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-20597 | 2026-08-23T15:03:46Z | Bryan | — | Davis | 1959-09-09 | NULL | UNKNOWN | 278-799-2735 | - | 2320 UNION STREET | ·Miami | FL | 33104 | null | MEDICARE-ADV-B |
| PRV | PRV-21578 | 2026-05-07T10:04:06Z | BRYAN | — | STEVENS | 1/4/1944 | — | •••-••-1821 | 2625639406 | bryan.stevens@hotmail.com | — | - | ·UNKNOWN | NULL | — | OPTIONS-PPO |
| PRV | PRV-21249 | 2026-08-08T22:00:45Z | JEFFREY | — | LARSON | ·09/24/1955 | UHC-00373-95 | N/A | 289-551-4159 | UNKNOWN | 5242 Jefferson Avenue | Scottsdale | AZ | 85236 | null | ·NULL |
| PRV | PRV-29291 | 2026-05-13T20:17:02Z | DENNIS | — | HART | 1980-01-06 | - | •••-••-7801 | 2576984525 | ···· | 8743 Maple Ave | Mesa | az | 85254 | ·N/A | UNKNOWN |
| PRV | PRV-20271 | 2026-03-09T16:19:31Z | Kayla | C | Shaw | 1986-11-15 | UHC-04156-50 | N/A·· | - | — | 7030 Washington Street | Plano | TX | ·75049 | UNKNOWN | CHOICE-PLUS-PPO |
| PRV | PRV-27264 | 2026-05-01T15:00:59Z | Braldey | — | Chen | 1993-05-27 | — | N/A | (571) 758-2303 | — | 285 RIDGE ROAD | Tucson | AZ | 85777 | — | — |
| PRV | PRV-26680 | 2026-03-11T04:24:42Z | megan | — | carter | 1953-09-14 | UHC-16129-53 | — | (467) 407-1961 | megan.carter@yahoo.com | 2354 CANYON RD | TUCSON | AZ | — | UNKNOWN | — |
| PRV | PRV-27121 | 2026-07-16T04:42:34Z | Russell | ···· | Hudson | 1991-72-26 | UHC-77582-79 | •••-••-2290 | (853) 923-0202 | N/A | 2756 Washington Street | San Antonio | TX | 78297 | — | UNKNOWN |
| PRV | PRV-28327 | 2026-03-29T04:20:07Z | Evelyn | — | Simpson | 01/11/1979 | UHC-33527-89 | — | 338-612-9001 | - | 6787 FOREST AVE | Dallas | TX | 75241 | null | null |
| PRV | PRV-26354 | 2026-06-04T11:15:33Z | KIM | H | HARVEY | 19600128 | UNKNOWN·· | null | 3391567 | UNKNOWN | 1939 Palm Drive | Miami | FL·· | 33153-8600 | UNKNOWN | NULL |
| PRV | PRV-21840 | 2026-05-10T14:50:36Z | Cruz, Emily·· | — | — | 2006-02-24 | - | — | ·737-647-5456 | N/A | 9514 Spring St | Mesa | Arizona | 85245 | N/A | — |
| PRV | PRV-25237 | 2026-10-10T08:33:25Z | Sophia | — | Harrison | 1964-02-25 | null | — | 881.482.5729 | NULL | NULL | - | N/A | N/A | — | MEDICARE-ADV-B |
| PRV | PRV-22667 | 2026-04-01T13:38:17Z | Doris | — | Stewart | 1968-03-04 | UHC-07596-64 | - | 619-451-1077 | — | 5776 Sage Court | Minneapolis | MN | 55480·· | N/A | N/A |
| PRV | PRV-27159 | 2026-04-25T08:45:32Z | John | ·· | Rice | 2000-08-08 | ·null | - | - | null | 9658 Elm St | Orlando | FL | 32827 | N/A | — |
| PRV | PRV-21382 | 2026-09-04T08:55:03Z | Helen | — | Cruz | 1988-11-02 | null | •••-••-6625 | 2427366336·· | N/A | 756 Central Ave | Orlando | FL | 32889 | null | N/A |
| PRV | PRV-29106 | 2026-05-22T10:02:16Z | CHERYL | — | JORDAN | Jun 6, 2003 | UHC-20575-37 | •••-••-4152 | 5728804657 | — | 9780 FOREST AVE | San Antonio | TX | 78296 | UNKNOWN | ·- |
| PRV | PRV-20754 | 2026-07-11T10:04:35Z | Jannifer | C. | Oliver | ·1972-06-16 | — | NULL | 660-692-0658 | JENNIFER.OLIVER9@OUTLOOK.COM | — | — | — | — | - | - |
| PRV | PRV-24519 | 2026-04-24T18:14:54Z | Jerry | — | Foster | 20-12-2005 | null | — | +1 264 913 5799 | ·- | 1403 Ridge Road | San Antonio | TX | ·78278 | - | OPTIONS-PPO |
| PRV | PRV-25590 | 2026-07-18T05:03:50Z | Martha | — | Gardner | 11/13/1995 | null | N/A | 4033281179 | — | 5940 Pine Drive | Columbus | OH | 43207 | — | — |
| PRV | PRV-20854 | 2026-09-23T03:09:54Z | WILLIE | — | WOODS | 2001-02-18 | - | — | 9468977509 | null | 6332 BROADWAY | PHOENIX | Arizona | 85019 | ·N/A | ·· |
| PRV | PRV-21091 | 2026-09-08T08:57:26Z | mari | — | munoz | 1974-05-22 | N/A | •••-••-4157 | (635) 717-9000 | — | 7712 Cedar Ln | Tempe | Arizona | 85257 | null | — |
| PRV | PRV-26525 | 2026-07-29T21:07:51Z | Kelly, Isabella | — | — | 19590225 | NULL | null | 4505933422 | ISABELLA.KELLY@AOL.COM | 2733 Sunset Blvd | Dallas | tx | — | — | — |
| PRV | PRV-23273 | 2026-07-02T00:00:11Z | MARIA | — | GRAY | 1994-12-02 | UHC-06693-16 | null | 329-500-2298 | — | ·7226 Lincoln Way | Charlotte | NC | 28208 | — | null |
| PRV | PRV-27453 | 2026-02-07T15:08:47Z | KAYLA | — | MARTIN | 1981-02-09 | — | NULL | (730) 388-2240 | KAYLA.MARTIN@PROTON.ME | 2860 SPRING ST | NASHVILLE | TN | 37218 | NULL | — |
| PRV | PRV-21626 | 2026-08-17T18:24:12Z | Vargas, Mark | — | — | 1982-06-13 | — | NULL | (638) 241-8379 | — | 7658 OAK ST | Phoenix | AZ | 85019 | — | — |
| PRV | PRV-28710 | 2026-02-09T23:39:27Z | ·Kathryn | — | Mendez | 06/22/1968 | UHC-53197-07 | — | +1 743 348 4944 | — | 7362 Maple Ave | TUCSON | AZ | 85782 | null | N/A |
| PRV | PRV-25902 | 2026-10-05T08:29:00Z | Cheryl·· | ·· | Ramos | 20000103 | NULL | null | — | CHERYL.RAMOS3@AOL.COM | 6590 Willow Ct | Columbus | OH | ·43221 | N/A | — |
| PRV | PRV-20174 | 2026-04-30T06:18:58Z | brandon | — | bryant | 1980-12-13 | UHC7804795 | •••-••-9574 | (953) 340-0231 | — | — | — | — | NULL | UNKNOWN | MEDICARE-ADV-B |
| PRV | PRV-26235 | 2026-03-06T13:19:00Z | JOYCE | — | — | 1989-12-12 | — | UNKNOWN | (242) 247-0655 | joyce.johnson61@yahoo.com | 5954 Central Ave | SAN DIEGO | CA | 92120 | null | - |
| PRV | PRV-20722 | 2026-08-22T13:41:02Z | Priya | — | James | 1999-02-25 | UHC-14750-42 | N/A | 345.293.5800 | priya.james@aol.com | 9288 SPRING ST #422 | Gilbert | AZ | 85272 | - | NULL |
| PRV | PRV-25924 | 2026-10-14T14:06:29Z | LAWRENCE | — | MARQUEZ | 1940-07-03 | UNKNOWN·· | null | 18333539312 | NULL | 4432 Broadway | Las Vegas | NV | 89129 | - | — |
| PRV | PRV-23739 | 2026-01-12T05:49:14Z | Bishop, Dorothy | — | — | Dec 12, 1975 | NULL | null | 774-458-3790 | null | 8850 Mesa Dr | Houston | ·TX | 77040 | NULL | NULL |
| PRV | PRV-28580 | 2026-05-09T14:51:44Z | Jensen | U | Austin | 19450806 | UNKNOWN | null | 3805063147 | — | 6006 Church Street | San Diego | CA | 92179 | N/A·· | - |
| PRV | PRV-21929 | 2026-05-26T23:27:06Z | Lori | — | Weber | 1995-02-02 | NULL | •••-••-6362 | UNKNOWN | lori.weber85@icloud.com | 432 Ridge Road | Plano | TX | ·75090 | — | SELECT-EPO |
| PRV | PRV-27493 | 2026-07-06T19:35:24Z | Alexander | — | Guerrero | 1960-11-25 | N/A | NULL | 638-569-9871 | UNKNOWN·· | N/A | — | — | UNKNOWN | — | CORE-HMO·· |
| PRV | PRV-26619 | 2026-04-25T04:18:46Z | CHHRISTIAN | ·· | LITTLE | 1980-06-27 | — | — | +1 523 396 7937 | N/A·· | 5811 Church St #309 | Orlando | FL | 32888 | N/A | - |
| PRV | PRV-20590 | 2026-05-13T19:01:22Z | MEI | — | ESTRADA | 91580613 | NULL | N/A | ·(986) 775-0981 | MEI.ESTRADA@GMAIL.COM | 8211 Church Street | Tempe | AZ | ·85267 | - | null·· |
| PRV | PRV-29275 | 2026-05-05T06:25:25Z | Arthur | — | Valdez | 1996-08-18 | UHC-18114-77 | null | 14296674000 | - | 8255 Ocean Avenue | Columbus·· | OH | NULL | NULL | NULL |
| PRV | PRV-22051 | 2026-02-24T04:26:34Z | Knight, Danielle | F.·· | — | 1957-08-19 | NULL | - | (899) 369-5753 | null | 8549 Jefferson Ave | GILBERT | AZ·· | 85220 | UNKNOWN | MEDICARE-ADV-B |
| PRV | PRV-21847 | 2026-02-07T19:25:20Z | sara | — | carter | Mar 8, 1945 | N/A | — | - | NULL·· | 4145 Lake View Road | Phoenix | AZ | 85097 | UNKNOWN | NAVIGATE-HMO |
| PRV | PRV-21634 | 2026-03-14T04:28:18Z | Bradley | — | Palmer | 1952-02-11 | UHC-68445-57 | ·· | +1 263 861 9542 | UNKNOWN | 2004 Jefferson Ave | Seattle | WA | 98139 | UNKNOWN | — |
| PRV | PRV-20406 | 2026-04-13T00:09:09Z | NANCY | ···· | GEORGE | 1946-06-28 | - | •••-••-3998 | 313-424-1295 | NULL | 6342 Forest Ave #511·· | Scottsdale | ·AZ | 85290 | ···· | — |
| PRV | PRV-22832 | 2026-09-21T11:24:05Z | Gabriel | — | Wagner | 1959-04-13 | ·· | •••-••-6779 | 4998731225 | GABRIEL.WAGNER35@OUTLOOK.COM | UNKNOWN | UNKNOWN·· | null | ···· | — | NULL |
| PRV | PRV-25572 | 2026-08-17T09:13:37Z | THERESA·· | — | AUSTIN | 22-09-1996 | UHC-47101-37 | ·- | 18906088000 | theresa.austin@hotmail.com | ·8576 CANYON RD | Mesa | AZ | 85245 | null | SELECT-EPO |
| PRV | PRV-22394 | 2026-04-07T20:02:43Z | rebecca | Z. | burns | 1988-10-20 | ·· | — | 8017363234 | rebecca.burns34@outlook.com | 3762 CEDAR LN | EDEN PRAIRIE | MN | — | — | CORE-HMO |
| PRV | PRV-22866 | 2026-01-17T06:25:32Z | ·Burton, Gary | L | — | 19631018 | — | UNKNOWN | 926-762-4480 | — | 9473 Harbor Boulevard | Tucson | AZ | NULL | null | — |
| PRV | PRV-23052 | 2026-03-25T12:43:27Z | Walter | — | Griffin | 1960-02-26 | — | UNKNOWN | (400) 734-1691 | walter.griffin42@outlook.com | 6093 Hillcrest Rd | Columbus | OH | ·43295 | UNKNOWN | - |
| PRV | PRV-29411 | 2026-05-31T10:33:29Z | Robinson, Ralph | — | — | 12/05/1952 | UHC-20956-92 | •••-••-0213 | 650-386-5457 | — | 5103 WILLOW COURT | Eden Prairie | Minnesota | 55349 | — | — |
| PRV | PRV-24359 | 2026-05-31T11:45:45Z | Randy | — | Meyer | Jul 26, 1984·· | UHC-39293-88 | - | (707) 261-9905 | - | 2773 MOUNTAIN VIEW DR | TUCSON | Arizona | 85753 | — | CHOICE-PLUS-PPO |
| PRV | PRV-24192 | 2026-05-15T07:57:35Z | DEBORAH | — | YANG | 8/28/1976 | UHC-58910-71 | •••-••-6290 | 7577520889 | deborah.yang3@outlook.com | 4152 Lincoln Way #696 | Orlando | FL | ·32843 | — | CHOICE-PLUS-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-19T19:54:25.421Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty