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-24676 | 2026-03-08T20:45:29Z | Joe, Diaz | — | ·· | 25-03-2001 | UHC-07594-37 | •••-••-3910 | 601-620-1229 | ·UNKNOWN | 3111 Maple Ave | GLENDALE | AZ | 85353 | UNKNOWN | — |
| PRV | PRV-27304 | 2026-01-03T21:30:41Z | JOSHUA | — | MORALES | 01-08-1994 | null | null | 713-540-2824 | N/A | 9767 SUNSET BLVD #107 | Phoenix | AZ | 85004 | — | ···· |
| PRV | PRV-22346 | 2026-03-07T23:05:07Z | Aisha | ·D | Wang | 07-07-2007 | UHC-84976-29 | — | (320) 414-2896 | null | 1243 Baseline Rd | Mesa | AZ | 85235 | UNKNOWN | OPTIONS-PPO |
| PRV | PRV-28491 | 2026-01-31T16:36:35Z | barbara | — | weber | 1948-01-25 | UHC-24739-99 | •••-••-1121 | 349-906-0415 | barbara.weber40@yahoo.com | 4863 Ocean Avenue | Eden Prairie | MN | 55336 | — | OPTIONS-PPO |
| PRV | PRV-21472 | 2026-06-15T16:30:06Z | Alan | — | Rios | 11/20/2002 | uhc-32796-59 | null | ·3025516496 | alan.rios37@aol.com | 9075 Desert Sky Blvd | Minneapolis | Minnesota | 55480 | null | UNKNOWN |
| PRV | PRV-21658 | 2026-01-24T19:11:11Z | ADAM | — | SIMPSON | 1949-08-17 | — | ···· | +1 342 708 7271 | ADAM.SIMPSON@YAHOO.COM | 1763 Sage Ct | Scottsdale·· | AZ | ·85273 | NULL | NAVIGATE-HMO |
| PRV | PRV-21935 | 2026-09-22T05:13:41Z | Douglas F. | — | Garza·· | 1946-09-15 | UHC-82645-48·· | •••-••-2432 | (273) 427-6134 | - | 1168 CEDAR LANE | Phoenix | AZ | 85069 | — | NULL |
| PRV | PRV-22337 | 2026-02-06T19:34:46Z | HEATHER | — | ELLIS | 2004-12-07 | UHC-10265-02 | — | (465) 331-4415 | — | — | N/A | ·UNKNOWN | -·· | null | MEDICARE-ADV-B |
| PRV | PRV-28857 | 2026-07-01T09:42:16Z | NATALIE | M. | JOHNSTON | 1963-03-03 | null | — | 427-855-6740 | — | ·2698 Elm St | Atlanta | GA | 30306 | - | - |
| PRV | PRV-25036 | 2026-01-30T14:01:32Z | Gonzales, Wil | — | — | ·08/17/77 | UHC-92544-37 | — | 462-939-1825 | william.gonzales23@proton.me | 2689 Market St | Minneapolis | MN | 55475 | — | — |
| PRV | PRV-21346 | 2026-09-18T05:53:17Z | Mason | — | Bowman | 1979-01-19·· | UHC-89875-58 | UNKNOWN | 414.389.4502 | N/A | 56 Grand Ave | Eden Prairie | ·MN | 55334 | null | CHOICE-PLUS-PPO |
| PRV | PRV-28533 | 2026-07-10T10:54:19Z | Patrick | — | ·Castro | 1996-09-04 | UHC-42767-76 | ···· | 2924205701 | — | 6815 Canyon Road | ·Dallas | TX | 75201 | null | - |
| PRV | PRV-21824 | 2026-07-23T15:29:09Z | Fisher, Harold | I. | — | 04/25/1962 | null | •••-••-2856 | 8633139086 | NULL | ·· | — | — | null | UNKNOWN | — |
| PRV | PRV-23936 | 2026-03-18T04:15:12Z | PHILIP | W | LAWSON | 20081227 | UHC-04229-09 | NULL | 6685736 | — | 8364 MAIN ST | Dallas | TX | 75217·· | UNKNOWN | ·· |
| PRV | PRV-24904 | 2026-04-07T03:25:00Z | Alexander | — | Perkins | 1959-03-26 | UNKNOWN | null | 7164336395 | alexander.perkins@icloud.com | 26 Camelback Road | Plano | ·TX | 75058 | UNKNOWN | — |
| PRV | PRV-24081 | 2026-08-20T00:08:40Z | ·Shirley | — | Stewart | 1917-07-06 | NULL | •••-••-7772 | N/A | N/A | NULL | N/A | — | N/A·· | ···· | — |
| PRV | PRV-29115 | 2026-01-05T00:49:41Z | Theresa | ·· | Bradley | 1954-11-05 | UHC-33427-48 | •••-••-2987 | 289.417.8886 | theresa.bradley61@icloud.com | 8604 Forest Ave | Sacramento | California | 95810 | NULL | — |
| PRV | PRV-20498 | 2026-07-21T17:36:46Z | PAMELA | — | — | 1975-11-08 | NULL | UNKNOWN | 14529523413·· | - | - | — | ·· | null | NULL | - |
| PRV | PRV-25650 | 2026-08-28T13:06:12Z | sara | P | ford | 2005-12-04 | UHC-92388-04 | •••-••-8645 | (754) 225-6746 | - | 2123 INDIAN SCHOOL ROAD | Charlotte | NC | 28221 | — | SELECT-EPO |
| PRV | PRV-20090 | 2026-06-23T00:07:22Z | Philip | — | Le | 19800205 | — | N/A | (401) 623-8117 | philip.le@aol.com | 6510 Pine Dr | GLENDALE | AZ | 85331-5556 | NULL | ···· |
| PRV | PRV-20540 | 2026-08-27T03:28:35Z | diane | A | lopez | 2008-02-15 | UHC-47129-97 | •••-••-9865 | 818-258-8640 | diane.lopez@hotmail.com | 4270 LINCOLN WAY | Seattle | WA | 98111 | null | NULL |
| PRV | PRV-24123 | 2026-06-23T10:05:28Z | DANIEL·· | ·G. | BENNETT | 2008-08-12 | UHC6682988 | — | 327-952-3910 | — | 9592 Market Street | GLENDALE | AZ | 85308 | null | - |
| PRV | PRV-20768 | 2026-09-21T23:43:37Z | Yuki | — | Wagner | 1975-12-10 | UHC-48477-20 | — | 572-712-6465 | null | 2516 Maple Ave | ·Los Angeles | CA | 90069 | N/A | — |
| PRV | PRV-21516 | 2026-09-27T07:39:11Z | thomas | — | boyd | Sep 28, 1984 | null | N/A | (478) 926-5496 | THOMAS.BOYD14@HOTMAIL.COM | ·7546 SUNSET BLVD | Sacramento | CA | 95883 | — | N/A·· |
| PRV | PRV-24562 | 2026-01-15T00:43:59Z | Elizzabeth | — | Ruiz | 02/03/1971 | — | UNKNOWN | (231) 213-5623 | — | — | UNKNOWN | N/A | null | N/A | - |
| PRV | PRV-25567 | 2026-06-09T01:45:27Z | Willie | — | Walsh | Feb 1, 1986 | NULL | UNKNOWN | N/A | UNKNOWN | 408 Sage Ct | SCOTTSDALE | AZ | 85249 | — | — |
| PRV | PRV-22210 | 2026-04-14T18:56:56Z | Natalie | — | Bihop | 04/25/87 | UNKNOWN | UNKNOWN·· | (697) 360-1068 | N/A | 5678 Baseline Rd | Fresno | CA | 93770 | ·NULL | OPTIONS-PPO |
| PRV | PRV-29019 | 2026-08-11T20:54:32Z | linda | — | duncan·· | Oct 21, 1962 | UNKNOWN | •••-••-4726 | 7868182688 | — | — | - | — | UNKNOWN | UNKNOWN | ·· |
| PRV | PRV-24938 | 2026-07-04T18:49:04Z | Karen | — | Powell | 1971-06-12 | UHC-95508-84 | NULL | ·+1 968 342 1649 | — | 5502 Broadway | FRESNO | CA | 93753 | — | OPTIONS-PPO |
| PRV | PRV-21257 | 2026-09-19T00:07:52Z | Denny | — | Simmons | 1983-04-07 | — | •••-••-1362 | 8409043209 | NULL | 2133 Apache Blvd | Austin | Texas·· | 78720 | — | — |
| PRV | PRV-25784 | 2026-10-14T20:19:43Z | ·Gariel | Z | Ward | 1943-02-02 | NULL | — | 13307013173 | ·· | ·998 Pine Drive | San Antonio | TX | 78250 | UNKNOWN | null |
| PRV | PRV-20704 | 2026-03-01T19:46:15Z | ·Randy | — | Harrison | 11/20/1985 | UNKNOWN | - | 712-455-2893·· | UNKNOWN | 5559 SAGE CT | CHANDLER | AZ | 85226 | — | -·· |
| PRV | PRV-24071 | 2026-04-13T18:38:32Z | Christine | O | Bryant | 01/02/64 | UHC-13671-78 | — | 3139113030 | christine.bryant@outlook.com | 8446 Union Street | Jacksonville | Florida | 32234 | null | SELECT-EPO·· |
| PRV | PRV-25559 | 2026-06-14T10:15:03Z | Julie | — | Jenkins | 6/4/1941 | UHC-74393-86 | N/A | 450-949-8674 | — | 6858 Camelback Rd Apt 23 | San Antonio | Texas | 78208 | — | — |
| PRV | PRV-25897 | 2026-03-23T22:59:27Z | CARLOS | W | RICHARDSON | 1951-12-10·· | UNKNOWN | NULL | 565-465-2141 | null | 887 Apache Blvd | Phoenix | AZ | 85009 | — | NULL |
| PRV | PRV-21834 | 2026-03-14T06:31:42Z | willie | ···· | shaw | 1978-12-02 | - | N/A | - | — | 7789 Canyon Road | Minneapolis | MN | — | N/A·· | UNKNOWN |
| PRV | PRV-24184 | 2026-06-26T03:57:47Z | Kathleen C·· | — | Knight | ·1981-08-22 | — | — | 233-687-3624 | — | 3149 Park Pl | DALLAS | TX | 75204 | NULL | OPTIONS-PPO |
| PRV | PRV-29393 | 2026-07-15T06:52:16Z | CHARLES·· | — | MARQUEZ | ·1943-08-17 | UHC-60230-72 | UNKNOWN | +1 768 562 6720 | charles.marquez@hotmail.com | 9250 PARK PL | CHARLOTTE·· | NC | 28209·· | null | CORE-HMO |
| PRV | PRV-27141 | 2026-03-11T17:28:51Z | JULIE | — | ARNOLD | 1981-09-06 | UHC-68011-71 | null | ·6902193859 | - | 9290 OAK ST | Tempe | AZ | ·85261 | — | UNKNOWN |
| PRV | PRV-22414 | 2026-05-04T19:16:30Z | CAMLA | — | SANDOVAL | Sep 18, 1983 | UHC-60824-59 | — | +1 459 217 9167 | - | 5221 BROADWAY #109 | Seattle | Washington | 98142 | null | — |
| PRV | PRV-20199 | 2026-10-01T23:23:49Z | Arjun | — | Lucas | 03/09/93 | UHC-83630-69 | — | 289-750-2616 | ARJUN.LUCAS94@AOL.COM | 7452 INDIAN SCHOOL ROAD | ·Nashville | tn | 37237 | N/A | UNKNOWN |
| PRV | PRV-23627 | 2026-02-08T05:07:47Z | DENNIS | X. | SILVA | 1974-02-09 | UHC-33614-22 | null | 2157445 | null | 5392 Market St | Mesa | AZ | 85238 | — | UNKNOWN |
| PRV | PRV-25363 | 2026-05-04T16:49:15Z | Kimberly | — | Vargas | 6/22/1986 | UHC-30183-37 | null | ·(246) 646-8926 | NULL | - | UNKNOWN | — | — | — | NULL |
| PRV | PRV-25096 | 2026-07-04T22:03:54Z | Mason | — | Armstrong | 1938-08-21 | N/A | •••-••-7200 | 981-902-7659 | — | 3613 Highland Avenue | COLUMBUS | OH | N/A·· | — | — |
| PRV | PRV-22235 | 2026-08-14T13:59:04Z | Tom·· | ···· | Mendoza | 1964-11-16·· | UHC-87035-55 | — | 19103901758 | N/A | ·· | - | — | - | UNKNOWN·· | ·NAVIGATE-HMO |
| PRV | PRV-22085 | 2026-07-10T16:58:28Z | RALPH | T. | DANIELS | 07-07-2001 | UHC-44422-88 | — | (619) 984-4511 | N/A | ·3822 SAGE CT Apt 7 | Phoenix | AZ | N/A | — | - |
| PRV | PRV-21386 | 2026-09-27T10:08:31Z | Ed | — | Graham | 06-12-1963 | UHC-96241-33 | null | 763.429.0261 | — | NULL | — | null | NULL | UNKNOWN·· | null |
| PRV | PRV-28589 | 2026-01-26T07:48:15Z | ·Wright, Benjamin | G | — | 5/17/1974 | UHC-86998-36 | -·· | 3266584477 | null | 9599 Ocean Ave | Orlando | FL | ·32824 | — | — |
| PRV | PRV-23932 | 2026-01-01T01:42:24Z | DEBORAH | — | ROSE | Aug 11, 1998 | N/A | NULL | — | deborah.rose@icloud.com | 1463 Mountain View Dr | Phoenix | AZ | 85039 | — | N/A |
| PRV | PRV-25357 | 2026-07-11T20:14:25Z | JOSHUA | S | CHAPMAN·· | 02-07-1975 | ·null | •••-••-7409 | 8886973592 | null | — | NULL | UNKNOWN | null | ···· | null |
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:03.720Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty