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-58083 | 2026-03-16T18:49:05Z | Carol | L. | Kelly | 1939-10-17 | — | null | 301-834-6050·· | ·· | 1796 Maple Ave | Seattle | WA | 98114 | NULL | — |
| TPA | TPA-62641 | 2026-05-23T02:06:50Z | Donald | — | Gomez | 1938-04-07 | UNKNOWN | •••-••-9931 | - | DONALD.GOMEZ42@YAHOO.COM | 6300 Ocean Avenue Apt 18 | Plano | tx | 75011·· | UNKNOWN | N/A |
| TPA | TPA-61548 | 2026-03-22T14:48:06Z | Russell | M | Schultz | — | ·· | NULL | 539-281-5153 | RUSSELL.SCHULTZ@AOL.COM | 1372 Forest Ave | Plano | TX | — | — | UNKNOWN |
| TPA | TPA-59770 | 2026-09-16T05:37:54Z | Olson, Ruth | — | — | 1960-10-19 | — | - | — | null | 8833 Sage Court | Seattle | WA | 98120 | — | — |
| TPA | TPA-53445 | 2026-05-16T17:20:02Z | AARON | — | RICHARDSON | 20050308 | UHC-17201-17 | •••-••-9450 | 16953255626 | - | ·7110 Indian School Road | Houston | TX | 77077 | GRP-9557·· | N/A·· |
| TPA | TPA-58242 | 2026-10-01T06:54:43Z | Siingh, Carol | — | — | 9197-02-14 | - | N/A | ·575-267-4334 | null | 5749 CANYON ROAD | Las Vegas | NV | 89107 | UNKNOWN | -·· |
| TPA | TPA-60945 | 2026-01-05T15:01:01Z | Jose | T | Patterson | 1982-09-22 | UHC6000641 | — | - | — | 9395 Sunset Boulevard | Houston | TX | 77066 | GRP-5037 | UNKNOWN |
| TPA | TPA-58172 | 2026-08-22T13:38:35Z | MARK·· | W | LYNCH | 12/19/1997·· | - | N/A | — | — | ·· | null | null | N/A | GRP-8255 | NAVIGATE-HMO |
| TPA | TPA-57591 | 2026-07-23T11:46:57Z | Sarah | — | Reed | 19670314 | N/A | •••-••-6151 | — | SARAH.REED93@HOTMAIL.COM | 3831 Grand Ave | Seattle | WA | 98140 | ·N/A | - |
| TPA | TPA-50262 | 2026-08-02T14:46:52Z | HENRY | Y | LANE | 1940-09-11 | — | N/A | +1 569 735 4109 | — | 1172 Lincoln Way | Los Angeles | California | 90068 | GRP-4035 | UNKNOWN |
| TPA | TPA-51559 | 2026-01-20T01:20:16Z | Debra | — | Pierce | 26-04-1964 | ···· | — | 693-478-2506 | — | — | — | N/A·· | — | null | MEDICARE-ADV-A |
| TPA | TPA-63996 | 2026-02-24T19:52:13Z | Diane | — | Fuller | ·04/08/57 | — | UNKNOWN | (260) 356-0458 | N/A | 5890 Apache Blvd | Houston | TX | 77064·· | — | NULL |
| TPA | TPA-57928 | 2026-04-07T19:35:27Z | Judy | — | Hart | 2006-05-28 | UHC-11656-07 | N/A | — | NULL | 2376 Meadow Ln | SCOTTSDALE | AZ | 85263-6552 | — | — |
| TPA | TPA-62812 | 2026-07-10T08:53:27Z | Rebecca | — | Crawford | 1957-08-12 | ·- | UNKNOWN | NULL | rebecca.crawford@icloud.com | 6408 Hillcrest Rd | Tempe | AZ | 85231 | N/A | OPTIONS-PPO |
| TPA | TPA-51416 | 2026-07-25T20:06:04Z | Kevin | — | Rogers | 08/11/1973 | — | - | UNKNOWN | UNKNOWN | 4596 Central Avenue | Plano | Texas | - | N/A·· | UNKNOWN |
| TPA | TPA-51716 | 2026-05-21T04:47:17Z | Ahmed | V. | Bowman | Jul 28, 1944 | UHC-82494-64 | •••-••-6296 | ···· | ahmed.bowman99@yahoo.com | — | null | UNKNOWN | — | ·NULL | UNKNOWN·· |
| TPA | TPA-54746 | 2026-10-06T16:13:40Z | albert | — | lucas | 1979-10-06 | UNKNOWN | ·NULL | N/A | N/A | 8067 Lincoln Way | Eden Prairie | MN | 55337·· | GRP-3123 | UNKNOWN |
| TPA | TPA-59517 | 2026-02-23T23:14:07Z | Kimberly | — | Wright | 10/10/83 | - | •••-••-5015 | ···· | — | 6957 Bayshore Drive | Los Angeles | CA | N/A | — | — |
| TPA | TPA-58974 | 2026-07-08T09:11:46Z | david | — | rogers | 1950-12-15·· | — | null | 6937497399 | david.rogers57@gmail.com | 5317 Washington Street | Mesa | AZ | 85218-9586 | GRP-4420 | CORE-HMO |
| TPA | TPA-57908 | 2026-10-01T05:37:00Z | Amy | M. | Fernandez | 2005-10-02 | — | — | (521) 346-4198 | null | 8451 Willow Ct | Austin·· | TX | 78787 | — | ·null |
| TPA | TPA-57517 | 2026-03-19T21:29:55Z | RYAN | — | ·MENDOZA | 1985-06-19 | NULL | NULL | (554) 942-3880 | — | 3085 Baseline Road | Los Angeles | CA | 90052·· | - | — |
| TPA | TPA-57327 | 2026-07-31T02:48:33Z | HANNAH | — | MCDONALD | 1947-12-15 | UHC-37231-04 | null | 380.212.4342 | — | ·6505 Elm Street | TAMPA | FL | 33608 | — | NAVIGATE-HMO |
| TPA | TPA-59243 | 2026-08-19T15:45:09Z | Megan | ·V | Vazquez | 1977-08-06 | null | •••-••-7147 | - | UNKNOWN | 2485 Spring Street | Los Angeles | ·CA | 90048·· | GRP-3015 | null |
| TPA | TPA-56944 | 2026-05-27T08:26:20Z | Angela | R. | Contreras | 1969-10-20 | — | — | +1 451 265 6716 | UNKNOWN | - | — | UNKNOWN | — | null | NAVIGATE-HMO |
| TPA | TPA-57772 | 2026-05-10T09:33:28Z | Karen | — | Allen | 1986-09-15·· | UHC-05227-85 | •••-••-2968 | — | null | 3484 CEDAR LN | Los Angeles | CA | 90008 | GRP-3836 | UNKNOWN |
| TPA | TPA-51893 | 2026-09-29T12:17:13Z | Stephen | ·Y | Hicks | 03/01/2003 | UHC-10555-56 | UNKNOWN | NULL | stephen.hicks@gmail.com | 2494 Oak Street | Austin·· | TX | null | — | null |
| TPA | TPA-53987 | 2026-07-04T22:21:29Z | Kyle | — | Rosss | 1970-08-03 | null | UNKNOWN | NULL | - | 6425 BASELINE RD | Fresno | California | 93736 | — | — |
| TPA | TPA-61405 | 2026-07-18T20:31:17Z | Harold | — | Porer | 19420501 | — | — | — | null | 2658 Grand Avenue | GLENDALE | AZ | 85372 | null | N/A·· |
| TPA | TPA-58621 | 2026-06-25T12:34:58Z | Wagner, Rcahel | — | ·· | 02/28/1967 | null | •••-••-0495 | 6884301702 | null | 3551 Palm Drive | Columbus | OH | 43210 | UNKNOWN | NULL |
| TPA | TPA-62810 | 2026-03-16T17:32:31Z | Perry, Michelle | — | — | 1948-10-24 | UHC-36131-73 | — | — | - | ·4869 Hillcrest Rd | Chandler | AZ | 85286 | GRP-8701 | UNKNOWN |
| TPA | TPA-51226 | 2026-07-30T02:15:10Z | Alvarado, Mariana | — | — | 1988-05-19 | UNKNOWN | •••-••-9185 | 3708083444 | N/A | 24 Lake View Road | AUSTIN·· | TX | 78795 | — | MEDICARE-ADV-A·· |
| TPA | TPA-54948 | 2026-03-27T10:41:35Z | daniel | — | austin | 16-05-1967 | UNKNOWN | UNKNOWN | N/A | UNKNOWN | 7940 MESA DR | SCOTTSDALE·· | Arizona | 85248 | — | N/A |
| TPA | TPA-52217 | 2026-08-08T10:06:22Z | MARK | — | PALMER | Dec 25, 1984 | — | — | - | null | 1818 Main St | Jacksonville | FL | 32208 | null | — |
| TPA | TPA-59030 | 2026-10-10T03:23:30Z | PRIYA | — | GUTIERREZ | 2005-09-07 | — | - | ·UNKNOWN | - | 2606 Elm Street | CHARLOTTE | NC | 28279 | GRP-8513 | MEDICARE-ADV-A |
| TPA | TPA-51470 | 2026-07-11T03:42:59Z | Margaret·· | — | Daniels | 9167-05-01 | N/A | NULL | NULL | ·UNKNOWN | 6083 Canyon Road Apt 32 | Tucson | AZ | 85725-5965 | N/A | SELECT-EPO |
| TPA | TPA-59953 | 2026-05-12T16:16:28Z | Betty | ·· | Cox | 1944-01-01 | ·- | •••-••-4801 | 283-362-9998 | — | 3527 Central Avenue | JACKSONVILLE | FL | 32275 | - | — |
| TPA | TPA-53720 | 2026-04-29T16:13:25Z | Lewis, Cynthia | — | — | 07-05-1959 | — | null | - | null | 9721 APACHE BOULEVARD | Gilbert | Arizona | 85214 | NULL | OPTIONS-PPO |
| TPA | TPA-61198 | 2026-01-26T16:42:31Z | Juan | A | Graham | ·06/16/1938 | ·· | N/A | — | juan.graham@icloud.com | 4334 Harbor Boulevard | FRESNO | ca | 93733 | — | NULL |
| TPA | TPA-60368 | 2026-03-05T05:52:36Z | Hannah | ···· | Brooks | 04/20/1959 | null·· | UNKNOWN | 841-970-0136 | null | 6472 WASHINGTON ST | Jacksonville | FL | 32248 | GRP-2959 | OPTIONS-PPO |
| TPA | TPA-61071 | 2026-01-05T20:48:49Z | CYNTHIA | — | MCDONALD | 1972-05-10 | UNKNOWN·· | •••-••-5173 | N/A | — | 1243 Bayshore Dr | Denver | CO | 80265 | GRP-4230 | — |
| TPA | TPA-62768 | 2026-10-16T02:08:54Z | BARBARA·· | — | WEBER | 19480125 | null | — | (349) 906-0415 | null | NULL | — | UNKNOWN | N/A | GRP-5437 | — |
| TPA | TPA-52648 | 2026-08-07T06:32:19Z | Cheryl | — | Torres | Feb 26, 1995 | - | — | 18975129326 | UNKNOWN | 3902 BASELINE ROAD | Gilbert | AZ | 85223 | GRP-2976 | OPTIONS-PPO |
| TPA | TPA-55729 | 2026-03-29T03:16:46Z | GEORGE | — | MCCOY | 19940925 | UNKNOWN·· | — | UNKNOWN | N/A | 8944 CEDAR LN | Orlando | FL | ·32896-8070 | null | CORE-HMO |
| TPA | TPA-61814 | 2026-01-30T06:40:43Z | Henry | — | Moore | May 4, 1968 | UHC-30985-92 | ·N/A | (826) 902-6935 | henry.moore@proton.me | — | NULL | - | null | GRP-0100 | UNKNOWN |
| TPA | TPA-52460 | 2026-02-20T08:26:10Z | JEAN | — | MILLS | 1961-04-07 | null | •••-••-0759 | N/A | N/A | 6528 Grand Avenue | COLUMBUS | OH | 43232 | UNKNOWN | — |
| TPA | TPA-61767 | 2026-05-30T20:32:05Z | JULIE | — | HART | 1940-08-25 | UNKNOWN | null | - | julie.hart@yahoo.com | 3705 Harbor Boulevard | Mesa | ·AZ | 85245 | GRP-5217 | — |
| TPA | TPA-54942 | 2026-02-01T02:19:06Z | JESSICA | C | VARGAS | 1971-11-27 | ···· | N/A | 4826481 | null | 4014 SUNSET BOULEVARD | GLENDALE | az | 85329 | — | - |
| TPA | TPA-58999 | 2026-06-26T02:05:56Z | Kelly | Y | Burns | 07/07/41 | — | •••-••-4602 | ·2583046592 | — | — | N/A | null | — | — | SELECT-EPO |
| TPA | TPA-54738 | 2026-01-11T05:32:11Z | Billy | — | Luna | 1946-12-10 | — | ·· | (929) 323-8468 | UNKNOWN·· | N/A | — | — | - | — | CHOICE-PLUS-PPO |
| TPA | TPA-56705 | 2026-02-09T02:26:28Z | GERALD | — | HOWELL | 12/14/1948 | — | — | (436) 273-4873 | NULL | - | — | — | null | GRP-8602 | CHOICE-PLUS-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:37.768Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty