johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
17 rows where deaths = 9293 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 11
- Lithuania 4
- Brazil 2
- North Macedonia 2
- US 2
- Canada 1
- Germany 1
- Moldova 1
- Paraguay 1
- Saudi Arabia 1
- Tunisia 1
- United Kingdom 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2633773 | 2633773 | 2022-09-05 | Lithuania | 1220882 | 9293 | 0 | 55.1694 | 23.8813 | 2022-09-06 04:21:02 | Lithuania | ||||
2987337 | 2987337 | 2022-09-04 | Lithuania | 1220822 | 9293 | 0 | 55.1694 | 23.8813 | 2022-09-05 04:21:01 | Lithuania | ||||
2713022 | 2713022 | 2022-09-03 | Lithuania | 1220758 | 9293 | 0 | 55.1694 | 23.8813 | 2022-09-04 04:21:22 | Lithuania | ||||
1393727 | 1393727 | 2022-09-02 | Lithuania | 1219977 | 9293 | 0 | 55.1694 | 23.8813 | 2022-09-03 04:21:04 | Lithuania | ||||
3774183 | 3774183 | 2022-08-30 | Saudi Arabia | 813376 | 9293 | 0 | 23.885942 | 45.079162 | 2022-08-31 04:20:57 | Saudi Arabia | ||||
1184887 | 1184887 | 2022-05-18 | North Macedonia | 311038 | 9293 | 0 | 41.6086 | 21.7453 | 2022-05-19 04:20:54 | North Macedonia | ||||
3582784 | 3582784 | 2022-05-17 | North Macedonia | 310942 | 9293 | 0 | 41.6086 | 21.7453 | 2022-05-18 04:20:50 | North Macedonia | ||||
4002318 | 4002318 | 2021-12-30 | United Kingdom | Wales | 621732 | 9293 | 0 | 52.1307 | -3.7837 | 2021-12-31 04:21:50 | Wales, United Kingdom | |||
550884 | 550884 | 2021-12-08 | Moldova | 367948 | 9293 | 0 | 47.4116 | 28.3699 | 2021-12-09 04:22:49 | Moldova | ||||
2104279 | 2104279 | 2021-06-01 | Paraguay | 358244 | 9293 | 294994 | 53957 | -23.4425 | -58.4438 | 2021-06-02 04:24:34 | Paraguay | |||
3393302 | 3393302 | 2021-04-28 | Germany | Baden-Wurttemberg | 435322 | 9293 | 384000 | 46157 | 48.6616 | 9.3501 | 2021-04-29 04:20:55 | Baden-Wurttemberg, Germany | ||
3883925 | 3883925 | 2021-04-11 | Tunisia | 271861 | 9293 | 224907 | 37661 | 33.886917 | 9.537499 | 2021-04-12 04:21:00 | Tunisia | |||
3645804 | 3645804 | 2021-03-30 | US | New York | Queens | 36081 | 245105 | 9293 | 0 | 40.71088124 | -73.81684712 | 2021-03-31 04:26:25 | Queens, New York, US | |
1292257 | 1292257 | 2021-03-29 | US | New York | Queens | 36081 | 244365 | 9293 | 0 | 40.71088124 | -73.81684712 | 2021-03-30 04:26:23 | Queens, New York, US | |
1093864 | 1093864 | 2021-01-20 | Canada | Quebec | 248277 | 9293 | 219592 | 19392 | 52.9399 | -73.5491 | 2021-01-21 05:22:01 | Quebec, Canada | ||
2541155 | 2541155 | 2021-01-07 | Brazil | Rio Grande do Sul | 470138 | 9293 | 446187 | 14658 | -30.0346 | -51.2177 | 2021-01-08 05:22:42 | Rio Grande do Sul, Brazil | ||
3480047 | 3480047 | 2020-10-26 | Brazil | Ceara | 270867 | 9293 | 223281 | 38017 | -5.4984 | -39.3206 | 2020-10-27 04:24:45 | Ceara, Brazil |
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]);