About this Dataset

BART Daily Station Exits

A. SUMMARY This dataset contains the number of station exits from Bay Area Rapid Transit (BART) stations by day starting from January 1, 1998. This data is produced by BART and not by the City & County of San Francisco. B. HOW THE DATASET IS CREATED Data is simply a lightly cleaned version of the public Daily Station Exits data published by BART here: http://64.111.127.166/DSE/Daily_Station_Exits.xlsx More information on BART ridership data is available here C. UPDATE PROCESS Data will update monthly when published by BART. D. HOW TO USE THIS DATASET Each row contains a date with the station names listed as columns and the number of exits from that station for that date as values. Station name abbreviations are used as columns but a reference table to identify full station names is available here for reference. Note: Daily exit data for approximately 16 dates (rows) in FY 2007-08 are missing from the dataset.
Organization: City of San Francisco
Last updated: 2022-10-21T04:19:06.191699
Tags: bart, ridership

Tables

Table 1

@usgov.city_of_san_francisco_bart_daily_station_exits.table_1

1.84 MB
9,921 rows
58 columns

CREATE TABLE table_1 (
  "fy" VARCHAR,
  "qtr" VARCHAR,
  "month" VARCHAR,
  "day_of_the_week" VARCHAR,
  "date" TIMESTAMP,
  "rm" DOUBLE,
  "en" DOUBLE,
  "ep" DOUBLE,
  "nb" DOUBLE,
  "bk" DOUBLE,
  "as" DOUBLE,
  "ma" DOUBLE,
  "n_19" DOUBLE  -- 19,
  "n_12" DOUBLE  -- 12,
  "lm" DOUBLE,
  "fv" DOUBLE,
  "cl" DOUBLE,
  "sl" DOUBLE,
  "bf" DOUBLE,
  "hy" DOUBLE,
  "sh" DOUBLE,
  "uc" DOUBLE,
  "fm" DOUBLE,
  "cn" DOUBLE,
  "ph" DOUBLE,
  "wc" DOUBLE,
  "lf" DOUBLE,
  "or" DOUBLE,
  "rr" DOUBLE,
  "ow" DOUBLE,
  "em" DOUBLE,
  "mt" DOUBLE,
  "pl" DOUBLE,
  "cc" DOUBLE,
  "n_16" DOUBLE  -- 16,
  "n_24" DOUBLE  -- 24,
  "gp" DOUBLE,
  "bp" DOUBLE,
  "dc" DOUBLE,
  "cm" DOUBLE,
  "cv" DOUBLE,
  "ed" DOUBLE,
  "nc" DOUBLE,
  "wp" DOUBLE,
  "ss" DOUBLE,
  "sb" DOUBLE,
  "so" DOUBLE,
  "mb" DOUBLE,
  "wd" DOUBLE,
  "oa" DOUBLE,
  "ws" DOUBLE,
  "ml" DOUBLE,
  "be" DOUBLE,
  "pc" DOUBLE,
  "an" DOUBLE,
  "total" DOUBLE,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR
);