*COVID Covid Anlaytics project
https://github.com/covid19india/covid19india-react
https://api.covid19india.org/raw_data3.json (API)
https://github.com/anjijava16/CovidCrowd
https://api.covid19api.com/countries
https://api.covid19api.com/total/country/south-africa/status/confirmed
https://api.covid19api.com/summary
https://api.covid19api.com/stats
https://api.covid19api.com/all (10MB data):
[ { "Country": "Afghanistan", "CountryCode": "AF", "Province": "", "City": "", "CityCode": "", "Lat": "33.94", "Lon": "67.71", "Confirmed": 0, "Deaths": 0, "Recovered": 0, "Active": 0, "Date": "2020-01-22T00:00:00Z" }]
CREATE TABLE COVID19_INDIA_TBL(
covid19_id INT(11) NOT NULL AUTO_INCREMENT,
agebracket VARCHAR(180) ,
contractedfromwhichpatientsuspected VARCHAR(180) ,
currentstatus VARCHAR(180) ,
dateannounced VARCHAR(180) ,
detectedcity VARCHAR(180) ,
detecteddistrict VARCHAR(180) ,
detectedstate VARCHAR(180) ,
entryid VARCHAR(180) ,
gender VARCHAR(180) ,
nationality VARCHAR(180) ,
notes VARCHAR(180) ,
numcases VARCHAR(180) ,
source1 VARCHAR(180) ,
source2 VARCHAR(180) ,
source3 VARCHAR(180) ,
statecode VARCHAR(180) ,
statepatientnumber VARCHAR(180) ,
statuschangedate VARCHAR(180) ,
typeoftransmission VARCHAR(180)
);
{ "Country": "Afghanistan", "CountryCode": "AF", "Province": "", "City": "", "CityCode": "", "Lat": "33.94", "Lon": "67.71", "Confirmed": 0, "Deaths": 0, "Recovered": 0, "Active": 0, "Date": "2020-01-22T00:00:00Z" }
private String country; private String countrycode; private String province; private String city; private String citycode; private String lat; private String lon; private String confirmed; private String deaths; private String recovered; private String active; private String date;