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-22768 | 2026-07-16T00:01:30Z | JACK | — | MENDOZA·· | 13-09-1978 | UNKNOWN·· | null | (686) 820-8834 | UNKNOWN | 6468 CAMELBACK RD | Chandler | AZ | 85243 | null | N/A |
| PRV | PRV-23235 | 2026-02-22T01:16:44Z | Allan | G | Hoffman | 23-06-1983 | UHC-11329-12 | — | 6496540688 | — | 3527 BAYSHORE DR | Fresno | CA | 93778 | - | — |
| PRV | PRV-26379 | 2026-06-19T13:49:02Z | james | M | maldonado | 1954-08-19 | UHC-48927-65 | - | 2759874401 | NULL·· | 9382 Mountain View Dr | Mesa | AZ | 85272 | ·NULL | MEDICARE-ADV-B |
| PRV | PRV-23677 | 2026-07-28T23:12:13Z | ·Amber | — | Kennedy | 1969-02-27 | — | •••-••-6416 | 16622072429 | — | 1169 Apache Boulevard | Los Angeles | CA | - | — | MEDICARE-ADV-B |
| PRV | PRV-27242 | 2026-07-10T12:01:54Z | Bradley | — | Morgan | 1948-01-20 | — | — | 3844981300 | UNKNOWN | 6148 CEDAR LN | ·Atlanta | GA | 30359 | — | — |
| PRV | PRV-28609 | 2026-03-04T20:31:22Z | JANET | B | MYERS·· | 1976-03-26 | UHC-34234-73 | — | 3436329039 | janet.myers99@outlook.com | 1433 Jefferson Ave | Jacksonville | FL | 32206-2213 | N/A | SELECT-EPO |
| PRV | PRV-20486 | 2026-02-17T05:08:42Z | David | — | Graham | 2003-09-12 | UHC-28829-66 | •••-••-1516 | +1 907 728 4379 | null·· | 2470 Lincoln Way | Plano | TX | 75031 | UNKNOWN | N/A |
| PRV | PRV-22385 | 2026-07-15T05:33:53Z | Diego | — | Mason | 1987-05-07 | ·· | UNKNOWN | 495.542.7071 | — | 1960 Willow Court | Houston | TX | 77038 | - | MEDICARE-ADV-A |
| PRV | PRV-26346 | 2026-01-08T09:05:41Z | BOBBY | Q·· | BARNES | - | — | -·· | 250-542-8493 | null | 7012 Lake View Rd | JACKSONVILLE | FL | — | — | UNKNOWN |
| PRV | PRV-24754 | 2026-03-10T13:43:08Z | Doris | — | ·Anderon | 6/16/1940 | UHC-85647-30 | •••-••-6546 | — | N/A | 5796 Broadway | Sacramento | California·· | 95828 | - | UNKNOWN |
| PRV | PRV-21758 | 2026-06-08T22:27:08Z | STEVEN | — | HOFFMAN | 1980-11-13 | ···· | — | ·null | steven.hoffman67@outlook.com | UNKNOWN | — | — | - | NULL | null |
| PRV | PRV-20347 | 2026-07-08T02:01:49Z | Fox, Mark | — | — | 7/18/1974 | UHC9990959 | — | 2946619352 | - | ·2492 Ridge Road | ·Minneapolis | MN | 55422-5300 | NULL | CORE-HMO |
| PRV | PRV-20923 | 2026-06-14T07:47:44Z | Ann | — | Elliott | 5/15/1990 | null | — | ·284-312-2218 | ANN.ELLIOTT@OUTLOOK.COM | 3996 Broadway | Glendale | AZ | 85361 | UNKNOWN | medicare-adv-b |
| PRV | PRV-21218 | 2026-06-04T09:10:30Z | lawrence | M | clark | 1996-12-10 | UHC-09797-27 | UNKNOWN | — | — | N/A | N/A | NULL | — | N/A | NULL |
| PRV | PRV-20656 | 2026-06-09T02:58:37Z | Harvey, Stephanie | — | ···· | 03/05/90 | ·UHC-11287-52 | NULL | (758) 318-4520 | N/A | ·6362 UNION ST | Eden Prairie | MN | 55338 | N/A | - |
| PRV | PRV-25076 | 2026-05-01T13:54:11Z | EVELYN | — | ESPINOZA | May 15, 1972 | UHC-88195-60 | -·· | 2864673382 | — | 157 Central Ave | Fresno | CA | ·· | null | — |
| PRV | PRV-26174 | 2026-09-13T03:47:02Z | Patrick | — | Henderson | Sep 17, 1968·· | UHC-63091-04 | •••-••-5753 | 708-956-0937 | N/A | 5981 Park Place | TAMPA·· | FL | null | NULL | — |
| PRV | PRV-24233 | 2026-10-08T10:46:07Z | margaret·· | U | vazquez | 1999-05-22 | UHC-51429-18 | - | ·· | ·N/A | 5357 CENTRAL AVE | SAN ANTONIO | TX | 78296-4431 | UNKNOWN | N/A |
| PRV | PRV-22255 | 2026-06-06T18:37:09Z | Gregory | — | Wagner | 12/28/87 | UHC-51627-22 | •••-••-7771 | 941-838-3423 | — | 6925 Broadway | MIAMI | FL | 33105 | UNKNOWN | - |
| PRV | PRV-24303 | 2026-01-12T19:05:29Z | Shirley | — | Adams | 07/20/1972 | UNKNOWN | — | 9159511274 | shirley.adams@proton.me | 8927 Ridge Road #823 | Houston | TX | — | NULL | choice-plus-ppo |
| PRV | PRV-20943 | 2026-01-11T05:05:20Z | ·Brenda | — | Robertson | 11/7/1943 | — | - | 2367132 | null | 8721 RIVER ROAD | Minneapolis | MN | 55402 | — | UNKNOWN |
| PRV | PRV-27560 | 2026-03-19T04:13:41Z | Kenneth | — | Delgado | 1956-05-01 | ·UHC-48532-68 | — | (834) 296-8675 | kenneth.delgado@gmail.com | null | N/A | - | - | — | ···· |
| PRV | PRV-23466 | 2026-01-27T17:42:57Z | Mariana | G | Riley | 25-06-1959 | UHC-27492-53 | — | 2787018958 | — | 5620 Valley View Dr | Gilbert | AZ | 85263 | — | — |
| PRV | PRV-29130 | 2026-07-30T19:22:37Z | CHRISTIAN | — | LYNCH | 1982-04-12·· | UHC-89218-09 | •••-••-8636 | 473.562.2060 | — | 2724 CENTRAL AVENUE | San Antonio | TX | 78248 | N/A | — |
| PRV | PRV-22837 | 2026-09-28T13:46:13Z | Deborah | — | Berry | Jan 16, 1940 | - | ·UNKNOWN | 5867850565 | deborah.berry7@aol.com·· | 5487 Maple Avenue | Houston | TX | 77008 | UNKNOWN | — |
| PRV | PRV-25129 | 2026-03-15T12:54:46Z | ALEXIS | — | WALKER | 1962-07-15 | — | null | (371) 567-9556 | NULL | 2604 Highland Ave | Phoenix | AZ | 85013 | NULL·· | CORE-HMO |
| PRV | PRV-25405 | 2026-03-11T08:14:56Z | ELIJAH | — | STEPHENS·· | 20021004 | UHC-28699-80 | null | 884.648.8345 | — | 7755 Ridge Road | Jacksonville | ·FL | 32240 | - | UNKNOWN |
| PRV | PRV-27171 | 2026-06-15T23:31:30Z | Evelyn | — | Lawon | 12/10/1997 | — | — | 480-760-9382 | UNKNOWN | 2187 WILLOW COURT #675 | Minneapolis | MN | 55402 | UNKNOWN | null |
| PRV | PRV-27177 | 2026-07-22T07:50:38Z | JULIE | ···· | ·ALEXANDER | 1996-01-22 | — | — | 17983554718 | ·null | 6091 Highland Ave | MIAMI | FL | — | UNKNOWN | NULL |
| PRV | PRV-27017 | 2026-05-12T03:32:41Z | Christine | E | Cunningham | 2002-02-17 | UHC-89978-63·· | — | 2123102804 | — | 5620 Canyon Road | Chandler | AZ | ·85224 | — | OPTIONS-PPO |
| PRV | PRV-28851 | 2026-07-25T14:10:13Z | Evelyn | — | Kim | 18-05-1991 | UHC-97183-17 | - | (862) 711-0973 | EVELYN.KIM@OUTLOOK.COM | 3615 Palm Drive | Seattle | WA | 98117 | NULL | NULL |
| PRV | PRV-22939 | 2026-10-04T07:58:35Z | SEAN | — | VASQUEZ | 03/25/1953 | UHC-70165-88 | null | 4339240463 | sean.vasquez53@outlook.com | ·5831 PALM DRIVE | Austin | tx | UNKNOWN | — | — |
| PRV | PRV-26832 | 2026-01-12T03:23:50Z | Bruce | — | Jackson | 1956-01-19 | UHC-34324-18 | ·N/A | (816) 711-4526 | bruce.jackson@aol.com | 8460 Oak St | Jacksonville | FL | 32261 | N/A | NAVIGATE-HMO |
| PRV | PRV-20431 | 2026-04-28T06:31:13Z | Katherine·· | — | Grant | 2008-04-28 | UHC-49702-48 | N/A | +1 343 978 2209 | — | 7447 Valley View Dr | ·Tempe | AZ | 85289 | UNKNOWN | NULL |
| PRV | PRV-26286 | 2026-02-25T08:41:50Z | MARIA | — | SPENCER | 1977-03-27 | UHC-16004-64 | •••-••-8629 | (725) 450-9368·· | — | 973 Sage Ct | Eden Prairie | MN | 55349 | ···· | NULL |
| PRV | PRV-21446 | 2026-10-03T03:40:20Z | Sara | — | Alvarado | 1974-04-15 | null | - | 7178037001 | SARA.ALVARADO@YAHOO.COM | 1776 Central Ave·· | Los Angeles | CA | 90062 | — | - |
| PRV | PRV-23341 | 2026-08-25T08:41:59Z | Ruth | — | Meyer | 1983-01-14 | N/A | •••-••-9118 | ·6576271761 | ···· | NULL | — | — | N/A | null | SELECT-EPO |
| PRV | PRV-28879 | 2026-04-05T01:38:53Z | SOFIA | Y. | BOWMAN | 19641120 | UHC-32544-49 | — | 595-638-4139 | sofia.bowman@proton.me | 3843 BASELINE ROAD | Scottsdale | AZ | 85229-3057 | — | null |
| PRV | PRV-20331 | 2026-08-27T16:16:50Z | Carolyn | — | Collins | 7/24/2001 | UHC-87961-21 | NULL·· | 892.903.8071 | — | 7280 Palm Dr | Gilbert | AZ | 85261 | null | — |
| PRV | PRV-24254 | 2026-05-06T05:28:39Z | Ramirez, Ethan | G | — | 1970-07-10 | UHC-26954-75 | - | (876) 644-5604 | ···· | 5724 MOUNTAIN VIEW DRIVE | Tucson | AZ | 85711 | — | UNKNOWN |
| PRV | PRV-22449 | 2026-07-06T07:39:56Z | Julia | — | Jensen | 21-06-1958 | UHC-89834-38 | NULL | 3894618707 | NULL | 6824 Broadway | Phoenix | Arizona | 85014 | — | — |
| PRV | PRV-22241 | 2026-06-05T13:22:32Z | Lori | I. | Duncan | 1951-07-06 | UHC-68266-89 | UNKNOWN | +1 927 452 7067 | ·UNKNOWN | 8977 MESA DR | Seattle | WA | 98164-4773 | null | — |
| PRV | PRV-24244 | 2026-05-07T08:54:45Z | CAROLYN | I | HERRERA·· | 7/4/1965 | UHC-83872-65 | UNKNOWN | — | UNKNOWN | 7974 WASHINGTON STREET | Gilbert·· | ·Arizona | 85261 | — | — |
| PRV | PRV-21875 | 2026-05-07T04:30:14Z | Dean, Tyler | — | — | 08/17/04 | null | N/A | 566-871-2479 | ·TYLER.DEAN@AOL.COM | 4144 CANYON RD | Seattle | WA | ·98177 | NULL | MEDICARE-ADV-A |
| PRV | PRV-26501 | 2026-04-09T01:23:26Z | Sean | ·· | Tucker | 1942-02-27 | null | N/A | 676.987.4210 | — | ·4803 CANYON RD | Minneapolis | MN | 55433 | — | UNKNOWN |
| PRV | PRV-23942 | 2026-01-16T01:19:40Z | Yuki | — | Patel | 19700323 | UHC-54511-33 | •••-••-9256 | (877) 640-3575 | NULL | 4070 BASELINE ROAD | Chandler | AZ | 85210 | N/A | N/A |
| PRV | PRV-28548 | 2026-05-08T02:36:59Z | Brandon | — | Santos | 1965-05-10 | UHC-60608-39 | ···· | 720-343-5308 | ·· | 1113 Broadway | Houston | ·TX | 77091 | UNKNOWN | null |
| PRV | PRV-24611 | 2026-03-13T08:42:00Z | Carolyn | ·W | Stevesn | 09/16/2005 | — | •••-••-9026 | 5539915428 | ·carolyn.stevens@aol.com | 5431 Forest Ave·· | Seattle | WA | 98176 | — | — |
| PRV | PRV-23001 | 2026-09-04T23:24:59Z | Marshall, Alice | E. | — | 11/22/1988 | ·· | — | 669.864.1806 | alice.marshall@outlook.com | 5036 Bayshore Dr | ·Plano | TX·· | 75009 | NULL | — |
| PRV | PRV-24747 | 2026-07-19T06:24:19Z | Pat | — | Fisher | 1985-08-03 | NULL | •••-••-4357 | — | - | 7715 Baseline Rd | Mesa | AZ | 85289 | NULL | navigate-hmo |
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.149Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty