Cyclistic Capstone Project

Google Analytics Certification

@kaggle.shane3martin_cyclist_capstone_project

Table List

4 tables(127.58 MB)

N 202008 Divvy Tripdata

N 202009 Divvy Tripdata

Summerbikerides

Winterbikerides

Summerbikerides

@kaggle.shane3martin_cyclist_capstone_project.summerbikerides

48.88 MB
1179535 rows
11 columns

ride_id Ride Id	rideable_type Rideable Type	started_at Started At	ended_at Ended At	ride_length Ride Length	weekday Weekday	member_casual Member Casual	date Date	month Month	day Day	year Year
A847FADBBC638E45	docked_bike	Sun Apr 26 2020 17:45:14 GMT+0000 (Coordinated Universal Time)	Sun Apr 26 2020 18:12:03 GMT+0000 (Coordinated Universal Time)	0:26:49	Sunday	member	Sun Apr 26 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	4	26	2020
5405B80E996FF60D	docked_bike	Fri Apr 17 2020 17:08:54 GMT+0000 (Coordinated Universal Time)	Fri Apr 17 2020 17:17:03 GMT+0000 (Coordinated Universal Time)	0:08:09	Friday	member	Fri Apr 17 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	4	17	2020
5DD24A79A4E006F4	docked_bike	Wed Apr 01 2020 17:54:13 GMT+0000 (Coordinated Universal Time)	Wed Apr 01 2020 18:08:36 GMT+0000 (Coordinated Universal Time)	0:14:23	Wednesday	member	Wed Apr 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	4	1	2020
2A59BBDF5CDBA725	docked_bike	Tue Apr 07 2020 12:50:19 GMT+0000 (Coordinated Universal Time)	Tue Apr 07 2020 13:02:31 GMT+0000 (Coordinated Universal Time)	0:12:12	Tuesday	member	Tue Apr 07 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	4	7	2020
27AD306C119C6158	docked_bike	Sat Apr 18 2020 10:22:59 GMT+0000 (Coordinated Universal Time)	Sat Apr 18 2020 11:15:54 GMT+0000 (Coordinated Universal Time)	0:52:55	Saturday	casual	Sat Apr 18 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	4	18	2020
356216E875132F61	docked_bike	Thu Apr 30 2020 17:55:47 GMT+0000 (Coordinated Universal Time)	Thu Apr 30 2020 18:01:11 GMT+0000 (Coordinated Universal Time)	0:05:24	Thursday	member	Thu Apr 30 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	4	30	2020
A2759CB06A81F2BC	docked_bike	Thu Apr 02 2020 14:47:19 GMT+0000 (Coordinated Universal Time)	Thu Apr 02 2020 14:52:32 GMT+0000 (Coordinated Universal Time)	0:05:13	Thursday	member	Thu Apr 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	4	2	2020
FC8BC2E2D54F35ED	docked_bike	Tue Apr 07 2020 12:22:20 GMT+0000 (Coordinated Universal Time)	Tue Apr 07 2020 13:38:09 GMT+0000 (Coordinated Universal Time)	1:15:49	Tuesday	casual	Tue Apr 07 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	4	7	2020
9EC5648678DE06E6	docked_bike	Wed Apr 15 2020 10:30:11 GMT+0000 (Coordinated Universal Time)	Wed Apr 15 2020 10:35:55 GMT+0000 (Coordinated Universal Time)	0:05:44	Wednesday	casual	Wed Apr 15 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	4	15	2020
A8FFF89140C33017	docked_bike	Sat Apr 04 2020 15:02:28 GMT+0000 (Coordinated Universal Time)	Sat Apr 04 2020 15:19:47 GMT+0000 (Coordinated Universal Time)	0:17:19	Saturday	member	Sat Apr 04 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	4	4	2020


CREATE TABLE summerbikerides (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "ended_at" TIMESTAMP,
  "ride_length" VARCHAR,
  "weekday" VARCHAR,
  "member_casual" VARCHAR,
  "date" TIMESTAMP,
  "month" BIGINT,
  "day" BIGINT,
  "year" BIGINT
);