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-57302 | 2026-03-09T17:17:43Z | Abigail | — | Palmer | 09/23/2007·· | — | — | ·6482625506 | ABIGAIL.PALMER@PROTON.ME | 5914 Palm Dr | Dallas·· | TX | 75235 | GRP-4000 | MEDICARE-ADV-A |
| TPA | TPA-60716 | 2026-07-31T10:51:58Z | ABIGAIL | — | ELLIS | 1939-06-23 | null·· | ·· | null | abigail.ellis72@proton.me | 7316 Broadway Apt 5 | ATLANTA | GA | 30396 | — | UNKNOWN |
| TPA | TPA-57784 | 2026-07-31T07:17:53Z | JOSHUA | V | SNYDER | ·1948-08-02 | NULL | null | UNKNOWN | JOSHUA.SNYDER76@PROTON.ME | - | ·UNKNOWN | null | N/A | UNKNOWN | UNKNOWN |
| TPA | TPA-60934 | 2026-02-11T03:20:04Z | ·Daniel | — | Green | 1995-11-06 | — | •••-••-1465 | — | — | 4827 Lake View Rd | Orlando | Florida | 32838 | GRP-0805 | — |
| TPA | TPA-61343 | 2026-05-01T23:05:48Z | ·Isabella | U. | Miller | 03/22/92 | UNKNOWN | •••-••-7382 | null | NULL | 7287 Lincoln Way | Mesa | AZ | 85294 | GRP-2851 | CHOICE-PLUS-PPO |
| TPA | TPA-60577 | 2026-05-27T17:57:41Z | ·kyle | — | cruz | 1947-05-02 | ···· | N/A | - | NULL | 2342 Church St | Jacksonville | FL·· | 32226 | UNKNOWN | MEDICARE-ADV-A |
| TPA | TPA-50906 | 2026-03-09T19:40:38Z | ruth | — | mendez | 2007-11-17 | null | UNKNOWN | NULL | NULL | 7365 SPRING STREET | San Antonio | TX | 78277 | — | — |
| TPA | TPA-51702 | 2026-09-27T06:22:46Z | albert | — | patel | 03/17/1949 | NULL | NULL | null | — | 7524 Forest Avenue | Fresno | CA | — | GRP-5218 | UNKNOWN |
| TPA | TPA-62363 | 2026-08-12T00:31:11Z | ralph | O. | luna | 2001-08-04 | — | null | — | - | 8713 Main Street | Atlanta | GA | ·30341 | null | UNKNOWN |
| TPA | TPA-50591 | 2026-08-22T14:03:12Z | DEBORAH | — | STEPHENS | 1998-04-13 | UHC-02721-84 | — | 8697199417·· | — | — | ·NULL | — | UNKNOWN | N/A | CORE-HMO |
| TPA | TPA-50326 | 2026-05-21T10:09:47Z | MATTHHEW | — | HAYES | 1993-02-07 | - | — | 464-921-9132 | UNKNOWN | 5670 River Road | Denver | CO | 80220 | GRP-0673 | NAVIGATE-HMO |
| TPA | TPA-62281 | 2026-01-17T13:59:43Z | ·Catherine | K | Junes | 2003-04-07 | - | •••-••-2208 | 700-495-6362 | NULL | — | -·· | — | — | — | CORE-HMO |
| TPA | TPA-50718 | 2026-10-05T14:56:48Z | Arjun | ···· | McCoy·· | 1954-05-11 | — | •••-••-2339 | UNKNOWN | — | 3672 CAMELBACK ROAD | Orlando | fl | 32804 | - | CORE-HMO |
| TPA | TPA-62634 | 2026-04-02T23:21:20Z | ANA | — | ·CARR | 1981-08-17 | NULL | — | null | ana.carr@hotmail.com | N/A | NULL | — | — | - | NAVIGATE-HMO |
| TPA | TPA-58070 | 2026-03-09T09:38:04Z | janet | — | sullivan | Feb 20, 1962·· | UHC-73270-99 | •••-••-5862 | 516-640-3891 | JANET.SULLIVAN22@AOL.COM | ·2326 LINCOLN WAY | Denver | CO | 80219·· | N/A | ···· |
| TPA | TPA-51115 | 2026-05-20T22:15:07Z | ·RUSSELL | U. | LEE | 1958-12-22 | — | •••-••-3389 | 513-823-4161 | null | 3177 Grand Avenue | Columbus | OH | 43244 | N/A | - |
| TPA | TPA-58687 | 2026-02-18T06:56:03Z | ISABELLA | — | ·LI | 1948-04-28 | NULL | •••-••-3607 | ·+1 900 920 9380 | ·NULL | 802 Ocean Ave | Charlotte | nc | 28270·· | — | — |
| TPA | TPA-60631 | 2026-02-06T22:26:27Z | Aisha | — | Cruz | 1972-02-22 | UHC-68226-65 | N/A | +1 618 827 0355 | - | 5583 BAYSHORE DR | Austin | TX | 78767 | — | — |
| TPA | TPA-62780 | 2026-03-28T10:51:20Z | Mark | ···· | Wang | 1989-10-27 | NULL | •••-••-7649 | (935) 487-9405 | mark.wang66@aol.com | 1548 River Road Apt 28 | Tempe | AZ | 85235 | — | OPTIONS-PPO |
| TPA | TPA-53229 | 2026-02-11T14:15:45Z | GEORGE | ·· | MRPHY | Oct 14, 1998 | — | •••-••-6270 | null | NULL | 2791 ELM STREET·· | Fresno | CA | 93778·· | UNKNOWN | — |
| TPA | TPA-50287 | 2026-07-24T01:19:31Z | MATTHEW | — | VEGA | 1998-08-17 | NULL | — | 4834304551 | UNKNOWN | 789 River Road | DALLAS | TX | 75235 | null | - |
| TPA | TPA-59532 | 2026-08-12T03:09:01Z | Laura | — | Ellis | Oct 28, 1991 | UNKNOWN | NULL | — | N/A | 3033 Central Ave | Denver | CO | 80273 | N/A | OPTIONS-PPO |
| TPA | TPA-59712 | 2026-08-20T06:55:36Z | ERIC | ···· | HDSON | 12/3/2008 | ···· | - | N/A | ·- | 8745 Church St | Minneapolis | MN | 55422 | — | — |
| TPA | TPA-50454 | 2026-03-28T12:17:39Z | Maria | — | Harrison | ·1998-01-02 | UNKNOWN | ·· | — | — | 2840 Oak St | Columbus | OH | 43297-0453 | — | null |
| TPA | TPA-58743 | 2026-02-16T04:35:48Z | NICHOLAS | — | BOWMAN | 08/02/1993 | UHC-35066-30 | - | — | — | 8094 MAIN STREET | Sacramento | ·CA | 95807 | GRP-3558 | NULL |
| TPA | TPA-55828 | 2026-02-21T05:57:55Z | Adams, Susan | — | — | 1992-09-01 | UNKNOWN | — | 538.813.6562 | NULL | 8014 Valley View Dr | Minneapolis | MN | 55410 | ·GRP-2960 | OPTIONS-PPO |
| TPA | TPA-56297 | 2026-04-01T23:55:51Z | amber | — | wright | 1939-02-25 | — | UNKNOWN | 9256935730 | AMBER.WRIGHT@PROTON.ME | 5715 Palm Dr | Tucson | az | 85718 | NULL | NULL |
| TPA | TPA-62083 | 2026-10-17T18:24:15Z | RAYMOND | — | HUNT | 20-02-1952 | — | — | null | N/A | 5972 Lake View Road | Charlotte | NC | 28267 | — | — |
| TPA | TPA-63574 | 2026-04-14T08:05:50Z | Mateo | — | Salazar | 1965-05-19 | — | •••-••-8018 | — | null | 4525 Highland Ave | MESA | AZ | 85215-2837 | GRP-3410 | ·· |
| TPA | TPA-52256 | 2026-01-01T14:14:46Z | Elijah | — | Flors | 1966-09-10 | NULL | — | NULL·· | ELIJAH.FLORES@OUTLOOK.COM | 2946 WASHINGTON ST #632·· | Sacramento | CA | ·95869 | GRP-9932 | — |
| TPA | TPA-58163 | 2026-08-16T16:53:25Z | KEITH | — | SIMPSON | 2007-11-19 | UNKNOWN | — | NULL | KEITH.SIMPSON62@GMAIL.COM | ·6732 CHURCH STREET | Fresno | CA | 93776 | — | - |
| TPA | TPA-58639 | 2026-04-19T00:06:12Z | JESSE | — | HARRISON | 10/28/73·· | UHC-23309-57 | - | UNKNOWN | - | 8794 Meadow Ln | Nashville | TN | 37249 | N/A·· | choice-plus-ppo |
| TPA | TPA-56113 | 2026-05-17T16:54:43Z | KATHLEEN | — | STEVENS | 1979-02-01 | UHC-16813-28 | — | 559-700-5041 | N/A | UNKNOWN | N/A | — | — | — | options-ppo |
| TPA | TPA-50319 | 2026-08-15T03:42:45Z | Cheryl | — | ·Parker | 09-06-1988 | null | •••-••-0033 | 746-261-6992 | N/A | 8286 Bayshore Drive | TAMPA | FL | 33649 | - | CORE-HMO |
| TPA | TPA-63919 | 2026-03-08T17:48:05Z | BRITTANY·· | — | — | 1/8/1968 | N/A | ·· | — | N/A | UNKNOWN | null | UNKNOWN | — | — | CHOICE-PLUS-PPO |
| TPA | TPA-53725 | 2026-03-22T13:11:09Z | donald | — | fields | 1981-05-24 | - | — | UNKNOWN | UNKNOWN | null | UNKNOWN | - | null | GRP-9287 | NULL |
| TPA | TPA-51422 | 2026-04-27T04:03:37Z | OMAR | W | RIOS·· | 91871015 | NULL | NULL | — | — | 5383 Union Street Apt 40 | Plano | TX | 75043 | NULL | — |
| TPA | TPA-55160 | 2026-03-04T02:51:03Z | Wei | — | Robinson | 1985-07-06 | — | — | 2025315396 | — | 5506 DESERT SKY BOULEVARD | Los Angeles | ca | 90005 | GRP-2994 | MEDICARE-ADV-B |
| TPA | TPA-55410 | 2026-08-29T21:19:03Z | TERRY | — | ELLIOTT | ·19800520 | UHC-43012-07 | NULL | N/A·· | — | 6936 WILLOW COURT | TEMPE | AZ | 85260 | GRP-8058 | OPTIONS-PPO |
| TPA | TPA-55642 | 2026-06-26T19:32:44Z | Theresa | — | Campbell | 01/26/86 | — | null | (966) 966-8695 | UNKNOWN | 7253 OCEAN AVENUE #451 | SEATTLE | WA | 98195 | GRP-3169 | UNKNOWN |
| TPA | TPA-59501 | 2026-04-04T11:42:54Z | SARA | G. | HOWARD | Apr 9, 1967 | UHC-97726-24 | •••-••-0175 | -·· | — | 4495 UNION ST | San Antonio | TX | 78244 | — | NULL |
| TPA | TPA-61875 | 2026-01-11T03:16:26Z | Philip | — | Johnston | 1966-07-26 | — | — | UNKNOWN | N/A | 9556 River Road | Tucson | AZ | 85789 | — | - |
| TPA | TPA-60024 | 2026-04-25T02:38:04Z | WLLIAM | — | KELLY | 2007-10-22 | UHC-90416-44 | — | ·NULL | NULL | null | UNKNOWN | null | N/A | null | - |
| TPA | TPA-57013 | 2026-03-19T18:15:32Z | BRENDA | — | NELSON | 1946-06-04·· | ·UNKNOWN | - | 4913346 | N/A | 1315 Market St | Gilbert | AZ | 85222 | null | N/A |
| TPA | TPA-52106 | 2026-07-06T10:45:09Z | LAUREN | — | JAMES | 19650405 | UHC-45123-42 | — | null | null | 9798 Main St | Tucson | AZ | 85732 | UNKNOWN | — |
| TPA | TPA-62559 | 2026-08-05T01:24:21Z | Sara·· | — | Murray | 1944-05-25 | — | •••-••-7785 | — | — | 9636 Spring Street | Columbus | OH | 43241·· | NULL | — |
| TPA | TPA-62734 | 2026-09-17T14:15:31Z | ROGER | — | ROSS | Dec 27, 2000 | — | ·- | NULL | — | 5420 VALLEY VIEW DRIVE·· | San Antonio | TX | NULL | — | ·null |
| TPA | TPA-62378 | 2026-07-31T13:34:07Z | SOPHIA | — | WILSON | 04-08-1977·· | — | •••-••-1405 | +1 613 829 1128 | NULL | 242 Main Street | Chandler | az | 85202 | UNKNOWN | NULL |
| TPA | TPA-50138 | 2026-06-21T14:49:34Z | Laura | — | Henderson | 1939-09-02 | UHC-08977-16 | N/A | 568-430-3972 | UNKNOWN | 6222 UNION STREET·· | TAMPA | FL | ···· | GRP-2687·· | SELECT-EPO |
| TPA | TPA-54282 | 2026-03-29T18:36:55Z | Lauren | — | Campbell | Aug 7, 1955 | N/A | — | — | — | 6268 Main St | TUCSON | ·AZ | 85718-0981 | ·· | OPTIONS-PPO |
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.681Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty