johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
2,918 rows where active = 41 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: last_update (date)
These facets timed out: province_or_state
country_or_region >30
- US 2,568
- Japan 71
- China 44
- Malaysia 25
- Colombia 21
- India 20
- Germany 11
- Central African Republic 10
- Canada 9
- Liberia 7
- Monaco 7
- Netherlands 7
- Russia 7
- United Kingdom 7
- Libya 6
- Comoros 5
- Denmark 5
- Taiwan* 5
- Australia 4
- Chile 4
- Djibouti 4
- Italy 4
- New Zealand 4
- Sao Tome and Principe 4
- Vietnam 4
- Brunei 3
- Cuba 3
- Equatorial Guinea 3
- France 3
- Spain 3
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3015351 | 3015351 | 2021-08-01 | Japan | Akita | 1021 | 20 | 960 | 41 | 39.748679 | 140.408228 | 2021-08-02 04:21:36 | Akita, Japan | ||
3015151 | 3015151 | 2021-08-01 | China | Fujian | 741 | 1 | 699 | 41 | 26.0789 | 117.9874 | 2021-08-02 04:21:36 | Fujian, China | ||
3903974 | 3903974 | 2021-07-31 | Japan | Akita | 1020 | 20 | 959 | 41 | 39.748679 | 140.408228 | 2021-08-01 04:21:50 | Akita, Japan | ||
3903849 | 3903849 | 2021-07-31 | Denmark | Greenland | 119 | 0 | 78 | 41 | 71.7069 | -42.6043 | 2021-08-01 04:21:50 | Greenland, Denmark | ||
3903774 | 3903774 | 2021-07-31 | China | Fujian | 737 | 1 | 695 | 41 | 26.0789 | 117.9874 | 2021-08-01 04:21:50 | Fujian, China | ||
411974 | 411974 | 2021-07-28 | Malaysia | Perlis | 665 | 8 | 616 | 41 | 6.4449 | 100.2048 | 2021-07-29 04:21:33 | Perlis, Malaysia | ||
408237 | 408237 | 2021-07-28 | India | Dadra and Nagar Haveli and Daman and Diu | 10642 | 4 | 10597 | 41 | 20.194742 | 73.080901 | 2021-07-29 04:21:33 | Dadra and Nagar Haveli and Daman and Diu, India | ||
1306171 | 1306171 | 2021-07-27 | Japan | Kagawa | 2170 | 32 | 2097 | 41 | 34.217292 | 133.969047 | 2021-07-28 04:21:39 | Kagawa, Japan | ||
1378554 | 1378554 | 2021-07-25 | Japan | Yamaguchi | 3211 | 80 | 3090 | 41 | 34.201190000000004 | 131.573293 | 2021-07-26 04:21:28 | Yamaguchi, Japan | ||
1330072 | 1330072 | 2021-07-24 | China | Sichuan | 1139 | 3 | 1095 | 41 | 30.6171 | 102.7103 | 2021-07-25 04:22:12 | Sichuan, China | ||
3137352 | 3137352 | 2021-07-23 | China | Fujian | 715 | 1 | 673 | 41 | 26.0789 | 117.9874 | 2021-07-24 00:21:36 | Fujian, China | ||
3137306 | 3137306 | 2021-07-23 | Brunei | 313 | 3 | 269 | 41 | 4.5353 | 114.7277 | 2021-07-24 00:21:36 | Brunei | |||
3331471 | 3331471 | 2021-07-21 | India | Chandigarh | 61914 | 809 | 61064 | 41 | 30.733839 | 76.76827800000002 | 2021-07-22 04:21:19 | Chandigarh, India | ||
3331285 | 3331285 | 2021-07-21 | Brunei | 305 | 3 | 261 | 41 | 4.5353 | 114.7277 | 2021-07-22 04:21:19 | Brunei | |||
2371266 | 2371266 | 2021-07-20 | Brunei | 305 | 3 | 261 | 41 | 4.5353 | 114.7277 | 2021-07-21 04:21:40 | Brunei | |||
2673817 | 2673817 | 2021-07-18 | Japan | Ehime | 2794 | 75 | 2678 | 41 | 33.624835 | 132.856842 | 2021-07-19 04:21:24 | Ehime, Japan | ||
2673614 | 2673614 | 2021-07-18 | China | Fujian | 709 | 1 | 667 | 41 | 26.0789 | 117.9874 | 2021-07-19 04:21:24 | Fujian, China | ||
3706145 | 3706145 | 2021-07-17 | Japan | Kumamoto | 6526 | 119 | 6366 | 41 | 32.608154 | 130.74523100000002 | 2021-07-18 04:22:07 | Kumamoto, Japan | ||
3705950 | 3705950 | 2021-07-17 | China | Sichuan | 1125 | 3 | 1081 | 41 | 30.6171 | 102.7103 | 2021-07-18 04:22:07 | Sichuan, China | ||
578633 | 578633 | 2021-07-13 | China | Fujian | 699 | 1 | 657 | 41 | 26.0789 | 117.9874 | 2021-07-14 04:21:35 | Fujian, China | ||
3741111 | 3741111 | 2021-07-12 | Japan | Okayama | 7622 | 126 | 7455 | 41 | 34.89246 | 133.826252 | 2021-07-13 04:21:18 | Okayama, Japan | ||
3659395 | 3659395 | 2021-07-11 | China | Fujian | 696 | 1 | 654 | 41 | 26.0789 | 117.9874 | 2021-07-12 04:21:34 | Fujian, China | ||
829606 | 829606 | 2021-07-09 | Japan | Gunma | 8071 | 154 | 7876 | 41 | 36.504479 | 138.985605 | 2021-07-10 04:21:25 | Gunma, Japan | ||
1440718 | 1440718 | 2021-07-07 | New Zealand | 2764 | 28 | 2697 | 41 | -40.9006 | 174.886 | 2021-07-08 04:21:26 | New Zealand | |||
2693396 | 2693396 | 2021-07-06 | Barbados | 4096 | 47 | 4008 | 41 | 13.1939 | -59.5432 | 2021-07-07 04:21:20 | Barbados | |||
1499257 | 1499257 | 2021-07-03 | United Kingdom | Gibraltar | 4364 | 94 | 4229 | 41 | 36.1408 | -5.3536 | 2021-07-04 04:21:38 | Gibraltar, United Kingdom | ||
1495545 | 1495545 | 2021-07-03 | India | Dadra and Nagar Haveli and Daman and Diu | 10567 | 4 | 10522 | 41 | 20.194742 | 73.080901 | 2021-07-04 04:21:38 | Dadra and Nagar Haveli and Daman and Diu, India | ||
1893169 | 1893169 | 2021-06-30 | Japan | Niigata | 3401 | 52 | 3308 | 41 | 37.521819 | 138.918647 | 2021-07-01 04:21:19 | Niigata, Japan | ||
400292 | 400292 | 2021-06-29 | Japan | Niigata | 3398 | 52 | 3305 | 41 | 37.521819 | 138.918647 | 2021-06-30 04:21:41 | Niigata, Japan | ||
3125208 | 3125208 | 2021-06-28 | Australia | Victoria | 20710 | 820 | 19849 | 41 | -37.8136 | 144.9631 | 2021-06-29 04:21:28 | Victoria, Australia | ||
2589834 | 2589834 | 2021-06-27 | Colombia | Amazonas | 6389 | 244 | 6104 | 41 | -1.4429 | -71.5724 | 2021-06-28 04:21:29 | Amazonas, Colombia | ||
3958535 | 3958535 | 2021-06-26 | Japan | Oita | 3491 | 62 | 3388 | 41 | 33.200697 | 131.43323999999998 | 2021-06-27 04:21:39 | Oita, Japan | ||
3958331 | 3958331 | 2021-06-26 | China | Sichuan | 1091 | 3 | 1047 | 41 | 30.6171 | 102.7103 | 2021-06-27 04:21:39 | Sichuan, China | ||
2295477 | 2295477 | 2021-06-24 | Japan | Nara | 8096 | 128 | 7927 | 41 | 34.317451 | 135.871644 | 2021-06-25 04:21:33 | Nara, Japan | ||
2295218 | 2295218 | 2021-06-24 | Canada | New Brunswick | 2322 | 45 | 2236 | 41 | 46.5653 | -66.4619 | 2021-06-25 04:21:33 | New Brunswick, Canada | ||
562792 | 562792 | 2021-06-22 | China | Sichuan | 1076 | 3 | 1032 | 41 | 30.6171 | 102.7103 | 2021-06-23 04:21:46 | Sichuan, China | ||
2884478 | 2884478 | 2021-06-20 | Monaco | 2548 | 33 | 2474 | 41 | 43.7333 | 7.4167 | 2021-06-21 04:21:41 | Monaco | |||
2884199 | 2884199 | 2021-06-20 | China | Zhejiang | 1379 | 1 | 1337 | 41 | 29.1832 | 120.0934 | 2021-06-21 04:21:41 | Zhejiang, China | ||
107561 | 107561 | 2021-06-19 | Monaco | 2548 | 33 | 2474 | 41 | 43.7333 | 7.4167 | 2021-06-20 04:21:48 | Monaco | |||
107282 | 107282 | 2021-06-19 | China | Zhejiang | 1379 | 1 | 1337 | 41 | 29.1832 | 120.0934 | 2021-06-20 04:21:48 | Zhejiang, China | ||
1125704 | 1125704 | 2021-06-18 | Monaco | 2547 | 33 | 2473 | 41 | 43.7333 | 7.4167 | 2021-06-19 04:22:33 | Monaco | |||
3385055 | 3385055 | 2021-06-13 | Malaysia | Perlis | 558 | 6 | 511 | 41 | 6.4449 | 100.2048 | 2021-06-14 04:22:46 | Perlis, Malaysia | ||
526506 | 526506 | 2021-06-09 | United Kingdom | Channel Islands | 0 | 0 | 3956 | 41 | 49.3723 | -2.3644 | 2021-06-10 04:23:17 | Channel Islands, United Kingdom | ||
3472144 | 3472144 | 2021-06-08 | Colombia | Guainia | 1841 | 22 | 1778 | 41 | 2.5854 | -68.5247 | 2021-06-09 04:23:31 | Guainia, Colombia | ||
3145428 | 3145428 | 2021-06-07 | Colombia | Guainia | 1841 | 22 | 1778 | 41 | 2.5854 | -68.5247 | 2021-06-08 04:22:35 | Guainia, Colombia | ||
2585819 | 2585819 | 2021-06-05 | China | Zhejiang | 1366 | 1 | 1324 | 41 | 29.1832 | 120.0934 | 2021-06-06 04:24:03 | Zhejiang, China | ||
2104171 | 2104171 | 2021-06-01 | Japan | Tottori | 466 | 2 | 423 | 41 | 35.359069 | 133.863619 | 2021-06-02 04:24:34 | Tottori, Japan | ||
3089254 | 3089254 | 2021-05-30 | Colombia | Amazonas | 6327 | 241 | 6045 | 41 | -1.4429 | -71.5724 | 2021-05-31 03:08:59 | Amazonas, Colombia | ||
50796 | 50796 | 2021-05-29 | Japan | Fukui | 1037 | 34 | 962 | 41 | 35.846614 | 136.22465400000002 | 2021-05-30 04:20:55 | Fukui, Japan | ||
50623 | 50623 | 2021-05-29 | Colombia | Amazonas | 6326 | 240 | 6045 | 41 | -1.4429 | -71.5724 | 2021-05-30 04:20:55 | Amazonas, Colombia | ||
82898 | 82898 | 2021-05-25 | China | Guangdong | 2413 | 8 | 2364 | 41 | 23.3417 | 113.4244 | 2021-05-26 04:20:35 | Guangdong, China | ||
1771597 | 1771597 | 2021-05-23 | Russia | Tyva Republic | 15919 | 203 | 15675 | 41 | 51.4017149 | 93.8582593 | 2021-05-24 04:20:53 | Tyva Republic, Russia | ||
730178 | 730178 | 2021-05-22 | Malaysia | Perlis | 428 | 3 | 384 | 41 | 6.4449 | 100.2048 | 2021-05-23 04:20:51 | Perlis, Malaysia | ||
2820601 | 2820601 | 2021-05-10 | China | Yunnan | 348 | 2 | 305 | 41 | 24.974 | 101.487 | 2021-05-11 04:20:41 | Yunnan, China | ||
1424811 | 1424811 | 2021-05-09 | Barbados | 3942 | 45 | 3856 | 41 | 13.1939 | -59.5432 | 2021-05-10 04:20:38 | Barbados | |||
380230 | 380230 | 2021-04-30 | Japan | Shimane | 347 | 0 | 306 | 41 | 35.07076 | 132.55406399999998 | 2021-05-01 04:20:47 | Shimane, Japan | ||
3702148 | 3702148 | 2021-04-27 | Japan | Shimane | 338 | 0 | 297 | 41 | 35.07076 | 132.55406399999998 | 2021-04-28 04:20:32 | Shimane, Japan | ||
3701809 | 3701809 | 2021-04-27 | Australia | Queensland | 1550 | 7 | 1502 | 41 | -27.4698 | 153.0251 | 2021-04-28 04:20:32 | Queensland, Australia | ||
954668 | 954668 | 2021-04-25 | China | Guangdong | 2329 | 8 | 2280 | 41 | 23.3417 | 113.4244 | 2021-04-26 04:21:04 | Guangdong, China | ||
3923784 | 3923784 | 2021-04-24 | Canada | Nunavut | 448 | 4 | 403 | 41 | 70.2998 | -83.1076 | 2021-04-25 04:20:32 | Nunavut, Canada | ||
3242130 | 3242130 | 2021-04-21 | China | Guangdong | 2322 | 8 | 2273 | 41 | 23.3417 | 113.4244 | 2021-04-22 04:20:53 | Guangdong, China | ||
2571949 | 2571949 | 2021-04-13 | Sao Tome and Principe | 2268 | 35 | 2192 | 41 | 0.1864 | 6.6131 | 2021-04-14 04:20:41 | Sao Tome and Principe | |||
36459 | 36459 | 2021-04-12 | Japan | Oita | 1348 | 22 | 1285 | 41 | 33.200697 | 131.43323999999998 | 2021-04-13 04:20:37 | Oita, Japan | ||
36368 | 36368 | 2021-04-12 | India | Arunachal Pradesh | 16888 | 56 | 16791 | 41 | 27.768456 | 96.384277 | 2021-04-13 04:20:37 | Arunachal Pradesh, India | ||
3887276 | 3887276 | 2021-04-11 | Malaysia | W.P. Labuan | 2410 | 12 | 2357 | 41 | 5.2831 | 115.2308 | 2021-04-12 04:21:00 | W.P. Labuan, Malaysia | ||
605460 | 605460 | 2021-04-09 | Canada | Nova Scotia | 1756 | 66 | 1649 | 41 | 44.682 | -63.7443 | 2021-04-10 04:20:59 | Nova Scotia, Canada | ||
2645881 | 2645881 | 2021-04-08 | Netherlands | Sint Maarten | 2174 | 27 | 2106 | 41 | 18.0425 | -63.0548 | 2021-04-09 04:21:13 | Sint Maarten, Netherlands | ||
2247523 | 2247523 | 2021-04-07 | Netherlands | Sint Maarten | 2174 | 27 | 2106 | 41 | 18.0425 | -63.0548 | 2021-04-08 04:21:13 | Sint Maarten, Netherlands | ||
2247198 | 2247198 | 2021-04-07 | China | Guangdong | 2291 | 8 | 2242 | 41 | 23.3417 | 113.4244 | 2021-04-08 04:21:13 | Guangdong, China | ||
3085428 | 3085428 | 2021-04-05 | Netherlands | Sint Maarten | 2151 | 27 | 2083 | 41 | 18.0425 | -63.0548 | 2021-04-06 04:20:32 | Sint Maarten, Netherlands | ||
3085123 | 3085123 | 2021-04-05 | China | Shanghai | 1902 | 7 | 1854 | 41 | 31.202 | 121.4491 | 2021-04-06 04:20:32 | Shanghai, China | ||
388351 | 388351 | 2021-04-04 | Netherlands | Sint Maarten | 2151 | 27 | 2083 | 41 | 18.0425 | -63.0548 | 2021-04-05 04:20:35 | Sint Maarten, Netherlands | ||
388257 | 388257 | 2021-04-04 | Japan | Saga | 1219 | 13 | 1165 | 41 | 33.286977 | 130.115738 | 2021-04-05 04:20:35 | Saga, Japan | ||
388182 | 388182 | 2021-04-04 | India | Mizoram | 4491 | 11 | 4439 | 41 | 23.309381 | 92.83822 | 2021-04-05 04:20:35 | Mizoram, India | ||
3710267 | 3710267 | 2021-04-03 | Netherlands | Sint Maarten | 2151 | 27 | 2083 | 41 | 18.0425 | -63.0548 | 2021-04-04 04:20:49 | Sint Maarten, Netherlands | ||
3710156 | 3710156 | 2021-04-03 | Japan | Kagoshima | 1847 | 28 | 1778 | 41 | 31.009484000000004 | 130.430665 | 2021-04-04 04:20:49 | Kagoshima, Japan | ||
241383 | 241383 | 2021-04-02 | Netherlands | Sint Maarten | 2151 | 27 | 2083 | 41 | 18.0425 | -63.0548 | 2021-04-03 04:20:44 | Sint Maarten, Netherlands | ||
241191 | 241191 | 2021-04-02 | India | Andaman and Nicobar Islands | 5084 | 62 | 4981 | 41 | 11.225999 | 92.968178 | 2021-04-03 04:20:44 | Andaman and Nicobar Islands, India | ||
1302180 | 1302180 | 2021-04-01 | Netherlands | Sint Maarten | 2151 | 27 | 2083 | 41 | 18.0425 | -63.0548 | 2021-04-02 04:20:36 | Sint Maarten, Netherlands | ||
637939 | 637939 | 2021-03-31 | Japan | Iwate | 621 | 30 | 550 | 41 | 39.593287 | 141.361777 | 2021-04-01 04:27:05 | Iwate, Japan | ||
1219583 | 1219583 | 2021-03-27 | Japan | Iwate | 604 | 30 | 533 | 41 | 39.593287 | 141.361777 | 2021-03-28 05:28:10 | Iwate, Japan | ||
1880951 | 1880951 | 2021-03-26 | India | Sikkim | 6215 | 135 | 6039 | 41 | 27.571671 | 88.472712 | 2021-03-27 05:25:04 | Sikkim, India | ||
2055848 | 2055848 | 2021-03-15 | India | Sikkim | 6184 | 135 | 6008 | 41 | 27.571671 | 88.472712 | 2021-03-16 05:25:13 | Sikkim, India | ||
2055708 | 2055708 | 2021-03-15 | China | Sichuan | 935 | 3 | 891 | 41 | 30.6171 | 102.7103 | 2021-03-16 05:25:13 | Sichuan, China | ||
1579975 | 1579975 | 2021-03-13 | China | Shanghai | 1834 | 7 | 1786 | 41 | 31.202 | 121.4491 | 2021-03-14 05:25:37 | Shanghai, China | ||
1837756 | 1837756 | 2021-03-12 | China | Sichuan | 929 | 3 | 885 | 41 | 30.6171 | 102.7103 | 2021-03-13 05:25:15 | Sichuan, China | ||
1837754 | 1837754 | 2021-03-12 | China | Shanghai | 1830 | 7 | 1782 | 41 | 31.202 | 121.4491 | 2021-03-13 05:25:15 | Shanghai, China | ||
352310 | 352310 | 2021-03-11 | Japan | Ishikawa | 1879 | 62 | 1776 | 41 | 36.769464 | 136.771027 | 2021-03-12 05:26:50 | Ishikawa, Japan | ||
352249 | 352249 | 2021-03-11 | India | Ladakh | 9840 | 130 | 9669 | 41 | 34.1526 | 77.5771 | 2021-03-12 05:26:50 | Ladakh, India | ||
3962580 | 3962580 | 2021-03-10 | Liberia | 2024 | 85 | 1898 | 41 | 6.4280550000000005 | -9.429499 | 2021-03-11 05:25:48 | Liberia | |||
3663668 | 3663668 | 2021-03-09 | Liberia | 2024 | 85 | 1898 | 41 | 6.4280550000000005 | -9.429499 | 2021-03-10 05:24:35 | Liberia | |||
3667695 | 3667695 | 2021-03-06 | Mauritius | 626 | 10 | 588 | 41 | -20.348404 | 57.552152 | 2021-03-07 05:21:54 | Mauritius | |||
998632 | 998632 | 2021-03-01 | Russia | Chukotka Autonomous Okrug | 694 | 5 | 648 | 41 | 66.0006475 | 169.4900869 | 2021-03-02 05:23:30 | Chukotka Autonomous Okrug, Russia | ||
998499 | 998499 | 2021-03-01 | Liberia | 2010 | 85 | 1884 | 41 | 6.4280550000000005 | -9.429499 | 2021-03-02 05:23:30 | Liberia | |||
998262 | 998262 | 2021-03-01 | China | Shanghai | 1797 | 7 | 1749 | 41 | 31.202 | 121.4491 | 2021-03-02 05:23:30 | Shanghai, China | ||
2371185 | 2371185 | 2021-02-28 | Malaysia | W.P. Putrajaya | 1062 | 8 | 1013 | 41 | 2.9264 | 101.6964 | 2021-03-01 05:23:01 | W.P. Putrajaya, Malaysia | ||
2367557 | 2367557 | 2021-02-28 | Liberia | 2010 | 85 | 1884 | 41 | 6.4280550000000005 | -9.429499 | 2021-03-01 05:23:01 | Liberia | |||
3069687 | 3069687 | 2021-02-27 | Malaysia | W.P. Putrajaya | 1059 | 8 | 1010 | 41 | 2.9264 | 101.6964 | 2021-02-28 05:22:20 | W.P. Putrajaya, Malaysia | ||
3066192 | 3066192 | 2021-02-27 | Russia | Chukotka Autonomous Okrug | 690 | 5 | 644 | 41 | 66.0006475 | 169.4900869 | 2021-02-28 05:22:20 | Chukotka Autonomous Okrug, Russia | ||
3066059 | 3066059 | 2021-02-27 | Liberia | 2010 | 85 | 1884 | 41 | 6.4280550000000005 | -9.429499 | 2021-02-28 05:22:20 | Liberia |
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]);