daily_reports (view)

⚠️ This table has been renamed. Use johns_hopkins_csse_daily_reports instead.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

948 rows where active = 185 sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

These facets timed out: province_or_state

day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2021-07-29 Japan Port Quarantine     3476 6 3287 185     2021-07-30 04:21:34 Port Quarantine, Japan
2021-07-29 Germany Sachsen-Anhalt     99479 3451 95900 185 51.9503 11.6923 2021-07-30 04:21:34 Sachsen-Anhalt, Germany
2021-07-27 Japan Kumamoto     6705 121 6399 185 32.608154 130.74523100000002 2021-07-28 04:21:39 Kumamoto, Japan
2021-07-22 India Madhya Pradesh     791721 10512 781024 185 23.541513 78.289633 2021-07-23 04:21:29 Madhya Pradesh, India
2021-07-21 India Madhya Pradesh     791704 10512 781007 185 23.541513 78.289633 2021-07-22 04:21:19 Madhya Pradesh, India
2021-07-19 Central African Republic       7142 98 6859 185 6.6111 20.9394 2021-07-20 04:21:48 Central African Republic
2021-07-18 Central African Republic       7142 98 6859 185 6.6111 20.9394 2021-07-19 04:21:24 Central African Republic
2021-07-17 Central African Republic       7142 98 6859 185 6.6111 20.9394 2021-07-18 04:22:07 Central African Republic
2021-07-16 Central African Republic       7142 98 6859 185 6.6111 20.9394 2021-07-17 04:22:22 Central African Republic
2021-07-15 Netherlands Curacao     12537 126 12226 185 12.1696 -68.99 2021-07-16 04:21:22 Curacao, Netherlands
2021-07-15 Central African Republic       7142 98 6859 185 6.6111 20.9394 2021-07-16 04:21:22 Central African Republic
2021-07-14 Central African Republic       7142 98 6859 185 6.6111 20.9394 2021-07-15 04:21:48 Central African Republic
2021-07-13 Italy Liguria     103630 4352 99093 185 44.41149315 8.9326992 2021-07-14 04:21:35 Liguria, Italy
2021-07-13 Central African Republic       7142 98 6859 185 6.6111 20.9394 2021-07-14 04:21:35 Central African Republic
2021-07-12 Central African Republic       7142 98 6859 185 6.6111 20.9394 2021-07-13 04:21:18 Central African Republic
2021-07-11 Central African Republic       7142 98 6859 185 6.6111 20.9394 2021-07-12 04:21:34 Central African Republic
2021-07-10 Central African Republic       7142 98 6859 185 6.6111 20.9394 2021-07-11 04:21:43 Central African Republic
2021-07-09 Ukraine Vinnytsia Oblast     71191 1693 69313 185 49.2331 28.4682 2021-07-10 04:21:25 Vinnytsia Oblast, Ukraine
2021-07-09 Central African Republic       7142 98 6859 185 6.6111 20.9394 2021-07-10 04:21:25 Central African Republic
2021-07-08 Central African Republic       7142 98 6859 185 6.6111 20.9394 2021-07-09 04:21:21 Central African Republic
2021-07-06 Ukraine Ternopil Oblast     70065 1201 68679 185 49.5535 25.5948 2021-07-07 04:21:20 Ternopil Oblast, Ukraine
2021-07-05 Italy Friuli Venezia Giulia     106998 3789 103024 185 45.6494354 13.76813649 2021-07-06 04:21:32 Friuli Venezia Giulia, Italy
2021-06-26 Italy P.A. Bolzano     73287 1180 71922 185 46.49933453 11.35662422 2021-06-27 04:21:39 P.A. Bolzano, Italy
2021-06-11 Japan Gunma     7970 148 7637 185 36.504479 138.985605 2021-06-12 04:22:22 Gunma, Japan
2021-06-07 Canada Nova Scotia     5680 88 5407 185 44.682 -63.7443 2021-06-08 04:22:35 Nova Scotia, Canada
2021-05-30 Japan Yamagata     1956 41 1730 185 38.448396 140.102154 2021-05-31 03:08:59 Yamagata, Japan
2021-05-27 Eritrea       4010 14 3811 185 15.1794 39.7823 2021-05-28 04:20:36 Eritrea
2021-05-26 Guinea-Bissau       3753 68 3500 185 11.8037 -15.1804 2021-05-27 04:20:59 Guinea-Bissau
2021-05-25 Guinea-Bissau       3753 68 3500 185 11.8037 -15.1804 2021-05-26 04:20:35 Guinea-Bissau
2021-05-25 Eritrea       3948 14 3749 185 15.1794 39.7823 2021-05-26 04:20:35 Eritrea
2021-05-15 Niger       5330 192 4953 185 17.607789 8.081666 2021-05-16 04:20:49 Niger
2021-05-08 Japan Port Quarantine     2825 3 2637 185     2021-05-09 04:20:35 Port Quarantine, Japan
2021-05-05 Japan Yamagata     1571 34 1352 185 38.448396 140.102154 2021-05-06 04:20:38 Yamagata, Japan
2021-05-02 Liechtenstein       3033 56 2792 185 47.14 9.55 2021-05-03 04:20:39 Liechtenstein
2021-04-25 Eritrea       3605 10 3410 185 15.1794 39.7823 2021-04-26 04:21:04 Eritrea
2021-04-24 Eritrea       3605 10 3410 185 15.1794 39.7823 2021-04-25 04:20:32 Eritrea
2021-04-23 Eritrea       3605 10 3410 185 15.1794 39.7823 2021-04-24 04:20:38 Eritrea
2021-04-22 Mauritania       18192 454 17553 185 21.0079 -10.9408 2021-04-23 04:20:52 Mauritania
2021-04-22 Japan Yamaguchi     1639 43 1411 185 34.201190000000004 131.573293 2021-04-23 04:20:52 Yamaguchi, Japan
2021-04-18 Japan Aomori     1305 20 1100 185 40.781541 140.828896 2021-04-19 04:20:57 Aomori, Japan
2021-04-16 Mauritania       18103 452 17466 185 21.0079 -10.9408 2021-04-17 04:20:40 Mauritania
2021-04-15 Russia Khakassia Republic     22062 517 21360 185 53.72258845 91.44293627 2021-04-16 04:20:46 Khakassia Republic, Russia
2021-04-15 Chad       4673 168 4320 185 15.4542 18.7322 2021-04-16 04:20:46 Chad
2021-04-14 Russia Khakassia Republic     22044 514 21345 185 53.72258845 91.44293627 2021-04-15 04:20:54 Khakassia Republic, Russia
2021-03-30 Eswatini       17333 667 16481 185 -26.5225 31.4659 2021-03-31 04:26:25 Eswatini
2021-03-27 Japan Tochigi     4526 70 4271 185 36.689912 139.819213 2021-03-28 05:28:10 Tochigi, Japan
2021-03-13 Japan Kyoto     9190 164 8841 185 35.253815 135.443341 2021-03-14 05:25:37 Kyoto, Japan
2021-03-09 Japan Shizuoka     5281 99 4997 185 34.916975 138.40778400000002 2021-03-10 05:24:35 Shizuoka, Japan
2021-03-06 US Texas Jeff Davis 48243 175 2 0 185 30.71490589 -104.1399973 2021-03-07 05:21:54 Jeff Davis, Texas, US
2021-03-06 US Hawaii Kauai 15007 186 1 0 185 22.03935037 -159.5966786 2021-03-07 05:21:54 Kauai, Hawaii, US
2021-03-05 US Texas Jeff Davis 48243 175 2 0 185 30.71490589 -104.1399973 2021-03-06 04:23:41 Jeff Davis, Texas, US
2021-03-05 US Hawaii Kauai 15007 186 1 0 185 22.03935037 -159.5966786 2021-03-06 04:23:41 Kauai, Hawaii, US
2021-03-04 US Hawaii Kauai 15007 186 1 0 185 22.03935037 -159.5966786 2021-03-05 05:26:29 Kauai, Hawaii, US
2021-03-03 US Texas Jeff Davis 48243 175 2 0 185 30.71490589 -104.1399973 2021-03-04 05:24:24 Jeff Davis, Texas, US
2021-03-01 US Colorado Costilla 8023 193 2 0 185 37.27732493 -105.4276548 2021-03-02 05:23:30 Costilla, Colorado, US
2021-02-28 US Colorado Costilla 8023 190 2 0 185 37.27732493 -105.4276548 2021-03-01 05:23:01 Costilla, Colorado, US
2021-02-28 India Puducherry     39725 668 38872 185 11.882658 78.86498 2021-03-01 05:23:01 Puducherry, India
2021-02-27 US Colorado Costilla 8023 190 2 0 185 37.27732493 -105.4276548 2021-02-28 05:22:20 Costilla, Colorado, US
2021-02-24 Japan Tochigi     4060 65 3810 185 36.689912 139.819213 2021-02-25 05:24:57 Tochigi, Japan
2021-02-22 US Nebraska Frontier 31063 186 1 0 185 40.52993007 -100.3924658 2021-02-23 05:23:41 Frontier, Nebraska, US
2021-02-21 US Nebraska Frontier 31063 186 1 0 185 40.52993007 -100.3924658 2021-02-22 05:24:21 Frontier, Nebraska, US
2021-02-20 US Puerto Rico Jayuya 72073 185 0 0 185 18.211446 -66.58878 2021-02-21 05:24:33 Jayuya, Puerto Rico, US
2021-02-20 US Nebraska Frontier 31063 186 1 0 185 40.52993007 -100.3924658 2021-02-21 05:24:33 Frontier, Nebraska, US
2021-02-19 US Puerto Rico Jayuya 72073 185 0 0 185 18.211446 -66.58878 2021-02-20 05:22:51 Jayuya, Puerto Rico, US
2021-02-19 US Nebraska Frontier 31063 186 1 0 185 40.52993007 -100.3924658 2021-02-20 05:22:51 Frontier, Nebraska, US
2021-02-18 US Puerto Rico Jayuya 72073 185 0 0 185 18.211446 -66.58878 2021-02-19 05:24:16 Jayuya, Puerto Rico, US
2021-02-18 US Montana Daniels 30019 192 7 0 185 48.78420029 -105.54763429999998 2021-02-19 05:24:16 Daniels, Montana, US
2021-02-18 Japan Ishikawa     1743 60 1498 185 36.769464 136.771027 2021-02-19 05:24:16 Ishikawa, Japan
2021-02-17 US Puerto Rico Jayuya 72073 185 0 0 185 18.211446 -66.58878 2021-02-18 05:22:58 Jayuya, Puerto Rico, US
2021-02-17 US Montana Daniels 30019 192 7 0 185 48.78420029 -105.54763429999998 2021-02-18 05:22:58 Daniels, Montana, US
2021-02-16 US Puerto Rico Jayuya 72073 185 0 0 185 18.211446 -66.58878 2021-02-17 05:23:10 Jayuya, Puerto Rico, US
2021-02-16 US Montana Daniels 30019 192 7 0 185 48.78420029 -105.54763429999998 2021-02-17 05:23:10 Daniels, Montana, US
2021-02-16 US Kansas Hodgeman 20083 192 7 0 185 38.08780079 -99.89829881 2021-02-17 05:23:10 Hodgeman, Kansas, US
2021-02-15 US Puerto Rico Jayuya 72073 185 0 0 185 18.211446 -66.58878 2021-02-16 05:24:38 Jayuya, Puerto Rico, US
2021-02-15 US Montana Daniels 30019 192 7 0 185 48.78420029 -105.54763429999998 2021-02-16 05:24:38 Daniels, Montana, US
2021-02-15 US Kansas Hodgeman 20083 192 7 0 185 38.08780079 -99.89829881 2021-02-16 05:24:38 Hodgeman, Kansas, US
2021-02-14 US Montana Daniels 30019 192 7 0 185 48.78420029 -105.54763429999998 2021-02-15 05:24:49 Daniels, Montana, US
2021-02-14 US Kansas Hodgeman 20083 192 7 0 185 38.08780079 -99.89829881 2021-02-15 05:24:49 Hodgeman, Kansas, US
2021-02-13 US Montana Daniels 30019 192 7 0 185 48.78420029 -105.54763429999998 2021-02-14 05:23:43 Daniels, Montana, US
2021-02-13 US Kansas Hodgeman 20083 192 7 0 185 38.08780079 -99.89829881 2021-02-14 05:23:43 Hodgeman, Kansas, US
2021-02-13 Japan Shiga     2305 39 2081 185 35.21582700000001 136.138064 2021-02-14 05:23:43 Shiga, Japan
2021-02-12 US Montana Daniels 30019 192 7 0 185 48.78420029 -105.54763429999998 2021-02-13 05:22:12 Daniels, Montana, US
2021-02-12 US Kansas Hodgeman 20083 192 7 0 185 38.08780079 -99.89829881 2021-02-13 05:22:12 Hodgeman, Kansas, US
2021-02-11 US Montana Daniels 30019 192 7 0 185 48.78420029 -105.54763429999998 2021-02-12 05:23:29 Daniels, Montana, US
2021-02-11 US Delaware Unassigned 90010 185 0 0 185 39.57992638 0.0 2021-02-12 05:23:29 Unassigned, Delaware, US
2021-02-10 US Montana Daniels 30019 192 7 0 185 48.78420029 -105.54763429999998 2021-02-11 05:23:55 Daniels, Montana, US
2021-02-09 US Montana Daniels 30019 192 7 0 185 48.78420029 -105.54763429999998 2021-02-10 05:22:41 Daniels, Montana, US
2021-02-09 US Kansas Jewell 20089 189 4 0 185 39.78470589 -98.21820662 2021-02-10 05:22:41 Jewell, Kansas, US
2021-02-08 US Kansas Jewell 20089 189 4 0 185 39.78470589 -98.21820662 2021-02-09 05:23:30 Jewell, Kansas, US
2021-02-08 US Idaho Butte 16023 186 1 0 185 43.72592209 -113.1735463 2021-02-09 05:23:30 Butte, Idaho, US
2021-02-07 US Idaho Butte 16023 186 1 0 185 43.72592209 -113.1735463 2021-02-08 05:22:39 Butte, Idaho, US
2021-02-07 Japan Miyagi     3477 22 3270 185 38.446859 140.927086 2021-02-08 05:22:39 Miyagi, Japan
2021-02-06 US Idaho Butte 16023 186 1 0 185 43.72592209 -113.1735463 2021-02-07 05:23:00 Butte, Idaho, US
2021-02-05 US Idaho Butte 16023 186 1 0 185 43.72592209 -113.1735463 2021-02-06 05:23:55 Butte, Idaho, US
2021-02-04 US Idaho Butte 16023 186 1 0 185 43.72592209 -113.1735463 2021-02-05 05:22:38 Butte, Idaho, US
2021-02-03 US Montana Daniels 30019 191 6 0 185 48.78420029 -105.54763429999998 2021-02-04 05:22:26 Daniels, Montana, US
2021-02-02 US Montana Daniels 30019 191 6 0 185 48.78420029 -105.54763429999998 2021-02-03 05:22:52 Daniels, Montana, US
2021-01-31 US Nebraska Pawnee 31133 186 1 0 185 40.13141096 -96.23705437 2021-02-01 05:22:53 Pawnee, Nebraska, US
2021-01-31 US Montana Granite 30039 187 2 0 185 46.40605220000001 -113.4414186 2021-02-01 05:22:53 Granite, Montana, US
2021-01-30 US Nebraska Pawnee 31133 186 1 0 185 40.13141096 -96.23705437 2021-01-31 05:22:42 Pawnee, Nebraska, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;