johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
3,495 rows where confirmed = 31 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
256981 | 256981 | 2022-09-08 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 31 | 0 | 0 | -7.9467 | -14.3559 | 2022-09-09 04:21:11 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | |||
3507499 | 3507499 | 2022-06-05 | Micronesia | 31 | 0 | 0 | 7.4256 | 150.5508 | 2022-06-06 04:20:57 | Micronesia | ||||
230794 | 230794 | 2022-05-31 | US | Maine | Unassigned | 90023 | 31 | 0 | 0 | 46.65926321 | 0.0 | 2022-06-01 04:20:55 | Unassigned, Maine, US | |
3188036 | 3188036 | 2022-05-30 | US | Nebraska | Arthur | 31005 | 31 | 1 | 0 | 41.56896142 | -101.6959559 | 2022-05-31 04:20:51 | Arthur, Nebraska, US | |
3200185 | 3200185 | 2022-05-29 | US | Nebraska | Arthur | 31005 | 31 | 1 | 0 | 41.56896142 | -101.6959559 | 2022-05-30 04:20:50 | Arthur, Nebraska, US | |
2727063 | 2727063 | 2022-05-28 | US | Nebraska | Arthur | 31005 | 31 | 1 | 0 | 41.56896142 | -101.6959559 | 2022-05-29 04:20:53 | Arthur, Nebraska, US | |
1316244 | 1316244 | 2022-05-27 | US | Nebraska | Arthur | 31005 | 31 | 1 | 0 | 41.56896142 | -101.6959559 | 2022-05-28 04:21:07 | Arthur, Nebraska, US | |
1852036 | 1852036 | 2022-05-26 | US | Nebraska | Arthur | 31005 | 31 | 1 | 0 | 41.56896142 | -101.6959559 | 2022-05-27 04:20:56 | Arthur, Nebraska, US | |
2049912 | 2049912 | 2022-05-25 | US | Nebraska | Arthur | 31005 | 31 | 1 | 0 | 41.56896142 | -101.6959559 | 2022-05-26 04:20:50 | Arthur, Nebraska, US | |
3001350 | 3001350 | 2022-05-24 | US | Nebraska | Arthur | 31005 | 31 | 1 | 0 | 41.56896142 | -101.6959559 | 2022-05-25 04:20:56 | Arthur, Nebraska, US | |
3595071 | 3595071 | 2022-05-23 | US | Nebraska | Arthur | 31005 | 31 | 1 | 0 | 41.56896142 | -101.6959559 | 2022-05-24 04:20:57 | Arthur, Nebraska, US | |
623923 | 623923 | 2022-05-22 | US | Nebraska | Arthur | 31005 | 31 | 1 | 0 | 41.56896142 | -101.6959559 | 2022-05-26 04:20:50 | Arthur, Nebraska, US | |
1111619 | 1111619 | 2022-05-21 | US | Nebraska | Arthur | 31005 | 31 | 1 | 0 | 41.56896142 | -101.6959559 | 2022-05-22 04:20:52 | Arthur, Nebraska, US | |
1171243 | 1171243 | 2022-05-20 | US | Nebraska | Arthur | 31005 | 31 | 1 | 0 | 41.56896142 | -101.6959559 | 2022-05-21 04:20:58 | Arthur, Nebraska, US | |
3898006 | 3898006 | 2022-05-19 | US | Nebraska | Arthur | 31005 | 31 | 1 | 0 | 41.56896142 | -101.6959559 | 2022-05-20 04:20:57 | Arthur, Nebraska, US | |
1186790 | 1186790 | 2022-05-18 | US | Nebraska | Arthur | 31005 | 31 | 1 | 0 | 41.56896142 | -101.6959559 | 2022-05-19 04:20:54 | Arthur, Nebraska, US | |
3584687 | 3584687 | 2022-05-17 | US | Nebraska | Arthur | 31005 | 31 | 1 | 0 | 41.56896142 | -101.6959559 | 2022-05-18 04:20:50 | Arthur, Nebraska, US | |
1505644 | 1505644 | 2022-05-16 | US | Nebraska | Arthur | 31005 | 31 | 1 | 0 | 41.56896142 | -101.6959559 | 2022-05-17 04:20:59 | Arthur, Nebraska, US | |
2086003 | 2086003 | 2022-05-15 | US | Nebraska | Arthur | 31005 | 31 | 1 | 0 | 41.56896142 | -101.6959559 | 2022-05-16 04:20:47 | Arthur, Nebraska, US | |
3356713 | 3356713 | 2022-05-14 | US | Nebraska | Arthur | 31005 | 31 | 1 | 0 | 41.56896142 | -101.6959559 | 2022-05-15 04:20:53 | Arthur, Nebraska, US | |
660358 | 660358 | 2022-05-13 | US | Nebraska | Arthur | 31005 | 31 | 1 | 0 | 41.56896142 | -101.6959559 | 2022-05-14 04:20:48 | Arthur, Nebraska, US | |
2535441 | 2535441 | 2022-05-12 | US | Nebraska | Arthur | 31005 | 31 | 1 | 0 | 41.56896142 | -101.6959559 | 2022-05-13 04:20:51 | Arthur, Nebraska, US | |
3446887 | 3446887 | 2022-05-11 | US | Nebraska | Arthur | 31005 | 31 | 1 | 0 | 41.56896142 | -101.6959559 | 2022-05-12 04:20:54 | Arthur, Nebraska, US | |
3537504 | 3537504 | 2022-05-10 | US | Nebraska | Arthur | 31005 | 31 | 1 | 0 | 41.56896142 | -101.6959559 | 2022-05-11 04:20:48 | Arthur, Nebraska, US | |
224039 | 224039 | 2022-05-09 | US | Nebraska | Arthur | 31005 | 31 | 1 | 0 | 41.56896142 | -101.6959559 | 2022-05-10 04:20:50 | Arthur, Nebraska, US | |
2333424 | 2333424 | 2022-05-08 | US | Nebraska | Arthur | 31005 | 31 | 1 | 0 | 41.56896142 | -101.6959559 | 2022-05-09 04:20:54 | Arthur, Nebraska, US | |
362386 | 362386 | 2022-05-07 | US | Nebraska | Arthur | 31005 | 31 | 1 | 0 | 41.56896142 | -101.6959559 | 2022-05-08 04:20:49 | Arthur, Nebraska, US | |
1399737 | 1399737 | 2022-05-06 | US | Nebraska | Arthur | 31005 | 31 | 1 | 0 | 41.56896142 | -101.6959559 | 2022-05-07 04:21:09 | Arthur, Nebraska, US | |
2600092 | 2600092 | 2022-05-05 | US | Nebraska | Arthur | 31005 | 31 | 1 | 0 | 41.56896142 | -101.6959559 | 2022-05-06 04:21:00 | Arthur, Nebraska, US | |
3267541 | 3267541 | 2022-05-04 | US | Nebraska | Arthur | 31005 | 31 | 1 | 0 | 41.56896142 | -101.6959559 | 2022-05-05 04:20:55 | Arthur, Nebraska, US | |
1574180 | 1574180 | 2022-05-03 | US | Nebraska | Arthur | 31005 | 31 | 1 | 0 | 41.56896142 | -101.6959559 | 2022-05-04 04:20:59 | Arthur, Nebraska, US | |
465440 | 465440 | 2022-05-02 | US | Nebraska | Arthur | 31005 | 31 | 1 | 0 | 41.56896142 | -101.6959559 | 2022-05-03 04:21:00 | Arthur, Nebraska, US | |
3918079 | 3918079 | 2022-05-01 | US | Nebraska | Arthur | 31005 | 31 | 1 | 0 | 41.56896142 | -101.6959559 | 2022-05-02 04:21:10 | Arthur, Nebraska, US | |
2842883 | 2842883 | 2022-04-30 | US | Nebraska | Arthur | 31005 | 31 | 1 | 0 | 41.56896142 | -101.6959559 | 2022-05-01 04:20:57 | Arthur, Nebraska, US | |
1159196 | 1159196 | 2022-04-29 | US | Nebraska | Arthur | 31005 | 31 | 1 | 0 | 41.56896142 | -101.6959559 | 2022-04-30 04:21:05 | Arthur, Nebraska, US | |
1698378 | 1698378 | 2022-04-28 | US | Nebraska | Arthur | 31005 | 31 | 1 | 0 | 41.56896142 | -101.6959559 | 2022-04-29 04:20:59 | Arthur, Nebraska, US | |
3853861 | 3853861 | 2022-04-27 | US | Nebraska | Arthur | 31005 | 31 | 1 | 0 | 41.56896142 | -101.6959559 | 2022-04-28 04:20:47 | Arthur, Nebraska, US | |
1328291 | 1328291 | 2022-04-26 | US | Nebraska | Arthur | 31005 | 31 | 1 | 0 | 41.56896142 | -101.6959559 | 2022-04-27 04:20:52 | Arthur, Nebraska, US | |
3206398 | 3206398 | 2022-04-11 | Netherlands | Unknown | 31 | 0 | 0 | 2022-02-28 23:21:00 | Unknown, Netherlands | |||||
1865283 | 1865283 | 2022-03-10 | China | Qinghai | 31 | 0 | 0 | 35.7452 | 95.9956 | 2022-03-11 04:20:50 | Qinghai, China | |||
1781405 | 1781405 | 2022-01-27 | US | Montana | Petroleum | 30069 | 31 | 1 | 0 | 47.118246299999996 | -108.2508876 | 2022-01-28 04:21:09 | Petroleum, Montana, US | |
1320233 | 1320233 | 2022-01-26 | US | Montana | Petroleum | 30069 | 31 | 1 | 0 | 47.118246299999996 | -108.2508876 | 2022-01-27 04:21:19 | Petroleum, Montana, US | |
2053901 | 2053901 | 2022-01-25 | US | Montana | Petroleum | 30069 | 31 | 1 | 0 | 47.118246299999996 | -108.2508876 | 2022-01-26 04:21:07 | Petroleum, Montana, US | |
1229632 | 1229632 | 2022-01-24 | US | Montana | Petroleum | 30069 | 31 | 1 | 0 | 47.118246299999996 | -108.2508876 | 2022-01-25 04:21:05 | Petroleum, Montana, US | |
3475 | 3475 | 2021-12-02 | US | Texas | King | 48269 | 31 | 0 | 0 | 33.61643847 | -100.2558057 | 2021-12-03 04:23:05 | King, Texas, US | |
1148074 | 1148074 | 2021-12-01 | US | Texas | King | 48269 | 31 | 0 | 0 | 33.61643847 | -100.2558057 | 2021-12-02 04:22:37 | King, Texas, US | |
3404586 | 3404586 | 2021-11-30 | US | Texas | King | 48269 | 31 | 0 | 0 | 33.61643847 | -100.2558057 | 2021-12-01 04:22:29 | King, Texas, US | |
153129 | 153129 | 2021-11-29 | US | Texas | King | 48269 | 31 | 0 | 0 | 33.61643847 | -100.2558057 | 2021-11-30 04:22:53 | King, Texas, US | |
3345912 | 3345912 | 2021-11-16 | US | Vermont | Unassigned | 90050 | 31 | 0 | 0 | 44.85627605 | 0.0 | 2021-11-17 04:21:48 | Unassigned, Vermont, US | |
2003952 | 2003952 | 2021-11-07 | US | Vermont | Unassigned | 90050 | 31 | 0 | 0 | 44.85627605 | 0.0 | 2021-11-08 04:21:43 | Unassigned, Vermont, US | |
773639 | 773639 | 2021-10-23 | US | Vermont | Unassigned | 90050 | 31 | 0 | 0 | 44.85627605 | 0.0 | 2021-10-24 04:21:22 | Unassigned, Vermont, US | |
986863 | 986863 | 2021-10-04 | France | Saint Pierre and Miquelon | 31 | 0 | 0 | 46.8852 | -56.3159 | 2021-10-05 04:21:27 | Saint Pierre and Miquelon, France | |||
1274173 | 1274173 | 2021-10-03 | France | Saint Pierre and Miquelon | 31 | 0 | 0 | 46.8852 | -56.3159 | 2021-10-04 04:21:31 | Saint Pierre and Miquelon, France | |||
3927926 | 3927926 | 2021-10-02 | France | Saint Pierre and Miquelon | 31 | 0 | 0 | 46.8852 | -56.3159 | 2021-10-03 04:21:24 | Saint Pierre and Miquelon, France | |||
2131906 | 2131906 | 2021-10-01 | France | Saint Pierre and Miquelon | 31 | 0 | 0 | 46.8852 | -56.3159 | 2021-10-02 04:21:25 | Saint Pierre and Miquelon, France | |||
2772863 | 2772863 | 2021-09-30 | France | Saint Pierre and Miquelon | 31 | 0 | 0 | 46.8852 | -56.3159 | 2021-10-01 04:21:35 | Saint Pierre and Miquelon, France | |||
706319 | 706319 | 2021-09-29 | France | Saint Pierre and Miquelon | 31 | 0 | 0 | 46.8852 | -56.3159 | 2021-09-30 04:21:20 | Saint Pierre and Miquelon, France | |||
1334161 | 1334161 | 2021-09-28 | France | Saint Pierre and Miquelon | 31 | 0 | 0 | 46.8852 | -56.3159 | 2021-09-29 04:21:45 | Saint Pierre and Miquelon, France | |||
1237689 | 1237689 | 2021-09-27 | US | Nebraska | Blaine | 31009 | 31 | 0 | 0 | 41.91311716 | -99.97677845 | 2021-09-28 04:21:28 | Blaine, Nebraska, US | |
1235530 | 1235530 | 2021-09-27 | France | Saint Pierre and Miquelon | 31 | 0 | 0 | 46.8852 | -56.3159 | 2021-09-28 04:21:28 | Saint Pierre and Miquelon, France | |||
2077990 | 2077990 | 2021-09-26 | US | Nebraska | Blaine | 31009 | 31 | 0 | 0 | 41.91311716 | -99.97677845 | 2021-09-27 04:21:16 | Blaine, Nebraska, US | |
2075831 | 2075831 | 2021-09-26 | France | Saint Pierre and Miquelon | 31 | 0 | 0 | 46.8852 | -56.3159 | 2021-09-27 04:21:16 | Saint Pierre and Miquelon, France | |||
1726542 | 1726542 | 2021-09-25 | US | Nebraska | Blaine | 31009 | 31 | 0 | 0 | 41.91311716 | -99.97677845 | 2021-09-26 04:21:29 | Blaine, Nebraska, US | |
1724383 | 1724383 | 2021-09-25 | France | Saint Pierre and Miquelon | 31 | 0 | 0 | 46.8852 | -56.3159 | 2021-09-26 04:21:29 | Saint Pierre and Miquelon, France | |||
1921103 | 1921103 | 2021-09-24 | France | Saint Pierre and Miquelon | 31 | 0 | 0 | 46.8852 | -56.3159 | 2021-09-25 04:21:31 | Saint Pierre and Miquelon, France | |||
601574 | 601574 | 2021-09-23 | France | Saint Pierre and Miquelon | 31 | 0 | 0 | 46.8852 | -56.3159 | 2021-09-24 04:21:44 | Saint Pierre and Miquelon, France | |||
3011235 | 3011235 | 2021-09-22 | France | Saint Pierre and Miquelon | 31 | 0 | 0 | 46.8852 | -56.3159 | 2021-09-23 04:21:43 | Saint Pierre and Miquelon, France | |||
3757373 | 3757373 | 2021-09-21 | France | Saint Pierre and Miquelon | 31 | 0 | 0 | 46.8852 | -56.3159 | 2021-09-22 04:21:45 | Saint Pierre and Miquelon, France | |||
809476 | 809476 | 2021-09-20 | France | Saint Pierre and Miquelon | 31 | 0 | 0 | 46.8852 | -56.3159 | 2021-09-21 04:21:26 | Saint Pierre and Miquelon, France | |||
1814675 | 1814675 | 2021-09-19 | France | Saint Pierre and Miquelon | 31 | 0 | 0 | 46.8852 | -56.3159 | 2021-09-20 04:21:22 | Saint Pierre and Miquelon, France | |||
16255 | 16255 | 2021-09-18 | France | Saint Pierre and Miquelon | 31 | 0 | 0 | 46.8852 | -56.3159 | 2021-09-19 04:21:34 | Saint Pierre and Miquelon, France | |||
2617940 | 2617940 | 2021-09-17 | France | Saint Pierre and Miquelon | 31 | 0 | 0 | 46.8852 | -56.3159 | 2021-09-18 04:21:24 | Saint Pierre and Miquelon, France | |||
2812406 | 2812406 | 2021-09-16 | United Kingdom | Montserrat | 31 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-09-17 04:21:46 | Montserrat, United Kingdom | |||
2808648 | 2808648 | 2021-09-16 | France | Saint Pierre and Miquelon | 31 | 0 | 0 | 46.8852 | -56.3159 | 2021-09-17 04:21:46 | Saint Pierre and Miquelon, France | |||
1378150 | 1378150 | 2021-09-15 | United Kingdom | Montserrat | 31 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-09-16 04:22:19 | Montserrat, United Kingdom | |||
1374393 | 1374393 | 2021-09-15 | France | Saint Pierre and Miquelon | 31 | 0 | 0 | 46.8852 | -56.3159 | 2021-09-16 04:22:19 | Saint Pierre and Miquelon, France | |||
2466449 | 2466449 | 2021-09-14 | United Kingdom | Montserrat | 31 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-09-15 03:22:37 | Montserrat, United Kingdom | |||
2464479 | 2464479 | 2021-09-14 | US | Michigan | Unassigned | 90026 | 31 | 0 | 0 | 47.63197653 | 0.0 | 2021-09-15 03:22:37 | Unassigned, Michigan, US | |
2462692 | 2462692 | 2021-09-14 | France | Saint Pierre and Miquelon | 31 | 0 | 0 | 46.8852 | -56.3159 | 2021-09-15 03:22:37 | Saint Pierre and Miquelon, France | |||
1389288 | 1389288 | 2021-09-13 | United Kingdom | Montserrat | 31 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-09-14 04:21:41 | Montserrat, United Kingdom | |||
1387318 | 1387318 | 2021-09-13 | US | Michigan | Unassigned | 90026 | 31 | 0 | 0 | 47.63197653 | 0.0 | 2021-09-14 04:21:41 | Unassigned, Michigan, US | |
1385531 | 1385531 | 2021-09-13 | France | Saint Pierre and Miquelon | 31 | 0 | 0 | 46.8852 | -56.3159 | 2021-09-14 04:21:41 | Saint Pierre and Miquelon, France | |||
1888657 | 1888657 | 2021-09-12 | United Kingdom | Montserrat | 31 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-09-13 04:21:15 | Montserrat, United Kingdom | |||
1884900 | 1884900 | 2021-09-12 | France | Saint Pierre and Miquelon | 31 | 0 | 0 | 46.8852 | -56.3159 | 2021-09-13 04:21:15 | Saint Pierre and Miquelon, France | |||
3809560 | 3809560 | 2021-09-11 | United Kingdom | Montserrat | 31 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-09-12 04:21:13 | Montserrat, United Kingdom | |||
3805803 | 3805803 | 2021-09-11 | France | Saint Pierre and Miquelon | 31 | 0 | 0 | 46.8852 | -56.3159 | 2021-09-12 04:21:13 | Saint Pierre and Miquelon, France | |||
3452500 | 3452500 | 2021-09-10 | United Kingdom | Montserrat | 31 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-09-11 04:21:30 | Montserrat, United Kingdom | |||
3448743 | 3448743 | 2021-09-10 | France | Saint Pierre and Miquelon | 31 | 0 | 0 | 46.8852 | -56.3159 | 2021-09-11 04:21:30 | Saint Pierre and Miquelon, France | |||
1266446 | 1266446 | 2021-09-09 | United Kingdom | Montserrat | 31 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-09-10 04:21:20 | Montserrat, United Kingdom | |||
1264476 | 1264476 | 2021-09-09 | US | Michigan | Unassigned | 90026 | 31 | 0 | 0 | 47.63197653 | 0.0 | 2021-09-10 04:21:20 | Unassigned, Michigan, US | |
1262689 | 1262689 | 2021-09-09 | France | Saint Pierre and Miquelon | 31 | 0 | 0 | 46.8852 | -56.3159 | 2021-09-10 04:21:20 | Saint Pierre and Miquelon, France | |||
2282816 | 2282816 | 2021-09-08 | United Kingdom | Montserrat | 31 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-09-09 04:21:27 | Montserrat, United Kingdom | |||
2280846 | 2280846 | 2021-09-08 | US | Michigan | Unassigned | 90026 | 31 | 0 | 0 | 47.63197653 | 0.0 | 2021-09-09 04:21:27 | Unassigned, Michigan, US | |
2279059 | 2279059 | 2021-09-08 | France | Saint Pierre and Miquelon | 31 | 0 | 0 | 46.8852 | -56.3159 | 2021-09-09 04:21:27 | Saint Pierre and Miquelon, France | |||
645595 | 645595 | 2021-09-07 | United Kingdom | Montserrat | 31 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-09-08 04:21:31 | Montserrat, United Kingdom | |||
641838 | 641838 | 2021-09-07 | France | Saint Pierre and Miquelon | 31 | 0 | 0 | 46.8852 | -56.3159 | 2021-09-08 04:21:31 | Saint Pierre and Miquelon, France | |||
3197658 | 3197658 | 2021-09-06 | United Kingdom | Montserrat | 31 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-09-07 04:21:35 | Montserrat, United Kingdom | |||
3193901 | 3193901 | 2021-09-06 | France | Saint Pierre and Miquelon | 31 | 0 | 0 | 46.8852 | -56.3159 | 2021-09-07 04:21:35 | Saint Pierre and Miquelon, France | |||
3284526 | 3284526 | 2021-09-05 | United Kingdom | Montserrat | 31 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-09-06 04:21:22 | Montserrat, United Kingdom | |||
3280769 | 3280769 | 2021-09-05 | France | Saint Pierre and Miquelon | 31 | 0 | 0 | 46.8852 | -56.3159 | 2021-09-06 04:21:22 | Saint Pierre and Miquelon, France |
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]);