daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
90 rows where confirmed = 7576 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 8
- US 56
- Colombia 28
- Barbados 1
- Guinea-Bissau 1
- India 1
- Netherlands 1
- Russia 1
- Zimbabwe 1
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-11-09 | US | Puerto Rico | Aibonito | 72009 | 7576 | 0 | 0 | 18.131361 | -66.264131 | 2022-11-10 04:21:16 | Aibonito, Puerto Rico, US | |
2022-10-13 | US | Arkansas | Cleburne | 5023 | 7576 | 139 | 0 | 35.53864922 | -92.02640019 | 2022-10-14 04:22:28 | Cleburne, Arkansas, US | |
2022-08-31 | US | Tennessee | Grainger | 47057 | 7576 | 113 | 0 | 36.27469206 | -83.51254721 | 2022-09-01 04:21:03 | Grainger, Tennessee, US | |
2022-08-08 | US | Virginia | Russell | 51167 | 7576 | 118 | 0 | 36.9302832 | -82.10095486 | 2022-08-09 04:20:34 | Russell, Virginia, US | |
2022-07-22 | US | Texas | Hopkins | 48223 | 7576 | 182 | 0 | 33.14875072 | -95.56351139 | 2022-07-23 04:20:53 | Hopkins, Texas, US | |
2022-07-07 | US | Texas | Cooke | 48097 | 7576 | 134 | 0 | 33.63979567 | -97.21240912 | 2022-07-08 04:20:56 | Cooke, Texas, US | |
2022-06-15 | Colombia | Amazonas | 7576 | 265 | 0 | -1.4429 | -71.5724 | 2022-06-16 04:20:55 | Amazonas, Colombia | |||
2022-06-14 | Colombia | Amazonas | 7576 | 265 | 0 | -1.4429 | -71.5724 | 2022-06-15 04:20:54 | Amazonas, Colombia | |||
2022-06-13 | Colombia | Amazonas | 7576 | 265 | 0 | -1.4429 | -71.5724 | 2022-06-14 04:20:52 | Amazonas, Colombia | |||
2022-06-12 | Colombia | Amazonas | 7576 | 265 | 0 | -1.4429 | -71.5724 | 2022-06-13 04:21:14 | Amazonas, Colombia | |||
2022-06-11 | Colombia | Amazonas | 7576 | 265 | 0 | -1.4429 | -71.5724 | 2022-06-12 04:20:53 | Amazonas, Colombia | |||
2022-06-10 | Colombia | Amazonas | 7576 | 265 | 0 | -1.4429 | -71.5724 | 2022-06-11 04:21:01 | Amazonas, Colombia | |||
2022-06-09 | Colombia | Amazonas | 7576 | 265 | 0 | -1.4429 | -71.5724 | 2022-06-10 04:20:55 | Amazonas, Colombia | |||
2022-06-08 | Colombia | Amazonas | 7576 | 265 | 0 | -1.4429 | -71.5724 | 2022-06-09 04:20:54 | Amazonas, Colombia | |||
2022-06-07 | Colombia | Amazonas | 7576 | 265 | 0 | -1.4429 | -71.5724 | 2022-06-08 04:20:55 | Amazonas, Colombia | |||
2022-06-06 | Colombia | Amazonas | 7576 | 265 | 0 | -1.4429 | -71.5724 | 2022-06-07 04:21:08 | Amazonas, Colombia | |||
2022-06-05 | Colombia | Amazonas | 7576 | 265 | 0 | -1.4429 | -71.5724 | 2022-06-06 04:20:57 | Amazonas, Colombia | |||
2022-06-04 | Colombia | Amazonas | 7576 | 265 | 0 | -1.4429 | -71.5724 | 2022-06-05 04:20:55 | Amazonas, Colombia | |||
2022-06-03 | Colombia | Amazonas | 7576 | 265 | 0 | -1.4429 | -71.5724 | 2022-06-04 04:20:58 | Amazonas, Colombia | |||
2022-06-02 | Colombia | Amazonas | 7576 | 265 | 0 | -1.4429 | -71.5724 | 2022-06-03 04:20:58 | Amazonas, Colombia | |||
2022-06-01 | Colombia | Amazonas | 7576 | 265 | 0 | -1.4429 | -71.5724 | 2022-06-02 05:20:39 | Amazonas, Colombia | |||
2022-05-31 | Colombia | Amazonas | 7576 | 265 | 0 | -1.4429 | -71.5724 | 2022-06-01 04:20:55 | Amazonas, Colombia | |||
2022-05-30 | Colombia | Amazonas | 7576 | 265 | 0 | -1.4429 | -71.5724 | 2022-05-31 04:20:51 | Amazonas, Colombia | |||
2022-05-29 | Colombia | Amazonas | 7576 | 265 | 0 | -1.4429 | -71.5724 | 2022-05-30 04:20:50 | Amazonas, Colombia | |||
2022-05-28 | Colombia | Amazonas | 7576 | 265 | 0 | -1.4429 | -71.5724 | 2022-05-29 04:20:53 | Amazonas, Colombia | |||
2022-05-27 | Colombia | Amazonas | 7576 | 265 | 0 | -1.4429 | -71.5724 | 2022-05-28 04:21:07 | Amazonas, Colombia | |||
2022-05-26 | Colombia | Amazonas | 7576 | 265 | 0 | -1.4429 | -71.5724 | 2022-05-27 04:20:56 | Amazonas, Colombia | |||
2022-05-25 | Colombia | Amazonas | 7576 | 265 | 0 | -1.4429 | -71.5724 | 2022-05-26 04:20:50 | Amazonas, Colombia | |||
2022-05-24 | Colombia | Amazonas | 7576 | 265 | 0 | -1.4429 | -71.5724 | 2022-05-25 04:20:56 | Amazonas, Colombia | |||
2022-05-23 | Colombia | Amazonas | 7576 | 265 | 0 | -1.4429 | -71.5724 | 2022-05-24 04:20:57 | Amazonas, Colombia | |||
2022-05-22 | Colombia | Amazonas | 7576 | 265 | 0 | -1.4429 | -71.5724 | 2022-05-26 04:20:50 | Amazonas, Colombia | |||
2022-05-21 | Colombia | Amazonas | 7576 | 265 | 0 | -1.4429 | -71.5724 | 2022-05-22 04:20:52 | Amazonas, Colombia | |||
2022-05-20 | Colombia | Amazonas | 7576 | 265 | 0 | -1.4429 | -71.5724 | 2022-05-21 04:20:58 | Amazonas, Colombia | |||
2022-05-19 | Colombia | Amazonas | 7576 | 265 | 0 | -1.4429 | -71.5724 | 2022-05-20 04:20:57 | Amazonas, Colombia | |||
2022-05-16 | US | Alabama | Winston | 1133 | 7576 | 131 | 0 | 34.15030532 | -87.37325922 | 2022-05-17 04:20:59 | Winston, Alabama, US | |
2022-05-15 | US | Alabama | Winston | 1133 | 7576 | 131 | 0 | 34.15030532 | -87.37325922 | 2022-05-16 04:20:47 | Winston, Alabama, US | |
2022-05-14 | US | Alabama | Winston | 1133 | 7576 | 131 | 0 | 34.15030532 | -87.37325922 | 2022-05-15 04:20:53 | Winston, Alabama, US | |
2022-05-13 | US | Alabama | Winston | 1133 | 7576 | 131 | 0 | 34.15030532 | -87.37325922 | 2022-05-14 04:20:48 | Winston, Alabama, US | |
2022-05-01 | US | Alabama | Pike | 1109 | 7576 | 134 | 0 | 31.80396383 | -85.9408295 | 2022-05-02 04:21:10 | Pike, Alabama, US | |
2022-04-30 | US | Alabama | Pike | 1109 | 7576 | 134 | 0 | 31.80396383 | -85.9408295 | 2022-05-01 04:20:57 | Pike, Alabama, US | |
2022-04-29 | US | Alabama | Pike | 1109 | 7576 | 134 | 0 | 31.80396383 | -85.9408295 | 2022-04-30 04:21:05 | Pike, Alabama, US | |
2022-04-17 | US | Kentucky | Montgomery | 21173 | 7576 | 100 | 0 | 38.03253032 | -83.9145241 | 2022-04-18 04:21:12 | Montgomery, Kentucky, US | |
2022-04-16 | US | Kentucky | Montgomery | 21173 | 7576 | 100 | 0 | 38.03253032 | -83.9145241 | 2022-04-17 04:20:59 | Montgomery, Kentucky, US | |
2022-04-15 | US | Kentucky | Montgomery | 21173 | 7576 | 100 | 0 | 38.03253032 | -83.9145241 | 2022-04-16 04:20:48 | Montgomery, Kentucky, US | |
2022-04-14 | US | Kentucky | Montgomery | 21173 | 7576 | 100 | 0 | 38.03253032 | -83.9145241 | 2022-04-15 04:20:57 | Montgomery, Kentucky, US | |
2022-04-13 | US | Kentucky | Montgomery | 21173 | 7576 | 100 | 0 | 38.03253032 | -83.9145241 | 2022-04-13 23:21:06 | Montgomery, Kentucky, US | |
2022-04-12 | US | Kentucky | Montgomery | 21173 | 7576 | 100 | 0 | 38.03253032 | -83.9145241 | 2022-04-13 04:21:03 | Montgomery, Kentucky, US | |
2022-04-11 | US | Kentucky | Montgomery | 21173 | 7576 | 100 | 0 | 38.03253032 | -83.9145241 | 2022-04-12 04:20:49 | Montgomery, Kentucky, US | |
2022-03-06 | US | New York | Delaware | 36025 | 7576 | 68 | 0 | 42.19837623 | -74.96709306 | 2022-03-07 04:20:47 | Delaware, New York, US | |
2022-03-02 | US | Alabama | Lawrence | 1079 | 7576 | 151 | 0 | 34.52041498 | -87.31069453 | 2022-03-03 04:21:01 | Lawrence, Alabama, US | |
2022-02-16 | US | Georgia | Wayne | 13305 | 7576 | 194 | 0 | 31.5521809 | -81.91894878 | 2022-02-17 04:20:56 | Wayne, Georgia, US | |
2022-02-06 | US | Arkansas | Poinsett | 5111 | 7576 | 109 | 0 | 35.57433534 | -90.66268713 | 2022-02-07 04:21:05 | Poinsett, Arkansas, US | |
2022-01-29 | US | Texas | Cherokee | 48073 | 7576 | 233 | 0 | 31.837258000000002 | -95.16559897 | 2022-01-30 04:21:26 | Cherokee, Texas, US | |
2022-01-29 | Guinea-Bissau | 7576 | 154 | 0 | 11.8037 | -15.1804 | 2022-01-30 04:21:26 | Guinea-Bissau | ||||
2021-12-29 | US | Louisiana | Lincoln | 22061 | 7576 | 119 | 0 | 32.6003154 | -92.66597409999999 | 2021-12-30 04:21:25 | Lincoln, Louisiana, US | |
2021-12-23 | US | Virginia | Culpeper | 51047 | 7576 | 94 | 0 | 38.48199985 | -77.95630870000002 | 2021-12-24 04:21:34 | Culpeper, Virginia, US | |
2021-12-02 | US | Virginia | Fauquier | 51061 | 7576 | 88 | 0 | 38.73564842 | -77.80647472 | 2021-12-03 04:23:05 | Fauquier, Virginia, US | |
2021-11-23 | US | Pennsylvania | Bedford | 42009 | 7576 | 189 | 0 | 40.00522157 | -78.48998442 | 2021-11-24 04:22:14 | Bedford, Pennsylvania, US | |
2021-11-14 | US | Wisconsin | Polk | 55095 | 7576 | 89 | 0 | 45.46130348 | -92.44182875 | 2021-11-15 04:21:36 | Polk, Wisconsin, US | |
2021-11-13 | US | Wisconsin | Polk | 55095 | 7576 | 89 | 0 | 45.46130348 | -92.44182875 | 2021-11-14 04:21:31 | Polk, Wisconsin, US | |
2021-11-12 | US | Wisconsin | Polk | 55095 | 7576 | 89 | 0 | 45.46130348 | -92.44182875 | 2021-11-13 04:21:38 | Polk, Wisconsin, US | |
2021-09-26 | Barbados | 7576 | 67 | 0 | 13.1939 | -59.5432 | 2021-09-27 04:21:16 | Barbados | ||||
2021-09-14 | US | Louisiana | Washington | 22117 | 7576 | 186 | 0 | 30.85288548 | -90.03866652 | 2021-09-15 03:22:37 | Washington, Louisiana, US | |
2021-09-08 | India | Andaman and Nicobar Islands | 7576 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-09-09 04:21:27 | Andaman and Nicobar Islands, India | |||
2021-08-09 | US | New York | Ontario | 36069 | 7576 | 93 | 0 | 42.85145728 | -77.30874425 | 2021-08-10 04:21:27 | Ontario, New York, US | |
2021-07-25 | US | Arkansas | Crawford | 5033 | 7576 | 124 | 0 | 35.58928601 | -94.2446814 | 2021-07-26 04:21:28 | Crawford, Arkansas, US | |
2021-06-30 | US | Kentucky | Laurel | 21125 | 7576 | 81 | 0 | 37.10975748 | -84.11321779 | 2021-07-01 04:21:19 | Laurel, Kentucky, US | |
2021-06-18 | US | Texas | Wise | 48497 | 7576 | 124 | 0 | 33.21570665 | -97.65460265 | 2021-06-19 04:22:33 | Wise, Texas, US | |
2021-05-30 | US | Georgia | Troup | 13285 | 7576 | 231 | 0 | 33.03349196 | -85.02812115 | 2021-05-31 03:08:59 | Troup, Georgia, US | |
2021-05-29 | US | Georgia | Troup | 13285 | 7576 | 231 | 0 | 33.03349196 | -85.02812115 | 2021-05-30 04:20:55 | Troup, Georgia, US | |
2021-04-30 | US | Washington | Kitsap | 53035 | 7576 | 105 | 0 | 47.63479026 | -122.6436061 | 2021-05-01 04:20:47 | Kitsap, Washington, US | |
2021-04-16 | US | Virginia | Frederick | 51069 | 7576 | 95 | 0 | 39.20172582 | -78.25974949 | 2021-04-17 04:20:40 | Frederick, Virginia, US | |
2021-03-28 | US | Indiana | Warrick | 18173 | 7576 | 155 | 0 | 38.08922676 | -87.2716085 | 2021-03-29 04:28:35 | Warrick, Indiana, US | |
2021-03-16 | US | Indiana | Bartholomew | 18005 | 7576 | 149 | 0 | 39.20744865 | -85.89558181 | 2021-03-17 05:25:07 | Bartholomew, Indiana, US | |
2021-02-25 | US | Missouri | St. Francois | 29187 | 7576 | 104 | 0 | 7472 | 37.81214171 | -90.47598685 | 2021-02-26 05:22:40 | St. Francois, Missouri, US |
2021-02-21 | US | Kentucky | Campbell | 21037 | 7576 | 46 | 0 | 7530 | 38.94384345 | -84.37875208 | 2021-02-22 05:24:21 | Campbell, Kentucky, US |
2021-02-13 | US | Florida | Sumter | 12119 | 7576 | 215 | 0 | 7361 | 28.70181754 | -82.0794267 | 2021-02-14 05:23:43 | Sumter, Florida, US |
2021-02-06 | US | Virginia | Spotsylvania | 51177 | 7576 | 87 | 0 | 7489 | 38.18574462 | -77.655399 | 2021-02-07 05:23:00 | Spotsylvania, Virginia, US |
2021-02-04 | US | Missouri | Clay | 29047 | 7576 | 131 | 0 | 7445 | 39.31132056 | -94.41850862 | 2021-02-05 05:22:38 | Clay, Missouri, US |
2021-02-01 | US | South Carolina | Orangeburg | 45075 | 7576 | 187 | 0 | 7389 | 33.4391073 | -80.79886287 | 2021-02-02 05:22:49 | Orangeburg, South Carolina, US |
2021-01-02 | US | Maine | Cumberland | 23005 | 7576 | 104 | 0 | 7472 | 43.8370751 | -70.37226999 | 2021-01-03 05:22:52 | Cumberland, Maine, US |
2020-12-22 | US | Indiana | Clark | 18019 | 7576 | 114 | 0 | 7462 | 38.48015445 | -85.70510334 | 2020-12-23 05:22:03 | Clark, Indiana, US |
2020-12-13 | Netherlands | Zeeland | 7576 | 106 | 0 | 7473 | 51.47936 | 3.861559 | 2020-12-14 05:26:27 | Zeeland, Netherlands | ||
2020-12-12 | US | Ohio | Greene | 39057 | 7576 | 127 | 0 | 7449 | 39.69116283 | -83.89032084 | 2020-12-13 05:27:20 | Greene, Ohio, US |
2020-12-04 | US | Georgia | Muscogee | 13215 | 7576 | 196 | 0 | 7380 | 32.50931999 | -84.87142262 | 2020-12-05 05:27:36 | Muscogee, Georgia, US |
2020-11-30 | Russia | Mari El Republic | 7576 | 92 | 6558 | 926 | 56.5767504 | 47.8817512 | 2020-12-01 05:26:18 | Mari El Republic, Russia | ||
2020-10-19 | US | Virginia | Loudoun | 51107 | 7576 | 129 | 0 | 7447 | 39.08990083 | -77.63481877 | 2020-10-20 04:24:22 | Loudoun, Virginia, US |
2020-10-05 | US | Oregon | Multnomah | 41051 | 7576 | 144 | 0 | 7432 | 45.54747959 | -122.4169351 | 2020-10-06 04:23:33 | Multnomah, Oregon, US |
2020-09-15 | Zimbabwe | 7576 | 224 | 5783 | 1569 | -19.015438 | 29.154857 | 2020-09-16 04:22:53 | Zimbabwe | |||
2020-07-07 | US | New Jersey | Camden | 34007 | 7576 | 534 | 0 | 7042 | 39.80343818 | -74.96388753 | 2020-07-08 05:33:48 | Camden, New Jersey, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;