daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
226 rows where confirmed = 3305 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-11-26 | China | Jiangsu | 3305 | 0 | 0 | 32.9711 | 119.455 | 2022-11-27 04:21:05 | Jiangsu, China | |||
2022-11-25 | China | Jiangsu | 3305 | 0 | 0 | 32.9711 | 119.455 | 2022-11-26 04:21:11 | Jiangsu, China | |||
2022-11-22 | US | Washington | Unassigned | 90053 | 3305 | 6 | 0 | 48.82227976 | 0.0 | 2022-11-23 04:21:06 | Unassigned, Washington, US | |
2022-11-22 | China | Yunnan | 3305 | 2 | 0 | 24.974 | 101.487 | 2022-11-23 04:21:06 | Yunnan, China | |||
2022-11-21 | US | Washington | Unassigned | 90053 | 3305 | 6 | 0 | 48.82227976 | 0.0 | 2022-11-22 04:20:47 | Unassigned, Washington, US | |
2022-11-21 | China | Yunnan | 3305 | 2 | 0 | 24.974 | 101.487 | 2022-11-22 04:20:47 | Yunnan, China | |||
2022-11-20 | US | Washington | Unassigned | 90053 | 3305 | 6 | 0 | 48.82227976 | 0.0 | 2022-11-21 04:21:05 | Unassigned, Washington, US | |
2022-11-19 | US | Washington | Unassigned | 90053 | 3305 | 6 | 0 | 48.82227976 | 0.0 | 2022-11-20 04:21:08 | Unassigned, Washington, US | |
2022-11-18 | US | Washington | Unassigned | 90053 | 3305 | 6 | 0 | 48.82227976 | 0.0 | 2022-11-19 04:21:14 | Unassigned, Washington, US | |
2022-11-17 | US | Washington | Unassigned | 90053 | 3305 | 6 | 0 | 48.82227976 | 0.0 | 2022-11-18 04:21:15 | Unassigned, Washington, US | |
2022-11-16 | US | Washington | Unassigned | 90053 | 3305 | 6 | 0 | 48.82227976 | 0.0 | 2022-11-17 04:21:11 | Unassigned, Washington, US | |
2022-10-18 | US | Iowa | Winnebago | 19189 | 3305 | 47 | 0 | 43.37751174 | -93.73407298 | 2022-10-19 04:22:26 | Winnebago, Iowa, US | |
2022-10-17 | US | Iowa | Winnebago | 19189 | 3305 | 47 | 0 | 43.37751174 | -93.73407298 | 2022-10-18 04:22:42 | Winnebago, Iowa, US | |
2022-10-16 | US | Iowa | Winnebago | 19189 | 3305 | 47 | 0 | 43.37751174 | -93.73407298 | 2022-10-17 04:20:31 | Winnebago, Iowa, US | |
2022-10-15 | US | Iowa | Winnebago | 19189 | 3305 | 47 | 0 | 43.37751174 | -93.73407298 | 2022-10-16 04:22:39 | Winnebago, Iowa, US | |
2022-10-14 | US | Iowa | Winnebago | 19189 | 3305 | 47 | 0 | 43.37751174 | -93.73407298 | 2022-10-15 04:22:00 | Winnebago, Iowa, US | |
2022-10-13 | US | Iowa | Winnebago | 19189 | 3305 | 47 | 0 | 43.37751174 | -93.73407298 | 2022-10-14 04:22:28 | Winnebago, Iowa, US | |
2022-10-12 | US | Iowa | Winnebago | 19189 | 3305 | 47 | 0 | 43.37751174 | -93.73407298 | 2022-10-13 04:22:39 | Winnebago, Iowa, US | |
2022-10-10 | US | Michigan | Iron | 26071 | 3305 | 95 | 0 | 46.20974132 | -88.53136251 | 2022-10-11 04:23:05 | Iron, Michigan, US | |
2022-10-09 | US | Michigan | Iron | 26071 | 3305 | 95 | 0 | 46.20974132 | -88.53136251 | 2022-10-10 04:22:32 | Iron, Michigan, US | |
2022-10-08 | US | Michigan | Iron | 26071 | 3305 | 95 | 0 | 46.20974132 | -88.53136251 | 2022-10-09 04:21:16 | Iron, Michigan, US | |
2022-10-07 | US | Michigan | Iron | 26071 | 3305 | 95 | 0 | 46.20974132 | -88.53136251 | 2022-10-08 04:22:56 | Iron, Michigan, US | |
2022-10-06 | US | Michigan | Iron | 26071 | 3305 | 95 | 0 | 46.20974132 | -88.53136251 | 2022-10-07 04:23:08 | Iron, Michigan, US | |
2022-10-05 | US | Michigan | Iron | 26071 | 3305 | 95 | 0 | 46.20974132 | -88.53136251 | 2022-10-06 04:21:22 | Iron, Michigan, US | |
2022-10-04 | US | Michigan | Iron | 26071 | 3305 | 95 | 0 | 46.20974132 | -88.53136251 | 2022-10-05 04:23:06 | Iron, Michigan, US | |
2022-09-22 | US | Washington | Unassigned | 90053 | 3305 | 6 | 0 | 48.82227976 | 0.0 | 2022-09-23 04:23:13 | Unassigned, Washington, US | |
2022-09-22 | US | Montana | Custer | 30017 | 3305 | 50 | 0 | 46.25319932 | -105.5737526 | 2022-09-23 04:23:13 | Custer, Montana, US | |
2022-09-21 | US | Washington | Unassigned | 90053 | 3305 | 6 | 0 | 48.82227976 | 0.0 | 2022-09-22 04:22:56 | Unassigned, Washington, US | |
2022-09-21 | US | Montana | Custer | 30017 | 3305 | 50 | 0 | 46.25319932 | -105.5737526 | 2022-09-22 04:22:56 | Custer, Montana, US | |
2022-09-20 | US | Montana | Custer | 30017 | 3305 | 50 | 0 | 46.25319932 | -105.5737526 | 2022-09-21 04:23:22 | Custer, Montana, US | |
2022-09-19 | US | Montana | Custer | 30017 | 3305 | 50 | 0 | 46.25319932 | -105.5737526 | 2022-09-20 04:22:48 | Custer, Montana, US | |
2022-09-18 | US | Montana | Custer | 30017 | 3305 | 50 | 0 | 46.25319932 | -105.5737526 | 2022-09-19 04:21:49 | Custer, Montana, US | |
2022-09-17 | US | Montana | Custer | 30017 | 3305 | 50 | 0 | 46.25319932 | -105.5737526 | 2022-09-18 04:22:50 | Custer, Montana, US | |
2022-09-16 | US | Montana | Custer | 30017 | 3305 | 50 | 0 | 46.25319932 | -105.5737526 | 2022-09-17 04:20:19 | Custer, Montana, US | |
2022-09-07 | US | Oklahoma | Noble | 40103 | 3305 | 42 | 0 | 36.38953329 | -97.22928674 | 2022-09-08 04:21:02 | Noble, Oklahoma, US | |
2022-09-07 | US | Alabama | Conecuh | 1035 | 3305 | 72 | 0 | 31.43401703 | -86.99320044 | 2022-09-08 04:21:02 | Conecuh, Alabama, US | |
2022-09-06 | US | Oklahoma | Noble | 40103 | 3305 | 42 | 0 | 36.38953329 | -97.22928674 | 2022-09-07 04:20:59 | Noble, Oklahoma, US | |
2022-09-06 | US | Idaho | Idaho | 16049 | 3305 | 54 | 0 | 45.84721541 | -115.4634436 | 2022-09-07 04:20:59 | Idaho, Idaho, US | |
2022-09-06 | US | Alabama | Conecuh | 1035 | 3305 | 72 | 0 | 31.43401703 | -86.99320044 | 2022-09-07 04:20:59 | Conecuh, Alabama, US | |
2022-09-06 | China | Henan | 3305 | 22 | 0 | 33.882 | 113.614 | 2022-09-07 04:20:59 | Henan, China | |||
2022-09-05 | US | Oklahoma | Noble | 40103 | 3305 | 42 | 0 | 36.38953329 | -97.22928674 | 2022-09-06 04:21:02 | Noble, Oklahoma, US | |
2022-09-05 | US | Idaho | Idaho | 16049 | 3305 | 54 | 0 | 45.84721541 | -115.4634436 | 2022-09-06 04:21:02 | Idaho, Idaho, US | |
2022-09-05 | US | Alabama | Conecuh | 1035 | 3305 | 72 | 0 | 31.43401703 | -86.99320044 | 2022-09-06 04:21:02 | Conecuh, Alabama, US | |
2022-09-05 | China | Henan | 3305 | 22 | 0 | 33.882 | 113.614 | 2022-09-06 04:21:02 | Henan, China | |||
2022-09-04 | US | Oklahoma | Noble | 40103 | 3305 | 42 | 0 | 36.38953329 | -97.22928674 | 2022-09-05 04:21:01 | Noble, Oklahoma, US | |
2022-09-04 | US | Idaho | Idaho | 16049 | 3305 | 54 | 0 | 45.84721541 | -115.4634436 | 2022-09-05 04:21:01 | Idaho, Idaho, US | |
2022-09-04 | US | Alabama | Conecuh | 1035 | 3305 | 72 | 0 | 31.43401703 | -86.99320044 | 2022-09-05 04:21:01 | Conecuh, Alabama, US | |
2022-09-04 | China | Henan | 3305 | 22 | 0 | 33.882 | 113.614 | 2022-09-05 04:21:01 | Henan, China | |||
2022-09-03 | US | Oklahoma | Noble | 40103 | 3305 | 42 | 0 | 36.38953329 | -97.22928674 | 2022-09-04 04:21:22 | Noble, Oklahoma, US | |
2022-09-03 | US | Idaho | Idaho | 16049 | 3305 | 54 | 0 | 45.84721541 | -115.4634436 | 2022-09-04 04:21:22 | Idaho, Idaho, US | |
2022-09-03 | US | Alabama | Conecuh | 1035 | 3305 | 72 | 0 | 31.43401703 | -86.99320044 | 2022-09-04 04:21:22 | Conecuh, Alabama, US | |
2022-09-02 | US | Oklahoma | Noble | 40103 | 3305 | 42 | 0 | 36.38953329 | -97.22928674 | 2022-09-03 04:21:04 | Noble, Oklahoma, US | |
2022-09-02 | US | Idaho | Idaho | 16049 | 3305 | 54 | 0 | 45.84721541 | -115.4634436 | 2022-09-03 04:21:04 | Idaho, Idaho, US | |
2022-09-02 | US | Alabama | Conecuh | 1035 | 3305 | 72 | 0 | 31.43401703 | -86.99320044 | 2022-09-03 04:21:04 | Conecuh, Alabama, US | |
2022-09-01 | US | Oklahoma | Noble | 40103 | 3305 | 42 | 0 | 36.38953329 | -97.22928674 | 2022-09-02 04:21:07 | Noble, Oklahoma, US | |
2022-09-01 | US | Alabama | Conecuh | 1035 | 3305 | 72 | 0 | 31.43401703 | -86.99320044 | 2022-09-02 04:21:07 | Conecuh, Alabama, US | |
2022-08-26 | US | Arkansas | Stone | 5137 | 3305 | 69 | 0 | 35.86251946 | -92.15684085 | 2022-08-27 04:20:57 | Stone, Arkansas, US | |
2022-07-31 | US | Arkansas | Desha | 5041 | 3305 | 41 | 0 | 33.83011025 | -91.25500948 | 2022-08-01 04:21:03 | Desha, Arkansas, US | |
2022-07-26 | US | Iowa | Madison | 19121 | 3305 | 41 | 0 | 41.33081904 | -94.01554631 | 2022-07-27 04:21:04 | Madison, Iowa, US | |
2022-07-25 | US | Iowa | Madison | 19121 | 3305 | 41 | 0 | 41.33081904 | -94.01554631 | 2022-07-26 04:20:58 | Madison, Iowa, US | |
2022-07-24 | US | Iowa | Madison | 19121 | 3305 | 41 | 0 | 41.33081904 | -94.01554631 | 2022-07-25 04:20:51 | Madison, Iowa, US | |
2022-07-23 | US | Iowa | Madison | 19121 | 3305 | 41 | 0 | 41.33081904 | -94.01554631 | 2022-07-24 04:20:47 | Madison, Iowa, US | |
2022-07-22 | US | Iowa | Madison | 19121 | 3305 | 41 | 0 | 41.33081904 | -94.01554631 | 2022-07-23 04:20:53 | Madison, Iowa, US | |
2022-07-21 | US | Iowa | Madison | 19121 | 3305 | 41 | 0 | 41.33081904 | -94.01554631 | 2022-07-22 04:21:15 | Madison, Iowa, US | |
2022-07-21 | US | Colorado | Moffat | 8081 | 3305 | 53 | 0 | 40.61810999 | -108.2070876 | 2022-07-22 04:21:15 | Moffat, Colorado, US | |
2022-07-20 | US | Iowa | Madison | 19121 | 3305 | 41 | 0 | 41.33081904 | -94.01554631 | 2022-07-21 04:21:10 | Madison, Iowa, US | |
2022-07-06 | US | California | Mono | 6051 | 3305 | 7 | 0 | 37.93899289 | -118.8872409 | 2022-07-07 04:20:55 | Mono, California, US | |
2022-06-23 | US | Maryland | Kent | 24029 | 3305 | 70 | 0 | 39.24976208 | -76.04741541 | 2022-06-24 04:20:58 | Kent, Maryland, US | |
2022-06-20 | US | Arkansas | Little River | 5081 | 3305 | 105 | 0 | 33.70375665 | -94.23468591 | 2022-06-21 04:20:56 | Little River, Arkansas, US | |
2022-06-19 | US | Arkansas | Little River | 5081 | 3305 | 105 | 0 | 33.70375665 | -94.23468591 | 2022-06-20 04:21:01 | Little River, Arkansas, US | |
2022-06-16 | China | Shaanxi | 3305 | 3 | 0 | 35.1917 | 108.8701 | 2022-06-17 04:20:56 | Shaanxi, China | |||
2022-06-14 | US | Washington | Unassigned | 90053 | 3305 | 6 | 0 | 48.82227976 | 0.0 | 2022-06-15 04:20:54 | Unassigned, Washington, US | |
2022-06-13 | US | Washington | Unassigned | 90053 | 3305 | 6 | 0 | 48.82227976 | 0.0 | 2022-06-14 04:20:52 | Unassigned, Washington, US | |
2022-06-09 | US | North Dakota | Mountrail | 38061 | 3305 | 37 | 0 | 48.20197971 | -102.3555315 | 2022-06-10 04:20:55 | Mountrail, North Dakota, US | |
2022-05-19 | US | Virginia | Westmoreland | 51193 | 3305 | 52 | 0 | 38.11021557 | -76.80213247 | 2022-05-20 04:20:57 | Westmoreland, Virginia, US | |
2022-03-27 | US | New Jersey | Unassigned | 90034 | 3305 | 0 | 0 | 41.13891592 | 0.0 | 2022-03-28 04:20:33 | Unassigned, New Jersey, US | |
2022-03-19 | US | Puerto Rico | Lares | 72081 | 3305 | 0 | 0 | 18.269035000000002 | -66.867236 | 2022-03-20 04:20:45 | Lares, Puerto Rico, US | |
2022-03-04 | US | New York | Yates | 36123 | 3305 | 39 | 0 | 42.63505484 | -77.10369919 | 2022-03-05 04:21:10 | Yates, New York, US | |
2022-03-03 | US | New York | Yates | 36123 | 3305 | 39 | 0 | 42.63505484 | -77.10369919 | 2022-03-04 04:21:09 | Yates, New York, US | |
2022-02-19 | US | Puerto Rico | Aibonito | 72009 | 3305 | 0 | 0 | 18.131361 | -66.264131 | 2022-02-20 04:21:00 | Aibonito, Puerto Rico, US | |
2022-02-10 | US | Colorado | Crowley | 8025 | 3305 | 29 | 0 | 38.32608609 | -103.7844965 | 2022-02-11 04:21:09 | Crowley, Colorado, US | |
2022-01-27 | US | South Dakota | Clay | 46027 | 3305 | 19 | 0 | 42.91296147 | -96.97656917 | 2022-01-28 04:21:09 | Clay, South Dakota, US | |
2022-01-25 | US | Colorado | Las Animas | 8071 | 3305 | 39 | 0 | 37.3153406 | -104.03764579999999 | 2022-01-26 04:21:07 | Las Animas, Colorado, US | |
2022-01-24 | US | Illinois | Wabash | 17185 | 3305 | 19 | 0 | 38.44272901 | -87.84922065 | 2022-01-25 04:21:05 | Wabash, Illinois, US | |
2022-01-18 | US | Arkansas | Howard | 5061 | 3305 | 39 | 0 | 34.09007427 | -93.9934871 | 2022-01-19 04:21:23 | Howard, Arkansas, US | |
2022-01-13 | US | West Virginia | Wetzel | 54103 | 3305 | 68 | 0 | 39.6065771 | -80.64016540000001 | 2022-01-14 04:21:54 | Wetzel, West Virginia, US | |
2022-01-11 | US | West Virginia | Hardy | 54031 | 3305 | 41 | 0 | 39.00683177 | -78.85855301 | 2022-01-12 04:21:44 | Hardy, West Virginia, US | |
2021-12-29 | US | Mississippi | Clay | 28025 | 3305 | 78 | 0 | 33.65358105 | -88.77784255 | 2021-12-30 04:21:25 | Clay, Mississippi, US | |
2021-12-28 | US | Idaho | Minidoka | 16067 | 3305 | 53 | 0 | 42.85518524 | -113.6357257 | 2021-12-29 03:21:43 | Minidoka, Idaho, US | |
2021-12-16 | US | Hawaii | Kauai | 15007 | 3305 | 13 | 0 | 22.03935037 | -159.5966786 | 2021-12-17 04:22:14 | Kauai, Hawaii, US | |
2021-12-01 | US | North Carolina | Caswell | 37033 | 3305 | 38 | 0 | 36.39312665 | -79.33353281 | 2021-12-02 04:22:37 | Caswell, North Carolina, US | |
2021-11-14 | US | Washington | Adams | 53001 | 3305 | 33 | 0 | 46.98299757 | -118.56017340000001 | 2021-11-15 04:21:36 | Adams, Washington, US | |
2021-11-13 | US | Washington | Adams | 53001 | 3305 | 33 | 0 | 46.98299757 | -118.56017340000001 | 2021-11-14 04:21:31 | Adams, Washington, US | |
2021-11-12 | US | Washington | Adams | 53001 | 3305 | 33 | 0 | 46.98299757 | -118.56017340000001 | 2021-11-13 04:21:38 | Adams, Washington, US | |
2021-11-09 | US | Kansas | Sumner | 20191 | 3305 | 61 | 0 | 37.23682549 | -97.47721621 | 2021-11-10 04:21:38 | Sumner, Kansas, US | |
2021-11-08 | US | Kansas | Sumner | 20191 | 3305 | 61 | 0 | 37.23682549 | -97.47721621 | 2021-11-09 04:21:36 | Sumner, Kansas, US | |
2021-11-07 | US | Indiana | Starke | 18149 | 3305 | 72 | 0 | 41.27890281 | -86.64686895 | 2021-11-08 04:21:43 | Starke, Indiana, US | |
2021-11-03 | US | Maryland | Garrett | 24023 | 3305 | 81 | 0 | 39.52786077 | -79.27355126 | 2021-11-04 04:22:20 | Garrett, Maryland, US | |
2021-11-01 | US | Oregon | Lincoln | 41041 | 3305 | 41 | 0 | 44.64252874 | -123.86991200000001 | 2021-11-02 04:22:03 | Lincoln, Oregon, US | |
2021-11-01 | US | Arkansas | Lawrence | 5075 | 3305 | 57 | 0 | 36.04188196 | -91.10867198 | 2021-11-02 04:22:03 | Lawrence, Arkansas, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;