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-4176482026-04-24T08:07:47Z OLIVIASGILBERT5/17/1944N/A·UNKNOWNnull-3145 Willow CtGilbert··AZ···85229—-
CLMCLM-4263702026-02-03T23:20:19ZMei··YReyes1945-08-10null•••-••-310912285300824NULL1048 MAIN STREET Apt 3··Jacksonvillefl32241—NULL
CLMCLM-4150602026-08-24T01:36:30Zdiana—russellDec 27, 1941··UNKNOWN——diana.russell@hotmail.com6622 Mesa DriveLas VegasNV89164NULL—
CLMCLM-4256132026-03-25T23:28:41Zlauren—·ray1956-01-12UHC-59761-26•••-••-0043·13568097738N/A9749 Meadow LaneOrlandoFL··32822GRP-3023—
CLMCLM-4095772026-07-03T02:18:28Zkathryn—guzmanNov 14, 1939--3979915488—200 River RdScottsdaleAZ85260-0432GRP-0781NAVIGATE-HMO
CLMCLM-4051312026-01-09T14:46:38Z Carl··Davis1987-07-12-N/A·(509) 881-0468null4425 Union StScottsdaleAZ··85254GRP-7301CORE-HMO
CLMCLM-4023632026-05-16T09:51:30ZPeterL··Vazquez2002-04-11UHC-44962-11•••-••-5361UNKNOWNUNKNOWN8624 Cedar LnTempeAZ85219-5732GRP-6447UNKNOWN
CLMCLM-4036022026-07-11T20:29:35ZMary—Edwards1949-09-06UNKNOWN•••-••-9533-—7363 Forest AvenueMiamiFlorida—GRP-1546N/A··
CLMCLM-4086372026-10-12T15:50:56ZJON—·CARLSON1996-03-01N/A··•••-••-31566975226723··null8009 Jefferson Avenue·DallasTX75250null—
CLMCLM-4245982026-04-21T18:59:13ZJeanH.Guerrero··1986-10-08UHC-68510-86—N/AN/A681 MAIN STLos AngelesCA90063GRP-7612·CHOICE-PLUS-PPO
CLMCLM-4175942026-04-12T12:02:29ZVICTORIA—TUCKER1990-07-28·UHC-76378-52—null—1068 SAGE CTTAMPAFL33686·GRP-7199—
CLMCLM-4292312026-05-30T19:29:35Zarjun—meyer2006-05-24UHC2564722UNKNOWNN/AARJUN.MEYER@AOL.COM—--—GRP-1559CHOICE-PLUS-PPO
CLMCLM-4229942026-08-12T06:58:49ZBettyGGomez1977-06-09·UHC-79259-25•••-••-5954·null—347 Main StTampaFloridaUNKNOWNN/AMEDICARE-ADV-B
CLMCLM-4079532026-10-18T08:23:53ZPRIYA—NELOSN2/3/1961UHC-65947-09•••-••-8121NULLUNKNOWN····N/A—N/A-—
CLMCLM-401631 2026-07-10T14:45:14ZWalsh, Jerry——9/24/1995UHC-81721-07•••-••-4852600-456-2286———-—GRP-7951null··
CLMCLM-4321272026-04-28T22:21:11ZMargaret—Sullivan04/17/05UHC-11975-47—234-925-4587—-N/A-NULLGRP-1911null
CLMCLM-4205272026-07-30T23:23:09ZGEORGETLOPEZ1951-11-13NULL•••-••-097815942626767null9472 Sunset BlvdSan DiegoCAN/AnullUNKNOWN
CLMCLM-4043672026-08-06T11:47:36ZEMMA—WATKINS1958-10-01UHC-88815-82———9371 Mountain View DrAtlantaGA30386··UNKNOWN
CLMCLM-419026 2026-06-24T02:08:25ZJACK—·JENKINS·1952-00-87UHC-75461-96•••-••-9773—NULL7076 Church StreetATLANTAGA30329GRP-9814—
CLMCLM-4241632026-04-04T20:40:16ZGARY—LARSON1949-11-11—NULL(675) 572-2822UNKNOWN-N/AUNKNOWN—GRP-6291NAVIGATE-HMO
CLMCLM-4174112026-09-25T12:28:55ZPriyaDCarter1997-03-24UHC-13058-44····+1 794 819 5829-··6305 Main StHoustonTX·77094GRP-7193OPTIONS-PPO
CLMCLM-4094002026-06-04T00:04:17ZArjun·RSullivan11/02/67—•••-••-6878709-830-8941N/A·5726 BroadwayJACKSONVILLE·FL32202GRP-9442N/A
CLMCLM-413465 2026-07-06T03:59:46ZISABELLA—NELSON1992-04-21—null·(520) 333-5188—2964 Grand Avenue #765AUSTINTX78797GRP-1444NULL··
CLMCLM-4253512026-10-12T09:45:55ZCarl—Hunt1952-07-25—•••-••-8846+1 347 303 5200—8099 Spring StSan AntonioTX78203GRP-9837CORE-HMO
CLMCLM-4070532026-05-08T12:53:41ZAngela—Lynch··15-05-1978UHC-19976-83—NULL—·3496 Mountain View DriveOrlandoFL32812-—
CLMCLM-4109532026-08-25T18:52:12ZDiaz, Alex——2001-08-14-•••-••-3103UNKNOWNUNKNOWN·3718 Mountain View DriveEden PrairieMN·55318-7472GRP-7306MEDICARE-ADV-A
CLMCLM-4325752026-08-15T04:05:04ZMelissaRAllen··1954-02-25UNKNOWNUNKNOWNnull———N/A-—OPTIONS-PPO··
CLMCLM-4029222026-09-19T12:09:51Zbenjamin—evans··1975-07-16UHC-28667-26-—-2265 CEDAR LNSan DiegoCA92180GRP-1801SELECT-EPO
CLMCLM-4264982026-03-01T10:32:05Zwayne—rodriguez01/02/1962UHC-24236-32N/A——·1949 Lake View RoadDenverCOUNKNOWNGRP-0133—
CLMCLM-4025462026-10-03T21:38:29Z·jennifer—baker02/01/1956··—(582) 242-2029NULL6553 Apache Boulevard·SacramentoCA95813GRP-0113—
CLMCLM-4057292026-02-17T22:05:22ZSHARON—WEST11-11-1984UHC-67402-41•••-••-89079416751364UNKNOWN773 Hillcrest RdOrlandoFL··32852-6727··GRP-9511—
CLMCLM-4265272026-05-09T10:55:08ZSTEPHANIE—MOORE1978-07-04····•••-••-4722——4646 Ridge RoadSan AntonioTX78256··—N/A
CLMCLM-432546 2026-07-30T10:54:41ZJudy—Wells1989-06-18—•••-••-9859(521) 657-9440N/A5771 Indian School RdScottsdaleAZ85236·GRP-6861N/A
CLMCLM-4247982026-07-31T13:13:01ZKeith—Silva1987-02-11UHC-11375-71-·NULLkeith.silva@hotmail.comnull-··—UNKNOWNUNKNOWNMEDICARE-ADV-B
CLM CLM-4134932026-05-21T10:34:43Z RICHARD—GREENE1997-02-19N/A•••-••-3971——1273 Spring StreetMiamiFL33191nullMEDICARE-ADV-B
CLMCLM-4242332026-05-04T20:58:19ZPhilip—Warren1946-04-26UHC-00906-32•••-••-3025—-416 MEADOW LANENashville·tn37260GRP-4893····
CLMCLM-4022452026-02-01T07:41:07ZNickXSantiago1991-10-19UHC-71532-02—3803462450—-UNKNOWNN/AN/AGRP-5116—
CLMCLM-4271462026-05-27T04:23:01ZPriya—Coleman1979-02-22N/A—N/A—8189 Canyon RoadPHOENIXAZ85027GRP-0405UNKNOWN
CLMCLM-420668 2026-05-01T07:06:11ZLogan—West1958-12-16UHC-35846-32•••-••-6270UNKNOWNNULL9527 BroadwayOrlandoFL32882-—
CLMCLM-4218832026-08-17T20:52:20Z·Philip—Williamson1969-09-05·UHC6120681•••-••-3970—N/A4970 LAKE VIEW ROADAtlantaGA30396··GRP-4591CORE-HMO··
CLMCLM-4076802026-07-16T23:49:01ZVALENTINAAPRICE20040424UHC-82856-79•••-••-6672(647) 720-9931—9812 Meadow LnPhoenixAZ·85032—OPTIONS-PPO
CLMCLM-4297902026-02-06T22:22:25ZNancy··—Marshall1961-03-10UHC-91729-28•••-••-4577null—9776 Main StreetPhoenix·Arizona85073GRP-6397-
CLMCLM-4177932026-07-30T01:39:04ZARJUN—JIMMENEZ··1994-06-09—•••-••-8469280-805-2611NULL7369 River Rd Apt 20··PHOENIXAZ85061GRP-6473—
CLMCLM-4115452026-10-09T17:34:18ZMARIA—SNYDER·1966-05-27UHC-84820-97null844-878-0896-5805 Mountain View Drive #934DenverCO80255GRP-9830CHOICE-PLUS-PPO
CLMCLM-4064522026-06-15T10:31:03ZHenry—Dixon2006-04-03UHC-32289-04•••-••-97639067851505HENRY.DIXON76@OUTLOOK.COMnull———nullSELECT-EPO
CLMCLM-4210032026-06-05T17:02:18ZDEBRA—GARZA1984-04-28uhc-51147-76•••-••-5759UNKNOWN—6588 Ocean Avenue·ColumbusOH43243nullN/A
CLMCLM-4092892026-04-06T06:15:39ZBENJAIMN—MORENO2000-08-10UNKNOWN•••-••-5495—NULL1642 MAPLE AVEAUSTINTX··78737GRP-9567NAVIGATE-HMO
CLMCLM-4199492026-06-04T21:27:18ZEvelyn—Le··12/9/1993UHC-70727-05•••-••-8676534-219-5395NULL1620 CENTRAL AVE #910GlendaleAZ85349-7402GRP-1213NAVIGATE-HMO··
CLMCLM-425111 2026-03-29T21:09:08ZTeresa—Rivera1967-12-18NULLNULL—null9292 Forest AvenueFRESNOCA93717··GRP-0339N/A
CLMCLM-4310082026-09-25T18:28:41ZFATIMAIPRICE11/18/45—•••-••-8816——3822 Lincoln Way··San DiegoCA92174null—
32,829 rows, page 142 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.324Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty