johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
38 rows where active = 4253 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3468369 | 3468369 | 2021-08-03 | Russia | Bryansk Oblast | 54865 | 824 | 49788 | 4253 | 52.8873315 | 33.41585300000001 | 2021-08-04 04:21:25 | Bryansk Oblast, Russia | ||
1740184 | 1740184 | 2021-06-12 | Malaysia | Kelantan | 31874 | 178 | 27443 | 4253 | 6.1254 | 102.2381 | 2021-06-13 04:22:44 | Kelantan, Malaysia | ||
523096 | 523096 | 2021-06-09 | Russia | Rostov Oblast | 95618 | 4540 | 86825 | 4253 | 47.6222451 | 40.7957942 | 2021-06-10 04:23:17 | Rostov Oblast, Russia | ||
3574556 | 3574556 | 2021-05-17 | India | Nagaland | 18349 | 216 | 13880 | 4253 | 26.06702 | 94.470302 | 2021-05-18 04:20:33 | Nagaland, India | ||
3420782 | 3420782 | 2021-03-19 | Colombia | Valle del Cauca | 202385 | 6392 | 191740 | 4253 | 3.8009 | -76.6413 | 2021-03-20 05:25:46 | Valle del Cauca, Colombia | ||
1000804 | 1000804 | 2021-03-01 | US | North Carolina | Vance | 37181 | 4334 | 81 | 0 | 4253 | 36.36880673 | -78.40670845 | 2021-03-02 05:23:30 | Vance, North Carolina, US |
2185497 | 2185497 | 2021-02-26 | US | Missouri | Lincoln | 29113 | 4289 | 36 | 0 | 4253 | 39.05345619 | -90.95588181 | 2021-02-27 05:22:28 | Lincoln, Missouri, US |
1858776 | 1858776 | 2021-02-25 | US | Georgia | Colquitt | 13071 | 4353 | 100 | 0 | 4253 | 31.18810588 | -83.7677946 | 2021-02-26 05:22:40 | Colquitt, Georgia, US |
1341911 | 1341911 | 2021-02-15 | Ukraine | Vinnytsia Oblast | 30119 | 578 | 25288 | 4253 | 49.2331 | 28.4682 | 2021-02-16 05:24:38 | Vinnytsia Oblast, Ukraine | ||
2283346 | 2283346 | 2021-02-14 | Germany | Sachsen-Anhalt | 56457 | 2109 | 50394 | 4253 | 51.9503 | 11.6923 | 2021-02-15 05:24:49 | Sachsen-Anhalt, Germany | ||
792553 | 792553 | 2021-02-04 | US | New Jersey | Salem | 34033 | 4403 | 150 | 0 | 4253 | 39.58719656 | -75.34696629999998 | 2021-02-05 05:22:38 | Salem, New Jersey, US |
3157061 | 3157061 | 2021-01-27 | US | Washington | Walla Walla | 53071 | 4302 | 49 | 0 | 4253 | 46.23040051 | -118.4775539 | 2021-01-28 05:22:24 | Walla Walla, Washington, US |
909152 | 909152 | 2021-01-19 | US | Illinois | Effingham | 17049 | 4311 | 58 | 0 | 4253 | 39.05935711 | -88.58969584 | 2021-01-20 05:21:54 | Effingham, Illinois, US |
3104736 | 3104736 | 2021-01-16 | US | Virginia | Bedford | 51019 | 4286 | 33 | 0 | 4253 | 37.3080028 | -79.5281964 | 2021-01-17 05:22:17 | Bedford, Virginia, US |
3902977 | 3902977 | 2021-01-09 | US | Texas | Bowie | 48037 | 4973 | 131 | 0 | 4253 | 33.44626922 | -94.41834132 | 2021-01-10 05:22:12 | Bowie, Texas, US |
2542576 | 2542576 | 2021-01-07 | US | Iowa | Clinton | 19045 | 4313 | 60 | 0 | 4253 | 41.89981633 | -90.53275096 | 2021-01-08 05:22:42 | Clinton, Iowa, US |
1139239 | 1139239 | 2021-01-01 | US | North Carolina | Stanly | 37167 | 4331 | 78 | 0 | 4253 | 35.31647813 | -80.25093221 | 2021-01-02 05:22:33 | Stanly, North Carolina, US |
3697845 | 3697845 | 2020-12-31 | US | North Carolina | Stanly | 37167 | 4331 | 78 | 0 | 4253 | 35.31647813 | -80.25093221 | 2021-01-01 05:23:07 | Stanly, North Carolina, US |
769271 | 769271 | 2020-12-29 | US | Tennessee | Lawrence | 47099 | 4328 | 57 | 0 | 4253 | 35.21675201 | -87.39787695 | 2020-12-30 05:22:34 | Lawrence, Tennessee, US |
2224472 | 2224472 | 2020-12-26 | US | Illinois | Clinton | 17027 | 4328 | 75 | 0 | 4253 | 38.60704876 | -89.42385254 | 2020-12-27 05:22:55 | Clinton, Illinois, US |
3691686 | 3691686 | 2020-12-24 | Russia | Khabarovsk Krai | 32701 | 199 | 28249 | 4253 | 51.6312684 | 136.121524 | 2020-12-25 05:22:48 | Khabarovsk Krai, Russia | ||
927433 | 927433 | 2020-12-21 | Brazil | Mato Grosso | 173132 | 4395 | 163638 | 4253 | -12.6819 | -56.9211 | 2020-12-22 05:22:33 | Mato Grosso, Brazil | ||
2130809 | 2130809 | 2020-12-17 | US | South Carolina | Lancaster | 45057 | 4329 | 76 | 0 | 4253 | 34.68270843 | -80.70513032 | 2020-12-18 05:28:18 | Lancaster, South Carolina, US |
2347860 | 2347860 | 2020-12-07 | US | Arizona | Cochise | 4003 | 4342 | 89 | 0 | 4253 | 31.87934684 | -109.7516088 | 2020-12-08 05:27:42 | Cochise, Arizona, US |
1006730 | 1006730 | 2020-12-06 | US | Arizona | Cochise | 4003 | 4342 | 89 | 0 | 4253 | 31.87934684 | -109.7516088 | 2020-12-07 05:26:14 | Cochise, Arizona, US |
1586741 | 1586741 | 2020-11-30 | US | Oklahoma | Payne | 40119 | 4272 | 19 | 0 | 4253 | 36.07695283 | -96.97584944 | 2020-12-01 05:26:18 | Payne, Oklahoma, US |
3191866 | 3191866 | 2020-11-22 | US | Missouri | Clay | 29047 | 4314 | 61 | 0 | 4253 | 39.31132056 | -94.41850862 | 2020-11-23 05:25:26 | Clay, Missouri, US |
2882653 | 2882653 | 2020-11-15 | US | Ohio | Delaware | 39041 | 4281 | 28 | 0 | 4253 | 40.27942393 | -83.00457058 | 2020-11-16 05:25:57 | Delaware, Ohio, US |
273892 | 273892 | 2020-11-10 | US | Minnesota | Olmsted | 27109 | 4283 | 30 | 0 | 4253 | 44.00374114 | -92.40209944 | 2020-11-11 05:25:30 | Olmsted, Minnesota, US |
2871893 | 2871893 | 2020-09-13 | US | Texas | Potter | 48375 | 4216 | 57 | 0 | 4253 | 35.40133773 | -101.893964 | 2020-09-14 04:26:00 | Potter, Texas, US |
549932 | 549932 | 2020-09-12 | US | Texas | Potter | 48375 | 4212 | 57 | 0 | 4253 | 35.40133773 | -101.893964 | 2020-09-13 04:30:52 | Potter, Texas, US |
1447761 | 1447761 | 2020-09-11 | US | Texas | Potter | 48375 | 4207 | 57 | 0 | 4253 | 35.40133773 | -101.893964 | 2020-09-12 04:25:05 | Potter, Texas, US |
206969 | 206969 | 2020-08-19 | US | Florida | Santa Rosa | 12113 | 4303 | 50 | 0 | 4253 | 30.693414500000006 | -87.02458128 | 2020-08-20 04:27:43 | Santa Rosa, Florida, US |
837881 | 837881 | 2020-08-17 | Senegal | 12237 | 256 | 7728 | 4253 | 14.4974 | -14.4524 | 2020-08-18 04:27:56 | Senegal | |||
1920638 | 1920638 | 2020-08-10 | Netherlands | Utrecht | 4701 | 432 | 0 | 4253 | 52.084251 | 5.163824 | 2020-08-11 04:35:08 | Utrecht, Netherlands | ||
98129 | 98129 | 2020-08-04 | Colombia | Bolivar | 19306 | 605 | 14448 | 4253 | 8.6704 | -74.03 | 2020-08-05 04:34:43 | Bolivar, Colombia | ||
323887 | 323887 | 2020-07-20 | US | Florida | Brevard | 12009 | 4303 | 50 | 0 | 4253 | 28.29409504 | -80.73091022 | 2020-07-21 04:38:46 | Brevard, Florida, US |
2685036 | 2685036 | 2020-07-06 | Russia | Saint Petersburg | 25816 | 1389 | 20174 | 4253 | 59.9606739 | 30.158655100000004 | 2020-07-07 04:34:00 | Saint Petersburg, Russia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);