Raw sources
Raw sources (bronze)
Rows from every feed, stored exactly as received. Normalisation happens in the silver layer, where each change is flagged.
ENREnrollment
43,101
raw rows
- Usable
- 42,871
- Flagged
- 84%
- No member ID
- 2%
- Linked
- 29,405
- First seen
- 2026-01-01
- Last seen
- 2026-10-18
CLMClaims
32,829
raw rows
- Usable
- 32,674
- Flagged
- 74%
- No member ID
- 35%
- Linked
- 30,209
- First seen
- 2026-01-01
- Last seen
- 2026-10-18
TPAThird-party administrator
14,474
raw rows
- Usable
- 14,404
- Flagged
- 77%
- No member ID
- 85%
- Linked
- 11,671
- First seen
- 2026-01-01
- Last seen
- 2026-10-18
PRVProvider network
9,596
raw rows
- Usable
- 9,546
- Flagged
- 80%
- No member ID
- 50%
- Linked
- 8,676
- First seen
- 2026-01-01
- Last seen
- 2026-10-18
Raw events
Third-party administrator only, ordered by line number
| Source | Record | Received | First | Middle | Last | DOB | Member ID | SSN | Phone | Address | City | State | ZIP | Group | Plan | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| TPA | TPA-50156 | 2026-09-19T06:36:28Z | Gilbert, Bobby | C | — | 2001-02-27 | — | NULL | null | NULL | 6310 Grand Avenue | Dallas | TX | 75253 | GRP-0914 | — |
| TPA | TPA-56418 | 2026-01-18T12:28:27Z | OMAR | — | LE | 1980-03-23 | ·· | •••-••-1650 | — | - | 9880 Canyon Rd | Charlotte | NC | 28206 | N/A | UNKNOWN |
| TPA | TPA-63741 | 2026-08-06T10:37:28Z | Kevin | — | Austin | 05/06/68 | - | •••-••-2811 | - | — | — | ·- | — | null | — | — |
| TPA | TPA-53022 | 2026-02-14T16:54:50Z | Brandon | — | Coleman | Feb 20, 1945 | — | N/A | (285) 946-2346 | BRANDON.COLEMAN@YAHOO.COM | 3945 Lake View Rd | Mesa | AZ | 85261 | — | OPTIONS-PPO |
| TPA | TPA-60736 | 2026-04-04T20:33:36Z | joe | ·· | bshop | 10/18/88 | UNKNOWN | •••-••-9752 | 5279154620 | joe.bishop@icloud.com | 6422 HARBOR BOULEVARD | NASHVILLE | TN | - | N/A | null |
| TPA | TPA-52442 | 2026-10-15T04:46:04Z | OLIVIA | ·· | MASON | 2005-01-07 | null | - | - | olivia.mason@icloud.com | 9078 SUNSET BLVD | Tucson | AZ | 85770 | GRP-5526 | ·- |
| TPA | TPA-59189 | 2026-05-22T05:59:54Z | MICHELLE | — | CARPENTER | 1960-07-18 | — | — | N/A | UNKNOWN | 8637 Ocean Avenue | Chandler | az | 85278 | ·GRP-5683 | - |
| TPA | TPA-50409 | 2026-08-22T21:01:43Z | Mary | ···· | Payne | 01/25/1948 | — | N/A | UNKNOWN | UNKNOWN·· | 2881 APACHE BLVD | SEATTLE | WA | 98120 | GRP-9259 | OPTIONS-PPO |
| TPA | TPA-58543 | 2026-06-02T20:19:36Z | CHRISTINA | ···· | MORGAN | 1999-03-07 | NULL | — | — | - | — | null | UNKNOWN | — | - | - |
| TPA | TPA-58399 | 2026-04-06T09:44:59Z | Mendoza, Valentina | — | — | 1991-04-01 | NULL | — | 685-622-4410 | - | 5443 Washington Street | Eden Prairie | MN | 55315 | null | ·NULL |
| TPA | TPA-51408 | 2026-06-14T03:24:35Z | ·Richard | — | Henry | 1978-06-16 | N/A | null | 848.295.9786 | — | 7513 Spring Street | Atlanta | ga | — | GRP-1237 | MEDICARE-ADV-A |
| TPA | TPA-59546 | 2026-08-10T03:13:36Z | Sue | X | Mason | 1954-06-27·· | UNKNOWN | UNKNOWN | - | — | N/A | null | — | - | UNKNOWN | MEDICARE-ADV-A |
| TPA | TPA-50962 | 2026-03-13T00:26:29Z | STEVEN | — | RUYZ | 1971-06-18 | null | — | 15573298954 | NULL | 860 Bayshore Drive | TUCSON | AZ | 85734 | ·N/A | — |
| TPA | TPA-51814 | 2026-06-05T03:50:51Z | HAROLD | — | BERRY | 02/16/1971 | - | •••-••-0558 | null | NULL | 8670 River Road | Sacramento | CA | 95829 | — | — |
| TPA | TPA-62661 | 2026-02-17T05:59:46Z | Gabriel | — | ·Riley | 1973-07-26 | UHC-30685-65 | N/A | +1 788 618 9483 | — | 7975 Washington St | Miami | ·FL | 33140 | NULL | NULL |
| TPA | TPA-50898 | 2026-06-20T03:21:08Z | DANIEL | — | LAWRENCE | 1798-07-10 | — | •••-••-5064 | (872) 669-8499 | — | 8162 Spring Street | PLANO·· | TX·· | 75004 | N/A | N/A |
| TPA | TPA-52794 | 2026-09-23T21:41:12Z | Terry | — | Coooper | 1988-02-23 | null | null | null | terry.cooper97@hotmail.com | 3070 Bayshore Drive | Minneapolis | MN | 55439 | GRP-1081 | NULL |
| TPA | TPA-53041 | 2026-04-27T10:18:02Z | joyce | — | jones | 1956-08-08 | N/A | — | - | N/A | 8268 FOREST AVE Apt 14 | Los Angeles | CA | ·90034 | GRP-0259 | N/A |
| TPA | TPA-56536 | 2026-02-25T20:25:45Z | Rachel | — | Wells | 1974-05-08 | - | ·UNKNOWN | — | — | NULL | null | - | — | GRP-9549 | - |
| TPA | TPA-64256 | 2026-08-22T15:55:34Z | Austin | — | Morgan | 05/17/03 | — | •••-••-6461 | UNKNOWN | NULL | 6020 Sunset Boulevard·· | Dallas | TX | 75225 | null | MEDICARE-ADV-A |
| TPA | TPA-55517 | 2026-06-08T06:41:46Z | JON | B | PARKER | 9/7/1952 | NULL | N/A | UNKNOWN | jonathan.parker58@gmail.com | 8769 Lincoln Way | Seattle | ·WA | 98174 | — | — |
| TPA | TPA-53502 | 2026-01-13T08:41:34Z | Sharon | B | Aguilar | 19810617 | — | •••-••-8670 | UNKNOWN | — | 9777 Grand Avenue | Scottsdale | AZ | null | GRP-0374 | - |
| TPA | TPA-62807 | 2026-06-14T18:29:30Z | Carol | O. | Bryant | 1951-09-03 | — | •••-••-3211 | NULL | — | 2505 Meadow Lane | Jacksonville | FL | 32292 | N/A | SELECT-EPO |
| TPA | TPA-55470 | 2026-02-09T09:07:24Z | ·AUSTIN | — | ROBERTSON | 1968-11-08 | N/A | NULL | N/A | NULL | 169 VALLEY VIEW DR | GILBERT | AZ | 85284 | — | NULL |
| TPA | TPA-59226 | 2026-06-09T21:27:50Z | ANGELA | ···· | WILLIAMSON | 1947-10-26 | NULL | •••-••-0540 | — | ANGELA.WILLIAMSON@OUTLOOK.COM | 6565 Baseline Road·· | Phoenix | AZ | ·85072 | — | — |
| TPA | TPA-56031 | 2026-02-03T01:55:45Z | Timothy | — | Mejia·· | 1963-01-05 | UHC-08344-93 | - | - | N/A | — | — | UNKNOWN | N/A | GRP-4749·· | NULL |
| TPA | TPA-56061 | 2026-06-05T20:47:39Z | Olivia | — | Harvey | 1975-06-25 | — | •••-••-5076 | 589-387-2577 | olivia.harvey47@hotmail.com | 8802 Broadway | Atlanta | GA | 30336 | — | — |
| TPA | TPA-62142 | 2026-03-01T11:31:46Z | Julia | — | Walsh | 1940-30-02 | N/A | — | — | N/A | 4421 PARK PLACE | FRESNO | ·CA | 93798 | GRP-5059 | select-epo |
| TPA | TPA-55859 | 2026-01-09T13:38:46Z | DIEGO | ···· | GUERRERO | 1943-03-05 | — | N/A | — | UNKNOWN | 4725 Willow Ct #450 | San Diego | CA | — | UNKNOWN | ·null |
| TPA | TPA-57805 | 2026-08-23T22:27:43Z | Janice | — | Tucker | 2005-12-03 | UNKNOWN | UNKNOWN | - | — | 1178 Palm Dr·· | Sacramento | California | 95825-0340 | NULL | — |
| TPA | TPA-53827 | 2026-02-26T04:41:45Z | Samuel | — | ·Watkins | 28-04-1979 | ·null | — | - | SAMUEL.WATKINS79@OUTLOOK.COM | — | N/A | UNKNOWN | NULL | — | - |
| TPA | TPA-58979 | 2026-01-13T16:07:53Z | DOMINGUEZ | — | HELEN | 2000-05-20 | UNKNOWN | •••-••-0466 | null | null | 320 Pine Drive | EDEN PRAIRIE | Minnesota | 55369-8983 | NULL | NULL |
| TPA | TPA-57965 | 2026-03-17T19:04:56Z | Kayla | — | Turner | ·08/22/1972 | — | N/A | NULL | N/A | N/A | null | — | — | - | N/A |
| TPA | TPA-62237 | 2026-03-21T13:11:13Z | ISABELLA | — | WEST | 13-02-1941 | NULL | NULL | — | NULL | 6180 Highland Avenue | Plano | TX | 75021 | null | — |
| TPA | TPA-53752 | 2026-08-25T23:35:30Z | Ray | ···· | Helen | — | - | null | 592.351.6637 | — | NULL·· | -·· | N/A | N/A | N/A | N/A |
| TPA | TPA-56904 | 2026-08-29T22:54:23Z | GEORGE | F. | SALAZAR | 1599-01-03 | null | •••-••-3333 | — | N/A | 1928 Palm Dr | San Antonio | TX | 78272 | — | null |
| TPA | TPA-54889 | 2026-08-11T06:10:20Z | DANIEL | M | OWENS | 1958-01-04 | - | — | 559.869.3732 | null | 1513 Cedar Lane | Atlanta | GA | 30313 | UNKNOWN | MEDICARE-ADV-B |
| TPA | TPA-59322 | 2026-07-21T01:15:09Z | ALICE | — | GONZALEZ | 1968-02-14 | ·N/A | null | 9108248546 | — | 8283 Mesa Drive | Sacramento | CA | 95872 | GRP-4208 | - |
| TPA | TPA-60799 | 2026-05-07T08:31:29Z | ·Kyle | — | Li | 1941-10-02 | null | •••-••-2147 | — | N/A | 1629 River Road | Tucson | AZ | 85724 | NULL·· | - |
| TPA | TPA-52757 | 2026-04-13T17:16:42Z | WILLIAM | ·· | STEWART | 8/11/1976 | N/A | - | — | UNKNOWN | — | NULL | ···· | — | GRP-6305 | ···· |
| TPA | TPA-62169 | 2026-01-27T13:16:43Z | Mitkhell, Sofia | — | — | 1969-05-08·· | UNKNOWN | •••-••-1045 | — | null | ·- | — | N/A | - | GRP-3016 | OPTIONS-PPO |
| TPA | TPA-52998 | 2026-08-31T04:39:11Z | Gloria | — | Ward | 1997-02-15 | — | - | - | gloria.ward40@aol.com | 6456 Highland Ave | Fresno | CA | UNKNOWN | — | — |
| TPA | TPA-53712 | 2026-04-12T20:22:36Z | margaret | — | hunter | 01/01/05 | null | null | 18467827683 | — | 2931 OAK ST | Chandler | AZ | 85272-9344 | N/A | UNKNOWN |
| TPA | TPA-60509 | 2026-05-05T20:27:59Z | Richard | E | Thmas | 20060712 | - | — | (948) 387-6321·· | N/A | 461 Pine Dr | Austin | TX·· | 78734 | null | ·UNKNOWN |
| TPA | TPA-55294 | 2026-02-10T18:35:48Z | douglas | — | obrien | 1966-08-26 | - | •••-••-2427 | null | UNKNOWN | 6471 Church Street | CHANDLER | ·AZ | 85231·· | UNKNOWN | NULL |
| TPA | TPA-58603 | 2026-06-03T03:45:10Z | GABRIEL | ·T | PERKINS | 1945-04-18 | UNKNOWN | — | — | GABRIEL.PERKINS@ICLOUD.COM | 1327 Valley View Dr | Scottsdale | Arizona | 85288 | GRP-7968·· | NULL |
| TPA | TPA-55089 | 2026-08-05T08:53:39Z | CAROLYN | — | FOWLER | 1993-06-10 | null | ·· | UNKNOWN | — | 4224 UNION ST | Seattle | WA | 98190-7181 | GRP-2884 | — |
| TPA | TPA-56847 | 2026-03-03T06:02:18Z | Camila | — | Moore | 2004-08-02 | null | — | 777-941-8814 | ·NULL | 9833 LAKE VIEW ROAD | Chandler | AZ | 85231 | — | — |
| TPA | TPA-64458 | 2026-07-21T22:56:00Z | Santiiago | — | Powell | 19850820 | NULL | •••-••-1623 | ·- | N/A | 6590 Canyon Rd·· | Columbus | OH | ·43254 | GRP-9742 | MEDICARE-ADV-B |
| TPA | TPA-54561 | 2026-05-23T21:18:10Z | ANNA | — | DUNN | 1979-05-15 | NULL | — | 257.478.2374 | — | 1087 HILLCREST ROAD | MIAMI | Florida | 33155 | GRP-2304 | — |
Bronze layer rules
What is guaranteed for downstream layers
- As receivedValues are stored exactly as the feed delivered them, including whitespace, inconsistent casing and placeholder tokens such as NULL or N/A.
- No transformationBronze is never edited in place. Every fix lives in silver and is traceable back here by record ID.
- Line number preservedThe line number records each row's position in the source file, so a value can be located in the original extract.
- Load timestampThe load timestamp marks when the row landed in the lakehouse; this batch landed 2026-10-22T12:42:43.635Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty