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-63917 | 2026-06-14T05:59:46Z | Lauren | — | Ryan | 1942-09-26 | — | •••-••-8856 | 328.617.9340 | — | 514 Lake View Road | GLENDALE | AZ | 85314-7161 | — | NAVIGATE-HMO |
| TPA | TPA-57407 | 2026-01-30T23:06:08Z | Reed, Michelle | P·· | — | ·1962-08-23 | ·UHC-33270-80 | - | 6369202 | null | 8956 Central Avenue | SAN DIEGO | California | 92173-1459 | NULL | OPTIONS-PPO·· |
| TPA | TPA-55424 | 2026-07-29T08:47:09Z | SHARON | — | DAVIS | 12/16/1962 | — | •••-••-0017 | — | — | 5576 Highland Avenue | Fresno | California | 93750-7351 | — | — |
| TPA | TPA-59611 | 2026-03-29T04:40:05Z | maria | — | mejia | 1995-03-27 | N/A | UNKNOWN | N/A | UNKNOWN | 5526 Spring Street | Mesa | AZ | 85227·· | — | MEDICARE-ADV-A |
| TPA | TPA-63328 | 2026-02-14T09:04:30Z | Nancy B. | — | Gilbert | 1976-03-20 | — | N/A | N/A | - | 4914 FOREST AVE | San Antonio | TX | 78206 | UNKNOWN | NULL |
| TPA | TPA-63021 | 2026-09-04T07:07:36Z | Brenda | — | Nelson | 1990-11-03 | — | — | (513) 964-6923 | - | 2173 Indian School Rd·· | Tampa | FL | 33643 | — | NULL |
| TPA | TPA-51258 | 2026-01-08T04:36:04Z | James | — | ·Reid | 13-10-2008 | UHC-04022-72 | null | — | NULL | 5685 SAGE COURT #446 | Scottsdale | AZ | 85269 | — | — |
| TPA | TPA-62203 | 2026-10-12T21:55:54Z | Maadison | — | Taylor | 1940-07-08 | UHC-46048-40 | •••-••-9338 | (293) 799-5844 | — | 3153 Oak Street | Fresno | CA | 93751-4839 | null | N/A |
| TPA | TPA-51050 | 2026-08-14T03:50:37Z | BRYAN | — | FERNANDEZ | 05/08/85 | - | UNKNOWN | 371-614-1127 | UNKNOWN | 1556 Canyon Rd | Minneapolis | MN | 55432 | — | null |
| TPA | TPA-51128 | 2026-09-03T09:19:41Z | Kally | — | Lawson | 1976-01-10 | — | N/A | 888-838-4992 | — | 2654 Sunset Blvd | Miami | FL·· | 33192 | NULL | UNKNOWN |
| TPA | TPA-64216 | 2026-08-31T17:43:54Z | Helen | — | Jacobs | ·2/4/1998 | — | ···· | UNKNOWN | — | 2811 Desert Sky Blvd #709 | LAS VEGAS | NV | 89160 | GRP-9468 | — |
| TPA | TPA-58775 | 2026-10-08T03:24:02Z | Kathryn | Y | Robinson | 19680513 | null | •••-••-2121 | - | kathryn.robinson@yahoo.com | 3930 PALM DRIVE | ·LAS VEGAS | NV | 89171 | GRP-7620 | - |
| TPA | TPA-52056 | 2026-03-02T23:09:17Z | AISAH | — | ROBINSON | 1990-08-11 | — | — | 5423957155 | aisha.robinson32@outlook.com | 9227 CANYON RD | Chandler | AZ | 85251 | GRP-5627 | — |
| TPA | TPA-63734 | 2026-03-09T12:34:09Z | Sarah | F | Ray | 1952-07-04 | UNKNOWN | — | 15277588326 | N/A | — | ·· | — | — | NULL | -·· |
| TPA | TPA-57612 | 2026-08-29T23:26:27Z | Matthew | — | Dunn | 11/24/2008 | — | - | +1 780 605 1992 | N/A | 2604 Ocean Avenue | Tempe | AZ | 85282 | — | NAVIGATE-HMO·· |
| TPA | TPA-51660 | 2026-05-31T21:37:47Z | Doris | — | Matthews | 07/09/44 | null | •••-••-8175 | — | — | 8753 Pine Drive | ORLANDO | FL | 32880 | null | CORE-HMO·· |
| TPA | TPA-60881 | 2026-03-24T02:21:46Z | Sofia | H | Phillips | 2008-02-28 | — | — | — | — | 9700 Lake View Road | Los Angeles | CA | 90073 | null | SELECT-EPO |
| TPA | TPA-50731 | 2026-01-13T04:56:41Z | ·Abby | — | Coleman | Jan 12, 1951 | ···· | — | 6177974325 | — | 6206 Ridge Rd | Denver | ·CO | — | — | SELECT-EPO |
| TPA | TPA-54668 | 2026-06-28T15:08:55Z | Benjamin | — | Maldonado | 12/12/96 | — | null | 9852710885 | ·N/A | ·3930 APACHE BOULEVARD | Scottsdale | AZ | 85283 | ·N/A | — |
| TPA | TPA-62597 | 2026-10-05T21:25:35Z | hannah | — | nelson | 1987-03-10 | - | UNKNOWN | null | — | 7495 Mesa Dr | Tampa | FL | — | GRP-5702 | choice-plus-ppo |
| TPA | TPA-64159 | 2026-02-08T03:10:12Z | Virginia | — | Luna | Feb 7, 1952 | N/A | ·· | null | — | 5487 PALM DR | Chandler | AZ | 85200 | GRP-6657 | NULL |
| TPA | TPA-61031 | 2026-02-14T01:18:25Z | ·Arjun | — | Coleman | 1985-06-02 | UNKNOWN | - | — | — | 9309 Willow Court Apt 39 | ·SCOTTSDALE | ·AZ | 85233 | N/A | — |
| TPA | TPA-62586 | 2026-08-08T22:40:47Z | Hannah | G. | Moore | 3/27/1963 | NULL·· | null | — | — | 4706 CENTRAL AVENUE | ·MINNEAPOLIS | mn | 55435 | GRP-8157 | MEDICARE-ADV-B |
| TPA | TPA-59048 | 2026-07-14T06:46:26Z | Bryan | — | Ryan | ·2005-03-05 | UHC3370677 | •••-••-7237 | 868-427-9761·· | - | 9245 HIGHLAND AVE | Tempe | AZ | 85270-0200 | null | — |
| TPA | TPA-54370 | 2026-04-19T02:54:21Z | Noah | — | Reid | 1965-08-22 | N/A | •••-••-2724 | null | - | 360 Sage Court | CHARLOTTE | NC | 28208 | GRP-7370 | null |
| TPA | TPA-52546 | 2026-09-05T03:12:38Z | MARTHA | — | AUSTIN | 1992-04-23 | — | — | 3203048096 | - | ·4820 Ocean Ave | Denver | CO | 80204-9724 | NULL | ·NAVIGATE-HMO |
| TPA | TPA-58010 | 2026-01-12T09:20:31Z | WALTER | — | GUZMAN | 07/20/1980 | UHC-84623-41 | - | N/A | — | 9478 Washington Street | TUCSON | AZ | 85787 | - | N/A·· |
| TPA | TPA-63452 | 2026-06-21T22:31:01Z | Sandra·· | N | Reynolds·· | 1971-06-18 | — | N/A | (479) 307-2564 | sandra.reynolds@aol.com | 5740 Indian School Road | ·Scottsdale | AZ | 85229-4122 | — | N/A |
| TPA | TPA-63731 | 2026-07-09T17:09:01Z | Pamela | — | ·Bailey | ·1976-09-06 | — | •••-••-7495 | — | - | 3492 Meadow Ln | Eden Prairie | MN | 55373 | GRP-1796 | ·null |
| TPA | TPA-54287 | 2026-10-14T07:07:42Z | LUCIA·· | — | FOSTER | 1944-01-24 | ·· | •••-••-5197 | - | — | ·9070 MAPLE AVE | Atlanta | GA | 30364 | N/A | NULL |
| TPA | TPA-55246 | 2026-03-20T07:55:13Z | emily | — | ryan | 1955-12-20 | - | NULL | (559) 922-5285 | ·· | 7230 Central Ave | Austin | TX | 78750 | NULL | N/A |
| TPA | TPA-58785 | 2026-02-09T22:21:18Z | Fernandez, Ralph | ·· | — | Jul 7, 1943 | NULL | — | — | — | UNKNOWN | — | N/A | N/A | — | — |
| TPA | TPA-58573 | 2026-06-03T02:37:59Z | CHERYL | ·· | RIVERA | 1943-05-15 | UNKNOWN | - | +1 564 215 4559 | CHERYL.RIVERA@OUTLOOK.COM | N/A | NULL | NULL | ·null | N/A | MEDICARE-ADV-A |
| TPA | TPA-54013 | 2026-03-07T02:41:42Z | Frances | — | Simpson·· | Dec 3, 2006 | - | •••-••-1752 | null | NULL | 4657 FOREST AVENUE | PLANO | TX | 75084 | — | — |
| TPA | TPA-60014 | 2026-04-19T11:25:32Z | ·William | V | Pierce | 1971-02-24 | — | •••-••-6820 | 6282685089 | — | 4291 Pine Dr | San Antonio | TX | 78228 | null | UNKNOWN |
| TPA | TPA-56145 | 2026-02-01T00:26:32Z | Sharon·· | — | Scott | 6/19/1977 | — | NULL | - | N/A | 463 Pine Drive | San Diego | CA | 92102 | GRP-3271 | N/A |
| TPA | TPA-64095 | 2026-10-08T03:59:12Z | Sandoval, Jacqueline | — | — | 1955-11-17 | UHC0541548 | — | (705) 218-9275 | NULL·· | 1902 Canyon Road | Dallas | Texas | 75237 | — | SELECT-EPO |
| TPA | TPA-63490 | 2026-06-13T08:13:43Z | ALEXANDER | — | LAWRENCE·· | 1974-03-07 | ·· | N/A | 608-728-6552·· | alexander.lawrence6@gmail.com | 4292 Grand Avenue | JACKSONVILLE | FL | 32279 | — | — |
| TPA | TPA-61007 | 2026-07-15T20:20:23Z | Jesse·· | — | Spencer | 1948-11-07 | N/A | NULL | 18872955665 | UNKNOWN | 3187 Meadow Ln | Tampa | FL | 33697 | — | — |
| TPA | TPA-51965 | 2026-02-16T10:37:24Z | Gary | — | Burke | 1963-05-22 | null | — | N/A | — | 2576 Lake View Rd | Miami | FL | — | GRP-1792 | - |
| TPA | TPA-50617 | 2026-08-26T18:09:23Z | ·jack | U·· | hunt | 1974-11-04 | NULL·· | UNKNOWN | NULL | JACK.HUNT94@ICLOUD.COM | 8639 MAIN ST | ·Miami | FL | ·33144-4371 | NULL | null |
| TPA | TPA-53059 | 2026-10-07T17:34:57Z | Ralph | I. | Howell | 12/28/78 | null | null | N/A·· | ralph.howell@icloud.com | 6338 Mountain View Dr | Los Angeles | CA | 90030 | GRP-6613 | N/A |
| TPA | TPA-50004 | 2026-08-23T04:25:50Z | Sophia | — | Ramirez·· | 1974-07-12 | N/A | — | 719.668.1436 | sophia.ramirez57@icloud.com | 1154 Indian School Road | Dallas | TX | 75285 | GRP-7771 | SELECT-EPO |
| TPA | TPA-55959 | 2026-03-30T14:09:41Z | Ann | G. | ·Simpson | 1984-06-28 | ···· | null | UNKNOWN | ann.simpson@gmail.com | 9591 Camelback Rd | Atlanta | GA | 30397-2192 | GRP-9177 | NULL |
| TPA | TPA-57247 | 2026-01-16T07:53:37Z | LAURA | I | HERRERA | 06/27/1959 | UHC-79427-43 | •••-••-5294 | 2112781293 | null | null | null | — | NULL | — | null |
| TPA | TPA-52962 | 2026-03-13T04:51:11Z | Kelly | — | Ellis | 1950-09-14 | null | N/A | 851-393-2723 | NULL | 1454 Sage Ct | EDEN PRAIRIE | MN | 55378 | NULL | — |
| TPA | TPA-60313 | 2026-03-13T03:51:45Z | SANTIAGO | — | FULLER | 08/15/50 | UNKNOWN | •••-••-3795 | 7333547928 | UNKNOWN | ·7215 Jefferson Avenue | Scottsdale | AZ | 85221 | GRP-1137 | OPTIONS-PPO |
| TPA | TPA-50253 | 2026-06-09T12:13:45Z | MATEO | — | ESPINOZA | 19790321·· | UHC-22304-73 | •••-••-6501 | 17177346822 | null | 2755 Central Ave | Austin | TX | 78798-8679 | — | null |
| TPA | TPA-55596 | 2026-08-05T13:34:25Z | JUUDY | — | JACKSON | 1966-08-27 | null | •••-••-5937 | 525-589-5129 | UNKNOWN | 645 Lake View Rd | Sacramento·· | CA | — | GRP-0263 | - |
| TPA | TPA-52873 | 2026-08-05T14:29:47Z | Carl | — | Pena | 1953-07-21 | N/A | — | 7453018369 | NULL | 4429 Baseline Road | Tucson·· | AZ | 85709-6614 | GRP-1976 | 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:40.614Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty