daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
738 rows where confirmed = 590 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-09-15 | US | Texas | Hardeman | 48197 | 590 | 20 | 0 | 34.28944521 | -99.74632408 | 2022-09-16 04:21:19 | Hardeman, Texas, US | |
2022-09-14 | US | Texas | Hardeman | 48197 | 590 | 20 | 0 | 34.28944521 | -99.74632408 | 2022-09-15 04:21:02 | Hardeman, Texas, US | |
2022-09-13 | US | Texas | Hardeman | 48197 | 590 | 20 | 0 | 34.28944521 | -99.74632408 | 2022-09-14 04:20:44 | Hardeman, Texas, US | |
2022-09-12 | US | Texas | Hardeman | 48197 | 590 | 20 | 0 | 34.28944521 | -99.74632408 | 2022-09-13 04:20:57 | Hardeman, Texas, US | |
2022-09-05 | US | Texas | Menard | 48327 | 590 | 12 | 0 | 30.88990665 | -99.8204794 | 2022-09-06 04:21:02 | Menard, Texas, US | |
2022-09-04 | US | Texas | Menard | 48327 | 590 | 12 | 0 | 30.88990665 | -99.8204794 | 2022-09-05 04:21:01 | Menard, Texas, US | |
2022-09-03 | US | Texas | Menard | 48327 | 590 | 12 | 0 | 30.88990665 | -99.8204794 | 2022-09-04 04:21:22 | Menard, Texas, US | |
2022-09-02 | US | Texas | Menard | 48327 | 590 | 12 | 0 | 30.88990665 | -99.8204794 | 2022-09-03 04:21:04 | Menard, Texas, US | |
2022-09-01 | US | Texas | Menard | 48327 | 590 | 12 | 0 | 30.88990665 | -99.8204794 | 2022-09-02 04:21:07 | Menard, Texas, US | |
2022-08-31 | US | Texas | Menard | 48327 | 590 | 12 | 0 | 30.88990665 | -99.8204794 | 2022-09-01 04:21:03 | Menard, Texas, US | |
2022-08-09 | US | Washington | Wahkiakum | 53069 | 590 | 8 | 0 | 46.2918004 | -123.4250831 | 2022-08-10 04:20:57 | Wahkiakum, Washington, US | |
2022-08-09 | US | North Dakota | Renville | 38075 | 590 | 15 | 0 | 48.71982533 | -101.6603912 | 2022-08-10 04:20:57 | Renville, North Dakota, US | |
2022-08-08 | US | Washington | Wahkiakum | 53069 | 590 | 8 | 0 | 46.2918004 | -123.4250831 | 2022-08-09 04:20:34 | Wahkiakum, Washington, US | |
2022-08-08 | US | North Dakota | Renville | 38075 | 590 | 15 | 0 | 48.71982533 | -101.6603912 | 2022-08-09 04:20:34 | Renville, North Dakota, US | |
2022-08-07 | US | Washington | Wahkiakum | 53069 | 590 | 8 | 0 | 46.2918004 | -123.4250831 | 2022-08-08 04:21:08 | Wahkiakum, Washington, US | |
2022-08-06 | US | Washington | Wahkiakum | 53069 | 590 | 8 | 0 | 46.2918004 | -123.4250831 | 2022-08-07 04:20:54 | Wahkiakum, Washington, US | |
2022-08-05 | US | Washington | Wahkiakum | 53069 | 590 | 8 | 0 | 46.2918004 | -123.4250831 | 2022-08-06 04:20:56 | Wahkiakum, Washington, US | |
2022-08-04 | US | Texas | Oldham | 48359 | 590 | 6 | 0 | 35.40425596 | -102.6027606 | 2022-08-05 04:20:52 | Oldham, Texas, US | |
2022-07-26 | US | Kansas | Elk | 20049 | 590 | 12 | 0 | 37.45338105 | -96.24369667 | 2022-07-27 04:21:04 | Elk, Kansas, US | |
2022-07-25 | US | Kansas | Elk | 20049 | 590 | 12 | 0 | 37.45338105 | -96.24369667 | 2022-07-26 04:20:58 | Elk, Kansas, US | |
2022-07-24 | US | Kansas | Elk | 20049 | 590 | 12 | 0 | 37.45338105 | -96.24369667 | 2022-07-25 04:20:51 | Elk, Kansas, US | |
2022-07-23 | US | Kansas | Elk | 20049 | 590 | 12 | 0 | 37.45338105 | -96.24369667 | 2022-07-24 04:20:47 | Elk, Kansas, US | |
2022-07-22 | US | Kansas | Elk | 20049 | 590 | 12 | 0 | 37.45338105 | -96.24369667 | 2022-07-23 04:20:53 | Elk, Kansas, US | |
2022-07-21 | US | Kansas | Elk | 20049 | 590 | 12 | 0 | 37.45338105 | -96.24369667 | 2022-07-22 04:21:15 | Elk, Kansas, US | |
2022-07-20 | US | Kansas | Elk | 20049 | 590 | 12 | 0 | 37.45338105 | -96.24369667 | 2022-07-21 04:21:10 | Elk, Kansas, US | |
2022-07-14 | US | Texas | Armstrong | 48011 | 590 | 10 | 0 | 34.96507426 | -101.3574874 | 2022-07-15 04:20:53 | Armstrong, Texas, US | |
2022-07-12 | US | South Dakota | Faulk | 46049 | 590 | 17 | 0 | 45.07082625 | -99.14535601 | 2022-07-13 04:20:58 | Faulk, South Dakota, US | |
2022-07-12 | US | Kansas | Graham | 20065 | 590 | 15 | 0 | 39.34987223 | -99.88332493 | 2022-07-13 04:20:58 | Graham, Kansas, US | |
2022-07-11 | US | South Dakota | Faulk | 46049 | 590 | 17 | 0 | 45.07082625 | -99.14535601 | 2022-07-12 04:20:51 | Faulk, South Dakota, US | |
2022-07-11 | US | Kansas | Graham | 20065 | 590 | 15 | 0 | 39.34987223 | -99.88332493 | 2022-07-12 04:20:51 | Graham, Kansas, US | |
2022-07-10 | US | South Dakota | Faulk | 46049 | 590 | 17 | 0 | 45.07082625 | -99.14535601 | 2022-07-11 04:20:46 | Faulk, South Dakota, US | |
2022-07-10 | US | Kansas | Graham | 20065 | 590 | 15 | 0 | 39.34987223 | -99.88332493 | 2022-07-11 04:20:46 | Graham, Kansas, US | |
2022-07-09 | US | South Dakota | Faulk | 46049 | 590 | 17 | 0 | 45.07082625 | -99.14535601 | 2022-07-10 04:20:54 | Faulk, South Dakota, US | |
2022-07-09 | US | Kansas | Graham | 20065 | 590 | 15 | 0 | 39.34987223 | -99.88332493 | 2022-07-10 04:20:54 | Graham, Kansas, US | |
2022-07-09 | China | Macau | 590 | 2 | 0 | 22.1667 | 113.55 | 2022-07-10 04:20:54 | Macau, China | |||
2022-07-08 | US | South Dakota | Faulk | 46049 | 590 | 17 | 0 | 45.07082625 | -99.14535601 | 2022-07-09 04:20:59 | Faulk, South Dakota, US | |
2022-07-08 | US | Kansas | Graham | 20065 | 590 | 15 | 0 | 39.34987223 | -99.88332493 | 2022-07-09 04:20:59 | Graham, Kansas, US | |
2022-07-07 | US | South Dakota | Faulk | 46049 | 590 | 17 | 0 | 45.07082625 | -99.14535601 | 2022-07-08 04:20:56 | Faulk, South Dakota, US | |
2022-07-07 | US | Kansas | Graham | 20065 | 590 | 15 | 0 | 39.34987223 | -99.88332493 | 2022-07-08 04:20:56 | Graham, Kansas, US | |
2022-07-06 | US | South Dakota | Faulk | 46049 | 590 | 17 | 0 | 45.07082625 | -99.14535601 | 2022-07-07 04:20:55 | Faulk, South Dakota, US | |
2022-07-06 | US | Kansas | Graham | 20065 | 590 | 15 | 0 | 39.34987223 | -99.88332493 | 2022-07-07 04:20:55 | Graham, Kansas, US | |
2022-06-26 | US | North Dakota | Griggs | 38039 | 590 | 2 | 0 | 47.45785838 | -98.23850925 | 2022-06-27 04:21:00 | Griggs, North Dakota, US | |
2022-06-25 | US | North Dakota | Griggs | 38039 | 590 | 2 | 0 | 47.45785838 | -98.23850925 | 2022-06-26 04:21:02 | Griggs, North Dakota, US | |
2022-06-24 | US | North Dakota | Griggs | 38039 | 590 | 2 | 0 | 47.45785838 | -98.23850925 | 2022-06-25 04:20:57 | Griggs, North Dakota, US | |
2022-06-23 | US | North Dakota | Griggs | 38039 | 590 | 2 | 0 | 47.45785838 | -98.23850925 | 2022-06-24 04:20:58 | Griggs, North Dakota, US | |
2022-06-22 | US | North Dakota | Griggs | 38039 | 590 | 2 | 0 | 47.45785838 | -98.23850925 | 2022-06-23 04:20:55 | Griggs, North Dakota, US | |
2022-06-21 | US | North Dakota | Griggs | 38039 | 590 | 2 | 0 | 47.45785838 | -98.23850925 | 2022-06-22 04:20:54 | Griggs, North Dakota, US | |
2022-06-20 | US | North Dakota | Griggs | 38039 | 590 | 2 | 0 | 47.45785838 | -98.23850925 | 2022-06-21 04:20:56 | Griggs, North Dakota, US | |
2022-05-19 | US | New Mexico | De Baca | 35011 | 590 | 6 | 0 | 34.34274529 | -104.4117842 | 2022-05-20 04:20:57 | De Baca, New Mexico, US | |
2022-05-18 | US | New Mexico | De Baca | 35011 | 590 | 6 | 0 | 34.34274529 | -104.4117842 | 2022-05-19 04:20:54 | De Baca, New Mexico, US | |
2022-05-17 | US | New Mexico | De Baca | 35011 | 590 | 6 | 0 | 34.34274529 | -104.4117842 | 2022-05-18 04:20:50 | De Baca, New Mexico, US | |
2022-05-16 | US | New Mexico | De Baca | 35011 | 590 | 6 | 0 | 34.34274529 | -104.4117842 | 2022-05-17 04:20:59 | De Baca, New Mexico, US | |
2022-05-11 | US | Minnesota | Cook | 27031 | 590 | 4 | 0 | 47.90504893 | -90.52629546 | 2022-05-12 04:20:54 | Cook, Minnesota, US | |
2022-02-24 | US | North Dakota | Adams | 38001 | 590 | 9 | 0 | 46.09686891 | -102.5285397 | 2022-02-25 04:21:11 | Adams, North Dakota, US | |
2022-02-07 | US | Georgia | Glascock | 13125 | 590 | 23 | 0 | 33.22879932 | -82.61297636 | 2022-02-08 04:21:15 | Glascock, Georgia, US | |
2022-02-02 | US | Puerto Rico | Vieques | 72147 | 590 | 0 | 0 | 18.123276 | -65.44097099999999 | 2022-02-03 04:21:21 | Vieques, Puerto Rico, US | |
2022-01-27 | US | Kansas | Morton | 20129 | 590 | 10 | 0 | 37.19141121 | -101.79925190000002 | 2022-01-28 04:21:09 | Morton, Kansas, US | |
2022-01-26 | US | South Dakota | Buffalo | 46017 | 590 | 17 | 0 | 44.07657829 | -99.20814467 | 2022-01-27 04:21:19 | Buffalo, South Dakota, US | |
2022-01-26 | US | Kansas | Morton | 20129 | 590 | 10 | 0 | 37.19141121 | -101.79925190000002 | 2022-01-27 04:21:19 | Morton, Kansas, US | |
2022-01-25 | China | Jilin | 590 | 3 | 0 | 43.6661 | 126.1923 | 2022-01-26 04:21:07 | Jilin, China | |||
2022-01-24 | China | Jilin | 590 | 3 | 0 | 43.6661 | 126.1923 | 2022-01-25 04:21:05 | Jilin, China | |||
2022-01-23 | US | Montana | Sheridan | 30091 | 590 | 10 | 0 | 48.72085833 | -104.50382900000001 | 2022-01-24 04:21:12 | Sheridan, Montana, US | |
2022-01-23 | US | Kansas | Chase | 20017 | 590 | 6 | 0 | 38.30292938 | -96.59563862 | 2022-01-24 04:21:12 | Chase, Kansas, US | |
2022-01-23 | China | Jilin | 590 | 3 | 0 | 43.6661 | 126.1923 | 2022-01-24 04:21:12 | Jilin, China | |||
2022-01-22 | US | Montana | Sheridan | 30091 | 590 | 10 | 0 | 48.72085833 | -104.50382900000001 | 2022-01-23 04:21:13 | Sheridan, Montana, US | |
2022-01-22 | US | Kansas | Chase | 20017 | 590 | 6 | 0 | 38.30292938 | -96.59563862 | 2022-01-23 04:21:13 | Chase, Kansas, US | |
2022-01-22 | China | Jilin | 590 | 3 | 0 | 43.6661 | 126.1923 | 2022-01-23 04:21:13 | Jilin, China | |||
2022-01-21 | US | Montana | Sheridan | 30091 | 590 | 10 | 0 | 48.72085833 | -104.50382900000001 | 2022-01-22 04:21:13 | Sheridan, Montana, US | |
2022-01-21 | US | Kansas | Chase | 20017 | 590 | 6 | 0 | 38.30292938 | -96.59563862 | 2022-01-22 04:21:13 | Chase, Kansas, US | |
2022-01-21 | China | Jilin | 590 | 3 | 0 | 43.6661 | 126.1923 | 2022-01-22 04:21:13 | Jilin, China | |||
2022-01-20 | China | Jilin | 590 | 3 | 0 | 43.6661 | 126.1923 | 2022-01-21 04:21:09 | Jilin, China | |||
2022-01-19 | China | Jilin | 590 | 3 | 0 | 43.6661 | 126.1923 | 2022-01-20 04:21:07 | Jilin, China | |||
2022-01-18 | China | Jilin | 590 | 3 | 0 | 43.6661 | 126.1923 | 2022-01-19 04:21:23 | Jilin, China | |||
2022-01-17 | China | Jilin | 590 | 3 | 0 | 43.6661 | 126.1923 | 2022-01-18 04:21:04 | Jilin, China | |||
2022-01-16 | US | Colorado | Costilla | 8023 | 590 | 14 | 0 | 37.27732493 | -105.4276548 | 2022-01-17 04:21:08 | Costilla, Colorado, US | |
2022-01-16 | China | Jilin | 590 | 3 | 0 | 43.6661 | 126.1923 | 2022-01-17 04:21:08 | Jilin, China | |||
2022-01-15 | US | Texas | Shackelford | 48417 | 590 | 11 | 0 | 32.73587756 | -99.35401337 | 2022-01-16 04:21:12 | Shackelford, Texas, US | |
2022-01-15 | China | Jilin | 590 | 3 | 0 | 43.6661 | 126.1923 | 2022-01-16 04:21:12 | Jilin, China | |||
2022-01-14 | China | Jilin | 590 | 3 | 0 | 43.6661 | 126.1923 | 2022-01-15 04:21:07 | Jilin, China | |||
2022-01-13 | US | Missouri | Schuyler | 29197 | 590 | 23 | 0 | 40.46921489 | -92.52311943 | 2022-01-14 04:21:54 | Schuyler, Missouri, US | |
2022-01-13 | China | Jilin | 590 | 3 | 0 | 43.6661 | 126.1923 | 2022-01-14 04:21:54 | Jilin, China | |||
2022-01-12 | China | Jilin | 590 | 3 | 0 | 43.6661 | 126.1923 | 2022-01-13 08:00:09 | Jilin, China | |||
2022-01-11 | US | South Dakota | Bennett | 46007 | 590 | 9 | 0 | 43.19486375 | -101.6665572 | 2022-01-12 04:21:44 | Bennett, South Dakota, US | |
2022-01-11 | US | Nebraska | Stanton | 31167 | 590 | 11 | 0 | 41.9169835 | -97.19394708 | 2022-01-12 04:21:44 | Stanton, Nebraska, US | |
2022-01-11 | US | Alaska | Bristol Bay plus Lake and Peninsula | 2164 | 590 | 1 | 0 | 58.62403337 | -156.21405890000003 | 2022-01-12 04:21:44 | Bristol Bay plus Lake and Peninsula, Alaska, US | |
2022-01-11 | China | Jilin | 590 | 3 | 0 | 43.6661 | 126.1923 | 2022-01-12 04:21:44 | Jilin, China | |||
2022-01-10 | US | Alaska | Bristol Bay plus Lake and Peninsula | 2164 | 590 | 1 | 0 | 58.62403337 | -156.21405890000003 | 2022-01-11 04:22:01 | Bristol Bay plus Lake and Peninsula, Alaska, US | |
2022-01-10 | China | Jilin | 590 | 3 | 0 | 43.6661 | 126.1923 | 2022-01-11 04:22:01 | Jilin, China | |||
2022-01-09 | China | Jilin | 590 | 3 | 0 | 43.6661 | 126.1923 | 2022-01-10 04:22:07 | Jilin, China | |||
2022-01-08 | China | Jilin | 590 | 3 | 0 | 43.6661 | 126.1923 | 2022-01-09 04:21:46 | Jilin, China | |||
2022-01-07 | China | Jilin | 590 | 3 | 0 | 43.6661 | 126.1923 | 2022-01-08 04:21:53 | Jilin, China | |||
2022-01-06 | US | Texas | Kinney | 48271 | 590 | 10 | 0 | 29.34967888 | -100.41866379999999 | 2022-01-07 04:22:09 | Kinney, Texas, US | |
2022-01-06 | US | South Dakota | Marshall | 46091 | 590 | 8 | 0 | 45.75870838 | -97.59855639 | 2022-01-07 04:22:09 | Marshall, South Dakota, US | |
2022-01-06 | China | Jilin | 590 | 3 | 0 | 43.6661 | 126.1923 | 2022-01-07 04:22:09 | Jilin, China | |||
2022-01-05 | China | Jilin | 590 | 3 | 0 | 43.6661 | 126.1923 | 2022-01-06 04:22:09 | Jilin, China | |||
2022-01-03 | US | Virginia | Bath | 51017 | 590 | 15 | 0 | 38.05852573 | -79.73912095 | 2022-01-04 04:22:17 | Bath, Virginia, US | |
2022-01-02 | US | South Dakota | Douglas | 46043 | 590 | 14 | 0 | 43.38520741 | -98.36978007 | 2022-01-03 02:22:25 | Douglas, South Dakota, US | |
2022-01-02 | US | Kansas | Ness | 20135 | 590 | 17 | 0 | 38.47974157 | -99.91547333 | 2022-01-03 02:22:25 | Ness, Kansas, US | |
2022-01-01 | US | South Dakota | Douglas | 46043 | 590 | 14 | 0 | 43.38520741 | -98.36978007 | 2022-01-02 04:20:52 | Douglas, South Dakota, US | |
2022-01-01 | US | Kansas | Ness | 20135 | 590 | 17 | 0 | 38.47974157 | -99.91547333 | 2022-01-02 04:20:52 | Ness, Kansas, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;