About this Dataset

Violent Crime & Property Crime By County: 1975 To Present

The data are provided are the Maryland Statistical Analysis Center (MSAC), within the Governor's Office of Crime Control and Prevention (GOCCP). MSAC, in turn, receives these data from the Maryland State Police's annual Uniform Crime Reports.
Organization: State of Maryland
Last updated: 2020-11-10T17:25:03.335803
Tags: aggravated-assault, goccp, homicide, public-safety, rape, robbery, violent-crime

Tables

Table 1

@usgov.state_of_maryland_violent_crime_property_crime_by_coun_97f12e84.table_1

183.06 kB
1,104 rows
38 columns

CREATE TABLE table_1 (
  "jurisdiction" VARCHAR,
  "year" BIGINT,
  "population" BIGINT,
  "murder" BIGINT,
  "rape" BIGINT,
  "robbery" BIGINT,
  "agg_assault" BIGINT  -- AGG. ASSAULT,
  "b_e" BIGINT  -- B & E,
  "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  -- AGG. ASSAULT PER 100,000 PEOPLE,
  "b_e_per_100_000_people" DOUBLE  -- B & E PER 100,000 PEOPLE,
  "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  -- AGG. ASSAULT RATE PERCENT CHANGE PER 100,000 PEOPLE,
  "b_e_rate_percent_change_per_100_000_people" DOUBLE  -- B & E RATE PERCENT CHANGE PER 100,000 PEOPLE,
  "larceny_theft_rate_percent_change_per_100_000_people" DOUBLE,
  "m_v_theft_rate_percent_change_per_100_000_people" DOUBLE
);