Baselight

Divvy Tripdata 2023

Datos historicos de viajes de Divvy durante el 2023

@kaggle.adrielogc_tripdata

Loading...
Loading...

About this Dataset

Divvy Tripdata 2023

Conjunto de datos históricos de viajes del sistema de bicicletas compartidas Divvy con sede en la Ciudad de Chicago, Illinois.

Los datos se encuentran alojados en un servidor web que se actualizan mes con mes en un depósito llamado "divvy-tripdata" al cual se puede acceder aquí.

Los conjuntos de datos allí mostrados son públicos, proporcionados por Motivate International Inc. bajo esta licencia.

Los datos cargados en este Dataset corresponden a los viajes realizados del primero de enero de 2023 al 31 de diciembre del mismo año.

Estos datos fueron utilizados como parte de un caso práctico en el Certificado Profesional de Análisis de Datos de Google.

Tables

N 202301 Divvy Tripdata

@kaggle.adrielogc_tripdata.n_202301_divvy_tripdata
  • 9.19 MB
  • 190301 rows
  • 13 columns
Loading...

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
);

N 202302 Divvy Tripdata

@kaggle.adrielogc_tripdata.n_202302_divvy_tripdata
  • 9.25 MB
  • 190445 rows
  • 13 columns
Loading...

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
);

N 202303 Divvy Tripdata

@kaggle.adrielogc_tripdata.n_202303_divvy_tripdata
  • 12.91 MB
  • 258678 rows
  • 13 columns
Loading...

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
);

N 202304 Divvy Tripdata

@kaggle.adrielogc_tripdata.n_202304_divvy_tripdata
  • 21.02 MB
  • 426590 rows
  • 13 columns
Loading...

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
);

N 202305 Divvy Tripdata

@kaggle.adrielogc_tripdata.n_202305_divvy_tripdata
  • 30.02 MB
  • 604827 rows
  • 13 columns
Loading...

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
);

N 202306 Divvy Tripdata

@kaggle.adrielogc_tripdata.n_202306_divvy_tripdata
  • 35.42 MB
  • 719618 rows
  • 13 columns
Loading...

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
);

N 202307 Divvy Tripdata

@kaggle.adrielogc_tripdata.n_202307_divvy_tripdata
  • 37.26 MB
  • 767650 rows
  • 13 columns
Loading...

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
);

N 202308 Divvy Tripdata

@kaggle.adrielogc_tripdata.n_202308_divvy_tripdata
  • 37.37 MB
  • 771693 rows
  • 13 columns
Loading...

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
);

N 202309 Divvy Tripdata

@kaggle.adrielogc_tripdata.n_202309_divvy_tripdata
  • 32.43 MB
  • 666371 rows
  • 13 columns
Loading...

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
);

N 202310 Divvy Tripdata

@kaggle.adrielogc_tripdata.n_202310_divvy_tripdata
  • 25.72 MB
  • 537113 rows
  • 13 columns
Loading...

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
);

N 202311 Divvy Tripdata

@kaggle.adrielogc_tripdata.n_202311_divvy_tripdata
  • 17.86 MB
  • 362518 rows
  • 13 columns
Loading...

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
);

N 202312 Divvy Tripdata

@kaggle.adrielogc_tripdata.n_202312_divvy_tripdata
  • 11.16 MB
  • 224073 rows
  • 13 columns
Loading...

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
);

Share link

Anyone who has the link will be able to view this.