johns_hopkins_csse_daily_reports

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

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

279 rows where active = 845 sorted by day descending

✎ View and edit SQL

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
3137695 3137695 2021-07-23 Pakistan Gilgit-Baltistan     7607 122 6640 845 35.792146 74.982138 2021-07-24 00:21:36 Gilgit-Baltistan, Pakistan
3476455 3476455 2021-07-22 Pakistan Gilgit-Baltistan     7607 122 6640 845 35.792146 74.982138 2021-07-23 04:21:29 Gilgit-Baltistan, Pakistan
3632143 3632143 2021-07-14 Russia Altai Republic     18492 259 17388 845 50.7114101 86.8572186 2021-07-15 04:21:48 Altai Republic, Russia
3631732 3631732 2021-07-14 Canada Quebec     376109 11231 364033 845 52.9399 -73.5491 2021-07-15 04:21:48 Quebec, Canada
3659534 3659534 2021-07-11 India Bihar     723283 9618 712820 845 25.679658 85.60484 2021-07-12 04:21:34 Bihar, India
1440815 1440815 2021-07-07 Russia Novgorod Oblast     32841 187 31809 845 58.2843833 32.5169757 2021-07-08 04:21:26 Novgorod Oblast, Russia
2910956 2910956 2021-06-17 Chile Atacama     23386 263 22278 845 -27.5661 -70.0503 2021-06-18 04:22:16 Atacama, Chile
2720602 2720602 2021-06-10 Ukraine Luhansk Oblast     26348 913 24590 845 48.574 39.3078 2021-06-11 04:23:20 Luhansk Oblast, Ukraine
3145535 3145535 2021-06-07 India Lakshadweep     8775 41 7889 845 13.6999972 72.18333259999999 2021-06-08 04:22:35 Lakshadweep, India
2939524 2939524 2021-05-16 Russia Ivanovo Oblast     35389 1176 33368 845 56.9167446 41.43521370000001 2021-05-17 04:20:34 Ivanovo Oblast, Russia
3113345 3113345 2021-05-06 Colombia Sucre     29374 1013 27516 845 8.814 -74.7233 2021-05-07 04:20:40 Sucre, Colombia
954707 954707 2021-04-25 Colombia Cauca     29984 807 28332 845 2.705 -76.82600000000002 2021-04-26 04:21:04 Cauca, Colombia
1571751 1571751 2021-04-22 United Kingdom Bermuda     2261 22 1394 845 32.3078 -64.7505 2021-04-23 04:20:52 Bermuda, United Kingdom
2020984 2020984 2021-04-20 Russia Yamalo-Nenets Autonomous Okrug     38374 413 37116 845 67.1471631 74.3415488 2021-04-21 04:21:14 Yamalo-Nenets Autonomous Okrug, Russia
2575346 2575346 2021-04-13 Zambia       90218 1229 88144 845 -13.133897 27.849332 2021-04-14 04:20:41 Zambia
2571942 2571942 2021-04-13 Russia Zabaykalsky Krai     41701 604 40252 845 52.248521 115.956325 2021-04-14 04:20:41 Zabaykalsky Krai, Russia
2571820 2571820 2021-04-13 Pakistan Balochistan     20499 219 19435 845 28.328492 65.898403 2021-04-14 04:20:41 Balochistan, Pakistan
2983094 2983094 2021-04-10 Colombia Boyaca     48962 1177 46940 845 5.4545 -73.362 2021-04-11 04:20:56 Boyaca, Colombia
3643390 3643390 2021-03-30 Colombia Boyaca     48071 1154 46072 845 5.4545 -73.362 2021-03-31 04:26:25 Boyaca, Colombia
1219796 1219796 2021-03-27 Russia North Ossetia - Alania Republic     16273 161 15267 845 42.79336110000001 44.6324493 2021-03-28 05:28:10 North Ossetia - Alania Republic, Russia
3669570 3669570 2021-03-06 US Missouri Ripley 29181 859 14 0 845 36.65460667 -90.85990261 2021-03-07 05:21:54 Ripley, Missouri, US
3668461 3668461 2021-03-06 US Georgia Montgomery 13209 866 21 0 845 32.17201038 -82.53527476 2021-03-07 05:21:54 Montgomery, Georgia, US
1617096 1617096 2021-03-05 US Georgia Pulaski 13235 884 39 0 845 32.23334561 -83.47549959999998 2021-03-06 04:23:41 Pulaski, Georgia, US
2210390 2210390 2021-03-04 US Puerto Rico Hatillo 72065 845 0 0 845 18.410928 -66.79632600000001 2021-03-05 05:26:29 Hatillo, Puerto Rico, US
2208493 2208493 2021-03-04 US Georgia Montgomery 13209 866 21 0 845 32.17201038 -82.53527476 2021-03-05 05:26:29 Montgomery, Georgia, US
1092811 1092811 2021-03-03 US Puerto Rico Hatillo 72065 845 0 0 845 18.410928 -66.79632600000001 2021-03-04 05:24:24 Hatillo, Puerto Rico, US
3256883 3256883 2021-03-02 US Puerto Rico Hatillo 72065 845 0 0 845 18.410928 -66.79632600000001 2021-03-03 05:23:28 Hatillo, Puerto Rico, US
1860263 1860263 2021-02-25 US New York Schuyler 36097 857 12 0 845 42.39184015 -76.8773299 2021-02-26 05:22:40 Schuyler, New York, US
280539 280539 2021-02-24 US Alabama Coosa 1037 868 23 0 845 32.93690146 -86.24847739 2021-02-25 05:24:57 Coosa, Alabama, US
1936305 1936305 2021-02-23 Colombia Norte de Santander     50521 2688 46988 845 7.9463 -72.8988 2021-02-24 05:29:16 Norte de Santander, Colombia
3053855 3053855 2021-02-16 Malaysia Pahang     3563 13 2705 845 3.8126 103.3256 2021-02-17 05:23:10 Pahang, Malaysia
3051391 3051391 2021-02-16 US Iowa Monroe 19135 872 27 0 845 41.02988815 -92.8690667 2021-02-17 05:23:10 Monroe, Iowa, US
2284287 2284287 2021-02-14 US Georgia Screven 13251 865 20 0 845 32.74976524 -81.60779441 2021-02-15 05:24:49 Screven, Georgia, US
2677773 2677773 2021-02-13 India Haryana     268969 3039 265085 845 29.20004 76.332824 2021-02-14 05:23:43 Haryana, India
3541433 3541433 2021-02-12 US Montana Beaverhead 30001 853 8 0 845 45.13434354 -112.8984694 2021-02-13 05:22:12 Beaverhead, Montana, US
3541013 3541013 2021-02-12 US Maine Sagadahoc 23023 846 1 0 845 43.95415864 -69.85074999 2021-02-13 05:22:12 Sagadahoc, Maine, US
2639696 2639696 2021-02-11 US Montana Beaverhead 30001 853 8 0 845 45.13434354 -112.8984694 2021-02-12 05:23:29 Beaverhead, Montana, US
3982188 3982188 2021-02-10 US Wyoming Washakie 56043 871 26 0 845 43.90451606 -107.68018700000002 2021-02-11 05:23:55 Washakie, Wyoming, US
3980551 3980551 2021-02-10 US Montana Beaverhead 30001 853 8 0 845 45.13434354 -112.8984694 2021-02-11 05:23:55 Beaverhead, Montana, US
3978514 3978514 2021-02-10 India Andhra Pradesh     888605 7161 880599 845 15.9129 79.74 2021-02-11 05:23:55 Andhra Pradesh, India
1529871 1529871 2021-02-09 US Montana Beaverhead 30001 853 8 0 845 45.13434354 -112.8984694 2021-02-10 05:22:41 Beaverhead, Montana, US
615662 615662 2021-02-08 US Montana Beaverhead 30001 853 8 0 845 45.13434354 -112.8984694 2021-02-09 05:23:30 Beaverhead, Montana, US
1674431 1674431 2021-02-07 US Montana Beaverhead 30001 853 8 0 845 45.13434354 -112.8984694 2021-02-08 05:22:39 Beaverhead, Montana, US
977194 977194 2021-02-06 US North Carolina Alleghany 37005 849 4 0 845 36.49360862 -81.12857041 2021-02-07 05:23:00 Alleghany, North Carolina, US
976892 976892 2021-02-06 US Montana Beaverhead 30001 853 8 0 845 45.13434354 -112.8984694 2021-02-07 05:23:00 Beaverhead, Montana, US
1590452 1590452 2021-02-05 US North Carolina Alleghany 37005 849 4 0 845 36.49360862 -81.12857041 2021-02-06 05:23:55 Alleghany, North Carolina, US
1590223 1590223 2021-02-05 US Nebraska Cheyenne 31033 861 16 0 845 41.21999357 -102.9941693 2021-02-06 05:23:55 Cheyenne, Nebraska, US
1590150 1590150 2021-02-05 US Montana Beaverhead 30001 853 8 0 845 45.13434354 -112.8984694 2021-02-06 05:23:55 Beaverhead, Montana, US
1589784 1589784 2021-02-05 US Michigan Benzie 26019 876 31 0 845 44.63899297 -86.01608482 2021-02-06 05:23:55 Benzie, Michigan, US
1588027 1588027 2021-02-05 Colombia Magdalena     30616 1193 28578 845 10.4113 -74.4057 2021-02-06 05:23:55 Magdalena, Colombia
791044 791044 2021-02-04 US Connecticut Unassigned 90009 853 8 0 845 41.85853803 0.0 2021-02-05 05:22:38 Unassigned, Connecticut, US
342036 342036 2021-02-03 US Minnesota Swift 27151 863 18 0 845 45.2829032 -95.68264092 2021-02-04 05:22:26 Swift, Minnesota, US
341642 341642 2021-02-03 US Kentucky Breathitt 21025 849 4 0 845 37.52333168 -83.31959161 2021-02-04 05:22:26 Breathitt, Kentucky, US
1686262 1686262 2021-02-02 US Minnesota Swift 27151 863 18 0 845 45.2829032 -95.68264092 2021-02-03 05:22:52 Swift, Minnesota, US
1686023 1686023 2021-02-02 US Louisiana St. Helena 22091 853 8 0 845 30.82210324 -90.71013176 2021-02-03 05:22:52 St. Helena, Louisiana, US
1678232 1678232 2021-02-01 US Minnesota Swift 27151 863 18 0 845 45.2829032 -95.68264092 2021-02-02 05:22:49 Swift, Minnesota, US
2484457 2484457 2021-01-28 US Ohio Morgan 39115 865 20 0 845 39.62081738 -81.85308173 2021-01-29 05:22:23 Morgan, Ohio, US
13532 13532 2021-01-26 US Iowa Howard 19089 864 19 0 845 43.35671042 -92.31702714 2021-01-27 05:23:41 Howard, Iowa, US
2569701 2569701 2021-01-25 US Nebraska Box Butte 31013 854 9 0 845 42.22079243 -103.0878834 2021-01-26 05:22:02 Box Butte, Nebraska, US
1761395 1761395 2021-01-24 US Nebraska Phelps 31137 853 8 0 845 40.51156033 -99.41461667 2021-01-25 05:22:16 Phelps, Nebraska, US
1760565 1760565 2021-01-24 US Kansas Doniphan 20043 857 12 0 845 39.79067154 -95.14056866 2021-01-25 05:22:16 Doniphan, Kansas, US
1760357 1760357 2021-01-24 US Indiana Brown 18013 882 37 0 845 39.19605589 -86.22868909 2021-01-25 05:22:16 Brown, Indiana, US
2429607 2429607 2021-01-23 US Puerto Rico Aguada 72003 845 0 0 845 18.360255 -67.17513100000001 2021-01-24 05:22:35 Aguada, Puerto Rico, US
2429041 2429041 2021-01-23 US Nevada Pershing 32027 861 16 0 845 40.44003782 -118.40056409999998 2021-01-24 05:22:35 Pershing, Nevada, US
2429002 2429002 2021-01-23 US Nebraska Phelps 31137 853 8 0 845 40.51156033 -99.41461667 2021-01-24 05:22:35 Phelps, Nebraska, US
2428915 2428915 2021-01-23 US Montana Powell 30077 850 5 0 845 46.85538891 -112.9359164 2021-01-24 05:22:35 Powell, Montana, US
2428172 2428172 2021-01-23 US Kansas Doniphan 20043 857 12 0 845 39.79067154 -95.14056866 2021-01-24 05:22:35 Doniphan, Kansas, US
2427782 2427782 2021-01-23 US Georgia Turner 13287 873 28 0 845 31.71612656 -83.62069378 2021-01-24 05:22:35 Turner, Georgia, US
2468074 2468074 2021-01-22 US Kansas Doniphan 20043 857 12 0 845 39.79067154 -95.14056866 2021-01-23 05:22:03 Doniphan, Kansas, US
437939 437939 2021-01-21 US Oklahoma Pushmataha 40127 853 8 0 845 34.41635232 -95.37603505 2021-01-22 05:22:10 Pushmataha, Oklahoma, US
239979 239979 2021-01-18 US Puerto Rico Isabela 72071 845 0 0 845 18.44981 -67.005093 2021-01-19 05:22:15 Isabela, Puerto Rico, US
238638 238638 2021-01-18 US Kentucky Green 21087 856 11 0 845 37.26484328 -85.5540745 2021-01-19 05:22:15 Green, Kentucky, US
3104834 3104834 2021-01-16 US Virginia Rockbridge 51163 854 9 0 845 37.81204314 -79.44605905 2021-01-17 05:22:17 Rockbridge, Virginia, US
775457 775457 2021-01-12 US Indiana Newton 18111 871 26 0 845 40.95610449 -87.39635768 2021-01-13 05:22:15 Newton, Indiana, US
193660 193660 2021-01-11 US Wyoming Converse 56009 856 11 0 845 42.97272268 -105.5081848 2021-01-12 05:22:15 Converse, Wyoming, US
191178 191178 2021-01-11 US Indiana Newton 18111 870 25 0 845 40.95610449 -87.39635768 2021-01-12 05:22:15 Newton, Indiana, US
3035564 3035564 2021-01-05 US Kansas Cloud 20029 867 22 0 845 39.48028352 -97.64925343 2021-01-06 05:22:16 Cloud, Kansas, US
1063252 1063252 2021-01-04 US Kentucky Henry 21103 849 4 0 845 38.44942688 -85.11587507 2021-01-05 05:21:49 Henry, Kentucky, US
2229381 2229381 2021-01-02 US Missouri Bates 29013 857 12 0 845 38.25271289 -94.34113157 2021-01-03 05:22:52 Bates, Missouri, US
1012537 1012537 2020-12-30 US New York Lewis 36049 857 12 0 845 43.7844157 -75.44903992 2020-12-31 05:22:49 Lewis, New York, US
1012047 1012047 2020-12-30 US Minnesota Pipestone 27117 866 21 0 845 44.02301619 -96.25841142 2020-12-31 05:22:49 Pipestone, Minnesota, US
769518 769518 2020-12-29 US Texas Runnels 48399 814 17 0 845 31.8314342 -99.97616148 2020-12-30 05:22:34 Runnels, Texas, US
3764213 3764213 2020-12-28 US Oregon Wasco 41065 867 22 0 845 45.16292781 -121.1670954 2020-12-29 05:22:37 Wasco, Oregon, US
3779273 3779273 2020-12-27 US Kentucky Caldwell 21033 860 15 0 845 37.14749129 -87.86948214 2020-12-28 05:22:06 Caldwell, Kentucky, US
3777703 3777703 2020-12-27 Chile Valparaiso     35252 1238 33169 845 -33.0472 -71.6127 2020-12-28 05:22:06 Valparaiso, Chile
3694203 3694203 2020-12-24 US Puerto Rico Corozal 72047 845 0 0 845 18.304264 -66.327738 2020-12-25 05:22:48 Corozal, Puerto Rico, US
3692447 3692447 2020-12-24 US Illinois De Witt 17039 863 18 0 845 40.17514519 -88.90959682 2020-12-25 05:22:48 De Witt, Illinois, US
2407578 2407578 2020-12-23 US Georgia Bleckley 13023 879 34 0 845 32.43829035 -83.33035166 2020-12-24 05:23:04 Bleckley, Georgia, US
3772669 3772669 2020-12-22 US South Carolina Bamberg 45009 883 38 0 845 33.21927586 -81.05659969 2020-12-23 05:22:03 Bamberg, South Carolina, US
2130229 2130229 2020-12-17 US New York Montgomery 36057 868 23 0 845 42.90123494 -74.44011632 2020-12-18 05:28:18 Montgomery, New York, US
2129958 2129958 2020-12-17 US Missouri Vernon 29217 858 13 0 845 37.8457799 -94.34127305 2020-12-18 05:28:18 Vernon, Missouri, US
2129178 2129178 2020-12-17 US Iowa Guthrie 19077 867 22 0 845 41.68378965 -94.50111014 2020-12-18 05:28:18 Guthrie, Iowa, US
3149973 3149973 2020-12-16 US Alabama Macon 1087 870 25 0 845 32.38759944 -85.69267724 2020-12-17 05:28:12 Macon, Alabama, US
3149972 3149972 2020-12-16 US Alabama Lowndes 1085 876 31 0 845 32.1597283 -86.65158371 2020-12-17 05:28:12 Lowndes, Alabama, US
1036618 1036618 2020-12-15 US New York Orleans 36073 904 59 0 845 43.2516977 -78.2320066 2020-12-16 05:28:04 Orleans, New York, US
1753114 1753114 2020-12-14 US Mississippi Walthall 28147 877 32 0 845 31.14971548 -90.10446654 2020-12-15 05:26:38 Walthall, Mississippi, US
1752164 1752164 2020-12-14 US Georgia Worth 13321 885 40 0 845 31.55162306 -83.85090513 2020-12-15 05:26:38 Worth, Georgia, US
3850684 3850684 2020-12-13 US South Dakota Turner 46125 892 47 0 845 43.3109081 -97.14865776 2020-12-14 05:26:27 Turner, South Dakota, US
3850444 3850444 2020-12-13 US Pennsylvania Elk 42047 857 12 0 845 41.42822061 -78.64524744 2020-12-14 05:26:27 Elk, Pennsylvania, US
3848473 3848473 2020-12-13 US Florida Franklin 12037 849 4 0 845 29.83791238 -84.82731662 2020-12-14 05:26:27 Franklin, Florida, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);