New York Times Web APIs

Geographic API

http://developer.nytimes.com/docs/geographic_api

============================================================

Libraries required

#require(devtools) for rtimes tool installation
#devtools::install_github("ropengov/rtimes") for rtimes tool installation
library("rtimes")
require(dplyr)

============================================================

Configuring the API, searching for New Zealand records, and then converting to data frame.

Sys.setenv(NYTIMES_GEO_KEY = "39687aa1836661da666a63e6c621e314:19:74828098")
results<-geo_search(country_code = 'NZ')
resultsDF<-do.call(rbind.data.frame, results$data)
resultsDFTransposed<-data.frame(t(resultsDF))
rownames(resultsDFTransposed) <- NULL

============================================================

Checking to see if properly formatted.

is.data.frame(resultsDFTransposed)
## [1] TRUE
glimpse(resultsDFTransposed)
## Observations: 10
## Variables: 27
## $ concept_id        (fctr) 27524, 22932, 24680, 28492, 28696, 30116, 3...
## $ concept_name      (fctr) New Zealand, Auckland (New Zealand), Dunedi...
## $ geocode_id        (fctr) 592, 4492, 6392, 7140, 7200, 7500, 7540, 76...
## $ geoname_id        (fctr) 2186224, 2193734, 2191562, 6204696, 2183232...
## $ name              (fctr) New Zealand, Auckland, Dunedin, Queenstown,...
## $ latitude          (fctr) -42, -36.85, -45.874159, -45.030226, -38.15...
## $ longitude         (fctr) 174, 174.783333, 170.503612, 168.66271, 176...
## $ elevation         (fctr) NA, NA, NA, NA, NA, NA, NA, NA, NA, NA
## $ population        (fctr) 4154000, NA, 114347, 10442, NA, NA, 381900,...
## $ country_code      (fctr) NZ, NZ, NZ, NZ, NZ, NZ, NZ, NZ, NZ, NZ
## $ country_name      (fctr) New Zealand, New Zealand, New Zealand, New ...
## $ admin_code1       (fctr) 00, E7, F7, F7, 00, 00, G2, F6, E9, E9
## $ admin_code2       (fctr) NA, NA, NA, NA, NA, NA, NA, NA, NA, 060
## $ admin_code3       (fctr) NA, NA, NA, NA, NA, NA, NA, NA, NA, NA
## $ admin_code4       (fctr) NA, NA, NA, NA, NA, NA, NA, NA, NA, NA
## $ admin_name1       (fctr) NA, Auckland, Otago, Otago, NA, NA, Welling...
## $ admin_name2       (fctr) NA, NA, NA, NA, NA, NA, NA, NA, NA, Christc...
## $ admin_name3       (fctr) NA, NA, NA, NA, NA, NA, NA, NA, NA, NA
## $ admin_name4       (fctr) NA, NA, NA, NA, NA, NA, NA, NA, NA, NA
## $ feature_class     (fctr) A, A, P, P, A, T, P, A, P, P
## $ feature_code      (fctr) PCLI, ADM1, PPLA, PPL, ADMD, ISL, PPLC, ADM...
## $ feature_code_name (fctr) independent political entity, first-order a...
## $ time_zone_id      (fctr) Pacific/Auckland, Pacific/Auckland, Pacific...
## $ dst_offset        (fctr) 12, 12, 12, 12, 12, 12, 12, 12, 12, 12
## $ gmt_offset        (fctr) 13, 13, 13, 13, 13, 13, 13, 13, 13, 13
## $ geocodes_created  (fctr) 2013-02-25 15:10:12, 2013-02-25 15:10:12, 2...
## $ geocodes_updated  (fctr) 2013-02-25 15:10:12, 2013-02-25 15:10:12, 2...