Violent Crime & Property Crime Statewide Totals: 1975 To Present
State of Maryland
@usgov.state_of_maryland_violent_crime_property_crime_statewi_ce68a584
State of Maryland
@usgov.state_of_maryland_violent_crime_property_crime_statewi_ce68a584
CREATE TABLE table_1 (
"jurisdiction" VARCHAR,
"year" BIGINT,
"population" BIGINT,
"murder" BIGINT,
"rape" BIGINT,
"robbery" BIGINT,
"agg_assault" BIGINT,
"b_e" BIGINT,
"larceny_theft" BIGINT,
"m_v_theft" BIGINT,
"grand_total" BIGINT,
"percent_change" DOUBLE,
"violent_crime_total" BIGINT,
"violent_crime_percent" DOUBLE,
"violent_crime_percent_change" DOUBLE,
"property_crime_totals" BIGINT,
"property_crime_percent" DOUBLE,
"property_crime_percent_change" DOUBLE,
"overall_crime_rate_per_100_000_people" DOUBLE,
"overall_percent_change_per_100_000_people" DOUBLE,
"violent_crime_rate_per_100_000_people" DOUBLE,
"violent_crime_rate_percent_change_per_100_000_people" DOUBLE,
"property_crime_rate_per_100_000_people" DOUBLE,
"property_crime_rate_percent_change_per_100_000_people" DOUBLE,
"murder_per_100_000_people" DOUBLE,
"rape_per_100_000_people" DOUBLE,
"robbery_per_100_000_people" DOUBLE,
"agg_assault_per_100_000_people" DOUBLE,
"b_e_per_100_000_people" DOUBLE,
"larceny_theft_per_100_000_people" DOUBLE,
"m_v_theft_per_100_000_people" DOUBLE,
"murder_rate_percent_change_per_100_000_people" DOUBLE,
"rape_rate_percent_change_per_100_000_people" DOUBLE,
"robbery_rate_percent_change_per_100_000_people" DOUBLE,
"agg_assault_rate_percent_change_per_100_000_people" DOUBLE,
"b_e_rate_percent_change_per_100_000_people" DOUBLE,
"larceny_theft_rate_percent_change_per_100_000_people" DOUBLE,
"m_v_theft_rate_percent_change_per_100_000_people" DOUBLE
);
Anyone who has the link will be able to view this.