Skip to content

Intraday ridership data from Washington Metro Area Transit Authority for 2009 and 2017 inaugurations and the Women's March.

Notifications You must be signed in to change notification settings

BloombergGraphics/2017-wmata-ridership-data

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

2 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

WMATA Ridership Data

Intraday ridership data from Washington Metro Area Transit Authority for 2009 and 2017 inaugurations and the Women's March.

Entrance data

Description

On Jan. 23, 2017, we filed a request under WMATA's Public Access to Records Policy for Metrorail station hourly entrance and exit data for Obama's inauguration on Jan. 20, 2009, Trump's inauguration on Jan. 20, 2017, and the Women's March on Jan. 21, 2017.

On Feb. 2, 2017, we received data for those days broken down into five time periods:

  • AM Peak: Station Opening to 9:30 AM.
  • Mid-day: 9:30 AM – 3:00 PM.
  • PM Peak: 3:00 PM- 7:00 PM.
  • Evening: 7:00 PM to Station Closing.

Files

The data was provided to us in two PDFs:

  • [PARP 17-0016 Inauguration Records.pdf](ridership-data/PARP 17-0016 Inauguration Records.pdf)
  • [PARP 17-0016 Women-s March Record.pdf](ridership-data/PARP 17-0016 Women-s March Record.pdf)

We used Tabula to turn these PDFs into spreadsheet data. One of the pages in PARP 17-0016 Inauguration Records.pdf was not convertible so we used ABBYY for that page. The data with minor post-OCR clean up is here:

We did the following cleaning to make this data easier to use. See Jupyter Notebook for more details.

  • Combine station data from the three speadsheets into one
  • Removed commas from numeric entries
  • Split event event_date column into two columns date and day
  • Added event_name column
  • Merged station names like Brookland-CU with Brookland/CUA and U Street-Cardozo with U Street/Cardozo
  • Split out SYSTEMWIDE TOTALS data into into its own spreadsheet
  • Verified row totals

The two cleaned speadsheets (station data and system-wide totals) can be found here:

Why are exits lower than entrances?

From WMATA press office:

To safely manage crowds during periods of high volume, Metro staff occasionally opened faregates, allowing customers to exit the system faster without processing fare media. (In these cases, the cards are reset and fares are charged as a batch process.) The “entry” number is what is used for official ridership stats.

Other files

If you want to make a map of this data, you might find these shapefiles helpful.

Disclaimer

We have done our best to verify the that the CSV data matches the PDF data including checking sums and manually comparing each row. However, errors may persist. Do your own checking to ensure its integrity. If you find any errors, please file an issue.

Attribution

PDFs should be cited as WMATA data obtained by Bloomberg News.

The provided CSV files should be cited as Bloomberg News analysis of WMATA data.

About

Intraday ridership data from Washington Metro Area Transit Authority for 2009 and 2017 inaugurations and the Women's March.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published