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-56263 | 2026-02-11T18:39:25Z | Gregory | F | Jimenez | ·1938-02-23 | UNKNOWN | — | 6390165 | NULL | 8862 SUNSET BOULEVARD | Plano | TX | 75004 | N/A | — |
| TPA | TPA-59625 | 2026-04-22T21:13:13Z | VINCENT | ·· | HART | 19590715 | ···· | null | null | - | 2540 MEADOW LN Apt 26 | Nashville | TN | 37236 | GRP-9030 | — |
| TPA | TPA-58673 | 2026-07-02T12:28:58Z | Karen | ···· | Sanchez | 25-08-1979 | UHC0966419·· | N/A | 9597070008 | karen.sanchez@gmail.com | 8145 Main St | Plano | Texas | 75074 | — | — |
| TPA | TPA-54217 | 2026-06-19T00:12:51Z | Alan | — | Ramos·· | 09/24/1971 | - | N/A | +1 979 342 6863 | alan.ramos88@hotmail.com | 34 Washington Street | SEATTLE | WA | ·98132 | GRP-4465 | N/A |
| TPA | TPA-58619 | 2026-02-26T10:50:48Z | JACOB·· | — | MITCHELL | 13-05-2001 | UHC-92974-06 | ·null | - | jacob.mitchell39@yahoo.com | 7326 Apache Blvd | Columbus | OH·· | 43287·· | UNKNOWN | UNKNOWN |
| TPA | TPA-56463 | 2026-01-16T21:52:37Z | JECOB | — | WATKINS | 19480123 | — | null | 5231742·· | — | 1221 Church Street | Fresno | California | 93719 | GRP-2948 | — |
| TPA | TPA-52746 | 2026-10-10T22:49:52Z | — | — | — | 1953-11-17 | — | NULL | — | ARJUN.WANG@HOTMAIL.COM | UNKNOWN | UNKNOWN | — | — | GRP-9435·· | — |
| TPA | TPA-63333 | 2026-04-07T06:24:29Z | Larry | — | Moreno | 19590427 | N/A | UNKNOWN | 319-449-1091 | N/A | 6676 Oak Street | Tempe | Arizona | 85271 | GRP-7637 | — |
| TPA | TPA-60650 | 2026-04-13T09:36:58Z | John | — | Weber | 5/24/1948 | — | — | 665.659.7999 | john.weber47@gmail.com | ·4227 WASHINGTON ST | Houston·· | TX | 77026-5783 | GRP-9307 | N/A |
| TPA | TPA-52542 | 2026-01-04T20:02:06Z | Dennis | ···· | Harris | 1939-08-08·· | — | UNKNOWN | — | null | ·5864 MAIN STREET | San Antonio | TX·· | 78262 | — | NULL |
| TPA | TPA-56868 | 2026-04-07T20:25:01Z | Christina | — | Turner | 2/6/1980 | NULL | — | UNKNOWN | - | 4965 Meadow Lane | Tucson | AZ | 85710 | — | — |
| TPA | TPA-58374 | 2026-10-02T19:54:49Z | Carl | — | Marshall | 07/22/1963 | — | •••-••-6678 | 6894527111 | N/A | 1078 Forest Ave | Gilbert | ·AZ | 85246 | null | — |
| TPA | TPA-64457 | 2026-08-21T13:16:22Z | Harold | ·· | Andarson | 1979-02-28 | N/A | NULL | (855) 310-4739 | — | 9783 Market Street #413 | Chandler | AZ | ·85276 | NULL·· | — |
| TPA | TPA-57731 | 2026-08-20T03:37:12Z | Wlilie | — | Woods | 1981-12-09 | — | N/A | — | — | 9597 Main Street | AUSTIN | TX·· | 78752 | NULL·· | NULL |
| TPA | TPA-58446 | 2026-10-06T22:48:40Z | Roger | — | Palmer | ·1996-09-07 | N/A | UNKNOWN | UNKNOWN | — | 8924 SAGE COURT | Nashville | TN | 37251 | GRP-1804 | NULL |
| TPA | TPA-51249 | 2026-09-28T19:37:37Z | Grace | V | Salazar | 1946-06-19 | — | - | 655-996-4275 | UNKNOWN | 6117 MOUNTAIN VIEW DRIVE·· | Glendale | Arizona | 85394-0472 | — | MEDICARE-ADV-A |
| TPA | TPA-52319 | 2026-03-13T15:24:10Z | Lane, Dennis | — | — | 2006-01-24 | — | •••-••-0193 | 3203257 | — | 5757 OAK STREET | LAS VEGAS | NV | 89112 | — | NULL |
| TPA | TPA-54105 | 2026-05-13T10:32:10Z | Christian | — | Rojas | 2002-10-10·· | UHC-82285-28 | — | +1 773 992 0381 | UNKNOWN | 2152 Oak St | PHOENIX | AZ | N/A·· | — | NAVIGATE-HMO |
| TPA | TPA-50653 | 2026-03-04T04:30:10Z | Dorothy·· | — | Ray | ·1980-07-15 | NULL | NULL | ·9869724173 | — | 802 Church St·· | San Antonio | TX·· | 78250 | GRP-6426 | CHOICE-PLUS-PPO |
| TPA | TPA-62718 | 2026-08-05T02:44:40Z | CHRISTINA | ·· | GONZALEZ | 1968-01-23 | UHC-26758-34 | — | NULL | N/A | 87 Sage Court | JACKSONVILLE | FL·· | 32218 | - | N/A |
| TPA | TPA-56253 | 2026-04-15T20:03:33Z | Mason | — | — | 1938-11-23 | NULL | - | (951) 218-5992 | - | 3902 Apache Blvd | MIAMI | FL | 33146 | NULL | MEDICARE-ADV-B |
| TPA | TPA-60634 | 2026-09-15T20:46:05Z | Ann | — | Sims | 1960-10-04 | ···· | •••-••-0663 | - | — | 7084 Elm St | Nashville | TN | 37232-7892 | ·NULL | UNKNOWN |
| TPA | TPA-63157 | 2026-07-04T12:55:08Z | Henry | — | Dominguez | 2000-08-01·· | — | — | — | henry.dominguez@gmail.com | 9538 MESA DRIVE #521 | Tampa | ·FL | ·33662 | GRP-8465·· | NAVIGATE-HMO |
| TPA | TPA-61062 | 2026-09-05T13:40:40Z | Andrea | I | Payne | 12/9/2008 | — | •••-••-9732 | — | N/A | 185 OCEAN AVE | Los Angeles | ca | 90049 | — | MEDICARE-ADV-B |
| TPA | TPA-50229 | 2026-04-05T12:04:31Z | Carolyn | — | Wilson | 1948-05-14 | - | •••-••-3424 | 3516852977·· | carolyn.wilson86@gmail.com | 2995 Pine Dr | CHARLOTTE | ·NC | 28254-7178 | GRP-0313 | — |
| TPA | TPA-63035 | 2026-03-18T16:29:55Z | Carol | W. | Turner | 1988-06-04 | UHC-66102-25 | NULL | (867) 437-6699 | — | 834 Highland Ave | Eden Prairie | MN | 55325 | null | - |
| TPA | TPA-53318 | 2026-05-26T05:20:20Z | Daniel | — | Wong | 1981-07-10 | -·· | - | null | daniel.wong@proton.me | 4430 MEADOW LN | Jacksonville | FL | 32235 | UNKNOWN | — |
| TPA | TPA-61529 | 2026-04-01T05:21:37Z | Kally | — | Woods | 19550801 | — | null | ·· | null | 422 Willow Ct | PLANO | tx | 75091 | null | — |
| TPA | TPA-51266 | 2026-06-14T02:34:51Z | alexis | G | ·porter | Jan 26, 1963 | — | NULL | (602) 614-1920·· | ·alexis.porter@gmail.com | 5157 Hillcrest Road | Sacramento | CA | 95803 | UNKNOWN | MEDICARE-ADV-A |
| TPA | TPA-51659 | 2026-09-03T17:21:56Z | LUIS | ···· | HGUHES | 1987-03-13 | - | •••-••-7822 | UNKNOWN | N/A | 8374 Sunset Boulevard | Seattle | WA | 98119-3013 | null·· | UNKNOWN |
| TPA | TPA-55050 | 2026-04-17T05:07:22Z | Anthony·· | — | Guerrero·· | 11/10/72 | null | — | 262-292-0400 | N/A | 6030 Main St | AUSTIN | TX | 78733 | GRP-2909 | N/A·· |
| TPA | TPA-55296 | 2026-05-13T04:19:13Z | Michael | ·· | ·Johnston | 2000-12-13·· | UHC-29125-14 | •••-••-2387 | (851) 811-6559 | — | 590 Bayshore Dr | ·COLUMBUS | OH | 43239 | GRP-5660 | NULL |
| TPA | TPA-55847 | 2026-05-10T02:16:10Z | JUDITH | — | HENRY | 07/02/68 | — | N/A | (941) 241-8220 | ·judith.henry69@proton.me | 7256 Willow Ct | Fresno | CA | 93788 | null | UNKNOWN |
| TPA | TPA-59408 | 2026-03-24T00:01:06Z | Santiago | L·· | Green | Apr 2, 1998 | null | •••-••-7315 | (813) 882-4526 | UNKNOWN | 6800 CANYON ROAD | Columbus | OH | 43216 | — | UNKNOWN |
| TPA | TPA-60000 | 2026-08-01T05:28:31Z | gregory | G·· | le | 1939-12-05 | UHC-77243-54 | UNKNOWN | 9158164062 | null | 3244 SPRING STREET | SAN DIEGO | CA | ···· | GRP-0662 | N/A |
| TPA | TPA-53406 | 2026-06-18T14:29:25Z | Rachel | ·· | Hart | 09/02/08 | — | — | — | — | - | — | ···· | UNKNOWN | — | ·MEDICARE-ADV-A |
| TPA | TPA-60031 | 2026-09-03T14:11:21Z | emily | — | dominguez | 1979-01-14 | ·· | N/A | 5073243129 | — | 1077 River Rd | San Diego | CA | 92120 | UNKNOWN | NULL |
| TPA | TPA-58704 | 2026-09-30T03:58:19Z | FRAKN | — | CRAWFORD | 1956-03-28 | N/A | NULL | 2973393821 | FRANK.CRAWFORD@OUTLOOK.COM | 964 Ocean Ave | Jacksonville | ·FL | null | GRP-9321 | UNKNOWN |
| TPA | TPA-57050 | 2026-03-08T06:43:17Z | Raymond | — | Duncan | 1986-06-13 | N/A | — | — | RAYMOND.DUNCAN64@OUTLOOK.COM | 6849 Valley View Dr | ·Miami | FL | 33181 | GRP-5757 | NULL |
| TPA | TPA-59305 | 2026-06-24T08:37:54Z | Elijah | — | Carlsson | 1990-07-25 | — | null | null | elijah.carlson@outlook.com | 7199 Broadway | MIAMI | FL | 33181 | - | — |
| TPA | TPA-62129 | 2026-07-27T10:02:31Z | JACK | B | LAWRENCE | 1987-04-27 | ·· | NULL | 4852942740 | — | ·2298 Harbor Boulevard | MIAMI | FL | ·33157 | — | NULL |
| TPA | TPA-52427 | 2026-01-25T15:33:27Z | tony | — | mason | 08/27/59 | UHC-71486-08 | NULL | - | N/A | 2698 Jefferson Ave | Gilbert | AZ | 85266 | N/A | - |
| TPA | TPA-58268 | 2026-01-17T07:52:31Z | ALEXIS | — | JIMENEZ | 19710920 | - | NULL | NULL·· | alexis.jimenez13@yahoo.com | 1687 Desert Sky Blvd | Miami | FL | 33106 | GRP-0637 | — |
| TPA | TPA-52520 | 2026-04-16T19:49:49Z | Sandra | — | Baker | 1972-10-10 | - | — | N/A | — | — | — | — | null | N/A | ·- |
| TPA | TPA-51398 | 2026-01-24T03:19:37Z | wood | — | gerald | 1992-07-05 | NULL | null | N/A | ·UNKNOWN | 3824 Harbor Boulevard | Jacksonville | FL | 32263 | N/A | N/A |
| TPA | TPA-55057 | 2026-04-17T23:46:21Z | LUIS | ·· | ORTIZ | 1951-11-28 | N/A | — | — | — | — | — | — | UNKNOWN | GRP-2678 | MEDICARE-ADV-A |
| TPA | TPA-56366 | 2026-08-10T13:12:14Z | ronald | — | murray | 19530223 | UHC2172619 | — | NULL | ronald.murray@hotmail.com | 1842 MEADOW LANE | Gilbert | AZ | 85213 | GRP-9044 | OPTIONS-PPO |
| TPA | TPA-52682 | 2026-08-17T21:00:16Z | Dorothy | — | Mejia | 1939-12-02 | - | UNKNOWN | — | — | 8951 PINE DR | AUSTIN | TX | 78738·· | GRP-1691 | NAVIGATE-HMO |
| TPA | TPA-50874 | 2026-02-18T20:25:33Z | FORD | — | ROB | 1954-11-11 | — | — | (265) 433-6271 | — | 9709 Park Pl | Plano | TX·· | 75020 | GRP-3001 | — |
| TPA | TPA-63620 | 2026-07-15T13:25:42Z | Joshua | — | Li | 1966-04-12 | UHC-66537-62 | UNKNOWN | — | NULL | 1294 Ridge Rd | Atlanta | GA | 30330 | — | — |
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:38.490Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty