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-4127972026-01-29T06:00:34ZAMANDA—AGUILAR14-07-1999UHC-57660-55——null·4164 BroadwayTampaFL—-null
CLMCLM-4115262026-01-02T03:25:12ZJOSE—BARNES07/16/1979UHC-53140-13•••-••-4836235.460.6618NULL7290 CEDAR LNAustinTX·78722—MEDICARE-ADV-B
CLMCLM-4289702026-01-11T13:00:26ZDOROTHY··HICKS··25-08-1946··UHC-74134-54—N/A—7841 RIVER ROADTucson··AZ85755—-
CLMCLM-4071022026-09-10T18:50:56ZGabriel—BennettSep 13, 1968nullNULLN/A—1698 Elm StSan AntonioTX78268GRP-4099··—
CLMCLM-4019682026-10-18T11:01:26ZMatthew—Carpenter··1955-06-10UHC-33751-82UNKNOWNN/A-·8003 CEDAR LNMinneapolisMN55458GRP-1420··CHOICE-PLUS-PPO
CLMCLM-4162242026-07-25T17:26:51ZMason, AmyD—1974-07-27UHC-63861-38NULLN/ANULL5602 Camelback RdLas VegasNevada89113—N/A
CLMCLM-4125412026-03-14T09:07:57ZDEBRA—POWELL··1945-02-07·uhc-90874-75•••-••-4365NULLdebra.powell13@aol.com4358 FOREST AVETAMPAFL33622UNKNOWNCORE-HMO
CLMCLM-4113272026-06-02T22:51:15ZMELISSAU··WOONG—UHC-05164-20—UNKNOWN—4112 Park PlaceLas VegasNV89145—N/A
CLMCLM-4278382026-09-01T10:16:56ZPatricia—Lawson1964-01-04··•••-••-6598(915) 526-6047UNKNOWN5663 Meadow Lane··CHARLOTTENC··28208——
CLMCLM-4280652026-10-15T15:32:04ZJason····HuntDec 8, 1963—null—N/AUNKNOWNNULL—nullGRP-1989OPTIONS-PPO
CLMCLM-4308472026-07-25T22:32:51ZMaateoL.GrantOct 22, 1969UHC-05095-06•••-••-9878UNKNOWN—·2240 HILLCREST RDFresnoCalifornia93736GRP-8215UNKNOWN
CLMCLM-4226362026-04-02T02:35:14ZJuan—Banks1967-11-12UHC-97584-08NULLNULLjuan.banks@icloud.com9425 Mesa DrFresnoCA93762GRP-6782CHOICE-PLUS-PPO
CLMCLM-4031732026-04-08T21:39:57ZOliver, Stephanie——19-02-1978—····831-559-1211null2679 Elm StJacksonvilleFL··GRP-9162UNKNOWN
CLMCLM-4149582026-06-09T05:47:02Zbilly—holmes12/26/1977null-—N/A·UNKNOWNUNKNOWN—N/A··GRP-8545UNKNOWN
CLMCLM-4158292026-06-02T18:16:35ZHeather··—·Jones1988-04-22UHC-15154-41•••-••-7543UNKNOWNUNKNOWN7379 BroadwayDallastx75291-8970··null—
CLM CLM-4204352026-05-11T22:51:33ZBrenda··Adaams··1953-06-22··UHC-68921-36null-··2980 WASHINGTON STCHARLOTTE··North Carolina28273GRP-4089MEDICARE-ADV-B
CLMCLM-4057332026-10-04T07:40:40ZBeverly····Hughes1988-06-28UHC-84048-28•••-••-1537—-3148 Cedar LnPlano··TX75003GRP-8923null
CLMCLM-4095332026-01-07T20:40:45Zsharno—morrison09/15/1990UHC-24318-58UNKNOWN··749.451.6232-2424 CEDAR LN Apt 26··SeattleWA98157····SELECT-EPO··
CLMCLM-4158282026-09-16T07:09:13Zwilliam—scott04/20/38UHC-86572-89•••-••-5496—-2049 River RoadDALLASTX75207-·UNKNOWN
CLM CLM-4165902026-07-10T16:17:40ZEvelyn··GBakar1953-06-08UHC-01180-54•••-••-4683N/AN/A2621 Union StreetColumbusOHNULLUNKNOWNCHOICE-PLUS-PPO
CLMCLM-4242442026-09-01T03:59:08ZJUDITHX.SNYDER1983-01-13null··—UNKNOWN—7887 Bayshore DrMesaAZ85282—null
CLMCLM-4319772026-04-01T03:39:22ZSAMUEL—RAY·10/1/1998UHC-71219-67•••-••-44633219583527samuel.ray85@outlook.com9124 Spring StCharlotteNC28299GRP-1035MEDICARE-ADV-A
CLMCLM-4203392026-01-15T09:50:40ZArjun··Woods2005-05-15··UHC-68559-43•••-••-66507995572816-——-nullGRP-6493OPTIONS-PPO
CLMCLM-4142782026-01-18T02:39:01ZZACHARY—WATKINS03/15/1962—•••-••-2958—N/A9266 Ridge RoadAtlantaGA30322GRP-9913MEDICARE-ADV-A
CLMCLM-4302312026-03-01T04:33:12ZNATALIE—JOHNSTONMar 3, 1963UHC-51311-29•••-••-4577427.855.6740NULL2698 Elm StAtlantaGA30306GRP-7216CHOICE-PLUS-PPO
CLMCLM-4194622026-06-03T10:52:51ZNathan—Day1974-08-11UHC-96207-66NULL9135715049UNKNOWNNULL-··UNKNOWN—N/Anull
CLMCLM-4090802026-09-19T11:26:47ZROBERTNTRAN1978-03-12UHC-15067-68•••-••-7900——-UNKNOWNnull—-null
CLMCLM-4211782026-01-02T10:34:27ZWillieK.Le··1709-19-96UHC-73240-85•••-••-2921(572) 518-4926———null····GRP-6191CHOICE-PLUS-PPO
CLMCLM-422854 2026-08-27T22:06:45ZBetty—Fox19670904UHC-83505-18•••-••-5512-UNKNOWN6071 Grand AvenueNashvilleTN37213-OPTIONS-PPO
CLMCLM-427011 2026-03-21T16:37:42ZJoe—Dean12/13/2006UHC-39253-08—589.841.2283null-NULL—-GRP-0792··CORE-HMO
CLMCLM-4108302026-05-10T04:00:22ZStevenNGreen2007-05-26UHC-83463-90UNKNOWN9166339086—N/ANULLnull··—GRP-8644MEDICARE-ADV-B
CLMCLM-405150 2026-09-26T14:33:52ZMARILYN··MUNOZ08-07-1944—··nullN/A··———··UNKNOWN·NULL
CLMCLM-4325792026-02-25T06:28:48ZZachary—Mitchell1987-08-27UHC-77378-20UNKNOWN··UNKNOWN—5449 Jefferson AvenueCharlottenc·28278nullnull
CLMCLM-4243192026-08-31T19:25:08Zisabella—carter1997-09-23·UHC-24455-27—nullNULL1199 Park Place·MESAAZ85206N/ACHOICE-PLUS-PPO
CLMCLM-4107872026-09-10T21:41:55ZMarilynGReyes·Mar 28, 1964UHC-39493-80———NULL-NULL—GRP-5783SELECT-EPO
CLMCLM-4017472026-04-09T05:50:29ZSAMATNHA—CONTRERAS1946-02-09uhc-40230-62N/A····N/A9591 BroadwayGlendaleAZ85316GRP-6198CHOICE-PLUS-PPO
CLMCLM-4078632026-07-08T01:23:47ZPETER—·MILLS2005-05-05·UHC-45739-09-231-707-1599N/A351 Central AvenueSacramentoCA·95881—OPTIONS-PPO
CLMCLM-4028442026-04-22T21:26:59Z·Chavez, WillL.—2002-04-28UHC-79231-34··—NULL-8109 VALLEY VIEW DRIVEMinneapolisMN55491UNKNOWNSELECT-EPO
CLMCLM-4207562026-03-13T06:34:59ZMaldonado, Jacob——26-07-1996UHC-78781-64•••-••-0354N/A—4546 Ridge Rd Apt 30San DiegoCA92121GRP-3576SELECT-EPO··
CLMCLM-4213932026-01-01T03:48:17ZMason—Miller12/23/1955UHC-52836-22null——825 MOUNTAIN VIEW DR··HoustonTexasUNKNOWNN/Anull··
CLMCLM-4043542026-06-17T08:19:10ZBRENDA—SINGH19-10-1998UHC-87927-23NULL436-890-1966null7889 Union StreetSeattleWA98138GRP-1775MEDICARE-ADV-A
CLMCLM-4261662026-01-27T02:40:05ZJeremy—Watkins19710123——7669443001JEREMY.WATKINS@OUTLOOK.COM9745 JEFFERSON AVESCOTTSDALEAZ85234null··-
CLMCLM-4064572026-07-28T04:21:27ZCatherine····Nguyen09/22/1998UHC-20991-26UNKNOWN(942) 379-9253—4832 Main St Apt 6·San AntonioTX78265GRP-5094UNKNOWN
CLMCLM-4052112026-01-06T19:38:55ZMARIA—GIBSON05/25/1985UHC-55479-43•••-••-3694NULL—8145 Washington StEDEN PRAIRIEMN55316—null
CLMCLM-4154102026-03-13T05:01:48ZHarold··—Vasquez18-04-2002UHC-05206-24··UNKNOWNN/A4231 LAKE VIEW ROADMesaAZ85252GRP-5495··
CLMCLM-4111912026-08-20T19:39:53ZBRANDON—BENNETT1950-02-23—•••-••-9878NULLNULL3332 BAYSHORE DRSacramentoCA95871GRP-6214null
CLMCLM-4110202026-01-14T22:42:33Z·Amanda—Allen··14-10-1938nullNULLN/Anull3402 Market StATLANTAGA30316-4121GRP-4213OPTIONS-PPO
CLMCLM-4287192026-08-11T12:03:49ZAlbert····Cruz1993-09-19UHC-86254-80-(266) 508-2073UNKNOWN1079 LAKE VIEW ROADGilbertAZ85238GRP-8289MEDICARE-ADV-A
CLMCLM-4239712026-03-31T06:47:53ZJennifer··Medina20000627··NULLNULL-1107 Valley View DriveEDEN PRAIRIEMN55325GRP-3613OPTIONS-PPO
CLMCLM-4185352026-09-14T10:29:07ZRUSSELL·····BOWN1940-17-27UHC-59359-98•••-••-2632UNKNOWNnull654 Forest AveOrlandoFL32804N/ACHOICE-PLUS-PPO
32,829 rows, page 10 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.421Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty