johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
15 rows where active = 24 and country_or_region = "India" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, longitude, combined_key
province_or_state 5
country_or_region 1
- India · 15 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3015293 | 3015293 | 2021-08-01 | India | Dadra and Nagar Haveli and Daman and Diu | 10650 | 4 | 10622 | 24 | 20.194742 | 73.080901 | 2021-08-02 04:21:36 | Dadra and Nagar Haveli and Daman and Diu, India | ||
483533 | 483533 | 2021-07-19 | India | Dadra and Nagar Haveli and Daman and Diu | 10605 | 4 | 10577 | 24 | 20.194742 | 73.080901 | 2021-07-20 04:21:48 | Dadra and Nagar Haveli and Daman and Diu, India | ||
1980575 | 1980575 | 2021-03-25 | India | Mizoram | 4460 | 11 | 4425 | 24 | 23.309381 | 92.83822 | 2021-03-26 05:26:55 | Mizoram, India | ||
3420876 | 3420876 | 2021-03-19 | India | Manipur | 29326 | 373 | 28929 | 24 | 24.738975 | 93.882541 | 2021-03-20 05:25:46 | Manipur, India | ||
702362 | 702362 | 2021-03-16 | India | Manipur | 29315 | 373 | 28918 | 24 | 24.738975 | 93.882541 | 2021-03-17 05:25:07 | Manipur, India | ||
2055840 | 2055840 | 2021-03-15 | India | Manipur | 29313 | 373 | 28916 | 24 | 24.738975 | 93.882541 | 2021-03-16 05:25:13 | Manipur, India | ||
1837874 | 1837874 | 2021-03-12 | India | Dadra and Nagar Haveli and Daman and Diu | 3431 | 2 | 3405 | 24 | 20.194742 | 73.080901 | 2021-03-13 05:25:15 | Dadra and Nagar Haveli and Daman and Diu, India | ||
3663576 | 3663576 | 2021-03-09 | India | Tripura | 33425 | 391 | 33010 | 24 | 23.746783 | 91.743565 | 2021-03-10 05:24:35 | Tripura, India | ||
1936410 | 1936410 | 2021-02-23 | India | Mizoram | 4413 | 10 | 4379 | 24 | 23.309381 | 92.83822 | 2021-02-24 05:29:16 | Mizoram, India | ||
471371 | 471371 | 2021-02-19 | India | Mizoram | 4407 | 10 | 4373 | 24 | 23.309381 | 92.83822 | 2021-02-20 05:22:51 | Mizoram, India | ||
613647 | 613647 | 2021-02-08 | India | Mizoram | 4386 | 9 | 4353 | 24 | 23.309381 | 92.83822 | 2021-02-09 05:23:30 | Mizoram, India | ||
1672416 | 1672416 | 2021-02-07 | India | Mizoram | 4383 | 9 | 4350 | 24 | 23.309381 | 92.83822 | 2021-02-08 05:22:39 | Mizoram, India | ||
12308 | 12308 | 2021-01-26 | India | Tripura | 33346 | 391 | 32931 | 24 | 23.746783 | 91.743565 | 2021-01-27 05:23:41 | Tripura, India | ||
2426839 | 2426839 | 2021-01-23 | India | Andaman and Nicobar Islands | 4993 | 62 | 4907 | 24 | 11.225999 | 92.968178 | 2021-01-24 05:22:35 | Andaman and Nicobar Islands, India | ||
3899896 | 3899896 | 2021-01-09 | India | Andaman and Nicobar Islands | 4959 | 62 | 4873 | 24 | 11.225999 | 92.968178 | 2021-01-10 05:22:12 | Andaman and Nicobar Islands, 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]);