daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
79 rows where active = 2636 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-08-01 | Russia | Amur Oblast | 27843 | 344 | 24863 | 2636 | 52.8032368 | 128.437295 | 2021-08-02 04:21:36 | Amur Oblast, Russia | ||
2021-07-21 | Colombia | Cordoba | 95865 | 3379 | 89850 | 2636 | 8.0493 | -75.574 | 2021-07-22 04:21:19 | Cordoba, Colombia | ||
2021-06-22 | Russia | Penza Oblast | 48928 | 937 | 45355 | 2636 | 53.1655415 | 44.78791810000001 | 2021-06-23 04:21:46 | Penza Oblast, Russia | ||
2021-05-08 | Italy | Umbria | 55162 | 1367 | 51159 | 2636 | 43.10675841 | 12.38824698 | 2021-05-09 04:20:35 | Umbria, Italy | ||
2021-04-14 | Maldives | 25844 | 67 | 23141 | 2636 | 3.2028 | 73.2207 | 2021-04-15 04:20:54 | Maldives | |||
2021-04-11 | Russia | Udmurt Republic | 31516 | 777 | 28103 | 2636 | 57.1961165 | 52.69598320000001 | 2021-04-12 04:21:00 | Udmurt Republic, Russia | ||
2021-04-02 | Russia | Lipetsk Oblast | 27774 | 537 | 24601 | 2636 | 52.6935178 | 39.1122664 | 2021-04-03 04:20:44 | Lipetsk Oblast, Russia | ||
2021-02-25 | Sweden | Gotland | 2681 | 45 | 0 | 2636 | 57.4684 | 18.4867 | 2021-02-26 05:22:40 | Gotland, Sweden | ||
2021-02-23 | US | Kentucky | Taylor | 21217 | 2666 | 30 | 0 | 2636 | 37.3677562 | -85.3329931 | 2021-02-24 05:29:16 | Taylor, Kentucky, US |
2021-02-17 | US | Georgia | Gilmer | 13123 | 2700 | 64 | 0 | 2636 | 34.69316688 | -84.45802506 | 2021-02-18 05:22:58 | Gilmer, Georgia, US |
2021-02-16 | US | Nevada | Nye | 32023 | 2728 | 92 | 0 | 2636 | 38.04264256 | -116.4722702 | 2021-02-17 05:23:10 | Nye, Nevada, US |
2021-02-10 | US | Missouri | Lawrence | 29109 | 2702 | 66 | 0 | 2636 | 37.10626634 | -93.83293097 | 2021-02-11 05:23:55 | Lawrence, Missouri, US |
2021-02-09 | US | Missouri | Lawrence | 29109 | 2701 | 65 | 0 | 2636 | 37.10626634 | -93.83293097 | 2021-02-10 05:22:41 | Lawrence, Missouri, US |
2021-02-09 | US | Arkansas | Baxter | 5005 | 2731 | 95 | 0 | 2636 | 36.28784385 | -92.33782872 | 2021-02-10 05:22:41 | Baxter, Arkansas, US |
2021-02-08 | US | Virginia | Wise | 51195 | 2720 | 84 | 0 | 2636 | 36.9746148 | -82.62410519 | 2021-02-09 05:23:30 | Wise, Virginia, US |
2021-02-04 | US | South Carolina | Marlboro | 45069 | 2679 | 43 | 0 | 2636 | 34.59905577 | -79.67561152 | 2021-02-05 05:22:38 | Marlboro, South Carolina, US |
2021-02-02 | US | Louisiana | Vernon | 22115 | 2724 | 88 | 0 | 2636 | 31.10884837 | -93.18153838 | 2021-02-03 05:22:52 | Vernon, Louisiana, US |
2021-01-30 | US | North Carolina | Montgomery | 37123 | 2703 | 67 | 0 | 2636 | 35.33155144 | -79.90416657 | 2021-01-31 05:22:42 | Montgomery, North Carolina, US |
2021-01-29 | US | North Carolina | Montgomery | 37123 | 2703 | 67 | 0 | 2636 | 35.33155144 | -79.90416657 | 2021-01-30 05:22:49 | Montgomery, North Carolina, US |
2021-01-25 | US | Indiana | Daviess | 18027 | 2717 | 81 | 0 | 2636 | 38.70186039 | -87.07185406 | 2021-01-26 05:22:02 | Daviess, Indiana, US |
2021-01-23 | US | Nebraska | Dawson | 31047 | 2662 | 26 | 0 | 2636 | 40.87028216 | -99.8201461 | 2021-01-24 05:22:35 | Dawson, Nebraska, US |
2021-01-21 | US | New Mexico | Otero | 35035 | 2683 | 47 | 0 | 2636 | 32.61348406 | -105.7417604 | 2021-01-22 05:22:10 | Otero, New Mexico, US |
2021-01-14 | Colombia | Tolima | 53226 | 1504 | 49086 | 2636 | 4.0925 | -75.1545 | 2021-01-15 05:22:24 | Tolima, Colombia | ||
2021-01-12 | US | North Carolina | Haywood | 37087 | 2708 | 72 | 0 | 2636 | 35.55269063 | -82.98196486 | 2021-01-13 05:22:15 | Haywood, North Carolina, US |
2021-01-12 | US | New York | Jefferson | 36045 | 2652 | 16 | 0 | 2636 | 44.04200959 | -75.94653457 | 2021-01-13 05:22:15 | Jefferson, New York, US |
2021-01-02 | Germany | Mecklenburg-Vorpommern | 12362 | 173 | 9644 | 2636 | 53.6127 | 12.4296 | 2021-01-03 05:22:52 | Mecklenburg-Vorpommern, Germany | ||
2020-12-30 | US | Texas | Brown | 48049 | 2203 | 59 | 0 | 2636 | 31.77430356 | -98.99907113 | 2020-12-31 05:22:49 | Brown, Texas, US |
2020-12-26 | US | South Carolina | Newberry | 45071 | 2707 | 71 | 0 | 2636 | 34.28629098 | -81.59935761 | 2020-12-27 05:22:55 | Newberry, South Carolina, US |
2020-12-25 | India | Odisha | 327867 | 1853 | 323378 | 2636 | 20.505428 | 84.418059 | 2020-12-26 05:22:28 | Odisha, India | ||
2020-12-22 | US | Oklahoma | Delaware | 40041 | 2679 | 43 | 0 | 2636 | 36.40823634 | -94.80325046 | 2020-12-23 05:22:03 | Delaware, Oklahoma, US |
2020-12-12 | US | Wisconsin | Polk | 55095 | 2656 | 20 | 0 | 2636 | 45.46130348 | -92.44182875 | 2020-12-13 05:27:20 | Polk, Wisconsin, US |
2020-12-10 | US | South Dakota | Brookings | 46011 | 2659 | 23 | 0 | 2636 | 44.36974375 | -96.79079945 | 2020-12-11 05:26:59 | Brookings, South Dakota, US |
2020-12-09 | US | Georgia | Polk | 13233 | 2671 | 35 | 0 | 2636 | 34.00267074 | -85.18677781 | 2020-12-10 05:26:19 | Polk, Georgia, US |
2020-12-06 | US | Oklahoma | Le Flore | 40079 | 2663 | 27 | 0 | 2636 | 34.89851864 | -94.70392124 | 2020-12-07 05:26:14 | Le Flore, Oklahoma, US |
2020-12-06 | US | North Carolina | Granville | 37077 | 2695 | 59 | 0 | 2636 | 36.30337451 | -78.65184241 | 2020-12-07 05:26:14 | Granville, North Carolina, US |
2020-12-06 | Spain | Ceuta | 2854 | 55 | 163 | 2636 | 35.8894 | -5.3213 | 2020-12-07 05:26:14 | Ceuta, Spain | ||
2020-12-05 | US | Louisiana | Lincoln | 22061 | 2697 | 61 | 0 | 2636 | 32.6003154 | -92.6659741 | 2020-12-06 05:26:18 | Lincoln, Louisiana, US |
2020-12-05 | Spain | Ceuta | 2854 | 55 | 163 | 2636 | 35.8894 | -5.3213 | 2020-12-06 05:26:18 | Ceuta, Spain | ||
2020-12-04 | US | North Dakota | Stutsman | 38093 | 2741 | 45 | 0 | 2636 | 46.97962541 | -98.95637318 | 2020-12-05 05:27:36 | Stutsman, North Dakota, US |
2020-12-04 | US | Louisiana | Lincoln | 22061 | 2697 | 61 | 0 | 2636 | 32.6003154 | -92.6659741 | 2020-12-05 05:27:36 | Lincoln, Louisiana, US |
2020-12-04 | Spain | Ceuta | 2854 | 55 | 163 | 2636 | 35.8894 | -5.3213 | 2020-12-05 05:27:36 | Ceuta, Spain | ||
2020-12-02 | US | Minnesota | Polk | 27119 | 2662 | 26 | 0 | 2636 | 47.77372465 | -96.40134647 | 2020-12-03 05:28:22 | Polk, Minnesota, US |
2020-12-02 | Brazil | Mato Grosso | 160540 | 4161 | 152973 | 2636 | -12.6819 | -56.9211 | 2020-12-03 05:28:22 | Mato Grosso, Brazil | ||
2020-12-01 | US | New Mexico | Unassigned | 90035 | 2636 | 0 | 0 | 2636 | 36.60569702 | -108.7151824 | 2020-12-02 05:27:41 | Unassigned, New Mexico, US |
2020-11-30 | US | South Dakota | Codington | 46029 | 2686 | 50 | 0 | 2636 | 44.97788119 | -97.18827677 | 2020-12-01 05:26:18 | Codington, South Dakota, US |
2020-11-29 | Russia | Bryansk Oblast | 17145 | 124 | 14385 | 2636 | 52.8873315 | 33.41585300000001 | 2020-11-30 05:26:13 | Bryansk Oblast, Russia | ||
2020-11-28 | US | Illinois | Henry | 17073 | 2650 | 14 | 0 | 2636 | 41.3533994 | -90.13296166 | 2020-11-29 05:25:55 | Henry, Illinois, US |
2020-11-28 | Russia | Irkutsk Oblast | 31538 | 763 | 28139 | 2636 | 56.6370122 | 104.719221 | 2020-11-29 05:25:55 | Irkutsk Oblast, Russia | ||
2020-11-27 | Colombia | Cundinamarca | 51263 | 1396 | 47231 | 2636 | 5.026 | -74.03 | 2020-11-28 05:25:50 | Cundinamarca, Colombia | ||
2020-11-26 | US | Illinois | Effingham | 17049 | 2656 | 20 | 0 | 2636 | 39.05935711 | -88.58969584 | 2020-11-27 05:26:53 | Effingham, Illinois, US |
2020-11-19 | US | Ohio | Mercer | 39107 | 2680 | 44 | 0 | 2636 | 40.54043046 | -84.62912742 | 2020-11-20 05:26:28 | Mercer, Ohio, US |
2020-11-18 | US | Nebraska | Madison | 31119 | 2650 | 14 | 0 | 2636 | 41.91676024 | -97.6005481 | 2020-11-19 05:25:23 | Madison, Nebraska, US |
2020-11-18 | US | Missouri | Newton | 29145 | 2673 | 37 | 0 | 2636 | 36.90519407 | -94.3394104 | 2020-11-19 05:25:23 | Newton, Missouri, US |
2020-11-11 | US | South Dakota | Brown | 46013 | 2644 | 8 | 0 | 2636 | 45.58994323 | -98.35165355 | 2020-11-12 05:25:55 | Brown, South Dakota, US |
2020-11-11 | US | South Carolina | Greenwood | 45047 | 2714 | 78 | 0 | 2636 | 34.15272415 | -82.12715789 | 2020-11-12 05:25:55 | Greenwood, South Carolina, US |
2020-11-07 | US | North Dakota | Stark | 38089 | 2712 | 35 | 0 | 2636 | 46.80851182 | -102.6576326 | 2020-11-08 05:24:56 | Stark, North Dakota, US |
2020-11-04 | US | Georgia | Walton | 13297 | 2710 | 74 | 0 | 2636 | 33.78017694 | -83.73552314 | 2020-11-05 06:05:03 | Walton, Georgia, US |
2020-11-03 | US | Maine | Cumberland | 23005 | 2706 | 70 | 0 | 2636 | 43.8370751 | -70.37226999 | 2020-11-04 05:25:09 | Cumberland, Maine, US |
2020-10-31 | Mexico | Durango | 14218 | 803 | 10779 | 2636 | 24.5593 | -104.6588 | 2020-11-01 04:36:19 | Durango, Mexico | ||
2020-10-22 | US | Ohio | Lorain | 39093 | 2728 | 92 | 0 | 2636 | 41.29553751 | -82.15083537 | 2020-10-23 04:24:46 | Lorain, Ohio, US |
2020-10-21 | India | Himachal Pradesh | 19621 | 279 | 16706 | 2636 | 31.927213 | 77.233081 | 2020-10-22 04:24:27 | Himachal Pradesh, India | ||
2020-10-14 | US | Virginia | Portsmouth | 51740 | 2699 | 63 | 0 | 2636 | 36.85914825 | -76.35971629 | 2020-10-15 04:24:28 | Portsmouth, Virginia, US |
2020-10-01 | US | Virginia | Harrisonburg | 51660 | 2670 | 34 | 0 | 2636 | 38.43542574 | -78.87536254 | 2020-10-02 04:23:51 | Harrisonburg, Virginia, US |
2020-09-22 | US | North Carolina | Randolph | 37151 | 2687 | 51 | 0 | 2636 | 35.71015088 | -79.80570339 | 2020-09-23 04:23:00 | Randolph, North Carolina, US |
2020-09-18 | US | Florida | Gadsden | 12039 | 2680 | 44 | 0 | 2636 | 30.57796289 | -84.61915825 | 2020-09-19 04:22:00 | Gadsden, Florida, US |
2020-09-15 | US | Georgia | Bartow | 13015 | 2713 | 77 | 0 | 2636 | 34.23732119 | -84.83887523 | 2020-09-16 04:22:53 | Bartow, Georgia, US |
2020-09-12 | US | Georgia | Floyd | 13115 | 2675 | 39 | 0 | 2636 | 34.26268279 | -85.21577392 | 2020-09-13 04:30:52 | Floyd, Georgia, US |
2020-09-11 | US | North Carolina | Buncombe | 37021 | 2708 | 72 | 0 | 2636 | 35.61113393 | -82.53305 | 2020-09-12 04:25:05 | Buncombe, North Carolina, US |
2020-09-04 | US | Ohio | Mahoning | 39099 | 2879 | 243 | 0 | 2636 | 41.01631101 | -80.77287029 | 2020-09-05 04:28:19 | Mahoning, Ohio, US |
2020-09-01 | US | Louisiana | Bossier | 22015 | 2728 | 92 | 0 | 2636 | 32.67932307 | -93.60460152 | 2020-09-02 04:28:25 | Bossier, Louisiana, US |
2020-08-26 | Maldives | 7225 | 28 | 4561 | 2636 | 3.2028 | 73.2207 | 2020-08-27 04:28:15 | Maldives | |||
2020-08-13 | US | Texas | Smith | 48423 | 1517 | 30 | 0 | 2636 | 32.37474036 | -95.2717568 | 2020-08-14 04:51:19 | Smith, Texas, US |
2020-07-26 | US | Georgia | Bibb | 13021 | 2689 | 53 | 0 | 2636 | 32.80904227 | -83.70489165 | 2020-07-27 04:35:02 | Bibb, Georgia, US |
2020-07-22 | Peru | Madre de Dios | 2721 | 85 | 0 | 2636 | -11.972699 | -70.53171999999998 | 2020-07-23 05:15:04 | Madre de Dios, Peru | ||
2020-07-03 | Costa Rica | 4311 | 18 | 1657 | 2636 | 9.7489 | -83.7534 | 2020-07-04 04:33:51 | Costa Rica | |||
2020-06-27 | US | New Jersey | Atlantic | 34001 | 2847 | 211 | 0 | 2636 | 39.47538693 | -74.65848483 | 2020-06-28 04:34:04 | Atlantic, New Jersey, US |
2020-06-19 | Russia | Kaluga Oblast | 5462 | 42 | 2784 | 2636 | 54.4382773 | 35.5272854 | 2020-06-20 04:33:19 | Kaluga Oblast, Russia | ||
2020-06-19 | US | California | San Mateo | 6081 | 2716 | 81 | 0 | 2636 | 37.422880799999994 | -122.32755459999998 | 2020-06-20 04:33:19 | San Mateo, California, US |
2020-04-10 | US | New Jersey | Morris | 34027 | 2771 | 135 | 0 | 2636 | 40.86095313 | -74.54553709999998 | 2020-04-10 22:54:07 | Morris, New Jersey, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;