# Bikeshare and E-scooter Systems by Year and City Served

## Local file

- Dataset file: `bikeshare_escooter_systems_by_city_year.csv`
- Format: CSV
- Retrieved: 2026-07-01
- Size: 748,100 bytes, about 730.6 KB
- Shape: 1,964 data rows, 49 columns
- SHA-256: `a7e96edc7200944da59a070eb1d9a60e4abafdb807dffee8c529ed9e33955efd`

## Source

- Found at: https://catalog.data.gov/dataset/bikeshare-docked-and-dockless-and-e-scooter-systems-by-year-and-city-served
- Publisher: Bureau of Transportation Statistics
- Direct download used: https://data.transportation.gov/api/views/cqdc-cm7d/rows.csv?accessType=DOWNLOAD

## What it is

This dataset tracks bikeshare, dockless bikeshare, and e-scooter systems by city and year. Records include city, state, year, latitude, longitude, FIPS code, system type, operator names, launch and closure dates, system counts, and notes.

The file includes point geometry in `the_geom`, city/year identifiers such as `YearPlaceID`, and descriptive fields such as `Type`, `dockNm`, `docklessNm`, and `scooterNm`.

## Notes for static website use

- This is the largest of the three retrieved files, but it is still under 1 MB and suitable for a static build.
- The dataset is useful for maps, city profiles, timelines, and filters by system type or year.
- Geometry is stored as WKT point text like `POINT (-97.40329 27.76355)`, while numeric coordinates are also available in `Lat` and `Lon`.
- Some date-like fields contain partial or textual values such as `Dec-18 (Lime)`, so avoid assuming every launch or closure field can be parsed as a strict date.
- The CSV was downloaded as-is from the source. No filtering, sorting, or transformations were applied.