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-26446 | 2026-04-25T12:58:38Z | MARIA | — | DELGADO | 3/2/1987 | UHC-94171-32 | •••-••-4918 | 336-818-1307 | ·NULL | 5393 Grand Avenue | Los Angeles | CA | 90026 | — | NULL |
| PRV | PRV-27066 | 2026-06-19T05:26:40Z | CHRIS | — | PHILLIPS | 2005-12-25 | ·UHC-57380-52 | null | — | — | 5907 Ridge Road | Phoenix | AZ | 85060 | NULL | ·- |
| PRV | PRV-23413 | 2026-08-02T06:41:05Z | Dorothy | — | — | 1945-01-19 | UHC0380059 | — | 5283984440 | null | ·N/A | ·N/A | — | N/A | ·null | CHOICE-PLUS-PPO |
| PRV | PRV-27732 | 2026-06-10T20:33:13Z | Olivia | — | Chapman | 1956-02-05 | UHC-95278-33 | •••-••-1894 | 513-968-0812 | — | 8780 Broadway | Orlando | FL | 32881 | ·· | CORE-HMO |
| PRV | PRV-20711 | 2026-02-24T20:42:49Z | ed | H | espinoza | 1949-08-10 | NULL | ···· | — | NULL | ·2750 Valley View Dr | San Antonio·· | TX | 78297 | — | - |
| PRV | PRV-20364 | 2026-01-05T13:12:54Z | bryan | ·Q | hansen | 11/13/1945 | UHC-58991-88 | N/A | 327-698-8031 | UNKNOWN | 8525 HIGHLAND AVENUE | San Antonio | TX | 78231 | null | — |
| PRV | PRV-22587 | 2026-01-12T22:48:40Z | Catherine | Q | Marquez | 2000-01-20 | — | — | NULL | N/A | — | — | ·· | null | — | ·N/A |
| PRV | PRV-22851 | 2026-02-07T06:17:58Z | HANNH | — | ·LEWIS | ·2002-06-28 | - | UNKNOWN | null | ···· | 236 Church Street·· | DENVER | co | 80227 | N/A | NULL |
| PRV | PRV-21162 | 2026-01-08T06:14:34Z | Fatima | — | Elliott | 11/5/1950·· | ·UNKNOWN | ·NULL | — | — | 5297 INDIAN SCHOOL ROAD | San Diego | CA | 92115 | UNKNOWN | — |
| PRV | PRV-20478 | 2026-06-30T06:15:38Z | SANTIAGO | X | FORD | 1994-12-11 | UHC-19531-20 | N/A | 8246440751 | NULL | 179 Apache Blvd | Tucson | AZ | 85720 | UNKNOWN | NULL |
| PRV | PRV-20553 | 2026-02-21T05:10:59Z | Warren, Emily | — | — | 1996-07-11 | UHC-27010-24 | N/A | - | emily.warren@proton.me | 2811 CENTRAL AVE | Austin | TX | 78730 | UNKNOWN | OPTIONS-PPO |
| PRV | PRV-26498 | 2026-07-17T07:53:27Z | — | — | — | 1956-12-06 | UHC-73484-68 | •••-••-1821 | 2032903503 | — | 6838 Maple Ave | Dallas | TX | 75299 | - | null |
| PRV | PRV-22859 | 2026-02-16T04:22:51Z | Priya | — | — | 4/22/1949 | UNKNOWN·· | null | +1 575 538 8631·· | priya.roberts31@hotmail.com | 7499 MARKET STREET | Las Vegas | Nevada | ·89101 | — | N/A |
| PRV | PRV-26769 | 2026-02-21T08:37:29Z | Betty | — | Gardner | 1960-44-20 | UHC-30425-67 | •••-••-0744 | 282.309.8523 | BETTY.GARDNER42@YAHOO.COM | 7139 Lake View Rd | Fresno | CA | 93763 | - | NULL |
| PRV | PRV-23283 | 2026-09-29T19:13:32Z | Susan | N | Howard | 1994-01-09 | ·null | N/A | ·3035682945 | susan.howard@aol.com | 9163 Willow Court | Plano | TX | 75089 | NULL | UNKNOWN·· |
| PRV | PRV-21987 | 2026-04-19T13:22:48Z | Willis, Aaron | — | — | 1938-05-01 | UHC-70017-39 | - | ·6162576 | NULL | 8138 RIDGE ROAD | Los Angeles | CA | 90021 | — | ·UNKNOWN |
| PRV | PRV-27570 | 2026-04-16T11:49:48Z | KATHLEEN | — | DAY | 1966-11-21 | UHC-04206-33 | null | 4146753098 | - | ·3932 Meadow Ln | Tampa | FL | 33660 | — | null |
| PRV | PRV-28234 | 2026-01-02T17:57:24Z | cheryl | — | richards | 1997-05-27 | UHC-37478-59 | ·N/A | ·435-571-5397 | N/A | N/A | null | UNKNOWN·· | N/A | — | — |
| PRV | PRV-26035 | 2026-05-25T16:53:12Z | Melissa | — | Ramos | 2002-06-10 | UNKNOWN | — | +1 876 376 9108 | melissa.ramos@aol.com | 7751 Bayshore Drive | Chandler | ·AZ | 85233-5736 | UNKNOWN·· | - |
| PRV | PRV-26920 | 2026-05-01T16:55:23Z | YUKI | — | HARRIS | 1950-10-26 | UHC-23626-39 | •••-••-5470 | 9277018 | yuki.harris@gmail.com | 3874 SAGE COURT | Austin | TX | 78720 | -·· | NULL |
| PRV | PRV-26622 | 2026-06-15T09:50:47Z | douglas | — | stevens | 2003-03-17 | — | N/A | — | UNKNOWN | 7040 Oak St | Columbus | Ohio | 43236 | NULL | UNKNOWN |
| PRV | PRV-21510 | 2026-10-18T15:30:58Z | BRITTANY | — | CAMPBELL | 1954-04-18 | null | •••-••-4729 | +1 827 851 7763 | — | 5105 VALLEY VIEW DR | Fresno | CA | 93759 | UNKNOWN | - |
| PRV | PRV-22478 | 2026-10-16T21:53:48Z | Arjun | — | Chavez | 19580721 | UHC-23529-51 | — | — | ARJUN.CHAVEZ@OUTLOOK.COM | — | null | — | NULL | N/A | UNKNOWN |
| PRV | PRV-24923 | 2026-06-14T22:52:05Z | JERRY | — | HALL | Apr 25, 2000 | ·UHC-27759-66 | — | 977-604-6378 | — | 6492 Canyon Rd | Charlotte | NC | 28212 | - | null |
| PRV | PRV-23316 | 2026-10-11T09:37:45Z | ·yuki | — | hayes·· | 1978-11-25 | UHC-85445-45 | - | 774-284-7603 | yuki.hayes@aol.com | 2971 Grand Ave | Orlando | FL | 32890 | — | — |
| PRV | PRV-26761 | 2026-01-10T03:22:16Z | CYNTHIA | — | ORETGA | Jul 8, 2002 | UHC-54454-59 | ·· | 2574457724 | null | 3415 CANYON ROAD | Nashville | TN | 37299 | ···· | — |
| PRV | PRV-27942 | 2026-03-23T00:47:35Z | Aisha | ·· | Cunningham | 02-12-1996·· | UHC-04872-68 | •••-••-1468 | ·· | — | 764 Valley View Dr | TAMPA | FL | 33683 | — | — |
| PRV | PRV-28633 | 2026-07-06T12:33:41Z | DIEGO | — | HARVEEY | 1956-20-03 | ···· | - | +1 682 410 0692 | null | NULL | — | — | NULL | — | OPTIONS-PPO |
| PRV | PRV-22583 | 2026-03-24T06:33:25Z | Ronald | U·· | Alvarez | Mar 19, 1994 | UHC-65432-23 | — | 748.342.1406 | — | 1061 Spring St | Fresno | CA | 93709-6714 | UNKNOWN | ·CHOICE-PLUS-PPO |
| PRV | PRV-24758 | 2026-06-11T14:49:02Z | MARCUS | — | TUCKER | 11/21/2000 | UHC-60936-79 | •••-••-6719 | NULL | MARCUS.TUCKER@YAHOO.COM | ·6343 Palm Dr | Austin | TX | 78799 | - | NULL |
| PRV | PRV-20604 | 2026-08-27T14:16:43Z | Christina | F | Perez | 20-01-2000 | UHC-96033-78 | N/A | (455) 754-4897 | — | 9108 Meadow Lane | Gilbert | AZ | 85255 | — | UNKNOWN |
| PRV | PRV-29152 | 2026-01-15T02:04:39Z | Joshua | — | Guerrero | 1963-09-04 | UHC-94844-47 | - | 624-376-3251 | NULL | 7674 Baseline Rd | Dallas | TX | ·75246 | — | MEDICARE-ADV-A |
| PRV | PRV-26119 | 2026-02-21T17:14:12Z | Mary | — | Nunez | 1967-06-23 | N/A | •••-••-9705 | 4078082756 | null | 326 Willow Court | Houston | TX | 77049 | N/A | N/A |
| PRV | PRV-26191 | 2026-07-04T07:57:49Z | GERALD | — | LARSON | 19860215 | — | •••-••-5492 | 14435153502 | gerald.larson76@hotmail.com | 8163 Valley View Drive | Atlanta | GA | 30381 | — | N/A |
| PRV | PRV-21571 | 2026-08-10T02:11:17Z | Diana | — | Valdez | 2005-07-24 | — | •••-••-5052 | 804-613-4231 | ·DIANA.VALDEZ69@AOL.COM | 1783 Cedar Ln | CHANDLER | AZ | — | — | — |
| PRV | PRV-27320 | 2026-04-13T12:39:04Z | Harper, Dylan | — | — | 1993-07-23 | UHC-06152-86 | •••-••-0045 | 6382368727 | N/A | 2458 PALM DRIVE | Tampa | FL | 33643 | UNKNOWN | NULL |
| PRV | PRV-27247 | 2026-09-23T07:59:12Z | Bradley | — | Russell | 1976-02-07 | N/A | — | 5219562117 | BRADLEY.RUSSELL@ICLOUD.COM | 3277 BAYSHORE DR | SACRAMENTO | CA | 95833-6485 | — | — |
| PRV | PRV-23464 | 2026-04-19T08:16:19Z | valentina | ···· | ·ortiz | 1953-05-05 | ·N/A | — | 5086820139 | N/A | — | null | ···· | -·· | NULL | ·null |
| PRV | PRV-22368 | 2026-04-14T13:47:56Z | Yuki | — | Dominguez | 1982-09-13 | null | ·N/A | 5733552265 | UNKNOWN | 2794 Camelback Rd | Nashville | TN | 37291-3360 | - | — |
| PRV | PRV-28524 | 2026-06-13T17:10:09Z | Christopher | — | Mendez | 01/10/89 | N/A | null | 679-606-1564 | christopher.mendez@gmail.com | 8230 Willow Ct | MIAMI | FL | 33199 | UNKNOWN | — |
| PRV | PRV-28845 | 2026-04-18T08:47:45Z | maria | D. | williams | 1981-03-22 | UHC-03452-96 | UNKNOWN | 964-246-6627 | — | 3689 River Rd | DENVER·· | CO | 80224 | — | UNKNOWN |
| PRV | PRV-23139 | 2026-03-05T14:13:35Z | CAROLYN H. | — | WONG | 01/09/77 | - | •••-••-0727 | ·9184250815 | N/A | 2259 HIGHLAND AVE | SACRAMENTO·· | CA | 95840 | — | null |
| PRV | PRV-27940 | 2026-06-01T09:24:32Z | richard | L. | gonzales | 08-05-1974·· | ·UHC-13350-17 | NULL | 7223272474 | - | 6299 Ocean Avenue | Minneapolis | MN | N/A | null | OPTIONS-PPO |
| PRV | PRV-27032 | 2026-09-11T02:27:32Z | Madison | — | Bennett | 1987-08-09 | ·UHC-18742-54 | NULL | 391.984.2076 | MADISON.BENNETT52@HOTMAIL.COM | 8827 Highland Ave | LAS VEGAS | NV | 89113 | UNKNOWN | — |
| PRV | PRV-29271 | 2026-09-09T05:36:38Z | Kevin | — | Washington | 2008-09-82 | UHC-24205-78 | — | 4967725739 | kevin.washington@hotmail.com | 7626 RIDGE ROAD | ·Plano | TX | 75046 | — | — |
| PRV | PRV-20535 | 2026-01-20T07:35:02Z | RUSSELL | Z. | WATKINS | 1990-08-22 | null | -·· | 6184895 | RUSSELL.WATKINS@AOL.COM | 8736 Bayshore Drive | Las Vegas | NV | 89104 | NULL | UNKNOWN |
| PRV | PRV-21621 | 2026-08-29T08:14:21Z | GEORGE | — | SANCHEZ | 1978-02-18 | — | •••-••-2975 | +1 436 983 3465 | - | 2945 Elm St | Miami | FL | — | UNKNOWN | MEDICARE-ADV-B |
| PRV | PRV-20969 | 2026-08-03T17:06:10Z | HENRY | — | CHERYL·· | 08/19/1955 | UHC-97793-44 | — | 598.732.4108·· | — | 4304 Canyon Rd | Tucson | AZ | 85764 | NULL | UNKNOWN |
| PRV | PRV-23008 | 2026-07-27T13:08:21Z | ELIJAH | — | WASHINGTON | 9/7/1979 | UHC-16414-38·· | NULL | 19886230862 | - | 959 Mesa Drive | AUSTIN | TX | 78748 | — | ···· |
| PRV | PRV-23404 | 2026-04-07T04:49:11Z | Simpson, Zachary | — | — | 1964-12-08 | NULL | -·· | (764) 876-9980 | zachary.simpson@icloud.com | 5711 Church St | MIAMI | FL | 33183 | — | 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:37.751Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty