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-4316102026-09-22T01:36:30ZHeather—Cruz1979-04-21UHC-18089-98UNKNOWN··12159256455NULL····nullNULLnullUNKNOWN·NAVIGATE-HMO
CLMCLM-4068212026-02-04T00:53:35ZMelissa··—Fox1979-01-22UHC-13839-35•••-••-2705(484) 873-6745·-2330 Ridge RoadFresnoCalifornia93744GRP-2739null
CLM CLM-4281572026-03-13T11:17:03ZGERALDMGARZA·1945-04-09UHC-07051-35··N/ANULL·UNKNOWN3829 Main StreetDenverCO80234—N/A
CLMCLM-4254302026-09-17T16:45:02ZWilson, Denise—··1987-11-14UHC-05747-60•••-••-7403—-UNKNOWNnull—null··—
CLMCLM-4318112026-07-23T08:01:17ZJuan—Carlson19730823uhc-78684-93UNKNOWNUNKNOWNN/AUNKNOWNNULLNULLN/AGRP-9378—
CLMCLM-4290212026-05-18T01:05:48ZNancy—Martin··7/28/1947UHC6635074•••-••-6866—N/A··7326 HIGHLAND AVETempeAZ85243GRP-9879—
CLMCLM-4058352026-01-24T19:51:33ZHIROSHIYPRICE23-01-1975UHC-21169-37··NULLNULLnull—N/A——-··UNKNOWN
CLMCLM-4203172026-06-19T17:31:29ZBlack, Lori——07/21/53UHC-24306-35—408-953-3436N/A·4320 RIVER RDFRESNOCA93743··GRP-0549N/A
CLMCLM-4205952026-08-30T15:51:33ZEVELYN··—MORRISON13-09-1986-•••-••-5114null—1846 Maple AvenueTampaFlorida33635GRP-9678null
CLMCLM-4263552026-03-16T15:14:12ZMariaPHawkins1984-05-24UHC-51163-84···NULL—maria.hawkins@aol.com4711 Desert Sky Boulevard·AustinTX··78783GRP-9526NULL
CLMCLM-4154912026-07-28T07:21:28ZBetty··Brooks1952-05-01UHC4647501——BETTY.BROOKS@HOTMAIL.COM2768 Park PlMesa·AZ·85231-MEDICARE-ADV-A
CLMCLM-4104322026-05-01T02:12:15ZCATHERINE—BENNETT1945-01-20null·NULL8452836··NULL9312 INDIAN SCHOOL RDOrlandoFLUNKNOWN··GRP-8343-
CLMCLM-4226012026-09-12T04:27:10ZLaura—Morgan1970-02-28nullUNKNOWN504-278-8356N/A6176 Pine Dr··TAMPAFlorida33650-null
CLMCLM-4214812026-05-21T07:24:55ZFrances—Rojas1985-05-01UHC-82208-39•••-••-5938(720) 337-1205N/AUNKNOWN-UNKNOWNnullGRP-4259null
CLMCLM-4204722026-10-10T17:36:33ZAmanda—Graham1996-03-27UHC-29738-16•••-••-6068882-794-2406amanda.graham41@gmail.com1043 Harbor BlvdSacramentoCA95883GRP-5868CHOICE-PLUS-PPO
CLMCLM-4048472026-09-26T12:25:49Z FRANK—RICHARDS1949-06-20UHC-87366-39UNKNOWN··nullN/A7427 Union St #125ChandlerAZ··85261N/AUNKNOWN
CLMCLM-4145562026-08-04T11:39:51ZBrandon—Warren01/11/2003nullnull7083255304UNKNOWN1717 GRAND AVENUEMinneapolisMN55466GRP-7257CHOICE-PLUS-PPO
CLMCLM-4061592026-06-26T14:30:33ZLuis—Nguyen1977-04-15··UHC-08438-95·nullnullluis.nguyen80@gmail.comNULL—UNKNOWN-GRP-1208··
CLMCLM-4201922026-10-09T14:31:44ZWei—Miller03/27/49N/A•••-••-8601+1 697 777 0510····967 Canyon Rd #466TempeAZ85223GRP-6579·CORE-HMO
CLMCLM-4245872026-09-22T22:05:18ZJANICE—JORDAN1966-03-24·-•••-••-5351(360) 839-8659—774 Washington StreetNASHVILLETN37275GRP-3331····
CLMCLM-4187082026-02-04T20:58:33ZMICHELLE—CARPENTER12/26/04UHC-19794-40•••-••-2403N/A—1416 SPRING STREETSCOTTSDALE·AZ85215—null
CLMCLM-424359 2026-06-26T07:31:30ZGloia—Howard03/22/1996UHC-34736-12null15206655418·null9169 Spring StScottsdaleAZ85211·N/A-··
CLMCLM-4295552026-02-26T04:22:58ZBRADLEY—PORTER2006-03-12UHC2330628-(882) 618-5903-6298 Maple AveFresnoCA··93729UNKNOWNOPTIONS-PPO
CLMCLM-4080802026-07-27T22:56:17ZMARCUS—SCOTT2003-02-20UHC-58921-89-5475676342null·2530 HARBOR BOULEVARDMesaArizona85252GRP-2725CHOICE-PLUS-PPO
CLMCLM-4258892026-08-21T12:04:33ZRANDYB.EDWWARDSApr 7, 1967——null—1054 WASHINGTON ST·MiamiFlorida33128··GRP-3470CHOICE-PLUS-PPO
CLMCLM-4235712026-09-05T03:41:10ZMegan—·Perez1947-11-27NULL··N/A-·megan.perez93@icloud.com8597 Valley View DrOrlandoFL32834·GRP-5749MEDICARE-ADV-B
CLMCLM-427959 2026-02-03T13:43:17ZWislon, Kyle—··1956-10-22UHC-49295-41N/A—N/A834 Oak StNashvilleTNnullGRP-0960—
CLMCLM-4063542026-09-10T20:15:03ZJOYCE—RAY1942-05-09UHC-45796-43··NULL3475552834nullNULL——NULLNULL·MEDICARE-ADV-A
CLMCLM-4083192026-07-23T01:25:53ZMcDonald, Raymond··——Jun 24, 1965N/A•••-••-65583229130UNKNOWN8053 Broadway··San AntonioTX78293-—
CLMCLM-4253252026-10-18T15:53:35ZJOAN—MURHPY05/01/00UHC-51326-26··294-859-5260UNKNOWN4518 Sage CourtJacksonvilleFL32249····CHOICE-PLUS-PPO
CLM CLM-4148352026-09-02T10:59:29ZGregory—Palmer1986-02-26UHC3345051NULL(314) 619-8561GREGORY.PALMER@OUTLOOK.COM8004 Church St··SCOTTSDALEAZ85256-6865GRP-7823UNKNOWN
CLMCLM-4103792026-10-02T12:05:16ZSarah—Cole6/18/1953UHC-95165-36•••-••-1664N/A-NULLnull—UNKNOWNGRP-0730CORE-HMO
CLMCLM-4318712026-02-05T03:18:17ZCharles—Stevens2004-01-25UHC-12624-66——N/AnullNULLN/A·N/A—CORE-HMO
CLMCLM-4130342026-05-28T07:34:46ZCHRISTIAN—HERNADEZMar 27, 1951NULLN/A831-960-9817null—UNKNOWNnull—-N/A
CLMCLM-4050112026-09-03T16:52:11ZAlice—Lynch1958-09-16UHC-12665-44—7566717771—-NULLnullUNKNOWN—SELECT-EPO
CLMCLM-4217752026-04-25T02:08:37ZLuis··—McDonald1940-06-07UHC-12314-12——NULL4096 Main StreetGLENDALEAZ85353GRP-2719—
CLMCLM-4273612026-05-21T01:30:23ZNathan··Gilbert01/10/08UHC-54667-70UNKNOWN····nathan.gilbert89@aol.com9116 SUNSET BLVDCharlotteNC28217GRP-3357NAVIGATE-HMO
CLMCLM-4055032026-03-03T04:24:53ZTONY—MASON08/27/59UHC-71486-08•••-••-2584522-985-4900·nullNULLnull····N/A·GRP-5270MEDICARE-ADV-A
CLMCLM-4183802026-05-18T06:25:54ZGloria—Johnston—UHC-03301-51•••-••-7811-GLORIA.JOHNSTON56@OUTLOOK.COM··2654 Maple AvenueOrlandofl··32863NULLOPTIONS-PPO
CLMCLM-4280052026-02-19T13:30:06Zwiillie—hughes2007-11-19UHC3686798•••-••-6707280-582-1410··7719 BroadwayChandlerAZ·85201GRP-7777—
CLMCLM-4028012026-03-14T07:47:47ZEmily—Walker1997-10-13———-350 MAIN ST #285·San DiegoCA92135······MEDICARE-ADV-B
CLMCLM-4248762026-06-08T06:39:22ZALICE—CRUZ19740913UHC-21043-26N/A-N/A——-—GRP-4698MEDICARE-ADV-B
CLMCLM-4276382026-10-18T03:46:22ZROY—BURNS·1996-01-06uhc-22217-24•••-••-6683····-·UNKNOWN—-·-GRP-2544NAVIGATE-HMO
CLMCLM-4210062026-05-27T08:22:40ZADAM—MCDOONALD22-08-1986N/A•••-••-6189681.523.0456ADAM.MCDONALD@AOL.COM5555 Sunset BoulevardCOLUMBUSOH43214GRP-5527—
CLMCLM-4101082026-07-10T18:31:35Zcheryl—garza1964-08-05UHC-54815-28N/ANULL—561 Jefferson AvenueSan DiegoCA92167-3918GRP-8598···MEDICARE-ADV-A
CLMCLM-4142042026-08-27T18:44:39ZGluria··Hamilton1938-03-03UHC-85050-17N/A—nullUNKNOWN———nullNULL
CLMCLM-4133162026-03-25T19:45:13ZJon—Ellis1979-09-23UHC-80469-45•••-••-8209UNKNOWN—5849 PALM DRTampaFL33609——
CLMCLM-4031132026-03-10T05:31:04ZCarlosV.White1989-01-05uhc-71477-56•••-••-30822306632369carlos.white@outlook.comN/AUNKNOWN—nullN/ACORE-HMO
CLMCLM-4314302026-05-02T01:03:07ZWei—Cooper··1953-10-25UHC-84241-56····(705) 608-8883N/A5751 RIVER RDChandlerAZ85261GRP-3458CHOICE-PLUS-PPO
CLM CLM-4122392026-09-04T13:42:02ZJULIEILEWIS1963-03-22—•••-••-4641·········7632 CHURCH STSeattle··WA98167-medicare-adv-a
32,829 rows, page 56 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.709Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty