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

All sources, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
CLMCLM-4270372026-05-14T13:32:06ZKyle—Cuok-UHC-80562-19—947.216.3495null8422 Hillcrest Road·TampaFL33671GRP-9648NAVIGATE-HMO
PRVPRV-207472026-04-16T14:32:17Z·CarlSWatson1942-06-01UHC-93057-38UNKNOWN(874) 346-2772-2747 Mountain View DriveJacksonvilleFL32262NULL-
TPATPA-621872026-09-05T21:47:35ZRandy—Shaw1993-01-05UNKNOWNUNKNOWN····N/A—UNKNOWNNULL——NULL
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
ENRENR-1124022026-06-11T08:53:55ZAnnaWHicks2000-07-28UHC-76951-41•••-••-239612747125621··-4474 VALLEY VIEW DRIVEMINNEAPOLISMinnesota55404GRP-8812SELECT-EPO
CLMCLM-4232452026-04-08T05:41:13Zsophia—lawrence·1989-05-04UHC-54923-39•••-••-1811(254) 428-0562SOPHIA.LAWRENCE90@YAHOO.COMnullN/A——·nullNAVIGATE-HMO
PRVPRV-264642026-09-26T23:35:44ZSaraBTrranSep 20, 2003···UHC-06860-38•••-••-319916645858422NULL6688 Lincoln WayMesaAZ85294··NULL—
CLM CLM-4285212026-02-06T02:01:35ZHANNAH·DLITTLE1967-01-19uhc-22874-08··628.469.1390——null—-GRP-7460OPTIONS-PPO
ENRENR-1008992026-06-22T21:53:23ZAlbertTMorales1949-06-03UHC-72455-23•••-••-9561509-635-3282ALBERT.MORALES@AOL.COM4504 Lake View RdGilbertAZ·85215-2388GRP-2779MEDICARE-ADV-A··
TPATPA-507422026-05-19T08:01:01ZJacquelie—Taylor1976-10-27N/A•••-••-9777····2794 Oak StHOUSTONTX77014UNKNOWNNULL
ENRENR-1426722026-01-22T14:07:00ZHaroldI.Pierce1958-09-17UHC-59853-76•••-••-8668(357) 805-7058harold.pierce@icloud.com5371 Park PlaceGlendaleAZ85370GRP-4266CORE-HMO··
CLMCLM-4247292026-10-16T22:18:03ZPhilip—Willis1968-02-27—•••-••-8559—UNKNOWN—N/A—NULL··N/Anull
TPATPA-505782026-08-07T03:04:55ZVIRGINIA—RUIZ··2002-06-11—UNKNOWN(274) 871-4431——NULL——GRP-6523—
CLMCLM-4231882026-07-04T22:27:24ZMEGAN—LAWRENCE1963-11-26UHC-76908-83•••-••-2735N/AUNKNOWN5603 Baseline RoadPhoenixAZ85001··NULLCHOICE-PLUS-PPO
PRVPRV-256302026-02-12T02:19:54ZPRIYA—MORENOAug 6, 1991UHC-96157-92•••-••-20955498854889priya.moreno@gmail.com8560 Palm Drive #490··CharlotteNorth Carolina·28296——
ENRENR-1191022026-09-17T23:04:17ZERIC—DAVIS1993-07-03UHC-71634-23•••-••-831817304239708UNKNOWN6609 Elm StreetLAS VEGASNV89134GRP-3950MEDICARE-ADV-B
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
ENRENR-1202292026-03-01T17:55:29ZGeorge····Hall2007-02-17UHC-02411-55•••-••-5646—george.hall39@yahoo.com6086 MAPLE AVENUEDallasTX75269GRP-8338MEDICARE-ADV-B
ENRENR-1126682026-03-26T14:23:27ZChristinaMHayes03/27/1942UHC-01179-85•••-••-86848254618220christian.hayes89@aol.com2588 Cedar Ln Apt 34Las VegasNVN/AGRP-8119MEDICARE-ADV-B··
CLMCLM-4065242026-06-28T13:54:19ZCYNTHIA—TORRES03/02/78UHC-94028-02UNKNOWN634-945-5581N/A7270 Park PlGILBERTAZ85256GRP-0738—
ENRENR-1029442026-04-24T20:37:42Z Fatima——·1980-12-19UHC-32664-63-214-566-4632—8974 Spring StreetLos AngelesCA··90048GRP-8557OPTIONS-PPO
PRVPRV-277262026-02-17T02:51:34ZWEI—JAMES05/16/87UHC-53568-22•••-••-898918928080751wei.james@proton.me7550 Sage CtORLANDOFL32822null·-
CLMCLM-4241342026-03-07T23:22:00ZMarilynP··Ross1968-11-15UHC-88869-42—14714716124N/A4816 Mesa DrCharlotte·North Carolina28298··GRP-0612MEDICARE-ADV-B
ENRENR-1064852026-02-23T18:12:38ZCHRISTIAN—RAMOS1940-02-26UHC-13877-93N/A9416975669christian.ramos@hotmail.com6760 PINE DRIVESan AntonioTX78230GRP-1092MEDICARE-ADV-A
CLMCLM-4236252026-01-10T22:30:00ZSimpson, Eric——19981018UHC6577370NULL9843752110—8776 CANYON RDColumbusOhio43289GRP-2713·options-ppo
TPATPA-622202026-03-13T15:55:26Z Luis—Wang1957-08-16—•••-••-1481UNKNOWN-2970 Jefferson AvePhoenixAZ85014UNKNOWNnull
ENR ENR-1366362026-01-19T23:16:09ZDONNAYYOOUNG1983-02-14UHC-28182-85•••-••-3442214.560.9349DONNA.YOUNG36@GMAIL.COM9517 Park PlScottsdaleaz85270GRP-2087SELECT-EPO··
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
ENRENR-1064132026-07-14T06:42:54ZWallace, KathleenR—20000314UHC-39042-54•••-••-0293UNKNOWNkathleen.wallace@gmail.com2363 FOREST AVE·ChandlerAZ85242GRP-6643medicare-adv-b
CLMCLM-4217692026-05-29T03:04:50ZSUE····DAVIS07/24/1957UHC-22832-41•••-••-4866——9258 Ocean AvenueSan DiegoCA92195··nullMEDICARE-ADV-A
ENRENR-1284392026-04-28T16:46:25ZJaniceFWalsh1970-01-22UHC-75179-24•••-••-4876+1 738 741 8338-6840 CEDAR LN··AtlantaGA30339GRP-2853MEDICARE-ADV-A
CLMCLM-4323682026-07-09T06:34:34ZTeresa—WoodsSep 17, 1968UHC-42550-05—7654510728N/A4912 Hillcrest Rd··CHANDLERAZ85221GRP-3106—
PRVPRV-265242026-10-03T01:42:11ZIsabella—Kelly02/25/59··UNKNOWNnull4505933422—2733 SUNSET BLVDDallasTX75215UNKNOWNnull
CLMCLM-4219652026-01-15T14:02:28ZJeff—Harrison1942-09-28UHC-17502-07—(559) 290-9024—6635 Canyon Rd #382Las VegasNV89189nullCORE-HMO
PRVPRV-205992026-01-29T22:45:46ZARTHUR—GARRETTNov 27, 1965UHC-35004-63NULL4847752631UNKNOWN5313 Sunset BlvdCharlotteNC28207nullNAVIGATE-HMO
TPA TPA-541682026-04-30T12:05:29ZDonaldI··Vazqez1960-05-26-NULLUNKNOWNN/A1869 Mesa DrScottsdaleAZ85210-8393····NAVIGATE-HMO
TPATPA-532732026-04-11T14:38:40ZPalmer, Caarolyn·M—19-08-2004-N/A728-562-9177carolyn.palmer80@aol.com······null—····N/A
CLM CLM-4046672026-09-05T13:06:58ZMargaret—Smith19760115UHC-25071-63N/AN/A—1446 RIDGE ROADChandlerAZ85248-4671NULL—
ENR ENR-1157562026-04-08T10:55:29ZWang—Jose1988-02-03UHC-58676-07•••-••-0507557.934.4867jose.wang@gmail.com··3956 Indian School RoadAtlantaGA30308GRP-0780MEDICARE-ADV-A
ENRENR-1397562026-03-12T07:34:27Z Austin·H.Li1943-07-11UHC-37537-13•••-••-95973275055austin.li@proton.me4095 BAYSHORE DRIVEScottsdaleAZ85262-7074GRP-2167CORE-HMO
ENRENR-102696 2026-04-29T18:37:08ZAlbertU.Crawford1942-11-20UHC-09010-78•••-••-2266(837) 232-0823albert.crawford@icloud.com2926 Ocean AvenueGlendaleAZ85347GRP-1143·SELECT-EPO
CLMCLM-4000662026-04-27T17:34:01ZLawrenceHKelly2008-02-22UHC-78966-48NULL9817852571lawrence.kelly33@aol.com·7196 OAK ST·ColumbusOHnullN/A—
CLMCLM-4134032026-08-30T09:59:39ZHunt, Sarah——07/09/98UHC-87592-42—380.843.9490SARAH.HUNT@ICLOUD.COM3523 MARKET STHoustonTX77046-3382GRP-0324MEDICARE-ADV-B
100,000 rows, page 200 of 2,000PreviousNext

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