CSV File Format

Session 3, #3: CSV File Format

We used the USGS data stored in CSV format. CSV stands for comma separated values:

Each row of the spreadsheet is stored in a separate line of the file.
The values of each column are separated by commas.

Here are a couple of lines of a CSV file from January 17, 2017:

time,latitude,longitude,depth,mag,magType,nst,gap,dmin,rms,net,id,updated,place,type,horizontalError,depthError,magError,magNst,status,locationSource,magSource
2017-01-17T11:48:48.530Z,5.4319,94.6079,54.55,5.6,mb,,67,2.338,1,us,us10007tps,2017-01-17T12:14:46.732Z,"80km W of Banda Aceh, Indonesia",earthquake,7.4,5.8,0.045,173,reviewed,us,us
2017-01-17T10:41:14.950Z,29.6,51.497,10,4.8,mb,,122,6.247,0.97,us,us10007tpm,2017-01-17T11:35:39.040Z,"15km W of Kazerun, Iran",earthquake,9.4,1.9,0.07,63,reviewed,us,us
2017-01-17T09:22:02.520Z,-56.8549,-26.0493,91.68,5.1,mb,,219,17.254,0.75,us,us10007tmm,2017-01-17T09:40:37.040Z,"72km ESE of Visokoi Island, South Georgia and the South Sandwich Islands",earthquake,20.9,12.9,0.108,28,reviewed,us,us

The first line has the column names. The next lines have the data for each observation, separated by commas. The first entry on each line is the time that the earthquake occurred. The next is the latitude, followed by the longitude, and the depth and magnitude. If we continue, almost at the very end (13 commas from the start of the line), there is the description, in words, of the location.

Challenge:
• We plotted the first three earthquakes in the previous challenge. What are the longitude and latitude of the next three earthquake observations?
• Mark these locations on the world map below: