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-25550 | 2026-02-14T21:00:14Z | ROBERT | — | RUSSELL | 1983-09-05 | null | NULL | (250) 366-5877 | — | 9166 PINE DRIVE | San Diego | CA | N/A | NULL | NULL |
| PRV | PRV-22729 | 2026-09-07T16:31:59Z | jordan | — | baker | 1991-11-22 | UHC-78101-68·· | — | 8214934284 | — | 4551 Broadway | Tucson | AZ | 85779 | — | NULL |
| PRV | PRV-22720 | 2026-04-16T15:31:22Z | SCOTT·· | — | JOHNSTON | 06/01/91 | ·UHC-09585-03 | - | 15782113159 | — | 8261 Pine Drive | San Diego·· | CA | ·92181 | — | UNKNOWN |
| PRV | PRV-21334 | 2026-02-01T13:45:03Z | ARJUN | — | AUSTIN | 1962-11-21 | — | - | 7974787148 | N/A | 1298 Union St | Charlotte | ·NC | 28274 | — | NULL |
| PRV | PRV-20756 | 2026-09-11T02:29:16Z | SOFIA | B | LI | Dec 18, 1948 | — | — | ·321-358-5049 | NULL·· | 1674 RIDGE RD | Jacksonville | FL | 32294 | — | UNKNOWN |
| PRV | PRV-21954 | 2026-06-16T00:25:50Z | Rodriguez, Raymond | — | ···· | 1980-09-11 | — | - | 7043124628 | - | 6125 Meadow Ln Apt 11 | Denver | CO | 80288·· | UNKNOWN·· | null |
| PRV | PRV-28863 | 2026-04-26T10:42:59Z | ·LAUREN | D.·· | BARNES | 1993-09-09 | — | null | 567.244.4736·· | — | 9543 Union St | DENVER | CO | 80206 | — | — |
| PRV | PRV-23816 | 2026-07-16T11:40:22Z | Logan | — | Phillips | 19660421 | — | ···· | 460.919.6479 | ···· | 3710 MOUNTAIN VIEW DRIVE | Orlando | FL | 32851 | — | - |
| PRV | PRV-28631 | 2026-04-12T09:34:08Z | Jackson, Justin | ·· | — | 1995-01-02 | UHC-75123-32 | N/A | — | — | 4662 APACHE BLVD | Denver | co | 80254 | - | N/A |
| PRV | PRV-28212 | 2026-10-09T23:37:12Z | Shirley | T | Carr | 1938-09-16 | — | N/A | — | shirley.carr@proton.me·· | 281 Meadow Ln #541 | Fresno | CA | 93770 | — | N/A |
| PRV | PRV-22898 | 2026-01-20T10:12:35Z | aaron | — | hicks | 1974-30-26·· | UHC-68928-73 | — | — | null | 6607 Desert Sky Blvd Apt 28 | Eden Prairie | MN | ·· | — | — |
| PRV | PRV-29501 | 2026-06-24T08:49:17Z | Arjun | — | Hanson | 1962-01-24 | UHC-47578-88 | - | 628-732-6931 | — | 7609 Spring Street | Seattle | ·WA | 98109 | N/A·· | SELECT-EPO |
| PRV | PRV-28553 | 2026-02-26T05:48:32Z | Johnny | T·· | Armstrong | 19571005 | UHC-89431-35 | — | (863) 717-7539 | UNKNOWN·· | ·7191 Main St | LAS VEGAS | NV·· | 89149 | null | NULL |
| PRV | PRV-25625 | 2026-04-17T02:58:19Z | Kevin | — | Wheeler | 04/21/46 | UHC-17930-18 | UNKNOWN | 8429192611 | null | 6231 BROADWAY | PLANO | TX | 75022 | — | — |
| PRV | PRV-22565 | 2026-06-23T16:15:55Z | WILLIE | — | WEBB·· | 9/24/2006 | UNKNOWN | •••-••-9500 | 13536897247·· | willie.webb@icloud.com | 7251 WILLOW COURT | Miami | FL | 33199 | N/A | MEDICARE-ADV-B |
| PRV | PRV-23244 | 2026-02-24T16:56:22Z | ·Morales, Tyler | M. | — | 7/2/1959 | NULL | N/A | 7264591183 | NULL | ·3280 RIDGE ROAD | Mesa·· | AZ | UNKNOWN | — | — |
| PRV | PRV-20421 | 2026-03-18T02:59:32Z | ·donald | T | johnston | 1945-11-27 | — | — | (566) 698-6636 | NULL | 942 HARBOR BLVD Apt 28 | Glendale | AZ | 85356 | NULL | options-ppo |
| PRV | PRV-26813 | 2026-01-01T07:26:39Z | Judy | — | Gordon | 11/01/70 | UHC-42219-38 | NULL | 4996647707 | UNKNOWN | 6485 Market St | San Antonio | TX | 78232 | N/A | null |
| PRV | PRV-26624 | 2026-04-25T20:59:10Z | Frank | — | Fernandez | Apr 4, 1960 | uhc-46561-13 | •••-••-5734 | 8743006582 | - | 6763 Mesa Drive | Glendale | ·AZ | 85323·· | null | — |
| PRV | PRV-20687 | 2026-10-14T08:04:58Z | Russell | U. | Jensen | 1960-08-26 | UHC-60553-97 | •••-••-9667 | 8646283416 | russell.jensen14@gmail.com | ·3170 Main Street | Scottsdale | AZ | ·85274 | UNKNOWN | UNKNOWN |
| PRV | PRV-22774 | 2026-05-19T19:57:20Z | SHARON | — | RODRIGUEZ·· | 1956-10-07 | — | — | (369) 527-0221 | null | 3427 Cedar Ln | Scottsdale | AZ | 85202 | — | — |
| PRV | PRV-28477 | 2026-03-08T06:14:04Z | henry | — | harrison | 1980-67-18 | UHC3310168·· | N/A | 3518485280 | henry.harrison44@yahoo.com | 7019 Washington St | Chandler | AZ | — | UNKNOWN | UNKNOWN |
| PRV | PRV-21608 | 2026-01-30T15:07:02Z | Martin, Brian | X. | — | 12/12/55 | — | ·- | +1 292 975 5523 | — | — | UNKNOWN | N/A | UNKNOWN | — | N/A |
| PRV | PRV-25368 | 2026-09-06T02:27:05Z | Wei | J | Peterson | 19741010 | — | — | (330) 895-1114 | wei.peterson@gmail.com | 1262 Grand Ave | Dallas | TX | 75257 | - | null |
| PRV | PRV-20046 | 2026-05-08T06:50:01Z | Mari | — | ·Davis | — | UHC-35556-52 | UNKNOWN | 5754717021 | maria.davis@gmail.com | 5103 Willow Court | ·Tempe | AZ | 85247 | - | UNKNOWN |
| PRV | PRV-21318 | 2026-03-12T02:58:01Z | Russell | ·· | Elliott | 2002-09-26·· | null | ·NULL | (763) 516-5615 | russell.elliott95@outlook.com | 8498 Camelback Road | San Diego | CA | 92156 | null | — |
| PRV | PRV-22270 | 2026-04-09T22:05:22Z | AMANDA | F | BOYD | 1939-06-26 | — | •••-••-5191 | 396-409-4126 | — | — | null | - | null | - | UNKNOWN |
| PRV | PRV-28048 | 2026-06-26T05:05:33Z | MARTHA | — | CAMPBELL | 14-12-1970 | UHC-78455-90 | •••-••-0692 | +1 417 607 7919 | martha.campbell77@yahoo.com | 3970 HARBOR BLVD | Gilbert·· | AZ | null | — | NULL |
| PRV | PRV-20086 | 2026-04-18T00:35:30Z | Peter | C | Garrett | 1981-03-11 | UHC-70030-79 | •••-••-8541 | 332-785-4244 | - | 8443 Oak St #940 | Fresno | ·CA | 93783 | UNKNOWN | — |
| PRV | PRV-23982 | 2026-10-17T04:50:31Z | Andrea | L | Wilson | 20060108 | UHC-84921-80 | — | 5248181787 | — | 4292 Pine Drive | Tempe | AZ | 85282·· | — | null |
| PRV | PRV-26257 | 2026-06-08T11:40:17Z | Nathan | ·· | Carpenter | 1954-06-10 | — | - | NULL | UNKNOWN | null | N/A | N/A | null | null | NULL |
| PRV | PRV-24922 | 2026-04-28T05:38:46Z | CHRISTOPHER | B. | STEWART | 03/11/2005 | null | UNKNOWN | — | christopher.stewart1@outlook.com | ·3758 Hillcrest Road | Minneapolis | mn | 55435·· | UNKNOWN·· | ·null |
| PRV | PRV-22831 | 2026-06-27T01:45:57Z | cheryl | — | daniels | 1974-11-24 | UHC-88831-98 | •••-••-4613 | 926-387-9492 | — | 5417 Palm Drive | Fresno | CA | 93782 | — | ···· |
| PRV | PRV-28381 | 2026-07-20T00:34:45Z | debra | — | ·rios | 1947-12-07 | — | — | N/A | debra.rios@outlook.com | 9593 Valley View Dr | San Antonio | Texas | 78244·· | NULL | SELECT-EPO |
| PRV | PRV-28770 | 2026-04-18T22:43:54Z | ·Duncan, Alexis | E | — | 1970-08-12 | null | N/A | +1 303 728 5635 | alexis.duncan96@proton.me | 9398 MAPLE AVE | Gilbert | AZ | 85284 | - | N/A |
| PRV | PRV-26334 | 2026-03-12T12:58:21Z | Ahmed | — | Perkins | 19480828 | - | — | UNKNOWN | N/A | 3105 Main St | Glendale | AZ | 85324 | ···· | N/A |
| PRV | PRV-26795 | 2026-05-23T16:54:10Z | Arthur | — | Soto | 03/10/63 | UHC-76728-29 | N/A | 5419202237 | — | 487 Maple Ave #383 | Austin | TX | 78796 | N/A | — |
| PRV | PRV-29232 | 2026-06-29T05:54:10Z | Samantha·· | R. | Thompson | 1941-01-01 | null | — | 4139936843·· | NULL·· | 2218 Indian School Rd | Austin | tx | 78713-7729 | — | - |
| PRV | PRV-28667 | 2026-04-21T23:17:43Z | Parker, Austin | ·I. | ···· | 1952-07-03 | UHC-47167-07 | - | 326-806-6971 | austin.parker6@yahoo.com | 3166 Spring Street | Miami | FL | 33123-7319 | NULL | N/A |
| PRV | PRV-21902 | 2026-04-09T17:13:07Z | Heather | I | Rose | 1982-05-02 | UHC-34695-21 | NULL·· | 7957193104·· | - | UNKNOWN | NULL | ·NULL | — | — | — |
| PRV | PRV-26725 | 2026-04-28T03:40:30Z | JULIE·· | — | BANKS | 1988-03-13 | UHC-67292-12 | UNKNOWN·· | 19616571052 | NULL | 2818 River Road | Minneapolis | MN | 55419 | UNKNOWN | — |
| PRV | PRV-21167 | 2026-07-05T20:51:05Z | Juile | — | Contreras | 1939-10-28 | NULL | - | (278) 872-4238 | - | ·7644 HILLCREST ROAD | PHOENIX·· | AZ | 85039 | N/A | null |
| PRV | PRV-24920 | 2026-07-09T12:33:51Z | Helen | V. | Mejia | 1/20/1987 | NULL | null | (960) 871-9395 | helen.mejia@gmail.com | 9445 Desert Sky Boulevard | Eden Prairie | Minnesota | 55352 | — | ·· |
| PRV | PRV-29199 | 2026-09-12T23:31:49Z | Anthony·· | — | Perkins | 1988-06-09 | UHC2913484 | N/A | (415) 688-4151 | ANTHONY.PERKINS@AOL.COM·· | 5905 Elm St | LAS VEGAS | NV | 89113 | N/A | — |
| PRV | PRV-25077 | 2026-03-31T15:29:28Z | William | F. | Foster | 22-12-2005 | - | NULL | ·478.274.2764 | — | 1191 River Rd | Columbus | OH | 43268 | N/A | NAVIGATE-HMO |
| PRV | PRV-28883 | 2026-03-09T04:04:46Z | Theresa | M | Munoz | ·Apr 6, 1962 | - | - | 893-303-9828 | theresa.munoz88@hotmail.com | 2470 CAMELBACK RD | Atlanta | GA | 30364 | — | — |
| PRV | PRV-20324 | 2026-08-21T13:24:33Z | Kelly | — | Larson | 1965-12-05 | — | NULL·· | 8229095647 | — | 3092 WASHINGTON STREET #572 | Chandler | AZ | 85221 | — | MEDICARE-ADV-A |
| PRV | PRV-26203 | 2026-08-10T00:59:15Z | Jose | J | Chapman | 1947-03-16 | ·N/A | UNKNOWN | 971-326-5250·· | JOSE.CHAPMAN75@GMAIL.COM | ·3582 Pine Drive Apt 40 | Sacramento | California | NULL | N/A | — |
| PRV | PRV-20996 | 2026-09-29T01:27:30Z | Pamela | — | Fuller | 1946-11-06 | UHC-53055-98 | - | 772.895.9546 | UNKNOWN | 3164 HILLCREST ROAD | Gilbert | AZ | 85248 | null | — |
| PRV | PRV-25561 | 2026-06-16T10:41:49Z | Amanda·· | ·· | McCoy | 2002-05-06 | N/A | null | 2137106801 | — | 1066 LAKE VIEW RD | Scottsdale | AZ | 85245 | N/A | — |
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:53.097Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty