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: Professional and Business Services in Iowa (DISCONTINUED) Series ID: SMU19000006000000003SA 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/SMU19000006000000003). 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/SMU19000006000000003) 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/SMU19000006000000003). 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 21.318048968079697 2007-02-01 21.106406004085000 2007-03-01 20.822062097001602 2007-04-01 20.738928191061397 2007-05-01 20.391714246193000 2007-06-01 21.951916429065300 2007-07-01 20.526789282582100 2007-08-01 20.198908604153800 2007-09-01 20.202256212581300 2007-10-01 19.998064226499200 2007-11-01 19.652620893043900 2007-12-01 19.804814120850400 2008-01-01 19.621823737157500 2008-02-01 19.665923547372700 2008-03-01 20.106078636505302 2008-04-01 20.668103183348100 2008-05-01 20.434435019347700 2008-06-01 21.879081879708000 2008-07-01 20.563638881522000 2008-08-01 23.381515383377600 2008-09-01 21.763633275651603 2008-10-01 21.420046751032398 2008-11-01 23.007245702483697 2008-12-01 22.194667643747600 2009-01-01 23.276558230109600 2009-02-01 23.597323754316303 2009-03-01 21.604543193442396 2009-04-01 21.160984741421700 2009-05-01 22.546264581860400 2009-06-01 21.885427163210398 2009-07-01 21.935035626790200 2009-08-01 22.161131730240697 2009-09-01 21.715795744359397 2009-10-01 21.381878080341200 2009-11-01 21.557936845198604 2009-12-01 21.383869847000398 2010-01-01 21.116359886669800 2010-02-01 21.004025913272300 2010-03-01 20.334158507901300 2010-04-01 21.159881223838500 2010-05-01 21.596906306779400 2010-06-01 21.377951643507200 2010-07-01 21.266604027093700 2010-08-01 21.442554621564900 2010-09-01 21.675505046876502 2010-10-01 22.099461921157697 2010-11-01 21.906829701067700 2010-12-01 21.993495892256604 2011-01-01 21.971515614580603 2011-02-01 22.064631742058200 2011-03-01 21.599937433815800 2011-04-01 21.259191698720397 2011-05-01 21.484912183036105 2011-06-01 21.059570615341197 2011-07-01 21.454286853777300 2011-08-01 21.117358279178802 2011-09-01 21.037033183767600 2011-10-01 21.358331569165500 2011-11-01 20.861672274438200 2011-12-01 20.836277144111303 2012-01-01 21.435568622591600 2012-02-01 20.842944931927400 2012-03-01 20.762327219517502 2012-04-01 20.745630182870800 2012-05-01 20.566382322471100 2012-06-01 20.212234949037800 2012-07-01 20.345239438842302 2012-08-01 20.218411109448700 2012-09-01 20.339844841123398 2012-10-01 20.251391921977200 2012-11-01 20.326805933067900 2012-12-01 20.522197475547000 2013-01-01 20.894074011144898 2013-02-01 20.779612282794300 2013-03-01 21.087706812317300 2013-04-01 21.475698496447300 2013-05-01 21.130244898704300 2013-06-01 21.612174169753200 2013-07-01 21.822402138714104 2013-08-01 22.050973337411400 2013-09-01 22.236463544516300 2013-10-01 22.208219863469502 2013-11-01 22.382959268728200 2013-12-01 22.656411496364196 2014-01-01 22.757329875825402 2014-02-01 22.888984732187100 2014-03-01 23.239401103157395 2014-04-01 22.759381472148000 2014-05-01 22.568276758266100 2014-06-01 23.160078169910100 2014-07-01 22.732008275137200 2014-08-01 22.758744140660000 2014-09-01 22.918203754535497 2014-10-01 22.640078579372002 2014-11-01 23.290837441773300 2014-12-01 22.894639978374000 2015-01-01 22.999388095937100 2015-02-01 23.525520324564802 2015-03-01 23.424817990608800 2015-04-01 23.139782881572800 2015-05-01 23.730121599457302 2015-06-01 23.900347762645197 2015-07-01 24.040488014193300 2015-08-01 24.490837692128600 2015-09-01 24.449553146150397 2015-10-01 24.539162608025400 2015-11-01 24.734081131566402 2015-12-01 24.317328143105100 2016-01-01 24.616305974077700 2016-02-01 24.613791209899300 2016-03-01 24.679466274778800 2016-04-01 24.783208993241000 2016-05-01 25.162383565034197 2016-06-01 25.209984753939000 2016-07-01 25.365856653848702 2016-08-01 25.025542042419602 2016-09-01 24.924903777368400 2016-10-01 25.462902987088600 2016-11-01 25.433697788447000 2016-12-01 25.655089675156700 2017-01-01 25.066215253475400 2017-02-01 25.025649437577602 2017-03-01 25.358487277628104 2017-04-01 25.668752302078100 2017-05-01 25.763181292535300 2017-06-01 25.747023478202300 2017-07-01 25.855877764320198 2017-08-01 25.640435642032000 2017-09-01 25.608746875170800 2017-10-01 26.057357822576900 2017-11-01 25.706594565133900 2017-12-01 26.247720378256396 2018-01-01 25.980882986808700 2018-02-01 25.670042454667698 2018-03-01 25.847240974017300 2018-04-01 25.843625294728200 2018-05-01 25.732753544195700 2018-06-01 25.699919561980300 2018-07-01 25.792466069623000 2018-08-01 25.871349657365700 2018-09-01 25.882113948019000 2018-10-01 25.492326027142703 2018-11-01 25.271326121382497 2018-12-01 25.748615534038898 2019-01-01 25.740982972895498 2019-02-01 26.057354581229703 2019-03-01 25.984269786284198 2019-04-01 25.879064468240900 2019-05-01 25.970099374007603 2019-06-01 26.368298004701902 2019-07-01 26.048669237434698 2019-08-01 25.959135990547200 2019-09-01 26.782715588276400 2019-10-01 26.499022714706000 2019-11-01 26.560551794869800 2019-12-01 26.059569505656400 2020-01-01 26.410617213010500 2020-02-01 26.495478644722000 2020-03-01 26.420513105048197 2020-04-01 26.876525133804396 2020-05-01 26.770652650561498 2020-06-01 26.356239030148500 2020-07-01 26.174016368496500 2020-08-01 26.261327484786200 2020-09-01 26.441763434676800 2020-10-01 25.796861641292402 2020-11-01 26.638468052238196 2020-12-01 26.445951352558400 2021-01-01 26.714460394743400 2021-02-01 26.447833123294600 2021-03-01 26.397302087421302 2021-04-01 25.860625316829900 2021-05-01 26.287969079430000 2021-06-01 26.295939678312003 2021-07-01 26.811251677132503 2021-08-01 26.994935550096198 2021-09-01 26.796527413364600 2021-10-01 26.989131634109600 2021-11-01 27.160150955578900 2021-12-01 27.453760139857000 2022-01-01 28.698599035638800 2022-02-01 28.270717352034303 2022-03-01 28.390557656262900