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-26093 | 2026-01-29T15:37:55Z | Zacahry | — | ·Pena | 1950-06-06 | null | - | 3799111696 | NULL | 6126 Mountain View Dr | Gilbert | AZ | 85251 | — | UNKNOWN |
| PRV | PRV-27635 | 2026-02-27T22:55:28Z | KATHRYN | ·· | ·WARREN | 1959-03-12·· | UHC-71018-94 | UNKNOWN·· | (316) 713-6460 | KATHRYN.WARREN@AOL.COM | 6289 Jefferson Ave·· | LOS ANGELES | CA | 90013 | — | — |
| PRV | PRV-26164 | 2026-04-21T14:57:51Z | Ana | — | Gordon | 1985-02-13·· | ·N/A | UNKNOWN | (713) 469-9142 | — | 4498 WASHINGTON STREET | Columbus | OH | 43210 | NULL | - |
| PRV | PRV-28338 | 2026-09-01T08:13:57Z | elijah | Z. | le | 1964-09-23 | UHC9517348 | •••-••-5435 | N/A | NULL | 9800 ELM STREET | FRESNO | CA·· | 93709 | — | - |
| PRV | PRV-24164 | 2026-09-19T04:09:48Z | RONAD | — | VALDEZ | 1995-11-13 | N/A | — | 670-908-5317 | null | 1195 JEFFERSON AVENUE·· | Nashville | TN | 37231 | — | ·SELECT-EPO |
| PRV | PRV-21801 | 2026-02-08T08:21:02Z | HELEN | ···· | GRAY | 7/3/1978 | UHC-92539-10 | — | (521) 400-4681 | HELEN.GRAY84@AOL.COM | NULL | null | UNKNOWN | null | -·· | null |
| PRV | PRV-20179 | 2026-07-22T08:42:17Z | Daniel | U | Cox·· | 1941-11-23 | UHC-76175-44 | null·· | (961) 647-6289 | daniel.cox@proton.me | ·7426 River Rd Apt 11 | DALLAS | TX | 75215 | N/A | - |
| PRV | PRV-20964 | 2026-04-02T16:22:37Z | JULIA | — | DEAN | 1959-11-20 | UHC-46436-46 | UNKNOWN | 498-414-6658 | — | 6505 HIGHLAND AVENUE | Jacksonville | FL | ·32273 | — | null |
| PRV | PRV-23363 | 2026-07-16T20:50:22Z | Coper, Melissa | — | — | May 15, 1938 | UHC-12129-19 | •••-••-2092 | (888) 535-5416·· | null | 2787 Broadway | Denver | CO | 80277 | NULL | NULL |
| PRV | PRV-28414 | 2026-07-13T15:21:08Z | REBECCA | — | ESTRADA | 03-01-1998 | UHC-94735-59 | •••-••-8069 | +1 898 388 5406 | — | 9541 Jefferson Ave | Atlanta | GA | 30310 | — | core-hmo |
| PRV | PRV-28803 | 2026-08-06T01:51:59Z | Freeman, Donald | — | ···· | 2/17/1947 | UHC-62334-11 | NULL | ·(600) 434-2609 | null | 1080 Palm Dr | TUCSON | AZ | 85769·· | - | UNKNOWN |
| PRV | PRV-20802 | 2026-04-22T06:06:13Z | Brown, Alan | — | — | 2004-01-08 | uhc-69982-03 | •••-••-8397 | — | ALAN.BROWN96@AOL.COM | 740 CENTRAL AVENUE Apt 13 | PHOENIX | AZ·· | 85077 | — | ···· |
| PRV | PRV-28820 | 2026-05-20T02:31:13Z | FRANK | G. | YANG | 1954-06-13 | ·· | UNKNOWN | 6147452696 | - | 4140 Jefferson Ave | Nashville | TN | 37272 | N/A | UNKNOWN |
| PRV | PRV-25646 | 2026-04-09T06:02:13Z | Marha | — | Brooks | 1966-10-23 | UNKNOWN | NULL | 438.515.6124 | MARTHA.BROOKS@HOTMAIL.COM | - | ·N/A | UNKNOWN | — | — | MEDICARE-ADV-B |
| PRV | PRV-28326 | 2026-01-28T05:55:57Z | Shirley | A | Meyer | 1976-09-12 | NULL | NULL | 2663373260 | shirley.meyer73@gmail.com | 413 CEDAR LN | Seattle | Washington | 98187-1203 | — | OPTIONS-PPO |
| PRV | PRV-28488 | 2026-04-11T09:49:11Z | ·Logan | — | Scott | Aug 15, 1988 | UHC-34279-81 | •••-••-2048 | 505-243-4196 | NULL | ·9396 Cedar Ln | Nashville·· | TN | 37243 | ·null | UNKNOWN |
| PRV | PRV-26717 | 2026-04-26T15:42:07Z | ·ROGER | — | ORTEGA | 1939-04-19 | UHC-44775-27 | - | (562) 395-5539 | — | 9312 Market Street | Jacksonville | fl | 32210 | ···· | NAVIGATE-HMO |
| PRV | PRV-22275 | 2026-09-22T01:09:19Z | Valentina | — | Price | 04/24/04 | UNKNOWN | null | — | - | 9812 Meadow Lane #599 | Phoenix | AZ | 85032 | — | — |
| PRV | PRV-28013 | 2026-09-10T04:22:09Z | Richard | — | Graham | 1940-08-21 | UNKNOWN | •••-••-3875 | 457-219-5228 | RICHARD.GRAHAM@YAHOO.COM | 9332 Camelback Rd | Tempe | AZ | 85243 | - | ···· |
| PRV | PRV-20621 | 2026-02-06T05:39:07Z | Kayla | — | Wong | ·1966-10-13 | ···· | — | (612) 492-9138 | null | 5312 APACHE BLVD | Mesa | Arizona | null | — | OPTIONS-PPO |
| PRV | PRV-23762 | 2026-01-25T09:45:37Z | Katherine | — | Dixon | 1989-07-28 | — | — | (500) 710-3246 | — | 9088 Union St | SAN DIEGO | CA | 92189 | N/A | NULL |
| PRV | PRV-25261 | 2026-08-22T12:06:30Z | Garza, Theresa | L | — | 10/28/1942 | — | •••-••-0204 | ···· | — | 877 Cedar Lane #244 | Atlanta | GA | 30319 | — | OPTIONS-PPO |
| PRV | PRV-27593 | 2026-01-18T14:44:33Z | JESSE | ···· | FIELDS | Aug 24, 1949 | N/A | null | 3619781581·· | - | 2531 Mountain View Dr | Denver | CO | 80255 | null | CHOICE-PLUS-PPO |
| PRV | PRV-23172 | 2026-01-29T14:10:26Z | Natalie | — | Banks | 1989-04-09 | UHC-97535-49 | •••-••-7272 | ·6464522147 | — | 7508 Jefferson Avenue | Seattle | WA | 98177 | null | — |
| PRV | PRV-21451 | 2026-10-06T13:20:38Z | Wallace, Peter | — | — | 2/10/1974·· | UHC-28274-41 | •••-••-4028 | — | null | — | NULL | ·null | ···· | — | null |
| PRV | PRV-24760 | 2026-06-24T11:24:18Z | Chirstian | — | Edwards | 1977-03-19 | UHC-82513-35 | null | — | ·christian.edwards@gmail.com | — | null | N/A | N/A | - | null |
| PRV | PRV-26566 | 2026-01-03T04:23:19Z | RUTH | — | OLSON | 1960-10-19 | UHC-37143-79 | •••-••-1713 | null | RUTH.OLSON29@HOTMAIL.COM | 8833 Sage Ct | Seattle·· | WA | 98120 | — | OPTIONS-PPO |
| PRV | PRV-25898 | 2026-05-10T11:47:12Z | Lucia | — | Jenkins | 1962-08-09 | null | UNKNOWN | 251.763.6966 | — | 2112 Sunset Boulevard | Columbus | OH | 43253 | — | OPTIONS-PPO·· |
| PRV | PRV-28398 | 2026-01-24T22:07:34Z | Mariana | K | Henry | 1946-04-24 | null | NULL | 2368291588 | — | 4336 DESERT SKY BLVD | Mesa | AZ | 85237-9502 | UNKNOWN | ·UNKNOWN |
| PRV | PRV-22543 | 2026-01-27T17:17:17Z | Jenkins, Deborah | — | — | 2002-05-05 | — | •••-••-7434 | (588) 273-4313 | - | 8137 Central Ave | Houston | TX | 77004 | N/A | null |
| PRV | PRV-21128 | 2026-05-14T23:59:48Z | Hawkins, Judy | — | — | 1942-06-04 | UHC-30240-19·· | ···· | 8484872847 | JUDY.HAWKINS91@ICLOUD.COM | 1144 Washington Street | ·Houston | TX | 77089 | UNKNOWN | ···· |
| PRV | PRV-24826 | 2026-04-19T16:17:33Z | PHILIP | — | MARSHALL | 1941-02-24 | N/A | •••-••-8225 | 17685352956 | PHILIP.MARSHALL60@ICLOUD.COM·· | 3565 Broadway·· | TUCSON | AZ | 85734-6938·· | — | — |
| PRV | PRV-28627 | 2026-08-28T23:32:20Z | Day, Raymond | J | — | 07/02/1984 | - | ·· | 18372569229 | UNKNOWN | 8570 MAIN STREET | Miami | FL | 33153-4219 | - | N/A·· |
| PRV | PRV-27230 | 2026-03-01T00:02:00Z | Harper, Natalie | — | — | 1974-06-13 | UHC-41642-39 | ·NULL | NULL·· | — | 4968 Camelback Rd | Atlanta | GA | 30307·· | N/A | CHOICE-PLUS-PPO |
| PRV | PRV-27238 | 2026-10-18T17:34:39Z | Bruce | — | Munoz | Aug 13, 1993 | UHC-93815-58 | •••-••-1958 | 446.538.8925·· | - | NULL | — | — | N/A | NULL | N/A |
| PRV | PRV-28989 | 2026-10-18T17:15:29Z | Randy | — | Matthews | 1958-06-21 | UHC-30155-02 | — | NULL | ···· | 4302 JEFFERSON AVE | Miami | FL | 33187 | — | — |
| PRV | PRV-27040 | 2026-02-16T14:39:49Z | Mason | V | Rios | 1980-07-07 | UHC-58394-45 | null | 7052457259 | mason.rios@yahoo.com | 8660 Central Avenue·· | ·Houston | TX | 77095 | - | null |
| PRV | PRV-20789 | 2026-10-18T03:11:46Z | EMILY | — | ROBERTS | 2006-06-27 | N/A | — | +1 256 296 9088 | emily.roberts@hotmail.com | 2034 HILLCREST ROAD·· | ·Phoenix | az | 85017 | UNKNOWN | — |
| PRV | PRV-23768 | 2026-01-15T07:43:40Z | Weaver, Camila·· | E. | — | ·1976-10-02 | ···· | null | 15518171644 | — | 1120 Spring St | Tempe | AZ | 85298 | N/A | — |
| PRV | PRV-21707 | 2026-08-05T13:52:52Z | Hiroshi | Y | Price | 1975-01-23 | UHC-21169-37 | ···· | 14393906066 | ·hiroshi.price8@gmail.com | - | - | UNKNOWN | - | UNKNOWN | NULL |
| PRV | PRV-23039 | 2026-05-22T20:20:25Z | Gary | — | Simpson | null | UHC-25382-23 | NULL | — | gary.simpson14@gmail.com | 963 MEADOW LN | ·Nashville | TN | 37238 | UNKNOWN | N/A |
| PRV | PRV-26886 | 2026-05-06T08:25:00Z | Madisn·· | D | Kelly | 1952-05-25 | — | - | 427-800-3659 | MADISON.KELLY74@GMAIL.COM | 5238 Sage Court | ·Nashville | TN | 37275-8165 | — | ·NAVIGATE-HMO |
| PRV | PRV-27233 | 2026-08-01T08:54:29Z | Cynthia | — | Bomwan | 1956-03-14 | — | NULL | 6612601445 | cynthia.bowman32@proton.me | 5228 Market Street | SAN DIEGO | CA | 92123 | ·UNKNOWN | NULL·· |
| PRV | PRV-22427 | 2026-08-05T07:42:31Z | Ramirez, Jason | — | — | 1998-11-21 | UHC-37350-18 | - | 2276145840 | JASON.RAMIREZ@PROTON.ME | 6727 Valley View Drive | Minneapolis·· | MN | 55491 | N/A | - |
| PRV | PRV-24686 | 2026-03-07T05:07:33Z | Sara | — | ·Little | 1981-10-12 | — | UNKNOWN | 720.936.1742 | sara.little55@proton.me | 5850 JEFFERSON AVENUE | Plano | tx | 75086 | UNKNOWN | null |
| PRV | PRV-20741 | 2026-10-04T13:36:53Z | Joseph | — | Padilla | 1998-06-17·· | UHC-83928-55 | •••-••-2268 | ·(757) 924-8202 | UNKNOWN·· | 8273 Lincoln Way | ·SAN ANTONIO | TX | 78225 | null | — |
| PRV | PRV-20130 | 2026-07-18T10:05:10Z | Jseph | ·· | Silva | 1979-05-07 | uhc-84565-25 | N/A | 710-598-2586 | NULL | 2092 SPRING STREET | Mesa | AZ | 85285 | N/A | N/A |
| PRV | PRV-20568 | 2026-07-16T18:57:23Z | Sara | — | ·Holmes | 12/28/1940·· | — | NULL | (439) 437-9229 | null | 31 CEDAR LN | Fresno | CA | 93736 | — | null |
| PRV | PRV-24408 | 2026-01-17T17:04:47Z | AARON | ·· | STONE | ·1966-01-28 | null | UNKNOWN | 7802243948 | AARON.STONE@OUTLOOK.COM·· | 14 Park Place Apt 6 | Gilbert | AZ | 85205 | UNKNOWN | — |
| PRV | PRV-28129 | 2026-07-25T08:45:12Z | ·Juditth | — | Brown | 05/01/49 | UHC-78195-69 | N/A | 242-458-7884 | ···· | 4374 Pine Dr | Fresno | CA | 93704-2704 | UNKNOWN | 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:36.713Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty