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 Weekly Earnings of All Employees: Private Service Providing in District of Columbia (DISCONTINUED) Series ID: SMU11000000800000011SA 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 Week Date Range: 2007-01-01 to 2022-03-01 Last Updated: 2022-04-16 5:06 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/SMU11000000800000011). 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/SMU11000000800000011) 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/SMU11000000800000011). 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 1183.3761820224200 2007-02-01 1201.8069635118000 2007-03-01 1193.9216668003598 2007-04-01 1270.3697994545098 2007-05-01 1233.9763390199000 2007-06-01 1243.2961673521200 2007-07-01 1259.8108461315198 2007-08-01 1209.6978065696600 2007-09-01 1235.6594407764699 2007-10-01 1213.5746834179200 2007-11-01 1194.2695723534100 2007-12-01 1215.6171023368000 2008-01-01 1173.5842339846700 2008-02-01 1179.5432436615700 2008-03-01 1190.2914466553400 2008-04-01 1157.5375899146600 2008-05-01 1161.9460894336900 2008-06-01 1179.0145107516498 2008-07-01 1171.9316089133700 2008-08-01 1151.2634967332100 2008-09-01 1154.0915257477000 2008-10-01 1141.6081113467599 2008-11-01 1142.5575706764100 2008-12-01 1116.5932546715300 2009-01-01 1130.1902209799800 2009-02-01 1165.4077268427000 2009-03-01 1139.1281038628700 2009-04-01 1125.1069032866499 2009-05-01 1104.4204762408199 2009-06-01 1129.4047103756600 2009-07-01 1118.2804199277300 2009-08-01 1155.6992188925599 2009-09-01 1129.5407757203000 2009-10-01 1141.3280815787600 2009-11-01 1178.1962034626200 2009-12-01 1146.3617950978000 2010-01-01 1162.1404994739800 2010-02-01 1163.8139175704700 2010-03-01 1176.6365411720500 2010-04-01 1202.9296449237800 2010-05-01 1219.8571198551401 2010-06-01 1177.8605257578100 2010-07-01 1187.7201008068700 2010-08-01 1227.1240986740100 2010-09-01 1206.8944528135100 2010-10-01 1242.3238875166600 2010-11-01 1239.4995290683100 2010-12-01 1254.8321401252902 2011-01-01 1284.9810463524000 2011-02-01 1239.4351074755400 2011-03-01 1235.2352445099100 2011-04-01 1239.6340619909700 2011-05-01 1278.5031895308500 2011-06-01 1243.8733878533900 2011-07-01 1268.1970284516499 2011-08-01 1248.1314554435000 2011-09-01 1254.6167136040100 2011-10-01 1329.2170651941801 2011-11-01 1259.9819751788000 2011-12-01 1263.9812862107700 2012-01-01 1314.0772098800098 2012-02-01 1264.0047289521099 2012-03-01 1279.2309322127300 2012-04-01 1339.3561985896001 2012-05-01 1282.6855112999401 2012-06-01 1302.5278399861400 2012-07-01 1390.4511169418802 2012-08-01 1317.2279223175200 2012-09-01 1359.4380293016400 2012-10-01 1337.0092183761099 2012-11-01 1320.9979421406700 2012-12-01 1356.5634223865302 2013-01-01 1327.1296228110200 2013-02-01 1357.4145657468000 2013-03-01 1343.0940151182000 2013-04-01 1357.4293004300600 2013-05-01 1361.7535923864000 2013-06-01 1429.7739990096400 2013-07-01 1370.8225873582599 2013-08-01 1371.8563422084500 2013-09-01 1415.8548988627100 2013-10-01 1400.5543861233402 2013-11-01 1390.9981420852698 2013-12-01 1444.1372492282400 2014-01-01 1400.6143009996500 2014-02-01 1435.3266634688400 2014-03-01 1433.7912871638598 2014-04-01 1389.5338470940699 2014-05-01 1407.7666699447400 2014-06-01 1441.7208906685300 2014-07-01 1404.9572047301700 2014-08-01 1401.6279354123099 2014-09-01 1395.4962437760098 2014-10-01 1413.6227595441500 2014-11-01 1458.4680716077498 2014-12-01 1388.8077636603100 2015-01-01 1414.9811117529598 2015-02-01 1469.2434438834302 2015-03-01 1469.8205076549900 2015-04-01 1386.3493796889300 2015-05-01 1392.4206925852900 2015-06-01 1370.5720332122300 2015-07-01 1338.5187298045900 2015-08-01 1381.2079177339801 2015-09-01 1311.4010489996000 2015-10-01 1297.5347094480198 2015-11-01 1335.0191180867698 2015-12-01 1288.9557185550500 2016-01-01 1297.1350877629902 2016-02-01 1286.8234968153600 2016-03-01 1297.0708584800200 2016-04-01 1328.0871281593200 2016-05-01 1435.9629849201401 2016-06-01 1359.0183442097900 2016-07-01 1369.8056352408000 2016-08-01 1398.6379401501401 2016-09-01 1381.9707705799300 2016-10-01 1491.4267789692801 2016-11-01 1399.7484912216800 2016-12-01 1408.3558228107200 2017-01-01 1503.0721736203302 2017-02-01 1404.9803915940400 2017-03-01 1413.6752213105099 2017-04-01 1443.9980153099302 2017-05-01 1417.4645721228500 2017-06-01 1408.9600531433898 2017-07-01 1484.2228719768600 2017-08-01 1433.6521727703900 2017-09-01 1434.7274741774302 2017-10-01 1548.3220597821200 2017-11-01 1458.5001765328500 2017-12-01 1453.6055608019800 2018-01-01 1472.5746117820600 2018-02-01 1471.2170820971300 2018-03-01 1479.6709461349499 2018-04-01 1525.7987166328000 2018-05-01 1487.4727884542600 2018-06-01 1503.7427470947598 2018-07-01 1547.6879902623200 2018-08-01 1495.4841839819198 2018-09-01 1573.4983936439700 2018-10-01 1534.2457926118698 2018-11-01 1544.5647232470400 2018-12-01 1616.8655573130900 2019-01-01 1570.1077411591900 2019-02-01 1573.5069706957200 2019-03-01 1601.3283486996600 2019-04-01 1591.5407138607502 2019-05-01 1623.6710765198600 2019-06-01 1711.5957204381000 2019-07-01 1597.8383828902697 2019-08-01 1606.4751961363502 2019-09-01 1660.6814199836099 2019-10-01 1619.4942231669102 2019-11-01 1617.1434987647901 2019-12-01 1684.5745823418500 2020-01-01 1646.0277012255300 2020-02-01 1746.7126489567300 2020-03-01 1743.8775066781197 2020-04-01 1751.1834436946500 2020-05-01 1785.2624491003500 2020-06-01 1809.5166536311604 2020-07-01 1799.4733354644000 2020-08-01 1882.4898747298103 2020-09-01 1825.9085623257300 2020-10-01 1865.6146030778898 2020-11-01 1971.4592612675800 2020-12-01 1847.7441784780603 2021-01-01 1881.2079410140600 2021-02-01 1850.5851838144602 2021-03-01 1845.2566820980700 2021-04-01 1816.5464160927600 2021-05-01 1933.6038522866397 2021-06-01 1824.4084014331000 2021-07-01 1825.4080904184802 2021-08-01 1902.9963017998800 2021-09-01 1810.7193224111802 2021-10-01 1837.5018232650000 2021-11-01 1850.4539431202200 2021-12-01 1821.3648525570002 2022-01-01 1897.2488478048900 2022-02-01 1797.7012530858200 2022-03-01 1795.7529032959199