daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
297 rows where confirmed = 2379 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 12
- US 273
- China 6
- Sweden 5
- Japan 3
- Cyprus 2
- Netherlands 2
- Chile 1
- Colombia 1
- Malaysia 1
- Mexico 1
- Saint Vincent and the Grenadines 1
- United Kingdom 1
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-11-26 | China | Guangxi | 2379 | 2 | 0 | 23.8298 | 108.7881 | 2022-11-27 04:21:05 | Guangxi, China | |||
2022-11-16 | US | North Dakota | Traill | 38097 | 2379 | 26 | 0 | 47.45367788 | -97.16323288 | 2022-11-17 04:21:11 | Traill, North Dakota, US | |
2022-11-02 | US | Minnesota | Clearwater | 27029 | 2379 | 32 | 0 | 47.57992111 | -95.37790562 | 2022-11-03 04:22:05 | Clearwater, Minnesota, US | |
2022-11-01 | US | Minnesota | Clearwater | 27029 | 2379 | 32 | 0 | 47.57992111 | -95.37790562 | 2022-11-02 04:22:09 | Clearwater, Minnesota, US | |
2022-10-31 | US | Minnesota | Clearwater | 27029 | 2379 | 32 | 0 | 47.57992111 | -95.37790562 | 2022-11-01 04:22:36 | Clearwater, Minnesota, US | |
2022-10-30 | US | Minnesota | Clearwater | 27029 | 2379 | 32 | 0 | 47.57992111 | -95.37790562 | 2022-10-31 04:21:36 | Clearwater, Minnesota, US | |
2022-10-29 | US | Minnesota | Clearwater | 27029 | 2379 | 32 | 0 | 47.57992111 | -95.37790562 | 2022-10-30 04:22:14 | Clearwater, Minnesota, US | |
2022-10-28 | US | Minnesota | Clearwater | 27029 | 2379 | 32 | 0 | 47.57992111 | -95.37790562 | 2022-10-29 04:21:13 | Clearwater, Minnesota, US | |
2022-10-27 | US | Minnesota | Clearwater | 27029 | 2379 | 32 | 0 | 47.57992111 | -95.37790562 | 2022-10-28 04:22:31 | Clearwater, Minnesota, US | |
2022-10-02 | China | Tianjin | 2379 | 3 | 0 | 39.3054 | 117.323 | 2022-10-03 04:23:11 | Tianjin, China | |||
2022-09-20 | China | Jiangsu | 2379 | 0 | 0 | 32.9711 | 119.455 | 2022-09-21 04:23:22 | Jiangsu, China | |||
2022-09-19 | China | Jiangsu | 2379 | 0 | 0 | 32.9711 | 119.455 | 2022-09-20 04:22:48 | Jiangsu, China | |||
2022-09-12 | US | West Virginia | Doddridge | 54017 | 2379 | 18 | 0 | 39.27057157 | -80.70671527 | 2022-09-13 04:20:57 | Doddridge, West Virginia, US | |
2022-09-12 | US | Virginia | Fairfax City | 51600 | 2379 | 45 | 0 | 38.85157547 | -77.2977964 | 2022-09-13 04:20:57 | Fairfax City, Virginia, US | |
2022-09-08 | US | Missouri | Monroe | 29137 | 2379 | 47 | 0 | 39.49593978 | -92.00043978 | 2022-09-09 04:21:11 | Monroe, Missouri, US | |
2022-09-07 | US | Missouri | Monroe | 29137 | 2379 | 47 | 0 | 39.49593978 | -92.00043978 | 2022-09-08 04:21:02 | Monroe, Missouri, US | |
2022-09-06 | US | Missouri | Monroe | 29137 | 2379 | 47 | 0 | 39.49593978 | -92.00043978 | 2022-09-07 04:20:59 | Monroe, Missouri, US | |
2022-09-05 | US | Missouri | Monroe | 29137 | 2379 | 47 | 0 | 39.49593978 | -92.00043978 | 2022-09-06 04:21:02 | Monroe, Missouri, US | |
2022-09-04 | US | Missouri | Monroe | 29137 | 2379 | 47 | 0 | 39.49593978 | -92.00043978 | 2022-09-05 04:21:01 | Monroe, Missouri, US | |
2022-09-03 | US | Missouri | Monroe | 29137 | 2379 | 47 | 0 | 39.49593978 | -92.00043978 | 2022-09-04 04:21:22 | Monroe, Missouri, US | |
2022-09-02 | US | Missouri | Monroe | 29137 | 2379 | 47 | 0 | 39.49593978 | -92.00043978 | 2022-09-03 04:21:04 | Monroe, Missouri, US | |
2022-08-14 | US | Illinois | Hamilton | 17065 | 2379 | 32 | 0 | 38.08163641 | -88.53883373 | 2022-08-15 04:20:59 | Hamilton, Illinois, US | |
2022-08-13 | US | Illinois | Hamilton | 17065 | 2379 | 32 | 0 | 38.08163641 | -88.53883373 | 2022-08-14 04:20:55 | Hamilton, Illinois, US | |
2022-08-12 | US | Illinois | Hamilton | 17065 | 2379 | 32 | 0 | 38.08163641 | -88.53883373 | 2022-08-13 04:20:52 | Hamilton, Illinois, US | |
2022-07-16 | US | Tennessee | Clay | 47027 | 2379 | 52 | 0 | 36.55151008 | -85.53930419 | 2022-07-17 04:21:15 | Clay, Tennessee, US | |
2022-07-15 | US | Tennessee | Clay | 47027 | 2379 | 52 | 0 | 36.55151008 | -85.53930419 | 2022-07-16 04:21:05 | Clay, Tennessee, US | |
2022-07-12 | US | South Dakota | Lake | 46079 | 2379 | 28 | 0 | 44.02193107 | -97.12926365 | 2022-07-13 04:20:58 | Lake, South Dakota, US | |
2022-07-11 | US | South Dakota | Lake | 46079 | 2379 | 28 | 0 | 44.02193107 | -97.12926365 | 2022-07-12 04:20:51 | Lake, South Dakota, US | |
2022-07-10 | US | South Dakota | Lake | 46079 | 2379 | 28 | 0 | 44.02193107 | -97.12926365 | 2022-07-11 04:20:46 | Lake, South Dakota, US | |
2022-07-09 | US | South Dakota | Lake | 46079 | 2379 | 28 | 0 | 44.02193107 | -97.12926365 | 2022-07-10 04:20:54 | Lake, South Dakota, US | |
2022-07-08 | US | South Dakota | Lake | 46079 | 2379 | 28 | 0 | 44.02193107 | -97.12926365 | 2022-07-09 04:20:59 | Lake, South Dakota, US | |
2022-07-07 | US | South Dakota | Lake | 46079 | 2379 | 28 | 0 | 44.02193107 | -97.12926365 | 2022-07-08 04:20:56 | Lake, South Dakota, US | |
2022-07-06 | US | South Dakota | Lake | 46079 | 2379 | 28 | 0 | 44.02193107 | -97.12926365 | 2022-07-07 04:20:55 | Lake, South Dakota, US | |
2022-07-04 | China | Sichuan | 2379 | 3 | 0 | 30.6171 | 102.7103 | 2022-07-05 04:20:45 | Sichuan, China | |||
2022-07-03 | China | Sichuan | 2379 | 3 | 0 | 30.6171 | 102.7103 | 2022-07-04 04:20:54 | Sichuan, China | |||
2022-06-21 | US | Minnesota | Rock | 27133 | 2379 | 35 | 0 | 43.67482683 | -96.25296832 | 2022-06-22 04:20:54 | Rock, Minnesota, US | |
2022-06-20 | US | Texas | Parmer | 48369 | 2379 | 52 | 0 | 34.52993409 | -102.7844668 | 2022-06-21 04:20:56 | Parmer, Texas, US | |
2022-06-19 | US | Texas | Parmer | 48369 | 2379 | 52 | 0 | 34.52993409 | -102.7844668 | 2022-06-20 04:21:01 | Parmer, Texas, US | |
2022-06-18 | US | Texas | Parmer | 48369 | 2379 | 52 | 0 | 34.52993409 | -102.7844668 | 2022-06-19 04:20:51 | Parmer, Texas, US | |
2022-06-16 | US | Idaho | Franklin | 16041 | 2379 | 29 | 0 | 42.18332217 | -111.8149666 | 2022-06-17 04:20:56 | Franklin, Idaho, US | |
2022-06-15 | US | Idaho | Franklin | 16041 | 2379 | 29 | 0 | 42.18332217 | -111.8149666 | 2022-06-16 04:20:55 | Franklin, Idaho, US | |
2022-05-24 | US | Iowa | Guthrie | 19077 | 2379 | 46 | 0 | 41.68378965 | -94.50111014 | 2022-05-25 04:20:56 | Guthrie, Iowa, US | |
2022-05-23 | US | Iowa | Guthrie | 19077 | 2379 | 46 | 0 | 41.68378965 | -94.50111014 | 2022-05-24 04:20:57 | Guthrie, Iowa, US | |
2022-05-21 | US | Iowa | Guthrie | 19077 | 2379 | 46 | 0 | 41.68378965 | -94.50111014 | 2022-05-22 04:20:52 | Guthrie, Iowa, US | |
2022-05-20 | US | Iowa | Guthrie | 19077 | 2379 | 46 | 0 | 41.68378965 | -94.50111014 | 2022-05-21 04:20:58 | Guthrie, Iowa, US | |
2022-05-19 | US | Iowa | Guthrie | 19077 | 2379 | 46 | 0 | 41.68378965 | -94.50111014 | 2022-05-20 04:20:57 | Guthrie, Iowa, US | |
2022-05-18 | US | Iowa | Guthrie | 19077 | 2379 | 46 | 0 | 41.68378965 | -94.50111014 | 2022-05-19 04:20:54 | Guthrie, Iowa, US | |
2022-04-06 | US | Idaho | Washington | 16087 | 2379 | 57 | 0 | 44.45275475 | -116.78476880000001 | 2022-04-07 04:20:53 | Washington, Idaho, US | |
2022-03-22 | US | Michigan | Mackinac | 26097 | 2379 | 29 | 0 | 46.07028979 | -85.04980537 | 2022-03-23 04:20:48 | Mackinac, Michigan, US | |
2022-03-21 | US | Michigan | Mackinac | 26097 | 2379 | 29 | 0 | 46.07028979 | -85.04980537 | 2022-03-22 04:20:54 | Mackinac, Michigan, US | |
2022-03-20 | US | Michigan | Mackinac | 26097 | 2379 | 29 | 0 | 46.07028979 | -85.04980537 | 2022-03-21 04:20:50 | Mackinac, Michigan, US | |
2022-03-19 | US | Michigan | Mackinac | 26097 | 2379 | 29 | 0 | 46.07028979 | -85.04980537 | 2022-03-20 04:20:45 | Mackinac, Michigan, US | |
2022-03-18 | US | Michigan | Mackinac | 26097 | 2379 | 29 | 0 | 46.07028979 | -85.04980537 | 2022-03-19 04:20:47 | Mackinac, Michigan, US | |
2022-02-27 | US | Illinois | Brown | 17009 | 2379 | 15 | 0 | 39.96209138 | -90.75068024 | 2022-02-28 04:21:05 | Brown, Illinois, US | |
2022-02-26 | US | Illinois | Brown | 17009 | 2379 | 15 | 0 | 39.96209138 | -90.75068024 | 2022-02-27 04:21:04 | Brown, Illinois, US | |
2022-02-25 | US | Illinois | Brown | 17009 | 2379 | 15 | 0 | 39.96209138 | -90.75068024 | 2022-02-26 04:21:12 | Brown, Illinois, US | |
2022-02-09 | US | Missouri | Ralls | 29173 | 2379 | 20 | 0 | 39.52817427 | -91.51838643 | 2022-02-10 04:21:14 | Ralls, Missouri, US | |
2022-02-07 | US | Texas | Trinity | 48455 | 2379 | 67 | 0 | 31.0879489 | -95.1367187 | 2022-02-08 04:21:15 | Trinity, Texas, US | |
2022-02-03 | US | Florida | Liberty | 12077 | 2379 | 25 | 0 | 30.23766008 | -84.8829258 | 2022-02-04 04:21:10 | Liberty, Florida, US | |
2022-02-03 | US | Arkansas | Perry | 5105 | 2379 | 28 | 0 | 34.945915299999996 | -92.94372564 | 2022-02-04 04:21:10 | Perry, Arkansas, US | |
2022-02-02 | US | Florida | Liberty | 12077 | 2379 | 25 | 0 | 30.23766008 | -84.8829258 | 2022-02-03 04:21:21 | Liberty, Florida, US | |
2022-02-01 | US | Florida | Liberty | 12077 | 2379 | 25 | 0 | 30.23766008 | -84.8829258 | 2022-02-02 04:21:09 | Liberty, Florida, US | |
2022-01-31 | US | Florida | Liberty | 12077 | 2379 | 25 | 0 | 30.23766008 | -84.8829258 | 2022-02-01 04:21:11 | Liberty, Florida, US | |
2022-01-30 | US | North Carolina | Pamlico | 37137 | 2379 | 27 | 0 | 35.15253315 | -76.66559823 | 2022-01-31 04:21:09 | Pamlico, North Carolina, US | |
2022-01-30 | US | Florida | Liberty | 12077 | 2379 | 25 | 0 | 30.23766008 | -84.8829258 | 2022-01-31 04:21:09 | Liberty, Florida, US | |
2022-01-30 | US | Colorado | Bent | 8011 | 2379 | 47 | 0 | 37.95474293 | -103.0720195 | 2022-01-31 04:21:09 | Bent, Colorado, US | |
2022-01-29 | US | North Carolina | Pamlico | 37137 | 2379 | 27 | 0 | 35.15253315 | -76.66559823 | 2022-01-30 04:21:26 | Pamlico, North Carolina, US | |
2022-01-29 | US | Florida | Liberty | 12077 | 2379 | 25 | 0 | 30.23766008 | -84.8829258 | 2022-01-30 04:21:26 | Liberty, Florida, US | |
2022-01-28 | US | North Carolina | Pamlico | 37137 | 2379 | 27 | 0 | 35.15253315 | -76.66559823 | 2022-01-29 04:21:10 | Pamlico, North Carolina, US | |
2022-01-28 | US | Florida | Liberty | 12077 | 2379 | 25 | 0 | 30.23766008 | -84.8829258 | 2022-01-29 04:21:10 | Liberty, Florida, US | |
2022-01-19 | US | Kentucky | Metcalfe | 21169 | 2379 | 53 | 0 | 36.99459295 | -85.63123699 | 2022-01-20 04:21:07 | Metcalfe, Kentucky, US | |
2022-01-06 | US | South Carolina | Bamberg | 45009 | 2379 | 64 | 0 | 33.21927586 | -81.05659969 | 2022-01-07 04:22:09 | Bamberg, South Carolina, US | |
2021-12-29 | US | Wyoming | Converse | 56009 | 2379 | 48 | 0 | 42.97272268 | -105.5081848 | 2021-12-30 04:21:25 | Converse, Wyoming, US | |
2021-12-28 | US | Alaska | Nome | 2180 | 2379 | 3 | 0 | 64.90320724 | -164.0353804 | 2021-12-29 03:21:43 | Nome, Alaska, US | |
2021-12-27 | US | Virginia | King William | 51101 | 2379 | 27 | 0 | 37.70965316 | -77.09384941 | 2021-12-28 04:21:47 | King William, Virginia, US | |
2021-12-27 | US | Alaska | Nome | 2180 | 2379 | 3 | 0 | 64.90320724 | -164.0353804 | 2021-12-28 04:21:47 | Nome, Alaska, US | |
2021-12-26 | US | Indiana | Blackford | 18009 | 2379 | 47 | 0 | 40.47388153 | -85.32499702 | 2021-12-27 04:21:58 | Blackford, Indiana, US | |
2021-12-25 | US | Indiana | Blackford | 18009 | 2379 | 47 | 0 | 40.47388153 | -85.32499702 | 2021-12-26 04:21:50 | Blackford, Indiana, US | |
2021-12-24 | US | Indiana | Blackford | 18009 | 2379 | 47 | 0 | 40.47388153 | -85.32499702 | 2021-12-25 04:21:37 | Blackford, Indiana, US | |
2021-12-23 | US | Indiana | Blackford | 18009 | 2379 | 47 | 0 | 40.47388153 | -85.32499702 | 2021-12-24 04:21:34 | Blackford, Indiana, US | |
2021-12-22 | US | Indiana | Blackford | 18009 | 2379 | 47 | 0 | 40.47388153 | -85.32499702 | 2021-12-23 04:21:21 | Blackford, Indiana, US | |
2021-12-11 | US | Colorado | Grand | 8049 | 2379 | 18 | 0 | 40.10603347 | -106.11780420000001 | 2021-12-12 04:22:12 | Grand, Colorado, US | |
2021-12-09 | US | Idaho | Gooding | 16047 | 2379 | 44 | 0 | 42.96927962 | -114.81083059999999 | 2021-12-10 04:22:28 | Gooding, Idaho, US | |
2021-11-17 | US | Nebraska | Seward | 31159 | 2379 | 32 | 0 | 40.87241834 | -97.139673 | 2021-11-18 04:21:33 | Seward, Nebraska, US | |
2021-11-16 | US | North Dakota | Walsh | 38099 | 2379 | 29 | 0 | 48.36876964 | -97.72574783 | 2021-11-17 04:21:48 | Walsh, North Dakota, US | |
2021-11-11 | US | Minnesota | Faribault | 27043 | 2379 | 31 | 0 | 43.67381499 | -93.94787458 | 2021-11-12 04:22:01 | Faribault, Minnesota, US | |
2021-11-08 | US | Nebraska | York | 31185 | 2379 | 11 | 0 | 40.87272618 | -97.59710186 | 2021-11-09 04:21:36 | York, Nebraska, US | |
2021-11-07 | US | Kentucky | Larue | 21123 | 2379 | 51 | 0 | 37.54567114 | -85.70138352 | 2021-11-08 04:21:43 | Larue, Kentucky, US | |
2021-11-06 | US | Kentucky | Larue | 21123 | 2379 | 51 | 0 | 37.54567114 | -85.70138352 | 2021-11-07 04:21:53 | Larue, Kentucky, US | |
2021-10-30 | US | New York | Schoharie | 36095 | 2379 | 23 | 0 | 42.58831742 | -74.44339029999998 | 2021-10-31 04:22:08 | Schoharie, New York, US | |
2021-10-28 | US | Mississippi | Yalobusha | 28161 | 2379 | 47 | 0 | 34.02824175 | -89.70762049999998 | 2021-10-29 04:22:03 | Yalobusha, Mississippi, US | |
2021-10-28 | US | Kentucky | Caldwell | 21033 | 2379 | 48 | 0 | 37.14749129 | -87.86948214 | 2021-10-29 04:22:03 | Caldwell, Kentucky, US | |
2021-10-28 | US | Illinois | Carroll | 17015 | 2379 | 38 | 0 | 42.06823429 | -89.93395545 | 2021-10-29 04:22:03 | Carroll, Illinois, US | |
2021-10-27 | US | Wyoming | Goshen | 56015 | 2379 | 38 | 0 | 42.08798185 | -104.3534743 | 2021-10-28 04:22:08 | Goshen, Wyoming, US | |
2021-10-22 | Netherlands | Bonaire, Sint Eustatius and Saba | 2379 | 19 | 0 | 12.1784 | -68.2385 | 2021-10-23 04:21:32 | Bonaire, Sint Eustatius and Saba, Netherlands | |||
2021-10-13 | US | Arkansas | Howard | 5061 | 2379 | 35 | 0 | 34.09007427 | -93.9934871 | 2021-10-14 04:21:29 | Howard, Arkansas, US | |
2021-10-07 | US | West Virginia | Wetzel | 54103 | 2379 | 46 | 0 | 39.6065771 | -80.64016540000001 | 2021-10-08 04:21:25 | Wetzel, West Virginia, US | |
2021-10-07 | US | Tennessee | Decatur | 47039 | 2379 | 43 | 0 | 35.60048904 | -88.11043779 | 2021-10-08 04:21:25 | Decatur, Tennessee, US | |
2021-10-06 | US | Pennsylvania | Montour | 42093 | 2379 | 69 | 0 | 41.03023987 | -76.66345939 | 2021-10-07 04:21:36 | Montour, Pennsylvania, US | |
2021-10-05 | US | Kentucky | Webster | 21233 | 2379 | 34 | 0 | 37.52168356 | -87.67989953 | 2021-10-06 04:21:33 | Webster, Kentucky, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;