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-62201 | 2026-04-10T09:01:45Z | ALBERT | — | HOFFMAN | 1967-12-23 | NULL | UNKNOWN | NULL | - | 3682 Pine Drive | San Diego | CA | 92153 | — | OPTIONS-PPO |
| TPA | TPA-57982 | 2026-07-21T14:16:40Z | KAYLA | — | PEREZ | 12/11/1964 | NULL | •••-••-2153 | — | kayla.perez@gmail.com | 5951 Forest Avenue | Plano | TX | 75025 | GRP-6857 | NULL·· |
| TPA | TPA-58780 | 2026-01-13T18:38:20Z | Mendez, John | — | — | 6/11/1971 | — | null | null | N/A | 4815 Pine Dr | ·Chandler | AZ | 85280 | — | UNKNOWN |
| TPA | TPA-56778 | 2026-05-06T12:54:58Z | ·JUAN | — | FRANKLIN | 19630308 | — | — | — | null | 5848 MAPLE AVENUE | Sacramento | CA | 95870 | — | null |
| TPA | TPA-52121 | 2026-08-29T21:24:35Z | Ryan | — | Rose | 1940-10-15 | NULL | •••-••-7887 | (593) 982-7627 | - | — | - | — | - | — | — |
| TPA | TPA-54181 | 2026-06-03T00:31:39Z | Brown, Bradley | — | — | 2004-06-11 | N/A | N/A | — | — | 4265 GRAND AVENUE | HOUSTON | TX | 77064 | N/A | — |
| TPA | TPA-50237 | 2026-05-11T07:49:37Z | DEBRA | — | BISHOP | Aug 24, 1939 | NULL | •••-••-3413 | — | N/A | 6338 Grand Ave | Orlando | FL | 32862 | — | N/A |
| TPA | TPA-53346 | 2026-09-25T04:20:59Z | tyler | — | ellis | 11-06-1964 | — | •••-••-8914 | UNKNOWN | UNKNOWN | 9799 Maple Ave | Las Vegas | NV | 89140 | NULL | — |
| TPA | TPA-62283 | 2026-04-14T22:36:25Z | MICHELLE | — | HARPER | 1952-04-17 | — | — | — | UNKNOWN | 3693 Union St | Plano | tx | ·75080 | GRP-0838 | UNKNOWN |
| TPA | TPA-61202 | 2026-02-20T00:30:12Z | ERIC | — | LI | 04/03/1942 | - | NULL | 281-637-7947 | - | 3044 Park Pl | Denver·· | CO | 80212-2711 | GRP-8411 | — |
| TPA | TPA-57993 | 2026-07-19T19:59:25Z | Brian | — | McCoy | 1958-07-15 | — | — | — | null | 8242 Union St | ·Tempe | Arizona | 85238 | null | OPTIONS-PPO |
| TPA | TPA-54535 | 2026-04-26T08:27:36Z | Matthew | — | Perrez | 1960-08-09 | - | - | 682-709-8770 | ·· | 3837 CAMELBACK ROAD | Seattle | ·WA | 98193 | GRP-6910 | CHOICE-PLUS-PPO |
| TPA | TPA-50928 | 2026-06-24T03:26:12Z | Katherine | H.·· | ·Bowman | 1957-01-08 | null | •••-••-7128 | (770) 630-8355 | N/A | 5388 PALM DRIVE Apt 10 | Atlanta | GA | 30316 | null | null |
| TPA | TPA-57879 | 2026-05-14T15:25:47Z | Turner, Justin | — | — | 1995-11-12 | — | — | ·468-619-6634 | justin.turner@icloud.com | 3538 Indian School Rd | ·Miami | FL | 33160·· | — | - |
| TPA | TPA-51209 | 2026-05-26T07:55:37Z | KIMBERLY | — | RYAN | 2004-10-07 | - | — | 3252899304 | NULL | 8063 Broadway | CHARLOTTE | NC | 28277 | — | SELECT-EPO |
| TPA | TPA-51411 | 2026-10-01T11:39:42Z | ·ADMA | — | BURKE·· | 09/04/40·· | — | NULL | — | — | 1835 Hillcrest Rd | NASHVILLE | TN | 37249 | — | - |
| TPA | TPA-57551 | 2026-07-12T15:53:55Z | SOPHIA | — | JENSEN | 1955-01-11 | — | — | 7598340220 | ···· | 9101 Union St | Atlanta | GA | 30365 | — | UNKNOWN |
| TPA | TPA-60932 | 2026-04-02T15:47:10Z | Reid, Charles | — | — | 1996-06-14 | — | — | — | ·· | 3202 Lincoln Way | Tempe·· | Arizona | 85211 | UNKNOWN | null |
| TPA | TPA-53280 | 2026-04-26T17:29:24Z | William | ·· | Harrion | 1956-07-19 | UHC-32299-78 | - | (780) 402-2643 | ·N/A | 807 Maple Ave | Tempe | AZ | 85274 | ·N/A | CORE-HMO |
| TPA | TPA-59825 | 2026-04-07T16:18:01Z | brian | — | baarnes | 1984-10-09 | UNKNOWN | •••-••-9068 | (305) 449-8682 | — | N/A | UNKNOWN | — | - | — | - |
| TPA | TPA-50225 | 2026-10-05T20:05:27Z | Joseph | — | Jordan | ·Oct 27, 1959 | — | — | 12418246598 | — | 8423 Palm Drive | Las Vegas | NV | 89143 | null | UNKNOWN |
| TPA | TPA-62309 | 2026-02-20T12:14:25Z | Jeffrey | Y | Guerrero | 02/16/71 | UHC-34240-66 | N/A | — | null | 7245 Grand Avenue | San Diego | CA | 92172 | GRP-1599 | MEDICARE-ADV-B·· |
| TPA | TPA-59402 | 2026-06-01T00:21:48Z | SANDRA | — | FOSTER | 2001-07-19 | — | — | - | null | 2551 Pine Drive | Columbus | OH | 43252 | GRP-2180 | SELECT-EPO |
| TPA | TPA-56247 | 2026-04-01T17:36:42Z | Angela | — | Espinoza | 2005-12-14 | null | •••-••-8897 | null | ···· | 764 Cedar Ln | Gilbert | AZ·· | 85219 | N/A | NAVIGATE-HMO |
| TPA | TPA-61908 | 2026-07-09T04:04:03Z | Billy | ·· | Mills | 11-11-1946·· | UNKNOWN | — | 19603095488 | null | UNKNOWN | — | — | — | UNKNOWN | — |
| TPA | TPA-55698 | 2026-08-25T03:19:53Z | Ruth | W | Payne | 1977-11-16 | — | •••-••-4420 | 6968055688 | ruth.payne@outlook.com | 6794 Church Street | JACKSONVILLE | FL | 32290-9990 | — | UNKNOWN |
| TPA | TPA-54489 | 2026-10-06T13:09:27Z | Snyder, Mariana·· | — | — | ·Jan 24, 1999 | ···· | •••-••-1163 | N/A | — | 5485 Mesa Dr | Dallas | TX | 75275 | — | NAVIGATE-HMO·· |
| TPA | TPA-51122 | 2026-07-30T21:26:11Z | GREGORY | U | HUDSON | 1972-10-10 | NULL | - | 6077518762 | — | - | — | ···· | — | ·GRP-8026 | N/A |
| TPA | TPA-58580 | 2026-02-09T00:32:30Z | Jesse | E | Spencer | 1969-06-10 | UHC-30833-86 | null·· | null | N/A | 935 Palm Dr | Columbus | OH | 43203 | NULL | — |
| TPA | TPA-50535 | 2026-02-04T12:15:20Z | Jordan | ···· | ·Cruz | 01/23/08 | null | — | — | NULL | 4114 Spring St | Plano | TX | 75047 | ·GRP-6230 | — |
| TPA | TPA-56214 | 2026-03-12T17:02:35Z | ROY | — | CHAVEZ | Nov 4, 1939 | ·· | - | — | null | 1429 APACHE BOULEVARD | Chandler | AZ | 85295 | null | MEDICARE-ADV-B·· |
| TPA | TPA-54364 | 2026-03-27T05:44:38Z | Wei | — | Bradley | 1962-09-24 | - | •••-••-5664 | 13147219949 | N/A | 2524 Baseline Rd | Columbus | OH·· | 43297 | — | — |
| TPA | TPA-62944 | 2026-02-14T11:59:51Z | Lane, Kyle | — | — | 11/7/1981·· | N/A | •••-••-6635 | — | KYLE.LANE@PROTON.ME | 9320 Willow Ct | Dallas·· | Texas | 75209 | ·null | N/A |
| TPA | TPA-51328 | 2026-06-09T10:11:15Z | paul | — | holmes | 23-04-2003 | — | NULL | 8824594611 | paul.holmes46@proton.me | 8385 Broadway | COLUMBUS | OH | 43250 | GRP-2158 | — |
| TPA | TPA-62188 | 2026-02-23T20:16:37Z | Logan | — | Spencer | 1092-20-02 | UHC-89476-48 | ·- | (926) 675-9382·· | LOGAN.SPENCER55@HOTMAIL.COM | 6116 Meadow Ln | Las Vegas | NV | 89191 | N/A | null |
| TPA | TPA-63011 | 2026-06-27T02:29:48Z | SEN·· | — | SIMS | 1945-02-08 | NULL | — | 455.433.7047 | - | 4081 Mesa Dr | Phoenix | AZ | 85020 | - | CORE-HMO |
| TPA | TPA-52585 | 2026-05-31T03:31:14Z | shirley | ···· | holmes | 1961-04-17 | null | - | 14462889768 | NULL | 8316 Ocean Ave | Phoenix | AZ | 85014 | GRP-1042 | CORE-HMO |
| TPA | TPA-57467 | 2026-02-15T18:56:37Z | Gonzales, Nathan | — | — | 2006-02-18 | — | N/A | — | — | 4173 Desert Sky Blvd | Orlando | FL | 32875 | — | UNKNOWN |
| TPA | TPA-60794 | 2026-06-24T15:44:11Z | ABIGAIL | ·· | LUNA | 1940-11-08 | UHC-74464-69 | — | NULL·· | — | 4651 Hillcrest Rd | Jacksonville | FL | UNKNOWN | GRP-5936 | — |
| TPA | TPA-61427 | 2026-07-21T10:57:38Z | Robert | — | ·Nichols | 18-09-1989 | UNKNOWN | N/A | +1 332 538 7382 | robert.nichols85@aol.com | 4382 SUNSET BLVD | Miami | FL | 33164 | GRP-5204 | NULL |
| TPA | TPA-50008 | 2026-06-17T19:59:01Z | Martha | — | Stone | 1952-05-13 | — | N/A | — | UNKNOWN·· | 776 Oak Street | Eden Prairie | MN | 55332·· | GRP-6023 | — |
| TPA | TPA-52004 | 2026-02-09T08:49:21Z | ·JASON | Q·· | KING | 8/6/1976 | N/A | NULL | — | NULL | 9255 PALM DR #995 | Fresno | ·CA | 93751 | GRP-9612·· | N/A |
| TPA | TPA-62060 | 2026-02-19T15:41:19Z | Harrison, Richard | — | — | 1988-06-17 | N/A | •••-••-0409 | N/A | RICHARD.HARRISON@PROTON.ME | 3120 Main Street | TAMPA | FL | N/A | - | NULL |
| TPA | TPA-55214 | 2026-04-17T11:37:23Z | Sean | — | Campblel | 19610727 | — | UNKNOWN | - | SEAN.CAMPBELL76@ICLOUD.COM | UNKNOWN | - | N/A | — | — | N/A |
| TPA | TPA-51969 | 2026-02-09T15:29:07Z | Paul | ···· | Simmons | 06/17/1953 | — | NULL | 5654598640 | -·· | 3135 Baseline Road | Phoenix | AZ | 85017 | — | — |
| TPA | TPA-60388 | 2026-05-24T04:56:10Z | Laura | — | ·Gusman | 1973-11-21 | — | •••-••-5560 | 750-538-6614 | — | — | NULL | NULL | NULL | GRP-7205 | - |
| TPA | TPA-56531 | 2026-03-01T08:46:52Z | DNISE | — | HARRISON | Jan 12, 1977 | — | — | 4383803 | N/A | — | - | null | NULL | N/A | UNKNOWN |
| TPA | TPA-56681 | 2026-08-10T08:12:30Z | ANDRREA | — | COLE | Oct 12, 1964 | null | — | 562.847.0621 | null·· | 5210 SUNSET BLVD | ORLANDO | FL·· | UNKNOWN | ·UNKNOWN | — |
| TPA | TPA-57312 | 2026-07-10T23:26:23Z | RANDY | — | BISHOP | 1941-03-11 | null | N/A | - | NULL | NULL | - | — | NULL | UNKNOWN | null |
| TPA | TPA-53879 | 2026-05-27T20:31:15Z | Amanda | — | Reyynolds | 1981-04-11 | null | — | (326) 289-1011 | amanda.reynolds@yahoo.com | 7514 Ocean Avenue | Tucson | Arizona | 85725 | GRP-9336 | — |
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:49.118Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty