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-26359 | 2026-01-21T06:42:13Z | KEITH | — | STEWART | 1996-08-13 | ·UHC-20256-95 | NULL | 7415208412 | ·- | — | - | — | — | NULL | UNKNOWN |
| PRV | PRV-25746 | 2026-07-21T00:20:36Z | FRANK | — | BRADLEY | 11-04-1967 | UHC-83035-86 | ·· | +1 522 334 8332 | — | 789 Church St | Plano | TX | 75015 | N/A | OPTIONS-PPO |
| PRV | PRV-27773 | 2026-03-25T01:58:37Z | SHARON | — | SALAZAR | 18-01-1961 | UHC-10097-24 | null | 390.866.0416·· | UNKNOWN | 6442 Market St·· | Denver | CO | 80278 | null·· | — |
| PRV | PRV-26785 | 2026-07-31T21:53:11Z | ruth | ···· | jackson | 2003-08-16 | null | •••-••-0932 | 17248121502 | N/A | 8808 Camelback Rd | Las Vegas | NV·· | - | N/A | — |
| PRV | PRV-29401 | 2026-08-25T21:54:48Z | Richard | T | Burns | 1955-09-02 | — | •••-••-4660 | (540) 729-9760 | null | null | UNKNOWN | N/A | — | NULL | MEDICARE-ADV-B |
| PRV | PRV-26780 | 2026-06-24T18:57:13Z | ISABELLA P. | — | FREEMAN | Sep 13, 1965 | N/A | UNKNOWN | 860-514-3057 | ·NULL | 2072 Market St | Los Angeles | CA | 90059-0073 | null | — |
| PRV | PRV-27079 | 2026-04-27T19:35:15Z | Howard, Carlos | — | — | 11/24/63 | — | null | 311-519-3041 | — | 5732 Desert Sky Blvd | CHANDLER | AZ | 85231 | ·- | UNKNOWN |
| PRV | PRV-27353 | 2026-10-09T09:43:39Z | Frances | — | Weaver | 12/23/1999 | ·UHC-64989-59 | NULL·· | 8169184825 | FRANCES.WEAVER@AOL.COM | 9050 CAMELBACK RD | Seattle | WA | 98143 | N/A | N/A |
| PRV | PRV-28170 | 2026-08-27T21:56:59Z | Harris, Mei | — | — | 1945-10-08 | UHC-08874-15 | null | (731) 408-3975 | mei.harris1@outlook.com | 2008 Maple Ave | LOS ANGELES | CA | 90037-1833 | NULL | — |
| PRV | PRV-29007 | 2026-06-13T00:18:16Z | CAROLYN | D | SIMMONS | 04/05/60 | UHC-93810-96 | — | 876-651-6529 | - | 7621 CAMELBACK ROAD | Jacksonville | FL | 32270 | UNKNOWN | NULL |
| PRV | PRV-21705 | 2026-07-26T18:17:19Z | Schmidt, Hannah | ···· | — | Jan 13, 1959 | UHC-54182-06 | UNKNOWN | — | — | ·5316 PARK PL | San Antonio | TX | 78226-6198 | ·N/A | UNKNOWN |
| PRV | PRV-26409 | 2026-07-03T22:59:49Z | Diaz, Maria | — | — | 1985-09-16 | null | — | 6726332025 | N/A | ·1719 Spring Street | Miami | FL | 33159 | — | ·null |
| PRV | PRV-26600 | 2026-06-25T07:12:47Z | Martha | ···· | Dixon | 1980-12-27 | - | NULL | 7392825747 | martha.dixon@icloud.com | 6794 Park Pl | Atlanta | GA | 30377 | null | N/A |
| PRV | PRV-23870 | 2026-08-10T23:06:16Z | RYAN | H·· | SCHULTZ | 19820515 | UHC-89183-96 | N/A | (564) 706-7001 | ryan.schultz@hotmail.com | 7856 Elm St | Glendale | AZ | 85345 | N/A | — |
| PRV | PRV-28147 | 2026-05-02T07:04:21Z | Melissa·· | T. | Lucas | 1985-03-13 | UHC-51145-37 | - | 776.862.8203 | NULL | 1946 DESERT SKY BLVD | Charlotte | ·NC | N/A | — | — |
| PRV | PRV-27963 | 2026-05-23T17:39:29Z | Margaret | — | Foster | 1950-06-28 | — | - | — | UNKNOWN | ·9550 Highland Ave | Phoenix | AZ | 85045 | UNKNOWN | N/A·· |
| PRV | PRV-25727 | 2026-07-26T23:28:42Z | ·MARIA | J | OLIVER | 4/2/1982 | UHC-92965-78 | •••-••-1232 | 948-815-9669 | maria.oliver@hotmail.com | 8314 WILLOW CT #843 | Miami | FL | UNKNOWN | UNKNOWN | — |
| PRV | PRV-26798 | 2026-03-09T14:17:55Z | Watson, Isabella | — | — | 1977-02-03 | UHC-11528-25 | UNKNOWN | +1 679 571 1721 | ISABELLA.WATSON88@PROTON.ME | 6426 Washington St | Houston | TX | 77066 | null·· | ·UNKNOWN |
| PRV | PRV-22167 | 2026-06-14T13:52:46Z | Zachary | — | Hughes | 1988-02-18 | UHC-96105-20 | — | 2949321 | zachary.hughes58@aol.com | 4613 Canyon Road·· | Seattle | Washington | 98121 | — | ·· |
| PRV | PRV-24800 | 2026-06-22T07:40:08Z | Davis, David | V·· | — | 1948-04-05·· | UHC-44621-94·· | NULL | 696-946-2810 | david.davis27@gmail.com | — | — | — | ···· | N/A | null |
| PRV | PRV-25275 | 2026-05-26T06:48:46Z | Patricia·· | ···· | Phillips | 1964-04-13 | UHC-42386-79 | — | +1 521 961 1092 | PATRICIA.PHILLIPS@YAHOO.COM | 6649 Hillcrest Rd | Plano | TX | 75021-7046 | null | NULL |
| PRV | PRV-22114 | 2026-07-03T10:52:50Z | Ryan | M | Duncan | ·11/20/02 | UNKNOWN | — | (500) 236-3668 | ryan.duncan@yahoo.com | 8674 Willow Ct | Plano | TX | 75024 | - | CORE-HMO |
| PRV | PRV-23765 | 2026-03-18T15:11:06Z | BENJAMIN·· | — | CHEN | 19760915 | UHC-26104-20 | N/A·· | 656.764.6035 | NULL | 1923 River Road | Seattle | WA | 98142 | null | — |
| PRV | PRV-23019 | 2026-06-27T15:54:10Z | Nicole | — | Munoz | 20060619 | — | •••-••-0485 | (444) 761-0655 | null·· | 9023 CHURCH ST | NASHVILLE | TN | 37248 | - | - |
| PRV | PRV-29396 | 2026-09-03T20:39:58Z | JAMES | — | RUIZ | 19870719 | UHC9243095 | •••-••-8105 | 3378820309 | NULL | — | - | - | — | — | — |
| PRV | PRV-22118 | 2026-04-14T09:47:35Z | Roger | Z | Jackson | 4/16/1949 | — | — | +1 205 428 4245 | roger.jackson14@icloud.com | — | NULL·· | UNKNOWN | null | N/A | NULL |
| PRV | PRV-23998 | 2026-09-28T14:17:46Z | Sarah | I | Oliver | 1996-07-24 | UHC3290231 | N/A·· | +1 228 513 6446·· | - | 4779 Union Street | Minneapolis | MN | 55405 | — | — |
| PRV | PRV-22013 | 2026-04-26T00:42:44Z | CAROL | — | ROSS | 12/21/54 | — | N/A | 871-255-7331 | — | 1098 Desert Sky Blvd | Tampa | FL | 33623 | ·· | null |
| PRV | PRV-22209 | 2026-07-04T03:38:44Z | henry | Z | hoffmaan | 1945-04-24·· | UHC-24303-37 | — | 900-464-9957 | — | 8962 HILLCREST ROAD | Orlando | FL | 32845 | N/A·· | NULL |
| PRV | PRV-21348 | 2026-03-13T19:46:12Z | MASUN | — | BOWMAN | 1979-01-19 | UHC-89875-58 | - | 4143894502 | — | 1815 Sunset Boulevard | Atlanta | GA | 30348 | - | NULL |
| PRV | PRV-23661 | 2026-09-17T15:15:24Z | KATHERINE | — | MORALES | 1949-06-28 | UHC-69962-70 | - | 709-921-5098 | KATHERINE.MORALES@OUTLOOK.COM·· | 9500 Sunset Blvd | LOS ANGELES | CA | 90008 | — | N/A |
| PRV | PRV-25335 | 2026-10-09T19:56:42Z | JACK | X | DUNN | 1975-08-10 | UHC-22549-45 | — | 5743947611 | jack.dunn@yahoo.com | 4632 Mesa Drive | ·LOS ANGELES | CA | 90029 | UNKNOWN | N/A |
| PRV | PRV-21004 | 2026-09-19T10:07:13Z | KELLLY | — | SHAW | 10-12-1994 | UHC-70062-36 | — | N/A | N/A | 7662 LAKE VIEW ROAD | CHANDLER | AZ | 85265 | — | — |
| PRV | PRV-25801 | 2026-05-09T02:20:36Z | Wagner, Rachel | O | — | 28-02-1967 | UHC-69511-69 | •••-••-0495 | (688) 430-1702 | N/A | 3551 Palm Drive | Columbus | OH | 43210·· | — | -·· |
| PRV | PRV-25854 | 2026-10-08T09:45:28Z | Julia | — | Sanchez | 12/07/04 | NULL | null | 2687424897 | NULL | 5416 FOREST AVENUE | GLENDALE | AZ | 85343 | N/A | MEDICARE-ADV-A |
| PRV | PRV-28866 | 2026-05-08T23:18:05Z | Reed, Maria | — | — | 1944-03-19 | NULL | UNKNOWN | +1 877 732 7613 | MARIA.REED@AOL.COM | 7228 RIDGE ROAD | Jacksonville | Florida | 32257 | NULL | UNKNOWN |
| PRV | PRV-21094 | 2026-03-26T09:26:09Z | Christopher | — | Pierce | 9/16/1985 | UHC-28425-80 | — | — | N/A | 5397 Ridge Rd | Austin·· | Texas | 78793 | - | N/A·· |
| PRV | PRV-20824 | 2026-01-08T13:45:52Z | ·Alexander | V. | Contreras | ·1954-30-12 | UHC-84406-53 | null | (832) 701-5035 | alexander.contreras@proton.me | 9114 Camelback Road | Eden Prairie | MN | 55379 | — | MEDICARE-ADV-A |
| PRV | PRV-20358 | 2026-08-17T13:00:12Z | REBECCA Y | — | GARZA | 19760604 | ·UHC5007412 | - | — | ···· | - | - | null | — | NULL | ·· |
| PRV | PRV-29570 | 2026-08-12T00:57:32Z | LINDA | — | BISHOP | 05/16/1942 | UHC-76949-11 | •••-••-9066 | 4547007895 | — | 1478 Maple Ave #884 | Jacksonville | FL | N/A | — | NULL |
| PRV | PRV-24120 | 2026-06-10T06:22:15Z | Wayne | — | Richardson | 0611-20-70 | — | — | 8955215588 | N/A | — | null | - | — | — | UNKNOWN |
| PRV | PRV-20516 | 2026-03-08T17:59:29Z | Dot | — | Perez | 1984-06-20 | UHC-96748-73 | - | +1 209 868 9013 | N/A | 2167 Mesa Dr | Seattle | WA | 98109 | — | - |
| PRV | PRV-24322 | 2026-06-12T12:45:45Z | sandra·· | Y. | ·obrien | 1985-10-07 | UHC-52659-90 | NULL | — | UNKNOWN | 7731 Spring St | Atlanta | ·GA | 30320 | N/A | N/A |
| PRV | PRV-29008 | 2026-10-13T00:27:00Z | Kim, Andrea | N | — | 1/18/1939 | UHC-58093-27 | UNKNOWN | 2789198035 | - | 152 Market Street | Houston | TX | 77022 | null | - |
| PRV | PRV-29323 | 2026-02-13T16:11:20Z | Singh, Victoria | — | — | ·18-04-1941 | UHC-82237-08 | — | 4874165697 | N/A | 3955 Grand Ave | Chandler | AZ | 85255 | - | — |
| PRV | PRV-20832 | 2026-02-07T19:24:56Z | TYLER | — | CRAWFORD | 08/07/68 | NULL | NULL | 725-501-5011 | — | 9252 RIDGE ROAD | Plano | TX | 75095 | — | NULL |
| PRV | PRV-28868 | 2026-03-16T11:14:11Z | brandon | — | munoz | Dec 6, 1939 | NULL | — | +1 278 617 4336 | UNKNOWN | — | NULL | — | — | null | — |
| PRV | PRV-22133 | 2026-08-18T15:52:44Z | ·Kimberly | — | Munoz | Dec 22, 2007 | UHC-59562-45 | UNKNOWN | 5384042562 | NULL | 5212 SPRING ST | Jacksonville | FL | 32237 | — | - |
| PRV | PRV-23565 | 2026-09-02T00:54:26Z | Frances | — | Harvey | 1985-03-28 | NULL | NULL | 702-647-7439 | - | 3719 Mesa Drive | Minneapolis | Minnesota | 55414 | — | — |
| PRV | PRV-25053 | 2026-06-03T23:38:43Z | lawrence | — | greene | 1987-01-10 | — | N/A·· | (290) 919-5527 | null | 2538 Sage Ct | Austin | TX | 78736 | 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.645Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty