Washington State Criminal Justice Data Book

CREATE TABLE table_1 (
  "year" BIGINT,
  "county" VARCHAR,
  "pop_total" BIGINT,
  "pop_f_0to11" BIGINT,
  "pop_f_12to17" BIGINT,
  "pop_f_18to39" BIGINT,
  "pop_f_40up" BIGINT,
  "pop_f_total" BIGINT,
  "pop_m_0to11" BIGINT,
  "pop_m_12to17" BIGINT,
  "pop_m_18to39" BIGINT,
  "pop_m_40up" BIGINT,
  "pop_m_total" BIGINT,
  "srs_ag_asslt" BIGINT,
  "srs_arson" BIGINT,
  "srs_burglary" BIGINT,
  "srs_murder" BIGINT,
  "srs_mvt" BIGINT,
  "srs_rape" BIGINT,
  "srs_robbery" BIGINT,
  "srs_theft" BIGINT,
  "srs_total" BIGINT,
  "nib_animalcr" BIGINT,
  "nib_arson" BIGINT,
  "nib_assault" BIGINT,
  "nib_bribery" BIGINT,
  "nib_burglary" BIGINT,
  "nib_destprop" BIGINT,
  "nib_drugviol" BIGINT,
  "nib_extortion" BIGINT,
  "nib_forgery" BIGINT,
  "nib_fsex" BIGINT,
  "nib_gambviol" BIGINT,
  "nib_htrffckng" BIGINT,
  "nib_kidnap" BIGINT,
  "nib_mnslghtr" BIGINT,
  "nib_murder" BIGINT,
  "nib_nfsex" BIGINT,
  "nib_porn" BIGINT,
  "nib_proptot" BIGINT,
  "nib_prost" BIGINT,
  "nib_prsntot" BIGINT,
  "nib_robbery" BIGINT,
  "nib_sctytot" BIGINT,
  "nib_theft" BIGINT,
  "nib_total" BIGINT,
  "nib_violnco" BIGINT,
  "nib_weapviol" BIGINT,
  "arr_ag_asslt" BIGINT,
  "arr_arson" BIGINT,
  "arr_burglary" BIGINT,
  "arr_drug_cr" BIGINT,
  "arr_murder" BIGINT,
  "arr_mvt" BIGINT,
  "arr_othcrime" BIGINT,
  "arr_rape" BIGINT,
  "arr_robbery" BIGINT,
  "arr_theft" BIGINT,
  "arr_total" BIGINT,
  "arn_animalcr" BIGINT,
  "arn_arson" BIGINT,
  "arn_assault" BIGINT,
  "arn_bribery" BIGINT,
  "arn_burglary" BIGINT,
  "arn_destprop" BIGINT,
  "arn_drugviol" BIGINT,
  "arn_extortion" BIGINT,
  "arn_forgery" BIGINT,
  "arn_fsex" BIGINT,
  "arn_gambviol" BIGINT,
  "arn_group_b" BIGINT,
  "arn_hackcomp" BIGINT,
  "arn_htrffckng" BIGINT,
  "arn_kidnap" BIGINT,
  "arn_mnslghtr" BIGINT,
  "arn_murder" BIGINT,
  "arn_nfsex" BIGINT,
  "arn_porn" BIGINT,
  "arn_prost" BIGINT,
  "arn_robbery" BIGINT,
  "arn_theft" BIGINT,
  "arn_total" BIGINT,
  "arn_violnco" BIGINT,
  "arn_weapviol" BIGINT,
  "scf_assault" BIGINT,
  "scf_drug_cr" BIGINT,
  "scf_homicide" BIGINT,
  "scf_mvt" DOUBLE,
  "scf_othfelon" BIGINT,
  "scf_propcr" BIGINT,
  "scf_robbery" BIGINT,
  "scf_sexcr" BIGINT,
  "scf_total" BIGINT,
  "jdp_othradp" DOUBLE,
  "jdp_post_adp" DOUBLE,
  "jdp_pre_adp" DOUBLE,
  "jdp_capacity" BIGINT,
  "jdp_totaladp" DOUBLE,
  "jst_assault" BIGINT,
  "jst_burglary" BIGINT
);