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-62123 | 2026-10-13T04:04:17Z | Dorothy | — | Castillo | ·1990-08-09 | — | UNKNOWN | — | N/A | 456 Washington St | Scottsdale | AZ | 85281 | null | N/A |
| TPA | TPA-58008 | 2026-09-04T08:15:45Z | TERESA·· | — | ·PAARKER | 03/07/70 | — | null | null | — | 4695 OCEAN AVE | Gilbert | AZ | ·85235 | null | CORE-HMO |
| TPA | TPA-55715 | 2026-04-18T12:01:33Z | Benjamin | — | Chen | ·15-09-1976 | null | •••-••-4302 | 6567646035 | — | 1923 RIVER ROAD | Seattle | ·WA | 98142 | ···· | MEDICARE-ADV-A |
| TPA | TPA-58462 | 2026-07-23T02:47:00Z | Noah | H | Ramos | 04/23/1947 | — | •••-••-8583 | NULL | — | 5404 Highland Ave·· | Orlando | fl | 32817 | GRP-6273 | UNKNOWN |
| TPA | TPA-60905 | 2026-08-22T09:23:27Z | DYLAN | F | PARKER | 1988-11-15 | null | •••-••-4846 | — | — | 539 Harbor Boulevard | San Diego | CA | 92160 | NULL | — |
| TPA | TPA-51895 | 2026-03-22T21:54:38Z | Kathleen | — | ·Cruz | 10/10/1967 | — | •••-••-9820 | — | N/A | 9570 Church Street·· | San Diego | CA | N/A | null | — |
| TPA | TPA-54513 | 2026-06-16T19:32:02Z | Dylan | — | Bailey | 07/08/62 | UHC-11302-77 | - | (530) 885-9968 | — | 8382 Jefferson Avenue | LAS VEGAS | NV | 89144 | ·GRP-2731 | select-epo |
| TPA | TPA-61491 | 2026-02-22T08:13:19Z | camila | ·· | herrera | 1946-01-08 | — | •••-••-6591 | — | null | 6176 PARK PL | GLENDALE | AZ | 85380 | GRP-1970 | MEDICARE-ADV-B |
| TPA | TPA-61088 | 2026-07-30T17:25:54Z | Noah | — | Campbell | 1956-06-22 | ···· | •••-••-8659 | — | — | 3116 CANYON RD | Seattle | WA | 98127 | GRP-8787 | - |
| TPA | TPA-53540 | 2026-01-28T09:41:38Z | ANGELA | ···· | SALAZAR | 6/5/1979 | — | •••-••-3141 | null | UNKNOWN | 5809 MOUNTAIN VIEW DRIVE | Minneapolis | ·MN | 55406 | — | UNKNOWN |
| TPA | TPA-51467 | 2026-05-07T06:57:48Z | Benajmin·· | — | Stewart | Jun 25, 1945 | UNKNOWN | •••-••-0799 | ·331.471.3960 | null | 2391 Willow Ct | Tempe | Arizona | 85270 | null·· | - |
| TPA | TPA-52295 | 2026-10-15T04:18:29Z | Robert | — | Ross | 19970818 | UNKNOWN | — | null | ROBERT.ROSS@PROTON.ME | 6404 Central Avenue | GILBERT | AZ | 85224 | — | ·- |
| TPA | TPA-50420 | 2026-10-04T16:11:43Z | Justin | — | Ray | 1999-07-07 | - | — | +1 517 424 7377 | N/A | 1742 Grand Ave | Atlanta | GA | 30316 | GRP-4429 | N/A |
| TPA | TPA-63808 | 2026-06-21T07:08:12Z | Douuglas | ·· | Guerrero | 08/04/96 | null | ·- | 6508830408 | — | 3106 Baseline Rd | Nashville·· | TN | 37222 | GRP-2182 | ·· |
| TPA | TPA-61026 | 2026-09-22T20:39:40Z | Joseph | Y | Reid·· | 04/24/53 | N/A | - | - | NULL | 7309 Washington St | Dallas | ·TX | 75269·· | GRP-2568 | select-epo |
| TPA | TPA-62416 | 2026-08-03T22:34:24Z | Cole, Valentina | ·· | — | 19600219 | UHC-84010-93·· | - | +1 323 317 3921 | — | 1496 Mountain View Drive | Seattle | WA | 98147 | ·· | — |
| TPA | TPA-55373 | 2026-08-04T16:47:57Z | Russell | — | Armstrong | 21-04-1968 | N/A | — | 19105869820 | russell.armstrong@outlook.com | — | UNKNOWN | — | null | null | OPTIONS-PPO |
| TPA | TPA-64205 | 2026-06-05T00:15:58Z | LOGAN·· | — | MARSHALL | 0412-19-39 | UHC-13279-34 | •••-••-9194 | — | logan.marshall90@proton.me | — | NULL | NULL | null | null | — |
| TPA | TPA-60404 | 2026-04-27T10:37:47Z | Torres, Doris | — | ·· | — | - | UNKNOWN | UNKNOWN | null | 7807 Sunset Blvd | PHOENIX | Arizona·· | 85071 | GRP-3197 | - |
| TPA | TPA-60386 | 2026-08-11T08:53:06Z | THOMAS | ···· | DAY | ·1893-04-11 | N/A | NULL | — | NULL | 2133 Broadway | LAS VEGAS | NV | 89109 | ·UNKNOWN | UNKNOWN |
| TPA | TPA-61409 | 2026-04-22T10:18:43Z | Alexnder | ·· | Palmer | 01-03-1984 | — | — | — | UNKNOWN | 8899 APACHE BOULEVARD | Dallas | TX | 75278 | null | null |
| TPA | TPA-64390 | 2026-04-19T01:23:04Z | MATEO | — | BLACK | 1994-09-12 | UHC-06260-45 | — | - | null | 1266 Jefferson Avenue | Tucson | AZ | 85722 | — | - |
| TPA | TPA-63656 | 2026-05-16T09:17:17Z | NOAH | — | FERGUSON | 1964-06-17 | UHC-63143-64 | — | UNKNOWN | N/A | 4294 Mountain View Dr | Dallas | Texas | 75234 | NULL | NAVIGATE-HMO |
| TPA | TPA-64110 | 2026-04-02T08:37:29Z | evelyn | — | simmons | 11/26/1938 | NULL | — | - | — | ·· | — | — | - | GRP-9335 | — |
| TPA | TPA-54873 | 2026-07-09T00:22:10Z | Kelly, Maria | — | — | 1970-02-25 | N/A | •••-••-3884 | N/A | maria.kelly@outlook.com | 478 Spring Street | Minneapolis | MN | 55456 | - | CHOICE-PLUS-PPO |
| TPA | TPA-53561 | 2026-07-07T10:33:45Z | Nancy | — | Morales | 2004-10-22 | UNKNOWN | NULL | NULL | UNKNOWN | ·· | — | ···· | - | — | NULL |
| TPA | TPA-50643 | 2026-04-11T12:29:36Z | Martha | — | Carter | 09/22/1989 | UHC-40028-30 | — | 8923339841 | null | 8319 Lake View Road | Las Vegas | NV | 89104 | - | - |
| TPA | TPA-51390 | 2026-06-27T01:50:24Z | Heather | — | Crawford | 1983-05-19 | — | — | 973.605.4805 | — | 949 CAMELBACK ROAD | ·Tampa | ·FL | 33682 | — | ···· |
| TPA | TPA-62457 | 2026-03-17T21:51:37Z | BRUCE | — | PORTER | 12/02/86 | UHC-09068-81 | •••-••-0118 | 904-641-6625 | N/A | ·2200 BAYSHORE DRIVE | Fresno | CA | ·93751-8422 | — | MEDICARE-ADV-A |
| TPA | TPA-56229 | 2026-02-10T04:43:00Z | Nancy | E | ·Richardson | 1989-05-28 | ···· | UNKNOWN | (663) 713-8851 | - | — | UNKNOWN | — | — | - | N/A |
| TPA | TPA-63658 | 2026-09-19T00:01:12Z | OMAR | — | MILLER | 1974-07-20·· | — | •••-••-8740 | 563-412-6256 | N/A | 6937 Main Street | Phoenix | AZ | 85002 | NULL | UNKNOWN |
| TPA | TPA-55198 | 2026-03-28T05:09:33Z | Gabriel | — | Woods | Jul 26, 1946 | NULL | •••-••-7016 | 12889487679 | UNKNOWN | 1388 Broadway | Las Vegas | NV | 89188 | N/A | NULL·· |
| TPA | TPA-51622 | 2026-01-17T23:25:52Z | KAREN | — | WILLIAMSON | 1989-01-28 | null | — | 612.810.6648 | - | N/A | null | UNKNOWN | — | null | ···· |
| TPA | TPA-51908 | 2026-09-24T13:33:18Z | Jeremy | J | Chapman | 12/26/85 | UHC-44520-76 | N/A | 358-664-3307 | UNKNOWN | 5814 FOREST AVE | ·Miami | FL | 33159 | N/A | UNKNOWN |
| TPA | TPA-63709 | 2026-04-06T03:47:29Z | Bruce | K | Turner | 12/12/96 | UNKNOWN | NULL | N/A | UNKNOWN·· | 7712 Park Place | San Diego | CA | 92168-8716 | GRP-6312 | NAVIGATE-HMO |
| TPA | TPA-62391 | 2026-07-01T11:20:17Z | rachel | — | yang | 1945-11-12 | null | NULL | +1 381 736 7496 | rachel.yang6@aol.com | 2921 PALM DR | DENVER | CO | 80243 | UNKNOWN | NULL |
| TPA | TPA-60261 | 2026-05-16T00:02:07Z | EVELYN | — | PALMER | 01/03/56·· | N/A | NULL | 5335273349 | — | 2570 Lake View Rd | Fresno | ca | 93770 | N/A | — |
| TPA | TPA-53531 | 2026-02-06T04:23:21Z | thomas | I. | sullivan | 1982-02-28 | UNKNOWN | — | 17659727137 | thomas.sullivan@gmail.com | 3863 River Rd | Tampa | fl | 33672 | — | CHOICE-PLUS-PPO |
| TPA | TPA-53766 | 2026-09-11T10:27:18Z | Abmer | J | Fox | 1994-12-25 | — | — | — | — | - | NULL | NULL | - | — | — |
| TPA | TPA-60965 | 2026-05-04T10:25:44Z | GABRIEL | — | STONE | 19600314 | ·null | •••-••-0669 | null | — | 8339 Washington Street | San Antonio | TX | 78232 | GRP-9722 | UNKNOWN |
| TPA | TPA-52784 | 2026-05-13T14:01:25Z | JANICE | — | ELLIS | 1972-04-17 | ···· | N/A | N/A·· | JANICE.ELLIS@HOTMAIL.COM | 8233 VALLEY VIEW DRIVE | Seattle | WA | 98153 | GRP-6216 | SELECT-EPO |
| TPA | TPA-51097 | 2026-08-20T03:18:51Z | James | — | Griffin | 19-01-1973 | - | null | — | — | 3450 Cedar Lane | PLANO | TX | 75067 | null | NULL |
| TPA | TPA-50942 | 2026-05-09T07:22:13Z | Joey | R | Willis | 27-06-1943 | — | — | null | N/A | 7981 Apache Blvd | Chandler | az | 85260 | — | UNKNOWN |
| TPA | TPA-56088 | 2026-07-08T05:07:48Z | Kyle·· | — | Medina | ·03/11/68 | N/A | UNKNOWN | +1 725 363 0271 | N/A | 7906 Ridge Road | San Diego | CA | 92149 | GRP-1055 | CORE-HMO |
| TPA | TPA-56439 | 2026-05-12T19:54:08Z | Maria | — | Wheeler | 02/11/78 | UHC-63171-78 | — | 2863458013 | maria.wheeler@aol.com | 6718 BROADWAY | Austin | TX | 78778 | null | — |
| TPA | TPA-61377 | 2026-01-09T07:32:47Z | Vasquez, Isabella | — | — | 2002-12-07 | NULL | ···· | — | ISABELLA.VASQUEZ@HOTMAIL.COM | 6491 WASHINGTON STREET·· | Tempe | AZ | 85245 | — | UNKNOWN |
| TPA | TPA-63513 | 2026-08-15T15:29:19Z | Susan | ·· | Larson | 1966-04-24 | N/A | ·- | null | ···· | 8213 Indian School Rd | Orlando | ·FL | 32859-0831 | null | N/A·· |
| TPA | TPA-50334 | 2026-07-25T11:54:42Z | Robinson, Patrick | R. | — | 1977-04-11 | UHC-78696-43 | N/A | 277.645.6911 | — | 7387 BAYSHORE DRIVE | Sacramento | CA | 95862 | GRP-0647 | — |
| TPA | TPA-63494 | 2026-07-25T22:03:19Z | George | — | Estrada | 06/18/1989 | UNKNOWN | •••-••-0788 | (223) 500-2919 | GEORGE.ESTRADA@YAHOO.COM | 3618 CANYON ROAD | Atlanta | GA | 30300-1156 | NULL | NULL |
| TPA | TPA-63641 | 2026-05-02T15:42:58Z | Lucas, Joseph | ·· | — | 1963-11-28 | — | — | -·· | joseph.lucas@icloud.com | 4555 LINCOLN WAY·· | Atlanta | GA | 30345 | GRP-8004 | UNKNOWN |
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:43:00.492Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty