Reproduce-able : Could not continue scan with NOLOCK due to data movement.

• brad.mason5

  Hall of Fame

  Points: 3299

  More actions

  October 25, 2017 at 8:15 pm

  #357982

  Hello SQL Server Community,
  Today I ran into an issue with an error I have never seen before.  The error is "Could not continue scan with NOLOCK due to data movement."
  I googled the error and all the articles I read talk about possible data corruption.  But the SQL I am including below can reproduce this error.
  I am not sure if many members have SQL 2008 to play around with.  Maybe you will not get the error.

  The script creates a heap table then inserts employment test data into it. Insert another set of data into a lookup table.
  What I noticed is that DISTINCT and EXCEPT together caused the issue but honestly I am not sure.  

  Hoping for someone out there to have insight.

  FYI: Ran this code on my local machine which is SQL Server 2016 and not able to reproduce.
  It is a lot of test data but  you should just be able to copy the code and paste in to SSMS.

  
USE tempdb
GO

  /**********************************
SQL Server version
Microsoft SQL Server 2008 (SP4) - 10.0.6000.29 (X64)
Build 7601: Service Pack 1

  Get error: randomly does not always occur.
Msg 601, Level 12, State 3, Line 6210
Could not continue scan with NOLOCK due to data movement.

  *****************************/
SET NOCOUNT ON;
SET TRANSaction Isolation level read uncommitted

  IF OBJECT_ID('tempdb..#EmploymentTestData', 'u') IS NOT NULL
  DROP TABLE #EmploymentTestData;

  CREATE TABLE #EmploymentTestData
            (
                QuarterEndDate DATETIME,
                GeoTypeID INT,
                TotalEmployment DEC(12,4)
  );

  INSERT INTO #EmploymentTestData

  SELECT QuarterEndDate = '20170930'
  ,GeoTypeID = 19780
     ,TotalEmployment = 362.6100 UNION ALL

  SELECT QuarterEndDate = '20171231'
  ,GeoTypeID = 19780
     ,TotalEmployment = 363.8700 UNION ALL

  SELECT QuarterEndDate = '20180331'
  ,GeoTypeID = 19780
     ,TotalEmployment = 364.9700 UNION ALL

  SELECT QuarterEndDate = '20180630'
  ,GeoTypeID = 19780
     ,TotalEmployment = 365.9900 UNION ALL

  SELECT QuarterEndDate = '20180930'
  ,GeoTypeID = 19780
     ,TotalEmployment = 367.0000 UNION ALL

  SELECT QuarterEndDate = '20181231'
  ,GeoTypeID = 19780
     ,TotalEmployment = 367.9500 UNION ALL

  SELECT QuarterEndDate = '20190331'
  ,GeoTypeID = 19780
     ,TotalEmployment = 368.8400 UNION ALL

  SELECT QuarterEndDate = '20190630'
  ,GeoTypeID = 19780
     ,TotalEmployment = 369.7600 UNION ALL

  SELECT QuarterEndDate = '20190930'
  ,GeoTypeID = 19780
     ,TotalEmployment = 370.6000 UNION ALL

  SELECT QuarterEndDate = '20191231'
  ,GeoTypeID = 19780
     ,TotalEmployment = 371.1400 UNION ALL

  SELECT QuarterEndDate = '20200331'
  ,GeoTypeID = 19780
     ,TotalEmployment = 371.5700 UNION ALL

  SELECT QuarterEndDate = '20200630'
  ,GeoTypeID = 19780
     ,TotalEmployment = 371.8300 UNION ALL

  SELECT QuarterEndDate = '20200930'
  ,GeoTypeID = 19780
     ,TotalEmployment = 372.1100 UNION ALL

  SELECT QuarterEndDate = '20201231'
  ,GeoTypeID = 19780
     ,TotalEmployment = 372.3600 UNION ALL

  SELECT QuarterEndDate = '20210331'
  ,GeoTypeID = 19780
     ,TotalEmployment = 372.6200 UNION ALL

  SELECT QuarterEndDate = '20210630'
  ,GeoTypeID = 19780
     ,TotalEmployment = 372.9000 UNION ALL

  SELECT QuarterEndDate = '20210930'
  ,GeoTypeID = 19780
     ,TotalEmployment = 373.2500 UNION ALL

  SELECT QuarterEndDate = '20211231'
  ,GeoTypeID = 19780
     ,TotalEmployment = 373.6500 UNION ALL

  SELECT QuarterEndDate = '20220331'
  ,GeoTypeID = 19780
     ,TotalEmployment = 374.0800 UNION ALL

  SELECT QuarterEndDate = '20220630'
  ,GeoTypeID = 19780
     ,TotalEmployment = 374.5600 UNION ALL

  SELECT QuarterEndDate = '20220930'
  ,GeoTypeID = 19780
     ,TotalEmployment = 375.0600 UNION ALL

  SELECT QuarterEndDate = '20221231'
  ,GeoTypeID = 19780
     ,TotalEmployment = 375.6000 UNION ALL

  SELECT QuarterEndDate = '20230331'
  ,GeoTypeID = 19780
     ,TotalEmployment = 376.1500 UNION ALL

  SELECT QuarterEndDate = '20230630'
  ,GeoTypeID = 19780
     ,TotalEmployment = 376.6900 UNION ALL

  SELECT QuarterEndDate = '20230930'
  ,GeoTypeID = 19780
     ,TotalEmployment = 377.2400 UNION ALL

  SELECT QuarterEndDate = '20231231'
  ,GeoTypeID = 19780
     ,TotalEmployment = 377.7900 UNION ALL

  SELECT QuarterEndDate = '20240331'
  ,GeoTypeID = 19780
     ,TotalEmployment = 378.3400 UNION ALL

  SELECT QuarterEndDate = '20240630'
  ,GeoTypeID = 19780
     ,TotalEmployment = 378.8900 UNION ALL

  SELECT QuarterEndDate = '20240930'
  ,GeoTypeID = 19780
     ,TotalEmployment = 379.4600 UNION ALL

  SELECT QuarterEndDate = '20241231'
  ,GeoTypeID = 19780
     ,TotalEmployment = 380.0200 UNION ALL

  SELECT QuarterEndDate = '20250331'
  ,GeoTypeID = 19780
     ,TotalEmployment = 380.5800 UNION ALL

  SELECT QuarterEndDate = '20250630'
  ,GeoTypeID = 19780
     ,TotalEmployment = 381.1500 UNION ALL

  SELECT QuarterEndDate = '20250930'
  ,GeoTypeID = 19780
     ,TotalEmployment = 381.7200 UNION ALL

  SELECT QuarterEndDate = '20251231'
  ,GeoTypeID = 19780
     ,TotalEmployment = 382.3000 UNION ALL

  SELECT QuarterEndDate = '20170930'
  ,GeoTypeID = 27500
     ,TotalEmployment = 71.9700 UNION ALL

  SELECT QuarterEndDate = '20171231'
  ,GeoTypeID = 27500
     ,TotalEmployment = 72.3500 UNION ALL

  SELECT QuarterEndDate = '20180331'
  ,GeoTypeID = 27500
     ,TotalEmployment = 72.6900 UNION ALL

  SELECT QuarterEndDate = '20180630'
  ,GeoTypeID = 27500
     ,TotalEmployment = 73.0200 UNION ALL

  SELECT QuarterEndDate = '20180930'
  ,GeoTypeID = 27500
     ,TotalEmployment = 73.3200 UNION ALL

  SELECT QuarterEndDate = '20181231'
  ,GeoTypeID = 27500
     ,TotalEmployment = 73.6200 UNION ALL

  SELECT QuarterEndDate = '20190331'
  ,GeoTypeID = 27500
     ,TotalEmployment = 73.9100 UNION ALL

  SELECT QuarterEndDate = '20190630'
  ,GeoTypeID = 27500
     ,TotalEmployment = 74.1800 UNION ALL

  SELECT QuarterEndDate = '20190930'
  ,GeoTypeID = 27500
     ,TotalEmployment = 74.4200 UNION ALL

  SELECT QuarterEndDate = '20191231'
  ,GeoTypeID = 27500
     ,TotalEmployment = 74.6200 UNION ALL

  SELECT QuarterEndDate = '20200331'
  ,GeoTypeID = 27500
     ,TotalEmployment = 74.8000 UNION ALL

  SELECT QuarterEndDate = '20200630'
  ,GeoTypeID = 27500
     ,TotalEmployment = 74.9300 UNION ALL

  SELECT QuarterEndDate = '20200930'
  ,GeoTypeID = 27500
     ,TotalEmployment = 75.0500 UNION ALL

  SELECT QuarterEndDate = '20201231'
  ,GeoTypeID = 27500
     ,TotalEmployment = 75.1500 UNION ALL

  SELECT QuarterEndDate = '20210331'
  ,GeoTypeID = 27500
     ,TotalEmployment = 75.2500 UNION ALL

  SELECT QuarterEndDate = '20210630'
  ,GeoTypeID = 27500
     ,TotalEmployment = 75.3600 UNION ALL

  SELECT QuarterEndDate = '20210930'
  ,GeoTypeID = 27500
     ,TotalEmployment = 75.4700 UNION ALL

  SELECT QuarterEndDate = '20211231'
  ,GeoTypeID = 27500
     ,TotalEmployment = 75.6000 UNION ALL

  SELECT QuarterEndDate = '20220331'
  ,GeoTypeID = 27500
     ,TotalEmployment = 75.7300 UNION ALL

  SELECT QuarterEndDate = '20220630'
  ,GeoTypeID = 27500
     ,TotalEmployment = 75.8700 UNION ALL

  SELECT QuarterEndDate = '20220930'
  ,GeoTypeID = 27500
     ,TotalEmployment = 76.0200 UNION ALL

  SELECT QuarterEndDate = '20221231'
  ,GeoTypeID = 27500
     ,TotalEmployment = 76.1800 UNION ALL

  SELECT QuarterEndDate = '20230331'
  ,GeoTypeID = 27500
     ,TotalEmployment = 76.3400 UNION ALL

  SELECT QuarterEndDate = '20230630'
  ,GeoTypeID = 27500
     ,TotalEmployment = 76.4900 UNION ALL

  SELECT QuarterEndDate = '20230930'
  ,GeoTypeID = 27500
     ,TotalEmployment = 76.6400 UNION ALL

  SELECT QuarterEndDate = '20231231'
  ,GeoTypeID = 27500
     ,TotalEmployment = 76.7900 UNION ALL

  SELECT QuarterEndDate = '20240331'
  ,GeoTypeID = 27500
     ,TotalEmployment = 76.9300 UNION ALL

  SELECT QuarterEndDate = '20240630'
  ,GeoTypeID = 27500
     ,TotalEmployment = 77.0700 UNION ALL

  SELECT QuarterEndDate = '20240930'
  ,GeoTypeID = 27500
     ,TotalEmployment = 77.2100 UNION ALL

  SELECT QuarterEndDate = '20241231'
  ,GeoTypeID = 27500
     ,TotalEmployment = 77.3500 UNION ALL

  SELECT QuarterEndDate = '20250331'
  ,GeoTypeID = 27500
     ,TotalEmployment = 77.4800 UNION ALL

  SELECT QuarterEndDate = '20250630'
  ,GeoTypeID = 27500
     ,TotalEmployment = 77.6200 UNION ALL

  SELECT QuarterEndDate = '20250930'
  ,GeoTypeID = 27500
     ,TotalEmployment = 77.7500 UNION ALL

  SELECT QuarterEndDate = '20251231'
  ,GeoTypeID = 27500
     ,TotalEmployment = 77.8800 UNION ALL

  SELECT QuarterEndDate = '20170930'
  ,GeoTypeID = 23060
     ,TotalEmployment = 226.1700 UNION ALL

  SELECT QuarterEndDate = '20171231'
  ,GeoTypeID = 23060
     ,TotalEmployment = 226.8400 UNION ALL

  SELECT QuarterEndDate = '20180331'
  ,GeoTypeID = 23060
     ,TotalEmployment = 227.5400 UNION ALL

  SELECT QuarterEndDate = '20180630'
  ,GeoTypeID = 23060
     ,TotalEmployment = 228.1200 UNION ALL

  SELECT QuarterEndDate = '20180930'
  ,GeoTypeID = 23060
     ,TotalEmployment = 228.8600 UNION ALL

  SELECT QuarterEndDate = '20181231'
  ,GeoTypeID = 23060
     ,TotalEmployment = 229.5700 UNION ALL

  SELECT QuarterEndDate = '20190331'
  ,GeoTypeID = 23060
     ,TotalEmployment = 230.1800 UNION ALL

  SELECT QuarterEndDate = '20190630'
  ,GeoTypeID = 23060
     ,TotalEmployment = 230.8200 UNION ALL

  SELECT QuarterEndDate = '20190930'
  ,GeoTypeID = 23060
     ,TotalEmployment = 231.3600 UNION ALL

  SELECT QuarterEndDate = '20191231'
  ,GeoTypeID = 23060
     ,TotalEmployment = 231.7200 UNION ALL

  SELECT QuarterEndDate = '20200331'
  ,GeoTypeID = 23060
     ,TotalEmployment = 231.9300 UNION ALL

  SELECT QuarterEndDate = '20200630'
  ,GeoTypeID = 23060
     ,TotalEmployment = 232.0500 UNION ALL

  SELECT QuarterEndDate = '20200930'
  ,GeoTypeID = 23060
     ,TotalEmployment = 232.2800 UNION ALL

  SELECT QuarterEndDate = '20201231'
  ,GeoTypeID = 23060
     ,TotalEmployment = 232.4700 UNION ALL

  SELECT QuarterEndDate = '20210331'
  ,GeoTypeID = 23060
     ,TotalEmployment = 232.6600 UNION ALL

  SELECT QuarterEndDate = '20210630'
  ,GeoTypeID = 23060
     ,TotalEmployment = 232.8400 UNION ALL

  SELECT QuarterEndDate = '20210930'
  ,GeoTypeID = 23060
     ,TotalEmployment = 233.0600 UNION ALL

  SELECT QuarterEndDate = '20211231'
  ,GeoTypeID = 23060
     ,TotalEmployment = 233.3400 UNION ALL

  SELECT QuarterEndDate = '20220331'
  ,GeoTypeID = 23060
     ,TotalEmployment = 233.6500 UNION ALL

  SELECT QuarterEndDate = '20220630'
  ,GeoTypeID = 23060
     ,TotalEmployment = 233.9900 UNION ALL

  SELECT QuarterEndDate = '20220930'
  ,GeoTypeID = 23060
     ,TotalEmployment = 234.3400 UNION ALL

  SELECT QuarterEndDate = '20221231'
  ,GeoTypeID = 23060
     ,TotalEmployment = 234.6900 UNION ALL

  SELECT QuarterEndDate = '20230331'
  ,GeoTypeID = 23060
     ,TotalEmployment = 235.0500 UNION ALL

  SELECT QuarterEndDate = '20230630'
  ,GeoTypeID = 23060
     ,TotalEmployment = 235.4100 UNION ALL

  SELECT QuarterEndDate = '20230930'
  ,GeoTypeID = 23060
     ,TotalEmployment = 235.7900 UNION ALL

  SELECT QuarterEndDate = '20231231'
  ,GeoTypeID = 23060
     ,TotalEmployment = 236.1500 UNION ALL

  SELECT QuarterEndDate = '20240331'
  ,GeoTypeID = 23060
     ,TotalEmployment = 236.5000 UNION ALL

  SELECT QuarterEndDate = '20240630'
  ,GeoTypeID = 23060
     ,TotalEmployment = 236.8500 UNION ALL

  SELECT QuarterEndDate = '20240930'
  ,GeoTypeID = 23060
     ,TotalEmployment = 237.2200 UNION ALL

  SELECT QuarterEndDate = '20241231'
  ,GeoTypeID = 23060
     ,TotalEmployment = 237.5900 UNION ALL

  SELECT QuarterEndDate = '20250331'
  ,GeoTypeID = 23060
     ,TotalEmployment = 237.9500 UNION ALL

  SELECT QuarterEndDate = '20250630'
  ,GeoTypeID = 23060
     ,TotalEmployment = 238.3100 UNION ALL

  SELECT QuarterEndDate = '20250930'
  ,GeoTypeID = 23060
     ,TotalEmployment = 238.6700 UNION ALL

  SELECT QuarterEndDate = '20251231'
  ,GeoTypeID = 23060
     ,TotalEmployment = 239.0400 UNION ALL

  SELECT QuarterEndDate = '20170930'
  ,GeoTypeID = 33780
     ,TotalEmployment = 44.0600 UNION ALL

  SELECT QuarterEndDate = '20171231'
  ,GeoTypeID = 33780
     ,TotalEmployment = 44.2300 UNION ALL

  SELECT QuarterEndDate = '20180331'
  ,GeoTypeID = 33780
     ,TotalEmployment = 44.4000 UNION ALL

  SELECT QuarterEndDate = '20180630'
  ,GeoTypeID = 33780
     ,TotalEmployment = 44.5600 UNION ALL

  SELECT QuarterEndDate = '20180930'
  ,GeoTypeID = 33780
     ,TotalEmployment = 44.7000 UNION ALL

  SELECT QuarterEndDate = '20181231'
  ,GeoTypeID = 33780
     ,TotalEmployment = 44.8200 UNION ALL

  SELECT QuarterEndDate = '20190331'
  ,GeoTypeID = 33780
     ,TotalEmployment = 44.9500 UNION ALL

  SELECT QuarterEndDate = '20190630'
  ,GeoTypeID = 33780
     ,TotalEmployment = 45.0700 UNION ALL

  SELECT QuarterEndDate = '20190930'
  ,GeoTypeID = 33780
     ,TotalEmployment = 45.1500 UNION ALL

  SELECT QuarterEndDate = '20191231'
  ,GeoTypeID = 33780
     ,TotalEmployment = 45.2000 UNION ALL

  SELECT QuarterEndDate = '20200331'
  ,GeoTypeID = 33780
     ,TotalEmployment = 45.2100 UNION ALL

  SELECT QuarterEndDate = '20200630'
  ,GeoTypeID = 33780
     ,TotalEmployment = 45.1900 UNION ALL

  SELECT QuarterEndDate = '20200930'
  ,GeoTypeID = 33780
     ,TotalEmployment = 45.1700 UNION ALL

  SELECT QuarterEndDate = '20201231'
  ,GeoTypeID = 33780
     ,TotalEmployment = 45.1700 UNION ALL

  SELECT QuarterEndDate = '20210331'
  ,GeoTypeID = 33780
     ,TotalEmployment = 45.1600 UNION ALL

  SELECT QuarterEndDate = '20210630'
  ,GeoTypeID = 33780
     ,TotalEmployment = 45.1700 UNION ALL

  SELECT QuarterEndDate = '20210930'
  ,GeoTypeID = 33780
     ,TotalEmployment = 45.1900 UNION ALL

  SELECT QuarterEndDate = '20211231'
  ,GeoTypeID = 33780
     ,TotalEmployment = 45.2100 UNION ALL

  SELECT QuarterEndDate = '20220331'
  ,GeoTypeID = 33780
     ,TotalEmployment = 45.2300 UNION ALL

  SELECT QuarterEndDate = '20220630'
  ,GeoTypeID = 33780
     ,TotalEmployment = 45.2600 UNION ALL

  SELECT QuarterEndDate = '20220930'
  ,GeoTypeID = 33780
     ,TotalEmployment = 45.3100 UNION ALL

  SELECT QuarterEndDate = '20221231'
  ,GeoTypeID = 33780
     ,TotalEmployment = 45.3600 UNION ALL

  SELECT QuarterEndDate = '20230331'
  ,GeoTypeID = 33780
     ,TotalEmployment = 45.4200 UNION ALL

  SELECT QuarterEndDate = '20230630'
  ,GeoTypeID = 33780
     ,TotalEmployment = 45.4700 UNION ALL

  SELECT QuarterEndDate = '20230930'
  ,GeoTypeID = 33780
     ,TotalEmployment = 45.5200 UNION ALL

  SELECT QuarterEndDate = '20231231'
  ,GeoTypeID = 33780
     ,TotalEmployment = 45.5600 UNION ALL

  SELECT QuarterEndDate = '20240331'
  ,GeoTypeID = 33780
     ,TotalEmployment = 45.6100 UNION ALL

  SELECT QuarterEndDate = '20240630'
  ,GeoTypeID = 33780
     ,TotalEmployment = 45.6600 UNION ALL

  SELECT QuarterEndDate = '20240930'
  ,GeoTypeID = 33780
     ,TotalEmployment = 45.7000 UNION ALL

  SELECT QuarterEndDate = '20241231'
  ,GeoTypeID = 33780
     ,TotalEmployment = 45.7500 UNION ALL

  SELECT QuarterEndDate = '20250331'
  ,GeoTypeID = 33780
     ,TotalEmployment = 45.8000 UNION ALL

  SELECT QuarterEndDate = '20250630'
  ,GeoTypeID = 33780
     ,TotalEmployment = 45.8400 UNION ALL

  SELECT QuarterEndDate = '20250930'
  ,GeoTypeID = 33780
     ,TotalEmployment = 45.8900 UNION ALL

  SELECT QuarterEndDate = '20251231'
  ,GeoTypeID = 33780
     ,TotalEmployment = 45.9300 UNION ALL

  SELECT QuarterEndDate = '20170930'
  ,GeoTypeID = 24340
     ,TotalEmployment = 551.9100 UNION ALL

  SELECT QuarterEndDate = '20171231'
  ,GeoTypeID = 24340
     ,TotalEmployment = 554.1300 UNION ALL

  SELECT QuarterEndDate = '20180331'
  ,GeoTypeID = 24340
     ,TotalEmployment = 556.5400 UNION ALL

  SELECT QuarterEndDate = '20180630'
  ,GeoTypeID = 24340
     ,TotalEmployment = 558.7200 UNION ALL

  SELECT QuarterEndDate = '20180930'
  ,GeoTypeID = 24340
     ,TotalEmployment = 560.8000 UNION ALL

  SELECT QuarterEndDate = '20181231'
  ,GeoTypeID = 24340
     ,TotalEmployment = 562.8800 UNION ALL

  SELECT QuarterEndDate = '20190331'
  ,GeoTypeID = 24340
     ,TotalEmployment = 564.8700 UNION ALL

  SELECT QuarterEndDate = '20190630'
  ,GeoTypeID = 24340
     ,TotalEmployment = 566.8800 UNION ALL

  SELECT QuarterEndDate = '20190930'
  ,GeoTypeID = 24340
     ,TotalEmployment = 568.6000 UNION ALL

  SELECT QuarterEndDate = '20191231'
  ,GeoTypeID = 24340
     ,TotalEmployment = 569.7300 UNION ALL

  SELECT QuarterEndDate = '20200331'
  ,GeoTypeID = 24340
     ,TotalEmployment = 570.6600 UNION ALL

  SELECT QuarterEndDate = '20200630'
  ,GeoTypeID = 24340
     ,TotalEmployment = 571.3000 UNION ALL

  SELECT QuarterEndDate = '20200930'
  ,GeoTypeID = 24340
     ,TotalEmployment = 571.9800 UNION ALL

  SELECT QuarterEndDate = '20201231'
  ,GeoTypeID = 24340
     ,TotalEmployment = 572.6100 UNION ALL

  SELECT QuarterEndDate = '20210331'
  ,GeoTypeID = 24340
     ,TotalEmployment = 573.2800 UNION ALL

  SELECT QuarterEndDate = '20210630'
  ,GeoTypeID = 24340
     ,TotalEmployment = 573.9900 UNION ALL

  SELECT QuarterEndDate = '20210930'
  ,GeoTypeID = 24340
     ,TotalEmployment = 574.7700 UNION ALL

  SELECT QuarterEndDate = '20211231'
  ,GeoTypeID = 24340
     ,TotalEmployment = 575.6700 UNION ALL

  SELECT QuarterEndDate = '20220331'
  ,GeoTypeID = 24340
     ,TotalEmployment = 576.6500 UNION ALL

  SELECT QuarterEndDate = '20220630'
  ,GeoTypeID = 24340
     ,TotalEmployment = 577.7000 UNION ALL

  SELECT QuarterEndDate = '20220930'
  ,GeoTypeID = 24340
     ,TotalEmployment = 578.8200 UNION ALL

  SELECT QuarterEndDate = '20221231'
  ,GeoTypeID = 24340
     ,TotalEmployment = 580.0100 UNION ALL

  SELECT QuarterEndDate = '20230331'
  ,GeoTypeID = 24340
     ,TotalEmployment = 581.2500 UNION ALL

  SELECT QuarterEndDate = '20230630'
  ,GeoTypeID = 24340
     ,TotalEmployment = 582.4800 UNION ALL

  SELECT QuarterEndDate = '20230930'
  ,GeoTypeID = 24340
     ,TotalEmployment = 583.7200 UNION ALL

  SELECT QuarterEndDate = '20231231'
  ,GeoTypeID = 24340
     ,TotalEmployment = 584.9700 UNION ALL

  SELECT QuarterEndDate = '20240331'
  ,GeoTypeID = 24340
     ,TotalEmployment = 586.2100 UNION ALL

  SELECT QuarterEndDate = '20240630'
  ,GeoTypeID = 24340
     ,TotalEmployment = 587.4500 UNION ALL

  SELECT QuarterEndDate = '20240930'
  ,GeoTypeID = 24340
     ,TotalEmployment = 588.6800 UNION ALL

  SELECT QuarterEndDate = '20241231'
  ,GeoTypeID = 24340
     ,TotalEmployment = 589.9100 UNION ALL

  SELECT QuarterEndDate = '20250331'
  ,GeoTypeID = 24340
     ,TotalEmployment = 591.1600 UNION ALL

  SELECT QuarterEndDate = '20250630'
  ,GeoTypeID = 24340
     ,TotalEmployment = 592.4200 UNION ALL

  SELECT QuarterEndDate = '20250930'
  ,GeoTypeID = 24340
     ,TotalEmployment = 593.7200 UNION ALL

  SELECT QuarterEndDate = '20251231'
  ,GeoTypeID = 24340
     ,TotalEmployment = 595.0200 UNION ALL

  SELECT QuarterEndDate = '20170930'
  ,GeoTypeID = 30700
     ,TotalEmployment = 190.8400 UNION ALL

  SELECT QuarterEndDate = '20171231'
  ,GeoTypeID = 30700
     ,TotalEmployment = 191.5600 UNION ALL

  SELECT QuarterEndDate = '20180331'
  ,GeoTypeID = 30700
     ,TotalEmployment = 192.2700 UNION ALL

  SELECT QuarterEndDate = '20180630'
  ,GeoTypeID = 30700
     ,TotalEmployment = 192.9400 UNION ALL

  SELECT QuarterEndDate = '20180930'
  ,GeoTypeID = 30700
     ,TotalEmployment = 193.5800 UNION ALL

  SELECT QuarterEndDate = '20181231'
  ,GeoTypeID = 30700
     ,TotalEmployment = 194.1800 UNION ALL

  SELECT QuarterEndDate = '20190331'
  ,GeoTypeID = 30700
     ,TotalEmployment = 194.7500 UNION ALL

  SELECT QuarterEndDate = '20190630'
  ,GeoTypeID = 30700
     ,TotalEmployment = 195.3200 UNION ALL

  SELECT QuarterEndDate = '20190930'
  ,GeoTypeID = 30700
     ,TotalEmployment = 195.7400 UNION ALL

  SELECT QuarterEndDate = '20191231'
  ,GeoTypeID = 30700
     ,TotalEmployment = 196.0400 UNION ALL

  SELECT QuarterEndDate = '20200331'
  ,GeoTypeID = 30700
     ,TotalEmployment = 196.2500 UNION ALL

  SELECT QuarterEndDate = '20200630'
  ,GeoTypeID = 30700
     ,TotalEmployment = 196.3600 UNION ALL

  SELECT QuarterEndDate = '20200930'
  ,GeoTypeID = 30700
     ,TotalEmployment = 196.5100 UNION ALL

  SELECT QuarterEndDate = '20201231'
  ,GeoTypeID = 30700
     ,TotalEmployment = 196.6600 UNION ALL

  SELECT QuarterEndDate = '20210331'
  ,GeoTypeID = 30700
     ,TotalEmployment = 196.8200 UNION ALL

  SELECT QuarterEndDate = '20210630'
  ,GeoTypeID = 30700
     ,TotalEmployment = 197.0300 UNION ALL

  SELECT QuarterEndDate = '20210930'
  ,GeoTypeID = 30700
     ,TotalEmployment = 197.2400 UNION ALL

  SELECT QuarterEndDate = '20211231'
  ,GeoTypeID = 30700
     ,TotalEmployment = 197.5100 UNION ALL

  SELECT QuarterEndDate = '20220331'
  ,GeoTypeID = 30700
     ,TotalEmployment = 197.7800 UNION ALL

  SELECT QuarterEndDate = '20220630'
  ,GeoTypeID = 30700
     ,TotalEmployment = 198.0900 UNION ALL

  SELECT QuarterEndDate = '20220930'
  ,GeoTypeID = 30700
     ,TotalEmployment = 198.4200 UNION ALL

  SELECT QuarterEndDate = '20221231'
  ,GeoTypeID = 30700
     ,TotalEmployment = 198.7300 UNION ALL

  SELECT QuarterEndDate = '20230331'
  ,GeoTypeID = 30700
     ,TotalEmployment = 199.0700 UNION ALL

  SELECT QuarterEndDate = '20230630'
  ,GeoTypeID = 30700
     ,TotalEmployment = 199.3900 UNION ALL

  SELECT QuarterEndDate = '20230930'
  ,GeoTypeID = 30700
     ,TotalEmployment = 199.6800 UNION ALL

  SELECT QuarterEndDate = '20231231'
  ,GeoTypeID = 30700
     ,TotalEmployment = 199.9700 UNION ALL

  SELECT QuarterEndDate = '20240331'
  ,GeoTypeID = 30700
     ,TotalEmployment = 200.2400 UNION ALL

  SELECT QuarterEndDate = '20240630'
  ,GeoTypeID = 30700
     ,TotalEmployment = 200.5200 UNION ALL

  SELECT QuarterEndDate = '20240930'
  ,GeoTypeID = 30700
     ,TotalEmployment = 200.8100 UNION ALL

  SELECT QuarterEndDate = '20241231'
  ,GeoTypeID = 30700
     ,TotalEmployment = 201.1000 UNION ALL

  SELECT QuarterEndDate = '20250331'
  ,GeoTypeID = 30700
     ,TotalEmployment = 201.3800 UNION ALL

  SELECT QuarterEndDate = '20250630'
  ,GeoTypeID = 30700
     ,TotalEmployment = 201.6700 UNION ALL

  SELECT QuarterEndDate = '20250930'
  ,GeoTypeID = 30700
     ,TotalEmployment = 201.9500 UNION ALL

  SELECT QuarterEndDate = '20251231'
  ,GeoTypeID = 30700
     ,TotalEmployment = 202.2400 UNION ALL

  SELECT QuarterEndDate = '20170930'
  ,GeoTypeID = 10420
     ,TotalEmployment = 352.3000 UNION ALL

  SELECT QuarterEndDate = '20171231'
  ,GeoTypeID = 10420
     ,TotalEmployment = 353.7000 UNION ALL

  SELECT QuarterEndDate = '20180331'
  ,GeoTypeID = 10420
     ,TotalEmployment = 354.9400 UNION ALL

  SELECT QuarterEndDate = '20180630'
  ,GeoTypeID = 10420
     ,TotalEmployment = 356.0100 UNION ALL

  SELECT QuarterEndDate = '20180930'
  ,GeoTypeID = 10420
     ,TotalEmployment = 357.0900 UNION ALL

  SELECT QuarterEndDate = '20181231'
  ,GeoTypeID = 10420
     ,TotalEmployment = 358.1500 UNION ALL

  SELECT QuarterEndDate = '20190331'
  ,GeoTypeID = 10420
     ,TotalEmployment = 359.1100 UNION ALL

  SELECT QuarterEndDate = '20190630'
  ,GeoTypeID = 10420
     ,TotalEmployment = 360.1000 UNION ALL

  SELECT QuarterEndDate = '20190930'
  ,GeoTypeID = 10420
     ,TotalEmployment = 360.9100 UNION ALL

  SELECT QuarterEndDate = '20191231'
  ,GeoTypeID = 10420
     ,TotalEmployment = 361.3800 UNION ALL

  SELECT QuarterEndDate = '20200331'
  ,GeoTypeID = 10420
     ,TotalEmployment = 361.7100 UNION ALL

  SELECT QuarterEndDate = '20200630'
  ,GeoTypeID = 10420
     ,TotalEmployment = 361.9100 UNION ALL

  SELECT QuarterEndDate = '20200930'
  ,GeoTypeID = 10420
     ,TotalEmployment = 362.1500 UNION ALL

  SELECT QuarterEndDate = '20201231'
  ,GeoTypeID = 10420
     ,TotalEmployment = 362.3000 UNION ALL

  SELECT QuarterEndDate = '20210331'
  ,GeoTypeID = 10420
     ,TotalEmployment = 362.5000 UNION ALL

  SELECT QuarterEndDate = '20210630'
  ,GeoTypeID = 10420
     ,TotalEmployment = 362.7100 UNION ALL

  SELECT QuarterEndDate = '20210930'
  ,GeoTypeID = 10420
     ,TotalEmployment = 362.9400 UNION ALL

  SELECT QuarterEndDate = '20211231'
  ,GeoTypeID = 10420
     ,TotalEmployment = 363.2700 UNION ALL

  SELECT QuarterEndDate = '20220331'
  ,GeoTypeID = 10420
     ,TotalEmployment = 363.6300 UNION ALL

  SELECT QuarterEndDate = '20220630'
  ,GeoTypeID = 10420
     ,TotalEmployment = 364.0600 UNION ALL

  SELECT QuarterEndDate = '20220930'
  ,GeoTypeID = 10420
     ,TotalEmployment = 364.4900 UNION ALL

  SELECT QuarterEndDate = '20221231'
  ,GeoTypeID = 10420
     ,TotalEmployment = 364.9200 UNION ALL

  SELECT QuarterEndDate = '20230331'
  ,GeoTypeID = 10420
     ,TotalEmployment = 365.3700 UNION ALL

  SELECT QuarterEndDate = '20230630'
  ,GeoTypeID = 10420
     ,TotalEmployment = 365.8100 UNION ALL

  SELECT QuarterEndDate = '20230930'
  ,GeoTypeID = 10420
     ,TotalEmployment = 366.2800 UNION ALL

  SELECT QuarterEndDate = '20231231'
  ,GeoTypeID = 10420
     ,TotalEmployment = 366.7300 UNION ALL

  SELECT QuarterEndDate = '20240331'
  ,GeoTypeID = 10420
     ,TotalEmployment = 367.1700 UNION ALL

  SELECT QuarterEndDate = '20240630'
  ,GeoTypeID = 10420
     ,TotalEmployment = 367.6200 UNION ALL

  SELECT QuarterEndDate = '20240930'
  ,GeoTypeID = 10420
     ,TotalEmployment = 368.0700 UNION ALL

  SELECT QuarterEndDate = '20241231'
  ,GeoTypeID = 10420
     ,TotalEmployment = 368.5400 UNION ALL

  SELECT QuarterEndDate = '20250331'
  ,GeoTypeID = 10420
     ,TotalEmployment = 368.9800 UNION ALL

  SELECT QuarterEndDate = '20250630'
  ,GeoTypeID = 10420
     ,TotalEmployment = 369.4400 UNION ALL

  SELECT QuarterEndDate = '20250930'
  ,GeoTypeID = 10420
     ,TotalEmployment = 369.9000 UNION ALL

  SELECT QuarterEndDate = '20251231'
  ,GeoTypeID = 10420
     ,TotalEmployment = 370.3700 UNION ALL

  SELECT QuarterEndDate = '20170930'
  ,GeoTypeID = 43100
     ,TotalEmployment = 63.2700 UNION ALL

  SELECT QuarterEndDate = '20171231'
  ,GeoTypeID = 43100
     ,TotalEmployment = 63.5800 UNION ALL

  SELECT QuarterEndDate = '20180331'
  ,GeoTypeID = 43100
     ,TotalEmployment = 63.8600 UNION ALL

  SELECT QuarterEndDate = '20180630'
  ,GeoTypeID = 43100
     ,TotalEmployment = 64.1300 UNION ALL

  SELECT QuarterEndDate = '20180930'
  ,GeoTypeID = 43100
     ,TotalEmployment = 64.3600 UNION ALL

  SELECT QuarterEndDate = '20181231'
  ,GeoTypeID = 43100
     ,TotalEmployment = 64.5700 UNION ALL

  SELECT QuarterEndDate = '20190331'
  ,GeoTypeID = 43100
     ,TotalEmployment = 64.7400 UNION ALL

  SELECT QuarterEndDate = '20190630'
  ,GeoTypeID = 43100
     ,TotalEmployment = 64.8900 UNION ALL

  SELECT QuarterEndDate = '20190930'
  ,GeoTypeID = 43100
     ,TotalEmployment = 65.0100 UNION ALL

  SELECT QuarterEndDate = '20191231'
  ,GeoTypeID = 43100
     ,TotalEmployment = 65.1100 UNION ALL

  SELECT QuarterEndDate = '20200331'
  ,GeoTypeID = 43100
     ,TotalEmployment = 65.1900 UNION ALL

  SELECT QuarterEndDate = '20200630'
  ,GeoTypeID = 43100
     ,TotalEmployment = 65.2600 UNION ALL

  SELECT QuarterEndDate = '20200930'
  ,GeoTypeID = 43100
     ,TotalEmployment = 65.3100 UNION ALL

  SELECT QuarterEndDate = '20201231'
  ,GeoTypeID = 43100
     ,TotalEmployment = 65.3700 UNION ALL

  SELECT QuarterEndDate = '20210331'
  ,GeoTypeID = 43100
     ,TotalEmployment = 65.4200 UNION ALL

  SELECT QuarterEndDate = '20210630'
  ,GeoTypeID = 43100
     ,TotalEmployment = 65.4800 UNION ALL

  SELECT QuarterEndDate = '20210930'
  ,GeoTypeID = 43100
     ,TotalEmployment = 65.5400 UNION ALL

  SELECT QuarterEndDate = '20211231'
  ,GeoTypeID = 43100
     ,TotalEmployment = 65.6000 UNION ALL

  SELECT QuarterEndDate = '20220331'
  ,GeoTypeID = 43100
     ,TotalEmployment = 65.6700 UNION ALL

  SELECT QuarterEndDate = '20220630'
  ,GeoTypeID = 43100
     ,TotalEmployment = 65.7400 UNION ALL

  SELECT QuarterEndDate = '20220930'
  ,GeoTypeID = 43100
     ,TotalEmployment = 65.8100 UNION ALL

  SELECT QuarterEndDate = '20221231'
  ,GeoTypeID = 43100
     ,TotalEmployment = 65.8900 UNION ALL

  SELECT QuarterEndDate = '20230331'
  ,GeoTypeID = 43100
     ,TotalEmployment = 65.9700 UNION ALL

  SELECT QuarterEndDate = '20230630'
  ,GeoTypeID = 43100
     ,TotalEmployment = 66.0500 UNION ALL

  SELECT QuarterEndDate = '20230930'
  ,GeoTypeID = 43100
     ,TotalEmployment = 66.1300 UNION ALL

  SELECT QuarterEndDate = '20231231'
  ,GeoTypeID = 43100
     ,TotalEmployment = 66.2100 UNION ALL

  SELECT QuarterEndDate = '20240331'
  ,GeoTypeID = 43100
     ,TotalEmployment = 66.3000 UNION ALL

  SELECT QuarterEndDate = '20240630'
  ,GeoTypeID = 43100
     ,TotalEmployment = 66.3900 UNION ALL

  SELECT QuarterEndDate = '20240930'
  ,GeoTypeID = 43100
     ,TotalEmployment = 66.4800 UNION ALL

  SELECT QuarterEndDate = '20241231'
  ,GeoTypeID = 43100
     ,TotalEmployment = 66.5600 UNION ALL

  SELECT QuarterEndDate = '20250331'
  ,GeoTypeID = 43100
     ,TotalEmployment = 66.6500 UNION ALL

  SELECT QuarterEndDate = '20250630'
  ,GeoTypeID = 43100
     ,TotalEmployment = 66.7400 UNION ALL

  SELECT QuarterEndDate = '20250930'
  ,GeoTypeID = 43100
     ,TotalEmployment = 66.8300 UNION ALL

  SELECT QuarterEndDate = '20251231'
  ,GeoTypeID = 43100
     ,TotalEmployment = 66.9200 UNION ALL

  SELECT QuarterEndDate = '20170930'
  ,GeoTypeID = 24580
     ,TotalEmployment = 179.7400 UNION ALL

  SELECT QuarterEndDate = '20171231'
  ,GeoTypeID = 24580
     ,TotalEmployment = 180.5800 UNION ALL

  SELECT QuarterEndDate = '20180331'
  ,GeoTypeID = 24580
     ,TotalEmployment = 181.3300 UNION ALL

  SELECT QuarterEndDate = '20180630'
  ,GeoTypeID = 24580
     ,TotalEmployment = 181.9600 UNION ALL

  SELECT QuarterEndDate = '20180930'
  ,GeoTypeID = 24580
     ,TotalEmployment = 182.4900 UNION ALL

  SELECT QuarterEndDate = '20181231'
  ,GeoTypeID = 24580
     ,TotalEmployment = 183.0300 UNION ALL

  SELECT QuarterEndDate = '20190331'
  ,GeoTypeID = 24580
     ,TotalEmployment = 183.5300 UNION ALL

  SELECT QuarterEndDate = '20190630'
  ,GeoTypeID = 24580
     ,TotalEmployment = 183.9400 UNION ALL

  SELECT QuarterEndDate = '20190930'
  ,GeoTypeID = 24580
     ,TotalEmployment = 184.3400 UNION ALL

  SELECT QuarterEndDate = '20191231'
  ,GeoTypeID = 24580
     ,TotalEmployment = 184.6200 UNION ALL

  SELECT QuarterEndDate = '20200331'
  ,GeoTypeID = 24580
     ,TotalEmployment = 184.8700 UNION ALL

  SELECT QuarterEndDate = '20200630'
  ,GeoTypeID = 24580
     ,TotalEmployment = 185.0700 UNION ALL

  SELECT QuarterEndDate = '20200930'
  ,GeoTypeID = 24580
     ,TotalEmployment = 185.2100 UNION ALL

  SELECT QuarterEndDate = '20201231'
  ,GeoTypeID = 24580
     ,TotalEmployment = 185.3900 UNION ALL

  SELECT QuarterEndDate = '20210331'
  ,GeoTypeID = 24580
     ,TotalEmployment = 185.5800 UNION ALL

  SELECT QuarterEndDate = '20210630'
  ,GeoTypeID = 24580
     ,TotalEmployment = 185.7200 UNION ALL

  SELECT QuarterEndDate = '20210930'
  ,GeoTypeID = 24580
     ,TotalEmployment = 185.9100 UNION ALL

  SELECT QuarterEndDate = '20211231'
  ,GeoTypeID = 24580
     ,TotalEmployment = 186.1100 UNION ALL

  SELECT QuarterEndDate = '20220331'
  ,GeoTypeID = 24580
     ,TotalEmployment = 186.3400 UNION ALL

  SELECT QuarterEndDate = '20220630'
  ,GeoTypeID = 24580
     ,TotalEmployment = 186.5500 UNION ALL

  SELECT QuarterEndDate = '20220930'
  ,GeoTypeID = 24580
     ,TotalEmployment = 186.7700 UNION ALL

  SELECT QuarterEndDate = '20221231'
  ,GeoTypeID = 24580
     ,TotalEmployment = 187.0300 UNION ALL

  SELECT QuarterEndDate = '20230331'
  ,GeoTypeID = 24580
     ,TotalEmployment = 187.2700 UNION ALL

  SELECT QuarterEndDate = '20230630'
  ,GeoTypeID = 24580
     ,TotalEmployment = 187.5100 UNION ALL

  SELECT QuarterEndDate = '20230930'
  ,GeoTypeID = 24580
     ,TotalEmployment = 187.7800 UNION ALL

  SELECT QuarterEndDate = '20231231'
  ,GeoTypeID = 24580
     ,TotalEmployment = 188.0400 UNION ALL

  SELECT QuarterEndDate = '20240331'
  ,GeoTypeID = 24580
     ,TotalEmployment = 188.3300 UNION ALL

  SELECT QuarterEndDate = '20240630'
  ,GeoTypeID = 24580
     ,TotalEmployment = 188.6000 UNION ALL

  SELECT QuarterEndDate = '20240930'
  ,GeoTypeID = 24580
     ,TotalEmployment = 188.8600 UNION ALL

  SELECT QuarterEndDate = '20241231'
  ,GeoTypeID = 24580
     ,TotalEmployment = 189.1300 UNION ALL

  SELECT QuarterEndDate = '20250331'
  ,GeoTypeID = 24580
     ,TotalEmployment = 189.4200 UNION ALL

  SELECT QuarterEndDate = '20250630'
  ,GeoTypeID = 24580
     ,TotalEmployment = 189.6900 UNION ALL

  SELECT QuarterEndDate = '20250930'
  ,GeoTypeID = 24580
     ,TotalEmployment = 189.9700 UNION ALL

  SELECT QuarterEndDate = '20251231'
  ,GeoTypeID = 24580
     ,TotalEmployment = 190.2600 UNION ALL

  SELECT QuarterEndDate = '20170930'
  ,GeoTypeID = 37900
     ,TotalEmployment = 180.3500 UNION ALL

  SELECT QuarterEndDate = '20171231'
  ,GeoTypeID = 37900
     ,TotalEmployment = 180.8300 UNION ALL

  SELECT QuarterEndDate = '20180331'
  ,GeoTypeID = 37900
     ,TotalEmployment = 181.2600 UNION ALL

  SELECT QuarterEndDate = '20180630'
  ,GeoTypeID = 37900
     ,TotalEmployment = 181.6300 UNION ALL

  SELECT QuarterEndDate = '20180930'
  ,GeoTypeID = 37900
     ,TotalEmployment = 181.9800 UNION ALL

  SELECT QuarterEndDate = '20181231'
  ,GeoTypeID = 37900
     ,TotalEmployment = 182.2800 UNION ALL

  SELECT QuarterEndDate = '20190331'
  ,GeoTypeID = 37900
     ,TotalEmployment = 182.5200 UNION ALL

  SELECT QuarterEndDate = '20190630'
  ,GeoTypeID = 37900
     ,TotalEmployment = 182.7400 UNION ALL

  SELECT QuarterEndDate = '20190930'
  ,GeoTypeID = 37900
     ,TotalEmployment = 182.8700 UNION ALL

  SELECT QuarterEndDate = '20191231'
  ,GeoTypeID = 37900
     ,TotalEmployment = 182.8500 UNION ALL

  SELECT QuarterEndDate = '20200331'
  ,GeoTypeID = 37900
     ,TotalEmployment = 182.7800 UNION ALL

  SELECT QuarterEndDate = '20200630'
  ,GeoTypeID = 37900
     ,TotalEmployment = 182.6300 UNION ALL

  SELECT QuarterEndDate = '20200930'
  ,GeoTypeID = 37900
     ,TotalEmployment = 182.4800 UNION ALL

  SELECT QuarterEndDate = '20201231'
  ,GeoTypeID = 37900
     ,TotalEmployment = 182.3300 UNION ALL

  SELECT QuarterEndDate = '20210331'
  ,GeoTypeID = 37900
     ,TotalEmployment = 182.1900 UNION ALL

  SELECT QuarterEndDate = '20210630'
  ,GeoTypeID = 37900
     ,TotalEmployment = 182.0500 UNION ALL

  SELECT QuarterEndDate = '20210930'
  ,GeoTypeID = 37900
     ,TotalEmployment = 181.9400 UNION ALL

  SELECT QuarterEndDate = '20211231'
  ,GeoTypeID = 37900
     ,TotalEmployment = 181.8500 UNION ALL

  SELECT QuarterEndDate = '20220331'
  ,GeoTypeID = 37900
     ,TotalEmployment = 181.7700 UNION ALL

  SELECT QuarterEndDate = '20220630'
  ,GeoTypeID = 37900
     ,TotalEmployment = 181.7100 UNION ALL

  SELECT QuarterEndDate = '20220930'
  ,GeoTypeID = 37900
     ,TotalEmployment = 181.6700 UNION ALL

  SELECT QuarterEndDate = '20221231'
  ,GeoTypeID = 37900
     ,TotalEmployment = 181.6500 UNION ALL

  SELECT QuarterEndDate = '20230331'
  ,GeoTypeID = 37900
     ,TotalEmployment = 181.6300 UNION ALL

  SELECT QuarterEndDate = '20230630'
  ,GeoTypeID = 37900
     ,TotalEmployment = 181.6000 UNION ALL

  SELECT QuarterEndDate = '20230930'
  ,GeoTypeID = 37900
     ,TotalEmployment = 181.5900 UNION ALL

  SELECT QuarterEndDate = '20231231'
  ,GeoTypeID = 37900
     ,TotalEmployment = 181.5800 UNION ALL

  SELECT QuarterEndDate = '20240331'
  ,GeoTypeID = 37900
     ,TotalEmployment = 181.5700 UNION ALL

  SELECT QuarterEndDate = '20240630'
  ,GeoTypeID = 37900
     ,TotalEmployment = 181.5600 UNION ALL

  SELECT QuarterEndDate = '20240930'
  ,GeoTypeID = 37900
     ,TotalEmployment = 181.5500 UNION ALL

  SELECT QuarterEndDate = '20241231'
  ,GeoTypeID = 37900
     ,TotalEmployment = 181.5500 UNION ALL

  SELECT QuarterEndDate = '20250331'
  ,GeoTypeID = 37900
     ,TotalEmployment = 181.5400 UNION ALL

  SELECT QuarterEndDate = '20250630'
  ,GeoTypeID = 37900
     ,TotalEmployment = 181.5500 UNION ALL

  SELECT QuarterEndDate = '20250930'
  ,GeoTypeID = 37900
     ,TotalEmployment = 181.5500 UNION ALL

  SELECT QuarterEndDate = '20251231'
  ,GeoTypeID = 37900
     ,TotalEmployment = 181.5700 UNION ALL

  SELECT QuarterEndDate = '20170930'
  ,GeoTypeID = 48620
     ,TotalEmployment = 310.2800 UNION ALL

  SELECT QuarterEndDate = '20171231'
  ,GeoTypeID = 48620
     ,TotalEmployment = 312.1500 UNION ALL

  SELECT QuarterEndDate = '20180331'
  ,GeoTypeID = 48620
     ,TotalEmployment = 314.0600 UNION ALL

  SELECT QuarterEndDate = '20180630'
  ,GeoTypeID = 48620
     ,TotalEmployment = 315.7100 UNION ALL

  SELECT QuarterEndDate = '20180930'
  ,GeoTypeID = 48620
     ,TotalEmployment = 317.2700 UNION ALL

  SELECT QuarterEndDate = '20181231'
  ,GeoTypeID = 48620
     ,TotalEmployment = 318.7300 UNION ALL

  SELECT QuarterEndDate = '20190331'
  ,GeoTypeID = 48620
     ,TotalEmployment = 320.0800 UNION ALL

  SELECT QuarterEndDate = '20190630'
  ,GeoTypeID = 48620
     ,TotalEmployment = 321.3700 UNION ALL

  SELECT QuarterEndDate = '20190930'
  ,GeoTypeID = 48620
     ,TotalEmployment = 322.3400 UNION ALL

  SELECT QuarterEndDate = '20191231'
  ,GeoTypeID = 48620
     ,TotalEmployment = 323.0500 UNION ALL

  SELECT QuarterEndDate = '20200331'
  ,GeoTypeID = 48620
     ,TotalEmployment = 323.5700 UNION ALL

  SELECT QuarterEndDate = '20200630'
  ,GeoTypeID = 48620
     ,TotalEmployment = 323.8100 UNION ALL

  SELECT QuarterEndDate = '20200930'
  ,GeoTypeID = 48620
     ,TotalEmployment = 324.0500 UNION ALL

  SELECT QuarterEndDate = '20201231'
  ,GeoTypeID = 48620
     ,TotalEmployment = 324.2900 UNION ALL

  SELECT QuarterEndDate = '20210331'
  ,GeoTypeID = 48620
     ,TotalEmployment = 324.5300 UNION ALL

  SELECT QuarterEndDate = '20210630'
  ,GeoTypeID = 48620
     ,TotalEmployment = 324.8800 UNION ALL

  SELECT QuarterEndDate = '20210930'
  ,GeoTypeID = 48620
     ,TotalEmployment = 325.2800 UNION ALL

  SELECT QuarterEndDate = '20211231'
  ,GeoTypeID = 48620
     ,TotalEmployment = 325.7500 UNION ALL

  SELECT QuarterEndDate = '20220331'
  ,GeoTypeID = 48620
     ,TotalEmployment = 326.2400 UNION ALL

  SELECT QuarterEndDate = '20220630'
  ,GeoTypeID = 48620
     ,TotalEmployment = 326.7900 UNION ALL

  SELECT QuarterEndDate = '20220930'
  ,GeoTypeID = 48620
     ,TotalEmployment = 327.4000 UNION ALL

  SELECT QuarterEndDate = '20221231'
  ,GeoTypeID = 48620
     ,TotalEmployment = 327.9900 UNION ALL

  SELECT QuarterEndDate = '20230331'
  ,GeoTypeID = 48620
     ,TotalEmployment = 328.5900 UNION ALL

  SELECT QuarterEndDate = '20230630'
  ,GeoTypeID = 48620
     ,TotalEmployment = 329.1500 UNION ALL

  SELECT QuarterEndDate = '20230930'
  ,GeoTypeID = 48620
     ,TotalEmployment = 329.6800 UNION ALL

  SELECT QuarterEndDate = '20231231'
  ,GeoTypeID = 48620
     ,TotalEmployment = 330.2300 UNION ALL

  SELECT QuarterEndDate = '20240331'
  ,GeoTypeID = 48620
     ,TotalEmployment = 330.7400 UNION ALL

  SELECT QuarterEndDate = '20240630'
  ,GeoTypeID = 48620
     ,TotalEmployment = 331.2500 UNION ALL

  SELECT QuarterEndDate = '20240930'
  ,GeoTypeID = 48620
     ,TotalEmployment = 331.7700 UNION ALL

  SELECT QuarterEndDate = '20241231'
  ,GeoTypeID = 48620
     ,TotalEmployment = 332.2900 UNION ALL

  SELECT QuarterEndDate = '20250331'
  ,GeoTypeID = 48620
     ,TotalEmployment = 332.7900 UNION ALL

  SELECT QuarterEndDate = '20250630'
  ,GeoTypeID = 48620
     ,TotalEmployment = 333.2900 UNION ALL

  SELECT QuarterEndDate = '20250930'
  ,GeoTypeID = 48620
     ,TotalEmployment = 333.8000 UNION ALL

  SELECT QuarterEndDate = '20251231'
  ,GeoTypeID = 48620
     ,TotalEmployment = 334.3100 UNION ALL

  SELECT QuarterEndDate = '20170930'
  ,GeoTypeID = 19340
     ,TotalEmployment = 184.5900 UNION ALL

  SELECT QuarterEndDate = '20171231'
  ,GeoTypeID = 19340
     ,TotalEmployment = 185.2700 UNION ALL

  SELECT QuarterEndDate = '20180331'
  ,GeoTypeID = 19340
     ,TotalEmployment = 185.8300 UNION ALL

  SELECT QuarterEndDate = '20180630'
  ,GeoTypeID = 19340
     ,TotalEmployment = 186.2700 UNION ALL

  SELECT QuarterEndDate = '20180930'
  ,GeoTypeID = 19340
     ,TotalEmployment = 186.6800 UNION ALL

  SELECT QuarterEndDate = '20181231'
  ,GeoTypeID = 19340
     ,TotalEmployment = 187.0400 UNION ALL

  SELECT QuarterEndDate = '20190331'
  ,GeoTypeID = 19340
     ,TotalEmployment = 187.3400 UNION ALL

  SELECT QuarterEndDate = '20190630'
  ,GeoTypeID = 19340
     ,TotalEmployment = 187.6100 UNION ALL

  SELECT QuarterEndDate = '20190930'
  ,GeoTypeID = 19340
     ,TotalEmployment = 187.8100 UNION ALL

  SELECT QuarterEndDate = '20191231'
  ,GeoTypeID = 19340
     ,TotalEmployment = 187.8500 UNION ALL

  SELECT QuarterEndDate = '20200331'
  ,GeoTypeID = 19340
     ,TotalEmployment = 187.8200 UNION ALL

  SELECT QuarterEndDate = '20200630'
  ,GeoTypeID = 19340
     ,TotalEmployment = 187.7200 UNION ALL

  SELECT QuarterEndDate = '20200930'
  ,GeoTypeID = 19340
     ,TotalEmployment = 187.6000 UNION ALL

  SELECT QuarterEndDate = '20201231'
  ,GeoTypeID = 19340
     ,TotalEmployment = 187.4700 UNION ALL

  SELECT QuarterEndDate = '20210331'
  ,GeoTypeID = 19340
     ,TotalEmployment = 187.3400 UNION ALL

  SELECT QuarterEndDate = '20210630'
  ,GeoTypeID = 19340
     ,TotalEmployment = 187.2100 UNION ALL

  SELECT QuarterEndDate = '20210930'
  ,GeoTypeID = 19340
     ,TotalEmployment = 187.0900 UNION ALL

  SELECT QuarterEndDate = '20211231'
  ,GeoTypeID = 19340
     ,TotalEmployment = 187.0000 UNION ALL

  SELECT QuarterEndDate = '20220331'
  ,GeoTypeID = 19340
     ,TotalEmployment = 186.9200 UNION ALL

  SELECT QuarterEndDate = '20220630'
  ,GeoTypeID = 19340
     ,TotalEmployment = 186.8600 UNION ALL

  SELECT QuarterEndDate = '20220930'
  ,GeoTypeID = 19340
     ,TotalEmployment = 186.8200 UNION ALL

  SELECT QuarterEndDate = '20221231'
  ,GeoTypeID = 19340
     ,TotalEmployment = 186.7800 UNION ALL

  SELECT QuarterEndDate = '20230331'
  ,GeoTypeID = 19340
     ,TotalEmployment = 186.7600 UNION ALL

  SELECT QuarterEndDate = '20230630'
  ,GeoTypeID = 19340
     ,TotalEmployment = 186.7300 UNION ALL

  SELECT QuarterEndDate = '20230930'
  ,GeoTypeID = 19340
     ,TotalEmployment = 186.7100 UNION ALL

  SELECT QuarterEndDate = '20231231'
  ,GeoTypeID = 19340
     ,TotalEmployment = 186.6900 UNION ALL

  SELECT QuarterEndDate = '20240331'
  ,GeoTypeID = 19340
     ,TotalEmployment = 186.6700 UNION ALL

  SELECT QuarterEndDate = '20240630'
  ,GeoTypeID = 19340
     ,TotalEmployment = 186.6400 UNION ALL

  SELECT QuarterEndDate = '20240930'
  ,GeoTypeID = 19340
     ,TotalEmployment = 186.6300 UNION ALL

  SELECT QuarterEndDate = '20241231'
  ,GeoTypeID = 19340
     ,TotalEmployment = 186.6100 UNION ALL

  SELECT QuarterEndDate = '20250331'
  ,GeoTypeID = 19340
     ,TotalEmployment = 186.5900 UNION ALL

  SELECT QuarterEndDate = '20250630'
  ,GeoTypeID = 19340
     ,TotalEmployment = 186.5800 UNION ALL

  SELECT QuarterEndDate = '20250930'
  ,GeoTypeID = 19340
     ,TotalEmployment = 186.5700 UNION ALL

  SELECT QuarterEndDate = '20251231'
  ,GeoTypeID = 19340
     ,TotalEmployment = 186.5700 UNION ALL

  SELECT QuarterEndDate = '20170930'
  ,GeoTypeID = 45780
     ,TotalEmployment = 318.1400 UNION ALL

  SELECT QuarterEndDate = '20171231'
  ,GeoTypeID = 45780
     ,TotalEmployment = 319.1900 UNION ALL

  SELECT QuarterEndDate = '20180331'
  ,GeoTypeID = 45780
     ,TotalEmployment = 320.1500 UNION ALL

  SELECT QuarterEndDate = '20180630'
  ,GeoTypeID = 45780
     ,TotalEmployment = 320.9900 UNION ALL

  SELECT QuarterEndDate = '20180930'
  ,GeoTypeID = 45780
     ,TotalEmployment = 321.8700 UNION ALL

  SELECT QuarterEndDate = '20181231'
  ,GeoTypeID = 45780
     ,TotalEmployment = 322.7600 UNION ALL

  SELECT QuarterEndDate = '20190331'
  ,GeoTypeID = 45780
     ,TotalEmployment = 323.5800 UNION ALL

  SELECT QuarterEndDate = '20190630'
  ,GeoTypeID = 45780
     ,TotalEmployment = 324.4500 UNION ALL

  SELECT QuarterEndDate = '20190930'
  ,GeoTypeID = 45780
     ,TotalEmployment = 325.1700 UNION ALL

  SELECT QuarterEndDate = '20191231'
  ,GeoTypeID = 45780
     ,TotalEmployment = 325.6000 UNION ALL

  SELECT QuarterEndDate = '20200331'
  ,GeoTypeID = 45780
     ,TotalEmployment = 325.9100 UNION ALL

  SELECT QuarterEndDate = '20200630'
  ,GeoTypeID = 45780
     ,TotalEmployment = 326.1100 UNION ALL

  SELECT QuarterEndDate = '20200930'
  ,GeoTypeID = 45780
     ,TotalEmployment = 326.3500 UNION ALL

  SELECT QuarterEndDate = '20201231'
  ,GeoTypeID = 45780
     ,TotalEmployment = 326.5100 UNION ALL

  SELECT QuarterEndDate = '20210331'
  ,GeoTypeID = 45780
     ,TotalEmployment = 326.7200 UNION ALL

  SELECT QuarterEndDate = '20210630'
  ,GeoTypeID = 45780
     ,TotalEmployment = 326.9500 UNION ALL

  SELECT QuarterEndDate = '20210930'
  ,GeoTypeID = 45780
     ,TotalEmployment = 327.1900 UNION ALL

  SELECT QuarterEndDate = '20211231'
  ,GeoTypeID = 45780
     ,TotalEmployment = 327.5200 UNION ALL

  SELECT QuarterEndDate = '20220331'
  ,GeoTypeID = 45780
     ,TotalEmployment = 327.8800 UNION ALL

  SELECT QuarterEndDate = '20220630'
  ,GeoTypeID = 45780
     ,TotalEmployment = 328.3000 UNION ALL

  SELECT QuarterEndDate = '20220930'
  ,GeoTypeID = 45780
     ,TotalEmployment = 328.7300 UNION ALL

  SELECT QuarterEndDate = '20221231'
  ,GeoTypeID = 45780
     ,TotalEmployment = 329.1500 UNION ALL

  SELECT QuarterEndDate = '20230331'
  ,GeoTypeID = 45780
     ,TotalEmployment = 329.5800 UNION ALL

  SELECT QuarterEndDate = '20230630'
  ,GeoTypeID = 45780
     ,TotalEmployment = 330.0100 UNION ALL

  SELECT QuarterEndDate = '20230930'
  ,GeoTypeID = 45780
     ,TotalEmployment = 330.4700 UNION ALL

  SELECT QuarterEndDate = '20231231'
  ,GeoTypeID = 45780
     ,TotalEmployment = 330.9000 UNION ALL

  SELECT QuarterEndDate = '20240331'
  ,GeoTypeID = 45780
     ,TotalEmployment = 331.3300 UNION ALL

  SELECT QuarterEndDate = '20240630'
  ,GeoTypeID = 45780
     ,TotalEmployment = 331.7600 UNION ALL

  SELECT QuarterEndDate = '20240930'
  ,GeoTypeID = 45780
     ,TotalEmployment = 332.2100 UNION ALL

  SELECT QuarterEndDate = '20241231'
  ,GeoTypeID = 45780
     ,TotalEmployment = 332.6500 UNION ALL

  SELECT QuarterEndDate = '20250331'
  ,GeoTypeID = 45780
     ,TotalEmployment = 333.0900 UNION ALL

  SELECT QuarterEndDate = '20250630'
  ,GeoTypeID = 45780
     ,TotalEmployment = 333.5300 UNION ALL

  SELECT QuarterEndDate = '20250930'
  ,GeoTypeID = 45780
     ,TotalEmployment = 333.9800 UNION ALL

  SELECT QuarterEndDate = '20251231'
  ,GeoTypeID = 45780
     ,TotalEmployment = 334.4400 UNION ALL

  SELECT QuarterEndDate = '20170930'
  ,GeoTypeID = 36540
     ,TotalEmployment = 506.8700 UNION ALL

  SELECT QuarterEndDate = '20171231'
  ,GeoTypeID = 36540
     ,TotalEmployment = 508.8800 UNION ALL

  SELECT QuarterEndDate = '20180331'
  ,GeoTypeID = 36540
     ,TotalEmployment = 510.8700 UNION ALL

  SELECT QuarterEndDate = '20180630'
  ,GeoTypeID = 36540
     ,TotalEmployment = 512.7300 UNION ALL

  SELECT QuarterEndDate = '20180930'
  ,GeoTypeID = 36540
     ,TotalEmployment = 514.5100 UNION ALL

  SELECT QuarterEndDate = '20181231'
  ,GeoTypeID = 36540
     ,TotalEmployment = 516.2000 UNION ALL

  SELECT QuarterEndDate = '20190331'
  ,GeoTypeID = 36540
     ,TotalEmployment = 517.7700 UNION ALL

  SELECT QuarterEndDate = '20190630'
  ,GeoTypeID = 36540
     ,TotalEmployment = 519.3400 UNION ALL

  SELECT QuarterEndDate = '20190930'
  ,GeoTypeID = 36540
     ,TotalEmployment = 520.4900 UNION ALL

  SELECT QuarterEndDate = '20191231'
  ,GeoTypeID = 36540
     ,TotalEmployment = 521.2800 UNION ALL

  SELECT QuarterEndDate = '20200331'
  ,GeoTypeID = 36540
     ,TotalEmployment = 521.8000 UNION ALL

  SELECT QuarterEndDate = '20200630'
  ,GeoTypeID = 36540
     ,TotalEmployment = 522.0400 UNION ALL

  SELECT QuarterEndDate = '20200930'
  ,GeoTypeID = 36540
     ,TotalEmployment = 522.3900 UNION ALL

  SELECT QuarterEndDate = '20201231'
  ,GeoTypeID = 36540
     ,TotalEmployment = 522.7100 UNION ALL

  SELECT QuarterEndDate = '20210331'
  ,GeoTypeID = 36540
     ,TotalEmployment = 523.0900 UNION ALL

  SELECT QuarterEndDate = '20210630'
  ,GeoTypeID = 36540
     ,TotalEmployment = 523.6000 UNION ALL

  SELECT QuarterEndDate = '20210930'
  ,GeoTypeID = 36540
     ,TotalEmployment = 524.1000 UNION ALL

  SELECT QuarterEndDate = '20211231'
  ,GeoTypeID = 36540
     ,TotalEmployment = 524.7600 UNION ALL

  SELECT QuarterEndDate = '20220331'
  ,GeoTypeID = 36540
     ,TotalEmployment = 525.4600 UNION ALL

  SELECT QuarterEndDate = '20220630'
  ,GeoTypeID = 36540
     ,TotalEmployment = 526.2500 UNION ALL

  SELECT QuarterEndDate = '20220930'
  ,GeoTypeID = 36540
     ,TotalEmployment = 527.1100 UNION ALL

  SELECT QuarterEndDate = '20221231'
  ,GeoTypeID = 36540
     ,TotalEmployment = 527.9300 UNION ALL

  SELECT QuarterEndDate = '20230331'
  ,GeoTypeID = 36540
     ,TotalEmployment = 528.8200 UNION ALL

  SELECT QuarterEndDate = '20230630'
  ,GeoTypeID = 36540
     ,TotalEmployment = 529.6400 UNION ALL

  SELECT QuarterEndDate = '20230930'
  ,GeoTypeID = 36540
     ,TotalEmployment = 530.3900 UNION ALL

  SELECT QuarterEndDate = '20231231'
  ,GeoTypeID = 36540
     ,TotalEmployment = 531.1400 UNION ALL

  SELECT QuarterEndDate = '20240331'
  ,GeoTypeID = 36540
     ,TotalEmployment = 531.8600 UNION ALL

  SELECT QuarterEndDate = '20240630'
  ,GeoTypeID = 36540
     ,TotalEmployment = 532.5800 UNION ALL

  SELECT QuarterEndDate = '20240930'
  ,GeoTypeID = 36540
     ,TotalEmployment = 533.3200 UNION ALL

  SELECT QuarterEndDate = '20241231'
  ,GeoTypeID = 36540
     ,TotalEmployment = 534.0700 UNION ALL

  SELECT QuarterEndDate = '20250331'
  ,GeoTypeID = 36540
     ,TotalEmployment = 534.7900 UNION ALL

  SELECT QuarterEndDate = '20250630'
  ,GeoTypeID = 36540
     ,TotalEmployment = 535.5200 UNION ALL

  SELECT QuarterEndDate = '20250930'
  ,GeoTypeID = 36540
     ,TotalEmployment = 536.2600 UNION ALL

  SELECT QuarterEndDate = '20251231'
  ,GeoTypeID = 36540
     ,TotalEmployment = 537.0100 UNION ALL

  SELECT QuarterEndDate = '20170930'
  ,GeoTypeID = 44220
     ,TotalEmployment = 51.5000 UNION ALL

  SELECT QuarterEndDate = '20171231'
  ,GeoTypeID = 44220
     ,TotalEmployment = 51.5400 UNION ALL

  SELECT QuarterEndDate = '20180331'
  ,GeoTypeID = 44220
     ,TotalEmployment = 51.5800 UNION ALL

  SELECT QuarterEndDate = '20180630'
  ,GeoTypeID = 44220
     ,TotalEmployment = 51.6200 UNION ALL

  SELECT QuarterEndDate = '20180930'
  ,GeoTypeID = 44220
     ,TotalEmployment = 51.6600 UNION ALL

  SELECT QuarterEndDate = '20181231'
  ,GeoTypeID = 44220
     ,TotalEmployment = 51.7000 UNION ALL

  SELECT QuarterEndDate = '20190331'
  ,GeoTypeID = 44220
     ,TotalEmployment = 51.7500 UNION ALL

  SELECT QuarterEndDate = '20190630'
  ,GeoTypeID = 44220
     ,TotalEmployment = 51.8000 UNION ALL

  SELECT QuarterEndDate = '20190930'
  ,GeoTypeID = 44220
     ,TotalEmployment = 51.8300 UNION ALL

  SELECT QuarterEndDate = '20191231'
  ,GeoTypeID = 44220
     ,TotalEmployment = 51.8200 UNION ALL

  SELECT QuarterEndDate = '20200331'
  ,GeoTypeID = 44220
     ,TotalEmployment = 51.8000 UNION ALL

  SELECT QuarterEndDate = '20200630'
  ,GeoTypeID = 44220
     ,TotalEmployment = 51.7600 UNION ALL

  SELECT QuarterEndDate = '20200930'
  ,GeoTypeID = 44220
     ,TotalEmployment = 51.7200 UNION ALL

  SELECT QuarterEndDate = '20201231'
  ,GeoTypeID = 44220
     ,TotalEmployment = 51.6800 UNION ALL

  SELECT QuarterEndDate = '20210331'
  ,GeoTypeID = 44220
     ,TotalEmployment = 51.6500 UNION ALL

  SELECT QuarterEndDate = '20210630'
  ,GeoTypeID = 44220
     ,TotalEmployment = 51.6200 UNION ALL

  SELECT QuarterEndDate = '20210930'
  ,GeoTypeID = 44220
     ,TotalEmployment = 51.5900 UNION ALL

  SELECT QuarterEndDate = '20211231'
  ,GeoTypeID = 44220
     ,TotalEmployment = 51.5700 UNION ALL

  SELECT QuarterEndDate = '20220331'
  ,GeoTypeID = 44220
     ,TotalEmployment = 51.5700 UNION ALL

  SELECT QuarterEndDate = '20220630'
  ,GeoTypeID = 44220
     ,TotalEmployment = 51.5700 UNION ALL

  SELECT QuarterEndDate = '20220930'
  ,GeoTypeID = 44220
     ,TotalEmployment = 51.5700 UNION ALL

  SELECT QuarterEndDate = '20221231'
  ,GeoTypeID = 44220
     ,TotalEmployment = 51.5700 UNION ALL

  SELECT QuarterEndDate = '20230331'
  ,GeoTypeID = 44220
     ,TotalEmployment = 51.5800 UNION ALL

  SELECT QuarterEndDate = '20230630'
  ,GeoTypeID = 44220
     ,TotalEmployment = 51.5800 UNION ALL

  SELECT QuarterEndDate = '20230930'
  ,GeoTypeID = 44220
     ,TotalEmployment = 51.5900 UNION ALL

  SELECT QuarterEndDate = '20231231'
  ,GeoTypeID = 44220
     ,TotalEmployment = 51.6000 UNION ALL

  SELECT QuarterEndDate = '20240331'
  ,GeoTypeID = 44220
     ,TotalEmployment = 51.6100 UNION ALL

  SELECT QuarterEndDate = '20240630'
  ,GeoTypeID = 44220
     ,TotalEmployment = 51.6100 UNION ALL

  SELECT QuarterEndDate = '20240930'
  ,GeoTypeID = 44220
     ,TotalEmployment = 51.6200 UNION ALL

  SELECT QuarterEndDate = '20241231'
  ,GeoTypeID = 44220
     ,TotalEmployment = 51.6300 UNION ALL

  SELECT QuarterEndDate = '20250331'
  ,GeoTypeID = 44220
     ,TotalEmployment = 51.6400 UNION ALL

  SELECT QuarterEndDate = '20250630'
  ,GeoTypeID = 44220
     ,TotalEmployment = 51.6500 UNION ALL

  SELECT QuarterEndDate = '20250930'
  ,GeoTypeID = 44220
     ,TotalEmployment = 51.6600 UNION ALL

  SELECT QuarterEndDate = '20251231'
  ,GeoTypeID = 44220
     ,TotalEmployment = 51.6700 UNION ALL

  SELECT QuarterEndDate = '20170930'
  ,GeoTypeID = 34740
     ,TotalEmployment = 66.9700 UNION ALL

  SELECT QuarterEndDate = '20171231'
  ,GeoTypeID = 34740
     ,TotalEmployment = 67.2500 UNION ALL

  SELECT QuarterEndDate = '20180331'
  ,GeoTypeID = 34740
     ,TotalEmployment = 67.5300 UNION ALL

  SELECT QuarterEndDate = '20180630'
  ,GeoTypeID = 34740
     ,TotalEmployment = 67.7700 UNION ALL

  SELECT QuarterEndDate = '20180930'
  ,GeoTypeID = 34740
     ,TotalEmployment = 67.9900 UNION ALL

  SELECT QuarterEndDate = '20181231'
  ,GeoTypeID = 34740
     ,TotalEmployment = 68.2000 UNION ALL

  SELECT QuarterEndDate = '20190331'
  ,GeoTypeID = 34740
     ,TotalEmployment = 68.3800 UNION ALL

  SELECT QuarterEndDate = '20190630'
  ,GeoTypeID = 34740
     ,TotalEmployment = 68.5600 UNION ALL

  SELECT QuarterEndDate = '20190930'
  ,GeoTypeID = 34740
     ,TotalEmployment = 68.7100 UNION ALL

  SELECT QuarterEndDate = '20191231'
  ,GeoTypeID = 34740
     ,TotalEmployment = 68.7800 UNION ALL

  SELECT QuarterEndDate = '20200331'
  ,GeoTypeID = 34740
     ,TotalEmployment = 68.8200 UNION ALL

  SELECT QuarterEndDate = '20200630'
  ,GeoTypeID = 34740
     ,TotalEmployment = 68.8300 UNION ALL

  SELECT QuarterEndDate = '20200930'
  ,GeoTypeID = 34740
     ,TotalEmployment = 68.8400 UNION ALL

  SELECT QuarterEndDate = '20201231'
  ,GeoTypeID = 34740
     ,TotalEmployment = 68.8400 UNION ALL

  SELECT QuarterEndDate = '20210331'
  ,GeoTypeID = 34740
     ,TotalEmployment = 68.8500 UNION ALL

  SELECT QuarterEndDate = '20210630'
  ,GeoTypeID = 34740
     ,TotalEmployment = 68.8600 UNION ALL

  SELECT QuarterEndDate = '20210930'
  ,GeoTypeID = 34740
     ,TotalEmployment = 68.8900 UNION ALL

  SELECT QuarterEndDate = '20211231'
  ,GeoTypeID = 34740
     ,TotalEmployment = 68.9200 UNION ALL

  SELECT QuarterEndDate = '20220331'
  ,GeoTypeID = 34740
     ,TotalEmployment = 68.9700 UNION ALL

  SELECT QuarterEndDate = '20220630'
  ,GeoTypeID = 34740
     ,TotalEmployment = 69.0200 UNION ALL

  SELECT QuarterEndDate = '20220930'
  ,GeoTypeID = 34740
     ,TotalEmployment = 69.0800 UNION ALL

  SELECT QuarterEndDate = '20221231'
  ,GeoTypeID = 34740
     ,TotalEmployment = 69.1500 UNION ALL

  SELECT QuarterEndDate = '20230331'
  ,GeoTypeID = 34740
     ,TotalEmployment = 69.2200 UNION ALL

  SELECT QuarterEndDate = '20230630'
  ,GeoTypeID = 34740
     ,TotalEmployment = 69.2900 UNION ALL

  SELECT QuarterEndDate = '20230930'
  ,GeoTypeID = 34740
     ,TotalEmployment = 69.3600 UNION ALL

  SELECT QuarterEndDate = '20231231'
  ,GeoTypeID = 34740
     ,TotalEmployment = 69.4300 UNION ALL

  SELECT QuarterEndDate = '20240331'
  ,GeoTypeID = 34740
     ,TotalEmployment = 69.5100 UNION ALL

  SELECT QuarterEndDate = '20240630'
  ,GeoTypeID = 34740
     ,TotalEmployment = 69.5800 UNION ALL

  SELECT QuarterEndDate = '20240930'
  ,GeoTypeID = 34740
     ,TotalEmployment = 69.6500 UNION ALL

  SELECT QuarterEndDate = '20241231'
  ,GeoTypeID = 34740
     ,TotalEmployment = 69.7200 UNION ALL

  SELECT QuarterEndDate = '20250331'
  ,GeoTypeID = 34740
     ,TotalEmployment = 69.7900 UNION ALL

  SELECT QuarterEndDate = '20250630'
  ,GeoTypeID = 34740
     ,TotalEmployment = 69.8600 UNION ALL

  SELECT QuarterEndDate = '20250930'
  ,GeoTypeID = 34740
     ,TotalEmployment = 69.9400 UNION ALL

  SELECT QuarterEndDate = '20251231'
  ,GeoTypeID = 34740
     ,TotalEmployment = 70.0200 UNION ALL

  SELECT QuarterEndDate = '20170930'
  ,GeoTypeID = 44180
     ,TotalEmployment = 218.1900 UNION ALL

  SELECT QuarterEndDate = '20171231'
  ,GeoTypeID = 44180
     ,TotalEmployment = 219.1400 UNION ALL

  SELECT QuarterEndDate = '20180331'
  ,GeoTypeID = 44180
     ,TotalEmployment = 220.1100 UNION ALL

  SELECT QuarterEndDate = '20180630'
  ,GeoTypeID = 44180
     ,TotalEmployment = 220.9100 UNION ALL

  SELECT QuarterEndDate = '20180930'
  ,GeoTypeID = 44180
     ,TotalEmployment = 221.6600 UNION ALL

  SELECT QuarterEndDate = '20181231'
  ,GeoTypeID = 44180
     ,TotalEmployment = 222.3900 UNION ALL

  SELECT QuarterEndDate = '20190331'
  ,GeoTypeID = 44180
     ,TotalEmployment = 223.0700 UNION ALL

  SELECT QuarterEndDate = '20190630'
  ,GeoTypeID = 44180
     ,TotalEmployment = 223.7200 UNION ALL

  SELECT QuarterEndDate = '20190930'
  ,GeoTypeID = 44180
     ,TotalEmployment = 224.2700 UNION ALL

  SELECT QuarterEndDate = '20191231'
  ,GeoTypeID = 44180
     ,TotalEmployment = 224.6300 UNION ALL

  SELECT QuarterEndDate = '20200331'
  ,GeoTypeID = 44180
     ,TotalEmployment = 224.9300 UNION ALL

  SELECT QuarterEndDate = '20200630'
  ,GeoTypeID = 44180
     ,TotalEmployment = 225.1700 UNION ALL

  SELECT QuarterEndDate = '20200930'
  ,GeoTypeID = 44180
     ,TotalEmployment = 225.4000 UNION ALL

  SELECT QuarterEndDate = '20201231'
  ,GeoTypeID = 44180
     ,TotalEmployment = 225.6000 UNION ALL

  SELECT QuarterEndDate = '20210331'
  ,GeoTypeID = 44180
     ,TotalEmployment = 225.8300 UNION ALL

  SELECT QuarterEndDate = '20210630'
  ,GeoTypeID = 44180
     ,TotalEmployment = 226.0600 UNION ALL

  SELECT QuarterEndDate = '20210930'
  ,GeoTypeID = 44180
     ,TotalEmployment = 226.3200 UNION ALL

  SELECT QuarterEndDate = '20211231'
  ,GeoTypeID = 44180
     ,TotalEmployment = 226.6200 UNION ALL

  SELECT QuarterEndDate = '20220331'
  ,GeoTypeID = 44180
     ,TotalEmployment = 226.9500 UNION ALL

  SELECT QuarterEndDate = '20220630'
  ,GeoTypeID = 44180
     ,TotalEmployment = 227.3000 UNION ALL

  SELECT QuarterEndDate = '20220930'
  ,GeoTypeID = 44180
     ,TotalEmployment = 227.6700 UNION ALL

  SELECT QuarterEndDate = '20221231'
  ,GeoTypeID = 44180
     ,TotalEmployment = 228.0300 UNION ALL

  SELECT QuarterEndDate = '20230331'
  ,GeoTypeID = 44180
     ,TotalEmployment = 228.4100 UNION ALL

  SELECT QuarterEndDate = '20230630'
  ,GeoTypeID = 44180
     ,TotalEmployment = 228.7700 UNION ALL

  SELECT QuarterEndDate = '20230930'
  ,GeoTypeID = 44180
     ,TotalEmployment = 229.1600 UNION ALL

  SELECT QuarterEndDate = '20231231'
  ,GeoTypeID = 44180
     ,TotalEmployment = 229.5300 UNION ALL

  SELECT QuarterEndDate = '20240331'
  ,GeoTypeID = 44180
     ,TotalEmployment = 229.9100 UNION ALL

  SELECT QuarterEndDate = '20240630'
  ,GeoTypeID = 44180
     ,TotalEmployment = 230.2800 UNION ALL

  SELECT QuarterEndDate = '20240930'
  ,GeoTypeID = 44180
     ,TotalEmployment = 230.6600 UNION ALL

  SELECT QuarterEndDate = '20241231'
  ,GeoTypeID = 44180
     ,TotalEmployment = 231.0400 UNION ALL

  SELECT QuarterEndDate = '20250331'
  ,GeoTypeID = 44180
     ,TotalEmployment = 231.3900 UNION ALL

  SELECT QuarterEndDate = '20250630'
  ,GeoTypeID = 44180
     ,TotalEmployment = 231.7500 UNION ALL

  SELECT QuarterEndDate = '20250930'
  ,GeoTypeID = 44180
     ,TotalEmployment = 232.1000 UNION ALL

  SELECT QuarterEndDate = '20251231'
  ,GeoTypeID = 44180
     ,TotalEmployment = 232.4500 UNION ALL

  SELECT QuarterEndDate = '20170930'
  ,GeoTypeID = 31900
     ,TotalEmployment = 53.3900 UNION ALL

  SELECT QuarterEndDate = '20171231'
  ,GeoTypeID = 31900
     ,TotalEmployment = 53.6000 UNION ALL

  SELECT QuarterEndDate = '20180331'
  ,GeoTypeID = 31900
     ,TotalEmployment = 53.7800 UNION ALL

  SELECT QuarterEndDate = '20180630'
  ,GeoTypeID = 31900
     ,TotalEmployment = 53.9400 UNION ALL

  SELECT QuarterEndDate = '20180930'
  ,GeoTypeID = 31900
     ,TotalEmployment = 54.1000 UNION ALL

  SELECT QuarterEndDate = '20181231'
  ,GeoTypeID = 31900
     ,TotalEmployment = 54.2500 UNION ALL

  SELECT QuarterEndDate = '20190331'
  ,GeoTypeID = 31900
     ,TotalEmployment = 54.3900 UNION ALL

  SELECT QuarterEndDate = '20190630'
  ,GeoTypeID = 31900
     ,TotalEmployment = 54.5300 UNION ALL

  SELECT QuarterEndDate = '20190930'
  ,GeoTypeID = 31900
     ,TotalEmployment = 54.6400 UNION ALL

  SELECT QuarterEndDate = '20191231'
  ,GeoTypeID = 31900
     ,TotalEmployment = 54.7000 UNION ALL

  SELECT QuarterEndDate = '20200331'
  ,GeoTypeID = 31900
     ,TotalEmployment = 54.7400 UNION ALL

  SELECT QuarterEndDate = '20200630'
  ,GeoTypeID = 31900
     ,TotalEmployment = 54.7700 UNION ALL

  SELECT QuarterEndDate = '20200930'
  ,GeoTypeID = 31900
     ,TotalEmployment = 54.7900 UNION ALL

  SELECT QuarterEndDate = '20201231'
  ,GeoTypeID = 31900
     ,TotalEmployment = 54.8100 UNION ALL

  SELECT QuarterEndDate = '20210331'
  ,GeoTypeID = 31900
     ,TotalEmployment = 54.8300 UNION ALL

  SELECT QuarterEndDate = '20210630'
  ,GeoTypeID = 31900
     ,TotalEmployment = 54.8500 UNION ALL

  SELECT QuarterEndDate = '20210930'
  ,GeoTypeID = 31900
     ,TotalEmployment = 54.8700 UNION ALL

  SELECT QuarterEndDate = '20211231'
  ,GeoTypeID = 31900
     ,TotalEmployment = 54.9200 UNION ALL

  SELECT QuarterEndDate = '20220331'
  ,GeoTypeID = 31900
     ,TotalEmployment = 54.9600 UNION ALL

  SELECT QuarterEndDate = '20220630'
  ,GeoTypeID = 31900
     ,TotalEmployment = 55.0100 UNION ALL

  SELECT QuarterEndDate = '20220930'
  ,GeoTypeID = 31900
     ,TotalEmployment = 55.0700 UNION ALL

  SELECT QuarterEndDate = '20221231'
  ,GeoTypeID = 31900
     ,TotalEmployment = 55.1200 UNION ALL

  SELECT QuarterEndDate = '20230331'
  ,GeoTypeID = 31900
     ,TotalEmployment = 55.1800 UNION ALL

  SELECT QuarterEndDate = '20230630'
  ,GeoTypeID = 31900
     ,TotalEmployment = 55.2300 UNION ALL

  SELECT QuarterEndDate = '20230930'
  ,GeoTypeID = 31900
     ,TotalEmployment = 55.2900 UNION ALL

  SELECT QuarterEndDate = '20231231'
  ,GeoTypeID = 31900
     ,TotalEmployment = 55.3400 UNION ALL

  SELECT QuarterEndDate = '20240331'
  ,GeoTypeID = 31900
     ,TotalEmployment = 55.3900 UNION ALL

  SELECT QuarterEndDate = '20240630'
  ,GeoTypeID = 31900
     ,TotalEmployment = 55.4400 UNION ALL

  SELECT QuarterEndDate = '20240930'
  ,GeoTypeID = 31900
     ,TotalEmployment = 55.5000 UNION ALL

  SELECT QuarterEndDate = '20241231'
  ,GeoTypeID = 31900
     ,TotalEmployment = 55.5500 UNION ALL

  SELECT QuarterEndDate = '20250331'
  ,GeoTypeID = 31900
     ,TotalEmployment = 55.6000 UNION ALL

  SELECT QuarterEndDate = '20250630'
  ,GeoTypeID = 31900
     ,TotalEmployment = 55.6500 UNION ALL

  SELECT QuarterEndDate = '20250930'
  ,GeoTypeID = 31900
     ,TotalEmployment = 55.7000 UNION ALL

  SELECT QuarterEndDate = '20251231'
  ,GeoTypeID = 31900
     ,TotalEmployment = 55.7600 UNION ALL

  SELECT QuarterEndDate = '20170930'
  ,GeoTypeID = 22420
     ,TotalEmployment = 142.4300 UNION ALL

  SELECT QuarterEndDate = '20171231'
  ,GeoTypeID = 22420
     ,TotalEmployment = 142.8800 UNION ALL

  SELECT QuarterEndDate = '20180331'
  ,GeoTypeID = 22420
     ,TotalEmployment = 143.3400 UNION ALL

  SELECT QuarterEndDate = '20180630'
  ,GeoTypeID = 22420
     ,TotalEmployment = 143.7500 UNION ALL

  SELECT QuarterEndDate = '20180930'
  ,GeoTypeID = 22420
     ,TotalEmployment = 144.1400 UNION ALL

  SELECT QuarterEndDate = '20181231'
  ,GeoTypeID = 22420
     ,TotalEmployment = 144.5300 UNION ALL

  SELECT QuarterEndDate = '20190331'
  ,GeoTypeID = 22420
     ,TotalEmployment = 144.9000 UNION ALL

  SELECT QuarterEndDate = '20190630'
  ,GeoTypeID = 22420
     ,TotalEmployment = 145.2700 UNION ALL

  SELECT QuarterEndDate = '20190930'
  ,GeoTypeID = 22420
     ,TotalEmployment = 145.5700 UNION ALL

  SELECT QuarterEndDate = '20191231'
  ,GeoTypeID = 22420
     ,TotalEmployment = 145.7200 UNION ALL

  SELECT QuarterEndDate = '20200331'
  ,GeoTypeID = 22420
     ,TotalEmployment = 145.8200 UNION ALL

  SELECT QuarterEndDate = '20200630'
  ,GeoTypeID = 22420
     ,TotalEmployment = 145.8400 UNION ALL

  SELECT QuarterEndDate = '20200930'
  ,GeoTypeID = 22420
     ,TotalEmployment = 145.8500 UNION ALL

  SELECT QuarterEndDate = '20201231'
  ,GeoTypeID = 22420
     ,TotalEmployment = 145.8500 UNION ALL

  SELECT QuarterEndDate = '20210331'
  ,GeoTypeID = 22420
     ,TotalEmployment = 145.8700 UNION ALL

  SELECT QuarterEndDate = '20210630'
  ,GeoTypeID = 22420
     ,TotalEmployment = 145.8800 UNION ALL

  SELECT QuarterEndDate = '20210930'
  ,GeoTypeID = 22420
     ,TotalEmployment = 145.9100 UNION ALL

  SELECT QuarterEndDate = '20211231'
  ,GeoTypeID = 22420
     ,TotalEmployment = 145.9600 UNION ALL

  SELECT QuarterEndDate = '20220331'
  ,GeoTypeID = 22420
     ,TotalEmployment = 146.0300 UNION ALL

  SELECT QuarterEndDate = '20220630'
  ,GeoTypeID = 22420
     ,TotalEmployment = 146.1300 UNION ALL

  SELECT QuarterEndDate = '20220930'
  ,GeoTypeID = 22420
     ,TotalEmployment = 146.2300 UNION ALL

  SELECT QuarterEndDate = '20221231'
  ,GeoTypeID = 22420
     ,TotalEmployment = 146.3500 UNION ALL

  SELECT QuarterEndDate = '20230331'
  ,GeoTypeID = 22420
     ,TotalEmployment = 146.4700 UNION ALL

  SELECT QuarterEndDate = '20230630'
  ,GeoTypeID = 22420
     ,TotalEmployment = 146.5900 UNION ALL

  SELECT QuarterEndDate = '20230930'
  ,GeoTypeID = 22420
     ,TotalEmployment = 146.7100 UNION ALL

  SELECT QuarterEndDate = '20231231'
  ,GeoTypeID = 22420
     ,TotalEmployment = 146.8200 UNION ALL

  SELECT QuarterEndDate = '20240331'
  ,GeoTypeID = 22420
     ,TotalEmployment = 146.9300 UNION ALL

  SELECT QuarterEndDate = '20240630'
  ,GeoTypeID = 22420
     ,TotalEmployment = 147.0400 UNION ALL

  SELECT QuarterEndDate = '20240930'
  ,GeoTypeID = 22420
     ,TotalEmployment = 147.1500 UNION ALL

  SELECT QuarterEndDate = '20241231'
  ,GeoTypeID = 22420
     ,TotalEmployment = 147.2400 UNION ALL

  SELECT QuarterEndDate = '20250331'
  ,GeoTypeID = 22420
     ,TotalEmployment = 147.3300 UNION ALL

  SELECT QuarterEndDate = '20250630'
  ,GeoTypeID = 22420
     ,TotalEmployment = 147.4100 UNION ALL

  SELECT QuarterEndDate = '20250930'
  ,GeoTypeID = 22420
     ,TotalEmployment = 147.5100 UNION ALL

  SELECT QuarterEndDate = '20251231'
  ,GeoTypeID = 22420
     ,TotalEmployment = 147.6000 UNION ALL

  SELECT QuarterEndDate = '20170930'
  ,GeoTypeID = 21140
     ,TotalEmployment = 125.0800 UNION ALL

  SELECT QuarterEndDate = '20171231'
  ,GeoTypeID = 21140
     ,TotalEmployment = 125.2900 UNION ALL

  SELECT QuarterEndDate = '20180331'
  ,GeoTypeID = 21140
     ,TotalEmployment = 125.4300 UNION ALL

  SELECT QuarterEndDate = '20180630'
  ,GeoTypeID = 21140
     ,TotalEmployment = 125.6400 UNION ALL

  SELECT QuarterEndDate = '20180930'
  ,GeoTypeID = 21140
     ,TotalEmployment = 125.9300 UNION ALL

  SELECT QuarterEndDate = '20181231'
  ,GeoTypeID = 21140
     ,TotalEmployment = 126.1700 UNION ALL

  SELECT QuarterEndDate = '20190331'
  ,GeoTypeID = 21140
     ,TotalEmployment = 126.4200 UNION ALL

  SELECT QuarterEndDate = '20190630'
  ,GeoTypeID = 21140
     ,TotalEmployment = 126.7400 UNION ALL

  SELECT QuarterEndDate = '20190930'
  ,GeoTypeID = 21140
     ,TotalEmployment = 127.0600 UNION ALL

  SELECT QuarterEndDate = '20191231'
  ,GeoTypeID = 21140
     ,TotalEmployment = 127.3100 UNION ALL

  SELECT QuarterEndDate = '20200331'
  ,GeoTypeID = 21140
     ,TotalEmployment = 127.5100 UNION ALL

  SELECT QuarterEndDate = '20200630'
  ,GeoTypeID = 21140
     ,TotalEmployment = 127.7100 UNION ALL

  SELECT QuarterEndDate = '20200930'
  ,GeoTypeID = 21140
     ,TotalEmployment = 127.9500 UNION ALL

  SELECT QuarterEndDate = '20201231'
  ,GeoTypeID = 21140
     ,TotalEmployment = 128.1500 UNION ALL

  SELECT QuarterEndDate = '20210331'
  ,GeoTypeID = 21140
     ,TotalEmployment = 128.3700 UNION ALL

  SELECT QuarterEndDate = '20210630'
  ,GeoTypeID = 21140
     ,TotalEmployment = 128.6100 UNION ALL

  SELECT QuarterEndDate = '20210930'
  ,GeoTypeID = 21140
     ,TotalEmployment = 128.8300 UNION ALL

  SELECT QuarterEndDate = '20211231'
  ,GeoTypeID = 21140
     ,TotalEmployment = 129.0800 UNION ALL

  SELECT QuarterEndDate = '20220331'
  ,GeoTypeID = 21140
     ,TotalEmployment = 129.3400 UNION ALL

  SELECT QuarterEndDate = '20220630'
  ,GeoTypeID = 21140
     ,TotalEmployment = 129.6200 UNION ALL

  SELECT QuarterEndDate = '20220930'
  ,GeoTypeID = 21140
     ,TotalEmployment = 129.9200 UNION ALL

  SELECT QuarterEndDate = '20221231'
  ,GeoTypeID = 21140
     ,TotalEmployment = 130.2200 UNION ALL

  SELECT QuarterEndDate = '20230331'
  ,GeoTypeID = 21140
     ,TotalEmployment = 130.5200 UNION ALL

  SELECT QuarterEndDate = '20230630'
  ,GeoTypeID = 21140
     ,TotalEmployment = 130.8400 UNION ALL

  SELECT QuarterEndDate = '20230930'
  ,GeoTypeID = 21140
     ,TotalEmployment = 131.1600 UNION ALL

  SELECT QuarterEndDate = '20231231'
  ,GeoTypeID = 21140
     ,TotalEmployment = 131.4800 UNION ALL

  SELECT QuarterEndDate = '20240331'
  ,GeoTypeID = 21140
     ,TotalEmployment = 131.7900 UNION ALL

  SELECT QuarterEndDate = '20240630'
  ,GeoTypeID = 21140
     ,TotalEmployment = 132.1100 UNION ALL

  SELECT QuarterEndDate = '20240930'
  ,GeoTypeID = 21140
     ,TotalEmployment = 132.4400 UNION ALL

  SELECT QuarterEndDate = '20241231'
  ,GeoTypeID = 21140
     ,TotalEmployment = 132.7600 UNION ALL

  SELECT QuarterEndDate = '20250331'
  ,GeoTypeID = 21140
     ,TotalEmployment = 133.0800 UNION ALL

  SELECT QuarterEndDate = '20250630'
  ,GeoTypeID = 21140
     ,TotalEmployment = 133.4300 UNION ALL

  SELECT QuarterEndDate = '20250930'
  ,GeoTypeID = 21140
     ,TotalEmployment = 133.7600 UNION ALL

  SELECT QuarterEndDate = '20251231'
  ,GeoTypeID = 21140
     ,TotalEmployment = 134.0900 UNION ALL

  SELECT QuarterEndDate = '20170930'
  ,GeoTypeID = 22540
     ,TotalEmployment = 49.2900 UNION ALL

  SELECT QuarterEndDate = '20171231'
  ,GeoTypeID = 22540
     ,TotalEmployment = 49.4300 UNION ALL

  SELECT QuarterEndDate = '20180331'
  ,GeoTypeID = 22540
     ,TotalEmployment = 49.5600 UNION ALL

  SELECT QuarterEndDate = '20180630'
  ,GeoTypeID = 22540
     ,TotalEmployment = 49.7700 UNION ALL

  SELECT QuarterEndDate = '20180930'
  ,GeoTypeID = 22540
     ,TotalEmployment = 49.9500 UNION ALL

  SELECT QuarterEndDate = '20181231'
  ,GeoTypeID = 22540
     ,TotalEmployment = 50.1100 UNION ALL

  SELECT QuarterEndDate = '20190331'
  ,GeoTypeID = 22540
     ,TotalEmployment = 50.2300 UNION ALL

  SELECT QuarterEndDate = '20190630'
  ,GeoTypeID = 22540
     ,TotalEmployment = 50.3900 UNION ALL

  SELECT QuarterEndDate = '20190930'
  ,GeoTypeID = 22540
     ,TotalEmployment = 50.4800 UNION ALL

  SELECT QuarterEndDate = '20191231'
  ,GeoTypeID = 22540
     ,TotalEmployment = 50.5400 UNION ALL

  SELECT QuarterEndDate = '20200331'
  ,GeoTypeID = 22540
     ,TotalEmployment = 50.5600 UNION ALL

  SELECT QuarterEndDate = '20200630'
  ,GeoTypeID = 22540
     ,TotalEmployment = 50.5800 UNION ALL

  SELECT QuarterEndDate = '20200930'
  ,GeoTypeID = 22540
     ,TotalEmployment = 50.6000 UNION ALL

  SELECT QuarterEndDate = '20201231'
  ,GeoTypeID = 22540
     ,TotalEmployment = 50.6300 UNION ALL

  SELECT QuarterEndDate = '20210331'
  ,GeoTypeID = 22540
     ,TotalEmployment = 50.6700 UNION ALL

  SELECT QuarterEndDate = '20210630'
  ,GeoTypeID = 22540
     ,TotalEmployment = 50.7100 UNION ALL

  SELECT QuarterEndDate = '20210930'
  ,GeoTypeID = 22540
     ,TotalEmployment = 50.7500 UNION ALL

  SELECT QuarterEndDate = '20211231'
  ,GeoTypeID = 22540
     ,TotalEmployment = 50.8000 UNION ALL

  SELECT QuarterEndDate = '20220331'
  ,GeoTypeID = 22540
     ,TotalEmployment = 50.8500 UNION ALL

  SELECT QuarterEndDate = '20220630'
  ,GeoTypeID = 22540
     ,TotalEmployment = 50.9000 UNION ALL

  SELECT QuarterEndDate = '20220930'
  ,GeoTypeID = 22540
     ,TotalEmployment = 50.9500 UNION ALL

  SELECT QuarterEndDate = '20221231'
  ,GeoTypeID = 22540
     ,TotalEmployment = 51.0100 UNION ALL

  SELECT QuarterEndDate = '20230331'
  ,GeoTypeID = 22540
     ,TotalEmployment = 51.0600 UNION ALL

  SELECT QuarterEndDate = '20230630'
  ,GeoTypeID = 22540
     ,TotalEmployment = 51.1100 UNION ALL

  SELECT QuarterEndDate = '20230930'
  ,GeoTypeID = 22540
     ,TotalEmployment = 51.1700 UNION ALL

  SELECT QuarterEndDate = '20231231'
  ,GeoTypeID = 22540
     ,TotalEmployment = 51.2300 UNION ALL

  SELECT QuarterEndDate = '20240331'
  ,GeoTypeID = 22540
     ,TotalEmployment = 51.2800 UNION ALL

  SELECT QuarterEndDate = '20240630'
  ,GeoTypeID = 22540
     ,TotalEmployment = 51.3400 UNION ALL

  SELECT QuarterEndDate = '20240930'
  ,GeoTypeID = 22540
     ,TotalEmployment = 51.4000 UNION ALL

  SELECT QuarterEndDate = '20241231'
  ,GeoTypeID = 22540
     ,TotalEmployment = 51.4600 UNION ALL

  SELECT QuarterEndDate = '20250331'
  ,GeoTypeID = 22540
     ,TotalEmployment = 51.5200 UNION ALL

  SELECT QuarterEndDate = '20250630'
  ,GeoTypeID = 22540
     ,TotalEmployment = 51.5700 UNION ALL

  SELECT QuarterEndDate = '20250930'
  ,GeoTypeID = 22540
     ,TotalEmployment = 51.6300 UNION ALL

  SELECT QuarterEndDate = '20251231'
  ,GeoTypeID = 22540
     ,TotalEmployment = 51.6900 UNION ALL

  SELECT QuarterEndDate = '20170930'
  ,GeoTypeID = 39540
     ,TotalEmployment = 79.5900 UNION ALL

  SELECT QuarterEndDate = '20171231'
  ,GeoTypeID = 39540
     ,TotalEmployment = 80.0200 UNION ALL

  SELECT QuarterEndDate = '20180331'
  ,GeoTypeID = 39540
     ,TotalEmployment = 80.4200 UNION ALL

  SELECT QuarterEndDate = '20180630'
  ,GeoTypeID = 39540
     ,TotalEmployment = 80.7800 UNION ALL

  SELECT QuarterEndDate = '20180930'
  ,GeoTypeID = 39540
     ,TotalEmployment = 81.0900 UNION ALL

  SELECT QuarterEndDate = '20181231'
  ,GeoTypeID = 39540
     ,TotalEmployment = 81.3600 UNION ALL

  SELECT QuarterEndDate = '20190331'
  ,GeoTypeID = 39540
     ,TotalEmployment = 81.5900 UNION ALL

  SELECT QuarterEndDate = '20190630'
  ,GeoTypeID = 39540
     ,TotalEmployment = 81.7800 UNION ALL

  SELECT QuarterEndDate = '20190930'
  ,GeoTypeID = 39540
     ,TotalEmployment = 81.9400 UNION ALL

  SELECT QuarterEndDate = '20191231'
  ,GeoTypeID = 39540
     ,TotalEmployment = 82.0700 UNION ALL

  SELECT QuarterEndDate = '20200331'
  ,GeoTypeID = 39540
     ,TotalEmployment = 82.1700 UNION ALL

  SELECT QuarterEndDate = '20200630'
  ,GeoTypeID = 39540
     ,TotalEmployment = 82.2500 UNION ALL

  SELECT QuarterEndDate = '20200930'
  ,GeoTypeID = 39540
     ,TotalEmployment = 82.3200 UNION ALL

  SELECT QuarterEndDate = '20201231'
  ,GeoTypeID = 39540
     ,TotalEmployment = 82.3800 UNION ALL

  SELECT QuarterEndDate = '20210331'
  ,GeoTypeID = 39540
     ,TotalEmployment = 82.4500 UNION ALL

  SELECT QuarterEndDate = '20210630'
  ,GeoTypeID = 39540
     ,TotalEmployment = 82.5300 UNION ALL

  SELECT QuarterEndDate = '20210930'
  ,GeoTypeID = 39540
     ,TotalEmployment = 82.6000 UNION ALL

  SELECT QuarterEndDate = '20211231'
  ,GeoTypeID = 39540
     ,TotalEmployment = 82.6800 UNION ALL

  SELECT QuarterEndDate = '20220331'
  ,GeoTypeID = 39540
     ,TotalEmployment = 82.7700 UNION ALL

  SELECT QuarterEndDate = '20220630'
  ,GeoTypeID = 39540
     ,TotalEmployment = 82.8600 UNION ALL

  SELECT QuarterEndDate = '20220930'
  ,GeoTypeID = 39540
     ,TotalEmployment = 82.9500 UNION ALL

  SELECT QuarterEndDate = '20221231'
  ,GeoTypeID = 39540
     ,TotalEmployment = 83.0400 UNION ALL

  SELECT QuarterEndDate = '20230331'
  ,GeoTypeID = 39540
     ,TotalEmployment = 83.1400 UNION ALL

  SELECT QuarterEndDate = '20230630'
  ,GeoTypeID = 39540
     ,TotalEmployment = 83.2400 UNION ALL

  SELECT QuarterEndDate = '20230930'
  ,GeoTypeID = 39540
     ,TotalEmployment = 83.3500 UNION ALL

  SELECT QuarterEndDate = '20231231'
  ,GeoTypeID = 39540
     ,TotalEmployment = 83.4500 UNION ALL

  SELECT QuarterEndDate = '20240331'
  ,GeoTypeID = 39540
     ,TotalEmployment = 83.5700 UNION ALL

  SELECT QuarterEndDate = '20240630'
  ,GeoTypeID = 39540
     ,TotalEmployment = 83.6800 UNION ALL

  SELECT QuarterEndDate = '20240930'
  ,GeoTypeID = 39540
     ,TotalEmployment = 83.7900 UNION ALL

  SELECT QuarterEndDate = '20241231'
  ,GeoTypeID = 39540
     ,TotalEmployment = 83.9000 UNION ALL

  SELECT QuarterEndDate = '20250331'
  ,GeoTypeID = 39540
     ,TotalEmployment = 84.0100 UNION ALL

  SELECT QuarterEndDate = '20250630'
  ,GeoTypeID = 39540
     ,TotalEmployment = 84.1200 UNION ALL

  SELECT QuarterEndDate = '20250930'
  ,GeoTypeID = 39540
     ,TotalEmployment = 84.2300 UNION ALL

  SELECT QuarterEndDate = '20251231'
  ,GeoTypeID = 39540
     ,TotalEmployment = 84.3500 UNION ALL

  SELECT QuarterEndDate = '20170930'
  ,GeoTypeID = 19380
     ,TotalEmployment = 393.5900 UNION ALL

  SELECT QuarterEndDate = '20171231'
  ,GeoTypeID = 19380
     ,TotalEmployment = 395.0700 UNION ALL

  SELECT QuarterEndDate = '20180331'
  ,GeoTypeID = 19380
     ,TotalEmployment = 396.4000 UNION ALL

  SELECT QuarterEndDate = '20180630'
  ,GeoTypeID = 19380
     ,TotalEmployment = 397.5700 UNION ALL

  SELECT QuarterEndDate = '20180930'
  ,GeoTypeID = 19380
     ,TotalEmployment = 398.7800 UNION ALL

  SELECT QuarterEndDate = '20181231'
  ,GeoTypeID = 19380
     ,TotalEmployment = 399.9600 UNION ALL

  SELECT QuarterEndDate = '20190331'
  ,GeoTypeID = 19380
     ,TotalEmployment = 401.0500 UNION ALL

  SELECT QuarterEndDate = '20190630'
  ,GeoTypeID = 19380
     ,TotalEmployment = 402.1600 UNION ALL

  SELECT QuarterEndDate = '20190930'
  ,GeoTypeID = 19380
     ,TotalEmployment = 403.1000 UNION ALL

  SELECT QuarterEndDate = '20191231'
  ,GeoTypeID = 19380
     ,TotalEmployment = 403.6800 UNION ALL

  SELECT QuarterEndDate = '20200331'
  ,GeoTypeID = 19380
     ,TotalEmployment = 404.1000 UNION ALL

  SELECT QuarterEndDate = '20200630'
  ,GeoTypeID = 19380
     ,TotalEmployment = 404.3700 UNION ALL

  SELECT QuarterEndDate = '20200930'
  ,GeoTypeID = 19380
     ,TotalEmployment = 404.6900 UNION ALL

  SELECT QuarterEndDate = '20201231'
  ,GeoTypeID = 19380
     ,TotalEmployment = 404.9200 UNION ALL

  SELECT QuarterEndDate = '20210331'
  ,GeoTypeID = 19380
     ,TotalEmployment = 405.2000 UNION ALL

  SELECT QuarterEndDate = '20210630'
  ,GeoTypeID = 19380
     ,TotalEmployment = 405.5000 UNION ALL

  SELECT QuarterEndDate = '20210930'
  ,GeoTypeID = 19380
     ,TotalEmployment = 405.8100 UNION ALL

  SELECT QuarterEndDate = '20211231'
  ,GeoTypeID = 19380
     ,TotalEmployment = 406.2300 UNION ALL

  SELECT QuarterEndDate = '20220331'
  ,GeoTypeID = 19380
     ,TotalEmployment = 406.7000 UNION ALL

  SELECT QuarterEndDate = '20220630'
  ,GeoTypeID = 19380
     ,TotalEmployment = 407.2200 UNION ALL

  SELECT QuarterEndDate = '20220930'
  ,GeoTypeID = 19380
     ,TotalEmployment = 407.7600 UNION ALL

  SELECT QuarterEndDate = '20221231'
  ,GeoTypeID = 19380
     ,TotalEmployment = 408.2800 UNION ALL

  SELECT QuarterEndDate = '20230331'
  ,GeoTypeID = 19380
     ,TotalEmployment = 408.8400 UNION ALL

  SELECT QuarterEndDate = '20230630'
  ,GeoTypeID = 19380
     ,TotalEmployment = 409.3800 UNION ALL

  SELECT QuarterEndDate = '20230930'
  ,GeoTypeID = 19380
     ,TotalEmployment = 409.9400 UNION ALL

  SELECT QuarterEndDate = '20231231'
  ,GeoTypeID = 19380
     ,TotalEmployment = 410.4800 UNION ALL

  SELECT QuarterEndDate = '20240331'
  ,GeoTypeID = 19380
     ,TotalEmployment = 411.0300 UNION ALL

  SELECT QuarterEndDate = '20240630'
  ,GeoTypeID = 19380
     ,TotalEmployment = 411.5700 UNION ALL

  SELECT QuarterEndDate = '20240930'
  ,GeoTypeID = 19380
     ,TotalEmployment = 412.1400 UNION ALL

  SELECT QuarterEndDate = '20241231'
  ,GeoTypeID = 19380
     ,TotalEmployment = 412.7000 UNION ALL

  SELECT QuarterEndDate = '20250331'
  ,GeoTypeID = 19380
     ,TotalEmployment = 413.2300 UNION ALL

  SELECT QuarterEndDate = '20250630'
  ,GeoTypeID = 19380
     ,TotalEmployment = 413.7900 UNION ALL

  SELECT QuarterEndDate = '20250930'
  ,GeoTypeID = 19380
     ,TotalEmployment = 414.3500 UNION ALL

  SELECT QuarterEndDate = '20251231'
  ,GeoTypeID = 19380
     ,TotalEmployment = 414.9200 UNION ALL

  SELECT QuarterEndDate = '20170930'
  ,GeoTypeID = 43780
     ,TotalEmployment = 142.3600 UNION ALL

  SELECT QuarterEndDate = '20171231'
  ,GeoTypeID = 43780
     ,TotalEmployment = 142.9400 UNION ALL

  SELECT QuarterEndDate = '20180331'
  ,GeoTypeID = 43780
     ,TotalEmployment = 143.4100 UNION ALL

  SELECT QuarterEndDate = '20180630'
  ,GeoTypeID = 43780
     ,TotalEmployment = 143.8400 UNION ALL

  SELECT QuarterEndDate = '20180930'
  ,GeoTypeID = 43780
     ,TotalEmployment = 144.3100 UNION ALL

  SELECT QuarterEndDate = '20181231'
  ,GeoTypeID = 43780
     ,TotalEmployment = 144.7200 UNION ALL

  SELECT QuarterEndDate = '20190331'
  ,GeoTypeID = 43780
     ,TotalEmployment = 145.2100 UNION ALL

  SELECT QuarterEndDate = '20190630'
  ,GeoTypeID = 43780
     ,TotalEmployment = 145.7100 UNION ALL

  SELECT QuarterEndDate = '20190930'
  ,GeoTypeID = 43780
     ,TotalEmployment = 146.1600 UNION ALL

  SELECT QuarterEndDate = '20191231'
  ,GeoTypeID = 43780
     ,TotalEmployment = 146.5000 UNION ALL

  SELECT QuarterEndDate = '20200331'
  ,GeoTypeID = 43780
     ,TotalEmployment = 146.7500 UNION ALL

  SELECT QuarterEndDate = '20200630'
  ,GeoTypeID = 43780
     ,TotalEmployment = 146.8500 UNION ALL

  SELECT QuarterEndDate = '20200930'
  ,GeoTypeID = 43780
     ,TotalEmployment = 146.9300 UNION ALL

  SELECT QuarterEndDate = '20201231'
  ,GeoTypeID = 43780
     ,TotalEmployment = 146.9600 UNION ALL

  SELECT QuarterEndDate = '20210331'
  ,GeoTypeID = 43780
     ,TotalEmployment = 146.9900 UNION ALL

  SELECT QuarterEndDate = '20210630'
  ,GeoTypeID = 43780
     ,TotalEmployment = 147.0200 UNION ALL

  SELECT QuarterEndDate = '20210930'
  ,GeoTypeID = 43780
     ,TotalEmployment = 147.0400 UNION ALL

  SELECT QuarterEndDate = '20211231'
  ,GeoTypeID = 43780
     ,TotalEmployment = 147.1000 UNION ALL

  SELECT QuarterEndDate = '20220331'
  ,GeoTypeID = 43780
     ,TotalEmployment = 147.1700 UNION ALL

  SELECT QuarterEndDate = '20220630'
  ,GeoTypeID = 43780
     ,TotalEmployment = 147.2500 UNION ALL

  SELECT QuarterEndDate = '20220930'
  ,GeoTypeID = 43780
     ,TotalEmployment = 147.3300 UNION ALL

  SELECT QuarterEndDate = '20221231'
  ,GeoTypeID = 43780
     ,TotalEmployment = 147.4400 UNION ALL

  SELECT QuarterEndDate = '20230331'
  ,GeoTypeID = 43780
     ,TotalEmployment = 147.5500 UNION ALL

  SELECT QuarterEndDate = '20230630'
  ,GeoTypeID = 43780
     ,TotalEmployment = 147.6600 UNION ALL

  SELECT QuarterEndDate = '20230930'
  ,GeoTypeID = 43780
     ,TotalEmployment = 147.7700 UNION ALL

  SELECT QuarterEndDate = '20231231'
  ,GeoTypeID = 43780
     ,TotalEmployment = 147.8900 UNION ALL

  SELECT QuarterEndDate = '20240331'
  ,GeoTypeID = 43780
     ,TotalEmployment = 148.0000 UNION ALL

  SELECT QuarterEndDate = '20240630'
  ,GeoTypeID = 43780
     ,TotalEmployment = 148.1100 UNION ALL

  SELECT QuarterEndDate = '20240930'
  ,GeoTypeID = 43780
     ,TotalEmployment = 148.2300 UNION ALL

  SELECT QuarterEndDate = '20241231'
  ,GeoTypeID = 43780
     ,TotalEmployment = 148.3500 UNION ALL

  SELECT QuarterEndDate = '20250331'
  ,GeoTypeID = 43780
     ,TotalEmployment = 148.4700 UNION ALL

  SELECT QuarterEndDate = '20250630'
  ,GeoTypeID = 43780
     ,TotalEmployment = 148.6000 UNION ALL

  SELECT QuarterEndDate = '20250930'
  ,GeoTypeID = 43780
     ,TotalEmployment = 148.7300 UNION ALL

  SELECT QuarterEndDate = '20251231'
  ,GeoTypeID = 43780
     ,TotalEmployment = 148.8600 UNION ALL

  SELECT QuarterEndDate = '20170930'
  ,GeoTypeID = 31540
     ,TotalEmployment = 402.2400 UNION ALL

  SELECT QuarterEndDate = '20171231'
  ,GeoTypeID = 31540
     ,TotalEmployment = 403.6500 UNION ALL

  SELECT QuarterEndDate = '20180331'
  ,GeoTypeID = 31540
     ,TotalEmployment = 404.9900 UNION ALL

  SELECT QuarterEndDate = '20180630'
  ,GeoTypeID = 31540
     ,TotalEmployment = 406.2400 UNION ALL

  SELECT QuarterEndDate = '20180930'
  ,GeoTypeID = 31540
     ,TotalEmployment = 407.3400 UNION ALL

  SELECT QuarterEndDate = '20181231'
  ,GeoTypeID = 31540
     ,TotalEmployment = 408.3000 UNION ALL

  SELECT QuarterEndDate = '20190331'
  ,GeoTypeID = 31540
     ,TotalEmployment = 409.1300 UNION ALL

  SELECT QuarterEndDate = '20190630'
  ,GeoTypeID = 31540
     ,TotalEmployment = 409.8600 UNION ALL

  SELECT QuarterEndDate = '20190930'
  ,GeoTypeID = 31540
     ,TotalEmployment = 410.4600 UNION ALL

  SELECT QuarterEndDate = '20191231'
  ,GeoTypeID = 31540
     ,TotalEmployment = 410.9300 UNION ALL

  SELECT QuarterEndDate = '20200331'
  ,GeoTypeID = 31540
     ,TotalEmployment = 411.3000 UNION ALL

  SELECT QuarterEndDate = '20200630'
  ,GeoTypeID = 31540
     ,TotalEmployment = 411.6100 UNION ALL

  SELECT QuarterEndDate = '20200930'
  ,GeoTypeID = 31540
     ,TotalEmployment = 411.8900 UNION ALL

  SELECT QuarterEndDate = '20201231'
  ,GeoTypeID = 31540
     ,TotalEmployment = 412.1900 UNION ALL

  SELECT QuarterEndDate = '20210331'
  ,GeoTypeID = 31540
     ,TotalEmployment = 412.4900 UNION ALL

  SELECT QuarterEndDate = '20210630'
  ,GeoTypeID = 31540
     ,TotalEmployment = 412.8400 UNION ALL

  SELECT QuarterEndDate = '20210930'
  ,GeoTypeID = 31540
     ,TotalEmployment = 413.2000 UNION ALL

  SELECT QuarterEndDate = '20211231'
  ,GeoTypeID = 31540
     ,TotalEmployment = 413.5800 UNION ALL

  SELECT QuarterEndDate = '20220331'
  ,GeoTypeID = 31540
     ,TotalEmployment = 413.9700 UNION ALL

  SELECT QuarterEndDate = '20220630'
  ,GeoTypeID = 31540
     ,TotalEmployment = 414.3800 UNION ALL

  SELECT QuarterEndDate = '20220930'
  ,GeoTypeID = 31540
     ,TotalEmployment = 414.8000 UNION ALL

  SELECT QuarterEndDate = '20221231'
  ,GeoTypeID = 31540
     ,TotalEmployment = 415.2400 UNION ALL

  SELECT QuarterEndDate = '20230331'
  ,GeoTypeID = 31540
     ,TotalEmployment = 415.6700 UNION ALL

  SELECT QuarterEndDate = '20230630'
  ,GeoTypeID = 31540
     ,TotalEmployment = 416.1300 UNION ALL

  SELECT QuarterEndDate = '20230930'
  ,GeoTypeID = 31540
     ,TotalEmployment = 416.6000 UNION ALL

  SELECT QuarterEndDate = '20231231'
  ,GeoTypeID = 31540
     ,TotalEmployment = 417.0900 UNION ALL

  SELECT QuarterEndDate = '20240331'
  ,GeoTypeID = 31540
     ,TotalEmployment = 417.5900 UNION ALL

  SELECT QuarterEndDate = '20240630'
  ,GeoTypeID = 31540
     ,TotalEmployment = 418.1000 UNION ALL

  SELECT QuarterEndDate = '20240930'
  ,GeoTypeID = 31540
     ,TotalEmployment = 418.6100 UNION ALL

  SELECT QuarterEndDate = '20241231'
  ,GeoTypeID = 31540
     ,TotalEmployment = 419.1300 UNION ALL

  SELECT QuarterEndDate = '20250331'
  ,GeoTypeID = 31540
     ,TotalEmployment = 419.6500 UNION ALL

  SELECT QuarterEndDate = '20250630'
  ,GeoTypeID = 31540
     ,TotalEmployment = 420.1800 UNION ALL

  SELECT QuarterEndDate = '20250930'
  ,GeoTypeID = 31540
     ,TotalEmployment = 420.7100 UNION ALL

  SELECT QuarterEndDate = '20251231'
  ,GeoTypeID = 31540
     ,TotalEmployment = 421.2600 UNION ALL

  SELECT QuarterEndDate = '20170930'
  ,GeoTypeID = 11540
     ,TotalEmployment = 127.6700 UNION ALL

  SELECT QuarterEndDate = '20171231'
  ,GeoTypeID = 11540
     ,TotalEmployment = 128.2500 UNION ALL

  SELECT QuarterEndDate = '20180331'
  ,GeoTypeID = 11540
     ,TotalEmployment = 128.8200 UNION ALL

  SELECT QuarterEndDate = '20180630'
  ,GeoTypeID = 11540
     ,TotalEmployment = 129.3000 UNION ALL

  SELECT QuarterEndDate = '20180930'
  ,GeoTypeID = 11540
     ,TotalEmployment = 129.7200 UNION ALL

  SELECT QuarterEndDate = '20181231'
  ,GeoTypeID = 11540
     ,TotalEmployment = 130.1400 UNION ALL

  SELECT QuarterEndDate = '20190331'
  ,GeoTypeID = 11540
     ,TotalEmployment = 130.5200 UNION ALL

  SELECT QuarterEndDate = '20190630'
  ,GeoTypeID = 11540
     ,TotalEmployment = 130.8500 UNION ALL

  SELECT QuarterEndDate = '20190930'
  ,GeoTypeID = 11540
     ,TotalEmployment = 131.1800 UNION ALL

  SELECT QuarterEndDate = '20191231'
  ,GeoTypeID = 11540
     ,TotalEmployment = 131.4100 UNION ALL

  SELECT QuarterEndDate = '20200331'
  ,GeoTypeID = 11540
     ,TotalEmployment = 131.6200 UNION ALL

  SELECT QuarterEndDate = '20200630'
  ,GeoTypeID = 11540
     ,TotalEmployment = 131.8000 UNION ALL

  SELECT QuarterEndDate = '20200930'
  ,GeoTypeID = 11540
     ,TotalEmployment = 131.9300 UNION ALL

  SELECT QuarterEndDate = '20201231'
  ,GeoTypeID = 11540
     ,TotalEmployment = 132.0900 UNION ALL

  SELECT QuarterEndDate = '20210331'
  ,GeoTypeID = 11540
     ,TotalEmployment = 132.2600 UNION ALL

  SELECT QuarterEndDate = '20210630'
  ,GeoTypeID = 11540
     ,TotalEmployment = 132.4000 UNION ALL

  SELECT QuarterEndDate = '20210930'
  ,GeoTypeID = 11540
     ,TotalEmployment = 132.5800 UNION ALL

  SELECT QuarterEndDate = '20211231'
  ,GeoTypeID = 11540
     ,TotalEmployment = 132.7600 UNION ALL

  SELECT QuarterEndDate = '20220331'
  ,GeoTypeID = 11540
     ,TotalEmployment = 132.9500 UNION ALL

  SELECT QuarterEndDate = '20220630'
  ,GeoTypeID = 11540
     ,TotalEmployment = 133.1500 UNION ALL

  SELECT QuarterEndDate = '20220930'
  ,GeoTypeID = 11540
     ,TotalEmployment = 133.3500 UNION ALL

  SELECT QuarterEndDate = '20221231'
  ,GeoTypeID = 11540
     ,TotalEmployment = 133.5700 UNION ALL

  SELECT QuarterEndDate = '20230331'
  ,GeoTypeID = 11540
     ,TotalEmployment = 133.7700 UNION ALL

  SELECT QuarterEndDate = '20230630'
  ,GeoTypeID = 11540
     ,TotalEmployment = 133.9800 UNION ALL

  SELECT QuarterEndDate = '20230930'
  ,GeoTypeID = 11540
     ,TotalEmployment = 134.2100 UNION ALL

  SELECT QuarterEndDate = '20231231'
  ,GeoTypeID = 11540
     ,TotalEmployment = 134.4300 UNION ALL

  SELECT QuarterEndDate = '20240331'
  ,GeoTypeID = 11540
     ,TotalEmployment = 134.6700 UNION ALL

  SELECT QuarterEndDate = '20240630'
  ,GeoTypeID = 11540
     ,TotalEmployment = 134.9000 UNION ALL

  SELECT QuarterEndDate = '20240930'
  ,GeoTypeID = 11540
     ,TotalEmployment = 135.1200 UNION ALL

  SELECT QuarterEndDate = '20241231'
  ,GeoTypeID = 11540
     ,TotalEmployment = 135.3500 UNION ALL

  SELECT QuarterEndDate = '20250331'
  ,GeoTypeID = 11540
     ,TotalEmployment = 135.5800 UNION ALL

  SELECT QuarterEndDate = '20250630'
  ,GeoTypeID = 11540
     ,TotalEmployment = 135.8100 UNION ALL

  SELECT QuarterEndDate = '20250930'
  ,GeoTypeID = 11540
     ,TotalEmployment = 136.0400 UNION ALL

  SELECT QuarterEndDate = '20251231'
  ,GeoTypeID = 11540
     ,TotalEmployment = 136.2800 UNION ALL

  SELECT QuarterEndDate = '20170930'
  ,GeoTypeID = 29940
     ,TotalEmployment = 54.3700 UNION ALL

  SELECT QuarterEndDate = '20171231'
  ,GeoTypeID = 29940
     ,TotalEmployment = 54.7000 UNION ALL

  SELECT QuarterEndDate = '20180331'
  ,GeoTypeID = 29940
     ,TotalEmployment = 55.0100 UNION ALL

  SELECT QuarterEndDate = '20180630'
  ,GeoTypeID = 29940
     ,TotalEmployment = 55.3000 UNION ALL

  SELECT QuarterEndDate = '20180930'
  ,GeoTypeID = 29940
     ,TotalEmployment = 55.5600 UNION ALL

  SELECT QuarterEndDate = '20181231'
  ,GeoTypeID = 29940
     ,TotalEmployment = 55.8100 UNION ALL

  SELECT QuarterEndDate = '20190331'
  ,GeoTypeID = 29940
     ,TotalEmployment = 56.0500 UNION ALL

  SELECT QuarterEndDate = '20190630'
  ,GeoTypeID = 29940
     ,TotalEmployment = 56.2800 UNION ALL

  SELECT QuarterEndDate = '20190930'
  ,GeoTypeID = 29940
     ,TotalEmployment = 56.4700 UNION ALL

  SELECT QuarterEndDate = '20191231'
  ,GeoTypeID = 29940
     ,TotalEmployment = 56.6300 UNION ALL

  SELECT QuarterEndDate = '20200331'
  ,GeoTypeID = 29940
     ,TotalEmployment = 56.7500 UNION ALL

  SELECT QuarterEndDate = '20200630'
  ,GeoTypeID = 29940
     ,TotalEmployment = 56.8400 UNION ALL

  SELECT QuarterEndDate = '20200930'
  ,GeoTypeID = 29940
     ,TotalEmployment = 56.9300 UNION ALL

  SELECT QuarterEndDate = '20201231'
  ,GeoTypeID = 29940
     ,TotalEmployment = 57.0200 UNION ALL

  SELECT QuarterEndDate = '20210331'
  ,GeoTypeID = 29940
     ,TotalEmployment = 57.1100 UNION ALL

  SELECT QuarterEndDate = '20210630'
  ,GeoTypeID = 29940
     ,TotalEmployment = 57.2200 UNION ALL

  SELECT QuarterEndDate = '20210930'
  ,GeoTypeID = 29940
     ,TotalEmployment = 57.3200 UNION ALL

  SELECT QuarterEndDate = '20211231'
  ,GeoTypeID = 29940
     ,TotalEmployment = 57.4400 UNION ALL

  SELECT QuarterEndDate = '20220331'
  ,GeoTypeID = 29940
     ,TotalEmployment = 57.5700 UNION ALL

  SELECT QuarterEndDate = '20220630'
  ,GeoTypeID = 29940
     ,TotalEmployment = 57.7000 UNION ALL

  SELECT QuarterEndDate = '20220930'
  ,GeoTypeID = 29940
     ,TotalEmployment = 57.8500 UNION ALL

  SELECT QuarterEndDate = '20221231'
  ,GeoTypeID = 29940
     ,TotalEmployment = 57.9900 UNION ALL

  SELECT QuarterEndDate = '20230331'
  ,GeoTypeID = 29940
     ,TotalEmployment = 58.1300 UNION ALL

  SELECT QuarterEndDate = '20230630'
  ,GeoTypeID = 29940
     ,TotalEmployment = 58.2700 UNION ALL

  SELECT QuarterEndDate = '20230930'
  ,GeoTypeID = 29940
     ,TotalEmployment = 58.4000 UNION ALL

  SELECT QuarterEndDate = '20231231'
  ,GeoTypeID = 29940
     ,TotalEmployment = 58.5300 UNION ALL

  SELECT QuarterEndDate = '20240331'
  ,GeoTypeID = 29940
     ,TotalEmployment = 58.6600 UNION ALL

  SELECT QuarterEndDate = '20240630'
  ,GeoTypeID = 29940
     ,TotalEmployment = 58.7800 UNION ALL

  SELECT QuarterEndDate = '20240930'
  ,GeoTypeID = 29940
     ,TotalEmployment = 58.9100 UNION ALL

  SELECT QuarterEndDate = '20241231'
  ,GeoTypeID = 29940
     ,TotalEmployment = 59.0400 UNION ALL

  SELECT QuarterEndDate = '20250331'
  ,GeoTypeID = 29940
     ,TotalEmployment = 59.1700 UNION ALL

  SELECT QuarterEndDate = '20250630'
  ,GeoTypeID = 29940
     ,TotalEmployment = 59.3000 UNION ALL

  SELECT QuarterEndDate = '20250930'
  ,GeoTypeID = 29940
     ,TotalEmployment = 59.4300 UNION ALL

  SELECT QuarterEndDate = '20251231'
  ,GeoTypeID = 29940
     ,TotalEmployment = 59.5600 UNION ALL

  SELECT QuarterEndDate = '20170930'
  ,GeoTypeID = 11460
     ,TotalEmployment = 226.5500 UNION ALL

  SELECT QuarterEndDate = '20171231'
  ,GeoTypeID = 11460
     ,TotalEmployment = 227.5100 UNION ALL

  SELECT QuarterEndDate = '20180331'
  ,GeoTypeID = 11460
     ,TotalEmployment = 228.4500 UNION ALL

  SELECT QuarterEndDate = '20180630'
  ,GeoTypeID = 11460
     ,TotalEmployment = 229.2800 UNION ALL

  SELECT QuarterEndDate = '20180930'
  ,GeoTypeID = 11460
     ,TotalEmployment = 230.0700 UNION ALL

  SELECT QuarterEndDate = '20181231'
  ,GeoTypeID = 11460
     ,TotalEmployment = 230.8300 UNION ALL

  SELECT QuarterEndDate = '20190331'
  ,GeoTypeID = 11460
     ,TotalEmployment = 231.5400 UNION ALL

  SELECT QuarterEndDate = '20190630'
  ,GeoTypeID = 11460
     ,TotalEmployment = 232.2700 UNION ALL

  SELECT QuarterEndDate = '20190930'
  ,GeoTypeID = 11460
     ,TotalEmployment = 232.8900 UNION ALL

  SELECT QuarterEndDate = '20191231'
  ,GeoTypeID = 11460
     ,TotalEmployment = 233.3300 UNION ALL

  SELECT QuarterEndDate = '20200331'
  ,GeoTypeID = 11460
     ,TotalEmployment = 233.6800 UNION ALL

  SELECT QuarterEndDate = '20200630'
  ,GeoTypeID = 11460
     ,TotalEmployment = 233.9700 UNION ALL

  SELECT QuarterEndDate = '20200930'
  ,GeoTypeID = 11460
     ,TotalEmployment = 234.2800 UNION ALL

  SELECT QuarterEndDate = '20201231'
  ,GeoTypeID = 11460
     ,TotalEmployment = 234.5900 UNION ALL

  SELECT QuarterEndDate = '20210331'
  ,GeoTypeID = 11460
     ,TotalEmployment = 234.8900 UNION ALL

  SELECT QuarterEndDate = '20210630'
  ,GeoTypeID = 11460
     ,TotalEmployment = 235.2300 UNION ALL

  SELECT QuarterEndDate = '20210930'
  ,GeoTypeID = 11460
     ,TotalEmployment = 235.5800 UNION ALL

  SELECT QuarterEndDate = '20211231'
  ,GeoTypeID = 11460
     ,TotalEmployment = 235.9900 UNION ALL

  SELECT QuarterEndDate = '20220331'
  ,GeoTypeID = 11460
     ,TotalEmployment = 236.3800 UNION ALL

  SELECT QuarterEndDate = '20220630'
  ,GeoTypeID = 11460
     ,TotalEmployment = 236.8100 UNION ALL

  SELECT QuarterEndDate = '20220930'
  ,GeoTypeID = 11460
     ,TotalEmployment = 237.2400 UNION ALL

  SELECT QuarterEndDate = '20221231'
  ,GeoTypeID = 11460
     ,TotalEmployment = 237.6900 UNION ALL

  SELECT QuarterEndDate = '20230331'
  ,GeoTypeID = 11460
     ,TotalEmployment = 238.1400 UNION ALL

  SELECT QuarterEndDate = '20230630'
  ,GeoTypeID = 11460
     ,TotalEmployment = 238.6000 UNION ALL

  SELECT QuarterEndDate = '20230930'
  ,GeoTypeID = 11460
     ,TotalEmployment = 239.0400 UNION ALL

  SELECT QuarterEndDate = '20231231'
  ,GeoTypeID = 11460
     ,TotalEmployment = 239.5000 UNION ALL

  SELECT QuarterEndDate = '20240331'
  ,GeoTypeID = 11460
     ,TotalEmployment = 239.9400 UNION ALL

  SELECT QuarterEndDate = '20240630'
  ,GeoTypeID = 11460
     ,TotalEmployment = 240.4000 UNION ALL

  SELECT QuarterEndDate = '20240930'
  ,GeoTypeID = 11460
     ,TotalEmployment = 240.8700 UNION ALL

  SELECT QuarterEndDate = '20241231'
  ,GeoTypeID = 11460
     ,TotalEmployment = 241.3400 UNION ALL

  SELECT QuarterEndDate = '20250331'
  ,GeoTypeID = 11460
     ,TotalEmployment = 241.8000 UNION ALL

  SELECT QuarterEndDate = '20250630'
  ,GeoTypeID = 11460
     ,TotalEmployment = 242.2600 UNION ALL

  SELECT QuarterEndDate = '20250930'
  ,GeoTypeID = 11460
     ,TotalEmployment = 242.7300 UNION ALL

  SELECT QuarterEndDate = '20251231'
  ,GeoTypeID = 11460
     ,TotalEmployment = 243.2000 UNION ALL

  SELECT QuarterEndDate = '20170930'
  ,GeoTypeID = 22220
     ,TotalEmployment = 248.5600 UNION ALL

  SELECT QuarterEndDate = '20171231'
  ,GeoTypeID = 22220
     ,TotalEmployment = 249.7400 UNION ALL

  SELECT QuarterEndDate = '20180331'
  ,GeoTypeID = 22220
     ,TotalEmployment = 250.7900 UNION ALL

  SELECT QuarterEndDate = '20180630'
  ,GeoTypeID = 22220
     ,TotalEmployment = 251.8900 UNION ALL

  SELECT QuarterEndDate = '20180930'
  ,GeoTypeID = 22220
     ,TotalEmployment = 253.0100 UNION ALL

  SELECT QuarterEndDate = '20181231'
  ,GeoTypeID = 22220
     ,TotalEmployment = 254.1000 UNION ALL

  SELECT QuarterEndDate = '20190331'
  ,GeoTypeID = 22220
     ,TotalEmployment = 255.1600 UNION ALL

  SELECT QuarterEndDate = '20190630'
  ,GeoTypeID = 22220
     ,TotalEmployment = 256.2500 UNION ALL

  SELECT QuarterEndDate = '20190930'
  ,GeoTypeID = 22220
     ,TotalEmployment = 257.1600 UNION ALL

  SELECT QuarterEndDate = '20191231'
  ,GeoTypeID = 22220
     ,TotalEmployment = 257.8800 UNION ALL

  SELECT QuarterEndDate = '20200331'
  ,GeoTypeID = 22220
     ,TotalEmployment = 258.4200 UNION ALL

  SELECT QuarterEndDate = '20200630'
  ,GeoTypeID = 22220
     ,TotalEmployment = 258.7600 UNION ALL

  SELECT QuarterEndDate = '20200930'
  ,GeoTypeID = 22220
     ,TotalEmployment = 259.1900 UNION ALL

  SELECT QuarterEndDate = '20201231'
  ,GeoTypeID = 22220
     ,TotalEmployment = 259.6100 UNION ALL

  SELECT QuarterEndDate = '20210331'
  ,GeoTypeID = 22220
     ,TotalEmployment = 260.0500 UNION ALL

  SELECT QuarterEndDate = '20210630'
  ,GeoTypeID = 22220
     ,TotalEmployment = 260.5800 UNION ALL

  SELECT QuarterEndDate = '20210930'
  ,GeoTypeID = 22220
     ,TotalEmployment = 261.1000 UNION ALL

  SELECT QuarterEndDate = '20211231'
  ,GeoTypeID = 22220
     ,TotalEmployment = 261.6900 UNION ALL

  SELECT QuarterEndDate = '20220331'
  ,GeoTypeID = 22220
     ,TotalEmployment = 262.3100 UNION ALL

  SELECT QuarterEndDate = '20220630'
  ,GeoTypeID = 22220
     ,TotalEmployment = 262.9700 UNION ALL

  SELECT QuarterEndDate = '20220930'
  ,GeoTypeID = 22220
     ,TotalEmployment = 263.6900 UNION ALL

  SELECT QuarterEndDate = '20221231'
  ,GeoTypeID = 22220
     ,TotalEmployment = 264.4200 UNION ALL

  SELECT QuarterEndDate = '20230331'
  ,GeoTypeID = 22220
     ,TotalEmployment = 265.2000 UNION ALL

  SELECT QuarterEndDate = '20230630'
  ,GeoTypeID = 22220
     ,TotalEmployment = 265.9400 UNION ALL

  SELECT QuarterEndDate = '20230930'
  ,GeoTypeID = 22220
     ,TotalEmployment = 266.6100 UNION ALL

  SELECT QuarterEndDate = '20231231'
  ,GeoTypeID = 22220
     ,TotalEmployment = 267.3200 UNION ALL

  SELECT QuarterEndDate = '20240331'
  ,GeoTypeID = 22220
     ,TotalEmployment = 268.0000 UNION ALL

  SELECT QuarterEndDate = '20240630'
  ,GeoTypeID = 22220
     ,TotalEmployment = 268.6900 UNION ALL

  SELECT QuarterEndDate = '20240930'
  ,GeoTypeID = 22220
     ,TotalEmployment = 269.3900 UNION ALL

  SELECT QuarterEndDate = '20241231'
  ,GeoTypeID = 22220
     ,TotalEmployment = 270.1000 UNION ALL

  SELECT QuarterEndDate = '20250331'
  ,GeoTypeID = 22220
     ,TotalEmployment = 270.8200 UNION ALL

  SELECT QuarterEndDate = '20250630'
  ,GeoTypeID = 22220
     ,TotalEmployment = 271.5400 UNION ALL

  SELECT QuarterEndDate = '20250930'
  ,GeoTypeID = 22220
     ,TotalEmployment = 272.2700 UNION ALL

  SELECT QuarterEndDate = '20251231'
  ,GeoTypeID = 22220
     ,TotalEmployment = 273.0200 UNION ALL

  SELECT QuarterEndDate = '20170930'
  ,GeoTypeID = 26580
     ,TotalEmployment = 142.8700 UNION ALL

  SELECT QuarterEndDate = '20171231'
  ,GeoTypeID = 26580
     ,TotalEmployment = 143.2200 UNION ALL

  SELECT QuarterEndDate = '20180331'
  ,GeoTypeID = 26580
     ,TotalEmployment = 143.7200 UNION ALL

  SELECT QuarterEndDate = '20180630'
  ,GeoTypeID = 26580
     ,TotalEmployment = 144.1800 UNION ALL

  SELECT QuarterEndDate = '20180930'
  ,GeoTypeID = 26580
     ,TotalEmployment = 144.6300 UNION ALL

  SELECT QuarterEndDate = '20181231'
  ,GeoTypeID = 26580
     ,TotalEmployment = 145.1000 UNION ALL

  SELECT QuarterEndDate = '20190331'
  ,GeoTypeID = 26580
     ,TotalEmployment = 145.5000 UNION ALL

  SELECT QuarterEndDate = '20190630'
  ,GeoTypeID = 26580
     ,TotalEmployment = 145.8800 UNION ALL

  SELECT QuarterEndDate = '20190930'
  ,GeoTypeID = 26580
     ,TotalEmployment = 146.1800 UNION ALL

  SELECT QuarterEndDate = '20191231'
  ,GeoTypeID = 26580
     ,TotalEmployment = 146.3600 UNION ALL

  SELECT QuarterEndDate = '20200331'
  ,GeoTypeID = 26580
     ,TotalEmployment = 146.5000 UNION ALL

  SELECT QuarterEndDate = '20200630'
  ,GeoTypeID = 26580
     ,TotalEmployment = 146.6100 UNION ALL

  SELECT QuarterEndDate = '20200930'
  ,GeoTypeID = 26580
     ,TotalEmployment = 146.7900 UNION ALL

  SELECT QuarterEndDate = '20201231'
  ,GeoTypeID = 26580
     ,TotalEmployment = 146.9800 UNION ALL

  SELECT QuarterEndDate = '20210331'
  ,GeoTypeID = 26580
     ,TotalEmployment = 147.0500 UNION ALL

  SELECT QuarterEndDate = '20210630'
  ,GeoTypeID = 26580
     ,TotalEmployment = 147.1400 UNION ALL

  SELECT QuarterEndDate = '20210930'
  ,GeoTypeID = 26580
     ,TotalEmployment = 147.2200 UNION ALL

  SELECT QuarterEndDate = '20211231'
  ,GeoTypeID = 26580
     ,TotalEmployment = 147.3100 UNION ALL

  SELECT QuarterEndDate = '20220331'
  ,GeoTypeID = 26580
     ,TotalEmployment = 147.4200 UNION ALL

  SELECT QuarterEndDate = '20220630'
  ,GeoTypeID = 26580
     ,TotalEmployment = 147.5400 UNION ALL

  SELECT QuarterEndDate = '20220930'
  ,GeoTypeID = 26580
     ,TotalEmployment = 147.6700 UNION ALL

  SELECT QuarterEndDate = '20221231'
  ,GeoTypeID = 26580
     ,TotalEmployment = 147.7900 UNION ALL

  SELECT QuarterEndDate = '20230331'
  ,GeoTypeID = 26580
     ,TotalEmployment = 147.9200 UNION ALL

  SELECT QuarterEndDate = '20230630'
  ,GeoTypeID = 26580
     ,TotalEmployment = 148.0500 UNION ALL

  SELECT QuarterEndDate = '20230930'
  ,GeoTypeID = 26580
     ,TotalEmployment = 148.2000 UNION ALL

  SELECT QuarterEndDate = '20231231'
  ,GeoTypeID = 26580
     ,TotalEmployment = 148.3400 UNION ALL

  SELECT QuarterEndDate = '20240331'
  ,GeoTypeID = 26580
     ,TotalEmployment = 148.4800 UNION ALL

  SELECT QuarterEndDate = '20240630'
  ,GeoTypeID = 26580
     ,TotalEmployment = 148.6200 UNION ALL

  SELECT QuarterEndDate = '20240930'
  ,GeoTypeID = 26580
     ,TotalEmployment = 148.7700 UNION ALL

  SELECT QuarterEndDate = '20241231'
  ,GeoTypeID = 26580
     ,TotalEmployment = 148.9100 UNION ALL

  SELECT QuarterEndDate = '20250331'
  ,GeoTypeID = 26580
     ,TotalEmployment = 149.0600 UNION ALL

  SELECT QuarterEndDate = '20250630'
  ,GeoTypeID = 26580
     ,TotalEmployment = 149.2100 UNION ALL

  SELECT QuarterEndDate = '20250930'
  ,GeoTypeID = 26580
     ,TotalEmployment = 149.3700 UNION ALL

  SELECT QuarterEndDate = '20251231'
  ,GeoTypeID = 26580
     ,TotalEmployment = 149.5200 UNION ALL

  SELECT QuarterEndDate = '20170930'
  ,GeoTypeID = 12980
     ,TotalEmployment = 60.3000 UNION ALL

  SELECT QuarterEndDate = '20171231'
  ,GeoTypeID = 12980
     ,TotalEmployment = 60.4600 UNION ALL

  SELECT QuarterEndDate = '20180331'
  ,GeoTypeID = 12980
     ,TotalEmployment = 60.6400 UNION ALL

  SELECT QuarterEndDate = '20180630'
  ,GeoTypeID = 12980
     ,TotalEmployment = 60.8200 UNION ALL

  SELECT QuarterEndDate = '20180930'
  ,GeoTypeID = 12980
     ,TotalEmployment = 60.9900 UNION ALL

  SELECT QuarterEndDate = '20181231'
  ,GeoTypeID = 12980
     ,TotalEmployment = 61.1400 UNION ALL

  SELECT QuarterEndDate = '20190331'
  ,GeoTypeID = 12980
     ,TotalEmployment = 61.3000 UNION ALL

  SELECT QuarterEndDate = '20190630'
  ,GeoTypeID = 12980
     ,TotalEmployment = 61.4500 UNION ALL

  SELECT QuarterEndDate = '20190930'
  ,GeoTypeID = 12980
     ,TotalEmployment = 61.5400 UNION ALL

  SELECT QuarterEndDate = '20191231'
  ,GeoTypeID = 12980
     ,TotalEmployment = 61.5900 UNION ALL

  SELECT QuarterEndDate = '20200331'
  ,GeoTypeID = 12980
     ,TotalEmployment = 61.6200 UNION ALL

  SELECT QuarterEndDate = '20200630'
  ,GeoTypeID = 12980
     ,TotalEmployment = 61.6400 UNION ALL

  SELECT QuarterEndDate = '20200930'
  ,GeoTypeID = 12980
     ,TotalEmployment = 61.6700 UNION ALL

  SELECT QuarterEndDate = '20201231'
  ,GeoTypeID = 12980
     ,TotalEmployment = 61.7100 UNION ALL

  SELECT QuarterEndDate = '20210331'
  ,GeoTypeID = 12980
     ,TotalEmployment = 61.7400 UNION ALL

  SELECT QuarterEndDate = '20210630'
  ,GeoTypeID = 12980
     ,TotalEmployment = 61.7900 UNION ALL

  SELECT QuarterEndDate = '20210930'
  ,GeoTypeID = 12980
     ,TotalEmployment = 61.8300 UNION ALL

  SELECT QuarterEndDate = '20211231'
  ,GeoTypeID = 12980
     ,TotalEmployment = 61.8800 UNION ALL

  SELECT QuarterEndDate = '20220331'
  ,GeoTypeID = 12980
     ,TotalEmployment = 61.9200 UNION ALL

  SELECT QuarterEndDate = '20220630'
  ,GeoTypeID = 12980
     ,TotalEmployment = 61.9800 UNION ALL

  SELECT QuarterEndDate = '20220930'
  ,GeoTypeID = 12980
     ,TotalEmployment = 62.0600 UNION ALL

  SELECT QuarterEndDate = '20221231'
  ,GeoTypeID = 12980
     ,TotalEmployment = 62.1300 UNION ALL

  SELECT QuarterEndDate = '20230331'
  ,GeoTypeID = 12980
     ,TotalEmployment = 62.2100 UNION ALL

  SELECT QuarterEndDate = '20230630'
  ,GeoTypeID = 12980
     ,TotalEmployment = 62.2800 UNION ALL

  SELECT QuarterEndDate = '20230930'
  ,GeoTypeID = 12980
     ,TotalEmployment = 62.3300 UNION ALL

  SELECT QuarterEndDate = '20231231'
  ,GeoTypeID = 12980
     ,TotalEmployment = 62.3900 UNION ALL

  SELECT QuarterEndDate = '20240331'
  ,GeoTypeID = 12980
     ,TotalEmployment = 62.4400 UNION ALL

  SELECT QuarterEndDate = '20240630'
  ,GeoTypeID = 12980
     ,TotalEmployment = 62.4900 UNION ALL

  SELECT QuarterEndDate = '20240930'
  ,GeoTypeID = 12980
     ,TotalEmployment = 62.5500 UNION ALL

  SELECT QuarterEndDate = '20241231'
  ,GeoTypeID = 12980
     ,TotalEmployment = 62.6000 UNION ALL

  SELECT QuarterEndDate = '20250331'
  ,GeoTypeID = 12980
     ,TotalEmployment = 62.6600 UNION ALL

  SELECT QuarterEndDate = '20250630'
  ,GeoTypeID = 12980
     ,TotalEmployment = 62.7100 UNION ALL

  SELECT QuarterEndDate = '20250930'
  ,GeoTypeID = 12980
     ,TotalEmployment = 62.7600 UNION ALL

  SELECT QuarterEndDate = '20251231'
  ,GeoTypeID = 12980
     ,TotalEmployment = 62.8000 UNION ALL

  SELECT QuarterEndDate = '20170930'
  ,GeoTypeID = 34620
     ,TotalEmployment = 52.4600 UNION ALL

  SELECT QuarterEndDate = '20171231'
  ,GeoTypeID = 34620
     ,TotalEmployment = 52.7100 UNION ALL

  SELECT QuarterEndDate = '20180331'
  ,GeoTypeID = 34620
     ,TotalEmployment = 52.9200 UNION ALL

  SELECT QuarterEndDate = '20180630'
  ,GeoTypeID = 34620
     ,TotalEmployment = 53.1000 UNION ALL

  SELECT QuarterEndDate = '20180930'
  ,GeoTypeID = 34620
     ,TotalEmployment = 53.2800 UNION ALL

  SELECT QuarterEndDate = '20181231'
  ,GeoTypeID = 34620
     ,TotalEmployment = 53.4400 UNION ALL

  SELECT QuarterEndDate = '20190331'
  ,GeoTypeID = 34620
     ,TotalEmployment = 53.5900 UNION ALL

  SELECT QuarterEndDate = '20190630'
  ,GeoTypeID = 34620
     ,TotalEmployment = 53.8100 UNION ALL

  SELECT QuarterEndDate = '20190930'
  ,GeoTypeID = 34620
     ,TotalEmployment = 53.9300 UNION ALL

  SELECT QuarterEndDate = '20191231'
  ,GeoTypeID = 34620
     ,TotalEmployment = 54.0900 UNION ALL

  SELECT QuarterEndDate = '20200331'
  ,GeoTypeID = 34620
     ,TotalEmployment = 54.3600 UNION ALL

  SELECT QuarterEndDate = '20200630'
  ,GeoTypeID = 34620
     ,TotalEmployment = 54.5100 UNION ALL

  SELECT QuarterEndDate = '20200930'
  ,GeoTypeID = 34620
     ,TotalEmployment = 54.5800 UNION ALL

  SELECT QuarterEndDate = '20201231'
  ,GeoTypeID = 34620
     ,TotalEmployment = 54.6500 UNION ALL

  SELECT QuarterEndDate = '20210331'
  ,GeoTypeID = 34620
     ,TotalEmployment = 54.6800 UNION ALL

  SELECT QuarterEndDate = '20210630'
  ,GeoTypeID = 34620
     ,TotalEmployment = 54.7200 UNION ALL

  SELECT QuarterEndDate = '20210930'
  ,GeoTypeID = 34620
     ,TotalEmployment = 54.7500 UNION ALL

  SELECT QuarterEndDate = '20211231'
  ,GeoTypeID = 34620
     ,TotalEmployment = 54.8000 UNION ALL

  SELECT QuarterEndDate = '20220331'
  ,GeoTypeID = 34620
     ,TotalEmployment = 54.8400 UNION ALL

  SELECT QuarterEndDate = '20220630'
  ,GeoTypeID = 34620
     ,TotalEmployment = 54.8900 UNION ALL

  SELECT QuarterEndDate = '20220930'
  ,GeoTypeID = 34620
     ,TotalEmployment = 54.9400 UNION ALL

  SELECT QuarterEndDate = '20221231'
  ,GeoTypeID = 34620
     ,TotalEmployment = 55.0000 UNION ALL

  SELECT QuarterEndDate = '20230331'
  ,GeoTypeID = 34620
     ,TotalEmployment = 55.0500 UNION ALL

  SELECT QuarterEndDate = '20230630'
  ,GeoTypeID = 34620
     ,TotalEmployment = 55.1000 UNION ALL

  SELECT QuarterEndDate = '20230930'
  ,GeoTypeID = 34620
     ,TotalEmployment = 55.1600 UNION ALL

  SELECT QuarterEndDate = '20231231'
  ,GeoTypeID = 34620
     ,TotalEmployment = 55.2100 UNION ALL

  SELECT QuarterEndDate = '20240331'
  ,GeoTypeID = 34620
     ,TotalEmployment = 55.2600 UNION ALL

  SELECT QuarterEndDate = '20240630'
  ,GeoTypeID = 34620
     ,TotalEmployment = 55.3200 UNION ALL

  SELECT QuarterEndDate = '20240930'
  ,GeoTypeID = 34620
     ,TotalEmployment = 55.3700 UNION ALL

  SELECT QuarterEndDate = '20241231'
  ,GeoTypeID = 34620
     ,TotalEmployment = 55.4200 UNION ALL

  SELECT QuarterEndDate = '20250331'
  ,GeoTypeID = 34620
     ,TotalEmployment = 55.4700 UNION ALL

  SELECT QuarterEndDate = '20250630'
  ,GeoTypeID = 34620
     ,TotalEmployment = 55.5200 UNION ALL

  SELECT QuarterEndDate = '20250930'
  ,GeoTypeID = 34620
     ,TotalEmployment = 55.5700 UNION ALL

  SELECT QuarterEndDate = '20251231'
  ,GeoTypeID = 34620
     ,TotalEmployment = 55.6200 UNION ALL

  SELECT QuarterEndDate = '20170930'
  ,GeoTypeID = 15940
     ,TotalEmployment = 176.9100 UNION ALL

  SELECT QuarterEndDate = '20171231'
  ,GeoTypeID = 15940
     ,TotalEmployment = 177.4600 UNION ALL

  SELECT QuarterEndDate = '20180331'
  ,GeoTypeID = 15940
     ,TotalEmployment = 177.9400 UNION ALL

  SELECT QuarterEndDate = '20180630'
  ,GeoTypeID = 15940
     ,TotalEmployment = 178.3500 UNION ALL

  SELECT QuarterEndDate = '20180930'
  ,GeoTypeID = 15940
     ,TotalEmployment = 178.7800 UNION ALL

  SELECT QuarterEndDate = '20181231'
  ,GeoTypeID = 15940
     ,TotalEmployment = 179.2000 UNION ALL

  SELECT QuarterEndDate = '20190331'
  ,GeoTypeID = 15940
     ,TotalEmployment = 179.5700 UNION ALL

  SELECT QuarterEndDate = '20190630'
  ,GeoTypeID = 15940
     ,TotalEmployment = 179.9600 UNION ALL

  SELECT QuarterEndDate = '20190930'
  ,GeoTypeID = 15940
     ,TotalEmployment = 180.2700 UNION ALL

  SELECT QuarterEndDate = '20191231'
  ,GeoTypeID = 15940
     ,TotalEmployment = 180.4100 UNION ALL

  SELECT QuarterEndDate = '20200331'
  ,GeoTypeID = 15940
     ,TotalEmployment = 180.4800 UNION ALL

  SELECT QuarterEndDate = '20200630'
  ,GeoTypeID = 15940
     ,TotalEmployment = 180.4900 UNION ALL

  SELECT QuarterEndDate = '20200930'
  ,GeoTypeID = 15940
     ,TotalEmployment = 180.5200 UNION ALL

  SELECT QuarterEndDate = '20201231'
  ,GeoTypeID = 15940
     ,TotalEmployment = 180.5000 UNION ALL

  SELECT QuarterEndDate = '20210331'
  ,GeoTypeID = 15940
     ,TotalEmployment = 180.5200 UNION ALL

  SELECT QuarterEndDate = '20210630'
  ,GeoTypeID = 15940
     ,TotalEmployment = 180.5400 UNION ALL

  SELECT QuarterEndDate = '20210930'
  ,GeoTypeID = 15940
     ,TotalEmployment = 180.5700 UNION ALL

  SELECT QuarterEndDate = '20211231'
  ,GeoTypeID = 15940
     ,TotalEmployment = 180.6500 UNION ALL

  SELECT QuarterEndDate = '20220331'
  ,GeoTypeID = 15940
     ,TotalEmployment = 180.7600 UNION ALL

  SELECT QuarterEndDate = '20220630'
  ,GeoTypeID = 15940
     ,TotalEmployment = 180.9000 UNION ALL

  SELECT QuarterEndDate = '20220930'
  ,GeoTypeID = 15940
     ,TotalEmployment = 181.0400 UNION ALL

  SELECT QuarterEndDate = '20221231'
  ,GeoTypeID = 15940
     ,TotalEmployment = 181.1800 UNION ALL

  SELECT QuarterEndDate = '20230331'
  ,GeoTypeID = 15940
     ,TotalEmployment = 181.3300 UNION ALL

  SELECT QuarterEndDate = '20230630'
  ,GeoTypeID = 15940
     ,TotalEmployment = 181.4800 UNION ALL

  SELECT QuarterEndDate = '20230930'
  ,GeoTypeID = 15940
     ,TotalEmployment = 181.6500 UNION ALL

  SELECT QuarterEndDate = '20231231'
  ,GeoTypeID = 15940
     ,TotalEmployment = 181.8000 UNION ALL

  SELECT QuarterEndDate = '20240331'
  ,GeoTypeID = 15940
     ,TotalEmployment = 181.9600 UNION ALL

  SELECT QuarterEndDate = '20240630'
  ,GeoTypeID = 15940
     ,TotalEmployment = 182.1100 UNION ALL

  SELECT QuarterEndDate = '20240930'
  ,GeoTypeID = 15940
     ,TotalEmployment = 182.2800 UNION ALL

  SELECT QuarterEndDate = '20241231'
  ,GeoTypeID = 15940
     ,TotalEmployment = 182.4400 UNION ALL

  SELECT QuarterEndDate = '20250331'
  ,GeoTypeID = 15940
     ,TotalEmployment = 182.6000 UNION ALL

  SELECT QuarterEndDate = '20250630'
  ,GeoTypeID = 15940
     ,TotalEmployment = 182.7600 UNION ALL

  SELECT QuarterEndDate = '20250930'
  ,GeoTypeID = 15940
     ,TotalEmployment = 182.9300 UNION ALL

  SELECT QuarterEndDate = '20251231'
  ,GeoTypeID = 15940
     ,TotalEmployment = 183.1000 UNION ALL

  SELECT QuarterEndDate = '20170930'
  ,GeoTypeID = 49660
     ,TotalEmployment = 228.7800 UNION ALL

  SELECT QuarterEndDate = '20171231'
  ,GeoTypeID = 49660
     ,TotalEmployment = 229.4100 UNION ALL

  SELECT QuarterEndDate = '20180331'
  ,GeoTypeID = 49660
     ,TotalEmployment = 229.9500 UNION ALL

  SELECT QuarterEndDate = '20180630'
  ,GeoTypeID = 49660
     ,TotalEmployment = 230.4100 UNION ALL

  SELECT QuarterEndDate = '20180930'
  ,GeoTypeID = 49660
     ,TotalEmployment = 230.8700 UNION ALL

  SELECT QuarterEndDate = '20181231'
  ,GeoTypeID = 49660
     ,TotalEmployment = 231.3300 UNION ALL

  SELECT QuarterEndDate = '20190331'
  ,GeoTypeID = 49660
     ,TotalEmployment = 231.7400 UNION ALL

  SELECT QuarterEndDate = '20190630'
  ,GeoTypeID = 49660
     ,TotalEmployment = 232.1600 UNION ALL

  SELECT QuarterEndDate = '20190930'
  ,GeoTypeID = 49660
     ,TotalEmployment = 232.4800 UNION ALL

  SELECT QuarterEndDate = '20191231'
  ,GeoTypeID = 49660
     ,TotalEmployment = 232.5900 UNION ALL

  SELECT QuarterEndDate = '20200331'
  ,GeoTypeID = 49660
     ,TotalEmployment = 232.6100 UNION ALL

  SELECT QuarterEndDate = '20200630'
  ,GeoTypeID = 49660
     ,TotalEmployment = 232.5500 UNION ALL

  SELECT QuarterEndDate = '20200930'
  ,GeoTypeID = 49660
     ,TotalEmployment = 232.5100 UNION ALL

  SELECT QuarterEndDate = '20201231'
  ,GeoTypeID = 49660
     ,TotalEmployment = 232.4200 UNION ALL

  SELECT QuarterEndDate = '20210331'
  ,GeoTypeID = 49660
     ,TotalEmployment = 232.3700 UNION ALL

  SELECT QuarterEndDate = '20210630'
  ,GeoTypeID = 49660
     ,TotalEmployment = 232.3200 UNION ALL

  SELECT QuarterEndDate = '20210930'
  ,GeoTypeID = 49660
     ,TotalEmployment = 232.2900 UNION ALL

  SELECT QuarterEndDate = '20211231'
  ,GeoTypeID = 49660
     ,TotalEmployment = 232.3200 UNION ALL

  SELECT QuarterEndDate = '20220331'
  ,GeoTypeID = 49660
     ,TotalEmployment = 232.3700 UNION ALL

  SELECT QuarterEndDate = '20220630'
  ,GeoTypeID = 49660
     ,TotalEmployment = 232.4600 UNION ALL

  SELECT QuarterEndDate = '20220930'
  ,GeoTypeID = 49660
     ,TotalEmployment = 232.5600 UNION ALL

  SELECT QuarterEndDate = '20221231'
  ,GeoTypeID = 49660
     ,TotalEmployment = 232.6500 UNION ALL

  SELECT QuarterEndDate = '20230331'
  ,GeoTypeID = 49660
     ,TotalEmployment = 232.7500 UNION ALL

  SELECT QuarterEndDate = '20230630'
  ,GeoTypeID = 49660
     ,TotalEmployment = 232.8400 UNION ALL

  SELECT QuarterEndDate = '20230930'
  ,GeoTypeID = 49660
     ,TotalEmployment = 232.9600 UNION ALL

  SELECT QuarterEndDate = '20231231'
  ,GeoTypeID = 49660
     ,TotalEmployment = 233.0500 UNION ALL

  SELECT QuarterEndDate = '20240331'
  ,GeoTypeID = 49660
     ,TotalEmployment = 233.1500 UNION ALL

  SELECT QuarterEndDate = '20240630'
  ,GeoTypeID = 49660
     ,TotalEmployment = 233.2400 UNION ALL

  SELECT QuarterEndDate = '20240930'
  ,GeoTypeID = 49660
     ,TotalEmployment = 233.3400 UNION ALL

  SELECT QuarterEndDate = '20241231'
  ,GeoTypeID = 49660
     ,TotalEmployment = 233.4300 UNION ALL

  SELECT QuarterEndDate = '20250331'
  ,GeoTypeID = 49660
     ,TotalEmployment = 233.5200 UNION ALL

  SELECT QuarterEndDate = '20250630'
  ,GeoTypeID = 49660
     ,TotalEmployment = 233.6100 UNION ALL

  SELECT QuarterEndDate = '20250930'
  ,GeoTypeID = 49660
     ,TotalEmployment = 233.7100 UNION ALL

  SELECT QuarterEndDate = '20251231'
  ,GeoTypeID = 49660
     ,TotalEmployment = 233.8100 UNION ALL

  SELECT QuarterEndDate = '20170930'
  ,GeoTypeID = 41780
     ,TotalEmployment = 41.4900 UNION ALL

  SELECT QuarterEndDate = '20171231'
  ,GeoTypeID = 41780
     ,TotalEmployment = 41.7300 UNION ALL

  SELECT QuarterEndDate = '20180331'
  ,GeoTypeID = 41780
     ,TotalEmployment = 41.9100 UNION ALL

  SELECT QuarterEndDate = '20180630'
  ,GeoTypeID = 41780
     ,TotalEmployment = 42.0400 UNION ALL

  SELECT QuarterEndDate = '20180930'
  ,GeoTypeID = 41780
     ,TotalEmployment = 42.1400 UNION ALL

  SELECT QuarterEndDate = '20181231'
  ,GeoTypeID = 41780
     ,TotalEmployment = 42.2400 UNION ALL

  SELECT QuarterEndDate = '20190331'
  ,GeoTypeID = 41780
     ,TotalEmployment = 42.3400 UNION ALL

  SELECT QuarterEndDate = '20190630'
  ,GeoTypeID = 41780
     ,TotalEmployment = 42.4400 UNION ALL

  SELECT QuarterEndDate = '20190930'
  ,GeoTypeID = 41780
     ,TotalEmployment = 42.5600 UNION ALL

  SELECT QuarterEndDate = '20191231'
  ,GeoTypeID = 41780
     ,TotalEmployment = 42.6700 UNION ALL

  SELECT QuarterEndDate = '20200331'
  ,GeoTypeID = 41780
     ,TotalEmployment = 42.7700 UNION ALL

  SELECT QuarterEndDate = '20200630'
  ,GeoTypeID = 41780
     ,TotalEmployment = 42.8600 UNION ALL

  SELECT QuarterEndDate = '20200930'
  ,GeoTypeID = 41780
     ,TotalEmployment = 42.9200 UNION ALL

  SELECT QuarterEndDate = '20201231'
  ,GeoTypeID = 41780
     ,TotalEmployment = 42.9800 UNION ALL

  SELECT QuarterEndDate = '20210331'
  ,GeoTypeID = 41780
     ,TotalEmployment = 43.0300 UNION ALL

  SELECT QuarterEndDate = '20210630'
  ,GeoTypeID = 41780
     ,TotalEmployment = 43.0600 UNION ALL

  SELECT QuarterEndDate = '20210930'
  ,GeoTypeID = 41780
     ,TotalEmployment = 43.0900 UNION ALL

  SELECT QuarterEndDate = '20211231'
  ,GeoTypeID = 41780
     ,TotalEmployment = 43.1300 UNION ALL

  SELECT QuarterEndDate = '20220331'
  ,GeoTypeID = 41780
     ,TotalEmployment = 43.1800 UNION ALL

  SELECT QuarterEndDate = '20220630'
  ,GeoTypeID = 41780
     ,TotalEmployment = 43.2000 UNION ALL

  SELECT QuarterEndDate = '20220930'
  ,GeoTypeID = 41780
     ,TotalEmployment = 43.2300 UNION ALL

  SELECT QuarterEndDate = '20221231'
  ,GeoTypeID = 41780
     ,TotalEmployment = 43.2800 UNION ALL

  SELECT QuarterEndDate = '20230331'
  ,GeoTypeID = 41780
     ,TotalEmployment = 43.3300 UNION ALL

  SELECT QuarterEndDate = '20230630'
  ,GeoTypeID = 41780
     ,TotalEmployment = 43.3800 UNION ALL

  SELECT QuarterEndDate = '20230930'
  ,GeoTypeID = 41780
     ,TotalEmployment = 43.4100 UNION ALL

  SELECT QuarterEndDate = '20231231'
  ,GeoTypeID = 41780
     ,TotalEmployment = 43.4600 UNION ALL

  SELECT QuarterEndDate = '20240331'
  ,GeoTypeID = 41780
     ,TotalEmployment = 43.5200 UNION ALL

  SELECT QuarterEndDate = '20240630'
  ,GeoTypeID = 41780
     ,TotalEmployment = 43.5600 UNION ALL

  SELECT QuarterEndDate = '20240930'
  ,GeoTypeID = 41780
     ,TotalEmployment = 43.5900 UNION ALL

  SELECT QuarterEndDate = '20241231'
  ,GeoTypeID = 41780
     ,TotalEmployment = 43.6400 UNION ALL

  SELECT QuarterEndDate = '20250331'
  ,GeoTypeID = 41780
     ,TotalEmployment = 43.6800 UNION ALL

  SELECT QuarterEndDate = '20250630'
  ,GeoTypeID = 41780
     ,TotalEmployment = 43.7000 UNION ALL

  SELECT QuarterEndDate = '20250930'
  ,GeoTypeID = 41780
     ,TotalEmployment = 43.7300 UNION ALL

  SELECT QuarterEndDate = '20251231'
  ,GeoTypeID = 41780
     ,TotalEmployment = 43.7500 UNION ALL

  SELECT QuarterEndDate = '20170930'
  ,GeoTypeID = 21780
     ,TotalEmployment = 158.8500 UNION ALL

  SELECT QuarterEndDate = '20171231'
  ,GeoTypeID = 21780
     ,TotalEmployment = 159.5500 UNION ALL

  SELECT QuarterEndDate = '20180331'
  ,GeoTypeID = 21780
     ,TotalEmployment = 160.2100 UNION ALL

  SELECT QuarterEndDate = '20180630'
  ,GeoTypeID = 21780
     ,TotalEmployment = 160.7600 UNION ALL

  SELECT QuarterEndDate = '20180930'
  ,GeoTypeID = 21780
     ,TotalEmployment = 161.3300 UNION ALL

  SELECT QuarterEndDate = '20181231'
  ,GeoTypeID = 21780
     ,TotalEmployment = 161.8400 UNION ALL

  SELECT QuarterEndDate = '20190331'
  ,GeoTypeID = 21780
     ,TotalEmployment = 162.2800 UNION ALL

  SELECT QuarterEndDate = '20190630'
  ,GeoTypeID = 21780
     ,TotalEmployment = 162.7200 UNION ALL

  SELECT QuarterEndDate = '20190930'
  ,GeoTypeID = 21780
     ,TotalEmployment = 163.0800 UNION ALL

  SELECT QuarterEndDate = '20191231'
  ,GeoTypeID = 21780
     ,TotalEmployment = 163.3000 UNION ALL

  SELECT QuarterEndDate = '20200331'
  ,GeoTypeID = 21780
     ,TotalEmployment = 163.4700 UNION ALL

  SELECT QuarterEndDate = '20200630'
  ,GeoTypeID = 21780
     ,TotalEmployment = 163.5700 UNION ALL

  SELECT QuarterEndDate = '20200930'
  ,GeoTypeID = 21780
     ,TotalEmployment = 163.6700 UNION ALL

  SELECT QuarterEndDate = '20201231'
  ,GeoTypeID = 21780
     ,TotalEmployment = 163.7600 UNION ALL

  SELECT QuarterEndDate = '20210331'
  ,GeoTypeID = 21780
     ,TotalEmployment = 163.8500 UNION ALL

  SELECT QuarterEndDate = '20210630'
  ,GeoTypeID = 21780
     ,TotalEmployment = 163.9400 UNION ALL

  SELECT QuarterEndDate = '20210930'
  ,GeoTypeID = 21780
     ,TotalEmployment = 164.0400 UNION ALL

  SELECT QuarterEndDate = '20211231'
  ,GeoTypeID = 21780
     ,TotalEmployment = 164.1700 UNION ALL

  SELECT QuarterEndDate = '20220331'
  ,GeoTypeID = 21780
     ,TotalEmployment = 164.3100 UNION ALL

  SELECT QuarterEndDate = '20220630'
  ,GeoTypeID = 21780
     ,TotalEmployment = 164.4600 UNION ALL

  SELECT QuarterEndDate = '20220930'
  ,GeoTypeID = 21780
     ,TotalEmployment = 164.6300 UNION ALL

  SELECT QuarterEndDate = '20221231'
  ,GeoTypeID = 21780
     ,TotalEmployment = 164.8200 UNION ALL

  SELECT QuarterEndDate = '20230331'
  ,GeoTypeID = 21780
     ,TotalEmployment = 165.0100 UNION ALL

  SELECT QuarterEndDate = '20230630'
  ,GeoTypeID = 21780
     ,TotalEmployment = 165.2000 UNION ALL

  SELECT QuarterEndDate = '20230930'
  ,GeoTypeID = 21780
     ,TotalEmployment = 165.3900 UNION ALL

  SELECT QuarterEndDate = '20231231'
  ,GeoTypeID = 21780
     ,TotalEmployment = 165.5800 UNION ALL

  SELECT QuarterEndDate = '20240331'
  ,GeoTypeID = 21780
     ,TotalEmployment = 165.7700 UNION ALL

  SELECT QuarterEndDate = '20240630'
  ,GeoTypeID = 21780
     ,TotalEmployment = 165.9600 UNION ALL

  SELECT QuarterEndDate = '20240930'
  ,GeoTypeID = 21780
     ,TotalEmployment = 166.1600 UNION ALL

  SELECT QuarterEndDate = '20241231'
  ,GeoTypeID = 21780
     ,TotalEmployment = 166.3500 UNION ALL

  SELECT QuarterEndDate = '20250331'
  ,GeoTypeID = 21780
     ,TotalEmployment = 166.5400 UNION ALL

  SELECT QuarterEndDate = '20250630'
  ,GeoTypeID = 21780
     ,TotalEmployment = 166.7400 UNION ALL

  SELECT QuarterEndDate = '20250930'
  ,GeoTypeID = 21780
     ,TotalEmployment = 166.9400 UNION ALL

  SELECT QuarterEndDate = '20251231'
  ,GeoTypeID = 21780
     ,TotalEmployment = 167.1400 UNION ALL

  SELECT QuarterEndDate = '20170930'
  ,GeoTypeID = 31140
     ,TotalEmployment = 674.8300 UNION ALL

  SELECT QuarterEndDate = '20171231'
  ,GeoTypeID = 31140
     ,TotalEmployment = 678.0300 UNION ALL

  SELECT QuarterEndDate = '20180331'
  ,GeoTypeID = 31140
     ,TotalEmployment = 680.6900 UNION ALL

  SELECT QuarterEndDate = '20180630'
  ,GeoTypeID = 31140
     ,TotalEmployment = 683.4700 UNION ALL

  SELECT QuarterEndDate = '20180930'
  ,GeoTypeID = 31140
     ,TotalEmployment = 686.2500 UNION ALL

  SELECT QuarterEndDate = '20181231'
  ,GeoTypeID = 31140
     ,TotalEmployment = 688.8100 UNION ALL

  SELECT QuarterEndDate = '20190331'
  ,GeoTypeID = 31140
     ,TotalEmployment = 691.2800 UNION ALL

  SELECT QuarterEndDate = '20190630'
  ,GeoTypeID = 31140
     ,TotalEmployment = 693.8800 UNION ALL

  SELECT QuarterEndDate = '20190930'
  ,GeoTypeID = 31140
     ,TotalEmployment = 695.9300 UNION ALL

  SELECT QuarterEndDate = '20191231'
  ,GeoTypeID = 31140
     ,TotalEmployment = 697.4200 UNION ALL

  SELECT QuarterEndDate = '20200331'
  ,GeoTypeID = 31140
     ,TotalEmployment = 698.3500 UNION ALL

  SELECT QuarterEndDate = '20200630'
  ,GeoTypeID = 31140
     ,TotalEmployment = 698.6700 UNION ALL

  SELECT QuarterEndDate = '20200930'
  ,GeoTypeID = 31140
     ,TotalEmployment = 699.1500 UNION ALL

  SELECT QuarterEndDate = '20201231'
  ,GeoTypeID = 31140
     ,TotalEmployment = 699.5600 UNION ALL

  SELECT QuarterEndDate = '20210331'
  ,GeoTypeID = 31140
     ,TotalEmployment = 699.9900 UNION ALL

  SELECT QuarterEndDate = '20210630'
  ,GeoTypeID = 31140
     ,TotalEmployment = 700.6200 UNION ALL

  SELECT QuarterEndDate = '20210930'
  ,GeoTypeID = 31140
     ,TotalEmployment = 701.2300 UNION ALL

  SELECT QuarterEndDate = '20211231'
  ,GeoTypeID = 31140
     ,TotalEmployment = 702.0400 UNION ALL

  SELECT QuarterEndDate = '20220331'
  ,GeoTypeID = 31140
     ,TotalEmployment = 702.9200 UNION ALL

  SELECT QuarterEndDate = '20220630'
  ,GeoTypeID = 31140
     ,TotalEmployment = 703.8900 UNION ALL

  SELECT QuarterEndDate = '20220930'
  ,GeoTypeID = 31140
     ,TotalEmployment = 705.0800 UNION ALL

  SELECT QuarterEndDate = '20221231'
  ,GeoTypeID = 31140
     ,TotalEmployment = 706.2700 UNION ALL

  SELECT QuarterEndDate = '20230331'
  ,GeoTypeID = 31140
     ,TotalEmployment = 707.5800 UNION ALL

  SELECT QuarterEndDate = '20230630'
  ,GeoTypeID = 31140
     ,TotalEmployment = 708.7900 UNION ALL

  SELECT QuarterEndDate = '20230930'
  ,GeoTypeID = 31140
     ,TotalEmployment = 709.8000 UNION ALL

  SELECT QuarterEndDate = '20231231'
  ,GeoTypeID = 31140
     ,TotalEmployment = 710.8700 UNION ALL

  SELECT QuarterEndDate = '20240331'
  ,GeoTypeID = 31140
     ,TotalEmployment = 711.8600 UNION ALL

  SELECT QuarterEndDate = '20240630'
  ,GeoTypeID = 31140
     ,TotalEmployment = 712.8900 UNION ALL

  SELECT QuarterEndDate = '20240930'
  ,GeoTypeID = 31140
     ,TotalEmployment = 713.9300 UNION ALL

  SELECT QuarterEndDate = '20241231'
  ,GeoTypeID = 31140
     ,TotalEmployment = 715.0100 UNION ALL

  SELECT QuarterEndDate = '20250331'
  ,GeoTypeID = 31140
     ,TotalEmployment = 716.0800 UNION ALL

  SELECT QuarterEndDate = '20250630'
  ,GeoTypeID = 31140
     ,TotalEmployment = 717.1800 UNION ALL

  SELECT QuarterEndDate = '20250930'
  ,GeoTypeID = 31140
     ,TotalEmployment = 718.2900 UNION ALL

  SELECT QuarterEndDate = '20251231'
  ,GeoTypeID = 31140
     ,TotalEmployment = 719.4300 UNION ALL

  SELECT QuarterEndDate = '20170930'
  ,GeoTypeID = 29620
     ,TotalEmployment = 232.8000 UNION ALL

  SELECT QuarterEndDate = '20171231'
  ,GeoTypeID = 29620
     ,TotalEmployment = 233.5800 UNION ALL

  SELECT QuarterEndDate = '20180331'
  ,GeoTypeID = 29620
     ,TotalEmployment = 234.4500 UNION ALL

  SELECT QuarterEndDate = '20180630'
  ,GeoTypeID = 29620
     ,TotalEmployment = 235.1800 UNION ALL

  SELECT QuarterEndDate = '20180930'
  ,GeoTypeID = 29620
     ,TotalEmployment = 235.8400 UNION ALL

  SELECT QuarterEndDate = '20181231'
  ,GeoTypeID = 29620
     ,TotalEmployment = 236.5200 UNION ALL

  SELECT QuarterEndDate = '20190331'
  ,GeoTypeID = 29620
     ,TotalEmployment = 237.1400 UNION ALL

  SELECT QuarterEndDate = '20190630'
  ,GeoTypeID = 29620
     ,TotalEmployment = 237.7600 UNION ALL

  SELECT QuarterEndDate = '20190930'
  ,GeoTypeID = 29620
     ,TotalEmployment = 238.2600 UNION ALL

  SELECT QuarterEndDate = '20191231'
  ,GeoTypeID = 29620
     ,TotalEmployment = 238.5600 UNION ALL

  SELECT QuarterEndDate = '20200331'
  ,GeoTypeID = 29620
     ,TotalEmployment = 238.8000 UNION ALL

  SELECT QuarterEndDate = '20200630'
  ,GeoTypeID = 29620
     ,TotalEmployment = 238.9800 UNION ALL

  SELECT QuarterEndDate = '20200930'
  ,GeoTypeID = 29620
     ,TotalEmployment = 239.1700 UNION ALL

  SELECT QuarterEndDate = '20201231'
  ,GeoTypeID = 29620
     ,TotalEmployment = 239.3400 UNION ALL

  SELECT QuarterEndDate = '20210331'
  ,GeoTypeID = 29620
     ,TotalEmployment = 239.5100 UNION ALL

  SELECT QuarterEndDate = '20210630'
  ,GeoTypeID = 29620
     ,TotalEmployment = 239.7200 UNION ALL

  SELECT QuarterEndDate = '20210930'
  ,GeoTypeID = 29620
     ,TotalEmployment = 239.9400 UNION ALL

  SELECT QuarterEndDate = '20211231'
  ,GeoTypeID = 29620
     ,TotalEmployment = 240.2300 UNION ALL

  SELECT QuarterEndDate = '20220331'
  ,GeoTypeID = 29620
     ,TotalEmployment = 240.5300 UNION ALL

  SELECT QuarterEndDate = '20220630'
  ,GeoTypeID = 29620
     ,TotalEmployment = 240.8700 UNION ALL

  SELECT QuarterEndDate = '20220930'
  ,GeoTypeID = 29620
     ,TotalEmployment = 241.2100 UNION ALL

  SELECT QuarterEndDate = '20221231'
  ,GeoTypeID = 29620
     ,TotalEmployment = 241.5500 UNION ALL

  SELECT QuarterEndDate = '20230331'
  ,GeoTypeID = 29620
     ,TotalEmployment = 241.8900 UNION ALL

  SELECT QuarterEndDate = '20230630'
  ,GeoTypeID = 29620
     ,TotalEmployment = 242.2400 UNION ALL

  SELECT QuarterEndDate = '20230930'
  ,GeoTypeID = 29620
     ,TotalEmployment = 242.5900 UNION ALL

  SELECT QuarterEndDate = '20231231'
  ,GeoTypeID = 29620
     ,TotalEmployment = 242.9400 UNION ALL

  SELECT QuarterEndDate = '20240331'
  ,GeoTypeID = 29620
     ,TotalEmployment = 243.2700 UNION ALL

  SELECT QuarterEndDate = '20240630'
  ,GeoTypeID = 29620
     ,TotalEmployment = 243.6000 UNION ALL

  SELECT QuarterEndDate = '20240930'
  ,GeoTypeID = 29620
     ,TotalEmployment = 243.9400 UNION ALL

  SELECT QuarterEndDate = '20241231'
  ,GeoTypeID = 29620
     ,TotalEmployment = 244.2900 UNION ALL

  SELECT QuarterEndDate = '20250331'
  ,GeoTypeID = 29620
     ,TotalEmployment = 244.6200 UNION ALL

  SELECT QuarterEndDate = '20250630'
  ,GeoTypeID = 29620
     ,TotalEmployment = 244.9600 UNION ALL

  SELECT QuarterEndDate = '20250930'
  ,GeoTypeID = 29620
     ,TotalEmployment = 245.3000 UNION ALL

  SELECT QuarterEndDate = '20251231'
  ,GeoTypeID = 29620
     ,TotalEmployment = 245.6400 UNION ALL

  SELECT QuarterEndDate = '20170930'
  ,GeoTypeID = 28020
     ,TotalEmployment = 149.7900 UNION ALL

  SELECT QuarterEndDate = '20171231'
  ,GeoTypeID = 28020
     ,TotalEmployment = 150.4600 UNION ALL

  SELECT QuarterEndDate = '20180331'
  ,GeoTypeID = 28020
     ,TotalEmployment = 151.1500 UNION ALL

  SELECT QuarterEndDate = '20180630'
  ,GeoTypeID = 28020
     ,TotalEmployment = 151.7600 UNION ALL

  SELECT QuarterEndDate = '20180930'
  ,GeoTypeID = 28020
     ,TotalEmployment = 152.3300 UNION ALL

  SELECT QuarterEndDate = '20181231'
  ,GeoTypeID = 28020
     ,TotalEmployment = 152.8800 UNION ALL

  SELECT QuarterEndDate = '20190331'
  ,GeoTypeID = 28020
     ,TotalEmployment = 153.4000 UNION ALL

  SELECT QuarterEndDate = '20190630'
  ,GeoTypeID = 28020
     ,TotalEmployment = 153.9200 UNION ALL

  SELECT QuarterEndDate = '20190930'
  ,GeoTypeID = 28020
     ,TotalEmployment = 154.3500 UNION ALL

  SELECT QuarterEndDate = '20191231'
  ,GeoTypeID = 28020
     ,TotalEmployment = 154.6300 UNION ALL

  SELECT QuarterEndDate = '20200331'
  ,GeoTypeID = 28020
     ,TotalEmployment = 154.8500 UNION ALL

  SELECT QuarterEndDate = '20200630'
  ,GeoTypeID = 28020
     ,TotalEmployment = 155.0000 UNION ALL

  SELECT QuarterEndDate = '20200930'
  ,GeoTypeID = 28020
     ,TotalEmployment = 155.1500 UNION ALL

  SELECT QuarterEndDate = '20201231'
  ,GeoTypeID = 28020
     ,TotalEmployment = 155.2900 UNION ALL

  SELECT QuarterEndDate = '20210331'
  ,GeoTypeID = 28020
     ,TotalEmployment = 155.4400 UNION ALL

  SELECT QuarterEndDate = '20210630'
  ,GeoTypeID = 28020
     ,TotalEmployment = 155.6000 UNION ALL

  SELECT QuarterEndDate = '20210930'
  ,GeoTypeID = 28020
     ,TotalEmployment = 155.7700 UNION ALL

  SELECT QuarterEndDate = '20211231'
  ,GeoTypeID = 28020
     ,TotalEmployment = 155.9800 UNION ALL

  SELECT QuarterEndDate = '20220331'
  ,GeoTypeID = 28020
     ,TotalEmployment = 156.2100 UNION ALL

  SELECT QuarterEndDate = '20220630'
  ,GeoTypeID = 28020
     ,TotalEmployment = 156.4500 UNION ALL

  SELECT QuarterEndDate = '20220930'
  ,GeoTypeID = 28020
     ,TotalEmployment = 156.7000 UNION ALL

  SELECT QuarterEndDate = '20221231'
  ,GeoTypeID = 28020
     ,TotalEmployment = 156.9700 UNION ALL

  SELECT QuarterEndDate = '20230331'
  ,GeoTypeID = 28020
     ,TotalEmployment = 157.2500 UNION ALL

  SELECT QuarterEndDate = '20230630'
  ,GeoTypeID = 28020
     ,TotalEmployment = 157.5200 UNION ALL

  SELECT QuarterEndDate = '20230930'
  ,GeoTypeID = 28020
     ,TotalEmployment = 157.7900 UNION ALL

  SELECT QuarterEndDate = '20231231'
  ,GeoTypeID = 28020
     ,TotalEmployment = 158.0600 UNION ALL

  SELECT QuarterEndDate = '20240331'
  ,GeoTypeID = 28020
     ,TotalEmployment = 158.3300 UNION ALL

  SELECT QuarterEndDate = '20240630'
  ,GeoTypeID = 28020
     ,TotalEmployment = 158.6000 UNION ALL

  SELECT QuarterEndDate = '20240930'
  ,GeoTypeID = 28020
     ,TotalEmployment = 158.8700 UNION ALL

  SELECT QuarterEndDate = '20241231'
  ,GeoTypeID = 28020
     ,TotalEmployment = 159.1300 UNION ALL

  SELECT QuarterEndDate = '20250331'
  ,GeoTypeID = 28020
     ,TotalEmployment = 159.4000 UNION ALL

  SELECT QuarterEndDate = '20250630'
  ,GeoTypeID = 28020
     ,TotalEmployment = 159.6700 UNION ALL

  SELECT QuarterEndDate = '20250930'
  ,GeoTypeID = 28020
     ,TotalEmployment = 159.9400 UNION ALL

  SELECT QuarterEndDate = '20251231'
  ,GeoTypeID = 28020
     ,TotalEmployment = 160.2200 UNION ALL

  SELECT QuarterEndDate = '20170930'
  ,GeoTypeID = 40420
     ,TotalEmployment = 159.1600 UNION ALL

  SELECT QuarterEndDate = '20171231'
  ,GeoTypeID = 40420
     ,TotalEmployment = 159.9300 UNION ALL

  SELECT QuarterEndDate = '20180331'
  ,GeoTypeID = 40420
     ,TotalEmployment = 160.6400 UNION ALL

  SELECT QuarterEndDate = '20180630'
  ,GeoTypeID = 40420
     ,TotalEmployment = 161.2600 UNION ALL

  SELECT QuarterEndDate = '20180930'
  ,GeoTypeID = 40420
     ,TotalEmployment = 161.8200 UNION ALL

  SELECT QuarterEndDate = '20181231'
  ,GeoTypeID = 40420
     ,TotalEmployment = 162.3500 UNION ALL

  SELECT QuarterEndDate = '20190331'
  ,GeoTypeID = 40420
     ,TotalEmployment = 162.8400 UNION ALL

  SELECT QuarterEndDate = '20190630'
  ,GeoTypeID = 40420
     ,TotalEmployment = 163.3100 UNION ALL

  SELECT QuarterEndDate = '20190930'
  ,GeoTypeID = 40420
     ,TotalEmployment = 163.7000 UNION ALL

  SELECT QuarterEndDate = '20191231'
  ,GeoTypeID = 40420
     ,TotalEmployment = 163.9600 UNION ALL

  SELECT QuarterEndDate = '20200331'
  ,GeoTypeID = 40420
     ,TotalEmployment = 164.1700 UNION ALL

  SELECT QuarterEndDate = '20200630'
  ,GeoTypeID = 40420
     ,TotalEmployment = 164.3100 UNION ALL

  SELECT QuarterEndDate = '20200930'
  ,GeoTypeID = 40420
     ,TotalEmployment = 164.4500 UNION ALL

  SELECT QuarterEndDate = '20201231'
  ,GeoTypeID = 40420
     ,TotalEmployment = 164.5800 UNION ALL

  SELECT QuarterEndDate = '20210331'
  ,GeoTypeID = 40420
     ,TotalEmployment = 164.7200 UNION ALL

  SELECT QuarterEndDate = '20210630'
  ,GeoTypeID = 40420
     ,TotalEmployment = 164.8700 UNION ALL

  SELECT QuarterEndDate = '20210930'
  ,GeoTypeID = 40420
     ,TotalEmployment = 165.0100 UNION ALL

  SELECT QuarterEndDate = '20211231'
  ,GeoTypeID = 40420
     ,TotalEmployment = 165.1900 UNION ALL

  SELECT QuarterEndDate = '20220331'
  ,GeoTypeID = 40420
     ,TotalEmployment = 165.3800 UNION ALL

  SELECT QuarterEndDate = '20220630'
  ,GeoTypeID = 40420
     ,TotalEmployment = 165.5900 UNION ALL

  SELECT QuarterEndDate = '20220930'
  ,GeoTypeID = 40420
     ,TotalEmployment = 165.7900 UNION ALL

  SELECT QuarterEndDate = '20221231'
  ,GeoTypeID = 40420
     ,TotalEmployment = 166.0200 UNION ALL

  SELECT QuarterEndDate = '20230331'
  ,GeoTypeID = 40420
     ,TotalEmployment = 166.2600 UNION ALL

  SELECT QuarterEndDate = '20230630'
  ,GeoTypeID = 40420
     ,TotalEmployment = 166.4900 UNION ALL

  SELECT QuarterEndDate = '20230930'
  ,GeoTypeID = 40420
     ,TotalEmployment = 166.7200 UNION ALL

  SELECT QuarterEndDate = '20231231'
  ,GeoTypeID = 40420
     ,TotalEmployment = 166.9600 UNION ALL

  SELECT QuarterEndDate = '20240331'
  ,GeoTypeID = 40420
     ,TotalEmployment = 167.2000 UNION ALL

  SELECT QuarterEndDate = '20240630'
  ,GeoTypeID = 40420
     ,TotalEmployment = 167.4300 UNION ALL

  SELECT QuarterEndDate = '20240930'
  ,GeoTypeID = 40420
     ,TotalEmployment = 167.6600 UNION ALL

  SELECT QuarterEndDate = '20241231'
  ,GeoTypeID = 40420
     ,TotalEmployment = 167.9000 UNION ALL

  SELECT QuarterEndDate = '20250331'
  ,GeoTypeID = 40420
     ,TotalEmployment = 168.1400 UNION ALL

  SELECT QuarterEndDate = '20250630'
  ,GeoTypeID = 40420
     ,TotalEmployment = 168.3800 UNION ALL

  SELECT QuarterEndDate = '20250930'
  ,GeoTypeID = 40420
     ,TotalEmployment = 168.6200 UNION ALL

  SELECT QuarterEndDate = '20251231'
  ,GeoTypeID = 40420
     ,TotalEmployment = 168.8600 UNION ALL

  SELECT QuarterEndDate = '20170930'
  ,GeoTypeID = 20260
     ,TotalEmployment = 134.5800 UNION ALL

  SELECT QuarterEndDate = '20171231'
  ,GeoTypeID = 20260
     ,TotalEmployment = 134.8200 UNION ALL

  SELECT QuarterEndDate = '20180331'
  ,GeoTypeID = 20260
     ,TotalEmployment = 135.1200 UNION ALL

  SELECT QuarterEndDate = '20180630'
  ,GeoTypeID = 20260
     ,TotalEmployment = 135.4200 UNION ALL

  SELECT QuarterEndDate = '20180930'
  ,GeoTypeID = 20260
     ,TotalEmployment = 135.7500 UNION ALL

  SELECT QuarterEndDate = '20181231'
  ,GeoTypeID = 20260
     ,TotalEmployment = 136.0000 UNION ALL

  SELECT QuarterEndDate = '20190331'
  ,GeoTypeID = 20260
     ,TotalEmployment = 136.2500 UNION ALL

  SELECT QuarterEndDate = '20190630'
  ,GeoTypeID = 20260
     ,TotalEmployment = 136.4600 UNION ALL

  SELECT QuarterEndDate = '20190930'
  ,GeoTypeID = 20260
     ,TotalEmployment = 136.6400 UNION ALL

  SELECT QuarterEndDate = '20191231'
  ,GeoTypeID = 20260
     ,TotalEmployment = 136.7800 UNION ALL

  SELECT QuarterEndDate = '20200331'
  ,GeoTypeID = 20260
     ,TotalEmployment = 136.8600 UNION ALL

  SELECT QuarterEndDate = '20200630'
  ,GeoTypeID = 20260
     ,TotalEmployment = 136.8400 UNION ALL

  SELECT QuarterEndDate = '20200930'
  ,GeoTypeID = 20260
     ,TotalEmployment = 136.7500 UNION ALL

  SELECT QuarterEndDate = '20201231'
  ,GeoTypeID = 20260
     ,TotalEmployment = 136.6600 UNION ALL

  SELECT QuarterEndDate = '20210331'
  ,GeoTypeID = 20260
     ,TotalEmployment = 136.5400 UNION ALL

  SELECT QuarterEndDate = '20210630'
  ,GeoTypeID = 20260
     ,TotalEmployment = 136.4500 UNION ALL

  SELECT QuarterEndDate = '20210930'
  ,GeoTypeID = 20260
     ,TotalEmployment = 136.3700 UNION ALL

  SELECT QuarterEndDate = '20211231'
  ,GeoTypeID = 20260
     ,TotalEmployment = 136.3100 UNION ALL

  SELECT QuarterEndDate = '20220331'
  ,GeoTypeID = 20260
     ,TotalEmployment = 136.2800 UNION ALL

  SELECT QuarterEndDate = '20220630'
  ,GeoTypeID = 20260
     ,TotalEmployment = 136.2700 UNION ALL

  SELECT QuarterEndDate = '20220930'
  ,GeoTypeID = 20260
     ,TotalEmployment = 136.2900 UNION ALL

  SELECT QuarterEndDate = '20221231'
  ,GeoTypeID = 20260
     ,TotalEmployment = 136.3400 UNION ALL

  SELECT QuarterEndDate = '20230331'
  ,GeoTypeID = 20260
     ,TotalEmployment = 136.4000 UNION ALL

  SELECT QuarterEndDate = '20230630'
  ,GeoTypeID = 20260
     ,TotalEmployment = 136.4600 UNION ALL

  SELECT QuarterEndDate = '20230930'
  ,GeoTypeID = 20260
     ,TotalEmployment = 136.5000 UNION ALL

  SELECT QuarterEndDate = '20231231'
  ,GeoTypeID = 20260
     ,TotalEmployment = 136.5500 UNION ALL

  SELECT QuarterEndDate = '20240331'
  ,GeoTypeID = 20260
     ,TotalEmployment = 136.5800 UNION ALL

  SELECT QuarterEndDate = '20240630'
  ,GeoTypeID = 20260
     ,TotalEmployment = 136.6000 UNION ALL

  SELECT QuarterEndDate = '20240930'
  ,GeoTypeID = 20260
     ,TotalEmployment = 136.6300 UNION ALL

  SELECT QuarterEndDate = '20241231'
  ,GeoTypeID = 20260
     ,TotalEmployment = 136.6400 UNION ALL

  SELECT QuarterEndDate = '20250331'
  ,GeoTypeID = 20260
     ,TotalEmployment = 136.6700 UNION ALL

  SELECT QuarterEndDate = '20250630'
  ,GeoTypeID = 20260
     ,TotalEmployment = 136.6900 UNION ALL

  SELECT QuarterEndDate = '20250930'
  ,GeoTypeID = 20260
     ,TotalEmployment = 136.7200 UNION ALL

  SELECT QuarterEndDate = '20251231'
  ,GeoTypeID = 20260
     ,TotalEmployment = 136.7500

       /**********************END FORECAST***************/
IF OBJECT_ID('tempdb..#Lower_ID', 'u') IS NOT NULL
  DROP TABLE #Lower_ID

  CREATE TABLE #Lower_ID
(
GeoTypeID INT
)

  INSERT INTO #Lower_ID
SELECT GeoTypeID = 39980
UNION ALL
SELECT GeoTypeID = 37020
UNION ALL
SELECT GeoTypeID = 45380
UNION ALL
SELECT GeoTypeID = 27920
UNION ALL
SELECT GeoTypeID = 37140
UNION ALL
SELECT GeoTypeID = 27220
UNION ALL
SELECT GeoTypeID = 18740
UNION ALL
SELECT GeoTypeID = 41060
UNION ALL
SELECT GeoTypeID = 13740
UNION ALL
SELECT GeoTypeID = 15580
UNION ALL
SELECT GeoTypeID = 15620
UNION ALL
SELECT GeoTypeID = 24700
UNION ALL
SELECT GeoTypeID = 31900
UNION ALL
SELECT GeoTypeID = 25740
UNION ALL
SELECT GeoTypeID = 14340
UNION ALL
SELECT GeoTypeID = 24260
UNION ALL
SELECT GeoTypeID = 28100
UNION ALL
SELECT GeoTypeID = 20260
UNION ALL
SELECT GeoTypeID = 38580
UNION ALL
SELECT GeoTypeID = 43780
UNION ALL
SELECT GeoTypeID = 31740
UNION ALL
SELECT GeoTypeID = 48020
UNION ALL
SELECT GeoTypeID = 11780
UNION ALL
SELECT GeoTypeID = 19540
UNION ALL
SELECT GeoTypeID = 25700
UNION ALL
SELECT GeoTypeID = 35420
UNION ALL
SELECT GeoTypeID = 23340
UNION ALL
SELECT GeoTypeID = 11740
UNION ALL
SELECT GeoTypeID = 22020
UNION ALL
SELECT GeoTypeID = 26540
UNION ALL
SELECT GeoTypeID = 20220
UNION ALL
SELECT GeoTypeID = 29200
UNION ALL
SELECT GeoTypeID = 36780
UNION ALL
SELECT GeoTypeID = 22260
UNION ALL
SELECT GeoTypeID = 32980
UNION ALL
SELECT GeoTypeID = 26700
UNION ALL
SELECT GeoTypeID = 10100
UNION ALL
SELECT GeoTypeID = 15740
UNION ALL
SELECT GeoTypeID = 25580
UNION ALL
SELECT GeoTypeID = 27500
UNION ALL
SELECT GeoTypeID = 31820
UNION ALL
SELECT GeoTypeID = 34620
UNION ALL
SELECT GeoTypeID = 39860
UNION ALL
SELECT GeoTypeID = 31980
UNION ALL
SELECT GeoTypeID = 39540
UNION ALL
SELECT GeoTypeID = 15900
UNION ALL
SELECT GeoTypeID = 34540
UNION ALL
SELECT GeoTypeID = 14660
UNION ALL
SELECT GeoTypeID = 28260
UNION ALL
SELECT GeoTypeID = 49780
UNION ALL
SELECT GeoTypeID = 14580
UNION ALL
SELECT GeoTypeID = 18820
UNION ALL
SELECT GeoTypeID = 47420
UNION ALL
SELECT GeoTypeID = 26740
UNION ALL
SELECT GeoTypeID = 47780
UNION ALL
SELECT GeoTypeID = 22300
UNION ALL
SELECT GeoTypeID = 30900
UNION ALL
SELECT GeoTypeID = 48460
UNION ALL
SELECT GeoTypeID = 28380
UNION ALL
SELECT GeoTypeID = 35500
UNION ALL
SELECT GeoTypeID = 19580
UNION ALL
SELECT GeoTypeID = 44100
UNION ALL
SELECT GeoTypeID = 10660
UNION ALL
SELECT GeoTypeID = 32020
UNION ALL
SELECT GeoTypeID = 21140
UNION ALL
SELECT GeoTypeID = 31140
UNION ALL
SELECT GeoTypeID = 40300
UNION ALL
SELECT GeoTypeID = 47540
UNION ALL
SELECT GeoTypeID = 49300
UNION ALL
SELECT GeoTypeID = 23380
UNION ALL
SELECT GeoTypeID = 31540
UNION ALL
SELECT GeoTypeID = 33780
UNION ALL
SELECT GeoTypeID = 36940
UNION ALL
SELECT GeoTypeID = 38500
UNION ALL
SELECT GeoTypeID = 12660
UNION ALL
SELECT GeoTypeID = 24580
UNION ALL
SELECT GeoTypeID = 26960
UNION ALL
SELECT GeoTypeID = 15940
UNION ALL
SELECT GeoTypeID = 23940
UNION ALL
SELECT GeoTypeID = 17540
UNION ALL
SELECT GeoTypeID = 17860
UNION ALL
SELECT GeoTypeID = 32100
UNION ALL
SELECT GeoTypeID = 45460
UNION ALL
SELECT GeoTypeID = 21840
UNION ALL
SELECT GeoTypeID = 47700
UNION ALL
SELECT GeoTypeID = 19780
UNION ALL
SELECT GeoTypeID = 37660
UNION ALL
SELECT GeoTypeID = 26580
UNION ALL
SELECT GeoTypeID = 48540
UNION ALL
SELECT GeoTypeID = 48940
UNION ALL
SELECT GeoTypeID = 11860
UNION ALL
SELECT GeoTypeID = 29020
UNION ALL
SELECT GeoTypeID = 46780
UNION ALL
SELECT GeoTypeID = 47920
UNION ALL
SELECT GeoTypeID = 22780
UNION ALL
SELECT GeoTypeID = 25300
UNION ALL
SELECT GeoTypeID = 26340
UNION ALL
SELECT GeoTypeID = 15100
UNION ALL
SELECT GeoTypeID = 33540
UNION ALL
SELECT GeoTypeID = 47980
UNION ALL
SELECT GeoTypeID = 41140
UNION ALL
SELECT GeoTypeID = 48140
UNION ALL
SELECT GeoTypeID = 11680
UNION ALL
SELECT GeoTypeID = 16460
UNION ALL
SELECT GeoTypeID = 18100
UNION ALL
SELECT GeoTypeID = 36840
UNION ALL
SELECT GeoTypeID = 43580
UNION ALL
SELECT GeoTypeID = 45660
UNION ALL
SELECT GeoTypeID = 11420
UNION ALL
SELECT GeoTypeID = 33020
UNION ALL
SELECT GeoTypeID = 17060
UNION ALL
SELECT GeoTypeID = 23300
UNION ALL
SELECT GeoTypeID = 36540
UNION ALL
SELECT GeoTypeID = 48820
UNION ALL
SELECT GeoTypeID = 31860
UNION ALL
SELECT GeoTypeID = 45820
UNION ALL
SELECT GeoTypeID = 22800
UNION ALL
SELECT GeoTypeID = 31500
UNION ALL
SELECT GeoTypeID = 43620
UNION ALL
SELECT GeoTypeID = 13660
UNION ALL
SELECT GeoTypeID = 20820
UNION ALL
SELECT GeoTypeID = 13100
UNION ALL
SELECT GeoTypeID = 36900
UNION ALL
SELECT GeoTypeID = 42740
UNION ALL
SELECT GeoTypeID = 49380
UNION ALL
SELECT GeoTypeID = 32380
UNION ALL
SELECT GeoTypeID = 28060
UNION ALL
SELECT GeoTypeID = 16220
UNION ALL
SELECT GeoTypeID = 33580
UNION ALL
SELECT GeoTypeID = 39660
UNION ALL
SELECT GeoTypeID = 14020
UNION ALL
SELECT GeoTypeID = 33220
UNION ALL
SELECT GeoTypeID = 26980
UNION ALL
SELECT GeoTypeID = 36820
UNION ALL
SELECT GeoTypeID = 43940
UNION ALL
SELECT GeoTypeID = 21860
UNION ALL
SELECT GeoTypeID = 13340
UNION ALL
SELECT GeoTypeID = 23060
UNION ALL
SELECT GeoTypeID = 42300
UNION ALL
SELECT GeoTypeID = 11180
UNION ALL
SELECT GeoTypeID = 22060
UNION ALL
SELECT GeoTypeID = 29940
UNION ALL
SELECT GeoTypeID = 28860
UNION ALL
SELECT GeoTypeID = 15460
UNION ALL
SELECT GeoTypeID = 44220
UNION ALL
SELECT GeoTypeID = 17740
UNION ALL
SELECT GeoTypeID = 44580
UNION ALL
SELECT GeoTypeID = 13180
UNION ALL
SELECT GeoTypeID = 24460
UNION ALL
SELECT GeoTypeID = 27300
UNION ALL
SELECT GeoTypeID = 30700
UNION ALL
SELECT GeoTypeID = 23780
UNION ALL
SELECT GeoTypeID = 32180
UNION ALL
SELECT GeoTypeID = 38180
UNION ALL
SELECT GeoTypeID = 13900
UNION ALL
SELECT GeoTypeID = 19860
UNION ALL
SELECT GeoTypeID = 38260
UNION ALL
SELECT GeoTypeID = 30620
UNION ALL
SELECT GeoTypeID = 33620
UNION ALL
SELECT GeoTypeID = 19940
UNION ALL
SELECT GeoTypeID = 26090
UNION ALL
SELECT GeoTypeID = 13260
UNION ALL
SELECT GeoTypeID = 28340
UNION ALL
SELECT GeoTypeID = 34740
UNION ALL
SELECT GeoTypeID = 33140
UNION ALL
SELECT GeoTypeID = 49100
UNION ALL
SELECT GeoTypeID = 46820
UNION ALL
SELECT GeoTypeID = 41400
UNION ALL
SELECT GeoTypeID = 16060
UNION ALL
SELECT GeoTypeID = 47180
UNION ALL
SELECT GeoTypeID = 10420
UNION ALL
SELECT GeoTypeID = 37940
UNION ALL
SELECT GeoTypeID = 29660
UNION ALL
SELECT GeoTypeID = 25880
UNION ALL
SELECT GeoTypeID = 33500
UNION ALL
SELECT GeoTypeID = 38740
UNION ALL
SELECT GeoTypeID = 32860
UNION ALL
SELECT GeoTypeID = 10980
UNION ALL
SELECT GeoTypeID = 49460
UNION ALL
SELECT GeoTypeID = 27100
UNION ALL
SELECT GeoTypeID = 24340
UNION ALL
SELECT GeoTypeID = 16660
UNION ALL
SELECT GeoTypeID = 14010
UNION ALL
SELECT GeoTypeID = 35220
UNION ALL
SELECT GeoTypeID = 47340
UNION ALL
SELECT GeoTypeID = 28020
UNION ALL
SELECT GeoTypeID = 47660
UNION ALL
SELECT GeoTypeID = 13420
UNION ALL
SELECT GeoTypeID = 37900
UNION ALL
SELECT GeoTypeID = 41780
UNION ALL
SELECT GeoTypeID = 10940
UNION ALL
SELECT GeoTypeID = 27540
UNION ALL
SELECT GeoTypeID = 38700
UNION ALL
SELECT GeoTypeID = 24330
UNION ALL
SELECT GeoTypeID = 16140
UNION ALL
SELECT GeoTypeID = 27160
UNION ALL
SELECT GeoTypeID = 16300
UNION ALL
SELECT GeoTypeID = 19500
UNION ALL
SELECT GeoTypeID = 14700
UNION ALL
SELECT GeoTypeID = 24820
UNION ALL
SELECT GeoTypeID = 42980
UNION ALL
SELECT GeoTypeID = 40180
UNION ALL
SELECT GeoTypeID = 43380
UNION ALL
SELECT GeoTypeID = 44180
UNION ALL
SELECT GeoTypeID = 48580
UNION ALL
SELECT GeoTypeID = 22700
UNION ALL
SELECT GeoTypeID = 29100
UNION ALL
SELECT GeoTypeID = 16940
UNION ALL
SELECT GeoTypeID = 26780
UNION ALL
SELECT GeoTypeID = 23140
UNION ALL
SELECT GeoTypeID = 11540
UNION ALL
SELECT GeoTypeID = 12980
UNION ALL
SELECT GeoTypeID = 23660
UNION ALL
SELECT GeoTypeID = 31930
UNION ALL
SELECT GeoTypeID = 30060
UNION ALL
SELECT GeoTypeID = 16380
UNION ALL
SELECT GeoTypeID = 40420
UNION ALL
SELECT GeoTypeID = 24220
UNION ALL
SELECT GeoTypeID = 35860
UNION ALL
SELECT GeoTypeID = 20740
UNION ALL
SELECT GeoTypeID = 40980
UNION ALL
SELECT GeoTypeID = 13020
UNION ALL
SELECT GeoTypeID = 43020
UNION ALL
SELECT GeoTypeID = 22100
UNION ALL
SELECT GeoTypeID = 19980
UNION ALL
SELECT GeoTypeID = 22420
UNION ALL
SELECT GeoTypeID = 24500
UNION ALL
SELECT GeoTypeID = 34380
UNION ALL
SELECT GeoTypeID = 40540
UNION ALL
SELECT GeoTypeID = 48780
UNION ALL
SELECT GeoTypeID = 35820
UNION ALL
SELECT GeoTypeID = 39020
UNION ALL
SELECT GeoTypeID = 27420
UNION ALL
SELECT GeoTypeID = 19180
UNION ALL
SELECT GeoTypeID = 21540
UNION ALL
SELECT GeoTypeID = 30420
UNION ALL
SELECT GeoTypeID = 49660
UNION ALL
SELECT GeoTypeID = 35740
UNION ALL
SELECT GeoTypeID = 44620
UNION ALL
SELECT GeoTypeID = 17700
UNION ALL
SELECT GeoTypeID = 32700
UNION ALL
SELECT GeoTypeID = 37800
UNION ALL
SELECT GeoTypeID = 19380
UNION ALL
SELECT GeoTypeID = 38840
UNION ALL
SELECT GeoTypeID = 10820
UNION ALL
SELECT GeoTypeID = 45780
UNION ALL
SELECT GeoTypeID = 35580
UNION ALL
SELECT GeoTypeID = 34500
UNION ALL
SELECT GeoTypeID = 38420
UNION ALL
SELECT GeoTypeID = 40340
UNION ALL
SELECT GeoTypeID = 19340
UNION ALL
SELECT GeoTypeID = 35940
UNION ALL
SELECT GeoTypeID = 40620
UNION ALL
SELECT GeoTypeID = 11460
UNION ALL
SELECT GeoTypeID = 39500
UNION ALL
SELECT GeoTypeID = 21740
UNION ALL
SELECT GeoTypeID = 43100
UNION ALL
SELECT GeoTypeID = 43460
UNION ALL
SELECT GeoTypeID = 29620
UNION ALL
SELECT GeoTypeID = 32140
UNION ALL
SELECT GeoTypeID = 36860
UNION ALL
SELECT GeoTypeID = 12140
UNION ALL
SELECT GeoTypeID = 31220
UNION ALL
SELECT GeoTypeID = 47940
UNION ALL
SELECT GeoTypeID = 22540
UNION ALL
SELECT GeoTypeID = 31380
UNION ALL
SELECT GeoTypeID = 15340
UNION ALL
SELECT GeoTypeID = 18220
UNION ALL
SELECT GeoTypeID = 42420
UNION ALL
SELECT GeoTypeID = 27020
UNION ALL
SELECT GeoTypeID = 18020
UNION ALL
SELECT GeoTypeID = 34700
UNION ALL
SELECT GeoTypeID = 30580
UNION ALL
SELECT GeoTypeID = 27620
UNION ALL
SELECT GeoTypeID = 31940
UNION ALL
SELECT GeoTypeID = 35660
UNION ALL
SELECT GeoTypeID = 21380
UNION ALL
SELECT GeoTypeID = 27900
UNION ALL
SELECT GeoTypeID = 10300
UNION ALL
SELECT GeoTypeID = 22220
UNION ALL
SELECT GeoTypeID = 43980
UNION ALL
SELECT GeoTypeID = 12380
UNION ALL
SELECT GeoTypeID = 16020
UNION ALL
SELECT GeoTypeID = 32260
UNION ALL
SELECT GeoTypeID = 44020
UNION ALL
SELECT GeoTypeID = 16580
UNION ALL
SELECT GeoTypeID = 49220
UNION ALL
SELECT GeoTypeID = 21780
UNION ALL
SELECT GeoTypeID = 44740
UNION ALL
SELECT GeoTypeID = 41460
UNION ALL
SELECT GeoTypeID = 48620
UNION ALL
SELECT GeoTypeID = 11900
UNION ALL
SELECT GeoTypeID = 46500
UNION ALL
SELECT GeoTypeID = 45900
UNION ALL
SELECT GeoTypeID = 32340
UNION ALL
SELECT GeoTypeID = 48260
UNION ALL
SELECT GeoTypeID = 30660
UNION ALL
SELECT GeoTypeID = 43260
UNION ALL
SELECT GeoTypeID = 44780

  --RETURN;

  INSERT INTO #EmploymentTestData
(
  GeoTypeID
 ,QuarterEndDate
 ,TotalEmployment
)
SELECT
  MissingGeos.GeoTypeID
 ,QuarterEndDate
 ,AverageEmployment = AVG(TotalEmployment)
FROM #EmploymentTestData ef
CROSS JOIN
(
  SELECT DISTINCT  --seems problem with DISTINCT included?
     GeoTypeID
  FROM #Lower_ID
  EXCEPT
  SELECT DISTINCT --seems problem with DISTINCT included?
     GeoTypeID
  FROM #EmploymentTestData
) AS MissingGeos
GROUP BY
  QuarterEndDate
 ,MissingGeos.GeoTypeID;

  GO 20 --run 20 times

  /********************rewrite which seemed to fix error.*****

  SELECT
  MissingGeos.GeoTypeID
 ,QuarterEndDate
 ,AverageEmployment = AVG(TotalEmployment)
FROM #EmploymentTestData ef
CROSS JOIN
(
  SELECT
     GeoTypeID
  FROM #Lower_ID
  EXCEPT
  SELECT
     GeoTypeID
  FROM #EmploymentTestData
) AS MissingGeos
WHERE NOT EXISTS (SELECT 1
              FROM #EmploymentTestData x
              WHERE MissingGeos.GeoTypeID = x.GeoTypeID
             )
GROUP BY
  QuarterEndDate
 ,MissingGeos.GeoTypeID;
 

  **************************************************************/


• brad.mason5

  Hall of Fame

  Points: 3299

  More actions

  October 26, 2017 at 2:09 pm

  #1965386

  A few of my team members looked at this and found the issue to be fixed in a later service pack. 
  The solution for now is to either create Clustered Index on table or set a trace flag.   Creating the Clustered Index solved the issue for me.

  https://support.microsoft.com/en-us/help/960770/fix-you-receive-error-605-and-error-824-when-you-run-a-query-that-inse

• Jeff Moden

  SSC Guru

  Points: 1004289

  More actions

  October 26, 2017 at 5:36 pm

  #1965427

  The real solution is to not use WITH(NOLOCK). 😉

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)
  

• brad.mason5

  Hall of Fame

  Points: 3299

  More actions

  October 26, 2017 at 5:47 pm

  #1965429

  Yes we will gradually get there.  Have tons of code that uses NOLOCK as most companies probably do.

  But in the case above even using Read Committed Isolation results in error. 

  Msg 605, Level 21, State 3, Line 6221
  Attempt to fetch logical page (5:269848) in database 2 failed. It belongs to allocation unit 8214589066255794176 not to 5836688556024332288.

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  October 26, 2017 at 5:50 pm

  #1965430

  brad.mason5 - Thursday, October 26, 2017 5:47 PM

  Yes we will gradually get there.  Have tons of code that uses NOLOCK as most companies probably do.

  But in the case above even using Read Committed Isolation results in error. 

  Msg 605, Level 21, State 3, Line 6221
  Attempt to fetch logical page (5:269848) in database 2 failed. It belongs to allocation unit 8214589066255794176 not to 5836688556024332288.

  That sounds like possible corruption.  Have you run a DBCC CHECKDB on the database?

• brad.mason5

  Hall of Fame

  Points: 3299

  More actions

  October 26, 2017 at 6:01 pm

  #1965433

  No I have not but I am sure the DBA's have.  Worth following up though.
  This solved the problem.   

  CREATE TABLE #EmploymentTestData
  ( 
    QuarterEndDate DATETIME NOT NULL
    , GeoTypeID INT NOT NULL
    , TotalEmployment DECIMAL(12, 4) NULL
    , PRIMARY KEY CLUSTERED (QuarterEndDate, GeoTypeID) -- it fails without this, succeeds with it.
  )