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-22296 | 2026-09-24T10:18:42Z | Samantha | ···· | Smith | 1958-06-16 | NULL | UNKNOWN | 7286461 | samantha.smith@gmail.com | - | N/A | — | null | N/A | - |
| PRV | PRV-28768 | 2026-08-01T09:38:47Z | Smith, Janice | ·· | — | 1961-08-04 | UNKNOWN | null | null | N/A | 7340 Desert Sky Blvd | Tucson | AZ | 85721 | null | UNKNOWN |
| PRV | PRV-25180 | 2026-03-23T08:30:51Z | Charlotte | H | Kelley | 1940-03-07 | UHC0232825 | UNKNOWN | (861) 567-9243 | - | — | NULL | NULL | N/A | — | CHOICE-PLUS-PPO |
| PRV | PRV-25989 | 2026-03-19T17:29:49Z | benjamin | — | boyd | 1939-02-06 | UHC-43747-98 | UNKNOWN | 4527770904 | NULL | 8631 Sage Court | Jacksonville | FL | 32269-4494 | NULL | MEDICARE-ADV-A |
| PRV | PRV-21719 | 2026-04-01T16:36:25Z | randy | — | hawkins | 1963-06-06 | UHC-99256-51 | — | 450-817-3685 | — | N/A | NULL | N/A | — | UNKNOWN | ·· |
| PRV | PRV-26526 | 2026-06-08T06:51:10Z | ·RAYMOND | — | WONG | 1994-04-14·· | NULL | NULL | 8573971127 | UNKNOWN | 6869 Union Street | Los Angeles | CA | 90038 | — | — |
| PRV | PRV-22305 | 2026-06-26T01:44:46Z | SANDRA | — | YANG | Oct 20, 1961 | UHC-18320-22 | NULL | 3794997151 | - | N/A | N/A | null | — | null | MEDICARE-ADV-B |
| PRV | PRV-22294 | 2026-08-12T14:10:45Z | Ralph | — | Robertson | 2005-08-09 | UHC-03692-72 | •••-••-1515 | 8357671481 | NULL | 2123 CAMELBACK ROAD | Scottsdale | AZ | 85264 | NULL | — |
| PRV | PRV-27081 | 2026-10-11T11:59:26Z | GRACE | W | COOPER | 11/17/1975 | N/A | ···· | +1 364 785 2882 | null | 5629 PALM DR | Glendale | ·AZ | ·85321 | UNKNOWN·· | null |
| PRV | PRV-28693 | 2026-05-08T23:54:36Z | Gerald | — | Wood | 1597-11-07 | - | •••-••-3223 | (503) 574-2089 | gerald.wood61@hotmail.com | 5108 MAPLE AVE | Las Vegas | NV | 89180 | ·N/A | CORE-HMO |
| PRV | PRV-24963 | 2026-08-29T17:27:36Z | Omar | — | Hicks | Jun 28, 1993 | ·UNKNOWN | — | 968-202-3886 | ·· | ·· | — | UNKNOWN | — | — | — |
| PRV | PRV-21766 | 2026-04-08T13:30:23Z | LARRY | — | BARNES | 1958-04-09 | UHC-76599-05 | •••-••-4030 | 431-240-2230 | larry.barnes70@aol.com·· | 6609 Market Street | HOUSTON | TX | 77037 | UNKNOWN | — |
| PRV | PRV-27689 | 2026-08-24T20:42:45Z | Schmidt, Kayla | — | — | 1973-12-05 | UNKNOWN | NULL | 16105445206 | N/A | 7183 Sunset Blvd | Columbus | OH | 43276 | NULL | — |
| PRV | PRV-27789 | 2026-09-29T02:44:40Z | Joan | — | Brooks | 19640503 | UHC-26997-72 | — | 6432077408 | — | N/A | UNKNOWN | — | NULL | — | — |
| PRV | PRV-28309 | 2026-09-23T15:15:50Z | Michelle | — | Harirson | 2000-04-28 | UHC-04552-01 | ·· | 7899307291 | michelle.harrison@aol.com | 2767 Indian School Rd | Jacksonville | FL | 32204·· | - | NAVIGATE-HMO |
| PRV | PRV-22015 | 2026-04-08T23:15:35Z | ·JERRY | — | FOWLER | ·09/15/48 | UHC-15169-15 | •••-••-8057 | 2374041501 | JERRY.FOWLER29@HOTMAIL.COM | N/A | NULL | — | NULL | null | ·- |
| PRV | PRV-25970 | 2026-06-17T10:04:00Z | DIANE | — | HUGHES | 2002-11-27 | UHC-73105-62 | •••-••-2614 | 564.471.3161 | diane.hughes@icloud.com | 5255 River Rd | Seattle | WA | 98134 | — | NULL |
| PRV | PRV-24901 | 2026-02-18T09:04:19Z | yuki | — | chapman | Feb 19, 2002 | NULL | — | 726-957-6631·· | N/A | 5584 Desert Sky Boulevard | MINNEAPOLIS | Minnesota | 55416 | — | UNKNOWN |
| PRV | PRV-20949 | 2026-02-04T23:32:52Z | gerald | V | robertson | 1997-03-28 | UHC-86460-12 | N/A | 796-930-2546 | NULL | 7199 Camelback Rd | San Diego | CA | 92127 | — | -·· |
| PRV | PRV-26433 | 2026-05-15T23:56:21Z | Matthew | — | Marquez·· | 1963-03-11 | — | •••-••-2476 | 310-650-3184 | matthew.marquez15@aol.com | 3974 Harbor Blvd | Sacramento | ca·· | 95824 | — | - |
| PRV | PRV-26414 | 2026-03-15T18:36:19Z | Annna | — | Ortiz | 19640820 | UHC-88523-20 | •••-••-1689 | (592) 906-8658 | NULL | 1887 CENTRAL AVE | Charlotte | North Carolina | 28209 | UNKNOWN | — |
| PRV | PRV-27862 | 2026-07-01T08:28:41Z | ·abigail | X | santiago | 19470518 | — | - | 4923525911 | ·abigail.santiago@proton.me | 2848 Apache Blvd | Scottsdale | AZ | 85222 | — | OPTIONS-PPO |
| PRV | PRV-24599 | 2026-09-10T14:33:26Z | RAY | R. | PRRIYA | 1962-05-28 | ·· | •••-••-0733 | 970-903-7558 | - | 7268 CEDAR LANE | GILBERT | Arizona | 85287 | — | - |
| PRV | PRV-25712 | 2026-03-12T09:43:42Z | Doris | ···· | Diaz | 1945-12-07 | UHC-46853-05 | null | 8050340 | doris.diaz48@gmail.com | ·N/A | — | — | - | — | — |
| PRV | PRV-23674 | 2026-08-02T23:49:27Z | Steven | — | Schmidt | 1986-09-25 | NULL | N/A | N/A | UNKNOWN | 2572 RIDGE ROAD | Plano | TX | 75059 | N/A | CORE-HMO |
| PRV | PRV-25819 | 2026-09-11T13:59:30Z | TIM | — | PERRY | 20080520 | UHC-32260-32 | — | (885) 581-9733 | UNKNOWN | 7814 HIGHLAND AVENUE | Miami | FL | 33136 | ·· | — |
| PRV | PRV-24183 | 2026-05-11T18:19:59Z | KATHLEEN | C | KNIGHT | 1981-08-22 | UHC-60314-10 | — | (233) 687-3624 | — | 3149 PARK PLACE·· | Dallas | tx·· | 75204·· | UNKNOWN | null |
| PRV | PRV-26630 | 2026-08-17T13:32:36Z | LARRY | — | RILEY | 1938-04-13 | UHC-29158-66 | NULL | 3113969988·· | larry.riley@outlook.com | 4797 Mountain View Dr | ORLANDO | FL | N/A·· | — | — |
| PRV | PRV-26265 | 2026-07-01T09:47:22Z | SEAN | J | LE | 1995-05-23 | UHC-51623-66 | — | (958) 562-4543 | — | 465 Willow Ct | Austin | TX | 78743 | NULL | NULL·· |
| PRV | PRV-26631 | 2026-08-08T15:25:02Z | Natalie | — | Myers | 2006-05-19 | NULL | •••-••-0914 | 6615760051 | NATALIE.MYERS72@HOTMAIL.COM | ·5100 Main Street | Miami | FL | 33128 | - | NULL |
| PRV | PRV-25785 | 2026-10-18T23:17:47Z | Peter | T | Castillo | 2007-04-06 | UHC-85777-05 | N/A | (491) 861-1411 | — | 237 Canyon Rd | San Antonio | TX·· | 78286 | N/A | — |
| PRV | PRV-24325 | 2026-01-15T12:06:41Z | MEI | — | ALLEN | 1991-09-17·· | UHC-06040-50 | •••-••-7454 | 796-770-0380 | — | 2703 Main Street | Tampa | FL | 33634 | - | - |
| PRV | PRV-29051 | 2026-01-17T08:30:00Z | Richard | — | Park | 11/22/00 | UHC0514179 | — | ·14204467255 | UNKNOWN | 3576 Lincoln Way | ORLANDO | FL | 32872-1626 | UNKNOWN | CORE-HMO |
| PRV | PRV-22033 | 2026-04-13T01:43:22Z | ROBERT | K. | ROMERO | 19861118 | UHC8430991 | N/A | 2892436915 | ·· | 4570 BASELINE RD | Tucson | AZ | 85780 | N/A | N/A |
| PRV | PRV-21829 | 2026-07-18T01:20:30Z | Logan | — | Lucas | Sep 26, 1985 | UHC-61131-87·· | •••-••-5579 | UNKNOWN | logan.lucas@proton.me | null | — | - | - | ···· | — |
| PRV | PRV-26791 | 2026-07-08T22:00:11Z | priya | — | campbell | 3/8/1946 | UHC-62725-43 | - | +1 230 502 0740 | NULL | 310 Pine Dr | Chandler | AZ | 85235·· | - | — |
| PRV | PRV-29518 | 2026-03-02T04:41:59Z | Julie·· | D | Medina | 2004-05-05 | UHC-60078-04·· | null | — | NULL | 7323 Apache Blvd | Austin | TX | 78743 | UNKNOWN | SELECT-EPO |
| PRV | PRV-25908 | 2026-08-09T08:04:51Z | JACOB | — | ·BROOKS | 1980-04-10 | UHC-39223-34 | •••-••-9502 | 877-660-5057 | jacob.brooks@yahoo.com | 6477 Broadway | Tempe | AZ | 85240 | N/A | NULL |
| PRV | PRV-21464 | 2026-07-11T18:19:40Z | Steven | — | Rojas | 10/3/2006 | UHC-06323-48 | NULL | 8596008897 | NULL | ·6813 Baseline Road | Gilbert | AZ | 85289-2063 | N/A | null |
| PRV | PRV-22035 | 2026-10-07T19:51:06Z | Lisa | — | Hoawrd | 2000-06-25 | UHC-49832-15 | — | (410) 663-2404 | UNKNOWN | 5634 MARKET ST | ·Charlotte | NC | 28296 | — | null |
| PRV | PRV-21844 | 2026-09-01T21:43:02Z | ·dunn | ·· | terry | 1970-06-22 | ·UNKNOWN | •••-••-6392 | 14193152449 | ···· | ·1568 CEDAR LN | SAN ANTONIO | TX | 78202 | — | N/A |
| PRV | PRV-23467 | 2026-01-20T21:12:28Z | Catherine | — | Cunningham | 1963-04-20 | N/A | — | - | NULL | 2671 Highland Ave | Las Vegas | NV | ·89145 | N/A | — |
| PRV | PRV-25707 | 2026-03-15T09:25:06Z | ·Ross, Gloria | Q | — | 1983-08-24 | UHC-95778-74 | — | (418) 424-7281 | — | ·4616 Forest Avenue | MINNEAPOLIS | MN | 55498 | N/A | — |
| PRV | PRV-25640 | 2026-02-27T13:11:01Z | ·Jesse | — | Wallace·· | 2005-06-01 | N/A | - | 490.717.4293 | - | 6051 River Rd | SAN DIEGO | CA | 92182 | - | N/A |
| PRV | PRV-21720 | 2026-08-11T15:27:22Z | Elliott | N | Karen | 1970-11-18 | UHC-05863-63 | — | (781) 354-3310 | NULL | 7428 FOREST AVENUE | San Antonio | ·TX | 78201-2952 | — | ·N/A |
| PRV | PRV-24880 | 2026-05-17T13:13:53Z | Lee, Lori | — | — | 1943-09-07 | - | null | (779) 382-8307 | — | 7843 SUNSET BLVD | Scottsdale | AZ | — | UNKNOWN | - |
| PRV | PRV-21617 | 2026-05-05T15:06:06Z | Sims, Sofia | — | — | 1955-06-06 | null | — | — | null | — | - | ···· | — | - | N/A |
| PRV | PRV-25478 | 2026-10-01T03:07:33Z | ·Lawrence | P | Russell | 1987-08-05·· | UHC-94134-10 | NULL | 2872850074 | — | ·· | — | — | - | - | SELECT-EPO |
| PRV | PRV-20884 | 2026-02-14T12:02:26Z | ·Wei | X | Bailey | 1963-90-25 | N/A | N/A | 346-912-4284 | — | 8300 PARK PLACE | Mesa | ·AZ | 85214 | — | null |
| PRV | PRV-27662 | 2026-03-27T07:04:51Z | kevin | V.·· | knight | 1953-01-22 | - | NULL | 889-979-6016 | kevin.knight@icloud.com | 7111 Ridge Road | Minneapolis | MN | ·· | - | 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:42:43.639Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty