johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
26 rows where active = 4420 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1330505 | 1330505 | 2021-07-24 | Russia | Udmurt Republic | 38837 | 1161 | 33256 | 4420 | 57.1961165 | 52.69598320000001 | 2021-07-25 04:22:12 | Udmurt Republic, Russia | ||
3958212 | 3958212 | 2021-06-26 | Bahrain | 264995 | 1341 | 259234 | 4420 | 26.0275 | 50.55 | 2021-06-27 04:21:39 | Bahrain | |||
3643416 | 3643416 | 2021-03-30 | Colombia | Valle del Cauca | 207712 | 6550 | 196742 | 4420 | 3.8009 | -76.6413 | 2021-03-31 04:26:25 | Valle del Cauca, Colombia | ||
1860433 | 1860433 | 2021-02-25 | US | North Dakota | Williams | 38105 | 4450 | 36 | 0 | 4420 | 48.34522353 | -103.4793387 | 2021-02-26 05:22:40 | Williams, North Dakota, US |
533808 | 533808 | 2021-02-22 | US | Texas | Harrison | 48203 | 5028 | 90 | 0 | 4420 | 32.54935988 | -94.36934071 | 2021-02-23 05:23:41 | Harrison, Texas, US |
3604314 | 3604314 | 2021-02-17 | US | Vermont | Chittenden | 50007 | 4502 | 82 | 0 | 4420 | 44.46322849 | -73.08359212 | 2021-02-18 05:22:58 | Chittenden, Vermont, US |
3978342 | 3978342 | 2021-02-10 | Canada | British Columbia | 71856 | 1269 | 66167 | 4420 | 53.7267 | -127.6476 | 2021-02-11 05:23:55 | British Columbia, Canada | ||
1674789 | 1674789 | 2021-02-07 | US | North Carolina | McDowell | 37111 | 4474 | 54 | 0 | 4420 | 35.67736232 | -82.0482425 | 2021-02-08 05:22:39 | McDowell, North Carolina, US |
975178 | 975178 | 2021-02-06 | Russia | Voronezh Oblast | 60440 | 1636 | 54384 | 4420 | 50.9800393 | 40.15065070000001 | 2021-02-07 05:23:00 | Voronezh Oblast, Russia | ||
777294 | 777294 | 2021-01-12 | US | Tennessee | Jefferson | 47089 | 4645 | 75 | 0 | 4420 | 36.04818632 | -83.45148924 | 2021-01-13 05:22:15 | Jefferson, Tennessee, US |
190838 | 190838 | 2021-01-11 | US | Georgia | Coffee | 13069 | 4522 | 102 | 0 | 4420 | 31.54892966 | -82.85492059999999 | 2021-01-12 05:22:15 | Coffee, Georgia, US |
2228271 | 2228271 | 2021-01-02 | US | Georgia | Bulloch | 13031 | 4477 | 57 | 0 | 4420 | 32.39577406 | -81.74811421 | 2021-01-03 05:22:52 | Bulloch, Georgia, US |
3691737 | 3691737 | 2020-12-24 | Russia | Vologda Oblast | 20932 | 359 | 16153 | 4420 | 60.0391461 | 43.1215213 | 2020-12-25 05:22:48 | Vologda Oblast, Russia | ||
3149530 | 3149530 | 2020-12-16 | India | Andhra Pradesh | 876814 | 7067 | 865327 | 4420 | 15.9129 | 79.74 | 2020-12-17 05:28:12 | Andhra Pradesh, India | ||
1026314 | 1026314 | 2020-10-17 | India | Puducherry | 32978 | 574 | 27984 | 4420 | 11.882658 | 78.86498 | 2020-10-18 04:24:25 | Puducherry, India | ||
3789507 | 3789507 | 2020-10-11 | Ukraine | Donetsk Oblast | 5649 | 66 | 1163 | 4420 | 48.0159 | 37.8028 | 2020-10-12 04:23:45 | Donetsk Oblast, Ukraine | ||
2515632 | 2515632 | 2020-10-03 | US | Kentucky | Warren | 21227 | 4474 | 54 | 0 | 4420 | 36.99903045 | -86.42672751 | 2020-10-04 04:23:44 | Warren, Kentucky, US |
2581842 | 2581842 | 2020-09-27 | Colombia | Santander | 30413 | 1271 | 24722 | 4420 | 6.6437 | -73.6536 | 2020-09-28 04:23:00 | Santander, Colombia | ||
752746 | 752746 | 2020-08-01 | US | Louisiana | St. Tammany | 22103 | 4621 | 201 | 0 | 4420 | 30.40942847 | -89.95642711 | 2020-08-02 04:34:47 | St. Tammany, Louisiana, US |
3263911 | 3263911 | 2020-07-31 | US | Louisiana | St. Tammany | 22103 | 4621 | 201 | 0 | 4420 | 30.40942847 | -89.95642711 | 2020-08-01 04:36:27 | St. Tammany, Louisiana, US |
3261387 | 3261387 | 2020-07-31 | US | Arkansas | Benton | 5007 | 4458 | 38 | 0 | 4420 | 36.33644656 | -94.25680817 | 2020-08-01 04:36:27 | Benton, Arkansas, US |
441762 | 441762 | 2020-07-26 | US | Missouri | St. Louis City | 29510 | 4597 | 177 | 0 | 4420 | 38.63555736 | -90.24349225 | 2020-07-27 04:35:02 | St. Louis City, Missouri, US |
1707812 | 1707812 | 2020-07-21 | Bulgaria | 9254 | 313 | 4521 | 4420 | 42.7339 | 25.4858 | 2020-07-22 04:34:42 | Bulgaria | |||
3435598 | 3435598 | 2020-07-11 | US | Arkansas | Washington | 5143 | 4456 | 36 | 0 | 4420 | 35.976844 | -94.21800746 | 2020-07-12 04:34:30 | Washington, Arkansas, US |
734290 | 734290 | 2020-06-12 | US | Colorado | Arapahoe | 8005 | 5264 | 356 | 0 | 4420 | 39.64977461 | -104.3353617 | 2020-06-13 03:33:14 | Arapahoe, Colorado, US |
1040514 | 1040514 | 2020-05-26 | US | Tennessee | Shelby | 47157 | 4581 | 96 | 0 | 4420 | 35.1864775 | -89.89692423 | 2020-05-27 02:32:31 | Shelby, Tennessee, 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]);