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 Bismarck, ND (MSA) (DISCONTINUED) Series ID: SMU38139000500000003SA 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:30 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/SMU38139000500000003). 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/SMU38139000500000003) 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/SMU38139000500000003). 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 17.917618341528400 2007-02-01 17.758320872687200 2007-03-01 17.718151518914700 2007-04-01 18.970458715715900 2007-05-01 17.957150125269300 2007-06-01 17.831678085608200 2007-07-01 17.943437155044700 2007-08-01 17.588017625985700 2007-09-01 17.681565271004104 2007-10-01 17.758905012902800 2007-11-01 17.837671087663500 2007-12-01 17.932506423191200 2008-01-01 17.685702869749300 2008-02-01 17.769676217765802 2008-03-01 17.784834004035602 2008-04-01 17.852298199994000 2008-05-01 17.872933827052200 2008-06-01 18.188532372763603 2008-07-01 18.196221529352897 2008-08-01 18.400149401222603 2008-09-01 18.509994924431602 2008-10-01 18.462795758962200 2008-11-01 18.734958252313000 2008-12-01 18.608584797396702 2009-01-01 18.405682925951500 2009-02-01 18.556410777639800 2009-03-01 18.734077352946000 2009-04-01 18.788003037773100 2009-05-01 18.758473609148200 2009-06-01 18.783128671965800 2009-07-01 18.870208403955100 2009-08-01 19.379628774403397 2009-09-01 19.547007697580500 2009-10-01 19.896257996040400 2009-11-01 19.841753939602600 2009-12-01 19.617901101344900 2010-01-01 20.652470530004603 2010-02-01 21.099079157554396 2010-03-01 19.871146018582500 2010-04-01 21.082720742178700 2010-05-01 21.445619757545200 2010-06-01 21.385996039139400 2010-07-01 21.842240755174700 2010-08-01 21.844951112090000 2010-09-01 21.224513841987900 2010-10-01 21.168426180660200 2010-11-01 21.321923517570898 2010-12-01 21.465991889536500 2011-01-01 21.539995150052600 2011-02-01 21.664753785614500 2011-03-01 21.844528696981200 2011-04-01 21.849367141284500 2011-05-01 21.734838827297697 2011-06-01 21.922403436752000 2011-07-01 22.091391756633200 2011-08-01 22.060131202307200 2011-09-01 22.375627959189600 2011-10-01 22.495212593095400 2011-11-01 22.601791705591804 2011-12-01 22.692990205591997 2012-01-01 22.973661694190998 2012-02-01 22.960596516967502 2012-03-01 23.156328967480000 2012-04-01 23.144053770474000 2012-05-01 23.341625758454104 2012-06-01 23.651760071457100 2012-07-01 23.295185992240000 2012-08-01 23.474062076428900 2012-09-01 23.718334953660500 2012-10-01 23.037827400114104 2012-11-01 23.474119929745697 2012-12-01 23.468798763053602 2013-01-01 23.518952907548698 2013-02-01 23.667124986427698 2013-03-01 23.349350378348800 2013-04-01 23.654767481102900 2013-05-01 23.942120829868300 2013-06-01 24.431162131117100 2013-07-01 24.276334884639700 2013-08-01 24.187971615435700 2013-09-01 24.133539603862500 2013-10-01 24.268645530980702 2013-11-01 24.513515281899000 2013-12-01 24.687264373767800 2014-01-01 24.573632330894700 2014-02-01 24.916975440059400 2014-03-01 24.789773403937300 2014-04-01 25.121590531955900 2014-05-01 24.595523106548600 2014-06-01 24.799064543492698 2014-07-01 24.972488021413003 2014-08-01 24.945313802658100 2014-09-01 25.263359045159696 2014-10-01 25.371620424294600 2014-11-01 25.345690202345300 2014-12-01 25.389336892987103 2015-01-01 25.422509091542100 2015-02-01 25.427024228949300 2015-03-01 25.083811834761700 2015-04-01 25.277687103120797 2015-05-01 24.952755801039000 2015-06-01 25.171651570767605 2015-07-01 25.109667867122603 2015-08-01 25.398826612234500 2015-09-01 25.002183666875897 2015-10-01 25.410377941437100 2015-11-01 25.355077037225800 2015-12-01 25.183108479462103 2016-01-01 25.454492900367400 2016-02-01 25.076164002618300 2016-03-01 25.483454897969400 2016-04-01 25.265704431494900 2016-05-01 25.784133952055303 2016-06-01 25.675874343061600 2016-07-01 25.921379158838896 2016-08-01 26.132185806636000 2016-09-01 26.365371949467804 2016-10-01 26.502321345853800 2016-11-01 26.624420889636200 2016-12-01 26.554674393200997 2017-01-01 26.733567376467400 2017-02-01 26.795956144877300 2017-03-01 27.235450160260300 2017-04-01 27.684596684573602 2017-05-01 27.361568102521400 2017-06-01 26.955954966483002 2017-07-01 27.408344061475702 2017-08-01 26.989818115974604 2017-09-01 26.927634500038800 2017-10-01 27.014531028769603 2017-11-01 26.710247177595402 2017-12-01 26.846375039633497 2018-01-01 26.693254260351000 2018-02-01 26.892910756893500 2018-03-01 26.696347890248800 2018-04-01 26.599227705091000 2018-05-01 26.570497642057400 2018-06-01 26.738734139466600 2018-07-01 26.419783378969303 2018-08-01 27.011705934695300 2018-09-01 27.147430347770200 2018-10-01 26.945488156752600 2018-11-01 27.236853827938600 2018-12-01 27.293547241091800 2019-01-01 27.302668847478800 2019-02-01 27.242661562021700 2019-03-01 27.014173137978897 2019-04-01 27.101460166196798 2019-05-01 27.202399350438500 2019-06-01 27.620977286673800 2019-07-01 26.831387622913898 2019-08-01 26.685895146186500 2019-09-01 26.238050219583997 2019-10-01 26.605101723284000 2019-11-01 26.794817753882400 2019-12-01 27.292298297651502 2020-01-01 26.587828017778600 2020-02-01 26.851284190841998 2020-03-01 26.905811318450000 2020-04-01 28.066165122226100 2020-05-01 26.876122290639700 2020-06-01 27.315644190374698 2020-07-01 27.294186946916200 2020-08-01 27.713242480793900 2020-09-01 26.796508610706000 2020-10-01 27.378064959826197 2020-11-01 27.284617127062603 2020-12-01 28.122745288032604 2021-01-01 27.599086092810197 2021-02-01 27.614279613002200 2021-03-01 27.706448883706397 2021-04-01 28.125888278658298 2021-05-01 28.158029917830600 2021-06-01 28.052728014888395 2021-07-01 28.323355530201603 2021-08-01 28.420696745896200 2021-09-01 28.780231005575400 2021-10-01 29.007839551954103 2021-11-01 29.341355050433503 2021-12-01 29.493456631066103 2022-01-01 30.517157080340800 2022-02-01 29.977994613369603 2022-03-01 30.274279736024102