...
| Sl. No. | Database Column Name | JSON Metadata Field Name | Field Description | Remarks |
|---|---|---|---|---|
| 1 | id | loc_id | LOC Index | String; |
| 2 | name | creator_nameCreator | Creator name loosely in the format: <last name>, <first name>, <birth year> - <death year>. One or all of these sub parts could be missing. If the creator name is blank the value is NULL. | String; |
| 3 | year_mon | year_monYear | Year and month (abbreviated in certain cases) in which the photograph was taken in the format : <year> - <month | month1 - month2 | season >(null if not available). | String; Some year - month values are like '[between 1940 and 1946]'; The format mentioned in the left cell may not be strictly followed. Need to look into this in detail when doing the transformation. |
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
// Input CSV Data: fsa1997018591#Shahn, Ben, 1898-1969#1938 Aug.
{
"loc_id": "fsa1997018591",
"creator_nameCreator": "Shahn, Ben, 1898-1969",
"year_monYear": "1938 Aug."
} |
FacesInfo
...
| Sl. No. | Database Column Name | JSON Metadata Field Name | Field Description | Remarks |
|---|---|---|---|---|
| 1 | id | loc_id | LOC Index | String; |
| 2 | lat | latitude | Latitude coordinate | Float; |
| 3 | long | longitude | Longitude coordinate | Float; |
| 4 | statestate | State | Abbreviation or state name (if abbreviation not found) or "United States" if no. Other country names are kept as it is. | String; |
| 5 | city | city | City name, when available | String; |
| 6 | county | county | County name, when available (this value is mostly unavailable) | String; |
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
// Input CSV Data: fsa1997018591#40.106639#-83.767142#OH#Urbana#nop
{
"loc_id": "fsa1997018591",
"latitude": 40.106639,
"longitude": -83.767142,
"stateState": "OH",
"city": "Urbana",
"county": null
} |
...