Sandy 311 Calls

FilesSizeFormatCreatedUpdatedLicenseSource
1csvFiveThirtyEight - Sandy 311 Calls

This folder contains 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 a...

Read more

Data Files

FileDescriptionSizeLast modifiedDownload
sandy-311-calls-by-day
sandy-311-calls-by-day

Data Previews

sandy-311-calls-by-day


Sandy 311 Calls

This folder contains 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)

This dataset was scraped from FiveThirtyEight - sandy-311-calls

© 2024 All rights reserved

Built with DataHub LogoDataHub Cloud