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-28610 | 2026-03-04T07:54:12Z | Harold | — | Green | 1949-02-27 | UHC-22405-40 | UNKNOWN | 809-265-9483 | harold.green@proton.me | 5450 Spring St | Seattle | WA | — | NULL | — |
| PRV | PRV-24777 | 2026-05-06T18:03:00Z | Allan·· | — | Marquez | 2020-02-16 | UHC-88620-29 | null | N/A | — | 2304 Central Ave | Fresno | CA | 93742 | N/A | - |
| PRV | PRV-23004 | 2026-07-05T19:03:28Z | ·Roy | — | Torres | 1994-07-03 | UHC-49244-99 | ···· | 696-349-4377 | ROY.TORRES44@PROTON.ME | — | — | UNKNOWN | ·· | - | UNKNOWN |
| PRV | PRV-21073 | 2026-05-02T21:02:27Z | grace·· | — | welch | 1951-12-11 | — | UNKNOWN | +1 969 816 2203 | — | 5334 Lake View Road·· | CHARLOTTE | NC | 28299 | — | — |
| PRV | PRV-22692 | 2026-02-10T23:42:47Z | Jones, Eugene | — | — | 1966-02-20 | UHC-84030-43 | •••-••-2628 | — | NULL | ·1907 BROADWAY | Chandler | AZ | 85295 | NULL | UNKNOWN |
| PRV | PRV-23489 | 2026-08-31T04:37:33Z | Hannah | — | Sims | 11/24/85 | UHC-61845-14 | N/A | UNKNOWN | NULL | 9768 Sunset Blvd | Dallas | TX | 75256 | — | null |
| PRV | PRV-21874 | 2026-07-03T08:17:19Z | JOYCE·· | — | VEGGA | 2003-11-25 | UHC-52734-38 | NULL | 960-902-0251 | — | 7706 Meadow Ln | Gilbert | AZ | 85233·· | NULL | N/A·· |
| PRV | PRV-28686 | 2026-02-27T12:17:39Z | STEPHEN | — | KELLEY | 11/11/76 | UNKNOWN | — | 6827089888 | stephen.kelley70@yahoo.com | - | null | null | NULL | — | - |
| PRV | PRV-25824 | 2026-05-25T17:07:35Z | Danielle | X | Cox | 19430412 | UNKNOWN | N/A | (713) 400-7297 | DANIELLE.COX@OUTLOOK.COM | 5635 Spring St | SACRAMENTO | California | ·95887 | — | N/A |
| PRV | PRV-23965 | 2026-06-01T05:23:29Z | JOSHUA·· | M | YANG | 08/04/2005 | UHC-41387-41 | — | ·5506881599 | — | 463 Palm Drive #848 | Plano | TX | 75040-2427 | N/A | — |
| PRV | PRV-27225 | 2026-06-26T16:47:58Z | amber | — | perkins | 1978-11-22 | ·UHC-05855-16 | •••-••-7117 | — | amber.perkins@gmail.com | 5171 Elm Street | Charlotte | ·NC | 28204 | - | ·- |
| PRV | PRV-28252 | 2026-06-24T19:12:32Z | SANTIAGO | — | ADASM | 1981-12-07 | ···· | •••-••-4645 | +1 391 326 0254 | — | 9625 Camelback Rd | Jacksonville | FL | 32274 | N/A | NULL |
| PRV | PRV-25841 | 2026-06-17T15:39:43Z | OLIVIA | — | ARNOLD | 1940-05-23 | — | - | (800) 604-6003 | null | 824 Forest Ave | Plano | TX | 75049-9160·· | null | N/A |
| PRV | PRV-29155 | 2026-07-19T14:50:40Z | Edward | K·· | Burton | 10/20/2004 | UHC-96686-35 | •••-••-5528 | 833-908-9193·· | EDWARD.BURTON86@PROTON.ME | 1763 PALM DR | Mesa | AZ | 85244 | — | MEDICARE-ADV-B·· |
| PRV | PRV-21058 | 2026-07-13T00:37:18Z | cheryl | — | scott | 07/23/71 | — | — | 8743440020 | null | 9254 Union Street | MIAMI | FL | 33196 | N/A | — |
| PRV | PRV-21991 | 2026-05-18T20:43:29Z | Christian | — | Morrison | 06/28/1969·· | — | — | 15332752929 | ···· | 7318 MESA DRIVE | TEMPE | AZ | 85234 | - | MEDICARE-ADV-B·· |
| PRV | PRV-20609 | 2026-04-12T01:16:45Z | Boyd, Mike·· | ···· | — | 07/23/1992 | UHC-19257-78 | — | +1 397 543 1757 | — | 5328 Ridge Road·· | San Antonio | TX | 78231-1877 | — | ·MEDICARE-ADV-A |
| PRV | PRV-20761 | 2026-05-04T15:27:42Z | Dona | G | Torres | 1981-10-11 | UHC-70484-11 | NULL | ·14119959668 | - | ·8447 Willow Ct | Orlando | ·fl | 32879 | UNKNOWN | — |
| PRV | PRV-20366 | 2026-06-28T04:30:02Z | Dan | — | Murphy | 1995-03-23 | — | •••-••-9446 | 867-903-1701 | — | UNKNOWN | null | — | — | UNKNOWN | MEDICARE-ADV-A |
| PRV | PRV-28628 | 2026-08-19T00:24:16Z | Raymond | — | Day | 7/2/1984·· | null | •••-••-9727 | (837) 256-9229 | — | 227 Elm Street Apt 37 | Tucson | AZ | 85757 | - | — |
| PRV | PRV-28978 | 2026-02-05T01:11:41Z | OLIVIA | — | HAWKINS | Jul 12, 1955 | null | •••-••-4945 | — | — | null | null | — | — | null | NULL |
| PRV | PRV-29332 | 2026-02-22T22:09:18Z | MARGARET | — | FERNANDEZ | Sep 28, 1938 | - | - | N/A | margaret.fernandez45@gmail.com | 1878 OCEAN AVENUE | Atlanta | GA | 30309 | - | UNKNOWN |
| PRV | PRV-22699 | 2026-09-14T02:26:09Z | RACHEL | — | SULLIVAN | 1999-10-18 | UHC-71527-15·· | — | 5297174849 | NULL | 2625 Grand Ave | Eden Prairie | MN | 55312-5934 | — | CORE-HMO |
| PRV | PRV-22551 | 2026-04-01T05:51:25Z | Stephen | ·· | Munoz·· | 1971-04-11 | NULL | UNKNOWN | 583-855-6176 | stephen.munoz14@proton.me | 4303 Maple Ave | Scottsdale | Arizona | 85280 | ·· | NULL |
| PRV | PRV-25188 | 2026-07-29T08:49:36Z | Michelle | — | Green | 1975-07-07·· | UNKNOWN | UNKNOWN | — | null | — | — | — | — | — | - |
| PRV | PRV-29204 | 2026-07-26T17:35:19Z | charles | Z | jimenez | 19460217·· | UHC-25702-22 | UNKNOWN | 981-556-5596 | — | 5023 River Rd | AUSTIN·· | TX | 78767 | UNKNOWN | — |
| PRV | PRV-24832 | 2026-09-25T08:16:48Z | Luis | B | Simmons | 2003-04-13 | ·uhc-91105-47 | — | 9167153948 | LUIS.SIMMONS68@PROTON.ME | 9389 Sunset Boulevard | Scottsdale | AZ | — | ·N/A | NULL |
| PRV | PRV-21493 | 2026-06-24T01:26:33Z | EMMA | O | REED | 6/7/1991 | UHC-91196-41·· | — | 16332224385 | NULL | 161 Desert Sky Blvd | Charlotte | North Carolina | 28294 | - | — |
| PRV | PRV-20981 | 2026-03-13T08:42:12Z | William | — | Cruz | 1964-02-18 | N/A | •••-••-3630 | (850) 410-5099 | — | 8853 Baseline Rd Apt 15 | Chandler | AZ | 85209 | - | — |
| PRV | PRV-21934 | 2026-01-02T23:04:26Z | Fox, Christina | — | — | 4/9/1991 | UHC-46991-39 | null·· | 597.904.3437 | - | 873 SPRING STREET #537 | ·Tempe | AZ | 85245 | N/A | — |
| PRV | PRV-20941 | 2026-03-27T21:01:47Z | Adams, Peter | K | — | 2003-05-10 | N/A·· | •••-••-2087 | (370) 646-8573 | -·· | - | - | UNKNOWN | null | - | CHOICE-PLUS-PPO |
| PRV | PRV-23105 | 2026-06-01T21:22:02Z | ·Ruth | — | Ray | 6/22/1953 | - | NULL | 8209622 | UNKNOWN·· | 3090 Harbor Boulevard | Las Vegas | NV | 89114 | — | — |
| PRV | PRV-21225 | 2026-03-15T15:16:23Z | James | S | Watson | 01/06/63 | - | UNKNOWN | 495.417.7457 | james.watson64@gmail.com | ·784 PALM DRIVE | Jacksonville | FL | 32221·· | — | — |
| PRV | PRV-23122 | 2026-01-31T15:09:45Z | Payne, Josh | — | — | 1946-12-20 | — | — | — | N/A·· | 8870 MAIN ST·· | DENVER | CO | 80285 | — | N/A |
| PRV | PRV-29391 | 2026-01-06T08:16:05Z | Patricia | ···· | Watson | 1939-08-16 | UHC-72592-06 | - | null | — | 5752 Desert Sky Boulevard | Eden Prairie | MN | ·55352-4288 | — | ·OPTIONS-PPO |
| PRV | PRV-25140 | 2026-07-19T20:12:35Z | Jerry | — | Ramos | Oct 7, 1974 | UHC-14545-99·· | •••-••-6141 | 389-409-2273·· | ·· | 5136 ELM ST | Sacramento·· | CA | 95880 | — | — |
| PRV | PRV-24068 | 2026-05-03T17:22:52Z | ·theresa | — | kelly | 1950-01-02 | UHC-26103-49 | N/A | 687.656.0179 | ···· | N/A | NULL | - | N/A | ·null | UNKNOWN |
| PRV | PRV-28322 | 2026-03-26T10:37:06Z | bradley | J | warren | 2005-07-23 | null | UNKNOWN | +1 588 372 7120 | - | 93 VALLEY VIEW DR·· | ATLANTA | GA | 30385 | N/A | null |
| PRV | PRV-25392 | 2026-08-19T05:41:15Z | Burke, Larry | — | — | 1976-07-03 | UHC-81346-65 | — | +1 616 876 0776 | — | 4801 Willow Ct | ·Tucson | az | 85722 | - | UNKNOWN |
| PRV | PRV-22733 | 2026-07-25T13:38:10Z | Jose | Y | Campbell | 11/18/1993 | — | UNKNOWN | 6243263156·· | JOSE.CAMPBELL96@AOL.COM | 8087 Market Street | Tempe | AZ | 85238 | N/A | ·- |
| PRV | PRV-28183 | 2026-04-06T20:38:27Z | Kye | L | Weber | 1987-08-09 | UHC-48005-03 | UNKNOWN | 9683645938 | — | 9279 Forest Ave | SAN DIEGO | CA | UNKNOWN | ·- | ·· |
| PRV | PRV-22295 | 2026-01-26T08:44:37Z | Samantha | — | Smith | 6/16/1958 | N/A | UNKNOWN | 16027286461 | - | 1097 SPRING STREET | Los Angeles | CA | 90067 | UNKNOWN | — |
| PRV | PRV-21770 | 2026-05-08T04:25:38Z | ·Nicole | — | Sullivan | 2005-09-21 | — | NULL | ·5616350718 | NULL | — | — | UNKNOWN | ···· | null | — |
| PRV | PRV-23097 | 2026-10-16T15:58:49Z | olson | B | ·keith | 2006-03-05 | — | N/A·· | 949-404-8924 | null | 500 Highland Ave Apt 22 | SACRAMENTO | ·CA | 95828 | UNKNOWN | — |
| PRV | PRV-22877 | 2026-03-15T19:25:14Z | CHRISTINA | — | STONE·· | 1992-04-11 | UHC-37469-45 | — | 3259577841 | — | 100 Lake View Rd·· | Columbus | OH | UNKNOWN | — | NULL |
| PRV | PRV-20370 | 2026-07-26T10:23:07Z | TIMOTHY | — | REED | 1963-03-14 | UHC-65404-55 | NULL·· | 12168700023 | — | ·6904 LINCOLN WAY | Columbus·· | Ohio | 43203 | — | null |
| PRV | PRV-21263 | 2026-01-16T15:49:05Z | Matthew | Y | White | 1973-02-91 | null | null | 478.464.4206 | matthew.white35@icloud.com | 8059 Valley View Drive | GILBERT | AZ | 85224 | null | — |
| PRV | PRV-27652 | 2026-03-28T23:49:00Z | ETHAN | E. | SANCHEZ | — | UHC-35179-03·· | null | (562) 327-9904 | ethan.sanchez@gmail.com | 1217 Oak St | SAN ANTONIO | TX | 78252·· | null | ·· |
| PRV | PRV-22881 | 2026-01-13T14:42:34Z | ·Jessica | R | Fox | 5/8/1991 | ·UHC-31731-49 | — | (493) 229-1787 | null·· | 2148 APACHE BOULEVARD | Jacksonville | FL | 32241 | — | core-hmo |
| PRV | PRV-29535 | 2026-03-19T21:44:30Z | Sara | — | Richardson | 1969-10-24 | UHC-63949-90 | •••-••-2737 | 302-881-5493 | sara.richardson50@outlook.com | 7411 Lake View Road | Houston | tx | 77089 | — | — |
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.731Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty