daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
250 rows where active = 1004 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-07-08 | India | Nagaland | 25727 | 505 | 24218 | 1004 | 26.06702 | 94.470302 | 2021-07-09 04:21:21 | Nagaland, India | ||
2021-06-29 | Russia | Ivanovo Oblast | 38138 | 1289 | 35845 | 1004 | 56.9167446 | 41.43521370000001 | 2021-06-30 04:21:41 | Ivanovo Oblast, Russia | ||
2021-05-03 | Chile | Los Rios | 34171 | 384 | 32783 | 1004 | -40.231 | -72.3311 | 2021-05-04 04:20:34 | Los Rios, Chile | ||
2021-05-02 | Russia | Kurgan Oblast | 20431 | 398 | 19029 | 1004 | 55.7655302 | 64.5632681 | 2021-05-03 04:20:39 | Kurgan Oblast, Russia | ||
2021-05-01 | Russia | Kurgan Oblast | 20399 | 398 | 18997 | 1004 | 55.7655302 | 64.5632681 | 2021-05-02 04:20:48 | Kurgan Oblast, Russia | ||
2021-04-24 | Japan | Nara | 5579 | 69 | 4506 | 1004 | 34.317451 | 135.871644 | 2021-04-25 04:20:32 | Nara, Japan | ||
2021-03-18 | Angola | 21558 | 522 | 20032 | 1004 | -11.2027 | 17.8739 | 2021-03-19 05:26:09 | Angola | |||
2021-03-08 | Bahamas | 8600 | 181 | 7415 | 1004 | 25.025885 | -78.035889 | 2021-03-09 05:28:19 | Bahamas | |||
2021-03-07 | Bahamas | 8600 | 181 | 7415 | 1004 | 25.025885 | -78.035889 | 2021-03-08 05:24:48 | Bahamas | |||
2021-03-06 | Bahamas | 8600 | 181 | 7415 | 1004 | 25.025885 | -78.035889 | 2021-03-07 05:21:54 | Bahamas | |||
2021-03-05 | Bahamas | 8600 | 181 | 7415 | 1004 | 25.025885 | -78.035889 | 2021-03-06 04:23:41 | Bahamas | |||
2021-03-04 | US | Tennessee | Houston | 47083 | 1039 | 32 | 0 | 1004 | 36.28872054 | -87.71878828 | 2021-03-05 05:26:29 | Houston, Tennessee, US |
2021-02-28 | US | Alaska | North Slope | 2185 | 1008 | 4 | 0 | 1004 | 69.31479216 | -153.4836093 | 2021-03-01 05:23:01 | North Slope, Alaska, US |
2021-02-27 | US | Alaska | North Slope | 2185 | 1008 | 4 | 0 | 1004 | 69.31479216 | -153.4836093 | 2021-02-28 05:22:20 | North Slope, Alaska, US |
2021-02-26 | US | Alaska | North Slope | 2185 | 1008 | 4 | 0 | 1004 | 69.31479216 | -153.4836093 | 2021-02-27 05:22:28 | North Slope, Alaska, US |
2021-02-25 | US | Alaska | North Slope | 2185 | 1008 | 4 | 0 | 1004 | 69.31479216 | -153.4836093 | 2021-02-26 05:22:40 | North Slope, Alaska, US |
2021-02-24 | US | Alaska | North Slope | 2185 | 1008 | 4 | 0 | 1004 | 69.31479216 | -153.4836093 | 2021-02-25 05:24:57 | North Slope, Alaska, US |
2021-02-23 | US | West Virginia | Lewis | 54041 | 1020 | 16 | 0 | 1004 | 38.9947249 | -80.49988181 | 2021-02-24 05:29:16 | Lewis, West Virginia, US |
2021-02-23 | US | Alaska | North Slope | 2185 | 1008 | 4 | 0 | 1004 | 69.31479216 | -153.4836093 | 2021-02-24 05:29:16 | North Slope, Alaska, US |
2021-02-22 | US | Oklahoma | Unassigned | 90040 | 1004 | 0 | 0 | 1004 | 36.83532655 | 0.0 | 2021-02-23 05:23:41 | Unassigned, Oklahoma, US |
2021-02-22 | US | Alaska | North Slope | 2185 | 1008 | 4 | 0 | 1004 | 69.31479216 | -153.4836093 | 2021-02-23 05:23:41 | North Slope, Alaska, US |
2021-02-18 | US | South Dakota | Turner | 46125 | 1055 | 51 | 0 | 1004 | 43.3109081 | -97.14865776 | 2021-02-19 05:24:16 | Turner, South Dakota, US |
2021-02-18 | US | Louisiana | Catahoula | 22025 | 1037 | 33 | 0 | 1004 | 31.66778967 | -91.84526385 | 2021-02-19 05:24:16 | Catahoula, Louisiana, US |
2021-02-18 | US | Indiana | Pulaski | 18131 | 1046 | 42 | 0 | 1004 | 41.04166107 | -86.69890683 | 2021-02-19 05:24:16 | Pulaski, Indiana, US |
2021-02-15 | Angola | 20381 | 493 | 18884 | 1004 | -11.2027 | 17.8739 | 2021-02-16 05:24:38 | Angola | |||
2021-02-14 | Russia | Bryansk Oblast | 31318 | 249 | 30065 | 1004 | 52.8873315 | 33.41585300000001 | 2021-02-15 05:24:49 | Bryansk Oblast, Russia | ||
2021-02-13 | US | Louisiana | Catahoula | 22025 | 1037 | 33 | 0 | 1004 | 31.66778967 | -91.84526385 | 2021-02-14 05:23:43 | Catahoula, Louisiana, US |
2021-02-13 | US | Georgia | Johnson | 13167 | 1049 | 45 | 0 | 1004 | 32.70211082 | -82.66166794 | 2021-02-14 05:23:43 | Johnson, Georgia, US |
2021-02-12 | US | Louisiana | Catahoula | 22025 | 1037 | 33 | 0 | 1004 | 31.66778967 | -91.84526385 | 2021-02-13 05:22:12 | Catahoula, Louisiana, US |
2021-02-12 | Colombia | Cordoba | 35223 | 1771 | 32448 | 1004 | 8.0493 | -75.574 | 2021-02-13 05:22:12 | Cordoba, Colombia | ||
2021-02-11 | US | Georgia | Towns | 13281 | 1049 | 45 | 0 | 1004 | 34.91369188 | -83.74107459999998 | 2021-02-12 05:23:29 | Towns, Georgia, US |
2021-02-09 | Colombia | Cauca | 26605 | 700 | 24901 | 1004 | 2.705 | -76.82600000000002 | 2021-02-10 05:22:41 | Cauca, Colombia | ||
2021-02-08 | Colombia | Cordoba | 34467 | 1758 | 31705 | 1004 | 8.0493 | -75.574 | 2021-02-09 05:23:30 | Cordoba, Colombia | ||
2021-02-05 | US | West Virginia | Wetzel | 54103 | 1023 | 19 | 0 | 1004 | 39.6065771 | -80.64016540000001 | 2021-02-06 05:23:55 | Wetzel, West Virginia, US |
2021-02-05 | US | Mississippi | Webster | 28155 | 1028 | 24 | 0 | 1004 | 33.61300486 | -89.28392912 | 2021-02-06 05:23:55 | Webster, Mississippi, US |
2021-02-04 | US | Oklahoma | Washita | 40149 | 1011 | 7 | 0 | 1004 | 35.29071824 | -98.99180434 | 2021-02-05 05:22:38 | Washita, Oklahoma, US |
2021-02-03 | US | Kentucky | Breckinridge | 21027 | 1009 | 5 | 0 | 1004 | 37.77377239 | -86.42885017 | 2021-02-04 05:22:26 | Breckinridge, Kentucky, US |
2021-02-01 | US | Minnesota | Kanabec | 27065 | 1022 | 18 | 0 | 1004 | 45.9459309 | -93.29275192 | 2021-02-02 05:22:49 | Kanabec, Minnesota, US |
2021-02-01 | US | Arkansas | Little River | 5081 | 1043 | 39 | 0 | 1004 | 33.70375665 | -94.23468591 | 2021-02-02 05:22:49 | Little River, Arkansas, US |
2021-01-30 | US | Montana | Dawson | 30021 | 1032 | 28 | 0 | 1004 | 47.26584855 | -104.89444170000002 | 2021-01-31 05:22:42 | Dawson, Montana, US |
2021-01-29 | US | New York | Schoharie | 36095 | 1012 | 8 | 0 | 1004 | 42.58831742 | -74.44339029999998 | 2021-01-30 05:22:49 | Schoharie, New York, US |
2021-01-28 | US | Puerto Rico | Manati | 72091 | 1004 | 0 | 0 | 1004 | 18.420473 | -66.490461 | 2021-01-29 05:22:23 | Manati, Puerto Rico, US |
2021-01-28 | US | Missouri | Bates | 29013 | 1020 | 16 | 0 | 1004 | 38.25271289 | -94.34113157 | 2021-01-29 05:22:23 | Bates, Missouri, US |
2021-01-27 | US | Texas | Callahan | 48059 | 1026 | 31 | 0 | 1004 | 32.29760619 | -99.37326312 | 2021-01-28 05:22:24 | Callahan, Texas, US |
2021-01-27 | US | Ohio | Monroe | 39111 | 1043 | 39 | 0 | 1004 | 39.72984936 | -81.08464734 | 2021-01-28 05:22:24 | Monroe, Ohio, US |
2021-01-25 | US | Virginia | Buchanan | 51027 | 1031 | 27 | 0 | 1004 | 37.26818323 | -82.03749726 | 2021-01-26 05:22:02 | Buchanan, Virginia, US |
2021-01-24 | Malaysia | Perak | 5421 | 22 | 4395 | 1004 | 4.5921 | 101.0901 | 2021-01-25 05:22:16 | Perak, Malaysia | ||
2021-01-24 | US | Virginia | Buchanan | 51027 | 1031 | 27 | 0 | 1004 | 37.26818323 | -82.03749726 | 2021-01-25 05:22:16 | Buchanan, Virginia, US |
2021-01-23 | US | New York | Essex | 36031 | 1025 | 21 | 0 | 1004 | 44.11630765 | -73.77297842 | 2021-01-24 05:22:35 | Essex, New York, US |
2021-01-23 | Russia | Tyva Republic | 15308 | 185 | 14119 | 1004 | 51.4017149 | 93.8582593 | 2021-01-24 05:22:35 | Tyva Republic, Russia | ||
2021-01-22 | US | Missouri | Bollinger | 29017 | 1016 | 12 | 0 | 1004 | 37.32449052 | -90.02725304 | 2021-01-23 05:22:03 | Bollinger, Missouri, US |
2021-01-21 | US | Louisiana | Caldwell | 22021 | 1027 | 23 | 0 | 1004 | 32.0902519 | -92.11752148 | 2021-01-22 05:22:10 | Caldwell, Louisiana, US |
2021-01-19 | US | Louisiana | West Feliciana | 22125 | 1032 | 28 | 0 | 1004 | 30.87882871 | -91.4148538 | 2021-01-20 05:21:54 | West Feliciana, Louisiana, US |
2021-01-17 | US | Ohio | Meigs | 39105 | 1032 | 28 | 0 | 1004 | 39.09224872 | -82.0305041 | 2021-01-18 05:22:34 | Meigs, Ohio, US |
2021-01-16 | US | Puerto Rico | Corozal | 72047 | 1004 | 0 | 0 | 1004 | 18.304264 | -66.327738 | 2021-01-17 05:22:17 | Corozal, Puerto Rico, US |
2021-01-16 | US | Mississippi | Lawrence | 28077 | 1021 | 17 | 0 | 1004 | 31.55147224 | -90.10841127 | 2021-01-17 05:22:17 | Lawrence, Mississippi, US |
2021-01-15 | US | Illinois | Jasper | 17079 | 1019 | 15 | 0 | 1004 | 39.01054275 | -88.15437049 | 2021-01-16 05:22:40 | Jasper, Illinois, US |
2021-01-13 | US | Tennessee | Stewart | 47161 | 1044 | 20 | 0 | 1004 | 36.50235092 | -87.83920548 | 2021-01-14 05:22:32 | Stewart, Tennessee, US |
2021-01-12 | US | Michigan | Roscommon | 26143 | 1032 | 28 | 0 | 1004 | 44.33473082 | -84.61067651 | 2021-01-13 05:22:15 | Roscommon, Michigan, US |
2021-01-10 | US | Missouri | Macon | 29121 | 1014 | 10 | 0 | 1004 | 39.83049768 | -92.56453089 | 2021-01-11 05:21:50 | Macon, Missouri, US |
2021-01-10 | US | Kentucky | Harrison | 21097 | 1005 | 1 | 0 | 1004 | 38.44188174 | -84.32869741 | 2021-01-11 05:21:50 | Harrison, Kentucky, US |
2021-01-09 | US | Florida | Franklin | 12037 | 1008 | 4 | 0 | 1004 | 29.83791238 | -84.82731662 | 2021-01-10 05:22:12 | Franklin, Florida, US |
2021-01-08 | US | Mississippi | Greene | 28041 | 1031 | 27 | 0 | 1004 | 31.21444233 | -88.63922281 | 2021-01-09 05:22:18 | Greene, Mississippi, US |
2021-01-06 | US | Wyoming | Goshen | 56015 | 1021 | 17 | 0 | 1004 | 42.08798185 | -104.3534743 | 2021-01-07 05:22:03 | Goshen, Wyoming, US |
2021-01-05 | US | Montana | Rosebud | 30087 | 1032 | 28 | 0 | 1004 | 46.23397237 | -106.72928799999998 | 2021-01-06 05:22:16 | Rosebud, Montana, US |
2021-01-05 | US | Iowa | Emmet | 19063 | 1032 | 28 | 0 | 1004 | 43.37782951 | -94.67858943 | 2021-01-06 05:22:16 | Emmet, Iowa, US |
2021-01-04 | US | Michigan | Wexford | 26165 | 1024 | 20 | 0 | 1004 | 44.33853602 | -85.57712739 | 2021-01-05 05:21:49 | Wexford, Michigan, US |
2021-01-03 | US | Virginia | Martinsville | 51690 | 1031 | 27 | 0 | 1004 | 36.68212094 | -79.86352771 | 2021-01-04 05:22:02 | Martinsville, Virginia, US |
2021-01-01 | US | South Dakota | Lake | 46079 | 1020 | 16 | 0 | 1004 | 44.02193107 | -97.12926365 | 2021-01-02 05:22:33 | Lake, South Dakota, US |
2020-12-31 | US | South Dakota | Lake | 46079 | 1020 | 16 | 0 | 1004 | 44.02193107 | -97.12926365 | 2021-01-01 05:23:07 | Lake, South Dakota, US |
2020-12-28 | Colombia | Magdalena | 24474 | 1052 | 22418 | 1004 | 10.4113 | -74.4057 | 2020-12-29 05:22:37 | Magdalena, Colombia | ||
2020-12-28 | China | Hong Kong | 8671 | 139 | 7526 | 1004 | 22.3 | 114.2 | 2020-12-29 05:22:37 | Hong Kong, China | ||
2020-12-26 | US | Wisconsin | Ashland | 55003 | 1018 | 14 | 0 | 1004 | 46.31956891 | -90.67837132 | 2020-12-27 05:22:55 | Ashland, Wisconsin, US |
2020-12-26 | US | Iowa | Chickasaw | 19037 | 1014 | 10 | 0 | 1004 | 43.06001295 | -92.31773347 | 2020-12-27 05:22:55 | Chickasaw, Iowa, US |
2020-12-25 | US | Iowa | Chickasaw | 19037 | 1014 | 10 | 0 | 1004 | 43.06001295 | -92.31773347 | 2020-12-26 05:22:28 | Chickasaw, Iowa, US |
2020-12-24 | US | Iowa | Sac | 19161 | 1018 | 14 | 0 | 1004 | 42.38624071 | -95.10547892 | 2020-12-25 05:22:48 | Sac, Iowa, US |
2020-12-23 | US | New York | Chenango | 36017 | 1020 | 16 | 0 | 1004 | 42.49430041 | -75.60887553 | 2020-12-24 05:23:04 | Chenango, New York, US |
2020-12-22 | US | Kentucky | Lee | 21129 | 1022 | 18 | 0 | 1004 | 37.59645942 | -83.71513901 | 2020-12-23 05:22:03 | Lee, Kentucky, US |
2020-12-19 | US | Wisconsin | Washburn | 55129 | 1015 | 11 | 0 | 1004 | 45.89838588 | -91.79050449 | 2020-12-20 05:27:32 | Washburn, Wisconsin, US |
2020-12-19 | US | Georgia | Morgan | 13211 | 1012 | 8 | 0 | 1004 | 33.59232073 | -83.49129491 | 2020-12-20 05:27:32 | Morgan, Georgia, US |
2020-12-18 | US | Minnesota | Watonwan | 27165 | 1009 | 5 | 0 | 1004 | 43.97823903 | -94.61413846 | 2020-12-19 05:27:52 | Watonwan, Minnesota, US |
2020-12-18 | Chile | Los Lagos | 23214 | 236 | 21974 | 1004 | -41.9198 | -72.1416 | 2020-12-19 05:27:52 | Los Lagos, Chile | ||
2020-12-17 | US | Texas | Parmer | 48369 | 1170 | 29 | 0 | 1004 | 34.52993409 | -102.7844668 | 2020-12-18 05:28:18 | Parmer, Texas, US |
2020-12-17 | US | Kentucky | Johnson | 21115 | 1016 | 12 | 0 | 1004 | 37.85106355 | -82.8264322 | 2020-12-18 05:28:18 | Johnson, Kentucky, US |
2020-12-16 | US | Wisconsin | Richland | 55103 | 1017 | 13 | 0 | 1004 | 43.3762778 | -90.43012729 | 2020-12-17 05:28:12 | Richland, Wisconsin, US |
2020-12-15 | US | Tennessee | Benton | 47005 | 1034 | 25 | 0 | 1004 | 36.07110411 | -88.06849355 | 2020-12-16 05:28:04 | Benton, Tennessee, US |
2020-12-15 | US | Puerto Rico | Dorado | 72051 | 1004 | 0 | 0 | 1004 | 18.436115 | -66.278669 | 2020-12-16 05:28:04 | Dorado, Puerto Rico, US |
2020-12-13 | US | Virginia | Southampton | 51175 | 1044 | 40 | 0 | 1004 | 36.72231125 | -77.10642712 | 2020-12-14 05:26:27 | Southampton, Virginia, US |
2020-12-12 | US | Arkansas | Hempstead | 5057 | 1013 | 9 | 0 | 1004 | 33.73325583 | -93.66935133 | 2020-12-13 05:27:20 | Hempstead, Arkansas, US |
2020-12-09 | US | Texas | Limestone | 48293 | 934 | 20 | 0 | 1004 | 31.5454767 | -96.58095444 | 2020-12-10 05:26:19 | Limestone, Texas, US |
2020-12-09 | US | Illinois | Edgar | 17045 | 1019 | 15 | 0 | 1004 | 39.6809186 | -87.74759563 | 2020-12-10 05:26:19 | Edgar, Illinois, US |
2020-12-08 | US | Illinois | Wayne | 17191 | 1038 | 34 | 0 | 1004 | 38.42955355 | -88.42586459 | 2020-12-09 05:28:01 | Wayne, Illinois, US |
2020-12-05 | US | Louisiana | Winn | 22127 | 1030 | 26 | 0 | 1004 | 31.94449367 | -92.63789413 | 2020-12-06 05:26:18 | Winn, Louisiana, US |
2020-12-04 | US | Texas | Kendall | 48259 | 1116 | 17 | 0 | 1004 | 29.94414155 | -98.7113588 | 2020-12-05 05:27:36 | Kendall, Texas, US |
2020-12-04 | US | Louisiana | Winn | 22127 | 1030 | 26 | 0 | 1004 | 31.94449367 | -92.63789413 | 2020-12-05 05:27:36 | Winn, Louisiana, US |
2020-12-02 | US | Georgia | Grady | 13131 | 1035 | 31 | 0 | 1004 | 30.87454847 | -84.23418364 | 2020-12-03 05:28:22 | Grady, Georgia, US |
2020-12-01 | US | Louisiana | Assumption | 22007 | 1029 | 25 | 0 | 1004 | 29.89946234 | -91.06461642 | 2020-12-02 05:27:41 | Assumption, Louisiana, US |
2020-12-01 | US | Georgia | Monroe | 13207 | 1065 | 61 | 0 | 1004 | 33.014289 | -83.92097166 | 2020-12-02 05:27:41 | Monroe, Georgia, US |
2020-11-30 | US | West Virginia | Logan | 54045 | 1055 | 51 | 0 | 1004 | 37.8299889 | -81.93528571 | 2020-12-01 05:26:18 | Logan, West Virginia, US |
2020-11-29 | Malaysia | Negeri Sembilan | 4775 | 9 | 3762 | 1004 | 2.7258 | 101.9424 | 2020-11-30 05:26:13 | Negeri Sembilan, Malaysia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;