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-4135892026-06-05T23:20:18Z Ahmed—Hayes10/10/1995UHC-59600-25—2407723846—1557 Baseline RoadFresnoCalifornia93702GRP-4401-
CLMCLM-4007872026-03-10T06:12:17ZKnight, Alice——1958-06-21··uhc-58125-21N/A470-826-2531ALICE.KNIGHT@ICLOUD.COMN/A—NULLUNKNOWNGRP-2336—
CLMCLM-4063162026-03-02T21:32:49ZSantiago—Oliver9/27/2001UHC-67432-85•••-••-2057(752) 363-3157SANTIAGO.OLIVER@ICLOUD.COM2408 Church StORLANDOFL32861GRP-1948—
CLMCLM-4160242026-03-29T09:08:35ZBRNDA—NELSON1946-06-04UHC-04067-06——brenda.nelson@outlook.com1315 Market StreetGilbertaz—····SELECT-EPO
CLMCLM-4142282026-02-01T01:30:38ZJesse—Reyes2006-02-10N/A—(272) 211-9943N/A3997 Canyon RoadMesaAZUNKNOWN—SELECT-EPO
CLMCLM-4045972026-06-04T21:09:07ZHansen, Gary——5/10/1975UNKNOWN•••-••-4743nullnull4171 BAYSHORE DRMinneapolisMN55423-4932··—MEDICARE-ADV-B
CLMCLM-4076872026-08-06T16:42:27ZNatalie—Burton1967-05-28UHC-11073-50•••-••-0917·NULLNULL·523 Main StTucsonAZ··85769NULLSELECT-EPO
CLMCLM-4180332026-02-23T03:19:03Zmaria—phillips1951-03-08UHC-57959-42—738-664-9942nullNULLN/AnullUNKNOWN·GRP-7890NAVIGATE-HMO
CLMCLM-4289242026-10-18T00:02:48ZFRANK—WOODS19860120NULL•••-••-4440-—UNKNOWN-nullN/AnullN/A··
CLMCLM-4153302026-07-12T19:52:06ZBryant, Bruce——04/09/00UHC-31867-72•••-••-7728—UNKNOWN9841 Meadow LaneChandlerAZ85236GRP-6890CORE-HMO
CLMCLM-4034122026-09-05T08:32:33ZKevinJCunningham20020711UHC-11004-76•••-••-0579——7149 PARK PLLos AngelesCA90083GRP-8041MEDICARE-ADV-B
CLMCLM-4163702026-03-02T11:42:27Zlisa—riceJul 12, 1975UHC-13130-09—-UNKNOWN·1330 Ridge RoadPhoenixAZ85094UNKNOWNselect-epo
CLMCLM-4327402026-06-30T18:09:57ZEUGENE—OBRIEN20051005UHC-43357-48•••-••-1256-—3202 Spring StreetFresnoCA93784——
CLMCLM-4193322026-08-13T11:22:35ZGREGORYFJAMES22-03-1971UHC-64701-90——NULL669 Desert Sky BoulevardSan AntonioTX78294-3755GRP-7365MEDICARE-ADV-B··
CLMCLM-4249962026-10-11T21:46:52ZMarilyn—Berry05/02/82UHC-72413-38•••-••-7506(506) 814-2068—3353 Mesa DrSacramentoCA95860UNKNOWNnull
CLMCLM-4265342026-03-27T11:22:50Zcatherine—·medina1970-09-07-NULL——N/ANULLUNKNOWNUNKNOWNN/A—
CLMCLM-4145342026-10-14T02:06:07Z Patricya—WangAug 14, 1950UHC-99901-23—NULL—8628 MAPLE AVEPLANOTXNULL··—
CLMCLM-4300432026-03-09T15:52:52ZMEIB.WALSH1980-04-15——NULL-6193 CHURCH STOrlandoFlorida32806GRP-0871NAVIGATE-HMO
CLMCLM-4028092026-01-27T03:25:28Zadam—lynchJan 24, 1996UNKNOWNnull12275445744-6693 Elm StJacksonvilleFL32265GRP-2612CHOICE-PLUS-PPO
CLMCLM-4010582026-02-26T05:38:17Z CHARLES—HUNTER1989-06-08—•••-••-6027——5023 Elm Street Apt 4··TempeAZ85267GRP-3530—
CLMCLM-4256752026-10-02T22:07:28Zbryan—ray1958-11-20UHC-15231-85—UNKNOWN—9671 INDIAN SCHOOL ROADTucsonArizona85765-8741N/Anull
CLMCLM-4056722026-09-05T06:00:19ZDiego··EJohnstno1956-02-16UHC-82913-21·null—N/A———NULLGRP-9352options-ppo
CLMCLM-4177272026-01-21T23:37:45ZYang, Logan—··09/12/67UNKNOWN•••-••-3633NULLN/A219 Lincoln Way #494··San AntonioTX78217GRP-5911··MEDICARE-ADV-B
CLMCLM-432354 2026-04-07T23:21:18ZLidna—Payne19931206UHC-07120-79•••-••-9261(808) 780-0471UNKNOWN321 MOUNTAIN VIEW DRIVEAtlanta·GA30334—MEDICARE-ADV-B
CLMCLM-4003752026-03-17T11:36:09Zgloria—woods1998-09-16··UHC-12398-94——-——N/A·N/A—SELECT-EPO
CLMCLM-4240422026-01-13T16:35:43ZFox, Ruth——1997-01-01UHC-51091-44•••-••-5967454-246-6460—339 Baseline RdAustinTX··78765GRP-8765NULL
CLMCLM-4319502026-08-25T17:55:55ZMichael—Kim1981-08-12NULLUNKNOWN—NULL351 Union StAustinTexas78787GRP-3885NAVIGATE-HMO
CLMCLM-400383 2026-09-06T10:17:12Zethan—·burton07/06/62UHC-46365-98—(736) 537-2560null1411 DESERT SKY BLVDPhoenixAZ85065NULLMEDICARE-ADV-A
CLMCLM-4293092026-02-11T22:34:15ZJULIA—THOMAS1956-07-15—N/A3913238352—-··NULLN/AGRP-2264—
CLMCLM-4164212026-02-02T22:10:32ZJean—Ortega2000-07-25N/A•••-••-4670-—9182 INDIAN SCHOOL ROAD·DallasTX75246GRP-3323-
CLMCLM-4089032026-02-16T12:49:14Zmarcus—snyder1958-10-04-•••-••-0294N/Amarcus.snyder28@gmail.com7609 CENTRAL AVENUETampaFL33672GRP-7912—
CLMCLM-4163342026-01-15T12:35:34ZALBERT—PARRK02/02/74UHC-34842-61•••-••-0647NULL—UNKNOWN··NULLUNKNOWN—N/ANULL
CLMCLM-4095872026-07-19T20:23:45ZSANTIAGO—COLEJul 1, 1978UHC5842778•••-••-5974——6345 Valley View DrPhoenixAZ85045nullCHOICE-PLUS-PPO
CLMCLM-4237212026-10-04T10:40:28ZOmar—Sanchez22-08-2007UHC-70219-09UNKNOWN+1 318 230 3092null1184 Pine Drive #247AustinTX78797nullMEDICARE-ADV-B
CLMCLM-4073762026-03-11T17:21:55ZDiana—·Jacobs·11/10/08NULL—888.373.7288N/A5990 MOUNTAIN VIEW DRORLANDOFL32818——
CLM CLM-4285072026-06-27T11:14:25ZPAUL—ROSS··13-09-1983·UHC-15295-38—19544437643····3208 Lincoln WayPlanoTX75029GRP-7869-
CLMCLM-4252012026-07-31T05:05:31ZJEAN—GONZALES1941-09-26—•••-••-8132358-475-7496NULL6416 Canyon Rd Apt 9San AntonioTX78277GRP-1815—
CLMCLM-400667 2026-03-10T09:30:18ZBRANDON····CARLSON1988-11-07-N/A4738937394UNKNOWN4875 APACHE BLVDHoustonTX77012GRP-2285-
CLM CLM-4105832026-07-17T08:15:22ZCunningham, Terry——10/11/1966UHC7243657null661-842-1003TERRY.CUNNINGHAM47@HOTMAIL.COM1040 Baseline Road··AustinTX78784N/AMEDICARE-ADV-B
CLMCLM-400322 2026-01-25T00:11:07ZPeterCGarrett03/11/81UHC-70030-79N/A3327854244—8443 Oak StreetFresnoCA93783··GRP-7534UNKNOWN
CLMCLM-4262222026-02-08T05:33:49Z·WALTERFREYES13-04-1992UHC-60664-75•••-••-0035NULLwalter.reyes@outlook.com3935 Lake View RoadSEATTLEWA··98141GRP-5995NAVIGATE-HMO
CLMCLM-4102152026-07-03T07:51:11ZGARY—WEST·1940-04-16·-•••-••-5376—null5456 CEDAR LNEden PrairieMN··55398GRP-9733null
CLMCLM-4030602026-03-02T08:00:12ZHannah—Peterson1984-08-18UHC-35783-07··•••-••-3835779-710-8154—3908 Pine Drive··JacksonvilleFL32263N/ANULL
CLMCLM-4092702026-04-25T04:33:48ZSAM—HERNANDEZOct 22, 1980UHC-94074-24•••-••-28287997228805—6839 JEFFERSON AVEOrlandoFlorida32889GRP-3540—
CLMCLM-4250412026-08-16T20:00:17ZMei···Bailey1966-11-09UNKNOWNN/ANULL—-——N/AUNKNOWNSELECT-EPO
CLMCLM-4206282026-02-16T01:04:42ZStephanie····RssFeb 27, 1998—•••-••-4057—stephanie.ross@yahoo.com504 Sunset BlvdAustinTX78795GRP-6829—
CLMCLM-4035872026-03-21T23:48:21Z Bradley··—Wallace1970-04-28UHC-69793-41———null—NULL—GRP-2063-
CLMCLM-4167682026-01-31T03:10:44ZSAMUELHMONTGOMERY1946-10-24UHC-58307-57N/A-—1004 Pine DriveSacramentoCA95879·GRP-7777null
CLMCLM-4228172026-03-06T09:52:25Zcheryl··Cbarnes10/02/1966null··——6986 Mountain View Drive·TEMPE·Arizona85286—·NAVIGATE-HMO
CLMCLM-4189292026-08-22T11:08:14ZAUSTIN—SOTO1976-02-08UHC-72765-50-7207861210—4436 JEFFERSON AVENUEGilbertAZ85267GRP-2623OPTIONS-PPO
32,829 rows, page 91 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:37.764Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty