johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
30 rows where active = 4787 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 8
- US 19
- India 2
- Italy 2
- Russia 2
- Ukraine 2
- Cambodia 1
- Cote d'Ivoire 1
- Madagascar 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3706119 | 3706119 | 2021-07-17 | Italy | Sicilia | 235092 | 6006 | 224299 | 4787 | 38.11569725 | 13.362356699999998 | 2021-07-18 04:22:07 | Sicilia, Italy | ||
3741040 | 3741040 | 2021-07-12 | India | Mizoram | 24702 | 112 | 19803 | 4787 | 23.309381 | 92.83822 | 2021-07-13 04:21:18 | Mizoram, India | ||
1712086 | 1712086 | 2021-06-25 | Cambodia | 46065 | 509 | 40769 | 4787 | 11.55 | 104.9167 | 2021-06-26 04:21:43 | Cambodia | |||
2548941 | 2548941 | 2021-04-15 | Madagascar | 30207 | 527 | 24893 | 4787 | -18.766947 | 46.869107 | 2021-04-16 04:20:46 | Madagascar | |||
1289985 | 1289985 | 2021-03-29 | Italy | Basilicata | 19181 | 439 | 13955 | 4787 | 40.63947052 | 15.80514834 | 2021-03-30 04:26:23 | Basilicata, Italy | ||
3068636 | 3068636 | 2021-02-27 | US | Pennsylvania | Armstrong | 42005 | 4903 | 116 | 0 | 4787 | 40.81665618 | -79.46290811 | 2021-02-28 05:22:20 | Armstrong, Pennsylvania, US |
743556 | 743556 | 2021-02-20 | US | Iowa | Webster | 19187 | 4872 | 85 | 0 | 4787 | 42.42853483 | -94.17987389 | 2021-02-21 05:24:33 | Webster, Iowa, US |
472654 | 472654 | 2021-02-19 | US | Iowa | Webster | 19187 | 4872 | 85 | 0 | 4787 | 42.42853483 | -94.17987389 | 2021-02-20 05:22:51 | Webster, Iowa, US |
3052357 | 3052357 | 2021-02-16 | US | New Mexico | Curry | 35009 | 4850 | 63 | 0 | 4787 | 34.57421077 | -103.3468876 | 2021-02-17 05:23:10 | Curry, New Mexico, US |
2285124 | 2285124 | 2021-02-14 | US | Minnesota | Chisago | 27025 | 4830 | 43 | 0 | 4787 | 45.5021011 | -92.90861945 | 2021-02-15 05:24:49 | Chisago, Minnesota, US |
977322 | 977322 | 2021-02-06 | US | North Dakota | Morton | 38059 | 4838 | 93 | 0 | 4787 | 46.71681782 | -101.2822377 | 2021-02-07 05:23:00 | Morton, North Dakota, US |
1590730 | 1590730 | 2021-02-05 | US | Oklahoma | Kay | 40071 | 4847 | 60 | 0 | 4787 | 36.81799745 | -97.14421435 | 2021-02-06 05:23:55 | Kay, Oklahoma, US |
3154428 | 3154428 | 2021-01-27 | US | Georgia | Laurens | 13175 | 4921 | 134 | 0 | 4787 | 32.46325233 | -82.92221316 | 2021-01-28 05:22:24 | Laurens, Georgia, US |
2570590 | 2570590 | 2021-01-25 | US | Tennessee | Dyer | 47045 | 4991 | 87 | 0 | 4787 | 36.05931946 | -89.41542855 | 2021-01-26 05:22:02 | Dyer, Tennessee, US |
2569961 | 2569961 | 2021-01-25 | US | North Carolina | Columbus | 37047 | 4893 | 106 | 0 | 4787 | 34.26744084 | -78.65801424 | 2021-01-26 05:22:02 | Columbus, North Carolina, US |
1762592 | 1762592 | 2021-01-24 | US | Virginia | Bedford | 51019 | 4824 | 37 | 0 | 4787 | 37.3080028 | -79.5281964 | 2021-01-25 05:22:16 | Bedford, Virginia, US |
436041 | 436041 | 2021-01-21 | US | Florida | Flagler | 12035 | 4847 | 60 | 0 | 4787 | 29.45933576 | -81.31508595 | 2021-01-22 05:22:10 | Flagler, Florida, US |
3103744 | 3103744 | 2021-01-16 | US | North Carolina | Duplin | 37061 | 4870 | 83 | 0 | 4787 | 34.93449805 | -77.93140529 | 2021-01-17 05:22:17 | Duplin, North Carolina, US |
3861436 | 3861436 | 2020-12-04 | US | Michigan | Bay | 26017 | 4898 | 111 | 0 | 4787 | 43.70639106 | -83.98731479 | 2020-12-05 05:27:36 | Bay, Michigan, US |
923908 | 923908 | 2020-11-26 | Russia | Nizhny Novgorod Oblast | 52633 | 1112 | 46734 | 4787 | 55.47180329999999 | 44.0911594 | 2020-11-27 05:26:53 | Nizhny Novgorod Oblast, Russia | ||
1352988 | 1352988 | 2020-11-24 | US | Pennsylvania | Lebanon | 42075 | 4891 | 104 | 0 | 4787 | 40.36680311 | -76.45651841 | 2020-11-25 05:27:20 | Lebanon, Pennsylvania, US |
2080138 | 2080138 | 2020-10-31 | Russia | Khabarovsk Krai | 16294 | 134 | 11373 | 4787 | 51.6312684 | 136.121524 | 2020-11-01 04:36:19 | Khabarovsk Krai, Russia | ||
757298 | 757298 | 2020-10-28 | US | Tennessee | Wilson | 47189 | 4893 | 60 | 0 | 4787 | 36.15496772 | -86.29775884 | 2020-10-29 04:24:49 | Wilson, Tennessee, US |
1057456 | 1057456 | 2020-10-23 | Ukraine | Volyn Oblast | 11792 | 233 | 6772 | 4787 | 50.7472 | 25.3254 | 2020-10-24 04:24:46 | Volyn Oblast, Ukraine | ||
2194276 | 2194276 | 2020-10-21 | US | Pennsylvania | Northampton | 42095 | 5096 | 309 | 0 | 4787 | 40.75182733 | -75.30471829 | 2020-10-22 04:24:27 | Northampton, Pennsylvania, US |
3785318 | 3785318 | 2020-10-13 | US | Washington | Benton | 53005 | 4915 | 128 | 0 | 4787 | 46.23946995 | -119.5120834 | 2020-10-14 04:24:05 | Benton, Washington, US |
1822749 | 1822749 | 2020-10-04 | India | Puducherry | 29089 | 539 | 23763 | 4787 | 11.882658 | 78.86498 | 2020-10-05 04:23:33 | Puducherry, India | ||
2840447 | 2840447 | 2020-09-21 | Ukraine | Zakarpattia Oblast | 9189 | 292 | 4110 | 4787 | 48.6208 | 22.2879 | 2020-09-22 04:23:00 | Zakarpattia Oblast, Ukraine | ||
2625393 | 2625393 | 2020-06-25 | Cote d'Ivoire | 8334 | 60 | 3487 | 4787 | 7.54 | -5.5471 | 2020-06-26 04:33:43 | Cote d'Ivoire | |||
1192753 | 1192753 | 2020-06-17 | US | Texas | Bexar | 48029 | 5528 | 89 | 0 | 4787 | 29.44928723 | -98.52019748 | 2020-06-18 04:33:18 | Bexar, Texas, 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]);