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-28525 | 2026-08-18T00:46:48Z | — | — | — | 10/6/1950·· | UHC-31579-16 | N/A | null | N/A | 588 VALLEY VIEW DR | JACKSONVILLE | FL | 32213·· | — | NULL |
| PRV | PRV-26756 | 2026-02-26T21:45:48Z | Ethan | — | ·Fernandez | Aug 5, 2000 | NULL | •••-••-3033 | — | ETHAN.FERNANDEZ73@ICLOUD.COM | 3381 Church St | San Diego | CA | 92166 | null | — |
| PRV | PRV-24170 | 2026-08-05T12:15:50Z | AAM | — | CHAPMAN | 1985-07-19 | UHC-28802-93 | — | (573) 961-9826 | N/A | 8709 Sage Court | Eden Prairie | MN | 55360 | — | UNKNOWN |
| PRV | PRV-24812 | 2026-09-22T19:00:04Z | Timothy | B | Freeman | 1992-07-09 | UHC-34025-60 | UNKNOWN | 931-696-6389 | ·null | null | NULL | null | null | NULL | N/A |
| PRV | PRV-28632 | 2026-09-12T06:15:29Z | ·KELLY | — | PERKINS | 04-10-2001·· | — | - | +1 375 444 2854 | KELLY.PERKINS@OUTLOOK.COM | 6401 Washington Street | Plano | TX | 75011 | UNKNOWN | NULL |
| PRV | PRV-20032 | 2026-07-17T09:36:21Z | Maria | Y. | Little | 19-05-1960 | UHC-54516-48 | UNKNOWN | NULL | — | ·1205 Hillcrest Rd #714 | DALLAS | TX | 75211 | - | ·null |
| PRV | PRV-25811 | 2026-06-04T06:25:41Z | vincent | — | tarn | Aug 14, 1989 | NULL | — | 483-981-7273 | - | 3950 Harbor Blvd | San Diego | CA | 92172 | null | ·CORE-HMO |
| PRV | PRV-27426 | 2026-10-01T13:22:55Z | MARTHA | — | WATSOON | 1976-12-23 | — | null | 696-651-7927 | MARTHA.WATSON@HOTMAIL.COM | 6159 Union Street | Eden Prairie | MN | 55365 | ···· | null |
| PRV | PRV-25078 | 2026-04-22T13:59:51Z | CHRISTINE | F | DAVIS | 1968-04-16 | null | •••-••-9943 | 948-727-7411 | NULL | 5608 LINCOLN WAY | Dallas | TX | 75252 | null | -·· |
| PRV | PRV-21013 | 2026-03-31T00:42:12Z | Harold | — | Adams | Apr 8, 1940 | N/A | •••-••-1704 | — | null | 2472 Spring Street | ATLANTA | GA | 30396 | N/A | N/A |
| PRV | PRV-23869 | 2026-03-12T17:47:00Z | Gloria | Y | Bowman | 19930705 | UHC-30916-26 | - | 727.744.2396 | - | 224 Forest Ave | Orlando | FL | 32819 | ·· | N/A |
| PRV | PRV-27420 | 2026-05-12T03:16:23Z | DAY·· | — | CATHERINE | 1943-07-04 | UHC0887572 | null | 698-727-7846 | catherine.day@hotmail.com | 5538 Grand Ave | Plano | TX | — | - | — |
| PRV | PRV-22351 | 2026-01-09T22:26:06Z | Madizon | — | Jordan | 1940-07-06 | null | •••-••-3238 | 6256031144 | — | 3870 Church Street Apt 12 | Chandler | AZ | 85281 | - | — |
| PRV | PRV-24446 | 2026-05-25T22:55:50Z | JACOB | — | BNAKS | 19880710 | — | — | 8488407 | ···· | 5849 Cedar Ln | Mesa | ·AZ | 85267 | NULL | UNKNOWN·· |
| PRV | PRV-21410 | 2026-05-18T15:34:42Z | GABRIEL·· | — | ROBINSON | 1952-09-09 | - | — | 982.477.9733 | gabriel.robinson32@aol.com | 9720 Desert Sky Boulevard | Nashville | TN | 37202 | — | N/A |
| PRV | PRV-26435 | 2026-05-14T18:49:52Z | Sandra | — | Franklin | ·2007-06-07 | UNKNOWN | •••-••-1607 | 551.494.1927 | null | 8987 Palm Drive | JACKSONVILLE | FL | ·32257 | — | — |
| PRV | PRV-25089 | 2026-09-14T03:37:48Z | Vasquez, Janet | — | — | 1945-02-20 | UHC-06138-79 | — | 6722671938 | null | 650 BAYSHORE DR | San Diego | CA | 92107 | — | N/A |
| PRV | PRV-22719 | 2026-03-24T13:36:14Z | SCOTT | B. | JOHNSTON | 06/01/91 | — | •••-••-3274 | UNKNOWN | scott.johnston@icloud.com | 8261 Pine Drive | San Diego | CA | 92181 | UNKNOWN | N/A |
| PRV | PRV-29353 | 2026-09-12T06:04:23Z | Lauren | — | Miller | 1991-09-18 | — | •••-••-5943 | — | — | 1142 RIVER ROAD | ·Denver | Colorado | 80281 | — | — |
| PRV | PRV-24382 | 2026-03-20T00:18:28Z | henry | — | stevens | 26-10-1970 | UHC-50709-36 | •••-••-1130 | (813) 894-2341 | HENRY.STEVENS80@AOL.COM | 9556 Sunset Boulevard | Eden Prairie | MN | 55343-9561 | null | ·UNKNOWN |
| PRV | PRV-24600 | 2026-03-18T06:21:34Z | ray | R | priya | 1962-05-28 | UNKNOWN | •••-••-0733 | UNKNOWN | - | 7268 Cedar Lane | GILBERT | AZ | 85287 | — | SELECT-EPO |
| PRV | PRV-25437 | 2026-04-09T08:48:18Z | dorothy | — | griffin | 19441226 | — | null | 4564782435 | — | 3855 Spring Street | Orlando·· | FL | 32886 | N/A | NAVIGATE-HMO |
| PRV | PRV-23981 | 2026-01-21T15:30:07Z | Andrea | — | Wilson | ·01/08/06 | N/A | UNKNOWN | ·(524) 818-1787 | andrea.wilson@aol.com | 4292 PINE DR | Tempe | Arizona | 85282 | null·· | — |
| PRV | PRV-25102 | 2026-09-12T02:44:23Z | Kathryn | L | Burke | 1952-10-06 | UHC3772705 | — | 18855054340 | — | 5009 GRAND AVE #402 | GLENDALE | AZ | 85394·· | N/A | — |
| PRV | PRV-20539 | 2026-09-28T22:17:42Z | Armstrong, Jordan | — | — | 1990-06-22 | - | UNKNOWN | 722-496-7167 | JORDAN.ARMSTRONG12@HOTMAIL.COM | 5162 Bayshore Dr Apt 35 | San Antonio | TX·· | 78276·· | — | — |
| PRV | PRV-24827 | 2026-01-10T10:11:37Z | beverly | — | sanchez | 10-11-1980 | UHC-76900-91 | — | 553-770-0961 | - | — | - | — | UNKNOWN | NULL | OPTIONS-PPO |
| PRV | PRV-28434 | 2026-06-23T10:10:41Z | Rebecca | W | Riley | 19680503·· | UNKNOWN | null | 2593428950 | — | NULL | null | — | - | - | — |
| PRV | PRV-20783 | 2026-02-19T05:39:07Z | Jarry | — | Haart·· | 1992-09-03 | UHC0098927 | - | (474) 943-0716 | UNKNOWN | 2072 PINE DR | Los Angeles | CA | 90053 | UNKNOWN | medicare-adv-a |
| PRV | PRV-24150 | 2026-08-21T15:14:06Z | Helen | — | Mitchell | 12/3/1956 | UHC-66688-12 | — | 276-579-6551 | HELEN.MITCHELL21@PROTON.ME | N/A | ·N/A | UNKNOWN | - | - | — |
| PRV | PRV-23770 | 2026-09-18T12:21:21Z | Ana | — | Rose | 1948-12-04 | UNKNOWN | ·NULL | (987) 572-4445 | ana.rose@hotmail.com | 21 Cedar Ln #835 | Columbus | OH | 43286 | — | - |
| PRV | PRV-28286 | 2026-01-14T17:30:05Z | Jason | R | Morgan | 2006-04-10 | UHC-31457-91 | •••-••-5109 | (504) 271-8566·· | null | 2752 Hillcrest Road | Tampa | FL | 33699 | null | -·· |
| PRV | PRV-24849 | 2026-01-20T21:21:37Z | CHRISTIAN | — | WHEELER | 05-12-1961 | UHC-52926-58 | •••-••-1132 | (317) 927-4242 | CHRISTIAN.WHEELER@PROTON.ME | 1245 CEDAR LANE | Seattle | WA | 98100 | N/A | NULL |
| PRV | PRV-20508 | 2026-07-14T02:20:27Z | Christina | — | Sandoval | 19831228·· | UHC-51663-15 | — | (671) 380-7910 | NULL | — | - | N/A·· | — | N/A | — |
| PRV | PRV-24442 | 2026-04-19T20:32:13Z | Grce·· | — | Jenkins | 1998-10-08 | UNKNOWN | •••-••-1388 | 6244733419 | N/A | 4259 Sage Court | Tampa | FL | 33608 | N/A | — |
| PRV | PRV-23725 | 2026-02-17T16:54:10Z | ethan | ·· | ross | 05/11/78 | — | — | 869-377-9501 | ETHAN.ROSS@AOL.COM | 1589 CENTRAL AVE | Jacksonville | FL | 32248 | null | — |
| PRV | PRV-23771 | 2026-10-14T17:23:19Z | Reid, Kayla | — | ···· | 12-09-2003 | null | ···· | 927.725.6579 | null | 2115 Market St | Sacramento | CA | 95845-8479 | — | — |
| PRV | PRV-21555 | 2026-02-13T09:09:19Z | Arjun | — | Bradley | 1959-04-16 | UNKNOWN | UNKNOWN | 741.957.3764 | ARJUN.BRADLEY39@PROTON.ME | 8435 Bayshore Drive | Gilbert | ·Arizona | — | - | - |
| PRV | PRV-22849 | 2026-01-21T17:46:17Z | MASON | — | WOOD | 2006-11-17 | N/A | — | ·3712343111 | NULL | 9111 Cedar Ln | SAN DIEGO | California·· | NULL | — | UNKNOWN |
| PRV | PRV-20001 | 2026-10-05T10:47:39Z | Laura | — | Alvarado | 1939-03-06·· | - | — | null | N/A | 4347 CHURCH ST Apt 36 | Plano | TX | 75086 | — | ·NAVIGATE-HMO |
| PRV | PRV-20616 | 2026-09-05T12:16:06Z | NANCY | — | CARR | 10/16/1981 | UHC-63787-77 | - | 3997255243 | nancy.carr91@proton.me | 489 MARKET STREET | Sacramento·· | CA | 95855 | N/A | ·navigate-hmo |
| PRV | PRV-20209 | 2026-02-27T14:45:33Z | Melissa | H. | Espinoza | 1953-11-24·· | N/A | NULL | N/A | — | 7482 Mesa Dr | GLENDALE | AZ | 85307 | null | ·NULL |
| PRV | PRV-20325 | 2026-08-01T01:25:31Z | Kimberly | — | Mejia | 1977-11-19 | — | — | ···· | — | 4850 Indian School Rd | Mesa | AZ | 85252-7856·· | - | N/A |
| PRV | PRV-21140 | 2026-08-11T08:16:53Z | Jeremy | — | Snyder | 1997-11-27 | UHC-72167-18 | — | — | null | 4178 Park Place | Jacksonville | FL | 32209 | null | - |
| PRV | PRV-22071 | 2026-08-03T02:07:52Z | Munoz, Joshua | — | — | 1994-01-20 | N/A | — | 221.459.4792 | joshua.munoz@gmail.com | 4852 Washington Street | Dallas | TX | — | — | ···· |
| PRV | PRV-25574 | 2026-06-28T16:11:33Z | Burns, Gary | K | — | 01/03/67 | null | null | 986-739-1788 | GARY.BURNS19@YAHOO.COM | 3058 Church St | ·MESA | AZ | 85212 | N/A | — |
| PRV | PRV-29131 | 2026-01-24T05:02:12Z | Bruce | T | Garrett | 07/12/62 | UHC-64079-01 | •••-••-0032 | — | — | 383 CENTRAL AVE | Miami | ·FL | 33114-6005 | - | OPTIONS-PPO |
| PRV | PRV-25713 | 2026-04-11T00:06:00Z | Walter Y | ·· | Richards | 1971-02-20 | - | NULL | 567-615-4464 | walter.richards@outlook.com | 1942 Highland Avenue | Chandler | az | 85251 | — | NULL |
| PRV | PRV-24866 | 2026-03-26T23:15:41Z | Jean | — | Vega | 19941010 | UHC-31783-01 | N/A | 512.981.5459 | ·· | 276 Market St | Los Angeles | CA | 90082 | — | UNKNOWN |
| PRV | PRV-21968 | 2026-04-12T23:21:25Z | Kenneth | R. | Hunter | 1970-02-17 | UHC-04666-05 | NULL | 431-596-8454 | null | 7067 INDIAN SCHOOL RD | Fresno·· | CA | 93789 | null | - |
| PRV | PRV-25855 | 2026-03-17T01:58:21Z | RIOS | — | MAOSN | 1939-11-04 | UHC-42367-40 | ·N/A | ···· | MASON.RIOS79@PROTON.ME | 2850 Valley View Dr·· | Tampa | FL | 33690 | 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:37.731Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty