Table Data - All Employees: Service-Providing in Ames, IA (MSA)

Title All Employees: Service-Providing in Ames, IA (MSA)
Series ID SMU19111800700000001SA
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 2026-09-01
Last Updated 2026-10-20 10:18 AM 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
1990-01-01 40.6050600644
1990-02-01 40.6516423924
1990-03-01 40.5672192137
1990-04-01 40.7955649851
1990-05-01 40.6618308646
1990-06-01 40.9013223011
1990-07-01 40.6939416654
1990-08-01 40.9525255904
1990-09-01 41.5915764041
1990-10-01 40.9984555453
1990-11-01 40.9689619726
1990-12-01 41.1244743308
1991-01-01 41.2659933490
1991-02-01 41.3919361721
1991-03-01 41.2582453620
1991-04-01 40.9155944872
1991-05-01 40.9418148197
1991-06-01 40.8843963745
1991-07-01 40.5287940389
1991-08-01 40.4209556460
1991-09-01 40.8132356011
1991-10-01 40.8904883643
1991-11-01 40.9828809618
1991-12-01 40.7217055722
1992-01-01 41.0081210396
1992-02-01 40.8508690897
1992-03-01 40.7580205134
1992-04-01 41.1395636841
1992-05-01 40.9282579642
1992-06-01 40.6577126586
1992-07-01 40.9669666663
1992-08-01 41.1278124086
1992-09-01 40.8195038608
1992-10-01 40.8842755071
1992-11-01 41.0883066975
1992-12-01 41.1227417739
1993-01-01 40.9484914159
1993-02-01 41.1167689873
1993-03-01 41.3883513909
1993-04-01 41.1310913578
1993-05-01 41.4915180686
1993-06-01 41.5506557639
1993-07-01 41.5093432849
1993-08-01 41.5268430761
1993-09-01 41.7116258840
1993-10-01 41.6596552662
1993-11-01 41.5904213108
1993-12-01 41.9306184212
1994-01-01 41.4731195608
1994-02-01 41.8512515027
1994-03-01 42.3237308115
1994-04-01 42.2864972108
1994-05-01 41.8639476805
1994-06-01 43.2391650181
1994-07-01 43.1776175774
1994-08-01 43.4425968373
1994-09-01 42.9101651609
1994-10-01 42.8983423256
1994-11-01 42.7700962925
1994-12-01 42.9415769205
1995-01-01 41.9224883938
1995-02-01 42.7479480879
1995-03-01 42.7563641976
1995-04-01 42.8488033841
1995-05-01 42.8436841195
1995-06-01 43.1193066301
1995-07-01 43.4863304274
1995-08-01 43.6563598218
1995-09-01 44.0547679685
1995-10-01 43.3223456252
1995-11-01 43.6432261800
1995-12-01 43.4438029701
1996-01-01 42.7250108225
1996-02-01 43.8843286157
1996-03-01 43.7452156795
1996-04-01 44.3128133318
1996-05-01 44.3586909710
1996-06-01 44.2172185024
1996-07-01 43.8385845422
1996-08-01 44.3383035430
1996-09-01 44.5781050719
1996-10-01 44.4205654769
1996-11-01 44.3799357054
1996-12-01 44.3165871956
1997-01-01 44.5946070121
1997-02-01 44.5698940725
1997-03-01 44.4017220864
1997-04-01 44.7341060641
1997-05-01 44.7604874429
1997-06-01 44.6450444338
1997-07-01 44.3141522066
1997-08-01 44.5906649147
1997-09-01 44.9593334679
1997-10-01 45.4337662087
1997-11-01 45.1807207926
1997-12-01 45.3345902374
1998-01-01 45.6200842899
1998-02-01 45.4328726374
1998-03-01 45.7183081854
1998-04-01 45.6757528232
1998-05-01 46.0729175200
1998-06-01 46.3204186934
1998-07-01 46.8414531007
1998-08-01 46.7049451833
1998-09-01 47.2087948516
1998-10-01 47.6354584914
1998-11-01 47.5227746493
1998-12-01 47.5833472636
1999-01-01 47.3609217481
1999-02-01 47.7008588528
1999-03-01 48.0018238601
1999-04-01 48.0280631159
1999-05-01 47.9949314894
1999-06-01 48.4511159794
1999-07-01 48.3445133240
1999-08-01 48.2516830483
1999-09-01 47.9795589882
1999-10-01 48.3863358148
1999-11-01 48.4778211770
1999-12-01 48.7309797492
2000-01-01 49.0424674530
2000-02-01 49.1166633315
2000-03-01 48.9047821294
2000-04-01 48.6087772750
2000-05-01 48.6687136861
2000-06-01 48.9013868372
2000-07-01 48.1802606207
2000-08-01 48.9790363566
2000-09-01 48.5885810309
2000-10-01 48.6785055697
2000-11-01 48.9705188140
2000-12-01 48.9403110321
2001-01-01 48.8974141782
2001-02-01 48.8659209107
2001-03-01 48.6753529434
2001-04-01 48.7605685060
2001-05-01 49.1370055646
2001-06-01 48.3781481591
2001-07-01 48.0774312677
2001-08-01 48.5010677358
2001-09-01 48.5441448199
2001-10-01 48.4728151762
2001-11-01 48.5014139909
2001-12-01 48.4985798267
2002-01-01 48.4959914875
2002-02-01 48.6537741537
2002-03-01 48.8119371477
2002-04-01 48.5649924363
2002-05-01 49.1994790227
2002-06-01 48.9029601395
2002-07-01 47.7259950868
2002-08-01 48.5228798502
2002-09-01 48.6046187749
2002-10-01 48.8375117808
2002-11-01 48.9481364242
2002-12-01 48.7921702979
2003-01-01 48.5179588269
2003-02-01 48.2491269510
2003-03-01 48.6973745002
2003-04-01 48.4640108030
2003-05-01 48.5574220735
2003-06-01 48.0696091474
2003-07-01 48.6175377355
2003-08-01 48.7505840210
2003-09-01 48.7271097657
2003-10-01 48.5152068024
2003-11-01 48.2531657080
2003-12-01 48.3247913808
2004-01-01 48.6943167550
2004-02-01 48.4504754577
2004-03-01 48.2979414530
2004-04-01 48.5402476355
2004-05-01 48.0946591708
2004-06-01 47.9077897806
2004-07-01 48.3447455632
2004-08-01 47.9174911074
2004-09-01 47.7407021175
2004-10-01 48.1107081483
2004-11-01 48.1761336558
2004-12-01 48.1907500403
2005-01-01 47.9899753709
2005-02-01 48.1166813303
2005-03-01 47.9811444766
2005-04-01 48.0259686987
2005-05-01 47.9654719073
2005-06-01 47.6036061312
2005-07-01 48.3401974517
2005-08-01 48.2717687623
2005-09-01 48.3618414653
2005-10-01 48.0884687787
2005-11-01 48.0875048014
2005-12-01 47.9343692140
2006-01-01 48.1489992137
2006-02-01 48.0905423114
2006-03-01 47.9137669256
2006-04-01 48.0976915582
2006-05-01 48.1739019192
2006-06-01 48.5232285122
2006-07-01 49.2363176485
2006-08-01 48.8736047125
2006-09-01 48.7988965730
2006-10-01 48.4342104940
2006-11-01 48.4919296840
2006-12-01 48.6453718189
2007-01-01 48.9654521346
2007-02-01 48.6719623781
2007-03-01 48.4873250130
2007-04-01 48.6760681194
2007-05-01 48.4042116211
2007-06-01 48.5724774056
2007-07-01 48.4644542887
2007-08-01 49.1285038409
2007-09-01 48.4828956327
2007-10-01 48.5971632056
2007-11-01 48.8046556408
2007-12-01 48.5307718942
2008-01-01 48.5558459097
2008-02-01 48.9796739559
2008-03-01 49.5095162115
2008-04-01 48.9769951159
2008-05-01 49.3309208426
2008-06-01 48.9294087999
2008-07-01 48.7573872285
2008-08-01 48.9823204613
2008-09-01 49.2241706765
2008-10-01 49.5488623852
2008-11-01 49.5245127134
2008-12-01 49.6077992499
2009-01-01 49.4424756301
2009-02-01 49.3616639836
2009-03-01 49.6188482870
2009-04-01 49.5671942582
2009-05-01 49.4578569323
2009-06-01 49.4116013819
2009-07-01 49.6025247958
2009-08-01 49.4771144681
2009-09-01 48.9769675350
2009-10-01 49.5580732862
2009-11-01 49.1754623393
2009-12-01 49.3117309818
2010-01-01 48.8726866859
2010-02-01 48.9149130454
2010-03-01 49.1184160957
2010-04-01 49.1830933976
2010-05-01 49.4283406099
2010-06-01 49.4139234697
2010-07-01 49.4351374223
2010-08-01 48.6769060385
2010-09-01 48.9007630492
2010-10-01 48.7927638229
2010-11-01 49.0031144816
2010-12-01 49.2115812430
2011-01-01 49.6333943468
2011-02-01 49.2221602528
2011-03-01 49.2165070474
2011-04-01 49.1757025205
2011-05-01 49.2085912111
2011-06-01 49.6397841634
2011-07-01 50.0084722015
2011-08-01 50.7086147580
2011-09-01 50.3715143508
2011-10-01 49.9762435103
2011-11-01 49.9496685110
2011-12-01 49.8701933000
2012-01-01 50.3661803049
2012-02-01 50.1954526575
2012-03-01 50.0967804456
2012-04-01 50.3277607455
2012-05-01 49.8191652468
2012-06-01 50.5484699663
2012-07-01 50.7737076338
2012-08-01 51.2554925280
2012-09-01 50.7795460851
2012-10-01 50.7155674952
2012-11-01 50.8504745802
2012-12-01 50.8029273278
2013-01-01 50.4954346960
2013-02-01 51.3600077438
2013-03-01 51.4983446542
2013-04-01 51.4325781498
2013-05-01 52.1020748197
2013-06-01 51.6043814709
2013-07-01 51.6039440812
2013-08-01 51.8180564197
2013-09-01 51.7968171985
2013-10-01 51.8997470825
2013-11-01 51.8959834589
2013-12-01 52.1136195985
2014-01-01 51.6469943993
2014-02-01 52.0265991204
2014-03-01 52.2236724639
2014-04-01 52.2344116610
2014-05-01 52.3173728775
2014-06-01 52.5950696178
2014-07-01 52.2002713304
2014-08-01 51.1093453290
2014-09-01 53.0351680239
2014-10-01 53.1334949833
2014-11-01 53.5156183966
2014-12-01 53.5121426762
2015-01-01 53.5380626802
2015-02-01 53.3864662009
2015-03-01 53.7743102978
2015-04-01 53.5201346917
2015-05-01 53.7151512209
2015-06-01 53.7765564127
2015-07-01 54.0432209051
2015-08-01 53.2525725570
2015-09-01 54.1598302128
2015-10-01 54.6681829297
2015-11-01 54.4630490208
2015-12-01 54.7581863741
2016-01-01 54.8214904782
2016-02-01 54.2712920774
2016-03-01 53.9589978750
2016-04-01 54.5400017316
2016-05-01 54.1009098429
2016-06-01 53.9925186793
2016-07-01 53.9572995368
2016-08-01 53.8557710675
2016-09-01 53.9337268303
2016-10-01 53.8124053648
2016-11-01 54.0170975018
2016-12-01 53.8883020347
2017-01-01 54.8952259204
2017-02-01 54.5272949644
2017-03-01 54.2624786054
2017-04-01 54.3816232273
2017-05-01 53.7833103236
2017-06-01 54.4606359104
2017-07-01 54.5685910239
2017-08-01 54.5119426555
2017-09-01 54.6661419906
2017-10-01 54.6172429832
2017-11-01 54.6533432649
2017-12-01 54.5408199044
2018-01-01 55.5496069988
2018-02-01 54.7381226154
2018-03-01 54.4445781748
2018-04-01 54.0401018544
2018-05-01 53.3992919610
2018-06-01 53.9793620406
2018-07-01 54.0269543991
2018-08-01 53.8803444531
2018-09-01 54.2846987868
2018-10-01 54.1169052084
2018-11-01 53.9899026756
2018-12-01 53.9118150957
2019-01-01 53.9753916499
2019-02-01 54.1171561010
2019-03-01 54.1246254185
2019-04-01 54.2931219288
2019-05-01 54.4626447106
2019-06-01 53.8130799511
2019-07-01 54.0022016347
2019-08-01 51.3852736778
2019-09-01 53.9163398270
2019-10-01 52.3218041408
2019-11-01 52.4833217780
2019-12-01 55.0369743142
2020-01-01 56.3122515381
2020-02-01 54.5007273618
2020-03-01 54.6743642845
2020-04-01 48.3676861067
2020-05-01 46.7176391665
2020-06-01 49.6287137411
2020-07-01 50.1526925677
2020-08-01 51.8980305317
2020-09-01 50.8744604608
2020-10-01 51.1412076863
2020-11-01 51.0891390237
2020-12-01 50.8303297327
2021-01-01 51.1275942207
2021-02-01 51.4359408625
2021-03-01 51.9148984484
2021-04-01 53.4024332065
2021-05-01 50.5780575305
2021-06-01 52.5714369298
2021-07-01 52.7460065984
2021-08-01 53.4622178454
2021-09-01 52.2773090724
2021-10-01 52.3688192205
2021-11-01 52.3718854172
2021-12-01 52.5647596236
2022-01-01 51.9618506373
2022-02-01 52.9440235954
2022-03-01 53.0134302548
2022-04-01 53.3343883425
2022-05-01 53.6331762596
2022-06-01 53.7873207926
2022-07-01 54.0530068755
2022-08-01 54.3905354989
2022-09-01 53.8726196135
2022-10-01 53.7891700954
2022-11-01 54.0365076717
2022-12-01 54.1569696266
2023-01-01 54.0406102218
2023-02-01 54.3123532212
2023-03-01 54.5307046038
2023-04-01 54.1986785285
2023-05-01 54.4963510087
2023-06-01 54.3799775839
2023-07-01 54.4007514855
2023-08-01 54.2753311761
2023-09-01 54.8442952031
2023-10-01 54.7052816742
2023-11-01 54.8361099577
2023-12-01 54.8760120374
2024-01-01 53.7699529302
2024-02-01 54.9961310203
2024-03-01 54.7676548858
2024-04-01 55.0961311693
2024-05-01 55.0284845750
2024-06-01 54.1460046964
2024-07-01 54.7630997372
2024-08-01 54.6530098429
2024-09-01 55.0270024308
2024-10-01 55.3047840536
2024-11-01 55.4359372078
2024-12-01 55.4915436187
2025-01-01 55.5438114604
2025-02-01 55.1957675907
2025-03-01 55.0099573210
2025-04-01 55.0079324614
2025-05-01 54.8582424730
2025-06-01 54.5727669021
2025-07-01 53.7072293115
2025-08-01 54.1130390858
2025-09-01 54.0301165704
2025-10-01 54.0363579965
2025-11-01 53.9092326867
2025-12-01 54.0110553230
2026-01-01 54.9856546146
2026-02-01 53.9430004680
2026-03-01 54.0568030134
2026-04-01 53.8141473966
2026-05-01 53.6414578306
2026-06-01 55.2277786041
2026-07-01 54.8049287156
2026-08-01 54.8974486915
2026-09-01 54.9940530655

Back to Top