johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
41 rows where active = 4060 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1408840 | 1408840 | 2021-04-23 | Chile | Valparaiso | 81259 | 2197 | 75002 | 4060 | -33.0472 | -71.6127 | 2021-04-24 04:20:38 | Valparaiso, Chile | ||
183257 | 183257 | 2021-02-21 | US | Iowa | Muscatine | 19139 | 4148 | 88 | 0 | 4060 | 41.48370744 | -91.1121697 | 2021-02-22 05:24:21 | Muscatine, Iowa, US |
745341 | 745341 | 2021-02-20 | US | Texas | Burnet | 48053 | 4630 | 54 | 0 | 4060 | 30.78801353 | -98.181887 | 2021-02-21 05:24:33 | Burnet, Texas, US |
3603866 | 3603866 | 2021-02-17 | US | South Carolina | Newberry | 45071 | 4152 | 92 | 0 | 4060 | 34.28629098 | -81.59935761 | 2021-02-18 05:22:58 | Newberry, South Carolina, US |
1339016 | 1339016 | 2021-02-15 | US | Georgia | Baldwin | 13009 | 4161 | 101 | 0 | 4060 | 33.06882326 | -83.24701748 | 2021-02-16 05:24:38 | Baldwin, Georgia, US |
2680040 | 2680040 | 2021-02-13 | US | New York | Cattaraugus | 36009 | 4133 | 73 | 0 | 4060 | 42.24778241 | -78.67923096 | 2021-02-14 05:23:43 | Cattaraugus, New York, US |
3543074 | 3543074 | 2021-02-12 | Ukraine | Chernihiv Oblast | 34598 | 695 | 29843 | 4060 | 51.4982 | 31.2893 | 2021-02-13 05:22:12 | Chernihiv Oblast, Ukraine | ||
1675566 | 1675566 | 2021-02-07 | US | Texas | Hill | 48217 | 4881 | 71 | 0 | 4060 | 31.99045053 | -97.13423143 | 2021-02-08 05:22:39 | Hill, Texas, US |
1677312 | 1677312 | 2021-02-01 | US | Georgia | Murray | 13213 | 4113 | 53 | 0 | 4060 | 34.78897608 | -84.74993177 | 2021-02-02 05:22:49 | Murray, Georgia, US |
2211456 | 2211456 | 2021-01-30 | Chile | Los Lagos | 41573 | 397 | 37116 | 4060 | -41.9198 | -72.1416 | 2021-01-31 05:22:42 | Los Lagos, Chile | ||
1899385 | 1899385 | 2021-01-29 | US | New York | Herkimer | 36043 | 4147 | 87 | 0 | 4060 | 43.42034246 | -74.96145307 | 2021-01-30 05:22:49 | Herkimer, New York, US |
908659 | 908659 | 2021-01-19 | US | Arkansas | Hot Spring | 5059 | 4121 | 61 | 0 | 4060 | 34.31709259 | -92.95396325 | 2021-01-20 05:21:54 | Hot Spring, Arkansas, US |
240169 | 240169 | 2021-01-18 | US | Tennessee | Franklin | 47051 | 4179 | 61 | 0 | 4060 | 35.15634626 | -86.09201039 | 2021-01-19 05:22:15 | Franklin, Tennessee, US |
3518955 | 3518955 | 2021-01-15 | US | Wisconsin | Marinette | 55075 | 4114 | 54 | 0 | 4060 | 45.38553432 | -88.03324599999998 | 2021-01-16 05:22:40 | Marinette, Wisconsin, US |
192632 | 192632 | 2021-01-11 | US | Oklahoma | McClain | 40087 | 4090 | 30 | 0 | 4060 | 35.01123903 | -97.44572302 | 2021-01-12 05:22:15 | McClain, Oklahoma, US |
2932184 | 2932184 | 2020-12-19 | US | Illinois | Clinton | 17027 | 4133 | 73 | 0 | 4060 | 38.60704876 | -89.42385254 | 2020-12-20 05:27:32 | Clinton, Illinois, US |
679672 | 679672 | 2020-11-23 | US | Kentucky | Boone | 21015 | 4088 | 28 | 0 | 4060 | 38.97065142 | -84.72615357 | 2020-11-24 05:27:31 | Boone, Kentucky, US |
3193418 | 3193418 | 2020-11-22 | US | Washington | Grant | 53025 | 4089 | 29 | 0 | 4060 | 47.20753737 | -119.4500749 | 2020-11-23 05:25:26 | Grant, Washington, US |
3190346 | 3190346 | 2020-11-22 | US | Alabama | Cullman | 1043 | 4096 | 36 | 0 | 4060 | 34.13020303 | -86.86888037 | 2020-11-23 05:25:26 | Cullman, Alabama, US |
3838817 | 3838817 | 2020-11-21 | US | North Carolina | Nash | 37127 | 4155 | 95 | 0 | 4060 | 35.96575634 | -77.98422508 | 2020-11-22 05:25:45 | Nash, North Carolina, US |
2920933 | 2920933 | 2020-11-04 | US | Minnesota | Scott | 27139 | 4098 | 38 | 0 | 4060 | 44.6490231 | -93.53340251 | 2020-11-05 06:05:03 | Scott, Minnesota, US |
3654530 | 3654530 | 2020-10-24 | US | Tennessee | Montgomery | 47125 | 4153 | 55 | 0 | 4060 | 36.49609412 | -87.38550661 | 2020-10-25 04:24:36 | Montgomery, Tennessee, US |
1057354 | 1057354 | 2020-10-23 | US | Wisconsin | Fond du Lac | 55039 | 4079 | 19 | 0 | 4060 | 43.75354908 | -88.48885325 | 2020-10-24 04:24:46 | Fond du Lac, Wisconsin, US |
1053743 | 1053743 | 2020-10-23 | Germany | Sachsen | 12071 | 272 | 8120 | 4060 | 51.1045 | 13.2017 | 2020-10-24 04:24:46 | Sachsen, Germany | ||
2690063 | 2690063 | 2020-10-08 | US | Alabama | Marshall | 1095 | 4105 | 45 | 0 | 4060 | 34.36975964 | -86.30486727 | 2020-10-09 04:23:59 | Marshall, Alabama, US |
1044490 | 1044490 | 2020-10-07 | US | Pennsylvania | Luzerne | 42079 | 4250 | 190 | 0 | 4060 | 41.17823008 | -75.98447579 | 2020-10-08 04:23:56 | Luzerne, Pennsylvania, US |
2616219 | 2616219 | 2020-09-26 | US | New Mexico | McKinley | 35031 | 4317 | 257 | 0 | 4060 | 35.5800772 | -108.262245 | 2020-09-27 04:23:00 | McKinley, New Mexico, US |
2814934 | 2814934 | 2020-09-25 | US | New Mexico | McKinley | 35031 | 4316 | 256 | 0 | 4060 | 35.5800772 | -108.262245 | 2020-09-26 04:23:00 | McKinley, New Mexico, US |
1174189 | 1174189 | 2020-09-10 | US | Illinois | McHenry | 17111 | 4176 | 116 | 0 | 4060 | 42.32451172 | -88.45248227 | 2020-09-11 04:46:23 | McHenry, Illinois, US |
1997347 | 1997347 | 2020-08-26 | US | Florida | Martin | 12085 | 4173 | 113 | 0 | 4060 | 27.0772071 | -80.43109784 | 2020-08-27 04:28:15 | Martin, Florida, US |
1481120 | 1481120 | 2020-08-21 | US | Maryland | Howard | 24027 | 4178 | 118 | 0 | 4060 | 39.25305293 | -76.93126208 | 2020-08-22 04:27:49 | Howard, Maryland, US |
1926844 | 1926844 | 2020-07-30 | US | Michigan | Michigan Department of Corrections (MDOC) | 4129 | 69 | 0 | 4060 | 47.63197653 | 0.0 | 2020-07-31 04:35:18 | Michigan Department of Corrections (MDOC), Michigan, US | |
2957012 | 2957012 | 2020-07-29 | US | Michigan | Michigan Department of Corrections (MDOC) | 4128 | 68 | 0 | 4060 | 47.63197653 | 0.0 | 2020-07-30 04:35:05 | Michigan Department of Corrections (MDOC), Michigan, US | |
842787 | 842787 | 2020-07-22 | US | Missouri | Kansas City | 4102 | 42 | 0 | 4060 | 39.0997 | -94.5786 | 2020-07-23 05:15:04 | Kansas City, Missouri, US | |
3435166 | 3435166 | 2020-07-11 | US | Florida | Seminole | 12117 | 4083 | 23 | 0 | 4060 | 28.7158582 | -81.24060348 | 2020-07-12 04:34:30 | Seminole, Florida, US |
529943 | 529943 | 2020-07-04 | Brazil | Mato Grosso do Sul | 10089 | 117 | 5736 | 4060 | -20.7722 | -54.7852 | 2020-07-05 04:33:46 | Mato Grosso do Sul, Brazil | ||
2039636 | 2039636 | 2020-06-27 | Colombia | Bolivar | 8138 | 319 | 3759 | 4060 | 8.6704 | -74.03 | 2020-06-28 04:34:04 | Bolivar, Colombia | ||
1507475 | 1507475 | 2020-06-22 | US | Pennsylvania | Berks | 42011 | 4405 | 345 | 0 | 4060 | 40.41570541 | -75.92457766 | 2020-06-23 04:33:22 | Berks, Pennsylvania, US |
3059722 | 3059722 | 2020-06-13 | US | Michigan | Michigan Department of Corrections (MDOC) | 4128 | 68 | 0 | 4060 | 47.63197653 | 0.0 | 2020-06-14 03:33:15 | Michigan Department of Corrections (MDOC), Michigan, US | |
2862464 | 2862464 | 2020-06-10 | US | Michigan | Michigan Department of Corrections (MDOC) | 4129 | 69 | 0 | 4060 | 47.63197653 | 0.0 | 2020-06-11 03:33:41 | Michigan Department of Corrections (MDOC), Michigan, US | |
1431299 | 1431299 | 2020-05-20 | US | Missouri | St. Louis | 29189 | 4410 | 350 | 0 | 4060 | 38.63770039999999 | -90.4458375 | 2020-05-21 02:32:48 | St. Louis, Missouri, US |
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]);