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-23791 | 2026-06-27T01:28:09Z | Kathryn | H. | Moreno | 1988-12-02 | UHC-94649-01·· | •••-••-2182 | +1 558 759 9229 | UNKNOWN | 9188 GRAND AVENUE | Columbus | ·OH | 43239 | - | — |
| PRV | PRV-25222 | 2026-04-22T20:19:58Z | Campbell, Carolyn | — | ·· | 1950-02-15 | null | UNKNOWN | 825.597.3022 | — | 7292 BROADWAY | DENVER | CO | 80244 | null | — |
| PRV | PRV-24094 | 2026-08-15T18:25:54Z | NATALIE·· | — | COLLINS | 07/26/1957 | — | — | 4856365413 | natalie.collins95@aol.com | 8209 River Rd Apt 13 | Las Vegas | NV | 89157 | — | null |
| PRV | PRV-26239 | 2026-06-13T07:36:27Z | ·Brittany | M | Sims | 12/5/2005 | — | NULL | +1 585 961 9603 | brittany.sims@aol.com | ·8123 Harbor Boulevard | LOS ANGELES | ca | 90068-4747 | N/A | null |
| PRV | PRV-21717 | 2026-05-01T11:12:15Z | Carolyn | — | ·Lopez | 20010905 | UHC-67098-51 | — | 9315980 | — | 6186 WASHINGTON ST | Phoenix | AZ | ·85059 | UNKNOWN | NULL |
| PRV | PRV-26682 | 2026-04-11T11:09:29Z | Mateo | — | Mason | 1979-12-10 | UNKNOWN | - | 616-478-1290 | - | 8867 Forest Ave | MIAMI | FL | 33154 | UNKNOWN | - |
| PRV | PRV-26587 | 2026-02-27T19:23:38Z | Omar | — | ·Myers | 1982-12-01 | UHC-34991-32 | — | 3668509803·· | OMAR.MYERS69@PROTON.ME | 7679 Maple Ave | Orlando | FL·· | 32865 | — | UNKNOWN |
| PRV | PRV-26432 | 2026-01-02T00:38:51Z | Teresa | D | Simpson | ·1957-04-18 | uhc-58968-10 | N/A | (518) 959-1430 | null | 1259 MOUNTAIN VIEW DR | Orlando·· | FL | 32820·· | NULL | — |
| PRV | PRV-27626 | 2026-03-30T11:55:46Z | Hudson, Billy | — | — | 19960706 | — | N/A | (277) 305-1095 | — | 7901 Market Street | Chandler | AZ | 85249 | N/A | UNKNOWN |
| PRV | PRV-25697 | 2026-04-05T15:52:35Z | Judith | — | ·Herrera | 05/21/2000 | — | NULL | 15244278363 | — | 1589 Meadow Lane | Austin | TX·· | 78752 | UNKNOWN·· | N/A |
| PRV | PRV-29372 | 2026-01-17T09:32:13Z | Kevin | — | Hughes | 7/2/1944 | null | — | 2064037357·· | UNKNOWN | ·· | — | — | NULL | N/A | MEDICARE-ADV-B |
| PRV | PRV-24733 | 2026-04-03T13:31:32Z | Juan | — | Butler | Mar 8, 1952 | UHC-52359-45 | •••-••-3426 | 3565466179 | JUAN.BUTLER@AOL.COM | 4309 WILLOW CT Apt 19 | Plano | TX | 75031-6189 | — | UNKNOWN |
| PRV | PRV-25161 | 2026-04-27T04:15:42Z | Ellis, Christopher | — | — | 04/05/86 | UHC6161107 | •••-••-8219 | +1 252 259 7934 | CHRISTOPHER.ELLIS79@GMAIL.COM | 3925 Broadway | San Diego | CA | 92178 | — | SELECT-EPO |
| PRV | PRV-26288 | 2026-09-28T12:11:04Z | stephanie | — | alvarado | 1994-11-24 | - | •••-••-2016 | 921-791-9909 | stephanie.alvarado@icloud.com | 7956 CAMELBACK RD | Las Vegas | NV | 89197 | null | select-epo |
| PRV | PRV-20314 | 2026-06-18T04:46:09Z | Kenneth | — | Wong | 06/21/94 | — | •••-••-5574 | — | UNKNOWN | ·NULL | — | - | - | UNKNOWN | ·N/A |
| PRV | PRV-20410 | 2026-03-29T22:08:19Z | Ann | — | Lynch | 1985-05-23 | N/A | UNKNOWN | (337) 287-3236 | ann.lynch55@proton.me | 3431 CAMELBACK RD | EDEN PRAIRIE | MN | 55324 | N/A | ···· |
| PRV | PRV-27642 | 2026-08-30T08:36:46Z | ruth | Z | ross | 19700421 | - | NULL | 539.256.7651 | - | 3071 Canyon Road | ·Phoenix | AZ | 85096 | — | null |
| PRV | PRV-23138 | 2026-01-11T06:51:11Z | Albert | — | Santos | 1985-08-12 | UHC-10621-50 | N/A | 665-979-0940 | N/A | 2953 UNION ST | Chandler | AZ | 85221 | null | NAVIGATE-HMO |
| PRV | PRV-28702 | 2026-02-11T16:01:49Z | Daniel | — | Martinez | 1964-05-21 | UHC-53488-77 | null | (967) 627-1166 | — | ·8883 Forest Ave | Chandler | AZ | 85249 | — | ·N/A |
| PRV | PRV-27996 | 2026-07-11T08:51:22Z | ·MEDINA | ·· | BILLY | 1947-04-11 | null | - | 7316851904 | — | 3674 Canyon Rd | Gilbert | az | 85239·· | UNKNOWN | null·· |
| PRV | PRV-26727 | 2026-06-05T15:07:07Z | LARRY | — | WATSON | 10-10-1945 | UHC-02736-74 | — | 857-494-1531 | larry.watson@aol.com | 6529 Baseline Road Apt 18 | Orlando | FL | 32815 | UNKNOWN | — |
| PRV | PRV-21185 | 2026-05-09T00:00:28Z | Clark, Janice | — | — | 1988-06-25 | UHC-78491-23 | — | 518-990-4977 | - | 2719 RIVER RD | Orlando | FL | 32817 | ·· | — |
| PRV | PRV-21792 | 2026-01-22T06:58:12Z | Jacqueline·· | — | ·Payne | 1952-08-12 | — | •••-••-5043 | 766-482-1145 | NULL | 8478 SUNSET BOULEVARD | Plano | TX·· | 75091-4678 | NULL | — |
| PRV | PRV-24708 | 2026-04-27T03:24:17Z | Zachary | — | Rogers | 1980-11-20 | UHC-85497-87 | •••-••-5298 | (520) 377-6622 | zachary.rogers@gmail.com | 4290 Ridge Road | Eden Prairie | MN | 55310 | — | MEDICARE-ADV-A |
| PRV | PRV-27552 | 2026-02-18T17:04:52Z | SANDRA | — | PORTER | 1958-05-14 | UHC-53724-87 | UNKNOWN | (681) 610-6461 | sandra.porter@outlook.com | 1215 Ocean Ave | Los Angeles | CA | 90014 | null | ·UNKNOWN |
| PRV | PRV-24357 | 2026-10-18T08:18:16Z | Pamela | — | Hughes | 19620224 | - | NULL | — | pamela.hughes@gmail.com | 4681 Bayshore Dr | SACRAMENTO | California | 95823 | UNKNOWN | — |
| PRV | PRV-21505 | 2026-09-08T16:56:22Z | Barbara | — | Silva | 04/05/65 | null | — | ·13364136039 | barbara.silva@hotmail.com | 7394 Valley View Drive | Austin | TX | 78781 | — | null |
| PRV | PRV-24837 | 2026-06-11T01:15:16Z | Camila | — | Vargas | 07/17/01 | null | N/A | 442-389-0275 | N/A | 4897 Main St | Dallas | Texas | 75294 | — | - |
| PRV | PRV-27640 | 2026-06-09T05:10:07Z | Fernandez, Christine | — | — | 1973-04-23 | N/A | — | ·(949) 337-9792 | christine.fernandez8@gmail.com | 9101 Washington Street | Atlanta | GA | 30381-7217 | N/A | OPTIONS-PPO |
| PRV | PRV-28779 | 2026-04-20T23:28:54Z | Powell, Kyle | — | ···· | 1962-10-08 | UNKNOWN | N/A | ·(524) 919-2176 | NULL | null | null | - | — | N/A·· | — |
| PRV | PRV-27162 | 2026-06-16T22:41:52Z | heather | Z | medina | 2001-09-21 | UNKNOWN | — | 6528269794 | NULL | 7546 Baseline Road | ·Charlotte | NC | 28257-1390 | — | N/A |
| PRV | PRV-23429 | 2026-04-02T09:44:51Z | Keith | — | Mills | 1969-12-07 | UHC-47029-94 | •••-••-0971 | ·8646607825 | N/A | 278 Hillcrest Rd | Seattle | WA | 98106 | - | null |
| PRV | PRV-28396 | 2026-07-05T23:30:42Z | JACK | — | WARREN | 10-02-1966 | — | — | +1 840 769 7979 | JACK.WARREN@HOTMAIL.COM | ·2998 MOUNTAIN VIEW DRIVE | ·Dallas | Texas | 75297 | N/A | NULL |
| PRV | PRV-24856 | 2026-09-30T03:39:07Z | Sean | W. | Estrada | 1976-12-02 | NULL | — | (675) 855-4042 | SEAN.ESTRADA@OUTLOOK.COM | 6902 Washington St | Atlanta | ga·· | 30360 | — | MEDICARE-ADV-B |
| PRV | PRV-22943 | 2026-03-12T23:43:29Z | Ronald | A | Scott | 1892-04-26 | UHC-68475-54 | — | - | UNKNOWN | 9242 Grand Avenue | Phoenix | AZ | 85010 | — | null·· |
| PRV | PRV-21795 | 2026-03-20T15:47:24Z | Joyce | — | Arnold | 1949-10-04 | ·null | ···· | ·2872357849 | — | - | UNKNOWN | — | null | — | MEDICARE-ADV-B |
| PRV | PRV-22457 | 2026-03-04T18:46:35Z | Abigail | L | Marshall | 25-09-1943 | — | null | 647-520-3297 | abigail.marshall71@gmail.com | 8253 Desert Sky Boulevard | Dallas | TX | 75264 | ·· | ···· |
| PRV | PRV-25045 | 2026-09-21T14:41:23Z | cheryl | — | thomas | 1997-04-20 | UHC-96463-73 | null | +1 752 803 0642 | N/A | 8372 Cedar Lane | Eden Prairie | MN | 55387 | NULL | UNKNOWN |
| PRV | PRV-27849 | 2026-03-13T20:22:47Z | Tony | — | Hunt | 02-05-1939 | UHC-11062-05 | — | (913) 448-5813 | anthony.hunt@gmail.com | 7124 MOUNTAIN VIEW DRIVE | Fresno | California | 93795 | UNKNOWN | NAVIGATE-HMO |
| PRV | PRV-23722 | 2026-02-14T13:42:24Z | Bobby | — | Powell·· | 12/22/1965 | UHC-79003-10 | UNKNOWN | 6014179192 | N/A | - | - | - | N/A | ···· | NULL |
| PRV | PRV-20542 | 2026-05-17T04:08:30Z | Theresa | V | Fowler·· | 04/14/79 | NULL | NULL | 399.629.8696 | - | 9800 Lake View Rd | Columbus | OH | 43297 | -·· | CORE-HMO |
| PRV | PRV-25953 | 2026-04-17T20:04:04Z | DANIEL | — | ·WEBB | 1951-10-12 | ·UHC-29575-59 | •••-••-4535 | (394) 852-1162 | NULL | 4456 Harbor Boulevard | Denver | CO | 80231 | NULL | — |
| PRV | PRV-26176 | 2026-08-08T16:41:25Z | BRITTANY | H. | PARKER | 1966-10-13 | UHC-15235-59 | ·N/A | 503-306-4629 | brittany.parker88@aol.com | 7950 River Road | Scottsdale | AZ | 85213 | N/A | NULL |
| PRV | PRV-23794 | 2026-08-30T18:07:28Z | CYNTHIA | — | MEJIA | 6/17/1957 | N/A | N/A | (523) 474-4072·· | UNKNOWN | 8021 Spring St | AUSTIN | TX | 78792 | — | MEDICARE-ADV-B |
| PRV | PRV-26938 | 2026-03-14T20:25:48Z | Russell | — | Ferguson | 1949-04-04 | null | - | 375-591-6732 | ···· | 2954 Highland Ave | CHARLOTTE | North Carolina | UNKNOWN | NULL | — |
| PRV | PRV-27868 | 2026-03-05T03:01:19Z | Ford, Hannah | — | — | 1986-05-08 | UHC-68283-93 | •••-••-5373 | 3669698143 | null | ·5236 Willow Court | Fresno | CA | 93752 | N/A | N/A |
| PRV | PRV-28165 | 2026-07-24T08:22:46Z | NICHOALS | B·· | WEST | 1984-01-12 | UHC-15259-45 | N/A | 2395018715 | N/A | 5521 Grand Avenue | Fresno | ·CA | 93776 | ···· | ·null |
| PRV | PRV-26219 | 2026-09-13T11:10:14Z | Karen | — | Nichols | 19440715 | UHC-16586-71 | UNKNOWN·· | 9594802672 | karen.nichols@yahoo.com | 8450 INDIAN SCHOOL RD | Los Angeles | CA | 90035 | — | MEDICARE-ADV-A |
| PRV | PRV-22121 | 2026-04-28T02:47:30Z | Beverly | — | Bennett | 03/21/77 | NULL | null | 15639347126 | null | 8135 MOUNTAIN VIEW DRIVE | Nashville | TN | 37243 | — | - |
| PRV | PRV-29287 | 2026-05-12T20:52:08Z | ANNA | ·· | GUZMAN | 6/28/1968·· | UHC-10311-67·· | •••-••-6361 | 7833335104 | anna.guzman@gmail.com | 8017 Washington Street | Scottsdale | ·Arizona | 85252 | - | — |
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.310Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty