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
TPATPA-640102026-10-08T00:35:43Z CHARLOTTE—JACOBS1947-07-01—•••-••-6130——2840 Cedar LaneScottsdale·AZ85266GRP-6701—
ENRENR-101295 2026-02-27T07:53:35ZAMBERN.GREENEMay 19, 1942UHC-79174-43··•••-••-9909248-463-1948amber.greene53@aol.com7738 Market StreetDenverCO80286GRP-9719MEDICARE-ADV-B
TPATPA-527832026-02-28T20:18:22ZWalsh, Don W····—1951-05-07N/A•••-••-07398584013690donald.walsh9@aol.com7131 Spring StDenverCO80243GRP-3953—
ENRENR-1094272026-04-27T00:47:10ZLuisGGrant25-08-1973··UHC-16519-27—(798) 785-7678—192 Forest AvenueEDEN PRAIRIE·MN55358-4447GRP-7747CORE-HMO
ENRENR-1354292026-05-11T13:48:07ZSARAPBOYD1973-05-27UHC-43557-07•••-••-0126602-643-2000SARA.BOYD20@PROTON.ME5882 Apache Blvd··ChandlerAZ85257GRP-4881CORE-HMO
ENRENR-1134982026-02-06T18:15:23ZOMARV.ESTRADA19560713UHC-36670-64•••-••-4209(368) 810-3781··omar.estrada22@gmail.com5347 Sunset BlvdMinneapolisMN55405GRP-3803NAVIGATE-HMO
CLMCLM-4176882026-06-29T09:46:11ZPatricia—Cooper1972-01-15UNKNOWN•••-••-0279UNKNOWNnull2892 Pine Dr Apt 22JACKSONVILLEFL32281-9873GRP-3549···N/A
ENRENR-1277902026-07-21T18:57:34Zkaren—spencer19510918UHC-15553-53•••-••-6793596.902.4780KAREN.SPENCER@OUTLOOK.COM5445 OAK STREETDallasTX75205GRP-8721MEDICARE-ADV-B
CLM CLM-4229572026-07-05T11:18:10Zkathleen—fisher06/22/1940——4052561273NULL8461 Harbor BlvdSan DiegoCA92108GRP-0660—
TPATPA-572002026-01-18T08:07:40ZSantiago—Edwards·2001-03-24N/A•••-••-2423·3697242779UNKNOWN··1283 Main StreetDallasTX75248·····SELECT-EPO
ENRENR-1165052026-01-08T15:03:53ZMARCUS—DEAN1975-08-02UHC-62627-71•••-••-8808976-619-4722·marcus.dean@gmail.com8043 MOUNTAIN VIEW DRIVEDenverCO80238GRP-0827SELECT-EPO
ENRENR-1053272026-03-13T22:11:59ZKimberly··Ryan1985-08-02UHC-27971-98•••-••-6721(419) 348-5247kimberly.ryan@gmail.com··1172 Elm StreetCHARLOTTENC28207GRP-9635CHOICE-PLUS-PPO
CLMCLM-4241752026-06-28T14:42:44Zdoris····rice1964-04-25-—266-667-1217·DORIS.RICE71@OUTLOOK.COM9774 PALM DRSeattleWA98119GRP-3061choice-plus-ppo
ENRENR-136561 2026-03-25T01:41:38ZCHARLOTTE B—RILEY2007-01-23UHC9262492N/A6864994338·CHARLOTTE.RILEY74@YAHOO.COM355 VALLEY VIEW DRTucsonAZ85782-5897GRP-9621NAVIGATE-HMO
TPATPA-591472026-10-10T20:50:58ZJACOB—JENSEN1019-19-42——-jacob.jensen@outlook.com5608 Meadow LaneDenverColorado80260GRP-1972··SELECT-EPO
CLM CLM-4308832026-01-25T00:31:37ZAustin··—·Espinoza02/23/03UHC-00961-08-3133468698UNKNOWN2063 VALLEY VIEW DRIVE·MinneapolisMN55483-6965GRP-1557UNKNOWN
CLMCLM-4078592026-02-12T01:11:02ZEspinoza, RonaldB.—09/20/81NULL-3695381020null763 OAK STREETATLANTAGeorgia30355GRP-0358—
PRVPRV-293702026-05-31T16:57:47ZETHAN··—LOPEZ1972-07-10UHC-92695-79•••-••-613416246151566UNKNOWN··992 SAGE COURTSan DiegoCA92148——
ENRENR-1079352026-03-05T00:10:21ZStephanieO·Ramirez1958-04-20UHC-11118-07··•••-••-3495988.591.3226stephanie.ramirez@proton.me8849 Lincoln WayGilbert··AZ85277GRP-7643MEDICARE-ADV-A··
ENRENR-1235932026-02-23T07:31:37ZLarry—Rogers1970-02-10UHC-32272-09•••-••-06314189493983LARRY.ROGERS@PROTON.ME··7957 Highland Ave·Eden PrairieMinnesota55349·GRP-2171MEDICARE-ADV-A
ENRENR-1113272026-08-10T08:58:11ZMasonEHarris05/11/1972UHC2193672•••-••-97344846329063··9568 Canyon RoadAtlantaGA30392GRP-4899OPTIONS-PPO
ENRENR-1388872026-04-07T19:42:58ZScott—Mason1974-04-01UHC-40347-24•••-••-9396468-318-4879····6312 Grand AvenueColumbusOH43228GRP-4747CORE-HMO
TPATPA-632172026-01-18T07:10:09ZTERRY—CUNNINGHAM··2007-03-21—NULLN/A··—7889 Lake View RdJacksonvilleFL32279-··UNKNOWN
CLMCLM-4201092026-08-25T01:58:34ZbarbaraZgordon1974-10-13UHC-06105-89-(815) 265-7950—3289 Washington Street··OrlandoFL32852GRP-6293UNKNOWN
TPA TPA-530762026-04-07T00:48:45ZDEBORAH····BNKS1964-01-22··UNKNOWN—deborah.banks15@gmail.com8093 Oak StreetPhoenixAZ85022GRP-2283··—
ENRENR-1296092026-04-27T14:11:25ZBOBBYHFREEMAN1945-03-23UHC-82432-95··+1 315 325 3407—8006 Indian School Rd··Eden PrairieMinnesota55361GRP-5686·SELECT-EPO
ENRENR-1420332026-04-17T01:53:24ZSARA—SPENCERAug 11, 1992UHC-86653-96•••-••-36628749584··sara.spencer66@yahoo.com4028 Oak St #476NashvilleTN37290GRP-9034CORE-HMO
CLM CLM-4276292026-04-09T15:46:24ZJORDAN—BANKS1980-04-06-NULL2035825625N/A8932 Elm Street·CharlotteNC28211·GRP-9080—
ENRENR-1299812026-01-24T06:15:02ZDeniseBStone1945-03-04UHC-23922-86•••-••-4736(852) 233-9517denise.stone@yahoo.com4799 WASHINGTON STNASHVILLETN37223GRP-2953CORE-HMO
CLMCLM-4038782026-03-28T05:59:44ZANDREA—BROWN·01/22/77UNKNOWN•••-••-68663447577223UNKNOWN2828 DESERT SKY BOULEVARDSan DiegoCA·92105GRP-7520CHOICE-PLUS-PPO
PRVPRV-217682026-07-26T17:41:10ZJoan—Silva01/08/1980—•••-••-2875-N/A9459 Canyon RdFresnoCA93709UNKNOWNN/A
ENRENR-1016942026-08-07T10:43:31ZAguilar, JudithZ—1940-03-28UHC-01588-51•••-••-1117208-290-0874JUDITH.AGUILAR@AOL.COM4131 Mesa DriveScottsdaleAZ85272GRP-4448··MEDICARE-ADV-B
TPATPA-533312026-08-25T07:42:17ZSofia··Cllark··1963-06-07N/AN/A·617.710.7716·sofia.clark11@proton.me470 Forest AveTampafl33608UNKNOWNchoice-plus-ppo
ENRENR-1111012026-10-13T03:00:19Zzachary··Eweber01/21/1945UHC-61312-95•••-••-85474636411510N/A1671 Elm StreetMiamiFL33142GRP-9617·MEDICARE-ADV-A
ENRENR-1404932026-05-14T13:09:56ZETHAN—GILBERT16-06-1974UHC4371556•••-••-8928(459) 399-9877ETHAN.GILBERT75@GMAIL.COM5664 WASHINGTON STHOUSTONTX77078GRP-6741SELECT-EPO
ENRENR-1125742026-06-29T04:45:14ZStephanie—Henderson1999-04-19·UHC7144786•••-••-5392477-656-3789STEPHANIE.HENDERSON@ICLOUD.COM2267 SAGE CTSACRAMENTOCA95811··GRP-9686MEDICARE-ADV-B
TPATPA-643142026-02-01T11:58:07ZPaul—Nguyen1989-02-24··UNKNOWN•••-••-8624UNKNOWNUNKNOWN5530 Indian School Rd·Phoenix·az85028GRP-7495—
PRVPRV-262812026-03-31T15:37:49ZJudy—Hansen1968-08-13UHC-56044-45··•••-••-9927(478) 404-2141-·7537 Union StGILBERTAZ85296UNKNOWNnull
CLMCLM-4023402026-08-09T22:56:08ZAisha—Simmons04/21/44nullN/A229.351.5885··UNKNOWN·774 Lincoln WayPhoenixAZ85014UNKNOWNNAVIGATE-HMO
CLMCLM-4248832026-04-07T00:06:04ZMitchell, Sarah——1992-09-26UHC-43687-13•••-••-9660--8532 Oak StreetEDEN PRAIRIEMN55386··—N/A
PRVPRV-200052026-08-26T18:45:53ZSophia—Ramirez—NULL—7196681436SOPHIA.RAMIREZ57@ICLOUD.COM—·-N/AnullUNKNOWNNULL
ENRENR-1353472026-04-15T19:02:51Z JoanC.SandersNov 7, 2008···UHC-18445-56•••-••-793618307096442joan.sanders56@icloud.com3502 Forest AvenueChandler·az85239GRP-0873NAVIGATE-HMO
CLMCLM-4323912026-04-10T19:24:36ZSimpson, Charlotte·C—1998-06-25UHC-77087-39•••-••-1862+1 908 508 2494N/A5938 Jefferson AvenueSacramentoCA95834GRP-1849-
ENRENR-1154432026-07-01T21:35:11ZLaura·J·Jensne2003-06-19UHC-27362-06•••-••-0589762-388-9708LAURA.JENSEN54@ICLOUD.COM6137 Indian School Rd··SACRAMENTOCA95876GRP-7730SELECT-EPO
TPATPA-519292026-01-13T18:43:11ZCarol—Rodriguez19901028NULL———NULLNULLNULLNULL··GRP-0952—
CLMCLM-4286192026-01-01T03:56:18ZJACK—YANG1943-06-04··UHC-59751-23•••-••-0767(340) 816-3035JACK.YANG27@AOL.COM2958 Camelback RoadLas Vegasnv89194GRP-8339NAVIGATE-HMO
ENRENR-1174032026-10-07T22:21:34ZDENNIS—BROOKS1956-10-04uhc-34952-16··•••-••-13862699782765dennis.brooks@hotmail.com4878 Camelback RoadAustinTX78767GRP-9124OPTIONS-PPO
ENRENR-1224832026-02-02T12:32:22ZHANNAHOWILLIAMS1972-04-05UHC-24476-29•••-••-92136812021493·hannah.williams@proton.me7890 Oak StSan DiegoCA92121GRP-8891SELECT-EPO
TPATPA-551512026-05-17T23:08:34ZEmmaL·Washington12/01/1949NULL•••-••-2740+1 753 255 3451—2206 Maple Avenue Apt 15SAN ANTONIOTX78222—MEDICARE-ADV-B
ENRENR-1026882026-03-27T05:35:52ZTheresaX.Harper1943-02-25UHC-74940-37•••-••-018616358134116theresa.harper93@icloud.com4015 Highland AveFresnoCA93718GRP-8428OPTIONS-PPO
100,000 rows, page 135 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.692Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty