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-52698 | 2026-03-11T05:17:08Z | mraiana | — | peters | 7/2/1948 | N/A | •••-••-7429 | 389-237-9222 | — | 8657 Meadow Lane | Houston | TX | 77000 | GRP-0839 | null |
| TPA | TPA-56610 | 2026-08-16T23:03:59Z | Arthur | — | Harvey | 1977-03-14 | — | •••-••-5550 | N/A | null | 5334 Elm St | Seattle | WA | 98104 | GRP-1623 | — |
| TPA | TPA-60108 | 2026-06-20T18:28:56Z | ASHLEY | — | CASTRO | 1952-07-15 | UHC-81991-63 | — | 520-678-8936·· | ashley.castro@aol.com | 2511 Camelback Rd | Denver | ·CO | 80265-5112 | — | NULL |
| TPA | TPA-56507 | 2026-07-15T12:55:41Z | Carlos | — | Ramos | 09-06-1967 | — | UNKNOWN | NULL·· | -·· | 2238 INDIAN SCHOOL ROAD | Tempe | AZ | 85255 | ·NULL | ·· |
| TPA | TPA-56454 | 2026-01-25T19:25:21Z | Aisha | — | Peters | 2008-11-28 | N/A | - | 2159173632 | UNKNOWN | N/A | UNKNOWN·· | UNKNOWN | — | NULL | OPTIONS-PPO |
| TPA | TPA-53313 | 2026-02-21T07:34:14Z | GREGORY | Y. | FRANKLIN | 2004-11-05 | null | •••-••-0850 | 937-922-9801 | — | 4284 Bayshore Dr | FRESNO | CA | 93761 | — | - |
| TPA | TPA-51449 | 2026-04-12T08:49:20Z | ANN | — | DOMINGUEZ | 12/03/59·· | — | — | (551) 205-4811 | ann.dominguez@hotmail.com | 2671 Grand Ave | Los Angeles·· | CA | 90042 | N/A | NULL |
| TPA | TPA-55668 | 2026-10-04T13:23:40Z | Mitkhell, Kimberly | — | ···· | 5/18/1945 | — | •••-••-7637 | ·+1 546 942 0396 | kimberly.mitchell@yahoo.com | 3292 Indian School Road | Minneapolis | MN | 55412·· | N/A | null |
| TPA | TPA-59326 | 2026-04-27T20:33:42Z | Kathleen | — | Santiago | 1943-10-11 | NULL | - | 502-755-5551 | NULL | 3108 APACHE BOULEVARD | Las Vegas | NV | NULL | GRP-9707 | — |
| TPA | TPA-54935 | 2026-09-29T02:10:50Z | JOYCE | ·Q | SPENCER | 1948-01-17 | — | •••-••-1126 | (971) 238-0933 | joyce.spencer47@gmail.com | 5919 Broadway | Sacramento | CA | 95800 | null | OPTIONS-PPO |
| TPA | TPA-56290 | 2026-08-17T20:19:31Z | Romero, Brittany | — | — | 07/06/1960·· | NULL | UNKNOWN | 300-364-2246 | ·BRITTANY.ROMERO55@YAHOO.COM | 1712 RIDGE RD Apt 28 | Dallas | tx | 75267 | — | MEDICARE-ADV-A·· |
| TPA | TPA-59064 | 2026-01-15T03:51:50Z | — | ·J | — | 1984-10-05 | N/A | UNKNOWN | NULL | — | 9633 Pine Dr | ·Los Angeles | CA | 90083·· | — | — |
| TPA | TPA-51680 | 2026-07-30T23:42:18Z | bobby | X. | moreno | 02/07/69 | - | N/A | (676) 493-3408 | - | -·· | UNKNOWN | null | null | UNKNOWN | NULL |
| TPA | TPA-62316 | 2026-06-27T20:37:05Z | STEVEN | — | GUERRERO | 1959-03-02 | — | -·· | ·UNKNOWN | N/A | 3024 HILLCREST ROAD | Orlando | FL | 32897 | UNKNOWN | null |
| TPA | TPA-61425 | 2026-04-21T07:00:22Z | Scott | ·· | Ducan | 06-06-1970 | UHC-34340-60 | NULL | NULL | — | 71 BAYSHORE DRIVE | Los Angeles | CA | 90071 | GRP-0102 | N/A |
| TPA | TPA-57534 | 2026-03-03T13:23:05Z | jonathan | — | ·gonzales | 2008-06-21 | UHC-10277-83 | — | null | UNKNOWN | 9832 Meadow Ln | Tempe | ·AZ | 85285 | N/A | — |
| TPA | TPA-61365 | 2026-01-20T07:00:23Z | Brian | — | Davis | 19660720 | N/A | — | - | NULL | 6652 Park Place | Jacksonville | fl·· | 32214 | — | - |
| TPA | TPA-53915 | 2026-07-06T17:10:17Z | Michael | M. | Patel | 12/08/1960 | — | — | - | N/A | 4190 FOREST AVENUE | Tempe | AZ | ·85260 | - | MEDICARE-ADV-B |
| TPA | TPA-50911 | 2026-03-08T10:45:23Z | DENNIS | W. | WILLIAMS | ·Mar 15, 1980 | — | null | - | UNKNOWN | 6382 SAGE CT·· | Gilbert | az | 85204 | - | SELECT-EPO |
| TPA | TPA-62384 | 2026-01-11T18:08:14Z | Benjamin | — | Simmons | 1971-06-14 | ·UHC-86087-23 | — | - | null | 8450 CAMELBACK RD | Gilbert | AZ | 85224 | ···· | NULL |
| TPA | TPA-60007 | 2026-01-07T16:57:53Z | Santiago | — | Carolyn | - | - | •••-••-3718 | ·13335090715 | — | 3514 Indian School Road | Atlanta·· | GA | 30355 | GRP-7520 | — |
| TPA | TPA-57068 | 2026-10-11T12:18:31Z | Michelle | — | Taylor | 2003-11-02 | NULL | null | NULL | N/A | ·9367 Park Pl | Tucson | AZ | 85790 | — | MEDICARE-ADV-A |
| TPA | TPA-51047 | 2026-08-12T20:32:36Z | PHILIP | — | MARSHALL | 28-03-1939 | null | •••-••-2863 | UNKNOWN | ·· | 7863 Washington St | Phoenix | AZ | 85083 | GRP-2440 | NULL |
| TPA | TPA-52399 | 2026-07-11T06:31:03Z | KEIH | — | SANCHEZ | 1959-08-17 | null | — | 16013369400 | UNKNOWN | ·4800 Ocean Ave | HOUSTON | TX | 77077 | N/A | - |
| TPA | TPA-62530 | 2026-02-16T03:14:17Z | Stephen | — | Collins | 1943-03-19 | — | UNKNOWN | null | ·NULL | 3224 Mountain View Dr | Sacramento | CA | NULL | — | NAVIGATE-HMO |
| TPA | TPA-58376 | 2026-08-10T00:10:51Z | Daniel | — | ·Grant | Jan 14, 1940 | - | — | - | NULL | 3420 OCEAN AVE | PHOENIX | AZ | 85077 | UNKNOWN | CHOICE-PLUS-PPO |
| TPA | TPA-62450 | 2026-06-12T17:42:05Z | Sofia | L | OBrien | 1990-10-08 | N/A | — | — | N/A | 8272 Hillcrest Rd | Austin | TX | 78706 | — | MEDICARE-ADV-B |
| TPA | TPA-62504 | 2026-08-30T03:16:08Z | Matthew | — | Nguyen | 1999-02-14 | NULL | ·N/A | — | MATTHEW.NGUYEN27@GMAIL.COM | ·9648 JEFFERSON AVE | Columbus | OH | 43280 | GRP-1504 | MEDICARE-ADV-A |
| TPA | TPA-63632 | 2026-08-18T11:07:16Z | bbby | ···· | wright | 9/21/1947 | UHC-08635-99 | •••-••-1517 | UNKNOWN·· | N/A | 5786 LAKE VIEW RD | Scottsdale | az | 85263 | GRP-2467 | N/A |
| TPA | TPA-63361 | 2026-06-24T03:42:39Z | JACOB | — | DOMINGUEZ | 8/7/1995 | - | •••-••-5198 | (351) 456-9918 | UNKNOWN | 3852 Elm St | Chandler | AZ | 85215 | NULL·· | SELECT-EPO |
| TPA | TPA-51020 | 2026-06-27T06:08:38Z | Patrick | — | Carter | 1986-11-22 | ·UNKNOWN | UNKNOWN | - | — | 9383 Washington Street | ·San Diego | CA | 92101-5936 | — | N/A |
| TPA | TPA-52373 | 2026-04-09T14:01:56Z | Jerry | — | Franklin | 1963-04-23 | NULL | — | ·397-533-9901 | jerry.franklin94@outlook.com | 2202 APACHE BLVD | Houston | TX | 77032 | ·GRP-5248 | — |
| TPA | TPA-53085 | 2026-01-20T11:24:10Z | Heathher | — | Wagner | 19911214 | — | •••-••-5313 | 4473470816 | heather.wagner68@yahoo.com | ·4720 Canyon Road | Miami | FL | 33174 | GRP-9903 | — |
| TPA | TPA-61914 | 2026-04-07T01:23:05Z | GARY | — | RIOS·· | 10-02-1985 | UNKNOWN | UNKNOWN | N/A | — | 8407 MARKET ST | TUCSON | AZ | ·85738 | - | N/A |
| TPA | TPA-50121 | 2026-07-28T12:34:28Z | Lauren | ···· | Castro | Jan 22, 1964 | — | •••-••-9734 | ·(667) 505-5998 | LAUREN.CASTRO92@OUTLOOK.COM | 2191 Pine Dr | Sacramento | CA | 95812 | GRP-7073 | MEDICARE-ADV-A |
| TPA | TPA-59034 | 2026-01-26T16:54:17Z | dorothy | ·· | fowler | 1990-02-06 | — | N/A | — | ···· | 2653 LINCOLN WAY | Phoenix | AZ | 85079 | — | - |
| TPA | TPA-53538 | 2026-05-13T22:54:31Z | Carlos | — | Stone | Jan 1, 1982 | UHC-21036-35 | - | NULL | ·· | 3927 Lincoln Way | Atlanta | Georgia | 30345 | ·- | — |
| TPA | TPA-56092 | 2026-08-22T21:46:39Z | ·SOPHIA | — | COLE | 1987-02-06 | UHC-35994-13 | NULL | - | SOPHIA.COLE55@ICLOUD.COM | 2155 SPRING STREET | Atlanta | GA | 30354 | N/A | - |
| TPA | TPA-62101 | 2026-10-10T18:43:20Z | Ruiz, Justin | — | — | ·1980-04-22 | N/A | — | (286) 717-1441 | — | 6445 Jefferson Avenue | Austin | TX | 78715 | GRP-5991 | CORE-HMO |
| TPA | TPA-56481 | 2026-06-07T06:56:20Z | CYNTHIA | — | KING | 1956-04-22 | N/A | •••-••-7347 | — | cynthia.king31@yahoo.com | 1443 VALLEY VIEW DR | CHARLOTTE | NC | 28213 | GRP-1240 | — |
| TPA | TPA-51154 | 2026-04-15T03:21:27Z | Noah | — | Lawrence | 1965-07-20 | — | •••-••-7673 | 289-561-3596 | UNKNOWN | — | — | null | — | GRP-8456 | - |
| TPA | TPA-59124 | 2026-04-09T22:33:01Z | Joe | — | Carlson | Feb 8, 1974 | — | — | 17359461783 | NULL | 8045 Willow Ct | Tampa | FL·· | 33695-0071 | GRP-4185 | — |
| TPA | TPA-53896 | 2026-06-05T17:26:30Z | Kathryn | ·S. | Bailey | 1952-03-04 | UNKNOWN | — | — | null | 4062 BASELINE ROAD·· | Tampa | FL | NULL | ·GRP-1663 | — |
| TPA | TPA-57059 | 2026-02-20T18:58:32Z | camila | — | walsh | 1960-01-13·· | UNKNOWN | •••-••-4489 | N/A | camila.walsh60@proton.me | 2775 HARBOR BOULEVARD | TEMPE | AZ | 85215 | UNKNOWN·· | CHOICE-PLUS-PPO |
| TPA | TPA-61299 | 2026-03-26T10:23:25Z | Peter | G. | Fox | 02/11/00 | UHC-43855-32 | UNKNOWN | 3789476021 | — | 5462 FOREST AVE | Houston | Texas | 77083 | N/A | NULL |
| TPA | TPA-52096 | 2026-06-10T09:24:17Z | Perry, Alice | G | — | 1943-04-24 | uhc-53984-35 | •••-••-8976 | (209) 671-4901 | N/A | 9138 Harbor Boulevard | Denver | CO | 80219 | GRP-5494 | — |
| TPA | TPA-54781 | 2026-06-16T04:57:56Z | JORDAN | — | BURKE | 12/25/1989 | — | UNKNOWN·· | null | UNKNOWN | 6875 Meadow Lane | Miami | FL | 33177 | NULL·· | N/A |
| TPA | TPA-55707 | 2026-06-04T15:03:41Z | gregory | — | schultz | 1969-02-25 | UHC-14832-94 | UNKNOWN | - | NULL·· | 5342 LINCOLN WAY | Las Vegas | NV | 89194 | GRP-5139·· | - |
| TPA | TPA-53621 | 2026-06-04T07:28:54Z | KAYLA | — | CHEN | 1/25/1967 | — | null·· | (237) 835-1439·· | ···· | 8289 Main St·· | Nashville | TN | 37244 | NULL·· | N/A |
| TPA | TPA-54576 | 2026-09-25T20:50:22Z | GREGORY | — | ELLIS | 1983-09-22 | NULL | — | — | — | 6057 Union Street | Charlotte | NC | 28224 | 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:42:53.717Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty