Civics & Covid-19 updates as of 09/21/2022



From:      To:       csv json      


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

From to
     

Past 7 days
     

Past 21 days
     
Example results in csv format:
Province_State,Political_color,Population,perConfirmed,perDeaths
Wisconsin,#80A0FF,5851754,648,1

Example results in json format:  
[{"perCon":"648","perDeaths":"1","Province_State":"Wisconsin","color":"#80A0FF","Population":"5851754"}]


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:

From to
     

Past 7 days
     

Past 21 days
     
Example results in csv format:
Location_ID,Province_State,Political_color,Population,Confirmed_cases,Death,Recovered,Active,Timestamp
5,California,#0000FF,39937489,3351,12,0,3339,

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


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

From to
     

Past 7 days
     

Past 21 days
     
Example results in csv format:
Country_Region,Confirmed_cases,Deaths,Active,Recovered
US,158652,457,77114,30026,

Example results in json format:
[{"Country_region":"US","Confirmed_cases":"158652","Deaths":"457","Active":"77114","Recovered":"30026"}] 


California data by county:

From to
     

Past 7 days
     

Past 21 days
     
Example results in csv format: 
County_code,Location,Confirmed_cases,Deaths,Recovered,Active,Timestamp
001,Alameda, California, US,0,0,0,0,2020-11-08 00:00:00

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