Urban Crime Incident Log

Snowflake table name : CYBERSYN.URBAN_CRIME_INCIDENT_LOG

View data source documentation here.

Name	Description	Type	Example
GEO_ID	A unique identifier for a place, joinable to the geography_index/relationships tables	VARCHAR	zip/77056
INCIDENT_ID	Unique ID for each incident recorded. Incidents recorded at the offense-level will have multiple rows for each incident_id specifying all offenses committed in the incident.	VARCHAR	houston_149780123
REPORTING_LEVEL	Level of reporting (e.g. Incident, Offense)	VARCHAR	Offense
OFFENSE_CATEGORY	Broad category of the offense (estimated by Cybersyn)	VARCHAR	Theft
ORIGINAL_DESCRIPTION	Description of offense from reporting jurisdiction	VARCHAR	aggravated assault
CODE	Official code classification for the offense	VARCHAR	23C
REPORTING_SYSTEM	Offense classification system used by the jurisdiction (e.g. NIBRS, IUCR)	VARCHAR	National Incident-Based Reporting System (NIBRS)
CITY	City of the reported incident	VARCHAR	New York
DATE	Date of the reported incident	DATE	2023-07-06
PROVENANCE_DOMAIN	Data source domain	VARCHAR	houstontx.gov
PROVENANCE_URL	Data source URL	VARCHAR	https://www.houstontx.gov/police/cs/Monthly_Crime_Data_by_Street...