johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
20 rows where active = 41 and country_or_region = "India" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, recovered, latitude, last_update (date)
province_or_state 10
country_or_region 1
- India · 20 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
408237 | 408237 | 2021-07-28 | India | Dadra and Nagar Haveli and Daman and Diu | 10642 | 4 | 10597 | 41 | 20.194742 | 73.080901 | 2021-07-29 04:21:33 | Dadra and Nagar Haveli and Daman and Diu, India | ||
3331471 | 3331471 | 2021-07-21 | India | Chandigarh | 61914 | 809 | 61064 | 41 | 30.733839 | 76.76827800000002 | 2021-07-22 04:21:19 | Chandigarh, India | ||
1495545 | 1495545 | 2021-07-03 | India | Dadra and Nagar Haveli and Daman and Diu | 10567 | 4 | 10522 | 41 | 20.194742 | 73.080901 | 2021-07-04 04:21:38 | Dadra and Nagar Haveli and Daman and Diu, India | ||
36368 | 36368 | 2021-04-12 | India | Arunachal Pradesh | 16888 | 56 | 16791 | 41 | 27.768456 | 96.384277 | 2021-04-13 04:20:37 | Arunachal Pradesh, India | ||
388182 | 388182 | 2021-04-04 | India | Mizoram | 4491 | 11 | 4439 | 41 | 23.309381 | 92.83822 | 2021-04-05 04:20:35 | Mizoram, India | ||
241191 | 241191 | 2021-04-02 | India | Andaman and Nicobar Islands | 5084 | 62 | 4981 | 41 | 11.225999 | 92.968178 | 2021-04-03 04:20:44 | Andaman and Nicobar Islands, India | ||
1880951 | 1880951 | 2021-03-26 | India | Sikkim | 6215 | 135 | 6039 | 41 | 27.571671 | 88.472712 | 2021-03-27 05:25:04 | Sikkim, India | ||
2055848 | 2055848 | 2021-03-15 | India | Sikkim | 6184 | 135 | 6008 | 41 | 27.571671 | 88.472712 | 2021-03-16 05:25:13 | Sikkim, India | ||
352249 | 352249 | 2021-03-11 | India | Ladakh | 9840 | 130 | 9669 | 41 | 34.1526 | 77.5771 | 2021-03-12 05:26:50 | Ladakh, India | ||
3065967 | 3065967 | 2021-02-27 | India | Tripura | 33417 | 391 | 32985 | 41 | 23.746783 | 91.743565 | 2021-02-28 05:22:20 | Tripura, India | ||
280140 | 280140 | 2021-02-24 | India | Manipur | 29250 | 373 | 28836 | 41 | 24.738975 | 93.882541 | 2021-02-25 05:24:57 | Manipur, India | ||
182008 | 182008 | 2021-02-21 | India | Tripura | 33394 | 391 | 32962 | 41 | 23.746783 | 91.743565 | 2021-02-22 05:24:21 | Tripura, India | ||
742282 | 742282 | 2021-02-20 | India | Tripura | 33393 | 391 | 32961 | 41 | 23.746783 | 91.743565 | 2021-02-21 05:24:33 | Tripura, India | ||
471365 | 471365 | 2021-02-19 | India | Ladakh | 9785 | 130 | 9614 | 41 | 34.1526 | 77.5771 | 2021-02-20 05:22:51 | Ladakh, India | ||
3050136 | 3050136 | 2021-02-16 | India | Nagaland | 12190 | 90 | 12059 | 41 | 26.06702 | 94.470302 | 2021-02-17 05:23:10 | Nagaland, India | ||
2481929 | 2481929 | 2021-01-28 | India | Mizoram | 4363 | 9 | 4313 | 41 | 23.309381 | 92.83822 | 2021-01-29 05:22:23 | Mizoram, India | ||
3515371 | 3515371 | 2021-01-15 | India | Tripura | 33329 | 391 | 32897 | 41 | 23.746783 | 91.743565 | 2021-01-16 05:22:40 | Tripura, India | ||
2039990 | 2039990 | 2020-06-27 | India | Sikkim | 87 | 0 | 46 | 41 | 27.571671000000002 | 88.472712 | 2020-06-28 04:34:04 | Sikkim, India | ||
737363 | 737363 | 2020-06-12 | India | Chandigarh | 332 | 5 | 286 | 41 | 30.733839 | 76.76827800000002 | 2020-06-13 03:33:14 | Chandigarh, India | ||
1273333 | 1273333 | 2020-06-11 | India | Chandigarh | 332 | 5 | 286 | 41 | 30.733839 | 76.76827800000002 | 2020-06-12 05:09:52 | Chandigarh, 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]);