johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,438 rows where active = 112 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3468306 | 3468306 | 2021-08-03 | Netherlands | Sint Maarten | 2824 | 34 | 2678 | 112 | 18.0425 | -63.0548 | 2021-08-04 04:21:25 | Sint Maarten, Netherlands | ||
3468223 | 3468223 | 2021-08-03 | Japan | Yamagata | 2200 | 47 | 2041 | 112 | 38.448396 | 140.102154 | 2021-08-04 04:21:25 | Yamagata, Japan | ||
3296182 | 3296182 | 2021-07-30 | Japan | Ehime | 2906 | 77 | 2717 | 112 | 33.624835 | 132.856842 | 2021-07-31 04:21:35 | Ehime, Japan | ||
1382139 | 1382139 | 2021-07-25 | Ukraine | Kirovohrad Oblast | 20703 | 856 | 19735 | 112 | 48.5079 | 32.2623 | 2021-07-26 04:21:28 | Kirovohrad Oblast, Ukraine | ||
3331647 | 3331647 | 2021-07-21 | Netherlands | Aruba | 11272 | 109 | 11051 | 112 | 12.5211 | -69.9683 | 2021-07-22 04:21:19 | Aruba, Netherlands | ||
483465 | 483465 | 2021-07-19 | Denmark | Faroe Islands | 933 | 1 | 820 | 112 | 61.8926 | -6.9118 | 2021-07-20 04:21:48 | Faroe Islands, Denmark | ||
295700 | 295700 | 2021-07-15 | Albania | 132629 | 2456 | 130061 | 112 | 41.1533 | 20.1683 | 2021-07-16 04:21:22 | Albania | |||
582454 | 582454 | 2021-07-13 | Ukraine | Chernivtsi Oblast | 80008 | 1794 | 78102 | 112 | 48.2917 | 25.9352 | 2021-07-14 04:21:35 | Chernivtsi Oblast, Ukraine | ||
578707 | 578707 | 2021-07-13 | Denmark | Faroe Islands | 891 | 1 | 778 | 112 | 61.8926 | -6.9118 | 2021-07-14 04:21:35 | Faroe Islands, Denmark | ||
3659609 | 3659609 | 2021-07-11 | Japan | Iwate | 1788 | 47 | 1629 | 112 | 39.593287 | 141.361777 | 2021-07-12 04:21:34 | Iwate, Japan | ||
781999 | 781999 | 2021-07-08 | Ukraine | Rivne Oblast | 79545 | 1205 | 78228 | 112 | 50.6199 | 26.2516 | 2021-07-09 04:21:21 | Rivne Oblast, Ukraine | ||
2693378 | 2693378 | 2021-07-06 | Andorra | 13991 | 127 | 13752 | 112 | 42.5063 | 1.5218 | 2021-07-07 04:21:20 | Andorra | |||
1932500 | 1932500 | 2021-07-05 | Liechtenstein | 3138 | 58 | 2968 | 112 | 47.14 | 9.55 | 2021-07-06 04:21:32 | Liechtenstein | |||
2764996 | 2764996 | 2021-07-01 | Liechtenstein | 3133 | 58 | 2963 | 112 | 47.14 | 9.55 | 2021-07-02 04:21:47 | Liechtenstein | |||
107508 | 107508 | 2021-06-19 | Laos | 2050 | 3 | 1935 | 112 | 19.85627 | 102.495496 | 2021-06-20 04:21:48 | Laos | |||
107468 | 107468 | 2021-06-19 | Japan | Kagoshima | 3632 | 34 | 3486 | 112 | 31.009484000000004 | 130.430665 | 2021-06-20 04:21:48 | Kagoshima, Japan | ||
107309 | 107309 | 2021-06-19 | Colombia | San Andres y Providencia | 6155 | 121 | 5922 | 112 | 12.5567 | -81.7185 | 2021-06-20 04:21:48 | San Andres y Providencia, Colombia | ||
1125851 | 1125851 | 2021-06-18 | Russia | Tyva Republic | 16085 | 203 | 15770 | 112 | 51.4017149 | 93.8582593 | 2021-06-19 04:22:33 | Tyva Republic, Russia | ||
1125622 | 1125622 | 2021-06-18 | Japan | Niigata | 3383 | 47 | 3224 | 112 | 37.521819 | 138.918647 | 2021-06-19 04:22:33 | Niigata, Japan | ||
1564155 | 1564155 | 2021-06-14 | Liechtenstein | 3118 | 58 | 2948 | 112 | 47.14 | 9.55 | 2021-06-15 04:22:22 | Liechtenstein | |||
3381438 | 3381438 | 2021-06-13 | Liechtenstein | 3118 | 58 | 2948 | 112 | 47.14 | 9.55 | 2021-06-14 04:22:46 | Liechtenstein | |||
1736572 | 1736572 | 2021-06-12 | Liechtenstein | 3118 | 58 | 2948 | 112 | 47.14 | 9.55 | 2021-06-13 04:22:44 | Liechtenstein | |||
3970547 | 3970547 | 2021-06-11 | Italy | Valle d'Aosta | 11653 | 472 | 11069 | 112 | 45.73750286 | 7.320149366 | 2021-06-12 04:22:22 | Valle d'Aosta, Italy | ||
522920 | 522920 | 2021-06-09 | Liechtenstein | 3114 | 57 | 2945 | 112 | 47.14 | 9.55 | 2021-06-10 04:23:17 | Liechtenstein | |||
3472360 | 3472360 | 2021-06-08 | Liechtenstein | 3113 | 57 | 2944 | 112 | 47.14 | 9.55 | 2021-06-09 04:23:31 | Liechtenstein | |||
3145608 | 3145608 | 2021-06-07 | Japan | Nara | 7890 | 119 | 7659 | 112 | 34.317451 | 135.871644 | 2021-06-08 04:22:35 | Nara, Japan | ||
3145349 | 3145349 | 2021-06-07 | Canada | New Brunswick | 2266 | 44 | 2110 | 112 | 46.5653 | -66.4619 | 2021-06-08 04:22:35 | New Brunswick, Canada | ||
2315245 | 2315245 | 2021-06-04 | India | Dadra and Nagar Haveli and Daman and Diu | 10377 | 4 | 10261 | 112 | 20.194742 | 73.080901 | 2021-06-05 04:23:03 | Dadra and Nagar Haveli and Daman and Diu, India | ||
2104192 | 2104192 | 2021-06-01 | Liechtenstein | 3103 | 57 | 2934 | 112 | 47.14 | 9.55 | 2021-06-02 04:24:34 | Liechtenstein | |||
20433 | 20433 | 2021-05-28 | Liechtenstein | 3098 | 57 | 2929 | 112 | 47.14 | 9.55 | 2021-05-29 04:20:41 | Liechtenstein | |||
1806888 | 1806888 | 2021-05-27 | Pakistan | Gilgit-Baltistan | 5545 | 107 | 5326 | 112 | 35.792146 | 74.982138 | 2021-05-28 04:20:36 | Gilgit-Baltistan, Pakistan | ||
1310173 | 1310173 | 2021-05-26 | Japan | Ehime | 2688 | 72 | 2504 | 112 | 33.624835 | 132.856842 | 2021-05-27 04:20:59 | Ehime, Japan | ||
2394459 | 2394459 | 2021-05-18 | Malaysia | W.P. Putrajaya | 1561 | 10 | 1439 | 112 | 2.9264 | 101.6964 | 2021-05-19 04:20:42 | W.P. Putrajaya, Malaysia | ||
3578284 | 3578284 | 2021-05-17 | Malaysia | W.P. Putrajaya | 1552 | 10 | 1430 | 112 | 2.9264 | 101.6964 | 2021-05-18 04:20:33 | W.P. Putrajaya, Malaysia | ||
2820913 | 2820913 | 2021-05-10 | Pakistan | Gilgit-Baltistan | 5401 | 107 | 5182 | 112 | 35.792146 | 74.982138 | 2021-05-11 04:20:41 | Gilgit-Baltistan, Pakistan | ||
1428791 | 1428791 | 2021-05-09 | Malaysia | W.P. Putrajaya | 1459 | 9 | 1338 | 112 | 2.9264 | 101.6964 | 2021-05-10 04:20:38 | W.P. Putrajaya, Malaysia | ||
3113627 | 3113627 | 2021-05-06 | Pakistan | Gilgit-Baltistan | 5358 | 107 | 5139 | 112 | 35.792146 | 74.982138 | 2021-05-07 04:20:40 | Gilgit-Baltistan, Pakistan | ||
3675657 | 3675657 | 2021-05-04 | Japan | Fukui | 910 | 33 | 765 | 112 | 35.846614 | 136.22465400000002 | 2021-05-05 04:20:43 | Fukui, Japan | ||
2760641 | 2760641 | 2021-05-03 | Belize | 12674 | 323 | 12239 | 112 | 17.1899 | -88.4976 | 2021-05-04 04:20:34 | Belize | |||
379917 | 379917 | 2021-04-30 | Bhutan | 1074 | 1 | 961 | 112 | 27.5142 | 90.4336 | 2021-05-01 04:20:47 | Bhutan | |||
1567828 | 1567828 | 2021-04-22 | Belize | 12596 | 320 | 12164 | 112 | 17.1899 | -88.4976 | 2021-04-23 04:20:52 | Belize | |||
2020757 | 2020757 | 2021-04-20 | Japan | Saga | 1390 | 13 | 1265 | 112 | 33.286977 | 130.115738 | 2021-04-21 04:21:14 | Saga, Japan | ||
1842211 | 1842211 | 2021-04-14 | Saint Lucia | 4355 | 64 | 4179 | 112 | 13.9094 | -60.9789 | 2021-04-15 04:20:54 | Saint Lucia | |||
2571945 | 2571945 | 2021-04-13 | Saint Lucia | 4355 | 64 | 4179 | 112 | 13.9094 | -60.9789 | 2021-04-14 04:20:41 | Saint Lucia | |||
36696 | 36696 | 2021-04-12 | Saint Lucia | 4355 | 64 | 4179 | 112 | 13.9094 | -60.9789 | 2021-04-13 04:20:37 | Saint Lucia | |||
3003149 | 3003149 | 2021-04-06 | Colombia | Choco | 6798 | 205 | 6481 | 112 | 5.2528 | -76.82600000000002 | 2021-04-07 04:20:53 | Choco, Colombia | ||
3710161 | 3710161 | 2021-04-03 | Japan | Mie | 2825 | 71 | 2642 | 112 | 34.508018 | 136.376013 | 2021-04-04 04:20:49 | Mie, Japan | ||
1302062 | 1302062 | 2021-04-01 | Japan | Hiroshima | 5182 | 106 | 4964 | 112 | 34.605309000000005 | 132.788719 | 2021-04-02 04:20:36 | Hiroshima, Japan | ||
637884 | 637884 | 2021-03-31 | India | Nagaland | 12340 | 92 | 12136 | 112 | 26.06702 | 94.470302 | 2021-04-01 04:27:05 | Nagaland, India | ||
1290039 | 1290039 | 2021-03-29 | Japan | Port Quarantine | 2384 | 3 | 2269 | 112 | 2021-03-30 04:26:23 | Port Quarantine, Japan | ||||
1880820 | 1880820 | 2021-03-26 | Colombia | Arauca | 5709 | 173 | 5424 | 112 | 7.0762 | -70.7105 | 2021-03-27 05:25:04 | Arauca, Colombia | ||
702435 | 702435 | 2021-03-16 | Japan | Okayama | 2588 | 35 | 2441 | 112 | 34.89246 | 133.826252 | 2021-03-17 05:25:07 | Okayama, Japan | ||
702150 | 702150 | 2021-03-16 | Brazil | Piaui | 187960 | 3697 | 183111 | 112 | -7.7183 | -42.7289 | 2021-03-17 05:25:07 | Piaui, Brazil | ||
1732830 | 1732830 | 2021-03-14 | Trinidad and Tobago | 7783 | 140 | 7531 | 112 | 10.6918 | -61.2225 | 2021-03-15 05:25:51 | Trinidad and Tobago | |||
2363152 | 2363152 | 2021-03-08 | Malaysia | Terengganu | 3296 | 11 | 3173 | 112 | 5.3117 | 103.1324 | 2021-03-09 05:28:19 | Terengganu, Malaysia | ||
54923 | 54923 | 2021-03-07 | Netherlands | Curacao | 4807 | 22 | 4673 | 112 | 12.1696 | -68.99 | 2021-03-08 05:24:48 | Curacao, Netherlands | ||
3669651 | 3669651 | 2021-03-06 | US | Montana | Wibaux | 30109 | 118 | 6 | 0 | 112 | 46.95925154 | -104.2510927 | 2021-03-07 05:21:54 | Wibaux, Montana, US |
3667898 | 3667898 | 2021-03-06 | Singapore | 60020 | 29 | 59879 | 112 | 1.2833 | 103.8333 | 2021-03-07 05:21:54 | Singapore | |||
1619361 | 1619361 | 2021-03-05 | US | Texas | Irion | 48235 | 109 | 1 | 0 | 112 | 31.30375559 | -100.982439 | 2021-03-06 04:23:41 | Irion, Texas, US |
1618272 | 1618272 | 2021-03-05 | US | Montana | Wibaux | 30109 | 118 | 6 | 0 | 112 | 46.95925154 | -104.2510927 | 2021-03-06 04:23:41 | Wibaux, Montana, US |
2210772 | 2210772 | 2021-03-04 | US | Texas | Irion | 48235 | 109 | 1 | 0 | 112 | 31.30375559 | -100.982439 | 2021-03-05 05:26:29 | Irion, Texas, US |
2209683 | 2209683 | 2021-03-04 | US | Montana | Wibaux | 30109 | 118 | 6 | 0 | 112 | 46.95925154 | -104.2510927 | 2021-03-05 05:26:29 | Wibaux, Montana, US |
2207930 | 2207930 | 2021-03-04 | Singapore | 59998 | 29 | 59857 | 112 | 1.2833 | 103.8333 | 2021-03-05 05:26:29 | Singapore | |||
1092104 | 1092104 | 2021-03-03 | US | Montana | Wibaux | 30109 | 118 | 6 | 0 | 112 | 46.95925154 | -104.2510927 | 2021-03-04 05:24:24 | Wibaux, Montana, US |
3256176 | 3256176 | 2021-03-02 | US | Montana | Wibaux | 30109 | 118 | 6 | 0 | 112 | 46.95925154 | -104.2510927 | 2021-03-03 05:23:28 | Wibaux, Montana, US |
3066867 | 3066867 | 2021-02-27 | US | Georgia | Taliaferro | 13265 | 114 | 2 | 0 | 112 | 33.56543317 | -82.88136816 | 2021-02-28 05:22:20 | Taliaferro, Georgia, US |
2186362 | 2186362 | 2021-02-26 | US | Puerto Rico | Vieques | 72147 | 112 | 0 | 0 | 112 | 18.123276 | -65.44097099999999 | 2021-02-27 05:22:28 | Vieques, Puerto Rico, US |
2184451 | 2184451 | 2021-02-26 | US | Georgia | Taliaferro | 13265 | 114 | 2 | 0 | 112 | 33.56543317 | -82.88136816 | 2021-02-27 05:22:28 | Taliaferro, Georgia, US |
1860784 | 1860784 | 2021-02-25 | US | Puerto Rico | Vieques | 72147 | 112 | 0 | 0 | 112 | 18.123276 | -65.44097099999999 | 2021-02-26 05:22:40 | Vieques, Puerto Rico, US |
1860034 | 1860034 | 2021-02-25 | US | Montana | Wibaux | 30109 | 117 | 5 | 0 | 112 | 46.95925154 | -104.2510927 | 2021-02-26 05:22:40 | Wibaux, Montana, US |
1858873 | 1858873 | 2021-02-25 | US | Georgia | Taliaferro | 13265 | 114 | 2 | 0 | 112 | 33.56543317 | -82.88136816 | 2021-02-26 05:22:40 | Taliaferro, Georgia, US |
282962 | 282962 | 2021-02-24 | US | Puerto Rico | Vieques | 72147 | 112 | 0 | 0 | 112 | 18.123276 | -65.44097099999999 | 2021-02-25 05:24:57 | Vieques, Puerto Rico, US |
282212 | 282212 | 2021-02-24 | US | Montana | Wibaux | 30109 | 117 | 5 | 0 | 112 | 46.95925154 | -104.2510927 | 2021-02-25 05:24:57 | Wibaux, Montana, US |
281051 | 281051 | 2021-02-24 | US | Georgia | Taliaferro | 13265 | 114 | 2 | 0 | 112 | 33.56543317 | -82.88136816 | 2021-02-25 05:24:57 | Taliaferro, Georgia, US |
1939882 | 1939882 | 2021-02-23 | US | Washington | Garfield | 53023 | 116 | 4 | 0 | 112 | 46.43197502 | -117.5454032 | 2021-02-24 05:29:16 | Garfield, Washington, US |
1939230 | 1939230 | 2021-02-23 | US | Puerto Rico | Vieques | 72147 | 112 | 0 | 0 | 112 | 18.123276 | -65.44097099999999 | 2021-02-24 05:29:16 | Vieques, Puerto Rico, US |
1938480 | 1938480 | 2021-02-23 | US | Montana | Wibaux | 30109 | 117 | 5 | 0 | 112 | 46.95925154 | -104.2510927 | 2021-02-24 05:29:16 | Wibaux, Montana, US |
1937319 | 1937319 | 2021-02-23 | US | Georgia | Taliaferro | 13265 | 114 | 2 | 0 | 112 | 33.56543317 | -82.88136816 | 2021-02-24 05:29:16 | Taliaferro, Georgia, US |
1936474 | 1936474 | 2021-02-23 | Japan | Miyagi | 3575 | 25 | 3438 | 112 | 38.446859 | 140.927086 | 2021-02-24 05:29:16 | Miyagi, Japan | ||
533485 | 533485 | 2021-02-22 | US | Puerto Rico | Vieques | 72147 | 112 | 0 | 0 | 112 | 18.123276 | -65.44097099999999 | 2021-02-23 05:23:41 | Vieques, Puerto Rico, US |
532735 | 532735 | 2021-02-22 | US | Montana | Wibaux | 30109 | 117 | 5 | 0 | 112 | 46.95925154 | -104.2510927 | 2021-02-23 05:23:41 | Wibaux, Montana, US |
531574 | 531574 | 2021-02-22 | US | Georgia | Taliaferro | 13265 | 114 | 2 | 0 | 112 | 33.56543317 | -82.88136816 | 2021-02-23 05:23:41 | Taliaferro, Georgia, US |
184819 | 184819 | 2021-02-21 | US | Puerto Rico | Vieques | 72147 | 112 | 0 | 0 | 112 | 18.123276 | -65.44097099999999 | 2021-02-22 05:24:21 | Vieques, Puerto Rico, US |
184069 | 184069 | 2021-02-21 | US | Montana | Wibaux | 30109 | 117 | 5 | 0 | 112 | 46.95925154 | -104.2510927 | 2021-02-22 05:24:21 | Wibaux, Montana, US |
745093 | 745093 | 2021-02-20 | US | Puerto Rico | Vieques | 72147 | 112 | 0 | 0 | 112 | 18.123276 | -65.44097099999999 | 2021-02-21 05:24:33 | Vieques, Puerto Rico, US |
744343 | 744343 | 2021-02-20 | US | Montana | Wibaux | 30109 | 117 | 5 | 0 | 112 | 46.95925154 | -104.2510927 | 2021-02-21 05:24:33 | Wibaux, Montana, US |
743182 | 743182 | 2021-02-20 | US | Georgia | Taliaferro | 13265 | 113 | 1 | 0 | 112 | 33.56543317 | -82.88136816 | 2021-02-21 05:24:33 | Taliaferro, Georgia, US |
474191 | 474191 | 2021-02-19 | US | Puerto Rico | Vieques | 72147 | 112 | 0 | 0 | 112 | 18.123276 | -65.44097099999999 | 2021-02-20 05:22:51 | Vieques, Puerto Rico, US |
473441 | 473441 | 2021-02-19 | US | Montana | Wibaux | 30109 | 117 | 5 | 0 | 112 | 46.95925154 | -104.2510927 | 2021-02-20 05:22:51 | Wibaux, Montana, US |
472280 | 472280 | 2021-02-19 | US | Georgia | Taliaferro | 13265 | 113 | 1 | 0 | 112 | 33.56543317 | -82.88136816 | 2021-02-20 05:22:51 | Taliaferro, Georgia, US |
1155900 | 1155900 | 2021-02-18 | US | Puerto Rico | Vieques | 72147 | 112 | 0 | 0 | 112 | 18.123276 | -65.44097099999999 | 2021-02-19 05:24:16 | Vieques, Puerto Rico, US |
1153989 | 1153989 | 2021-02-18 | US | Georgia | Taliaferro | 13265 | 113 | 1 | 0 | 112 | 33.56543317 | -82.88136816 | 2021-02-19 05:24:16 | Taliaferro, Georgia, US |
1152890 | 1152890 | 2021-02-18 | Canada | New Brunswick | 1411 | 24 | 1275 | 112 | 46.5653 | -66.4619 | 2021-02-19 05:24:16 | New Brunswick, Canada | ||
3603820 | 3603820 | 2021-02-17 | US | Puerto Rico | Vieques | 72147 | 112 | 0 | 0 | 112 | 18.123276 | -65.44097099999999 | 2021-02-18 05:22:58 | Vieques, Puerto Rico, US |
3052955 | 3052955 | 2021-02-16 | US | Puerto Rico | Vieques | 72147 | 112 | 0 | 0 | 112 | 18.123276 | -65.44097099999999 | 2021-02-17 05:23:10 | Vieques, Puerto Rico, US |
1341054 | 1341054 | 2021-02-15 | US | Puerto Rico | Vieques | 72147 | 112 | 0 | 0 | 112 | 18.123276 | -65.44097099999999 | 2021-02-16 05:24:38 | Vieques, Puerto Rico, US |
2286205 | 2286205 | 2021-02-14 | US | Puerto Rico | Vieques | 72147 | 112 | 0 | 0 | 112 | 18.123276 | -65.44097099999999 | 2021-02-15 05:24:49 | Vieques, Puerto Rico, US |
2285425 | 2285425 | 2021-02-14 | US | Montana | Liberty | 30051 | 113 | 1 | 0 | 112 | 48.56084317 | -111.024307 | 2021-02-15 05:24:49 | Liberty, Montana, US |
2680605 | 2680605 | 2021-02-13 | US | Puerto Rico | Vieques | 72147 | 112 | 0 | 0 | 112 | 18.123276 | -65.44097099999999 | 2021-02-14 05:23:43 | Vieques, Puerto Rico, US |
3543148 | 3543148 | 2021-02-12 | Malaysia | W.P. Putrajaya | 989 | 7 | 870 | 112 | 2.9264 | 101.6964 | 2021-02-13 05:22:12 | W.P. Putrajaya, Malaysia |
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]);