library(httr)## Warning: package 'httr' was built under R version 3.2.3library(jsonlite)## Warning: package 'jsonlite' was built under R version 3.2.3library(stringr)j = fromJSON("http://api.nytimes.com/svc/semantic/v2/geocodes/query.json?feature_class=S&api-key=8362b50c62d211ae15667045551ac95d:5:74819770")
n = nrow(j$results)
c = colnames(j$results)
c = str_replace_all(c, "_", " ")
j## $status
## [1] "OK"
##
## $copyright
## [1] "Copyright (c) 2015 The New York Times Company. All Rights Reserved."
##
## $num_results
## [1] 17
##
## $results
## concept_id concept_name geocode_id geoname_id
## 1 22988 Babylon (Iraq) 1924 98228
## 2 25000 Flatiron District (NYC) 3172 6944373
## 3 28288 Pompeii (Italy) 3284 3170336
## 4 25052 Fort Drum (NY) 3404 6298323
## 5 26732 Machu Picchu (Peru) 3752 3935634
## 6 30444 Zion National Park (Utah) 4592 5550115
## 7 26252 Kish (Iran) 5848 6300043
## 8 22820 Arezzo (Italy) 6012 6299603
## 9 24820 Epidaurus (Greece) 6416 262661
## 10 25068 Fort Monroe (Va) 6452 6940416
## 11 26536 Leptis Magna (Libya) 6792 2215692
## 12 28548 Red Square (Moscow) 7156 6956705
## 13 29972 Vandenberg Air Force Base (Calif) 7460 6301743
## 14 22544 Akihabara (Tokyo) 7764 1865441
## 15 68308 Three Mile Island (Pa) 7968 6332747
## 16 70532 Tahrir Square (Cairo) 7980 6955473
## 17 70364 Interstate 95 8008 4836859
## name latitude longitude
## 1 Babylon 32.54083 44.42417
## 2 Chelsea/Grammercy/Flatiron District 40.74720 -74.00000
## 3 Pompeii 40.75000 14.48333
## 4 Fort Drum / Wheeler-Sack U. S. Army Airfield 44.05562 -75.71946
## 5 Machu Picchu -13.16357 -72.54574
## 6 Zion National Park 37.29998 -113.05078
## 7 Kish Island / Kish 26.52616 53.98021
## 8 Arezzo 43.46667 11.85000
## 9 Epidaurus 37.63333 23.16667
## 10 Fort Monroe 37.00420 -76.30739
## 11 Leptis Magna 32.63167 14.31167
## 12 Red Square 55.75420 37.62000
## 13 Lompoc, Vandenberg Air Force Base 34.73733 -120.58431
## 14 Akihabara 35.70000 139.76667
## 15 Three Mile Island Nuclear Power Plant 40.15417 -76.72500
## 16 Tahrir Square 30.04533 31.23539
## 17 Interstate 95 Tourist Information Center 41.29066 -72.43148
## elevation population country_code country_name admin_code1 admin_code2
## 1 NA NA IQ Iraq 06 <NA>
## 2 NA NA US United States NY 061
## 3 NA NA IT Italy 04 <NA>
## 4 210 NA US United States NY <NA>
## 5 NA NA PE Peru 08 <NA>
## 6 1877 NA US United States UT 053
## 7 30 NA IR Iran <NA> <NA>
## 8 248 NA IT Italy <NA> <NA>
## 9 NA NA GR Greece <NA> <NA>
## 10 NA NA US United States VA 650
## 11 NA NA LY Libya 50 <NA>
## 12 NA NA RU Russia 47 <NA>
## 13 112 NA US United States CA <NA>
## 14 NA NA JP Japan 00 <NA>
## 15 93 NA US United States PA 043
## 16 NA NA EG Egypt 11 <NA>
## 17 34 NA US United States CT 007
## admin_code3 admin_code4 admin_name1 admin_name2
## 1 NA NA B%u0101bil <NA>
## 2 NA NA New York New York County
## 3 NA NA Campania <NA>
## 4 NA NA New York <NA>
## 5 NA NA Cusco <NA>
## 6 NA NA Utah Washington County
## 7 NA NA <NA> <NA>
## 8 NA NA <NA> <NA>
## 9 NA NA <NA> <NA>
## 10 NA NA Virginia City of Hampton
## 11 NA NA Al Khums <NA>
## 12 NA NA Moskovskaya Oblast' <NA>
## 13 NA NA California <NA>
## 14 NA NA <NA> <NA>
## 15 NA NA Pennsylvania Dauphin County
## 16 NA NA Al Q%u0101hirah <NA>
## 17 NA NA Connecticut Middlesex County
## admin_name3 admin_name4 feature_class feature_code
## 1 NA NA S RUIN
## 2 NA NA S RSTN
## 3 NA NA S ANS
## 4 NA NA S AIRP
## 5 NA NA S RUIN
## 6 NA NA S PO
## 7 NA NA S AIRP
## 8 NA NA S STNM
## 9 NA NA S RUIN
## 10 NA NA S FT
## 11 NA NA S RUIN
## 12 NA NA S SQR
## 13 NA NA S AIRB
## 14 NA NA S RSTN
## 15 NA NA S
## 16 NA NA S SQR
## 17 NA NA S BLDG
## feature_code_name time_zone_id dst_offset gmt_offset
## 1 ruin(s) Asia/Baghdad 3.0 3.0
## 2 railroad station America/New_York -4.0 -5.0
## 3 ancient site Europe/Rome 2.0 1.0
## 4 airport America/New_York -4.0 -5.0
## 5 ruin(s) America/Lima -5.0 -5.0
## 6 post office America/Shiprock -6.0 -7.0
## 7 airport Asia/Tehran 4.5 3.5
## 8 meteorological station Europe/Rome 2.0 1.0
## 9 ruin(s) Europe/Athens 3.0 2.0
## 10 fort America/New_York -4.0 -5.0
## 11 ruin(s) Africa/Tripoli 2.0 2.0
## 12 square Europe/Moscow 4.0 3.0
## 13 airbase America/Los_Angeles -7.0 -8.0
## 14 railroad station Asia/Tokyo 9.0 9.0
## 15 America/New_York -4.0 -5.0
## 16 square Africa/Cairo 3.0 2.0
## 17 building(s) America/New_York -4.0 -5.0
## geocodes_created geocodes_updated
## 1 2013-02-25 15:10:12 2013-02-25 15:10:12
## 2 2013-02-25 15:10:12 2013-02-25 15:10:12
## 3 2013-02-25 15:10:12 2013-02-25 15:10:12
## 4 2013-02-25 15:10:12 2013-02-25 15:10:12
## 5 2013-02-25 15:10:12 2013-02-25 15:10:12
## 6 2013-02-25 15:10:12 2013-02-25 15:10:12
## 7 2013-02-25 15:10:12 2013-02-25 15:10:12
## 8 2013-02-25 15:10:12 2013-02-25 15:10:12
## 9 2013-02-25 15:10:12 2013-02-25 15:10:12
## 10 2013-02-25 15:10:12 2013-02-25 15:10:12
## 11 2013-02-25 15:10:12 2013-02-25 15:10:12
## 12 2013-02-25 15:10:12 2013-02-25 15:10:12
## 13 2013-02-25 15:10:12 2013-02-25 15:10:12
## 14 2013-02-25 15:10:12 2013-02-25 15:10:12
## 15 2013-02-25 15:10:12 2013-02-25 15:10:12
## 16 2013-02-25 15:10:12 2013-02-25 15:10:12
## 17 2013-02-25 15:10:12 2013-02-25 15:10:12Now we try to make all the null readings consistent.
j = unlist(j$results, use.names = T)
j = str_replace_all(j, "<NA>", "NA")
j = matrix(j, nrow = n, byrow = F)
j = data.frame(j)
colnames(j) = c
j## concept id concept name geocode id geoname id
## 1 22988 Babylon (Iraq) 1924 98228
## 2 25000 Flatiron District (NYC) 3172 6944373
## 3 28288 Pompeii (Italy) 3284 3170336
## 4 25052 Fort Drum (NY) 3404 6298323
## 5 26732 Machu Picchu (Peru) 3752 3935634
## 6 30444 Zion National Park (Utah) 4592 5550115
## 7 26252 Kish (Iran) 5848 6300043
## 8 22820 Arezzo (Italy) 6012 6299603
## 9 24820 Epidaurus (Greece) 6416 262661
## 10 25068 Fort Monroe (Va) 6452 6940416
## 11 26536 Leptis Magna (Libya) 6792 2215692
## 12 28548 Red Square (Moscow) 7156 6956705
## 13 29972 Vandenberg Air Force Base (Calif) 7460 6301743
## 14 22544 Akihabara (Tokyo) 7764 1865441
## 15 68308 Three Mile Island (Pa) 7968 6332747
## 16 70532 Tahrir Square (Cairo) 7980 6955473
## 17 70364 Interstate 95 8008 4836859
## name latitude longitude
## 1 Babylon 32.540833 44.424167
## 2 Chelsea/Grammercy/Flatiron District 40.7472 -74
## 3 Pompeii 40.75 14.483333
## 4 Fort Drum / Wheeler-Sack U. S. Army Airfield 44.055619 -75.719458
## 5 Machu Picchu -13.16357 -72.545739
## 6 Zion National Park 37.299981 -113.050777
## 7 Kish Island / Kish 26.526156 53.980211
## 8 Arezzo 43.466667 11.85
## 9 Epidaurus 37.633333 23.166667
## 10 Fort Monroe 37.004198 -76.307387
## 11 Leptis Magna 32.631667 14.311667
## 12 Red Square 55.7542 37.62
## 13 Lompoc, Vandenberg Air Force Base 34.737333 -120.584306
## 14 Akihabara 35.7 139.766667
## 15 Three Mile Island Nuclear Power Plant 40.154167 -76.725
## 16 Tahrir Square 30.045331 31.235386
## 17 Interstate 95 Tourist Information Center 41.290655 -72.431476
## elevation population country code country name admin code1 admin code2
## 1 <NA> <NA> IQ Iraq 06 <NA>
## 2 <NA> <NA> US United States NY 061
## 3 <NA> <NA> IT Italy 04 <NA>
## 4 210 <NA> US United States NY <NA>
## 5 <NA> <NA> PE Peru 08 <NA>
## 6 1877 <NA> US United States UT 053
## 7 30 <NA> IR Iran <NA> <NA>
## 8 248 <NA> IT Italy <NA> <NA>
## 9 <NA> <NA> GR Greece <NA> <NA>
## 10 <NA> <NA> US United States VA 650
## 11 <NA> <NA> LY Libya 50 <NA>
## 12 <NA> <NA> RU Russia 47 <NA>
## 13 112 <NA> US United States CA <NA>
## 14 <NA> <NA> JP Japan 00 <NA>
## 15 93 <NA> US United States PA 043
## 16 <NA> <NA> EG Egypt 11 <NA>
## 17 34 <NA> US United States CT 007
## admin code3 admin code4 admin name1 admin name2
## 1 <NA> <NA> B%u0101bil <NA>
## 2 <NA> <NA> New York New York County
## 3 <NA> <NA> Campania <NA>
## 4 <NA> <NA> New York <NA>
## 5 <NA> <NA> Cusco <NA>
## 6 <NA> <NA> Utah Washington County
## 7 <NA> <NA> <NA> <NA>
## 8 <NA> <NA> <NA> <NA>
## 9 <NA> <NA> <NA> <NA>
## 10 <NA> <NA> Virginia City of Hampton
## 11 <NA> <NA> Al Khums <NA>
## 12 <NA> <NA> Moskovskaya Oblast' <NA>
## 13 <NA> <NA> California <NA>
## 14 <NA> <NA> <NA> <NA>
## 15 <NA> <NA> Pennsylvania Dauphin County
## 16 <NA> <NA> Al Q%u0101hirah <NA>
## 17 <NA> <NA> Connecticut Middlesex County
## admin name3 admin name4 feature class feature code
## 1 <NA> <NA> S RUIN
## 2 <NA> <NA> S RSTN
## 3 <NA> <NA> S ANS
## 4 <NA> <NA> S AIRP
## 5 <NA> <NA> S RUIN
## 6 <NA> <NA> S PO
## 7 <NA> <NA> S AIRP
## 8 <NA> <NA> S STNM
## 9 <NA> <NA> S RUIN
## 10 <NA> <NA> S FT
## 11 <NA> <NA> S RUIN
## 12 <NA> <NA> S SQR
## 13 <NA> <NA> S AIRB
## 14 <NA> <NA> S RSTN
## 15 <NA> <NA> S
## 16 <NA> <NA> S SQR
## 17 <NA> <NA> S BLDG
## feature code name time zone id dst offset gmt offset
## 1 ruin(s) Asia/Baghdad 3 3
## 2 railroad station America/New_York -4 -5
## 3 ancient site Europe/Rome 2 1
## 4 airport America/New_York -4 -5
## 5 ruin(s) America/Lima -5 -5
## 6 post office America/Shiprock -6 -7
## 7 airport Asia/Tehran 4.5 3.5
## 8 meteorological station Europe/Rome 2 1
## 9 ruin(s) Europe/Athens 3 2
## 10 fort America/New_York -4 -5
## 11 ruin(s) Africa/Tripoli 2 2
## 12 square Europe/Moscow 4 3
## 13 airbase America/Los_Angeles -7 -8
## 14 railroad station Asia/Tokyo 9 9
## 15 America/New_York -4 -5
## 16 square Africa/Cairo 3 2
## 17 building(s) America/New_York -4 -5
## geocodes created geocodes updated
## 1 2013-02-25 15:10:12 2013-02-25 15:10:12
## 2 2013-02-25 15:10:12 2013-02-25 15:10:12
## 3 2013-02-25 15:10:12 2013-02-25 15:10:12
## 4 2013-02-25 15:10:12 2013-02-25 15:10:12
## 5 2013-02-25 15:10:12 2013-02-25 15:10:12
## 6 2013-02-25 15:10:12 2013-02-25 15:10:12
## 7 2013-02-25 15:10:12 2013-02-25 15:10:12
## 8 2013-02-25 15:10:12 2013-02-25 15:10:12
## 9 2013-02-25 15:10:12 2013-02-25 15:10:12
## 10 2013-02-25 15:10:12 2013-02-25 15:10:12
## 11 2013-02-25 15:10:12 2013-02-25 15:10:12
## 12 2013-02-25 15:10:12 2013-02-25 15:10:12
## 13 2013-02-25 15:10:12 2013-02-25 15:10:12
## 14 2013-02-25 15:10:12 2013-02-25 15:10:12
## 15 2013-02-25 15:10:12 2013-02-25 15:10:12
## 16 2013-02-25 15:10:12 2013-02-25 15:10:12
## 17 2013-02-25 15:10:12 2013-02-25 15:10:12