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-22641 | 2026-08-18T10:52:02Z | Rebecca | — | Salazar | 1969-02-21 | UHC-27424-29·· | — | 14813777076 | NULL | 6842 Sunset Boulevard | Houston | TX | 77084 | - | SELECT-EPO |
| PRV | PRV-20873 | 2026-06-24T07:10:07Z | Denise | ·· | ·Bennett | 2003-06-18 | N/A | NULL | 3614947193 | — | 3143 MOUNTAIN VIEW DR Apt 33 | ·Denver | co | ·80286 | — | — |
| PRV | PRV-26538 | 2026-05-04T08:56:02Z | Albert | — | Rivera | 20040604 | N/A | null | 249-490-7660 | — | 3812 Ridge Rd | Tucson | AZ | 85725 | — | N/A |
| PRV | PRV-20940 | 2026-01-07T13:30:54Z | West, Betty | — | — | ·2001-09-13 | - | - | 8226476 | betty.west97@proton.me | 7361 JEFFERSON AVE #637 | Chandler | Arizona | ·85278 | NULL | NULL |
| PRV | PRV-25446 | 2026-06-22T21:33:57Z | ARTHUR | — | ·HUNT | 1941-03-03 | - | •••-••-0726 | ·N/A | — | 6255 Valley View Drive·· | Columbus | OH | 43246 | — | null |
| PRV | PRV-28223 | 2026-05-01T15:01:09Z | Ronald·· | C | Stone | 12/18/38 | UHC-53111-75 | ·· | (760) 952-9855 | ·· | 2406 Apache Blvd | Gilbert | AZ | 85295-6075 | UNKNOWN | NAVIGATE-HMO |
| PRV | PRV-25345 | 2026-05-15T15:25:31Z | rachel | — | jacobs | 1997-04-04 | UHC-30192-79 | — | +1 473 908 5402 | N/A | 8448 Camelback Rd | GILBERT | Arizona | null | N/A | UNKNOWN |
| PRV | PRV-20571 | 2026-10-01T23:10:33Z | ·Justin | — | Cooper | 1943-04-08 | N/A | •••-••-3634 | (833) 326-6042 | — | 8956 BASELINE RD | FRESNO | CA | 93724 | — | CORE-HMO |
| PRV | PRV-22203 | 2026-04-19T06:22:59Z | JOAN | — | DUNCAN | 1950-01-11 | UHC-35968-68 | UNKNOWN | 19008536637·· | - | 8323 SPRING ST | Los Angeles | CA | UNKNOWN | — | null |
| PRV | PRV-24723 | 2026-04-07T20:30:03Z | Russell | — | Jimenez·· | 26-08-1972 | ·UHC-20971-83 | UNKNOWN | 3317140263 | UNKNOWN | 8370 HARBOR BLVD | Atlanta | GA·· | 30326 | null | CORE-HMO |
| PRV | PRV-20254 | 2026-05-19T17:21:27Z | Jeffrey | S | Dixon | 02/12/07 | NULL | null | ·- | null | 3804 HILLCREST RD | Mesa | Arizona | 85223 | UNKNOWN | OPTIONS-PPO |
| PRV | PRV-28111 | 2026-02-19T11:36:28Z | Grace | — | Wong | 2000-12-03 | UHC-13056-47 | - | 7356676010 | grace.wong41@hotmail.com | ·3571 SPRING ST | SACRAMENTO | ca | 95834-3075 | — | — |
| PRV | PRV-26592 | 2026-07-26T11:15:34Z | Robinson, Deb | ···· | ···· | 1946-06-14 | UHC-84327-14 | N/A | 13847063063 | null | ·3973 Union Street | Austin | Texas | 78734 | ·N/A | — |
| PRV | PRV-21957 | 2026-01-23T14:25:40Z | Gabriel | R | Ross | 1982-07-27 | UNKNOWN | •••-••-0048 | 412-374-7243 | UNKNOWN | 5064 MESA DRIVE | Sacramento | CA | 95875 | N/A | — |
| PRV | PRV-21731 | 2026-05-02T00:10:25Z | TERESA | Y. | HUGHES | 8/25/1996 | UHC-82381-89 | •••-••-4665 | 724.829.7926 | — | 7401 OAK ST | Sacramento | CA | 95897 | — | MEDICARE-ADV-B |
| PRV | PRV-21638 | 2026-07-26T06:20:10Z | Laura | — | Wong | 1951-08-09 | UHC-97344-52 | •••-••-2510 | 493-244-7322 | UNKNOWN | — | — | ···· | — | — | N/A |
| PRV | PRV-28637 | 2026-07-18T06:30:15Z | chistina | — | garcia | 1969-02-11 | UHC7370075 | N/A | (433) 674-8812 | christina.garcia@icloud.com | 7938 Church Street | ·Houston | TX·· | 77017 | -·· | null |
| PRV | PRV-29158 | 2026-02-16T01:46:36Z | Jack | N. | Jordan | ·1968-12-26 | UHC-46514-85 | UNKNOWN | (812) 362-0354 | ·N/A | 7965 WASHINGTON STREET | Houston | TX | ·77007 | null | null |
| PRV | PRV-25682 | 2026-07-12T00:27:37Z | GARY | — | ORTIZ | 09/25/2006 | UHC-32126-66 | — | 3104012418 | — | 9373 Pine Dr | Sacramento | CA | 95801 | ·· | NAVIGATE-HMO |
| PRV | PRV-21230 | 2026-09-14T03:38:37Z | ·Andrea | — | Scott | 1942-11-13 | UHC-49963-79·· | N/A | 15494208731 | N/A | 5272 Maple Avenue | CHANDLER | AZ | 85271 | - | UNKNOWN |
| PRV | PRV-25152 | 2026-01-12T22:10:05Z | Evelyn | — | Jensen | 2005-05-28 | — | — | NULL | evelyn.jensen@yahoo.com | 9886 Sage Ct | PHOENIX | AZ | 85052 | - | N/A |
| PRV | PRV-26653 | 2026-04-19T07:41:22Z | Frances·· | A | Long | 1959-08-23 | — | •••-••-6742 | 15167277627 | FRANCES.LONG@ICLOUD.COM | 3267 Park Place | Tucson | az | 85763 | N/A | UNKNOWN |
| PRV | PRV-29104 | 2026-08-26T08:53:21Z | JULIA | — | CHAVVEZ | 19580219 | UHC-90166-60 | NULL | 683-540-3604 | N/A | 6840 Willow Court | Atlanta | GA | 30300-3502 | NULL | — |
| PRV | PRV-22155 | 2026-06-20T02:52:40Z | Stephen | — | Carr | 1966-01-10 | null | •••-••-1943 | 7807311419 | ·stephen.carr17@outlook.com | 7932 HARBOR BOULEVARD | Jacksonville | FL | 32219 | null | ·- |
| PRV | PRV-21032 | 2026-01-10T06:37:56Z | Dylan | D·· | White | 01/15/39 | NULL | NULL | 854-742-6782 | dylan.white28@icloud.com | 7746 MOUNTAIN VIEW DRIVE | HOUSTON | TX | 77050 | UNKNOWN | - |
| PRV | PRV-26746 | 2026-01-29T14:53:48Z | JONATHAN | ·H | JOHNSTON | 1977-03-04 | UNKNOWN | NULL | ·917-233-1133 | JONATHAN.JOHNSTON29@HOTMAIL.COM | N/A | - | UNKNOWN | — | — | ·N/A |
| PRV | PRV-25591 | 2026-05-01T22:54:00Z | Snyder, Julia | — | — | 1951-02-06 | UHC-60469-08 | NULL | 552.507.4119 | — | 2609 Sunset Boulevard | Glendale | AZ | ·85379-2002 | ·· | - |
| PRV | PRV-26885 | 2026-03-23T23:28:14Z | ROB | — | WATKINS | 2001-07-07 | UHC-29270-37 | UNKNOWN | - | robert.watkins@yahoo.com·· | 8144 GRAND AVE | Dallas | TX | 75245 | null | ·- |
| PRV | PRV-24647 | 2026-02-08T03:15:48Z | MARGARET | — | ·BAILEY | 2/27/1998 | UHC-26153-91 | ···· | 2706876690 | margaret.bailey@hotmail.com | 3713 Cedar Lane | Gilbert | AZ | 85210 | - | null |
| PRV | PRV-29318 | 2026-07-26T14:42:12Z | MICHAEL | X. | MCDONALD | ·1982-07-05 | null | — | 231-203-0340 | NULL | 6489 Camelback Road | Gilbert | AZ | 85245 | — | - |
| PRV | PRV-27279 | 2026-03-23T04:28:26Z | JOSE | — | TUCKER·· | 2004-12-21 | UHC3686360 | N/A | (331) 434-9662 | jose.tucker30@icloud.com | 4862 Sage Ct | Las Vegas | NV | 89113 | null | — |
| PRV | PRV-27437 | 2026-03-27T06:46:32Z | Wright, Steven | — | — | 04/06/2003 | NULL | - | 9249428800 | ·· | 8108 Meadow Lane | Chandler | AZ | 85219 | N/A | null |
| PRV | PRV-21057 | 2026-04-18T19:37:02Z | Natalie | — | Sandoval | 1989-05-08 | UHC-85144-55 | UNKNOWN | 845.876.2184 | UNKNOWN | 3009 River Rd | Sacramento | CA | ·95887-7577 | - | CHOICE-PLUS-PPO |
| PRV | PRV-26652 | 2026-02-06T05:38:14Z | Bobby | L. | Payne | 1987-08-17 | UHC-54861-76 | — | 231-586-0318 | bobby.payne55@icloud.com | 7432 Palm Dr | Columbus | OH | 43248-7429 | N/A | — |
| PRV | PRV-22228 | 2026-09-13T02:00:36Z | kelley | — | abgail | 1987-10-27 | UHC-49343-30 | — | (232) 577-8514 | ·· | 3540 Harbor Boulevard | Seattle | Washington | ·98172 | — | — |
| PRV | PRV-25864 | 2026-04-06T12:54:05Z | THERESA | — | GARCIA | 1940-11-08 | uhc-73103-71 | •••-••-8533 | (943) 562-9635 | theresa.garcia53@aol.com | 2889 Camelback Rd | FRESNO | CA | 93725 | null | — |
| PRV | PRV-24200 | 2026-01-27T17:02:41Z | Vazquez, Jennifer | ···· | ·· | ·25-07-1946 | — | •••-••-2553 | (771) 445-5658 | - | 1445 Market Street | Los Angeles·· | California | 90048 | - | — |
| PRV | PRV-22424 | 2026-09-09T02:33:48Z | Bobby | — | Taylor | 1980-04-28 | NULL | ·- | 803-848-3258 | null | 7916 Forest Ave | Tucson | AZ | ·85796 | - | SELECT-EPO |
| PRV | PRV-27209 | 2026-06-11T01:07:33Z | KELLY | — | MUNOZ | 19710706 | NULL | — | ·16109535292 | kelly.munoz@outlook.com | 997 BAYSHORE DR | ·Tempe | AZ | 85247-4738 | — | NULL |
| PRV | PRV-21120 | 2026-05-16T23:08:49Z | Rivera, Andrew | ···· | — | 1983-06-13 | UHC-42281-66 | N/A | 19027222780 | NULL | 3452 BROADWAY | Nashville | TN | 37242 | null | ·OPTIONS-PPO |
| PRV | PRV-28265 | 2026-09-13T07:43:46Z | REBECCA | — | CAMPBELL | 1938-06-11 | - | •••-••-5718 | 587-775-0928 | UNKNOWN | 7151 Church Street | Austin | TX | 78776·· | - | ·NULL |
| PRV | PRV-26864 | 2026-07-13T05:31:06Z | Virginia | — | Barnes·· | 2007-04-02 | — | — | 3827817215 | virginia.barnes14@gmail.com | 6404 Sage Court | ATLANTA | GA | 30375 | — | CHOICE-PLUS-PPO |
| PRV | PRV-24034 | 2026-04-18T04:50:13Z | Harold | — | Ramos | 1978-08-26 | NULL | null | 208-790-5762 | harold.ramos@gmail.com | 3785 Church Street | San Diego | CA | 92144-4431 | N/A | CORE-HMO |
| PRV | PRV-22978 | 2026-01-10T05:56:20Z | Elliott, Rebecac | ·G | — | ·07/04/1951 | ·· | null | - | rebecca.elliott13@outlook.com·· | 1001 Lincoln Way | COLUMBUS | OH | 43213 | — | SELECT-EPO |
| PRV | PRV-28538 | 2026-07-01T04:11:12Z | Peter | I. | Carlson | 26-05-1949 | null | •••-••-2584 | (259) 270-1194 | N/A | 206 Maple Ave | Tempe | az·· | 85230 | ·N/A | - |
| PRV | PRV-23827 | 2026-05-03T06:24:58Z | CHRISTINE | — | CARTER | 1939-10-14 | UHC-65972-85 | •••-••-9173 | 4859587300 | UNKNOWN | 4747 Mountain View Drive | Scottsdale | Arizona | 85229 | NULL | NULL |
| PRV | PRV-22308 | 2026-06-20T20:47:59Z | carol | — | garrett | 1971-02-27 | UHC-98913-03 | •••-••-3299 | (440) 975-5259 | NULL | 5161 Valley View Drive | Fresno | California | 93785 | — | NULL |
| PRV | PRV-27884 | 2026-03-02T17:21:32Z | Angela | S | Ellis | 03/02/1949 | — | •••-••-9207 | null | — | 9545 APACHE BLVD Apt 12 | Fresno | CA | 93761 | — | — |
| PRV | PRV-22568 | 2026-10-17T06:35:48Z | Janice | — | Burton | 1955-04-03 | UHC-20074-87 | •••-••-8240 | null | UNKNOWN | 5988 BASELINE ROAD | Seattle | WA | 98179 | null | N/A |
| PRV | PRV-21223 | 2026-08-14T13:46:06Z | CAMILA | — | ·DELGADO | 06/05/75 | ·UHC-77210-26 | UNKNOWN | 8896251986 | UNKNOWN | 4527 DESERT SKY BLVD | Glendale | ·AZ | ·85301 | — | 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:42:52.238Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty