daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
3,002 rows where confirmed = 38 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
These facets timed out: province_or_state
country_or_region >30
- US 2,801
- Malaysia 43
- Micronesia 34
- France 31
- Japan 12
- Colombia 10
- Canada 8
- Mongolia 7
- Australia 6
- Dominica 6
- Fiji 6
- Guinea-Bissau 4
- India 4
- Mainland China 2
- Malta 2
- Syria 2
- Albania 1
- Bosnia and Herzegovina 1
- Botswana 1
- Brazil 1
- Burma 1
- China 1
- Croatia 1
- Ethiopia 1
- Georgia 1
- Germany 1
- Guatemala 1
- Hong Kong 1
- Israel 1
- Kenya 1
- …
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-09-01 | US | Montana | Petroleum | 30069 | 38 | 1 | 0 | 47.1182463 | -108.2508876 | 2022-09-02 04:21:07 | Petroleum, Montana, US | |
2022-08-31 | US | Montana | Petroleum | 30069 | 38 | 1 | 0 | 47.1182463 | -108.2508876 | 2022-09-01 04:21:03 | Petroleum, Montana, US | |
2022-08-30 | US | Montana | Petroleum | 30069 | 38 | 1 | 0 | 47.1182463 | -108.2508876 | 2022-08-31 04:20:57 | Petroleum, Montana, US | |
2022-08-29 | US | Montana | Petroleum | 30069 | 38 | 1 | 0 | 47.1182463 | -108.2508876 | 2022-08-30 04:21:03 | Petroleum, Montana, US | |
2022-08-28 | US | Montana | Petroleum | 30069 | 38 | 1 | 0 | 47.1182463 | -108.2508876 | 2022-08-29 04:21:06 | Petroleum, Montana, US | |
2022-08-27 | US | Montana | Petroleum | 30069 | 38 | 1 | 0 | 47.1182463 | -108.2508876 | 2022-08-28 04:21:02 | Petroleum, Montana, US | |
2022-08-26 | US | Montana | Petroleum | 30069 | 38 | 1 | 0 | 47.1182463 | -108.2508876 | 2022-08-27 04:20:57 | Petroleum, Montana, US | |
2022-07-19 | Micronesia | 38 | 0 | 0 | 7.4256 | 150.5508 | 2022-07-20 04:20:59 | Micronesia | ||||
2022-07-18 | Micronesia | 38 | 0 | 0 | 7.4256 | 150.5508 | 2022-07-19 04:20:58 | Micronesia | ||||
2022-07-17 | Micronesia | 38 | 0 | 0 | 7.4256 | 150.5508 | 2022-07-18 04:20:59 | Micronesia | ||||
2022-07-16 | Micronesia | 38 | 0 | 0 | 7.4256 | 150.5508 | 2022-07-17 04:21:15 | Micronesia | ||||
2022-07-15 | Micronesia | 38 | 0 | 0 | 7.4256 | 150.5508 | 2022-07-16 04:21:05 | Micronesia | ||||
2022-07-14 | Micronesia | 38 | 0 | 0 | 7.4256 | 150.5508 | 2022-07-15 04:20:53 | Micronesia | ||||
2022-07-13 | Micronesia | 38 | 0 | 0 | 7.4256 | 150.5508 | 2022-07-14 04:20:57 | Micronesia | ||||
2022-07-12 | Micronesia | 38 | 0 | 0 | 7.4256 | 150.5508 | 2022-07-13 04:20:58 | Micronesia | ||||
2022-07-11 | Micronesia | 38 | 0 | 0 | 7.4256 | 150.5508 | 2022-07-12 04:20:51 | Micronesia | ||||
2022-07-10 | Micronesia | 38 | 0 | 0 | 7.4256 | 150.5508 | 2022-07-11 04:20:46 | Micronesia | ||||
2022-07-09 | Micronesia | 38 | 0 | 0 | 7.4256 | 150.5508 | 2022-07-10 04:20:54 | Micronesia | ||||
2022-07-08 | Micronesia | 38 | 0 | 0 | 7.4256 | 150.5508 | 2022-07-09 04:20:59 | Micronesia | ||||
2022-07-07 | Micronesia | 38 | 0 | 0 | 7.4256 | 150.5508 | 2022-07-08 04:20:56 | Micronesia | ||||
2022-07-06 | Micronesia | 38 | 0 | 0 | 7.4256 | 150.5508 | 2022-07-07 04:20:55 | Micronesia | ||||
2022-07-05 | Micronesia | 38 | 0 | 0 | 7.4256 | 150.5508 | 2022-07-06 04:20:58 | Micronesia | ||||
2022-07-04 | Micronesia | 38 | 0 | 0 | 7.4256 | 150.5508 | 2022-07-05 04:20:45 | Micronesia | ||||
2022-07-03 | Micronesia | 38 | 0 | 0 | 7.4256 | 150.5508 | 2022-07-04 04:20:54 | Micronesia | ||||
2022-07-02 | Micronesia | 38 | 0 | 0 | 7.4256 | 150.5508 | 2022-07-03 04:20:59 | Micronesia | ||||
2022-07-01 | Micronesia | 38 | 0 | 0 | 7.4256 | 150.5508 | 2022-07-02 04:21:16 | Micronesia | ||||
2022-06-30 | Micronesia | 38 | 0 | 0 | 7.4256 | 150.5508 | 2022-07-01 04:21:10 | Micronesia | ||||
2022-06-29 | Micronesia | 38 | 0 | 0 | 7.4256 | 150.5508 | 2022-06-30 04:21:01 | Micronesia | ||||
2022-06-28 | Micronesia | 38 | 0 | 0 | 7.4256 | 150.5508 | 2022-06-29 04:20:59 | Micronesia | ||||
2022-06-27 | Micronesia | 38 | 0 | 0 | 7.4256 | 150.5508 | 2022-06-28 04:20:58 | Micronesia | ||||
2022-06-26 | Micronesia | 38 | 0 | 0 | 7.4256 | 150.5508 | 2022-06-27 04:21:00 | Micronesia | ||||
2022-06-25 | Micronesia | 38 | 0 | 0 | 7.4256 | 150.5508 | 2022-06-26 04:21:02 | Micronesia | ||||
2022-06-24 | Micronesia | 38 | 0 | 0 | 7.4256 | 150.5508 | 2022-06-25 04:20:57 | Micronesia | ||||
2022-06-23 | Micronesia | 38 | 0 | 0 | 7.4256 | 150.5508 | 2022-06-24 04:20:58 | Micronesia | ||||
2022-06-22 | Micronesia | 38 | 0 | 0 | 7.4256 | 150.5508 | 2022-06-23 04:20:55 | Micronesia | ||||
2022-06-21 | Micronesia | 38 | 0 | 0 | 7.4256 | 150.5508 | 2022-06-22 04:20:54 | Micronesia | ||||
2022-06-20 | Micronesia | 38 | 0 | 0 | 7.4256 | 150.5508 | 2022-06-21 04:20:56 | Micronesia | ||||
2022-06-19 | Micronesia | 38 | 0 | 0 | 7.4256 | 150.5508 | 2022-06-20 04:21:01 | Micronesia | ||||
2022-06-18 | Micronesia | 38 | 0 | 0 | 7.4256 | 150.5508 | 2022-06-19 04:20:51 | Micronesia | ||||
2022-06-17 | Micronesia | 38 | 0 | 0 | 7.4256 | 150.5508 | 2022-06-18 04:21:10 | Micronesia | ||||
2022-06-16 | Micronesia | 38 | 0 | 0 | 7.4256 | 150.5508 | 2022-06-17 04:20:56 | Micronesia | ||||
2022-06-07 | US | Maine | Unassigned | 90023 | 38 | 0 | 0 | 46.65926321 | 0.0 | 2022-06-08 04:20:55 | Unassigned, Maine, US | |
2022-01-09 | US | Texas | King | 48269 | 38 | 0 | 0 | 33.61643847 | -100.2558057 | 2022-01-10 04:22:07 | King, Texas, US | |
2022-01-08 | US | Texas | King | 48269 | 38 | 0 | 0 | 33.61643847 | -100.2558057 | 2022-01-09 04:21:46 | King, Texas, US | |
2021-10-26 | US | Vermont | Unassigned | 90050 | 38 | 0 | 0 | 44.85627605 | 0.0 | 2021-10-27 04:22:32 | Unassigned, Vermont, US | |
2021-10-26 | US | Nebraska | Blaine | 31009 | 38 | 0 | 0 | 41.91311716 | -99.97677845 | 2021-10-27 04:22:32 | Blaine, Nebraska, US | |
2021-10-26 | US | Iowa | Unassigned | 90019 | 38 | 0 | 0 | 43.38107862 | 0.0 | 2021-10-27 04:22:32 | Unassigned, Iowa, US | |
2021-10-25 | US | Nebraska | Blaine | 31009 | 38 | 0 | 0 | 41.91311716 | -99.97677845 | 2021-10-26 04:22:09 | Blaine, Nebraska, US | |
2021-10-25 | US | Iowa | Unassigned | 90019 | 38 | 0 | 0 | 43.38107862 | 0.0 | 2021-10-26 04:22:09 | Unassigned, Iowa, US | |
2021-10-24 | US | Nebraska | Blaine | 31009 | 38 | 0 | 0 | 41.91311716 | -99.97677845 | 2021-10-25 04:22:31 | Blaine, Nebraska, US | |
2021-10-24 | US | Iowa | Unassigned | 90019 | 38 | 0 | 0 | 43.38107862 | 0.0 | 2021-10-25 04:22:31 | Unassigned, Iowa, US | |
2021-10-23 | US | Nebraska | Blaine | 31009 | 38 | 0 | 0 | 41.91311716 | -99.97677845 | 2021-10-24 04:21:22 | Blaine, Nebraska, US | |
2021-10-23 | US | Iowa | Unassigned | 90019 | 38 | 0 | 0 | 43.38107862 | 0.0 | 2021-10-24 04:21:22 | Unassigned, Iowa, US | |
2021-10-22 | US | Nebraska | Blaine | 31009 | 38 | 0 | 0 | 41.91311716 | -99.97677845 | 2021-10-23 04:21:32 | Blaine, Nebraska, US | |
2021-10-22 | US | Iowa | Unassigned | 90019 | 38 | 0 | 0 | 43.38107862 | 0.0 | 2021-10-23 04:21:32 | Unassigned, Iowa, US | |
2021-10-21 | US | Nebraska | Blaine | 31009 | 38 | 0 | 0 | 41.91311716 | -99.97677845 | 2021-10-22 04:21:14 | Blaine, Nebraska, US | |
2021-10-21 | US | Iowa | Unassigned | 90019 | 38 | 0 | 0 | 43.38107862 | 0.0 | 2021-10-22 04:21:14 | Unassigned, Iowa, US | |
2021-10-20 | US | Nebraska | Blaine | 31009 | 38 | 0 | 0 | 41.91311716 | -99.97677845 | 2021-10-21 04:21:18 | Blaine, Nebraska, US | |
2021-10-20 | US | Iowa | Unassigned | 90019 | 38 | 0 | 0 | 43.38107862 | 0.0 | 2021-10-21 04:21:18 | Unassigned, Iowa, US | |
2021-10-19 | US | Nebraska | Blaine | 31009 | 38 | 0 | 0 | 41.91311716 | -99.97677845 | 2021-10-20 04:21:00 | Blaine, Nebraska, US | |
2021-10-18 | US | Nebraska | Blaine | 31009 | 38 | 0 | 0 | 41.91311716 | -99.97677845 | 2021-10-19 04:20:54 | Blaine, Nebraska, US | |
2021-10-17 | US | Nebraska | Blaine | 31009 | 38 | 0 | 0 | 41.91311716 | -99.97677845 | 2021-10-18 04:21:10 | Blaine, Nebraska, US | |
2021-10-16 | US | Nebraska | Blaine | 31009 | 38 | 0 | 0 | 41.91311716 | -99.97677845 | 2021-10-17 04:21:29 | Blaine, Nebraska, US | |
2021-10-15 | US | Nebraska | Blaine | 31009 | 38 | 0 | 0 | 41.91311716 | -99.97677845 | 2021-10-16 04:21:15 | Blaine, Nebraska, US | |
2021-10-14 | US | Nebraska | Blaine | 31009 | 38 | 0 | 0 | 41.91311716 | -99.97677845 | 2021-10-15 04:21:26 | Blaine, Nebraska, US | |
2021-10-13 | US | Nebraska | Blaine | 31009 | 38 | 0 | 0 | 41.91311716 | -99.97677845 | 2021-10-14 04:21:29 | Blaine, Nebraska, US | |
2021-10-12 | US | Nebraska | Blaine | 31009 | 38 | 0 | 0 | 41.91311716 | -99.97677845 | 2021-10-13 04:20:51 | Blaine, Nebraska, US | |
2021-10-11 | US | Nebraska | Blaine | 31009 | 38 | 0 | 0 | 41.91311716 | -99.97677845 | 2021-10-12 04:21:09 | Blaine, Nebraska, US | |
2021-10-10 | US | Nebraska | Blaine | 31009 | 38 | 0 | 0 | 41.91311716 | -99.97677845 | 2021-10-11 04:21:31 | Blaine, Nebraska, US | |
2021-10-09 | US | Nebraska | Blaine | 31009 | 38 | 0 | 0 | 41.91311716 | -99.97677845 | 2021-10-10 04:21:38 | Blaine, Nebraska, US | |
2021-10-08 | US | Nebraska | Blaine | 31009 | 38 | 0 | 0 | 41.91311716 | -99.97677845 | 2021-10-09 04:21:34 | Blaine, Nebraska, US | |
2021-10-07 | US | Nebraska | Blaine | 31009 | 38 | 0 | 0 | 41.91311716 | -99.97677845 | 2021-10-08 04:21:25 | Blaine, Nebraska, US | |
2021-10-06 | US | Nebraska | Blaine | 31009 | 38 | 0 | 0 | 41.91311716 | -99.97677845 | 2021-10-07 04:21:36 | Blaine, Nebraska, US | |
2021-09-22 | US | North Dakota | Slope | 38087 | 38 | 0 | 0 | 46.44737738 | -103.4601547 | 2021-09-23 04:21:43 | Slope, North Dakota, US | |
2021-08-11 | US | Alaska | Haines | 2100 | 38 | 0 | 0 | 59.09893571 | -135.4679843 | 2021-08-12 04:21:25 | Haines, Alaska, US | |
2021-08-10 | US | Alaska | Haines | 2100 | 38 | 0 | 0 | 59.09893571 | -135.4679843 | 2021-08-11 04:21:58 | Haines, Alaska, US | |
2021-08-06 | US | Colorado | Hinsdale | 8053 | 38 | 0 | 0 | 37.82247444 | -107.3004345 | 2021-08-07 04:21:30 | Hinsdale, Colorado, US | |
2021-07-28 | US | Oregon | Wheeler | 41069 | 38 | 1 | 0 | 44.72698162 | -120.02814270000002 | 2021-07-29 04:21:33 | Wheeler, Oregon, US | |
2021-07-12 | US | Nevada | Esmeralda | 32009 | 38 | 0 | 0 | 37.78436681 | -117.6319999 | 2021-07-13 04:21:18 | Esmeralda, Nevada, US | |
2021-07-11 | US | Nevada | Esmeralda | 32009 | 38 | 0 | 0 | 37.78436681 | -117.6319999 | 2021-07-12 04:21:34 | Esmeralda, Nevada, US | |
2021-07-10 | US | Nevada | Esmeralda | 32009 | 38 | 0 | 0 | 37.78436681 | -117.6319999 | 2021-07-11 04:21:43 | Esmeralda, Nevada, US | |
2021-07-09 | US | Nevada | Esmeralda | 32009 | 38 | 0 | 0 | 37.78436681 | -117.6319999 | 2021-07-10 04:21:25 | Esmeralda, Nevada, US | |
2021-07-08 | US | Nevada | Esmeralda | 32009 | 38 | 0 | 0 | 37.78436681 | -117.6319999 | 2021-07-09 04:21:21 | Esmeralda, Nevada, US | |
2021-07-07 | US | Nevada | Esmeralda | 32009 | 38 | 0 | 0 | 37.78436681 | -117.6319999 | 2021-07-08 04:21:26 | Esmeralda, Nevada, US | |
2021-07-06 | US | Nevada | Esmeralda | 32009 | 38 | 0 | 0 | 37.78436681 | -117.6319999 | 2021-07-07 04:21:20 | Esmeralda, Nevada, US | |
2021-07-05 | US | Nevada | Esmeralda | 32009 | 38 | 0 | 0 | 37.78436681 | -117.6319999 | 2021-07-06 04:21:32 | Esmeralda, Nevada, US | |
2021-07-04 | US | Nevada | Esmeralda | 32009 | 38 | 0 | 0 | 37.78436681 | -117.6319999 | 2021-07-05 04:21:28 | Esmeralda, Nevada, US | |
2021-07-03 | US | Nevada | Esmeralda | 32009 | 38 | 0 | 0 | 37.78436681 | -117.6319999 | 2021-07-04 04:21:38 | Esmeralda, Nevada, US | |
2021-07-02 | US | Nevada | Esmeralda | 32009 | 38 | 0 | 0 | 37.78436681 | -117.6319999 | 2021-07-03 04:21:37 | Esmeralda, Nevada, US | |
2021-07-01 | US | Nevada | Esmeralda | 32009 | 38 | 0 | 0 | 37.78436681 | -117.6319999 | 2021-07-02 04:21:47 | Esmeralda, Nevada, US | |
2021-06-30 | US | Nevada | Esmeralda | 32009 | 38 | 0 | 0 | 37.78436681 | -117.6319999 | 2021-07-01 04:21:19 | Esmeralda, Nevada, US | |
2021-06-29 | US | Nevada | Esmeralda | 32009 | 38 | 0 | 0 | 37.78436681 | -117.6319999 | 2021-06-30 04:21:41 | Esmeralda, Nevada, US | |
2021-06-28 | US | Nevada | Esmeralda | 32009 | 38 | 0 | 0 | 37.78436681 | -117.6319999 | 2021-06-29 04:21:28 | Esmeralda, Nevada, US | |
2021-06-27 | US | Nevada | Esmeralda | 32009 | 38 | 0 | 0 | 37.78436681 | -117.6319999 | 2021-06-28 04:21:29 | Esmeralda, Nevada, US | |
2021-06-27 | US | Illinois | Out of IL | 80017 | 38 | 0 | 0 | 42.36542373 | 0.0 | 2021-06-28 04:21:29 | Out of IL, Illinois, US | |
2021-06-27 | US | California | Unassigned | 90006 | 38 | 0 | 0 | 41.74228275 | 0.0 | 2021-06-28 04:21:29 | Unassigned, California, US | |
2021-06-26 | US | Nevada | Esmeralda | 32009 | 38 | 0 | 0 | 37.78436681 | -117.6319999 | 2021-06-27 04:21:39 | Esmeralda, Nevada, US | |
2021-06-26 | US | Illinois | Out of IL | 80017 | 38 | 0 | 0 | 42.36542373 | 0.0 | 2021-06-27 04:21:39 | Out of IL, Illinois, US | |
2021-06-26 | US | California | Unassigned | 90006 | 38 | 0 | 0 | 41.74228275 | 0.0 | 2021-06-27 04:21:39 | Unassigned, California, US | |
2021-06-25 | US | Nevada | Esmeralda | 32009 | 38 | 0 | 0 | 37.78436681 | -117.6319999 | 2021-06-26 04:21:43 | Esmeralda, Nevada, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;