About this Dataset

APC Raw July 2021 - December 2021

This Capital Metro Automatic Passenger Counter (APC) Ridership data set is unprocessed, pure, raw, flaws and all straight from our Automatic Vehicle Location (AVL) system. Capital Metro, in partnership with a third-party vendor, applies a process that reviews the data to determine the validity and flags various elements to ensure final reported data has any bad elements excluded. Utilizing this data without applying your own methods to remove errors WILL NOT produce results corresponding to the published Ridership Reports.

https://www.capmetro.org/facts/#!
Organization: City of Austin
Last updated: 2023-08-25T23:00:47.016531
Tags: apc, ridership, transit

Tables

Table 1

@usgov.city_of_austin_apc_raw_july_2021_december_2021.table_1

582.77 MB
9,197,694 rows
47 columns

CREATE TABLE table_1 (
  "act_trip_start_time" BIGINT,
  "actual_sequence" BIGINT,
  "apc_date_time" BIGINT,
  "block_id" BIGINT,
  "booking_id" VARCHAR,
  "booking_num" BIGINT,
  "booking_start_date" BIGINT,
  "bs_id" BIGINT,
  "close_date_time" BIGINT,
  "current_route_id" BIGINT,
  "day_type_vs" BIGINT,
  "direction_code_id" BIGINT,
  "dwell_time" BIGINT,
  "ext_trip_id" BIGINT,
  "garage_id" BIGINT,
  "headsign_route" BIGINT,
  "import_error" BIGINT,
  "import_trip_error" BIGINT,
  "insert_date_time" BIGINT,
  "max_load" BIGINT,
  "non_rev_distance" DOUBLE,
  "non_rev_seconds" BIGINT,
  "num_sat" BIGINT,
  "offs" BIGINT,
  "ons" BIGINT,
  "open_date_time" BIGINT,
  "operator_id" BIGINT,
  "position_source" BIGINT,
  "quality_indicator" BIGINT,
  "raw_max_load" BIGINT,
  "raw_off" BIGINT,
  "raw_on" BIGINT,
  "rev_distance" DOUBLE,
  "rev_seconds" BIGINT,
  "route_id" BIGINT,
  "run_id" BIGINT,
  "sched_time" BIGINT,
  "seg_arr_time" BIGINT,
  "seg_dep_time" BIGINT,
  "start_trip_time" BIGINT,
  "time_id" BIGINT,
  "tp_id" BIGINT,
  "transit_date_time" BIGINT,
  "variation" VARCHAR,
  "veh_lat" DOUBLE,
  "veh_long" DOUBLE,
  "vehicle_id" BIGINT
);