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-23834 | 2026-09-13T15:51:31Z | Ann | X | Fields·· | 19460103 | UHC-32591-81 | •••-••-5486 | 12802824556·· | ANN.FIELDS@YAHOO.COM | 5259 Valley View Dr | TEMPE | AZ | 85241-8573 | NULL | — |
| PRV | PRV-27473 | 2026-06-21T15:33:49Z | Nicholas | — | Kennedy | 1968-01-24 | UHC-20724-92 | N/A | 7075636307 | — | 4906 Main Street | Phoenix | AZ·· | 85045 | — | UNKNOWN |
| PRV | PRV-21490 | 2026-01-02T04:40:49Z | RAYMOND | H | SCHMIDT | 07/01/1954 | UNKNOWN | UNKNOWN | 662-621-0257 | null | 8835 Valley View Dr | Jacksonville | FL | 32261 | NULL | NULL |
| PRV | PRV-20827 | 2026-10-11T19:19:00Z | Dennis | — | Gutierrez | 1984-04-08 | UHC-41524-39 | - | 952-632-7283 | — | 9635 MOUNTAIN VIEW DR | Seattle | WA | 98132 | - | null |
| PRV | PRV-22030 | 2026-10-01T21:26:34Z | Gregory | — | Willis | 1955-05-27 | UHC-33667-24 | ···· | 8742720651 | — | — | N/A | - | NULL | null·· | ·null |
| PRV | PRV-25301 | 2026-08-22T05:48:48Z | PAUL·· | — | LUCAS | 1946-06-15 | UNKNOWN | N/A | 779-659-7606 | — | 3616 CAMELBACK RD | JACKSONVILLE | fl | 32262 | — | null |
| PRV | PRV-24174 | 2026-03-28T16:24:35Z | Stephanie | — | Graham | 05/16/61 | ·· | - | 4886602903 | NULL | 5498 Spring St | Austin | Texas | 78740-1084 | - | N/A |
| PRV | PRV-23773 | 2026-04-08T09:22:30Z | LAWRENCE | — | ·KING | 1953-12-26 | - | UNKNOWN | 208-403-5748 | UNKNOWN | 569 RIDGE RD·· | Dallas | TX | — | - | — |
| PRV | PRV-20439 | 2026-07-22T06:52:06Z | Benjamin | B | — | 1978-11-02 | — | UNKNOWN | (741) 428-9056 | benjamin.harris@icloud.com | 1764 Mountain View Drive | Las Vegas | NV | 89190 | UNKNOWN | — |
| PRV | PRV-26953 | 2026-03-24T21:56:44Z | Janet | — | Hawkins | 03/26/1996 | UHC-30047-18 | — | 5695896314 | — | 7647 Mesa Drive | Tucson | ·AZ | 85704 | null·· | - |
| PRV | PRV-21480 | 2026-03-10T05:27:05Z | Diane | — | Knight | 19421118 | UHC-54183-65 | N/A | 242-468-3030·· | null | 2976 Market St | TUCSON | AZ | 85760 | NULL | N/A |
| PRV | PRV-26662 | 2026-01-10T05:15:25Z | Valentina | — | ·Wong | 4/8/1950 | ·UHC-87911-51 | ·· | (547) 514-7665 | UNKNOWN | 316 Pine Dr | Gilbert | AZ | 85240 | — | null |
| PRV | PRV-24917 | 2026-10-06T05:19:55Z | Fisher, Ahmed | — | — | 05/01/86 | UHC6805804 | UNKNOWN | 505-305-6699 | — | 44 ELM STREET | Seattle | WA | 98149 | — | NULL·· |
| PRV | PRV-26571 | 2026-05-26T18:53:40Z | RUTH | W | FORD | 1973-12-26 | UHC-28799-29 | - | ·+1 721 956 3712 | UNKNOWN | 3627 DESERT SKY BOULEVARD #189 | Tempe | AZ | 85217 | NULL | NULL |
| PRV | PRV-27071 | 2026-07-28T18:33:54Z | david | — | weber | 1980-04-08 | N/A | — | 6844058 | — | 7188 JEFFERSON AVENUE·· | Denver | CO | 80211 | UNKNOWN | — |
| PRV | PRV-23154 | 2026-07-06T23:09:40Z | BETTY | Y | WILSON | 2001-09-19 | UHC-90824-27 | NULL·· | 8086429491 | — | 4772 Desert Sky Blvd | Tampa | FL | 33684 | N/A | MEDICARE-ADV-B |
| PRV | PRV-24899 | 2026-05-28T14:20:46Z | MARTHA | — | FLORES | 10/16/1956 | UHC-46994-53 | UNKNOWN | 7377016721 | — | NULL | ·· | — | — | - | NAVIGATE-HMO |
| PRV | PRV-20266 | 2026-06-30T08:46:36Z | JEFFREY | — | CARR | 06/15/1983 | — | — | — | - | 9717 Jefferson Ave | Dallas | TX | 75267 | — | — |
| PRV | PRV-23157 | 2026-09-02T05:32:37Z | sara | — | lucas | 1982-04-18 | — | null | — | sara.lucas@gmail.com | 6230 Union St | Scottsdale | AZ | 85250 | null | SELECT-EPO |
| PRV | PRV-26983 | 2026-01-03T22:10:29Z | GRACE | I | WILLIIAMS | 1977-04-18 | UNKNOWN | — | 12232374335 | - | 9067 Highland Avenue | Jacksonville | FL | 32233 | N/A | null |
| PRV | PRV-20798 | 2026-09-10T12:51:34Z | patrick | — | chapman | ·1938-04-13 | UHC-67096-01 | •••-••-1235 | 417-885-8332 | NULL | 493 CAMELBACK ROAD | Dallas | TX | 75269 | NULL | — |
| PRV | PRV-24744 | 2026-02-27T06:18:22Z | Priya | — | Webb | 11/22/1986 | NULL | null·· | 5973211335 | - | 5120 MAIN ST Apt 24 | Glendale | AZ | 85392·· | — | NULL |
| PRV | PRV-24058 | 2026-08-31T15:03:08Z | Julia | — | Hollmes | 1974-12-28 | — | •••-••-3127 | 696-728-9662 | julia.holmes@icloud.com | — | — | NULL | NULL | NULL | — |
| PRV | PRV-29229 | 2026-07-14T14:45:02Z | Emma | — | Richardson | 1980-10-14 | NULL | - | 7188204004 | UNKNOWN | 877 Central Avenue | PHOENIX | AZ | 85058 | UNKNOWN | — |
| PRV | PRV-28809 | 2026-02-18T11:13:26Z | Valentina | — | Williams | 1982-09-21 | — | ·UNKNOWN | 928-651-2546 | ·· | 8185 Mesa Drive | Columbus | OH | 43287-7144 | null·· | UNKNOWN |
| PRV | PRV-20277 | 2026-07-29T15:43:06Z | MARIA | — | COLEMAN | 26-06-2008 | UHC-49758-95 | — | +1 231 507 3874 | null·· | 3616 Camelback Rd | Nashville | TN | 37240 | - | — |
| PRV | PRV-28404 | 2026-06-01T13:24:41Z | Andrea | — | Harey | 1975-03-08 | UHC4558006 | •••-••-3078 | 9193260838 | andrea.harvey@proton.me | 7038 Valley View Drive | Phoenix | AZ | 85075-7135 | - | — |
| PRV | PRV-20602 | 2026-08-18T13:18:19Z | Natalie | T. | Palmer | ·1973-09-04 | UHC-30236-51 | ·NULL | +1 736 774 4331 | natalie.palmer83@gmail.com | UNKNOWN | — | — | — | - | CORE-HMO |
| PRV | PRV-25571 | 2026-04-10T01:20:30Z | Ronald | — | Long | 07/10/72 | UHC-17595-06 | •••-••-9594 | 5102469841 | N/A | 3301 OAK STREET #281 | ·CHARLOTTE | North Carolina | 28270 | null | null |
| PRV | PRV-27013 | 2026-01-01T20:59:14Z | DORIS | P | KIGN | 1976-07-06 | N/A | null | ·UNKNOWN | — | 1377 INDIAN SCHOOL ROAD | Tampa | Florida | 33644 | — | N/A |
| PRV | PRV-26476 | 2026-05-20T21:51:05Z | Jennifer | — | Jensen | 28-10-2001 | UHC-53962-93 | N/A | (292) 280-0161 | NULL | 512 Main Street | Houston | TX | 77030 | — | null·· |
| PRV | PRV-23485 | 2026-04-18T15:20:09Z | Keith | R. | Ross | 1996-07-22 | NULL | UNKNOWN | 4175293226 | — | 7356 Maple Avenue #587 | Houston | TX·· | 77015 | UNKNOWN | OPTIONS-PPO·· |
| PRV | PRV-23707 | 2026-02-18T07:44:21Z | CHARLOTTE | — | WASHINGTON | 01/27/2007 | UHC-47321-13 | — | UNKNOWN | N/A | 7562 Union St | Seattle | Washington | 98172 | null | NULL |
| PRV | PRV-28152 | 2026-01-15T07:01:24Z | Edwards, Christine | Y | — | 1955-04-20 | UHC-05546-44 | - | (774) 621-5789 | N/A | 5729 Elm Street | Plano | TX | 75081 | N/A | MEDICARE-ADV-B·· |
| PRV | PRV-26441 | 2026-01-29T22:55:30Z | Diane | — | Henry | ·1975-02-03 | null | NULL | +1 276 907 7913 | NULL | 2927 Ridge Road Apt 7 | Chandler | Arizona | 85268 | N/A | — |
| PRV | PRV-25658 | 2026-02-26T02:21:28Z | Aisha | — | Stone | 1984-07-07 | ·UHC-36349-47 | — | 747-448-1889 | — | 905 MAIN ST | HOUSTON | tx | ···· | — | null |
| PRV | PRV-20668 | 2026-08-03T08:14:40Z | Hiroshi | — | Banks·· | 1989-07-07 | — | •••-••-5388 | null | hiroshi.banks@yahoo.com | 3319 OCEAN AVENUE | LAS VEGAS | NV·· | 89119 | N/A | CORE-HMO |
| PRV | PRV-23230 | 2026-04-17T08:53:48Z | Vyrginia | — | Hudson | 1954-05-12 | UHC-60725-86 | N/A | +1 861 638 8608 | VIRGINIA.HUDSON45@OUTLOOK.COM | 4992 Washington St | Dallas | TX | 75226 | NULL | — |
| PRV | PRV-26648 | 2026-10-10T23:01:37Z | Ralph | A | Mendoza | ·03-11-1977 | UHC-00344-49 | NULL | 17793092735·· | N/A | 1456 Palm Drive | ·LOS ANGELES | CA | 90082 | - | — |
| PRV | PRV-21089 | 2026-01-25T05:07:09Z | Keith | — | ·Degado | 1945-11-19 | UHC2340540 | — | 7185611383 | - | 2236 FOREST AVE #419·· | Sacramento | CA | 95884 | — | OPTIONS-PPO |
| PRV | PRV-23266 | 2026-01-08T20:42:21Z | ALEXANDER | — | REYNOLDS | 08/03/1990 | -·· | — | (699) 304-2577·· | — | 7344 Cedar Lane | Glendale | AZ | 85333 | - | MEDICARE-ADV-B |
| PRV | PRV-23785 | 2026-10-13T10:36:03Z | MARIA | — | OWENS | 1962-11-07 | UHC-11319-80 | NULL | null | maria.owens13@proton.me | 951 Pine Dr | Orlando | fl | 32842 | null | MEDICARE-ADV-B |
| PRV | PRV-22106 | 2026-06-06T12:16:53Z | Watkins, Dylan | — | — | 2007-10-27 | N/A | ·N/A | 802.916.9881 | ·dylan.watkins@gmail.com | ·343 Bayshore Drive | Seattle | Washington | 98191 | - | NULL |
| PRV | PRV-29054 | 2026-07-24T02:24:45Z | RAYMOND | — | JENSEN | 01/26/1965 | UHC-53128-19·· | — | 9292823743 | — | 3947 Market St | Atlanta | GA | 30322 | - | NULL |
| PRV | PRV-22161 | 2026-06-26T14:10:26Z | Hiroshi | R | Harper | 20080306·· | — | •••-••-3763 | 17746266530 | NULL | 6123 BASELINE RD | NASHVILLE | TN·· | — | - | UNKNOWN |
| PRV | PRV-28021 | 2026-01-26T21:02:29Z | CAMILA | — | PHILLIPS | 1977-11-17 | N/A | N/A | 13873790587 | - | 3465 Hillcrest Rd | Atlanta·· | GA | 30305 | UNKNOWN | N/A |
| PRV | PRV-21524 | 2026-09-07T17:22:35Z | ALEXIS | H. | WASHINGTON | 1997-12-03 | ·N/A | — | 262-706-4480 | alexis.washington@aol.com | 5669 Valley View Dr | Columbus | OH | 43234 | null | N/A |
| PRV | PRV-27236 | 2026-05-24T16:03:02Z | judy | — | lee | ·1996-08-09 | - | — | NULL | JUDY.LEE77@ICLOUD.COM | ·3033 MESA DRIVE | Tempe | AZ·· | 85265 | UNKNOWN | — |
| PRV | PRV-25113 | 2026-04-30T07:13:47Z | ARJUN | U | HOLMES | 1978-11-22 | UNKNOWN·· | •••-••-1035 | N/A | - | 5851 Main Street Apt 35 | Glendale | AZ | 85333 | NULL | CORE-HMO |
| PRV | PRV-25963 | 2026-03-18T20:16:31Z | Sandra | G | Schmidt | 01/18/1954 | UHC-39593-67 | — | 7053481 | — | 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:42:40.593Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty