daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
297 rows where confirmed = 2384 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 13
- US 269
- Japan 6
- China 5
- United Kingdom 5
- Russia 3
- Colombia 2
- Chile 1
- Lithuania 1
- Mexico 1
- Monaco 1
- New Zealand 1
- San Marino 1
- Ukraine 1
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-11-27 | China | Guangxi | 2384 | 2 | 0 | 23.8298 | 108.7881 | 2022-11-28 04:21:02 | Guangxi, China | |||
2022-11-09 | US | Minnesota | Clearwater | 27029 | 2384 | 32 | 0 | 47.57992111 | -95.37790562 | 2022-11-10 04:21:16 | Clearwater, Minnesota, US | |
2022-11-08 | US | Minnesota | Clearwater | 27029 | 2384 | 32 | 0 | 47.57992111 | -95.37790562 | 2022-11-09 04:21:22 | Clearwater, Minnesota, US | |
2022-11-07 | US | Minnesota | Clearwater | 27029 | 2384 | 32 | 0 | 47.57992111 | -95.37790562 | 2022-11-08 04:21:21 | Clearwater, Minnesota, US | |
2022-11-06 | US | Minnesota | Clearwater | 27029 | 2384 | 32 | 0 | 47.57992111 | -95.37790562 | 2022-11-07 04:21:26 | Clearwater, Minnesota, US | |
2022-11-05 | US | Minnesota | Clearwater | 27029 | 2384 | 32 | 0 | 47.57992111 | -95.37790562 | 2022-11-06 04:21:24 | Clearwater, Minnesota, US | |
2022-11-04 | US | Minnesota | Clearwater | 27029 | 2384 | 32 | 0 | 47.57992111 | -95.37790562 | 2022-11-05 04:21:52 | Clearwater, Minnesota, US | |
2022-11-03 | US | Texas | Clay | 48077 | 2384 | 41 | 0 | 33.78686685 | -98.20771198 | 2022-11-04 04:22:11 | Clay, Texas, US | |
2022-11-03 | US | Minnesota | Clearwater | 27029 | 2384 | 32 | 0 | 47.57992111 | -95.37790562 | 2022-11-04 04:22:11 | Clearwater, Minnesota, US | |
2022-11-02 | US | Texas | Clay | 48077 | 2384 | 41 | 0 | 33.78686685 | -98.20771198 | 2022-11-03 04:22:05 | Clay, Texas, US | |
2022-11-01 | US | Alaska | Southeast Fairbanks | 2240 | 2384 | 21 | 0 | 63.87692095 | -143.2127643 | 2022-11-02 04:22:09 | Southeast Fairbanks, Alaska, US | |
2022-11-01 | US | Alaska | Chugach | 2063 | 2384 | 12 | 0 | 61.16666 | -149.9 | 2022-11-02 04:22:09 | Chugach, Alaska, US | |
2022-10-31 | US | Alaska | Southeast Fairbanks | 2240 | 2384 | 21 | 0 | 63.87692095 | -143.2127643 | 2022-11-01 04:22:36 | Southeast Fairbanks, Alaska, US | |
2022-10-31 | US | Alaska | Chugach | 2063 | 2384 | 12 | 0 | 61.16666 | -149.9 | 2022-11-01 04:22:36 | Chugach, Alaska, US | |
2022-10-30 | US | Alaska | Southeast Fairbanks | 2240 | 2384 | 21 | 0 | 63.87692095 | -143.2127643 | 2022-10-31 04:21:36 | Southeast Fairbanks, Alaska, US | |
2022-10-30 | US | Alaska | Chugach | 2063 | 2384 | 12 | 0 | 61.16666 | -149.9 | 2022-10-31 04:21:36 | Chugach, Alaska, US | |
2022-10-29 | US | Alaska | Southeast Fairbanks | 2240 | 2384 | 21 | 0 | 63.87692095 | -143.2127643 | 2022-10-30 04:22:14 | Southeast Fairbanks, Alaska, US | |
2022-10-29 | US | Alaska | Chugach | 2063 | 2384 | 12 | 0 | 61.16666 | -149.9 | 2022-10-30 04:22:14 | Chugach, Alaska, US | |
2022-10-28 | US | Alaska | Southeast Fairbanks | 2240 | 2384 | 21 | 0 | 63.87692095 | -143.2127643 | 2022-10-29 04:21:13 | Southeast Fairbanks, Alaska, US | |
2022-10-28 | US | Alaska | Chugach | 2063 | 2384 | 12 | 0 | 61.16666 | -149.9 | 2022-10-29 04:21:13 | Chugach, Alaska, US | |
2022-10-27 | US | Alaska | Southeast Fairbanks | 2240 | 2384 | 21 | 0 | 63.87692095 | -143.2127643 | 2022-10-28 04:22:31 | Southeast Fairbanks, Alaska, US | |
2022-10-27 | US | Alaska | Chugach | 2063 | 2384 | 12 | 0 | 61.16666 | -149.9 | 2022-10-28 04:22:31 | Chugach, Alaska, US | |
2022-10-26 | US | Alaska | Southeast Fairbanks | 2240 | 2384 | 21 | 0 | 63.87692095 | -143.2127643 | 2022-10-27 04:22:01 | Southeast Fairbanks, Alaska, US | |
2022-10-26 | US | Alaska | Chugach | 2063 | 2384 | 12 | 0 | 61.16666 | -149.9 | 2022-10-27 04:22:01 | Chugach, Alaska, US | |
2022-10-19 | US | New Mexico | Quay | 35037 | 2384 | 68 | 0 | 35.10403332 | -103.5481727 | 2022-10-20 04:22:59 | Quay, New Mexico, US | |
2022-10-11 | US | Arkansas | Searcy | 5129 | 2384 | 52 | 0 | 35.9109364 | -92.69936482 | 2022-10-12 04:22:51 | Searcy, Arkansas, US | |
2022-10-10 | US | Arkansas | Searcy | 5129 | 2384 | 52 | 0 | 35.9109364 | -92.69936482 | 2022-10-11 04:23:05 | Searcy, Arkansas, US | |
2022-10-09 | US | Arkansas | Searcy | 5129 | 2384 | 52 | 0 | 35.9109364 | -92.69936482 | 2022-10-10 04:22:32 | Searcy, Arkansas, US | |
2022-10-08 | US | Arkansas | Searcy | 5129 | 2384 | 52 | 0 | 35.9109364 | -92.69936482 | 2022-10-09 04:21:16 | Searcy, Arkansas, US | |
2022-10-07 | US | Arkansas | Searcy | 5129 | 2384 | 51 | 0 | 35.9109364 | -92.69936482 | 2022-10-08 04:22:56 | Searcy, Arkansas, US | |
2022-10-05 | US | West Virginia | Pocahontas | 54075 | 2384 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-10-06 04:21:22 | Pocahontas, West Virginia, US | |
2022-10-04 | China | Tianjin | 2384 | 3 | 0 | 39.3054 | 117.323 | 2022-10-05 04:23:06 | Tianjin, China | |||
2022-10-03 | China | Tianjin | 2384 | 3 | 0 | 39.3054 | 117.323 | 2022-10-04 04:22:55 | Tianjin, China | |||
2022-09-15 | US | Montana | Blaine | 30005 | 2384 | 33 | 0 | 48.43175214 | -108.9582723 | 2022-09-16 04:21:19 | Blaine, Montana, US | |
2022-09-14 | US | Montana | Blaine | 30005 | 2384 | 33 | 0 | 48.43175214 | -108.9582723 | 2022-09-15 04:21:02 | Blaine, Montana, US | |
2022-09-13 | US | Montana | Blaine | 30005 | 2384 | 33 | 0 | 48.43175214 | -108.9582723 | 2022-09-14 04:20:44 | Blaine, Montana, US | |
2022-09-12 | US | Montana | Blaine | 30005 | 2384 | 33 | 0 | 48.43175214 | -108.9582723 | 2022-09-13 04:20:57 | Blaine, Montana, US | |
2022-09-11 | US | Montana | Blaine | 30005 | 2384 | 33 | 0 | 48.43175214 | -108.9582723 | 2022-09-12 04:20:58 | Blaine, Montana, US | |
2022-09-10 | US | Montana | Blaine | 30005 | 2384 | 33 | 0 | 48.43175214 | -108.9582723 | 2022-09-11 04:20:50 | Blaine, Montana, US | |
2022-09-09 | US | Montana | Blaine | 30005 | 2384 | 33 | 0 | 48.43175214 | -108.9582723 | 2022-09-10 04:21:10 | Blaine, Montana, US | |
2022-08-31 | US | Minnesota | Lake | 27075 | 2384 | 31 | 0 | 47.64270764 | -91.44557998 | 2022-09-01 04:21:03 | Lake, Minnesota, US | |
2022-08-30 | US | Minnesota | Lake | 27075 | 2384 | 31 | 0 | 47.64270764 | -91.44557998 | 2022-08-31 04:20:57 | Lake, Minnesota, US | |
2022-08-29 | US | Minnesota | Lake | 27075 | 2384 | 31 | 0 | 47.64270764 | -91.44557998 | 2022-08-30 04:21:03 | Lake, Minnesota, US | |
2022-08-28 | US | Minnesota | Lake | 27075 | 2384 | 31 | 0 | 47.64270764 | -91.44557998 | 2022-08-29 04:21:06 | Lake, Minnesota, US | |
2022-08-27 | US | Minnesota | Lake | 27075 | 2384 | 31 | 0 | 47.64270764 | -91.44557998 | 2022-08-28 04:21:02 | Lake, Minnesota, US | |
2022-08-26 | US | Minnesota | Lake | 27075 | 2384 | 31 | 0 | 47.64270764 | -91.44557998 | 2022-08-27 04:20:57 | Lake, Minnesota, US | |
2022-08-25 | US | Minnesota | Lake | 27075 | 2384 | 31 | 0 | 47.64270764 | -91.44557998 | 2022-08-26 04:21:02 | Lake, Minnesota, US | |
2022-08-02 | US | Virginia | Northumberland | 51133 | 2384 | 43 | 0 | 37.89202088 | -76.41949732 | 2022-08-03 04:20:59 | Northumberland, Virginia, US | |
2022-08-02 | US | Nebraska | Phelps | 31137 | 2384 | 14 | 0 | 40.51156033 | -99.41461667 | 2022-08-03 04:20:59 | Phelps, Nebraska, US | |
2022-08-01 | US | Nebraska | Phelps | 31137 | 2384 | 14 | 0 | 40.51156033 | -99.41461667 | 2022-08-02 04:20:53 | Phelps, Nebraska, US | |
2022-07-31 | US | Nebraska | Phelps | 31137 | 2384 | 14 | 0 | 40.51156033 | -99.41461667 | 2022-08-01 04:21:03 | Phelps, Nebraska, US | |
2022-07-30 | US | Nebraska | Phelps | 31137 | 2384 | 14 | 0 | 40.51156033 | -99.41461667 | 2022-07-31 04:21:02 | Phelps, Nebraska, US | |
2022-07-29 | US | Nebraska | Phelps | 31137 | 2384 | 14 | 0 | 40.51156033 | -99.41461667 | 2022-07-30 04:20:42 | Phelps, Nebraska, US | |
2022-07-28 | US | Nebraska | Phelps | 31137 | 2384 | 14 | 0 | 40.51156033 | -99.41461667 | 2022-07-29 04:20:45 | Phelps, Nebraska, US | |
2022-07-27 | US | Nebraska | Phelps | 31137 | 2384 | 14 | 0 | 40.51156033 | -99.41461667 | 2022-07-28 04:20:56 | Phelps, Nebraska, US | |
2022-07-26 | US | Nebraska | Phelps | 31137 | 2384 | 14 | 0 | 40.51156033 | -99.41461667 | 2022-07-27 04:21:04 | Phelps, Nebraska, US | |
2022-07-25 | US | Nebraska | Phelps | 31137 | 2384 | 14 | 0 | 40.51156033 | -99.41461667 | 2022-07-26 04:20:58 | Phelps, Nebraska, US | |
2022-07-24 | US | Nebraska | Phelps | 31137 | 2384 | 14 | 0 | 40.51156033 | -99.41461667 | 2022-07-25 04:20:51 | Phelps, Nebraska, US | |
2022-07-23 | US | Nebraska | Phelps | 31137 | 2384 | 14 | 0 | 40.51156033 | -99.41461667 | 2022-07-24 04:20:47 | Phelps, Nebraska, US | |
2022-07-22 | US | Nebraska | Phelps | 31137 | 2384 | 14 | 0 | 40.51156033 | -99.41461667 | 2022-07-23 04:20:53 | Phelps, Nebraska, US | |
2022-07-21 | US | Nebraska | Phelps | 31137 | 2384 | 14 | 0 | 40.51156033 | -99.41461667 | 2022-07-22 04:21:15 | Phelps, Nebraska, US | |
2022-07-20 | US | Texas | Castro | 48069 | 2384 | 47 | 0 | 34.53016752 | -102.2617243 | 2022-07-21 04:21:10 | Castro, Texas, US | |
2022-07-20 | US | Nebraska | Phelps | 31137 | 2384 | 14 | 0 | 40.51156033 | -99.41461667 | 2022-07-21 04:21:10 | Phelps, Nebraska, US | |
2022-07-19 | US | Texas | Castro | 48069 | 2384 | 47 | 0 | 34.53016752 | -102.2617243 | 2022-07-20 04:20:59 | Castro, Texas, US | |
2022-07-19 | US | Tennessee | Clay | 47027 | 2384 | 52 | 0 | 36.55151008 | -85.53930419 | 2022-07-20 04:20:59 | Clay, Tennessee, US | |
2022-07-19 | US | Nebraska | Phelps | 31137 | 2384 | 14 | 0 | 40.51156033 | -99.41461667 | 2022-07-20 04:20:59 | Phelps, Nebraska, US | |
2022-07-18 | US | Texas | Castro | 48069 | 2384 | 47 | 0 | 34.53016752 | -102.2617243 | 2022-07-19 04:20:58 | Castro, Texas, US | |
2022-07-18 | US | Nebraska | Phelps | 31137 | 2384 | 14 | 0 | 40.51156033 | -99.41461667 | 2022-07-19 04:20:58 | Phelps, Nebraska, US | |
2022-07-17 | US | Texas | Castro | 48069 | 2384 | 47 | 0 | 34.53016752 | -102.2617243 | 2022-07-18 04:20:59 | Castro, Texas, US | |
2022-07-17 | US | Nebraska | Phelps | 31137 | 2384 | 14 | 0 | 40.51156033 | -99.41461667 | 2022-07-18 04:20:59 | Phelps, Nebraska, US | |
2022-07-16 | US | Texas | Castro | 48069 | 2384 | 47 | 0 | 34.53016752 | -102.2617243 | 2022-07-17 04:21:15 | Castro, Texas, US | |
2022-07-16 | US | Nebraska | Phelps | 31137 | 2384 | 14 | 0 | 40.51156033 | -99.41461667 | 2022-07-17 04:21:15 | Phelps, Nebraska, US | |
2022-07-15 | US | Texas | Castro | 48069 | 2384 | 47 | 0 | 34.53016752 | -102.2617243 | 2022-07-16 04:21:05 | Castro, Texas, US | |
2022-07-15 | US | Nebraska | Phelps | 31137 | 2384 | 14 | 0 | 40.51156033 | -99.41461667 | 2022-07-16 04:21:05 | Phelps, Nebraska, US | |
2022-07-14 | US | Nebraska | Phelps | 31137 | 2384 | 14 | 0 | 40.51156033 | -99.41461667 | 2022-07-15 04:20:53 | Phelps, Nebraska, US | |
2022-07-13 | US | Nebraska | Phelps | 31137 | 2384 | 14 | 0 | 40.51156033 | -99.41461667 | 2022-07-14 04:20:57 | Phelps, Nebraska, US | |
2022-07-12 | US | North Carolina | Jones | 37103 | 2384 | 39 | 0 | 35.02254606 | -77.35870791 | 2022-07-13 04:20:58 | Jones, North Carolina, US | |
2022-07-12 | US | Nebraska | Phelps | 31137 | 2384 | 14 | 0 | 40.51156033 | -99.41461667 | 2022-07-13 04:20:58 | Phelps, Nebraska, US | |
2022-07-11 | US | North Carolina | Jones | 37103 | 2384 | 39 | 0 | 35.02254606 | -77.35870791 | 2022-07-12 04:20:51 | Jones, North Carolina, US | |
2022-07-11 | US | Nebraska | Phelps | 31137 | 2384 | 14 | 0 | 40.51156033 | -99.41461667 | 2022-07-12 04:20:51 | Phelps, Nebraska, US | |
2022-07-10 | US | North Carolina | Jones | 37103 | 2384 | 39 | 0 | 35.02254606 | -77.35870791 | 2022-07-11 04:20:46 | Jones, North Carolina, US | |
2022-07-10 | US | Nebraska | Phelps | 31137 | 2384 | 14 | 0 | 40.51156033 | -99.41461667 | 2022-07-11 04:20:46 | Phelps, Nebraska, US | |
2022-07-09 | US | North Carolina | Jones | 37103 | 2384 | 39 | 0 | 35.02254606 | -77.35870791 | 2022-07-10 04:20:54 | Jones, North Carolina, US | |
2022-07-09 | US | Nebraska | Phelps | 31137 | 2384 | 14 | 0 | 40.51156033 | -99.41461667 | 2022-07-10 04:20:54 | Phelps, Nebraska, US | |
2022-07-08 | US | North Carolina | Jones | 37103 | 2384 | 39 | 0 | 35.02254606 | -77.35870791 | 2022-07-09 04:20:59 | Jones, North Carolina, US | |
2022-07-08 | US | Nebraska | Phelps | 31137 | 2384 | 14 | 0 | 40.51156033 | -99.41461667 | 2022-07-09 04:20:59 | Phelps, Nebraska, US | |
2022-07-07 | US | North Carolina | Jones | 37103 | 2384 | 39 | 0 | 35.02254606 | -77.35870791 | 2022-07-08 04:20:56 | Jones, North Carolina, US | |
2022-07-07 | US | Nebraska | Phelps | 31137 | 2384 | 14 | 0 | 40.51156033 | -99.41461667 | 2022-07-08 04:20:56 | Phelps, Nebraska, US | |
2022-07-07 | China | Sichuan | 2384 | 3 | 0 | 30.6171 | 102.7103 | 2022-07-08 04:20:56 | Sichuan, China | |||
2022-07-06 | US | North Carolina | Jones | 37103 | 2384 | 39 | 0 | 35.02254606 | -77.35870791 | 2022-07-07 04:20:55 | Jones, North Carolina, US | |
2022-07-06 | US | Nebraska | Phelps | 31137 | 2384 | 14 | 0 | 40.51156033 | -99.41461667 | 2022-07-07 04:20:55 | Phelps, Nebraska, US | |
2022-07-05 | US | West Virginia | Webster | 54101 | 2384 | 34 | 0 | 38.49370949 | -80.4202023 | 2022-07-06 04:20:58 | Webster, West Virginia, US | |
2022-07-05 | US | Nebraska | Phelps | 31137 | 2384 | 14 | 0 | 40.51156033 | -99.41461667 | 2022-07-06 04:20:58 | Phelps, Nebraska, US | |
2022-07-04 | US | Virginia | Essex | 51057 | 2384 | 35 | 0 | 37.93357639 | -76.94230311 | 2022-07-05 04:20:45 | Essex, Virginia, US | |
2022-07-04 | US | Nebraska | Phelps | 31137 | 2384 | 14 | 0 | 40.51156033 | -99.41461667 | 2022-07-05 04:20:45 | Phelps, Nebraska, US | |
2022-07-03 | US | Nebraska | Phelps | 31137 | 2384 | 14 | 0 | 40.51156033 | -99.41461667 | 2022-07-04 04:20:54 | Phelps, Nebraska, US | |
2022-07-02 | US | Nebraska | Phelps | 31137 | 2384 | 14 | 0 | 40.51156033 | -99.41461667 | 2022-07-03 04:20:59 | Phelps, Nebraska, US | |
2022-07-01 | US | Nebraska | Phelps | 31137 | 2384 | 14 | 0 | 40.51156033 | -99.41461667 | 2022-07-02 04:21:16 | Phelps, Nebraska, US | |
2022-06-30 | US | Nebraska | Phelps | 31137 | 2384 | 14 | 0 | 40.51156033 | -99.41461667 | 2022-07-01 04:21:10 | Phelps, Nebraska, US | |
2022-06-29 | US | Nebraska | Phelps | 31137 | 2384 | 14 | 0 | 40.51156033 | -99.41461667 | 2022-06-30 04:21:01 | Phelps, Nebraska, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;