johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
83 rows where active = 2205 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
578670 | 578670 | 2021-07-13 | Colombia | Caldas | 94649 | 2012 | 90432 | 2205 | 5.2983 | -75.2479 | 2021-07-14 04:21:35 | Caldas, Colombia | ||
778106 | 778106 | 2021-07-08 | Brazil | Piaui | 301198 | 6684 | 291428 | 2205 | -7.7183 | -42.7289 | 2021-07-09 04:21:21 | Piaui, Brazil | ||
2071778 | 2071778 | 2021-07-02 | Colombia | Tolima | 91465 | 2955 | 86305 | 2205 | 4.0925 | -75.1545 | 2021-07-03 04:21:37 | Tolima, Colombia | ||
3358815 | 3358815 | 2021-06-21 | Pakistan | Khyber Pakhtunkhwa | 137147 | 4274 | 130668 | 2205 | 34.485332 | 72.09169 | 2021-06-22 04:21:34 | Khyber Pakhtunkhwa, Pakistan | ||
2716754 | 2716754 | 2021-06-10 | Chile | Araucania | 86527 | 1123 | 83199 | 2205 | -38.9489 | -72.3311 | 2021-06-11 04:23:20 | Araucania, Chile | ||
1448801 | 1448801 | 2021-06-03 | Russia | Kostroma Oblast | 21625 | 483 | 18937 | 2205 | 58.424756 | 44.2533273 | 2021-06-04 04:23:37 | Kostroma Oblast, Russia | ||
1290249 | 1290249 | 2021-03-29 | Russia | Samara Oblast | 55336 | 1078 | 52053 | 2205 | 53.2128813 | 50.8914633 | 2021-03-30 04:26:23 | Samara Oblast, Russia | ||
2055814 | 2055814 | 2021-03-15 | Haiti | 12700 | 251 | 10177 | 2205 | 18.9712 | -72.2852 | 2021-03-16 05:25:13 | Haiti | |||
998353 | 998353 | 2021-03-01 | Germany | Mecklenburg-Vorpommern | 24554 | 739 | 21663 | 2205 | 53.6127 | 12.4296 | 2021-03-02 05:23:30 | Mecklenburg-Vorpommern, Germany | ||
2187163 | 2187163 | 2021-02-26 | US | Wisconsin | Vilas | 55125 | 2243 | 38 | 0 | 2205 | 46.05467334 | -89.51719204 | 2021-02-27 05:22:28 | Vilas, Wisconsin, US |
534372 | 534372 | 2021-02-22 | Zimbabwe | 35862 | 1441 | 32216 | 2205 | -19.015438 | 29.154857 | 2021-02-23 05:23:41 | Zimbabwe | |||
532439 | 532439 | 2021-02-22 | US | Minnesota | Mille Lacs | 27095 | 2252 | 47 | 0 | 2205 | 45.93705297 | -93.63236823 | 2021-02-23 05:23:41 | Mille Lacs, Minnesota, US |
185719 | 185719 | 2021-02-21 | Malaysia | Perak | 9318 | 39 | 7074 | 2205 | 4.5921 | 101.0901 | 2021-02-22 05:24:21 | Perak, Malaysia | ||
184288 | 184288 | 2021-02-21 | US | New York | Otsego | 36077 | 2247 | 42 | 0 | 2205 | 42.63492579 | -75.03151402 | 2021-02-22 05:24:21 | Otsego, New York, US |
743214 | 743214 | 2021-02-20 | US | Hawaii | Hawaii | 15001 | 2258 | 53 | 0 | 2205 | 19.60121157 | -155.5210167 | 2021-02-21 05:24:33 | Hawaii, Hawaii, US |
1154654 | 1154654 | 2021-02-18 | US | Louisiana | Union | 22111 | 2280 | 75 | 0 | 2205 | 32.83121059 | -92.3749373 | 2021-02-19 05:24:16 | Union, Louisiana, US |
3604483 | 3604483 | 2021-02-17 | US | Washington | Mason | 53045 | 2227 | 22 | 0 | 2205 | 47.35007586 | -123.1863685 | 2021-02-18 05:22:58 | Mason, Washington, US |
3980795 | 3980795 | 2021-02-10 | US | New York | Chenango | 36017 | 2266 | 61 | 0 | 2205 | 42.49430041 | -75.60887553 | 2021-02-11 05:23:55 | Chenango, New York, US |
341677 | 341677 | 2021-02-03 | US | Kentucky | Harlan | 21095 | 2260 | 55 | 0 | 2205 | 36.85699301 | -83.21899516 | 2021-02-04 05:22:26 | Harlan, Kentucky, US |
1679972 | 1679972 | 2021-02-01 | US | West Virginia | Randolph | 54083 | 2214 | 9 | 0 | 2205 | 38.769899 | -79.87919615 | 2021-02-02 05:22:49 | Randolph, West Virginia, US |
2484437 | 2484437 | 2021-01-28 | US | Ohio | Holmes | 39075 | 2296 | 91 | 0 | 2205 | 40.56163713 | -81.92635677 | 2021-01-29 05:22:23 | Holmes, Ohio, US |
1762806 | 1762806 | 2021-01-24 | US | West Virginia | Wayne | 54099 | 2231 | 26 | 0 | 2205 | 38.14901357 | -82.42287994 | 2021-01-25 05:22:16 | Wayne, West Virginia, US |
2428826 | 2428826 | 2021-01-23 | US | Missouri | Miller | 29131 | 2250 | 45 | 0 | 2205 | 38.21450288 | -92.42610898 | 2021-01-24 05:22:35 | Miller, Missouri, US |
438383 | 438383 | 2021-01-21 | US | Texas | Burnet | 48053 | 2757 | 36 | 0 | 2205 | 30.78801353 | -98.181887 | 2021-01-22 05:22:10 | Burnet, Texas, US |
3104420 | 3104420 | 2021-01-16 | US | Tennessee | Scott | 47151 | 2528 | 31 | 0 | 2205 | 36.42325673 | -84.50360494 | 2021-01-17 05:22:17 | Scott, Tennessee, US |
3103389 | 3103389 | 2021-01-16 | US | Missouri | Saline | 29195 | 2231 | 26 | 0 | 2205 | 39.13734288 | -93.20259964 | 2021-01-17 05:22:17 | Saline, Missouri, US |
3101233 | 3101233 | 2021-01-16 | Chile | Maule | 30447 | 627 | 27615 | 2205 | -35.5183 | -71.6885 | 2021-01-17 05:22:17 | Maule, Chile | ||
2628854 | 2628854 | 2021-01-10 | US | Tennessee | Smith | 47159 | 2259 | 24 | 0 | 2205 | 36.25359775 | -85.95411046 | 2021-01-11 05:21:50 | Smith, Tennessee, US |
2542054 | 2542054 | 2021-01-07 | US | Colorado | Summit | 8117 | 2302 | 5 | 0 | 2205 | 39.63803232 | -106.1150762 | 2021-01-08 05:22:42 | Summit, Colorado, US |
3035692 | 3035692 | 2021-01-05 | US | Kentucky | Franklin | 21073 | 2226 | 21 | 0 | 2205 | 38.2379395 | -84.87962551 | 2021-01-06 05:22:16 | Franklin, Kentucky, US |
1137645 | 1137645 | 2021-01-01 | US | Georgia | Chattahoochee | 13053 | 2208 | 3 | 0 | 2205 | 32.34341231 | -84.78809239 | 2021-01-02 05:22:33 | Chattahoochee, Georgia, US |
3781380 | 3781380 | 2020-12-27 | US | West Virginia | Jefferson | 54037 | 2230 | 25 | 0 | 2205 | 39.30776166 | -77.86014147 | 2020-12-28 05:22:06 | Jefferson, West Virginia, US |
3779804 | 3779804 | 2020-12-27 | US | Missouri | Howell | 29091 | 2241 | 36 | 0 | 2205 | 36.77383887 | -91.88683935 | 2020-12-28 05:22:06 | Howell, Missouri, US |
3778426 | 3778426 | 2020-12-27 | US | Arkansas | Union | 5139 | 2278 | 73 | 0 | 2205 | 33.16887091 | -92.59746952 | 2020-12-28 05:22:06 | Union, Arkansas, US |
205694 | 205694 | 2020-12-25 | US | Washington | Lewis | 53041 | 2229 | 24 | 0 | 2205 | 46.57756476 | -122.3925769 | 2020-12-26 05:22:28 | Lewis, Washington, US |
3694917 | 3694917 | 2020-12-24 | US | Washington | Lewis | 53041 | 2229 | 24 | 0 | 2205 | 46.57756476 | -122.3925769 | 2020-12-25 05:22:48 | Lewis, Washington, US |
2408671 | 2408671 | 2020-12-23 | US | Mississippi | Tate | 28137 | 2261 | 56 | 0 | 2205 | 34.65133709 | -89.94485778 | 2020-12-24 05:23:04 | Tate, Mississippi, US |
2122365 | 2122365 | 2020-12-20 | US | Pennsylvania | Columbia | 42037 | 2262 | 57 | 0 | 2205 | 41.04821986 | -76.40565017 | 2020-12-21 05:27:58 | Columbia, Pennsylvania, US |
2121341 | 2121341 | 2020-12-20 | US | Michigan | Hillsdale | 26059 | 2255 | 50 | 0 | 2205 | 41.88753639 | -84.59312019 | 2020-12-21 05:27:58 | Hillsdale, Michigan, US |
2933161 | 2933161 | 2020-12-19 | US | Missouri | Pulaski | 29169 | 2231 | 26 | 0 | 2205 | 37.82462075 | -92.20783203 | 2020-12-20 05:27:32 | Pulaski, Missouri, US |
2932848 | 2932848 | 2020-12-19 | US | Michigan | Hillsdale | 26059 | 2255 | 50 | 0 | 2205 | 41.88753639 | -84.59312019 | 2020-12-20 05:27:32 | Hillsdale, Michigan, US |
1902296 | 1902296 | 2020-12-18 | US | Indiana | Steuben | 18151 | 2223 | 18 | 0 | 2205 | 41.64423868 | -85.00101094 | 2020-12-19 05:27:52 | Steuben, Indiana, US |
1035780 | 1035780 | 2020-12-15 | US | Kentucky | Hopkins | 21107 | 2265 | 60 | 0 | 2205 | 37.30939025 | -87.54670406 | 2020-12-16 05:28:04 | Hopkins, Kentucky, US |
1754810 | 1754810 | 2020-12-14 | US | Wisconsin | Juneau | 55057 | 2213 | 8 | 0 | 2205 | 43.92456975 | -90.11120239 | 2020-12-15 05:26:38 | Juneau, Wisconsin, US |
1751492 | 1751492 | 2020-12-14 | Russia | Murmansk Oblast | 31421 | 553 | 28663 | 2205 | 68.00004179999999 | 33.9999151 | 2020-12-15 05:26:38 | Murmansk Oblast, Russia | ||
1602586 | 1602586 | 2020-12-10 | US | North Carolina | Watauga | 37189 | 2213 | 8 | 0 | 2205 | 36.23103603 | -81.70033724 | 2020-12-11 05:26:59 | Watauga, North Carolina, US |
1602271 | 1602271 | 2020-12-10 | US | Nebraska | Dawson | 31047 | 2226 | 21 | 0 | 2205 | 40.87028216 | -99.8201461 | 2020-12-11 05:26:59 | Dawson, Nebraska, US |
1007389 | 1007389 | 2020-12-06 | US | Indiana | Knox | 18083 | 2254 | 49 | 0 | 2205 | 38.68861576 | -87.4194665 | 2020-12-07 05:26:14 | Knox, Indiana, US |
2538413 | 2538413 | 2020-12-01 | US | Illinois | Morgan | 17137 | 2243 | 38 | 0 | 2205 | 39.71654544 | -90.20255104 | 2020-12-02 05:27:41 | Morgan, Illinois, US |
3192278 | 3192278 | 2020-11-22 | US | North Carolina | Chatham | 37037 | 2270 | 65 | 0 | 2205 | 35.70394416 | -79.25541492 | 2020-11-23 05:25:26 | Chatham, North Carolina, US |
3190850 | 3190850 | 2020-11-22 | US | Georgia | Spalding | 13255 | 2281 | 76 | 0 | 2205 | 33.26310031 | -84.28013991 | 2020-11-23 05:25:26 | Spalding, Georgia, US |
2703127 | 2703127 | 2020-11-20 | US | Michigan | Delta | 26041 | 2261 | 56 | 0 | 2205 | 45.90484910000001 | -86.9080745 | 2020-11-21 05:25:51 | Delta, Michigan, US |
822421 | 822421 | 2020-11-19 | US | Georgia | Polk | 13233 | 2238 | 33 | 0 | 2205 | 34.00267074 | -85.18677781 | 2020-11-20 05:26:28 | Polk, Georgia, US |
124952 | 124952 | 2020-11-18 | US | New York | Putnam | 36079 | 2269 | 64 | 0 | 2205 | 41.42630093 | -73.74965532 | 2020-11-19 05:25:23 | Putnam, New York, US |
2787092 | 2787092 | 2020-11-13 | US | Nebraska | Madison | 31119 | 2219 | 14 | 0 | 2205 | 41.91676024 | -97.6005481 | 2020-11-14 05:25:37 | Madison, Nebraska, US |
2919293 | 2919293 | 2020-11-04 | Mozambique | 13283 | 95 | 10983 | 2205 | -18.665695 | 35.529562 | 2020-11-05 06:05:03 | Mozambique | |||
3306065 | 3306065 | 2020-11-02 | US | Missouri | Cass | 29037 | 2237 | 32 | 0 | 2205 | 38.64789422 | -94.353399 | 2020-11-03 06:00:16 | Cass, Missouri, US |
2244479 | 2244479 | 2020-10-30 | US | Indiana | Kosciusko | 18085 | 2235 | 30 | 0 | 2205 | 41.24521668 | -85.86312322 | 2020-10-31 04:24:44 | Kosciusko, Indiana, US |
2243798 | 2243798 | 2020-10-30 | US | Alaska | Fairbanks North Star | 2090 | 2220 | 15 | 0 | 2205 | 64.80726247 | -146.5692662 | 2020-10-31 04:24:44 | Fairbanks North Star, Alaska, US |
3480829 | 3480829 | 2020-10-26 | US | Arkansas | Unassigned | 90005 | 2205 | 0 | 0 | 2205 | 36.38177105 | 0.0 | 2020-10-27 04:24:45 | Unassigned, Arkansas, US |
11732 | 11732 | 2020-10-25 | US | Virginia | Suffolk | 51800 | 2283 | 78 | 0 | 2205 | 36.70155394 | -76.63603554 | 2020-10-26 04:25:02 | Suffolk, Virginia, US |
11253 | 11253 | 2020-10-25 | US | Tennessee | Dyer | 47045 | 2257 | 32 | 0 | 2205 | 36.05931946 | -89.41542855 | 2020-10-26 04:25:02 | Dyer, Tennessee, US |
1054919 | 1054919 | 2020-10-23 | US | Indiana | LaPorte | 18091 | 2266 | 61 | 0 | 2205 | 41.54366008 | -86.74072188 | 2020-10-24 04:24:46 | LaPorte, Indiana, US |
3991098 | 3991098 | 2020-10-20 | US | Arkansas | Lincoln | 5079 | 2222 | 17 | 0 | 2205 | 33.95317155 | -91.74002806 | 2020-10-21 04:24:14 | Lincoln, Arkansas, US |
1027161 | 1027161 | 2020-10-17 | US | Georgia | Jackson | 13157 | 2245 | 40 | 0 | 2205 | 34.13794553 | -83.56814788 | 2020-10-18 04:24:25 | Jackson, Georgia, US |
3120295 | 3120295 | 2020-10-06 | US | South Carolina | Lancaster | 45057 | 2258 | 53 | 0 | 2205 | 34.68270843 | -80.70513032 | 2020-10-07 04:23:40 | Lancaster, South Carolina, US |
2382714 | 2382714 | 2020-10-01 | US | Texas | Gregg | 48183 | 1593 | 72 | 0 | 2205 | 32.47940482 | -94.81591935 | 2020-10-02 04:23:51 | Gregg, Texas, US |
1518532 | 1518532 | 2020-09-28 | US | Texas | Liberty | 48291 | 2395 | 51 | 0 | 2205 | 30.15152688 | -94.81205615 | 2020-09-29 04:23:42 | Liberty, Texas, US |
2585120 | 2585120 | 2020-09-27 | US | Texas | Liberty | 48291 | 2385 | 51 | 0 | 2205 | 30.15152688 | -94.81205615 | 2020-09-28 04:23:00 | Liberty, Texas, US |
2582187 | 2582187 | 2020-09-27 | Russia | Khabarovsk Krai | 11878 | 102 | 9571 | 2205 | 51.6312684 | 136.121524 | 2020-09-28 04:23:00 | Khabarovsk Krai, Russia | ||
2816380 | 2816380 | 2020-09-25 | Ukraine | Zaporizhia Oblast | 3428 | 55 | 1168 | 2205 | 47.8388 | 35.1396 | 2020-09-26 04:23:00 | Zaporizhia Oblast, Ukraine | ||
2656237 | 2656237 | 2020-09-23 | US | Ohio | Lorain | 39093 | 2293 | 88 | 0 | 2205 | 41.29553751 | -82.15083537 | 2020-09-24 04:23:00 | Lorain, Ohio, US |
2457550 | 2457550 | 2020-09-19 | US | Rhode Island | Unassigned | 90044 | 2246 | 41 | 0 | 2205 | 41.87064746 | 0.0 | 2020-09-20 04:22:00 | Unassigned, Rhode Island, US |
2851619 | 2851619 | 2020-09-18 | US | Rhode Island | Unassigned | 90044 | 2246 | 41 | 0 | 2205 | 41.87064746 | 0.0 | 2020-09-19 04:22:00 | Unassigned, Rhode Island, US |
3161979 | 3161979 | 2020-09-06 | US | Alabama | DeKalb | 1049 | 2221 | 16 | 0 | 2205 | 34.45946862 | -85.80782906 | 2020-09-07 04:28:30 | DeKalb, Alabama, US |
1108735 | 1108735 | 2020-09-02 | US | Texas | Randall | 48381 | 1846 | 31 | 0 | 2205 | 34.96585996 | -101.8971322 | 2020-09-03 04:28:22 | Randall, Texas, US |
3934354 | 3934354 | 2020-08-30 | US | North Carolina | Orange | 37135 | 2255 | 50 | 0 | 2205 | 36.06092947 | -79.12167935 | 2020-08-31 04:28:27 | Orange, North Carolina, US |
206222 | 206222 | 2020-08-19 | India | Tripura | 7835 | 65 | 5565 | 2205 | 23.746783 | 91.743565 | 2020-08-20 04:27:43 | Tripura, India | ||
841851 | 841851 | 2020-07-22 | US | Florida | Clay | 12019 | 2249 | 44 | 0 | 2205 | 29.98319144 | -81.85609986 | 2020-07-23 05:15:04 | Clay, Florida, US |
3436356 | 3436356 | 2020-07-11 | Greece | 3772 | 193 | 1374 | 2205 | 39.0742 | 21.8243 | 2020-07-12 04:34:30 | Greece | |||
1691090 | 1691090 | 2020-06-19 | US | Arkansas | Washington | 5143 | 2222 | 17 | 0 | 2205 | 35.976844 | -94.21800746 | 2020-06-20 04:33:19 | Washington, Arkansas, US |
2384973 | 2384973 | 2020-06-16 | US | Ohio | Lucas | 39095 | 2460 | 255 | 0 | 2205 | 41.62101218 | -83.65468618 | 2020-06-17 04:33:21 | Lucas, Ohio, US |
996872 | 996872 | 2020-05-23 | US | Texas | Potter | 48375 | 2021 | 24 | 0 | 2205 | 35.40133773 | -101.893964 | 2020-05-24 02:32:43 | Potter, Texas, 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]);