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
CLM CLM-4237042026-03-30T22:41:09Z doris—barnes03/13/1980uhc-22231-79•••-••-52935683394—··NULL—null·GRP-8082null
TPATPA-519862026-06-05T18:52:06ZDouglas—Gilbert10/23/1994—-N/ADOUGLAS.GILBERT@GMAIL.COM7249 MARKET STREETSan AntonioTX78216nullNULL
PRV PRV-205452026-06-20T11:58:32ZWAYNE—HOWELL1965-10-08UNKNOWN•••-••-6098·388-481-1126null9750 CENTRAL AVETempeAZ85230nullN/A
TPATPA-52796 2026-10-02T13:09:53ZBrcueR·Jacos4/21/1950N/A—2109894072bruce.jacobs@gmail.com6148 Sunset BlvdTUCSONAZ85723GRP-9840NAVIGATE-HMO
TPATPA-519962026-02-04T18:19:36ZArthur—Freeman1957-12-26·--·UNKNOWNUNKNOWN4412 Forest AvenueTucsonAZ··85789GRP-4238CHOICE-PLUS-PPO
ENRENR-1062062026-09-13T05:35:05ZMaryB.Austin··1955-10-10UHC-84483-96UNKNOWN785-530-1453mary.austin61@hotmail.com9469 CEDAR LANEMIAMIFL33186GRP-7679medicare-adv-b
CLMCLM-4238742026-01-02T05:51:27Zjennifer—vargas1989-11-03-•••-••-9425N/AUNKNOWN2753 RIVER RDPlanoTX·75058GRP-9763MEDICARE-ADV-A
ENRENR-1321842026-02-07T09:37:08ZJoyce—Tucker4/26/2000UHC-14237-21•••-••-5286518-529-7059-8892 Cedar LnChandler·AZ85295GRP-9166OPTIONS-PPO
CLMCLM-4129822026-09-03T10:26:27Zkatherine—dixon19890728—N/A15007103246N/A9088 UNION STSan DiegoCA—N/A··NULL
ENRENR-1203242026-05-20T06:45:23ZCarolLMarquez12/10/44UHC-26390-57•••-••-7426-carol.marquez@hotmail.com3174 BroadwayNashvilleTennessee37290GRP-9986MEDICARE-ADV-A
ENRENR-1009062026-03-04T17:43:34ZMelissaHEspinoza1953-11-24UNKNOWN•••-••-4592·(658) 306-5744MELISSA.ESPINOZA@ICLOUD.COM7482 MESA DRGlendaleAZ85307GRP-5643MEDICARE-ADV-A
CLMCLM-4201582026-08-06T13:42:35Z———05-11-1946··UHC-87019-89-—-3708 Apache BlvdScottsdaleAZ··-GRP-9068—
ENRENR-1282482026-02-22T20:58:57ZPatriciaJ.Ellis19761019UHC-19735-38•••-••-451212082832063—8285 Church StFresno·CA93756GRP-0522OPTIONS-PPO
ENRENR-1169432026-05-25T17:25:48ZCAROLYN—GORDON1949-05-06UHC-94966-87•••-••-4423358-708-0043carolyn.gordon15@aol.com7485 RIDGE ROADPlanoTX75071GRP-5791OPTIONS-PPO
TPATPA-619552026-09-24T22:08:56Zbrittany—watson1971-04-25UHC-75844-21null3348380907··—3073 MARKET STSACRAMENTOca95874GRP-3967N/A
CLMCLM-4135992026-07-25T16:06:42ZCarr, Steven——0142-19-67UHC-95393-63-—NULL3232 Willow CourtHoustonTX·77057—OPTIONS-PPO
TPATPA-548242026-05-15T03:00:38ZJOSHUA—BROWN1974-08-18—·nullnullJOSHUA.BROWN@PROTON.ME·6299 Meadow Lane Apt 27GlendaleAZ85311nullSELECT-EPO
CLMCLM-4167132026-04-28T05:13:04ZElijah—Torres19680321—UNKNOWN9883370211N/A··7315 CHURCH STREETEden PrairieMN55333-NAVIGATE-HMO
ENRENR-1095392026-02-02T15:48:58ZWard, Jacqueline——10/19/2005UHC-85118-85•••-••-6452(409) 750-3030jacqueline.ward88@outlook.com523 LAKE VIEW RDTucsonAZ—GRP-8658··MEDICARE-ADV-B
CLMCLM-401075 2026-09-02T19:12:33ZJANET—SANCHEZ2007-08-22UHC-19523-28··—····N/AN/ANULLUNKNOWN———
PRVPRV-222072026-01-16T21:51:21ZChristian—Reynolds9169-04-15·UHC-02582-56•••-••-3964533-254-2224CHRISTIAN.REYNOLDS@YAHOO.COM—nullnull······nullnull
ENRENR-1202982026-03-08T01:51:25ZCarolyn—Jordan10/12/1952UHC-84537-40•••-••-0666·9293703365CAROLYN.JORDAN@ICLOUD.COM3878 Market St··Charlotte··NC28245GRP-0495MEDICARE-ADV-B
PRVPRV-231712026-02-22T22:02:48ZBryan—Reinolds··1958-08-23UHC-54408-06UNKNOWN2845697411bryan.reynolds@icloud.com1616 Desert Sky BoulevardGlendaleAZ85376nullUNKNOWN
ENRENR-1047262026-10-05T22:42:06ZbttyS.gutierrez··Jan 26, 1976··UHC-29030-63•••-••-6308(704) 505-0150··betty.gutierrez88@aol.com6971 Union StPLANOTexas75024GRP-3072SELECT-EPO
CLMCLM-4093422026-10-09T01:51:24ZFatima··—Coleman1981-12-02UHC-25318-23UNKNOWN-—·4474 Sunset BoulevardLos AngelesCA90061-7557GRP-6649N/A
ENRENR-1201242026-06-03T23:46:16ZCARLOST.RICHARDSON1994-06-02UHC-86386-38•••-••-8287666-548-1098carlos.richardson31@icloud.com9280 Forest AveMinneapolis·MN55458GRP-9451MEDICARE-ADV-B
TPATPA-561892026-09-19T19:15:44ZFatima—Boyd1985-07-28—NULL17457946116null7311 SAGE COURT··FresnoCA93791····-
ENRENR-1160302026-01-11T05:06:02ZMARIA—MATTHEWS1967-12-24UHC-24311-20•••-••-74659173203898maria.matthews46@icloud.com380 OAK STMinneapolisMN55459-3743GRP-7094SELECT-EPO
ENRENR-1093012026-10-05T12:00:56ZGARY—OLIVER1974-01-06UHC-43278-86•••-••-7287(573) 970-4226NULL2024 Cedar LaneSacramentoca95808-5975GRP-7363CHOICE-PLUS-PPO
ENR ENR-1032722026-02-06T22:48:24ZmichelleL.·mendoza2/22/2002··UHC-94441-58··UNKNOWN5882485922··—3551 Ridge RdSacramentoCA95817GRP-1415SELECT-EPO
ENR ENR-1037682026-06-23T18:34:23ZZachary··A·Wheeler1991-01-13UHC-43929-28•••-••-4542+1 299 318 5230zachary.wheeler20@aol.com3086 Sage CourtMesaArizona85243GRP-3528MEDICARE-ADV-A
CLMCLM-4222322026-03-10T11:11:43ZHiroshi—Schultz1978-07-23null•••-••-17359873904263—2330 Palm DrPhoenixAZ85079GRP-0570NULL··
ENRENR-1249792026-03-24T07:28:09ZPowell, SamuelF.····1952-04-19UHC-90652-31•••-••-1780(326) 334-8253SAMUEL.POWELL@PROTON.ME7828 Willow Ct·SCOTTSDALEAZ—·GRP-4852OPTIONS-PPO
ENRENR-1230122026-03-17T22:22:13ZPATRICIAR.—08/25/92UHC-68939-94•••-••-3082908.976.1394patricia.sandoval77@gmail.com5270 Highland AvenueChandlerAZ85227GRP-5647MEDICARE-ADV-A
ENRENR-1038872026-07-28T23:22:39ZSaraO.YangMay 7, 1990UHC-30052-60•••-••-69776386788933SARA.YANG@PROTON.ME2605 PARK PL··ATLANTAGA30351GRP-8430CORE-HMO
TPATPA-601472026-05-01T20:39:11ZKAREN—GREEN1953-06-27—•••-••-3796·16726132324NULL1578 Camelback RdDallasTX75298GRP-6062SELECT-EPO
PRVPRV-221052026-02-15T16:57:55ZABIGAILR.JENKINS1943-02-14UHC-10662-01··NULL(971) 297-0797—2333 CENTRAL AVETempeAZ85295NULLN/A
ENRENR-1000992026-07-17T18:53:15ZAARONWWEBBOct 7, 2008UHC-75621-63··•••-••-83484588466333·UNKNOWN6397 GRAND AVENUETempeAZ·85260GRP-8847CORE-HMO
ENRENR-1407672026-03-25T09:29:33ZPHILIP—RUSSELL2000-05-17UHC-68991-80•••-••-9967(581) 373-2144UNKNOWN1105 Maple AvenueTAMPAFL33676GRP-5365NAVIGATE-HMO
PRVPRV-256762026-09-22T22:00:14Zmateo—cooper1999-09-15UHC-44800-44null766-682-9596null—UNKNOWNN/AN/A—-
ENRENR-1068422026-05-18T11:40:09Zjanice··jenkins05-05-1966UHC-48581-90•••-••-9299775-733-8773janice.jenkins@proton.me8757 Highland AveScottsdaleAZ85226GRP-7354CHOICE-PLUS-PPO
ENRENR-1324052026-05-27T07:41:26ZCHARLESW.REEID1969-06-14··UHC-11944-53•••-••-73303702182011charles.reid@proton.me3202 Lincoln WayTEMPEAZ85211-8426GRP-1066··OPTIONS-PPO
ENRENR-1399352026-05-01T17:38:22ZValentinaTGuerrero1977-09-18UHC-71193-02N/A(568) 666-8856valentina.guerrero@icloud.com7765 Grand Avenue #115ColumbusOH43232GRP-1522·OPTIONS-PPO
ENRENR-1186932026-07-16T15:53:59ZJuan··Gutierrez1975-02-27UHC-97030-07•••-••-7176709.913.4689juan.gutierrez68@outlook.com4751 Washington StreetLas VegasNevada89139GRP-5447MEDICARE-ADV-B
ENRENR-1375082026-08-25T00:39:35ZLauraZJacobs3/21/1986UHC-87411-82•••-••-4240791-922-6255LAURA.JACOBS19@OUTLOOK.COM··2503 Lincoln WayAtlantaGA30384GRP-5449MEDICARE-ADV-B
TPATPA-532972026-01-10T17:59:00ZJEFFREY—JENSEN8/17/1965UNKNOWNN/A—jeffrey.jensen85@aol.com·6869 Willow CtTempeAZ85287····NAVIGATE-HMO
ENRENR-1398212026-05-11T09:00:48ZAnn—Williamson1963-02-12UHC-79164-18•••-••-59385907757710ann.williamson@outlook.com567 Meadow LaneAtlantaGeorgia30322-4503GRP-9039MEDICARE-ADV-B··
CLMCLM-4034812026-06-29T06:43:18ZHIROSHI—·WOOD1960-10-20—•••-••-3802N/A—8320 RIVER ROADEden PrairieMNnullGRP-5947OPTIONS-PPO··
ENRENR-1307002026-02-14T17:24:20Z JEANOHOLES··1977-09-23··UHC-90160-52•••-••-6418(808) 572-8724JEAN.HOLMES42@PROTON.ME··-NULL··UNKNOWNGRP-8680CHOICE-PLUS-PPO
CLMCLM-4095322026-06-05T17:25:49ZNency—Salazar19810305UHC-90313-65•••-••-06148346663805—4822 Sunset Boulevard #686··ColumbusOH43220GRP-6388CHOICE-PLUS-PPO
100,000 rows, page 195 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.720Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty