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
ENR ENR-1107822026-10-03T23:32:50ZamyRthompson2002-07-04UHC-07707-05··—amy.thompson13@proton.me·1010 Apache BoulevardDALLASTX75241GRP-6896MEDICARE-ADV-A
CLMCLM-4301222026-05-20T23:27:15ZNoah—·Bowman1996-00-91NULLUNKNOWN—noah.bowman@icloud.com-——NULLGRP-3204NULL
CLMCLM-4104452026-03-16T09:36:43ZBurton, Kathy——15-07-1947UHC-48446-12nullN/A—3808 Harbor BlvdScottsdaleAZ85292GRP-4147—
CLMCLM-4003972026-05-04T23:44:35ZDouglas—Reyes1968-09-09——nulldouglas.reyes15@hotmail.com7814 CENTRAL AVESCOTTSDALEAZ85284NULLNULL
CLMCLM-4217502026-04-27T12:55:40ZLori—Soto26-09-1956UHC-93373-56UNKNOWN··-—9248 HARBOR BLVDTampaFL33669GRP-6674-
PRVPRV-242742026-01-18T11:41:45Z·Mason—Weaver08/27/46UNKNOWN•••-••-16523287084598·mason.weaver31@proton.me248 Palm DriveFRESNOCA93706—MEDICARE-ADV-A
CLMCLM-4310072026-06-10T20:04:57Z DouglasI.·Smith1939-02-21UHC-05345-58··—NULL6704 Valley View DriveSeattleWA98166GRP-6328null
ENRENR-1323452026-02-22T06:03:05ZLriW.Marshall1995-10-20UHC-14620-73•••-••-43654537437511lori.marshall@gmail.com3879 PARK PLACEATLANTA··GA30399GRP-5939MEDICARE-ADV-A
ENRENR-1391632026-10-17T00:31:36ZBeverly—Jackson1998-09-09NULLN/A···4599324131BEVERLY.JACKSON@HOTMAIL.COM4804 Main StreetCharlotteNorth Carolina··UNKNOWNGRP-0922OPTIONS-PPO
ENRENR-1384722026-06-11T07:09:56ZJose—Day2004-10-04UHC6567801—4162887—3940 Desert Sky BoulevardPlanoTX··75035GRP-9817NAVIGATE-HMO
TPATPA-594882026-08-18T20:12:40ZDIANA—VAZQUEZ1993-07-23—UNKNOWNN/Adiana.vazquez@proton.me5173 RIVER RDJacksonvilleFL32292GRP-1046—
ENRENR-1336902026-04-04T03:33:52ZWashington, Danielle——2001-10-06UHC4111313—·3923151900—8837 Harbor BlvdLOS ANGELESCA90065··GRP-6013OPTIONS-PPO
CLMCLM-4204272026-01-17T14:42:32ZThomas—Carter1984-12-06-•••-••-6827N/AUNKNOWN4427 Maple AvenueGlendaleAZ··85304GRP-5519-··
CLMCLM-4270512026-05-31T04:06:57Zisabella—singh··14-11-1949null•••-••-2505·916-250-9220N/A8764 Baseline Road·COLUMBUSOH43296GRP-3794null
ENRENR-1174892026-01-10T00:18:41ZJames·ZPowell1994-05-14UHC-76763-51•••-••-4880·556.245.9713—127 Main StSEATTLEWA98131GRP-1766SELECT-EPO
CLMCLM-4267132026-09-17T08:02:38ZTreesaD.Cunningham03/02/1974··UHC-56407-99—·(589) 716-5184teresa.cunningham@gmail.com981 Willow Ct··SAN DIEGO··CA92163NULLSELECT-EPO
ENRENR-1135332026-06-23T19:44:57ZDanielDAlvarez1943-05-25UHC-57632-09•••-••-8435UNKNOWN—6848 Grand Avenue·Austin·TX78790GRP-8954CORE-HMO
CLMCLM-4231092026-07-29T15:28:24ZEmily—Little1996-04-14UHC-12266-19•••-••-0998(737) 540-3603——-NULL—GRP-2595—
ENRENR-1023322026-02-25T05:06:14ZRussell—WatkinsAug 22, 1990UHC-79036-19•••-••-4554664-618-4895russell.watkins@aol.com8736 BAYSHORE DRIVELas Vegas··NV89104GRP-7160MEDICARE-ADV-B
ENRENR-1043952026-09-12T05:40:54Z·Green, Debra——20031126UHC-24356-58•••-••-4531—null4701 Washington StChandlerAZ85205GRP-6360·MEDICARE-ADV-A
CLMCLM-4189822026-01-26T11:47:24Zgary—jordan1977-03-09—····(216) 331-1280·NULLN/A—··N/ANULLCHOICE-PLUS-PPO
ENRENR-1106832026-07-04T19:22:55ZHarvey, Zachary——08/10/2004UHC-58981-28•••-••-7000842-610-7239zachary.harvey31@yahoo.com8928 APACHE BOULEVARDTEMPEAZ85239GRP-8584CHOICE-PLUS-PPO··
TPATPA-545442026-04-28T03:45:14Z Lisa—Daniels1948-04-20··nullN/A—420 LINCOLN WAYDallasTX··75216·GRP-4260-
ENRENR-1307152026-05-09T07:17:02ZSilva, OmarE.—1962-06-26UHC-10513-43•••-••-4272·3564993674omar.silva@gmail.com4924 Mountain View DrSeattleWA98179GRP-2070MEDICARE-ADV-B
ENRENR-1302402026-04-05T12:44:57ZARJUN··LUCAS02/04/78···UHC-66384-38•••-••-9321664-352-4113UNKNOWN5563 HILLCREST RDHoustonTXN/AGRP-1589CHOICE-PLUS-PPO
ENRENR-1308522026-06-12T17:05:15Zjessica—elliott20050704UHC-51147-59•••-••-2699798-982-4634jessica.elliott@gmail.com2452 Maple AveTempeAZ85284·GRP-4217NAVIGATE-HMO
TPATPA-640652026-06-06T20:49:40ZWhite, Lisa——1939-07-16N/A···nullUNKNOWN··6103 Hillcrest RoadTucsonAZ85768-2955-—
TPATPA-636332026-05-08T11:05:47ZKatherine—Gonzalez1958-10-26—•••-••-0768nullN/A3627 Highland AveTampaFL33637-NAVIGATE-HMO
TPATPA-616082026-09-11T18:09:03ZCAMILA—·CHEN1977-01-12··UNKNOWN-(416) 684-0302····130 Harbor BlvdGlendaleAZ85327NULL··-
CLMCLM-4293372026-03-18T05:48:33Zlaura—berry18-02-1961UHC-60478-77•••-••-93937924332083··-5033 MAIN STMiamiFL33184N/A··CORE-HMO
ENRENR-1422062026-10-01T14:01:50ZELIZABETHP.OWENS··1949-09-17-•••-••-6419(854) 871-1123null·163 Oak StreetHoustonTX··77026GRP-8882OPTIONS-PPO
ENRENR-1032712026-01-19T16:18:56ZMaldonado, BruceW—4/15/1975UHC-52868-26•••-••-96135343997606bruce.maldonado82@icloud.com9375 Union StTucsonAZ85738··GRP-5113navigate-hmo
CLMCLM-4072272026-07-27T10:51:09ZVincent··—Lee01/01/79UHC-40504-25—689-774-5966—4326 Sunset BoulevardHoustonTexas77068··N/ACORE-HMO
PRV PRV-232002026-02-14T07:35:46ZPayne, CharlotteI.—01/13/05N/ANULL+1 472 498 3309NULL2382 GRAND AVEGlendaleAZ85354—null
CLMCLM-4092682026-10-15T02:05:53ZHiroshi—Miller1978-09-12uhc-76081-36nullNULLUNKNOWN8858 SAGE CTGilbertAZ85263NULLnull
CLMCLM-4315032026-01-14T09:00:19ZMarthaJHarvey··01/08/1988NULL•••-••-3415N/A—6664 Union StDenverCO—nullnull
ENRENR-1333912026-05-23T23:57:22ZSantiago, CynthiaH—Mar 9, 2006UHC-06856-30··•••-••-14299067084CYNTHIA.SANTIAGO40@YAHOO.COM5327 MAPLE AVENUELAS VEGASNevada89111GRP-0476··CHOICE-PLUS-PPO
ENR ENR-1003142026-01-23T05:12:57ZLisa—Morgan2001-02-04UHC-63545-45——-·1074 Lake View RoadSEATTLEWA98157GRP-6397MEDICARE-ADV-A
ENRENR-1021692026-04-12T06:01:50ZBeverly·LMcDonald19831012UHC-63479-17•••-••-5720619.988.4275BEVERLY.MCDONALD55@OUTLOOK.COM1805 Canyon RdFresnoCA93785GRP-2443MEDICARE-ADV-B
CLMCLM-4090782026-01-11T01:50:14ZTren, RobertN—1978-03-12UHC-15067-68—N/A—6155 Spring StreetPLANOTX·-GRP-1353CORE-HMO
TPATPA-597682026-03-12T12:35:24ZRICHARD··SCHULTZ1960-09-04NULL··-676.572.2649NULL3637 Union StreetTempeAZ85264-UNKNOWN
ENRENR-1341372026-07-15T22:25:16ZVIGRINIAW.STONE22-02-1968UHC-66168-77•••-••-3120UNKNOWN—329 Spring Street·AustinTexas78792GRP-3017··MEDICARE-ADV-A
CLMCLM-4153642026-08-14T14:47:55Z Ethan—Little03-02-1983UHC3463267•••-••-8311+1 983 411 2655N/A2244 PINE DRIVETampaFL33633GRP-9479UNKNOWN
CLMCLM-4076382026-01-20T16:37:37ZMason, Ana——2002-01-10UNKNOWN··-3122246069UNKNOWN—UNKNOWN—UNKNOWNN/ANAVIGATE-HMO
ENRENR-1404392026-09-14T19:52:23ZKatherineQWheeler1982-06-17·UHC-14259-82UNKNOWN+1 945 917 1020katherine.wheeler73@outlook.com5094 MAPLE AVELas VegasNV89196GRP-0210SELECT-EPO
TPATPA-509972026-02-18T11:34:58ZRalph—Woods1967-07-26NULLnull····UNKNOWN6887 Spring StTampaFL33671GRP-9120—
CLMCLM-4193222026-05-17T16:30:06ZThomas, Megan——14-10-1998UHC-49695-95•••-••-6822—UNKNOWN2120 HIGHLAND AVEDALLASTX75221··NULLCORE-HMO
PRVPRV-212902026-08-12T03:27:45ZKathy—Sandoval19620514-•••-••-8227N/AN/A5904 Central Avenue··TempeAZ85242—CHOICE-PLUS-PPO
ENRENR-1310182026-08-19T10:07:24ZMeiFArmstrongJun 21, 1992UHC-83413-64•••-••-9378237-782-0792MEI.ARMSTRONG16@AOL.COM6233 Canyon RdPlanoTX··75071GRP-3687OPTIONS-PPO
PRVPRV-204142026-07-12T00:48:30ZChristian—WelchJul 15, 1975UHC-53208-60—450-314-6399-4593 Elm Street·JacksonvilleFL32299NULL··
100,000 rows, page 86 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:34.799Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty