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-24089 | 2026-03-19T05:45:17Z | Lucas, Michael | — | — | 1965-08-11 | ·· | — | ···· | UNKNOWN | 1524 HIGHLAND AVENUE | Eden Prairie | MN | 55329 | NULL·· | — |
| PRV | PRV-23806 | 2026-01-01T10:57:03Z | Michael | — | Chappman | 09/01/1960 | — | •••-••-1413 | (689) 809-9082 | — | 3528 Bayshore Dr | Tampa | FL | 33698 | — | null |
| PRV | PRV-23387 | 2026-09-01T19:42:59Z | ALICE | — | FREEMAN | ·1960-84-04 | UHC-80293-63 | NULL | 873-893-8397 | NULL | null | — | - | — | null | ·MEDICARE-ADV-B |
| PRV | PRV-27985 | 2026-03-13T09:01:27Z | BILLY | — | ROSE | 1964-03-08 | UHC-55154-36 | - | 8553123142 | william.rose@icloud.com | 5030 Cedar Ln Apt 27 | Phoenix | ·AZ | 85035 | UNKNOWN | NULL |
| PRV | PRV-25247 | 2026-04-30T10:25:45Z | George | — | Perez | 1969-01-24 | UHC-59062-50 | — | 946.922.6873 | ·george.perez18@proton.me | 8873 Indian School Rd | LAS VEGAS | NV | 89190 | N/A | MEDICARE-ADV-B |
| PRV | PRV-29461 | 2026-03-29T17:48:18Z | Melissa | — | Gibson | 1946-03-15 | UHC-27893-59 | — | 954-819-6908 | — | ·8469 Oak St | Columbus | OH | 43204 | UNKNOWN | — |
| PRV | PRV-20793 | 2026-10-15T17:31:20Z | Alexis | ···· | Alvarado | 07/18/2002 | UHC-08236-43 | - | 690.844.3487 | alexis.alvarado43@hotmail.com | 7620 Harbor Blvd | Columbus | OH | ·43299 | NULL | — |
| PRV | PRV-24491 | 2026-01-29T08:05:33Z | DIANA | — | OLIVER | 10/02/2003 | null | •••-••-8433 | 13282569089 | — | 4633 Hillcrest Road | Seattle | ·WA | 98134 | ·· | — |
| PRV | PRV-24530 | 2026-01-17T04:02:11Z | George | Q | Dominguez | 2001-04-12 | ·NULL | •••-••-0331 | 454-563-4232 | — | 4593 OCEAN AVENUE | Glendale | AZ | 85363 | NULL | — |
| PRV | PRV-27875 | 2026-02-20T20:10:06Z | REBECCA | D | MENDOZA | Mar 10, 2006 | UHC-41468-60 | N/A | +1 869 639 0034 | rebecca.mendoza@proton.me | 9585 BASELINE ROAD | ·Houston | TX·· | 77094-4992 | — | — |
| PRV | PRV-26817 | 2026-01-16T05:25:05Z | Contreras, Christina | — | — | Jul 6, 1967 | uhc-62827-35 | null | 940-428-6373·· | ···· | - | — | UNKNOWN | null | N/A | NULL |
| PRV | PRV-21003 | 2026-02-04T15:46:03Z | Carol | Q | Carlson | 1994-06-12 | UHC7496893 | •••-••-4833 | 12485851096 | N/A | 841 Central Ave | Dallas | TX | 75220 | UNKNOWN | null |
| PRV | PRV-20965 | 2026-01-12T00:45:31Z | Hughes, Rachel | — | — | 1969-06-06 | — | NULL·· | (538) 412-6473 | NULL | 3782 Meadow Lane·· | GLENDALE | ·AZ | 85328 | — | MEDICARE-ADV-B |
| PRV | PRV-20870 | 2026-03-03T18:19:06Z | SHARON | R | OLSON | Aug 10, 1999 | ·UHC-00596-77 | — | 9203586966 | ·sharon.olson@aol.com | — | — | UNKNOWN | UNKNOWN | null | NAVIGATE-HMO |
| PRV | PRV-24767 | 2026-01-18T04:37:50Z | Jordan | — | Romero | 1989-01-18 | UHC-83045-22 | null | - | N/A·· | 1743 Jefferson Avenue | Fresno | CA·· | 93705 | — | N/A |
| PRV | PRV-25286 | 2026-02-25T11:03:48Z | ANDREA | — | CARTER | 01/14/1968 | ···· | - | NULL | ·· | 589 Bayshore Dr | ·Houston | TX | 77082-2508 | N/A | — |
| PRV | PRV-21206 | 2026-10-18T05:40:27Z | Nancy | — | Oliver | 1944-10-25 | UHC-38921-64 | •••-••-3667 | -·· | UNKNOWN | 8923 Baseline Road | Plano | Texas | 75066 | NULL | null |
| PRV | PRV-24168 | 2026-06-01T23:18:17Z | BETTY | ·· | PENA | 10/3/1953 | UHC-15755-28 | UNKNOWN | 588.666.3083 | BETTY.PENA37@HOTMAIL.COM | ·8194 Maple Ave | NASHVILLE | TN | 37272 | — | N/A |
| PRV | PRV-28808 | 2026-05-02T22:21:31Z | Jean | O | Nelson·· | 1987-09-12 | NULL | ·NULL | 494-731-1148 | UNKNOWN | 5776 RIDGE RD | CHARLOTTE | NC | 28236 | — | N/A |
| PRV | PRV-22659 | 2026-06-17T07:45:48Z | raymond | ···· | pierce | null | NULL | - | N/A | - | 9508 Market St | Eden Prairie | MN | ·55328 | — | - |
| PRV | PRV-29177 | 2026-10-07T17:43:14Z | Albert | ·P | Howard | 2004-09-11 | UHC-92633-37 | NULL | 242-643-8010 | albert.howard@gmail.com | 6203 Park Place | Gilbert | AZ·· | 85222 | — | — |
| PRV | PRV-22440 | 2026-05-26T18:07:11Z | ·GLORIA | — | ·WEBB | 1941-12-28 | UHC-39563-01 | — | — | — | 7915 Mountain View Drive | Austin | Texas·· | 78757 | — | CORE-HMO |
| PRV | PRV-23286 | 2026-06-22T20:04:02Z | MARIA | — | EDWARDS·· | 19621107·· | UHC-00544-89·· | null | 4596211591 | NULL | 2604 River Road | MESA | AZ | 85259 | — | UNKNOWN |
| PRV | PRV-20273 | 2026-09-30T22:37:37Z | janet | — | wright | 1966-09-20 | UHC-45348-02 | - | 3153185416 | N/A | 4019 Maple Avenue | Minneapolis | ·Minnesota | 55415 | — | NAVIGATE-HMO |
| PRV | PRV-22227 | 2026-06-18T08:34:43Z | virginia | G | yang | 19880828 | UHC-41415-62·· | — | 685.603.9563 | virginia.yang53@proton.me | 200 Jefferson Avenue | MESA | AZ | 85287 | NULL | UNKNOWN |
| PRV | PRV-28728 | 2026-04-28T02:17:26Z | ALEXIS | — | SINGH | 12/05/07 | — | — | (899) 593-2629 | NULL | 6744 Desert Sky Boulevard | Las Vegas | NV | 89152 | — | — |
| PRV | PRV-23506 | 2026-04-26T01:43:10Z | Marilyn·· | ·· | Nunez | 1974-08-16 | UNKNOWN | — | (489) 716-4544 | — | - | — | - | ·· | UNKNOWN | N/A |
| PRV | PRV-24454 | 2026-02-09T12:56:51Z | Wei | A. | Car | 1977-01-10 | — | - | 212-529-9826·· | — | ·174 Mesa Dr | Jacksonville | FL | 32269 | N/A | null |
| PRV | PRV-25540 | 2026-09-04T19:51:20Z | YUKI | — | HANSON | 03/04/81 | UHC-02203-04 | ·null | 582-935-8898 | — | — | — | — | ·- | - | null |
| PRV | PRV-20012 | 2026-02-16T13:00:10Z | Olivia | ·· | Mejia | 1996-01-27 | UHC-99227-11 | UNKNOWN | (624) 889-4352 | — | — | — | — | — | N/A | NULL |
| PRV | PRV-23526 | 2026-08-27T04:10:10Z | SEAN | — | FULLER | 1986-08-24 | UHC-36745-76 | - | null | sean.fuller@aol.com | 1395 GRAND AVENUE | CHANDLER | AZ | 85201 | — | NAVIGATE-HMO |
| PRV | PRV-20749 | 2026-02-18T19:39:58Z | ·John | — | Berry | 4/11/1950 | UHC-41668-73 | •••-••-1976 | 3954812675 | NULL | 3364 FOREST AVE | GLENDALE | AZ | 85322·· | — | UNKNOWN |
| PRV | PRV-20746 | 2026-03-10T02:22:35Z | ·Bennett, Diana | — | ···· | 1964-09-14 | UHC-02217-16 | NULL | +1 648 988 0225 | ···· | 7866 SUNSET BOULEVARD | MINNEAPOLIS | MN | 55487-1378 | UNKNOWN | NULL |
| PRV | PRV-22112 | 2026-05-06T14:01:31Z | Christine | — | Marshall | 11/02/1978 | NULL | N/A | (530) 781-5623 | christine.marshall@aol.com | 3165 Elm Street | Houston | TX | 77095 | ·UNKNOWN | SELECT-EPO |
| PRV | PRV-28858 | 2026-09-04T23:59:45Z | ·Cynthia | — | Ross | NULL | null | - | (911) 553-4062 | - | 9101 PINE DR | Seattle | WA | 98108 | N/A | — |
| PRV | PRV-29448 | 2026-10-05T01:39:23Z | Benjamin | — | Walker | 12/12/95·· | UHC-70830-99 | — | (587) 918-0816 | benjamin.walker10@aol.com | 4431 Union St | Jacksonville | FL | 32254 | null | ·N/A |
| PRV | PRV-28159 | 2026-09-30T15:32:12Z | Cheryl | — | Ward | 01/06/1988 | UHC-07157-64 | — | (343) 956-8671 | — | 1620 Lake View Rd | Denver | Colorado | 80204 | — | N/A |
| PRV | PRV-27585 | 2026-07-06T21:27:25Z | ELIZABETH | — | WALKER | 19-11-1958 | UHC-96628-55 | •••-••-6177 | - | N/A | 8507 HARBOR BLVD | Denver | CO·· | ···· | N/A | ···· |
| PRV | PRV-24335 | 2026-01-18T17:49:59Z | Eugene | — | Fowler | 11/03/38 | NULL | •••-••-3041 | 725-334-1434 | ·eugene.fowler@icloud.com | 5011 Desert Sky Boulevard #617 | PHOENIX | AZ | null | - | ·NAVIGATE-HMO |
| PRV | PRV-20562 | 2026-06-06T08:48:21Z | JACQUELINE | — | SIMPSON | ·1951-06-01 | UHC2123896·· | null | — | jacqueline.simpson@icloud.com | 1304 Mountain View Drive | Gilbert | AZ | 85294 | - | ·null |
| PRV | PRV-24368 | 2026-06-18T03:45:57Z | Mason | — | Lcas | 19690601 | UHC-82569-27·· | - | 438-556-8143 | N/A | 2967 MESA DR | Chandler | AZ | null | NULL | N/A |
| PRV | PRV-25545 | 2026-08-11T01:11:42Z | DORIS | ·F | CONTRERAS | 1982-06-15 | UHC-33127-95 | UNKNOWN | N/A | — | — | null | — | ·NULL | ·· | — |
| PRV | PRV-27208 | 2026-04-10T01:04:41Z | SAMUEL | Y. | SIMMONS | 25-05-1945 | UHC-47169-69 | — | 847-410-0580·· | N/A | 519 Grand Ave | Orlando | FL | 32885 | N/A | MEDICARE-ADV-B |
| PRV | PRV-21426 | 2026-03-29T08:54:40Z | BOBBY | — | RODRIGUEZ | 1953-05-08 | UHC6879741 | — | 3869332186 | NULL | 2710 LINCOLN WAY | Fresno | CA | 93791 | NULL | - |
| PRV | PRV-23269 | 2026-07-14T07:21:40Z | Margaret | — | Roberts | 05/20/62 | UHC-10370-08 | •••-••-8564 | (321) 652-5886 | N/A | 6363 HIGHLAND AVE | Los Angeles | ca | 90039 | — | - |
| PRV | PRV-22287 | 2026-05-21T21:31:57Z | ·RAYMOND | — | BANKS | 2004-07-09 | — | — | 882.343.4683·· | UNKNOWN | 2102 Central Ave | Denver | CO | 80236 | null | - |
| PRV | PRV-22885 | 2026-07-22T16:54:34Z | George, Christine | — | — | 21-08-2006 | UHC-97886-80·· | NULL | 15859503220 | NULL·· | 2631 Highland Avenue | Austin·· | Texas | ·null | — | N/A |
| PRV | PRV-24361 | 2026-01-25T08:54:56Z | SCOTT | ·· | GIBSON | ·1966-11-03 | UHC-21871-27 | •••-••-0766 | (463) 585-8937 | ···· | 1015 WILLOW CT | Glendale | AZ | 85390 | — | — |
| PRV | PRV-28343 | 2026-06-16T14:05:03Z | DIANA | — | ·ELLIS | 1985-05-03·· | — | N/A | 13943315576 | null | 2713 MAPLE AVE | PHOENIX | AZ | 85047 | — | null |
| PRV | PRV-27485 | 2026-10-09T19:21:26Z | JANET | A | PAYNE | 19920708 | UHC-51229-92 | — | 7036460010 | janet.payne28@proton.me | 2335 Camelback Road | Mesa | AZ | 85281 | 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:40.350Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty