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-1214742026-05-05T21:00:57ZDonnaB.Kim1963-03-16UHC-64234-68•••-••-8876350-691-8676—5079 OCEAN AVENUECharlotteNC28239GRP-5888SELECT-EPO
CLMCLM-4021832026-04-18T00:34:04ZSUSAN—MONTGOMERY1962-01-04·UHC-46842-28·-———NULLNULLnull——
ENRENR-1275192026-06-07T02:00:32ZVasquez, TimothyH—19460816UHC-40176-50····897-227-1401—4462 Baseline RdSan Antonio··TX78200GRP-0209··NAVIGATE-HMO
ENRENR-1267662026-04-19T11:38:05ZGreene, Donna——·1989-01-17UHC-31782-23•••-••-164018568609815donna.greene81@proton.me5500 Hillcrest RdSAN DIEGOCalifornia92179GRP-7933MEDICARE-ADV-A
CLMCLM-4064322026-05-08T14:09:40ZBILLY—HUNT1995-07-25NULL··—(397) 993-9228·NULLnull-null—GRP-7818MEDICARE-ADV-B
CLMCLM-4033672026-07-17T03:58:56ZJulieMStephens12/10/1945·UHC-77192-02•••-••-36976194581058——UNKNOWN----
CLMCLM-4300912026-02-25T00:51:27ZYuki—Spencer·6/28/1940UHC-90438-72-8185216253—2541 Cedar Lane #513PlanoTX75002-6312GRP-7087MEDICARE-ADV-A
ENRENR-1393132026-10-02T23:49:39ZDiane—James11/15/1956UHC-35653-34•••-••-6661747-330-6118··diane.james@icloud.com7761 CEDAR LANETampaFL33642GRP-8937CHOICE-PLUS-PPO
PRVPRV-25321 2026-09-09T21:00:57ZKEVIN—CUNNINGHAM1962-09-09UHC-16646-65NULLnull—4566 Forest AvenuePhoenixAZ85099N/A—
ENR ENR-1323332026-04-10T13:25:49ZGraceSBarnes2001-12-22UHC0261034•••-••-2587(753) 230-2229grace.barnes@yahoo.com3180 Harbor BoulevardOrlandoFL32868-0204GRP-6097MEDICARE-ADV-B
CLMCLM-4298932026-01-05T09:20:13ZCarlos—Grant·1982-04-25UHC-60171-08··•••-••-6457null—7336 UNION STSACRAMENTOCA95866GRP-4670CHOICE-PLUS-PPO
ENRENR-1240862026-10-03T02:06:53ZAmy—Palmer1962-11-23UHC1168255•••-••-2938nullAMY.PALMER@AOL.COM·7688 River RdEden PrairieMN55355GRP-9434MEDICARE-ADV-B
ENRENR-1166702026-05-29T03:45:12ZFrankV.West20080719UHC-04003-72•••-••-4262(365) 272-2280frank.west42@icloud.com9071 Cedar LaneTempeAZ85266GRP-3172choice-plus-ppo
ENRENR-1231432026-02-09T10:29:13ZNathanOWest1965-08-26UHC-01348-64•••-••-0439(850) 963-1061nathan.west23@icloud.com5136 BASELINE ROAD··Columbusoh43228GRP-8048MEDICARE-ADV-B
ENRENR-1104112026-05-01T06:51:54ZSeanCChapman1991-12-25UHC6657779•••-••-516917942644904—6667 Cedar LaneEden PrairieMN·55398GRP-7935MEDICARE-ADV-A
CLMCLM-4147082026-06-11T21:52:30ZRandy—Simpson·1953-11-15UHC-07224-49•••-••-0310(830) 298-6455N/A4237 Camelback RdSan AntonioTX78258GRP-7946CORE-HMO
ENRENR-1398612026-10-12T11:12:08Zkathryn—obrien09/23/1987UHC5953324•••-••-6113(741) 263-2886KATHRYN.OBRIEN@OUTLOOK.COM650 APACHE BLVDPhoenixArizona85022GRP-0434MEDICARE-ADV-B
TPATPA-562192026-04-20T07:03:52Z ChristianU.—·3/18/1942N/A··•••-••-3148N/A—NULLUNKNOWNNULLNULL··NAVIGATE-HMO
CLMCLM-4114302026-09-06T11:35:56ZJOE—TORRES1985-05-16UNKNOWN•••-••-5976UNKNOWN·-7285 Indian School RoadTucsonAZ··85743GRP-5077-
CLMCLM-4228632026-08-29T02:35:30ZALAN—FORD1952-08-28—•••-••-3726—UNKNOWN6670 Baseline RdGilbertAZ85280—NAVIGATE-HMO
ENRENR-1167572026-05-14T10:12:51ZSean··Matthews2008-04-28UHC-14473-06•••-••-7585(686) 818-0716SEAN.MATTHEWS@GMAIL.COM7946 Central AvenueMesa··AZ85261GRP-7887MEDICARE-ADV-B
TPATPA-569522026-08-24T20:37:44ZDorisY.MeyerMay 19, 1961—UNKNOWN-·-UNKNOWNUNKNOWN-N/AN/A··—
ENRENR-1210152026-02-20T16:40:46ZGeraldMNelson1995-12-21UHC-75926-86N/A-gerald.nelson7@aol.com2068 Elm StreetGlendaleAZ85301GRP-5946SELECT-EPO
PRVPRV-277252026-05-16T12:36:11Zdavid—day1970-01-08··UHC-71063-24N/A5623205DAVID.DAY43@ICLOUD.COM7470 PARK PLDenverCO80292UNKNOWNUNKNOWN
ENRENR-1189702026-06-19T07:45:37Zhunter—joan··1950-10-22UHC-46112-23•••-••-2138+1 488 681 8551joan.hunter@proton.me3968 Harbor BlvdORLANDOFL32812GRP-2624options-ppo
CLMCLM-4052242026-02-20T18:41:17ZCharlotte—Snyder1952-11-17UHC-56383-06N/A-N/A···4879 Maple AveSacramentoca95868GRP-8433··—
CLMCLM-414016 2026-09-10T18:08:52Z·Frances—King1988-05-04UHC-31602-81UNKNOWN(506) 582-0088-6888 FOREST AVENUETEMPEAZ85254GRP-6655OPTIONS-PPO
TPATPA-509922026-04-17T06:16:36ZGibson····GabrielApr 8, 1993NULL•••-••-9278NULL··gabriel.gibson14@yahoo.com5197 CEDAR LANENASHVILLETN37295-UNKNOWN
CLM CLM-4214172026-03-25T22:18:24Z YukiMContreras·03/01/1997null··—N/A4549 BROADWAYPhoenix··AZ85046······NAVIGATE-HMO
PRVPRV-244672026-05-25T13:12:09ZDANIEL—HUNTER1990-12-19—NULL—DANIEL.HUNTER@GMAIL.COM3802 Mesa DriveNashvilleTN37296—NULL
ENRENR-1091002026-08-14T05:53:08ZMatthew··KMontgomery10/03/1972UHC-40390-81•••-••-8525+1 907 944 6751matthew.montgomery96@proton.me4920 Lake View RoadCharlotteNC28279·GRP-9394CORE-HMO
CLMCLM-4319122026-01-10T10:36:22ZOmar, MeyerI.—19970426UHC-76229-33•••-••-0852N/A-6245 Market Street #805DallasTX75202-CHOICE-PLUS-PPO
ENRENR-1116582026-03-22T18:04:36ZZacharyNBryant2006-07-04UHC-87908-27•••-••-3729null—1840 Sage CtCharlotteNC28253GRP-6561MEDICARE-ADV-A
CLMCLM-4231452026-09-20T13:15:04ZRebeccaC.McDonald1999-03-21UHC-79820-75UNKNOWN549-814-9132rebecca.mcdonald68@proton.me5631 SAGE CTSCOTTSDALEAZ85275nullOPTIONS-PPO
ENRENR-1327922026-06-29T01:45:14ZWeiB·Rodriguez·19440920UHC-29509-85•••-••-11439508259985—8123 MOUNTAIN VIEW DRIVETempeAZ85254··GRP-6597·NAVIGATE-HMO
CLMCLM-4201152026-08-25T02:31:01ZrogerC·wang06/16/1971··UHC-11203-29•••-••-3927980-684-0763·NULL932 Park PlaceDenverColorado80289—N/A
TPATPA-552322026-04-04T19:08:07ZKelly—Alvarado9/15/1995-null4482819586—2379 Canyon RdJacksonvilleFL32276-—
ENRENR-1051262026-07-01T01:58:56Z Christina—Cruz·9/5/1986UHC-96388-39•••-••-0900·13087113051UNKNOWN4501 JEFFERSON AVENUEEden Prairiemn55391·GRP-5836CHOICE-PLUS-PPO
PRVPRV-249982026-05-09T03:37:09ZJulia—Carpenter·1939-09-16UHC-53528-15UNKNOWN8972660610UNKNOWN3269 SAGE COURTGilbertAZ85291——
ENRENR-1288172026-09-03T14:42:13ZNathanTMunoz1969-05-26UHC-14152-14UNKNOWN943-224-7692NATHAN.MUNOZ@YAHOO.COM8839 Spring St Apt 30SCOTTSDALE·AZ85254GRP-4868MEDICARE-ADV-A··
ENRENR-1256742026-06-21T06:18:37ZJenkins—Emily1991-03-01UHC6313122•••-••-2118(733) 785-5742NULL3664 Camelback RoadAustinTX78775GRP-2202··CHOICE-PLUS-PPO
TPATPA-619352026-02-03T01:40:26Z·Paul—Broooks1980-03-07UNKNOWN•••-••-37874933946646null2313 Indian School RdPlanoTX75003N/A-
CLMCLM-4013672026-09-13T11:32:44ZANGELAI·HAWKINS1940-08-24N/A——N/A975 LINCOLN WAY·MinneapolisMN55432nullCHOICE-PLUS-PPO
ENRENR-1114272026-04-14T03:16:48ZAndyNWalsh1494-08-05UHC-17683-33•••-••-831716976538246ANDREW.WALSH@AOL.COM4949 BASELINE RDJacksonvilleFL32292GRP-0580·MEDICARE-ADV-A
CLMCLM-4212112026-06-10T17:46:31Z·StevenRPriceJan 16, 1939UNKNOWN··——2043 Grand AvenueHoustonTX77062GRP-3400OPTIONS-PPO
CLMCLM-4051062026-05-30T11:38:41Z·Mary·A.Miller··1961-10-25UHC-64703-56NULLNULLN/A870 Market StreetORLANDOFlorida32832GRP-5950—
TPATPA-51064 2026-10-11T04:51:27ZCHARLES··—CRAWFORDJan 1, 1956UHC-28011-91•••-••-1232—···733 Willow CourtSEATTLEWA98168UNKNOWNnull
PRVPRV-219262026-04-08T05:24:55ZCAMILA—SANTIAGO1940-08-03UHC-21140-26····550-821-6953camila.santiago7@gmail.com1728 VALLEY VIEW DRIVEScottsdaleAZ·UNKNOWN-—
PRVPRV-20897 2026-08-10T03:37:13ZDiego—Williams1978-12-01—N/A(682) 765-9100N/A1963 Willow CourtChandlerAZ85252NULL—
ENRENR-1154272026-02-18T10:28:31ZANDREAV.GUERRERO1953-09-12UHC-24890-23•••-••-59164084500877andrea.guerrero33@proton.me9204 DESERT SKY BLVDGilbertAZ85230·GRP-7440OPTIONS-PPO
100,000 rows, page 164 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.706Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty