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-54301 | 2026-03-17T15:41:16Z | Charlotte·· | — | Greene | 02080209 | N/A | — | — | — | 9599 PARK PL | San Antonio | TX | 78260 | GRP-6421 | ·· |
| TPA | TPA-52090 | 2026-08-23T04:20:39Z | Andrea | — | Jimenez | 1988-11-18 | N/A | — | null | ANDREA.JIMENEZ@ICLOUD.COM | 4934 Broadway | Denver | ·Colorado | 80225 | — | NULL·· |
| TPA | TPA-55378 | 2026-04-14T03:51:38Z | Brian | — | Reyes | 06/16/1944 | — | null | NULL | NULL | 1630 Broadway | Houston·· | TX | 77008 | null | NULL |
| TPA | TPA-58615 | 2026-10-13T02:22:01Z | Brenda | — | Valdez | 10/14/1942 | UNKNOWN | •••-••-9589 | 253-375-8858 | - | 570 River Rd | Nashville | Tennessee | 37242 | — | - |
| TPA | TPA-56466 | 2026-02-08T20:44:37Z | DORIS·· | D. | WATSON | 05-12-1951 | N/A | - | 526-476-5344 | — | UNKNOWN | UNKNOWN | — | NULL | — | — |
| TPA | TPA-58988 | 2026-07-14T05:47:32Z | Patrick | O. | Boyd | 1977-05-24 | ·· | — | null | — | 7545 Mesa Dr | Mesa | AZ | 85230 | ·· | - |
| TPA | TPA-54416 | 2026-06-27T11:11:55Z | PRIYA | ·· | AGUILAR | 2000-10-24 | — | •••-••-8865 | — | — | 6298 PINE DRIVE | San Diego | CA | 92143 | — | CHOICE-PLUS-PPO |
| TPA | TPA-55599 | 2026-05-01T01:55:30Z | mei | — | jackson | ·12/15/05 | UHC5014131 | •••-••-7618 | - | NULL | 2468 WILLOW COURT | Gilbert | AZ | 85288 | ·· | - |
| TPA | TPA-55616 | 2026-01-10T00:25:08Z | Joshua | I | Moreno·· | 08/02/1994 | — | •••-••-1961 | 452-523-6822 | N/A | — | ·· | — | — | GRP-2966 | N/A |
| TPA | TPA-62444 | 2026-10-12T01:11:18Z | Scott | — | Li·· | 2004-10-06 | - | •••-••-2728 | — | scott.li@aol.com | 5197 OCEAN AVE | PHOENIX | AZ | 85086 | ·null | MEDICARE-ADV-A |
| TPA | TPA-53090 | 2026-03-11T07:43:51Z | Jennifer | ·· | Hawkins | 14-07-1943 | — | — | ·N/A | — | N/A | NULL | - | N/A | UNKNOWN | UNKNOWN |
| TPA | TPA-60741 | 2026-03-27T21:23:10Z | Omar | — | Perez | 02/05/76 | N/A | - | 268-908-9198 | ·· | 5497 CANYON RD Apt 34 | Las Vegas | Nevada | 89146 | null | NULL |
| TPA | TPA-59895 | 2026-03-11T02:43:21Z | Margaret | — | Griffin | 1947-10-20 | N/A | UNKNOWN | (207) 904-9279 | - | ·3342 River Rd | San Diego | CA | 92158-9356 | GRP-8742 | ·· |
| TPA | TPA-53701 | 2026-02-27T05:39:42Z | JOSE | — | ALVAREZ | 14-03-1940 | — | null | 801-283-6857 | UNKNOWN | 6690 Sunset Boulevard | ·Orlando | FL | 32818 | null | null |
| TPA | TPA-53951 | 2026-01-23T03:51:37Z | Arjun | — | Flores | 12/09/1978 | — | — | null | UNKNOWN | 2271 ELM STREET | CHANDLER | Arizona | UNKNOWN | N/A·· | — |
| TPA | TPA-50717 | 2026-05-08T01:31:10Z | Nathan | M | Armstrong | 02/06/42 | null | •••-••-1930 | 633.790.5699 | - | 5140 Highland Ave | Orlando | FL | 32843 | null | OPTIONS-PPO |
| TPA | TPA-56888 | 2026-10-14T01:18:13Z | Vincent | — | Green | 1988-04-03 | — | N/A | ·· | — | 4739 Church Street | Houston | TX | 77098 | — | NULL |
| TPA | TPA-62703 | 2026-10-01T22:31:04Z | Colleman, Patricia | — | ·· | May 18, 1958 | — | null | (642) 986-8458 | — | N/A | — | UNKNOWN | null | null | ·· |
| TPA | TPA-54760 | 2026-01-31T17:14:47Z | Kayla | — | Thompson | 1963-09-26 | null | •••-••-2751 | 17119538739 | N/A | 89 PARK PL #442 | Mesa | ·AZ | 85276 | GRP-0725 | OPTIONS-PPO |
| TPA | TPA-60110 | 2026-07-06T06:15:29Z | Mason | — | Reynolds | 19831014 | UHC-91476-92 | UNKNOWN | - | - | ·3585 MOUNTAIN VIEW DR | SCOTTSDALE | AZ | 85270 | GRP-3331 | OPTIONS-PPO |
| TPA | TPA-55525 | 2026-05-27T07:27:06Z | THUMAS | — | WEBB | 1966-07-03 | — | — | — | null | 5126 CEDAR LN | Scottsdale | AZ | ·85220 | — | medicare-adv-a |
| TPA | TPA-55621 | 2026-01-21T18:26:09Z | Perry, Jose | — | — | Jan 22, 1957 | N/A | UNKNOWN | — | ·N/A | 332 Ocean Avenue | Miami | FL | — | UNKNOWN | - |
| TPA | TPA-62478 | 2026-01-27T10:43:53Z | Austin | — | Wlch | 04/23/1963·· | ·UNKNOWN | NULL | 7728276325 | NULL | 278 Palm Dr | Gilbert | AZ | 85277-0891 | NULL | null |
| TPA | TPA-59764 | 2026-10-07T18:29:34Z | Lawrence | — | ·Larry | 08/16/62 | — | •••-••-6435 | — | — | 891 INDIAN SCHOOL ROAD | Glendale | AZ | 85394 | N/A | NULL |
| TPA | TPA-50950 | 2026-06-04T23:03:51Z | Christopher | — | Mendoza | 7/8/1940 | UNKNOWN | — | NULL | christopher.mendoza62@proton.me·· | null | - | N/A | — | - | — |
| TPA | TPA-62005 | 2026-04-25T05:10:33Z | Burke | O. | Bryna | Sep 15, 1998 | — | •••-••-9194 | 742-633-9903 | — | 8698 BAYSHORE DR | DALLAS·· | TX | 75228 | — | NULL |
| TPA | TPA-54975 | 2026-06-08T22:32:40Z | CHERYL | — | ANDREWS | 1971-11-24 | UHC-98602-23 | — | - | null | 8184 Mountain View Drive | Chandler | AZ | 85263 | UNKNOWN·· | — |
| TPA | TPA-56478 | 2026-07-19T22:49:29Z | ·Steven | — | George | 3007-19-71 | UHC-39607-73 | — | — | NULL | 3251 Desert Sky Boulevard | Charlotte | NC | — | — | UNKNOWN |
| TPA | TPA-50439 | 2026-09-30T13:09:40Z | JUSTIN | ···· | ORTIZ | Dec 5, 1956·· | UNKNOWN | UNKNOWN | NULL | — | NULL | — | — | — | GRP-8488 | UNKNOWN |
| TPA | TPA-58021 | 2026-01-17T14:58:26Z | Raymond | X. | Patel | 1983-07-14·· | UHC-58315-24 | NULL | 7317853236 | raymond.patel@hotmail.com | 5018 Broadway | Dallas | TX | 75201 | GRP-2359 | NULL |
| TPA | TPA-58258 | 2026-06-14T22:19:39Z | Aisha·· | ·· | Snyder | 1967-03-11 | UNKNOWN | — | — | UNKNOWN | 7756 Hillcrest Road | Atlanta | Georgia | N/A | — | null |
| TPA | TPA-63351 | 2026-07-15T11:25:23Z | MEI | — | REID | 1977-09-04 | — | NULL | (782) 467-8194 | UNKNOWN·· | 7400 Meadow Lane | EDEN PRAIRIE | Minnesota | 55382 | — | — |
| TPA | TPA-52386 | 2026-04-17T06:14:03Z | maria·· | — | johnston | Dec 18, 1964 | — | NULL | N/A | UNKNOWN | 4950 DESERT SKY BOULEVARD | Eden Prairie | MN | ·55369 | NULL | — |
| TPA | TPA-62016 | 2026-06-18T03:39:29Z | Carol | — | Murray | 1967-04-06 | ·N/A | — | ·8755683662 | UNKNOWN | 91 SPRING STREET | EDEN PRAIRIE | ·MN | 55327 | NULL·· | medicare-adv-a |
| TPA | TPA-57599 | 2026-09-22T04:17:13Z | Campbell, Jeck | — | — | 1968-03-16 | UHC-15180-41 | •••-••-2280 | ·· | NULL | 1440 GRAND AVE | Las Vegas | Nevada | 89133 | GRP-1631 | NAVIGATE-HMO |
| TPA | TPA-63525 | 2026-06-09T22:15:53Z | Edward | — | Hunt | 1999-06-24 | — | •••-••-6794 | NULL | UNKNOWN | - | - | — | NULL | GRP-2649 | NULL |
| TPA | TPA-53252 | 2026-06-04T00:39:54Z | GEORGE | — | MORRISON | 1981-02-22 | — | •••-••-3124 | +1 601 634 1074 | - | 5509 RIDGE ROAD Apt 32 | Phoenix | AZ | 85026 | — | null |
| TPA | TPA-56677 | 2026-06-28T17:21:06Z | Paul | — | Garza | 9/17/1980 | — | ·- | NULL | - | 9746 FOREST AVENUE | Austin | Texas | — | NULL | UNKNOWN |
| TPA | TPA-56804 | 2026-10-03T06:48:46Z | Maria | J | Vazquez | Oct 10, 1954 | — | NULL | 2385506675 | maria.vazquez55@yahoo.com | 891 Canyon Rd | LOS ANGELES | CA | 90042 | GRP-7124 | SELECT-EPO |
| TPA | TPA-51689 | 2026-10-01T12:25:16Z | Betty | — | Willis | 2006-05-12 | — | — | ·· | — | 7434 Canyon Rd | ·Gilbert | AZ | ·85267 | — | OPTIONS-PPO |
| TPA | TPA-54528 | 2026-06-09T21:37:07Z | Amhed | — | Riley | ·03/13/2007 | ···· | •••-••-5942 | NULL | — | 5024 Hillcrest Rd | Jacksonville | FL | 32283 | UNKNOWN | SELECT-EPO |
| TPA | TPA-59143 | 2026-08-05T05:02:12Z | Emily | — | Jones | — | NULL | — | NULL | UNKNOWN | 9687 Valley View Dr | ORLANDO | Florida | 32808 | — | NAVIGATE-HMO |
| TPA | TPA-54054 | 2026-05-01T07:07:36Z | Matthew | — | Romero | 1972-07-08 | UNKNOWN | — | — | NULL·· | 138 Market Street | Tempe | AZ | 85226 | GRP-7902 | MEDICARE-ADV-B |
| TPA | TPA-59799 | 2026-01-23T04:47:00Z | noah | — | woods | 02-10-1969·· | NULL | — | null | UNKNOWN | NULL | — | NULL | ·null | NULL | UNKNOWN |
| TPA | TPA-60591 | 2026-03-04T08:52:03Z | Alice | — | Russell | 19760909 | — | NULL | N/A | - | 1599 BAYSHORE DRIVE | Orlando | FL | 32890-1771 | GRP-0790 | UNKNOWN |
| TPA | TPA-61401 | 2026-09-03T09:25:47Z | RAYMOND | — | CARLSON | 2030-12-03 | UHC-95664-26 | NULL | N/A | UNKNOWN | 9151 CHURCH ST·· | Houston | Texas | 77059 | GRP-8599 | - |
| TPA | TPA-58820 | 2026-01-06T00:57:55Z | Martha | — | Castro | 1946-08-12·· | — | NULL | 5138028963 | UNKNOWN | 8370 Mountain View Drive | Houston | ·TX | 77097 | GRP-7867 | - |
| TPA | TPA-54372 | 2026-08-20T09:31:44Z | Sofia | — | Weaver | 6/5/1968 | — | null | 3593601826 | ·UNKNOWN | N/A | - | N/A | N/A | null | — |
| TPA | TPA-54393 | 2026-01-25T10:03:31Z | Soophia | — | Richardson·· | 1946-07-02 | — | •••-••-1828 | 7203237001 | null | 2328 CHURCH STREET·· | PLANO | ·TX | 75004-2976 | ·NULL | ·· |
| TPA | TPA-63985 | 2026-05-27T22:32:26Z | Christopher | — | Willis | 1953-10-21 | — | •••-••-4064 | N/A | null | 269 Indian School Rd | Jacksonville | FL | 32278 | GRP-3864·· | 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:43.605Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty