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-24380 | 2026-01-14T03:45:27Z | Dennis | — | Dunn | 1984-08-27 | UHC-10436-45 | — | 2045820357 | DENNIS.DUNN@HOTMAIL.COM | 8612 CENTRAL AVE | ·FRESNO | CA | 93783-6804 | -·· | — |
| PRV | PRV-25999 | 2026-06-08T19:41:50Z | ·EMMA | H | PENA | 2006-12-15 | UHC-89588-48 | — | 213-547-7737 | — | 1716 Sunset Boulevard | Austin | TX | 78701 | UNKNOWN | — |
| PRV | PRV-25715 | 2026-10-11T04:07:52Z | ANN | — | KENNEDY | 1955-04-17 | UHC-55225-29 | •••-••-8320 | null | ·ANN.KENNEDY39@YAHOO.COM | 5760 Cedar Ln | Chandler | AZ | 85261 | N/A | — |
| PRV | PRV-21056 | 2026-01-09T14:09:05Z | michelle·· | — | hamilton | 1990-01-02 | - | UNKNOWN | (461) 836-3358·· | MICHELLE.HAMILTON@YAHOO.COM | 7834 GRAND AVENUE | AUSTIN | Texas | 78772 | — | — |
| PRV | PRV-22713 | 2026-04-19T10:02:36Z | — | W | — | ·09/04/97 | UHC-42544-68·· | - | 7053117743 | null | 2246 Broadway Apt 10 | San Diego | CA | 92126 | null | MEDICARE-ADV-B |
| PRV | PRV-27752 | 2026-08-11T15:42:40Z | Ruth | K | Collins | Feb 6, 1938 | UHC-81446-80 | N/A | 430-604-6951 | UNKNOWN | 4725 Harbor Boulevard | Charlotte | NC | 28279 | UNKNOWN | — |
| PRV | PRV-25362 | 2026-09-12T05:14:25Z | KAYLA | ···· | PEREZ | Dec 11, 1964 | — | — | 3612084240 | N/A | — | — | N/A | UNKNOWN | — | CORE-HMO |
| PRV | PRV-26904 | 2026-05-01T20:39:28Z | Henderson, Elijah | T. | — | 17-02-1980 | UHC-24951-39 | - | 220.578.4083 | - | 8438 Camelback Rd | Scottsdale | AZ | null | — | null |
| PRV | PRV-26602 | 2026-06-25T17:03:17Z | Jeffrey | — | Yang | 19530811 | - | - | (637) 447-0197 | - | 3040 Cedar Lane | SEATTLE | WA | 98108 | N/A | MEDICARE-ADV-B |
| PRV | PRV-26673 | 2026-09-18T10:43:10Z | Jonathan | — | Garrett | 1961-02-22·· | UHC-48138-96 | UNKNOWN | — | — | 5631 CHURCH ST | Denver | CO | 80250 | - | OPTIONS-PPO |
| PRV | PRV-20518 | 2026-07-23T11:55:19Z | arthur | N | mason | 7/11/1975·· | ·UHC-95789-74 | NULL | 337-397-4367 | NULL | 5652 Jefferson Avenue | San Antonio | TX | 78266 | — | — |
| PRV | PRV-29422 | 2026-09-11T08:05:30Z | JULIE | N | KNIGHT | 1989-05-17 | null | — | (762) 996-6026 | NULL | 9298 Lake View Road | Tucson | AZ | 85745 | null | ···· |
| PRV | PRV-21501 | 2026-01-12T13:26:01Z | BILLY | — | MORGAN | 10/28/77 | UHC-03233-84 | •••-••-7679 | 847-818-2485 | - | 2010 UNION STREET #989 | Denver | CO | 80224 | — | — |
| PRV | PRV-28121 | 2026-10-01T11:58:45Z | Barnes, Barbara | Z | — | 09/12/06 | - | NULL | 488-365-6405 | null | UNKNOWN | -·· | — | — | ·N/A | NULL |
| PRV | PRV-23328 | 2026-08-26T19:34:59Z | Barbara | ···· | Pena | 2005-02-23 | ·· | — | 4433485397 | null | 2978 Church Street | Atlanta | ga | - | ···· | — |
| PRV | PRV-26993 | 2026-01-28T10:48:20Z | Timothy | — | Bradley | ·1982-01-14 | UHC-38160-44·· | null | 806-890-0272 | N/A | 4594 BASELINE ROAD | Nashville | TN·· | 37285 | — | null |
| PRV | PRV-27775 | 2026-06-05T17:27:13Z | Megan | — | Pena | 1972-03-24 | N/A | - | ·3896438845 | megan.pena83@aol.com | 5555 River Rd | NASHVILLE | Tennessee | 37285 | — | SELECT-EPO·· |
| PRV | PRV-26913 | 2026-05-10T23:16:53Z | Laauren | — | Sandoval | 08/17/55 | UHC-88391-59 | UNKNOWN | — | - | 3650 Willow Ct | Tucson | AZ | 85701 | — | UNKNOWN |
| PRV | PRV-27334 | 2026-02-24T10:30:05Z | Lucia | — | Butler·· | 1979-05-26 | UHC-92207-77 | •••-••-6513 | N/A | — | 6114 GRAND AVE | Miami | FL | 33134 | ···· | — |
| PRV | PRV-26515 | 2026-08-26T01:16:45Z | JANET | — | TRAN | 1986-08-20 | UHC-03218-96 | •••-••-6917 | +1 670 901 7122 | null | 2658 Broadway | Phoenix | Arizona | 85018 | — | ·null |
| PRV | PRV-22739 | 2026-04-13T15:26:30Z | Anthony | — | Fisher | 1938-01-15 | — | - | NULL | ANTHONY.FISHER58@PROTON.ME | 264 River Rd | Orlando | FL | 32812 | ·· | — |
| PRV | PRV-23290 | 2026-08-18T10:17:40Z | Kelly | F | Wheeler | 1975-11-17 | UHC-91238-92 | ···· | 957-987-2902 | - | 4067 Washington St | Orlando | Florida·· | 32855 | — | — |
| PRV | PRV-27237 | 2026-06-15T08:59:14Z | mason | X | garrett | 13-05-1942 | UHC-21265-20 | •••-••-3589 | 538.403.3079 | ···· | 2814 Desert Sky Blvd·· | Tucson | AZ | 85751 | N/A·· | MEDICARE-ADV-B |
| PRV | PRV-22691 | 2026-06-08T03:13:27Z | barbara | — | ruiz | 3/19/1942 | UHC-93786-89 | •••-••-7746 | 7198183359 | — | 8554 Ridge Road | Tampa | FL | 33608·· | NULL | null |
| PRV | PRV-24257 | 2026-09-16T04:27:51Z | Mariana | — | Walker | 1961-05-06 | NULL | — | (700) 969-0386 | mariana.walker74@outlook.com | 9604 River Rd | Charlotte | NC | 28243-6525 | UNKNOWN | — |
| PRV | PRV-21112 | 2026-04-03T07:39:02Z | Kenneth | — | Tucker | 04/12/1947 | UHC4828643 | — | 2384297613 | kenneth.tucker@aol.com | 1345 Meadow Ln | GILBERT | AZ | 85250 | - | — |
| PRV | PRV-21226 | 2026-01-04T17:18:38Z | Daniel | S | Fuller | 1953-01-25 | UHC-71153-24 | UNKNOWN | (882) 893-2349 | daniel.fuller@aol.com | 5148 Mesa Drive | Austin | TX | 78756 | - | — |
| PRV | PRV-23789 | 2026-08-19T19:41:48Z | MARY | — | ROBINSON | 2006-01-16 | — | — | (764) 326-7621 | UNKNOWN | 7941 Valley View Drive | Mesa | AZ | null | — | MEDICARE-ADV-B |
| PRV | PRV-28849 | 2026-02-03T03:45:28Z | Omar | C. | — | 1943-10-14 | — | — | 9567178918 | ···· | 1000 WASHINGTON STREET | Dallas | TX | 75247 | ·· | N/A |
| PRV | PRV-29378 | 2026-07-01T10:29:29Z | ·jack | — | yang | 1992-01-27·· | N/A | ·null | (435) 985-4255 | — | 1847 Central Avenue | Gilbert | az | N/A·· | - | N/A |
| PRV | PRV-25431 | 2026-07-23T13:29:59Z | Pamela | ·· | Bryant | 1960-03-17 | UNKNOWN | - | 615-928-9513 | PAMELA.BRYANT78@YAHOO.COM | ·609 Lake View Rd | Los Angeles·· | CA | 90019-8576 | N/A | — |
| PRV | PRV-26340 | 2026-08-02T17:47:22Z | annna | — | greene | 1986-02-14 | UHC-19124-93 | — | (987) 521-7391 | anna.greene20@yahoo.com | 9359 Lake View Road | Denver | ·CO | 80222 | NULL | - |
| PRV | PRV-25936 | 2026-04-04T06:40:08Z | Christina | S | Butler | 03/13/45 | ·UHC-65441-35 | — | 359-257-6327 | ···· | ···· | — | UNKNOWN | N/A | — | MEDICARE-ADV-B |
| PRV | PRV-22011 | 2026-03-14T22:05:11Z | Maria | — | ·Danniels | 2002-09-14 | UHC-62018-03 | N/A | null | ·· | 5348 Market Street | San Antonio | TX | ·78228 | — | — |
| PRV | PRV-21923 | 2026-01-16T00:49:44Z | JEMES | — | GORDON | 1988-04-11 | — | UNKNOWN | 222-401-0374 | — | 9822 Highland Ave | Tempe | AZ | 85243 | N/A | — |
| PRV | PRV-22582 | 2026-08-25T19:35:10Z | Vincent | — | Gordon | 1973-01-03 | N/A | — | 255.816.9267 | N/A | 1710 Central Ave #773 | Miami | FL | 33190 | N/A | SELECT-EPO |
| PRV | PRV-26117 | 2026-04-14T03:27:05Z | Roger | — | Carr·· | ·04-11-1985 | - | NULL | 825-355-1950 | roger.carr2@outlook.com | 5490 Sunset Blvd | Mesa | Arizona | 85209 | — | — |
| PRV | PRV-25520 | 2026-01-27T13:25:04Z | DOUGLAS | — | DAY | 08/13/46 | N/A | UNKNOWN | 555-394-7248 | ·· | 3209 Washington St | Orlando | FL | 32814 | ·null | — |
| PRV | PRV-21691 | 2026-04-11T00:12:41Z | nathan | K. | moore | 2000-08-01 | UHC-49058-08 | — | ·· | nathan.moore@hotmail.com | 2651 Central Avenue·· | Eden Prairie | MN | 55339 | UNKNOWN | N/A |
| PRV | PRV-28030 | 2026-03-04T14:49:51Z | Kim | A | Baker | 1987-10-13 | UHC-95208-72 | — | 4827714425 | kimberly.baker27@icloud.com | 6304 Camelback Rd | Seattle | Washington | — | — | N/A |
| PRV | PRV-23106 | 2026-03-08T21:50:27Z | Diane | B | Henderson | 19461220 | UHC-09074-03 | UNKNOWN | 394.260.1676 | null | 6357 Oak St Apt 24 | PHOENIX | AZ | 85000 | ·NULL | null |
| PRV | PRV-28790 | 2026-08-30T02:18:57Z | BILLY | — | ADAMS | 2006-06-17 | UHC-87978-84 | NULL | 862-978-6626 | UNKNOWN | 3663 MOUNTAIN VIEW DR | ·Charlotte | NC | 28274 | — | CORE-HMO |
| PRV | PRV-26277 | 2026-04-07T08:57:48Z | GABRIEL | — | SHAW | 1975-05-15 | UHC-14473-31 | - | 466.757.9911 | gabriel.shaw54@gmail.com | — | ·· | — | null | - | — |
| PRV | PRV-24250 | 2026-01-09T01:45:17Z | Tim | — | Sims | 9/12/2008 | UHC-24501-74 | - | 862-709-0425 | TIMOTHY.SIMS4@HOTMAIL.COM | 3299 River Road | Las Vegas | nv | 89134 | - | ···· |
| PRV | PRV-24664 | 2026-06-18T13:50:30Z | Eric | — | Bell | Oct 3, 1943 | UNKNOWN | — | 734-973-8013 | N/A | 6105 Bayshore Dr | Denver | Colorado·· | 80258 | null | OPTIONS-PPO |
| PRV | PRV-20932 | 2026-08-10T17:12:47Z | Teresa | — | Wang | 1980-01-09 | — | •••-••-3572 | UNKNOWN | - | 1451 Spring St | Los Angeles | CA | 90051 | NULL | UNKNOWN |
| PRV | PRV-20376 | 2026-02-03T18:02:54Z | Denise | — | Walker | 1955-11-04 | UHC-80410-94 | ···· | (229) 816-7821 | denise.walker93@aol.com | 8205 Baseline Road | Jacksonville | FL | ·32273-8833 | null | ·medicare-adv-b |
| PRV | PRV-25332 | 2026-09-03T01:44:17Z | dylan | — | watkins | 02/07/1957 | UHC-98153-10 | - | ·626-329-7888 | - | 7577 HIGHLAND AVENUE | Glendale | AZ | 85378-8494 | UNKNOWN | N/A |
| PRV | PRV-27711 | 2026-03-04T12:14:08Z | KELLY | ···· | CARLSON | 0703-18-90 | NULL | •••-••-2736 | (560) 947-6747 | UNKNOWN | 4379 Palm Drive Apt 19 | Jacksonville | ·FL | 32281 | — | medicare-adv-b |
| PRV | PRV-22502 | 2026-02-18T22:54:00Z | Wang, Maria | — | — | 1976-04-07 | UHC0126947 | null | null | MARIA.WANG35@YAHOO.COM | 6033 Mesa Dr | Phoenix | AZ | 85004 | N/A | — |
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:38.494Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty