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-54847 | 2026-02-18T06:48:26Z | ·Garcia, Luis | ·· | — | 1978-11-12 | — | ·UNKNOWN | - | — | 8262 Main Street | Scottsdale | AZ | 85296 | NULL | NAVIGATE-HMO |
| TPA | TPA-56656 | 2026-03-05T02:58:59Z | Grace | — | Jenkins | 1998-10-08 | N/A | - | - | UNKNOWN | 4259 Sage Ct | Tampa | Florida | ·33608-2188 | — | — |
| TPA | TPA-64432 | 2026-10-03T06:38:14Z | RANDY | — | RILEY | 1975-07-01 | UHC-06936-55 | null | (325) 510-5808 | randy.riley@icloud.com | 2611 Jefferson Ave | PLANO | TX | 75054 | ·· | ···· |
| TPA | TPA-59460 | 2026-02-11T08:35:32Z | Anna | — | Greene | 1986-02-14 | — | •••-••-8419 | 987-521-7391 | — | 9359 Lake View Road | DENVER | CO | 80222 | - | null |
| TPA | TPA-50078 | 2026-02-14T03:05:00Z | Jean | — | Torres | 1997-05-05 | - | ·N/A | — | — | 2059 CAMELBACK ROAD | Houston | TX | 77025 | — | CHOICE-PLUS-PPO |
| TPA | TPA-60445 | 2026-07-22T00:41:52Z | Fatima | — | Gardner | 1950-06-01 | null | •••-••-7201 | 234.690.0062 | UNKNOWN | 7090 Ocean Avenue | Glendale | AZ | 85318-6885 | NULL | NULL |
| TPA | TPA-58204 | 2026-04-08T06:08:46Z | CHARLES | — | JAMES | 01/01/85 | null | - | - | NULL | ·6831 Desert Sky Blvd | Miami | FL | 33107 | GRP-0582 | N/A |
| TPA | TPA-50107 | 2026-05-15T22:50:52Z | Shirley | — | Reynolds | 1973-09-12 | UNKNOWN·· | - | — | null | 6472 Desert Sky Blvd | Houston | TX | 77024 | - | NAVIGATE-HMO |
| TPA | TPA-51494 | 2026-09-26T19:03:03Z | Patel, Ryan | C | — | 2008-04-15 | ·NULL | null | (506) 868-6599 | — | null | — | ···· | — | -·· | null |
| TPA | TPA-59417 | 2026-03-31T14:31:06Z | Stephen | — | Jimenez | 2006-09-27 | — | — | +1 452 510 0958 | NULL | 3249 BAYSHORE DRIVE #503·· | Denver | ·CO | 80254 | - | null |
| TPA | TPA-51066 | 2026-05-03T21:39:20Z | Olivia·· | — | Hunt | 1987-09-16 | N/A | N/A | 5355722990 | olivia.hunt37@hotmail.com | 4796 Hillcrest Road | ATLANTA | GA | 30302 | ·NULL | NULL |
| TPA | TPA-64106 | 2026-03-19T15:11:52Z | Russeell | ···· | Scott | 2006-07-06 | - | UNKNOWN | 5822157597 | null | NULL | — | ·UNKNOWN | UNKNOWN | — | — |
| TPA | TPA-59315 | 2026-10-17T09:45:01Z | Le, Willie | — | ·· | 1969-09-17 | UHC-73240-85 | •••-••-2921 | — | willie.le25@icloud.com | 6908 OAK ST | Sacramento | CA | NULL | — | — |
| TPA | TPA-60652 | 2026-01-26T19:33:49Z | HENRY | W | DELGADO | 1981-05-26 | — | •••-••-1454 | - | - | 5525 Oak Street·· | Minneapolis | MN | 55456 | — | — |
| TPA | TPA-52250 | 2026-02-09T10:16:11Z | RICHARD | — | SILVA | 2000-07-04 | UNKNOWN | NULL | UNKNOWN | richard.silva@aol.com·· | 1302 Meadow Ln·· | San Diego | CA | 92143 | null | null |
| TPA | TPA-63804 | 2026-01-03T17:51:05Z | Martha | — | Rice | ·1956-08-23 | null | — | null | null | 6052 Desert Sky Blvd | Tampa | FL | null | N/A | MEDICARE-ADV-B |
| TPA | TPA-58938 | 2026-10-16T21:39:31Z | diana | — | park | 1996-05-28 | UHC-17088-19 | null | (981) 704-2882 | UNKNOWN | 6071 River Rd | FRESNO | CA | 93746 | UNKNOWN | CHOICE-PLUS-PPO |
| TPA | TPA-57670 | 2026-08-08T05:28:17Z | MEGAN | — | HOFFMAN | 1961-11-17 | NULL | NULL | — | null | 7890 Maple Ave | Denver | CO | 80229 | GRP-8420 | — |
| TPA | TPA-53853 | 2026-04-02T04:06:38Z | ·Bruce | — | ·Fowler | May 8, 1938 | ·· | - | 3897636212 | N/A | 7225 Lincoln Way | Columbus | OH | 43213 | null·· | - |
| TPA | TPA-62037 | 2026-09-11T11:08:22Z | Stephen | — | Carter | 1945-09-16 | ·· | — | ·478.226.8064 | - | - | N/A | - | — | - | MEDICARE-ADV-B |
| TPA | TPA-60624 | 2026-07-22T22:13:13Z | Roy | ·· | Harvey | 09/04/05 | UHC-56060-86 | •••-••-7866 | 411-224-6275·· | - | 2684 Mountain View Drive | Gilbert | AZ | 85265·· | — | — |
| TPA | TPA-58627 | 2026-04-07T13:14:42Z | Christine | — | Fuller | 1976-04-25 | UHC-04747-15 | •••-••-0807 | UNKNOWN | null | 9726 VALLEY VIEW DRIVE Apt 12 | Glendale | AZ | 85323 | GRP-3402 | null |
| TPA | TPA-51971 | 2026-02-10T00:04:57Z | heather | O | griffin | ·1987-08-11 | — | — | 824.822.9092 | heather.griffin@yahoo.com | 8521 Palm Drive | Jacksonville | FL | 32278 | GRP-1193 | N/A |
| TPA | TPA-54034 | 2026-07-19T15:12:33Z | Dennis | ···· | Foster | NULL | UNKNOWN | — | 954-623-0114 | — | 7226 OCEAN AVENUE | JACKSONVILLE | ·FL | 32212-3883 | UNKNOWN | ·N/A |
| TPA | TPA-60092 | 2026-07-10T01:10:46Z | carol | — | pierce | 0201-99-57 | UHC-80359-24 | null | - | — | 7677 Baseline Road Apt 33 | Fresno | CA | 93773 | ·· | N/A |
| TPA | TPA-52540 | 2026-08-20T09:13:20Z | Debra | — | Patel | 1948-01-07 | - | •••-••-3784 | 2388216340 | NULL | 3271 River Road | Orlando | FL | 32835 | GRP-2994 | UNKNOWN |
| TPA | TPA-60241 | 2026-01-13T22:00:10Z | Maria | B | Clark | 1949-12-07 | ·UHC-75430-55 | •••-••-8238 | N/A | UNKNOWN | 8006 Apache Blvd | COLUMBUS | OH | 43289 | - | CORE-HMO |
| TPA | TPA-59608 | 2026-08-30T02:41:54Z | ERIC | — | WALSH | 1948-09-23 | — | UNKNOWN·· | +1 474 953 5319 | - | 2093 Indian School Road | Tucson | ·AZ | 85756-1360 | UNKNOWN | — |
| TPA | TPA-64080 | 2026-07-24T21:10:28Z | ZACHARY | — | RAMOS | 2005-02-23 | null | - | — | zachary.ramos6@icloud.com | NULL | ·null | — | ·· | NULL | NULL |
| TPA | TPA-59144 | 2026-04-03T03:47:25Z | Raymond | — | Munoz·· | 19760513 | UHC-91631-69 | •••-••-6942 | 6806992699 | NULL | 8454 APACHE BLVD | Scottsdale | AZ | 85248-4401 | N/A | N/A |
| TPA | TPA-52726 | 2026-03-29T20:12:08Z | joyce | Y | arnold | 1949-10-04 | null | N/A | — | ···· | 7113 Meadow Ln | Atlanta | GA | 30399 | ·- | N/A |
| TPA | TPA-60336 | 2026-01-17T04:45:12Z | Gabriel | — | Bell | 19761208 | null·· | •••-••-0534 | ·4772846941 | ·GABRIEL.BELL@AOL.COM | 7713 Market St | Tampa | FL | 33634 | GRP-9958 | null |
| TPA | TPA-55842 | 2026-04-14T15:58:41Z | ·Samuel | A. | Rivera | Jul 26, 1988 | — | - | 378-644-1173 | null | 4182 VALLEY VIEW DRIVE | Jacksonville | Florida | 32271 | GRP-2938 | ·· |
| TPA | TPA-51069 | 2026-02-27T03:01:40Z | WEI | W | RUIZ | 06-04-1994 | N/A | •••-••-3325 | 935.721.3360 | UNKNOWN | 5871 Church Street | Columbus | Ohio | 43224 | GRP-2666 | null |
| TPA | TPA-64361 | 2026-01-11T19:00:58Z | Russell | — | Jacobs | 1986-02-10 | UNKNOWN | UNKNOWN | null·· | NULL | 3278 Spring Street | DENVER | CO | 80225 | NULL | — |
| TPA | TPA-51505 | 2026-01-28T00:14:53Z | DENNIS | T. | WEBER | 1990-02-17 | — | UNKNOWN | 271-293-5696 | DENNIS.WEBER@YAHOO.COM | 4987 Camelback Rd·· | Houston | TX | N/A | ·· | NULL |
| TPA | TPA-57047 | 2026-08-13T09:23:32Z | ryan | — | elliott | 1962-07-01 | null | N/A | 8323083910 | RYAN.ELLIOTT37@GMAIL.COM | 5526 Sunset Boulevard Apt 8 | San Antonio | Texas | 78260 | GRP-1983 | NAVIGATE-HMO |
| TPA | TPA-56915 | 2026-03-11T21:15:29Z | Janice | — | Walsh | 09/05/41 | NULL | N/A | - | janice.walsh@icloud.com | 6935 Baseline Road | HOUSTON | TX | 77024 | GRP-3106 | NULL |
| TPA | TPA-61943 | 2026-06-06T15:53:01Z | Powell, Austin·· | ···· | — | 1946-05-25 | — | — | 5194091628 | austin.powell70@proton.me·· | 9114 Indian School Road | Los Angeles | CA | 90006 | — | - |
| TPA | TPA-52968 | 2026-07-15T07:43:27Z | Elliott, Eugene | — | — | 1945-03-11 | UHC-77796-83 | •••-••-4260 | 774.826.9784 | — | ···· | ···· | — | null | — | — |
| TPA | TPA-62595 | 2026-01-07T04:46:46Z | ELLIOTT | — | DAVID·· | 1955-05-20 | — | — | +1 626 529 6430 | ·N/A | 4394 Main Street·· | NASHVILLE | TN | 37200 | null | NAVIGATE-HMO |
| TPA | TPA-58734 | 2026-03-09T07:47:20Z | FRANCES | — | HENRY | 2001-02-07 | UNKNOWN | N/A | 973-446-5938 | — | NULL | NULL | - | N/A | N/A | null·· |
| TPA | TPA-58491 | 2026-08-30T09:50:59Z | kenneth | — | bailey | 05-01-2002 | UNKNOWN | UNKNOWN | (553) 616-7156 | ·- | 203 Camelback Road | PLANO | TX | 75011 | null | navigate-hmo |
| TPA | TPA-55209 | 2026-07-01T01:54:51Z | willie | — | black | 9/22/2001 | — | NULL | — | N/A | UNKNOWN | NULL | null | null | N/A | — |
| TPA | TPA-55308 | 2026-01-05T17:37:59Z | matthew | — | bennett | 06/05/08 | — | — | — | MATTHEW.BENNETT76@ICLOUD.COM | 1050 ELM STREET | Nashville | TN | 37221 | GRP-7314 | SELECT-EPO |
| TPA | TPA-63414 | 2026-08-27T23:05:15Z | Margaret | ·· | Jordan | 1985-06-62 | ···· | N/A | 6437042374 | — | 4851 HARBOR BOULEVARD | Denver·· | ·CO | 80295 | N/A | NULL |
| TPA | TPA-63118 | 2026-02-28T21:28:06Z | rachel | — | lawson·· | Nov 24, 1999 | — | N/A | — | UNKNOWN | 5424 Washington Street | Austin | TX·· | 78740 | — | ·NULL |
| TPA | TPA-64412 | 2026-04-11T11:53:12Z | ·Ben | — | Olson | 1977-02-25 | N/A | NULL | UNKNOWN | benjamin.olson@proton.me | 3921 Lincoln Way | Jacksonville | FL | ·UNKNOWN | — | - |
| TPA | TPA-51828 | 2026-05-16T14:12:11Z | philip | — | nichols | 1988-04-04 | NULL | •••-••-3348 | 6144971756·· | ·philip.nichols20@hotmail.com | 5140 Park Place | San Diego | CA | 92155 | N/A | ·· |
| TPA | TPA-54938 | 2026-05-02T17:03:33Z | EMILY | ···· | ·WALKER | 1957-12-26 | NULL | NULL | - | ·- | 541 Maple Avenue | Austin | TX | 78749-4928 | ·· | - |
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:56.303Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty