johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
49 rows where active = 4 and country_or_region = "India" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 6
country_or_region 1
- India · 49 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
331842 | 331842 | 2021-08-04 | India | Andaman and Nicobar Islands | 7541 | 129 | 7408 | 4 | 11.225999 | 92.968178 | 2021-08-05 04:21:51 | Andaman and Nicobar Islands, India | ||
1301990 | 1301990 | 2021-04-01 | India | Arunachal Pradesh | 16845 | 56 | 16785 | 4 | 27.768456 | 96.384277 | 2021-04-02 04:20:36 | Arunachal Pradesh, India | ||
637862 | 637862 | 2021-03-31 | India | Arunachal Pradesh | 16845 | 56 | 16785 | 4 | 27.768456 | 96.384277 | 2021-04-01 04:27:05 | Arunachal Pradesh, India | ||
3643491 | 3643491 | 2021-03-30 | India | Arunachal Pradesh | 16845 | 56 | 16785 | 4 | 27.768456 | 96.384277 | 2021-03-31 04:26:25 | Arunachal Pradesh, India | ||
1289944 | 1289944 | 2021-03-29 | India | Arunachal Pradesh | 16845 | 56 | 16785 | 4 | 27.768456 | 96.384277 | 2021-03-30 04:26:23 | Arunachal Pradesh, India | ||
1535866 | 1535866 | 2021-03-28 | India | Arunachal Pradesh | 16845 | 56 | 16785 | 4 | 27.768456 | 96.384277 | 2021-03-29 04:28:35 | Arunachal Pradesh, India | ||
1535888 | 1535888 | 2021-03-28 | India | Nagaland | 12230 | 92 | 12134 | 4 | 26.06702 | 94.470302 | 2021-03-29 04:28:35 | Nagaland, India | ||
1219506 | 1219506 | 2021-03-27 | India | Arunachal Pradesh | 16845 | 56 | 16785 | 4 | 27.768456 | 96.384277 | 2021-03-28 05:28:10 | Arunachal Pradesh, India | ||
1219528 | 1219528 | 2021-03-27 | India | Nagaland | 12229 | 92 | 12133 | 4 | 26.06702 | 94.470302 | 2021-03-28 05:28:10 | Nagaland, India | ||
1880946 | 1880946 | 2021-03-26 | India | Nagaland | 12229 | 92 | 12133 | 4 | 26.06702 | 94.470302 | 2021-03-27 05:25:04 | Nagaland, India | ||
1980576 | 1980576 | 2021-03-25 | India | Nagaland | 12229 | 92 | 12133 | 4 | 26.06702 | 94.470302 | 2021-03-26 05:26:55 | Nagaland, India | ||
1580088 | 1580088 | 2021-03-13 | India | Andaman and Nicobar Islands | 5030 | 62 | 4964 | 4 | 11.225999 | 92.968178 | 2021-03-14 05:25:37 | Andaman and Nicobar Islands, India | ||
1837869 | 1837869 | 2021-03-12 | India | Arunachal Pradesh | 16840 | 56 | 16780 | 4 | 27.768456 | 96.384277 | 2021-03-13 05:25:15 | Arunachal Pradesh, India | ||
352234 | 352234 | 2021-03-11 | India | Arunachal Pradesh | 16840 | 56 | 16780 | 4 | 27.768456 | 96.384277 | 2021-03-12 05:26:50 | Arunachal Pradesh, India | ||
3962458 | 3962458 | 2021-03-10 | India | Arunachal Pradesh | 16840 | 56 | 16780 | 4 | 27.768456 | 96.384277 | 2021-03-11 05:25:48 | Arunachal Pradesh, India | ||
998382 | 998382 | 2021-03-01 | India | Dadra and Nagar Haveli and Daman and Diu | 3406 | 2 | 3400 | 4 | 20.194742 | 73.080901 | 2021-03-02 05:23:30 | Dadra and Nagar Haveli and Daman and Diu, India | ||
2367440 | 2367440 | 2021-02-28 | India | Dadra and Nagar Haveli and Daman and Diu | 3406 | 2 | 3400 | 4 | 20.194742 | 73.080901 | 2021-03-01 05:23:01 | Dadra and Nagar Haveli and Daman and Diu, India | ||
3065935 | 3065935 | 2021-02-27 | India | Andaman and Nicobar Islands | 5018 | 62 | 4952 | 4 | 11.225999 | 92.968178 | 2021-02-28 05:22:20 | Andaman and Nicobar Islands, India | ||
3065942 | 3065942 | 2021-02-27 | India | Dadra and Nagar Haveli and Daman and Diu | 3406 | 2 | 3400 | 4 | 20.194742 | 73.080901 | 2021-02-28 05:22:20 | Dadra and Nagar Haveli and Daman and Diu, India | ||
2183526 | 2183526 | 2021-02-26 | India | Dadra and Nagar Haveli and Daman and Diu | 3406 | 2 | 3400 | 4 | 20.194742 | 73.080901 | 2021-02-27 05:22:28 | Dadra and Nagar Haveli and Daman and Diu, India | ||
280119 | 280119 | 2021-02-24 | India | Andaman and Nicobar Islands | 5016 | 62 | 4950 | 4 | 11.225999 | 92.968178 | 2021-02-25 05:24:57 | Andaman and Nicobar Islands, India | ||
280121 | 280121 | 2021-02-24 | India | Arunachal Pradesh | 16836 | 56 | 16776 | 4 | 27.768456 | 96.384277 | 2021-02-25 05:24:57 | Arunachal Pradesh, India | ||
280126 | 280126 | 2021-02-24 | India | Dadra and Nagar Haveli and Daman and Diu | 3404 | 2 | 3398 | 4 | 20.194742 | 73.080901 | 2021-02-25 05:24:57 | Dadra and Nagar Haveli and Daman and Diu, India | ||
1936389 | 1936389 | 2021-02-23 | India | Arunachal Pradesh | 16836 | 56 | 16776 | 4 | 27.768456 | 96.384277 | 2021-02-24 05:29:16 | Arunachal Pradesh, India | ||
530642 | 530642 | 2021-02-22 | India | Andaman and Nicobar Islands | 5015 | 62 | 4949 | 4 | 11.225999 | 92.968178 | 2021-02-23 05:23:41 | Andaman and Nicobar Islands, India | ||
530649 | 530649 | 2021-02-22 | India | Dadra and Nagar Haveli and Daman and Diu | 3402 | 2 | 3396 | 4 | 20.194742 | 73.080901 | 2021-02-23 05:23:41 | Dadra and Nagar Haveli and Daman and Diu, India | ||
181983 | 181983 | 2021-02-21 | India | Dadra and Nagar Haveli and Daman and Diu | 3402 | 2 | 3396 | 4 | 20.194742 | 73.080901 | 2021-02-22 05:24:21 | Dadra and Nagar Haveli and Daman and Diu, India | ||
742257 | 742257 | 2021-02-20 | India | Dadra and Nagar Haveli and Daman and Diu | 3402 | 2 | 3396 | 4 | 20.194742 | 73.080901 | 2021-02-21 05:24:33 | Dadra and Nagar Haveli and Daman and Diu, India | ||
471348 | 471348 | 2021-02-19 | India | Andaman and Nicobar Islands | 5014 | 62 | 4948 | 4 | 11.225999 | 92.968178 | 2021-02-20 05:22:51 | Andaman and Nicobar Islands, India | ||
471355 | 471355 | 2021-02-19 | India | Dadra and Nagar Haveli and Daman and Diu | 3402 | 2 | 3396 | 4 | 20.194742 | 73.080901 | 2021-02-20 05:22:51 | Dadra and Nagar Haveli and Daman and Diu, India | ||
1153064 | 1153064 | 2021-02-18 | India | Dadra and Nagar Haveli and Daman and Diu | 3402 | 2 | 3396 | 4 | 20.194742 | 73.080901 | 2021-02-19 05:24:16 | Dadra and Nagar Haveli and Daman and Diu, India | ||
3600984 | 3600984 | 2021-02-17 | India | Dadra and Nagar Haveli and Daman and Diu | 3402 | 2 | 3396 | 4 | 20.194742 | 73.080901 | 2021-02-18 05:22:58 | Dadra and Nagar Haveli and Daman and Diu, India | ||
3050144 | 3050144 | 2021-02-16 | India | Tripura | 33355 | 391 | 32960 | 4 | 23.746783 | 91.743565 | 2021-02-17 05:23:10 | Tripura, India | ||
2677764 | 2677764 | 2021-02-13 | India | Arunachal Pradesh | 16832 | 56 | 16772 | 4 | 27.768456 | 96.384277 | 2021-02-14 05:23:43 | Arunachal Pradesh, India | ||
3978515 | 3978515 | 2021-02-10 | India | Arunachal Pradesh | 16831 | 56 | 16771 | 4 | 27.768456 | 96.384277 | 2021-02-11 05:23:55 | Arunachal Pradesh, India | ||
1527835 | 1527835 | 2021-02-09 | India | Arunachal Pradesh | 16831 | 56 | 16771 | 4 | 27.768456 | 96.384277 | 2021-02-10 05:22:41 | Arunachal Pradesh, India | ||
790326 | 790326 | 2021-02-04 | India | Dadra and Nagar Haveli and Daman and Diu | 3398 | 2 | 3392 | 4 | 20.194742 | 73.080901 | 2021-02-05 05:22:38 | Dadra and Nagar Haveli and Daman and Diu, India | ||
340218 | 340218 | 2021-02-03 | India | Dadra and Nagar Haveli and Daman and Diu | 3398 | 2 | 3392 | 4 | 20.194742 | 73.080901 | 2021-02-04 05:22:26 | Dadra and Nagar Haveli and Daman and Diu, India | ||
1684444 | 1684444 | 2021-02-02 | India | Dadra and Nagar Haveli and Daman and Diu | 3398 | 2 | 3392 | 4 | 20.194742 | 73.080901 | 2021-02-03 05:22:52 | Dadra and Nagar Haveli and Daman and Diu, India | ||
1459695 | 1459695 | 2021-01-31 | India | Andaman and Nicobar Islands | 4994 | 62 | 4928 | 4 | 11.225999 | 92.968178 | 2021-02-01 05:22:53 | Andaman and Nicobar Islands, India | ||
2211603 | 2211603 | 2021-01-30 | India | Andaman and Nicobar Islands | 4994 | 62 | 4928 | 4 | 11.225999 | 92.968178 | 2021-01-31 05:22:42 | Andaman and Nicobar Islands, India | ||
3308146 | 3308146 | 2021-01-13 | India | Dadra and Nagar Haveli and Daman and Diu | 3383 | 2 | 3377 | 4 | 20.194742 | 73.080901 | 2021-01-14 05:22:32 | Dadra and Nagar Haveli and Daman and Diu, India | ||
774291 | 774291 | 2021-01-12 | India | Dadra and Nagar Haveli and Daman and Diu | 3382 | 2 | 3376 | 4 | 20.194742 | 73.080901 | 2021-01-13 05:22:15 | Dadra and Nagar Haveli and Daman and Diu, India | ||
190012 | 190012 | 2021-01-11 | India | Dadra and Nagar Haveli and Daman and Diu | 3382 | 2 | 3376 | 4 | 20.194742 | 73.080901 | 2021-01-12 05:22:15 | Dadra and Nagar Haveli and Daman and Diu, India | ||
3899903 | 3899903 | 2021-01-09 | India | Dadra and Nagar Haveli and Daman and Diu | 3380 | 2 | 3374 | 4 | 20.194742 | 73.080901 | 2021-01-10 05:22:12 | Dadra and Nagar Haveli and Daman and Diu, India | ||
2632948 | 2632948 | 2020-06-29 | India | Meghalaya | 47 | 1 | 42 | 4 | 25.536934 | 91.278882 | 2020-06-30 04:33:48 | Meghalaya, India | ||
2306511 | 2306511 | 2020-06-28 | India | Meghalaya | 47 | 1 | 42 | 4 | 25.536934 | 91.278882 | 2020-06-29 04:33:44 | Meghalaya, India | ||
2039846 | 2039846 | 2020-06-27 | India | Meghalaya | 47 | 1 | 42 | 4 | 25.536934 | 91.278882 | 2020-06-28 04:34:04 | Meghalaya, India | ||
1136127 | 1136127 | 2020-06-26 | India | Meghalaya | 47 | 1 | 42 | 4 | 25.536934 | 91.278882 | 2020-06-27 04:33:35 | Meghalaya, 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] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);