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-24379 | 2026-07-28T05:13:28Z | Kathryn | T. | Gonzalez | 1988-08-13 | ·NULL | — | — | — | 4472 MAIN STREET | Minneapolis | MN | 55483 | — | N/A |
| PRV | PRV-21653 | 2026-09-04T06:52:02Z | Vazquez, Bradley | — | — | Jan 7, 1944 | - | UNKNOWN | +1 279 973 7529 | null | 9117 Meadow Ln | ATLANTA | GA | 30368 | — | N/A |
| PRV | PRV-20483 | 2026-07-15T18:01:28Z | MARK | — | ·RYAN | 12-07-1964 | ·UHC-13819-28 | — | 9753254922 | mark.ryan@icloud.com | 3174 Harbor Boulevard | Los Angeles | CA | ·90047 | - | UNKNOWN |
| PRV | PRV-27183 | 2026-07-14T21:45:18Z | joe | — | bishop | 1988-10-18 | - | •••-••-9752 | +1 527 915 4620 | joe.bishop@icloud.com | 6422 Harbor Boulevard·· | Nashville | TN | 37273 | null | CORE-HMO |
| PRV | PRV-23355 | 2026-04-26T10:00:04Z | Ramos, Kayla | L | — | 06/04/1946 | — | UNKNOWN | ·14414144068 | — | 7515 MARKET ST | Charlotte | NC | 28233 | N/A | UNKNOWN |
| PRV | PRV-27556 | 2026-07-31T11:39:14Z | Perkins, Wayne | — | — | 1943-09-07 | UHC-83686-34 | UNKNOWN | 9098771961 | wayne.perkins@aol.com | 5373 Highland Ave | Mesa | AZ | 85212 | UNKNOWN | N/A |
| PRV | PRV-23083 | 2026-02-20T16:04:11Z | bobby | — | henderson | 1995-04-15 | UHC-70285-55 | — | 5709873670 | null | 9539 Mesa Drive | LOS ANGELES | California | 90027·· | — | NULL |
| PRV | PRV-29266 | 2026-10-02T04:24:56Z | Garbiel | — | Gilbert | ·1987-01-10 | — | ·null | 691-319-9613 | — | 9797 River Road | Tucson | AZ | 85723 | N/A | — |
| PRV | PRV-26169 | 2026-06-27T13:21:01Z | SARAH | — | MORRIS | 1994-05-08 | null | N/A | 14496500273 | UNKNOWN | — | — | - | N/A | ·NULL | — |
| PRV | PRV-28821 | 2026-04-08T04:15:20Z | CAROL | — | ·AGUILAR | 06/17/1981 | UHC-79105-60 | •••-••-3862 | 7134119036 | carol.aguilar98@proton.me | N/A | - | null | — | - | — |
| PRV | PRV-21360 | 2026-06-13T00:44:35Z | Charles | — | Rice | 1968-08-21 | UHC-28560-68 | •••-••-8707 | (818) 218-4863 | charles.rice@proton.me | N/A | null | UNKNOWN | — | UNKNOWN | — |
| PRV | PRV-25207 | 2026-09-06T21:35:05Z | fatima | — | daniels | 2007-06-08 | UHC-51636-63 | — | (659) 938-2100 | — | 500 Desert Sky Boulevard #185 | Plano | TX | null | - | null |
| PRV | PRV-29547 | 2026-04-29T05:09:58Z | AMBER | ···· | GRIFFIN | 1939-12-09 | — | — | +1 406 891 4367 | amber.griffin@icloud.com | 6088 Desert Sky Boulevard | San Diego | CA | 92193 | - | null |
| PRV | PRV-26869 | 2026-03-03T04:51:10Z | Denise | — | Vargas | 10/23/1949 | UNKNOWN·· | — | 6146730135 | DENISE.VARGAS@YAHOO.COM | 4158 CENTRAL AVENUE·· | NASHVILLE | TN | 37205 | ···· | - |
| PRV | PRV-22336 | 2026-05-29T20:10:38Z | Long, Tlyer | — | — | 4/15/1981 | NULL | - | 417-517-7821 | — | 277 JEFFERSON AVENUE | DALLAS | TX | 75286 | — | — |
| PRV | PRV-26377 | 2026-09-08T16:19:41Z | — | — | — | 2003-11-26 | - | NULL | null | UNKNOWN | 1900 Ocean Avenue | Charlotte | NC | 28251 | null | — |
| PRV | PRV-28963 | 2026-08-15T06:06:50Z | EDWERD | — | HICKS | 1989-04-06 | UHC-50339-17 | NULL | 654.548.4363 | N/A | 3192 MESA DR | Columbus | OH·· | 43209 | — | null |
| PRV | PRV-25933 | 2026-03-01T01:36:28Z | WEI | ·· | WALKER | 14-05-1976 | UHC-30724-80 | UNKNOWN | 700-405-2828 | wei.walker67@yahoo.com | ·N/A | - | N/A | - | N/A | UNKNOWN |
| PRV | PRV-28737 | 2026-05-05T09:23:42Z | Lauren | — | Sullivan | 1938-07-08 | NULL | — | 824-926-8872 | null | 6489 OAK ST | Seattle | WA | 98189 | — | — |
| PRV | PRV-24956 | 2026-08-06T16:23:20Z | ·Logan | — | ·Green | 1972-01-18 | NULL | •••-••-8320 | (513) 446-7856 | — | 32 Willow Ct | Chandler | AZ | 85266 | NULL·· | NULL·· |
| PRV | PRV-22103 | 2026-07-23T03:06:30Z | Kelly, Mateo | — | — | ·1947-07-10 | null | null·· | 4894443862 | UNKNOWN | N/A | null | N/A | UNKNOWN | null | N/A |
| PRV | PRV-29588 | 2026-03-10T02:54:51Z | Valentiina | H. | Jacobs | 1974-08-06 | UNKNOWN | NULL·· | 8957016616 | NULL | — | null | — | — | UNKNOWN | CORE-HMO·· |
| PRV | PRV-24277 | 2026-09-30T15:05:17Z | henry | — | ·pierce | 2006-12-27 | UHC-37182-32 | UNKNOWN | (261) 281-4971 | null | 1170 Camelback Road | Jacksonville·· | FL | 32208 | — | - |
| PRV | PRV-20809 | 2026-09-29T14:39:44Z | PAMELA | — | FIELDS | Apr 12, 1988 | - | — | — | N/A | 9331 SPRING ST | Charlotte | North Carolina | - | null | — |
| PRV | PRV-27419 | 2026-04-20T00:30:09Z | Brittany | — | Pierce | 19961111 | UHC-41280-08 | NULL | null | NULL | 2934 Highland Ave | Austin | TX | N/A | — | NAVIGATE-HMO |
| PRV | PRV-20269 | 2026-06-19T06:29:34Z | SCOTT | — | ALEXANDER | 1938-02-10 | ·UHC-45983-33 | — | +1 401 991 6993 | scott.alexander31@proton.me | 6524 Lincoln Way | Glendale | Arizona | 85392 | - | - |
| PRV | PRV-21827 | 2026-09-21T16:58:55Z | BRITTANY | — | ROBINSON | 1966-08-08 | UHC-17369-36 | NULL | 17726091297 | — | 521 Lincoln Way | AUSTIN | TX | 78797-8236·· | — | — |
| PRV | PRV-28658 | 2026-07-27T02:18:30Z | CAROL | — | DUNCAN | 1943-10-11 | — | N/A | (603) 904-7913 | carol.duncan11@gmail.com | ·9468 Forest Ave | SCOTTSDALE | AZ | 85254 | — | UNKNOWN |
| PRV | PRV-27446 | 2026-09-17T20:23:29Z | ·PATRICK | ·· | COLLINS | 11/27/1974 | — | - | (730) 839-1245 | — | 1406 Maple Avenue | Jacksonville | fl | 32222 | N/A | — |
| PRV | PRV-25415 | 2026-09-15T11:15:55Z | Kathleen | — | Owens | 1956-02-10 | null | — | 763-702-2018 | - | ·NULL | NULL | - | UNKNOWN | NULL | MEDICARE-ADV-A |
| PRV | PRV-27608 | 2026-06-09T14:27:24Z | Douglas | B | Sims | 1987-01-18 | UHC-75923-17 | — | 4536588 | - | — | NULL | N/A | UNKNOWN | - | UNKNOWN |
| PRV | PRV-21489 | 2026-07-15T00:53:21Z | debra | — | ·park | 01/10/1957 | N/A | N/A | 6353207478 | DEBRA.PARK@PROTON.ME | 2847 Spring St | Glendale | AZ | 85369 | N/A | ·N/A |
| PRV | PRV-27616 | 2026-02-21T13:32:48Z | RICHARD | — | ALVAREZ | 19520820 | UHC-56524-96 | — | 285-245-2763 | richard.alvarez6@icloud.com | 7885 Sunset Boulevard | PHOENIX | AZ | 85080 | — | null |
| PRV | PRV-25633 | 2026-04-02T13:44:52Z | — | — | — | 03/22/2002 | -·· | — | 5712478 | cheryl.wells33@proton.me | 4094 Apache Blvd | Los Angeles | California·· | 90085 | UNKNOWN | NULL |
| PRV | PRV-28749 | 2026-09-04T15:03:25Z | Johnson, Frank | H. | — | 1975-03-06 | UHC-56150-34 | null | 656-613-2714 | frank.johnson99@outlook.com | 925 Spring St | GILBERT | AZ·· | 85274 | ·· | — |
| PRV | PRV-24450 | 2026-07-04T12:15:26Z | Lisa | — | Cruz | ·2000-07-10 | null | •••-••-6321 | (258) 318-1027 | - | 6093 Hillcrest Road | Scottsdale | AZ | ·85208 | - | — |
| PRV | PRV-22036 | 2026-06-04T20:02:19Z | Ralph | — | Taylor | 1985-07-21 | UNKNOWN | - | - | UNKNOWN | 1559 BROADWAY | Las Vegas | NV | 89136 | null | — |
| PRV | PRV-20572 | 2026-04-21T09:11:35Z | Grannt, Sarah | D | ···· | 1999-01-04 | UHC-93690-53 | — | 354-323-3551 | SARAH.GRANT@AOL.COM | 4672 Canyon Rd | Minneapolis | MN | 55413 | — | SELECT-EPO |
| PRV | PRV-20379 | 2026-02-08T10:52:47Z | Brown, Donald | J | — | 2007-05-16 | UHC-36042-29 | — | 5009602474 | donald.brown@yahoo.com | UNKNOWN | null·· | UNKNOWN | UNKNOWN | — | — |
| PRV | PRV-20193 | 2026-04-22T02:01:07Z | WALSH | — | WILLIE | 01/26/1959 | NULL | UNKNOWN | 2414327954 | — | 4995 Broadway | LOS ANGELES | CA | 90095 | ·· | OPTIONS-PPO |
| PRV | PRV-28762 | 2026-03-05T14:28:06Z | BRUCE | — | GARZA | 11/15/1948 | UHC-00733-12 | •••-••-8594 | 7333245407 | NULL | 3302 Jefferson Ave | Plano·· | TX | 75014 | UNKNOWN | — |
| PRV | PRV-25267 | 2026-01-02T14:35:16Z | Jose | — | Scott | 19790502·· | — | •••-••-4784 | +1 791 545 2789 | jose.scott14@hotmail.com | 1716 Ridge Rd | Nashville | ·Tennessee | 37283 | — | - |
| PRV | PRV-20935 | 2026-07-10T07:13:44Z | RONALD | F | JOHNSTON | 2002-02-06 | ·UHC-85701-34 | ·- | 7759028505 | — | ·9032 Ocean Ave | San Antonio | TX | 78294 | UNKNOWN | - |
| PRV | PRV-24457 | 2026-05-01T13:56:24Z | Aaron | — | Evans | 1944-06-16 | — | •••-••-8884 | (693) 536-5422 | — | 2320 Central Ave #426 | Austin | TX | 78753·· | UNKNOWN | -·· |
| PRV | PRV-23921 | 2026-03-09T06:44:04Z | ·Stephen | — | Hansen | 1939-05-11 | — | NULL | +1 754 359 8589 | N/A | 8089 Pine Dr | FRESNO | California | 93739 | — | null |
| PRV | PRV-20925 | 2026-08-23T20:05:32Z | george | — | willis·· | 1939-10-03 | UHC-36586-64 | •••-••-1573 | (775) 448-6801 | ·GEORGE.WILLIS47@HOTMAIL.COM | 4974 MAPLE AVE #728 | Phoenix | AZ | 85076-2854 | NULL | N/A |
| PRV | PRV-27536 | 2026-10-10T22:23:16Z | CHARLES | — | MORALES | 7/6/1996 | N/A | N/A | 884-369-6264 | — | 1061 Mesa Dr | ·Charlotte | NC | 28244 | — | — |
| PRV | PRV-24623 | 2026-02-18T02:10:46Z | DYLAN | — | HUDSON | 2005-07-01 | UHC-06408-75 | — | (452) 806-9089 | UNKNOWN | 3085 Camelback Rd | Fresno | CA | 93777 | NULL | UNKNOWN |
| PRV | PRV-24165 | 2026-04-10T02:55:02Z | Carlos | — | Lucas | 1965-04-04 | UHC-26021-69 | ·- | NULL | — | null | null | — | — | — | OPTIONS-PPO·· |
| PRV | PRV-28991 | 2026-06-03T12:36:41Z | Judith | — | Morgan | 1942-21-17 | UHC-85227-49 | ·- | 4493674179 | judith.morgan80@gmail.com | 112 Meadow Ln #869 | Chandler | AZ | 85223 | UNKNOWN | - |
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.462Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty