johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
920 rows where active = 165 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3907595 | 3907595 | 2021-07-31 | Ukraine | Chernivtsi Oblast | 80177 | 1798 | 78214 | 165 | 48.2917 | 25.9352 | 2021-08-01 04:21:50 | Chernivtsi Oblast, Ukraine | ||
1305863 | 1305863 | 2021-07-27 | Barbados | 4359 | 48 | 4146 | 165 | 13.1939 | -59.5432 | 2021-07-28 04:21:39 | Barbados | |||
3218352 | 3218352 | 2021-07-26 | Kosovo | 108031 | 2269 | 105597 | 165 | 42.602636 | 20.902977 | 2021-07-27 04:21:18 | Kosovo | |||
3331558 | 3331558 | 2021-07-21 | Japan | Niigata | 3645 | 54 | 3426 | 165 | 37.521819 | 138.918647 | 2021-07-22 04:21:19 | Niigata, Japan | ||
487219 | 487219 | 2021-07-19 | Ukraine | Khmelnytskyi Oblast | 89071 | 1885 | 87021 | 165 | 49.423 | 26.9871 | 2021-07-20 04:21:48 | Khmelnytskyi Oblast, Ukraine | ||
2677442 | 2677442 | 2021-07-18 | Ukraine | Khmelnytskyi Oblast | 89071 | 1885 | 87021 | 165 | 49.423 | 26.9871 | 2021-07-19 04:21:24 | Khmelnytskyi Oblast, Ukraine | ||
2673724 | 2673724 | 2021-07-18 | Germany | Bremen | 27604 | 489 | 26980 | 165 | 53.0793 | 8.8017 | 2021-07-19 04:21:24 | Bremen, Germany | ||
2947389 | 2947389 | 2021-07-16 | Japan | Port Quarantine | 3316 | 5 | 3147 | 165 | 2021-07-17 04:22:22 | Port Quarantine, Japan | ||||
2071707 | 2071707 | 2021-07-02 | Chile | Magallanes | 28912 | 457 | 28290 | 165 | -52.368 | -70.9863 | 2021-07-03 04:21:37 | Magallanes, Chile | ||
3962132 | 3962132 | 2021-06-26 | Ukraine | Ivano-Frankivsk Oblast | 86647 | 2097 | 84385 | 165 | 48.9226 | 24.7111 | 2021-06-27 04:21:39 | Ivano-Frankivsk Oblast, Ukraine | ||
2295594 | 2295594 | 2021-06-24 | Pakistan | Gilgit-Baltistan | 5908 | 111 | 5632 | 165 | 35.792146 | 74.982138 | 2021-06-25 04:21:33 | Gilgit-Baltistan, Pakistan | ||
1567780 | 1567780 | 2021-06-14 | Malaysia | W.P. Putrajaya | 2125 | 13 | 1947 | 165 | 2.9264 | 101.6964 | 2021-06-15 04:22:22 | W.P. Putrajaya, Malaysia | ||
1564289 | 1564289 | 2021-06-14 | Russia | Ingushetia Republic | 15930 | 190 | 15575 | 165 | 43.11542075 | 45.01713552 | 2021-06-15 04:22:22 | Ingushetia Republic, Russia | ||
3970578 | 3970578 | 2021-06-11 | Japan | Niigata | 3340 | 46 | 3129 | 165 | 37.521819 | 138.918647 | 2021-06-12 04:22:22 | Niigata, Japan | ||
2717029 | 2717029 | 2021-06-10 | Laos | 1975 | 3 | 1807 | 165 | 19.85627 | 102.495496 | 2021-06-11 04:23:20 | Laos | |||
522883 | 522883 | 2021-06-09 | Japan | Nagasaki | 3017 | 68 | 2784 | 165 | 33.235712 | 129.608033 | 2021-06-10 04:23:17 | Nagasaki, Japan | ||
522864 | 522864 | 2021-06-09 | Japan | Fukushima | 4677 | 155 | 4357 | 165 | 37.378867 | 140.223295 | 2021-06-10 04:23:17 | Fukushima, Japan | ||
825918 | 825918 | 2021-06-06 | Togo | 13539 | 125 | 13249 | 165 | 8.6195 | 0.8248 | 2021-06-07 04:22:51 | Togo | |||
83114 | 83114 | 2021-05-25 | Japan | Kochi | 1310 | 20 | 1125 | 165 | 33.422519 | 133.367307 | 2021-05-26 04:20:35 | Kochi, Japan | ||
2390657 | 2390657 | 2021-05-18 | Eritrea | 3879 | 14 | 3700 | 165 | 15.1794 | 39.7823 | 2021-05-19 04:20:42 | Eritrea | |||
2939359 | 2939359 | 2021-05-16 | Japan | Port Quarantine | 2878 | 3 | 2710 | 165 | 2021-05-17 04:20:34 | Port Quarantine, Japan | ||||
3954332 | 3954332 | 2021-05-11 | Colombia | Caqueta | 17675 | 662 | 16848 | 165 | 0.8699 | -73.8419 | 2021-05-12 04:21:29 | Caqueta, Colombia | ||
2820611 | 2820611 | 2021-05-10 | Colombia | Caqueta | 17662 | 659 | 16838 | 165 | 0.8699 | -73.8419 | 2021-05-11 04:20:41 | Caqueta, Colombia | ||
2760805 | 2760805 | 2021-05-03 | Eritrea | 3673 | 12 | 3496 | 165 | 15.1794 | 39.7823 | 2021-05-04 04:20:34 | Eritrea | |||
2451044 | 2451044 | 2021-05-02 | Senegal | 40433 | 1110 | 39158 | 165 | 14.4974 | -14.4524 | 2021-05-03 04:20:39 | Senegal | |||
380217 | 380217 | 2021-04-30 | Japan | Miyazaki | 2208 | 22 | 2021 | 165 | 32.193203999999994 | 131.299374 | 2021-05-01 04:20:47 | Miyazaki, Japan | ||
1636252 | 1636252 | 2021-04-29 | India | Andaman and Nicobar Islands | 5875 | 67 | 5643 | 165 | 11.225999 | 92.968178 | 2021-04-30 04:21:03 | Andaman and Nicobar Islands, India | ||
3242213 | 3242213 | 2021-04-21 | Eritrea | 3564 | 10 | 3389 | 165 | 15.1794 | 39.7823 | 2021-04-22 04:20:53 | Eritrea | |||
2410906 | 2410906 | 2021-04-19 | Liechtenstein | 2914 | 56 | 2693 | 165 | 47.14 | 9.55 | 2021-04-20 04:20:41 | Liechtenstein | |||
170106 | 170106 | 2021-04-16 | Liechtenstein | 2886 | 56 | 2665 | 165 | 47.14 | 9.55 | 2021-04-17 04:20:40 | Liechtenstein | |||
170001 | 170001 | 2021-04-16 | India | Manipur | 29610 | 376 | 29069 | 165 | 24.738975 | 93.882541 | 2021-04-17 04:20:40 | Manipur, India | ||
2548908 | 2548908 | 2021-04-15 | Japan | Port Quarantine | 2553 | 3 | 2385 | 165 | 2021-04-16 04:20:46 | Port Quarantine, Japan | ||||
3369184 | 3369184 | 2021-03-21 | Colombia | Putumayo | 8100 | 319 | 7616 | 165 | 0.436 | -75.5277 | 2021-03-22 05:25:43 | Putumayo, Colombia | ||
702113 | 702113 | 2021-03-16 | Barbados | 3458 | 39 | 3254 | 165 | 13.1939 | -59.5432 | 2021-03-17 05:25:07 | Barbados | |||
2055922 | 2055922 | 2021-03-15 | Japan | Tochigi | 4288 | 69 | 4054 | 165 | 36.689912 | 139.819213 | 2021-03-16 05:25:13 | Tochigi, Japan | ||
2055738 | 2055738 | 2021-03-15 | Colombia | Putumayo | 8023 | 316 | 7542 | 165 | 0.436 | -75.5277 | 2021-03-16 05:25:13 | Putumayo, Colombia | ||
3663629 | 3663629 | 2021-03-09 | Japan | Kyoto | 9129 | 163 | 8801 | 165 | 35.253815 | 135.443341 | 2021-03-10 05:24:35 | Kyoto, Japan | ||
3667658 | 3667658 | 2021-03-06 | Japan | Shiga | 2546 | 47 | 2334 | 165 | 35.21582700000001 | 136.138064 | 2021-03-07 05:21:54 | Shiga, Japan | ||
2208266 | 2208266 | 2021-03-04 | US | Colorado | Gilpin | 8047 | 185 | 3 | 0 | 165 | 39.85646523 | -105.5252597 | 2021-03-05 05:26:29 | Gilpin, Colorado, US |
1090687 | 1090687 | 2021-03-03 | US | Colorado | Gilpin | 8047 | 183 | 3 | 0 | 165 | 39.85646523 | -105.5252597 | 2021-03-04 05:24:24 | Gilpin, Colorado, US |
3254759 | 3254759 | 2021-03-02 | US | Colorado | Gilpin | 8047 | 183 | 3 | 0 | 165 | 39.85646523 | -105.5252597 | 2021-03-03 05:23:28 | Gilpin, Colorado, US |
1001713 | 1001713 | 2021-03-01 | US | Vermont | Essex | 50009 | 166 | 1 | 0 | 165 | 44.72736416 | -71.73579864 | 2021-03-02 05:23:30 | Essex, Vermont, US |
999051 | 999051 | 2021-03-01 | US | Colorado | Gilpin | 8047 | 183 | 3 | 0 | 165 | 39.85646523 | -105.5252597 | 2021-03-02 05:23:30 | Gilpin, Colorado, US |
2368109 | 2368109 | 2021-02-28 | US | Colorado | Gilpin | 8047 | 181 | 3 | 0 | 165 | 39.85646523 | -105.5252597 | 2021-03-01 05:23:01 | Gilpin, Colorado, US |
3066611 | 3066611 | 2021-02-27 | US | Colorado | Gilpin | 8047 | 181 | 3 | 0 | 165 | 39.85646523 | -105.5252597 | 2021-02-28 05:22:20 | Gilpin, Colorado, US |
2184195 | 2184195 | 2021-02-26 | US | Colorado | Gilpin | 8047 | 181 | 3 | 0 | 165 | 39.85646523 | -105.5252597 | 2021-02-27 05:22:28 | Gilpin, Colorado, US |
1858617 | 1858617 | 2021-02-25 | US | Colorado | Gilpin | 8047 | 181 | 3 | 0 | 165 | 39.85646523 | -105.5252597 | 2021-02-26 05:22:40 | Gilpin, Colorado, US |
1857837 | 1857837 | 2021-02-25 | Colombia | Amazonas | 4951 | 174 | 4612 | 165 | -1.4429 | -71.5724 | 2021-02-26 05:22:40 | Amazonas, Colombia | ||
282211 | 282211 | 2021-02-24 | US | Montana | Wheatland | 30107 | 171 | 6 | 0 | 165 | 46.46652491 | -109.8464636 | 2021-02-25 05:24:57 | Wheatland, Montana, US |
1937723 | 1937723 | 2021-02-23 | US | Kansas | Elk | 20049 | 169 | 4 | 0 | 165 | 37.45338105 | -96.24369667 | 2021-02-24 05:29:16 | Elk, Kansas, US |
531978 | 531978 | 2021-02-22 | US | Kansas | Elk | 20049 | 169 | 4 | 0 | 165 | 37.45338105 | -96.24369667 | 2021-02-23 05:23:41 | Elk, Kansas, US |
2639071 | 2639071 | 2021-02-11 | US | Kansas | Wallace | 20199 | 169 | 4 | 0 | 165 | 38.91686134 | -101.7638876 | 2021-02-12 05:23:29 | Wallace, Kansas, US |
3980636 | 3980636 | 2021-02-10 | US | Nebraska | Dundy | 31057 | 169 | 4 | 0 | 165 | 40.17638677 | -101.6876522 | 2021-02-11 05:23:55 | Dundy, Nebraska, US |
3979926 | 3979926 | 2021-02-10 | US | Kansas | Wallace | 20199 | 169 | 4 | 0 | 165 | 38.91686134 | -101.7638876 | 2021-02-11 05:23:55 | Wallace, Kansas, US |
1530317 | 1530317 | 2021-02-09 | US | North Dakota | Steele | 38091 | 169 | 2 | 0 | 165 | 47.45611548 | -97.72728747 | 2021-02-10 05:22:41 | Steele, North Dakota, US |
616108 | 616108 | 2021-02-08 | US | North Dakota | Steele | 38091 | 167 | 2 | 0 | 165 | 47.45611548 | -97.72728747 | 2021-02-09 05:23:30 | Steele, North Dakota, US |
613685 | 613685 | 2021-02-08 | Italy | Valle d'Aosta | 7856 | 410 | 7281 | 165 | 45.73750286 | 7.320149366 | 2021-02-09 05:23:30 | Valle d'Aosta, Italy | ||
1674877 | 1674877 | 2021-02-07 | US | North Dakota | Steele | 38091 | 167 | 2 | 0 | 165 | 47.45611548 | -97.72728747 | 2021-02-08 05:22:39 | Steele, North Dakota, US |
977338 | 977338 | 2021-02-06 | US | North Dakota | Steele | 38091 | 167 | 2 | 0 | 165 | 47.45611548 | -97.72728747 | 2021-02-07 05:23:00 | Steele, North Dakota, US |
1590596 | 1590596 | 2021-02-05 | US | North Dakota | Steele | 38091 | 167 | 2 | 0 | 165 | 47.45611548 | -97.72728747 | 2021-02-06 05:23:55 | Steele, North Dakota, US |
792803 | 792803 | 2021-02-04 | US | North Dakota | Steele | 38091 | 167 | 2 | 0 | 165 | 47.45611548 | -97.72728747 | 2021-02-05 05:22:38 | Steele, North Dakota, US |
790399 | 790399 | 2021-02-04 | Japan | Kagawa | 676 | 16 | 495 | 165 | 34.217292 | 133.969047 | 2021-02-05 05:22:38 | Kagawa, Japan | ||
342695 | 342695 | 2021-02-03 | US | North Dakota | Steele | 38091 | 167 | 2 | 0 | 165 | 47.45611548 | -97.72728747 | 2021-02-04 05:22:26 | Steele, North Dakota, US |
1686921 | 1686921 | 2021-02-02 | US | North Dakota | Steele | 38091 | 167 | 2 | 0 | 165 | 47.45611548 | -97.72728747 | 2021-02-03 05:22:52 | Steele, North Dakota, US |
1678891 | 1678891 | 2021-02-01 | US | North Dakota | Steele | 38091 | 167 | 2 | 0 | 165 | 47.45611548 | -97.72728747 | 2021-02-02 05:22:49 | Steele, North Dakota, US |
1462179 | 1462179 | 2021-01-31 | US | North Dakota | Steele | 38091 | 167 | 2 | 0 | 165 | 47.45611548 | -97.72728747 | 2021-02-01 05:22:53 | Steele, North Dakota, US |
1459700 | 1459700 | 2021-01-31 | India | Chandigarh | 20925 | 334 | 20426 | 165 | 30.733839 | 76.76827800000002 | 2021-02-01 05:22:53 | Chandigarh, India | ||
2214087 | 2214087 | 2021-01-30 | US | North Dakota | Steele | 38091 | 167 | 2 | 0 | 165 | 47.45611548 | -97.72728747 | 2021-01-31 05:22:42 | Steele, North Dakota, US |
1899574 | 1899574 | 2021-01-29 | US | North Dakota | Steele | 38091 | 167 | 2 | 0 | 165 | 47.45611548 | -97.72728747 | 2021-01-30 05:22:49 | Steele, North Dakota, US |
2569894 | 2569894 | 2021-01-25 | US | New York | Hamilton | 36041 | 166 | 1 | 0 | 165 | 43.66146647 | -74.49721957 | 2021-01-26 05:22:02 | Hamilton, New York, US |
2569776 | 2569776 | 2021-01-25 | US | Nebraska | Sherman | 31163 | 169 | 4 | 0 | 165 | 41.22045983 | -98.97588642 | 2021-01-26 05:22:02 | Sherman, Nebraska, US |
1761526 | 1761526 | 2021-01-24 | US | New York | Hamilton | 36041 | 166 | 1 | 0 | 165 | 43.66146647 | -74.49721957 | 2021-01-25 05:22:16 | Hamilton, New York, US |
2430549 | 2430549 | 2021-01-23 | United Kingdom | Channel Islands | 0 | 0 | 3186 | 165 | 49.3723 | -2.3644 | 2021-01-24 05:22:35 | Channel Islands, United Kingdom | ||
2429015 | 2429015 | 2021-01-23 | US | Nebraska | Sherman | 31163 | 169 | 4 | 0 | 165 | 41.22045983 | -98.97588642 | 2021-01-24 05:22:35 | Sherman, Nebraska, US |
2468917 | 2468917 | 2021-01-22 | US | Nebraska | Sherman | 31163 | 169 | 4 | 0 | 165 | 41.22045983 | -98.97588642 | 2021-01-23 05:22:03 | Sherman, Nebraska, US |
2468714 | 2468714 | 2021-01-22 | US | Missouri | Knox | 29103 | 167 | 2 | 0 | 165 | 40.12699751 | -92.14780832 | 2021-01-23 05:22:03 | Knox, Missouri, US |
1096507 | 1096507 | 2021-01-20 | US | North Dakota | Steele | 38091 | 167 | 2 | 0 | 165 | 47.45611548 | -97.72728747 | 2021-01-21 05:22:01 | Steele, North Dakota, US |
911357 | 911357 | 2021-01-19 | US | Texas | Oldham | 48359 | 224 | 2 | 0 | 165 | 35.40425596 | -102.6027606 | 2021-01-20 05:21:54 | Oldham, Texas, US |
909730 | 909730 | 2021-01-19 | US | Maine | Piscataquis | 23021 | 166 | 1 | 0 | 165 | 45.83839062 | -69.2860223 | 2021-01-20 05:21:54 | Piscataquis, Maine, US |
240420 | 240420 | 2021-01-18 | US | Texas | Oldham | 48359 | 224 | 2 | 0 | 165 | 35.40425596 | -102.6027606 | 2021-01-19 05:22:15 | Oldham, Texas, US |
3506537 | 3506537 | 2021-01-17 | US | Texas | Oldham | 48359 | 224 | 2 | 0 | 165 | 35.40425596 | -102.6027606 | 2021-01-18 05:22:34 | Oldham, Texas, US |
3104620 | 3104620 | 2021-01-16 | US | Texas | Oldham | 48359 | 224 | 2 | 0 | 165 | 35.40425596 | -102.6027606 | 2021-01-17 05:22:17 | Oldham, Texas, US |
3518582 | 3518582 | 2021-01-15 | US | Texas | Oldham | 48359 | 224 | 2 | 0 | 165 | 35.40425596 | -102.6027606 | 2021-01-16 05:22:40 | Oldham, Texas, US |
3515676 | 3515676 | 2021-01-15 | Seychelles | 626 | 1 | 460 | 165 | -4.6796 | 55.492 | 2021-01-16 05:22:40 | Seychelles | |||
3882889 | 3882889 | 2021-01-14 | US | Virginia | Craig | 51045 | 167 | 2 | 0 | 165 | 37.48133648 | -80.21072274 | 2021-01-15 05:22:24 | Craig, Virginia, US |
3882754 | 3882754 | 2021-01-14 | US | Texas | Oldham | 48359 | 224 | 2 | 0 | 165 | 35.40425596 | -102.6027606 | 2021-01-15 05:22:24 | Oldham, Texas, US |
3311890 | 3311890 | 2021-01-13 | Malaysia | W.P. Putrajaya | 466 | 5 | 296 | 165 | 2.9264 | 101.6964 | 2021-01-14 05:22:32 | W.P. Putrajaya, Malaysia | ||
3311252 | 3311252 | 2021-01-13 | US | Texas | Cottle | 48101 | 168 | 6 | 0 | 165 | 34.07783319 | -100.2785062 | 2021-01-14 05:22:32 | Cottle, Texas, US |
3308849 | 3308849 | 2021-01-13 | US | Colorado | Sedgwick | 8115 | 180 | 2 | 0 | 165 | 40.87595412 | -102.3519227 | 2021-01-14 05:22:32 | Sedgwick, Colorado, US |
3308250 | 3308250 | 2021-01-13 | Japan | Yamaguchi | 742 | 5 | 572 | 165 | 34.201190000000004 | 131.573293 | 2021-01-14 05:22:32 | Yamaguchi, Japan | ||
774981 | 774981 | 2021-01-12 | US | Colorado | Ouray | 8091 | 188 | 3 | 0 | 165 | 38.14717457 | -107.7675136 | 2021-01-13 05:22:15 | Ouray, Colorado, US |
192487 | 192487 | 2021-01-11 | US | North Dakota | Steele | 38091 | 163 | 2 | 0 | 165 | 47.45611548 | -97.72728747 | 2021-01-12 05:22:15 | Steele, North Dakota, US |
190702 | 190702 | 2021-01-11 | US | Colorado | Ouray | 8091 | 186 | 3 | 0 | 165 | 38.14717457 | -107.7675136 | 2021-01-12 05:22:15 | Ouray, Colorado, US |
2628290 | 2628290 | 2021-01-10 | US | North Dakota | Steele | 38091 | 163 | 2 | 0 | 165 | 47.45611548 | -97.72728747 | 2021-01-11 05:21:50 | Steele, North Dakota, US |
2627163 | 2627163 | 2021-01-10 | US | Kansas | Jewell | 20089 | 168 | 3 | 0 | 165 | 39.78470589 | -98.21820662 | 2021-01-11 05:21:50 | Jewell, Kansas, US |
3902378 | 3902378 | 2021-01-09 | US | North Dakota | Steele | 38091 | 163 | 2 | 0 | 165 | 47.45611548 | -97.72728747 | 2021-01-10 05:22:12 | Steele, North Dakota, US |
3901251 | 3901251 | 2021-01-09 | US | Kansas | Jewell | 20089 | 168 | 3 | 0 | 165 | 39.78470589 | -98.21820662 | 2021-01-10 05:22:12 | Jewell, Kansas, US |
156401 | 156401 | 2021-01-08 | US | North Dakota | Steele | 38091 | 163 | 2 | 0 | 165 | 47.45611548 | -97.72728747 | 2021-01-09 05:22:18 | Steele, North Dakota, US |
155274 | 155274 | 2021-01-08 | US | Kansas | Jewell | 20089 | 168 | 3 | 0 | 165 | 39.78470589 | -98.21820662 | 2021-01-09 05:22:18 | Jewell, Kansas, US |
2543825 | 2543825 | 2021-01-07 | US | North Dakota | Steele | 38091 | 163 | 2 | 0 | 165 | 47.45611548 | -97.72728747 | 2021-01-08 05:22:42 | Steele, North Dakota, 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]);