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-55038 | 2026-02-17T07:38:50Z | ·CHARLES | A | ·LITTLE | 1951-04-09 | ·UHC-26339-12 | NULL | 5843517130 | null | 2376 WASHINGTON STREET | Fresno | CA·· | 93740 | — | UNKNOWN |
| TPA | TPA-60453 | 2026-09-24T00:24:28Z | Donald | O. | Jones | 19950324 | ·· | — | — | — | - | NULL | — | null | ·NULL | UNKNOWN |
| TPA | TPA-61041 | 2026-08-26T08:42:03Z | PATRICIA | — | MARTIN | 19470424·· | — | — | - | — | 1060 Desert Sky Boulevard | San Antonio | TX | N/A | UNKNOWN | UNKNOWN |
| TPA | TPA-60658 | 2026-02-09T03:37:28Z | Black, Michelle | — | — | ·1997-12-14 | NULL | — | (880) 915-7048 | - | 8695 LINCOLN WAY | Atlanta | ga | 30398 | UNKNOWN | NAVIGATE-HMO |
| TPA | TPA-58052 | 2026-06-30T02:48:25Z | Grant, Sara | Y | — | ·01/24/87 | — | N/A | — | N/A | 5202 Cedar Ln | Plano | TX | 75050 | NULL | null |
| TPA | TPA-58600 | 2026-08-02T01:55:04Z | Mark | — | Smith | 23-12-1999 | ···· | - | null | - | 9291 Elm Street #521 | Seattle | WA | 98108 | GRP-4065 | OPTIONS-PPO |
| TPA | TPA-51938 | 2026-08-27T00:04:05Z | Wei | — | Gardner | Apr 1, 1971 | — | null | 6495336650 | — | 7039 Apache Boulevard | Columbus | Ohio | 43244 | - | CORE-HMO |
| TPA | TPA-55253 | 2026-10-16T21:47:19Z | Carol | R | Walker | 1986-08-16 | ···· | — | 205-265-1534 | - | 384 GRAND AVE | ORLANDO | FL | 32870 | null | OPTIONS-PPO |
| TPA | TPA-54378 | 2026-09-13T10:20:10Z | Roy | — | Carlson | Oct 5, 1981 | — | - | — | roy.carlson@outlook.com | 1263 HARBOR BLVD | Gilbert | Arizona | 85277 | GRP-9883 | MEDICARE-ADV-B |
| TPA | TPA-50120 | 2026-06-25T07:31:50Z | Lauren | — | Castro | Jan 22, 1964 | — | — | ·NULL | UNKNOWN | NULL | - | - | NULL | NULL | MEDICARE-ADV-A·· |
| TPA | TPA-59171 | 2026-07-18T15:03:39Z | SANDRA | — | CARLSON·· | 1941-04-05 | — | — | null | — | NULL | — | — | ·null | — | NAVIGATE-HMO |
| TPA | TPA-56450 | 2026-07-27T20:43:33Z | Ethan | — | Harvey | N/A | — | - | - | — | UNKNOWN | — | null | UNKNOWN | GRP-4817 | null |
| TPA | TPA-61199 | 2026-01-10T23:49:09Z | Pemela | — | Arnold | 06-03-1974 | N/A | - | - | PAMELA.ARNOLD@AOL.COM | ·3833 WILLOW COURT | Tempe | AZ | 85259 | - | ·CORE-HMO |
| TPA | TPA-54780 | 2026-07-10T10:48:42Z | Rebecca | — | Vasquez | 2002-07-27 | null | — | ·N/A | N/A | ·8831 CANYON RD | Glendale | AZ | — | null | — |
| TPA | TPA-52709 | 2026-08-23T07:12:21Z | Adam | ·· | Collins | 19750608 | null | •••-••-0906 | UNKNOWN | NULL | 2667 Canyon Road·· | TUCSON | AZ | 85765 | — | null |
| TPA | TPA-58122 | 2026-05-04T07:28:37Z | MEGAN | — | FORD | May 18, 2008 | null | - | N/A | -·· | 1688 Bayshore Drive | Columbus | OH | 43231 | GRP-4996 | - |
| TPA | TPA-63792 | 2026-03-15T19:18:51Z | RUSSELL | — | WILLIAMSON | 1990-12-09 | UHC-62850-78 | UNKNOWN | 456-557-1369 | - | 8828 OCEAN AVE | Eden Prairie | MN | 55385-2649 | UNKNOWN | CHOICE-PLUS-PPO |
| TPA | TPA-53363 | 2026-04-07T21:55:36Z | Luis | — | ·Burns | 2000-08-08 | null | •••-••-3610 | NULL | — | 3270 Oak Street | Denver | CO | 80219 | — | NAVIGATE-HMO |
| TPA | TPA-51139 | 2026-01-09T23:45:58Z | philip | C. | mccoy | Aug 25, 1991 | NULL | •••-••-3249 | ·· | null | 7432 Camelback Rd | Denver | ·CO | 80242-9055 | GRP-9025 | NAVIGATE-HMO |
| TPA | TPA-61129 | 2026-09-09T07:22:47Z | ·JORDAN | — | MASON·· | 3/7/1963 | null | — | ·· | N/A | 9391 Valley View Dr | Nashville | Tennessee·· | 37291-3240 | N/A | UNKNOWN |
| TPA | TPA-60671 | 2026-04-15T16:42:31Z | Stephanie | — | Porter | 1974-01-20 | - | •••-••-2519 | — | — | 3850 Jefferson Ave | Los Angeles | CA | 90086 | null | — |
| TPA | TPA-54664 | 2026-04-21T17:40:03Z | Roger | — | Chapman | 1962-09-24 | — | NULL | NULL | roger.chapman@aol.com | ·694 Meadow Ln | Seattle | WA | 98148 | GRP-5956 | SELECT-EPO |
| TPA | TPA-55949 | 2026-04-18T04:19:20Z | Noah | — | Padilla | 1984-09-20 | UNKNOWN | — | NULL | - | 5201 HIGHLAND AVE | Austin | tx | 78774·· | GRP-0456 | — |
| TPA | TPA-54763 | 2026-09-26T08:44:54Z | Sara | M | Kennedy·· | 2000-01-08 | UNKNOWN | ···· | 827-637-3717 | UNKNOWN | 5858 Elm Street | Denver | CO | — | UNKNOWN | — |
| TPA | TPA-57174 | 2026-02-18T15:59:29Z | ·MADISON | ·· | TAYLOR | 1957-08-22·· | - | •••-••-8581 | 296-798-5659 | ·NULL | 16 Ocean Avenue | Jacksonville | FL | 32299 | — | MEDICARE-ADV-B |
| TPA | TPA-61477 | 2026-10-02T11:40:42Z | Susan | A | Chavez | 1963-08-08 | NULL | •••-••-5270 | - | N/A | UNKNOWN | - | — | — | GRP-7937 | N/A |
| TPA | TPA-52015 | 2026-06-12T09:55:14Z | Long, Judy | — | — | 05/20/2001 | N/A | - | NULL | null | 4143 Apache Boulevard | Gilbert | AZ | 85272 | — | NULL |
| TPA | TPA-60824 | 2026-04-21T06:34:45Z | Bradley | Q. | Barnes | 01/18/86 | — | null·· | NULL | NULL | 1932 Spring St | Glendale | AZ | 85338 | GRP-7501 | — |
| TPA | TPA-56346 | 2026-01-15T19:23:11Z | LARRY | — | BANKS | 2007-01-04 | — | — | 390.487.4762 | - | 152 Lincoln Way | Atlanta | GA | 30367 | NULL | — |
| TPA | TPA-59037 | 2026-08-30T04:02:02Z | Roy | — | Young | 1964-04-11 | UHC-43268-74 | ···· | - | UNKNOWN | null | — | NULL | — | GRP-4867·· | MEDICARE-ADV-B·· |
| TPA | TPA-50558 | 2026-01-07T15:36:41Z | FANK | Y | PARK | 1940-10-09 | — | ·UNKNOWN | (643) 270-2924 | UNKNOWN | 9254 CEDAR LANE | Sacramento | CA | 95886-6583 | — | — |
| TPA | TPA-60354 | 2026-10-12T02:30:56Z | ·jerry | — | moore | 1963-04-12 | - | •••-••-8834 | NULL | — | 5838 LINCOLN WAY | Columbus | OH | 43249 | — | - |
| TPA | TPA-54432 | 2026-04-18T23:50:07Z | Steven | — | Ward | 1974-11-26 | UNKNOWN·· | N/A | NULL | — | 6742 ELM STREET | Las Vegas | NV | 89134 | GRP-5512 | - |
| TPA | TPA-53268 | 2026-05-20T04:11:26Z | PATRICIA | — | HAYES·· | ·2000-07-03 | UHC-59679-50 | — | — | NULL | 5615 Grand Ave | Jacksonville | FL | 32275 | — | NULL |
| TPA | TPA-54228 | 2026-08-02T19:53:35Z | WEI | — | BERRY | ·01-06-1942 | - | •••-••-8512 | - | ·wei.berry2@hotmail.com | 8201 BAYSHORE DR Apt 33 | Houston | tx | 77022 | — | UNKNOWN |
| TPA | TPA-53263 | 2026-03-10T21:16:14Z | SHIRLEY | — | WALSH | 02/11/1970 | UHC-61247-35 | ·NULL | UNKNOWN | — | 4744 Lincoln Way | ·Sacramento | California | 95852 | — | null |
| TPA | TPA-58350 | 2026-01-07T07:59:22Z | WILLIE | — | PEREZ | — | — | — | UNKNOWN | willie.perez29@hotmail.com | 5735 PARK PLACE | Sacramento | CA | 95810 | — | NAVIGATE-HMO |
| TPA | TPA-63072 | 2026-09-27T06:16:35Z | Andrew | — | Ford | 1967-04-18·· | ·· | •••-••-7912 | (255) 719-0087 | — | 4446 BAYSHORE DRIVE | Scottsdale | AZ | 85266 | null | null |
| TPA | TPA-60639 | 2026-09-12T04:52:53Z | Judy | X | Reed | Oct 25, 1995 | UHC-47525-60 | •••-••-6081 | NULL | JUDY.REED54@OUTLOOK.COM·· | 7590 GRAND AVE | ATLANTA | GA | 30378-7141 | UNKNOWN | OPTIONS-PPO |
| TPA | TPA-50664 | 2026-06-04T07:55:31Z | Ralph | F | Gonzalez | 03/16/1994 | null | — | 730-881-1916 | N/A | 7003 JEFFERSON AVENUE | Las Vegas | NV | 89189 | — | — |
| TPA | TPA-56197 | 2026-07-29T02:20:37Z | Samuel | W | Garcia | ·1939-05-05 | NULL | — | N/A | null | 8620 MEADOW LN | Seattle | WA·· | 98137 | NULL | N/A |
| TPA | TPA-51083 | 2026-07-20T21:44:02Z | Jordan | ···· | Porter | 7/21/1970 | - | — | null | - | 214 WASHINGTON STREET | LOS ANGELES | California | 90099 | GRP-1208 | N/A |
| TPA | TPA-57582 | 2026-08-31T11:35:43Z | Andreew | ·· | Smith | 19621208 | UHC9535462 | NULL | 956-297-4725 | ANDREW.SMITH@AOL.COM | 5777 Harbor Blvd | Gilbert | AZ | 85213 | — | MEDICARE-ADV-A |
| TPA | TPA-50743 | 2026-09-05T04:28:33Z | Larry | — | Porter·· | Jun 19, 1995 | — | - | — | — | 2951 Indian School Rd Apt 5 | SAN ANTONIO | TX | 78212-6023 | — | — |
| TPA | TPA-59793 | 2026-03-08T19:50:25Z | Jean | E. | Harrison | Oct 13, 2004 | N/A | •••-••-4320 | +1 800 641 5054 | jean.harrison@icloud.com | 6547 Broadway | SACRAMENTO | CA | 95886 | GRP-0451 | null |
| TPA | TPA-63752 | 2026-03-17T06:13:41Z | Patel, Sandra | — | — | 1950-08-26 | ·- | null | 590-921-9151 | null | — | — | — | UNKNOWN | — | — |
| TPA | TPA-59041 | 2026-05-04T20:10:32Z | carl | — | rivera | 1980-12-03 | N/A | — | - | — | 5451 Grand Ave | Eden Prairie | Minnesota | 55370 | GRP-4324 | CHOICE-PLUS-PPO |
| TPA | TPA-56233 | 2026-07-12T23:57:07Z | Jordan | — | Kim | ·10/28/1938 | N/A | NULL | — | — | 7859 Baseline Rd | Minneapolis | MN | 55477 | — | ···· |
| TPA | TPA-62849 | 2026-01-15T11:35:37Z | justin | — | ruiz | 1971-06-17 | N/A·· | N/A·· | — | ·N/A | 4303 GRAND AVENUE | LAS VEGAS | Nevada | 89134 | NULL | MEDICARE-ADV-B |
| TPA | TPA-53231 | 2026-02-16T14:36:43Z | Benjamin | — | Webb | 1962-05-07 | — | — | — | — | — | N/A | UNKNOWN | — | GRP-9109 | 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:38.453Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty