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-29179 | 2026-08-29T07:43:44Z | Kimberly | K | Mills | ·12/07/55 | — | •••-••-5444 | (801) 623-4112 | UNKNOWN | 9137 MAIN ST Apt 17 | Gilbert | AZ | — | NULL | -·· |
| PRV | PRV-26753 | 2026-02-25T16:24:21Z | Danielle | — | Kelly | 1968-01-28 | UHC-36263-55 | •••-••-9997 | (723) 400-6868 | NULL | 3468 WASHINGTON ST | Phoenix | AZ | 85085 | — | — |
| PRV | PRV-22971 | 2026-03-10T09:02:16Z | Beverly | — | Robinson | 1/25/1982 | — | ···· | — | beverly.robinson@icloud.com | 9497 Sage Court | Scottsdale | AZ | 85224 | — | CHOICE-PLUS-PPO |
| PRV | PRV-21377 | 2026-06-13T05:00:47Z | Peter·· | — | Clark | Jun 8, 1947 | UHC-99363-17 | ·· | +1 605 611 7774 | peter.clark46@proton.me | 275 CEDAR LANE #442 | Denver | CO | 80294 | UNKNOWN | — |
| PRV | PRV-27731 | 2026-07-22T13:43:54Z | Lewis, Patrick | D·· | — | 1939-02-28·· | UHC-79870-10 | null | (339) 981-8213 | — | 9157 Camelback Rd·· | Dallas·· | TX | 75286 | N/A | - |
| PRV | PRV-21125 | 2026-06-18T14:52:43Z | Virginia | — | Singh | ·4/27/1957 | UHC-78289-57 | null·· | N/A | null | 1609 Valley View Drive | Charlotte | North Carolina | — | — | — |
| PRV | PRV-22751 | 2026-09-18T20:43:03Z | Wayne | W | Bryant | Dec 15, 1958 | N/A | N/A | 6444598544 | wayne.bryant@icloud.com | 7704 Jefferson Avenue | Eden Prairie | MN | 55341 | UNKNOWN | — |
| PRV | PRV-20317 | 2026-09-18T01:49:59Z | Jaun | — | Thompson | Dec 24, 1963 | null | UNKNOWN | (684) 204-7158 | UNKNOWN | 660 WILLOW CT | Phoenix | AZ | 85031 | - | UNKNOWN |
| PRV | PRV-27172 | 2026-06-14T17:33:08Z | JOSEPH | ···· | SALAZAR·· | 6/11/1961 | UHC-42198-11 | - | (653) 485-9138 | — | 8192 Sage Ct | Tucson | AZ | 85772 | UNKNOWN | ·- |
| PRV | PRV-21641 | 2026-05-20T11:41:19Z | Brenda | ·· | Marquez | ·24-03-1974 | UHC-60566-59 | — | 707-990-7062 | ·BRENDA.MARQUEZ@AOL.COM | 5518 Grand Avenue | Las Vegas | NV | 89172 | null | NULL |
| PRV | PRV-21481 | 2026-06-01T08:43:25Z | SOPHIA M. | — | WILSON | 10/14/1958 | UHC-22018-02 | N/A | 9446933110 | — | 3631 Market St #845 | Nashville | TN | 37219 | - | — |
| PRV | PRV-29456 | 2026-06-24T12:01:38Z | jesse | ·· | daniels | 11/24/1960 | UHC-34721-77 | — | 6987582646 | jesse.daniels27@hotmail.com | 5751 ELM STREET | Charlotte | NC | 28238 | UNKNOWN | NULL |
| PRV | PRV-23788 | 2026-06-19T02:50:28Z | ANTHONY | — | LAWSON | 1994-06-11 | UNKNOWN | - | 775-886-4925 | UNKNOWN | 4179 Sunset Boulevard | JACKSONVILLE | ·FL | 32288-6188·· | NULL | NULL |
| PRV | PRV-23804 | 2026-04-27T13:47:36Z | Sarah | — | Olson | 2002-10-06 | — | UNKNOWN | (756) 401-9099 | sarah.olson76@outlook.com | 6116 WILLOW COURT | Fresno | CA | null·· | — | null |
| PRV | PRV-27829 | 2026-03-19T09:13:33Z | Mazon | — | Palmer·· | 2005-01-19·· | null | N/A | null | UNKNOWN | 334 LINCOLN WAY | Atlanta | GA | 30351 | NULL | NULL |
| PRV | PRV-24319 | 2026-07-09T12:29:41Z | JOHN | M | HICKS | 19490226 | null | •••-••-5664 | 4809016447 | N/A | 582 Ocean Ave | Austin | TX | 78737-2093 | null | — |
| PRV | PRV-24234 | 2026-04-04T22:43:15Z | George | — | Jensen | Mar 2, 1951 | UHC-18575-03 | •••-••-1928 | (430) 315-0474 | UNKNOWN | 4915 Highland Avenue | Columbus·· | OH | 43237 | - | UNKNOWN |
| PRV | PRV-28789 | 2026-10-15T15:52:14Z | ·Sharon | — | ·Diaz | 7/25/1957 | NULL | ···· | (608) 960-9342 | SHARON.DIAZ80@OUTLOOK.COM | 4651 Sage Court | NASHVILLE | TN | 37266 | NULL | CORE-HMO |
| PRV | PRV-22249 | 2026-05-31T14:12:27Z | ·Phillips, Beverly | — | ·· | 1945-08-19 | UHC-74481-70 | — | 846-581-7626 | -·· | 996 RIVER ROAD | NASHVILLE·· | TN | 37214-3716 | — | - |
| PRV | PRV-25221 | 2026-09-17T15:58:37Z | KATHERINE | Y | PERRY | ·Mar 27, 1959 | NULL | ···· | 9250018 | - | 5610 SAGE CT | Fresno | CA | 93713 | - | — |
| PRV | PRV-21051 | 2026-05-30T02:24:36Z | JEN | ···· | ANDERSON | 1975-07-27 | UHC-24465-07·· | — | (423) 449-0921 | - | 3368 WILLOW CT | Orlando | FL | 32893 | - | UNKNOWN |
| PRV | PRV-29024 | 2026-05-25T19:22:54Z | RONALD | ···· | SILVA | 1946-07-18 | null | •••-••-3896 | (840) 545-0144 | ronald.silva@gmail.com | N/A | UNKNOWN | - | N/A | NULL | NULL·· |
| PRV | PRV-28179 | 2026-07-25T11:48:25Z | Mary | — | Herrera | 3/20/1973 | UHC-96852-32 | UNKNOWN | (829) 918-9312·· | — | 7943 Palm Dr | Houston | TX | 77040·· | UNKNOWN | UNKNOWN |
| PRV | PRV-20683 | 2026-06-10T11:00:12Z | Michael | — | Stone | 01/26/1974 | UHC-84625-12 | — | - | michael.stone@proton.me | 7918 Meadow Ln | Miami | FL | 33129 | — | OPTIONS-PPO |
| PRV | PRV-23631 | 2026-08-15T19:01:55Z | mateo | — | harrison | 08-12-1950 | — | UNKNOWN | 7865650513 | MATEO.HARRISON97@ICLOUD.COM | 8418 Washington Street | Atlanta | GA | UNKNOWN | — | — |
| PRV | PRV-20106 | 2026-07-16T01:46:33Z | Natalie | — | Martinez | ·Jun 18, 1991 | — | -·· | (595) 780-3152 | NULL | ·5785 Apache Boulevard | Plano | Texas | 75015 | UNKNOWN | — |
| PRV | PRV-28684 | 2026-09-13T22:12:37Z | Betty | — | Peters | 19710224 | — | — | +1 252 382 0369 | ···· | 6038 Market St | Scottsdale | AZ | 85229 | — | OPTIONS-PPO |
| PRV | PRV-20416 | 2026-09-25T15:42:48Z | Billy | — | Rodriguez | 1982-07-06 | null | — | 914-615-1101 | UNKNOWN | 647 Main Street | Gilbert | Arizona | 85261 | — | — |
| PRV | PRV-29210 | 2026-09-08T16:01:47Z | Emily | — | Dean | 1938-09-11 | UHC-59103-27 | UNKNOWN | 8095753906 | EMILY.DEAN29@YAHOO.COM | 45 OAK STREET | DENVER | CO | 80259 | - | null |
| PRV | PRV-27144 | 2026-01-19T00:49:46Z | Richard | — | Murphy | Feb 22, 1992 | UHC-66444-91 | — | 6824514806 | NULL | — | NULL | — | — | null | N/A |
| PRV | PRV-21862 | 2026-01-15T11:03:42Z | RALPH | — | GUTIERREZ | 1950-11-24 | — | null | 13114397602 | N/A | 9361 Sage Ct | Denver | CO | 80259·· | — | N/A |
| PRV | PRV-22129 | 2026-07-07T05:06:16Z | jeffrey | — | green | 1988-05-13 | NULL | null | ·5662782770 | N/A | 4405 CAMELBACK ROAD | Orlando | FL | 32885 | NULL | — |
| PRV | PRV-23675 | 2026-06-14T17:39:23Z | Steven | Z.·· | Schmidt | 1986-09-25 | UHC-10816-62 | NULL | 628-673-9037 | — | 5175 MARKET STREET | Las Vegas·· | NV | 89123 | NULL | CORE-HMO |
| PRV | PRV-29482 | 2026-03-24T11:22:14Z | WILLLIE | — | BENNETT | 19690125 | — | N/A | 6495868623 | null | - | — | — | ·· | — | — |
| PRV | PRV-22212 | 2026-05-24T08:40:40Z | Steven | — | Ellis | 1944-12-28 | UNKNOWN | N/A | — | ·- | ·6255 Park Pl | Jacksonville | FL | ·32272 | null | NULL |
| PRV | PRV-23786 | 2026-08-08T04:48:16Z | ·Rodriguez, William | X | — | 19680904 | NULL | - | (223) 337-5882 | william.rodriguez@hotmail.com | 5466 Church Street | GILBERT | AZ | 85239 | - | - |
| PRV | PRV-29020 | 2026-04-28T07:18:49Z | Pamela | ···· | Wheeler | 19710219 | UHC-85700-76 | N/A | (909) 592-6975 | NULL | 8244 Park Place | Chandler | AZ | 85270 | UNKNOWN | NULL |
| PRV | PRV-26923 | 2026-07-08T13:45:52Z | Ryan | — | Gutierrez | 10/13/1987 | UHC-52264-23 | N/A | — | N/A | 9692 MARKET STREET | Fresno | CA | 93732 | — | — |
| PRV | PRV-24604 | 2026-01-11T08:17:22Z | barbara | C. | fisher | 1938-06-16 | — | — | 5728819269 | barbara.fisher@proton.me | ·4226 Church Street | Orlando | FL | 32822 | ···· | — |
| PRV | PRV-25125 | 2026-10-14T20:13:05Z | MICHEEL | — | PATTERSON | 1950-07-25 | UHC-52330-39 | •••-••-9646 | 5344757314 | MICHAEL.PATTERSON@ICLOUD.COM | UNKNOWN | UNKNOWN | — | NULL | — | ·N/A |
| PRV | PRV-21282 | 2026-08-05T17:34:02Z | Gabriel | ···· | Campbell | 1941-09-14 | ·· | - | NULL | ·gabriel.campbell4@yahoo.com | 1460 Pine Drive | Plano | Texas | 75001 | — | - |
| PRV | PRV-26449 | 2026-08-02T00:23:53Z | ERIC | — | WALSH | 1948-09-23 | UHC-81765-07 | UNKNOWN | 474-953-5319 | NULL | 2093 Indian School Rd | TUCSON | AZ | 85756·· | null | - |
| PRV | PRV-21158 | 2026-04-26T13:38:39Z | Sean | — | Allen | 19930914 | — | — | +1 495 839 6051 | N/A | 1226 Willow Court | Los Angeles | CA·· | ·90091 | NULL | null |
| PRV | PRV-29377 | 2026-04-14T05:49:44Z | SHIRLEY | — | BOYD | Aug 14, 1972 | UNKNOWN | - | 6134102978 | — | — | NULL | — | UNKNOWN | null | UNKNOWN |
| PRV | PRV-23037 | 2026-06-02T08:43:10Z | FRANK | ·O | STEPHENS | 1983-04-08 | UNKNOWN | •••-••-2515 | 3628098196 | NULL | 8890 Lincoln Way | CHANDLER | AZ | 85223 | null | — |
| PRV | PRV-21066 | 2026-04-21T02:22:36Z | Catherine | — | ·Herrera | 19590515 | UHC-29635-57·· | — | (971) 654-3306 | — | 6478 Canyon Road | SAN ANTONIO | TX | — | — | ·· |
| PRV | PRV-29309 | 2026-09-23T02:54:15Z | James, Roy | — | — | Nov 12, 2008 | — | •••-••-6659 | +1 555 719 3929 | roy.james@proton.me | 6635 Park Pl·· | LAS VEGAS | Nevada | 89178 | NULL | CORE-HMO |
| PRV | PRV-22365 | 2026-08-15T07:01:09Z | ANGELA | E | SAAZAR | 2001-02-03 | UHC-20499-93 | •••-••-7538 | 6846723646·· | — | 9038 LINCOLN WAY | ATLANTA | ga | 30362 | NULL | UNKNOWN |
| PRV | PRV-29561 | 2026-03-01T13:46:12Z | MASON | ·· | WARD | 1993-02-17 | — | UNKNOWN | (382) 720-8216 | MASON.WARD98@OUTLOOK.COM | 2679 CAMELBACK ROAD | Jacksonville | FL | 32212 | UNKNOWN | — |
| PRV | PRV-25506 | 2026-04-30T10:33:52Z | George | Z | Li | 1955-11-01 | ·· | N/A | ·652-254-2957 | NULL | 9770 Jefferson Avenue·· | ATLANTA | GA | 30349 | NULL | NAVIGATE-HMO |
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:46.457Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty