bts-gov/docked-bikeshare-ridership-6cfa-ipzd
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 1 month ago
Indexed 4 hours ago

Docked Bikeshare Ridership

Historic data updated on 07/14/2023. Q4 of 2023 and data for all years on systems allowing parking outside of a docking station updated on 06/04/2024.

Bikeshare ridership by system for bikeshare systems with docking stations. Data summarized for each system by: (1) month, (2) day, and (3) hour. Data starting in January 2019. In monthly summary, months are rearranged to include the same number of days of the week across years (see below).

Ridership data not available for all docked bikeshare systems. Only docked bikeshare systems with ridership data shown. Some systems included in the data permit users to leave a bicycle outside of a docking station; these trips are indicated by the trip type. Trips defined as rides from point A to B. If user makes trip from B to A on same day, counted as a second trip. Trips labeled as round trips in Metro Bike Share and Indego trip files counted as 2 trips. Trips with no trip time are not counted. For trips starting and ending at a docking station or on systems where only docked trips are permitted, trips with no start station identifier and/or end station id are not counted in totals. Trips shorter than 1 minute or greater than 2 hours excluded. In monthly summary, days aligned to include the same days of weeks across years.

Days included in each month can be found in the attachments (https://data.bts.gov/api/views/6cfa-ipzd/files/36fde1b8-57c3-4d31-b9dc-bbc896ba346e?download=true&filename=days_included_in_docked_bikeshare_monthly_summaries.xlsx)

Data visualizations available at: https://data.bts.gov/stories/s/Summary-of-Docked-Bikeshare-Trips-by-System-and-Ot/7fgy-2zkf/

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"bts-gov/docked-bikeshare-ridership-6cfa-ipzd\".\"docked_bikeshare_ridership\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • docked_bikeshare_ridership
     
     
     
     
     
Upstream Metadata