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-27781 | 2026-02-05T17:28:15Z | George | K | ·Dominguez | 1961-11-27 | UHC-82930-52·· | - | +1 281 443 6322 | george.dominguez@gmail.com | 684 Highland Avenue | ·Scottsdale | az | 85265 | N/A | SELECT-EPO |
| PRV | PRV-25412 | 2026-05-11T17:11:01Z | Olson, Bruce | — | ·· | 1938-06-21 | UHC-09197-07 | null | 4539108 | bruce.olson@icloud.com | 2751 Ridge Rd | Seattle | wa | ·98165-5543 | N/A | OPTIONS-PPO |
| PRV | PRV-29337 | 2026-07-05T23:08:11Z | Ralph | — | Wood | 1959-08-19 | UHC-68877-11 | N/A | 2908299688 | NULL | 5440 LAKE VIEW RD | CHARLOTTE | nc | 28250-2412 | NULL | OPTIONS-PPO |
| PRV | PRV-23589 | 2026-08-24T11:27:12Z | Harold | — | Smith | 1964-12-25 | UHC5441291 | •••-••-5746 | 426-367-6235 | harold.smith@hotmail.com | 6838 Camelback Rd | Denver | CO | 80214 | — | SELECT-EPO |
| PRV | PRV-26130 | 2026-07-25T22:55:17Z | Carol | — | Rogers | 1973-06-14 | UHC-29452-56 | — | (643) 767-6642 | N/A | 6820 HILLCREST ROAD #482 | Minneapolis | MN | 55427 | null | - |
| PRV | PRV-26881 | 2026-02-07T06:09:21Z | HAROLD | — | RAMIREZ | 28-04-1943 | UHC-18546-96 | NULL | +1 722 316 0778 | harold.ramirez@outlook.com | 6606 Forest Avenue | CHARLOTTE | NC | 28260 | — | N/A |
| PRV | PRV-23795 | 2026-08-17T23:37:52Z | Jason | ···· | Wang | 1942-07-04 | ·UHC-43783-35 | ···· | (535) 431-9408 | jason.wang99@hotmail.com | 1287 HARBOR BOULEVARD #201 | Los Angeles | CA | 90011-9921 | null | UNKNOWN |
| PRV | PRV-20011 | 2026-10-18T10:28:00Z | Sara | J. | Contreras | 1973-04-10 | UHC-46492-52 | — | — | sara.contreras60@icloud.com | 4401 River Road | Seattle | WA | 98159 | — | NAVIGATE-HMO |
| PRV | PRV-23070 | 2026-04-27T05:36:44Z | Victoria | — | Contreras | 1974-07-19 | — | — | (510) 228-2443 | ·· | 7228 BASELINE RD | Orlando | fl | 32817 | NULL | ·CORE-HMO |
| PRV | PRV-24158 | 2026-04-14T03:05:46Z | Wei | — | Moore | 1956-10-25 | - | null | NULL | wei.moore@yahoo.com | — | UNKNOWN | - | NULL | NULL | SELECT-EPO |
| PRV | PRV-26739 | 2026-07-24T03:39:47Z | Sharon | T | Sims | NULL | UNKNOWN·· | •••-••-2142 | 827-821-8280 | null | null | ·- | — | — | — | NULL |
| PRV | PRV-28099 | 2026-02-09T02:18:07Z | Brooks, Logan | ···· | — | 1952-04-19 | - | •••-••-7142 | 2603003266 | NULL | 3578 Forest Ave | Eden Prairie | MN | N/A | ···· | NULL |
| PRV | PRV-28297 | 2026-10-05T21:38:56Z | — | — | — | 19850221 | UHC-13034-08·· | •••-••-3242 | 5565850121 | N/A | 2552 MAPLE AVENUE | Jacksonville | FL | 32230 | — | — |
| PRV | PRV-22958 | 2026-07-03T17:23:35Z | Phillips, Rob·· | — | — | 1943-11-04 | — | •••-••-1199 | 732-547-2007 | N/A | 4709 INDIAN SCHOOL ROAD | Scottsdale | AZ | 85255 | - | — |
| PRV | PRV-24220 | 2026-01-12T18:22:55Z | Olivia | — | Berry | 1987-12-10 | UNKNOWN | null | 344-620-1978 | N/A·· | null | — | UNKNOWN | UNKNOWN | null | CORE-HMO |
| PRV | PRV-21354 | 2026-03-05T17:17:03Z | JOSPEH | J | WOOD | 1987-12-20 | null | — | 9577963480 | null | 2060 Canyon Road | Phoenix | AZ·· | 85037-3855 | — | MEDICARE-ADV-A |
| PRV | PRV-27069 | 2026-02-24T19:04:31Z | KELLY | — | FOX | 01/15/1996 | - | •••-••-9374 | 9012158914 | - | 4171 RIVER ROAD | Plano | TX | 75013 | null | null |
| PRV | PRV-23252 | 2026-02-13T08:41:13Z | KAYLA | — | ·OLSON | 1988-07-18 | UHC-13448-68 | null | 7559313985 | N/A | 1392 Grand Avenue | ·Dallas | TX | 75297·· | null | N/A |
| PRV | PRV-29546 | 2026-04-20T18:05:58Z | hiroshi | — | butler | — | UHC-41564-73 | ·· | 3487174748 | — | 4742 Oak Street | ·Denver | ·CO | - | NULL | MEDICARE-ADV-B·· |
| PRV | PRV-26576 | 2026-07-11T20:50:04Z | Roger·· | — | Peters | 05/09/68 | - | — | 9636620056 | — | 7864 Lincoln Way | Scottsdale | AZ | 85272 | ·NULL | - |
| PRV | PRV-21518 | 2026-10-11T03:30:03Z | Jason | ···· | Duncan | 6/16/1996 | UHC-47431-54 | — | — | — | 783 Washington St | Houston | Texas | 77091 | — | — |
| PRV | PRV-26384 | 2026-01-17T15:10:26Z | Ramirez, Patricia | — | ···· | 1999-04-18 | UHC-77528-55 | — | 5696782858 | patricia.ramirez41@outlook.com·· | ···· | N/A | — | — | - | - |
| PRV | PRV-22562 | 2026-09-19T17:36:14Z | ANA | — | RAY | ·10-03-2008 | — | UNKNOWN·· | ·(731) 439-1317 | -·· | 467 HARBOR BLVD Apt 39 | Atlanta·· | Georgia | UNKNOWN | — | null |
| PRV | PRV-26841 | 2026-09-09T23:10:34Z | Ken | — | James | 1941-08-01 | UHC7984573 | ···· | NULL | — | 2485 BASELINE RD | Gilbert | Arizona | 85229 | N/A | — |
| PRV | PRV-25927 | 2026-03-10T01:24:19Z | Murpyh, Bobby | — | — | 4/3/1992 | - | •••-••-9817 | 396-969-3979 | - | 4556 RIDGE RD | Houston | TX | 77089 | N/A | null |
| PRV | PRV-21108 | 2026-07-17T21:55:25Z | Mark | — | Crawford | 1942-07-15 | UHC-80518-14 | null | 13363944959 | NULL | 9452 Mesa Dr | Eden Prairie | MN | 55398 | — | — |
| PRV | PRV-28861 | 2026-09-23T20:02:43Z | ·Karen | — | Alexander·· | 1975-02-26 | — | N/A | null | null | 6849 Cedar Lane | Nashville·· | TN | 37254-7590 | — | MEDICARE-ADV-A |
| PRV | PRV-28245 | 2026-05-19T07:44:50Z | SHIRLEY | H | ELLLIS | Jan 21, 1975 | ·N/A | — | +1 284 631 5516 | — | 7905 Church Street | Phoenix | AZ | 85068 | null | - |
| PRV | PRV-20646 | 2026-07-14T12:18:30Z | Bowman, Christine | — | — | 1953-10-18·· | — | — | 564-812-1289 | null | 125 Spring Street | Nashville | ·TN | 37233 | UNKNOWN·· | CORE-HMO |
| PRV | PRV-23121 | 2026-07-11T19:37:07Z | Josh | — | Payne | 1946-12-20 | UHC-46227-21 | •••-••-6696 | 13004991602 | JOSHUA.PAYNE43@GMAIL.COM | 8870 Main St Apt 8 | DENVER | Colorado·· | 80285 | — | NULL |
| PRV | PRV-23964 | 2026-05-07T19:00:35Z | BRIAN | F | WILSON | 1984-10-03 | UHC-08927-59 | N/A | (740) 218-5505·· | UNKNOWN | 955 CEDAR LN | Miami | FL | N/A | N/A | - |
| PRV | PRV-21116 | 2026-05-03T18:19:34Z | CATHERINE | — | WARREN | Feb 15, 1967 | UHC-42276-35 | •••-••-8283 | ·820-842-6413 | NULL | NULL | — | — | UNKNOWN | null | NULL |
| PRV | PRV-22519 | 2026-08-30T18:46:44Z | judith | M. | dean | 1998-06-17 | NULL | •••-••-3403 | 989-744-4303 | NULL | 7492 Market Street | Mesa | AZ | 85270 | ·UNKNOWN | UNKNOWN·· |
| PRV | PRV-22845 | 2026-04-23T16:56:31Z | ABIGAIL | — | JENKINS | 12/11/2005 | UHC-73523-67 | •••-••-3688 | ·+1 721 788 0087 | abigail.jenkins@yahoo.com | 5428 APACHE BOULEVARD | San Diego | ·California | 92185-0491 | — | null·· |
| PRV | PRV-29399 | 2026-05-31T11:02:11Z | Frank | — | Owens | 1979-11-28 | UHC-66842-15 | UNKNOWN | N/A | - | - | — | null | ·N/A | NULL | — |
| PRV | PRV-21016 | 2026-05-07T21:13:36Z | CARLOS | — | — | Dec 17, 1951 | UHC9414809 | ···· | (384) 593-0105 | CARLOS.MORALES91@HOTMAIL.COM | — | — | — | N/A | N/A | CORE-HMO |
| PRV | PRV-29006 | 2026-02-03T04:35:26Z | Julie | — | Hansen | 1947-05-27 | UHC-90762-59 | — | 4232319218 | null | 7954 MAIN STREET | TUCSON·· | AZ | 85776 | — | NAVIGATE-HMO |
| PRV | PRV-21665 | 2026-05-28T01:04:27Z | DAN·· | — | HERRERA | ·1975-02-05 | - | — | UNKNOWN | daniel.herrera16@gmail.com | 1962 CHURCH ST | Plano | TX | 75096 | UNKNOWN | null |
| PRV | PRV-23622 | 2026-07-09T21:44:21Z | Guerrero, Carlos | — | — | 19600311 | null | •••-••-2593 | (697) 585-9369 | NULL | 53 GRAND AVENUE | Gilbert | AZ | ·85241 | UNKNOWN·· | NULL |
| PRV | PRV-22208 | 2026-07-13T02:26:00Z | BRENDA·· | — | STEPHENS | 1965-07-27 | — | •••-••-8393 | 5736872252 | brenda.stephens@hotmail.com | 3910 Forest Ave #565 | Phoenix | AZ | 85033 | null | — |
| PRV | PRV-22054 | 2026-05-19T07:23:23Z | Mark | — | Hunt | 1984-06-14 | — | — | 780-456-0399 | mark.hunt64@outlook.com | 7893 SAGE COURT Apt 21 | Tampa | FL | 33699 | UNKNOWN | OPTIONS-PPO·· |
| PRV | PRV-24443 | 2026-08-18T01:23:47Z | Grace | — | Jenkins | 1998-10-08 | — | •••-••-1388 | 624.473.3419 | grace.jenkins@aol.com | 4259 Sage Court | Tampa | ·FL | 33608-9480 | — | ·NULL |
| PRV | PRV-24541 | 2026-05-20T19:53:34Z | Diana | — | Hughes | 3/1/1975 | UHC-99954-49 | — | - | — | 8291 Palm Drive | Dallas | Texas | 75254 | — | UNKNOWN |
| PRV | PRV-22272 | 2026-10-09T14:25:57Z | Aguilar, Patricia | G. | — | 1953-02-23 | UHC-00064-32 | N/A | - | ·null | 5789 River Rd | Nashville | TN | 37202 | — | — |
| PRV | PRV-24241 | 2026-09-10T23:05:07Z | NOAH | — | GARRETT | 1948-06-17 | UHC9963891 | -·· | (795) 226-8932·· | — | ·3201 SUNSET BOULEVARD | Charlotte | NC | 28246 | NULL | — |
| PRV | PRV-23318 | 2026-06-02T01:41:24Z | Garza, Rebecca | ···· | — | 1975-70-18 | UHC-40205-49 | — | 549-556-1390 | NULL | 5199 UNION STREET | PLANO | TX | ·75044 | — | NULL |
| PRV | PRV-25040 | 2026-09-05T11:40:52Z | JUAN | — | ·GEORGE | 1969-10-12 | UHC-51548-97 | UNKNOWN | 681.258.9562 | ·juan.george@yahoo.com | 416 Hillcrest Road | Austin | tx | 78790 | — | — |
| PRV | PRV-27699 | 2026-03-10T01:57:28Z | Brenda | — | Wright | 1976-02-10 | UNKNOWN | ···· | 8795444929 | - | NULL | N/A | — | N/A | ·null | ·NULL |
| PRV | PRV-23314 | 2026-05-31T01:41:53Z | ALEXANDER | J. | CASTRO | 1938-07-15 | UHC-91968-47 | •••-••-8510 | N/A | alexander.castro@proton.me | 6520 Apache Blvd | Scottsdale | AZ | — | null | N/A |
| PRV | PRV-28384 | 2026-07-08T09:07:42Z | Megan | ·· | Carter | 1980-10-13 | UHC-66312-14 | N/A | 606.903.8480 | megan.carter10@icloud.com | 4534 Forest Ave·· | San Diego | CA | 92152 | - | OPTIONS-PPO |
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.438Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty