Skip to content

Instantly share code, notes, and snippets.

@davidbarratt

davidbarratt/covidratio.txt

Last active September 13, 2020 18:51
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save davidbarratt/69eba3b011632ae003ace70a061b76dd to your computer and use it in GitHub Desktop.
Save davidbarratt/69eba3b011632ae003ace70a061b76dd to your computer and use it in GitHub Desktop.
Download ZIP
APIs for COVID Ratio
Raw
covidratio.txt
# Population of Every Florida County
https://api.census.gov/data/2019/pep/population?get=POP&for=county:*&in=state:12
# Number of cases in a Florida county within a date range
# @TODO I'm not sure which datetime field is the correct one to be looking at, there are at least 3.
https://services1.arcgis.com/CY1LXxl9zlJeBuRZ/arcgis/rest/services/Florida_COVID19_Case_Line_Data_NEW/FeatureServer/0/query?where=County+%3D+%27Orange%27+AND+Case1+%3E%3D+TIMESTAMP+%272020-03-18+00%3A00%3A00%27+AND+Case1+%3C%3D+TIMESTAMP+%272020-04-27+23%3A59%3A59%27&returnCountOnly=true&f=json
# Case count for given time range broken down by Florida county
https://services1.arcgis.com/CY1LXxl9zlJeBuRZ/arcgis/rest/services/Florida_COVID19_Case_Line_Data_NEW/FeatureServer/0/query?where=EventDate+%3E%3D+TIMESTAMP+%272020-08-30+00%3A00%3A00%27+AND+EventDate+%3C%3D+TIMESTAMP+%272020-09-12+23%3A59%3A59%27&f=json&outStatistics=%5B%7B+%09%22statisticType%22%3A+%22count%22%2C+%09%22onStatisticField%22%3A+%22ObjectId%22%2C+%09%22outStatisticFieldName%22%3A+%22Count%22+%7D%5D&groupByFieldsForStatistics=County&orderByFields=County
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment