Skip to content

Latest commit

 

History

History
17 lines (11 loc) · 953 Bytes

Readme.md

File metadata and controls

17 lines (11 loc) · 953 Bytes

Sandy 311 Calls

Raw data behind the story The (Very) Long Tail Of Hurricane Recovery.

Data was collected from the NYC OpenData website. The data dictionary, hosted on the city's website, contains an "Agency List" tab with the full form of each agency's acronym.

You can recreate this spreadsheet by downloading all the data from Oct. 2012 to today from that site (warning: it's very large), and running the following R code:

allCalls <- read.csv('DOWNLOADED_DATA_HERE')

justSandy <- allCalls[grepl("Sandy", allCalls$BRIEF_DESCRIPTION),]

library(reshape2)
justSandy$date <- mdy(justSandy$DATE)
bydate <- dcast(justSandy, date ~ AGENCY)