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 Oakland-Hayward-Berkeley, CA (MD) (DISCONTINUED) Series ID: SMU06360840500000003SA 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:13 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/SMU06360840500000003). 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/SMU06360840500000003) 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/SMU06360840500000003). 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 27.928169532420500 2007-02-01 27.554093707618197 2007-03-01 27.301972854707103 2007-04-01 27.360763625517200 2007-05-01 27.675593952235698 2007-06-01 27.595350434057497 2007-07-01 27.612299924270300 2007-08-01 27.569176389129602 2007-09-01 27.662475818270998 2007-10-01 27.705358945413103 2007-11-01 27.843580973186600 2007-12-01 27.992353063895504 2008-01-01 27.717632862251100 2008-02-01 27.835714783587800 2008-03-01 28.246134357997700 2008-04-01 28.250011616064500 2008-05-01 28.249352890925497 2008-06-01 28.316256230739103 2008-07-01 28.209494563432300 2008-08-01 28.948266472784400 2008-09-01 29.010853701200600 2008-10-01 29.305655205667602 2008-11-01 29.551529752001700 2008-12-01 29.402526992206504 2009-01-01 29.467317513958804 2009-02-01 30.008181083575696 2009-03-01 29.599188162825600 2009-04-01 29.347236219635100 2009-05-01 29.109644719205498 2009-06-01 28.890382703511400 2009-07-01 29.446525641033602 2009-08-01 29.382846479882500 2009-09-01 29.362309153585702 2009-10-01 29.297086961247896 2009-11-01 29.216454186617998 2009-12-01 29.312562288220600 2010-01-01 29.401177185151600 2010-02-01 29.640343400198300 2010-03-01 29.527051400472104 2010-04-01 29.708924731407300 2010-05-01 29.726757430646000 2010-06-01 29.662286512433802 2010-07-01 29.534355176151000 2010-08-01 29.927800695886898 2010-09-01 29.647644246680798 2010-10-01 29.531953613179800 2010-11-01 29.621791751755400 2010-12-01 29.782165866567503 2011-01-01 29.940891307594498 2011-02-01 29.590305291563200 2011-03-01 29.889094501862196 2011-04-01 29.942041040438900 2011-05-01 30.242572141291200 2011-06-01 30.381700942552900 2011-07-01 30.293134455741402 2011-08-01 30.065775895603300 2011-09-01 30.046827130581000 2011-10-01 30.084970796556600 2011-11-01 29.838190774885900 2011-12-01 29.543629233233800 2012-01-01 29.782878538170298 2012-02-01 29.466584222023100 2012-03-01 29.213160325260400 2012-04-01 29.399043432358800 2012-05-01 29.021171686186300 2012-06-01 29.062810558867103 2012-07-01 29.028392627447900 2012-08-01 28.837572323691802 2012-09-01 29.788621039329900 2012-10-01 29.412707466550300 2012-11-01 29.323775660652498 2012-12-01 29.553555466875600 2013-01-01 29.232533504261603 2013-02-01 29.242083430894603 2013-03-01 29.103161373401900 2013-04-01 29.380476563583397 2013-05-01 29.670171292302300 2013-06-01 29.603094726636800 2013-07-01 29.662381788876000 2013-08-01 29.322888588012900 2013-09-01 29.631543363411900 2013-10-01 29.353921380324696 2013-11-01 29.278100992809300 2013-12-01 29.750285047520000 2014-01-01 29.659060412075400 2014-02-01 30.078198261709400 2014-03-01 30.049379487333002 2014-04-01 29.780972271159700 2014-05-01 29.946486671171400 2014-06-01 30.156184575480800 2014-07-01 30.292529101367997 2014-08-01 30.650355946072100 2014-09-01 30.415198401513100 2014-10-01 30.454031346701000 2014-11-01 30.823033069026998 2014-12-01 30.491691791867500 2015-01-01 30.795948935873604 2015-02-01 30.859938959660397 2015-03-01 31.023926568501100 2015-04-01 30.949893086238800 2015-05-01 30.766681103231804 2015-06-01 30.661849817393698 2015-07-01 30.439626556536002 2015-08-01 30.314829692158103 2015-09-01 30.223836613713000 2015-10-01 30.596636334912702 2015-11-01 30.901640451206397 2015-12-01 30.639665759982600 2016-01-01 30.736361653491397 2016-02-01 30.623196791522002 2016-03-01 30.781664683131200 2016-04-01 30.727682906114698 2016-05-01 31.084060785756100 2016-06-01 30.957461143820100 2016-07-01 31.072036238194400 2016-08-01 31.514238668716803 2016-09-01 31.774815522098800 2016-10-01 32.263616323691900 2016-11-01 31.922759244064103 2016-12-01 31.574397086277500 2017-01-01 32.338466340078000 2017-02-01 32.462499737089100 2017-03-01 32.598947602245700 2017-04-01 32.737870897651100 2017-05-01 32.295387326427104 2017-06-01 32.012022875752390 2017-07-01 32.879559424699100 2017-08-01 32.759069013976806 2017-09-01 32.741983641692600 2017-10-01 33.212200844030500 2017-11-01 32.911212410521806 2017-12-01 32.818915151751800 2018-01-01 32.870110444404100 2018-02-01 33.026219298294000 2018-03-01 32.935641143890200 2018-04-01 33.365403362037505 2018-05-01 33.549759915636390 2018-06-01 33.652070257789000 2018-07-01 33.798959230145400 2018-08-01 33.997965632647300 2018-09-01 34.292760710840200 2018-10-01 34.202127721805600 2018-11-01 33.894259115534800 2018-12-01 34.695373226898500 2019-01-01 35.270580977992700 2019-02-01 34.759242446212400 2019-03-01 34.817369328830104 2019-04-01 35.361549016572900 2019-05-01 35.069972016080400 2019-06-01 35.647745785939100 2019-07-01 35.754804167126700 2019-08-01 35.648420848346300 2019-09-01 35.816454945071200 2019-10-01 35.846541301913300 2019-11-01 35.790885499131800 2019-12-01 35.877093221383900 2020-01-01 35.952755924455104 2020-02-01 36.267677484823700 2020-03-01 36.525608986010795 2020-04-01 36.459305792845896 2020-05-01 36.790179439382800 2020-06-01 36.656215221646290 2020-07-01 36.627035790408300 2020-08-01 37.004168955740795 2020-09-01 36.985368037155900 2020-10-01 37.080954546904100 2020-11-01 37.229669844098204 2020-12-01 37.297946451821105 2021-01-01 37.256890956799296 2021-02-01 37.194951185442100 2021-03-01 37.662826549007800 2021-04-01 37.218640411083800 2021-05-01 37.691029002091604 2021-06-01 37.539720176841300 2021-07-01 37.602658719077100 2021-08-01 38.360002601547900 2021-09-01 36.981358443593294 2021-10-01 37.717253115329300 2021-11-01 38.022425191085300 2021-12-01 38.346677107623100 2022-01-01 38.912867476845500 2022-02-01 38.481707259989210 2022-03-01 37.672754916361800