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-50357 | 2026-04-25T19:03:44Z | WEI | — | PATTERSON | 1949-07-04 | - | null | — | NULL | UNKNOWN | - | UNKNOWN | — | N/A | NULL |
| TPA | TPA-57782 | 2026-07-25T22:19:43Z | mateo | B | wallace | 1980-05-21 | — | - | UNKNOWN | null | 8602 Harbor Boulevard | Denver | co | 80228 | ·· | — |
| TPA | TPA-51882 | 2026-06-17T13:03:02Z | Daniel | — | Fuller | 1953-01-25 | — | - | (882) 893-2349·· | daniel.fuller@aol.com | 5148 Mesa Drive | Austin | TX | 78756-9775 | NULL | MEDICARE-ADV-A |
| TPA | TPA-54119 | 2026-07-14T03:09:35Z | Omar | — | Bell | 19980517 | NULL | null | — | — | 9649 CAMELBACK ROAD | SEATTLE | wa | 98107 | — | — |
| TPA | TPA-51799 | 2026-08-29T08:09:16Z | Emily | — | Rojas | 11-08-1973 | — | UNKNOWN | 4547015886 | — | 3655 Market St | Las Vegas | NV | NULL·· | N/A | — |
| TPA | TPA-55605 | 2026-06-19T05:43:34Z | AUSTIN | — | SIMPSON | 1993-02-27·· | — | — | — | NULL | 3090 Ocean Avenue | Los Angeles | California | ·· | N/A | OPTIONS-PPO |
| TPA | TPA-63714 | 2026-08-09T17:56:01Z | Jeremy | — | Dominguez | 1972-02-12 | NULL | ···· | — | — | 8548 Hillcrest Rd | Mesa | AZ | 85287 | N/A | NULL |
| TPA | TPA-55702 | 2026-04-26T03:33:30Z | KATHLEEN | — | MORGAN | ·02/04/60 | — | — | (487) 320-9652 | ···· | 2706 ELM STREET | DENVER | CO | 80284 | GRP-4371 | CORE-HMO |
| TPA | TPA-61217 | 2026-05-04T00:43:21Z | Watkins, Carol | — | — | 1997-02-06 | N/A | — | — | - | 7919 Broadway | San Antonio | TX | 78290 | GRP-9645 | OPTIONS-PPO |
| TPA | TPA-59704 | 2026-07-21T19:17:23Z | Julie | ···· | Watkyns·· | Jul 10, 2000 | — | UNKNOWN | 16468286232 | - | 3982 Sunset Blvd | Mesa | AZ | 85296 | NULL | NULL |
| TPA | TPA-50701 | 2026-09-30T21:24:37Z | Nathan | — | Lee | 20060825 | null | •••-••-2187 | - | N/A | 5406 WILLOW CT | Dallas | TX | 75272 | null | - |
| TPA | TPA-61747 | 2026-05-12T01:52:39Z | KEITH | ···· | DIXON | 3/2/1996 | UHC-52659-75 | •••-••-0412 | ···· | keith.dixon@outlook.com | — | — | — | UNKNOWN | -·· | OPTIONS-PPO |
| TPA | TPA-55069 | 2026-01-23T05:05:36Z | ·Ramos, Joshua | — | — | 1952-07-04 | — | •••-••-8511 | N/A·· | - | ·1749 Broadway #313 | Minneapolis | MN | NULL | NULL | null |
| TPA | TPA-54464 | 2026-01-30T17:42:16Z | MATEO | X. | AUSTIN | 1976-03-24 | NULL | NULL | null | mateo.austin@outlook.com | — | null | NULL·· | — | N/A | — |
| TPA | TPA-52930 | 2026-02-27T20:24:42Z | elizabeth | — | harrison | 1965-09-25 | UHC-17943-36 | N/A | 14235550063 | elizabeth.harrison@outlook.com | null | ·null | ·N/A | — | — | NULL |
| TPA | TPA-60700 | 2026-06-18T02:11:12Z | CHARLIE | — | MURRAY | 1952-10-15 | N/A | •••-••-3224 | (670) 329-5030 | NULL | 8544 Apache Boulevard | Nashville | TN | 37208 | N/A | ···· |
| TPA | TPA-56798 | 2026-04-01T07:58:05Z | LISA | — | WANG | 1962-01-10 | UHC-01264-90·· | •••-••-5499 | NULL | — | ·5726 INDIAN SCHOOL ROAD | Scottsdale | AZ·· | 85282 | N/A | SELECT-EPO |
| TPA | TPA-52608 | 2026-09-15T16:20:56Z | Victoria | — | Webb | 08-07-1951 | ·UHC-59648-01 | — | 518-687-0944 | null | 1681 Desert Sky Boulevard | Miami | FL | 33123 | ·UNKNOWN | — |
| TPA | TPA-62572 | 2026-02-09T16:11:03Z | Camila | — | Ortiz | 1975-03-25 | - | — | ·NULL | CAMILA.ORTIZ@GMAIL.COM | 2942 LAKE VIEW ROAD | Columbus | OH | 43224 | GRP-4153 | SELECT-EPO |
| TPA | TPA-52558 | 2026-02-04T05:36:34Z | Nicholas | — | Edwards | Jun 3, 1983 | UHC-13752-66 | •••-••-7811 | 15267366357·· | null | 2706 Broadway | Tucson | AZ | 85724 | N/A | NAVIGATE-HMO |
| TPA | TPA-52512 | 2026-01-23T10:00:24Z | Betty | F | Hernandez | 1950-05-09 | UNKNOWN | •••-••-6669 | ···· | — | 4114 Valley View Dr | Glendale | Arizona | 85307-6679 | GRP-4012 | SELECT-EPO |
| TPA | TPA-62722 | 2026-04-15T12:30:48Z | rebecca | — | fox | 2000-12-04 | UHC-05601-41 | NULL | — | N/A | 7732 Harbor Blvd | Eden Prairie | MN | 55371 | — | SELECT-EPO |
| TPA | TPA-62008 | 2026-05-23T14:24:49Z | Jennifer | — | Lee | 1984-05-11 | null | - | 241-689-2642 | — | 2678 PALM DR | Nashville | TN | 37256 | N/A | CHOICE-PLUS-PPO |
| TPA | TPA-64132 | 2026-04-30T08:14:08Z | MATEO | — | SIMS·· | 1980-03-12·· | — | — | N/A | N/A | 4897 Canyon Road | San Diego | CA | 92187 | GRP-1147 | — |
| TPA | TPA-52465 | 2026-10-06T03:28:17Z | Sandra | — | Smith | 1977-06-05 | — | N/A | 14095011127 | N/A | 2383 Park Place | Chandler | Arizona | 85204 | — | null |
| TPA | TPA-51339 | 2026-07-12T19:25:52Z | JUDITH | — | PENA | 8/25/1939·· | — | NULL | 15615105268 | NULL | 1931 BASELINE ROAD | Denver | CO | 80265-2567 | null | OPTIONS-PPO |
| TPA | TPA-62642 | 2026-07-08T13:02:43Z | NANCY | G | HARVEY | 1994-03-19 | NULL | •••-••-5956 | NULL | nancy.harvey@proton.me | ·4513 Palm Drive | San Diego | CA | 92169 | N/A | — |
| TPA | TPA-60389 | 2026-06-12T06:49:26Z | PATRICK | ·· | KNIGHT | 1978-08-19 | — | NULL | - | — | 4240 INDIAN SCHOOL RD·· | Plano | TX | - | UNKNOWN | UNKNOWN |
| TPA | TPA-52467 | 2026-07-04T09:28:20Z | Ashley | I | Nunez | 1942-02-11 | UHC-78050-72 | NULL | ·null | — | 6577 Highland Ave | Minneapolis | MN | 55411 | — | medicare-adv-b |
| TPA | TPA-50323 | 2026-05-31T13:28:21Z | Jacob | — | OBrien | 1953-12-07·· | UHC-35819-35 | null | 897-439-2985·· | jacob.obrien@icloud.com | 8849 Cedar Lane | SAN DIEGO | CA | 92142 | - | SELECT-EPO |
| TPA | TPA-50818 | 2026-02-09T12:51:59Z | ethan | ·· | fuller·· | 1965-02-12 | - | NULL | - | NULL | 3379 Highland Ave | Gilbert | AZ | 85283 | - | ···· |
| TPA | TPA-57869 | 2026-09-25T22:10:37Z | NATHAN | ···· | PARKER | 06/24/51 | — | NULL | — | — | 2088 Desert Sky Boulevard | Chandler | az | 85288 | GRP-5073 | — |
| TPA | TPA-56708 | 2026-09-05T13:07:47Z | Ann | — | Gonzalez | 1960-10-27 | UHC-34996-49 | - | 2788362292 | -·· | 4617 Grand Avenue | Sacramento | California | 95855 | GRP-2863 | N/A |
| TPA | TPA-62544 | 2026-04-20T00:11:14Z | Arthur | — | Rivera | 19660415 | UHC-43347-56 | - | 9466383 | NULL | 8948 Apache Blvd | Houston | TX | 77054 | — | NULL |
| TPA | TPA-58080 | 2026-07-19T07:05:00Z | HANNAH | ···· | WILLIS | 1973-05-27 | UNKNOWN | •••-••-8140 | — | — | 9616 Harbor Blvd | PHOENIX | AZ | 85023 | - | OPTIONS-PPO |
| TPA | TPA-54517 | 2026-03-26T07:23:26Z | Agela | — | Moreno | 1984-07-41 | UNKNOWN | null | +1 913 585 9151 | — | ·5944 Park Pl | Houston | TX | ·77001 | — | OPTIONS-PPO |
| TPA | TPA-62949 | 2026-07-09T05:51:29Z | Luna, Alice | — | — | 1969-09-27·· | UHC-88465-55 | - | N/A | — | 158 PARK PLACE | Glendale | AZ | 85365 | GRP-7507 | OPTIONS-PPO |
| TPA | TPA-62466 | 2026-02-09T01:55:58Z | Angela | ···· | ·Sanchez | 1942-02-16 | — | •••-••-3397 | - | angela.sanchez25@outlook.com | ·6275 Oak St | Las Vegas | NV | 89133 | GRP-7410 | NAVIGATE-HMO |
| TPA | TPA-59708 | 2026-05-06T12:48:18Z | gary | J | young | 2001-11-25 | UHC-27384-74 | null | — | - | 9289 Meadow Lane | Plano | TX | 75075·· | — | — |
| TPA | TPA-53274 | 2026-03-13T07:24:33Z | Ana | — | Hunter | 2008-10-04 | - | UNKNOWN | 640-213-6733 | - | — | — | null | N/A | UNKNOWN | CHOICE-PLUS-PPO |
| TPA | TPA-54076 | 2026-01-15T05:01:43Z | brenda | — | phillips | 19451026 | N/A | NULL | null | UNKNOWN | 5189 GRAND AVENUE | Orlando | FL | 32884 | GRP-6139 | SELECT-EPO |
| TPA | TPA-63711 | 2026-03-08T21:39:10Z | Janice | — | Marshall | 1985-02-22 | — | - | UNKNOWN | - | 5578 Bayshore Dr | Sacramento | CA | - | — | — |
| TPA | TPA-50150 | 2026-08-20T17:16:45Z | Anna | — | Stevens | 11/09/70 | UHC-64371-85 | •••-••-7074 | UNKNOWN | — | 582 Union Street | Orlando | FL | 32828 | — | MEDICARE-ADV-A |
| TPA | TPA-50845 | 2026-01-17T14:40:36Z | James | — | Montgomery | 1987-04-13 | — | •••-••-9766 | -·· | ·UNKNOWN | 2804 Central Ave | CHARLOTTE | NC | 28298 | - | UNKNOWN |
| TPA | TPA-50398 | 2026-04-30T05:00:00Z | Dylan | — | Green | ·1988-01-20 | NULL | NULL | UNKNOWN | dylan.green@outlook.com | ·8017 Ridge Road | Tempe | AZ | 85241 | null | NULL |
| TPA | TPA-57513 | 2026-08-30T20:05:36Z | JONATHAN | — | FORD | ·02/08/1955 | ·- | — | NULL | N/A | 1229 Broadway | Nashville | Tennessee | 37279 | NULL | — |
| TPA | TPA-50075 | 2026-05-28T12:18:01Z | ·Richard | — | Kelley | 19610110·· | UHC-55573-18 | •••-••-6158 | 754.361.7207 | - | 1539 SPRING STREET | Atlanta | Georgia | — | N/A | - |
| TPA | TPA-56919 | 2026-05-16T06:19:39Z | Camila | — | Dunn | 20071205 | N/A | — | ·4307541468 | — | ·null | N/A | - | — | NULL | medicare-adv-a |
| TPA | TPA-62649 | 2026-08-12T20:06:46Z | VALENTINA | — | SCOTT | 1893-10-26·· | UHC-56762-01 | — | null | VALENTINA.SCOTT60@ICLOUD.COM | — | null | UNKNOWN | — | — | - |
| TPA | TPA-56430 | 2026-03-31T20:04:30Z | Patrick | D | Wiilliamson | 1971-11-13·· | ·- | - | — | null | 105 Highland Ave·· | Miami | FL | 33162-0456 | GRP-6244 | N/A |
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:49.091Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty