daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
205 rows where confirmed = 4509 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-18 | US | Illinois | Massac | 17127 | 4509 | 72 | 0 | 37.22078441 | -88.71036614 | 2022-12-19 04:21:03 | Massac, Illinois, US | |
2022-12-17 | US | Illinois | Massac | 17127 | 4509 | 72 | 0 | 37.22078441 | -88.71036614 | 2022-12-18 04:21:03 | Massac, Illinois, US | |
2022-12-16 | US | Illinois | Massac | 17127 | 4509 | 72 | 0 | 37.22078441 | -88.71036614 | 2022-12-17 04:21:04 | Massac, Illinois, US | |
2022-12-08 | US | New Mexico | Los Alamos | 35028 | 4509 | 23 | 0 | 35.86631386 | -106.3134985 | 2022-12-09 04:21:05 | Los Alamos, New Mexico, US | |
2022-11-22 | US | Alabama | Lamar | 1075 | 4509 | 69 | 0 | 33.77995024 | -88.09668032 | 2022-11-23 04:21:06 | Lamar, Alabama, US | |
2022-11-21 | US | Alabama | Lamar | 1075 | 4509 | 69 | 0 | 33.77995024 | -88.09668032 | 2022-11-22 04:20:47 | Lamar, Alabama, US | |
2022-11-20 | US | Alabama | Lamar | 1075 | 4509 | 69 | 0 | 33.77995024 | -88.09668032 | 2022-11-21 04:21:05 | Lamar, Alabama, US | |
2022-11-19 | US | Alabama | Lamar | 1075 | 4509 | 69 | 0 | 33.77995024 | -88.09668032 | 2022-11-20 04:21:08 | Lamar, Alabama, US | |
2022-11-18 | US | Alabama | Lamar | 1075 | 4509 | 69 | 0 | 33.77995024 | -88.09668032 | 2022-11-19 04:21:14 | Lamar, Alabama, US | |
2022-11-17 | US | Alabama | Lamar | 1075 | 4509 | 69 | 0 | 33.77995024 | -88.09668032 | 2022-11-18 04:21:15 | Lamar, Alabama, US | |
2022-11-16 | US | Alabama | Lamar | 1075 | 4509 | 69 | 0 | 33.77995024 | -88.09668032 | 2022-11-17 04:21:11 | Lamar, Alabama, US | |
2022-10-20 | US | Illinois | Mason | 17125 | 4509 | 65 | 0 | 40.23917274 | -89.91824452 | 2022-10-21 04:22:23 | Mason, Illinois, US | |
2022-09-27 | US | Georgia | Greene | 13133 | 4509 | 88 | 0 | 33.5769205 | -83.17139104 | 2022-09-28 04:23:01 | Greene, Georgia, US | |
2022-09-26 | US | Georgia | Greene | 13133 | 4509 | 88 | 0 | 33.5769205 | -83.17139104 | 2022-09-27 04:23:01 | Greene, Georgia, US | |
2022-09-25 | US | Georgia | Greene | 13133 | 4509 | 88 | 0 | 33.5769205 | -83.17139104 | 2022-09-26 04:20:52 | Greene, Georgia, US | |
2022-09-24 | US | Georgia | Greene | 13133 | 4509 | 88 | 0 | 33.5769205 | -83.17139104 | 2022-09-25 04:23:31 | Greene, Georgia, US | |
2022-09-23 | US | Georgia | Greene | 13133 | 4509 | 88 | 0 | 33.5769205 | -83.17139104 | 2022-09-24 04:21:40 | Greene, Georgia, US | |
2022-09-22 | US | Georgia | Greene | 13133 | 4509 | 88 | 0 | 33.5769205 | -83.17139104 | 2022-09-23 04:23:13 | Greene, Georgia, US | |
2022-09-21 | US | Virginia | Manassas Park | 51685 | 4509 | 28 | 0 | 38.77058531 | -77.44399307 | 2022-09-22 04:22:56 | Manassas Park, Virginia, US | |
2022-09-21 | US | Georgia | Greene | 13133 | 4509 | 88 | 0 | 33.5769205 | -83.17139104 | 2022-09-22 04:22:56 | Greene, Georgia, US | |
2022-09-20 | US | North Dakota | Richland | 38077 | 4509 | 23 | 0 | 46.26440649 | -96.94852979 | 2022-09-21 04:23:22 | Richland, North Dakota, US | |
2022-08-25 | US | Louisiana | Bienville | 22013 | 4509 | 114 | 0 | 32.34569994 | -93.05398492 | 2022-08-26 04:21:02 | Bienville, Louisiana, US | |
2022-08-09 | US | Wisconsin | Burnett | 55013 | 4509 | 45 | 0 | 45.86303537 | -92.36711412 | 2022-08-10 04:20:57 | Burnett, Wisconsin, US | |
2022-08-04 | US | Texas | Lavaca | 48285 | 4509 | 122 | 0 | 29.38508402 | -96.93186692 | 2022-08-05 04:20:52 | Lavaca, Texas, US | |
2022-07-26 | US | Tennessee | Cannon | 47015 | 4509 | 68 | 0 | 35.80990797 | -86.05738983 | 2022-07-27 04:21:04 | Cannon, Tennessee, US | |
2022-07-20 | US | West Virginia | Hardy | 54031 | 4509 | 49 | 0 | 39.00683177 | -78.85855301 | 2022-07-21 04:21:10 | Hardy, West Virginia, US | |
2022-07-17 | US | Louisiana | LaSalle | 22059 | 4509 | 61 | 0 | 31.67884782 | -92.15907765 | 2022-07-18 04:20:59 | LaSalle, Louisiana, US | |
2022-07-16 | US | Louisiana | LaSalle | 22059 | 4509 | 61 | 0 | 31.67884782 | -92.15907765 | 2022-07-17 04:21:15 | LaSalle, Louisiana, US | |
2022-07-15 | US | Louisiana | LaSalle | 22059 | 4509 | 61 | 0 | 31.67884782 | -92.15907765 | 2022-07-16 04:21:05 | LaSalle, Louisiana, US | |
2022-07-12 | US | Texas | Lamb | 48279 | 4509 | 122 | 0 | 34.06859623 | -102.3516289 | 2022-07-13 04:20:58 | Lamb, Texas, US | |
2022-07-12 | US | Illinois | Carroll | 17015 | 4509 | 49 | 0 | 42.06823429 | -89.93395545 | 2022-07-13 04:20:58 | Carroll, Illinois, US | |
2022-07-06 | US | Texas | Aransas | 48007 | 4509 | 87 | 0 | 28.10556197 | -96.9995047 | 2022-07-07 04:20:55 | Aransas, Texas, US | |
2022-06-12 | US | Illinois | Hancock | 17067 | 4509 | 48 | 0 | 40.40423981 | -91.16313899 | 2022-06-13 04:21:14 | Hancock, Illinois, US | |
2022-06-11 | US | Illinois | Hancock | 17067 | 4509 | 48 | 0 | 40.40423981 | -91.16313899 | 2022-06-12 04:20:53 | Hancock, Illinois, US | |
2022-06-10 | US | Texas | Shelby | 48419 | 4509 | 134 | 0 | 31.79211404 | -94.14550696 | 2022-06-11 04:21:01 | Shelby, Texas, US | |
2022-06-10 | US | Illinois | Hancock | 17067 | 4509 | 48 | 0 | 40.40423981 | -91.16313899 | 2022-06-11 04:21:01 | Hancock, Illinois, US | |
2022-06-08 | US | Illinois | Bond | 17005 | 4509 | 31 | 0 | 38.88829622 | -89.43534887 | 2022-06-09 04:20:54 | Bond, Illinois, US | |
2022-05-08 | US | California | Colusa | 6011 | 4509 | 21 | 0 | 39.17881957 | -122.2331726 | 2022-05-09 04:20:54 | Colusa, California, US | |
2022-05-07 | US | California | Colusa | 6011 | 4509 | 21 | 0 | 39.17881957 | -122.2331726 | 2022-05-08 04:20:49 | Colusa, California, US | |
2022-05-06 | US | California | Colusa | 6011 | 4509 | 21 | 0 | 39.17881957 | -122.2331726 | 2022-05-07 04:21:09 | Colusa, California, US | |
2022-04-01 | US | Pennsylvania | Montour | 42093 | 4509 | 93 | 0 | 41.03023987 | -76.66345939 | 2022-04-02 04:20:47 | Montour, Pennsylvania, US | |
2022-03-30 | US | Minnesota | Houston | 27055 | 4509 | 18 | 0 | 43.67129565 | -91.49143057 | 2022-03-31 04:20:56 | Houston, Minnesota, US | |
2022-03-29 | US | Minnesota | Houston | 27055 | 4509 | 18 | 0 | 43.67129565 | -91.49143057 | 2022-03-30 04:20:45 | Houston, Minnesota, US | |
2022-03-29 | US | Georgia | Morgan | 13211 | 4509 | 63 | 0 | 33.59232073 | -83.49129491 | 2022-03-30 04:20:45 | Morgan, Georgia, US | |
2022-03-22 | US | Washington | Asotin | 53003 | 4509 | 65 | 0 | 46.18894415 | -117.2022851 | 2022-03-23 04:20:48 | Asotin, Washington, US | |
2022-03-21 | US | Washington | Asotin | 53003 | 4509 | 65 | 0 | 46.18894415 | -117.2022851 | 2022-03-22 04:20:54 | Asotin, Washington, US | |
2022-03-20 | US | Washington | Asotin | 53003 | 4509 | 65 | 0 | 46.18894415 | -117.2022851 | 2022-03-21 04:20:50 | Asotin, Washington, US | |
2022-03-19 | US | Washington | Asotin | 53003 | 4509 | 65 | 0 | 46.18894415 | -117.2022851 | 2022-03-20 04:20:45 | Asotin, Washington, US | |
2022-03-18 | US | Washington | Asotin | 53003 | 4509 | 65 | 0 | 46.18894415 | -117.2022851 | 2022-03-19 04:20:47 | Asotin, Washington, US | |
2022-03-15 | US | Nevada | Humboldt | 32013 | 4509 | 53 | 0 | 41.40692186 | -118.11094270000001 | 2022-03-16 04:20:50 | Humboldt, Nevada, US | |
2022-03-14 | US | Nevada | Humboldt | 32013 | 4509 | 53 | 0 | 41.40692186 | -118.11094270000001 | 2022-03-15 04:20:47 | Humboldt, Nevada, US | |
2022-03-14 | US | Georgia | Morgan | 13211 | 4509 | 60 | 0 | 33.59232073 | -83.49129491 | 2022-03-15 04:20:47 | Morgan, Georgia, US | |
2022-03-13 | US | Nevada | Humboldt | 32013 | 4509 | 53 | 0 | 41.40692186 | -118.11094270000001 | 2022-03-14 04:20:46 | Humboldt, Nevada, US | |
2022-03-12 | US | Nevada | Humboldt | 32013 | 4509 | 53 | 0 | 41.40692186 | -118.11094270000001 | 2022-03-13 04:20:49 | Humboldt, Nevada, US | |
2022-03-11 | US | Nevada | Humboldt | 32013 | 4509 | 53 | 0 | 41.40692186 | -118.11094270000001 | 2022-03-12 04:20:50 | Humboldt, Nevada, US | |
2022-02-26 | Russia | Chukotka Autonomous Okrug | 4509 | 41 | 0 | 66.0006475 | 169.4900869 | 2022-02-27 04:21:04 | Chukotka Autonomous Okrug, Russia | |||
2022-02-23 | US | Georgia | Elbert | 13105 | 4509 | 104 | 0 | 34.11302332 | -82.83936148 | 2022-02-24 04:21:14 | Elbert, Georgia, US | |
2022-02-15 | US | West Virginia | Barbour | 54001 | 4509 | 67 | 0 | 39.1307219 | -80.00350858 | 2022-02-16 04:21:10 | Barbour, West Virginia, US | |
2022-02-15 | US | Michigan | Roscommon | 26143 | 4509 | 109 | 0 | 44.33473082 | -84.61067651 | 2022-02-16 04:21:10 | Roscommon, Michigan, US | |
2022-02-14 | US | Michigan | Roscommon | 26143 | 4509 | 109 | 0 | 44.33473082 | -84.61067651 | 2022-02-15 04:21:09 | Roscommon, Michigan, US | |
2022-02-12 | US | Puerto Rico | Cabo Rojo | 72023 | 4509 | 0 | 0 | 18.040993 | -67.154391 | 2022-02-13 04:21:00 | Cabo Rojo, Puerto Rico, US | |
2022-02-11 | US | Arkansas | Drew | 5043 | 4509 | 58 | 0 | 33.59035001 | -91.71777921 | 2022-02-12 04:21:06 | Drew, Arkansas, US | |
2022-02-03 | US | Virginia | Radford | 51750 | 4509 | 39 | 0 | 37.12222899 | -80.56027320000003 | 2022-02-04 04:21:10 | Radford, Virginia, US | |
2022-01-30 | US | Arkansas | Randolph | 5121 | 4509 | 73 | 0 | 36.3415714 | -91.02455531 | 2022-01-31 04:21:09 | Randolph, Arkansas, US | |
2022-01-29 | US | Arkansas | Randolph | 5121 | 4509 | 73 | 0 | 36.3415714 | -91.02455531 | 2022-01-30 04:21:26 | Randolph, Arkansas, US | |
2022-01-28 | US | Arkansas | Randolph | 5121 | 4509 | 73 | 0 | 36.3415714 | -91.02455531 | 2022-01-29 04:21:10 | Randolph, Arkansas, US | |
2022-01-25 | US | Missouri | Vernon | 29217 | 4509 | 93 | 0 | 37.8457799 | -94.34127305 | 2022-01-26 04:21:07 | Vernon, Missouri, US | |
2022-01-25 | US | Arkansas | Ashley | 5003 | 4509 | 56 | 0 | 33.19153461 | -91.76984709999999 | 2022-01-26 04:21:07 | Ashley, Arkansas, US | |
2022-01-24 | US | Indiana | Fulton | 18049 | 4509 | 93 | 0 | 41.0469907 | -86.26252745 | 2022-01-25 04:21:05 | Fulton, Indiana, US | |
2022-01-12 | US | Texas | Moore | 48341 | 4509 | 97 | 0 | 35.83769242 | -101.8930281 | 2022-01-13 08:00:09 | Moore, Texas, US | |
2022-01-04 | US | New Mexico | Cibola | 35006 | 4509 | 158 | 0 | 34.91131525 | -107.998876 | 2022-01-05 04:21:59 | Cibola, New Mexico, US | |
2021-12-19 | US | New Hampshire | Coos | 33007 | 4509 | 79 | 0 | 44.69063265 | -71.30633239 | 2021-12-20 04:21:43 | Coos, New Hampshire, US | |
2021-12-18 | US | New Hampshire | Coos | 33007 | 4509 | 79 | 0 | 44.69063265 | -71.30633239 | 2021-12-19 04:21:11 | Coos, New Hampshire, US | |
2021-12-17 | US | New Hampshire | Coos | 33007 | 4509 | 79 | 0 | 44.69063265 | -71.30633239 | 2021-12-18 02:22:20 | Coos, New Hampshire, US | |
2021-12-15 | US | Missouri | Saline | 29195 | 4509 | 84 | 0 | 39.13734288 | -93.20259964 | 2021-12-16 04:22:11 | Saline, Missouri, US | |
2021-12-14 | US | Oregon | Columbia | 41009 | 4509 | 60 | 0 | 45.94464254 | -123.08908980000001 | 2021-12-15 03:22:16 | Columbia, Oregon, US | |
2021-12-11 | US | Puerto Rico | Unassigned | 72999 | 4509 | 3274 | 0 | 18.459681 | -67.336525 | 2021-12-12 04:22:12 | Unassigned, Puerto Rico, US | |
2021-12-10 | US | Puerto Rico | Unassigned | 72999 | 4509 | 3274 | 0 | 18.459681 | -67.336525 | 2021-12-11 04:22:45 | Unassigned, Puerto Rico, US | |
2021-12-07 | US | Idaho | Jefferson | 16051 | 4509 | 51 | 0 | 43.82078483 | -112.3131749 | 2021-12-08 04:22:46 | Jefferson, Idaho, US | |
2021-12-02 | US | Kentucky | Lincoln | 21137 | 4509 | 103 | 0 | 37.45475628 | -84.6565327 | 2021-12-03 04:23:05 | Lincoln, Kentucky, US | |
2021-11-29 | US | Virginia | Amherst | 51009 | 4509 | 61 | 0 | 37.60308293 | -79.14548696 | 2021-11-30 04:22:53 | Amherst, Virginia, US | |
2021-11-28 | US | South Carolina | Edgefield | 45037 | 4509 | 59 | 0 | 33.77221995 | -81.96231108 | 2021-11-29 04:22:30 | Edgefield, South Carolina, US | |
2021-11-28 | US | Illinois | Perry | 17145 | 4509 | 78 | 0 | 38.08510853 | -89.36856219 | 2021-11-29 04:22:30 | Perry, Illinois, US | |
2021-11-27 | US | South Carolina | Edgefield | 45037 | 4509 | 59 | 0 | 33.77221995 | -81.96231108 | 2021-11-28 04:22:43 | Edgefield, South Carolina, US | |
2021-11-27 | US | Illinois | Perry | 17145 | 4509 | 78 | 0 | 38.08510853 | -89.36856219 | 2021-11-28 04:22:43 | Perry, Illinois, US | |
2021-11-26 | US | South Carolina | Edgefield | 45037 | 4509 | 59 | 0 | 33.77221995 | -81.96231108 | 2021-11-27 04:22:45 | Edgefield, South Carolina, US | |
2021-11-26 | US | Illinois | Perry | 17145 | 4509 | 78 | 0 | 38.08510853 | -89.36856219 | 2021-11-27 04:22:45 | Perry, Illinois, US | |
2021-11-25 | US | Illinois | Perry | 17145 | 4509 | 78 | 0 | 38.08510853 | -89.36856219 | 2021-11-26 04:22:33 | Perry, Illinois, US | |
2021-11-24 | US | Illinois | Perry | 17145 | 4509 | 78 | 0 | 38.08510853 | -89.36856219 | 2021-11-25 04:22:33 | Perry, Illinois, US | |
2021-11-22 | US | Louisiana | East Feliciana | 22037 | 4509 | 145 | 0 | 30.84425359 | -91.04976723 | 2021-11-23 04:22:39 | East Feliciana, Louisiana, US | |
2021-11-18 | US | Kansas | Miami | 20121 | 4509 | 68 | 0 | 38.56383358 | -94.83832189 | 2021-11-19 04:21:40 | Miami, Kansas, US | |
2021-11-17 | US | Kansas | Miami | 20121 | 4509 | 68 | 0 | 38.56383358 | -94.83832189 | 2021-11-18 04:21:33 | Miami, Kansas, US | |
2021-11-14 | US | South Dakota | Lawrence | 46081 | 4509 | 64 | 0 | 44.35919441 | -103.79294279999999 | 2021-11-15 04:21:36 | Lawrence, South Dakota, US | |
2021-11-13 | US | South Dakota | Lawrence | 46081 | 4509 | 64 | 0 | 44.35919441 | -103.79294279999999 | 2021-11-14 04:21:31 | Lawrence, South Dakota, US | |
2021-11-13 | Japan | Port Quarantine | 4509 | 7 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
2021-11-12 | US | South Dakota | Lawrence | 46081 | 4509 | 64 | 0 | 44.35919441 | -103.79294279999999 | 2021-11-13 04:21:38 | Lawrence, South Dakota, US | |
2021-11-12 | Japan | Port Quarantine | 4509 | 7 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
2021-11-11 | US | Michigan | Houghton | 26061 | 4509 | 56 | 0 | 46.89988536 | -88.68495385 | 2021-11-12 04:22:01 | Houghton, Michigan, US | |
2021-11-10 | US | Michigan | Houghton | 26061 | 4509 | 56 | 0 | 46.89988536 | -88.68495385 | 2021-11-11 04:21:45 | Houghton, Michigan, US | |
2021-11-06 | Netherlands | Sint Maarten | 4509 | 75 | 0 | 18.0425 | -63.0548 | 2021-11-07 04:21:53 | Sint Maarten, Netherlands |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;