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-4110482026-09-18T11:59:30ZLauren—Scmhidt1972-01-17—•••-••-0745360-341-9548—4410 Lincoln WayHoustonTX77025GRP-6799··CORE-HMO
CLMCLM-4182432026-07-16T00:40:52Zbrenda—lung1958-12-20··UHC-69208-88—7212471223··brenda.long@gmail.com4604 Washington Street Apt 14GilbertAZ85287N/ACHOICE-PLUS-PPO
CLMCLM-4000732026-02-23T01:36:55ZValentinaDWarren11/17/59UHC-64240-81•••-••-6931——9049 Maple AvenueDallasTX75225-····
CLMCLM-429806 2026-04-20T06:09:31Z·JESSICALHUNT·1981-40-27UHC-73352-65—·776-419-1539—3711 VALLEY VIEW DRIVEMIAMIFL33171GRP-8163MEDICARE-ADV-B··
CLMCLM-4098362026-01-05T17:45:13ZRUSSELL—WAGNER25-09-1974—•••-••-4503+1 414 322 8396-1814 GRAND AVETampaFL33650-OPTIONS-PPO
CLMCLM-4062472026-03-27T07:16:31ZMartha—Rodriguez·1977-06-11UHC-02773-73—(824) 631-3228—3973 Washington StPHOENIXAZ85093-9876GRP-4456choice-plus-ppo
CLMCLM-4286792026-01-13T08:38:04ZMike—Rios23-08-1961UHC-88156-15•••-••-6578N/ANULL9120 LAKE VIEW ROAD··Los AngelesCalifornia90097··GRP-8146null
CLMCLM-4070372026-08-25T08:14:42ZIsabella··—Gomez02/04/1977UHC-25379-25-(899) 245-3642—2400 Willow CtAustinTexas78722··GRP-6433NAVIGATE-HMO··
CLM CLM-4032492026-05-28T22:09:29ZTERESAP.WANGJan 9, 1980··UHC-66405-35•••-••-3572(965) 542-9232NULL1451 Spring StreetLos AngelesCA90051GRP-0425MEDICARE-ADV-A
CLMCLM-4104622026-09-24T21:03:00ZJoe—Lane01/10/74UHC-01685-47—2367518115—1430 Camelback Road·AUSTINTX78797GRP-5695CHOICE-PLUS-PPO
CLMCLM-4285302026-08-03T13:49:45ZEmma····Le2002-11-16N/Anull·5167630412emma.le79@gmail.com··5485 Church StSan DiegoCA92198GRP-5190null
CLMCLM-4293432026-03-07T15:19:57Zfrenk··J.carroll13-04-1958UHC-98820-98•••-••-0995941-679-6873—UNKNOWN··——·NULLGRP-6754—
CLMCLM-4117652026-03-23T13:09:32Z JEFFREY—VAZQUEZ06/12/2007UNKNOWN—5369495497—2458 Lincoln WayHoustonTX—GRP-2814-
CLMCLM-4242762026-06-16T23:48:29ZDeborah··Vargas1944-06-26UHC-22202-05•••-••-3169NULL—4953 APACHE BLVDMinneapolisMN55473NULL—
CLMCLM-4049132026-03-13T02:37:57ZAustin—Wong1961-03-19UHC-52819-86··NULL(757) 995-6047N/A—N/AUNKNOWN-GRP-0242MEDICARE-ADV-A
CLMCLM-4075062026-05-15T03:14:46ZDaniel··—Le1973-04-26N/A•••-••-7375225-327-0364—7309 OAK STTucsonAZ85782NULLNULL
CLMCLM-4146262026-02-15T07:32:06ZKathleenXAndrews1960-05-22UHC-09149-87—-kathleen.andrews77@proton.me—-NULLN/AGRP-7974MEDICARE-ADV-B
CLMCLM-4292892026-05-16T05:43:38ZVIRGINIAYWONGMar 7, 1971——671-435-7218—-····—-nullnull
CLMCLM-4057342026-08-18T03:29:21Zbeverly—hughes1988-06-28N/A•••-••-1537UNKNOWNN/A3148 Cedar LanePLANOTX75003·NULLSELECT-EPO
CLMCLM-4101302026-01-09T10:56:14ZStephanie—Reed1993-01-10N/A··—263-595-0946NULL7427 Church StreetNashvilleTN37269GRP-3167CHOICE-PLUS-PPO
CLMCLM-4229542026-08-04T07:19:48ZLoganWSimmuns1959-06-11UHC-67698-28—9247951154——NULLNULLN/A-N/A
CLMCLM-4125662026-01-27T17:34:21ZKATHLEEN—LANE2601-20-01UHC-31114-80-null—7643 HIGHLAND AVEMiamiFL33193-CHOICE-PLUS-PPO
CLMCLM-4274492026-08-29T02:13:45ZJERRY—THOMPSON2002-05-17UHC-11477-88•••-••-6283674.825.6938—8227 Mesa DriveAtlantaGA30338·····UNKNOWN
CLMCLM-4049882026-02-23T13:50:46ZKennedy, Christina——1985-08-03UHC-24928-35NULL(212) 834-7188null1803 CENTRAL AVE··TUCSONAZ··85706GRP-2701CHOICE-PLUS-PPO
CLMCLM-4155992026-07-11T08:03:20ZAnnaC.Fox1995-06-05N/A··•••-••-4228·(493) 830-2103null—UNKNOWNNULL—GRP-2501N/A
CLMCLM-4020502026-10-14T13:26:54ZNatalie—Palmer19730904NULL—N/A-2173 Forest AveEden PrairieMN·55344-CORE-HMO
CLMCLM-4075312026-04-04T01:20:42ZRoger—White08/05/1948UHC3807845NULLUNKNOWNN/A1413 Meadow LaneMiamifl33135GRP-5884select-epo
CLMCLM-4029712026-01-04T11:11:55ZYUKI—WHITE1954-11-15UHC-76332-15-——·4932 Maple AveDenverCO80255-6391GRP-6888—
CLMCLM-4270372026-05-14T13:32:06ZKyle—Cuok-UHC-80562-19—947.216.3495null8422 Hillcrest Road·TampaFL33671GRP-9648NAVIGATE-HMO
CLMCLM-409897 2026-10-06T03:38:54ZWilliam—Bnaks01-03-1961NULL•••-••-1115-—6816 Spring StreetLos AngelesCA90031GRP-6838·CORE-HMO
CLMCLM-4096142026-08-19T07:07:38ZMason—Muore1976-10-05-•••-••-8028—-1307 Oak Street··DALLASTX75218GRP-1034UNKNOWN
CLMCLM-4023092026-04-04T09:57:16ZDianaTBennett2002-08-21UHC-57282-50—-UNKNOWNN/AUNKNOWN—····GRP-8371null
CLMCLM-4221782026-02-02T11:05:00ZAUSTNI—TUCKER08/12/1954uhc-47758-36NULLNULLnullnull—·NULL—GRP-7146—
CLMCLM-4242202026-01-25T10:18:56ZLOGAN—MOORE1943-06-14-•••-••-22115072632863logan.moore@hotmail.comUNKNOWNNULLNULLnullGRP-8318N/A
CLMCLM-4232452026-04-08T05:41:13Zsophia—lawrence·1989-05-04UHC-54923-39•••-••-1811(254) 428-0562SOPHIA.LAWRENCE90@YAHOO.COMnullN/A——·nullNAVIGATE-HMO
CLM CLM-4285212026-02-06T02:01:35ZHANNAH·DLITTLE1967-01-19uhc-22874-08··628.469.1390——null—-GRP-7460OPTIONS-PPO
CLMCLM-4247292026-10-16T22:18:03ZPhilip—Willis1968-02-27—•••-••-8559—UNKNOWN—N/A—NULL··N/Anull
CLMCLM-4231882026-07-04T22:27:24ZMEGAN—LAWRENCE1963-11-26UHC-76908-83•••-••-2735N/AUNKNOWN5603 Baseline RoadPhoenixAZ85001··NULLCHOICE-PLUS-PPO
CLMCLM-424612 2026-04-05T20:01:46ZPeter—·Patel19450420UHC9996363•••-••-0357-UNKNOWN981 Union StreetCHANDLERAZ85264GRP-9578—
CLMCLM-4275362026-04-08T23:16:35ZBOBBY—WILLIAMSONSep 16, 1981UHC-55721-28--UNKNOWN··7659 MAPLE AVENUEOrlandoFL32879UNKNOWN··N/A
CLMCLM-401011 2026-01-27T18:04:22ZWeber, Justin····—·1948-06-28UHC-21843-63•••-••-278518607039790—9726 PALM DRMIAMIFL33131GRP-7972UNKNOWN
CLMCLM-4065242026-06-28T13:54:19ZCYNTHIA—TORRES03/02/78UHC-94028-02UNKNOWN634-945-5581N/A7270 Park PlGILBERTAZ85256GRP-0738—
CLMCLM-4241342026-03-07T23:22:00ZMarilynP··Ross1968-11-15UHC-88869-42—14714716124N/A4816 Mesa DrCharlotte·North Carolina28298··GRP-0612MEDICARE-ADV-B
CLMCLM-4236252026-01-10T22:30:00ZSimpson, Eric——19981018UHC6577370NULL9843752110—8776 CANYON RDColumbusOhio43289GRP-2713·options-ppo
CLMCLM-4166432026-02-01T12:40:18ZHOWERD—SUSAN1985-08-06—•••-••-13744784911931UNKNOWN6781 Forest AvenuePhoenixAZ85059UNKNOWNNULL
CLMCLM-4312202026-02-26T19:53:34ZDonna—Morris2003-07-27··UHC-81537-62•••-••-9402533-685-1073-7992 Elm StNASHVILLETennessee37284··GRP-5225CHOICE-PLUS-PPO
CLMCLM-4217692026-05-29T03:04:50ZSUE····DAVIS07/24/1957UHC-22832-41•••-••-4866——9258 Ocean AvenueSan DiegoCA92195··nullMEDICARE-ADV-A
CLMCLM-4323682026-07-09T06:34:34ZTeresa—WoodsSep 17, 1968UHC-42550-05—7654510728N/A4912 Hillcrest Rd··CHANDLERAZ85221GRP-3106—
CLMCLM-4219652026-01-15T14:02:28ZJeff—Harrison1942-09-28UHC-17502-07—(559) 290-9024—6635 Canyon Rd #382Las VegasNV89189nullCORE-HMO
CLM CLM-4046672026-09-05T13:06:58ZMargaret—Smith19760115UHC-25071-63N/AN/A—1446 RIDGE ROADChandlerAZ85248-4671NULL—
32,829 rows, page 65 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.722Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty