MTA Subway Turnstile Entry and Exit Counts for 2018

2018 data contains entry and exit values for individual control areas within the New York City subway system. The dataset is provided by data.ny.gov for archival purposes, as more detailed hourly ridership data is now available elsewhere. It includes columns for station, turnstile unit, line, and cumulative entry/exit counts.

Use Cases

• Analyze daily passenger flow patterns by aggregating the `Entries` and `Exits` columns per `Station` and `Date`.
• Model turnstile-level usage by joining data on `C/A`, `Unit`, and `SCP` identifiers to track specific device activity.
• Compare ridership across different `Division` or `Line Name` using the cumulative entry/exit metrics.
• Investigate temporal ridership trends by processing the `Time` and `Date` fields alongside entry/exit deltas.

Strengths

• Archival data for a full calendar year (2018).
• Includes granular data at the control area (`C/A`) and device (`SCP`) level.
• Provides multiple file format options (CSV, JSON, XML, RDF).

Limitations

• Dataset is retired and flagged for archival use only, indicating potential staleness.
• Exact row count and data completeness are unknown.
• May require significant processing to calculate net entries/exits from cumulative counts.

Provenance

Source

data.ny.gov

Collection Method

Collected from Metropolitan Transportation Authority (MTA) subway turnstile systems.

Time Range

2018

Freshness

Last updated metadata indicates 2024-07-29, but the underlying data is from 2018.

Geography

New York City, USA, specifically MTA subway stations.