Table Data - All Employees: Government: Local Government Excluding Educational Services in Santa Rosa-Petaluma, CA (MSA)

Title All Employees: Government: Local Government Excluding Educational Services in Santa Rosa-Petaluma, CA (MSA)
Series ID SMU06422209093200001SA
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 2003-01-01 to 2026-07-01
Last Updated 2026-08-21 7:21 PM CDT
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. More information on X-13ARIMA-SEATS can be found here.

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.

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
2003-01-01 8.25369775999033
2003-02-01 8.25382525211748
2003-03-01 8.35506239185582
2003-04-01 8.61737765628379
2003-05-01 8.62668993616802
2003-06-01 8.52226855588696
2003-07-01 8.68374630012516
2003-08-01 8.59343668574898
2003-09-01 8.60373289345186
2003-10-01 8.70846092350868
2003-11-01 8.57185531259387
2003-12-01 8.60986576666133
2004-01-01 8.65291047338774
2004-02-01 8.65588250545433
2004-03-01 8.65278785749361
2004-04-01 8.62249898076657
2004-05-01 8.51963992685472
2004-06-01 8.62294393887165
2004-07-01 8.48907394631286
2004-08-01 8.59112850676760
2004-09-01 8.60463453865528
2004-10-01 8.61159354148100
2004-11-01 8.76572282269672
2004-12-01 8.70462529973156
2005-01-01 8.75525989084463
2005-02-01 8.85826574969207
2005-03-01 8.85227332640112
2005-04-01 8.83068640368386
2005-05-01 8.81341317817011
2005-06-01 8.92196630852396
2005-07-01 9.00039151659090
2005-08-01 9.18246541668473
2005-09-01 9.00276480617316
2005-10-01 9.01813331289523
2005-11-01 8.95697939693818
2005-12-01 8.99679858352358
2006-01-01 8.96061941359407
2006-02-01 8.96270609056876
2006-03-01 8.95174717332994
2006-04-01 9.04008327409235
2006-05-01 9.10517216290378
2006-06-01 9.12189435803050
2006-07-01 9.11313995682863
2006-08-01 9.07106383368318
2006-09-01 9.20158917852108
2006-10-01 9.01711158966327
2006-11-01 8.95214924760764
2006-12-01 9.18136165732171
2007-01-01 9.27854365885375
2007-02-01 9.27093714875577
2007-03-01 9.35529931465246
2007-04-01 9.24572422140652
2007-05-01 9.29598380766491
2007-06-01 9.20988600371504
2007-07-01 9.22913350635440
2007-08-01 9.25554369686901
2007-09-01 9.19601504725849
2007-10-01 9.42532521968058
2007-11-01 9.35583932081481
2007-12-01 9.46809577566933
2008-01-01 9.10203978492074
2008-02-01 9.17565698415672
2008-03-01 9.14589480261233
2008-04-01 9.25021998227995
2008-05-01 9.29166640392508
2008-06-01 9.19002176083316
2008-07-01 9.34820504640404
2008-08-01 9.14403333485525
2008-09-01 9.59426201692195
2008-10-01 9.42560688311930
2008-11-01 9.36405534401848
2008-12-01 9.35655242783790
2009-01-01 9.42461642328313
2009-02-01 9.37805006188589
2009-03-01 9.34192412133893
2009-04-01 9.35003201900692
2009-05-01 9.28975863940895
2009-06-01 9.26189665431693
2009-07-01 9.16440899386390
2009-08-01 9.14189954729470
2009-09-01 9.09653083895429
2009-10-01 9.02892988723786
2009-11-01 8.97840730736629
2009-12-01 8.93932786107505
2010-01-01 8.74207737534677
2010-02-01 8.76737502912321
2010-03-01 8.73133094334674
2010-04-01 8.65564393437010
2010-05-01 8.59931598820558
2010-06-01 7.84001474574614
2010-07-01 7.77221413052358
2010-08-01 7.85595342795974
2010-09-01 7.79714234284430
2010-10-01 7.72806920919619
2010-11-01 7.78834601637309
2010-12-01 7.80831319169709
2011-01-01 7.85468388250677
2011-02-01 8.16221201668755
2011-03-01 8.83187118094673
2011-04-01 8.75423625667501
2011-05-01 8.21229584596631
2011-06-01 8.32070446596126
2011-07-01 8.17563995841762
2011-08-01 8.48134235821563
2011-09-01 8.20261835329650
2011-10-01 8.12240684081757
2011-11-01 8.09514721868743
2011-12-01 7.97450133205695
2012-01-01 8.15885662157935
2012-02-01 8.05655067583103
2012-03-01 8.03100002649744
2012-04-01 8.15421190912182
2012-05-01 8.32508675985605
2012-06-01 8.21804394112745
2012-07-01 8.28209913856041
2012-08-01 8.20311594380398
2012-09-01 8.20856455616060
2012-10-01 8.60354612303596
2012-11-01 8.29054087066568
2012-12-01 8.55179789592288
2013-01-01 8.35072721040111
2013-02-01 8.46561783942760
2013-03-01 8.44565744104577
2013-04-01 8.34980025540458
2013-05-01 8.42965796680968
2013-06-01 8.42269472694653
2013-07-01 8.68449222364858
2013-08-01 9.10799074317774
2013-09-01 9.32040392537642
2013-10-01 10.58439492226260
2013-11-01 10.88923840804930
2013-12-01 10.93824149272660
2014-01-01 10.84254886340110
2014-02-01 10.77178650085370
2014-03-01 10.75388973778010
2014-04-01 10.85587448825570
2014-05-01 10.53228231692740
2014-06-01 10.63461068320420
2014-07-01 10.38719819281340
2014-08-01 10.28810950931550
2014-09-01 10.32249947044290
2014-10-01 10.47620253770240
2014-11-01 10.38832563580180
2014-12-01 10.34095579590940
2015-01-01 10.33548644739520
2015-02-01 10.37900772467750
2015-03-01 10.36316311092680
2015-04-01 10.46294618632990
2015-05-01 10.53601504626280
2015-06-01 10.43310624123960
2015-07-01 10.49605082282110
2015-08-01 10.54109310773270
2015-09-01 10.53237677100420
2015-10-01 10.57840812416040
2015-11-01 10.49022380263130
2015-12-01 10.45435369648180
2016-01-01 10.53567212964060
2016-02-01 10.47629167103020
2016-03-01 10.56494620463020
2016-04-01 10.57692915874420
2016-05-01 10.63948208608210
2016-06-01 10.52955134303480
2016-07-01 10.90829263260290
2016-08-01 11.07985844606140
2016-09-01 10.83876355635950
2016-10-01 10.78985224188740
2016-11-01 10.89234562869870
2016-12-01 10.97513686131450
2017-01-01 11.03309876941700
2017-02-01 10.86756211059580
2017-03-01 11.17189187571670
2017-04-01 11.08536682251310
2017-05-01 11.14543633858290
2017-06-01 11.12558219545040
2017-07-01 11.12067472885310
2017-08-01 11.12633776740230
2017-09-01 11.24934892997600
2017-10-01 11.10182355483770
2017-11-01 11.09652397619550
2017-12-01 11.07550063012130
2018-01-01 11.13581735511260
2018-02-01 11.15912216162910
2018-03-01 11.06625500048000
2018-04-01 11.09511805551120
2018-05-01 11.15357960069520
2018-06-01 11.13712083029760
2018-07-01 11.13098076366650
2018-08-01 11.19280792516630
2018-09-01 11.04555511965940
2018-10-01 11.11515994009430
2018-11-01 11.09525765431730
2018-12-01 11.06864607207410
2019-01-01 11.03871003645400
2019-02-01 11.05765116347970
2019-03-01 11.05227858414930
2019-04-01 11.09340011708130
2019-05-01 11.06632169271090
2019-06-01 11.25008099327830
2019-07-01 11.14760921810290
2019-08-01 11.28088050603570
2019-09-01 11.03797385834860
2019-10-01 11.11599775398550
2019-11-01 11.19514008329540
2019-12-01 11.15963611400560
2020-01-01 11.14302216583460
2020-02-01 11.26631931535440
2020-03-01 11.12819969777200
2020-04-01 10.18897479440780
2020-05-01 8.66817162749602
2020-06-01 9.96994226516831
2020-07-01 10.26100911942260
2020-08-01 10.07540696486020
2020-09-01 10.62560787495540
2020-10-01 10.62139897223760
2020-11-01 10.59242225568720
2020-12-01 10.76280742952300
2021-01-01 10.75060976894760
2021-02-01 10.67026844740740
2021-03-01 10.80991693615280
2021-04-01 10.77820998355060
2021-05-01 10.86941958024060
2021-06-01 10.77973138101270
2021-07-01 10.86361998407740
2021-08-01 10.57411181711840
2021-09-01 10.91740786094380
2021-10-01 10.82906727750020
2021-11-01 10.89605312757750
2021-12-01 10.86970801236580
2022-01-01 11.15422238621930
2022-02-01 10.78001646512500
2022-03-01 10.99398054762600
2022-04-01 10.87395902599860
2022-05-01 10.86536793379050
2022-06-01 10.88500338534180
2022-07-01 10.84771630388890
2022-08-01 10.87098898145430
2022-09-01 11.00923335251350
2022-10-01 11.04483534688130
2022-11-01 10.99848146006080
2022-12-01 11.08724270097950
2023-01-01 11.15543586444230
2023-02-01 11.38440642018760
2023-03-01 11.29328999276600
2023-04-01 11.27640481697120
2023-05-01 11.36065243490900
2023-06-01 11.27602903804880
2023-07-01 11.32413989806660
2023-08-01 11.46806888651850
2023-09-01 11.40713070997520
2023-10-01 11.45064904195440
2023-11-01 11.60580148125750
2023-12-01 11.60339317033790
2024-01-01 11.65343067655120
2024-02-01 11.89144422776230
2024-03-01 11.80309258904250
2024-04-01 12.08487010560670
2024-05-01 12.05480881412000
2024-06-01 12.26532818619800
2024-07-01 12.39531193737810
2024-08-01 12.25971273487800
2024-09-01 12.20834946055650
2024-10-01 12.25813354875780
2024-11-01 12.30692872156260
2024-12-01 12.31741761858110
2025-01-01 12.35477863224060
2025-02-01 12.19111596668280
2025-03-01 12.32530409287240
2025-04-01 12.29060829575580
2025-05-01 12.25434603849590
2025-06-01 12.24857875563830
2025-07-01 12.37235667327470
2025-08-01 12.25623190215710
2025-09-01 12.31191988545200
2025-10-01 12.25663905691700
2025-11-01 12.21040314597160
2025-12-01 12.22142624899770
2026-01-01 12.25157484250630
2026-02-01 12.19767128441430
2026-03-01 12.24098397842420
2026-04-01 12.19744505484180
2026-05-01 12.35282963838050
2026-06-01 12.54327164057380
2026-07-01 12.35272772305540

Back to Top