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-58684 | 2026-10-16T05:27:46Z | Virginia | ·· | Black | 1959-02-23 | UNKNOWN | null | (507) 412-9846 | N/A | 5876 Desert Sky Boulevard | Mesa | AZ | — | GRP-0807 | MEDICARE-ADV-B |
| TPA | TPA-57995 | 2026-08-23T22:19:32Z | VICTORIA | I·· | PETERSON | 03/17/04 | ·· | •••-••-2120 | null | — | — | UNKNOWN | - | UNKNOWN | — | NAVIGATE-HMO |
| TPA | TPA-62047 | 2026-09-14T04:14:47Z | CHRISTINE | — | VALDEZ | 1960-02-08 | — | •••-••-1477 | N/A | N/A | — | UNKNOWN | — | NULL | N/A | - |
| TPA | TPA-60320 | 2026-10-01T07:08:49Z | JUSTIN | — | SHAW | 1942-04-02 | — | •••-••-2772 | 896-604-0696 | null | 5769 Oak Street | LAS VEGAS | Nevada | 89112 | GRP-9764·· | SELECT-EPO |
| TPA | TPA-60759 | 2026-10-02T15:13:37Z | JUSTIN | — | ·WATKINS | 2/19/2004 | — | null | UNKNOWN | JUSTIN.WATKINS@ICLOUD.COM | — | null | UNKNOWN | UNKNOWN | GRP-8115 | MEDICARE-ADV-B |
| TPA | TPA-55506 | 2026-02-03T14:48:48Z | virginia | — | weber | 1948-05-14 | NULL | — | — | UNKNOWN | ·6931 Valley View Dr | Dallas | TX | 75268 | null | — |
| TPA | TPA-55925 | 2026-05-14T18:12:12Z | Marshall, Camila | — | — | 1940-01-08 | N/A | — | N/A | camila.marshall51@yahoo.com | 3494 Ridge Road | Miami | FL | 33128 | — | null |
| TPA | TPA-61987 | 2026-04-26T20:14:17Z | Santiago | — | Sandoval | 1959-10-12 | N/A | UNKNOWN | — | santiago.sandoval22@proton.me | 8497 CAMELBACK ROAD | San Antonio | TX | 78213-6923 | — | - |
| TPA | TPA-63101 | 2026-02-28T18:21:03Z | Chris | — | Lee·· | 05/13/2000 | N/A | — | +1 853 450 6471·· | - | 8465 Lake View Rd | Gilbert | AZ | ·85263 | UNKNOWN | — |
| TPA | TPA-59303 | 2026-08-19T09:18:19Z | Dorothy | — | Riley | 1986-06-13 | N/A | •••-••-2764 | NULL·· | null | null | — | — | ·NULL | GRP-9346 | NAVIGATE-HMO |
| TPA | TPA-57796 | 2026-02-02T20:49:04Z | Danielle | — | Ferguson | 1945-04-19 | — | NULL | NULL | — | 3567 ELM STREET | San Antonio | TX | 78209 | — | SELECT-EPO |
| TPA | TPA-63036 | 2026-10-07T23:56:43Z | CAROL | — | TURNER | 06/04/1988 | — | ·· | 8674376699 | null | 834 Highland Ave | Eden Prairie | MN | 55325-3798·· | N/A | SELECT-EPO |
| TPA | TPA-64356 | 2026-01-02T08:27:33Z | GEORGE | N | COLEMAN | 19390505 | - | — | 2869210112 | N/A | 7711 Valley View Dr Apt 34 | Sacramento | CA | 95896 | — | N/A |
| TPA | TPA-57620 | 2026-07-01T04:36:36Z | ·Price, Naoh | U. | — | 19691108 | UHC-27165-52 | •••-••-2727 | +1 555 253 2220 | noah.price@icloud.com | 4559 Market Street | PLANO | TX | 75026 | null | ·null |
| TPA | TPA-55402 | 2026-07-26T14:52:48Z | THERESA | — | MURPHY | 1949-04-01 | — | UNKNOWN | 16405667718 | N/A | ·NULL | NULL | N/A | - | GRP-7247 | NULL |
| TPA | TPA-64362 | 2026-10-02T19:55:17Z | Wang | J | Charles | 06/14/1970 | UHC-77837-25 | null | null | — | 8724 Camelback Rd | Charlotte | NC | 28249 | GRP-2523 | — |
| TPA | TPA-64135 | 2026-08-24T15:09:07Z | Santiago | — | Burton | 1998-05-26 | UHC-39291-32 | — | ·null | N/A | 3029 Willow Ct | ORLANDO | FL | 32897 | GRP-5142 | MEDICARE-ADV-B |
| TPA | TPA-63824 | 2026-07-04T22:56:18Z | Jenkins, Brittany | — | — | 10/02/48 | - | UNKNOWN·· | +1 845 573 9459 | N/A | 4783 Ocean Ave | Charlotte | NC | 28273-1742 | GRP-9508 | — |
| TPA | TPA-62461 | 2026-02-28T16:26:08Z | dylan | A. | greene | 1964-02-10 | null | — | — | null | 8214 MESA DR | Gilbert | AZ | — | — | — |
| TPA | TPA-64127 | 2026-07-16T16:27:50Z | Alexander | — | Woods | 1950-12-07 | UHC-66071-50 | - | +1 475 213 6315 | — | - | NULL | — | — | NULL·· | null |
| TPA | TPA-60430 | 2026-07-09T11:46:34Z | Jerry | ·· | White | Dec 23, 1996 | - | UNKNOWN | 4647922·· | - | 2285 Sage Ct | Seattle | WA | 98181 | GRP-7361 | UNKNOWN |
| TPA | TPA-60397 | 2026-02-18T20:07:13Z | Harvey, Austin | — | — | 2/2/1988 | NULL | N/A | — | N/A | 8260 Main Street | DENVER | CO | 80245 | N/A | ·null |
| TPA | TPA-50877 | 2026-02-23T16:42:28Z | BRIAN | K. | WONG | 09/25/1946 | null | N/A | — | NULL | 2639 Canyon Road | Plano | TX | 75033 | — | SELECT-EPO |
| TPA | TPA-53719 | 2026-02-06T05:36:50Z | Judy | — | Payne | 1950-01-20 | - | - | — | — | 1141 Indian School Road | Minneapolis | MN | 55402 | ·null | OPTIONS-PPO |
| TPA | TPA-61689 | 2026-05-28T06:19:08Z | Weaver, Margaret | F | — | 04/17/1989 | UHC-13952-43 | UNKNOWN | — | - | — | NULL | UNKNOWN | UNKNOWN | -·· | OPTIONS-PPO |
| TPA | TPA-57430 | 2026-08-19T00:05:54Z | Rychardson, Terry | — | — | 07/04/1984 | UHC-96410-44 | •••-••-4834 | UNKNOWN | - | 6145 Park Pl | San Antonio | TX | 78286 | — | - |
| TPA | TPA-53532 | 2026-02-19T20:53:44Z | YUKI | — | DOMINGUZ | 1982-09-13 | UHC2011023 | ·UNKNOWN | 5733552265 | — | 2794 CAMELBACK ROAD | Nashville | TN | 37291 | NULL | null |
| TPA | TPA-50118 | 2026-10-03T01:29:12Z | Vargas, Jean·· | ·· | — | ·1994-08-16 | UNKNOWN | null | NULL | JEAN.VARGAS@OUTLOOK.COM | 8065 MEADOW LANE | Chandler | AZ | 85265 | - | — |
| TPA | TPA-56443 | 2026-01-23T15:23:33Z | Kevin | — | George | 1941-01-17 | — | •••-••-5836 | N/A | kevin.george8@gmail.com | 1143 Jefferson Ave | Houston | TX | ·77030 | UNKNOWN | UNKNOWN |
| TPA | TPA-57666 | 2026-03-24T20:40:14Z | Bailey, Eric | — | — | 1988-04-01 | NULL | UNKNOWN | UNKNOWN | null | 2012 MOUNTAIN VIEW DR | Atlanta | ga | 30315-6292 | UNKNOWN | - |
| TPA | TPA-53632 | 2026-06-12T13:34:41Z | Janice | V. | Stone | 1974-07-18 | N/A | null | 9638437888 | UNKNOWN | 6480 OCEAN AVE #122 | Chandler | AZ | 85290 | — | — |
| TPA | TPA-57303 | 2026-03-05T11:08:23Z | Frnk | — | Kelley | 1942-02-28 | UHC-40168-92 | — | 4224129873 | — | 4477 Sunset Blvd | ·JACKSONVILLE | Florida | 32204 | GRP-5333 | ·· |
| TPA | TPA-54246 | 2026-10-04T05:17:44Z | ZACHARY | — | HILL | 01/15/1958 | N/A | N/A | 253.957.0730 | — | 7404 MARKET ST | Sacramento | California | 95805 | UNKNOWN | N/A |
| TPA | TPA-63109 | 2026-09-01T09:45:21Z | Vincent | — | Hughes | 1978-01-02 | NULL | null | +1 518 925 4297 | - | 8897 WILLOW CT | MESA | AZ | 85292 | GRP-2651 | — |
| TPA | TPA-61369 | 2026-01-24T19:55:45Z | JUDITH | — | BANKS | 1949-01-10 | — | — | 969.225.8400 | N/A | 3720 Main St | Orlando | FL | 32890-9927 | ·NULL | NULL |
| TPA | TPA-63103 | 2026-10-07T09:53:35Z | Zachary | — | Ellis | 06/07/01 | null | UNKNOWN | — | — | 2174 CEDAR LANE | Glendale | AZ·· | 85349 | GRP-1890 | OPTIONS-PPO |
| TPA | TPA-63934 | 2026-08-14T17:30:17Z | JESSICA | — | HILL | Dec 16, 1990 | - | •••-••-6220 | null | jessica.hill@outlook.com | 4977 CHURCH ST·· | Charlotte | NC | 28254 | — | — |
| TPA | TPA-64429 | 2026-03-31T00:41:39Z | Wells, Patrick | — | ·· | 1969-09-19 | NULL | NULL | — | — | 8113 Church Street | Nashville | TN | 37297 | — | - |
| TPA | TPA-54871 | 2026-07-06T11:29:18Z | Sullivan, Elijah | — | — | 1941-04-26 | — | — | +1 349 599 2944 | elijah.sullivan66@outlook.com | 7717 LAKE VIEW RD | Eden Prairie | ·MN | 55373 | GRP-8028 | — |
| TPA | TPA-58412 | 2026-01-31T03:45:59Z | ·Elizabeth | — | Simmons | 1985-06-17 | null | UNKNOWN | — | null | 9041 Baseline Road | Fresno | CA | 93797 | — | — |
| TPA | TPA-60479 | 2026-03-27T13:43:45Z | ANDREA | — | GUZMAN | May 15, 1992 | N/A | ·null | — | NULL | 4778 SAGE COURT #158 | TUCSON | AZ | N/A | GRP-6054 | -·· |
| TPA | TPA-64052 | 2026-05-06T17:17:31Z | NATALIE | — | DANIELS | 11/18/1951 | -·· | — | - | ···· | 1690 Pine Drive | EDEN PRAIRIE | MN | 55375 | GRP-8260 | SELECT-EPO |
| TPA | TPA-59450 | 2026-01-16T01:28:55Z | JESSE | — | CUNNINGHAM | 1960-86-09 | - | ·· | 813-706-4995 | — | 7036 Grand Ave | Tampa | Florida | NULL | — | — |
| TPA | TPA-50226 | 2026-09-02T07:08:23Z | SANDRA | — | WARREN | Aug 1, 1993 | ·UHC-88298-78 | •••-••-2841 | null | null | 2427 SPRING STREET | Sacramento | CA·· | 95864 | GRP-3820 | NULL |
| TPA | TPA-60963 | 2026-06-30T21:13:40Z | JESSE | N. | DUNN | 1939-01-26 | - | •••-••-3886 | 4098322813 | — | 7126 Sage Ct | Phoenix | az | 85029-4568 | GRP-6544 | — |
| TPA | TPA-51091 | 2026-07-31T19:25:15Z | Jazon | — | ·Garza | 2003-03-24 | null | — | ···· | null | N/A | — | — | NULL | ···· | N/A |
| TPA | TPA-60340 | 2026-10-17T20:33:47Z | Carr, Rachel·· | H | — | 1969-09-16 | UNKNOWN | — | ···· | N/A | 6128 Central Ave | SEATTLE | WA·· | 98165-1476 | GRP-5312 | NAVIGATE-HMO |
| TPA | TPA-55730 | 2026-08-10T14:09:04Z | kayla | — | reid | 09/12/03 | uhc-98078-99 | •••-••-9592 | — | ·UNKNOWN | 2115 Market St | SACRAMENTO | CA·· | 95845 | — | N/A |
| TPA | TPA-61836 | 2026-01-24T21:13:31Z | ANGELA | — | ELLIS | 3/2/1949 | ···· | UNKNOWN | (446) 376-2583 | — | 9545 Apache Boulevard | FRESNO | CA | 93761 | - | null |
| TPA | TPA-52343 | 2026-03-29T21:05:16Z | Edward | — | Herrera | 1942-04-27 | — | •••-••-2746 | 7516314351 | UNKNOWN | 8620 Harbor Boulevard | Tampa | FL·· | 33676-6569 | GRP-2612 | — |
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.733Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty