search

Chicago / RSocrata

Provides easier interaction with Socrata open data portals http://dev.socrata.com. Users can provide a 'Socrata' data set resource URL, or a 'Socrata' Open Data API (SoDA) web query, or a 'Socrata' "human-friendly" URL, returns an R data frame. Converts dates to 'POSIX' format. Manages throttling by 'Socrata'.
https://CRAN.R-project.org/package=RSocrata
Other
233 stars 84 forks source link

"NA" in Dates Column #68

Closed RPavuluri closed 8 years ago

RPavuluri commented 8 years ago

I ran the following in RScript:

health_FOIA <- read.socrata("https://data.cityofchicago.org/resource/4h87-zdcp.csv").

I then printed health_FOIA$DATE.RECEIVED and got NA for each entry. This is odd because there are dates in the online portal. It is also odd because I don't get NULL, which happens when I print health_FOIA$DATE.RECEIVEDS (incorrect spelling of column heading).

When I print health_FOIA$DESCRIPTION.OF.REQUEST, however, I get a vector populated with the correct information.

I have the same problem with the Business Affairs and Consumer Protection, Chicago Police Board, Fire, Ethics, Law, Human Resources, and Aviation FOIA Logs.

Any thoughts?

geneorama commented 8 years ago

I'm having the same issue with the Sanitation data set

sanitationComplaints <- read.socrata("https://data.cityofchicago.org/resource/me59-5fac.csv")
table(is.na(sanitationComplaints$Creation.Date))
# TRUE 
# 95360

image