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-1346232026-06-03T17:47:08ZAnnaFMurray8/4/1999·UHC-80172-35•••-••-2701571.906.0986UNKNOWN7304 Highland AveATLANTAGeorgia30376GRP-8638MEDICARE-ADV-A
TPATPA-518592026-09-07T17:08:16ZFuller, Nick——08-02-1983UHC-17681-49•••-••-7616null—4462 Sage CtLAS VEGASNV89144GRP-8651-
CLMCLM-4086152026-09-20T04:24:28ZFRANCESZPENA1996-11-26UHC-11201-26•••-••-6947null·NULL———····GRP-9545CORE-HMO
CLMCLM-4144322026-01-13T18:58:48ZJustin—Snyder1941-02-25NULLN/AnullNULL6092 Ocean AvenueSCOTTSDALEAZ85205nullSELECT-EPO
CLMCLM-4133012026-03-07T08:07:36ZTeresa—Ford·08/17/2007UHC-20506-45•••-••-47378533456001··—9494 MARKET STREETGilbertAZ85259-—
CLMCLM-4143782026-03-10T15:44:01ZJASON—ORTEGA1941-09-03UHC-52395-15—794-364-8119—8529 Indian School RoadSeattleWA98166GRP-0222CORE-HMO
CLMCLM-4265162026-08-05T23:11:55Z John··—·Payne12/1/1947UHC-58602-12··N/A—4417 HILLCREST RDAtlantaGA30363—NULL
ENRENR-1247282026-01-12T13:08:06ZdonaldH.burton··1973-02-10UHC-51875-33•••-••-5247UNKNOWNdonald.burton@aol.com8911 Sunset Boulevard·Houston·tx77089GRP-1337SELECT-EPO
TPATPA-583382026-01-27T16:45:11Z·Evans—Joseph1997-07-02UNKNOWN•••-••-3863—JOSEPH.EVANS@YAHOO.COM··7198 OAK STTempeAZ85236GRP-4953NAVIGATE-HMO
ENR ENR-1209392026-09-22T16:10:55Z DENISEMCOX19771017UHC-00474-84•••-••-4113(944) 240-3137null5177 VALLEY VIEW DRIVELas VegasNV89165GRP-4069MEDICARE-ADV-A
ENRENR-1328342026-03-14T07:22:55ZLOGAND.DAVIS12/05/1975UHC-19058-33•••-••-07399412123448NULL5042 Main St·DallasTX··75236GRP-9985CORE-HMO
PRVPRV-251732026-04-21T11:09:14ZRACHEL—WEBB2001-04-13—··312-762-5131rachel.webb99@aol.com5298 MAPLE AVENUEAtlanta··GA30378····—
ENRENR-1376612026-08-15T19:57:05ZBettyUMendoza20080514UHC-11236-54•••-••-2254+1 868 740 8613N/A4088 Grand Avenue #517SacramentoCA95876GRP-1475NAVIGATE-HMO
TPA TPA-552902026-06-29T08:28:21Z·BRITTANY—DIAZ··19740308null—327-691-2675—4481 Ocean AveSan AntonioTexas78234GRP-0560NULL
CLMCLM-4299012026-03-14T12:53:16ZMark····Nelson1957-10-06N/ANULL—-3833 Desert Sky BoulevardLAS VEGASNVnullGRP-0669MEDICARE-ADV-B
PRVPRV-290502026-09-27T13:29:33ZMICHELLE··—·BOWMAN1971-10-24-null-—7317 OAK STREETTampaFL33639NULL··SELECT-EPO
TPATPA-606692026-08-16T01:40:35ZPETER—WELLS05/19/46—•••-••-9910NULL—2917 MESA DRMiamiFlorida33128-CORE-HMO
PRVPRV-224412026-05-31T16:12:47ZNathanI.Olson··1977-08-18UNKNOWN—8935064456nathan.olson@hotmail.com7553 Central AveHouston·TX77034-—
ENRENR-1133702026-03-23T09:39:03ZHoffman, PatrickJ.—Nov 21, 1960UHC-10829-67•••-••-5351(315) 352-8761patrick.hoffman@aol.com2406 Forest AvenueSAN DIEGOCA92106GRP-4261CORE-HMO··
PRVPRV-223302026-05-23T10:24:19ZJudith—Gardner1996-07-24UHC-21987-43UNKNOWN(743) 902-8198null9762 MAIN ST·PhoenixAZ85077NULL—
ENRENR-1393492026-09-28T11:55:55ZJULIAZNELSON11-06-1997UHC-55618-44•••-••-7296(814) 213-5020julia.nelson75@aol.com6787 Maple AvenueTucsonAZ85792··GRP-9185CHOICE-PLUS-PPO
CLMCLM-4101762026-03-27T16:16:53ZCHRISTINE—MORALES19-01-2007UHC1812175•••-••-6430(567) 467-7874NULL9879 Lincoln WayFRESNOCA93702··GRP-7144—
PRVPRV-262692026-07-24T12:58:07ZDIANA··LANE1990-09-25·UHC-80512-97null·18243077412NULL3391 Indian School Rd #279MesaAZ85265-1306NULLUNKNOWN
ENRENR-1318312026-04-27T12:57:35ZKeith—·FisherJun 18, 1963UHC-31886-13UNKNOWN743-911-3686keith.fisher72@outlook.comnull·nullUNKNOWNUNKNOWNGRP-8393navigate-hmo
ENRENR-1045872026-08-30T16:08:21ZBECKY—WEST1951-05-23UHC-32690-49····(271) 363-4673rebecca.west92@yahoo.com1859 MAPLE AVENUE·CharlotteNC28290GRP-2170CORE-HMO
TPATPA-554142026-08-07T12:54:35ZJNICE—COOK1946-04-28UNKNOWN·NULL·-UNKNOWN—NULLN/AN/AGRP-9179null
TPATPA-598162026-10-04T16:20:16ZLINDA—ROSSJun 14, 1969··—•••-••-0937—N/A9275 Ridge RdChandlerAZ85246····UNKNOWN
CLMCLM-4183682026-01-30T15:21:20ZBrandon—Graham1998-03-03UHC-81812-78•••-••-945912115434560-——UNKNOWNUNKNOWNGRP-0555SELECT-EPO
CLMCLM-4297572026-03-21T08:08:05ZMills—James10/16/1982UHC-21607-68NULL489-674-5749—9312 BroadwayLos AngelesCA90068-5576-N/A
ENRENR-1140492026-06-14T18:24:19ZDanielle—Parker1983-08-19UHC9214117•••-••-5838+1 784 689 9027danielle.parker@proton.me3347 Maple AveSan DiegoCA92176··GRP-6266OPTIONS-PPO
ENRENR-1151232026-08-16T05:35:46ZFrancesP.Meyer·1996-08-21UHC-29846-75•••-••-9249+1 517 773 0037frances.meyer@gmail.com4125 Apache BlvdTempeAZ85272GRP-0644MEDICARE-ADV-B
CLMCLM-4137932026-05-31T09:56:28Z·DENISEIORTEGA2005-09-20UHC-19461-15NULL·15596106358—7305 Maple AveSeattleWA98162GRP-2791OPTIONS-PPO
CLMCLM-4313682026-08-14T01:56:49ZMartinez, Cynthia——9/25/1996UHC7351661•••-••-3464N/AN/A7315 BroadwayGilbertAZ85227nullmedicare-adv-a
CLMCLM-4278792026-06-16T15:12:38ZJoyce—Nunez1991-01-18UHC-97504-31•••-••-4869NULL—·6894 Desert Sky Blvd #693SeattleWA—N/ANAVIGATE-HMO
TPATPA-539862026-10-11T02:36:16ZTruner, Jacqueline··E.—11/12/00UHC-69964-16N/ANULLNULL898 LINCOLN WAYAustinTX78789—··
CLMCLM-4046452026-05-22T16:47:18ZANGELA—CHAPMAN15-05-1938UHC-53091-93•••-••-1623——UNKNOWN—NULLNULLGRP-2060NAVIGATE-HMO··
CLMCLM-4143352026-06-24T13:19:06ZMariana—Parker2008-11-14UHC-18863-52•••-••-7913·8676421234null9046 CHURCH STREETGilbert··AZ85224-1881UNKNOWN—
CLMCLM-4250542026-10-05T15:24:01ZMARK··——1941-03-17——(445) 449-0533null6407 SPRING STREETJACKSONVILLEFL32232GRP-9934CORE-HMO
ENRENR-1027392026-04-03T13:46:51ZLINDALHARRIS19830320UHC-22013-65•••-••-2005·(975) 761-7358LINDA.HARRIS@HOTMAIL.COM5910 Mountain View DriveDenverCO80276GRP-4707CORE-HMO
ENRENR-1309172026-02-03T16:17:52ZAnthonyP.Median12-02-1995UHC-86103-32•••-••-8655+1 820 397 5478anthony.medina@hotmail.com7982 Park PlOrlandoFL32864-1787GRP-5334MEDICARE-ADV-A
TPATPA-632502026-03-01T18:21:00ZLi, Carolyn··—Jul 28, 1947N/A··—nullNULL6525 Highland AvenueNashvilleTN37205N/A··—
ENRENR-1207762026-04-07T10:37:04ZHiroshiLMcDonald07/08/1991UHC-32228-83UNKNOWN9036515984UNKNOWN8785 Harbor Boulevard·CharlotteNC28219GRP-7493SELECT-EPO
PRVPRV-269112026-03-14T04:59:08ZJACK J—SMITH07/24/50UHC-36697-29—956.682.4215jack.smith@icloud.com4569 SPRING STSan AntonioTX78247null··CORE-HMO
PRVPRV-240742026-10-06T15:05:15ZDAVIDI.HERNANDEZ6/28/1987UHC-79977-02UNKNOWN··3086821david.hernandez@aol.com8201 CAMELBACK RD·OrlandoFL··-UNKNOWNNAVIGATE-HMO
CLMCLM-4013382026-10-09T02:51:55ZLynda—Greene1979-07-12nullUNKNOWN—UNKNOWN··655 Central AvenueLas VegasNV89170NULLN/A
ENRENR-1092732026-01-02T18:33:49ZOmar—Oliver10/01/08UHC-32622-59•••-••-4537886-288-1687OMAR.OLIVER58@AOL.COM7149 Market StreetSAN DIEGOCA92147GRP-3984NAVIGATE-HMO··
ENRENR-1343762026-02-20T21:51:02ZWei—Jemes1987-05-16UHC-53568-22•••-••-8989(892) 808-0751WEI.JAMES@PROTON.ME7550 SAGE COURTOrlandoFL32822···GRP-6004CORE-HMO
ENRENR-1284412026-05-26T09:48:08ZMasonSGarrett2005-06-06UHC-88787-58•••-••-23818725199267mason.garrett@yahoo.com6530 BAYSHORE DRIVENashvilleTN37281GRP-2573OPTIONS-PPO
CLMCLM-4114652026-08-02T05:58:32ZANTHONY—GUERRERO1972-11-10UHC-93685-60•••-••-9390NULLUNKNOWN·6030 MAIN STAustinTX78733GRP-2909—
ENRENR-1071322026-07-23T18:42:12ZSophia—Nunez·05/12/1963UHC-17485-17•••-••-3293477.392.5452sophia.nunez@aol.com9531 Cedar Ln··AUSTINTexas··78766·GRP-1185MEDICARE-ADV-B
100,000 rows, page 2 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-19T19:54:25.413Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty