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-4069182026-01-29T06:16:26ZGerald—Davis13-07-1959UHC-68736-64—8239090null·7154 Pine DrTempeAZ85215null—
CLMCLM-4276882026-05-13T09:20:35ZJimmy—Lee27-03-1985UHC-47044-58—-NULLUNKNOWNUNKNOWNnull-··—null
CLMCLM-4310752026-07-02T13:31:22ZBRENDA—CARPENTER19930215N/ANULLN/A-7814 WILLOW COURTColumbusOhio43217GRP-4387medicare-adv-b
CLMCLM-4191542026-04-02T18:54:28Zterry—fernandez1985-03-27UHC-26247-59—4308706··—6649 Grand AvenueJacksonvilleFlorida32250GRP-7344OPTIONS-PPO
CLMCLM-4261472026-06-01T08:22:37ZDianaRMills19890206UHC-78735-87•••-••-2324960-574-2578diana.mills64@yahoo.com5029 UNION STREETLOS ANGELESca90053—-
CLMCLM-4096182026-02-07T03:38:38ZAlbert—Haies7/3/1944—null17195431617NULL7339 HILLCREST RDPLANOTX75091GRP-6652—
CLMCLM-4095752026-08-24T12:47:13ZHeatherTWelchApr 6, 1979—•••-••-4470208-201-9606—4656 Pine DriveFresnoCA93790N/A·UNKNOWN
CLMCLM-4192792026-08-31T19:29:59ZAustin, Cunningham——2005-12-11UHC-71262-56•••-••-4538·639-283-6784NULL4366 FOREST AVEPHOENIX··AZ85002GRP-8055CORE-HMO
CLMCLM-4321962026-06-03T08:58:43ZRalph—Robinson1952-12-05UHC-20956-92nullnullUNKNOWN5103 Willow CtEden PrairieMN55349GRP-0599CORE-HMO
CLMCLM-4315052026-07-21T11:35:00ZCHRISK.RICHARDS·12/12/1960-•••-••-3311845-452-8539UNKNOWN—UNKNOWNUNKNOWN—GRP-2541—
CLMCLM-4298842026-03-05T02:15:55ZGarrett, Ann——1938-12-18UHC6361533•••-••-3333nullUNKNOWN5563 Lincoln Way #379HoustonTexas·77073nullCORE-HMO
CLMCLM-4013762026-10-14T15:18:22ZSimpson, Nicoole——11-11-1969UHC-07493-84UNKNOWN-N/A802 Ridge RoadNashvilleTN37233GRP-8929NULL
CLMCLM-4218662026-10-18T11:25:51ZWong, NancyT—5/23/2006N/A•••-••-3192872.563.3120·-NULL—nullUNKNOWN·GRP-9306OPTIONS-PPO
CLMCLM-4058312026-05-22T13:09:30Zbarb—wallace9184-12-25UHC-80497-35•••-••-7028N/A—····—null—nullN/A
CLMCLM-420686 2026-04-19T21:51:28ZDEBRA—WARREN1972-08-21UHC-72923-64•••-••-7571—null3834 VALLEY VIEW DRSeattleWA98121·null—
CLMCLM-4188952026-07-08T02:16:18ZSophia—Turner01/18/47UHC-88478-15•••-••-2498—N/A4569 Harbor BoulevardColumbusOH·43266—CHOICE-PLUS-PPO
CLMCLM-4322872026-10-16T18:17:37ZDENISE—MILLS1982-03-24UNKNOWN··null-—1110 GRAND AVEATLANTA··GA30389—NULL··
CLMCLM-4286602026-01-11T20:43:56Zkevn—rojas1993-01-19UHC-91709-03UNKNOWNNULLkevin.rojas@outlook.com7298 OAK STTampaFL33674··GRP-2118OPTIONS-PPO
CLMCLM-4054932026-03-13T02:44:15Z Rachel—Wheeler1968-04-06uhc-03328-76•••-••-5356····NULL3159 River RoadChandlerAZUNKNOWN·GRP-6068·NULL
CLMCLM-4149812026-04-12T01:47:22Z·Priya B.—Rice1956-12-11UHC-92535-76N/A12084330337··9320 Bayshore DrChandlerAZ85250GRP-3056NAVIGATE-HMO··
CLMCLM-4114672026-07-09T19:35:57Z·Nicole—·Elliott1954-07-08UHC6081781—-——NULL··-N/A······
CLMCLM-4185482026-02-25T09:44:24ZRUSSELL—POWELL22-10-1939UHC-73379-98•••-••-5979N/ARUSSELL.POWELL93@OUTLOOK.COMnullnull—-—N/A
CLMCLM-405379 2026-07-10T19:44:24ZRonald··—Sims1983-08-21UHC-85514-63null——2231 Church StreetFresno·CA93729GRP-8355CORE-HMO
CLMCLM-4196742026-03-15T13:35:47ZnoahFmoore·1963-07-27UHC-12184-09•••-••-4948-—NULL-NULL—GRP-4932—
CLMCLM-4293232026-07-25T15:47:23ZJORDAN—ROBERTSON13-09-1979-··•••-••-0692—····1875 Ocean AveTempeAZ85216-4989GRP-3661OPTIONS-PPO
CLMCLM-4068552026-09-27T11:29:53ZNancy—Spencer09/06/08UHC-62462-17•••-••-98316803761098UNKNOWN6931 Ocean AveCharlotte··NC28255··UNKNOWN-
CLMCLM-4275122026-06-19T14:22:52ZKimberly—Gordon2006-12-28UHC-89560-95N/A+1 784 584 5260—1992 MOUNTAIN VIEW DRCharlotteNC28288-6913GRP-9801··-
CLMCLM-4281302026-05-29T03:15:40ZRuthM.Meyer2004-06-19UHC-88349-27··•••-••-0378—N/A8704 Central AveGlendaleAZ85341·GRP-3069MEDICARE-ADV-B
CLMCLM-4291092026-10-14T07:00:06ZTerry—YoungDec 26, 2003UHC-16318-17—UNKNOWN-116 Baseline RdHoustonTX77015-1921GRP-5918SELECT-EPO
CLMCLM-4254532026-09-17T10:51:42ZScott—Gibson06/02/04····—-UNKNOWN5853 Lake View Road··MiamiFL33153GRP-4659-
CLMCLM-4176582026-07-10T23:29:55ZCARLOS—MCCOY1981-10-23——N/A—5251 Main StreetTampaFL33640NULLnavigate-hmo
CLMCLM-4124192026-08-01T04:39:51ZGeorge—·Little1999-10-12·UHC-09315-33UNKNOWN(521) 984-5136NULLnullnullnullnullGRP-8965-
CLMCLM-4117522026-09-08T05:32:07ZEMILY—THOMPSON2/27/1964UHC-60492-22—858-356-0260N/A7291 Mesa Drive Apt 35CharlotteNC28216GRP-0562—
CLMCLM-4140562026-01-28T00:41:22ZChapman, Amanda—··1950-09-03·UHC-94916-77•••-••-1346766-787-5967amanda.chapman52@icloud.com6464 Maple Ave #624MiamiFL33137GRP-3738NULL
CLMCLM-4226532026-10-03T02:11:28ZLORI····LI16-05-2000UHC-86987-56•••-••-7122(213) 752-9288UNKNOWN··7785 Ocean AvenueSan Diegoca92124-8605NULL—
CLMCLM-4113682026-06-15T17:37:57ZJonathanEWheeler—····NULL9602096387—null——-GRP-4743OPTIONS-PPO
CLMCLM-4282792026-07-02T13:49:59Zemily—montgomery2004-03-03UHC-51886-82•••-••-6030977-955-3021··233 Oak StreetDENVERCO80292··-CHOICE-PLUS-PPO
CLMCLM-4014322026-06-25T23:14:41ZPierce, Sophia—····1973-09-23UHC0450142nullnullUNKNOWN6744 Desert Sky BoulevardGlendaleAZ85382GRP-2870SELECT-EPO
CLMCLM-4133942026-03-25T14:23:41Z·ELLIOTT—TYLER01/14/54UHC-10283-58•••-••-7835619-258-7292null6868 Hillcrest RoadPlanoTX··75038GRP-8548UNKNOWN
CLMCLM-4266502026-09-20T08:46:40ZIsabella—GeorgeDec 24, 1944UHC-40296-74·N/A—NULL—null··—UNKNOWNGRP-5671OPTIONS-PPO
CLMCLM-4108312026-04-05T11:00:01ZSteven·NGreen2007-05-26UHC-83463-90—+1 916 633 9086·steven.green80@icloud.com17 Oak StPLANOTX75011GRP-8644··
CLMCLM-4149362026-05-30T22:55:06ZTYLER··—GRAY2005-10-24null—-N/A3159 HARBOR BLVD #564GlendaleAZ-GRP-0578N/A
CLMCLM-4112762026-08-19T10:17:01Zfrank····lawrence·1979-09-09UHC-94025-69UNKNOWN—N/A8715 Grand AveAtlantaGA30364-2288GRP-5542MEDICARE-ADV-A
CLMCLM-4162892026-03-29T09:54:15ZPhilip—Brown10-03-2003UHC-75306-06•••-••-2337(671) 740-0471—429 Mesa DrJACKSONVILLEFL32286N/AN/A
CLMCLM-4307622026-08-12T03:51:22ZZacharyQ.Baker1952-04-10NULL———9465 Grand AvenueEden PrairieMN55345N/ANAVIGATE-HMO
CLM CLM-4091372026-01-31T20:29:33Zteresa—munoz10/02/1989UHC-84425-40•••-••-5442(806) 767-8348—3237 PALM DROrlandoFL··32890-7710GRP-4645CHOICE-PLUS-PPO
CLMCLM-4262782026-04-08T08:29:05Z·Valdez, Nancy——2002-06-24—•••-••-5109-null3019 PARK PLACETUCSONAZ85734null··SELECT-EPO
CLMCLM-429698 2026-01-29T10:47:47ZDouglas—Banks19830106UHC-51125-18—·NULLNULL1901 Mountain View DriveSacramentoCA95895GRP-2284null
CLMCLM-4007922026-03-13T21:46:39ZROY—FISHER1967-07-02UHC-91505-50•••-••-6868—-323 Baseline RdTAMPAFL33699-·CORE-HMO
CLMCLM-4185512026-03-12T19:38:07ZEric—Bailey··1989-07-10UHC-12608-31-6162170791—9184 Highland AveTAMPAFlorida33676—null
32,829 rows, page 61 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:36.715Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty