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-22236 | 2026-01-20T08:20:03Z | Janet | — | Hernadnez | 20080315 | UNKNOWN | — | 9149804428 | UNKNOWN | ·1444 INDIAN SCHOOL RD | Fresno | CA·· | 93784 | — | MEDICARE-ADV-B |
| PRV | PRV-21681 | 2026-02-02T01:52:25Z | Ahmed | — | Munoz | ·1980-06-16 | ·UNKNOWN | •••-••-9354 | (382) 776-4197 | N/A | 3355 River Road | Plano | TX | 75054 | — | MEDICARE-ADV-A |
| PRV | PRV-28181 | 2026-04-11T03:31:47Z | STEPEN | — | HOLMES | 1962-07-06 | ·UHC1430830 | - | 16882860067·· | -·· | 3832 Meadow Ln | Scottsdale | AZ | 85242-1260 | UNKNOWN | — |
| PRV | PRV-23119 | 2026-02-13T11:31:28Z | Gacia, Aaron | — | — | 04/27/1963 | — | N/A | 7519765126 | aaron.garcia53@yahoo.com | 7813 Desert Sky Blvd·· | Minneapolis | Minnesota·· | 55424 | - | UNKNOWN |
| PRV | PRV-25417 | 2026-02-04T20:16:49Z | Edward·· | ···· | Allen | Oct 20, 1940 | UHC-76827-89·· | - | 3517431183 | — | 1379 Canyon Road·· | Eden Prairie | MN | 55372 | — | OPTIONS-PPO |
| PRV | PRV-20490 | 2026-07-31T15:47:33Z | Cahpman, Gloria | — | — | 1945-07-20 | UHC-02870-23 | — | 6343153093 | gloria.chapman@aol.com | 9217 Elm St | PHOENIX·· | AZ | N/A | — | NULL |
| PRV | PRV-20620 | 2026-04-28T23:43:21Z | ANTHONY | — | GRAY | 1947-05-21 | - | -·· | 4984169169 | — | 3721 PARK PL | Miami | Florida | 33102 | — | UNKNOWN |
| PRV | PRV-21488 | 2026-04-28T04:26:00Z | SARA | W | PENA | 19570318 | UHC-34572-90 | N/A·· | 620-275-5766 | sara.pena@aol.com | 1798 River Rd | Tampa | FL | 33694 | — | ···· |
| PRV | PRV-28765 | 2026-02-21T06:51:35Z | Ahmed | J | Singh | N/A | null | •••-••-8190 | NULL | ahmed.singh@proton.me·· | 8556 Apache Boulevard | Plano | TX | — | — | NULL |
| PRV | PRV-28395 | 2026-07-01T23:08:29Z | BRITTANY | — | FULLER | 1965-12-07 | UHC-81567-13 | null·· | 554-387-4972 | N/A | 799 Elm Street | ·LAS VEGAS | nv | 89109 | NULL | NULL |
| PRV | PRV-24934 | 2026-03-26T01:05:45Z | Roy | — | Price | 03/25/1981 | UHC-50198-86 | •••-••-0147 | 6354591976 | -·· | 9852 Grand Avenue | Houston | TX | 77076 | — | CHOICE-PLUS-PPO |
| PRV | PRV-29559 | 2026-08-08T15:43:03Z | Joe | L. | Fields | 1938-04-04 | NULL | — | 4577211227 | — | ·UNKNOWN | — | null·· | — | NULL | null |
| PRV | PRV-27693 | 2026-02-28T11:05:03Z | DONALD | O. | WASHINGGTON | 02/07/1999 | UNKNOWN | null | 753-745-1819 | donald.washington@proton.me | 732 Church Street | Glendale | AZ | 85315 | NULL | NULL |
| PRV | PRV-28970 | 2026-08-05T09:31:30Z | Edward | — | Boyd | 2003-11-09 | null | null | (717) 333-8374 | — | 8783 Willow Court | San Diego | California | 92123 | NULL | SELECT-EPO |
| PRV | PRV-26261 | 2026-01-06T11:13:16Z | brittany | — | mendez·· | 27-05-1946 | null | UNKNOWN | 9825017689 | brittany.mendez@hotmail.com | 5701 Baseline Road·· | Columbus | OH | 43234 | NULL | — |
| PRV | PRV-22802 | 2026-03-05T03:19:43Z | AISHA | — | STEPHENS | 4/17/1996 | UHC-23263-89 | — | 7065044094 | — | null | — | — | — | NULL | — |
| PRV | PRV-23636 | 2026-06-22T08:13:14Z | Denyse | Y. | Price | 1939-12-27 | UHC-27721-07 | — | 458-959-3879 | N/A | 8071 Desert Sky Boulevard | SEATTLE | WA | 98119 | UNKNOWN | ···· |
| PRV | PRV-26058 | 2026-02-05T09:08:47Z | Samantha | — | Hawkins | 1964-06-19 | N/A | N/A | (407) 934-8722 | ·· | 3752 Grand Ave | TEMPE | AZ | 85247·· | ·· | UNKNOWN |
| PRV | PRV-27080 | 2026-09-18T09:42:14Z | Salazar, Susan | — | — | 1966-12-23 | — | — | (743) 686-0152 | — | 1616 SUNSET BLVD | Glendale | AZ | 85383 | N/A | ···· |
| PRV | PRV-24012 | 2026-01-19T13:21:36Z | Cook, Theresa | A | — | 1987-01-13 | — | - | 4992485697 | theresa.cook@yahoo.com | 8803 Mountain View Drive #687 | Denver | CO | 80297-7084 | — | NULL |
| PRV | PRV-29157 | 2026-01-26T04:12:36Z | Angela | — | Murray | 1987-06-24 | UHC-29472-03 | N/A | 4487160206 | angela.murray99@icloud.com | 6807 CEDAR LANE | Austin·· | Texas | 78788·· | N/A | NULL |
| PRV | PRV-23481 | 2026-09-14T20:49:12Z | FRANCES | Y | CARTER·· | 1961-01-06 | UHC-52031-78 | NULL | ·2495772154 | null | 2331 LINCOLN WAY | Charlotte | NC | ·N/A | — | ·N/A |
| PRV | PRV-21667 | 2026-06-11T07:59:00Z | Herrera, Daniel | — | — | 1975-02-05 | null | NULL | ·(508) 720-2685 | daniel.herrera16@gmail.com | 8261 Broadway | GILBERT | ·AZ | 85219 | UNKNOWN | — |
| PRV | PRV-23730 | 2026-02-04T16:50:05Z | Barbara | — | Boyd | 1966-09-24 | UHC-51193-31 | NULL | 633-614-6338 | NULL | 9280 VALLEY VIEW DR | Las Vegas | NV | 89118 | — | — |
| PRV | PRV-23194 | 2026-07-08T02:03:56Z | Susan | — | Hayes | 1957-09-13 | UHC-57014-25 | - | 228.757.0186 | N/A | 2422 SUNSET BOULEVARD | ·Phoenix | AZ | 85053-1574 | N/A | — |
| PRV | PRV-22698 | 2026-02-22T16:37:12Z | Nicholas | ·· | Patterson·· | 1974-12-05 | UNKNOWN | null | N/A | — | 9852 Washington Street Apt 34 | Tempe | AZ | ·85259 | - | select-epo |
| PRV | PRV-26240 | 2026-06-04T14:01:15Z | Thompson, Sofia | — | — | ·1987-07-21 | — | NULL | (643) 931-3066 | NULL | 4099 Willow Ct | Charlotte | NC | 28268 | UNKNOWN | — |
| PRV | PRV-21473 | 2026-08-19T21:55:03Z | judith | — | lopez | May 16, 2002 | UHC-84948-25 | — | (330) 727-0584 | — | 9047 Broadway | Glendale | AZ | 85316 | null | OPTIONS-PPO |
| PRV | PRV-23367 | 2026-04-15T21:11:52Z | Walker, Douglsa | — | — | 06/08/93 | UHC-39642-73 | •••-••-7685 | (588) 927-7270 | — | ·1960 OCEAN AVENUE | Tampa·· | FL | 33610 | N/A | ·UNKNOWN |
| PRV | PRV-27818 | 2026-06-14T07:16:33Z | denise | — | smith | 1962-02-23 | ···· | NULL | +1 772 246 4564 | — | 3876 Baseline Road | Tucson | AZ | 85705 | UNKNOWN | MEDICARE-ADV-A |
| PRV | PRV-27812 | 2026-02-16T06:34:13Z | Thomas | — | Sims | 03/19/1971 | — | — | 19817131418 | — | 4750 Grand Ave | Orlando | FL | 32898 | N/A | NULL |
| PRV | PRV-22189 | 2026-01-15T07:13:50Z | Jack | — | Kelly | ·8/10/1984 | UHC-72971-02 | — | ·(358) 236-9506 | jack.kelly39@gmail.com | 8029 Willow Court | San Antonio | TX·· | 78230 | null | CHOICE-PLUS-PPO |
| PRV | PRV-23107 | 2026-04-16T16:41:37Z | Brittany | Q. | Fowler | 1948-04-11 | NULL | — | 7738311115 | ·UNKNOWN | 4303 LAKE VIEW RD | San Antonio | tx | 78274-0755 | UNKNOWN | — |
| PRV | PRV-23090 | 2026-08-23T19:18:47Z | Ethan | — | Lopez | 1983-05-12 | UHC-27810-97 | N/A | 705-680-4337 | ethan.lopez16@yahoo.com | 7340 Palm Dr | Fresno | CA | — | — | MEDICARE-ADV-A |
| PRV | PRV-20479 | 2026-02-09T08:16:53Z | Jhn | — | Graham | 1982-06-14 | — | null | (326) 785-4971 | N/A | 719 Central Ave | Tampa | FL | 33657 | NULL | — |
| PRV | PRV-23168 | 2026-05-11T20:16:31Z | Fatima·· | — | Harris | Jul 21, 1993 | null | N/A | 872-787-4024 | fatima.harris@aol.com | 9585 Oak Street | Tampa | FL | ·33629 | — | UNKNOWN |
| PRV | PRV-20957 | 2026-04-16T02:38:49Z | boby | — | martinez | 1963-09-25 | N/A | — | UNKNOWN | bobby.martinez52@gmail.com | 2233 MOUNTAIN VIEW DR | Atlanta | Georgia | 30388 | UNKNOWN | — |
| PRV | PRV-20449 | 2026-07-22T19:41:26Z | Sam | — | Hayes | 1995-70-12 | UHC-36765-49 | — | (362) 929-7240 | ·· | 2104 OCEAN AVENUE | JACKSONVILLE | ·FL | N/A | N/A | — |
| PRV | PRV-26271 | 2026-03-30T12:22:57Z | VICTORIA | — | ·ESTRADA | 18-09-1995 | UHC-18975-43 | •••-••-2934 | ·N/A | — | 1939 PARK PLACE Apt 19 | SEATTLE | Washington | 98124 | null | N/A |
| PRV | PRV-20579 | 2026-07-26T09:17:01Z | NATHAN | — | BROOKS | 1492-11-26 | N/A·· | — | +1 787 638 3278 | — | 5065 Meadow Ln·· | Charlotte | North Carolina | 28284 | ·NULL | NULL |
| PRV | PRV-29129 | 2026-01-05T01:21:29Z | SUSAN·· | — | CONTRERAS | 1963-04-01 | UHC-06057-20 | NULL | 562-322-8934 | susan.contreras22@proton.me | 7437 SAGE CT | Columbus | oh | 43295 | - | — |
| PRV | PRV-29009 | 2026-07-07T15:16:41Z | Ana·· | — | Vargas | 1939-05-27 | NULL | UNKNOWN | 3518972153 | ana.vargas@icloud.com | 2692 Pine Dr·· | Scottsdale | AZ | 85252-1378 | null | SELECT-EPO |
| PRV | PRV-22791 | 2026-09-11T10:03:07Z | Stephen | K | Sto | 1940-05-05 | UHC-60749-62 | — | (954) 515-7177 | null | 3987 Sage Ct | COLUMBUS | OH | 43295 | N/A | ···· |
| PRV | PRV-26946 | 2026-01-21T16:50:09Z | Laura | — | Vega | 04/18/1993·· | UHC-91483-51 | null | 2867308406·· | NULL | 7141 Palm Dr | Atlanta | GA | 30345 | — | — |
| PRV | PRV-20995 | 2026-08-27T11:06:34Z | Pamela | — | Fuller | 11/6/1946 | UHC-53055-98 | — | 772-895-9546 | pamela.fuller7@aol.com | 3164 Hillcrest Road | Gilbert | AZ | 85248 | N/A | — |
| PRV | PRV-24846 | 2026-03-08T04:40:43Z | GERALD | — | ELLIS | 1986-06-11 | UHC-73134-35 | — | (410) 358-8512 | gerald.ellis56@yahoo.com | 589 Mountain View Drive | TEMPE | AZ | 85252 | — | UNKNOWN |
| PRV | PRV-24555 | 2026-08-04T10:44:07Z | SAMUEL | — | CASTRO | 1975-05-08 | UNKNOWN·· | — | N/A | ·· | 5853 Market Street | Fresno | CA | 93729 | ···· | — |
| PRV | PRV-26300 | 2026-07-30T22:58:07Z | Donald | M. | Palmer | 1991-01-10 | NULL | •••-••-1941 | -·· | UNKNOWN | 1789 Valley View Drive | Sacramento | CA | 95857 | ···· | - |
| PRV | PRV-20523 | 2026-04-07T01:27:40Z | BETTY | — | YUONG | 1987-10-28 | UHC-02259-50 | null | 778.248.5860 | N/A | 8656 Sunset Boulevard | Phoenix | AZ | N/A | N/A | — |
| PRV | PRV-20534 | 2026-03-12T21:38:03Z | David | — | Turner | 17-04-1940 | UHC-15533-67 | — | 733-399-5098 | david.turner@outlook.com | 9519 JEFFERSON AVENUE | Charlotte | NC | 28209 | — | - |
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.345Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty