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-56566 | 2026-05-10T13:42:23Z | Rebecca | — | Bailey | Dec 20, 1986 | — | NULL | - | - | 1884 Willow Court | ·Jacksonville | fl | 32214 | — | — |
| TPA | TPA-54895 | 2026-10-01T21:19:25Z | Karen | — | Shaaw | 08-04-1995·· | null | ·UNKNOWN | null | — | ·9539 Camelback Road Apt 26 | Austin | TX | 78745 | GRP-4060 | — |
| TPA | TPA-56453 | 2026-03-08T16:03:54Z | GRACE | — | SANDOVAL | 1994-07-17 | uhc-09986-75 | •••-••-2192 | — | - | 3704 CANYON ROAD | Glendale | az | ·85331 | GRP-0565 | NULL |
| TPA | TPA-56240 | 2026-05-19T18:00:51Z | Ralph | — | Cole | 19640611 | — | - | 251-871-4110 | — | 9782 Valley View Dr | TUCSON | AZ | ·85778 | NULL | N/A |
| TPA | TPA-61876 | 2026-03-05T03:16:54Z | PHILIP | — | JOHNSTON | 1966-07-26·· | null | •••-••-4955 | — | ···· | 9556 RIVER ROAD | Tucson | AZ | 85789 | - | — |
| TPA | TPA-58641 | 2026-02-17T05:19:27Z | Nathen | ·· | Robertson | 19970722 | — | ·null | null | NATHAN.ROBERTSON59@GMAIL.COM | 8063 Meadow Ln | Mesa | AZ | 85274 | null | UNKNOWN |
| TPA | TPA-60191 | 2026-06-25T05:41:39Z | Megan | — | Lawrence | 1963-11-26 | UHC-76908-83 | •••-••-2735 | 461.731.1412 | MEGAN.LAWRENCE@PROTON.ME | 5603 BASELINE ROAD | Phoenix·· | Arizona | 85001 | ·· | CHOICE-PLUS-PPO |
| TPA | TPA-61501 | 2026-09-25T23:22:30Z | ·kayla | — | cole | 20080227 | null | •••-••-0377 | - | — | 2740 Highland Avenue | Nashville | TN | 37276 | ·NULL | UNKNOWN |
| TPA | TPA-51051 | 2026-05-27T16:04:11Z | Joyce | — | Carr | 08/01/1976 | UHC-88883-33 | null | (809) 406-2738 | N/A | 5711 Broadway | Nashville | ·TN | 37200 | GRP-1849 | — |
| TPA | TPA-64302 | 2026-07-22T23:13:01Z | Wallace, Juan | — | — | 19540227 | UHC-92362-72 | — | — | — | 5508 Union Street | Columbus | OH | 43254 | GRP-4474 | CORE-HMO |
| TPA | TPA-50775 | 2026-07-30T13:22:56Z | Washington, Walter | I | — | 1944-03-04 | — | UNKNOWN | — | NULL | 2644 Hillcrest Road·· | San Diego | CA | 92127 | — | — |
| TPA | TPA-57978 | 2026-02-19T17:12:44Z | SHARON | — | ·ORTIZ | ·null | null | •••-••-5470 | — | — | 8541 Main Street | MIAMI | FL | 33150 | GRP-7470 | - |
| TPA | TPA-53620 | 2026-09-26T05:39:04Z | isabella | ···· | herrera | 1938-05-17 | UNKNOWN | NULL | 15668649491 | ISABELLA.HERRERA56@HOTMAIL.COM | — | N/A | — | — | GRP-7089 | UNKNOWN·· |
| TPA | TPA-58735 | 2026-06-18T18:46:36Z | Sandra | — | ·Welch | 1996-09-09·· | — | null | +1 871 565 8476 | - | null | null | null | null | — | SELECT-EPO |
| TPA | TPA-63877 | 2026-04-01T04:24:54Z | Robert | — | Simpson·· | Jun 15, 1941 | - | UNKNOWN | ·- | UNKNOWN | 9634 Sage Ct | MESA | AZ | 85256 | null | UNKNOWN |
| TPA | TPA-60625 | 2026-08-12T04:56:04Z | JACK | — | ROSE | 1954-02-02 | UHC-37958-45·· | null | 827-478-7053·· | — | null | — | NULL | - | null | UNKNOWN |
| TPA | TPA-54460 | 2026-04-04T06:56:19Z | Chuck | — | Rice | 1953-09-09 | — | null | NULL | charles.rice2@gmail.com | 8697 Main Street | Jacksonville | FL | 32245 | N/A | — |
| TPA | TPA-64070 | 2026-08-07T00:25:02Z | ·Vincent | ·· | Riley | 19641224 | N/A | null | - | — | 1651 GRAND AVENUE | ATLANTA | Georgia | 30381 | null | CHOICE-PLUS-PPO |
| TPA | TPA-50579 | 2026-03-08T08:09:46Z | Angela | — | Myers | 1/9/2003 | null | NULL | UNKNOWN | — | ·3652 Oak St | Jacksonville | Florida | 32238·· | — | medicare-adv-a |
| TPA | TPA-59525 | 2026-06-01T07:14:09Z | ·Pamela | — | Grant | 1949-06-15 | - | — | null | NULL | 6343 Maple Avenue | Denver | Colorado | 80235 | GRP-0111 | — |
| TPA | TPA-56781 | 2026-03-22T14:33:09Z | Mark | — | Hunter | 1941-09-01 | UNKNOWN | •••-••-1537 | N/A | - | 1443 Elm St | SAN DIEGO | CA | 92170-5568 | N/A | ·UNKNOWN |
| TPA | TPA-61287 | 2026-03-31T03:44:05Z | PAUL | O | RICHARDS | 1967-04-11 | UNKNOWN | NULL | 419.304.7267 | NULL | 5432 PINE DR | Las Vegas | Nevada | 89141 | N/A | ·N/A |
| TPA | TPA-52012 | 2026-06-19T00:28:39Z | Hannah | — | Hunter | 1956-12-07 | NULL | null·· | 6405321221 | — | ·8685 MARKET ST | Los Angeles | CA | 90072 | — | — |
| TPA | TPA-57955 | 2026-05-17T17:33:14Z | Griffin, Doroty | — | — | 08/16/42 | null | NULL | — | — | 968 CAMELBACK ROAD | AUSTIN | TX | 78770 | GRP-6707 | - |
| TPA | TPA-63305 | 2026-03-13T06:08:50Z | Lida | — | Watson | 2005-10-21 | UHC-57475-22 | - | null | NULL | — | NULL | — | UNKNOWN | GRP-4340·· | ·N/A |
| TPA | TPA-59241 | 2026-02-16T09:01:02Z | GEORGE | — | ESTRADA | ·May 27, 1950 | - | •••-••-4522 | 6503148876 | N/A | NULL | null | UNKNOWN | — | null | NULL |
| TPA | TPA-51094 | 2026-07-08T21:44:44Z | JACOB | — | WILSON | 1964-02-09 | UHC-87096-71 | - | null | — | 1598 Lincoln Way | ATLANTA | Georgia | 30322 | NULL | null |
| TPA | TPA-62833 | 2026-03-03T03:38:04Z | Sharon | — | Stone | 1949-09-05 | NULL | NULL | (719) 865-5984 | NULL | 8449 River Road | Orlando | FL | 32843·· | — | — |
| TPA | TPA-51677 | 2026-05-30T06:06:10Z | GERALD | — | HARRIS | Nov 10, 2001 | UHC-76132-83 | UNKNOWN | null | gerald.harris4@outlook.com | 2875 Mountain View Dr | Dallas | TX | 75275 | — | null |
| TPA | TPA-62758 | 2026-10-13T07:44:13Z | Diane | — | George | 1994-09-26 | null | - | N/A | — | 6546 SPRING STREET Apt 8 | Houston | TX | 77077-3392 | — | — |
| TPA | TPA-51085 | 2026-05-29T10:20:17Z | Sarra·· | — | Riley | 11/24/1968 | - | NULL | 560.470.7904 | sara.riley43@hotmail.com | — | — | - | — | ·· | CHOICE-PLUS-PPO |
| TPA | TPA-60649 | 2026-03-27T07:08:01Z | TERESA | — | MURPHY | 1967-10-09 | — | null | 318.223.6218·· | — | 4268 Broadway | ·Mesa | AZ | 85269 | GRP-8031 | MEDICARE-ADV-A |
| TPA | TPA-54012 | 2026-07-18T10:10:56Z | joshua | — | ·roberts | ·03/27/1963 | NULL | UNKNOWN | — | N/A | 9038 WASHINGTON STREET | Columbus | oh | 43202 | GRP-1102 | null |
| TPA | TPA-54913 | 2026-03-24T16:02:43Z | Roger | — | Ramirez | 1976-04-23 | ···· | •••-••-0319 | null | NULL | — | — | — | N/A | GRP-6283 | — |
| TPA | TPA-53414 | 2026-09-21T01:11:14Z | Jaince | ···· | Moreno | 1950-12-06 | ·UHC-99841-47 | UNKNOWN | — | null | 4861 Grand Avenue | ·Sacramento | CA | 95813 | GRP-1129 | — |
| TPA | TPA-54684 | 2026-03-28T11:19:26Z | GRACE | H | ROSS | 1985-12-22 | N/A | •••-••-2549 | 2152747706 | — | 5740 SUNSET BOULEVARD | Eden Prairie | ·MN | ·55308 | GRP-9022·· | UNKNOWN |
| TPA | TPA-50436 | 2026-08-24T12:46:01Z | CAMILA | — | SANTOS | 20-11-1951 | NULL | - | N/A | UNKNOWN | 4386 Lake View Rd | Seattle | ·WA | — | UNKNOWN | OPTIONS-PPO |
| TPA | TPA-51992 | 2026-05-04T19:47:35Z | SEAN | — | MURENO | 1989-08-28 | ···· | •••-••-5328 | 9699642 | NULL | 8250 Elm Street | San Diego | CA | 92188 | GRP-4938 | NULL |
| TPA | TPA-58958 | 2026-08-24T22:58:44Z | Kayla | — | Hawkins | 1983-10-01 | - | NULL | — | - | N/A·· | - | — | - | — | UNKNOWN |
| TPA | TPA-57643 | 2026-05-12T21:08:56Z | Isabella | — | Cook | 2003-12-09 | — | N/A | — | NULL | 1808 Elm Street | Eden Prairie | MN | 55386 | — | — |
| TPA | TPA-52076 | 2026-03-03T06:19:26Z | Gabriel | — | Moreno | 1963-03-04 | UHC-78406-35 | — | (876) 770-1307 | — | 492 PINE DRIVE | Los Angeles | CA | 90049 | — | — |
| TPA | TPA-58255 | 2026-07-17T05:19:30Z | YUKKI | — | HANSON | 3/4/1981 | - | •••-••-6090 | — | UNKNOWN | - | — | — | — | GRP-0503 | - |
| TPA | TPA-58756 | 2026-09-19T15:45:42Z | SANDRA | — | LEWIS | Jan 8, 2005 | ·null | — | (679) 356-3349 | N/A | 7524 Pine Dr | DALLAS | TX | 75290 | null | NULL·· |
| TPA | TPA-57397 | 2026-01-24T07:47:00Z | Kim | — | Morrison | 1978-02-03 | — | — | — | KIMBERLY.MORRISON@OUTLOOK.COM | 5491 WILLOW CT | Plano | TX | 75030 | GRP-9407 | null |
| TPA | TPA-59289 | 2026-04-16T06:37:21Z | Riso, Heather | — | — | Jan 24, 1943 | UHC2571390 | •••-••-7482 | N/A | UNKNOWN | — | - | — | N/A | GRP-9901 | CORE-HMO·· |
| TPA | TPA-55757 | 2026-01-19T07:28:13Z | Sarah | — | ·Tucker | 1943-09-21 | ·UNKNOWN | null | — | NULL | — | N/A | - | ·· | GRP-6637 | N/A |
| TPA | TPA-54178 | 2026-03-24T15:02:51Z | donald | — | griffin | 26-05-1973 | - | N/A | - | — | 9557 MAIN STREET | MESA | az | 85273 | null | — |
| TPA | TPA-56942 | 2026-05-15T05:45:02Z | Alexander | N | Thomas | 1968-03-15 | - | •••-••-8118 | 744-973-6974 | ···· | 6245 Ridge Rd | Nashville | TN | 37283 | null | MEDICARE-ADV-B |
| TPA | TPA-51701 | 2026-06-17T00:49:39Z | Margaret | — | Kelley | ·UNKNOWN | — | — | — | UNKNOWN | 6289 JEFFERSON AVENUE | Las Vegas | NV | 89138 | - | NAVIGATE-HMO |
| TPA | TPA-61809 | 2026-05-02T21:01:48Z | Robert | — | Harper | 09/18/95 | N/A | - | — | UNKNOWN·· | 4989 MAIN ST | Chandler | AZ·· | 85219 | — | null |
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:40.604Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty