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-24694 | 2026-02-08T09:48:04Z | CAMILA | — | MARSHALL | 12/09/56·· | UHC-89742-06 | — | (334) 702-0523 | - | 6341 Baseline Rd | Phoenix | Arizona | 85066 | N/A | — |
| PRV | PRV-28662 | 2026-05-13T10:06:41Z | olivia | ···· | shaw | 19570428 | UNKNOWN | ···· | (216) 956-4424 | — | 6872 JEFFERSON AVE | Dallas | TX | 75259-2087 | N/A | N/A |
| PRV | PRV-20503 | 2026-09-09T15:32:56Z | Joan | — | Gilbert | 12/3/1953 | N/A | - | 558.814.3784 | joan.gilbert@outlook.com | 6465 Willow Ct | Glendale | AZ | 85319 | — | N/A |
| PRV | PRV-20786 | 2026-07-05T06:56:53Z | lucia | — | gonzales | Apr 17, 1955 | UHC-58807-87 | •••-••-3857 | 399-527-1271 | lucia.gonzales72@yahoo.com | 2783 Sage Court | ·San Antonio | TX | 78241 | — | N/A |
| PRV | PRV-22049 | 2026-09-30T13:23:50Z | diana | — | ·ramos | 1994-10-07 | — | •••-••-5997 | — | diana.ramos78@yahoo.com | 8705 Pine Dr | Atlanta | GA | 30335·· | N/A | null |
| PRV | PRV-28743 | 2026-06-21T01:50:31Z | Olson, Alan | — | — | 01/19/1953 | UHC-34288-51 | N/A | 4032249395 | alan.olson@outlook.com | 9036 RIDGE ROAD·· | San Antonio | TX | 78201·· | — | OPTIONS-PPO |
| PRV | PRV-23043 | 2026-05-14T00:19:46Z | Santiago | — | Perkins | 25-11-1977 | NULL | ···· | (544) 604-4503 | NULL | 6183 Apache Boulevard | Scottsdale | AZ | 85285-2915 | - | N/A |
| PRV | PRV-22752 | 2026-03-27T19:06:55Z | BETTY | — | MENDOZA | 1951-07-26 | ·UHC6558373 | - | 633-796-0987 | N/A | 9797 Valley View Dr·· | Mesa | AZ | 85231 | ·null | N/A |
| PRV | PRV-28645 | 2026-04-27T14:24:14Z | Victoria | — | Gray | 1978-09-01 | UHC-19111-25 | NULL | (525) 616-6349 | UNKNOWN | 580 SAGE COURT | Eden Prairie | ·MN | 55334 | — | - |
| PRV | PRV-27695 | 2026-07-15T16:26:03Z | Emily | — | Lucas | Mar 1, 1987 | — | — | 7220647 | null | 664 Hillcrest Road | ATLANTA | GA | 30325 | UNKNOWN | — |
| PRV | PRV-24809 | 2026-04-14T01:40:10Z | Stephen | — | Weber | 1/28/1987 | — | null·· | (687) 449-1291 | UNKNOWN | 8952 SAGE CT | CHARLOTTE | North Carolina | 28253 | UNKNOWN | OPTIONS-PPO |
| PRV | PRV-28882 | 2026-08-01T15:40:32Z | Theresa | M | Munoz | Apr 6, 1962 | UHC-44745-77 | null | 8933039828 | — | 2470 Camelback Road | Atlanta | GA | 30364 | N/A | — |
| PRV | PRV-21136 | 2026-02-15T02:50:47Z | Saumel | — | Estrada | 1976-06-12 | N/A | UNKNOWN | 212-818-9582 | ·N/A | 1665 PALM DR | Dallas | TX | 75266 | UNKNOWN | N/A |
| PRV | PRV-24369 | 2026-09-23T01:23:05Z | MASON | — | LUCAS | 1969-06-01 | UHC-82569-27 | •••-••-8721 | 4385568143 | — | 2967 Mesa Dr | CHANDLER | AZ | 85200 | null | N/A |
| PRV | PRV-22101 | 2026-08-05T13:19:31Z | ALICE | N | SPENCER | 19670301 | UHC-71190-27 | NULL | 544-212-0508 | alice.spencer46@icloud.com | 4684 Mountain View Drive | Houston | TX | 77017 | — | MEDICARE-ADV-B |
| PRV | PRV-25979 | 2026-04-06T05:40:42Z | Scott | — | Hughes | 1958-01-10 | UHC-53716-26 | null | +1 821 748 5157 | NULL | 5069 LINCOLN WAY | ·Orlando | FL | — | ·- | N/A |
| PRV | PRV-26475 | 2026-08-24T11:57:26Z | Jennifer | — | Jensn | 28-10-2001 | UHC5396293 | NULL | 292-280-0161 | NULL | 512 MAIN ST | Houston | TX | 77030 | NULL | MEDICARE-ADV-A |
| PRV | PRV-28653 | 2026-02-18T22:12:59Z | Jaes | L | Mitchell | 1940-05-27·· | UHC-22235-84 | -·· | ·468-436-0070 | NULL | 8842 Highland Avenue | ·Sacramento | CA | 95895 | NULL | OPTIONS-PPO |
| PRV | PRV-28697 | 2026-02-20T13:29:25Z | Martin, Gloria | — | — | 1989-09-15 | UHC-38570-43 | UNKNOWN | 659.673.1875 | N/A | ·6216 Canyon Rd | Miami | Florida | 33155 | UNKNOWN | null·· |
| PRV | PRV-26697 | 2026-09-23T00:18:52Z | Billy | — | Jones | 12/24/89 | — | — | - | UNKNOWN | 3396 Sunset Boulevard·· | Fresno | CA | 93741 | UNKNOWN | SELECT-EPO |
| PRV | PRV-23405 | 2026-03-29T16:44:47Z | Roy | T | Ellis | 1948-12-11 | uhc-77583-75 | •••-••-4355 | 465.664.0157 | roy.ellis@hotmail.com | 4326 CAMELBACK ROAD | Houston | TX | 77063 | null | - |
| PRV | PRV-21839 | 2026-05-24T08:15:56Z | albert | — | owens | 01-03-1942 | UHC-26507-26 | null | ···· | NULL | 367 Central Avenue | Charlotte | NC | 28236 | null | MEDICARE-ADV-B |
| PRV | PRV-24350 | 2026-02-06T16:20:50Z | Bruce·· | — | Hansen | 04/06/1995 | UHC-49101-83 | •••-••-9834 | (729) 371-6405 | BRUCE.HANSEN@AOL.COM | 3759 WILLOW COURT Apt 28 | Austin | TX | UNKNOWN | — | MEDICARE-ADV-A |
| PRV | PRV-25326 | 2026-08-01T17:36:18Z | WAYNE | — | SILVA | 2005-02-18 | — | — | 237-450-4670 | wayne.silva30@aol.com | 3386 Union St | ·Orlando | FL | 32817 | — | NULL |
| PRV | PRV-23188 | 2026-05-19T03:21:14Z | richard | X | vasquez | 1944-10-03 | UHC-80242-21 | •••-••-3810 | 7574224752 | richard.vasquez21@proton.me | - | NULL | UNKNOWN | - | — | — |
| PRV | PRV-26497 | 2026-06-23T19:30:59Z | ·Edwards, Judy | A | — | 08/01/1992 | UNKNOWN | — | NULL | NULL | 501 PALM DRIVE | Gilbert | AZ | N/A | — | — |
| PRV | PRV-24653 | 2026-01-31T16:06:25Z | Randy | — | Marshall | 2007-12-17 | — | •••-••-7046 | 15213290907 | null | 1355 Harbor Boulevard | LOS ANGELES | CA | 90048·· | null | MEDICARE-ADV-B |
| PRV | PRV-20652 | 2026-06-05T09:32:21Z | HAROLD | G | SINGH·· | ·Dec 22, 1949 | N/A·· | — | (581) 780-2635 | — | 7435 Lake View Road | San Antonio | ·Texas | 78285 | N/A | NAVIGATE-HMO |
| PRV | PRV-22467 | 2026-09-30T21:55:39Z | CAMILA | M | LUCAS | 1959-11-09 | N/A | NULL | (402) 946-0018 | N/A·· | 1620 Jefferson Avenue | DALLAS | TX | 75232 | UNKNOWN·· | — |
| PRV | PRV-28130 | 2026-10-13T08:29:46Z | melissa·· | V | ·simmons | 1993-10-05 | UHC-31521-24 | N/A | 311.471.5238 | null | 3474 Sage Court | Atlanta | Georgia | 30381 | — | NULL |
| PRV | PRV-22704 | 2026-02-01T21:29:56Z | mary | — | ross | 1970-03-28 | — | •••-••-9060 | 307-348-8670 | - | 7635 Harbor Boulevard | Las Vegas | NV | 89116 | — | — |
| PRV | PRV-20131 | 2026-05-24T19:41:10Z | Cheryl | — | Fernandez | — | UHC-81604-35 | — | 966.747.7100 | UNKNOWN | 5415 LAKE VIEW RD·· | San Diego | CA | 92152 | N/A·· | null |
| PRV | PRV-22248 | 2026-06-27T16:23:56Z | JOE | — | TURNER | 1997-09-21 | — | — | +1 611 762 4390 | -·· | 3679 Lincoln Way | Denver | Colorado | 80227 | null | N/A |
| PRV | PRV-22980 | 2026-10-05T21:05:10Z | Kelley | — | Samuel | 1960-10-20 | UHC-79157-57 | - | (576) 697-2179 | N/A | 3674 MEADOW LN | Tempe | AZ | 85209 | UNKNOWN | — |
| PRV | PRV-21666 | 2026-07-21T07:07:02Z | Danyel | — | Herrera | 1975-02-05 | UHC-83545-49 | •••-••-6370 | null | null | N/A | — | ·NULL | UNKNOWN | — | UNKNOWN |
| PRV | PRV-20292 | 2026-03-10T21:57:56Z | Catherine | — | Hoffman | 1949-01-28 | null | UNKNOWN | (474) 438-5613 | ·catherine.hoffman@aol.com | 5813 Indian School Road #831 | San Diego | ca | 92113 | N/A | NULL |
| PRV | PRV-26393 | 2026-09-02T19:49:13Z | Rodriguez, Thomas | — | ·· | 09/10/1948 | N/A | — | +1 835 645 9710 | THOMAS.RODRIGUEZ26@PROTON.ME | ·6430 Maple Avenue | Minneapolis | MN | 55497 | UNKNOWN | NULL |
| PRV | PRV-22603 | 2026-07-10T02:06:23Z | Randy | — | Hernandez | 1980-10-19 | - | •••-••-4047 | 8468546648 | UNKNOWN | 5165 GRAND AVE #565 | Denver | CO | 80243 | UNKNOWN | — |
| PRV | PRV-25295 | 2026-01-22T05:15:39Z | GLORIA | — | DEAAN | 1970-08-16 | UHC-28610-05 | NULL | 642-651-8782 | — | 7126 Meadow Ln | MIAMI | FL | 33137·· | - | NULL |
| PRV | PRV-26014 | 2026-09-21T12:58:05Z | sarah | K | adams | 20060609 | UHC5710630 | •••-••-1491 | (334) 370-1715 | SARAH.ADAMS@AOL.COM | 2699 Canyon Road | ·FRESNO | CA | 93784 | — | - |
| PRV | PRV-24185 | 2026-05-18T08:04:24Z | Douglas | — | Mendez | Aug 10, 1959 | UHC8477178 | N/A | ·3438859555 | ·- | 630 APACHE BLVD | Plano·· | TX | 75015 | null | — |
| PRV | PRV-24895 | 2026-09-22T14:54:59Z | EUGENE | — | CRAWFORD | 05/03/79 | UHC-32157-94 | — | 3296627470 | null | null | N/A | UNKNOWN | — | — | — |
| PRV | PRV-29195 | 2026-09-29T00:01:25Z | ANN | — | HOFFMAN | 2008-02-22 | UNKNOWN | - | 339.993.5016 | NULL | - | UNKNOWN | - | null | UNKNOWN | SELECT-EPO |
| PRV | PRV-28302 | 2026-08-25T21:01:34Z | JERRY | — | PERKINS | 1988-01-07 | UHC-63351-43 | •••-••-2043 | (809) 755-5262 | jerry.perkins@aol.com | 9878 Desert Sky Blvd·· | ATLANTA·· | GA | 30380·· | N/A·· | — |
| PRV | PRV-24015 | 2026-05-24T05:56:25Z | Katherine | N. | Porter | 1945-05-01 | UHC-30660-13 | ·N/A | (795) 512-1059 | -·· | 8266 Lincoln Way | Eden Prairie | Minnesota | 55386 | null | UNKNOWN |
| PRV | PRV-26829 | 2026-01-12T10:22:55Z | Alice | L·· | Marquez | 1997-08-26 | UNKNOWN | null | 7535676148 | null | 2926 Jefferson Ave #615 | Denver | CO | — | — | NULL |
| PRV | PRV-29365 | 2026-06-28T06:56:27Z | Virginia | — | Fowler | 1958-10-27 | UHC-04162-62 | •••-••-9702 | 582-884-2421 | — | 9688 UNION ST·· | Las Vegas | Nevada | 89126 | null | MEDICARE-ADV-B |
| PRV | PRV-27965 | 2026-05-21T17:30:57Z | Samuel | — | Wheeler | 12/19/1999 | UHC-26647-40 | — | (218) 395-9334 | ·NULL | 889 Cedar Lane | San Antonio | TX | 78201 | N/A | NULL |
| PRV | PRV-20360 | 2026-02-16T17:47:07Z | Santiago | P. | Anderson | Sep 27, 1990 | UHC-31051-13 | null | 13016255019 | NULL | 21 Main St | Glendale | Arizona | 85366 | - | null |
| PRV | PRV-26548 | 2026-02-17T03:32:13Z | MARIANA | — | FRANLKIN | 1954-12-15 | — | •••-••-2941 | 813.506.3873 | — | 6836 MAIN ST | Plano | Texas·· | 75019·· | NULL | 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:43:03.449Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty