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-21836 | 2026-01-11T23:10:35Z | Janice | — | Ells·· | 1972-04-17 | UNKNOWN·· | — | 2313540359 | — | 8233 VALLEY VIEW DRIVE | SEATTLE | WA | 98153 | — | SELECT-EPO |
| PRV | PRV-25575 | 2026-08-29T15:46:10Z | ROBERT | B | WASHINGTUN | 4/3/1969 | UHC-52616-95 | •••-••-5993 | ·NULL | robert.washington51@aol.com | 8721 APACHE BOULEVARD | MIAMI | FL | 33146 | UNKNOWN | — |
| PRV | PRV-21708 | 2026-02-25T18:55:03Z | MADISON | — | FOSTER | 03/28/1955 | UHC-63068-07 | null | (679) 972-7683 | NULL | 8828 Spring Street | Atlanta | GA | 30393 | null | — |
| PRV | PRV-20385 | 2026-05-12T19:06:03Z | Greg | — | Lawson | 02-02-1983 | null | null | null | GREGORY.LAWSON70@OUTLOOK.COM | 3957 Grand Avenue | Denver | CO·· | 80261 | — | null |
| PRV | PRV-25372 | 2026-07-25T21:41:31Z | Logan | Z | Richardson | 1981-11-11 | — | •••-••-7026 | 13566552589 | UNKNOWN | 2481 APACHE BLVD #472 | Las Vegas | NV | 89167·· | - | ·- |
| PRV | PRV-27506 | 2026-02-07T12:55:53Z | CAROLYN | — | HOWARD | 1951-05-02 | UHC-95418-97 | N/A | 906-564-7459 | null | 3359 MEADOW LN | Nashville | TN | 37262 | N/A | — |
| PRV | PRV-22454 | 2026-10-04T05:30:52Z | DEBORAH | — | ALVARADO | 02/04/2006 | UHC-58614-80 | •••-••-0049 | (499) 665-6349 | deborah.alvarado@proton.me | — | N/A·· | — | — | ···· | — |
| PRV | PRV-21982 | 2026-10-02T21:41:20Z | Gloria | — | Stone | 19650403 | UHC-46016-18 | — | (486) 337-6974 | gloria.stone50@aol.com | ·2107 PARK PLACE | Charlotte | NC | 28202-6219 | null | UNKNOWN |
| PRV | PRV-20329 | 2026-02-06T16:37:51Z | BEVERLY | ···· | AGUILAR | 2/7/1948 | UHC-27212-80 | — | (737) 722-3654 | UNKNOWN | 2486 Baseline Rd | Scottsdale | ·AZ | 85255 | null | NULL |
| PRV | PRV-21252 | 2026-05-06T14:34:19Z | Danielle·· | — | Long | 1/10/1998 | UHC-61358-21 | — | 869-608-8611 | danielle.long@proton.me | 105 Ocean Avenue | Los Angeles | CA | 90077 | NULL | CHOICE-PLUS-PPO |
| PRV | PRV-20550 | 2026-03-02T18:25:24Z | Lori | — | Jenkins | 1942-03-08·· | UHC-04155-85 | — | 636-436-2211·· | LORI.JENKINS@YAHOO.COM | ·6063 Market Street | Nashville | TN | 37280 | — | N/A |
| PRV | PRV-26688 | 2026-02-04T20:24:02Z | Sean | F | Mendoza | 19621114 | ·N/A | UNKNOWN | 19033023098 | ·NULL | 7046 Highland Avenue·· | Atlanta | GA·· | 30380 | — | null |
| PRV | PRV-25120 | 2026-10-16T11:13:45Z | MICHELLE | ·· | WALKER·· | 2003-08-05 | UHC-17580-14 | N/A | (301) 583-8848 | — | 7539 Bayshore Drive | ·Jacksonville | FL | 32259 | — | - |
| PRV | PRV-27807 | 2026-03-07T07:00:40Z | Bobby | — | Dean | 1941-05-26 | UHC-81117-27 | — | 408-333-0786 | NULL | 717 Valley View Drive Apt 12 | Jacksonville | FL | 32287 | NULL | — |
| PRV | PRV-25058 | 2026-01-07T21:32:23Z | Matthew | — | Alexender | 1988-05-08 | UHC-16478-31 | — | — | MATTHEW.ALEXANDER24@AOL.COM | 9294 HIGHLAND AVENUE·· | Miami | FL | 33138 | ·- | SELECT-EPO |
| PRV | PRV-25871 | 2026-01-07T17:08:44Z | ROGER | T. | FERGUSON | 19600412 | NULL | — | ·19527383499 | roger.ferguson@gmail.com | 4199 Church St | Glendale | AZ | 85349 | ·NULL | UNKNOWN |
| PRV | PRV-29373 | 2026-03-20T08:11:24Z | Carl | ·G. | Rios | 2007-05-20 | UHC-20090-95 | — | null | null | 180 Meadow Ln | TUCSON·· | AZ | 85762 | — | NULL |
| PRV | PRV-22584 | 2026-06-10T06:57:14Z | Judith | U | Roberts | 6/3/2008 | UNKNOWN | •••-••-7475 | ·(658) 834-0136 | N/A | NULL | -·· | — | — | NULL | NULL |
| PRV | PRV-21259 | 2026-04-23T10:44:31Z | Gutierrez, Patrick·· | — | ···· | 1993-10-02 | UHC-38230-55 | UNKNOWN | - | patrick.gutierrez@proton.me | 6794 Cedar Ln | Mesa | AZ | 85275-9006 | — | — |
| PRV | PRV-25358 | 2026-08-18T09:56:45Z | Jaack | N. | Burns | ·· | null | null | 304-583-6899 | - | 4753 Apache Boulevard | San Diego | CA | 92197 | — | CORE-HMO |
| PRV | PRV-24213 | 2026-02-04T07:47:31Z | ·JEREMY | B | DIXON | 1939-05-03 | UHC-07517-71 | — | 446-411-0688 | jeremy.dixon@aol.com | 6846 Hillcrest Road | Houston | TX | null | NULL | UNKNOWN |
| PRV | PRV-29465 | 2026-08-11T17:00:34Z | ·LUCIA | — | JIMENEZ | 1971-07-28 | null | NULL | 6463949096 | - | 4373 UNION STREET | San Diego | CA | 92136 | — | OPTIONS-PPO |
| PRV | PRV-29497 | 2026-08-18T08:03:49Z | LINDA | — | WALSH | 6/4/1947 | UHC-51831-20 | — | UNKNOWN | NULL | 3155 Valley View Drive | Tucson | AZ | 85767 | null | UNKNOWN |
| PRV | PRV-21645 | 2026-04-12T01:44:02Z | Vincent | — | Schmidt | 17-12-2007 | — | •••-••-2046 | +1 819 691 8807 | — | 1891 CAMELBACK RD | Gilbert | Arizona | 85227 | - | N/A |
| PRV | PRV-25844 | 2026-04-09T07:30:41Z | Richard | — | Lawson | May 25, 1976 | UHC-60156-03 | — | ·375-443-5819 | NULL | 9040 Ridge Rd | Las Vegas | NV | 89128 | N/A | - |
| PRV | PRV-28102 | 2026-04-27T17:45:43Z | ·RAYMND | — | PHILLIPS | 01/28/1995 | NULL | — | 4037341297 | — | 1479 BASELINE RD | Glendale | AZ | 85314 | NULL | NULL |
| PRV | PRV-23486 | 2026-08-06T18:23:58Z | daniel·· | — | palmer | 1976-01-03·· | — | null | (720) 769-0680 | NULL·· | 5385 Broadway | ·EDEN PRAIRIE | MN | 55313 | — | null |
| PRV | PRV-29235 | 2026-06-16T15:26:23Z | Catherine | Q | Wright | 1952-12-03 | UNKNOWN | •••-••-6025 | — | — | 4260 Lake View Rd | Jacksonville | FL | 32256-9620 | — | - |
| PRV | PRV-23588 | 2026-07-27T11:10:12Z | Armsttrong, Willie | — | — | 11/18/57·· | UHC-69417-66 | — | 8015433 | NULL | 5056 Market St | Las Vegas | NV | 89173 | N/A | ·- |
| PRV | PRV-28221 | 2026-09-27T06:12:00Z | Robinson | — | Carolyn | 1976-07-13 | UHC-30018-72 | null | - | UNKNOWN·· | 3675 Grand Avenue | Tempe | AZ | 85273 | UNKNOWN | N/A |
| PRV | PRV-23442 | 2026-06-21T03:58:34Z | GLORIA | — | HOLMES·· | Aug 4, 1985·· | UHC-47269-70 | UNKNOWN | ·8878901218 | null | 606 JEFFERSON AVENUE | Seattle | WA | 98123 | NULL | N/A |
| PRV | PRV-25997 | 2026-09-17T14:51:12Z | NANCY | ·· | GEORGE | 1979-06-04 | UHC-95306-31 | N/A | (411) 514-7965 | — | 436 Bayshore Drive | San Antonio | TX | 78234 | NULL | - |
| PRV | PRV-26826 | 2026-07-07T16:07:38Z | Amanda | — | Cole | 2005-10-28 | null | •••-••-6354 | 2293378957 | — | 593 Cedar Lane | Seattle | WA·· | 98142 | ·N/A | CORE-HMO |
| PRV | PRV-21287 | 2026-02-16T17:57:24Z | mason | — | duncan | 1984-04-28 | UHC-64676-94 | NULL | (787) 478-6941 | null | 3258 HILLCREST RD | Gilbert | Arizona | 85216 | — | - |
| PRV | PRV-22652 | 2026-05-04T09:58:50Z | Eugene | — | Collins | 2005-05-18 | UNKNOWN | •••-••-6414 | 18643502892 | eugene.collins@aol.com | 1653 Highland Ave #905 | Tempe | AZ | 85221 | — | UNKNOWN |
| PRV | PRV-26001 | 2026-03-17T04:15:12Z | Roger | — | Fisher | 1980-08-23 | UHC-56175-53 | — | 391.712.1226 | null | ·7021 MEADOW LN | Tempe | AZ | 85206-4533 | — | NAVIGATE-HMO |
| PRV | PRV-22107 | 2026-02-09T23:50:59Z | Dylan | — | Watkins | 10/27/07 | UHC-44967-83 | — | UNKNOWN | DYLAN.WATKINS@GMAIL.COM·· | 343 Bayshore Drive | Seattle | WA | 98191 | null | — |
| PRV | PRV-23419 | 2026-03-10T06:06:56Z | Juan | — | Coleman | 2008-05-26 | - | N/A | 968-361-6772 | UNKNOWN | 8188 DESERT SKY BOULEVARD Apt 17 | Sacramento | California | 95880 | — | NULL |
| PRV | PRV-23726 | 2026-04-14T14:08:53Z | MEGAN·· | — | WILSON | ·3/14/1956 | UHC-27377-95 | UNKNOWN | 673-301-6707 | MEGAN.WILSON83@HOTMAIL.COM | 9499 MARKET ST | Denver | Colorado | 80247 | - | N/A |
| PRV | PRV-27361 | 2026-07-07T02:18:46Z | Ashley·· | — | Moore | 1966-04-16 | UHC-92997-42 | — | 12739035923 | null | 5502 RIVER RD | Nashville | TN | — | null | UNKNOWN |
| PRV | PRV-27373 | 2026-05-07T01:51:19Z | justin | ·· | chavez | 1947-05-07 | - | — | (909) 793-9771 | — | ·8672 Canyon Road | Tucson | AZ | - | NULL | UNKNOWN |
| PRV | PRV-22797 | 2026-04-28T09:25:05Z | Lucia | — | Cook | 1950-10-17 | ·- | — | 500-795-7531 | UNKNOWN | 4149 Indian School Rd·· | MESA | AZ | 85271·· | ·· | UNKNOWN |
| PRV | PRV-27309 | 2026-05-05T02:04:05Z | Angela | — | Hunter | ·1997-06-20 | — | NULL | 6433533055·· | - | 8782 LINCOLN WAY | Orlando | FL·· | 32817·· | N/A | — |
| PRV | PRV-21139 | 2026-07-17T16:06:16Z | KATHRYN | — | BOWMAN | 01/08/49 | UNKNOWN | •••-••-8224 | ·9587770732 | NULL | - | N/A | UNKNOWN | — | NULL | CORE-HMO |
| PRV | PRV-26921 | 2026-06-14T10:23:00Z | Yuki | — | Harris | 1950-10-26 | UNKNOWN | - | — | NULL | UNKNOWN | — | N/A | — | — | ·NULL |
| PRV | PRV-27881 | 2026-09-04T03:02:29Z | Roy | — | Elis | 2006-02-21 | UHC-97344-04 | N/A | 213-560-6666 | NULL | 2423 Central Avenue | Mesa | AZ | 85234 | NULL | CHOICE-PLUS-PPO |
| PRV | PRV-28776 | 2026-01-27T05:53:42Z | Marquez, Ashley | V. | — | 1939-01-03 | UHC-56997-24 | — | 4835801301·· | N/A | 384 LAKE VIEW ROAD Apt 8 | NASHVILLE·· | ·TN | 37279 | NULL | MEDICARE-ADV-A |
| PRV | PRV-22726 | 2026-08-08T19:38:26Z | Cynthia·· | — | Elliott | 2007-09-02 | — | — | 511-338-2771 | ···· | 9248 Sage Ct | San Antonio | TX | ·78200 | null | — |
| PRV | PRV-29357 | 2026-01-25T21:34:00Z | Arthur | ·· | Oliver | 19720719 | N/A | NULL | — | N/A | 3820 MOUNTAIN VIEW DR | Minneapolis | ·mn | 55472 | N/A | null |
| PRV | PRV-26456 | 2026-02-23T13:54:39Z | NANCY | I | WILLIAMSON | 19480324 | UHC-86218-75 | •••-••-5939 | 824-511-7466 | NULL | 8444 Apache Blvd | FRESNO | CA | 93781-9321·· | — | — |
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:46.094Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty