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-4125422026-10-11T08:13:14Z·DEBRA—POWELL19450207nullnull7948101299NULL4358 Forest AvenueTampaFL33622-9366GRP-7169—
CLMCLM-4151532026-01-23T21:47:28ZCynthia·W.Hughes1952-03-22UHC-65736-97—N/Acynthia.hughes@gmail.com2167 Union StreetTEMPEAZ85230GRP-5155—
CLMCLM-4045392026-05-05T14:36:09ZLISA—SILVA2002-04-16UHC-88580-44•••-••-5377—LISA.SILVA72@YAHOO.COMNULL—N/ANULLGRP-4998CORE-HMO
CLMCLM-4275162026-03-20T18:29:42Z·Catherine—ChenMar 6, 1941UHC-58328-78•••-••-4985UNKNOWN-··N/AUNKNOWNnullUNKNOWN-MEDICARE-ADV-A
CLMCLM-4308612026-05-01T07:23:34ZJoseph—Lucas1963-11-28·UHC-13804-58--NULL4555 LINCOLN WAYAtlantaGA30345UNKNOWNNAVIGATE-HMO
CLMCLM-4310322026-10-15T20:38:10ZLauren—Snyder08/01/56——null—4984 LINCOLN WAYChandlerAZ85266—OPTIONS-PPO
CLMCLM-4035502026-07-18T15:59:59ZJackson, CarolynO.—·11/02/02UHC-39760-46•••-••-8251—-··2843 Mesa Drive·AtlantaGA30305GRP-3002-
CLMCLM-4035332026-01-16T00:55:04ZMATEO··KIM1983-07-15nullnull(414) 397-4812UNKNOWN··1057 Mountain View DriveATLANTAGA30338--
CLMCLM-4248052026-01-27T01:55:52ZMARCUS—GRIFFIN···Feb 22, 1955UHC-16047-81UNKNOWN——6506 Spring Street #242PhoenixAZnull—-
CLMCLM-4099512026-09-03T01:47:09ZdouglasR.schultz···1974-07-19UHC-55063-31NULL-UNKNOWN3366 Elm StMiamiFL33181GRP-7860OPTIONS-PPO
CLMCLM-4138802026-02-06T03:21:47ZKATHRYN—SANDOVAL·0208-91-54N/A•••-••-3203—-6364 Maple AveSeattlewa98142·GRP-1586MEDICARE-ADV-B··
CLMCLM-4141802026-04-19T08:48:35ZDorothy—BoydSep 27, 1945NULL•••-••-6361UNKNOWNUNKNOWN7813 LINCOLN WAYSacramentoCA95894N/AUNKNOWN
CLMCLM-4139502026-10-08T09:07:03ZPal—Hughes1999-07-16UHC-04092-93•••-••-7658(714) 413-3137··null9635 Palm DriveCharlotteNC28225·nullnull
CLMCLM-4157662026-06-27T18:50:04ZCastro, Mason——1957-09-28UHC-01653-72•••-••-8498·7644039675-4926 MAIN STREETAustintxNULL——
CLMCLM-4268942026-05-28T21:22:10ZAlexis—Henry1961-02-97UHC-60956-74NULL——9695 Harbor BlvdTucsonAZ85779N/AUNKNOWN
CLMCLM-4057822026-10-09T07:32:50ZRyan, Matthew———null•••-••-0820NULL-2434 Willow CourtEden PrairieMN55386GRP-7358NAVIGATE-HMO
CLMCLM-4277592026-09-12T02:00:29ZRaymond—Black1939-11-09NULL•••-••-4489—-1444 Sage CtChandler··AZ85233GRP-2581··UNKNOWN
CLMCLM-4155942026-04-29T07:03:44ZJUSTIN—ALEXANDER1981-02-11-•••-••-106017163209948—1450 Mountain View Drive·Los AngelesCA90068GRP-1750—
CLMCLM-4029012026-01-12T21:49:57ZSARAHZ.GREEN1961-11-01—NULLNULL-1438 BROADWAYJacksonvilleFL32271UNKNOWN—
CLMCLM-4236542026-04-18T15:24:36ZJONATHAN—CASTILLO02/18/1970-•••-••-4418934-281-1565UNKNOWN—null····-GRP-7397UNKNOWN
CLMCLM-4158662026-02-25T11:47:56ZAaron··—Simpson2005-05-22UHC-21933-26UNKNOWNnullaaron.simpson1@aol.com·659 Washington StreetMiami··Florida33175null-
CLMCLM-4028582026-09-24T18:51:55ZAustin, Randy··—··10/15/2002UHC-90305-60—606.730.4933UNKNOWN2466 Palm DrLas Vegas··NV89182·null-
CLMCLM-4194102026-04-10T06:29:25ZDEBRA··—COX··19930622UHC-62132-15··—·(282) 908-3125UNKNOWN8967 Desert Sky BoulevardCOLUMBUSOhio·43297GRP-3717UNKNOWN
CLM CLM-4059442026-10-08T01:24:56ZZACHARY—HARRIS03/02/72uhc-04428-62—·7524419031—6872 Sage Ct #826MiamiFL33103GRP-9684CHOICE-PLUS-PPO
CLMCLM-4111812026-06-21T01:09:57ZBEVERLY—WILSON—UHC-95133-67--beverly.wilson@icloud.com··554 PINE DRIVEATLANTAGA30349GRP-0931MEDICARE-ADV-B
CLMCLM-4122712026-10-15T16:50:05Zjerry—jensen1955-08-28UHC-63050-35NULL267-958-6582—4916 Sunset BoulevardNashville···Tennessee37255-8813GRP-5530NULL
CLMCLM-4277412026-05-26T00:28:45ZRoy—Alvarado1969-12-02uhc-53540-10•••-••-8424361-837-7706N/A6102 VALLEY VIEW DRIVESan AntonioTX78203--
CLMCLM-4136992026-06-14T02:39:15ZJULIA·K.GRAHAM1947-05-12UHC-16313-77UNKNOWNnullN/A352 Willow Ct·TucsonAZ85748GRP-3451—
CLMCLM-4061692026-09-24T01:50:50ZHelen—Gray1977-07-03UHC-92539-10•••-••-4035——NULL-—nullnullNAVIGATE-HMO
CLMCLM-4252422026-05-29T09:41:06Z Butler, Megan···M—1953-21-25uhc-88806-59—+1 799 415 6664NULL8973 CHURCH STREETAtlanta·GA30351GRP-1785—
CLMCLM-4013732026-08-22T03:24:57ZArjun—Gardner08/28/87UHC-24635-15•••-••-8494487.830.3467arjun.gardner@proton.me—N/A—null—·SELECT-EPO
CLMCLM-425370 2026-04-23T12:27:58ZPAMELA··ARNOLD03/06/1974UHC-14514-49NULL317-931-2944NULL2015 Lake View RdHoustonTX77033··GRP-8957CHOICE-PLUS-PPO
CLMCLM-4134822026-07-08T17:06:48ZAustin—Hannson1974-09-09UHC-99877-94null··AUSTIN.HANSON63@ICLOUD.COM1610 Church StPhoenixAZ85030GRP-2231UNKNOWN
CLMCLM-4113822026-07-19T16:13:22ZBrandon·V·Vazquez·1956-10-03N/A•••-••-1986-null2328 Elm StAustinTX78789nullSELECT-EPO
CLMCLM-4091272026-01-16T10:00:31ZROBERT—PIERCEMar 4, 1988····•••-••-8004+1 244 371 3021—3041 HILLCREST RDHoustonTX77072-0263GRP-6307null··
CLMCLM-4239862026-03-06T07:31:42Zdenise—stewatr1985-01-04-—-UNKNOWN—·N/A—-GRP-7715CHOICE-PLUS-PPO
CLMCLM-4302952026-07-24T12:18:01Z HelenXEllis2008-02-12—•••-••-1947—·N/A-—NULL-nullNULL
CLMCLM-4165062026-04-23T05:26:10ZJOSHUA—YOUNG··2003-09-05UHC-79976-16-710-969-2931—null——-UNKNOWN—
CLMCLM-4282772026-05-26T20:34:39ZBeverly—Ross·1960-07-26UHC-10564-44··—339-689-9358NULL8373 Hillcrest RoadEDEN PRAIRIEMN55370—CORE-HMO··
CLMCLM-4197832026-06-08T19:31:19ZLuciaEParker12-11-1955UHC-17810-44——UNKNOWN5680 Elm StreetAustinTX78704·GRP-8969UNKNOWN
CLMCLM-4283082026-07-19T12:06:43ZJERRY—PERKIINS1/7/1988-····8097555262—9878 Desert Sky BoulevardAtlantaGA30380GRP-1672CORE-HMO
CLMCLM-4262622026-01-03T10:41:39ZCalrson, Julia——11/18/63UHC-47137-69null——4096 CENTRAL AVEGilbertAZ85215GRP-7885NAVIGATE-HMO··
CLMCLM-4156042026-10-04T13:55:13ZTheresa—Payne9/5/1978UHC5965415—5907677118—9004 Sage CtCharlotteNC28269GRP-7870NULL
CLMCLM-4297962026-08-04T02:44:53ZSandra—Hart1957-12-16null•••-••-0081950-839-7903N/A9810 Jefferson AvenueSan DiegoCA92119nullNULL
CLMCLM-4015562026-10-16T00:08:51ZSantiagoHRivera0205-15-91UHC-93168-85—-·N/A3442 Camelback RoadMINNEAPOLISMN55443—CORE-HMO
CLMCLM-4091312026-09-12T02:45:08ZMiller, Stephen——05/04/1998uhc-10946-99•••-••-2273+1 581 397 8980UNKNOWN8460 Baseline RdJACKSONVILLEFlorida32210NULL—
CLMCLM-4031942026-10-06T23:28:18ZDENNIS—HUNT·03/07/1993UNKNOWN•••-••-160817022047001—9777 Mountain View DrCOLUMBUSOH43245·GRP-7338MEDICARE-ADV-B··
CLMCLM-4180712026-06-17T22:46:19ZDenise··Padilla9/21/1970UHC-91088-69•••-••-1590-—3946 Union StSan AntonioTX78296·GRP-8270CHOICE-PLUS-PPO··
CLMCLM-4263752026-09-13T01:33:47Zcarlos—clrak1975-12-08UHC-35686-87•••-••-5612691-746-5857NULLnull-N/AnullGRP-0640NULL
CLMCLM-4301582026-01-18T06:25:49ZYuki—Yang1977-09-21UHC-26988-86NULLUNKNOWNN/A7745 BroadwaySAN DIEGOCA92191UNKNOWNN/A
32,829 rows, page 119 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:38.486Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty