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-11-03 · 5,989,519 rows

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

Top categories

Lead · #1 of 12 66% of total

Information Request

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

295K

294,992

The other 11 · scale below excludes the leader

  1. Rubbish/Recyclable Material Collection 37K
  2. Maintenance Complaint 33K
  3. Salting 15K
  4. Abandoned Vehicle 15K
  5. Illegal Dumping 14K
  6. Street Defect 11K
  7. Other (Streets) 8.2K
  8. Sanitation Violation 6.3K
  9. Shoveling 4.8K
  10. License Complaint 4.4K
  11. Street Trees 4.4K

Hour-of-day for "Illegal Dumping"

incidents by hour-of-day
05001.0K1.5K2.0K00: 9901: 9502: 6103: 5004: 2105: 1206: 607: 508: 809: 710: 2511: 7412: 91913: 1,45714: 1,54315: 1,57116: 1,48417: 1,45618: 1,27319: 1,41520: 98621: 76622: 45923: 242000102030405060708091011121314151617181920212223

Geographic distribution · "Illegal Dumping"

map loads on scroll…

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

median days to close · since 2025-11-03

Response time medians

  1. Abandoned Vehicle 100.2d
  2. Smoke Detector 98.3d
  3. Traffic Calming Request 93.1d
  4. Alley Light Outage 76.0d
  5. Fire Safety Complaint 55.8d
  6. Maintenance Complaint 41.0d
  7. License Complaint 35.4d
  8. Line Striping 21.0d
  9. Street Light Outage 17.0d
  10. Street Defect 12.1d
  11. Traffic (Other) 7.8d
  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-11-03

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.4%
  6. Rubbish/Recyclable Material Collection 99.2%
  7. Illegal Dumping 99.0%
  8. Sanitation Violation 98.8%
  9. Graffiti Removal 97.3%
  10. Dangerous Sidewalk 93.0%
  11. Street Light Outage 91.1%
  12. Traffic Signal Emergency 90.7%
  13. Smoke Detector 90.1%
  14. Street Defect 87.6%
  15. Other (Streets) 86.5%
  16. Construction Complaints 80.5%
  17. Maintenance Complaint 53.6%
  18. Traffic (Other) 53.6%
  19. License Complaint 50.6%
  20. Abandoned Vehicle 20.8%

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

median days to close · since 2025-11-03 · all categories

Response time by zip code

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

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