johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
93 rows where active = 2049 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3385722 | 3385722 | 2021-07-29 | Taiwan* | 15637 | 787 | 12801 | 2049 | 23.7 | 121.0 | 2021-07-30 04:21:34 | Taiwan* | |||
1712176 | 1712176 | 2021-06-25 | Colombia | Magdalena | 78468 | 2904 | 73515 | 2049 | 10.4113 | -74.4057 | 2021-06-26 04:21:43 | Magdalena, Colombia | ||
2423101 | 2423101 | 2021-06-23 | Russia | Khabarovsk Krai | 54284 | 461 | 51774 | 2049 | 51.6312684 | 136.121524 | 2021-06-24 04:21:55 | Khabarovsk Krai, Russia | ||
2315562 | 2315562 | 2021-06-04 | Russia | Vologda Oblast | 46279 | 1105 | 43125 | 2049 | 60.0391461 | 43.1215213 | 2021-06-05 04:23:03 | Vologda Oblast, Russia | ||
20582 | 20582 | 2021-05-28 | Russia | Kirov Oblast | 43770 | 364 | 41357 | 2049 | 57.9665589 | 49.4074599 | 2021-05-29 04:20:41 | Kirov Oblast, Russia | ||
726713 | 726713 | 2021-05-22 | Russia | Krasnoyarsk Krai | 72650 | 3682 | 66919 | 2049 | 63.3233807 | 97.0979974 | 2021-05-23 04:20:51 | Krasnoyarsk Krai, Russia | ||
3675867 | 3675867 | 2021-05-04 | Russia | Krasnoyarsk Krai | 70793 | 3539 | 65205 | 2049 | 63.3233807 | 97.0979974 | 2021-05-05 04:20:43 | Krasnoyarsk Krai, Russia | ||
2645743 | 2645743 | 2021-04-08 | Italy | P.A. Trento | 42114 | 1307 | 38758 | 2049 | 46.06893511 | 11.12123097 | 2021-04-09 04:21:13 | P.A. Trento, Italy | ||
2781225 | 2781225 | 2021-03-24 | Russia | Omsk Oblast | 43169 | 1293 | 39827 | 2049 | 56.09352629999999 | 73.5099936 | 2021-03-25 05:27:00 | Omsk Oblast, Russia | ||
282027 | 282027 | 2021-02-24 | US | Mississippi | Tishomingo | 28141 | 2114 | 65 | 0 | 2049 | 34.74023475 | -88.23917219 | 2021-02-25 05:24:57 | Tishomingo, Mississippi, US |
474901 | 474901 | 2021-02-19 | US | West Virginia | Mingo | 54059 | 2082 | 33 | 0 | 2049 | 37.73048351 | -82.13338365 | 2021-02-20 05:22:51 | Mingo, West Virginia, US |
473476 | 473476 | 2021-02-19 | US | Nebraska | Gage | 31067 | 2065 | 16 | 0 | 2049 | 40.26186809 | -96.68946704 | 2021-02-20 05:22:51 | Gage, Nebraska, US |
473216 | 473216 | 2021-02-19 | US | Mississippi | Jasper | 28061 | 2091 | 42 | 0 | 2049 | 32.01922104 | -89.11786866 | 2021-02-20 05:22:51 | Jasper, Mississippi, US |
2640329 | 2640329 | 2021-02-11 | US | Oregon | Douglas | 41019 | 2100 | 51 | 0 | 2049 | 43.27941273 | -123.167291 | 2021-02-12 05:23:29 | Douglas, Oregon, US |
3980846 | 3980846 | 2021-02-10 | US | New York | Washington | 36115 | 2094 | 45 | 0 | 2049 | 43.31153794 | -73.43043448 | 2021-02-11 05:23:55 | Washington, New York, US |
1528991 | 1528991 | 2021-02-09 | US | Indiana | Jennings | 18079 | 2092 | 43 | 0 | 2049 | 38.99588883 | -85.62710784 | 2021-02-10 05:22:41 | Jennings, Indiana, US |
614897 | 614897 | 2021-02-08 | US | Iowa | Mahaska | 19123 | 2092 | 43 | 0 | 2049 | 41.33521503 | -92.64083907 | 2021-02-09 05:23:30 | Mahaska, Iowa, US |
1674426 | 1674426 | 2021-02-07 | US | Missouri | Washington | 29221 | 2091 | 42 | 0 | 2049 | 37.96130078 | -90.87948158 | 2021-02-08 05:22:39 | Washington, Missouri, US |
794020 | 794020 | 2021-02-04 | Ukraine | Volyn Oblast | 37182 | 587 | 34546 | 2049 | 50.7472 | 25.3254 | 2021-02-05 05:22:38 | Volyn Oblast, Ukraine | ||
793493 | 793493 | 2021-02-04 | US | Texas | Hockley | 48219 | 3097 | 96 | 0 | 2049 | 33.60771256 | -102.3431676 | 2021-02-05 05:22:38 | Hockley, Texas, US |
792207 | 792207 | 2021-02-04 | US | Mississippi | Newton | 28101 | 2098 | 49 | 0 | 2049 | 32.40021118 | -89.11843336 | 2021-02-05 05:22:38 | Newton, Mississippi, US |
342786 | 342786 | 2021-02-03 | US | Ohio | Van Wert | 39161 | 2111 | 62 | 0 | 2049 | 40.8554138 | -84.59111700000003 | 2021-02-04 05:22:26 | Van Wert, Ohio, US |
3504634 | 3504634 | 2021-01-17 | US | Kansas | Franklin | 20059 | 2072 | 23 | 0 | 2049 | 38.56443815 | -95.28644341 | 2021-01-18 05:22:34 | Franklin, Kansas, US |
3503614 | 3503614 | 2021-01-17 | Russia | Vladimir Oblast | 21352 | 582 | 18721 | 2049 | 56.0503336 | 40.6561633 | 2021-01-18 05:22:34 | Vladimir Oblast, Russia | ||
3102717 | 3102717 | 2021-01-16 | US | Kansas | Franklin | 20059 | 2072 | 23 | 0 | 2049 | 38.56443815 | -95.28644341 | 2021-01-17 05:22:17 | Franklin, Kansas, US |
3516679 | 3516679 | 2021-01-15 | US | Kansas | Franklin | 20059 | 2072 | 23 | 0 | 2049 | 38.56443815 | -95.28644341 | 2021-01-16 05:22:40 | Franklin, Kansas, US |
3515659 | 3515659 | 2021-01-15 | Russia | Vladimir Oblast | 21035 | 570 | 18416 | 2049 | 56.0503336 | 40.6561633 | 2021-01-16 05:22:40 | Vladimir Oblast, Russia | ||
3311699 | 3311699 | 2021-01-13 | US | West Virginia | Preston | 54077 | 2083 | 34 | 0 | 2049 | 39.46770987 | -79.66712803 | 2021-01-14 05:22:32 | Preston, West Virginia, US |
775412 | 775412 | 2021-01-12 | US | Indiana | Clay | 18021 | 2090 | 41 | 0 | 2049 | 39.39561833 | -87.11723506 | 2021-01-13 05:22:15 | Clay, Indiana, US |
191428 | 191428 | 2021-01-11 | US | Kentucky | Bell | 21013 | 2078 | 29 | 0 | 2049 | 36.73355174 | -83.67766671 | 2021-01-12 05:22:15 | Bell, Kentucky, US |
2626122 | 2626122 | 2021-01-10 | Russia | Tula Oblast | 24874 | 854 | 21971 | 2049 | 53.9570701 | 37.3690909 | 2021-01-11 05:21:50 | Tula Oblast, Russia | ||
157152 | 157152 | 2021-01-08 | US | Texas | Moore | 48341 | 2669 | 54 | 0 | 2049 | 35.83769242 | -101.8930281 | 2021-01-09 05:22:18 | Moore, Texas, US |
156648 | 156648 | 2021-01-08 | US | Pennsylvania | Jefferson | 42065 | 2099 | 50 | 0 | 2049 | 41.12913106 | -78.9986361 | 2021-01-09 05:22:18 | Jefferson, Pennsylvania, US |
3036953 | 3036953 | 2021-01-05 | US | Pennsylvania | Clinton | 42035 | 2075 | 26 | 0 | 2049 | 41.23255967 | -77.63785995 | 2021-01-06 05:22:16 | Clinton, Pennsylvania, US |
3036250 | 3036250 | 2021-01-05 | US | Missouri | Saline | 29195 | 2075 | 26 | 0 | 2049 | 39.13734288 | -93.20259964 | 2021-01-06 05:22:16 | Saline, Missouri, US |
2230502 | 2230502 | 2021-01-02 | US | Tennessee | Smith | 47159 | 2086 | 24 | 0 | 2049 | 36.25359775 | -85.95411046 | 2021-01-03 05:22:52 | Smith, Tennessee, US |
3699074 | 3699074 | 2020-12-31 | US | Wisconsin | Waushara | 55137 | 2067 | 18 | 0 | 2049 | 44.11324419 | -89.24317107 | 2021-01-01 05:23:07 | Waushara, Wisconsin, US |
1011838 | 1011838 | 2020-12-30 | US | Louisiana | Vernon | 22115 | 2122 | 73 | 0 | 2049 | 31.10884837 | -93.18153838 | 2020-12-31 05:22:49 | Vernon, Louisiana, US |
3764830 | 3764830 | 2020-12-28 | US | Texas | Wilson | 48493 | 2156 | 33 | 0 | 2049 | 29.1732598 | -98.08693082 | 2020-12-29 05:22:37 | Wilson, Texas, US |
3781335 | 3781335 | 2020-12-27 | US | Washington | Grays Harbor | 53027 | 2069 | 20 | 0 | 2049 | 47.14003705 | -123.7820567 | 2020-12-28 05:22:06 | Grays Harbor, Washington, US |
3781150 | 3781150 | 2020-12-27 | US | Texas | Wilson | 48493 | 2135 | 33 | 0 | 2049 | 29.1732598 | -98.08693082 | 2020-12-28 05:22:06 | Wilson, Texas, US |
2226940 | 2226940 | 2020-12-26 | US | Washington | Grays Harbor | 53027 | 2069 | 20 | 0 | 2049 | 47.14003705 | -123.7820567 | 2020-12-27 05:22:55 | Grays Harbor, Washington, US |
2226755 | 2226755 | 2020-12-26 | US | Texas | Wilson | 48493 | 2135 | 33 | 0 | 2049 | 29.1732598 | -98.08693082 | 2020-12-27 05:22:55 | Wilson, Texas, US |
2225702 | 2225702 | 2020-12-26 | US | New Mexico | Otero | 35035 | 2085 | 36 | 0 | 2049 | 32.61348406 | -105.7417604 | 2020-12-27 05:22:55 | Otero, New Mexico, US |
205502 | 205502 | 2020-12-25 | US | Texas | Wilson | 48493 | 2113 | 33 | 0 | 2049 | 29.1732598 | -98.08693082 | 2020-12-26 05:22:28 | Wilson, Texas, US |
929919 | 929919 | 2020-12-21 | US | New York | Genesee | 36037 | 2080 | 31 | 0 | 2049 | 43.0022601 | -78.19135193 | 2020-12-22 05:22:33 | Genesee, New York, US |
2932154 | 2932154 | 2020-12-19 | US | Idaho | Latah | 16057 | 2052 | 3 | 0 | 2049 | 46.81587887 | -116.7113698 | 2020-12-20 05:27:32 | Latah, Idaho, US |
1753297 | 1753297 | 2020-12-14 | US | Nebraska | Adams | 31001 | 2075 | 26 | 0 | 2049 | 40.52449420000001 | -98.50117804 | 2020-12-15 05:26:38 | Adams, Nebraska, US |
3849626 | 3849626 | 2020-12-13 | US | Mississippi | Sunflower | 28133 | 2106 | 57 | 0 | 2049 | 33.60192578 | -90.58882684 | 2020-12-14 05:26:27 | Sunflower, Mississippi, US |
1602506 | 1602506 | 2020-12-10 | US | North Carolina | Carteret | 37031 | 2065 | 16 | 0 | 2049 | 34.8932941 | -76.54120135 | 2020-12-11 05:26:59 | Carteret, North Carolina, US |
1821136 | 1821136 | 2020-12-08 | US | North Carolina | Richmond | 37153 | 2089 | 40 | 0 | 2049 | 35.00417719 | -79.74491009 | 2020-12-09 05:28:01 | Richmond, North Carolina, US |
2349778 | 2349778 | 2020-12-07 | US | North Carolina | Scotland | 37165 | 2092 | 43 | 0 | 2049 | 34.8386299 | -79.4757978 | 2020-12-08 05:27:42 | Scotland, North Carolina, US |
1352139 | 1352139 | 2020-11-24 | US | Mississippi | Neshoba | 28099 | 2164 | 115 | 0 | 2049 | 32.75339664 | -89.11726492 | 2020-11-25 05:27:20 | Neshoba, Mississippi, US |
1351949 | 1351949 | 2020-11-24 | US | Michigan | Ionia | 26067 | 2062 | 13 | 0 | 2049 | 42.94502238 | -85.07413319 | 2020-11-25 05:27:20 | Ionia, Michigan, US |
821926 | 821926 | 2020-11-19 | US | Alabama | Covington | 1039 | 2081 | 32 | 0 | 2049 | 31.2477854 | -86.45050893 | 2020-11-20 05:26:28 | Covington, Alabama, US |
1730445 | 1730445 | 2020-11-08 | US | Missouri | Taney | 29213 | 2085 | 36 | 0 | 2049 | 36.65465345 | -93.04075153 | 2020-11-09 05:25:45 | Taney, Missouri, US |
2921491 | 2921491 | 2020-11-04 | US | North Carolina | Granville | 37077 | 2100 | 51 | 0 | 2049 | 36.30337451 | -78.65184241 | 2020-11-05 06:05:03 | Granville, North Carolina, US |
2501065 | 2501065 | 2020-11-03 | US | Texas | Coryell | 48099 | 2386 | 14 | 0 | 2049 | 31.39078397 | -97.79936155 | 2020-11-04 05:25:09 | Coryell, Texas, US |
3412613 | 3412613 | 2020-11-01 | US | Texas | Nacogdoches | 48347 | 2173 | 70 | 0 | 2049 | 31.62017125 | -94.61803994 | 2020-11-02 05:25:04 | Nacogdoches, Texas, US |
3480963 | 3480963 | 2020-10-26 | US | Connecticut | Litchfield | 9005 | 2192 | 143 | 0 | 2049 | 41.7937534 | -73.2451475 | 2020-10-27 04:24:45 | Litchfield, Connecticut, US |
8766 | 8766 | 2020-10-25 | US | Arizona | Cochise | 4003 | 2122 | 73 | 0 | 2049 | 31.87934684 | -109.7516088 | 2020-10-26 04:25:02 | Cochise, Arizona, US |
1028224 | 1028224 | 2020-10-17 | US | Missouri | Christian | 29043 | 2059 | 10 | 0 | 2049 | 36.9711783 | -93.18537118 | 2020-10-18 04:24:25 | Christian, Missouri, US |
2604467 | 2604467 | 2020-10-10 | US | Ohio | Clark | 39023 | 2100 | 51 | 0 | 2049 | 39.91592258 | -83.78498252 | 2020-10-11 04:23:46 | Clark, Ohio, US |
3802583 | 3802583 | 2020-10-05 | US | Florida | Hendry | 12051 | 2089 | 40 | 0 | 2049 | 26.55386945 | -81.16469006 | 2020-10-06 04:23:33 | Hendry, Florida, US |
3389904 | 3389904 | 2020-10-02 | US | Arkansas | Unassigned | 90005 | 2049 | 0 | 0 | 2049 | 36.38177105 | 0.0 | 2020-10-03 04:23:40 | Unassigned, Arkansas, US |
1518809 | 1518809 | 2020-09-28 | US | Washington | Chelan | 53007 | 2066 | 17 | 0 | 2049 | 47.87046092 | -120.6173956 | 2020-09-29 04:23:42 | Chelan, Washington, US |
2614145 | 2614145 | 2020-09-26 | Namibia | 10918 | 120 | 8749 | 2049 | -22.9576 | 18.4904 | 2020-09-27 04:23:00 | Namibia | |||
2606529 | 2606529 | 2020-09-24 | US | Arkansas | Pope | 5115 | 2079 | 30 | 0 | 2049 | 35.44871474 | -93.03212219 | 2020-09-25 04:23:00 | Pope, Arkansas, US |
1124030 | 1124030 | 2020-09-17 | US | Ohio | Delaware | 39041 | 2069 | 20 | 0 | 2049 | 40.27942393 | -83.00457058 | 2020-09-18 05:05:00 | Delaware, Ohio, US |
1172902 | 1172902 | 2020-09-10 | Azerbaijan | 37874 | 556 | 35269 | 2049 | 40.1431 | 47.5769 | 2020-09-11 04:46:23 | Azerbaijan | |||
3162220 | 3162220 | 2020-09-06 | US | Colorado | Douglas | 8035 | 2314 | 59 | 0 | 2049 | 39.33133796 | -104.930001 | 2020-09-07 04:28:30 | Douglas, Colorado, US |
3161906 | 3161906 | 2020-09-06 | Spain | Cantabria | 4561 | 225 | 2287 | 2049 | 43.1828 | -3.9878 | 2020-09-07 04:28:30 | Cantabria, Spain | ||
813861 | 813861 | 2020-09-05 | Spain | Cantabria | 4561 | 225 | 2287 | 2049 | 43.1828 | -3.9878 | 2020-09-06 04:28:33 | Cantabria, Spain | ||
2662061 | 2662061 | 2020-09-04 | Spain | Cantabria | 4561 | 225 | 2287 | 2049 | 43.1828 | -3.9878 | 2020-09-05 04:28:19 | Cantabria, Spain | ||
1354521 | 1354521 | 2020-09-03 | Russia | Khabarovsk Krai | 10309 | 93 | 8167 | 2049 | 51.6312684 | 136.121524 | 2020-09-04 04:28:26 | Khabarovsk Krai, Russia | ||
3933688 | 3933688 | 2020-08-30 | US | Michigan | Ottawa | 26139 | 2112 | 63 | 0 | 2049 | 42.95996803 | -85.9969107 | 2020-08-31 04:28:27 | Ottawa, Michigan, US |
206990 | 206990 | 2020-08-19 | US | Georgia | Bartow | 13015 | 2114 | 65 | 0 | 2049 | 34.23732119 | -84.83887523 | 2020-08-20 04:27:43 | Bartow, Georgia, US |
3792017 | 3792017 | 2020-08-05 | US | North Carolina | Randolph | 37151 | 2085 | 36 | 0 | 2049 | 35.71015088 | -79.80570339 | 2020-08-06 04:35:02 | Randolph, North Carolina, US |
1499304 | 1499304 | 2020-07-25 | US | Louisiana | Acadia | 22001 | 2111 | 62 | 0 | 2049 | 30.295064899999996 | -92.41419698 | 2020-07-26 04:35:00 | Acadia, Louisiana, US |
2560275 | 2560275 | 2020-07-24 | US | Louisiana | Acadia | 22001 | 2111 | 62 | 0 | 2049 | 30.295064899999996 | -92.41419698 | 2020-07-25 04:47:39 | Acadia, Louisiana, US |
326629 | 326629 | 2020-07-20 | US | Utah | Weber-Morgan | 2071 | 22 | 0 | 2049 | 41.27116049 | -111.9145117 | 2020-07-21 04:38:46 | Weber-Morgan, Utah, US | |
367008 | 367008 | 2020-07-16 | US | Oregon | Washington | 41067 | 2070 | 21 | 0 | 2049 | 45.55972701 | -123.0955257 | 2020-07-17 04:34:50 | Washington, Oregon, US |
2747832 | 2747832 | 2020-07-15 | US | South Carolina | York | 45091 | 2062 | 13 | 0 | 2049 | 34.97281497 | -81.18085944 | 2020-07-16 04:44:59 | York, South Carolina, US |
3237392 | 3237392 | 2020-07-10 | Peru | Cusco | 2125 | 76 | 0 | 2049 | -13.191068 | -72.153609 | 2020-07-11 04:34:26 | Cusco, Peru | ||
1005470 | 1005470 | 2020-07-09 | Russia | Kaluga Oblast | 6458 | 49 | 4360 | 2049 | 54.4382773 | 35.5272854 | 2020-07-10 04:34:24 | Kaluga Oblast, Russia | ||
2222351 | 2222351 | 2020-07-08 | US | Texas | Webb | 48479 | 1776 | 42 | 0 | 2049 | 27.7610369 | -99.33237355 | 2020-07-09 04:34:23 | Webb, Texas, US |
529930 | 529930 | 2020-07-04 | Peru | Madre de Dios | 2119 | 70 | 0 | 2049 | -11.972699 | -70.53171999999998 | 2020-07-05 04:33:46 | Madre de Dios, Peru | ||
1522272 | 1522272 | 2020-06-23 | Russia | Chuvashia Republic | 4678 | 24 | 2605 | 2049 | 55.4259922 | 47.0849429 | 2020-06-24 04:33:28 | Chuvashia Republic, Russia | ||
3247149 | 3247149 | 2020-06-21 | US | Tennessee | Hamilton | 47065 | 1994 | 25 | 0 | 2049 | 35.17670231 | -85.16652245 | 2020-06-22 04:33:20 | Hamilton, Tennessee, US |
1789352 | 1789352 | 2020-05-29 | US | Arizona | Pima | 4019 | 2234 | 185 | 0 | 2049 | 32.0971334 | -111.7890033 | 2020-05-30 02:32:48 | Pima, Arizona, US |
114171 | 114171 | 2020-05-08 | US | Puerto Rico | 72 | 2156 | 107 | 0 | 2049 | 18.2208 | -66.5901 | 2020-05-09 02:32:35 | Puerto Rico, US | |
1384130 | 1384130 | 2020-04-19 | US | Florida | Palm Beach | 12099 | 2170 | 121 | 0 | 2049 | 26.64676272 | -80.46536002 | 2020-04-19 23:41:01 | Palm Beach, Florida, US |
2875615 | 2875615 | 2020-03-29 | China | Hubei | 67801 | 3182 | 62570 | 2049 | 30.9756 | 112.2707 | 3/29/20 14:07 | Hubei, China |
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]);