home

vice

Custom SQL query

Department

id, value

46 rows

Fatal

id, value

3 rows

NatureOfStop

id, value

429 rows

OfficerGender

id, value

118 rows

OfficerRace

id, value

249 rows

SubjectArmed

id, value

3 rows

SubjectGender

id, value

7 rows

SubjectRace

id, value

6 rows

ViceNews_FullOISData

Date, NumberOfSubjects, Fatal, SubjectArmed, Notes, SubjectRace, SubjectGender, SubjectAge, NatureOfStop...

4,381 rows

city

id, value

47 rows

ViceNews_FullOISData_fts (hidden)

city, Department, Notes, FullNarrative, NatureOfStop

4,381 rows

ViceNews_FullOISData_fts_docsize (hidden)

docid, size

4,381 rows

ViceNews_FullOISData_fts_segdir (hidden)

level, idx, start_block, leaves_end_block, end_block, root

2 rows

ViceNews_FullOISData_fts_segments (hidden)

blockid, block

229 rows

ViceNews_FullOISData_fts_stat (hidden)

id, value

1 row

Download SQLite DB: vice.db

Powered by Datasette · Query took 0.126ms