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-1229642026-03-08T01:56:49ZDonnaA.Evans··1960-11-01UHC-46623-02•••-••-747415206216393-4193 Forest AveDenverCO···80216GRP-2946NAVIGATE-HMO
CLMCLM-4221902026-06-04T16:47:09Ztimothy—harris19600808UHC-02413-69•••-••-4461—-1631 Lincoln WayLos Angelesca90003UNKNOWNNAVIGATE-HMO
TPATPA-516052026-02-28T18:34:08ZVICTORIA—MOORE2003-01-28—··4370809null-·-NULLN/AUNKNOWN—
ENRENR-1201452026-04-07T14:59:58Z·Albrt—Knigth07-08-1994UHC-52355-58•••-••-2456null—6424 Mesa DrTempeAZ85229-0572GRP-7233·CHOICE-PLUS-PPO
ENRENR-1375272026-09-04T01:54:15ZWayneD.Dunn·Sep 20, 1981UHC-76545-20-454.671.3779wayne.dunn88@icloud.com2552 Willow CtSacramentoCalifornia95878-8113GRP-4348NAVIGATE-HMO
TPATPA-600222026-04-10T07:56:04ZTerry··Wlsh19610719—•••-••-60328695095746-NULLUNKNOWN—-—N/A
ENRENR-106674 2026-04-22T13:16:14ZHANNAHLANDREWS··1966-05-25UHC-23068-61•••-••-6217897.589.5438HANNAH.ANDREWS46@GMAIL.COM8163 Bayshore DrOrlandoFLN/AGRP-9204OPTIONS-PPO
ENR ENR-1228312026-09-05T11:05:53ZKathyLWeber19-04-1983UHC-61537-64•••-••-8001(966) 790-7447—6853 Lake View RoadSan Antoniotx78232-0172GRP-6044CHOICE-PLUS-PPO
ENRENR-1143772026-05-31T01:13:08ZBillyPPeterson·1954-11-28UHC-29755-09•••-••-0388802-283-7389billy.peterson@yahoo.com5137 Harbor Blvd Apt 3AtlantaGA30326·GRP-6593NAVIGATE-HMO
PRVPRV-216982026-07-18T01:14:13ZOMAR—·WOOD1986-11-02UHC-49107-09null678.769.1835null5185 Pine DriveLas Vegas··NV·89146UNKNOWNN/A
CLMCLM-4191662026-07-21T09:56:27ZAlbert—Carr1966-02-09UHC-81559-93—·NULL—·-NULLN/A··nullNULLOPTIONS-PPO
ENRENR-1200472026-03-30T10:27:23ZElijah—Hansen06/28/66UHC-64874-13•••-••-7404(563) 929-4848elijah.hansen6@aol.com6700 Jefferson Ave #240PhoenixAZ85037GRP-2950MEDICARE-ADV-B
ENRENR-1127012026-02-03T23:23:59ZGerald—Nichols02-12-1956·UHC-10049-27•••-••-0336225-272-2408NULL592 BroadwayLOS ANGELESCA90092GRP-6034NAVIGATE-HMO
CLMCLM-4075242026-07-09T06:08:06ZKELLY—NUNEZ1969-07-08UHC-71535-19N/A—NULL2972 WASHINGTON STREETPHOENIXAZ85025GRP-2423OPTIONS-PPO
CLMCLM-4312152026-04-05T22:22:10ZSophia—Daniels5/6/1983——UNKNOWNNULL9788 JEFFERSON AVEDenverColorado80275-6118GRP-3411OPTIONS-PPO
PRVPRV-252992026-10-02T15:18:14ZGregory—Taylor1975-03-06·UNKNOWN—878-953-4201N/A3415 Washington Street··GilbertAZ85212—UNKNOWN
CLMCLM-4015222026-04-12T08:21:13ZDenise··Peters1980-10-22null··•••-••-1272+1 841 469 4491—·9572 MESA DRIVESan AntonioTexas78291N/AMEDICARE-ADV-A··
CLMCLM-4172932026-09-17T23:31:44ZDEBRAC.MATTHEWSOct 28, 1973UNKNOWNNULL··—UNKNOWN3697 LAKE VIEW ROADCHANDLERAZ85267GRP-9695choice-plus-ppo
PRVPRV-245742026-09-10T07:11:32ZHart, Rebecca—··1962-03-15··UNKNOWN4442893304null2012 Jefferson Ave·DallasTX75284-1939-—
ENRENR-1141842026-10-11T07:31:22ZJordan··Z.Jones1952-02-01UHC-40973-44•••-••-6318-jordan.jones74@yahoo.com412 PARK PLTampaFL33688GRP-4534SELECT-EPO
TPATPA-583512026-03-05T18:19:53ZAndrews, Logan——1991-09-19—·-N/AUNKNOWN1378 Park PlTempeAZ85202——
TPATPA-563602026-09-08T23:24:34ZGEORGE—TORRES1964-05-20N/A•••-••-6914929.416.2649—4804 Market StMesaAZ85267GRP-8333UNKNOWN
ENR ENR-1107032026-05-19T04:46:22ZStephen—Peterson1943-06-12UHC-22151-31··•••-••-841415229834977stephen.peterson@aol.com6606 Jefferson Avenue Apt 1San AntonioTX·78242GRP-5851CHOICE-PLUS-PPO
CLMCLM-4088612026-10-02T23:40:20ZCheryl—Wallace2008-11-01UHC7578168····UNKNOWNUNKNOWN7965 Camelback RoadEden PrairieMN55323GRP-5560CHOICE-PLUS-PPO
ENRENR-1118692026-06-06T08:34:45ZWayneYArmstrong12/22/2005UHC-55770-22•••-••-6219527-998-3210··—1981 Mountain View DriveColumbusOH-GRP-6033SELECT-EPO
ENRENR-1269172026-07-09T06:54:19ZMorales, Alice·A.—09/03/1980··UHC-00679-59•••-••-5741762-931-7844alice.morales98@gmail.com431 Apache BlvdGilbertAZ85244-3358GRP-9131NAVIGATE-HMO
PRVPRV-293042026-09-05T02:50:42Z Russell—Rjas·1966-11-19-—·nullrussell.rojas11@outlook.com1584 Broadway Apt 17HoustonTX77069—null
PRVPRV-224082026-08-20T00:33:01ZANA··RICHARDS2001-02-07UHC5314166—3759208N/A841 Sage Court·GlendaleazUNKNOWNUNKNOWN··UNKNOWN
CLMCLM-4112132026-08-18T00:59:42ZTorres, StephanieZ···2006-11-14UHC-99975-09NULL-······3934 FOREST AVENUEMESAAZ85295NULLNULL
CLMCLM-4004262026-08-16T21:38:51ZChen, Jacqueline——08/07/97UHC-37309-92null··UNKNOWN—5143 Grand AvenueLos AngelesCA—GRP-4377SELECT-EPO
ENRENR-1019972026-07-27T21:52:37ZRalph F—Gonzalez19940316·UHC-28287-12•••-••-9869730.881.1916ralph.gonzalez73@aol.com7003 Jefferson AveLas VegasNV89189GRP-8501MEDICARE-ADV-A
TPATPA-634492026-06-13T20:37:02ZPhillips, Ralph——1983-08-09-———6178 PARK PLACE··AustinTX·78712UNKNOWN—
ENRENR-1274502026-08-07T20:04:05ZHENRYKHARPER6/23/1984UHC-81588-42•••-••-799519125791006HENRY.HARPER@AOL.COM8644 BroadwayFresnoCA93708GRP-2861CORE-HMO
PRVPRV-243472026-07-03T21:00:19Zchristine··garcia1960-03-06UNKNOWNNULL+1 393 442 4041CHRISTINE.GARCIA77@PROTON.ME2995 BROADWAYMINNEAPOLISMN55477·-—
ENRENR-1009332026-06-27T17:16:56Zdebra—·welch1958-05-02UHC-72784-39•••-••-101616323537484DEBRA.WELCH@YAHOO.COM7993 SPRING STSAN DIEGOCA92182GRP-2530CHOICE-PLUS-PPO
CLMCLM-4246562026-01-19T08:15:45ZFrank—Washington07/08/78UHC-91228-72-··N/A—-N/A——GRP-5992—
PRV PRV-222862026-03-11T23:41:47ZAMYOELLIOTT1950-07-18UHC-43246-58·N/A-null7041 Elm StreetPhoenixAZ85070NULL—
CLMCLM-4197812026-10-08T09:07:59ZChris—Meyer2004-02-28——517-883-8557—8041 Main StreetNashvilleTN37251··——
CLMCLM-4317322026-08-06T05:06:50Z·YUKI—WILLIAMSON2000-30-19UHC-67835-34··2598489270—4914 Sage CourtJacksonvilleFL32270GRP-5116NAVIGATE-HMO
ENRENR-1238482026-03-07T18:44:36ZAlexis··Ortega1967-10-25UNKNOWN•••-••-9617(572) 947-8817NULLNULL—null—GRP-1742CORE-HMO
ENRENR-1340542026-01-24T21:38:38ZDAVID··—POWELLDec 9, 1977UHC-52885-07•••-••-7008203-558-3675david.powell@icloud.com2066 Palm Drive·Miami·Florida33177GRP-8484··NAVIGATE-HMO
ENRENR-1283172026-05-20T16:58:35ZMeiJ.Mills19810618UHC-17607-31UNKNOWN211-918-4585mei.mills97@icloud.com··3240 Mountain View DrPhoenixAZUNKNOWNGRP-6040CORE-HMO
PRVPRV-254602026-01-28T23:26:54ZSanders, CamilaB—·07/23/03UHC-24398-42null·(307) 799-0541CAMILA.SANDERS@YAHOO.COM7123 CEDAR LNTampaFL··33648N/A—
TPATPA-537572026-09-11T19:14:32Zlarry—payne1969-07-14null—(648) 342-6301—2134 PINE DRIVESacramentoCA95849GRP-7825null
CLMCLM-4128242026-05-20T03:44:16ZGeorge—Padilla2002-10-05N/A•••-••-0407—-7600 Valley View DriveCharlotteNC28274GRP-9813MEDICARE-ADV-B
TPATPA-642942026-08-26T13:41:10ZALAN—ESTRADA19810101N/ANULL—null··7463 CANYON ROADDALLASTX-—null
ENRENR-1279012026-04-05T03:59:04Z·seanHwallaceOct 23, 1994·UHC-48266-32null+1 742 717 3751sean.wallace11@gmail.com3705 DESERT SKY BLVDSan AntonioTX78259·GRP-4904MEDICARE-ADV-A
CLMCLM-4208712026-04-27T05:58:27ZDONNA····COK1978-02-12—•••-••-3433879-870-8298—6772 Desert Sky BoulevardNashvilleTN37276GRP-4591—
ENRENR-1424442026-01-23T22:44:36ZKatyh C—Anderson1957-02-05UHC-30623-89•••-••-1098·494-287-5369—6950 River Rd Apt 35DallasTexas75298GRP-2236OPTIONS-PPO
ENRENR-1090452026-01-02T03:57:35ZJustin—GreeneMay 8, 1999UHC-79908-77•••-••-6370·-JUSTIN.GREENE@YAHOO.COM198 Harbor BlvdNashville·TN37241GRP-6868CHOICE-PLUS-PPO
100,000 rows, page 208 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.724Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty