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-26399 | 2026-02-05T10:43:54Z | Montgomery, Richard | — | — | 19740926 | UHC-73151-29 | NULL | +1 444 421 5030 | null | 5204 LINCOLN WAY | Sacramento·· | CA | 95802 | UNKNOWN | — |
| PRV | PRV-22894 | 2026-03-12T02:36:58Z | BEVERLY | — | CRAWFORD | 2006-09-16·· | UHC-83624-96 | - | null·· | — | NULL | — | null | UNKNOWN | UNKNOWN | — |
| PRV | PRV-26591 | 2026-08-24T20:23:19Z | Brittany | — | Taylor | 1947-06-20 | UHC-87089-87 | null·· | (450) 677-8727 | — | 5296 Sage Ct #765·· | GILBERT | ·AZ | 85274 | — | CHOICE-PLUS-PPO |
| PRV | PRV-26776 | 2026-06-02T05:36:26Z | DIEGO | — | TUCKER | 1968-05-21 | — | •••-••-1388 | - | diego.tucker66@gmail.com | ·6327 Elm St | Jacksonville | FL | 32278 | null | — |
| PRV | PRV-28174 | 2026-02-11T09:13:27Z | ·Benjamin | ·· | Brown | 1989-10-03 | N/A | null | (859) 841-7434 | benjamin.brown70@aol.com | 3447 Sage Ct | Denver | CO | 80241 | — | — |
| PRV | PRV-21235 | 2026-05-28T02:42:15Z | Raymond | H | Hanson | May 20, 1990 | UHC-40217-49 | •••-••-6383 | 714.391.1775 | raymond.hanson89@hotmail.com | 3321 Grand Avenue | ATLANTA | GA | 30388 | NULL | — |
| PRV | PRV-22650 | 2026-06-12T04:15:50Z | Debra | — | Bailey | 10/06/1956·· | - | - | +1 661 443 9082·· | — | 2074 Cedar Ln | Glendale | AZ | 85375 | — | CHOICE-PLUS-PPO |
| PRV | PRV-22642 | 2026-03-11T04:49:48Z | EMILY | ·· | SCOTT | 1987-08-19 | UHC-19898-07·· | •••-••-7214 | 9332972501 | emily.scott30@icloud.com | 5675 Oak St | Tampa | FL | 33610 | — | null |
| PRV | PRV-22679 | 2026-03-13T15:20:13Z | gregory·· | W | wheeler | 1989-03-15 | NULL | UNKNOWN | 9891783 | UNKNOWN | — | N/A | — | - | NULL | ·UNKNOWN |
| PRV | PRV-20073 | 2026-01-09T14:37:41Z | ·Angela | M | Bryant | 1938-04-06 | UHC-22165-57 | •••-••-3352 | N/A | ·angela.bryant@hotmail.com | 9768 Spring St·· | MESA | AZ | 85236 | NULL | — |
| PRV | PRV-24964 | 2026-05-29T09:36:01Z | danielle | — | garza | ·1978-11-07 | UHC-79202-96 | UNKNOWN | (964) 863-1091 | DANIELLE.GARZA22@GMAIL.COM | — | - | NULL | — | - | - |
| PRV | PRV-20051 | 2026-07-17T03:30:22Z | Aaron·· | ·· | Lawrence | 1961-02-02 | ·UHC-70537-90 | •••-••-1493 | 726-574-5716 | null | 7528 Apache Blvd·· | CHANDLER | AZ | 85284 | — | - |
| PRV | PRV-24466 | 2026-08-27T01:22:10Z | Peterson | ·S | Terry | 3/22/1940 | ·- | ···· | ·7826611322 | — | ·9120 Harbor Blvd | Miami | FL | 33121 | - | options-ppo |
| PRV | PRV-21201 | 2026-07-07T19:41:35Z | JULIE | M | GARZA | 1973-01-15·· | null | •••-••-7045 | (767) 569-6487 | — | 6575 Meadow Lane | Seattle | Washington | 98191 | UNKNOWN | — |
| PRV | PRV-20757 | 2026-03-10T13:18:08Z | CHRISTOPHER | Y | PERRY | 1981-12-03 | — | — | 4438076499 | N/A | 2218 APACHE BOULEVARD | ·Nashville | tn | 37233 | — | null |
| PRV | PRV-29572 | 2026-02-18T19:49:14Z | Madison | U. | Thomas | 25-05-1945 | UHC4595844 | •••-••-0713 | 385-386-3289 | madison.thomas@aol.com | 9336 Maple Avenue Apt 25 | Minneapolis | MN | 55440 | — | — |
| PRV | PRV-21938 | 2026-06-20T06:40:40Z | Sophia | — | Carroll | 23-02-1979 | UHC-64413-52 | - | (581) 638-8412 | - | 5642 DESERT SKY BLVD | Atlanta | GA·· | 30394 | NULL | UNKNOWN |
| PRV | PRV-22243 | 2026-05-08T12:50:12Z | HANNAH | — | CLARK | 1981-05-15 | NULL | null | 6819926218 | hannah.clark4@outlook.com | 2713 Jefferson Avenue | Fresno | CA | 93737 | N/A | - |
| PRV | PRV-21203 | 2026-09-13T19:46:33Z | bruce | O. | nichols | 1943-10-11 | UHC-21925-74 | UNKNOWN | 471-722-7129·· | — | 7296 Indian School Rd | San Antonio | TX | 78234 | — | ·· |
| PRV | PRV-23331 | 2026-04-09T12:12:31Z | GARY | — | KING | 05-08-1974 | UHC-19513-90 | N/A·· | +1 453 467 1857 | — | 6406 Camelback Rd | Columbus | OH | 43211 | — | ·- |
| PRV | PRV-23625 | 2026-01-21T14:35:08Z | gregory·· | ·· | cole | 1995-09-24 | UHC-65103-91·· | - | +1 626 212 8314 | gregory.cole@proton.me | 2080 Washington Street | Austin | TX | 78714 | — | UNKNOWN |
| PRV | PRV-26819 | 2026-03-03T07:46:57Z | STEVEN | — | MALDONADO | Apr 19, 1985 | UNKNOWN | null | 867.279.6554 | steven.maldonado@yahoo.com | 1352 Desert Sky Blvd | Minneapolis | MN | 55478 | - | — |
| PRV | PRV-24366 | 2026-01-20T18:50:58Z | DENNIS | — | MURPHY | 12-08-1962 | NULL | •••-••-9487 | ·327-289-9178 | null | 1093 Baseline Road | Plano | TX | 75094 | NULL | UNKNOWN |
| PRV | PRV-27372 | 2026-03-26T11:44:32Z | Paul | G | Luna | 05/11/74 | UHC-71549-96 | — | 9529945118 | — | 9143 UNION ST | Glendale | AZ | 85333·· | NULL | - |
| PRV | PRV-25663 | 2026-07-07T12:11:17Z | MARCUS | — | RODRIGUEZ | 19950970 | UHC-13361-97 | NULL | 2205693909·· | — | 439 Desert Sky Blvd | Dallas | Texas | 75295 | — | NULL·· |
| PRV | PRV-21837 | 2026-02-27T21:15:05Z | janice | — | ·ellis | 17-04-1972 | — | NULL | 2313540359 | janice.ellis@hotmail.com | 8233 Valley View Drive | Seattle | WA | 98153 | N/A | - |
| PRV | PRV-22778 | 2026-09-16T03:45:09Z | ·juan | — | carroll | 1941-07-09·· | UHC-56945-76 | •••-••-8704 | 563-372-6733 | juan.carroll@yahoo.com·· | 7931 Desert Sky Blvd | ·Denver | CO | 80221 | N/A | - |
| PRV | PRV-23238 | 2026-06-25T04:14:30Z | ·Justin | — | Garcia | 1993-09-18 | null | null | +1 880 809 3661 | — | 6008 CEDAR LANE | Scottsdale | AZ | 85274 | null | UNKNOWN |
| PRV | PRV-21453 | 2026-02-28T23:48:06Z | ARTHUR | — | CONTRERAS | Oct 20, 1943 | UHC-78188-71 | ·· | 333-994-8394 | arthur.contreras@icloud.com | 3294 Baseline Road Apt 34 | JACKSONVILLE | FL·· | 32277·· | N/A | UNKNOWN |
| PRV | PRV-23782 | 2026-02-15T20:00:26Z | Hannah | — | Simmons | 1981-12-04 | UHC-61478-12 | NULL | 595-791-1275 | — | NULL | NULL·· | — | NULL | - | NULL·· |
| PRV | PRV-28507 | 2026-08-16T13:28:39Z | Steven | — | Cunningham·· | 11/19/1982 | UHC7388440 | null | 542-618-0439 | — | 9570 Palm Drive | Jacksonville | Florida | 32217 | — | — |
| PRV | PRV-29124 | 2026-10-08T12:44:10Z | Betty·· | — | Stevens | 6/23/1970 | UHC-37763-62 | ·N/A | (333) 899-0718 | NULL | 9098 Desert Sky Blvd | Nashville | TN | 37258 | — | - |
| PRV | PRV-24952 | 2026-04-17T23:18:28Z | Mark | ·· | Mills | 1962-04-06 | — | - | 647-742-3538 | mark.mills89@outlook.com | 5792 Broadway | Glendale | AZ | NULL | null | - |
| PRV | PRV-25432 | 2026-10-04T04:23:20Z | OMAR | V | MOORE | Jul 6, 2004 | N/A | UNKNOWN | 259.811.2902 | OMAR.MOORE@OUTLOOK.COM | 6676 Central Avenue | Columbus | OH | 43232 | UNKNOWN | UNKNOWN |
| PRV | PRV-24488 | 2026-02-06T14:14:48Z | robert | — | knight | 11/08/74 | UHC-63802-23 | — | (769) 802-1759 | ROBERT.KNIGHT46@PROTON.ME | ·7235 Spring St | Minneapolis | MN | 55483 | — | OPTIONS-PPO |
| PRV | PRV-26113 | 2026-01-07T06:18:39Z | Hansen, Melissa | — | — | 1996-03-18 | — | UNKNOWN | — | — | 5176 Lincoln Way | LAS VEGAS | NV | 89109 | — | NULL·· |
| PRV | PRV-20248 | 2026-01-14T21:36:08Z | ·Grace | D | Rodriguez | 14-03-1994 | NULL | •••-••-3416 | — | ·grace.rodriguez@hotmail.com | 4481 Sage Court | ·San Antonio | TX | 78217 | ·N/A | null |
| PRV | PRV-23557 | 2026-05-17T20:33:54Z | Raymond | — | Moreno | 1971-05-25 | UHC-10088-57 | •••-••-0835 | (255) 394-3970 | ···· | 8655 Grand Ave | Orlando | FL | ·null | UNKNOWN | — |
| PRV | PRV-21582 | 2026-09-09T11:16:14Z | Camila | ·· | Knight·· | 12/26/77 | UHC-37268-86 | •••-••-3725 | 8666637272·· | camila.knight62@yahoo.com | UNKNOWN | -·· | N/A | - | - | null |
| PRV | PRV-20892 | 2026-04-22T04:53:42Z | Judith | — | Rivera | Apr 15, 1968 | UHC-20415-76 | — | 905-726-2201 | judith.rivera@aol.com | 5604 Ridge Road | Los Angeles | CA | 90005 | NULL | NULL |
| PRV | PRV-27992 | 2026-04-24T07:06:20Z | AMANDA | ···· | PETERS | 1971-12-05 | N/A | •••-••-2614 | +1 307 961 1652 | amanda.peters@hotmail.com | 4865 Willow Court | Phoenix | Arizona | 85031 | - | ···· |
| PRV | PRV-28506 | 2026-10-16T02:41:55Z | Ana·· | ·· | Nelson | 7/6/1982 | UHC-12437-93 | - | 356-642-6135 | - | 1543 Union St | ·Sacramento | CA | 95870 | UNKNOWN | NAVIGATE-HMO |
| PRV | PRV-22784 | 2026-01-29T13:02:00Z | ELIZABETH | F. | GREENE | 1950-01-08 | null | UNKNOWN | (241) 245-8741 | - | 4344 Central Ave·· | ·Atlanta | GA | 30336 | ·· | null |
| PRV | PRV-23718 | 2026-01-25T22:38:11Z | michael | V·· | harrison | ·1963-07-09 | UHC-04868-24 | null | 957-742-6060 | michael.harrison@aol.com | 7551 Lake View Road | Los Angeles | CA | 90095 | N/A | N/A |
| PRV | PRV-25352 | 2026-09-28T01:52:26Z | linda·· | Y | lucas | 1952-03-06 | null | — | 4002711136 | linda.lucas84@icloud.com | 6009 BAYSHORE DRIVE #516 | Eden Prairie·· | MN | 55326 | — | NAVIGATE-HMO |
| PRV | PRV-22254 | 2026-09-25T12:35:12Z | Logan | R. | Burton | UNKNOWN | NULL | N/A | 352-273-1320 | logan.burton69@proton.me | 9374 Canyon Rd | Houston | TX | ·77017 | NULL | NULL·· |
| PRV | PRV-27535 | 2026-01-05T09:01:05Z | CAROL | — | STEVENS | 1965-12-10 | UHC-68436-17 | N/A | — | ·· | 8238 INDIAN SCHOOL RD | Eden Prairie | MN | 55343 | UNKNOWN | ·UNKNOWN |
| PRV | PRV-21779 | 2026-10-09T06:48:42Z | Catherine | E. | Taylor | 12/12/1965 | — | •••-••-9548 | 8284089875 | null | 7245 Hillcrest Rd | ·Chandler | AZ | 85253 | null | — |
| PRV | PRV-22267 | 2026-03-16T11:08:41Z | Dylan | J | Guerrero | 1944-04-17 | ·· | •••-••-9982 | 569-364-5022 | - | 9202 Spring Street | Las Vegas | Nevada | 89119 | - | N/A |
| PRV | PRV-20831 | 2026-09-29T09:08:15Z | Tyler | — | Crawford | 1968-08-07 | UHC-49693-64 | UNKNOWN | (725) 501-5011 | tyler.crawford56@hotmail.com | 9252 Ridge Road | Plano·· | TX | N/A | 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:43.602Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty