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-1203982026-06-15T09:01:55ZCatherineLLawrence1957-05-18UHC-09218-86•••-••-4867(370) 704-3729··catherine.lawrence30@aol.com9836 CANYON RDChandlerArizona85249GRP-0966MEDICARE-ADV-B
ENRENR-1038112026-08-13T01:11:00ZAishaRMorales1980-02-21··UHC-71586-40•••-••-6374·(639) 420-6082—6200 Baseline RoadMiami··FL33147GRP-5854MEDICARE-ADV-A··
ENRENR-1187082026-07-18T21:01:35ZJanice—Gonzales04/24/1978UHC-38433-28•••-••-5227912-584-1145janice.gonzales68@hotmail.com2651 Hillcrest RdEden PrairieMN55317GRP-7357OPTIONS-PPO
CLMCLM-4052922026-08-12T18:07:13ZALBERT—HALLMar 18, 1980UHC-77367-20null9763737258N/A2761 Forest AveChandlerAZ85231UNKNOWNN/A
ENRENR-1201752026-05-05T04:27:30ZBrittany—Kelley1943-09-13UHC-07098-28•••-••-8435318.976.2810—9482 MEADOW LNDALLASTX75224·GRP-0774MEDICARE-ADV-B
CLMCLM-4207312026-03-21T15:35:19ZAshley—Shaw26-09-1989UHC-49013-03•••-••-3929—N/A3813 Indian School RdHoustonTX77046GRP-0154UNKNOWN
ENRENR-1291132026-02-07T04:41:17ZKEVINVREYES1938-04-09··UHC-54672-04•••-••-73735716478007kevin.reyes34@proton.me·172 Sage CtSeattleWashingtonNULLGRP-9023SELECT-EPO
ENRENR-1005162026-07-26T07:45:21Z·REBECCAG.REED·1958-06-08UHC-81612-39•••-••-86157932157291rebecca.reed40@proton.me2410 Canyon RdAtlantaGA30360GRP-8722MEDICARE-ADV-A
CLMCLM-4325182026-02-21T21:07:29ZJoeL.Stevens7/16/1952NULLNULLN/A··UNKNOWN6977 Apache BoulevardSEATTLEWA98174GRP-4929SELECT-EPO
CLMCLM-4312522026-04-28T07:44:18ZBarbara—Cox1962-01-13UHC-93560-89•••-••-01384684654934barbara.cox12@outlook.com·1468 Hillcrest RoadCOLUMBUSOH43234··—null··
TPA TPA-600092026-06-03T16:00:03ZSHIRLEY—HUNTER1958-03-17UNKNOWNUNKNOWN834-466-2722shirley.hunter64@outlook.com4214 Spring StreetSan DiegoCA92173NULLNULL
ENRENR-1371982026-05-01T08:46:45ZChristianA.Mejia12/24/97··UHC-16395-85•••-••-70876169851UNKNOWN2684 RIDGE ROAD·Miami·FL33110GRP-6074options-ppo
TPATPA-635592026-08-13T23:15:55ZKatherine—Black1997-07-25—•••-••-8075(232) 267-7319····45 Palm DriveTUCSONAZ85765null—
TPATPA-532652026-08-31T02:17:09ZVincent—Meyer2005-07-25N/A··——7588 CAMELBACK ROADDallasTX75251GRP-3339OPTIONS-PPO
ENRENR-1312992026-10-18T10:38:55ZCynthiaW.Harper2005-02-15UHC-74116-62•••-••-36352359978660cynthia.harper36@hotmail.com2423 GRAND AVENUETucson·AZ85790GRP-3937SELECT-EPO
CLMCLM-4005592026-06-01T19:52:06ZMateo··—Espinoza03/21/1979—•••-••-65017177346822—2755 CENTRAL AVENUEAUSTIN·TXnullGRP-9574-
PRVPRV-234792026-05-23T00:40:19ZJULIEJWILSON1020-19-09UHC7638141-(285) 947-6131UNKNOWN9127 Pine Dr #522COLUMBUSOhio43249N/A—
CLMCLM-4188562026-08-17T09:08:41ZKYLEO.BRYANT16-09-1976UHC-45658-55UNKNOWNN/A—3140 Ocean AvenueNASHVILLETN37281GRP-1755—
TPATPA-601762026-07-10T04:51:45Z·Ryan—Soto2002-11-11-UNKNOWN—RYAN.SOTO48@YAHOO.COM8891 Union Street #361TEMPEArizona85233—··
ENRENR-1172832026-03-21T22:58:32ZSamuel··QLynch19811212UHC-18157-27•••-••-7876(730) 634-4799samuel.lynch7@hotmail.com··689 Market StPlanoTXN/AGRP-6261CORE-HMO
PRVPRV-287632026-04-27T22:36:23ZAisha··H.King··1981-07-14UHC-01605-28—(460) 433-4400aisha.king@icloud.com2857 LINCOLN WAY·CHANDLERAZ85208NULLnull
CLMCLM-4187142026-03-06T05:19:42ZSmmith, AustinS.—2007-09-13UHC-95971-84•••-••-1072NULL—8639 Lincoln WayJacksonvilleFL32272-2071NULLMEDICARE-ADV-B··
CLMCLM-4001282026-08-22T21:00:25Zwilliam—den1981-02-50UHC-57472-02NULL(220) 690-1779N/A8983 SPRING STREETAustinTXnullGRP-2294····
CLMCLM-4143842026-06-17T06:39:54ZDOUGLAS—MENDEZDec 11, 1947-··•••-••-5864NULL—5921 WASHINGTON STREET·MiamiFlorida·33188GRP-9992NAVIGATE-HMO
ENRENR-1149692026-07-31T06:42:22ZnicoleTjenkins1998-04-22uhc-34083-24•••-••-03082798056924—1519 Lake View RoadFresnoCA93765GRP-4700MEDICARE-ADV-A
CLMCLM-4193512026-06-10T10:27:23ZMARILYN—RAY1980-11-13UNKNOWNNULLUNKNOWN-··6694 Sage CtCharlotteNC28294GRP-5388N/A
CLMCLM-4048272026-01-23T10:39:41ZROBERTS.DUNN20-07-1951UHC-95326-41··•••-••-5031398-755-3995——UNKNOWNN/A—UNKNOWNMEDICARE-ADV-A
ENRENR-1189392026-08-08T03:44:40ZMarilyn—Rios1944-05-19UHC-47927-41•••-••-27378242082229NULL911 Lincoln WayCharlotteNC28244GRP-7588MEDICARE-ADV-B
ENRENR-1313072026-04-14T21:05:22ZAARON··HHILL··1953-01-22UHC4351539•••-••-8930·920-476-1283—6660 Willow Ct #850NashvilleTennessee37256GRP-7967MEDICARE-ADV-A
ENRENR-1301712026-06-30T17:05:05ZHughes—Kathleen1949-12-20UHC-40860-30•••-••-5685—KATHLEEN.HUGHES@HOTMAIL.COM5289 Oak StPhoenixAZ85065GRP-5600MEDICARE-ADV-B
ENRENR-1066762026-07-23T16:45:33ZMADISONVHAWKINS·01/09/87UHC-63822-79•••-••-209613995150164madison.hawkins90@outlook.com8810 Lake View RoadMinneapolisMN55465··GRP-4252CHOICE-PLUS-PPO
ENRENR-1029432026-09-02T10:37:39ZEspinozaP.Amber1948-01-22UHC-65231-24•••-••-0946+1 700 307 0359—9369 Valley View DrColumbus·OH43256GRP-2881NAVIGATE-HMO
ENRENR-1208182026-08-27T12:55:21ZMegan—Ortiz08-11-1971UHC-52814-98•••-••-89484920561megan.ortiz@icloud.com3042 Palm DriveColumbusOH43202GRP-8420CHOICE-PLUS-PPO
TPATPA-627752026-04-24T19:04:26ZSUSANZBARNES1999-01-17NULL—2894137118-9887 LINCOLN WAYSeattleWA98149GRP-2443UNKNOWN
CLMCLM-4079672026-08-19T06:56:47ZEvelyn—Perry1955-01-16·UNKNOWNNULL7919756841····4210 RIDGE ROADFresnoCA93734——
ENRENR-1097702026-05-22T20:53:56ZGregoryZ.Garza1945-11-10UHC-70838-33•••-••-82314855695569GREGORY.GARZA@GMAIL.COM8645 OCEAN AVENUEMinneapolisMN55415GRP-3438··SELECT-EPO
ENRENR-1104992026-01-13T09:00:11ZGregoryMWarren1964-07-25UHC-08947-69•••-••-20269863403180··1904 Highland AvePlanoTexas75062GRP-5096MEDICARE-ADV-A
ENRENR-1043742026-08-17T21:25:27ZWALTER—FOSTER1966-03-23UHC-55074-38··•••-••-7417290.430.2546-··5433 Cedar LaneDallasTX75292GRP-0201SELECT-EPO
CLMCLM-4218072026-04-13T00:04:53ZWayneBLee·01/02/1949UHC-57483-83—N/AN/A—NULLN/A——N/A
ENRENR-1036282026-07-18T10:17:10ZSusanO.Gordon4005-19-43UHC-93650-18•••-••-4977803-704-8107susan.gordon65@hotmail.com7719 JEFFERSON AVENUECOLUMBUSOH43260GRP-9658SELECT-EPO
ENRENR-1172812026-03-23T20:55:14ZBenjaminWHawkins··1950-01-05UHC-71370-31N/A15662764780··benjamin.hawkins87@proton.me4245 Hillcrest RdColumbusOhio43230-0091GRP-0325SELECT-EPO
ENRENR-1430712026-04-23T02:27:26ZRoger—Fowler09/05/98UHC1702981•••-••-6229+1 532 388 5024—6457 Grand AveLas VegasNV89106GRP-1885NAVIGATE-HMO
TPATPA-512972026-04-23T07:01:02ZBrittany—Kim1958-12-16—•••-••-2714NULLN/A6440 Central AveHoustonTX77010-9070GRP-2039·UNKNOWN
CLMCLM-4130132026-05-11T21:23:06ZRoger—Holmes··1977-08-03--—NULL289 Grand Avenue·Los AngelesCA·90087GRP-5468NAVIGATE-HMO
CLMCLM-4104052026-01-10T11:46:24ZDEBORAH—SMITH·1955-02-11—•••-••-940514476415070null805 Market StreetPlanoTX75081N/A-
ENRENR-1277642026-06-11T07:29:15ZRandy—Alvarado2000-02-01UHC-90506-58•••-••-7318693-392-1305randy.alvarado@hotmail.com5022 Sunset BlvdOrlandoFL32830GRP-6414·MEDICARE-ADV-A
ENRENR-1250962026-10-14T06:38:49ZDEBRAS.COLEMAN··1946-01-26UHC-23801-02NULLnullN/A9237 WASHINGTON STREET·MiamiFlorida33147GRP-1922OPTIONS-PPO
ENRENR-1402332026-09-28T23:59:51ZMaldonado, ShirleyZ··—6/13/2004UHC-32226-51—UNKNOWNSHIRLEY.MALDONADO2@OUTLOOK.COM7306 MESA DRIVETampa··FL33666GRP-3688SELECT-EPO
ENRENR-115838 2026-01-08T19:15:55ZGraceZ.··Hughes1963-06-21UHC-49736-31•••-••-5447(872) 346-4236NULL2697 Cedar LaneHoustonTX77036GRP-4105SELECT-EPO
PRVPRV-235362026-02-11T05:46:42ZDiegoL··Carroll·1953-07-05UHC-04213-88•••-••-19029617760210DIEGO.CARROLL65@PROTON.MENULLnullnullN/A—-
100,000 rows, page 251 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:37.750Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty