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-58873 | 2026-07-12T12:57:36Z | Adam | — | Peterson | 05/01/1997 | null | — | N/A·· | UNKNOWN | 782 Palm Drive | Scottsdale | AZ | 85228 | GRP-3642 | MEDICARE-ADV-B |
| TPA | TPA-56799 | 2026-03-06T15:46:24Z | — | — | — | 12/4/1944 | — | - | — | charlotte.obrien@gmail.com | ·2619 Central Avenue | SAN DIEGO | CA | 92110 | - | — |
| TPA | TPA-56025 | 2026-08-08T23:16:19Z | Roy | — | Li | 07-03-2005 | NULL | N/A | N/A | — | ·5854 Harbor Boulevard | Las Vegas | Nevada | 89181 | UNKNOWN | NULL |
| TPA | TPA-59753 | 2026-01-26T20:00:43Z | Mary | — | Holmes | 1941-12-03 | — | ···· | 2742436759 | — | 2184 Lincoln Way | LOS ANGELES | CA | 90071 | — | — |
| TPA | TPA-52765 | 2026-01-13T21:11:02Z | Ashley | C. | Kim | 1975-12-28 | - | NULL | 18426090029 | null | 4485 Forest Avenue | TEMPE | AZ | 85263 | ···· | CORE-HMO |
| TPA | TPA-50276 | 2026-04-05T06:36:39Z | GARY | — | GUTIERREZ | 1992-12-06 | N/A·· | •••-••-8045 | 381-341-8968 | — | 2995 MARKET STREET | Eden Prairie | MN | 55325 | GRP-2243 | — |
| TPA | TPA-53995 | 2026-02-09T17:54:16Z | KELLY | F. | BAILYE | 1971-02-27 | - | •••-••-6306 | — | UNKNOWN | N/A | ···· | NULL | ···· | — | UNKNOWN |
| TPA | TPA-56713 | 2026-10-03T13:03:41Z | Carlos | — | Richardson | 1994-06-02 | UHC-86386-38 | ·· | — | - | 9280 Forest Ave Apt 4 | Minneapolis | MN | 55458 | N/A | - |
| TPA | TPA-54457 | 2026-08-26T03:37:08Z | Lauren | — | Gutierrez | 1989-01-04 | — | — | - | — | 9548 Broadway | Orlando | FL | 32831·· | GRP-1733 | null |
| TPA | TPA-54437 | 2026-08-30T23:18:44Z | Bruce | — | ·Watson | ·10/1/1956 | ···· | — | N/A·· | UNKNOWN | 8285 Ocean Ave | Mesa | AZ | 85289 | GRP-6817 | N/A |
| TPA | TPA-63133 | 2026-09-20T12:03:37Z | Timothy | — | Simmons | 1950-79-16 | - | N/A | - | — | 4725 OCEAN AVENUE #843 | Orlando | FL | 32872 | GRP-8799 | ·NULL |
| TPA | TPA-64185 | 2026-02-04T02:31:13Z | Fox, Melissa | — | — | 1979-10-28 | N/A | NULL | +1 332 636 3708 | ·· | UNKNOWN·· | — | null | UNKNOWN | UNKNOWN·· | — |
| TPA | TPA-63325 | 2026-03-08T17:16:47Z | Ronald | — | Thomas | 1999-03-07 | N/A | — | NULL | N/A | ·700 Grand Ave Apt 11 | LOS ANGELES | CA | 90054-4845 | GRP-4407·· | ·null |
| TPA | TPA-62320 | 2026-04-15T00:19:23Z | Randy | — | Vazquez | 1960-06-15 | ·NULL | — | N/A | — | 9686 LAKE VIEW ROAD | AUSTIN | TX | 78792 | UNKNOWN | CORE-HMO |
| TPA | TPA-62488 | 2026-08-13T07:28:23Z | Ralph | — | Miller | 1987-08-17 | — | — | 6123403087 | — | N/A | — | — | null | — | CHOICE-PLUS-PPO |
| TPA | TPA-61919 | 2026-04-25T23:27:46Z | BARB | O | PIERCE | 3/18/1952 | N/A | •••-••-0937 | ·UNKNOWN | — | 9542 River Rd | Houston | TX | 77051 | - | null |
| TPA | TPA-55659 | 2026-09-22T09:30:48Z | Kathryn | — | Lawrence | 1992-05-09 | — | •••-••-9375 | NULL | N/A | 6151 BROADWAY | Columbus | OH | 43227 | — | — |
| TPA | TPA-61850 | 2026-01-26T09:29:06Z | Carolyn | — | Jimenez | 1945-05-14 | UHC-56314-20 | •••-••-5235 | null | N/A | null | - | ·NULL | - | — | UNKNOWN |
| TPA | TPA-58418 | 2026-01-07T07:22:46Z | Warren, Elizabeth | — | — | 1980-09-25 | — | — | +1 746 471 4608 | — | 8697 Washington St | HOUSTON | TX | NULL | — | NAVIGATE-HMO |
| TPA | TPA-50849 | 2026-07-05T00:36:50Z | ALBERT | — | FIELDS | 03-03-1969 | — | NULL | (966) 211-9279 | ·N/A | 3255 UNION STREET | Minneapolis | MN | 55420·· | null | CHOICE-PLUS-PPO |
| TPA | TPA-54055 | 2026-10-07T17:48:03Z | Romero, Matthew | R. | ···· | 1972-07-08 | — | — | 765-337-5419·· | — | 138 Market Street | Tempe·· | AZ | 85226 | NULL | UNKNOWN |
| TPA | TPA-56702 | 2026-03-06T08:17:36Z | Donnald | — | Fowler | 03/25/05 | NULL | — | 2264009481 | — | - | NULL | — | — | GRP-3022·· | -·· |
| TPA | TPA-52257 | 2026-06-10T08:30:21Z | Carlos | I. | Richardson | 1953-10-16 | N/A | - | - | CARLOS.RICHARDSON17@ICLOUD.COM | 7392 HIGHLAND AVE | Las Vegas | NV | 89121 | UNKNOWN | - |
| TPA | TPA-50134 | 2026-04-12T06:38:07Z | Charles | — | Palmer | 02/11/94 | ···· | ···· | (278) 313-9745 | N/A | ·6887 Valley View Drive | Columbus | oh | 43259 | N/A | MEDICARE-ADV-A |
| TPA | TPA-63425 | 2026-06-01T09:21:25Z | VINCENT | — | MEYER·· | 1984-12-22 | NULL | •••-••-8761 | 367-838-6470 | NULL | 237 Sage Court | PLANO | TX | 75014 | NULL | NULL |
| TPA | TPA-64371 | 2026-01-14T04:46:01Z | JULIE | — | MEDINA | 05-05-2004 | ·UHC-60078-04 | null | — | NULL | 7323 Apache Blvd | Austin | TX | 78743 | GRP-6974 | UNKNOWN |
| TPA | TPA-61587 | 2026-01-15T18:41:10Z | Andrea | — | Chavez | 1962-08-10 | N/A | null | UNKNOWN·· | N/A | 2030 MOUNTAIN VIEW DR | TEMPE | Arizona | 85276 | GRP-4562 | UNKNOWN |
| TPA | TPA-50265 | 2026-07-26T17:21:16Z | RUSSELL | J. | CARLSON | 1972-11-07 | UHC-54250-93 | — | ·N/A | — | 1405 Valley View Dr | Orlando | FL | 32863 | GRP-9363 | ···· |
| TPA | TPA-57348 | 2026-02-08T03:35:52Z | Michael·· | — | Lee | 1965-11-28 | UHC-18645-50 | •••-••-6248 | (643) 255-2719 | — | null | N/A | N/A | null | GRP-8114 | — |
| TPA | TPA-61107 | 2026-07-23T12:23:55Z | Wei | — | Knight | 01/13/2003 | — | NULL | NULL | wei.knight@yahoo.com | 5983 Harbor Boulevard | Minneapolis | MN | 55440 | — | — |
| TPA | TPA-54984 | 2026-07-10T07:23:02Z | Billy | — | Hansen·· | 13-03-1960 | UNKNOWN | UNKNOWN | UNKNOWN | null | - | null | - | UNKNOWN | ·GRP-3670 | null |
| TPA | TPA-57255 | 2026-01-22T21:37:11Z | YUKI | — | CHAPMAN | 2002-02-19 | -·· | •••-••-9731 | NULL | UNKNOWN | UNKNOWN | -·· | N/A | NULL | GRP-1568·· | N/A |
| TPA | TPA-64298 | 2026-02-09T20:59:29Z | marcus | — | roberts | Feb 28, 1956 | — | •••-••-3460 | 666-392-4690 | marcus.roberts@proton.me | 8092 Oak Street | Charlotte | NC | 28233 | — | — |
| TPA | TPA-59643 | 2026-03-07T06:52:42Z | James | — | Wright | 1956-09-07 | UHC-07765-75 | •••-••-2288 | null | - | 9023 Ridge Rd | ·Miami | FL | 33103 | - | ·N/A |
| TPA | TPA-61310 | 2026-07-22T18:48:38Z | ahmed | I | li | -·· | — | — | UNKNOWN | null | 9424 Park Pl | ·Eden Prairie | Minnesota | 55361·· | UNKNOWN | — |
| TPA | TPA-63420 | 2026-08-30T21:38:23Z | Beverly | — | Reid | Dec 17, 1967 | — | N/A | - | N/A | 6813 Sunset Boulevard | Austin | tx | 78705 | - | null |
| TPA | TPA-51263 | 2026-03-30T09:12:20Z | wei·· | — | gardner | 20021112 | — | — | 8488640320 | — | 9666 Canyon Rd | Mesa | AZ | 85212 | null | null |
| TPA | TPA-52972 | 2026-02-01T09:58:18Z | LORI | — | LUCAS | 1953-12-09 | UHC-00588-86 | - | 2448153512 | ···· | 9365 Palm Drive | Denver | ·CO | 80288 | null | UNKNOWN |
| TPA | TPA-57102 | 2026-01-02T18:55:03Z | Pamela | — | Ruiz | 1973-02-23 | — | NULL | N/A | - | 383 Meadow Ln | CHARLOTTE | nc | 28235-3799 | — | ···· |
| TPA | TPA-61039 | 2026-08-04T13:15:00Z | Cox, Joe | — | ···· | 10/4/1997 | -·· | — | — | — | 9489 Mountain View Dr | Plano | TX | 75039 | N/A | — |
| TPA | TPA-53214 | 2026-03-06T21:12:38Z | ·DOT | — | MEDINA | 19-10-1967·· | N/A | N/A | NULL | null | 1837 PINE DR | HOUSTON | TX | 77041 | N/A | null |
| TPA | TPA-50053 | 2026-04-14T09:17:38Z | Yang, Nathan | Q | — | 12/19/1989 | — | — | — | ···· | 7436 River Rd Apt 16·· | Seattle | WA | 98190 | NULL | ·null |
| TPA | TPA-55901 | 2026-09-23T09:40:09Z | elizabeth | S | tucker | 1945-01-16 | NULL·· | NULL | (692) 639-9135 | — | 5669 Meadow Lane | Minneapolis | MN | 55496 | — | N/A |
| TPA | TPA-52589 | 2026-09-02T16:49:09Z | ·Brittany | — | Johnston | 06/16/05 | — | - | UNKNOWN·· | - | ···· | — | — | — | UNKNOWN | UNKNOWN |
| TPA | TPA-63560 | 2026-01-12T18:57:33Z | Lucia | — | Gomez | 02/02/1997 | UHC-42126-16 | — | (528) 360-1314 | — | ·5088 Union Street | Gilbert | Arizona | 85255 | GRP-9339 | — |
| TPA | TPA-62776 | 2026-09-22T06:54:02Z | CHERYL | — | WEAVER | 1965-09-19 | — | - | - | UNKNOWN·· | 5516 Lake View Road | Miami | FL | 33126 | null | — |
| TPA | TPA-50564 | 2026-09-24T08:47:40Z | Grae | — | Alvarado | 1945-12-20 | — | •••-••-6565 | null | N/A | ·806 Desert Sky Blvd | Atlanta | GA | ·30330 | N/A | NULL |
| TPA | TPA-54553 | 2026-07-12T01:10:36Z | SARA | — | CAMPBELL | ·12/26/42 | N/A | null | (294) 960-6419 | SARA.CAMPBELL69@YAHOO.COM | 5159 DESERT SKY BOULEVARD | Gilbert | AZ | 85261 | ···· | ···· |
| TPA | TPA-59217 | 2026-07-17T12:32:35Z | William | — | Freeman | 1954-03-22 | UNKNOWN | •••-••-4033 | UNKNOWN | william.freeman53@proton.me | 765 HIGHLAND AVENUE | Plano | TX | 75071 | GRP-7298 | NAVIGATE-HMO |
| TPA | TPA-57538 | 2026-06-30T10:58:10Z | Matthews, Russell | — | — | 1282-19-64 | UNKNOWN | - | (968) 439-7875 | - | N/A | - | - | — | GRP-1018 | UNKNOWN |
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.331Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty