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-59416 | 2026-02-12T10:50:11Z | Stephen | ···· | Jimenez | 9/27/2006 | — | — | N/A·· | UNKNOWN | 3249 Bayshore Dr | Denver | CO | 80254 | null | UNKNOWN |
| TPA | TPA-52846 | 2026-09-27T02:44:23Z | Evelyn | — | Simmons | 03/10/1972 | - | — | N/A | null | UNKNOWN | UNKNOWN | — | null | N/A | MEDICARE-ADV-B |
| TPA | TPA-61474 | 2026-08-21T21:53:33Z | Aisha | — | Sullivan | 1941-02-07 | N/A | •••-••-6224 | null | AISHA.SULLIVAN65@ICLOUD.COM | 4715 Grand Ave | Gilbert | AZ | 85222 | NULL | null·· |
| TPA | TPA-53962 | 2026-06-08T23:14:33Z | betty | — | fields | 1990-09-12 | UHC-71045-07 | UNKNOWN | (867) 251-1619 | UNKNOWN | ·4666 Broadway | Charlotte | NC·· | 28275 | GRP-4822 | — |
| TPA | TPA-54711 | 2026-06-08T00:31:40Z | Susan | — | Gordon | 1960-11-23 | UHC-75486-27 | — | - | - | 3226 Grand Ave | Tucson·· | AZ | 85749 | UNKNOWN | N/A |
| TPA | TPA-63093 | 2026-05-02T06:20:43Z | Richard | — | Carpenter | 01/14/73 | UHC-63811-16 | NULL | N/A | — | ·1751 ELM ST | Fresno | CA | 93766 | — | N/A |
| TPA | TPA-54474 | 2026-05-01T17:26:23Z | Edwards, Sarah | — | — | 1941-04-27 | NULL | — | — | — | 7813 Main St | San Diego | CA | ·92118 | — | — |
| TPA | TPA-59844 | 2026-01-22T02:26:41Z | Black | — | Daniel | 2005-02-09 | - | •••-••-0079 | 950-857-7341 | daniel.black12@aol.com | 4370 Spring St | Phoenix | AZ | 85078 | GRP-0848·· | null |
| TPA | TPA-50808 | 2026-06-18T03:41:37Z | theresa | — | olson | 1955-11-04 | - | •••-••-9652 | UNKNOWN | THERESA.OLSON@GMAIL.COM | 9320 Main Street | Glendale | AZ | 85354 | NULL | — |
| TPA | TPA-54713 | 2026-07-23T06:59:04Z | Scott, Anna | — | — | 1966-07-27 | UHC-14025-28 | •••-••-1065 | — | NULL | ·2964 Central Avenue | Columbus | OH | 43293 | null·· | MEDICARE-ADV-B |
| TPA | TPA-56467 | 2026-10-11T04:56:08Z | ·steven | — | robinson | Sep 15, 2004·· | — | — | ·3272207989 | N/A | 9561 Mountain View Dr | JACKSONVILLE | FL | 32266 | — | - |
| TPA | TPA-57292 | 2026-07-05T06:14:12Z | Evelyn | — | Baker | 1953-06-08 | — | UNKNOWN | 518.297.1835 | UNKNOWN·· | 2621 UNION STREET | Columbus | OH | 43276 | NULL | - |
| TPA | TPA-58635 | 2026-05-06T03:14:34Z | ANROLD·· | — | MARIANA | 1973-01-18 | NULL | null | 6208609139 | N/A | 7880 Ocean Avenue | Tempe | AZ | 85216 | GRP-3586 | MEDICARE-ADV-A |
| TPA | TPA-58007 | 2026-03-19T17:18:43Z | Megan | ·C. | Crawford | 1938-07-24 | — | — | NULL | null | 6340 UNION ST | Seattle | WA | 98117 | — | NULL |
| TPA | TPA-59159 | 2026-05-31T07:53:01Z | CARL | — | COLE | 14-02-1950 | UHC-38847-19 | ···· | 12696234016 | - | — | - | NULL | - | GRP-3597 | - |
| TPA | TPA-60758 | 2026-03-01T10:46:12Z | Andrea | — | Bryant | 1955-03-03 | - | NULL | 4953335604 | — | 2442 CHURCH ST | Las Vegas | NV | ·- | NULL | — |
| TPA | TPA-56087 | 2026-03-22T11:33:41Z | theresa | A | cook | 1987-01-13 | — | •••-••-4749 | — | — | 8803 MOUNTAIN VIEW DR·· | Denver | co | UNKNOWN | null | — |
| TPA | TPA-53355 | 2026-06-05T04:21:48Z | EMMA | — | WILSON | 23-01-1975·· | ·- | •••-••-3465 | — | null | — | - | ···· | ···· | UNKNOWN | — |
| TPA | TPA-57109 | 2026-07-05T11:49:01Z | daniel | — | ward | 4/16/1948·· | NULL | ·NULL | +1 354 839 4358 | null | 8568 Highland Avenue | Austin | ·TX | 78731 | GRP-9817 | MEDICARE-ADV-B |
| TPA | TPA-59672 | 2026-04-28T20:55:21Z | mason | — | sanchez | 19440326 | null·· | •••-••-9766 | 8666826779 | UNKNOWN | 3167 MARKET ST | Las Vegas | ·NV | 89174 | — | — |
| TPA | TPA-63221 | 2026-03-04T07:55:56Z | jerry | — | dean | 1977-11-14 | N/A | — | - | — | 5719 Lincoln Way·· | CHARLOTTE | NC | 28268 | GRP-3450 | OPTIONS-PPO |
| TPA | TPA-61994 | 2026-05-26T13:44:26Z | grace | — | davis·· | 2000-05-18 | — | — | N/A | UNKNOWN | 436 SPRING ST Apt 1 | Denver | CO | 80285 | null·· | ·CORE-HMO |
| TPA | TPA-54903 | 2026-07-08T03:36:16Z | BRYAN | ·· | ·GARRETT | 19860315 | null | UNKNOWN | UNKNOWN | — | 8805 BROADWAY | CHARLOTTE·· | NC | 28207 | ·GRP-6126 | OPTIONS-PPO |
| TPA | TPA-63446 | 2026-07-13T12:37:51Z | Juan | — | Munoz | 1945-07-17 | - | — | N/A | null | 9843 CENTRAL AVE | Tempe | AZ | 85215 | NULL | MEDICARE-ADV-A |
| TPA | TPA-50902 | 2026-08-02T15:15:44Z | Philip | — | White | Jul 21, 1989 | UHC-38610-80 | •••-••-8191 | null | - | 8118 Palm Dr·· | ·Atlanta | GA | 30352 | UNKNOWN | NULL |
| TPA | TPA-58124 | 2026-09-23T23:10:00Z | Sophia | — | Munoz | 1980-02-11 | — | - | (209) 695-2786 | — | ·3607 Mountain View Dr | Chandler | AZ | 85248·· | GRP-3407 | — |
| TPA | TPA-54655 | 2026-08-03T03:31:19Z | LOGAN | — | PETERS | 2005-10-27 | null | N/A·· | 3756373343 | — | ·6343 Bayshore Dr | Tampa | FL | 33605 | - | CORE-HMO·· |
| TPA | TPA-58514 | 2026-04-26T05:56:32Z | Vincent | — | Dixon | 1985-07-10 | — | — | (216) 316-4367 | — | 7753 Pine Dr | Seattle | WA | 98140 | — | MEDICARE-ADV-B |
| TPA | TPA-61273 | 2026-09-28T20:48:02Z | Evelyn | — | Nelson | 1958-05-23 | — | — | 2282187599 | NULL | 9742 Park Pl | Tempe | AZ | 85242-9224 | UNKNOWN | — |
| TPA | TPA-56523 | 2026-03-15T08:23:26Z | cyntia | — | jensen | May 28, 1959 | N/A | N/A | 268-596-9803 | cynthia.jensen@icloud.com | 454 Apache Blvd | Columbus | ·OH | 43277-8564 | — | — |
| TPA | TPA-59309 | 2026-08-17T08:49:55Z | Gabriel | — | Castro | 1994-09-24 | — | UNKNOWN | 422-922-5601 | null | null | - | — | — | null | MEDICARE-ADV-A |
| TPA | TPA-62573 | 2026-05-05T11:48:54Z | Jessica | — | Welch | 1952-01-27 | UNKNOWN | •••-••-6920 | — | null | 1213 Apache Blvd Apt 9·· | Dallas | TX | 75284-8089 | null | — |
| TPA | TPA-63337 | 2026-03-04T05:40:29Z | Janice | — | Marshall | 5/8/1985 | UHC-01618-80 | - | 587-430-8972 | null | 8752 Spring Street | Mesa | AZ | 85276 | — | ·OPTIONS-PPO |
| TPA | TPA-52161 | 2026-02-17T14:18:24Z | ·KATHRYN | — | TURNER | 1952-02-22 | NULL | — | — | null | 1319 HARBOR BLVD | EDEN PRAIRIE | MN | 55396 | NULL | — |
| TPA | TPA-60304 | 2026-06-15T08:05:41Z | Julia | G. | Meyer | 1969-08-25 | — | - | UNKNOWN | NULL | 5564 CENTRAL AVENUE·· | Minneapolis | MN·· | 55474 | — | - |
| TPA | TPA-62970 | 2026-03-28T09:28:19Z | Judith | — | Woods | 21-04-1971 | NULL | N/A | +1 348 490 5379 | judith.woods78@proton.me | 8981 Mesa Drive | Austin | TX | 78798 | GRP-8469 | ···· |
| TPA | TPA-56218 | 2026-06-24T11:15:11Z | Thomas | ···· | Johnson | 1987-06-12 | — | •••-••-8412 | -·· | — | 2625 Main St | MINNEAPOLIS | MN | 55431 | — | — |
| TPA | TPA-56984 | 2026-01-14T02:19:51Z | ABIGAIL | — | OLSON | ·1945-07-07 | UHC-32653-35 | ·· | 486-371-5490 | UNKNOWN | null | - | — | — | GRP-6864 | — |
| TPA | TPA-51072 | 2026-01-23T10:50:19Z | jerry | ·· | johnson | 1966-05-03 | - | — | N/A | — | N/A | — | — | NULL | N/A | null |
| TPA | TPA-57607 | 2026-01-26T23:04:49Z | LAWRENCE | — | ALEXANDER | 1942-01-01 | N/A | null | (271) 450-7162 | -·· | 3342 CAMELBACK ROAD | ·Fresno | CA | 93764 | GRP-6896 | SELECT-EPO |
| TPA | TPA-51532 | 2026-04-19T05:56:32Z | ·Diego | O | Castillo | 2007-02-09 | NULL | NULL | UNKNOWN | diego.castillo50@gmail.com | 3312 Maple Avenue | Houston | TX | 77038 | GRP-7820 | ·OPTIONS-PPO |
| TPA | TPA-56079 | 2026-09-20T15:11:38Z | roger·· | — | ·stewart | 21-02-1968 | NULL | •••-••-3364 | 9217988735 | ROGER.STEWART@AOL.COM | ·6205 Sage Ct | Scottsdale | AZ | — | UNKNOWN | — |
| TPA | TPA-59777 | 2026-04-27T10:34:59Z | Mark | — | Payne | 19721019 | null | •••-••-3752 | NULL | — | 3285 Desert Sky Boulevard | Plano | Texas | 75087 | NULL | NULL |
| TPA | TPA-60082 | 2026-01-17T15:50:54Z | RUTH | — | JACKSON | 08/16/03 | - | •••-••-0932 | (724) 812-1502 | ·· | 4532 Jefferson Ave | Mesa | AZ | 85236 | N/A | — |
| TPA | TPA-52621 | 2026-05-02T09:20:10Z | Thomas | — | Armstrong | 1993-12-04 | UHC-87670-07 | •••-••-8875 | NULL | THOMAS.ARMSTRONG@YAHOO.COM | 1436 Elm Street | Austin | TX | 78709 | ·GRP-1377 | OPTIONS-PPO |
| TPA | TPA-59574 | 2026-04-08T13:06:12Z | Kathleen | C | Tran | ·1975-04-20 | - | null | +1 362 359 9237 | kathleen.tran84@gmail.com | N/A | — | NULL | null | — | — |
| TPA | TPA-61049 | 2026-05-16T08:01:14Z | Danielle | — | Henry | 11/16/50 | ·· | •••-••-0098 | null | - | N/A | — | UNKNOWN | ·· | ·· | null |
| TPA | TPA-57850 | 2026-08-19T17:14:05Z | ARJUN | — | JIMENEZ·· | 1994-06-09 | ·NULL | - | 12808052611 | null | 7369 River Rd #881 | Phoenix | AZ | NULL | - | — |
| TPA | TPA-56281 | 2026-01-19T04:55:35Z | HENRY | ···· | WELLS | 19940508 | N/A | ·· | N/A | — | 7167 Highland Avenue | Scottsdale | AZ | 85216 | null | MEDICARE-ADV-B |
| TPA | TPA-51037 | 2026-01-02T02:20:09Z | Johnston, Terry | Z. | — | 11/9/1948 | UHC-45521-73 | null | +1 762 335 4194 | — | 5215 Highland Ave | Orlando | FL | 32887-7339 | 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:43:00.520Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty