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-4319712026-08-12T19:28:57ZCAROLYN—JACOBS1954-07-07UHC-51019-83•••-••-8352N/ANULL4870 Main St··ChandlerAZ85260GRP-4811SELECT-EPO
CLMCLM-4223692026-04-29T12:11:15ZBruce—Dean1983-05-07UHC-92761-61•••-••-9175450.375.4132N/A1899 Oak StHOUSTONTX77033GRP-7502N/A
CLMCLM-4006782026-03-18T05:52:59ZCATHERINE—MORRISON1988-12-13N/A•••-••-4469+1 833 252 6471—3792 Desert Sky Boulevard··CharlotteNC28291GRP-4290null
CLMCLM-4004592026-09-22T08:21:06ZjaniceC.santiago0807-14-90·N/A———210 Highland AveTucsonAZ85789UNKNOWNNAVIGATE-HMO
CLMCLM-4217172026-05-21T15:30:07ZJordanT·Garza2008-05-17UHC-49606-85N/A795.812.4298null··8012 Bayshore DrChandlerArizona·N/ANULLCHOICE-PLUS-PPO
CLMCLM-4189512026-10-14T20:56:26ZOmar—Hunt1938-05-20UHC-97434-51•••-••-38934543629865-9314 Bayshore DriveLos AngelesCA90085·null-
CLMCLM-4003002026-02-22T13:07:43ZWAYNE—ANDERSON1962-01-16UHC-02479-04———3004 Main StreetDenver·Colorado80262··—N/A
CLMCLM-4268512026-05-04T14:43:24ZAaron—Scott·1982-12-27UHC-25529-53UNKNOWN—N/A4438 LINCOLN WAY··SeattleWA98129GRP-8781NAVIGATE-HMO
CLMCLM-4155232026-05-08T17:25:47ZBruce—Reynolds··1945-07-01UHC-33418-96-13325831335-··8688 APACHE BLVDGlendaleArizona85382N/AOPTIONS-PPO
CLMCLM-4059682026-07-23T15:42:41ZJanice—·Hill1944-06-25UHC5248549UNKNOWN-UNKNOWN4290 MESA DRIVEEDEN PRAIRIEMN55318··GRP-6344UNKNOWN
CLMCLM-4204992026-06-26T04:48:21ZCharlotte—·Sanders04/13/78-•••-••-8502709.824.8985—2361 Willow CourtEden Prairie·MN55354-·MEDICARE-ADV-B
CLMCLM-4024072026-06-28T20:32:57ZAnn··—Harris1985-01-28··UHC-15134-26——UNKNOWN2557 Willow CourtDALLASTX75206··—OPTIONS-PPO
CLMCLM-4125982026-10-04T09:17:53ZKathleen—Brown14-08-1994UHC-43169-47•••-••-7491746-922-8012··—3092 Sage CourtOrlandoFL32854NULLMEDICARE-ADV-A
CLMCLM-4074212026-01-29T02:37:20ZGLORIA—·FOWLER9/7/1964UHC-72716-32NULL—N/A-——UNKNOWNGRP-8358UNKNOWN
CLMCLM-4130632026-01-03T13:07:40ZAnthony—Lewis19520809UHC-99074-50-UNKNOWN-7328 Union StHoustontx77058N/A—
CLMCLM-420786 2026-04-11T19:19:18ZJORDAN··LI2004-01-13N/A•••-••-43417958578230—6736 Mesa DrORLANDOFL32894—MEDICARE-ADV-B
CLMCLM-4190752026-03-28T00:33:37ZJASON—GRAY1983-11-23··UHC-15887-53··•••-••-9855(248) 469-7238-3678 Spring StreetGilbertAZ85264GRP-0596MEDICARE-ADV-B
CLMCLM-4263492026-05-12T11:29:07ZMARIA—JORDAN04/01/79UHC-32080-45UNKNOWN—····7536 CENTRAL AVENUEAtlantaGA30385GRP-5083NULL
CLMCLM-4208952026-03-24T23:32:45Z·SamanthaSJones1956-09-12UNKNOWN•••-••-1515—UNKNOWN8027 UNION STREETTucsonAZ85787GRP-3734NULL
CLMCLM-4037392026-04-21T01:01:48Zgerald—cunningham1983-06-15UHC-15167-50UNKNOWN·NULL—N/A—N/A-——
CLMCLM-408266 2026-05-09T19:52:06ZAlice·W.Duncan1962-04-05——8075082517—4992 Church StreetSeattleWA··98161GRP-5994MEDICARE-ADV-A
CLMCLM-4216862026-02-12T05:43:35ZMurphy, Jonathan——1988-04-25UHC-59517-51UNKNOWN+1 604 470 3811—1540 Canyon RdMesaAZ85299GRP-6692SELECT-EPO
CLMCLM-4139882026-05-14T11:26:38ZGary—Jensen1950-07-25—UNKNOWN··nullgary.jensen@proton.meUNKNOWNUNKNOWN—UNKNOWN—CORE-HMO
CLMCLM-4284112026-09-06T08:49:15ZLauren—Phillips··Jan 1, 1966···UHC1920641-3512567156NULL8819 Sunset BoulevardSeattleWA··98177GRP-1040MEDICARE-ADV-B
CLMCLM-4001642026-02-25T20:11:50ZCHARLOTTE—WHEELER0133-19-64UHC-02876-57•••-••-1875UNKNOWNUNKNOWN8961 Park PlaceSacramentoCA·95844—UNKNOWN
CLMCLM-4322442026-01-12T15:23:19Z Frank—Allen07-11-1974UHC-03524-51•••-••-01786138829522NULL——NULL——N/A
CLMCLM-4252712026-01-13T19:57:36ZEvans, BruceU—1946-06-09——+1 411 945 6514NULL2759 Spring StCharlotteNC28204-2345N/ACORE-HMO
CLMCLM-4060622026-05-16T00:38:12ZSARA····BURTON28-03-1938UHC-95297-67-null—2589 Canyon RoadATLANTAGA30328GRP-0305-
CLMCLM-4220822026-10-04T12:14:42ZSofia··—Kelly1946-04-05UHC-33102-93—9365977430—8132 Elm StreetGLENDALEAZ85320GRP-1581······
CLMCLM-4079872026-02-26T17:26:02Z·Katherine—Ford1939-07-16UHC-11119-53•••-••-9234UNKNOWN-9302 Main Street··TucsonAZ85720GRP-0415OPTIONS-PPO
CLMCLM-4258442026-08-23T23:43:12Z·NOAH—WATKINS20010205··—NULL+1 794 678 3671N/AN/A——UNKNOWNGRP-8932UNKNOWN
CLMCLM-4018442026-05-30T06:11:45ZMadisno—Wood01/25/1998UHC-82152-40•••-••-69859047880823-7666 SUNSET BOULEVARDMinneapolisMN—GRP-6195—
CLMCLM-4033102026-10-14T09:35:15ZJustin—Palmer1950-09-24UHC-44225-20•••-••-9348NULL—··UNKNOWN-N/AGRP-8364N/A
CLMCLM-4118152026-02-05T19:54:00ZASHLEY—REYES··1948-10-05UHC-44896-67—UNKNOWNnull6513 Central AvenueScottsdaleAZ85236-SELECT-EPO
CLMCLM-4043652026-06-14T07:22:15ZMarilyn··—Willis·19970615-NULL18272927043··NULL8924 Grand AvenueAtlantaGA30334GRP-3815N/A
CLMCLM-4018682026-03-13T03:13:23ZAndrews, NicholasK··—11/19/1985null··•••-••-2502NULLnull··4409 LINCOLN WAYDallasTXNULL·GRP-5321choice-plus-ppo
CLMCLM-4207032026-08-15T14:50:52ZLauren—Gutierrez1942-10-10—•••-••-2031·440.908.3769—NULLNULLNULL—GRP-2922MEDICARE-ADV-A
CLMCLM-4121762026-05-29T23:16:12ZYoungGKayla1993-08-02UHC-40548-30—6620510NULL—null—nullGRP-8160-
CLMCLM-4096632026-01-04T15:19:02Z Timothy—Welch3/3/1945UHC-08254-58NULL—NULL·7717 Central AvenueScottsdaleAZ85289GRP-5200null
CLMCLM-4125012026-08-20T06:14:01ZDenny—Dunn1985-02-25UHC-21945-46-788-450-1406dennis.dunn@hotmail.com4708 VALLEY VIEW DR··TUCSONAZ85718GRP-3500CORE-HMO
CLMCLM-4153112026-02-26T16:46:30ZJACQUELINE—HARVEY05/08/73NULL·-—nullNULL-nullUNKNOWN··GRP-6609NULL
CLMCLM-4160822026-05-25T22:46:20ZPRIYA—HOWARRD1977-10-20UHC-63338-41—null··UNKNOWN269 Desert Sky BlvdChandlerAZNULLGRP-2282SELECT-EPO
CLMCLM-4301332026-08-26T11:54:47ZPATRICK—TORRES19770720UHC-30389-16UNKNOWN302-983-9746UNKNOWN9888 Sunset BoulevardLos AngelesCA·90000—UNKNOWN
CLMCLM-4178692026-01-05T05:08:49ZHeather—·Sanchez06/03/1996—•••-••-7781NULL—3323 Park PlCHANDLERAZ85293GRP-4514null
CLMCLM-4042892026-04-25T06:08:29Z·JOSEPH—PORTER1950-10-08UHC-81208-98•••-••-6789770.357.1209N/A6339 VALLEY VIEW DRIVEChandlerAZ85245GRP-6305··OPTIONS-PPO
CLMCLM-4322722026-10-02T12:18:10ZRICHARD—BISHOP1948-01-13··-•••-••-1893612-734-0011—4532 Jefferson AveSan AntonioTX·78256GRP-3971NAVIGATE-HMO
CLMCLM-4295512026-10-09T12:42:23ZANNA··HARVEY1968-10-09—UNKNOWN777-574-5458—·3429 Forest AvenueChandlerAZ85274·GRP-6591CORE-HMO
CLM CLM-4029972026-07-05T23:54:09ZMATEO—MALDONADO1971-06-02UHC-32508-33N/A2815363236UNKNOWN——N/A—·GRP-9004CHOICE-PLUS-PPO
CLMCLM-4213172026-02-27T22:06:36ZAbigailQ·Soto1975-12-20—N/A—NULL7611 LAKE VIEW RDSan DiegoCA92165N/A····
CLMCLM-4018872026-07-30T19:24:13ZGabriel—Hanson1981-07-24UHC-35795-37N/A—gabriel.hanson@aol.com6139 HIGHLAND AVENUEFresnoCA93780····NAVIGATE-HMO
32,829 rows, page 210 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.433Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty