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-20182 | 2026-07-21T02:31:51Z | KENNETH | — | DUNN | 03/15/50 | UHC-30577-22 | NULL | — | UNKNOWN | 345 Harbor Boulevard | Atlanta | GA | 30390-7863 | UNKNOWN | NULL |
| PRV | PRV-26193 | 2026-07-23T22:52:07Z | Omar | Z | Rios | 1997-02-17 | UHC-74123-52 | null | 684-399-4057 | UNKNOWN | 7637 Union Street | Phoenix | AZ | 85033 | - | - |
| PRV | PRV-24951 | 2026-07-19T06:48:08Z | Maria | — | Robinson·· | Jan 14, 1983 | N/A | •••-••-6650 | ·· | UNKNOWN | 4309 Sage Ct | Austin | TX | 78758 | — | UNKNOWN |
| PRV | PRV-26131 | 2026-02-21T21:09:19Z | carolyn | — | ·kennedy | 1948-08-06 | UHC-02309-97 | - | +1 539 752 8324 | NULL | 5655 MAIN STREET | Glendale | AZ·· | 85336 | null | - |
| PRV | PRV-22624 | 2026-08-19T20:16:37Z | MARTHA | — | SOTO | 12/5/1957 | null | •••-••-6502 | (501) 470-8672 | MARTHA.SOTO@OUTLOOK.COM | 2000 HARBOR BLVD | Austin | ·TX | 78700 | — | — |
| PRV | PRV-28274 | 2026-09-19T16:32:18Z | Alexander | ···· | Patel | 1985-09-23 | null·· | null | 14435563349 | — | 5375 Sunset Boulevard | Plano | TX | 75026 | N/A | NAVIGATE-HMO |
| PRV | PRV-23904 | 2026-01-02T10:11:38Z | ·Ralph | — | Miller | 1968-10-17 | — | — | 7605406 | — | 3448 Park Place | Orlando | ·FL | 32887 | N/A | — |
| PRV | PRV-27313 | 2026-06-19T11:06:20Z | Lawson, Philip | — | — | 9/26/1987 | — | •••-••-7402 | 9528017086 | philip.lawson63@yahoo.com | 5269 HILLCREST ROAD | ·PLANO | TX | 75056·· | NULL·· | UNKNOWN |
| PRV | PRV-20689 | 2026-03-16T14:16:57Z | ALEX | ···· | MUNOZ | Jul 1, 1998 | UHC-78751-46 | N/A | 4576389669 | ·· | ·- | — | N/A | null | - | N/A |
| PRV | PRV-23960 | 2026-03-20T10:16:32Z | TIM | — | DIXON | 1951-11-17 | UHC5433187 | null | 445-631-0971 | — | 1368 Ridge Road | Plano | TX | 75078-6301 | NULL | OPTIONS-PPO |
| PRV | PRV-23687 | 2026-06-28T17:10:10Z | Susan | X | Cunningham | 1972-05-03 | UHC-54309-49 | NULL | 302-895-7021 | N/A | 1351 Baseline Rd Apt 33 | GILBERT | AZ | 85266 | — | — |
| PRV | PRV-27220 | 2026-02-08T18:12:45Z | Hanson, Bryan | — | ···· | 2007-11-19·· | N/A·· | - | 5988138737 | UNKNOWN | N/A | UNKNOWN | — | N/A | NULL | N/A |
| PRV | PRV-26905 | 2026-04-11T14:59:21Z | CAROLYN | J. | MARTIN | - | N/A | - | +1 428 279 0462 | carolyn.martin98@gmail.com | 5919 Church St | Plano | TX | 75008 | — | N/A |
| PRV | PRV-26799 | 2026-01-26T18:01:24Z | ASHLEY | — | HUDSON | 1972-10-24 | - | NULL | — | ·- | 56 CENTRAL AVE | DALLAS | Texas | 75223 | UNKNOWN | OPTIONS-PPO |
| PRV | PRV-27116 | 2026-09-14T08:20:00Z | George | — | Estrada·· | 05/24/98 | N/A | UNKNOWN | 221.971.6731 | george.estrada60@gmail.com | 958 Church St | TEMPE | AZ | null | NULL | ·- |
| PRV | PRV-25023 | 2026-07-13T12:41:09Z | Santiago | ·· | Lynch | 1998-06-15 | UHC-94650-08 | •••-••-7531 | 325-317-3092 | null | 2281 River Rd | Las Vegas | NV | 89117 | NULL | ·· |
| PRV | PRV-24711 | 2026-06-15T11:47:39Z | Margaret | — | Lane | 1979-04-20 | null | - | 8725231524 | margaret.lane@icloud.com | 2784 SPRING ST | PLANO | TX | 75015 | NULL | UNKNOWN |
| PRV | PRV-26051 | 2026-08-06T14:44:04Z | Carol | — | Ortega | 1996-01-15 | UHC-51717-73 | - | 5967803069 | UNKNOWN | 5241 Central Avenue | Tampa | FL | 33612·· | - | UNKNOWN |
| PRV | PRV-27431 | 2026-08-07T06:45:38Z | DOUGLAS | — | YANG | — | uhc-45248-33 | null | UNKNOWN | UNKNOWN | 6930 LINCOLN WAY | Fresno | CA | 93790 | NULL | — |
| PRV | PRV-24375 | 2026-03-10T01:32:02Z | STEPHEN | ·· | NCIHOLS·· | 1945-05-04 | UHC-56677-05·· | UNKNOWN | 9552539607·· | null | 3615 Sunset Boulevard | Los Angeles | CA | 90038 | -·· | — |
| PRV | PRV-25390 | 2026-05-01T01:18:52Z | SEAN | — | YANG | 1966-01-27 | UNKNOWN | UNKNOWN·· | ·(844) 541-5132 | -·· | 9465 Palm Drive | San Diego | CA | 92191 | UNKNOWN | ·· |
| PRV | PRV-27406 | 2026-01-20T01:22:46Z | Mary | — | Smith | 19450709 | — | - | 2656792 | — | 1344 Apache Blvd | AUSTIN | TX | 78704 | - | — |
| PRV | PRV-26350 | 2026-02-01T14:01:59Z | Martinez, Nathan | — | — | 19440401·· | — | — | 9494443956·· | — | 2561 Bayshore Drive | Nashville | TN | 37207 | — | — |
| PRV | PRV-21532 | 2026-02-14T19:28:41Z | Kathryn | — | Garcia | 1978-03-16 | — | •••-••-3758 | 642-300-4905·· | ·null | N/A | — | UNKNOWN | N/A | NULL | NULL |
| PRV | PRV-23671 | 2026-05-22T13:42:00Z | Melissa | — | Dixon | ·16-11-1993 | uhc-54897-01 | null | 2856232365 | — | NULL | null | ·· | — | null | ·· |
| PRV | PRV-26784 | 2026-06-24T23:04:33Z | Saniago | — | Gibson | 2001-04-19 | UHC-15032-49 | •••-••-4461 | — | — | ·9582 WILLOW COURT | Houston | TX | — | - | NAVIGATE-HMO |
| PRV | PRV-27795 | 2026-08-05T13:35:53Z | Sofia | S | Soto | 02/12/64 | UHC-89751-90 | null | 576-752-5612 | UNKNOWN | 2267 Spring Street | Atlanta | GA | 30340 | NULL | ·· |
| PRV | PRV-24218 | 2026-02-28T05:47:47Z | LOGAN | — | KNIGHT | 11/19/47 | — | •••-••-8966 | N/A | LOGAN.KNIGHT@PROTON.ME | 2515 Oak Street·· | ·Miami | FL | ·NULL | UNKNOWN | UNKNOWN |
| PRV | PRV-22995 | 2026-10-03T03:06:18Z | kathy | S. | simmons | 07/17/1985 | UHC-12054-24 | — | 3328713836 | N/A | 1289 Main Street | SCOTTSDALE | az·· | 85260 | N/A | null |
| PRV | PRV-26752 | 2026-02-08T09:06:43Z | Benjamin | H·· | Brooks | 12/09/08·· | UHC-58222-55 | — | 9166617 | — | 9416 Desert Sky Boulevard Apt 17·· | San Diego | CA | 92148-5616 | N/A | SELECT-EPO |
| PRV | PRV-22393 | 2026-07-01T22:20:44Z | Ralph | S | Jacobs | 1973-08-05·· | UHC-30664-27 | ···· | 363.875.6339 | — | 164 Ocean Ave | San Diego | CA | 92168 | - | ·· |
| PRV | PRV-21102 | 2026-05-14T13:26:34Z | Heather | — | Fuller | 10/26/1938 | - | •••-••-2577 | (894) 672-2041 | heather.fuller@yahoo.com | 1004 Bayshore Dr | Mesa | AZ | 85204 | N/A | UNKNOWN·· |
| PRV | PRV-20372 | 2026-08-17T10:53:34Z | Joe | — | Crawfford | 7/8/1977 | null | - | 721.886.5740 | JOE.CRAWFORD44@GMAIL.COM | 1032 SUNSET BLVD | Denver | CO | 80218 | NULL | null |
| PRV | PRV-20500 | 2026-02-27T19:47:41Z | ABIGAIL | O. | PERKINS | 28-04-1971 | UHC-99873-07 | — | — | — | 7914 Oak St | Columbus | Ohio | 43289 | — | — |
| PRV | PRV-27698 | 2026-08-01T21:12:04Z | Helen | — | Lane | May 5, 1975 | UHC3540403 | N/A | — | ·· | 9691 Sunset Boulevard #561 | Minneapolis | MN | 55470 | — | NULL |
| PRV | PRV-27479 | 2026-05-06T23:27:09Z | Madison | — | Reyes | 19660119 | UHC-19088-31 | UNKNOWN | (917) 827-5217 | null | — | — | — | UNKNOWN | - | null |
| PRV | PRV-21239 | 2026-09-05T02:00:59Z | Roy | C | Olson | 1967-08-06 | UHC-36243-10 | — | +1 518 548 3978 | UNKNOWN | 6622 BAYSHORE DRIVE | Chandler | AZ | 85200 | N/A | SELECT-EPO·· |
| PRV | PRV-25872 | 2026-08-07T20:58:08Z | Kathryn | S. | Payne | 10-06-1963 | null | - | 718-747-2042 | kathryn.payne@proton.me | ·3681 MAIN ST | Atlanta | GA | 30317 | - | CORE-HMO |
| PRV | PRV-27814 | 2026-06-09T11:04:28Z | PAUL | — | MARSHALL | 1962-10-12 | — | UNKNOWN | 566-316-0388 | - | — | NULL | null | null | — | — |
| PRV | PRV-20454 | 2026-05-14T09:33:53Z | LAWRENCE | B | TUCKER | 1983-12-11 | - | null | (354) 304-7288 | lawrence.tucker@aol.com | 1664 VALLEY VIEW DRIVE | Plano | TX | 75024 | - | UNKNOWN |
| PRV | PRV-20026 | 2026-05-25T11:10:10Z | AMBER | — | WELLS | 1979-06-25 | NULL | UNKNOWN | 266-595-0799 | — | 4421 OCEAN AVE | Tampa | FL | 33680 | ···· | - |
| PRV | PRV-29017 | 2026-04-23T01:04:48Z | ·Kye | A. | Hunt | 1959-07-03 | - | NULL | 2033574048 | - | 9635 Highland Avenue | Denver | Colorado | 80254 | - | - |
| PRV | PRV-24289 | 2026-08-09T05:45:25Z | GARRETT | V | KATHLEEN | 1959-05-02 | UHC-55711-88 | NULL | 6927725384 | kathleen.garrett@hotmail.com | 9748 Market St | FRESNO | CA | 93748 | N/A | SELECT-EPO |
| PRV | PRV-24093 | 2026-08-18T08:49:25Z | Christian | — | Hghes | 1942-03-18 | UHC-52016-67 | NULL | 6074728764 | ·N/A | 2182 Desert Sky Boulevard | Chandler | AZ | 85237·· | — | N/A |
| PRV | PRV-22452 | 2026-10-16T22:15:28Z | Julia | — | ·Jensen | 1958-06-21 | N/A | NULL | (389) 461-8707 | ·NULL | 6824 Broadway | PHOENIX | az | 85014·· | NULL | MEDICARE-ADV-B |
| PRV | PRV-21599 | 2026-02-24T19:52:22Z | DENISE | ·· | ·DUNN | 1954-05-11 | UHC6661426 | NULL | ·379-719-7048 | denise.dunn@gmail.com | 5263 Sunset Boulevard #365 | Tempe | AZ·· | - | - | — |
| PRV | PRV-26006 | 2026-04-07T13:24:43Z | Stone, Arjun | — | — | Mar 17, 1987 | — | - | +1 657 565 5180 | arjun.stone13@gmail.com | - | - | — | - | — | — |
| PRV | PRV-27307 | 2026-04-04T04:17:22Z | Raymond | W | Tores | 10/14/1938 | NULL | •••-••-3425 | (744) 845-7649 | — | 3104 DESERT SKY BLVD | Los Angeles | CA | 90033 | NULL | — |
| PRV | PRV-23044 | 2026-05-24T07:57:33Z | Perez, Amber | — | — | 10/25/43·· | UHC-24581-99 | ·UNKNOWN | (401) 301-1768 | amber.perez85@aol.com | 6547 Union Street·· | NASHVILLE | TN·· | 37244 | null | ·null |
| PRV | PRV-23208 | 2026-10-15T22:29:28Z | Alan | — | Morgan | 02-06-1976 | UHC-68605-81 | — | 284.511.6754 | - | 9755 Elm Street | Glendale | ·Arizona | 85398 | NULL | 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:42:56.135Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty