Case Study: Divvy-tripdata

How does a bike-share navigate speedy success?

@kaggle.elenaracila_case_study_divvy_tripdata

Table List

12 tables(279.15 MB)

N 202303 Divvy Tripdata

N 202304 Divvy Tripdata

N 202305 Divvy Tripdata

N 202306 Divvy Tripdata

N 202307 Divvy Tripdata

N 202308 Divvy Tripdata

N 202309 Divvy Tripdata

N 202310 Divvy Tripdata

N 202311 Divvy Tripdata

N 202312 Divvy Tripdata

N 202401 Divvy Tripdata

N 202402 Divvy Tripdata

N 202306 Divvy Tripdata

@kaggle.elenaracila_case_study_divvy_tripdata.n_202306_divvy_tripdata

35.42 MB
719618 rows
13 columns

ride_id Ride Id	rideable_type Rideable Type	started_at Started At	ended_at Ended At	start_station_name Start Station Name	start_station_id Start Station Id	end_station_name End Station Name	end_station_id End Station Id	start_lat Start Lat	start_lng Start Lng	end_lat End Lat	end_lng End Lng	member_casual Member Casual
6F1682AC40EB6F71	electric_bike	Mon Jun 05 2023 13:34:12 GMT+0000 (Coordinated Universal Time)	Mon Jun 05 2023 14:31:56 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.91	-87.69	41.91	-87.7	member
622A1686D64948EB	electric_bike	Mon Jun 05 2023 01:30:22 GMT+0000 (Coordinated Universal Time)	Mon Jun 05 2023 01:33:06 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.94	-87.65	41.94	-87.65	member
3C88859D926253B4	electric_bike	Tue Jun 20 2023 18:15:49 GMT+0000 (Coordinated Universal Time)	Tue Jun 20 2023 18:32:05 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.95	-87.68	41.92	-87.63	member
EAD8A5E0259DEC88	electric_bike	Mon Jun 19 2023 14:56:00 GMT+0000 (Coordinated Universal Time)	Mon Jun 19 2023 15:00:35 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.99	-87.65	41.98	-87.66	member
5A36F21930D6A55C	electric_bike	Mon Jun 19 2023 15:03:34 GMT+0000 (Coordinated Universal Time)	Mon Jun 19 2023 15:07:16 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.98	-87.66	41.99	-87.65	member
CF682EA7D0F961DB	electric_bike	Fri Jun 09 2023 21:30:25 GMT+0000 (Coordinated Universal Time)	Fri Jun 09 2023 21:49:52 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.99	-87.68	41.94	-87.65	member
4910FBB710157754	electric_bike	Sat Jun 03 2023 13:34:09 GMT+0000 (Coordinated Universal Time)	Sat Jun 03 2023 13:34:28 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.88	-87.62	41.88	-87.62	member
EA19D850A42F56D8	electric_bike	Sat Jun 03 2023 13:34:46 GMT+0000 (Coordinated Universal Time)	Sat Jun 03 2023 13:35:00 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.88	-87.62	41.88	-87.62	member
E68F43784662A2D0	electric_bike	Fri Jun 02 2023 22:27:35 GMT+0000 (Coordinated Universal Time)	Fri Jun 02 2023 22:35:26 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.95	-87.64	41.95	-87.65	member
5A013E29CC001611	electric_bike	Fri Jun 02 2023 21:18:31 GMT+0000 (Coordinated Universal Time)	Sat Jun 03 2023 01:27:19 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.87	-87.63	41.89	-87.63	member


CREATE TABLE n_202306_divvy_tripdata (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "ended_at" TIMESTAMP,
  "start_station_name" VARCHAR,
  "start_station_id" VARCHAR,
  "end_station_name" VARCHAR,
  "end_station_id" VARCHAR,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);