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-4002792026-07-27T00:52:03ZHeather—Foster2000-04-09UHC-18247-46•••-••-0323··N/A·7943 Central AveMIAMIFL33108UNKNOWNUNKNOWN
CLMCLM-4267472026-01-31T07:41:09Z rusell···marshall19710806NULL•••-••-3032243.714.9342·NULL962 Spring Street #219TempeAZ85278GRP-7294·OPTIONS-PPO
CLMCLM-4137842026-07-21T20:14:45Z GERALD—SCOTT1942-08-24UHC-63185-93———8050 Washington StChandlerArizona85281··—NULL
CLMCLM-4304202026-10-16T11:57:52Z DENNIS—NELSON·02-09-1992UHC-45196-98•••-••-1692N/AN/A8076 VALLEY VIEW DRIVEScottsdaleAZnullnullCORE-HMO
CLMCLM-4073782026-07-25T15:36:08ZMELISSAWHAYES20061023UHC-64851-11UNKNOWN··—N/A5383 BroadwayDallasTX75269GRP-8159MEDICARE-ADV-B
CLMCLM-4072442026-06-26T16:01:34Z ·debbie—jackson07/21/1951·N/ANULL(651) 717-0507N/A·8786 Jefferson Ave #194Las VegasNV89108GRP-3432—
CLMCLM-4230212026-07-28T16:29:34ZHannah—Bailey1947-05-14UNKNOWN—(700) 840-9188UNKNOWNN/A-——GRP-8886OPTIONS-PPO
CLMCLM-425497 2026-05-31T04:06:56Z·Stephen—Cox1959-07-01UHC5946499—-—2758 MOUNTAIN VIEW DRGILBERTAZ85227GRP-3522MEDICARE-ADV-A
CLMCLM-4016512026-03-12T14:18:29ZDORIS—·MARTIN1979-11-14UHC-99173-76•••-••-9876—··2759 OCEAN AVENUEScottsdaleAZ85299—MEDICARE-ADV-B
CLMCLM-4161672026-04-06T11:50:58ZGonzalz, Priya——1965-07-20··UHC-98742-51UNKNOWNnullUNKNOWN12 Main StMesaAZ—·GRP-6875MEDICARE-ADV-A
CLMCLM-4029962026-03-11T18:16:04ZRoger—Park1997-06-19UHC-41871-10•••-••-6872N/A···roger.park@outlook.com5591 Jefferson AveEden Prairie··mn55340—NULL
CLMCLM-4262822026-03-17T15:49:03ZNATHANB.CRAWFORDJun 3, 2002—-837-737-7459null—UNKNOWNUNKNOWN—GRP-1457—
CLMCLM-4287762026-05-18T08:24:04Z·jacobWgrant1969-10-22··UHC-57440-22•••-••-9553308-434-6185NULL3053 HARBOR BLVDTucsonAZN/AGRP-5693NAVIGATE-HMO
CLMCLM-4178582026-03-13T12:38:19ZAdam—Rodriguez16-06-1997UHC-87609-65•••-••-4691·N/AN/A7818 Oak StSan DiegoCA92131NULLMEDICARE-ADV-A
CLMCLM-4080202026-05-20T08:54:49ZBlack—Diana1987-07-10UHC-19098-18—-—1397 Ridge RoadTAMPAFLN/AGRP-7439SELECT-EPO
CLMCLM-4239962026-07-07T19:41:15ZKAREN N.—HARRISON1987-01-26UHC-86250-15—null—-NULLnullUNKNOWN··GRP-8028—
CLMCLM-4092212026-01-23T00:54:21Z·Heather—Rice09/12/1947UHC-90036-38•••-••-2251N/A—8115 Elm StScottsdaleAZNULLGRP-7304SELECT-EPO
CLMCLM-4255792026-08-21T09:43:53ZMaria—Stone1995-09-12UHC-60339-87•••-••-4892——459 MAIN STREETPHOENIXAZ85028N/ASELECT-EPO··
CLMCLM-4092482026-09-04T10:49:47Zjuan—kim1965-09-28UHC-49008-92•••-••-5457UNKNOWNnull8159 RIVER RDNashvilleTN·37259UNKNOWN—
CLMCLM-4242492026-01-20T16:59:08ZWalterOCarter01/14/98·UHC-11426-79•••-••-8158nullwalter.carter@hotmail.com6131 Lincoln WayPHOENIXAZ··null—N/A
CLMCLM-4209972026-08-03T12:30:53ZSnyder, Nicole——07/06/88UHC-47909-54NULLNULL-6336 Spring StreetSan AntonioTX-nullnavigate-hmo··
CLMCLM-4029492026-02-21T05:18:04ZLinda·AGarrett1947-03-01UHC-52045-15—N/Alinda.garrett67@yahoo.com6243 Mesa DrNashvilleTN37262GRP-6650—
CLM CLM-4089342026-09-06T14:16:51ZKeith—Washington1945-03-09—N/A(360) 946-8522null273 HARBOR BOULEVARDNashvilleTN37275··CHOICE-PLUS-PPO
CLMCLM-4027632026-09-10T05:19:35ZJacob—Evans—UHC-30782-04UNKNOWN——2290 Spring StJacksonvilleFL·32244GRP-9504—
CLMCLM-4041882026-07-19T10:06:15ZSHARON—SANTOS01/28/90UHC-46936-59•••-••-4062+1 905 984 8621NULL6404 Bayshore DrDENVERCO80272nullCHOICE-PLUS-PPO
CLMCLM-4189452026-04-28T02:50:55ZPatrickK··Ford1991-01-12UHC-72154-88——-UNKNOWNnull——GRP-6604NAVIGATE-HMO
CLMCLM-410512 2026-01-21T01:49:29ZBrandon—Sandoval03/07/47-—347-598-1600··UNKNOWN·5758 Baseline RoadMinneapolisMN··55492——
CLMCLM-4275532026-08-20T00:45:26Z·ANTHONYCOLIVER·1962-09-24UHC-51791-98null—-697 Meadow LanePhoenixAZ85026GRP-7063choice-plus-ppo
CLMCLM-4207242026-06-29T13:32:36Z KATHRYN—KELLEY03/05/1941UHC-23952-71nullNULL··5269 WASHINGTON ST Apt 6NashvilleTN37265GRP-1703MEDICARE-ADV-A
CLMCLM-4222612026-03-31T08:21:48ZOmarCOBiren1976-06-22null—5864108616UNKNOWN3990 MEADOW LANEChandlerAZ85245-4853GRP-7263CORE-HMO
CLMCLM-4248432026-03-22T07:11:42ZJohn—Bell1957-01-01UHC-95187-29UNKNOWN319-539-6419N/A8461 Union StreetLos AngelesCAUNKNOWN····NULL
CLMCLM-4236972026-02-18T18:19:49ZRonald—West2070-07-24UHC-21226-69·····+1 349 901 3255ronald.west@icloud.com1699 UNION STREETMinneapolisMinnesota55467GRP-2934—
CLMCLM-4000372026-06-26T16:41:01ZDONNA—HUNTER1992-05-20UHC-21504-45null19174840488donna.hunter@gmail.comNULLUNKNOWNnullN/A—-
CLMCLM-4291212026-02-24T20:20:11ZCharlotte—Sandoval1965-09-28UHC-46215-36·UNKNOWN311-857-4377··nullN/A-N/A—core-hmo
CLMCLM-4081542026-07-20T14:56:42Z·Allen, Elijah——1943-12-01UHC-15522-20—(616) 890-2010———-—GRP-3627—
CLMCLM-4035792026-06-21T03:15:25ZCruz, Brittany——1964-02-22NULL·N/A(304) 730-7115N/A··2650 Market StreetGilbertAZ85297·GRP-4804CHOICE-PLUS-PPO
CLMCLM-4108142026-04-08T22:03:24ZJoshuaAPayne12/20/1946UHC-46227-21··+1 300 499 1602joshua.payne43@gmail.com8870 MAIN STREETDenverCO80285GRP-5121····
CLMCLM-4141012026-06-21T05:59:03ZShaw, Amanda——1966-03-05UHC-91321-72——null—nullUNKNOWNUNKNOWN··UNKNOWN
CLM CLM-4155872026-06-04T11:49:11ZRALPH—KNIGHT1949-10-18NULL•••-••-7879N/A—UNKNOWN——nullGRP-8600NULL
CLMCLM-430455 2026-01-16T20:19:27ZPhillips, Ralph··—1983-08-09N/ANULL463-600-4576—6178 Park Place··Austintx78712GRP-6296MEDICARE-ADV-A
CLMCLM-4080222026-03-02T10:04:39ZCarlos—Stone01-01-1982UHC-21036-35UNKNOWN791-604-9053CARLOS.STONE@YAHOO.COM3927 Lincoln WayAtlantaGA30345GRP-5865NAVIGATE-HMO
CLMCLM-4301392026-05-27T22:41:16ZADAM—VEGA1974-12-27UHC-75377-52nullNULLN/A3130 Cedar LaneSan DiegoCalifornia92181GRP-2061CHOICE-PLUS-PPO
CLMCLM-4069462026-08-01T22:11:38ZemmaI.santiago1995-03-17N/A——··5006 Spring Street #378DenverCO80228GRP-2789—
CLMCLM-4314272026-03-09T03:48:10ZFrances—Gonzalez1946-04-11——·NULLN/A95 WASHINGTON STREETTucsonAZ85796GRP-9903NAVIGATE-HMO
CLMCLM-4227922026-06-17T18:50:31ZGuzman, Julie M··——1963-02-20uhc-93993-35—259-659-3030·null885 CHURCH STREETGlendale··AZ85371·GRP-3027—
CLMCLM-4081652026-07-11T08:22:44ZPhilipW.Black06-02-1955UHC-68692-47•••-••-4806818-343-1032null1873 Forest AvenueHOUSTONTX77015nullSELECT-EPO
CLMCLM-4231652026-05-28T07:53:01ZMatthew··Sims1/14/1949UHC-92965-60··•••-••-5006N/Amatthew.sims@gmail.com9604 Lake View RoadChandlerAZ85284GRP-3469—
CLMCLM-4294102026-09-02T22:57:01ZRaymondJDay02-07-1984—•••-••-9727+1 837 256 9229—227 Elm Street·TucsonAZ85757GRP-5920—
CLMCLM-4068782026-02-24T21:55:03ZEugene—Fisher19690925UHC-45550-42•••-••-7718409-715-7953··UNKNOWN8143 Baseline Road #879ChandlerAZ85258—NULL
CLMCLM-4095232026-02-23T14:50:05Zharold—burnsApr 20, 1998uhc-89167-11null··null—6484 Central Avenue #508DenverCO80297GRP-1500-··
32,829 rows, page 193 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.640Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty