johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
19 rows where country_or_region = "India" and deaths = 222 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 5
- Ladakh 15
- Chandigarh 1
- Jammu and Kashmir 1
- Mizoram 1
- Tripura 1
country_or_region 1
- India · 19 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1227551 | 1227551 | 2022-01-24 | India | Ladakh | 24818 | 222 | 0 | 34.1526 | 77.5771 | 2022-01-25 04:21:05 | Ladakh, India | |||
1140850 | 1140850 | 2022-01-23 | India | Ladakh | 24655 | 222 | 0 | 34.1526 | 77.5771 | 2022-01-24 04:21:12 | Ladakh, India | |||
2832768 | 2832768 | 2022-01-22 | India | Ladakh | 24496 | 222 | 0 | 34.1526 | 77.5771 | 2022-01-23 04:21:13 | Ladakh, India | |||
3424886 | 3424886 | 2022-01-21 | India | Ladakh | 24213 | 222 | 0 | 34.1526 | 77.5771 | 2022-01-22 04:21:13 | Ladakh, India | |||
1960494 | 1960494 | 2022-01-20 | India | Ladakh | 24034 | 222 | 0 | 34.1526 | 77.5771 | 2022-01-21 04:21:09 | Ladakh, India | |||
3226389 | 3226389 | 2022-01-19 | India | Ladakh | 23885 | 222 | 0 | 34.1526 | 77.5771 | 2022-01-20 04:21:07 | Ladakh, India | |||
3464114 | 3464114 | 2022-01-18 | India | Ladakh | 23700 | 222 | 0 | 34.1526 | 77.5771 | 2022-01-19 04:21:23 | Ladakh, India | |||
1472053 | 1472053 | 2022-01-17 | India | Ladakh | 23536 | 222 | 0 | 34.1526 | 77.5771 | 2022-01-18 04:21:04 | Ladakh, India | |||
554727 | 554727 | 2022-01-16 | India | Ladakh | 23384 | 222 | 0 | 34.1526 | 77.5771 | 2022-01-17 04:21:08 | Ladakh, India | |||
3840448 | 3840448 | 2022-01-15 | India | Ladakh | 23209 | 222 | 0 | 34.1526 | 77.5771 | 2022-01-16 04:21:12 | Ladakh, India | |||
99263 | 99263 | 2022-01-14 | India | Ladakh | 23079 | 222 | 0 | 34.1526 | 77.5771 | 2022-01-15 04:21:07 | Ladakh, India | |||
3687418 | 3687418 | 2022-01-13 | India | Ladakh | 22849 | 222 | 0 | 34.1526 | 77.5771 | 2022-01-14 04:21:54 | Ladakh, India | |||
3613002 | 3613002 | 2022-01-12 | India | Ladakh | 22849 | 222 | 0 | 34.1526 | 77.5771 | 2022-01-13 08:00:09 | Ladakh, India | |||
1113527 | 1113527 | 2022-01-11 | India | Ladakh | 22686 | 222 | 0 | 34.1526 | 77.5771 | 2022-01-12 04:21:44 | Ladakh, India | |||
1692255 | 1692255 | 2022-01-10 | India | Ladakh | 22686 | 222 | 0 | 34.1526 | 77.5771 | 2022-01-11 04:22:01 | Ladakh, India | |||
249242 | 249242 | 2021-09-04 | India | Mizoram | 63784 | 222 | 0 | 23.309381 | 92.83821999999999 | 2021-09-05 04:21:33 | Mizoram, India | |||
3480252 | 3480252 | 2020-10-26 | India | Chandigarh | 14085 | 222 | 13230 | 633 | 30.733839 | 76.76827800000002 | 2020-10-27 04:24:45 | Chandigarh, India | ||
666246 | 666246 | 2020-09-16 | India | Tripura | 20676 | 222 | 12956 | 7498 | 23.746783 | 91.743565 | 2020-09-17 04:22:00 | Tripura, India | ||
367361 | 367361 | 2020-07-16 | India | Jammu and Kashmir | 12156 | 222 | 6446 | 5488 | 33.75943 | 76.612638 | 2020-07-17 04:34:50 | Jammu and Kashmir, 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]);