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-60542 | 2026-04-09T21:44:18Z | TYLER | — | EDWARDS | 1988-03-04 | NULL | •••-••-2479 | 8425081422 | TYLER.EDWARDS20@HOTMAIL.COM | 8005 Church Street | Los Angeles | CA | UNKNOWN | GRP-6863 | — |
| TPA | TPA-54907 | 2026-10-15T18:31:16Z | mark | P. | kennedy | 2004-06-24 | — | N/A | null | — | 8236 Main Street | Jacksonville·· | FL | 32202 | NULL | MEDICARE-ADV-A |
| TPA | TPA-61069 | 2026-02-16T23:53:47Z | scott | — | knight | Apr 1, 1964 | — | NULL | UNKNOWN | — | 5464 Oak St | Miami | FL | 33131 | NULL | NULL |
| TPA | TPA-53174 | 2026-06-09T13:54:50Z | Marilyn | D | Coleman | 1958-03-25 | UNKNOWN | — | 13624793359·· | — | 1474 Mountain View Dr | Glendale | AZ | 85341 | — | N/A |
| TPA | TPA-55405 | 2026-09-22T00:01:52Z | Jeremy | — | Alvarado | 1991-12-01 | — | •••-••-0173 | 5136052825 | ·- | 8217 Spring St | Austin | TX | — | — | MEDICARE-ADV-B |
| TPA | TPA-50230 | 2026-01-17T12:25:24Z | George | — | Nichols | 08/10/1992 | - | •••-••-1319 | — | george.nichols91@aol.com | 6925 Harbor Boulevard | Columbus | OH | 43234 | GRP-8811 | SELECT-EPO |
| TPA | TPA-52338 | 2026-04-14T15:44:29Z | ·Amy | — | Washngton | 1963-07-27 | UHC-41659-76 | •••-••-8543 | - | NULL·· | 8281 MOUNTAIN VIEW DRIVE | Fresno | CA | 93710 | - | SELECT-EPO |
| TPA | TPA-52226 | 2026-10-09T12:47:12Z | Jacobs, Nathan | — | — | Jul 4, 1946·· | NULL | UNKNOWN | null | nathan.jacobs@aol.com | 3405 Pine Dr | Seattle | wa | 98114 | N/A | UNKNOWN |
| TPA | TPA-58331 | 2026-10-04T20:01:59Z | ETHAN | — | PERRY | 06/27/07 | uhc-68803-96 | — | - | ·· | 124 PARK PL | Eden Prairie | MN | 55357-8559 | N/A·· | ·· |
| TPA | TPA-53194 | 2026-04-08T08:01:47Z | HEATHER | K | ARNOLD | 1939-10-06 | UHC-93459-97 | •••-••-8907 | — | heather.arnold49@icloud.com | N/A | — | N/A | UNKNOWN | GRP-6532·· | NAVIGATE-HMO |
| TPA | TPA-54236 | 2026-03-27T11:39:26Z | Megan | — | Reed | 2005-11-11 | null | NULL | NULL | — | 8402 MESA DRIVE #666 | Sacramento | CA | 95812·· | GRP-1069 | — |
| TPA | TPA-53283 | 2026-08-28T09:41:48Z | MEGAN | — | RIVERA | 12/11/1971 | - | N/A | — | megan.rivera@yahoo.com | 4402 Elm Street | San Antonio | TX | null | null | UNKNOWN |
| TPA | TPA-61708 | 2026-05-03T06:40:30Z | THOMAS | — | SIMS | ·1971-03-19 | — | N/A | 9817131418 | N/A | 4750 GRAND AVE | Orlando | FL | 32898 | GRP-7811 | null |
| TPA | TPA-64083 | 2026-01-15T15:05:50Z | ralph | W.·· | wood | 19-08-1959 | - | •••-••-0275 | UNKNOWN | UNKNOWN | 5440 Lake View Rd | Charlotte | NC | 28250 | N/A | — |
| TPA | TPA-61601 | 2026-07-06T16:33:59Z | Aan | — | Greene | 1943-11-23 | null | •••-••-5713 | 539.733.1749 | — | 9748 OAK ST | COLUMBUS | OH | 43243 | UNKNOWN | MEDICARE-ADV-A |
| TPA | TPA-58389 | 2026-01-28T12:15:16Z | Mrk | — | Greene | 1991-10-25 | N/A | — | 2454801147 | NULL | — | UNKNOWN | NULL·· | — | — | UNKNOWN |
| TPA | TPA-58323 | 2026-04-10T07:04:30Z | Larry·· | ·· | Chapman | 1981-11-16 | - | •••-••-1964 | — | UNKNOWN | 3349 Union St | EDEN PRAIRIE | MN | 55390-1001 | N/A | — |
| TPA | TPA-56219 | 2026-04-20T07:03:52Z | Christian | U. | — | ·3/18/1942 | N/A·· | •••-••-3148 | N/A | — | NULL | UNKNOWN | NULL | NULL | ·· | NAVIGATE-HMO |
| TPA | TPA-56952 | 2026-08-24T20:37:44Z | Doris | Y. | Meyer | May 19, 1961 | — | UNKNOWN | - | ·- | UNKNOWN | UNKNOWN | - | N/A | N/A·· | — |
| TPA | TPA-50992 | 2026-04-17T06:16:36Z | Gibson | ···· | Gabriel | Apr 8, 1993 | NULL | •••-••-9278 | NULL·· | gabriel.gibson14@yahoo.com | 5197 CEDAR LANE | NASHVILLE | TN | 37295 | - | UNKNOWN |
| TPA | TPA-55232 | 2026-04-04T19:08:07Z | Kelly | — | Alvarado | 9/15/1995 | - | null | 4482819586 | — | 2379 Canyon Rd | Jacksonville | FL | 32276 | - | — |
| TPA | TPA-61935 | 2026-02-03T01:40:26Z | ·Paul | — | Broooks | 1980-03-07 | UNKNOWN | •••-••-3787 | 4933946646 | null | 2313 Indian School Rd | Plano | TX | 75003 | N/A | - |
| TPA | TPA-51064 | 2026-10-11T04:51:27Z | CHARLES·· | — | CRAWFORD | Jan 1, 1956 | UHC-28011-91 | •••-••-1232 | — | ·· | ·733 Willow Court | SEATTLE | WA | 98168 | UNKNOWN | null |
| TPA | TPA-62482 | 2026-02-25T09:38:42Z | Gerald | — | Parker | 1970-07-24 | ·· | — | - | NULL | 7751 MESA DRIVE | Chandler | ·AZ | 85228 | ·GRP-1641 | NULL |
| TPA | TPA-50029 | 2026-03-17T21:22:17Z | Denise | E | Elliott | ·1948-09-26 | — | •••-••-7764 | - | — | 7529 CAMELBACK RD | ·Austin | TX | ·78795 | ···· | — |
| TPA | TPA-52977 | 2026-05-29T22:38:25Z | ROBERT | — | MURPHY·· | 1999-04-24 | NULL | NULL | N/A | ·NULL | 7979 Apache Boulevard | Charlotte | ·NC | 28258 | GRP-1042 | — |
| TPA | TPA-52844 | 2026-10-05T19:22:32Z | lara | — | ryan | 1993-01-22 | N/A | UNKNOWN | — | NULL | N/A | - | - | - | — | - |
| TPA | TPA-53035 | 2026-06-09T06:51:58Z | Samuel | — | Williamson | 2003-01-11 | NULL | NULL | UNKNOWN | - | 8488 VALLEY VIEW DRIVE | Austin | TX | 78798 | GRP-8474 | N/A |
| TPA | TPA-51070 | 2026-04-05T08:38:57Z | Douglas | — | Morgan | 1974-01-02 | - | •••-••-4086 | +1 778 390 0003 | - | 4328 Grand Ave·· | Chandler | Arizona | 85207 | GRP-1978 | - |
| TPA | TPA-53713 | 2026-08-12T03:41:08Z | Roy | — | Mendez | 1937-06-03 | N/A | — | (773) 220-6513 | - | N/A | null·· | - | null | GRP-4999 | ·null |
| TPA | TPA-63727 | 2026-01-31T22:25:47Z | Yuki | S. | Rios | ·09/05/1995 | — | null | UNKNOWN | — | ·16 Lake View Rd | Tampa | FL | 33645 | NULL | — |
| TPA | TPA-52039 | 2026-07-27T21:28:42Z | Le, Lori | — | — | 1962-06-12 | UNKNOWN | — | null | UNKNOWN | 7963 Jefferson Avenue | MINNEAPOLIS | MN | 55485·· | GRP-8823 | SELECT-EPO |
| TPA | TPA-50782 | 2026-07-25T22:30:00Z | hiroshi | B | coleman | 06-04-1985 | null | ·UNKNOWN | - | null | 3352 CENTRAL AVENUE | San Antonio | TX | NULL·· | N/A | UNKNOWN |
| TPA | TPA-63153 | 2026-09-26T09:15:45Z | JULIA | — | ·CHAPMAN | 26-09-2008 | null | null | - | — | — | — | - | NULL·· | GRP-8892 | null |
| TPA | TPA-58055 | 2026-06-11T18:48:28Z | Sharon | K | Mendoza | 11/23/1971 | N/A | - | — | sharon.mendoza@outlook.com | 8627 Willow Ct | Jacksonville | FL | 32294 | NULL | OPTIONS-PPO |
| TPA | TPA-54679 | 2026-03-12T01:32:14Z | CAROLYN | — | KING | 13-07-1957 | — | ·N/A | — | UNKNOWN | 2064 PARK PL | San Antonio·· | TX | 78271 | UNKNOWN | N/A |
| TPA | TPA-56125 | 2026-01-10T19:39:20Z | Natalie | — | Park | 04/25/04 | — | — | UNKNOWN | — | 3479 Ocean Avenue | Gilbert | Arizona | 85240-0372 | null | UNKNOWN |
| TPA | TPA-58691 | 2026-04-15T03:56:23Z | Charles | — | Padilla | 1948-10-24 | N/A | •••-••-0953 | — | — | 8669 Highland Ave | Tempe | AZ | — | GRP-1498 | NAVIGATE-HMO |
| TPA | TPA-54373 | 2026-08-18T19:24:56Z | PAMELA | — | ·HICKS | 1990-09-04 | UHC-20829-55 | •••-••-2561 | — | NULL | 6514 Mountain View Dr | Plano | TX | 75056 | — | N/A |
| TPA | TPA-60347 | 2026-06-24T16:12:10Z | Alan | — | Simmons·· | 1995-04-25 | UNKNOWN | NULL | (414) 236-1332 | N/A·· | 4788 Indian School Rd | Gilbert | AZ | 85260 | GRP-7414·· | — |
| TPA | TPA-52410 | 2026-01-19T13:19:01Z | ROGER·· | — | PORTER | 10-03-1992 | UHC6116762 | NULL | 345-727-6244 | roger.porter@gmail.com | 5095 Ridge Rd | Chandler | AZ | 85256 | null·· | — |
| TPA | TPA-59168 | 2026-04-21T16:49:15Z | JONATHAN | — | SANHEZ | ·1941-08-06 | — | •••-••-5591 | null | ·jonathan.sanchez68@aol.com | 6808 Lake View Road | Tucson | Arizona | 85788 | GRP-2167 | MEDICARE-ADV-B |
| TPA | TPA-55699 | 2026-01-14T22:17:11Z | Sandra | — | ·Ngyen | ·1962-09-03 | — | •••-••-9585 | ·N/A | N/A | 7065 SUNSET BLVD | Columbus | OH | 43220 | - | - |
| TPA | TPA-56220 | 2026-09-05T11:43:30Z | ·CHRISTIAN | U·· | HUGHES | 03/18/1943 | - | — | 607-472-8764 | — | 9665 Willow Court | Phoenix | AZ | 85077 | GRP-6016 | N/A |
| TPA | TPA-56023 | 2026-05-24T08:28:49Z | Jacqueline | — | Wagner | 19380124 | UHC-77881-56 | •••-••-7317 | N/A | UNKNOWN | 4420 Sage Ct Apt 33 | MIAMI | fl | null | NULL | - |
| TPA | TPA-57305 | 2026-03-26T21:07:16Z | NOAH | — | TURNER | 28-03-1949 | - | UNKNOWN | ·+1 941 289 8050 | noah.turner30@aol.com | 441 Palm Dr | Chandler | AZ | 85287 | null | core-hmo |
| TPA | TPA-60638 | 2026-04-20T00:24:40Z | Walter | — | Nelson | 2000-07-28·· | — | •••-••-3277 | — | UNKNOWN·· | 4332 Oak Street | Phoenix | AZ | 85010 | GRP-0717 | NULL |
| TPA | TPA-52590 | 2026-02-02T01:10:33Z | SARA | — | KYNG | 1996-12-15 | UHC-68504-05 | — | UNKNOWN | — | - | N/A | - | NULL | - | UNKNOWN |
| TPA | TPA-51144 | 2026-02-06T15:11:59Z | Samuel | — | Gordon | 1999-08-21 | ···· | •••-••-4028 | 18877886818 | — | 906 CHURCH ST | San Antonio | TX | 78212 | ·NULL | N/A |
| TPA | TPA-58155 | 2026-03-22T15:31:15Z | GERALD·· | — | ORTEGA | 1979-09-05 | UNKNOWN·· | null | ·12786948758 | — | 8711 CEDAR LN | Columbus | OH | 43291 | — | — |
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:36.705Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty