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-24342 | 2026-08-16T23:46:20Z | john | K. | lynch | 1985-12-18 | UHC7169836 | - | 4619606705 | JOHN.LYNCH@AOL.COM | 4927 OCEAN AVE | Charlotte | NC | 28289 | N/A | — |
| PRV | PRV-23668 | 2026-09-24T20:03:39Z | justin | — | payne | ·1949-11-03 | UHC-39329-76 | N/A | 4482530587 | — | 1744 WILLOW COURT | Gilbert | AZ | 85216 | - | — |
| PRV | PRV-22144 | 2026-07-14T05:44:02Z | Lori | S. | Williams | 1984-07-03 | null | UNKNOWN·· | 201.800.1039 | null | 7541 Washington Street | Fresno | California | 93734 | - | - |
| PRV | PRV-23035 | 2026-03-14T22:23:00Z | MELISSA | — | PATTARSON | 1964-03-08 | NULL | - | 3085738275 | ·N/A | 64 Elm Street | Sacramento | CA | 95845 | — | — |
| PRV | PRV-29464 | 2026-02-04T03:43:12Z | Justin | — | Crawford | 1961-04-08 | — | null | UNKNOWN | justin.crawford70@hotmail.com | 5349 Washington St | Scottsdale | AZ | 85297 | UNKNOWN | N/A |
| PRV | PRV-28884 | 2026-08-03T21:44:30Z | THERESA | — | MUNOZ | ·1962-04-06 | - | UNKNOWN | -·· | N/A | 2470 CAMELBACK RD | ATLANTA | GA | ·30364-4260 | - | - |
| PRV | PRV-21126 | 2026-01-06T14:13:27Z | Virginia | B | Singh | 1957-04-27 | UNKNOWN | UNKNOWN | (710) 457-2779 | virginia.singh@gmail.com | 1609 Valley View Drive | Charlotte | NC·· | 28268·· | UNKNOWN | - |
| PRV | PRV-20930 | 2026-02-22T22:12:36Z | ZACHARY·· | — | REYNOLDS | 9/10/2006 | null | — | ·9077672286 | null | 1038 Main Street | PLANO | TX | UNKNOWN | ·- | NULL |
| PRV | PRV-23274 | 2026-04-14T13:32:04Z | MARIA | — | GRAY | 12/02/94 | UHC-06693-16 | - | 13295002298 | NULL | 7226 Lincoln Way | Charlotte | nc | 28208 | — | SELECT-EPO |
| PRV | PRV-29381 | 2026-05-07T08:33:09Z | FATIMA | — | RICHARDS | 2008-07-13 | NULL | - | 5423835971 | — | 7368 Baseline Road | Columbus | OH | 43262 | — | - |
| PRV | PRV-20526 | 2026-01-23T02:19:51Z | denise | — | mendoza | 1989-02-12 | UHC-54373-74 | ·· | (227) 766-8269 | ·NULL | 5546 Sunset Boulevard | Houston | TX | 77094 | — | — |
| PRV | PRV-25257 | 2026-01-04T10:16:24Z | DEBRA | — | ANDESRON | Oct 7, 1963 | UHC1573068 | •••-••-5429 | — | null | 4484 River Rd | ATLANTA | Georgia | — | N/A | - |
| PRV | PRV-24275 | 2026-01-18T11:10:23Z | Carl | — | Torres | 16-05-2000 | UNKNOWN | •••-••-3938 | UNKNOWN | — | 8732 LAKE VIEW RD | Glendale | AZ | 85342 | — | NULL |
| PRV | PRV-27907 | 2026-09-24T22:22:32Z | Thomas, Philip | — | — | 2/9/1993 | UHC-59106-02 | N/A | 967-671-7345 | PHILIP.THOMAS93@GMAIL.COM | 4175 Apache Boulevard | Orlando | FL·· | 32868 | - | MEDICARE-ADV-A |
| PRV | PRV-27018 | 2026-06-07T20:19:42Z | ·BENJAMIN | — | ·COX | Mar 7, 1983 | UHC-68145-78 | •••-••-0875 | (401) 954-8847 | — | 2173 MAIN STREET | San Antonio | TX | 78230-4861 | ·null | medicare-adv-a·· |
| PRV | PRV-25464 | 2026-07-25T07:51:05Z | BILLY | F·· | DUNN | 1938-08-19 | UNKNOWN·· | •••-••-0980 | (755) 323-0472 | ·N/A | 8982 Mountain View Dr | Chandler | AZ | 85225 | — | — |
| PRV | PRV-24756 | 2026-07-16T04:47:54Z | Lori | Z | Gibson | ·8/15/1960 | - | •••-••-6402 | (817) 425-9575 | - | 8161 RIDGE RD | Austin·· | TX | 78715 | — | SELECT-EPO·· |
| PRV | PRV-21550 | 2026-08-10T00:47:04Z | Ray, Sara | — | — | 1970-06-23 | UHC2093743 | null | 550-480-0879 | UNKNOWN | 2228 JEFFERSON AVENUE | Las Vegas | NV | 89120 | null | — |
| PRV | PRV-22767 | 2026-05-09T00:46:10Z | Aaron | — | Estrada | 1988-08-23 | UHC-63672-89 | ·null | +1 394 712 5800 | N/A | 8086 Pine Dr | Scottsdale | AZ | 85208 | null | SELECT-EPO |
| PRV | PRV-24016 | 2026-05-10T07:47:01Z | Jose | — | Adams | May 9, 1938 | UHC-52436-99 | — | 13018157190 | - | 3613 Ridge Rd | JACKSONVILLE | FL | ·32233 | N/A | NULL |
| PRV | PRV-21740 | 2026-02-24T21:55:35Z | ·DORIS | X. | ·COLEMAN | Jun 6, 1989 | — | •••-••-3226 | N/A | doris.coleman13@icloud.com | 342 Valley View Dr | Tempe | AZ | 85275 | ·null | null |
| PRV | PRV-25511 | 2026-08-26T19:55:31Z | Benntet, Lucia | — | — | ·12/08/1946 | UHC-47654-57 | UNKNOWN | 722.361.9686 | NULL | UNKNOWN·· | N/A | NULL | — | — | N/A |
| PRV | PRV-20256 | 2026-02-14T03:32:18Z | sarah | — | garrett | 22-06-1983 | UHC-10408-31 | UNKNOWN | 2517175277 | — | 9114 Indian School Rd | San Diego | CA | 92186 | UNKNOWN | NULL |
| PRV | PRV-22681 | 2026-07-28T18:06:48Z | MARIANA·· | — | WHEELER | 10/23/1959 | null | •••-••-0016 | — | — | 9891 Washington Street·· | Columbus | ·OH | 43204 | N/A | NULL |
| PRV | PRV-22835 | 2026-09-03T20:07:26Z | BRYAN | Z. | MARTINEZ | Oct 21, 2008 | UHC-39860-37 | •••-••-4373 | 810-219-8850 | — | 4682 Washington St | Orlando | FL | 32825 | UNKNOWN | — |
| PRV | PRV-27671 | 2026-10-09T14:57:31Z | reed | T | cheryl | Jun 12, 1984 | NULL | ·UNKNOWN | - | N/A | 984 MEADOW LANE | Nashville·· | TN | 37207 | N/A | UNKNOWN |
| PRV | PRV-27630 | 2026-08-18T19:11:34Z | ERIC | — | ROBERTSON | 2008-07-10 | UHC-01745-78 | •••-••-8515 | (218) 627-1767 | — | 3096 Union Street | Fresno | CA | 93766 | UNKNOWN | - |
| PRV | PRV-29453 | 2026-05-01T09:15:44Z | Day, Mary | — | — | 1985-11-24 | - | — | (473) 297-6946 | null | 4022 CHURCH STREET | HOUSTON | TX | 77096 | — | - |
| PRV | PRV-22872 | 2026-05-16T14:58:40Z | Grace | S. | Harper | 1981-06-12 | UHC-75926-22 | — | ·798-978-4285 | N/A | 6965 Sunset Blvd | Mesa | AZ | 85251 | NULL | MEDICARE-ADV-A |
| PRV | PRV-24162 | 2026-03-12T06:30:53Z | danielle | G | carroll | 1992-03-01 | UHC-70974-77 | — | (517) 964-8732 | danielle.carroll82@proton.me | 1954 MAPLE AVE | ·Gilbert | AZ | 85256-1883 | — | N/A |
| PRV | PRV-22338 | 2026-10-01T04:57:25Z | Heen | — | Anderson·· | 12/21/1998 | - | — | (756) 317-4037 | N/A | — | — | NULL | - | — | N/A |
| PRV | PRV-21941 | 2026-03-15T20:16:33Z | lori | Q. | lane | 2006-03-28 | UHC-27982-32 | — | +1 830 459 7042 | ·· | 5174 CHURCH ST Apt 34 | Atlanta | GA | 30392 | UNKNOWN | - |
| PRV | PRV-22480 | 2026-06-12T13:30:45Z | William | — | Haarvey | 28-01-1943 | — | •••-••-3475 | 15076532477 | NULL | 6888 MEADOW LANE | Atlanta | GA | 30301 | NULL | MEDICARE-ADV-A |
| PRV | PRV-24526 | 2026-05-15T09:12:56Z | zachary | — | jacobs | 10/07/64·· | UHC-67727-99 | UNKNOWN | 4046392478 | - | 5070 JEFFERSON AVE | Las Vegas | Nevada | ·89157 | — | NAVIGATE-HMO |
| PRV | PRV-26000 | 2026-01-13T16:48:45Z | Beverly | — | Baker | Aug 8, 1997 | UHC-69779-08 | •••-••-2925 | null | — | 5700 Maple Ave | Atlanta | GA | 30347 | NULL | N/A |
| PRV | PRV-21117 | 2026-06-01T20:51:51Z | LUCIA | — | ADAMS | 19590801 | UHC-55025-65 | •••-••-0491 | UNKNOWN | NULL | 9384 Broadway | Fresno | CA | 93769 | NULL | N/A |
| PRV | PRV-23091 | 2026-10-10T13:17:18Z | Ahmed | — | Jacobs | 07-06-1982 | UHC-99057-32 | NULL | 902-657-2813 | — | 1326 Lincoln Way | Plano | TX | 75070 | - | — |
| PRV | PRV-26659 | 2026-05-21T21:14:48Z | Susan | — | Richards | 1983-02-21 | UHC-61678-33 | NULL | 9686807594 | null | 7732 Mountain View Drive | Tempe | Arizona | 85246 | ·null | N/A·· |
| PRV | PRV-29081 | 2026-03-09T08:14:57Z | janet | ·· | lewis | 19701007 | - | UNKNOWN | (616) 462-4999 | janet.lewis@outlook.com | ·3583 River Rd | PHOENIX | AZ | 85055 | — | N/A |
| PRV | PRV-29282 | 2026-09-15T22:53:33Z | Denise | — | Robertson | ·1947-09-05 | UHC-42523-92 | •••-••-7845 | 806-874-4904 | — | 6834 Market St | Tucson | AZ | 85763 | null | UNKNOWN |
| PRV | PRV-20015 | 2026-08-05T02:23:49Z | KYLE | J | WATSON | 19-02-1957 | UHC-64229-19 | •••-••-1156 | 489-907-9543 | ·UNKNOWN | 1571 Broadway | Phoenix | AZ | 85034 | N/A | — |
| PRV | PRV-24973 | 2026-03-30T11:05:10Z | ANTHONY | ···· | JACKSON | 1996-11-11·· | ···· | — | 7084971104 | UNKNOWN | 7175 MESA DR | Dallas | TX | 75263 | - | ·NULL |
| PRV | PRV-24480 | 2026-08-23T00:12:17Z | Betty | ·W | Romero | 1970-01-02 | UHC-86415-53 | UNKNOWN | 15552874995 | NULL·· | 5730 UNION STREET #903 | Tucson | ·AZ | 85777 | - | — |
| PRV | PRV-24377 | 2026-01-29T18:26:45Z | kathryn·· | — | gonzalez | 1988-08-13 | null·· | •••-••-4524 | 6019982729 | kathryn.gonzalez79@outlook.com | 4472 Main St | Minneapolis | Minnesota | 55483 | — | — |
| PRV | PRV-26322 | 2026-01-07T05:15:19Z | maria | — | delgado | 1996-06-14 | - | — | 246-591-3779 | null·· | 9693 Highland Ave Apt 24 | Nashville | Tennessee | 37285-5522 | UNKNOWN | — |
| PRV | PRV-26373 | 2026-02-09T12:53:23Z | MARILYN | — | HAWKINS | 08/22/02 | UHC-70032-40 | — | 6467135533 | N/A | 7537 Pine Dr | Tempe | AZ | 85255 | null | null |
| PRV | PRV-24167 | 2026-01-13T23:21:02Z | Betty | — | Pena | 1953-10-03 | UHC-15755-28 | ·NULL | 588-666-3083 | — | 8194 Maple Ave | Nashville | TN | 37272 | - | - |
| PRV | PRV-21375 | 2026-10-11T19:23:42Z | LISA | ·· | JIMENEZ | 1985-04-16·· | uhc-89522-53 | NULL | 4492953475 | LISA.JIMENEZ76@AOL.COM | 8398 Indian School Road | Los Angeles | California | 90009 | — | NULL |
| PRV | PRV-24085 | 2026-02-22T22:25:55Z | Sims, Philip | — | — | UNKNOWN | UHC-24004-33·· | •••-••-8051 | (663) 409-0106 | UNKNOWN | 2558 BASELINE ROAD | Atlanta | GA | 30348 | — | - |
| PRV | PRV-28629 | 2026-02-24T20:07:29Z | LINDA | — | LE | 2006-02-15 | — | — | — | — | 9480 Hillcrest Rd | San Diego | CA | 92178 | N/A | 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:43:00.553Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty