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-23126 | 2026-08-28T20:22:06Z | Steven | — | Green | 2007-05-26 | - | NULL | (916) 633-9086 | N/A | ·17 Oak St | Plano | TX | 75011 | — | N/A |
| PRV | PRV-26970 | 2026-07-16T21:49:34Z | Carol | M | Franklin | 1938-04-22 | UHC-98866-30 | — | (224) 530-7140 | null | 8103 UNION ST | Tempe | AZ | 85292 | — | N/A·· |
| PRV | PRV-25395 | 2026-02-27T08:47:46Z | Judith·· | G | Cunningham | ·1986-06-05 | UNKNOWN | null | 713-519-4974 | judith.cunningham@icloud.com | 244 Broadway | Sacramento | CA | 95828 | NULL·· | NAVIGATE-HMO |
| PRV | PRV-23978 | 2026-09-01T10:50:46Z | ETHAN | — | ·MORGAN | 03/26/1939 | — | •••-••-6115 | 837-871-5781 | UNKNOWN | 6874 BASELINE ROAD | Fresno | CA | 93715 | — | — |
| PRV | PRV-29566 | 2026-06-23T05:42:22Z | DENISE | — | ROGERS | 1996-05-21 | UHC-63267-36 | - | +1 393 512 8684 | NULL | 6840 OCEAN AVENUE | San Diego | CA | 92153 | - | null |
| PRV | PRV-25648 | 2026-01-21T04:31:01Z | Ashley | — | Hall | 2002-03-15 | — | NULL | (268) 597-7492 | — | 5373 Jefferson Avenue #694 | NASHVILLE | ·TN | 37281·· | — | ·SELECT-EPO |
| PRV | PRV-28143 | 2026-05-31T07:59:22Z | Shirley | — | Vasquez | 08/15/1997 | UHC-77814-68 | — | 701-286-2573 | shirley.vasquez83@icloud.com | 9094 APACHE BLVD | Atlanta | GA | 30320 | — | — |
| PRV | PRV-23140 | 2026-06-22T13:25:13Z | Edward | — | Powell | 1968-08-27 | - | UNKNOWN | 8664825 | — | 1518 INDIAN SCHOOL RD | Tucson | AZ | 85731 | — | UNKNOWN |
| PRV | PRV-23430 | 2026-08-17T19:38:49Z | Roy | — | Vargas | 1995-02-27 | UHC-80446-31 | null | — | ROY.VARGAS@HOTMAIL.COM | 8851 Maple Avenue·· | LOS ANGELES | CA | 90066 | ·· | N/A |
| PRV | PRV-27461 | 2026-03-18T09:22:37Z | GEORGE | — | BISHOP·· | 03/28/98 | UHC-09489-36 | — | 904.285.7970 | NULL | 1650 Grand Avenue | Plano | TX | 75052 | — | ·UNKNOWN |
| PRV | PRV-27500 | 2026-04-14T20:36:19Z | MEGAN | ···· | FERGUSON | Aug 10, 1988 | N/A | •••-••-2713 | +1 709 677 6678 | — | 3570 Grand Ave | Seattle | WA | 98152 | NULL | — |
| PRV | PRV-23512 | 2026-03-01T01:42:47Z | FATIMA | — | ROBERTSON | 1941-11-02 | UHC-98227-66 | NULL | (804) 870-5194 | ···· | null | — | — | NULL | null | null |
| PRV | PRV-25441 | 2026-10-05T14:09:10Z | ·steven | — | west | 1968-04-02 | UHC-27799-40 | ·· | — | null | 16 MESA DRIVE | Gilbert | AZ | 85268 | — | — |
| PRV | PRV-24565 | 2026-03-06T19:22:38Z | Tyler | — | Luna | 1977-07-09 | - | N/A | 856.915.8143 | — | 1937 Meadow Ln | Atlanta | GA | 30361-5825 | — | NAVIGATE-HMO |
| PRV | PRV-22632 | 2026-07-20T10:30:30Z | James, Carol | U. | — | 1996-11-22 | — | NULL | 7094556 | — | 5225 UNION ST | TUCSON | ·AZ | 85723 | - | — |
| PRV | PRV-23432 | 2026-05-15T00:09:01Z | Adams, Julia | — | — | 04/13/1962 | UHC-29398-05 | •••-••-6311 | ·(620) 827-4753 | null | - | — | — | - | UNKNOWN | ···· |
| PRV | PRV-24939 | 2026-08-14T21:37:31Z | ·MATTHEW | — | CRUZ | 1944-06-17·· | UHC-91463-54 | N/A | ·(213) 422-5293 | N/A | 7979 Pine Drive | Eden Prairie | MN | 55374 | - | UNKNOWN |
| PRV | PRV-27873 | 2026-07-13T05:44:19Z | Christina | T | Lawrence | 2006-09-09 | — | — | +1 924 709 9607 | — | 8599 Sage Court | Chandler | AZ | 85279 | UNKNOWN | — |
| PRV | PRV-28839 | 2026-07-30T23:43:50Z | Mike | — | George | 6/24/1955 | NULL | - | (684) 803-1192 | — | 3589 BASELINE RD | MIAMI | FL | 33173 | N/A | — |
| PRV | PRV-24887 | 2026-02-13T07:17:35Z | Megan | R. | ·Lee | 11-08-1974 | UHC-53262-83 | - | ···· | null | 1493 HIGHLAND AVENUE | DENVER | CO | 80254-6189 | — | - |
| PRV | PRV-27100 | 2026-04-03T23:46:35Z | terry | — | davis | 1976-05-26 | UHC-12131-13 | — | +1 340 313 5479 | UNKNOWN | 7984 River Rd | Glendale | AZ | 85332 | N/A | NULL |
| PRV | PRV-24298 | 2026-06-28T08:54:23Z | Watkins, Jacob·· | — | — | 1948-01-23 | UNKNOWN | •••-••-4743 | 9825231742 | - | 1221 Church Street·· | Fresno | CA | NULL | NULL | N/A |
| PRV | PRV-22685 | 2026-04-04T12:09:38Z | Nancy | — | Rios | 03-11-1945 | null | — | N/A | nancy.rios19@outlook.com | 7547 Highland Avenue Apt 19 | COLUMBUS | OH | 43286 | NULL | — |
| PRV | PRV-20912 | 2026-02-22T12:36:34Z | BETTY | — | ALLEN | 1956-09-12 | ·- | — | 965.963.5693 | betty.allen22@icloud.com | 8596 Broadway | Tempe | AZ | 85248 | NULL | CHOICE-PLUS-PPO |
| PRV | PRV-23174 | 2026-09-28T15:07:37Z | Daniels, Laura | — | — | ·04/28/78 | N/A | •••-••-2546 | 716-589-5063 | — | 2172 Lincoln Way | Chandler | AZ | - | — | CORE-HMO |
| PRV | PRV-27182 | 2026-10-01T13:05:30Z | King, Valentina | — | — | 1989-03-28 | null | NULL | — | - | 8497 Palm Dr | ORLANDO | FL | 32882 | N/A | UNKNOWN |
| PRV | PRV-22003 | 2026-05-29T02:38:19Z | Julie | — | Pena | 1989-12-02 | UHC-02461-38 | — | 12948505111·· | ·N/A | 59 MOUNTAIN VIEW DRIVE | TUCSON | AZ | 85739 | — | null |
| PRV | PRV-23056 | 2026-05-07T11:45:02Z | Betty | I | Hutner | 9/7/1989 | UHC-84042-08 | •••-••-6910 | ·+1 875 630 2387 | — | 2690 Desert Sky Blvd | Seattle·· | WA | 98177 | UNKNOWN | - |
| PRV | PRV-26179 | 2026-05-31T01:34:53Z | ·Lee, Angela | — | — | Jun 7, 1983 | UHC-45982-35 | •••-••-0460 | 962-440-5853 | — | 7108 Meadow Ln | SACRAMENTO | CA | 95803 | — | null |
| PRV | PRV-27065 | 2026-04-07T01:14:08Z | AISHA | — | GILBERT | Aug 8, 1971 | null | null | 503-956-6880 | null | 8619 ELM ST Apt 13 | Houston | TX | 77047 | null | NAVIGATE-HMO |
| PRV | PRV-24430 | 2026-02-25T20:37:40Z | ·Daniel | — | Jackson | 21-11-1951 | UHC-96969-13 | •••-••-5084 | 881-734-3579 | DANIEL.JACKSON@OUTLOOK.COM | 9136 BASELINE RD | Denver | CO | 80242 | NULL | - |
| PRV | PRV-28591 | 2026-02-13T18:15:12Z | John | F | Bell | 1979-07-03 | — | NULL | 312.606.8312 | — | 4113 Market St #328 | Tucson | Arizona | 85785 | N/A | - |
| PRV | PRV-25011 | 2026-07-29T02:36:33Z | Carol | — | Wheeler | 19430208·· | N/A | N/A | (218) 256-6087 | null | 6835 MAPLE AVENUE | Denver | CO | 80242 | ·· | null |
| PRV | PRV-21145 | 2026-03-25T08:55:57Z | Angela | O | Wood | Sep 26, 2008 | UHC-49670-68 | null | 687-793-9048 | — | — | - | — | - | — | — |
| PRV | PRV-26140 | 2026-09-23T07:46:47Z | DANIELLE | — | RUSSELL | 01-07-1991 | — | N/A·· | 14739164877 | — | 2379 Forest Avenue | Tucson·· | AZ | 85737 | UNKNOWN | null |
| PRV | PRV-23434 | 2026-07-20T00:39:08Z | ·Robert | Q | Day | 1942-07-06 | ···· | N/A | (303) 422-4257 | — | 5242 River Road | Scottsdale | AZ | 85251 | -·· | - |
| PRV | PRV-23084 | 2026-06-27T18:52:10Z | ·SOFIIA | — | WABB | 1956-09-14 | UHC-71462-42 | - | — | N/A | 3993 Highland Ave | Orlando | FL | 32802 | — | N/A |
| PRV | PRV-24023 | 2026-08-31T08:24:57Z | Patricia | ···· | Patel | 1958-07-09 | UHC-33252-46 | NULL | 7033724602 | UNKNOWN | 3400 Central Ave | Nashville | TN | 37256 | NULL | OPTIONS-PPO·· |
| PRV | PRV-25852 | 2026-07-06T19:38:08Z | Maria | — | Morgan | Feb 11, 2007 | NULL | •••-••-2549 | ·· | maria.morgan11@gmail.com | 6055 WILLOW COURT | MESA | AZ | 85273 | - | N/A |
| PRV | PRV-20100 | 2026-04-29T10:55:29Z | Marcus | — | Luna | 1991-11-07 | UHC-28607-59 | — | 3503922594 | — | 4042 DESERT SKY BLVD | Scottsdale | AZ | 85225 | ·· | SELECT-EPO |
| PRV | PRV-24280 | 2026-01-28T10:29:06Z | Joshua | — | Ford | 09/26/72 | UHC-98156-24 | •••-••-7800 | (477) 436-4619 | ···· | 7167 CAMELBACK RD | Tampa | FL | 33641 | — | — |
| PRV | PRV-27599 | 2026-04-05T15:48:48Z | Diego | C | ·Snyder | 01/08/44 | UHC-57459-82 | N/A | 398-934-1877 | N/A | 2917 Washington St | Seattle | WA | 98101 | - | MEDICARE-ADV-B |
| PRV | PRV-21338 | 2026-05-18T03:17:36Z | Tucker, Billy | ···· | — | Dec 20, 1987 | UNKNOWN | — | (550) 877-1851 | billy.tucker@gmail.com | 1246 Hillcrest Rd | Tampa | FL | 33679 | null | — |
| PRV | PRV-22972 | 2026-05-14T21:28:05Z | Dylan | F | ·Wheeler | ·20000126 | — | — | 17058103344 | — | — | ·UNKNOWN | ·null | null | — | N/A |
| PRV | PRV-28936 | 2026-09-14T11:55:22Z | ARNOLD | U | KETHLEEN | 2/3/1967·· | UHC-42875-96 | •••-••-5525 | 18216902371 | null·· | 5324 Willow Court | Minneapolis | ·MN | 55496 | — | UNKNOWN |
| PRV | PRV-20476 | 2026-02-12T18:24:10Z | JULIE | — | WASHINGTON | 1939-10-25 | UHC-19375-27 | — | 466.201.5517 | - | 4718 Union Street | Scottsdale | az | 85298-3115 | - | NULL |
| PRV | PRV-29075 | 2026-05-03T17:43:29Z | ABIGAIL | — | MOORE | 3/11/1998 | N/A | ·- | (510) 362-2691 | — | 59 Mountain View Dr | Charlotte | NC | 28241 | UNKNOWN | NULL |
| PRV | PRV-24728 | 2026-05-01T03:27:45Z | ·Daniel | — | ·Ramirez | 19920915·· | UHC-57427-66 | •••-••-8451 | (672) 771-5403 | DANIEL.RAMIREZ7@ICLOUD.COM | 815 Sunset Blvd | MIAMI | FL | 33128 | - | UNKNOWN |
| PRV | PRV-28098 | 2026-01-21T23:31:00Z | Hiroshi | A | Moore | 1950-09-08 | null | •••-••-3113 | 334.945.6011 | hiroshi.moore96@gmail.com | 952 Union Street | Glendale | AZ | 85388 | - | UNKNOWN |
| PRV | PRV-29569 | 2026-06-06T18:21:39Z | STEPHEN | — | RUIZ | 1952-07-01 | UHC-29193-51 | — | NULL | — | 2175 Highland Avenue | Tampa | ·Florida | 33605 | — | 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-19T19:54:25.425Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty