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

All sources, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
ENRENR-1126092026-07-28T08:20:14Z BradleyIBishop1993-11-05UHC-27079-25•••-••-9927659.825.2726null4050 Meadow Ln Apt 2NASHVILLEtn·37283GRP-1166CORE-HMO
ENRENR-1115102026-08-04T15:21:11ZRandyJ·Singh1966-11-13UHC-39792-54•••-••-5628968-653-7527randy.singh@yahoo.com3230 Highland AveColumbusoh·43267GRP-9180CHOICE-PLUS-PPO
ENRENR-1144422026-06-18T23:43:33Ztim—wang1971-12-13UHC-89745-16··•••-••-8393(751) 405-4227··timothy.wang52@outlook.com·1726 Spring StreetHoustonTX77002GRP-3925CHOICE-PLUS-PPO
CLMCLM-4193932026-05-18T06:49:24ZZACHARYITHOMPSON01/28/1994··UHC-57296-58-—NULL8390 Forest AveSeattleWA98195GRP-3527—
ENRENR-1111802026-02-15T19:27:37ZGREGORYKPIERCE1997-10-26UHC-32313-32—(678) 329-8421NULL508 Central AvenuePlanoTX75029··GRP-2808··CORE-HMO
ENRENR-1162882026-04-30T22:58:39ZAmanda—Powell02/20/1958UHC-15061-46•••-••-3012nullamanda.powell@proton.me5353 MEADOW LNTEMPEAZ85251GRP-4892MEDICARE-ADV-A
ENRENR-1127852026-10-09T01:16:49Zjacob—cooper1971-11-28UHC-27394-07•••-••-9159·2285773172JACOB.COOPER@AOL.COM9817 PINE DRChandler·AZ85257GRP-3206CHOICE-PLUS-PPO
ENRENR-1157792026-08-18T09:14:31ZchristineY··elliott··2001-08-27UHC7752255null6814136727··christine.elliott34@outlook.com··6246 Church StAustinTX78704GRP-5848MEDICARE-ADV-B
ENRENR-1335892026-09-17T04:12:23ZGrace—PetersonMar 7, 1988··UHC-49921-92•••-••-21992868713271N/A5104 Lincoln WayEden PrairieMN55389GRP-3222SELECT-EPO
ENRENR-1288102026-05-13T16:43:52ZGEORGEISCHULTZ20021111UHC-55554-57NULL2096549594george.schultz@yahoo.com7977 RIVER RDTucsonAZ85729-0616GRP-9470CHOICE-PLUS-PPO
PRVPRV-239032026-04-04T11:19:16ZTYLERX.DOMINGUEZNov 27, 1982UHC-61632-38-912-288-5514tyler.dominguez38@outlook.com7545 Canyon RdNashvilleTN37239NULLN/A
ENRENR-1050302026-02-20T16:44:12ZDominguez, Hiroshi——06/23/42UHC-02224-53•••-••-14238594602517-9789 CENTRAL AVENUE #962OrlandoFL32850GRP-3630OPTIONS-PPO
CLMCLM-4009622026-10-04T19:52:27ZJACK—PATERSON1984-09-04NULLN/A·UNKNOWNnull—UNKNOWNN/A··nullUNKNOWNSELECT-EPO
ENRENR-1070492026-05-26T15:06:34ZSCOTT—GARRETT1996-08-08UHC-99037-29•••-••-51615419113030SCOTT.GARRETT54@PROTON.MENULLN/AN/A—GRP-1305CORE-HMO
ENRENR-1272442026-08-23T21:25:41ZKathryn—Kelley1941-03-05UHC2395271•••-••-5855849.781.2510kathryn.kelley@proton.me5269 WASHINGTON STREETNashvilleTN37265GRP-1703MEDICARE-ADV-B
TPATPA-556422026-06-26T19:32:44ZTheresa—Campbell01/26/86—null(966) 966-8695UNKNOWN7253 OCEAN AVENUE #451SEATTLEWA98195GRP-3169UNKNOWN
ENRENR-1029392026-07-11T18:52:48ZJulieK.Fernandez1978-03-03UHC-84577-80-7861161null1216 DESERT SKY BOULEVARD·AtlantaGA30382GRP-3571CHOICE-PLUS-PPO
CLMCLM-4324012026-06-23T09:24:06ZALICEYMCDONALD23-09-1993UHC-21511-16—709-216-1458null4747 Elm StreetLos AngelesCA90057GRP-4837NULL
ENRENR-1068162026-03-01T21:59:18ZJOEY—KENNEDY1956-12-21UHC-38071-28•••-••-086213822690087joseph.kennedy81@aol.com2817 Harbor BlvdTucson·az85763GRP-3460OPTIONS-PPO
ENRENR-1048912026-02-21T18:34:34ZANN—MARTINEZ1961-02-02UHC-32428-31•••-••-1698774.380.8687ann.martinez55@yahoo.com·UNKNOWN—UNKNOWNNULLGRP-4075··MEDICARE-ADV-A
ENRENR-1066152026-03-17T20:27:35ZAMBERK.VARGAS1985-01-01UHC-53395-28•••-••-0664427.914.8014AMBER.VARGAS@ICLOUD.COM2261 Central Avenue·JacksonvilleFL—GRP-4990SELECT-EPO
TPATPA-595012026-04-04T11:42:54ZSARAG.HOWARDApr 9, 1967UHC-97726-24•••-••-0175-··—4495 UNION STSan AntonioTX78244—NULL
ENRENR-1153592026-02-01T05:57:15ZAlexanderLCruz·1960-08-28UHC-39381-75•••-••-0585588.912.1293ALEXANDER.CRUZ33@ICLOUD.COM2134 Union StreetTAMPAFL33639-9637GRP-2024CHOICE-PLUS-PPO
ENR ENR-1270012026-05-21T07:40:44ZDENYSECRAMOS·Dec 10, 1960UHC-80996-85•••-••-3774·5257937763denise.ramos@icloud.com899 Forest AveDenverCO80256GRP-6240NAVIGATE-HMO
ENRENR-1224702026-06-14T00:00:00ZJeanU.Johnson1950-06-28UHC-38568-98•••-••-02488164247453jean.johnson42@hotmail.com4611 CEDAR LANEJacksonvilleFL32260GRP-7363·CORE-HMO
ENRENR-1027952026-01-11T22:53:10Z·THERESACWEST1982-03-22UHC-07177-15•••-••-5971NULL·theresa.west99@outlook.com8304 Baseline RdSan DiegoCA92131GRP-3491SELECT-EPO··
CLMCLM-4000482026-08-07T14:45:58ZGarza, DorisF—1957-12-18N/A•••-••-4697——5194 Desert Sky BoulevardLOS ANGELESca90000GRP-8008CORE-HMO
ENRENR-1315032026-07-15T03:55:58ZMason, Santiago—··2007-05-19UHC-55720-62•••-••-3162956-251-4898·santiago.mason94@aol.com8400 Pine DrNashvilleTN37268GRP-0256MEDICARE-ADV-A
CLMCLM-4212502026-04-22T02:59:44ZSteven—Alvarez2007-02-25UHC-39225-34•••-••-0114UNKNOWNnullN/ANULLnullUNKNOWNNULL—
CLMCLM-4030582026-10-17T18:21:09ZWayne—Jones1975-01-24UHC-18856-20N/A(529) 997-5980wayne.jones2@icloud.com408 Canyon RoadJacksonvilleFL32204GRP-6885CHOICE-PLUS-PPO
ENRENR-1325202026-02-16T03:36:12Zjoyce—hunter1974-11-24UHC-92295-16—(706) 376-9908joyce.hunter@hotmail.com5559 Meadow Ln Apt 17FresnoCA93719GRP-1692CHOICE-PLUS-PPO
CLMCLM-4280642026-08-05T09:46:20ZTERESALSNYDER1995-03-08UHC-84031-93•••-••-3989341.690.0947null7579 Indian School RdHoustonTexas77042N/A—
PRVPRV-286362026-04-10T20:38:11ZMegan—Elliott03/18/99UHC-54964-91nullNULL···megan.elliott36@icloud.com2593 HARBOR BOULEVARDORLANDOFL·32822——
ENRENR-1268712026-02-26T12:25:23ZThomasTCarterDec 6, 1984UHC-18931-33•••-••-6827+1 656 427 3432thomas.carter30@icloud.com4427 Maple AvenueGlendaleAZ85304GRP-5519MEDICARE-ADV-A
CLMCLM-4195912026-08-27T03:33:27ZDouglasTLong··1951-05-02uhc-91066-27—505-811-5307N/A5253 Willow CourtAtlantaGA30312—CORE-HMO
ENRENR-1400732026-06-01T00:23:38Zjanice—carter·1956-03-13·uhc-63333-08•••-••-2670N/AN/AN/Anull--GRP-4169SELECT-EPO
ENRENR-1197142026-09-19T13:08:38ZRomero, Judith··B····12/01/65UHC-76613-51•••-••-8120645-939-9856JUDITH.ROMERO58@OUTLOOK.COM··1753 RIVER ROADAUSTINTX·78784-2384GRP-7727MEDICARE-ADV-B
ENRENR-1015182026-03-07T23:08:50ZjudyE.··ford1982-07-24UHC-04242-46•••-••-8681(952) 295-6028judy.ford33@hotmail.com3524 Market StreetTucsonAZ·85793GRP-8018OPTIONS-PPO
ENRENR-1271932026-09-03T19:52:04ZROGERM.··BROWN1966-10-11UHC-71329-29•••-••-69845413768006NULL·293 Indian School RdOrlandoFlorida··32804GRP-5981OPTIONS-PPO
ENRENR-1395742026-10-14T06:11:13Z NOAH—HARPER19470513UHC-38796-66—2128971264—N/AN/ANULLnullGRP-8350OPTIONS-PPO
CLMCLM-4084202026-03-06T17:06:31ZZachary—WeberJan 21, 1945UHC-61312-95N/A463-641-1510-1671 Elm StreetMiamiFlorida33142GRP-9617UNKNOWN
ENRENR-1138672026-09-02T12:01:45ZMARILYNI.PATTERSON1997-01-05UHC-43471-66•••-••-80345688744256nullN/A——UNKNOWNGRP-5805MEDICARE-ADV-A
TPATPA-618752026-01-11T03:16:26ZPhilip—Johnston1966-07-26——UNKNOWNN/A9556 River RoadTucsonAZ85789—-
CLMCLM-4298792026-04-11T15:02:38ZPena, Julie——14-12-1994UNKNOWN•••-••-8529—null9289 Ridge RoadAtlantaGeorgia30309-5023GRP-7301—
PRV PRV-248542026-04-10T14:10:26ZHiroshi—Hudson1986-01-26—•••-••-75827546783296hiroshi.hudson24@aol.com6665 Washington St·ORLANDOFL32842N/AMEDICARE-ADV-B
PRVPRV-217292026-02-11T05:33:53Zalexander—reed08/02/1960UHC-32257-08•••-••-7592(435) 273-1328··7671 Church StreetAustinTX78717null··—
CLMCLM-4001432026-02-13T20:35:41ZYoung, Katherine—··1985-06-08UHC-45033-96UNKNOWN—UNKNOWN-null—NULL··GRP-6874SELECT-EPO
CLMCLM-4205902026-06-23T21:00:13ZEmmaA.SandersAug 6, 1948UNKNOWN—12228543447UNKNOWN6865 Sage CtNASHVILLETennessee37297GRP-1150—
ENRENR-1393872026-09-17T23:07:10ZBillyD··Salazar1958-08-09UHC-53626-68•••-••-5631—UNKNOWN7942 LAKE VIEW RDAtlantaGA30316GRP-0116·OPTIONS-PPO
CLMCLM-4308962026-07-10T18:42:32Z VALENTINA—REID1965-04-06N/AUNKNOWNnull—4462 Lake View RoadPhoenixaz85029-0361GRP-8788—
100,000 rows, page 116 of 2,000PreviousNext

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.684Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty