Dataset: Bikeshare (Docked And Dockless) And E-scooter Systems By Year And City Served

About this Dataset

Bikeshare (Docked And Dockless) And E-scooter Systems By Year And City Served

List of cities served by a bikeshare and/or e-scooter system in each year starting in 2015. Some systems serve more than one city. The layer lists just the primary city served. Bikeshare includes systems that are open to the general public, IT-automated, and station based (contain hubs to which users can grab and return a bike) as well as dockless systems. The layer includes a count of the number of docking stations, the number of dockless bikeshare systems, and the number of e-scooter systems serving a city (if applicable) in each year. Counts include systems that served an areas for only part of the year.
Organization: Department of Transportation
Last updated: 2020-11-12T12:44:03.625091
Tags: bikeshare, docked-bikeshare, dockless-bikeshare, e-scooters, micromobility

Tables

Table 1

@usgov.dot_gov_bikeshare_docked_and_dockless_and_e_scooter_sy_8606d2d3.table_1

147.45 KB
1864 rows
38 columns


CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "placeid" VARCHAR,
  "yearplaceid" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "citystate" VARCHAR,
  "year" BIGINT,
  "asofdate" BIGINT,
  "dockid" VARCHAR,
  "dockct" BIGINT,
  "stationct_pct" DOUBLE,
  "stationct_bin" BIGINT,
  "docknm" VARCHAR,
  "docklessct" BIGINT,
  "dockless_bin" BIGINT,
  "docklessnm" VARCHAR,
  "scooterct" BIGINT,
  "scooter_bin" BIGINT,
  "scooternm" VARCHAR,
  "type" VARCHAR,
  "lat" DOUBLE,
  "lon" DOUBLE,
  "fips" DOUBLE,
  "datedocklaunch" VARCHAR,
  "datedockclosed" VARCHAR,
  "datescooterlaunch" VARCHAR,
  "datescooterend" VARCHAR,
  "datedocklesslaunch" VARCHAR,
  "datedocklessend" VARCHAR,
  "docknotes" VARCHAR,
  "notesdockless" VARCHAR,
  "notesscooter" VARCHAR,
  "scooterct_jul" BIGINT,
  "dockct_jul" BIGINT,
  "docklessnm_jul" VARCHAR,
  "scooternm_jul" VARCHAR,
  "docknm_jul" VARCHAR,
  "docklessct_jul" BIGINT
);