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-20381 | 2026-03-18T10:09:48Z | KATHERINE | ·· | CARPENTER·· | 04/23/49 | UHC-20620-59 | UNKNOWN | 6706839429 | katherine.carpenter46@proton.me | 4824 LAKE VIEW RD | Plano·· | TX | 75046 | null | null |
| PRV | PRV-20565 | 2026-09-28T11:46:43Z | Gutierrez, Camila | F. | — | 1981-01-01 | null | — | 8184289736 | - | 4059 Maple Ave | Glendale·· | AZ | 85343 | - | — |
| PRV | PRV-22021 | 2026-10-04T02:49:08Z | VIRGINIA | N | CARR | 1959-09-19 | UHC-61614-40 | — | 325-445-1452 | ·· | 9085 Church Street | Dallas | TX·· | NULL | — | - |
| PRV | PRV-21086 | 2026-05-28T03:21:22Z | GERALD·· | B | HARRIS·· | 2001-11-10 | UHC-76132-83·· | — | 6010789 | NULL | 2875 MOUNTAIN VIEW DR | Dallas | tx·· | 75275 | NULL | — |
| PRV | PRV-24926 | 2026-09-28T01:35:04Z | Robertsson, Debra | C | — | 1983-01-04 | UHC-55599-52 | NULL·· | 7105004908 | — | 4220 CANYON RD | Seattle | ·WA | 98134 | NULL | null |
| PRV | PRV-28979 | 2026-03-25T20:55:26Z | Hiroshi | — | Sims | ·1972-10-22 | UNKNOWN | •••-••-4506 | (835) 279-8010 | hiroshi.sims92@yahoo.com | 393 LINCOLN WAY | ·Fresno | CA | ·93766 | UNKNOWN | — |
| PRV | PRV-26078 | 2026-03-26T23:25:34Z | ANTHONY | — | RILEY | 19411225 | ·UHC-65454-36 | N/A | 909-679-5110 | anthony.riley93@outlook.com | 6638 WILLOW CT | Charlotte | North Carolina | — | — | null |
| PRV | PRV-24198 | 2026-09-28T23:08:40Z | Luis | — | Miller | 1998-03-25 | UHC-85826-69 | N/A | — | — | 6417 Apache Blvd | Fresno | ca | ·93795 | UNKNOWN | — |
| PRV | PRV-21401 | 2026-10-14T19:09:45Z | Marcus | — | Hart | Nov 13, 1983 | UNKNOWN | UNKNOWN·· | — | marcus.hart@gmail.com | 3873 LINCOLN WAY | Gilbert·· | AZ | 85279 | — | NAVIGATE-HMO |
| PRV | PRV-26175 | 2026-04-09T17:22:52Z | Christopher | — | Castro | 02/27/2005 | - | — | (301) 432-5148·· | null | 1841 Maple Avenue·· | Las Vegas | ·NV | 89108 | null | NAVIGATE-HMO |
| PRV | PRV-27837 | 2026-04-22T00:06:29Z | ralph | — | kelley | 09/22/75 | UHC-28952-82 | - | 8395879904 | RALPH.KELLEY@AOL.COM | 1320 PINE DR | TEMPE | AZ | — | — | — |
| PRV | PRV-25865 | 2026-07-03T19:26:36Z | Garcia, William | — | — | 1954-01-11 | UHC-02353-22 | NULL | 224-293-0388 | — | 4474 HIGHLAND AVE | San Antonio | TX | 78234 | ·· | UNKNOWN |
| PRV | PRV-22252 | 2026-03-19T04:04:16Z | william | — | mcdonald | 8/17/1987 | UNKNOWN | •••-••-2402 | 563-988-9435·· | ·null | 2281 Pine Dr | Las Vegas | NV | 89161 | NULL | MEDICARE-ADV-A |
| PRV | PRV-22949 | 2026-09-04T14:01:08Z | Alexander | E. | Carpenter | 1948-07-15 | - | — | N/A | null | 1607 Oak Street | ORLANDO | FL | 32811 | - | — |
| PRV | PRV-23439 | 2026-01-24T00:45:04Z | Jose | — | Rodriguez | 1972-10-11 | UHC4992588 | — | 347-218-3963 | null | 385 Market Street | ·Dallas | TX | 75261 | — | UNKNOWN |
| PRV | PRV-23278 | 2026-09-20T01:37:25Z | Nathan | — | Gutierrez | 1996-06-12 | UHC-41662-03 | — | — | - | 4249 CANYON ROAD | Orlando | ·FL | 32837·· | — | — |
| PRV | PRV-21679 | 2026-07-11T10:22:23Z | Anna | — | ·Bennett | 3/28/1969 | UHC-77170-89 | — | 487.561.3684 | ANNA.BENNETT@PROTON.ME | 2754 Desert Sky Blvd·· | Scottsdale | AZ | 85258 | - | UNKNOWN |
| PRV | PRV-22792 | 2026-08-31T01:23:42Z | PRIYA | ···· | WEST | 1999-03-13 | UHC-77568-76·· | ·· | ·248-975-6166 | priya.west@aol.com | 1090 BROADWAY | Eden Prairie | MN | 55382 | N/A | NAVIGATE-HMO |
| PRV | PRV-25051 | 2026-04-02T23:03:59Z | Olivia | K | Bradley·· | 1950-11-05 | - | - | +1 505 806 7939 | null | 293 Grand Ave | Sacramento | CA·· | 95873 | UNKNOWN | — |
| PRV | PRV-24870 | 2026-01-09T20:44:23Z | ·Samuel | F | Bunrs | 12-07-1982 | UHC-91892-68 | — | 896-961-9072 | UNKNOWN | null | N/A | - | - | — | null |
| PRV | PRV-25969 | 2026-01-28T06:54:55Z | LOGAN | — | GARDNER | 1946-06-26 | UHC-53930-19·· | - | (589) 870-6565 | NULL | 6261 Washington Street | SAN ANTONIO | TX | 78256 | null | NULL |
| PRV | PRV-20211 | 2026-10-06T11:29:42Z | Tony | Q. | Kelly | 2000-12-23·· | ·UHC-84357-74 | — | 562-847-9738 | — | 5361 Sunset Blvd | Eden Prairie | MN | 55325 | — | null |
| PRV | PRV-27771 | 2026-02-09T14:04:39Z | Priya | — | Vldez | 1977-12-20 | UNKNOWN | — | (982) 929-9460 | — | 6896 Canyon Road | Plano | TX | 75033·· | — | NAVIGATE-HMO |
| PRV | PRV-28026 | 2026-01-22T10:48:00Z | Gregry | — | Sandoval | Feb 21, 1980 | - | null | 375-378-5007 | - | 1634 MESA DR | Jacksonville | fl | 32266-2010 | - | UNKNOWN |
| PRV | PRV-27950 | 2026-09-17T21:37:27Z | Arjun | ·· | Morales | 1977-02-03 | — | — | 904.739.3557 | null | 3741 Lincoln Way | Glendale | AZ·· | ·85338 | — | N/A |
| PRV | PRV-23653 | 2026-06-22T20:03:33Z | SHIRLEY | ·· | COLEMAN | 1954-03-14·· | null | — | null | ···· | 6553 Lake View Rd | Austin | TX | 78755 | null | MEDICARE-ADV-A |
| PRV | PRV-25109 | 2026-08-26T14:39:34Z | Angela | — | Watkins | Nov 8, 1959 | UHC-59656-73 | •••-••-9474 | 353-914-7433 | — | 3595 MOUNTAIN VIEW DRIVE | Jacksonville | FL | null | - | null |
| PRV | PRV-25639 | 2026-05-14T10:28:34Z | Wallace, Jesse | — | — | Jun 1, 2005 | — | — | 490-717-4293 | ·NULL | — | - | - | NULL | NULL | — |
| PRV | PRV-26249 | 2026-09-30T12:09:17Z | Nathan | I. | Nelson | 1980-02-19 | N/A | null | 714-857-0254 | — | 2023 Park Pl | Tampa | FL | 33608 | UNKNOWN | null |
| PRV | PRV-22991 | 2026-05-06T09:35:28Z | Abigail | — | Mertinez | Mar 8, 1967 | UHC-84886-97 | - | (751) 252-2900 | abigail.martinez56@yahoo.com | 2815 River Rd | Mesa | AZ·· | 85212 | null | — |
| PRV | PRV-23447 | 2026-02-04T05:06:09Z | ARTHUR | — | CHEN | 9146-09-05 | UHC-64162-33 | UNKNOWN | 496-814-6384 | ARTHUR.CHEN@YAHOO.COM | 2514 Apache Blvd | Dallas | TX | 75268 | — | — |
| PRV | PRV-20057 | 2026-08-28T13:16:31Z | Robert | — | Jenkins | 04/28/48 | UHC-46816-23 | - | 7208274033 | robert.jenkins@aol.com | 3732 LAKE VIEW RD | Glendale | AZ·· | 85357 | — | ···· |
| PRV | PRV-23477 | 2026-05-24T18:20:23Z | Greene, Rebecca | — | — | 2006-05-05 | UHC-66153-41 | - | - | REBECCA.GREENE@GMAIL.COM | 3070 Palm Dr | Tampa | ·FL | 33694 | — | — |
| PRV | PRV-27495 | 2026-10-05T14:29:12Z | Joe | — | Scott | 1982-04-21 | UHC-63070-24·· | ·N/A | 571-459-2362 | - | - | NULL | null | UNKNOWN | — | ·null |
| PRV | PRV-28930 | 2026-04-03T20:11:23Z | Johnston, Anthony | — | — | 11/28/2005 | UHC-74682-65 | UNKNOWN | 2978502921 | null | 713 Mountain View Dr | Fresno | CA | 93719 | NULL | — |
| PRV | PRV-24082 | 2026-10-11T23:20:26Z | OMAR | D | NGUYEN | 1997-06-08 | N/A | UNKNOWN | 880-256-8685 | OMAR.NGUYEN@YAHOO.COM | 5478 LAKE VIEW RD | Tampa | FL | 33621 | null | — |
| PRV | PRV-27611 | 2026-02-18T16:37:48Z | DONNA | F. | ·REED | ·1985-11-09 | N/A | — | — | UNKNOWN | N/A | — | — | — | — | - |
| PRV | PRV-22843 | 2026-03-20T17:46:30Z | Charlotte | — | Salazar | 1975-09-06 | UNKNOWN | UNKNOWN | 740-368-0028 | — | 6582 Central Avenue | ·ATLANTA | Georgia | 30388 | null | null |
| PRV | PRV-20576 | 2026-06-01T21:16:31Z | ·HEATHER | M | FISHER | ·1961-01-07 | UHC-92896-47 | UNKNOWN | 524-207-0320 | — | 3767 Market St | Los Angeles | CA | 90043 | null | N/A |
| PRV | PRV-29580 | 2026-08-14T02:53:54Z | Julie | — | Ross | 1939-11-28 | UHC-35911-86 | — | 382-956-2824 | — | NULL | ·· | — | - | UNKNOWN | NAVIGATE-HMO |
| PRV | PRV-21105 | 2026-07-03T09:29:17Z | Charyl·· | — | Montgomery | 1991-03-14 | UHC-59035-49 | — | (206) 474-2682 | CHERYL.MONTGOMERY99@HOTMAIL.COM | ·3629 ELM ST | Dallas | TX | 75207 | N/A | — |
| PRV | PRV-22922 | 2026-03-23T22:16:28Z | Sharon | — | Ellis | 1982-09-20 | - | — | 936-442-7562 | — | 8570 MAPLE AVE | ·Phoenix | AZ | 85085-0337 | UNKNOWN | options-ppo |
| PRV | PRV-23825 | 2026-05-08T08:38:48Z | FRANK | W. | SALAZAR | 1988-09-10 | UHC-98170-43 | — | (521) 212-9491 | — | UNKNOWN | — | NULL | — | NULL | — |
| PRV | PRV-23852 | 2026-07-07T10:55:13Z | Laura | — | Gonzalez | 2003-10-20 | UHC3350482 | — | 857-546-1907 | UNKNOWN | null | ···· | NULL | ·· | — | N/A |
| PRV | PRV-28648 | 2026-01-14T12:30:03Z | NATALIE | ·· | WEBER | 08/06/66 | null | — | 4446143 | natalie.weber@icloud.com | 3991 Hillcrest Rd | Fresno | CA | 93768 | null | — |
| PRV | PRV-29491 | 2026-07-20T07:24:24Z | Stevens, Joe | — | — | 1952-07-16 | ·UNKNOWN | - | (578) 587-5708 | NULL | 6977 Apache Boulevard | Seattle | ·WA | 98174 | — | - |
| PRV | PRV-27199 | 2026-04-17T03:35:44Z | Charles | C | Reynolds | 26-09-1961 | N/A | null | 12975574630 | CHARLES.REYNOLDS@AOL.COM | ·6382 APACHE BOULEVARD | ·Orlando | FL | 32824 | NULL·· | NULL |
| PRV | PRV-22579 | 2026-03-19T05:20:44Z | Evelyn | — | Nguyen | 2006-09-24 | UHC-71046-85 | — | 714.846.6990·· | — | — | NULL | — | N/A | — | -·· |
| PRV | PRV-21304 | 2026-02-10T14:38:45Z | GRACE | — | GARDNER | 1961-12-10 | UHC-54937-30 | •••-••-1395 | N/A | N/A | - | ·null | — | NULL·· | — | — |
| PRV | PRV-27291 | 2026-10-11T18:48:23Z | Jose | T. | Patterson | 1982-09-22·· | — | ·N/A | (849) 655-0950 | — | 9395 Sunset Blvd | Houston | Texas | — | 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-22T12:42:40.355Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty