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-23242 | 2026-09-16T01:58:37Z | Helne | — | Robinson | 3/10/1996 | — | N/A | 653.205.4941·· | HELEN.ROBINSON10@AOL.COM | 1332 HILLCREST RD | Atlanta | GA | 30378 | — | UNKNOWN |
| PRV | PRV-20282 | 2026-03-01T08:20:28Z | Barb | — | Ryan | 19640501 | NULL | •••-••-9679 | 323-240-3800 | - | 6299 Sunset Boulevard | San Diego | CA | 92148 | — | - |
| PRV | PRV-28261 | 2026-02-19T05:06:14Z | JOSHUA | — | HICKS | 27-02-1958·· | - | — | 15172881512 | NULL | UNKNOWN | — | UNKNOWN | ·- | null | NULL |
| PRV | PRV-25420 | 2026-05-02T14:18:02Z | SEAN | — | GORDON | 1987-10-04 | UHC-32543-22 | N/A | (375) 724-9175 | sean.gordon71@outlook.com | 6154 Canyon Road | Mesa | AZ | 85230 | UNKNOWN | null |
| PRV | PRV-28318 | 2026-07-18T03:39:58Z | Dennis | W. | Sims | 19880412·· | null | UNKNOWN | null | null | NULL | UNKNOWN | UNKNOWN | — | — | MEDICARE-ADV-B |
| PRV | PRV-21946 | 2026-02-21T13:07:22Z | Isabella | ·· | Flores | Jun 4, 2000 | UNKNOWN | NULL | (747) 388-4284 | ···· | 3163 Forest Avenue | Plano | TX | 75000 | N/A | — |
| PRV | PRV-21309 | 2026-07-04T13:23:27Z | Amber | F. | White·· | 1962-01-21 | — | — | 820-911-7647 | amber.white88@gmail.com | 2131 SUNSET BOULEVARD #710 | MIAMI | FL | 33105 | N/A | ·SELECT-EPO |
| PRV | PRV-27538 | 2026-08-15T16:20:22Z | OMAR | — | VALDEZ | 1961-04-21 | UHC-08703-94 | •••-••-7265 | (739) 547-5822 | ·N/A | 6802 Highland Ave | Scottsdale | ·AZ | 85215·· | — | — |
| PRV | PRV-25500 | 2026-10-08T06:47:55Z | Hernandez, Ryna | L. | ·· | 1959-01-19 | - | •••-••-8114 | 15727094583 | — | — | — | — | NULL | — | — |
| PRV | PRV-23564 | 2026-03-16T23:37:14Z | Judy | — | Cooper | 19640918 | — | N/A | ·null | JUDY.COOPER9@OUTLOOK.COM | 3369 Apache Blvd | GILBERT·· | AZ | 85221 | UNKNOWN | - |
| PRV | PRV-20409 | 2026-05-05T05:09:28Z | ·joseph | — | fields | 1967-12-01 | — | •••-••-8484 | null | ·joseph.fields2@aol.com | 704 GRAND AVE | Denver | CO | 80254 | — | UNKNOWN·· |
| PRV | PRV-20311 | 2026-04-03T05:18:58Z | GEORGE·· | Y. | RIOS | 1974-11-12 | ·- | •••-••-8338 | (945) 510-1110 | george.rios40@icloud.com | 6504 VALLEY VIEW DR | AUSTIN | TX | 78707 | — | — |
| PRV | PRV-26745 | 2026-10-07T20:25:14Z | Kyle | ·V | Butler | 11/28/91 | UHC-96998-42·· | N/A·· | (507) 953-2266 | - | 1483 Canyon Rd | Charlotte | NC | 28268 | — | — |
| PRV | PRV-26898 | 2026-04-04T20:37:51Z | ·Mat | — | Bradley | 06/22/74 | UHC-67838-83·· | NULL | (477) 602-4405 | — | ·8537 Baseline Road | Glendale | AZ | 85300 | - | UNKNOWN |
| PRV | PRV-27268 | 2026-07-01T12:09:02Z | Yang, Nathan·· | E. | — | May 21, 1957 | — | •••-••-9929 | (494) 927-1401 | N/A | ·4848 Hillcrest Rd | Los Angeles | ·CA | 90002 | ·- | SELECT-EPO |
| PRV | PRV-20736 | 2026-03-07T16:54:23Z | SARAH | N. | CRUZ | 2002-05-22 | — | null | (478) 951-4363 | — | — | — | - | UNKNOWN | — | options-ppo |
| PRV | PRV-24002 | 2026-04-17T08:17:31Z | Logan | ·T. | Pihllips | 1962-04-09 | ·UHC-41116-08 | •••-••-8892 | — | — | ·2237 Market Street #861 | SEATTLE | WA | — | NULL | NULL |
| PRV | PRV-23170 | 2026-06-06T06:02:03Z | Murray, Robert | V. | — | 1960-04-28 | UHC0662468 | — | 226-575-0560 | robert.murray@proton.me | 8849 Mesa Drive | Tampa | FL·· | 33680 | null | — |
| PRV | PRV-21684 | 2026-05-04T20:26:49Z | Foster, Eugene | — | — | 1959-03-24 | — | — | (685) 688-6984 | eugene.foster2@icloud.com | 6273 CENTRAL AVENUE | Sacramento | CA | NULL | — | — |
| PRV | PRV-26640 | 2026-01-31T12:54:02Z | DANIELLE | R | MARTINEZ | Jul 22, 2004 | UHC7891682 | N/A | NULL·· | - | 8733 Desert Sky Boulevard | Orlando | FL | 32815 | — | - |
| PRV | PRV-26891 | 2026-01-24T15:32:09Z | austin | A | hayes | UNKNOWN | ·· | — | 564.252.6506 | — | 7703 PALM DR | Denver | CO | 80201 | — | — |
| PRV | PRV-22927 | 2026-07-02T09:54:36Z | Julie | H | ·Sims | 25-02-1980 | UHC-52677-23 | — | - | — | 4819 VALLEY VIEW DR·· | San Antonio | Texas·· | 78220-5379 | — | null |
| PRV | PRV-26209 | 2026-07-13T00:15:20Z | ·Katherine | — | Adams | 07/08/42 | null | null | 648.638.8366 | — | null | — | NULL | N/A | UNKNOWN | — |
| PRV | PRV-29228 | 2026-07-14T14:45:02Z | Emma | — | Richardson | 1980-10-14 | NULL | - | 7188204004 | UNKNOWN | 877 Central Avenue | PHOENIX | AZ | 85058 | UNKNOWN | — |
| PRV | PRV-29398 | 2026-05-10T16:57:30Z | Alan | — | Warren | 1946-09-10 | — | — | +1 321 340 3999 | ALAN.WARREN56@PROTON.ME | 7316 Valley View Dr | Chandler | AZ | 85285·· | UNKNOWN | MEDICARE-ADV-B |
| PRV | PRV-29262 | 2026-04-30T18:22:13Z | Camila | J | Price | 1972-05-11 | UHC-50192-84 | — | (980) 504-7532 | -·· | 6672 Canyon Road | NASHVILLE | TN | 37270 | - | — |
| PRV | PRV-23772 | 2026-07-10T12:59:32Z | Marilyn | ···· | Peterson | ·12/11/42 | UNKNOWN | — | — | MARILYN.PETERSON51@YAHOO.COM | 2853 River Road | PHOENIX | AZ | 85070 | N/A | null |
| PRV | PRV-21788 | 2026-09-02T08:09:40Z | Diana | — | Berry | 03/11/78 | UHC-53245-53 | — | 681-658-1324 | null | 8859 Spring Street | Miami | FL | 33197 | — | UNKNOWN |
| PRV | PRV-22591 | 2026-02-25T09:39:00Z | Sullivan, Michelle | — | — | 1950-10-26 | UHC0930718 | N/A | 4746191 | NULL | 2442 Market Street #859 | Dallas | TX | 75255-1689 | — | — |
| PRV | PRV-23866 | 2026-01-05T06:02:03Z | Kenneth | ·K | Fowler | 1956-12-11 | UNKNOWN | — | 904.437.9449 | N/A | 100 Canyon Road | Dallas | TX | 75272 | ·- | MEDICARE-ADV-B |
| PRV | PRV-21124 | 2026-09-09T21:54:04Z | albert | — | sanders | 07/28/1943 | N/A | NULL | (930) 967-6412 | UNKNOWN | 313 Canyon Rd | LAS VEGAS | nv | ···· | — | — |
| PRV | PRV-26026 | 2026-02-14T04:50:18Z | Wayne | Y | Brown·· | 8/27/1980 | NULL | null | null | null·· | N/A | — | — | — | - | — |
| PRV | PRV-21231 | 2026-04-16T16:18:38Z | Madison | L | Armstrong | 1973-10-11 | UHC-95183-75 | NULL | 9595884632 | madison.armstrong@proton.me | 6205 Grand Ave | Plano·· | TX | 75071 | - | N/A |
| PRV | PRV-28921 | 2026-09-19T02:01:09Z | Linda | ·D. | Ross | 1956-08-11 | NULL | — | 449.499.3190 | linda.ross@outlook.com | 3198 SUNSET BOULEVARD·· | San Antonio | TX | 78280 | UNKNOWN | null |
| PRV | PRV-24890 | 2026-03-13T09:46:08Z | Bradley | ···· | Ford | 1955-09-13 | UNKNOWN | N/A | - | UNKNOWN | 8827 Sage Court | Chandler | AZ | 85296 | N/A | select-epo |
| PRV | PRV-28228 | 2026-01-08T03:15:29Z | Cruz, Amber | — | — | 10/18/43 | UHC-42078-47·· | ·null | - | NULL | 7339 OAK ST | Austin | TX | 78707 | — | CHOICE-PLUS-PPO |
| PRV | PRV-25024 | 2026-04-24T09:37:02Z | SHARON | A. | LITTLE | 0703-02-04 | — | - | — | sharon.little1@aol.com | 8702 Pine Drive | Houston | TX | 77080 | - | UNKNOWN |
| PRV | PRV-26633 | 2026-07-17T19:14:39Z | danielle | — | lawrence | 1983-11-02 | — | •••-••-3772 | 7698663216 | danielle.lawrence78@outlook.com | 9652 Mesa Drive | Houston | TX | 77069 | null | CHOICE-PLUS-PPO |
| PRV | PRV-27280 | 2026-06-15T17:16:38Z | GABRIEL | C | PATTERSON | ·05-06-1980 | UHC-73125-87·· | — | 19642252123 | — | 2762 Elm Street | Glendale | AZ | 85393 | - | UNKNOWN |
| PRV | PRV-28431 | 2026-01-02T08:02:51Z | Susan | C | Hamilton | 1983-12-09 | — | null | ·+1 968 346 9728 | susan.hamilton@aol.com | 4288 Church St #742 | Sacramento | CA | 95810-3901 | — | CHOICE-PLUS-PPO |
| PRV | PRV-26967 | 2026-01-31T02:30:27Z | SOTO | ·· | RANDY | Dec 7, 1943 | UHC-23233-32 | UNKNOWN·· | 8336914874 | — | 8000 Pine Drive | ·Dallas | Texas | 75231 | UNKNOWN | N/A |
| PRV | PRV-27588 | 2026-08-10T18:06:37Z | Ruiz, Jason | — | — | 12/27/00 | ·N/A | NULL | (581) 382-3891·· | — | — | — | — | ·· | null | — |
| PRV | PRV-26838 | 2026-01-25T07:09:07Z | Nicole | F | ·Santos | 12/19/1938 | ·· | •••-••-1043 | (253) 701-3915 | null | 9029 Ocean Ave | MINNEAPOLIS | MN | 55437 | — | NULL |
| PRV | PRV-25944 | 2026-01-24T06:20:20Z | Dorothy | — | Weaver | 1941-10-26 | UHC-95535-78 | ·· | 327.937.0475 | dorothy.weaver34@gmail.com | 916 Jefferson Avenue | Seattle | Washington | 98185 | N/A | NULL |
| PRV | PRV-20765 | 2026-03-11T04:44:41Z | Anthony | J.·· | Hoffman | 1977-01-02 | NULL | NULL | 3016837 | - | 5486 Highland Ave | Atlanta | GA | — | ·null | — |
| PRV | PRV-21809 | 2026-08-29T22:53:08Z | Luis | I | Murphy | 1965-07-18 | UHC-24205-01 | UNKNOWN | 9488942399·· | luis.murphy@icloud.com | ·2011 Grand Ave | Jacksonville | FL | 32261 | UNKNOWN | — |
| PRV | PRV-25349 | 2026-03-15T06:14:43Z | Martinez, Betty | ·Y. | — | 1968-04-26 | UHC-57515-46 | UNKNOWN | 5793489459·· | NULL | 3912 CENTRAL AVE | Los Angeles | CA | 90010 | — | NULL·· |
| PRV | PRV-22938 | 2026-03-01T06:45:35Z | ·Aaron | — | Cruz | 2008-01-18 | UHC8955676 | null | (596) 296-0753 | aaron.cruz14@icloud.com | NULL·· | — | - | - | — | N/A |
| PRV | PRV-21952 | 2026-10-17T15:42:15Z | William | ···· | Vasquez | 1939-01-24 | - | UNKNOWN | ·· | - | - | — | - | — | — | — |
| PRV | PRV-25259 | 2026-01-24T14:29:48Z | ·joyce | M | webb | 1940-07-21 | UHC-86059-45 | - | 408-706-4188 | NULL | 4877 Grand Avenue | Seattle | WA | 98187 | — | 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:43:00.241Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty