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-23369 | 2026-10-12T05:23:45Z | Grace | — | Guzman | 1982-12-19 | UHC-39682-17 | — | (756) 643-1855 | — | 3690 Central Ave Apt 11 | ·San Diego | CA | 92192 | — | N/A |
| PRV | PRV-28836 | 2026-03-11T16:31:26Z | ELIJAAH | K | SANTIAGO | null | UHC-99665-89 | •••-••-0591 | — | — | 5365 Hillcrest Rd | Fresno | CA | 93798 | - | — |
| PRV | PRV-21207 | 2026-01-19T03:10:08Z | BENJAMIN | — | RICHARDSON | 1958-04-17 | - | NULL | 5606446879 | — | 6480 Indian School Rd Apt 15 | Dallas | TX | 75277 | NULL | NULL |
| PRV | PRV-27924 | 2026-06-18T03:39:05Z | JORDAN | — | HERRERA | 1994-01-02 | UHC-56597-74 | NULL | 923-869-7845 | null | 8958 Indian School Rd | Phoenix·· | AZ·· | 85053 | — | — |
| PRV | PRV-27492 | 2026-04-21T02:36:01Z | Denny | — | Daniels | Feb 10, 1972 | N/A | N/A | 864.468.5863 | — | - | — | — | — | NULL | NAVIGATE-HMO |
| PRV | PRV-25482 | 2026-08-16T10:15:12Z | sara | — | sanders | 10/03/84 | UNKNOWN | — | 382-317-8732·· | UNKNOWN | 2217 Grand Ave | Austin·· | tx | 78701 | — | CHOICE-PLUS-PPO |
| PRV | PRV-27243 | 2026-01-17T01:32:45Z | Catherine | — | Matthews | 1998-08-27 | UHC-17578-78 | — | 270-276-8681 | N/A | 2400 OCEAN AVE | San Diego | CA | 92146 | null | — |
| PRV | PRV-28981 | 2026-06-08T07:37:59Z | GEORGE | — | WILLIAMSON | ·1953-03-23 | - | null | (315) 250-9653 | NULL | 2608 Spring Street | SACRAMENTO·· | CA | 95879 | N/A | — |
| PRV | PRV-24304 | 2026-01-05T05:07:25Z | Evelyn | — | Burns | ·Oct 17, 1991 | null | •••-••-7600 | 728-471-9453 | ···· | 4461 SPRING ST | Tampa | FL | 33671 | NULL | OPTIONS-PPO |
| PRV | PRV-26854 | 2026-09-05T20:26:11Z | Sam | — | Adams | ·1960-07-20 | UHC-62298-66 | UNKNOWN | +1 405 815 0327 | - | 2770 Canyon Road | Columbus | OH | 43226 | — | SELECT-EPO |
| PRV | PRV-28973 | 2026-04-25T00:31:27Z | Evans, Christopher | — | — | 1905-10-23 | - | null | 843-963-3499 | NULL | 9894 Maple Avenue | Tucson | AZ | 85730-1308 | NULL | CORE-HMO |
| PRV | PRV-26412 | 2026-01-18T22:56:50Z | ALAN | G. | BRADLEY | 09/10/71 | uhc-99205-78·· | •••-••-3172 | — | alan.bradley2@hotmail.com | 5458 Oak Street | Tampa | FL | 33633-0273·· | UNKNOWN | UNKNOWN |
| PRV | PRV-24029 | 2026-03-14T07:16:10Z | Mary·· | — | Pena | 10/04/1964 | UHC-87810-27·· | •••-••-0138 | 320-687-5443 | — | 5221 River Rd | Seattle | WA | 98184 | — | N/A |
| PRV | PRV-28752 | 2026-02-23T05:41:48Z | Janet | — | Carroll | 1938-02-10 | UHC-53190-20 | •••-••-1602 | (532) 621-6137 | ·null | 6292 Union Street Apt 6 | Orlando | FL | 32810 | — | MEDICARE-ADV-A |
| PRV | PRV-20222 | 2026-08-10T21:22:45Z | pena | O | janet | 1944-10-07 | - | - | 6548050 | — | 3537 VALLEY VIEW DRIVE | Minneapolis | MN | 55462 | — | NULL·· |
| PRV | PRV-26766 | 2026-08-31T21:07:04Z | Randy | — | Stweart | 3/5/1955 | — | — | 2529828935 | NULL | 8689 GRAND AVE | San Diego | CA | 92137 | null | — |
| PRV | PRV-26188 | 2026-01-03T08:31:25Z | Montgomery, Mariana·· | — | — | ·1998-05-26 | UHC-54015-86 | UNKNOWN | 8128725036 | MARIANA.MONTGOMERY@PROTON.ME | 5809 Baseline Rd | Fresno | California | 93715 | NULL | CORE-HMO |
| PRV | PRV-23915 | 2026-10-13T23:47:26Z | Adam | — | McCoy | 07-08-1967 | UHC-56750-62 | •••-••-1725 | ·255-270-9479 | adam.mccoy74@outlook.com | — | - | — | — | ·- | -·· |
| PRV | PRV-27194 | 2026-05-02T23:53:52Z | Ahmed | X | Mejia | 1950-08-22 | UHC-77938-49·· | ·· | +1 662 841 9650 | - | ·8436 Indian School Road | San Diego | CA | 92198 | — | — |
| PRV | PRV-24421 | 2026-05-01T10:05:55Z | Bradley | — | Vasquez | 2002-07-21 | UHC-93444-31 | UNKNOWN | 898-255-1819 | BRADLEY.VASQUEZ64@PROTON.ME | 8359 MARKET STREET Apt 29 | Tampa | ·Florida | 33607 | NULL | — |
| PRV | PRV-20608 | 2026-06-27T22:59:50Z | Michael | Z | Boyd | 07/23/1992 | ·· | - | 13975431757 | UNKNOWN | 5328 Ridge Rd | San Antonio·· | TX | — | — | UNKNOWN |
| PRV | PRV-22600 | 2026-03-18T18:41:09Z | ·ANN | — | PATEL | 1977-06-01 | null | - | 336-910-9289 | — | 7149 Bayshore Dr | Orlando | FL | 32839 | ···· | N/A |
| PRV | PRV-20480 | 2026-06-10T00:29:52Z | SANTIAGO | — | RIVERA | 05-02-1951 | N/A | null·· | 427-656-7861 | santiago.rivera11@icloud.com | 3442 Camelback Rd | MINNEAPOLIS·· | MN | 55443 | null | - |
| PRV | PRV-24869 | 2026-09-24T11:24:40Z | Beverly | — | ·Aguilar | ·19920415 | UHC-96753-34 | N/A | 889-372-6618 | N/A | 5561 Main St | Minneapolis | MN | 55480 | UNKNOWN | — |
| PRV | PRV-28124 | 2026-01-16T09:49:49Z | ·JOHNNY | — | LYNCH | Mar 2, 1973 | UHC9815944 | null | 9537713252 | — | 4664 Maple Ave | Tempe | AZ | 85211 | UNKNOWN | - |
| PRV | PRV-23186 | 2026-07-05T22:34:33Z | Keith | — | Palmer·· | Feb 21, 1984 | — | null | 680.692.7523 | UNKNOWN | 7266 Meadow Ln | Columbus | OH | 43211 | — | CORE-HMO |
| PRV | PRV-24937 | 2026-06-12T08:10:35Z | VICTTORIA | C. | JOHNSTON | 07/22/57 | UHC-39376-18 | UNKNOWN | UNKNOWN | — | 9122 Central Ave | Sacramento | CA | 95855 | — | OPTIONS-PPO |
| PRV | PRV-23196 | 2026-06-16T08:39:27Z | Amy | — | Woods | 2006-11-16 | UHC-17540-27 | — | 619-839-9766 | N/A | 3130 Cedar Lane | Seattle | WA | 98142 | UNKNOWN | — |
| PRV | PRV-23853 | 2026-06-29T18:07:15Z | Grace | S | Maldonado | 1945-01-19 | UHC-96133-18 | •••-••-5570 | ·19109435868 | grace.maldonado@gmail.com | 902 Lincoln Way | Orlando | FL | 32827-9082 | — | CHOICE-PLUS-PPO |
| PRV | PRV-25914 | 2026-10-16T12:43:02Z | WAYNE | ·· | DAVIS | 19560525 | UHC6727896 | ·null | 2448415214 | UNKNOWN | 4681 Oak St | Eden Prairie·· | ·MN | 55309 | — | NULL |
| PRV | PRV-28801 | 2026-10-07T01:32:31Z | Rebecca | — | Chavez | 1970-11-09 | UHC-48366-81 | •••-••-5520 | — | rebecca.chavez@hotmail.com | — | — | UNKNOWN | — | — | — |
| PRV | PRV-27033 | 2026-08-07T22:06:12Z | Billy | ···· | Brown | 04-12-1977 | UHC-09978-13 | •••-••-8684 | — | UNKNOWN | 870 Hillcrest Rd | Fresno | CA | 93709-2660 | null | ·OPTIONS-PPO |
| PRV | PRV-29479 | 2026-01-05T12:19:24Z | Martha | — | Williamson | 1995-08-06 | N/A | NULL | 5406969099 | martha.williamson@gmail.com | 364 Broadway | Plano | Texas | 75094 | — | — |
| PRV | PRV-24160 | 2026-07-23T04:58:56Z | BRYAN | ·· | GRAHAM | 4/8/1952 | — | •••-••-7202 | 773-355-9998 | null | 238 Jefferson Ave | San Antonio | TX | 78204 | NULL | — |
| PRV | PRV-23829 | 2026-04-30T21:49:20Z | JACQUELINE | — | LITTLE | 1987-12-24·· | — | — | ·406-943-4164 | — | 8051 Camelback Rd | Eden Prairie | MN | 55303-4083 | null | MEDICARE-ADV-A |
| PRV | PRV-20776 | 2026-08-11T06:45:05Z | TERRY | — | ELLIOTT | 7/19/1980 | UHC-19456-25 | •••-••-1302 | 6812696009 | null | 5002 Palm Dr | Fresno | CA | 93752 | — | — |
| PRV | PRV-26504 | 2026-09-23T00:32:04Z | Kim, Daniel | — | — | 1958-09-25 | NULL | N/A | 15024941594 | UNKNOWN | 3734 MESA DR | Nashville | tn | 37231 | null | UNKNOWN |
| PRV | PRV-25755 | 2026-05-19T08:22:33Z | OLIVIA | — | FRANKLIN | 2003-08-18 | UHC-89046-15 | N/A | +1 230 830 4907 | — | 2718 Palm Drive | Seattle | WA | 98101 | N/A | — |
| PRV | PRV-20226 | 2026-02-24T22:59:50Z | JOE | J. | WASHINGTON | 1952-07-17 | UHC-56815-47 | null | (619) 664-3976 | N/A | 6560 Market St | GLENDALE | ·AZ | 85325-2208 | — | NULL |
| PRV | PRV-26321 | 2026-02-16T15:45:02Z | keith | — | schultz | 1940-01-23 | UHC-59799-84 | NULL | N/A | KEITH.SCHULTZ70@HOTMAIL.COM·· | 3791 Sunset Boulevard | SEATTLE | WA | 98127 | NULL | CHOICE-PLUS-PPO |
| PRV | PRV-23571 | 2026-01-26T07:35:23Z | Deborah | — | Gilbert | 05/12/1966 | UNKNOWN | — | N/A·· | deborah.gilbert41@yahoo.com | 5353 Church St·· | Minneapolis | MN | — | - | — |
| PRV | PRV-27680 | 2026-01-19T11:53:55Z | logan | T. | snyder | 19660802 | UHC-28743-44 | UNKNOWN | 750-494-7853 | N/A | 6657 JEFFERSON AVENUE | Columbus | OH | NULL | N/A | — |
| PRV | PRV-28095 | 2026-02-06T21:38:23Z | Banks, Jordan | — | — | 1980-04-06·· | ···· | — | 203.582.5625 | UNKNOWN | 8932 Elm Street | Charlotte | NC | 28211 | UNKNOWN | CHOICE-PLUS-PPO |
| PRV | PRV-29508 | 2026-04-25T21:20:57Z | Lisa | — | Cark | 09/26/02 | UHC-57585-76 | •••-••-5168 | (469) 399-7787 | UNKNOWN | 3910 PALM DR | Columbus | OH | 43285 | null | NAVIGATE-HMO |
| PRV | PRV-28840 | 2026-04-22T14:19:09Z | chris | ···· | ortega | 1970-12-12 | UHC-45995-18 | — | 792-376-3304 | christopher.ortega@yahoo.com | 3105 OAK ST | CHARLOTTE | ·NC | 28278 | UNKNOWN | — |
| PRV | PRV-20205 | 2026-04-29T04:34:40Z | BRANDON | — | JACKSON | 1938-03-22 | ·NULL | — | (888) 221-4017 | NULL | UNKNOWN | NULL | N/A | N/A | - | CHOICE-PLUS-PPO |
| PRV | PRV-27489 | 2026-06-14T02:25:16Z | Patrick | — | Gilbert | 1968-05-26·· | UHC-38235-14 | — | (781) 705-1727 | — | 9878 INDIAN SCHOOL RD | Atlanta | GA | 30300 | — | — |
| PRV | PRV-27658 | 2026-10-06T18:53:58Z | Lucia | ·· | Alvarado | 2005-01-16 | — | •••-••-2754 | (646) 578-4325 | - | 1364 Palm Drive | Jacksonville | ·FL | null | N/A | null |
| PRV | PRV-25287 | 2026-05-30T12:59:40Z | JOHN·· | B. | HERNANDEZ | 2001-09-16 | — | — | 977-223-0676·· | UNKNOWN | 5504 Desert Sky Boulevard | Denver | CO | 80203 | N/A | — |
| PRV | PRV-23706 | 2026-10-15T11:37:45Z | George | M | Padilla | 2005-01-20 | — | •••-••-0407 | N/A | — | 7600 Valley View Dr | CHARLOTTE | NC·· | 28274 | - | N/A |
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.075Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty