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-60885 | 2026-06-12T09:48:27Z | Joyce | ···· | Sanchez | 1966-10-24 | UHC-16910-09 | UNKNOWN | 5079071539 | null | 2620 MARKET STREET | Las Vegas | NV·· | — | — | N/A |
| TPA | TPA-58133 | 2026-09-06T23:18:40Z | Powell, Bradley | — | — | 12/2/1988 | NULL | •••-••-7783 | NULL | — | 5426 Camelback Road | PLANO | Texas | 75059 | N/A | — |
| TPA | TPA-57111 | 2026-04-20T11:38:38Z | Mills, Lisa | — | — | ·12-08-1942 | UHC-79129-20 | null | — | — | 4582 Pine Dr | Las Vegas | NV | ·89107 | UNKNOWN | CHOICE-PLUS-PPO |
| TPA | TPA-59158 | 2026-07-31T19:40:01Z | Hansen, Dennis | — | — | May 6, 1940·· | — | •••-••-0228 | N/A·· | null | 9125 Jefferson Avenue·· | Phoenix·· | AZ | 85058 | - | ···· |
| TPA | TPA-51966 | 2026-07-18T05:02:09Z | joey | — | lewis | 2005-04-10 | — | — | NULL | — | 1020 CEDAR LN | Scottsdale | AZ | 85227 | GRP-2287 | N/A |
| TPA | TPA-58280 | 2026-01-19T01:23:13Z | Ann | — | Garrett | 1977-01-19 | - | UNKNOWN | (486) 570-0176 | N/A | 6583 Oak Street #765 | HOUSTON | TX | 77084-6656 | — | ·N/A |
| TPA | TPA-55602 | 2026-10-09T00:16:31Z | Mitchell, Mateo | Y | — | 09/13/1983 | NULL | UNKNOWN | 291-708-0633 | — | — | — | — | NULL | GRP-2111 | — |
| TPA | TPA-57055 | 2026-09-04T09:27:15Z | NOAH | Y | HUGHES | 1954-12-24 | - | •••-••-3288 | UNKNOWN | UNKNOWN | 7724 Bayshore Dr | Tempe | AZ | 85246-3991 | null | CHOICE-PLUS-PPO |
| TPA | TPA-50147 | 2026-05-09T06:13:50Z | JOE | X | ·HUDSON | 1988-08-22 | - | — | — | - | 22 Grand Avenue | Scottsdale·· | AZ | 85213 | -·· | null |
| TPA | TPA-53792 | 2026-06-09T07:05:11Z | Lori | F | Dominguez | 2000-09-04 | — | NULL | — | ···· | NULL·· | — | - | NULL | GRP-8624 | NULL |
| TPA | TPA-57448 | 2026-04-11T19:59:15Z | Jerry | ·· | Hughes | 26-05-1983 | null | •••-••-5123 | - | ·JERRY.HUGHES90@YAHOO.COM | 1707 Hillcrest Road | SEATTLE | WA | 98147-4864 | GRP-5996 | - |
| TPA | TPA-59085 | 2026-03-08T20:25:22Z | stephanie | — | armstrong | 01/24/94 | null | UNKNOWN | — | N/A | - | — | UNKNOWN | — | - | MEDICARE-ADV-A |
| TPA | TPA-53978 | 2026-07-30T21:55:49Z | ASHLEY | — | MARQUEZ | 1974-06-24 | — | — | 5198953939 | null | N/A | N/A | UNKNOWN | NULL | N/A | UNKNOWN |
| TPA | TPA-56801 | 2026-03-15T06:45:37Z | Bill | — | ·Wrighht | 1999-12-01 | — | N/A | ·null | null | 5224 APACHE BLVD | Fresno | CA | 93732 | — | — |
| TPA | TPA-52472 | 2026-07-25T01:57:33Z | Alexander | R | Oliver | 0624-91-88 | NULL | •••-••-1569 | NULL | — | ·- | — | — | N/A | — | — |
| TPA | TPA-51808 | 2026-02-08T09:45:16Z | Sharon | B | Santos | 1990-01-28 | UNKNOWN | — | NULL | sharon.santos9@aol.com | 6404 BAYSHORE DR | Denver | CO·· | 80272 | - | UNKNOWN |
| TPA | TPA-59675 | 2026-07-04T20:04:57Z | William | — | Black | 04/12/1956 | null | — | ···· | UNKNOWN·· | 3862 Canyon Road | Houston | TX | 77098·· | N/A | - |
| TPA | TPA-50212 | 2026-04-18T22:40:02Z | Fatima | — | Kim | Aug 22, 1976 | — | null | — | — | 6634 BASELINE ROAD | Charlotte | NC | 28222 | - | NAVIGATE-HMO |
| TPA | TPA-51905 | 2026-03-24T13:14:15Z | patricia | — | bryant | 1990-12-07 | - | •••-••-3898 | — | -·· | 2419 Maple Ave | Denver | CO | 80271 | GRP-5940 | — |
| TPA | TPA-56375 | 2026-09-09T03:43:32Z | AARON | — | REYES | ·Apr 20, 2005 | NULL | •••-••-3704 | — | — | 2415 RIDGE RD | ·Tampa | FL | 33640 | — | MEDICARE-ADV-B·· |
| TPA | TPA-51811 | 2026-07-29T05:48:33Z | Ryan, Mendez | — | — | 1969-06-26 | null | •••-••-4108 | (896) 599-4565 | — | 2216 Lake View Road | Fresno | CA | 93714 | GRP-6086·· | — |
| TPA | TPA-62855 | 2026-09-10T22:30:32Z | CYNTHIA·· | — | RAMIREZ | NULL | — | null | N/A | null | - | ···· | — | NULL | GRP-7523 | NULL |
| TPA | TPA-63418 | 2026-09-18T11:10:56Z | Daniel | — | Davis | 2004-12-08 | UHC-43463-17 | ·· | — | - | ·8632 Camelback Road | Dallas | TX | 75272 | NULL | — |
| TPA | TPA-56176 | 2026-05-13T17:59:54Z | julie | — | li | 1/24/1986 | NULL | — | 9312746436 | NULL | — | N/A | UNKNOWN | — | — | N/A |
| TPA | TPA-50406 | 2026-03-10T09:57:51Z | Justin | — | Gordon | 2006-04-25 | UHC-77734-83 | •••-••-3132 | 972-821-3135 | — | 9124 UNION STREET | GLENDALE | AZ | 85388-1286 | — | — |
| TPA | TPA-55354 | 2026-02-23T05:14:59Z | ROY | — | MILLS | 10-09-1949 | N/A | ···· | UNKNOWN | — | 1396 Union Street | Sacramento | CA | 95803·· | GRP-0407 | NULL |
| TPA | TPA-51262 | 2026-01-10T21:42:44Z | anna | — | freeman | 2005-05-18 | ·UHC-84558-26 | - | NULL | null | ·9520 APACHE BOULEVARD | Nashville | Tennessee | null | GRP-0717·· | — |
| TPA | TPA-53453 | 2026-09-30T10:03:12Z | Jacqueline | I. | ·Williamson | 1953-06-01 | N/A | •••-••-4076 | (399) 691-8034 | null | 1442 CANYON RD·· | Las Vegas·· | NV | 89162 | GRP-3866 | — |
| TPA | TPA-59176 | 2026-08-26T15:21:47Z | DORIS | — | BRADLEY | ·19460801 | NULL | - | - | UNKNOWN | ·158 CEDAR LN | Orlando | FL | UNKNOWN | — | null |
| TPA | TPA-51137 | 2026-05-07T13:22:02Z | Nathan | — | McCoy | Dec 6, 1970 | UNKNOWN | UNKNOWN | +1 826 345 5424 | N/A | ·77 SUNSET BLVD | Tampa | ·fl | 33686 | GRP-1872 | - |
| TPA | TPA-58018 | 2026-03-20T22:08:20Z | SANTIAGO | — | WARREN | 10/01/76 | — | — | - | SANTIAGO.WARREN@PROTON.ME | 542 Harbor Boulevard Apt 5 | Mesa | AZ | 85248 | — | CHOICE-PLUS-PPO |
| TPA | TPA-62178 | 2026-08-29T14:45:13Z | Fatima | ···· | Warren | 1943-01-18 | - | ···· | — | — | 9247 OAK STREET | Minneapolis | MN | 55453 | - | N/A |
| TPA | TPA-53838 | 2026-06-02T08:56:05Z | NATHAN | — | ROSE | May 5, 1964 | UNKNOWN | UNKNOWN | — | null | ·439 Baseline Road | Denver | CO·· | 80269 | null | N/A |
| TPA | TPA-55689 | 2026-04-03T21:12:38Z | Pamela | H | Collins | 9/3/1942 | UNKNOWN | •••-••-1544 | — | pamela.collins@yahoo.com | 1992 MEADOW LN | MESA | AZ | 85242 | N/A | ···· |
| TPA | TPA-55412 | 2026-05-20T03:42:26Z | Christopher | — | Rivera | 1982-06-16 | — | •••-••-4981 | — | - | null | - | null | — | - | NULL |
| TPA | TPA-54080 | 2026-05-31T22:41:11Z | Ethan | — | ·Dixon | 14-11-1987 | N/A | — | — | null | 7408 Desert Sky Blvd | Seattle | Washington | 98143 | GRP-7479 | NAVIGATE-HMO |
| TPA | TPA-51174 | 2026-10-04T04:23:44Z | Chris | — | Fox | 19500428 | - | - | NULL | CHRISTOPHER.FOX14@ICLOUD.COM | 3691 Hillcrest Road | ATLANTA | GA | 30320 | GRP-4425 | - |
| TPA | TPA-61153 | 2026-06-12T07:50:47Z | Alan | X | Wheeler | 1941-03-09 | — | ·· | NULL | UNKNOWN | — | — | N/A | null | NULL | ·NULL |
| TPA | TPA-61120 | 2026-08-11T11:00:55Z | Reed | — | Ronald | 7/28/1957 | null·· | — | NULL·· | — | — | null | NULL | null | GRP-9916 | N/A |
| TPA | TPA-51227 | 2026-09-06T04:42:46Z | JOSEPH | ···· | ·JORDAN | 1945-09-27 | UNKNOWN | •••-••-5298 | — | null | null | N/A | — | null | GRP-3983 | — |
| TPA | TPA-59892 | 2026-05-14T07:48:22Z | helen | U | wylliams | 1978-04-25·· | — | - | 381.427.1921 | N/A | 1803 BAYSHORE DR | SAN ANTONIO | TX | 78208 | NULL | — |
| TPA | TPA-52331 | 2026-06-12T02:28:37Z | CHRISTINE | ·· | HICKS | 1996-10-24 | NULL·· | — | NULL | — | 4361 Canyon Road | Scottsdale | AZ | 85277·· | NULL | — |
| TPA | TPA-62494 | 2026-05-25T04:50:10Z | Beverly | ·· | Ross | 26-07-1960 | null | — | 3396899358 | UNKNOWN | ·8373 HILLCREST ROAD | Eden Prairie | MN | 55370 | null | — |
| TPA | TPA-59146 | 2026-03-24T17:41:12Z | JACOB | — | JENSEN | 19420119 | UHC-74692-41 | — | — | jacob.jensen@outlook.com | 5608 Meadow Lane | DENVER | CO | 80260-4622 | — | — |
| TPA | TPA-50231 | 2026-06-18T00:50:04Z | Martha | A | Martinez | 1965-11-09 | UHC7158561 | •••-••-6977 | NULL | ·· | 4824 Maple Ave | Scottsdale | AZ | 85261 | GRP-5586 | NULL |
| TPA | TPA-57818 | 2026-01-22T13:01:05Z | Brandon | I. | Bell | ·12/08/55 | N/A | — | (925) 767-8922 | ···· | — | NULL | — | N/A | - | NAVIGATE-HMO |
| TPA | TPA-61574 | 2026-04-09T09:17:48Z | ANNA | — | PAYNE·· | 11/27/1966 | null | N/A | — | — | 3257 Market St #795 | Austin | TX | 78786·· | - | — |
| TPA | TPA-62865 | 2026-06-12T14:25:42Z | Wood, Roy | — | — | 1950-08-01 | — | N/A | 765-575-4581 | — | 5991 Church St #616 | Sacramento | CA | 95881 | — | UNKNOWN |
| TPA | TPA-57271 | 2026-09-30T21:08:18Z | Ronald | — | Rojas | 1943-10-01 | N/A | — | ·- | N/A | 6395 Valley View Dr | Miami | ·FL | 33199 | GRP-0179 | NULL |
| TPA | TPA-50869 | 2026-07-31T03:14:54Z | Arthur | M | Grant·· | 23-10-1960 | N/A | N/A | UNKNOWN | ·UNKNOWN | 1067 Pine Drive | MIAMI | FL | 33114 | — | — |
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.744Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty