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-22162 | 2026-07-31T03:52:39Z | LISA | J | BRYANT | 2/6/1997 | — | — | 19268184628 | LISA.BRYANT@PROTON.ME | 5893 Meadow Ln | NASHVILLE | Tennessee | 37224 | ·· | — |
| PRV | PRV-21383 | 2026-09-10T00:28:00Z | ANGELA | — | KENNEDY·· | 1998-08-40 | N/A | N/A | — | NULL | 890 Forest Ave | Dallas | TX | 75239 | N/A | CHOICE-PLUS-PPO |
| PRV | PRV-20807 | 2026-10-03T02:39:46Z | Ruth | — | Wells | 20031208 | - | — | 822-770-8183 | ruth.wells@gmail.com | 7402 SAGE CT | Tempe | AZ | 85264 | NULL | MEDICARE-ADV-A·· |
| PRV | PRV-27598 | 2026-03-06T20:44:35Z | Harold | — | Porter | 1942-05-01·· | — | N/A | 269-862-1952 | NULL | 2658 Grand Ave | Glendale | AZ | 85372 | NULL | null |
| PRV | PRV-26137 | 2026-05-01T06:39:42Z | ·RALPH | V. | SANTOS | 1971-04-17 | UHC-84145-92 | — | - | ···· | 6368 Highland Ave | Sacramento | CA | 95809 | — | OPTIONS-PPO |
| PRV | PRV-24274 | 2026-01-18T11:41:45Z | ·Mason | — | Weaver | 08/27/46 | UNKNOWN | •••-••-1652 | 3287084598 | ·mason.weaver31@proton.me | 248 Palm Drive | FRESNO | CA | 93706 | — | MEDICARE-ADV-A |
| PRV | PRV-23200 | 2026-02-14T07:35:46Z | Payne, Charlotte | I. | — | 01/13/05 | N/A | NULL | +1 472 498 3309 | NULL | 2382 GRAND AVE | Glendale | AZ | 85354 | — | null |
| PRV | PRV-21290 | 2026-08-12T03:27:45Z | Kathy | — | Sandoval | 19620514 | - | •••-••-8227 | N/A | N/A | 5904 Central Avenue·· | Tempe | AZ | 85242 | — | CHOICE-PLUS-PPO |
| PRV | PRV-20414 | 2026-07-12T00:48:30Z | Christian | — | Welch | Jul 15, 1975 | UHC-53208-60 | — | 450-314-6399 | - | 4593 Elm Street | ·Jacksonville | FL | 32299 | NULL | ·· |
| PRV | PRV-20286 | 2026-04-25T02:10:24Z | Carl | W | Sandoval | 01-04-1998 | null | UNKNOWN·· | ·895-907-3972 | CARL.SANDOVAL@ICLOUD.COM | 1075 Elm Street | Plano | TX | 75032-0735 | - | null |
| PRV | PRV-29379 | 2026-07-21T19:16:45Z | JONATHEN | — | BISHOP·· | 1998-06-24 | UHC-27890-40 | NULL | (725) 300-8403 | JONATHAN.BISHOP@HOTMAIL.COM | 5797 Desert Sky Blvd | Mesa | AZ | 85215 | — | — |
| PRV | PRV-21579 | 2026-06-18T07:39:42Z | CHARLOTTE | H | BERRY | 1943-02-28 | UNKNOWN | •••-••-3833 | — | — | - | UNKNOWN | — | N/A | UNKNOWN | ·UNKNOWN |
| PRV | PRV-25314 | 2026-02-20T20:21:50Z | Kenneth | W | Stewart | 1946-06-05 | ·null | null | 8564494783 | kenneth.stewart31@gmail.com | 5531 River Rd | Plano | TX | 75090 | — | null |
| PRV | PRV-25673 | 2026-09-17T07:54:22Z | Ramirez, Arjun | — | — | 1990-05-09 | UHC-84085-42 | NULL | (380) 759-9608 | — | 2896 Sunset Boulevard | Gilbert | AZ | 85259 | null | — |
| PRV | PRV-25012 | 2026-01-20T21:33:02Z | Jake | X | Hughes | ·12/21/79 | UNKNOWN | NULL | 684.414.4837 | ·· | 7401 WASHINGTON STREET | Atlanta | ·GA | 30391 | — | — |
| PRV | PRV-25698 | 2026-05-27T22:53:07Z | angela | — | gilbert | 10/11/53·· | UHC-84008-87 | NULL | — | — | — | ···· | - | - | — | navigate-hmo |
| PRV | PRV-27958 | 2026-04-28T22:48:52Z | Lisa | — | Graham | 08/06/1956 | null | - | 2669411647 | UNKNOWN | null | null | - | null·· | — | null |
| PRV | PRV-24106 | 2026-10-14T05:03:53Z | danielle | — | ·andrews | 1952-11-02 | - | - | 341.326.1209 | - | 247 Camelback Rd | EDEN PRAIRIE | MN | 55393-7370 | — | UNKNOWN |
| PRV | PRV-20135 | 2026-10-08T04:18:01Z | Paul L | — | Gutierrez | 11/28/1939·· | UHC-28321-70 | — | 6632701366 | — | 167 MAIN STREET | PLANO | TX | 75032 | — | N/A |
| PRV | PRV-24786 | 2026-05-25T12:43:44Z | MELISSA | — | HENDERSON | Aug 4, 1956 | UHC-06487-05 | N/A | 446-659-5844 | — | 3872 Highland Ave | LOS ANGELES | CA | 90021 | UNKNOWN | NAVIGATE-HMO |
| PRV | PRV-25683 | 2026-04-27T19:06:00Z | Austin | — | Murray | ·1944-07-18 | — | — | null | — | 6579 Washington St | AUSTIN | ·TX | 78760-8625 | — | — |
| PRV | PRV-21631 | 2026-06-07T11:18:23Z | Heather | G | Black | 1983-01-18 | — | — | — | N/A | 3321 WASHINGTON ST | Los Angeles | CA | 90040 | — | N/A |
| PRV | PRV-29102 | 2026-05-17T02:38:31Z | DOROTHY | — | SPENCER | 6/15/1947 | ·NULL | N/A | 4604176622 | — | 8114 SAGE CT | Gilbert | AZ | 85247 | N/A | — |
| PRV | PRV-27982 | 2026-04-11T15:33:45Z | Burke, Bryan | O | — | 15-09-1998 | UHC-45325-26 | — | 742-633-9903 | — | 8698 BAYSHORE DR | ·Dallas | TX | 75228 | ···· | NULL |
| PRV | PRV-23570 | 2026-05-10T11:10:42Z | DEB | V. | GILBERT | 9166-05-12 | UHC-22494-09·· | NULL | (715) 299-7127 | ·· | 5353 Church Street | Minneapolis | MN | 55412 | — | — |
| PRV | PRV-26924 | 2026-07-19T01:24:59Z | Billy | A | Watkins | 19901107 | ·UHC-49351-53 | UNKNOWN | ·517-284-8724 | NULL | 4593 River Rd·· | Las Vegas | NV | 89153-8176 | — | ·UNKNOWN |
| PRV | PRV-20890 | 2026-06-17T11:30:47Z | christian | T | rivera·· | 04/11/00 | UHC-95771-57 | null | 5122835725 | ·· | 2617 Sage Ct | Seattle | WA·· | NULL | N/A | null |
| PRV | PRV-28000 | 2026-01-04T02:08:13Z | Sullivan, Charlotte | Q | — | 1954-08-24 | UHC-97098-75 | N/A | 9856593353 | N/A | 1460 WILLOW CT·· | AUSTIN | TX·· | 78770·· | UNKNOWN | ·choice-plus-ppo |
| PRV | PRV-20998 | 2026-09-28T15:54:28Z | Gary | — | Richardson | 8/3/1954 | UHC-77929-51 | — | 419-899-4903 | ·· | 5154 Mountain View Dr | Eden Prairie | MN | 55336 | NULL | - |
| PRV | PRV-29415 | 2026-07-21T20:15:22Z | Nunez, Alexis | T | ···· | ·· | UNKNOWN | — | ·+1 292 983 2165 | NULL | 9582 Grand Ave | Denver | CO | 80210·· | N/A·· | — |
| PRV | PRV-21683 | 2026-03-20T06:51:29Z | EMMA | ···· | FERNANDEZ | 15-02-1989 | UHC0390718 | UNKNOWN | +1 693 966 1786 | — | 5873 BAYSHORE DR | Phoenix | AZ | 85030 | NULL | — |
| PRV | PRV-28439 | 2026-01-06T20:09:31Z | joyce | — | johnson | 1994-08-04 | UHC-57438-80 | NULL | ·· | N/A | 1785 Ridge Road | Scottsdale | AZ | 85209 | — | — |
| PRV | PRV-23812 | 2026-07-17T22:30:13Z | Aaron | — | Rojas | 0811-19-80 | UNKNOWN | •••-••-3086 | 316-435-2379 | — | 1140 SPRING ST | ·Tempe | az | 85244 | - | MEDICARE-ADV-B |
| PRV | PRV-21775 | 2026-08-01T07:47:11Z | Bradley | G. | Carroll | 1968-11-05 | UHC-64547-12 | NULL | (764) 650-2640 | — | 2490 Market St | ·Glendale | Arizona | 85383-2819 | UNKNOWN | - |
| PRV | PRV-26878 | 2026-04-27T22:22:56Z | Hall, Samuel | L. | — | 1988-09-22 | UHC-61573-06 | — | (212) 730-4833 | samuel.hall90@yahoo.com | 6266 MESA DRIVE | ·Columbus | OH | 43281 | — | UNKNOWN |
| PRV | PRV-22031 | 2026-08-16T19:06:02Z | Davis, Gerald | — | — | 1959-07-13 | UHC-68736-64 | — | — | gerald.davis@outlook.com | 7154 Pine Dr | Tempe | AZ | 85215 | ···· | NAVIGATE-HMO |
| PRV | PRV-25901 | 2026-05-10T00:39:02Z | Bryan | — | Banks | 1985-07-06 | ···· | UNKNOWN | +1 411 761 6199 | bryan.banks78@aol.com | 1805 PALM DRIVE | Phoenix | az | 85090 | — | — |
| PRV | PRV-20626 | 2026-05-07T14:37:01Z | Bobby | — | Wilson | 1971-02-25 | NULL | — | 4152432213 | N/A | 633 MEADOW LN | Miami | Florida | 33117-3715 | - | CORE-HMO |
| PRV | PRV-26604 | 2026-05-02T08:55:27Z | Paul | — | Arnold | 2008-11-11 | - | — | — | — | 4396 Jefferson Avenue | Miami | FL | 33145 | — | UNKNOWN |
| PRV | PRV-24069 | 2026-06-22T23:34:48Z | Kelly, Theresa | — | — | 19500102 | UHC2610349 | N/A | (687) 656-0179 | theresa.kelly90@aol.com | 1014 Hillcrest Rd | San Diego | California | UNKNOWN | - | MEDICARE-ADV-A |
| PRV | PRV-29582 | 2026-04-12T18:49:14Z | Doris | — | Meyer | 20-12-1960 | - | NULL | N/A | — | 7944 Valley View Drive Apt 25 | PLANO | TX | 75036 | - | NULL |
| PRV | PRV-27464 | 2026-03-29T04:42:41Z | Betty | — | Watkins | 1994-07-17 | UHC-83199-38 | — | (393) 203-5504 | betty.watkins@gmail.com | 6891 Palm Drive | Tempe | AZ | 85286-5833 | UNKNOWN | N/A |
| PRV | PRV-24118 | 2026-07-02T20:56:28Z | DENNIS | — | CONTRERAS | — | N/A | null | — | null | ·1344 MOUNTAIN VIEW DRIVE | ORLANDO | Florida | 32830-7798 | N/A | null |
| PRV | PRV-26614 | 2026-08-20T18:23:43Z | Sharon | — | Campbell | 1956-06-07 | UHC-06772-04 | — | +1 446 504 1093 | SHARON.CAMPBELL@PROTON.ME | 878 Canyon Rd | Tucson | AZ | 85718 | — | NULL·· |
| PRV | PRV-28452 | 2026-07-06T13:24:50Z | Priya | — | Phillips | 1984-06-03 | - | •••-••-4745 | +1 485 313 4742 | — | 1868 Hillcrest Rd | MIAMI | FL | 33156 | N/A | medicare-adv-b |
| PRV | PRV-27325 | 2026-06-22T17:15:02Z | ANGELA | ·· | CARPENTER | 07/20/90 | — | - | 4867873 | — | ·4829 Jefferson Avenue | Austin | TX | 78752·· | — | ·· |
| PRV | PRV-21164 | 2026-10-12T14:14:43Z | Perez, Ahmed | Y | ·· | 9141-05-09 | ···· | — | 9662242443 | N/A | 3435 Broadway | SACRAMENTO | ·CA | 95811 | — | SELECT-EPO |
| PRV | PRV-20639 | 2026-01-10T18:02:51Z | Ashley | ···· | Turner | 1982-08-20 | UHC-15343-73 | N/A | 5857597815·· | ashley.turner44@aol.com | 7867 Elm Street | Atlanta | GA | 30390 | null | NULL |
| PRV | PRV-28709 | 2026-01-15T02:22:34Z | Michael | — | Romero | 4/1/1944 | ·- | null | 9586948183 | UNKNOWN | 118 Washington Street | TUCSON | AZ | N/A | NULL | MEDICARE-ADV-A |
| PRV | PRV-26430 | 2026-08-15T22:50:42Z | Evans, Arjun | ·· | ···· | 2/19/1979 | — | — | (291) 357-4271 | — | 5961 BROADWAY | SCOTTSDALE | AZ | 85235 | — | medicare-adv-b |
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-19T19:54:25.439Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty