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
Third-party administrator only, ordered by line number
| Source | Record | Received | First | Middle | Last | DOB | Member ID | SSN | Phone | Address | City | State | ZIP | Group | Plan | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| TPA | TPA-51016 | 2026-02-02T07:40:20Z | Stephens, Ralph | — | — | 2000-12-04 | ·NULL | UNKNOWN | - | N/A | 3893 Elm Street | Gilbert | AZ | ···· | — | UNKNOWN |
| TPA | TPA-62877 | 2026-08-07T02:11:03Z | Isabella | — | Patel | ·1966-07-12 | UHC-81273-52 | UNKNOWN | ·UNKNOWN | NULL | 7874 LINCOLN WAY | ·Las Vegas | NV | 89141 | GRP-4328 | NAVIGATE-HMO |
| TPA | TPA-59697 | 2026-07-01T17:25:01Z | Nancy | — | ·Ryan | 03/05/89 | — | N/A | N/A | NULL | 249 Spring St | Plano | TX | 75053 | N/A·· | CORE-HMO |
| TPA | TPA-53967 | 2026-03-19T06:40:21Z | RANDY | — | WASHINGTON | 1956-04-20 | — | ·NULL | +1 225 832 5116 | — | 7571 Camelback Road | Chandler | AZ | — | null | NULL |
| TPA | TPA-51058 | 2026-10-13T10:23:48Z | Vincent | — | Hernandez | 1970-11-27 | NULL | null | — | — | 4259 Canyon Road | ·Chandler | AZ | 85217 | N/A | NAVIGATE-HMO |
| TPA | TPA-59634 | 2026-08-12T10:46:06Z | Donald | — | Singh | 19760813 | — | •••-••-8870 | (887) 293-7964 | - | 3049 Park Place | Tampa | FL | — | GRP-4607 | — |
| TPA | TPA-64349 | 2026-08-03T00:21:13Z | Joe | — | Martin | 02/18/2008 | UNKNOWN | - | null·· | — | ·NULL | N/A | — | - | N/A | CHOICE-PLUS-PPO |
| TPA | TPA-53164 | 2026-10-03T18:33:58Z | Carlos | L. | Montgomery | 5/18/1956 | — | •••-••-2663 | - | — | 9412 Broadway | AUSTIN | TX | 78724 | GRP-5051 | UNKNOWN |
| TPA | TPA-59039 | 2026-09-21T15:32:31Z | Austin | A | Matthews | 1998-04-17 | NULL | •••-••-5084 | (790) 974-1513 | UNKNOWN | 85 UNION ST | Tampa | FL | 33615 | null | OPTIONS-PPO |
| TPA | TPA-59504 | 2026-05-08T22:26:13Z | Andrea | — | Grant | 1989-02-09 | null | •••-••-1448 | (624) 241-6008 | NULL | 4241 Baseline Road | Dallas | TX | 75270 | GRP-9927 | - |
| TPA | TPA-52541 | 2026-04-21T07:54:35Z | Melissa | D | ·Campbell | 1984-05-03 | null | NULL | 407-931-9079 | NULL | ·9465 SAGE CT | Tucson | AZ | 85739 | N/A | NAVIGATE-HMO |
| TPA | TPA-57849 | 2026-07-13T07:52:24Z | Nelson, Roger | — | ···· | 1989-06-14 | - | •••-••-2695 | ···· | roger.nelson28@aol.com | 1103 Desert Sky Blvd | Tucson | AZ | 85733 | N/A | NULL |
| TPA | TPA-58246 | 2026-01-15T01:20:10Z | ·RALPH | T. | ·MARSHALL | 2/1/1975 | UNKNOWN·· | — | UNKNOWN | ralph.marshall54@gmail.com | — | — | — | — | N/A | -·· |
| TPA | TPA-61541 | 2026-03-05T18:01:09Z | Raymond | — | ·Hicks | 2007-09-22 | — | NULL | 843-786-9678 | — | 7323 Baseline Road Apt 5 | Orlando | FL | 32825-4064 | — | NAVIGATE-HMO |
| TPA | TPA-52570 | 2026-10-01T06:11:35Z | Lori | — | Lee | — | — | — | 955-912-3383 | LORI.LEE@ICLOUD.COM | 3574 MOUNTAIN VIEW DRIVE·· | Phoenix | AZ | ·85034 | - | ···· |
| TPA | TPA-57171 | 2026-06-17T01:13:17Z | Harvey, Valentina | — | — | 1979-04-11 | ·null | — | — | -·· | 3650 River Road | Austin | TX | 78759-0234 | GRP-2178 | MEDICARE-ADV-A |
| TPA | TPA-60494 | 2026-09-09T15:42:29Z | Kevin | G | Fwler | 1963-10-01 | UHC0585380 | •••-••-3690 | null | — | ·· | — | N/A | null | — | NULL |
| TPA | TPA-54985 | 2026-08-29T13:35:59Z | Billy | — | Hanseen | 1960-03-13 | N/A | •••-••-3213 | 811-928-3330 | UNKNOWN | 8826 GRAND AVENUE Apt 5 | San Diego | CA | N/A | GRP-3670 | options-ppo |
| TPA | TPA-64337 | 2026-08-19T01:33:21Z | Jerry | — | Marquez | 1946-08-18 | NULL | •••-••-9524 | 245-835-8922 | UNKNOWN | - | UNKNOWN·· | — | ·· | — | null |
| TPA | TPA-59661 | 2026-06-18T00:29:36Z | REBECCA | ···· | FOX·· | Apr 23, 2000 | - | — | UNKNOWN | — | 9718 Main St | Fresno | CA | 93789 | — | — |
| TPA | TPA-50269 | 2026-01-24T22:08:59Z | ·Spencer, Katherine | — | — | 05-12-1941 | — | — | - | NULL | — | - | — | NULL | null | ·SELECT-EPO |
| TPA | TPA-53832 | 2026-07-10T13:04:02Z | ALICE | — | TRAN | 20060418 | — | UNKNOWN | - | - | 5978 Market St | Gilbert·· | az | 85276 | NULL | CHOICE-PLUS-PPO |
| TPA | TPA-51517 | 2026-04-28T10:11:49Z | David | — | Parker | 19-06-1972 | UHC2730803 | •••-••-8553 | +1 597 317 4400 | null | ·3490 CHURCH ST | Seattle | ·WA | 98126 | - | OPTIONS-PPO |
| TPA | TPA-55180 | 2026-03-06T13:21:31Z | ARJUN | — | HERRERA | 1983-12-20 | ·· | - | ·· | — | 6028 Maple Avenue | Chandler | AZ | ·85287 | GRP-2312 | — |
| TPA | TPA-58773 | 2026-03-20T10:02:30Z | Yuki | — | Ross | 1982-03-01 | - | ·NULL | ·N/A | N/A | 2922 Park Place | Las Vegas | NV | 89190 | NULL | — |
| TPA | TPA-51403 | 2026-08-28T00:10:54Z | Diego | — | Nunez | 2001-11-26 | null | — | — | — | 6629 Canyon Road | ·Scottsdale | AZ | 85214 | UNKNOWN | NAVIGATE-HMO |
| TPA | TPA-54625 | 2026-10-12T11:02:03Z | Sean | — | Silva | May 3, 1959 | - | •••-••-4288 | (767) 335-6525 | sean.silva@proton.me | 7819 CHURCH STREET | CHANDLER | AZ | 85221 | NULL | - |
| TPA | TPA-62696 | 2026-01-07T13:28:29Z | albert | ·· | cruz | 09/19/1992 | — | — | null | null | 1079 Lake View Road | Gilbert | AZ | 85238 | GRP-8289 | N/A |
| TPA | TPA-50114 | 2026-04-05T17:29:01Z | Barb | — | Nchols | 1983-11-17 | N/A | N/A | — | barbara.nichols20@aol.com | 2632 Meadow Lane | Phoenix | AZ | ·85000 | UNKNOWN | UNKNOWN |
| TPA | TPA-60046 | 2026-08-11T12:08:28Z | Ruth | — | Aguilar | 1995-07-04 | UNKNOWN | null | 6329985888 | UNKNOWN | 7008 Cedar Lane | Mesa | AZ | 85207 | — | — |
| TPA | TPA-63296 | 2026-07-14T00:05:46Z | David | — | Rojas | 2006-02-10 | - | •••-••-2143 | N/A | null | 3125 WASHINGTON STREET | EDEN PRAIRIE | MN | 55350 | null | — |
| TPA | TPA-53365 | 2026-07-27T16:15:34Z | Andrea | — | Rivera | 05/09/76 | null | N/A | (387) 953-9187 | ANDREA.RIVERA29@OUTLOOK.COM | 7221 Valley View Dr | Denver | CO | 80259 | GRP-4136·· | — |
| TPA | TPA-57061 | 2026-04-05T11:15:01Z | ·Henry | W | Kennedy | 1990-11-13 | N/A | ···· | — | UNKNOWN | 9131 Oak St | Fresno | California·· | 93700 | - | null |
| TPA | TPA-54922 | 2026-05-13T22:17:53Z | Pter | — | McCoy | 4/2/2000 | UNKNOWN | NULL | 9884815·· | — | 3108 Desert Sky Boulevard Apt 34 | Columbus | OH·· | 43270 | — | — |
| TPA | TPA-62786 | 2026-06-16T23:31:21Z | ·Hannah | — | Valdez | 03/27/1969 | NULL | N/A | ·· | UNKNOWN | 4569 BASELINE RD | Glendale·· | AZ·· | 85357 | — | CORE-HMO |
| TPA | TPA-53754 | 2026-02-22T01:41:58Z | PHILIP | — | WRIGHT | 04/12/1998 | - | •••-••-5536 | 6736256120 | null | 1137 Hillcrest Rd | Las Vegas | NV | 89166 | GRP-2333 | — |
| TPA | TPA-62711 | 2026-03-19T09:44:28Z | Joan | — | Coleman | 2003-02-55 | NULL | •••-••-7395 | N/A | NULL | 6592 Willow Ct Apt 11 | Tampa | FL | 33636 | ·N/A | SELECT-EPO |
| TPA | TPA-61634 | 2026-01-08T11:27:46Z | Grant, Eugene | — | — | 01/10/1972 | NULL | NULL | +1 274 818 7226 | — | 3969 Palm Dr | Eden Prairie | MN | 55395 | ·NULL | UNKNOWN |
| TPA | TPA-56315 | 2026-02-15T11:50:20Z | MARILYN | — | HICKS | 1943-02-26 | null | •••-••-4656 | null | UNKNOWN·· | 4833 Mountain View Dr | AUSTIN | TX | 78799 | null | UNKNOWN |
| TPA | TPA-53939 | 2026-05-13T01:34:58Z | BETTY | — | FIELDS | 08/24/06 | - | UNKNOWN | 547.873.8985 | betty.fields@hotmail.com | 2940 Cedar Lane | Scottsdale | AZ | 85273·· | ·UNKNOWN | — |
| TPA | TPA-60585 | 2026-03-21T16:39:33Z | MEGAN | — | KIM | 2008-03-28·· | - | — | (820) 687-8393 | megan.kim@yahoo.com | - | - | N/A | — | N/A | null |
| TPA | TPA-62515 | 2026-02-25T19:33:46Z | denise | ·· | dominguez | 01-05-1972 | UNKNOWN | NULL | ·· | null | 2833 PALM DRIVE | Jacksonville | FL·· | 32276 | — | SELECT-EPO |
| TPA | TPA-55247 | 2026-07-11T03:44:38Z | Bruce | — | Santos | 1938-03-13 | NULL | -·· | — | UNKNOWN | 9658 Pine Dr | Gilbert | AZ·· | 85288 | NULL | UNKNOWN |
| TPA | TPA-63231 | 2026-03-09T22:00:37Z | David | ·· | Rogers | 1959-11-20 | — | N/A | — | UNKNOWN | 9118 Mountain View Dr | Orlando | FL·· | null | NULL·· | — |
| TPA | TPA-64197 | 2026-06-19T10:09:13Z | NICHOLAS | — | ·KENNEDY | 19740410 | N/A | null | — | null | — | N/A·· | — | - | GRP-3408 | null |
| TPA | TPA-59394 | 2026-06-22T15:11:26Z | VIRGINIA | — | CLARK | 1956-11-05 | UHC-07844-60 | •••-••-6493 | (383) 229-7394 | virginia.clark67@gmail.com | - | null | — | - | - | UNKNOWN |
| TPA | TPA-54182 | 2026-07-25T20:39:00Z | Marcus | — | Jacobs | 2004-09-07 | UNKNOWN | •••-••-9143 | 378.740.5430 | N/A | 3489 CHURCH ST | Phoenix | AZ | 85072 | N/A | MEDICARE-ADV-A |
| TPA | TPA-57014 | 2026-10-14T19:38:53Z | Anderson, Dorys | — | — | 16-06-1940 | NULL | N/A | 476-468-3227 | NULL | 5796 Broadway | Sacramento | CA | 95828 | GRP-0758 | N/A |
| TPA | TPA-58279 | 2026-07-07T16:21:26Z | RALPH | Z.·· | BELL | Nov 3, 1976 | — | •••-••-5711 | (481) 390-4799 | NULL | 8457 Apache Boulevard | TEMPE | AZ | 85201 | GRP-0589 | null |
| TPA | TPA-52270 | 2026-03-07T08:49:43Z | virgiia | — | ortiz | 2008-03-22 | UHC-29964-53 | — | 9769934724 | VIRGINIA.ORTIZ@ICLOUD.COM | 8997 Broadway·· | Denver | ·CO | 80228 | GRP-3713 | 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:38.499Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty