8986 Cities and 19585 Agencies: FBI UCR Coverage Inside PlainCrime

Findings

8986 cities and 2406 counties covered across 51 states

PlainCrime's cities table stores 8986 rows for every US city submission in the FBI UCR 2024 release. The counties table holds 2406 rows that match every county with data in the same dataset. States table lists all 51 US jurisdictions, including 50 states plus the District of Columbia. City rows link to states table through the state_fips column, which supports state-level aggregations from city data. Population columns in city_crime table allow per-capita calculations across these 8986 cities using the per-100000 denominator.

City_crime table pairs each of the 8986 cities with 10 distinct crime columns: violent_crime, murder, rape, robbery, aggravated_assault, property_crime, burglary, larceny, motor_vehicle_theft, and arson. County_crime table applies the same structure to its 2406 rows. FBI UCR 2024 release provides the raw counts in these columns without alteration. Developers compute rates by dividing violent_crime totals by population column values and multiplying by 100000. This setup enables direct comparisons between any two cities in the cities table.

Among the 8986 cities, 315 rows show populations above 100000 in the city_crime table population column. These 315 cities deliver stable per-capita rates for violent_crime and property_crime categories. States table state_fips column filters these 315 cities into per-state lists across 51 jurisdictions. FBI Crime Data Explorer lists the agency submissions behind these rows. Methodology page details how city_crime table preserves FBI UCR 2024 release counts exactly while adding rate formulas.

Counties table 2406 rows join to states table via state_fips for county-level views within each of 51 jurisdictions. City_crime table population data supports per-100000 rates for the full 8986 cities, including rollups to 2406 counties. FBI UCR 2024 release defines the submission scope for both tables. Arson column in city_crime table tracks a separate category across all rows, distinct from property_crime totals.

19585 law-enforcement agencies submit to the FBI UCR 2024 release

PlainCrime's agencies table indexes 19585 rows for city police, county sheriffs, and state police submitters to FBI UCR 2024 release. Agencies table links to cities table 8986 rows and counties table 2406 rows through agency identifiers. FBI Crime Data Explorer directory supplies the full list of these 19585 agencies. Each agency row connects to city_crime table or county_crime table for crime counts in violent_crime and property_crime columns.

Agencies table covers submitters for all 51 jurisdictions in states table. City police agencies populate most of the 8986 cities table rows, while county sheriffs fill 2406 counties table rows. FBI UCR 2024 release accepts submissions from these 19585 agencies without gaps in PlainCrime coverage. Population columns in city_crime table pair with agency-submitted violent_crime totals for per-100000 rates on 315 large cities.

State police agencies in agencies table 19585 rows contribute to state_crime table records. Robbery column and aggravated_assault column in city_crime table trace back to specific agencies among the 19585 total. Agency directory queries agencies table by state_fips from states table. FBI National Incident-Based Reporting System documentation outlines submission rules for these agencies.

Murder column and rape column values in city_crime table originate from 19585 agencies table submitters. Counties table 2406 rows aggregate agency data within state_fips boundaries across 51 jurisdictions. FBI UCR 2024 release timestamp matches the agencies table index date. Burglary column rates compute via population in county_crime table for sheriff-led submissions.

561 state-year records span 11 years of state-level trend data

PlainCrime's state_crime table contains 561 rows across 11 years from 2014 through 2024 for all 51 jurisdictions. Each state_crime row includes population column and 10 crime columns matching city_crime table structure. States table state_fips keys join state_crime table to city-level data in 8986 cities. FBI Uniform Crime Reporting 2024 release anchors the 2024 portion of these 561 records. Per-100000 rates derive from violent_crime divided by population in state_crime table.

State_crime table 561 rows track property_crime, burglary, larceny, and motor_vehicle_theft columns year-over-year for 51 jurisdictions. Agencies table 19585 submitters roll up into these state-level totals. FBI UCR 2024 release provides the 2024 snapshot, with prior years from matching releases. Rankings page pulls trends from state_crime table across the 11 years.

Murder and arson columns in state_crime table show changes across 561 rows from 2014 to 2024. Population column in state_crime table enables consistent per-capita views for all 51 states table entries. FBI Crime Data Explorer tracks agency contributions to these state aggregates. Rape and robbery rates compute directly from state_crime table values using the 100000 denominator.

Aggravated_assault column spans the full 561 state-year records in state_crime table. States table covers 51 jurisdictions with no missing years in the 11-year span. FBI National Incident-Based Reporting System documentation supports the column definitions. Categories page breaks out state_crime table columns for comparison.

PlainCrime tables reproduce FBI UCR 2024 release at city_crime level with 8986 cities, county_crime with 2406 counties, and state_crime with 561 state-year records across 51 jurisdictions and 11 years. Agencies table 19585 rows tie submissions to population-enabled per-100000 rates in violent_crime, property_crime, and 8 subcategories. State_fips joins enable rollups from 315 large cities to states table, supporting granular comparisons verbatim from the dataset. About page confirms full coverage without added observations.

Implementation notes for analysts

Practitioners querying PlainCrime's tables should account for several methodological subtleties that affect comparison validity. Coverage discontinuities arise from the 2021 transition between the Summary Reporting System (SRS) and the National Incident-Based Reporting System (NIBRS), where some agencies submitted partial-year data during the migration window. Geographic boundary changes (annexations, incorporations, disincorporations) shift the population denominator without altering the FIPS code, producing apparent rate spikes that reflect administrative reorganization rather than crime trend. Special-jurisdiction agencies (campus police, transit authorities, tribal nations, federal protective services) report through distinct submission channels and appear in the agencies table flagged by submitter_type when present. Hate-crime supplemental tabulations, NIBRS bias-motivation indicators, and victim-offender relationship breakdowns are stored in adjacent tables not enumerated in this overview but accessible through documented joins on incident_id.