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-55624 | 2026-06-08T06:40:26Z | BRENDA | — | LONG | 1955-11-11 | - | — | 936-838-8627 | — | 7814 HILLCREST RD | SAN ANTONIO·· | TX | 78209 | — | — |
| TPA | TPA-57699 | 2026-03-22T02:16:48Z | SCOTT | — | MURRAY·· | 1940-07-26 | - | — | — | null | 8246 FOREST AVENUE | Los Angeles | CA | 90098 | - | — |
| TPA | TPA-60270 | 2026-05-17T06:47:18Z | CATHERINE | — | HART | 11/23/1973 | UNKNOWN | — | N/A | null | 1502 Oak Street | Gilbert | AZ | 85208-3047·· | null | — |
| TPA | TPA-61505 | 2026-08-24T21:40:39Z | Abigail | — | Davis | 2009-12-21 | — | NULL | 886-216-7104 | N/A | 7333 MAPLE AVENUE | Nashville | TN | 37270 | GRP-3401 | — |
| TPA | TPA-54639 | 2026-04-08T06:36:04Z | Terry | W | Cunningham | 1966-10-11 | — | - | NULL | — | 1040 Baseline Rd | Austin | TX | 78784-1238 | NULL·· | SELECT-EPO |
| TPA | TPA-55865 | 2026-02-06T01:12:37Z | Anderson, Lawrence | — | ···· | 2001-08-07 | null | •••-••-1264 | 584-356-9567 | null | 6884 Meadow Lane | San Diego | CA | 92130 | GRP-3589 | - |
| TPA | TPA-53885 | 2026-02-02T03:24:46Z | GREGORY | — | GUERRERO | 1985-01-16 | — | — | ···· | gregory.guerrero20@aol.com | 7166 Jefferson Avenue | Phoenix | AZ | 85075 | GRP-6337 | - |
| TPA | TPA-54964 | 2026-02-02T23:02:02Z | JERRY | — | FOX | 1977-06-23 | — | •••-••-0895 | N/A | UNKNOWN | 9700 Camelback Road Apt 22 | Mesa | AZ | 85245 | GRP-4610 | CORE-HMO |
| TPA | TPA-53825 | 2026-09-23T18:29:43Z | CATHERINE | — | MARQUEZ | 20000120 | N/A·· | •••-••-4563 | ·300-526-8145 | ·N/A | 5431 CHURCH STREET | Austin | TX | 78725 | — | MEDICARE-ADV-A |
| TPA | TPA-57694 | 2026-08-10T00:11:59Z | JOSE | — | — | 1965-08-18 | — | — | null | — | 7293 Camelback Rd | Plano | Texas | 75065-1240 | NULL | CHOICE-PLUS-PPO |
| TPA | TPA-60886 | 2026-01-11T20:14:37Z | Dminguez, Alna | — | — | 24-07-1990 | UHC-26620-07 | - | 264-315-7691 | — | 690 Valley View Dr·· | HOUSTON | TX | 77006 | — | null·· |
| TPA | TPA-53912 | 2026-07-11T00:37:58Z | Elizabeth | — | Clark | 1991-06-26 | — | •••-••-5123 | 4893974558 | elizabeth.clark41@proton.me | 878 Pine Drive | ·San Diego | ·CA | 92120-6591·· | null | N/A |
| TPA | TPA-51307 | 2026-06-13T02:26:21Z | Joe | — | Gray | 1949-02-23 | — | •••-••-1168 | ·5243736300 | ·· | 2333 Apache Blvd | Mesa | AZ·· | 85283-1284 | — | NAVIGATE-HMO |
| TPA | TPA-60390 | 2026-06-04T08:12:52Z | Fank | — | Ruiz | 03/26/1947 | N/A | — | 4617142767 | N/A | 2396 Lake View Road | Eden Prairie | MN | 55340 | - | UNKNOWN |
| TPA | TPA-57284 | 2026-02-15T08:14:41Z | DEBORAH | — | ·PRICE | 11/15/1940 | N/A | UNKNOWN | null | NULL | — | NULL | — | — | ·N/A | — |
| TPA | TPA-56398 | 2026-05-12T13:38:39Z | Arthur | — | Pierce | 1950-01-16 | — | •••-••-8147 | — | UNKNOWN | 6768 LINCOLN WAY | TAMPA | Florida | 33673 | — | N/A |
| TPA | TPA-53750 | 2026-04-10T23:13:16Z | Victoria | — | Hunt | 2004-02-03 | - | ·N/A | 349.257.9670 | N/A | 8062 Cedar Lane | Dallas·· | TX | 75273 | GRP-7359 | ·MEDICARE-ADV-B |
| TPA | TPA-50604 | 2026-03-12T19:24:09Z | Alexander | — | Lee·· | 1971-04-24 | — | UNKNOWN | 6083542471 | — | 1021 Desert Sky Boulevard | Austin | TX | 78706 | - | NAVIGATE-HMO |
| TPA | TPA-50139 | 2026-05-26T23:39:45Z | Priya | — | Alexander | ·1983-03-13 | N/A | null | null | priya.alexander62@proton.me | 1179 CANYON RD | Tempe | AZ | 85292-9821 | UNKNOWN | — |
| TPA | TPA-56578 | 2026-03-20T09:46:57Z | Benjamin | — | Contreras | 1980-06-23 | ·null | •••-••-9857 | (946) 455-5695 | N/A | 7408 Sage Ct·· | Gilbert | AZ | 85210-5287 | GRP-9082 | null |
| TPA | TPA-59745 | 2026-09-26T11:51:49Z | Alexander | ·· | Wells | 01/06/1997 | null | •••-••-1735 | UNKNOWN | ·ALEXANDER.WELLS9@HOTMAIL.COM | 5592 Broadway Apt 40 | LOS ANGELES | CA | 90067 | GRP-1151 | UNKNOWN |
| TPA | TPA-57783 | 2026-05-29T16:38:08Z | Jasno | L. | Austin | 11/16/1986 | UHC0173348 | — | UNKNOWN | NULL | NULL | - | NULL | NULL | GRP-1250 | — |
| TPA | TPA-58995 | 2026-05-11T10:43:40Z | Tores, Sam | — | — | 1954-08-20·· | - | UNKNOWN | null | ···· | 5874 Sunset Blvd | Austin | TX | 78717 | - | UNKNOWN |
| TPA | TPA-50467 | 2026-09-07T09:11:08Z | Samantha | — | Espinoza | 1996-10-22 | NULL | NULL | - | null | 8512 Valley View Dr | MIAMI | FL | 33156 | NULL | CHOICE-PLUS-PPO |
| TPA | TPA-64398 | 2026-06-25T21:17:53Z | ANA | — | HOWELL | 1940-02-13 | — | N/A | UNKNOWN | — | 8360 Pine Drive | Minneapolis | MN | 55497·· | — | - |
| TPA | TPA-55190 | 2026-03-23T11:43:52Z | Frances | — | Ford | 03-03-1945 | N/A | null | — | ·- | ·9796 MARKET STREET | LAS VEGAS | nv | 89161 | - | — |
| TPA | TPA-64100 | 2026-04-16T09:15:34Z | Henry·· | — | Waard | 03/06/39 | - | •••-••-7342 | - | null | 2753 Sunset Boulevard | San Diego | CA | 92160 | GRP-3992 | N/A |
| TPA | TPA-59727 | 2026-09-14T23:09:17Z | GLORIA | — | OBRIEN | 10/23/1970 | — | •••-••-7933 | 322.735.1204 | GLORIA.OBRIEN45@PROTON.ME | UNKNOWN·· | — | — | — | null | OPTIONS-PPO |
| TPA | TPA-60561 | 2026-10-10T07:37:17Z | Roberts, Margaret | — | — | 12/16/1939 | — | •••-••-4875 | UNKNOWN | null | 5221 Cedar Ln | Houston | TX | 77017 | GRP-9861·· | - |
| TPA | TPA-52990 | 2026-08-08T08:26:30Z | MARTHA | — | WALKER | 1980-04-09 | NULL | — | — | — | ·3756 Indian School Rd | AUSTIN | TX | 78766 | GRP-3008 | - |
| TPA | TPA-63122 | 2026-02-20T20:57:43Z | ·Robert | — | Brooks | 1999-02-24 | N/A | — | — | — | 5314 Palm Dr | Fresno | CA | — | - | - |
| TPA | TPA-54954 | 2026-07-01T06:49:47Z | Janice | — | Park | 2004-10-23 | N/A·· | — | N/A | — | N/A | - | null | — | GRP-1868 | UNKNOWN |
| TPA | TPA-50674 | 2026-04-05T13:49:56Z | Samuel | — | Mejia | 7/13/2003 | N/A | •••-••-7332 | null | UNKNOWN | N/A | UNKNOWN | N/A | — | GRP-8910 | SELECT-EPO |
| TPA | TPA-56279 | 2026-04-09T14:52:05Z | henry | — | wells | 08-05-1994 | - | •••-••-4638 | (248) 355-8215 | UNKNOWN | - | - | UNKNOWN | N/A | — | — |
| TPA | TPA-57606 | 2026-01-19T20:23:15Z | JACQUELINE | — | JAMES | 1991-03-25 | — | — | - | jacqueline.james@outlook.com | 4971 Desert Sky Blvd | ·Plano | TX | 75087 | ·- | SELECT-EPO |
| TPA | TPA-55261 | 2026-01-15T16:18:41Z | Jose | — | Oliver | 1951-03-24 | NULL | UNKNOWN | 373-845-6078 | jose.oliver57@icloud.com | — | ···· | - | — | -·· | UNKNOWN |
| TPA | TPA-56105 | 2026-08-15T11:41:14Z | NICHOLAS | — | BOWMAN | Jun 26, 1965 | NULL | — | 972-723-0482 | ···· | 8128 Harbor Boulevard | Nashville | TN | NULL | — | N/A |
| TPA | TPA-63999 | 2026-04-27T20:30:48Z | Lane, Carol | J. | — | 04/14/71 | UNKNOWN | •••-••-0184 | 4826730167 | null | 1038 APACHE BLVD | Dallas·· | TX | 75207 | NULL | UNKNOWN |
| TPA | TPA-64210 | 2026-03-10T02:05:06Z | Doris | Q | OBrien | Nov 11, 1973 | UHC-18952-16 | - | ···· | doris.obrien63@hotmail.com | 8287 Grand Ave | Fresno | CA | 93705 | N/A | MEDICARE-ADV-A |
| TPA | TPA-58069 | 2026-09-23T01:16:38Z | Janet, Sullivan | — | — | 1962-02-20·· | UHC-73270-99 | UNKNOWN | — | N/A | — | null | — | — | — | - |
| TPA | TPA-61115 | 2026-08-29T23:32:36Z | Karen | — | Owens | 2002-09-07 | — | — | - | karen.owens@outlook.com | 4662 Harbor Blvd | MINNEAPOLIS | MN | 55481 | N/A | N/A |
| TPA | TPA-51964 | 2026-06-01T04:57:07Z | Jones, Chuck | — | — | 1950-06-21 | null | N/A | 607-701-2816 | N/A | 1193 OCEAN AVENUE | Mesa | AZ | 85209-8065 | GRP-7016 | MEDICARE-ADV-B |
| TPA | TPA-62621 | 2026-02-27T15:42:47Z | Samuel | — | Medina·· | 1943-08-15 | — | - | 8734718945 | - | 1746 GRAND AVENUE | Sacramento | CA | — | null | — |
| TPA | TPA-55200 | 2026-04-30T12:52:14Z | henry | — | yang | 1987-12-03 | N/A | UNKNOWN | — | null | 4104 Highland Avenue | Dallas | TX | 75298 | GRP-9065 | MEDICARE-ADV-A |
| TPA | TPA-52711 | 2026-03-05T01:45:58Z | LINDA | ·· | GOMEZ | 2003-12-22 | UNKNOWN | — | — | null | 2234 Mesa Dr | Gilbert | AZ | 85269 | ·· | — |
| TPA | TPA-63762 | 2026-01-01T15:43:23Z | Helen | — | Munoz | 1999-80-23 | — | N/A | +1 650 570 0591 | NULL | 7417 Forest Ave Apt 27 | San Diego | CA | 92146 | GRP-1505 | MEDICARE-ADV-A |
| TPA | TPA-53929 | 2026-01-29T02:42:48Z | Dunn, Cheryl | — | — | 12/14/87 | UNKNOWN | •••-••-6758 | N/A | UNKNOWN | 6313 Highland Ave | EDEN PRAIRIE | Minnesota | 55363 | GRP-2336 | SELECT-EPO |
| TPA | TPA-62325 | 2026-06-15T04:27:46Z | Aaron | — | Knight | 19830713 | UHC-95721-09 | — | — | NULL | 8293 Spring St | Nashville | Tennessee | 37219-9218 | - | MEDICARE-ADV-A |
| TPA | TPA-60752 | 2026-02-14T23:39:14Z | Isabella | — | Adams | 04/08/84 | - | NULL | N/A·· | null | 5521 Church St | Jacksonville·· | FL | 32276 | UNKNOWN | — |
| TPA | TPA-63932 | 2026-01-15T06:36:28Z | Zachary | — | Scott | Dec 24, 1949 | NULL | - | 6067826986 | — | ·8108 Canyon Road | Plano | TX | N/A | — | N/A |
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:46.467Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty