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-55683 | 2026-06-21T10:37:38Z | Willie | ···· | Guuzman | 1959-02-17 | NULL | NULL | 6242338554 | — | 8300 Hillcrest Road·· | Atlanta | GA | 30334 | GRP-3877 | — |
| TPA | TPA-61722 | 2026-05-28T21:20:59Z | bran | — | aguilar | 1948-09-16 | UNKNOWN | — | 345-822-8569 | - | 8656 CENTRAL AVENUE | DENVER | CO | ·80225 | - | OPTIONS-PPO·· |
| TPA | TPA-63936 | 2026-05-27T07:13:41Z | ·PARKER | — | PATRICIA | 1956-07-15 | — | NULL | NULL | — | NULL·· | UNKNOWN | — | NULL | — | N/A |
| TPA | TPA-57258 | 2026-02-07T17:23:31Z | yuki | — | ward | ·12/23/1948 | — | NULL | - | yuki.ward@hotmail.com | 4400 CENTRAL AVE | Miami | ·FL | 33132 | — | — |
| TPA | TPA-57031 | 2026-03-20T17:48:03Z | Linda | — | ·Robinson | 05/22/2002 | NULL | — | ·(579) 616-4499 | null | null | - | ·N/A | N/A | — | — |
| TPA | TPA-57866 | 2026-05-31T10:14:12Z | AISHA | — | NGUYEN | 06/09/85 | — | N/A | null | N/A | UNKNOWN | null·· | — | — | ·GRP-4516 | SELECT-EPO |
| TPA | TPA-53196 | 2026-04-02T20:47:36Z | Hiroshi | — | Harper | 2008-03-06 | — | •••-••-3763 | ·774.626.6530 | NULL | 6123 BASELINE RD | Nashville | TN | 37203 | null | N/A |
| TPA | TPA-57793 | 2026-05-09T11:25:35Z | Brittany | — | Romero | 1/5/1966 | null | •••-••-3750 | NULL | - | 1928 Maple Avenue | Austin | ·TX | 78709·· | UNKNOWN | -·· |
| TPA | TPA-58142 | 2026-03-27T22:58:53Z | SARA | C | SANDERS | 03-10-1984 | — | ·null | ·· | null | ·1296 Jefferson Avenue | Gilbert | AZ | 85249 | — | — |
| TPA | TPA-64319 | 2026-06-03T09:35:00Z | Douglas | — | Lukas | 1944-09-12 | UNKNOWN | N/A | 7837058963 | — | 2791 Forest Avenue | Las Vegas | Nevada | 89177 | GRP-5927 | — |
| TPA | TPA-52827 | 2026-06-01T01:01:33Z | Mason | — | Litle | 1947-02-26 | — | •••-••-3648 | null | MASON.LITTLE@AOL.COM | 840 Market Street | Gilbert | Arizona | 85204 | N/A | NULL |
| TPA | TPA-61178 | 2026-09-16T13:46:43Z | ana | — | warren | 25-01-1963 | - | •••-••-6895 | ···· | NULL | N/A | NULL | — | — | GRP-0634 | MEDICARE-ADV-B |
| TPA | TPA-51255 | 2026-09-15T12:31:37Z | Elijah | — | Portter | 1950-09-15 | UNKNOWN·· | •••-••-2391 | N/A·· | — | 1753 DESERT SKY BLVD | Plano | TX | 75042 | N/A | — |
| TPA | TPA-61379 | 2026-05-20T20:25:44Z | Doris | — | Klly | 1957-03-07 | ·- | •••-••-2678 | NULL | DORIS.KELLY56@PROTON.ME | 9827 HIGHLAND AVENUE | Seattle | WA | 98162 | NULL | UNKNOWN·· |
| TPA | TPA-54879 | 2026-07-30T03:55:42Z | CYNTHIA | — | CAPMAN·· | 22-12-1998 | N/A | — | 743-392-7767 | — | 5035 Camelback Road | ·Glendale | AZ | 85341 | -·· | UNKNOWN |
| TPA | TPA-60970 | 2026-08-13T04:28:10Z | ZACHARY | — | GIBSON | 2001-08-24 | — | •••-••-7419 | ·null | — | 1442 MAPLE AVE | Austin | TX | 78796 | UNKNOWN | CORE-HMO |
| TPA | TPA-58752 | 2026-04-02T15:36:40Z | DORIS | — | HOFFMAN | 1938-11-04 | - | — | N/A·· | NULL | — | — | null | UNKNOWN | NULL | OPTIONS-PPO |
| TPA | TPA-58770 | 2026-06-10T22:32:16Z | Brian | — | Walsh | 1969-11-11 | — | N/A | 18335883813 | - | 8536 UNION ST | TUCSON | AZ | 85733 | GRP-8240 | — |
| TPA | TPA-57485 | 2026-02-21T00:08:20Z | Sara | — | Burton | 10/24/1941·· | N/A | •••-••-0380 | 14926145177 | ···· | — | UNKNOWN | — | ·NULL | GRP-9996 | MEDICARE-ADV-A |
| TPA | TPA-56696 | 2026-10-13T20:06:46Z | BOBBY | — | PORTER | 1697-05-06 | null | UNKNOWN | (766) 574-4346 | NULL | 9479 Camelback Road | SACRAMENTO | CA | 95834 | null | NAVIGATE-HMO |
| TPA | TPA-52100 | 2026-03-04T06:34:37Z | Albert | — | Espinoza | 1962-06-23 | — | NULL | null | — | 2343 Central Avenue | Plano | TX | 75050 | UNKNOWN | MEDICARE-ADV-A |
| TPA | TPA-56720 | 2026-01-14T13:07:40Z | Ryan | L | ·White | 1997-06-15·· | NULL | •••-••-7946 | +1 554 894 3833 | N/A | UNKNOWN | - | — | — | GRP-2674 | — |
| TPA | TPA-50486 | 2026-02-18T01:47:48Z | dnaiel | — | bailey | 19670212 | NULL | •••-••-7100 | 7083385285 | NULL | 6557 MAIN STREET | Las Vegas·· | NV | 89156 | null | OPTIONS-PPO |
| TPA | TPA-58308 | 2026-02-06T14:18:42Z | Billy | — | Austin | 05/22/92 | — | — | 8977240676 | - | UNKNOWN | — | — | — | ·UNKNOWN | SELECT-EPO |
| TPA | TPA-63474 | 2026-07-20T22:44:58Z | Lauren | — | Rice | 1980-08-12 | — | null | (477) 238-8834 | — | 7069 Sage Ct | Los Angeles | CA | 90095 | GRP-7874 | medicare-adv-a |
| TPA | TPA-53457 | 2026-02-08T20:06:04Z | KEVIN | — | CHAPMAN | 1967-09-13 | N/A | •••-••-3338 | UNKNOWN | NULL | 3206 Meadow Lane | Scottsdale | AZ | - | N/A | — |
| TPA | TPA-62013 | 2026-09-24T06:28:04Z | Isabella | H | Shaw | ·1941-12-52 | — | N/A | - | NULL | ·9248 PARK PL | Las Vegas | Nevada | 89139 | - | — |
| TPA | TPA-52721 | 2026-05-13T01:05:53Z | ·Diana | — | Beerry | 19780311 | UHC-53245-53 | •••-••-3466 | — | NULL | null | null | — | NULL | null | - |
| TPA | TPA-58226 | 2026-02-11T13:04:49Z | CYNTHIA | — | ALLEN | 1997-05-24 | — | •••-••-3879 | (630) 211-1076 | N/A | 9695 SUNSET BOULEVARD | Eden Prairie | MN·· | 55397 | GRP-0972 | null |
| TPA | TPA-54557 | 2026-08-26T04:44:14Z | Christian | — | Griffin | ·4/24/2008 | — | NULL | — | CHRISTIAN.GRIFFIN97@YAHOO.COM | 3553 Highland Avenue Apt 33 | Glendale | AZ | 85351 | NULL·· | null |
| TPA | TPA-60747 | 2026-08-21T00:54:53Z | PEGGY | — | TAYLOR | 12-04-1962 | N/A | NULL | 442-359-6196 | - | null | — | NULL | ·· | N/A | — |
| TPA | TPA-50951 | 2026-02-13T07:55:58Z | BENJAMIN | — | OBRIIEN | 8/21/1938·· | UHC-68311-73 | null | 5019348070 | NULL·· | 3925 Central Ave | Glendale | AZ | UNKNOWN | GRP-4912 | — |
| TPA | TPA-55182 | 2026-02-02T17:06:01Z | CARL | — | WATSON | 09-06-1947 | — | null | 635-614-1072 | CARL.WATSON34@AOL.COM | 4297 PALM DR | Miami | FL | 33100 | GRP-0630 | ···· |
| TPA | TPA-53153 | 2026-03-24T04:29:25Z | Pamela | — | Lucas | 19631005 | uhc-08267-93 | null | ·- | — | 6958 Highland Avenue Apt 37 | San Antonio | TX | NULL | null | NULL·· |
| TPA | TPA-62373 | 2026-02-14T15:35:06Z | Hannah | ·· | Santos | 06/09/1941 | — | •••-••-3988 | — | ·NULL | 2094 SUNSET BLVD | San Antonio | TX | 78271 | NULL·· | - |
| TPA | TPA-54490 | 2026-09-02T15:49:10Z | bradely | — | hall | 1978-05-24 | — | — | 18886447395 | — | 1877 LINCOLN WAY | Phoenix | AZ | 85054 | null | NAVIGATE-HMO |
| TPA | TPA-57623 | 2026-08-02T18:35:39Z | Carolyn | — | Gutierrez | 1948-06-25 | uhc-61047-79 | — | 8753951746 | — | 4424 Church St | Seattle | WA | 98189 | GRP-1870 | null |
| TPA | TPA-50623 | 2026-09-09T06:13:56Z | SOFIA | — | PADILLA | 2007-03-04 | — | - | (248) 762-3563 | — | 5934 Elm St | Gilbert | AZ | 85218 | GRP-0772 | — |
| TPA | TPA-58628 | 2026-08-26T04:14:04Z | Andrea | — | Russell | 1944-08-16 | - | — | 771.288.9749 | N/A | 8847 Apache Blvd | Plano | TX | 75059 | - | UNKNOWN |
| TPA | TPA-53340 | 2026-01-11T07:27:48Z | Burton | — | Logan | Aug 4, 1945 | — | N/A | - | UNKNOWN | 9374 CANYON ROAD | Houston | TX | 77017-7425 | NULL | - |
| TPA | TPA-56869 | 2026-10-02T07:22:59Z | BRADNON | ·· | COOK·· | 19690602 | null·· | •••-••-3388 | ·(806) 656-6365 | NULL | 1367 Mountain View Dr | Glendale | AZ | 85340 | GRP-8535 | — |
| TPA | TPA-60420 | 2026-09-12T07:09:45Z | Natalie | — | Duncan·· | 1972-03-22 | — | - | null·· | natalie.duncan@aol.com | 930 Meadow Ln | Las Vegas | NV | 89125 | NULL | — |
| TPA | TPA-60901 | 2026-05-09T00:42:32Z | Mara | — | Robinson | 19380519 | ·null | NULL | 420-741-0329 | UNKNOWN | 7834 Apache Blvd | PLANO | TX | — | - | null |
| TPA | TPA-59487 | 2026-07-13T15:50:40Z | natalie | — | johnson | 1968-10-03 | — | — | — | — | 3759 Forest Avenue | Mesa | AZ | 85212-4041·· | NULL | - |
| TPA | TPA-57657 | 2026-04-19T16:02:23Z | jerry | — | ramos | 1974-10-07 | null | N/A | +1 389 409 2273 | — | 5136 Elm St | Sacramento | CA | 95880 | NULL | UNKNOWN |
| TPA | TPA-62945 | 2026-08-22T19:46:44Z | KYLE | — | LANE | 1981-11-07 | NULL | — | 7489465380 | N/A | 9320 Willow Court | DALLAS | TX | 75209 | - | MEDICARE-ADV-A |
| TPA | TPA-63608 | 2026-08-25T13:39:46Z | Christian | — | Anderson | 1939-07-09 | UHC-03780-58 | •••-••-1233 | (945) 878-7180 | - | 2042 Washington Street | Orlando | FL·· | 32818 | — | CORE-HMO |
| TPA | TPA-54251 | 2026-02-23T09:12:42Z | Johnson, Doris | — | — | 1953-11-22 | - | •••-••-7274 | UNKNOWN | — | 9796 Broadway | Nashville | TN | 37252 | null | OPTIONS-PPO |
| TPA | TPA-57188 | 2026-09-11T14:46:42Z | Grace | ···· | Soto | 1948-12-28 | — | •••-••-5830 | — | N/A | 3732 HIGHLAND AVE | Scottsdale·· | AZ | 85206 | — | — |
| TPA | TPA-57621 | 2026-04-19T07:52:18Z | JAMES | — | SOTO | 2002-03-26 | null | -·· | 5302381197 | — | 7915 MEADOW LANE | Atlanta | GA | 30342 | GRP-3680 | SELECT-EPO |
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:49.088Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty