SparkyData

NYC Commute Times: Census Microdata on Resident Workers

Public-use microdata from the article “The hour-plus commute”

Not synthetic. Disclosure-protected survey records published by a government statistical agency, cut to the people or households we looked at.

Records
Public-use microdata
Place
New York City
Version
1.13,
Licence
CC BY 4.0; code MIT
Built for
The hour-plus commute (version 1.13)

The hour-long commute in New York is a matter of address and vehicle far more than pay. A quarter of the city's commuters spend an hour or more each way, mostly subway and bus riders from the outer boroughs; about half the racial gap remains after adjusting for where people live, travel and work; the pattern has held since 1990, and nothing in the MTA's 2026 figures says the trip got quicker.

The article's own data file, microdata cut to what it analyses, and the script that computes every figure in it. Computed from: ACS 2020–2024 five-year PUMS, NYC resident workers, with the 2024 one-year file for the reproduction; Census 1990 and 2000 5% PUMS and ACS 2005–2024 one-year PUMS for the series; MTA daily ridership to 30 September 2026; MTA bus speeds and subway customer journey metrics to August 2026.

Files

FileRowsSizeWhat it holds
data.csv 151,386 23.5 MB The microdata the article's figures are computed from.
analysis.py 56 KB The script that computes every figure in the article (MIT).

Columns

data.csv: The data (22 columns)

row_id, weight, borough, worked_from_home, mode, mode_group, one_way_minutes, hour_plus, ninety_plus, place_of_work, works_in_manhattan, own_earnings_2024, earnings_band, race_ethnicity, foreign_born, bachelors_or_higher, occupation_group, usual_hours, leaves_before_6am, departure_code, age, sex. The article and its script define each one.

Sources

Licence and credit

The survey records are the publishing agency's, redistributed as published; the columns we derived are CC BY 4.0; the script is MIT. Public-use microdata are disclosure-protected records derived from survey responses, published by the issuing agency so that no respondent can be identified; synthetic records are generated by SparkyData and correspond to no real person, household or address. Neither may be used to identify anyone.

Credit it as:

SparkyData (2026). NYC Commute Times: Census Microdata on Resident Workers (version 1.13). Data CC BY 4.0.
https://sparkydata.dev/data/nyc-commute-times-census-microdata

The article gives the charts, the uncertainty of each comparison and a changelog. Corrections and questions: sparkytech.dev@gmail.com, or see corrections.