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-26502 | 2026-08-02T05:55:08Z | SEAN | U. | TUCKER | 1942-02-27 | null | — | 16769874210 | NULL | 4803 CANYON RD·· | Minneapolis | MN | — | — | UNKNOWN |
| PRV | PRV-26370 | 2026-05-27T11:48:09Z | ETHAN | — | MORGAN | 1964-08-18 | — | — | N/A | — | N/A | NULL | N/A | UNKNOWN | — | SELECT-EPO |
| PRV | PRV-22303 | 2026-05-07T16:33:32Z | BRYAN | — | LOPEZ | 1952-11-09 | ·· | •••-••-4067 | UNKNOWN | NULL | 7665 Elm Street | ·Denver | co | 80287 | — | MEDICARE-ADV-A |
| PRV | PRV-20405 | 2026-09-06T13:36:17Z | Austin | — | Rice·· | 1961-08-09 | UHC-01782-05 | — | (633) 908-8309 | - | 3657 Elm St | Tempe | AZ | 85217 | - | N/A |
| PRV | PRV-27127 | 2026-02-17T07:50:50Z | DAVID | — | LYNCH | 1968-09-13 | UHC-56000-70·· | - | (738) 667-9694 | null | 7366 UNION STREET | TEMPE | ·AZ | 85207 | UNKNOWN | SELECT-EPO |
| PRV | PRV-28402 | 2026-02-05T17:11:09Z | Adam | Z·· | Baker | 1991-81-08 | UHC-26096-08 | UNKNOWN | 700.533.4140 | — | 1209 Park Pl | EDEN PRAIRIE | MN | NULL | — | — |
| PRV | PRV-28232 | 2026-04-29T18:53:42Z | Carolyn | ···· | Henry | 09/17/1941 | N/A | — | (968) 795-7748 | — | 924 River Road #294 | Dallas | TX | 75256 | NULL | N/A |
| PRV | PRV-22921 | 2026-04-18T18:03:18Z | ·Jason | ·M | Mills | 1986-04-22 | — | — | 352-422-6638 | N/A | 2460 Grand Ave Apt 16·· | Tampa | FL | 33639-0931 | — | UNKNOWN·· |
| PRV | PRV-26607 | 2026-07-09T03:20:37Z | jose | — | hernandez | 2008-07-01 | NULL | UNKNOWN | 704-676-6439 | UNKNOWN | 8649 Camelback Rd | Columbus | OH | 43271-9883 | N/A | CHOICE-PLUS-PPO |
| PRV | PRV-24655 | 2026-07-04T10:25:57Z | jose | — | green | 12-10-1998 | — | null | 735-305-4363 | jose.green@gmail.com | 6617 OCEAN AVENUE | Los Angeles | CA | 90002 | — | N/A |
| PRV | PRV-21433 | 2026-09-02T11:11:49Z | DOROTHY | A | SULLIVAN | 07/13/1975 | UHC-18967-93 | - | (692) 769-8509 | — | 1010 Union St | Tucson | AZ | 85755 | null | NULL |
| PRV | PRV-22455 | 2026-09-04T09:28:05Z | CHERYL | — | LITTLE | ·1951-06-21 | N/A | •••-••-5184 | 2967803744 | ·cheryl.little@gmail.com | 8771 MEADOW LN | Eden Prairie | MN | 55382 | null | UNKNOWN |
| PRV | PRV-25192 | 2026-03-15T09:49:15Z | JOSE | — | RYAN | 1948-06-08 | ···· | — | 707-353-1374 | N/A | 5976 Market St | Gilbert | AZ | 85281 | N/A | CHOICE-PLUS-PPO |
| PRV | PRV-24563 | 2026-05-13T00:20:13Z | arjun | K·· | chaevz | 07/17/1979 | — | — | (982) 616-1875 | arjun.chavez@outlook.com | 3090 Apache Boulevard | Tucson | AZ | 85770 | — | — |
| PRV | PRV-20816 | 2026-02-13T21:30:43Z | Joseph, Jordan | P. | — | 1945-09-27 | UHC-60507-55 | N/A | +1 704 931 1419 | — | 8990 Desert Sky Blvd Apt 25 | Austin | TX | 78721·· | UNKNOWN | SELECT-EPO |
| PRV | PRV-25476 | 2026-06-29T09:23:44Z | LAWRENCE | — | MORRIS | 1965-03-05 | NULL | — | (952) 214-6972 | UNKNOWN | 6621 CENTRAL AVENUE Apt 5 | Jacksonville | FL | 32258 | — | — |
| PRV | PRV-28193 | 2026-02-13T01:07:41Z | JEFFREY | ···· | NELSON | 19621020 | UHC-95285-40 | •••-••-6684 | (332) 437-9864·· | null | 1426 CAMELBACK RD | Sacramento | California | 95828-3058 | — | choice-plus-ppo |
| PRV | PRV-28688 | 2026-10-11T04:50:02Z | Barbara | — | Owens | 20020624 | ·- | NULL | 595-349-0383 | NULL | 4882 Church Street | Chandler | AZ | 85256 | — | MEDICARE-ADV-B |
| PRV | PRV-21243 | 2026-04-17T02:20:54Z | MARILYN | — | WYLLIS | ·1997-06-15 | UHC-30752-12 | •••-••-9412 | (827) 292-7043 | - | 8924 Grand Avenue | Atlanta | GA | — | UNKNOWN | UNKNOWN |
| PRV | PRV-21745 | 2026-09-10T21:19:01Z | Ethan | — | Li | 1947-07-13 | UHC-48504-34 | - | 323-205-0702 | ethan.li@gmail.com | 2446 MOUNTAIN VIEW DRIVE | Phoenix | AZ | 85064 | NULL | null |
| PRV | PRV-24341 | 2026-10-06T22:27:41Z | Denise | — | Stephens | 1/26/1988 | UHC-00197-62 | N/A | ·· | denise.stephens@outlook.com | 538 Bayshore Drive | Atlanta | Georgia | 30320 | N/A | N/A |
| PRV | PRV-28552 | 2026-05-21T18:01:15Z | Bruce | Q | Wilson | 2007-09-09·· | UHC-69395-77 | — | (744) 915-4205 | bruce.wilson52@gmail.com | ·2098 BASELINE RD | Tampa | fl | 33668-8077 | UNKNOWN | — |
| PRV | PRV-26972 | 2026-02-07T20:43:01Z | Smith, Lucia | — | — | Oct 17, 1983 | UHC-73102-48 | •••-••-7980 | 850.664.6125 | NULL | 7359 Washington St | Nashville | TN | 37207 | — | — |
| PRV | PRV-21423 | 2026-08-20T23:58:29Z | Bruce | P·· | Ferguson·· | 04/10/1978 | UHC-65891-58 | NULL | 3388534845 | - | N/A | null | ·· | null | N/A | CHOICE-PLUS-PPO |
| PRV | PRV-22070 | 2026-06-25T14:19:35Z | LARRY | ·· | MYERS | 02/11/01 | — | •••-••-7894 | +1 959 904 5305 | null | ·6114 Church Street | ·ATLANTA | GA | 30327 | N/A | CHOICE-PLUS-PPO |
| PRV | PRV-22821 | 2026-03-26T07:30:55Z | ALAN | — | RAMOS | 24-09-1971 | UHC-81866-57 | UNKNOWN | +1 979 342 6863 | N/A·· | 34 Washington St | Seattle | WA | 98132 | — | UNKNOWN |
| PRV | PRV-22756 | 2026-05-12T06:18:12Z | Mejia, Brandon | P·· | — | 12-12-1994 | ·- | N/A | (387) 932-4177 | — | 3682 CEDAR LN | Minneapolis | mn·· | 55463 | N/A | null |
| PRV | PRV-20097 | 2026-09-24T22:09:03Z | JOE | — | HUDSON | 1988-08-22 | UHC-75967-80 | •••-••-4089 | N/A | ·UNKNOWN | 22 Grand Ave | Scottsdale | AZ | 85213 | — | - |
| PRV | PRV-24044 | 2026-09-15T03:46:48Z | JOHN·· | — | TUCKER | ·1994-11-15 | UHC-06674-90 | — | 642-451-5710 | null | 5432 Park Place | Miami | FL | 33174 | - | null |
| PRV | PRV-20850 | 2026-05-27T16:58:10Z | gabriel | — | simpson | 02/15/43 | UHC2352326 | UNKNOWN | (744) 504-2495 | null | 6302 LAKE VIEW RD | Chandler | AZ | 85210 | ·· | UNKNOWN |
| PRV | PRV-23131 | 2026-10-11T07:59:52Z | Samuel | — | Marshall | 2008-01-11 | UHC-42128-45 | NULL | 19107025386 | null | 185 Union St | Columbus | oh | 43242 | ·null | MEDICARE-ADV-A |
| PRV | PRV-21859 | 2026-08-09T14:11:14Z | William | V | Snyder | 1941-06-07 | N/A | — | 910-284-6823 | ·- | 1256 BASELINE RD | Mesa | AZ | 85266 | — | null |
| PRV | PRV-23703 | 2026-04-16T20:01:34Z | camila | — | baker | 1946-03-09 | UNKNOWN | UNKNOWN | 9009578885 | UNKNOWN | 815 Ocean Ave | LAS VEGAS | NV | 89195·· | ·· | NULL |
| PRV | PRV-23986 | 2026-09-24T13:27:05Z | Theresa·· | — | Mendez | 1976-12-25 | UHC-72420-38 | — | (475) 823-2018 | - | 7707 RIVER ROAD | Miami | FL | 33156 | UNKNOWN | — |
| PRV | PRV-29236 | 2026-09-01T21:30:19Z | Andrea | — | Silva | 1968-07-26 | UHC-17651-51 | — | 6394369044 | — | 5701 FOREST AVE Apt 6 | San Diego | CA | 92126 | UNKNOWN | — |
| PRV | PRV-26937 | 2026-02-17T09:00:51Z | sarah | — | frankllin | 9179-02-19 | UHC-19757-48 | — | ·675-213-5009 | — | 5484 Central Avenue | Sacramento | CA | ·95864 | N/A | SELECT-EPO |
| PRV | PRV-29159 | 2026-03-05T18:24:30Z | Brandon | Z | Johnson | 1987-01-18 | UHC-07574-46 | — | (228) 724-9230 | ·brandon.johnson44@aol.com | 3554 Park Pl Apt 25 | Tucson | Arizona | 85738 | null | SELECT-EPO |
| PRV | PRV-25736 | 2026-05-30T01:23:08Z | AUSTIN | R | CUNNINGHAM | Dec 11, 2005 | N/A | — | ·639.283.6784 | austin.cunningham@aol.com | 4366 Forest Ave | Phoenix | AZ | 85002 | - | — |
| PRV | PRV-29032 | 2026-08-12T08:38:52Z | BENJAMIN·· | K | VASQUUEZ | 2006-04-10 | UHC-82637-55 | ···· | 3042095884 | — | 5631 MOUNTAIN VIEW DR | Orlando | FL | 32879-8499 | - | null |
| PRV | PRV-23301 | 2026-04-28T16:26:25Z | Victoria | N | Medina | 1977-12-21 | UHC-01237-82 | •••-••-8263 | 17818763630 | - | 2066 Cedar Lane | Dallas | TX | 75230 | ·· | — |
| PRV | PRV-20888 | 2026-04-22T12:15:54Z | Bailey, Margaret | — | — | 1/13/1998 | UHC-09162-99 | - | +1 831 591 4501 | - | 9793 Elm Street | Orlando | FL | 32804 | null | ·MEDICARE-ADV-A |
| PRV | PRV-27110 | 2026-03-11T23:49:01Z | LAURA | — | MASON | 19771026 | UHC-86903-57 | — | 3372559 | null | 4702 Highland Ave | Seattle | WA·· | — | UNKNOWN | — |
| PRV | PRV-26104 | 2026-07-21T08:10:01Z | Ann | — | Jones | 1966-09-24 | — | — | 4746282723 | NULL | 6076 Elm Street | San Antonio | TX | 78268 | NULL | null |
| PRV | PRV-26610 | 2026-03-06T19:41:19Z | VALENTINA | — | HIKKS | 1951-08-06 | N/A | UNKNOWN | 880.848.8420 | N/A | 137 Canyon Rd | Denver·· | CO | ·80245 | — | — |
| PRV | PRV-23435 | 2026-02-10T13:43:00Z | Kimberly | — | Hunter | 09/07/83 | N/A·· | UNKNOWN | 728-399-6473 | - | 3181 FOREST AVE Apt 17 | SAN ANTONIO | Texas | 78290 | — | — |
| PRV | PRV-20156 | 2026-06-24T03:09:26Z | Adam | — | Turner | 1942-05-16 | — | NULL | 833-213-1506 | adam.turner@hotmail.com | 2295 BAYSHORE DRIVE | Chandler | AZ | 85270 | — | ···· |
| PRV | PRV-28733 | 2026-04-14T02:58:35Z | Austin | — | Contreras | 1941-12-19 | UHC7212049 | null | (288) 792-2714 | — | 7460 CANYON ROAD | San Diego | CA | ·92125 | null | — |
| PRV | PRV-25542 | 2026-04-18T21:25:29Z | ·Carl | — | Banks | 07/28/79 | UHC-44122-85 | N/A | 7795715705 | carl.banks48@gmail.com | 7792 Jefferson Ave | ·Fresno | CA | 93782 | — | - |
| PRV | PRV-27496 | 2026-09-01T19:28:22Z | Ahmed | V. | Montgomery | 1993-10-05 | ·UHC-74670-82 | - | 897-387-4035 | AHMED.MONTGOMERY15@AOL.COM | 6407 Grand Avenue | TEMPE | AZ | UNKNOWN | — | MEDICARE-ADV-A |
| PRV | PRV-28110 | 2026-08-20T08:11:54Z | JONATHAN | — | FLORES | Sep 19, 1972 | N/A | — | 843-452-4663 | — | 9441 Canyon Rd | Eden Prairie | MN | 55360 | — | 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:43:03.426Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty