About this Dataset

Violent Crime & Property Crime By Municipality: 2000 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:23:49.311636
Tags: aggravated-assault, goccp, homicide, public-safety, rape, robbery, violent-crime

Tables

Table 1

@usgov.state_of_maryland_violent_crime_property_crime_by_muni_b1fc7526.table_1

347.08 kB
4,284 rows
32 columns

CREATE TABLE table_1 (
  "jurisdiction" VARCHAR,
  "county" 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
);