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

Claims only, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
CLMCLM-4085422026-03-03T01:27:10ZJenniferEBennett1989-01-17UHC-50914-80N/A(554) 746-5644··9197 Baseline RdPhoenix··AZ85036GRP-5277CORE-HMO
CLMCLM-4022232026-09-21T00:05:08ZKimberly—·Crawford10/25/1995UHC-52893-38—2675442722—3927 OCEAN AVEDallasTX75218NULLnull
CLMCLM-4208002026-08-22T06:28:18ZCARLOS—MALDONADO1990-01-17UHC-37202-97•••-••-86945779465880null4567 CEDAR LNMesaAZ85218GRP-0982MEDICARE-ADV-B
CLMCLM-4096072026-09-08T20:45:23Zeugene—coleman··1985-03-07UHC8570384null508-418-0342eugene.coleman7@aol.comN/A—nullN/AGRP-2467NAVIGATE-HMO
CLMCLM-4253762026-03-02T09:20:48ZPHILIP—TUCKER02/21/82UHC-65487-82•••-••-12507326363269null9361 Jefferson AvenueOrlando·FL32873GRP-3717N/A
CLM CLM-4263712026-06-18T18:56:48ZHeather··—Pena2004-03-62UNKNOWN•••-••-09739155561340-6554 Baseline RdTucsonAZ85708GRP-8285UNKNOWN
CLMCLM-4123152026-07-14T18:28:29ZHenderson, Catherine——1986-01-17UHC-95700-75null7679563869catherine.henderson@yahoo.com4276 CHURCH STMiamiFL33140GRP-4025CORE-HMO
CLMCLM-4134162026-09-06T04:04:33ZMiller, Bobby——1995-01-10UHC-03506-53null3713143240N/A3637 Harbor BoulevardTucsonAZ85759GRP-0578NAVIGATE-HMO
CLMCLM-4011432026-07-26T02:12:50ZRebecca··—Garza6/4/1976UHC-50074-12•••-••-1049N/AN/A5159 Mountain View DrGilbertAZ85272GRP-6665CORE-HMO··
CLMCLM-4130022026-03-26T01:00:47ZAngela··Watkins08/02/97UHC-53758-58•••-••-699715518257488—2215 Canyon Road Apt 40TampaFL33613-0831····CORE-HMO
CLMCLM-4221242026-04-12T12:53:41ZSara··Estrada1946-01-01null•••-••-6618·771-362-7179N/A2636 FOREST AVENUEJacksonvilleFL·32276GRP-3275—
CLMCLM-4010192026-09-14T12:29:51ZKimberly—Mejia1977-11-19UHC5631591•••-••-9568UNKNOWN—4850 INDIAN SCHOOL ROADMesaaz85252——
CLMCLM-4085862026-02-09T19:12:33ZDENNIS—ALVAREZ22-04-2004UHC-68394-96•••-••-3334+1 533 205 4449UNKNOWN8893 Maple AveTempeAZ··85287——
CLMCLM-4148102026-09-07T05:02:24ZkathrynPhall11-10-1978··UNKNOWN•••-••-7660340.973.0598-4517 Jefferson AvenuePhoenixAZ85086GRP-9206SELECT-EPO
CLMCLM-4078292026-08-07T12:48:13Zmark—moore19441206UHC-67771-87··null610-568-9554null8179 Ridge RdCOLUMBUSOH43210——
CLMCLM-4122432026-01-26T10:16:03ZVictoria··—·Ross06/16/1978——380-680-5912—8429 Camelback RoadDALLAS··TX75251GRP-5900MEDICARE-ADV-A
CLMCLM-4299262026-08-17T12:55:01ZMariana—Sullivan1995-08-21UHC1396360NULL-—2901 Central AvenueColumbus·Ohio43200——
CLMCLM-4054962026-05-22T18:29:51ZloriAfowler··1927-10-21UHC-41558-85—(378) 249-1059NULL····UNKNOWNnull—GRP-9971OPTIONS-PPO
CLMCLM-4200122026-10-16T04:35:11ZTERRY—COOPER1960-07-24null—(786) 934-6996null6679 Sunset BlvdFresnoCA93752-9801GRP-5356null
CLMCLM-4036982026-06-06T00:49:25ZJONATHANYPARK09-01-1983—•••-••-4257····-NULL—-··UNKNOWN-NAVIGATE-HMO
CLMCLM-4146462026-01-23T09:44:49ZWlliam—Powell01/13/73UHC-92775-03—(455) 479-2134william.powell@icloud.com1719 Ridge RdEden PrairieMinnesota55337GRP-5396··null
CLMCLM-4265502026-07-15T15:24:20ZAmandaR.HillAug 8, 2001··UHC-75623-64UNKNOWN(932) 806-1406NULL6405 Desert Sky Boulevard #144CHARLOTTENorth Carolina28299UNKNOWN··—
CLMCLM-4160912026-05-03T19:25:45Z·CharlotteIGordon11-12-1942UHC3899450•••-••-7381-null4904 OCEAN AVESeattleWA98124GRP-5124NAVIGATE-HMO··
CLMCLM-4142632026-10-10T12:47:50ZJudith··XGomez02/18/44UHC-71940-96nullN/A—NULL—NULL—····—
CLMCLM-4013082026-05-28T00:59:51ZSara······Hall1958-06-02··UHC-08168-65•••-••-8162N/AUNKNOWN7589 DESERT SKY BLVDTEMPEAZ85276GRP-8457CORE-HMO
CLMCLM-4314502026-04-07T22:33:20ZAnna—Weaver··1965-12-26-··-—NULL400 Forest AvenueScottsdaleArizona85221···GRP-9346NULL
CLMCLM-4163602026-07-24T10:20:38ZGABRIEL—ESTRADA1989-03-12UHC-50678-72null4444313872NULLNULL-—null—CORE-HMO··
CLMCLM-4000792026-02-12T14:28:49ZAnderson, Patty··——1974-04-15UHC8290323—-N/A··1229 Desert Sky BlvdCHARLOTTE·NC28235GRP-3065·MEDICARE-ADV-B
CLMCLM-4224842026-06-26T00:08:14ZSamuel—Brown2001-05-09UHC-22101-79•••-••-2553N/AN/A8733 Main StScottsdaleAZ85220GRP-5212MEDICARE-ADV-A
CLMCLM-4202972026-04-20T22:57:48ZCATHERINE—GONZELES1976-10-27UHC-71670-98•••-••-0594··NULL··8551 LAKE VIEW RD··LOS ANGELESCA90032GRP-2086CHOICE-PLUS-PPO
CLMCLM-4056762026-05-26T12:46:35ZMari—Hanzen··28-11-1983UHC-89653-21•••-••-6962··NULL9210 SAGE CTTempeAZ85292GRP-6804NAVIGATE-HMO··
CLMCLM-4120572026-09-15T11:24:17Z·HANNAH—SIMS24-11-1985———NULL9768 Sunset BlvdDallasTX75256—null
CLMCLM-4101012026-06-04T23:29:03ZREBECCA—SCHULTZ1951-02-20N/AN/A342-879-9932——UNKNOWN—N/AGRP-6508—
CLMCLM-4162182026-05-25T14:44:21ZKyle—Rogers1941-02-15UHC4375048•••-••-0703577-203-8067KYLE.ROGERS77@GMAIL.COM628 Pine DrSEATTLEWA98105GRP-2942-
CLMCLM-4115182026-10-05T10:13:18ZPETERA.WONG1650-19-67NULLnull··916.633.3386-1739 CENTRAL AVENUETempeArizona85283-3164GRP-7629SELECT-EPO
CLMCLM-4151782026-09-06T13:55:26ZFrank—Nelson1997-09-14N/A•••-••-1902null····UNKNOWNNULLnull·nullN/A—
CLMCLM-4165892026-09-18T04:31:28ZChristopher····Stewart3/11/2005————3758 Hillcrest RoadMINNEAPOLISMN55435GRP-7623··N/A
CLMCLM-4119322026-09-12T09:01:28Z·Ana···Mejia1990-02-18NULL—nullN/A8489 River RdSan DiegoCA92143GRP-7523OPTIONS-PPO
CLMCLM-4040842026-07-15T15:03:27Z JACQUELINE—BLACK—UHC-52048-14UNKNOWN7868549331NULL3673 Apache BoulevardTucsonAZ85721NULLMEDICARE-ADV-B
CLMCLM-4055042026-09-22T17:29:28ZMichael—Pena25-04-1950—NULL8226938707null4773 Ocean AveGilbertAZ85285GRP-6847CORE-HMO
CLMCLM-4113852026-10-04T07:42:22ZNathan··—Gutierrez12-06-1996UHC-41662-03UNKNOWN573-519-0216NULL834 Pine DrScottsdaleArizona85275·GRP-5117MEDICARE-ADV-A
CLMCLM-4144572026-08-17T05:27:16ZEmma—McDonald·20041211null··3473094169null·2008 CENTRAL AVENUE·JacksonvilleFL32217-null
CLM CLM-4227252026-05-25T22:15:04ZGeraldXArnold1960-12-28··—•••-••-7315UNKNOWN-2154 BAYSHORE DRIVEHoustonTX77001NULLSELECT-EPO
CLMCLM-4255892026-08-27T19:06:24ZDOUGLAS··—EDWARDS1962-05-28UHC-96258-72—(667) 629-8303null-—··—GRP-6568NAVIGATE-HMO
CLM CLM-4212662026-05-05T20:43:08ZChristian—Hayes1963-03-14N/AnullUNKNOWNnull957 Camelback RoadTempeAZ85207UNKNOWNNAVIGATE-HMO
CLMCLM-4050142026-06-25T01:08:25Z·CAMILA—MURPHY1977-05-27UHC-32185-12•••-••-2777--nullNULL-—GRP-7713NAVIGATE-HMO
CLMCLM-4215132026-01-20T16:45:49ZJOE—STEWART1953-02-11UHC-21317-80UNKNOWN····-286 Sage CourtLos AngelesCA90063··GRP-4592CORE-HMO
CLMCLM-4314752026-05-22T01:51:24Z EMILYFDEAN1938-09-11uhc-59103-27•••-••-4015809.575.3906··NULL45 Oak StreetDenverCO80259nullMEDICARE-ADV-A
CLMCLM-4146552026-04-08T20:06:07ZALANZWASHINGTON10/5/1947UHC-41085-50•••-••-7414UNKNOWNNULLnull——··GRP-0605OPTIONS-PPO
CLMCLM-4210142026-08-09T00:27:55ZADAM—WILLIAMSONMar 3, 1977·UHC-12020-33N/A551-280-8766ADAM.WILLIAMSON43@YAHOO.COM2283 Valley View DrMiamiFL·33143-7398GRP-1709MEDICARE-ADV-A
32,829 rows, page 153 of 657PreviousNext

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:40.341Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty