daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
20 rows where deaths = 6694 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-21 | US | California | Riverside | 6065 | 756228 | 6694 | 0 | 33.74314981 | -115.9933578 | 2022-12-22 04:20:56 | Riverside, California, US | |
2022-12-20 | US | California | Riverside | 6065 | 756228 | 6694 | 0 | 33.74314981 | -115.9933578 | 2022-12-21 04:21:03 | Riverside, California, US | |
2022-12-19 | US | California | Riverside | 6065 | 753078 | 6694 | 0 | 33.74314981 | -115.9933578 | 2022-12-20 04:21:04 | Riverside, California, US | |
2022-12-18 | US | California | Riverside | 6065 | 753077 | 6694 | 0 | 33.74314981 | -115.9933578 | 2022-12-19 04:21:03 | Riverside, California, US | |
2022-12-17 | US | California | Riverside | 6065 | 753077 | 6694 | 0 | 33.74314981 | -115.9933578 | 2022-12-18 04:21:03 | Riverside, California, US | |
2022-12-16 | US | California | Riverside | 6065 | 753077 | 6694 | 0 | 33.74314981 | -115.9933578 | 2022-12-17 04:21:04 | Riverside, California, US | |
2022-12-15 | US | California | Riverside | 6065 | 753072 | 6694 | 0 | 33.74314981 | -115.9933578 | 2022-12-16 04:21:01 | Riverside, California, US | |
2022-11-20 | Japan | Osaka | 2239950 | 6694 | 0 | 34.620965 | 135.507481 | 2022-11-21 04:21:05 | Osaka, Japan | |||
2022-07-30 | Slovenia | 1082492 | 6694 | 0 | 46.1512 | 14.9955 | 2022-07-31 04:21:02 | Slovenia | ||||
2022-03-27 | US | Texas | Dallas | 48113 | 568232 | 6694 | 0 | 32.76670599 | -96.77796049999999 | 2022-03-28 04:20:33 | Dallas, Texas, US | |
2022-03-25 | Russia | Volgograd Oblast | 207358 | 6694 | 0 | 49.604833899999996 | 44.29035820000001 | 2022-03-26 04:20:23 | Volgograd Oblast, Russia | |||
2022-03-01 | Brazil | Alagoas | 292217 | 6694 | 0 | -9.5713 | -36.782 | 2022-03-02 04:21:07 | Alagoas, Brazil | |||
2022-01-20 | US | Nevada | Clark | 32003 | 461535 | 6694 | 0 | 36.21458855 | -115.0130241 | 2022-01-21 04:21:09 | Clark, Nevada, US | |
2021-12-17 | Brazil | Rondonia | 282195 | 6694 | 0 | -11.5057 | -63.5806 | 2021-12-18 02:22:20 | Rondonia, Brazil | |||
2021-08-23 | Italy | Puglia | 261641 | 6694 | 0 | 41.12559576 | 16.86736689 | 2021-08-24 04:21:19 | Puglia, Italy | |||
2021-08-22 | Italy | Puglia | 261497 | 6694 | 0 | 41.12559576 | 16.86736689 | 2021-08-23 04:21:27 | Puglia, Italy | |||
2021-06-10 | Mexico | Sonora | 76284 | 6694 | 0 | 69590 | 29.2972 | -110.3309 | 2021-06-11 04:23:20 | Sonora, Mexico | ||
2021-04-14 | Spain | Castilla y Leon | 217551 | 6694 | 8716 | 202141 | 41.8357 | -4.3976 | 2021-04-15 04:20:54 | Castilla y Leon, Spain | ||
2021-04-10 | Colombia | Valle del Cauca | 215855 | 6694 | 203386 | 5775 | 3.8009 | -76.6413 | 2021-04-11 04:20:56 | Valle del Cauca, Colombia | ||
2020-12-02 | Egypt | 116724 | 6694 | 102949 | 7081 | 26.820553000000004 | 30.802498 | 2020-12-03 05:28:22 | Egypt |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;