NOTE: THIS DATA FILE WILL CHANGE! To improve accessibility of data for all users, we will convert this file from a text format to an html table by the end of June 2024. Title: Average Hourly Earnings of All Employees: Total Private in Kennewick-Richland, WA (MSA) (DISCONTINUED) Series ID: SMU53284200500000003SA Source: U.S. Bureau of Labor Statistics, Federal Reserve Bank of St. Louis Release: State and Metro Area Employment, Hours, and Earnings (Not a Press Release) Seasonal Adjustment: Seasonally Adjusted Frequency: Monthly Units: Dollars per Hour Date Range: 2007-01-01 to 2022-03-01 Last Updated: 2022-04-16 4:11 AM CDT Notes: This series is discontinued and will no longer be updated. The Federal Reserve Bank of St. Louis previously calculated this seasonally adjusted (SA) series based on the not seasonally adjusted (NSA) version available here (https://fred.stlouisfed.org/series/SMU53284200500000003). However, most of the earnings-related series do not have a significant seasonal component, so the values for both the SA and the NSA series are very similar. See the NSA series (https://fred.stlouisfed.org/series/SMU53284200500000003) for updated values. The Federal Reserve Bank of St. Louis previously used to seasonally adjust this series by using the 'statsmodels' library from Python with default parameter settings. The package uses the U.S. Bureau of the Census X-13ARIMA-SEATS Seasonal Adjustment Program. More information on the 'statsmodels' X-13ARIMA-SEATS package can be found here (https://www.statsmodels.org/dev/generated/statsmodels.tsa.x13.x13_arima_analysis.html). More information on X-13ARIMA-SEATS can be found here (https://www.census.gov/data/software/x13as.html). Many series include both seasonally adjusted (SA) and not seasonally adjusted (NSA) data. Occasionally, updates to the data will not include sufficient seasonal factors to trigger a seasonal adjustment. In these cases, the NSA series will be updated normally; but the SA series will also be updated with the NSA data. The NSA series can be located here here (https://fred.stlouisfed.org/series/SMU53284200500000003). Some seasonally adjusted series may exhibit negative values because they are created from a seasonal adjustment process regardless of the actual meaning or interpretation of the given indicator. DATE VALUE 2007-01-01 25.212052321968304 2007-02-01 23.756015387619500 2007-03-01 23.532144439295802 2007-04-01 23.712802644939398 2007-05-01 23.108802438923302 2007-06-01 23.317960190681700 2007-07-01 23.092439129921104 2007-08-01 23.277881725122800 2007-09-01 23.155714650994700 2007-10-01 25.423457776699100 2007-11-01 23.420257654809800 2007-12-01 24.008943189556497 2008-01-01 24.045779398995300 2008-02-01 23.863801847949098 2008-03-01 23.704158793209800 2008-04-01 23.932483659059702 2008-05-01 24.006609608454298 2008-06-01 24.087925099754802 2008-07-01 23.989219757768396 2008-08-01 24.387641065950000 2008-09-01 24.583268268905800 2008-10-01 23.481644535797702 2008-11-01 23.270109402695898 2008-12-01 22.545217262366300 2009-01-01 23.005105690286900 2009-02-01 23.625685548438300 2009-03-01 24.759696736756503 2009-04-01 24.282252277304600 2009-05-01 24.732212763519602 2009-06-01 24.706931587590603 2009-07-01 25.248038057182400 2009-08-01 24.602686035096397 2009-09-01 24.196163315208697 2009-10-01 25.781335598983198 2009-11-01 25.743462835958700 2009-12-01 25.324438661059900 2010-01-01 25.908913612365104 2010-02-01 25.703514627925202 2010-03-01 26.109364861641698 2010-04-01 25.325564199196800 2010-05-01 25.500025756245602 2010-06-01 25.495372052590998 2010-07-01 25.550427169019500 2010-08-01 25.771495273884100 2010-09-01 25.862252599897200 2010-10-01 25.728926377101104 2010-11-01 26.322863836506000 2010-12-01 26.553125387979698 2011-01-01 25.711842903755700 2011-02-01 26.478752318641100 2011-03-01 26.266343929301700 2011-04-01 26.526727611362900 2011-05-01 26.771535285734100 2011-06-01 26.703940201843900 2011-07-01 26.943290149362700 2011-08-01 26.951646811184100 2011-09-01 27.238806737102603 2011-10-01 27.069728249088600 2011-11-01 26.757335994886397 2011-12-01 27.093255462170898 2012-01-01 26.705914838167200 2012-02-01 26.764341857351198 2012-03-01 26.459020253770700 2012-04-01 26.676465143296500 2012-05-01 26.443369998734603 2012-06-01 26.424993489455600 2012-07-01 26.119050395119300 2012-08-01 25.849176867939700 2012-09-01 25.750774897487002 2012-10-01 25.742857819793500 2012-11-01 25.759437242431602 2012-12-01 25.388169027156202 2013-01-01 25.560501424991397 2013-02-01 25.652679659021200 2013-03-01 25.701228300504500 2013-04-01 25.596135712481900 2013-05-01 25.600502849986402 2013-06-01 25.711210731115198 2013-07-01 25.713980647074600 2013-08-01 26.098139597802400 2013-09-01 25.873732342064300 2013-10-01 25.948703965418400 2013-11-01 25.927678722534598 2013-12-01 25.781593009206900 2014-01-01 25.820309929147200 2014-02-01 25.320324096698400 2014-03-01 25.666703891164400 2014-04-01 25.604363527771802 2014-05-01 25.581745188418697 2014-06-01 25.714642948505200 2014-07-01 26.538901903971600 2014-08-01 26.579272188945900 2014-09-01 26.326609218607803 2014-10-01 26.467305796845398 2014-11-01 26.220578782122100 2014-12-01 26.336994703421396 2015-01-01 27.173265471864198 2015-02-01 27.267069389799400 2015-03-01 27.220633001162400 2015-04-01 27.442235883327605 2015-05-01 27.105776886724200 2015-06-01 27.290938069355400 2015-07-01 27.003018326787200 2015-08-01 26.970152397537200 2015-09-01 26.872536517046300 2015-10-01 27.475206329141002 2015-11-01 27.180672576890696 2015-12-01 27.249089972745700 2016-01-01 27.400522406071897 2016-02-01 27.391882978783897 2016-03-01 27.595435814343200 2016-04-01 27.728669579738200 2016-05-01 28.021657319498300 2016-06-01 28.276876068868500 2016-07-01 28.324866049088303 2016-08-01 27.900965725178200 2016-09-01 28.802484164647900 2016-10-01 28.862391075391603 2016-11-01 28.657575930494300 2016-12-01 28.845600930109896 2017-01-01 28.692756518333503 2017-02-01 28.657290391465500 2017-03-01 28.651345273978702 2017-04-01 28.545395177081400 2017-05-01 28.671037001700203 2017-06-01 28.387037874211500 2017-07-01 28.576119258983496 2017-08-01 28.776196358003800 2017-09-01 28.730165582929803 2017-10-01 28.991671812072102 2017-11-01 29.098494107685600 2017-12-01 29.188734131780400 2018-01-01 28.910807050142900 2018-02-01 29.087489483492604 2018-03-01 29.232020223275400 2018-04-01 29.911385274399200 2018-05-01 29.366643101232500 2018-06-01 29.229352011860900 2018-07-01 29.361290797238198 2018-08-01 29.066361258289800 2018-09-01 29.449640421615000 2018-10-01 28.810707349632600 2018-11-01 28.287341515487700 2018-12-01 28.913273129755800 2019-01-01 29.110068489206900 2019-02-01 29.141309505709400 2019-03-01 28.992536979963300 2019-04-01 28.634036893204900 2019-05-01 28.378145445810000 2019-06-01 28.542393225166002 2019-07-01 28.177630913767500 2019-08-01 28.373951838745800 2019-09-01 28.865269632914700 2019-10-01 28.783391846134897 2019-11-01 29.181549487965200 2019-12-01 29.246347142655200 2020-01-01 29.726944496354900 2020-02-01 29.891292972930003 2020-03-01 29.510806525669900 2020-04-01 31.115466906676602 2020-05-01 31.415708391099300 2020-06-01 31.574034682022700 2020-07-01 31.777536020121698 2020-08-01 31.872654632009700 2020-09-01 31.928445786276303 2020-10-01 32.010914956212900 2020-11-01 31.968813497655695 2020-12-01 32.803445554945400 2021-01-01 31.850341508775600 2021-02-01 31.926174331924600 2021-03-01 30.764998371475800 2021-04-01 31.571363673210897 2021-05-01 31.987321184800200 2021-06-01 32.020574471995800 2021-07-01 32.266450117786100 2021-08-01 32.448947191612700 2021-09-01 31.988108030900197 2021-10-01 32.220032019671900 2021-11-01 32.386755894254400 2021-12-01 31.871163930377500 2022-01-01 32.449476997098900 2022-02-01 32.338233434795605 2022-03-01 32.368472098714300