Police Department Investigated Hate Crimes
City of San Francisco
@usgov.city_of_san_francisco_police_department_investigated_h_bfa926b6
City of San Francisco
@usgov.city_of_san_francisco_police_department_investigated_h_bfa926b6
CREATE TABLE table_1 (
"record_id" VARCHAR,
"occurence_month" TIMESTAMP,
"ncic" DOUBLE,
"total_number_of_victims" BIGINT,
"total_number_of_individual_victims" BIGINT,
"suspects_race_as_a_group" VARCHAR,
"total_number_of_suspects" BIGINT,
"most_serious_ucr" VARCHAR,
"most_serious_ucr_type" VARCHAR,
"most_serious_location" VARCHAR,
"most_serious_bias" VARCHAR,
"most_serious_bias_type" VARCHAR,
"most_serious_victim_type" VARCHAR,
"weapon_type" VARCHAR,
"offensive_act" VARCHAR,
"is_multiple_bias" VARCHAR,
"total_number_of_individual_victims_adult" DOUBLE,
"total_number_of_individual_victims_juvenile" DOUBLE,
"total_number_of_suspects_adult" DOUBLE,
"total_number_of_suspects_juvenile" DOUBLE,
"suspects_ethnicity_as_a_group" VARCHAR,
"data_as_of" VARCHAR,
"data_loaded_at" VARCHAR
);
Anyone who has the link will be able to view this.