About this Dataset

Bikeshare (Docked And Dockless) And E-scooter Systems 2020 By Month And System Status

List of cities served by a bikeshare (docked or dockless) and/or e-scooter system by month in 2020. 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 month and the status of the system - whether temporarily suspended or closed. Many systems temporarily suspended operations and/or closed permanently in response to COVID-19.
Organization: Department of Transportation
Last updated: 2020-11-12T12:39:51.460730
Tags: bikeshare, dockless-bikeshare, e-scooters, micromobility

Tables

Table 1

@usgov.dot_gov_bikeshare_docked_and_dockless_and_e_scooter_sy_f1fde707.table_1

94.2 KB
2340 rows
47 columns


CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "placeid" VARCHAR,
  "yearplaceid" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "citystate" VARCHAR,
  "year" BIGINT,
  "month" BIGINT,
  "docksuspended" VARCHAR,
  "dockclosed" VARCHAR,
  "docklesssuspended" VARCHAR,
  "docklessclosed" VARCHAR,
  "scootersuspended" VARCHAR,
  "scooterclosed" VARCHAR,
  "dockid" DOUBLE,
  "stationct" BIGINT,
  "stationct_pct" DOUBLE,
  "stationct_bin" BIGINT,
  "dockct" BIGINT,
  "docknm" VARCHAR,
  "docknmsuspended" VARCHAR,
  "docklessct" BIGINT,
  "docklessct_bin" BIGINT,
  "docklessnm" VARCHAR,
  "docklessnmsuspended" VARCHAR,
  "scooterct" BIGINT,
  "scooterct_bin" BIGINT,
  "scooternm" VARCHAR,
  "scooternmsuspended" VARCHAR,
  "lat" DOUBLE,
  "lon" DOUBLE,
  "type" VARCHAR,
  "suspscooterct" BIGINT,
  "closedscooterct" BIGINT,
  "suspdocklessct" BIGINT,
  "closeddocklessct" BIGINT,
  "closeddockct" BIGINT,
  "suspdockct" BIGINT,
  "docknotes" VARCHAR,
  "docklessnotes" VARCHAR,
  "scooternotes" VARCHAR,
  "docksuspendednotes" VARCHAR,
  "docklesssuspendednotes" VARCHAR,
  "scootersuspendednotes" VARCHAR,
  "dockclosednotes" VARCHAR,
  "docklessclosednotes" VARCHAR,
  "scooterclosednotes" VARCHAR
);