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
Provider network only, ordered by line number
| Source | Record | Received | First | Middle | Last | DOB | Member ID | SSN | Phone | Address | City | State | ZIP | Group | Plan | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| PRV | PRV-28025 | 2026-02-01T01:30:12Z | Helen | — | Chen | 1941-09-22 | N/A | •••-••-9692 | 7802985905 | ·· | N/A | NULL | null | - | — | NULL·· |
| PRV | PRV-27444 | 2026-03-11T02:54:42Z | jonathan | — | dixon | 03/13/85 | UHC-49534-89 | •••-••-0848 | (726) 692-0868 | — | 6319 Ridge Road | Minneapolis | mn | 55411 | - | SELECT-EPO |
| PRV | PRV-23908 | 2026-07-13T02:34:08Z | Black, Alice | — | — | 1995-09-01 | — | UNKNOWN | 488-742-7255 | null | 8121 Ocean Avenue | Los Angeles | California | 90040 | UNKNOWN·· | — |
| PRV | PRV-28753 | 2026-04-09T08:18:00Z | barbara | C | ·carroll | 1966-01-23 | ···· | •••-••-9233 | 523-963-7570·· | barbara.carroll59@yahoo.com | N/A | — | UNKNOWN | — | — | — |
| PRV | PRV-23393 | 2026-08-26T05:00:29Z | CAL | C. | ·WATSON | 1947-06-09 | UHC-46114-22 | — | 6356141072 | — | 4297 Palm Drive | Miami | FL | 33100-9379 | N/A·· | ·N/A |
| PRV | PRV-21384 | 2026-08-10T10:13:21Z | Melissa | — | Larson | 1941-03-18 | UHC-49577-53 | UNKNOWN | (558) 524-5210 | — | 8354 Lake View Rd | San Diego | CA | 92139 | — | null |
| PRV | PRV-28376 | 2026-07-21T01:31:55Z | Virginia | — | Kim | 1945-08-11 | NULL | •••-••-7476 | 4591023 | virginia.kim@outlook.com | 4941 Mesa Dr | Las Vegas | NV | 89132 | - | - |
| PRV | PRV-26764 | 2026-03-05T17:32:38Z | CHARLOTTE·· | — | HANSON | 1963-05-10 | - | •••-••-5135 | +1 799 425 7241 | — | 2618 Ridge Road | Denver | CO | 80272-1016 | NULL | null |
| PRV | PRV-20188 | 2026-10-04T10:29:16Z | brian | — | cole | UNKNOWN | null | UNKNOWN | 824.714.8547·· | BRIAN.COLE73@ICLOUD.COM | 8635 Market St Apt 13 | Miami | FL | 33182 | — | ·· |
| PRV | PRV-20002 | 2026-03-04T10:19:46Z | laura·· | — | alvarado | 1939-03-06 | ·null | •••-••-3696 | 2082046344 | laura.alvarado30@gmail.com | 4347 Church Street | Plano | TX | 75086-0358 | UNKNOWN | NULL |
| PRV | PRV-28278 | 2026-03-05T17:14:06Z | Shirley | ···· | Media | 03/28/39 | UHC-90535-74 | UNKNOWN | (294) 698-5847·· | — | 902 Elm St Apt 24·· | GLENDALE | AZ | 85336 | UNKNOWN | null |
| PRV | PRV-22673 | 2026-08-25T14:18:55Z | Joan | W | Chavez | 2006-02-14 | UHC-73132-10 | null | (576) 969-5537 | NULL | 7276 Spring St Apt 35 | Eden Prairie | MN | 55340 | — | — |
| PRV | PRV-25073 | 2026-03-28T00:04:44Z | ·Wayne | — | Moorris | 6/7/1984 | uhc-85819-24 | — | +1 816 640 4542 | NULL | 3686 Main St | Charlotte | North Carolina | 28267 | null | — |
| PRV | PRV-27516 | 2026-09-18T20:42:32Z | Joseph | — | Bradley | 20051116 | ·· | UNKNOWN | +1 687 722 6409 | null | 7644 PARK PLACE Apt 15·· | Charlotte | ·NC | 28237 | null | NULL |
| PRV | PRV-20536 | 2026-03-31T14:51:56Z | Walter | — | Peters·· | 02/13/1966 | UHC-02548-52 | NULL | (611) 820-4274 | NULL | 5060 Highland Ave Apt 22 | Minneapolis | MN | 55434·· | - | medicare-adv-a |
| PRV | PRV-22182 | 2026-07-19T10:28:37Z | Bobby | B | Lee | 1939-06-16 | UNKNOWN | UNKNOWN | — | null | UNKNOWN | N/A | — | ···· | null | NAVIGATE-HMO |
| PRV | PRV-23944 | 2026-07-26T02:35:32Z | Justin | Y. | Gilbert | 10/17/79 | N/A | - | 478.320.3040 | — | 5876 INDIAN SCHOOL ROAD | Mesa | AZ | 85232 | N/A | — |
| PRV | PRV-26748 | 2026-07-18T06:44:18Z | TERRY | — | ·OLSON | 01/20/1945 | UHC-32163-31 | •••-••-3113 | 311-513-0681·· | null | 423 Elm Street | LOS ANGELES | CA | 90058 | null | NAVIGATE-HMO |
| PRV | PRV-21038 | 2026-05-11T03:40:22Z | Gardner, Dennis | — | — | 09/27/1975 | UHC-28962-20 | N/A | N/A | N/A | ·9046 Mountain View Drive | Austin | TX | 78744 | null | ·· |
| PRV | PRV-22856 | 2026-10-15T22:27:37Z | KIMBERLY | — | HERNANDEZ | 1979-10-17 | N/A | — | 7288066834 | ·kimberly.hernandez74@icloud.com | 1697 Desert Sky Blvd | Chandler | Arizona | 85254 | UNKNOWN | MEDICARE-ADV-A |
| PRV | PRV-27863 | 2026-04-22T14:01:56Z | Paul | — | Coleman | 1930-99-22 | UHC-62015-28 | NULL | (741) 814-6580 | — | 8638 MAIN STREET Apt 16 | Miami | FL | 33170·· | NULL | UNKNOWN |
| PRV | PRV-21392 | 2026-09-27T17:56:14Z | Shirley | — | Harris | 1973-06-03 | N/A | •••-••-8544 | (457) 422-6987 | shirley.harris@proton.me | 7248 Broadway | CHANDLER | Arizona | 85269 | - | - |
| PRV | PRV-26840 | 2026-04-07T18:58:39Z | Paul | T | Murphy | 1961-07-18 | null | UNKNOWN | 762-760-1954 | N/A | 4643 Main St | Tucson | Arizona | 85747 | NULL | - |
| PRV | PRV-20029 | 2026-05-07T23:41:01Z | NANCY | B | MORRISON | 19720515 | N/A | null·· | 598-516-4419 | ·UNKNOWN | 9818 Camelback Rd | HOUSTON | TX | 77089·· | — | UNKNOWN |
| PRV | PRV-29339 | 2026-03-19T15:53:08Z | ASHLEY | — | VARGAS | 09/03/58 | null | UNKNOWN | 680.503.2837 | ashley.vargas43@outlook.com | ·9179 Cedar Ln Apt 13 | Chandler | AZ | 85219-3210 | UNKNOWN | N/A |
| PRV | PRV-23454 | 2026-10-05T21:08:17Z | SOPHIA | ·O. | DIXON | 1938-03-10 | UHC-10387-52 | — | 15022621731 | ·null | 3158 Spring Street | Mesa | AZ | 85256 | null·· | null |
| PRV | PRV-22084 | 2026-06-03T10:34:34Z | Andrew | — | Fisher | 1976-09-27 | UHC-49611-17 | •••-••-2735 | 621-841-8223 | — | 6348 Bayshore Dr | Tampa | FL | 33622-8756 | UNKNOWN | — |
| PRV | PRV-25082 | 2026-09-07T07:18:21Z | DANIELLE | Q. | PETERSON | 01/25/49 | — | — | NULL | danielle.peterson50@gmail.com | 1519 JEFFERSON AVE | Mesa | AZ | 85265 | ·- | — |
| PRV | PRV-26044 | 2026-07-14T01:59:24Z | NATALIE·· | — | FIELDS | 1991-03-02 | UHC-40274-76 | null | 939-357-7098 | — | 8410 Desert Sky Boulevard·· | Tucson | AZ | 85720 | N/A | — |
| PRV | PRV-27216 | 2026-05-29T09:52:09Z | Stephanie | — | Harris | 12/15/1943 | UHC-40495-92 | N/A | +1 690 371 5635 | — | 3844 Spring St | EDEN PRAIRIE | MN | 55306-1110 | UNKNOWN | — |
| PRV | PRV-21915 | 2026-07-26T01:35:58Z | YUKI | — | SANTIAGO | 19410409 | NULL | NULL | 469-976-2795 | yuki.santiago11@hotmail.com | NULL | NULL·· | N/A | UNKNOWN | — | - |
| PRV | PRV-20351 | 2026-02-13T07:56:52Z | Janice | Z | ·Luna | 1976-10-02 | N/A | — | +1 243 352 1738 | null | 6923 Palm Drive | Tucson | Arizona·· | 85763 | ·- | NAVIGATE-HMO |
| PRV | PRV-26186 | 2026-04-09T00:34:25Z | Arthur | O | Kelley | 1973-10-12 | UHC-35949-93 | •••-••-6351 | (426) 671-4227 | arthur.kelley70@proton.me | 5723 WASHINGTON ST | Jacksonville·· | FL·· | 32202 | N/A | CHOICE-PLUS-PPO |
| PRV | PRV-22758 | 2026-04-13T12:21:11Z | Stewart, Kenneth | — | — | ·· | — | null·· | 12539247268 | — | 333 JEFFERSON AVENUE | Atlanta | GA | — | N/A | — |
| PRV | PRV-25474 | 2026-09-06T13:07:15Z | Linda | F | OBrien | 2003-06-27 | NULL | ···· | 8622615137 | — | 4621 Central Ave | Tempe | AZ | 85242 | UNKNOWN | - |
| PRV | PRV-22541 | 2026-03-27T22:30:37Z | Susan | — | Murphy | ·03-06-1996 | NULL | N/A | 757-667-4321 | SUSAN.MURPHY@AOL.COM | 1234 Broadway | Tempe | AZ | — | — | UNKNOWN |
| PRV | PRV-24433 | 2026-03-06T12:10:54Z | Burton, Nathan | — | — | ·1997-10-09 | — | NULL | (985) 676-4577 | null | 3629 Union St | Atlanta | GA·· | 30308 | — | NULL |
| PRV | PRV-20459 | 2026-03-10T10:54:27Z | Henry | — | Jordan·· | 1964-09-22 | null | N/A | 660-772-6878·· | null | NULL | UNKNOWN | N/A | null | ·N/A | null |
| PRV | PRV-22745 | 2026-02-01T13:34:30Z | ELIJAH | — | GRAY | 20020726 | UHC-73436-77 | null | ·638.296.9891 | ·N/A | NULL | N/A | N/A | ·· | N/A | CORE-HMO |
| PRV | PRV-24634 | 2026-08-23T17:47:29Z | Lisa | R | Warren | 1987-03-08 | ···· | - | (681) 428-6068 | ·- | 1800 Lincoln Way | Austin | TX | 78786 | — | MEDICARE-ADV-A |
| PRV | PRV-29295 | 2026-06-26T04:27:06Z | Denise | — | Walker | Jul 11, 1960 | — | UNKNOWN | (391) 552-8076 | denise.walker42@gmail.com | 4844 PALM DR #237 | Nashville | ·TN | 37274 | N/A | N/A |
| PRV | PRV-23857 | 2026-07-29T02:11:26Z | Wayne | ·T | Piercce | 20070317 | — | - | 277.507.6446 | UNKNOWN | 8049 Highland Ave | DALLAS | ·TX | 75277 | — | NAVIGATE-HMO |
| PRV | PRV-20312 | 2026-06-23T07:49:54Z | William | — | Daniels | 1941-08-01 | — | — | 5252377028 | — | 1798 RIDGE ROAD Apt 11 | AUSTIN | TX·· | 78778 | null | — |
| PRV | PRV-26437 | 2026-02-25T09:02:01Z | GERALD | — | BELL | 01/17/1972 | - | UNKNOWN | 754-523-1201 | NULL | ·581 Oak Street | MESA | Arizona | 85264 | NULL | MEDICARE-ADV-A |
| PRV | PRV-28598 | 2026-05-11T18:02:43Z | RAYMOND | — | RICHARDS | 1962-10-21 | UHC-30938-76 | — | 518-384-0984·· | — | 4610 Union Street | Charlotte | NC | 28270 | — | null |
| PRV | PRV-23500 | 2026-10-04T20:45:22Z | Hiroshi | ···· | Hanson | 12/11/1939 | UHC-76924-24·· | UNKNOWN | 948-475-5377 | — | ·6791 BASELINE RD | Minneapolis | MN | 55425 | — | CORE-HMO |
| PRV | PRV-20856 | 2026-09-20T06:51:23Z | Arjun | — | Turner | 09/08/84 | N/A | •••-••-8698 | — | arjun.turner5@proton.me | 8735 Valley View Drive | Phoenix | Arizona | ·85067 | null | ·· |
| PRV | PRV-20290 | 2026-09-27T12:53:48Z | ·Christian | I | Williamson | 1974-08-05 | — | UNKNOWN | UNKNOWN·· | UNKNOWN | 3455 OAK ST·· | CHANDLER | ·AZ | 85285 | N/A | NULL |
| PRV | PRV-23604 | 2026-05-31T03:56:33Z | beverly | Y | hunt | 05/06/1984 | - | - | 337-333-6093 | null | 1902 Maple Ave·· | Gilbert·· | ·Arizona | 85246 | UNKNOWN | NULL |
| PRV | PRV-22407 | 2026-01-26T08:29:31Z | STEPHANIE·· | — | ADAMS | 12/25/1955 | UHC-59976-73 | — | 540-607-2644 | UNKNOWN | 3604 River Rd·· | Eden Prairie | MN | 55376 | 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:46.441Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty