Skip to main content

FBI

Overview

The FBI, or Federal Bureau of Investigation, is the principal federal law enforcement agency in the United States, tasked with investigating and enforcing federal laws. Data includes crime totals by offense category across the nation and its 50 states from 1979.

Key Attributes

Geographic CoverageUnited States
Entity LevelCountry, State
Time GranularityAnnual
Release FrequencyAnnual
History1979 onwards

Cybersyn Products

Tables above are available in the following Cybersyn data product:

Sample Queries

Calculate growth rates of different crimes in the US.

SELECT
ts.geo_id,
ts.variable_name,
att.offense_category,
ts.date,
ts.value,
ts.unit,
ROUND((ts.value / LAG(ts.value, 1) OVER (PARTITION BY ts.geo_id, ts.variable_name ORDER BY ts.date) - 1) * 100, 2) AS yoy_change
FROM cybersyn.fbi_crime_timeseries ts
LEFT JOIN cybersyn.fbi_crime_attributes att
ON ts.variable = att.variable
WHERE geo_id = 'country/USA'
QUALIFY date = (SELECT MAX(date) FROM cybersyn.fbi_crime_timeseries)
ORDER BY yoy_change DESC;

Disclaimers

The data in this product is sourced from the FBI.

Cybersyn is not endorsed by or affiliated with any of these providers. Contact support@cybersyn.com for questions.