Cyclistic Bike Share Trip Data - 06.2023

Google Data Analytics Capstone Project

@kaggle.rubyphan_bike_share

Table List

12 tables(281.77 MB)

N 202207 Divvy Tripdata

N 202208 Divvy Tripdata

N 202209 Divvy Publictripdata

N 202210 Divvy Tripdata

N 202211 Divvy Tripdata

N 202212 Divvy Tripdata

N 202301 Divvy Tripdata

N 202302 Divvy Tripdata

N 202303 Divvy Tripdata

N 202304 Divvy Tripdata

N 202305 Divvy Tripdata

N 202306 Divvy Tripdata

N 202301 Divvy Tripdata

@kaggle.rubyphan_bike_share.n_202301_divvy_tripdata

9.19 MB
190301 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
F96D5A74A3E41399	electric_bike	Sat Jan 21 2023 20:05:42 GMT+0000 (Coordinated Universal Time)	Sat Jan 21 2023 20:16:33 GMT+0000 (Coordinated Universal Time)	Lincoln Ave & Fullerton Ave	TA1309000058	Hampden Ct & Diversey Ave	202480.0	41.924073935	-87.646278381	41.93	-87.64	member
13CB7EB698CEDB88	classic_bike	Tue Jan 10 2023 15:37:36 GMT+0000 (Coordinated Universal Time)	Tue Jan 10 2023 15:46:05 GMT+0000 (Coordinated Universal Time)	Kimbark Ave & 53rd St	TA1309000037	Greenwood Ave & 47th St	TA1308000002	41.799568	-87.594747	41.809835	-87.599383	member
BD88A2E670661CE5	electric_bike	Mon Jan 02 2023 07:51:57 GMT+0000 (Coordinated Universal Time)	Mon Jan 02 2023 08:05:11 GMT+0000 (Coordinated Universal Time)	Western Ave & Lunt Ave	RP-005	Valli Produce - Evanston Plaza	599	42.008571	-87.69048283333333	42.039742	-87.699413	casual
C90792D034FED968	classic_bike	Sun Jan 22 2023 10:52:58 GMT+0000 (Coordinated Universal Time)	Sun Jan 22 2023 11:01:44 GMT+0000 (Coordinated Universal Time)	Kimbark Ave & 53rd St	TA1309000037	Greenwood Ave & 47th St	TA1308000002	41.799568	-87.594747	41.809835	-87.599383	member
3397017529188E8A	classic_bike	Thu Jan 12 2023 13:58:01 GMT+0000 (Coordinated Universal Time)	Thu Jan 12 2023 14:13:20 GMT+0000 (Coordinated Universal Time)	Kimbark Ave & 53rd St	TA1309000037	Greenwood Ave & 47th St	TA1308000002	41.799568	-87.594747	41.809835	-87.599383	member
58E68156DAE3E311	electric_bike	Tue Jan 31 2023 07:18:03 GMT+0000 (Coordinated Universal Time)	Tue Jan 31 2023 07:21:16 GMT+0000 (Coordinated Universal Time)	Lakeview Ave & Fullerton Pkwy	TA1309000019	Hampden Ct & Diversey Ave	202480.0	41.926068902	-87.638858199	41.93	-87.64	member
2F7194B6012A98D4	electric_bike	Sun Jan 15 2023 21:18:36 GMT+0000 (Coordinated Universal Time)	Sun Jan 15 2023 21:32:36 GMT+0000 (Coordinated Universal Time)	Kimbark Ave & 53rd St	TA1309000037	Greenwood Ave & 47th St	TA1308000002	41.799553633	-87.594616652	41.809835	-87.599383	member
DB1CF84154D6A049	classic_bike	Wed Jan 25 2023 10:49:01 GMT+0000 (Coordinated Universal Time)	Wed Jan 25 2023 10:58:22 GMT+0000 (Coordinated Universal Time)	Kimbark Ave & 53rd St	TA1309000037	Greenwood Ave & 47th St	TA1308000002	41.799568	-87.594747	41.809835	-87.599383	member
34EAB943F88C4C5D	electric_bike	Wed Jan 25 2023 20:49:47 GMT+0000 (Coordinated Universal Time)	Wed Jan 25 2023 21:02:14 GMT+0000 (Coordinated Universal Time)	Kimbark Ave & 53rd St	TA1309000037	Greenwood Ave & 47th St	TA1308000002	41.799587488	-87.594670296	41.809835	-87.599383	member
BC8AB1AA51DA9115	classic_bike	Fri Jan 06 2023 16:37:19 GMT+0000 (Coordinated Universal Time)	Fri Jan 06 2023 16:49:52 GMT+0000 (Coordinated Universal Time)	Kimbark Ave & 53rd St	TA1309000037	Greenwood Ave & 47th St	TA1308000002	41.799568	-87.594747	41.809835	-87.599383	member


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