About this Dataset

Healthy Ride Trip Data (archive)

A dataset that shows trips taken using the Healthy Ride system by quarter. The dataset includes bike number, membership type, trip start and end timestamp, and origin and destination information. A trip is defined as any valid rental one minute or longer.

The Healthy Ride system was replaced by POGOH in May 2022. Data for POGOH may be found here: https://data.wprdc.org/organization/pogoh
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T18:07:41.987160
Tags: bike, bike-share, rental, trip

Tables

Healthy Ride Rentals - 2015 Q2

@usgov.allegheny_county_city_of_pitts_healthy_ride_trip_data_archive.healthy_ride_rentals_2015_q2

270.63 kB
9,198 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 Rentals - 2015 Q3

@usgov.allegheny_county_city_of_pitts_healthy_ride_trip_data_archive.healthy_ride_rentals_2015_q3

1.05 MB
38,007 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 Q4

@usgov.allegheny_county_city_of_pitts_healthy_ride_trip_data_archive.healthy_ride_rentals_2015_q4

440.42 kB
15,100 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 - 2016 Q1

@usgov.allegheny_county_city_of_pitts_healthy_ride_trip_data_archive.healthy_ride_rentals_2016_q1

292.04 kB
9,841 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 - 2016 Q2

@usgov.allegheny_county_city_of_pitts_healthy_ride_trip_data_archive.healthy_ride_rentals_2016_q2

743.01 kB
26,370 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 Q3

@usgov.allegheny_county_city_of_pitts_healthy_ride_trip_data_archive.healthy_ride_rentals_2016_q3

812.7 kB
28,841 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 Q4

@usgov.allegheny_county_city_of_pitts_healthy_ride_trip_data_archive.healthy_ride_rentals_2016_q4

341.87 kB
11,322 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 - 2017 Q1

@usgov.allegheny_county_city_of_pitts_healthy_ride_trip_data_archive.healthy_ride_rentals_2017_q1

220.93 kB
7,224 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 - 2017 Q2

@usgov.allegheny_county_city_of_pitts_healthy_ride_trip_data_archive.healthy_ride_rentals_2017_q2

694.49 kB
24,313 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 Q3

@usgov.allegheny_county_city_of_pitts_healthy_ride_trip_data_archive.healthy_ride_rentals_2017_q3

791.44 kB
27,706 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 Q4

@usgov.allegheny_county_city_of_pitts_healthy_ride_trip_data_archive.healthy_ride_rentals_2017_q4

350.54 kB
11,647 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 - 2018 Q1

@usgov.allegheny_county_city_of_pitts_healthy_ride_trip_data_archive.healthy_ride_rentals_2018_q1

167.84 kB
5,186 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 - 2018 Q2

@usgov.allegheny_county_city_of_pitts_healthy_ride_trip_data_archive.healthy_ride_rentals_2018_q2

798.65 kB
26,973 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 Q3

@usgov.allegheny_county_city_of_pitts_healthy_ride_trip_data_archive.healthy_ride_rentals_2018_q3

984.69 kB
33,265 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 Q4

@usgov.allegheny_county_city_of_pitts_healthy_ride_trip_data_archive.healthy_ride_rentals_2018_q4

328.25 kB
10,448 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 - 2019 Q1

@usgov.allegheny_county_city_of_pitts_healthy_ride_trip_data_archive.healthy_ride_rentals_2019_q1

287.95 kB
8,813 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 - 2019 Q2

@usgov.allegheny_county_city_of_pitts_healthy_ride_trip_data_archive.healthy_ride_rentals_2019_q2

1.06 MB
35,815 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 Q3

@usgov.allegheny_county_city_of_pitts_healthy_ride_trip_data_archive.healthy_ride_rentals_2019_q3

1.36 MB
1,047,762 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 Q4

@usgov.allegheny_county_city_of_pitts_healthy_ride_trip_data_archive.healthy_ride_rentals_2019_q4

606.79 kB
19,855 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 - 2020 Q1

@usgov.allegheny_county_city_of_pitts_healthy_ride_trip_data_archive.healthy_ride_rentals_2020_q1

392.71 kB
12,225 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 - 2020 Q2

@usgov.allegheny_county_city_of_pitts_healthy_ride_trip_data_archive.healthy_ride_rentals_2020_q2

882.86 kB
29,811 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 Q3

@usgov.allegheny_county_city_of_pitts_healthy_ride_trip_data_archive.healthy_ride_rentals_2020_q3

1.29 MB
43,616 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 Q4

@usgov.allegheny_county_city_of_pitts_healthy_ride_trip_data_archive.healthy_ride_rentals_2020_q4

537.57 kB
17,595 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 - 2021 Q1

@usgov.allegheny_county_city_of_pitts_healthy_ride_trip_data_archive.healthy_ride_rentals_2021_q1

450.71 kB
14,619 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 - 2021 Q2

@usgov.allegheny_county_city_of_pitts_healthy_ride_trip_data_archive.healthy_ride_rentals_2021_q2

1.12 MB
37,785 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
);