johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,073 rows where active = 149 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region >30
- US 925
- Japan 25
- Colombia 12
- France 11
- Iceland 7
- India 7
- Chile 6
- China 6
- Canada 5
- Mexico 5
- United Kingdom 5
- Cyprus 4
- Kosovo 4
- Malaysia 4
- Monaco 4
- Netherlands 4
- Italy 3
- Niger 3
- Pakistan 3
- Spain 3
- Barbados 2
- Djibouti 2
- Equatorial Guinea 2
- South Sudan 2
- Uruguay 2
- Australia 1
- Botswana 1
- Brazil 1
- Cote d'Ivoire 1
- Finland 1
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3468287 | 3468287 | 2021-08-03 | Monaco | 2926 | 33 | 2744 | 149 | 43.7333 | 7.4167 | 2021-08-04 04:21:25 | Monaco | |||
3015375 | 3015375 | 2021-08-01 | Japan | Nagano | 5333 | 94 | 5090 | 149 | 36.132134 | 138.045528 | 2021-08-02 04:21:36 | Nagano, Japan | ||
3904083 | 3904083 | 2021-07-31 | Monaco | 2889 | 33 | 2707 | 149 | 43.7333 | 7.4167 | 2021-08-01 04:21:50 | Monaco | |||
1330202 | 1330202 | 2021-07-24 | India | Madhya Pradesh | 791738 | 10512 | 781077 | 149 | 23.541513 | 78.289633 | 2021-07-25 04:22:12 | Madhya Pradesh, India | ||
3331423 | 3331423 | 2021-07-21 | France | French Polynesia | 19195 | 144 | 18902 | 149 | -17.6797 | -149.4068 | 2021-07-22 04:21:19 | French Polynesia, France | ||
3741114 | 3741114 | 2021-07-12 | Japan | Port Quarantine | 3262 | 5 | 3109 | 149 | 2021-07-13 04:21:18 | Port Quarantine, Japan | ||||
778415 | 778415 | 2021-07-08 | Kosovo | 107827 | 2266 | 105412 | 149 | 42.602636 | 20.902977 | 2021-07-09 04:21:21 | Kosovo | |||
1440637 | 1440637 | 2021-07-07 | Kosovo | 107819 | 2265 | 105405 | 149 | 42.602636 | 20.902977 | 2021-07-08 04:21:26 | Kosovo | |||
1932227 | 1932227 | 2021-07-05 | Chile | Magallanes | 28967 | 464 | 28354 | 149 | -52.368 | -70.9863 | 2021-07-06 04:21:32 | Magallanes, Chile | ||
1495543 | 1495543 | 2021-07-03 | India | Chandigarh | 61718 | 808 | 60761 | 149 | 30.733839 | 76.76827800000002 | 2021-07-04 04:21:38 | Chandigarh, India | ||
2764874 | 2764874 | 2021-07-01 | India | Chandigarh | 61687 | 808 | 60730 | 149 | 30.733839 | 76.76827800000002 | 2021-07-02 04:21:47 | Chandigarh, India | ||
1893151 | 1893151 | 2021-06-30 | Japan | Hiroshima | 11494 | 175 | 11170 | 149 | 34.605309000000005 | 132.788719 | 2021-07-01 04:21:19 | Hiroshima, Japan | ||
3358813 | 3358813 | 2021-06-21 | Pakistan | Gilgit-Baltistan | 5827 | 108 | 5570 | 149 | 35.792146 | 74.982138 | 2021-06-22 04:21:34 | Gilgit-Baltistan, Pakistan | ||
2884358 | 2884358 | 2021-06-20 | Italy | P.A. Trento | 45731 | 1361 | 44221 | 149 | 46.06893511 | 11.12123097 | 2021-06-21 04:21:41 | P.A. Trento, Italy | ||
3970607 | 3970607 | 2021-06-11 | Laos | 1979 | 3 | 1827 | 149 | 19.85627 | 102.495496 | 2021-06-12 04:22:22 | Laos | |||
825580 | 825580 | 2021-06-06 | Italy | Valle d'Aosta | 11626 | 472 | 11005 | 149 | 45.73750286 | 7.320149366 | 2021-06-07 04:22:51 | Valle d'Aosta, Italy | ||
2585836 | 2585836 | 2021-06-05 | Colombia | Guaviare | 3308 | 53 | 3106 | 149 | 1.0654 | -73.2603 | 2021-06-06 04:24:03 | Guaviare, Colombia | ||
3089437 | 3089437 | 2021-05-30 | Japan | Iwate | 1436 | 44 | 1243 | 149 | 39.593287 | 141.361777 | 2021-05-31 03:08:59 | Iwate, Japan | ||
3574444 | 3574444 | 2021-05-17 | Colombia | Guaviare | 2627 | 40 | 2438 | 149 | 1.0654 | -73.2603 | 2021-05-18 04:20:33 | Guaviare, Colombia | ||
3954540 | 3954540 | 2021-05-11 | Japan | Yamanashi | 1347 | 19 | 1179 | 149 | 35.612364 | 138.61148899999998 | 2021-05-12 04:21:29 | Yamanashi, Japan | ||
2502072 | 2502072 | 2021-05-07 | Japan | Toyama | 1388 | 31 | 1208 | 149 | 36.637464 | 137.26934599999998 | 2021-05-08 04:21:04 | Toyama, Japan | ||
2450888 | 2450888 | 2021-05-02 | Netherlands | Aruba | 10650 | 99 | 10402 | 149 | 12.5211 | -69.9683 | 2021-05-03 04:20:39 | Aruba, Netherlands | ||
2824901 | 2824901 | 2021-05-01 | Netherlands | Aruba | 10650 | 99 | 10402 | 149 | 12.5211 | -69.9683 | 2021-05-02 04:20:48 | Aruba, Netherlands | ||
2824818 | 2824818 | 2021-05-01 | Japan | Port Quarantine | 2720 | 3 | 2568 | 149 | 2021-05-02 04:20:48 | Port Quarantine, Japan | ||||
380003 | 380003 | 2021-04-30 | China | Hong Kong | 11774 | 209 | 11416 | 149 | 22.3 | 114.2 | 2021-05-01 04:20:47 | Hong Kong, China | ||
3702127 | 3702127 | 2021-04-27 | Japan | Kagawa | 1180 | 21 | 1010 | 149 | 34.217292 | 133.969047 | 2021-04-28 04:20:32 | Kagawa, Japan | ||
3701981 | 3701981 | 2021-04-27 | Cote d'Ivoire | 45885 | 285 | 45451 | 149 | 7.54 | -5.5471 | 2021-04-28 04:20:32 | Cote d'Ivoire | |||
1408811 | 1408811 | 2021-04-23 | Canada | New Brunswick | 1839 | 34 | 1656 | 149 | 46.5653 | -66.4619 | 2021-04-24 04:20:38 | New Brunswick, Canada | ||
2021005 | 2021005 | 2021-04-20 | South Sudan | 10478 | 114 | 10215 | 149 | 6.877000000000002 | 31.307 | 2021-04-21 04:21:14 | South Sudan | |||
2020770 | 2020770 | 2021-04-20 | Japan | Yamaguchi | 1593 | 43 | 1401 | 149 | 34.201190000000004 | 131.573293 | 2021-04-21 04:21:14 | Yamaguchi, Japan | ||
2020508 | 2020508 | 2021-04-20 | Chile | Aysen | 3981 | 30 | 3802 | 149 | -45.9864 | -73.7669 | 2021-04-21 04:21:14 | Aysen, Chile | ||
982734 | 982734 | 2021-04-17 | Chile | Aysen | 3915 | 30 | 3736 | 149 | -45.9864 | -73.7669 | 2021-04-18 04:20:41 | Aysen, Chile | ||
3883357 | 3883357 | 2021-04-11 | Canada | New Brunswick | 1722 | 33 | 1540 | 149 | 46.5653 | -66.4619 | 2021-04-12 04:21:00 | New Brunswick, Canada | ||
2983025 | 2983025 | 2021-04-10 | Canada | New Brunswick | 1713 | 33 | 1531 | 149 | 46.5653 | -66.4619 | 2021-04-11 04:20:56 | New Brunswick, Canada | ||
2646035 | 2646035 | 2021-04-08 | South Sudan | 10324 | 114 | 10061 | 149 | 6.877000000000002 | 31.307 | 2021-04-09 04:21:13 | South Sudan | |||
241364 | 241364 | 2021-04-02 | Monaco | 2320 | 28 | 2143 | 149 | 43.7333 | 7.4167 | 2021-04-03 04:20:44 | Monaco | |||
1302161 | 1302161 | 2021-04-01 | Monaco | 2305 | 28 | 2128 | 149 | 43.7333 | 7.4167 | 2021-04-02 04:20:36 | Monaco | |||
1289714 | 1289714 | 2021-03-29 | Barbados | 3634 | 41 | 3444 | 149 | 13.1939 | -59.5432 | 2021-03-30 04:26:23 | Barbados | |||
1980324 | 1980324 | 2021-03-25 | Barbados | 3593 | 40 | 3404 | 149 | 13.1939 | -59.5432 | 2021-03-26 05:26:55 | Barbados | |||
702546 | 702546 | 2021-03-16 | Pakistan | Balochistan | 19247 | 202 | 18896 | 149 | 28.328492 | 65.898403 | 2021-03-17 05:25:07 | Balochistan, Pakistan | ||
1000846 | 1000846 | 2021-03-01 | US | North Dakota | Oliver | 38065 | 152 | 2 | 0 | 149 | 47.11530482 | -101.3406158 | 2021-03-02 05:23:30 | Oliver, North Dakota, US |
2369904 | 2369904 | 2021-02-28 | US | North Dakota | Oliver | 38065 | 151 | 2 | 0 | 149 | 47.11530482 | -101.3406158 | 2021-03-01 05:23:01 | Oliver, North Dakota, US |
2367533 | 2367533 | 2021-02-28 | Japan | Shiga | 2467 | 46 | 2272 | 149 | 35.21582700000001 | 136.138064 | 2021-03-01 05:23:01 | Shiga, Japan | ||
3068406 | 3068406 | 2021-02-27 | US | North Dakota | Oliver | 38065 | 151 | 2 | 0 | 149 | 47.11530482 | -101.3406158 | 2021-02-28 05:22:20 | Oliver, North Dakota, US |
2185990 | 2185990 | 2021-02-26 | US | North Dakota | Oliver | 38065 | 151 | 2 | 0 | 149 | 47.11530482 | -101.3406158 | 2021-02-27 05:22:28 | Oliver, North Dakota, US |
1860412 | 1860412 | 2021-02-25 | US | North Dakota | Oliver | 38065 | 151 | 2 | 0 | 149 | 47.11530482 | -101.3406158 | 2021-02-26 05:22:40 | Oliver, North Dakota, US |
282590 | 282590 | 2021-02-24 | US | North Dakota | Oliver | 38065 | 151 | 2 | 0 | 149 | 47.11530482 | -101.3406158 | 2021-02-25 05:24:57 | Oliver, North Dakota, US |
1938858 | 1938858 | 2021-02-23 | US | North Dakota | Oliver | 38065 | 151 | 2 | 0 | 149 | 47.11530482 | -101.3406158 | 2021-02-24 05:29:16 | Oliver, North Dakota, US |
533917 | 533917 | 2021-02-22 | US | Texas | Sherman | 48421 | 269 | 12 | 0 | 149 | 36.27751473 | -101.8933156 | 2021-02-23 05:23:41 | Sherman, Texas, US |
185251 | 185251 | 2021-02-21 | US | Texas | Sherman | 48421 | 269 | 12 | 0 | 149 | 36.27751473 | -101.8933156 | 2021-02-22 05:24:21 | Sherman, Texas, US |
745525 | 745525 | 2021-02-20 | US | Texas | Sherman | 48421 | 269 | 12 | 0 | 149 | 36.27751473 | -101.8933156 | 2021-02-21 05:24:33 | Sherman, Texas, US |
473798 | 473798 | 2021-02-19 | US | North Dakota | Divide | 38023 | 152 | 2 | 0 | 149 | 48.814938700000006 | -103.4873611 | 2021-02-20 05:22:51 | Divide, North Dakota, US |
1155507 | 1155507 | 2021-02-18 | US | North Dakota | Divide | 38023 | 151 | 2 | 0 | 149 | 48.814938700000006 | -103.4873611 | 2021-02-19 05:24:16 | Divide, North Dakota, US |
1152929 | 1152929 | 2021-02-18 | China | Hebei | 1317 | 7 | 1161 | 149 | 37.8957 | 114.9042 | 2021-02-19 05:24:16 | Hebei, China | ||
3600849 | 3600849 | 2021-02-17 | China | Hebei | 1317 | 7 | 1161 | 149 | 37.8957 | 114.9042 | 2021-02-18 05:22:58 | Hebei, China | ||
3052443 | 3052443 | 2021-02-16 | US | New York | Unassigned | 90036 | 305 | 156 | 0 | 149 | 44.74530905 | 0.0 | 2021-02-17 05:23:10 | Unassigned, New York, US |
2283384 | 2283384 | 2021-02-14 | India | Meghalaya | 13942 | 148 | 13645 | 149 | 25.536934 | 91.278882 | 2021-02-15 05:24:49 | Meghalaya, India | ||
2283260 | 2283260 | 2021-02-14 | Colombia | Arauca | 5501 | 162 | 5190 | 149 | 7.0762 | -70.7105 | 2021-02-15 05:24:49 | Arauca, Colombia | ||
2283212 | 2283212 | 2021-02-14 | Chile | Aysen | 2827 | 23 | 2655 | 149 | -45.9864 | -73.7669 | 2021-02-15 05:24:49 | Aysen, Chile | ||
3540314 | 3540314 | 2021-02-12 | US | Georgia | Quitman | 13239 | 150 | 1 | 0 | 149 | 31.86728114 | -85.01773177 | 2021-02-13 05:22:12 | Quitman, Georgia, US |
2638577 | 2638577 | 2021-02-11 | US | Georgia | Quitman | 13239 | 150 | 1 | 0 | 149 | 31.86728114 | -85.01773177 | 2021-02-12 05:23:29 | Quitman, Georgia, US |
3979432 | 3979432 | 2021-02-10 | US | Georgia | Quitman | 13239 | 150 | 1 | 0 | 149 | 31.86728114 | -85.01773177 | 2021-02-11 05:23:55 | Quitman, Georgia, US |
1528752 | 1528752 | 2021-02-09 | US | Georgia | Quitman | 13239 | 150 | 1 | 0 | 149 | 31.86728114 | -85.01773177 | 2021-02-10 05:22:41 | Quitman, Georgia, US |
1672301 | 1672301 | 2021-02-07 | Colombia | Choco | 6417 | 192 | 6076 | 149 | 5.2528 | -76.82600000000002 | 2021-02-08 05:22:39 | Choco, Colombia | ||
343964 | 343964 | 2021-02-03 | Malaysia | W.P. Putrajaya | 911 | 6 | 756 | 149 | 2.9264 | 101.6964 | 2021-02-04 05:22:26 | W.P. Putrajaya, Malaysia | ||
1684526 | 1684526 | 2021-02-02 | Japan | Nagano | 2298 | 38 | 2111 | 149 | 36.132134 | 138.045528 | 2021-02-03 05:22:52 | Nagano, Japan | ||
1459900 | 1459900 | 2021-01-31 | Pakistan | Balochistan | 18823 | 195 | 18479 | 149 | 28.328492 | 65.898403 | 2021-02-01 05:22:53 | Balochistan, Pakistan | ||
1459763 | 1459763 | 2021-01-31 | Japan | Ehime | 993 | 18 | 826 | 149 | 33.624835 | 132.856842 | 2021-02-01 05:22:53 | Ehime, Japan | ||
2211671 | 2211671 | 2021-01-30 | Japan | Ehime | 993 | 18 | 826 | 149 | 33.624835 | 132.856842 | 2021-01-31 05:22:42 | Ehime, Japan | ||
1899182 | 1899182 | 2021-01-29 | US | Montana | Wheatland | 30107 | 155 | 6 | 0 | 149 | 46.46652491 | -109.8464636 | 2021-01-30 05:22:49 | Wheatland, Montana, US |
2483998 | 2483998 | 2021-01-28 | US | Montana | Wheatland | 30107 | 155 | 6 | 0 | 149 | 46.46652491 | -109.8464636 | 2021-01-29 05:22:23 | Wheatland, Montana, US |
3155633 | 3155633 | 2021-01-27 | US | Montana | Wheatland | 30107 | 155 | 6 | 0 | 149 | 46.46652491 | -109.8464636 | 2021-01-28 05:22:24 | Wheatland, Montana, US |
14368 | 14368 | 2021-01-26 | US | Montana | Wheatland | 30107 | 155 | 6 | 0 | 149 | 46.46652491 | -109.8464636 | 2021-01-27 05:23:41 | Wheatland, Montana, US |
12225 | 12225 | 2021-01-26 | Equatorial Guinea | 5454 | 86 | 5219 | 149 | 1.6508 | 10.2679 | 2021-01-27 05:23:41 | Equatorial Guinea | |||
2570071 | 2570071 | 2021-01-25 | US | North Dakota | Oliver | 38065 | 148 | 2 | 0 | 149 | 47.11530482 | -101.3406158 | 2021-01-26 05:22:02 | Oliver, North Dakota, US |
2569692 | 2569692 | 2021-01-25 | US | Montana | Wheatland | 30107 | 155 | 6 | 0 | 149 | 46.46652491 | -109.8464636 | 2021-01-26 05:22:02 | Wheatland, Montana, US |
2567549 | 2567549 | 2021-01-25 | Equatorial Guinea | 5454 | 86 | 5219 | 149 | 1.6508 | 10.2679 | 2021-01-26 05:22:02 | Equatorial Guinea | |||
1761703 | 1761703 | 2021-01-24 | US | North Dakota | Oliver | 38065 | 148 | 2 | 0 | 149 | 47.11530482 | -101.3406158 | 2021-01-25 05:22:16 | Oliver, North Dakota, US |
2429310 | 2429310 | 2021-01-23 | US | North Dakota | Oliver | 38065 | 148 | 2 | 0 | 149 | 47.11530482 | -101.3406158 | 2021-01-24 05:22:35 | Oliver, North Dakota, US |
2426931 | 2426931 | 2021-01-23 | Japan | Niigata | 837 | 7 | 681 | 149 | 37.521819 | 138.918647 | 2021-01-24 05:22:35 | Niigata, Japan | ||
437586 | 437586 | 2021-01-21 | US | New York | Hamilton | 36041 | 150 | 1 | 0 | 149 | 43.66146647 | -74.49721957 | 2021-01-22 05:22:10 | Hamilton, New York, US |
436628 | 436628 | 2021-01-21 | US | Kansas | Elk | 20049 | 151 | 2 | 0 | 149 | 37.45338105 | -96.24369667 | 2021-01-22 05:22:10 | Elk, Kansas, US |
1095359 | 1095359 | 2021-01-20 | US | Kansas | Elk | 20049 | 151 | 2 | 0 | 149 | 37.45338105 | -96.24369667 | 2021-01-21 05:22:01 | Elk, Kansas, US |
3503631 | 3503631 | 2021-01-17 | Seychelles | 689 | 1 | 539 | 149 | -4.6796 | 55.492 | 2021-01-18 05:22:34 | Seychelles | |||
3103803 | 3103803 | 2021-01-16 | US | North Carolina | Unassigned | 90037 | 149 | 0 | 0 | 149 | 36.49360862 | 0.0 | 2021-01-17 05:22:17 | Unassigned, North Carolina, US |
3101854 | 3101854 | 2021-01-16 | US | Alaska | Dillingham | 2070 | 150 | 1 | 0 | 149 | 59.79603738 | -158.23819419999995 | 2021-01-17 05:22:17 | Dillingham, Alaska, US |
3515816 | 3515816 | 2021-01-15 | US | Alaska | Dillingham | 2070 | 150 | 1 | 0 | 149 | 59.79603738 | -158.23819419999995 | 2021-01-16 05:22:40 | Dillingham, Alaska, US |
3879621 | 3879621 | 2021-01-14 | Japan | Wakayama | 819 | 9 | 661 | 149 | 33.911879 | 135.505446 | 2021-01-15 05:22:24 | Wakayama, Japan | ||
3310002 | 3310002 | 2021-01-13 | US | Mississippi | Issaquena | 28055 | 155 | 6 | 0 | 149 | 32.72531359 | -90.97392828 | 2021-01-14 05:22:32 | Issaquena, Mississippi, US |
3309754 | 3309754 | 2021-01-13 | US | Maine | Piscataquis | 23021 | 150 | 1 | 0 | 149 | 45.83839062 | -69.2860223 | 2021-01-14 05:22:32 | Piscataquis, Maine, US |
774283 | 774283 | 2021-01-12 | Iceland | 5912 | 29 | 5734 | 149 | 64.9631 | -19.0208 | 2021-01-13 05:22:15 | Iceland | |||
2627872 | 2627872 | 2021-01-10 | US | Montana | McCone | 30055 | 149 | 0 | 0 | 149 | 47.64469406 | -105.7944994 | 2021-01-11 05:21:50 | McCone, Montana, US |
2626138 | 2626138 | 2021-01-10 | Saint Vincent and the Grenadines | 249 | 0 | 100 | 149 | 12.9843 | -61.2872 | 2021-01-11 05:21:50 | Saint Vincent and the Grenadines | |||
2625919 | 2625919 | 2021-01-10 | Japan | Yamaguchi | 706 | 3 | 554 | 149 | 34.201190000000004 | 131.573293 | 2021-01-11 05:21:50 | Yamaguchi, Japan | ||
3902698 | 3902698 | 2021-01-09 | US | Puerto Rico | Jayuya | 72073 | 149 | 0 | 0 | 149 | 18.211446 | -66.58878 | 2021-01-10 05:22:12 | Jayuya, Puerto Rico, US |
3901960 | 3901960 | 2021-01-09 | US | Montana | McCone | 30055 | 149 | 0 | 0 | 149 | 47.64469406 | -105.7944994 | 2021-01-10 05:22:12 | McCone, Montana, US |
156721 | 156721 | 2021-01-08 | US | Puerto Rico | Jayuya | 72073 | 149 | 0 | 0 | 149 | 18.211446 | -66.58878 | 2021-01-09 05:22:18 | Jayuya, Puerto Rico, US |
155782 | 155782 | 2021-01-08 | US | Mississippi | Issaquena | 28055 | 154 | 5 | 0 | 149 | 32.72531359 | -90.97392828 | 2021-01-09 05:22:18 | Issaquena, Mississippi, US |
2542072 | 2542072 | 2021-01-07 | US | Delaware | Unassigned | 90010 | 149 | 0 | 0 | 149 | 39.57992638 | 0.0 | 2021-01-08 05:22:42 | Unassigned, Delaware, US |
2542053 | 2542053 | 2021-01-07 | US | Colorado | Sedgwick | 8115 | 171 | 2 | 0 | 149 | 40.87595412 | -102.3519227 | 2021-01-08 05:22:42 | Sedgwick, Colorado, 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]);