Crime Reports

City of Austin

@usgov.city_of_austin_crime_reports_bf2b7

Table List

1 table(81.95 MB)

Table 1

@usgov.city_of_austin_crime_reports_bf2b7.table_1

81.95 MB
2614910 rows
19 columns

incident_number Incident Number	highest_offense_description Highest Offense Description	highest_offense_code Highest Offense Code	family_violence Family Violence	occurred_date_time Occurred Date Time	occurred_date Occurred Date	report_date_time Report Date Time	report_date Report Date	location_type Location Type	council_district Council District	apd_sector APD Sector	apd_district APD District	clearance_status Clearance Status	clearance_date Clearance Date	ucr_category UCR Category	category_description Category Description	census_block_group Census Block Group
2002923330284	FAMILY DISTURBANCE	3400	N	Wed Jan 29 2003 05:30:00 GMT+0000 (Coordinated Universal Time)	Wed Jan 29 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Nov 29 2002 05:30:00 GMT+0000 (Coordinated Universal Time)	Fri Nov 29 2002 00:00:00 GMT+0000 (Coordinated Universal Time)	RESIDENCE / HOME	6	AD	3	N				4530341003
2003920010029	DEADLY CONDUCT	408	N	Wed Jan 01 2003 00:01:00 GMT+0000 (Coordinated Universal Time)	Wed Jan 01 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jan 01 2003 00:01:00 GMT+0000 (Coordinated Universal Time)	Wed Jan 01 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	RESIDENCE / HOME	4	ID	4	N		13A	Aggravated Assault	4530021123
2003920010046	BURGLARY NON RESIDENCE	502	N	Wed Jan 01 2003 00:02:00 GMT+0000 (Coordinated Universal Time)	Wed Jan 01 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jan 01 2003 00:02:00 GMT+0000 (Coordinated Universal Time)	Wed Jan 01 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	COMMERCIAL / OFFICE BUILDING	2	DA	3		Sat Oct 18 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	220	Burglary	4530024101
2003920010048	DEADLY CONDUCT	408	N	Wed Jan 01 2003 00:03:00 GMT+0000 (Coordinated Universal Time)	Wed Jan 01 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jan 01 2003 00:03:00 GMT+0000 (Coordinated Universal Time)	Wed Jan 01 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	RESIDENCE / HOME	4	ID	2	C	Thu Jan 02 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	13A	Aggravated Assault	4530402001
2003920010049	PUBLIC INTOXICATION	2300	N	Wed Jan 01 2003 00:23:00 GMT+0000 (Coordinated Universal Time)	Wed Jan 01 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jan 01 2003 00:23:00 GMT+0000 (Coordinated Universal Time)	Wed Jan 01 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	HWY / ROAD / ALLEY/ STREET/ SIDEWALK		GE	3	C
2003920010079	RESISTING ARREST OR SEARCH	905	N	Wed Jan 01 2003 00:06:00 GMT+0000 (Coordinated Universal Time)	Wed Jan 01 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jan 01 2003 00:06:00 GMT+0000 (Coordinated Universal Time)	Wed Jan 01 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	RESIDENCE / HOME	3	CH	2	C	Wed Jan 01 2003 00:00:00 GMT+0000 (Coordinated Universal Time)			4530009021
2003920010100	ASSAULT WITH INJURY	900	N	Wed Jan 01 2003 00:08:00 GMT+0000 (Coordinated Universal Time)	Wed Jan 01 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jan 01 2003 00:08:00 GMT+0000 (Coordinated Universal Time)	Wed Jan 01 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	BAR / NIGHTCLUB	9	GE	1	N				4530011022
2003920010127	THEFT- APPROPRIATE STOLEN PROP	1300	N	Wed Jan 01 2003 00:10:00 GMT+0000 (Coordinated Universal Time)	Wed Jan 01 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jan 01 2003 00:10:00 GMT+0000 (Coordinated Universal Time)	Wed Jan 01 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	RESIDENCE / HOME	2	FR	8	C	Fri Jan 24 2003 00:00:00 GMT+0000 (Coordinated Universal Time)			4530024421
2003920010132	PUBLIC INTOXICATION	2300	N	Wed Jan 01 2003 00:11:00 GMT+0000 (Coordinated Universal Time)	Wed Jan 01 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jan 01 2003 00:11:00 GMT+0000 (Coordinated Universal Time)	Wed Jan 01 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	HWY / ROAD / ALLEY/ STREET/ SIDEWALK	9	GE	2	C				4530011032
2003920010139	POSS OF DRUG PARAPHERNALIA	1818	N	Wed Jan 01 2003 00:11:00 GMT+0000 (Coordinated Universal Time)	Wed Jan 01 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jan 01 2003 00:11:00 GMT+0000 (Coordinated Universal Time)	Wed Jan 01 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	HWY / ROAD / ALLEY/ STREET/ SIDEWALK		GE	3	N	Mon Jan 06 2003 00:00:00 GMT+0000 (Coordinated Universal Time)


CREATE TABLE table_1 (
  "incident_number" BIGINT,
  "highest_offense_description" VARCHAR,
  "highest_offense_code" BIGINT,
  "family_violence" VARCHAR,
  "occurred_date_time" TIMESTAMP,
  "occurred_date" TIMESTAMP,
  "occurred_time" DOUBLE,
  "report_date_time" TIMESTAMP,
  "report_date" TIMESTAMP,
  "report_time" DOUBLE,
  "location_type" VARCHAR,
  "council_district" DOUBLE,
  "apd_sector" VARCHAR,
  "apd_district" VARCHAR,
  "clearance_status" VARCHAR,
  "clearance_date" TIMESTAMP,
  "ucr_category" VARCHAR,
  "category_description" VARCHAR,
  "census_block_group" DOUBLE
);