johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
275 rows where active = 917 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
408058 | 408058 | 2021-07-28 | Canada | British Columbia | 149444 | 1771 | 146756 | 917 | 53.7267 | -127.6476 | 2021-07-29 04:21:33 | British Columbia, Canada | ||
1330103 | 1330103 | 2021-07-24 | Colombia | Quindio | 53578 | 1620 | 51041 | 917 | 4.461 | -75.6674 | 2021-07-25 04:22:12 | Quindio, Colombia | ||
3331727 | 3331727 | 2021-07-21 | Russia | Chuvashia Republic | 28571 | 1659 | 25995 | 917 | 55.4259922 | 47.0849429 | 2021-07-22 04:21:19 | Chuvashia Republic, Russia | ||
2371428 | 2371428 | 2021-07-20 | Germany | Rheinland-Pfalz | 156169 | 3895 | 151500 | 917 | 50.1183 | 7.309 | 2021-07-21 04:21:40 | Rheinland-Pfalz, Germany | ||
3740786 | 3740786 | 2021-07-12 | Bahamas | 13024 | 252 | 11855 | 917 | 25.025885 | -78.035889 | 2021-07-13 04:21:18 | Bahamas | |||
3659299 | 3659299 | 2021-07-11 | Bahamas | 13024 | 252 | 11855 | 917 | 25.025885 | -78.035889 | 2021-07-12 04:21:34 | Bahamas | |||
625583 | 625583 | 2021-07-10 | Bahamas | 13024 | 252 | 11855 | 917 | 25.025885 | -78.035889 | 2021-07-11 04:21:43 | Bahamas | |||
829302 | 829302 | 2021-07-09 | Bahamas | 13024 | 252 | 11855 | 917 | 25.025885 | -78.035889 | 2021-07-10 04:21:25 | Bahamas | |||
778066 | 778066 | 2021-07-08 | Bahamas | 13024 | 252 | 11855 | 917 | 25.025885 | -78.035889 | 2021-07-09 04:21:21 | Bahamas | |||
3958287 | 3958287 | 2021-06-26 | Chile | Antofagasta | 57029 | 1113 | 54999 | 917 | -23.6509 | -70.3975 | 2021-06-27 04:21:39 | Antofagasta, Chile | ||
3149222 | 3149222 | 2021-06-07 | Ukraine | Zakarpattia Oblast | 61807 | 1595 | 59295 | 917 | 48.6208 | 22.2879 | 2021-06-08 04:22:35 | Zakarpattia Oblast, Ukraine | ||
1310367 | 1310367 | 2021-05-26 | Russia | Ivanovo Oblast | 35982 | 1202 | 33863 | 917 | 56.9167446 | 41.43521370000001 | 2021-05-27 04:20:59 | Ivanovo Oblast, Russia | ||
2939527 | 2939527 | 2021-05-16 | Russia | Kaliningrad Oblast | 32704 | 455 | 31332 | 917 | 54.7293041 | 21.1489473 | 2021-05-17 04:20:34 | Kaliningrad Oblast, Russia | ||
2004936 | 2004936 | 2021-05-12 | Sierra Leone | 4089 | 79 | 3093 | 917 | 8.460555000000001 | -11.779889 | 2021-05-13 04:20:51 | Sierra Leone | |||
3954767 | 3954767 | 2021-05-11 | Sierra Leone | 4089 | 79 | 3093 | 917 | 8.460555000000001 | -11.779889 | 2021-05-12 04:21:29 | Sierra Leone | |||
2821046 | 2821046 | 2021-05-10 | Sierra Leone | 4089 | 79 | 3093 | 917 | 8.460555000000001 | -11.779889 | 2021-05-11 04:20:41 | Sierra Leone | |||
3117162 | 3117162 | 2021-05-06 | Malaysia | Negeri Sembilan | 19266 | 41 | 18308 | 917 | 2.7258 | 101.9424 | 2021-05-07 04:20:40 | Negeri Sembilan, Malaysia | ||
3702079 | 3702079 | 2021-04-27 | India | Tripura | 34862 | 396 | 33549 | 917 | 23.746783 | 91.743565 | 2021-04-28 04:20:32 | Tripura, India | ||
2646004 | 2646004 | 2021-04-08 | Russia | Tula Oblast | 36958 | 1629 | 34412 | 917 | 53.9570701 | 37.3690909 | 2021-04-09 04:21:13 | Tula Oblast, Russia | ||
241450 | 241450 | 2021-04-02 | Russia | Dagestan Republic | 31138 | 1411 | 28810 | 917 | 43.05749160000001 | 47.1332224 | 2021-04-03 04:20:44 | Dagestan Republic, Russia | ||
1980797 | 1980797 | 2021-03-25 | Russia | Adygea Republic | 14039 | 160 | 12962 | 917 | 44.6939006 | 40.1520421 | 2021-03-26 05:26:55 | Adygea Republic, Russia | ||
2207345 | 2207345 | 2021-03-04 | Angola | 20981 | 511 | 19553 | 917 | -11.2027 | 17.8739 | 2021-03-05 05:26:29 | Angola | |||
2368864 | 2368864 | 2021-02-28 | US | Kentucky | Breathitt | 21025 | 923 | 6 | 0 | 917 | 37.52333168 | -83.31959161 | 2021-03-01 05:23:01 | Breathitt, Kentucky, US |
2368766 | 2368766 | 2021-02-28 | US | Kansas | Doniphan | 20043 | 939 | 22 | 0 | 917 | 39.79067154 | -95.14056866 | 2021-03-01 05:23:01 | Doniphan, Kansas, US |
3067268 | 3067268 | 2021-02-27 | US | Kansas | Doniphan | 20043 | 939 | 22 | 0 | 917 | 39.79067154 | -95.14056866 | 2021-02-28 05:22:20 | Doniphan, Kansas, US |
2184950 | 2184950 | 2021-02-26 | US | Kentucky | Breathitt | 21025 | 923 | 6 | 0 | 917 | 37.52333168 | -83.31959161 | 2021-02-27 05:22:28 | Breathitt, Kentucky, US |
2184852 | 2184852 | 2021-02-26 | US | Kansas | Doniphan | 20043 | 939 | 22 | 0 | 917 | 39.79067154 | -95.14056866 | 2021-02-27 05:22:28 | Doniphan, Kansas, US |
282321 | 282321 | 2021-02-24 | US | Nevada | Pershing | 32027 | 936 | 19 | 0 | 917 | 40.44003782 | -118.40056409999998 | 2021-02-25 05:24:57 | Pershing, Nevada, US |
1938589 | 1938589 | 2021-02-23 | US | Nevada | Pershing | 32027 | 936 | 19 | 0 | 917 | 40.44003782 | -118.40056409999998 | 2021-02-24 05:29:16 | Pershing, Nevada, US |
1937803 | 1937803 | 2021-02-23 | US | Kansas | Wilson | 20205 | 931 | 14 | 0 | 917 | 37.55937174 | -95.74323255 | 2021-02-24 05:29:16 | Wilson, Kansas, US |
533567 | 533567 | 2021-02-22 | US | South Dakota | Grant | 46051 | 954 | 37 | 0 | 917 | 45.1723937 | -96.77002276 | 2021-02-23 05:23:41 | Grant, South Dakota, US |
532844 | 532844 | 2021-02-22 | US | Nevada | Pershing | 32027 | 936 | 19 | 0 | 917 | 40.44003782 | -118.40056409999998 | 2021-02-23 05:23:41 | Pershing, Nevada, US |
532058 | 532058 | 2021-02-22 | US | Kansas | Wilson | 20205 | 931 | 14 | 0 | 917 | 37.55937174 | -95.74323255 | 2021-02-23 05:23:41 | Wilson, Kansas, US |
184901 | 184901 | 2021-02-21 | US | South Dakota | Grant | 46051 | 954 | 37 | 0 | 917 | 45.1723937 | -96.77002276 | 2021-02-22 05:24:21 | Grant, South Dakota, US |
184178 | 184178 | 2021-02-21 | US | Nevada | Pershing | 32027 | 936 | 19 | 0 | 917 | 40.44003782 | -118.40056409999998 | 2021-02-22 05:24:21 | Pershing, Nevada, US |
1156612 | 1156612 | 2021-02-18 | US | West Virginia | Monroe | 54063 | 929 | 12 | 0 | 917 | 37.56274716 | -80.54577965 | 2021-02-19 05:24:16 | Monroe, West Virginia, US |
1155489 | 1155489 | 2021-02-18 | US | North Carolina | Washington | 37187 | 945 | 28 | 0 | 917 | 35.83810081 | -76.57299037 | 2021-02-19 05:24:16 | Washington, North Carolina, US |
2679042 | 2679042 | 2021-02-13 | US | Iowa | Montgomery | 19137 | 953 | 36 | 0 | 917 | 41.03018714 | -95.15642896 | 2021-02-14 05:23:43 | Montgomery, Iowa, US |
3540675 | 3540675 | 2021-02-12 | US | Iowa | Montgomery | 19137 | 953 | 36 | 0 | 917 | 41.03018714 | -95.15642896 | 2021-02-13 05:22:12 | Montgomery, Iowa, US |
2641077 | 2641077 | 2021-02-11 | US | Virginia | Lexington | 51678 | 935 | 18 | 0 | 917 | 37.78258621 | -79.44262866 | 2021-02-12 05:23:29 | Lexington, Virginia, US |
3982170 | 3982170 | 2021-02-10 | US | Wyoming | Converse | 56009 | 932 | 15 | 0 | 917 | 42.97272268 | -105.5081848 | 2021-02-11 05:23:55 | Converse, Wyoming, US |
3978771 | 3978771 | 2021-02-10 | Russia | Chuvashia Republic | 20309 | 935 | 18457 | 917 | 55.4259922 | 47.0849429 | 2021-02-11 05:23:55 | Chuvashia Republic, Russia | ||
1531321 | 1531321 | 2021-02-09 | US | Washington | Clallam | 53009 | 923 | 6 | 0 | 917 | 48.04754642 | -123.9226319 | 2021-02-10 05:22:41 | Clallam, Washington, US |
1527834 | 1527834 | 2021-02-09 | India | Andhra Pradesh | 888555 | 7160 | 880478 | 917 | 15.9129 | 79.74 | 2021-02-10 05:22:41 | Andhra Pradesh, India | ||
617112 | 617112 | 2021-02-08 | US | Washington | Clallam | 53009 | 923 | 6 | 0 | 917 | 48.04754642 | -123.9226319 | 2021-02-09 05:23:30 | Clallam, Washington, US |
615075 | 615075 | 2021-02-08 | US | Kentucky | Estill | 21065 | 917 | 0 | 0 | 917 | 37.69241417 | -83.95956369 | 2021-02-09 05:23:30 | Estill, Kentucky, US |
615074 | 615074 | 2021-02-08 | US | Kentucky | Elliott | 21063 | 918 | 1 | 0 | 917 | 38.11624059 | -83.09771563 | 2021-02-09 05:23:30 | Elliott, Kentucky, US |
614470 | 614470 | 2021-02-08 | US | Georgia | Dooly | 13093 | 951 | 34 | 0 | 917 | 32.15630737 | -83.79746561 | 2021-02-09 05:23:30 | Dooly, Georgia, US |
1673844 | 1673844 | 2021-02-07 | US | Kentucky | Estill | 21065 | 917 | 0 | 0 | 917 | 37.69241417 | -83.95956369 | 2021-02-08 05:22:39 | Estill, Kentucky, US |
1673843 | 1673843 | 2021-02-07 | US | Kentucky | Elliott | 21063 | 918 | 1 | 0 | 917 | 38.11624059 | -83.09771563 | 2021-02-08 05:22:39 | Elliott, Kentucky, US |
1673239 | 1673239 | 2021-02-07 | US | Georgia | Dooly | 13093 | 951 | 34 | 0 | 917 | 32.15630737 | -83.79746561 | 2021-02-08 05:22:39 | Dooly, Georgia, US |
976110 | 976110 | 2021-02-06 | US | Iowa | Howard | 19089 | 937 | 20 | 0 | 917 | 43.35671042 | -92.31702714 | 2021-02-07 05:23:00 | Howard, Iowa, US |
975700 | 975700 | 2021-02-06 | US | Georgia | Dooly | 13093 | 951 | 34 | 0 | 917 | 32.15630737 | -83.79746561 | 2021-02-07 05:23:00 | Dooly, Georgia, US |
1897354 | 1897354 | 2021-01-29 | Russia | Kabardino-Balkarian Republic | 18600 | 322 | 17361 | 917 | 43.4806048 | 43.5978976 | 2021-01-30 05:22:49 | Kabardino-Balkarian Republic, Russia | ||
2571254 | 2571254 | 2021-01-25 | US | Wyoming | Big Horn | 56003 | 944 | 27 | 0 | 917 | 44.52405055 | -107.9960365 | 2021-01-26 05:22:02 | Big Horn, Wyoming, US |
2570703 | 2570703 | 2021-01-25 | US | Texas | Clay | 48077 | 963 | 13 | 0 | 917 | 33.78686685 | -98.20771198 | 2021-01-26 05:22:02 | Clay, Texas, US |
2568679 | 2568679 | 2021-01-25 | US | Illinois | Menard | 17129 | 923 | 6 | 0 | 917 | 40.02742725 | -89.80246001 | 2021-01-26 05:22:02 | Menard, Illinois, US |
1762886 | 1762886 | 2021-01-24 | US | Wyoming | Big Horn | 56003 | 944 | 27 | 0 | 917 | 44.52405055 | -107.9960365 | 2021-01-25 05:22:16 | Big Horn, Wyoming, US |
1762335 | 1762335 | 2021-01-24 | US | Texas | Clay | 48077 | 963 | 13 | 0 | 917 | 33.78686685 | -98.20771198 | 2021-01-25 05:22:16 | Clay, Texas, US |
1760558 | 1760558 | 2021-01-24 | US | Kansas | Cloud | 20029 | 939 | 22 | 0 | 917 | 39.48028352 | -97.64925343 | 2021-01-25 05:22:16 | Cloud, Kansas, US |
2430317 | 2430317 | 2021-01-23 | US | Virginia | Westmoreland | 51193 | 931 | 14 | 0 | 917 | 38.11021557 | -76.80213247 | 2021-01-24 05:22:35 | Westmoreland, Virginia, US |
2429942 | 2429942 | 2021-01-23 | US | Texas | Clay | 48077 | 963 | 13 | 0 | 917 | 33.78686685 | -98.20771198 | 2021-01-24 05:22:35 | Clay, Texas, US |
2428165 | 2428165 | 2021-01-23 | US | Kansas | Cloud | 20029 | 939 | 22 | 0 | 917 | 39.48028352 | -97.64925343 | 2021-01-24 05:22:35 | Cloud, Kansas, US |
2468067 | 2468067 | 2021-01-22 | US | Kansas | Cloud | 20029 | 939 | 22 | 0 | 917 | 39.48028352 | -97.64925343 | 2021-01-23 05:22:03 | Cloud, Kansas, US |
438861 | 438861 | 2021-01-21 | US | West Virginia | Taylor | 54091 | 932 | 15 | 0 | 917 | 39.33602617 | -80.0421439 | 2021-01-22 05:22:10 | Taylor, West Virginia, US |
438827 | 438827 | 2021-01-21 | US | West Virginia | Grant | 54023 | 936 | 19 | 0 | 917 | 39.10314817 | -79.19440518 | 2021-01-22 05:22:10 | Grant, West Virginia, US |
436175 | 436175 | 2021-01-21 | US | Georgia | Johnson | 13167 | 951 | 34 | 0 | 917 | 32.70211082 | -82.66166794 | 2021-01-22 05:22:10 | Johnson, Georgia, US |
1097300 | 1097300 | 2021-01-20 | US | Texas | Somervell | 48425 | 934 | 8 | 0 | 917 | 32.22236802 | -97.77403489 | 2021-01-21 05:22:01 | Somervell, Texas, US |
1095207 | 1095207 | 2021-01-20 | US | Indiana | Pulaski | 18131 | 956 | 39 | 0 | 917 | 41.04166107 | -86.69890683 | 2021-01-21 05:22:01 | Pulaski, Indiana, US |
911122 | 911122 | 2021-01-19 | US | Tennessee | Houston | 47083 | 971 | 22 | 0 | 917 | 36.28872054 | -87.71878828 | 2021-01-20 05:21:54 | Houston, Tennessee, US |
240185 | 240185 | 2021-01-18 | US | Tennessee | Houston | 47083 | 968 | 22 | 0 | 917 | 36.28872054 | -87.71878828 | 2021-01-19 05:22:15 | Houston, Tennessee, US |
238984 | 238984 | 2021-01-18 | US | Minnesota | Pipestone | 27117 | 940 | 23 | 0 | 917 | 44.02301619 | -96.25841142 | 2021-01-19 05:22:15 | Pipestone, Minnesota, US |
237733 | 237733 | 2021-01-18 | US | Arkansas | Little River | 5081 | 956 | 39 | 0 | 917 | 33.70375665 | -94.23468591 | 2021-01-19 05:22:15 | Little River, Arkansas, US |
3506302 | 3506302 | 2021-01-17 | US | Tennessee | Houston | 47083 | 967 | 22 | 0 | 917 | 36.28872054 | -87.71878828 | 2021-01-18 05:22:34 | Houston, Tennessee, US |
3504912 | 3504912 | 2021-01-17 | US | Maine | Somerset | 23025 | 942 | 25 | 0 | 917 | 45.51229767 | -69.95995554 | 2021-01-18 05:22:34 | Somerset, Maine, US |
3504063 | 3504063 | 2021-01-17 | US | Florida | Liberty | 12077 | 931 | 14 | 0 | 917 | 30.23766008 | -84.8829258 | 2021-01-18 05:22:34 | Liberty, Florida, US |
3503850 | 3503850 | 2021-01-17 | US | Arkansas | Little River | 5081 | 956 | 39 | 0 | 917 | 33.70375665 | -94.23468591 | 2021-01-18 05:22:34 | Little River, Arkansas, US |
3104062 | 3104062 | 2021-01-16 | US | Oregon | Morrow | 41049 | 927 | 10 | 0 | 917 | 45.41846568 | -119.584546 | 2021-01-17 05:22:17 | Morrow, Oregon, US |
3310216 | 3310216 | 2021-01-13 | US | Montana | Richland | 30083 | 929 | 12 | 0 | 917 | 47.78668011 | -104.5610786 | 2021-01-14 05:22:32 | Richland, Montana, US |
777364 | 777364 | 2021-01-12 | US | Texas | Bosque | 48035 | 1205 | 18 | 0 | 917 | 31.89978581 | -97.63613524 | 2021-01-13 05:22:15 | Bosque, Texas, US |
192490 | 192490 | 2021-01-11 | US | North Dakota | Traill | 38097 | 923 | 17 | 0 | 917 | 47.45367788 | -97.16323288 | 2021-01-12 05:22:15 | Traill, North Dakota, US |
191843 | 191843 | 2021-01-11 | US | Mississippi | Amite | 28005 | 942 | 25 | 0 | 917 | 31.17467303 | -90.80501621 | 2021-01-12 05:22:15 | Amite, Mississippi, US |
191809 | 191809 | 2021-01-11 | US | Minnesota | Pennington | 27113 | 932 | 15 | 0 | 917 | 48.06642577 | -96.0370814 | 2021-01-12 05:22:15 | Pennington, Minnesota, US |
2626648 | 2626648 | 2021-01-10 | US | Georgia | Dade | 13083 | 925 | 8 | 0 | 917 | 34.854916700000004 | -85.50490424 | 2021-01-11 05:21:50 | Dade, Georgia, US |
3900380 | 3900380 | 2021-01-09 | US | Alaska | Kusilvak | 2158 | 920 | 3 | 0 | 917 | 62.15429159999999 | -163.39678830000003 | 2021-01-10 05:22:12 | Kusilvak, Alaska, US |
157282 | 157282 | 2021-01-08 | US | Virginia | Buchanan | 51027 | 940 | 23 | 0 | 917 | 37.26818323 | -82.03749726 | 2021-01-09 05:22:18 | Buchanan, Virginia, US |
156734 | 156734 | 2021-01-08 | US | Puerto Rico | Moca | 72099 | 917 | 0 | 0 | 917 | 18.377805 | -67.080952 | 2021-01-09 05:22:18 | Moca, Puerto Rico, US |
156599 | 156599 | 2021-01-08 | US | Oregon | Lincoln | 41041 | 934 | 17 | 0 | 917 | 44.64252874 | -123.869912 | 2021-01-09 05:22:18 | Lincoln, Oregon, US |
155988 | 155988 | 2021-01-08 | US | Montana | Park | 30067 | 924 | 7 | 0 | 917 | 45.48965095 | -110.52643940000002 | 2021-01-09 05:22:18 | Park, Montana, US |
2544865 | 2544865 | 2021-01-07 | US | West Virginia | Barbour | 54001 | 931 | 14 | 0 | 917 | 39.1307219 | -80.00350858 | 2021-01-08 05:22:42 | Barbour, West Virginia, US |
2544131 | 2544131 | 2021-01-07 | US | Puerto Rico | Corozal | 72047 | 917 | 0 | 0 | 917 | 18.304264 | -66.327738 | 2021-01-08 05:22:42 | Corozal, Puerto Rico, US |
3232167 | 3232167 | 2021-01-03 | US | Minnesota | Kanabec | 27065 | 935 | 18 | 0 | 917 | 45.9459309 | -93.29275192 | 2021-01-04 05:22:02 | Kanabec, Minnesota, US |
2229662 | 2229662 | 2021-01-02 | US | New Hampshire | Carroll | 33003 | 921 | 4 | 0 | 917 | 43.87498583 | -71.20430216 | 2021-01-03 05:22:52 | Carroll, New Hampshire, US |
1139676 | 1139676 | 2021-01-01 | US | South Carolina | Bamberg | 45009 | 957 | 40 | 0 | 917 | 33.21927586 | -81.05659969 | 2021-01-02 05:22:33 | Bamberg, South Carolina, US |
1139086 | 1139086 | 2021-01-01 | US | New Mexico | Socorro | 35053 | 959 | 42 | 0 | 917 | 34.00715494 | -106.9298354 | 2021-01-02 05:22:33 | Socorro, New Mexico, US |
3698282 | 3698282 | 2020-12-31 | US | South Carolina | Bamberg | 45009 | 957 | 40 | 0 | 917 | 33.21927586 | -81.05659969 | 2021-01-01 05:23:07 | Bamberg, South Carolina, US |
3696742 | 3696742 | 2020-12-31 | US | Kansas | Bourbon | 20011 | 927 | 10 | 0 | 917 | 37.85508555 | -94.84865997 | 2021-01-01 05:23:07 | Bourbon, Kansas, US |
1013329 | 1013329 | 2020-12-30 | US | Texas | Burleson | 48051 | 1103 | 14 | 0 | 917 | 30.49273808 | -96.62158484 | 2020-12-31 05:22:49 | Burleson, Texas, US |
1013201 | 1013201 | 2020-12-30 | US | South Dakota | Turner | 46125 | 964 | 47 | 0 | 917 | 43.3109081 | -97.14865776 | 2020-12-31 05:22:49 | Turner, South Dakota, US |
1011557 | 1011557 | 2020-12-30 | US | Kansas | Bourbon | 20011 | 927 | 10 | 0 | 917 | 37.85508555 | -94.84865997 | 2020-12-31 05:22:49 | Bourbon, Kansas, 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]);