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-24351 | 2026-09-30T05:50:29Z | AUSTIN | — | WOOD | 1985-10-06·· | UHC-01868-34 | N/A | 9204725 | NULL | 5714 Cedar Ln·· | Atlanta | GA | 30356 | UNKNOWN | — |
| PRV | PRV-22653 | 2026-08-29T03:47:57Z | EUGENE | — | COLINS | 2005-05-18 | UHC-77997-41 | — | 864-350-2892 | — | 1653 HIGHLAND AVENUE | ·Tempe | AZ | 85221 | null | - |
| PRV | PRV-22735 | 2026-06-08T17:06:43Z | Charlotte | — | Nunze | 1991-06-08 | null | •••-••-7835 | 6996997536 | - | 3202 MEADOW LANE | Phoenix | AZ | 85016 | — | - |
| PRV | PRV-22087 | 2026-08-02T21:11:32Z | emma | ···· | ·tucker | 1955-10-18 | UHC-67045-13 | •••-••-4708 | NULL·· | NULL | 4116 Market Street·· | Mesa | AZ | 85245 | — | SELECT-EPO |
| PRV | PRV-21989 | 2026-09-16T00:20:24Z | Maria | — | Robinson | Dec 3, 1962 | UHC-39058-94 | null | 282-920-0240 | — | 717 Grand Avenue | Columbus | OH | UNKNOWN | null | N/A |
| PRV | PRV-28618 | 2026-05-24T09:43:19Z | Donna | — | Cook | 1944-02-16 | N/A·· | - | 256-333-9851 | null | 599 Washington Street Apt 33 | FRESNO | CA | 93712 | - | null·· |
| PRV | PRV-22176 | 2026-06-06T10:37:19Z | Patrick | C. | Carroll | 1986-01-15 | null | N/A | - | PATRICK.CARROLL5@AOL.COM | 9191 Meadow Ln·· | San Antonio | TX·· | 78280 | — | — |
| PRV | PRV-20158 | 2026-05-21T20:26:47Z | Harold | X.·· | Carter | 2/3/1939 | — | UNKNOWN | null | UNKNOWN | 5029 LINCOLN WAY | PHOENIX | AZ | 85020 | - | — |
| PRV | PRV-20119 | 2026-02-03T01:11:39Z | Madison | M. | Wright·· | 1971-11-10 | UHC-57868-16 | UNKNOWN | N/A | NULL | 1261 Harbor Blvd | Chandler | AZ | 85264 | — | SELECT-EPO |
| PRV | PRV-20815 | 2026-09-16T16:52:13Z | Sandra | ···· | Wang | 19920725 | UHC-11750-72 | — | 249.266.0154 | ·null | ·4488 Cedar Ln | Seattle | WA | — | ·NULL | N/A |
| PRV | PRV-25098 | 2026-02-09T20:29:38Z | jack | — | campbell | 16-03-1968 | null | •••-••-2280 | 304-326-0715 | jack.campbell86@outlook.com | ·1440 Grand Ave #603 | Las Vegas | Nevada | 89133 | - | ·UNKNOWN |
| PRV | PRV-27525 | 2026-09-04T03:43:53Z | Aisha | — | Maldonado | 19640408 | N/A | — | 12406308438 | - | — | - | ·UNKNOWN | — | N/A | null |
| PRV | PRV-25130 | 2026-02-16T18:13:23Z | Alexis | J | West | 1996-10-23 | — | NULL | — | ALEXIS.WEST87@YAHOO.COM | 5812 Church St | Dallas | Texas | 75264 | NULL | NULL |
| PRV | PRV-23048 | 2026-07-19T00:36:47Z | Joyce | — | Morrison | 2008-07-04 | UHC-87643-47 | null | 3208896267 | JOYCE.MORRISON@HOTMAIL.COM·· | 2570 Lake View Road | NASHVILLE | TN | 37262 | UNKNOWN·· | N/A·· |
| PRV | PRV-22310 | 2026-04-22T12:51:57Z | ZACHARY | — | AGUILAR | 1944-03-27 | UHC-52452-64 | — | 396-415-1017 | zachary.aguilar@proton.me | 6999 Palm Dr | Jacksonville | FL | 32209 | UNKNOWN | — |
| PRV | PRV-23755 | 2026-03-24T02:35:06Z | Janice | — | Hunt | Dec 24, 1956 | UHC-20449-42 | •••-••-8328 | +1 856 900 3404 | UNKNOWN | 5192 Lincoln Way | Charlotte | NC | 28268 | NULL | null |
| PRV | PRV-24399 | 2026-02-25T12:15:14Z | JOSH | U. | BOWMAN·· | 1972-02-10 | UNKNOWN·· | NULL | 564-800-5827 | joshua.bowman@hotmail.com·· | 6523 JEFFERSON AVE | Charlotte·· | NC | 28261 | UNKNOWN | N/A |
| PRV | PRV-22931 | 2026-01-11T12:08:55Z | Emily | — | Nguyen | 2005-12-28 | UHC-56018-98 | — | UNKNOWN | ···· | 2586 Indian School Road | Sacramento | CA | 95836 | N/A | NULL |
| PRV | PRV-23103 | 2026-05-28T02:23:35Z | LAWRENCE | — | BISHOP | ·1986-08-04 | ·UHC-76858-34 | NULL | 4372496513 | NULL | 9670 Camelback Road | Gilbert | AZ | N/A | NULL | - |
| PRV | PRV-28251 | 2026-09-19T20:06:46Z | ·bruce | — | garrett | 24-06-1950 | UHC-17603-90 | UNKNOWN | 415-554-8487·· | NULL | 9636 Bayshore Drive | Columbus | OH | 43299 | NULL | UNKNOWN |
| PRV | PRV-25302 | 2026-01-14T22:52:59Z | DIANE | — | CONTRERAS | Aug 17, 1963 | UHC-13930-95 | — | ·14668453080 | DIANE.CONTRERAS57@OUTLOOK.COM | 7134 SAGE COURT | Fresno | CA | 93704 | NULL | — |
| PRV | PRV-21339 | 2026-05-30T10:46:59Z | SEAN | — | TORRES | 1939-04-18 | UHC-30998-65 | NULL | +1 690 676 5655 | — | 1225 PARK PL | LAS VEGAS | NV | 89121 | UNKNOWN | — |
| PRV | PRV-20181 | 2026-02-22T07:24:56Z | Katherine | — | Spencer·· | 1941-12-05 | — | •••-••-2815 | NULL | NULL | 7159 Jefferson Ave | Eden Prairie | MN | 55395 | null | — |
| PRV | PRV-25449 | 2026-10-17T18:42:00Z | David | M | Larson | 1986-04-27 | UHC-94457-68 | •••-••-8023 | 504-479-6623 | NULL | 5735 VALLEY VIEW DRIVE | Houston | TX | 77007-6673 | — | — |
| PRV | PRV-21171 | 2026-06-06T14:55:21Z | zachary | — | luna | 04-03-1949 | uhc-56365-90 | — | 4993825921 | zachary.luna57@gmail.com | 8165 Harbor Blvd | Glendale | AZ | 85350 | null | SELECT-EPO |
| PRV | PRV-29041 | 2026-03-26T15:35:53Z | ETHAN | S. | GARZA | 6/26/2002 | UHC-91432-94 | — | (349) 681-5937 | ·- | 9873 MARKET ST Apt 22 | Atlanta | GA | 30335 | N/A | NULL |
| PRV | PRV-28339 | 2026-07-31T09:10:26Z | richard | ·· | rice | 1977-10-05 | ·UHC-29214-90 | N/A | N/A | richard.rice@outlook.com | 2371 MESA DRIVE | PLANO | TX | 75010 | N/A | ·- |
| PRV | PRV-28788 | 2026-08-29T12:03:04Z | NOHA·· | — | SALAZAR | 01/25/06 | - | null | (599) 571-9198 | noah.salazar@outlook.com | 1356 Meadow Lane | TEMPE | AZ | 85273 | — | MEDICARE-ADV-A |
| PRV | PRV-26207 | 2026-05-02T20:49:06Z | Donald·· | — | Daniels | 0150-20-01 | — | UNKNOWN | (612) 423-8839 | UNKNOWN | 6814 VALLEY VIEW DR | DALLAS | TX | 75290 | null | — |
| PRV | PRV-20287 | 2026-02-01T09:57:18Z | KELLY | — | CARLSON | 1957-04-27 | null | NULL | 4959956984 | kelly.carlson@proton.me | 2153 CANYON ROAD | Nashville | TN | null | UNKNOWN | N/A |
| PRV | PRV-22018 | 2026-06-24T14:29:13Z | Amanda | — | ·Hicks | 1972-10-09 | UNKNOWN | UNKNOWN·· | 15958864136 | -·· | 5918 Forest Ave | MINNEAPOLIS | MN·· | 55439 | UNKNOWN | ·· |
| PRV | PRV-25581 | 2026-08-09T05:16:57Z | Evans, Sophia | ·· | — | 1974-12-27 | - | •••-••-0199 | +1 802 628 1086 | — | 9437 Sunset Boulevard | Chandler | Arizona | 85230-1897 | NULL | - |
| PRV | PRV-23587 | 2026-08-31T12:40:41Z | Shirley | R. | Howard | ···· | UNKNOWN | — | (308) 678-2307 | null | 9430 Lincoln Way | ·Charlotte | ·North Carolina | 28274 | — | NULL |
| PRV | PRV-27564 | 2026-01-14T16:49:47Z | Cynthia·· | — | Porter | ·Oct 11, 1983 | null | — | ·(274) 970-9102 | ·null | null·· | — | NULL | N/A | N/A | — |
| PRV | PRV-28150 | 2026-01-03T02:22:15Z | Jeffrey | ···· | Harvey | 1969-10-15 | UNKNOWN | •••-••-1237 | (335) 358-0723 | JEFFREY.HARVEY@OUTLOOK.COM | 6301 Valley View Drive | Nashville | TN | 37244 | - | UNKNOWN |
| PRV | PRV-21246 | 2026-03-21T19:04:21Z | Teresa | — | ·George | 1971-06-02 | NULL | •••-••-5674 | — | teresa.george62@outlook.com | NULL | — | - | null | - | SELECT-EPO |
| PRV | PRV-20447 | 2026-02-06T00:34:27Z | Emiyl | — | Yuong·· | 1987-09-27 | — | null | 624-386-8078 | NULL | 5517 Lincoln Way | Seattle | WA | 98182 | — | OPTIONS-PPO |
| PRV | PRV-21221 | 2026-08-06T00:43:09Z | Jacqueline | — | Jimenez | ·09/07/1950 | UHC-16993-83 | — | 886-974-0952 | - | 7066 Highland Ave | Orlando | FL | 32875·· | — | N/A |
| PRV | PRV-20308 | 2026-07-08T11:13:49Z | MEGAN | N | FIELDS | 15-05-2000 | UHC-44065-22 | NULL | +1 918 605 7828 | - | 1242 Spring Street | ·Columbus | OH·· | 43212 | UNKNOWN | — |
| PRV | PRV-29080 | 2026-08-02T14:26:23Z | angela | L. | morriis·· | 1957-05-17 | UNKNOWN | — | NULL | angela.morris18@proton.me | 610 Grand Avenue | Dallas | Texas | 75219 | NULL | NULL |
| PRV | PRV-27497 | 2026-06-10T02:12:25Z | KAYLA | ·· | TURNER | ·2001-02-19 | - | null | (309) 825-3639 | — | — | - | null | - | UNKNOWN | null |
| PRV | PRV-26467 | 2026-04-18T04:10:09Z | Beverly | Z | ·Vasquez | 1980-01-13 | null | •••-••-5735 | (278) 406-3649 | NULL | 3211 Meadow Ln Apt 35 | Denver | CO | 80216 | — | — |
| PRV | PRV-26663 | 2026-07-09T00:41:18Z | JOHN | — | REEYS | 07/07/52 | - | N/A | 6804201368 | NULL | 5780 Jefferson Avenue | Plano | TX·· | 75082 | — | OPTIONS-PPO |
| PRV | PRV-21913 | 2026-09-02T17:57:47Z | Jenkins, Hannah | — | — | ·15-11-1993 | N/A | — | — | hannah.jenkins31@aol.com | 1368 Mesa Dr | Austin | TX | 78756 | UNKNOWN | UNKNOWN |
| PRV | PRV-28566 | 2026-07-14T17:15:06Z | Marc·· | — | Hudson | 1977-06-02 | — | •••-••-7226 | - | marcus.hudson91@proton.me | ·4570 OAK ST | MINNEAPOLIS | MN | UNKNOWN | NULL | OPTIONS-PPO |
| PRV | PRV-22135 | 2026-02-08T22:17:01Z | Medina, Richard | — | — | 1988-06-20 | — | •••-••-7473 | 566.955.2739 | RICHARD.MEDINA91@HOTMAIL.COM | 9218 Highland Avenue | Eden Prairie | mn | 55378 | — | N/A |
| PRV | PRV-25346 | 2026-04-15T07:46:01Z | katherine | — | holmes | 1985-04-10 | NULL | — | 858-433-4280·· | KATHERINE.HOLMES17@ICLOUD.COM | 3359 Jefferson Avenue | HOUSTON | TX | 77016 | — | UNKNOWN |
| PRV | PRV-25670 | 2026-04-27T16:45:11Z | KAREN | S. | RIVERA | 1984-05-22 | null | UNKNOWN | (643) 959-5537 | null | 9144 RIDGE ROAD | ·Fresno | CA | 93779 | UNKNOWN | - |
| PRV | PRV-24621 | 2026-08-24T12:03:09Z | Campbell, Martha | — | ·· | 2007-12-27 | UHC-49054-08 | NULL | - | N/A | 2352 Broadway #466 | MESA | AZ | 85287 | ···· | — |
| PRV | PRV-26961 | 2026-01-15T15:59:48Z | Cox, Lary | — | — | null | UHC-25922-95 | NULL | (955) 370-6658 | - | ·4973 Grand Ave | Tampa | ·FL | 33619 | UNKNOWN | SELECT-EPO |
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.452Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty