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-51593 | 2026-01-19T07:26:12Z | Gerald | — | Ford | 1951-09-22 | — | NULL | null | — | UNKNOWN | - | — | — | — | CHOICE-PLUS-PPO |
| TPA | TPA-57035 | 2026-01-19T03:21:19Z | ·lauren | — | pena | 1974-01-10 | — | - | N/A | NULL | — | — | — | — | — | null |
| TPA | TPA-58553 | 2026-03-19T04:16:33Z | Barbara | — | Chavez | 04/28/84 | — | •••-••-6903 | UNKNOWN | barbara.chavez25@aol.com | 6126 INDIAN SCHOOL RD | San Antonio | TX | — | - | UNKNOWN |
| TPA | TPA-59405 | 2026-05-22T02:01:46Z | Charles | V | Evans | 1976-10-02 | - | NULL | (740) 208-5591 | null | 2088 Broadway | Glendale·· | AZ | 85375-2411 | GRP-6666 | CORE-HMO |
| TPA | TPA-59940 | 2026-03-14T23:19:26Z | Sarah | — | McDonald | 05/05/56 | UHC-91367-28 | - | +1 704 551 8382 | null | 6759 RIVER RD·· | Miami | FL·· | 33162 | — | UNKNOWN |
| TPA | TPA-57561 | 2026-04-09T19:14:19Z | Randy | — | Armstrong | 1959-01-07 | ·· | UNKNOWN | N/A | NULL | 5427 HARBOR BLVD | San Antonio | Texas | 78227 | null | - |
| TPA | TPA-55357 | 2026-08-10T05:15:10Z | Nancy | — | Lewis | 1984-11-14 | - | NULL | null | - | 6223 Valley View Dr | Austin | TX | 78732 | UNKNOWN | N/A |
| TPA | TPA-53931 | 2026-01-03T08:03:57Z | jamas | — | garcia | 1975-05-23 | ·· | NULL | N/A | james.garcia@yahoo.com | 1489 Baseline Rd | San Antonio | TX | UNKNOWN | GRP-8328·· | SELECT-EPO·· |
| TPA | TPA-62080 | 2026-01-16T01:04:22Z | EVELYN | — | WALSH | 19451112 | - | UNKNOWN | null | NULL | 472 APACHE BOULEVARD | San Antonio | TX | 78224 | GRP-5351 | — |
| TPA | TPA-55853 | 2026-01-16T13:20:02Z | Doris | — | White | 02/02/95 | — | •••-••-4107 | ·N/A | doris.white35@icloud.com | — | NULL | — | — | GRP-2055 | CORE-HMO |
| TPA | TPA-55355 | 2026-09-05T09:33:44Z | Roy·· | U. | Mills | 10-09-1949 | UHC-24316-20 | ·· | - | ·UNKNOWN | 1396 Union Street | Sacramento | CA | 95803 | - | N/A |
| TPA | TPA-64291 | 2026-10-14T19:31:32Z | Gay | ···· | Santos | 03/08/1957 | NULL·· | - | 12328547760 | — | 947 Grand Avenue·· | Miami | fl | 33168 | — | UNKNOWN |
| TPA | TPA-51714 | 2026-03-02T19:10:32Z | MARK | Z | FOX | 04/05/1993 | — | •••-••-1880 | 17479183905 | mark.fox@yahoo.com | 1877 INDIAN SCHOOL ROAD | Atlanta | ·GA | ·30302 | GRP-7629 | NULL |
| TPA | TPA-59595 | 2026-06-15T02:43:38Z | Martha | ·· | ·Morgan | 06/22/1992 | — | - | UNKNOWN·· | - | 9387 Elm Street | Denver | CO | 80249 | — | — |
| TPA | TPA-53895 | 2026-04-02T12:52:58Z | George | — | Simpson | 11/01/53·· | NULL | — | NULL | UNKNOWN | 3637 HARBOR BLVD | ORLANDO | FL | 32889·· | N/A | — |
| TPA | TPA-60807 | 2026-08-06T21:29:48Z | Joseph | ···· | Owens | 5/26/1949 | - | — | 851-995-1077 | ·null | 7608 River Road | AUSTIN | TX | 78797 | - | UNKNOWN |
| TPA | TPA-54900 | 2026-03-14T16:54:18Z | virginia | — | hudson | ·1954-05-12 | null | — | null | N/A | 4992 Washington St | Dallas | TX·· | 75226 | GRP-0751 | NAVIGATE-HMO |
| TPA | TPA-61091 | 2026-02-25T11:02:37Z | Camila | — | Hanson | 2008-01-09 | N/A | •••-••-5180 | 913-398-9663 | NULL | 9600 Lincoln Way | Nashville | Tennessee | 37256 | GRP-4874·· | — |
| TPA | TPA-62269 | 2026-07-11T03:33:54Z | Lucia | — | White | 1997-06-02 | N/A | ···· | N/A | — | 8826 Cedar Ln | Jacksonville | fl | — | GRP-5318 | — |
| TPA | TPA-60179 | 2026-09-22T09:59:40Z | Willie | B | — | 11/15/1998 | - | -·· | ·477.283.0887 | null | 9044 MOUNTAIN VIEW DRIVE | LAS VEGAS | NV | 89163 | GRP-6349 | NULL |
| TPA | TPA-62838 | 2026-04-03T08:40:54Z | RUSSELL | ···· | MORRISON | 1952-07-14 | — | — | ·· | ·UNKNOWN | 6556 Spring St | Houston | ·tx | 77089 | GRP-3709 | NAVIGATE-HMO |
| TPA | TPA-58368 | 2026-02-04T08:55:03Z | Joe | — | Webb | 2008-01-15 | UHC-44238-24 | NULL | N/A·· | - | ·838 Washington Street | MINNEAPOLIS | MN | 55477 | - | — |
| TPA | TPA-59004 | 2026-02-22T11:09:28Z | Janet | ···· | Hicks | 24-06-1979·· | - | NULL | 4283226184 | janet.hicks@hotmail.com | ·- | — | UNKNOWN | null | — | UNKNOWN |
| TPA | TPA-62126 | 2026-07-27T11:47:48Z | Julie | — | Garrtt | 06/04/40 | UHC-79164-92 | ·N/A | 233-313-5139 | - | 5021 Pine Dr | San Antonio | TX | 78221 | GRP-9499 | N/A |
| TPA | TPA-57827 | 2026-05-01T17:45:37Z | angela | — | gilbert | 1964-01-11 | - | — | UNKNOWN | null | 336 PINE DRIVE | MIAMI | FL | 33162-7194 | GRP-6249 | N/A·· |
| TPA | TPA-57766 | 2026-07-28T20:53:31Z | Maria | — | Simpson | 1979-12-26 | null | UNKNOWN | ·589.230.6355 | maria.simpson85@yahoo.com | 7887 Forest Avenue | Tampa | FL | 33686 | N/A | SELECT-EPO |
| TPA | TPA-59887 | 2026-03-29T06:50:39Z | Brittany | — | Wong | 20-04-1978 | — | UNKNOWN | (474) 392-1761 | null | ·1666 MOUNTAIN VIEW DRIVE #529 | LOS ANGELES | CA | 90096 | NULL | — |
| TPA | TPA-58103 | 2026-02-21T18:16:15Z | Soto, Marcus | — | — | 1977-03-21 | — | •••-••-8181 | — | — | 8050 Main St | Atlanta | GA | 30362-8339 | GRP-9746 | — |
| TPA | TPA-55821 | 2026-05-06T00:53:34Z | Albert | ·· | ·Mendez | ·Oct 21, 1972 | - | — | (393) 866-3302 | null | 1232 DESERT SKY BOULEVARD | Houston | TX | 77004 | NULL | NULL |
| TPA | TPA-59260 | 2026-04-03T09:54:18Z | brandon | — | ·gilbert | 19400310 | UHC-47987-53 | — | 6393887358 | - | 5070 HIGHLAND AVE | Phoenix | AZ | 85093 | — | CORE-HMO |
| TPA | TPA-62181 | 2026-06-27T16:51:14Z | Donald | — | Adams | 11/07/46 | ···· | — | UNKNOWN | donald.adams@gmail.com | 9804 Sunset Blvd | Plano | TX | 75003 | — | null |
| TPA | TPA-50813 | 2026-04-12T23:25:59Z | Warreen, Emily | — | — | 1996-07-11 | — | null | 669-633-0066 | - | 8997 Maple Avenue | Mesa | AZ | 85260 | ·null | — |
| TPA | TPA-50833 | 2026-05-02T22:27:15Z | Gloria | ·· | Meyer·· | 1/23/1988 | -·· | •••-••-9004 | 522-239-0186 | N/A | ·8279 Willow Ct | Dallas | TX | 75212 | UNKNOWN | NULL |
| TPA | TPA-59496 | 2026-03-16T23:55:28Z | Dorothy | — | ·Li | 7/23/1958 | — | — | UNKNOWN | dorothy.li76@icloud.com | N/A | — | N/A | - | ·· | SELECT-EPO |
| TPA | TPA-64082 | 2026-10-05T05:32:25Z | CHRISTINA | — | RUIZ | 2005-02-21 | - | - | - | NULL | 1263 Ocean Avenue | Eden Prairie | MN | 55318 | — | NAVIGATE-HMO |
| TPA | TPA-62002 | 2026-06-12T19:15:02Z | Thomas | — | Hart | 1993-01-06 | — | — | UNKNOWN | - | NULL·· | — | N/A | - | UNKNOWN | MEDICARE-ADV-A |
| TPA | TPA-62199 | 2026-04-27T18:47:23Z | GARY | — | JORDAN | 01/08/2005 | UHC-93960-98·· | •••-••-7988 | NULL | UNKNOWN | - | - | - | — | GRP-9233 | N/A |
| TPA | TPA-50761 | 2026-03-24T22:41:00Z | Ethan | — | Le | 11/24/1939 | null | — | (925) 358-9039 | NULL | 3103 Mesa Drive | PHOENIX | AZ | — | — | MEDICARE-ADV-B |
| TPA | TPA-63149 | 2026-05-19T07:38:40Z | Arthur | — | Watkins | 1939-08-05 | N/A | •••-••-4967 | (712) 891-9772·· | - | null | null | — | — | UNKNOWN | MEDICARE-ADV-A |
| TPA | TPA-57408 | 2026-09-28T12:56:23Z | JANET | — | CRUZ | 1595-06-17 | — | — | N/A | janet.cruz17@gmail.com | 6842 Oak Street | Chandler | AZ | 85244 | - | - |
| TPA | TPA-57158 | 2026-04-25T08:25:09Z | LARUA | — | DUNN | NULL | null | UNKNOWN | (468) 229-5174 | — | ·7113 Central Avenue | ATLANTA | GA | 30375 | — | CHOICE-PLUS-PPO |
| TPA | TPA-61004 | 2026-06-14T11:06:50Z | Angela | — | Carpenter | 1990-07-20 | NULL | NULL | +1 868 486 7873 | NULL | 4829 Jefferson Ave | Austin | TX | 78752 | NULL | — |
| TPA | TPA-52791 | 2026-07-17T19:22:54Z | EMILY | — | CRUZ | 2006-02-24 | UNKNOWN | •••-••-0327 | — | — | 9514 Spring St | Mesa | AZ | 85245 | - | MEDICARE-ADV-B |
| TPA | TPA-62503 | 2026-09-28T21:14:46Z | MARIA | — | LITTLE | 1940-06-21 | UNKNOWN | •••-••-2894 | 4209178852 | NULL | 1334 HARBOR BOULEVARD·· | Phoenix | AZ | 85030 | null | N/A |
| TPA | TPA-64435 | 2026-05-06T21:22:38Z | Steve | ·· | Ruiz | 01-07-1952 | UHC-29193-51 | UNKNOWN | — | ·· | 2175 Highland Ave·· | Tampa | fl | 33605 | — | null |
| TPA | TPA-53206 | 2026-07-22T13:35:43Z | Benjamin | — | Watkins | 1942-03-15 | — | — | — | - | 8979 Valley View Drive | Phoenix | AZ | 85088 | null | — |
| TPA | TPA-53298 | 2026-03-06T03:57:57Z | kelly | — | nunez | 1960-97-08 | — | — | 16934279439 | — | 2972 WASHINGTON ST | Phoenix | AZ | 85025 | GRP-2423 | - |
| TPA | TPA-50510 | 2026-06-13T00:54:53Z | DONNA | — | WEAVER | 1983-01-05 | - | N/A | N/A | - | 8693 Desert Sky Boulevard | Chandler | AZ | 85299 | GRP-6812 | NULL |
| TPA | TPA-50515 | 2026-05-26T20:09:26Z | Crawford, Joe | — | — | Jul 8, 1977 | — | — | N/A | - | 1032 Sunset Boulevard | Denver | CO | 80218 | UNKNOWN | CORE-HMO |
| TPA | TPA-56741 | 2026-07-01T14:16:59Z | Boyd, Nanyc | — | — | 04/18/1967 | — | NULL | (429) 538-2034 | — | 7848 Grand Ave | Glendale | AZ | 85301 | GRP-9903 | — |
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:40.627Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty