daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
2,779 rows where confirmed = 41 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-15 | US | Montana | Petroleum | 30069 | 41 | 1 | 0 | 47.1182463 | -108.2508876 | 2022-12-16 04:21:01 | Petroleum, Montana, US | |
2022-12-14 | US | Montana | Petroleum | 30069 | 41 | 1 | 0 | 47.1182463 | -108.2508876 | 2022-12-15 04:20:58 | Petroleum, Montana, US | |
2022-12-13 | US | Montana | Petroleum | 30069 | 41 | 1 | 0 | 47.1182463 | -108.2508876 | 2022-12-14 04:21:04 | Petroleum, Montana, US | |
2022-12-12 | US | Montana | Petroleum | 30069 | 41 | 1 | 0 | 47.1182463 | -108.2508876 | 2022-12-11 23:21:04 | Petroleum, Montana, US | |
2022-12-11 | US | Montana | Petroleum | 30069 | 41 | 1 | 0 | 47.1182463 | -108.2508876 | 2022-12-11 23:21:04 | Petroleum, Montana, US | |
2022-12-10 | US | Montana | Petroleum | 30069 | 41 | 1 | 0 | 47.1182463 | -108.2508876 | 2022-12-11 04:20:50 | Petroleum, Montana, US | |
2022-12-09 | US | Montana | Petroleum | 30069 | 41 | 1 | 0 | 47.1182463 | -108.2508876 | 2022-12-10 04:21:02 | Petroleum, Montana, US | |
2022-12-08 | US | Montana | Petroleum | 30069 | 41 | 1 | 0 | 47.1182463 | -108.2508876 | 2022-12-09 04:21:05 | Petroleum, Montana, US | |
2022-12-07 | US | Montana | Petroleum | 30069 | 41 | 1 | 0 | 47.1182463 | -108.2508876 | 2022-12-08 04:21:07 | Petroleum, Montana, US | |
2022-12-06 | US | Montana | Petroleum | 30069 | 41 | 1 | 0 | 47.1182463 | -108.2508876 | 2022-12-07 04:20:58 | Petroleum, Montana, US | |
2022-12-05 | US | Montana | Petroleum | 30069 | 41 | 1 | 0 | 47.1182463 | -108.2508876 | 2022-12-06 04:21:03 | Petroleum, Montana, US | |
2022-12-04 | US | Montana | Petroleum | 30069 | 41 | 1 | 0 | 47.1182463 | -108.2508876 | 2022-12-05 04:20:58 | Petroleum, Montana, US | |
2022-12-03 | US | Montana | Petroleum | 30069 | 41 | 1 | 0 | 47.1182463 | -108.2508876 | 2022-12-04 04:20:56 | Petroleum, Montana, US | |
2022-12-02 | US | Montana | Petroleum | 30069 | 41 | 1 | 0 | 47.1182463 | -108.2508876 | 2022-12-03 04:21:02 | Petroleum, Montana, US | |
2022-12-01 | US | Montana | Petroleum | 30069 | 41 | 1 | 0 | 47.1182463 | -108.2508876 | 2022-12-02 04:21:07 | Petroleum, Montana, US | |
2022-11-30 | US | Montana | Petroleum | 30069 | 41 | 1 | 0 | 47.1182463 | -108.2508876 | 2022-12-01 04:21:03 | Petroleum, Montana, US | |
2022-11-29 | US | Montana | Petroleum | 30069 | 41 | 1 | 0 | 47.1182463 | -108.2508876 | 2022-11-30 04:21:07 | Petroleum, Montana, US | |
2022-11-28 | US | Montana | Petroleum | 30069 | 41 | 1 | 0 | 47.1182463 | -108.2508876 | 2022-11-29 04:21:05 | Petroleum, Montana, US | |
2022-11-27 | US | Montana | Petroleum | 30069 | 41 | 1 | 0 | 47.1182463 | -108.2508876 | 2022-11-28 04:21:02 | Petroleum, Montana, US | |
2022-11-26 | US | Montana | Petroleum | 30069 | 41 | 1 | 0 | 47.1182463 | -108.2508876 | 2022-11-27 04:21:05 | Petroleum, Montana, US | |
2022-11-25 | US | Montana | Petroleum | 30069 | 41 | 1 | 0 | 47.1182463 | -108.2508876 | 2022-11-26 04:21:11 | Petroleum, Montana, US | |
2022-11-24 | US | Montana | Petroleum | 30069 | 41 | 1 | 0 | 47.1182463 | -108.2508876 | 2022-11-25 04:21:06 | Petroleum, Montana, US | |
2022-11-23 | US | Montana | Petroleum | 30069 | 41 | 1 | 0 | 47.1182463 | -108.2508876 | 2022-11-24 04:21:09 | Petroleum, Montana, US | |
2022-11-22 | US | Montana | Petroleum | 30069 | 41 | 1 | 0 | 47.1182463 | -108.2508876 | 2022-11-23 04:21:06 | Petroleum, Montana, US | |
2022-11-21 | US | Montana | Petroleum | 30069 | 41 | 1 | 0 | 47.1182463 | -108.2508876 | 2022-11-22 04:20:47 | Petroleum, Montana, US | |
2022-11-20 | US | Montana | Petroleum | 30069 | 41 | 1 | 0 | 47.1182463 | -108.2508876 | 2022-11-21 04:21:05 | Petroleum, Montana, US | |
2022-11-19 | US | Montana | Petroleum | 30069 | 41 | 1 | 0 | 47.1182463 | -108.2508876 | 2022-11-20 04:21:08 | Petroleum, Montana, US | |
2022-11-18 | US | Montana | Petroleum | 30069 | 41 | 1 | 0 | 47.1182463 | -108.2508876 | 2022-11-19 04:21:14 | Petroleum, Montana, US | |
2022-11-17 | US | Montana | Petroleum | 30069 | 41 | 1 | 0 | 47.1182463 | -108.2508876 | 2022-11-18 04:21:15 | Petroleum, Montana, US | |
2022-11-16 | US | Montana | Petroleum | 30069 | 41 | 1 | 0 | 47.1182463 | -108.2508876 | 2022-11-17 04:21:11 | Petroleum, Montana, US | |
2022-11-15 | US | Montana | Petroleum | 30069 | 41 | 1 | 0 | 47.1182463 | -108.2508876 | 2022-11-16 04:21:09 | Petroleum, Montana, US | |
2022-11-14 | US | Montana | Petroleum | 30069 | 41 | 1 | 0 | 47.1182463 | -108.2508876 | 2022-11-15 04:21:16 | Petroleum, Montana, US | |
2022-04-04 | US | Texas | King | 48269 | 41 | 0 | 0 | 33.61643847 | -100.2558057 | 2022-04-05 04:20:48 | King, Texas, US | |
2022-04-03 | US | Texas | King | 48269 | 41 | 0 | 0 | 33.61643847 | -100.2558057 | 2022-04-04 04:20:51 | King, Texas, US | |
2022-04-02 | US | Texas | King | 48269 | 41 | 0 | 0 | 33.61643847 | -100.2558057 | 2022-04-03 04:20:48 | King, Texas, US | |
2022-04-01 | US | Texas | King | 48269 | 41 | 0 | 0 | 33.61643847 | -100.2558057 | 2022-04-02 04:20:47 | King, Texas, US | |
2022-03-31 | US | Texas | King | 48269 | 41 | 0 | 0 | 33.61643847 | -100.2558057 | 2022-04-01 04:20:28 | King, Texas, US | |
2022-03-30 | US | Texas | King | 48269 | 41 | 0 | 0 | 33.61643847 | -100.2558057 | 2022-03-31 04:20:56 | King, Texas, US | |
2022-03-29 | US | Texas | King | 48269 | 41 | 0 | 0 | 33.61643847 | -100.2558057 | 2022-03-30 04:20:45 | King, Texas, US | |
2022-03-28 | US | Texas | King | 48269 | 41 | 0 | 0 | 33.61643847 | -100.2558057 | 2022-03-29 04:20:46 | King, Texas, US | |
2022-03-27 | US | Texas | King | 48269 | 41 | 0 | 0 | 33.61643847 | -100.2558057 | 2022-03-28 04:20:33 | King, Texas, US | |
2022-03-26 | US | Texas | King | 48269 | 41 | 0 | 0 | 33.61643847 | -100.2558057 | 2022-03-27 04:20:47 | King, Texas, US | |
2022-03-25 | US | Texas | King | 48269 | 41 | 0 | 0 | 33.61643847 | -100.2558057 | 2022-03-26 04:20:23 | King, Texas, US | |
2022-03-24 | US | Texas | King | 48269 | 41 | 0 | 0 | 33.61643847 | -100.2558057 | 2022-03-25 04:20:46 | King, Texas, US | |
2022-03-23 | US | Texas | King | 48269 | 41 | 0 | 0 | 33.61643847 | -100.2558057 | 2022-03-24 04:20:43 | King, Texas, US | |
2022-03-22 | US | Texas | King | 48269 | 41 | 0 | 0 | 33.61643847 | -100.2558057 | 2022-03-23 04:20:48 | King, Texas, US | |
2022-03-21 | US | Texas | King | 48269 | 41 | 0 | 0 | 33.61643847 | -100.2558057 | 2022-03-22 04:20:54 | King, Texas, US | |
2022-03-20 | US | Texas | King | 48269 | 41 | 0 | 0 | 33.61643847 | -100.2558057 | 2022-03-21 04:20:50 | King, Texas, US | |
2022-03-19 | US | Texas | King | 48269 | 41 | 0 | 0 | 33.61643847 | -100.2558057 | 2022-03-20 04:20:45 | King, Texas, US | |
2022-03-18 | US | Texas | King | 48269 | 41 | 0 | 0 | 33.61643847 | -100.2558057 | 2022-03-19 04:20:47 | King, Texas, US | |
2022-03-17 | US | Texas | King | 48269 | 41 | 0 | 0 | 33.61643847 | -100.2558057 | 2022-03-18 04:20:55 | King, Texas, US | |
2022-03-16 | US | Texas | King | 48269 | 41 | 0 | 0 | 33.61643847 | -100.2558057 | 2022-03-17 04:20:56 | King, Texas, US | |
2022-03-15 | US | Texas | King | 48269 | 41 | 0 | 0 | 33.61643847 | -100.2558057 | 2022-03-16 04:20:50 | King, Texas, US | |
2022-03-14 | US | Texas | King | 48269 | 41 | 0 | 0 | 33.61643847 | -100.2558057 | 2022-03-15 04:20:47 | King, Texas, US | |
2022-03-13 | US | Texas | King | 48269 | 41 | 0 | 0 | 33.61643847 | -100.2558057 | 2022-03-14 04:20:46 | King, Texas, US | |
2022-03-12 | US | Texas | King | 48269 | 41 | 0 | 0 | 33.61643847 | -100.2558057 | 2022-03-13 04:20:49 | King, Texas, US | |
2022-03-11 | US | Texas | King | 48269 | 41 | 0 | 0 | 33.61643847 | -100.2558057 | 2022-03-12 04:20:50 | King, Texas, US | |
2022-03-10 | US | Texas | King | 48269 | 41 | 0 | 0 | 33.61643847 | -100.2558057 | 2022-03-11 04:20:50 | King, Texas, US | |
2022-03-09 | US | Texas | King | 48269 | 41 | 0 | 0 | 33.61643847 | -100.2558057 | 2022-03-10 04:20:48 | King, Texas, US | |
2022-03-09 | Samoa | 41 | 0 | 0 | -13.759 | -172.1046 | 2022-03-10 04:20:48 | Samoa | ||||
2022-03-08 | US | Texas | King | 48269 | 41 | 0 | 0 | 33.61643847 | -100.2558057 | 2022-03-09 04:20:59 | King, Texas, US | |
2022-03-08 | Samoa | 41 | 0 | 0 | -13.759 | -172.1046 | 2022-03-09 04:20:59 | Samoa | ||||
2022-03-07 | US | Texas | King | 48269 | 41 | 0 | 0 | 33.61643847 | -100.2558057 | 2022-03-08 04:20:54 | King, Texas, US | |
2022-03-07 | Samoa | 41 | 0 | 0 | -13.759 | -172.1046 | 2022-03-08 04:20:54 | Samoa | ||||
2022-03-06 | US | Texas | King | 48269 | 41 | 0 | 0 | 33.61643847 | -100.2558057 | 2022-03-07 04:20:47 | King, Texas, US | |
2022-03-05 | US | Texas | King | 48269 | 41 | 0 | 0 | 33.61643847 | -100.2558057 | 2022-03-06 04:20:49 | King, Texas, US | |
2022-03-04 | US | Texas | King | 48269 | 41 | 0 | 0 | 33.61643847 | -100.2558057 | 2022-03-05 04:21:10 | King, Texas, US | |
2022-03-03 | US | Texas | King | 48269 | 41 | 0 | 0 | 33.61643847 | -100.2558057 | 2022-03-04 04:21:09 | King, Texas, US | |
2022-03-02 | US | Texas | King | 48269 | 41 | 0 | 0 | 33.61643847 | -100.2558057 | 2022-03-03 04:21:01 | King, Texas, US | |
2022-03-01 | US | Texas | King | 48269 | 41 | 0 | 0 | 33.61643847 | -100.2558057 | 2022-03-02 04:21:07 | King, Texas, US | |
2022-02-28 | US | Texas | King | 48269 | 41 | 0 | 0 | 33.61643847 | -100.2558057 | 2022-03-01 04:21:09 | King, Texas, US | |
2022-02-27 | US | Texas | King | 48269 | 41 | 0 | 0 | 33.61643847 | -100.2558057 | 2022-02-28 04:21:05 | King, Texas, US | |
2022-02-26 | US | Texas | King | 48269 | 41 | 0 | 0 | 33.61643847 | -100.2558057 | 2022-02-27 04:21:04 | King, Texas, US | |
2022-02-25 | US | Texas | King | 48269 | 41 | 0 | 0 | 33.61643847 | -100.2558057 | 2022-02-26 04:21:12 | King, Texas, US | |
2022-02-24 | US | Texas | King | 48269 | 41 | 0 | 0 | 33.61643847 | -100.2558057 | 2022-02-25 04:21:11 | King, Texas, US | |
2022-02-23 | US | Texas | King | 48269 | 41 | 0 | 0 | 33.61643847 | -100.2558057 | 2022-02-24 04:21:14 | King, Texas, US | |
2022-02-22 | US | Texas | King | 48269 | 41 | 0 | 0 | 33.61643847 | -100.2558057 | 2022-02-23 04:21:09 | King, Texas, US | |
2022-02-21 | US | Texas | King | 48269 | 41 | 0 | 0 | 33.61643847 | -100.2558057 | 2022-02-22 04:21:01 | King, Texas, US | |
2022-02-20 | US | Texas | King | 48269 | 41 | 0 | 0 | 33.61643847 | -100.2558057 | 2022-02-21 04:21:05 | King, Texas, US | |
2022-02-19 | US | Texas | King | 48269 | 41 | 0 | 0 | 33.61643847 | -100.2558057 | 2022-02-20 04:21:00 | King, Texas, US | |
2021-11-18 | United Kingdom | Montserrat | 41 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-11-19 04:21:40 | Montserrat, United Kingdom | |||
2021-11-17 | United Kingdom | Montserrat | 41 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-11-18 04:21:33 | Montserrat, United Kingdom | |||
2021-11-16 | United Kingdom | Montserrat | 41 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-11-17 04:21:48 | Montserrat, United Kingdom | |||
2021-11-15 | United Kingdom | Montserrat | 41 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-11-16 04:21:10 | Montserrat, United Kingdom | |||
2021-11-14 | United Kingdom | Montserrat | 41 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-11-15 04:21:36 | Montserrat, United Kingdom | |||
2021-11-14 | US | Nebraska | Blaine | 31009 | 41 | 0 | 0 | 41.91311716 | -99.97677845 | 2021-11-15 04:21:36 | Blaine, Nebraska, US | |
2021-11-13 | United Kingdom | Montserrat | 41 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-11-14 04:21:31 | Montserrat, United Kingdom | |||
2021-11-13 | US | Nebraska | Blaine | 31009 | 41 | 0 | 0 | 41.91311716 | -99.97677845 | 2021-11-14 04:21:31 | Blaine, Nebraska, US | |
2021-11-12 | United Kingdom | Montserrat | 41 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-11-13 04:21:38 | Montserrat, United Kingdom | |||
2021-11-12 | US | Nebraska | Blaine | 31009 | 41 | 0 | 0 | 41.91311716 | -99.97677845 | 2021-11-13 04:21:38 | Blaine, Nebraska, US | |
2021-11-11 | United Kingdom | Montserrat | 41 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-11-12 04:22:01 | Montserrat, United Kingdom | |||
2021-11-11 | US | Nebraska | Blaine | 31009 | 41 | 0 | 0 | 41.91311716 | -99.97677845 | 2021-11-12 04:22:01 | Blaine, Nebraska, US | |
2021-11-10 | United Kingdom | Montserrat | 41 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-11-11 04:21:45 | Montserrat, United Kingdom | |||
2021-11-09 | United Kingdom | Montserrat | 41 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-11-10 04:21:38 | Montserrat, United Kingdom | |||
2021-11-08 | United Kingdom | Montserrat | 41 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-11-09 04:21:36 | Montserrat, United Kingdom | |||
2021-11-07 | United Kingdom | Montserrat | 41 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-11-08 04:21:43 | Montserrat, United Kingdom | |||
2021-11-06 | United Kingdom | Montserrat | 41 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-11-07 04:21:53 | Montserrat, United Kingdom | |||
2021-11-05 | United Kingdom | Montserrat | 41 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-11-06 04:21:51 | Montserrat, United Kingdom | |||
2021-11-04 | United Kingdom | Montserrat | 41 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-11-05 04:21:54 | Montserrat, United Kingdom | |||
2021-11-03 | United Kingdom | Montserrat | 41 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-11-04 04:22:20 | Montserrat, United Kingdom |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;