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-64043 | 2026-07-11T06:52:42Z | Lauren | P. | Thomas | 1956-10-12 | — | — | — | N/A | 8053 Pine Drive | San Diego | CA | 92143 | — | UNKNOWN |
| TPA | TPA-58079 | 2026-07-06T12:23:31Z | BBOBY | E | RODRIGUEZ | 1967-01-04 | UHC-12282-59 | — | UNKNOWN | N/A | 2655 Bayshore Drive | Phoenix | AZ | N/A | GRP-0928 | — |
| TPA | TPA-58229 | 2026-03-05T00:35:16Z | Anna | — | Edwards | 2001-12-09 | NULL | •••-••-5080 | -·· | null | 3858 Willow Court | Seattle | WA | 98135 | — | - |
| TPA | TPA-54353 | 2026-05-28T14:10:15Z | Luis | — | Bell | 1956-03-23 | ·- | ·N/A | (651) 957-1616 | — | UNKNOWN | — | — | — | GRP-4765 | UNKNOWN·· |
| TPA | TPA-56589 | 2026-07-06T08:28:52Z | Brenda | — | Reed | 02/24/1974 | NULL | ···· | — | — | 3928 HILLCREST ROAD | Eden Prairie | MN | 55320 | GRP-9981 | null |
| TPA | TPA-53626 | 2026-08-15T19:15:24Z | PATRICK | — | GIBSON | 1993-10-06 | ·N/A | — | - | N/A | NULL | — | UNKNOWN | — | — | null |
| TPA | TPA-53807 | 2026-03-03T08:00:06Z | JEAN | — | VASQUEZ | 15-09-1972 | UHC-72732-38 | null | null | null | 447 Ocean Avenue | JACKSONVILLE | FL | 32204 | UNKNOWN·· | UNKNOWN |
| TPA | TPA-55569 | 2026-01-18T07:30:31Z | Yuki | — | ·Hoffman | Mar 10, 1940 | - | — | (649) 374-1097 | null | 4114 River Rd | Tampa | FL | 33648 | — | UNKNOWN |
| TPA | TPA-62496 | 2026-08-22T16:39:14Z | Guzman, Mark | — | — | 1953-04-07 | ·UHC-53643-04 | •••-••-2247 | UNKNOWN | — | 9499 Forest Ave | Scottsdale | AZ | 85292 | — | null |
| TPA | TPA-61036 | 2026-09-17T03:46:09Z | Ralph | — | Morris | 1971-12-28·· | N/A | — | 4719739793 | — | ·2055 Forest Avenue | Austin | TX | 78718 | GRP-3435 | — |
| TPA | TPA-53704 | 2026-03-20T10:16:50Z | Jason | — | Davis | 2008-11-02 | UHC-10468-58 | •••-••-8437 | 888-625-8419 | jason.davis@hotmail.com | 8435 Pine Dr | Gilbert | Arizona | 85288-1731 | GRP-2168 | OPTIONS-PPO |
| TPA | TPA-50858 | 2026-04-06T06:49:10Z | TYLER | ·· | MITCHELL | 06/17/81 | N/A | •••-••-9766 | — | — | UNKNOWN | UNKNOWN | NULL | — | NULL | UNKNOWN |
| TPA | TPA-51565 | 2026-08-30T08:25:01Z | EMMA·· | — | WATSON | 1991-08-15 | UHC-67915-09 | — | — | N/A | 1108 Elm St | Sacramento | CA | 95854 | - | SELECT-EPO |
| TPA | TPA-53371 | 2026-07-18T13:26:56Z | ·MEGAN | — | CARR | 19620816 | — | •••-••-8559 | — | megan.carr98@proton.me | 2579 Meadow Lane | Los Angeles | CA | 90003 | GRP-3562 | — |
| TPA | TPA-58421 | 2026-07-01T22:24:10Z | Kelly | — | Gonzales | 12/21/1965 | — | null | 870-526-2186 | UNKNOWN | 4772 Forest Avenue | Plano | TX·· | 75014 | - | OPTIONS-PPO |
| TPA | TPA-59229 | 2026-02-08T07:12:45Z | Ray | — | Mendez | 2005-06-03 | — | NULL | — | UNKNOWN | 3227 Mountain View Dr | Atlanta | GA | 30321 | — | — |
| TPA | TPA-60222 | 2026-02-26T18:32:36Z | Isabella | — | Perez·· | 1981-06-24 | UHC-78595-08 | N/A | ·· | — | 3412 Apache Blvd | Charlotte | NC | 28282 | - | select-epo |
| TPA | TPA-59160 | 2026-07-31T01:40:45Z | CHRISTIAN | — | ELLIOTT·· | 07/07/72 | UHC-57110-89 | •••-••-0199 | — | christian.elliott@yahoo.com | null | null | — | -·· | GRP-0387 | — |
| TPA | TPA-63748 | 2026-04-29T20:57:17Z | Ahmed·· | O. | Coleman | 1975-03-03 | — | — | ·15126065971 | ahmed.coleman21@gmail.com | 4581 FOREST AVENUE | Columbus | OH | 43255 | — | — |
| TPA | TPA-60645 | 2026-04-27T19:44:26Z | Diana | — | Tran | 1939-03-24 | - | •••-••-9502 | — | diana.tran67@outlook.com·· | N/A | — | UNKNOWN | — | — | N/A |
| TPA | TPA-59921 | 2026-07-13T12:38:35Z | Jerry | V | Howard | 11/01/64 | N/A | — | 17605309171 | jerry.howard@hotmail.com | 7324 MEADOW LN | Los Angeles | CA | 90066 | — | NAVIGATE-HMO |
| TPA | TPA-54305 | 2026-07-11T23:11:11Z | bryan | — | williams | Aug 9, 2007 | — | •••-••-1759 | (219) 836-5668 | -·· | 3380 Park Place | Tempe·· | AZ | 85201·· | — | MEDICARE-ADV-A |
| TPA | TPA-60746 | 2026-01-14T10:02:36Z | MARIANA | — | STEWART | May 9, 1984 | UHC-55215-31 | N/A | ·null | N/A | ·4958 Indian School Rd | HOUSTON | TX | 77056 | GRP-3115 | NAVIGATE-HMO |
| TPA | TPA-53798 | 2026-02-18T01:16:42Z | RUTH | I | FISHER | Oct 20, 1968 | — | — | — | — | 5096 BROADWAY | Los Angeles | CA | 90091 | — | N/A |
| TPA | TPA-62258 | 2026-07-30T17:40:29Z | ROBERT | ·J. | BRYANT | 19721214 | UNKNOWN | •••-••-9027 | NULL | N/A | 7085 Maple Ave | Orlando | FL | — | — | — |
| TPA | TPA-63638 | 2026-06-16T06:33:28Z | Brenda | H | Gordoon | 1965-06-14 | null | — | null | - | ·6342 Harbor Boulevard #325 | Jacksonville | FL | 32227 | ·null | null |
| TPA | TPA-52555 | 2026-01-04T12:34:04Z | Aisha | — | Griffin | 2005-09-04 | UNKNOWN | UNKNOWN | ·· | — | 5361 Elm St | CHANDLER | AZ | 85229 | - | null |
| TPA | TPA-54483 | 2026-03-25T12:59:52Z | MATEO | T | HARRSI | 1943-12-06 | - | — | 7643636 | - | 7925 LINCOLN WAY | Tucson | Arizona | 85782 | — | UNKNOWN |
| TPA | TPA-63496 | 2026-04-20T02:10:22Z | ·albert | — | stephens | 1990-04-16 | NULL | UNKNOWN | UNKNOWN | — | N/A | — | — | UNKNOWN | GRP-5602 | — |
| TPA | TPA-54702 | 2026-08-19T20:42:16Z | AHMED | — | JACOBS | 1983-06-07 | N/A | — | null | - | 1326 LINCOLN WAY | Plano | TX | 75070 | NULL | null·· |
| TPA | TPA-53048 | 2026-10-14T17:11:18Z | KEVIN | — | JACOBS·· | 1973-08-14 | - | •••-••-9235 | 656-565-3025 | — | 9820 Harbor Blvd | Jacksonville | FL | 32202 | -·· | N/A |
| TPA | TPA-55169 | 2026-05-12T07:48:58Z | Melissa | — | Stephens | 2004-04-03 | ·null | - | null | — | 2913 Sunset Boulevard | JACKSONVILLE | ·FL | 32280 | NULL | ···· |
| TPA | TPA-56761 | 2026-04-29T03:07:22Z | Kathy | — | Watkins | 1972-05-26 | - | — | 18113903013 | kathleen.watkins51@yahoo.com | 630 Desert Sky Boulevard | CHARLOTTE | North Carolina | 28297·· | null | NAVIGATE-HMO |
| TPA | TPA-58468 | 2026-02-19T12:01:14Z | Nathan | — | Harrison | 1967-09-23 | UNKNOWN·· | •••-••-3947 | 536.812.3885 | — | 452 Highland Ave | Chandler·· | ·Arizona | 85231 | UNKNOWN | null |
| TPA | TPA-58569 | 2026-07-04T00:10:23Z | Adam | I | Duncan | 1971-05-03 | - | - | UNKNOWN | — | 1918 Canyon Rd | Minneapolis | ·MN | 55449 | — | — |
| TPA | TPA-60216 | 2026-07-26T07:27:30Z | Lia·· | — | Andesron | 19511209 | N/A | — | 869-655-8856 | — | 2347 Market St #993 | Jacksonville | FL | 32216 | GRP-7803 | N/A |
| TPA | TPA-55691 | 2026-08-08T05:31:58Z | GONZALEZ | — | ·MELISSA | 01/07/75 | - | — | N/A | — | 4070 Union St | Jacksonville | FL·· | 32256 | GRP-7016 | OPTIONS-PPO |
| TPA | TPA-50445 | 2026-08-22T00:40:24Z | Hunter, Sean | — | — | 18-01-1944 | — | N/A | 618-512-4174 | null | 5604 Pine Drive | Austin | TX | 78795 | N/A | N/A |
| TPA | TPA-56064 | 2026-03-13T10:34:53Z | ALEXANDER·· | V. | WILLIAMSON | 1968-05-42 | UNKNOWN | — | 7166095209 | alexander.williamson88@yahoo.com | 5393 Ridge Road | Las Vegas | NV | 89146 | — | — |
| TPA | TPA-54087 | 2026-06-05T11:51:06Z | LUIS | — | RICHARDS | 21-08-1969 | — | - | 920-461-7339 | null | 6338 INDIAN SCHOOL RD | GILBERT·· | AZ·· | ·85225 | — | MEDICARE-ADV-B |
| TPA | TPA-60450 | 2026-07-17T17:50:50Z | Victoria | — | Santiago | ·02/16/1981 | UNKNOWN | •••-••-7571 | — | null | — | — | UNKNOWN | null | — | - |
| TPA | TPA-63717 | 2026-04-26T13:12:00Z | Doris | — | Mendez | 11/25/1997 | — | null | - | doris.mendez89@yahoo.com | 4014 HARBOR BOULEVARD | Miami | FL | NULL | ·GRP-7243 | - |
| TPA | TPA-54768 | 2026-01-22T07:19:39Z | Ryan·· | — | Knyght | 19521119 | null | - | 947-773-8831·· | — | 8974 Willow Ct | Houston | TX | 77050·· | UNKNOWN | NAVIGATE-HMO |
| TPA | TPA-58826 | 2026-06-16T07:04:07Z | Torres, Gloria | — | — | 1991-11-21 | — | — | UNKNOWN | — | 156 SUNSET BOULEVARD #548 | Charlotte | NC | 28268 | — | — |
| TPA | TPA-58179 | 2026-02-18T12:54:17Z | ·Brown, Russell | — | — | 1941-07-27 | N/A | null | (279) 465-9772 | null | 654 FOREST AVENUE·· | ORLANDO | FL | 32804 | — | UNKNOWN |
| TPA | TPA-54112 | 2026-08-11T05:34:05Z | ·Owens, Bryan | — | — | ·11/02/52 | NULL·· | — | - | - | 9413 Ocean Ave | Minneapolis | MN | 55485-6187 | N/A | NULL |
| TPA | TPA-54736 | 2026-02-16T22:36:29Z | FATIMA | — | BAKER | 12/22/1982 | NULL | ·null | UNKNOWN | UNKNOWN | 7973 Apache Boulevard | ·CHANDLER | az | 85289 | GRP-0142 | N/A |
| TPA | TPA-54621 | 2026-03-24T01:15:35Z | SOFIA | — | WELCH | 09/24/2005 | — | — | 12498555139 | — | 9888 Main Street | Eden Prairie | mn | 55330 | GRP-0266 | N/A·· |
| TPA | TPA-52193 | 2026-08-08T12:11:04Z | Contreras, Arthur | I | — | 10/20/43 | UHC-78188-71 | — | — | — | 3294 Baseline Road | JACKSONVILLE·· | FL | 32277 | ···· | SELECT-EPO |
| TPA | TPA-63185 | 2026-04-09T23:32:16Z | Stevens, Luis | — | — | 2003-07-18 | - | •••-••-1931 | UNKNOWN | N/A | 7599 GRAND AVE | Sacramento·· | CA | 95850 | GRP-1518 | — |
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:53.137Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty