CSV data seems the format the most versatile to export data from an HTML table, a spreadsheet or a SQL table.
For example we could have:
```
Timestamp,Name,Age
4/11/2013,Raymond Herisse,22
4/11/2013,Gil Collar,18
4/12/2013,Stanley LaVon Gibson,43
```
If we convert this CSV into a JSON document, we'll be able:
* to store it in MongoDB database
* to make the API able to use it, allowing to query a dataset
The plan is to:
* extract the columns' titles as identifiers
* create an array of objets
* each object has properties matching the columns' titles
For example, our CSV should be converted into this:
```
[
{
"Timestamp": "4/11/2013",
"Name": "Raymond Herisse",
"Age": 22
},
{
"Timestamp": "4/11/2013",
"Name": "Gil Collar",
"Age": 18
},
{
"Timestamp": "4/12/2013",
"Name": "Stanley LaVon Gibson",
"Age": 43
}
]
```
______________
Here some testable not nice data. We could extract the columnns' fields and get camel case expressions for them. 's could be discard, () ignored, a number appended if several fields have the same identifier.
```
Timestamp,Subject's name,Subject's age,Subject's gender,Subject's race,URL of image of deceased,Date of injury resulting in death (month/day/year),Location of injury (address),Location of death (city),Location of death (state),Location of death (zip code),Location of death (county),Agency responsible for death,Cause of death,A brief description of the circumstances surrounding the death,Official disposition of death (justified or other),Link to news article or photo of official document,Symptoms of mental illness?,Source/Submitted by,Email address,Date&Description,,Unique identifier
4/11/2013,Raymond Herisse,22,Male,African-American/Black,http://graphics8.nytimes.com/images/2013/08/04/us/MIAMI/MIAMI-popup.jpg,"May 30, 2011",18th Street and Collins Avenue,"South Beach, Miami Beach, Florida",FL,33139,Miami-Dade,Miami Beach Police Department,Gunshot,Police tried to stop Herisse’s speeding four-door Hyundai as it barreled down a crowded Collins Avenue.,justified,http://www.miamiherald.com/2013/04/10/3336557/lab-report-man-slain-in-wild-sobe.html#storylink=cpy,Unknown,Burghart,,5/30/2011: Police tried to stop Herisse’s speeding four-door Hyundai as it barreled down a crowded Collins Avenue. http://www.miamiherald.com/2013/04/10/3336557/lab-report-man-slain-in-wild-sobe.html#storylink=cpy,,1.1
```
Expected column identifiers:
```
Timestamp
SubjectName
SubjectAge
SubjectGender
SubjectRace
URLOfImageDeceased
DateOfInjuryResultingInDeath
LocationOfInjury
LocationOfDeath1
LocationOfDeath2
LocationOfDeath3
[...]
```