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

All sources, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
ENRENR-1299202026-01-13T19:12:00Z·Aguilar, RuthK—07/04/1995UHC-73106-42•••-••-6144·6329985888ruth.aguilar19@yahoo.com7008 CEDAR LANE·MESAAZ85207GRP-1207MEDICARE-ADV-A
CLMCLM-4290652026-06-08T22:07:27ZLauren—Silva—UHC-22401-06—+1 248 749 8456lauren.silva70@aol.com7322 Ocean AvePhoenixAZ85099-7915··—UNKNOWN
ENRENR-1166992026-09-16T15:22:53ZRANDYF.DIXON1991-08-06UHC-17679-69N/A8345020074—6924 Willow CourtAtlantaGA30381··GRP-6791NAVIGATE-HMO
TPATPA-501192026-08-26T08:47:59ZEstrada, Walter——1987-03-07—•••-••-5235—null1573 Indian School RdEden PrairieMN·55304NULL—
CLMCLM-4290722026-08-15T08:46:32ZSEAN··—PAYNE··Oct 8, 1996UHC-09440-80null(703) 786-3702—5135 Sage CtTempeAZ85211—MEDICARE-ADV-A
ENRENR-1232972026-08-03T11:39:11ZGEORGEKFERNANDEZ··Sep 21, 1972UHC-36073-65•••-••-7609519-460-3935N/A7541 Park PlaceColumbusOH43244GRP-6396SELECT-EPO
PRVPRV-237462026-04-19T20:52:25ZAMY—ARMSTRONG08-05-1999UNKNOWNUNKNOWN16942393198UNKNOWN4161 Apache BlvdPhoenixAZ85069-—
ENRENR-1276202026-09-29T02:19:52ZLori—Ruz2004-02-12UHC9645994•••-••-2439(816) 684-4985—5235 FOREST AVENUEMiamiFL33117GRP-9936MEDICARE-ADV-A
CLMCLM-4101382026-05-08T02:56:39ZSamuel··Tucker1993-06-19UHC-53744-28—2689716961SAMUEL.TUCKER@GMAIL.COM·5881 Apache BoulevardChandlerArizona··85224GRP-7322—
CLMCLM-4322212026-05-30T07:31:17ZJerry—Chapman1997-09-24UNKNOWNUNKNOWN(921) 982-5498UNKNOWN5719 Lake View RoadMiamiFL·33199GRP-5070··N/A
ENRENR-1112372026-09-21T11:03:59Z GaryVDay07/20/77UHC-44898-69•••-••-8317(429) 677-5374N/A5985 Jefferson AveDallasTexas75298GRP-0565CHOICE-PLUS-PPO
CLMCLM-427386 2026-07-14T10:11:55ZMeiVVasquez1958-03-22N/A··UNKNOWN-mei.vasquez@aol.com—null—·N/AGRP-8142····
CLMCLM-4267752026-01-12T20:57:23ZBradley—Weber1991-06-17UHC-33663-44N/A722-482-9611—6986 PINE DRIVEMiamiFL33102GRP-6741NULL
ENRENR-1075862026-06-25T00:27:37ZHENRYAMENDEZ1981-08-06·uhc-27527-73•••-••-3891·null—·7683 Meadow LnJacksonvilleFL··—GRP-8516···SELECT-EPO
ENRENR-1279662026-09-15T20:37:42ZBILLY—NUNEZ1963-06-06UHC-87066-40•••-••-1974—billy.nunez@icloud.com7160 Sunset BlvdTucsonAZ85731·GRP-6429MEDICARE-ADV-A
CLMCLM-4227302026-07-03T23:49:12ZFuller, Benjamin——1964-03-15····-+1 216 273 9017null4702 Spring StNashvilleTN·37237GRP-7658MEDICARE-ADV-A
PRVPRV-228392026-07-26T21:42:29ZGeorge—Banks1987-07-19UHC-71568-86UNKNOWN2085759809george.banks@aol.com8067 Washington StColumbusOH43209-7355—NULL
PRVPRV-200522026-03-10T14:06:25ZAnthony R—Maldonado1958-06-17·UHC-57454-98—881-629-8459UNKNOWN7136 SAGE CT #287·DallasTX75246UNKNOWN··-
ENRENR-1262672026-05-25T14:30:14Z—X.—1994-02-07UHC7210405•••-••-4588860-351-9447roy.ruiz@icloud.com8276 Spring StreetLas VegasNVNULLGRP-8359NAVIGATE-HMO
ENRENR-108896 2026-04-14T15:53:56ZGLORIAC.··VASQUEZ1970-07-18··UHC-13633-38•••-••-1643·(739) 426-3633·gloria.vasquez@proton.me7394 Meadow Ln #747San AntonioTX78203GRP-4787MEDICARE-ADV-B
CLMCLM-4117072026-01-26T17:34:01ZAdnrea—Guerrero·Sep 12, 1953N/A-+1 408 450 0877··UNKNOWN345 Hillcrest Rd Apt 22JacksonvilleFL32217-NULL
CLMCLM-4309742026-03-10T12:48:51Zdiane—olson11-07-1981—•••-••-1304··null4637 Lake View Road #174JacksonvilleFL32257GRP-3112CHOICE-PLUS-PPO
ENRENR-1090282026-07-10T07:21:56ZGREGORY—WILLIS1955-05-27·UHC-33667-24•••-••-8854(874) 272-0651GREGORY.WILLIS84@AOL.COM6304 PALM DRSeattleWA98104GRP-9188OPTIONS-PPO
ENRENR-1270542026-02-26T08:39:50ZNancy—Ferguson4/10/1971UHC-02890-41•••-••-0209(989) 481-3491NANCY.FERGUSON@HOTMAIL.COM664 Grand AvenueAtlantaGA30319GRP-6375CHOICE-PLUS-PPO
ENRENR-1409672026-10-07T04:48:32ZRALPHS.NGUYEN1959-03-10UHC-34004-03•••-••-2511758-236-8243ralph.nguyen@hotmail.com3418 APACHE BOULEVARDTampa··FL33632GRP-0548MEDICARE-ADV-B··
ENRENR-1364892026-04-11T06:56:59ZWAYNEZCRUZ09/07/1964UHC-31174-70•••-••-3355·4311718wayne.cruz@icloud.com5670 INDIAN SCHOOL ROADSeattleWAN/AGRP-9701··SELECT-EPO
ENRENR-1094052026-09-17T17:33:25ZAnaIPrice1949-12-07UHC6490114•••-••-7138551-203-1933—605 BroadwayJacksonvilleFL32257GRP-1942SELECT-EPO
PRVPRV-257942026-02-06T16:54:48ZVictoria—Howard1961-09-20UHC-87606-64•••-••-9870·5888107099null9758 Oak StSAN DIEGOCA92142-3316N/A—
CLMCLM-4152632026-07-24T06:20:49ZPamela—Vargas01/23/1976-•••-••-9974UNKNOWNN/AN/A—UNKNOWNN/A·GRP-6109UNKNOWN
ENRENR-1341672026-09-16T03:43:00ZMorgan, AnthonyY—2001-09-05UHC-23469-62•••-••-97612662700298—5791 Indian School RdScottsdaleArizonaN/AGRP-1140MEDICARE-ADV-A
ENR ENR-1091832026-09-26T03:28:26ZJOYCEY.SANTOSOct 19, 1955UHC-15519-28•••-••-03958255946871NULL6973 MESA DRDenverCO80237GRP-2910··CHOICE-PLUS-PPO
CLM CLM-4028512026-01-08T17:50:21ZChapman, Olivia——1975-01-18N/A•••-••-356016167377091NULL9683 Market StreetEden PrairieMN55397GRP-0269NULL
PRVPRV-275042026-01-21T06:53:20ZETHAN—SPENCER2002-01-09·UHC-46162-88UNKNOWN(280) 748-6166ethan.spencer11@yahoo.com8718 Ocean AvenueAtlantaGA30361-1270nullNULL
CLMCLM-4026332026-02-22T05:00:39ZBryan—Yang1961-08-06UHC-24123-48•••-••-9474——N/AUNKNOWN—nullGRP-7362—
CLMCLM-4319412026-04-25T09:01:29ZDIEGO—DOMINUEZ1985-01-01——(666) 723-2138diego.dominguez@outlook.com····-··—UNKNOWN-OPTIONS-PPO
CLMCLM-4212952026-08-19T10:54:01ZHARROLD—ESPINOZA1984-09-28UHC-90072-37•••-••-1051NULL—3889 CANYON RDGlendaleAZ85302-2147GRP-0792N/A
ENRENR-1231592026-08-27T17:04:28ZBeverly··Hicks1601-89-58UHC-10140-65•••-••-7134····BEVERLY.HICKS30@AOL.COM3610 Bayshore DrHouston·TX77040GRP-0832NAVIGATE-HMO
TPATPA-543192026-01-04T22:36:55ZElijah··—Hanson··2003-03-04——·2764045252—119 Indian School RoadJacksonville··fl32200——
CLMCLM-4102352026-04-13T13:51:10ZJANICE··LOPEZ5/11/1947UHC-64105-04N/A+1 788 316 3428UNKNOWN2564 Lincoln WaySan AntonioTexas78293GRP-2251null··
CLMCLM-4293732026-05-13T09:47:50ZJennifer—Parker19771109UHC-33407-88•••-••-2403494.659.4255NULL241 Forest AvenueAustinTX78716—null
ENRENR-1072232026-06-30T10:20:00ZEmily··Martinez···Aug 11, 2004UHC-84850-46•••-••-7704(678) 673-6831emily.martinez@icloud.com9266 SAGE COURTORLANDOFL32811GRP-2526OPTIONS-PPO
CLMCLM-4306622026-09-15T13:47:05ZCARLARIOS1990-02-14UHC-55056-63N/A-—UNKNOWN—--GRP-5557N/A
ENRENR-1316732026-03-24T11:38:19Z·KellyV.Mendez1964-01-17UHC-91623-04•••-••-6008284-552-0296kelly.mendez77@outlook.com7328 Union StreetEden PrairieMinnesota55374GRP-6306NAVIGATE-HMO
TPATPA-599672026-05-03T03:33:21ZWILLIE—GOMEZ1950-08-17NULL•••-••-0950UNKNOWNnull—N/A··N/A-GRP-2477····
ENRENR-1303092026-09-22T11:15:09ZCAROLYN—BUTLER1996-09-24UHC-60274-91•••-••-0816(312) 536-1293CAROLYN.BUTLER@OUTLOOK.COM116 MEADOW LANE Apt 3DenverCO80250-2055GRP-5560CHOICE-PLUS-PPO
CLMCLM-4009042026-09-01T19:55:00Zalexander—watkinsNov 20, 1942UHC-52797-12-—ALEXANDER.WATKINS@OUTLOOK.COMNULL—nullnullGRP-1643CORE-HMO
CLM CLM-4210422026-01-02T19:55:14ZDOROTHY—ALVAREZ··Nov 6, 1990·UHC-40595-14null8043562146····9758 Oak StTampaFL33657GRP-8775MEDICARE-ADV-A
TPATPA-605232026-05-13T15:03:43ZCAMILA—BENNETT1992-08-15-•••-••-5614——NULL—nullnull—MEDICARE-ADV-B
ENRENR-1391822026-05-27T03:05:58ZAbigail—Cunningham1940-07-17UHC-38115-43•••-••-9293502-817-7506ABIGAIL.CUNNINGHAM@HOTMAIL.COM3547 Ridge RdGilbertAZ85298··GRP-6615CORE-HMO
TPATPA-598212026-02-09T20:15:46ZDixon, Martha——27-12-1980NULLN/A——1052 OCEAN AVEChandlerAZ85299N/A—
100,000 rows, page 76 of 2,000PreviousNext

Bronze layer rules

What is guaranteed for downstream layers

  • As received
    Values are stored exactly as the feed delivered them, including whitespace, inconsistent casing and placeholder tokens such as NULL or N/A.
  • No transformation
    Bronze is never edited in place. Every fix lives in silver and is traceable back here by record ID.
  • Line number preserved
    The line number records each row's position in the source file, so a value can be located in the original extract.
  • Load timestamp
    The load timestamp marks when the row landed in the lakehouse; this batch landed 2026-10-22T12:42:34.794Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty