Urban Crime Incident Log

Snowflake table name : CYBERSYN.URBAN_CRIME_INCIDENT_LOG

View data sources, attributes, and sample queries here.

Name	Description	Type	Example
GEO_ID	A unique identifier for a place, joinable to the geography_index/relationships tables	VARCHAR	zip/77042
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_cybersyn_id_1196533
REPORTING_LEVEL	Level of reporting (e.g. Incident, Offense)	VARCHAR	Offense
OFFENSE_CATEGORY	Broad category of the offense (estimated by Cybersyn)	VARCHAR	Motor Vehicle Theft
ORIGINAL_DESCRIPTION	Description of offense from reporting jurisdiction	VARCHAR	theft from motor vehicle
CODE	Official code classification for the offense	VARCHAR	290
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	Houston
DATE	Date of the reported incident	DATE	2015-05-07
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...