Google Capstone Project

Navigate Speedy Success For Bike-Share Company "Cyclistic"

@kaggle.haniarthur_google_capstone_project

Table List

12 tables(272.12 MB)

N 202201 Divvy Tripdata

N 202202 Divvy Tripdata

N 202203 Divvy Tripdata

N 202204 Divvy Tripdata

N 202205 Divvy Tripdata

N 202206 Divvy Tripdata

N 202207 Divvy Tripdata

N 202208 Divvy Tripdata

N 202209 Divvy Tripdata

N 202210 Divvy Tripdata

N 202211 Divvy Tripdata

N 202212 Divvy Tripdata

N 202210 Divvy Tripdata

@kaggle.haniarthur_google_capstone_project.n_202210_divvy_tripdata

27.04 MB
558685 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
A50255C1E17942AB	classic_bike	Fri Oct 14 2022 17:13:30 GMT+0000 (Coordinated Universal Time)	Fri Oct 14 2022 17:19:39 GMT+0000 (Coordinated Universal Time)	Noble St & Milwaukee Ave	13290	Larrabee St & Division St	KA1504000079	41.90068	-87.6626	41.90348607004	-87.6433534936	member
DB692A70BD2DD4E3	electric_bike	Sat Oct 01 2022 16:29:26 GMT+0000 (Coordinated Universal Time)	Sat Oct 01 2022 16:49:06 GMT+0000 (Coordinated Universal Time)	Damen Ave & Charleston St	13288	Damen Ave & Cullerton St	13089	41.920037	-87.67793683333333	41.854966518753926	-87.67569959163664	casual
3C02727AAF60F873	electric_bike	Wed Oct 19 2022 18:55:40 GMT+0000 (Coordinated Universal Time)	Wed Oct 19 2022 19:03:30 GMT+0000 (Coordinated Universal Time)	Hoyne Ave & Balmoral Ave	655	Western Ave & Leland Ave	TA1307000140	41.979878902	-87.681902051	41.966399801840986	-87.68870428204536	member
47E653FDC2D99236	electric_bike	Mon Oct 31 2022 07:52:36 GMT+0000 (Coordinated Universal Time)	Mon Oct 31 2022 07:58:49 GMT+0000 (Coordinated Universal Time)	Rush St & Cedar St	KA1504000133	Orleans St & Chestnut St (NEXT Apts)	620	41.902273666666666	-87.6276925	41.898203	-87.637536	member
8B5407BE535159BF	classic_bike	Thu Oct 13 2022 18:41:03 GMT+0000 (Coordinated Universal Time)	Thu Oct 13 2022 19:26:18 GMT+0000 (Coordinated Universal Time)	900 W Harrison St	13028	Adler Planetarium	13431	41.874754	-87.649807	41.866095	-87.607267	casual
A177C92E9F021B99	electric_bike	Thu Oct 13 2022 15:53:27 GMT+0000 (Coordinated Universal Time)	Thu Oct 13 2022 15:59:17 GMT+0000 (Coordinated Universal Time)	900 W Harrison St	13028	Loomis St & Lexington St	13332	41.874725	-87.64983033333333	41.872187	-87.661501	casual
DF5EC7678DE3C2B3	electric_bike	Thu Oct 06 2022 15:51:21 GMT+0000 (Coordinated Universal Time)	Thu Oct 06 2022 15:55:06 GMT+0000 (Coordinated Universal Time)	900 W Harrison St	13028	Halsted St & Roosevelt Rd	TA1305000017	41.87471333333333	-87.649875	41.867324	-87.648625	member
407DE6D80130A297	classic_bike	Wed Oct 26 2022 17:30:10 GMT+0000 (Coordinated Universal Time)	Wed Oct 26 2022 17:37:57 GMT+0000 (Coordinated Universal Time)	Rush St & Cedar St	KA1504000133	Larrabee St & Division St	KA1504000079	41.90230870122	-87.627690528	41.90348607004	-87.6433534936	member
45EEAF68A1A051CA	classic_bike	Sat Oct 22 2022 09:47:56 GMT+0000 (Coordinated Universal Time)	Sat Oct 22 2022 09:57:42 GMT+0000 (Coordinated Universal Time)	Noble St & Milwaukee Ave	13290	Kingsbury St & Kinzie St	KA1503000043	41.90068	-87.6626	41.88917683258	-87.6385057718	casual
66CD8E4D0C38C0F3	electric_bike	Mon Oct 24 2022 12:39:47 GMT+0000 (Coordinated Universal Time)	Mon Oct 24 2022 12:48:36 GMT+0000 (Coordinated Universal Time)	Noble St & Milwaukee Ave	13290	Damen Ave & Cortland St	13133	41.90070083333333	-87.66256516666667	41.915983	-87.677335	member


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