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-1006412026-08-17T11:01:49ZIsabella····Wang1997-04-11UHC-38725-82•••-••-48487617249isabella.wang67@proton.me·4334 Jefferson AveHoustonTexas77027GRP-5851CORE-HMO··
ENRENR-1248502026-01-20T06:53:47ZOmar—·Lee1956-02-14UHC-17270-62null2693595840·OMAR.LEE4@OUTLOOK.COM348 Palm DrJacksonvilleFL32252GRP-1900··NAVIGATE-HMO
ENRENR-1348852026-09-12T01:32:36ZOwens, PatriciaS—·1950-08-04UHC-87048-14•••-••-3262617-444-0320PATRICIA.OWENS50@PROTON.ME··3078 OCEAN AVENUENASHVILLETN37201·GRP-9441CORE-HMO
CLMCLM-4034792026-04-13T15:03:51ZSAM··—EVANS2003-06-19—·-—-··4995 Maple AvenuePhoenixAZ··85021N/A-
PRVPRV-27230 2026-03-01T00:02:00ZHarper, Natalie——1974-06-13UHC-41642-39·NULLNULL··—4968 Camelback RdAtlantaGA30307··N/ACHOICE-PLUS-PPO
ENRENR-1145642026-01-09T12:36:09ZSeanB.Perry05-10-1972UHC-95752-06•••-••-71087489232391sean.perry@hotmail.com8590 Jefferson AveCHANDLERAZ·85206GRP-6172MEDICARE-ADV-B
CLMCLM-4276902026-09-17T11:55:05ZMARCUS—REYNOLDS1992-60-16UHC-16240-68null·(602) 660-6361——NULL—UNKNOWN—····
ENRENR-1132932026-06-23T11:39:51ZMaryNRussell23-12-1942UHC-42213-42•••-••-0294(309) 420-5832mary.russell3@gmail.com6848 Jefferson AveLas VegasNV89179GRP-7384OPTIONS-PPO
ENRENR-1352852026-02-22T01:21:08ZDAVIDJ.RYAN1990-01-19UHC0604057•••-••-99897342478808DAVID.RYAN64@GMAIL.COM5979 Park PlOrlandoFL32832-3592GRP-4714OPTIONS-PPO
TPATPA-612312026-07-07T09:05:31ZELIZABETH··WEAVER1985-07-09UHC-21629-88—NULLN/A2357 OCEAN AVENUESan Antonio·TX78239GRP-9943····
CLMCLM-4012752026-05-07T15:21:54ZMarkRMcDonald2/6/1989··UNKNOWN·NULL854-830-0320null1238 PARK PLSeattleWashington98192GRP-0848MEDICARE-ADV-A
ENR ENR-106512 2026-10-09T16:47:16ZArjunF.Lopez··1959-11-20UHC-85521-93—·225.564.1562arjun.lopez@aol.com5286 HIGHLAND AVENUELos AngelesCA90011GRP-9325CORE-HMO
CLMCLM-4179082026-06-08T09:17:46ZNicholas—Washington08/08/68UHC1839187UNKNOWN+1 479 687 0616UNKNOWN6609 Highland AvePhoenixAZ85085GRP-1485-
ENRENR-1311682026-05-13T01:04:29Zraymond··—torres03/02/2007UHC-11215-39•••-••-394716008236456raymond.torres@proton.me·6610 PINE DRIVEAustintx78714GRP-3423CHOICE-PLUS-PPO
ENR ENR-1165142026-01-04T11:44:42Zwayne···rojas02/06/1965UHC2922561•••-••-0148333.766.7105wayne.rojas@icloud.com5328 Pine DrFresnoCA93773GRP-5655NAVIGATE-HMO
ENRENR-129228 2026-03-08T08:54:25ZTucker, Wei——12/27/1979UHC-94558-28•••-••-29362356894324-5189 Valley View DriveNashvilleTN37212GRP-6426NAVIGATE-HMO
TPATPA-583942026-04-11T00:08:13ZFernandez, Amber—··Aug 14, 1970—nullUNKNOWNNULL3495 Hillcrest RdSan DiegoCA·92129UNKNOWNCORE-HMO
ENRENR-1415162026-09-06T02:11:14ZEvelynF.Vargas1995-06-15UHC-61305-53•••-••-52785747753420evelyn.vargas@outlook.com8105 Church StreetGlendaleAZ85347-8406GRP-9192CHOICE-PLUS-PPO··
ENRENR-1015582026-08-18T08:23:25ZJulia—Sanders1990-03-17··UHC-75221-78•••-••-28399889045241NULL9533 WASHINGTON STREETDenverCO80232GRP-4746NAVIGATE-HMO
ENRENR-1144112026-06-26T22:16:29ZDOUGLAS·AHALL27-03-1965UHC-41939-31•••-••-3621+1 472 671 8562douglas.hall8@yahoo.com4216 Harbor BoulevardHoustonTX77087-9125GRP-5785MEDICARE-ADV-A
ENRENR-1361902026-10-12T06:20:54Z Joe C.—Day1948-02-19uhc-72292-79····358-898-6299null6135 APACHE BOULEVARDMiamiFL33133GRP-6939SELECT-EPO
ENRENR-1073742026-07-22T17:01:18ZBlack, HeatherG—19830118UHC-29594-73•••-••-8701(655) 548-6532HEATHER.BLACK@PROTON.ME3321 Washington Street··Los AngelesCA90040GRP-7477MEDICARE-ADV-B
TPATPA-505412026-03-28T08:18:20ZMaria—Washington1968-08-24··NULL—null—1478 BAYSHORE DRIVESacramento··CA95859GRP-8811—
CLMCLM-4239372026-09-18T19:20:52ZFoster, Gerald··——1993-02-26NULL—NULL—·8689 Jefferson AvenueTUCSON··az85762GRP-1453··NULL
CLMCLM-4057962026-01-20T16:36:31ZJordan—Duncan1993-06-11nullNULL(786) 319-0096—4713 Indian School RdHoustonTX-GRP-9330OPTIONS-PPO
CLMCLM-4232032026-07-11T15:51:13ZSam—Adams07/20/60UHC-62298-66··N/AUNKNOWN—2770 CANYON ROADCOLUMBUSOH43226GRP-8950SELECT-EPO
TPATPA-639822026-07-20T21:50:30ZGRACE—LE0201-07-10null-····UNKNOWN·7146 Central AvenueSAN ANTONIOTX78244-null
TPATPA-585982026-06-29T23:05:39ZJacobKArnold1945-11-04UNKNOWN•••-••-7841(429) 917-8212—NULLUNKNOWN—UNKNOWN—-
ENRENR-1089382026-08-15T21:33:57ZElizabethRFowler1983-08-12UHC-18239-50•••-••-06192159457070ELIZABETH.FOWLER@ICLOUD.COM2647 MAPLE AVEPhoenixAZ85041GRP-2227medicare-adv-a
ENRENR-1258512026-04-01T20:45:01ZCarlson, NicoleD—20-10-1941··UHC-64211-07•••-••-3917349-886-9262UNKNOWN8802 PINE DRIVETampaFLNULLGRP-0483CORE-HMO
PRVPRV-272382026-10-18T17:34:39ZBruce—MunozAug 13, 1993UHC-93815-58•••-••-1958446.538.8925··-NULL——N/ANULLN/A
ENRENR-1038732026-03-02T01:47:29ZNATALIEH.BANKS-UHC-06375-15•••-••-8433·(480) 554-2343natalie.banks@icloud.com4380 Pine DrAustinTX—GRP-2558CHOICE-PLUS-PPO
CLM CLM-4278512026-03-01T20:42:08ZDyylan·YCole01-07-2004UHC-93588-47—258-293-0050dylan.cole50@outlook.com6513 Cedar Lane··PhoenixAZ85086N/AMEDICARE-ADV-A
TPATPA-589342026-01-26T08:19:29ZNathanABell12/03/1942-—2603064347NATHAN.BELL53@OUTLOOK.COM1240 Park Place··MiamiFL33170-—
PRVPRV-289892026-10-18T17:15:29ZRandy—Matthews1958-06-21UHC-30155-02—NULL····4302 JEFFERSON AVEMiamiFL33187——
PRVPRV-270402026-02-16T14:39:49ZMasonVRios1980-07-07UHC-58394-45null7052457259mason.rios@yahoo.com8660 Central Avenue···HoustonTX77095-null
TPATPA-637772026-08-05T08:07:08Zsteeve—robertson1974-04-26—-nullstephen.robertson8@aol.com4568 CANYON RDFresnoCalifornia93735-2481-null
CLMCLM-4282572026-02-05T12:27:35ZJoshua··Roberts1979-05-25UHC-70115-04•••-••-5206null—-··—null-····UNKNOWN
CLMCLM-4242772026-09-19T07:01:42ZDeborah··—Vargas19440626——NULLN/A4953 APACHE BLVDMINNEAPOLISMN55473GRP-4934—
ENRENR-1298172026-01-21T21:15:52ZCarlosHPenaDec 7, 1992UHC-50186-13•••-••-0238364-519-0507-7674 Pine DrTucsonAZ85745GRP-2124MEDICARE-ADV-A
ENRENR-1055462026-04-30T13:22:53ZFRANKX.CONTRERAS1959-06-18UHC-79195-30•••-••-4828628-503-2006frank.contreras32@yahoo.com5259 Spring StreetMesa·Arizona85274-5561GRP-4620OPTIONS-PPO
ENRENR-1009952026-06-11T01:44:22ZShirley··QWiliamson25-04-1962UHC-89515-83•••-••-3787946-638-0048shirley.williamson33@outlook.com4586 CHURCH STTampaFL33619-6578··GRP-1353MEDICARE-ADV-A
ENRENR-1330932026-05-17T16:10:01ZRachelF.Griffin2005-03-12UHC-76041-46··•••-••-134213118618954RACHEL.GRIFFIN@YAHOO.COM5971 Baseline RdHoustontx77068GRP-6101medicare-adv-b
CLMCLM-4120972026-05-31T16:38:10Z Abigail—Scott1979-12-18UHC-38723-32NULLNULLnull943 Harbor BlvdOrlando··FL32833GRP-5016null
ENRENR-1175892026-03-13T11:34:59ZBradley··Martinez05/14/98UHC-38793-60•••-••-5187·5148930755null7736 Pine DrColumbusOH43237GRP-7779CORE-HMO
ENRENR-1301622026-01-07T02:14:04ZJean—Garrett1944-01-18·UHC-65015-52•••-••-8253(329) 472-9854jean.garrett@outlook.com3445 Elm StSan Antonio·TX78222GRP-5056··MEDICARE-ADV-A
ENRENR-1120232026-09-21T02:24:03ZASHLEY—MARQUEZ06/24/74UHC-60528-22•••-••-7379+1 519 895 3939—3704 CEDAR LN·Eden PrairieMN55376GRP-8599OPTIONS-PPO
CLMCLM-4188522026-01-22T13:46:07ZDOUGLAS—MCDONALD1959-11-11·UHC-18708-72—N/ANULL6907 VALLEY VIEW DRIVEAustin·TX78704GRP-9482—
TPATPA-545122026-02-01T03:09:24ZDYLAN··—BAILEY1962-07-08—•••-••-0427null—8382 Jefferson AveLas VegasNV89144——
ENRENR-1340962026-05-20T10:50:35ZKathryn—Gary1969-12-14UHC-34431-13•••-••-1419(623) 461-7851··kathryn.gray@aol.com·6391 CAMELBACK ROADScottsdaleAZ85213GRP-9951MEDICARE-ADV-B··
100,000 rows, page 188 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.717Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty