Forms of Municipal Government

A listing of each of Connecticut's 169 municipalities indicating both the form of local government (such as Mayor-Council) and the Term in years for the Chief Elected Official

Updated annually as part of OPM's Municipal Fiscal Indicators report

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/forms-of-municipal-government-rn4x-2mrw\".\"forms_of_municipal_government\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.