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-575522026-03-22T07:43:34ZCooper, DannyE····1969-07-18NULL•••-••-4235620-801-1209—6979 DESERT SKY BOULEVARDSEATTLEWA98167N/AN/A
CLMCLM-4004062026-09-13T07:19:50ZAaron··—Harper2008-11-02N/A—289-634-1496null3658 Market StreetScottsdaleAZ85237·GRP-7940UNKNOWN
CLMCLM-4211832026-05-16T14:00:34ZgaryM.guerrero12/10/85—•••-••-538514105945149N/A5571 JEFFERSON AVELos AngelesCA—GRP-9963··OPTIONS-PPO
ENRENR-1245492026-08-09T17:33:42ZBrian—Watson1975-03-19UHC0161426•••-••-16675452026N/A3215 Sage CourtLAS VEGASNV89184GRP-8817CHOICE-PLUS-PPO
CLMCLM-4201212026-08-21T04:09:15ZJacqeuline—Ferguson1974-09-25UHC-12789-54——null····-UNKNOWN-GRP-8018null··
ENRENR-1255592026-06-26T02:30:28ZEdwardEGreen1963-11-19UHC-68492-66-·3788755118edward.green@outlook.com7570 HIGHLAND AVE··Miami··FL33193GRP-3775MEDICARE-ADV-B
ENR ENR-1062992026-04-29T20:44:11Z·Arthur—Alexander19560820UHC-11557-51•••-••-14246064968151arthur.alexander60@aol.com4818 MARKET STREETNashvilleTN37273GRP-8607SELECT-EPO
ENRENR-1139002026-04-15T10:31:14ZHeatherG.Pricce·1957-11-07UHC-36993-92•••-••-8853974-888-7320HEATHER.PRICE@OUTLOOK.COM7101 Palm DriveDALLASTX75220GRP-7627·MEDICARE-ADV-A
CLMCLM-4113472026-10-05T06:44:20Z Bill··—Dunn6/10/1953UHC-72312-69•••-••-8245778-364-2545-—N/A——UNKNOWNCORE-HMO
ENRENR-1292592026-08-21T16:57:37ZHiroshiW.Morgan1994-04-16UHC-20795-47··•••-••-0452(913) 556-4881HIROSHI.MORGAN82@AOL.COM1282 Sunset Boulevard #577AtlantaGA30361GRP-9173OPTIONS-PPO··
TPATPA-501712026-06-07T20:23:25Zralph—ellioott19930626NULL———3733 LAKE VIEW RDEden PrairieMN55372-4782—MEDICARE-ADV-A
ENRENR-1131732026-02-01T09:24:09ZGreen, MarianaT.··—1989-08-17UHC-41515-80null+1 354 715 9929—9052 Grand AvenueDenverCO80222GRP-4848NAVIGATE-HMO
CLMCLM-4052812026-06-19T13:07:30ZJudith····Harris9/18/1938UHC-25584-49•••-••-7769——····———·GRP-7705OPTIONS-PPO··
CLMCLM-4318322026-08-04T19:51:05ZBruceS.Johnson··1979-07-16UHC-57855-96··•••-••-7435331-449-2617UNKNOWN1021 Meadow Lane #391·PlanoTX75019N/ACORE-HMO
PRVPRV-213112026-02-26T04:32:57ZJACOB—SIMPSON1/24/2000UHC0292618··—N/A—4452 MAPLE AVENUECHARLOTTENorth Carolina28267NULLUNKNOWN
ENRENR-1346492026-10-09T21:57:47ZHiroshi··N.Greene1997-09-26UHC-56048-27null(716) 296-6600HIROSHI.GREENE@ICLOUD.COM7106 MARKET STREETSacramentoCA95896GRP-0686SELECT-EPO
ENRENR-1133992026-08-01T12:06:11ZCox, RonaldA—19800809UHC-19931-06•••-••-1809(715) 717-3069ronald.cox@aol.com6564 CAMELBACK ROAD···Charlottenc28270GRP-8715OPTIONS-PPO
ENRENR-1189472026-04-15T12:13:12ZChristinaDArmstrong1997-01-04UHC-21735-06•••-••-2435425-634-4023christina.armstrong@yahoo.com8489 Pine DriveSeattleWA··98188GRP-3889OPTIONS-PPO
CLMCLM-4179032026-04-17T10:44:52ZBRUCE—HOLMES1987-02-03UHC-07074-32•••-••-3219N/A—4044 GRAND AVEMinneapolisMN55423GRP-1662SELECT-EPO
ENRENR-1377682026-01-15T12:06:48ZIsabella—·Halll1947-03-05UHC-55281-38null219-557-0261isabella.hall@aol.com9712 WASHINGTON STHoustonTX77040GRP-2445MEDICARE-ADV-A
CLMCLM-4056512026-01-10T00:43:33ZMaria—Griffin06/25/89UNKNOWNNULL—null··nullUNKNOWN·UNKNOWNNULLNULL-
CLMCLM-4276852026-07-09T21:10:44ZJESSE—PETERSON·1963-11-24—N/A8226045jesse.peterson61@outlook.com3424 MAPLE AVELos AngelesCA90098GRP-4256-
CLMCLM-4045882026-02-08T16:26:23ZAnna··Sanchez1977-11-26NULL--···UNKNOWN————GRP-2760OPTIONS-PPO
ENRENR-1206322026-04-02T06:56:59ZJonathan—Bares1997-01-27UHC-03469-09•••-••-75342526437738JONATHAN.BARNES53@AOL.COM8367 ELM STREET··Charlottenc28252GRP-6542NAVIGATE-HMO
CLMCLM-4044662026-10-06T14:05:38ZDan—Carroll09/22/08UHC-28665-19•••-••-2636-UNKNOWN4534 HIGHLAND AVECharlotte·NC28286GRP-2081NULL
ENRENR-1344702026-01-25T04:58:54ZGLORIAF.ALVAREZ04-09-1956UHC-31983-88•••-••-3717+1 484 215 4398GLORIA.ALVAREZ@PROTON.ME··6186 Ocean Ave·DenverCO80241··GRP-0102·OPTIONS-PPO
CLMCLM-4043422026-02-15T12:11:00ZEMILY—·BELL2008-06-26·UHC-21783-69•••-••-4816——1694 Harbor BoulevardNashvilleTN··37238-5552GRP-1892—
CLMCLM-4202952026-10-01T20:44:06ZSUSAN—JACKSON1985-02-10—•••-••-7588574-899-3895—1342 Mountain View Dr #681MesaAZ85280-—
CLMCLM-4146912026-05-21T06:58:14ZMEGAN—BURKE1980-12-16UHC-39787-28UNKNOWN2963527592NULL7111 OCEAN AVE Apt 35SeattleWA98128——
ENRENR-1105772026-06-01T18:45:38ZJoeGColeman1952-07-16UHC-89912-98•••-••-6527(213) 613-2067joe.coleman55@yahoo.com5241 Cedar LnMesaAZ85208GRP-8337OPTIONS-PPO
PRVPRV-259072026-08-19T05:57:46ZLAWRENCE—JACKSON08-10-1972UHC-33336-58—+1 430 293 3514—8802 Harbor Blvd··NashvilleTN37265-—
ENRENR-1396022026-03-05T04:04:13ZDanielRLuna2/6/1967UHC-54159-78•••-••-4168(841) 908-7542—2620 Apache BoulevardHouston·TX77017GRP-0532CHOICE-PLUS-PPO
ENRENR-1074222026-07-07T05:28:10Z JudithFMartin1992-01-20UHC-58715-49-——3511 SUNSET BOULEVARD·Minneapolis·Minnesota55413GRP-6748OPTIONS-PPO
TPATPA-559922026-09-18T07:32:23ZElijahY.·Castillo27-10-1939—NULL780.730.3324-2196 ELM STChandler··AZ—nullmedicare-adv-b
CLMCLM-4322352026-09-26T09:30:14Zaisha—gardner1969-09-06UHC-26182-08-··7864618—8538 Hillcrest RdSACRAMENTOCA95884GRP-8332NAVIGATE-HMO
PRVPRV-287872026-01-08T01:27:00Zcarolyn—li1947-07-28—•••-••-2424(774) 976-4183carolyn.li71@outlook.com··—·N/A—-NULL··
TPATPA-500262026-04-02T05:40:42ZNATALIE—SALAZAR02/22/1957NULL•••-••-7860-··—NULLNULL-—NAVIGATE-HMO
CLMCLM-4160292026-05-29T22:17:21ZLuri—Gibson08/15/60N/ANULL(817) 425-9575UNKNOWN8161 Ridge Road··AustinTX78715—CHOICE-PLUS-PPO
ENRENR-1262762026-09-18T11:42:16ZMATEO—GUZMAN1969-11-18UHC-81858-58•••-••-3458(698) 524-8265MATEO.GUZMAN16@AOL.COM341 Church StreetDallasTX75228GRP-2243CHOICE-PLUS-PPO
TPATPA-523082026-07-07T15:49:46ZAlexis····Washington1997-12-03·NULL•••-••-0450NULLN/A5669 Valley View DrColumbusOH43234-8286-—
PRVPRV-229542026-02-12T05:28:31ZChristine—MoralesJan 19, 2007nullNULL567.467.7874··—8944 Forest AveCharlotteNC·28211·N/AUNKNOWN
PRVPRV-287222026-01-18T19:18:07ZBrenda—Bennett1963-03-11———·brenda.bennett2@outlook.com6951 Sunset Blvd·SAN DIEGOCA·92121null—
CLMCLM-4236782026-01-28T02:46:13ZAdamBGriffin1984-03-08—•••-••-3218205.831.5730-nullnullUNKNOWN··NULL··—navigate-hmo
CLMCLM-4095462026-02-25T09:14:39Z Tucker, Douglas——08/22/1992UHC-89410-87UNKNOWNUNKNOWN-5520 Desert Sky BoulevardGlendaleAZ85372NULL—
ENRENR-1002052026-01-08T09:16:07ZVincent Y—Ruiz20050928UHC-75913-18•••-••-51107193792334vincent.ruiz48@aol.com3625 Church StORLANDOFL32803GRP-9465NAVIGATE-HMO··
ENRENR-1114542026-03-09T14:38:33ZAllen, AishaA—1979-02-22UHC-59734-47•••-••-2010(748) 601-1768AISHA.ALLEN@OUTLOOK.COM6345 MEADOW LNScottsdale·AZ85262GRP-9141CHOICE-PLUS-PPO
ENRENR-1380512026-07-16T07:53:17ZSharon····Ruiz1996-02-26UHC-05868-02•••-••-095216668856260··sharon.ruiz@outlook.com2788 Washington StreetTampafl33609GRP-2076navigate-hmo
TPATPA-546062026-08-06T22:14:29ZSam—Martinez1964-04-01N/A•••-••-6049N/A··—6530 Cedar Ln·GlendaleAZN/A—-
ENRENR-1427042026-04-24T14:34:43ZHiiroshiK.Willams1950-01-04UHC-95783-27•••-••-6585820-222-2304hiroshi.williams@proton.me232 MOUNTAIN VIEW DRIVEDENVERCO80275GRP-7302MEDICARE-ADV-B
CLMCLM-4267252026-07-29T03:27:40ZJanice—Duncan2003-08-22UHC-43398-21•••-••-9042212-571-4493—1469 Central AvenueLos AngelesCA90099N/A—
100,000 rows, page 4 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-19T19:54:25.413Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty