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-50571 | 2026-03-02T11:26:09Z | ·Keith | C. | Brooks | 26-03-1986 | N/A | -·· | ·873-518-7339 | — | — | N/A | N/A | NULL·· | GRP-6892 | ·OPTIONS-PPO |
| TPA | TPA-57942 | 2026-05-07T17:01:06Z | GREGRY | N | HENRY | 1975-02-12 | UHC-22017-61 | •••-••-1671 | 488-276-4630 | gregory.henry70@icloud.com | 9087 Broadway | HOUSTON | TX | 77062 | - | MEDICARE-ADV-B |
| TPA | TPA-51743 | 2026-07-13T22:56:52Z | Bell, Martha | — | ···· | ·1965-09-21 | NULL | NULL | NULL | UNKNOWN | 1624 Palm Drive | MESA | AZ | 85222 | — | — |
| TPA | TPA-56005 | 2026-05-17T18:04:06Z | ANN | — | ROGERS | 2/18/2003 | UNKNOWN | - | 13032981285 | — | 9630 Spring St | Eden Prairie | Minnesota | 55310 | N/A | OPTIONS-PPO |
| TPA | TPA-54298 | 2026-08-02T04:19:06Z | SCOTT | D | MORRIS | 1976-05-10·· | NULL | — | — | scott.morris80@hotmail.com | 7172 Central Ave | COLUMBUS | OH | 43223 | ·null | — |
| TPA | TPA-64416 | 2026-04-10T04:42:04Z | Frances | — | Meyer | 08-11-1984 | — | •••-••-2672 | null | - | 4342 Main Street | Phoenix | AZ | 85091 | — | ·CHOICE-PLUS-PPO |
| TPA | TPA-55687 | 2026-03-28T13:36:15Z | heather | — | chapman | 12/2/1981 | UNKNOWN | null | - | — | 7036 Park Place | Minneapolis | MN | 55418 | — | NULL |
| TPA | TPA-54510 | 2026-02-24T07:10:46Z | Diego | — | Ferguson | 12/11/1975 | — | null | — | NULL | 3780 Market St | Phoenix | AZ | 85060·· | UNKNOWN | CHOICE-PLUS-PPO |
| TPA | TPA-55450 | 2026-02-11T18:27:06Z | Steven | — | Mason | 1965-11-06 | - | UNKNOWN | UNKNOWN | - | 6665 Pine Dr Apt 33 | MIAMI | FL | ·33184 | GRP-6840 | select-epo |
| TPA | TPA-58866 | 2026-09-28T13:51:42Z | ·Roger C. | — | Wang | 1971-06-16 | — | — | NULL | null | 932 Park Place | Denver | CO | 80289 | — | null |
| TPA | TPA-61345 | 2026-03-06T12:47:50Z | PATRICK | — | HERNANDEZ | 2008-01-12 | — | - | null | patrick.hernandez@proton.me | 1688 WILLOW COURT | COLUMBUS | Ohio | 43279·· | GRP-5980 | — |
| TPA | TPA-55575 | 2026-02-16T04:12:58Z | Patricia | — | Howard | 3/17/1946 | null | null | 7190786 | — | 8106 Camelback Rd | Sacramento | CA | 95811 | GRP-0752 | N/A |
| TPA | TPA-54327 | 2026-07-25T18:14:35Z | Alan | — | Nunez | 2003-08-05 | UNKNOWN | — | 9433305822 | UNKNOWN | 6551 Maple Avenue | Tampa | FL | 33644 | null | — |
| TPA | TPA-50941 | 2026-06-05T04:33:12Z | Alice·· | F | Singh | 1980-32-16 | UHC-74636-77 | null | (652) 514-6912 | — | ·4384 Main St | SAN ANTONIO | TX | 78233 | — | N/A |
| TPA | TPA-50764 | 2026-04-02T11:55:31Z | FATIMA | — | CLARK | 03/05/79 | — | — | — | — | 2705 SAGE COURT | Minneapolis | MN | -·· | null | N/A |
| TPA | TPA-53870 | 2026-05-17T05:27:16Z | Michael | — | Alexander | 2003-08-01 | ···· | •••-••-4812 | null | N/A | 9873 INDIAN SCHOOL RD | Glendale | AZ | 85318 | - | ·· |
| TPA | TPA-63019 | 2026-10-07T01:46:22Z | LUCIA | — | RIVERA | 1998-01-04 | null | N/A | (419) 223-0251 | — | 128 Oak St | Minneapolis | MN | 55490 | GRP-3753 | CORE-HMO |
| TPA | TPA-63842 | 2026-07-05T20:20:26Z | CARL | — | ·SIMS | 1963-06-26 | — | - | 7386776 | — | 3056 Indian School Road | Tucson | AZ | 85781 | N/A | — |
| TPA | TPA-58808 | 2026-07-31T15:29:17Z | Judy | — | Brown | 3/24/1979·· | N/A | UNKNOWN | 8854644983 | judy.brown@yahoo.com | 6536 Elm St | Plano | Texas | NULL | UNKNOWN | UNKNOWN·· |
| TPA | TPA-51110 | 2026-03-29T16:35:45Z | Laarry | ···· | Vasquez | 20030424·· | N/A | — | N/A | NULL | ·5326 LINCOLN WAY | JACKSONVILLE | FL | 32248 | GRP-4457 | N/A |
| TPA | TPA-50013 | 2026-02-23T01:15:58Z | Sara·· | — | Contreras | 1973-04-10 | NULL | — | UNKNOWN | NULL | 4401 RIVER RD | Seattle | WA | 98159 | null | NAVIGATE-HMO |
| TPA | TPA-55717 | 2026-01-24T11:44:11Z | Bryan | C. | Soto | 1986-10-28 | UNKNOWN | - | — | bryan.soto95@hotmail.com | 1605 Lincoln Way | San Antonio | Texas | 78221-0083 | GRP-8292 | — |
| TPA | TPA-50543 | 2026-07-14T16:20:56Z | Lucia | — | Peters | 19810908 | NULL | null | N/A·· | NULL | 8664 Market St #614 | Atlanta | GA | 30375·· | - | NULL |
| TPA | TPA-57633 | 2026-05-24T12:51:46Z | MARILYN | — | HOLMES | 1944-08-12 | N/A | •••-••-0594 | — | null·· | 7708 RIVER ROAD | San Diego | CA | 92164 | GRP-1129 | null |
| TPA | TPA-61520 | 2026-06-29T17:58:37Z | Wang, Samantha | — | — | 9/10/1995 | NULL | NULL | null | N/A | 570 Ridge Rd | ·Charlotte | North Carolina | 28202 | GRP-6412·· | N/A |
| TPA | TPA-52164 | 2026-09-02T02:39:35Z | KATHERINE | R | AUSTIN | 1964-01-09 | NULL | •••-••-5888 | (615) 224-4394 | katherine.austin19@proton.me·· | 8602 Main Street | Jacksonville | FL | 32240 | — | — |
| TPA | TPA-56852 | 2026-08-20T02:17:59Z | ·Martha | — | Campbell | 2007-12-72 | — | null | UNKNOWN | N/A | 2352 BROADWAY | Mesa | AZ | 85287 | - | — |
| TPA | TPA-59108 | 2026-07-13T08:08:13Z | Andrewws, Roy | — | — | 1942-06-18 | — | N/A | 4702131669 | roy.andrews@gmail.com | - | null·· | N/A | null | GRP-0308 | — |
| TPA | TPA-64269 | 2026-02-26T03:07:41Z | Brittany·· | — | Torres | 1969-12-15 | UNKNOWN | - | UNKNOWN | null | 716 Broadway·· | Plano | TX | 75014 | GRP-8109 | ·· |
| TPA | TPA-63064 | 2026-10-04T15:37:23Z | Ahmde | — | Sanders | 1970-10-02·· | NULL | ·NULL | (744) 993-0595 | NULL | 7646 WILLOW COURT | Atlanta | GA | 30310 | GRP-5400 | — |
| TPA | TPA-54997 | 2026-09-09T20:41:37Z | Ahmed | — | Johnson | 1980-07-19 | — | UNKNOWN·· | — | NULL | 1865 OCEAN AVENUE | ·Columbus | OH | 43297 | — | SELECT-EPO |
| TPA | TPA-58470 | 2026-07-25T11:21:13Z | Karen·· | P | Kim | 1993-01-13 | NULL | null | UNKNOWN | NULL | 8068 MOUNTAIN VIEW DR | Dallas | TX | — | GRP-2189 | ·SELECT-EPO |
| TPA | TPA-60069 | 2026-07-29T22:18:03Z | Kelly | — | Lawrence | ·1982-05-23 | UNKNOWN | UNKNOWN | — | null·· | 2077 CEDAR LN | ·MESA | AZ | ·85293 | ·· | null |
| TPA | TPA-56432 | 2026-07-24T21:48:59Z | JOAN | — | GUTIERREZ | 2006-05-28 | UHC-02943-57 | null | — | — | 3674 Harbor Boulevard | Tampa | FL | 33683 | - | null |
| TPA | TPA-55118 | 2026-07-01T02:20:16Z | Laura | ·· | Ramirez | 19530109 | NULL | NULL | - | NULL | 2889 PINE DR | Miami·· | FL·· | ·33194 | GRP-6339 | NAVIGATE-HMO |
| TPA | TPA-53877 | 2026-03-30T15:23:18Z | Charlotte | — | Alexander | ·19970413 | UNKNOWN | — | N/A | ·· | 8547 MOUNTAIN VIEW DR | Nashville | TN | 37287 | GRP-5301 | null |
| TPA | TPA-57801 | 2026-06-13T19:16:17Z | Ford, Cynthia | — | — | 1986-06-11 | UNKNOWN | •••-••-0765 | +1 693 605 7795 | NULL | NULL | ···· | - | ·UNKNOWN | N/A | ·UNKNOWN |
| TPA | TPA-55530 | 2026-04-28T01:52:24Z | Roy | X | Sanders | 06/11/1941 | — | UNKNOWN | NULL | ·N/A | 1470 Willow Court | Orlando | FL | ·32818 | — | options-ppo |
| TPA | TPA-50487 | 2026-06-07T14:03:16Z | ·Emma | — | ·Reyes | 1992-04-17 | — | UNKNOWN | (246) 461-5050 | UNKNOWN | 6614 Lake View Rd | Sacramento | CA | 95827 | null | N/A |
| TPA | TPA-58390 | 2026-08-07T08:22:22Z | HELEN | — | GUZMAN | 19870519 | - | •••-••-8033 | — | UNKNOWN | 7313 Maple Avenue | Plano | Texas | 75031 | null | SELECT-EPO |
| TPA | TPA-63584 | 2026-02-27T01:24:13Z | Judith | — | ·Knight | Sep 15, 1991 | UHC-83763-88 | — | ·9876878180 | JUDITH.KNIGHT@AOL.COM·· | 9676 Sage Court | Columbus | ·OH | 43269 | ···· | NULL |
| TPA | TPA-58748 | 2026-01-01T18:51:17Z | albert | — | jacobs | 1994-07-04 | ·N/A | null | - | — | 1538 Lake View Rd | Seattle | WA | 98175 | NULL | MEDICARE-ADV-A |
| TPA | TPA-63701 | 2026-10-01T09:05:30Z | FATIMA | I. | PRICE | 19451118 | N/A | ·UNKNOWN | N/A | — | - | UNKNOWN | - | null | UNKNOWN | UNKNOWN |
| TPA | TPA-53708 | 2026-07-07T13:12:44Z | RONALD | — | GARZA | 09/25/1959 | — | UNKNOWN | — | null | 1160 Highland Avenue | Sacramento | CA | 95849 | — | MEDICARE-ADV-A |
| TPA | TPA-52173 | 2026-06-03T13:29:41Z | Debra | — | Moore | 1957-05-26 | N/A·· | — | — | UNKNOWN | 3078 Jefferson Avenue | PLANO | TX | - | GRP-1003 | — |
| TPA | TPA-64336 | 2026-03-01T09:12:44Z | Joe·· | — | Stevens | 1952-07-16 | ·NULL | - | null | — | 6977 Apache Blvd | Seattle | Washington | 98174 | GRP-4929 | — |
| TPA | TPA-61349 | 2026-01-13T13:03:46Z | Gerald | — | Mendez | Jan 11, 1963 | — | N/A | null | NULL | 4300 MOUNTAIN VIEW DRIVE | Nashville | TN·· | ·37210 | null | ·OPTIONS-PPO |
| TPA | TPA-50002 | 2026-03-25T11:32:21Z | james | — | hunter | 1960-03-14 | - | - | NULL | JAMES.HUNTER@ICLOUD.COM | null | — | ·null | — | ·GRP-2498 | UNKNOWN |
| TPA | TPA-55376 | 2026-09-05T02:39:58Z | Thomas | — | Boyd | 11/05/96 | - | •••-••-5425 | 18104388722 | — | 204 Indian School Road | Glendale | Arizona | 85368 | — | SELECT-EPO |
| TPA | TPA-52725 | 2026-02-15T13:15:59Z | Jackie | — | Payne | 1952-08-12 | — | — | - | — | 8478 Sunset Boulevard | Plano | TX | 75091 | GRP-9452 | UNKNOWN |
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:43:00.497Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty