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-1276132026-01-01T11:36:32ZDot··—Green21-08-1985··UHC-13074-61•••-••-93623933189687dorothy.green@hotmail.com1200 HARBOR BOULEVARDMinneapolisMN55482GRP-2959CORE-HMO
ENRENR-1292422026-07-08T04:30:06ZFrankA.Payne··1995-07-16UHC-69731-21•••-••-5612722-411-1339frank.payne@icloud.com··1501 WASHINGTON STREET··GLENDALEAZ85300GRP-4923MEDICARE-ADV-A
ENRENR-1011742026-01-31T06:57:10ZAmy—Woong1998-07-28UHC-95146-52NULL(824) 365-5662amy.wong90@proton.me3591 BROADWAYSacramentoCA95820GRP-4765MEDICARE-ADV-B
ENRENR-1041402026-03-20T12:58:27ZSandoval, SamanthaV.—06/18/00UHC-17937-83N/A946-647-4914null7192 Highland AveMinneapolisMN·55419GRP-7446OPTIONS-PPO
PRVPRV-202322026-10-07T06:56:05ZJoshua—Vasquaz1940-01-03UHC-79855-18N/A(827) 637-2355··8275 Washington StAustinTX78773null····
ENRENR-1201372026-08-16T00:12:06ZNichols, OmarG—1974-12-28UHC-45484-87•••-••-5601+1 506 640 3452—1161 RIDGE RDDenverCO··80273GRP-0508medicare-adv-a
ENRENR-1365182026-10-03T19:03:13ZSARA—HAWKINS02/02/1986uhc-45242-14•••-••-47429262901022··null1415 Ocean AvenueAtlantaGA30337GRP-0717·MEDICARE-ADV-A
ENRENR-1386162026-08-31T20:07:35ZMARGARET—BANKS12/17/2003UHC-02221-08•••-••-2137·18087806638margaret.banks51@icloud.com6612 BASELINE ROADFresno·California93762GRP-4249NAVIGATE-HMO
CLMCLM-4294972026-05-17T19:20:51ZMARIALMORENO2007-11-28UHC-61343-62N/A306-788-1041N/A9319 Apache BoulevardTampaFLN/A·GRP-8292options-ppo
ENRENR-1079232026-06-14T20:12:04ZGERALDWRICHARDSON1957-04-11UHC-52791-35•••-••-27982998825660··gerald.richardson@proton.me1747 SAGE COURT #988GilbertAZ85254GRP-3281CHOICE-PLUS-PPO
PRV PRV-217412026-07-23T20:16:43ZFrances—AndersonFeb 5, 1976—UNKNOWN3248346442N/A7806 Market StreetDallasTX-——
TPATPA-575372026-04-18T01:20:11Zcamila—hamilton25-08-1959—UNKNOWN803-936-7556CAMILA.HAMILTON@OUTLOOK.COM-··NULL····N/ANULLNULL
TPATPA-629612026-01-21T18:09:19ZSTEVENS—VALENITNA1943-01-26—····N/AUNKNOWN8592 MOUNTAIN VIEW DRHoustonTX77011N/AN/A
TPATPA-635052026-04-26T05:07:44Z·HAROD—HOWELL01/19/39—•••-••-4093··harold.howell@yahoo.com300 Washington StNASHVILLETN37219—·MEDICARE-ADV-B
TPATPA-602802026-04-26T00:23:22ZJonathan—Peterson1958-09-11—•••-••-1156(370) 210-7906—8169 Sunset BlvdHoustonTX77071NULLNULL
CLMCLM-4001732026-03-05T10:19:44Z Janice··Rivera1975-04-23UHC-27879-12—(812) 538-0707—708 BASELINE RDDenverCO80257GRP-8668—
ENRENR-1214382026-05-19T11:47:51ZTeresa—Martinez02/26/1976UHC-30493-45•••-••-3718961.478.6866teresa.martinez@gmail.com332 Cedar LaneTucsonArizona85752GRP-8243MEDICARE-ADV-B
ENRENR-1183922026-03-18T00:13:42Zstephen··L.lawson1974-09-03UHC-40167-97•••-••-1754(894) 211-4802stephen.lawson34@outlook.com··5405 VALLEY VIEW DRDENVERColorado··nullGRP-3882·NAVIGATE-HMO
CLMCLM-4027002026-04-28T21:23:48ZArthurSBurton1996-05-21UHC-20218-65•••-••-5957N/AN/A8899 Cedar LnJacksonvilleFL32238—navigate-hmo
CLMCLM-4245512026-08-26T09:44:13ZJoan—Mendoza02/17/1951UHC-92655-07-16072545982··N/A—UNKNOWN··NULLGRP-4832CHOICE-PLUS-PPO
CLMCLM-4166502026-06-30T23:31:50ZChristine—Smipson··1943-05-14NULL•••-••-2355-·nullNULL——nullGRP-1933MEDICARE-ADV-A
ENRENR-1105112026-01-29T12:51:34ZWAYNE··EGRAHAM12/25/1971··UHC6626017•••-••-2063(251) 872-2302WAYNE.GRAHAM@GMAIL.COM9446 Central AvenueOrlando··FL32802GRP-3832OPTIONS-PPO
TPATPA-516842026-07-01T03:26:11ZGabril—Fisher··1962-02-02··—UNKNOWNNULLUNKNOWN3157 Baseline RdChandlerAZ85283—-
ENRENR-1307732026-06-07T03:55:10ZDEBORAHA.HOFFMAN19551220UHC5807009•••-••-41176522655625DEBORAH.HOFFMAN1@HOTMAIL.COM551 Spring StreetChandlerAZ·85202-1745GRP-7925NAVIGATE-HMO
CLMCLM-4085512026-09-07T09:07:55ZAnderson, MarianaD.—20001014UNKNOWN•••-••-3369—N/A340 Ocean AveCOLUMBUSOH43274null·CORE-HMO
ENRENR-1000822026-07-31T03:47:11Z ·Mari—Ortiz1999-11-28UHC-72125-46•••-••-3542236.909.2219MARIA.ORTIZ@PROTON.ME5555 Harbor Blvd #443JACKSONVILLEFL32241GRP-3853MEDICARE-ADV-A
CLMCLM-4278502026-01-24T02:16:49Zdlyan—cole01-07-2004UHC9358847—--6513 Cedar LanePhoenixAZ85086-7915NULL—
PRVPRV-203212026-02-14T20:58:48ZSHARON—MEJIA1995-04-14UHC-94173-82—3199293736··—1111 Camelback RoadPhoenixAZ··85081—null
PRVPRV-248142026-05-31T11:34:39ZAlan—Maldonado1940-09-18uhc-40405-98—+1 964 864 0740—3947 WILLOW CTFRESNOCA93760NULLN/A
ENRENR-1289842026-02-12T19:17:18ZLisaU.Stewart1977-12-24UHC9035921N/A608-779-5089null8323 Harbor BoulevardHoustonTX77005GRP-5961CORE-HMO
CLMCLM-4016022026-04-03T20:49:31ZDouglas—Carr0301-91-67UHC-34967-07-UNKNOWN—8779 HIGHLAND AVEPhoenixAZ85020—·NAVIGATE-HMO
CLMCLM-4167962026-06-06T12:10:16ZNICHOLAS—·JACKSON1974-02-26UHC-76666-47•••-••-3341-—-NULLUNKNOWN—N/A—
ENRENR-1222962026-10-01T13:03:19ZGregory—Woods··UNKNOWNUHC-74086-93•••-••-9361854-416-2356gregory.woods@hotmail.com2736 OAK STREETSan DiegoCA-GRP-1416·SELECT-EPO
ENRENR-1150712026-05-09T22:48:01ZANNK.DAVIS1951-07-28UHC-65874-73•••-••-4750·918.986.8567ANN.DAVIS51@AOL.COM2840 Cedar LaneOrlandoFL32807GRP-8002MEDICARE-ADV-A
TPATPA-61869 2026-07-12T19:53:21ZMichael··Santos2003-07-12N/A•••-••-6031·UNKNOWNmichael.santos@icloud.com··7101 SAGE COURTMiamiFL33125—NULL
ENRENR-1056142026-01-24T05:35:21ZLOGAN—LEWIS19800119UHC-94631-76•••-••-8588418-272-0832logan.lewis92@gmail.com924 Indian School Rd #348JacksonvilleFL32236GRP-5109SELECT-EPO
CLMCLM-4018852026-04-14T17:05:36ZBRANDONMFOX2005-04-28UHC-96771-85——-——--N/AUNKNOWN
ENRENR-1341222026-06-11T05:41:14ZValentina··H.Reed04/11/1942UHC-49323-16•••-••-50657309247309valentina.reed22@gmail.com5582 MAPLE AVENUESan DiegoCA92117GRP-6609CORE-HMO
PRVPRV-286952026-03-16T11:05:45Z·Gabriel··Howell1943-02-05UHC-87332-44•••-••-6060(586) 667-6679null2866 Harbor BoulevardSeattle··WA98157—-
ENRENR-1295622026-10-04T12:55:02ZTHERESAUHICKS02/09/1969UHC-01574-14•••-••-66525654780theresa.hicks71@aol.com1799 Highland AvenueJacksonvilleFL32208GRP-0590MEDICARE-ADV-A
ENRENR-1007272026-04-19T23:47:31ZCarlos—Rose1938-05-13·UHC-25199-96null2322482292—7906 SUNSET BLVDDenverCO80246··GRP-1464CORE-HMO
ENRENR-1011032026-07-02T10:31:47ZTeresa—Perry1930-82-25UHC-36932-17•••-••-3814981-985-5949THERESA.PERRY@ICLOUD.COM7782 Willow CourtHoustonTX77096GRP-9479OPTIONS-PPO
CLMCLM-4280732026-04-18T17:13:08ZChrisian—King1952-07-18UHC-48234-46··•••-••-4201+1 308 767 3267—5526 SUNSET BOULEVARDTempeAZ85215GRP-1478—
ENR ENR-1217732026-02-08T22:23:23Z·Omra—Castro1938-12-18UHC-52606-73•••-••-6972542-906-7973N/A6204 Forest Avenue Apt 22GilbertArizona85286GRP-3026NAVIGATE-HMO
ENRENR-1387792026-08-18T12:24:41ZOlivia—Shaw1957-04-28UHC-50891-73•••-••-9231(216) 956-4424··olivia.shaw21@proton.me6872 Jefferson AveDallasTX75259GRP-4241··MEDICARE-ADV-B
CLMCLM-4235642026-07-27T02:59:49ZAlbertQ.Lynch·04/25/1960UHC-64593-13UNKNOWNN/A-1108 Maple AveSeattleWA98143GRP-8548NAVIGATE-HMO
TPATPA-502092026-06-05T13:19:06ZOrtiz, Judith——1/5/1981N/A—7199290UNKNOWN9287 Camelback RdGilbertAZ85216nullUNKNOWN
ENRENR-1048162026-08-28T18:29:28ZAbigail—Freeman1940-01-20UHC-60056-86•••-••-60343975775670NULL7577 Baseline RdMinneapolisMN55477GRP-8477MEDICARE-ADV-A
TPATPA-514392026-07-07T23:50:05ZKeith—Bennett1990-05-26·NULL——-1922 Ocean AveJacksonvilleFL32227GRP-8816UNKNOWN
ENRENR-1014742026-09-03T04:07:01ZLOGANBSIMS1982-02-26UHC-95454-32•••-••-5010253-818-0435—·539 MEADOW LNHoustontx·77006GRP-1881NAVIGATE-HMO
100,000 rows, page 23 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.763Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty