About this Dataset

Capital Bikeshare Locations

Capital Bikeshare is metro DC's bikeshare service, with 5,000 bikes and 600+ stations across 7 jurisdictions: Washington, DC.; Arlington, VA; Alexandria, VA; Montgomery, MD; Prince George's County, MD; Fairfax County, VA; and the City of Falls Church, VA. For more information, please visit https://www.capitalbikeshare.com.
Organization: District of Columbia
Last updated: 2024-04-30T18:20:27.647255
Tags: bicycle, bike, capital-bikeshare, dc, ddot, district-of-columbia, transportation, washington-dc

Tables

Table 1

@usgov.district_of_columbia_capital_bikeshare_locations.table_1

90.38 kB
794 rows
29 columns

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "name" VARCHAR,
  "station_type" VARCHAR,
  "station_id" VARCHAR,
  "station_status" VARCHAR,
  "last_reported" TIMESTAMP,
  "num_docks_available" BIGINT,
  "num_docks_disabled" BIGINT,
  "num_bikes_available" BIGINT,
  "num_ebikes_available" BIGINT,
  "num_bikes_disabled" BIGINT,
  "is_installed" VARCHAR,
  "is_returning" VARCHAR,
  "is_renting" VARCHAR,
  "has_kiosk" VARCHAR,
  "ios" VARCHAR,
  "android" VARCHAR,
  "electric_bike_surcharge_waiver" VARCHAR,
  "eightd_has_key_dispenser" VARCHAR,
  "capacity" BIGINT,
  "rental_methods" VARCHAR,
  "region_id" DOUBLE,
  "region_name" VARCHAR,
  "gis_id" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "gis_last_mod_dttm" TIMESTAMP,
  "objectid" BIGINT
);