A | B | C | D | E | F | G | H | J | K | L | M | N | O | P | Q | R | S | ||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Scraped? | Country | County Data? | Abbrev | Name | Source | Type | Notes | Abbr. | Last Checked/Updated | Checked By | Potential Contact | Phone | Date Contact Initiated | Task Owner | Outcome | |||
2 | yes | USA | yes | AL | Alabama | http://www.alabamapublichealth.gov/infectiousdiseases/2019-coronavirus.html | Table | by county | AL | ||||||||||
3 | yes | USA | yes | AK | Alaska | http://dhss.alaska.gov/dph/Epi/id/Pages/COVID-19/monitoring.aspx | List | Listed in table by economic region, as of 3/17; I don't anticipate them entering by buroughs, so I would use economic region instead | AK | 3/17 | Maggie | ||||||||
4 | no | USA | no | AS | American Samoa | https://www.samoanews.com/regional/effective-immediately-samoa-health-travel-advisory-coronavirus | List | No county data; press release; they have 14 "local" counties | AS | 3/18 | Maggie | Sarah Brown | sarahb@health.gov.ws | ||||||
5 | yes | USA | yes | AZ | Arizona | https://tableau.azdhs.gov/views/COVID-19Dashboard/COVID-19table?:embed=y&:showVizHome=no&:host_url=https%3A%2F%2Ftableau.azdhs.gov%2F&:embed_code_version=3&:tabs=yes&:toolbar=yes&:showAppBanner=false&:display_spinner=no&iframeSizedToWindow=true&:loadOrderID=0 | Tableau | Hacked Tableau viz URL to show toolbar, download icon visible at the bottom | AZ | ||||||||||
6 | yes | USA | yes | AR | Arkansas | https://www.healthy.arkansas.gov/programs-services/topics/novel-coronavirus | List, Image | Should be fixed now; county data there | AR | 3/23 | Maggie | ADH.CoronaVirus@arkansas.gov | |||||||
7 | no | USA | no | CA | California | https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/Immunization/ncov2019.aspx | Currently hand collected by Harriet Blair Rowan | CA | 3/16 | Maggie | Corey Egel, CHPH Public Affairs | CDPHpress@cdph.ca.gov | 916.440.7259 | 3/13 | |||||
8 | yes | USA | yes | CO | Colorado | https://covid19.colorado.gov/data | Table, ArcGis | CO | Crestina Martinez | Crestina.Martinez@state.co.us | (719) 588-0673 | ||||||||
9 | yes | USA | yes | CT | Connecticut | https://portal.ct.gov/Coronavirus | List | CT | |||||||||||
10 | yes | USA | yes | DE | Delaware | https://www.dhss.delaware.gov/dhss/dph/epi/2019novelcoronavirus.html | Table | DE | |||||||||||
11 | yes | USA | yes | DC | District of Columbia | https://coronavirus.dc.gov/page/coronavirus-data | List | DC | |||||||||||
12 | yes | USA | yes | FL | Florida | http://www.floridahealth.gov/diseases-and-conditions/COVID-19/index.html | Table | FL | |||||||||||
13 | yes | USA | yes | GA | Georgia | https://dph.georgia.gov/georgia-department-public-health-covid-19-daily-status-report | Table | HTML Table added 3/16 | GA | 3/22 | David | Resolved | |||||||
14 | no | USA | no | GU | Guam | http://dphss.guam.gov/2019-novel-coronavirus-2019-n-cov/ | List | Press releases, no data | GU | ||||||||||
15 | yes | USA | yes | HI | Hawaii | https://health.hawaii.gov/docd/advisories/novel-coronavirus-2019/ | Table | County data present as of 3/23 | HI | 3/23 | Maggie | ||||||||
16 | yes | USA | yes | ID | Idaho | https://coronavirus.idaho.gov/ | Table | County data available 3/23 | ID | 3/23 | Maggie | Niki Forbing-Orr, Manager, 208-334-0668 | DPHInquiries@dhw.idaho.gov | 208-334-0668 | 3/16 | ||||
17 | yes | USA | yes | IL | Illinois | http://www.dph.illinois.gov/sites/default/files/COVID19/COVID19CountyResults.json | JSON | County data added with JSON Link | IL | 3/16 | Maggie | DPH.SICK@ILLINOIS.GOV | 1-800-889-3931 | 3/16 | |||||
18 | yes | USA | yes | IN | Indiana | https://www.in.gov/coronavirus/ | Map, Table | Needs JavaScript to render data, but has county data | IN | ||||||||||
19 | yes | USA | yes | IA | Iowa | https://idph.iowa.gov/emerging-health-issues/novel-coronavirus | Table | IA | 3/19 | David | 3/19 | David Geeraerts | Resolved | ||||||
20 | yes | USA | yes | KS | Kansas | http://www.kdheks.gov/coronavirus/#undefined | No table, dispirate links | KS | |||||||||||
21 | yes | USA | yes | KY | Kentucky | https://datawrapper.dwcdn.net/BbowM/23/ | CSV | CSV text contained in download link | KY | 3/16 | Maggie | Sebastian Kitchen, Deputy Comms Director | Sebastian.Kitchen@ky.gov | (800)722-5725 | 3/16 | ||||
22 | yes | USA | yes | LA | Louisiana | http://ldh.la.gov/Coronavirus/ | Table | Site was updated on 3/14 from table to ArgGIS map. I don't know how to build a scraper, but this is the direct link to the new dashboard: https://www.arcgis.com/apps/opsdashboard/index.html#/c091b679e7f64fa78628de361f64eb92 | LA | 3/17 | cphi1@la.gov | 3/15 | |||||||
23 | yes | USA | yes | ME | Maine | https://www.maine.gov/dhhs/mecdc/infectious-disease/epi/airborne/coronavirus.shtml | Table | County data available as of 3/16 | ME | 3/16 | Maggie | ||||||||
24 | yes | USA | yes | MD | Maryland | https://phpa.health.maryland.gov/Pages/Novel-coronavirus.aspx | List | County data available as of 3/16 | MD | 3/16 | Maggie | ||||||||
25 | yes | USA | yes | MA | Massachusetts | https://www.mass.gov/info-details/covid-19-cases-quarantine-and-monitoring | County data in PDF | MA | |||||||||||
26 | yes | USA | yes | MI | Michigan | https://www.michigan.gov/coronavirus/0,9753,7-406-98163-520743--,00.html | Table | County data available as of 3/18 | MI | 3/16 | Maggie | Bob Wheaton | wheatonb@michigan.gov | 517-281-1701 | 3/16 | ||||
27 | yes | USA | yes | MN | Minnesota | https://www.health.state.mn.us/diseases/coronavirus/situation.html | Image | 📞 County data present, but ranged not numerical, stuckin an image, call to ask for proper data | MN | 3/16 | Maggie | Doug Schultz | doug.schultz@state.mn.us | 651-201-4993 | 3/16 | ||||
28 | yes | USA | yes | MS | Mississippi | https://msdh.ms.gov/msdhsite/_static/14,0,420.html | Table, map | MS | |||||||||||
29 | yes | USA | yes | MO | Missouri | https://health.mo.gov/living/healthcondiseases/communicable/novel-coronavirus/ | Table | County data available as of 3/16 in paragraph under table | MO | 3/16 | Maggie | ||||||||
30 | yes | USA | yes | MT | Montana | https://dphhs.mt.gov/publichealth/cdepi/diseases/coronavirusmt | Table | No county data | MT | 3/16 | Maggie | Jon Ebelt, Public Information Officer | jebelt@mt.gov | (406) 444-0936 | 3/16 | ||||
31 | pr filed | USA | yes | NE | Nebraska | http://dhhs.ne.gov/Pages/Coronavirus.aspx | List | No county data | NE | 3/16 | Maggie | Leah Bucco-White, Communications; Khalilah LeGrand, Communications | leah.bucco-white@nebraska.gov; khalilah.legrand@nebraska.gov | 402-309-4157 | 3/16 | ||||
32 | no | USA | no | NV | Nevada | https://app.powerbigov.us/view?r=eyJrIjoiMjA2ZThiOWUtM2FlNS00MGY5LWFmYjUtNmQwNTQ3Nzg5N2I2IiwidCI6ImU0YTM0MGU2LWI4OWUtNGU2OC04ZWFhLTE1NDRkMjcwMzk4MCJ9 | Tables | No county data, but rather lab counts various patient data | NV | 3/23 | Maggie | Lisa Sherych, Administrator, Department of Public & Behavioral Health; Julia Peek, Deputy Administrator, Community Services Branch | lsherych@adsd.nv.gov; jpeek@health.nv.gov | 775-684-4200; 775-684-5280 | 3/16 | ||||
33 | yes | USA | yes | NH | New Hampshire | https://www.nh.gov/covid19/index.htm | County data listed in PDF Map | NH | 3/31 | Maggie | Joint Information Center | jic@dos.nh.gov | 603-223-6169 | 3/16 | |||||
34 | yes | USA | yes | NJ | New Jersey | https://www.nj.gov/health/cd/topics/covid2019_dashboard.shtml | Map | Has county data, but requires JavaScript | NJ | ||||||||||
35 | yes | USA | yes | NM | New Mexico | https://cv.nmhealth.org/cases-by-county/ | Table | Table 1 | NM | 3/23 | David | Jodi McGinnis Porter | jodi.mcginnis-porter@state.nm.us | 505-670-4136 | 3/16 | Resolved | |||
36 | yes | USA | yes | NY | New York | https://coronavirus.health.ny.gov/county-county-breakdown-positive-cases | Table | Only confirmed cases; simple table | NY | 3/20/2020 | Herb | ||||||||
37 | yes | USA | yes | NC | North Carolina | https://www.ncdhhs.gov/covid-19-case-count-nc | Table | County data in ESRI map | NC | ||||||||||
38 | no | USA | no | ND | North Dakota | https://www.health.nd.gov/diseases-conditions/coronavirus/north-dakota-coronavirus-cases | Image | County data in image | ND | 3/23 | Maggie | Used Web Form | https://www.health.nd.gov/contact | 701-328-2372 | 3/16 | ||||
39 | no | USA | no | MP | Northern Mariana Islands | https://www.chcc.gov.mp/coronavirusinformation.php | - | No data at all | MP | ||||||||||
40 | yes | USA | yes | OH | Ohio | https://odh.ohio.gov/wps/portal/gov/odh/know-our-programs/Novel-Coronavirus/welcome/ | List | now includes county details in paragraph under kpi's | OH | ||||||||||
41 | yes | USA | yes | OK | Oklahoma | https://www.ok.gov/health/Prevention_and_Preparedness/Acute_Disease_Service/Disease_Information/Coronavirus_Disease_2019/Oklahoma_Response_to_Coronavirus_Disease_2019/index.html | List | Has county data, as of 3/16 | OK | 3/16 | Maggie | N/A | |||||||
42 | yes | USA | yes | OR | Oregon | https://www.oregon.gov/oha/PH/DISEASESCONDITIONS/DISEASESAZ/Pages/emerging-respiratory-infections.aspx | Table | OR | |||||||||||
43 | yes | USA | yes | PA | Pennsylvania | https://www.health.pa.gov/topics/disease/Pages/Coronavirus.aspx | List | Posted as sitrep updates, not static | PA | ||||||||||
45 | yes | USA | yes | RI | Rhode Island | https://health.ri.gov/data/covid-19/ | Table | No county data; they will not release data by county, | RI | 3/16 | Maggie | Dr. Nicole Alexander-Scott | RIDOH.COVID19Questions@health.ri.gov | 401-222-5960 | |||||
46 | yes | USA | yes | SC | South Carolina | https://www.scdhec.gov/index.php/monitoring-testing-covid-19 | List | County data available as of 3/17, updated site info | SC | 3/17 | Maggie | info@dhec.sc.gov | (803) 898-3432 | ||||||
47 | yes | USA | yes | SD | South Dakota | https://doh.sd.gov/news/Coronavirus.aspx#SD | List, table | They corrected their date typos | SD | 3/16 | Maggie | ||||||||
48 | yes | USA | yes | TN | Tennessee | https://www.tn.gov/health/cedep/ncov.html | List, table | TN | |||||||||||
49 | yes | USA | yes | TX | Texas | https://www.dshs.state.tx.us/news/updates.shtm#coronavirus | Table | First Death (3/17/2020).Added new table for deaths.not picked up by scraper | TX | ||||||||||
50 | yes | USA | yes | UT | Utah | https://coronavirus.utah.gov/latest/ | UT | ||||||||||||
51 | no | USA | no | VT | Vermont | https://www.healthvermont.gov/response/infectious-disease/2019-novel-coronavirus | Image | county data available now | VT | 3/23 | Maggie | Ben Truman | bennett.truman@vermont.gov | 802-951-5153 | 3/16 | ||||
52 | no | USA | no | VI | Virgin Islands (US) | https://doh.vi.gov/news/health-officials-announce-first-confirmed-case-covid-19-usvi | https://doh.vi.gov/covid19usvi | List | no data; one case via press release | VI | 3/16 | Maggie | St. Croix Office, (340) 718-1311 | ||||||
53 | yes | USA | yes | VA | Virginia | http://www.vdh.virginia.gov/surveillance-and-investigation/novel-coronavirus/ | Tableau | Data provided in Tableau Vis, county data included. | VA | 3/23 | David Geeraerts | Suresh Soundararajan, Chief Info Tech Officer | suresh.soundararajan@vdh.virginia.gov | (804) 864-7140 | 3/23 | David Geeraerts | |||
54 | yes | USA | yes | WA | Washington | https://www.doh.wa.gov/Emergencies/Coronavirus | Table | No HTML <TABLE> tag! Contacted WA [WDOH] last week (2020-03-08) asking them to add back <TABLE> tags like they once had in the beginning.~DG | WA | 3/17 | David Geeraerts | Kathleen Sullivan | secretary@doh.wa.gov | 800-525-0127 | 3/5 | David Geeraerts | |||
55 | yes | USA | yes | WV | West Virginia | https://dhhr.wv.gov/COVID-19/Pages/default.aspx | Table | One case, no county data | WV | 3/17 | Maggie | DHHR Communications Team | DHHRCommunications | 3/17 | |||||
56 | yes | USA | yes | WI | Wisconsin | https://www.dhs.wisconsin.gov/outbreaks/index.htm | Table | *Updated* Aggregated County data | WI | ||||||||||
57 | yes | USA | Yes | WY | Wyoming | https://health.wyo.gov/publichealth/infectious-disease-epidemiology-unit/disease/novel-coronavirus/covid-19-map-and-statistics/ | Tableau | Tableau with data (csv) disabled. | WY | 3/23 | David | Used web form | |||||||
58 | |||||||||||||||||||
59 | |||||||||||||||||||
60 | |||||||||||||||||||
61 | |||||||||||||||||||
62 | |||||||||||||||||||
63 | |||||||||||||||||||
64 | |||||||||||||||||||
65 | |||||||||||||||||||
66 | |||||||||||||||||||
67 | |||||||||||||||||||
68 | |||||||||||||||||||
69 | |||||||||||||||||||
70 | |||||||||||||||||||
71 | |||||||||||||||||||
72 | |||||||||||||||||||
73 | |||||||||||||||||||
74 | |||||||||||||||||||
75 | |||||||||||||||||||
76 | |||||||||||||||||||
77 | |||||||||||||||||||
78 | |||||||||||||||||||
79 | |||||||||||||||||||
80 | |||||||||||||||||||
81 | |||||||||||||||||||
82 | |||||||||||||||||||
83 | |||||||||||||||||||
84 | |||||||||||||||||||
85 | |||||||||||||||||||
86 | |||||||||||||||||||
87 | |||||||||||||||||||
88 | |||||||||||||||||||
89 | |||||||||||||||||||
90 | |||||||||||||||||||
91 | |||||||||||||||||||
92 | |||||||||||||||||||
93 | |||||||||||||||||||
94 | |||||||||||||||||||
95 | |||||||||||||||||||
96 | |||||||||||||||||||
97 | |||||||||||||||||||
98 | |||||||||||||||||||
99 | |||||||||||||||||||
100 | |||||||||||||||||||
101 |