Nov23-Oct24-divvy-tripdata

Google Data Analytics Capstone Project Data Set Nov23-Oct24

@kaggle.jacksonbecker13_nov23_oct24_divvy_tripdata

Table List

12 tables(274.69 MB)

N 202311 Divvy Tripdata

N 202312 Divvy Tripdata

N 202401 Divvy Tripdata

N 202402 Divvy Tripdata

N 202403 Divvy Tripdata

N 202404 Divvy Tripdata

N 202405 Divvy Tripdata

N 202406 Divvy Tripdata

N 202407 Divvy Tripdata

N 202408 Divvy Tripdata

N 202409 Divvy Tripdata

N 202410 Divvy Tripdata

N 202311 Divvy Tripdata

@kaggle.jacksonbecker13_nov23_oct24_divvy_tripdata.n_202311_divvy_tripdata

17.86 MB
362518 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
4EAD8F1AD547356B	electric_bike	Thu Nov 30 2023 21:50:05 GMT+0000 (Coordinated Universal Time)	Thu Nov 30 2023 22:13:27 GMT+0000 (Coordinated Universal Time)	Millennium Park	13008	Pine Grove Ave & Waveland Ave	TA1307000150	41.8811015	-87.62408183333334	41.94947274088333	-87.64645278453827	member
6322270563BF5470	electric_bike	Fri Nov 03 2023 09:44:02 GMT+0000 (Coordinated Universal Time)	Fri Nov 03 2023 10:17:15 GMT+0000 (Coordinated Universal Time)	Broadway & Sheridan Rd	13323	Broadway & Sheridan Rd	13323	41.952867866	-87.650034904	41.952833	-87.649993	member
B37BDE091ECA38E0	electric_bike	Thu Nov 30 2023 11:39:44 GMT+0000 (Coordinated Universal Time)	Thu Nov 30 2023 11:40:08 GMT+0000 (Coordinated Universal Time)	State St & Pearson St	TA1307000061	State St & Pearson St	TA1307000061	41.89753266666666	-87.62869433333333	41.897448	-87.628722	member
CF0CA5DD26E4F90E	classic_bike	Wed Nov 08 2023 10:01:45 GMT+0000 (Coordinated Universal Time)	Wed Nov 08 2023 10:27:05 GMT+0000 (Coordinated Universal Time)	Theater on the Lake	TA1308000001	Theater on the Lake	TA1308000001	41.926277	-87.630834	41.926277	-87.630834	member
EB8381AA641348DB	classic_bike	Fri Nov 03 2023 16:20:25 GMT+0000 (Coordinated Universal Time)	Fri Nov 03 2023 16:54:25 GMT+0000 (Coordinated Universal Time)	Theater on the Lake	TA1308000001	Theater on the Lake	TA1308000001	41.926277	-87.630834	41.926277	-87.630834	member
B8CF14EA423D6886	electric_bike	Thu Nov 30 2023 16:15:53 GMT+0000 (Coordinated Universal Time)	Thu Nov 30 2023 16:39:52 GMT+0000 (Coordinated Universal Time)	Pine Grove Ave & Waveland Ave	TA1307000150	Millennium Park	13008	41.949422717	-87.646384716	41.8810317	-87.62408432	member
1763B0A2778C185E	classic_bike	Thu Nov 09 2023 11:55:54 GMT+0000 (Coordinated Universal Time)	Thu Nov 09 2023 13:08:18 GMT+0000 (Coordinated Universal Time)	Millennium Park	13008	Millennium Park	13008	41.8810317	-87.62408432	41.8810317	-87.62408432	casual
8307B5F616A3D2EE	classic_bike	Sun Nov 19 2023 14:37:02 GMT+0000 (Coordinated Universal Time)	Sun Nov 19 2023 14:59:07 GMT+0000 (Coordinated Universal Time)	Theater on the Lake	TA1308000001	Theater on the Lake	TA1308000001	41.926277	-87.630834	41.926277	-87.630834	member
90B4E47C4977935E	classic_bike	Sun Nov 19 2023 15:12:54 GMT+0000 (Coordinated Universal Time)	Sun Nov 19 2023 15:27:50 GMT+0000 (Coordinated Universal Time)	Pine Grove Ave & Waveland Ave	TA1307000150	Theater on the Lake	TA1308000001	41.94947274088333	-87.64645278453827	41.926277	-87.630834	member
A9A78F624F996079	classic_bike	Thu Nov 09 2023 19:34:57 GMT+0000 (Coordinated Universal Time)	Thu Nov 09 2023 19:37:53 GMT+0000 (Coordinated Universal Time)	Pine Grove Ave & Waveland Ave	TA1307000150	Pine Grove Ave & Waveland Ave	TA1307000150	41.94947274088333	-87.64645278453827	41.94947274088333	-87.64645278453827	member


CREATE TABLE n_202311_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
);