daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
401 rows where confirmed = 1507 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-29 | US | Montana | Broadwater | 30007 | 1507 | 22 | 0 | 46.33277565 | -111.4955813 | 2022-12-30 04:21:04 | Broadwater, Montana, US | |
2022-12-28 | US | Montana | Broadwater | 30007 | 1507 | 22 | 0 | 46.33277565 | -111.4955813 | 2022-12-29 04:21:01 | Broadwater, Montana, US | |
2022-12-27 | US | Montana | Broadwater | 30007 | 1507 | 22 | 0 | 46.33277565 | -111.4955813 | 2022-12-28 04:21:04 | Broadwater, Montana, US | |
2022-12-26 | US | Montana | Broadwater | 30007 | 1507 | 22 | 0 | 46.33277565 | -111.4955813 | 2022-12-27 04:21:07 | Broadwater, Montana, US | |
2022-12-25 | US | Montana | Broadwater | 30007 | 1507 | 22 | 0 | 46.33277565 | -111.4955813 | 2022-12-26 04:21:06 | Broadwater, Montana, US | |
2022-12-24 | US | Montana | Broadwater | 30007 | 1507 | 22 | 0 | 46.33277565 | -111.4955813 | 2022-12-25 04:21:04 | Broadwater, Montana, US | |
2022-12-23 | US | Montana | Broadwater | 30007 | 1507 | 22 | 0 | 46.33277565 | -111.4955813 | 2022-12-24 04:21:02 | Broadwater, Montana, US | |
2022-12-11 | US | Virginia | Norton | 51720 | 1507 | 20 | 0 | 36.93357076 | -82.62750411 | 2022-12-12 04:21:01 | Norton, Virginia, US | |
2022-12-10 | US | Virginia | Norton | 51720 | 1507 | 20 | 0 | 36.93357076 | -82.62750411 | 2022-12-11 04:20:50 | Norton, Virginia, US | |
2022-12-09 | US | Virginia | Norton | 51720 | 1507 | 20 | 0 | 36.93357076 | -82.62750411 | 2022-12-10 04:21:02 | Norton, Virginia, US | |
2022-11-03 | US | Illinois | Alexander | 17003 | 1507 | 16 | 0 | 37.18049267 | -89.32910838 | 2022-11-04 04:22:11 | Alexander, Illinois, US | |
2022-11-02 | US | Illinois | Alexander | 17003 | 1507 | 16 | 0 | 37.18049267 | -89.32910838 | 2022-11-03 04:22:05 | Alexander, Illinois, US | |
2022-11-01 | US | Illinois | Alexander | 17003 | 1507 | 16 | 0 | 37.18049267 | -89.32910838 | 2022-11-02 04:22:09 | Alexander, Illinois, US | |
2022-10-31 | US | Illinois | Alexander | 17003 | 1507 | 16 | 0 | 37.18049267 | -89.32910838 | 2022-11-01 04:22:36 | Alexander, Illinois, US | |
2022-10-25 | US | Oregon | Wallowa | 41063 | 1507 | 22 | 0 | 45.57894064 | -117.183538 | 2022-10-26 04:22:19 | Wallowa, Oregon, US | |
2022-10-24 | US | Oregon | Wallowa | 41063 | 1507 | 22 | 0 | 45.57894064 | -117.183538 | 2022-10-25 04:21:53 | Wallowa, Oregon, US | |
2022-10-23 | US | Oregon | Wallowa | 41063 | 1507 | 22 | 0 | 45.57894064 | -117.183538 | 2022-10-24 04:22:29 | Wallowa, Oregon, US | |
2022-10-22 | US | Oregon | Wallowa | 41063 | 1507 | 22 | 0 | 45.57894064 | -117.183538 | 2022-10-23 04:22:46 | Wallowa, Oregon, US | |
2022-10-21 | US | Oregon | Wallowa | 41063 | 1507 | 22 | 0 | 45.57894064 | -117.183538 | 2022-10-22 04:22:53 | Wallowa, Oregon, US | |
2022-10-20 | US | Oregon | Wallowa | 41063 | 1507 | 22 | 0 | 45.57894064 | -117.183538 | 2022-10-21 04:22:23 | Wallowa, Oregon, US | |
2022-10-19 | US | Oregon | Wallowa | 41063 | 1507 | 22 | 0 | 45.57894064 | -117.183538 | 2022-10-20 04:22:59 | Wallowa, Oregon, US | |
2022-10-12 | China | Xinjiang | 1507 | 3 | 0 | 41.1129 | 85.2401 | 2022-10-13 04:22:39 | Xinjiang, China | |||
2022-10-11 | US | North Dakota | Sioux | 38085 | 1507 | 19 | 0 | 46.11323337 | -101.0440149 | 2022-10-12 04:22:51 | Sioux, North Dakota, US | |
2022-10-03 | China | Anhui | 1507 | 6 | 0 | 31.8257 | 117.2264 | 2022-10-04 04:22:55 | Anhui, China | |||
2022-09-14 | US | Virginia | Emporia | 51595 | 1507 | 55 | 0 | 36.69455571 | -77.53406129 | 2022-09-15 04:21:02 | Emporia, Virginia, US | |
2022-09-13 | US | Virginia | Emporia | 51595 | 1507 | 55 | 0 | 36.69455571 | -77.53406129 | 2022-09-14 04:20:44 | Emporia, Virginia, US | |
2022-09-12 | US | Virginia | Emporia | 51595 | 1507 | 55 | 0 | 36.69455571 | -77.53406129 | 2022-09-13 04:20:57 | Emporia, Virginia, US | |
2022-09-06 | US | Kansas | Rooks | 20163 | 1507 | 21 | 0 | 39.35022773 | -99.32484567 | 2022-09-07 04:20:59 | Rooks, Kansas, US | |
2022-09-05 | US | Kansas | Rooks | 20163 | 1507 | 21 | 0 | 39.35022773 | -99.32484567 | 2022-09-06 04:21:02 | Rooks, Kansas, US | |
2022-09-04 | US | Kansas | Rooks | 20163 | 1507 | 21 | 0 | 39.35022773 | -99.32484567 | 2022-09-05 04:21:01 | Rooks, Kansas, US | |
2022-09-03 | US | Kansas | Rooks | 20163 | 1507 | 21 | 0 | 39.35022773 | -99.32484567 | 2022-09-04 04:21:22 | Rooks, Kansas, US | |
2022-09-02 | US | Kansas | Rooks | 20163 | 1507 | 21 | 0 | 39.35022773 | -99.32484567 | 2022-09-03 04:21:04 | Rooks, Kansas, US | |
2022-09-01 | US | Kansas | Rooks | 20163 | 1507 | 21 | 0 | 39.35022773 | -99.32484567 | 2022-09-02 04:21:07 | Rooks, Kansas, US | |
2022-08-31 | US | Kansas | Rooks | 20163 | 1507 | 21 | 0 | 39.35022773 | -99.32484567 | 2022-09-01 04:21:03 | Rooks, Kansas, US | |
2022-08-23 | US | Iowa | Van Buren | 19177 | 1507 | 27 | 0 | 40.75326764 | -91.95017958 | 2022-08-24 04:20:46 | Van Buren, Iowa, US | |
2022-08-22 | US | Iowa | Van Buren | 19177 | 1507 | 27 | 0 | 40.75326764 | -91.95017958 | 2022-08-23 04:20:56 | Van Buren, Iowa, US | |
2022-08-21 | US | Iowa | Van Buren | 19177 | 1507 | 27 | 0 | 40.75326764 | -91.95017958 | 2022-08-22 04:20:38 | Van Buren, Iowa, US | |
2022-08-20 | US | Iowa | Van Buren | 19177 | 1507 | 27 | 0 | 40.75326764 | -91.95017958 | 2022-08-21 04:20:44 | Van Buren, Iowa, US | |
2022-08-19 | US | Iowa | Van Buren | 19177 | 1507 | 27 | 0 | 40.75326764 | -91.95017958 | 2022-08-20 04:21:01 | Van Buren, Iowa, US | |
2022-08-18 | US | Iowa | Van Buren | 19177 | 1507 | 27 | 0 | 40.75326764 | -91.95017958 | 2022-08-19 04:20:54 | Van Buren, Iowa, US | |
2022-08-17 | US | Iowa | Van Buren | 19177 | 1507 | 27 | 0 | 40.75326764 | -91.95017958 | 2022-08-18 04:21:11 | Van Buren, Iowa, US | |
2022-08-02 | US | South Dakota | Brule | 46015 | 1507 | 22 | 0 | 43.71756379 | -99.08118954 | 2022-08-03 04:20:59 | Brule, South Dakota, US | |
2022-08-01 | US | South Dakota | Brule | 46015 | 1507 | 22 | 0 | 43.71756379 | -99.08118954 | 2022-08-02 04:20:53 | Brule, South Dakota, US | |
2022-07-31 | US | South Dakota | Brule | 46015 | 1507 | 22 | 0 | 43.71756379 | -99.08118954 | 2022-08-01 04:21:03 | Brule, South Dakota, US | |
2022-07-30 | US | South Dakota | Brule | 46015 | 1507 | 22 | 0 | 43.71756379 | -99.08118954 | 2022-07-31 04:21:02 | Brule, South Dakota, US | |
2022-07-29 | US | South Dakota | Brule | 46015 | 1507 | 22 | 0 | 43.71756379 | -99.08118954 | 2022-07-30 04:20:42 | Brule, South Dakota, US | |
2022-07-28 | US | South Dakota | Brule | 46015 | 1507 | 22 | 0 | 43.71756379 | -99.08118954 | 2022-07-29 04:20:45 | Brule, South Dakota, US | |
2022-07-27 | US | South Dakota | Brule | 46015 | 1507 | 22 | 0 | 43.71756379 | -99.08118954 | 2022-07-28 04:20:56 | Brule, South Dakota, US | |
2022-07-25 | US | Oregon | Lake | 41037 | 1507 | 29 | 0 | 42.79246693 | -120.3850163 | 2022-07-26 04:20:58 | Lake, Oregon, US | |
2022-07-24 | US | Oregon | Lake | 41037 | 1507 | 29 | 0 | 42.79246693 | -120.3850163 | 2022-07-25 04:20:51 | Lake, Oregon, US | |
2022-07-23 | US | Oregon | Lake | 41037 | 1507 | 29 | 0 | 42.79246693 | -120.3850163 | 2022-07-24 04:20:47 | Lake, Oregon, US | |
2022-07-22 | US | Oregon | Lake | 41037 | 1507 | 29 | 0 | 42.79246693 | -120.3850163 | 2022-07-23 04:20:53 | Lake, Oregon, US | |
2022-07-14 | US | Indiana | Ohio | 18115 | 1507 | 19 | 0 | 38.955305 | -84.96515993 | 2022-07-15 04:20:53 | Ohio, Indiana, US | |
2022-07-13 | US | Indiana | Ohio | 18115 | 1507 | 19 | 0 | 38.955305 | -84.96515993 | 2022-07-14 04:20:57 | Ohio, Indiana, US | |
2022-06-23 | US | Idaho | Caribou | 16029 | 1507 | 26 | 0 | 42.77149116 | -111.5597683 | 2022-06-24 04:20:58 | Caribou, Idaho, US | |
2022-06-22 | US | Idaho | Caribou | 16029 | 1507 | 26 | 0 | 42.77149116 | -111.5597683 | 2022-06-23 04:20:55 | Caribou, Idaho, US | |
2022-06-13 | US | North Dakota | Dickey | 38021 | 1507 | 39 | 0 | 46.11017712 | -98.5049008 | 2022-06-14 04:20:52 | Dickey, North Dakota, US | |
2022-06-12 | US | North Dakota | Dickey | 38021 | 1507 | 39 | 0 | 46.11017712 | -98.5049008 | 2022-06-13 04:21:14 | Dickey, North Dakota, US | |
2022-06-11 | US | North Dakota | Dickey | 38021 | 1507 | 39 | 0 | 46.11017712 | -98.5049008 | 2022-06-12 04:20:53 | Dickey, North Dakota, US | |
2022-06-10 | US | North Dakota | Dickey | 38021 | 1507 | 39 | 0 | 46.11017712 | -98.5049008 | 2022-06-11 04:21:01 | Dickey, North Dakota, US | |
2022-06-09 | US | North Dakota | Dickey | 38021 | 1507 | 39 | 0 | 46.11017712 | -98.5049008 | 2022-06-10 04:20:55 | Dickey, North Dakota, US | |
2022-06-07 | US | Georgia | Jenkins | 13165 | 1507 | 66 | 0 | 32.79248718 | -81.96040187 | 2022-06-08 04:20:55 | Jenkins, Georgia, US | |
2022-06-06 | US | Georgia | Jenkins | 13165 | 1507 | 66 | 0 | 32.79248718 | -81.96040187 | 2022-06-07 04:21:08 | Jenkins, Georgia, US | |
2022-06-05 | US | Georgia | Jenkins | 13165 | 1507 | 66 | 0 | 32.79248718 | -81.96040187 | 2022-06-06 04:20:57 | Jenkins, Georgia, US | |
2022-06-04 | US | Georgia | Jenkins | 13165 | 1507 | 66 | 0 | 32.79248718 | -81.96040187 | 2022-06-05 04:20:55 | Jenkins, Georgia, US | |
2022-06-03 | US | Georgia | Jenkins | 13165 | 1507 | 66 | 0 | 32.79248718 | -81.96040187 | 2022-06-04 04:20:58 | Jenkins, Georgia, US | |
2022-06-02 | US | Georgia | Jenkins | 13165 | 1507 | 66 | 0 | 32.79248718 | -81.96040187 | 2022-06-03 04:20:58 | Jenkins, Georgia, US | |
2022-06-01 | US | Georgia | Jenkins | 13165 | 1507 | 66 | 0 | 32.79248718 | -81.96040187 | 2022-06-02 05:20:39 | Jenkins, Georgia, US | |
2022-04-30 | US | Puerto Rico | Guanica | 72055 | 1507 | 0 | 0 | 17.982429 | -66.919643 | 2022-05-01 04:20:57 | Guanica, Puerto Rico, US | |
2022-04-28 | US | Washington | Skamania | 53059 | 1507 | 13 | 0 | 46.02408726 | -121.9164403 | 2022-04-29 04:20:59 | Skamania, Washington, US | |
2022-04-27 | US | Washington | Skamania | 53059 | 1507 | 13 | 0 | 46.02408726 | -121.9164403 | 2022-04-28 04:20:47 | Skamania, Washington, US | |
2022-04-11 | US | Texas | Jack | 48237 | 1507 | 28 | 0 | 33.23377248 | -98.17283469 | 2022-04-12 04:20:49 | Jack, Texas, US | |
2022-04-10 | US | Texas | Jack | 48237 | 1507 | 28 | 0 | 33.23377248 | -98.17283469 | 2022-04-11 04:21:02 | Jack, Texas, US | |
2022-04-09 | US | Texas | Jack | 48237 | 1507 | 28 | 0 | 33.23377248 | -98.17283469 | 2022-04-10 04:20:52 | Jack, Texas, US | |
2022-04-07 | US | Nebraska | Cedar | 31027 | 1507 | 14 | 0 | 42.598885100000004 | -97.25311951 | 2022-04-08 04:20:48 | Cedar, Nebraska, US | |
2022-04-06 | US | Nebraska | Cedar | 31027 | 1507 | 14 | 0 | 42.598885100000004 | -97.25311951 | 2022-04-07 04:20:53 | Cedar, Nebraska, US | |
2022-04-05 | US | Nebraska | Cedar | 31027 | 1507 | 14 | 0 | 42.598885100000004 | -97.25311951 | 2022-04-06 04:20:49 | Cedar, Nebraska, US | |
2022-04-03 | US | Georgia | Marion | 13197 | 1507 | 50 | 0 | 32.3483402 | -84.52733571 | 2022-04-04 04:20:51 | Marion, Georgia, US | |
2022-04-02 | US | Georgia | Marion | 13197 | 1507 | 50 | 0 | 32.3483402 | -84.52733571 | 2022-04-03 04:20:48 | Marion, Georgia, US | |
2022-04-01 | US | Nebraska | Cedar | 31027 | 1507 | 14 | 0 | 42.598885100000004 | -97.25311951 | 2022-04-02 04:20:47 | Cedar, Nebraska, US | |
2022-04-01 | US | Georgia | Marion | 13197 | 1507 | 50 | 0 | 32.3483402 | -84.52733571 | 2022-04-02 04:20:47 | Marion, Georgia, US | |
2022-03-31 | US | Georgia | Marion | 13197 | 1507 | 50 | 0 | 32.3483402 | -84.52733571 | 2022-04-01 04:20:28 | Marion, Georgia, US | |
2022-03-30 | US | Georgia | Marion | 13197 | 1507 | 50 | 0 | 32.3483402 | -84.52733571 | 2022-03-31 04:20:56 | Marion, Georgia, US | |
2022-03-24 | US | Kansas | Sherman | 20181 | 1507 | 20 | 0 | 39.35147699 | -101.71976240000001 | 2022-03-25 04:20:46 | Sherman, Kansas, US | |
2022-03-23 | US | Kansas | Sherman | 20181 | 1507 | 20 | 0 | 39.35147699 | -101.71976240000001 | 2022-03-24 04:20:43 | Sherman, Kansas, US | |
2022-03-17 | US | Texas | Carson | 48065 | 1507 | 34 | 0 | 35.40365929 | -101.35426690000001 | 2022-03-18 04:20:55 | Carson, Texas, US | |
2022-03-15 | US | Nebraska | Cedar | 31027 | 1507 | 11 | 0 | 42.598885100000004 | -97.25311951 | 2022-03-16 04:20:50 | Cedar, Nebraska, US | |
2022-02-15 | China | Fujian | 1507 | 1 | 0 | 26.0789 | 117.9874 | 2022-02-16 04:21:10 | Fujian, China | |||
2022-02-10 | US | Georgia | Twiggs | 13289 | 1507 | 66 | 0 | 32.67435595 | -83.43078662 | 2022-02-11 04:21:09 | Twiggs, Georgia, US | |
2022-02-03 | US | Minnesota | Wilkin | 27167 | 1507 | 20 | 0 | 46.35721532 | -96.4684375 | 2022-02-04 04:21:10 | Wilkin, Minnesota, US | |
2022-01-31 | US | Missouri | Clark | 29045 | 1507 | 28 | 0 | 40.41040752 | -91.73661677 | 2022-02-01 04:21:11 | Clark, Missouri, US | |
2022-01-31 | US | Georgia | Hancock | 13141 | 1507 | 86 | 0 | 33.2721566 | -82.99766919 | 2022-02-01 04:21:11 | Hancock, Georgia, US | |
2022-01-23 | US | Nebraska | Merrick | 31121 | 1507 | 15 | 0 | 41.16624273 | -98.0374887 | 2022-01-24 04:21:12 | Merrick, Nebraska, US | |
2022-01-23 | US | Georgia | Crawford | 13079 | 1507 | 48 | 0 | 32.71391813 | -83.98061238 | 2022-01-24 04:21:12 | Crawford, Georgia, US | |
2022-01-22 | US | Texas | Coleman | 48083 | 1507 | 64 | 0 | 31.76736834 | -99.45240766 | 2022-01-23 04:21:13 | Coleman, Texas, US | |
2022-01-22 | US | Nebraska | Merrick | 31121 | 1507 | 15 | 0 | 41.16624273 | -98.0374887 | 2022-01-23 04:21:13 | Merrick, Nebraska, US | |
2022-01-22 | US | Georgia | Crawford | 13079 | 1507 | 48 | 0 | 32.71391813 | -83.98061238 | 2022-01-23 04:21:13 | Crawford, Georgia, US | |
2022-01-21 | US | Nebraska | Merrick | 31121 | 1507 | 15 | 0 | 41.16624273 | -98.0374887 | 2022-01-22 04:21:13 | Merrick, Nebraska, US | |
2022-01-21 | US | Georgia | Crawford | 13079 | 1507 | 48 | 0 | 32.71391813 | -83.98061238 | 2022-01-22 04:21:13 | Crawford, Georgia, US | |
2022-01-20 | US | Georgia | Miller | 13201 | 1507 | 25 | 0 | 31.16568912 | -84.73151117 | 2022-01-21 04:21:09 | Miller, Georgia, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;