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-27388 | 2026-09-30T19:13:08Z | MARY | ···· | OLSON | 1959-05-05 | UNKNOWN | — | 460-587-8102·· | ·· | — | null | null | UNKNOWN | — | null |
| PRV | PRV-22264 | 2026-05-07T09:50:04Z | PATRICK | — | GARCIA | 01-12-1998 | — | N/A | 2639086 | null | 1849 Ocean Ave | San Diego | CA | 92199 | N/A | — |
| PRV | PRV-24558 | 2026-05-24T19:10:38Z | AISHA | Q | HENDEERSON | 1986-02-18 | UHC2779306 | null | UNKNOWN | — | ·563 SPRING ST | SAN ANTONIO | Texas·· | 78287-3683 | — | - |
| PRV | PRV-23276 | 2026-03-07T15:46:12Z | BETH | V | RAY | 1/25/1992 | UHC-56495-72 | — | (623) 203-7637 | NULL | 7416 Oak St | Las Vegas | NV | 89186 | N/A | NULL |
| PRV | PRV-20632 | 2026-05-10T19:27:31Z | SANDRA | — | FREEMAN | 1995-01-01 | — | — | 781-596-2100 | sandra.freeman75@outlook.com | 3230 PINE DRIVE | Gilbert | AZ | NULL·· | null | — |
| PRV | PRV-23842 | 2026-03-10T17:19:58Z | Terry | ·· | Bowman | 2/1/1984 | UHC-58664-75 | •••-••-0548 | NULL | - | 3752 Lincoln Way | Glendale | AZ | 85372-8704 | - | CORE-HMO |
| PRV | PRV-28666 | 2026-04-22T01:15:58Z | Julia | — | Cooper | 2002-07-03 | UNKNOWN | •••-••-1985 | 423.877.4045 | UNKNOWN | 4654 CEDAR LANE | Tucson | Arizona | 85729 | — | MEDICARE-ADV-B |
| PRV | PRV-22456 | 2026-10-09T08:39:09Z | Sanchez, Mark | — | — | 1989-03-12 | UHC0808838 | — | 352-611-1154 | N/A | 7775 DESERT SKY BLVD·· | Columbus | Ohio | 43278 | NULL | null |
| PRV | PRV-25665 | 2026-09-27T09:28:09Z | ·bradley | J | reyes | 11/12/1949 | UHC3318194 | — | 8831363 | ·null | 7930 Harbor Blvd #578 | Glendale | AZ | 85330-5587 | — | ·· |
| PRV | PRV-22344 | 2026-05-11T00:16:04Z | Diego | — | Hill | 04/18/86 | UHC-71876-27 | ·null | (702) 285-3275 | - | 2197 CHURCH ST | SAN ANTONIO | TX | 78227 | - | UNKNOWN |
| PRV | PRV-27871 | 2026-07-15T23:04:32Z | Janice | — | Duncan | 2003-08-22 | null | UNKNOWN | 2125714493 | NULL | 1469 Central Avenue #758 | Los Angeles | ca | 90099 | N/A | NULL |
| PRV | PRV-20357 | 2026-04-20T13:20:40Z | Logan | — | Sims | 1982-02-26 | UNKNOWN | N/A | ·· | NULL | 539 MEADOW LANE | ·Houston | TX | 77006 | UNKNOWN | - |
| PRV | PRV-21564 | 2026-05-20T17:51:30Z | Marilyn | — | ·Nguyen | 1982-03-21 | UHC-42573-34 | — | (950) 596-8736 | null | UNKNOWN | UNKNOWN·· | NULL | NULL | — | ·· |
| PRV | PRV-29292 | 2026-10-08T01:45:56Z | DIEGO | — | PORTER | 11/14/1963 | UHC-80014-17 | — | 16764382224 | DIEGO.PORTER79@HOTMAIL.COM | 5795 Oak St | Nashville | TN | 37247 | — | — |
| PRV | PRV-29040 | 2026-05-15T03:19:24Z | CHRISTOPHER | — | YANG | 1961-08-27 | null | NULL | 8085075961 | NULL | 6043 CHURCH ST | Chandler | AZ | 85289 | null | - |
| PRV | PRV-23962 | 2026-09-06T18:01:52Z | Amber | — | ·Dean | 1961-02-19 | ·UHC-03303-76 | •••-••-2725 | ·+1 774 312 6836 | null | 2058 Sage Court | Mesa | AZ | 85253 | — | — |
| PRV | PRV-28484 | 2026-09-04T06:15:45Z | Watkins, Lucia | B | — | N/A | UHC-64281-09 | ·N/A | — | UNKNOWN·· | 952 Bayshore Drive | SCOTTSDALE | AZ | 85200 | - | — |
| PRV | PRV-27004 | 2026-01-16T06:02:00Z | ·Amy | — | Warren | 1940-12-08 | N/A | - | (750) 385-2602·· | ·amy.warren@aol.com | 8408 Palm Drive·· | Columbus | Ohio | 43208 | ·· | MEDICARE-ADV-B |
| PRV | PRV-20224 | 2026-06-24T07:25:18Z | patrick·· | — | robinson | 4/11/1977 | NULL | null | 277.645.6911 | null | 7387 Bayshore Drive·· | Sacramento | ca | 95862 | NULL·· | — |
| PRV | PRV-24682 | 2026-08-25T23:46:23Z | Carol | — | Phillips | 1977-12-05 | ·UNKNOWN | — | 626-588-2479 | NULL | 8747 Apache Boulevard | ·Plano | TX | 75076 | NULL | — |
| PRV | PRV-20383 | 2026-05-09T12:19:09Z | Peter | ···· | ·Robertson | 2003-07-16 | UHC-65809-32·· | •••-••-9725 | (894) 281-4396 | peter.robertson71@outlook.com | 3414 Broadway Apt 29 | Chandler·· | AZ | 85227·· | UNKNOWN | - |
| PRV | PRV-21979 | 2026-01-20T06:36:13Z | Ruth | — | Mason | 1990-01-14 | UNKNOWN | - | 755-801-2230 | - | 2577 Maple Ave | Eden Prairie | Minnesota | 55381-0278 | N/A | N/A |
| PRV | PRV-24436 | 2026-09-07T14:18:14Z | Michelle·· | ·L | Lee | 04-09-1942 | UHC-24537-63 | N/A | (207) 484-8993 | — | 182 Canyon Road | Los Angeles | CA | 90030 | UNKNOWN | - |
| PRV | PRV-25720 | 2026-08-14T12:59:52Z | Wei | — | Hamilton·· | 05/27/1938 | null | N/A | — | — | 4558 Cedar Lane | Plano | TX | — | UNKNOWN | - |
| PRV | PRV-26551 | 2026-09-27T21:01:08Z | SEAN | — | YANG | 1978-12-20·· | null | N/A | 6989019021 | - | 7871 Desert Sky Blvd | Miami | Florida | 33194·· | NULL | OPTIONS-PPO |
| PRV | PRV-27844 | 2026-02-17T09:14:59Z | Beth | — | Rodriguez | 1963-12-06 | UHC-01963-18 | NULL | (278) 715-0921 | elizabeth.rodriguez89@yahoo.com | 7374 SAGE COURT | Tampa | FL | N/A | - | NAVIGATE-HMO |
| PRV | PRV-24232 | 2026-07-31T14:49:03Z | Wright, Nancy | — | — | 1984-01-05 | — | NULL | 6073773218 | — | 1451 Grand Ave | Seattle | WA | 98111 | N/A·· | ···· |
| PRV | PRV-26094 | 2026-06-04T03:59:29Z | ZACHARY | — | PENA | 06-06-1950 | null | •••-••-9021 | 379-911-1696 | — | 5936 Willow Ct | Gilbert | AZ | 85240 | — | UNKNOWN |
| PRV | PRV-28316 | 2026-03-21T09:08:58Z | Yuki | — | Willis | 1985-12-25 | UHC-15526-71 | •••-••-3738 | 2988513348 | — | ·5308 Meadow Lane | Miami | FL | 33177 | — | — |
| PRV | PRV-22918 | 2026-09-06T06:15:50Z | Fatima | — | Simmons | 09-03-1999 | UHC-08560-99 | •••-••-6741 | — | fatima.simmons@aol.com | 388 Church St | ·Columbus | OH | 43239 | null | OPTIONS-PPO |
| PRV | PRV-21870 | 2026-04-09T16:26:24Z | MARCUS·· | — | TURNER | 12/07/74 | - | - | — | marcus.turner@outlook.com | 5655 BAYSHORE DR | Columbus | OH | 43262·· | — | null |
| PRV | PRV-22711 | 2026-02-12T07:32:43Z | justin | — | morgan | 1956-06-21 | ·UNKNOWN | — | 676-753-9937 | justin.morgan@proton.me | 4401 Desert Sky Blvd | TEMPE | AZ | 85233 | N/A | null |
| PRV | PRV-25916 | 2026-03-10T12:34:50Z | raymond | — | ortiz | 19650404 | NULL | •••-••-6131 | 8676294665 | N/A | 9314 Hillcrest Rd | Fresno | CA | 93776·· | ·null | — |
| PRV | PRV-22514 | 2026-08-01T03:52:50Z | ·JOAN | — | HANSON | 1970-10-28 | — | — | 3413620546 | - | 6881 GRAND AVENUE | Orlando | fl | ·32801 | — | — |
| PRV | PRV-20962 | 2026-08-12T17:28:56Z | Albert | — | Diaz | 18-10-1958 | UHC-79011-24 | N/A | (241) 709-4758 | N/A | 4675 MOUNTAIN VIEW DRIVE | SAN DIEGO | CA | 92173 | — | UNKNOWN |
| PRV | PRV-24787 | 2026-06-14T08:07:45Z | Steve | Q | Taylor | 19950119 | UHC-02047-87 | N/A | 7163258971 | — | 2493 Desert Sky Boulevard | Fresno | CA | 93781 | — | NULL |
| PRV | PRV-25336 | 2026-09-07T04:21:40Z | Frances | — | Hanson | 1989-05-10 | — | — | 870-357-6409 | N/A | 6548 Willow Court·· | Phoenix | AZ | 85041 | NULL | UNKNOWN |
| PRV | PRV-28595 | 2026-01-04T03:54:05Z | ANN | — | SIMS | 1992-02-16 | UHC-84909-39 | UNKNOWN | 402-950-7313 | ann.sims28@icloud.com·· | 2701 Pine Drive #847 | Gilbert | AZ·· | 85233 | — | — |
| PRV | PRV-20669 | 2026-01-12T01:25:09Z | sofia | — | day | 1938-07-28 | UNKNOWN | UNKNOWN | (463) 859-5313 | UNKNOWN | 2714 Ocean Ave | Chandler | Arizona | 85245-0389 | — | NAVIGATE-HMO |
| PRV | PRV-27845 | 2026-04-01T22:15:16Z | Elizabeth | — | Rodriguez | 1963-12-06 | N/A | UNKNOWN | 12787150921 | NULL | 7374 Sage Ct | Tampa | FL | 33602 | — | — |
| PRV | PRV-27350 | 2026-01-14T03:46:03Z | Alvarado, Brittany | — | ···· | 1991-09-17 | UHC-89357-17 | UNKNOWN | 597-582-6766 | null | 7794 Baseline Road | Phoenix | AZ | 85044·· | — | ·SELECT-EPO |
| PRV | PRV-27400 | 2026-03-28T10:07:32Z | Steve | — | Coleman | 1943-09-27 | UHC-69122-85 | •••-••-3465 | 8993892300 | null | 4640 Ocean Avenue | MESA | AZ | 85230 | ·N/A | null |
| PRV | PRV-24395 | 2026-10-11T02:23:22Z | ·eugene | — | moreno | ·1942-03-06 | N/A | NULL | (246) 972-0952 | eugene.moreno@aol.com | 3932 Baseline Rd | Phoenix | AZ | 85059 | UNKNOWN | — |
| PRV | PRV-21878 | 2026-09-20T12:00:21Z | Jerry·· | — | Kelley | 11/04/65 | UNKNOWN | •••-••-5348 | ·2639341075 | NULL | 6586 Park Pl #675 | Scottsdale | AZ | 85220 | - | MEDICARE-ADV-A |
| PRV | PRV-29202 | 2026-07-19T20:44:34Z | NICOLE | — | RICE | null | — | — | 19634760847 | NULL | 735 Mesa Drive | Denver | co | 80260·· | -·· | CHOICE-PLUS-PPO |
| PRV | PRV-22852 | 2026-01-29T14:37:52Z | Aisha | — | Sttewart | 1943-12-10 | null | ·· | (652) 385-7271 | null | 2865 Apache Boulevard | Chandler | AZ | 85291-1891 | UNKNOWN | — |
| PRV | PRV-28785 | 2026-05-10T14:47:47Z | mateo | — | gardner | 1991-11-03 | UHC-88333-70·· | — | UNKNOWN | mateo.gardner@proton.me | 2185 MARKET STREET | Minneapolis | MN | 55468 | — | - |
| PRV | PRV-24155 | 2026-03-04T09:11:30Z | BRIAN | I | OLSON | 12/23/1998 | null | •••-••-9694 | (536) 427-6399 | brian.olson@icloud.com | 8779 Bayshore Drive | Jacksonville | FL | 32216 | - | — |
| PRV | PRV-29083 | 2026-04-03T04:40:43Z | Pamela | Z. | Bailey | 1976-09-06 | UHC-35929-69 | — | 467-760-2086·· | NULL | 3492 MEADOW LN | ·Eden Prairie | MN | 55373 | UNKNOWN | - |
| PRV | PRV-27894 | 2026-10-09T01:07:17Z | ·ELIJAH | — | WEAVER | 12/01/1954 | - | — | 2403286 | - | null·· | - | ·null | 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:43.425Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty