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-4199742026-02-23T20:07:04ZWeaver, AnnM.—Nov 21, 1980UHC-46632-16—909-239-1968—2201 APACHE BLVDMiamiFL33157-7517—SELECT-EPO
CLM CLM-4151592026-02-23T23:35:17ZEdward—Garcia1942-12-09null•••-••-568414818602544N/A5691 LINCOLN WAYAustinTexas78786GRP-2285CHOICE-PLUS-PPO
CLMCLM-4169132026-04-13T01:28:15Zraymond—stewart8/23/2008UHC-81012-14•••-••-8664—NULL7962 Hillcrest RoadTampaFL·33618-6186·GRP-4733OPTIONS-PPO
CLM CLM-4243262026-05-31T13:53:10Z MarcusEMyers08/13/89NULL•••-••-3811·(481) 577-6632nullN/A--UNKNOWNGRP-8793CORE-HMO
CLMCLM-4075532026-08-08T15:34:42ZJOSH—TURNER2005-08-27UHC-57288-86UNKNOWN——7345 Cedar Lane #264EDEN PRAIRIEMN55377GRP-0508··CORE-HMO
CLMCLM-4141482026-02-09T12:03:33ZTyler—Alvarado1993-03-01UHC-30206-42•••-••-5713692-337-2460—NULL-UNKNOWNN/AGRP-9744UNKNOWN
CLMCLM-4308012026-01-03T19:41:09ZMarilyn—Castillo1980-01-24UHC-80095-34—(559) 386-4702-7402 HIGHLAND AVE··ChandlerAZ85284—CORE-HMO
CLM CLM-4203882026-04-09T23:43:16ZMARYMGARRETTDec 22, 2007—•••-••-4657NULL-2645 LAKE VIEW RD #668PhoenixAZ··85018··GRP-9788·N/A
CLMCLM-4170942026-06-30T22:24:49ZAshley—Olson1984-01-07UHC-61639-29··NULL—-·--—NULLGRP-2214····
CLMCLM-4032992026-05-06T04:05:00ZDaniel—SantigoJul 24, 1998UNKNOWNNULL··—5968 PARK PLACEPhoenixAZ85028——
CLMCLM-4204622026-01-07T14:40:31ZPatrick—Valdez1950-04-27-NULL(638) 374-3885—5078 CANYON RDMinneapolisMN—GRP-8637CORE-HMO
CLMCLM-431878 2026-08-12T03:03:44ZJeremy—Dunncan··1977-04-20N/A•••-••-4548——3976 MOUNTAIN VIEW DRFresno··California93709GRP-5024CHOICE-PLUS-PPO
CLMCLM-4168272026-01-05T10:52:27ZMelissa—Daniels19980101UHC-79454-55N/AN/AUNKNOWN7050 Lincoln Way #530Los AngelesCalifornia90070GRP-6040MEDICARE-ADV-B
CLMCLM-4258632026-10-07T15:11:39ZMATTHEWJSILVA07/09/61UHC-88687-40—null···9834 Indian School RdPlanoTX75013GRP-9957—
CLM CLM-4122342026-06-13T11:06:31ZSophiaYVazquez09/24/1992UHC-24298-39•••-••-0078930-843-8446·UNKNOWN4625 INDIAN SCHOOL RDScottsdaleArizona85205GRP-2858CHOICE-PLUS-PPO
CLMCLM-4323472026-04-17T21:37:41ZJeremy····Scott26-01-1980N/A•••-••-9730(542) 561-4232UNKNOWN·9678 Forest AvenueDallasTX·75225——
CLMCLM-426334 2026-08-16T00:42:27ZAlexisT·Crawford1962-10-07nullNULLN/AN/A9305 Central AveMiamiFL33151GRP-7348—
CLMCLM-4083342026-06-06T05:34:13ZSHIRLEY—HAMILTON1967-04-03·UHC-08692-04•••-••-6407-NULLUNKNOWNN/A··—nullMEDICARE-ADV-A
CLMCLM-4267692026-04-22T02:41:16ZMEGAN—SANDOVAL05-12-2004—null·UNKNOWN··8968 Highland AvenueAtlanta·GA30327··nullN/A
CLMCLM-4219172026-08-05T02:18:33ZVINCENTQHART19590715UHC-21987-76—4755130697—·2540 Meadow LnNashvilleTN37236GRP-9030MEDICARE-ADV-B
CLMCLM-4048122026-06-27T23:02:03ZDavis—Denise1990-08-20UHC-10523-05··•••-••-6458864-606-3712-··5468 Bayshore DrAtlantaGA30340--
CLMCLM-4077152026-07-15T09:08:16Zamy··—elliott1950-07-18NULLNULL—UNKNOWN--——-CORE-HMO
CLMCLM-4164812026-05-09T08:54:45ZArthur—Guzman1951-01-13UHC7238209NULL12469255618—3798 WILLOW CTFresno·CA93717-CHOICE-PLUS-PPO
CLMCLM-405262 2026-06-11T06:21:24ZHELEN—SIMMMONSUNKNOWNUNKNOWNN/A·4919270856N/A711 Oak StreetEDEN PRAIRIEMN55377—null
CLMCLM-4249382026-02-13T20:24:20ZWard, Wayne——1940-05-22UHC-86507-79•••-••-8555—-·8946 Apache BlvdPlanotx75025GRP-5557SELECT-EPO
CLMCLM-4199582026-04-29T15:18:39ZEMMAX.MEYER1950-04-22UHC-01738-01—-——null———OPTIONS-PPO
CLMCLM-4260082026-05-04T04:54:31ZDavid—Jacobs19990103UNKNOWN•••-••-7734-—null—nullNULL—CORE-HMO
CLMCLM-4217522026-08-20T16:16:42ZlindaT··johnonUNKNOWNNULL—(878) 724-5719NULL3980 Baseline RoadColumbusOH43215GRP-6065-
CLMCLM-4265152026-09-01T08:48:15ZKevin—Freeman··1953-09-01UHC-75530-98—(546) 580-2416··—7508 Oak StreetMesaAZ85247UNKNOWNCORE-HMO
CLMCLM-4031272026-03-19T14:53:18ZHowrad, Sean——·03/02/03UHC-69785-40•••-••-9834NULL—1024 LINCOLN WAYGILBERTAZ85274GRP-1475CHOICE-PLUS-PPO
CLMCLM-4239452026-07-29T13:48:53ZSandra—Reed4/5/1985—NULL—sandra.reed@proton.me4807 Central AvenueColumbusOH43264NULLUNKNOWN
CLMCLM-4107032026-09-26T13:02:25ZSarah·DBowman1983-04-27UNKNOWN•••-••-3711(343) 667-9817·UNKNOWN3180 Apache BoulevardLos AngelesCA90041····UNKNOWN
CLMCLM-4300112026-07-22T01:43:00ZLARRY—GARCIA9/11/1952uhc-62291-99-null··—3651 HARBOR BLVD·FresnoCA93741—core-hmo
CLMCLM-4305962026-07-25T22:32:27ZRojas, Stephanie·O—NULLUHC-23206-48•••-••-4620580-934-2163—3938 Main StreetJacksonvilleFL32217-3520GRP-5421SELECT-EPO
CLMCLM-4022982026-05-08T16:50:12ZFatima—Carlson1980-12-19UHC-32664-63—214-566-4632null8974 Spring StLos AngelesCA90048GRP-8557OPTIONS-PPO
CLMCLM-4178952026-06-28T22:07:30ZMark—Arnold1983-10-25NULL—7446563855——N/AUNKNOWN-UNKNOWN—
CLMCLM-4004132026-06-16T05:10:50ZJohn—Gardner1947-11-06··-NULL·N/A6299 Desert Sky Blvd #266Austin··TX78722—CORE-HMO
CLMCLM-4221172026-08-26T08:57:45ZLucia—Stone1995-04-04—UNKNOWNN/Anull2092 BAYSHORE DRTempeAZ85240GRP-1909·SELECT-EPO
CLMCLM-4210192026-04-17T18:35:30ZALICED.WEBB1998-06-27·N/AN/AUNKNOWN—2190 OAK STREETCHARLOTTEnc··28256GRP-3189OPTIONS-PPO··
CLMCLM-4239282026-03-17T11:14:01ZEthan—Wood1961-04-06UHC-73564-91UNKNOWN——5108 Lincoln WayNashvilleTN37258GRP-3279CHOICE-PLUS-PPO
CLMCLM-4219182026-08-05T02:18:33ZVINCENTQHART19590715UHC-21987-76—4755130697—·2540 Meadow LnNashvilleTN37236GRP-9030MEDICARE-ADV-B
CLMCLM-4149732026-09-30T15:41:03ZAmanda—Parker1947-02-27UHC-47167-27—nullUNKNOWN2487 Apache BlvdDenverCO-N/ASELECT-EPO
CLMCLM-4027912026-09-28T02:21:41ZDaniel··Rios1954-08-24UHC-16351-42•••-••-7411(969) 695-4297N/A6945 PINE DRIVESan DiegoCA92196-5792GRP-8827MEDICARE-ADV-B
CLMCLM-4137802026-08-15T08:07:55Z Gloria—·Ray1982-06-02—-823-277-3658UNKNOWN64 Central AvenueTucsonArizona85712·GRP-6219MEDICARE-ADV-A
CLMCLM-4221672026-02-04T07:47:06ZHaroldE.Castillo05/28/1949UHC-59339-91N/A-N/A1101 Church StreetDallasTX75244·GRP-1845OPTIONS-PPO
CLMCLM-4209772026-02-15T16:03:34Z·Ronald—Williammson1983-02-23UHC-04062-47UNKNOWN—N/A3583 BroadwayNashvilleTN37278GRP-4267CORE-HMO
CLMCLM-4137132026-02-08T17:01:58ZSamanthaT.Diaz1998-08-23··UHC-92123-72UNKNOWN7985037N/A1859 Meadow LnTucsonAZ85789-3719UNKNOWNMEDICARE-ADV-A
CLMCLM-4290172026-08-03T07:04:56ZBrenda—Green1966-08-06UHC-46437-60—246.461.9923brenda.green22@hotmail.com4014 Canyon RoadEDEN PRAIRIEMN55348GRP-1377··NAVIGATE-HMO
CLMCLM-4172712026-06-02T23:47:50ZDanielle—Jordan1973-12-20UHC-72650-33UNKNOWN8554587156danielle.jordan49@outlook.com··2275 Hillcrest RdSacramentoCA···95836—····
CLMCLM-4202532026-05-07T14:06:09Z Andrew—McCoy1999-11-03UHC-29060-53N/A—NULL184 BroadwayHoustonTX77031GRP-4420CORE-HMO
32,829 rows, page 52 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:36.703Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty