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-4125312026-07-07T08:53:56ZKARENE.WAGNER19950207—····-null3199 Market Street·NashvilleTennessee37213—UNKNOWN
CLMCLM-4155512026-06-25T05:47:09ZGeorge—Owens04/26/1938··NULL•••-••-7060N/A—·491 UNION STREET·GlendaleAZ85322GRP-7042OPTIONS-PPO
CLMCLM-4006822026-05-13T04:03:12ZAnthonyQ.Kelly2000-12-23UHC-84357-74UNKNOWN—··5361 SUNSET BOULEVARDEden PrairieMN55325GRP-4330CORE-HMO
CLMCLM-4141332026-03-01T08:59:34ZKarenN.Welch1955-01-05UHC-51273-02•••-••-40585568119896-5842 WASHINGTON STREETPlanoTX75096-1231N/AMEDICARE-ADV-A
CLMCLM-4059502026-08-30T20:10:50ZJoe—Martin19840515N/A•••-••-5043N/ANULL9554 BroadwayNashvilleTN37269nullMEDICARE-ADV-B
CLMCLM-4240382026-07-25T11:25:20ZCruz, AhmedC—1986-04-22UHC-49614-51—····N/AUNKNOWNnull-·N/AN/A—
CLMCLM-4323462026-09-24T23:50:34ZWeber, MichaelA.···11/17/1950UHC8001973—266-520-1176-3529 Washington StColumbusOH43270GRP-4442NULL
CLMCLM-4248752026-01-15T19:11:56ZSANDRA··TRAN1993-10-02··UHC-11924-51nullN/A-N/AnullUNKNOWNN/A—NULL
CLMCLM-4124352026-01-21T07:38:08ZMaria—McDonald0208-06-24·-N/A·NULLnull8439 ELM STHoustonTexas77044-MEDICARE-ADV-A
CLMCLM-4113232026-02-12T18:23:50ZJEAN—GRIFFIN20050912UHC-83368-23-NULLUNKNOWN4142 UNION STREETLAS VEGASNV89168N/A··-
CLMCLM-4101062026-02-10T08:58:11ZAbigail—Reynolds1976-04-27NULL··-·NULL—8152 Ocean AveSeattleWA98149—null
CLMCLM-4104002026-09-02T14:17:36ZAnaKRobinson1955-02-02—•••-••-1224UNKNOWN——UNKNOWNnullNULLGRP-6756··
CLMCLM-4322862026-03-21T04:18:51ZCHRISTIANQWHEELER·1976-08-08UHC8407299•••-••-8465UNKNOWN——null····N/A··GRP-8066—
CLMCLM-4016762026-05-31T05:38:02ZBRIAN—SNYDER19691119N/A-14712487301NULL··6722 Grand AveChandlerAZ··85212GRP-7063CHOICE-PLUS-PPO
CLMCLM-4185122026-05-14T06:43:14ZbrandonM.gbison1997-12-20UHC-73891-30NULL····NULL3199 Desert Sky BoulevardHoustonTX77023—NAVIGATE-HMO
CLMCLM-4269902026-01-16T23:00:11ZMARTAHPJENKINS1987-01-51UHC3810873UNKNOWN294-476-9082—8650 APACHE BLVD Apt 4SacramentoCA95821GRP-5107core-hmo
CLMCLM-4093482026-03-04T03:34:43ZMatthew—Romero·1972-07-08UHC-57072-21•••-••-9717—-··138 MARKET STREETTempeAZ85226GRP-7902MEDICARE-ADV-B
CLMCLM-4194982026-08-04T00:42:04ZMason·OJenkins1956-09-19UHC-24242-13•••-••-0954NULLUNKNOWN8141 Harbor BlvdGilbertAZ85219··nullOPTIONS-PPO
CLMCLM-4085492026-03-02T05:32:39ZROBERT—GREENE1993-07-26UHC-26139-06•••-••-78227046929979NULL6881 Meadow LaneTampaFL33641NULLnull
CLMCLM-417217 2026-09-12T22:47:43ZMurphy, KateT—9/2/2001—•••-••-1998344-626-2127·N/A5536 MAIN STMiamiFL33178—medicare-adv-b
CLMCLM-4273762026-09-29T05:23:44ZAnaA.··Cox1981-07-08—•••-••-0321—N/A8684 MAIN STTempeAZ85216-··null
CLMCLM-4207232026-01-03T20:46:53ZRUSSELL—FERNANDEZ19770525UHC-14589-20•••-••-59095935565458—·1840 CAMELBACK RDDallasTX75281UNKNOWNnull
CLMCLM-4237342026-05-17T11:50:00Zluis—alexander04/27/1951··UHC-27605-62—N/ANULL2773 Hillcrest RoadLas Vegas·NV89178UNKNOWN··
CLMCLM-4043332026-07-28T07:20:07ZSharon—MillerMar 24, 1960—•••-••-7382801.965.2436NULLUNKNOWNNULLnull—NULLOPTIONS-PPO
CLMCLM-4141072026-02-03T09:18:53ZWaltrLEstrada3/23/1990··—UNKNOWNNULL—4182 Main St··San AntonioTX78217—-
CLMCLM-4256042026-06-07T17:44:07ZLaurenPWang1963-08-19NULL•••-••-96408896251698—6246 PARK PLACENashvilleTN37252—NULL
CLMCLM-4283792026-08-10T21:03:34ZCheryl—Bradley1981-08-26—•••-••-99738338027279null1119 Lake View RdOrlandoFL32858GRP-7953MEDICARE-ADV-A
CLMCLM-4297362026-04-16T23:10:30Zchristina—jimenez04/19/1958··NULL··N/A(386) 297-6335····4263 OCEAN AVENUEChandlerArizona85200GRP-0646MEDICARE-ADV-B
CLMCLM-4172502026-07-01T01:25:44Zmartha—henderson2008-10-26UHC-24638-57-NULL—6710 Washington StreetMinneapolisMN55437N/A-
CLMCLM-4145352026-08-02T12:45:08ZPatriccia··Wang1950-08-14UHC-99901-23—9345370419UNKNOWN————UNKNOWNUNKNOWN
CLMCLM-4317282026-01-04T12:47:44ZELIZABETH—SCHULTZ12-06-1981UHC-50432-56-——·8960 Union StreetPhoenixAZ85065GRP-5273MEDICARE-ADV-A
CLMCLM-4230012026-02-08T01:41:30Z ·Ashley—·Castro1952-07-15·UHC-81991-63N/A(520) 678-8936—2511 Camelback RoadDENVERCO80265GRP-8450·UNKNOWN
CLMCLM-4036012026-05-07T10:55:53ZMaryK·Rogers1943-04-11UHC-81130-66null476-819-4588··-3310 Washington StreetScottsdaleArizona85202GRP-0359MEDICARE-ADV-A
CLMCLM-4024302026-04-03T16:01:41ZHiroshi—West1974-08-08UHC-60964-87null··15019621321—2311 Bayshore Dr··TucsonAZ··85757-····
CLMCLM-4215742026-04-22T18:00:47ZMADISONE.MOORE2001-01-14UHC-36940-63•••-••-2134UNKNOWN··N/A6393 GRAND AVETempeAZ85260-8291GRP-9212NULL
CLMCLM-4032042026-04-15T07:58:18ZMARINAA—COLLINSSep 24, 1966·UNKNOWN—nullUNKNOWN9011 Pine DrJacksonvillefl32277UNKNOWNSELECT-EPO
CLMCLM-4139072026-09-27T15:03:35ZKathryn—Sims1967-11-06-—9753018836NULL9716 River RdMinneapolismn55478-2453GRP-2823null
CLMCLM-4291282026-06-08T19:52:03ZDIANE—DIAZ1958-03-01UHC3101876•••-••-9587N/Anull3673 Ocean AvenueATLANTAGeorgia30336GRP-7582-
CLMCLM-4029782026-09-23T18:04:25Z Mson—Santos21-03-1964UHC1043264··UNKNOWN——8308 Canyon Road #517GlendaleAZ85385GRP-1369NAVIGATE-HMO
CLMCLM-4041732026-06-17T13:51:23Z—····—12/22/1957···UHC-14266-65•••-••-4407—····5404 Market StreetHoustonTX77069GRP-6357··OPTIONS-PPO
CLMCLM-4089262026-02-09T04:57:46Z Eugene—Patterson1974-02-26··NULLUNKNOWN··N/A9170 Spring StMiamifl33199GRP-7931OPTIONS-PPO
CLMCLM-4147902026-02-18T23:11:19ZBRENDA—CRAWFORD2082-19-54—•••-••-41464626064389··—NULL-null—GRP-1028MEDICARE-ADV-A
CLMCLM-4002512026-01-03T06:44:19ZMAGGIE·····HICKS2008-06-15UNKNOWNNULL971-629-6610N/A2960 Central AvenueOrlandoFL32853GRP-7828··SELECT-EPO
CLMCLM-4134282026-10-08T14:45:48ZKyle····Richards1981-02-28UHC-09435-37•••-••-7658NULLN/A1539 Indian School RdMINNEAPOLISmn55433GRP-8660CORE-HMO
CLM CLM-4237042026-03-30T22:41:09Z doris—barnes03/13/1980uhc-22231-79•••-••-52935683394—··NULL—null·GRP-8082null
CLMCLM-4238742026-01-02T05:51:27Zjennifer—vargas1989-11-03-•••-••-9425N/AUNKNOWN2753 RIVER RDPlanoTX·75058GRP-9763MEDICARE-ADV-A
CLMCLM-4129822026-09-03T10:26:27Zkatherine—dixon19890728—N/A15007103246N/A9088 UNION STSan DiegoCA—N/A··NULL
CLMCLM-4201582026-08-06T13:42:35Z———05-11-1946··UHC-87019-89-—-3708 Apache BlvdScottsdaleAZ··-GRP-9068—
CLMCLM-4135992026-07-25T16:06:42ZCarr, Steven——0142-19-67UHC-95393-63-—NULL3232 Willow CourtHoustonTX·77057—OPTIONS-PPO
CLMCLM-4167132026-04-28T05:13:04ZElijah—Torres19680321—UNKNOWN9883370211N/A··7315 CHURCH STREETEden PrairieMN55333-NAVIGATE-HMO
32,829 rows, page 63 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.719Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty