johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
46 rows where active = 3448 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3741273 | 3741273 | 2021-07-12 | Russia | Bryansk Oblast | 48406 | 634 | 44324 | 3448 | 52.8873315 | 33.41585300000001 | 2021-07-13 04:21:18 | Bryansk Oblast, Russia | ||
1896764 | 1896764 | 2021-06-30 | Ukraine | Crimea Republic* | 48386 | 1505 | 43433 | 3448 | 45.2835 | 34.2008 | 2021-07-01 04:21:19 | Crimea Republic*, Ukraine | ||
1091891 | 1091891 | 2021-03-03 | US | Mississippi | Lincoln | 28085 | 3552 | 104 | 0 | 3448 | 31.53288662 | -90.45391915 | 2021-03-04 05:24:24 | Lincoln, Mississippi, US |
2186058 | 2186058 | 2021-02-26 | US | Ohio | Logan | 39091 | 3524 | 76 | 0 | 3448 | 40.38996525 | -83.76784341 | 2021-02-27 05:22:28 | Logan, Ohio, US |
3602588 | 3602588 | 2021-02-17 | US | Maine | Kennebec | 23011 | 3497 | 49 | 0 | 3448 | 44.40759555 | -69.76738544 | 2021-02-18 05:22:58 | Kennebec, Maine, US |
3602147 | 3602147 | 2021-02-17 | US | Indiana | Miami | 18103 | 3509 | 61 | 0 | 3448 | 40.76940965 | -86.04525048 | 2021-02-18 05:22:58 | Miami, Indiana, US |
2638273 | 2638273 | 2021-02-11 | US | California | Mendocino | 6045 | 3489 | 38 | 0 | 3448 | 39.4381191 | -123.3911313 | 2021-02-12 05:23:29 | Mendocino, California, US |
1530738 | 1530738 | 2021-02-09 | US | South Dakota | Brookings | 46011 | 3483 | 35 | 0 | 3448 | 44.36974375 | -96.79079945 | 2021-02-10 05:22:41 | Brookings, South Dakota, US |
977494 | 977494 | 2021-02-06 | US | Oklahoma | Ottawa | 40115 | 3486 | 38 | 0 | 3448 | 36.83532655 | -94.81011909 | 2021-02-07 05:23:00 | Ottawa, Oklahoma, US |
1461167 | 1461167 | 2021-01-31 | US | Kentucky | Hopkins | 21107 | 3559 | 111 | 0 | 3448 | 37.30939025 | -87.54670406 | 2021-02-01 05:22:53 | Hopkins, Kentucky, US |
2426867 | 2426867 | 2021-01-23 | India | Rajasthan | 316485 | 2758 | 310279 | 3448 | 26.583423 | 73.847973 | 2021-01-24 05:22:35 | Rajasthan, India | ||
437834 | 437834 | 2021-01-21 | US | Ohio | Madison | 39097 | 3499 | 51 | 0 | 3448 | 39.89381073 | -83.40178317 | 2021-01-22 05:22:10 | Madison, Ohio, US |
909704 | 909704 | 2021-01-19 | US | Louisiana | St. Mary | 22101 | 3555 | 107 | 0 | 3448 | 29.69262097 | -91.44702164 | 2021-01-20 05:21:54 | St. Mary, Louisiana, US |
3104820 | 3104820 | 2021-01-16 | US | Virginia | Pittsylvania | 51143 | 3489 | 41 | 0 | 3448 | 36.81980341 | -79.39731264 | 2021-01-17 05:22:17 | Pittsylvania, Virginia, US |
769137 | 769137 | 2020-12-29 | US | South Carolina | Laurens | 45059 | 3529 | 81 | 0 | 3448 | 34.48244419 | -82.00490796 | 2020-12-30 05:22:34 | Laurens, South Carolina, US |
3770863 | 3770863 | 2020-12-22 | US | Illinois | Henry | 17073 | 3477 | 29 | 0 | 3448 | 41.3533994 | -90.13296166 | 2020-12-23 05:22:03 | Henry, Illinois, US |
862331 | 862331 | 2020-12-11 | US | Michigan | Midland | 26111 | 3479 | 31 | 0 | 3448 | 43.64330771 | -84.38804374 | 2020-12-12 05:26:19 | Midland, Michigan, US |
2347893 | 2347893 | 2020-12-07 | US | Arkansas | Crittenden | 5035 | 3506 | 58 | 0 | 3448 | 35.21247318 | -90.30839406 | 2020-12-08 05:27:42 | Crittenden, Arkansas, US |
3566981 | 3566981 | 2020-11-29 | US | Alaska | Fairbanks North Star | 2090 | 3465 | 17 | 0 | 3448 | 64.80726247 | -146.5692662 | 2020-11-30 05:26:13 | Fairbanks North Star, Alaska, US |
681491 | 681491 | 2020-11-23 | US | Texas | Orange | 48361 | 1957 | 51 | 0 | 3448 | 30.11879481 | -93.89412775 | 2020-11-24 05:27:31 | Orange, Texas, US |
3193167 | 3193167 | 2020-11-22 | US | Texas | Orange | 48361 | 1877 | 51 | 0 | 3448 | 30.11879481 | -93.89412775 | 2020-11-23 05:25:26 | Orange, Texas, US |
3190770 | 3190770 | 2020-11-22 | US | Georgia | Dougherty | 13095 | 3651 | 203 | 0 | 3448 | 31.53328528 | -84.21722377 | 2020-11-23 05:25:26 | Dougherty, Georgia, US |
3839661 | 3839661 | 2020-11-21 | US | Texas | Orange | 48361 | 1840 | 51 | 0 | 3448 | 30.11879481 | -93.89412775 | 2020-11-22 05:25:45 | Orange, Texas, US |
3172636 | 3172636 | 2020-11-16 | US | Texas | Anderson | 48001 | 2892 | 45 | 0 | 3448 | 31.81534745 | -95.65354823 | 2020-11-17 05:25:54 | Anderson, Texas, US |
2883204 | 2883204 | 2020-11-15 | US | Texas | Anderson | 48001 | 2892 | 45 | 0 | 3448 | 31.81534745 | -95.65354823 | 2020-11-16 05:25:57 | Anderson, Texas, US |
2918551 | 2918551 | 2020-11-14 | US | Virginia | Newport News | 51700 | 3501 | 53 | 0 | 3448 | 37.08166899 | -76.51754109 | 2020-11-15 05:26:53 | Newport News, Virginia, US |
1730090 | 1730090 | 2020-11-08 | US | Michigan | Berrien | 26021 | 3541 | 93 | 0 | 3448 | 41.95447397 | -86.41313079999998 | 2020-11-09 05:25:45 | Berrien, Michigan, US |
1545550 | 1545550 | 2020-11-07 | US | Michigan | Berrien | 26021 | 3541 | 93 | 0 | 3448 | 41.95447397 | -86.41313079999998 | 2020-11-08 05:24:56 | Berrien, Michigan, US |
3306817 | 3306817 | 2020-11-02 | US | Oregon | Umatilla | 41059 | 3493 | 45 | 0 | 3448 | 45.59073056 | -118.7353826 | 2020-11-03 06:00:16 | Umatilla, Oregon, US |
1452909 | 1452909 | 2020-10-27 | Sweden | Vastmanland | 3632 | 184 | 0 | 3448 | 59.6714 | 16.2159 | 2020-10-28 04:24:39 | Vastmanland, Sweden | ||
1452644 | 1452644 | 2020-10-27 | Latvia | 4893 | 63 | 1382 | 3448 | 56.8796 | 24.6032 | 2020-10-28 04:24:39 | Latvia | |||
9899 | 9899 | 2020-10-25 | US | Maryland | Harford | 24025 | 3529 | 81 | 0 | 3448 | 39.55010644 | -76.30775940000002 | 2020-10-26 04:25:02 | Harford, Maryland, US |
3993132 | 3993132 | 2020-10-20 | US | Oklahoma | Canadian | 40017 | 3469 | 21 | 0 | 3448 | 35.5426055 | -97.98465569 | 2020-10-21 04:24:14 | Canadian, Oklahoma, US |
3117479 | 3117479 | 2020-10-06 | Italy | Sicilia | 8007 | 322 | 4237 | 3448 | 38.11569725 | 13.362356699999998 | 2020-10-07 04:23:40 | Sicilia, Italy | ||
1047478 | 1047478 | 2020-09-30 | US | Michigan | Ottawa | 26139 | 3514 | 66 | 0 | 3448 | 42.95996803 | -85.9969107 | 2020-10-01 04:23:42 | Ottawa, Michigan, US |
3316326 | 3316326 | 2020-09-22 | Montenegro | 9138 | 146 | 5544 | 3448 | 42.708678 | 19.37439 | 2020-09-23 04:23:00 | Montenegro | |||
2729090 | 2729090 | 2020-09-15 | Mexico | Mexico | 74894 | 8794 | 62652 | 3448 | 19.4969 | -99.7233 | 2020-09-16 04:22:53 | Mexico, Mexico | ||
1174682 | 1174682 | 2020-09-10 | US | Louisiana | Livingston | 22063 | 3517 | 69 | 0 | 3448 | 30.44143993 | -90.73061664 | 2020-09-11 04:46:23 | Livingston, Louisiana, US |
428289 | 428289 | 2020-09-07 | US | Illinois | Champaign | 17019 | 3468 | 20 | 0 | 3448 | 40.13919438 | -88.20046615 | 2020-09-08 04:28:25 | Champaign, Illinois, US |
1355777 | 1355777 | 2020-09-03 | US | Kentucky | Warren | 21227 | 3476 | 28 | 0 | 3448 | 36.99903045 | -86.42672751 | 2020-09-04 04:28:26 | Warren, Kentucky, US |
3177863 | 3177863 | 2020-08-18 | Colombia | Narino | 11763 | 421 | 7894 | 3448 | 1.2892 | -77.3579 | 2020-08-19 04:27:00 | Narino, Colombia | ||
1919327 | 1919327 | 2020-08-10 | US | Wisconsin | Racine | 55101 | 3526 | 78 | 0 | 3448 | 42.74753117 | -88.05941254 | 2020-08-11 04:35:08 | Racine, Wisconsin, US |
844478 | 844478 | 2020-07-22 | US | Iowa | Woodbury | 19193 | 3495 | 47 | 0 | 3448 | 42.38979414 | -96.0459439 | 2020-07-23 05:15:04 | Woodbury, Iowa, US |
1705926 | 1705926 | 2020-07-21 | US | Texas | McLennan | 48309 | 1254 | 24 | 0 | 3448 | 31.55255453 | -97.20217694 | 2020-07-22 04:34:42 | McLennan, Texas, US |
3734433 | 3734433 | 2020-07-12 | US | Arkansas | Benton | 5007 | 3470 | 22 | 0 | 3448 | 36.33644656 | -94.25680817 | 2020-07-13 04:43:04 | Benton, Arkansas, US |
1195685 | 1195685 | 2020-06-17 | Colombia | Bolivar | 5423 | 227 | 1748 | 3448 | 8.6704 | -74.03 | 2020-06-18 04:33:18 | Bolivar, Colombia |
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]);