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-24327 | 2026-04-01T23:29:14Z | Sofia | — | ·Clark | 1987-06-19 | — | — | (360) 726-8580·· | N/A | N/A | - | — | — | ·· | — |
| PRV | PRV-21604 | 2026-09-01T03:01:52Z | Lawrence | — | ·Warren | 19610503 | UHC-31399-31 | - | 506-318-3429 | NULL | 7599 INDIAN SCHOOL RD | Miami | FL | 33150 | — | CORE-HMO |
| PRV | PRV-23352 | 2026-06-06T14:47:42Z | SANTIAGO | — | HENRY | 06-11-1995 | UHC-14707-79 | UNKNOWN | — | — | 226 CANYON ROAD | Mesa | AZ | 85255 | UNKNOWN | ···· |
| PRV | PRV-25065 | 2026-01-01T00:20:49Z | Hannah | — | Williams | 1972-04-05·· | UHC-24476-29 | — | 681-202-1493 | hannah.williams@proton.me | — | ·NULL | NULL | NULL | N/A | SELECT-EPO |
| PRV | PRV-22419 | 2026-05-20T21:01:05Z | priya·· | — | clark | 1940-07-26 | null | — | +1 757 681 5457 | UNKNOWN | N/A | ·· | NULL | N/A | NULL | UNKNOWN |
| PRV | PRV-27576 | 2026-06-12T05:55:26Z | Denise | W | Chapman | 2005-07-28 | UHC-35764-34·· | — | 413-565-0747 | — | 6110 Grand Avenue | CHANDLER | AZ | 85264 | — | ·- |
| PRV | PRV-27130 | 2026-01-31T16:02:02Z | jason | — | chavez | 06/07/54 | null | •••-••-9310 | 638-976-3999 | UNKNOWN | 825 FOREST AVENUE #317 | Tampa | fl | — | NULL | null |
| PRV | PRV-27819 | 2026-04-09T07:29:25Z | KELLY | — | ROBINSON | 19810719 | — | NULL | +1 924 505 8985 | - | 7506 Cedar Ln Apt 11 | Orlando | FL | 32883 | — | — |
| PRV | PRV-27397 | 2026-01-06T09:56:10Z | Larry | — | Duncan | Apr 28, 1989 | UNKNOWN | NULL | — | — | 9313 BASELINE RD Apt 31 | Eden Prairie | MN | 55346 | — | N/A |
| PRV | PRV-26016 | 2026-03-16T21:22:10Z | Tyler | — | Li | Feb 8, 1939 | uhc-35505-93 | •••-••-3302 | 507-569-4556 | ·UNKNOWN | 3573 GRAND AVE | Las Vegas | NV | 89111-7603 | null | MEDICARE-ADV-A·· |
| PRV | PRV-27943 | 2026-04-29T12:40:03Z | ISABELLA | — | SINGH | 19491114 | uhc-14951-40 | NULL | N/A | isabella.singh@icloud.com | 8764 Baseline Road #853 | Columbus | OH | UNKNOWN | N/A | UNKNOWN |
| PRV | PRV-26366 | 2026-10-17T18:20:37Z | JACOB | — | RAMIREZ | Jun 1, 1979 | UHC-89226-72 | NULL | 2072070968 | - | 6959 Willow Ct | Tempe | AZ | 85296 | — | NULL |
| PRV | PRV-23117 | 2026-02-28T22:52:29Z | Fatima | Z | Baker | 19821222 | null | NULL | ·7482443393 | — | 7973 APACHE BOULEVARD | Chandler | AZ | 85289 | ···· | -·· |
| PRV | PRV-24991 | 2026-07-20T12:07:03Z | Michael·· | — | Barnes | 1951-12-12 | ·UHC-61882-38 | — | 2883789898·· | ·michael.barnes61@icloud.com | 8521 Desert Sky Boulevard | Jacksonville | FL | 32220 | — | - |
| PRV | PRV-28830 | 2026-01-13T05:56:21Z | DIANE | — | CARTER | 1974-06-22·· | — | — | 379-917-9824 | ·DIANE.CARTER@HOTMAIL.COM | 663 MAIN STREET | San Diego | CA | 92173 | N/A | — |
| PRV | PRV-26282 | 2026-04-15T06:15:36Z | Katherine | V. | Willis | Aug 27, 1995 | - | •••-••-4187 | null·· | KATHERINE.WILLIS@HOTMAIL.COM | ·7286 Market Street | Tampa·· | FL | 33675 | UNKNOWN | — |
| PRV | PRV-20654 | 2026-08-13T01:41:52Z | Jamse | — | Marshall | 2006-09-03 | UHC-35247-81 | null | +1 354 644 3991 | james.marshall@hotmail.com | 2554 Willow Court | SAN ANTONIO | TX | - | NULL | — |
| PRV | PRV-24750 | 2026-04-26T04:33:42Z | TERRY | ·T | MEYER | 19890911 | — | — | 659.994.4418 | TERRY.MEYER1@OUTLOOK.COM | 8620 Ridge Road | Eden Prairie·· | MN | 55361 | — | N/A |
| PRV | PRV-29492 | 2026-03-18T16:27:30Z | ·Bryan | — | Clark | 19780519 | - | null | 13174122429 | NULL | 705 Camelback Rd Apt 27·· | Tampa | Florida | 33638 | N/A | N/A |
| PRV | PRV-20591 | 2026-06-14T11:17:59Z | Mei | F·· | Etrada | 1958-06-13 | UHC-89965-96 | NULL | (986) 775-0981 | N/A·· | ·8211 CHURCH STREET | Tempe | Arizona | 85267 | N/A | UNKNOWN |
| PRV | PRV-28397 | 2026-06-26T08:27:21Z | Jack | — | Warren | 1966-02-10 | - | N/A | 840.769.7979 | jack.warren@hotmail.com | 7172 MOUNTAIN VIEW DRIVE | LOS ANGELES | ·CA | 90037 | ···· | null·· |
| PRV | PRV-28264 | 2026-04-27T15:30:54Z | Susan | — | Vasquez | 1965-02-24 | NULL | UNKNOWN | - | — | 4067 Grand Ave | COLUMBUS | OH | 43204 | ·· | — |
| PRV | PRV-21019 | 2026-04-28T05:23:42Z | Joyce | — | Carroll | 03/15/1974 | UHC-18329-37 | NULL | +1 786 200 4060 | JOYCE.CARROLL67@HOTMAIL.COM | 2079 Indian School Road | Houston | TX | 77060 | NULL | — |
| PRV | PRV-20901 | 2026-07-09T22:05:55Z | gabriel | R | yang | 04/14/1960 | UHC-81771-20 | — | 8706604064 | — | 1130 ELM STREET | Columbus | OH | 43210 | - | N/A |
| PRV | PRV-24131 | 2026-05-20T17:06:29Z | ·DOROTHY | — | BOYD | 1945-09-27·· | N/A | - | 967.678.9974·· | dorothy.boyd73@proton.me | 7813 Lincoln Way | SACRAMENTO | CA | 95894 | NULL | — |
| PRV | PRV-27405 | 2026-02-16T06:38:05Z | DENISE | — | YANG | 1961-03-26 | NULL | UNKNOWN | 357-429-1332 | denise.yang@gmail.com | 1201 River Rd | Tucson | AZ | 85732-7767 | null | — |
| PRV | PRV-26919 | 2026-03-13T13:57:04Z | Jean | — | Holmes | 1977-09-23 | — | — | 18085728724 | — | 5649 Oak St #929 | Los Angeles | California | 90066-8258 | N/A | — |
| PRV | PRV-27376 | 2026-06-11T11:02:48Z | Teresa | — | Rivera | 18-12-1967 | N/A | •••-••-2773 | (613) 374-5860 | — | 9292 Forest Avenue | Fresno | California | — | — | NULL |
| PRV | PRV-24270 | 2026-08-06T06:32:33Z | Charlie | — | Palmer | 2001-02-02 | UHC-16746-02 | — | 9336451819 | N/A | 9260 PALM DRIVE | LAS VEGAS | NV | — | UNKNOWN | ·- |
| PRV | PRV-21755 | 2026-03-16T17:31:02Z | MEI | — | WHITE | 9180-03-25 | UNKNOWN | — | 3536760790 | NULL | 8916 River Road | ·Jacksonville | FL | 32273 | null | — |
| PRV | PRV-27042 | 2026-01-14T13:03:02Z | Judy | — | Montgomery | 1962-02-14 | UHC-91198-73 | — | 7003875748 | — | 6221 Central Avenue | Eden Prairie | MN | 55388 | UNKNOWN | UNKNOWN |
| PRV | PRV-26395 | 2026-01-14T14:22:41Z | Arjun | — | Hansen | 05/27/01 | — | — | 748-854-9079 | arjun.hansen@yahoo.com | 4213 SPRING ST | MINNEAPOLIS | MN | 55428 | — | - |
| PRV | PRV-21007 | 2026-08-01T21:59:56Z | Carolyn | — | — | 2002-11-02 | ·UHC-39760-46 | null | N/A | CAROLYN.JACKSON40@ICLOUD.COM·· | 2843 Mesa Drive | ATLANTA | GA | ·30305 | — | SELECT-EPO |
| PRV | PRV-23505 | 2026-05-15T18:11:03Z | ANA | — | BRADLEY | ·1999-03-06 | ·null | N/A | ·719.860.3873 | N/A | 1725 Spring St | Las Vegas | nv | 89173 | - | SELECT-EPO |
| PRV | PRV-23375 | 2026-09-26T10:40:46Z | ANTHONY·· | — | CARR | 04/27/72 | UHC-16569-19 | ·· | 15814629705 | — | 8920 Sage Ct | Mesa | AZ·· | 85273 | UNKNOWN·· | NULL |
| PRV | PRV-23115 | 2026-08-08T08:24:59Z | ·MASON | — | ·HUNTER | 2003-09-27 | UHC-81262-82 | — | +1 491 923 0308 | MASON.HUNTER@PROTON.ME | 5611 CHURCH STREET | Eden Prairie | Minnesota | 55316 | — | — |
| PRV | PRV-20444 | 2026-04-26T08:07:53Z | Brian·· | — | Cox·· | 1980-04-19 | ·UHC-39816-02 | N/A | ···· | — | 4972 Washington St | EDEN PRAIRIE | MN | 55352 | — | UNKNOWN |
| PRV | PRV-28239 | 2026-06-17T14:43:18Z | ·Roy | — | Gonzalez | 1944-06-16 | UHC-99240-65 | UNKNOWN | 9507968171 | N/A | 1918 ELM STREET | Chandler·· | AZ | 85293 | — | NAVIGATE-HMO |
| PRV | PRV-27553 | 2026-04-29T09:58:45Z | ·HEATHER | ···· | MEYER | 1985-05-19 | UHC-17486-97 | N/A | 16239850085 | heather.meyer@proton.me | 9200 Harbor Boulevard | Charlotte | NC | 28252 | NULL | N/A |
| PRV | PRV-24529 | 2026-07-15T17:36:04Z | Hall, George | — | ···· | 2008-02-17 | — | — | 2997242 | ·NULL | 6086 MAPLE AVE | DALLAS | TX | 75269 | — | — |
| PRV | PRV-25013 | 2026-03-20T12:02:09Z | William | — | Wallace | 11/20/1997 | UHC-76716-58 | — | (662) 363-1782 | N/A | ·7044 Union St | Tempe | AZ | 85270 | — | OPTIONS-PPO |
| PRV | PRV-21484 | 2026-01-21T06:45:06Z | JERRY | — | ANDREWS | 8/8/1974 | UHC-29366-06·· | null | 710-321-5741 | — | 3021 HILLCREST RD | Plano | TX | 75055 | — | — |
| PRV | PRV-23719 | 2026-05-31T22:12:59Z | ·Burke, Marcus | — | — | 4/17/2008 | UHC-79080-92 | — | (857) 381-9812 | marcus.burke@yahoo.com | 4628 RIVER ROAD | San Antonio | TX | 78278 | UNKNOWN | UNKNOWN |
| PRV | PRV-27804 | 2026-07-05T18:24:59Z | Soto, Martha | Q. | — | 1987-07-21 | UHC-39559-98 | N/A | (649) 412-3942 | MARTHA.SOTO@PROTON.ME | 1011 Lincoln Way | Glendale | AZ | 85337 | null | N/A |
| PRV | PRV-25878 | 2026-07-30T23:51:09Z | Diane | — | Reid | 1954-02-03 | NULL | - | 482-419-0082 | — | 2365 Sage Ct | Houston | TX | 77045 | — | NULL |
| PRV | PRV-21969 | 2026-07-09T23:08:01Z | ABIGAIL | — | PEREZ | 1980-05-24 | UHC-17361-46 | — | 838.880.2281 | — | 7594 Sage Ct | Las Vegas | NV | 89115 | null | N/A |
| PRV | PRV-25313 | 2026-03-10T03:38:10Z | SEAN | — | DIXON | 20001004 | null | N/A | 347.755.0518 | sean.dixon65@icloud.com | 3247 Mountain View Drive | Nashville | Tennessee·· | 37264 | - | — |
| PRV | PRV-23808 | 2026-10-02T02:45:18Z | MARIANA | ·P | WEST | 20041118 | UHC-69843-37 | •••-••-9258 | +1 275 235 2705 | - | 597 Valley View Dr | Atlanta | ga | 30397 | - | — |
| PRV | PRV-27981 | 2026-08-08T03:46:03Z | Nicholas | H | Le | 19770515 | null | - | (857) 739-6860 | — | 4494 SPRING ST | Orlando | FL | 32812 | NULL | CORE-HMO |
| PRV | PRV-26550 | 2026-07-28T07:23:28Z | Wei | — | Smith·· | 11/07/75 | UNKNOWN | •••-••-9261 | +1 296 332 0783 | — | 5845 Camelback Rd | Nashville | ·TN | 37226 | ·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:38.477Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty