johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
25 rows where deaths = 6543 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
515745 | 515745 | 2022-10-15 | Japan | Osaka | 2129690 | 6543 | 0 | 34.620965 | 135.507481 | 2022-10-16 04:22:39 | Osaka, Japan | |||
2529957 | 2529957 | 2022-10-06 | US | California | Riverside | 6065 | 730852 | 6543 | 0 | 33.74314981 | -115.9933578 | 2022-10-07 04:23:08 | Riverside, California, US | |
1811351 | 1811351 | 2022-10-05 | US | California | Riverside | 6065 | 730832 | 6543 | 0 | 33.74314981 | -115.9933578 | 2022-10-06 04:21:22 | Riverside, California, US | |
131325 | 131325 | 2022-10-04 | US | California | Riverside | 6065 | 730814 | 6543 | 0 | 33.74314981 | -115.9933578 | 2022-10-05 04:23:06 | Riverside, California, US | |
2686272 | 2686272 | 2022-10-03 | US | California | Riverside | 6065 | 729728 | 6543 | 0 | 33.74314981 | -115.9933578 | 2022-10-04 04:22:55 | Riverside, California, US | |
2260339 | 2260339 | 2022-10-02 | US | California | Riverside | 6065 | 729707 | 6543 | 0 | 33.74314981 | -115.9933578 | 2022-10-03 04:23:11 | Riverside, California, US | |
2995865 | 2995865 | 2022-10-01 | US | California | Riverside | 6065 | 729693 | 6543 | 0 | 33.74314981 | -115.9933578 | 2022-10-02 04:21:23 | Riverside, California, US | |
854191 | 854191 | 2022-09-30 | US | California | Riverside | 6065 | 729680 | 6543 | 0 | 33.74314981 | -115.9933578 | 2022-10-01 04:23:01 | Riverside, California, US | |
3617654 | 3617654 | 2022-08-01 | US | California | Riverside | 6065 | 699915 | 6543 | 0 | 33.74314981 | -115.9933578 | 2022-08-02 04:20:53 | Riverside, California, US | |
3872134 | 3872134 | 2022-07-31 | US | California | Riverside | 6065 | 695986 | 6543 | 0 | 33.74314981 | -115.9933578 | 2022-08-01 04:21:03 | Riverside, California, US | |
674888 | 674888 | 2022-07-30 | US | California | Riverside | 6065 | 695957 | 6543 | 0 | 33.74314981 | -115.9933578 | 2022-07-31 04:21:02 | Riverside, California, US | |
1784087 | 1784087 | 2022-07-29 | US | California | Riverside | 6065 | 695911 | 6543 | 0 | 33.74314981 | -115.9933578 | 2022-07-30 04:20:42 | Riverside, California, US | |
3428827 | 3428827 | 2022-07-14 | Denmark | 3201797 | 6543 | 0 | 56.2639 | 9.5018 | 2022-07-15 04:20:53 | Denmark | ||||
1294232 | 1294232 | 2022-02-05 | Russia | Chelyabinsk Oblast | 182980 | 6543 | 0 | 54.4223954 | 61.1865846 | 2022-02-06 04:21:00 | Chelyabinsk Oblast, Russia | |||
1231245 | 1231245 | 2022-01-24 | Ukraine | Kharkiv Oblast | 256092 | 6543 | 0 | 49.9935 | 36.2304 | 2022-01-25 04:21:05 | Kharkiv Oblast, Ukraine | |||
1078219 | 1078219 | 2021-12-09 | Spain | Castilla - La Mancha | 247240 | 6543 | 0 | 39.2796 | -3.0977 | 2021-12-10 04:22:28 | Castilla - La Mancha, Spain | |||
423084 | 423084 | 2021-10-10 | Brazil | Rondonia | 266714 | 6543 | 0 | -11.5057 | -63.5806 | 2021-10-11 04:21:31 | Rondonia, Brazil | |||
2875941 | 2875941 | 2021-10-09 | Brazil | Rondonia | 266699 | 6543 | 0 | -11.5057 | -63.5806 | 2021-10-10 04:21:38 | Rondonia, Brazil | |||
2131710 | 2131710 | 2021-10-01 | Azerbaijan | 484591 | 6543 | 0 | 40.1431 | 47.5769 | 2021-10-02 04:21:25 | Azerbaijan | ||||
3448837 | 3448837 | 2021-09-10 | Italy | Sicilia | 287056 | 6543 | 0 | 38.11569725 | 13.362356699999998 | 2021-09-11 04:21:30 | Sicilia, Italy | |||
3904055 | 3904055 | 2021-07-31 | Mexico | Coahuila | 73045 | 6543 | 0 | 66502 | 27.0587 | -101.7068 | 2021-08-01 04:21:50 | Coahuila, Mexico | ||
1412796 | 1412796 | 2021-05-24 | Brazil | Mato Grosso do Sul | 279867 | 6543 | 249323 | 22237 | -20.7722 | -54.7852 | 2021-05-25 04:21:08 | Mato Grosso do Sul, Brazil | ||
646051 | 646051 | 2021-05-05 | Mexico | Sonora | 73630 | 6543 | 0 | 67087 | 29.2972 | -110.3309 | 2021-05-06 04:20:38 | Sonora, Mexico | ||
1841858 | 1841858 | 2021-04-14 | Germany | Hessen | 236594 | 6543 | 210700 | 21321 | 50.6521 | 9.1624 | 2021-04-15 04:20:54 | Hessen, Germany | ||
786347 | 786347 | 2020-10-15 | India | Uttar Pradesh | 447383 | 6543 | 404545 | 36295 | 26.925425 | 80.560982 | 2020-10-16 04:24:01 | 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]);