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

Winterbikerides

@kaggle.shane3martin_cyclist_capstone_project.winterbikerides

21.07 MB
506525 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
70B6A9A437D4C30D	classic_bike	Sun Dec 27 2020 12:44:29 GMT+0000 (Coordinated Universal Time)	Sun Dec 27 2020 12:55:06 GMT+0000 (Coordinated Universal Time)	637	Sunday	member	Sun Dec 27 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	12	27	2020
158A465D4E74C54A	electric_bike	Fri Dec 18 2020 17:37:15 GMT+0000 (Coordinated Universal Time)	Fri Dec 18 2020 17:44:19 GMT+0000 (Coordinated Universal Time)	424	Friday	member	Fri Dec 18 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	12	18	2020
5262016E0F1F2F9A	electric_bike	Tue Dec 15 2020 15:04:33 GMT+0000 (Coordinated Universal Time)	Tue Dec 15 2020 15:11:28 GMT+0000 (Coordinated Universal Time)	415	Tuesday	member	Tue Dec 15 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	12	15	2020
BE119628E44F871E	electric_bike	Tue Dec 15 2020 15:54:18 GMT+0000 (Coordinated Universal Time)	Tue Dec 15 2020 16:00:11 GMT+0000 (Coordinated Universal Time)	353	Tuesday	member	Tue Dec 15 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	12	15	2020
69AF78D57854E110	electric_bike	Tue Dec 22 2020 12:08:17 GMT+0000 (Coordinated Universal Time)	Tue Dec 22 2020 12:10:59 GMT+0000 (Coordinated Universal Time)	162	Tuesday	member	Tue Dec 22 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	12	22	2020
C1DECC4AB488831C	electric_bike	Tue Dec 22 2020 13:26:37 GMT+0000 (Coordinated Universal Time)	Tue Dec 22 2020 13:34:50 GMT+0000 (Coordinated Universal Time)	493	Tuesday	member	Tue Dec 22 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	12	22	2020
B014A60B856C02B1	electric_bike	Thu Dec 03 2020 16:23:48 GMT+0000 (Coordinated Universal Time)	Thu Dec 03 2020 16:33:39 GMT+0000 (Coordinated Universal Time)	591	Thursday	member	Thu Dec 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	12	3	2020
1E127B1929C0A976	electric_bike	Thu Dec 03 2020 15:03:38 GMT+0000 (Coordinated Universal Time)	Thu Dec 03 2020 15:12:39 GMT+0000 (Coordinated Universal Time)	541	Thursday	member	Thu Dec 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	12	3	2020
05F41F5137B5048E	electric_bike	Sat Dec 12 2020 09:26:17 GMT+0000 (Coordinated Universal Time)	Sat Dec 12 2020 09:26:35 GMT+0000 (Coordinated Universal Time)	18	Saturday	member	Sat Dec 12 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	12	12	2020
BB807646588DC5B1	electric_bike	Fri Dec 18 2020 12:52:06 GMT+0000 (Coordinated Universal Time)	Fri Dec 18 2020 12:52:23 GMT+0000 (Coordinated Universal Time)	17	Friday	member	Fri Dec 18 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	12	18	2020


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