data . willkara
dataset · OpenDataPhilly via Carto

Philly 311 service requests

Live snapshot of the City of Philadelphia's 311 service-and-information requests, queried directly against phl.carto.com through our Cloudflare worker proxy.

data through 2026-09-04 · 5,923,813 rows

Live data from public_cases_fc on phl.carto.com. The time slider below applies the 2025-09-04 to 2026-09-04 window to every chart on this tab. The hour-of-day and map are additionally filtered to category Illegal Dumping; use the Filters tab to override the category and zipcode.

Time window

2014-01-01 – 2014-01-01

Drag either thumb to scrub; press play to advance the upper bound a month at a time. URL deep-links the window — ?since=YYYY-MM-DD&until=YYYY-MM-DD round-trips on refresh.

incidents by category · since 2025-09-04

Top categories

Lead · #1 of 12 65% of total

Information Request

Acts as a public information desk — many calls are routed here when residents aren't sure who else to ask.

303K

303,245

The other 11 · scale below excludes the leader

  1. Rubbish/Recyclable Material Collection 37K
  2. Maintenance Complaint 34K
  3. Abandoned Vehicle 18K
  4. Illegal Dumping 16K
  5. Salting 15K
  6. Street Defect 11K
  7. Other (Streets) 8.5K
  8. Sanitation Violation 6.5K
  9. Shoveling 4.8K
  10. Construction Complaints 4.7K
  11. License Complaint 4.7K

Hour-of-day for "Illegal Dumping"

incidents by hour-of-day
05001.0K1.5K2.0K00: 17101: 16002: 7703: 9604: 3005: 1306: 1007: 408: 609: 1110: 4111: 11912: 1,01013: 1,55614: 1,63215: 1,61816: 1,60017: 1,73618: 1,40719: 1,49320: 1,12621: 80222: 55523: 300000102030405060708091011121314151617181920212223

Geographic distribution · "Illegal Dumping"

map loads on scroll…

586 grid cells · server-aggregated via ST_SnapToGrid(the_geom, 0.005) · only cells with >5 incidents shown

median days to close · since 2025-09-04

Response time medians

  1. Smoke Detector 117.2d
  2. Traffic Calming Request 117.0d
  3. Abandoned Vehicle 103.0d
  4. Alley Light Outage 72.3d
  5. Fire Safety Complaint 52.1d
  6. Maintenance Complaint 40.0d
  7. License Complaint 35.4d
  8. Street Light Outage 21.0d
  9. Line Striping 20.3d
  10. Street Defect 10.9d
  11. Traffic (Other) 8.0d
  12. Digital Navigator Request 7.0d

percentile_cont(0.5) over (closed_datetime − requested_datetime); only categories with >100 closed cases shown

% of complaints closed · since 2025-09-04

Closure rates by category

  1. Information Request 100.0%
  2. Salting 100.0%
  3. Shoveling 100.0%
  4. Street Trees 99.8%
  5. Inlet Cleaning 99.0%
  6. Rubbish/Recyclable Material Collection 98.5%
  7. Illegal Dumping 98.5%
  8. Graffiti Removal 98.4%
  9. Sanitation Violation 98.0%
  10. Smoke Detector 93.6%
  11. Dangerous Sidewalk 92.9%
  12. Traffic Signal Emergency 92.4%
  13. Street Light Outage 90.2%
  14. Other (Streets) 85.5%
  15. Street Defect 83.1%
  16. Construction Complaints 80.7%
  17. Traffic (Other) 57.2%
  18. Maintenance Complaint 55.4%
  19. License Complaint 52.2%
  20. Abandoned Vehicle 20.6%

share of complaints with status = 'Closed'; categories with >500 tickets shown

median days to close · since 2025-09-04 · all categories

Response time by zip code

  1. 19124 6.0d
  2. 19152 6.0d
  3. 19153 5.8d
  4. 19120 5.7d
  5. 19134 5.3d
  6. 19137 5.1d
  7. 19135 5.1d
  8. 19140 4.9d
  9. 19111 4.8d
  10. 19115 4.8d
  11. 19136 4.7d
  12. 19141 4.7d
  13. 19142 4.6d
  14. 19149 4.6d
  15. 19143 4.5d
  16. 19116 4.1d
  17. 19139 4.1d
  18. 19126 4.1d
  19. 19104 4.0d
  20. 19114 4.0d
  21. 19118 3.9d
  22. 19145 3.9d
  23. 19131 3.9d
  24. 19132 3.9d
  25. 19144 3.9d
  26. 19148 3.9d
  27. 19121 3.8d
  28. 19138 3.8d
  29. 19122 3.7d
  30. 19147 3.7d
  31. 19106 3.7d
  32. 19119 3.7d
  33. 19133 3.7d
  34. 19151 3.7d
  35. 19125 3.7d
  36. 19146 3.6d
  37. 19129 3.6d
  38. 19130 3.6d
  39. 19123 3.6d
  40. 19107 3.5d
  41. 19103 3.3d
  42. 19102 3.0d
  43. 19128 2.8d
  44. 19154 2.8d
  45. 19150 2.7d
  46. 19127 2.6d

zip codes with >50 closed complaints; slowest at top — are these random, or a pattern?