johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
42 rows where deaths = 47 and province_or_state = "Iwate" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: active, day (date)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1483571 | 1483571 | 2021-08-13 | Japan | Iwate | 2335 | 47 | 0 | 39.593287 | 141.361777 | 2021-08-14 04:21:25 | Iwate, Japan | |||
2899701 | 2899701 | 2021-08-12 | Japan | Iwate | 2281 | 47 | 0 | 39.593287 | 141.361777 | 2021-08-13 04:21:24 | Iwate, Japan | |||
1342305 | 1342305 | 2021-08-11 | Japan | Iwate | 2245 | 47 | 0 | 39.593287 | 141.361777 | 2021-08-12 04:21:25 | Iwate, Japan | |||
2351452 | 2351452 | 2021-08-10 | Japan | Iwate | 2205 | 47 | 0 | 39.593287 | 141.361777 | 2021-08-11 04:21:58 | Iwate, Japan | |||
649981 | 649981 | 2021-08-09 | Japan | Iwate | 2179 | 47 | 0 | 39.593287 | 141.361777 | 2021-08-10 04:21:27 | Iwate, Japan | |||
589643 | 589643 | 2021-08-08 | Japan | Iwate | 2166 | 47 | 0 | 39.593287 | 141.361777 | 2021-08-09 04:21:24 | Iwate, Japan | |||
2203655 | 2203655 | 2021-08-07 | Japan | Iwate | 2145 | 47 | 0 | 39.593287 | 141.361777 | 2021-08-08 04:21:33 | Iwate, Japan | |||
1117605 | 1117605 | 2021-08-06 | Japan | Iwate | 2106 | 47 | 0 | 39.593287 | 141.361777 | 2021-08-07 04:21:30 | Iwate, Japan | |||
1956542 | 1956542 | 2021-08-05 | Japan | Iwate | 2078 | 47 | 0 | 39.593287 | 141.361777 | 2021-08-06 04:21:18 | Iwate, Japan | |||
331921 | 331921 | 2021-08-04 | Japan | Iwate | 2065 | 47 | 1862 | 156 | 39.593287 | 141.361777 | 2021-08-05 04:21:51 | Iwate, Japan | ||
3468192 | 3468192 | 2021-08-03 | Japan | Iwate | 2046 | 47 | 1840 | 159 | 39.593287 | 141.361777 | 2021-08-04 04:21:25 | Iwate, Japan | ||
3683466 | 3683466 | 2021-08-02 | Japan | Iwate | 2025 | 47 | 1835 | 143 | 39.593287 | 141.361777 | 2021-08-03 04:21:39 | Iwate, Japan | ||
3015365 | 3015365 | 2021-08-01 | Japan | Iwate | 2011 | 47 | 1827 | 137 | 39.593287 | 141.361777 | 2021-08-02 04:21:36 | Iwate, Japan | ||
3903988 | 3903988 | 2021-07-31 | Japan | Iwate | 2002 | 47 | 1813 | 142 | 39.593287 | 141.361777 | 2021-08-01 04:21:50 | Iwate, Japan | ||
3296193 | 3296193 | 2021-07-30 | Japan | Iwate | 1981 | 47 | 1805 | 129 | 39.593287 | 141.361777 | 2021-07-31 04:21:35 | Iwate, Japan | ||
3385404 | 3385404 | 2021-07-29 | Japan | Iwate | 1962 | 47 | 1797 | 118 | 39.593287 | 141.361777 | 2021-07-30 04:21:34 | Iwate, Japan | ||
408309 | 408309 | 2021-07-28 | Japan | Iwate | 1950 | 47 | 1785 | 118 | 39.593287 | 141.361777 | 2021-07-29 04:21:33 | Iwate, Japan | ||
1306170 | 1306170 | 2021-07-27 | Japan | Iwate | 1933 | 47 | 1775 | 111 | 39.593287 | 141.361777 | 2021-07-28 04:21:39 | Iwate, Japan | ||
3218313 | 3218313 | 2021-07-26 | Japan | Iwate | 1923 | 47 | 1773 | 103 | 39.593287 | 141.361777 | 2021-07-27 04:21:18 | Iwate, Japan | ||
1378522 | 1378522 | 2021-07-25 | Japan | Iwate | 1912 | 47 | 1768 | 97 | 39.593287 | 141.361777 | 2021-07-26 04:21:28 | Iwate, Japan | ||
1330262 | 1330262 | 2021-07-24 | Japan | Iwate | 1899 | 47 | 1759 | 93 | 39.593287 | 141.361777 | 2021-07-25 04:22:12 | Iwate, Japan | ||
3137566 | 3137566 | 2021-07-23 | Japan | Iwate | 1887 | 47 | 1751 | 89 | 39.593287 | 141.361777 | 2021-07-24 00:21:36 | Iwate, Japan | ||
3476326 | 3476326 | 2021-07-22 | Japan | Iwate | 1879 | 47 | 1744 | 88 | 39.593287 | 141.361777 | 2021-07-23 04:21:29 | Iwate, Japan | ||
3331545 | 3331545 | 2021-07-21 | Japan | Iwate | 1874 | 47 | 1729 | 98 | 39.593287 | 141.361777 | 2021-07-22 04:21:19 | Iwate, Japan | ||
2371526 | 2371526 | 2021-07-20 | Japan | Iwate | 1865 | 47 | 1714 | 104 | 39.593287 | 141.361777 | 2021-07-21 04:21:40 | Iwate, Japan | ||
483605 | 483605 | 2021-07-19 | Japan | Iwate | 1859 | 47 | 1706 | 106 | 39.593287 | 141.361777 | 2021-07-20 04:21:48 | Iwate, Japan | ||
2673828 | 2673828 | 2021-07-18 | Japan | Iwate | 1855 | 47 | 1694 | 114 | 39.593287 | 141.361777 | 2021-07-19 04:21:24 | Iwate, Japan | ||
3706140 | 3706140 | 2021-07-17 | Japan | Iwate | 1845 | 47 | 1685 | 113 | 39.593287 | 141.361777 | 2021-07-18 04:22:07 | Iwate, Japan | ||
2947371 | 2947371 | 2021-07-16 | Japan | Iwate | 1835 | 47 | 1677 | 111 | 39.593287 | 141.361777 | 2021-07-17 04:22:22 | Iwate, Japan | ||
296027 | 296027 | 2021-07-15 | Japan | Iwate | 1826 | 47 | 1670 | 109 | 39.593287 | 141.361777 | 2021-07-16 04:21:22 | Iwate, Japan | ||
3631972 | 3631972 | 2021-07-14 | Japan | Iwate | 1820 | 47 | 1656 | 117 | 39.593287 | 141.361777 | 2021-07-15 04:21:48 | Iwate, Japan | ||
578847 | 578847 | 2021-07-13 | Japan | Iwate | 1812 | 47 | 1649 | 116 | 39.593287 | 141.361777 | 2021-07-14 04:21:35 | Iwate, Japan | ||
3741096 | 3741096 | 2021-07-12 | Japan | Iwate | 1800 | 47 | 1645 | 108 | 39.593287 | 141.361777 | 2021-07-13 04:21:18 | Iwate, Japan | ||
3659609 | 3659609 | 2021-07-11 | Japan | Iwate | 1788 | 47 | 1629 | 112 | 39.593287 | 141.361777 | 2021-07-12 04:21:34 | Iwate, Japan | ||
625893 | 625893 | 2021-07-10 | Japan | Iwate | 1774 | 47 | 1629 | 98 | 39.593287 | 141.361777 | 2021-07-11 04:21:43 | Iwate, Japan | ||
829612 | 829612 | 2021-07-09 | Japan | Iwate | 1766 | 47 | 1621 | 98 | 39.593287 | 141.361777 | 2021-07-10 04:21:25 | Iwate, Japan | ||
778376 | 778376 | 2021-07-08 | Japan | Iwate | 1754 | 47 | 1615 | 92 | 39.593287 | 141.361777 | 2021-07-09 04:21:21 | Iwate, Japan | ||
1440598 | 1440598 | 2021-07-07 | Japan | Iwate | 1746 | 47 | 1610 | 89 | 39.593287 | 141.361777 | 2021-07-08 04:21:26 | Iwate, Japan | ||
2693703 | 2693703 | 2021-07-06 | Japan | Iwate | 1737 | 47 | 1605 | 85 | 39.593287 | 141.361777 | 2021-07-07 04:21:20 | Iwate, Japan | ||
1932452 | 1932452 | 2021-07-05 | Japan | Iwate | 1730 | 47 | 1602 | 81 | 39.593287 | 141.361777 | 2021-07-06 04:21:32 | Iwate, Japan | ||
1165183 | 1165183 | 2021-07-04 | Japan | Iwate | 1713 | 47 | 1597 | 69 | 39.593287 | 141.361777 | 2021-07-05 04:21:28 | Iwate, Japan | ||
1495617 | 1495617 | 2021-07-03 | Japan | Iwate | 1707 | 47 | 1588 | 72 | 39.593287 | 141.361777 | 2021-07-04 04:21:38 | Iwate, Japan |
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]);