johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
30 rows where active = 6692 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1567775 | 1567775 | 2021-06-14 | Malaysia | Sarawak | 56187 | 356 | 49139 | 6692 | 1.5533 | 110.3592 | 2021-06-15 04:22:22 | Sarawak, Malaysia | ||
2318977 | 2318977 | 2021-06-04 | Malaysia | Kelantan | 29560 | 148 | 22720 | 6692 | 6.1254 | 102.2381 | 2021-06-05 04:23:03 | Kelantan, Malaysia | ||
726547 | 726547 | 2021-05-22 | Jordan | 726432 | 9295 | 710445 | 6692 | 31.24 | 36.51 | 2021-05-23 04:20:51 | Jordan | |||
1952562 | 1952562 | 2021-05-21 | Jordan | 726432 | 9295 | 710445 | 6692 | 31.24 | 36.51 | 2021-05-22 04:20:45 | Jordan | |||
1913261 | 1913261 | 2021-05-20 | Jordan | 726432 | 9295 | 710445 | 6692 | 31.24 | 36.51 | 2021-05-21 04:20:43 | Jordan | |||
2255782 | 2255782 | 2021-05-19 | Jordan | 726432 | 9295 | 710445 | 6692 | 31.24 | 36.51 | 2021-05-20 04:21:05 | Jordan | |||
2390820 | 2390820 | 2021-05-18 | Jordan | 726432 | 9295 | 710445 | 6692 | 31.24 | 36.51 | 2021-05-19 04:20:42 | Jordan | |||
3054428 | 3054428 | 2021-05-13 | Russia | Pskov Oblast | 36942 | 367 | 29883 | 6692 | 57.5358729 | 28.8586826 | 2021-05-14 04:20:41 | Pskov Oblast, Russia | ||
998145 | 998145 | 2021-03-01 | Bahrain | 123039 | 452 | 115895 | 6692 | 26.0275 | 50.55 | 2021-03-02 05:23:30 | Bahrain | |||
474662 | 474662 | 2021-02-19 | US | Texas | Wise | 48497 | 6898 | 109 | 0 | 6692 | 33.21570665 | -97.65460265 | 2021-02-20 05:22:51 | Wise, Texas, US |
1156371 | 1156371 | 2021-02-18 | US | Texas | Wise | 48497 | 6898 | 109 | 0 | 6692 | 33.21570665 | -97.65460265 | 2021-02-19 05:24:16 | Wise, Texas, US |
3604291 | 3604291 | 2021-02-17 | US | Texas | Wise | 48497 | 6898 | 109 | 0 | 6692 | 33.21570665 | -97.65460265 | 2021-02-18 05:22:58 | Wise, Texas, US |
1530532 | 1530532 | 2021-02-09 | US | Pennsylvania | Adams | 42001 | 6837 | 145 | 0 | 6692 | 39.87140411 | -77.21610347 | 2021-02-10 05:22:41 | Adams, Pennsylvania, US |
438183 | 438183 | 2021-01-21 | US | South Carolina | Orangeburg | 45075 | 6863 | 171 | 0 | 6692 | 33.4391073 | -80.79886287 | 2021-01-22 05:22:10 | Orangeburg, South Carolina, US |
776840 | 776840 | 2021-01-12 | US | Ohio | Pickaway | 39129 | 6785 | 93 | 0 | 6692 | 39.64170392 | -83.0243386 | 2021-01-13 05:22:15 | Pickaway, Ohio, US |
157603 | 157603 | 2021-01-08 | Ukraine | Kherson Oblast | 18774 | 463 | 11619 | 6692 | 46.6354 | 32.6169 | 2021-01-09 05:22:18 | Kherson Oblast, Ukraine | ||
3037762 | 3037762 | 2021-01-05 | US | West Virginia | Berkeley | 54003 | 6749 | 57 | 0 | 6692 | 39.46704621 | -78.02414609 | 2021-01-06 05:22:16 | Berkeley, West Virginia, US |
2976981 | 2976981 | 2020-12-09 | US | Minnesota | Sherburne | 27141 | 6740 | 48 | 0 | 6692 | 45.44447208 | -93.77617511 | 2020-12-10 05:26:19 | Sherburne, Minnesota, US |
2976837 | 2976837 | 2020-12-09 | US | Michigan | Calhoun | 26025 | 6833 | 141 | 0 | 6692 | 42.24633834 | -85.00493569 | 2020-12-10 05:26:19 | Calhoun, Michigan, US |
75473 | 75473 | 2020-12-03 | US | Alabama | Marshall | 1095 | 6750 | 58 | 0 | 6692 | 34.36975964 | -86.30486727 | 2020-12-04 05:27:27 | Marshall, Alabama, US |
2540823 | 2540823 | 2020-12-01 | US | Washington | Franklin | 53021 | 6765 | 73 | 0 | 6692 | 46.53351425 | -118.9018212 | 2020-12-02 05:27:41 | Franklin, Washington, US |
2538922 | 2538922 | 2020-12-01 | US | Louisiana | Tangipahoa | 22105 | 6834 | 142 | 0 | 6692 | 30.62888673 | -90.40664996 | 2020-12-02 05:27:41 | Tangipahoa, Louisiana, US |
679779 | 679779 | 2020-11-23 | US | Kentucky | Warren | 21227 | 6753 | 61 | 0 | 6692 | 36.99903045 | -86.42672751 | 2020-11-24 05:27:31 | Warren, Kentucky, US |
2703934 | 2703934 | 2020-11-20 | US | North Dakota | Ward | 38101 | 6940 | 110 | 0 | 6692 | 48.22390169 | -101.5436763 | 2020-11-21 05:25:51 | Ward, North Dakota, US |
1056056 | 1056056 | 2020-10-23 | US | New York | Monroe | 36055 | 6992 | 300 | 0 | 6692 | 43.14638895 | -77.69322942 | 2020-10-24 04:24:46 | Monroe, New York, US |
2585330 | 2585330 | 2020-09-27 | US | Virginia | Loudoun | 51107 | 6816 | 124 | 0 | 6692 | 39.08990083 | -77.63481877 | 2020-09-28 04:23:00 | Loudoun, Virginia, US |
2457069 | 2457069 | 2020-09-19 | US | North Carolina | Forsyth | 37067 | 6786 | 94 | 0 | 6692 | 36.12859861 | -80.25459052 | 2020-09-20 04:22:00 | Forsyth, North Carolina, US |
2730954 | 2730954 | 2020-09-15 | US | Missouri | St. Louis City | 29510 | 6913 | 221 | 0 | 6692 | 38.63555736 | -90.24349225 | 2020-09-16 04:22:53 | St. Louis City, Missouri, US |
1244052 | 1244052 | 2020-09-08 | Spain | Murcia | 9034 | 162 | 2180 | 6692 | 37.9922 | -1.1307 | 2020-09-09 04:28:48 | Murcia, Spain | ||
3845581 | 3845581 | 2020-05-13 | US | Washington | King | 53033 | 7212 | 520 | 0 | 6692 | 47.49137892 | -121.8346131 | 2020-05-14 03:32:28 | King, Washington, 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]);