Stolen Guns

City of Bloomington

@usgov.city_of_bloomington_stolen_guns_b43e8

Table List

1 table(21.19 KB)

Table 1

@usgov.city_of_bloomington_stolen_guns_b43e8.table_1

21.19 KB
466 rows
10 columns

property_number Property Number	case_number Case Number	stolen_date Stolen Date	brand Brand	model Model	color Color	status Status	stolen_from Stolen From	recovery Recovery	agency Agency
P13827	B16-00694	Wed Jan 06 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	HI POINT	9MM	BLK	STOLEN LOCALLY	RESIDENCE	RECOVERED LOCALLY	BPD
P14174	B16-01892	Fri Jan 15 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	JENNINGS J22		COM	STOLEN LOCALLY	RESIDENCE	NOT RECOVERED	BPD
P14377	B16-03125	Sun Jan 24 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	CENTURY ARMS	M92		STOLEN LOCALLY	RESIDENCE	RECOVERED LOCALLY	BPD
P14707	B16-05095	Mon Feb 08 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	TAURUS	PT740 SLIM		STOLEN LOCALLY	RESIDENCE	NOT RECOVERED	BPD
P15042	B16-06990	Tue Feb 23 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	HIGHPOINT	CARBINE		STOLEN LOCALLY	RESIDENCE	RECOVERED LOCALLY	BPD
P15043	B16-06990	Tue Feb 23 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	RUGAR			STOLEN LOCALLY	RESIDENCE	RECOVERED LOCALLY	BPD
P15556	B16-08308	Fri Mar 18 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	HENRY ARMS	.17 CALIBRE		STOLEN LOCALLY	RESIDENCE	RECOVERED LOCALLY	BPD
P16026	B16-12278	Sat Apr 02 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	EAA		BLK	STOLEN LOCALLY	RESIDENCE	RECOVERED LOCALLY	BPD
P16080	B16-13074	Fri Apr 08 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	BUSHMASTER	CARBON-15		STOLEN LOCALLY	RESIDENCE	NOT RECOVERED	BPD
P16081	B16-13074	Fri Apr 08 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	GLOCK	17		STOLEN LOCALLY	RESIDENCE	RECOVERED OTHER	BPD


CREATE TABLE table_1 (
  "property_number" VARCHAR,
  "case_number" VARCHAR,
  "stolen_date" TIMESTAMP,
  "brand" VARCHAR,
  "model" VARCHAR,
  "color" VARCHAR,
  "status" VARCHAR,
  "stolen_from" VARCHAR,
  "recovery" VARCHAR,
  "agency" VARCHAR
);