Name: US Juvenile Arrests By Crime
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

US Juvenile Arrests By Crime

Content

This dataset contains information on the number of juvenile arrests in the US per crime category for each year between 1995 and 2016. The number of arrests is further broken down by sex, age group, and race for each crime category. This data is collected by the FBI as part of the Uniform Crime Reporting Program.

Acknowledgements

Source: FBI Crime Data Explorer
Image by @anneniuniu on Unsplash

Tables

Arrests National Juvenile

@kaggle.tjkyner_us_juvenile_arrests_by_crime.arrests_national_juvenile

81.87 kB
690 rows
27 columns

CREATE TABLE arrests_national_juvenile (
  "id" BIGINT,
  "year" BIGINT,
  "state_abbr" VARCHAR,
  "offense_code" VARCHAR,
  "offense_name" VARCHAR,
  "agencies" BIGINT,
  "population" BIGINT,
  "total_male" BIGINT,
  "total_female" BIGINT,
  "m_0_9" DOUBLE,
  "m_10_12" DOUBLE,
  "m_13_14" BIGINT,
  "m_15" BIGINT,
  "m_16" BIGINT,
  "m_17" BIGINT,
  "f_0_9" DOUBLE,
  "f_10_12" DOUBLE,
  "f_13_14" DOUBLE,
  "f_15" DOUBLE,
  "f_16" DOUBLE,
  "f_17" BIGINT,
  "race_agencies" BIGINT,
  "race_population" BIGINT,
  "white" BIGINT,
  "black" BIGINT,
  "asian_pacific_islander" DOUBLE,
  "american_indian" DOUBLE
);