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 202304 Divvy Tripdata

@kaggle.elenaracila_case_study_divvy_tripdata.n_202304_divvy_tripdata

21.02 MB
426590 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
8FE8F7D9C10E88C7	electric_bike	Sun Apr 02 2023 08:37:28 GMT+0000 (Coordinated Universal Time)	Sun Apr 02 2023 08:41:37 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.8	-87.6	41.79	-87.6	member
34E4ED3ADF1D821B	electric_bike	Wed Apr 19 2023 11:29:02 GMT+0000 (Coordinated Universal Time)	Wed Apr 19 2023 11:52:12 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.87	-87.65	41.93	-87.68	member
5296BF07A2F77CB5	electric_bike	Wed Apr 19 2023 08:41:22 GMT+0000 (Coordinated Universal Time)	Wed Apr 19 2023 08:43:22 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.93	-87.66	41.93	-87.66	member
40759916B76D5D52	electric_bike	Wed Apr 19 2023 13:31:30 GMT+0000 (Coordinated Universal Time)	Wed Apr 19 2023 13:35:09 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.92	-87.65	41.91	-87.65	member
77A96F460101AC63	electric_bike	Wed Apr 19 2023 12:05:36 GMT+0000 (Coordinated Universal Time)	Wed Apr 19 2023 12:10:26 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.91	-87.65	41.91	-87.63	member
8D6A2328E19DC168	electric_bike	Wed Apr 19 2023 12:17:34 GMT+0000 (Coordinated Universal Time)	Wed Apr 19 2023 12:21:38 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.91	-87.63	41.92	-87.65	member
C97BBA66E07889F9	electric_bike	Wed Apr 19 2023 09:35:48 GMT+0000 (Coordinated Universal Time)	Wed Apr 19 2023 09:45:00 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.93	-87.66	41.91	-87.65	member
6687AD4C575FF734	electric_bike	Tue Apr 11 2023 16:13:43 GMT+0000 (Coordinated Universal Time)	Tue Apr 11 2023 16:18:41 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	42	-87.66	41.99	-87.66	member
A8FA4F73B22BC11F	electric_bike	Tue Apr 11 2023 16:29:24 GMT+0000 (Coordinated Universal Time)	Tue Apr 11 2023 16:40:23 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.99	-87.66	42	-87.66	member
81E158FE63D99994	electric_bike	Wed Apr 19 2023 17:35:40 GMT+0000 (Coordinated Universal Time)	Wed Apr 19 2023 17:36:11 GMT+0000 (Coordinated Universal Time)	nan	nan	nan	nan	41.88	-87.65	41.88	-87.65	member


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