Federal Bureau of Investigation


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


Release Frequency



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.


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

Cybersyn Products

Tables above are available in the following Cybersyn data product:

Examples & Sample Queries

Calculate growth rates of different crimes in the US.

    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;


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.

Last updated

Copyright © 2024 Cybersyn