Updated

Sandy 311 Calls

API Access

Access dataset files directly from scripts, code, or AI agents.

Browse dataset files
Dataset Files

Each file has a stable URL (r-link) that you can use directly in scripts, apps, or AI agents. These URLs are permanent and safe to hardcode.

/fivethirtyeight/sandy-311-calls/
https://datahub.io/fivethirtyeight/sandy-311-calls/_r/-/README.md
https://datahub.io/fivethirtyeight/sandy-311-calls/_r/-/data/sandy-311-calls-by-day.csv
https://datahub.io/fivethirtyeight/sandy-311-calls/_r/-/datapackage.json
Key Files

Start with these files — they give you everything you need to understand and access the dataset.

datapackage.jsonmetadata & schema
https://datahub.io/fivethirtyeight/sandy-311-calls/_r/-/datapackage.json
README.mddocumentation
https://datahub.io/fivethirtyeight/sandy-311-calls/_r/-/README.md
Typical Usage
  1. 1. Fetch datapackage.json to inspect schema and resources
  2. 2. Download data resources listed in datapackage.json
  3. 3. Read README.md for full context

Data Previews

sandy-311-calls-by-day

Loading data...

Schema

nametypeformat
datestringdefault
nyc-3-1-1integerdefault
acsintegerdefault
bpsiintegerdefault
cauintegerdefault
challintegerdefault
depintegerdefault
dobintegerdefault
doeintegerdefault
dofintegerdefault
dohmhintegerdefault
dprintegerdefault
femaintegerdefault
hpdintegerdefault
hraintegerdefault
mfanycintegerdefault
moseintegerdefault
nycemintegerdefault
nychaintegerdefault
nycserviceintegerdefault
nypdintegerdefault
nysdolintegerdefault
sbsintegerdefault
nysemergencymgintegerdefault
totalintegerdefault

Data Files

FileDescriptionSizeLast modifiedDownload
sandy-311-calls-by-day
101 kB17 days ago
sandy-311-calls-by-day
FilesSizeFormatCreatedUpdatedLicenseSource
1101 kBcsv17 days agoFiveThirtyEight - Sandy 311 Calls

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