johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
3,671 rows where deaths = 159 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2755752 | 2755752 | 2022-12-29 | US | South Carolina | Union | 45087 | 9411 | 159 | 0 | 34.68835752 | -81.61730349 | 2022-12-30 04:21:04 | Union, South Carolina, US | |
2755613 | 2755613 | 2022-12-29 | US | Pennsylvania | Union | 42119 | 13303 | 159 | 0 | 40.96188846 | -77.05996014 | 2022-12-30 04:21:04 | Union, Pennsylvania, US | |
2755358 | 2755358 | 2022-12-29 | US | Ohio | Champaign | 39021 | 10541 | 159 | 0 | 40.13923427 | -83.76875242 | 2022-12-30 04:21:04 | Champaign, Ohio, US | |
2754755 | 2754755 | 2022-12-29 | US | Mississippi | Simpson | 28127 | 8308 | 159 | 0 | 31.91282117 | -89.91716179 | 2022-12-30 04:21:04 | Simpson, Mississippi, US | |
2754040 | 2754040 | 2022-12-29 | US | Indiana | Randolph | 18135 | 6775 | 159 | 0 | 40.15734772 | -85.01139319 | 2022-12-30 04:21:04 | Randolph, Indiana, US | |
2753993 | 2753993 | 2022-12-29 | US | Indiana | Fayette | 18041 | 8036 | 159 | 0 | 39.63684962 | -85.17797541 | 2022-12-30 04:21:04 | Fayette, Indiana, US | |
1076758 | 1076758 | 2022-12-28 | US | South Carolina | Union | 45087 | 9411 | 159 | 0 | 34.68835752 | -81.61730349 | 2022-12-29 04:21:01 | Union, South Carolina, US | |
1076619 | 1076619 | 2022-12-28 | US | Pennsylvania | Union | 42119 | 13303 | 159 | 0 | 40.96188846 | -77.05996014 | 2022-12-29 04:21:01 | Union, Pennsylvania, US | |
1076364 | 1076364 | 2022-12-28 | US | Ohio | Champaign | 39021 | 10507 | 159 | 0 | 40.13923427 | -83.76875242 | 2022-12-29 04:21:01 | Champaign, Ohio, US | |
1075761 | 1075761 | 2022-12-28 | US | Mississippi | Simpson | 28127 | 8308 | 159 | 0 | 31.91282117 | -89.91716179 | 2022-12-29 04:21:01 | Simpson, Mississippi, US | |
1075046 | 1075046 | 2022-12-28 | US | Indiana | Randolph | 18135 | 6775 | 159 | 0 | 40.15734772 | -85.01139319 | 2022-12-29 04:21:01 | Randolph, Indiana, US | |
1074999 | 1074999 | 2022-12-28 | US | Indiana | Fayette | 18041 | 8036 | 159 | 0 | 39.63684962 | -85.17797541 | 2022-12-29 04:21:01 | Fayette, Indiana, US | |
330755 | 330755 | 2022-12-27 | US | South Carolina | Union | 45087 | 9411 | 159 | 0 | 34.68835752 | -81.61730349 | 2022-12-28 04:21:04 | Union, South Carolina, US | |
330616 | 330616 | 2022-12-27 | US | Pennsylvania | Union | 42119 | 13275 | 159 | 0 | 40.96188846 | -77.05996014 | 2022-12-28 04:21:04 | Union, Pennsylvania, US | |
330361 | 330361 | 2022-12-27 | US | Ohio | Champaign | 39021 | 10507 | 159 | 0 | 40.13923427 | -83.76875242 | 2022-12-28 04:21:04 | Champaign, Ohio, US | |
329758 | 329758 | 2022-12-27 | US | Mississippi | Simpson | 28127 | 8308 | 159 | 0 | 31.91282117 | -89.91716179 | 2022-12-28 04:21:04 | Simpson, Mississippi, US | |
329043 | 329043 | 2022-12-27 | US | Indiana | Randolph | 18135 | 6775 | 159 | 0 | 40.15734772 | -85.01139319 | 2022-12-28 04:21:04 | Randolph, Indiana, US | |
328996 | 328996 | 2022-12-27 | US | Indiana | Fayette | 18041 | 8036 | 159 | 0 | 39.63684962 | -85.17797541 | 2022-12-28 04:21:04 | Fayette, Indiana, US | |
328861 | 328861 | 2022-12-27 | US | Idaho | Nez Perce | 16069 | 10396 | 159 | 0 | 46.32638236 | -116.7500975 | 2022-12-28 04:21:04 | Nez Perce, Idaho, US | |
220828 | 220828 | 2022-12-26 | US | South Carolina | Union | 45087 | 9319 | 159 | 0 | 34.68835752 | -81.61730349 | 2022-12-27 04:21:07 | Union, South Carolina, US | |
220795 | 220795 | 2022-12-26 | US | South Carolina | Chester | 45023 | 12082 | 159 | 0 | 34.69249168 | -81.1583216 | 2022-12-27 04:21:07 | Chester, South Carolina, US | |
220689 | 220689 | 2022-12-26 | US | Pennsylvania | Union | 42119 | 13275 | 159 | 0 | 40.96188846 | -77.05996014 | 2022-12-27 04:21:07 | Union, Pennsylvania, US | |
220434 | 220434 | 2022-12-26 | US | Ohio | Champaign | 39021 | 10507 | 159 | 0 | 40.13923427 | -83.76875242 | 2022-12-27 04:21:07 | Champaign, Ohio, US | |
219441 | 219441 | 2022-12-26 | US | Kentucky | Oldham | 21185 | 22336 | 159 | 0 | 38.39791089 | -85.448222 | 2022-12-27 04:21:07 | Oldham, Kentucky, US | |
219116 | 219116 | 2022-12-26 | US | Indiana | Randolph | 18135 | 6775 | 159 | 0 | 40.15734772 | -85.01139319 | 2022-12-27 04:21:07 | Randolph, Indiana, US | |
219069 | 219069 | 2022-12-26 | US | Indiana | Fayette | 18041 | 8036 | 159 | 0 | 39.63684962 | -85.17797541 | 2022-12-27 04:21:07 | Fayette, Indiana, US | |
218934 | 218934 | 2022-12-26 | US | Idaho | Nez Perce | 16069 | 10396 | 159 | 0 | 46.32638236 | -116.7500975 | 2022-12-27 04:21:07 | Nez Perce, Idaho, US | |
3225285 | 3225285 | 2022-12-25 | US | South Carolina | Union | 45087 | 9319 | 159 | 0 | 34.68835752 | -81.61730349 | 2022-12-26 04:21:06 | Union, South Carolina, US | |
3225252 | 3225252 | 2022-12-25 | US | South Carolina | Chester | 45023 | 12082 | 159 | 0 | 34.69249168 | -81.1583216 | 2022-12-26 04:21:06 | Chester, South Carolina, US | |
3225146 | 3225146 | 2022-12-25 | US | Pennsylvania | Union | 42119 | 13275 | 159 | 0 | 40.96188846 | -77.05996014 | 2022-12-26 04:21:06 | Union, Pennsylvania, US | |
3224891 | 3224891 | 2022-12-25 | US | Ohio | Champaign | 39021 | 10507 | 159 | 0 | 40.13923427 | -83.76875242 | 2022-12-26 04:21:06 | Champaign, Ohio, US | |
3223898 | 3223898 | 2022-12-25 | US | Kentucky | Oldham | 21185 | 22336 | 159 | 0 | 38.39791089 | -85.448222 | 2022-12-26 04:21:06 | Oldham, Kentucky, US | |
3223573 | 3223573 | 2022-12-25 | US | Indiana | Randolph | 18135 | 6775 | 159 | 0 | 40.15734772 | -85.01139319 | 2022-12-26 04:21:06 | Randolph, Indiana, US | |
3223526 | 3223526 | 2022-12-25 | US | Indiana | Fayette | 18041 | 8036 | 159 | 0 | 39.63684962 | -85.17797541 | 2022-12-26 04:21:06 | Fayette, Indiana, US | |
3223391 | 3223391 | 2022-12-25 | US | Idaho | Nez Perce | 16069 | 10396 | 159 | 0 | 46.32638236 | -116.7500975 | 2022-12-26 04:21:06 | Nez Perce, Idaho, US | |
1021199 | 1021199 | 2022-12-24 | US | South Carolina | Union | 45087 | 9319 | 159 | 0 | 34.68835752 | -81.61730349 | 2022-12-25 04:21:04 | Union, South Carolina, US | |
1021166 | 1021166 | 2022-12-24 | US | South Carolina | Chester | 45023 | 12082 | 159 | 0 | 34.69249168 | -81.1583216 | 2022-12-25 04:21:04 | Chester, South Carolina, US | |
1021060 | 1021060 | 2022-12-24 | US | Pennsylvania | Union | 42119 | 13275 | 159 | 0 | 40.96188846 | -77.05996014 | 2022-12-25 04:21:04 | Union, Pennsylvania, US | |
1020805 | 1020805 | 2022-12-24 | US | Ohio | Champaign | 39021 | 10507 | 159 | 0 | 40.13923427 | -83.76875242 | 2022-12-25 04:21:04 | Champaign, Ohio, US | |
1019812 | 1019812 | 2022-12-24 | US | Kentucky | Oldham | 21185 | 22336 | 159 | 0 | 38.39791089 | -85.448222 | 2022-12-25 04:21:04 | Oldham, Kentucky, US | |
1019487 | 1019487 | 2022-12-24 | US | Indiana | Randolph | 18135 | 6775 | 159 | 0 | 40.15734772 | -85.01139319 | 2022-12-25 04:21:04 | Randolph, Indiana, US | |
1019440 | 1019440 | 2022-12-24 | US | Indiana | Fayette | 18041 | 8036 | 159 | 0 | 39.63684962 | -85.17797541 | 2022-12-25 04:21:04 | Fayette, Indiana, US | |
1019305 | 1019305 | 2022-12-24 | US | Idaho | Nez Perce | 16069 | 10396 | 159 | 0 | 46.32638236 | -116.7500975 | 2022-12-25 04:21:04 | Nez Perce, Idaho, US | |
693222 | 693222 | 2022-12-23 | US | South Carolina | Union | 45087 | 9319 | 159 | 0 | 34.68835752 | -81.61730349 | 2022-12-24 04:21:02 | Union, South Carolina, US | |
693189 | 693189 | 2022-12-23 | US | South Carolina | Chester | 45023 | 12082 | 159 | 0 | 34.69249168 | -81.1583216 | 2022-12-24 04:21:02 | Chester, South Carolina, US | |
693083 | 693083 | 2022-12-23 | US | Pennsylvania | Union | 42119 | 13275 | 159 | 0 | 40.96188846 | -77.05996014 | 2022-12-24 04:21:02 | Union, Pennsylvania, US | |
692828 | 692828 | 2022-12-23 | US | Ohio | Champaign | 39021 | 10507 | 159 | 0 | 40.13923427 | -83.76875242 | 2022-12-24 04:21:02 | Champaign, Ohio, US | |
691835 | 691835 | 2022-12-23 | US | Kentucky | Oldham | 21185 | 22336 | 159 | 0 | 38.39791089 | -85.448222 | 2022-12-24 04:21:02 | Oldham, Kentucky, US | |
691510 | 691510 | 2022-12-23 | US | Indiana | Randolph | 18135 | 6775 | 159 | 0 | 40.15734772 | -85.01139319 | 2022-12-24 04:21:02 | Randolph, Indiana, US | |
691463 | 691463 | 2022-12-23 | US | Indiana | Fayette | 18041 | 8036 | 159 | 0 | 39.63684962 | -85.17797541 | 2022-12-24 04:21:02 | Fayette, Indiana, US | |
691328 | 691328 | 2022-12-23 | US | Idaho | Nez Perce | 16069 | 10396 | 159 | 0 | 46.32638236 | -116.7500975 | 2022-12-24 04:21:02 | Nez Perce, Idaho, US | |
2182432 | 2182432 | 2022-12-22 | US | South Carolina | Union | 45087 | 9319 | 159 | 0 | 34.68835752 | -81.61730349 | 2022-12-23 04:21:04 | Union, South Carolina, US | |
2182399 | 2182399 | 2022-12-22 | US | South Carolina | Chester | 45023 | 12082 | 159 | 0 | 34.69249168 | -81.1583216 | 2022-12-23 04:21:04 | Chester, South Carolina, US | |
2182293 | 2182293 | 2022-12-22 | US | Pennsylvania | Union | 42119 | 13275 | 159 | 0 | 40.96188846 | -77.05996014 | 2022-12-23 04:21:04 | Union, Pennsylvania, US | |
2182038 | 2182038 | 2022-12-22 | US | Ohio | Champaign | 39021 | 10507 | 159 | 0 | 40.13923427 | -83.76875242 | 2022-12-23 04:21:04 | Champaign, Ohio, US | |
2181795 | 2181795 | 2022-12-22 | US | New Mexico | Rio Arriba | 35039 | 13075 | 159 | 0 | 36.51072137 | -106.6931674 | 2022-12-23 04:21:04 | Rio Arriba, New Mexico, US | |
2181045 | 2181045 | 2022-12-22 | US | Kentucky | Oldham | 21185 | 22336 | 159 | 0 | 38.39791089 | -85.448222 | 2022-12-23 04:21:04 | Oldham, Kentucky, US | |
2180720 | 2180720 | 2022-12-22 | US | Indiana | Randolph | 18135 | 6775 | 159 | 0 | 40.15734772 | -85.01139319 | 2022-12-23 04:21:04 | Randolph, Indiana, US | |
2180673 | 2180673 | 2022-12-22 | US | Indiana | Fayette | 18041 | 8036 | 159 | 0 | 39.63684962 | -85.17797541 | 2022-12-23 04:21:04 | Fayette, Indiana, US | |
2180538 | 2180538 | 2022-12-22 | US | Idaho | Nez Perce | 16069 | 10396 | 159 | 0 | 46.32638236 | -116.7500975 | 2022-12-23 04:21:04 | Nez Perce, Idaho, US | |
454236 | 454236 | 2022-12-21 | US | South Carolina | Union | 45087 | 9319 | 159 | 0 | 34.68835752 | -81.61730349 | 2022-12-22 04:20:56 | Union, South Carolina, US | |
454203 | 454203 | 2022-12-21 | US | South Carolina | Chester | 45023 | 12082 | 159 | 0 | 34.69249168 | -81.1583216 | 2022-12-22 04:20:56 | Chester, South Carolina, US | |
454097 | 454097 | 2022-12-21 | US | Pennsylvania | Union | 42119 | 13275 | 159 | 0 | 40.96188846 | -77.05996014 | 2022-12-22 04:20:56 | Union, Pennsylvania, US | |
453842 | 453842 | 2022-12-21 | US | Ohio | Champaign | 39021 | 10460 | 159 | 0 | 40.13923427 | -83.76875242 | 2022-12-22 04:20:56 | Champaign, Ohio, US | |
453599 | 453599 | 2022-12-21 | US | New Mexico | Rio Arriba | 35039 | 13068 | 159 | 0 | 36.51072137 | -106.6931674 | 2022-12-22 04:20:56 | Rio Arriba, New Mexico, US | |
452849 | 452849 | 2022-12-21 | US | Kentucky | Oldham | 21185 | 22336 | 159 | 0 | 38.39791089 | -85.448222 | 2022-12-22 04:20:56 | Oldham, Kentucky, US | |
452524 | 452524 | 2022-12-21 | US | Indiana | Randolph | 18135 | 6775 | 159 | 0 | 40.15734772 | -85.01139319 | 2022-12-22 04:20:56 | Randolph, Indiana, US | |
452477 | 452477 | 2022-12-21 | US | Indiana | Fayette | 18041 | 8036 | 159 | 0 | 39.63684962 | -85.17797541 | 2022-12-22 04:20:56 | Fayette, Indiana, US | |
452342 | 452342 | 2022-12-21 | US | Idaho | Nez Perce | 16069 | 10396 | 159 | 0 | 46.32638236 | -116.7500975 | 2022-12-22 04:20:56 | Nez Perce, Idaho, US | |
2954235 | 2954235 | 2022-12-20 | US | South Carolina | Union | 45087 | 9319 | 159 | 0 | 34.68835752 | -81.61730349 | 2022-12-21 04:21:03 | Union, South Carolina, US | |
2954202 | 2954202 | 2022-12-20 | US | South Carolina | Chester | 45023 | 12082 | 159 | 0 | 34.69249168 | -81.1583216 | 2022-12-21 04:21:03 | Chester, South Carolina, US | |
2954096 | 2954096 | 2022-12-20 | US | Pennsylvania | Union | 42119 | 13223 | 159 | 0 | 40.96188846 | -77.05996014 | 2022-12-21 04:21:03 | Union, Pennsylvania, US | |
2953841 | 2953841 | 2022-12-20 | US | Ohio | Champaign | 39021 | 10460 | 159 | 0 | 40.13923427 | -83.76875242 | 2022-12-21 04:21:03 | Champaign, Ohio, US | |
2953598 | 2953598 | 2022-12-20 | US | New Mexico | Rio Arriba | 35039 | 13052 | 159 | 0 | 36.51072137 | -106.6931674 | 2022-12-21 04:21:03 | Rio Arriba, New Mexico, US | |
2952848 | 2952848 | 2022-12-20 | US | Kentucky | Oldham | 21185 | 22336 | 159 | 0 | 38.39791089 | -85.448222 | 2022-12-21 04:21:03 | Oldham, Kentucky, US | |
2952523 | 2952523 | 2022-12-20 | US | Indiana | Randolph | 18135 | 6775 | 159 | 0 | 40.15734772 | -85.01139319 | 2022-12-21 04:21:03 | Randolph, Indiana, US | |
2952476 | 2952476 | 2022-12-20 | US | Indiana | Fayette | 18041 | 8036 | 159 | 0 | 39.63684962 | -85.17797541 | 2022-12-21 04:21:03 | Fayette, Indiana, US | |
2952341 | 2952341 | 2022-12-20 | US | Idaho | Nez Perce | 16069 | 10349 | 159 | 0 | 46.32638236 | -116.7500975 | 2022-12-21 04:21:03 | Nez Perce, Idaho, US | |
3176637 | 3176637 | 2022-12-19 | US | South Carolina | Union | 45087 | 9268 | 159 | 0 | 34.68835752 | -81.61730349 | 2022-12-20 04:21:04 | Union, South Carolina, US | |
3176604 | 3176604 | 2022-12-19 | US | South Carolina | Chester | 45023 | 12004 | 159 | 0 | 34.69249168 | -81.1583216 | 2022-12-20 04:21:04 | Chester, South Carolina, US | |
3176498 | 3176498 | 2022-12-19 | US | Pennsylvania | Union | 42119 | 13223 | 159 | 0 | 40.96188846 | -77.05996014 | 2022-12-20 04:21:04 | Union, Pennsylvania, US | |
3176243 | 3176243 | 2022-12-19 | US | Ohio | Champaign | 39021 | 10460 | 159 | 0 | 40.13923427 | -83.76875242 | 2022-12-20 04:21:04 | Champaign, Ohio, US | |
3176000 | 3176000 | 2022-12-19 | US | New Mexico | Rio Arriba | 35039 | 13049 | 159 | 0 | 36.51072137 | -106.6931674 | 2022-12-20 04:21:04 | Rio Arriba, New Mexico, US | |
3175250 | 3175250 | 2022-12-19 | US | Kentucky | Oldham | 21185 | 22336 | 159 | 0 | 38.39791089 | -85.448222 | 2022-12-20 04:21:04 | Oldham, Kentucky, US | |
3174925 | 3174925 | 2022-12-19 | US | Indiana | Randolph | 18135 | 6775 | 159 | 0 | 40.15734772 | -85.01139319 | 2022-12-20 04:21:04 | Randolph, Indiana, US | |
3174878 | 3174878 | 2022-12-19 | US | Indiana | Fayette | 18041 | 8036 | 159 | 0 | 39.63684962 | -85.17797541 | 2022-12-20 04:21:04 | Fayette, Indiana, US | |
3174743 | 3174743 | 2022-12-19 | US | Idaho | Nez Perce | 16069 | 10349 | 159 | 0 | 46.32638236 | -116.7500975 | 2022-12-20 04:21:04 | Nez Perce, Idaho, US | |
1631154 | 1631154 | 2022-12-18 | US | South Carolina | Union | 45087 | 9268 | 159 | 0 | 34.68835752 | -81.61730349 | 2022-12-19 04:21:03 | Union, South Carolina, US | |
1631121 | 1631121 | 2022-12-18 | US | South Carolina | Chester | 45023 | 12004 | 159 | 0 | 34.69249168 | -81.1583216 | 2022-12-19 04:21:03 | Chester, South Carolina, US | |
1631015 | 1631015 | 2022-12-18 | US | Pennsylvania | Union | 42119 | 13223 | 159 | 0 | 40.96188846 | -77.05996014 | 2022-12-19 04:21:03 | Union, Pennsylvania, US | |
1630760 | 1630760 | 2022-12-18 | US | Ohio | Champaign | 39021 | 10460 | 159 | 0 | 40.13923427 | -83.76875242 | 2022-12-19 04:21:03 | Champaign, Ohio, US | |
1630517 | 1630517 | 2022-12-18 | US | New Mexico | Rio Arriba | 35039 | 13034 | 159 | 0 | 36.51072137 | -106.6931674 | 2022-12-19 04:21:03 | Rio Arriba, New Mexico, US | |
1629442 | 1629442 | 2022-12-18 | US | Indiana | Randolph | 18135 | 6775 | 159 | 0 | 40.15734772 | -85.01139319 | 2022-12-19 04:21:03 | Randolph, Indiana, US | |
1629395 | 1629395 | 2022-12-18 | US | Indiana | Fayette | 18041 | 8036 | 159 | 0 | 39.63684962 | -85.17797541 | 2022-12-19 04:21:03 | Fayette, Indiana, US | |
1629260 | 1629260 | 2022-12-18 | US | Idaho | Nez Perce | 16069 | 10349 | 159 | 0 | 46.32638236 | -116.7500975 | 2022-12-19 04:21:03 | Nez Perce, Idaho, US | |
506533 | 506533 | 2022-12-17 | US | South Carolina | Union | 45087 | 9268 | 159 | 0 | 34.68835752 | -81.61730349 | 2022-12-18 04:21:03 | Union, South Carolina, US | |
506500 | 506500 | 2022-12-17 | US | South Carolina | Chester | 45023 | 12004 | 159 | 0 | 34.69249168 | -81.1583216 | 2022-12-18 04:21:03 | Chester, South Carolina, US | |
506394 | 506394 | 2022-12-17 | US | Pennsylvania | Union | 42119 | 13223 | 159 | 0 | 40.96188846 | -77.05996014 | 2022-12-18 04:21:03 | Union, Pennsylvania, US | |
506139 | 506139 | 2022-12-17 | US | Ohio | Champaign | 39021 | 10460 | 159 | 0 | 40.13923427 | -83.76875242 | 2022-12-18 04:21:03 | Champaign, Ohio, US | |
505896 | 505896 | 2022-12-17 | US | New Mexico | Rio Arriba | 35039 | 13034 | 159 | 0 | 36.51072137 | -106.6931674 | 2022-12-18 04:21:03 | Rio Arriba, New Mexico, 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]);