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-4027292026-06-08T20:25:20Z·ANAICOLEMAN03/12/41nullnull··——4247 GRAND AVENUELos AngelesCA90003——
CLMCLM-4260922026-09-28T03:42:41ZKayla····Schmidt·Dec 5, 1973N/A•••-••-5147NULLnull7183 Sunset BoulevardCOLUMBUSOhio43276·GRP-2575·MEDICARE-ADV-B
CLMCLM-413095 2026-05-13T01:36:43ZJOE—ROJAS1948-12-20UNKNOWNUNKNOWN—-NULL—·-nullGRP-9498—
CLMCLM-4060562026-01-04T05:37:30ZScott—Kim1949-12-21UHC9845586UNKNOWNNULL-3083 Ocean AveTempeAZ85251··GRP-9437OPTIONS-PPO
CLMCLM-4054742026-10-07T04:44:54ZALBERT—OLSON··19471108null•••-••-7578817-879-4171ALBERT.OLSON@AOL.COM—null———N/A
CLMCLM-4198272026-06-20T11:39:22ZCheryl—Harper1996-10-02UHC3598919-564-993-3179N/A404 Lincoln WaySan AntonioTX78233null·core-hmo
CLMCLM-4041032026-09-10T09:59:27ZChris—Park1989-05-03UHC8571974•••-••-912018203435933null2104 Market StreetScottsdaleAZ··—·GRP-6457CORE-HMO
CLMCLM-4300932026-02-20T06:04:20ZJEAN—NELSON1987-09-12UHC-20738-64•••-••-3741UNKNOWN-5776 RIDGE ROADCharlotteNC28236GRP-3021UNKNOWN
CLMCLM-4165042026-08-08T05:03:38ZJOAN—PRICE1950-03-25UHC-71246-26•••-••-1041(276) 621-8860N/A390 Park PlaceColumbusOH43262UNKNOWN···CORE-HMO
CLMCLM-4120752026-01-17T04:52:46ZRussell—Williamson11/06/47UHC-57475-82•••-••-4500NULL—1151 Maple Ave #756MiamiFL33120UNKNOWNMEDICARE-ADV-A
CLMCLM-4073902026-10-16T05:25:48ZPhiilp—Dean··1988-09-21null•••-••-4046·-NULL1778 RIDGE RDOrlandoFL32803nullCORE-HMO
CLMCLM-4306242026-04-10T23:08:57ZALANKREYNOLDS1971-10-19UHC-75853-19UNKNOWN·340.810.3418alan.reynolds11@hotmail.comUNKNOWN—NULLN/AN/AOPTIONS-PPO
CLMCLM-4163522026-04-03T21:55:43ZSTEVEN—RAMIREZ1952-06-15··UHC-82095-13—721-560-4422-5837 Indian School RoadColumbusOH43282N/ANULL
CLMCLM-4020432026-01-13T09:47:08ZSctt—Shaw1943-09-25UNKNOWNN/A(569) 918-4977-663 Market StDallasTexas75296UNKNOWN··
CLMCLM-4193522026-08-18T16:14:19ZSantiagoO.Hamilton2/12/2007UHC-80543-19UNKNOWNN/Asantiago.hamilton31@proton.me6075 Canyon RoadPHOENIXAZ85080GRP-7824··null
CLMCLM-405393 2026-01-20T14:09:54ZWEI—MARTINEZ1942-06-12UHC-81436-54UNKNOWNNULLNULL408 ELM STSan DiegoCA92179GRP-2881··—
CLMCLM-4292762026-09-05T04:20:14ZNOAHD.MARQUEZFeb 5, 1954UHC4490914—7477686986noah.marquez@gmail.com·3964 Cedar LaneCOLUMBUSOhio43244—-
CLMCLM-4319782026-02-21T20:07:09ZGrant, Jeffrey——19830913UHC1167592··UNKNOWNnullnull8815 Oak StreetEDEN PRAIRIEMN55300-—
CLMCLM-4136642026-05-11T10:15:03ZJOSHTCOOPER10/20/62uhc-54359-82NULL(413) 520-6744—8269 Pine DrNASHVILLETN37234nullOPTIONS-PPO
CLMCLM-4159612026-09-25T06:33:58Z·Sandra—Russell··Feb 25, 1995—UNKNOWN+1 615 821 3623—6195 Main StTempeAZ85275GRP-7966—
CLMCLM-4250712026-01-13T05:47:02ZJoen—Fowler1983-10-14N/ANULL7126109526null7025 SAGE CTFresnoCA···93722GRP-7640··-
CLMCLM-4025322026-01-11T06:59:56ZPriya—Phillips1/2/1940UHC-10701-47·UNKNOWN+1 749 960 8220—6123 Apache BlvdColumbusOH43243·GRP-7231CORE-HMO
CLMCLM-4180242026-10-02T23:46:12ZYUKI—MURPHY19450516uhc-24467-37•••-••-5468(795) 219-2534NULL··3311 Ocean AveSacramentoCalifornia95816-0615—CHOICE-PLUS-PPO
CLMCLM-4130682026-02-08T02:18:06ZStephenYMontgomery13-11-1975··UNKNOWN15164584594null2336 CHURCH STREETDallasTX75219GRP-3554MEDICARE-ADV-A
CLMCLM-4220142026-05-14T07:57:45Z·Sofia—·Lawrence2001-04-24UHC-25799-28null—-3103 Apache BlvdLOS ANGELESCA90044GRP-9623—
CLM CLM-4231322026-01-15T05:44:37ZKing, Cynthia——1981-07-10UHC-15784-43•••-••-5330308.465.4069UNKNOWN386 Mesa DrFRESNOCalifornia93754UNKNOWNCORE-HMO
CLMCLM-4131382026-06-19T14:53:44ZHamilton, ChrisS—·19841003—N/A····UNKNOWN··1418 BroadwaySeattleWA98108-1255GRP-0183·MEDICARE-ADV-A
CLMCLM-4251512026-08-11T01:26:21ZDOROTHY—MEJIA1961-08-27UHC-13045-75··•••-••-7809N/Adorothy.mejia27@icloud.com·412 Sunset BoulevardDenverCO80246UNKNOWN—
CLMCLM-403995 2026-07-19T15:40:34ZVirginia—Cook2007-06-17-null344-340-4000-9174 Forest AvenuePlanoTX75020—CORE-HMO
CLMCLM-4180352026-10-05T18:44:09ZWilliams, William——19-12-1953—•••-••-4492NULL-6941 ELM STREETScottsdaleAZ85239GRP-2535-
CLMCLM-4055832026-05-11T21:00:41ZGEORGE—SANCHEZ2/18/1978UHC-41321-44•••-••-2975——2945 Elm StreetMIAMIFL33182nullMEDICARE-ADV-B
CLMCLM-4148582026-04-15T13:26:40ZNANCY C—ROJAS1999-06-09UHC-90304-33•••-••-6093N/A·UNKNOWN6782 Pine DriveHoustonTX77065GRP-5252—
CLMCLM-4108952026-09-29T12:30:00ZJozeKHowell1973-11-06UHC-32051-30•••-••-4240383-652-3892NULLUNKNOWNUNKNOWN—nullGRP-5428MEDICARE-ADV-B
CLMCLM-411479 2026-08-31T00:44:51Z·Margaret··Cruz01/09/01uhc-61807-71•••-••-26167919638151margaret.cruz@gmail.com——NULL———
CLMCLM-4273022026-08-23T00:05:43ZLogan—Vargas06/07/65··UHC-17983-86—18119287403··2581 RIVER RDLas VegasNV89139··—SELECT-EPO
CLMCLM-4271702026-07-08T23:26:23ZBlack, Bryan—··Jan 26, 1940—nullN/A··UNKNOWN985 APACHE BOULEVARD·MINNEAPOLISMN55412····CORE-HMO
CLMCLM-4156812026-10-03T02:56:36ZMichelle—King1974-07-25UHC-13873-93•••-••-7747-··null1773 INDIAN SCHOOL ROADEden PrairieMN55331N/Anull
CLMCLM-4056152026-04-10T22:58:02ZAMBER S.—GARZAMay 4, 1950—NULL7238038—6737 Apache Boulevard··PHOENIX·AZ85001-NAVIGATE-HMO
CLMCLM-4076962026-08-03T17:04:30ZROBERTU.WEBER1982-03-12——914-816-7895—5930 Maple AveChandlerAZ·85270—NULL
CLMCLM-417735 2026-05-02T09:16:13ZTHERESA—GARZA·1942-10-28·UHC-29869-56—(668) 247-1738-877 Cedar LnAtlantaGA30319GRP-2195-
CLMCLM-4198322026-08-12T04:02:38ZElliott, Daniel··——19440310——NULL—·8182 Washington StreetSan DiegoCA92172GRP-8464CHOICE-PLUS-PPO
CLMCLM-4071622026-01-30T19:59:01Z·RyanMDuncan··20021120——(500) 236-3668··8674 Willow CtPlanoTX·75024GRP-3170NULL
CLMCLM-4056432026-08-04T04:05:44ZGrace—Singh17-08-1980UHC-75793-12NULL5928829805grace.singh17@outlook.comNULL—-—GRP-4191—
CLMCLM-4027452026-02-21T11:53:57ZYuki—·Collins01/13/83UHC-91200-07N/A359.797.5966-1167 Camelback RoadJACKSONVILLEFL32248GRP-0671NAVIGATE-HMO
CLMCLM-4321202026-08-04T14:38:47ZElizabethPAlvvarado1973-06-24UHC-06831-15UNKNOWN4443768525NULL—NULLN/Anull—MEDICARE-ADV-A
CLMCLM-4237482026-03-16T07:38:06ZGardner, MarianaQ.—Jan 24, 2001UHC-13906-61•••-••-6042—N/A7580 Willow CtMiami·FL33169GRP-7401—
CLM CLM-4112702026-04-07T22:12:04Zdebra··ramos·4/19/1992nullN/A395-429-6772null431 Cedar LaneMinneapolisMN55457GRP-2670OPTIONS-PPO
CLMCLM-4318362026-02-19T03:13:50Z·Vincent—FernandezApr 2, 1943··UHC-19905-25•••-••-5758-·N/A6169 ELM STDenverCO80211-—
CLMCLM-401174 2026-02-11T21:55:51ZCARL—COLE1943-08-19UHC-70721-52——N/A2452 Oak StColumbusOH·43216GRP-9633CHOICE-PLUS-PPO
CLMCLM-4192302026-07-12T13:15:59Z·shirley··harris1985-11-26UHC-59657-64•••-••-8941(250) 791-1758N/A2404 Maple AveSAN DIEGO·CA92185——
32,829 rows, page 188 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.632Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty