Incarceration Trends BigQuery Schema

schema.json

[
  {
    "name": "yfips",
    "type": "INT64",
    "mode": "REQUIRED",
    "description": "Unique ID: Year and FIPS code"
  },
  {
    "name": "year",
    "type": "INT64",
    "mode": "NULLABLE",
    "description": "Year"
  },
  {
    "name": "fips",
    "type": "INT64",
    "mode": "NULLABLE",
    "description": "County Identification Code"
  },
  {
    "name": "state",
    "type": "STRING",
    "mode": "NULLABLE",
    "description": "State Name"
  },
  {
    "name": "county_name",
    "type": "STRING",
    "mode": "NULLABLE",
    "description": "County Name"
  },
  {
    "name": "total_pop",
    "type": "INT64",
    "mode": "NULLABLE",
    "description": "Population Count, All Ages"
  },
  {
    "name": "total_pop_15to64",
    "type": "INT64",
    "mode": "NULLABLE",
    "description": "Population Count, Ages 15 to 64"
  },
  {
    "name": "female_pop_15to64",
    "type": "INT64",
    "mode": "NULLABLE",
    "description": "Female Population Count, Ages 15 to 64"
  },
  {
    "name": "male_pop_15to64",
    "type": "INT64",
    "mode": "NULLABLE",
    "description": "Male Population Count, Ages 15 to 64"
  },
  {
    "name": "asian_pop_15to64",
    "type": "INT64",
    "mode": "NULLABLE",
    "description": "Asian Population Count, Ages 15 to 64"
  },
  {
    "name": "black_pop_15to64",
    "type": "INT64",
    "mode": "NULLABLE",
    "description": "Black Population Count, Ages 15 to 64"
  },
  {
    "name": "latino_pop_15to64",
    "type": "INT64",
    "mode": "NULLABLE",
    "description": "Latino Population Count, Ages 15 to 64"
  },
  {
    "name": "native_pop_15to64",
    "type": "INT64",
    "mode": "NULLABLE",
    "description": "Native American Population Count, Ages 15 to 64"
  },
  {
    "name": "other_pop_15to64",
    "type": "INT64",
    "mode": "NULLABLE",
    "description": "Population Count Other Race, Ages 15 to 64"
  },
  {
    "name": "white_pop_15to64",
    "type": "INT64",
    "mode": "NULLABLE",
    "description": "White Population Count, Ages 15 to 64"
  },
  {
    "name": "urbanicity",
    "type": "STRING",
    "mode": "NULLABLE",
    "description": "Urbanicity"
  },
  {
    "name": "region",
    "type": "STRING",
    "mode": "NULLABLE",
    "description": "Census Region"
  },
  {
    "name": "division",
    "type": "STRING",
    "mode": "NULLABLE",
    "description": "Census Division"
  },
  {
    "name": "commuting_zone",
    "type": "INT64",
    "mode": "NULLABLE",
    "description": "Commuting Zone"
  },
  {
    "name": "metro_area",
    "type": "INT64",
    "mode": "NULLABLE",
    "description": "Core Based Statistical Area (CBSA)"
  },
  {
    "name": "land_area",
    "type": "FLOAT64",
    "mode": "NULLABLE",
    "description": "Land Area in Square Miles"
  },
  {
    "name": "total_jail_adm",
    "type": "FLOAT64",
    "mode": "NULLABLE",
    "description": "Total Jail Admission Count, ASJ/COJ Data"
  },
  {
    "name": "total_jail_adm_dcrp",
    "type": "FLOAT64",
    "mode": "NULLABLE",
    "description": "Total Jail Admission Count, DCRP Data"
  },
  {
    "name": "female_jail_adm_dcrp",
    "type": "FLOAT64",
    "mode": "NULLABLE",
    "description": "Total Jail Admission Count, Female"
  },
  {
    "name": "male_jail_adm_dcrp",
    "type": "FLOAT64",
    "mode": "NULLABLE",
    "description": "Total Jail Admission Count, Male"
  },
  {
    "name": "total_jail_pop",
    "type": "FLOAT64",
    "mode": "NULLABLE",
    "description": "Total Jail Population Count, ASJ/COJ Data"
  },
  {
    "name": "female_jail_pop",
    "type": "FLOAT64",
    "mode": "NULLABLE",
    "description": "Female Jail Population Count, ASJ/COJ Data"
  },
  {
    "name": "male_jail_pop",
    "type": "FLOAT64",
    "mode": "NULLABLE",
    "description": "Male Jail Population Count, ASJ/COJ Data"
  },
  {
    "name": "asian_jail_pop",
    "type": "FLOAT64",
    "mode": "NULLABLE",
    "description": "Jail Population Count, Asian"
  },
  {
    "name": "black_jail_pop",
    "type": "FLOAT64",
    "mode": "NULLABLE",
    "description": "Jail Population Count, Black"
  },
  {
    "name": "latino_jail_pop",
    "type": "FLOAT64",
    "mode": "NULLABLE",
    "description": "Jail Population Count, Latino"
  },
  {
    "name": "native_jail_pop",
    "type": "FLOAT64",
    "mode": "NULLABLE",
    "description": "Jail Population Count, Native American"
  },
  {
    "name": "white_jail_pop",
    "type": "FLOAT64",
    "mode": "NULLABLE",
    "description": "Jail Population Count, White"
  },
  {
    "name": "total_jail_pretrial",
    "type": "FLOAT64",
    "mode": "NULLABLE",
    "description": "Pretrial Jail Population Count"
  },
  {
    "name": "female_jail_pretrial",
    "type": "FLOAT64",
    "mode": "NULLABLE",
    "description": "Pretrial Jail Population Count, Female"
  },
  {
    "name": "male_jail_pretrial",
    "type": "FLOAT64",
    "mode": "NULLABLE",
    "description": "Pretrial Jail Population Count, Male"
  },
  {
    "name": "jail_from_state_prison",
    "type": "FLOAT64",
    "mode": "NULLABLE",
    "description": "Jail Population Count, Held for State Prison"
  },
  {
    "name": "jail_from_other_state_prison",
    "type": "FLOAT64",
    "mode": "NULLABLE",
    "description": "Jail Population Count, Held for Out-of-State Prison"
  },
  {
    "name": "jail_from_state_jail",
    "type": "FLOAT64",
    "mode": "NULLABLE",
    "description": "Jail Population Count, Held for State Jail"
  },
  {
    "name": "jail_from_other_state_jail",
    "type": "FLOAT64",
    "mode": "NULLABLE",
    "description": "Jail Population Count, Held for Out-Of-State Jail"
  },
  {
    "name": "jail_from_fed",
    "type": "FLOAT64",
    "mode": "NULLABLE",
    "description": "Jail Population Count, Held for all Federal Authorities"
  },
  {
    "name": "jail_from_ice",
    "type": "FLOAT64",
    "mode": "NULLABLE",
    "description": "Jail Population Count, Held for ICE, or predecessor INS"
  },
  {
    "name": "total_jail_pop_dcrp",
    "type": "FLOAT64",
    "mode": "NULLABLE",
    "description": "Total Jail Population Count, DCRP Data"
  },
  {
    "name": "female_jail_pop_dcrp",
    "type": "FLOAT64",
    "mode": "NULLABLE",
    "description": "Female Jail Population Count, DCRP Data"
  },
  {
    "name": "male_jail_pop_dcrp",
    "type": "FLOAT64",
    "mode": "NULLABLE",
    "description": "Male Jail Population Count, DCRP Data"
  },
  {
    "name": "total_prison_pop",
    "type": "FLOAT64",
    "mode": "NULLABLE",
    "description": "Total Prison Population Count"
  },
  {
    "name": "female_prison_pop",
    "type": "FLOAT64",
    "mode": "NULLABLE",
    "description": "Prison Population Count, Female"
  },
  {
    "name": "male_prison_pop",
    "type": "FLOAT64",
    "mode": "NULLABLE",
    "description": "Prison Population Count, Male"
  },
  {
    "name": "asian_prison_pop",
    "type": "FLOAT64",
    "mode": "NULLABLE",
    "description": "Prison Population Count, Asian"
  },
  {
    "name": "black_prison_pop",
    "type": "FLOAT64",
    "mode": "NULLABLE",
    "description": "Prison Population Count, Black"
  },
  {
    "name": "latino_prison_pop",
    "type": "FLOAT64",
    "mode": "NULLABLE",
    "description": "Prison Population Count, Hispanic"
  },
  {
    "name": "native_prison_pop",
    "type": "FLOAT64",
    "mode": "NULLABLE",
    "description": "Prison Population Count, Native American"
  },
  {
    "name": "other_prison_pop",
    "type": "FLOAT64",
    "mode": "NULLABLE",
    "description": "Prison Population Count, Other Race"
  },
  {
    "name": "white_prison_pop",
    "type": "FLOAT64",
    "mode": "NULLABLE",
    "description": "Prison Population Count, White"
  },
  {
    "name": "total_prison_adm",
    "type": "FLOAT64",
    "mode": "NULLABLE",
    "description": "Total Prison Admission Count"
  },
  {
    "name": "female_prison_adm",
    "type": "FLOAT64",
    "mode": "NULLABLE",
    "description": "Prison Admission Count, Female"
  },
  {
    "name": "male_prison_adm",
    "type": "FLOAT64",
    "mode": "NULLABLE",
    "description": "Prison Admission Count, Male"
  },
  {
    "name": "asian_prison_adm",
    "type": "FLOAT64",
    "mode": "NULLABLE",
    "description": "Prison Admission Count, Asian"
  },
  {
    "name": "black_prison_adm",
    "type": "FLOAT64",
    "mode": "NULLABLE",
    "description": "Prison Admission Count, Black"
  },
  {
    "name": "latino_prison_adm",
    "type": "FLOAT64",
    "mode": "NULLABLE",
    "description": "Prison Admission Count, Latino"
  },
  {
    "name": "native_prison_adm",
    "type": "FLOAT64",
    "mode": "NULLABLE",
    "description": "Prison Admission Count, Native American"
  },
  {
    "name": "other_prison_adm",
    "type": "FLOAT64",
    "mode": "NULLABLE",
    "description": "Prison Admission Count, Other Race"
  },
  {
    "name": "white_prison_adm",
    "type": "FLOAT64",
    "mode": "NULLABLE",
    "description": "Prison Admission Count, White"
  },
  {
    "name": "num_facilites",
    "type": "INT64",
    "mode": "NULLABLE",
    "description": "Number of Facilities"
  },
  {
    "name": "num_employees",
    "type": "INT64",
    "mode": "NULLABLE",
    "description": "Number of Employees"
  },
  {
    "name": "confined_pop",
    "type": "INT64",
    "mode": "NULLABLE",
    "description": "Total Confined Population"
  },
  {
    "name": "capacity",
    "type": "INT64",
    "mode": "NULLABLE",
    "description": "Total Prison Capacity"
  },
  {
    "name": "ucr_population",
    "type": "INT64",
    "mode": "NULLABLE",
    "description": "Total County Population – Agencies Reporting Arrests"
  },
  {
    "name": "index_crime",
    "type": "INT64",
    "mode": "NULLABLE",
    "description": "Count of Part I Index Crimes"
  },
  {
    "name": "violent_crime",
    "type": "INT64",
    "mode": "NULLABLE",
    "description": "Count of Violent Offenses"
  },
  {
    "name": "property_crime",
    "type": "INT64",
    "mode": "NULLABLE",
    "description": "Count of Property Offenses"
  },
  {
    "name": "murder_crime",
    "type": "INT64",
    "mode": "NULLABLE",
    "description": "Count of Homicide Offenses"
  },
  {
    "name": "rape_crime",
    "type": "INT64",
    "mode": "NULLABLE",
    "description": "Count of Rape Offenses"
  },
  {
    "name": "robbery_crime",
    "type": "INT64",
    "mode": "NULLABLE",
    "description": "Count of Robbery Offenses"
  },
  {
    "name": "agr_assault_crime",
    "type": "INT64",
    "mode": "NULLABLE",
    "description": "Count of Aggravated Assault Offenses"
  },
  {
    "name": "burglary_crime",
    "type": "INT64",
    "mode": "NULLABLE",
    "description": "Count of Burglary Offenses"
  },
  {
    "name": "larceny_crime",
    "type": "INT64",
    "mode": "NULLABLE",
    "description": "Count of Larceny Offenses"
  },
  {
    "name": "mv_theft_crime",
    "type": "INT64",
    "mode": "NULLABLE",
    "description": "Count of Motor Vehicle Theft Offenses"
  },
  {
    "name": "arson_crime",
    "type": "INT64",
    "mode": "NULLABLE",
    "description": "Count of Arson Offenses"
  }
]