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-20920 | 2026-08-06T10:47:13Z | Fatima | ···· | Schmidt·· | 10/08/1943 | — | •••-••-6991 | (344) 224-0097·· | -·· | 3998 Palm Drive Apt 33 | Denver | CO | 80256 | UNKNOWN | null |
| PRV | PRV-27754 | 2026-06-03T02:33:10Z | Martha | U | Richardson | 2002-07-26 | UNKNOWN | ·· | — | N/A | ·3299 Ocean Ave | Glendale | AZ | 85360 | - | N/A |
| PRV | PRV-26405 | 2026-03-10T20:58:53Z | Adam | — | Espinoza | 2002-01-22 | UHC-31431-03 | N/A | +1 272 661 0944 | adam.espinoza92@gmail.com | 344 PALM DRIVE #785 | Charlotte | ·NC | 28268 | — | null |
| PRV | PRV-26177 | 2026-04-24T03:00:36Z | Beverly | — | Soto | 08/25/1981 | UHC-36735-65 | null | null | UNKNOWN | 5451 Camelback Rd | Fresno | CA | 93714 | — | — |
| PRV | PRV-20352 | 2026-01-26T17:59:02Z | Gregory | — | ·Salazar | 1967-09-26 | null | — | (663) 903-8016 | NULL | 7702 APACHE BLVD | Seattle | WA | ·98131 | — | N/A |
| PRV | PRV-27085 | 2026-01-03T06:14:46Z | Anna | — | Wagner | 02/07/1969 | UNKNOWN | UNKNOWN | ·369-453-5865 | UNKNOWN | 2838 Main St | ·Chandler | AZ·· | 85251-2267 | — | ·· |
| PRV | PRV-22988 | 2026-07-03T16:37:08Z | KEITH | ·· | TORRES | 19561222 | — | NULL·· | 9066891591 | — | 8102 Main Street | Houston | TX | 77018 | ·· | SELECT-EPO |
| PRV | PRV-25489 | 2026-10-03T12:06:57Z | AISHA | — | CASTRO | 1938-10-08 | UHC0296776 | ·· | 894-604-0056 | - | 3200 Apache Boulevard | LAS VEGAS | NV | 89111 | NULL | — |
| PRV | PRV-24631 | 2026-06-22T13:34:53Z | CYNTHIA | ·J | MITCHELL | 18-08-1993 | UHC-39160-11 | N/A | (216) 482-0816 | N/A | 308 Broadway | Tampa | FL | ·33602-8497 | NULL | - |
| PRV | PRV-25194 | 2026-05-10T06:22:13Z | Janice | — | Perry | 11/11/2001 | UHC-27746-87 | •••-••-3847 | 9502029778 | NULL | 112 HIGHLAND AVENUE | Eden Prairie | MN | ·55327 | ·NULL | ·· |
| PRV | PRV-27265 | 2026-07-19T06:05:58Z | RONALD | ···· | VALDEZ | 18-10-1978 | N/A | — | 728-746-8816 | ronald.valdez@proton.me | 9019 CENTRAL AVENUE | Jacksonville | FL | 32234 | N/A | NULL |
| PRV | PRV-29201 | 2026-04-21T00:59:07Z | Natalie | — | Moore | 1963-05-18 | UHC-14789-97 | UNKNOWN | 2732498869 | NATALIE.MOORE93@AOL.COM | 1524 Valley View Dr | Austin | TX | 78776 | — | null |
| PRV | PRV-28027 | 2026-07-03T19:16:36Z | Brian | — | Adams | 1954-04-02 | - | — | ·(785) 743-0725 | NULL | 4847 Ridge Road | Minneapolis | ·Minnesota | 55470 | ·NULL | N/A |
| PRV | PRV-20812 | 2026-05-24T17:28:40Z | JUAN | — | MARTIN | 1963-07-17 | - | - | 6396137275 | null | 5914 Apache Blvd | Scottsdale | AZ | 85222 | NULL | null |
| PRV | PRV-22363 | 2026-03-09T22:37:03Z | Kathy | — | Ford | 1939-07-16 | UHC-11119-53 | — | 18433358005 | ·UNKNOWN | ·9302 Main St | Tucson | AZ | 85720 | null | null |
| PRV | PRV-24993 | 2026-05-03T01:55:07Z | WALTRE | — | COLE | 1946-03-19·· | UHC-18104-33 | — | +1 267 383 1887 | ·NULL | 6107 Palm Drive | Atlanta | GA | 30382 | ·N/A | ···· |
| PRV | PRV-24716 | 2026-01-30T00:20:33Z | RACHEL | ·· | ALLEN | 1990-08-27 | N/A | ···· | 9706551598 | — | 1261 Lake View Rd | Chandler | AZ | 85284 | ···· | - |
| PRV | PRV-22245 | 2026-02-28T20:35:21Z | Aslhey | — | Brooks | 1991-03-10 | UHC-93298-79 | UNKNOWN | UNKNOWN | — | 1256 Canyon Rd | Phoenix | AZ | 85069 | — | null |
| PRV | PRV-24729 | 2026-07-31T06:06:36Z | ALBERT | — | JOHNSTON | 1961-03-13 | UHC-99093-54 | NULL | +1 921 203 7775 | UNKNOWN | 6902 INDIAN SCHOOL ROAD | Chandler | AZ | 85283-2581 | null | — |
| PRV | PRV-24612 | 2026-03-03T13:42:16Z | Berry, Timothy | — | ·· | 1963-09-08 | N/A | UNKNOWN | 218-403-7704·· | timothy.berry99@aol.com | 3376 Spring St | Dallas | TX·· | 75284 | NULL | SELECT-EPO |
| PRV | PRV-20031 | 2026-02-10T10:26:39Z | MARK | — | BURKE | 1994-05-26 | NULL | — | 953-327-4220 | UNKNOWN | 4572 FOREST AVE | Nashville | TN | 37289 | — | null |
| PRV | PRV-28746 | 2026-08-14T13:46:27Z | CATHERINE | — | LASRON | 1971-12-20 | null | N/A | 642-285-2095 | catherine.larson@gmail.com | 2721 SUNSET BLVD | San Diego | CA | 92109 | -·· | NULL |
| PRV | PRV-29280 | 2026-09-01T20:04:23Z | Mari | — | Tran | 1982-06-18 | UHC-00957-09 | — | 631-643-3919 | ·N/A | 5726 Park Pl | Phoenix | AZ | 85061 | N/A | null |
| PRV | PRV-24370 | 2026-05-11T17:39:47Z | Carter, Lawrence | — | — | — | null | — | null | LAWRENCE.CARTER11@AOL.COM | 1881 JEFFERSON AVE | Scottsdale | AZ | 85206·· | N/A | ·N/A |
| PRV | PRV-23265 | 2026-01-14T18:56:17Z | LAUREN | — | COOK | 09/16/91 | NULL | NULL | 14207704301 | — | 5042 Highland Avenue·· | San Antonio | TX | 78202-3040·· | null | — |
| PRV | PRV-28291 | 2026-03-22T06:23:57Z | Richard | Z | Bailey | May 8, 1969 | UHC-89724-56 | •••-••-4356 | 824-467-8316 | richard.bailey@yahoo.com | UNKNOWN | — | N/A | UNKNOWN | - | — |
| PRV | PRV-24215 | 2026-02-08T18:58:18Z | SAMUEL | — | HALL | 07/09/1969 | uhc-98058-91 | — | (772) 341-6986 | samuel.hall85@aol.com | 2021 Spring St·· | Fresno | CA | 93792 | — | — |
| PRV | PRV-29429 | 2026-09-16T03:38:09Z | ·LISA | S. | NELSON | Aug 13, 1971 | UHC-22297-46 | UNKNOWN | 494-756-1674 | — | 4376 MESA DRIVE | ·Scottsdale | AZ·· | 85289 | UNKNOWN | MEDICARE-ADV-A |
| PRV | PRV-26626 | 2026-08-28T02:06:48Z | Amanda | — | Alexander | 1938-02-27 | UHC-10695-82 | null·· | +1 933 683 2337 | amanda.alexander@gmail.com | 879 Sunset Blvd | Houston | TX | 77027 | ···· | null |
| PRV | PRV-22688 | 2026-07-25T16:32:03Z | LAWRENCE | — | ADAMS | 08-01-1971 | — | - | 697-942-6797 | NULL | 529 Sunset Boulevard | Charlotte | North Carolina | 28238 | UNKNOWN | NULL |
| PRV | PRV-23305 | 2026-09-03T15:42:35Z | Christina | O·· | ·Maldonado | 1957-06-20 | — | — | +1 363 395 6290 | - | 8246 Valley View Drive | ·Eden Prairie | MN | ·55379 | - | NULL |
| PRV | PRV-22402 | 2026-04-21T04:28:19Z | EMMA | — | DUNN | 1944-10-28 | UHC-06624-87 | — | 511-601-9461 | NULL | 1261 Highland Ave | Denver | CO | 80272 | null | UNKNOWN |
| PRV | PRV-26349 | 2026-05-26T14:04:19Z | ·MEGAN | — | MEDINA | 1944-10-12 | null | NULL | (352) 967-5550·· | ·· | 3116 Hillcrest Rd·· | Jacksonville | ·FL | 32245 | null | — |
| PRV | PRV-22495 | 2026-07-24T17:17:32Z | RALPH·· | — | CARPENTER | 1967-06-11 | NULL | UNKNOWN | (789) 490-9266 | — | 9818 Baseline Rd | Jacksonville | FL·· | 32236-1485 | UNKNOWN | — |
| PRV | PRV-25558 | 2026-06-06T06:46:18Z | Garrett, Ann | — | — | 01/19/1977 | null | NULL | — | N/A | 6583 Oak Street | Houston | TX | 77084 | - | null·· |
| PRV | PRV-26833 | 2026-06-15T00:02:28Z | ·Dylan | — | Martin | 3/15/1946 | UHC4151635·· | null | 19334409259 | UNKNOWN | 3591 Lake View Road #279 | Tampa | FL | ·33622 | null | NULL |
| PRV | PRV-24127 | 2026-09-04T13:00:24Z | Ralph | — | Wang | 1957-12-03 | UHC-14239-31 | — | 19104336575 | — | 5835 Washington St | Chandler | Arizona·· | 85295 | ···· | ·· |
| PRV | PRV-28903 | 2026-09-17T06:23:32Z | LUIS | — | WATSON | 1975-09-62 | UHC-67075-45 | — | +1 478 805 3781·· | luis.watson58@gmail.com | 844 Washington Street | Gilbert | AZ | 85232 | null | — |
| PRV | PRV-28958 | 2026-10-07T07:19:32Z | Edward | A | Hunt | 1999-06-24 | UHC-76455-82 | •••-••-6794 | (946) 336-4219 | NULL | NULL | UNKNOWN | — | NULL·· | ·N/A | OPTIONS-PPO |
| PRV | PRV-21460 | 2026-04-04T01:40:49Z | Tim | — | Lopez | 1946-01-15 | UHC-58975-81 | — | (513) 672-6619 | — | 9308 Meadow Lane·· | Nashville | TN | 37271 | — | CHOICE-PLUS-PPO |
| PRV | PRV-21880 | 2026-08-29T11:19:49Z | JEAN | — | DAVIS | 1979-12-02 | N/A | •••-••-4088 | 712-382-8977 | jean.davis12@aol.com | 4831 HIGHLAND AVE #411 | Nashville | ·Tennessee | 37203·· | - | - |
| PRV | PRV-22433 | 2026-01-15T21:48:05Z | mateo | K. | clark | 2006-01-06 | UHC-38810-30·· | - | 857-465-9904 | mateo.clark7@aol.com | ·399 Mesa Dr | Scottsdale | AZ | 85204 | NULL | ·null |
| PRV | PRV-24451 | 2026-01-11T21:40:16Z | PHILIP | — | LUNA | 12/08/99 | UHC-82234-73 | - | 401-639-9901 | N/A | 3718 CAMELBACK ROAD | MINNEAPOLIS | mn·· | 55498 | N/A | NULL |
| PRV | PRV-24267 | 2026-02-04T12:35:07Z | Mateo | — | Elliott | 1996-02-27 | UHC-10418-03 | •••-••-3447 | 5548525222 | UNKNOWN | — | NULL | — | NULL | UNKNOWN | — |
| PRV | PRV-25228 | 2026-07-01T13:59:59Z | Lttle, Adam | I | — | 1943-08-22 | - | •••-••-5436 | +1 551 542 4028 | - | ·1689 MOUNTAIN VIEW DRIVE | Nashville | Tennessee | 37201 | N/A | null |
| PRV | PRV-21639 | 2026-06-20T16:22:26Z | ·Brandon | — | Snyder | 1968-12-04 | UHC-55662-93 | UNKNOWN | (581) 970-1183 | null | — | — | NULL | N/A | - | NULL |
| PRV | PRV-21735 | 2026-05-29T02:34:54Z | STEVEN | Y. | ORTEGA | 03/27/41 | UHC-06063-03 | null | 2828626106 | STEVEN.ORTEGA83@YAHOO.COM·· | 1456 Jefferson Avenue | Tempe | AZ | 85239 | N/A | null |
| PRV | PRV-24725 | 2026-07-30T23:16:18Z | Chuck | — | Brooks | 2001-12-41 | UHC-36973-25 | null | (738) 260-6017 | charles.brooks11@proton.me | 4048 River Rd #874 | Orlando | FL | ·32874 | -·· | NULL |
| PRV | PRV-26260 | 2026-05-20T23:22:58Z | Brittany | ···· | Mendez | 1946-05-27 | UNKNOWN | UNKNOWN | N/A | — | 5701 Baseline Road | Columbus | OH | 43234·· | — | - |
| PRV | PRV-29057 | 2026-01-21T02:01:14Z | bobby | — | arnold | 1987-06-23 | UHC-31712-74 | ·NULL | (750) 355-9603 | ···· | 9386 HARBOR BOULEVARD | Columbus | oh | 43263-4518 | 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:43:03.417Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty