About this Dataset

Traffic Counts Studies By 15 Minute Bins

This table provides traffic studies in 15 minutes bins and some statistics. The SDOT Traffic Counts group runs studies across the city to collect traffic volumes. Most studies are done with pneumatic tubes, but some come from video systems as well. Use the field study_id to match it with other tables for more information.
Organization: City of Seattle
Last updated: 2024-12-16T22:27:12.484233
Tags: counts, traffic-counts

Tables

Table 1

@usgov.city_of_seattle_traffic_counts_studies_by_15_minute_bins.table_1

395.21 MB
41,221,152 rows
13 columns

CREATE TABLE table_1 (
  "count_id" BIGINT,
  "study_id" BIGINT,
  "count_sequence" BIGINT,
  "initial_count" BIGINT,
  "current_count" BIGINT,
  "count_year" BIGINT,
  "count_month" BIGINT,
  "count_day" BIGINT,
  "count_hour" BIGINT,
  "count_minute" BIGINT,
  "count_week" BIGINT,
  "add_dttm" VARCHAR,
  "mod_dttm" VARCHAR
);