FBI

Federal Bureau of Investigation

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

As with all Public Domain datasets, Cybersyn aims to release data on Snowflake Marketplace as soon as the underlying source releases new data. We check periodically for changes to the underlying source and, upon detecting a change, propagate the data to Snowflake Marketplace immediately. See our release process for more details.

Notes

EAV Model: All Cybersyn products follow the EAV (entity, attributes, value) model with a unified schema. Entities are tangible objects (e.g. geography, company) that Cybersyn provides data on. Index tables contain all entities of a certain type. Timeseries tables contain all timeseries' dates and values that refer to an entity type. Additional tables, such as the relationships table and attributes table, are used to describe the entities and timeseries. Data is joinable across all Cybersyn products that have a GEO_ID. Refer to Cybersyn Concepts for more details.

Tables & Sources

Tables	Sources
FBI_CRIME_ATTRIBUTES FBI_CRIME_TIMESERIES	FBI

Cybersyn Products

Tables above are available in the following Cybersyn data product:

• Government Essentials

• Crime Statistics

• Enterprise

Examples & 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 [e-mail] for questions.