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-27471 | 2026-02-16T15:12:07Z | Lucia | ·· | Guerrero | 2006-03-10 | — | •••-••-3617 | 772-248-2192 | — | 4320 Maple Ave | Sacramento | CA | 95806-0645 | — | N/A |
| PRV | PRV-27578 | 2026-01-12T07:44:13Z | yuki | U | perez | 1986-01-19 | ·· | ·N/A | 6265875624 | ·YUKI.PEREZ@GMAIL.COM | 5798 Elm Street | SACRAMENTO | CA | 95846·· | null | UNKNOWN |
| PRV | PRV-29405 | 2026-01-08T07:25:46Z | DENISE | — | MORALES | 9/16/1952 | ·UHC-22051-95 | — | ·UNKNOWN | NULL | 6636 Meadow Lane | CHARLOTTE | NC | 28220 | ·UNKNOWN | — |
| PRV | PRV-23190 | 2026-08-12T03:39:00Z | OLIVIA | ···· | RAMIREZ | 2002-09-06 | — | •••-••-5401 | 917-814-9036 | - | 3487 Oak Street | AUSTIN | TX | 78763 | N/A | - |
| PRV | PRV-28169 | 2026-01-16T18:36:43Z | Eric | — | Bell | 1950-58-15 | UHC-32632-40 | -·· | (324) 634-5977 | - | 7210 Mountain View Drive Apt 39 | Miami | FL | 33191 | UNKNOWN·· | NULL |
| PRV | PRV-21434 | 2026-05-18T15:08:04Z | MARIANA | C.·· | HAWKINS | Mar 8, 1960 | UHC-87456-54 | •••-••-5799 | (220) 350-9097 | NULL | 9230 Mountain View Drive | Gilbert | az | 85264 | N/A | — |
| PRV | PRV-26959 | 2026-04-29T10:52:49Z | larry | — | cox | 1983-06-01 | - | UNKNOWN | 9553706658 | LARRY.COX@PROTON.ME | 4973 Grand Avenue #668 | Tampa | FL | null | — | — |
| PRV | PRV-24925 | 2026-07-04T12:33:14Z | Nuah | — | Turner | 1949-03-28 | NULL | •••-••-0962 | — | — | 441 Palm Drive #868 | Chandler | AZ | ·85287 | - | UNKNOWN |
| PRV | PRV-25480 | 2026-04-20T10:09:43Z | Betty | L | Johnson | 1948-12-12 | ·· | •••-••-9481 | 729-780-6019 | null·· | 8542 Central Ave | EDEN PRAIRIE | MN·· | 55398 | — | NULL |
| PRV | PRV-20276 | 2026-03-26T01:05:16Z | Debbie | — | ·Powell | 1956-03-01 | UHC-05099-83 | ·N/A | — | null | 931 MARKET STREET | Tempe | AZ | 85203 | N/A | - |
| PRV | PRV-26710 | 2026-06-26T05:51:05Z | ARJUN | J·· | CARTER | 2008-00-24 | N/A | — | 18855956045 | ·NULL | 9536 Sunset Blvd | Tampa | ·FL | 33607 | - | MEDICARE-ADV-B |
| PRV | PRV-25112 | 2026-01-23T11:11:45Z | Martha | — | Henderson | 2008-10-26 | — | — | 3896377268 | - | 6710 Washington St | ·Minneapolis | Minnesota | ·UNKNOWN | — | - |
| PRV | PRV-20989 | 2026-08-06T17:09:21Z | Michael | K.·· | Kelly | 1984-04-04 | UHC-55894-77 | NULL | 314-269-0661 | N/A | 9662 WILLOW COURT | DALLAS | tx | 75200 | N/A | ···· |
| PRV | PRV-27603 | 2026-09-14T17:23:30Z | Ana·· | H | Williams | 1985-11-05 | UHC-92716-76 | •••-••-9470 | (340) 810-8516 | - | 3549 MEADOW LANE | COLUMBUS | ·OH | 43231-7506 | — | - |
| PRV | PRV-22434 | 2026-07-09T15:36:16Z | ARJUN | — | RICHARDSON | 2005-06-21 | N/A | •••-••-6614 | — | - | — | NULL | ·- | - | UNKNOWN | null |
| PRV | PRV-24885 | 2026-10-11T20:34:50Z | Denny | — | Porter | 1950-05-26 | - | •••-••-2941 | 540-762-0023 | UNKNOWN | 4248 Baseline Rd | Eden Prairie | MN | 55341 | null | - |
| PRV | PRV-22997 | 2026-03-31T00:23:23Z | Terry | — | Sms·· | 1938-08-05 | uhc-54059-41 | - | 3879544581 | TERRY.SIMS@AOL.COM | 2868 ELM STREET | Phoenix | AZ | 85023 | — | — |
| PRV | PRV-27148 | 2026-09-08T19:36:53Z | Rachel | R | Anderson | 19560924·· | UHC-70564-37 | — | (389) 323-3009 | RACHEL.ANDERSON@AOL.COM | 6955 Washington St | ·Minneapolis | MN | 55404 | — | N/A |
| PRV | PRV-25416 | 2026-03-30T00:02:47Z | Megan | — | Pena | 19600127 | — | — | null | N/A | 2843 Oak Street | Plano·· | TX | 75015 | ·- | ···· |
| PRV | PRV-21381 | 2026-07-30T19:52:51Z | Knight, Katherine | — | — | 2001-03-26 | — | •••-••-0649 | 891-507-7707 | — | 7895 Willow Ct | Plano | TX | 75049·· | - | MEDICARE-ADV-A·· |
| PRV | PRV-21202 | 2026-01-01T19:23:09Z | MELISSA | — | THOMPSON | 1976-02-10 | UHC-59296-89 | •••-••-3610 | 480.676.0819 | ···· | NULL | NULL | null | NULL | — | MEDICARE-ADV-A |
| PRV | PRV-27609 | 2026-09-14T12:36:24Z | ROGER | — | WELCH | 1941-01-03 | — | - | (422) 742-3511 | UNKNOWN | 7310 Central Ave | Tampa | FL | 33671 | NULL | NULL |
| PRV | PRV-28341 | 2026-06-03T12:52:20Z | Tyler | — | Washington | 1941-08-11·· | UHC-77864-45 | •••-••-2641 | UNKNOWN | ···· | 4828 Harbor Blvd | Sacramento | CA | 95892 | null·· | — |
| PRV | PRV-20853 | 2026-09-08T21:35:35Z | Frances | Q | Jamees | 1971-05-02 | UHC-12248-93 | - | 5543472192 | — | 947 Highland Ave Apt 31 | Phoenix | AZ | 85020 | — | MEDICARE-ADV-A |
| PRV | PRV-20740 | 2026-03-09T14:08:32Z | JAMES | ···· | DELGADO | 1977-12-02 | UHC-33344-70 | N/A | 2208398187 | NULL | 7763 Broadway #785 | ·Tampa | FL | 33649 | - | — |
| PRV | PRV-22563 | 2026-01-10T12:38:17Z | ·ROGER | — | MORRISON | 19920322 | null·· | — | 924-217-6416·· | — | 1173 Apache Boulevard | Las Vegas | Nevada | 89139 | null | — |
| PRV | PRV-20748 | 2026-01-04T00:00:09Z | Christian | — | Webb | 1970-03-12 | UHC-18196-25 | — | 9306451616 | CHRISTIAN.WEBB56@OUTLOOK.COM | 2076 MOUNTAIN VIEW DR Apt 36 | San Antonio | Texas | 78259 | N/A·· | NULL·· |
| PRV | PRV-21644 | 2026-04-16T12:16:00Z | Lori | — | Li | 8/8/1994 | UHC2708642 | -·· | 457-460-7825 | lori.li37@outlook.com | 4073 Camelback Rd | Tucson | AZ·· | 85784 | UNKNOWN | — |
| PRV | PRV-20080 | 2026-03-04T16:11:26Z | Carolyn | — | Fernandez | 01/27/76 | N/A | N/A | 7646313760 | - | 6529 Central Avenue Apt 16 | HOUSTON | TX | 77055 | N/A | - |
| PRV | PRV-27403 | 2026-10-15T04:28:50Z | Grace | — | Dixon | 09/19/83 | UHC6253551 | - | ·810-455-1642 | — | ·5204 Palm Dr | ·MIAMI | FL | 33134·· | — | MEDICARE-ADV-B |
| PRV | PRV-24640 | 2026-01-31T14:12:40Z | ·Julia | — | Mitchell | 19651104 | - | •••-••-9950 | ·684.906.0488 | ·julia.mitchell@yahoo.com | 2886 Valley View Dr | Dallas | TX | 75209 | — | — |
| PRV | PRV-24188 | 2026-01-19T22:48:57Z | CHRISTOPHER·· | — | BOYD | 1972-04-20 | — | — | N/A | - | 7489 Ridge Rd | Denver | CO | 80263 | — | — |
| PRV | PRV-29371 | 2026-08-08T09:57:43Z | Abigail | S | Webb | 1997-07-23 | NULL | UNKNOWN | 7183780 | abigail.webb47@yahoo.com | 7718 HARBOR BLVD | ·Chandler | Arizona | 85238 | null | — |
| PRV | PRV-26639 | 2026-01-01T16:50:20Z | Christian | — | Peterson | 06/14/69 | ···· | null | UNKNOWN | — | 2683 INDIAN SCHOOL ROAD | Eden Prairie | MN | 55358 | UNKNOWN | null |
| PRV | PRV-20185 | 2026-05-31T16:24:34Z | Nicholas | ···· | Lawson | 19-01-1958 | ·UHC-16478-62 | — | 551-802-9643 | nicholas.lawson@icloud.com | 1395 Hillcrest Road #258 | Atlanta | GA | ·30321 | UNKNOWN | MEDICARE-ADV-A |
| PRV | PRV-26845 | 2026-08-07T16:42:26Z | Wong | A. | Fraces | ·11/20/97 | — | •••-••-1182 | 17178921720 | frances.wong@gmail.com | 6245 BROADWAY | Denver | CO | 80235 | UNKNOWN | N/A |
| PRV | PRV-22164 | 2026-07-01T23:31:17Z | PETER | — | ELLIOTT·· | 10/8/1976 | NULL | N/A | 409-860-8284 | — | 6020 River Rd Apt 8 | Charlotte | NC | 28247 | UNKNOWN | MEDICARE-ADV-A |
| PRV | PRV-22828 | 2026-06-15T19:57:37Z | CHARLIE | ···· | TAYLOR | 22-01-1946·· | — | UNKNOWN | - | CHARLES.TAYLOR86@GMAIL.COM | 3261 Jefferson Avenue | Austin | TX | 78763 | NULL | — |
| PRV | PRV-23624 | 2026-01-10T04:21:00Z | BRANDON | — | WHITE | 2000-04-11 | UHC-94755-46 | — | ·null | — | 1696 Apache Boulevard | Las Vegas | NV | 89171 | — | — |
| PRV | PRV-23013 | 2026-04-28T19:22:30Z | MICHELLE | W | CUNNINGHAM | 2007-07-25 | UHC2738813 | N/A | 890-595-6307 | - | 1038 Main St | Gilbert | Arizona | 85250 | — | MEDICARE-ADV-A |
| PRV | PRV-21100 | 2026-04-03T19:03:24Z | SOFIA | — | OLIVER | 08/21/82 | UHC-82300-20 | — | UNKNOWN | null | 3300 MEADOW LN | LAS VEGAS | NV·· | 89149 | null | UNKNOWN |
| PRV | PRV-20894 | 2026-04-14T17:26:06Z | MARCUS | ···· | FIELDS | 1996-03-03 | UNKNOWN | UNKNOWN·· | 6133079537 | marcus.fields76@outlook.com | 8621 Oak St | Nashville | Tennessee·· | 37241 | UNKNOWN | null |
| PRV | PRV-20063 | 2026-02-23T06:31:57Z | ALICE | — | LE | 2005-09-17 | ·· | UNKNOWN | ·2868574050 | — | 4656 HILLCREST RD | Glendale | AZ | 85382 | — | — |
| PRV | PRV-25654 | 2026-06-21T15:44:59Z | GARY | — | JORDAN | 1977-03-09 | ·- | •••-••-7750 | (216) 331-1280 | N/A | - | UNKNOWN | UNKNOWN | — | — | - |
| PRV | PRV-21115 | 2026-02-05T01:16:26Z | Catherine | — | Warren | 1967-02-15 | UHC4227635 | null | 820.842.6413 | NULL | 290 Grand Ave | Fresno | CA | 93735 | — | null |
| PRV | PRV-23187 | 2026-02-03T22:32:33Z | Rck | — | Vsquez | 10/3/1944 | UHC8024221 | UNKNOWN·· | 757-422-4752 | -·· | null | null | null | UNKNOWN | NULL | null |
| PRV | PRV-26076 | 2026-02-02T20:44:58Z | Janet | — | Mendoza | 11/26/1998 | NULL | UNKNOWN | NULL | ·null | 5780 Mountain View Dr | SAN DIEGO | California | 92101 | NULL | - |
| PRV | PRV-24144 | 2026-09-26T04:40:37Z | MICHELLE | — | RIVERA | 1989-06-02 | UHC-89576-64 | — | (322) 573-7826 | null | 6134 Hillcrest Rd | Tampa | fl | ·33667 | — | CHOICE-PLUS-PPO |
| PRV | PRV-25103 | 2026-07-19T10:43:57Z | ARTHUR | T | BURKE | 1/9/1969 | UHC-65754-38·· | ·NULL | (356) 351-6373 | arthur.burke29@proton.me | 9271 Desert Sky Boulevard | Dallas | ·Texas | 75216 | null | ·· |
| PRV | PRV-27075 | 2026-08-21T02:35:01Z | Vicky | — | Schmidt | 1993-04-02 | — | •••-••-2269 | 4482929 | NULL | 82 Canyon Rd | ORLANDO | FL | 32861 | - | 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:40.608Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty