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-4039172026-02-09T13:32:57ZWayne··—Marshall05/04/02UHC-10389-42—-NULL8276 Desert Sky BoulevardOrlandoFL32828GRP-3034MEDICARE-ADV-B
CLM CLM-4091182026-06-15T19:03:02ZFreeman—Joe2007-11-17UHC-44075-78•••-••-3345UNKNOWNNULL7788 MEADOW LNMIAMIFlorida33128GRP-2533null
CLMCLM-4325012026-01-24T00:01:25ZomarI·bryant1987-03-17UHC-89172-02———-—N/ANULLGRP-8678-
CLMCLM-4039762026-09-19T08:40:28Z·Hannah—Nguyen5/8/1972UHC-20168-56N/ANULLhannah.nguyen@hotmail.com8201 Meadow LnDALLASTX75293——
CLMCLM-4180452026-07-09T03:46:08ZLewis, Jennifer——1973-02-23UHC-67406-74null··NULL—3020 Washington StHoustonTX77090-6295GRP-7767OPTIONS-PPO
CLMCLM-4032882026-06-17T11:59:52Zshirley····harveyDec 25, 1994-•••-••-7377NULL-7830 Pine DrCHANDLERArizona·85217GRP-2524·MEDICARE-ADV-B
CLMCLM-4269682026-05-11T19:46:03ZChris—Delgado·-NULLnull-····UNKNOWN—UNKNOWN-·GRP-0956·N/A
CLMCLM-415455 2026-07-04T08:29:27ZEugene—Harper1985-02-04·UHC-02390-23•••-••-9657UNKNOWNNULL7637 CENTRAL AVENUECharlotteNC28280NULLCHOICE-PLUS-PPO
CLMCLM-4257702026-09-08T04:13:01ZAdam—Vega1992-02-01UHC-59055-13UNKNOWNNULL—·3499 Canyon RoadChandlerAZ··85205—OPTIONS-PPO
CLMCLM-4094532026-04-13T16:19:03ZPamela—Yang1945-01-06null•••-••-0593-NULL4873 MARKET STREETDallasTX75230··GRP-7329NAVIGATE-HMO
CLMCLM-4034742026-03-19T19:17:09ZKTAHRYN—PIARCE02/21/39UHC9540116•••-••-8786—kathryn.pierce34@gmail.com9528 WASHINGTON ST··Tampafl·N/AGRP-8811CORE-HMO
CLMCLM-4047302026-03-06T22:15:12ZLuis—JimenezDec 13, 1980UHC-81143-69•••-••-5454null—4600 Forest Avenue··TAMPAfl33661GRP-8007N/A
CLMCLM-4155282026-10-07T21:49:17ZAMYY·WRIGHTJun 1, 1956-—NULLamy.wright@icloud.com295 Meadow Ln #518Tucson·AZ85737GRP-3455NULL
CLMCLM-4305482026-03-19T05:39:46ZDan····Turner1982-06-20UHC-52643-65•••-••-7408nullN/A5490 Lake View RdTUCSON·az85761N/ASELECT-EPO
CLMCLM-4008222026-05-31T07:14:00ZCarl—OBrien19761012UHC-87879-70··3207359504-3482 Jefferson AvenueMinneapolisMN55456GRP-9229MEDICARE-ADV-B
CLMCLM-4140182026-07-23T18:53:43ZMariana R.—Snatiago2006-11-22UHC-36282-56—531-780-7023N/A4386 Jefferson Avenue Apt 23TUCSONAZ·85737UNKNOWNnull
CLMCLM-4086152026-09-20T04:24:28ZFRANCESZPENA1996-11-26UHC-11201-26•••-••-6947null·NULL———····GRP-9545CORE-HMO
CLMCLM-4144322026-01-13T18:58:48ZJustin—Snyder1941-02-25NULLN/AnullNULL6092 Ocean AvenueSCOTTSDALEAZ85205nullSELECT-EPO
CLMCLM-4133012026-03-07T08:07:36ZTeresa—Ford·08/17/2007UHC-20506-45•••-••-47378533456001··—9494 MARKET STREETGilbertAZ85259-—
CLMCLM-4143782026-03-10T15:44:01ZJASON—ORTEGA1941-09-03UHC-52395-15—794-364-8119—8529 Indian School RoadSeattleWA98166GRP-0222CORE-HMO
CLMCLM-4265162026-08-05T23:11:55Z John··—·Payne12/1/1947UHC-58602-12··N/A—4417 HILLCREST RDAtlantaGA30363—NULL
CLMCLM-4299012026-03-14T12:53:16ZMark····Nelson1957-10-06N/ANULL—-3833 Desert Sky BoulevardLAS VEGASNVnullGRP-0669MEDICARE-ADV-B
CLMCLM-4101762026-03-27T16:16:53ZCHRISTINE—MORALES19-01-2007UHC1812175•••-••-6430(567) 467-7874NULL9879 Lincoln WayFRESNOCA93702··GRP-7144—
CLMCLM-4183682026-01-30T15:21:20ZBrandon—Graham1998-03-03UHC-81812-78•••-••-945912115434560-——UNKNOWNUNKNOWNGRP-0555SELECT-EPO
CLMCLM-4297572026-03-21T08:08:05ZMills—James10/16/1982UHC-21607-68NULL489-674-5749—9312 BroadwayLos AngelesCA90068-5576-N/A
CLMCLM-4137932026-05-31T09:56:28Z·DENISEIORTEGA2005-09-20UHC-19461-15NULL·15596106358—7305 Maple AveSeattleWA98162GRP-2791OPTIONS-PPO
CLMCLM-4313682026-08-14T01:56:49ZMartinez, Cynthia——9/25/1996UHC7351661•••-••-3464N/AN/A7315 BroadwayGilbertAZ85227nullmedicare-adv-a
CLMCLM-4278792026-06-16T15:12:38ZJoyce—Nunez1991-01-18UHC-97504-31•••-••-4869NULL—·6894 Desert Sky Blvd #693SeattleWA—N/ANAVIGATE-HMO
CLMCLM-4046452026-05-22T16:47:18ZANGELA—CHAPMAN15-05-1938UHC-53091-93•••-••-1623——UNKNOWN—NULLNULLGRP-2060NAVIGATE-HMO··
CLMCLM-4143352026-06-24T13:19:06ZMariana—Parker2008-11-14UHC-18863-52•••-••-7913·8676421234null9046 CHURCH STREETGilbert··AZ85224-1881UNKNOWN—
CLMCLM-4250542026-10-05T15:24:01ZMARK··——1941-03-17——(445) 449-0533null6407 SPRING STREETJACKSONVILLEFL32232GRP-9934CORE-HMO
CLMCLM-4013382026-10-09T02:51:55ZLynda—Greene1979-07-12nullUNKNOWN—UNKNOWN··655 Central AvenueLas VegasNV89170NULLN/A
CLMCLM-4114652026-08-02T05:58:32ZANTHONY—GUERRERO1972-11-10UHC-93685-60•••-••-9390NULLUNKNOWN·6030 MAIN STAustinTX78733GRP-2909—
CLMCLM-4287092026-01-28T02:08:04ZHiroshi—Herrera1979-01-23—•••-••-52094822735360—4577 Union StreetPlanotx·75018——
CLMCLM-412817 2026-06-25T04:11:08ZRalph—Campbell1989-10-10UHC-69425-15-5816600304N/A4022 Main StAtlantaGA30392GRP-1319NULL
CLMCLM-4186152026-09-21T22:12:24Zrachel—arnold11/3/2006UHC-88152-78N/AUNKNOWNUNKNOWN5388 Highland AveAustin·TX78705GRP-2858·N/A
CLMCLM-4182032026-06-19T00:46:08ZTHOMAS—BARNES1958-12-14·UHC-50248-95··null—4530 Ridge RdPLANOTX75041GRP-9899SELECT-EPO
CLMCLM-4283052026-07-12T20:38:59ZJerry··IPerkins·1988-01-07null•••-••-2043809-755-5262jerry.perkins@aol.com9878 Desert Sky BoulevardAtlantaGA30380-3034—CORE-HMO
CLMCLM-4211302026-10-17T10:41:10ZDoris, Bell——1957-03-09UHC-49343-44•••-••-52956277660285N/AN/A-·nullNULLGRP-4730—
CLMCLM-413055 2026-09-05T00:12:55ZVIRGINIA··FDOMINGUEZ1997-03-24UHC-47834-81··NULLN/AN/A9376 Elm St Apt 25OrlandoFL32846—OPTIONS-PPO
CLMCLM-4253952026-04-22T08:59:44Zwayne—bennett1948-01-25—N/A—UNKNOWN4348 Maple Ave Apt 32TampaFL33602GRP-7843N/A
CLMCLM-4055912026-03-26T04:54:42ZLawrence, Jose——1967-12-22··UHC-16741-15··•••-••-3883(233) 889-9604-·4669 Lincoln WayPlanoTX75040-4130NULLOPTIONS-PPO
CLMCLM-4113622026-09-23T20:06:36ZMarcusCWong10/05/2006UHC-03574-75—501-257-4386—8541 DESERT SKY BLVDMESAAZ85278GRP-9982—
CLMCLM-4004062026-09-13T07:19:50ZAaron··—Harper2008-11-02N/A—289-634-1496null3658 Market StreetScottsdaleAZ85237·GRP-7940UNKNOWN
CLMCLM-4211832026-05-16T14:00:34ZgaryM.guerrero12/10/85—•••-••-538514105945149N/A5571 JEFFERSON AVELos AngelesCA—GRP-9963··OPTIONS-PPO
CLMCLM-4201212026-08-21T04:09:15ZJacqeuline—Ferguson1974-09-25UHC-12789-54——null····-UNKNOWN-GRP-8018null··
CLMCLM-4113472026-10-05T06:44:20Z Bill··—Dunn6/10/1953UHC-72312-69•••-••-8245778-364-2545-—N/A——UNKNOWNCORE-HMO
CLMCLM-4052812026-06-19T13:07:30ZJudith····Harris9/18/1938UHC-25584-49•••-••-7769——····———·GRP-7705OPTIONS-PPO··
CLMCLM-4318322026-08-04T19:51:05ZBruceS.Johnson··1979-07-16UHC-57855-96··•••-••-7435331-449-2617UNKNOWN1021 Meadow Lane #391·PlanoTX75019N/ACORE-HMO
CLMCLM-4179032026-04-17T10:44:52ZBRUCE—HOLMES1987-02-03UHC-07074-32•••-••-3219N/A—4044 GRAND AVEMinneapolisMN55423GRP-1662SELECT-EPO
32,829 rows, page 1 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
    line_no records each row's position in the source file, so a value can be located in the original extract.
  • Load timestamp
    loaded_at marks when the row landed in the lakehouse; this batch landed 2026-10-21T12:37:53.958Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty