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-29035 | 2026-08-09T18:34:11Z | CHRISTINA | ·S | JACOBS | Jul 14, 1969 | UHC-14937-07 | NULL | ·(465) 619-6844 | christina.jacobs76@gmail.com | UNKNOWN | UNKNOWN | N/A | null | UNKNOWN | MEDICARE-ADV-A |
| PRV | PRV-20813 | 2026-06-04T12:30:48Z | MARTHA | — | SANCHEZ | 1992-08-24 | UHC3439645 | — | 7289875490 | martha.sanchez@aol.com | 3891 Camelback Rd | Seattle | WA | 98186 | NULL | NULL |
| PRV | PRV-28070 | 2026-08-26T10:00:28Z | Mendez, Donald | — | ·· | 1996-11-14 | — | — | (908) 406-5895 | NULL | 8762 Camelback Rd | Mesa | Arizona | 85270 | NULL | UNKNOWN |
| PRV | PRV-23000 | 2026-08-17T12:01:06Z | Alice | ···· | Marshall | 11/22/1988 | ·N/A | — | 6698641806 | - | 5036 Bayshore Drive | Plano·· | TX | 75009 | — | — |
| PRV | PRV-26039 | 2026-02-03T18:38:26Z | Ethan | — | Washington | 1994-11-12 | UHC-00595-54 | null·· | (603) 486-1677 | — | 1253 Elm St | ·TEMPE | AZ | 85257-7051 | — | — |
| PRV | PRV-27687 | 2026-04-12T02:27:45Z | MARTHA | — | SNYDER | 08-05-1989 | UNKNOWN | - | 7964328536 | MARTHA.SNYDER@HOTMAIL.COM | ·6526 Broadway | PLANO | TX | 75074 | — | UNKNOWN |
| PRV | PRV-25803 | 2026-05-31T17:58:50Z | Christine | — | Fuller | 1976-04-25 | UHC-04747-15 | •••-••-0807 | +1 341 745 0937 | ·N/A | 9726 Valley View Dr | GLENDALE | Arizona | 85323 | - | — |
| PRV | PRV-24413 | 2026-08-13T22:03:33Z | CYNTHIA·· | W | SANDERS | 1982-11-05 | UHC-47513-40 | •••-••-2604 | 909.617.3880 | -·· | 3725 Central Avenue | Tempe | AZ | 85213·· | — | CORE-HMO |
| PRV | PRV-29586 | 2026-03-30T17:10:37Z | Mason | — | Pyane | 1979-11-17 | UHC-28896-14 | - | ·3238353551 | — | 5013 Forest Avenue | Atlanta | GA | 30385 | null | — |
| PRV | PRV-23973 | 2026-02-15T13:51:18Z | frank | — | baker | 1990-09-08 | - | - | 774-260-1092 | ·UNKNOWN | 2429 Sage Ct | Glendale | AZ | 85307-3547 | — | - |
| PRV | PRV-20007 | 2026-09-05T17:05:38Z | NANCY | — | CAMPBELL | 1991-05-20 | ·· | ·· | 733.238.1159 | N/A | 3517 Baseline Road | JACKSONVILLE | FL | ·32266 | NULL | MEDICARE-ADV-B |
| PRV | PRV-29153 | 2026-05-20T14:17:08Z | JOSSHUA | — | GUERRERO | 19630904 | N/A | — | ·· | UNKNOWN | 7674 Baseline Road | DALLAS | TX | 75246 | - | — |
| PRV | PRV-20710 | 2026-01-28T03:05:01Z | Grace | — | Mills | 1984-07-03 | UHC-19336-64 | •••-••-3715 | 2662329785 | grace.mills@icloud.com | 1298 MAIN STREET | Tempe | Arizona | 85217 | UNKNOWN | OPTIONS-PPO |
| PRV | PRV-26021 | 2026-02-20T06:52:41Z | Beverly | ·· | Chen | 1946-04-03 | N/A | UNKNOWN | 7112394905 | beverly.chen71@aol.com | NULL | UNKNOWN | null | NULL | null | UNKNOWN |
| PRV | PRV-22544 | 2026-04-25T08:55:43Z | ·DORIS | — | — | 1939-12-09 | UHC2434103 | — | 530-289-4016 | doris.west@aol.com | 9597 Camelback Rd | Tempe | az | 85259 | — | N/A |
| PRV | PRV-25985 | 2026-01-18T12:23:35Z | rebecca | — | foster | 1972-09-20·· | UHC-85099-24 | null | 3755638106 | REBECCA.FOSTER84@ICLOUD.COM | 2598 Oak St | San Diego | ·CA | 92198 | - | NULL |
| PRV | PRV-25758 | 2026-02-18T00:38:06Z | Ethan | — | Simmons | 1947-08-08 | UHC-10103-53 | - | 927-379-2900 | NULL·· | 922 Palm Drive | TEMPE | Arizona | 85259-1290 | NULL | — |
| PRV | PRV-29249 | 2026-06-04T07:20:23Z | Douglas | — | Cruz | ·1961-04-01 | — | — | (281) 793-9656 | N/A | 9571 Baseline Rd | ·COLUMBUS | oh | 43278 | NULL | NULL |
| PRV | PRV-27039 | 2026-03-30T02:54:34Z | ·ANNA | — | CARPENTER | 7/20/1976 | UNKNOWN | UNKNOWN | 12977720124 | ANNA.CARPENTER12@ICLOUD.COM | 7255 Ridge Rd | Phoenix | Arizona | 85098 | N/A | null |
| PRV | PRV-22654 | 2026-06-07T11:32:59Z | Joan | ···· | ·Mills | 1957-12-16 | UHC-84014-04 | •••-••-5950 | N/A | UNKNOWN | 1972 Hillcrest Rd Apt 14 | Scottsdale | AZ | 85214 | - | — |
| PRV | PRV-27923 | 2026-05-16T03:39:41Z | Jacob | — | Alvarado | ·1953-02-16 | — | •••-••-1227 | +1 752 752 2087 | jacob.alvarado@yahoo.com | 8878 Ocean Avenue | Nashville | TN | 37269 | — | NULL |
| PRV | PRV-23292 | 2026-04-08T06:35:31Z | MASON | — | ·GARDNER | 1957-02-01 | UHC-03087-94 | •••-••-8562 | (513) 281-6326 | mason.gardner@proton.me | 1165 Oak Street | Tucson | AZ | 85786 | ·N/A | MEDICARE-ADV-A |
| PRV | PRV-28513 | 2026-08-10T13:58:28Z | Joshua | — | ·Stevens | 1980-10-26 | — | •••-••-8500 | (737) 328-1853 | — | 9610 Washington Street #268 | CHARLOTTE | North Carolina | 28216 | NULL | null |
| PRV | PRV-29362 | 2026-06-24T22:52:06Z | NICHOLAS | — | CUNNINGHAM | 7/18/1971·· | UHC-89997-78 | — | 9848448842 | ·- | — | NULL | NULL | ·UNKNOWN | - | - |
| PRV | PRV-25884 | 2026-01-02T01:51:45Z | Arthur | ···· | Munoz | 1956-01-04 | NULL | N/A | (523) 803-5252 | — | 4160 Sage Court | Tampa | FL | ·NULL | UNKNOWN | — |
| PRV | PRV-21659 | 2026-06-10T01:51:04Z | Roy | — | Stephens | Mar 23, 2007 | UHC-69885-63 | — | (451) 403-8073 | - | 9170 Cedar Ln | Denver | CO | 80227 | N/A | — |
| PRV | PRV-26734 | 2026-08-06T15:21:55Z | Walsh, Joseph | — | — | 1997-05-25 | UHC-54154-91 | •••-••-4505 | (229) 637-7020 | — | — | — | UNKNOWN | — | UNKNOWN | - |
| PRV | PRV-26557 | 2026-08-17T07:57:30Z | MELISSA | — | MORGAN | Sep 11, 1992 | UHC-68202-82 | •••-••-7770 | +1 850 264 6613·· | — | 7009 Harbor Blvd | Tampa | FL | 33665 | NULL | NAVIGATE-HMO |
| PRV | PRV-20961 | 2026-01-21T02:04:41Z | jeremy | — | torres | 1982-06-17·· | UHC-01486-09 | — | N/A | UNKNOWN | 8802 Jefferson Avenue | Plano | TX | 75017 | - | NAVIGATE-HMO |
| PRV | PRV-24007 | 2026-07-02T10:14:03Z | Russell | J. | Le | 1978-09-17 | UNKNOWN | null | 483-292-6556 | russell.le@yahoo.com | 5812 SPRING ST | Austin | tx | 78725 | NULL | — |
| PRV | PRV-21539 | 2026-01-29T01:57:23Z | LAWRENCE | — | ·HAMILTON | 1949-01-17 | N/A | •••-••-0559 | ·+1 366 226 8827 | lawrence.hamilton18@proton.me | ·8701 Sunset Boulevard | SACRAMENTO | California | UNKNOWN | — | - |
| PRV | PRV-27520 | 2026-03-29T10:48:20Z | Adnrea | — | Salazar | ·9156-08-17 | N/A | •••-••-7205 | 6068865263 | — | 8269 MESA DRIVE | Columbus | OH | 43270 | UNKNOWN | — |
| PRV | PRV-28407 | 2026-03-04T07:26:50Z | DOUGLAS | ···· | KELLY | 1995-05-25 | null | null | +1 964 442 4332 | ·- | 9857 Washington St | Charlotte | ·NC | 28231 | N/A | N/A |
| PRV | PRV-22016 | 2026-03-20T00:15:54Z | Spencer, Nancy | H. | — | 2008-09-06 | UHC-62462-17 | UNKNOWN | 680-376-1098 | — | ·NULL | null | NULL | - | — | null |
| PRV | PRV-20921 | 2026-05-30T08:26:40Z | FATIMA | — | SCHMIDT | 08-10-1943 | UNKNOWN | UNKNOWN | 3442240097 | fatima.schmidt@aol.com | 3998 PALM DR | DENVER | ·CO | NULL | — | - |
| PRV | PRV-22697 | 2026-09-16T15:37:04Z | Arjun | — | ·Mason | 1976-04-14 | NULL | •••-••-1179 | ·329-413-4279 | ARJUN.MASON39@GMAIL.COM | 9507 Meadow Lane | LAS VEGAS | NV | 89152 | - | NULL |
| PRV | PRV-22479 | 2026-03-20T04:08:25Z | LOGAN | — | COX | 1948-02-15 | UHC-10803-30 | NULL | - | — | 8242 Valley View Dr | ·Atlanta | GA | 30314 | NULL | — |
| PRV | PRV-24496 | 2026-08-16T22:34:44Z | judy | — | ortega | 1997-11-23 | null | — | 2342283457 | ·N/A | 2089 Camelback Road | SAN DIEGO | CA | 92136 | - | - |
| PRV | PRV-29539 | 2026-05-08T19:13:09Z | saen | — | peters | 10/05/2001 | UNKNOWN | — | 340.415.8757 | — | 4637 SAGE CT Apt 5 | Houston | TX | 77053 | ·- | MEDICARE-ADV-B |
| PRV | PRV-21817 | 2026-08-25T13:32:14Z | HENRY | — | SNYDER | 1946-09-18 | UNKNOWN | N/A | 3918930872 | henry.snyder@gmail.com | 4659 Church Street | Houston | TX | 77029 | UNKNOWN | MEDICARE-ADV-A |
| PRV | PRV-22183 | 2026-09-21T16:03:52Z | BOBBY | ···· | LEE | 1939-06-16 | — | - | 890-229-7657 | BOBBY.LEE@AOL.COM | 7975 LINCOLN WAY | Scottsdale | AZ | 85201 | N/A | NAVIGATE-HMO |
| PRV | PRV-23335 | 2026-05-14T09:00:54Z | SHIRLEY | — | JENSEN | 1957-03-15 | — | null | ·(448) 926-8805 | — | 3189 Pine Dr | Glendale | AZ | 85375 | — | — |
| PRV | PRV-24045 | 2026-05-20T17:22:05Z | ·KELLY | — | DUNCAN | 1978-09-20 | ·· | - | 686-476-4460 | kelly.duncan@hotmail.com | 9867 Oak St | Tampa | FL | 33688 | — | UNKNOWN |
| PRV | PRV-24508 | 2026-05-05T21:50:15Z | Julie | — | ·Allen | 18-07-2006 | — | NULL | +1 958 617 9676 | — | 455 INDIAN SCHOOL ROAD | Dallas | TX | 75215 | — | N/A |
| PRV | PRV-23527 | 2026-01-18T05:24:38Z | Sean | — | Fuller | 24-08-1986 | UHC-36745-76 | — | 9424263366 | — | 8628 SPRING ST | Charlotte | North Carolina | 28200 | — | ·· |
| PRV | PRV-21436 | 2026-05-09T14:14:58Z | Hciks, Natalie | — | — | 2004-09-04 | — | ···· | 16384444698 | natalie.hicks79@icloud.com | 4341 Lake View Road | Plano | TX | 75040 | NULL | ···· |
| PRV | PRV-28216 | 2026-08-06T02:14:06Z | Ahsley | — | Cook | 1970-12-27 | UHC-87838-91 | - | 256.327.7536 | NULL | 510 Valley View Drive | Glendale | AZ | 85309 | — | — |
| PRV | PRV-23358 | 2026-01-01T05:49:57Z | Andrea | — | Watkins | 08-10-1973 | UHC-03284-66 | - | 6365124595 | UNKNOWN | 6651 Hillcrest Rd | Jacksonville | FL·· | 32268 | - | UNKNOWN |
| PRV | PRV-25178 | 2026-05-30T23:57:31Z | Joyce | — | Snyder | 1961-01-07 | N/A | UNKNOWN | (678) 253-9977 | — | 7991 Meadow Ln | Glendale | AZ | 85350·· | — | — |
| PRV | PRV-26848 | 2026-04-13T00:13:37Z | Jean | — | Lawrence | 19740303 | UHC-43612-23 | •••-••-3309 | 6409951893 | N/A | 3662 Lincoln Way | GILBERT | az | 85292 | - | — |
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.693Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty