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-4207432026-09-29T20:20:39ZJennifer—Schmidt1992-10-05null•••-••-0732—null9425 Desert Sky BlvdGilbertAZ85255GRP-9551MEDICARE-ADV-B
CLMCLM-4061202026-05-18T04:05:14ZJudith—Rivera1953-09-08UHC-82345-54—null-7771 LAKE VIEW ROADNashvilleTN37239GRP-6781-
CLMCLM-402832 2026-01-04T21:05:36ZLAWRENCE—MROGAN27-05-1970UHC-08471-65—549-868-5276—·3458 Forest AveTempe·AZN/AGRP-4682NULL
CLMCLM-4143492026-09-03T18:09:05ZWei—Castillo1960-11-18—UNKNOWN(906) 243-9468null2397 Willow Ct #781··Eden PrairieMN55392GRP-3982CORE-HMO
CLMCLM-4055102026-09-25T09:53:26ZlarryV.dean1985-10-03··UNKNOWN653-349-5722-2609 Spring StJACKSONVILLEFLN/AGRP-8749null
CLMCLM-4281722026-08-17T15:42:50ZJerry—Edwards1958-03-13NULL•••-••-1001--—-—NULL·N/AMEDICARE-ADV-B
CLMCLM-4085292026-06-26T08:29:08ZJUDITHMDEAN1998-06-17UHC4735396N/A9897444303··7492 MARKET STMesaAZ85270GRP-8103MEDICARE-ADV-A
CLMCLM-4295222026-02-10T14:49:02ZAisha—CunninghamApr 16, 1948——+1 345 895 2099aisha.cunningham@yahoo.com9144 Pine DrTempeAZ85272GRP-0231—
CLMCLM-4054852026-08-13T00:53:11Z LUIS—FERNANDEZ1939-03-16—•••-••-5410nullnull6230 Camelback RdAustinTexas78790—NAVIGATE-HMO
CLMCLM-4233862026-03-27T08:48:21ZMatt—Braldey1974-06-22NULL•••-••-6052(477) 602-4405—8537 Baseline Road #435GlendaleAZ··85300GRP-3843MEDICARE-ADV-A
CLMCLM-4260122026-03-28T05:11:28ZDavid—Powll1977-12-09UHC-52885-07—2035583675—2066 PALM DR··MiamiFL33177GRP-8484NAVIGATE-HMO
CLMCLM-4302142026-03-19T01:07:01ZMillar, Austin——2000-11-16UHC-05857-13•••-••-4256UNKNOWN—1627 CHURCH STREETMinneapolisMN55476GRP-9687NULL
CLMCLM-4195812026-04-11T16:43:14ZTran—Vincent1989-80-14UHC-61998-96··—null—3950 Harbor BoulevardSan DiegoCA··92172NULLCORE-HMO
CLMCLM-4016192026-10-09T16:21:50ZSophia····Fox06/20/73··UHC-96989-32——NULL5249 Sage CourtHouston··TX77012-MEDICARE-ADV-B··
CLMCLM-4064552026-08-29T12:20:15ZGrake—Mdina9/27/2001UHC-02912-01•••-••-2122-—6594 CANYON RDMinneapolisMN55417GRP-6238OPTIONS-PPO
CLMCLM-4164952026-05-19T10:13:39Zryan—lee1954-10-11UHC-63291-28-··+1 739 959 7825N/A990 Sage Court·GlendaleAZ85397GRP-8856OPTIONS-PPO
CLMCLM-4249892026-06-09T06:09:37ZJUDITH—AUSTIN·1948-11-12UHC-16752-93•••-••-7760(445) 868-8624null1210 MAPLE AVESacramento··CA·95846GRP-5890SELECT-EPO
CLMCLM-4203072026-03-27T03:16:54ZTYLER—MENDEZ1984-07-19UHC-76563-32N/A—-8168 CHURCH STTampaFLnullGRP-0208···-
CLMCLM-4168132026-05-04T19:34:09ZMarilyn··Ellioott12/8/1984UHC-00621-20———5553 Lake View RdGilbertAZ85253-—
CLMCLM-4169642026-03-22T19:21:48ZSHIRLEYQWAG1946-08-25UNKNOWN•••-••-0041-N/A9684 RIDGE ROADMesaAZnullGRP-4821CORE-HMO
CLMCLM-4130102026-04-29T14:05:56ZMARYYPOWELL2007-00-99UHC-10162-80•••-••-8784332.607.2968··2667 INDIAN SCHOOL RD Apt 37AtlantaGA30336GRP-4338NAVIGATE-HMO
CLMCLM-407261 2026-02-21T22:09:38ZAbigailCStone2009-12-07UHC7697320•••-••-1424—null9054 Mesa DriveTampaFL33681GRP-9208CHOICE-PLUS-PPO
CLMCLM-4109932026-09-06T14:01:07ZCarlos—Alvarez··05/24/46UHC-45709-79•••-••-4627—carlos.alvarez@yahoo.com·2196 Harbor BoulevardHoustonTX77096-5762GRP-0957CORE-HMO
CLMCLM-4198102026-01-05T20:51:48ZLawrence····Smiith1964-03-19UHC-22685-39····—LAWRENCE.SMITH@GMAIL.COM259 CENTRAL AVENUEOrlandoFlorida32877N/A—
CLMCLM-4086312026-08-22T05:32:18Zjulia—·powell1982-02-15UHC-20456-59NULLUNKNOWNN/A———NULLGRP-6492—
CLMCLM-418404 2026-10-06T20:14:14ZAnn—Simpson1/5/2006—•••-••-5868-ann.simpson45@gmail.com2030 CENTRAL AVEGILBERTAZ··85268GRP-8614··—
CLMCLM-4014172026-07-25T17:32:09ZBenjamin—Harris1978-11-02UHC-55813-93•••-••-7667—N/AN/A—-N/AGRP-8271null
CLMCLM-4137002026-03-14T08:11:07Z Vincent—Ruiz1975-11-21-—UNKNOWN-4505 Indian School RoadPLANOTX75029N/AMEDICARE-ADV-B
CLM CLM-4237892026-01-18T21:41:00ZBarbara—Hudson·1946-06-16-•••-••-42695798130866—3512 Forest AvenueFresnoCA93747nullNULL
CLMCLM-4156852026-08-19T15:10:23Z·Sophia—Lee20030311UNKNOWNnull-N/A528 Ocean AvenueGilbert··AZ85227—MEDICARE-ADV-B
CLMCLM-4289332026-04-30T08:19:47ZBaverly I—Davis1976-12-19·UHC-39550-29NULL2642854470—N/AN/AnullNULLnullSELECT-EPO
CLMCLM-4234632026-09-07T02:07:43ZJamesG.Smith1942-08-18—•••-••-1261-—UNKNOWNnullnullNULL—CHOICE-PLUS-PPO
CLMCLM-425594 2026-03-25T00:11:32Zsandra—davis02/20/65UNKNOWN•••-••-017714305948939UNKNOWN·680 Maple AvenueHOUSTONTX77046·GRP-3875SELECT-EPO··
CLMCLM-4259512026-08-04T16:43:19ZBRANDON····HARTApr 10, 1982-•••-••-4144642.277.9496UNKNOWN·N/A—nullNULLGRP-4985SELECT-EPO
CLMCLM-4148372026-06-23T10:41:48ZKATHLEENQ·TURNER1939-03-01UHC-07492-11•••-••-3506742.805.1949null8573 Park PlaceMesaAZ·85268GRP-2244select-epo
CLMCLM-4053592026-08-19T00:00:38ZGuzman, KeithP—01/10/98UHC-44567-20•••-••-0179(602) 719-8695NULL6289 Main StPhoenixAZ·85062·N/A—
CLMCLM-4052162026-04-20T10:20:51ZDavis, Carol——1951-10-03——·9155348032—8959 Cedar LnNASHVILLETN37233GRP-3470MEDICARE-ADV-A
CLMCLM-4020352026-07-16T15:14:21ZMATRHA··—DEAN1989-02-17UNKNOWN•••-••-2395919-204-3821—5105 SPRING STTempeArizona85250NULLN/A··
CLMCLM-4015382026-03-16T10:13:31ZEMMA—ESPINOZA1984-03-17UHC-28014-04•••-••-8719NULLUNKNOWN5393 UNION STREETMESAAZ85224GRP-0799—
CLMCLM-405760 2026-02-13T07:58:47ZBilly—Kng1986-10-17null•••-••-4954(793) 347-5889—381 SAGE CTHOUSTONTX77098GRP-3753—
CLMCLM-4188092026-07-26T20:52:03ZJORDAN—GREENE10/12/1986··UHC-15739-92-UNKNOWNnull3593 Central AvenueDallasTX75244—CHOICE-PLUS-PPO
CLMCLM-4220612026-04-30T13:15:32ZGeorge··RMason1696-06-26N/A··•••-••-2515UNKNOWNNULL··4247 DESERT SKY BOULEVARDCharlotteNorth Carolina·nullGRP-2098CORE-HMO
CLMCLM-4109762026-06-23T10:04:21ZDENNY—HAMILTON1990-01-87UHC-00203-27•••-••-91617818775065·null4256 OCEAN AVECOLUMBUSOHUNKNOWNNULLN/A··
CLMCLM-4130662026-07-01T23:54:01ZSTEPHENY.MONTGOMERY11/13/1975UHC5792364—516.458.4594··-NULLNULL—nullUNKNOWNUNKNOWN
CLM CLM-4082352026-02-19T06:15:09ZWILLIE··FOX7/18/1959UHC-90861-56··UNKNOWNNULL6086 Harbor BoulevardMesaAZ··-—MEDICARE-ADV-A
CLMCLM-4202942026-02-27T19:57:21ZCheryl—Andrews·Jun 1, 1942UHC-74091-14··•••-••-5870-····3779 Jefferson AvePlanoTX75011-3894··NULLCHOICE-PLUS-PPO
CLMCLM-4140032026-01-24T05:33:41Znancy—mills1981-07-20UHC-00702-28—(470) 638-9323—7380 OAK STCharlotteNC28244N/Aselect-epo
CLMCLM-4210472026-08-25T00:38:32ZDanielR.Jimenez1956-02-18UHC9210363—16512437620-4505 Hillcrest RoadSacramentoCA95817-7310GRP-1145NULL
CLMCLM-4282342026-02-12T15:49:23ZDenise—Lopez1943-02-06UHC-27821-65····-UNKNOWN1337 Sage Ct·ScottsdaleAZ85206GRP-4990OPTIONS-PPO
CLMCLM-4099972026-04-22T03:50:10ZMorris, KevinE.—1995-12-22UHC-47442-06NULL—UNKNOWNN/AN/AN/A-—-
32,829 rows, page 199 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:43.417Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty