ETL Pipeline Health
Data Pipeline Status
0 failed · 1 stale · 11 ok
Per-source freshness and outcome for every parser, the Mosser internal Vacancy Report loader, and the Minimum Rents loader. Failures and >2-day stale sources are highlighted. Drill into a specific run via the recent-runs table.
01 / Source freshness
Last run per source
ETL parsers + audit loaders
| Source | Kind | Last Attempt | Last Success | Days Stale | Last Outcome | Duration (s) | Runs (30d) | Last Error |
|---|---|---|---|---|---|---|---|---|
| 2bl | operator | 2026-06-01 13:42:01 UTC | 2026-06-01 13:42:01 UTC | 0 | success | 1.3 | 59 | |
| ai_reflection | craigslist | 2026-05-19 03:18:52 UTC | — | — | skipped | 0.0 | 2 | |
| brick_timber | operator | 2026-06-01 13:42:04 UTC | 2026-06-01 13:42:04 UTC | 0 | success | 25.0 | 59 | |
| craigslist | craigslist | 2026-06-01 13:46:35 UTC | 2026-06-01 13:40:18 UTC | 0 | skipped | 0.0 | 73 | |
| gaetani | operator | 2026-06-01 13:42:03 UTC | 2026-06-01 13:42:03 UTC | 0 | success | 1.2 | 59 | |
| geocode | operator | 2026-06-01 13:46:35 UTC | 2026-06-01 13:46:35 UTC | 0 | success | 199.7 | 47 | |
| mosser | operator | 2026-06-01 13:46:13 UTC | 2026-06-01 13:46:13 UTC | 0 | success | 3.6 | 59 | |
| parkmerced | operator | 2026-06-01 13:42:29 UTC | 2026-06-01 13:42:29 UTC | 0 | success | 5.9 | 59 | |
| rematch_cl | craigslist | 2026-05-14 02:37:37 UTC | 2026-05-14 02:37:37 UTC | 18 | success | 12.1 | 5 | |
| rentals_inc | operator | 2026-06-01 13:46:16 UTC | 2026-06-01 13:46:16 UTC | 0 | success | 18.0 | 59 | |
| rentsfnow | operator | 2026-06-01 13:46:03 UTC | 2026-06-01 13:46:03 UTC | 0 | success | 9.2 | 59 | |
| trinity_sf | operator | 2026-06-01 13:42:35 UTC | 2026-06-01 13:42:35 UTC | 0 | success | 208.1 | 59 |
02 / Recent runs
Last 40 ETL runs across all sources
v_etl_runs_recent
| Started | Source | Outcome | Duration | Seen | +New | ~Upd | =Unch | -Rem | Err | Error |
|---|---|---|---|---|---|---|---|---|---|---|
| 2026-06-01 13:46:35 UTC | geocode | success | 200s | 136 | 136 | 0 | — | — | 0 | |
| 2026-06-01 13:46:35 UTC | craigslist | skipped | 0s | 0 | — | — | — | — | 0 | |
| 2026-06-01 13:46:16 UTC | rentals_inc | success | 18s | 24 | 0 | 0 | 24 | 15 | 0 | |
| 2026-06-01 13:46:13 UTC | mosser | success | 4s | 5 | 0 | 0 | 5 | 0 | 0 | |
| 2026-06-01 13:46:03 UTC | rentsfnow | success | 9s | 12 | 0 | 0 | 12 | 0 | 0 | |
| 2026-06-01 13:42:35 UTC | trinity_sf | success | 208s | 4 | 0 | 1 | 3 | 10 | 0 | |
| 2026-06-01 13:42:29 UTC | parkmerced | success | 6s | 6 | 0 | 0 | 6 | 0 | 0 | |
| 2026-06-01 13:42:04 UTC | brick_timber | success | 25s | 71 | 2 | 0 | 69 | 0 | 0 | |
| 2026-06-01 13:42:03 UTC | gaetani | success | 1s | 10 | 0 | 0 | 10 | 1 | 0 | |
| 2026-06-01 13:42:01 UTC | 2bl | success | 1s | 4 | 0 | 0 | 4 | 0 | 0 | |
| 2026-06-01 13:40:18 UTC | craigslist | success | 1750s | 51 | 51 | 0 | — | — | 0 | |
| 2026-05-31 21:01:55 UTC | craigslist | success | 2823s | 182 | 103 | 79 | — | — | 0 | |
| 2026-05-31 21:01:03 UTC | geocode | success | 236s | 156 | 156 | 0 | — | — | 0 | |
| 2026-05-31 21:01:02 UTC | craigslist | skipped | 0s | 0 | — | — | — | — | 0 | |
| 2026-05-31 21:00:44 UTC | rentals_inc | success | 19s | 39 | 1 | 1 | 37 | 0 | 0 | |
| 2026-05-31 21:00:40 UTC | mosser | success | 3s | 5 | 0 | 0 | 5 | 0 | 0 | |
| 2026-05-31 21:00:31 UTC | rentsfnow | success | 9s | 12 | 0 | 0 | 12 | 0 | 0 | |
| 2026-05-31 20:59:37 UTC | trinity_sf | success | 53s | 11 | 2 | 3 | 6 | 0 | 0 | |
| 2026-05-31 20:59:32 UTC | parkmerced | success | 6s | 6 | 0 | 0 | 6 | 0 | 0 | |
| 2026-05-31 20:59:07 UTC | brick_timber | success | 24s | 69 | 0 | 1 | 68 | 0 | 0 | |
| 2026-05-31 20:59:06 UTC | gaetani | success | 1s | 10 | 0 | 0 | 10 | 0 | 0 | |
| 2026-05-31 20:59:04 UTC | 2bl | success | 1s | 4 | 0 | 0 | 4 | 0 | 0 | |
| 2026-05-31 10:18:27 UTC | craigslist | success | 2249s | 145 | 74 | 71 | — | — | 0 | |
| 2026-05-31 10:17:30 UTC | geocode | success | 207s | 146 | 146 | 0 | — | — | 0 | |
| 2026-05-31 10:17:28 UTC | craigslist | skipped | 0s | 0 | — | — | — | — | 0 | |
| 2026-05-31 10:17:09 UTC | rentals_inc | success | 19s | 28 | 0 | 0 | 28 | 1 | 0 | |
| 2026-05-31 10:17:03 UTC | mosser | success | 5s | 5 | 0 | 0 | 5 | 0 | 0 | |
| 2026-05-31 10:16:53 UTC | rentsfnow | success | 10s | 12 | 0 | 0 | 12 | 0 | 0 | |
| 2026-05-31 10:15:59 UTC | trinity_sf | success | 53s | 11 | 0 | 1 | 10 | 1 | 0 | |
| 2026-05-31 10:15:53 UTC | parkmerced | success | 6s | 6 | 0 | 0 | 6 | 0 | 0 | |
| 2026-05-31 10:15:26 UTC | brick_timber | success | 27s | 69 | 1 | 1 | 67 | 0 | 0 | |
| 2026-05-31 10:15:24 UTC | gaetani | success | 2s | 11 | 0 | 0 | 11 | 1 | 0 | |
| 2026-05-31 10:15:21 UTC | 2bl | success | 2s | 4 | 0 | 0 | 4 | 1 | 0 | |
| 2026-05-30 21:00:33 UTC | craigslist | success | 2290s | 158 | 103 | 55 | — | — | 0 | |
| 2026-05-30 20:57:41 UTC | geocode | success | 209s | 146 | 146 | 0 | — | — | 0 | |
| 2026-05-30 20:57:39 UTC | craigslist | skipped | 0s | 0 | — | — | — | — | 0 | |
| 2026-05-30 20:57:20 UTC | rentals_inc | success | 19s | 28 | 0 | 0 | 28 | 0 | 0 | |
| 2026-05-30 20:57:15 UTC | mosser | success | 5s | 5 | 0 | 0 | 5 | 0 | 0 | |
| 2026-05-30 20:57:04 UTC | rentsfnow | success | 11s | 12 | 0 | 0 | 12 | 0 | 0 | |
| 2026-05-30 20:56:06 UTC | trinity_sf | success | 57s | 10 | 1 | 2 | 7 | 5 | 0 |
03 / Internal data loaders
Vacancy Report + Min Rents
tracked separately from the daily ETL — different cadence
| Source | Loaded At | As Of | Rows | File |
|---|---|---|---|---|
| vacancy_report | 2026-05-21 16:32:44 UTC | 2026-05-20 | 638 | |
| vacancy_report | 2026-05-20 16:33:16 UTC | 2026-05-20 | 638 | |
| vacancy_report | 2026-05-19 16:32:12 UTC | 2026-05-19 | 623 | |
| min_rents | 2026-05-10 22:08:00 UTC | 2026-01-09 | 546 |
Drill-Through
geocode — last 50 runs
46 historical runs
| Started | Outcome | Duration | Seen | +New | ~Upd | =Unch | -Rem | Err | Error |
|---|---|---|---|---|---|---|---|---|---|
| 2026-05-31 21:01:03 UTC | success | 236s | 156 | 156 | 0 | — | — | 0 | |
| 2026-05-31 10:17:30 UTC | success | 207s | 146 | 146 | 0 | — | — | 0 | |
| 2026-05-30 20:57:41 UTC | success | 209s | 146 | 146 | 0 | — | — | 0 | |
| 2026-05-30 10:07:24 UTC | success | 180s | 125 | 125 | 0 | — | — | 0 | |
| 2026-05-29 21:53:59 UTC | success | 213s | 146 | 146 | 0 | — | — | 0 | |
| 2026-05-29 11:30:47 UTC | success | 228s | 156 | 156 | 0 | — | — | 0 | |
| 2026-05-28 21:57:20 UTC | success | 214s | 148 | 148 | 0 | — | — | 0 | |
| 2026-05-28 11:40:34 UTC | success | 214s | 146 | 146 | 0 | — | — | 0 | |
| 2026-05-27 21:56:20 UTC | success | 226s | 159 | 158 | 1 | — | — | 0 | |
| 2026-05-27 11:39:54 UTC | success | 210s | 146 | 145 | 1 | — | — | 0 | |
| 2026-05-27 08:00:57 UTC | success | 189s | 135 | 134 | 1 | — | — | 0 | |
| 2026-05-26 21:46:34 UTC | success | 194s | 136 | 135 | 1 | — | — | 0 | |
| 2026-05-25 21:07:06 UTC | success | 196s | 136 | 134 | 2 | — | — | 0 | |
| 2026-05-25 11:55:18 UTC | success | 206s | 145 | 143 | 2 | — | — | 0 | |
| 2026-05-24 20:56:58 UTC | success | 216s | 146 | 144 | 2 | — | — | 0 | |
| 2026-05-24 09:55:33 UTC | success | 220s | 149 | 147 | 2 | — | — | 0 | |
| 2026-05-23 20:53:08 UTC | success | 205s | 141 | 139 | 2 | — | — | 0 | |
| 2026-05-23 09:53:38 UTC | success | 202s | 145 | 143 | 2 | — | — | 0 | |
| 2026-05-22 21:11:12 UTC | success | 205s | 140 | 138 | 2 | — | — | 0 | |
| 2026-05-22 18:12:12 UTC | success | 205s | 139 | 137 | 2 | — | — | 0 | |
| 2026-05-19 03:12:24 UTC | success | 187s | 129 | 128 | 1 | — | — | 0 | |
| 2026-05-18 20:36:52 UTC | success | 163s | 115 | 114 | 1 | — | — | 0 | |
| 2026-05-18 15:10:15 UTC | success | 194s | 136 | 135 | 1 | — | — | 0 | |
| 2026-05-18 11:33:26 UTC | success | 194s | 136 | 135 | 1 | — | — | 0 | |
| 2026-05-18 09:06:03 UTC | success | 203s | 144 | 143 | 1 | — | — | 0 | |
| 2026-05-18 03:13:26 UTC | success | 198s | 136 | 135 | 1 | — | — | 0 | |
| 2026-05-17 22:55:51 UTC | success | 194s | 137 | 136 | 1 | — | — | 0 | |
| 2026-05-17 20:17:00 UTC | success | 201s | 136 | 135 | 1 | — | — | 0 | |
| 2026-05-17 18:34:11 UTC | success | 201s | 137 | 136 | 1 | — | — | 0 | |
| 2026-05-17 18:33:55 UTC | partial | 312s | 137 | 60 | 77 | — | — | 0 | |
| 2026-05-17 14:34:58 UTC | success | 214s | 144 | 143 | 1 | — | — | 0 | |
| 2026-05-17 08:47:12 UTC | success | 158s | 116 | 115 | 1 | — | — | 0 | |
| 2026-05-17 03:11:32 UTC | success | 216s | 146 | 145 | 1 | — | — | 0 | |
| 2026-05-16 20:15:42 UTC | success | 168s | 125 | 124 | 1 | — | — | 0 | |
| 2026-05-16 14:31:45 UTC | success | 181s | 135 | 134 | 1 | — | — | 0 | |
| 2026-05-16 08:33:46 UTC | success | 186s | 126 | 124 | 2 | — | — | 0 | |
| 2026-05-16 03:10:01 UTC | success | 196s | 136 | 135 | 1 | — | — | 0 | |
| 2026-05-15 20:26:42 UTC | success | 222s | 150 | 149 | 1 | — | — | 0 | |
| 2026-05-15 14:53:28 UTC | success | 189s | 140 | 139 | 1 | — | — | 0 | |
| 2026-05-15 09:01:15 UTC | success | 202s | 153 | 152 | 1 | — | — | 0 | |
| 2026-05-11 15:07:17 UTC | success | 178s | 124 | 124 | 0 | — | — | 0 | |
| 2026-05-10 19:15:30 UTC | success | 0s | 0 | 0 | 0 | — | — | 0 | |
| 2026-05-10 19:01:02 UTC | success | 13s | 7 | 7 | 0 | — | — | 0 | |
| 2026-05-10 18:09:36 UTC | success | 186s | 122 | 122 | 0 | — | — | 0 | |
| 2026-05-10 12:05:30 UTC | success | 18s | 1 | 1 | 0 | — | — | 0 | |
| 2026-05-10 12:05:09 UTC | success | 0s | 0 | 0 | 0 | — | — | 0 |