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-20393 | 2026-01-15T18:17:36Z | MARIA | H | WARREN | 24-03-1982 | UHC-60350-58 | N/A | (648) 513-9927 | — | 5611 Hillcrest Rd | ·Plano | TX | 75062 | N/A | - |
| PRV | PRV-27250 | 2026-02-14T23:02:00Z | JOYCE | — | SANCHEZ | 10/24/1966 | UHC-16910-09 | — | null | N/A | 2620 MARKET STREET | Las Vegas | ·nv | 89104 | — | UNKNOWN |
| PRV | PRV-26918 | 2026-02-03T13:59:43Z | David | — | Woods·· | 1938-05-26 | UHC8207175 | null | 629-271-2914 | — | 1578 Union St | Nashville | Tennessee | 37211 | null | — |
| PRV | PRV-20441 | 2026-03-16T08:36:42Z | Billy | — | Lopez | 19551008 | null | ···· | 415-397-2520 | billy.lopez@icloud.com | 3626 SAGE COURT Apt 22 | Seattle | Washington | 98125 | — | — |
| PRV | PRV-27621 | 2026-09-03T07:32:05Z | David | — | Guzman | 08/27/1957 | UHC-47294-74 | null | 13904235765 | N/A | 8849 Oak St | Sacramento | CA | — | NULL | — |
| PRV | PRV-21405 | 2026-08-11T12:39:19Z | BRENDA | — | JOHNSTON | 1996-01-24 | ·· | NULL | 18784258724 | ·BRENDA.JOHNSTON56@OUTLOOK.COM | 1490 River Rd | TAMPA | FL | 33656-1886 | N/A | - |
| PRV | PRV-25451 | 2026-09-18T18:32:21Z | JERRY | I | ·PATEL | 1984-07-01·· | UHC-16622-15 | •••-••-7272 | 574.701.0969 | — | 3705 Washington St | Miami | FL | 33171 | - | NULL |
| PRV | PRV-23077 | 2026-09-27T04:40:01Z | ANTHONY | C. | HOLMES | 1952-10-14 | null | •••-••-7460 | +1 816 674 0284 | UNKNOWN | 3009 Sage Ct | DENVER | CO | 80255 | ·NULL | UNKNOWN·· |
| PRV | PRV-28700 | 2026-02-26T23:29:25Z | Elijah | — | Chapman | 19590220 | — | null | +1 217 959 0319 | - | 392 INDIAN SCHOOL ROAD | Atlanta | GA | 30301 | — | null |
| PRV | PRV-20451 | 2026-08-13T02:46:18Z | Aisha | — | Allen | 1938-10-20 | NULL | — | (679) 952-9957 | NULL | ·6490 Baseline Rd | Minneapolis | MN | 55470 | UNKNOWN | UNKNOWN |
| PRV | PRV-27961 | 2026-06-15T10:34:20Z | Shirley | — | Powell | 1949-02-22 | N/A·· | •••-••-1964 | ·null | shirley.powell58@outlook.com | 7038 Main St | Sacramento | CA | 95859 | — | NAVIGATE-HMO |
| PRV | PRV-27947 | 2026-03-06T10:05:40Z | Baker, Michelle | P | — | 1989-05-27 | ·· | - | — | MICHELLE.BAKER18@YAHOO.COM | 3246 Sage Ct | San Diego | CA | 92111 | null | — |
| PRV | PRV-23694 | 2026-01-17T20:21:06Z | Ryan | — | Collins | 1983-09-18 | — | ·- | 543.652.6991·· | — | null | NULL·· | null | null | UNKNOWN | UNKNOWN |
| PRV | PRV-21457 | 2026-03-25T03:50:25Z | Santiago | — | Torres | 1560-19-61 | null·· | •••-••-4559 | 259-624-4074 | - | 5968 Park Pl | Tucson | AZ | — | null | CHOICE-PLUS-PPO |
| PRV | PRV-24077 | 2026-07-06T15:21:57Z | Ann | — | ·Mendez | 02/12/64 | UHC-31441-46 | N/A | +1 316 848 9959 | null | 9039 Hillcrest Rd | Plano·· | TX | 75042 | null | NULL |
| PRV | PRV-23124 | 2026-03-06T05:08:14Z | SAMANTA | — | SANTOS | 10/22/1946 | UHC-62857-33 | - | 330-323-8374 | UNKNOWN | 9217 Market Street | Miami | FL | 33125 | NULL | MEDICARE-ADV-B |
| PRV | PRV-28856 | 2026-02-07T10:15:49Z | Donna | P | Torres | 1957-03-17 | UHC-62265-92 | •••-••-5304 | (687) 810-2635 | ·NULL | 2673 PARK PLACE | Tempe | AZ·· | N/A | - | NAVIGATE-HMO |
| PRV | PRV-25341 | 2026-06-27T23:40:25Z | luis | — | pena | 1963-08-21 | UHC-67941-70 | NULL | (940) 837-7937 | null | 7615 River Rd | SAN DIEGO | CA | 92136 | UNKNOWN | OPTIONS-PPO |
| PRV | PRV-21507 | 2026-09-12T21:06:41Z | MARILYN | ·· | AGUILAR | 1977-06-02 | — | UNKNOWN | 2763483797 | NULL·· | 3638 Bayshore Drive | Dallas | TX | 75200 | — | UNKNOWN |
| PRV | PRV-27583 | 2026-09-05T22:54:49Z | Abigail | — | Morrison | 1950-04-01 | — | — | (397) 420-4494 | N/A | 928 Bayshore Drive | Minneapolis | MN | 55448 | null | - |
| PRV | PRV-29139 | 2026-03-05T09:25:56Z | Tyler | X | Wallace | 1992-09-05 | UHC-31842-98 | null | 3919207989 | ·· | 8122 BROADWAY | MINNEAPOLIS | MN | 55481 | null | MEDICARE-ADV-B |
| PRV | PRV-26615 | 2026-08-20T18:23:43Z | Sharon | — | Campbell | 1956-06-07 | UHC-06772-04 | — | +1 446 504 1093 | SHARON.CAMPBELL@PROTON.ME | 878 Canyon Rd | Tucson | AZ | 85718 | — | NULL·· |
| PRV | PRV-26793 | 2026-04-12T22:40:06Z | Jefffrey | — | Payne | ·11/15/66 | - | — | null | N/A | - | N/A | null | NULL | — | UNKNOWN |
| PRV | PRV-23177 | 2026-06-15T20:07:06Z | Adam | ·C. | Wilson | 5/18/1956 | UHC3958126 | NULL | 615-566-3239·· | ·· | N/A | — | — | — | UNKNOWN | — |
| PRV | PRV-29417 | 2026-08-08T13:40:45Z | Ford, Ronald | — | — | 10/11/1963 | UNKNOWN | N/A | 368-239-1657 | ronald.ford94@gmail.com | 2253 Lake View Rd | Columbus | OH | 43254 | N/A | N/A |
| PRV | PRV-23803 | 2026-08-07T06:36:57Z | Espinoza, Sara·· | — | — | 1997-01-27 | UHC-90159-04 | - | ·7938200340 | N/A | 859 GRAND AVENUE | Tempe | AZ | 85201 | — | OPTIONS-PPO |
| PRV | PRV-23306 | 2026-09-13T15:34:42Z | MARGARET | — | CRUZ | Jan 9, 2000 | ·UHC-61807-71 | — | (791) 963-8151 | margaret.cruz@gmail.com | 9104 Jefferson Avenue #302 | Glendale | AZ | 85353-8279 | null | NULL |
| PRV | PRV-20013 | 2026-05-29T22:41:47Z | olivvia | H | mejia | 01/27/96 | NULL | •••-••-7650 | 8894352 | - | 1802 Forest Ave | ATLANTA | GA | 30389 | - | - |
| PRV | PRV-26422 | 2026-09-11T21:53:29Z | Linda | — | Schultz | 1945-04-21 | UHC-13050-52 | — | (328) 637-5608 | NULL | 4397 Church St | Los Angeles | ca | 90027 | NULL | — |
| PRV | PRV-24929 | 2026-09-11T13:17:55Z | CARLOS | — | FORD | 06/22/73 | UHC-51499-08 | •••-••-8864 | 854.479.6446 | — | 3488 PALM DR | Tucson·· | AZ | 85712 | — | NULL |
| PRV | PRV-29591 | 2026-08-21T13:39:33Z | Sarah | — | Harvey·· | 07-03-1994 | UHC-63568-85 | — | 254-818-1830 | sarah.harvey89@icloud.com | 9589 CHURCH ST | Phoenix | AZ | 85073 | — | — |
| PRV | PRV-23648 | 2026-03-03T04:34:36Z | Barb | Z | Robinson | 03/09/1953 | UHC-20413-79 | •••-••-0450 | (428) 683-6779 | barbara.robinson@hotmail.com | 1839 River Rd | MIAMI | FL | 33164-6728 | UNKNOWN | — |
| PRV | PRV-28342 | 2026-08-06T10:42:22Z | ·Merilyn | N | Vazquez | 1941-05-20 | — | - | 794-882-7844 | marilyn.vazquez@gmail.com | 8011 Meadow Lane | Gilbert | AZ | 85241 | — | — |
| PRV | PRV-22375 | 2026-09-16T20:21:27Z | samul | P | wheeler | 1959-09-23·· | — | — | 554.461.6356 | N/A | 9508 RIDGE ROAD | Fresno | CA | 93758 | null | N/A |
| PRV | PRV-23577 | 2026-03-31T01:19:23Z | Henry·· | — | Gomez | 7/16/1957 | UHC-44840-46 | •••-••-3439 | 5165932301 | UNKNOWN | 8724 Bayshore Dr | SCOTTSDALE | AZ | ·85211 | UNKNOWN | — |
| PRV | PRV-27545 | 2026-06-19T10:03:50Z | Austin | V | Peterson | Dec 7, 1941 | UHC-36139-82 | — | 7891370 | - | 879 River Rd | Glendale·· | AZ | 85300 | null | CHOICE-PLUS-PPO |
| PRV | PRV-22421 | 2026-04-18T10:05:29Z | Elizabeth | F | Lane | ·1943-05-04 | null | •••-••-9714 | 12445185748 | ···· | 9077 Hillcrest Rd | Columbus | Ohio | 43224 | — | OPTIONS-PPO |
| PRV | PRV-20166 | 2026-10-09T22:33:47Z | EMILY | — | SHAW | 2/6/1952 | NULL | UNKNOWN | 738-726-6016 | — | 1742 INDIAN SCHOOL RD | Nashville | TN | 37253 | UNKNOWN | CORE-HMO |
| PRV | PRV-25285 | 2026-03-03T19:35:26Z | mike | S | lynch | 03/05/40 | UHC-82219-84 | ·null | 832.549.4410 | UNKNOWN | 4883 Park Pl | Tempe | AZ | 85202 | ···· | - |
| PRV | PRV-22066 | 2026-06-01T07:20:03Z | Wagner, Heather | P | — | 1991-12-14 | UHC-68131-47 | •••-••-5313 | (447) 347-0816 | - | ·4720 Canyon Road | Miami | FL | 33174 | ·· | null |
| PRV | PRV-27037 | 2026-01-06T22:13:30Z | JOSE | — | NELSON | 01/14/86 | UHC-60100-97 | ·· | 19797179244 | JOSE.NELSON@AOL.COM | 2966 Grand Ave | NASHVILLE | TN | 37272 | - | — |
| PRV | PRV-22602 | 2026-07-16T11:13:48Z | bruce | ···· | fowler | 1937-05-08 | - | UNKNOWN | ·389.763.6212 | bruce.fowler@gmail.com | UNKNOWN | — | — | — | null | — |
| PRV | PRV-20733 | 2026-02-10T08:18:55Z | julia | — | ortega | — | UNKNOWN | N/A | (362) 382-4545 | — | 9413 JEFFERSON AVENUE | Denver | ·CO | 80281 | N/A | — |
| PRV | PRV-23448 | 2026-05-08T06:43:36Z | RUTH | ···· | HOWARD | ·1974-05-10 | UHC-24377-82 | — | 954.544.5065 | — | 8178 Willow Court | NASHVILLE | TN | 37243 | UNKNOWN | N/A |
| PRV | PRV-20022 | 2026-01-13T12:56:13Z | Joyce | A | Contreras | 7/3/1966 | UHC-09400-72 | UNKNOWN | 6224547008 | ···· | 2980 PARK PL | Mesa | Arizona | — | — | MEDICARE-ADV-B |
| PRV | PRV-29072 | 2026-06-11T20:17:02Z | Lauren | — | Snyder | Aug 1, 1956 | N/A | •••-••-8593 | 6469188966 | null·· | 4984 LINCOLN WAY | Chandler | az | 85266 | - | OPTIONS-PPO |
| PRV | PRV-25071 | 2026-09-01T23:09:46Z | SUSAN | — | JAKKSON | 1997-01-05 | - | •••-••-6347 | 867-802-0946 | susan.jackson@yahoo.com | 4616 Sunset Blvd | Chandler | Arizona | 85290 | N/A | N/A |
| PRV | PRV-21688 | 2026-03-05T06:05:34Z | Amanda·· | — | Larson | 1946-09-26 | — | •••-••-8352 | (238) 476-6490 | — | 1439 DESERT SKY BOULEVARD | Tempe | AZ | 85258 | N/A | null |
| PRV | PRV-21629 | 2026-04-04T14:48:39Z | JOSHUA | — | JOHNSTON | 11/19/2000 | — | null | 7685883071 | NULL | 6768 Jefferson Ave | Eden Prairie | MN | 55369-2134 | null | N/A |
| PRV | PRV-21229 | 2026-04-18T06:54:01Z | Daniel | O | Duncan | 19380721·· | — | ···· | 742.524.3732 | N/A | 6999 CANYON ROAD | Houston | TX | 77066-9816 | 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:56.297Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty