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-23542 | 2026-08-17T09:38:59Z | Richards, Thomas | — | — | 1945-02-21 | UHC-76708-28 | UNKNOWN | ·9742960653 | — | 4221 Oak St | Las Vegas·· | NV | ·89129 | - | OPTIONS-PPO |
| PRV | PRV-22853 | 2026-03-19T21:00:01Z | Richards, Marilyn | ·· | — | 8/16/1987 | UHC-81335-20 | ···· | 3277357547 | N/A | 9496 Church Street Apt 6 | Las Vegas·· | NV | ·89160 | ·· | NULL |
| PRV | PRV-25541 | 2026-07-23T14:55:05Z | HEATHER | — | MITCHELL | 10/22/1979·· | UHC-85304-14 | null | +1 315 723 9515 | UNKNOWN | 9293 Apache Boulevard Apt 12 | Chandler | AZ | 85240 | — | — |
| PRV | PRV-26634 | 2026-07-06T18:19:33Z | Donna | — | Miller | 04/07/1941 | - | UNKNOWN | (244) 221-3102·· | - | 4906 Canyon Road | Jacksonville | FL | 32202-9963 | — | NULL |
| PRV | PRV-21176 | 2026-08-13T15:54:27Z | Richard | ·· | Matthews | 27-07-1958 | null | — | 894-579-4523 | — | 276 RIDGE RD | ORLANDO | FL | 32857 | null | OPTIONS-PPO |
| PRV | PRV-28186 | 2026-01-29T04:21:37Z | Emma | — | Clark | 2005-11-07 | UHC-74207-75 | N/A | 7826977088 | UNKNOWN | 8762 River Rd #169 | PHOENIX | AZ | 85083 | — | N/A |
| PRV | PRV-25980 | 2026-09-20T22:23:54Z | GRACE | ·· | SHAW | ·1961-11-20 | UHC4933806 | •••-••-9685 | (338) 861-9459 | ·grace.shaw@proton.me | 3793 Market Street | Seattle | WA | ·98139-5510 | NULL | UNKNOWN |
| PRV | PRV-29416 | 2026-04-17T20:28:35Z | Harold | — | Hart | 04/11/94 | UHC3634842 | ·UNKNOWN | (600) 232-9636 | — | 2280 VALLEY VIEW DR | Fresno | CA | 93746 | N/A | CORE-HMO |
| PRV | PRV-29485 | 2026-09-01T19:39:28Z | Gibson, Cheryl | — | — | 1999-05-15 | null | - | 294-481-9018 | - | 6044 WILLOW CT | Los Angeles | CA | 90080 | — | N/A |
| PRV | PRV-21914 | 2026-06-24T21:42:30Z | MELISSA | Q | MONTGOMERY | 1985-02-11 | — | UNKNOWN | (398) 528-4849 | — | 1611 Spring St | Plano | TX | UNKNOWN | null | UNKNOWN |
| PRV | PRV-28285 | 2026-07-05T02:11:43Z | catherine | T. | taylor | 11/26/42 | — | - | 961-533-3401 | UNKNOWN | 7794 Park Pl | Las Vegas | NV | 89146 | — | - |
| PRV | PRV-28149 | 2026-01-13T17:16:35Z | ANN | — | DEAN | 1959-06-13 | N/A | •••-••-3407 | +1 257 946 6641 | — | 22 Spring St | Chandler | AZ | 85257 | — | - |
| PRV | PRV-23945 | 2026-07-17T14:14:58Z | NATALIE | — | BELL | 03/27/05 | UHC-15700-52 | •••-••-5995 | 2149450989 | natalie.bell87@yahoo.com | N/A | N/A | N/A·· | NULL | — | NULL |
| PRV | PRV-20728 | 2026-04-25T09:02:33Z | BRANDON | — | JENKINS | 19940801 | N/A | null | 655-934-8279 | — | 1660 Palm Drive | Scottsdale | AZ·· | 85209 | UNKNOWN | NULL |
| PRV | PRV-27364 | 2026-05-12T20:49:35Z | NICK | — | ARNOLD | Jun 27, 1980 | N/A | N/A | (653) 957-0181 | N/A | 9623 FOREST AVE | Chandler | AZ | 85259 | - | - |
| PRV | PRV-24493 | 2026-08-29T21:01:11Z | samuel | — | robinson | 26-03-1966 | UHC-35425-74 | NULL | 2562179642 | - | 944 Hillcrest Rd | LOS ANGELES | CA | 90080 | UNKNOWN | — |
| PRV | PRV-27719 | 2026-08-27T23:11:10Z | Lisa | I | Wood | 1938-11-08 | UHC-20238-58 | — | (951) 831-9663 | — | 7709 MEADOW LN | Glendale | AZ | 85369 | — | SELECT-EPO |
| PRV | PRV-26167 | 2026-03-25T05:05:49Z | SAM | — | JONES | 1956-09-12 | — | UNKNOWN | NULL | — | 8027 UNION ST | Tucson | Arizona | 85787 | NULL | ·NAVIGATE-HMO |
| PRV | PRV-23941 | 2026-03-03T07:30:47Z | Gloria | — | Bukre | 1918-11-07 | — | — | 393-343-9367 | — | 8287 Valley View Drive | Tucson | AZ | 85728 | NULL | — |
| PRV | PRV-23406 | 2026-01-17T13:54:06Z | JORDAN | — | PERKINS | 03/03/1951 | UHC-84504-72 | - | 9474822634 | — | — | null | — | — | N/A | MEDICARE-ADV-B |
| PRV | PRV-27314 | 2026-04-07T20:01:33Z | Nicole | — | Gilbert | 01/25/51 | UHC9348942 | - | (770) 281-8360 | NICOLE.GILBERT@OUTLOOK.COM | 6879 MARKET STREET·· | Orlando | Florida | 32853·· | UNKNOWN | NAVIGATE-HMO |
| PRV | PRV-20363 | 2026-06-15T18:10:41Z | Terry | — | Fox | 2007-08-14 | UHC-25927-17 | — | (585) 539-1901 | — | 5658 Maple Ave | Las Vegas | NV | 89181 | null | null |
| PRV | PRV-25812 | 2026-07-28T03:24:08Z | Christian | — | Mills·· | 2004-07-14 | UHC-15038-45 | •••-••-3622 | (439) 728-3020 | CHRISTIAN.MILLS@GMAIL.COM | 4462 Jefferson Ave | Charlotte | NC | 28223 | — | - |
| PRV | PRV-21029 | 2026-01-13T05:21:43Z | CHRISTIAN | ·· | PEREZ | 19780111 | UHC4711340·· | — | N/A | christian.perez61@yahoo.com | 9660 Grand Ave Apt 35 | Tempe | az | 85211 | NULL·· | — |
| PRV | PRV-22122 | 2026-03-25T08:57:15Z | David | — | Weaver | 1967-12-12 | null | — | N/A | NULL | 6824 Elm St | Orlando | FL | 32867 | — | — |
| PRV | PRV-25955 | 2026-06-02T05:13:38Z | LAURA·· | H | COOPER | 2007-11-04 | - | •••-••-6845 | 359-656-4023 | UNKNOWN | 1831 Willow Court Apt 19 | San Diego | CA | 92106 | — | UNKNOWN |
| PRV | PRV-25858 | 2026-06-15T20:15:34Z | MARIANA | — | GUZMAN | 1954-06-03 | — | UNKNOWN | (657) 746-0469 | N/A | 3575 Hillcrest Road #161 | COLUMBUS | oh | ·43266 | — | — |
| PRV | PRV-28166 | 2026-09-25T06:01:31Z | JACQUELINE | — | YOUNG | 1991-01-01 | NULL | null·· | +1 419 569 6266 | JACQUELINE.YOUNG@AOL.COM | 5721 Valley View Drive | Gilbert | AZ | 85223 | null | — |
| PRV | PRV-22712 | 2026-08-26T11:25:05Z | Jean | X. | Butler | 1998-12-11 | UHC-71890-62 | — | +1 923 270 5573 | JEAN.BUTLER@HOTMAIL.COM | ·4831 Apache Boulevard | LOS ANGELES·· | CA·· | 90095 | — | — |
| PRV | PRV-23828 | 2026-07-21T14:59:07Z | Christine | — | Carter | 10/14/1939 | — | — | 9587300 | — | - | - | N/A | — | — | — |
| PRV | PRV-22044 | 2026-10-03T20:16:46Z | Heather | — | Duncan | 1958-11-01 | UHC-89472-32 | NULL | 671.927.1132 | ·· | 7625 Desert Sky Blvd | Dallas | Texas | 75279 | UNKNOWN·· | - |
| PRV | PRV-26304 | 2026-03-16T18:01:22Z | Mariana | — | Vasquez | 1979-07-23 | UHC-43094-42 | - | (585) 596-1556 | mariana.vasquez7@aol.com | 3090 Canyon Rd·· | Dallas | TX | 75208 | N/A | null |
| PRV | PRV-20039 | 2026-08-26T05:02:53Z | Mark | — | Lawrence | 03/17/1943 | UHC-20563-33 | - | (582) 217-7500 | ·- | 358 BASELINE RD | Denver | CO | 80295 | ·NULL | MEDICARE-ADV-A·· |
| PRV | PRV-22753 | 2026-09-18T17:51:24Z | OLIVIA | — | CAMPBELL | 1986-10-04 | — | UNKNOWN | (642) 432-0170 | UNKNOWN | 5315 Indian School Road | Glendale | AZ | 85319 | NULL | — |
| PRV | PRV-28597 | 2026-03-24T02:17:14Z | Randy | — | Torres | 1994-12-12 | UHC-32787-64 | •••-••-3140 | null | N/A | UNKNOWN | — | UNKNOWN | — | - | OPTIONS-PPO·· |
| PRV | PRV-25021 | 2026-02-03T18:11:15Z | ELIJAH | — | RICHARDSON | 1951-04-02 | UHC-63367-57 | null | — | N/A | 3875 Park Pl | Orlando | FL | 32864 | UNKNOWN | N/A |
| PRV | PRV-24717 | 2026-05-07T06:44:34Z | ELIJAH | — | MONTGOMERY | - | UHC-48585-51 | NULL | NULL | — | 6026 SAGE CT Apt 5 | Denver | CO | 80230 | null | — |
| PRV | PRV-27278 | 2026-03-20T01:19:50Z | Raymond | — | Valdez | 2006-08-24 | UHC-28229-93 | — | 7386494036 | - | 816 Palm Drive·· | Orlando | FL | 32892 | — | — |
| PRV | PRV-20791 | 2026-06-03T21:17:24Z | LINDA | — | WEAVER | 1945-04-12 | UHC-05696-37 | null | 5934093369 | NULL | 8132 GRAND AVENUE | Seattle | WA | 98145-7105 | — | — |
| PRV | PRV-21496 | 2026-05-08T21:47:21Z | Elijah | X | Flores | 9166-09-10 | — | ·· | 514-428-2516 | elijah.flores@outlook.com | 7879 Market Street | LOS ANGELES·· | California | 90040 | ···· | N/A·· |
| PRV | PRV-21462 | 2026-01-23T01:25:24Z | Diana | O | Harrison | 1966-08-06 | UHC0987403 | •••-••-4458 | -·· | null | 7744 Central Ave·· | GILBERT | ·AZ | 85264 | UNKNOWN | - |
| PRV | PRV-27315 | 2026-04-14T10:03:11Z | Gilbert, Nicole | — | — | 1951-01-25 | UHC-93489-42 | •••-••-7682 | ·(770) 281-8360 | — | 6879 MARKET ST | Orlando | FL | 32853 | - | — |
| PRV | PRV-25919 | 2026-09-21T16:27:10Z | ralph | — | jacobs | 19820419 | UHC-34844-14 | null | (646) 902-3287 | ralph.jacobs@gmail.com | 3178 LINCOLN WAY | JACKSONVILLE | FL | 32271 | NULL | N/A |
| PRV | PRV-23191 | 2026-05-27T00:23:28Z | Carolyn | — | ·Chen | 09/02/2006 | — | NULL | 275.681.9734 | ·CAROLYN.CHEN26@HOTMAIL.COM | 2822 Sunset Blvd | Glendale | AZ | 85314 | — | N/A |
| PRV | PRV-21391 | 2026-01-24T19:32:25Z | Shirley | — | ·Harris | 1973-06-03 | ·UHC-83247-86 | NULL | 457.422.6987 | null | 7248 Broadway | Chandler | AZ | 85269 | — | N/A |
| PRV | PRV-28869 | 2026-08-05T17:39:30Z | Deborah | — | Gordon | 09/18/95·· | UNKNOWN | — | NULL | deborah.gordon13@icloud.com | 5176 Mesa Dr | SAN DIEGO | ca | 92158 | — | N/A |
| PRV | PRV-27056 | 2026-04-17T21:38:28Z | Wnog, Lisa | — | — | Sep 13, 1966 | UHC-10089-20 | null | +1 591 557 8825 | — | 6788 OAK STREET | TUCSON | AZ | 85722-1859 | ·N/A | NAVIGATE-HMO |
| PRV | PRV-25291 | 2026-03-31T10:29:12Z | ·KIMBERLY | ·R | ORTEGA·· | 2000-05-19 | UHC-66789-55 | •••-••-7678 | null | NULL | 7148 Sage Court Apt 17 | Jacksonville | FL·· | 32297 | — | CHOICE-PLUS-PPO |
| PRV | PRV-24794 | 2026-09-28T02:13:34Z | OMAR | — | ROBERTSON | 1968-09-14 | UHC-90322-30 | — | (782) 363-8544 | — | 3455 MEADOW LANE | Seattle | WA | 98178 | NULL | N/A·· |
| PRV | PRV-22770 | 2026-05-21T12:18:02Z | mariana | O. | johnson | 1997-03-21 | UHC-60276-16 | •••-••-4031 | (440) 482-1064 | MARIANA.JOHNSON61@HOTMAIL.COM | 1867 Mountain View Dr | Dallas | tx·· | 75206 | null | CORE-HMO |
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:43:00.545Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty