{
  "total": 3,
  "source": "d1",
  "tracking_since": "2026-10-25T12:38:37.716Z",
  "source_rechecks": {
    "rows": 332,
    "series": 250,
    "last_checked_at": "2026-10-25T13:38:37.000Z",
    "latest_result_counts": {
      "confirmed": 240,
      "unreachable": 5,
      "needs_review": 4,
      "changed": 1
    },
    "method": "Each source URL is fetched and the recorded numbers are looked for in the page (PDFs via pdftotext); anything not confirmed is reviewed by a human. Log: /downloads/price_rechecks.jsonl"
  },
  "observations": [
    {
      "id": "po_20261026_56a2e38a59e9",
      "series_key": "ps_98248a378d4d96b5",
      "kind": "benchmark",
      "use_case_id": "pipe-relining-robot",
      "use_case_ids": [
        "pipe-relining-robot"
      ],
      "provider_id": null,
      "description": "City of St. Peters MO bid 25-152 (FY25 CIPP lining), sanitary lateral reinstatement after lining (done with a robotic cutter), 665 each; the 2 bids were $75 (Insituform) and $700 (SAK) per lateral",
      "low": 75,
      "high": 700,
      "currency": "USD",
      "unit": "per lateral",
      "region": "US-MO",
      "source_url": "https://www.stpetersmo.net/DocumentCenter/View/4971/Bid-Tab-25-152---FY25-CIPP-Lining-PDF?bidId=",
      "as_of": "2025-06-13",
      "observed_at": "2026-10-26T03:32:44.654Z",
      "content_hash": "sha256:56a2e38a59e9420d623389d2b3c359359bd76e012377f9385c268f9de7cda744",
      "supersedes": null,
      "origin": "build",
      "change_reason": null,
      "current": true,
      "usd": {
        "currency": "USD",
        "low": 75,
        "high": 700,
        "note": "Already in target currency; no conversion."
      }
    },
    {
      "id": "po_20261026_c41791b91fe4",
      "series_key": "ps_78decc759d5d4850",
      "kind": "benchmark",
      "use_case_id": "pipe-relining-robot",
      "use_case_ids": [
        "pipe-relining-robot"
      ],
      "provider_id": null,
      "description": "Village of Hoffman Estates IL 2025 sanitary sewer revitalization bid tab, lateral reinstatements after CIPP lining, 360 each; range across the 5 priced columns (bidders and engineer's estimate)",
      "low": 25,
      "high": 250,
      "currency": "USD",
      "unit": "per lateral",
      "region": "US-IL",
      "source_url": "https://www.hoffmanestates.org/25712%20-%20Bid%20Tab.pdf?t=202511191538120",
      "as_of": "2025-11-19",
      "observed_at": "2026-10-26T03:32:44.654Z",
      "content_hash": "sha256:c41791b91fe4a2f21615ea5a8fa485ac9a1c85f16579e6912790bef27a36aa0d",
      "supersedes": null,
      "origin": "build",
      "change_reason": null,
      "current": true,
      "usd": {
        "currency": "USD",
        "low": 25,
        "high": 250,
        "note": "Already in target currency; no conversion."
      }
    },
    {
      "id": "po_20261026_fbceed8eef34",
      "series_key": "ps_7cf68190b6887fff",
      "kind": "benchmark",
      "use_case_id": "pipe-relining-robot",
      "use_case_ids": [
        "pipe-relining-robot"
      ],
      "provider_id": null,
      "description": "City of St. Peters MO bid 25-152, lateral top-hat installation (lateral connection seal installed from inside the main), 70 each; 2 bids",
      "low": 2200,
      "high": 4362,
      "currency": "USD",
      "unit": "per lateral",
      "region": "US-MO",
      "source_url": "https://www.stpetersmo.net/DocumentCenter/View/4971/Bid-Tab-25-152---FY25-CIPP-Lining-PDF?bidId=",
      "as_of": "2025-06-13",
      "observed_at": "2026-10-26T03:32:44.654Z",
      "content_hash": "sha256:fbceed8eef34e09a6d0067a45fc0732dd499eaf82501a6ac6f7c0c56caa04769",
      "supersedes": null,
      "origin": "build",
      "change_reason": null,
      "current": true,
      "usd": {
        "currency": "USD",
        "low": 2200,
        "high": 4362,
        "note": "Already in target currency; no conversion."
      }
    }
  ],
  "series": [
    {
      "series_key": "ps_98248a378d4d96b5",
      "kind": "benchmark",
      "use_case_id": "pipe-relining-robot",
      "provider_id": null,
      "description": "City of St. Peters MO bid 25-152 (FY25 CIPP lining), sanitary lateral reinstatement after lining (done with a robotic cutter), 665 each; the 2 bids were $75 (Insituform) and $700 (SAK) per lateral",
      "currency": "USD",
      "unit": "per lateral",
      "region": "US-MO",
      "source_url": "https://www.stpetersmo.net/DocumentCenter/View/4971/Bid-Tab-25-152---FY25-CIPP-Lining-PDF?bidId=",
      "observations": 1,
      "first_observed_at": "2026-10-26T03:32:44.654Z",
      "last_observed_at": "2026-10-26T03:32:44.654Z",
      "current": true,
      "latest": {
        "low": 75,
        "high": 700,
        "as_of": "2025-06-13",
        "id": "po_20261026_56a2e38a59e9"
      },
      "trend": null,
      "last_rechecked": null
    },
    {
      "series_key": "ps_78decc759d5d4850",
      "kind": "benchmark",
      "use_case_id": "pipe-relining-robot",
      "provider_id": null,
      "description": "Village of Hoffman Estates IL 2025 sanitary sewer revitalization bid tab, lateral reinstatements after CIPP lining, 360 each; range across the 5 priced columns (bidders and engineer's estimate)",
      "currency": "USD",
      "unit": "per lateral",
      "region": "US-IL",
      "source_url": "https://www.hoffmanestates.org/25712%20-%20Bid%20Tab.pdf?t=202511191538120",
      "observations": 1,
      "first_observed_at": "2026-10-26T03:32:44.654Z",
      "last_observed_at": "2026-10-26T03:32:44.654Z",
      "current": true,
      "latest": {
        "low": 25,
        "high": 250,
        "as_of": "2025-11-19",
        "id": "po_20261026_c41791b91fe4"
      },
      "trend": null,
      "last_rechecked": null
    },
    {
      "series_key": "ps_7cf68190b6887fff",
      "kind": "benchmark",
      "use_case_id": "pipe-relining-robot",
      "provider_id": null,
      "description": "City of St. Peters MO bid 25-152, lateral top-hat installation (lateral connection seal installed from inside the main), 70 each; 2 bids",
      "currency": "USD",
      "unit": "per lateral",
      "region": "US-MO",
      "source_url": "https://www.stpetersmo.net/DocumentCenter/View/4971/Bid-Tab-25-152---FY25-CIPP-Lining-PDF?bidId=",
      "observations": 1,
      "first_observed_at": "2026-10-26T03:32:44.654Z",
      "last_observed_at": "2026-10-26T03:32:44.654Z",
      "current": true,
      "latest": {
        "low": 2200,
        "high": 4362,
        "as_of": "2025-06-13",
        "id": "po_20261026_fbceed8eef34"
      },
      "trend": null,
      "last_rechecked": null
    }
  ],
  "note": "Only one observation per series so far: we started recording every price on 2026-10-25 and re-check every source on a schedule. A trend appears when a re-checked source shows a different price (we never overwrite old observations).",
  "pagination": {
    "total": 3,
    "limit": 200,
    "offset": 0,
    "returned": 3,
    "next_offset": null,
    "next": null,
    "prev": null
  },
  "license": "Whirrwork (https://whirrwork.com), CC BY 4.0"
}