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-52151 | 2026-04-27T02:08:13Z | VINCENT | — | HOWARD | 19930720·· | - | N/A | 679-563-3875 | N/A | - | NULL | N/A | NULL | — | - |
| TPA | TPA-51558 | 2026-04-21T05:29:10Z | Daniel | ·· | Dean | 04-10-1950 | null | •••-••-4122 | N/A | - | 3184 Spring Street | Austin | TX | 78776 | NULL | CORE-HMO |
| TPA | TPA-59577 | 2026-01-24T04:57:19Z | Wayne | — | Lee | 1949-01-02 | — | •••-••-3606 | — | - | — | ···· | ···· | - | NULL | CORE-HMO |
| TPA | TPA-54229 | 2026-05-08T21:08:28Z | Diane | — | Perry | 1972-06-28 | UHC-44965-89 | — | 2063760734 | N/A | 5899 Union Street | Phoenix | ·AZ | 85095 | GRP-6166 | CORE-HMO |
| TPA | TPA-50382 | 2026-01-25T12:12:10Z | Noha | — | Yang | 12/27/1974 | UHC-48251-04 | •••-••-4320 | — | — | 5747 Jefferson Ave | Scottsdale | az | 85231 | GRP-8956 | null |
| TPA | TPA-54059 | 2026-04-13T03:57:52Z | Aaron | — | Campbell | 11/03/75 | null | NULL | N/A | UNKNOWN | 9770 PARK PLACE | Austin | TX | 78708 | — | SELECT-EPO |
| TPA | TPA-55334 | 2026-08-16T20:57:52Z | BRITTANY | — | HUDSON | 1974-11-22 | N/A | •••-••-4449 | 707-708-4336 | BRITTANY.HUDSON7@HOTMAIL.COM | 1400 PALM DRIVE | San Diego | CA·· | 92164 | NULL | SELECT-EPO |
| TPA | TPA-62550 | 2026-02-28T08:57:36Z | RICHARD | — | RICE | 1977-10-05 | — | ·N/A | 5268844805 | UNKNOWN | 2371 Mesa Drive | Plano | TX | 75010-2211 | UNKNOWN | — |
| TPA | TPA-59047 | 2026-02-20T09:43:01Z | Benjamin | — | Weaver | 08/10/96 | NULL | ·N/A | ·963-579-6913 | - | 3047 Willow Ct | COLUMBUS | OH | 43204 | N/A | — |
| TPA | TPA-54933 | 2026-09-16T22:51:33Z | Wei | — | Dunn | ·1997-10-09 | N/A | UNKNOWN | 7853953456 | — | UNKNOWN | N/A | NULL | N/A | GRP-8747 | UNKNOWN |
| TPA | TPA-59331 | 2026-05-26T15:24:55Z | Gerald | — | Rios | 03/19/76 | — | — | null | GERALD.RIOS@GMAIL.COM | 3000 Maple Ave | San Antonio | TX | 78252 | GRP-3747 | — |
| TPA | TPA-60897 | 2026-07-09T08:20:50Z | Ronald | — | Valdez | 1978-10-18 | NULL | — | null | NULL | 9019 CENTRAL AVENUE | Jacksonville | FL | 32234 | NULL | SELECT-EPO |
| TPA | TPA-55770 | 2026-07-03T21:08:00Z | Sara | — | Espinoza | 27-01-1997 | NULL | — | NULL | NULL | N/A·· | null | — | — | — | — |
| TPA | TPA-62193 | 2026-03-23T05:35:14Z | Cook, William | — | — | 2002-03-27 | - | - | null | WILLIAM.COOK66@GMAIL.COM | 221 Baseline Road | ·Seattle | WA | — | GRP-0283 | ·N/A |
| TPA | TPA-59902 | 2026-01-29T11:33:39Z | ·STEVE | — | WATKINS | 1956-06-02 | NULL | — | 5079940693 | ···· | NULL | NULL | UNKNOWN | — | - | OPTIONS-PPO |
| TPA | TPA-61562 | 2026-04-13T09:22:51Z | Marquez, Mark | ···· | — | 1953-02-28 | null | — | ·7106427661 | ·· | 5772 Sage Court·· | San Antonio | TX | ·78271 | NULL | — |
| TPA | TPA-52737 | 2026-03-07T02:38:47Z | Diana | ·· | Martin | 2003-11-05 | N/A | UNKNOWN | 457-807-6441 | - | — | null | N/A | N/A | NULL | - |
| TPA | TPA-55244 | 2026-06-03T05:00:23Z | Brittany | — | Riley | 1991-07-08 | N/A | •••-••-9708 | — | — | 1109 Lake View Rd | SAN ANTONIO | TX | 78260 | null | — |
| TPA | TPA-57567 | 2026-05-26T07:17:13Z | HAROLD | — | SIMMONS | 1948-07-21 | UNKNOWN | •••-••-9940 | — | harold.simmons47@gmail.com | 1157 Desert Sky Blvd | Gilbert | az | 85227 | GRP-9120 | — |
| TPA | TPA-53227 | 2026-09-09T04:40:37Z | Edwards, Jean | — | — | 1991-12-01·· | UHC-85008-34 | — | — | — | 4057 Sage Ct Apt 4 | Sacramento | CA | 95868 | GRP-8721 | — |
| TPA | TPA-58900 | 2026-03-23T12:47:14Z | MARIA | E | WELLS | 1946-03-19·· | UNKNOWN | •••-••-4496 | 730.653.4530 | UNKNOWN | 7304 Mountain View Drive | ·Phoenix | AZ | 85099 | NULL | — |
| TPA | TPA-58365 | 2026-02-28T05:33:26Z | Barbara·· | ·· | Castillo | 1940-11-11 | NULL | •••-••-1786 | - | BARBARA.CASTILLO40@YAHOO.COM | 2447 Mesa Dr | COLUMBUS | OH | 43292 | N/A | null |
| TPA | TPA-53749 | 2026-08-02T12:19:55Z | Victoria | — | Hunt | 2004-02-03 | NULL | ·null | — | null | 8062 Cedar Ln | Dallas | TX | 75273 | N/A | — |
| TPA | TPA-64251 | 2026-04-12T15:11:21Z | Howell, David | — | — | 1978-06-19 | — | NULL | - | N/A | 1246 Camelback Rd #223 | COLUMBUS·· | OH | 43210 | GRP-0847 | MEDICARE-ADV-A |
| TPA | TPA-57572 | 2026-04-25T14:30:21Z | Melissa | — | Santiago | 10-03-1992 | ·UHC-16590-48 | •••-••-0763 | — | null | NULL | -·· | N/A·· | — | — | NULL |
| TPA | TPA-56057 | 2026-05-26T08:08:15Z | Dyylan | — | Andrews | 11/8/1961 | N/A | — | 18068906466·· | dylan.andrews92@gmail.com | 7202 Washington Street | Sacramento | CA | 95879 | N/A | CHOICE-PLUS-PPO·· |
| TPA | TPA-58717 | 2026-10-07T09:22:28Z | Dais, Catherine | — | — | ·1961-02-12 | - | •••-••-5888 | — | - | 6282 Ridge Rd | Miami·· | FL | 33147 | ···· | UNKNOWN |
| TPA | TPA-56680 | 2026-04-24T22:46:51Z | Denise | — | Gibson | 1998-02-24·· | N/A·· | — | UNKNOWN | — | — | N/A | — | — | NULL | - |
| TPA | TPA-57249 | 2026-10-07T22:07:10Z | Jackson, Billy | — | — | 6/13/1951 | — | — | (828) 632-6178 | BILLY.JACKSON84@ICLOUD.COM | 9686 Hillcrest Rd | Jacksonville | FL | 32258 | GRP-8401 | NULL·· |
| TPA | TPA-60665 | 2026-02-24T17:36:53Z | Brandon | — | Guzman | ·1948-12-09 | null | •••-••-3540 | 3708970317 | NULL | 3766 Sunset Boulevard | TEMPE | ·AZ | 85226 | UNKNOWN | MEDICARE-ADV-B |
| TPA | TPA-53383 | 2026-01-10T00:53:11Z | Richardson, Julia | — | ···· | 1982-08-18 | ···· | •••-••-1508 | (754) 477-1939 | UNKNOWN | 8484 Lincoln Way #697 | Eden Prairie | MN | 55301 | GRP-8651·· | — |
| TPA | TPA-62020 | 2026-04-28T12:43:33Z | Juulie | — | Franklin | 1967-09-25 | UHC-79652-17 | •••-••-4067 | 18553416908 | JULIE.FRANKLIN@YAHOO.COM | 6590 Hillcrest Rd | Houston | TX | 77018 | GRP-2921 | NULL |
| TPA | TPA-52843 | 2026-09-07T02:26:31Z | Stephen | — | Holmes·· | 19400128 | — | — | NULL | STEPHEN.HOLMES@HOTMAIL.COM | 2998 CEDAR LANE | Orlando | FL | ·32851 | — | - |
| TPA | TPA-60377 | 2026-03-27T18:05:17Z | CYNTHIA | — | ·LITTLE | Aug 1, 1978 | — | — | — | NULL | 5859 Camelback Road | ·Glendale | AZ | ·85335 | null | CHOICE-PLUS-PPO |
| TPA | TPA-63104 | 2026-04-10T13:27:31Z | Aisha | — | McCoy | 2004-08-22 | — | — | — | aisha.mccoy10@yahoo.com | 354 Market St Apt 10 | San Diego | CA | 92198 | GRP-0841 | — |
| TPA | TPA-52643 | 2026-10-07T16:13:41Z | Gonzales, Nick | X | — | 1999-02-28 | UNKNOWN | null | UNKNOWN | — | 3035 Harbor Blvd | Glendale | Arizona | 85333 | N/A | — |
| TPA | TPA-57339 | 2026-01-29T03:20:50Z | RICHARD | — | BURKE | 9/27/2002 | N/A | null | 970-726-2675 | richard.burke81@yahoo.com | 2536 PARK PLACE | ·Miami | FL | 33130 | ·· | OPTIONS-PPO |
| TPA | TPA-60586 | 2026-09-11T16:57:57Z | Megan | L. | Kim | Mar 28, 2008 | - | NULL | - | megan.kim@yahoo.com | — | — | NULL | N/A | — | null |
| TPA | TPA-60361 | 2026-01-01T12:41:23Z | Mary | J·· | Watkins | 02/25/94 | ···· | — | 585-338-8926 | UNKNOWN | 6724 Baseline Road | Jacksonville | FL | 32288 | GRP-7920 | — |
| TPA | TPA-56576 | 2026-06-19T01:46:01Z | Ann | — | Adams | 1983-01-10 | - | •••-••-1002 | 5615062737 | — | 5537 Camelback Road | Sacramento | ·CA | 95832 | N/A | MEDICARE-ADV-A |
| TPA | TPA-64092 | 2026-07-22T16:31:16Z | Patrick | W. | Jenkins | 1987-04-22 | — | — | 13856761430 | N/A | - | — | N/A | null | UNKNOWN | — |
| TPA | TPA-57452 | 2026-07-22T14:12:16Z | sofia | — | guerrero | 21-04-1978 | UHC-42523-31 | •••-••-5392 | null | SOFIA.GUERRERO@HOTMAIL.COM | 7894 MESA DR | Minneapolis | MN | 55433 | GRP-6367 | — |
| TPA | TPA-52003 | 2026-01-05T13:25:30Z | JESSICA | — | KIM | 1992-02-14 | N/A | — | N/A | ···· | 4433 Camelback Rd | Sacramento | CA | — | null | OPTIONS-PPO |
| TPA | TPA-60516 | 2026-06-10T17:59:36Z | Mark | Q | Webb | Dec 20, 1998 | UHC-98847-79 | ·UNKNOWN | 19165987462 | UNKNOWN | 4085 Mountain View Dr | SEATTLE | WA | 98109·· | UNKNOWN | — |
| TPA | TPA-59153 | 2026-03-05T20:55:01Z | Julia | — | McDonald | 24-11-1990 | — | ·UNKNOWN | — | ·N/A | 7526 Hillcrest Road | ·Plano | TX | 75052 | N/A | - |
| TPA | TPA-52842 | 2026-07-26T08:42:21Z | jerry | — | hill | 19590915 | — | N/A | — | ·NULL | 273 Camelback Road | ·Austin | TX | 78777 | N/A | ·· |
| TPA | TPA-55765 | 2026-04-14T07:00:33Z | Eric·· | — | Cox | 03/26/58 | UHC-62852-94 | •••-••-6491 | UNKNOWN | — | 1825 Meadow Ln | Chandler | AZ | 85297 | — | CHOICE-PLUS-PPO |
| TPA | TPA-62207 | 2026-04-03T15:48:14Z | JORDAN | — | BANKS | 1980-04-06 | — | - | N/A | — | NULL | NULL | — | — | GRP-9080 | CHOICE-PLUS-PPO |
| TPA | TPA-61128 | 2026-09-24T16:12:32Z | Jose | E | Palmer | 1955-11-10 | — | null | UNKNOWN | NULL | 778 River Road | Columbus | OH | 43234·· | — | - |
| TPA | TPA-56509 | 2026-09-19T23:20:18Z | Jacob | K·· | Carr | 12/25/1995 | NULL | — | — | — | 473 GRAND AVE Apt 3 | San Antonio | TX | 78203-7248 | — | 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-22T12:42:56.321Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty