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 | 37 | 400 | 2015-01-18T00:00:00Z | 201503003714.00000000 | 3 | 0 | 0 | 0 | 1800 BLOCK S 7th St | 183289 | N | N | N | 1 | -75.15742316 | 39.92649636 | B | M | GeoJSON | 08:27:00 | Leg | 2015 | |
2 | GeoJSON | 33 | 400 | 2015-12-19T00:00:00Z | 201502080513.00000000 | 2 | 0 | 0 | 0 | 7900 BLOCK Bustleton Ave | 183290 | N | N | N | 1 | -75.0524559 | 40.05885237 | B | M | GeoJSON | 00:53:00 | Multiple | 2015 | |
3 | GeoJSON | 40 | 100 | 2015-07-25T00:00:00Z | 201502048013.00000000 | 2 | 1 | 0 | 0 | 500 BLOCK Hill Creek Dr | 183291 | N | N | N | 1 | -75.11001028 | 40.03758222 | B | M | GeoJSON | 12:56:00 | Multiple | 2015 | |
4 | GeoJSON | 23 | 400 | 2015-03-22T00:00:00Z | 201502017572.00000000 | 2 | 0 | 0 | 0 | 900 BLOCK Bridge St | 183292 | N | N | N | 1 | -75.09165101 | 40.03212302 | B | M | GeoJSON | 11:15:00 | Multiple | 2015 | |
5 | GeoJSON | 26 | 100 | 2015-08-15T00:00:00Z | 201512064827.00000000 | 12 | 1 | 0 | 0 | 1500 BLOCK N53RD St | 183293 | N | N | N | 1 | -75.22021764 | 39.93946126 | B | M | GeoJSON | 18:59:00 | Multiple | 2015 | |
6 | GeoJSON | null | null | 2015-07-17T00:00:00Z | 1531.00000000 | 6 | null | null | null | 700 Block of N 8th St | 199933 | N | Y | Y | null | -75.15121557 | 39.9650447 | null | M | GeoJSON | null | null | 2015 | |
7 | GeoJSON | 16 | 100 | 2015-08-09T00:00:00Z | 201512063210.00000000 | 12 | 1 | 0 | 0 | 6300 BLOCK Reedland St | 183294 | N | N | N | 1 | -75.22902876 | 39.92394078 | B | M | GeoJSON | 18:43:00 | Head | 2015 | |
8 | GeoJSON | 53 | 400 | 2015-08-03T00:00:00Z | 201512061421.00000000 | 12 | 0 | 0 | 0 | 6500 BLOCK Elmwood Ave | 183295 | N | N | N | 1 | -75.23128167 | 39.92146265 | B | M | GeoJSON | 15:12:00 | Multiple | 2015 | |
9 | GeoJSON | 24 | 100 | 2015-05-26T00:00:00Z | 201512040640.00000000 | 12 | 1 | 0 | 0 | 5700 BLOCK Greenway Ave | 183296 | N | N | N | 1 | -75.224511 | 39.93441293 | B | M | GeoJSON | 03:24:00 | Multiple | 2015 | |
10 | GeoJSON | 20 | 100 | 2015-05-25T00:00:00Z | 201512040433.00000000 | 12 | 1 | 0 | 0 | 2400 BLOCK S 65th St | 183297 | N | N | N | 1 | -75.23150941 | 39.92317918 | B | M | GeoJSON | 22:09:00 | Multiple | 2015 | |
11 | GeoJSON | 27 | 400 | 2015-05-19T00:00:00Z | 201512038687.00000000 | 12 | 0 | 1 | 0 | 6700 BLOCK Woodland Ave | 183298 | N | N | N | 0 | -75.23735767 | 39.92311583 | B | M | GeoJSON | 10:52:00 | Foot | 2015 | |
12 | GeoJSON | 28 | 400 | 2015-05-05T00:00:00Z | 201512034516.00000000 | 12 | 0 | 0 | 0 | 5400 BLOCK Lindbergh Blvd | 183299 | N | N | N | 1 | -75.21589063 | 39.93224342 | B | M | GeoJSON | 21:20:00 | Stomach | 2015 | |
13 | GeoJSON | null | null | 2015-07-22T00:00:00Z | 1532.00000000 | 8 | null | null | null | 800 Block of Riverside Dr | 199934 | Y | Y | Y | null | -74.98627438 | 40.09688924 | null | M | GeoJSON | null | null | 2015 | |
14 | GeoJSON | null | null | 2015-08-26T00:00:00Z | 1535.00000000 | 18 | null | null | null | 100 Block of S 61st St | 199935 | N | Y | Y | null | -75.24311547 | 39.96067877 | null | M | GeoJSON | null | null | 2015 | |
15 | GeoJSON | null | null | 2015-08-26T00:00:00Z | 1536.00000000 | 14 | null | null | null | 100 Block of E Pastorius St | 199936 | N | N | Y | null | -75.17767422 | 40.04335408 | null | M | GeoJSON | null | null | 2015 | |
16 | GeoJSON | 40 | 400 | 2015-05-05T00:00:00Z | 201512034507.00000000 | 12 | 0 | 0 | 0 | 5400 BLOCK Lindbergh Blvd | 183300 | N | N | N | 1 | -75.21589063 | 39.93224342 | B | M | GeoJSON | 21:20:00 | Leg | 2015 | |
17 | GeoJSON | 23 | 400 | 2015-03-29T00:00:00Z | 201512023262.00000000 | 12 | 0 | 0 | 0 | 6200 BLOCK Dickens Ave | 183301 | N | N | N | 1 | -75.22569095 | 39.92425591 | B | M | GeoJSON | 05:10:00 | Leg | 2015 | |
18 | GeoJSON | null | null | 2015-09-14T00:00:00Z | 1537.00000000 | 22 | null | null | null | 1500 Block of W Lehigh Ave | 199937 | N | N | Y | null | -75.15625732 | 39.99411931 | null | M | GeoJSON | null | null | 2015 | |
19 | GeoJSON | null | null | 2015-01-08T00:00:00Z | 1502.00000000 | 22 | null | null | null | N 32nd St & W Susquehanna Ave | 199938 | N | N | Y | null | -75.18505461 | 39.99001198 | null | M | GeoJSON | null | null | 2015 | |
20 | GeoJSON | 19 | 400 | 2015-03-19T00:00:00Z | 201512020580.00000000 | 12 | 0 | 1 | 0 | 5500 BLOCK Lindbergh Blvd | 183302 | N | N | N | 0 | -75.21704481 | 39.93195857 | B | M | GeoJSON | 15:40:00 | Stomach | 2015 |