daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
53 rows where confirmed = 9791 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-07-25 | US | Virginia | Prince George | 51149 | 9791 | 80 | 0 | 37.18497668 | -77.22922187 | 2022-07-26 04:20:58 | Prince George, Virginia, US | |
2022-07-18 | US | Puerto Rico | Canovanas | 72029 | 9791 | 0 | 0 | 18.328802 | -65.887612 | 2022-07-19 04:20:58 | Canovanas, Puerto Rico, US | |
2022-07-02 | US | Arkansas | Boone | 5009 | 9791 | 181 | 0 | 36.3084504 | -93.09374925 | 2022-07-03 04:20:59 | Boone, Arkansas, US | |
2022-06-28 | US | Texas | Lamar | 48277 | 9791 | 258 | 0 | 33.66981763 | -95.57404777 | 2022-06-29 04:20:59 | Lamar, Texas, US | |
2022-04-03 | US | Virginia | Charlottesville | 51540 | 9791 | 75 | 0 | 38.03527919 | -78.48569588 | 2022-04-04 04:20:51 | Charlottesville, Virginia, US | |
2022-04-02 | US | Virginia | Charlottesville | 51540 | 9791 | 75 | 0 | 38.03527919 | -78.48569588 | 2022-04-03 04:20:48 | Charlottesville, Virginia, US | |
2022-04-01 | US | Virginia | Charlottesville | 51540 | 9791 | 75 | 0 | 38.03527919 | -78.48569588 | 2022-04-02 04:20:47 | Charlottesville, Virginia, US | |
2022-03-01 | US | Wyoming | Teton | 56039 | 9791 | 16 | 0 | 43.93522482 | -110.5890801 | 2022-03-02 04:21:07 | Teton, Wyoming, US | |
2022-01-21 | US | Tennessee | Campbell | 47013 | 9791 | 135 | 0 | 36.40355516 | -84.15108559999999 | 2022-01-22 04:21:13 | Campbell, Tennessee, US | |
2022-01-15 | US | Puerto Rico | Arecibo | 72013 | 9791 | 0 | 0 | 18.406631 | -66.675077 | 2022-01-16 04:21:12 | Arecibo, Puerto Rico, US | |
2021-11-26 | US | Arizona | Santa Cruz | 4023 | 9791 | 196 | 0 | 31.52508998 | -110.8479088 | 2021-11-27 04:22:45 | Santa Cruz, Arizona, US | |
2021-10-31 | Yemen | 9791 | 1889 | 0 | 15.552726999999999 | 48.516388 | 2021-11-01 04:22:01 | Yemen | ||||
2021-10-13 | US | Minnesota | Rice | 27131 | 9791 | 129 | 0 | 44.3543376 | -93.29658715 | 2021-10-14 04:21:29 | Rice, Minnesota, US | |
2021-09-02 | US | Michigan | Lapeer | 26087 | 9791 | 210 | 0 | 43.09052506 | -83.22153148 | 2021-09-03 04:21:20 | Lapeer, Michigan, US | |
2021-09-01 | US | Michigan | Lapeer | 26087 | 9791 | 210 | 0 | 43.09052506 | -83.22153148 | 2021-09-02 04:21:15 | Lapeer, Michigan, US | |
2021-08-30 | US | Massachusetts | Hampshire | 25015 | 9791 | 238 | 0 | 42.33997957 | -72.65898478 | 2021-08-31 04:21:46 | Hampshire, Massachusetts, US | |
2021-08-22 | US | Ohio | Columbiana | 39029 | 9791 | 236 | 0 | 40.76932373 | -80.78094576 | 2021-08-23 04:21:27 | Columbiana, Ohio, US | |
2021-08-17 | US | West Virginia | Monongalia | 54061 | 9791 | 93 | 0 | 39.63218457 | -80.04766838 | 2021-08-18 04:21:35 | Monongalia, West Virginia, US | |
2021-07-29 | Japan | Miyagi | 9791 | 91 | 9438 | 262 | 38.446859 | 140.927086 | 2021-07-30 04:21:34 | Miyagi, Japan | ||
2021-07-28 | US | Connecticut | Tolland | 9013 | 9791 | 187 | 0 | 41.85853803 | -72.3308481 | 2021-07-29 04:21:33 | Tolland, Connecticut, US | |
2021-06-29 | US | Idaho | Twin Falls | 16083 | 9791 | 131 | 0 | 42.35440512 | -114.6685381 | 2021-06-30 04:21:41 | Twin Falls, Idaho, US | |
2021-06-20 | US | Pennsylvania | Mercer | 42085 | 9791 | 261 | 0 | 41.30248872 | -80.25816981 | 2021-06-21 04:21:41 | Mercer, Pennsylvania, US | |
2021-06-06 | US | North Carolina | Wilson | 37195 | 9791 | 179 | 0 | 35.70625477 | -77.917978 | 2021-06-07 04:22:51 | Wilson, North Carolina, US | |
2021-06-05 | US | North Carolina | Wilson | 37195 | 9791 | 179 | 0 | 35.70625477 | -77.917978 | 2021-06-06 04:24:03 | Wilson, North Carolina, US | |
2021-06-04 | US | North Carolina | Wilson | 37195 | 9791 | 179 | 0 | 35.70625477 | -77.917978 | 2021-06-05 04:23:03 | Wilson, North Carolina, US | |
2021-04-21 | Suriname | 9791 | 189 | 8937 | 665 | 3.9193 | -56.0278 | 2021-04-22 04:20:53 | Suriname | |||
2021-04-20 | Bahamas | 9791 | 194 | 9059 | 538 | 25.025885 | -78.035889 | 2021-04-21 04:21:14 | Bahamas | |||
2021-04-19 | Bahamas | 9791 | 194 | 9059 | 538 | 25.025885 | -78.035889 | 2021-04-20 04:20:41 | Bahamas | |||
2021-04-08 | US | Alabama | Limestone | 1083 | 9791 | 146 | 0 | 34.81185586 | -86.98310072 | 2021-04-09 04:21:13 | Limestone, Alabama, US | |
2021-03-07 | US | California | El Dorado | 6017 | 9791 | 97 | 0 | 38.77965956 | -120.5233166 | 2021-03-08 05:24:48 | El Dorado, California, US | |
2021-03-02 | US | Florida | Citrus | 12017 | 9791 | 404 | 0 | 9387 | 28.84804315 | -82.47614748 | 2021-03-03 05:23:28 | Citrus, Florida, US |
2021-02-05 | Peru | Madre de Dios | 9791 | 167 | 0 | 9624 | -11.972699 | -70.53171999999998 | 2021-02-06 05:23:55 | Madre de Dios, Peru | ||
2021-02-04 | Peru | Madre de Dios | 9791 | 167 | 0 | 9624 | -11.972699 | -70.53171999999998 | 2021-02-05 05:22:38 | Madre de Dios, Peru | ||
2021-01-27 | US | Oklahoma | Comanche | 40031 | 9791 | 104 | 0 | 9687 | 34.65973764 | -98.47195055 | 2021-01-28 05:22:24 | Comanche, Oklahoma, US |
2021-01-24 | US | Illinois | LaSalle | 17099 | 9791 | 197 | 0 | 9594 | 41.34426129999999 | -88.88633881 | 2021-01-25 05:22:16 | LaSalle, Illinois, US |
2021-01-20 | Sweden | Vasterbotten | 9791 | 111 | 0 | 9680 | 65.3337 | 16.5162 | 2021-01-21 05:22:01 | Vasterbotten, Sweden | ||
2021-01-05 | US | Texas | Kaufman | 48257 | 9791 | 128 | 0 | 9801 | 32.599141700000004 | -96.28734728 | 2021-01-06 05:22:16 | Kaufman, Texas, US |
2020-12-29 | US | Missouri | Jasper | 29097 | 9791 | 157 | 0 | 9634 | 37.20351921 | -94.34050458 | 2020-12-30 05:22:34 | Jasper, Missouri, US |
2020-12-20 | Belize | 9791 | 213 | 4779 | 4799 | 17.1899 | -88.4976 | 2020-12-21 05:27:58 | Belize | |||
2020-12-19 | Belize | 9791 | 213 | 4779 | 4799 | 17.1899 | -88.4976 | 2020-12-20 05:27:32 | Belize | |||
2020-12-18 | Belize | 9791 | 213 | 4779 | 4799 | 17.1899 | -88.4976 | 2020-12-19 05:27:52 | Belize | |||
2020-12-17 | Belize | 9791 | 213 | 4779 | 4799 | 17.1899 | -88.4976 | 2020-12-18 05:28:18 | Belize | |||
2020-12-13 | US | Florida | Bay | 12005 | 9791 | 184 | 0 | 9607 | 30.26548745 | -85.62122584 | 2020-12-14 05:26:27 | Bay, Florida, US |
2020-11-30 | US | South Carolina | York | 45091 | 9791 | 136 | 0 | 9655 | 34.97281497 | -81.18085944 | 2020-12-01 05:26:18 | York, South Carolina, US |
2020-11-22 | Germany | Sachsen-Anhalt | 9791 | 122 | 6535 | 3375 | 51.9503 | 11.6923 | 2020-11-23 05:25:26 | Sachsen-Anhalt, Germany | ||
2020-10-29 | Sri Lanka | 9791 | 19 | 4142 | 5630 | 7.873054 | 80.77179699999998 | 2020-10-30 04:24:49 | Sri Lanka | |||
2020-10-12 | Ukraine | Volyn Oblast | 9791 | 201 | 5851 | 3739 | 50.7472 | 25.3254 | 2020-10-13 04:24:02 | Volyn Oblast, Ukraine | ||
2020-09-25 | India | Manipur | 9791 | 63 | 7602 | 2126 | 24.738975 | 93.882541 | 2020-09-26 04:23:00 | Manipur, India | ||
2020-09-12 | US | Indiana | Lake | 18089 | 9791 | 332 | 0 | 9459 | 41.41874274 | -87.38277575 | 2020-09-13 04:30:52 | Lake, Indiana, US |
2020-08-16 | Paraguay | 9791 | 138 | 6034 | 3619 | -23.4425 | -58.4438 | 2020-08-17 04:27:20 | Paraguay | |||
2020-07-28 | Russia | Murmansk Oblast | 9791 | 68 | 5477 | 4246 | 68.00004179999999 | 33.9999151 | 2020-07-29 04:35:11 | Murmansk Oblast, Russia | ||
2020-07-21 | US | New Jersey | Monmouth | 34025 | 9791 | 851 | 0 | 8940 | 40.26549699 | -74.22240686 | 2020-07-22 04:34:42 | Monmouth, New Jersey, US |
2020-05-06 | Serbia | 9791 | 203 | 1971 | 7617 | 44.0165 | 21.0059 | 2020-05-07 02:32:28 | Serbia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;