daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
58 rows where confirmed = 9887 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 5
- US 54
- Chile 1
- Italy 1
- Korea, South 1
- Russia 1
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-29 | US | Texas | Grimes | 48185 | 9887 | 125 | 0 | 30.54579585 | -95.98902499 | 2022-12-30 04:21:04 | Grimes, Texas, US | |
2022-12-28 | US | Texas | Grimes | 48185 | 9887 | 125 | 0 | 30.54579585 | -95.98902499 | 2022-12-29 04:21:01 | Grimes, Texas, US | |
2022-10-23 | US | Texas | Matagorda | 48321 | 9887 | 185 | 0 | 28.81955746 | -96.01230294 | 2022-10-24 04:22:29 | Matagorda, Texas, US | |
2022-10-22 | US | Texas | Matagorda | 48321 | 9887 | 185 | 0 | 28.81955746 | -96.01230294 | 2022-10-23 04:22:46 | Matagorda, Texas, US | |
2022-10-21 | US | Texas | Matagorda | 48321 | 9887 | 185 | 0 | 28.81955746 | -96.01230294 | 2022-10-22 04:22:53 | Matagorda, Texas, US | |
2022-09-06 | US | Wisconsin | Oneida | 55085 | 9887 | 142 | 0 | 45.70677897 | -89.51944105 | 2022-09-07 04:20:59 | Oneida, Wisconsin, US | |
2022-09-05 | US | Wisconsin | Oneida | 55085 | 9887 | 142 | 0 | 45.70677897 | -89.51944105 | 2022-09-06 04:21:02 | Oneida, Wisconsin, US | |
2022-08-21 | US | Maryland | Worcester | 24047 | 9887 | 167 | 0 | 38.21274277 | -75.33200012 | 2022-08-22 04:20:38 | Worcester, Maryland, US | |
2022-08-20 | US | Maryland | Worcester | 24047 | 9887 | 167 | 0 | 38.21274277 | -75.33200012 | 2022-08-21 04:20:44 | Worcester, Maryland, US | |
2022-08-19 | US | Maryland | Worcester | 24047 | 9887 | 167 | 0 | 38.21274277 | -75.33200012 | 2022-08-20 04:21:01 | Worcester, Maryland, US | |
2022-08-07 | US | Puerto Rico | Manati | 72091 | 9887 | 0 | 0 | 18.420473 | -66.490461 | 2022-08-08 04:21:08 | Manati, Puerto Rico, US | |
2022-07-12 | US | Tennessee | Giles | 47055 | 9887 | 196 | 0 | 35.20222469 | -87.03992678 | 2022-07-13 04:20:58 | Giles, Tennessee, US | |
2022-06-19 | US | Nebraska | Unassigned | 90031 | 9887 | 862 | 0 | 42.8997274 | 0.0 | 2022-06-20 04:21:01 | Unassigned, Nebraska, US | |
2022-06-18 | US | Nebraska | Unassigned | 90031 | 9887 | 862 | 0 | 42.8997274 | 0.0 | 2022-06-19 04:20:51 | Unassigned, Nebraska, US | |
2022-06-17 | US | Nebraska | Unassigned | 90031 | 9887 | 862 | 0 | 42.8997274 | 0.0 | 2022-06-18 04:21:10 | Unassigned, Nebraska, US | |
2022-05-03 | US | New Mexico | Rio Arriba | 35039 | 9887 | 134 | 0 | 36.51072137 | -106.6931674 | 2022-05-04 04:20:59 | Rio Arriba, New Mexico, US | |
2022-03-24 | US | Wyoming | Teton | 56039 | 9887 | 16 | 0 | 43.93522482 | -110.5890801 | 2022-03-25 04:20:46 | Teton, Wyoming, US | |
2022-03-23 | US | Wyoming | Teton | 56039 | 9887 | 16 | 0 | 43.93522482 | -110.5890801 | 2022-03-24 04:20:43 | Teton, Wyoming, US | |
2022-03-22 | US | Wyoming | Teton | 56039 | 9887 | 16 | 0 | 43.93522482 | -110.5890801 | 2022-03-23 04:20:48 | Teton, Wyoming, US | |
2022-02-20 | US | Tennessee | Lincoln | 47103 | 9887 | 144 | 0 | 35.13738622 | -86.58910106 | 2022-02-21 04:21:05 | Lincoln, Tennessee, US | |
2022-02-13 | US | Alabama | Escambia | 1053 | 9887 | 153 | 0 | 31.1256789 | -87.15918694 | 2022-02-14 04:20:51 | Escambia, Alabama, US | |
2022-01-26 | US | Virginia | Henry | 51089 | 9887 | 215 | 0 | 36.68542395 | -79.87634026 | 2022-01-27 04:21:19 | Henry, Virginia, US | |
2022-01-25 | US | Oklahoma | Le Flore | 40079 | 9887 | 97 | 0 | 34.89851864 | -94.70392124 | 2022-01-26 04:21:07 | Le Flore, Oklahoma, US | |
2022-01-25 | US | Oklahoma | Kay | 40071 | 9887 | 180 | 0 | 36.81799745 | -97.14421435 | 2022-01-26 04:21:07 | Kay, Oklahoma, US | |
2022-01-24 | US | Oklahoma | Le Flore | 40079 | 9887 | 97 | 0 | 34.89851864 | -94.70392124 | 2022-01-25 04:21:05 | Le Flore, Oklahoma, US | |
2022-01-24 | US | Oklahoma | Kay | 40071 | 9887 | 180 | 0 | 36.81799745 | -97.14421435 | 2022-01-25 04:21:05 | Kay, Oklahoma, US | |
2022-01-23 | US | Oklahoma | Le Flore | 40079 | 9887 | 97 | 0 | 34.89851864 | -94.70392124 | 2022-01-24 04:21:12 | Le Flore, Oklahoma, US | |
2022-01-23 | US | Oklahoma | Kay | 40071 | 9887 | 180 | 0 | 36.81799745 | -97.14421435 | 2022-01-24 04:21:12 | Kay, Oklahoma, US | |
2022-01-23 | US | Kansas | Ford | 20057 | 9887 | 104 | 0 | 37.69200114 | -99.88825298 | 2022-01-24 04:21:12 | Ford, Kansas, US | |
2022-01-22 | US | Oklahoma | Le Flore | 40079 | 9887 | 97 | 0 | 34.89851864 | -94.70392124 | 2022-01-23 04:21:13 | Le Flore, Oklahoma, US | |
2022-01-22 | US | Oklahoma | Kay | 40071 | 9887 | 180 | 0 | 36.81799745 | -97.14421435 | 2022-01-23 04:21:13 | Kay, Oklahoma, US | |
2022-01-22 | US | Kansas | Ford | 20057 | 9887 | 104 | 0 | 37.69200114 | -99.88825298 | 2022-01-23 04:21:13 | Ford, Kansas, US | |
2022-01-21 | US | Oklahoma | Le Flore | 40079 | 9887 | 97 | 0 | 34.89851864 | -94.70392124 | 2022-01-22 04:21:13 | Le Flore, Oklahoma, US | |
2022-01-21 | US | Oklahoma | Kay | 40071 | 9887 | 180 | 0 | 36.81799745 | -97.14421435 | 2022-01-22 04:21:13 | Kay, Oklahoma, US | |
2022-01-21 | US | Kansas | Ford | 20057 | 9887 | 104 | 0 | 37.69200114 | -99.88825298 | 2022-01-22 04:21:13 | Ford, Kansas, US | |
2022-01-20 | US | Oklahoma | Le Flore | 40079 | 9887 | 97 | 0 | 34.89851864 | -94.70392124 | 2022-01-21 04:21:09 | Le Flore, Oklahoma, US | |
2022-01-20 | US | Oklahoma | Kay | 40071 | 9887 | 180 | 0 | 36.81799745 | -97.14421435 | 2022-01-21 04:21:09 | Kay, Oklahoma, US | |
2022-01-19 | US | Oklahoma | Le Flore | 40079 | 9887 | 97 | 0 | 34.89851864 | -94.70392124 | 2022-01-20 04:21:07 | Le Flore, Oklahoma, US | |
2022-01-19 | US | Oklahoma | Kay | 40071 | 9887 | 180 | 0 | 36.81799745 | -97.14421435 | 2022-01-20 04:21:07 | Kay, Oklahoma, US | |
2021-12-09 | US | Ohio | Jefferson | 39081 | 9887 | 250 | 0 | 40.38614126 | -80.76259514 | 2021-12-10 04:22:28 | Jefferson, Ohio, US | |
2021-11-14 | US | New Mexico | Valencia | 35061 | 9887 | 146 | 0 | 34.71669834 | -106.8103733 | 2021-11-15 04:21:36 | Valencia, New Mexico, US | |
2021-11-13 | US | New Mexico | Valencia | 35061 | 9887 | 146 | 0 | 34.71669834 | -106.8103733 | 2021-11-14 04:21:31 | Valencia, New Mexico, US | |
2021-11-12 | US | New Mexico | Valencia | 35061 | 9887 | 146 | 0 | 34.71669834 | -106.8103733 | 2021-11-13 04:21:38 | Valencia, New Mexico, US | |
2021-10-22 | US | Tennessee | Jefferson | 47089 | 9887 | 144 | 0 | 36.04818632 | -83.45148924 | 2021-10-23 04:21:32 | Jefferson, Tennessee, US | |
2021-09-19 | US | Kansas | Butler | 20015 | 9887 | 112 | 0 | 37.78134351 | -96.83878537 | 2021-09-20 04:21:22 | Butler, Kansas, US | |
2021-09-18 | US | Kansas | Butler | 20015 | 9887 | 112 | 0 | 37.78134351 | -96.83878537 | 2021-09-19 04:21:34 | Butler, Kansas, US | |
2021-09-17 | US | Kansas | Butler | 20015 | 9887 | 112 | 0 | 37.78134351 | -96.83878537 | 2021-09-18 04:21:24 | Butler, Kansas, US | |
2021-07-30 | US | Pennsylvania | Adams | 42001 | 9887 | 190 | 0 | 39.87140411 | -77.21610347 | 2021-07-31 04:21:35 | Adams, Pennsylvania, US | |
2021-07-08 | US | South Carolina | Orangeburg | 45075 | 9887 | 255 | 0 | 33.4391073 | -80.79886287 | 2021-07-09 04:21:21 | Orangeburg, South Carolina, US | |
2021-06-02 | US | South Carolina | Orangeburg | 45075 | 9887 | 253 | 0 | 33.4391073 | -80.79886287 | 2021-06-03 04:23:32 | Orangeburg, South Carolina, US | |
2021-05-28 | US | New Hampshire | Strafford | 33017 | 9887 | 92 | 0 | 43.291833 | -71.02336013 | 2021-05-29 04:20:41 | Strafford, New Hampshire, US | |
2021-02-28 | US | Oklahoma | Rogers | 40131 | 9887 | 118 | 0 | 9769 | 36.37004357 | -95.60406759 | 2021-03-01 05:23:01 | Rogers, Oklahoma, US |
2021-01-06 | US | Virginia | Richmond City | 51760 | 9887 | 100 | 0 | 9787 | 37.53255773 | -77.47966921 | 2021-01-07 05:22:03 | Richmond City, Virginia, US |
2020-12-20 | Chile | Nuble | 9887 | 200 | 9299 | 388 | -36.7226 | -71.7622 | 2020-12-21 05:27:58 | Nuble, Chile | ||
2020-11-02 | Russia | Tver Oblast | 9887 | 326 | 5697 | 3864 | 57.1134475 | 35.174442799999994 | 2020-11-03 06:00:16 | Tver Oblast, Russia | ||
2020-10-18 | US | Kentucky | Fayette | 21067 | 9887 | 83 | 0 | 9804 | 38.0368225 | -84.45576892 | 2020-10-19 04:24:16 | Fayette, Kentucky, US |
2020-06-15 | Italy | Liguria | 9887 | 1525 | 8116 | 246 | 44.41149315 | 8.9326992 | 2020-06-16 04:33:09 | Liguria, Italy | ||
2020-04-01 | Korea, South | 9887 | 165 | 5567 | 4155 | 35.90775700000001 | 127.766922 | 2020-04-01 21:58:34 | Korea, South |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;