Sandy 311 Calls

•

Files	Size	Format	Created	Updated	License	Source
1	101 kB	csv		over 6 years ago		FiveThirtyEight - 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...

File	Description	Size	Last modified	Download
sandy-311-calls-by-day		101 kB	over 6 years ago	sandy-311-calls-by-day

Data Previews

sandy-311-calls-by-day

Schema

name	type	format
date	string	default
nyc-3-1-1	integer	default
acs	integer	default
bpsi	integer	default
cau	integer	default
chall	integer	default
dep	integer	default
dob	integer	default
doe	integer	default
dof	integer	default
dohmh	integer	default
dpr	integer	default
fema	integer	default
hpd	integer	default
hra	integer	default
mfanyc	integer	default
mose	integer	default
nycem	integer	default
nycha	integer	default
nycservice	integer	default
nypd	integer	default
nysdol	integer	default
sbs	integer	default
nysemergencymg	integer	default
total	integer	default

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

Data Files

Data Previews

sandy-311-calls-by-day

Schema

Sandy 311 Calls