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
trinity_sf — last 50 runs
50 historical runs
| Started | Outcome | Duration | Seen | +New | ~Upd | =Unch | -Rem | Err | Error |
|---|---|---|---|---|---|---|---|---|---|
| 2026-05-31 20:59:37 UTC | success | 53s | 11 | 2 | 3 | 6 | 0 | 0 | |
| 2026-05-31 10:15:59 UTC | success | 53s | 11 | 0 | 1 | 10 | 1 | 0 | |
| 2026-05-30 20:56:06 UTC | success | 57s | 10 | 1 | 2 | 7 | 5 | 0 | |
| 2026-05-30 10:00:48 UTC | partial | 362s | 0 | 0 | 0 | 0 | 0 | 0 | |
| 2026-05-29 21:52:28 UTC | success | 55s | 11 | 0 | 4 | 7 | 0 | 0 | |
| 2026-05-29 11:29:16 UTC | success | 52s | 12 | 0 | 0 | 12 | 0 | 0 | |
| 2026-05-28 21:55:54 UTC | success | 52s | 12 | 0 | 2 | 10 | 0 | 0 | |
| 2026-05-28 11:39:05 UTC | success | 53s | 11 | 0 | 0 | 11 | 2 | 0 | |
| 2026-05-27 21:54:54 UTC | success | 54s | 12 | 1 | 2 | 9 | 0 | 0 | |
| 2026-05-27 11:38:26 UTC | success | 53s | 12 | 1 | 0 | 11 | 0 | 0 | |
| 2026-05-27 07:56:55 UTC | success | 208s | 5 | 0 | 0 | 5 | 8 | 0 | |
| 2026-05-26 21:45:09 UTC | success | 53s | 13 | 0 | 0 | 13 | 0 | 0 | |
| 2026-05-25 21:05:39 UTC | success | 53s | 13 | 0 | 1 | 12 | 0 | 0 | |
| 2026-05-25 11:53:47 UTC | success | 54s | 12 | 0 | 0 | 12 | 0 | 0 | |
| 2026-05-24 20:55:33 UTC | success | 52s | 12 | 0 | 0 | 12 | 0 | 0 | |
| 2026-05-24 09:54:08 UTC | success | 52s | 12 | 0 | 0 | 12 | 0 | 0 | |
| 2026-05-23 20:51:39 UTC | success | 53s | 12 | 0 | 4 | 8 | 0 | 0 | |
| 2026-05-23 09:52:19 UTC | success | 51s | 11 | 0 | 4 | 7 | 1 | 0 | |
| 2026-05-22 21:09:40 UTC | success | 53s | 12 | 0 | 5 | 7 | 0 | 0 | |
| 2026-05-22 18:08:11 UTC | success | 207s | 5 | 2 | 3 | 0 | 8 | 0 | |
| 2026-05-19 03:11:00 UTC | success | 52s | 11 | 1 | 10 | 0 | 1 | 0 | |
| 2026-05-18 20:30:15 UTC | partial | 362s | 0 | 0 | 0 | 0 | 0 | 0 | |
| 2026-05-18 15:08:44 UTC | success | 55s | 11 | 0 | 1 | 10 | 0 | 0 | |
| 2026-05-18 11:31:53 UTC | success | 54s | 11 | 0 | 1 | 10 | 0 | 0 | |
| 2026-05-18 09:04:38 UTC | success | 52s | 11 | 0 | 1 | 10 | 0 | 0 | |
| 2026-05-18 03:11:56 UTC | success | 53s | 11 | 0 | 1 | 10 | 1 | 0 | |
| 2026-05-17 22:54:23 UTC | success | 53s | 11 | 0 | 5 | 6 | 0 | 0 | |
| 2026-05-17 20:15:30 UTC | success | 53s | 11 | 0 | 5 | 6 | 0 | 0 | |
| 2026-05-17 18:32:41 UTC | success | 53s | 11 | 0 | 5 | 6 | 0 | 0 | |
| 2026-05-17 18:32:25 UTC | success | 53s | 11 | 0 | 5 | 6 | 0 | 0 | |
| 2026-05-17 14:33:29 UTC | success | 54s | 11 | 0 | 4 | 7 | 0 | 0 | |
| 2026-05-17 08:40:39 UTC | partial | 362s | 0 | 0 | 0 | 0 | 0 | 0 | |
| 2026-05-17 03:10:02 UTC | success | 54s | 12 | 1 | 4 | 7 | 3 | 0 | |
| 2026-05-16 20:14:20 UTC | success | 54s | 11 | 0 | 4 | 7 | 0 | 0 | |
| 2026-05-16 14:30:25 UTC | success | 53s | 11 | 0 | 4 | 7 | 0 | 0 | |
| 2026-05-16 08:32:25 UTC | success | 52s | 11 | 1 | 3 | 7 | 0 | 0 | |
| 2026-05-16 03:08:39 UTC | success | 52s | 11 | 1 | 3 | 7 | 6 | 0 | |
| 2026-05-15 20:25:15 UTC | success | 53s | 12 | 0 | 4 | 8 | 0 | 0 | |
| 2026-05-15 14:52:07 UTC | success | 51s | 12 | 0 | 4 | 8 | 0 | 0 | |
| 2026-05-15 08:59:55 UTC | success | 51s | 11 | 0 | 4 | 7 | 0 | 0 | |
| 2026-05-15 01:32:56 UTC | success | 52s | 13 | 0 | 3 | 10 | 0 | 0 | |
| 2026-05-15 01:31:24 UTC | skipped | 0s | 0 | — | — | — | — | 0 | |
| 2026-05-15 01:28:52 UTC | success | 53s | 13 | 0 | 3 | 10 | 0 | 0 | |
| 2026-05-15 01:27:32 UTC | skipped | 0s | 0 | — | — | — | — | 0 | |
| 2026-05-15 01:24:53 UTC | success | 54s | 13 | 3 | 3 | 7 | 5 | 0 | |
| 2026-05-15 01:22:10 UTC | skipped | 0s | 0 | — | — | — | — | 0 | |
| 2026-05-14 22:36:09 UTC | success | 53s | 13 | 3 | 8 | 2 | 2 | 0 | |
| 2026-05-12 15:05:28 UTC | success | 52s | 9 | 1 | 2 | 6 | 6 | 0 | |
| 2026-05-11 15:05:56 UTC | success | 51s | 14 | 2 | 3 | 9 | 2 | 0 | |
| 2026-05-10 18:52:23 UTC | skipped | 0s | 0 | — | — | — | — | 0 |