johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
19,157 rows where deaths = 35 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2756518 | 2756518 | 2022-12-29 | US | Wyoming | Lincoln | 56023 | 4849 | 35 | 0 | 42.26376367 | -110.6563997 | 2022-12-30 04:21:04 | Lincoln, Wyoming, US | |
2756167 | 2756167 | 2022-12-29 | US | Texas | Winkler | 48495 | 2163 | 35 | 0 | 31.85008651 | -103.0485163 | 2022-12-30 04:21:04 | Winkler, Texas, US | |
2755934 | 2755934 | 2022-12-29 | US | Texas | Blanco | 48031 | 3121 | 35 | 0 | 30.26640707 | -98.3999852 | 2022-12-30 04:21:04 | Blanco, Texas, US | |
2755579 | 2755579 | 2022-12-29 | US | Pennsylvania | Forest | 42053 | 2508 | 35 | 0 | 41.51095103 | -79.23229292 | 2022-12-30 04:21:04 | Forest, Pennsylvania, US | |
2755458 | 2755458 | 2022-12-29 | US | Oklahoma | Dewey | 40043 | 1206 | 35 | 0 | 35.98772922 | -99.00730714 | 2022-12-30 04:21:04 | Dewey, Oklahoma, US | |
2755453 | 2755453 | 2022-12-29 | US | Oklahoma | Cotton | 40033 | 1635 | 35 | 0 | 34.28845626 | -98.37053567 | 2022-12-30 04:21:04 | Cotton, Oklahoma, US | |
2754819 | 2754819 | 2022-12-29 | US | Missouri | Howard | 29089 | 2876 | 35 | 0 | 39.1435761 | -92.69756691 | 2022-12-30 04:21:04 | Howard, Missouri, US | |
2754670 | 2754670 | 2022-12-29 | US | Minnesota | Rock | 27133 | 2733 | 35 | 0 | 43.67482683 | -96.25296832 | 2022-12-30 04:21:04 | Rock, Minnesota, US | |
2754363 | 2754363 | 2022-12-29 | US | Kentucky | Nicholas | 21181 | 2652 | 35 | 0 | 38.33342292 | -84.01889177 | 2022-12-30 04:21:04 | Nicholas, Kentucky, US | |
2754355 | 2754355 | 2022-12-29 | US | Kentucky | Menifee | 21165 | 2285 | 35 | 0 | 37.94090733 | -83.59985712 | 2022-12-30 04:21:04 | Menifee, Kentucky, US | |
2754310 | 2754310 | 2022-12-29 | US | Kentucky | Fulton | 21075 | 1430 | 35 | 0 | 36.55238827 | -89.20140068 | 2022-12-30 04:21:04 | Fulton, Kentucky, US | |
2754252 | 2754252 | 2022-12-29 | US | Kansas | Scott | 20171 | 1554 | 35 | 0 | 38.48222076 | -100.9066539 | 2022-12-30 04:21:04 | Scott, Kansas, US | |
2754242 | 2754242 | 2022-12-29 | US | Kansas | Pratt | 20151 | 2233 | 35 | 0 | 37.64780729 | -98.73922153 | 2022-12-30 04:21:04 | Pratt, Kansas, US | |
2754219 | 2754219 | 2022-12-29 | US | Kansas | Linn | 20107 | 3384 | 35 | 0 | 38.21267844 | -94.84254089 | 2022-12-30 04:21:04 | Linn, Kansas, US | |
2754091 | 2754091 | 2022-12-29 | US | Iowa | Davis | 19051 | 1787 | 35 | 0 | 40.74773536 | -92.41005468 | 2022-12-30 04:21:04 | Davis, Iowa, US | |
1077524 | 1077524 | 2022-12-28 | US | Wyoming | Lincoln | 56023 | 4849 | 35 | 0 | 42.26376367 | -110.6563997 | 2022-12-29 04:21:01 | Lincoln, Wyoming, US | |
1077173 | 1077173 | 2022-12-28 | US | Texas | Winkler | 48495 | 2163 | 35 | 0 | 31.85008651 | -103.0485163 | 2022-12-29 04:21:01 | Winkler, Texas, US | |
1076940 | 1076940 | 2022-12-28 | US | Texas | Blanco | 48031 | 3121 | 35 | 0 | 30.26640707 | -98.3999852 | 2022-12-29 04:21:01 | Blanco, Texas, US | |
1076585 | 1076585 | 2022-12-28 | US | Pennsylvania | Forest | 42053 | 2508 | 35 | 0 | 41.51095103 | -79.23229292 | 2022-12-29 04:21:01 | Forest, Pennsylvania, US | |
1076464 | 1076464 | 2022-12-28 | US | Oklahoma | Dewey | 40043 | 1203 | 35 | 0 | 35.98772922 | -99.00730714 | 2022-12-29 04:21:01 | Dewey, Oklahoma, US | |
1075825 | 1075825 | 2022-12-28 | US | Missouri | Howard | 29089 | 2876 | 35 | 0 | 39.1435761 | -92.69756691 | 2022-12-29 04:21:01 | Howard, Missouri, US | |
1075676 | 1075676 | 2022-12-28 | US | Minnesota | Rock | 27133 | 2729 | 35 | 0 | 43.67482683 | -96.25296832 | 2022-12-29 04:21:01 | Rock, Minnesota, US | |
1075369 | 1075369 | 2022-12-28 | US | Kentucky | Nicholas | 21181 | 2652 | 35 | 0 | 38.33342292 | -84.01889177 | 2022-12-29 04:21:01 | Nicholas, Kentucky, US | |
1075361 | 1075361 | 2022-12-28 | US | Kentucky | Menifee | 21165 | 2285 | 35 | 0 | 37.94090733 | -83.59985712 | 2022-12-29 04:21:01 | Menifee, Kentucky, US | |
1075316 | 1075316 | 2022-12-28 | US | Kentucky | Fulton | 21075 | 1430 | 35 | 0 | 36.55238827 | -89.20140068 | 2022-12-29 04:21:01 | Fulton, Kentucky, US | |
1075258 | 1075258 | 2022-12-28 | US | Kansas | Scott | 20171 | 1554 | 35 | 0 | 38.48222076 | -100.9066539 | 2022-12-29 04:21:01 | Scott, Kansas, US | |
1075248 | 1075248 | 2022-12-28 | US | Kansas | Pratt | 20151 | 2233 | 35 | 0 | 37.64780729 | -98.73922153 | 2022-12-29 04:21:01 | Pratt, Kansas, US | |
1075225 | 1075225 | 2022-12-28 | US | Kansas | Linn | 20107 | 3384 | 35 | 0 | 38.21267844 | -94.84254089 | 2022-12-29 04:21:01 | Linn, Kansas, US | |
1075097 | 1075097 | 2022-12-28 | US | Iowa | Davis | 19051 | 1787 | 35 | 0 | 40.74773536 | -92.41005468 | 2022-12-29 04:21:01 | Davis, Iowa, US | |
331521 | 331521 | 2022-12-27 | US | Wyoming | Lincoln | 56023 | 4849 | 35 | 0 | 42.26376367 | -110.6563997 | 2022-12-28 04:21:04 | Lincoln, Wyoming, US | |
331170 | 331170 | 2022-12-27 | US | Texas | Winkler | 48495 | 2146 | 35 | 0 | 31.85008651 | -103.0485163 | 2022-12-28 04:21:04 | Winkler, Texas, US | |
330937 | 330937 | 2022-12-27 | US | Texas | Blanco | 48031 | 3101 | 35 | 0 | 30.26640707 | -98.3999852 | 2022-12-28 04:21:04 | Blanco, Texas, US | |
330582 | 330582 | 2022-12-27 | US | Pennsylvania | Forest | 42053 | 2506 | 35 | 0 | 41.51095103 | -79.23229292 | 2022-12-28 04:21:04 | Forest, Pennsylvania, US | |
330461 | 330461 | 2022-12-27 | US | Oklahoma | Dewey | 40043 | 1203 | 35 | 0 | 35.98772922 | -99.00730714 | 2022-12-28 04:21:04 | Dewey, Oklahoma, US | |
329822 | 329822 | 2022-12-27 | US | Missouri | Howard | 29089 | 2876 | 35 | 0 | 39.1435761 | -92.69756691 | 2022-12-28 04:21:04 | Howard, Missouri, US | |
329673 | 329673 | 2022-12-27 | US | Minnesota | Rock | 27133 | 2729 | 35 | 0 | 43.67482683 | -96.25296832 | 2022-12-28 04:21:04 | Rock, Minnesota, US | |
329366 | 329366 | 2022-12-27 | US | Kentucky | Nicholas | 21181 | 2652 | 35 | 0 | 38.33342292 | -84.01889177 | 2022-12-28 04:21:04 | Nicholas, Kentucky, US | |
329358 | 329358 | 2022-12-27 | US | Kentucky | Menifee | 21165 | 2285 | 35 | 0 | 37.94090733 | -83.59985712 | 2022-12-28 04:21:04 | Menifee, Kentucky, US | |
329313 | 329313 | 2022-12-27 | US | Kentucky | Fulton | 21075 | 1430 | 35 | 0 | 36.55238827 | -89.20140068 | 2022-12-28 04:21:04 | Fulton, Kentucky, US | |
329255 | 329255 | 2022-12-27 | US | Kansas | Scott | 20171 | 1548 | 35 | 0 | 38.48222076 | -100.9066539 | 2022-12-28 04:21:04 | Scott, Kansas, US | |
329245 | 329245 | 2022-12-27 | US | Kansas | Pratt | 20151 | 2218 | 35 | 0 | 37.64780729 | -98.73922153 | 2022-12-28 04:21:04 | Pratt, Kansas, US | |
329222 | 329222 | 2022-12-27 | US | Kansas | Linn | 20107 | 3374 | 35 | 0 | 38.21267844 | -94.84254089 | 2022-12-28 04:21:04 | Linn, Kansas, US | |
329094 | 329094 | 2022-12-27 | US | Iowa | Davis | 19051 | 1785 | 35 | 0 | 40.74773536 | -92.41005468 | 2022-12-28 04:21:04 | Davis, Iowa, US | |
328808 | 328808 | 2022-12-27 | US | Georgia | Warren | 13301 | 1270 | 35 | 0 | 33.41146451 | -82.67795848 | 2022-12-28 04:21:04 | Warren, Georgia, US | |
221594 | 221594 | 2022-12-26 | US | Wyoming | Lincoln | 56023 | 4843 | 35 | 0 | 42.26376367 | -110.6563997 | 2022-12-27 04:21:07 | Lincoln, Wyoming, US | |
221243 | 221243 | 2022-12-26 | US | Texas | Winkler | 48495 | 2146 | 35 | 0 | 31.85008651 | -103.0485163 | 2022-12-27 04:21:07 | Winkler, Texas, US | |
221010 | 221010 | 2022-12-26 | US | Texas | Blanco | 48031 | 3101 | 35 | 0 | 30.26640707 | -98.3999852 | 2022-12-27 04:21:07 | Blanco, Texas, US | |
220655 | 220655 | 2022-12-26 | US | Pennsylvania | Forest | 42053 | 2506 | 35 | 0 | 41.51095103 | -79.23229292 | 2022-12-27 04:21:07 | Forest, Pennsylvania, US | |
220534 | 220534 | 2022-12-26 | US | Oklahoma | Dewey | 40043 | 1203 | 35 | 0 | 35.98772922 | -99.00730714 | 2022-12-27 04:21:07 | Dewey, Oklahoma, US | |
219895 | 219895 | 2022-12-26 | US | Missouri | Howard | 29089 | 2872 | 35 | 0 | 39.1435761 | -92.69756691 | 2022-12-27 04:21:07 | Howard, Missouri, US | |
219746 | 219746 | 2022-12-26 | US | Minnesota | Rock | 27133 | 2729 | 35 | 0 | 43.67482683 | -96.25296832 | 2022-12-27 04:21:07 | Rock, Minnesota, US | |
219439 | 219439 | 2022-12-26 | US | Kentucky | Nicholas | 21181 | 2632 | 35 | 0 | 38.33342292 | -84.01889177 | 2022-12-27 04:21:07 | Nicholas, Kentucky, US | |
219431 | 219431 | 2022-12-26 | US | Kentucky | Menifee | 21165 | 2267 | 35 | 0 | 37.94090733 | -83.59985712 | 2022-12-27 04:21:07 | Menifee, Kentucky, US | |
219386 | 219386 | 2022-12-26 | US | Kentucky | Fulton | 21075 | 1426 | 35 | 0 | 36.55238827 | -89.20140068 | 2022-12-27 04:21:07 | Fulton, Kentucky, US | |
219328 | 219328 | 2022-12-26 | US | Kansas | Scott | 20171 | 1548 | 35 | 0 | 38.48222076 | -100.9066539 | 2022-12-27 04:21:07 | Scott, Kansas, US | |
219318 | 219318 | 2022-12-26 | US | Kansas | Pratt | 20151 | 2218 | 35 | 0 | 37.64780729 | -98.73922153 | 2022-12-27 04:21:07 | Pratt, Kansas, US | |
219295 | 219295 | 2022-12-26 | US | Kansas | Linn | 20107 | 3374 | 35 | 0 | 38.21267844 | -94.84254089 | 2022-12-27 04:21:07 | Linn, Kansas, US | |
219167 | 219167 | 2022-12-26 | US | Iowa | Davis | 19051 | 1785 | 35 | 0 | 40.74773536 | -92.41005468 | 2022-12-27 04:21:07 | Davis, Iowa, US | |
218881 | 218881 | 2022-12-26 | US | Georgia | Warren | 13301 | 1270 | 35 | 0 | 33.41146451 | -82.67795848 | 2022-12-27 04:21:07 | Warren, Georgia, US | |
3226051 | 3226051 | 2022-12-25 | US | Wyoming | Lincoln | 56023 | 4843 | 35 | 0 | 42.26376367 | -110.6563997 | 2022-12-26 04:21:06 | Lincoln, Wyoming, US | |
3225700 | 3225700 | 2022-12-25 | US | Texas | Winkler | 48495 | 2146 | 35 | 0 | 31.85008651 | -103.0485163 | 2022-12-26 04:21:06 | Winkler, Texas, US | |
3225467 | 3225467 | 2022-12-25 | US | Texas | Blanco | 48031 | 3101 | 35 | 0 | 30.26640707 | -98.3999852 | 2022-12-26 04:21:06 | Blanco, Texas, US | |
3225112 | 3225112 | 2022-12-25 | US | Pennsylvania | Forest | 42053 | 2506 | 35 | 0 | 41.51095103 | -79.23229292 | 2022-12-26 04:21:06 | Forest, Pennsylvania, US | |
3224991 | 3224991 | 2022-12-25 | US | Oklahoma | Dewey | 40043 | 1203 | 35 | 0 | 35.98772922 | -99.00730714 | 2022-12-26 04:21:06 | Dewey, Oklahoma, US | |
3224352 | 3224352 | 2022-12-25 | US | Missouri | Howard | 29089 | 2872 | 35 | 0 | 39.1435761 | -92.69756691 | 2022-12-26 04:21:06 | Howard, Missouri, US | |
3224203 | 3224203 | 2022-12-25 | US | Minnesota | Rock | 27133 | 2729 | 35 | 0 | 43.67482683 | -96.25296832 | 2022-12-26 04:21:06 | Rock, Minnesota, US | |
3223896 | 3223896 | 2022-12-25 | US | Kentucky | Nicholas | 21181 | 2632 | 35 | 0 | 38.33342292 | -84.01889177 | 2022-12-26 04:21:06 | Nicholas, Kentucky, US | |
3223888 | 3223888 | 2022-12-25 | US | Kentucky | Menifee | 21165 | 2267 | 35 | 0 | 37.94090733 | -83.59985712 | 2022-12-26 04:21:06 | Menifee, Kentucky, US | |
3223843 | 3223843 | 2022-12-25 | US | Kentucky | Fulton | 21075 | 1426 | 35 | 0 | 36.55238827 | -89.20140068 | 2022-12-26 04:21:06 | Fulton, Kentucky, US | |
3223785 | 3223785 | 2022-12-25 | US | Kansas | Scott | 20171 | 1548 | 35 | 0 | 38.48222076 | -100.9066539 | 2022-12-26 04:21:06 | Scott, Kansas, US | |
3223775 | 3223775 | 2022-12-25 | US | Kansas | Pratt | 20151 | 2218 | 35 | 0 | 37.64780729 | -98.73922153 | 2022-12-26 04:21:06 | Pratt, Kansas, US | |
3223752 | 3223752 | 2022-12-25 | US | Kansas | Linn | 20107 | 3374 | 35 | 0 | 38.21267844 | -94.84254089 | 2022-12-26 04:21:06 | Linn, Kansas, US | |
3223624 | 3223624 | 2022-12-25 | US | Iowa | Davis | 19051 | 1785 | 35 | 0 | 40.74773536 | -92.41005468 | 2022-12-26 04:21:06 | Davis, Iowa, US | |
3223338 | 3223338 | 2022-12-25 | US | Georgia | Warren | 13301 | 1270 | 35 | 0 | 33.41146451 | -82.67795848 | 2022-12-26 04:21:06 | Warren, Georgia, US | |
1021965 | 1021965 | 2022-12-24 | US | Wyoming | Lincoln | 56023 | 4843 | 35 | 0 | 42.26376367 | -110.6563997 | 2022-12-25 04:21:04 | Lincoln, Wyoming, US | |
1021614 | 1021614 | 2022-12-24 | US | Texas | Winkler | 48495 | 2146 | 35 | 0 | 31.85008651 | -103.0485163 | 2022-12-25 04:21:04 | Winkler, Texas, US | |
1021381 | 1021381 | 2022-12-24 | US | Texas | Blanco | 48031 | 3101 | 35 | 0 | 30.26640707 | -98.3999852 | 2022-12-25 04:21:04 | Blanco, Texas, US | |
1021026 | 1021026 | 2022-12-24 | US | Pennsylvania | Forest | 42053 | 2506 | 35 | 0 | 41.51095103 | -79.23229292 | 2022-12-25 04:21:04 | Forest, Pennsylvania, US | |
1020905 | 1020905 | 2022-12-24 | US | Oklahoma | Dewey | 40043 | 1203 | 35 | 0 | 35.98772922 | -99.00730714 | 2022-12-25 04:21:04 | Dewey, Oklahoma, US | |
1020266 | 1020266 | 2022-12-24 | US | Missouri | Howard | 29089 | 2872 | 35 | 0 | 39.1435761 | -92.69756691 | 2022-12-25 04:21:04 | Howard, Missouri, US | |
1020117 | 1020117 | 2022-12-24 | US | Minnesota | Rock | 27133 | 2729 | 35 | 0 | 43.67482683 | -96.25296832 | 2022-12-25 04:21:04 | Rock, Minnesota, US | |
1019810 | 1019810 | 2022-12-24 | US | Kentucky | Nicholas | 21181 | 2632 | 35 | 0 | 38.33342292 | -84.01889177 | 2022-12-25 04:21:04 | Nicholas, Kentucky, US | |
1019802 | 1019802 | 2022-12-24 | US | Kentucky | Menifee | 21165 | 2267 | 35 | 0 | 37.94090733 | -83.59985712 | 2022-12-25 04:21:04 | Menifee, Kentucky, US | |
1019757 | 1019757 | 2022-12-24 | US | Kentucky | Fulton | 21075 | 1426 | 35 | 0 | 36.55238827 | -89.20140068 | 2022-12-25 04:21:04 | Fulton, Kentucky, US | |
1019699 | 1019699 | 2022-12-24 | US | Kansas | Scott | 20171 | 1548 | 35 | 0 | 38.48222076 | -100.9066539 | 2022-12-25 04:21:04 | Scott, Kansas, US | |
1019689 | 1019689 | 2022-12-24 | US | Kansas | Pratt | 20151 | 2218 | 35 | 0 | 37.64780729 | -98.73922153 | 2022-12-25 04:21:04 | Pratt, Kansas, US | |
1019666 | 1019666 | 2022-12-24 | US | Kansas | Linn | 20107 | 3374 | 35 | 0 | 38.21267844 | -94.84254089 | 2022-12-25 04:21:04 | Linn, Kansas, US | |
1019538 | 1019538 | 2022-12-24 | US | Iowa | Davis | 19051 | 1785 | 35 | 0 | 40.74773536 | -92.41005468 | 2022-12-25 04:21:04 | Davis, Iowa, US | |
1019252 | 1019252 | 2022-12-24 | US | Georgia | Warren | 13301 | 1270 | 35 | 0 | 33.41146451 | -82.67795848 | 2022-12-25 04:21:04 | Warren, Georgia, US | |
693988 | 693988 | 2022-12-23 | US | Wyoming | Lincoln | 56023 | 4843 | 35 | 0 | 42.26376367 | -110.6563997 | 2022-12-24 04:21:02 | Lincoln, Wyoming, US | |
693637 | 693637 | 2022-12-23 | US | Texas | Winkler | 48495 | 2146 | 35 | 0 | 31.85008651 | -103.0485163 | 2022-12-24 04:21:02 | Winkler, Texas, US | |
693404 | 693404 | 2022-12-23 | US | Texas | Blanco | 48031 | 3101 | 35 | 0 | 30.26640707 | -98.3999852 | 2022-12-24 04:21:02 | Blanco, Texas, US | |
693049 | 693049 | 2022-12-23 | US | Pennsylvania | Forest | 42053 | 2506 | 35 | 0 | 41.51095103 | -79.23229292 | 2022-12-24 04:21:02 | Forest, Pennsylvania, US | |
692928 | 692928 | 2022-12-23 | US | Oklahoma | Dewey | 40043 | 1203 | 35 | 0 | 35.98772922 | -99.00730714 | 2022-12-24 04:21:02 | Dewey, Oklahoma, US | |
692289 | 692289 | 2022-12-23 | US | Missouri | Howard | 29089 | 2872 | 35 | 0 | 39.1435761 | -92.69756691 | 2022-12-24 04:21:02 | Howard, Missouri, US | |
692140 | 692140 | 2022-12-23 | US | Minnesota | Rock | 27133 | 2729 | 35 | 0 | 43.67482683 | -96.25296832 | 2022-12-24 04:21:02 | Rock, Minnesota, US | |
691833 | 691833 | 2022-12-23 | US | Kentucky | Nicholas | 21181 | 2632 | 35 | 0 | 38.33342292 | -84.01889177 | 2022-12-24 04:21:02 | Nicholas, Kentucky, US | |
691825 | 691825 | 2022-12-23 | US | Kentucky | Menifee | 21165 | 2267 | 35 | 0 | 37.94090733 | -83.59985712 | 2022-12-24 04:21:02 | Menifee, Kentucky, US | |
691780 | 691780 | 2022-12-23 | US | Kentucky | Fulton | 21075 | 1426 | 35 | 0 | 36.55238827 | -89.20140068 | 2022-12-24 04:21:02 | Fulton, Kentucky, US | |
691722 | 691722 | 2022-12-23 | US | Kansas | Scott | 20171 | 1548 | 35 | 0 | 38.48222076 | -100.9066539 | 2022-12-24 04:21:02 | Scott, 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]);