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-26142 | 2026-07-04T10:13:11Z | CARLOS | — | DEAN | 08/04/1970 | UHC-27915-16 | UNKNOWN | 211.453.2730 | - | NULL | null | - | null | - | — |
| PRV | PRV-24572 | 2026-06-26T10:22:25Z | Amy | G | Reynolds | 1948-05-26 | — | — | 5556186354 | amy.reynolds95@hotmail.com | 5432 MEADOW LANE | Tempe | ·AZ | 85225 | null | UNKNOWN |
| PRV | PRV-23985 | 2026-09-14T21:30:16Z | Catherine | — | Robertson | 1941-07-02 | — | — | 420-382-0793 | catherine.robertson@hotmail.com | 4634 DESERT SKY BLVD | Fresno·· | CA | ·93766 | NULL | UNKNOWN |
| PRV | PRV-22224 | 2026-05-07T21:48:05Z | Laura | V | Bryant | 1985-06-09 | UHC-42238-04 | - | 791.932.1075 | null | 2223 JEFFERSON AVENUE | Mesa | AZ | 85215 | NULL | NAVIGATE-HMO |
| PRV | PRV-20475 | 2026-06-17T08:56:24Z | Michael | ·· | Fields | 1969-09-14 | UHC-13912-97 | — | 5934521973 | - | 332 Baseline Road | Tucson | AZ | 85756 | UNKNOWN | — |
| PRV | PRV-22865 | 2026-08-16T06:48:54Z | ralph·· | ·· | johnson | 1939-11-02 | N/A | •••-••-9429 | — | ralph.johnson@outlook.com | — | - | - | — | — | null |
| PRV | PRV-27738 | 2026-06-10T01:39:46Z | Julia | — | Carlson | 1963-11-18·· | UHC-47137-69 | — | ·750.645.2381 | null·· | 4096 Central Avenue·· | ·Gilbert | Arizona | 85215 | — | — |
| PRV | PRV-26889 | 2026-04-08T11:51:43Z | BRYAN | — | PEREZ | 1989-08-17 | null | - | NULL | BRYAN.PEREZ@OUTLOOK.COM | 4600 Canyon Road | Tempe | ·AZ | 85234 | - | CHOICE-PLUS-PPO |
| PRV | PRV-22818 | 2026-09-05T16:44:19Z | Danielle | — | Torres | 2003-09-16 | — | N/A | 855.832.4572 | - | 3202 Central Ave | Orlando | FL | NULL | UNKNOWN | — |
| PRV | PRV-29384 | 2026-07-14T05:47:22Z | Dennis | — | Ferguson | 09/28/1954 | — | null | 234.362.6613 | — | 3009 DESERT SKY BLVD·· | Eden Prairie | MN | ·55396 | — | — |
| PRV | PRV-21209 | 2026-07-25T16:54:46Z | Rihcardson, Benjamin | — | — | ·19580417 | UHC-80303-69 | null | +1 560 644 6879 | - | 6480 Indian School Rd | Dallas | TX | 75277 | UNKNOWN | MEDICARE-ADV-B |
| PRV | PRV-22329 | 2026-03-11T23:07:46Z | MARILYN | — | HUNT | 2000-04-25 | UHC-87899-87 | NULL | NULL | null | 2638 Indian School Road | Nashville | TN·· | 37286 | - | - |
| PRV | PRV-25184 | 2026-01-11T04:03:54Z | DENY | — | PARKER | 1972-05-03 | UHC-00717-49 | null | 505-345-0910 | — | UNKNOWN | — | NULL | null | N/A | N/A |
| PRV | PRV-21640 | 2026-02-22T17:05:40Z | brenda | — | marquez | 1974-03-24 | - | — | 707.990.7062 | brenda.marquez@aol.com | 5518 GRAND AVENUE | Las Vegas | NV | 89172 | — | UNKNOWN |
| PRV | PRV-25817 | 2026-07-26T19:07:46Z | Butler, Justin | — | — | Nov 8, 1953 | UHC-04020-20 | — | 610.931.7064 | JUSTIN.BUTLER33@PROTON.ME | 2044 Mountain View Dr | Austin | TX | 78706·· | - | ·MEDICARE-ADV-A |
| PRV | PRV-22056 | 2026-05-02T06:38:22Z | CAROL | R. | CLARK | 01/03/89 | null | null | 2257839 | N/A | 6078 Lincoln Way | Columbus | OH | 43226 | — | UNKNOWN |
| PRV | PRV-20365 | 2026-06-14T23:17:47Z | Mari | — | Carroll | 04/04/00 | — | — | ·765-801-2640 | N/A | 3988 CAMELBACK ROAD | Austin | Texas | 78705-8209 | — | UNKNOWN |
| PRV | PRV-21722 | 2026-05-08T08:51:39Z | Andrea | — | Washington | 01-01-1981 | UHC-84724-16 | — | 650-807-1942 | andrea.washington23@aol.com | 912 PALM DR | Charlotte | NC | ·28285 | — | - |
| PRV | PRV-27878 | 2026-07-10T03:49:41Z | Green, Virginia | — | — | 10/26/1963·· | — | NULL | (229) 204-7499 | N/A | 8700 Sunset Boulevard | SAN DIEGO | CA | 92126 | — | UNKNOWN |
| PRV | PRV-20124 | 2026-08-14T16:00:40Z | JACQUELINE | ···· | CHEN | 1997-08-07 | ···· | - | 7032478775 | jacqueline.chen31@aol.com | 5143 Grand Avenue | LOS ANGELES | CA | — | NULL | UNKNOWN |
| PRV | PRV-24954 | 2026-09-27T23:36:26Z | Mark | — | Mills | Apr 6, 1962 | — | - | (647) 742-3538 | null | null | - | null | — | null | — |
| PRV | PRV-26689 | 2026-07-25T04:04:09Z | Joan | — | Castro·· | 08/20/93 | N/A | UNKNOWN | ·14054368361 | ·N/A | — | N/A | N/A | UNKNOWN | — | N/A |
| PRV | PRV-22335 | 2026-10-12T13:44:59Z | KATHLEEN | — | ·POWELL | 1958-08-22 | NULL | — | (348) 370-6554 | - | 930 FOREST AVENUE | San Diego | CA | 92199-4310 | - | null |
| PRV | PRV-20635 | 2026-01-17T21:22:09Z | ahmed | — | gutierrez | 1938-05-12 | — | •••-••-1105 | 233-672-1836 | NULL | 6178 Forest Avenue | Columbus | oh | 43204 | — | — |
| PRV | PRV-22499 | 2026-10-17T05:27:45Z | KAYLA | D. | ROBINSON | 1970-05-04 | UHC-81146-87 | NULL | 14834625711 | NULL | 9260 Canyon Road | Plano | Texas | 75064 | NULL | — |
| PRV | PRV-27816 | 2026-02-04T18:08:06Z | Mei | — | ·Reeed | Dec 2, 1940 | UHC-67578-17 | N/A | 5438771739 | — | 8628 Forest Avenue | Austin | TX | 78702 | ·UNKNOWN | null |
| PRV | PRV-29430 | 2026-08-08T10:33:04Z | john | — | luna | 1982-01-25 | UHC1702693 | null | 5198173775 | N/A | 2837 Jefferson Avenue | Mesa | AZ | 85294-6051 | UNKNOWN | OPTIONS-PPO |
| PRV | PRV-24979 | 2026-03-06T10:31:41Z | Hoffman, Sandra | — | — | 1969-10-27 | ·UHC-22666-98 | — | 7888898371 | SANDRA.HOFFMAN@AOL.COM | 7038 Desert Sky Blvd | Mesa | AZ | 85253 | — | - |
| PRV | PRV-22646 | 2026-04-26T18:52:01Z | Walter | — | Peterson | 1965-10-07 | - | N/A | — | walter.peterson18@icloud.com | 4110 SPRING STREET | Seattle | WA | 98144 | — | null |
| PRV | PRV-26232 | 2026-08-31T03:51:21Z | Alexis | — | Bowman | 2006-05-09 | UHC-55664-07 | UNKNOWN | (744) 220-2071 | N/A | 4239 Ridge Road | Chandler | AZ | 85258 | ···· | OPTIONS-PPO |
| PRV | PRV-23990 | 2026-08-03T01:53:25Z | Gerald | W | Scott | Aug 24, 1942 | null | UNKNOWN | (396) 454-9640 | N/A | UNKNOWN | N/A | NULL | NULL | null | N/A |
| PRV | PRV-23898 | 2026-02-07T04:10:29Z | evelyn | Y | ·reyes | 1999-09-05 | UHC-54787-27 | null | (692) 756-0326 | ·· | 48 Mountain View Drive | Los Angeles | CA | 90035 | — | NULL·· |
| PRV | PRV-24474 | 2026-09-27T15:03:05Z | Carpenter, Lisa | — | — | 1948-11-22 | ·· | •••-••-4436 | ·null | null | 6990 PINE DR | Tucson | AZ | 85725 | ·null | NAVIGATE-HMO |
| PRV | PRV-21976 | 2026-07-09T01:48:22Z | Barbara | — | Hanson | 1966-06-11 | ·- | NULL | ·846-376-2880 | NULL | 6526 Apache Blvd | Dallas | TX | 75243 | NULL | UNKNOWN |
| PRV | PRV-27721 | 2026-06-26T09:16:04Z | Padilla | — | Cheryl | 1978-04-06 | UNKNOWN | - | (644) 668-6372 | — | 9498 Forest Ave | Tempe | AZ | 85260 | — | — |
| PRV | PRV-28093 | 2026-05-28T21:13:44Z | SANDRA | ···· | PERKINS | 1942-06-25 | N/A | •••-••-0585 | +1 513 418 1620·· | — | 1706 APACHE BLVD | Miami | FL | 33137 | ·· | - |
| PRV | PRV-20126 | 2026-01-18T23:11:38Z | CHARLOTTE | X | NICHOLS | 16-03-1960 | null | — | UNKNOWN | UNKNOWN | 5200 BAYSHORE DR | Tempe | AZ | 85259 | UNKNOWN | OPTIONS-PPO |
| PRV | PRV-28919 | 2026-02-13T04:38:35Z | RAYMOND | — | PETERS | 08/03/72 | — | - | 941-696-2019 | N/A | 2221 Lake View Rd Apt 31 | AUSTIN | TX | 78732 | — | null |
| PRV | PRV-26032 | 2026-06-20T07:08:14Z | Mills, Raymond | — | ·· | 19570517 | UHC-11438-15 | •••-••-4312 | 4986616054 | — | 5768 Forest Ave | Eden Prairie | MN | 55355 | N/A | CORE-HMO |
| PRV | PRV-26256 | 2026-06-16T19:02:17Z | ASHLEY R | — | PETERS | 1941-04-21 | UHC-83509-19 | — | +1 471 439 7647 | ashley.peters77@hotmail.com | 6353 CANYON RD #184 | Columbus | OH | N/A | - | ···· |
| PRV | PRV-27087 | 2026-02-01T09:43:50Z | kathryn | — | holmes | 1939-03-10 | NULL | ···· | 266-852-8374 | UNKNOWN | 8055 Desert Sky Boulevard | Denver | CO | 80259 | — | — |
| PRV | PRV-21730 | 2026-07-10T21:29:58Z | THOMAS | U. | ARMSTRONG | 12/04/93 | UHC-87670-07 | N/A | 19622937747 | — | 1436 Elm Street | Austin | TX | 78709 | — | N/A |
| PRV | PRV-28084 | 2026-08-18T02:27:07Z | marcus | N | hoffman·· | 02-09-1967 | UHC5728021 | — | 262-920-7331 | — | 1328 Desert Sky Boulevard | Tampa | FL | - | UNKNOWN | N/A |
| PRV | PRV-26686 | 2026-01-19T22:46:55Z | Sarah | ···· | McDonald | 05/05/1956 | NULL | — | +1 704 551 8382 | - | 6759 River Road·· | Miami | FL | 33162 | - | — |
| PRV | PRV-26046 | 2026-04-12T21:14:17Z | Ahmed | — | Reid | 12/15/1947 | UHC-00042-25 | ·null | 919-235-2753 | ahmed.reid41@gmail.com | 3342 Grand Avenue | Glendale | AZ | 85326 | - | - |
| PRV | PRV-22289 | 2026-05-20T18:07:49Z | MARI | E | COOK | 04/04/1963 | UHC-93632-88 | •••-••-5794 | (887) 675-2140 | N/A | 3872 Highland Avenue | Atlanta | ·GA | 30353 | N/A | MEDICARE-ADV-A |
| PRV | PRV-22274 | 2026-03-29T11:47:25Z | Mitchell, Harold | D | — | 2005-12-08 | UHC-40615-47·· | •••-••-0134 | — | harold.mitchell@yahoo.com | 5445 UNION STREET | LOS ANGELES | CA | 90049 | - | ···· |
| PRV | PRV-28677 | 2026-05-30T15:32:11Z | AUSTIN | O. | GORDON | Sep 27, 1964 | UHC-50210-62 | — | 387-591-0563 | - | 9313 HIGHLAND AVENUE #505 | JACKSONVILLE | Florida | 32240 | - | null |
| PRV | PRV-20402 | 2026-03-26T13:08:32Z | Joan | — | Scott | 2000-03-05 | - | — | 494-881-3247 | joan.scott11@icloud.com | 4392 Desert Sky Boulevard | Chandler | AZ | 85209 | UNKNOWN·· | UNKNOWN |
| PRV | PRV-25224 | 2026-04-12T14:57:49Z | Adam·· | — | ·Ruiz | 3/19/2002 | ·N/A | UNKNOWN | 5249089026 | NULL | 4394 APACHE BLVD | Charlotte | NC | 28251 | — | — |
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:56.327Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty