Posts Tagged ‘data download’

Rail Ridership Data to Help the Region Plan for SafeTrack

May 27th, 2016 3 comments

To help the region and our partners plan alternatives and mitigate the impacts of SafeTrack, Metro releases rail ridership data applicable to this important maintenance effort.

SafeTrack example 2Rail Link Volumes: This data describes the number of customers on board trains between two contiguous stations, for a given hour of the day, then assigned to rail links.  For example, the link volume from Bethesda to Friendship Heights is the sum of everyone who boarded upstream, minus those who exited at or before Bethesda. This can be useful for planning SafeTrack mitigation efforts because it gives a first-order estimate of the potential demand for a bus bridge, for example.

Online Interactive Map of Metrorail Link Volumes, average weekday and Saturday in May 2015

Metrorail Link volumes, average weekday in May 2015, by hour, by line color (580kb, .xlsx)

Read more…

Data Download: Metrorail Ridership by Station by Month, 2010-2015

March 24th, 2016 6 comments

Data_clipSee how seasons, land use, and service drive trends in rail ridership at the station level, in this new data download.

This latest data download shows Metrorail ridership by station, by month, for the last five years or so. It hints at the complex factors driving rail ridership – from short-term effects like weather or service changes, to long-term trends like real estate development and office relocations.

We see a few tidbits in this data:

  • Seasonal trends: rail ridership follows a predictable pattern each year – peaking in the summer and around Cherry Blossoms, and reaching lows around the holidays.  Compare the high seasonality of Arlington Cemetery to a more commuter-oriented station, for example.  Ridership in the summer at that station can quintuple over its winter base.
  • Weather impacts: see how the blizzard this past January lowered the average for the month as service was shut down.
  • Service changes: See how the opening of the Silver Line shifted riders from Orange to Silver in July-August 2014.
  • Land Use is key! Look at the recent growth rates at stations like Navy Yard and NoMa (formerly New York Ave.), reflecting the new jobs and residences near those stations.

Metrorail Ridership, by Station by Month, 2010-2015, Average Weekday (.xlsx, 120kb)

Metrorail Ridership, by Station by Month by Period, 2010-2015, Average Weekday (.xlsx, 630kb) (Added 3/30/2016)

Notes: these numbers are raw entries for an average weekday in the month, including snow days, excluding holidays when we did not run a weekday schedule.  The numbers are for trend analysis and will differ slightly from those we report in financial statements, which undergo additional data scrubbing and normalization.

What do trends you see?

Metrorail Ridership Data Download, October 2015

March 14th, 2016 8 comments

New data download features rail ridership by origin, destination, day of week, and quarter-hour intervals.

ridership_plots_subset

Subset of the visualization made by BioNrd aka Mike from our October 2014 data download data.

As you’ve probably noticed, it’s been a while since we’ve released a fresh batch of Metrorail ridership data.  Continuing the spirit of openness, we have recently uploaded data from October 2015 in CSV format.  (The number of rows is too great for Microsoft Excel).

This new dataset includes day of week data, so you can begin to investigate impacts of evolving workplace policies such as compressed work schedules.  You can also compare it to October 2014.

In the past, we have seen a lot of innovative analyses of the data we share.  Perhaps the best so far was a visualization of Metrorail station entries and exits by station by “BioNrd” aka “Mike.” What else can we learn from this dataset?

 

How Do Marylanders Use Metro?

February 2nd, 2016 2 comments

We analyzed Metrorail, Metrobus, and MetroAccess ridership for all Maryland residents in response to the Maryland Legislature’s data and analysis request. Newsflash – we have customers from across the state!

Origins of Maryland Rail Riders

Origins of Maryland Rail Riders

In the 2015 legislative session, the Maryland General Assembly passed the WMATA Utilization Study (HB300),which required the Maryland Department of Transportation (MDOT) and WMATA to analyze the utilization of Metrorail, Metrobus, and MetroAccess every five years. This year’s analysis is based on the most recent Metrorail passenger survey (2012), Metrobus passenger survey (2014), and actual ridership for MetroAccess for an average day in April 2015. Below are some findings that I found most interesting. But more importantly, here is the complete 2015 Maryland HB300 WMATA Utilization Study (native pdf), which includes all the links to the underlying survey data, interactive charts, and analysis.

  • 82 percent of Metrorail trips by Montgomery County residents are destined for Washington DC in the morning on a typical weekday;
  • 71 percent of Metrobus trips in the AM peak period made by Prince George’s County residents are for work purposes on a typical weekday;
  • 3.3 percent of all trips across all Metro services on a typical weekday are taken by Maryland residents from Frederick, Charles, Calvert, Howard, Anne Arundel, and Baltimore Counties and Baltimore City;
  • 35 percent of other Maryland residents on Metrorail access via commuter rail (MARC) and Amtrak; and
  • 17,600 residents of the District and Virginia reverse-commute into Maryland on Metrorail and bus each morning on a typical weekday (about 5 percent of total system ridership)

Any other nuggets that you found from analyzing the data? Ideas for other ways to graphically represent the findings?

Three Tidbits: What The Metrobus 2014 Survey Can Tell Us

October 26th, 2015 7 comments

The latest survey of Metrobus riders is a gold mine of information about who our bus riders are, why they travel, and more. Here are the answers to just three questions:

Who’s on the Bus on 16th St. NW? Metro planners and DC residents alike have advocated for a possible bus lane on 16th St. NW, where Metrobuses carry over 50% of the people, are scheduled for about every two minutes, and are frequently bunched and overcrowded. The survey can tell us what kinds of riders use that corridor – giving us clues to what kind of new riders a bus lane might attract.

S-Line Ridership by Juris of Residence

 S-Line demogs

Survey says:

  • Three quarters of S-Line (S1, S2, S4, and S9 combined) riders live in D.C., while the rest hail primarily from Montgomery County
  • S-Line riders are younger and more affluent, than the system-wide average for bus riders.
  • They are slightly more likely to be car-free and employed by the federal government, but the difference is very small.

Read more…

Metrorail Rider Incomes – A Closer Look

June 29th, 2015 5 comments

Salaries of actual riders are needed to paint a true picture of Metrorail ridership by line.

The Washington Post recently featured a series of images from the You Are Here project of the Social Computing Group at MIT showing Metrorail median income by line and station.  We were digging into it and realized it uses median household income within a half-mile radius, and not that of the actual riders’ households.  While we’ve mapped low-income riders before, we set out to answer the question, “What is the actual average income of Metrorail riders by line and station?”   Along the way, we developed this interactive data visualization.

dashboard

Screenshot of Metrorail rider income by station visualization. Click image for full interactive version.

The biggest overall difference between our work and that of the MIT group is higher  household incomes at end-of-line stations on the eastern side of the region.  These stations, while located in lower income areas, have large parking facilities that draw commuters from all over the region and beyond. Read more…

Metrorail Data Download, October 2014

January 26th, 2015 26 comments

This new data download from October 2014 includes ridership from the five new Silver Line stations.

Over the past few years we’ve been making ridership data available for download and analysis by the online community.  We have received some requests for full origin-destination (O/D) data sets that include the new Silver Line ridership.

These data sets include ridership from October of 2014, and are available by period (AM Peak, midday, etc.) or by quarter-hour interval, for all stations including the five new Silver Line stations.  Both sets include daily averages for weekdays, Saturdays, Sundays and Columbus Day.

Note, the quarter-hour data file is to big to open in Microsoft Excel.

Have fun playing around with this data and let us know in the comments what you find.  Make sure you check out  the other assessments of Silver Line ridership  we’ve done.

Jan 29, 2015, 10:00 AM Update:  Files have been updated to include total and average travel times for each station pair.

Feb 02, 2015, 11:00 AM Update:  Files have been updated to separate Columbus Day from Saturdays using a new column “Holiday”.

 

 

 

Data Download: May 2013-2014 Metrorail Ridership by Origin and Destination

August 28th, 2014 22 comments

DataDownloadFuzzyMay 2013 and 2014 Metrorail ridership data is available: what patterns do you see?

Following up on our last data download of rail ridership from May 2012, 2013 and 2014 are now available. These data now represent three “snapshots” in time of rail ridership, at a very fine level of detail.  This data can help answer questions, such as: where is ridership growth the strongest? Which destinations are becoming more or less popular?  How has off-peak vs. peak ridership changed? 

May 2013 Metrorail Ridership by Origin, Destination, TimePeriod, DayOfWeek (.xlsx, 3.3 MB)

May 2014 Metrorail Ridership by Origin, Destination, TimePeriod, DayOfWeek (.xlsx, 3.4 MB)

We invite you to tell us what you see, in the comments.

Technical notes on the data are the same as the last post.  This time, Saturdays and Sundays are shown in the same worksheet as weekdays.

Ridership Increases Expected for Cherry Blossom Festival

February 27th, 2014 2 comments

During the National Cherry Blossom Festival, Metrorail ridership increases on average by 7% on weekdays  and 50% on Saturdays. 

Metrorail ridership is impacted by a variety of factors, from special events to weather to government shutdowns.  One event that brings visitors to the region — and to Metrorail — in droves is the annual National Cherry Blossom Festival.   In anticipation of this year’s festival, we performed some analysis on how, when and where the blossom viewers impacted ridership on the Metrorail system.

In general, Metrorail ridership increases on average by 7% on weekdays and up to 53% on Saturdays during the festival.  On days with nice weather, ridership has increased up to 10% on weekdays and 70% on Saturdays!

As the figure below shows, during the weekdays there is no impact in the morning, a large (21%) increase of activity during the mid day and then a 7% increase thereafter.

Saturdays are another story all together.  Ridership increases up to 63% during mid day and afternoon periods on days during the festival, with a total ridership increase above 50%.  Even morning and “late” night ridership increases significantly during this period.

Cherry-Chart-Weekday-Saturday-w-Chart-2

Metrorail system entries by quarter-hour interval, Regular Weekday, Cherry Blossom Weekday, Regular Saturday and Cherry Blossom Saturday. Click chart for larger version.

 

When looking at change in ridership by station in the maps below, some obvious conclusions can be drawn. Read more…

What Will the Travel Times Be on the Silver Line?

September 20th, 2013 26 comments

The stations on the new Silver Line are two minutes apart in the Tysons area, and the Tysons-area stations are eight minutes away from both East Falls Church and Wiehle-Reston East.

Silver-Line-Travel-Times

Draft travel times for the new Silver Line stations.

Earlier this year we published a series of posts about the region’s newest rail line, the Silver Line, due to begin service in early 2014. Those posts included answering the questions, “Where will it go?“, “What will happen to rail schedules?“, and “What will happen to bus schedules?“.

Now it’s time to talk about preliminary travel times between Silver Line stations. The map above illustrates the estimated travel times between the five new stations. These times are preliminary and may be refined after operational testing has been completed.

Below is a widget that can be used to look up the travel times between any two stations, including the five new Silver Line stations.*

Read more…