covid19

*COVID Covid Anlaytics project

https://www.covid19india.org/

https://github.com/covid19india/covid19india-react

https://api.covid19india.org/raw_data3.json (API)

https://documenter.getpostman.com/view/10808728/SzS8rjbc?version=latest#81415d42-eb53-4a85-8484-42d2349debfe

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;