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-61848 | 2026-10-05T12:15:20Z | theresa | — | gonzales | 09/04/1981 | NULL | •••-••-6886 | - | UNKNOWN | 6783 Meadow Lane | Tempe | Arizona | 85291 | — | UNKNOWN |
| TPA | TPA-60552 | 2026-04-16T02:05:37Z | Christine | — | Phillips | 12/25/2005 | — | — | NULL | CHRISTINE.PHILLIPS1@PROTON.ME·· | NULL | N/A·· | — | — | — | NULL |
| TPA | TPA-56429 | 2026-09-23T20:34:25Z | MASON | — | WEAVER | 1946-08-27 | — | •••-••-1652 | — | — | 248 PALM DRIVE | Fresno·· | CA | 93706 | null | MEDICARE-ADV-A |
| TPA | TPA-56305 | 2026-08-09T07:33:20Z | ·Clark, Geroge | — | — | 12/20/1957 | UHC-07697-40 | •••-••-7839 | ·null | N/A | 2954 BAYSHORE DR | Eden Prairie | MN | 55306 | NULL | CHOICE-PLUS-PPO |
| TPA | TPA-60543 | 2026-09-23T08:16:01Z | Tyler | — | Edwards | 1988-03-04 | N/A·· | •••-••-2479 | N/A | ·TYLER.EDWARDS20@HOTMAIL.COM | 8005 Church St | Los Angeles | CA | 90056-7918 | GRP-6863 | NULL |
| TPA | TPA-54308 | 2026-07-16T16:46:46Z | Camila | M | Allen | 2008-03-09 | null | — | NULL | NULL | 2209 BROADWAY | Plano | tx | 75028 | GRP-0799 | NULL |
| TPA | TPA-52632 | 2026-07-21T22:09:44Z | Emily | — | Peters | Aug 9, 1962 | — | NULL | — | EMILY.PETERS95@ICLOUD.COM | — | — | — | null | — | — |
| TPA | TPA-61893 | 2026-10-13T02:09:31Z | sean | — | howell | 1979-03-20 | UHC-66065-50 | •••-••-0737 | ·(622) 749-6210 | SEAN.HOWELL@AOL.COM | 1203 Sage Ct | Sacramento | CA | 95889 | null | OPTIONS-PPO |
| TPA | TPA-63666 | 2026-06-30T23:43:37Z | eugene·· | — | edwards | 1968-07-25 | UNKNOWN | N/A | 8592826276 | - | 6041 Ridge Road | Mesa | AZ | 85218 | ·N/A | ·· |
| TPA | TPA-56925 | 2026-09-02T04:26:39Z | Sharon | — | ·Herrera | 01-02-1966 | — | — | — | NULL·· | 8230 MARKET ST | Jacksonville | FL | 32291·· | NULL | N/A |
| TPA | TPA-59497 | 2026-07-09T00:48:52Z | Henry | U | Chen | 1945-11-01 | null·· | - | — | HENRY.CHEN@PROTON.ME | 7603 SUNSET BLVD | DALLAS | Texas | 75297 | NULL | CHOICE-PLUS-PPO |
| TPA | TPA-61221 | 2026-02-27T13:01:43Z | Dennis | ·· | Daniels | 19720210 | UHC-93018-85 | •••-••-2638 | — | N/A | 3114 Elm Street | HOUSTON | TX | 77041 | — | - |
| TPA | TPA-50316 | 2026-09-08T12:22:12Z | SUSAN | — | BENNETT | 1951-07-12 | — | ·· | 989.436.2311 | susan.bennett38@aol.com | 8267 JEFFERSON AVENUE·· | DENVER | CO | 80203 | GRP-6839 | — |
| TPA | TPA-51140 | 2026-09-18T07:39:25Z | ALICE | — | TAYLOR | 12/28/50 | - | UNKNOWN | 681.855.9476 | ALICE.TAYLOR@HOTMAIL.COM | 8487 LAKE VIEW RD | Tucson | AZ | 85764 | - | — |
| TPA | TPA-63117 | 2026-06-16T12:22:45Z | ·Rachel | U | Bker | 2006-10-24·· | UHC-32037-03 | NULL | NULL | null·· | — | null | N/A | N/A | GRP-1941 | NULL |
| TPA | TPA-62277 | 2026-05-25T11:57:42Z | Sean | — | Kelly | ·20030808 | null | •••-••-6571 | — | sean.kelly@yahoo.com | 4766 GRAND AVE | EDEN PRAIRIE | MN | 55307 | — | — |
| TPA | TPA-62560 | 2026-01-27T21:35:25Z | Sara | — | Murray | 1944-05-25 | NULL | •••-••-7785 | UNKNOWN | — | 9636 Spring Street #982 | Columbus | OH | 43241 | — | CHOICE-PLUS-PPO |
| TPA | TPA-60989 | 2026-01-22T05:32:47Z | Bradley | — | Martinez | 7/23/1970 | — | NULL | - | — | 6301 Park Pl | Minneapolis | MN | 55404 | GRP-9813 | null |
| TPA | TPA-50105 | 2026-01-31T03:03:12Z | Sofia | — | ·Woods | ·1961-10-28 | - | •••-••-4619 | UNKNOWN | — | 6262 FOREST AVE | Chandler | AZ | 85238 | NULL | UNKNOWN |
| TPA | TPA-55434 | 2026-03-17T00:27:32Z | ·Elizabeth | — | Hernandez | 1945-01-01 | - | •••-••-7157 | (330) 493-2376 | — | 4988 BASELINE RD | Tucson | AZ | 85757-0073 | — | — |
| TPA | TPA-59482 | 2026-06-11T04:47:58Z | Madison | — | Moore | Jan 14, 2001 | — | UNKNOWN | NULL | N/A | 6393 Grand Avenue | Tempe | AZ | 85260 | GRP-9212 | - |
| TPA | TPA-50931 | 2026-08-17T17:53:50Z | Hamilton, Gloria | ·· | — | ·20080122 | N/A·· | null | — | gloria.hamilton23@icloud.com·· | 4463 Lake View Rd | Tampa | FL | ·· | GRP-7053 | N/A |
| TPA | TPA-56149 | 2026-06-24T03:52:00Z | Harris, Anthony | — | — | 1960-08-04 | UHC-51862-60 | ·- | 8492710678 | anthony.harris@aol.com | 2320 Harbor Blvd | Orlando | FL | 32824 | GRP-9197 | — |
| TPA | TPA-50736 | 2026-03-25T16:11:59Z | Stephen | — | Jensen | 1981-11-03 | — | — | N/A·· | UNKNOWN | — | - | NULL | UNKNOWN | GRP-2961 | SELECT-EPO |
| TPA | TPA-64128 | 2026-03-04T03:55:43Z | DIEGO | F | ELLIS | 1977-03-18 | NULL | •••-••-6276 | — | DIEGO.ELLIS@PROTON.ME | 7590 WILLOW COURT | Orlando | FL | ·32876 | GRP-8078 | SELECT-EPO |
| TPA | TPA-63569 | 2026-10-01T16:34:54Z | BRITTNY | — | BANKS | 1948-07-03 | null | •••-••-3080 | 915-505-1099 | UNKNOWN | 493 CAMELBACK ROAD | Orlando | Florida | 32858 | GRP-3018 | OPTIONS-PPO |
| TPA | TPA-56082 | 2026-08-24T03:44:42Z | Carlos | — | Fields | 2005-11-05 | UNKNOWN | — | null | - | 9541 RIDGE RD | JACKSONVILLE | FL | 32278-1890 | — | null |
| TPA | TPA-62070 | 2026-07-23T16:52:59Z | Brian | — | Adams | 1954-04-02 | ·N/A | •••-••-7062 | 785-743-0725 | — | 4847 Ridge Rd | Minneapolis | ·MN | 55470 | - | — |
| TPA | TPA-58477 | 2026-09-10T19:28:47Z | BRADLEY | ·· | ARNOLD | 06/07/1982 | UNKNOWN | — | — | bradley.arnold@aol.com | 112 Ocean Ave·· | Eden Prairie | MN | 55316 | — | - |
| TPA | TPA-54741 | 2026-01-02T01:03:26Z | Ashley | — | Gibson·· | 2005-08-12 | N/A | null | (770) 369-7222 | — | 8818 Maple Avenue | Phoenix | AZ·· | 85045 | N/A | OPTIONS-PPO |
| TPA | TPA-59748 | 2026-02-20T10:31:17Z | LUIS | P | FREEMAN | 19900327·· | NULL·· | •••-••-1617 | NULL | UNKNOWN | 3146 Canyon Rd | ·GILBERT | az·· | 85274 | — | — |
| TPA | TPA-57203 | 2026-05-10T12:50:44Z | Rebeca | — | ·Armstrong | 1941-01-17 | UHC-21586-51·· | — | (608) 843-3273 | UNKNOWN | 4269 JEFFERSON AVE | San Diego | ca | 92152 | ·N/A | MEDICARE-ADV-A |
| TPA | TPA-58064 | 2026-01-08T13:32:49Z | barbara | — | ·ortiz | 1975-09-23 | — | •••-••-4082 | — | — | 9244 HILLCREST ROAD | Scottsdale | Arizona | 85247 | GRP-3545 | CHOICE-PLUS-PPO |
| TPA | TPA-52768 | 2026-05-05T08:41:56Z | PEGGY | — | HILL | 1946-11-12 | — | — | 225-820-3107 | — | 7893 Lake View Rd | ·Charlotte | North Carolina | 28278 | - | — |
| TPA | TPA-50082 | 2026-02-10T00:38:08Z | albert | — | montgomery | 1971-02-03 | null | — | — | — | 7534 Cedar Lane | Glendale | ·AZ | — | null·· | — |
| TPA | TPA-63100 | 2026-07-25T09:17:07Z | ·Eugene | ·· | Mason | 1940-07-01 | N/A | NULL | - | UNKNOWN | 7057 Market St | LOS ANGELES | CA | — | GRP-5564·· | null |
| TPA | TPA-50337 | 2026-01-11T23:58:15Z | Kathryn | — | King | 11/05/96 | — | - | (594) 948-5491 | — | 862 Camelback Rd | San Diego | CA | 92171 | GRP-0959 | MEDICARE-ADV-B |
| TPA | TPA-54102 | 2026-03-18T04:11:39Z | Patrick·· | O | Jones | 4/2/1960 | null | - | (437) 920-1990 | — | 4740 Canyon Road | Charlotte | NC | 28245 | UNKNOWN | null |
| TPA | TPA-59707 | 2026-06-12T07:16:21Z | JUDY | X. | MASON | 8/20/1953 | — | N/A | +1 830 325 8877 | NULL | ·UNKNOWN | N/A | — | null | — | — |
| TPA | TPA-51686 | 2026-10-05T10:35:29Z | Raymond | ·S | Aguilar | 03-04-1951 | — | N/A | — | — | 1291 HIGHLAND AVE | Chandler | AZ | 85250 | GRP-3964 | ·NAVIGATE-HMO |
| TPA | TPA-62564 | 2026-10-06T09:04:56Z | Amber | E. | OBrien | 1/2/1986 | UNKNOWN | •••-••-2122 | — | — | 8267 SPRING STREET | Houston | TX | 77031 | — | ···· |
| TPA | TPA-56236 | 2026-05-16T18:00:23Z | Kathleen | — | Morris | 1962-10-27 | - | •••-••-3651 | null·· | kathleen.morris1@icloud.com | ·4720 APACHE BOULEVARD | Tucson | ·AZ | 85750 | — | null |
| TPA | TPA-61373 | 2026-06-15T02:38:56Z | Kelley, Lius | — | — | 1998-05-21 | - | •••-••-5328 | (806) 464-7325 | UNKNOWN | 4043 Spring St | LAS VEGAS | NV | 89128 | GRP-2541 | — |
| TPA | TPA-52888 | 2026-09-05T11:08:12Z | Gerald | — | Lopez | 11/18/2004 | N/A | — | 377-926-8670 | - | 3691 Jefferson Avenue | JACKSONVILLE | Florida | ·32288 | UNKNOWN·· | UNKNOWN |
| TPA | TPA-55657 | 2026-03-27T19:49:32Z | Jezse | — | Lopez | 1970-12-28 | — | — | 942-769-7990 | NULL | 1244 Oak Street | Tempe | AZ | 85215 | ···· | NULL |
| TPA | TPA-57931 | 2026-04-05T02:46:36Z | ROGER | — | BISHOP | 19751101 | null | — | - | ROGER.BISHOP@GMAIL.COM | 5376 Bayshore Dr #602 | LOS ANGELES | CA | 90063 | - | medicare-adv-a |
| TPA | TPA-62436 | 2026-03-03T04:12:44Z | Miller, Rebecca | — | — | 1970-12-08 | — | — | UNKNOWN | null | 9024 Valley View Dr | Miami | FL | 33143 | — | NULL |
| TPA | TPA-57206 | 2026-03-30T03:54:58Z | NOAH | — | WOODS | 1999-05-23 | N/A | — | - | N/A | — | — | - | - | — | -·· |
| TPA | TPA-50506 | 2026-05-27T13:53:14Z | ·Alexander | R | Castro | 19571001 | — | N/A | ·- | ALEXANDER.CASTRO91@YAHOO.COM | 1906 Broadway | Los Angeles | CA | 90097 | GRP-7545 | null |
| TPA | TPA-60268 | 2026-06-03T19:03:57Z | Lauren | — | Porter | 1962-08-04 | UHC-47113-19 | •••-••-6054 | — | UNKNOWN | N/A | — | — | UNKNOWN | GRP-0467 | 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:40.328Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty