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 | 29 | 400 | 2019-01-14T00:00:00Z | 201918002985.00000000 | 18 | 0 | 0 | 0 | 4600 BLOCK Walnut St | 270988 | N | N | N | 1 | -75.21476512 | 39.95557155 | B | M | GeoJSON | 09:15:00 | Multiple | 2019 | |
2 | GeoJSON | 23 | 400 | 2019-04-21T00:00:00Z | 201918033013.00000000 | 18 | 0 | 0 | 0 | 100 BLOCK S 49th St | 270989 | N | N | N | 1 | -75.21942252 | 39.95730685 | B | M | GeoJSON | 14:23:00 | Multiple | 2019 | |
3 | GeoJSON | 23 | 400 | 2019-09-08T00:00:00Z | 201918081524.00000000 | 18 | 0 | 0 | 0 | 5200 BLOCK Cedar Ave | 270990 | N | N | N | 1 | -75.22798559 | 39.95065801 | B | M | GeoJSON | 19:29:00 | Ankle | 2019 | |
4 | GeoJSON | 27 | 400 | 2019-11-14T00:00:00Z | 201918105508.00000000 | 18 | 0 | 0 | 0 | 4500 BLOCK Linmore Ave | 270991 | N | N | N | 1 | -75.20751981 | 39.94325911 | B | M | GeoJSON | 22:05:00 | Leg | 2019 | |
5 | GeoJSON | 23 | 3400 | 2020-04-16T00:00:00Z | 202025025755.00000000 | 25 | 1 | 0 | 0 | 700 BLOCK E MADISON ST | 274258 | N | N | N | 1 | -75.11603189 | 39.99772271 | B | M | GeoJSON | 09:49:00 | Multiple/Head | 2020 | |
6 | GeoJSON | 30 | 400 | 2020-09-12T00:00:00Z | 202025059468.00000000 | 25 | 0 | 0 | 1 | 500 BLOCK E COURTLAND ST | 274259 | N | N | N | 1 | -75.1162335 | 40.01884734 | W | M | GeoJSON | 14:57:00 | Multiple | 2020 | |
7 | GeoJSON | 30 | 400 | 2020-08-16T00:00:00Z | 202025053290.00000000 | 25 | 0 | 0 | 0 | 3700 BLOCK N BROAD ST | 274260 | N | N | N | 1 | -75.15092319 | 40.00994861 | B | M | GeoJSON | 04:25:00 | Hand | 2020 | |
8 | GeoJSON | null | 400 | 2020-09-18T00:00:00Z | 202025061069.00000000 | 25 | 0 | 0 | 0 | 2900 BLOCK N ORKNEY ST | 274261 | N | N | N | 1 | -75.1389423 | 39.99559949 | W | M | GeoJSON | 22:54:00 | Multiple | 2020 | |
9 | GeoJSON | 30 | 100 | 2020-09-20T00:00:00Z | 202025061339.00000000 | 25 | 1 | 0 | 0 | 1000 BLOCK W VENAGO ST | 274262 | N | N | N | 1 | -75.14551647 | 40.00687751 | B | M | GeoJSON | 00:39:00 | Chest | 2020 | |
10 | GeoJSON | 36 | 100 | 2020-09-20T00:00:00Z | 202025061339.00000000 | 25 | 0 | 0 | 0 | 1000 BLOCK W VENAGO ST | 274263 | N | N | N | 1 | -75.14551647 | 40.00687751 | B | M | GeoJSON | 00:39:00 | Leg | 2020 | |
11 | GeoJSON | 20 | 400 | 2023-07-29T00:00:00Z | 202322044094.00000000 | 22 | 0 | 0 | 0 | 2900 BLOCK W HARPER ST | 277205 | N | N | N | 1 | -75.18438528 | 39.97423273 | B | M | GeoJSON | 19:19:00 | Multiple | 2023 | |
12 | GeoJSON | 29 | 400 | 2023-03-31T00:00:00Z | 202319017769.00000000 | 19 | 0 | 0 | 0 | 6700 BLOCK W OXFORD ST | 277206 | N | N | N | 1 | -75.25398109 | 39.97692828 | B | M | GeoJSON | 21:03:00 | Multiple | 2023 | |
13 | GeoJSON | 14 | 100 | 2023-03-04T00:00:00Z | 202319011993.00000000 | 19 | 1 | 0 | 0 | 6000 BLOCK HADDINGTON LANE | 277207 | N | N | N | 1 | -75.24055386 | 39.97736472 | B | M | GeoJSON | 20:26:00 | Chest | 2023 | |
14 | GeoJSON | 32 | 3400 | 2023-02-08T00:00:00Z | 202319009330.00000000 | 19 | 0 | 0 | 0 | 5800 BLOCK VINE ST | 277208 | N | N | N | 1 | -75.23599904 | 39.96604581 | B | M | GeoJSON | 16:30:00 | Leg | 2023 | |
15 | GeoJSON | 28 | 100 | 2023-12-10T00:00:00Z | 202322071626.00000000 | 22 | 1 | 0 | 0 | 2200 BLOCK N CHADWICK ST | 277209 | N | N | N | 1 | -75.1605031 | 39.98687393 | B | F | GeoJSON | 04:12:00 | Back | 2023 | |
16 | GeoJSON | 32 | 100 | 2023-12-10T00:00:00Z | 202322071626.00000000 | 22 | 1 | 0 | 0 | 2200 BLOCK N CHADWICK ST | 277210 | N | N | N | 1 | -75.1605031 | 39.98687393 | B | M | GeoJSON | 04:12:00 | Multiple | 2023 | |
17 | GeoJSON | 16 | 400 | 2025-03-01T00:00:00Z | 202512017084.00000000 | 12 | 0 | 0 | 0 | 7200 BLOCK BUIST AVE | 280680 | N | N | N | 1 | -75.2488468 | 39.90457705 | B | M | GeoJSON | 13:28:00 | Hip | 2025 | |
18 | GeoJSON | 14 | 400 | 2024-05-22T00:00:00Z | 202435032158.00000000 | 35 | 0 | 1 | 0 | 6400 BLOCK N BROAD ST | 280681 | N | N | N | 0 | -75.14166336 | 40.05091895 | B | M | GeoJSON | 21:17:00 | Stomach | 2024 | |
19 | GeoJSON | 27 | 400 | 2025-02-28T00:00:00Z | 202522013263.00000000 | 22 | 0 | 0 | 0 | 3000 BLOCK W CUMBERLAND ST | 280682 | N | N | N | 1 | -75.18100614 | 39.9941553 | B | M | GeoJSON | 15:09:00 | Multiple | 2025 | |
20 | GeoJSON | 30 | 400 | 2025-02-03T00:00:00Z | 202539007548.00000000 | 39 | 0 | 0 | 0 | 2200 BLOCK W HUNTING PARK AVE | 280683 | N | N | N | 1 | -75.16538169 | 40.01048791 | B | F | GeoJSON | 20:03:00 | Neck | 2025 |
