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-24348 | 2026-08-19T02:30:14Z | ·Patrikk | — | Nguyen | 11/21/2001 | UHC6212412 | null | 6962571225 | PATRICK.NGUYEN@OUTLOOK.COM | 4943 ELM STREET | Sacramento | CA | 95809 | NULL | ·· |
| PRV | PRV-28362 | 2026-04-26T00:11:56Z | LORI | — | STEWART | 1945-01-20 | UHC-49995-63 | — | 817-570-8003 | - | 5044 Broadway | ATLANTA | GA | UNKNOWN | — | UNKNOWN |
| PRV | PRV-20988 | 2026-10-18T01:51:19Z | Nancy | S | Ferguson | 1983-09-08 | null | NULL | NULL | null | 3032 HIGHLAND AVE | COLUMBUS | OH | 43241 | UNKNOWN | UNKNOWN |
| PRV | PRV-22148 | 2026-07-22T15:04:59Z | ·Roger | — | Lewis | 1956-02-03 | — | •••-••-6736 | 861.490.5018 | roger.lewis@outlook.com·· | null | — | — | — | — | — |
| PRV | PRV-23649 | 2026-01-02T18:34:26Z | Juan | — | Crawford | 1988-02-23·· | — | — | 13945071908 | — | 5169 VALLEY VIEW DR | Sacramento | California | 95858 | — | — |
| PRV | PRV-29039 | 2026-10-07T06:13:26Z | Jessica·· | ···· | Alvarez | 1905-03-27 | UHC-19484-62 | NULL | null | UNKNOWN | 976 Sunset Boulevard | Gilbert | AZ | 85218 | - | UNKNOWN |
| PRV | PRV-25485 | 2026-01-29T19:15:18Z | Mason, Jacqueline | ···· | — | null | UHC-70522-46 | ·· | 808.214.2473 | — | 5140 Cedar Lane·· | Minneapolis | MN·· | 55456-3824 | NULL | UNKNOWN |
| PRV | PRV-22510 | 2026-02-08T21:51:44Z | Ralph | — | Johnston | 19830127 | NULL | NULL·· | — | ·ralph.johnston98@proton.me | 1083 Sage Ct | Minneapolis | MN | 55490 | - | null |
| PRV | PRV-23031 | 2026-01-09T09:20:12Z | timothy | — | martin | 1985-02-15 | ·UHC-77042-14 | — | 821-565-2923 | UNKNOWN | 5826 Maple Avenue | Fresno | CA | 93768 | — | — |
| PRV | PRV-28369 | 2026-09-05T05:52:46Z | Joyce | D·· | Cooper | 2000-04-03 | UHC-90049-06 | ·· | 8408126761 | UNKNOWN | 459 Cedar Ln | Columbus | OH | 43270 | NULL | SELECT-EPO |
| PRV | PRV-23840 | 2026-01-27T08:05:03Z | ARJUN | C | CRUZ | Jan 18, 2002 | — | - | (761) 478-0340 | ···· | 2954 Palm Dr | EDEN PRAIRIE | MN | 55315 | N/A | — |
| PRV | PRV-21709 | 2026-06-11T20:48:19Z | ·MADISON | — | FOSTER | Mar 28, 1955 | UHC6306807 | N/A | +1 679 972 7683 | madison.foster23@outlook.com | 8828 Spring St | Atlanta | GA | 30393 | UNKNOWN | N/A |
| PRV | PRV-20055 | 2026-06-29T13:44:45Z | Ann | N | Flores | 1978-10-19 | UHC-43456-24 | ·· | 367-432-7305 | — | 5599 Broadway | NASHVILLE | tn | 37234 | UNKNOWN | — |
| PRV | PRV-21438 | 2026-03-21T13:21:48Z | Kmiberly | J | Willis | 1954-04-24 | null | - | (227) 434-0284 | — | 5805 Park Place | SAN DIEGO | CA | - | NULL | — |
| PRV | PRV-21477 | 2026-01-14T15:48:25Z | Jonathan | ·· | Bell | 19880222 | UHC-75396-89 | null | N/A | jonathan.bell@gmail.com | 4740 Forest Avenue | Sacramento | CA | 95896 | UNKNOWN | MEDICARE-ADV-A |
| PRV | PRV-22026 | 2026-08-25T17:00:24Z | Cook, Priya | — | — | 1956-08-04 | UNKNOWN | ·null | 8593901606 | PRIYA.COOK@ICLOUD.COM | 8550 Cedar Lane | Eden Prairie | Minnesota | 55326 | - | NULL |
| PRV | PRV-24459 | 2026-07-01T17:06:41Z | Anthony U. | — | Hayes | 19460903·· | UHC-47136-42 | - | +1 929 642 0529 | anthony.hayes84@yahoo.com | 1648 Baseline Rd | Houston | TX | 77003-0087·· | — | ·UNKNOWN |
| PRV | PRV-20581 | 2026-03-03T18:32:37Z | omar | — | dixon | Jul 9, 1973 | UHC-94376-27 | •••-••-0190 | 510-841-8557 | UNKNOWN | 636 Meadow Ln | Tempe | Arizona | ···· | ·UNKNOWN | N/A |
| PRV | PRV-26890 | 2026-09-13T06:44:20Z | BRANDON | — | HALL | 1997-08-11 | ·· | UNKNOWN | (921) 493-7486·· | — | 1192 Union Street | Chandler | AZ | 85280·· | null | UNKNOWN |
| PRV | PRV-25643 | 2026-09-06T06:36:07Z | Lauren | — | Chen | 2003-04-01 | UHC-04060-90 | •••-••-5249 | 709-951-8613 | lauren.chen58@gmail.com | 8160 INDIAN SCHOOL RD | ·Austin | TX | 78773 | — | - |
| PRV | PRV-21365 | 2026-03-16T20:19:43Z | Johnston, Sam | — | ···· | 2/8/1978 | null | UNKNOWN | 3232751298 | — | 1434 Palm Drive | Las Vegas | ·NV | 89112 | null | — |
| PRV | PRV-22017 | 2026-07-13T00:40:35Z | ADAM | ·· | ADAMS | 7/5/1969 | UHC-49503-77 | NULL | (761) 282-7366 | — | 87 Ridge Rd·· | Las Vegas | NV | 89191 | null | — |
| PRV | PRV-28268 | 2026-08-29T06:00:51Z | RANDY | ·D | WARD | 1966-08-21 | UHC-18923-49 | — | — | UNKNOWN·· | 5264 Sage Court·· | Mesa | Arizona | 85277·· | — | ·CHOICE-PLUS-PPO |
| PRV | PRV-21359 | 2026-10-05T14:12:58Z | Janet | — | Arnold | 1962-08-10 | — | •••-••-5410 | +1 393 353 3885 | JANET.ARNOLD36@ICLOUD.COM | 2671 Palm Drive | Jacksonville·· | FL | 32296 | N/A | N/A |
| PRV | PRV-27939 | 2026-09-02T11:27:34Z | Benjamin F | ···· | Jones | 2000-11-10 | null | •••-••-5143 | 417-628-5515 | UNKNOWN | 3840 Palm Dr | NASHVILLE | TN | 37240-5539 | - | — |
| PRV | PRV-26749 | 2026-06-17T17:47:10Z | BRUCE | — | WELLS | 1977-11-17 | NULL | UNKNOWN·· | 545-799-8325 | null | 7373 Pine Drive | Charlotte | NC·· | 28233-3214 | — | - |
| PRV | PRV-20121 | 2026-06-13T13:42:55Z | Fatima | — | Kim | 1966-06-26 | UHC-47643-05 | null | 9889443477 | N/A | 8544 Camelback Rd | Sacramento | CA | 95882 | ·· | — |
| PRV | PRV-22140 | 2026-02-23T18:34:16Z | Lauren | — | Howard | 10/01/02 | UHC-36100-80 | - | 918-679-6560 | NULL | 5084 RIVER RD | Gilbert | AZ | 85251 | N/A | - |
| PRV | PRV-29247 | 2026-09-20T05:24:22Z | Terry | — | Hansen | 1994-10-11 | NULL | - | +1 869 677 1414 | TERRY.HANSEN59@YAHOO.COM | 213 PINE DR | Columbus | OH·· | 43272 | — | — |
| PRV | PRV-26082 | 2026-03-27T13:58:25Z | SARA | — | HANSON | 1993-07-16·· | UHC-23621-71 | null | 626-527-9615·· | sara.hanson86@icloud.com | 2711 SAGE CT | Charlotte | NC | 28237-9217 | NULL | UNKNOWN |
| PRV | PRV-25279 | 2026-02-26T16:37:24Z | Justin | L | Gordn | 1958-09-10·· | UHC-93719-60 | N/A | UNKNOWN | justin.gordon94@yahoo.com | 8913 Mountain View Drive | Phoenix | AZ | 85069-3667·· | - | NULL |
| PRV | PRV-29556 | 2026-06-24T15:37:42Z | Stephanie | ···· | Allen | 18-04-1957 | UHC-26220-93 | — | (787) 583-3154 | — | 3199 MARKET STREET | LOS ANGELES | CA | 90086 | ···· | — |
| PRV | PRV-22225 | 2026-07-24T22:09:31Z | JOE | — | SILVA | 1944-11-08·· | UHC-53993-88 | •••-••-6970 | 367-518-0514 | jose.silva9@aol.com | 3387 RIVER ROAD | Mesa | AZ | ·85247 | — | — |
| PRV | PRV-26394 | 2026-05-31T13:17:01Z | Sophia | ···· | Ray | Oct 3, 1999 | — | — | 7377922231 | null | 707 Valley View Dr | AUSTIN | TX | 78737-2839 | — | NULL |
| PRV | PRV-27136 | 2026-09-15T04:46:52Z | Warren, Philip | ···· | — | 26-04-1964 | UHC-00906-32 | — | 6237643552 | null | ·416 MEADOW LANE | Nashville | TN | 37260 | — | — |
| PRV | PRV-24407 | 2026-02-07T20:52:31Z | Aaron | — | Stone | 1966-01-28 | UHC-20090-06 | •••-••-2015 | (780) 224-3948 | NULL | ·14 Park Pl | Gilbert | AZ | 85205 | N/A | ·SELECT-EPO |
| PRV | PRV-28723 | 2026-07-09T03:44:38Z | Guerrero, Kayla | — | — | ·Apr 5, 1974 | ·· | •••-••-0061 | 303-463-4451 | kayla.guerrero@hotmail.com | 9734 Desert Sky Boulevard | Nashville | Tennessee | 37237-3432·· | N/A | — |
| PRV | PRV-27834 | 2026-03-10T06:30:25Z | Janet | A | Jimenez | 03/12/62 | - | •••-••-5660 | 3008720717 | janet.jimenez16@gmail.com | 4320 Ocean Avenue | Las Vegas | NV | 89175 | — | — |
| PRV | PRV-28386 | 2026-09-22T13:05:16Z | Keith | O | Tran | 1998-05-08 | - | - | +1 812 276 3352 | ·UNKNOWN | 8577 Highland Avenue | Fresno | CA | 93722 | — | — |
| PRV | PRV-22658 | 2026-01-09T09:19:01Z | Bradley | — | Belll·· | 10/15/89 | - | •••-••-4179 | 16273622857 | — | 8241 Meadow Ln | Jacksonville | FL | 32268 | — | — |
| PRV | PRV-22765 | 2026-08-19T02:41:47Z | BOBBY | — | PERZ | 02/16/2005 | ···· | •••-••-6135 | (667) 727-6081 | bobby.perez68@aol.com | 669 RIDGE RD | Plano | TX | — | UNKNOWN | — |
| PRV | PRV-20670 | 2026-02-18T12:06:47Z | ·McCoy, Gregory | — | — | 1942-05-15 | — | — | ·(518) 279-0967 | null | 8994 Lake View Rd | Nashville | ·TN | 37293 | — | NULL |
| PRV | PRV-23663 | 2026-03-01T22:37:18Z | Jaccob | — | Pierce | 1950-04-11 | UHC-39294-12 | null | (621) 654-5488 | jacob.pierce64@gmail.com | 3638 HILLCREST RD Apt 28·· | Mesa | AZ | 85229 | NULL | MEDICARE-ADV-B |
| PRV | PRV-26289 | 2026-09-10T02:41:19Z | Jonathan | ·· | Msaon | 1979-10-23 | — | NULL | +1 770 216 8246 | N/A | — | — | — | NULL | - | NULL |
| PRV | PRV-23151 | 2026-09-10T11:40:08Z | Graham, Michael·· | L | — | 1991-04-09 | UHC-80630-55 | ·- | +1 712 888 0544 | MICHAEL.GRAHAM45@GMAIL.COM | 5523 Main St | Plano | Texas | ·null | — | - |
| PRV | PRV-28745 | 2026-08-26T14:35:36Z | Catherine | ·R | Larson | 20-12-1971 | - | N/A | 6422852095 | catherine.larson@gmail.com | 2721 SUNSET BLVD·· | San Diego | CA·· | ·NULL | — | — |
| PRV | PRV-23667 | 2026-04-29T14:54:17Z | dennis | — | ·castro | 20000506 | ·UHC-54013-05 | •••-••-9730 | ·326.844.2329 | dennis.castro@yahoo.com | 5520 Washington St | Miami | FL | 33174 | — | ·· |
| PRV | PRV-20731 | 2026-01-29T01:57:08Z | AUSTIN | C | HOLMES | 1976-02-25 | N/A | — | 3899321696 | NULL | 2810 Spring Street #349 | SAN DIEGO | CA | 92123 | null | - |
| PRV | PRV-29170 | 2026-09-10T08:40:08Z | CHRISTINE | — | ROBINSON | 6/5/1972 | UHC-30697-65 | NULL·· | 513.371.9111 | — | 9172 MEADOW LANE·· | Las Vegas | NV | 89111 | — | NAVIGATE-HMO |
| PRV | PRV-21882 | 2026-09-28T06:34:26Z | — | — | — | 1945-05-06 | UHC-12903-25 | UNKNOWN | 8283946181 | N/A | 8733 PARK PL | Los Angeles | CA | 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-19T19:54:25.443Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty