Dataset: Divvy Trips

About this Dataset

Divvy Trips

Context
Used dataset provided by Coursera Google Data Analytics course.

Content
Dataset provides information about 'casual' users and 'subscriber' users on how they use bikes. Allows to observe specific attributes of each user type.

Tables

All Trips V2

@kaggle.fahrettingazicen_divvy_trips.all_trips_v2

64.87 MB
2494791 rows
15 columns


CREATE TABLE all_trips_v2 (
  "trip_id" BIGINT,
  "start_time" TIMESTAMP,
  "end_time" TIMESTAMP,
  "bikeid" BIGINT,
  "tripduration" BIGINT,
  "from_station_id" BIGINT,
  "from_station_name" VARCHAR,
  "to_station_id" BIGINT,
  "to_station_name" VARCHAR,
  "usertype" VARCHAR,
  "date" TIMESTAMP,
  "month" BIGINT,
  "day" BIGINT,
  "year" BIGINT,
  "day_of_week" VARCHAR
);