johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
577 rows where active = 401 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3683391 | 3683391 | 2021-08-02 | India | Bihar | 724917 | 9644 | 714872 | 401 | 25.679658 | 85.60484 | 2021-08-03 04:21:39 | Bihar, India | ||
3389009 | 3389009 | 2021-07-29 | Ukraine | Cherkasy Oblast | 82184 | 1321 | 80462 | 401 | 49.4444 | 32.0598 | 2021-07-30 04:21:34 | Cherkasy Oblast, Ukraine | ||
3385528 | 3385528 | 2021-07-29 | North Macedonia | 156225 | 5491 | 150333 | 401 | 41.6086 | 21.7453 | 2021-07-30 04:21:34 | North Macedonia | |||
1378357 | 1378357 | 2021-07-25 | Colombia | La Guajira | 41191 | 1290 | 39500 | 401 | 11.3548 | -72.5205 | 2021-07-26 04:21:28 | La Guajira, Colombia | ||
3137406 | 3137406 | 2021-07-23 | Colombia | Putumayo | 14925 | 604 | 13920 | 401 | 0.436 | -75.5277 | 2021-07-24 00:21:36 | Putumayo, Colombia | ||
3476166 | 3476166 | 2021-07-22 | Colombia | Putumayo | 14925 | 604 | 13920 | 401 | 0.436 | -75.5277 | 2021-07-23 04:21:29 | Putumayo, Colombia | ||
3331317 | 3331317 | 2021-07-21 | Chile | Coquimbo | 47108 | 897 | 45810 | 401 | -29.959 | -71.3389 | 2021-07-22 04:21:19 | Coquimbo, Chile | ||
2673826 | 2673826 | 2021-07-18 | Japan | Ibaraki | 11117 | 166 | 10550 | 401 | 36.303588 | 140.319591 | 2021-07-19 04:21:24 | Ibaraki, Japan | ||
778205 | 778205 | 2021-07-08 | Colombia | Choco | 15002 | 357 | 14244 | 401 | 5.2528 | -76.82600000000002 | 2021-07-09 04:21:21 | Choco, Colombia | ||
2694026 | 2694026 | 2021-07-06 | Togo | 14105 | 132 | 13572 | 401 | 8.6195 | 0.8248 | 2021-07-07 04:21:20 | Togo | |||
1932636 | 1932636 | 2021-07-05 | Russia | Ingushetia Republic | 16330 | 197 | 15732 | 401 | 43.11542075 | 45.01713552 | 2021-07-06 04:21:32 | Ingushetia Republic, Russia | ||
2768568 | 2768568 | 2021-07-01 | Ukraine | Mykolaiv Oblast | 69964 | 1846 | 67717 | 401 | 46.975 | 31.9946 | 2021-07-02 04:21:47 | Mykolaiv Oblast, Ukraine | ||
2104358 | 2104358 | 2021-06-01 | Russia | North Ossetia - Alania Republic | 17012 | 214 | 16397 | 401 | 42.79336110000001 | 44.6324493 | 2021-06-02 04:24:34 | North Ossetia - Alania Republic, Russia | ||
2451048 | 2451048 | 2021-05-02 | Singapore | 61218 | 31 | 60786 | 401 | 1.2833 | 103.8333 | 2021-05-03 04:20:39 | Singapore | |||
3702115 | 3702115 | 2021-04-27 | Japan | Ehime | 2241 | 33 | 1807 | 401 | 33.624835 | 132.856842 | 2021-04-28 04:20:32 | Ehime, Japan | ||
36220 | 36220 | 2021-04-12 | Chile | Magallanes | 23698 | 361 | 22936 | 401 | -52.368 | -70.9863 | 2021-04-13 04:20:37 | Magallanes, Chile | ||
3713816 | 3713816 | 2021-04-03 | Malaysia | Negeri Sembilan | 17359 | 31 | 16927 | 401 | 2.7258 | 101.9424 | 2021-04-04 04:20:49 | Negeri Sembilan, Malaysia | ||
1802318 | 1802318 | 2021-03-23 | Malaysia | Perak | 12711 | 44 | 12266 | 401 | 4.5921 | 101.0901 | 2021-03-24 05:25:40 | Perak, Malaysia | ||
1736128 | 1736128 | 2021-03-14 | Ukraine | Sevastopol* | 12608 | 533 | 11674 | 401 | 44.6054 | 33.522 | 2021-03-15 05:25:51 | Sevastopol*, Ukraine | ||
3669705 | 3669705 | 2021-03-06 | US | Nebraska | Kimball | 31105 | 409 | 8 | 0 | 401 | 41.19774275 | -103.7148131 | 2021-03-07 05:21:54 | Kimball, Nebraska, US |
3667634 | 3667634 | 2021-03-06 | Japan | Hyogo | 18144 | 557 | 17186 | 401 | 35.039913 | 134.828057 | 2021-03-07 05:21:54 | Hyogo, Japan | ||
2209737 | 2209737 | 2021-03-04 | US | Nebraska | Kimball | 31105 | 409 | 8 | 0 | 401 | 41.19774275 | -103.7148131 | 2021-03-05 05:26:29 | Kimball, Nebraska, US |
3256230 | 3256230 | 2021-03-02 | US | Nebraska | Kimball | 31105 | 409 | 8 | 0 | 401 | 41.19774275 | -103.7148131 | 2021-03-03 05:23:28 | Kimball, Nebraska, US |
3254359 | 3254359 | 2021-03-02 | Russia | Komi Republic | 39596 | 753 | 38442 | 401 | 63.9881421 | 54.3326073 | 2021-03-03 05:23:28 | Komi Republic, Russia | ||
2370264 | 2370264 | 2021-02-28 | US | Puerto Rico | San German | 72125 | 401 | 0 | 0 | 401 | 18.111484 | -67.03858100000001 | 2021-03-01 05:23:01 | San German, Puerto Rico, US |
2367709 | 2367709 | 2021-02-28 | Russia | Komi Republic | 39437 | 753 | 38283 | 401 | 63.9881421 | 54.3326073 | 2021-03-01 05:23:01 | Komi Republic, Russia | ||
282160 | 282160 | 2021-02-24 | US | Montana | Broadwater | 30007 | 406 | 5 | 0 | 401 | 46.33277565 | -111.4955813 | 2021-02-25 05:24:57 | Broadwater, Montana, US |
1939723 | 1939723 | 2021-02-23 | US | Vermont | Caledonia | 50005 | 406 | 5 | 0 | 401 | 44.46548598 | -72.10314651 | 2021-02-24 05:29:16 | Caledonia, Vermont, US |
1938428 | 1938428 | 2021-02-23 | US | Montana | Broadwater | 30007 | 406 | 5 | 0 | 401 | 46.33277565 | -111.4955813 | 2021-02-24 05:29:16 | Broadwater, Montana, US |
533311 | 533311 | 2021-02-22 | US | Oregon | Curry | 41015 | 407 | 6 | 0 | 401 | 42.45911325 | -124.157282 | 2021-02-23 05:23:41 | Curry, Oregon, US |
184666 | 184666 | 2021-02-21 | US | Oregon | Tillamook | 41057 | 403 | 2 | 0 | 401 | 45.46248721 | -123.712066 | 2021-02-22 05:24:21 | Tillamook, Oregon, US |
184588 | 184588 | 2021-02-21 | US | Oklahoma | Harper | 40059 | 405 | 4 | 0 | 401 | 36.78836519 | -99.6679804 | 2021-02-22 05:24:21 | Harper, Oklahoma, US |
744940 | 744940 | 2021-02-20 | US | Oregon | Tillamook | 41057 | 403 | 2 | 0 | 401 | 45.46248721 | -123.712066 | 2021-02-21 05:24:33 | Tillamook, Oregon, US |
3051775 | 3051775 | 2021-02-16 | US | Michigan | Alcona | 26001 | 425 | 24 | 0 | 401 | 44.6846864 | -83.59507875 | 2021-02-17 05:23:10 | Alcona, Michigan, US |
2283237 | 2283237 | 2021-02-14 | China | Hong Kong | 10779 | 193 | 10185 | 401 | 22.3 | 114.2 | 2021-02-15 05:24:49 | Hong Kong, China | ||
3980773 | 3980773 | 2021-02-10 | US | New Mexico | Quay | 35037 | 409 | 8 | 0 | 401 | 35.10403332 | -103.5481727 | 2021-02-11 05:23:55 | Quay, New Mexico, US |
1530093 | 1530093 | 2021-02-09 | US | New Mexico | Quay | 35037 | 409 | 8 | 0 | 401 | 35.10403332 | -103.5481727 | 2021-02-10 05:22:41 | Quay, New Mexico, US |
1675217 | 1675217 | 2021-02-07 | US | Puerto Rico | Penuelas | 72111 | 401 | 0 | 0 | 401 | 18.059645 | -66.721572 | 2021-02-08 05:22:39 | Penuelas, Puerto Rico, US |
1673931 | 1673931 | 2021-02-07 | US | Kentucky | Wolfe | 21237 | 405 | 4 | 0 | 401 | 37.73941626 | -83.49303612 | 2021-02-08 05:22:39 | Wolfe, Kentucky, US |
342152 | 342152 | 2021-02-03 | US | Missouri | Chariton | 29041 | 404 | 3 | 0 | 401 | 39.51499357 | -92.9629191 | 2021-02-04 05:22:26 | Chariton, Missouri, US |
1686378 | 1686378 | 2021-02-02 | US | Missouri | Chariton | 29041 | 404 | 3 | 0 | 401 | 39.51499357 | -92.9629191 | 2021-02-03 05:22:52 | Chariton, Missouri, US |
1685368 | 1685368 | 2021-02-02 | US | Georgia | Talbot | 13263 | 414 | 13 | 0 | 401 | 32.69642758 | -84.53351366 | 2021-02-03 05:22:52 | Talbot, Georgia, US |
1678348 | 1678348 | 2021-02-01 | US | Missouri | Chariton | 29041 | 404 | 3 | 0 | 401 | 39.51499357 | -92.9629191 | 2021-02-02 05:22:49 | Chariton, Missouri, US |
1678345 | 1678345 | 2021-02-01 | US | Missouri | Carter | 29035 | 409 | 8 | 0 | 401 | 36.94160441 | -90.96051322 | 2021-02-02 05:22:49 | Carter, Missouri, US |
1677070 | 1677070 | 2021-02-01 | US | Colorado | Conejos | 8021 | 421 | 6 | 0 | 401 | 37.201606 | -106.19174879999998 | 2021-02-02 05:22:49 | Conejos, Colorado, US |
1463227 | 1463227 | 2021-01-31 | US | West Virginia | Doddridge | 54017 | 406 | 5 | 0 | 401 | 39.27057157 | -80.70671527 | 2021-02-01 05:22:53 | Doddridge, West Virginia, US |
1461633 | 1461633 | 2021-01-31 | US | Missouri | Carter | 29035 | 409 | 8 | 0 | 401 | 36.94160441 | -90.96051322 | 2021-02-01 05:22:53 | Carter, Missouri, US |
1899028 | 1899028 | 2021-01-29 | US | Missouri | Carter | 29035 | 409 | 8 | 0 | 401 | 36.94160441 | -90.96051322 | 2021-01-30 05:22:49 | Carter, Missouri, US |
1898395 | 1898395 | 2021-01-29 | US | Iowa | Wayne | 19185 | 422 | 21 | 0 | 401 | 40.73969028 | -93.32752197 | 2021-01-30 05:22:49 | Wayne, Iowa, US |
1897004 | 1897004 | 2021-01-29 | Colombia | La Guajira | 15566 | 592 | 14573 | 401 | 11.3548 | -72.5205 | 2021-01-30 05:22:49 | La Guajira, Colombia | ||
2483844 | 2483844 | 2021-01-28 | US | Missouri | Carter | 29035 | 409 | 8 | 0 | 401 | 36.94160441 | -90.96051322 | 2021-01-29 05:22:23 | Carter, Missouri, US |
2483211 | 2483211 | 2021-01-28 | US | Iowa | Wayne | 19185 | 422 | 21 | 0 | 401 | 40.73969028 | -93.32752197 | 2021-01-29 05:22:23 | Wayne, Iowa, US |
3154846 | 3154846 | 2021-01-27 | US | Iowa | Wayne | 19185 | 422 | 21 | 0 | 401 | 40.73969028 | -93.32752197 | 2021-01-28 05:22:24 | Wayne, Iowa, US |
3154557 | 3154557 | 2021-01-27 | US | Illinois | Alexander | 17003 | 409 | 8 | 0 | 401 | 37.18049267 | -89.32910838 | 2021-01-28 05:22:24 | Alexander, Illinois, US |
3153652 | 3153652 | 2021-01-27 | Japan | Yamaguchi | 1169 | 12 | 756 | 401 | 34.201190000000004 | 131.573293 | 2021-01-28 05:22:24 | Yamaguchi, Japan | ||
2570521 | 2570521 | 2021-01-25 | US | South Dakota | Douglas | 46043 | 410 | 9 | 0 | 401 | 43.38520741 | -98.36978007 | 2021-01-26 05:22:02 | Douglas, South Dakota, US |
1762660 | 1762660 | 2021-01-24 | US | Virginia | Mathews | 51115 | 407 | 6 | 0 | 401 | 37.44164146 | -76.34098896 | 2021-01-25 05:22:16 | Mathews, Virginia, US |
1762153 | 1762153 | 2021-01-24 | US | South Dakota | Douglas | 46043 | 410 | 9 | 0 | 401 | 43.38520741 | -98.36978007 | 2021-01-25 05:22:16 | Douglas, South Dakota, US |
2429760 | 2429760 | 2021-01-23 | US | South Dakota | Douglas | 46043 | 410 | 9 | 0 | 401 | 43.38520741 | -98.36978007 | 2021-01-24 05:22:35 | Douglas, South Dakota, US |
2426925 | 2426925 | 2021-01-23 | Japan | Mie | 1976 | 28 | 1547 | 401 | 34.508018 | 136.376013 | 2021-01-24 05:22:35 | Mie, Japan | ||
2466528 | 2466528 | 2021-01-22 | Belize | 11700 | 290 | 11009 | 401 | 17.1899 | -88.4976 | 2021-01-23 05:22:03 | Belize | |||
437467 | 437467 | 2021-01-21 | US | Nebraska | Sheridan | 31161 | 414 | 13 | 0 | 401 | 42.50284406 | -102.4126613 | 2021-01-22 05:22:10 | Sheridan, Nebraska, US |
1097447 | 1097447 | 2021-01-20 | US | Virginia | Madison | 51113 | 406 | 5 | 0 | 401 | 38.41531222 | -78.28220331 | 2021-01-21 05:22:01 | Madison, Virginia, US |
1097024 | 1097024 | 2021-01-20 | US | Tennessee | Hancock | 47067 | 446 | 6 | 0 | 401 | 36.52692871 | -83.22375847 | 2021-01-21 05:22:01 | Hancock, Tennessee, US |
1094919 | 1094919 | 2021-01-20 | US | Georgia | Marion | 13197 | 411 | 10 | 0 | 401 | 32.3483402 | -84.52733571 | 2021-01-21 05:22:01 | Marion, Georgia, US |
911680 | 911680 | 2021-01-19 | US | West Virginia | Roane | 54087 | 407 | 6 | 0 | 401 | 38.71622686 | -81.35243568 | 2021-01-20 05:21:54 | Roane, West Virginia, US |
908963 | 908963 | 2021-01-19 | US | Georgia | Echols | 13101 | 406 | 5 | 0 | 401 | 30.71101099 | -82.89687287 | 2021-01-20 05:21:54 | Echols, Georgia, US |
238026 | 238026 | 2021-01-18 | US | Georgia | Echols | 13101 | 405 | 4 | 0 | 401 | 30.71101099 | -82.89687287 | 2021-01-19 05:22:15 | Echols, Georgia, US |
3103168 | 3103168 | 2021-01-16 | US | Minnesota | Mahnomen | 27087 | 408 | 7 | 0 | 401 | 47.32557075 | -95.80921485 | 2021-01-17 05:22:17 | Mahnomen, Minnesota, US |
3883080 | 3883080 | 2021-01-14 | US | West Virginia | Tucker | 54093 | 405 | 4 | 0 | 401 | 39.11240885 | -79.57053576 | 2021-01-15 05:22:24 | Tucker, West Virginia, US |
3882001 | 3882001 | 2021-01-14 | US | North Dakota | Wells | 38103 | 409 | 8 | 0 | 401 | 47.58614526 | -99.65904998 | 2021-01-15 05:22:24 | Wells, North Dakota, US |
3311707 | 3311707 | 2021-01-13 | US | West Virginia | Tucker | 54093 | 405 | 4 | 0 | 401 | 39.11240885 | -79.57053576 | 2021-01-14 05:22:32 | Tucker, West Virginia, US |
3310628 | 3310628 | 2021-01-13 | US | North Dakota | Wells | 38103 | 407 | 8 | 0 | 401 | 47.58614526 | -99.65904998 | 2021-01-14 05:22:32 | Wells, North Dakota, US |
3308532 | 3308532 | 2021-01-13 | Tajikistan | 13710 | 91 | 13218 | 401 | 38.861 | 71.2761 | 2021-01-14 05:22:32 | Tajikistan | |||
192048 | 192048 | 2021-01-11 | US | Montana | Chouteau | 30015 | 406 | 5 | 0 | 401 | 47.88084126 | -110.4353362 | 2021-01-12 05:22:15 | Chouteau, Montana, US |
2626201 | 2626201 | 2021-01-10 | Tajikistan | 13707 | 91 | 13215 | 401 | 38.861 | 71.2761 | 2021-01-11 05:21:50 | Tajikistan | |||
3902268 | 3902268 | 2021-01-09 | US | North Carolina | Gates | 37073 | 413 | 12 | 0 | 401 | 36.44667547 | -76.69749701 | 2021-01-10 05:22:12 | Gates, North Carolina, US |
157224 | 157224 | 2021-01-08 | US | Texas | Wheeler | 48483 | 509 | 9 | 0 | 401 | 35.40114335 | -100.2699514 | 2021-01-09 05:22:18 | Wheeler, Texas, US |
155529 | 155529 | 2021-01-08 | US | Maine | Knox | 23013 | 405 | 4 | 0 | 401 | 44.11486325 | -69.10529169 | 2021-01-09 05:22:18 | Knox, Maine, US |
2544446 | 2544446 | 2021-01-07 | US | Texas | Coke | 48081 | 338 | 10 | 0 | 401 | 31.88911733 | -100.5297533 | 2021-01-08 05:22:42 | Coke, Texas, US |
2543547 | 2543547 | 2021-01-07 | US | Nevada | White Pine | 32033 | 404 | 3 | 0 | 401 | 39.44157041 | -114.899966 | 2021-01-08 05:22:42 | White Pine, Nevada, US |
2866856 | 2866856 | 2021-01-06 | US | Nevada | White Pine | 32033 | 404 | 3 | 0 | 401 | 39.44157041 | -114.899966 | 2021-01-07 05:22:03 | White Pine, Nevada, US |
2866425 | 2866425 | 2021-01-06 | US | Minnesota | Grant | 27051 | 408 | 7 | 0 | 401 | 45.93424769 | -96.01139609 | 2021-01-07 05:22:03 | Grant, Minnesota, US |
3037145 | 3037145 | 2021-01-05 | US | South Dakota | Buffalo | 46017 | 411 | 10 | 0 | 401 | 44.07657829 | -99.20814467 | 2021-01-06 05:22:16 | Buffalo, South Dakota, US |
3037015 | 3037015 | 2021-01-05 | US | Puerto Rico | Cabo Rojo | 72023 | 401 | 0 | 0 | 401 | 18.040993 | -67.154391 | 2021-01-06 05:22:16 | Cabo Rojo, Puerto Rico, US |
3036443 | 3036443 | 2021-01-05 | US | Nevada | White Pine | 32033 | 404 | 3 | 0 | 401 | 39.44157041 | -114.899966 | 2021-01-06 05:22:16 | White Pine, Nevada, US |
3036393 | 3036393 | 2021-01-05 | US | Nebraska | Morrill | 31123 | 413 | 12 | 0 | 401 | 41.71711774 | -103.0061405 | 2021-01-06 05:22:16 | Morrill, Nebraska, US |
3035859 | 3035859 | 2021-01-05 | US | Maine | Washington | 23029 | 405 | 4 | 0 | 401 | 45.01607142 | -67.62813524 | 2021-01-06 05:22:16 | Washington, Maine, US |
3035414 | 3035414 | 2021-01-05 | US | Indiana | Ohio | 18115 | 411 | 10 | 0 | 401 | 38.955305 | -84.96515993 | 2021-01-06 05:22:16 | Ohio, Indiana, US |
3035288 | 3035288 | 2021-01-05 | US | Illinois | Henderson | 17071 | 405 | 4 | 0 | 401 | 40.81908672 | -90.92491462 | 2021-01-06 05:22:16 | Henderson, Illinois, US |
1064690 | 1064690 | 2021-01-04 | US | South Dakota | Buffalo | 46017 | 411 | 10 | 0 | 401 | 44.07657829 | -99.20814467 | 2021-01-05 05:21:49 | Buffalo, South Dakota, US |
1064560 | 1064560 | 2021-01-04 | US | Puerto Rico | Cabo Rojo | 72023 | 401 | 0 | 0 | 401 | 18.040993 | -67.154391 | 2021-01-05 05:21:49 | Cabo Rojo, Puerto Rico, US |
1064252 | 1064252 | 2021-01-04 | US | North Dakota | Nelson | 38063 | 410 | 12 | 0 | 401 | 47.9226426 | -98.19038437 | 2021-01-05 05:21:49 | Nelson, North Dakota, US |
1061879 | 1061879 | 2021-01-04 | Japan | Okinawa | 5486 | 83 | 5002 | 401 | 25.768923 | 126.668016 | 2021-01-05 05:21:49 | Okinawa, Japan | ||
1061629 | 1061629 | 2021-01-04 | Chad | 2229 | 104 | 1724 | 401 | 15.4542 | 18.7322 | 2021-01-05 05:21:49 | Chad | |||
3233293 | 3233293 | 2021-01-03 | US | South Dakota | Buffalo | 46017 | 411 | 10 | 0 | 401 | 44.07657829 | -99.20814467 | 2021-01-04 05:22:02 | Buffalo, South Dakota, US |
2230362 | 2230362 | 2021-01-02 | US | South Dakota | Buffalo | 46017 | 411 | 10 | 0 | 401 | 44.07657829 | -99.20814467 | 2021-01-03 05:22:52 | Buffalo, South Dakota, US |
1140166 | 1140166 | 2021-01-01 | US | Vermont | Windsor | 50027 | 404 | 3 | 0 | 401 | 43.58010937 | -72.58595157 | 2021-01-02 05:22:33 | Windsor, Vermont, US |
1138835 | 1138835 | 2021-01-01 | US | Missouri | Shannon | 29203 | 410 | 9 | 0 | 401 | 37.15772072 | -91.40190382 | 2021-01-02 05:22:33 | Shannon, Missouri, US |
1137308 | 1137308 | 2021-01-01 | US | Alaska | Northwest Arctic | 2188 | 401 | 0 | 0 | 401 | 67.04919196 | -159.7503946 | 2021-01-02 05:22:33 | Northwest Arctic, Alaska, 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]);