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-23497 | 2026-06-14T13:31:01Z | Roy | — | Bowman | 1952-07-07 | NULL | — | (659) 289-1954 | — | 1638 Pine Drive | EDEN PRAIRIE | MN | 55364 | — | - |
| PRV | PRV-24714 | 2026-04-30T09:24:27Z | TIMOTHY | — | ROBERTSON | 1952-01-06 | — | — | 424.951.5029 | — | — | NULL | N/A | — | UNKNOWN | null |
| PRV | PRV-20986 | 2026-01-22T14:22:02Z | CAMILA | — | OLSON | 1938-06-17 | null | — | 734-541-7864 | camila.olson4@proton.me | 5990 Camelback Rd | DENVER | CO | 80272 | null | — |
| PRV | PRV-23644 | 2026-10-13T18:54:17Z | ·SARAH | — | SNGH | 2004-10-21 | NULL | — | 9323854683 | - | 6395 BAYSHORE DR Apt 39 | Nashville | TN·· | 37224 | — | — |
| PRV | PRV-22342 | 2026-09-04T19:10:03Z | Brian | — | Ortiz | 08-11-1959 | NULL·· | - | 5194910191 | UNKNOWN | 6054 Cedar Lane | Tampa | FL | 33660 | null | — |
| PRV | PRV-26146 | 2026-05-08T17:22:18Z | GARY | — | JENKINS | 1989-05-08 | NULL·· | — | (237) 716-2164 | — | 5509 Palm Drive | Jacksonville | FL | 32273·· | null | — |
| PRV | PRV-27140 | 2026-03-29T18:44:43Z | JERRY | O | JENKINS | 1978-02-73 | UNKNOWN | N/A | null | NULL | 5012 Broadway | Houston | TX | null | N/A | CHOICE-PLUS-PPO |
| PRV | PRV-25010 | 2026-05-21T03:22:50Z | amber | T. | ·hudson | ·1/9/1941 | - | UNKNOWN | (511) 896-4922 | ·- | 1218 Willow Court | San Diego | ·CA | 92119 | ·N/A | — |
| PRV | PRV-22082 | 2026-04-25T05:39:41Z | Charlotte | K | Coleman | 1994-05-05·· | NULL | null | 703-576-1622 | — | 4598 Baseline Rd #227 | Nashville | TN | 37221 | ·UNKNOWN | — |
| PRV | PRV-28416 | 2026-08-03T23:30:27Z | Ralph | — | Arnold·· | 1998-08-26 | — | NULL·· | ·(914) 379-2078 | — | 1334 JEFFERSON AVENUE #442·· | San Antonio | TX | 78254 | NULL | null |
| PRV | PRV-22569 | 2026-01-04T00:21:28Z | Christian | — | Barnes | 1941-11-12 | UHC-06628-52 | NULL | 19263517139 | — | 7655 Canyon Rd | Los Angeles | CA | 90057 | null | — |
| PRV | PRV-27691 | 2026-02-07T03:45:49Z | Daniel | A | Edwards | Jan 8, 1974 | null | - | (287) 509-5232 | — | 8072 Cedar Lane | Los Angeles | CA | 90016 | — | CORE-HMO |
| PRV | PRV-26083 | 2026-10-17T10:10:03Z | SAMANTHA | G. | FOWLER | 17-10-1947 | - | N/A | 19442115222 | SAMANTHA.FOWLER99@YAHOO.COM | 5051 MOUNTAIN VIEW DR | Gilbert | az | 85228 | — | OPTIONS-PPO |
| PRV | PRV-20751 | 2026-04-13T12:46:46Z | Arthur | D | Guzman | 1950-07-01·· | — | null | - | ·ARTHUR.GUZMAN@PROTON.ME | 2337 Broadway | Eden Prairie | ·MN | 55370 | UNKNOWN | null |
| PRV | PRV-24199 | 2026-05-13T02:37:21Z | Juan | ·· | Castro | Aug 2, 1981 | null | NULL | 8809025 | ···· | 3666 Market Street | FRESNO | CA | 93713 | — | N/A |
| PRV | PRV-20896 | 2026-03-11T23:39:15Z | jeffrey | — | cook | ·1991-07-02 | UNKNOWN | NULL | 851-491-5274 | NULL | 7021 BASELINE RD | SCOTTSDALE | AZ | 85215 | NULL | — |
| PRV | PRV-22586 | 2026-01-01T06:13:31Z | EVELYN | C | LANE | 1985-04-14 | UHC-61513-03 | UNKNOWN | 567.766.6790 | — | NULL | - | ·· | UNKNOWN·· | — | - |
| PRV | PRV-25310 | 2026-10-16T03:06:30Z | Jonathan | — | Wang | 8/12/1997 | UNKNOWN | N/A | 658-989-0069 | null | 5706 Indian School Rd | Jacksonville | FL | 32238-3213 | — | ·· |
| PRV | PRV-28256 | 2026-08-06T22:04:31Z | LOGAN | — | LARON | Apr 19, 1945 | UHC-56916-28 | •••-••-5682 | 986.688.7457 | ·N/A | 6157 FOREST AVE | PHOENIX | AZ | 85053 | — | - |
| PRV | PRV-24591 | 2026-07-25T04:41:51Z | Kathleen | — | Crawford | Jun 1, 1999 | UHC-99013-43 | •••-••-2511 | +1 307 823 5692 | kathleen.crawford@outlook.com | 5269 Jefferson Avenue | Glendale | az | ·85356 | null | null·· |
| PRV | PRV-24458 | 2026-09-27T10:42:10Z | AARON | ···· | EVANS | 1944-06-16 | UHC-51560-75 | UNKNOWN | (693) 536-5422 | — | 2320 Central Avenue | Austin | TX·· | 78753·· | UNKNOWN | — |
| PRV | PRV-21214 | 2026-04-18T12:13:24Z | ·Carlos | — | Gray | 1941-08-12 | UHC-64484-73·· | — | null | — | 8227 GRAND AVE | San Diego | California | NULL | — | null·· |
| PRV | PRV-24358 | 2026-05-04T22:58:02Z | nancy | C | rojas | 1999-06-09 | UHC-90304-33 | NULL | — | null | 6782 Pine Drive·· | Houston | TX | — | — | — |
| PRV | PRV-27986 | 2026-03-01T00:08:12Z | randy | — | owens | 12/13/05 | UHC-66110-46 | UNKNOWN | (916) 384-3627 | N/A | 5875 Church Street | Fresno | CA | 93795 | N/A | — |
| PRV | PRV-21144 | 2026-07-15T18:03:04Z | ·Dan | — | Palmer | 1960-03-08 | UHC-52734-93 | •••-••-3817 | +1 454 300 6946 | daniel.palmer@gmail.com | 2641 Apache Boulevard | Chandler | AZ | 85282 | UNKNOWN | - |
| PRV | PRV-21525 | 2026-04-25T02:02:28Z | Eugene | ···· | Owens | 05/22/2008 | UHC-90372-35 | NULL | (248) 850-5614 | ···· | 3082 INDIAN SCHOOL RD | Dallas | ·TX | 75238 | null | CORE-HMO |
| PRV | PRV-24208 | 2026-04-23T08:55:14Z | raymond | — | lucas | 1980-04-23 | UNKNOWN | NULL | (657) 507-1479 | raymond.lucas@proton.me | 4336 Washington Street | Phoenix | AZ | 85026 | null·· | UNKNOWN |
| PRV | PRV-24825 | 2026-05-26T14:41:58Z | NICHOLAS | — | ALEXANDER | 1989-04-25 | UHC-55928-14 | N/A | 791-635-4300 | UNKNOWN | 6192 CANYON ROAD | Mesa | AZ | 85282 | N/A | NULL |
| PRV | PRV-24295 | 2026-03-26T07:28:29Z | Wong, Santiago | J | ·· | 16-08-1981 | ·UHC-46520-40 | — | ·null | SANTIAGO.WONG@PROTON.ME | 7006 MESA DR | JACKSONVILLE | FL | 32243 | N/A | — |
| PRV | PRV-27219 | 2026-02-08T00:59:48Z | Alexander | V | Silva | 08/10/1984 | uhc-70392-45 | NULL | +1 325 851 0146 | NULL | 5783 Pine Drive | Phoenix | AZ | 85008 | N/A | - |
| PRV | PRV-26824 | 2026-04-01T07:08:28Z | JUDY | — | WELCH | ·1968-06-08 | UHC-74292-52 | ···· | 700-726-1911 | — | 5041 Palm Dr | Phoenix | AZ | 85055 | N/A | — |
| PRV | PRV-26617 | 2026-01-13T16:44:06Z | ABIGAIL | ·· | SOTO | 1953-03-27 | UHC-46807-97·· | UNKNOWN | 617.444.7910 | N/A | 3268 Lake View Road | MESA | AZ | 85252 | — | — |
| PRV | PRV-24797 | 2026-02-11T02:41:54Z | BRITTANY | ···· | FERGUSON | 9/21/1990 | UHC-84955-92 | null | N/A | UNKNOWN | 8269 Baseline Road | Minneapolis | MN | 55433 | null | NULL |
| PRV | PRV-27103 | 2026-07-22T07:10:59Z | Doris | — | Powell | 1975-10-28 | — | — | (897) 316-5951 | N/A | 1164 Grand Avenue | Las Vegas | NV | 89153·· | NULL | MEDICARE-ADV-B |
| PRV | PRV-27953 | 2026-02-02T18:00:59Z | JOSHUA | — | HERRERA | 1954-10-01 | UHC-29222-37 | N/A | 17236077992 | NULL | 8343 Washington St | Columbus | OH | 43249 | NULL | ·· |
| PRV | PRV-20456 | 2026-06-07T23:42:03Z | Ahmed | R | Grant | 5/15/1946 | null | NULL | (680) 275-0928 | AHMED.GRANT86@YAHOO.COM | — | — | N/A | — | - | ···· |
| PRV | PRV-27286 | 2026-03-04T06:44:39Z | Gregory | — | Nguyen·· | 1999-06-16 | — | — | 12563169300 | NULL | 8469 Camelback Road | MESA | AZ | 85267 | — | — |
| PRV | PRV-21441 | 2026-02-23T11:25:28Z | Aaron | — | Mendez | 2006-05-23 | UHC-95807-32 | - | (399) 428-4583 | UNKNOWN | 4835 Main Street | Orlando | ·FL | 32867 | - | null |
| PRV | PRV-27886 | 2026-08-04T16:18:28Z | rebecca | — | stevens | 9140-08-09 | null | — | (234) 365-6742 | REBECCA.STEVENS@ICLOUD.COM | 2879 Lincoln Way | Los Angeles | CA | 90097-8352 | — | - |
| PRV | PRV-26789 | 2026-09-10T17:06:19Z | CAROL | — | PIERCE | 1957-02-09 | UHC-80359-24 | •••-••-8891 | (821) 512-2517 | — | 7677 Baseline Road | Fresno | California | 93773 | N/A | OPTIONS-PPO |
| PRV | PRV-29036 | 2026-07-20T20:40:58Z | Priia | ·· | Dunn | 05/05/1959 | ·UNKNOWN | NULL | +1 743 958 2379 | priya.dunn@hotmail.com | 7821 Oak St | Las Vegas | NV | 89148 | — | — |
| PRV | PRV-20435 | 2026-05-27T00:43:16Z | Amber | — | Yang | Sep 10, 1959 | NULL | UNKNOWN | +1 355 657 0858 | AMBER.YANG@YAHOO.COM | 1998 Jefferson Ave | Glendale | Arizona | — | NULL | — |
| PRV | PRV-26252 | 2026-05-10T09:47:13Z | JUDY | — | SANTIAGO | 13-05-1999 | N/A | null | ·+1 866 418 2162 | JUDY.SANTIAGO@YAHOO.COM | 132 Pine Drive | Tempe | AZ | 85248 | — | UNKNOWN |
| PRV | PRV-25960 | 2026-06-05T01:48:46Z | Bryan | — | King | 1960-11-11 | UHC-04101-99·· | •••-••-6514 | null | - | 3073 Canyon Rd | Fresno | CA | 93761-8286 | null | N/A |
| PRV | PRV-27448 | 2026-04-30T05:27:55Z | SARAH | T | PRKER·· | 02/23/90·· | — | N/A | 2538286454 | sarah.parker71@proton.me | 7418 Forest Ave | Denver | Colorado | ·80280 | N/A | UNKNOWN |
| PRV | PRV-21072 | 2026-03-01T15:52:10Z | BRADLEY | C | SCHMIDT | 1999-09-02 | UHC-76297-90 | - | (544) 292-0791 | — | 7157 LINCOLN WAY | Tampa | FL | 33616 | NULL | — |
| PRV | PRV-23639 | 2026-04-04T14:44:25Z | Jeremy | — | Vega | 08/16/1950 | UHC-56071-65 | UNKNOWN | 675-818-5989 | N/A | 1820 PARK PL·· | Sacramento | CA | — | — | - |
| PRV | PRV-28726 | 2026-06-01T18:17:54Z | brian | — | ramos | 08/15/1971 | ·null | null | 7093802338 | brian.ramos25@outlook.com | 134 MARKET ST | Fresno | California | 93714 | NULL | null |
| PRV | PRV-23422 | 2026-08-22T16:53:51Z | KEVIN | — | CLARK | 1986-09-02 | - | NULL | 4955613118 | kevin.clark8@icloud.com | 4402 Mesa Dr | Atlanta | GA | 30336 | NULL | UNKNOWN |
| PRV | PRV-20820 | 2026-08-16T07:04:53Z | Chapman, Noah | — | — | 4/15/2002 | UHC-65294-57 | •••-••-4729 | 979.904.6434 | null | 397 Palm Drive | Phoenix | AZ | 85078·· | 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:00.205Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty