About this Dataset

Bike Share Inspections

Inspections has halted since March 2020.
DOT field inspectors conduct inspections and issue tickets in real-time to the Bike Share system operator according to service level agreements. Stations, kiosks, docks, and bicycles are checked.
Organization: City of New York
Last updated: 2020-11-10T17:00:52.989608
Tags: bicycle, bike, bikeshare, citi-bike, citibike, inspection, share, ticket

Tables

Table 1

@usgov.city_of_new_york_bike_share_inspections.table_1

2.77 MB
94,172 rows
42 columns

CREATE TABLE table_1 (
  "siteid" DOUBLE,
  "inspectionid" BIGINT,
  "inpectiondate" VARCHAR,
  "location" VARCHAR,
  "question1" VARCHAR,
  "question2" VARCHAR,
  "n_2_option1" VARCHAR  -- 2-Option1,
  "n_2_option2" VARCHAR  -- 2-Option2,
  "n_2_option3" VARCHAR  -- 2-Option3,
  "n_2_option4" VARCHAR  -- 2-Option4,
  "n_2_option5" VARCHAR  -- 2-Option5,
  "n_2_option6" VARCHAR  -- 2-Option6,
  "n_2_ticketnumber" VARCHAR  -- 2-TicketNumber,
  "n_2_bikeidnumber" VARCHAR  -- 2-BikeIDNumber,
  "n_2_multipleinstances" VARCHAR  -- 2-MultipleInstances,
  "n_2_ticketcomments" VARCHAR  -- 2-TicketComments,
  "question3" VARCHAR,
  "n_3_option1" VARCHAR  -- 3-Option1,
  "n_3_option2" VARCHAR  -- 3-Option2,
  "n_3_option3" VARCHAR  -- 3-Option3,
  "n_3_option4" VARCHAR  -- 3-Option4,
  "n_3_ticketnumber" VARCHAR  -- 3-TicketNumber,
  "n_3_ticketcomments" VARCHAR  -- 3-TicketComments,
  "question4" VARCHAR,
  "n_4_option1" VARCHAR  -- 4-Option1,
  "n_4_option2" VARCHAR  -- 4-Option2,
  "n_4_option3" VARCHAR  -- 4-Option3,
  "n_4_option4" VARCHAR  -- 4-Option4,
  "n_4_ticketnumber" VARCHAR  -- 4-TicketNumber,
  "n_4_ticketcomments" VARCHAR  -- 4-TicketComments,
  "question5" VARCHAR,
  "question6" DOUBLE,
  "question7" VARCHAR,
  "question8" VARCHAR,
  "n_8_option1" VARCHAR  -- 8-Option1,
  "n_8_option2" VARCHAR  -- 8-Option2,
  "n_8_option3" VARCHAR  -- 8-Option3,
  "n_8_ticketnumber" VARCHAR  -- 8-TicketNumber,
  "n_8_bikeidnumber" DOUBLE  -- 8-BikeIDNumber,
  "n_8_ticketcomments" VARCHAR  -- 8-TicketComments,
  "question9" DOUBLE,
  "question10" DOUBLE
);