Dataset: Healthy Ride Trip Data (archive)

Healthy Ride Rentals - 2022 Q2

@usgov.allegheny_county_city_of_pitts_healthy_ride_trip_data_archive.healthy_ride_rentals_2022_q2

99.11 KB
2897 rows
10 columns


CREATE TABLE healthy_ride_rentals_2022_q2 (
  "trip_id" BIGINT,
  "starttime" TIMESTAMP,
  "stoptime" TIMESTAMP,
  "bikeid" BIGINT,
  "tripduration" BIGINT,
  "from_station_id" DOUBLE,
  "from_station_name" VARCHAR,
  "to_station_id" DOUBLE,
  "to_station_name" VARCHAR,
  "usertype" VARCHAR
);

Healthy Ride Rentals - 2022 Q1

@usgov.allegheny_county_city_of_pitts_healthy_ride_trip_data_archive.healthy_ride_rentals_2022_q1

264.4 KB
7925 rows
10 columns


CREATE TABLE healthy_ride_rentals_2022_q1 (
  "trip_id" BIGINT,
  "starttime" TIMESTAMP,
  "stoptime" TIMESTAMP,
  "bikeid" BIGINT,
  "tripduration" BIGINT,
  "from_station_id" DOUBLE,
  "from_station_name" VARCHAR,
  "to_station_id" DOUBLE,
  "to_station_name" VARCHAR,
  "usertype" VARCHAR
);

Healthy Ride Rentals - 2021 Q4

@usgov.allegheny_county_city_of_pitts_healthy_ride_trip_data_archive.healthy_ride_rentals_2021_q4

777.97 KB
26229 rows
10 columns


CREATE TABLE healthy_ride_rentals_2021_q4 (
  "trip_id" BIGINT,
  "starttime" TIMESTAMP,
  "stoptime" TIMESTAMP,
  "bikeid" BIGINT,
  "tripduration" BIGINT,
  "from_station_id" DOUBLE,
  "from_station_name" VARCHAR,
  "to_station_id" DOUBLE,
  "to_station_name" VARCHAR,
  "usertype" VARCHAR
);

Healthy Ride Rentals - 2021 Q3

@usgov.allegheny_county_city_of_pitts_healthy_ride_trip_data_archive.healthy_ride_rentals_2021_q3

1.27 MB
44967 rows
10 columns


CREATE TABLE healthy_ride_rentals_2021_q3 (
  "trip_id" BIGINT,
  "starttime" TIMESTAMP,
  "stoptime" TIMESTAMP,
  "bikeid" BIGINT,
  "tripduration" BIGINT,
  "from_station_id" DOUBLE,
  "from_station_name" VARCHAR,
  "to_station_id" DOUBLE,
  "to_station_name" VARCHAR,
  "usertype" VARCHAR
);

Healthy Ride Rentals - 2021 Q2

@usgov.allegheny_county_city_of_pitts_healthy_ride_trip_data_archive.healthy_ride_rentals_2021_q2

1.07 MB
37785 rows
10 columns


CREATE TABLE healthy_ride_rentals_2021_q2 (
  "trip_id" BIGINT,
  "starttime" TIMESTAMP,
  "stoptime" TIMESTAMP,
  "bikeid" BIGINT,
  "tripduration" BIGINT,
  "from_station_id" DOUBLE,
  "from_station_name" VARCHAR,
  "to_station_id" DOUBLE,
  "to_station_name" VARCHAR,
  "usertype" VARCHAR
);

Healthy Ride Rentals - 2021 Q1

@usgov.allegheny_county_city_of_pitts_healthy_ride_trip_data_archive.healthy_ride_rentals_2021_q1

440.15 KB
14619 rows
10 columns


CREATE TABLE healthy_ride_rentals_2021_q1 (
  "trip_id" BIGINT,
  "starttime" TIMESTAMP,
  "stoptime" TIMESTAMP,
  "bikeid" BIGINT,
  "tripduration" BIGINT,
  "from_station_id" DOUBLE,
  "from_station_name" VARCHAR,
  "to_station_id" DOUBLE,
  "to_station_name" VARCHAR,
  "usertype" VARCHAR
);

Healthy Ride Rentals - 2020 Q4

@usgov.allegheny_county_city_of_pitts_healthy_ride_trip_data_archive.healthy_ride_rentals_2020_q4

524.97 KB
17595 rows
10 columns


CREATE TABLE healthy_ride_rentals_2020_q4 (
  "trip_id" BIGINT,
  "starttime" TIMESTAMP,
  "stoptime" TIMESTAMP,
  "bikeid" BIGINT,
  "tripduration" BIGINT,
  "from_station_id" DOUBLE,
  "from_station_name" VARCHAR,
  "to_station_id" DOUBLE,
  "to_station_name" VARCHAR,
  "usertype" VARCHAR
);

Healthy Ride Rentals - 2020 Q3

@usgov.allegheny_county_city_of_pitts_healthy_ride_trip_data_archive.healthy_ride_rentals_2020_q3

1.23 MB
43616 rows
10 columns


CREATE TABLE healthy_ride_rentals_2020_q3 (
  "trip_id" BIGINT,
  "starttime" TIMESTAMP,
  "stoptime" TIMESTAMP,
  "bikeid" BIGINT,
  "tripduration" BIGINT,
  "from_station_id" DOUBLE,
  "from_station_name" VARCHAR,
  "to_station_id" DOUBLE,
  "to_station_name" VARCHAR,
  "usertype" VARCHAR
);

Healthy Ride Rentals - 2020 Q2

@usgov.allegheny_county_city_of_pitts_healthy_ride_trip_data_archive.healthy_ride_rentals_2020_q2

862.16 KB
29811 rows
10 columns


CREATE TABLE healthy_ride_rentals_2020_q2 (
  "trip_id" BIGINT,
  "starttime" TIMESTAMP,
  "stoptime" TIMESTAMP,
  "bikeid" BIGINT,
  "tripduration" BIGINT,
  "from_station_id" DOUBLE,
  "from_station_name" VARCHAR,
  "to_station_id" DOUBLE,
  "to_station_name" VARCHAR,
  "usertype" VARCHAR
);

Healthy Ride Rentals - 2020 Q1

@usgov.allegheny_county_city_of_pitts_healthy_ride_trip_data_archive.healthy_ride_rentals_2020_q1

383.51 KB
12225 rows
10 columns


CREATE TABLE healthy_ride_rentals_2020_q1 (
  "trip_id" BIGINT,
  "starttime" TIMESTAMP,
  "stoptime" TIMESTAMP,
  "bikeid" BIGINT,
  "tripduration" BIGINT,
  "from_station_id" DOUBLE,
  "from_station_name" VARCHAR,
  "to_station_id" DOUBLE,
  "to_station_name" VARCHAR,
  "usertype" VARCHAR
);

Healthy Ride Rentals - 2019 Q4

@usgov.allegheny_county_city_of_pitts_healthy_ride_trip_data_archive.healthy_ride_rentals_2019_q4

592.56 KB
19855 rows
10 columns


CREATE TABLE healthy_ride_rentals_2019_q4 (
  "trip_id" BIGINT,
  "starttime" TIMESTAMP,
  "stoptime" TIMESTAMP,
  "bikeid" BIGINT,
  "tripduration" BIGINT,
  "from_station_id" DOUBLE,
  "from_station_name" VARCHAR,
  "to_station_id" DOUBLE,
  "to_station_name" VARCHAR,
  "usertype" VARCHAR
);

Healthy Ride Rentals - 2019 Q3

@usgov.allegheny_county_city_of_pitts_healthy_ride_trip_data_archive.healthy_ride_rentals_2019_q3

1.29 MB
1047762 rows
10 columns


CREATE TABLE healthy_ride_rentals_2019_q3 (
  "trip_id" DOUBLE,
  "starttime" TIMESTAMP,
  "stoptime" TIMESTAMP,
  "bikeid" DOUBLE,
  "tripduration" DOUBLE,
  "from_station_id" DOUBLE,
  "from_station_name" VARCHAR,
  "to_station_id" DOUBLE,
  "to_station_name" VARCHAR,
  "usertype" VARCHAR
);

Healthy Ride Rentals - 2019 Q2

@usgov.allegheny_county_city_of_pitts_healthy_ride_trip_data_archive.healthy_ride_rentals_2019_q2

1.01 MB
35815 rows
10 columns


CREATE TABLE healthy_ride_rentals_2019_q2 (
  "trip_id" BIGINT,
  "starttime" TIMESTAMP,
  "stoptime" TIMESTAMP,
  "bikeid" BIGINT,
  "tripduration" BIGINT,
  "from_station_id" DOUBLE,
  "from_station_name" VARCHAR,
  "to_station_id" DOUBLE,
  "to_station_name" VARCHAR,
  "usertype" VARCHAR
);

Healthy Ride Rentals - 2019 Q1

@usgov.allegheny_county_city_of_pitts_healthy_ride_trip_data_archive.healthy_ride_rentals_2019_q1

281.21 KB
8813 rows
10 columns


CREATE TABLE healthy_ride_rentals_2019_q1 (
  "trip_id" BIGINT,
  "starttime" TIMESTAMP,
  "stoptime" TIMESTAMP,
  "bikeid" BIGINT,
  "tripduration" BIGINT,
  "from_station_id" DOUBLE,
  "from_station_name" VARCHAR,
  "to_station_id" DOUBLE,
  "to_station_name" VARCHAR,
  "usertype" VARCHAR
);

Healthy Ride Rentals - 2018 Q4

@usgov.allegheny_county_city_of_pitts_healthy_ride_trip_data_archive.healthy_ride_rentals_2018_q4

320.56 KB
10448 rows
10 columns


CREATE TABLE healthy_ride_rentals_2018_q4 (
  "trip_id" BIGINT,
  "starttime" TIMESTAMP,
  "stoptime" TIMESTAMP,
  "bikeid" BIGINT,
  "tripduration" BIGINT,
  "from_station_id" BIGINT,
  "from_station_name" VARCHAR,
  "to_station_id" BIGINT,
  "to_station_name" VARCHAR,
  "usertype" VARCHAR
);

Healthy Ride Rentals - 2018 Q3

@usgov.allegheny_county_city_of_pitts_healthy_ride_trip_data_archive.healthy_ride_rentals_2018_q3

961.61 KB
33265 rows
10 columns


CREATE TABLE healthy_ride_rentals_2018_q3 (
  "trip_id" BIGINT,
  "starttime" TIMESTAMP,
  "stoptime" TIMESTAMP,
  "bikeid" BIGINT,
  "tripduration" BIGINT,
  "from_station_id" DOUBLE,
  "from_station_name" VARCHAR,
  "to_station_id" DOUBLE,
  "to_station_name" VARCHAR,
  "usertype" VARCHAR
);

Healthy Ride Rentals - 2018 Q2

@usgov.allegheny_county_city_of_pitts_healthy_ride_trip_data_archive.healthy_ride_rentals_2018_q2

779.94 KB
26973 rows
10 columns


CREATE TABLE healthy_ride_rentals_2018_q2 (
  "trip_id" BIGINT,
  "starttime" TIMESTAMP,
  "stoptime" TIMESTAMP,
  "bikeid" BIGINT,
  "tripduration" BIGINT,
  "from_station_id" DOUBLE,
  "from_station_name" VARCHAR,
  "to_station_id" DOUBLE,
  "to_station_name" VARCHAR,
  "usertype" VARCHAR
);

Healthy Ride Rentals - 2018 Q1

@usgov.allegheny_county_city_of_pitts_healthy_ride_trip_data_archive.healthy_ride_rentals_2018_q1

163.91 KB
5186 rows
10 columns


CREATE TABLE healthy_ride_rentals_2018_q1 (
  "trip_id" BIGINT,
  "starttime" TIMESTAMP,
  "stoptime" TIMESTAMP,
  "bikeid" BIGINT,
  "tripduration" BIGINT,
  "from_station_id" BIGINT,
  "from_station_name" VARCHAR,
  "to_station_id" BIGINT,
  "to_station_name" VARCHAR,
  "usertype" VARCHAR
);

Healthy Ride Rentals - 2017 Q4

@usgov.allegheny_county_city_of_pitts_healthy_ride_trip_data_archive.healthy_ride_rentals_2017_q4

342.32 KB
11647 rows
10 columns


CREATE TABLE healthy_ride_rentals_2017_q4 (
  "trip_id" BIGINT,
  "starttime" TIMESTAMP,
  "stoptime" TIMESTAMP,
  "bikeid" BIGINT,
  "tripduration" BIGINT,
  "from_station_id" BIGINT,
  "from_station_name" VARCHAR,
  "to_station_id" BIGINT,
  "to_station_name" VARCHAR,
  "usertype" VARCHAR
);

Healthy Ride Rentals - 2017 Q3

@usgov.allegheny_county_city_of_pitts_healthy_ride_trip_data_archive.healthy_ride_rentals_2017_q3

772.89 KB
27706 rows
10 columns


CREATE TABLE healthy_ride_rentals_2017_q3 (
  "trip_id" BIGINT,
  "starttime" TIMESTAMP,
  "stoptime" TIMESTAMP,
  "bikeid" BIGINT,
  "tripduration" BIGINT,
  "from_station_id" BIGINT,
  "from_station_name" VARCHAR,
  "to_station_id" BIGINT,
  "to_station_name" VARCHAR,
  "usertype" VARCHAR
);

Healthy Ride Rentals - 2017 Q2

@usgov.allegheny_county_city_of_pitts_healthy_ride_trip_data_archive.healthy_ride_rentals_2017_q2

678.21 KB
24313 rows
10 columns


CREATE TABLE healthy_ride_rentals_2017_q2 (
  "trip_id" BIGINT,
  "starttime" TIMESTAMP,
  "stoptime" TIMESTAMP,
  "bikeid" BIGINT,
  "tripduration" BIGINT,
  "from_station_id" BIGINT,
  "from_station_name" VARCHAR,
  "to_station_id" BIGINT,
  "to_station_name" VARCHAR,
  "usertype" VARCHAR
);

Healthy Ride Rentals - 2017 Q1

@usgov.allegheny_county_city_of_pitts_healthy_ride_trip_data_archive.healthy_ride_rentals_2017_q1

215.75 KB
7224 rows
10 columns


CREATE TABLE healthy_ride_rentals_2017_q1 (
  "trip_id" BIGINT,
  "starttime" TIMESTAMP,
  "stoptime" TIMESTAMP,
  "bikeid" BIGINT,
  "tripduration" BIGINT,
  "from_station_id" BIGINT,
  "from_station_name" VARCHAR,
  "to_station_id" BIGINT,
  "to_station_name" VARCHAR,
  "usertype" VARCHAR
);

Healthy Ride Rentals - 2016 Q4

@usgov.allegheny_county_city_of_pitts_healthy_ride_trip_data_archive.healthy_ride_rentals_2016_q4

333.86 KB
11322 rows
10 columns


CREATE TABLE healthy_ride_rentals_2016_q4 (
  "trip_id" BIGINT,
  "starttime" TIMESTAMP,
  "stoptime" TIMESTAMP,
  "bikeid" BIGINT,
  "tripduration" BIGINT,
  "from_station_id" BIGINT,
  "from_station_name" VARCHAR,
  "to_station_id" BIGINT,
  "to_station_name" VARCHAR,
  "usertype" VARCHAR
);

Healthy Ride Rentals - 2016 Q3

@usgov.allegheny_county_city_of_pitts_healthy_ride_trip_data_archive.healthy_ride_rentals_2016_q3

793.65 KB
28841 rows
10 columns


CREATE TABLE healthy_ride_rentals_2016_q3 (
  "trip_id" BIGINT,
  "starttime" TIMESTAMP,
  "stoptime" TIMESTAMP,
  "bikeid" BIGINT,
  "tripduration" BIGINT,
  "from_station_id" BIGINT,
  "from_station_name" VARCHAR,
  "to_station_id" BIGINT,
  "to_station_name" VARCHAR,
  "usertype" VARCHAR
);

Healthy Ride Rentals - 2016 Q2

@usgov.allegheny_county_city_of_pitts_healthy_ride_trip_data_archive.healthy_ride_rentals_2016_q2

725.6 KB
26370 rows
10 columns


CREATE TABLE healthy_ride_rentals_2016_q2 (
  "trip_id" BIGINT,
  "starttime" TIMESTAMP,
  "stoptime" TIMESTAMP,
  "bikeid" BIGINT,
  "tripduration" BIGINT,
  "from_station_id" BIGINT,
  "from_station_name" VARCHAR,
  "to_station_id" BIGINT,
  "to_station_name" VARCHAR,
  "usertype" VARCHAR
);

Healthy Ride Rentals - 2016 Q1

@usgov.allegheny_county_city_of_pitts_healthy_ride_trip_data_archive.healthy_ride_rentals_2016_q1

285.2 KB
9841 rows
10 columns


CREATE TABLE healthy_ride_rentals_2016_q1 (
  "trip_id" BIGINT,
  "starttime" TIMESTAMP,
  "stoptime" TIMESTAMP,
  "bikeid" BIGINT,
  "tripduration" BIGINT,
  "from_station_id" BIGINT,
  "from_station_name" VARCHAR,
  "to_station_id" BIGINT,
  "to_station_name" VARCHAR,
  "usertype" VARCHAR
);

Healthy Ride Rentals - 2015 Q4

@usgov.allegheny_county_city_of_pitts_healthy_ride_trip_data_archive.healthy_ride_rentals_2015_q4

430.1 KB
15100 rows
10 columns


CREATE TABLE healthy_ride_rentals_2015_q4 (
  "trip_id" BIGINT,
  "starttime" TIMESTAMP,
  "stoptime" TIMESTAMP,
  "bikeid" BIGINT,
  "tripduration" BIGINT,
  "from_station_id" BIGINT,
  "from_station_name" VARCHAR,
  "to_station_id" BIGINT,
  "to_station_name" VARCHAR,
  "usertype" VARCHAR
);

Healthy Ride Rentals - 2015 Q3

@usgov.allegheny_county_city_of_pitts_healthy_ride_trip_data_archive.healthy_ride_rentals_2015_q3

1.01 MB
38007 rows
10 columns


CREATE TABLE healthy_ride_rentals_2015_q3 (
  "trip_id" BIGINT,
  "starttime" TIMESTAMP,
  "stoptime" TIMESTAMP,
  "bikeid" BIGINT,
  "tripduration" BIGINT,
  "from_station_id" BIGINT,
  "from_station_name" VARCHAR,
  "to_station_id" BIGINT,
  "to_station_name" VARCHAR,
  "usertype" VARCHAR
);

Healthy Ride Rentals - 2015 Q2

@usgov.allegheny_county_city_of_pitts_healthy_ride_trip_data_archive.healthy_ride_rentals_2015_q2

264.28 KB
9198 rows
10 columns


CREATE TABLE healthy_ride_rentals_2015_q2 (
  "trip_id" BIGINT,
  "starttime" TIMESTAMP,
  "stoptime" TIMESTAMP,
  "bikeid" BIGINT,
  "tripduration" BIGINT,
  "from_station_id" BIGINT,
  "from_station_name" VARCHAR,
  "to_station_id" BIGINT,
  "to_station_name" VARCHAR,
  "usertype" VARCHAR
);

Healthy Ride Trip Data Dictionary

@usgov.allegheny_county_city_of_pitts_healthy_ride_trip_data_archive.healthy_ride_trip_data_dictionary

2.47 KB
10 rows
2 columns


CREATE TABLE healthy_ride_trip_data_dictionary (
  "column" VARCHAR,
  "description" VARCHAR
);

Healthy Ride Trip Data (archive)

About this Dataset