johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
97 rows where active = 2088 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2295661 | 2295661 | 2021-06-24 | Russia | Khabarovsk Krai | 54422 | 464 | 51870 | 2088 | 51.6312684 | 136.121524 | 2021-06-25 04:21:33 | Khabarovsk Krai, Russia | ||
563162 | 563162 | 2021-06-22 | Russia | Chelyabinsk Oblast | 63801 | 1741 | 59972 | 2088 | 54.4223954 | 61.1865846 | 2021-06-23 04:21:46 | Chelyabinsk Oblast, Russia | ||
3358864 | 3358864 | 2021-06-21 | Russia | Chelyabinsk Oblast | 63698 | 1737 | 59873 | 2088 | 54.4223954 | 61.1865846 | 2021-06-22 04:21:34 | Chelyabinsk Oblast, Russia | ||
2339646 | 2339646 | 2021-06-15 | Russia | Tatarstan Republic | 21938 | 518 | 19332 | 2088 | 55.7648572 | 52.43104273 | 2021-06-16 04:22:32 | Tatarstan Republic, Russia | ||
3621012 | 3621012 | 2021-03-17 | Haiti | 12722 | 251 | 10331 | 2088 | 18.9712 | -72.2852 | 2021-03-18 05:26:22 | Haiti | |||
3962434 | 3962434 | 2021-03-10 | Germany | Mecklenburg-Vorpommern | 25962 | 789 | 23265 | 2088 | 53.6127 | 12.4296 | 2021-03-11 05:25:48 | Mecklenburg-Vorpommern, Germany | ||
1616583 | 1616583 | 2021-03-05 | US | Alabama | Barbour | 1005 | 2139 | 51 | 0 | 2088 | 31.868263 | -85.3871286 | 2021-03-06 04:23:41 | Barbour, Alabama, US |
2370986 | 2370986 | 2021-02-28 | US | West Virginia | Mingo | 54059 | 2122 | 34 | 0 | 2088 | 37.73048351 | -82.13338365 | 2021-03-01 05:23:01 | Mingo, West Virginia, US |
3069488 | 3069488 | 2021-02-27 | US | West Virginia | Mingo | 54059 | 2122 | 34 | 0 | 2088 | 37.73048351 | -82.13338365 | 2021-02-28 05:22:20 | Mingo, West Virginia, US |
3066202 | 3066202 | 2021-02-27 | Russia | Kaluga Oblast | 29707 | 257 | 27362 | 2088 | 54.4382773 | 35.5272854 | 2021-02-28 05:22:20 | Kaluga Oblast, Russia | ||
281392 | 281392 | 2021-02-24 | US | Iowa | Mahaska | 19123 | 2133 | 45 | 0 | 2088 | 41.33521503 | -92.64083907 | 2021-02-25 05:24:57 | Mahaska, Iowa, US |
281220 | 281220 | 2021-02-24 | US | Illinois | Shelby | 17173 | 2122 | 34 | 0 | 2088 | 39.39133527 | -88.80611122 | 2021-02-25 05:24:57 | Shelby, Illinois, US |
1938764 | 1938764 | 2021-02-23 | US | North Carolina | Greene | 37079 | 2127 | 39 | 0 | 2088 | 35.48544173 | -77.67578087 | 2021-02-24 05:29:16 | Greene, North Carolina, US |
531497 | 531497 | 2021-02-22 | US | Georgia | Fannin | 13111 | 2148 | 60 | 0 | 2088 | 34.86430205 | -84.316964 | 2021-02-23 05:23:41 | Fannin, Georgia, US |
3602592 | 3602592 | 2021-02-17 | US | Maine | Oxford | 23017 | 2129 | 41 | 0 | 2088 | 44.49952995 | -70.75682123 | 2021-02-18 05:22:58 | Oxford, Maine, US |
2678953 | 2678953 | 2021-02-13 | US | Indiana | Spencer | 18147 | 2116 | 28 | 0 | 2088 | 38.01519732 | -87.0079644 | 2021-02-14 05:23:43 | Spencer, Indiana, US |
2640671 | 2640671 | 2021-02-11 | US | Tennessee | Johnson | 47091 | 2112 | 37 | 0 | 2088 | 36.45523950000001 | -81.84886538 | 2021-02-12 05:23:29 | Johnson, Tennessee, US |
1528685 | 1528685 | 2021-02-09 | US | Georgia | Elbert | 13105 | 2137 | 49 | 0 | 2088 | 34.11302332 | -82.83936148 | 2021-02-10 05:22:41 | Elbert, Georgia, US |
1675797 | 1675797 | 2021-02-07 | US | Virginia | Halifax | 51083 | 2143 | 55 | 0 | 2088 | 36.76654925 | -78.93512622 | 2021-02-08 05:22:39 | Halifax, Virginia, US |
1675252 | 1675252 | 2021-02-07 | US | South Carolina | Barnwell | 45011 | 2131 | 43 | 0 | 2088 | 33.26679302 | -81.43584352 | 2021-02-08 05:22:39 | Barnwell, South Carolina, US |
1674968 | 1674968 | 2021-02-07 | US | Ohio | Van Wert | 39161 | 2150 | 62 | 0 | 2088 | 40.8554138 | -84.59111700000003 | 2021-02-08 05:22:39 | Van Wert, Ohio, US |
791952 | 791952 | 2021-02-04 | US | Maryland | Dorchester | 24019 | 2124 | 36 | 0 | 2088 | 38.45413522 | -76.02752426 | 2021-02-05 05:22:38 | Dorchester, Maryland, US |
1688133 | 1688133 | 2021-02-02 | Ukraine | Rivne Oblast | 45982 | 579 | 43315 | 2088 | 50.6199 | 26.2516 | 2021-02-03 05:22:52 | Rivne Oblast, Ukraine | ||
1462445 | 1462445 | 2021-01-31 | US | Pennsylvania | Pike | 42103 | 2132 | 44 | 0 | 2088 | 41.33155042 | -75.03208106 | 2021-02-01 05:22:53 | Pike, Pennsylvania, US |
436256 | 436256 | 2021-01-21 | US | Hawaii | Hawaii | 15001 | 2133 | 45 | 0 | 2088 | 19.60121157 | -155.5210167 | 2021-01-22 05:22:10 | Hawaii, Hawaii, US |
1094344 | 1094344 | 2021-01-20 | Russia | Vladimir Oblast | 21823 | 607 | 19128 | 2088 | 56.0503336 | 40.6561633 | 2021-01-21 05:22:01 | Vladimir Oblast, Russia | ||
908984 | 908984 | 2021-01-19 | US | Georgia | Haralson | 13143 | 2138 | 50 | 0 | 2088 | 33.79602175 | -85.21005667 | 2021-01-20 05:21:54 | Haralson, Georgia, US |
908168 | 908168 | 2021-01-19 | Italy | P.A. Trento | 25272 | 1081 | 22103 | 2088 | 46.06893511 | 11.12123097 | 2021-01-20 05:21:54 | P.A. Trento, Italy | ||
3104308 | 3104308 | 2021-01-16 | US | South Dakota | Hughes | 46065 | 2118 | 30 | 0 | 2088 | 44.39091534 | -99.99661148 | 2021-01-17 05:22:17 | Hughes, South Dakota, US |
3310694 | 3310694 | 2021-01-13 | US | Ohio | Perry | 39127 | 2129 | 41 | 0 | 2088 | 39.73508655 | -82.23804971 | 2021-01-14 05:22:32 | Perry, Ohio, US |
189987 | 189987 | 2021-01-11 | Germany | Saarland | 21900 | 543 | 19740 | 2088 | 49.3964 | 7.023 | 2021-01-12 05:22:15 | Saarland, Germany | ||
2542142 | 2542142 | 2021-01-07 | US | Florida | Washington | 12133 | 2118 | 30 | 0 | 2088 | 30.61359259 | -85.66002461 | 2021-01-08 05:22:42 | Washington, Florida, US |
2867364 | 2867364 | 2021-01-06 | US | Pennsylvania | Clarion | 42031 | 2138 | 50 | 0 | 2088 | 41.19265812 | -79.42413524 | 2021-01-07 05:22:03 | Clarion, Pennsylvania, US |
2866012 | 2866012 | 2021-01-06 | US | Kansas | Labette | 20099 | 2119 | 31 | 0 | 2088 | 37.19113093 | -95.29849679 | 2021-01-07 05:22:03 | Labette, Kansas, US |
3037650 | 3037650 | 2021-01-05 | US | Virginia | James City | 51095 | 2119 | 31 | 0 | 2088 | 37.31156958 | -76.76950618 | 2021-01-06 05:22:16 | James City, Virginia, US |
1062365 | 1062365 | 2021-01-04 | US | Arkansas | Sevier | 5133 | 2108 | 20 | 0 | 2088 | 33.99780401 | -94.2424869 | 2021-01-05 05:21:49 | Sevier, Arkansas, US |
2227358 | 2227358 | 2021-01-02 | Colombia | Boyaca | 29258 | 630 | 26540 | 2088 | 5.4545 | -73.362 | 2021-01-03 05:22:52 | Boyaca, Colombia | ||
2227037 | 2227037 | 2020-12-26 | US | Wisconsin | Door | 55029 | 2102 | 14 | 0 | 2088 | 44.95856458 | -87.30002707 | 2020-12-27 05:22:55 | Door, Wisconsin, US |
205784 | 205784 | 2020-12-25 | US | Wisconsin | Door | 55029 | 2102 | 14 | 0 | 2088 | 44.95856458 | -87.30002707 | 2020-12-26 05:22:28 | Door, Wisconsin, US |
205026 | 205026 | 2020-12-25 | US | Puerto Rico | Toa Alta | 72135 | 2088 | 0 | 0 | 2088 | 18.362406 | -66.246616 | 2020-12-26 05:22:28 | Toa Alta, Puerto Rico, US |
3695007 | 3695007 | 2020-12-24 | US | Wisconsin | Door | 55029 | 2102 | 14 | 0 | 2088 | 44.95856458 | -87.30002707 | 2020-12-25 05:22:48 | Door, Wisconsin, US |
3151866 | 3151866 | 2020-12-16 | US | North Carolina | Alexander | 37003 | 2109 | 21 | 0 | 2088 | 35.922379600000006 | -81.17751948 | 2020-12-17 05:28:12 | Alexander, North Carolina, US |
1036212 | 1036212 | 2020-12-15 | US | Mississippi | Sunflower | 28133 | 2145 | 57 | 0 | 2088 | 33.60192578 | -90.58882684 | 2020-12-16 05:28:04 | Sunflower, Mississippi, US |
848564 | 848564 | 2020-12-12 | US | Tennessee | Wayne | 47181 | 2141 | 14 | 0 | 2088 | 35.23868267 | -87.78644456 | 2020-12-13 05:27:20 | Wayne, Tennessee, US |
2348414 | 2348414 | 2020-12-07 | US | Illinois | Jefferson | 17081 | 2150 | 62 | 0 | 2088 | 38.29980057 | -88.9240025 | 2020-12-08 05:27:42 | Jefferson, Illinois, US |
2347279 | 2347279 | 2020-12-07 | Colombia | Norte de Santander | 31480 | 1483 | 27909 | 2088 | 7.9463 | -72.8988 | 2020-12-08 05:27:42 | Norte de Santander, Colombia | ||
1006873 | 1006873 | 2020-12-06 | US | California | Tehama | 6103 | 2089 | 9 | 0 | 2088 | 40.12570935 | -122.2370171 | 2020-12-07 05:26:14 | Tehama, California, US |
1635908 | 1635908 | 2020-12-05 | US | Wyoming | Sweetwater | 56037 | 2098 | 10 | 0 | 2088 | 41.65943896 | -108.8827882 | 2020-12-06 05:26:18 | Sweetwater, Wyoming, US |
3861188 | 3861188 | 2020-12-04 | US | Kentucky | Barren | 21009 | 2119 | 31 | 0 | 2088 | 36.96469836 | -85.93338945 | 2020-12-05 05:27:36 | Barren, Kentucky, US |
2937890 | 2937890 | 2020-11-28 | US | Pennsylvania | Fayette | 42051 | 2107 | 19 | 0 | 2088 | 39.92041012 | -79.64291195 | 2020-11-29 05:25:55 | Fayette, Pennsylvania, US |
2937053 | 2937053 | 2020-11-28 | US | Mississippi | Neshoba | 28099 | 2206 | 118 | 0 | 2088 | 32.75339664 | -89.11726492 | 2020-11-29 05:25:55 | Neshoba, Mississippi, US |
394053 | 394053 | 2020-11-27 | US | Mississippi | Marshall | 28093 | 2138 | 50 | 0 | 2088 | 34.76216286 | -89.50299462 | 2020-11-28 05:25:50 | Marshall, Mississippi, US |
924602 | 924602 | 2020-11-26 | US | Idaho | Cassia | 16031 | 2105 | 17 | 0 | 2088 | 42.28347888 | -113.6012409 | 2020-11-27 05:26:53 | Cassia, Idaho, US |
1973507 | 1973507 | 2020-11-25 | US | Idaho | Cassia | 16031 | 2105 | 17 | 0 | 2088 | 42.28347888 | -113.6012409 | 2020-11-26 05:27:44 | Cassia, Idaho, US |
2881115 | 2881115 | 2020-11-15 | US | Idaho | Bingham | 16011 | 2114 | 26 | 0 | 2088 | 43.21672879999999 | -112.3978437 | 2020-11-16 05:25:57 | Bingham, Idaho, US |
2916093 | 2916093 | 2020-11-14 | US | Idaho | Bingham | 16011 | 2114 | 26 | 0 | 2088 | 43.21672879999999 | -112.3978437 | 2020-11-15 05:26:53 | Bingham, Idaho, US |
2785364 | 2785364 | 2020-11-13 | US | Alabama | Dale | 1045 | 2142 | 54 | 0 | 2088 | 31.43037123 | -85.61095742 | 2020-11-14 05:25:37 | Dale, Alabama, US |
3444173 | 3444173 | 2020-11-11 | US | Virginia | Manassas | 51683 | 2116 | 28 | 0 | 2088 | 38.7464321 | -77.48509905 | 2020-11-12 05:25:55 | Manassas, Virginia, US |
1990593 | 1990593 | 2020-11-09 | US | Missouri | Taney | 29213 | 2124 | 36 | 0 | 2088 | 36.65465345 | -93.04075153 | 2020-11-10 05:40:07 | Taney, Missouri, US |
1546991 | 1546991 | 2020-11-07 | US | Texas | Coryell | 48099 | 2435 | 14 | 0 | 2088 | 31.39078397 | -97.79936155 | 2020-11-08 05:24:56 | Coryell, Texas, US |
377054 | 377054 | 2020-11-06 | US | Georgia | Tift | 13277 | 2161 | 73 | 0 | 2088 | 31.45743864 | -83.5236119 | 2020-11-07 05:24:52 | Tift, Georgia, US |
2919102 | 2919102 | 2020-11-04 | Germany | Sachsen-Anhalt | 5582 | 86 | 3736 | 2088 | 51.9503 | 11.6923 | 2020-11-05 06:05:03 | Sachsen-Anhalt, Germany | ||
3412127 | 3412127 | 2020-11-01 | US | Pennsylvania | Schuylkill | 42107 | 2185 | 97 | 0 | 2088 | 40.70497338 | -76.2150785 | 2020-11-02 05:25:04 | Schuylkill, Pennsylvania, US |
2244174 | 2244174 | 2020-10-30 | US | Georgia | Fayette | 13113 | 2145 | 57 | 0 | 2088 | 33.41357794 | -84.49089434 | 2020-10-31 04:24:44 | Fayette, Georgia, US |
3655122 | 3655122 | 2020-10-24 | US | Wisconsin | Oconto | 55083 | 2101 | 13 | 0 | 2088 | 45.02715345 | -88.26807503 | 2020-10-25 04:24:36 | Oconto, Wisconsin, US |
764842 | 764842 | 2020-10-18 | US | Oklahoma | Comanche | 40031 | 2104 | 16 | 0 | 2088 | 34.65973764 | -98.47195055 | 2020-10-19 04:24:16 | Comanche, Oklahoma, US |
80607 | 80607 | 2020-10-14 | US | Louisiana | St. Martin | 22099 | 2149 | 61 | 0 | 2088 | 30.13112107 | -91.61403569 | 2020-10-15 04:24:28 | St. Martin, Louisiana, US |
2691992 | 2691992 | 2020-10-08 | US | North Carolina | Henderson | 37089 | 2152 | 64 | 0 | 2088 | 35.33788927 | -82.4766782 | 2020-10-09 04:23:59 | Henderson, North Carolina, US |
1046504 | 1046504 | 2020-09-30 | US | Florida | Highlands | 12055 | 2177 | 89 | 0 | 2088 | 27.34254618 | -81.34071957 | 2020-10-01 04:23:42 | Highlands, Florida, US |
1517838 | 1517838 | 2020-09-28 | US | Ohio | Fairfield | 39045 | 2132 | 44 | 0 | 2088 | 39.75107189 | -82.63088163 | 2020-09-29 04:23:42 | Fairfield, Ohio, US |
2582697 | 2582697 | 2020-09-27 | US | Florida | Putnam | 12107 | 2127 | 39 | 0 | 2088 | 29.60779729 | -81.74230285 | 2020-09-28 04:23:00 | Putnam, Florida, US |
2609004 | 2609004 | 2020-09-24 | US | Tennessee | Sullivan | 47163 | 2137 | 33 | 0 | 2088 | 36.51240691 | -82.30412917 | 2020-09-25 04:23:00 | Sullivan, Tennessee, US |
2454763 | 2454763 | 2020-09-19 | Italy | Puglia | 6944 | 578 | 4278 | 2088 | 41.12559576 | 16.86736689 | 2020-09-20 04:22:00 | Puglia, Italy | ||
666746 | 666746 | 2020-09-16 | US | Arkansas | Faulkner | 5045 | 2103 | 15 | 0 | 2088 | 35.14719007 | -92.33717519 | 2020-09-17 04:22:00 | Faulkner, Arkansas, US |
666677 | 666677 | 2020-09-16 | US | Alabama | Walker | 1127 | 2168 | 80 | 0 | 2088 | 33.80270512 | -87.30027177 | 2020-09-17 04:22:00 | Walker, Alabama, US |
2871374 | 2871374 | 2020-09-13 | US | Pennsylvania | Lackawanna | 42069 | 2302 | 214 | 0 | 2088 | 41.43564672 | -75.60379201 | 2020-09-14 04:26:00 | Lackawanna, Pennsylvania, US |
813292 | 813292 | 2020-09-05 | Australia | Victoria | 19538 | 666 | 16784 | 2088 | -37.8136 | 144.9631 | 2020-09-06 04:28:33 | Victoria, Australia | ||
2993169 | 2993169 | 2020-08-24 | US | Missouri | Jasper | 29097 | 2123 | 35 | 0 | 2088 | 37.20351921 | -94.34050458 | 2020-08-25 04:28:02 | Jasper, Missouri, US |
2300985 | 2300985 | 2020-08-22 | US | Maine | Cumberland | 23005 | 2158 | 70 | 0 | 2088 | 43.8370751 | -70.37226999 | 2020-08-23 04:27:48 | Cumberland, Maine, US |
206841 | 206841 | 2020-08-19 | US | Colorado | Boulder | 8013 | 2244 | 71 | 0 | 2088 | 40.09313619 | -105.3546767 | 2020-08-20 04:27:43 | Boulder, Colorado, US |
837454 | 837454 | 2020-08-17 | Colombia | Caqueta | 3922 | 113 | 1721 | 2088 | 0.8699 | -73.8419 | 2020-08-18 04:27:56 | Caqueta, Colombia | ||
583043 | 583043 | 2020-08-13 | Russia | Krasnoyarsk Krai | 14812 | 380 | 12344 | 2088 | 63.3233807 | 97.0979974 | 2020-08-14 04:51:19 | Krasnoyarsk Krai, Russia | ||
1918378 | 1918378 | 2020-08-10 | US | Iowa | Johnson | 19103 | 2107 | 19 | 0 | 2088 | 41.67169354 | -91.58754744 | 2020-08-11 04:35:08 | Johnson, Iowa, US |
371756 | 371756 | 2020-08-08 | Maldives | 4898 | 19 | 2791 | 2088 | 3.2028 | 73.2207 | 2020-08-09 04:34:54 | Maldives | |||
3611187 | 3611187 | 2020-08-06 | US | North Carolina | Randolph | 37151 | 2125 | 37 | 0 | 2088 | 35.71015088 | -79.80570339 | 2020-08-07 04:35:11 | Randolph, North Carolina, US |
843442 | 843442 | 2020-07-22 | US | Florida | Okaloosa | 12091 | 2104 | 16 | 0 | 2088 | 30.69143028 | -86.59267105 | 2020-07-23 05:15:04 | Okaloosa, Florida, US |
2748260 | 2748260 | 2020-07-15 | Sweden | Sormland | 2336 | 248 | 0 | 2088 | 59.0336 | 16.7519 | 2020-07-16 04:44:59 | Sormland, Sweden | ||
1005417 | 1005417 | 2020-07-09 | Mexico | Guanajuato | 10707 | 506 | 8113 | 2088 | 21.019 | -101.2574 | 2020-07-10 04:34:24 | Guanajuato, Mexico | ||
3045344 | 3045344 | 2020-07-02 | India | Kerala | 4753 | 25 | 2640 | 2088 | 10.450898 | 76.405749 | 2020-07-03 04:33:54 | Kerala, India | ||
2438041 | 2438041 | 2020-06-20 | Italy | Piemonte | 31215 | 4045 | 25082 | 2088 | 45.0732745 | 7.680687483 | 2020-06-21 04:33:19 | Piemonte, Italy | ||
2385884 | 2385884 | 2020-06-16 | US | Missouri | St. Louis City | 29510 | 2239 | 151 | 0 | 2088 | 38.63555736 | -90.24349225 | 2020-06-17 04:33:21 | St. Louis City, Missouri, US |
1836419 | 1836419 | 2020-06-14 | US | Minnesota | Stearns | 27145 | 2107 | 19 | 0 | 2088 | 45.55192576 | -94.61078221 | 2020-06-15 03:33:14 | Stearns, Minnesota, US |
3057935 | 3057935 | 2020-06-13 | US | Indiana | Allen | 18003 | 2168 | 80 | 0 | 2088 | 41.09194313 | -85.06800636 | 2020-06-14 03:33:15 | Allen, Indiana, US |
1272350 | 1272350 | 2020-06-11 | US | Ohio | Pickaway | 39129 | 2121 | 33 | 0 | 2088 | 39.64170392 | -83.0243386 | 2020-06-12 05:09:52 | Pickaway, Ohio, US |
215175 | 215175 | 2020-06-08 | US | Maryland | Howard | 24027 | 2156 | 68 | 0 | 2088 | 39.25305293 | -76.93126208 | 2020-06-09 03:33:03 | Howard, Maryland, US |
2042596 | 2042596 | 2020-05-02 | US | California | Santa Clara | 6085 | 2208 | 115 | 0 | 2088 | 37.23104908 | -121.6970462 | 2020-05-03 02:32:28 | Santa Clara, California, US |
521728 | 521728 | 2020-04-21 | US | Washington | Snohomish | 53061 | 2189 | 101 | 0 | 2088 | 48.04615983 | -121.7170703 | 2020-04-21 23:30:50 | Snohomish, Washington, 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]);