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-61257 | 2026-01-29T10:24:18Z | Walter | — | Morris | 1945-08-18 | UNKNOWN | null | NULL | - | 9310 FOREST AVE | ·Las Vegas | NV | — | NULL | N/A |
| TPA | TPA-52268 | 2026-04-17T21:46:18Z | Mariana | — | Carlson | ·1958-07-21 | UHC8377486 | null | UNKNOWN | UNKNOWN | 3744 ELM STREET | Minneapolis | MN | NULL | - | CORE-HMO |
| TPA | TPA-60611 | 2026-03-17T09:02:53Z | Austin, Wei | — | — | 1994-08-27 | null | ·NULL | 615-860-3465 | NULL | 1250 RIVER RD | ORLANDO | FL | 32814 | GRP-9521 | UNKNOWN |
| TPA | TPA-54203 | 2026-09-17T07:00:01Z | ANTHONY | — | GRAHAM | 09-10-1963·· | — | •••-••-4322 | 978-753-1810 | — | 8414 Highland Ave | Las Vegas | NV | 89165 | null | MEDICARE-ADV-B |
| TPA | TPA-62476 | 2026-08-18T12:19:08Z | BOBBY | — | MORGAN | 12/26/2005 | - | •••-••-3411 | - | — | 5906 Maple Ave·· | Fresno | CA | 93738 | GRP-2962 | N/A |
| TPA | TPA-59475 | 2026-08-13T15:16:00Z | ·virginia | — | schmidt | 1967-09-09 | — | — | +1 893 319 8397 | - | 9250 FOREST AVENUE | Seattle | WA | 98146 | N/A | NULL |
| TPA | TPA-54823 | 2026-06-27T09:29:11Z | Nicholas | J | Little | 1996-03-25 | null | N/A | null | nicholas.little8@gmail.com | 2786 BAYSHORE DRIVE | Scottsdale | AZ | ·85279 | GRP-0792 | CORE-HMO |
| TPA | TPA-61637 | 2026-09-20T16:43:30Z | ·Aaron | — | Moore | 1995-06-17·· | ·· | •••-••-1211 | — | — | 7264 Indian School Rd | San Diego | CA | 92174·· | NULL | MEDICARE-ADV-B |
| TPA | TPA-59373 | 2026-03-22T22:24:04Z | Valentina | Q | Ellis | 1949-10-14 | NULL | — | UNKNOWN | UNKNOWN | 3256 MARKET ST | Tucson | AZ | 85710 | N/A | N/A |
| TPA | TPA-52581 | 2026-05-18T07:44:07Z | Wallace, Barbara | ···· | — | 1984-12-25 | - | NULL | UNKNOWN | barbara.wallace@yahoo.com·· | 3506 Willow Court | Phoenix | AZ | ·85081 | null | NULL |
| TPA | TPA-56568 | 2026-06-25T18:02:52Z | JEREMY·· | — | DIAZ | 2003-04-27 | — | •••-••-1772 | (482) 777-7442 | — | 5050 MAPLE AVE | San Antonio | TX | 78286 | NULL | UNKNOWN |
| TPA | TPA-50972 | 2026-10-01T22:01:07Z | Abigail | — | Snyder | 24-05-1997 | UNKNOWN | — | — | ABIGAIL.SNYDER24@HOTMAIL.COM | NULL·· | null | NULL | null | — | - |
| TPA | TPA-52956 | 2026-02-04T06:29:44Z | Anna | — | Adams | 2003-09-24 | null | — | 693-203-0709 | — | 504 Ridge Road | MINNEAPOLIS | MN | 55488 | ·null | NAVIGATE-HMO |
| TPA | TPA-61380 | 2026-07-20T23:18:42Z | doris | ···· | ·kelly | 1957-03-07 | — | •••-••-2678 | 3952726980 | UNKNOWN | 9827 HIGHLAND AVE | Seattle | WA | 98162 | - | MEDICARE-ADV-A |
| TPA | TPA-61192 | 2026-05-15T13:31:10Z | Isabella | — | Lynch | 19731109 | — | — | 8597405922 | - | 7754 Valley View Drive | Gilbert | AZ | 85235 | — | — |
| TPA | TPA-59944 | 2026-07-05T00:27:22Z | Isabella | — | Hanson | 1969-02-15 | - | •••-••-5580 | 900-289-7182 | — | 6627 APACHE BOULEVARD | EDEN PRAIRIE | MN·· | 55326 | UNKNOWN | - |
| TPA | TPA-59556 | 2026-04-19T02:46:19Z | lori | K. | soto | 1956-09-26 | N/A | •••-••-7638 | UNKNOWN | ·LORI.SOTO59@ICLOUD.COM | ·9248 HARBOR BLVD | Tampa | FL | 33669 | GRP-6674 | SELECT-EPO |
| TPA | TPA-63627 | 2026-01-19T17:07:06Z | Cox, Matthew | — | — | 1952-01-15 | NULL | NULL | (850) 983-4923 | N/A | UNKNOWN | — | null | ·· | NULL | — |
| TPA | TPA-60163 | 2026-02-20T22:33:57Z | RAYMOND | — | TURNER·· | Sep 9, 1999 | NULL | - | 19878746251 | -·· | 321 Grand Avenue #314 | Denver | CO | 80208-3568 | - | null |
| TPA | TPA-50892 | 2026-01-27T14:26:36Z | CHARLOTTE | — | OLIVER | 1995-04-07 | UNKNOWN | UNKNOWN | — | charlotte.oliver@gmail.com | 951 Jefferson Ave Apt 21 | Sacramento | CA | 95887 | ·· | ···· |
| TPA | TPA-60371 | 2026-08-18T10:15:37Z | JOSEPH | — | REID | 11-04-1944 | NULL | •••-••-5393 | 648-376-2113 | — | 9792 Pine Dr | Minneapolis | ·MN | 55464 | null | — |
| TPA | TPA-55168 | 2026-05-05T03:32:44Z | DENISE | — | ROS | 1975-07-10 | uhc-51808-48 | null | ·+1 305 646 9510 | N/A | 9734 APACHE BOULEVARD | Columbus | OH | 43223 | GRP-9451 | SELECT-EPO |
| TPA | TPA-54565 | 2026-07-03T02:53:15Z | ·Denise | — | Hanson | 24-10-1967 | N/A | null | N/A | NULL | 5749 Willow Ct | Sacramento | ca | 95867 | GRP-8496 | select-epo |
| TPA | TPA-62797 | 2026-01-23T08:16:13Z | ·Judy | — | Patterson·· | 1998-03-07 | - | null | ·NULL | NULL | 7921 CHURCH STREET | Austin | TX | 78767 | GRP-3059 | UNKNOWN |
| TPA | TPA-60872 | 2026-07-04T10:10:26Z | Eliah | ···· | Webb | 9/3/1981·· | — | — | (302) 563-0804 | elijah.webb@outlook.com | 1767 Washington St | MIAMI | FL | 33105 | GRP-1966 | NAVIGATE-HMO |
| TPA | TPA-55836 | 2026-08-14T08:56:10Z | KATHERINE | — | GOMEZ·· | 2007-07-28 | — | — | 755.363.5923 | katherine.gomez1@gmail.com | 2883 HILLCREST RD | JACKSONVILLE | FL | 32213 | — | null |
| TPA | TPA-56760 | 2026-01-14T04:31:34Z | KATHLEEN | — | WATKINS | 1971-05-26 | ·- | null | NULL | — | ·630 Desert Sky Boulevard | Charlotte | NC | 28297 | - | N/A |
| TPA | TPA-55826 | 2026-03-14T16:10:09Z | David·· | — | Lynch | 1959-02-27 | - | NULL | 902-990-3252 | — | 4340 RIVER RD | Tempe | AZ | 85232 | GRP-1686 | ·CHOICE-PLUS-PPO |
| TPA | TPA-52882 | 2026-09-15T09:34:13Z | Brian | — | Nunez | 1966-01-09 | — | - | NULL | — | 8089 SUNSET BLVD | Las Vegas | NV | 89166 | GRP-3735 | MEDICARE-ADV-A |
| TPA | TPA-59452 | 2026-05-01T23:21:59Z | Thompson, Frank | — | — | 1982-09-06·· | — | null | 3184719·· | UNKNOWN | 5660 VALLEY VIEW DRIVE | Fresno | CA | 93730 | GRP-3889 | OPTIONS-PPO·· |
| TPA | TPA-50352 | 2026-07-30T09:54:30Z | Jennifer | ·· | Hernandez | 1947-08-10 | UHC-59786-48·· | null | NULL | JENNIFER.HERNANDEZ66@HOTMAIL.COM | 6284 Indian School Road | Chandler | AZ | NULL | — | UNKNOWN |
| TPA | TPA-60498 | 2026-10-01T00:49:44Z | JOYCE | — | SOTO | 1969-09-28 | — | •••-••-2268 | ·N/A | null | 3811 Church Street | Atlanta | Georgia | ·30343 | ·UNKNOWN | MEDICARE-ADV-A |
| TPA | TPA-54407 | 2026-04-24T10:58:06Z | Sarah | — | Campbell | 1945-02-09 | ·null | — | 5063846435 | sarah.campbell@proton.me | — | — | N/A | — | null | null·· |
| TPA | TPA-51590 | 2026-05-16T15:12:52Z | Carl | C | Hill | 1994-10-06 | — | — | 779-972-5256 | carl.hill@icloud.com | UNKNOWN | - | - | — | — | ·UNKNOWN |
| TPA | TPA-57462 | 2026-06-22T20:16:24Z | — | — | — | 1967-01-23 | UHC-12402-61 | — | N/A | — | 4340 Canyon Road | Chandler | AZ | 85252 | GRP-5862 | NULL |
| TPA | TPA-58840 | 2026-06-18T00:53:28Z | Campbell, Olivia | — | — | 1987-09-15 | ·null | — | UNKNOWN | - | - | UNKNOWN | — | — | null | - |
| TPA | TPA-62064 | 2026-02-27T08:51:51Z | Isabella | — | George | 11/27/1988 | — | N/A·· | 6533750 | NULL | 9793 Lake View Rd | Austin | TX | 78766 | - | CHOICE-PLUS-PPO |
| TPA | TPA-63829 | 2026-02-01T22:53:09Z | ARTHUR | — | BOYD·· | 06/22/1978 | — | N/A | — | NULL | 6927 Lincoln Way | San Diego | CA·· | 92194 | null | — |
| TPA | TPA-54376 | 2026-09-17T08:06:18Z | Cynthia | — | Contreras | 1978-03-06 | - | UNKNOWN·· | — | N/A | 4353 Washington Street | Phoenix | AZ | 85043 | UNKNOWN | NULL |
| TPA | TPA-50861 | 2026-09-19T22:46:48Z | SEAN | B | ALVARADO | 1974-11-08 | NULL | null | null·· | UNKNOWN | ···· | N/A | — | N/A | GRP-5900 | — |
| TPA | TPA-53393 | 2026-07-23T02:40:50Z | Hat, Billy | — | — | 1986-01-16 | N/A | •••-••-3944 | — | — | 6343 Ridge Road·· | San Antonio | TX | 78288 | GRP-3767 | — |
| TPA | TPA-60566 | 2026-01-31T06:06:36Z | Cynthia | — | Medina | 1950-05-20 | — | ···· | — | — | ·3801 Grand Ave | Las Vegas | NV·· | 89118 | N/A | — |
| TPA | TPA-55507 | 2026-03-19T10:09:57Z | Nathan | — | Thomposn | 1965-07-03 | NULL | •••-••-1344 | 569-978-2489 | — | N/A | NULL | - | N/A | GRP-2542 | core-hmo |
| TPA | TPA-58685 | 2026-07-20T17:49:00Z | Diana | — | Freeman | ·7/17/1962 | N/A | — | - | N/A | 2721 ELM ST | JACKSONVILLE | Florida | 32234 | — | — |
| TPA | TPA-58882 | 2026-01-18T18:14:20Z | JOSE | — | GRIFFIN | 1973-12-16 | NULL | — | NULL | null | 6349 BROADWAY | EDEN PRAIRIE | MN | ·55370 | GRP-6675 | — |
| TPA | TPA-54002 | 2026-01-21T03:07:08Z | jonathan | — | davis | 1970-02-15 | N/A | •••-••-3144 | +1 396 936 8043 | — | 6574 Sage Court | Gilbert | AZ | 85207 | GRP-0957 | N/A·· |
| TPA | TPA-56930 | 2026-01-17T10:19:29Z | gerald·· | — | hunter | 20080704 | — | •••-••-1757 | N/A | NULL | 5105 Sunset Boulevard | COLUMBUS | OH | 43216 | null | MEDICARE-ADV-A |
| TPA | TPA-62936 | 2026-07-08T21:22:56Z | Austin | — | Jensen | 19450806 | — | — | - | austin.jensen68@icloud.com | 6006 Church St | San Diego | CA | - | ···· | UNKNOWN |
| TPA | TPA-50168 | 2026-03-18T02:29:53Z | Mark | — | Stevens | 1988-08-18 | null | — | 746-336-9917 | — | 3343 Apache Blvd | Sacramento·· | CA | UNKNOWN | — | OPTIONS-PPO |
| TPA | TPA-54769 | 2026-09-04T14:54:51Z | RYAN | — | KNIGHT | 1952-11-19 | - | — | (947) 773-8831 | - | 8974 Willow Ct | Houston | TX | 77050 | — | NAVIGATE-HMO |
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.462Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty