daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
108 rows where deaths = 6875 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-10-24 | Slovenia | 1226109 | 6875 | 0 | 46.1512 | 14.9955 | 2022-10-25 04:21:53 | Slovenia | ||||
2022-07-23 | Algeria | 266772 | 6875 | 0 | 28.0339 | 1.6596 | 2022-07-24 04:20:47 | Algeria | ||||
2022-07-22 | Algeria | 266700 | 6875 | 0 | 28.0339 | 1.6596 | 2022-07-23 04:20:53 | Algeria | ||||
2022-07-21 | Algeria | 266654 | 6875 | 0 | 28.0339 | 1.6596 | 2022-07-22 04:21:15 | Algeria | ||||
2022-07-20 | Algeria | 266591 | 6875 | 0 | 28.0339 | 1.6596 | 2022-07-21 04:21:10 | Algeria | ||||
2022-07-19 | Algeria | 266542 | 6875 | 0 | 28.0339 | 1.6596 | 2022-07-20 04:20:59 | Algeria | ||||
2022-07-18 | Algeria | 266487 | 6875 | 0 | 28.0339 | 1.6596 | 2022-07-19 04:20:58 | Algeria | ||||
2022-07-17 | Algeria | 266445 | 6875 | 0 | 28.0339 | 1.6596 | 2022-07-18 04:20:59 | Algeria | ||||
2022-07-16 | Algeria | 266424 | 6875 | 0 | 28.0339 | 1.6596 | 2022-07-17 04:21:15 | Algeria | ||||
2022-07-15 | Algeria | 266392 | 6875 | 0 | 28.0339 | 1.6596 | 2022-07-16 04:21:05 | Algeria | ||||
2022-07-14 | Algeria | 266356 | 6875 | 0 | 28.0339 | 1.6596 | 2022-07-15 04:20:53 | Algeria | ||||
2022-07-13 | Algeria | 266328 | 6875 | 0 | 28.0339 | 1.6596 | 2022-07-14 04:20:57 | Algeria | ||||
2022-07-12 | Algeria | 266303 | 6875 | 0 | 28.0339 | 1.6596 | 2022-07-13 04:20:58 | Algeria | ||||
2022-07-11 | Algeria | 266274 | 6875 | 0 | 28.0339 | 1.6596 | 2022-07-12 04:20:51 | Algeria | ||||
2022-07-10 | Algeria | 266257 | 6875 | 0 | 28.0339 | 1.6596 | 2022-07-11 04:20:46 | Algeria | ||||
2022-07-09 | Algeria | 266246 | 6875 | 0 | 28.0339 | 1.6596 | 2022-07-10 04:20:54 | Algeria | ||||
2022-07-08 | Algeria | 266228 | 6875 | 0 | 28.0339 | 1.6596 | 2022-07-09 04:20:59 | Algeria | ||||
2022-07-07 | Algeria | 266202 | 6875 | 0 | 28.0339 | 1.6596 | 2022-07-08 04:20:56 | Algeria | ||||
2022-07-06 | Algeria | 266181 | 6875 | 0 | 28.0339 | 1.6596 | 2022-07-07 04:20:55 | Algeria | ||||
2022-07-05 | Algeria | 266173 | 6875 | 0 | 28.0339 | 1.6596 | 2022-07-06 04:20:58 | Algeria | ||||
2022-07-04 | Algeria | 266173 | 6875 | 0 | 28.0339 | 1.6596 | 2022-07-05 04:20:45 | Algeria | ||||
2022-07-03 | Algeria | 266128 | 6875 | 0 | 28.0339 | 1.6596 | 2022-07-04 04:20:54 | Algeria | ||||
2022-07-02 | Algeria | 266115 | 6875 | 0 | 28.0339 | 1.6596 | 2022-07-03 04:20:59 | Algeria | ||||
2022-07-01 | Algeria | 266105 | 6875 | 0 | 28.0339 | 1.6596 | 2022-07-02 04:21:16 | Algeria | ||||
2022-06-30 | Algeria | 266087 | 6875 | 0 | 28.0339 | 1.6596 | 2022-07-01 04:21:10 | Algeria | ||||
2022-06-29 | Algeria | 266073 | 6875 | 0 | 28.0339 | 1.6596 | 2022-06-30 04:21:01 | Algeria | ||||
2022-06-28 | Algeria | 266062 | 6875 | 0 | 28.0339 | 1.6596 | 2022-06-29 04:20:59 | Algeria | ||||
2022-06-27 | Algeria | 266049 | 6875 | 0 | 28.0339 | 1.6596 | 2022-06-28 04:20:58 | Algeria | ||||
2022-06-26 | Algeria | 266038 | 6875 | 0 | 28.0339 | 1.6596 | 2022-06-27 04:21:00 | Algeria | ||||
2022-06-25 | Algeria | 266030 | 6875 | 0 | 28.0339 | 1.6596 | 2022-06-26 04:21:02 | Algeria | ||||
2022-06-24 | Algeria | 266025 | 6875 | 0 | 28.0339 | 1.6596 | 2022-06-25 04:20:57 | Algeria | ||||
2022-06-23 | Algeria | 266015 | 6875 | 0 | 28.0339 | 1.6596 | 2022-06-24 04:20:58 | Algeria | ||||
2022-06-22 | Algeria | 266006 | 6875 | 0 | 28.0339 | 1.6596 | 2022-06-23 04:20:55 | Algeria | ||||
2022-06-21 | Algeria | 265993 | 6875 | 0 | 28.0339 | 1.6596 | 2022-06-22 04:20:54 | Algeria | ||||
2022-06-20 | Algeria | 265985 | 6875 | 0 | 28.0339 | 1.6596 | 2022-06-21 04:20:56 | Algeria | ||||
2022-06-19 | Algeria | 265975 | 6875 | 0 | 28.0339 | 1.6596 | 2022-06-20 04:21:01 | Algeria | ||||
2022-06-18 | Algeria | 265971 | 6875 | 0 | 28.0339 | 1.6596 | 2022-06-19 04:20:51 | Algeria | ||||
2022-06-17 | Algeria | 265968 | 6875 | 0 | 28.0339 | 1.6596 | 2022-06-18 04:21:10 | Algeria | ||||
2022-06-16 | Algeria | 265964 | 6875 | 0 | 28.0339 | 1.6596 | 2022-06-17 04:20:56 | Algeria | ||||
2022-06-15 | Algeria | 265952 | 6875 | 0 | 28.0339 | 1.6596 | 2022-06-16 04:20:55 | Algeria | ||||
2022-06-14 | Algeria | 265943 | 6875 | 0 | 28.0339 | 1.6596 | 2022-06-15 04:20:54 | Algeria | ||||
2022-06-13 | Algeria | 265937 | 6875 | 0 | 28.0339 | 1.6596 | 2022-06-14 04:20:52 | Algeria | ||||
2022-06-12 | Algeria | 265927 | 6875 | 0 | 28.0339 | 1.6596 | 2022-06-13 04:21:14 | Algeria | ||||
2022-06-11 | Algeria | 265925 | 6875 | 0 | 28.0339 | 1.6596 | 2022-06-12 04:20:53 | Algeria | ||||
2022-06-10 | Algeria | 265925 | 6875 | 0 | 28.0339 | 1.6596 | 2022-06-11 04:21:01 | Algeria | ||||
2022-06-09 | Algeria | 265920 | 6875 | 0 | 28.0339 | 1.6596 | 2022-06-10 04:20:55 | Algeria | ||||
2022-06-08 | Algeria | 265909 | 6875 | 0 | 28.0339 | 1.6596 | 2022-06-09 04:20:54 | Algeria | ||||
2022-06-07 | Algeria | 265904 | 6875 | 0 | 28.0339 | 1.6596 | 2022-06-08 04:20:55 | Algeria | ||||
2022-06-06 | Algeria | 265900 | 6875 | 0 | 28.0339 | 1.6596 | 2022-06-07 04:21:08 | Algeria | ||||
2022-06-05 | Algeria | 265897 | 6875 | 0 | 28.0339 | 1.6596 | 2022-06-06 04:20:57 | Algeria | ||||
2022-06-04 | Algeria | 265889 | 6875 | 0 | 28.0339 | 1.6596 | 2022-06-05 04:20:55 | Algeria | ||||
2022-06-03 | Algeria | 265889 | 6875 | 0 | 28.0339 | 1.6596 | 2022-06-04 04:20:58 | Algeria | ||||
2022-06-02 | Algeria | 265889 | 6875 | 0 | 28.0339 | 1.6596 | 2022-06-03 04:20:58 | Algeria | ||||
2022-06-01 | Algeria | 265887 | 6875 | 0 | 28.0339 | 1.6596 | 2022-06-02 05:20:39 | Algeria | ||||
2022-05-31 | Algeria | 265884 | 6875 | 0 | 28.0339 | 1.6596 | 2022-06-01 04:20:55 | Algeria | ||||
2022-05-30 | Algeria | 265877 | 6875 | 0 | 28.0339 | 1.6596 | 2022-05-31 04:20:51 | Algeria | ||||
2022-05-29 | Algeria | 265873 | 6875 | 0 | 28.0339 | 1.6596 | 2022-05-30 04:20:50 | Algeria | ||||
2022-05-28 | Algeria | 265873 | 6875 | 0 | 28.0339 | 1.6596 | 2022-05-29 04:20:53 | Algeria | ||||
2022-05-27 | Algeria | 265870 | 6875 | 0 | 28.0339 | 1.6596 | 2022-05-28 04:21:07 | Algeria | ||||
2022-05-26 | Algeria | 265864 | 6875 | 0 | 28.0339 | 1.6596 | 2022-05-27 04:20:56 | Algeria | ||||
2022-05-25 | Algeria | 265862 | 6875 | 0 | 28.0339 | 1.6596 | 2022-05-26 04:20:50 | Algeria | ||||
2022-05-24 | Algeria | 265860 | 6875 | 0 | 28.0339 | 1.6596 | 2022-05-25 04:20:56 | Algeria | ||||
2022-05-23 | Algeria | 265855 | 6875 | 0 | 28.0339 | 1.6596 | 2022-05-24 04:20:57 | Algeria | ||||
2022-05-22 | Algeria | 265862 | 6875 | 0 | 28.0339 | 1.6596 | 2022-05-26 04:20:50 | Algeria | ||||
2022-05-21 | Algeria | 265851 | 6875 | 0 | 28.0339 | 1.6596 | 2022-05-22 04:20:52 | Algeria | ||||
2022-05-20 | Russia | Volgograd Oblast | 219930 | 6875 | 0 | 49.6048339 | 44.2903582 | 2022-05-21 04:20:58 | Volgograd Oblast, Russia | |||
2022-05-20 | Algeria | 265847 | 6875 | 0 | 28.0339 | 1.6596 | 2022-05-21 04:20:58 | Algeria | ||||
2022-05-19 | Russia | Volgograd Oblast | 219785 | 6875 | 0 | 49.6048339 | 44.2903582 | 2022-05-20 04:20:57 | Volgograd Oblast, Russia | |||
2022-05-19 | Algeria | 265841 | 6875 | 0 | 28.0339 | 1.6596 | 2022-05-20 04:20:57 | Algeria | ||||
2022-05-18 | Algeria | 265834 | 6875 | 0 | 28.0339 | 1.6596 | 2022-05-19 04:20:54 | Algeria | ||||
2022-05-17 | Algeria | 265828 | 6875 | 0 | 28.0339 | 1.6596 | 2022-05-18 04:20:50 | Algeria | ||||
2022-05-16 | Algeria | 265823 | 6875 | 0 | 28.0339 | 1.6596 | 2022-05-17 04:20:59 | Algeria | ||||
2022-05-15 | Algeria | 265818 | 6875 | 0 | 28.0339 | 1.6596 | 2022-05-16 04:20:47 | Algeria | ||||
2022-05-14 | Algeria | 265816 | 6875 | 0 | 28.0339 | 1.6596 | 2022-05-15 04:20:53 | Algeria | ||||
2022-05-13 | Algeria | 265814 | 6875 | 0 | 28.0339 | 1.6596 | 2022-05-14 04:20:48 | Algeria | ||||
2022-05-12 | Algeria | 265808 | 6875 | 0 | 28.0339 | 1.6596 | 2022-05-13 04:20:51 | Algeria | ||||
2022-05-11 | Algeria | 265806 | 6875 | 0 | 28.0339 | 1.6596 | 2022-05-12 04:20:54 | Algeria | ||||
2022-05-10 | Algeria | 265804 | 6875 | 0 | 28.0339 | 1.6596 | 2022-05-11 04:20:48 | Algeria | ||||
2022-05-09 | Algeria | 265800 | 6875 | 0 | 28.0339 | 1.6596 | 2022-05-10 04:20:50 | Algeria | ||||
2022-05-08 | Algeria | 265798 | 6875 | 0 | 28.0339 | 1.6596 | 2022-05-09 04:20:54 | Algeria | ||||
2022-05-07 | Algeria | 265794 | 6875 | 0 | 28.0339 | 1.6596 | 2022-05-08 04:20:49 | Algeria | ||||
2022-05-06 | Algeria | 265791 | 6875 | 0 | 28.0339 | 1.6596 | 2022-05-07 04:21:09 | Algeria | ||||
2022-05-05 | Algeria | 265786 | 6875 | 0 | 28.0339 | 1.6596 | 2022-05-06 04:21:00 | Algeria | ||||
2022-05-04 | Algeria | 265782 | 6875 | 0 | 28.0339 | 1.6596 | 2022-05-05 04:20:55 | Algeria | ||||
2022-05-03 | Algeria | 265782 | 6875 | 0 | 28.0339 | 1.6596 | 2022-05-04 04:20:59 | Algeria | ||||
2022-05-02 | Algeria | 265782 | 6875 | 0 | 28.0339 | 1.6596 | 2022-05-03 04:21:00 | Algeria | ||||
2022-05-01 | Algeria | 265782 | 6875 | 0 | 28.0339 | 1.6596 | 2022-05-02 04:21:10 | Algeria | ||||
2022-04-30 | Algeria | 265780 | 6875 | 0 | 28.0339 | 1.6596 | 2022-05-01 04:20:57 | Algeria | ||||
2022-04-29 | Algeria | 265779 | 6875 | 0 | 28.0339 | 1.6596 | 2022-04-30 04:21:05 | Algeria | ||||
2022-04-28 | Algeria | 265776 | 6875 | 0 | 28.0339 | 1.6596 | 2022-04-29 04:20:59 | Algeria | ||||
2022-04-27 | Algeria | 265773 | 6875 | 0 | 28.0339 | 1.6596 | 2022-04-28 04:20:47 | Algeria | ||||
2022-04-26 | Algeria | 265772 | 6875 | 0 | 28.0339 | 1.6596 | 2022-04-27 04:20:52 | Algeria | ||||
2022-04-25 | Algeria | 265771 | 6875 | 0 | 28.0339 | 1.6596 | 2022-04-26 04:20:51 | Algeria | ||||
2022-04-24 | Algeria | 265767 | 6875 | 0 | 28.0339 | 1.6596 | 2022-04-25 04:20:56 | Algeria | ||||
2022-03-29 | US | California | Orange | 6059 | 586934 | 6875 | 0 | 33.70147516 | -117.76459979999998 | 2022-03-30 04:20:45 | Orange, California, US | |
2022-02-02 | Spain | Castilla - La Mancha | 438600 | 6875 | 0 | 39.2796 | -3.0977 | 2022-02-03 04:21:21 | Castilla - La Mancha, Spain | |||
2021-12-27 | US | New York | Bronx | 36005 | 244870 | 6875 | 0 | 40.85209301 | -73.86282755 | 2021-12-28 04:21:47 | Bronx, New York, US | |
2021-11-22 | Italy | Puglia | 277466 | 6875 | 0 | 41.12559576 | 16.86736689 | 2021-11-23 04:22:39 | Puglia, Italy | |||
2021-10-13 | North Macedonia | 195542 | 6875 | 0 | 41.6086 | 21.7453 | 2021-10-14 04:21:29 | North Macedonia | ||||
2021-08-30 | Pakistan | Sindh | 431636 | 6875 | 0 | 26.009446 | 68.77680699999999 | 2021-08-31 04:21:46 | Sindh, Pakistan |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;