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-59607 | 2026-03-11T11:52:59Z | VINCENT | — | LITTEL | 1980-02-28 | - | •••-••-7547 | 679-415-4910 | — | 1858 Market St | PHOENIX | Arizona | 85033 | GRP-1491 | CHOICE-PLUS-PPO |
| TPA | TPA-63421 | 2026-03-03T13:55:44Z | Denise | — | Steens | 16-11-1970 | - | — | — | denise.stevens@aol.com | 7600 MOUNTAIN VIEW DRIVE | Houston | TX | 77053 | UNKNOWN·· | MEDICARE-ADV-B |
| TPA | TPA-53088 | 2026-02-01T11:32:08Z | Bradley | — | Vega | 13-06-1938 | - | •••-••-6062 | (949) 608-9448 | null | 7952 SPRING STREET | GILBERT | AZ | 85274 | — | OPTIONS-PPO |
| TPA | TPA-63618 | 2026-05-26T22:28:06Z | DAVID | N | PHILLIPS | 19380110 | null | UNKNOWN | N/A | - | 7151 Spring Street | Chandler | AZ | 85299 | UNKNOWN | NULL |
| TPA | TPA-56460 | 2026-01-14T19:52:43Z | Brooks, Albert | — | — | 1974-06-08 | ·NULL | •••-••-2140 | (504) 209-8908·· | — | 883 Ocean Avenue #815 | San Antonio | TX | 78221 | null | null |
| TPA | TPA-54560 | 2026-01-29T17:34:47Z | EMMA | — | GARZA | 1958-10-10 | UHC-80361-35 | null | (640) 531-7054 | — | 9103 Jefferson Ave | Seattle | WA | 98141 | UNKNOWN | OPTIONS-PPO |
| TPA | TPA-51783 | 2026-04-12T11:20:02Z | ·Emily | — | Jenkins | 2001-03-17 | UNKNOWN | •••-••-7498 | null | — | 7216 Canyon Rd #636 | Austin·· | ·TX | 78700 | — | - |
| TPA | TPA-55429 | 2026-03-07T00:12:58Z | Priya, Warren | ·· | — | 26-11-1987 | UNKNOWN | •••-••-5858 | - | ···· | — | — | UNKNOWN | — | — | — |
| TPA | TPA-58642 | 2026-09-03T12:59:47Z | Nathan | Q | Robertson | 1997-07-22 | — | •••-••-7069 | — | - | 8063 Meadow Lane | Mesa | AZ | 85274 | — | N/A |
| TPA | TPA-50982 | 2026-07-03T19:49:25Z | Noah | ·· | Cox | 1963-08-03 | NULL | •••-••-9964 | 214-489-1117 | — | 1809 Grand Avenue | ·Los Angeles | CA | 90070 | GRP-8105 | CORE-HMO |
| TPA | TPA-60895 | 2026-04-14T13:43:09Z | KAREN | — | ·MONTGOMERY | 14-09-1963 | — | null | 2318550598 | N/A | 8807 Highland Avenue | Columbus | OH | 43278-0460 | ···· | null |
| TPA | TPA-56630 | 2026-07-12T06:28:50Z | DENNIS | — | MENDOZA | 1983-03-10 | - | •••-••-9054 | 974-850-7483 | N/A | 2596 Ocean Ave | PHOENIX | AZ | 85016 | UNKNOWN | OPTIONS-PPO |
| TPA | TPA-59277 | 2026-10-07T18:40:48Z | Ryan | — | Li | 1963-09-10 | — | •••-••-1924 | N/A | NULL | 5648 Elm Street | FRESNO | California | 93735 | GRP-6378 | CHOICE-PLUS-PPO |
| TPA | TPA-55700 | 2026-07-31T11:51:40Z | Janice | — | Hunt | 1224-91-56 | UNKNOWN | — | (856) 900-3404 | — | 5192 Lincoln Way | Charlotte | NC | 28268 | NULL | - |
| TPA | TPA-57265 | 2026-03-25T02:41:26Z | noah | — | santiago | 7/5/1979 | null | •••-••-5562 | N/A | — | 7426 Baseline Road | Los Angeles | CA | 90037 | null | NAVIGATE-HMO |
| TPA | TPA-54968 | 2026-10-04T19:24:35Z | Maria | — | Mejia | 1992-10-18 | NULL | •••-••-1117 | N/A | — | 6944 Park Place | Chandler | AZ | 85213 | NULL | — |
| TPA | TPA-55275 | 2026-03-26T21:27:20Z | Megan | — | Herrera·· | 1991-02-23 | — | — | NULL | ···· | ·4453 Indian School Road | Denver | CO | 80228 | - | N/A |
| TPA | TPA-57891 | 2026-07-15T03:35:32Z | Betty | — | Paetl | 07-02-1959 | UHC-54842-23 | •••-••-3836 | 7427794631 | betty.patel16@aol.com | 1321 River Road Apt 2·· | Charlotte | NC | 28291 | — | — |
| TPA | TPA-61779 | 2026-02-05T22:41:43Z | Roger | — | ·Banks | 05/26/1974 | null | UNKNOWN | 5458052054 | — | ·4937 Sage Ct | Scottsdale | AZ | UNKNOWN | — | MEDICARE-ADV-B·· |
| TPA | TPA-57450 | 2026-04-30T00:19:08Z | elijah | — | myers | 19891209 | ·NULL | - | +1 550 624 3373 | null | 3062 Highland Ave | Dallas | TX | 75233 | GRP-3646 | CHOICE-PLUS-PPO |
| TPA | TPA-54152 | 2026-09-26T16:49:16Z | NICOLE·· | — | HAYES | Dec 1, 1981 | N/A | NULL | — | null | ·8810 CEDAR LN | Columbus | Ohio | ·43209 | ·GRP-8572 | UNKNOWN |
| TPA | TPA-61952 | 2026-03-16T22:58:00Z | JENA | T | DAVIS | 11/14/1947 | UNKNOWN | UNKNOWN | 6489249295 | ·jean.davis27@gmail.com | 5123 FOREST AVE | ·SACRAMENTO | ·CA | 95804·· | NULL | — |
| TPA | TPA-61119 | 2026-09-26T12:29:06Z | RONALD | ···· | REED | 07/28/57 | — | UNKNOWN | (629) 552-0385 | N/A | 6289 Baseline Road | ·Tucson | AZ | 85783-7410·· | GRP-9916 | CORE-HMO |
| TPA | TPA-60551 | 2026-07-24T00:51:03Z | CHRISTINE | — | PHILLIPS | 2005-12-25 | - | •••-••-9078 | 15853908763 | — | ·5907 RIDGE ROAD | Phoenix·· | AZ | 85060 | GRP-3595 | NAVIGATE-HMO |
| TPA | TPA-52703 | 2026-03-03T17:23:25Z | Steve | W | Maldonado·· | 19410616 | UHC-08829-69 | •••-••-9956 | 6146437845 | stephen.maldonado@proton.me | 5247 HILLCREST ROAD | Sacramento·· | ca | — | GRP-1871 | UNKNOWN |
| TPA | TPA-64226 | 2026-09-29T22:39:32Z | piya | — | burke | 02/15/76 | — | NULL | 9566659500 | ·- | ·1398 Ridge Road | Chandler | AZ | ·85268 | N/A | N/A·· |
| TPA | TPA-51183 | 2026-02-11T08:13:55Z | Thomas | — | Soto | 03/01/70 | NULL | •••-••-5765 | 7869810060 | NULL | - | N/A | NULL | ·null | — | SELECT-EPO |
| TPA | TPA-52886 | 2026-02-16T09:55:50Z | Evelyn | — | Green | 05/03/06 | — | UNKNOWN | 369-599-9499 | - | 5420 Jefferson Avenue | Los Angeles | ·CA | 90036 | GRP-4795·· | UNKNOWN |
| TPA | TPA-55361 | 2026-04-29T08:02:56Z | Jeffrey | — | Weaver | 26-10-1979 | UNKNOWN | NULL | - | — | — | ·UNKNOWN | — | - | — | MEDICARE-ADV-A |
| TPA | TPA-54247 | 2026-04-26T20:17:54Z | ·MEGAN | — | HUNTER | 19700818 | ·· | UNKNOWN | null | N/A | 7085 Mountain View Drive Apt 5 | Orlando | FL | 32857 | — | N/A |
| TPA | TPA-59374 | 2026-06-15T09:52:39Z | VALENTINA | Q·· | — | 1949-10-14 | N/A | •••-••-7879 | N/A | UNKNOWN | 3256 Market Street | Tucson·· | AZ | 85710 | — | CORE-HMO |
| TPA | TPA-54529 | 2026-09-21T10:37:37Z | Elizabeth | — | Morrison | 1967-12-24 | — | null | N/A | — | 7434 SUNSET BLVD | Fresno | California | 93723 | null | — |
| TPA | TPA-57298 | 2026-05-29T18:17:35Z | Carol | M | Rodriguez | 19970602 | NULL | - | N/A | null | 5317 FOREST AVENUE | Nashville | TN | 37227 | — | NULL |
| TPA | TPA-56567 | 2026-03-18T21:51:30Z | MARK | — | BRRADLEY | 1976-07-04 | — | null | - | ···· | 7469 MOUNTAIN VIEW DRIVE | Charlotte | NC | 28207 | UNKNOWN | — |
| TPA | TPA-51577 | 2026-01-07T08:38:57Z | Wood, Nicole | — | — | 05/07/2002 | UNKNOWN | •••-••-6217 | NULL | null | - | — | — | — | GRP-8377 | null |
| TPA | TPA-51445 | 2026-01-27T20:01:45Z | Bruce | ·· | Schultz | 08/09/1994 | N/A | NULL·· | — | bruce.schultz@icloud.com | 7122 Indian School Road | SAN DIEGO | CA | 92113 | UNKNOWN | — |
| TPA | TPA-59983 | 2026-05-12T11:07:02Z | Roger | — | Ortega | 1939-04-19 | UHC-44775-27 | •••-••-3573 | 3955539 | — | 9312 Market Street #328 | JACKSONVILLE | fl | 32210·· | — | - |
| TPA | TPA-50364 | 2026-01-08T19:00:11Z | Yang, Agela | R. | — | 1970-01-18 | — | — | UNKNOWN | — | 7662 OAK ST | Austin | TX | 78702 | UNKNOWN | UNKNOWN |
| TPA | TPA-57752 | 2026-03-02T20:56:50Z | Alexanedr | O | Williams | 1964-05-18 | — | •••-••-5070 | 341.524.9761 | — | 9121 Lincoln Way | Los Angeles | CA | 90058-5152 | GRP-1705 | — |
| TPA | TPA-59285 | 2026-03-08T10:41:41Z | MATEO | — | HUGHES | 19650514 | UHC-97145-41 | •••-••-4525 | — | MATEO.HUGHES@YAHOO.COM | NULL | - | null | - | GRP-9405 | null |
| TPA | TPA-56914 | 2026-06-27T09:43:49Z | Noah | ·· | Black | 2000-05-15 | — | N/A | N/A | NULL | UNKNOWN | — | ·N/A | — | GRP-5436 | — |
| TPA | TPA-64368 | 2026-07-05T16:53:58Z | Cheryl | — | Carr | 1981-12-11 | N/A | — | N/A | — | N/A·· | — | NULL | NULL | GRP-6956·· | N/A |
| TPA | TPA-51257 | 2026-08-15T23:21:17Z | ELIJAH | — | PORTER | 1950-09-15 | null | — | null | - | 1434 Canyon Road | Columbus | Ohio | 43202 | N/A | — |
| TPA | TPA-50612 | 2026-02-25T01:12:33Z | Arthur | B. | Banks | ·19550913 | — | •••-••-4984 | ·NULL | ARTHUR.BANKS@GMAIL.COM | 5876 BAYSHORE DRIVE | Seattle | WA | 98111 | N/A | - |
| TPA | TPA-57721 | 2026-09-29T16:37:12Z | SANTIAGO | — | ·ROMERO | 1978-11-20 | N/A | •••-••-0442 | 882-972-3793 | NULL | 2666 Forest Ave | Houston | TX | 77076 | GRP-3967 | — |
| TPA | TPA-50415 | 2026-08-12T03:03:07Z | LORI | — | DIXON | 19390923 | UHC-20645-16 | null | ···· | — | 2347 Sunset Blvd | PLANO | TX | 75003 | GRP-3238 | N/A |
| TPA | TPA-58271 | 2026-09-23T09:58:18Z | Martha | — | Bennett | 03/18/1948 | NULL | NULL | (805) 956-1170 | martha.bennett@proton.me | 8416 Desert Sky Blvd | ·NASHVILLE | TN | 37291 | N/A | NULL |
| TPA | TPA-55944 | 2026-09-15T01:33:22Z | Mary | — | Jacobs | 1983-06-07 | — | •••-••-1043 | — | N/A | 4376 Elm Street | San Antonio | TX | 78234 | — | MEDICARE-ADV-B |
| TPA | TPA-63467 | 2026-03-16T17:58:20Z | Evelyn | F | Hudson | 06/07/89 | NULL | — | - | UNKNOWN | 1021 GRAND AVE | ·PLANO | TX | 75034-9796 | — | null |
| TPA | TPA-59758 | 2026-08-21T03:18:32Z | sara | — | carpenter·· | 11/6/1962 | N/A | •••-••-6211 | 630-385-1522 | NULL·· | 4233 Park Place | Nashville | tn | 37275 | — | — |
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.187Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty