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-20755 | 2026-10-11T19:10:29Z | Albart | ·· | Myers | 3/1/1959 | — | •••-••-7727 | — | UNKNOWN | 2650 Mountain View Drive | Denver | CO·· | 80224 | — | UNKNOWN |
| PRV | PRV-29016 | 2026-02-18T19:31:34Z | Brittany | E | Wells | 2001-01-14 | — | •••-••-4574 | null | — | 1690 Jefferson Ave | AUSTIN | Texas | NULL | - | N/A |
| PRV | PRV-24434 | 2026-01-01T06:15:13Z | teresa | — | harrison | 27-01-2007 | — | NULL | ·UNKNOWN | TERESA.HARRISON@PROTON.ME | 1781 Harbor Boulevard | San Antonio | TX | 78294 | N/A | UNKNOWN·· |
| PRV | PRV-25147 | 2026-09-17T04:54:32Z | roger | — | edwards | 2002-10-01 | UHC-27243-62 | — | 18782199861 | N/A·· | 7296 UNION ST | TEMPE | AZ | 85298 | — | — |
| PRV | PRV-27701 | 2026-07-07T13:08:53Z | LOGAN | ·· | LUCAS | 19740921 | UHC-41254-21 | UNKNOWN | 6882130 | — | 6921 Harbor Blvd | Plano | TX | 75041 | NULL | — |
| PRV | PRV-28014 | 2026-06-05T22:11:53Z | Austin | R | Medina | 1954-03-06 | uhc-50918-06 | UNKNOWN | 802-709-8372 | austin.medina@hotmail.com | 4470 Main St Apt 26 | Fresno | ·CA | 93780 | — | — |
| PRV | PRV-23592 | 2026-02-06T20:27:42Z | Judy | — | Jimenez | 2006-07-10 | UHC-73726-15 | ·NULL | 373-997-4886 | JUDY.JIMENEZ26@PROTON.ME | ·4481 Camelback Road | TAMPA | fl | 33619 | null | UNKNOWN |
| PRV | PRV-24009 | 2026-08-04T22:15:02Z | Dennis | — | Spencer | 1993-03-21 | — | — | 250-598-4817 | — | 230 SUNSET BOULEVARD | AUSTIN | TX | 78739 | NULL | NULL |
| PRV | PRV-20861 | 2026-02-16T08:12:48Z | Nicholas | — | Roberts | 1977-11-15 | UHC-36764-94 | null | 3723946636 | NULL | 5876 Pine Dr | San Diego | California | NULL | - | MEDICARE-ADV-B |
| PRV | PRV-22804 | 2026-04-24T16:05:56Z | Barb | — | Hansen | 1980-06-28 | UHC-50547-71 | N/A | (965) 663-5875 | NULL | 8572 Bayshore Dr | Dallas | TX·· | 75218 | — | ···· |
| PRV | PRV-26863 | 2026-03-20T20:23:37Z | Cynthia | — | Nunez | 1966-08-17 | UNKNOWN | — | 311-915-5397 | — | — | N/A·· | — | ·N/A | — | N/A |
| PRV | PRV-24576 | 2026-04-19T16:20:07Z | Vincent | — | Bishop | 1941-07-16 | UHC-65761-48 | — | 224.506.9724 | UNKNOWN | ·6350 JEFFERSON AVENUE | Charlotte | NC | ·28215 | N/A | UNKNOWN |
| PRV | PRV-23014 | 2026-06-12T22:02:06Z | Chapman, Martha | O. | — | 1938-04-06 | — | - | N/A | ·MARTHA.CHAPMAN98@PROTON.ME | 1455 Mountain View Dr | Tempe | AZ | 85218 | UNKNOWN | NULL |
| PRV | PRV-28940 | 2026-05-02T14:49:48Z | Frances | — | Powell | 1968-11-17 | UHC-90782-54 | UNKNOWN | 644.288.7489 | null | 7489 Sunset Boulevard | FRESNO | CA | 93710-2600 | NULL | CORE-HMO |
| PRV | PRV-24571 | 2026-01-16T13:21:26Z | kevin·· | — | austin | 1961-08-28·· | uhc-21846-45 | •••-••-6635 | 495.642.8308 | ·null | 5743 Union Street | Scottsdale | AZ | 85270 | null | null |
| PRV | PRV-27084 | 2026-05-28T04:39:05Z | Debra | — | Hanson | 05/14/52 | UHC-88261-03 | NULL | — | null | 2273 Main Street | San Diego | CA | 92196 | NULL | — |
| PRV | PRV-26415 | 2026-01-22T14:16:02Z | Donald | V | Rojas | Feb 18, 1981 | UHC-71744-36 | ···· | 6118929310 | ·UNKNOWN | 3130 Grand Avenue | Charlotte | NC | 28277 | - | OPTIONS-PPO |
| PRV | PRV-26285 | 2026-09-17T00:00:33Z | Riley | I | Marcus | 12/07/1963 | UHC-91091-69·· | — | (825) 655-8062 | MARCUS.RILEY45@OUTLOOK.COM | 7986 Union St | Los Angeles | California | 90099 | null | N/A |
| PRV | PRV-22830 | 2026-04-11T06:02:09Z | ·CHERYL | — | DANIELS | 1974-11-24 | UHC-88831-98·· | •••-••-4613 | 926-387-9492 | cheryl.daniels27@hotmail.com | 5417 PALM DRIVE | Fresno | CA | 93782·· | ·null | MEDICARE-ADV-A |
| PRV | PRV-20852 | 2026-01-10T07:28:03Z | Johhn | R | Ferguson | 1940-02-16 | UHC-93817-92 | •••-••-2468 | (580) 618-1576 | JOHN.FERGUSON4@OUTLOOK.COM | 3561 Ocean Avenue | Los Angeles | CA | 90042 | — | — |
| PRV | PRV-21366 | 2026-03-14T18:38:43Z | Walker, Karen | — | — | 19650819 | UHC-57736-99 | •••-••-7724 | 445-539-6447 | ·· | 8920 Grand Avenue | Denver | CO | ·80288 | ···· | MEDICARE-ADV-B |
| PRV | PRV-22570 | 2026-09-07T13:57:07Z | ·Elijah | — | Vega | 08-05-1948 | — | •••-••-9808 | 340-504-2350 | NULL | 925 SPRING STREET | Chandler | AZ | 85215 | UNKNOWN | NULL |
| PRV | PRV-28317 | 2026-08-09T22:20:30Z | Berry, Frances | — | — | 08-02-1968 | UHC-64195-37 | — | null | frances.berry@gmail.com | 384 HIGHLAND AVE | Minneapolis | MN | 55406 | N/A | NULL |
| PRV | PRV-26482 | 2026-10-10T19:09:11Z | Gerald | H. | Wagner | 19810611 | UHC-78476-36 | null | NULL | GERALD.WAGNER77@ICLOUD.COM | - | - | - | NULL | - | UNKNOWN |
| PRV | PRV-27057 | 2026-09-20T18:17:06Z | Nguyen, Aaron | — | — | 01/03/80 | UHC-97529-09 | ···· | 264-493-4696 | ·· | 7123 Baseline Road | Minneapolis | ·MN | 55418 | NULL | UNKNOWN |
| PRV | PRV-26180 | 2026-02-06T07:53:30Z | Doris | W. | Santiago | 1986-07-04 | UHC-85136-97 | •••-••-9129 | 758-881-6808 | - | 6004 Forest Ave | Tucson | Arizona·· | 85771 | null | — |
| PRV | PRV-23705 | 2026-06-23T04:42:59Z | ·George M. | — | Padilla | 2005-01-20 | UHC-53198-74 | — | (941) 730-4308 | george.padilla51@hotmail.com | 7600 VALLEY VIEW DRIVE | Charlotte | NC | 28274 | UNKNOWN | null |
| PRV | PRV-27929 | 2026-02-12T03:47:22Z | Barb | — | Carr | 2000-03-19 | UHC7142935 | •••-••-9518 | 5953887054 | NULL | NULL | UNKNOWN | UNKNOWN | null | NULL | — |
| PRV | PRV-28571 | 2026-08-25T17:31:22Z | ashley | — | walllace | 1961-07-08 | — | •••-••-3117 | (847) 806-4359·· | ashley.wallace31@outlook.com | 2406 CHURCH ST | Tucson | ·AZ | ·85772 | — | - |
| PRV | PRV-23947 | 2026-05-23T18:24:01Z | Carlos | — | Le | 1944-10-15 | UHC-07359-80 | - | 5644707042 | NULL | 7655 Lake View Rd | Charlotte·· | NC | 28252 | - | — |
| PRV | PRV-29351 | 2026-09-25T13:47:33Z | ward | — | henry | 1939-03-06 | UHC-63253-17 | - | (422) 499-5123 | NULL | 2753 Sunset Blvd | San Diego | CA | 92160 | - | NULL |
| PRV | PRV-21429 | 2026-07-28T12:04:34Z | Josh | — | Castro | 2008-03-20 | null | — | 616.599.4210 | JOSHUA.CASTRO@PROTON.ME·· | 5488 Union St | Denver | Colorado | 80218 | UNKNOWN | ···· |
| PRV | PRV-25522 | 2026-10-11T16:32:24Z | John | N. | Santiago | 19581020 | — | UNKNOWN | 932-960-6619 | N/A | 4038 SAGE CT | Minneapolis | mn | 55489 | N/A | NULL |
| PRV | PRV-27830 | 2026-09-24T16:34:32Z | RUTH | — | SPENCER | 2002-07-12 | — | — | (478) 843-2334 | - | 1966 Main Street | Tempe | AZ | 85241-9282 | UNKNOWN | N/A |
| PRV | PRV-21036 | 2026-02-21T04:31:02Z | Owens, Brenda | — | — | 1949-10-19 | — | — | ·(446) 309-2832 | N/A | 729 BROADWAY | Plano | TX | 75070 | — | NAVIGATE-HMO |
| PRV | PRV-26241 | 2026-08-21T14:13:34Z | HELEN | — | — | 1991-05-18 | UHC-00390-60 | — | 678-207-5902 | - | 5356 Oak Street | DALLAS | ·TX | 75217 | — | SELECT-EPO |
| PRV | PRV-23656 | 2026-06-22T01:33:17Z | Eric | — | Pierce | 2003-11-02·· | UHC-40910-11 | •••-••-7822 | 5116032279 | eric.pierce83@gmail.com | 6563 SAGE CT | Chandler | AZ | 85292 | — | MEDICARE-ADV-A |
| PRV | PRV-23236 | 2026-03-24T12:27:52Z | ·dorothy | T. | richardson | 1940-87-07 | UHC-54546-12 | •••-••-3796 | 6337116 | null·· | 1505 CAMELBACK RD | Seattle | Washington | 98192 | — | N/A |
| PRV | PRV-23634 | 2026-05-20T12:21:45Z | Noah | E | ·Sims | 05/14/02 | UHC-54449-78 | NULL | NULL | noah.sims86@hotmail.com | 7793 HARBOR BOULEVARD | Chandler | Arizona | 85215 | — | — |
| PRV | PRV-25329 | 2026-05-07T17:34:00Z | DEBRA | — | HUDSON | 1999-06-22 | UHC-37158-60 | — | (641) 531-1118 | debra.hudson@outlook.com | 8828 UNION STREET | Atlanta | GA | 30327 | N/A | - |
| PRV | PRV-22073 | 2026-08-30T17:50:39Z | Hawkins, Jennifer | — | — | 1943-07-14 | ·UHC-46500-91 | •••-••-8009 | 790-611-3647 | — | 1107 Lake View Road | Denver | CO | 80266 | null | - |
| PRV | PRV-25626 | 2026-02-13T13:48:10Z | ANTHONY | F. | FERNANDEZ | ·1950-07-04 | UNKNOWN | •••-••-6888 | (757) 549-1957 | anthony.fernandez@gmail.com | 899 River Road | Jacksonville | ·FL | 32254 | UNKNOWN | SELECT-EPO |
| PRV | PRV-22125 | 2026-04-15T10:50:19Z | ·Diane | ·· | Alvarez | 1998-06-11 | UNKNOWN | UNKNOWN | 358.552.0249 | diane.alvarez@gmail.com | 7578 CENTRAL AVENUE | Plano | TX | 75055 | UNKNOWN | — |
| PRV | PRV-27806 | 2026-06-26T05:27:38Z | Dnise | — | Santos | 1202-10-05 | UHC-49411-48 | N/A | NULL | — | 5029 Jefferson Avenue | Columbus | OH | 43255 | NULL | null |
| PRV | PRV-26896 | 2026-06-24T12:57:05Z | Jeffrey | — | Gutierrez | 2001-02-05 | UHC-79792-52·· | — | 530-450-6803 | JEFFREY.GUTIERREZ@OUTLOOK.COM | 8454 FOREST AVE | Dallas | TX | 75288 | null | N/A |
| PRV | PRV-25883 | 2026-09-21T19:53:51Z | ADAM | T | DIXON | 07/03/74 | UHC-43173-48 | •••-••-8847 | 3246179309 | ADAM.DIXON@GMAIL.COM | 1990 MESA DR | Tempe | Arizona | 85257 | NULL | — |
| PRV | PRV-23443 | 2026-08-18T23:43:37Z | ·Elliott, Cynthia | P | — | 19610213 | - | NULL | 8385030086 | null | 8657 Mountain View Dr | San Diego | CA | 92172 | — | UNKNOWN |
| PRV | PRV-26041 | 2026-01-02T15:57:06Z | Greene, Donna | — | — | ·1989-01-17 | — | UNKNOWN | (856) 860-9815 | N/A | 5500 Hillcrest Rd | SAN DIEGO | CA | 92179·· | — | N/A |
| PRV | PRV-28621 | 2026-10-05T08:46:13Z | Michelle | ···· | Lynch | 1944-05-17 | ·NULL | UNKNOWN | — | NULL | 7066 Central Ave | JACKSONVILLE | FL | 32227 | — | — |
| PRV | PRV-27619 | 2026-08-07T13:15:08Z | BRUCE | O | BRADLEY | 1979-12-26 | — | — | — | — | — | UNKNOWN | — | NULL | ···· | 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:46.423Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty