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: Leisure and Hospitality in Iowa (DISCONTINUED) Series ID: SMU19000007000000003SA 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:56 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/SMU19000007000000003). 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/SMU19000007000000003) 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/SMU19000007000000003). 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 10.547162078541900 2007-02-01 10.840887344920200 2007-03-01 10.907828985293500 2007-04-01 10.905701964385700 2007-05-01 10.819493690846500 2007-06-01 10.800189293894999 2007-07-01 11.135614229240500 2007-08-01 10.836870158581300 2007-09-01 11.070570607234800 2007-10-01 11.279659465441698 2007-11-01 11.145443586418299 2007-12-01 11.122063958472301 2008-01-01 11.232578694475200 2008-02-01 11.237611999323500 2008-03-01 11.208812151511399 2008-04-01 11.153050756818900 2008-05-01 11.210496928766998 2008-06-01 11.194490558424098 2008-07-01 11.293854187325900 2008-08-01 11.364056822300999 2008-09-01 11.404915804870301 2008-10-01 11.494055936064100 2008-11-01 11.511373213636300 2008-12-01 11.628878132066697 2009-01-01 11.629326309362801 2009-02-01 11.606689831793000 2009-03-01 11.682483403747199 2009-04-01 11.792814101225300 2009-05-01 11.784689444619698 2009-06-01 11.864969908080099 2009-07-01 11.800852334512902 2009-08-01 11.879309411090698 2009-09-01 11.958545645906902 2009-10-01 11.955723645290000 2009-11-01 11.960145147816801 2009-12-01 12.026917602871300 2010-01-01 12.150972536838902 2010-02-01 12.036770728715197 2010-03-01 11.938813846263699 2010-04-01 11.846155748770599 2010-05-01 11.906181934494100 2010-06-01 11.845522623058500 2010-07-01 11.917113173989598 2010-08-01 11.790766104345801 2010-09-01 11.696514656269901 2010-10-01 11.592357314217901 2010-11-01 11.542537192069199 2010-12-01 11.476323509288301 2011-01-01 11.529555561467900 2011-02-01 11.573144170085198 2011-03-01 11.661598922418198 2011-04-01 11.716069116896698 2011-05-01 11.774388080325199 2011-06-01 11.821133236896400 2011-07-01 12.045211030911900 2011-08-01 11.765936187955502 2011-09-01 11.742212627951000 2011-10-01 11.654139334460599 2011-11-01 11.754973277542600 2011-12-01 11.682484539630599 2012-01-01 11.723643567521200 2012-02-01 11.817555003775000 2012-03-01 11.848171706996501 2012-04-01 11.919822266338501 2012-05-01 11.957594064331401 2012-06-01 11.887696199346001 2012-07-01 11.963277732925000 2012-08-01 11.961203126985500 2012-09-01 12.025191602906402 2012-10-01 12.305859178208499 2012-11-01 12.300824276556801 2012-12-01 12.359890462409599 2013-01-01 12.296225894476900 2013-02-01 12.172791643182400 2013-03-01 12.237987715464499 2013-04-01 12.217511048295300 2013-05-01 12.187619557230802 2013-06-01 12.230450919142699 2013-07-01 12.253782723756800 2013-08-01 12.364327868460900 2013-09-01 12.297291387765501 2013-10-01 12.370751074787000 2013-11-01 12.354824992308500 2013-12-01 12.400470505794100 2014-01-01 12.386254737991400 2014-02-01 12.465189027357098 2014-03-01 12.398521481458600 2014-04-01 12.425534347119902 2014-05-01 12.371294988792300 2014-06-01 12.546102395529600 2014-07-01 12.350305565129400 2014-08-01 12.346721159169100 2014-09-01 12.428424876124700 2014-10-01 12.353255556970598 2014-11-01 12.309775400469999 2014-12-01 12.413531073706698 2015-01-01 12.567739263388300 2015-02-01 12.427444515745302 2015-03-01 12.257794177109599 2015-04-01 12.365625370487098 2015-05-01 12.474172246683200 2015-06-01 12.491414497249100 2015-07-01 12.469059605885400 2015-08-01 12.714552397002200 2015-09-01 12.496884211677802 2015-10-01 12.578287819770400 2015-11-01 12.726321461139099 2015-12-01 12.673348647041200 2016-01-01 12.656720880611800 2016-02-01 12.651992824905800 2016-03-01 12.698711761064600 2016-04-01 12.884257756662299 2016-05-01 12.796763747764000 2016-06-01 12.805558798401300 2016-07-01 12.873472477697199 2016-08-01 12.722516153177200 2016-09-01 12.864732173111200 2016-10-01 12.849141325583599 2016-11-01 12.792414082683100 2016-12-01 12.819241285348700 2017-01-01 12.621169008678802 2017-02-01 12.827498853576698 2017-03-01 12.852752678014900 2017-04-01 12.744221354653499 2017-05-01 12.864040984049700 2017-06-01 12.816796997002900 2017-07-01 13.025228553425501 2017-08-01 13.024974207330900 2017-09-01 13.050038420687098 2017-10-01 13.029189054034200 2017-11-01 13.094669747311500 2017-12-01 13.062871572765000 2018-01-01 13.332754580300500 2018-02-01 13.271959164673500 2018-03-01 13.428747163972002 2018-04-01 13.437876671721499 2018-05-01 13.472224149647100 2018-06-01 13.607583604892400 2018-07-01 13.589880164801800 2018-08-01 13.674257765204699 2018-09-01 13.790653311291900 2018-10-01 13.865582882551000 2018-11-01 13.866100496742801 2018-12-01 13.865520444543900 2019-01-01 13.992656941389100 2019-02-01 14.092678536861902 2019-03-01 14.076390904727200 2019-04-01 14.123033346441900 2019-05-01 14.167147819415300 2019-06-01 14.098786596516600 2019-07-01 14.136131145236600 2019-08-01 14.223295029241700 2019-09-01 14.119299601293699 2019-10-01 14.214084438493000 2019-11-01 14.180372726823200 2019-12-01 14.209180398111501 2020-01-01 14.171541457065500 2020-02-01 14.033505440033500 2020-03-01 14.301647771138600 2020-04-01 15.404730960640500 2020-05-01 14.832124113076400 2020-06-01 14.604573015694600 2020-07-01 14.547659914661400 2020-08-01 14.668076959380400 2020-09-01 14.722898552637100 2020-10-01 14.833912575119600 2020-11-01 15.068682249422700 2020-12-01 15.278768886578600 2021-01-01 15.203355196619198 2021-02-01 15.315902690616200 2021-03-01 15.253968302252801 2021-04-01 15.353942716837402 2021-05-01 15.569479463356400 2021-06-01 15.999409626468502 2021-07-01 16.060078722407600 2021-08-01 16.220017908994500 2021-09-01 16.580269738734300 2021-10-01 16.623420717399900 2021-11-01 16.801137643671900 2021-12-01 17.100857359336500 2022-01-01 17.359150822500400 2022-02-01 17.490638545968400 2022-03-01 17.979361779944803