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-56810 | 2026-01-09T01:43:07Z | Day | Q·· | Denny | 1711-91-62 | — | •••-••-2909 | — | UNKNOWN | 2557 Bayshore Drive | Tempe·· | Arizona | ·85225 | UNKNOWN | — |
| TPA | TPA-57075 | 2026-03-14T04:02:33Z | Burke, Jonathan·· | — | ·· | 10/2/1984 | - | •••-••-5613 | - | ···· | ·4277 Washington St | Denver | CO | 80209 | GRP-2560 | CORE-HMO |
| TPA | TPA-53772 | 2026-06-19T16:38:25Z | Ashley | — | Campbell | 1952-04-19 | null | NULL | (913) 778-0311 | ashley.campbell@hotmail.com | null | — | UNKNOWN | — | GRP-5225·· | — |
| TPA | TPA-59807 | 2026-07-01T11:57:23Z | LAUREN | — | ·CHEN | 7/26/1973 | — | N/A | — | N/A | UNKNOWN | N/A | — | N/A | — | MEDICARE-ADV-A |
| TPA | TPA-55854 | 2026-01-05T22:04:18Z | CAROLYN | — | PATTERSON | Feb 10, 1975 | UHC-74389-73 | N/A | (681) 937-4209 | — | 2439 Valley View Drive | Los Angeles | CA | NULL | — | ·CORE-HMO |
| TPA | TPA-55183 | 2026-05-05T08:42:49Z | LUIS | — | MUNOZ | 1963-10-07 | — | - | 568.311.3536 | ·· | 8503 OAK STREET | Atlanta | GA | 30354 | - | OPTIONS-PPO |
| TPA | TPA-52222 | 2026-09-08T08:11:52Z | Patricia | — | ·Grant | 1962-11-13 | — | NULL | - | UNKNOWN | 2725 Hillcrest Road | Mesa·· | AZ | 85264 | - | — |
| TPA | TPA-58581 | 2026-02-18T23:43:07Z | jesse | — | spencer | Jun 10, 1969 | UNKNOWN | N/A | 7362875725 | JESSE.SPENCER@OUTLOOK.COM | 935 Palm Drive | Columbus | OH | 43203 | null | — |
| TPA | TPA-55150 | 2026-07-26T08:08:42Z | EMMA | — | WASHINGTN | 1949-12-01 | UHC-20115-01 | •••-••-2740 | UNKNOWN | emma.washington90@aol.com | 2206 Maple Avenue | SAN ANTONIO | TX | 78222 | — | MEDICARE-ADV-B |
| TPA | TPA-60375 | 2026-07-23T19:09:16Z | Ryaan | — | Howard | 1976-12-22 | UNKNOWN | N/A | — | N/A | 6625 MARKET ST | DALLAS | ·TX | 75230 | GRP-8965 | null |
| TPA | TPA-52916 | 2026-03-28T04:40:15Z | Jacob | — | Coleman | 1963-06-15 | UHC-92202-30 | •••-••-3335 | NULL | NULL | 1605 Broadway·· | Fresno | CA | 93786 | ·· | NULL |
| TPA | TPA-52176 | 2026-05-15T20:21:47Z | MARTHA | — | WILLIS | 1966-07-20 | UHC-62076-92 | null | null | ·· | ·3212 Bayshore Dr | Glendale | AZ | 85351 | ·null | UNKNOWN |
| TPA | TPA-60600 | 2026-05-01T21:08:03Z | PETAR | — | CHAVEZ | 01/16/1986 | UHC-11335-20 | •••-••-7954 | 333.587.8654 | — | 7706 Lake View Rd | Tucson | ·AZ | 85761 | GRP-2959 | UNKNOWN |
| TPA | TPA-52223 | 2026-05-25T09:41:32Z | ·Marcus | E | ·Nguyen | 1955-02-10 | UHC-49186-57 | — | 228-554-0204 | - | ·7005 Sunset Blvd | Glendale | AZ | 85343 | GRP-0836 | - |
| TPA | TPA-58977 | 2026-05-23T13:25:48Z | VICTORIA | — | CAMPBELL·· | 1950-12-06 | — | •••-••-9713 | 445-689-8050 | UNKNOWN | 1779 Cedar Lane | San Antonio | TX | 78269 | NULL | null |
| TPA | TPA-53557 | 2026-05-22T20:17:43Z | RYAN | E | ROBINSON | 1946-08-04 | — | •••-••-9904 | 5448338811 | — | 1897 OCEAN AVENUE | Houston | TX | 77081 | — | N/A |
| TPA | TPA-61793 | 2026-06-03T17:03:11Z | carl | — | carr | 1985-06-03 | — | — | NULL | UNKNOWN | NULL | NULL | NULL | - | GRP-1700 | SELECT-EPO |
| TPA | TPA-55358 | 2026-09-10T07:59:17Z | ·sandra | ···· | estrada | 1986-01-13·· | NULL·· | - | - | NULL | 7408 Spring Street·· | Charlotte | nc | 28277·· | GRP-8766 | ·MEDICARE-ADV-B |
| TPA | TPA-55898 | 2026-02-19T02:22:52Z | AMBER | — | ALEXANDER | 05/26/60 | ·UNKNOWN | — | (230) 638-4043 | null | 8353 Oak Street | Jacksonville | ·FL | 32230 | - | OPTIONS-PPO |
| TPA | TPA-53461 | 2026-04-24T08:36:21Z | JOSE | — | PERRY | 1967-07-03 | — | N/A | 9156935561 | — | 7548 MOUNTAIN VIEW DRIVE | Fresno | CA | 93749 | NULL | — |
| TPA | TPA-54969 | 2026-01-04T19:43:46Z | Patrick | — | Jones | 2003-05-09 | ···· | •••-••-2349 | - | — | 3171 CEDAR LN | PLANO | TX | 75021 | NULL | — |
| TPA | TPA-50402 | 2026-07-13T13:53:41Z | Aaron | — | Payne | 9169-11-26·· | ·null | — | null | AARON.PAYNE@AOL.COM | 9763 Indian School Road·· | ·Glendale | Arizona | ·85375 | UNKNOWN | NULL |
| TPA | TPA-61984 | 2026-06-01T03:17:58Z | Santiago | — | Sandoval | 10/12/1958 | NULL | UNKNOWN·· | — | santiago.sandoval22@proton.me | - | UNKNOWN | N/A | UNKNOWN | GRP-1958 | - |
| TPA | TPA-63616 | 2026-03-23T16:27:51Z | Harrison, Andrea | M. | — | 19560622 | — | — | — | ANDREA.HARRISON21@YAHOO.COM | 1180 Meadow Ln | Phoenix | AZ | 85054 | ·GRP-6490 | NULL |
| TPA | TPA-58819 | 2026-02-02T14:07:19Z | ·Philip | — | ·Williamson | 07/04/38 | UNKNOWN | — | (778) 360-1032 | - | - | — | - | — | — | CHOICE-PLUS-PPO |
| TPA | TPA-56526 | 2026-06-03T17:37:01Z | John | — | Henry·· | 1944-01-19 | — | •••-••-8813 | — | NULL | - | NULL | N/A·· | UNKNOWN | — | — |
| TPA | TPA-58829 | 2026-01-28T09:19:59Z | Willis, Alice | — | — | ·1944-06-18 | N/A | NULL | +1 708 805 4449 | alice.willis@gmail.com | 5380 Willow Court | Nashville | TN | 37241 | GRP-1902 | — |
| TPA | TPA-59822 | 2026-04-09T18:12:43Z | BARBARA | — | HOWADR | 1979-03-23 | UNKNOWN | NULL·· | N/A | NULL | 3433 Highland Avenue | Fresno | CA | 93736-2794 | — | ···· |
| TPA | TPA-52719 | 2026-06-23T23:48:06Z | MICHELLE·· | ·· | NELSON | 1947-08-08 | ·UHC-68864-27 | N/A | +1 489 483 4073 | NULL | 2704 Lincoln Way | NASHVILLE | Tennessee | 37286 | UNKNOWN | N/A |
| TPA | TPA-57236 | 2026-07-06T08:40:48Z | Bruce | J | Gray | 11/28/77 | - | N/A | UNKNOWN | null | 2080 RIVER RD | Nashville | TN | 37249 | GRP-8292 | N/A |
| TPA | TPA-55211 | 2026-05-01T11:46:45Z | Bobby | — | Hudson | 08-06-1995·· | — | — | NULL | — | NULL | null | null | - | N/A | NAVIGATE-HMO |
| TPA | TPA-52351 | 2026-09-24T21:05:40Z | Day, Santiago | — | — | 5/3/1998 | - | •••-••-7832 | null | — | 9850 CHURCH STREET | Las Vegas | ·NV | 89131 | GRP-3923 | UNKNOWN |
| TPA | TPA-61846 | 2026-05-29T21:48:18Z | Warren, Matthew | — | — | 1958-10-03 | — | •••-••-0398 | N/A | NULL | 6845 Lake View Rd | SAN DIEGO | CA | 92154 | ·· | NAVIGATE-HMO |
| TPA | TPA-63621 | 2026-04-14T12:13:16Z | ETHAN | — | GILBERT | 1974-06-16·· | ·· | — | (459) 399-9877 | — | 5664 Washington Street | Houston | Texas | — | GRP-6741 | NULL |
| TPA | TPA-55684 | 2026-08-23T21:33:47Z | NICHOLAS | — | PRICE | 1942-09-03 | NULL | UNKNOWN | N/A | — | N/A | ·· | — | NULL | — | UNKNOWN·· |
| TPA | TPA-62751 | 2026-09-30T21:03:46Z | LOGAN | — | SCOTT | 1988-08-15 | — | •••-••-2048 | UNKNOWN | - | 9396 Cedar Lane | Nashville | TN | 37243 | GRP-1464 | — |
| TPA | TPA-60643 | 2026-06-06T09:06:19Z | Priya | — | Ford | 1969-05-03 | N/A | N/A | null | - | 6295 Indian School Road | Denver | CO | 80256 | UNKNOWN | MEDICARE-ADV-A |
| TPA | TPA-50768 | 2026-01-08T05:01:18Z | Samantha | — | Contreras | 1946-02-09 | null | •••-••-0640 | ···· | - | 9591 BROADWAY | Glendale | AZ | — | — | N/A |
| TPA | TPA-54724 | 2026-01-24T20:20:07Z | ·Gloria | — | Hicks | 03/18/1952 | — | - | null | GLORIA.HICKS55@HOTMAIL.COM | 6778 Jefferson Ave·· | GLENDALE | AZ·· | 85389 | — | CHOICE-PLUS-PPO |
| TPA | TPA-54699 | 2026-04-19T11:34:46Z | Evelyn | — | Williams | 2008-09-27 | null | •••-••-0701 | 3604353854 | UNKNOWN | 8149 Bayshore Dr | Tempe | AZ | 85270 | — | MEDICARE-ADV-B |
| TPA | TPA-53456 | 2026-06-07T11:33:10Z | Gloria | — | Kim | 1953-04-30 | - | •••-••-2475 | 14409054905 | - | ·4694 Sunset Blvd | TEMPE | AZ | ·85237-5490 | GRP-2589 | NULL |
| TPA | TPA-56969 | 2026-07-27T20:36:04Z | Natalie | — | Murphy | 12/2/1958 | UHC-11747-32 | ·UNKNOWN | N/A | null | ·9355 Meadow Ln | SAN ANTONIO | TX | 78215 | GRP-1758 | — |
| TPA | TPA-59265 | 2026-07-18T22:34:15Z | Jeremy | O. | Barnes | 1995-11-25 | - | — | 648-525-2563 | jeremy.barnes@icloud.com | 8573 Ocean Avenue #464 | Chandler | AZ | 85261 | GRP-0123 | — |
| TPA | TPA-58768 | 2026-06-09T22:18:19Z | Marcus | — | Wallace | 1951-09-12 | ·UHC-87858-93 | NULL | ·null | — | 1408 FOREST AVE | Dallas | TX | 75282-0588 | N/A | N/A |
| TPA | TPA-50886 | 2026-01-26T11:51:24Z | BRYAN | — | HARRISON | 1994-50-27 | - | •••-••-8728 | 803-213-6535 | N/A | 6618 Oak Street | Austin | TX | ·78713 | — | MEDICARE-ADV-B |
| TPA | TPA-61724 | 2026-09-28T07:19:37Z | JOSEPH | — | SPENCER | 1986-06-21 | - | •••-••-9793 | — | joseph.spencer@yahoo.com | 8039 Central Ave | ORLANDO | Florida | 32892 | GRP-1880 | MEDICARE-ADV-A |
| TPA | TPA-54068 | 2026-03-04T15:46:10Z | SOPHIA | O.·· | CUNNINGHAM | 1973-05-01 | null | •••-••-1594 | 9494144183 | - | 3898 Sunset Boulevard | Seattle | wa | 98150 | null | — |
| TPA | TPA-58893 | 2026-05-31T16:01:35Z | Rebecca | ·· | Foster | 09/20/1972 | - | - | 375-563-8106 | - | 2598 OAK STREET | SAN DIEGO | CA | 92198 | - | — |
| TPA | TPA-51111 | 2026-06-08T14:02:24Z | sofia | — | li | 12/18/48 | - | N/A | - | NULL | 1674 Ridge Rd·· | JACKSONVILLE | ·FL | ·32294 | N/A | — |
| TPA | TPA-60387 | 2026-05-06T10:21:17Z | ·THOMAS | — | DAY | 1983-04-11·· | UHC-64033-30 | •••-••-6419 | — | NULL | 2133 Broadway | Las Vegas | NV | 89109 | ·· | ·- |
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.356Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty