johns_hopkins_csse_daily_reports

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

1,356 rows where country_or_region = "India" sorted by day descending

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Link	rowid	day ▲	country_or_region	province_or_state	confirmed	deaths	recovered	active	latitude	longitude	last_update	combined_key
180826	180826	2020-07-13	India	Andaman and Nicobar Islands	166	0	109	57	11.225999	92.96817800000001	2020-07-14 04:34:46	Andaman and Nicobar Islands, India
180827	180827	2020-07-13	India	Andhra Pradesh	31103	365	16464	14274	15.9129	79.74	2020-07-14 04:34:46	Andhra Pradesh, India
180841	180841	2020-07-13	India	Arunachal Pradesh	387	2	145	240	27.768456	96.384277	2020-07-14 04:34:46	Arunachal Pradesh, India
180842	180842	2020-07-13	India	Assam	16806	36	10894	5876	26.357149	92.83044100000001	2020-07-14 04:34:46	Assam, India
180864	180864	2020-07-13	India	Bihar	17959	160	12317	5482	25.679658	85.60484	2020-07-14 04:34:46	Bihar, India
180896	180896	2020-07-13	India	Chandigarh	588	8	423	157	30.733839	76.76827800000002	2020-07-14 04:34:46	Chandigarh, India
180903	180903	2020-07-13	India	Chhattisgarh	4217	19	3202	996	21.264705	82.035366	2020-07-14 04:34:46	Chhattisgarh, India
180920	180920	2020-07-13	India	Dadra and Nagar Haveli and Daman and Diu	495	1	268	226	20.194742	73.080901	2020-07-14 04:34:46	Dadra and Nagar Haveli and Daman and Diu, India
180923	180923	2020-07-13	India	Delhi	113740	3411	91312	19017	28.646519	77.10898	2020-07-14 04:34:46	Delhi, India
180950	180950	2020-07-13	India	Goa	2583	17	1540	1026	15.359682000000001	74.057396	2020-07-14 04:34:46	Goa, India
180964	180964	2020-07-13	India	Gujarat	42722	2055	29770	10897	22.694884	71.590923	2020-07-14 04:34:46	Gujarat, India
180969	180969	2020-07-13	India	Haryana	21894	308	16602	4984	29.20004	76.332824	2020-07-14 04:34:46	Haryana, India
180975	180975	2020-07-13	India	Himachal Pradesh	1243	11	940	292	31.927213000000002	77.233081	2020-07-14 04:34:46	Himachal Pradesh, India
180996	180996	2020-07-13	India	Jammu and Kashmir	10827	187	6095	4545	33.75943	76.612638	2020-07-14 04:34:46	Jammu and Kashmir, India
180999	180999	2020-07-13	India	Jharkhand	3898	33	2351	1514	23.654536	85.557631	2020-07-14 04:34:46	Jharkhand, India
181016	181016	2020-07-13	India	Karnataka	41581	757	16248	24576	14.705179999999999	76.166436	2020-07-14 04:34:46	Karnataka, India
181018	181018	2020-07-13	India	Kerala	8322	33	4257	4032	10.450898	76.405749	2020-07-14 04:34:46	Kerala, India
181043	181043	2020-07-13	India	Ladakh	1093	1	946	146	34.1526	77.5771	2020-07-14 04:34:46	Ladakh, India
181058	181058	2020-07-13	India	Madhya Pradesh	18207	663	13208	4336	23.541513000000002	78.289633	2020-07-14 04:34:46	Madhya Pradesh, India
181064	181064	2020-07-13	India	Maharashtra	260924	10482	144507	105935	19.449759	76.108221	2020-07-14 04:34:46	Maharashtra, India
181065	181065	2020-07-13	India	Manipur	1626	0	970	656	24.738975	93.882541	2020-07-14 04:34:46	Manipur, India
181076	181076	2020-07-13	India	Meghalaya	318	2	66	250	25.536934	91.278882	2020-07-14 04:34:46	Meghalaya, India
181086	181086	2020-07-13	India	Mizoram	233	0	151	82	23.309381	92.83821999999999	2020-07-14 04:34:46	Mizoram, India
181097	181097	2020-07-13	India	Nagaland	845	0	340	505	26.06702	94.470302	2020-07-14 04:34:46	Nagaland, India
181129	181129	2020-07-13	India	Odisha	13737	70	9255	4412	20.505428	84.418059	2020-07-14 04:34:46	Odisha, India
181158	181158	2020-07-13	India	Puducherry	1468	18	785	665	11.882658000000001	78.86498	2020-07-14 04:34:46	Puducherry, India
181162	181162	2020-07-13	India	Punjab	8178	204	5586	2388	30.841465000000003	75.40879	2020-07-14 04:34:46	Punjab, India
181172	181172	2020-07-13	India	Rajasthan	24936	525	18630	5781	26.583423	73.847973	2020-07-14 04:34:46	Rajasthan, India
181218	181218	2020-07-13	India	Sikkim	192	0	86	106	27.571671000000002	88.472712	2020-07-14 04:34:46	Sikkim, India
181237	181237	2020-07-13	India	Tamil Nadu	142798	2032	92567	48199	11.006091	78.400624	2020-07-14 04:34:46	Tamil Nadu, India
181241	181241	2020-07-13	India	Telangana	36221	365	23679	12177	18.1124	79.0193	2020-07-14 04:34:46	Telangana, India
181256	181256	2020-07-13	India	Tripura	2080	2	1475	603	23.746782999999997	91.743565	2020-07-14 04:34:46	Tripura, India
181270	181270	2020-07-13	India	Unknown	2179	0	0	2179			2020-07-14 04:34:46	Unknown, India
181276	181276	2020-07-13	India	Uttar Pradesh	38130	955	24203	12972	26.925425	80.560982	2020-07-14 04:34:46	Uttar Pradesh, India
181277	181277	2020-07-13	India	Uttarakhand	3608	49	2856	703	30.156446999999996	79.197608	2020-07-14 04:34:46	Uttarakhand, India
181300	181300	2020-07-13	India	West Bengal	31448	956	19213	11279	23.814082	87.979803	2020-07-14 04:34:46	West Bengal, India
321531	321531	2020-07-12	India	Andaman and Nicobar Islands	163	0	93	70	11.225999	92.96817800000001	2020-07-13 04:43:04	Andaman and Nicobar Islands, India
321532	321532	2020-07-12	India	Andhra Pradesh	29168	328	15412	13428	15.9129	79.74	2020-07-13 04:43:04	Andhra Pradesh, India
321546	321546	2020-07-12	India	Arunachal Pradesh	359	2	138	219	27.768456	96.384277	2020-07-13 04:43:04	Arunachal Pradesh, India
321547	321547	2020-07-12	India	Assam	16071	35	10426	5610	26.357149	92.83044100000001	2020-07-13 04:43:04	Assam, India
321569	321569	2020-07-12	India	Bihar	16642	143	11498	5001	25.679658	85.60484	2020-07-13 04:43:04	Bihar, India
321601	321601	2020-07-12	India	Chandigarh	559	8	417	134	30.733839	76.76827800000002	2020-07-13 04:43:04	Chandigarh, India
321608	321608	2020-07-12	India	Chhattisgarh	4059	19	3153	887	21.264705	82.035366	2020-07-13 04:43:04	Chhattisgarh, India
321625	321625	2020-07-12	India	Dadra and Nagar Haveli and Daman and Diu	479	0	245	234	20.194742	73.080901	2020-07-13 04:43:04	Dadra and Nagar Haveli and Daman and Diu, India
321628	321628	2020-07-12	India	Delhi	112494	3371	89968	19155	28.646519	77.10898	2020-07-13 04:43:04	Delhi, India
321655	321655	2020-07-12	India	Goa	2453	14	1487	952	15.359682000000001	74.057396	2020-07-13 04:43:04	Goa, India
321670	321670	2020-07-12	India	Gujarat	41820	2045	29162	10613	22.694884	71.590923	2020-07-13 04:43:04	Gujarat, India
321675	321675	2020-07-12	India	Haryana	21240	301	15983	4956	29.20004	76.332824	2020-07-13 04:43:04	Haryana, India
321681	321681	2020-07-12	India	Himachal Pradesh	1213	11	929	273	31.927213000000002	77.233081	2020-07-13 04:43:04	Himachal Pradesh, India
321702	321702	2020-07-12	India	Jammu and Kashmir	10513	179	5979	4355	33.75943	76.612638	2020-07-13 04:43:04	Jammu and Kashmir, India
321705	321705	2020-07-12	India	Jharkhand	3756	30	2308	1418	23.654536	85.557631	2020-07-13 04:43:04	Jharkhand, India
321722	321722	2020-07-12	India	Karnataka	38843	684	15409	22750	14.705179999999999	76.166436	2020-07-13 04:43:04	Karnataka, India
321724	321724	2020-07-12	India	Kerala	7873	31	4095	3747	10.450898	76.405749	2020-07-13 04:43:04	Kerala, India
321749	321749	2020-07-12	India	Ladakh	1086	1	928	157	34.1526	77.5771	2020-07-13 04:43:04	Ladakh, India
321764	321764	2020-07-12	India	Madhya Pradesh	17632	653	12876	4103	23.541513000000002	78.289633	2020-07-13 04:43:04	Madhya Pradesh, India
321770	321770	2020-07-12	India	Maharashtra	254427	10289	140325	103813	19.449759	76.108221	2020-07-13 04:43:04	Maharashtra, India
321771	321771	2020-07-12	India	Manipur	1609	0	896	713	24.738975	93.882541	2020-07-13 04:43:04	Manipur, India
321782	321782	2020-07-12	India	Meghalaya	306	2	66	238	25.536934	91.278882	2020-07-13 04:43:04	Meghalaya, India
321792	321792	2020-07-12	India	Mizoram	231	0	150	81	23.309381	92.83821999999999	2020-07-13 04:43:04	Mizoram, India
321803	321803	2020-07-12	India	Nagaland	774	0	327	447	26.06702	94.470302	2020-07-13 04:43:04	Nagaland, India
321835	321835	2020-07-12	India	Odisha	13121	64	8750	4307	20.505428	84.418059	2020-07-13 04:43:04	Odisha, India
321864	321864	2020-07-12	India	Puducherry	1418	18	739	661	11.882658000000001	78.86498	2020-07-13 04:43:04	Puducherry, India
321868	321868	2020-07-12	India	Punjab	7821	199	5392	2230	30.841465000000003	75.40879	2020-07-13 04:43:04	Punjab, India
321878	321878	2020-07-12	India	Rajasthan	24392	510	18103	5779	26.583423	73.847973	2020-07-13 04:43:04	Rajasthan, India
321924	321924	2020-07-12	India	Sikkim	153	0	81	72	27.571671000000002	88.472712	2020-07-13 04:43:04	Sikkim, India
321943	321943	2020-07-12	India	Tamil Nadu	138470	1966	89532	46972	11.006091	78.400624	2020-07-13 04:43:04	Tamil Nadu, India
321947	321947	2020-07-12	India	Telangana	34671	356	22482	11833	18.1124	79.0193	2020-07-13 04:43:04	Telangana, India
321962	321962	2020-07-12	India	Tripura	2054	2	1421	631	23.746782999999997	91.743565	2020-07-13 04:43:04	Tripura, India
321976	321976	2020-07-12	India	Unknown	2358	0	0	2358			2020-07-13 04:43:04	Unknown, India
321982	321982	2020-07-12	India	Uttar Pradesh	36476	934	23334	12208	26.925425	80.560982	2020-07-13 04:43:04	Uttar Pradesh, India
321983	321983	2020-07-12	India	Uttarakhand	3537	47	2786	704	30.156446999999996	79.197608	2020-07-13 04:43:04	Uttarakhand, India
322006	322006	2020-07-12	India	West Bengal	30013	932	18581	10500	23.814082	87.979803	2020-07-13 04:43:04	West Bengal, India
274923	274923	2020-07-11	India	Andaman and Nicobar Islands	163	0	93	70	11.225999	92.96817800000001	2020-07-12 04:34:30	Andaman and Nicobar Islands, India
274924	274924	2020-07-11	India	Andhra Pradesh	27235	309	14393	12533	15.9129	79.74	2020-07-12 04:34:30	Andhra Pradesh, India
274938	274938	2020-07-11	India	Arunachal Pradesh	341	2	125	214	27.768456	96.384277	2020-07-12 04:34:30	Arunachal Pradesh, India
274939	274939	2020-07-11	India	Assam	15536	35	9150	6351	26.357149	92.83044100000001	2020-07-12 04:34:30	Assam, India
274961	274961	2020-07-11	India	Bihar	15373	131	10685	4557	25.679658	85.60484	2020-07-12 04:34:30	Bihar, India
274993	274993	2020-07-11	India	Chandigarh	555	7	413	135	30.733839	76.76827800000002	2020-07-12 04:34:30	Chandigarh, India
275000	275000	2020-07-11	India	Chhattisgarh	3897	17	3070	810	21.264705	82.035366	2020-07-12 04:34:30	Chhattisgarh, India
275017	275017	2020-07-11	India	Dadra and Nagar Haveli and Daman and Diu	471	0	226	245	20.194742	73.080901	2020-07-12 04:34:30	Dadra and Nagar Haveli and Daman and Diu, India
275020	275020	2020-07-11	India	Delhi	110921	3334	87692	19895	28.646519	77.10898	2020-07-12 04:34:30	Delhi, India
275047	275047	2020-07-11	India	Goa	2368	12	1428	928	15.359682000000001	74.057396	2020-07-12 04:34:30	Goa, India
275062	275062	2020-07-11	India	Gujarat	40941	2032	28649	10260	22.694884	71.590923	2020-07-12 04:34:30	Gujarat, India
275067	275067	2020-07-11	India	Haryana	20582	297	15394	4891	29.20004	76.332824	2020-07-12 04:34:30	Haryana, India
275073	275073	2020-07-11	India	Himachal Pradesh	1182	11	908	263	31.927213000000002	77.233081	2020-07-12 04:34:30	Himachal Pradesh, India
275094	275094	2020-07-11	India	Jammu and Kashmir	10156	169	5895	4092	33.75943	76.612638	2020-07-12 04:34:30	Jammu and Kashmir, India
275097	275097	2020-07-11	India	Jharkhand	3613	23	2243	1347	23.654536	85.557631	2020-07-12 04:34:30	Jharkhand, India
275114	275114	2020-07-11	India	Karnataka	36216	613	14716	20887	14.705179999999999	76.166436	2020-07-12 04:34:30	Karnataka, India
275116	275116	2020-07-11	India	Kerala	7438	29	3963	3446	10.450898	76.405749	2020-07-12 04:34:30	Kerala, India
275141	275141	2020-07-11	India	Ladakh	1077	1	928	148	34.1526	77.5771	2020-07-12 04:34:30	Ladakh, India
275156	275156	2020-07-11	India	Madhya Pradesh	17201	644	12679	3878	23.541513000000002	78.289633	2020-07-12 04:34:30	Madhya Pradesh, India
275162	275162	2020-07-11	India	Maharashtra	246600	10116	136985	99499	19.449759	76.108221	2020-07-12 04:34:30	Maharashtra, India
275163	275163	2020-07-11	India	Manipur	1593	0	843	750	24.738975	93.882541	2020-07-12 04:34:30	Manipur, India
275174	275174	2020-07-11	India	Meghalaya	207	2	66	139	25.536934	91.278882	2020-07-12 04:34:30	Meghalaya, India
275184	275184	2020-07-11	India	Mizoram	227	0	150	77	23.309381	92.83821999999999	2020-07-12 04:34:30	Mizoram, India
275195	275195	2020-07-11	India	Nagaland	748	0	313	435	26.06702	94.470302	2020-07-12 04:34:30	Nagaland, India
275227	275227	2020-07-11	India	Odisha	12526	61	8360	4105	20.505428	84.418059	2020-07-12 04:34:30	Odisha, India
275256	275256	2020-07-11	India	Puducherry	1337	18	690	629	11.882658000000001	78.86498	2020-07-12 04:34:30	Puducherry, India
275260	275260	2020-07-11	India	Punjab	7587	195	5040	2352	30.841465000000003	75.40879	2020-07-12 04:34:30	Punjab, India
275270	275270	2020-07-11	India	Rajasthan	23748	503	17869	5376	26.583423	73.847973	2020-07-12 04:34:30	Rajasthan, India

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE [johns_hopkins_csse_daily_reports] (
   [day] TEXT,
   [country_or_region] TEXT,
   [province_or_state] TEXT,
   [admin2] TEXT,
   [fips] TEXT,
   [confirmed] INTEGER,
   [deaths] INTEGER,
   [recovered] INTEGER,
   [active] INTEGER,
   [latitude] TEXT,
   [longitude] TEXT,
   [last_update] TEXT,
   [combined_key] TEXT
);