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-50961 | 2026-01-10T15:04:26Z | Christina | — | Bradley | 26-08-1958·· | N/A | — | — | — | 934 Apache Blvd | Plano | TX | N/A | - | NULL |
| TPA | TPA-56143 | 2026-01-26T13:44:40Z | Murray, Nancy | — | — | 09/03/1976 | ···· | — | — | null | 2773 MAPLE AVENUE | SCOTTSDALE | Arizona | 85243-6421 | GRP-1576 | OPTIONS-PPO |
| TPA | TPA-52181 | 2026-07-01T17:06:45Z | Maria·· | — | Vargas | 1996-10-16 | - | NULL | null | MARIA.VARGAS@PROTON.ME | 6130 Canyon Road | Orlando | FL | 32810 | N/A | N/A |
| TPA | TPA-52894 | 2026-04-17T02:00:26Z | Lawrence | — | McCoy | 13-02-1942 | — | N/A | — | null·· | 5429 Highland Ave | San Diego | CA | 92165 | GRP-2844 | OPTIONS-PPO |
| TPA | TPA-51352 | 2026-03-06T06:12:25Z | diana | F | rid | 20000201 | - | •••-••-5365 | — | diana.reid57@yahoo.com | 9358 Desert Sky Boulevard | ·Sacramento | ca | null | UNKNOWN | OPTIONS-PPO |
| TPA | TPA-63833 | 2026-04-23T21:44:28Z | Carolyn | — | Andrews | Nov 16, 1981 | — | •••-••-1636 | (799) 517-7710 | UNKNOWN | 5721 Ocean Avenue | Tucson | AZ | - | GRP-3668 | -·· |
| TPA | TPA-54937 | 2026-06-12T00:27:45Z | LAWRENCE | — | RAY | 09/17/85 | — | — | — | lawrence.ray97@yahoo.com | 8789 SUNSET BLVD | Miami | FL | 33159 | GRP-7242 | NULL |
| TPA | TPA-50691 | 2026-07-15T23:52:50Z | Vincent | M | Dixon·· | Dec 9, 1965 | UNKNOWN | UNKNOWN·· | (398) 793-5563 | vincent.dixon@yahoo.com | 2436 Maple Avenue | AUSTIN | TX | 78700 | — | — |
| TPA | TPA-51395 | 2026-03-18T18:23:31Z | Yuki | M. | Richardson | 1982-02-08 | — | •••-••-2936 | 6144330688 | - | 2434 Forest Ave | Eden Prairie | MN | ·55340 | UNKNOWN | - |
| TPA | TPA-51891 | 2026-10-08T01:52:51Z | Hanson, Raymond | H. | — | 1990-05-20 | UNKNOWN | •••-••-6383 | 714-391-1775 | raymond.hanson89@hotmail.com | 3321 Grand Ave | Atlanta·· | GA | 30388 | UNKNOWN | NULL |
| TPA | TPA-50208 | 2026-06-15T18:21:54Z | ·Lawrence | — | Sanchez | 08-11-1939 | UHC-61874-07 | ·· | ·+1 223 707 8293 | N/A | 6912 Baseline Road | Tucson | az | 85716 | N/A | null |
| TPA | TPA-60469 | 2026-04-25T14:16:25Z | DANIEL | — | OWENS | 09/12/1995 | UHC-62595-38 | •••-••-3105 | — | DANIEL.OWENS77@HOTMAIL.COM | 2304 CHURCH STREET | Minneapolis | MN | null | — | — |
| TPA | TPA-56892 | 2026-05-02T23:12:14Z | Sandoval, Richard | — | — | 1947-10-27 | N/A | — | 692.298.6423 | richard.sandoval@icloud.com | 7359 Harbor Blvd | SAN DIEGO | California | 92107 | — | N/A |
| TPA | TPA-55416 | 2026-08-16T03:33:11Z | Ross, Virginia | — | — | Jul 13, 1999 | UNKNOWN | •••-••-4263 | UNKNOWN | ·NULL | 6241 Main Street | Orlando | FL | 32827 | GRP-7113 | — |
| TPA | TPA-52431 | 2026-02-01T00:30:28Z | Dunn, Denise | — | — | 1945-05-11 | - | •••-••-4301 | +1 379 719 7048 | - | 5263 Sunset Blvd | Tempe | AZ | 85239 | — | NULL |
| TPA | TPA-57043 | 2026-08-13T04:45:37Z | Walsh, Sean | — | — | 1940-11-14 | UHC-07850-72·· | •••-••-8260 | N/A | NULL | ·1571 Union Street | Glendale | AZ | 85347 | N/A | CHOICE-PLUS-PPO·· |
| TPA | TPA-58191 | 2026-02-26T14:33:10Z | Lauren | — | ·Castillo | 01/17/50 | N/A | — | N/A | — | 8106 Willow Court Apt 25 | Tempe | AZ | 85266 | GRP-8344 | ···· |
| TPA | TPA-54120 | 2026-02-15T13:40:01Z | Nathan | — | Cunningham | 1938-05-08 | — | •••-••-1337 | (524) 225-1717 | NATHAN.CUNNINGHAM@ICLOUD.COM | ·8203 LAKE VIEW ROAD | Atlanta | GA | 30399 | GRP-2649 | null |
| TPA | TPA-51438 | 2026-06-25T21:57:15Z | Howell, Matthew | ·· | — | 06/12/1973 | UHC-16485-71 | NULL | UNKNOWN | — | 8776 MAPLE AVENUE | ·Chandler | AZ | 85278 | - | SELECT-EPO |
| TPA | TPA-56506 | 2026-03-15T20:10:35Z | KEVIN·· | — | WALLACE | 1981-03-11 | UHC-64153-44 | - | - | kevin.wallace54@outlook.com | 8690 Harbor Blvd | San Diego | CA | 92155 | — | OPTIONS-PPO |
| TPA | TPA-50192 | 2026-01-11T16:58:29Z | Cheryl | — | Fernandez | 05/13/64 | UHC-81604-35 | — | 966-747-7100 | — | 5415 Lake View Rd | San Diego | ·CA | UNKNOWN | GRP-2503 | MEDICARE-ADV-B |
| TPA | TPA-55839 | 2026-10-13T17:17:21Z | Julia | ·· | Patel | 13-04-1979 | - | NULL | - | — | 531 MOUNTAIN VIEW DR·· | Minneapolis | MN | 55408 | UNKNOWN | null |
| TPA | TPA-57936 | 2026-10-17T11:17:01Z | Jacqueline | — | Sanders | 1951-07-10 | — | UNKNOWN | 299-888-8429 | NULL | 737 GRAND AVE | GLENDALE | ·AZ | — | — | — |
| TPA | TPA-61481 | 2026-04-16T08:53:40Z | Salazar, Dorothy | — | — | ·1990-29-11 | ·UNKNOWN | NULL | — | N/A | ·N/A | NULL | — | - | GRP-5312 | — |
| TPA | TPA-53771 | 2026-04-05T17:30:09Z | VINCENT | — | ·PENA | 02/06/1945 | NULL | — | 3683430541 | — | 3385 HILLCREST ROAD | Minneapolis | MN | 55480 | GRP-5645 | MEDICARE-ADV-A |
| TPA | TPA-64134 | 2026-04-23T14:07:41Z | Richard | — | Mitchell | 2001-10-28 | - | ·null | - | richard.mitchell30@outlook.com | 3670 Main St | Tucson | AZ | 85769 | - | - |
| TPA | TPA-61398 | 2026-08-16T20:08:01Z | gary | N. | kelly | Dec 25, 1969·· | NULL | ···· | 9005910574 | — | 9565 Valley View Drive | SAN ANTONIO | TX | 78237 | NULL·· | — |
| TPA | TPA-57019 | 2026-07-30T20:23:49Z | Eugene | — | Hlal | 1955-04-03 | ···· | •••-••-1892 | - | ·null | 8430 Palm Dr | Orlando | FL | 32868 | ·N/A | NAVIGATE-HMO |
| TPA | TPA-57172 | 2026-09-21T21:27:13Z | Christine | — | Dominguez | 1966-02-20 | UNKNOWN | •••-••-7501 | (854) 435-5860 | — | 7719 MARKET STREET | Las Vegas | ·NV | 89140 | GRP-7550 | null |
| TPA | TPA-62684 | 2026-08-05T11:55:21Z | Lauren·· | — | Reid | 9168-05-07 | — | — | NULL | — | 4573 WILLOW COURT | Los Angeles | California | 90021 | GRP-8638 | — |
| TPA | TPA-60898 | 2026-04-02T17:22:31Z | Grace | — | Owens | 1972-01-25 | UNKNOWN | null | - | — | 685 APACHE BLVD #542 | Dallas | Texas | 75211-5020 | GRP-8496 | MEDICARE-ADV-B |
| TPA | TPA-53495 | 2026-01-12T06:51:06Z | ANA | — | ROGERS | 19731120 | null | null | 13283998407 | N/A | 2242 Pine Dr | Mesa | AZ·· | 85231 | - | CHOICE-PLUS-PPO |
| TPA | TPA-55351 | 2026-04-15T13:47:40Z | Joshua | — | Jensen | 2002-08-16 | — | — | 8132217562 | — | 5857 CEDAR LANE | ·Dallas | TX | 75252 | GRP-6823·· | — |
| TPA | TPA-56731 | 2026-08-19T21:27:15Z | BRADLEY | — | LOPEZ | 2/24/2005 | — | N/A | - | NULL | ·5000 Central Avenue | DENVER | CO | 80235 | - | OPTIONS-PPO |
| TPA | TPA-60481 | 2026-09-15T07:54:24Z | Christine | — | Powell | 1984-11-14 | null | — | ·9619844221 | null·· | 1042 Maple Avenue Apt 16 | Houston | TX | 77000 | - | N/A |
| TPA | TPA-53742 | 2026-07-07T15:54:57Z | VINCENT | — | STEVENS | 1975-10-05 | — | ·· | +1 472 395 2432 | UNKNOWN | 1528 BASELINE RD | Sacramento | CA | — | null | UNKNOWN |
| TPA | TPA-52764 | 2026-05-25T08:45:40Z | Ryan, Elijah | — | — | 1991-11-22 | UHC-60945-02 | •••-••-7395 | null | — | 1873 Meadow Lane | Austin | TX | 78791 | - | null |
| TPA | TPA-54846 | 2026-08-18T06:36:14Z | JEFFREY | — | GREEN·· | 1976-05-21 | UNKNOWN | UNKNOWN | NULL | — | 1429 Spring Street | Denver | CO | 80299 | null | — |
| TPA | TPA-55338 | 2026-06-14T10:10:47Z | Shaw, Benjamin | — | — | 1993-05-24 | UNKNOWN | ···· | (635) 919-4924 | — | 4124 Bayshore Dr | San Antonio | TX·· | 78298 | ·GRP-8083 | UNKNOWN |
| TPA | TPA-58129 | 2026-05-07T07:56:02Z | maria | F | castillo | 1955-10-06 | UNKNOWN | •••-••-5931 | null | UNKNOWN | 3511 Ocean Avenue | Seattle | WA | ·98161 | GRP-5920 | — |
| TPA | TPA-61499 | 2026-06-24T10:18:04Z | ·CHERYL | — | REED | 1984-06-12 | — | null | +1 615 369 3348 | CHERYL.REED@PROTON.ME | null | — | — | N/A | — | NAVIGATE-HMO |
| TPA | TPA-57335 | 2026-06-27T07:11:42Z | Benjamin | Y | Yang | 10/04/44 | UHC-43975-07·· | — | null | UNKNOWN | 5389 Desert Sky Blvd | Mesa | AZ | ·85265 | GRP-7756 | ···· |
| TPA | TPA-53821 | 2026-01-25T01:56:51Z | Diane | — | Hernandez | 1958-05-05 | - | ·· | 9364793791 | — | 3542 Ridge Rd | Orlando | FL | 32821 | N/A | ·NAVIGATE-HMO |
| TPA | TPA-52067 | 2026-10-01T15:57:45Z | Madison | — | Freeman | 1960-11-28 | UHC-37196-07 | — | 5449331530 | - | 9182 Willow Court | Seattle | WA | ·98191 | GRP-3228 | — |
| TPA | TPA-56499 | 2026-02-27T23:39:27Z | shirley | — | ·lopez | 06/04/1991 | N/A | N/A | 313-627-2862 | ·· | N/A | NULL | — | N/A·· | - | ···· |
| TPA | TPA-64004 | 2026-07-26T06:50:36Z | Raymond | N. | Patterson | ·1995-03-19 | — | •••-••-3242 | 366-705-9695 | raymond.patterson@gmail.com | ·· | NULL | N/A | N/A | GRP-7497 | MEDICARE-ADV-B |
| TPA | TPA-55991 | 2026-05-18T19:20:45Z | Margaret | ·· | Taylor | 2005-06-28 | - | N/A | (390) 394-5614 | — | 7621 Ridge Road | ·Austin | TX | 78761 | GRP-4850 | CORE-HMO |
| TPA | TPA-54812 | 2026-01-09T19:47:08Z | jim | — | watkins | 1957-08-25 | UHC-77031-08 | ·NULL | — | null | 3160 Union St | Austin | Texas | 78716 | ·NULL | — |
| TPA | TPA-63951 | 2026-03-08T18:48:16Z | Cook, Saarh | — | — | 2000-11-01 | — | — | N/A | — | 103 GRAND AVE | DALLAS | Texas | 75219-5952 | null | N/A |
| TPA | TPA-58090 | 2026-01-11T17:18:11Z | Laura | — | Graham | 1959-12-13 | — | ·· | 786-685-1262 | laura.graham@gmail.com | 8342 Apache Blvd | SAN DIEGO | CA·· | 92113 | GRP-8423 | UNKNOWN |
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:43:00.238Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty