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
Provider network only, ordered by line number
| Source | Record | Received | First | Middle | Last | DOB | Member ID | SSN | Phone | Address | City | State | ZIP | Group | Plan | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| PRV | PRV-23954 | 2026-06-23T15:51:02Z | Theresa | S | McDonald | 1945-11-19 | - | — | 7229876265·· | theresa.mcdonald69@gmail.com | ·9572 Baseline Road | Glendale | AZ | 85332 | null | UNKNOWN |
| PRV | PRV-26867 | 2026-06-21T15:21:35Z | SEAN | S | JAMES | 1978-05-06 | — | — | +1 911 275 7314 | NULL | 7309 Mountain View Dr | Tucson | AZ | 85758 | null | — |
| PRV | PRV-25653 | 2026-01-14T01:03:16Z | ELIZABETH | — | SIMMONS | 1985-06-17 | NULL | UNKNOWN | +1 925 765 3754 | — | 9041 Baseline Rd | Fresno | CA | - | — | — |
| PRV | PRV-26468 | 2026-02-01T11:26:35Z | Howard, Nancy | — | — | 19940207 | UHC-08853-29 | null | 3806422553 | — | 1720 WILLOW COURT | Las Vegas | ·NV | 89112 | UNKNOWN | - |
| PRV | PRV-24681 | 2026-08-24T23:36:41Z | Jeremy | U. | Duncan | 1969-05-17 | UHC6411648 | N/A | 756-893-0325 | UNKNOWN | 6026 Main Street | Fresno | CA | 93731 | — | ···· |
| PRV | PRV-27285 | 2026-06-27T12:51:46Z | Elliott, Sam·· | — | — | 3/17/1990 | UHC-79245-67 | •••-••-2364 | (311) 268-6874 | null | 6721 Sunset Blvd Apt 34 | Las Vegas | NV | 89105 | null | - |
| PRV | PRV-28173 | 2026-09-04T10:44:03Z | Johnson, Nancy | Y | — | 1982-09-21 | NULL·· | - | (739) 375-0301 | nancy.johnson@proton.me | 5070 Mountain View Drive | Atlanta | GA | 30375-2028 | — | UNKNOWN·· |
| PRV | PRV-26192 | 2026-03-23T22:05:07Z | Geerald | T | Larson | 1986-02-15 | N/A | — | 443-515-3502 | — | 8163 VALLEY VIEW DRIVE | ATLANTA | GA·· | 30381 | null | — |
| PRV | PRV-29225 | 2026-05-07T17:31:40Z | Maosn | Q·· | Stone | 1983-10-10 | NULL | •••-••-6524 | N/A | mason.stone@hotmail.com·· | 5591 Park Place | Glendale | AZ | 85392-9850 | — | UNKNOWN |
| PRV | PRV-22290 | 2026-04-15T03:25:19Z | CARLOS | — | HAMILTON | 1/21/1956 | UHC-99654-35 | — | +1 642 413 2000 | N/A | 7313 Desert Sky Boulevard | Tampa·· | FL | 33635 | NULL | N/A |
| PRV | PRV-28281 | 2026-03-08T11:48:53Z | CHRISTINA | — | DIAZ | 1980-06-18 | — | — | 339-711-0595 | ·UNKNOWN | 6501 Baseline Road | Orlando | FL | 32822 | NULL | — |
| PRV | PRV-27710 | 2026-08-06T20:24:15Z | Timothy | — | Stevens | 10/25/2003·· | UHC-96853-72 | •••-••-0136 | ·+1 896 307 5838 | timothy.stevens69@icloud.com | 6676 RIVER ROAD | Miami | FL | 33103 | N/A | UNKNOWN |
| PRV | PRV-26539 | 2026-02-27T05:00:30Z | bobby | — | sandoval·· | Apr 3, 1957 | UHC-01331-40·· | UNKNOWN | 690-951-6499 | - | 8910 Harbor Blvd | CHARLOTTE | North Carolina | 28245·· | N/A | UNKNOWN |
| PRV | PRV-20198 | 2026-07-13T05:27:06Z | ARJUN | — | LUCAS | ·Mar 9, 1993 | UHC-83630-69 | •••-••-6831 | 12897502616 | UNKNOWN | 7452 INDIAN SCHOOL RD | Nashville | TN | 37237 | — | — |
| PRV | PRV-26102 | 2026-02-20T20:48:03Z | Estrada, Natalie | — | — | 5/17/1938 | UHC-84399-83 | - | 4355169604 | null | 8742 Church St | Fresno | CA | 93739 | - | — |
| PRV | PRV-23652 | 2026-10-03T07:34:23Z | Justin | — | Rodriguez | 1981-01-25 | — | UNKNOWN·· | 12034768363 | UNKNOWN·· | 5750 Desert Sky Boulevard | Dallas | TX | 75286 | ·- | — |
| PRV | PRV-26744 | 2026-08-29T14:07:53Z | Cheryl | — | Barnes | 10/02/66·· | UHC-88098-43 | null | +1 784 218 4408 | NULL | 6986 Mountain View Drive | Tempe | AZ | 85286-4988 | - | null |
| PRV | PRV-24698 | 2026-02-10T18:40:07Z | ABIGAIL | P | ·HARRISON | 4/21/1940·· | — | •••-••-4927 | — | N/A | N/A | N/A | — | — | — | CHOICE-PLUS-PPO |
| PRV | PRV-25566 | 2026-09-16T00:58:04Z | Willie | — | Walsh | 1986-02-01 | ·UNKNOWN | NULL | ·542-362-6204 | null | 408 Sage Ct | Scottsdale | AZ | 85249 | ···· | NULL |
| PRV | PRV-27273 | 2026-06-04T03:26:47Z | Jerry | — | Jordan | 1997-06-11 | UHC-64857-05 | •••-••-8903 | +1 967 241 5441 | N/A | 2771 Spring Street Apt 17 | Tempe | AZ | 85244 | UNKNOWN | — |
| PRV | PRV-27106 | 2026-07-18T01:10:36Z | Gerald | — | Ellis | 28-07-1997 | UHC-40481-26 | •••-••-9957 | UNKNOWN | gerald.ellis32@outlook.com | 3286 WASHINGTON ST | Phoenix | az | 85033 | - | OPTIONS-PPO |
| PRV | PRV-27217 | 2026-07-20T00:36:00Z | Theresa | ·K | Knight | 1975-05-06 | UHC-65748-45 | N/A | 12818037645 | — | 7122 Mountain View Dr | ·Tampa | FL | 33697 | NULL | null |
| PRV | PRV-23958 | 2026-09-10T12:20:56Z | justin | — | franklin | 19850914 | UHC-39521-81 | •••-••-4025 | null | — | 1730 Sage Court | Atlanta | GA | 30378 | — | — |
| PRV | PRV-26666 | 2026-09-07T20:01:48Z | Bruce | ···· | Clark | 05/02/90 | UHC-63878-37 | •••-••-8887 | (864) 409-3656 | - | 2717 OCEAN AVENUE | Houston | TX | 77077 | NULL | — |
| PRV | PRV-20088 | 2026-07-07T05:43:01Z | Ben | K | Flores | 12/08/1965 | UNKNOWN | N/A | NULL | ···· | 735 Central Ave | GILBERT | AZ | 85217·· | - | — |
| PRV | PRV-20720 | 2026-04-06T03:59:01Z | Brandon | — | Rivera | 2006-08-16·· | UHC-83841-16 | — | — | — | 4526 Jefferson Avenue | GILBERT | AZ | 85280-8873 | UNKNOWN | CORE-HMO |
| PRV | PRV-25026 | 2026-01-03T23:09:04Z | Gregory | U | Woods | 03/11/98 | - | - | 8544162356 | UNKNOWN·· | 2736 Oak St | SAN DIEGO | CA | 92136 | — | N/A |
| PRV | PRV-28899 | 2026-06-24T06:13:27Z | ·ROGER | — | ·BAILEY | 1992-01-21 | NULL | — | N/A·· | roger.bailey@aol.com | 6556 Willow Ct | Denver | CO·· | 80238-6835 | UNKNOWN | UNKNOWN |
| PRV | PRV-22908 | 2026-04-30T20:28:25Z | TIMOTHY | O. | LUCAS | 2/26/1939 | UHC6576708 | •••-••-3152 | 795-358-0222 | — | ·6117 Grand Avenue | Las Vegas | NV | 89171 | NULL | NULL |
| PRV | PRV-21623 | 2026-01-10T12:33:33Z | Omar | — | Richardson | 1941-06-13 | — | — | — | - | UNKNOWN | NULL·· | UNKNOWN | ·N/A | — | N/A |
| PRV | PRV-23045 | 2026-01-17T09:25:25Z | Patterson, Marilyn | I. | — | 1997-01-05 | UHC-43471-66 | — | 568-874-4256 | NULL | NULL | N/A | N/A | null | — | MEDICARE-ADV-A |
| PRV | PRV-28271 | 2026-03-25T10:21:26Z | Baker, Jesse | — | — | 1985-01-05 | NULL | null | 3199329132 | JESSE.BAKER73@OUTLOOK.COM | null | NULL | — | - | ·· | — |
| PRV | PRV-20505 | 2026-01-21T05:36:27Z | Amy·· | — | Castillo | 2/15/1959 | UHC-48609-92 | — | — | UNKNOWN | 3513 Lincoln Way | Scottsdale | Arizona | N/A | - | — |
| PRV | PRV-20432 | 2026-06-12T08:03:30Z | ·DANIEL | — | STEPHENS | 1991-01-12 | UHC-83301-02 | — | (982) 425-5742 | NULL | 3320 Sunset Blvd | DENVER·· | CO | 80259 | UNKNOWN | OPTIONS-PPO |
| PRV | PRV-24678 | 2026-09-25T08:57:45Z | Omar | — | Dunn | ·1981-11-14 | UHC-59784-86 | — | 947-801-4741 | NULL | 5238 Union Street | Chandler | AZ | 85230 | NULL | — |
| PRV | PRV-26353 | 2026-09-10T19:03:38Z | LUNA | — | GREGORY | 1953-02-15 | UHC-66734-89 | NULL | (235) 526-8108 | ·NULL | - | UNKNOWN | NULL | — | UNKNOWN | UNKNOWN |
| PRV | PRV-24651 | 2026-08-29T20:03:09Z | Lucia | W | Russell | 2001-11-13·· | UNKNOWN | — | 659.564.9114 | — | 3497 Oak St | Tampa | FL | 33652 | — | - |
| PRV | PRV-21142 | 2026-06-28T05:17:02Z | Valentina | — | Saalazar | 1971-07-20 | UHC-13048-68 | null | (755) 826-3969 | UNKNOWN | 7124 Desert Sky Boulevard | Charlotte | North Carolina | 28265 | NULL | — |
| PRV | PRV-28542 | 2026-07-07T13:25:53Z | Yuki | O | Maldonado·· | 1980-05-26 | NULL | N/A | (680) 678-5902 | UNKNOWN·· | 647 CHURCH ST | Orlando | FL | 32802-8249 | NULL | CHOICE-PLUS-PPO |
| PRV | PRV-22060 | 2026-10-11T15:20:30Z | JESSE | — | HUDSON | 1973-08-21 | ···· | NULL | 800.692.8238 | — | 7065 Lincoln Way | ·LOS ANGELES | CA | 90025 | ···· | - |
| PRV | PRV-20630 | 2026-10-09T12:46:43Z | Luis·· | — | Sullivan | 02/09/43 | UHC-42957-58 | — | 2826340299 | LUIS.SULLIVAN@GMAIL.COM·· | 2265 Maple Ave | LOS ANGELES | CA | 90010 | — | ·CORE-HMO |
| PRV | PRV-22606 | 2026-04-28T23:55:13Z | Armstrong, Judith | — | — | 1989-03-13 | UHC-29429-16 | — | 512-713-1909 | NULL | 6268 River Road | Houston | TX·· | 77022 | - | — |
| PRV | PRV-20350 | 2026-05-12T21:09:22Z | MARTHA | — | PADILLA | 19400126 | UHC-51567-53·· | - | 13902255298 | ·NULL | 3228 River Rd | Tempe | AZ | 85202-2802 | — | N/A |
| PRV | PRV-25703 | 2026-07-23T22:15:22Z | jeff | — | lane | 1940-09-24 | UHC-27279-65 | — | ·499.459.8239 | NULL | N/A | NULL | — | null | - | MEDICARE-ADV-A |
| PRV | PRV-27213 | 2026-10-09T10:56:57Z | Kenneth | — | Diaz | 2000-11-09 | — | UNKNOWN | +1 852 454 6088 | NULL | 5393 Mountain View Dr | Orlando | FL | 32874 | — | OPTIONS-PPO |
| PRV | PRV-20645 | 2026-02-06T16:58:53Z | KATHERINE | — | BOWMAN | 1957-01-08 | null | ·· | (770) 630-8355 | — | NULL | - | NULL | N/A | — | NULL |
| PRV | PRV-24539 | 2026-02-03T02:46:52Z | Mariana | R | Valdez | 1982-11-22 | null | UNKNOWN·· | 9142666728 | MARIANA.VALDEZ31@HOTMAIL.COM | 1961 Apache Boulevard | Dallas·· | TX | 75267 | - | — |
| PRV | PRV-28383 | 2026-07-02T22:27:39Z | Carter·· | — | Megan | 1980-10-13 | UHC6631214 | null·· | 606.903.8480 | megan.carter10@icloud.com | 4534 Forest Ave | San Diego | CA | 92152 | ·null | OPTIONS-PPO |
| PRV | PRV-28292 | 2026-05-11T05:12:39Z | Cynthia | T | Lawrence | Feb 2, 1954 | null | null | UNKNOWN | NULL·· | 8533 HARBOR BLVD | Denver | CO | 80256-9257 | - | — |
| PRV | PRV-28493 | 2026-07-16T08:56:13Z | ·William | ·· | Carpenter | 19480603 | UHC-01255-44 | — | 9302277992 | null | 9388 Market St | Tempe | AZ | 85270 | NULL | 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:42:37.763Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty