About this Dataset

Fremont Bridge Bicycle Counter

The Fremont Bridge Bicycle Counter began operation in October 2012 and records the number of bikes that cross the bridge using the pedestrian/bicycle pathways. Inductive loops on the east and west pathways count the passing of bicycles regardless of travel direction. The data consists of a date/time field: Date, east pathway count field: Fremont Bridge NB, and west pathway count field: Fremont Bridge SB. The count fields represent the total bicycles detected during the specified one hour period. Direction of travel is not specified, but in general most traffic in the Fremont Bridge NB field is travelling northbound and most traffic in the Fremont Bridge SB field is travelling southbound.
Organization: City of Seattle
Last updated: 2024-12-16T22:20:45.706565
Tags: bicycle, bike, bike-counts, counts, fremont, seattle, traffic

Tables

Table 1

@usgov.city_of_seattle_fremont_bridge_bicycle_counter_4f097.table_1

1.09 MB
110,232 rows
4 columns

CREATE TABLE table_1 (
  "date" VARCHAR,
  "fremont_bridge_sidewalks_south_of_n_34th_st_total" DOUBLE  -- Fremont Bridge Sidewalks, South Of N 34th St Total,
  "fremont_bridge_sidewalks_south_of_n_34th_st_cyclist_we_607418d9" DOUBLE  -- Fremont Bridge Sidewalks, South Of N 34th St Cyclist West Sidewalk,
  "fremont_bridge_sidewalks_south_of_n_34th_st_cyclist_ea_8c7b2427" DOUBLE  -- Fremont Bridge Sidewalks, South Of N 34th St Cyclist East Sidewalk
);