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-105856 2026-09-10T00:00:08ZMoreno, ScottO—1984-10-06UHC-00221-37•••-••-2750(809) 852-3632·SCOTT.MORENO@YAHOO.COM3320 Cedar LaneDallasTX75245GRP-2260NAVIGATE-HMO
ENRENR-1213342026-07-29T18:53:57ZGERALD—·YANG1963-07-07UHC-53274-69•••-••-20732459276170gerald.yang@gmail.com··533 BASELINE ROADColumbusOH··43261GRP-8035MEDICARE-ADV-A
CLMCLM-4084722026-09-23T05:38:43ZTHOMAS—BRYANT04/05/2004—•••-••-84139252341938thomas.bryant@outlook.com7941 DESERT SKY BOULEVARDTampaFL··33659GRP-6321—
ENRENR-1334572026-09-01T04:44:21ZARJUN··ROBERTSON1958-02-08UHC-02402-18•••-••-0259(712) 316-9065null4366 Lake View RdDallasTX·75266GRP-3584OPTIONS-PPO
ENRENR-1356002026-07-23T11:38:42ZMarilynR.Sullivan05/20/1952·UHC-59465-80•••-••-0207274-851-9508··null5246 Desert Sky BlvdMiamiFL··33143-9647GRP-3876CORE-HMO
ENRENR-1175722026-03-08T13:11:29ZHicks, Sara—····1993-01-17··UHC-61863-88•••-••-99288347243767sara.hicks@aol.com9732 Forest AveMinneapolisMN55485-6686GRP-4548SELECT-EPO
CLMCLM-4244492026-10-03T06:47:28Zamy—simpson··1940-12-05UNKNOWN•••-••-5915UNKNOWN—7977 Bayshore Dr··Jacksonville··FL32260GRP-7858MEDICARE-ADV-A
CLMCLM-4195962026-05-19T16:13:49ZEMMA—·RODRIGUEZ2006-11-25—·NULL—·UNKNOWN894 RIVER RDPHOENIXAZ-UNKNOWN—
CLMCLM-4231892026-01-21T22:10:20ZArmstrong, Jesse——Apr 3, 1941UHC-52920-63•••-••-68258637155511jesse.armstrong5@proton.me2778 Elm StMIAMIFL33109NULLnull
TPATPA-607082026-09-20T04:58:25ZOmar—OBrien1953-12-16null•••-••-5301—-8422 Washington Street··San DiegoCA92135-5868··NULL
CLMCLM-4126172026-07-31T08:21:00ZDiego—Marquez1993-02-10··-null—·8702 Valley View Drive Apt 34ColumbusOH43264GRP-8014CORE-HMO
TPATPA-551032026-10-08T17:38:07ZgabrielT.nguyen04/25/49N/ANULLUNKNOWN-5009 JEFFERSON AVENUE·Chandler·AZ—nullnull
ENRENR-1337952026-01-14T13:56:17ZLUIS—WILLIS1981-11-19UHC-03152-84•••-••-02574072630254··LUIS.WILLIS@AOL.COM8903 Desert Sky Boulevard Apt 17DenverCO80210GRP-4230··MEDICARE-ADV-B
PRVPRV-276762026-04-08T16:53:32ZCarlos—Estrada··1969-05-14NULLnull8000987NULL4195 Ocean AvenueDenverColorado80281——
CLMCLM-4192292026-03-03T02:04:43ZVINCENT—REYES23-10-2006·NULL—UNKNOWN··NULL8555 PARK PLACEPlanoTX75016GRP-7587OPTIONS-PPO
PRVPRV-235032026-03-29T14:01:04ZLaura—Alvarado1944-03-03—-542-487-8919—1141 JEFFERSON AVEHouston··TX77096NULL—
ENRENR-1091912026-09-07T04:45:24Zjoyce—chen1986-05-01-—(638) 252-9071joyce.chen27@outlook.com9200 BASELINE ROADDenverCO80215GRP-8791MEDICARE-ADV-B
PRVPRV-264452026-10-04T17:29:49ZDiaz, Dennis——20050603——9303490223·N/A6178 OCEAN AVENUELAS VEGASNV89129NULL—
CLMCLM-4018512026-03-18T22:20:23ZJacob—HolmesnullN/A•••-••-1501N/A—9299 Apache BoulevardAustinTX78764GRP-0237MEDICARE-ADV-A
ENRENR-1171032026-05-06T22:35:14ZMichaelUGeorgeDec 10, 1997UHC9953598•••-••-4738(696) 921-8894michael.george@icloud.com499 Sunset BlvdLos AngelesCA·90091·GRP-3989CORE-HMO
ENRENR-1238392026-10-14T23:34:07ZJacobs, AbigailU····1955-11-22UHC-00074-37··•••-••-3804·+1 648 892 9693null670 Harbor BlvdMiamiFL33196GRP-0561MEDICARE-ADV-B
CLMCLM-4182902026-01-22T13:58:10ZLAURA—·CHAVEZ2006-02-02—•••-••-4664(832) 590-5377N/A1179 Lake View RdDenverCO·80251null·OPTIONS-PPO
ENRENR-1239982026-08-03T11:58:00ZTylerAOliver1951-05-20·UHC-51920-31-5600494tyler.oliver@aol.com7954 Market Street··SeattleWashington98173GRP-9512CHOICE-PLUS-PPO
TPATPA-507662026-06-18T21:07:20ZSofia—Hunt28-11-2008nullUNKNOWN—-7726 Lake View RdScottsdaleAZ85228nullOPTIONS-PPO
PRVPRV-201182026-02-22T00:15:07ZWilliamGBurton1961-71-04NULLN/A3908648015william.burton@proton.me7872 Main StreetNashvilleTN37224null—
CLMCLM-4128732026-02-21T18:49:22ZsharonVray2002-08-08UHC-31560-49•••-••-8513(404) 542-3475—nullN/A-—NULLNAVIGATE-HMO
TPATPA-550412026-01-22T22:07:26ZOlivia····Cooleman1967-06-19UHC8031312•••-••-2249-—1107 OAK STSan AntonioTX78250NULLCHOICE-PLUS-PPO
CLMCLM-4034932026-03-21T06:53:00Z·Maria—Burns03/19/78UNKNOWNUNKNOWN4253271MARIA.BURNS91@ICLOUD.COMNULL--NULLGRP-8401—
CLMCLM-4114352026-02-05T08:12:39ZAndrew—Edwards1957-06-19UHC-43496-82UNKNOWN4692488295null6231 Bayshore DriveGLENDALEAZ·nullNULLOPTIONS-PPO
CLMCLM-4110482026-09-18T11:59:30ZLauren—Scmhidt1972-01-17—•••-••-0745360-341-9548—4410 Lincoln WayHoustonTX77025GRP-6799··CORE-HMO
ENRENR-1385762026-01-27T15:09:26ZEmily—RobertsJul 11, 1955UHC-42496-47N/AN/AN/A6341 Meadow Lane··TucsonAZ85745GRP-4765OPTIONS-PPO
CLMCLM-4182432026-07-16T00:40:52Zbrenda—lung1958-12-20··UHC-69208-88—7212471223··brenda.long@gmail.com4604 Washington Street Apt 14GilbertAZ85287N/ACHOICE-PLUS-PPO
ENRENR-1202542026-01-07T17:41:13ZWilliam—·Ruiz12-01-1993UHC-14301-66UNKNOWN8393335773william.ruiz@outlook.com··8250 HIGHLAND AVEMinneapolisMN55478GRP-2005MEDICARE-ADV-B
TPATPA-577772026-07-27T19:06:21ZWatson, Sam··—·1993-05-12NULL•••-••-8359930-577-8331—7942 Pine DrSan AntonioTX78260UNKNOWNUNKNOWN
ENRENR-1314362026-09-09T09:40:43ZFox, Ruth··Z.—01-01-1997UHC-51091-44null·454.246.6460ruth.fox86@proton.me339 BASELINE ROADAUSTINTX78765GRP-8765MEDICARE-ADV-A
CLMCLM-4000732026-02-23T01:36:55ZValentinaDWarren11/17/59UHC-64240-81•••-••-6931——9049 Maple AvenueDallasTX75225-····
ENRENR-1145232026-08-20T18:33:19Zsandra—morgan·May 20, 1939·UHC-28897-69•••-••-8518+1 567 319 1559null1706 Palm DrDenverCO80287GRP-5035NAVIGATE-HMO··
CLMCLM-429806 2026-04-20T06:09:31Z·JESSICALHUNT·1981-40-27UHC-73352-65—·776-419-1539—3711 VALLEY VIEW DRIVEMIAMIFL33171GRP-8163MEDICARE-ADV-B··
TPATPA-554852026-04-29T20:48:05ZMarquez, Angela——2001-07-12UNKNOWN•••-••-0398+1 271 658 3170—6514 Harbor Boulevard·AUSTINTX78717-N/A
CLMCLM-4098362026-01-05T17:45:13ZRUSSELL—WAGNER25-09-1974—•••-••-4503+1 414 322 8396-1814 GRAND AVETampaFL33650-OPTIONS-PPO
TPATPA-624292026-08-22T15:46:07Z·Dylan—DayNov 15, 1946—•••-••-4999NULLUNKNOWN8287 Central AveGILBERTAZ85275nullCORE-HMO
TPATPA-516872026-04-25T23:16:32ZDennis—Pierce1953-02-24····•••-••-9760215.920.5000-6540 Harbor BlvdFresnoCA93791—··
CLMCLM-4062472026-03-27T07:16:31ZMartha—Rodriguez·1977-06-11UHC-02773-73—(824) 631-3228—3973 Washington StPHOENIXAZ85093-9876GRP-4456choice-plus-ppo
ENRENR-1405322026-04-04T21:59:42ZDANIELLE A—WELLCH1978-03-10UHC-57613-39•••-••-8223(778) 245-3061—2220 Willow CtTempeAZ85215GRP-3416OPTIONS-PPO
CLMCLM-4286792026-01-13T08:38:04ZMike—Rios23-08-1961UHC-88156-15•••-••-6578N/ANULL9120 LAKE VIEW ROAD··Los AngelesCalifornia90097··GRP-8146null
CLMCLM-4070372026-08-25T08:14:42ZIsabella··—Gomez02/04/1977UHC-25379-25-(899) 245-3642—2400 Willow CtAustinTexas78722··GRP-6433NAVIGATE-HMO··
ENR ENR-1411112026-09-01T04:10:55ZRonaldNMejia··1982-05-13UHC-76212-96•••-••-5447274.565.6463·RONALD.MEJIA@AOL.COM2707 Church St·San DiegoCA92103··GRP-7397NAVIGATE-HMO
ENR ENR-1138072026-09-11T06:57:55ZLUCIAH··WATSON1976-09-28UHC-44470-52null(532) 676-3495lucia.watson@outlook.com2545 Oak StreetTempeArizona85265GRP-6683CHOICE-PLUS-PPO
ENRENR-1314172026-08-16T07:22:31ZJuliaQFields1997-05-09UHC-96692-70•••-••-9083939-784-3698·julia.fields44@aol.com3238 Hillcrest RoadSAN DIEGOCA92130GRP-5361CHOICE-PLUS-PPO
PRVPRV-291272026-08-20T20:25:10ZDIEGO—COLLINS2006-12-06N/A—7065794686DIEGO.COLLINS@PROTON.ME1389 Lincoln WayPlanoTX75034UNKNOWNUNKNOWN
100,000 rows, page 198 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.721Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty