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-412467 2026-05-08T15:02:32Z·alexis—watkins·08-10-1946—··6234631535UNKNOWN3596 Elm Street Apt 29OrlandoFL32861—CORE-HMO
CLMCLM-4287122026-06-18T02:11:10ZJERRY—GUERREROJan 23, 1976UHC-49960-30•••-••-2561789-460-3497—9063 PALM DR·SeattleWA98115GRP-5868UNKNOWN
CLMCLM-4253782026-07-20T04:14:26ZTUCKER—PHILIP02/21/1982··N/AN/A·17326363269—9361 Jefferson AvenueOrlandoFlorida·32873GRP-3717··—
CLMCLM-4211862026-04-26T13:21:04ZDONALD—MORRISON19-05-1991··UHC-76798-71UNKNOWN458-611-9045—632 CENTRAL AVEScottsdaleAZ85229nullSELECT-EPO
CLMCLM-4173762026-09-19T21:57:57Z·Andy····Ross2003-02-09UHC-96333-70UNKNOWNUNKNOWNN/A8067 Meadow LaneSeattleWA98192GRP-6029UNKNOWN
CLMCLM-4019182026-05-28T22:27:05Zmary—masonAug 6, 1994UHC8523294nullN/ANULL9474 LAKE VIEW ROADAustin··tx78733GRP-9804OPTIONS-PPO
CLMCLM-4087512026-06-09T14:36:01ZPatricai··Gomez1940-10-24UHC-71807-52•••-••-665212928418674-nullUNKNOWN——UNKNOWN—
CLMCLM-4233932026-01-31T22:11:49ZEricGBowman19720914UHC-39720-70•••-••-6459(238) 612-5890······6475 PINE DR·Orlandofl32845GRP-8290MEDICARE-ADV-B
CLMCLM-4051002026-09-23T09:02:07ZDiane—Knight19421118UHC-54183-65nullN/AN/A2976 Market StTucsonAZ85760GRP-0103MEDICARE-ADV-A
CLMCLM-4200102026-06-01T04:31:10ZEdwardW.Elliott1979-05-08UHC-33180-88UNKNOWN-NULL·2976 PARK PLACETempeAZ85230UNKNOWNCHOICE-PLUS-PPO
CLMCLM-4173032026-08-25T00:45:12ZBurns, Theresa——1961-08-13UHC-49456-91NULL8677651239N/A6374 River RoadMiami·Florida33146nullN/A
CLMCLM-4206792026-07-22T07:45:18ZDebbie—Davis·07/11/53N/A•••-••-5053(596) 386-2981-9882 Valley View DriveAustinTX78745GRP-3861MEDICARE-ADV-B
CLMCLM-4306532026-07-27T11:01:47ZSANDRA—MCCOY1999-11-15UHC-43501-97•••-••-4873268-818-3877null··—UNKNOWNN/A-··GRP-1237OPTIONS-PPO
CLMCLM-4120332026-07-22T13:30:01Z·Wong, SamuelL—10/12/05N/A•••-••-8384—NULL9102 FOREST AVENUEHoustonTX77062N/A-
CLMCLM-4323252026-09-08T06:24:26ZRuth—Allen19881207-•••-••-85387785510561NULL4663 Oak StHoustonTX77017GRP-7968—
CLMCLM-4192972026-04-10T22:48:24ZIsabella—Walsh1979-06-04····—NULL—NULL—-nullGRP-8847MEDICARE-ADV-B
CLMCLM-4207512026-06-19T12:34:34ZCehryl—Owens1976-10-12—NULL··14679141075cheryl.owens24@gmail.com——nullNULL·GRP-6373UNKNOWN··
CLMCLM-4078112026-04-08T01:23:11ZKeithZAlvarez2001-08-18UHC-14541-33-6609361558—6453 Indian School Rd··CHARLOTTENC28299GRP-8883—
CLMCLM-4013422026-08-02T04:38:06ZZachary—Rodriguez1941-10-09UHC-03456-11•••-••-34656490451UNKNOWN7339 Jefferson AveLos AngelesCA90091—CHOICE-PLUS-PPO
CLMCLM-4307782026-04-14T18:18:36ZKATHERINE··WHEELER1982-06-17NULL—nullkatherine.wheeler73@outlook.com5094 Maple AvenueLas VegasNV89196GRP-0210·SELECT-EPO
CLMCLM-4315772026-03-26T01:23:23ZNatalie—Ryan··06/05/04UHC-86274-64•••-••-3485309.552.2514·NULL9790 Washington StreetMinneapolisMinnesota55421NULL-
CLMCLM-4235232026-03-20T13:54:09Z AHMED—CASTRO12/17/1993null—7727389026null9824 OAK STREETMinneapolis··MN55444GRP-8639—
CLMCLM-4159102026-02-02T16:13:33ZJanice—Owens1594-05-25null··UNKNOWN——1736 HARBOR BOULEVARDJacksonvilleFLN/A—UNKNOWN
CLM CLM-4240812026-07-10T12:59:08Z Aaron—Holmes1996-05-19-N/AN/A—8374 Palm DriveGlendaleAZ85352GRP-1542medicare-adv-a
CLMCLM-4263542026-03-16T15:14:12ZMariaPHawkins1984-05-24UHC-51163-84···NULL—maria.hawkins@aol.com4711 Desert Sky Boulevard·AustinTX··78783GRP-9526NULL
CLMCLM-4055352026-07-18T23:10:52ZCAMILA—MEYER1971-08-08UHC-63608-27N/AN/AnullN/A———N/ACHOICE-PLUS-PPO
CLMCLM-4077672026-07-06T06:20:47ZJAMES—WONG19930623UHC-53109-44NULL977-301-9909—1693 Sunset Blvd·GilbertAZ85223GRP-3837CORE-HMO
CLMCLM-4254612026-04-08T02:15:37Z·Willie····Sulllivan2005-02-28UHC-03086-90•••-••-7780NULL—5956 CENTRAL AVELas VegasnvnullGRP-8629·NULL
CLMCLM-4299992026-02-23T06:59:10ZDANIELU.RUSSSELL··1955-08-06—-—·-6057 Apache Boulevard·SacramentoCA95842N/ANULL
CLMCLM-4181372026-02-14T13:20:46Z·valentina—boyd1962-12-01UHC-23158-01——N/A3476 Central AveTempeAZ85246GRP-4349-
CLMCLM-4295772026-09-28T06:19:37ZLauren—PiarceFeb 4, 1975··UHC-58226-07—447-761-5739—N/ANULL—NULLN/A—
CLMCLM-4064862026-06-28T23:51:31ZRALPH—SCHULTZ19800817UNKNOWN-·null-8278 Elm StMiamiFL··—GRP-2844null
CLMCLM-4173792026-06-26T19:29:51ZGerald—Jordan1950-10-14UHC-54565-76•••-••-4594—GERALD.JORDAN19@GMAIL.COM4097 Apache BoulevardSacramentoCA95826——
CLMCLM-4209562026-06-03T09:52:55ZBrian—Harrison1977-10-22-N/A595-824-2725-713 Oak StreetChandlerAZ85222GRP-8632N/A
CLMCLM-4197552026-10-11T22:46:58ZWilliamB.·Garcia1/11/1954UHC-02353-22——UNKNOWN4474 Highland AvenueSan AntonioTX78234GRP-3672MEDICARE-ADV-A
CLMCLM-4316772026-01-25T19:37:11ZCHRISTOPHERQ.WILLIS1951-30-21·UHC-10720-18-—-·269 Indian School RoadJacksonvilleFLN/ANULLCORE-HMO
CLMCLM-4147882026-04-15T09:24:44ZMegan—Morrson1981-12-16UHC-40939-67•••-••-7738——5736 Cedar LnTampaFL33645nullCHOICE-PLUS-PPO
CLMCLM-4266872026-05-24T07:05:06ZFrancesBRoss12/11/87—•••-••-8404nullfrances.ross21@icloud.com379 WASHINGTON STLas VegasNV89188nullNULL
CLMCLM-4151072026-06-11T11:20:54Z·EmmaRWhite1975-07-18—•••-••-9977(573) 232-2798—8102 SAGE CTNashvilleTN37263GRP-3934OPTIONS-PPO
CLMCLM-4264122026-03-20T18:15:22ZRachel—Kenneedy1975-07-09UHC-76272-44•••-••-6888N/AUNKNOWN8703 Park PlacePhoenixAZ85029··—CORE-HMO
CLMCLM-423788 2026-01-23T02:57:49ZMIKE··—MATTHEWS1998-09-14UHC-27533-36·null(393) 293-2161NULL·9134 Grand AvenueGLENDALE··AZ85374nullN/A
CLMCLM-4093592026-08-15T22:26:37ZSusan—Scott1971-09-12—N/A7159685927UNKNOWN6472 Main StSan DiegoCA-NULL—
CLMCLM-4256392026-07-18T08:15:33ZHEATHER—MEYER1980-55-19UHC-17486-97•••-••-8751—heather.meyer@proton.me9200 HARBOR BOULEVARDCharlotteNC28252nullNULL
CLMCLM-4192882026-06-09T14:56:05ZMADISON··—KNIGHT1984-02-05UHC-85507-79··NULLnullUNKNOWN·8677 Baseline Road Apt 18AtlantaGA30319-0712GRP-6935NULL
CLMCLM-4189862026-05-02T10:00:17ZAHMED—SANDERSUNKNOWNUHC-07701-06N/A4209977132—2821 Sunset BlvdSacramentoCA95877GRP-0541OPTIONS-PPO
CLMCLM-4071262026-06-30T18:46:28ZValentina—Wheeler1944-03-26N/A•••-••-9595UNKNOWNUNKNOWN7039 BroadwayAtlantaGAUNKNOWNNULLSELECT-EPO
CLMCLM-4126522026-01-28T02:05:37ZevelynIstewart3/4/1997UHC-37643-23UNKNOWN4851253··—8320 UNION STREETAtlantaGA30332·N/A·NULL
CLMCLM-4282262026-08-12T21:31:38ZJOAN—VAZQUEZ1958-10-06——395-964-8074-2813 Valley View DrChandlerAZ·85283GRP-0351N/A
CLMCLM-4273832026-04-08T10:07:09ZLori—Armstrong1939-08-17uhc-85173-78—NULL-N/Anull—UNKNOWNGRP-8696OPTIONS-PPO
CLMCLM-4174522026-06-05T17:56:15ZRachel—Webb2001-04-13UNKNOWN•••-••-1857312-762-5131—5298 Maple AvenueAtlantaGA30378··GRP-2919··NULL
32,829 rows, page 5 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-19T19:54:25.416Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty