Cyclistic Bike Share Trip Data - 06.2023
Google Data Analytics Capstone Project
@kaggle.rubyphan_bike_share
Google Data Analytics Capstone Project
@kaggle.rubyphan_bike_share
ride_idRide Id | rideable_typeRideable Type | started_atStarted At | ended_atEnded At | start_station_nameStart Station Name | start_station_idStart Station Id | end_station_nameEnd Station Name | end_station_idEnd Station Id | start_latStart Lat | start_lngStart Lng | end_latEnd Lat | end_lngEnd Lng | member_casualMember Casual |
---|---|---|---|---|---|---|---|---|---|---|---|---|
BCC66FC6FAB27CC7 | electric_bike | Thu Nov 10 2022 06:21:55 GMT+0000 (Coordinated Universal Time) | Thu Nov 10 2022 06:31:27 GMT+0000 (Coordinated Universal Time) | Canal St & Adams St | 13011 | St. Clair St & Erie St | 13016 | 41.879401207 | -87.639847875 | 41.89434513742426 | -87.62279838323593 | member |
772AB67E902C180F | classic_bike | Fri Nov 04 2022 07:31:55 GMT+0000 (Coordinated Universal Time) | Fri Nov 04 2022 07:46:25 GMT+0000 (Coordinated Universal Time) | Canal St & Adams St | 13011 | St. Clair St & Erie St | 13016 | 41.879255 | -87.639904 | 41.89434513742426 | -87.62279838323593 | member |
585EAD07FDEC0152 | classic_bike | Mon Nov 21 2022 17:20:29 GMT+0000 (Coordinated Universal Time) | Mon Nov 21 2022 17:34:36 GMT+0000 (Coordinated Universal Time) | Indiana Ave & Roosevelt Rd | SL-005 | St. Clair St & Erie St | 13016 | 41.867888 | -87.623041 | 41.89434513742426 | -87.62279838323593 | member |
91C4E7ED3C262FF9 | classic_bike | Fri Nov 25 2022 17:29:34 GMT+0000 (Coordinated Universal Time) | Fri Nov 25 2022 17:45:15 GMT+0000 (Coordinated Universal Time) | Indiana Ave & Roosevelt Rd | SL-005 | St. Clair St & Erie St | 13016 | 41.867888 | -87.623041 | 41.89434513742426 | -87.62279838323593 | member |
709206A3104CABC8 | classic_bike | Tue Nov 29 2022 17:24:25 GMT+0000 (Coordinated Universal Time) | Tue Nov 29 2022 17:42:51 GMT+0000 (Coordinated Universal Time) | Indiana Ave & Roosevelt Rd | SL-005 | St. Clair St & Erie St | 13016 | 41.867888 | -87.623041 | 41.89434513742426 | -87.62279838323593 | member |
11DE62E16D1A6BD1 | classic_bike | Fri Nov 04 2022 14:40:47 GMT+0000 (Coordinated Universal Time) | Fri Nov 04 2022 14:52:35 GMT+0000 (Coordinated Universal Time) | Streeter Dr & Grand Ave | 13022 | Desplaines St & Kinzie St | TA1306000003 | 41.892278 | -87.612043 | 41.888716036 | -87.6444478533 | member |
0F05C92DE9981154 | classic_bike | Sun Nov 06 2022 14:26:29 GMT+0000 (Coordinated Universal Time) | Sun Nov 06 2022 14:36:00 GMT+0000 (Coordinated Universal Time) | Halsted St & Clybourn Ave | 331 | Desplaines St & Kinzie St | TA1306000003 | 41.909668 | -87.648128 | 41.888716036 | -87.6444478533 | member |
CBEB7068C91BB672 | classic_bike | Tue Nov 08 2022 20:25:34 GMT+0000 (Coordinated Universal Time) | Tue Nov 08 2022 20:34:23 GMT+0000 (Coordinated Universal Time) | Halsted St & Clybourn Ave | 331 | Orleans St & Chestnut St (NEXT Apts) | 620 | 41.909668 | -87.648128 | 41.898203 | -87.637536 | member |
C79980F697C514FF | electric_bike | Sun Nov 13 2022 21:56:36 GMT+0000 (Coordinated Universal Time) | Sun Nov 13 2022 22:06:07 GMT+0000 (Coordinated Universal Time) | Franklin St & Adams St (Temp) | TA1309000008 | Desplaines St & Kinzie St | TA1306000003 | 41.879141 | -87.6360515 | 41.888716036 | -87.6444478533 | member |
A65691E4D563258E | classic_bike | Tue Nov 01 2022 20:17:51 GMT+0000 (Coordinated Universal Time) | Tue Nov 01 2022 20:24:14 GMT+0000 (Coordinated Universal Time) | Halsted St & Clybourn Ave | 331 | Orleans St & Chestnut St (NEXT Apts) | 620 | 41.909668 | -87.648128 | 41.898203 | -87.637536 | member |
CREATE TABLE n_202211_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
);
Anyone who has the link will be able to view this.