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-26681 | 2026-02-16T19:32:09Z | Jacqueline | — | Flores | 1974-06-19 | UHC-20775-72 | UNKNOWN | 667-684-1267 | - | 8905 WASHINGTON STREET | SAN DIEGO | CA | 92173 | N/A | — |
| PRV | PRV-24397 | 2026-07-10T12:31:26Z | ALEXANDER | D | WELCH | 01/05/86 | - | — | (766) 630-0088 | ·· | 2046 Palm Dr | FRESNO·· | CA | - | — | - |
| PRV | PRV-20327 | 2026-04-21T23:39:32Z | ·MARIA | L | LONG | 1972-11-04·· | UHC-89960-59 | NULL | (976) 337-8811 | N/A | 5897 Central Avenue | Glendale | AZ | 85322 | — | — |
| PRV | PRV-20369 | 2026-09-05T01:18:19Z | Timothy | — | Reed | ·1963-03-14 | - | UNKNOWN | 12168700023 | UNKNOWN | 6904 Lincoln Way | ·COLUMBUS | OH | 43203 | ···· | CHOICE-PLUS-PPO |
| PRV | PRV-23055 | 2026-04-10T23:11:00Z | Tyler | ·· | Russell | 1958-12-09 | UHC-38785-33 | — | - | UNKNOWN | 596 Hillcrest Road | ORLANDO | FL | 32866 | — | ·· |
| PRV | PRV-27176 | 2026-05-22T14:09:25Z | Henry | ···· | Ruiz | 1992-02-13 | UHC-11129-89 | •••-••-9162 | 918-848-7342 | null | 86 BAYSHORE DRIVE | San Antonio | TX | 78296 | — | null |
| PRV | PRV-24518 | 2026-02-27T20:07:08Z | SARA | — | SCOTT | 1958-06-18 | — | N/A | (889) 354-0383 | N/A | 9443 Broadway #751 | Tempe | AZ | 85270 | null | — |
| PRV | PRV-22285 | 2026-05-10T21:19:53Z | roger·· | — | george | 1983-01-10 | - | — | ·14533472618 | roger.george@hotmail.com | 1902 WASHINGTON ST | Atlanta | GA | 30362 | null | UNKNOWN |
| PRV | PRV-24579 | 2026-05-18T11:45:05Z | PAUL·· | C | LEWIS | 1972-03-11 | UNKNOWN | null | (683) 738-6045 | — | — | null | — | UNKNOWN | — | null |
| PRV | PRV-27854 | 2026-07-18T23:34:33Z | Kayla | P | Gumez | 2007-10-28 | null | null | (970) 521-8394 | — | 5853 Church St | Scottsdale | AZ | 85259 | N/A | ·- |
| PRV | PRV-28599 | 2026-04-26T18:41:49Z | Raymond | — | ·Richards | Oct 21, 1962 | UHC-30938-76 | — | ·(518) 384-0984 | RAYMOND.RICHARDS@AOL.COM | 4610 Union St | Charlotte | NC | 28270 | — | null |
| PRV | PRV-26231 | 2026-08-11T11:10:27Z | Alexis | — | Bwman | 5/9/2006 | UHC5566407 | •••-••-5982 | 744-220-2071 | — | 4239 RIDGE RD | Chandler | AZ | 85258 | — | - |
| PRV | PRV-28554 | 2026-09-01T20:57:20Z | Powell, Aisha | I | — | ·1963-07-22 | null | •••-••-0180 | 542-945-3518 | — | UNKNOWN | null | ···· | — | null | — |
| PRV | PRV-24352 | 2026-02-27T23:47:49Z | Long | D | Olivia·· | 15-07-1997 | UHC-29266-21 | UNKNOWN | 824.274.2158 | UNKNOWN | 1779 Jefferson Ave | Miami | ·Florida | 33125-1059 | UNKNOWN | CHOICE-PLUS-PPO |
| PRV | PRV-20858 | 2026-06-03T10:43:29Z | EMILY·· | N. | PERKIINS | ·1988-03-16 | NULL | — | (884) 590-2415 | emily.perkins98@hotmail.com | 8902 Union St | SAN ANTONIO | tx·· | 78206·· | N/A | OPTIONS-PPO |
| PRV | PRV-26488 | 2026-08-27T04:18:54Z | Gary·· | — | Hill | 03/23/55 | — | N/A·· | (489) 671-3363 | UNKNOWN | 1930 Apache Blvd | Seattle | WA | 98148 | — | NULL |
| PRV | PRV-29486 | 2026-05-29T10:57:07Z | LUCIA | J | CASTILLO | 1989-12-02 | UHC-03398-73 | — | 9647888 | — | 413 OCEAN AVE | Miami | FL | 33108·· | - | — |
| PRV | PRV-20102 | 2026-02-28T00:03:38Z | Gloria | U. | Woods | 16-09-1998 | UHC-12398-94 | N/A | (692) 972-8201 | ·null | ·6142 Jefferson Avenue | ·San Antonio | TX | 78246 | UNKNOWN | — |
| PRV | PRV-22397 | 2026-05-27T01:38:05Z | HELEN | L | AUSTIN | 2003-09-10 | UNKNOWN | NULL | (582) 819-7153 | — | 9204 RIDGE ROAD | Glendale | AZ | ·85345 | null | null |
| PRV | PRV-21502 | 2026-04-10T08:00:22Z | Richard | — | Hudson | 1974-01-08 | UNKNOWN | •••-••-9470 | 7017400006 | — | 7415 Sage Ct | Seattle | WA | 98183-4565 | — | NULL |
| PRV | PRV-27513 | 2026-06-14T11:39:42Z | ana | — | jordan | 12-10-1952 | NULL | — | 884-540-0101 | N/A | 5091 WASHINGTON ST | SEATTLE | WA | 98168 | N/A | — |
| PRV | PRV-27417 | 2026-08-29T17:22:08Z | Debra | — | Garza | 1968-12-21 | - | •••-••-5248 | ·(295) 802-2764 | ·debra.garza@proton.me | 6122 Highland Avenue | ·AUSTIN | TX | 78756-8195 | N/A | UNKNOWN |
| PRV | PRV-28802 | 2026-06-01T00:41:02Z | MEGAN | — | YOUNG·· | 1952-02-28 | UHC-39931-30 | — | (338) 280-9173 | megan.young98@outlook.com | — | — | ·· | - | - | — |
| PRV | PRV-27418 | 2026-07-23T00:23:50Z | Stepphanie | — | Rios | 1979-05-15 | null | — | — | stephanie.rios@icloud.com | 3417 FOREST AVE | NASHVILLE | Tennessee | 37207 | — | null |
| PRV | PRV-25367 | 2026-03-18T02:53:43Z | David | M | Ruiz | 1967-12-20 | UHC-51878-80 | - | — | null | 2004 Lake View Road·· | DENVER | CO | 80235-9598 | null | null |
| PRV | PRV-24921 | 2026-09-27T23:15:55Z | Helen | — | Mejia | 1987-01-20 | — | N/A | (960) 871-9395 | null | 9445 DESERT SKY BLVD | Eden Prairie | MN | 55352 | ·· | navigate-hmo |
| PRV | PRV-23999 | 2026-03-19T18:16:52Z | Ryan | — | Johnson | 9/28/1997 | — | UNKNOWN | (857) 636-1853 | null | 3038 Desert Sky Blvd | Tempe | AZ | 85210 | — | N/A |
| PRV | PRV-22950 | 2026-02-20T12:16:46Z | Robert | — | Hansen | 1939-12-07 | UNKNOWN | •••-••-3808 | (624) 834-4740 | N/A | ·9514 WASHINGTON ST | Gilbert | AZ·· | 85279 | — | — |
| PRV | PRV-29190 | 2026-08-25T07:48:23Z | Christina | ···· | Maldonado | 13-01-1968 | UHC-10398-30 | NULL | (641) 550-0800 | — | 7835 Grand Avenue | Austin | Texas | ·78763 | null | ·null |
| PRV | PRV-26284 | 2026-08-02T12:05:48Z | Hiroshi | ·Z | Pierce | 2005-12-01 | UHC-54268-51 | — | 444.461.9104 | hiroshi.pierce75@proton.me | 3552 Apache Boulevard | DENVER | CO | 80228 | — | UNKNOWN |
| PRV | PRV-27184 | 2026-03-06T13:15:19Z | HELEN | ···· | FERNANDEZ | 1942-06-16 | UHC-17523-60 | null | 19188964154 | — | 5023 Grand Avenue | ATLANTA | GA | 30344 | — | UNKNOWN·· |
| PRV | PRV-20265 | 2026-09-22T23:27:30Z | DIANA | — | ROSS·· | 1985-04-21 | NULL | UNKNOWN | 14664677953 | UNKNOWN | - | — | ·· | NULL | N/A | NULL |
| PRV | PRV-22526 | 2026-04-02T16:14:58Z | Santiago | — | Fowler | 10-12-1946 | UHC-38032-37 | null | N/A | — | 566 Broadway | Las Vegas | NV | ·89197 | null | N/A |
| PRV | PRV-25062 | 2026-09-06T12:08:54Z | Charlotte | — | ·Reid | 1997-11-10 | ···· | — | ·12822351642 | — | 8889 MAIN ST | Mesa | AZ | 85273 | UNKNOWN | NULL |
| PRV | PRV-22992 | 2026-07-26T06:37:55Z | REBECCA | ···· | HARRIS | 1995-09-15 | UHC-64318-81·· | - | -·· | - | 7103 Market Street | ATLANTA | GA | 30388 | - | — |
| PRV | PRV-20210 | 2026-05-07T05:10:47Z | Raymnod | — | Mendoza | 1943-05-14 | — | NULL | 940-441-5757 | null·· | 6759 CANYON ROAD | Columbus | OH | 43276 | — | ···· |
| PRV | PRV-28003 | 2026-09-23T12:33:30Z | Diane | — | Edwards | Apr 19, 1978 | UHC-67682-80 | NULL·· | (568) 700-4946 | DIANE.EDWARDS77@AOL.COM | — | - | — | N/A | — | — |
| PRV | PRV-28543 | 2026-07-09T12:45:26Z | Jonathan·· | — | Mendoza | 1997-01-20 | — | N/A | 16033249527 | — | 5911 MEADOW LANE #921 | DALLAS | TX | 75203 | ···· | — |
| PRV | PRV-25091 | 2026-07-08T18:04:25Z | SHIRLEY | — | GRANT | 1947-08-11 | UNKNOWN | — | 949-818-9244 | N/A | 122 Forest Ave | Scottsdale | AZ | 85240 | — | UNKNOWN |
| PRV | PRV-28824 | 2026-05-07T09:15:42Z | Zachary | — | Harvey | 1981-02-22 | UHC-43673-22 | — | 9485635188 | NULL | null | null | - | NULL | — | N/A |
| PRV | PRV-21357 | 2026-04-08T16:04:09Z | BRENDA | L | STEPHENS | Mar 2, 2000 | N/A | UNKNOWN·· | +1 876 219 6814 | UNKNOWN | 7450 Spring St | TAMPA | FL | 33658 | — | NAVIGATE-HMO |
| PRV | PRV-28761 | 2026-03-18T16:41:10Z | Charlotte | X | Ramos·· | 05/05/1996 | UHC-26786-04 | ·UNKNOWN | 871-472-7455 | — | 3625 OCEAN AVE | Denver·· | Colorado | 80249 | N/A | — |
| PRV | PRV-20994 | 2026-03-20T22:47:55Z | SUE | — | FULLER | 1956-09-15 | null | — | 654-546-9134 | N/A | 1486 MAIN ST | TAMPA | FL | 33699 | NULL | — |
| PRV | PRV-21075 | 2026-02-23T13:13:16Z | AUSTIN | — | WAGNER | ·24-09-1939 | UHC-81000-54 | — | 454-357-7614 | UNKNOWN | 372 HARBOR BOULEVARD #161 | Mesa | AZ | 85269 | — | SELECT-EPO |
| PRV | PRV-22705 | 2026-05-29T09:41:17Z | MARY | — | ROSS | ·28-03-1970 | — | N/A | N/A | mary.ross@proton.me | 7635 HARBOR BLVD | Las Vegas | NV | 89116 | ·· | CORE-HMO |
| PRV | PRV-24605 | 2026-10-17T23:48:38Z | Foster, Lri | — | ·· | ·1993-05-17 | ·· | ···· | 4796326521 | LORI.FOSTER95@AOL.COM | 8427 River Rd | Eden Prairie·· | MN | 55339 | — | UNKNOWN |
| PRV | PRV-21024 | 2026-01-29T19:00:45Z | Jackie | ·· | Fowler | 1991-02-11 | UHC-54173-12 | NULL | (890) 741-7379 | - | 9633 Central Ave | Los Angeles | CA | 90086 | N/A | N/A |
| PRV | PRV-27749 | 2026-08-10T15:10:21Z | Davis, Aaron | — | — | 9168-09-21 | UHC-45592-84 | - | 7727838164 | — | 1381 HIGHLAND AVE | San Antonio | TX | NULL | — | - |
| PRV | PRV-26908 | 2026-05-20T14:47:33Z | JACQUELINE | — | RAMIREZ | 7/9/1995 | UNKNOWN | ·· | - | N/A | ·1601 WASHINGTON STREET | Tempe | AZ | 85247 | — | null |
| PRV | PRV-25629 | 2026-10-16T14:54:47Z | Grace | — | Hall | 2000-05-09 | UHC-20965-19 | ···· | 545-696-4649 | N/A | 2262 Bayshore Drive | TEMPE | AZ | 85213 | — | 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:56.124Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty