Municipal Fiscal Indicators: Benchmark Labor Data, 2019

Municipal Fiscal Indicators is an annual compendium of information compiled by the Office of Policy and Management, Office of Finance, Municipal Finance Services Unit (MFS). The data contained in Indicators provides key financial and demographic information on municipalities in Connecticut.

Municipal Fiscal Indicators contains the most current financial data available for each of Connecticut's 169 municipalities. The majority of this data was compiled from the audited financial statements that are filed annually with the State of Connecticut, Office of Policy and Management, Office of Finance. This database of information includes selected demographic and economic data relating to, or having an impact upon, a municipality’s financial condition. The most recent edition is for the Fiscal Years Ended 2015-2019 published in April 2021.

Data on the Municipal Fiscal Indicators is included in the following datasets:

Municipal Fiscal Indicators, 2019

https://data.ct.gov/Local-Government/Municipal-Fiscal-Indicators-2019/sb4i-6vik

Municipal Fiscal Indicators: Grand List Components, 2019

https://data.ct.gov/Local-Government/Municipal-Fiscal-Indicators-Grand-List-Components-/ifrb-kp2b

Municipal Fiscal Indicators: Pension Funding Information For Defined Benefit Pension Plans, 2019

https://data.ct.gov/Local-Government/Municipal-Fiscal-Indicators-Pension-Funding-Inform/civu-w22d

Municipal Fiscal Indicators: Type and Number of Pension Plans, 2019

https://data.ct.gov/Local-Government/Municipal-Fiscal-Indicators-Type-and-Number-of-Pen/9f65-c4yr

Municipal Fiscal Indicators: Other Post-Employment Benefits (OPEB), 2019

https://data.ct.gov/Local-Government/Municipal-Fiscal-Indicators-Other-Post-Employment-/sa26-46h8

Municipal Fiscal Indicators: Economic and Grand List Data, 2019

https://data.ct.gov/Local-Government/Municipal-Fiscal-Indicators-Economic-and-Grand-Lis/wpbp-b657

Municipal Fiscal Indicators: Benchmark Labor Data, 2019

https://data.ct.gov/Local-Government/Municipal-Fiscal-Indicators-Benchmark-Labor-Data-2/db37-h23r

Municipal Fiscal Indicators: Unemployment, 2019

https://data.ct.gov/Local-Government/Municipal-Fiscal-Indicators-Unemployment-2019/cugp-2za3

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"ct-gov/municipal-fiscal-indicators-benchmark-labor-data-db37-h23r\".\"municipal_fiscal_indicators_benchmark_labor_data\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.