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-20928 | 2026-06-18T23:41:08Z | linda | — | spencer | 1966-09-16 | NULL | •••-••-7429 | 3328480395 | N/A | 6260 RIDGE ROAD | Tucson | AZ | ·85787 | — | - |
| PRV | PRV-25832 | 2026-03-07T04:27:25Z | Kimberly·· | W | Henderson | 2/1/1980·· | UHC-76058-16 | •••-••-7924 | 450-911-1685 | — | 5226 Desert Sky Boulevard | Austin | Texas | ·78772 | — | null·· |
| PRV | PRV-29092 | 2026-10-10T04:22:18Z | Stephanie | — | ·Lopez | 10/18/43 | UHC9522895·· | •••-••-7622 | (644) 598-0421 | — | 1921 Washington Street | GILBERT | AZ | 85201 | — | — |
| PRV | PRV-23368 | 2026-01-24T23:17:15Z | Heather | — | Clark | 1979-05-05 | UHC-77791-65 | - | - | - | 5935 Market Street | San Diego | CA | 92182 | null | — |
| PRV | PRV-25166 | 2026-08-18T02:48:29Z | Sean | — | Carpenter | 1955-10-05 | UNKNOWN | UNKNOWN | (349) 370-4324 | — | 4917 LAKE VIEW ROAD | SEATTLE | WA | 98103 | — | - |
| PRV | PRV-28294 | 2026-06-20T06:41:40Z | LUCIA | — | WEST | 1988-02-09·· | UHC-68232-57·· | N/A | ·8939791 | — | 3770 Indian School Rd | Tampa | FL | 33650 | NULL | — |
| PRV | PRV-24495 | 2026-05-15T21:11:39Z | Aisha | — | Owens | 06/26/2002 | UNKNOWN | ·UNKNOWN | (231) 707-5318 | - | 7806 Main Street | ORLANDO | FL | 32868 | UNKNOWN | — |
| PRV | PRV-27258 | 2026-02-17T23:09:10Z | Ann | — | Berry | 05/28/2003 | UHC-79552-37 | - | 599-454-8114 | — | ·7288 Broadway | Eden Prairie | MN | 55364 | NULL | - |
| PRV | PRV-22496 | 2026-05-23T14:17:37Z | Sean | V | Sanders | 02/05/2004 | UHC-48053-23 | null | 712-533-6877 | NULL | 3327 GRAND AVE | Scottsdale | AZ | 85264 | UNKNOWN | CHOICE-PLUS-PPO |
| PRV | PRV-27108 | 2026-06-23T09:10:56Z | donald | R | hudson | 01/19/1976 | ·NULL | — | — | - | 6764 Baseline Road | CHARLOTTE | NC | 28284 | - | ·- |
| PRV | PRV-23128 | 2026-09-29T08:18:15Z | Edward | — | Daaniels | 1985-10-27 | UHC-52432-11 | NULL | 13343172163 | null | 8035 Central Ave Apt 10 | ·Tampa | FL | 33615 | UNKNOWN | — |
| PRV | PRV-26643 | 2026-03-31T13:52:38Z | Sofia | — | Hicks | 1952-05-23 | NULL | — | 9537066447 | — | 1685 Church Street | Phoenix | Arizona | 85060 | — | — |
| PRV | PRV-25210 | 2026-01-11T09:43:50Z | Nicole M | — | Butler | 1997-01-10·· | UHC-48354-10 | — | — | nicole.butler@gmail.com | 6720 BAYSHORE DRIVE | Eden Prairie | MN | 55316 | N/A | - |
| PRV | PRV-28905 | 2026-06-21T07:47:30Z | Diane | — | Castillo | 19680608 | UHC-29993-99 | — | 14447381256 | N/A | 8444 Camelback Road | MIAMI | FL | N/A | NULL | - |
| PRV | PRV-21593 | 2026-01-05T01:32:05Z | Simpson, Ann | — | ·· | 1975-01-13 | null | •••-••-4610 | ·426.830.8851 | NULL | 63 INDIAN SCHOOL RD | Tempe | AZ | 85297 | — | — |
| PRV | PRV-22982 | 2026-01-20T16:57:09Z | Jean | — | Ruiz | 1/26/1965 | — | — | N/A | UNKNOWN | 6029 Sunset Boulevard | SAN DIEGO | CA | 92175 | N/A | ·UNKNOWN |
| PRV | PRV-21421 | 2026-05-31T09:53:55Z | LINDA | ···· | MURRAY | 15-10-1958 | UHC8716020 | - | 423-660-0658 | — | 9085 Washington St | Mesa | AZ | 85250 | - | — |
| PRV | PRV-26883 | 2026-05-31T04:55:07Z | Jack | — | Parker | 19571106 | UHC-19681-90 | UNKNOWN | NULL | null | 7658 PINE DRIVE Apt 4 | Las Vegas | NV | 89117 | - | UNKNOWN |
| PRV | PRV-28182 | 2026-07-20T02:24:14Z | KYLE | L | WBER | 1987-08-09 | — | NULL | (968) 364-5938 | UNKNOWN | 9279 Forest Avenue | San Diego | CA | ·92182 | N/A | MEDICARE-ADV-B |
| PRV | PRV-28031 | 2026-10-12T18:55:30Z | ANA | A | COX | 7/8/1981 | — | •••-••-0321 | (954) 685-7596·· | ana.cox61@aol.com | 8684 MAIN ST | Tempe | AZ | 85216 | — | ·· |
| PRV | PRV-27540 | 2026-04-19T09:28:50Z | OMAR | — | VALDEZ | 1961-04-21 | UHC-08703-94 | •••-••-7265 | 739-547-5822 | N/A | 6802 HIGHLAND AVE | Scottsdale | AZ | 85215 | — | CORE-HMO |
| PRV | PRV-25763 | 2026-05-25T11:42:40Z | Cheryl | F | Rivera | ·5/15/1943 | UHC-22669-61 | — | 564-215-4559 | — | 2517 Baseline Road | TEMPE | Arizona | 85257 | N/A | N/A |
| PRV | PRV-27509 | 2026-01-24T14:52:54Z | Graham, Virginia | F | — | 19650901 | UHC-41763-34 | •••-••-4879 | 12764573892 | VIRGINIA.GRAHAM@PROTON.ME | 4219 Mesa Dr | Austin | TX | ·UNKNOWN | N/A | N/A |
| PRV | PRV-29300 | 2026-01-19T16:59:30Z | CAMILA | — | FULLER | 1989-01-15 | ·NULL | •••-••-2829 | 600-377-0152 | camila.fuller@hotmail.com·· | 5726 CHURCH ST | Sacramento | CA | 95831 | N/A | — |
| PRV | PRV-27512 | 2026-08-31T01:33:46Z | Nathan | R | Clark | 1/15/1941 | NULL | - | 292-984-6918 | N/A | 387 JEFFERSON AVENUE | Chandler | AZ | 85217 | null | MEDICARE-ADV-A |
| PRV | PRV-28793 | 2026-05-13T06:48:27Z | Christine | — | Marquez | 01/03/1941 | UNKNOWN | N/A | (972) 442-9407 | ·UNKNOWN | — | - | — | N/A | UNKNOWN | NULL |
| PRV | PRV-27452 | 2026-01-30T21:03:20Z | Theresa | ·W | Rios | 1950-03-14 | uhc-98479-41 | NULL | 4963687225 | UNKNOWN | 9833 Park Place | Tempe | AZ | 85259 | UNKNOWN | — |
| PRV | PRV-20968 | 2026-08-03T17:06:10Z | HENRY | — | CHERYL·· | 08/19/1955 | UHC-97793-44 | — | 598.732.4108·· | — | 4304 Canyon Rd | Tucson | AZ | 85764 | NULL | UNKNOWN |
| PRV | PRV-27743 | 2026-04-23T02:05:21Z | NANCY | Y | VALDEZ | 2002-06-24 | UHC-34666-58 | — | 3898239 | — | 3019 Park Place | TUCSON | AZ | 85734 | - | ·null |
| PRV | PRV-28429 | 2026-05-17T23:10:16Z | Montgomery, Andrew | — | — | 08/15/45 | — | NULL | 747-240-1135 | - | 3903 Mesa Dr | San Antonio | TX | 78284 | null | NULL·· |
| PRV | PRV-28094 | 2026-08-15T01:35:01Z | Lri | — | Allen | 06/02/1970 | N/A | — | N/A | null | 1131 Central Ave | Chandler | AZ | 85248 | null | UNKNOWN |
| PRV | PRV-21183 | 2026-08-09T12:52:33Z | Nichols, Philip | B | — | Apr 4, 1988 | UNKNOWN | NULL | (614) 497-1756 | PHILIP.NICHOLS20@HOTMAIL.COM | 5140 Park Place | San Diego | CA | 92155 | — | N/A |
| PRV | PRV-21894 | 2026-07-22T18:22:11Z | Lauren | — | Jordan | 7/18/1995 | null | ·· | 618-719-2622 | LAUREN.JORDAN@GMAIL.COM | 3684 Ridge Road | Minneapolis | MN | 55492 | NULL | null |
| PRV | PRV-25419 | 2026-09-15T05:40:51Z | Soto, Ryan | M | — | 1994-04-04 | — | — | (505) 271-0280 | — | 3892 HILLCREST RD | SEATTLE | WA | 98158·· | NULL | NAVIGATE-HMO |
| PRV | PRV-28594 | 2026-01-07T00:57:11Z | ANN | B | SIMS | 1992-02-16 | ···· | NULL | 14029507313·· | NULL | ·· | — | - | N/A | - | — |
| PRV | PRV-28476 | 2026-05-29T00:23:19Z | Sandra | — | Stewart | Jul 25, 1955 | UHC-38871-63 | N/A | (825) 755-7553 | sandra.stewart@proton.me | 7198 Harbor Boulevard | Seattle | WA | 98140 | — | — |
| PRV | PRV-22052 | 2026-02-04T15:27:06Z | EMILY | — | COOPER | Apr 8, 1987 | N/A | null | +1 208 662 0488 | emily.cooper52@gmail.com | 246 MOUNTAIN VIEW DR | Los Angeles | California | 90087-2939 | NULL | — |
| PRV | PRV-26158 | 2026-05-05T01:22:45Z | sara | H. | moore | 3/26/1996 | null | •••-••-3682 | 4967210963 | — | 7068 MARKET STREET | Tucson | AZ | 85781 | — | - |
| PRV | PRV-21244 | 2026-02-24T20:05:10Z | DAVID | — | GARZA | Apr 6, 1938 | null | •••-••-5249 | 6429218121 | — | 4042 Canyon Rd | Plano | ·TX | 75098 | — | - |
| PRV | PRV-25234 | 2026-03-15T01:53:15Z | cynthia | — | ford | 1986-06-11 | null | N/A | — | cynthia.ford30@aol.com·· | 3753 LINCOLN WAY | Fresno | CA | ·93791 | — | -·· |
| PRV | PRV-20900 | 2026-05-13T21:13:00Z | ·AUSTIN | — | HUGHES·· | 2000-06-04 | — | •••-••-2458 | 14454953335 | austin.hughes@yahoo.com | 138 Meadow Ln | ·Eden Prairie | MN | 55308 | UNKNOWN | MEDICARE-ADV-A |
| PRV | PRV-25912 | 2026-05-01T01:56:02Z | Cynthia | — | Jimenez | 1989-07-14 | UHC-68580-40 | ·NULL | N/A | cynthia.jimenez@aol.com | 7864 MARKET STREET | ·Columbus | ·OH | 43222 | ·N/A | OPTIONS-PPO |
| PRV | PRV-23545 | 2026-08-21T02:01:17Z | Nancy | — | Gray | 1941-07-06 | ···· | •••-••-1622 | 336-384-5937 | — | 5749 Ridge Road·· | Mesa | AZ | UNKNOWN | UNKNOWN | ·- |
| PRV | PRV-21542 | 2026-04-10T04:38:14Z | Albert | — | Li | 1973-10-24 | — | - | 9639072435 | — | 1364 PARK PLACE | CHARLOTTE | NC | 28264 | NULL | CHOICE-PLUS-PPO |
| PRV | PRV-22936 | 2026-02-24T22:30:30Z | GERADL | — | CHAVEZ | Mar 27, 1987 | UHC-99698-91 | null | 426-827-3256 | ·gerald.chavez@outlook.com | 3225 Hillcrest Rd·· | Atlanta | GA | 30348 | UNKNOWN | — |
| PRV | PRV-24152 | 2026-07-14T12:25:14Z | JESSICA | — | MORGAN | 1957-05-01 | UHC-15395-10 | NULL | +1 305 430 4965·· | — | 4019 Meadow Ln Apt 7 | GLENDALE | AZ·· | 85317 | — | ·· |
| PRV | PRV-23563 | 2026-01-03T00:51:47Z | EDWARD | — | COLEMAN | 1971-11-17 | UHC7739261 | — | (632) 970-0454 | — | 7471 Washington St | Denver | Colorado | 80222 | — | UNKNOWN |
| PRV | PRV-24059 | 2026-04-01T15:00:18Z | Bradley | R. | ·Freeman | 1999-10-11 | N/A | — | 547-208-1684 | — | null | UNKNOWN | — | — | NULL | MEDICARE-ADV-A·· |
| PRV | PRV-21268 | 2026-06-09T16:44:07Z | Scott | O | Moreno·· | 06-10-1984 | UHC-00221-37 | - | +1 809 852 3632 | null | 3320 Cedar Lane | ·Dallas | TX | 75245·· | null | NAVIGATE-HMO |
| PRV | PRV-28227 | 2026-01-31T00:25:49Z | Rachel | — | Yang | 1945-11-12 | null | — | (381) 736-7496 | rachel.yang6@aol.com | ·2921 PALM DRIVE | Denver | Colorado | 80243 | - | 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:43:03.759Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty