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-4128042026-08-09T05:37:09ZJESSEHSTEVENS1992-11-10·N/A•••-••-7055(522) 432-1924jesse.stevens@icloud.com2642 Harbor BlvdGilbertAZNULL—··
CLMCLM-4241592026-03-24T06:45:39ZHerrera, Danielle——1948-03-21UHC-14995-82—+1 457 738 7148N/A—nullUNKNOWNN/AGRP-3533null
CLMCLM-4151502026-02-04T20:04:59Zlinda—mcdonald19870312UHC8939386-UNKNOWNnull3863 BroadwaySan Antonio··TX78286GRP-5525N/A
CLMCLM-4176262026-03-17T11:58:02ZOMAR—SANDOVAL1988-10-09UHC-06877-43—931-743-7233NULL6551 Grand AvenueSan Antonio·TX78223··GRP-0289UNKNOWN
CLMCLM-4235892026-08-02T03:41:56ZKEVIN—SINGH20-08-1994NULL•••-••-7405nullUNKNOWN-nullN/A··N/AGRP-0864MEDICARE-ADV-A
CLMCLM-4210972026-03-05T04:20:03ZDENNIS—HOLMES1981-01-15UHC-23663-34N/ANULLnull··8792 Elm StreetMiamiFL33153GRP-1143MEDICARE-ADV-A
CLMCLM-4050632026-03-30T23:15:57ZAustin—Berry2007-04-07UHC-63286-32•••-••-7128N/A—4427 Washington StNashvilleTN·37276GRP-3471··OPTIONS-PPO
CLMCLM-4077932026-07-28T09:37:42ZSCOTT—LONG2005-01-19UHC-92078-40—3365227421—333 Pine Drive··San DiegoCA92132-null
CLMCLM-4322182026-06-12T22:19:52Zharold—hart11-04-1994UHC-36348-42N/A600-232-9636—2280 VALLEY VIEW DRFresnoCA93746——
CLM CLM-4229072026-08-05T21:11:14ZLAURA—WEBER09/14/1941·UHC7040026•••-••-0825(390) 817-0764nullN/A—N/A—-N/A
CLMCLM-4168762026-02-13T06:06:38ZKevin—Reid13-06-1942UHC5941737··——N/A-—N/A·UNKNOWN——
CLMCLM-4169332026-02-26T19:50:40Z·WILLIE····HARPER2000-09-13UHC-88343-77NULL-—750 CENTRAL AVEGilbertAZ85211NULL··—
CLMCLM-4185922026-08-17T16:20:43Zcatherine··—·coleman·08/12/04UHC-75249-39—5508284224-4690 Camelback RoadSan AntonioTX78292-6581GRP-9124CORE-HMO
CLMCLM-4178192026-07-20T15:25:57ZSharon—Cox1949-11-02UNKNOWN•••-••-5485··N/A4839 Ridge RdSAN ANTONIOTX·UNKNOWNGRP-0727SELECT-EPO
CLM CLM-4046012026-08-12T18:35:22ZRussell—·Elliott2002-09-26—null7635165615null8498 CAMELBACK RD··San Diego··ca·-—UNKNOWN
CLMCLM-4300392026-03-08T16:24:23ZTimothy P—George1941-06-24UHC-62919-01•••-••-13962412813785—4259 Valley View DrSan Diego··California—GRP-1101·UNKNOWN
CLMCLM-4296152026-08-21T21:54:01Z KEVIN—PATEL1986-11-19UHC8145464UNKNOWN——6854 PARK PLSEATTLE··WA98140-MEDICARE-ADV-B
CLMCLM-4096242026-09-15T06:19:31ZBRUCE—ADAMS08/25/43NULL•••-••-1339null-1940 Grand AvenueAustintx78733GRP-1488NAVIGATE-HMO
CLMCLM-4023082026-09-01T04:38:38ZSteven—Griffin19640603UHC-31694-08-·923-373-6481steven.griffin45@yahoo.com7957 SPRING STREETLos AngelesCA90041GRP-5962MEDICARE-ADV-A
CLMCLM-4184522026-03-15T21:28:12Zjulia····jackson1986-05-03UHC0053803•••-••-2494—-9856 Maple AvenueSan AntonioTX·78252GRP-0904CHOICE-PLUS-PPO
CLMCLM-4194332026-02-13T05:42:49Zsingh—jennifer1962-11-02UHC-83847-54-·N/A—4343 River RoadMinneapolisMN55413N/AMEDICARE-ADV-A
CLMCLM-4076092026-09-01T12:36:46ZRichardQ.Washington2006-06-16-—·(540) 840-0677UNKNOWN8427 Camelback RdGlendaleAZN/AUNKNOWNOPTIONS-PPO
CLMCLM-4252472026-02-02T10:36:12ZAISHA····MONTGOMERY1941-08-14UHC-04709-66•••-••-95582963761893·--N/AUNKNOWN—GRP-8632-
CLMCLM-4189762026-06-29T04:31:11ZSharon—Ortega1972-05-08UHC-75713-53—(936) 639-0348—·9011 Willow CtAtlantaGeorgia30306—SELECT-EPO
CLMCLM-4192472026-07-15T23:10:08ZSOPHIACBELL11/12/1946-—-NULL381 JEFFERSON AVEScottsdaleAZ——·UNKNOWN
CLMCLM-4178202026-05-23T19:49:39ZRachelLKnight19-08-1952-··•••-••-3452596-229-8603—N/Anull—····GRP-5154··CORE-HMO
CLMCLM-4304562026-06-01T05:04:54ZRALPH—GRCIA0421-29-45UHC-55034-74•••-••-5319N/AUNKNOWN2592 FOREST AVEMiamiFL33115-2292UNKNOWNCHOICE-PLUS-PPO
CLMCLM-4291632026-06-01T02:27:18ZCAROLYNK··FULLER1996-12-10UHC-10166-76•••-••-4941UNKNOWNnull————N/AMEDICARE-ADV-A
CLMCLM-4088262026-07-31T23:18:38ZJUAN—ELLIS7/2/1996nullN/AUNKNOWNUNKNOWN3402 River RdEDEN PRAIRIEMN··55362GRP-9939N/A
CLMCLM-4112572026-03-13T18:07:35ZJess—Vargas1971-11-27—N/A+1 437 482 6481—4014 Sunset BoulevardGlendaleAZ85329GRP-3565MEDICARE-ADV-B
CLMCLM-4085922026-05-21T20:03:00ZGeorge··Patterson1983-02-09UHC-34242-48UNKNOWN··(608) 512-5623UNKNOWN·5376 CENTRAL AVESAN ANTONIOTX78205—NULL
CLMCLM-4216472026-10-02T03:59:17ZKATHRYN—FORD1995-01-12UHC-66109-47—·+1 310 638 3894N/A·779 VALLEY VIEW DRIVESeattleWA98108GRP-4652MEDICARE-ADV-B··
CLMCLM-4167032026-01-04T12:31:56ZANNA····WEBB·1961-05-16UHC-91806-14•••-••-16482855550737—N/AUNKNOWN·UNKNOWN··GRP-8372N/A
CLMCLM-4075842026-01-12T13:40:57ZHANNAH—CLARK1981-05-15UHC-95602-29•••-••-4185(681) 992-6218HANNAH.CLARK4@OUTLOOK.COM2713 Jefferson AvenueFresno·CA93737GRP-5671NAVIGATE-HMO
CLMCLM-4055872026-10-15T09:24:16ZHelen—Snyder1952-08-03—•••-••-4019-NULLNULL—-———
CLMCLM-4314692026-03-08T03:59:04ZKIM—HEATHER0401-20-60UHC3348145——UNKNOWNUNKNOWNNULLnullN/AGRP-3229NULL
CLMCLM-4324652026-06-23T01:18:32ZStewart, Michael——0211-19-98UHC-09021-38•••-••-9507(296) 342-3490NULL6202 WASHINGTON STREET Apt 34San DiegoCA92163—null
CLMCLM-4196752026-03-15T13:35:47ZnoahFmoore·1963-07-27UHC-12184-09•••-••-4948-—NULL-NULL—GRP-4932—
CLMCLM-4181472026-09-29T18:39:28Z·VINCENT—THOMAS1939-06-11nullnull18993797926—--NULL———
CLMCLM-4239182026-06-12T01:49:34ZALICE··—MEYER1980-10-04UHC-24459-46null(411) 807-3364null··7448 Mesa Drive Apt 38ChandlerAZ85272null··null
CLMCLM-4055992026-06-29T14:33:48ZMADISON—SIMMONS06/11/70UHC-47808-51NULL16113802927NULL1841 LAKE VIEW RDSacramentoCA95862GRP-9662—
CLMCLM-4121842026-02-28T09:18:07ZKATHRYN—HART22-10-1983UNKNOWN—6156147128—1868 Park PlaceJacksonvilleFL32215——
CLMCLM-4179162026-02-10T17:13:03ZJudith··—West1964-07-26····•••-••-7460-—9842 BroadwayGilbertAZ85238—CORE-HMO
CLM CLM-415425 2026-01-10T21:23:28ZAhmed—Hernandez1942-04-15UHC-21736-01··•••-••-3576-UNKNOWN3347 Jefferson AveSacramentoCA95805GRP-4600N/A
CLMCLM-4254442026-10-07T17:19:57ZLiz—Weaver1985-07-09UHC-21629-88•••-••-9662—elizabeth.weaver@gmail.com2357 Ocean Avenue #446San AntonioTX78239GRP-9943··UNKNOWN
CLMCLM-4192322026-02-09T17:08:53ZCHRISTINA—MORGANMar 17, 2007UHC-99715-06•••-••-9876-null5927 Cedar LnPhoenixAZ85021GRP-6359UNKNOWN
CLMCLM-4195782026-01-15T05:25:35ZAshley—OBrien1950-02-12UHC-95905-89-N/A—-—N/A—GRP-9365—
CLMCLM-4004252026-05-10T17:48:00ZJaacqueline—Chen07-08-1997··UHC-37309-92—703-247-8775UNKNOWN5143 Grand AvenueLos AngelesCA90011null-
CLMCLM-4242182026-09-03T06:30:30ZLuis—Larson··08/22/79UHC-85158-48—+1 264 457 1080luis.larson11@yahoo.comnullNULLNULL····nullMEDICARE-ADV-A
CLMCLM-4061022026-09-22T03:34:05ZSANTIAGOJ.CRAWFORDMay 22, 2005N/A-—-null-null—GRP-2075-
32,829 rows, page 101 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.458Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty