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-60711 | 2026-01-08T19:34:27Z | ALEXIS | — | CASTRO | 01/10/91 | ·· | - | - | — | 4926 UNION STREET | Glendale | AZ | 85328 | - | NULL |
| TPA | TPA-55650 | 2026-02-07T15:09:35Z | RYAN | — | GRANT | 27-09-1989·· | ·NULL | •••-••-4542 | — | NULL | 6174 Valley View Drive | Tucson | Arizona | null | GRP-4283 | CHOICE-PLUS-PPO |
| TPA | TPA-51826 | 2026-10-10T23:41:28Z | MATTHEW | — | DAY | 1949-03-08 | N/A | — | 3868458370 | — | 4162 CEDAR LN | Tempe | az·· | 85261-6869 | GRP-9752 | — |
| TPA | TPA-60419 | 2026-06-17T16:51:20Z | Carlos | — | Ortega | 1985-05-15 | UNKNOWN | UNKNOWN | 7852825408 | null | — | N/A | — | — | GRP-7313 | MEDICARE-ADV-A |
| TPA | TPA-61556 | 2026-06-12T11:25:51Z | JOE | ···· | MILLS | 1948-12-08 | ···· | •••-••-7739 | UNKNOWN | - | ·8341 Market St | SEATTLE | WA | 98142 | N/A | — |
| TPA | TPA-59726 | 2026-04-25T18:58:05Z | aisha | ·· | mejia | 1962-08-28 | — | — | ·N/A | -·· | 3732 HILLCREST RD | Jacksonville | FL | 32256 | GRP-3985 | — |
| TPA | TPA-55186 | 2026-05-21T07:33:47Z | Jessica | — | Valdez | 1954-05-06 | — | •••-••-2078 | 8464708695 | ·null | 4450 PARK PL·· | Mesa | AZ·· | 85297·· | GRP-2392 | CORE-HMO |
| TPA | TPA-58541 | 2026-02-07T10:42:28Z | Amy | — | Snyder | 12/03/84 | — | •••-••-4215 | ·(763) 982-8245 | UNKNOWN | 9570 Sunset Boulevard #484·· | Miami | FL | 33143 | — | CORE-HMO |
| TPA | TPA-53888 | 2026-06-21T14:53:27Z | Bruce | — | Perkins | 04/02/68 | — | NULL | 3819597953 | null | 7248 Grand Avenue | Jacksonville | fl | 32257 | UNKNOWN | medicare-adv-a |
| TPA | TPA-62765 | 2026-08-28T03:02:46Z | Jean | — | Johsnon | 1947-06-09 | — | - | 7638731 | — | 6754 CANYON RD·· | Nashville | ·TN | 37277-0391 | NULL | — |
| TPA | TPA-54286 | 2026-08-16T07:22:25Z | Joe | Q | Hernandez | 1984-04-12 | — | •••-••-2354 | +1 744 837 0918 | — | 795 MAPLE AVENUE | Tempe | AZ | ·· | — | MEDICARE-ADV-B |
| TPA | TPA-62626 | 2026-10-18T14:14:33Z | Johnston, Gerald | — | — | 19380521 | NULL | N/A | 3935165250 | N/A | — | UNKNOWN | — | N/A | - | OPTIONS-PPO |
| TPA | TPA-57005 | 2026-08-29T03:54:14Z | Alexander | — | Johnston | 2006-02-24 | - | — | N/A | ALEXANDER.JOHNSTON@AOL.COM | ·3793 Lake View Rd Apt 3 | Gilbert | AZ | 85247-0887 | GRP-4198 | MEDICARE-ADV-B |
| TPA | TPA-50339 | 2026-09-06T20:30:34Z | Margaret | — | Pena | 1985-10-06 | - | null | (935) 832-8314 | - | 978 Market Street | Eden Prairie | MN | 55319 | N/A | OPTIONS-PPO |
| TPA | TPA-59698 | 2026-09-19T18:15:32Z | Nancy | — | Ryan | 1989-03-05 | — | UNKNOWN | (599) 455-8400 | — | — | — | — | NULL | — | null |
| TPA | TPA-50132 | 2026-02-25T11:41:11Z | Cynthia·· | — | Hraris | 19790410 | UNKNOWN | UNKNOWN | — | — | — | - | null | - | - | — |
| TPA | TPA-55762 | 2026-04-25T19:09:50Z | ANTHONY | — | JOHNSTON | 1976-01-26 | UNKNOWN | null | N/A | NULL | 6353 Cedar Ln | Tampa | ·FL | 33619 | N/A | UNKNOWN |
| TPA | TPA-55661 | 2026-05-14T10:06:31Z | Robert | — | Hall | 22-03-1946·· | - | null | — | N/A | 1833 OAK STREET | Sacramento | CA | 95893 | — | NULL |
| TPA | TPA-55099 | 2026-06-29T22:11:23Z | Evelyn | — | Martinez | 1976-09-16 | NULL | N/A | +1 914 850 7710 | N/A | 1377 Mesa Drive | Tempe | AZ | ·85276 | GRP-0983·· | NULL |
| TPA | TPA-55126 | 2026-02-07T02:19:39Z | ANDREA | A. | ESPINOZA | 1995-10-20 | NULL | •••-••-8832 | — | null | 4990 CHURCH STREET | EDEN PRAIRIE | MN | 55312 | — | MEDICARE-ADV-B |
| TPA | TPA-52660 | 2026-04-18T03:50:06Z | Reynolds, Luis | — | — | 1946-04-03 | null | — | (405) 264-5021 | — | ·5142 Baseline Road | Tucson | AZ | 85705 | GRP-3820 | UNKNOWN |
| TPA | TPA-56957 | 2026-02-04T00:11:13Z | Simpson, Aaron | — | — | ·2005-05-22 | UNKNOWN | ·N/A | 6439817281 | — | 659 Washington Street | Miami·· | FL | 33175 | NULL | ·- |
| TPA | TPA-56073 | 2026-10-05T22:10:21Z | Pamla | — | Tucker | 1974-08-08 | NULL | null·· | N/A | - | 7360 JEFFERSON AVE | Atlanta | GA | 30385 | GRP-5961 | N/A |
| TPA | TPA-59650 | 2026-03-13T14:54:01Z | Donald | — | Griffin·· | 1954-05-14 | NULL | — | (337) 276-0907 | NULL·· | 3360 Mountain View Drive | Austin | TX | 78704 | — | - |
| TPA | TPA-60873 | 2026-09-20T15:48:21Z | Elijah·· | — | Webb | 1981-09-03 | null | •••-••-0444 | — | — | — | — | NULL | NULL | null | null |
| TPA | TPA-59483 | 2026-06-18T14:33:17Z | Tyler | — | Maldonado | 7/12/1948 | UNKNOWN | •••-••-2521 | 416-807-8675 | NULL | 7191 Mesa Dr | Minneapolis | MN | 55480 | - | CORE-HMO |
| TPA | TPA-57365 | 2026-03-18T06:55:01Z | Robert | — | Vargas | 1940-08-18 | — | — | NULL | UNKNOWN | NULL | NULL | — | - | N/A | SELECT-EPO |
| TPA | TPA-62322 | 2026-09-19T18:36:46Z | Mary | — | Herrear | Mar 20, 1973 | UHC-96852-32 | •••-••-6708 | NULL | N/A | 7943 Palm Dr | Houston | TX | ·77040 | GRP-9075 | OPTIONS-PPO |
| TPA | TPA-50179 | 2026-08-22T08:20:40Z | JEREMY | K | YOUNG | 5/20/2002·· | N/A | •••-••-7061 | ·· | - | 6020 JEFFERSON AVE #274 | Columbus | OH | 43287-1908 | — | MEDICARE-ADV-A |
| TPA | TPA-57677 | 2026-09-09T00:04:53Z | Elijah | — | Burke | 26-03-1994 | UHC-30110-62 | UNKNOWN | NULL | elijah.burke72@outlook.com | 6133 Washington St | GILBERT | AZ | null | GRP-6103 | SELECT-EPO |
| TPA | TPA-55724 | 2026-09-28T17:38:34Z | ROGER | ·· | HOLMES | 03-08-1978 | NULL | •••-••-7487 | NULL | N/A | 289 Grand Ave | Los Angeles | CA | 90087 | — | ···· |
| TPA | TPA-50123 | 2026-04-13T12:59:47Z | Jacob | — | Hamilton | 09/19/87 | - | ·· | 7252173776 | — | 9073 Grand Ave | Columbus | OH | 43214·· | GRP-9243 | MEDICARE-ADV-A·· |
| TPA | TPA-62699 | 2026-09-23T10:56:07Z | Ethan | S | Butler | 1957-01-03 | UHC-86946-59 | — | 2552516678 | — | 4299 FOREST AVE | Columbus | Ohio | 43284 | - | NAVIGATE-HMO |
| TPA | TPA-56666 | 2026-09-05T09:30:08Z | Jeremy | — | Long | 2005-07-23 | N/A | null | 756.785.0188 | — | 2147 Market St | Miami | FL | 33138 | null·· | — |
| TPA | TPA-63879 | 2026-01-06T13:35:45Z | Kathryn | — | Dominnguez | 1939-12-18 | N/A | - | - | null | 6195 Apache Boulevard | Sacramento | CA | 95854 | GRP-9268 | N/A |
| TPA | TPA-62223 | 2026-03-04T03:58:05Z | MARGARET | — | JENSEN | Dec 27, 1955 | UHC-87953-54 | — | ·739-302-5588 | - | 8046 Sunset Boulevard | Glendale | AZ | 85323 | — | MEDICARE-ADV-B |
| TPA | TPA-53389 | 2026-02-01T11:03:12Z | Natalie | — | Wallace | 1940-08-15 | UHC-21792-24 | — | UNKNOWN | -·· | 406 Church St | Sacramento | CA | 95856 | GRP-2074 | — |
| TPA | TPA-63068 | 2026-10-09T22:08:32Z | LUIS | — | NICHOLS | 1975-08-02 | NULL | N/A·· | — | NULL | 8547 Spring Street | Tucson·· | AZ | 85721 | GRP-1993 | CORE-HMO |
| TPA | TPA-50412 | 2026-07-26T12:04:45Z | Fatima | — | Kennedy | 5/7/1989 | - | — | — | - | 8239 Central Ave | SAN ANTONIO | TX | 78293 | null | — |
| TPA | TPA-61551 | 2026-04-06T08:43:42Z | Alice | F | Lopez | 09/15/92 | — | - | ·570-496-7224 | — | 7635 BASELINE ROAD | Tempe | AZ | 85235 | GRP-7396 | — |
| TPA | TPA-53992 | 2026-04-30T18:09:45Z | ·Nicole | — | Carter | Feb 6, 1978 | — | — | — | ·null | 5698 Grand Ave | HOUSTON | TX | 77048 | ·GRP-2105 | — |
| TPA | TPA-50067 | 2026-09-03T21:11:54Z | Singh, Evelyn | — | — | 1976-01-08 | N/A | null | — | UNKNOWN | 9466 Union Street | Minneapolis | MN | 55477 | GRP-6131 | UNKNOWN |
| TPA | TPA-59678 | 2026-09-28T00:36:47Z | RYAN | — | EDWARDS | 08-05-2000 | - | ·null | — | ·N/A | 638 Church Street #701 | Gilbert | AZ | 85260·· | null | — |
| TPA | TPA-51218 | 2026-07-07T11:53:28Z | SOPHIA | — | THOMPSON | 2005-07-09 | UHC-80003-55 | ·NULL | 461-518-6988 | — | — | - | ·null | null | UNKNOWN | — |
| TPA | TPA-60812 | 2026-09-13T02:34:37Z | ·Santiago | — | Silva·· | 12/21/55 | — | •••-••-1090 | — | — | 2852 Valley View Drive | Tampa | FL | 33615 | — | ·NULL |
| TPA | TPA-50759 | 2026-10-10T14:57:06Z | JOE | ···· | RIVERA | 1952-07-18 | UHC0584687 | — | — | null | NULL | N/A | null | N/A | ···· | N/A |
| TPA | TPA-62086 | 2026-10-11T21:31:36Z | Kimberly | — | Baker | ·1987-10-13 | UNKNOWN | •••-••-9804 | (482) 771-4425 | NULL | 6304 Camelback Rd | Seattle | WA | 98101 | - | null |
| TPA | TPA-56884 | 2026-05-17T15:07:19Z | Jose | — | Green | 1998-10-12 | - | •••-••-5002 | - | — | 6617 Ocean Avenue | Los Angeles·· | CA | 90002 | N/A | — |
| TPA | TPA-58705 | 2026-07-28T01:36:49Z | Donna | — | Wong | 1967-09-15 | UNKNOWN | •••-••-5419 | ·N/A | NULL | 7147 Mountain View Dr | Glendale | Arizona | 85396 | — | null |
| TPA | TPA-50636 | 2026-08-09T20:26:09Z | Keith | M. | Payne | 13-02-1997 | NULL | •••-••-4223 | (837) 468-7938 | — | 5572 Broadway | Phoenix | az | 85038 | GRP-9970 | — |
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:36.685Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty