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-1342382026-03-19T16:44:02ZHiroshi—Garza2005-11-05UHC-77416-36•••-••-92288065786361hiroshi.garza@aol.com3626 INDIAN SCHOOL RDPlanoTX75018·GRP-5015NAVIGATE-HMO
ENRENR-1232512026-08-02T07:30:40ZJoseph—Hansen1940-08-18·UHC-21743-38•••-••-9621814.780.4187JOSEPH.HANSEN54@PROTON.ME6929 BROADWAYHouston·tx77032GRP-7300MEDICARE-ADV-B
PRVPRV-209882026-10-18T01:51:19ZNancySFerguson1983-09-08nullNULLNULLnull3032 HIGHLAND AVECOLUMBUSOH43241UNKNOWNUNKNOWN
ENRENR-104562 2026-01-19T09:25:09ZhenryH.long1969-04-28UHC-73738-13•••-••-51302295816028··UNKNOWN·3353 Spring StreetChandlerAZ85274GRP-7745·CHOICE-PLUS-PPO
TPATPA-644002026-06-03T12:31:35ZCHRIS—PORTER1972-09-25---—3330 Washington StreetTempeAZ85222-4736UNKNOWN··N/A
ENRENR-1266512026-07-12T21:14:03ZBradleyK··Scott23-10-1997UHC-32362-04•••-••-9519(553) 572-8090bradley.scott@outlook.com1514 Camelback RdTempeAZ85216GRP-3605SELECT-EPO
ENRENR-1212582026-09-26T09:10:05ZDORISTJACKSON1964-10-17UHC-46932-02··•••-••-9726·3072851734DORIS.JACKSON39@HOTMAIL.COM7288 OCEAN AVEGLENDALEAZ85348GRP-5045·CHOICE-PLUS-PPO
CLMCLM-4064892026-10-07T14:21:24Z Aaron—OBrien1967-10-21UHC-02423-61NULL—aaron.obrien@outlook.com2467 CENTRAL AVECHANDLERAZ··85277·NULLCORE-HMO
ENRENR-1049472026-03-27T12:05:21ZDEBORAHB·BISHOP1961-04-12UHC-53289-31··•••-••-0737803-973-2355—7177 BASELINE ROADPHOENIXAZ·85079GRP-4378options-ppo
ENRENR-1070682026-02-05T01:40:32ZNATALIEELARSON1999-01-13··UHC-29101-12•••-••-59237118741072null199 Grand AvePlanoTX·75040GRP-5586SELECT-EPO
ENRENR-1126762026-04-04T08:05:02ZAlice—Bennett1981-10-20UHC-05340-64•••-••-216714112656633alice.bennett52@yahoo.com2277 Pine Drive #829DallasTexasnullGRP-9745choice-plus-ppo
CLM CLM-4324312026-06-13T14:53:41ZDominguez, Yki····—05/28/75··UHC-43448-72•••-••-5654(701) 923-5765N/A6273 Bayshore DrCHARLOTTENC28262GRP-1984—
CLMCLM-4234892026-09-13T19:46:25ZDOROTHHY—HOWARD08-06-1963·UHC-03790-63—(485) 514-6828—8082 Willow CtEden PrairieMN55345GRP-5516OPTIONS-PPO
ENRENR-1380652026-07-24T04:58:23ZMatthews, Marilyn——1961-05-19UHC-75503-07•••-••-0176+1 533 211 4737marilyn.matthews@aol.com6552 Canyon RdAtlantaGA30352-7051GRP-8949··MEDICARE-ADV-A
ENRENR-1302392026-08-19T00:48:57Z JamesZHerrera11/09/1979UHC-24048-03•••-••-1993(344) 704-3368JAMES.HERRERA15@HOTMAIL.COM6370 Meadow LnSEATTLEwa98144GRP-4649CHOICE-PLUS-PPO
CLMCLM-4242392026-07-15T00:21:11Z———1985-12-02UHC-44550-43•••-••-471815239443816-2515 Palm DriveTucson··AZ85767UNKNOWNN/A
ENRENR-1286192026-01-13T06:44:55ZLittle, Vincent····—1980-02-28UHC-06876-42•••-••-75476794154910—1858 Market StPhoenixAZ85033GRP-1491CHOICE-PLUS-PPO
TPATPA-51279 2026-08-23T08:28:33ZSTEPHANIE—ROBERTSON··1980-01-10—null18045810159NULLNULLN/A·-NULLnullN/A
ENRENR-1221472026-09-02T02:54:16ZAmberCJackson·1940-04-15UHC-61032-14•••-••-5173966.995.9429AMBER.JACKSON@GMAIL.COM5632 Pine DriveColumbusOH···43216GRP-7038MEDICARE-ADV-B
ENRENR-1407552026-03-07T20:26:59ZColeman—Edward1938-04-08·UHC-02650-81•••-••-8434(212) 669-4821edward.coleman@yahoo.com·8603 Bayshore DriveHoustonTX77084GRP-6592SELECT-EPO
CLMCLM-4160852026-05-04T13:57:44ZChristine—Edwards1969-05-22UHC-19900-65•••-••-4482429-479-4897N/A2240 Desert Sky BlvdColumbusOH43262GRP-9531····
ENRENR-1038722026-03-02T20:00:49ZMargaret—Gutierrez06-10-1961UHC-64472-08•••-••-80576784883519margaret.gutierrez@proton.me2129 Forest AvenueScottsdaleAZ85257GRP-0957NAVIGATE-HMO
TPATPA-584612026-04-16T02:09:44ZMICHELLE—MASON1990-12-28—•••-••-4066——4639 Forest AvenueSeattle·WA98194··GRP-8170····
ENRENR-1250722026-04-22T11:45:29ZMariaZ.··Johnson19941004UHC-32040-91•••-••-390718106280399··—5389 Indian School RoadLos AngelesCA90045GRP-0401··NAVIGATE-HMO
PRVPRV-221482026-07-22T15:04:59Z·Roger—Lewis1956-02-03—•••-••-6736861.490.5018roger.lewis@outlook.com··null—————
CLMCLM-4005762026-02-27T01:28:09ZNathan—Crawford1989-03-21UHC5301967—·9413427409N/A9154 Forest AveGilbertAZ85230NULLOPTIONS-PPO
ENRENR-1330052026-02-09T18:30:49ZCHARLES—·CHAN1978-06-13UHC5701254•••-••-8875827.494.0267CHARLES.CHEN@PROTON.ME2023 MEADOW LNTucsonAZnull·GRP-8096CHOICE-PLUS-PPO··
PRVPRV-236492026-01-02T18:34:26ZJuan—Crawford1988-02-23··——13945071908—5169 VALLEY VIEW DRSacramentoCalifornia95858——
ENRENR-1385552026-04-08T02:34:46ZGarrett, BeverlyT—19581203UHC-81988-70•••-••-98989237699337—3178 BASELINE ROADChandler·AZ85295-9802GRP-8179MEDICARE-ADV-A
CLMCLM-4038122026-06-09T11:58:47ZDEBORAH····BISHOPApr 21, 1961·N/AN/ANULL—7177 Baseline RdPHOENIX··AZ85079——
PRVPRV-290392026-10-07T06:13:26ZJessica······Alvarez1905-03-27UHC-19484-62NULLnullUNKNOWN976 Sunset BoulevardGilbertAZ85218-UNKNOWN
PRVPRV-254852026-01-29T19:15:18ZMason, Jacqueline····—nullUHC-70522-46··808.214.2473—5140 Cedar Lane··MinneapolisMN··55456-3824NULLUNKNOWN
PRVPRV-225102026-02-08T21:51:44ZRalph—Johnston19830127NULLNULL··—·ralph.johnston98@proton.me1083 Sage CtMinneapolisMN55490-null
CLMCLM-4287712026-04-21T12:16:30ZSandra—Bradley1970-05-25UHC-59697-99NULL7829315135—216 LAKE VIEW ROADDenverCO—GRP-8460NULL
TPATPA-590972026-09-27T21:32:39Zchristopher··lucas19460107null-7858852136······NULL—NULL—UNKNOWN··UNKNOWN
CLMCLM-4267202026-06-02T11:33:22ZBRADLEY—HOWARD1992-12-01UHC-85451-99•••-••-4779(274) 618-4074bradley.howard@gmail.com··—NULL-N/AGRP-7961···null
TPATPA-532362026-07-02T21:19:30Zbrian—vazquez16-07-1970N/A··null364-661-5998NULL4314 WASHINGTON STREET··SacramentoCA95831GRP-8130—
ENRENR-1373962026-04-29T23:37:19ZAlbert—Kim1960-05-01·UHC-94099-84•••-••-72258179101715albert.kim@yahoo.com7346 Spring StreetLas VegasNV89151GRP-3294CORE-HMO
CLMCLM-4230172026-06-25T19:29:29Z JENNIFER—COOPER28-07-1983N/A··null—-8673 Elm StDenverCO80270GRP-6082—
ENRENR-1013862026-10-07T23:37:23Zdebra—weaver1964-12-08uhc-98417-45•••-••-4353(715) 222-7119debra.weaver@proton.me9635 PARK PLAtlanta··GA30391··GRP-3724·MEDICARE-ADV-B
ENRENR-1150802026-04-28T01:36:06ZJAAKEF··CARR1973-06-23UHC-11223-36•••-••-05153893918393jacob.carr@proton.me·2448 Canyon Rd·TUCSONAZ85707GRP-0898NAVIGATE-HMO
ENRENR-1201362026-09-18T17:01:56Z·DANIELLEL.BANKS10/19/1942UHC1537358•••-••-32847158864057danielle.banks67@gmail.com38 Forest AvenueLOS ANGELESCANULLGRP-2754MEDICARE-ADV-B
CLMCLM-4327602026-08-17T18:39:03ZJesseA··Hunter1943-06-08-nullUNKNOWNN/Anull——-·GRP-5954core-hmo
ENRENR-1232712026-10-08T17:08:15Z·Anna—Scott19570413UHC-58273-66•••-••-0122(912) 524-1538ANNA.SCOTT44@AOL.COM5832 DESERT SKY BOULEVARDMesaAZ85290GRP-2916OPTIONS-PPO
ENRENR-1132702026-09-04T09:56:33ZJANETB.BAILEYnullUHC-68660-89··—(797) 828-5678janet.bailey@outlook.com4559 BAYSHORE DRIVE·OrlandoFL32861GRP-0836CHOICE-PLUS-PPO
ENRENR-1170582026-07-23T18:35:46ZHarold—Gonzales06/19/80UHC-74823-63•••-••-6131(272) 576-8115HAROLD.GONZALES86@GMAIL.COM6248 Camelback Road #635TucsonAZ85713GRP-0803MEDICARE-ADV-A
ENRENR-1360672026-05-03T23:38:41Z·LaurenRMurphy1969-08-21UHC-46397-91•••-••-23839237297088LAUREN.MURPHY69@PROTON.ME6265 OCEAN AVENUEMesaAZ85264GRP-3939MEDICARE-ADV-B
PRV PRV-230312026-01-09T09:20:12Ztimothy—martin1985-02-15·UHC-77042-14—821-565-2923UNKNOWN5826 Maple AvenueFresnoCA93768——
ENRENR-1092822026-09-06T05:09:19ZAlexis—Burke1951-01-13UNKNOWN•••-••-4335—alexis.burke@yahoo.com6809 Valley View DriveTUCSONAZ85747GRP-6347CORE-HMO
ENRENR-1056572026-02-08T13:34:01ZAndreaECarr1967-08-01UHC-30099-41•••-••-48112133135396··ANDREA.CARR@YAHOO.COM8551 Desert Sky BlvdORLANDOFL32888GRP-8673·MEDICARE-ADV-B
100,000 rows, page 95 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.803Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty