johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
15 rows where country_or_region = "India" and deaths = 1084 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: recovered, latitude
province_or_state 6
- Jharkhand 6
- Assam 4
- Chandigarh 2
- Bihar 1
- Jammu and Kashmir 1
- Uttar Pradesh 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3687406 | 3687406 | 2022-01-13 | India | Chandigarh | 71303 | 1084 | 0 | 30.733839 | 76.76827800000002 | 2022-01-14 04:21:54 | Chandigarh, India | |||
3612990 | 3612990 | 2022-01-12 | India | Chandigarh | 71303 | 1084 | 0 | 30.733839 | 76.76827800000002 | 2022-01-13 08:00:09 | Chandigarh, India | |||
742264 | 742264 | 2021-02-20 | India | Jharkhand | 119565 | 1084 | 118022 | 459 | 23.654536 | 85.557631 | 2021-02-21 05:24:33 | Jharkhand, India | ||
471362 | 471362 | 2021-02-19 | India | Jharkhand | 119528 | 1084 | 117977 | 467 | 23.654536 | 85.557631 | 2021-02-20 05:22:51 | Jharkhand, India | ||
1153071 | 1153071 | 2021-02-18 | India | Jharkhand | 119477 | 1084 | 117926 | 467 | 23.654536 | 85.557631 | 2021-02-19 05:24:16 | Jharkhand, India | ||
3600991 | 3600991 | 2021-02-17 | India | Jharkhand | 119439 | 1084 | 117889 | 466 | 23.654536 | 85.557631 | 2021-02-18 05:22:58 | Jharkhand, India | ||
3050126 | 3050126 | 2021-02-16 | India | Jharkhand | 119394 | 1084 | 117850 | 460 | 23.654536 | 85.557631 | 2021-02-17 05:23:10 | Jharkhand, India | ||
1338225 | 1338225 | 2021-02-15 | India | Jharkhand | 119354 | 1084 | 117806 | 464 | 23.654536 | 85.557631 | 2021-02-16 05:24:38 | Jharkhand, India | ||
1672396 | 1672396 | 2021-02-07 | India | Assam | 217210 | 1084 | 214447 | 1679 | 26.357149 | 92.830441 | 2021-02-08 05:22:39 | Assam, India | ||
974857 | 974857 | 2021-02-06 | India | Assam | 217202 | 1084 | 214423 | 1695 | 26.357149 | 92.830441 | 2021-02-07 05:23:00 | Assam, India | ||
1588115 | 1588115 | 2021-02-05 | India | Assam | 217193 | 1084 | 214403 | 1706 | 26.357149 | 92.830441 | 2021-02-06 05:23:55 | Assam, India | ||
790322 | 790322 | 2021-02-04 | India | Assam | 217186 | 1084 | 214374 | 1728 | 26.357149 | 92.830441 | 2021-02-05 05:22:38 | Assam, India | ||
2243325 | 2243325 | 2020-10-30 | India | Bihar | 215327 | 1084 | 206346 | 7897 | 25.679658 | 85.60484 | 2020-10-31 04:24:44 | Bihar, India | ||
2605975 | 2605975 | 2020-09-24 | India | Jammu and Kashmir | 68614 | 1084 | 48079 | 19451 | 33.75943 | 76.612638 | 2020-09-25 04:23:00 | Jammu and Kashmir, India | ||
2708834 | 2708834 | 2020-07-17 | India | Uttar Pradesh | 45163 | 1084 | 27634 | 16445 | 26.925425 | 80.560982 | 2020-07-18 04:34:45 | Uttar Pradesh, 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]);