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 Coverage | United States |
Entity Level | Country, State |
Time Granularity | Annual |
Release Frequency | Annual |
History | 1979 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.