Skip to main content

Data Dictionary

Urban Crime AttributesView Source Documentation

PUBLIC_DATA.URBAN_CRIME_ATTRIBUTES: Aggregated crime incident counts by offense category, zip code, and date for major US cities, mapped to standardized offense categories.

Urban Crime Attributes Point-in-Time HistoryView Source Documentation

PUBLIC_DATA.URBAN_CRIME_ATTRIBUTES_PIT: Tracks history of the urban_crime_attributes table with start and end timestamps to indicate row validity periods.

Urban Crime Incident LogView Source Documentation

PUBLIC_DATA.URBAN_CRIME_INCIDENT_LOG: Crime event data for major US cities, mapped to broad offense categories, provided by city police departments. Includes reporting level, offense details, classification codes, and data provenance.

Urban Crime Incident Log Point-in-Time HistoryView Source Documentation

PUBLIC_DATA.URBAN_CRIME_INCIDENT_LOG_PIT: Tracks history of the urban_crime_incident_log table with start and end timestamps to indicate row validity periods.

Urban Crime TimeseriesView Source Documentation

PUBLIC_DATA.URBAN_CRIME_TIMESERIES: Historical crime data from major US cities' police departments, aggregated by offense category, zip code, and date.

Urban Crime Timeseries Point-in-Time HistoryView Source Documentation

PUBLIC_DATA.URBAN_CRIME_TIMESERIES_PIT: Tracks history of the urban_crime_timeseries table with start and end timestamps to indicate row validity periods.