daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
59 rows where active = 2979 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-04 | Suriname | 25614 | 657 | 21978 | 2979 | 3.9193 | -56.0278 | 2021-08-05 04:21:51 | Suriname | |||
2021-07-18 | Russia | Buryatia Republic | 49434 | 1550 | 44905 | 2979 | 52.7182426 | 109.492143 | 2021-07-19 04:21:24 | Buryatia Republic, Russia | ||
2021-06-29 | Colombia | Huila | 71568 | 2385 | 66204 | 2979 | 2.5359 | -75.5277 | 2021-06-30 04:21:41 | Huila, Colombia | ||
2021-06-23 | Russia | Sakha (Yakutiya) Republic | 40694 | 754 | 36961 | 2979 | 66.941626 | 129.642371 | 2021-06-24 04:21:55 | Sakha (Yakutiya) Republic, Russia | ||
2021-06-17 | Chile | Biobio | 138705 | 2217 | 133509 | 2979 | -37.4464 | -72.1416 | 2021-06-18 04:22:16 | Biobio, Chile | ||
2021-06-13 | Italy | Basilicata | 26688 | 585 | 23124 | 2979 | 40.63947052 | 15.80514834 | 2021-06-14 04:22:46 | Basilicata, Italy | ||
2021-04-23 | Colombia | Caldas | 58249 | 1142 | 54128 | 2979 | 5.2983 | -75.2479 | 2021-04-24 04:20:38 | Caldas, Colombia | ||
2021-03-28 | Russia | Voronezh Oblast | 74539 | 2375 | 69185 | 2979 | 50.9800393 | 40.15065070000001 | 2021-03-29 04:28:35 | Voronezh Oblast, Russia | ||
2021-03-12 | Georgia | 274377 | 3634 | 267764 | 2979 | 42.3154 | 43.3569 | 2021-03-13 05:25:15 | Georgia | |||
2021-03-05 | US | Colorado | La Plata | 8067 | 3106 | 38 | 0 | 2979 | 37.28632032 | -107.8429014 | 2021-03-06 04:23:41 | La Plata, Colorado, US |
2021-02-28 | US | Pennsylvania | Wayne | 42127 | 3045 | 66 | 0 | 2979 | 41.64938475 | -75.29956506 | 2021-03-01 05:23:01 | Wayne, Pennsylvania, US |
2021-02-22 | US | Arkansas | Poinsett | 5111 | 3054 | 75 | 0 | 2979 | 35.57433534 | -90.66268713 | 2021-02-23 05:23:41 | Poinsett, Arkansas, US |
2021-02-21 | US | Arkansas | Poinsett | 5111 | 3054 | 75 | 0 | 2979 | 35.57433534 | -90.66268713 | 2021-02-22 05:24:21 | Poinsett, Arkansas, US |
2021-02-21 | Russia | Khabarovsk Krai | 48326 | 278 | 45069 | 2979 | 51.6312684 | 136.121524 | 2021-02-22 05:24:21 | Khabarovsk Krai, Russia | ||
2021-02-11 | US | Missouri | Platte | 29165 | 3017 | 38 | 0 | 2979 | 39.38154439 | -94.77068479 | 2021-02-12 05:23:29 | Platte, Missouri, US |
2021-02-10 | US | Wisconsin | Green | 55045 | 3000 | 21 | 0 | 2979 | 42.6794956 | -89.60243287 | 2021-02-11 05:23:55 | Green, Wisconsin, US |
2021-02-08 | US | Tennessee | Macon | 47111 | 3282 | 67 | 0 | 2979 | 36.53157855 | -86.00778595 | 2021-02-09 05:23:30 | Macon, Tennessee, US |
2021-02-01 | US | Washington | Grays Harbor | 53027 | 3011 | 32 | 0 | 2979 | 47.14003705 | -123.7820567 | 2021-02-02 05:22:49 | Grays Harbor, Washington, US |
2021-01-31 | US | Washington | Grays Harbor | 53027 | 3012 | 33 | 0 | 2979 | 47.14003705 | -123.7820567 | 2021-02-01 05:22:53 | Grays Harbor, Washington, US |
2021-01-31 | US | Colorado | Montrose | 8085 | 3191 | 55 | 0 | 2979 | 38.40214114 | -108.26390220000002 | 2021-02-01 05:22:53 | Montrose, Colorado, US |
2021-01-30 | US | Washington | Grays Harbor | 53027 | 3012 | 33 | 0 | 2979 | 47.14003705 | -123.7820567 | 2021-01-31 05:22:42 | Grays Harbor, Washington, US |
2021-01-27 | US | Mississippi | Hancock | 28045 | 3042 | 63 | 0 | 2979 | 30.41830223 | -89.48851033 | 2021-01-28 05:22:24 | Hancock, Mississippi, US |
2021-01-24 | US | Mississippi | Lincoln | 28085 | 3067 | 88 | 0 | 2979 | 31.53288662 | -90.45391915 | 2021-01-25 05:22:16 | Lincoln, Mississippi, US |
2021-01-21 | US | Tennessee | Hardin | 47071 | 3110 | 48 | 0 | 2979 | 35.19732531 | -88.18593755 | 2021-01-22 05:22:10 | Hardin, Tennessee, US |
2021-01-21 | US | Puerto Rico | Guaynabo | 72061 | 2979 | 0 | 0 | 2979 | 18.345114 | -66.11452299999999 | 2021-01-22 05:22:10 | Guaynabo, Puerto Rico, US |
2021-01-20 | US | California | Mendocino | 6045 | 3014 | 32 | 0 | 2979 | 39.4381191 | -123.3911313 | 2021-01-21 05:22:01 | Mendocino, California, US |
2021-01-16 | US | Texas | Bee | 48025 | 3709 | 53 | 0 | 2979 | 28.41761668 | -97.74215593 | 2021-01-17 05:22:17 | Bee, Texas, US |
2021-01-10 | Russia | Ulyanovsk Oblast | 38880 | 474 | 35427 | 2979 | 54.1463177 | 47.2324921 | 2021-01-11 05:21:50 | Ulyanovsk Oblast, Russia | ||
2021-01-07 | US | Minnesota | Morrison | 27097 | 3022 | 43 | 0 | 2979 | 46.01265363 | -94.27341528 | 2021-01-08 05:22:42 | Morrison, Minnesota, US |
2020-12-31 | US | Virginia | Culpeper | 51047 | 2998 | 19 | 0 | 2979 | 38.48199985 | -77.95630870000002 | 2021-01-01 05:23:07 | Culpeper, Virginia, US |
2020-12-31 | France | French Guiana | 13045 | 71 | 9995 | 2979 | 4.0 | -53.0 | 2021-01-01 05:23:07 | French Guiana, France | ||
2020-12-29 | US | Wisconsin | Trempealeau | 55121 | 3009 | 30 | 0 | 2979 | 44.30360275 | -91.35893614 | 2020-12-30 05:22:34 | Trempealeau, Wisconsin, US |
2020-12-29 | US | Michigan | Branch | 26023 | 3047 | 68 | 0 | 2979 | 41.91600556 | -85.05929476 | 2020-12-30 05:22:34 | Branch, Michigan, US |
2020-12-25 | US | Illinois | Livingston | 17105 | 3030 | 51 | 0 | 2979 | 40.89188292 | -88.55784752 | 2020-12-26 05:22:28 | Livingston, Illinois, US |
2020-12-21 | US | Tennessee | Fayette | 47047 | 3069 | 45 | 0 | 2979 | 35.19615831 | -89.41399032 | 2020-12-22 05:22:33 | Fayette, Tennessee, US |
2020-12-12 | US | Texas | Wise | 48497 | 3009 | 54 | 0 | 2979 | 33.21570665 | -97.65460265 | 2020-12-13 05:27:20 | Wise, Texas, US |
2020-12-12 | US | Ohio | Auglaize | 39011 | 3036 | 57 | 0 | 2979 | 40.55998859 | -84.22421429999999 | 2020-12-13 05:27:20 | Auglaize, Ohio, US |
2020-12-09 | US | Oklahoma | Creek | 40037 | 3032 | 53 | 0 | 2979 | 35.90230551 | -96.37086028 | 2020-12-10 05:26:19 | Creek, Oklahoma, US |
2020-12-06 | US | Indiana | Boone | 18011 | 3040 | 61 | 0 | 2979 | 40.0509304 | -86.46841646 | 2020-12-07 05:26:14 | Boone, Indiana, US |
2020-12-03 | US | Iowa | Muscatine | 19139 | 3051 | 72 | 0 | 2979 | 41.48370744 | -91.1121697 | 2020-12-04 05:27:27 | Muscatine, Iowa, US |
2020-12-03 | US | Georgia | Coffee | 13069 | 3060 | 81 | 0 | 2979 | 31.54892966 | -82.85492059999999 | 2020-12-04 05:27:27 | Coffee, Georgia, US |
2020-11-21 | US | South Carolina | Oconee | 45073 | 3019 | 40 | 0 | 2979 | 34.75225169 | -83.06742317 | 2020-11-22 05:25:45 | Oconee, South Carolina, US |
2020-11-20 | Colombia | Santander | 49505 | 1909 | 44617 | 2979 | 6.6437 | -73.6536 | 2020-11-21 05:25:51 | Santander, Colombia | ||
2020-11-19 | US | Iowa | Cerro Gordo | 19033 | 3017 | 38 | 0 | 2979 | 43.08177563 | -93.2612239 | 2020-11-20 05:26:28 | Cerro Gordo, Iowa, US |
2020-11-18 | US | Mississippi | Lauderdale | 28075 | 3120 | 141 | 0 | 2979 | 32.40419769 | -88.66229662 | 2020-11-19 05:25:23 | Lauderdale, Mississippi, US |
2020-11-16 | Japan | Tokyo | 34928 | 472 | 31477 | 2979 | 35.711343 | 139.446921 | 2020-11-17 05:25:54 | Tokyo, Japan | ||
2020-11-06 | US | North Carolina | Sampson | 37163 | 3010 | 31 | 0 | 2979 | 34.98820368 | -78.36914061 | 2020-11-07 05:24:52 | Sampson, North Carolina, US |
2020-11-06 | US | Florida | Suwannee | 12121 | 3059 | 80 | 0 | 2979 | 30.19746066 | -82.99099670000003 | 2020-11-07 05:24:52 | Suwannee, Florida, US |
2020-11-04 | US | Alabama | Walker | 1127 | 3074 | 95 | 0 | 2979 | 33.80270512 | -87.30027177 | 2020-11-05 06:05:03 | Walker, Alabama, US |
2020-10-31 | US | Arizona | Santa Cruz | 4023 | 3044 | 65 | 0 | 2979 | 31.52508998 | -110.8479088 | 2020-11-01 04:36:19 | Santa Cruz, Arizona, US |
2020-10-21 | Russia | Tver Oblast | 8211 | 293 | 4939 | 2979 | 57.1134475 | 35.174442799999994 | 2020-10-22 04:24:27 | Tver Oblast, Russia | ||
2020-10-15 | US | Alabama | Elmore | 1051 | 3031 | 52 | 0 | 2979 | 32.59785413 | -86.14415284 | 2020-10-16 04:24:01 | Elmore, Alabama, US |
2020-09-12 | Mexico | Guanajuato | 36391 | 2579 | 30833 | 2979 | 21.019 | -101.2574 | 2020-09-13 04:30:52 | Guanajuato, Mexico | ||
2020-09-08 | US | Mississippi | Madison | 28089 | 3062 | 83 | 0 | 2979 | 32.63389156 | -90.03513564 | 2020-09-09 04:28:48 | Madison, Mississippi, US |
2020-07-23 | US | Washington | Spokane | 53063 | 3023 | 44 | 0 | 2979 | 47.62113146 | -117.4046494 | 2020-07-24 05:30:40 | Spokane, Washington, US |
2020-06-28 | US | Louisiana | Caddo | 22017 | 3211 | 232 | 0 | 2979 | 32.57991587 | -93.88375652 | 2020-06-29 04:33:44 | Caddo, Louisiana, US |
2020-06-20 | Peru | San Martin | 3383 | 404 | 0 | 2979 | -7.039531 | -76.729127 | 2020-06-21 04:33:19 | San Martin, Peru | ||
2020-06-12 | US | Washington | Snohomish | 53061 | 3131 | 152 | 0 | 2979 | 48.04615983 | -121.7170703 | 2020-06-13 03:33:14 | Snohomish, Washington, US |
2020-05-15 | Bolivia | 3577 | 164 | 434 | 2979 | -16.2902 | -63.5887 | 2020-05-16 02:32:19 | Bolivia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;