SparkyData

Data

The data behind our articles about New York City, to download, check and reuse. Each dataset is named for what it holds, says first whether its records are counts, survey microdata or synthetic, and keeps the government's records apart from what we added.

Data is CC BY 4.0 where we made it; the government's records stay under their publishers' terms, and the analysis code is MIT (licensing).

Joined datasets

Several public sources combined into something not published elsewhere in one place, with a dictionary of every column, what is observed and what is estimated, and every source with its checksum.

  • NYC Subway Crime Rates and Ridership, 1998–2026

    Administrative records 25 files version 2.0, 2026-10-19

    This dataset pairs complaints recorded in the New York City subway by the New York City Police Department (NYPD), January 2014 to June 2026, with ridership from the Metropolitan Transportation Authority (MTA), so that complaint counts can be compared as rates per million paid rides and per million estimated entries, paid or not. The complaint files cover months, days, hours, stations and victim groups, and subway_complaint_records.csv has one row per complaint, with categorical fields and gaps kept from the source. A separate series covers major felonies across the transit system back to fiscal 1998. Start with subway_crime_monthly.csv: one row per month, with counts, rides and rates already combined.

    Built for Per subway ride, major felonies fell for thirty years. Felony assault broke from the fall.

Families

Housing

Population

Public safety

Transport

Work and pay