johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
14,621 rows where deaths = 54 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2756507 | 2756507 | 2022-12-29 | US | Wyoming | Albany | 56001 | 11416 | 54 | 0 | 41.65498705 | -105.7235415 | 2022-12-30 04:21:04 | Albany, Wyoming, US | |
2756454 | 2756454 | 2022-12-29 | US | Wisconsin | Forest | 55041 | 3272 | 54 | 0 | 45.66678019 | -88.77084892 | 2022-12-30 04:21:04 | Forest, Wisconsin, US | |
2756252 | 2756252 | 2022-12-29 | US | Virginia | Giles | 51071 | 5080 | 54 | 0 | 37.31234791 | -80.70636931 | 2022-12-30 04:21:04 | Giles, Virginia, US | |
2755144 | 2755144 | 2022-12-29 | US | New York | Franklin | 36033 | 11843 | 54 | 0 | 44.59040891 | -74.29926032 | 2022-12-30 04:21:04 | Franklin, New York, US | |
2754643 | 2754643 | 2022-12-29 | US | Minnesota | Le Sueur | 27079 | 7386 | 54 | 0 | 44.37136597 | -93.72844721 | 2022-12-30 04:21:04 | Le Sueur, Minnesota, US | |
2754293 | 2754293 | 2022-12-29 | US | Kentucky | Carroll | 21041 | 4230 | 54 | 0 | 38.66599534 | -85.12601074 | 2022-12-30 04:21:04 | Carroll, Kentucky, US | |
2754270 | 2754270 | 2022-12-29 | US | Kansas | Wilson | 20205 | 3387 | 54 | 0 | 37.55937174 | -95.74323255 | 2022-12-30 04:21:04 | Wilson, Kansas, US | |
2754154 | 2754154 | 2022-12-29 | US | Iowa | Union | 19175 | 3130 | 54 | 0 | 41.0277278 | -94.24234847 | 2022-12-30 04:21:04 | Union, Iowa, US | |
2754119 | 2754119 | 2022-12-29 | US | Iowa | Keokuk | 19107 | 2431 | 54 | 0 | 41.33649833 | -92.1785067 | 2022-12-30 04:21:04 | Keokuk, Iowa, US | |
2753967 | 2753967 | 2022-12-29 | US | Illinois | White | 17193 | 5316 | 54 | 0 | 38.08706198 | -88.17657461 | 2022-12-30 04:21:04 | White, Illinois, US | |
2753880 | 2753880 | 2022-12-29 | US | Illinois | Clark | 17023 | 5797 | 54 | 0 | 39.33425789 | -87.78705622 | 2022-12-30 04:21:04 | Clark, Illinois, US | |
2753257 | 2753257 | 2022-12-29 | US | Alabama | Bullock | 1011 | 2886 | 54 | 0 | 32.10030533 | -85.71265535 | 2022-12-30 04:21:04 | Bullock, Alabama, US | |
1077513 | 1077513 | 2022-12-28 | US | Wyoming | Albany | 56001 | 11416 | 54 | 0 | 41.65498705 | -105.7235415 | 2022-12-29 04:21:01 | Albany, Wyoming, US | |
1077460 | 1077460 | 2022-12-28 | US | Wisconsin | Forest | 55041 | 3271 | 54 | 0 | 45.66678019 | -88.77084892 | 2022-12-29 04:21:01 | Forest, Wisconsin, US | |
1077258 | 1077258 | 2022-12-28 | US | Virginia | Giles | 51071 | 5080 | 54 | 0 | 37.31234791 | -80.70636931 | 2022-12-29 04:21:01 | Giles, Virginia, US | |
1076150 | 1076150 | 2022-12-28 | US | New York | Franklin | 36033 | 11835 | 54 | 0 | 44.59040891 | -74.29926032 | 2022-12-29 04:21:01 | Franklin, New York, US | |
1075649 | 1075649 | 2022-12-28 | US | Minnesota | Le Sueur | 27079 | 7362 | 54 | 0 | 44.37136597 | -93.72844721 | 2022-12-29 04:21:01 | Le Sueur, Minnesota, US | |
1075299 | 1075299 | 2022-12-28 | US | Kentucky | Carroll | 21041 | 4230 | 54 | 0 | 38.66599534 | -85.12601074 | 2022-12-29 04:21:01 | Carroll, Kentucky, US | |
1075276 | 1075276 | 2022-12-28 | US | Kansas | Wilson | 20205 | 3387 | 54 | 0 | 37.55937174 | -95.74323255 | 2022-12-29 04:21:01 | Wilson, Kansas, US | |
1075160 | 1075160 | 2022-12-28 | US | Iowa | Union | 19175 | 3130 | 54 | 0 | 41.0277278 | -94.24234847 | 2022-12-29 04:21:01 | Union, Iowa, US | |
1075125 | 1075125 | 2022-12-28 | US | Iowa | Keokuk | 19107 | 2431 | 54 | 0 | 41.33649833 | -92.1785067 | 2022-12-29 04:21:01 | Keokuk, Iowa, US | |
1074973 | 1074973 | 2022-12-28 | US | Illinois | White | 17193 | 5310 | 54 | 0 | 38.08706198 | -88.17657461 | 2022-12-29 04:21:01 | White, Illinois, US | |
1074886 | 1074886 | 2022-12-28 | US | Illinois | Clark | 17023 | 5783 | 54 | 0 | 39.33425789 | -87.78705622 | 2022-12-29 04:21:01 | Clark, Illinois, US | |
1074263 | 1074263 | 2022-12-28 | US | Alabama | Bullock | 1011 | 2886 | 54 | 0 | 32.10030533 | -85.71265535 | 2022-12-29 04:21:01 | Bullock, Alabama, US | |
331510 | 331510 | 2022-12-27 | US | Wyoming | Albany | 56001 | 11416 | 54 | 0 | 41.65498705 | -105.7235415 | 2022-12-28 04:21:04 | Albany, Wyoming, US | |
331457 | 331457 | 2022-12-27 | US | Wisconsin | Forest | 55041 | 3271 | 54 | 0 | 45.66678019 | -88.77084892 | 2022-12-28 04:21:04 | Forest, Wisconsin, US | |
331255 | 331255 | 2022-12-27 | US | Virginia | Giles | 51071 | 5068 | 54 | 0 | 37.31234791 | -80.70636931 | 2022-12-28 04:21:04 | Giles, Virginia, US | |
330147 | 330147 | 2022-12-27 | US | New York | Franklin | 36033 | 11834 | 54 | 0 | 44.59040891 | -74.29926032 | 2022-12-28 04:21:04 | Franklin, New York, US | |
329646 | 329646 | 2022-12-27 | US | Minnesota | Le Sueur | 27079 | 7362 | 54 | 0 | 44.37136597 | -93.72844721 | 2022-12-28 04:21:04 | Le Sueur, Minnesota, US | |
329296 | 329296 | 2022-12-27 | US | Kentucky | Carroll | 21041 | 4230 | 54 | 0 | 38.66599534 | -85.12601074 | 2022-12-28 04:21:04 | Carroll, Kentucky, US | |
329273 | 329273 | 2022-12-27 | US | Kansas | Wilson | 20205 | 3382 | 54 | 0 | 37.55937174 | -95.74323255 | 2022-12-28 04:21:04 | Wilson, Kansas, US | |
329157 | 329157 | 2022-12-27 | US | Iowa | Union | 19175 | 3127 | 54 | 0 | 41.0277278 | -94.24234847 | 2022-12-28 04:21:04 | Union, Iowa, US | |
329151 | 329151 | 2022-12-27 | US | Iowa | Shelby | 19165 | 3093 | 54 | 0 | 41.6850066 | -95.31015553 | 2022-12-28 04:21:04 | Shelby, Iowa, US | |
329122 | 329122 | 2022-12-27 | US | Iowa | Keokuk | 19107 | 2423 | 54 | 0 | 41.33649833 | -92.1785067 | 2022-12-28 04:21:04 | Keokuk, Iowa, US | |
328970 | 328970 | 2022-12-27 | US | Illinois | White | 17193 | 5305 | 54 | 0 | 38.08706198 | -88.17657461 | 2022-12-28 04:21:04 | White, Illinois, US | |
328883 | 328883 | 2022-12-27 | US | Illinois | Clark | 17023 | 5782 | 54 | 0 | 39.33425789 | -87.78705622 | 2022-12-28 04:21:04 | Clark, Illinois, US | |
328260 | 328260 | 2022-12-27 | US | Alabama | Bullock | 1011 | 2886 | 54 | 0 | 32.10030533 | -85.71265535 | 2022-12-28 04:21:04 | Bullock, Alabama, US | |
221583 | 221583 | 2022-12-26 | US | Wyoming | Albany | 56001 | 11405 | 54 | 0 | 41.65498705 | -105.7235415 | 2022-12-27 04:21:07 | Albany, Wyoming, US | |
221530 | 221530 | 2022-12-26 | US | Wisconsin | Forest | 55041 | 3270 | 54 | 0 | 45.66678019 | -88.77084892 | 2022-12-27 04:21:07 | Forest, Wisconsin, US | |
221328 | 221328 | 2022-12-26 | US | Virginia | Giles | 51071 | 5065 | 54 | 0 | 37.31234791 | -80.70636931 | 2022-12-27 04:21:07 | Giles, Virginia, US | |
220220 | 220220 | 2022-12-26 | US | New York | Franklin | 36033 | 11831 | 54 | 0 | 44.59040891 | -74.29926032 | 2022-12-27 04:21:07 | Franklin, New York, US | |
219719 | 219719 | 2022-12-26 | US | Minnesota | Le Sueur | 27079 | 7362 | 54 | 0 | 44.37136597 | -93.72844721 | 2022-12-27 04:21:07 | Le Sueur, Minnesota, US | |
219369 | 219369 | 2022-12-26 | US | Kentucky | Carroll | 21041 | 4207 | 54 | 0 | 38.66599534 | -85.12601074 | 2022-12-27 04:21:07 | Carroll, Kentucky, US | |
219346 | 219346 | 2022-12-26 | US | Kansas | Wilson | 20205 | 3382 | 54 | 0 | 37.55937174 | -95.74323255 | 2022-12-27 04:21:07 | Wilson, Kansas, US | |
219230 | 219230 | 2022-12-26 | US | Iowa | Union | 19175 | 3127 | 54 | 0 | 41.0277278 | -94.24234847 | 2022-12-27 04:21:07 | Union, Iowa, US | |
219224 | 219224 | 2022-12-26 | US | Iowa | Shelby | 19165 | 3093 | 54 | 0 | 41.6850066 | -95.31015553 | 2022-12-27 04:21:07 | Shelby, Iowa, US | |
219195 | 219195 | 2022-12-26 | US | Iowa | Keokuk | 19107 | 2423 | 54 | 0 | 41.33649833 | -92.1785067 | 2022-12-27 04:21:07 | Keokuk, Iowa, US | |
219043 | 219043 | 2022-12-26 | US | Illinois | White | 17193 | 5299 | 54 | 0 | 38.08706198 | -88.17657461 | 2022-12-27 04:21:07 | White, Illinois, US | |
218956 | 218956 | 2022-12-26 | US | Illinois | Clark | 17023 | 5774 | 54 | 0 | 39.33425789 | -87.78705622 | 2022-12-27 04:21:07 | Clark, Illinois, US | |
218333 | 218333 | 2022-12-26 | US | Alabama | Bullock | 1011 | 2886 | 54 | 0 | 32.10030533 | -85.71265535 | 2022-12-27 04:21:07 | Bullock, Alabama, US | |
3226040 | 3226040 | 2022-12-25 | US | Wyoming | Albany | 56001 | 11405 | 54 | 0 | 41.65498705 | -105.7235415 | 2022-12-26 04:21:06 | Albany, Wyoming, US | |
3225987 | 3225987 | 2022-12-25 | US | Wisconsin | Forest | 55041 | 3270 | 54 | 0 | 45.66678019 | -88.77084892 | 2022-12-26 04:21:06 | Forest, Wisconsin, US | |
3225785 | 3225785 | 2022-12-25 | US | Virginia | Giles | 51071 | 5053 | 54 | 0 | 37.31234791 | -80.70636931 | 2022-12-26 04:21:06 | Giles, Virginia, US | |
3224677 | 3224677 | 2022-12-25 | US | New York | Franklin | 36033 | 11830 | 54 | 0 | 44.59040891 | -74.29926032 | 2022-12-26 04:21:06 | Franklin, New York, US | |
3224176 | 3224176 | 2022-12-25 | US | Minnesota | Le Sueur | 27079 | 7362 | 54 | 0 | 44.37136597 | -93.72844721 | 2022-12-26 04:21:06 | Le Sueur, Minnesota, US | |
3223826 | 3223826 | 2022-12-25 | US | Kentucky | Carroll | 21041 | 4207 | 54 | 0 | 38.66599534 | -85.12601074 | 2022-12-26 04:21:06 | Carroll, Kentucky, US | |
3223803 | 3223803 | 2022-12-25 | US | Kansas | Wilson | 20205 | 3382 | 54 | 0 | 37.55937174 | -95.74323255 | 2022-12-26 04:21:06 | Wilson, Kansas, US | |
3223687 | 3223687 | 2022-12-25 | US | Iowa | Union | 19175 | 3127 | 54 | 0 | 41.0277278 | -94.24234847 | 2022-12-26 04:21:06 | Union, Iowa, US | |
3223681 | 3223681 | 2022-12-25 | US | Iowa | Shelby | 19165 | 3093 | 54 | 0 | 41.6850066 | -95.31015553 | 2022-12-26 04:21:06 | Shelby, Iowa, US | |
3223652 | 3223652 | 2022-12-25 | US | Iowa | Keokuk | 19107 | 2423 | 54 | 0 | 41.33649833 | -92.1785067 | 2022-12-26 04:21:06 | Keokuk, Iowa, US | |
3223500 | 3223500 | 2022-12-25 | US | Illinois | White | 17193 | 5299 | 54 | 0 | 38.08706198 | -88.17657461 | 2022-12-26 04:21:06 | White, Illinois, US | |
3223413 | 3223413 | 2022-12-25 | US | Illinois | Clark | 17023 | 5774 | 54 | 0 | 39.33425789 | -87.78705622 | 2022-12-26 04:21:06 | Clark, Illinois, US | |
3222790 | 3222790 | 2022-12-25 | US | Alabama | Bullock | 1011 | 2886 | 54 | 0 | 32.10030533 | -85.71265535 | 2022-12-26 04:21:06 | Bullock, Alabama, US | |
1021954 | 1021954 | 2022-12-24 | US | Wyoming | Albany | 56001 | 11405 | 54 | 0 | 41.65498705 | -105.7235415 | 2022-12-25 04:21:04 | Albany, Wyoming, US | |
1021901 | 1021901 | 2022-12-24 | US | Wisconsin | Forest | 55041 | 3270 | 54 | 0 | 45.66678019 | -88.77084892 | 2022-12-25 04:21:04 | Forest, Wisconsin, US | |
1021699 | 1021699 | 2022-12-24 | US | Virginia | Giles | 51071 | 5053 | 54 | 0 | 37.31234791 | -80.70636931 | 2022-12-25 04:21:04 | Giles, Virginia, US | |
1020591 | 1020591 | 2022-12-24 | US | New York | Franklin | 36033 | 11826 | 54 | 0 | 44.59040891 | -74.29926032 | 2022-12-25 04:21:04 | Franklin, New York, US | |
1020090 | 1020090 | 2022-12-24 | US | Minnesota | Le Sueur | 27079 | 7362 | 54 | 0 | 44.37136597 | -93.72844721 | 2022-12-25 04:21:04 | Le Sueur, Minnesota, US | |
1019740 | 1019740 | 2022-12-24 | US | Kentucky | Carroll | 21041 | 4207 | 54 | 0 | 38.66599534 | -85.12601074 | 2022-12-25 04:21:04 | Carroll, Kentucky, US | |
1019717 | 1019717 | 2022-12-24 | US | Kansas | Wilson | 20205 | 3382 | 54 | 0 | 37.55937174 | -95.74323255 | 2022-12-25 04:21:04 | Wilson, Kansas, US | |
1019601 | 1019601 | 2022-12-24 | US | Iowa | Union | 19175 | 3127 | 54 | 0 | 41.0277278 | -94.24234847 | 2022-12-25 04:21:04 | Union, Iowa, US | |
1019595 | 1019595 | 2022-12-24 | US | Iowa | Shelby | 19165 | 3093 | 54 | 0 | 41.6850066 | -95.31015553 | 2022-12-25 04:21:04 | Shelby, Iowa, US | |
1019566 | 1019566 | 2022-12-24 | US | Iowa | Keokuk | 19107 | 2423 | 54 | 0 | 41.33649833 | -92.1785067 | 2022-12-25 04:21:04 | Keokuk, Iowa, US | |
1019414 | 1019414 | 2022-12-24 | US | Illinois | White | 17193 | 5299 | 54 | 0 | 38.08706198 | -88.17657461 | 2022-12-25 04:21:04 | White, Illinois, US | |
1019327 | 1019327 | 2022-12-24 | US | Illinois | Clark | 17023 | 5774 | 54 | 0 | 39.33425789 | -87.78705622 | 2022-12-25 04:21:04 | Clark, Illinois, US | |
1018704 | 1018704 | 2022-12-24 | US | Alabama | Bullock | 1011 | 2886 | 54 | 0 | 32.10030533 | -85.71265535 | 2022-12-25 04:21:04 | Bullock, Alabama, US | |
693977 | 693977 | 2022-12-23 | US | Wyoming | Albany | 56001 | 11405 | 54 | 0 | 41.65498705 | -105.7235415 | 2022-12-24 04:21:02 | Albany, Wyoming, US | |
693924 | 693924 | 2022-12-23 | US | Wisconsin | Forest | 55041 | 3270 | 54 | 0 | 45.66678019 | -88.77084892 | 2022-12-24 04:21:02 | Forest, Wisconsin, US | |
693722 | 693722 | 2022-12-23 | US | Virginia | Giles | 51071 | 5053 | 54 | 0 | 37.31234791 | -80.70636931 | 2022-12-24 04:21:02 | Giles, Virginia, US | |
692614 | 692614 | 2022-12-23 | US | New York | Franklin | 36033 | 11824 | 54 | 0 | 44.59040891 | -74.29926032 | 2022-12-24 04:21:02 | Franklin, New York, US | |
692113 | 692113 | 2022-12-23 | US | Minnesota | Le Sueur | 27079 | 7362 | 54 | 0 | 44.37136597 | -93.72844721 | 2022-12-24 04:21:02 | Le Sueur, Minnesota, US | |
691763 | 691763 | 2022-12-23 | US | Kentucky | Carroll | 21041 | 4207 | 54 | 0 | 38.66599534 | -85.12601074 | 2022-12-24 04:21:02 | Carroll, Kentucky, US | |
691740 | 691740 | 2022-12-23 | US | Kansas | Wilson | 20205 | 3382 | 54 | 0 | 37.55937174 | -95.74323255 | 2022-12-24 04:21:02 | Wilson, Kansas, US | |
691624 | 691624 | 2022-12-23 | US | Iowa | Union | 19175 | 3127 | 54 | 0 | 41.0277278 | -94.24234847 | 2022-12-24 04:21:02 | Union, Iowa, US | |
691618 | 691618 | 2022-12-23 | US | Iowa | Shelby | 19165 | 3093 | 54 | 0 | 41.6850066 | -95.31015553 | 2022-12-24 04:21:02 | Shelby, Iowa, US | |
691589 | 691589 | 2022-12-23 | US | Iowa | Keokuk | 19107 | 2423 | 54 | 0 | 41.33649833 | -92.1785067 | 2022-12-24 04:21:02 | Keokuk, Iowa, US | |
691437 | 691437 | 2022-12-23 | US | Illinois | White | 17193 | 5299 | 54 | 0 | 38.08706198 | -88.17657461 | 2022-12-24 04:21:02 | White, Illinois, US | |
691350 | 691350 | 2022-12-23 | US | Illinois | Clark | 17023 | 5774 | 54 | 0 | 39.33425789 | -87.78705622 | 2022-12-24 04:21:02 | Clark, Illinois, US | |
690727 | 690727 | 2022-12-23 | US | Alabama | Bullock | 1011 | 2886 | 54 | 0 | 32.10030533 | -85.71265535 | 2022-12-24 04:21:02 | Bullock, Alabama, US | |
2183187 | 2183187 | 2022-12-22 | US | Wyoming | Albany | 56001 | 11405 | 54 | 0 | 41.65498705 | -105.7235415 | 2022-12-23 04:21:04 | Albany, Wyoming, US | |
2183134 | 2183134 | 2022-12-22 | US | Wisconsin | Forest | 55041 | 3271 | 54 | 0 | 45.66678019 | -88.77084892 | 2022-12-23 04:21:04 | Forest, Wisconsin, US | |
2182932 | 2182932 | 2022-12-22 | US | Virginia | Giles | 51071 | 5046 | 54 | 0 | 37.31234791 | -80.70636931 | 2022-12-23 04:21:04 | Giles, Virginia, US | |
2181824 | 2181824 | 2022-12-22 | US | New York | Franklin | 36033 | 11813 | 54 | 0 | 44.59040891 | -74.29926032 | 2022-12-23 04:21:04 | Franklin, New York, US | |
2181323 | 2181323 | 2022-12-22 | US | Minnesota | Le Sueur | 27079 | 7362 | 54 | 0 | 44.37136597 | -93.72844721 | 2022-12-23 04:21:04 | Le Sueur, Minnesota, US | |
2180973 | 2180973 | 2022-12-22 | US | Kentucky | Carroll | 21041 | 4207 | 54 | 0 | 38.66599534 | -85.12601074 | 2022-12-23 04:21:04 | Carroll, Kentucky, US | |
2180950 | 2180950 | 2022-12-22 | US | Kansas | Wilson | 20205 | 3382 | 54 | 0 | 37.55937174 | -95.74323255 | 2022-12-23 04:21:04 | Wilson, Kansas, US | |
2180834 | 2180834 | 2022-12-22 | US | Iowa | Union | 19175 | 3127 | 54 | 0 | 41.0277278 | -94.24234847 | 2022-12-23 04:21:04 | Union, Iowa, US | |
2180828 | 2180828 | 2022-12-22 | US | Iowa | Shelby | 19165 | 3093 | 54 | 0 | 41.6850066 | -95.31015553 | 2022-12-23 04:21:04 | Shelby, Iowa, US | |
2180799 | 2180799 | 2022-12-22 | US | Iowa | Keokuk | 19107 | 2423 | 54 | 0 | 41.33649833 | -92.1785067 | 2022-12-23 04:21:04 | Keokuk, Iowa, US | |
2180647 | 2180647 | 2022-12-22 | US | Illinois | White | 17193 | 5296 | 54 | 0 | 38.08706198 | -88.17657461 | 2022-12-23 04:21:04 | White, Illinois, 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]);