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: All Employees: Retail Trade: Sporting Goods, Hobby, Musical Instrument, and Book Stores in Oakland-Hayward-Berkeley, CA (MD) Series ID: SMU06360844245100001SA 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: Thousands of Persons Date Range: 1990-01-01 to 2022-12-01 Last Updated: 2023-01-25 3:40 AM CST Notes: The Federal Reserve Bank of St. Louis seasonally adjusts 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/SMU06360844245100001). 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 1990-01-01 8.0134195506238500 1990-02-01 7.8683521970777410 1990-03-01 7.8470482659270000 1990-04-01 7.8298744727801400 1990-05-01 7.8605356690169410 1990-06-01 7.7943634030136110 1990-07-01 7.9458454404518800 1990-08-01 7.9407465577189000 1990-09-01 8.1759754416274200 1990-10-01 7.8878760454520500 1990-11-01 7.8067903948355990 1990-12-01 7.7353697645043210 1991-01-01 7.5200239115177000 1991-02-01 7.5685281009969200 1991-03-01 7.5431248152862800 1991-04-01 7.3198617251501300 1991-05-01 7.2494811572126510 1991-06-01 7.1775260589907190 1991-07-01 7.3507054528177690 1991-08-01 7.4503028334807695 1991-09-01 7.4837277056084600 1991-10-01 7.4901359658918200 1991-11-01 7.5184777034063400 1991-12-01 7.5513086113303105 1992-01-01 6.8331280264838100 1992-02-01 6.8659504084112310 1992-03-01 6.8388288073987010 1992-04-01 6.9998273873563890 1992-05-01 7.0229789899065200 1992-06-01 6.9382634867059410 1992-07-01 6.9588641121589400 1992-08-01 6.9618702313780590 1992-09-01 6.9941676456186610 1992-10-01 7.0016480210740990 1992-11-01 7.1505177867055800 1992-12-01 7.1808961119404400 1993-01-01 7.2404221754851505 1993-02-01 7.1643389040661600 1993-03-01 7.1321019312164100 1993-04-01 6.8738342015016000 1993-05-01 6.9835960649795590 1993-06-01 7.0971138139064500 1993-07-01 7.0588364566474400 1993-08-01 6.8643622321879010 1993-09-01 7.0002898191830100 1993-10-01 7.0254080574801100 1993-11-01 6.9987845107783900 1993-12-01 7.0311468965557395 1994-01-01 6.5408983902302005 1994-02-01 6.6506899883035600 1994-03-01 6.7115353836493900 1994-04-01 6.7614294477409510 1994-05-01 6.7531249657066100 1994-06-01 6.6603026022065310 1994-07-01 6.5438354883992895 1994-08-01 6.5511242173722600 1994-09-01 6.5976174730384200 1994-10-01 6.7512466753708490 1994-11-01 6.8581122033939000 1994-12-01 6.9017819747366500 1995-01-01 6.5371847700716690 1995-02-01 6.7326301897558500 1995-03-01 6.6829216183939510 1995-04-01 6.8558882350765000 1995-05-01 6.9248700936528005 1995-06-01 6.9410996427480690 1995-07-01 6.8209611468268300 1995-08-01 6.8313475206816100 1995-09-01 6.7872816731620510 1995-10-01 6.7696887093769690 1995-11-01 6.6117545402988210 1995-12-01 6.7777323984542310 1996-01-01 6.7348637353497900 1996-02-01 6.6025483488877800 1996-03-01 6.6516100785449000 1996-04-01 6.5702414366331100 1996-05-01 6.5137842202279295 1996-06-01 6.5388305377791500 1996-07-01 6.5889877506422900 1996-08-01 6.5997672960486190 1996-09-01 6.5682226441251700 1996-10-01 6.3818814415769200 1996-11-01 6.3572730483508200 1996-12-01 6.3421142320172410 1997-01-01 6.4420430119359600 1997-02-01 6.5764507811836510 1997-03-01 6.6294292437743400 1997-04-01 6.4833807355354290 1997-05-01 6.5082137236027690 1997-06-01 6.4467680798578900 1997-07-01 6.7498207058488890 1997-08-01 6.5726482120290190 1997-09-01 6.5507469756923400 1997-10-01 6.5933180816962200 1997-11-01 6.6875394394029500 1997-12-01 6.5948249025913890 1998-01-01 6.7539305927021210 1998-02-01 6.7495393261072900 1998-03-01 6.8125554239016600 1998-04-01 6.8933049954054810 1998-05-01 6.9109155359485990 1998-06-01 6.9572874087489610 1998-07-01 6.8145358163823600 1998-08-01 6.7466754587594600 1998-09-01 6.8466711530251505 1998-10-01 6.8975684344704600 1998-11-01 6.8041536280995500 1998-12-01 6.8280888383717210 1999-01-01 6.8763007096494400 1999-02-01 6.8337474662714900 1999-03-01 6.9018583703464800 1999-04-01 6.5911228010515310 1999-05-01 6.6065020150554090 1999-06-01 6.5642576560844300 1999-07-01 6.6908455912169190 1999-08-01 6.7376372529799400 1999-09-01 6.7508897430128090 1999-10-01 6.6955582484455896 1999-11-01 6.7098173728664900 1999-12-01 6.7519192426655590 2000-01-01 6.5898873510614910 2000-02-01 6.5222142622164900 2000-03-01 6.6953219893566110 2000-04-01 6.9878004411473000 2000-05-01 6.9040278973868710 2000-06-01 6.9726912906879100 2000-07-01 7.0757373715560306 2000-08-01 7.0314616131984900 2000-09-01 7.0576954333669700 2000-10-01 7.0898563319261690 2000-11-01 7.3113332697266795 2000-12-01 7.1641691391991600 2001-01-01 7.1980705833575700 2001-02-01 7.2241419807135200 2001-03-01 7.2909378078408205 2001-04-01 7.3775971204860490 2001-05-01 7.3034027619549100 2001-06-01 7.3818855880238310 2001-07-01 7.1637446950019410 2001-08-01 7.2340622513777400 2001-09-01 7.0612003402933890 2001-10-01 7.0865759118921700 2001-11-01 7.0040037996111800 2001-12-01 7.0826880131614200 2002-01-01 6.9949329105913600 2002-02-01 7.0271321829493890 2002-03-01 6.9847926568669400 2002-04-01 6.8627994034798006 2002-05-01 6.9058128785876600 2002-06-01 6.7899296665921800 2002-07-01 6.8681407160423600 2002-08-01 6.8357426285438700 2002-09-01 6.8693235414886110 2002-10-01 6.7813163783949100 2002-11-01 6.7864352087422700 2002-12-01 6.7031481394489300 2003-01-01 6.7833739467079806 2003-02-01 6.7310818647284200 2003-03-01 6.6818298299127900 2003-04-01 6.5499740213140500 2003-05-01 6.5058184008825400 2003-06-01 6.4972212280997890 2003-07-01 6.4793770678215400 2003-08-01 6.3481586510768790 2003-09-01 6.3735560589609300 2003-10-01 6.3707710264938300 2003-11-01 6.2622630224027600 2003-12-01 6.4248244511532300 2004-01-01 6.2605889465459690 2004-02-01 6.2335750919142590 2004-03-01 6.0859206004403090 2004-04-01 6.4454339157384100 2004-05-01 6.6130889406179705 2004-06-01 6.5059426948158805 2004-07-01 6.5962940392735705 2004-08-01 6.6504935004917805 2004-09-01 6.5683513105435700 2004-10-01 6.7585769511698090 2004-11-01 6.8345231769457495 2004-12-01 6.8421267503653596 2005-01-01 6.7409917994181106 2005-02-01 6.7388036119262600 2005-03-01 6.7012941915638400 2005-04-01 6.7483041779416110 2005-05-01 6.7201323149265100 2005-06-01 6.7187666406785000 2005-07-01 6.6081535178851200 2005-08-01 6.6439353241905800 2005-09-01 6.5556972972090300 2005-10-01 6.5451436342600890 2005-11-01 6.6064297123261900 2005-12-01 6.5542214616214690 2006-01-01 6.6257946269033200 2006-02-01 6.6532806332928600 2006-03-01 6.6214400619518400 2006-04-01 6.3545528357462900 2006-05-01 6.4284366816801795 2006-06-01 6.3238846526764100 2006-07-01 6.2258638704169410 2006-08-01 6.0203352212006100 2006-09-01 5.9402167745269590 2006-10-01 5.9379363123646000 2006-11-01 5.7848383758461100 2006-12-01 5.7674296160102500 2007-01-01 5.7134279242359510 2007-02-01 5.6647489000114110 2007-03-01 5.6377204564418300 2007-04-01 5.6689016930294690 2007-05-01 5.6293411532191600 2007-06-01 5.6323686472318610 2007-07-01 5.6382797242921000 2007-08-01 5.6978699984509600 2007-09-01 5.7227668317025010 2007-10-01 5.6278366191390900 2007-11-01 5.6724586997255190 2007-12-01 5.5819387921024590 2008-01-01 5.6009965795053500 2008-02-01 5.5813027431844810 2008-03-01 5.4473562849643800 2008-04-01 5.4818902250607600 2008-05-01 5.5255898628271700 2008-06-01 5.5362756342985000 2008-07-01 5.6534405177852090 2008-08-01 5.6779233199170100 2008-09-01 5.7053803130458100 2008-10-01 5.7227172558188790 2008-11-01 5.5602679008797296 2008-12-01 5.7030976345253395 2009-01-01 5.5876639455057600 2009-02-01 5.4968950137249290 2009-03-01 5.5518396242995705 2009-04-01 5.4921102677024810 2009-05-01 5.4171470715120495 2009-06-01 5.4397241689839900 2009-07-01 5.3629529624291800 2009-08-01 5.3664787410646100 2009-09-01 5.2936513074012100 2009-10-01 5.2177201028066900 2009-11-01 5.2512823148506400 2009-12-01 5.2224007717588300 2010-01-01 5.1799218951447410 2010-02-01 5.2117418047075410 2010-03-01 5.1519758754515500 2010-04-01 5.1948645011164100 2010-05-01 5.2076520540032700 2010-06-01 5.1345210308802600 2010-07-01 5.0684688571676000 2010-08-01 4.8594388925740700 2010-09-01 4.9952138976048300 2010-10-01 5.0260141053562000 2010-11-01 4.9366656948716000 2010-12-01 4.9459092804233000 2011-01-01 4.9746913955235400 2011-02-01 4.9133373843324010 2011-03-01 4.9461899777575500 2011-04-01 4.8964142371728805 2011-05-01 4.8981753575279905 2011-06-01 4.8272136440700310 2011-07-01 4.7628437525736700 2011-08-01 4.6673385145256700 2011-09-01 4.9082121398785000 2011-10-01 4.8313399778855000 2011-11-01 4.9249708927580995 2011-12-01 4.7651164601273495 2012-01-01 4.8734296969154900 2012-02-01 4.8108257273654810 2012-03-01 4.8354044396419695 2012-04-01 4.7918820731059900 2012-05-01 4.7953782196565800 2012-06-01 4.8202607976091200 2012-07-01 4.8518875473029700 2012-08-01 4.8766371212460310 2012-09-01 4.9253477879113100 2012-10-01 4.8417427595460400 2012-11-01 4.8118251562298795 2012-12-01 4.7821317829187300 2013-01-01 4.7749504832008000 2013-02-01 4.8025418966186600 2013-03-01 4.7283564350241290 2013-04-01 4.7879432374546500 2013-05-01 4.7946003934460300 2013-06-01 4.8108023363798490 2013-07-01 4.8342848761889800 2013-08-01 4.8867259540788800 2013-09-01 4.7389476322757900 2013-10-01 4.7470673871612400 2013-11-01 4.8149807865338090 2013-12-01 4.7962037619335090 2014-01-01 4.7885569696606200 2014-02-01 4.7917789898477500 2014-03-01 4.8197429041921900 2014-04-01 4.7745824423535400 2014-05-01 4.8957855493811700 2014-06-01 4.7926972306413400 2014-07-01 4.7168503257680900 2014-08-01 4.7956998932129595 2014-09-01 4.8526856280119300 2014-10-01 5.0542955302765400 2014-11-01 5.0263727982105190 2014-12-01 5.0114335876322595 2015-01-01 5.0085829182997300 2015-02-01 4.9813209587550000 2015-03-01 5.0121531846792700 2015-04-01 4.9542973777527300 2015-05-01 4.8922348304049010 2015-06-01 4.8705462997705000 2015-07-01 4.9017881130565900 2015-08-01 4.9063119173114300 2015-09-01 4.8538459497443500 2015-10-01 4.8523078156799400 2015-11-01 4.8548654025059506 2015-12-01 4.8412484256810900 2016-01-01 4.8308185344883700 2016-02-01 4.7681657906880200 2016-03-01 4.7032316382295500 2016-04-01 4.7325022896703200 2016-05-01 4.7866604929221800 2016-06-01 4.7515657112748700 2016-07-01 4.6880070581903200 2016-08-01 4.5050957289174910 2016-09-01 4.6432730022957400 2016-10-01 4.6480050387156000 2016-11-01 4.5902349581741500 2016-12-01 4.6803493028460190 2017-01-01 4.6497777607969900 2017-02-01 4.7567940411081400 2017-03-01 4.8026259285676300 2017-04-01 4.8196264515964300 2017-05-01 4.7821521497201390 2017-06-01 4.8374806258969905 2017-07-01 4.7662908250162900 2017-08-01 4.6937697106684400 2017-09-01 4.7167270892205800 2017-10-01 4.8321939519767400 2017-11-01 4.9302662515328610 2017-12-01 4.9340487166631695 2018-01-01 4.8746921244594500 2018-02-01 4.7452922471270400 2018-03-01 4.9099874354076400 2018-04-01 4.8118208467620100 2018-05-01 4.6739230226813700 2018-06-01 4.6272130659866600 2018-07-01 4.4365704070638800 2018-08-01 4.4757732828249600 2018-09-01 4.4939592675846290 2018-10-01 4.4132517369943800 2018-11-01 4.2609609338799200 2018-12-01 4.2893302637928400 2019-01-01 4.3950338809618500 2019-02-01 4.4408183665649900 2019-03-01 4.4217318516229600 2019-04-01 4.4128424294610795 2019-05-01 4.4661713816123100 2019-06-01 4.4187561239045300 2019-07-01 4.4015241629736800 2019-08-01 4.4575005245813800 2019-09-01 4.3741989403343500 2019-10-01 4.2883862597319900 2019-11-01 4.2863665095396400 2019-12-01 4.3468389562538300 2020-01-01 4.3123522308917000 2020-02-01 4.3402952317327200 2020-03-01 4.3322392108711805 2020-04-01 2.2162655590622897 2020-05-01 2.2537818746134500 2020-06-01 2.9121274290578200 2020-07-01 3.2705754038326096 2020-08-01 3.3373805194602300 2020-09-01 3.4671545965173200 2020-10-01 3.5708397567640400 2020-11-01 3.6048963578301000 2020-12-01 3.5877778902434505 2021-01-01 3.6213654120239800 2021-02-01 3.6428801211301804 2021-03-01 3.7427854918290095 2021-04-01 3.9220168866413100 2021-05-01 3.9448315385862700 2021-06-01 3.9042114537906403 2021-07-01 3.9454473872371000 2021-08-01 3.9237323605494800 2021-09-01 3.8658608811437500 2021-10-01 4.0550384326348400 2021-11-01 4.0182141886302800 2021-12-01 4.0172524868539500 2022-01-01 4.1309036236934900 2022-02-01 4.1468109288323600 2022-03-01 4.1479461573355610 2022-04-01 4.1211337455665800 2022-05-01 4.1337748266637500 2022-06-01 4.1958475505026300 2022-07-01 4.1320842321656600 2022-08-01 4.1195782275163100 2022-09-01 4.0719470961756405 2022-10-01 4.0477904940422205 2022-11-01 4.0234657072126610 2022-12-01 4.0304485765169400