johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
54 rows where active = 3020 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
408603 | 408603 | 2021-07-28 | Suriname | 25118 | 640 | 21458 | 3020 | 3.9193 | -56.0278 | 2021-07-29 04:21:33 | Suriname | |||
3218409 | 3218409 | 2021-07-26 | Mongolia | 157974 | 688 | 154172 | 3020 | 46.8625 | 103.8467 | 2021-07-27 04:21:18 | Mongolia | |||
1378618 | 1378618 | 2021-07-25 | Mongolia | 156725 | 680 | 154172 | 3020 | 46.8625 | 103.8467 | 2021-07-26 04:21:28 | Mongolia | |||
2716963 | 2716963 | 2021-06-10 | Italy | Piemonte | 361871 | 11666 | 347185 | 3020 | 45.0732745 | 7.680687483 | 2021-06-11 04:23:20 | Piemonte, Italy | ||
2209369 | 2209369 | 2021-03-04 | US | Minnesota | Isanti | 27059 | 3076 | 56 | 0 | 3020 | 45.56181234 | -93.29487636 | 2021-03-05 05:26:29 | Isanti, Minnesota, US |
1002074 | 1002074 | 2021-03-01 | Ukraine | Ternopil Oblast | 42277 | 603 | 38654 | 3020 | 49.5535 | 25.5948 | 2021-03-02 05:23:30 | Ternopil Oblast, Ukraine | ||
2187133 | 2187133 | 2021-02-26 | US | Wisconsin | Lincoln | 55069 | 3095 | 75 | 0 | 3020 | 45.33737523 | -89.73411273 | 2021-02-27 05:22:28 | Lincoln, Wisconsin, US |
473352 | 473352 | 2021-02-19 | US | Missouri | Platte | 29165 | 3062 | 42 | 0 | 3020 | 39.38154439 | -94.77068479 | 2021-02-20 05:22:51 | Platte, Missouri, US |
3601223 | 3601223 | 2021-02-17 | Russia | Altai Krai | 41949 | 1396 | 37533 | 3020 | 52.6932243 | 82.69314240000001 | 2021-02-18 05:22:58 | Altai Krai, Russia | ||
3051795 | 3051795 | 2021-02-16 | US | Michigan | Delta | 26041 | 3104 | 84 | 0 | 3020 | 45.90484910000001 | -86.9080745 | 2021-02-17 05:23:10 | Delta, Michigan, US |
1341819 | 1341819 | 2021-02-15 | US | Wisconsin | Juneau | 55057 | 3040 | 20 | 0 | 3020 | 43.92456975 | -90.11120239 | 2021-02-16 05:24:38 | Juneau, Wisconsin, US |
2286970 | 2286970 | 2021-02-14 | US | Wisconsin | Juneau | 55057 | 3040 | 20 | 0 | 3020 | 43.92456975 | -90.11120239 | 2021-02-15 05:24:49 | Juneau, Wisconsin, US |
2286735 | 2286735 | 2021-02-14 | US | Virginia | Charlottesville | 51540 | 3060 | 40 | 0 | 3020 | 38.03527919 | -78.48569588 | 2021-02-15 05:24:49 | Charlottesville, Virginia, US |
1528988 | 1528988 | 2021-02-09 | US | Indiana | Jasper | 18073 | 3061 | 41 | 0 | 3020 | 41.02078733 | -87.11553319 | 2021-02-10 05:22:41 | Jasper, Indiana, US |
616285 | 616285 | 2021-02-08 | US | Oklahoma | Woodward | 40153 | 3035 | 15 | 0 | 3020 | 36.42316318 | -99.26283045 | 2021-02-09 05:23:30 | Woodward, Oklahoma, US |
342510 | 342510 | 2021-02-03 | US | New York | Livingston | 36051 | 3069 | 49 | 0 | 3020 | 42.72596275 | -77.77966158 | 2021-02-04 05:22:26 | Livingston, New York, US |
340064 | 340064 | 2021-02-03 | Chile | Los Lagos | 43332 | 422 | 39890 | 3020 | -41.9198 | -72.1416 | 2021-02-04 05:22:26 | Los Lagos, Chile | ||
1685171 | 1685171 | 2021-02-02 | US | Florida | Baker | 12003 | 3071 | 51 | 0 | 3020 | 30.33060121 | -82.28467476 | 2021-02-03 05:22:52 | Baker, Florida, US |
1460882 | 1460882 | 2021-01-31 | US | Indiana | Ripley | 18137 | 3073 | 53 | 0 | 3020 | 39.10235626 | -85.26212744 | 2021-02-01 05:22:53 | Ripley, Indiana, US |
436566 | 436566 | 2021-01-21 | US | Iowa | Marion | 19125 | 3072 | 52 | 0 | 3020 | 41.33445101 | -93.09934783 | 2021-01-22 05:22:10 | Marion, Iowa, US |
3881054 | 3881054 | 2021-01-14 | US | Louisiana | Avoyelles | 22009 | 3118 | 98 | 0 | 3020 | 31.07796211 | -92.00079449 | 2021-01-15 05:22:24 | Avoyelles, Louisiana, US |
3308466 | 3308466 | 2021-01-13 | Rwanda | 10122 | 128 | 6974 | 3020 | -1.9403 | 29.8739 | 2021-01-14 05:22:32 | Rwanda | |||
191801 | 191801 | 2021-01-11 | US | Minnesota | Morrison | 27097 | 3063 | 43 | 0 | 3020 | 46.01265363 | -94.27341528 | 2021-01-12 05:22:15 | Morrison, Minnesota, US |
2628145 | 2628145 | 2021-01-10 | US | North Carolina | Alexander | 37003 | 3058 | 38 | 0 | 3020 | 35.922379600000006 | -81.17751948 | 2021-01-11 05:21:50 | Alexander, North Carolina, US |
3900015 | 3900015 | 2021-01-09 | Kyrgyzstan | 82138 | 1367 | 77751 | 3020 | 41.20438 | 74.766098 | 2021-01-10 05:22:12 | Kyrgyzstan | |||
1011839 | 1011839 | 2020-12-30 | US | Louisiana | Washington | 22117 | 3107 | 87 | 0 | 3020 | 30.85288548 | -90.03866652 | 2020-12-31 05:22:49 | Washington, Louisiana, US |
1010534 | 1010534 | 2020-12-30 | Russia | Novosibirsk Oblast | 27736 | 958 | 23758 | 3020 | 54.9720169 | 79.48139240000002 | 2020-12-31 05:22:49 | Novosibirsk Oblast, Russia | ||
204405 | 204405 | 2020-12-25 | US | New Hampshire | Strafford | 33017 | 3042 | 22 | 0 | 3020 | 43.291833 | -71.02336013 | 2020-12-26 05:22:28 | Strafford, New Hampshire, US |
3693628 | 3693628 | 2020-12-24 | US | New Hampshire | Strafford | 33017 | 3042 | 22 | 0 | 3020 | 43.291833 | -71.02336013 | 2020-12-25 05:22:48 | Strafford, New Hampshire, US |
3770635 | 3770635 | 2020-12-22 | US | Georgia | Catoosa | 13047 | 3055 | 35 | 0 | 3020 | 34.89872298 | -85.13757014 | 2020-12-23 05:22:03 | Catoosa, Georgia, US |
3770569 | 3770569 | 2020-12-22 | US | Florida | Hendry | 12051 | 3068 | 48 | 0 | 3020 | 26.55386945 | -81.16469006 | 2020-12-23 05:22:03 | Hendry, Florida, US |
2934038 | 2934038 | 2020-12-19 | US | South Carolina | Laurens | 45059 | 3092 | 72 | 0 | 3020 | 34.48244419 | -82.00490796 | 2020-12-20 05:27:32 | Laurens, South Carolina, US |
2130549 | 2130549 | 2020-12-17 | US | Oklahoma | Le Flore | 40079 | 3048 | 28 | 0 | 3020 | 34.89851864 | -94.70392124 | 2020-12-18 05:28:18 | Le Flore, Oklahoma, US |
1753180 | 1753180 | 2020-12-14 | US | Missouri | Lincoln | 29113 | 3033 | 13 | 0 | 3020 | 39.05345619 | -90.95588181 | 2020-12-15 05:26:38 | Lincoln, Missouri, US |
2975709 | 2975709 | 2020-12-09 | US | Arkansas | Hot Spring | 5059 | 3066 | 46 | 0 | 3020 | 34.31709259 | -92.95396325 | 2020-12-10 05:26:19 | Hot Spring, Arkansas, US |
2936968 | 2936968 | 2020-11-28 | US | Minnesota | Nobles | 27105 | 3049 | 29 | 0 | 3020 | 43.67434621 | -95.75329576 | 2020-11-29 05:25:55 | Nobles, Minnesota, US |
925781 | 925781 | 2020-11-26 | US | Nebraska | Platte | 31141 | 3045 | 25 | 0 | 3020 | 41.57246836 | -97.52144359 | 2020-11-27 05:26:53 | Platte, Nebraska, US |
123747 | 123747 | 2020-11-18 | US | Illinois | Vermilion | 17183 | 3051 | 31 | 0 | 3020 | 40.18417171 | -87.73384359 | 2020-11-19 05:25:23 | Vermilion, Illinois, US |
2786640 | 2786640 | 2020-11-13 | US | Michigan | Jackson | 26075 | 3104 | 84 | 0 | 3020 | 42.24807035 | -84.42258681 | 2020-11-14 05:25:37 | Jackson, Michigan, US |
377986 | 377986 | 2020-11-06 | US | Mississippi | Jones | 28067 | 3104 | 84 | 0 | 3020 | 31.62257767 | -89.16896899999998 | 2020-11-07 05:24:52 | Jones, Mississippi, US |
376583 | 376583 | 2020-11-06 | US | Alabama | Walker | 1127 | 3116 | 96 | 0 | 3020 | 33.80270512 | -87.30027177 | 2020-11-07 05:24:52 | Walker, Alabama, US |
892567 | 892567 | 2020-11-05 | US | Arizona | Santa Cruz | 4023 | 3085 | 65 | 0 | 3020 | 31.52508998 | -110.8479088 | 2020-11-06 05:24:55 | Santa Cruz, Arizona, US |
2919867 | 2919867 | 2020-11-04 | US | Florida | Gadsden | 12039 | 3076 | 56 | 0 | 3020 | 30.57796289 | -84.61915825 | 2020-11-05 06:05:03 | Gadsden, Florida, US |
2501538 | 2501538 | 2020-11-03 | US | Wisconsin | Calumet | 55015 | 3034 | 14 | 0 | 3020 | 44.0816316 | -88.21780273 | 2020-11-04 05:25:09 | Calumet, Wisconsin, US |
3118154 | 3118154 | 2020-10-06 | US | Florida | Charlotte | 12015 | 3159 | 139 | 0 | 3020 | 26.90131002 | -81.92949121 | 2020-10-07 04:23:40 | Charlotte, Florida, US |
2457242 | 2457242 | 2020-09-19 | US | Ohio | Marion | 39101 | 3057 | 37 | 0 | 3020 | 40.58610662 | -83.15736305 | 2020-09-20 04:22:00 | Marion, Ohio, US |
2662973 | 2662973 | 2020-09-04 | US | Iowa | Linn | 19113 | 3114 | 94 | 0 | 3020 | 42.07923082 | -91.59809485 | 2020-09-05 04:28:19 | Linn, Iowa, US |
2218819 | 2218819 | 2020-08-23 | US | Texas | Midland | 48329 | 2316 | 62 | 0 | 3020 | 31.86904128 | -102.0315682 | 2020-08-24 04:27:56 | Midland, Texas, US |
2302601 | 2302601 | 2020-08-22 | US | Texas | Midland | 48329 | 2314 | 62 | 0 | 3020 | 31.86904128 | -102.0315682 | 2020-08-23 04:27:48 | Midland, Texas, US |
1482707 | 1482707 | 2020-08-21 | US | Texas | Midland | 48329 | 2309 | 62 | 0 | 3020 | 31.86904128 | -102.0315682 | 2020-08-22 04:27:49 | Midland, Texas, US |
3491095 | 3491095 | 2020-07-13 | US | Kansas | Wyandotte | 20209 | 3108 | 88 | 0 | 3020 | 39.11727348 | -94.76378225 | 2020-07-14 04:34:46 | Wyandotte, Kansas, US |
996137 | 996137 | 2020-05-23 | US | Indiana | Lake | 18089 | 3191 | 171 | 0 | 3020 | 41.41874274 | -87.38277575 | 2020-05-24 02:32:43 | Lake, Indiana, US |
1404618 | 1404618 | 2020-05-14 | Oman | 4341 | 18 | 1303 | 3020 | 21.512583 | 55.92325500000001 | 2020-05-15 02:33:02 | Oman | |||
2580584 | 2580584 | 2020-05-12 | US | Virginia | Prince William | 51153 | 3078 | 58 | 0 | 3020 | 38.70916224 | -77.48713689 | 2020-05-13 03:32:26 | Prince William, Virginia, 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]);