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-55093 | 2026-04-11T22:33:45Z | BETTY | — | ROSE | 14-02-2004 | UNKNOWN | — | null | — | 1454 Grand Avenue | Glendale | AZ | 85332-9116 | UNKNOWN | N/A |
| TPA | TPA-63548 | 2026-06-27T13:56:14Z | DENNIS | — | DELGADO | 1991-08-14 | null | •••-••-0846 | - | — | 7235 Bayshore Drive | ·Fresno | ·CA | 93725 | — | MEDICARE-ADV-A |
| TPA | TPA-56828 | 2026-01-15T00:34:26Z | Harold | ···· | Murray | 1982-06-10 | — | •••-••-4984 | NULL | N/A | 188 Baseline Road | Austin | TX | 78753 | GRP-7015 | UNKNOWN |
| TPA | TPA-52284 | 2026-01-30T07:09:12Z | Scott | U | Gomez | 12/27/1994 | — | — | 3048528575 | N/A | 4489 UNION STREET | Las Vegas | NV | 89155 | GRP-8741 | MEDICARE-ADV-B |
| TPA | TPA-57401 | 2026-08-15T11:59:58Z | ·Marcus | — | McDonald | ·9/22/2001 | null | •••-••-0494 | +1 689 809 0179 | UNKNOWN | 6411 Broadway | Houston | TX | 77085 | — | UNKNOWN |
| TPA | TPA-61121 | 2026-03-12T05:05:47Z | Hamilton, Jeryr·· | — | — | 1954-08-31 | — | null | 209-670-7176 | UNKNOWN | — | — | UNKNOWN | - | — | — |
| TPA | TPA-54288 | 2026-09-19T18:10:12Z | ·RAYMOND | — | PAYNE | 6/1/1967 | UNKNOWN | N/A | 380-847-8937 | null·· | 7626 Broadway·· | Denver | Colorado·· | NULL | — | MEDICARE-ADV-B |
| TPA | TPA-53152 | 2026-05-28T10:23:38Z | Janet | — | Boyd | 19670103 | — | •••-••-9109 | 17848160075 | — | 711 Desert Sky Boulevard | Nashville | TN | 37271 | NULL | — |
| TPA | TPA-53862 | 2026-07-11T04:33:22Z | Parker | — | Denise | 1947-11-17 | NULL | - | NULL | UNKNOWN | UNKNOWN | - | — | NULL | — | null |
| TPA | TPA-55629 | 2026-01-08T09:18:07Z | Matthew | — | Phillips | 09/16/74 | - | - | — | - | — | null | UNKNOWN | - | UNKNOWN | ···· |
| TPA | TPA-50765 | 2026-04-29T14:17:35Z | ANNA | — | KING | 1941-01-11 | UNKNOWN | •••-••-9511 | - | N/A | 251 Main Street | EDEN PRAIRIE | Minnesota | ·55323 | NULL | — |
| TPA | TPA-52826 | 2026-05-15T06:13:34Z | Wei | E | Nelson | 12/11/98 | - | - | UNKNOWN | wei.nelson56@yahoo.com | 139 Main Street | MINNEAPOLIS | MN | 55488 | - | NULL |
| TPA | TPA-58489 | 2026-03-27T04:45:35Z | Tim | — | Henry | 1/7/1955 | UNKNOWN | UNKNOWN | 327.741.6921 | — | — | UNKNOWN | — | N/A | GRP-3773 | — |
| TPA | TPA-63218 | 2026-07-21T07:52:24Z | TERRY | — | CUNNINGHAM | 2007-03-21 | — | UNKNOWN·· | UNKNOWN | — | UNKNOWN | UNKNOWN | null | ·· | GRP-3411 | - |
| TPA | TPA-51214 | 2026-05-25T03:18:30Z | Alan | — | Brown | 2004-01-08 | - | null | (627) 976-0412 | — | 740 Central Avenue | Phoenix | AZ·· | 85077 | NULL | MEDICARE-ADV-B |
| TPA | TPA-61451 | 2026-08-08T14:49:12Z | ·JANET | — | PADILLA | 1974-06-13 | null | N/A | +1 940 498 1769 | null | 5221 Washington St | ·SCOTTSDALE | AZ | 85228·· | - | — |
| TPA | TPA-62871 | 2026-09-16T16:24:19Z | Jose | — | Jensen | 1939-09-04 | NULL | UNKNOWN | - | NULL | 4470 CHURCH ST | Mesa | AZ | 85243 | — | NULL |
| TPA | TPA-60272 | 2026-05-15T23:29:39Z | Sarah | Z. | Guzman·· | Sep 6, 1994 | UNKNOWN | •••-••-8406 | null | — | 2359 Canyon Rd | Minneapolis | MN | 55417 | UNKNOWN | — |
| TPA | TPA-61034 | 2026-06-14T10:03:28Z | MEI | — | BAILEY | 11/9/1966 | UNKNOWN | — | ·5165565888 | — | 1353 DESERT SKY BLVD | Tampa | FL | 33632 | — | UNKNOWN |
| TPA | TPA-62272 | 2026-04-20T17:30:35Z | austin | — | gibson | 01/01/85 | NULL | — | — | — | 8410 SAGE CT | SEATTLE | WA | 98137·· | GRP-3037 | OPTIONS-PPO |
| TPA | TPA-59062 | 2026-06-02T15:23:17Z | Carlos | S | Schmidt | 1942-01-28 | N/A | — | 6087291157 | — | 886 RIDGE ROAD Apt 3 | Atlanta | GA | null | GRP-0935 | OPTIONS-PPO |
| TPA | TPA-59965 | 2026-02-07T06:52:19Z | HANNAH | — | WHITE | 1953-06-08 | UHC-97230-82 | — | null | — | 4277 PALM DR | Eden Prairie·· | MN | 55368 | — | ·SELECT-EPO |
| TPA | TPA-60999 | 2026-02-16T03:55:14Z | WEI | — | WARD | 1973-01-21 | — | N/A | (879) 989-5704 | N/A | 6543 Jefferson Avenue | Minneapolis | MN | ·55455 | GRP-1567 | MEDICARE-ADV-B |
| TPA | TPA-57067 | 2026-03-19T14:44:10Z | Romero | — | Vincent | 1993-07-13 | — | NULL | 816.391.6132 | UNKNOWN | NULL | N/A | N/A | UNKNOWN | N/A·· | - |
| TPA | TPA-57135 | 2026-02-17T04:07:09Z | Christian | — | Moreno | 1942-07-05 | N/A | ·NULL | NULL | CHRISTIAN.MORENO@PROTON.ME | NULL | — | NULL·· | UNKNOWN | NULL | NAVIGATE-HMO |
| TPA | TPA-61308 | 2026-01-07T22:51:20Z | Ahmed | — | Li | 05/11/1952 | N/A | — | 8079369613 | UNKNOWN | 9424 PARK PLACE | Eden Prairie | MN | 55361 | — | — |
| TPA | TPA-62085 | 2026-03-03T03:30:55Z | MEI | — | GRANT | 19670721 | null | — | N/A | — | 8400 Main Street | EDEN PRAIRIE | MN | 55319 | GRP-1354 | ·UNKNOWN |
| TPA | TPA-61931 | 2026-05-04T17:33:21Z | Dean, Madison | — | — | 12/12/1972 | N/A | NULL | (316) 498-7718 | — | NULL | NULL | NULL | - | ···· | — |
| TPA | TPA-57169 | 2026-10-12T06:25:36Z | James | — | Myers | ·Apr 20, 1980 | UHC-80186-79 | null | N/A | null | 493 MARKET ST | MIAMI | FL | 33185 | NULL | - |
| TPA | TPA-52984 | 2026-03-15T14:27:33Z | JULIE | ·· | PENA | 1988-12-02 | null | •••-••-0880 | 294-850-5111 | UNKNOWN | 59 MOUNTAIN VIEW DR | Tucson | ·AZ | 85739 | — | MEDICARE-ADV-A |
| TPA | TPA-52105 | 2026-03-30T07:57:04Z | James, Lauren | — | — | 4/5/1965 | UNKNOWN | — | 389.759.0217 | UNKNOWN | 9798 Main St | Tucson | AZ | 85732 | — | ···· |
| TPA | TPA-55423 | 2026-03-18T11:27:52Z | lisa | — | hawkins·· | Mar 27, 2004 | — | •••-••-2812 | UNKNOWN | - | 6779 BROADWAY | CHARLOTTE | NC | 28250-6942 | GRP-3036 | N/A |
| TPA | TPA-61442 | 2026-08-04T20:26:26Z | maria | — | rojas | 1943-08-21 | UNKNOWN | •••-••-4606 | 5245561709 | — | - | UNKNOWN | N/A | -·· | N/A | ·- |
| TPA | TPA-60286 | 2026-08-06T18:37:04Z | PATRICK | — | HAWKINS | 2007-10-27 | UHC-18890-29 | •••-••-0746 | — | N/A | 4154 Baseline Rd | Charlotte | North Carolina | 28207-3023 | UNKNOWN | NULL |
| TPA | TPA-57073 | 2026-09-21T14:05:29Z | ·Evelyn | ···· | Elliott | 1949-01-12 | null | •••-••-7524 | null | - | 5279 Pine Dr | Houston | TX | 77046 | ·GRP-4086 | MEDICARE-ADV-B |
| TPA | TPA-64305 | 2026-02-26T18:37:03Z | TERESA | A·· | ROBERTS | 19551112 | N/A | NULL | 5032847223 | - | 7920 Main Street | Glendale·· | AZ | 85321 | GRP-2391 | - |
| TPA | TPA-56725 | 2026-09-17T13:51:16Z | Amy | — | Lawrence | ·2003-09-23 | UNKNOWN | UNKNOWN | NULL | ·UNKNOWN | 2012 MOUNTAIN VIEW DRIVE Apt 20 | Denver | CO | 80247-1537 | GRP-6488 | CORE-HMO |
| TPA | TPA-64141 | 2026-01-30T06:22:35Z | Jackie | ···· | Mitchell | 1952-08-19 | — | •••-••-2407 | 9025108443 | null | 4556 Grand Avenue | ATLANTA | GA | 30384 | — | - |
| TPA | TPA-58478 | 2026-07-09T04:37:52Z | Lane, Jeffrey | — | — | 1941-09-24 | null | - | — | UNKNOWN | 3740 Mesa Drive | TUCSON | az | 85791 | N/A | — |
| TPA | TPA-61783 | 2026-02-14T22:10:31Z | Benjamin | C. | — | 1969-07-01 | - | — | 4645659812 | ·UNKNOWN | 8814 PARK PLACE | Nashville | tn | ·N/A | — | UNKNOWN·· |
| TPA | TPA-59029 | 2026-06-27T03:58:13Z | FRANK | — | BURTON | 1964-11-25 | NULL | •••-••-2651 | 582-691-0621 | — | 7178 Indian School Road | Minneapolis | MN | 55493 | — | UNKNOWN |
| TPA | TPA-54680 | 2026-09-29T12:03:04Z | King, Carolyn | — | — | 19570713 | — | — | 893-626-5186 | N/A | 2064 Park Place | San Antonio | TX·· | 78271 | N/A | NULL |
| TPA | TPA-57937 | 2026-05-24T18:32:47Z | Camila | — | Ryan | 1986-10-28 | — | — | 5473255537 | ·· | ·UNKNOWN | ···· | UNKNOWN | — | UNKNOWN | NULL |
| TPA | TPA-60724 | 2026-01-20T13:46:44Z | Reed, Amber | — | — | 08-04-1938 | — | NULL | — | — | 715 Valley View Drive | Miami | FL | 33183 | — | CORE-HMO |
| TPA | TPA-56497 | 2026-07-18T21:25:41Z | Sandra | — | OBrien | 07-10-1985 | — | null·· | 900-916-6639 | - | 7731 Spring Street | Atlanta | GA | ·30320 | null | UNKNOWN·· |
| TPA | TPA-61165 | 2026-02-20T12:26:13Z | VICTORRIA | ···· | GRAHAM | 1970-12-07 | — | •••-••-7960 | UNKNOWN | — | 2255 Cedar Ln | LAS VEGAS | NV | 89185 | — | NULL |
| TPA | TPA-51746 | 2026-07-03T05:53:44Z | JSSE·· | ·· | RYAN | 11/25/84 | NULL | — | (574) 753-4802 | ·· | 1048 Mesa Drive | Glendale | AZ | 85303-6798 | - | OPTIONS-PPO |
| TPA | TPA-58904 | 2026-08-10T13:50:33Z | Karen | — | Ruiz | 8/1/1943 | — | — | — | karen.ruiz98@outlook.com | 5995 Sage Ct | Austin | TX | 78782·· | GRP-6459 | NULL |
| TPA | TPA-51757 | 2026-07-24T22:24:05Z | West, Harold | ·· | — | 04/02/94 | — | NULL | 405.579.5979 | UNKNOWN | 4445 Sage Court | Seattle | Washington | 98162 | NULL | — |
| TPA | TPA-60215 | 2026-02-25T07:43:00Z | jackie | L | wheeler | 5/23/1959 | NULL | •••-••-4166 | NULL | - | 8137 Bayshore Drive | Plano | TX | 75011-7010 | ·GRP-6003 | NULL |
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:37.736Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty