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-4281172026-04-24T04:36:35Z·CHRISTOPHER—·WELLS1953-04-09·UHC-08027-82····-NULL8935 Baseline RdJacksonvilleFL32233GRP-5402null
CLMCLM-4195542026-10-05T21:10:40ZBRITTANY—JENSEN05/17/06UHC3779878NULLN/A———-—GRP-3102—
CLMCLM-4320632026-09-22T11:31:38Z·madison··ramos7/3/1998UHC3768341•••-••-4239986-984-9123madison.ramos@gmail.com5185 Central AvenueMinneapolisMN55409GRP-6305MEDICARE-ADV-A
CLMCLM-4304452026-05-22T00:14:05ZBradley—Padilla1960-11-01—null9146679296—863 INDIAN SCHOOL ROADTampaFL33610—-··
CLMCLM-4288422026-04-25T07:59:41ZPeter——1939-10-02UHC-67988-31•••-••-3422····—4179 River RdCharlotteNC28202UNKNOWN—
CLMCLM-4214342026-10-17T05:59:50ZMartha··MedinaOct 18, 1958UHC-68694-09NULL—martha.medina59@icloud.com2912 River RdDenverCO80285——
CLMCLM-4270522026-02-18T19:34:32ZBryanJCastro1947-12-01-•••-••-7227UNKNOWN—3934 CENTRAL AVEDALLASTX75200GRP-4080NAVIGATE-HMO
CLMCLM-4115672026-09-27T11:37:58ZTIMOTHY—PARK1996-02-21UHC-02264-61-911-205-7316—2407 Palm DrAtlantaGA30371—N/A
CLMCLM-4103992026-04-19T01:32:39ZAnaK.Robinson1955-02-02UHC-45904-17··—UNKNOWNNULL3989 Indian School RoadSAN DIEGOCA———
CLMCLM-4255012026-08-20T21:22:20ZRussell··—Hudson10/13/1962UHC-66326-40•••-••-0910—null8985 Hillcrest RoadColumbusOH43252GRP-3434··NAVIGATE-HMO
CLMCLM-4227102026-02-07T05:36:47Z Fisheer, Jenny··——1979-08-18UHC-09837-45—····-nullnullnull—·NULL—
CLMCLM-4071242026-09-23T23:32:44Z sandra—guzman··11/26/07UHC3550064—3470860null7954 DESERT SKY BOULEVARDHoustonTexas77083GRP-5336·OPTIONS-PPO
CLMCLM-4318282026-03-26T11:28:34ZSimpson, Valentina··——1978-02-15UHC-84824-46•••-••-96542424776764———····NULLGRP-9884—
CLMCLM-4212452026-09-09T01:48:18ZGary—Peters1945-08-17null•••-••-8575nullGARY.PETERS56@HOTMAIL.COM··355 Mesa DrPLANOTX75001GRP-9737CHOICE-PLUS-PPO
CLMCLM-4117392026-02-22T02:37:44ZTucker, Priya——1981-02-07UHC-26060-45—nullUNKNOWN··619 Ocean AveJacksonvilleFL32248GRP-3235MEDICARE-ADV-B
CLMCLM-4028802026-10-11T08:35:00Zdiego··Avaldez1962-04-06··null•••-••-3632·+1 576 845 3658NULL··315 PALM DRIVETucsonArizona85799·GRP-1473CHOICE-PLUS-PPO
CLM CLM-4086682026-01-21T04:29:27ZRuth·IFisherOct 20, 1968N/A··NULLruth.fisher@outlook.com5096 BroadwayLOS ANGELESCA90091GRP-2348··null
CLMCLM-4273822026-07-08T22:04:22ZStephanie—Bennett19900204——(327) 971-5548—9669 Maple Ave·GLENDALEAZ—GRP-0297OPTIONS-PPO
CLMCLM-4066882026-06-16T20:49:16ZCharles—Larson2003-10-06UHC-12794-92•••-••-1220686.462.2790———N/A-——
CLMCLM-4281712026-04-03T18:31:40ZMEGAN—PREZ1984-12-22UHC-14015-28•••-••-615914484811664NULL1460 BAYSHORE DRIVEMiamiFL33161GRP-2028·OPTIONS-PPO
CLMCLM-4206532026-10-11T12:57:55ZCarpenter, JacobZ—nullUHC-24720-46null-N/A5511 Mountain View DriveTempeAZN/AGRP-4956null
CLMCLM-4017382026-07-28T22:06:35Zbetty—long1965-10-14UHC-18001-61-NULL—6155 BASELINE RDCOLUMBUSOH··43230GRP-9142—
CLMCLM-4272212026-01-26T01:03:18ZBrian—Hicks·1999-01-28····null906-299-7638NULL4648 Hillcrest RoadTucsonAZ85783UNKNOWNSELECT-EPO
CLMCLM-4280782026-06-07T09:26:48ZcherylNmartinezMay 6, 1982UHC-03389-40•••-••-2402··N/A9766 BroadwayLOS ANGELESCA90068GRP-7545OPTIONS-PPO
CLMCLM-4295192026-08-09T14:46:52ZJuliaD.Luna1971-02-15—•••-••-0988N/AUNKNOWN8584 Main StTampa·FL33678nullnull
CLMCLM-4109332026-04-25T11:56:37ZJesseDWarren·11/17/2008UHC-51170-46•••-••-7033——7100 Hillcrest RdGilbertAZ85243-4942—OPTIONS-PPO
CLMCLM-4299602026-07-30T04:52:02ZNANCYL.·CARR1951-03-15UHC-37559-94—3695548481-9697 Elm StEden PrairieMN55390GRP-3206OPTIONS-PPO
CLMCLM-418312 2026-08-07T01:22:44ZLawrenceW.Lane08/09/06UHC-10400-82UNKNOWN(950) 239-8303—2237 Camelback RdLos AngelesCA90083GRP-4667UNKNOWN
CLMCLM-4241462026-02-06T01:55:47ZMichael—Ferguson8/2/1991UHC-81936-57N/A708.483.6813null6568 Highland AvenueAtlantaGA30341GRP-8129MEDICARE-ADV-B
CLMCLM-4012312026-01-11T23:51:16ZDennis—Matthews1968-10-04null··—3669605—4603 DESERT SKY BLVDFresnoCalifornia·93752GRP-0670—
CLMCLM-4293982026-10-09T01:54:11ZTHERESA—CARTER1968-12-13uhc-04988-64····8186483464null4683 PALM DRChandlerArizona85262UNKNOWN-
CLMCLM-4065292026-08-09T00:08:41ZAbigail—Jackson06/20/1970UHC-80175-96-685-745-1899—2843 Bayshore Dr·ChandlerAZ85292GRP-7009null
CLMCLM-4046242026-01-22T03:01:30ZMendez, JuanD—1945-09-16UHC-10330-89N/A236-996-2654—6100 Oak StMesaAZ85249—-
CLMCLM-4254752026-02-06T18:05:22Z Carolyn—Howard··02-05-1951uhc-95418-97——N/A——N/AUNKNOWN·NULLCORE-HMO
CLMCLM-4128942026-05-25T08:03:05Z Joe··—Richards09/03/45····-null—5655 Ridge RdMinneapolisMN55404GRP-6122MEDICARE-ADV-A
CLMCLM-4041812026-03-13T01:28:57ZAustin, Christina——1968-05-12UHC-18686-11•••-••-8032-NULL··1879 Forest Ave #652OrlandoFL32880NULLnull
CLMCLM-4320382026-07-31T04:39:03ZBOBBY—ORTIZ1946-01-03·UNKNOWN•••-••-4077N/AUNKNOWN4494 Indian School RdMiamiFL33150-4410GRP-7164—
CLM CLM-4081672026-06-27T14:00:23ZCharlotte—Vega··1969-05-09UHC-23171-99•••-••-4860205-436-8369-4574 Ocean AveLas VegasNV89191-—
CLMCLM-4161332026-01-13T23:34:35ZjerryImurray1948-04-17UHC-40805-76—N/Ajerry.murray@hotmail.com3159 Oak StDallasTX75254··GRP-9018—
CLMCLM-4258902026-04-18T01:10:50ZRandy—Edwards04/07/67UHC9027738•••-••-6114(911) 889-0062·N/A1054 Washington StMiamiFL33128N/A—
CLM CLM-4164632026-05-28T10:43:13ZFATIMA—SANDERS1958-04-02—NULL(388) 600-8236—null—NULLUNKNOWNNULL—
CLMCLM-4239102026-04-17T22:32:32ZAlbert—Garrett1982-08-01UHC-12932-13———9517 Desert Sky BoulevardEden PrairieMN55380—-
CLMCLM-4148092026-06-13T21:32:37Z·John—Henry19-01-1944UHC-67530-07•••-••-881318532614998—9524 Desert Sky BlvdATLANTAGA30391-9162——
CLMCLM-415395 2026-09-27T09:33:13Zkathy—·watkins05/26/72UHC-19886-37—811-390-3013—630 Desert Sky BlvdCharlotteNC28297··-N/A
CLMCLM-4164132026-10-09T09:01:09ZSandoval, NancyI—Nov 3, 1983UHC-95939-67•••-••-97379558260487—2398 DESERT SKY BOULEVARDScottsdaleArizona85284-5265GRP-7658—
CLMCLM-4016812026-08-27T13:38:41ZABIGAIL—COLEMAN01/12/51——NULLnull6206 Ridge RdDENVERCO80291GRP-4787-
CLMCLM-4086012026-03-23T15:25:20ZARTHUR—LUCAS1983-09-11UHC-03901-28··•••-••-02234261240NULL2547 OCEAN AVENUENashvilleTN37228GRP-8839MEDICARE-ADV-B··
CLMCLM-4143972026-01-27T06:46:16Zsatiago—miller1969-04-28NULL—13279644892N/A3679 Meadow LaneMesaAZ-GRP-3924·N/A
CLMCLM-4168402026-04-23T23:58:37ZMegan—Harison19871225UHC-84396-20-13183064248NULLN/A—·NULL—null-
CLMCLM-4003992026-09-10T01:06:33ZShirleyR.Watson1997-06-09—•••-••-7700733-258-6650NULL-——nullGRP-5481NAVIGATE-HMO
32,829 rows, page 190 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.635Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty