Newman Labs · Houston 311
Houston Signal
A public-data view of what is happening around Houston: one year of observed 311 activity and the current HFD incident snapshot.
- Data through
- 2026-05-28
- Refreshed
- Jul 22 · 05:05 UTC
- Pipeline
- Succeeded
- Retained cases · 365 days
- 44,169 40,343 currently open
- Retained cases · latest 30 days
- 16,476 Up 148.4% from the prior 30 days Prior period: 6,633 · Largest category change: Streets And Traffic (+2,780)
- Closed · latest 30-day cohort
- 35.8% Of requests created in that period
- Median resolution · 90 days
- 2.8 days For requests created in the latest 90 days
Houston Fire Department · active snapshot
86 active incidents
- Fire and alarm calls
- 4
- Latest call opened
- Jul 22 · 23:37
- Snapshot refreshed
- Jul 22 · 23:46 UTC
HFD publishes an incomplete active snapshot. Incidents that start and end between observations may not be captured.
Current call types
-
01EMS EVENT73
-
02CHECK PATIENT*2
-
03FIRE EVENT2
-
04MOTOR VEHICLE INCIDENT2
-
05UNKNOWN EVENT A LEVEL RESPONSE2
-
06CAR FIRE1
Latest 365 days
Retained cases by creation date
Cases currently retained that were created each day and how many have since closed.
Houston's 311 source is a mutable recent-service-request view. Houston Signal preserves cases from its first observation forward; earlier retained counts are not a complete historical total.
Request types
Top request types
Created in the 30 days ending 2026-05-28.
-
01Weeds/Trash/Stagnant Water on Property2,465
-
02Traffic Signal Maintenance1,351
-
03Container Replacement926
-
04Water Leak826
-
05Parking Violation817
-
06Missed Garbage Pickup646
-
07Street Hazard536
-
08New Resident Container517
Geography
Council districts
Request volume in the same 30-day period.
-
CDistrict C2,548
-
DDistrict D2,218
-
HDistrict H2,082
-
BDistrict B2,049
-
IDistrict I1,557
-
KDistrict K1,423
-
ADistrict A1,250
-
EDistrict E934
-
FDistrict F872
-
GDistrict G870
-
JDistrict J629
-
UnknownDistrict Unknown44
Pipeline status
Ingestion and dbt
PostgreSQL records ingestion and dbt status. Prefect schedules and observes each run.
Source health
Latest committed loads
Each source owns its extraction cadence. Both publish through the same PostgreSQL and dbt foundation.
| Source | Status | Completed | Extracted | Changed | Watermark |
|---|---|---|---|---|---|
| HFD active incidents | Succeeded | Jul 22 · 23:46 UTC | 86 | 66 | 2026-07-22 23:37:00+00:00 |
| Houston 311 | Succeeded | Jul 22 · 05:06 UTC | 118,227 | 0 | 2026-05-28 23:06:21+00:00 |
Latest run
No source changes; downstream work skipped.
All 49,248 current cases were unchanged, so dbt was skipped.
- 01Houston 311118,227 snapshots extracted
- 02PostgreSQL0 current cases changed
- 03dbtBuild correctly skipped
- 04Houston SignalDatabase-backed views remain current
dbt scheduler
- Last completed build
- Jul 22, 2026 · 23:46 UTC
- Models in last build
- 4
- Models queued now
- 0
- Failed models
- 0
- Source selector
source:houston.houston_311_request+
Latest row accounting
- Inserted
- 0
- Updated
- 0
- Unchanged
- 49,248
- Expired after 365 days
- 0
- Current watermark
- 2026-05-28 23:06:21+00:00
Database audit
Recent ingestion runs
Audit rows are committed with their source load.
| Completed | Status | Source rows | Load batch | Changed | dbt decision |
|---|---|---|---|---|---|
| Jul 22 · 05:06 | Succeeded | 118,227 | 49,248 | 0 | Skipped · unchanged |
| Jul 21 · 18:07 | Succeeded | 118,227 | 49,248 | 49,248 | Build requested |