Step 5 · Runs every morning
Each source judged against its own cadence
When a source is down, it shows as down — not as “no activity”.
Snapshot · 2026-10-16
| Source | Cadence | Mode | Last fetch / newest | Status | Rows dropped |
|---|---|---|---|---|---|
| TX RRC Drilling Permit Master+Trailer (Daily)Railroad Commission of Texas | nightly | Snapshot onlysnapshot only: download needs a stateful GoAnywhere session (SOURCES.md #1) | Snapshot 2026-10-16Newest: 2026-10-15 | OK | — |
| TCEQ NSR Pending Air Permit ApplicationsTexas Commission on Environmental Quality | weekly (republished as noticed) | Snapshot onlysnapshot only in v0: HTML report on a migration path (SOURCES.md #3) | Snapshot 2026-10-16Newest: 2026-09-25 | OK | — |
| TxDOT Bid TabulationsTexas Department of Transportation | per letting (effectively daily) | Live-capable · Snapshot selecteddata.texas.gov Socrata SODA, no key | Snapshot 2026-10-16Newest: 2026-10-15 | OK | — |
| TxDOT Plan HoldersTexas Department of Transportation | daily, rolling snapshot | Live-capable · Snapshot selecteddata.texas.gov Socrata SODA, no key | Snapshot 2026-10-16Newest: 2026-10-16 | OK | — |
| SBA 7(a)/504 FOIA loan dataU.S. Small Business Administration | quarterly | Snapshot onlysnapshot only: 181 MB quarterly CSV | Snapshot 2026-10-16Newest: 2026-06-30 | Quarterly · as of 2026-06-30 | — |
| EPA ECHO formal enforcement, TX + LAU.S. Environmental Protection Agency | weekly | Live-capable · Snapshot selectedechodata.epa.gov REST, no key, two-step QID | Snapshot 2026-10-16Newest: 2026-10-16 | OK | — |
| Louisiana DEQ EDMS enforcement documentsLouisiana Department of Environmental Quality | daily, 4-7 day posting lag | Snapshot onlysnapshot only: unattributed rows (no company name) | Snapshot 2026-10-16Newest: 2026-10-16 | OK | — |
| TCEQ Notices of ViolationTexas Commission on Environmental Quality | monthly | Live-capable · Snapshot selecteddata.texas.gov Socrata SODA, no key | Snapshot 2026-10-16Newest: 2026-09-29 | OK | — |
| TCEQ Notices of EnforcementTexas Commission on Environmental Quality | daily | Live-capable · Snapshot selecteddata.texas.gov Socrata SODA, no key | Snapshot 2026-10-16Newest: 2026-10-01 | OK | — |
| TCEQ Water Quality General PermitsTexas Commission on Environmental Quality | daily | Live-capable · Snapshot selecteddata.texas.gov Socrata SODA, no key | Snapshot 2026-10-16Newest: 2026-10-15 | OK | — |
| TCEQ Water Quality Individual PermitsTexas Commission on Environmental Quality | daily | Live-capable · Snapshot selecteddata.texas.gov Socrata SODA, no key | Snapshot 2026-10-16Newest: 2026-10-08 | OK | — |
| TCEQ Aggregate Production OperationsTexas Commission on Environmental Quality | daily | Live-capable · Snapshot selecteddata.texas.gov Socrata SODA, no key | Snapshot 2026-10-16Newest: 2026-10-15 | OK | — |
| TX Active Sales Tax Permit HoldersTexas Comptroller of Public Accounts | weekly | Live-capable · Snapshot selecteddata.texas.gov Socrata SODA, no key | Snapshot 2026-10-16Newest: 2026-10-10 | OK | — |
| TX Active Franchise TaxpayersTexas Comptroller of Public Accounts | weekly | Live-capable · Snapshot selecteddata.texas.gov Socrata SODA, no key | Snapshot 2026-10-16Newest: 2026-10-16 | OK | — |
| TCEQ Air Emission Events (/oce/eer/)Texas Commission on Environmental Quality | unverified | Snapshot onlyblocked (401) | — (no rows) | Unreachable · 401 | — |
- TX RRC Drilling Permit Master+Trailer (Daily)OK
Railroad Commission of Texas
- Cadence
- nightly
- Last fetch / newest
- Snapshot 2026-10-16Newest: 2026-10-15
- Mode
- Snapshot only · snapshot only: download needs a stateful GoAnywhere session (SOURCES.md #1)
- Rows dropped
- —
- TCEQ NSR Pending Air Permit ApplicationsOK
Texas Commission on Environmental Quality
- Cadence
- weekly (republished as noticed)
- Last fetch / newest
- Snapshot 2026-10-16Newest: 2026-09-25
- Mode
- Snapshot only · snapshot only in v0: HTML report on a migration path (SOURCES.md #3)
- Rows dropped
- —
- TxDOT Bid TabulationsOK
Texas Department of Transportation
- Cadence
- per letting (effectively daily)
- Last fetch / newest
- Snapshot 2026-10-16Newest: 2026-10-15
- Mode
- Live-capable · Snapshot selected · data.texas.gov Socrata SODA, no key
- Rows dropped
- —
- TxDOT Plan HoldersOK
Texas Department of Transportation
- Cadence
- daily, rolling snapshot
- Last fetch / newest
- Snapshot 2026-10-16Newest: 2026-10-16
- Mode
- Live-capable · Snapshot selected · data.texas.gov Socrata SODA, no key
- Rows dropped
- —
- SBA 7(a)/504 FOIA loan dataQuarterly · as of 2026-06-30
U.S. Small Business Administration
- Cadence
- quarterly
- Last fetch / newest
- Snapshot 2026-10-16Newest: 2026-06-30
- Mode
- Snapshot only · snapshot only: 181 MB quarterly CSV
- Rows dropped
- —
- EPA ECHO formal enforcement, TX + LAOK
U.S. Environmental Protection Agency
- Cadence
- weekly
- Last fetch / newest
- Snapshot 2026-10-16Newest: 2026-10-16
- Mode
- Live-capable · Snapshot selected · echodata.epa.gov REST, no key, two-step QID
- Rows dropped
- —
- Louisiana DEQ EDMS enforcement documentsOK
Louisiana Department of Environmental Quality
- Cadence
- daily, 4-7 day posting lag
- Last fetch / newest
- Snapshot 2026-10-16Newest: 2026-10-16
- Mode
- Snapshot only · snapshot only: unattributed rows (no company name)
- Rows dropped
- —
- TCEQ Notices of ViolationOK
Texas Commission on Environmental Quality
- Cadence
- monthly
- Last fetch / newest
- Snapshot 2026-10-16Newest: 2026-09-29
- Mode
- Live-capable · Snapshot selected · data.texas.gov Socrata SODA, no key
- Rows dropped
- —
- TCEQ Notices of EnforcementOK
Texas Commission on Environmental Quality
- Cadence
- daily
- Last fetch / newest
- Snapshot 2026-10-16Newest: 2026-10-01
- Mode
- Live-capable · Snapshot selected · data.texas.gov Socrata SODA, no key
- Rows dropped
- —
- TCEQ Water Quality General PermitsOK
Texas Commission on Environmental Quality
- Cadence
- daily
- Last fetch / newest
- Snapshot 2026-10-16Newest: 2026-10-15
- Mode
- Live-capable · Snapshot selected · data.texas.gov Socrata SODA, no key
- Rows dropped
- —
- TCEQ Water Quality Individual PermitsOK
Texas Commission on Environmental Quality
- Cadence
- daily
- Last fetch / newest
- Snapshot 2026-10-16Newest: 2026-10-08
- Mode
- Live-capable · Snapshot selected · data.texas.gov Socrata SODA, no key
- Rows dropped
- —
- TCEQ Aggregate Production OperationsOK
Texas Commission on Environmental Quality
- Cadence
- daily
- Last fetch / newest
- Snapshot 2026-10-16Newest: 2026-10-15
- Mode
- Live-capable · Snapshot selected · data.texas.gov Socrata SODA, no key
- Rows dropped
- —
- TX Active Sales Tax Permit HoldersOK
Texas Comptroller of Public Accounts
- Cadence
- weekly
- Last fetch / newest
- Snapshot 2026-10-16Newest: 2026-10-10
- Mode
- Live-capable · Snapshot selected · data.texas.gov Socrata SODA, no key
- Rows dropped
- —
- TX Active Franchise TaxpayersOK
Texas Comptroller of Public Accounts
- Cadence
- weekly
- Last fetch / newest
- Snapshot 2026-10-16Newest: 2026-10-16
- Mode
- Live-capable · Snapshot selected · data.texas.gov Socrata SODA, no key
- Rows dropped
- —
- TCEQ Air Emission Events (/oce/eer/)Unreachable · 401
Texas Commission on Environmental Quality
- Cadence
- unverified
- Last fetch / newest
- — (no rows)
- Mode
- Snapshot only · blocked (401)
- Rows dropped
- —
Daily 6:00 AM CT ingestion
Coming next — workflow built, enablement pendingLast ingestion: source census 2026-10-16