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-28344 | 2026-01-16T06:46:48Z | Shirley, Day | — | ···· | 1939-05-17 | - | - | N/A | ·· | 8550 Cedar Ln | Plano | TX | 75097 | — | OPTIONS-PPO |
| PRV | PRV-29135 | 2026-01-11T05:57:17Z | Gonzales, Josh | — | — | 2001-03-06 | UNKNOWN | •••-••-7577 | 4668332251 | joshua.gonzales12@proton.me | 4712 Sunset Blvd | Phoenix | AZ | 85052 | — | null |
| PRV | PRV-27717 | 2026-01-16T15:11:46Z | KEVIN | L | TUCKER | 1951-06-09 | ·UHC0135875 | — | 323-521-3877 | UNKNOWN | 1128 HARBOR BLVD | Columbus | OH | 43242 | — | N/A |
| PRV | PRV-22623 | 2026-07-30T18:07:50Z | ·Amanda | — | Reynolds | ·04/11/1981 | UNKNOWN | null | 13262891011 | amanda.reynolds@yahoo.com | 7514 Ocean Ave #187 | TUCSON | AZ | 85725-7180 | — | UNKNOWN |
| PRV | PRV-24594 | 2026-01-10T10:29:54Z | ·George | — | Owens | 19380426 | null | null·· | 601.658.6517 | — | 491 Union St | Glendale | az | 85322-4814 | null | ·- |
| PRV | PRV-28092 | 2026-08-15T03:18:37Z | Joyce | — | Chapman | 2007-02-23 | UHC-27758-57 | — | 3514492477 | ·· | 7447 Canyon Rd | Tempe | AZ | 85222-8466 | ·null | UNKNOWN |
| PRV | PRV-24862 | 2026-09-18T10:55:22Z | Lori | — | Walsh | 1995-11-06 | ···· | — | 830.300.2309·· | null | 3222 MEADOW LN | Dallas | TX | 75264 | null | — |
| PRV | PRV-20171 | 2026-05-09T17:44:30Z | Bell, Roger | — | — | ·1986-11-02 | ·UHC-49797-35 | - | 9578753466 | roger.bell4@hotmail.com·· | UNKNOWN | null | NULL | N/A | — | NULL |
| PRV | PRV-25766 | 2026-08-26T23:14:00Z | Evelyn | — | Vargas | 1969-01-18 | UHC-34654-11 | •••-••-6042 | 548.494.3332 | EVELYN.VARGAS@ICLOUD.COM | 9477 Forest Avenue #952 | Plano | tx | 75085 | N/A | — |
| PRV | PRV-26928 | 2026-03-10T18:25:22Z | joe | — | salazar | 1994-01-16 | UHC-89970-58 | NULL | 873-275-9175 | joe.salazar34@gmail.com | 2559 Mountain View Drive | Dallas | TX·· | 75260 | - | null |
| PRV | PRV-21314 | 2026-01-27T16:12:08Z | priya | — | warren | Jun 19, 1958 | UHC-43262-29 | — | 933-386-8605 | — | 7010 BAYSHORE DRIVE | Tampa | FL | 33653 | UNKNOWN | ·CHOICE-PLUS-PPO |
| PRV | PRV-27409 | 2026-06-08T11:02:49Z | Gary | — | Delgado | 1945-02-08 | null | — | — | N/A | 8879 Valley View Dr | Fresno | CA | 93767-7530 | — | ·UNKNOWN |
| PRV | PRV-22915 | 2026-04-09T12:14:37Z | DEBRA | — | ROJAS | ·15-07-1941 | UHC4171420 | N/A | 781-756-5985 | - | 2800 Sage Ct | LAS VEGAS | NV | 89182-2889 | - | ·- |
| PRV | PRV-23623 | 2026-03-30T10:34:12Z | James, Camila | — | ·· | 05/03/46 | ···· | - | 19037463637 | null | 6031 Oak Street | Eden Prairie | MN·· | 55354 | - | NULL |
| PRV | PRV-21148 | 2026-09-25T02:33:19Z | Lynch, Danielle | — | — | 2000-02-09 | UHC-65454-97 | — | NULL | danielle.lynch26@proton.me | 1905 ELM STREET | Minneapolis | ·MN | 55432 | ···· | null |
| PRV | PRV-28750 | 2026-05-05T16:51:09Z | Kyle | — | Contreras | 1962-06-10 | UHC-17396-44 | •••-••-2510 | 536-896-5463 | UNKNOWN | ·7575 Canyon Rd | Denver | CO | 80251-8023 | — | NULL |
| PRV | PRV-20919 | 2026-02-17T18:52:25Z | Nancy | — | Brooks | 2002-03-20·· | — | null | NULL | nancy.brooks8@gmail.com | null | - | — | N/A | — | MEDICARE-ADV-B |
| PRV | PRV-23851 | 2026-07-08T23:30:26Z | Laura | — | Gonzalez | 2003-10-20 | UNKNOWN | N/A | 8575461907 | — | 4629 SPRING STREET | Scottsdale | AZ | UNKNOWN | UNKNOWN | SELECT-EPO |
| PRV | PRV-25671 | 2026-09-19T17:33:45Z | ·FATIMA | — | BRYANT | 1992-08-14 | UHC-41018-08 | UNKNOWN | +1 737 278 1105 | NULL | 9517 Lincoln Way | Sacramento | CA | 95858 | — | - |
| PRV | PRV-28364 | 2026-02-04T17:02:30Z | NICOLE | — | NUNEZ | 12-08-1991 | — | ·null | 14878063447 | — | 1464 CEDAR LN·· | ·AUSTIN | TX | 78747 | — | NULL |
| PRV | PRV-28071 | 2026-06-18T17:22:19Z | ·Douglas | — | Ortegga | 1991-01-22 | UHC-67942-79 | ·- | (209) 231-5147 | douglas.ortega@proton.me | 3035 Baseline Rd | Charlotte | NC | 28267-9338 | NULL | NULL |
| PRV | PRV-20619 | 2026-03-04T21:35:05Z | Gray, Anthony | — | — | 1947-05-21 | ·UHC-32028-55 | — | 4984169169 | — | 3721 PARK PLACE | Miami | FL·· | 33102 | — | null |
| PRV | PRV-29541 | 2026-08-21T06:41:39Z | Arnold, Carolyn | C | — | 1961-01-28 | - | •••-••-8246 | 9093511403 | carolyn.arnold86@aol.com | 5629 BROADWAY | Dallas | TX | 75254 | ·N/A | CHOICE-PLUS-PPO |
| PRV | PRV-29428 | 2026-03-26T22:51:01Z | MARTHA | — | LUNA | 1981-06-14 | null | — | 874-418-2831 | - | 2310 Grand Ave | SAN DIEGO | CA | 92144 | - | — |
| PRV | PRV-27174 | 2026-03-30T18:11:15Z | JOSEPH | O. | RICHARDS | 8/11/1959 | null·· | - | 478-882-7316 | — | 821 Broadway | Glendale | AZ | 85333 | - | - |
| PRV | PRV-22595 | 2026-07-01T21:23:11Z | Jacob | F. | Cruz | Jul 9, 1988 | UHC-04690-02 | - | 9257108550 | — | 7937 LINCOLN WAY | San Diego·· | CA | 92162 | ···· | — |
| PRV | PRV-21690 | 2026-10-09T00:04:09Z | ·ADAM | — | WRIGHT | 07/04/44 | N/A | null | (290) 867-4394 | - | 7199 Sunset Boulevard | Gilbert | AZ | — | - | null·· |
| PRV | PRV-21321 | 2026-01-11T08:38:04Z | Jerry | — | Perry | 1994-05-25 | UHC-81449-36 | NULL | (747) 821-9402 | ·· | 6462 Mesa Drive | Eden Prairie | MN | 55398-1530 | — | UNKNOWN |
| PRV | PRV-26438 | 2026-10-07T02:54:40Z | zachary | — | robertson | 19630617 | UHC-51782-76 | N/A | (336) 588-1947 | - | 9048 JEFFERSON AVENUE | Tucson | AZ | 85731 | - | — |
| PRV | PRV-24741 | 2026-03-13T15:58:45Z | jennifer | — | hayse | 2004-01-09 | UHC-67865-24 | N/A | +1 681 898 2160 | ·· | 314 MAPLE AVENUE | PHOENIX | AZ | 85021 | — | — |
| PRV | PRV-24065 | 2026-08-11T19:37:34Z | ALLEN | — | HAROLD | 1982-05-24·· | — | •••-••-3177 | (746) 608-7016 | HAROLD.ALLEN50@PROTON.ME | UNKNOWN | — | null | — | — | NULL |
| PRV | PRV-28331 | 2026-08-03T07:12:13Z | JEREMY | — | MASON | 1962-12-28 | UHC-67531-66 | NULL | +1 815 398 1570 | N/A | 4853 Apache Blvd | Jacksonville | FL | 32253 | - | null |
| PRV | PRV-26684 | 2026-08-06T10:49:24Z | Judith | — | Simmons | Jul 16, 1980 | - | NULL | NULL | NULL | 8104 Maple Ave | Fresno | CA | 93728-7458 | N/A | N/A |
| PRV | PRV-24801 | 2026-02-06T21:41:27Z | David | V | Davis | 4/5/1948 | UHC-44621-94 | •••-••-9710 | NULL | david.davis27@gmail.com | 5233 Maple Avenue | Mesa | ·AZ | 85203 | NULL | UNKNOWN |
| PRV | PRV-27306 | 2026-06-02T22:34:13Z | Hiroshi | — | Brooks | 15-08-1990 | UHC-65032-33 | UNKNOWN | (438) 573-7130 | NULL | 741 Canyon Rd | Nashville | ·TN | 37232 | — | — |
| PRV | PRV-24833 | 2026-10-04T05:39:04Z | ·Simmons, Luis | B. | — | 2003-04-13 | ·UHC-91105-47 | null | +1 916 715 3948 | — | - | — | — | - | UNKNOWN | null |
| PRV | PRV-20493 | 2026-01-05T14:54:47Z | Joan | Z | Peters | 1971-09-12 | UHC-81748-15 | NULL | 295-582-3386 | JOAN.PETERS@HOTMAIL.COM | 2879 Camelback Rd | EDEN PRAIRIE | MN | 55363 | - | — |
| PRV | PRV-23787 | 2026-09-02T14:08:20Z | Catherine | L | Peters | 04/22/1960 | UHC-57239-93 | •••-••-7881 | 6722681200 | NULL | 387 Park Pl #939 | Tucson | AZ·· | 85776 | UNKNOWN | null |
| PRV | PRV-27074 | 2026-09-13T23:18:43Z | Denise | ·Z | Jackson | 07-03-1949 | ·- | ·· | 6568391082 | — | 3077 Valley View Drive | Tampa | FL | 33626-7259 | NULL | ·NULL |
| PRV | PRV-24318 | 2026-07-03T10:29:57Z | Mary | — | Young | 07/16/1996 | — | - | (549) 664-6553 | - | 4728 Market Street | San Antonio | TX | 78237-8146 | - | null |
| PRV | PRV-29475 | 2026-07-21T11:53:25Z | Paul | — | Nguyen | 9189-02-24 | N/A | — | (770) 621-0767 | null | NULL | NULL | UNKNOWN | — | null | UNKNOWN·· |
| PRV | PRV-22204 | 2026-01-26T12:04:20Z | jordan | W | cooper | 05-09-1966 | UHC-56687-76 | N/A | +1 761 212 6816 | jordan.cooper@gmail.com | 2256 APACHE BLVD | HOUSTON | TX | ·77030 | - | NULL |
| PRV | PRV-21253 | 2026-06-30T23:39:35Z | ALEXIS | ·· | EDWARDS | 1976-03-25 | — | NULL | 286.397.3708 | — | 561 Indian School Road | SAN ANTONIO | TX | 78201 | N/A | CHOICE-PLUS-PPO |
| PRV | PRV-27927 | 2026-10-07T23:27:25Z | JOSE | — | MENDEZ | 1975-02-15 | N/A·· | ·null | 16693119260 | — | 2541 Canyon Road | Orlando | FL | 32862-2040 | null | — |
| PRV | PRV-26628 | 2026-01-17T15:25:48Z | Murphy | — | Elijah | 1945-06-24 | UHC-06509-69 | •••-••-1508 | 15346230056 | NULL | 8467 Union St | Plano | TX | 75041 | NULL | null |
| PRV | PRV-22518 | 2026-09-29T11:35:05Z | LARRY | — | SPENCER | 1961-04-01·· | uhc-08518-76 | UNKNOWN | N/A | LARRY.SPENCER@AOL.COM | 3145 Sunset Blvd | Austin | TX | 78795 | — | null |
| PRV | PRV-20780 | 2026-02-03T08:16:38Z | TERESA | — | FREEMAN | 1960-04-11 | UHC-86980-83 | — | UNKNOWN | TERESA.FREEMAN@YAHOO.COM·· | 6947 ELM STREET | MIAMI | FL | 33116 | null | N/A |
| PRV | PRV-21920 | 2026-03-13T13:17:57Z | Timothy | — | Ortiz | 11/19/2004 | ·UHC-17817-46 | - | (390) 314-1097 | TIMOTHY.ORTIZ24@GMAIL.COM | 3613 BAYSHORE DR | Nashville | TN | 37264 | — | MEDICARE-ADV-A |
| PRV | PRV-26205 | 2026-10-12T06:20:26Z | SARA | — | POWELL | 20050203 | - | NULL | (459) 572-9223 | N/A | 3039 Sage Ct | TUCSON | AZ | 85799 | NULL | CORE-HMO·· |
| PRV | PRV-23248 | 2026-04-04T08:59:31Z | Betty | — | Wood | 1950-04-12 | UHC-68387-04 | — | 558-980-6735 | UNKNOWN | 7551 Lincoln Way | SEATTLE | WA | 98176 | — | - |
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:49.099Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty