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-27559 | 2026-09-12T02:20:31Z | ·Angela | — | Gonzalez | 05-02-1964 | N/A | •••-••-8334 | 2923059509 | angela.gonzalez@gmail.com | 1263 MEADOW LANE | Tempe | Arizona | 85255 | N/A | core-hmo |
| PRV | PRV-28464 | 2026-03-28T22:58:17Z | JUSTIN | — | JENSEN | 10/24/53 | N/A | •••-••-9222 | UNKNOWN | — | ·3327 RIVER RD | JACKSONVILLE | FL | 32223 | NULL | UNKNOWN |
| PRV | PRV-21307 | 2026-07-19T12:19:50Z | Susan | ·· | Perez | 1949-07-28 | UHC-63932-33 | - | 763-261-5146 | — | 4019 Sage Ct | NASHVILLE | TN | 37255-9927 | ·NULL | NAVIGATE-HMO |
| PRV | PRV-27643 | 2026-07-25T09:29:36Z | Brittany | — | Wang | 11/14/1994 | UHC-81918-66 | UNKNOWN | UNKNOWN | brittany.wang51@outlook.com | ·3355 River Road | Miami | FL | 33185-3885 | N/A | — |
| PRV | PRV-26527 | 2026-02-28T17:51:55Z | Hicks, Franecs | G | — | 1963-04-27 | null | — | 8352650587 | null | 2571 DESERT SKY BOULEVARD | Chandler·· | AZ | 85225 | ·· | NULL |
| PRV | PRV-28053 | 2026-06-05T22:24:56Z | Eric | — | Li | 19-12-1944 | UHC-57535-49 | •••-••-8112 | — | eric.li@hotmail.com | 7760 Union St | Jacksonville | FL | 32249 | — | - |
| PRV | PRV-28950 | 2026-04-28T12:43:25Z | Willie | — | Sims | 1959-05-14 | UHC-08712-31 | •••-••-1054 | 383.549.5239 | N/A | 3094 Hillcrest Road | Plano | TX | 75032 | N/A | OPTIONS-PPO |
| PRV | PRV-27044 | 2026-04-23T09:54:24Z | Angela, Banks | W | — | 1989-12-03 | UHC-53594-04 | •••-••-8186 | 729-568-8487 | ANGELA.BANKS19@GMAIL.COM | 6844 Oak Street | FRESNO·· | CA | 93778 | — | NULL·· |
| PRV | PRV-25508 | 2026-08-17T19:45:30Z | Danielle·· | P | Day | 2005-07-09 | UHC-21529-84 | — | (592) 785-9778 | ·danielle.day@outlook.com | null·· | NULL | UNKNOWN | null | — | - |
| PRV | PRV-27246 | 2026-02-10T15:47:06Z | CHARLES | P | GRIFFIN | 10/08/03 | UHC-79368-12 | UNKNOWN | (308) 584-7986 | null | 6431 Oak St | EDEN PRAIRIE | MN | 55384 | — | ·CHOICE-PLUS-PPO |
| PRV | PRV-23928 | 2026-04-16T16:52:27Z | KELYL | — | ·HART | Jan 16, 1972 | UNKNOWN | •••-••-5185 | +1 338 778 4809 | NULL | 1560 Canyon Road Apt 25 | Miami | FL | 33199 | null | — |
| PRV | PRV-22307 | 2026-03-21T23:23:43Z | Keith | — | Wallace | 03/02/1977 | — | null | N/A | keith.wallace67@aol.com | - | ·NULL | UNKNOWN | UNKNOWN | - | - |
| PRV | PRV-22232 | 2026-03-23T07:54:05Z | lura | H. | gonzales | 11-03-1955 | ·UHC-58273-59 | — | 3362313576 | laura.gonzales10@icloud.com | 2608 Washington Street | FRESNO | CA | 93729 | — | NULL |
| PRV | PRV-21931 | 2026-06-12T10:23:52Z | MARIA | Y | DEAN | ·1956-04-23 | UHC-74698-76 | — | UNKNOWN | maria.dean@gmail.com | - | — | N/A | - | NULL | UNKNOWN |
| PRV | PRV-20819 | 2026-09-22T13:54:40Z | ·DIEGO A | — | VALDEZ | 1962-04-06 | ·· | NULL | 576-845-3658 | -·· | null | UNKNOWN | null | UNKNOWN | null | — |
| PRV | PRV-27547 | 2026-02-17T20:52:57Z | ALEXANDER | — | JAMES | Aug 17, 1995 | UHC-89597-44 | null | 7732849113 | ···· | 2877 Indian School Road | Tempe | AZ | ·85221-5943 | NULL | - |
| PRV | PRV-20488 | 2026-07-03T23:34:35Z | Arjun·· | — | Brown | 1998-12-18 | — | - | 5637054767 | NULL | NULL | null | — | — | — | — |
| PRV | PRV-26089 | 2026-09-02T13:30:40Z | Jsese | — | Williamson | Oct 13, 1961 | UHC-57888-13 | — | NULL | NULL | 5866 Pine Dr | AUSTIN | ·TX | 78771 | — | UNKNOWN |
| PRV | PRV-23254 | 2026-02-17T13:40:59Z | Adam | A·· | Weaver | 1941-07-08 | null | •••-••-2369 | (210) 889-9697 | ·ADAM.WEAVER@HOTMAIL.COM | 4901 Spring St | MESA | az | 85271 | N/A | — |
| PRV | PRV-20976 | 2026-04-08T20:38:05Z | Jessica | ·· | Burns | 2007-05-20 | UHC-28147-73·· | - | — | UNKNOWN | 8189 SAGE CT Apt 7 | Seattle | WA | 98114 | — | N/A |
| PRV | PRV-24841 | 2026-02-14T15:33:49Z | DYLAN | — | WAGNER | 19590919 | null | null | (252) 870-8299 | ·· | 8950 Apache Blvd·· | Houston | TX | 77025 | ·null | UNKNOWN |
| PRV | PRV-27722 | 2026-02-27T23:27:51Z | Nelson, Judy | — | — | 02-10-1952 | — | UNKNOWN | (787) 352-5343 | judy.nelson@outlook.com | 5320 River Road | TUCSON | ·AZ | ·85710 | — | - |
| PRV | PRV-21671 | 2026-10-14T14:07:44Z | anthony | — | fox | 1958-07-09 | N/A | UNKNOWN | ·979.204.9229 | N/A | 3622 Desert Sky Boulevard | Eden Prairie | MN | null | null·· | - |
| PRV | PRV-29341 | 2026-04-27T04:11:53Z | ALEXIS | — | REED | 1955-03-05 | UHC-79076-73 | •••-••-5121 | 2516881975 | null | 5473 Canyon Road | MINNEAPOLIS | MN | ·55426 | NULL | — |
| PRV | PRV-21448 | 2026-04-11T08:49:21Z | Billy·· | X. | ·Mendez | May 15, 1959 | — | — | 7938147936 | N/A | 1872 WILLOW CT | Miami | ·Florida | 33100 | UNKNOWN | N/A |
| PRV | PRV-23654 | 2026-10-12T23:49:20Z | olivia | — | wong | 1959-01-01 | — | NULL | 19514663353 | OLIVIA.WONG45@OUTLOOK.COM | ·68 Valley View Dr | Columbus | OH | 43209 | UNKNOWN | null |
| PRV | PRV-21413 | 2026-01-22T03:10:09Z | KATHLEEN | — | WALLACE | Mar 14, 2000 | UHC-39042-54 | — | - | ·NULL | 6675 HARBOR BLVD | Los Angeles | CA | 90015 | — | — |
| PRV | PRV-26416 | 2026-05-27T18:54:48Z | Donald | — | Rojas | 1981-02-18 | - | — | (611) 892-9310 | UNKNOWN | 3130 GRAND AVENUE #896 | CHARLOTTE | North Carolina | 28277 | — | - |
| PRV | PRV-28361 | 2026-05-08T13:34:09Z | Evelyn | — | Lucas | 1955-07-07 | UHC-92805-27 | - | (258) 758-7018 | EVELYN.LUCAS@AOL.COM·· | 6833 Desert Sky Blvd | Los Angeles | California | 90010-9018 | ·null | — |
| PRV | PRV-25773 | 2026-06-24T11:23:37Z | JOOSE | L | SCHULTZ | 1998-12-25 | UHC-22544-02·· | — | NULL | UNKNOWN | 6038 OAK STREET | ORLANDO | Florida | 32885-2768 | — | — |
| PRV | PRV-29550 | 2026-07-22T12:24:03Z | Walker, Bryan | — | ·· | 1691-01-12 | UHC3665610 | •••-••-2794 | ·16824572043 | — | N/A | — | NULL | — | N/A·· | NULL |
| PRV | PRV-21883 | 2026-05-12T05:48:00Z | ANGELA | — | KING | 1998-07-19 | UHC-52357-03 | •••-••-2347 | +1 809 297 0983 | NULL | 5763 River Road | Eden Prairie | MN | 55354·· | - | - |
| PRV | PRV-29058 | 2026-04-05T16:54:08Z | CATHERINE | B. | LNE·· | 27-10-2007 | UHC-93377-92 | — | UNKNOWN | — | 3738 APACHE BLVD | Sacramento | CA | 95896 | — | null |
| PRV | PRV-27271 | 2026-06-07T20:42:24Z | Joyce | — | ·Sadners | 19440123 | UNKNOWN | - | 8209621459 | — | 9492 Ocean Avenue | San Antonio | TX | 78278 | UNKNOWN | navigate-hmo |
| PRV | PRV-26713 | 2026-01-17T06:21:36Z | Albert | — | Hughes | 20-06-1942 | UHC-56108-84 | UNKNOWN | 2625017162 | UNKNOWN | ·6509 Apache Boulevard | TUCSON | AZ | 85710 | UNKNOWN | — |
| PRV | PRV-22534 | 2026-08-16T02:39:58Z | Jerry | — | Lawsoon | 03-06-1992 | - | ·UNKNOWN | 5596205988 | - | 6696 Spring Street | Los Angeles | CA | 90010 | N/A | — |
| PRV | PRV-20293 | 2026-10-16T20:36:27Z | Carr, Sofia | ·· | — | 1950-08-08 | UHC8839263 | •••-••-6806 | (622) 473-7398 | N/A | 3946 Lincoln Way | SAN ANTONIO | TX | 78291-2694 | UNKNOWN | MEDICARE-ADV-B |
| PRV | PRV-22444 | 2026-06-18T01:36:47Z | Isabella | — | Williams | 2005-12-04 | null | NULL | (650) 541-5742 | — | 1402 Maple Avenue | Mesa | AZ | — | — | ···· |
| PRV | PRV-26835 | 2026-09-26T01:20:27Z | JONATHAN | — | GREEN | 1964-07-25·· | UHC-91476-16 | — | 12067330935 | — | ·· | — | N/A | — | — | CORE-HMO |
| PRV | PRV-23832 | 2026-10-14T22:37:12Z | Luis I | — | Rodriguez | 2003-04-28 | UHC-22104-96 | ·· | (762) 257-8773 | — | 2126 Main St | FRESNO | CA | 93734 | — | — |
| PRV | PRV-23519 | 2026-08-23T15:55:13Z | Peter | — | Gomez | Mar 7, 2006 | — | NULL | +1 854 440 6564 | N/A | 7109 APACHE BLVD | Tampa | FL | 33676 | - | CORE-HMO |
| PRV | PRV-28669 | 2026-09-25T05:20:04Z | Diane·· | — | Robinson | 02/15/89 | UHC-99457-09 | — | (544) 545-3060 | N/A | 6755 Park Pl | Atlanta | Georgia | 30379 | ·- | null |
| PRV | PRV-23681 | 2026-06-03T20:40:40Z | Stephen | — | Duncan | 01/07/1963 | — | •••-••-6863 | 845-688-8882 | ·NULL | 2845 MARKET STREET | TAMPA | FL | 33648 | — | — |
| PRV | PRV-23912 | 2026-03-20T16:03:18Z | MATTHEW | N | FOWLER | 10/15/1946 | — | NULL | 660-613-7410 | MATTHEW.FOWLER80@GMAIL.COM | 5316 Washington Street | Chandler | Arizona | 85235 | NULL | NULL·· |
| PRV | PRV-22648 | 2026-04-03T19:51:15Z | Cheryl·· | — | Dunn | 1987-12-14 | UHC-78434-31 | - | ·· | ·cheryl.dunn23@icloud.com | 6313 Highland Avenue | Eden Prairie | MN | 55363 | N/A | — |
| PRV | PRV-20504 | 2026-02-06T08:30:10Z | Schultz, Judy | — | ·· | ·11/05/1971 | UHC6891711 | — | (674) 458-3506 | null | 4311 SAGE COURT | Mesa | AZ | 85235 | ·· | ···· |
| PRV | PRV-23710 | 2026-06-02T07:19:10Z | EMMA | — | NUNEZ | 1955-05-11 | uhc-09511-67 | — | 18036530206 | — | 2707 Bayshore Dr·· | Houston | TX | 77041 | ·UNKNOWN | NULL |
| PRV | PRV-22061 | 2026-03-25T08:08:20Z | joshua·· | F | vargas | 08-10-1993 | NULL | •••-••-1902 | 575-426-4149 | NULL | 5441 Cedar Lane | Houston | TX | 77014 | — | MEDICARE-ADV-B |
| PRV | PRV-20773 | 2026-07-18T08:55:09Z | Aaron | — | Harvey | 2001-07-05 | UHC-57296-51 | — | (819) 959-9752 | — | 5852 APACHE BOULEVARD | GLENDALE | AZ | 85373 | UNKNOWN | NULL |
| PRV | PRV-25717 | 2026-05-05T20:54:22Z | VINCENT | — | REYES | 2006-10-23 | UNKNOWN | UNKNOWN | (683) 349-2357 | - | 8555 Park Pl | Plano | TX | 75016 | 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.212Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty