# Chat Transcript
## Philadelphia Area Incidents Summary Statistics

👤 **User**  
Provide summary statistics about incidents reported in the Philadelphia area.

---

🧠 **Assistant**  

Based on the **Neighborhood Information Knowledge Graph (NIKG)**, here are the summary statistics for incidents reported in the Philadelphia area:

### Overall Incident Counts

| Metric | Count |
|--------|-------|
| **Total Incidents** | 15,328 |
| **Fatal Incidents** | 3,163 (20.6%) |
| **Officer-Involved Incidents** | 123 (0.8%) |
| **Offender Deceased** | 35 |
| **Offender Injured** | 85 |

### Offender Demographics

**By Sex:**
- Male (Q6581097): 13,755 incidents (89.7%)
- Female (Q6581072): 1,573 incidents (10.3%)

**By Race:**
- African American/Black (Q49085): 12,477 incidents (81.4%)
- White (Q49078): 2,609 incidents (17.0%)
- Asian (Q16263328): 109 incidents
- Other/Mixed (Q24238356): 10 incidents
- Not Available: 123 incidents

**Age Distribution:**
- 15,093 incidents have recorded offender ages
- The most common ages are 20-25 years old, with peak at age 21 (754 incidents)
- Ages 18-30 account for the majority of incidents
- Notable youth involvement: ages 16-17 represent 802 incidents

### Geographic Distribution

Incidents are distributed across **361 unique locations** (census tracts). The top 10 census tracts with highest incident counts are:

1. CT_17701: 456 incidents
2. CT_17602: 284 incidents
3. CT_17702: 283 incidents
4. CT_17500: 218 incidents
5. CT_20400: 203 incidents
6. CT_30000: 199 incidents
7. CT_17800: 198 incidents
8. CT_18800: 185 incidents
9. CT_17201: 168 incidents
10. CT_9400: 159 incidents

These statistics reveal that incidents in Philadelphia are predominantly involving young adult males, with significant geographic clustering in certain census tracts.

---

*Created by [mcp-proto-okn](https://github.com/sbl-sdsc/mcp-proto-okn) 0.4.0 using claude-opus-4-5-20251101 on 2025-12-21*
