cartodb_id_ | the_geom_GEO | age_ | code_ | date__ | dc_key_ | dist_ | fatal_ | inside_ | latino_ | location_ | objectid_ | offender_deceased_ | offender_injured_ | officer_involved_ | outside_ | point_x_ | point_y_ | race_ | sex_ | the_geom_webmercator_GEO | time_ | wound_ | year_ | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | GeoJSON | 23 | 100 | 2015-05-10T00:00:00Z | 201502029653.00000000 | 2 | 1 | 0 | 0 | 6000 BLOCK Colgate St | 133280 | N | N | N | 1 | -75.09998992 | 40.04494111 | B | M | GeoJSON | 09:47:00 | Leg | 2015 | |
2 | GeoJSON | 36 | 400 | 2015-08-25T00:00:00Z | 201514069431.00000000 | 14 | 0 | 0 | 0 | 1300 BLOCK E Sedgwick St | 133281 | N | N | N | 1 | -75.1709004 | 40.07396942 | B | M | GeoJSON | 20:49:00 | Leg | 2015 | |
3 | GeoJSON | 36 | 400 | 2015-08-25T00:00:00Z | 201514069432.00000000 | 14 | 0 | 0 | 0 | 1300 BLOCK E Sedgwick St | 133282 | N | N | N | 1 | -75.1709004 | 40.07396942 | B | M | GeoJSON | 20:49:00 | Stomach | 2015 | |
4 | GeoJSON | 27 | 400 | 2015-07-27T00:00:00Z | 201514059914.00000000 | 14 | 0 | 0 | 0 | 2000 BLOCK Walnut Ln | 133283 | N | N | N | 1 | null | null | B | M | GeoJSON | 13:25:00 | Multiple | 2015 | |
5 | GeoJSON | null | null | 2016-09-09T00:00:00Z | 1629.00000000 | 18 | null | null | null | 200 Block of Millick St | 149881 | N | Y | Y | null | -75.2427489 | 39.95905533 | null | M | GeoJSON | null | null | 2016 | |
6 | GeoJSON | null | null | 2016-09-16T00:00:00Z | 1630.00000000 | 18 | null | null | null | 4800 Block of Sansom St | 149882 | Y | Y | Y | null | -75.21755014 | 39.95670593 | null | M | GeoJSON | null | null | 2016 | |
7 | GeoJSON | 25 | 400 | 2015-10-18T00:00:00Z | 201514084865.00000000 | 14 | 0 | 0 | 0 | 800 BLOCK E Woodlawn St | 133284 | N | N | N | 1 | -75.1636896 | 40.04483896 | B | M | GeoJSON | 15:25:00 | Leg | 2015 | |
8 | GeoJSON | null | null | 2016-09-28T00:00:00Z | 1632.00000000 | 18 | null | null | null | 6300 Block of Hazel Ave | 149883 | Y | Y | Y | null | -75.24848112 | 39.95417168 | null | M | GeoJSON | null | null | 2016 | |
9 | GeoJSON | 36 | 400 | 2015-11-01T00:00:00Z | 201514089443.00000000 | 14 | 0 | 0 | 0 | 100 BLOCK E Tulpehocken St | 133285 | N | N | N | 1 | -75.17826295 | 40.04373925 | B | M | GeoJSON | 00:25:00 | Leg | 2015 | |
10 | GeoJSON | 19 | 400 | 2015-06-27T00:00:00Z | 201514050425.00000000 | 14 | 0 | 0 | 0 | 7400 BLOCK Ogontz Ave | 133286 | N | N | N | 1 | -75.15672084 | 40.06809765 | B | M | GeoJSON | 23:34:00 | Multiple | 2015 | |
11 | GeoJSON | 29 | 400 | 2015-06-26T00:00:00Z | 201514050037.00000000 | 14 | 0 | 0 | 0 | 7800 BLOCK Provident St | 133287 | N | N | N | 1 | -75.16134601 | 40.07241873 | B | M | GeoJSON | 17:05:00 | Stomach | 2015 | |
12 | GeoJSON | 19 | 100 | 2015-12-15T00:00:00Z | 201512098697.00000000 | 12 | 1 | 0 | 0 | 5700 BLOCK Warrington Ave | 133288 | N | N | N | 1 | -75.23046775 | 39.93831464 | B | M | GeoJSON | 17:15:00 | Multiple | 2015 | |
13 | GeoJSON | 23 | 400 | 2015-11-26T00:00:00Z | 201512093525.00000000 | 12 | 0 | 0 | 0 | 2700 BLOCK Bartram Drive | 133289 | N | N | N | 1 | null | null | B | M | GeoJSON | 22:05:00 | Back | 2015 | |
14 | GeoJSON | 45 | 400 | 2015-11-25T00:00:00Z | 201512093277.00000000 | 12 | 0 | 0 | 0 | 900 BLOCK S51st St | 133290 | N | N | N | 1 | -75.22386545 | 39.94657265 | B | M | GeoJSON | 06:14:00 | Head | 2015 | |
15 | GeoJSON | 50 | 100 | 2015-10-12T00:00:00Z | 201512080581.00000000 | 12 | 1 | 1 | 0 | 1100 BLOCK S Ruby St | 133291 | N | N | N | 0 | -75.22574173 | 39.94261466 | B | M | GeoJSON | 23:00:00 | Head | 2015 | |
16 | GeoJSON | 52 | 400 | 2015-08-30T00:00:00Z | 201512068847.00000000 | 12 | 0 | 0 | 0 | 5700 BLOCK Kingsessing Ave | 133292 | N | N | N | 1 | -75.22595975 | 39.9355041 | B | M | GeoJSON | 03:15:00 | Leg | 2015 | |
17 | GeoJSON | 22 | 400 | 2015-08-24T00:00:00Z | 201512067054.00000000 | 12 | 0 | 0 | 0 | 7200 BLOCK Buist Ave | 133293 | N | N | N | 1 | -75.23894696 | 39.91395334 | B | M | GeoJSON | 23:45:00 | Leg | 2015 | |
18 | GeoJSON | 27 | 100 | 2015-07-07T00:00:00Z | 201512053238.00000000 | 12 | 1 | 0 | 0 | 1600 BLOCK S Ithan St | 133294 | N | N | N | 1 | -75.22648676 | 39.93769229 | B | M | GeoJSON | 02:31:00 | Head | 2015 | |
19 | GeoJSON | 33 | 400 | 2015-06-16T00:00:00Z | 201512046839.00000000 | 12 | 0 | 0 | 0 | 5700 BLOCK Malcolm St | 133295 | N | N | N | 1 | -75.23370313 | 39.94161516 | B | M | GeoJSON | 01:25:00 | Foot | 2015 | |
20 | GeoJSON | 25 | 400 | 2015-05-23T00:00:00Z | 201512039689.00000000 | 12 | 0 | 0 | 0 | 5800 BLOCK Hadfield St | 133296 | N | N | N | 1 | -75.2357438 | 39.93994299 | B | M | GeoJSON | 11:23:00 | Multiple | 2015 |
