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-24485 | 2026-02-21T11:17:31Z | Lawrence | — | Rice | 1963-11-14 | null | — | 252.489.5991 | — | UNKNOWN | — | N/A | — | NULL | select-epo |
| PRV | PRV-27673 | 2026-05-27T17:07:36Z | Diego | — | Lucas | Jun 9, 1952 | UHC-55378-42 | N/A·· | 737-347-0504 | DIEGO.LUCAS@YAHOO.COM | 5253 Church St | ·Columbus | Ohio | 43205 | — | UNKNOWN |
| PRV | PRV-21851 | 2026-01-19T01:33:37Z | Sophia | I | Wells | 1943-05-10 | N/A | — | 959.412.2567 | — | 7097 Park Place | ·San Diego | CA | 92147 | N/A | - |
| PRV | PRV-23989 | 2026-07-25T15:05:58Z | LOGAN | H. | WANG | ·2001-03-04 | — | - | 5619720419 | N/A | 9242 Park Place | Phoenix | AZ | 85058 | null | — |
| PRV | PRV-27889 | 2026-04-12T15:18:47Z | CHARLEES | — | CARPENTER | 2006-07-15 | UHC-19993-86 | •••-••-4145 | 7419839128 | — | 7072 HIGHLAND AVE | Denver | CO | 80202-6958 | null | — |
| PRV | PRV-22621 | 2026-03-14T21:23:27Z | Janice·· | V. | Carlson | 11/15/2000 | UNKNOWN | N/A | 18155964117 | JANICE.CARLSON46@OUTLOOK.COM | 627 Lincoln Way·· | ·Nashville | TN | 37253 | - | NULL |
| PRV | PRV-28299 | 2026-02-27T09:45:50Z | Maria | — | Little·· | 9141-06-21 | UHC-24075-34 | •••-••-2894 | +1 420 917 8852 | N/A | 1334 Harbor Blvd | Phoenix | AZ | 85030-9639 | null | — |
| PRV | PRV-24367 | 2026-08-07T01:13:28Z | Jooyce | — | Gonzales | 1996-07-20 | UHC-24623-10 | NULL | (237) 656-6859 | joyce.gonzales@hotmail.com | 3425 Pine Drive Apt 20 | Jacksonville | ·FL | ·32244 | null | UNKNOWN |
| PRV | PRV-23704 | 2026-07-19T05:20:19Z | Robert | — | Dixon | 10/5/2000 | — | null | ·(574) 580-4447 | robert.dixon@outlook.com | 7749 Meadow Ln | Denver·· | CO | 80234-7604 | — | — |
| PRV | PRV-23837 | 2026-04-12T05:52:03Z | Mendez, Albert·· | — | — | 1972-10-21·· | null | — | 3938663302 | — | 1232 DESERT SKY BLVD | Houston·· | TX | 77004 | null | UNKNOWN |
| PRV | PRV-22952 | 2026-10-14T12:04:20Z | nancy·· | — | lynch | 2/10/1970 | ·UHC-62977-75 | •••-••-3864 | 8325056289 | NANCY.LYNCH68@AOL.COM | ·1365 SPRING ST | DENVER | CO | 80289 | UNKNOWN | — |
| PRV | PRV-27483 | 2026-04-27T05:26:21Z | DONALD Q | ·· | KELLY | 12/04/2007·· | UHC-24828-97 | •••-••-7343 | null·· | DONALD.KELLY46@GMAIL.COM | 7800 MEADOW LN | San Antonio | TX | 78266 | N/A | — |
| PRV | PRV-24259 | 2026-02-10T03:49:27Z | PAUL | Z. | COOPER | 05/19/1984 | — | null·· | 19275331056 | paul.cooper@outlook.com | N/A | — | N/A·· | - | — | ·N/A |
| PRV | PRV-21497 | 2026-05-12T22:34:35Z | Emma | ···· | Parker | 1943-05-15 | NULL | NULL | NULL | emma.parker33@outlook.com | 3550 Palm Drive #756 | Fresno | CA | 93754 | — | MEDICARE-ADV-B |
| PRV | PRV-21393 | 2026-10-09T15:34:56Z | BILLLY | — | GIBSON | 2008-04-13 | UNKNOWN | — | ···· | — | 3004 Sunset Boulevard | Tucson | Arizona | 85791 | — | OPTIONS-PPO |
| PRV | PRV-29325 | 2026-04-11T09:36:49Z | patrick | — | spencer·· | 1951-04-14 | NULL | UNKNOWN | UNKNOWN | patrick.spencer@hotmail.com | — | null | UNKNOWN | UNKNOWN | — | UNKNOWN |
| PRV | PRV-20752 | 2026-07-13T01:49:37Z | Teresa | C | McCoy | ·Aug 20, 1976 | UHC-16722-55 | - | 12045096146 | teresa.mccoy@hotmail.com | 5413 Market Street | Los Angeles | CA | 90000 | - | - |
| PRV | PRV-28895 | 2026-02-21T23:27:26Z | Alan | — | Nguyen | 1999-06-19 | NULL | •••-••-5003 | 587-333-7715 | — | 9871 MAIN ST | Mesa | AZ | 85221 | — | NULL |
| PRV | PRV-22137 | 2026-05-20T06:31:07Z | amy | — | matthews | 1977-12-25 | N/A | — | 739-568-6519 | — | 4188 Hillcrest Road·· | Mesa | AZ | ·85259 | null | NULL |
| PRV | PRV-21132 | 2026-01-15T21:39:05Z | ·Ethan | — | Rios | 1992-50-13 | UHC9850033 | - | +1 272 285 6719 | ethan.rios@icloud.com | 143 LAKE VIEW RD | Orlando | ·Florida | 32828 | NULL | — |
| PRV | PRV-23711 | 2026-08-17T04:32:07Z | MEI | — | LI | 11/28/53 | UHC9879236 | •••-••-2459 | 17116684556 | ·NULL | 9840 Palm Dr | JACKSONVILLE | Florida | 32255 | NULL | — |
| PRV | PRV-23309 | 2026-03-19T05:50:08Z | Carr, Kayla | — | — | 1964-05-19 | NULL | - | 697-783-5291 | kayla.carr55@proton.me | 37 CAMELBACK ROAD | Phoenix | AZ | null | — | — |
| PRV | PRV-27650 | 2026-09-19T11:44:28Z | Reynolds, Joseph | — | — | 1960-03-27 | — | - | 273-424-8384 | — | 6878 Grand Ave | Fresno | California | — | ···· | MEDICARE-ADV-B |
| PRV | PRV-28392 | 2026-01-22T10:26:11Z | George | — | Johnston | 5/21/1951 | UNKNOWN | UNKNOWN | 16557128585 | UNKNOWN | 962 Park Pl | Tempe | AZ | 85205 | — | — |
| PRV | PRV-26296 | 2026-09-11T10:03:56Z | DOUGLAS | H. | KENNEDY | 1959-02-15 | UNKNOWN | •••-••-8127 | 4076271319 | NULL | 9050 Sunset Boulevard | Eden Prairie | ·MN | 55335-5615 | - | - |
| PRV | PRV-21760 | 2026-10-10T21:20:23Z | Ryan | — | Le | 11/28/79 | — | •••-••-2456 | +1 224 585 8486·· | — | 9613 Broadway | Seattle | WA | 98100 | null | CORE-HMO |
| PRV | PRV-24011 | 2026-05-13T16:16:41Z | EVELYN | — | COLEMAN | 1996-03-11 | N/A | ·· | (676) 487-1565 | ···· | 7025 Spring St #995 | Scottsdale | az | 85257 | ·- | MEDICARE-ADV-A |
| PRV | PRV-27189 | 2026-06-20T11:18:23Z | MARIANA | V | STWART | 1984-05-09 | UNKNOWN | UNKNOWN | - | - | ·4958 INDIAN SCHOOL RD | Houston | TX | 77056 | — | NULL·· |
| PRV | PRV-27362 | 2026-05-03T15:53:33Z | ASHLEY | — | MOORE | 1966-04-16 | — | — | 273-903-5923 | — | 5502 River Rd | Nashville | tn | 37268 | null | — |
| PRV | PRV-29355 | 2026-05-21T02:26:03Z | alexander | — | wells | 1960-08-11 | UHC-85686-20 | — | - | ·null | 9136 Union Street | Sacramento | CA | 95845 | — | — |
| PRV | PRV-24551 | 2026-05-06T18:54:25Z | Ahmed | — | Hernandez | 1942-04-15 | N/A | - | (875) 744-7817·· | N/A | 3347 Jefferson Ave | Sacramento | CA | 95805 | null | — |
| PRV | PRV-23320 | 2026-09-21T10:28:14Z | NICOLE | — | MASON | 2007-05-06 | UHC8740883 | — | 9289648291 | ···· | 2874 Indian School Rd | SEATTLE | ·WA | 98135 | — | CHOICE-PLUS-PPO |
| PRV | PRV-20346 | 2026-03-13T04:31:07Z | MARTHA | H | SOTO | Jul 25, 1959 | ·UHC-33703-56 | •••-••-7309 | — | MARTHA.SOTO64@AOL.COM | 6617 WILLOW CT | San Antonio·· | TX | 78233 | N/A | MEDICARE-ADV-A |
| PRV | PRV-26099 | 2026-03-09T04:48:15Z | Bryan | — | Ryan | 20050305 | UHC-33706-77 | ·UNKNOWN | 8684279761 | UNKNOWN | 9245 HIGHLAND AVE·· | Tempe | AZ | 85270 | - | — |
| PRV | PRV-27168 | 2026-05-20T08:15:49Z | SOFIA | — | PATEL | 2000-03-25 | UHC-81293-58 | N/A | (261) 915-6113 | — | 5736 Ocean Ave | Chandler | AZ | 85298 | — | — |
| PRV | PRV-22975 | 2026-03-26T05:41:44Z | Omar | V. | Estrada | 19550713 | N/A | •••-••-4209 | — | — | 5347 SUNSET BOULEVARD | Minneapolis | MN | ·55405 | — | NAVIGATE-HMO |
| PRV | PRV-22842 | 2026-03-16T14:18:37Z | dennis | Q | ray | 21-02-1965 | N/A | •••-••-9671 | 8556618303 | UNKNOWN | N/A | UNKNOWN | NULL | N/A | UNKNOWN | CHOICE-PLUS-PPO |
| PRV | PRV-22205 | 2026-09-22T15:18:50Z | Cooper, Jordan | — | ···· | 1966-09-05·· | UHC-56687-76 | — | 761-212-6816 | jordan.cooper@gmail.com | 2256 Apache Blvd | Houston | ·Texas | 77030 | ·· | N/A |
| PRV | PRV-23984 | 2026-02-18T17:58:07Z | Elizabeth | Z·· | Martinez | 1998-12-22 | UNKNOWN | — | +1 914 741 2783 | — | 2780 Desert Sky Boulevard | Atlanta·· | GA | 30343-5620 | N/A | — |
| PRV | PRV-23427 | 2026-01-29T05:00:03Z | Donald | O | Lynch | 02/27/99·· | NULL | null | 531-331-4934 | — | 2835 Lake View Rd | MESA | AZ | 85265 | — | - |
| PRV | PRV-21771 | 2026-06-29T01:46:23Z | Eugene | — | Henderson | 1985-03-10 | — | •••-••-8642 | 14875833046 | eugene.henderson69@aol.com | 6761 Ridge Rd | Tucson | AZ | 85770 | — | OPTIONS-PPO |
| PRV | PRV-22826 | 2026-02-03T13:40:31Z | Logan | ···· | Lews | 1969-06-02 | N/A | null | 575.792.6798 | - | 5160 Church St | Dallas | TX | ·75205 | NULL | — |
| PRV | PRV-28379 | 2026-09-26T06:27:09Z | Madison | — | Butler | 1975-06-07 | UHC-99817-46 | N/A | 296-253-0468 | null | 8928 Lake View Road | Minneapolis | MN·· | 55401 | — | CHOICE-PLUS-PPO |
| PRV | PRV-24542 | 2026-02-04T15:03:13Z | evelyn | Z. | freeman | 03/22/1958 | NULL | — | 574-477-0213 | — | 1736 MOUNTAIN VIEW DRIVE | Atlanta | GA | 30364 | - | N/A |
| PRV | PRV-22959 | 2026-10-16T03:38:37Z | ·Bobby | — | Hart | ·1941-11-19 | UHC-50494-13 | — | +1 976 325 9365 | — | 9401 CAMELBACK ROAD | Las Vegas | NV | UNKNOWN | UNKNOWN | — |
| PRV | PRV-20301 | 2026-03-17T21:29:53Z | EMILY | — | MEJIA | 1976-04-16 | UHC-14207-80 | •••-••-8826 | (284) 286-1564 | NULL | 9063 HILLCREST RD | DALLAS | TX | 75252-0268 | null | — |
| PRV | PRV-23410 | 2026-02-13T09:23:16Z | DEBRA | — | COOK | 1943-11-19 | UHC-39496-64 | — | 248.604.5893 | — | 4011 PALM DR | Orlando·· | FL | 32860 | null | — |
| PRV | PRV-20893 | 2026-02-16T10:54:18Z | DIANA | F | REID | 2000-02-01·· | UNKNOWN | NULL | 18558669315 | diana.reid57@yahoo.com | 9358 DESERT SKY BLVD | Sacramento | CA | 95844 | null | — |
| PRV | PRV-22755 | 2026-08-08T23:05:38Z | Judy·· | ···· | Rius | 10/21/56 | ·null | •••-••-5905 | (698) 938-8866·· | NULL | 7327 Meadow Lane | ·Plano | TX | ···· | — | NULL |
| PRV | PRV-21803 | 2026-01-29T14:41:50Z | — | — | — | 1946-03-19 | UHC-94319-73 | •••-••-0635 | ·9755294351 | john.green39@aol.com | — | UNKNOWN | N/A | — | — | OPTIONS-PPO |
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:52.254Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty