...
| Sl. No. | Database Column Name | Field Description | Remarks |
|---|---|---|---|
| 1 | id | LOC Index | String; |
| 2 | name | Creator name in the format: <last name>, <first name>, <birth year> - <death year>. If the creator name is blank the value is NULL. | String; |
| 3 | year_mon | Year and month (abbreviated in certain cases) in which the photograph was taken in the format: <year> - <month | month1 - month2 | season > | String; Some year - month values are like '[between 1940 and 1946]'; The format mentioned in the left column cell may not be strictly followed. Need to look into this in detail when doing the transformation. |
...