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-06-12 · 5,813,912 rows

Live data from public_cases_fc on phl.carto.com. The time slider below applies the 2025-06-12 to 2026-06-12 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-06-12

Top categories

Lead · #1 of 12 63% of total

Information Request

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

302K

301,966

The other 11 · scale below excludes the leader

  1. Rubbish/Recyclable Material Collection 42K
  2. Maintenance Complaint 37K
  3. Abandoned Vehicle 22K
  4. Illegal Dumping 20K
  5. Salting 15K
  6. Street Defect 13K
  7. Other (Streets) 8.1K
  8. Sanitation Violation 6.9K
  9. Graffiti Removal 6.2K
  10. Street Light Outage 5.7K
  11. Construction Complaints 5.2K

Hour-of-day for "Illegal Dumping"

incidents by hour-of-day
01.3K2.5K3.8K5.0K00: 31801: 25402: 14503: 14104: 5305: 2106: 1307: 1208: 1709: 2910: 14411: 33412: 1,31413: 1,94514: 2,04015: 1,93516: 1,96917: 1,98318: 1,63819: 1,67520: 1,41621: 1,06022: 75023: 488000102030405060708091011121314151617181920212223

Geographic distribution · "Illegal Dumping"

map loads on scroll…

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

median days to close · since 2025-06-12

Response time medians

  1. Traffic Calming Request 119.7d
  2. Smoke Detector 109.2d
  3. Abandoned Vehicle 101.9d
  4. Alley Light Outage 72.3d
  5. Fire Safety Complaint 48.6d
  6. Maintenance Complaint 43.0d
  7. License Complaint 42.9d
  8. Street Light Outage 28.0d
  9. Line Striping 22.0d
  10. Street Defect 14.1d
  11. Digital Navigator Request 8.1d
  12. Traffic (Other) 7.9d

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

% of complaints closed · since 2025-06-12

Closure rates by category

  1. Information Request 100.0%
  2. Salting 100.0%
  3. Shoveling 100.0%
  4. Illegal Dumping 99.3%
  5. Rubbish/Recyclable Material Collection 99.2%
  6. Sanitation Violation 99.1%
  7. Inlet Cleaning 98.7%
  8. Graffiti Removal 98.5%
  9. Traffic Signal Emergency 94.3%
  10. Street Trees 93.1%
  11. Dangerous Sidewalk 93.0%
  12. Street Light Outage 86.1%
  13. Other (Streets) 85.6%
  14. Street Defect 83.8%
  15. Construction Complaints 79.9%
  16. Maintenance Complaint 63.5%
  17. Smoke Detector 60.5%
  18. Traffic (Other) 60.2%
  19. License Complaint 50.1%
  20. Abandoned Vehicle 22.4%

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

median days to close · since 2025-06-12 · all categories

Response time by zip code

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

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