Divvy Tripdata 2023
Datos historicos de viajes de Divvy durante el 2023
@kaggle.adrielogc_tripdata
Datos historicos de viajes de Divvy durante el 2023
@kaggle.adrielogc_tripdata
CREATE TABLE n_202301_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
);
CREATE TABLE n_202302_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
);
CREATE TABLE n_202303_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
);
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
);
CREATE TABLE n_202305_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
);
CREATE TABLE n_202306_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
);
CREATE TABLE n_202307_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
);
CREATE TABLE n_202308_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
);
CREATE TABLE n_202309_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
);
CREATE TABLE n_202310_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
);
CREATE TABLE n_202311_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
);
CREATE TABLE n_202312_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
);
Anyone who has the link will be able to view this.