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-60626 | 2026-01-20T18:02:30Z | JUAN·· | X | WEST | 20061222 | — | N/A | null | null | 8647 Highland Avenue·· | ·Mesa | AZ | 85254 | null | — |
| TPA | TPA-56671 | 2026-01-25T16:59:46Z | Cynthia | — | Bailey | Feb 16, 1957 | null | — | (559) 535-0256 | cynthia.bailey39@aol.com | 9112 Market Street | Gilbert | AZ | 85247-7241 | GRP-1899 | — |
| TPA | TPA-63743 | 2026-02-23T21:24:22Z | Alexis | — | Murray | 1990-12-15 | ·N/A | — | ···· | alexis.murray49@proton.me | 5747 CAMELBACK ROAD | San Diego | CA | NULL | NULL | NULL |
| TPA | TPA-56365 | 2026-09-21T15:33:02Z | Roger | — | Graham | 21-04-1985 | N/A | — | - | ·- | 8975 SAGE CT #390 | Phoenix | AZ | ·85046 | — | — |
| TPA | TPA-59070 | 2026-05-20T04:00:41Z | Russell | — | Hart | 1977-05-15 | ·N/A | null | NULL | N/A | null | — | - | UNKNOWN | GRP-4281 | NULL |
| TPA | TPA-53730 | 2026-03-18T17:45:29Z | MEI·· | — | JACKSON | 05/19/02 | NULL | UNKNOWN | NULL·· | NULL | 3669 Market Street | Mesa | AZ | 85225 | GRP-4512 | — |
| TPA | TPA-58613 | 2026-03-21T15:49:07Z | Kayla | S | Vasquez | Dec 4, 1949 | UHC-56091-77 | UNKNOWN | - | — | 9411 Elm St | Jacksonville | FL | 32264 | — | MEDICARE-ADV-B |
| TPA | TPA-58522 | 2026-01-16T12:58:34Z | Austin | — | Cunningham | 2001-52-11 | — | NULL | - | — | — | UNKNOWN | null | NULL | — | — |
| TPA | TPA-62414 | 2026-09-06T03:03:58Z | Deborah | — | Fox | 19820604 | — | •••-••-4983 | N/A | N/A | 3808 Highland Ave Apt 36 | Houston | TX | 77059 | - | MEDICARE-ADV-A |
| TPA | TPA-61038 | 2026-05-24T16:04:28Z | ashley | — | moore | 4/16/1966 | UNKNOWN | — | — | - | 5502 River Rd | Nashville | TN | 37268 | — | — |
| TPA | TPA-61707 | 2026-04-08T16:29:41Z | Thomas | — | Sims | 1971-03-19·· | — | N/A | (981) 713-1418 | UNKNOWN | 4750 Grand Avenue | Orlando | FL | 32898-6890 | UNKNOWN | — |
| TPA | TPA-53095 | 2026-07-24T20:38:14Z | Benjamin | — | Yang | 1931-90-25 | — | •••-••-1679 | UNKNOWN | null | — | N/A | N/A | — | UNKNOWN | SELECT-EPO |
| TPA | TPA-63558 | 2026-10-09T23:29:01Z | Katherine | — | Black | ·7/25/1997 | UNKNOWN | ·null | — | — | 45 Palm Drive | Tucson | AZ | 85765 | GRP-3883 | — |
| TPA | TPA-56692 | 2026-02-14T09:23:56Z | Mrris, Brittany | ···· | — | 2001-01-10·· | — | — | 4673404072 | — | null | -·· | UNKNOWN | — | - | NAVIGATE-HMO |
| TPA | TPA-57279 | 2026-04-03T16:43:39Z | Fiher, Ahmed | P | — | 1986-05-01 | - | UNKNOWN | (505) 305-6699 | — | 44 Elm Street | SEATTLE | WA | 98149 | - | CORE-HMO |
| TPA | TPA-56259 | 2026-03-25T05:48:57Z | ·Saarh | Q. | Bennett | 11/9/1976 | - | NULL | (973) 566-3116 | NULL | UNKNOWN | NULL | — | UNKNOWN | GRP-4250 | ·null |
| TPA | TPA-50154 | 2026-09-08T14:56:44Z | Grace | — | Burton | 19810126 | UNKNOWN | UNKNOWN | NULL | - | 8064 Maple Ave | Columbus | OH | 43279 | - | N/A |
| TPA | TPA-57779 | 2026-07-03T04:57:30Z | Lauren | — | Stevens | 19630902 | - | •••-••-4340 | — | null | UNKNOWN | — | — | UNKNOWN | GRP-9325 | - |
| TPA | TPA-59045 | 2026-04-20T13:06:52Z | ·WEI | ·· | STEPHENS | Jul 7, 1953 | - | •••-••-8038 | (444) 244-2440 | — | NULL | — | — | — | GRP-9712 | — |
| TPA | TPA-59321 | 2026-03-31T01:13:58Z | SOFIA | — | THOMPSON | 1987-07-21 | UNKNOWN | - | ·- | sofia.thompson@yahoo.com | NULL | N/A | UNKNOWN | NULL | GRP-4748 | MEDICARE-ADV-A |
| TPA | TPA-51667 | 2026-10-08T19:16:32Z | Ftima | ···· | Green | Jan 19, 1971 | UNKNOWN | — | (897) 585-5235 | NULL | 764 River Road·· | Minneapolis | MN | 55442 | - | ·medicare-adv-b |
| TPA | TPA-50559 | 2026-02-06T19:29:01Z | Andrea | J. | Lane | 08/25/1962 | — | •••-••-2612 | UNKNOWN | andrea.lane@aol.com | — | — | null·· | NULL | GRP-3558 | MEDICARE-ADV-A |
| TPA | TPA-63032 | 2026-04-29T21:42:47Z | NOAH | — | KIM | Apr 28, 1957 | N/A | UNKNOWN | NULL | — | 4631 RIVER ROAD | CHARLOTTE | NC | 28258 | null | -·· |
| TPA | TPA-62873 | 2026-09-20T13:09:04Z | Juan | — | Murray | 12/26/1960 | UHC-76789-10 | N/A | 392-267-9400 | — | 9062 Park Place | ·Gilbert | AZ | 85263 | UNKNOWN | — |
| TPA | TPA-58931 | 2026-04-11T14:00:55Z | CHRISTOPHER | — | ORTEGA | 20060619 | UHC-06039-73 | - | 6253350169 | NULL | 9815 Bayshore Dr | Charlotte | North Carolina | 28268 | N/A·· | — |
| TPA | TPA-51330 | 2026-04-17T18:27:11Z | Ryan | ·· | Marquez | 19670507 | UHC-70690-14 | null | UNKNOWN | RYAN.MARQUEZ41@HOTMAIL.COM·· | 121 Mountain View Drive | Sacramento | ca | 95861·· | N/A | SELECT-EPO |
| TPA | TPA-50359 | 2026-02-22T03:12:25Z | Billy | — | Thomas | 1961-12-16 | — | — | N/A | - | null | NULL | — | - | null | CHOICE-PLUS-PPO |
| TPA | TPA-57547 | 2026-05-29T20:30:49Z | TERRY | — | SNYDER | 2007-04-01 | — | •••-••-0343 | 784-943-6459 | null | 5679 Park Pl | Denver | CO | 80201 | GRP-9363 | MEDICARE-ADV-B |
| TPA | TPA-51995 | 2026-01-03T20:56:09Z | MIKE | — | HENRY | 1990-05-07 | N/A | — | - | michael.henry20@gmail.com | 6130 Mountain View Drive | Tempe·· | AZ | 85297 | - | N/A |
| TPA | TPA-51825 | 2026-09-10T09:12:04Z | Matt | — | Day | ·1949-03-08 | UNKNOWN | N/A | — | MATTHEW.DAY@PROTON.ME | NULL | — | — | UNKNOWN | - | UNKNOWN |
| TPA | TPA-57847 | 2026-02-20T00:13:18Z | ALBEERT | — | HUNT | Aug 1, 2002 | N/A | N/A | N/A | - | 5402 PARK PL | Eden Prairie | MN | 55324 | - | UNKNOWN |
| TPA | TPA-52126 | 2026-09-18T17:36:54Z | Michael | — | Chappman | 1938-11-13 | — | UNKNOWN | null | NULL | ·5220 Church St | Atlanta | GA | 30325 | — | null |
| TPA | TPA-62669 | 2026-01-08T13:02:14Z | Jacqueline | — | Reid | 2004-11-04 | UHC-57895-23 | UNKNOWN | +1 771 934 3517 | ·· | 8207 Cedar Lane | Sacramento | CA | 95880 | - | UNKNOWN |
| TPA | TPA-55231 | 2026-04-19T16:14:57Z | AMANDA | — | RICHARDS | 1978-03-09 | N/A | — | — | — | NULL | — | null | — | GRP-2551 | MEDICARE-ADV-B |
| TPA | TPA-55674 | 2026-07-16T14:45:17Z | Reyes, Amber | E. | ···· | 1997-03-24 | N/A | NULL·· | null | amber.reyes27@outlook.com | 6206 Ridge Road | Minneapolis | MN·· | 55411 | GRP-4380 | CHOICE-PLUS-PPO·· |
| TPA | TPA-51497 | 2026-10-09T19:53:07Z | Roy | — | Baker | 7/17/1990 | UHC-57070-14 | NULL | — | UNKNOWN | 3701 Washington Street | TAMPA | FL | 33607 | N/A | NULL |
| TPA | TPA-60142 | 2026-06-28T10:16:49Z | STEVE | — | MALDONADO·· | ·1985-04-19 | N/A | NULL | — | — | 1352 Desert Sky Boulevard | Minneapolis | MN | - | N/A | UNKNOWN |
| TPA | TPA-57098 | 2026-07-31T14:34:41Z | JEREMY | Z. | WILLIAMSON | 20010509 | — | — | — | ·null | N/A | NULL | N/A | -·· | GRP-6662 | NAVIGATE-HMO |
| TPA | TPA-50137 | 2026-06-15T10:49:31Z | Le, Philip | N. | — | 2/5/1980 | null | - | (401) 623-8117 | — | 6056 Union Street | San Diego | CA | 92112 | UNKNOWN | OPTIONS-PPO |
| TPA | TPA-61749 | 2026-03-12T04:03:27Z | theresa | Y·· | rios | 2007-07-20 | — | null | (709) 941-2606 | theresa.rios40@yahoo.com | 3083 Sage Court | Houston | TX | 77063 | NULL | — |
| TPA | TPA-54214 | 2026-07-05T09:35:59Z | DONNA | — | COLEMAN | 1924-10-15 | NULL | NULL | (624) 506-5244 | UNKNOWN | 7430 Palm Drive | Sacramento | CA | 95848 | GRP-3827 | null |
| TPA | TPA-63737 | 2026-03-31T14:40:20Z | Elijah | — | Owens | 1953-05-21 | NULL | null | — | ···· | 8030 Cedar Lane | Mesa | AZ | 85278 | NULL | — |
| TPA | TPA-56599 | 2026-01-29T05:06:52Z | AMBER | — | BERRY | 11-05-1995 | — | — | 229-412-3039 | ·· | 5315 Palm Drive | ATLANTA | GA | 30369 | — | NULL |
| TPA | TPA-52336 | 2026-02-13T07:33:39Z | george | ···· | sims | 1997-01-02 | — | UNKNOWN | 9832619092 | - | 461 Jefferson Ave | PLANO | Texas | 75094-4932 | — | -·· |
| TPA | TPA-52021 | 2026-04-20T12:56:24Z | Linda | ···· | Gomez | Apr 14, 1994 | UHC4820983 | N/A | — | — | 8638 River Rd | JACKSONVILLE | FL | 32251 | NULL | NULL |
| TPA | TPA-63800 | 2026-06-13T09:08:32Z | Steven | — | Jones | 1946-11-19 | UHC-22977-86 | N/A | ·· | UNKNOWN·· | 6102 Jefferson Avenue | ·CHANDLER | AZ | 85283 | UNKNOWN | CORE-HMO |
| TPA | TPA-51997 | 2026-07-14T07:12:15Z | Sofia | ·· | Luna | 1995-01-17 | — | null | — | — | 5518 Spring St | Charlotte | NC | 28295 | UNKNOWN | NULL |
| TPA | TPA-61762 | 2026-05-10T22:40:16Z | Davis, Sofiia | — | — | 1971-05-14 | UNKNOWN | UNKNOWN | UNKNOWN | - | 1258 WILLOW COURT | Eden Prairie | MN | 55389 | ·GRP-5602 | null |
| TPA | TPA-51913 | 2026-07-15T11:53:49Z | Alexis | — | Edawrds | 1976-03-25·· | — | •••-••-9480 | 3973708 | — | ·561 Indian School Road | ·San Antonio | TX | 78201 | -·· | — |
| TPA | TPA-58017 | 2026-08-25T12:58:15Z | Nancy | — | Larson | 02/14/1977 | NULL | — | null | — | 4282 Park Place | Nashville | TN | 37292 | — | 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.481Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty