johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
3,700 rows where deaths = 169 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2755830 | 2755830 | 2022-12-29 | US | Tennessee | Carroll | 47017 | 11072 | 169 | 0 | 35.97366108 | -88.45189331 | 2022-12-30 04:21:04 | Carroll, Tennessee, US | |
2754634 | 2754634 | 2022-12-29 | US | Minnesota | Itasca | 27061 | 13255 | 169 | 0 | 47.51009045 | -93.63092229 | 2022-12-30 04:21:04 | Itasca, Minnesota, US | |
2754552 | 2754552 | 2022-12-29 | US | Michigan | Iosco | 26069 | 5583 | 169 | 0 | 44.35486835 | -83.63484895 | 2022-12-30 04:21:04 | Iosco, Michigan, US | |
2754279 | 2754279 | 2022-12-29 | US | Kentucky | Bell | 21013 | 10759 | 169 | 0 | 36.73355174 | -83.67766671 | 2022-12-30 04:21:04 | Bell, Kentucky, US | |
2754026 | 2754026 | 2022-12-29 | US | Indiana | Montgomery | 18107 | 11973 | 169 | 0 | 40.04034823 | -86.89335024 | 2022-12-30 04:21:04 | Montgomery, Indiana, US | |
2753611 | 2753611 | 2022-12-29 | US | Florida | Hendry | 12051 | 13488 | 169 | 0 | 26.55386945 | -81.16469006 | 2022-12-30 04:21:04 | Hendry, Florida, US | |
2753209 | 2753209 | 2022-12-29 | Spain | Melilla | 25166 | 169 | 0 | 35.2923 | -2.9381 | 2022-12-30 04:21:04 | Melilla, Spain | |||
1076836 | 1076836 | 2022-12-28 | US | Tennessee | Carroll | 47017 | 11072 | 169 | 0 | 35.97366108 | -88.45189331 | 2022-12-29 04:21:01 | Carroll, Tennessee, US | |
1075640 | 1075640 | 2022-12-28 | US | Minnesota | Itasca | 27061 | 13210 | 169 | 0 | 47.51009045 | -93.63092229 | 2022-12-29 04:21:01 | Itasca, Minnesota, US | |
1075558 | 1075558 | 2022-12-28 | US | Michigan | Iosco | 26069 | 5583 | 169 | 0 | 44.35486835 | -83.63484895 | 2022-12-29 04:21:01 | Iosco, Michigan, US | |
1075285 | 1075285 | 2022-12-28 | US | Kentucky | Bell | 21013 | 10759 | 169 | 0 | 36.73355174 | -83.67766671 | 2022-12-29 04:21:01 | Bell, Kentucky, US | |
1075032 | 1075032 | 2022-12-28 | US | Indiana | Montgomery | 18107 | 11973 | 169 | 0 | 40.04034823 | -86.89335024 | 2022-12-29 04:21:01 | Montgomery, Indiana, US | |
1074617 | 1074617 | 2022-12-28 | US | Florida | Hendry | 12051 | 13488 | 169 | 0 | 26.55386945 | -81.16469006 | 2022-12-29 04:21:01 | Hendry, Florida, US | |
1074215 | 1074215 | 2022-12-28 | Spain | Melilla | 25166 | 169 | 0 | 35.2923 | -2.9381 | 2022-12-29 04:21:01 | Melilla, Spain | |||
330833 | 330833 | 2022-12-27 | US | Tennessee | Carroll | 47017 | 11072 | 169 | 0 | 35.97366108 | -88.45189331 | 2022-12-28 04:21:04 | Carroll, Tennessee, US | |
329637 | 329637 | 2022-12-27 | US | Minnesota | Itasca | 27061 | 13210 | 169 | 0 | 47.51009045 | -93.63092229 | 2022-12-28 04:21:04 | Itasca, Minnesota, US | |
329555 | 329555 | 2022-12-27 | US | Michigan | Iosco | 26069 | 5583 | 169 | 0 | 44.35486835 | -83.63484895 | 2022-12-28 04:21:04 | Iosco, Michigan, US | |
329282 | 329282 | 2022-12-27 | US | Kentucky | Bell | 21013 | 10759 | 169 | 0 | 36.73355174 | -83.67766671 | 2022-12-28 04:21:04 | Bell, Kentucky, US | |
329120 | 329120 | 2022-12-27 | US | Iowa | Johnson | 19103 | 43853 | 169 | 0 | 41.67169354 | -91.58754744 | 2022-12-28 04:21:04 | Johnson, Iowa, US | |
329029 | 329029 | 2022-12-27 | US | Indiana | Montgomery | 18107 | 11973 | 169 | 0 | 40.04034823 | -86.89335024 | 2022-12-28 04:21:04 | Montgomery, Indiana, US | |
328614 | 328614 | 2022-12-27 | US | Florida | Hendry | 12051 | 13488 | 169 | 0 | 26.55386945 | -81.16469006 | 2022-12-28 04:21:04 | Hendry, Florida, US | |
328212 | 328212 | 2022-12-27 | Spain | Melilla | 25166 | 169 | 0 | 35.2923 | -2.9381 | 2022-12-28 04:21:04 | Melilla, Spain | |||
220906 | 220906 | 2022-12-26 | US | Tennessee | Carroll | 47017 | 11072 | 169 | 0 | 35.97366108 | -88.45189331 | 2022-12-27 04:21:07 | Carroll, Tennessee, US | |
219710 | 219710 | 2022-12-26 | US | Minnesota | Itasca | 27061 | 13210 | 169 | 0 | 47.51009045 | -93.63092229 | 2022-12-27 04:21:07 | Itasca, Minnesota, US | |
219628 | 219628 | 2022-12-26 | US | Michigan | Iosco | 26069 | 5573 | 169 | 0 | 44.35486835 | -83.63484895 | 2022-12-27 04:21:07 | Iosco, Michigan, US | |
219409 | 219409 | 2022-12-26 | US | Kentucky | Knox | 21121 | 14574 | 169 | 0 | 36.89225732 | -83.85403396 | 2022-12-27 04:21:07 | Knox, Kentucky, US | |
219355 | 219355 | 2022-12-26 | US | Kentucky | Bell | 21013 | 10699 | 169 | 0 | 36.73355174 | -83.67766671 | 2022-12-27 04:21:07 | Bell, Kentucky, US | |
219193 | 219193 | 2022-12-26 | US | Iowa | Johnson | 19103 | 43853 | 169 | 0 | 41.67169354 | -91.58754744 | 2022-12-27 04:21:07 | Johnson, Iowa, US | |
219102 | 219102 | 2022-12-26 | US | Indiana | Montgomery | 18107 | 11973 | 169 | 0 | 40.04034823 | -86.89335024 | 2022-12-27 04:21:07 | Montgomery, Indiana, US | |
218687 | 218687 | 2022-12-26 | US | Florida | Hendry | 12051 | 13488 | 169 | 0 | 26.55386945 | -81.16469006 | 2022-12-27 04:21:07 | Hendry, Florida, US | |
218285 | 218285 | 2022-12-26 | Spain | Melilla | 25166 | 169 | 0 | 35.2923 | -2.9381 | 2022-12-27 04:21:07 | Melilla, Spain | |||
3225363 | 3225363 | 2022-12-25 | US | Tennessee | Carroll | 47017 | 11072 | 169 | 0 | 35.97366108 | -88.45189331 | 2022-12-26 04:21:06 | Carroll, Tennessee, US | |
3224167 | 3224167 | 2022-12-25 | US | Minnesota | Itasca | 27061 | 13210 | 169 | 0 | 47.51009045 | -93.63092229 | 2022-12-26 04:21:06 | Itasca, Minnesota, US | |
3224085 | 3224085 | 2022-12-25 | US | Michigan | Iosco | 26069 | 5573 | 169 | 0 | 44.35486835 | -83.63484895 | 2022-12-26 04:21:06 | Iosco, Michigan, US | |
3223866 | 3223866 | 2022-12-25 | US | Kentucky | Knox | 21121 | 14574 | 169 | 0 | 36.89225732 | -83.85403396 | 2022-12-26 04:21:06 | Knox, Kentucky, US | |
3223812 | 3223812 | 2022-12-25 | US | Kentucky | Bell | 21013 | 10699 | 169 | 0 | 36.73355174 | -83.67766671 | 2022-12-26 04:21:06 | Bell, Kentucky, US | |
3223650 | 3223650 | 2022-12-25 | US | Iowa | Johnson | 19103 | 43853 | 169 | 0 | 41.67169354 | -91.58754744 | 2022-12-26 04:21:06 | Johnson, Iowa, US | |
3223559 | 3223559 | 2022-12-25 | US | Indiana | Montgomery | 18107 | 11973 | 169 | 0 | 40.04034823 | -86.89335024 | 2022-12-26 04:21:06 | Montgomery, Indiana, US | |
3223144 | 3223144 | 2022-12-25 | US | Florida | Hendry | 12051 | 13488 | 169 | 0 | 26.55386945 | -81.16469006 | 2022-12-26 04:21:06 | Hendry, Florida, US | |
3222742 | 3222742 | 2022-12-25 | Spain | Melilla | 25166 | 169 | 0 | 35.2923 | -2.9381 | 2022-12-26 04:21:06 | Melilla, Spain | |||
1021277 | 1021277 | 2022-12-24 | US | Tennessee | Carroll | 47017 | 11072 | 169 | 0 | 35.97366108 | -88.45189331 | 2022-12-25 04:21:04 | Carroll, Tennessee, US | |
1020081 | 1020081 | 2022-12-24 | US | Minnesota | Itasca | 27061 | 13210 | 169 | 0 | 47.51009045 | -93.63092229 | 2022-12-25 04:21:04 | Itasca, Minnesota, US | |
1019999 | 1019999 | 2022-12-24 | US | Michigan | Iosco | 26069 | 5573 | 169 | 0 | 44.35486835 | -83.63484895 | 2022-12-25 04:21:04 | Iosco, Michigan, US | |
1019780 | 1019780 | 2022-12-24 | US | Kentucky | Knox | 21121 | 14574 | 169 | 0 | 36.89225732 | -83.85403396 | 2022-12-25 04:21:04 | Knox, Kentucky, US | |
1019726 | 1019726 | 2022-12-24 | US | Kentucky | Bell | 21013 | 10699 | 169 | 0 | 36.73355174 | -83.67766671 | 2022-12-25 04:21:04 | Bell, Kentucky, US | |
1019564 | 1019564 | 2022-12-24 | US | Iowa | Johnson | 19103 | 43853 | 169 | 0 | 41.67169354 | -91.58754744 | 2022-12-25 04:21:04 | Johnson, Iowa, US | |
1019473 | 1019473 | 2022-12-24 | US | Indiana | Montgomery | 18107 | 11973 | 169 | 0 | 40.04034823 | -86.89335024 | 2022-12-25 04:21:04 | Montgomery, Indiana, US | |
1019058 | 1019058 | 2022-12-24 | US | Florida | Hendry | 12051 | 13488 | 169 | 0 | 26.55386945 | -81.16469006 | 2022-12-25 04:21:04 | Hendry, Florida, US | |
1018656 | 1018656 | 2022-12-24 | Spain | Melilla | 25166 | 169 | 0 | 35.2923 | -2.9381 | 2022-12-25 04:21:04 | Melilla, Spain | |||
693300 | 693300 | 2022-12-23 | US | Tennessee | Carroll | 47017 | 11069 | 169 | 0 | 35.97366108 | -88.45189331 | 2022-12-24 04:21:02 | Carroll, Tennessee, US | |
692104 | 692104 | 2022-12-23 | US | Minnesota | Itasca | 27061 | 13210 | 169 | 0 | 47.51009045 | -93.63092229 | 2022-12-24 04:21:02 | Itasca, Minnesota, US | |
692022 | 692022 | 2022-12-23 | US | Michigan | Iosco | 26069 | 5573 | 169 | 0 | 44.35486835 | -83.63484895 | 2022-12-24 04:21:02 | Iosco, Michigan, US | |
691803 | 691803 | 2022-12-23 | US | Kentucky | Knox | 21121 | 14574 | 169 | 0 | 36.89225732 | -83.85403396 | 2022-12-24 04:21:02 | Knox, Kentucky, US | |
691749 | 691749 | 2022-12-23 | US | Kentucky | Bell | 21013 | 10699 | 169 | 0 | 36.73355174 | -83.67766671 | 2022-12-24 04:21:02 | Bell, Kentucky, US | |
691587 | 691587 | 2022-12-23 | US | Iowa | Johnson | 19103 | 43853 | 169 | 0 | 41.67169354 | -91.58754744 | 2022-12-24 04:21:02 | Johnson, Iowa, US | |
691496 | 691496 | 2022-12-23 | US | Indiana | Montgomery | 18107 | 11973 | 169 | 0 | 40.04034823 | -86.89335024 | 2022-12-24 04:21:02 | Montgomery, Indiana, US | |
691081 | 691081 | 2022-12-23 | US | Florida | Hendry | 12051 | 13488 | 169 | 0 | 26.55386945 | -81.16469006 | 2022-12-24 04:21:02 | Hendry, Florida, US | |
690679 | 690679 | 2022-12-23 | Spain | Melilla | 25166 | 169 | 0 | 35.2923 | -2.9381 | 2022-12-24 04:21:02 | Melilla, Spain | |||
2182510 | 2182510 | 2022-12-22 | US | Tennessee | Carroll | 47017 | 11058 | 169 | 0 | 35.97366108 | -88.45189331 | 2022-12-23 04:21:04 | Carroll, Tennessee, US | |
2181314 | 2181314 | 2022-12-22 | US | Minnesota | Itasca | 27061 | 13210 | 169 | 0 | 47.51009045 | -93.63092229 | 2022-12-23 04:21:04 | Itasca, Minnesota, US | |
2181232 | 2181232 | 2022-12-22 | US | Michigan | Iosco | 26069 | 5573 | 169 | 0 | 44.35486835 | -83.63484895 | 2022-12-23 04:21:04 | Iosco, Michigan, US | |
2181013 | 2181013 | 2022-12-22 | US | Kentucky | Knox | 21121 | 14574 | 169 | 0 | 36.89225732 | -83.85403396 | 2022-12-23 04:21:04 | Knox, Kentucky, US | |
2180959 | 2180959 | 2022-12-22 | US | Kentucky | Bell | 21013 | 10699 | 169 | 0 | 36.73355174 | -83.67766671 | 2022-12-23 04:21:04 | Bell, Kentucky, US | |
2180797 | 2180797 | 2022-12-22 | US | Iowa | Johnson | 19103 | 43853 | 169 | 0 | 41.67169354 | -91.58754744 | 2022-12-23 04:21:04 | Johnson, Iowa, US | |
2180706 | 2180706 | 2022-12-22 | US | Indiana | Montgomery | 18107 | 11973 | 169 | 0 | 40.04034823 | -86.89335024 | 2022-12-23 04:21:04 | Montgomery, Indiana, US | |
2180291 | 2180291 | 2022-12-22 | US | Florida | Hendry | 12051 | 13488 | 169 | 0 | 26.55386945 | -81.16469006 | 2022-12-23 04:21:04 | Hendry, Florida, US | |
2179889 | 2179889 | 2022-12-22 | Spain | Melilla | 25103 | 169 | 0 | 35.2923 | -2.9381 | 2022-12-23 04:21:04 | Melilla, Spain | |||
454314 | 454314 | 2022-12-21 | US | Tennessee | Carroll | 47017 | 11054 | 169 | 0 | 35.97366108 | -88.45189331 | 2022-12-22 04:20:56 | Carroll, Tennessee, US | |
453118 | 453118 | 2022-12-21 | US | Minnesota | Itasca | 27061 | 13188 | 169 | 0 | 47.51009045 | -93.63092229 | 2022-12-22 04:20:56 | Itasca, Minnesota, US | |
453036 | 453036 | 2022-12-21 | US | Michigan | Iosco | 26069 | 5573 | 169 | 0 | 44.35486835 | -83.63484895 | 2022-12-22 04:20:56 | Iosco, Michigan, US | |
452817 | 452817 | 2022-12-21 | US | Kentucky | Knox | 21121 | 14574 | 169 | 0 | 36.89225732 | -83.85403396 | 2022-12-22 04:20:56 | Knox, Kentucky, US | |
452763 | 452763 | 2022-12-21 | US | Kentucky | Bell | 21013 | 10699 | 169 | 0 | 36.73355174 | -83.67766671 | 2022-12-22 04:20:56 | Bell, Kentucky, US | |
452601 | 452601 | 2022-12-21 | US | Iowa | Johnson | 19103 | 43853 | 169 | 0 | 41.67169354 | -91.58754744 | 2022-12-22 04:20:56 | Johnson, Iowa, US | |
452510 | 452510 | 2022-12-21 | US | Indiana | Montgomery | 18107 | 11973 | 169 | 0 | 40.04034823 | -86.89335024 | 2022-12-22 04:20:56 | Montgomery, Indiana, US | |
452095 | 452095 | 2022-12-21 | US | Florida | Hendry | 12051 | 13488 | 169 | 0 | 26.55386945 | -81.16469006 | 2022-12-22 04:20:56 | Hendry, Florida, US | |
451693 | 451693 | 2022-12-21 | Spain | Melilla | 25103 | 169 | 0 | 35.2923 | -2.9381 | 2022-12-22 04:20:56 | Melilla, Spain | |||
2954313 | 2954313 | 2022-12-20 | US | Tennessee | Carroll | 47017 | 11041 | 169 | 0 | 35.97366108 | -88.45189331 | 2022-12-21 04:21:03 | Carroll, Tennessee, US | |
2953117 | 2953117 | 2022-12-20 | US | Minnesota | Itasca | 27061 | 13188 | 169 | 0 | 47.51009045 | -93.63092229 | 2022-12-21 04:21:03 | Itasca, Minnesota, US | |
2953035 | 2953035 | 2022-12-20 | US | Michigan | Iosco | 26069 | 5573 | 169 | 0 | 44.35486835 | -83.63484895 | 2022-12-21 04:21:03 | Iosco, Michigan, US | |
2952816 | 2952816 | 2022-12-20 | US | Kentucky | Knox | 21121 | 14574 | 169 | 0 | 36.89225732 | -83.85403396 | 2022-12-21 04:21:03 | Knox, Kentucky, US | |
2952762 | 2952762 | 2022-12-20 | US | Kentucky | Bell | 21013 | 10699 | 169 | 0 | 36.73355174 | -83.67766671 | 2022-12-21 04:21:03 | Bell, Kentucky, US | |
2952600 | 2952600 | 2022-12-20 | US | Iowa | Johnson | 19103 | 43646 | 169 | 0 | 41.67169354 | -91.58754744 | 2022-12-21 04:21:03 | Johnson, Iowa, US | |
2952509 | 2952509 | 2022-12-20 | US | Indiana | Montgomery | 18107 | 11973 | 169 | 0 | 40.04034823 | -86.89335024 | 2022-12-21 04:21:03 | Montgomery, Indiana, US | |
2952094 | 2952094 | 2022-12-20 | US | Florida | Hendry | 12051 | 13488 | 169 | 0 | 26.55386945 | -81.16469006 | 2022-12-21 04:21:03 | Hendry, Florida, US | |
2951692 | 2951692 | 2022-12-20 | Spain | Melilla | 25103 | 169 | 0 | 35.2923 | -2.9381 | 2022-12-21 04:21:03 | Melilla, Spain | |||
3177119 | 3177119 | 2022-12-19 | US | Virginia | Culpeper | 51047 | 13902 | 169 | 0 | 38.48199985 | -77.9563087 | 2022-12-20 04:21:04 | Culpeper, Virginia, US | |
3176715 | 3176715 | 2022-12-19 | US | Tennessee | Carroll | 47017 | 11029 | 169 | 0 | 35.97366108 | -88.45189331 | 2022-12-20 04:21:04 | Carroll, Tennessee, US | |
3176625 | 3176625 | 2022-12-19 | US | South Carolina | Marion | 45067 | 10194 | 169 | 0 | 34.07859748 | -79.36400756 | 2022-12-20 04:21:04 | Marion, South Carolina, US | |
3175519 | 3175519 | 2022-12-19 | US | Minnesota | Itasca | 27061 | 13188 | 169 | 0 | 47.51009045 | -93.63092229 | 2022-12-20 04:21:04 | Itasca, Minnesota, US | |
3175437 | 3175437 | 2022-12-19 | US | Michigan | Iosco | 26069 | 5564 | 169 | 0 | 44.35486835 | -83.63484895 | 2022-12-20 04:21:04 | Iosco, Michigan, US | |
3175218 | 3175218 | 2022-12-19 | US | Kentucky | Knox | 21121 | 14574 | 169 | 0 | 36.89225732 | -83.85403396 | 2022-12-20 04:21:04 | Knox, Kentucky, US | |
3175164 | 3175164 | 2022-12-19 | US | Kentucky | Bell | 21013 | 10699 | 169 | 0 | 36.73355174 | -83.67766671 | 2022-12-20 04:21:04 | Bell, Kentucky, US | |
3175002 | 3175002 | 2022-12-19 | US | Iowa | Johnson | 19103 | 43646 | 169 | 0 | 41.67169354 | -91.58754744 | 2022-12-20 04:21:04 | Johnson, Iowa, US | |
3174911 | 3174911 | 2022-12-19 | US | Indiana | Montgomery | 18107 | 11973 | 169 | 0 | 40.04034823 | -86.89335024 | 2022-12-20 04:21:04 | Montgomery, Indiana, US | |
3174800 | 3174800 | 2022-12-19 | US | Illinois | Kendall | 17093 | 40328 | 169 | 0 | 41.59081014 | -88.42869583 | 2022-12-20 04:21:04 | Kendall, Illinois, US | |
3174496 | 3174496 | 2022-12-19 | US | Florida | Hendry | 12051 | 13488 | 169 | 0 | 26.55386945 | -81.16469006 | 2022-12-20 04:21:04 | Hendry, Florida, US | |
3174094 | 3174094 | 2022-12-19 | Spain | Melilla | 25103 | 169 | 0 | 35.2923 | -2.9381 | 2022-12-20 04:21:04 | Melilla, Spain | |||
1631636 | 1631636 | 2022-12-18 | US | Virginia | Culpeper | 51047 | 13872 | 169 | 0 | 38.48199985 | -77.9563087 | 2022-12-19 04:21:03 | Culpeper, Virginia, US | |
1631232 | 1631232 | 2022-12-18 | US | Tennessee | Carroll | 47017 | 11021 | 169 | 0 | 35.97366108 | -88.45189331 | 2022-12-19 04:21:03 | Carroll, Tennessee, US | |
1631142 | 1631142 | 2022-12-18 | US | South Carolina | Marion | 45067 | 10194 | 169 | 0 | 34.07859748 | -79.36400756 | 2022-12-19 04:21:03 | Marion, South Carolina, 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]);