Neat Things You Can Do With Public Data

Andy Arthur GitHubGit my R and Python scripts used to make maps and diagrams.

Mapping and Political Data 🐴 🐘

Crunched Election Results with Turnout for Albany County: November 2023, 2022, 2021, 2020, 2019 and Primaries June 2019, Pres/June 2020, June 2021, June 2022, Aug 2022, June 2023.

Albany County Races converted to the new 2023 EDs using Super EDs and Code: 2022, 2021, 2020, 2019 and Primaries June 2019, Pres/June 2020, June 2021, June 2022, Aug 2022.

Above Election Results as zipped Excel files.

A Crosswalk Table Showing the Proposition of Voting Age Population in New and Old EDs

A comparison of Democratic Performance 2022 Assembly Districts to those proposed in 2023 by the IRC. Here is latest 4/20/23 IRC Maps, showing ADP and how they change from existing Assembly districts. Most towns upstate, outside of cities, are quite red. Using LATFOR data with R to calculate Average Democratic Performance.

State Worker Data👱👷

You can scrape state and local employee salary data from SeeThroughNY using R.

Other useful investigative resources using public data!

Property Taxes 🏠💸

Find coordinates and political districts

Look Up State Tax Records

Script for Processing RPTL 1520 PDFs.

Match NY SWIS Codes to FIPS Codes and GEOID.

How to Find MapServer Data and Load Into QGIS.

Making Maps and Processing Data 📉📊

WMS and ArcMap ServicesDownloadable CSV file listing services used on the blog.

Interactive Maps of NY CensusExplore and download KML files.

Thematic Map: Fifty Least Densely Populated Municipalities in NY State
Thematic Map: us-state-pop-density-1900