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-23922 | 2026-06-18T20:42:56Z | Stephen | — | Hansen | ·1939-05-11 | uhc-67426-32 | — | - | null | 8089 PINE DRIVE | FRESNO | ca | 93739 | N/A | - |
| PRV | PRV-23313 | 2026-05-02T06:14:10Z | Kayla | S | Crter | 1970-04-24 | UNKNOWN | •••-••-6873 | 4004654563 | ·kayla.carter38@outlook.com | 3471 APACHE BOULEVARD·· | Miami | Florida | - | - | — |
| PRV | PRV-22043 | 2026-04-06T06:02:03Z | ·Emma | — | ·Santiago | 03/17/95 | UHC-20832-61 | UNKNOWN | 962.794.5315 | — | - | null | N/A | — | - | — |
| PRV | PRV-24181 | 2026-08-09T19:52:54Z | Sophia | G. | Vargas | 1962-06-05 | UHC-93377-20 | N/A | - | sophia.vargas@yahoo.com | 8577 Apache Boulevard | Houston | TX | 77012-6099 | null | NULL |
| PRV | PRV-29414 | 2026-08-01T06:23:41Z | STEPHANIE | E | ALVARADO | 2006-12-17 | — | — | 455-415-8798 | N/A | 985 RIDGE ROAD | San Antonio | TX | 78240 | NULL | UNKNOWN |
| PRV | PRV-29554 | 2026-03-17T23:02:03Z | BRUCE | — | BENNETT | 19660406 | — | •••-••-6459 | +1 202 220 3023 | — | 1262 UNION STREET | Miami | FL | 33108-0044 | — | N/A |
| PRV | PRV-27898 | 2026-08-29T10:57:15Z | KATHRYN | J. | THOMPSON | 02/25/1989 | UNKNOWN | - | (384) 990-9239 | — | 9214 Forest Ave | MINNEAPOLIS | MN | ·55416 | N/A | UNKNOWN |
| PRV | PRV-27828 | 2026-07-21T04:49:21Z | Judith | — | ·Gant | 19680616 | null | N/A | 5394379731 | ·judith.grant24@yahoo.com | 7974 Ridge Rd | Sacramento | ·CA | 95824 | — | — |
| PRV | PRV-27557 | 2026-10-13T05:25:50Z | Larry | — | Scott | 02-05-1959 | — | ·- | — | — | 1815 Lincoln Way·· | Nashville | TN | 37257-9885 | — | null |
| PRV | PRV-21106 | 2026-10-12T07:06:47Z | Mark | — | Fox | Apr 5, 1993 | NULL | — | 747-918-3905 | N/A | 1877 Indian School Rd | Atlanta | ·Georgia | 30302 | N/A | CORE-HMO |
| PRV | PRV-24243 | 2026-02-20T22:00:36Z | Yuki | — | Fowler | 1985-08-17 | UHC-97221-33 | NULL | 858-238-4505 | YUKI.FOWLER@YAHOO.COM | 6317 Apache Boulevard | SCOTTSDALE | AZ | 85203 | - | null |
| PRV | PRV-28078 | 2026-04-05T10:04:36Z | Sofia | L | Mitchell·· | 1969-05-08·· | UHC-25956-67 | N/A | UNKNOWN | - | 1194 Ridge Rd | Miami | FL | 33130 | N/A | OPTIONS-PPO |
| PRV | PRV-22460 | 2026-04-24T13:55:49Z | Gary | ·Q | ·West | 1/17/1998 | UHC-19798-12 | •••-••-6530 | 981-661-2400 | gary.west45@aol.com | 6358 Ocean Ave | Columbus | Ohio | 43278 | — | — |
| PRV | PRV-28236 | 2026-05-06T00:50:38Z | Melissa | — | Hawikns·· | 1975-06-26 | UHC-87638-87 | null | N/A | — | 9255 Harbor Blvd | Chandler | AZ | 85225 | — | N/A |
| PRV | PRV-20770 | 2026-05-17T21:32:20Z | KIMBERLY | R | PATEL | Sep 21, 1992 | null | •••-••-8639 | — | kimberly.patel@icloud.com | 4322 Valley View Dr | Fresno | CA | 93709 | — | — |
| PRV | PRV-24657 | 2026-07-29T20:38:16Z | KATHRYN | — | ORTEGA | 07/27/02 | UHC-85581-79 | •••-••-3769 | 9828990969 | null | 1848 Main St | Atlanta | GA | ·30307 | null | — |
| PRV | PRV-27043 | 2026-07-08T18:12:42Z | Daniel | — | Stephens | 1993-08-03 | - | — | 5985032190 | daniel.stephens@icloud.com | 4109 Willow Ct | Tempe | az | 85244 | null | N/A |
| PRV | PRV-24307 | 2026-07-17T11:03:27Z | Arjun | — | Johnston | 1966-02-05 | N/A | - | (631) 981-2942 | - | 3085 Forest Ave | AUSTIN | TX | 78763 | N/A | CORE-HMO |
| PRV | PRV-27532 | 2026-04-26T14:36:29Z | Betty | — | Griffin | 1981-06-15 | — | null | 735-892-9307 | N/A | 3605 WASHINGTON ST | HOUSTON | tx | 77096 | ·N/A | — |
| PRV | PRV-23551 | 2026-03-10T07:16:08Z | ALICE | — | PORTER | 06/20/1989 | UHC-37723-15 | •••-••-6412 | - | — | 1574 River Rd | Jacksonville | fl | - | null | — |
| PRV | PRV-24475 | 2026-09-27T16:33:28Z | kyle | — | harrison | 15-05-1967 | — | - | 635-964-8948 | kyle.harrison@proton.me | 2106 MOUNTAIN VIEW DRIVE | Gilbert | AZ | 85217 | — | — |
| PRV | PRV-22588 | 2026-09-13T17:43:24Z | CATHERINE | Q | MARQUEZ | 2000-01-20 | UHC-51377-30 | null | 3005268145 | catherine.marquez@gmail.com | 5431 Church St | Austin | TX | 78725-2507·· | null | UNKNOWN·· |
| PRV | PRV-24710 | 2026-04-07T05:56:08Z | Paul | L. | Henry | 19501223 | - | •••-••-8470 | 7779024897 | ···· | 9855 Broadway | COLUMBUS | OH | 43233·· | — | UNKNOWN |
| PRV | PRV-28489 | 2026-01-11T19:54:42Z | Aisha | W | Hudson | 1969-07-28 | — | null | 351-593-0306 | null | 7330 Sunset Boulevard | Tucson | AZ·· | 85756 | ·UNKNOWN | MEDICARE-ADV-A |
| PRV | PRV-22150 | 2026-02-24T21:35:07Z | LUCIA | E. | BUTLER | 12/24/97 | UHC6494999 | •••-••-0147 | 2629085 | ·NULL | 3810 River Rd | Denver | Colorado | ·80210 | N/A·· | null |
| PRV | PRV-20876 | 2026-03-16T22:02:57Z | Gerald·· | — | Cunningham | 1951-07-23·· | UHC-47203-81 | — | 787-567-7578 | GERALD.CUNNINGHAM8@PROTON.ME | 3051 WASHINGTON STREET | Scottsdale | AZ | 85257 | — | N/A |
| PRV | PRV-23261 | 2026-05-19T07:28:12Z | Kathryn | — | Ross | 1980-02-11 | UHC-38480-02 | •••-••-6503 | (269) 203-1668 | NULL | 9505 Harbor Boulevard | Minneapolis | MN | 55442 | ·null | — |
| PRV | PRV-26575 | 2026-05-29T00:18:29Z | Justin | M. | Knight | 10/27/1985 | UHC-39714-96 | - | 12555761995 | UNKNOWN | 2762 FOREST AVENUE | Seattle | WA·· | 98102·· | — | — |
| PRV | PRV-24643 | 2026-06-23T23:57:14Z | George | A | Bryant | — | UHC-88695-40 | NULL | null | george.bryant@aol.com | 2407 Bayshore Dr | San Diego | CA | 92181 | — | — |
| PRV | PRV-22749 | 2026-05-11T18:52:56Z | HEATHER | S | — | 05/18/60 | N/A | — | 726-398-8696 | ·HEATHER.WOOD@OUTLOOK.COM | — | — | — | null | null | — |
| PRV | PRV-26183 | 2026-02-27T08:33:44Z | ·Gabriel | — | Torres | 1962-04-24·· | UHC-05549-07 | — | 7469559 | GABRIEL.TORRES@PROTON.ME | ·2356 Desert Sky Blvd | Nashville | Tennessee | 37249 | NULL | null |
| PRV | PRV-22168 | 2026-01-21T17:36:22Z | mateo | A | lane | 10/27/1942 | — | NULL | 710-520-9273 | NULL·· | 3117 PINE DRIVE | Miami | FL | 33136 | — | ···· |
| PRV | PRV-25886 | 2026-02-11T10:41:42Z | kyle | J | garrett | 20-02-1972 | — | N/A | 508-657-8915 | kyle.garrett15@proton.me | 1381 APACHE BOULEVARD | JACKSONVILLE·· | FL | ·32299 | N/A | ···· |
| PRV | PRV-27234 | 2026-03-07T06:24:20Z | EUGENE·· | A. | ROBERTSON | 2001-11-10 | UHC-32080-48 | •••-••-8804 | +1 553 656 3521 | N/A | 8505 PALM DR Apt 22 | Columbus | OH | 43265 | — | null |
| PRV | PRV-21153 | 2026-02-09T05:13:25Z | Ryan | — | Jimenez | 1955-06-10 | NULL | N/A | NULL | UNKNOWN | 2708 Forest Ave | Denver | CO | 80294-1624 | — | — |
| PRV | PRV-28531 | 2026-09-08T18:09:44Z | Margart | — | Stewart | 04/20/1978 | — | •••-••-7303 | 620-906-8342 | margaret.stewart@outlook.com | 3045 WILLOW COURT | Phoenix | AZ | 85088 | - | — |
| PRV | PRV-29134 | 2026-06-24T00:18:01Z | JOSHUA | — | GONZALES | 2001-03-06 | — | •••-••-7577 | 14668332251 | UNKNOWN | 4712 SUNSET BOULEVARD | PHOENIX | Arizona | 85052 | NULL | - |
| PRV | PRV-21512 | 2026-01-07T10:36:03Z | ANA | — | CONTRERAS | 5/17/2003 | - | •••-••-3512 | 6187624848 | null | 9416 RIDGE ROAD | Atlanta | GA | 30359 | NULL | MEDICARE-ADV-B |
| PRV | PRV-28466 | 2026-03-26T01:40:07Z | Dylan | — | Lynch | 03/16/99 | - | — | (860) 920-9818 | UNKNOWN | 5219 BASELINE RD | Orlando | ·FL | 32866 | null | MEDICARE-ADV-B |
| PRV | PRV-26620 | 2026-09-24T06:01:11Z | Danny | — | Black | 2005-02-09 | — | - | — | daniel.black12@aol.com | 4370 Spring Street #768·· | Phoenix | AZ | 85078 | -·· | — |
| PRV | PRV-26989 | 2026-08-14T04:43:56Z | JACQUELINE | V | COOK | 1960-06-10 | ·UHC-56396-26 | — | — | JACQUELINE.COOK@HOTMAIL.COM | 4684 Elm Street | Scottsdale·· | ·AZ | 85203 | N/A | null |
| PRV | PRV-29281 | 2026-10-03T13:47:05Z | Denise | — | Robertson | 1947-09-05 | UHC-42523-92 | UNKNOWN | 806-874-4904 | — | 6834 MARKET ST | Tucson | AZ | 85763 | NULL | N/A |
| PRV | PRV-27568 | 2026-01-20T00:38:29Z | RONALD | — | MORALES | 1948-01-28 | N/A | •••-••-4360 | 5609962582 | N/A | 2228 Church St | Phoenix | AZ | 85044 | — | null |
| PRV | PRV-23082 | 2026-10-03T05:21:04Z | Simmons, Jeffrey | N.·· | — | 1977-03-08 | UHC-64891-47·· | •••-••-9766 | +1 880 948 3626 | NULL | 6175 RIVER ROAD | Tempe | ·AZ | 85240 | null | ·UNKNOWN |
| PRV | PRV-27708 | 2026-06-03T17:26:35Z | Kimberly | — | Black | 1991-04-16 | UNKNOWN | — | null | KIMBERLY.BLACK@HOTMAIL.COM | 8087 Pine Dr | Tempe | AZ | NULL | - | NULL |
| PRV | PRV-22160 | 2026-10-10T01:09:12Z | ·Seven | — | ·Vasquez | 1957-06-27 | uhc-60190-71 | UNKNOWN | (218) 404-8209 | NULL | 6946 Meadow Lane | Orlando | FL | 32826 | NULL | navigate-hmo |
| PRV | PRV-20931 | 2026-09-12T10:08:00Z | Tyler | F | Carroll | 1955-07-23 | — | UNKNOWN | 4672936962 | — | 4135 Ocean Avenue | ·Austin | TX | 78721 | - | null |
| PRV | PRV-21336 | 2026-03-23T02:17:50Z | debra | — | merquez | 1996-03-18 | UHC-56584-90 | UNKNOWN | 5879686316 | UNKNOWN | 6543 Lincoln Way·· | MESA | AZ | 85274 | NULL | NULL |
| PRV | PRV-20862 | 2026-02-05T23:04:33Z | ETHAN | — | VAZQUEZ | 1990-01-23 | UHC-36033-31 | — | NULL | N/A | 1776 LAKE VIEW ROAD | ORLANDO | FL | 32853 | UNKNOWN | null |
| PRV | PRV-22609 | 2026-03-07T18:24:34Z | Jaffrey | — | Griffin | 1944-08-13 | UHC-57372-73 | NULL | 630-814-4980 | — | 8977 RIDGE RD·· | SEATTLE | WA | 98189 | N/A·· | N/A |
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:49.103Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty