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-29407 | 2026-08-15T02:45:48Z | Kelly | I | Gutierrez | 19901016 | ·UHC-76846-41 | — | 890-791-7505 | - | 6693 Maple Avenue·· | Las Vegas | NV | 89123 | null | CORE-HMO |
| PRV | PRV-25117 | 2026-05-08T02:30:41Z | DANIELLE | — | JORDAN | 12/20/1973 | UHC-72650-33 | — | — | UNKNOWN | 2275 Hillcrest Road | Sacramento | CA | ·95836 | — | - |
| PRV | PRV-25382 | 2026-01-10T22:24:51Z | BOBBY | — | BANKS | 1976-05-12 | - | UNKNOWN | 462-275-9381 | BOBBY.BANKS@ICLOUD.COM | 5703 Valley View Dr #468 | Eden Prairie | MN | 55306 | ···· | select-epo |
| PRV | PRV-28455 | 2026-09-21T18:02:26Z | Ruth | — | Reynolds | 26-04-1989 | — | - | +1 283 972 6833 | — | 8399 Central Ave | Tempe | AZ | 85260 | null | N/A |
| PRV | PRV-24671 | 2026-08-31T12:09:54Z | Walsh | — | Janice | 1941-09-05 | uhc-88062-59 | — | +1 485 811 6124 | JANICE.WALSH@ICLOUD.COM | 6935 BASELINE RD | Houston | TX | 77024 | UNKNOWN | N/A |
| PRV | PRV-24948 | 2026-05-16T23:21:22Z | LUIS | — | DELGADO | 5/8/1999 | NULL | null | 503-222-3372 | — | 6453 Grand Ave Apt 30 | ·Las Vegas | NV | 89193 | N/A | — |
| PRV | PRV-28405 | 2026-06-18T10:12:08Z | Valentina | — | Scott | 1983-10-26 | N/A | NULL | (345) 226-0399 | VALENTINA.SCOTT60@ICLOUD.COM | 6070 Elm Street | Gilbert·· | Arizona | 85220-0456 | null·· | — |
| PRV | PRV-21141 | 2026-01-01T04:35:34Z | Valentina | ···· | Salazar | 1971-07-20 | null | — | 7558263969 | NULL | NULL | NULL | null | UNKNOWN | UNKNOWN | — |
| PRV | PRV-22165 | 2026-04-24T19:07:59Z | Joyce | — | ·Thompson | 91520217 | NULL | N/A | 7828946526 | — | 2819 Pine Dr | Fresno | CA | 93721 | null | — |
| PRV | PRV-29012 | 2026-05-25T21:50:22Z | CATHERINE | L·· | MARSHALL | 18-12-1999 | NULL | null | NULL | catherine.marshall80@gmail.com | — | — | - | NULL | — | CORE-HMO |
| PRV | PRV-25204 | 2026-03-17T14:18:48Z | mariana G | — | gutierrez | 7/23/1999 | - | •••-••-7629 | 6016756473 | mariana.gutierrez84@hotmail.com | 8486 Central Ave | Mesa | AZ | null | — | - |
| PRV | PRV-22115 | 2026-10-17T06:17:37Z | ·ryan | M | duncan | 2002-11-20 | - | null | 500.236.3668 | — | 8674 Willow Court | PLANO | TX | ·75024 | ···· | CHOICE-PLUS-PPO |
| PRV | PRV-24774 | 2026-07-06T02:58:13Z | ANGELA | — | ROSE | 9/19/1944 | UHC-67908-80 | UNKNOWN | +1 526 596 0167 | angela.rose@hotmail.com | 2743 RIDGE RD | HOUSTON | TX | 77006 | — | null |
| PRV | PRV-25593 | 2026-01-23T13:21:04Z | SOPHIA | I | HILL·· | 13-03-1996 | UNKNOWN | •••-••-6938 | 734-656-4859 | sophia.hill96@hotmail.com | 7644 Hillcrest Road | Houston | ·TX | 77057-5126 | — | null |
| PRV | PRV-25245 | 2026-01-02T16:35:21Z | Timothy | — | Gordon | 03/04/67 | — | — | 499-346-4992 | N/A | null | UNKNOWN | NULL | — | null | NULL |
| PRV | PRV-23882 | 2026-06-09T07:02:21Z | Brandon | — | Rojas | 1940-05-16 | UHC-05735-97 | •••-••-2861 | 335-319-4071 | brandon.rojas@yahoo.com | 5141 UNION STREET #419 | SEATTLE | Washington | 98127 | null | NAVIGATE-HMO |
| PRV | PRV-21459 | 2026-04-19T10:34:23Z | TIMOTHY | — | LOPEZ | 01/15/1945 | NULL | — | (513) 672-6619 | NULL | 9308 MEADOW LN | Nashville | TN | 37271 | NULL | UNKNOWN |
| PRV | PRV-23991 | 2026-01-10T04:52:16Z | Alice·· | X. | Baker | 1952-04-16 | UHC-01066-48 | — | ·738.240.0525 | ALICE.BAKER@HOTMAIL.COM | 2666 Church St | Gilbert | AZ | — | UNKNOWN | — |
| PRV | PRV-20533 | 2026-06-21T00:00:04Z | David | — | Turner | ·1940-04-17 | UHC-15533-67·· | — | (733) 399-5098 | DAVID.TURNER@OUTLOOK.COM | 9519 Jefferson Avenue | Charlotte | NC | 28209 | — | — |
| PRV | PRV-26574 | 2026-02-02T04:39:05Z | Justin | M | Knight | 1985-10-27 | UHC-39714-96 | N/A | — | justin.knight@icloud.com | 2762 FOREST AVENUE | Seattle | ·WA | 98102 | N/A | ·CHOICE-PLUS-PPO |
| PRV | PRV-27164 | 2026-07-16T20:48:13Z | Marcus | E | Myers | 1989-08-13 | — | — | — | null | 95 Lake View Rd | Tucson | AZ | 85700 | - | MEDICARE-ADV-A·· |
| PRV | PRV-25481 | 2026-02-21T21:37:19Z | diana | — | flures·· | Jul 19, 1990·· | — | •••-••-2624 | N/A | diana.flores97@outlook.com | 7000 DESERT SKY BLVD | Nashville | TN | 37234·· | null | -·· |
| PRV | PRV-24721 | 2026-01-28T23:34:31Z | Nathan | — | Campbell | Jan 12, 1958 | UHC-46707-26 | •••-••-8367 | +1 812 345 8389 | — | 6555 Palm Drive | Charlotte | NC | 28231 | — | - |
| PRV | PRV-21322 | 2026-04-16T13:07:40Z | Guzman, Kathleen | — | — | Nov 7, 2004·· | ·UHC-40091-84 | null | 501-522-5365 | N/A·· | — | NULL | null | UNKNOWN | null | — |
| PRV | PRV-20886 | 2026-09-14T05:00:19Z | Jonathan | L. | Sullivan | 01/10/76 | UHC-13997-31 | - | 269-487-1564 | jonathan.sullivan@aol.com·· | 7212 Mesa Dr #208 | GILBERT | AZ | 85231 | null | UNKNOWN |
| PRV | PRV-28280 | 2026-09-15T20:51:23Z | Vega, Lisa | J. | ···· | 1965-03-05 | UHC-36382-30 | UNKNOWN | 19399589061 | lisa.vega24@hotmail.com | 9673 Indian School Rd | Houston | TX | 77014-6333 | N/A | ·· |
| PRV | PRV-28351 | 2026-07-11T00:27:52Z | Don | — | Nguyen | Dec 16, 1986 | - | — | null | null | ·4619 Camelback Road | Minneapolis | MN | 55424 | null | null |
| PRV | PRV-24626 | 2026-08-07T10:33:20Z | Benjamin | — | Welch | 14-07-2001 | UHC-88140-28 | — | (341) 750-2380 | benjamin.welch@aol.com | 8914 Willow Ct | Columbus | OH | 43270·· | — | null |
| PRV | PRV-23692 | 2026-08-07T19:41:25Z | CHRISTINA | M | — | 09/19/1954 | ·UHC-81624-09 | — | 442.221.8009 | — | 6995 Pine Dr | Plano | TX | 75052 | null | OPTIONS-PPO |
| PRV | PRV-21165 | 2026-07-18T03:06:28Z | Emily | — | Valdez | 1942-11-17 | - | — | 5846473 | N/A | 2291 RIDGE ROAD | ·Orlando | FL | 32855 | UNKNOWN | NULL |
| PRV | PRV-22050 | 2026-06-23T10:42:08Z | LAURA | — | BURKE | 1972-11-18 | UHC-40110-94 | null | - | UNKNOWN | 5085 MARKET ST | SEATTLE | WA | 98185 | — | SELECT-EPO |
| PRV | PRV-23100 | 2026-10-02T01:29:21Z | GREGORY | — | HUDSON | 1954-02-04 | - | N/A | (535) 636-8820 | NULL | 8058 Main Street | Nashville | TN·· | 37262-9775 | ·· | - |
| PRV | PRV-21157 | 2026-09-09T05:00:56Z | Roy | — | Morales | 19690921 | null | N/A | (573) 817-5102 | N/A | ·3291 SUNSET BLVD | Glendale | AZ | 85350 | ·· | OPTIONS-PPO |
| PRV | PRV-23525 | 2026-08-21T19:32:23Z | MARTHA | — | POWELL | 12/23/1943 | UHC-78239-03 | •••-••-8402 | 9737120551 | N/A | — | NULL | — | UNKNOWN | — | — |
| PRV | PRV-29294 | 2026-09-12T06:16:16Z | Aisha | T | Hughes | 2002-02-24 | — | null | 5151798 | aisha.hughes48@aol.com | 3610 OAK ST | Las Vegas | Nevada | 89182 | UNKNOWN | null |
| PRV | PRV-26705 | 2026-10-18T12:06:35Z | ARTHUR | V | LAWSON | 01/04/80 | UNKNOWN | - | 237-594-4552 | NULL | UNKNOWN | — | ···· | — | — | — |
| PRV | PRV-24994 | 2026-06-17T10:31:29Z | ALBERT·· | L. | SANTOS | Dec 7, 1956 | — | null | 547-897-5623 | null·· | 8286 Harbor Boulevard | Mesa | AZ | 85246 | N/A | N/A |
| PRV | PRV-26975 | 2026-06-09T19:34:17Z | Scott | ·U | Delgado | 1964-08-08 | UHC-84050-71 | — | 2019128572 | null | 2628 MOUNTAIN VIEW DRIVE | Nashville | tn | 37274 | UNKNOWN | null |
| PRV | PRV-23264 | 2026-05-21T12:34:57Z | Hill, Debra | — | — | 19471210 | NULL | - | 3066553236 | null | 3871 Bayshore Drive | Phoenix | AZ | 85041-6448 | ·- | — |
| PRV | PRV-23408 | 2026-03-18T14:09:21Z | Juna | C | Singh | 7/2/1968 | null | — | (559) 411-9668 | juan.singh29@yahoo.com | 4657 Cedar Lane | Miami | Florida | 33155 | — | SELECT-EPO·· |
| PRV | PRV-27733 | 2026-04-05T03:42:46Z | Charles | M. | Hoffman | 1958-06-21 | UHC-08773-02 | — | 12152540032 | ·N/A | — | — | — | — | - | UNKNOWN |
| PRV | PRV-26110 | 2026-08-09T18:44:51Z | Michael | ·· | Pierce | 1992-03-04 | null | NULL | 3454479000 | — | N/A | null | — | ···· | — | - |
| PRV | PRV-24569 | 2026-09-23T11:59:01Z | Jacob | — | Greene | 9184-10-02 | UHC-35926-22·· | ···· | 3149657945 | — | 9893 Meadow Ln #312 | ·Jacksonville | Florida | 32211 | - | MEDICARE-ADV-B |
| PRV | PRV-29462 | 2026-02-16T03:29:53Z | Debra | G | Stevens | May 19, 1953 | — | NULL | (688) 437-6812 | NULL | 1289 Lincoln Way | Denver | CO | 80211 | — | — |
| PRV | PRV-28878 | 2026-03-24T11:39:10Z | Bian | — | Burke | Jun 24, 2003 | UHC-91013-14 | — | (942) 586-6095 | - | 4636 UNION STREET | FRESNO·· | CA | 93767 | - | CHOICE-PLUS-PPO |
| PRV | PRV-26302 | 2026-04-02T12:26:36Z | Paul·· | — | Stone | Nov 3, 1957 | UHC-18642-90 | N/A | (247) 392-7138 | paul.stone51@gmail.com | 8452 Camelback Road | Jacksonville | fl | 32257 | ···· | NULL |
| PRV | PRV-29470 | 2026-10-15T10:12:53Z | Pena, Diana | — | — | 1978-11-05·· | null | — | 941-617-1581 | - | 8865 SUNSET BOULEVARD | Atlanta | GA | ·30309 | — | — |
| PRV | PRV-26567 | 2026-10-10T09:23:06Z | juan | — | medina | 1967-05-10 | UHC-12396-73 | — | 3984514614 | UNKNOWN | 1799 BAYSHORE DRIVE | Los Angeles | CA | 90075 | — | UNKNOWN |
| PRV | PRV-21197 | 2026-07-10T08:06:33Z | Scott | — | Long | 1943-11-10 | — | UNKNOWN | — | NULL | 484 Willow Court | Austin | Texas | 78738·· | — | null |
| PRV | PRV-26218 | 2026-10-03T11:12:34Z | Mayr | — | Owens | 1946-04-03 | UHC-44249-01 | •••-••-7058 | 837-344-3938 | MARY.OWENS@GMAIL.COM | 7422 Apache Blvd | Denver | CO | 80252 | 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:40.314Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty