daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
264 rows where active = 1022 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-08-04 | Colombia | Sucre | 57848 | 1566 | 55260 | 1022 | 8.814 | -74.7233 | 2021-08-05 04:21:51 | Sucre, Colombia | ||
2021-07-05 | Canada | Manitoba | 56482 | 1151 | 54309 | 1022 | 53.7609 | -98.8139 | 2021-07-06 04:21:32 | Manitoba, Canada | ||
2021-07-01 | Russia | Ryazan Oblast | 31147 | 612 | 29513 | 1022 | 54.42267320000001 | 40.57052460000001 | 2021-07-02 04:21:47 | Ryazan Oblast, Russia | ||
2021-07-01 | Pakistan | Islamabad | 82779 | 779 | 80978 | 1022 | 33.665087 | 73.121219 | 2021-07-02 04:21:47 | Islamabad, Pakistan | ||
2021-06-22 | Ukraine | Cherkasy Oblast | 81565 | 1299 | 79244 | 1022 | 49.4444 | 32.0598 | 2021-06-23 04:21:46 | Cherkasy Oblast, Ukraine | ||
2021-06-19 | Malaysia | Pahang | 11956 | 91 | 10843 | 1022 | 3.8126 | 103.3256 | 2021-06-20 04:21:48 | Pahang, Malaysia | ||
2021-04-13 | Chile | Coquimbo | 29250 | 560 | 27668 | 1022 | -29.959 | -71.3389 | 2021-04-14 04:20:41 | Coquimbo, Chile | ||
2021-04-01 | Russia | Yamalo-Nenets Autonomous Okrug | 38014 | 407 | 36585 | 1022 | 67.1471631 | 74.3415488 | 2021-04-02 04:20:36 | Yamalo-Nenets Autonomous Okrug, Russia | ||
2021-03-30 | Chile | Nuble | 21146 | 403 | 19721 | 1022 | -36.7226 | -71.7622 | 2021-03-31 04:26:25 | Nuble, Chile | ||
2021-03-27 | Italy | Molise | 12159 | 431 | 10706 | 1022 | 41.55774754 | 14.65916051 | 2021-03-28 05:28:10 | Molise, Italy | ||
2021-03-15 | Germany | Saarland | 30115 | 911 | 28213 | 1022 | 49.3964 | 7.023 | 2021-03-16 05:25:13 | Saarland, Germany | ||
2021-03-10 | Germany | Saarland | 29713 | 903 | 27834 | 1022 | 49.3964 | 7.023 | 2021-03-11 05:25:48 | Saarland, Germany | ||
2021-03-06 | US | Louisiana | Catahoula | 22025 | 1057 | 35 | 0 | 1022 | 31.66778967 | -91.84526385 | 2021-03-07 05:21:54 | Catahoula, Louisiana, US |
2021-03-05 | US | Louisiana | Catahoula | 22025 | 1057 | 35 | 0 | 1022 | 31.66778967 | -91.84526385 | 2021-03-06 04:23:41 | Catahoula, Louisiana, US |
2021-03-04 | US | Louisiana | Catahoula | 22025 | 1057 | 35 | 0 | 1022 | 31.66778967 | -91.84526385 | 2021-03-05 05:26:29 | Catahoula, Louisiana, US |
2021-03-02 | US | Indiana | Pulaski | 18131 | 1066 | 44 | 0 | 1022 | 41.04166107 | -86.69890683 | 2021-03-03 05:23:28 | Pulaski, Indiana, US |
2021-02-24 | US | Michigan | Charlevoix | 26029 | 1035 | 13 | 0 | 1022 | 45.37790017 | -85.19614053 | 2021-02-25 05:24:57 | Charlevoix, Michigan, US |
2021-02-24 | US | Florida | Liberty | 12077 | 1037 | 15 | 0 | 1022 | 30.23766008 | -84.8829258 | 2021-02-25 05:24:57 | Liberty, Florida, US |
2021-02-23 | US | Michigan | Charlevoix | 26029 | 1035 | 13 | 0 | 1022 | 45.37790017 | -85.19614053 | 2021-02-24 05:29:16 | Charlevoix, Michigan, US |
2021-02-23 | US | Alabama | Perry | 1105 | 1049 | 27 | 0 | 1022 | 32.64048341 | -87.29770589 | 2021-02-24 05:29:16 | Perry, Alabama, US |
2021-02-21 | US | Florida | Liberty | 12077 | 1036 | 14 | 0 | 1022 | 30.23766008 | -84.8829258 | 2021-02-22 05:24:21 | Liberty, Florida, US |
2021-02-20 | US | West Virginia | Grant | 54023 | 1047 | 25 | 0 | 1022 | 39.10314817 | -79.19440518 | 2021-02-21 05:24:33 | Grant, West Virginia, US |
2021-02-20 | US | Virginia | Sussex | 51183 | 1038 | 16 | 0 | 1022 | 36.92432914 | -77.25791182 | 2021-02-21 05:24:33 | Sussex, Virginia, US |
2021-02-20 | US | Florida | Liberty | 12077 | 1036 | 14 | 0 | 1022 | 30.23766008 | -84.8829258 | 2021-02-21 05:24:33 | Liberty, Florida, US |
2021-02-18 | US | Wyoming | Big Horn | 56003 | 1051 | 29 | 0 | 1022 | 44.52405055 | -107.9960365 | 2021-02-19 05:24:16 | Big Horn, Wyoming, US |
2021-02-18 | US | Georgia | Towns | 13281 | 1070 | 48 | 0 | 1022 | 34.91369188 | -83.74107459999998 | 2021-02-19 05:24:16 | Towns, Georgia, US |
2021-02-17 | Ukraine | Kherson Oblast | 21331 | 620 | 19689 | 1022 | 46.6354 | 32.6169 | 2021-02-18 05:22:58 | Kherson Oblast, Ukraine | ||
2021-02-17 | US | Oregon | Hood River | 41027 | 1051 | 29 | 0 | 1022 | 45.51872811 | -121.65520359999998 | 2021-02-18 05:22:58 | Hood River, Oregon, US |
2021-02-14 | Colombia | Cordoba | 35521 | 1781 | 32718 | 1022 | 8.0493 | -75.574 | 2021-02-15 05:24:49 | Cordoba, Colombia | ||
2021-02-13 | US | Montana | Dawson | 30021 | 1050 | 28 | 0 | 1022 | 47.26584855 | -104.89444170000002 | 2021-02-14 05:23:43 | Dawson, Montana, US |
2021-02-11 | US | Kentucky | Lewis | 21135 | 1052 | 30 | 0 | 1022 | 38.53184419 | -83.37735618 | 2021-02-12 05:23:29 | Lewis, Kentucky, US |
2021-02-11 | US | Alabama | Conecuh | 1035 | 1045 | 23 | 0 | 1022 | 31.43401703 | -86.99320044 | 2021-02-12 05:23:29 | Conecuh, Alabama, US |
2021-02-10 | US | West Virginia | Wetzel | 54103 | 1041 | 19 | 0 | 1022 | 39.6065771 | -80.64016540000001 | 2021-02-11 05:23:55 | Wetzel, West Virginia, US |
2021-02-08 | US | Puerto Rico | Las Piedras | 72085 | 1022 | 0 | 0 | 1022 | 18.187527 | -65.86946800000001 | 2021-02-09 05:23:30 | Las Piedras, Puerto Rico, US |
2021-02-07 | US | Minnesota | Kanabec | 27065 | 1040 | 18 | 0 | 1022 | 45.9459309 | -93.29275192 | 2021-02-08 05:22:39 | Kanabec, Minnesota, US |
2021-02-07 | Burkina Faso | 11285 | 134 | 10129 | 1022 | 12.2383 | -1.5616 | 2021-02-08 05:22:39 | Burkina Faso | |||
2021-02-06 | US | Vermont | Rutland | 50021 | 1031 | 9 | 0 | 1022 | 43.57723578 | -73.03741676 | 2021-02-07 05:23:00 | Rutland, Vermont, US |
2021-02-05 | US | Oklahoma | Nowata | 40105 | 1036 | 14 | 0 | 1022 | 36.79843529 | -95.61902331 | 2021-02-06 05:23:55 | Nowata, Oklahoma, US |
2021-02-05 | US | Georgia | Early | 13099 | 1066 | 44 | 0 | 1022 | 31.32155345 | -84.90255207 | 2021-02-06 05:23:55 | Early, Georgia, US |
2021-02-04 | US | Maryland | Kent | 24029 | 1059 | 37 | 0 | 1022 | 39.24976208 | -76.04741541 | 2021-02-05 05:22:38 | Kent, Maryland, US |
2021-02-03 | US | Louisiana | Caldwell | 22021 | 1046 | 24 | 0 | 1022 | 32.0902519 | -92.11752148 | 2021-02-04 05:22:26 | Caldwell, Louisiana, US |
2021-02-03 | US | Arkansas | Little River | 5081 | 1062 | 40 | 0 | 1022 | 33.70375665 | -94.23468591 | 2021-02-04 05:22:26 | Little River, Arkansas, US |
2021-02-01 | US | Pennsylvania | Wyoming | 42131 | 1059 | 37 | 0 | 1022 | 41.51955538 | -76.01074915 | 2021-02-02 05:22:49 | Wyoming, Pennsylvania, US |
2021-01-31 | Russia | Bryansk Oblast | 29078 | 239 | 27817 | 1022 | 52.8873315 | 33.41585300000001 | 2021-02-01 05:22:53 | Bryansk Oblast, Russia | ||
2021-01-29 | US | California | Inyo | 6027 | 1056 | 27 | 0 | 1022 | 36.51112084 | -117.41119779999998 | 2021-01-30 05:22:49 | Inyo, California, US |
2021-01-28 | US | Puerto Rico | Aguadilla | 72005 | 1022 | 0 | 0 | 1022 | 18.459681 | -67.12081500000001 | 2021-01-29 05:22:23 | Aguadilla, Puerto Rico, US |
2021-01-27 | Italy | Molise | 8016 | 261 | 6733 | 1022 | 41.55774754 | 14.65916051 | 2021-01-28 05:22:24 | Molise, Italy | ||
2021-01-26 | US | Iowa | Guthrie | 19077 | 1046 | 24 | 0 | 1022 | 41.68378965 | -94.50111014 | 2021-01-27 05:23:41 | Guthrie, Iowa, US |
2021-01-26 | US | Iowa | Franklin | 19069 | 1040 | 18 | 0 | 1022 | 42.73270384 | -93.26256925 | 2021-01-27 05:23:41 | Franklin, Iowa, US |
2021-01-25 | Malaysia | Perak | 5524 | 23 | 4479 | 1022 | 4.5921 | 101.0901 | 2021-01-26 05:22:02 | Perak, Malaysia | ||
2021-01-25 | US | Mississippi | Perry | 28111 | 1053 | 31 | 0 | 1022 | 31.17161885 | -88.99281835 | 2021-01-26 05:22:02 | Perry, Mississippi, US |
2021-01-25 | US | Iowa | Guthrie | 19077 | 1046 | 24 | 0 | 1022 | 41.68378965 | -94.50111014 | 2021-01-26 05:22:02 | Guthrie, Iowa, US |
2021-01-24 | US | Kansas | Osage | 20139 | 1037 | 15 | 0 | 1022 | 38.65235984 | -95.72707998 | 2021-01-25 05:22:16 | Osage, Kansas, US |
2021-01-23 | US | Kansas | Osage | 20139 | 1037 | 15 | 0 | 1022 | 38.65235984 | -95.72707998 | 2021-01-24 05:22:35 | Osage, Kansas, US |
2021-01-23 | Maldives | 14885 | 50 | 13813 | 1022 | 3.2028 | 73.2207 | 2021-01-24 05:22:35 | Maldives | |||
2021-01-22 | US | Kansas | Osage | 20139 | 1037 | 15 | 0 | 1022 | 38.65235984 | -95.72707998 | 2021-01-23 05:22:03 | Osage, Kansas, US |
2021-01-22 | US | Georgia | Dade | 13083 | 1031 | 9 | 0 | 1022 | 34.854916700000004 | -85.50490424 | 2021-01-23 05:22:03 | Dade, Georgia, US |
2021-01-20 | Russia | Tyva Republic | 15227 | 185 | 14020 | 1022 | 51.4017149 | 93.8582593 | 2021-01-21 05:22:01 | Tyva Republic, Russia | ||
2021-01-19 | US | Ohio | Meigs | 39105 | 1050 | 28 | 0 | 1022 | 39.09224872 | -82.0305041 | 2021-01-20 05:21:54 | Meigs, Ohio, US |
2021-01-18 | US | Kentucky | Washington | 21229 | 1038 | 16 | 0 | 1022 | 37.75599461 | -85.17407732 | 2021-01-19 05:22:15 | Washington, Kentucky, US |
2021-01-17 | US | Louisiana | East Carroll | 22035 | 1041 | 19 | 0 | 1022 | 32.73926954 | -91.23425694 | 2021-01-18 05:22:34 | East Carroll, Louisiana, US |
2021-01-16 | US | Oklahoma | Haskell | 40061 | 1029 | 7 | 0 | 1022 | 35.22257600000001 | -95.11513306 | 2021-01-17 05:22:17 | Haskell, Oklahoma, US |
2021-01-16 | US | North Carolina | Polk | 37149 | 1036 | 14 | 0 | 1022 | 35.27820615 | -82.16812354 | 2021-01-17 05:22:17 | Polk, North Carolina, US |
2021-01-11 | US | North Dakota | Mercer | 38057 | 1021 | 9 | 0 | 1022 | 47.31213126 | -101.8318399 | 2021-01-12 05:22:15 | Mercer, North Dakota, US |
2021-01-11 | US | Kentucky | Monroe | 21171 | 1050 | 28 | 0 | 1022 | 36.71225341 | -85.71596443 | 2021-01-12 05:22:15 | Monroe, Kentucky, US |
2021-01-10 | US | North Dakota | Mercer | 38057 | 1017 | 9 | 0 | 1022 | 47.31213126 | -101.8318399 | 2021-01-11 05:21:50 | Mercer, North Dakota, US |
2021-01-08 | US | Texas | Lee | 48287 | 1105 | 31 | 0 | 1022 | 30.31120597 | -96.97045773 | 2021-01-09 05:22:18 | Lee, Texas, US |
2021-01-07 | US | Virginia | Louisa | 51109 | 1033 | 11 | 0 | 1022 | 37.97850256 | -77.96274807 | 2021-01-08 05:22:42 | Louisa, Virginia, US |
2021-01-06 | US | Iowa | Emmet | 19063 | 1050 | 28 | 0 | 1022 | 43.37782951 | -94.67858943 | 2021-01-07 05:22:03 | Emmet, Iowa, US |
2021-01-05 | US | Virginia | Martinsville | 51690 | 1049 | 27 | 0 | 1022 | 36.68212094 | -79.86352771 | 2021-01-06 05:22:16 | Martinsville, Virginia, US |
2021-01-04 | US | Wisconsin | Price | 55099 | 1027 | 5 | 0 | 1022 | 45.68051754 | -90.3609888 | 2021-01-05 05:21:49 | Price, Wisconsin, US |
2021-01-04 | US | West Virginia | McDowell | 54047 | 1028 | 6 | 0 | 1022 | 37.38002939 | -81.65083669 | 2021-01-05 05:21:49 | McDowell, West Virginia, US |
2021-01-04 | US | Virginia | Orange | 51137 | 1035 | 13 | 0 | 1022 | 38.24530219 | -78.01560400000002 | 2021-01-05 05:21:49 | Orange, Virginia, US |
2021-01-04 | US | Texas | Panola | 48365 | 1314 | 41 | 0 | 1022 | 32.163959600000005 | -94.30552481 | 2021-01-05 05:21:49 | Panola, Texas, US |
2021-01-03 | US | Wisconsin | Price | 55099 | 1027 | 5 | 0 | 1022 | 45.68051754 | -90.3609888 | 2021-01-04 05:22:02 | Price, Wisconsin, US |
2021-01-03 | US | Kentucky | Anderson | 21005 | 1025 | 3 | 0 | 1022 | 38.00671029 | -84.99171713 | 2021-01-04 05:22:02 | Anderson, Kentucky, US |
2021-01-03 | US | Iowa | Jefferson | 19101 | 1042 | 20 | 0 | 1022 | 41.03192394 | -91.94849466 | 2021-01-04 05:22:02 | Jefferson, Iowa, US |
2021-01-02 | US | Minnesota | Sibley | 27143 | 1027 | 5 | 0 | 1022 | 44.5796592 | -94.23164924 | 2021-01-03 05:22:52 | Sibley, Minnesota, US |
2021-01-01 | US | Texas | Austin | 48015 | 1108 | 15 | 0 | 1022 | 29.88548725 | -96.27736949 | 2021-01-02 05:22:33 | Austin, Texas, US |
2020-12-30 | US | Iowa | Chickasaw | 19037 | 1033 | 11 | 0 | 1022 | 43.06001295 | -92.31773347 | 2020-12-31 05:22:49 | Chickasaw, Iowa, US |
2020-12-30 | US | Alabama | Lamar | 1075 | 1037 | 15 | 0 | 1022 | 33.77995024 | -88.09668032 | 2020-12-31 05:22:49 | Lamar, Alabama, US |
2020-12-29 | US | Illinois | Piatt | 17147 | 1029 | 7 | 0 | 1022 | 40.01360584 | -88.59319339 | 2020-12-30 05:22:34 | Piatt, Illinois, US |
2020-12-29 | US | Georgia | Worth | 13321 | 1062 | 40 | 0 | 1022 | 31.55162306 | -83.85090513 | 2020-12-30 05:22:34 | Worth, Georgia, US |
2020-12-29 | US | Colorado | Pitkin | 8097 | 1199 | 4 | 0 | 1022 | 39.21720112 | -106.9310027 | 2020-12-30 05:22:34 | Pitkin, Colorado, US |
2020-12-26 | US | Ohio | Carroll | 39019 | 1045 | 23 | 0 | 1022 | 40.5789686 | -81.09178213 | 2020-12-27 05:22:55 | Carroll, Ohio, US |
2020-12-18 | US | Wisconsin | Burnett | 55013 | 1038 | 16 | 0 | 1022 | 45.86303537 | -92.36711412 | 2020-12-19 05:27:52 | Burnett, Wisconsin, US |
2020-12-18 | US | Texas | Nolan | 48353 | 851 | 13 | 0 | 1022 | 32.30365282 | -100.4060208 | 2020-12-19 05:27:52 | Nolan, Texas, US |
2020-12-16 | US | Nebraska | Seward | 31159 | 1041 | 19 | 0 | 1022 | 40.87241834 | -97.139673 | 2020-12-17 05:28:12 | Seward, Nebraska, US |
2020-12-16 | US | Illinois | Washington | 17189 | 1032 | 10 | 0 | 1022 | 38.35309213 | -89.40982703 | 2020-12-17 05:28:12 | Washington, Illinois, US |
2020-12-16 | US | Georgia | Cook | 13075 | 1044 | 22 | 0 | 1022 | 31.16068491 | -83.42947229 | 2020-12-17 05:28:12 | Cook, Georgia, US |
2020-12-15 | US | Indiana | Owen | 18119 | 1041 | 19 | 0 | 1022 | 39.31145587 | -86.83900724 | 2020-12-16 05:28:04 | Owen, Indiana, US |
2020-12-11 | US | Texas | Limestone | 48293 | 979 | 20 | 0 | 1022 | 31.5454767 | -96.58095444 | 2020-12-12 05:26:19 | Limestone, Texas, US |
2020-12-10 | US | Texas | Limestone | 48293 | 950 | 20 | 0 | 1022 | 31.5454767 | -96.58095444 | 2020-12-11 05:26:59 | Limestone, Texas, US |
2020-12-10 | US | Connecticut | Unassigned | 90009 | 1023 | 1 | 0 | 1022 | 41.85853803 | 0.0 | 2020-12-11 05:26:59 | Unassigned, Connecticut, US |
2020-12-09 | US | Texas | Milam | 48331 | 556 | 10 | 0 | 1022 | 30.785818300000006 | -96.97718698 | 2020-12-10 05:26:19 | Milam, Texas, US |
2020-12-09 | US | Ohio | Wyandot | 39175 | 1043 | 21 | 0 | 1022 | 40.84339621 | -83.30734173 | 2020-12-10 05:26:19 | Wyandot, Ohio, US |
2020-12-09 | US | Nevada | Churchill | 32001 | 1044 | 22 | 0 | 1022 | 39.58105744 | -118.3394607 | 2020-12-10 05:26:19 | Churchill, Nevada, US |
2020-12-07 | US | Texas | Gaines | 48165 | 375 | 18 | 0 | 1022 | 32.74055318 | -102.6353295 | 2020-12-08 05:27:42 | Gaines, Texas, US |
2020-12-06 | US | Texas | Gaines | 48165 | 371 | 18 | 0 | 1022 | 32.74055318 | -102.6353295 | 2020-12-07 05:26:14 | Gaines, Texas, US |
2020-12-06 | US | Indiana | Fulton | 18049 | 1047 | 25 | 0 | 1022 | 41.0469907 | -86.26252745 | 2020-12-07 05:26:14 | Fulton, Indiana, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;