Crimes Data

crime rates in united states

@kaggle.edwardotieno_2019_crimes_data

Table List

1 table(19.36 KB)

Crimes Dataset

@kaggle.edwardotieno_2019_crimes_data.crimes_dataset

19.36 KB
20 rows
22 columns

year Year	population Population	violent_crimes Violent Crimes	violent_crime_rate Violent Crime Rate	murder_nonnegligent_manslaughter Murder Nonnegligent Manslaughter	murder_nonnegligent_manslaughter_rate Murder Nonnegligent Manslaughter Rate	rape_legacy_definition Rape (legacy Definition	rape_legacy_definition_rate Rape (legacy Definition) Rate	robbery Robbery	robbery_rate Robbery Rate	aggravated_assault Aggravated Assault	aggravated_assault_rate Aggravated Assault Rate	property_crime Property Crime	property_crime_rate Property Crime Rate	burglary Burglary	burglary_rate Burglary Rate	larceny_theft Larceny- Theft	larceny_theft_rate Larceny- Theft Rate	motor_vehicle_theft Motor Vehicle Theft	motor_vehicle_theft_rate Motor Vehicle Theft Rate
2000	281421906	1425486	506.5	15586	5.5	90178	32	408016	145	911706	324	10182584	3618.3	2050992	728.8	6971590	2477.3	1160002	412.2
2001	285317559	1439480	504.5	16037	5.6	90863	31.8	423557	148.5	909023	318.6	10437189	3658.1	2116531	741.8	7092267	2485.7	1228391	430.5
2002	287973924	1423677	494.4	16229	5.6	95235	33.1	420806	146.1	891407	309.5	10455277	3630.6	2151252	747	7057379	2450.7	1246646	432.9
2003	290788976	1383676	475.8	16528	5.7	93883	32.3	414235	142.5	859030	295.4	10442862	3591.2	2154834	741	7026802	2416.5	1261226	433.7
2004	293656842	1360088	463.2	16148	5.5	95089	32.4	401470	136.7	847381	288.6	10319386	3514.1	2144446	730.3	6937089	2362.3	1237851	421.5
2005	296507061	1390745	469	16740	5.6	94347	31.8	417438	140.8	862220	290.8	10174754	3431.5	2155448	726.9	6783447	2287.8	1235859	416.8
2006	299398484	1435123	479.3	17309	5.8	94472	31.6	449246	150	874096	292	10019601	3346.6	2194993	733.1	6626363	2213.2	1198245	400.2
2007	301621157	1422970	471.8	17128	5.7	92160	30.6	447324	148.3	866358	287.2	9882212	3276.4	2190198	726.1	6591542	2185.4	1100472	364.9
2008	304059724	1394461	458.6	16465	5.4	90750	29.8	443563	145.9	843683	277.5	9774152	3214.6	2228887	733	6586206	2166.1	959059	315.4
2009	307006550	1325896	431.9	15399	5	89241	29.1	408742	133.1	812514	264.7	9337060	3041.3	2203313	717.7	6338095	2064.5	795652	259.2


CREATE TABLE crimes_dataset (
  "year" BIGINT,
  "population" BIGINT,
  "violent_crimes" BIGINT,
  "violent_crime_rate" DOUBLE,
  "murder_nonnegligent_manslaughter" BIGINT,
  "murder_nonnegligent_manslaughter_rate" DOUBLE,
  "rape_revised_definition" DOUBLE,
  "rape_revised_definition_rate" DOUBLE,
  "rape_legacy_definition" BIGINT,
  "rape_legacy_definition_rate" DOUBLE,
  "robbery" BIGINT,
  "robbery_rate" DOUBLE,
  "aggravated_assault" BIGINT,
  "aggravated_assault_rate" DOUBLE,
  "property_crime" BIGINT,
  "property_crime_rate" DOUBLE,
  "burglary" BIGINT,
  "burglary_rate" DOUBLE,
  "larceny_theft" BIGINT,
  "larceny_theft_rate" DOUBLE,
  "motor_vehicle_theft" BIGINT,
  "motor_vehicle_theft_rate" DOUBLE
);