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-62554 | 2026-02-05T06:19:27Z | EMMA | X | LEIS | Apr 19, 1972 | — | - | N/A | ·N/A | — | — | — | null | — | NAVIGATE-HMO |
| TPA | TPA-52406 | 2026-07-08T04:25:13Z | Lawson, Gabriel | — | — | 9/1/1967 | — | ···· | (258) 237-6228 | — | 2751 UNION ST | Eden Prairie | MN | 55301 | N/A | — |
| TPA | TPA-54250 | 2026-04-21T05:57:28Z | Ralph | — | Owens | 12/11/1964 | — | NULL | NULL·· | NULL·· | 1795 Indian School Rd | Eden Prairie | MN | 55324 | UNKNOWN | MEDICARE-ADV-B |
| TPA | TPA-61326 | 2026-09-21T17:14:00Z | Perkins, Wayne | — | — | 1943-09-07 | — | •••-••-2036 | - | NULL | 5373 Highland Ave | Mesa | AZ·· | 85212 | null | — |
| TPA | TPA-55566 | 2026-06-06T05:49:46Z | Vasquez, George | P. | — | 2008-11-14 | - | — | null | NULL | 7870 River Road Apt 36 | PLANO | TX | 75085·· | null | - |
| TPA | TPA-53707 | 2026-01-01T00:34:40Z | bobby | — | jacobs | 1942-09-25 | — | — | (294) 943-8631 | bobby.jacobs92@aol.com | 1545 Jefferson Ave | San Antonio | Texas | 78285 | GRP-3977 | — |
| TPA | TPA-50404 | 2026-07-16T22:25:07Z | Munoz, Brandon | — | — | 1965-08-06 | — | ·UNKNOWN | (419) 903-4858 | UNKNOWN | 466 Desert Sky Blvd | Jacksonville | FL | 32253 | GRP-2664 | null |
| TPA | TPA-52859 | 2026-04-20T13:49:23Z | CYNTHIA·· | ···· | PIRCE | 10/01/1941 | N/A | •••-••-5666 | N/A | cynthia.price99@yahoo.com | 2275 Mountain View Drive | Los Angeles | CA | 90063 | - | ·OPTIONS-PPO |
| TPA | TPA-51021 | 2026-05-08T19:56:01Z | ·Diana | A. | Hudson | 1398-09-25 | — | — | N/A | null | - | - | - | — | NULL | MEDICARE-ADV-A |
| TPA | TPA-58937 | 2026-07-11T00:12:50Z | PATRICIA | — | ·GARZA | 1947-06-18 | null | null | UNKNOWN | — | null | — | N/A | - | UNKNOWN | CORE-HMO |
| TPA | TPA-52475 | 2026-04-11T22:29:41Z | Jack | M. | Ortiz | 12/15/1957 | ·UHC-23081-51 | NULL | — | UNKNOWN | 8618 Elm St | Mesa | ·Arizona | 85234 | NULL | UNKNOWN |
| TPA | TPA-54304 | 2026-03-22T15:01:12Z | Bryan | — | Williams | 20070809·· | ·- | N/A | — | UNKNOWN | 3380 Park Place | Tempe | AZ | 85201·· | N/A | null |
| TPA | TPA-55473 | 2026-05-17T23:48:01Z | BEVELRY | — | PADILLA | ·12/19/1988 | N/A | — | 6967591907 | null | 404 PARK PLACE | Denver | CO | 80256 | UNKNOWN | NULL |
| TPA | TPA-60034 | 2026-01-23T20:15:07Z | GEORGE | — | CHAPMAN | 9/5/1951 | — | ···· | null | NULL | 788 ELM ST | Tempe | AZ | ·85264 | NULL | — |
| TPA | TPA-57248 | 2026-08-30T00:04:03Z | Aguilar, Yuki | — | — | 1987-12-19 | — | •••-••-0157 | UNKNOWN | ·N/A | — | - | — | N/A | GRP-3151 | — |
| TPA | TPA-53201 | 2026-04-16T13:41:21Z | PAUL | B | FOSTER·· | 02/05/1983 | null | NULL | NULL | N/A | 4047 Washington Street | San Antonio | TX | 78240 | — | MEDICARE-ADV-B |
| TPA | TPA-61362 | 2026-06-11T20:48:17Z | Yuki | ·· | Perez | 1/19/1986 | NULL | — | — | ·NULL | 5798 ELM STREET | Sacramento | CA | 95846 | — | — |
| TPA | TPA-58432 | 2026-01-13T04:52:19Z | Victoria | ·· | Yang | 1998-08-24 | null | NULL·· | (871) 553-2764 | — | 4664 Forest Avenue | Gilbert | AZ | 85248-8364 | - | null |
| TPA | TPA-58355 | 2026-09-21T11:27:47Z | Adam | W | Ortega | 6/8/1967 | — | NULL | ···· | ···· | 8102 MOUNTAIN VIEW DR | Orlando | fl | 32855 | GRP-7955 | — |
| TPA | TPA-59952 | 2026-04-20T04:01:52Z | Natalie | — | Dixon·· | 1946-12-08 | N/A | — | null | — | 2013 Forest Ave | Scottsdale | AZ | 85208·· | — | - |
| TPA | TPA-53860 | 2026-01-17T16:54:35Z | NANCY | — | SIMPSON | 1956-04-01 | UHC-55422-71·· | — | (205) 958-5506 | — | 5617 JEFFERSON AVE | SACRAMENTO | CA | ·95828 | GRP-8771 | — |
| TPA | TPA-61403 | 2026-03-01T10:41:51Z | BARB | — | LITTLE | 1987-04-01 | NULL | — | 4963848797·· | — | 629 Spring St | SACRAMENTO | CA | 95841 | GRP-3619 | NAVIGATE-HMO |
| TPA | TPA-58033 | 2026-01-21T23:10:13Z | Powell, Jennifer | — | — | 1953-10-20 | null | — | — | UNKNOWN | 5942 FOREST AVE | Gilbert | AZ | ·NULL | GRP-2801 | MEDICARE-ADV-A |
| TPA | TPA-64339 | 2026-05-09T13:12:03Z | KIMBERLY | — | ·GUTIERREZ | 5/12/1944 | — | •••-••-8070 | UNKNOWN | N/A | 8251 Sage Ct | Tucson | AZ | 85796 | — | MEDICARE-ADV-B·· |
| TPA | TPA-61588 | 2026-10-02T02:58:15Z | Gary | — | Gray | 1961-07-03 | NULL | NULL | N/A | GARY.GRAY98@OUTLOOK.COM | 462 Grand Ave | Nashville | TN | 37249 | — | — |
| TPA | TPA-58158 | 2026-02-14T07:39:27Z | ISSABELLA | — | MCDONALD | 02-08-1967 | - | N/A | (481) 626-2445 | — | NULL | — | — | UNKNOWN | — | ·CORE-HMO |
| TPA | TPA-58113 | 2026-02-01T17:34:49Z | Omar | Y. | Evans | 1971-06-08 | -·· | — | — | - | 3145 Jefferson Ave | CHARLOTTE | NC | 28242 | - | — |
| TPA | TPA-54285 | 2026-05-19T13:56:31Z | Gonzalez, Carlos | — | — | 2004-10-12 | ·UNKNOWN | •••-••-7276 | (343) 417-3094 | — | UNKNOWN | - | UNKNOWN | — | - | UNKNOWN |
| TPA | TPA-62546 | 2026-09-06T18:46:19Z | Douglas | ···· | Santos | 21-02-1942 | — | N/A | - | DOUGLAS.SANTOS76@ICLOUD.COM | — | UNKNOWN | — | — | GRP-6465 | — |
| TPA | TPA-60772 | 2026-06-11T11:55:25Z | ANGELA | — | WELLS | 1985-07-25·· | UHC-29972-07 | — | NULL | angela.wells49@outlook.com | 2563 Pine Dr | Fresno | CA | 93715 | null | NAVIGATE-HMO |
| TPA | TPA-64042 | 2026-04-01T11:37:11Z | Ruth | — | Hudson | 19660212 | — | •••-••-3329 | — | - | 6660 Market Street | EDEN PRAIRIE·· | MN | 55384-3503 | — | N/A |
| TPA | TPA-58769 | 2026-08-28T05:56:18Z | Peter | — | Duncan | 04/19/1950 | - | NULL | 9421748·· | — | 445 Elm Street | Gilbert | AZ·· | 85225 | GRP-7179 | UNKNOWN |
| TPA | TPA-63664 | 2026-09-10T18:46:34Z | Stephens, Dylan | R. | — | Aug 3, 1982 | ·· | — | 387-807-0018 | - | 8540 Meadow Lane | Plano | TX | 75048-4432 | N/A | — |
| TPA | TPA-57680 | 2026-06-20T00:23:50Z | Austin, Jeremy | — | — | 1956-05-06 | — | — | 515.542.5207 | jeremy.austin@hotmail.com | 1708 APACHE BOULEVARD | MINNEAPOLIS | MN | ·55441 | GRP-7174 | MEDICARE-ADV-A |
| TPA | TPA-57433 | 2026-07-14T14:43:14Z | SOPHIA | — | WATKINS | ·1947-12-21 | NULL | •••-••-0818 | ·N/A | UNKNOWN | 3945 MEADOW LN | Seattle | ·WA | 98173 | GRP-6612 | MEDICARE-ADV-A |
| TPA | TPA-59174 | 2026-05-18T18:59:26Z | VINCENT | ·· | CASTRO | 1995-11-17 | — | NULL | 6929027527 | N/A | 6652 Valley View Drive | Orlando | FL | 32852 | ···· | ···· |
| TPA | TPA-60784 | 2026-10-12T19:48:01Z | Kyle | — | Dean | 09-08-1965 | N/A | null·· | null | - | 7843 Baseline Road | Fresno | CA | 93766 | N/A | UNKNOWN |
| TPA | TPA-57584 | 2026-04-30T23:05:32Z | Mark | — | Hawkins·· | ·1973-02-22 | ·- | •••-••-9442 | NULL | NULL | 1648 Main Street | TEMPE | ·Arizona | 85289 | — | CHOICE-PLUS-PPO |
| TPA | TPA-53940 | 2026-04-16T08:37:04Z | betty | — | fields | Aug 24, 2006 | UHC-24111-97 | - | +1 547 873 8985 | betty.fields@hotmail.com | 2940 CEDAR LANE | Scottsdale | AZ | 85273 | GRP-8918 | MEDICARE-ADV-B |
| TPA | TPA-64425 | 2026-03-29T01:08:01Z | Madison | — | Hunt | 1993-05-07 | — | null | UNKNOWN | - | 2547 Mesa Drive | Tucson | AZ | 85736 | — | MEDICARE-ADV-A |
| TPA | TPA-53655 | 2026-05-11T11:42:10Z | tom | — | richardson | 1996-01-21 | UHC-44503-57 | •••-••-4537 | NULL | UNKNOWN | 8105 Bayshore Drive | Tucson | ·AZ | 85775 | - | — |
| TPA | TPA-54066 | 2026-07-12T09:29:31Z | Luri | — | Graham | 1968-06-02·· | -·· | •••-••-7669 | +1 809 848 3852 | N/A | 4806 Palm Drive | Jacksonville | FL | 32211 | null | NAVIGATE-HMO·· |
| TPA | TPA-62827 | 2026-07-22T20:12:15Z | ·Ethan | — | Ross | 7/19/2004 | — | NULL | — | ethan.ross@icloud.com | 6087 Highland Ave | Columbus | OH | 43206 | — | — |
| TPA | TPA-64236 | 2026-04-28T16:33:57Z | SARA | — | WARREN | 1960-10-23 | NULL | UNKNOWN | +1 737 669 7523 | NULL | 1795 DESERT SKY BLVD | Dallas | ·TX | 75283 | — | CORE-HMO |
| TPA | TPA-57126 | 2026-01-11T07:23:05Z | RONALD | — | BROWN | 1964-02-24 | NULL | NULL | 12945384752 | UNKNOWN | — | - | UNKNOWN | NULL | N/A | - |
| TPA | TPA-50042 | 2026-10-11T13:44:44Z | KYLE | — | CARR | 1978-09-07 | null | null | ·NULL | NULL | 8327 Apache Boulevard | Scottsdale | AZ | 85275 | — | MEDICARE-ADV-A |
| TPA | TPA-54103 | 2026-08-16T13:26:39Z | AISHA | — | PRICE | 1939-08-27 | ·NULL | •••-••-7612 | ·N/A | aisha.price86@yahoo.com | 2027 Ocean Ave | Miami | FL | 33124·· | N/A | UNKNOWN |
| TPA | TPA-50690 | 2026-04-11T12:18:33Z | Luis | — | Mejia·· | ·2/19/1977 | N/A | •••-••-8921 | NULL·· | luis.mejia71@aol.com | 3420 Ridge Rd | Phoenix | az | 85029 | UNKNOWN | null |
| TPA | TPA-61103 | 2026-01-08T19:51:33Z | mateo | — | alexander | 1973-03-12 | — | — | (552) 734-1703·· | — | 3499 PINE DRIVE·· | ·Tucson | AZ | 85763 | UNKNOWN | SELECT-EPO |
| TPA | TPA-63814 | 2026-10-03T05:48:05Z | julie | — | martinez | 1955-04-23 | — | null | NULL | — | 19 Maple Ave | Tampa | FL | 33635 | - | choice-plus-ppo |
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.496Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty