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: Private Service Providing in Hawaii (DISCONTINUED) Series ID: SMU15000000800000003SA 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 5:02 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/SMU15000000800000003). 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/SMU15000000800000003) 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/SMU15000000800000003). 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 19.700172400647500 2007-02-01 19.303226761147602 2007-03-01 19.672607953197900 2007-04-01 19.735682946439700 2007-05-01 19.752501585759102 2007-06-01 19.755090940091400 2007-07-01 19.775157201526000 2007-08-01 19.665904823637398 2007-09-01 19.694731282874500 2007-10-01 19.692625372840500 2007-11-01 19.540389014150100 2007-12-01 19.936230616638802 2008-01-01 19.202706911685897 2008-02-01 19.189706566812898 2008-03-01 19.289805886846600 2008-04-01 19.584595284576900 2008-05-01 19.598054731574500 2008-06-01 19.673627788257800 2008-07-01 19.619583724209896 2008-08-01 19.737861223860600 2008-09-01 19.734525748404800 2008-10-01 19.913934613162000 2008-11-01 19.966608999603398 2008-12-01 19.878817696475200 2009-01-01 19.849488811476500 2009-02-01 20.015916174260800 2009-03-01 19.983533903052800 2009-04-01 19.872324773258200 2009-05-01 19.827469343712200 2009-06-01 19.985228068245803 2009-07-01 20.035760014809200 2009-08-01 20.126492507003697 2009-09-01 20.206540666605800 2009-10-01 20.173364772134303 2009-11-01 20.425440113420800 2009-12-01 20.352517214661102 2010-01-01 20.312139155802000 2010-02-01 20.382799070727803 2010-03-01 20.405737221473398 2010-04-01 20.373746903202800 2010-05-01 20.445602077274500 2010-06-01 20.464018666687800 2010-07-01 20.699661977577900 2010-08-01 20.987613060961102 2010-09-01 20.931667041287398 2010-10-01 21.045742221426700 2010-11-01 20.928611926793300 2010-12-01 21.157017999904300 2011-01-01 21.600608738810898 2011-02-01 21.287400043309200 2011-03-01 21.191585793163800 2011-04-01 21.227574435617200 2011-05-01 21.390359745988700 2011-06-01 21.336474525380897 2011-07-01 21.281685443057302 2011-08-01 21.185446157858898 2011-09-01 21.012873951103000 2011-10-01 21.295827522636500 2011-11-01 21.277574625193800 2011-12-01 21.337727398704000 2012-01-01 21.532368172703700 2012-02-01 21.418130485438400 2012-03-01 21.667523413079400 2012-04-01 21.684007146581997 2012-05-01 21.500006314095103 2012-06-01 21.731156898689104 2012-07-01 22.235574547180900 2012-08-01 22.033574079502802 2012-09-01 22.199921264242600 2012-10-01 22.089177205122600 2012-11-01 22.146326822230602 2012-12-01 22.357029645091000 2013-01-01 22.517973924620900 2013-02-01 22.646068767043200 2013-03-01 22.826722016241900 2013-04-01 23.048778770231700 2013-05-01 23.043479068584500 2013-06-01 23.050893518159800 2013-07-01 22.952391698259696 2013-08-01 22.897113054782000 2013-09-01 22.964473642122304 2013-10-01 23.009962378448200 2013-11-01 23.071569612960502 2013-12-01 23.127289277193498 2014-01-01 23.119064194247304 2014-02-01 23.143825045079000 2014-03-01 23.228518971709104 2014-04-01 23.179029439755897 2014-05-01 23.294969485016900 2014-06-01 23.511887782809400 2014-07-01 23.512799531935500 2014-08-01 23.582961745174103 2014-09-01 23.486874469119300 2014-10-01 23.655850202210400 2014-11-01 23.710862564029604 2014-12-01 23.373671228468500 2015-01-01 23.460338086647600 2015-02-01 23.650743875242800 2015-03-01 23.620391960396198 2015-04-01 23.520518009317900 2015-05-01 23.556717222613603 2015-06-01 23.527369276993000 2015-07-01 23.553281051788698 2015-08-01 23.676163110859605 2015-09-01 23.508825127248603 2015-10-01 23.702670631311804 2015-11-01 23.986413162099600 2015-12-01 24.008763083585897 2016-01-01 24.072502885300604 2016-02-01 24.267966716416602 2016-03-01 24.215420415201997 2016-04-01 24.268838802045998 2016-05-01 24.473669043265200 2016-06-01 24.507920185975000 2016-07-01 24.534891107366300 2016-08-01 24.454542558518895 2016-09-01 24.694494852066804 2016-10-01 24.634851404463802 2016-11-01 24.552942991436300 2016-12-01 24.530408178509497 2017-01-01 24.703390659351395 2017-02-01 24.645217675790000 2017-03-01 24.735072315175700 2017-04-01 24.876838275877400 2017-05-01 24.934455868573800 2017-06-01 24.944326381062197 2017-07-01 25.190067633500900 2017-08-01 25.466222634066302 2017-09-01 25.440027969869103 2017-10-01 25.825638576992997 2017-11-01 25.687059049440197 2017-12-01 25.961286943909396 2018-01-01 26.344758393842103 2018-02-01 26.163998425465998 2018-03-01 26.406841543740600 2018-04-01 26.816796582019000 2018-05-01 26.563711681710400 2018-06-01 26.921044833998604 2018-07-01 26.979071154290300 2018-08-01 26.895877677997000 2018-09-01 26.990724154050998 2018-10-01 26.885198339492000 2018-11-01 27.033107875034105 2018-12-01 27.222451001279800 2019-01-01 26.811946996089002 2019-02-01 27.014911336725696 2019-03-01 27.051667820383000 2019-04-01 27.158170389850200 2019-05-01 27.652255216418300 2019-06-01 27.522446413150900 2019-07-01 27.805984984922800 2019-08-01 27.757909187797800 2019-09-01 27.988620735462900 2019-10-01 28.428029964027800 2019-11-01 28.192099407522896 2019-12-01 28.357893420678900 2020-01-01 28.382219221239200 2020-02-01 28.599261916895700 2020-03-01 28.502984044380998 2020-04-01 30.543524541194600 2020-05-01 30.202216832462803 2020-06-01 29.413543469614100 2020-07-01 30.210606821132803 2020-08-01 30.587171281839600 2020-09-01 30.757501620764398 2020-10-01 30.537396363962497 2020-11-01 30.784153032505998 2020-12-01 30.947492569200396 2021-01-01 31.025438311355400 2021-02-01 30.952353400772900 2021-03-01 31.333768840890897 2021-04-01 30.919805204876400 2021-05-01 32.155140903032695 2021-06-01 31.139162261347398 2021-07-01 31.110051067607102 2021-08-01 31.265846253925900 2021-09-01 30.642298445187800 2021-10-01 31.185816098864198 2021-11-01 31.500403343908000 2021-12-01 31.472883371554500 2022-01-01 31.941982866343700 2022-02-01 31.759091458689800 2022-03-01 31.436604780417700