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-27869 | 2026-08-30T10:08:02Z | Gonzzales, George | — | — | 02/26/1944 | UHC-26152-27 | null | 7047922841 | george.gonzales@yahoo.com | — | ·· | — | — | null·· | NAVIGATE-HMO |
| PRV | PRV-28791 | 2026-06-13T15:30:46Z | jacob | X | snyder | ·08/04/1959 | - | — | 5203400319 | - | 3879 Lake View Rd | Charlotte | NC | 28276 | N/A | OPTIONS-PPO |
| PRV | PRV-22511 | 2026-07-21T00:00:55Z | stephanie | — | valdez | 19820219 | N/A | NULL·· | NULL | — | 6959 River Road·· | Gilbert | AZ | 85223 | UNKNOWN | UNKNOWN·· |
| PRV | PRV-26797 | 2026-05-10T19:14:58Z | Gerald | — | Harris | 19930904 | UHC-40919-46 | N/A | UNKNOWN | — | 5549 Market St | Las Vegas | nv | 89128-9853 | ·UNKNOWN | NULL |
| PRV | PRV-20857 | 2026-05-09T03:13:16Z | Allice | — | Wallace | 04-07-1939·· | UHC-88572-65 | •••-••-6496 | - | N/A | 1501 Main Street | Orlando | Florida | 32875 | null | UNKNOWN |
| PRV | PRV-24149 | 2026-07-28T20:31:15Z | Juan | — | Gutierrez | 1975-02-27 | — | ···· | 7099134689 | NULL | 4751 WASHINGTON ST | Las Vegas | NV·· | null | — | — |
| PRV | PRV-20622 | 2026-04-30T08:55:41Z | DIANE | — | STONE·· | 2000-02-21 | — | — | 933-340-1447 | — | 3422 PINE DR | San Antonio | Texas | ·78297 | — | — |
| PRV | PRV-25458 | 2026-04-07T06:00:31Z | RONALD | — | ESPINOZA | 19751025 | null | — | UNKNOWN | — | 3502 LINCOLN WAY | Eden Prairie | MN | 55309 | — | NAVIGATE-HMO |
| PRV | PRV-29014 | 2026-02-19T17:41:04Z | SANDRA | — | BROOKS | 1987-02-20·· | UNKNOWN | - | (687) 916-5579 | NULL | 1171 OAK STREET | Seattle | WA | 98128 | null | OPTIONS-PPO |
| PRV | PRV-20225 | 2026-03-01T14:17:48Z | Ronald | — | Perez | 01/07/80 | — | NULL | — | — | 3180 Elm St | Charlotte | NC | 28284 | — | - |
| PRV | PRV-29118 | 2026-09-04T09:09:17Z | SUE | — | KNIGHT | ·1999-02-05 | — | — | 609-314-8800 | — | 1461 MESA DR | Gilbert | AZ | 85299 | UNKNOWN | MEDICARE-ADV-B |
| PRV | PRV-28847 | 2026-02-02T02:46:50Z | Christian | I. | Simmons | 1996-09-04 | UHC-30204-74 | NULL | 400.859.2499 | CHRISTIAN.SIMMONS57@OUTLOOK.COM | 8494 CENTRAL AVENUE Apt 38 | Phoenix | AZ | 85092 | - | CORE-HMO |
| PRV | PRV-25851 | 2026-04-28T12:56:30Z | Sean | — | Morgan | 2005-10-24 | — | •••-••-3409 | (643) 637-2880 | - | 2936 Canyon Rd | Las Vegas | NV | 89133 | ·· | UNKNOWN |
| PRV | PRV-25772 | 2026-01-05T15:43:48Z | Vazquez, Pamela | — | — | 1951-08-15 | — | N/A·· | (674) 516-4540 | — | ·2911 Sunset Boulevard | NASHVILLE | TN | 37236 | UNKNOWN | UNKNOWN |
| PRV | PRV-25548 | 2026-02-11T15:47:52Z | Michelle | — | Carpenter | 2004-12-26 | UHC-19794-40 | — | 4466247822 | — | 1416 SPRING STREET | Scottsdale | AZ | 85215 | N/A | N/A |
| PRV | PRV-22185 | 2026-08-07T04:01:08Z | AHMED | K | FOX | Aug 23, 1977 | UHC-86795-06 | N/A | 14315376219 | ahmed.fox73@hotmail.com | 7853 Harbor Blvd | Las Vegas | Nevada | 89187 | NULL | — |
| PRV | PRV-21178 | 2026-07-04T04:25:57Z | Steven | — | Little | 1957-12-22 | UHC-14266-65 | - | +1 851 807 2578 | null·· | - | UNKNOWN | null | — | UNKNOWN | OPTIONS-PPO |
| PRV | PRV-27027 | 2026-05-18T03:40:10Z | AISHA | O | BROOKKS | 1951-06-13 | null | — | ·+1 256 324 7034 | null | 3747 Canyon Road | Jacksonville | ·FL | 32260-9630 | N/A | — |
| PRV | PRV-25396 | 2026-08-21T01:17:35Z | judith | — | cunningham | 06/05/86 | null | — | 7135194974 | null | 244 Broadway | Sacramento | CA | 95828 | — | N/A |
| PRV | PRV-25611 | 2026-03-22T03:32:44Z | ARTHUR | — | ·LYNCH | 4/3/1952 | UHC-12744-38 | N/A | (734) 411-1029 | - | 3939 Grand Avenue | Charlotte | NC·· | 28219 | — | NULL |
| PRV | PRV-28690 | 2026-07-15T22:27:53Z | Arjun | — | Martinez | 1977-04-11 | — | — | (626) 365-0166 | - | 5901 Central Avenue #438 | Phoenix | az | 85091 | — | UNKNOWN |
| PRV | PRV-25723 | 2026-05-14T11:12:19Z | Lisa | V | Hudson | ·1/10/1957 | UHC-49171-42 | N/A | 719.276.3236 | lisa.hudson@yahoo.com | 19 Broadway | Phoenix | AZ | 85068 | NULL | N/A |
| PRV | PRV-25596 | 2026-03-17T19:34:05Z | Martin, Jemes | — | — | 1966-02-17 | UNKNOWN | - | — | - | 5807 Lincoln Way | Tampa | FL | 33651 | UNKNOWN | ·UNKNOWN |
| PRV | PRV-29160 | 2026-06-25T04:39:49Z | Raymond | Y | Chapman | 1974-12-27 | UHC5766796 | — | 202-346-7133 | — | 3099 Maple Ave | Houston | TX | 77002·· | — | CHOICE-PLUS-PPO |
| PRV | PRV-24834 | 2026-01-27T12:40:53Z | Jerry | — | Watkins | 19570707 | — | null | (940) 770-3748 | ···· | 2207 WASHINGTON STREET | Los Angeles | CA | 90098 | — | SELECT-EPO·· |
| PRV | PRV-22661 | 2026-08-08T09:14:42Z | DAVID | — | COLE | 1986-07-26 | — | ·null | N/A | ·null | UNKNOWN | UNKNOWN | - | null | — | SELECT-EPO |
| PRV | PRV-28976 | 2026-02-09T14:27:31Z | Dunn, Maria | M | — | 1994-05-25 | — | — | (427) 666-8119 | null | NULL | — | N/A | - | - | N/A·· |
| PRV | PRV-22193 | 2026-08-05T12:07:26Z | Shirley | K | Guerrero | 1944-06-02 | UHC-91027-43 | null | 9087148433 | shirley.guerrero@outlook.com | null | NULL·· | — | UNKNOWN | NULL | - |
| PRV | PRV-25796 | 2026-08-30T12:29:08Z | Bryan | — | Walker | 1962-11-10 | NULL | — | 8027789037 | null | 385 OAK ST | Miami·· | FL | 33144 | — | UNKNOWN |
| PRV | PRV-21642 | 2026-03-12T16:26:09Z | ·Carol | — | Gonzalez | Oct 9, 1955 | UHC5213969 | UNKNOWN | N/A | N/A | 6918 Desert Sky Boulevard #784 | ·Minneapolis | ·MN | null | NULL·· | N/A |
| PRV | PRV-21831 | 2026-01-30T19:15:59Z | Billy N | — | Austin | 1944-10-09 | ·· | •••-••-6636 | +1 709 840 6444 | billy.austin31@gmail.com·· | 386 Ocean Ave | San Diego | CA | 92171 | — | NAVIGATE-HMO |
| PRV | PRV-27785 | 2026-07-28T14:25:38Z | AARON | — | BARNES | 27-11-1945 | UHC-75608-11·· | — | 809-281-8450 | AARON.BARNES@ICLOUD.COM | 9539 River Rd | Columbus·· | OH | 43270 | ···· | N/A |
| PRV | PRV-25831 | 2026-09-30T09:37:05Z | SAMUEL | — | FIELDS | 1973-02-01 | UHC-70900-77 | N/A | 6908229153 | -·· | 2094 DESERT SKY BOULEVARD #366 | Fresno | CA | ·93725 | null | — |
| PRV | PRV-27490 | 2026-03-01T13:52:33Z | JEEFFREY | — | COOK | 1986-04-06 | UHC-48436-17 | — | — | null | 7290 Highland Ave | Minneapolis | Minnesota | 55405 | NULL·· | navigate-hmo |
| PRV | PRV-26143 | 2026-08-10T16:34:51Z | PAMELA | ···· | BROWN | 2003-11-10·· | N/A | — | null | PAMELA.BROWN89@AOL.COM | 6660 MAPLE AVE | Orlando | FL | 32806 | null | ···· |
| PRV | PRV-26787 | 2026-03-26T06:36:06Z | Wayne | — | Watkins | 1997-09-27 | UHC8536447 | — | 369-395-9993 | wayne.watkins15@yahoo.com | 2153 OCEAN AVE #670 | Seattle | Washington | 98130 | — | NAVIGATE-HMO |
| PRV | PRV-25280 | 2026-01-04T14:20:24Z | Cheryl | C | Buutler | 1972-02-27 | null | - | 18107993504 | N/A | 7407 OCEAN AVENUE | Atlanta | GA | — | — | N/A·· |
| PRV | PRV-21899 | 2026-02-11T06:08:37Z | VIRGINIA | — | GREENE | 2005-06-22 | UHC-49687-56 | •••-••-3329 | (265) 552-4091 | — | 4747 WILLOW COURT | San Diego | California | 92152 | UNKNOWN | null |
| PRV | PRV-26427 | 2026-06-14T23:03:15Z | brenda | W.·· | edwards | 12/10/66 | NULL | N/A | (863) 479-4468 | NULL | 5077 Hillcrest Rd | CHARLOTTE·· | NC | 28204 | N/A | UNKNOWN |
| PRV | PRV-25016 | 2026-03-14T06:58:07Z | Read, Jeremy | ·· | — | 1948-03-21 | UHC-59517-34 | null | 3464800666 | — | 8795 Valley View Dr | Nashville | ·TN | 37237 | — | — |
| PRV | PRV-24132 | 2026-04-01T07:52:34Z | Carlos | U. | ·Daniels | 1943-06-12 | N/A | N/A | 495.417.1444 | CARLOS.DANIELS39@GMAIL.COM | 7763 Main Street | GILBERT | Arizona | 85218 | — | MEDICARE-ADV-A |
| PRV | PRV-21907 | 2026-06-25T10:51:54Z | Ralph | — | Ngguyen | 1958-05-12 | UHC-95967-21 | N/A | 718.463.3452 | — | N/A | - | UNKNOWN | UNKNOWN | - | — |
| PRV | PRV-26485 | 2026-05-06T10:33:29Z | PRIYA | H | ORTIZ | 1943-10-11 | UHC8252911 | null | (622) 835-8243 | PRIYA.ORTIZ35@YAHOO.COM | 3640 Lake View Rd | Dallas | TX | 75241 | — | NAVIGATE-HMO |
| PRV | PRV-24701 | 2026-04-19T21:36:29Z | Aaron | T·· | ·Simpson | 05/22/05 | UHC-21933-26 | •••-••-2495 | 16439817281 | aaron.simpson1@aol.com | 659 Washington Street | MIAMI | FL | 33175 | UNKNOWN | — |
| PRV | PRV-27023 | 2026-09-12T11:54:32Z | Doriis | — | Weaver | 19940404 | UHC8501809 | •••-••-7086 | 15397801661 | NULL | UNKNOWN | null | UNKNOWN | UNKNOWN | N/A | — |
| PRV | PRV-21476 | 2026-06-25T05:22:23Z | William | — | Dominguez | 26-05-1971 | uhc-78896-13·· | N/A | 4583567555 | william.dominguez@icloud.com | 7833 Baseline Road | Columbus | ·OH | ·43213 | N/A | — |
| PRV | PRV-21647 | 2026-06-29T18:44:42Z | CHRISTOPHER | — | PAYNE | 2000-05-20 | null | - | 694-765-0155 | NULL | 6425 Desert Sky Boulevard | Miami | FL | 33151 | null | - |
| PRV | PRV-23068 | 2026-01-08T06:55:01Z | Victoria | — | Contreras·· | 07/19/1974 | — | - | (510) 228-2443 | victoria.contreras@aol.com | — | null | — | UNKNOWN | null | NULL |
| PRV | PRV-28546 | 2026-04-07T20:15:50Z | LARRY | ···· | TAYLOR | 10-04-1939·· | UNKNOWN | •••-••-9643 | - | N/A | 3402 OCEAN AVENUE | Tampa | FL | 33652·· | UNKNOWN | UNKNOWN |
| PRV | PRV-28983 | 2026-01-24T18:34:27Z | SARAH | — | EVANS | 2005-06-24 | — | •••-••-4046 | +1 786 351 8033 | NULL | 834 CEDAR LANE | Eden Prairie | MN | 55356 | — | — |
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.742Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty