2021 Walk & Bike Count
City of Los Angeles
@usgov.city_of_los_angeles_2021_walk_bike_count
City of Los Angeles
@usgov.city_of_los_angeles_2021_walk_bike_count
CREATE TABLE table_1 (
"n_2023_index" VARCHAR,
"street_name" VARCHAR,
"limit_1" VARCHAR,
"limit_2" VARCHAR,
"full_name" VARCHAR,
"facility_type" VARCHAR,
"ped_total" BIGINT,
"ped_female" BIGINT,
"ped_male" BIGINT,
"ped_mobassist" BIGINT,
"ped_stroller" BIGINT,
"ped_weekday" DOUBLE,
"ped_weekday_female" DOUBLE,
"ped_weekday_male" DOUBLE,
"ped_weekday_mobassist" DOUBLE,
"ped_weekday_stroller" DOUBLE,
"ped_weekend" DOUBLE,
"ped_weekend_female" DOUBLE,
"ped_weekend_male" DOUBLE,
"ped_weekend_mobassist" DOUBLE,
"ped_weekend_stroller" DOUBLE,
"bike_total" BIGINT,
"bike_female" BIGINT,
"bike_male" BIGINT,
"bike_sidewalk" BIGINT,
"bike_contraflow" BIGINT,
"bike_bikeshare" BIGINT,
"bike_helmet" BIGINT,
"bike_weekday_total" DOUBLE,
"bike_weekday_female" DOUBLE,
"bike_weekday_male" DOUBLE,
"bike_weekday_sidewalk" DOUBLE,
"bike_weekday_contraflow" DOUBLE,
"bike_weekday_bike_weekdayshare" DOUBLE,
"bike_weekday_helmet" DOUBLE,
"bike_weekend_total" DOUBLE,
"bike_weekend_female" DOUBLE,
"bike_weekend_male" DOUBLE,
"bike_weekend_sidewalk" DOUBLE,
"bike_weekend_contraflow" DOUBLE,
"bike_weekend_bike_weekendshare" DOUBLE,
"bike_weekend_helmet" DOUBLE,
"scooter_total" BIGINT,
"scooter_female" BIGINT,
"scooter_male" BIGINT,
"scooter_sidewalk" BIGINT,
"scooter_contraflow" BIGINT,
"scooter_helmet" BIGINT,
"scooter_weekday_total" DOUBLE,
"scooter_weekday_female" DOUBLE,
"scooter_weekday_male" DOUBLE,
"scooter_weekday_sidewalk" DOUBLE,
"scooter_weekday_contraflow" DOUBLE,
"scooter_weekday_helmet" DOUBLE,
"scooter_weekend_total" DOUBLE,
"scooter_weekend_female" DOUBLE,
"scooter_weekend_male" DOUBLE,
"scooter_weekend_sidewalk" DOUBLE,
"scooter_weekend_contraflow" DOUBLE,
"scooter_weekend_helmet" DOUBLE,
"other_total" BIGINT,
"other_female" BIGINT,
"other_male" BIGINT,
"other_sidewalk" BIGINT,
"other_contraflow" BIGINT,
"other_helmet" BIGINT,
"other_weekday_total" DOUBLE,
"other_weekday_female" DOUBLE,
"other_weekday_male" DOUBLE,
"other_weekday_sidewalk" DOUBLE,
"other_weekday_contraflow" DOUBLE,
"other_weekday_helmet" DOUBLE,
"other_weekend_total" BIGINT,
"other_weekend_female" DOUBLE,
"other_weekend_male" DOUBLE,
"other_weekend_sidewalk" DOUBLE,
"other_weekend_contraflow" DOUBLE,
"other_weekend_helmet" DOUBLE
);
Anyone who has the link will be able to view this.