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:

• Global Government
• US Crime
• Cybersyn Foundations - PAID

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 snowflake-public-data@snowflake.com for questions.