A Foundation Report: Family Violence
City of New York
@usgov.city_of_new_york_a_foundation_report_family_violence
City of New York
@usgov.city_of_new_york_a_foundation_report_family_violence
CREATE TABLE table_1 (
"year" BIGINT,
"comm_dist_boro" VARCHAR,
"comm_district" VARCHAR,
"fam_dir" BIGINT,
"fam_fel_assault" BIGINT,
"dv_fel_assault" BIGINT,
"fam_rape" BIGINT,
"dv_rape" BIGINT,
"dir_family_total" DOUBLE,
"dir_fam_rel_child" DOUBLE,
"dir_fam_rel_parent" DOUBLE,
"dir_fam_rel_othrelative" DOUBLE,
"fel_aslt_fam_total" DOUBLE,
"fel_aslt_rel_child" DOUBLE,
"fel_aslt_rel_parent" DOUBLE,
"fel_aslt_rel_othrelative" DOUBLE,
"fel_rape_fam_total" DOUBLE,
"fel_rape_rel_child" DOUBLE,
"fel_rape_rel_parent" DOUBLE,
"fel_rape_rel_othrelative" DOUBLE,
"fam_homicide_total" DOUBLE,
"fam_hom_rel_child" DOUBLE,
"fam_hom_rel_parent" DOUBLE,
"fam_hom_rel_oth" DOUBLE,
"fam_hom_rel_unkn" DOUBLE,
"fam_hom_sex_female" DOUBLE,
"fam_hom_sex_male" DOUBLE,
"fam_hom_prior_dir_yes" DOUBLE,
"fam_hom_prior_dir_no" DOUBLE,
"fam_hom_meth_blunt" DOUBLE,
"fam_hom_meth_sharpe" DOUBLE,
"fam_hom_meth_firearm" DOUBLE,
"ipv_hom_sex_female" DOUBLE,
"ipv_hom_sex_male" DOUBLE,
"ipv_hom_prior_dir_yes" DOUBLE,
"ipv_hom_prior_dir_no" DOUBLE,
"ipv_hom_meth_blunt" DOUBLE,
"ipv_hom_meth_sharpe" DOUBLE,
"ipv_hom_meth_firearm" DOUBLE,
"ipv_hom_meth_oth" DOUBLE,
"fjc_fam_client" DOUBLE,
"fjc_fam_client_ser_safplan" DOUBLE,
"fjc_fam_client_ser_counseling" DOUBLE,
"fjc_fam_client_ser_civleg" DOUBLE,
"fjc_fam_client_ser_permhous" DOUBLE,
"fjc_fam_client_ser_childcounsel" DOUBLE
);
Anyone who has the link will be able to view this.