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-21121 | 2026-06-20T20:28:26Z | ANDY | — | RIVERA | 06/13/1983 | UHC4228166 | •••-••-5124 | 9027222780 | — | ·3452 Broadway | NASHVILLE | ·TN | N/A | — | NULL |
| PRV | PRV-25657 | 2026-06-07T01:58:32Z | Gonzales, Kelly | — | — | 1965-12-21 | ···· | — | 870-526-2186 | kelly.gonzales36@yahoo.com | 4772 FOREST AVENUE | PLANO | TX | 75014 | N/A | OPTIONS-PPO |
| PRV | PRV-25244 | 2026-01-28T19:34:12Z | TIMOTHY·· | — | GORDON·· | 1967-03-04 | UHC-69308-48 | - | 499-346-4992 | timothy.gordon36@outlook.com | 3260 UNION STREET | Phoenix | AZ | 85005 | null | N/A |
| PRV | PRV-23821 | 2026-05-22T21:52:24Z | NATHAN | — | FERNANDEZ | 1993-03-22 | UHC-35679-26 | NULL | 5919923960 | UNKNOWN | 5278 River Road | Jacksonville | FL | 32247 | UNKNOWN | NULL |
| PRV | PRV-23423 | 2026-07-06T20:59:00Z | Kevin | — | Clark | 1986-09-02 | UHC-87862-60 | N/A | 495.561.3118 | NULL | 4402 Mesa Dr | Atlanta | GA | 30336 | UNKNOWN | — |
| PRV | PRV-29458 | 2026-03-23T14:20:26Z | teresa | — | woods | 09/17/1968 | NULL | NULL | — | teresa.woods70@outlook.com | 4912 HILLCREST RD | Chandler | AZ | 85221 | — | ·N/A |
| PRV | PRV-20320 | 2026-03-03T21:18:04Z | Maria | E. | Harrison | 1998-01-02 | UHC-00391-32 | •••-••-5727 | 747-476-6332 | UNKNOWN | 2840 OAK STREET | Columbus | Ohio | 43297 | UNKNOWN | — |
| PRV | PRV-24524 | 2026-06-19T14:17:18Z | SOFIA | — | LOPAZ | 1997-04-09 | null | - | (667) 277-2546 | SOFIA.LOPEZ@HOTMAIL.COM | 5094 Mesa Dr Apt 23 | Gilbert·· | AZ | 85254-5691 | null | OPTIONS-PPO |
| PRV | PRV-20729 | 2026-02-01T19:28:05Z | Nunez, Lauren | ···· | — | 1976-04-15·· | UHC-81063-83 | •••-••-5332 | 587-662-3640 | NULL | 8700 Oak Street | SACRAMENTO | CA | 95864 | ···· | N/A |
| PRV | PRV-22904 | 2026-09-18T04:59:01Z | Lisa·· | — | Hayes | 1997-11-16 | UHC-48433-58 | — | (613) 232-7411 | lisa.hayes@outlook.com | ·3266 MOUNTAIN VIEW DR | Plano | TX | ·75053 | null | NAVIGATE-HMO |
| PRV | PRV-24947 | 2026-08-25T15:24:10Z | ·Albert | ·· | Stephens | 4/17/1949 | null | null | (267) 668-2075 | albert.stephens75@hotmail.com | 2513 LAKE VIEW RD #406 | Seattle | WA | 98163 | null | CORE-HMO |
| PRV | PRV-22847 | 2026-06-30T02:44:03Z | Joshua | M | Diaz | 1983-01-17 | N/A | •••-••-7169 | 5379681224 | UNKNOWN | 5119 Bayshore Dr | Phoenix·· | AZ | null | - | — |
| PRV | PRV-28122 | 2026-05-07T15:53:03Z | Sarah | N. | Washington | 02-02-1975 | UHC-90115-28 | NULL·· | 3136396837 | — | 7915 Meadow Ln | ·Fresno | ·California | null·· | - | - |
| PRV | PRV-24782 | 2026-06-10T11:35:34Z | DANIELLE | — | ·KING | 1982-05-23 | null | UNKNOWN | 698-443-7672 | danielle.king55@yahoo.com | 6050 PARK PL | Fresno | CA | 93707 | N/A | ·N/A |
| PRV | PRV-21443 | 2026-05-31T12:52:42Z | — | — | — | ·05/01/1990 | UNKNOWN | — | 17419104928 | nancy.tran83@proton.me | 2622 Palm Drive·· | SCOTTSDALE | AZ | — | NULL | - |
| PRV | PRV-27335 | 2026-05-04T01:41:37Z | THOMAS·· | N | SANCHEZ | 1943-03-28 | N/A | N/A | 5487895912 | ·· | — | NULL | - | null | null | MEDICARE-ADV-B |
| PRV | PRV-22360 | 2026-02-27T06:53:47Z | ryan | — | howell | 1982-04-25 | UHC9114866 | •••-••-4068 | UNKNOWN·· | — | 4377 FOREST AVENUE | Miami | Florida | 33176·· | null | — |
| PRV | PRV-26942 | 2026-09-25T12:44:31Z | ·harold | — | franklin | 19800223 | UHC-93681-23 | N/A | +1 870 553 9675 | N/A | 8586 Sage Court | SCOTTSDALE | ·AZ | 85291 | - | NULL |
| PRV | PRV-22996 | 2026-09-15T18:44:42Z | Walter | S | Moreno | 1992-12-06 | null | — | (956) 389-0151·· | N/A | 7959 Canyon Road | Sacramento | CA | 95880-6897 | — | — |
| PRV | PRV-27212 | 2026-05-23T04:45:16Z | JUSSTIN | ·· | BOWMAN | 1980-11-01 | UHC-62449-29 | null | 16663242365 | JUSTIN.BOWMAN@ICLOUD.COM | null·· | N/A·· | UNKNOWN | NULL | ·· | UNKNOWN |
| PRV | PRV-23883 | 2026-01-08T03:56:52Z | PATEL | — | PAUL | 1942-11-22 | UHC6729932 | UNKNOWN | (671) 723-3707 | PAUL.PATEL11@YAHOO.COM | 8622 Bayshore Dr Apt 22 | Tucson | AZ | 85741 | - | UNKNOWN |
| PRV | PRV-21293 | 2026-08-26T17:34:32Z | Munoz, Deborah | — | — | 1989-05-06 | UHC-29058-69 | null | 682-953-6361 | deborah.munoz@hotmail.com | 5131 Apache Blvd | Gilbert | AZ | 85265 | - | — |
| PRV | PRV-22008 | 2026-09-11T18:03:38Z | ·marilyn | — | peters | 04/10/2008 | UHC-57980-91 | — | ·UNKNOWN | UNKNOWN | 9318 Elm Street | Plano | Texas | 75046·· | — | SELECT-EPO |
| PRV | PRV-20323 | 2026-04-25T05:46:48Z | TERRY·· | — | WELLS | 8/6/1948·· | null | — | UNKNOWN | ···· | 6231 Sage Ct | Sacramento | CA | 95869 | UNKNOWN | N/A |
| PRV | PRV-28707 | 2026-01-11T00:06:43Z | James | — | Mills | 1982-10-16 | — | - | 489-674-5749 | NULL | 9312 Broadway | Los Angeles | CA | — | UNKNOWN | CHOICE-PLUS-PPO·· |
| PRV | PRV-24627 | 2026-04-16T18:31:39Z | charles | — | fowler | 1963-05-20 | null | null | 9655437918 | ·UNKNOWN | 3451 Mountain View Drive | Mesa | AZ | 85269 | — | select-epo |
| PRV | PRV-26916 | 2026-05-24T20:04:40Z | ASHLEY | — | HNRY | 1965-12-15 | — | •••-••-8474 | 13019232575 | - | 8367 CHURCH STREET | Atlanta | GA·· | 30347 | null | — |
| PRV | PRV-24484 | 2026-02-07T22:33:31Z | Jerry | — | Armstrong | 1940-04-10 | NULL | NULL | 967-220-0978 | jerry.armstrong@icloud.com | 6898 MOUNTAIN VIEW DR | Phoenix | AZ | 85058 | - | — |
| PRV | PRV-26523 | 2026-06-26T11:13:50Z | Tyler | — | Barnes | 1966-03-01 | N/A | — | 7433776119 | — | 2446 Apache Boulevard | Jacksonville | FL | 32219 | N/A | UNKNOWN |
| PRV | PRV-24892 | 2026-05-04T12:40:16Z | Scott, Alan | — | — | Apr 18, 1949 | null | •••-••-5618 | 16664792125 | alan.scott73@outlook.com·· | 7774 FOREST AVENUE | Chandler | Arizona·· | 85282 | null | — |
| PRV | PRV-23933 | 2026-07-24T14:15:15Z | RACHEL·· | — | LEE | 11/02/1939 | UHC-20804-03 | N/A | 299-399-7503 | — | 3132 Meadow Ln | ·LAS VEGAS | NV | 89139 | N/A | — |
| PRV | PRV-26821 | 2026-04-29T10:36:26Z | Juna S. | — | Bradley | 1951-04-10 | — | •••-••-9971 | 2158354537 | NULL | 8530 Hillcrest Rd | Charlotte | NC | 28274·· | null | SELECT-EPO |
| PRV | PRV-28587 | 2026-08-28T23:12:48Z | Kayla | B | Dominguez | 2005-12-04 | UHC-24025-42 | •••-••-3426 | (792) 368-9334 | - | 3204 Bayshore Dr | Plano | TX | 75051 | — | — |
| PRV | PRV-25137 | 2026-07-12T20:14:24Z | Betty | — | Patterson | 1979-01-20 | — | — | 7076134958 | UNKNOWN | 6212 Bayshore Drive | Gilbert | AZ | 85273 | — | - |
| PRV | PRV-20125 | 2026-08-05T20:50:07Z | Nunez, Brian | — | ·· | Mar 16, 1952 | UHC-67413-60 | null | 17507922554 | NULL | 4829 Mountain View Dr | Orlando | FL | 32825 | - | UNKNOWN |
| PRV | PRV-22728 | 2026-09-17T23:22:28Z | ·PATRICK | — | WEBB·· | ···· | NULL | N/A | 938.751.9014 | N/A | 31 Palm Drive | Jacksonville | FL | 32266 | — | - |
| PRV | PRV-27668 | 2026-08-10T17:10:53Z | JASON | — | ROSS | 1952-10-22 | null | •••-••-4296 | 7594240525 | — | 1716 Maple Ave #669 | Gilbert | Arizona | ·85278 | NULL | — |
| PRV | PRV-27131 | 2026-07-11T02:53:49Z | jason | — | chavez | 06/07/54 | — | — | 638-976-3999 | ·- | 825 FOREST AVE | Tampa | FL | 33694 | NULL | SELECT-EPO |
| PRV | PRV-25734 | 2026-08-15T04:58:10Z | Diane | — | Yang | 09/09/2001 | UNKNOWN | UNKNOWN | (261) 606-9814 | — | NULL | null | null·· | N/A | — | NULL |
| PRV | PRV-21975 | 2026-05-15T14:18:32Z | barbara | U. | warren·· | ·1979-06-15 | — | •••-••-0853 | 4519681684 | ·· | 9804 OCEAN AVENUE #139 | Austin | tx | 78763 | - | CORE-HMO |
| PRV | PRV-28037 | 2026-07-01T00:50:29Z | Elijah | — | Wood | 1984-09-24 | — | UNKNOWN | N/A | elijah.wood@icloud.com | 3073 Main Street | Scottsdale | AZ | 85282 | NULL | NULL |
| PRV | PRV-26056 | 2026-02-15T17:05:28Z | TIMOTHY | — | SCOTT | 07/22/1949·· | — | N/A | (237) 910-1779 | UNKNOWN | 449 Palm Drive | Nashville | TN | 37295 | NULL | NULL |
| PRV | PRV-21529 | 2026-09-18T05:29:25Z | Carolyn | — | Barnes | 9156-06-23 | UHC-31715-59 | N/A | (345) 256-3870 | N/A | 8801 Broadway #849 | Plano | TX | 75034 | - | null |
| PRV | PRV-28630 | 2026-09-04T21:35:12Z | AUSTIN | — | ROGERS | 0706-18-96 | NULL | UNKNOWN | (647) 743-0493 | austin.rogers@proton.me | 7743 Sage Court | San Antonio | Texas | 78273 | — | NULL |
| PRV | PRV-26579 | 2026-07-26T20:32:23Z | MARIA | ·· | CUNNINGHAM | 10/20/59 | UHC-51601-85 | N/A | 18988085832 | NULL | 7075 Pine Dr | Los Angeles | CA | 90008 | — | - |
| PRV | PRV-29526 | 2026-07-06T19:48:38Z | Kenneth | — | Day | 2008-07-12 | — | null | 726-851-0027 | N/A | 8020 Main St | Fresno | CA | UNKNOWN | - | N/A |
| PRV | PRV-24670 | 2026-05-25T22:07:08Z | Daniel·· | — | Henry | ·19940509 | UHC-35049-99 | - | (649) 858-1674 | — | 8016 Maple Ave | Eden Prairie | ·MN | 55363 | - | N/A |
| PRV | PRV-22292 | 2026-02-01T19:04:38Z | Padilla, Beverly | G. | — | 1954-10-26 | UHC-35803-15 | null | (539) 534-8170 | - | 6136 Park Pl | Mesa | AZ | 85225 | - | NULL |
| PRV | PRV-21610 | 2026-03-12T21:10:53Z | Nguyen, Maria | — | — | 2003-04-02 | N/A | — | 18202037758 | — | 4081 Willow Court | Phoenix | AZ | 85030 | NULL | OPTIONS-PPO |
| PRV | PRV-28290 | 2026-02-11T02:26:18Z | ·EDWARD | — | JENKINS | 1963-01-15 | - | — | null | — | ·7380 OAK STREET | Sacramento·· | CA | 95847 | NULL | UNKNOWN·· |
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:37.757Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty