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-25131 | 2026-01-18T20:57:38Z | Judith·· | ·· | Castro | 1946-06-18 | UNKNOWN | •••-••-7866 | 338-924-9418 | — | 9281 Baseline Road | San Diego·· | CA | 92180-0731 | UNKNOWN | N/A |
| PRV | PRV-20165 | 2026-07-07T11:36:49Z | Wong, Amy | — | — | 1972-07-16 | UHC-19081-16 | - | +1 868 446 4207 | N/A | 5871 BASELINE ROAD | ·Glendale | AZ | 85320 | UNKNOWN | CHOICE-PLUS-PPO |
| PRV | PRV-24500 | 2026-02-18T21:21:38Z | BETTY | — | BROOKS | 2002-03-14 | - | •••-••-3440 | — | betty.brooks63@gmail.com | 8012 Baseline Rd | DENVER | CO | - | - | N/A |
| PRV | PRV-26428 | 2026-07-31T11:46:39Z | Flores, Hiroshi | X. | — | ·1966-10-20 | UHC-41870-78 | NULL | -·· | — | 9389 Valley View Dr | Mesa | AZ | 85268·· | ·N/A | - |
| PRV | PRV-24212 | 2026-04-16T07:30:52Z | jason | — | ortega | 9/3/1941 | UHC-52395-15 | - | - | jason.ortega78@hotmail.com | 8529 Indian School Road | Seattle | wa | 98166 | — | NULL |
| PRV | PRV-21520 | 2026-03-30T20:43:54Z | Hiroshi | — | Brown | 1975-12-15 | ·· | — | (538) 315-1912 | - | 4342 Oak St | Tempe | AZ | 85296 | — | - |
| PRV | PRV-22481 | 2026-05-10T03:00:19Z | AHMED·· | — | WAGNER | 1981-01-01 | — | null | 314-220-4944 | - | 212 BAYSHORE DRIVE | Seattle | ·WA | UNKNOWN | — | NULL |
| PRV | PRV-21417 | 2026-08-10T20:36:46Z | Jerry | — | ·Hawkins | 08/16/82 | UHC-79567-63 | — | NULL | N/A | 2004 Sunset Boulevard | Dallas | TX·· | 75280 | UNKNOWN | MEDICARE-ADV-A |
| PRV | PRV-25752 | 2026-04-16T23:26:16Z | GLORIA | — | STONE | 1945-12-08 | UHC-35804-59 | — | 4897976147 | — | 2470 Indian School Rd | Fresno | CA | 93724 | NULL | - |
| PRV | PRV-21210 | 2026-04-06T08:33:05Z | Kathleen | — | ·Ortiz | 2001-05-28·· | UHC-82174-72 | — | 968-440-5748 | null | 7729 Park Pl | Minneapolis | MN | 55479 | null | CORE-HMO |
| PRV | PRV-29544 | 2026-03-17T13:51:18Z | Timothy | Q | Bryant | 1980-04-17 | UHC-71520-19 | NULL | (531) 604-3515·· | - | 4466 Ridge Rd | Phoenix | Arizona | 85009 | UNKNOWN | — |
| PRV | PRV-24130 | 2026-09-19T06:46:20Z | beth | R | howard | 2001-12-10 | N/A | UNKNOWN | 3847102 | null | 6188 CHURCH ST·· | San Antonio | TX | 78214-4965 | N/A | — |
| PRV | PRV-20915 | 2026-03-17T01:59:33Z | PAUL | — | HUNTER | 1942-08-04·· | null | ···· | (431) 353-4254 | UNKNOWN | 8964 Maple Ave | Fresno | CA | 93791 | null | — |
| PRV | PRV-22876 | 2026-03-20T23:03:21Z | JEREMY | — | JAMES | 12/08/1956 | UHC-33338-98 | — | (345) 284-0548 | UNKNOWN | ·4486 Union St | EDEN PRAIRIE | mn | 55334 | UNKNOWN | NULL |
| PRV | PRV-27181 | 2026-04-30T00:29:50Z | Valentina | — | King | 03/28/89 | null | N/A | 409.384.5909 | N/A | 8497 Palm Drive | Orlando | FL | 32882 | — | — |
| PRV | PRV-27332 | 2026-08-26T13:33:31Z | Marilyn | — | James | 1952-06-17 | UHC-01639-27 | — | 8354061542 | — | 1285 PALM DRIVE | ·Glendale | AZ | — | - | UNKNOWN |
| PRV | PRV-22170 | 2026-05-28T17:17:19Z | Ethan | E | Dominguez | 1948-08-01 | null | N/A | 5195181446 | ethan.dominguez28@proton.me | 8430 Central Ave | Los Angeles | CA | 90003 | - | N/A |
| PRV | PRV-24095 | 2026-05-11T18:11:30Z | ·Nunez, Fatima | Y. | — | 19470614·· | UHC-68443-71 | — | 973-232-2916 | ···· | 9002 Maple Ave | Glendale | AZ | 85307 | — | - |
| PRV | PRV-21822 | 2026-03-26T06:20:23Z | Natalie·· | — | Hanson | 1962-09-17 | UHC-59968-41 | — | +1 959 311 0005 | natalie.hanson@outlook.com | 5459 Broadway | Seattle | wa | 98151 | — | null |
| PRV | PRV-22909 | 2026-01-07T07:28:34Z | Mariana | T | Green | ·1989-08-17 | ·UHC-41515-80 | — | UNKNOWN·· | — | 9052 Grand Ave | ·DENVER | CO | 80222 | ···· | navigate-hmo |
| PRV | PRV-26009 | 2026-01-15T06:41:54Z | BILLY | ···· | VALDEZ | 02-12-1968 | — | — | 4548323745 | — | 1459 Hillcrest Rd | GLENDALE | Arizona | 85310-5931 | null | UNKNOWN |
| PRV | PRV-23724 | 2026-07-15T22:03:42Z | Ethan | — | Ross | 1978-05-11 | UHC-72291-17 | — | 8693779501 | NULL | 1589 Central Avenue | Jacksonville | FL | 32248 | — | CORE-HMO |
| PRV | PRV-29536 | 2026-02-05T05:26:45Z | Grant, Amy | — | — | ·1983-06-11 | UHC-34713-39 | — | ·- | — | — | N/A | NULL | — | - | — |
| PRV | PRV-25377 | 2026-07-20T13:01:29Z | WALTER | — | GUZMAN | 1980-07-20 | — | — | (926) 884-3798 | — | 9478 Washington St | Tucson | AZ | 85787 | — | null |
| PRV | PRV-24538 | 2026-08-20T11:13:46Z | Mariana | R | Valdez | 1982-11-22 | UHC-75813-69 | •••-••-6987 | N/A | — | 1961 Apache Blvd | Dallas | Texas | N/A | UNKNOWN | ·· |
| PRV | PRV-22824 | 2026-07-15T06:54:53Z | Andrea | ···· | Franklin | 1983-11-15 | null | null | +1 841 224 3054 | — | 2792 Ocean Ave | Tempe | AZ | 85255-7399 | NULL | null |
| PRV | PRV-25008 | 2026-03-29T00:22:51Z | Charles | L | Webb | 1990-08-11 | — | NULL | 444-407-9877 | — | 2023 Desert Sky Blvd | ·LAS VEGAS | NV | ·89154 | null | CHOICE-PLUS-PPO |
| PRV | PRV-25529 | 2026-05-23T00:56:56Z | ANNA | Y | LUNA | 08/13/2001 | - | — | 859-915-9442 | — | 964 Apache Blvd #925 | LAS VEGAS | nv | 89108 | — | — |
| PRV | PRV-27637 | 2026-01-03T17:24:27Z | CHRISTOPHER | C. | THOMAS | 09/08/03 | — | — | 342-495-4941 | NULL | 2590 Ocean Avenue | CHANDLER | AZ | 85296 | - | - |
| PRV | PRV-29457 | 2026-10-03T17:46:11Z | Jose | — | Banks | 1997-11-05 | UHC9218266 | N/A | +1 716 317 9933 | UNKNOWN | 5571 MAIN STREET #201 | Dallas | TX | 75275 | — | CHOICE-PLUS-PPO |
| PRV | PRV-22622 | 2026-05-22T22:07:52Z | JOYCE | — | MORRIS·· | 1967-12-27 | UHC-36491-29 | UNKNOWN | 17705529903 | — | 4392 Elm Street | Scottsdale | AZ | 85279 | null | — |
| PRV | PRV-22382 | 2026-10-12T17:43:42Z | Diana | X·· | Richards | 08-11-2006 | — | NULL | 557-748-2727 | NULL | 3735 Cedar Ln | Mesa | AZ | 85296 | - | UNKNOWN |
| PRV | PRV-27546 | 2026-08-22T22:37:11Z | billy | N | phillips | 1952-12-19 | UHC-39529-34 | •••-••-1444 | 17817348393 | — | 1219 DESERT SKY BOULEVARD | Charlotte·· | NC | 28222 | null | ···· |
| PRV | PRV-27859 | 2026-07-03T20:51:16Z | Evans, Larry | A. | — | 09/28/1973 | — | — | 869-478-0953 | ···· | 6969 HARBOR BOULEVARD | Mesa | AZ | 85265 | — | — |
| PRV | PRV-23826 | 2026-10-06T19:38:18Z | Sarah | — | McCoy | 1955-12-01·· | UHC-25246-54 | - | (355) 460-0160 | SARAH.MCCOY@HOTMAIL.COM | ·7068 Pine Drive Apt 32 | Phoenix | AZ | 85057 | - | — |
| PRV | PRV-26236 | 2026-07-01T11:09:22Z | CAROLYN | — | WALKER | 04/28/97 | — | — | 628-312-1431 | CAROLYN.WALKER56@PROTON.ME | 911 MOUNTAIN VIEW DR | Minneapolis | MN | ·55471 | - | — |
| PRV | PRV-22523 | 2026-09-08T10:37:31Z | Reyes, John | — | — | 01/07/04 | — | — | (306) 487-3975 | john.reyes@hotmail.com | 1791 Elm St | Tempe | AZ | 85253 | - | NULL |
| PRV | PRV-27867 | 2026-08-10T03:44:10Z | Teresa | — | Woods | 1993-02-08 | N/A | null | +1 769 407 5803 | — | 6410 FOREST AVE | Eden Prairie·· | MN | 55330 | — | - |
| PRV | PRV-23256 | 2026-03-08T07:01:24Z | Janice | — | Park | 2004-10-23 | - | UNKNOWN | 940-883-7778 | — | 3497 Mountain View Drive #811 | Scottsdale | AZ·· | 85260 | null | UNKNOWN |
| PRV | PRV-23436 | 2026-04-15T13:20:50Z | Zachay | — | ·Knight | 07/23/59·· | UHC-03561-97 | — | N/A | null | 6436 Grand Avenue | Charlotte | NC | 28290 | UNKNOWN | NULL |
| PRV | PRV-21337 | 2026-03-23T02:17:50Z | debra | — | merquez | 1996-03-18 | UHC-56584-90 | UNKNOWN | 5879686316 | UNKNOWN | 6543 Lincoln Way·· | MESA | AZ | 85274 | NULL | NULL |
| PRV | PRV-26262 | 2026-02-27T09:49:10Z | LAWRENCE·· | — | SHAW | ·1968-10-26 | null | — | ·(268) 645-3729 | - | 1500 Baseline Rd | HOUSTON | TX | 77023-2686 | null | null |
| PRV | PRV-26893 | 2026-09-25T00:57:53Z | Eugene | C. | ·Padilla | 2007-06-27 | UHC-02340-28 | - | (537) 863-3073 | - | ·1804 Ridge Road | Chandler | AZ | null·· | — | ···· |
| PRV | PRV-23713 | 2026-02-23T05:45:16Z | Debra | — | Duncan | 01/03/89 | UHC-10860-41 | •••-••-2699 | (590) 388-8217 | null | 2197 Washington Street | TEMPE | AZ | 85277 | UNKNOWN | NULL |
| PRV | PRV-28176 | 2026-08-29T12:37:54Z | ·Randy | R | Vazqquez | 06/15/60 | UHC-86837-23 | NULL | 636-577-8967 | randy.vazquez@proton.me | 9686 LAKE VIEW RD | Austin | TX | 78792 | ·UNKNOWN | NULL |
| PRV | PRV-22558 | 2026-07-26T15:14:57Z | JULIA | ·· | POWELL·· | 1982-02-15 | NULL | — | 545.312.3644 | UNKNOWN | 7906 Apache Blvd | Sacramento | CA | 95864 | ···· | — |
| PRV | PRV-24336 | 2026-01-18T11:40:07Z | Luis | — | Delgado | 1999-07-17 | UNKNOWN | null | 719-946-6860 | null | 3376 Camelback Road | Denver | CO | 80216 | — | null |
| PRV | PRV-29141 | 2026-04-18T14:55:02Z | THOOMAS | — | MENDOZA | 12/26/1953 | N/A | - | 901-365-3279 | — | 8758 Indian School Rd | SAN ANTONIO | TX | 78251 | N/A | N/A |
| PRV | PRV-22945 | 2026-10-16T03:17:04Z | Roger | — | Ray | 19770803 | - | NULL | 7875008643 | — | N/A | NULL | — | null | — | — |
| PRV | PRV-26045 | 2026-03-13T17:05:47Z | LORI·· | — | NICHOLS | Oct 3, 1941 | null | •••-••-9556 | 928-967-4486 | — | 8962 UNION STREET | GILBERT | AZ | 85264-4201 | 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:43:00.515Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty