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-24780 | 2026-02-02T20:22:36Z | SARAH | — | SINGH | 12/15/1940 | uhc-49529-34 | - | null | — | 220 Broadway | Jacksonville | FL | 32214 | NULL | null |
| PRV | PRV-26002 | 2026-01-03T08:31:07Z | Keith | — | Gordon | 1965-09-11 | UHC-14722-66 | N/A·· | 3936293122 | UNKNOWN | 9536 LAKE VIEW RD | Dallas | TX | 75240-5903·· | null | CORE-HMO |
| PRV | PRV-20863 | 2026-06-07T20:26:30Z | Peter | E | ·Ryan | 1976-02-24 | N/A | null | 5517228705·· | UNKNOWN | 5547 River Road·· | Tampa | FL | 33696·· | — | UNKNOWN |
| PRV | PRV-26980 | 2026-07-23T04:01:26Z | Janice | — | Banks | 22-06-1964 | UHC-81252-69 | null | (721) 618-3607 | — | ·6376 CHURCH STREET | Scottsdale | AZ | 85275 | N/A | — |
| PRV | PRV-26981 | 2026-08-21T06:05:36Z | julia | — | walker | 1973-07-13 | UHC-38007-53 | - | UNKNOWN | — | 8617 APACHE BOULEVARD Apt 36 | Plano | TX | 75077 | — | -·· |
| PRV | PRV-25206 | 2026-01-15T22:51:55Z | Mateo | — | Willis | 3/22/2002 | UHC-05122-10 | •••-••-7444 | - | N/A | null | N/A | null | N/A | ·null | CORE-HMO |
| PRV | PRV-23884 | 2026-10-08T08:21:10Z | Jerry | — | Sandoval | 1996-07-10 | UHC-15546-21 | null | (698) 539-0081 | NULL | 5046 Maple Avenue | ·MINNEAPOLIS | MN | 55429 | — | MEDICARE-ADV-B |
| PRV | PRV-22665 | 2026-01-15T02:59:58Z | Ward, Danielle·· | K | ···· | 20030925 | UHC-81974-47 | — | 18778395229 | NULL | 8315 CENTRAL AVE | SCOTTSDALE | AZ | 85262 | N/A | CORE-HMO |
| PRV | PRV-26215 | 2026-01-09T17:28:18Z | ·Ray, David | C | — | 2006-09-26 | UHC-63175-31 | — | 15379777346 | N/A | — | NULL | ·null | null | — | — |
| PRV | PRV-23385 | 2026-05-25T07:03:51Z | melissa | — | stephens | 2005-04-03 | null | null | 632-631-1041 | MELISSA.STEPHENS@HOTMAIL.COM | 2913 Sunset Blvd | ·Jacksonville | FL | 32280-4717 | ·· | ·NULL |
| PRV | PRV-23833 | 2026-02-02T15:03:21Z | ·Burke, Matthew | F. | — | ·1982-01-07 | — | null | (554) 451-0237 | matthew.burke83@aol.com | 2792 Desert Sky Blvd | Nashville·· | Tennessee | 37291-4211 | UNKNOWN | NULL |
| PRV | PRV-28773 | 2026-09-19T18:28:20Z | HANNAH | — | MILLER | 10/12/1957 | UHC-46820-04 | - | 9047055262 | NULL | 7477 Broadway | Las Vegas | NV | 89110 | — | ·NULL |
| PRV | PRV-26069 | 2026-08-11T14:18:06Z | Allen, Omar | — | — | 1997-07-16 | UHC-06383-65 | null | 7754676155 | UNKNOWN | 5570 Lincoln Way | Charlotte | NC | 28298 | — | NULL |
| PRV | PRV-28390 | 2026-10-18T08:18:42Z | Jnet | L | Howell | 2005-03-11 | N/A | N/A | N/A | ·· | 9379 WILLOW CT | AUSTIN | TX | UNKNOWN·· | - | MEDICARE-ADV-B |
| PRV | PRV-25940 | 2026-01-30T04:21:14Z | Gabriel | — | Thompson | 1962-10-09 | UHC-12785-40 | ·- | (247) 870-6650 | gabriel.thompson24@yahoo.com | 6602 Valley View Dr | San Antonio | TX | 78273 | N/A | UNKNOWN |
| PRV | PRV-26931 | 2026-09-27T03:56:54Z | DEBORAH | ···· | HOFFMAN | Dec 20, 1955 | — | ·N/A | (652) 265-5625 | deborah.hoffman1@hotmail.com | 551 Spring St | Chandler | AZ | 85202 | — | NAVIGATE-HMO |
| PRV | PRV-27227 | 2026-09-07T21:14:12Z | MELISSA | — | HAWKINS | — | UHC-47276-80 | •••-••-7904 | 7004380328 | UNKNOWN | 4053 FOREST AVENUE | SAN DIEGO | CA | 92140 | — | null |
| PRV | PRV-29386 | 2026-03-17T05:23:12Z | Samantha | — | Fuller | 11/24/41 | N/A | - | 2457097160 | NULL | 4633 Cedar Lane | Charlotte | NC | 28222 | UNKNOWN | — |
| PRV | PRV-22490 | 2026-06-21T07:52:06Z | davis | — | jason | 2008-11-02 | UHC-10468-58 | •••-••-8437 | (888) 625-8419·· | jason.davis@hotmail.com | 8435 Pine Drive | Gilbert | AZ | — | ·null | OPTIONS-PPO |
| PRV | PRV-24632 | 2026-06-22T13:34:53Z | CYNTHIA | ·J | MITCHELL | 18-08-1993 | UHC-39160-11 | N/A | (216) 482-0816 | N/A | 308 Broadway | Tampa | FL | ·33602-8497 | NULL | - |
| PRV | PRV-24193 | 2026-04-28T18:32:10Z | Roger | ·· | Wheeler | — | — | UNKNOWN | (247) 437-9538 | — | 7260 JEFFERSON AVENUE | Tucson·· | AZ | 85782 | — | NAVIGATE-HMO |
| PRV | PRV-26199 | 2026-08-03T06:32:20Z | ·SANTIAGO | — | PATTERSON | 1978-05-19 | - | N/A | (747) 954-0450 | — | 6551 Mesa Drive | Charlotte·· | NC | 28248-5420 | — | CORE-HMO |
| PRV | PRV-28060 | 2026-01-12T04:39:23Z | Lucia | — | Gonzalez | 1978-07-05 | UHC-77260-89 | — | N/A | — | ·3897 Bayshore Dr | Sacramento | CA | 95873 | ·null | — |
| PRV | PRV-29515 | 2026-06-14T11:37:58Z | CHERYL | — | CARR | 1981-12-11 | — | - | 625-429-3747 | ·· | null | UNKNOWN | UNKNOWN | N/A | null | NULL |
| PRV | PRV-21061 | 2026-05-25T13:26:56Z | Mariana | — | Bradley | 1960-08-08 | UHC-30373-48 | •••-••-4610 | (715) 931-7768 | — | 3194 Sunset Boulevard | Seattle | Washington | 98156-6555 | — | — |
| PRV | PRV-27589 | 2026-01-17T09:07:43Z | Mariana·· | — | Hansen | 10/02/1948 | NULL | N/A | 329-702-0131 | MARIANA.HANSEN83@AOL.COM·· | 7499 Desert Sky Blvd | Eden Prairie | Minnesota | 55370 | — | N/A |
| PRV | PRV-20137 | 2026-10-07T17:02:21Z | Wayne·· | ·S. | Carpenter | 02/01/1993 | N/A·· | UNKNOWN | 9764727482 | ·· | 6771 Bayshore Drive | ·EDEN PRAIRIE | MN | 55375 | — | NULL |
| PRV | PRV-22034 | 2026-07-06T20:23:25Z | Justni | ·· | Greene | 1999-05-08 | null | - | 249-666-7165 | — | 198 Harbor Blvd | Nashville·· | TN | NULL | null·· | N/A |
| PRV | PRV-22059 | 2026-02-06T02:29:00Z | Jacob | — | Kim | 07/15/1958 | UHC-18672-96·· | - | 487-748-9624 | null·· | 8072 ELM STREET | JACKSONVILLE | FL·· | 32291 | - | NULL |
| PRV | PRV-28614 | 2026-05-09T03:11:15Z | Howell, Sandra | T | — | 08/19/40 | ···· | — | (570) 803-5365 | sandra.howell78@hotmail.com | 1797 MEADOW LN | MESA | AZ | 85266 | ···· | null |
| PRV | PRV-23344 | 2026-09-15T23:47:48Z | KIMBERLY | — | WEBB | 2001-10-11 | UHC-74710-86 | null | N/A | kimberly.webb67@yahoo.com | 1437 Grand Avenue | Nashville | TN | 37292 | — | - |
| PRV | PRV-20105 | 2026-06-17T15:16:50Z | Deborah | ·· | Williams | 1967-12-27 | UHC-53086-07 | NULL | 14749914477 | deborah.williams@outlook.com | 6972 Grand Avenue | Miami | FL | 33164 | - | UNKNOWN |
| PRV | PRV-27780 | 2026-08-27T02:03:52Z | Mary | B | Hanson | 1958-05-14 | UHC-40770-25 | NULL | 4053626007 | — | 1207 MOUNTAIN VIEW DR | Plano | TX | 75075 | - | null |
| PRV | PRV-23967 | 2026-08-19T22:45:12Z | Palmer, Anthony | ·L | — | 6/21/1953 | ·UHC-35596-29 | NULL·· | 6407435110 | UNKNOWN | 867 ELM STREET | Fresno | CA | 93755 | NULL | N/A |
| PRV | PRV-23400 | 2026-07-31T20:55:10Z | Espinoza, Gary | V. | ·· | ·1948-04-18 | UHC-84150-57 | — | 9606425868 | gary.espinoza@aol.com | N/A | — | — | — | — | — |
| PRV | PRV-29208 | 2026-05-16T18:23:59Z | Carol·· | — | Willis | 1982-12-20 | — | null | 902-325-6100 | carol.willis44@outlook.com | 5189 Cedar Lane | Eden Prairie | MN | 55333-0047 | -·· | UNKNOWN |
| PRV | PRV-20053 | 2026-02-11T22:00:04Z | Camila | — | Jimenez | 2008-07-04 | UHC-95243-62 | — | 3492342575 | — | 4881 SUNSET BOULEVARD Apt 40 | Orlando | Florida | 32835 | — | MEDICARE-ADV-A |
| PRV | PRV-24666 | 2026-09-23T05:55:37Z | raymond | — | pierce | 1964-01-27 | — | — | 7829685415 | — | 8367 Mountain View Dr | Miami | FL | 33184 | - | — |
| PRV | PRV-20801 | 2026-02-10T23:31:40Z | Danielle | ···· | Perry | 1981-01-25 | ·UHC-15283-06 | UNKNOWN | (782) 379-2073 | — | 372 Church St | Denver | CO | 80253 | null | — |
| PRV | PRV-27801 | 2026-01-31T20:37:07Z | gerald | K | robertson·· | 19450920·· | — | NULL | N/A | — | 2789 Palm Dr | PHOENIX | AZ | ·85083 | UNKNOWN | NULL |
| PRV | PRV-26254 | 2026-09-27T04:54:16Z | Mark | — | ·Schmidt | 14-10-1966 | ·NULL | •••-••-1209 | 2096465528 | — | — | — | NULL | null | - | — |
| PRV | PRV-22647 | 2026-06-23T20:32:33Z | GARY | — | RICHARDS | 1994-12-26 | NULL·· | UNKNOWN | NULL·· | gary.richards@gmail.com | 720 UNION STREET | Mesa | AZ | 85208 | NULL | ·CHOICE-PLUS-PPO |
| PRV | PRV-28913 | 2026-09-10T14:47:33Z | Nicholas | — | Oliver | ·1967-01-18 | — | •••-••-2297 | 13179898853 | UNKNOWN | 7570 Lake View Road | Houston | TX | 77050 | null·· | — |
| PRV | PRV-27659 | 2026-04-22T16:08:27Z | Donna | Q | Raamirez | ·1978-07-06 | NULL | UNKNOWN | 3333590613 | — | 7362 Valley View Dr | Nashville | TN | 37254 | N/A | MEDICARE-ADV-B |
| PRV | PRV-28315 | 2026-08-25T06:49:32Z | SANDRA | — | JOHNSTON | 1987-04-23 | null | NULL | 370-640-6971 | sandra.johnston@hotmail.com | 8467 Sunset Blvd | Austin | TX | 78717 | N/A | — |
| PRV | PRV-26594 | 2026-03-02T06:12:03Z | Ethan | — | Oliiver·· | 1938-11-05·· | — | NULL | UNKNOWN | NULL | 646 Ridge Rd·· | Sacramento·· | CA | 95800 | — | — |
| PRV | PRV-26593 | 2026-06-22T15:33:20Z | Deborah | — | Robinson·· | 1946-06-14 | ·UHC-84327-14 | null | 3847063063 | null | 9488 JEFFERSON AVE | Columbus | Ohio | NULL·· | UNKNOWN | - |
| PRV | PRV-25874 | 2026-05-17T07:40:25Z | Virgina | — | Santos | 1963-04-24 | UHC-04585-66 | — | 7167838598 | virginia.santos@gmail.com | null | UNKNOWN | — | — | — | N/A |
| PRV | PRV-22969 | 2026-05-30T17:17:59Z | Sarh | ···· | Wright | 2007-07-09 | UHC8813096 | •••-••-6690 | UNKNOWN | SARAH.WRIGHT@GMAIL.COM | 3671 Sunset Boulevard | NASHVILLE | ·Tennessee | 37271 | null | — |
| PRV | PRV-28445 | 2026-09-13T00:17:12Z | KATHRYN | — | WILSON | 1995-04-08 | — | — | — | — | 4396 Sage Ct | CHANDLER | AZ | 85243-5260 | 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.155Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty