Civics & Covid-19 updates as of 11/23/2021



From:      To:       csv json      


Confirmed cases and deaths per 100,000 color-coded by the political party:

Province_State,Political_color,Population,perConfirmed,perDeaths
Wisconsin,#80A0FF,5851754,648,1

[{"perCon":"648","perDeaths":"1","Province_State":"Wisconsin","color":"#80A0FF","Population":"5851754"}]
     

Past 7 days
     

Past 21 days
     



Sample python script for CSV format

import urllib.request

dataURL = "https://robothot.ai/DataTutorial-Covid-19/get_PerCon.php?B=2020-11-08%2000:00:00&E=2020-11-09%2000:00:00&T=csv"
fp = urllib.request.urlopen(dataURL)
data = fp.read()
data = data.decode("utf8")
print(data)

Sample python script for JSON format

import json

dataURL = "https://robothot.ai/DataTutorial-Covid-19/get_PerCon.php?B=2020-11-08%2000:00:00&E=2020-11-09%2000:00:00&T=json"
fp = urllib.request.urlopen(dataURL)
data_string = fp.read()
data_string = data_string.decode("utf8")
data_json = json.loads(data_string)
for j in data_json:
    #print(j)
    print("\n")
    print(j["Province_State"])
    print(j["Population"])
    print(j["color"])
    print(j["perCon"])
    print(j["perDeaths"])


USA data by state color-coded by the political party:

Location_ID,Province_State,Political_color,Population,Confirmed_cases,Deaths,Recovered,Active,Timestamp
5,California,#0000FF,39937489,3351,12,0,3339,

[{"confirmed":"3351","deaths":"12","recovered":"0","active":"3339","population":"39937489","Province_State":"California","color":"#0000FF","LOC_ID":"5"}]
     

Past 7 days
     

Past 21 days
     



Country data including breakdown by region (not all regions have reported statistics):

Country_Region,Confirmed_cases,Deaths,Active,Recovered
US,158652,457,77114,30026,

[{"Country_region":"US","Confirmed_cases":"158652","Deaths":"457","Active":"77114","Recovered":"30026"}] 
     

Past 7 days
     

Past 21 days
     



California data by county:

County_code,Location,Confirmed_cases,Deaths,Recovered,Active,Timestamp
001,Alameda, California, US,0,0,0,0,2020-11-08 00:00:00

[{"FIPS":"6001","LOCATION":"Alameda, California, US","population":"1666750","confirmed":"0","dead":"0","recovered":"0","active":"0","timestamp":"2020-11-08 00:00:00"}]
     

Past 7 days
     

Past 21 days