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-25209 | 2026-03-16T04:19:42Z | Fatima | — | Daniels | Jun 8, 2007 | UHC-51636-63 | UNKNOWN | 16599382100 | — | 500 DESERT SKY BOULEVARD | Plano | TX | 75014 | UNKNOWN | NULL |
| PRV | PRV-22498 | 2026-08-22T16:45:24Z | Marshall | J | Christian | 04-01-1994 | UHC-58093-69 | — | 848.509.1616 | ·NULL | 5719 SUNSET BLVD Apt 37 | Minneapolis | MN | 55478 | NULL | CHOICE-PLUS-PPO |
| PRV | PRV-25074 | 2026-05-07T08:51:36Z | ASHLEY | — | FIELDS | 25-05-1986 | uhc-74750-45·· | •••-••-1431 | null | N/A | - | — | null | null | null | N/A |
| PRV | PRV-26533 | 2026-09-27T05:57:01Z | Diego | — | Hill | 2001-12-20 | NULL | — | — | diego.hill@aol.com | 6895 Willow Court | Nashville | TN | 37201-0788 | NULL | - |
| PRV | PRV-23836 | 2026-03-24T18:30:54Z | Fields, Frances | — | — | 1951-11-04 | NULL | UNKNOWN | (414) 661-3290 | FRANCES.FIELDS@AOL.COM | 565 Main Street | Tempe | AZ | ·85239 | UNKNOWN | N/A |
| PRV | PRV-20109 | 2026-09-06T07:21:16Z | Charlie | — | Willis | Apr 17, 1954 | UHC-75469-91 | UNKNOWN | — | CHARLES.WILLIS@YAHOO.COM | 2631 LINCOLN WAY | ·Austin | TX | null | — | N/A |
| PRV | PRV-21551 | 2026-04-25T07:26:52Z | RONALD | — | SIMS | 1983-08-21 | UHC-85514-63 | null | 775-320-8593 | UNKNOWN | 2231 Church St | FRESNO | CA | 93729 | UNKNOWN | — |
| PRV | PRV-23605 | 2026-10-11T03:13:47Z | Kyle | — | Hall | 12/28/71 | — | — | 4987164866 | UNKNOWN | 3425 RIVER ROAD | Eden Prairie | MN | 55396 | ·NULL | — |
| PRV | PRV-23213 | 2026-01-04T12:53:14Z | Sarah | — | Carlson | 9189-10-24 | null | N/A | — | — | 1651 Sunset Boulevard | LAS VEGAS·· | NV | — | NULL | CHOICE-PLUS-PPO |
| PRV | PRV-24050 | 2026-07-20T12:59:51Z | ·Logan | S | Ortiz | Sep 1, 1979 | ·null | - | 860-805-6585 | UNKNOWN | ·3486 Sunset Blvd | Tempe | AZ | 85257 | UNKNOWN | N/A |
| PRV | PRV-26228 | 2026-06-27T00:16:19Z | Carolyn, Wallace·· | — | — | 07/24/97 | UHC-71193-56 | - | 3997914383 | null | — | — | - | ·NULL | NULL | — |
| PRV | PRV-25495 | 2026-05-09T23:25:34Z | RALPH | A. | CRUZ·· | 1958-06-07 | UHC-08000-40 | •••-••-2263 | 6579469524 | UNKNOWN | 2076 HIGHLAND AVENUE | Phoenix | AZ | 85068 | NULL | NULL |
| PRV | PRV-20514 | 2026-09-01T22:46:05Z | DOOROTHY | — | JACOBS | 1942-02-04 | UHC-33416-55 | — | NULL | DOROTHY.JACOBS@HOTMAIL.COM | 2626 River Road | Fresno | CA | 93771 | - | CORE-HMO |
| PRV | PRV-29567 | 2026-03-02T15:14:17Z | Rachel | I | Adams | 03/26/39 | UHC3437578 | - | (670) 587-9506 | rachel.adams@icloud.com | 5892 Oak Street | Tucson | AZ | 85724 | null | null |
| PRV | PRV-21774 | 2026-01-13T13:11:56Z | dorothy | — | olson | 1969-01-05 | UNKNOWN | — | 2069832084 | dorothy.olson@proton.me | 6538 Forest Ave | SAN ANTONIO | TX | 78248 | — | NAVIGATE-HMO |
| PRV | PRV-27815 | 2026-01-16T15:59:51Z | Gary | G | Collins | 09/17/78 | null | - | ·(342) 899-1081 | gary.collins@proton.me | N/A | — | — | NULL | — | N/A·· |
| PRV | PRV-28865 | 2026-09-10T14:15:26Z | janice | H | schultz | 1957-01-08 | null | — | (543) 878-1542 | JANICE.SCHULTZ@ICLOUD.COM | 9863 Church Street | Eden Prairie | MN | 55357 | - | null |
| PRV | PRV-28555 | 2026-05-13T19:09:48Z | melissa | — | vega | ·19731025 | -·· | — | 649-795-8231·· | — | 5150 Park Pl | Tempe | AZ | NULL | — | ·UNKNOWN |
| PRV | PRV-21845 | 2026-05-01T15:56:15Z | TERRY·· | E | DUNN | 6/22/1970 | UHC-54521-89 | •••-••-6392 | 419-315-2449 | terry.dunn@icloud.com·· | 1568 Cedar Lane | San Antonio | tx | N/A | — | — |
| PRV | PRV-26808 | 2026-02-22T17:31:07Z | RALPH | — | WASHINGTON | 1977-07-06 | N/A | null | 450-891-3008 | — | 3498 MEADOW LN | Plano | TX | 75077 | - | — |
| PRV | PRV-25624 | 2026-05-13T10:49:49Z | Cunningham, Peter | — | — | 02/27/65 | UHC-99835-78 | null·· | 17143207399 | — | 7919 Union St | Plano | TX | 75005 | -·· | ·N/A |
| PRV | PRV-21030 | 2026-04-22T11:47:37Z | PAMELA | — | ESPINOZA | 7/6/1975 | UHC-71228-89 | UNKNOWN | UNKNOWN | pamela.espinoza89@gmail.com | 952 Lincoln Way | San Diego | CA | 92177 | null | NAVIGATE-HMO |
| PRV | PRV-22273 | 2026-08-28T16:11:14Z | HAROLD | D | MITCHELL | 2005-12-08 | NULL | — | (437) 803-8460 | harold.mitchell@yahoo.com | 5445 UNION ST Apt 23 | Los Angeles | CA | 90049 | — | CHOICE-PLUS-PPO |
| PRV | PRV-25067 | 2026-08-08T11:37:18Z | RUSSELL | Q. | MATTHEWS | 1964-12-28 | — | — | 968-439-7875 | N/A | 8711 Union St | San Antonio | TX | 78245 | N/A | — |
| PRV | PRV-27478 | 2026-04-08T15:23:54Z | Christopher | B | Stephens | 09/21/88 | UHC-69472-98 | UNKNOWN | (921) 998-3447 | UNKNOWN | 5720 Valley View Drive | Gilbert | AZ | 85227 | ·· | — |
| PRV | PRV-23120 | 2026-02-24T04:30:13Z | Billy | — | Morris | 1999-02-06 | — | NULL | ·· | ·null | 1727 CANYON ROAD | Atlanta | Georgia | 30364 | — | — |
| PRV | PRV-24654 | 2026-10-03T12:12:37Z | RANDY | — | MARSHALL | 17-12-2007 | UHC2191714 | — | 5213290907 | randy.marshall71@proton.me | N/A | ·UNKNOWN | N/A | N/A | null | N/A |
| PRV | PRV-25539 | 2026-05-24T08:20:54Z | Parker, Tyler | — | — | 2008-07-24 | — | null | ·8367210922 | NULL | NULL | N/A | N/A | null | — | N/A |
| PRV | PRV-29099 | 2026-01-14T19:01:06Z | Joe | — | Vargas | 1973-02-28 | UHC-09497-55 | •••-••-2860 | 774-517-5459 | joe.vargas45@proton.me | 4634 Lake View Rd·· | DALLAS | TX | N/A | null | - |
| PRV | PRV-23471 | 2026-01-17T13:34:30Z | JOSH | — | SANDERS | 06/07/52 | N/A | NULL | 4738258178 | — | 9202 Hillcrest Road | Tempe | AZ | 85217 | N/A | — |
| PRV | PRV-23461 | 2026-05-06T12:36:48Z | Ryan, Eugene | — | ·· | Oct 12, 1938 | UHC3171962 | NULL | 6568533992 | NULL | 8037 Valley View Dr | San Diego | CA | 92133 | — | — |
| PRV | PRV-25402 | 2026-10-13T12:28:32Z | Eugene | — | Gordon | 2000-06-13 | UHC-51400-98 | — | 395-835-9187 | — | 3363 Forest Ave | Las Vegas | Nevada | 89134 | — | core-hmo |
| PRV | PRV-20804 | 2026-06-26T17:34:48Z | Mark | — | Ray·· | 1947-03-25 | UHC-24246-62 | N/A | UNKNOWN | — | 7803 Valley View Dr | Chandler | AZ | 85272 | — | -·· |
| PRV | PRV-20309 | 2026-09-12T02:35:26Z | Sullivan, Gary | — | — | 03-11-1965 | — | •••-••-2091 | 7709632432 | null | 4564 Baseline Rd | Atlanta | GA | 30334 | - | — |
| PRV | PRV-21461 | 2026-02-07T02:32:56Z | Joyce | ·Q. | Gibson | Apr 10, 1984 | N/A | N/A | (836) 748-8813 | ·N/A | 2946 Ocean Ave | Las Vegas | NV | N/A | N/A | null |
| PRV | PRV-24419 | 2026-09-26T10:29:06Z | gerald·· | ···· | tucker | 1941-04-21 | UHC-93483-60 | •••-••-2022 | NULL | null | 3156 Canyon Road | Tucson | AZ | 85768 | null | ···· |
| PRV | PRV-28125 | 2026-02-26T15:36:26Z | Jacqueline | — | Mitchell | 1984-06-10 | UHC-85622-08 | UNKNOWN | - | ·· | 7226 Broadway | DENVER | CO | 80223 | — | — |
| PRV | PRV-29184 | 2026-08-29T23:29:31Z | christina | A | silva | 20-01-1989 | — | - | (552) 493-2005 | CHRISTINA.SILVA26@AOL.COM | 4021 MAPLE AVENUE | Las Vegas | NV | 89161 | UNKNOWN | SELECT-EPO |
| PRV | PRV-21114 | 2026-07-06T11:38:04Z | Jose | — | Rivera | 11/18/2000 | null | - | 923-988-6567 | null | 1290 Union Street | Mesa | AZ | 85228 | — | SELECT-EPO |
| PRV | PRV-21428 | 2026-09-09T23:24:27Z | Vicnent | H | Hart | Apr 5, 1976 | UHC-99163-01·· | — | — | UNKNOWN | 3166 OAK STREET | MINNEAPOLIS | MN | 55413 | N/A | UNKNOWN·· |
| PRV | PRV-29003 | 2026-05-20T05:51:45Z | ALEXANDER | — | STEPHENS | 1991-02-08 | UNKNOWN | ·· | +1 718 625 5194 | alexander.stephens@icloud.com | 7415 OAK STREET | Glendale | AZ·· | 85319·· | N/A | — |
| PRV | PRV-24945 | 2026-08-08T10:03:40Z | Jose | ···· | Hall·· | 1944-09-22 | - | — | 525-346-4344 | NULL | 8803 CHURCH STREET | Austin | TX | 78753 | — | N/A |
| PRV | PRV-28127 | 2026-10-15T15:02:01Z | ·David | D | Griffin | Jul 13, 1958 | UHC-59486-30 | — | — | UNKNOWN | 9704 Forest Avenue | Scottsdale | AZ | 85264-6877 | — | — |
| PRV | PRV-20985 | 2026-03-06T11:59:08Z | Lucia | ·D | Bradley | 1997-12-17 | — | UNKNOWN | 522-831-4300 | - | 3641 SPRING STREET | ·Eden Prairie | MN | 55317 | N/A | ···· |
| PRV | PRV-27562 | 2026-04-06T15:06:44Z | Betty | — | ·Lucas | 05/20/58 | N/A | NULL | +1 292 374 0103 | ·UNKNOWN | — | ·null | N/A | - | UNKNOWN | — |
| PRV | PRV-26068 | 2026-05-26T04:45:04Z | AMY | — | LYNCH | 2007-07-28 | NULL | null | +1 783 920 7817 | ·N/A | 6954 HIGHLAND AVENUE | Chandler | AZ | 85273 | — | — |
| PRV | PRV-20036 | 2026-08-08T15:07:19Z | charles | N | hall | 19830504 | UHC-31175-80 | - | (566) 488-0620 | charles.hall@icloud.com | 9101 Sage Court | Tucson | AZ | 85798 | — | — |
| PRV | PRV-25515 | 2026-04-18T11:26:53Z | Sofia | — | Mendozza | 1974-07-26 | — | •••-••-9788 | 681-366-8192·· | — | 527 Union Street | SCOTTSDALE | AZ | 85233 | — | N/A |
| PRV | PRV-20659 | 2026-03-22T11:13:43Z | William | — | Taylor | 10/14/2007 | UHC-44116-66 | •••-••-1748 | 9714944605 | null | 5581 RIDGE RD | LAS VEGAS | NV | 89142 | null | null |
| PRV | PRV-25651 | 2026-01-16T03:26:56Z | Nicole | — | Carr | 1961-06-14 | -·· | -·· | (402) 380-2792 | ·NICOLE.CARR93@OUTLOOK.COM | 7331 PINE DR | Phoenix | AZ | 85053 | null·· | UNKNOWN |
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.052Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty