# Phase 6 Stage B2 — SoonerStart public data acquisition and import

Checked November 9, 2026. Scope covers every document linked from the official [SoonerStart Data and Reporting page](https://oklahoma.gov/education/services/soonerstart/soonerstart-data-and-reporting.html). Only nonproduction tests were run. No database migration was applied, no data was written to production, and no agency was contacted.

## Summary

- **Inventory.** The page linked **21 official PDFs**. All 21 returned HTTP 200 and were hashed. **20 were fully transcribed** from their text layers. One, the *Part C Site Determinations 2024-2025* (`site-det-2024-25`, 20 pages), is **image-only**: it was retrieved and hashed but **not transcribed**, because no OCR was performed and an unchecked OCR transcription could not be verified. No other linked document failed to download.
- **Records.** **1,469 aggregate records** were extracted. **1,351 are VERIFIED PUBLIC DATA**: each value was matched to its cited PDF page and, where counts are published, recomputed. **118 are on QUALITY HOLD**: they are kept for review, but the public endpoint removes their values.
- **Checks.** **491 automated checks** ran: 485 PASS and 6 FAIL. Every FAIL is an intended discrepancy that produced a quality hold (listed below). There were no unexpected failures.
- **Coverage.** Data run from FFY 2017 to FFY 2024 statewide. FFY 2017–2021 are percentages republished in a later report's historical tables; FFY 2022–2024 come from the full SPP/APRs. Local data cover 12 service districts (2022–23 and 2023–24) and 27 local sites (2021–22).
- **Completeness.** This is **not** a claim that all SoonerStart public data have been acquired. It covers the linked documents on one official index page as of the check date. SPP/APRs before FFY 2022, district profiles before 2021–22, child-count and exiting releases not linked on the page, and the 2024–25 child count were not available there. They are recorded as missing, not as nonexistent.

## 1–2. Official source inventory and retrieval manifest

Full machine-readable manifest: [source-inventory.json](source-inventory.json). It lists the URL, HTTP status, bytes, SHA-256, server Last-Modified, ETag, page count, text-layer pages, retrieval time and processing status. Source version is `sha256:<first 16 hex>`. Publication dates are not printed in most documents, so the server Last-Modified header is recorded as the revision indicator only. The FFY 2024 Part C SPP/APR hash matches the earlier Stage B2 retrieval exactly (`d9d7f0d7…`).

| ID | Title as linked | Reporting label | Coverage | Pages (text layer) | Server last-modified | SHA-256 | Records verified / held | Processing |
|---|---|---|---|---|---|---|---:|---|
| `spp-c-ffy2024` | [Oklahoma's Part C, SPP/APR FFY 2024](https://oklahoma.gov/content/dam/ok/en/osde/documents/services/soonerstart/data-reporting/SPP%20APR%20FFY24.pdf) | FFY 2024 | statewide | 66 (66) | Thu, 04 Jun 2026 15:46:50 GMT | `d9d7f0d71bfe791d1a877fbe07427411259b505159b56bb36c285c02724c083e` | 38 / 5 | extracted |
| `spp-c-ffy2023` | [Oklahoma's Part C, SPP/APR FFY 2023](https://oklahoma.gov/content/dam/ok/en/osde/documents/services/soonerstart/data-reporting/OK-01%20SPP%20PART%20C%20FFY%202023-24.pdf) | FFY 2023 | statewide | 80 (80) | Wed, 22 Apr 2026 03:22:59 GMT | `c5174f9712eee6970d919e424cf0c2e64cf6533658f5c3e0159b7a7b83b08853` | 42 / 0 | extracted |
| `spp-c-ffy2022` | [Oklahoma's Part C, SPP/APR FFY 2022](https://oklahoma.gov/content/dam/ok/en/osde/documents/services/soonerstart/data-reporting/Oklahoma_Part_C_SPPAPR_FFY_2022.pdf) | FFY 2022 | statewide | 69 (69) | Mon, 15 Jul 2024 16:45:05 GMT | `04ad957fb1dfa85a88f1c4d2832438d1ddffbaba1be63c9b8829cc328d028ff5` | 125 / 0 | extracted |
| `osep-det-2021` | [Oklahoma's Part C, IDEA Determination FFY 2021](https://oklahoma.gov/content/dam/ok/en/osde/documents/services/soonerstart/data-reporting/OK_Part_C_IDEA_Determination_FFY_2021.pdf) | 2021 determination (FFY 2019 SPP/APR) | statewide | 3 (3) | Mon, 15 Jul 2024 16:54:24 GMT | `cf341054bce232c2ad10aa156903722445cf55aab53258f0af47454c629b9118` | 1 / 0 | extracted |
| `osep-det-2022` | [Oklahoma's Part C, IDEA Determination FFY 2022](https://oklahoma.gov/content/dam/ok/en/osde/documents/services/soonerstart/data-reporting/OK_Part_C_IDEA_Determination_FFY_2022.pdf) | 2022 determination (FFY 2020 SPP/APR) | statewide | 4 (4) | Mon, 15 Jul 2024 16:54:24 GMT | `b812bd2ffa49db9d1def53ad55bdcd986819d15bed720e74ee2cde900c8bde98` | 1 / 0 | extracted |
| `osep-det-2023` | [Oklahoma's Part C, IDEA Determination FFY 2023](https://oklahoma.gov/content/dam/ok/en/osde/documents/services/soonerstart/data-reporting/OK_Part_C_IDEA_Determination_FFY_2023.pdf) | 2023 determination (FFY 2021 SPP/APR) | statewide | 4 (4) | Mon, 15 Jul 2024 16:54:24 GMT | `a42414beb50c7a699384a8b3207aa6a604d5ef52f6ec949ebb2ce2265850ed1a` | 1 / 0 | extracted |
| `site-det-2024-25` | [Part C Site Determinations 2024-2025](https://oklahoma.gov/content/dam/ok/en/osde/documents/services/soonerstart/data-reporting/SoonerStart%20Site%20Determination%202024-2025.pdf) | 2024-2025 | 12 service districts (not verified) | 20 (0) | Thu, 04 Dec 2025 20:51:54 GMT | `63c061b5a63762d914da4094cf17fe7a4119b1e4e774b2538efb4c985f5051c8` | 0 / 0 | not-extracted-image-only |
| `site-det-2023-24` | [Part C Site Determinations 2023-2024](https://oklahoma.gov/content/dam/ok/en/osde/documents/services/soonerstart/data-reporting/SoonerStart%20Site%20Determinations%202023-2024.pdf) | 2023-2024 | 12 service districts | 25 (25) | Mon, 07 Apr 2025 19:58:40 GMT | `3b121c4c14f29a60d5db18706a73502cff599b878d42d53eee26976225a9f13c` | 36 / 0 | extracted |
| `site-det-2022-23` | [Part C Site Determinations 2022-2023](https://oklahoma.gov/content/dam/ok/en/osde/documents/services/soonerstart/data-reporting/Part%20C%20Site%20Determinations%202022-2023.pdf) | 2022-2023 | 12 service districts | 25 (25) | Mon, 15 Jul 2024 19:46:08 GMT | `20751610dc38ff6db6a88721cbdc2fae03bf03e2177560bc57b20e16b0b8150a` | 36 / 0 | extracted |
| `profile-2023-24` | [Part C Data Profiles 2023-2024](https://oklahoma.gov/content/dam/ok/en/osde/documents/services/soonerstart/data-reporting/District%20Data%20Profiles%202023-2024.pdf) | 2023-2024 | 12 service districts | 24 (24) | Mon, 07 Apr 2025 20:03:39 GMT | `5cffcfea15622b9ee7ee6b9c726a29bbc801d471edbeae8d4e95860305bef35b` | 227 / 13 | extracted |
| `profile-2022-23` | [Part C Data Profiles 2022-2023](https://oklahoma.gov/content/dam/ok/en/osde/documents/services/soonerstart/data-reporting/Part%20C%20Data%20Profiles%202022-2023.pdf) | 2022-2023 | 12 service districts | 24 (24) | Mon, 15 Jul 2024 19:46:08 GMT | `34c38a3a795cf6fdafab16ef80b47505813d823d82550d186962e8ce334d7614` | 240 / 0 | extracted |
| `profile-2021-22` | [Part C Data Profiles 2021-2022](https://oklahoma.gov/content/dam/ok/en/osde/documents/services/soonerstart/data-reporting/Part%20C%20Data%20Profiles%202021-2022.pdf) | 2021-2022 | 27 local sites | 54 (54) | Mon, 15 Jul 2024 19:46:09 GMT | `21fc95c5974f4ab198779da50a1883cf4b48de86d032dd52968b1467a446f519` | 456 / 84 | extracted |
| `exit-2024-25` | [Part C Exiting Data 2024-2025](https://oklahoma.gov/content/dam/ok/en/osde/documents/services/soonerstart/data-reporting/Part%20C%20Exiting%20Data%202024-2025.pdf) | FFY 2024 | statewide | 2 (2) | Thu, 29 Jan 2026 15:40:40 GMT | `bcaa11d006e5b911f630d5e2f903d36cd54a96c48838045786cdbe8cf258b7cf` | 0 / 16 | extracted |
| `exit-2023-24` | [Part C Exiting Data 2023-2024](https://oklahoma.gov/content/dam/ok/en/osde/documents/services/soonerstart/data-reporting/Part%20C%20Exiting%20Data%202023-2024.pdf) | 2023-2024 | statewide | 1 (1) | Mon, 07 Apr 2025 20:53:04 GMT | `f28ce366e43bbf5cf560401ac7b64d2155d4a772844820223cd2205681471eff` | 17 / 0 | extracted |
| `exit-2022-23` | [Part C Exiting Data 2022-2023](https://oklahoma.gov/content/dam/ok/en/osde/documents/services/soonerstart/data-reporting/Part%20C%20Exiting%20Data%202022-2023.pdf) | 2022-23 | statewide | 5 (5) | Mon, 15 Jul 2024 19:46:07 GMT | `0d51dca5dafa297cc9dbe47329e6203e84a7c80eeee17a763458f0feb4793e40` | 17 / 0 | extracted |
| `dispute-2023-24` | [Part C Dispute Resolution 2023-2024](https://oklahoma.gov/content/dam/ok/en/osde/documents/services/soonerstart/data-reporting/23-24%20Dispute%20resolution.pdf) | SY 2023-24 | statewide | 3 (3) | Mon, 07 Apr 2025 20:13:26 GMT | `1dd9b6c583da1642fff89e58e4eb8ae1a69b43f5a8111e79a4fd4db7bea015f6` | 3 / 0 | extracted |
| `dispute-2022-23` | [Part C Dispute Resolution 2022-2023](https://oklahoma.gov/content/dam/ok/en/osde/documents/services/soonerstart/data-reporting/Part%20C%20Dispute%20Resolution%202022-2023.pdf) | SY 2022-23 | statewide | 2 (2) | Mon, 15 Jul 2024 19:46:07 GMT | `078f163b9cf188f661723bef28062e550c42a968ed734195e3ba333ef18046c9` | 3 / 0 | extracted |
| `dispute-2021-22` | [Part C Dispute Resolution 2021-2022](https://oklahoma.gov/content/dam/ok/en/osde/documents/services/soonerstart/data-reporting/Part%20C%20Dispute%20Resolution%202021-2022.pdf) | SY 2021-22 | statewide | 2 (2) | Mon, 15 Jul 2024 19:46:07 GMT | `38a36cff139470f06568e47ed24ffad77f4b6281b2a121960ac49be0350eb04b` | 3 / 0 | extracted |
| `cc-2023-24` | [Part C Child Count and Setting 2023-2024](https://oklahoma.gov/content/dam/ok/en/osde/documents/services/soonerstart/data-reporting/Part%20C%20Child%20Count%20and%20Setting%202023-2024.pdf) | 2023-24 (December 1, 2023) | statewide | 8 (8) | Mon, 07 Apr 2025 20:54:16 GMT | `23f2d25acc8f0a7d1f990cda26ba900f186c799c80e3b2539d394612aef88fee` | 35 / 0 | extracted |
| `cc-2022-23` | [Part C Child Count and Setting 2022-2023](https://oklahoma.gov/content/dam/ok/en/osde/documents/services/soonerstart/data-reporting/IDEA%20Part%20C%20Child%20Count%20and%20Setting%202022-2023.pdf) | 2022-23 (December 1, 2022) | statewide | 4 (4) | Mon, 15 Jul 2024 19:46:07 GMT | `66e1c59756dafebbc026966c6712c667ae909347be03856d7b8b0361f6b0f691` | 35 / 0 | extracted |
| `cc-2021-22` | [Part C Child Count and Setting 2021-2022](https://oklahoma.gov/content/dam/ok/en/osde/documents/services/soonerstart/data-reporting/IDEA%20Part%20C%20Child%20Count%20and%20Settings%202021-22.pdf) | 2021-22 (December 1, 2021) | statewide | 4 (4) | Mon, 15 Jul 2024 19:46:08 GMT | `1868018011559f0e231c7727f03ef43db6738775ec8d0094b03ff24a4cf381d5` | 35 / 0 | extracted |

Documents the page did **not** link (not successfully located through this official source, not assumed absent): Part C SPP/APRs for FFY 2021 and earlier (only republished percentages were available), district/site profiles before 2021–22, site determinations before 2022–23, Section 618 child count for December 1, 2024, Section 618 exiting for FFY 2021 and earlier, and federal determination letters after 2023. The FFY 2024 child count (2,420) appears only inside the FFY 2024 SPP/APR (Indicators 2 and 6).

## 3. Extracted public-data catalog

[public-data-catalog.csv](public-data-catalog.csv) and [public-data-catalog.json](public-data-catalog.json) have one row per published value. Column definitions are in [public-data-schema.json](public-data-schema.json); indicator definitions, methodology and limitations are in [indicators.json](indicators.json); geographies and published county memberships are in [geographies.json](geographies.json).

| Content | Sources | Records |
|---|---|---:|
| Statewide SPP/APR indicators 1–12 (published rates, adjusted compliance, raw timely share, counts) | FFY 2022, 2023, 2024 | 80 |
| Indicator 3 progress categories a–e (3 outcomes × 3 years) | FFY 2022–2024 | 45 |
| Republished historical percentages and targets, Indicators 1–8 | FFY 2017–2021 (from the FFY 2022 report) | 85 |
| District profiles: Indicators 1–8, child counts, surveys | 2022–23, 2023–24 (12 districts each) | 480 |
| Site profiles: same layout | 2021–22 (27 sites) | 540 |
| Site determinations: total, compliance and results points, level | 2022–23, 2023–24 | 72 |
| Section 618 child count: age × setting, race/ethnicity, gender, cumulative | Dec 1 2021, 2022, 2023 | 105 |
| Section 618 exiting: reasons, total, race/ethnicity | 2022–23, 2023–24, FFY 2024 | 50 |
| Dispute resolution totals | SY 2021-22 to 2023-24 | 9 |
| Federal (OSEP) determinations | 2021, 2022, 2023 letters | 3 |

The table above shows record counts by content. By measure basis: published rates 914, counts 326, republished history 85, determinations 75, progress categories 45, adjusted compliance 12, and raw timely share (derived from published counts) 12.

**Measures not published by any reviewed source (DATA UNAVAILABLE):** referral counts, evaluation and eligibility outcomes for all referred children, county-of-residence results, referral-to-first-service completion and waiting-time distributions. Indicator 7 covers only eligible children who had an initial IFSP meeting. Indicator 1 covers service start after IFSP consent, including subsequent IFSPs. Neither is referral-to-first-service completion.

## 4. Source verification results

Results are in [verification-results.json](verification-results.json): 491 checks, each with an id, type, result and detail. The 491 break down as 161 cross-source, 107 structure, 95 arithmetic, 86 source-token, 22 inventory, 12 reconciliation, 5 integrity and 3 geography.

- **Source tokens.** Every statewide value is located as literal text on its cited physical PDF page.
- **Arithmetic.** Every published rate is recomputed from its counts. Adjusted compliance is recomputed as (timely + documented exceptions) / (denominator − exclusions).
- **Reconciliation.**
  - Residual delays equal the published staff-reason counts for Indicator 1 (FFY 2022–2024), Indicator 7 (FFY 2022–2023) and Indicators 8A/8C (FFY 2022–2023).
  - Indicator 3 summaries equal (c+d)/(a+b+c+d) and (d+e)/total of the progress categories.
- **Cross-source consistency.**
  - The 12 district birth-to-three counts sum exactly to the statewide December 1 child count: 2,565 (2022) and 2,711 (2023).
  - Indicator 2 equals home plus community-based settings in the child count, including the republished FFY 2021 value (94.14% = 2,138/2,271).
  - Indicator 5 numerators equal the statewide birth-to-1 child counts.
  - SPP/APR Section 618 exits equal the exiting reports for FFY 2022 (2,640) and FFY 2023 (2,720).
  - Family surveys distributed equal the IFSP count.
  - Site-determination matrices equal the same-year profile values for all 24 district-years.
  - Republished history agrees across all three reports wherever years overlap.
- **Verification limits.** These checks confirm what the publications say and that their arithmetic holds. They do not audit the agency's underlying records.

## 5. Historical year coverage

| Measure | FFY 2017–2021 | FFY 2022 | FFY 2023 | FFY 2024 |
|---|---|---|---|---|
| Indicators 1, 7, 8A–C (statewide) | Republished % | Counts + % | Counts + % | 1, 8A counts + %; **7, 8B, 8C held** |
| Indicators 2, 3, 4, 5, 6 (statewide) | Republished % and targets | Counts + % | Counts + % | Counts + % |
| Indicator 11 SSIP, 12 supervision | — | 11 only | 11, 12 | 11, 12 |
| Child count (Dec 1) | 2021 | 2022 | 2023 | Total only (in SPP/APR) |
| Exiting | — | Verified | Verified (period not stated) | **Held** |
| Local profiles | 2021–22 sites | 2022–23 districts | 2023–24 districts | Not published on page |

Definition changes are disclosed and encoded in each record's `comparability_key`:
- Indicators 3 and 4 re-established their baselines in FFY 2020, so the dashboard breaks the trend line there.
- Indicator 11 uses a different implementation-district subset every year, so it is not comparable year to year.
- The 2021–22 sites and the later districts are different geographies; SoonerStart consolidated sites into districts in 2022 (FFY 2022 SPP/APR p. 30).
- Each child-count release prints a cumulative reference period ending a year before its label. This is preserved as printed.

## 6. District coverage

All 12 districts are covered in 2022–23 and 2023–24, and all 27 sites in 2021–22. In each structure, the published memberships list every one of Oklahoma's 77 counties exactly once (automated check).

For the priority counties:
- **Tulsa** is District 11 (titled "Tulsa County" in the source). In 2021–22 it was the Tulsa County site.
- **Rogers, Mayes, Craig, Ottawa, Delaware and Nowata** are in District 4, together with Wagoner and Washington. In 2021–22 they were split across the Claremore (Rogers), Tahlequah (Mayes), Vinita (Craig, Ottawa, Delaware) and Bartlesville (Nowata) sites.

District results are never divided among counties. District 11 is not relabelled as Tulsa County residence outcomes. No population-based allocation is used. The county selector shows membership only.

## 7. Indicator availability matrix

| Measure | Statewide | Service district / site | County of residence |
|---|---|---|---|
| Children served (child count) | VERIFIED 2021–2023 | VERIFIED birth to three 2022–2023; HOLD 2023–24 birth to one and 2021–22 site totals | DATA UNAVAILABLE |
| Referral counts; evaluation / eligibility outcomes | DATA UNAVAILABLE | DATA UNAVAILABLE | DATA UNAVAILABLE |
| Indicator 7 (45-day timeline) | VERIFIED FFY 2022–2023; HOLD FFY 2024 | VERIFIED % only | DATA UNAVAILABLE |
| Indicator 1 (timely services) | VERIFIED FFY 2022–2024 | VERIFIED % only | DATA UNAVAILABLE |
| Indicators 2–6 | VERIFIED FFY 2017–2024 | VERIFIED %; HOLD 2021–22 Indicator 2 and Outcome B2 | DATA UNAVAILABLE |
| Indicator 8 (transition) | VERIFIED FFY 2022–2023 and 8A FFY 2024; HOLD 8B/8C FFY 2024 | VERIFIED % only | DATA UNAVAILABLE |
| Exits | VERIFIED FFY 2022–2023; HOLD FFY 2024 | DATA UNAVAILABLE | DATA UNAVAILABLE |
| Site determinations | OSEP letters VERIFIED | VERIFIED 2022–24; NOT YET CONNECTED 2024–25 (image-only) | DATA UNAVAILABLE |
| Referral-to-first-service completion | DATA NOT YET CONNECTED | DATA NOT YET CONNECTED | DATA NOT YET CONNECTED |

## 8. Quality holds and unresolved discrepancies

Details are in [quality-holds.json](quality-holds.json). In every case, values are kept in the database but removed by the public endpoint and CSV.

| Hold | Records | Reason |
|---|---:|---|
| `hold-c7-ffy2024` (existing) | 2 | 557 − 409 − 146 = 2, but the report cites 32 staff-delay incidences; printed quarterly shares sum to 92.0% |
| `hold-b12-ffy2024` (existing, Part B) | 0 here | Unchanged; remains held in the existing Part B section |
| `hold-c8bc-ffy2024` | 3 | "Potentially eligible for Part B" is 318 in 8B but 349 in 8C for the same quarter |
| `hold-exit-ffy2024` | 16 | Total 2,564 ≠ reasons 2,543 ≠ race/ethnicity 2,543 ≠ SPP/APR's 2,733 |
| `hold-profile-birth-to-one-2023` | 12 | District birth-to-one counts sum to 366 vs. statewide 352 |
| `hold-profile-2021-child-count` | 27 | Site birth-to-three counts sum to 2,270 vs. statewide 2,271 |
| `hold-profile-2021-c2-units` | 27 | 2021–22 Indicator 2 printed as proportions (e.g. "0.97%", "Yes" vs. 96% target) |
| `hold-profile-2021-b2` | 27 | 2021–22 Outcome B2 values of 47–100% against a statewide 38.47%; flags contradict values |
| `hold-profile-met-flag` | 4 | Printed "Met target" contradicts printed values (2023–24 District 12 Indicator 6; 2021–22 Durant Indicator 6; Norman and Tulsa County Indicator 4A) |

The existing Stage B2 records `b11-ffy2024` and `b12-referrals-ffy2024` were not modified or duplicated. The Part B and Part C tables stay separate.

## 9. Import-ready structured data and schema

- **Pipeline.** `scripts/soonerstart-public-data/build_catalog.py`, with curated statewide values in `statewide_spec.py`, regenerates every artifact here and the seed migration from the PDFs. It stops on any unexpected check failure. Run it with an isolated interpreter and pdfplumber installed outside the repository.
- **Schema.** The schema is in `db/schema.ts` with migration `20261109115021_create_soonerstart_public_records`. It adds five new tables: `soonerstart_sources`, `soonerstart_geographies`, `soonerstart_indicators`, `soonerstart_quality_holds` and `soonerstart_public_records`.
  - Stable ids are used for source, indicator, geography and record. The record id is `source:indicator:basis:geography:subgroup:year`.
  - A unique natural key prevents duplicates, and foreign keys link each record to its source, indicator, geography and hold.
  - Check constraints enforce: held ⇔ hold id, `record_origin = 'public-publication'`, numerator ≤ denominator, non-negative values, a well-formed SHA-256, and official `https://oklahoma.gov/` URLs.
- **Seed.** Migration `20261109115022_seed_soonerstart_public_records` uses `ON CONFLICT DO NOTHING`. Triggers block any later UPDATE or DELETE on records, sources and holds; a correction requires a new source version or a deliberately reviewed migration.
- **Separation from agency data.** Future agency-provided aggregates continue to use the existing `idea_aggregate_reviews` table and validator. They cannot enter the public-publication table. There is no write endpoint.

## 10. Dashboard implementation changes

- **New section.** A *SoonerStart Public Data · IDEA Part C* section was added inside *Developmental Identification & Service Access*, after the existing IDEA section. It contains:
  - A. Statewide indicators, FFY 2022–2024, with counts, targets, adjusted versus raw rows and status badges.
  - C. Historical trends: an indicator selector, a single-series line with a dashed target, breaks at definition changes, keyboard- and hover-accessible points and a full table equivalent.
  - B. District and site profiles, with determinations and a county-to-service-area lookup (the seven priority counties are listed first).
  - E. A district comparison listed in district-number order, not ranked.
  - D. Child count, demographics and exits.
  - F. An availability matrix and the live hold list.
  - G. A CSV download from `/api/soonerstart-public-data?format=csv`.
- **Status labels.** The four labels are distinguished by color, an icon glyph and text.
- **New endpoint.** `/api/soonerstart-public-data` is GET/HEAD only and rejects unknown parameters. It re-checks pinned source hashes and arithmetic, drops failing rows, and strips the values of held rows.
- **Retained.** The nine-measure framework, eight missing-pathway labels, ten domains, county filters, maps and the Stage B1/B2 records are unchanged. The framework's Part C evidence text was updated to cite the verified Indicator 1, 7 and 8 data and the remaining holds. A row was added to the geographic availability table, and a methods entry was added to `data-sources-methods.html`.

## 11. Automated and browser test results

| Test | Result |
|---|---|
| `node --experimental-strip-types --test tests/*.test.mts` | **PASS** — 55/55 (15 new SoonerStart tests: inventory, verification dispositions, arithmetic, raw/adjusted separation, deduplication, statewide/district double counting, period mixing, definition changes, geography, holds and tamper rejection, unavailable data, PII, seed parity, CSV injection, dashboard regression; 40 existing tests) |
| All 9 migrations applied in order to in-memory PGlite | **PASS** — 1,469 records, 21 sources, 40 geographies, 44 indicators, 9 holds; the existing 2 Part B records are intact. UPDATE, DELETE, a duplicate natural key, a verified row carrying a hold and an agency-origin row were all rejected; re-running the seed inserts changed nothing |
| `tests/soonerstart-public-data-browser.mjs` (1440px and 390px; database rows → shared response builder → page) | **PASS** — 20/20, see [browser-test-results.json](browser-test-results.json): held values absent, trend break, District 4/11 lookup, unranked comparison, frameworks retained, no overflow, **zero axe WCAG 2.1 A/AA violations** in the section, outage shows DATA UNAVAILABLE with no stale values, no page errors |
| JavaScript syntax, `git diff --check` | **PASS** |
| Existing browser suites (`phase6-*-browser.mjs` etc.) | **NOT VERIFIED** — they require `netlify dev` plus production API snapshots; not run in this session |
| Deployed function against a Netlify database branch | **NOT VERIFIED** — see 14 |
| Manual screen-reader review | **NOT VERIFIED** |

## 12. Exact records added, excluded or held

- **Added (seeded, pending deploy):** 1,469 rows in `soonerstart_public_records`. Of these, 1,351 are verified and 118 are held, broken down by source in the inventory table above. No existing row was changed.
- **Excluded on purpose:**
  - Race × setting cross-tabs from child counts (63 cells) and race × reason cells from exits.
  - Quarterly IFSP counts and narrative delay ranges.
  - Per-indicator site-determination points that duplicate profile values (used only for cross-checks).
  - FFY 2022–2023 republished history (the primary records are used instead).
  - The image-only 2024–25 site determinations.
- **Held:** 118, as listed in section 8.

## 13. Git branch, commit and pull request

The work was done in the platform-managed workspace on `main`, base commit `4b3bee0202832cef61b2736b68975be6709070e6`. The platform handles the commit, branch and pull request, so no commit SHA or pull request URL was available when this report was written.

## 14. Database and deployment blockers

- **Earlier preview failures.** Previous Deploy Previews failed at `createSiteDatabaseBranch` with HTTP 500. This run did not retry provisioning, bypass branch isolation or touch the production database.
- **Local validation only.** All database validation used an in-memory PGlite instance.
- **Persistence not yet confirmed.** Persistence on a Netlify database branch has **not** been confirmed. Until a preview provisions successfully, the endpoint returns 503 and the section shows DATA UNAVAILABLE. No values are substituted.
- **Merging seeds production.** These are additive migrations. Merging the change will cause the platform to apply them, including the seed, to the production database. That is a reviewer decision.
