daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
41,691 rows where deaths = 8 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
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-29 | United Kingdom | Montserrat | 1403 | 8 | 0 | 16.742498 | -62.187366 | 2022-12-30 04:21:04 | Montserrat, United Kingdom | |||
2022-12-29 | US | Utah | Unassigned | 90049 | 4526 | 8 | 0 | 41.72330587 | 0.0 | 2022-12-30 04:21:04 | Unassigned, Utah, US | |
2022-12-29 | US | Texas | Hemphill | 48211 | 1414 | 8 | 0 | 35.83764858 | -100.2703577 | 2022-12-30 04:21:04 | Hemphill, Texas, US | |
2022-12-29 | US | Texas | Briscoe | 48045 | 559 | 8 | 0 | 34.53026962 | -101.2084947 | 2022-12-30 04:21:04 | Briscoe, Texas, US | |
2022-12-29 | US | South Dakota | Sanborn | 46111 | 663 | 8 | 0 | 44.02351092 | -98.0909816 | 2022-12-30 04:21:04 | Sanborn, South Dakota, US | |
2022-12-29 | US | South Dakota | Mellette | 46095 | 634 | 8 | 0 | 43.58078848 | -100.7563186 | 2022-12-30 04:21:04 | Mellette, South Dakota, US | |
2022-12-29 | US | South Dakota | Hyde | 46069 | 344 | 8 | 0 | 44.54747703 | -99.48572582 | 2022-12-30 04:21:04 | Hyde, South Dakota, US | |
2022-12-29 | US | North Dakota | Hettinger | 38041 | 948 | 8 | 0 | 46.43375068 | -102.4632417 | 2022-12-30 04:21:04 | Hettinger, North Dakota, US | |
2022-12-29 | US | North Dakota | Dunn | 38025 | 1175 | 8 | 0 | 47.35423935 | -102.6160468 | 2022-12-30 04:21:04 | Dunn, North Dakota, US | |
2022-12-29 | US | Nebraska | Pawnee | 31133 | 493 | 8 | 0 | 40.13141096 | -96.23705437 | 2022-12-30 04:21:04 | Pawnee, Nebraska, US | |
2022-12-29 | US | Montana | Wibaux | 30109 | 244 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-12-30 04:21:04 | Wibaux, Montana, US | |
2022-12-29 | US | Kansas | Wallace | 20199 | 484 | 8 | 0 | 38.91686134 | -101.7638876 | 2022-12-30 04:21:04 | Wallace, Kansas, US | |
2022-12-29 | US | Kansas | Kiowa | 20097 | 755 | 8 | 0 | 37.55848695 | -99.2856537 | 2022-12-30 04:21:04 | Kiowa, Kansas, US | |
2022-12-29 | US | Kansas | Clark | 20025 | 568 | 8 | 0 | 37.23577007 | -99.81883015 | 2022-12-30 04:21:04 | Clark, Kansas, US | |
2022-12-29 | US | Colorado | San Miguel | 8113 | 2648 | 8 | 0 | 38.00450883 | -108.4020725 | 2022-12-30 04:21:04 | San Miguel, Colorado, US | |
2022-12-29 | US | Colorado | Pitkin | 8097 | 7977 | 8 | 0 | 39.21720112 | -106.9310027 | 2022-12-30 04:21:04 | Pitkin, Colorado, US | |
2022-12-29 | US | Colorado | Dolores | 8033 | 419 | 8 | 0 | 37.75208676 | -108.5211585 | 2022-12-30 04:21:04 | Dolores, Colorado, US | |
2022-12-29 | US | California | Mono | 6051 | 3556 | 8 | 0 | 37.93899289 | -118.8872409 | 2022-12-30 04:21:04 | Mono, California, US | |
2022-12-29 | Japan | Port Quarantine | 22118 | 8 | 0 | 2022-11-22 23:21:06 | Port Quarantine, Japan | |||||
2022-12-29 | China | Shandong | 4797 | 8 | 0 | 36.3427 | 118.1498 | 2022-12-30 04:21:04 | Shandong, China | |||
2022-12-29 | China | Guangdong | 63739 | 8 | 0 | 23.3417 | 113.4244 | 2022-12-30 04:21:04 | Guangdong, China | |||
2022-12-28 | United Kingdom | Montserrat | 1403 | 8 | 0 | 16.742498 | -62.187366 | 2022-12-29 04:21:01 | Montserrat, United Kingdom | |||
2022-12-28 | US | Texas | Hemphill | 48211 | 1414 | 8 | 0 | 35.83764858 | -100.2703577 | 2022-12-29 04:21:01 | Hemphill, Texas, US | |
2022-12-28 | US | Texas | Briscoe | 48045 | 559 | 8 | 0 | 34.53026962 | -101.2084947 | 2022-12-29 04:21:01 | Briscoe, Texas, US | |
2022-12-28 | US | South Dakota | Sanborn | 46111 | 663 | 8 | 0 | 44.02351092 | -98.0909816 | 2022-12-29 04:21:01 | Sanborn, South Dakota, US | |
2022-12-28 | US | South Dakota | Mellette | 46095 | 634 | 8 | 0 | 43.58078848 | -100.7563186 | 2022-12-29 04:21:01 | Mellette, South Dakota, US | |
2022-12-28 | US | South Dakota | Hyde | 46069 | 344 | 8 | 0 | 44.54747703 | -99.48572582 | 2022-12-29 04:21:01 | Hyde, South Dakota, US | |
2022-12-28 | US | North Dakota | Hettinger | 38041 | 948 | 8 | 0 | 46.43375068 | -102.4632417 | 2022-12-29 04:21:01 | Hettinger, North Dakota, US | |
2022-12-28 | US | North Dakota | Dunn | 38025 | 1175 | 8 | 0 | 47.35423935 | -102.6160468 | 2022-12-29 04:21:01 | Dunn, North Dakota, US | |
2022-12-28 | US | Nebraska | Pawnee | 31133 | 493 | 8 | 0 | 40.13141096 | -96.23705437 | 2022-12-29 04:21:01 | Pawnee, Nebraska, US | |
2022-12-28 | US | Montana | Wibaux | 30109 | 244 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-12-29 04:21:01 | Wibaux, Montana, US | |
2022-12-28 | US | Kansas | Wallace | 20199 | 484 | 8 | 0 | 38.91686134 | -101.7638876 | 2022-12-29 04:21:01 | Wallace, Kansas, US | |
2022-12-28 | US | Kansas | Kiowa | 20097 | 755 | 8 | 0 | 37.55848695 | -99.2856537 | 2022-12-29 04:21:01 | Kiowa, Kansas, US | |
2022-12-28 | US | Kansas | Clark | 20025 | 568 | 8 | 0 | 37.23577007 | -99.81883015 | 2022-12-29 04:21:01 | Clark, Kansas, US | |
2022-12-28 | US | Colorado | San Miguel | 8113 | 2644 | 8 | 0 | 38.00450883 | -108.4020725 | 2022-12-29 04:21:01 | San Miguel, Colorado, US | |
2022-12-28 | US | Colorado | Pitkin | 8097 | 7977 | 8 | 0 | 39.21720112 | -106.9310027 | 2022-12-29 04:21:01 | Pitkin, Colorado, US | |
2022-12-28 | US | Colorado | Dolores | 8033 | 418 | 8 | 0 | 37.75208676 | -108.5211585 | 2022-12-29 04:21:01 | Dolores, Colorado, US | |
2022-12-28 | US | California | Mono | 6051 | 3556 | 8 | 0 | 37.93899289 | -118.8872409 | 2022-12-29 04:21:01 | Mono, California, US | |
2022-12-28 | Japan | Port Quarantine | 22118 | 8 | 0 | 2022-11-22 23:21:06 | Port Quarantine, Japan | |||||
2022-12-28 | China | Shandong | 4797 | 8 | 0 | 36.3427 | 118.1498 | 2022-12-29 04:21:01 | Shandong, China | |||
2022-12-28 | China | Guangdong | 63739 | 8 | 0 | 23.3417 | 113.4244 | 2022-12-29 04:21:01 | Guangdong, China | |||
2022-12-27 | United Kingdom | Montserrat | 1403 | 8 | 0 | 16.742498 | -62.187366 | 2022-12-28 04:21:04 | Montserrat, United Kingdom | |||
2022-12-27 | US | Texas | Hemphill | 48211 | 1410 | 8 | 0 | 35.83764858 | -100.2703577 | 2022-12-28 04:21:04 | Hemphill, Texas, US | |
2022-12-27 | US | Texas | Briscoe | 48045 | 551 | 8 | 0 | 34.53026962 | -101.2084947 | 2022-12-28 04:21:04 | Briscoe, Texas, US | |
2022-12-27 | US | South Dakota | Sanborn | 46111 | 663 | 8 | 0 | 44.02351092 | -98.0909816 | 2022-12-28 04:21:04 | Sanborn, South Dakota, US | |
2022-12-27 | US | South Dakota | Mellette | 46095 | 634 | 8 | 0 | 43.58078848 | -100.7563186 | 2022-12-28 04:21:04 | Mellette, South Dakota, US | |
2022-12-27 | US | South Dakota | Hyde | 46069 | 344 | 8 | 0 | 44.54747703 | -99.48572582 | 2022-12-28 04:21:04 | Hyde, South Dakota, US | |
2022-12-27 | US | North Dakota | Hettinger | 38041 | 948 | 8 | 0 | 46.43375068 | -102.4632417 | 2022-12-28 04:21:04 | Hettinger, North Dakota, US | |
2022-12-27 | US | North Dakota | Dunn | 38025 | 1175 | 8 | 0 | 47.35423935 | -102.6160468 | 2022-12-28 04:21:04 | Dunn, North Dakota, US | |
2022-12-27 | US | Nebraska | Pawnee | 31133 | 493 | 8 | 0 | 40.13141096 | -96.23705437 | 2022-12-28 04:21:04 | Pawnee, Nebraska, US | |
2022-12-27 | US | Montana | Wibaux | 30109 | 244 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-12-28 04:21:04 | Wibaux, Montana, US | |
2022-12-27 | US | Kansas | Wallace | 20199 | 483 | 8 | 0 | 38.91686134 | -101.7638876 | 2022-12-28 04:21:04 | Wallace, Kansas, US | |
2022-12-27 | US | Kansas | Kiowa | 20097 | 748 | 8 | 0 | 37.55848695 | -99.2856537 | 2022-12-28 04:21:04 | Kiowa, Kansas, US | |
2022-12-27 | US | Kansas | Clark | 20025 | 567 | 8 | 0 | 37.23577007 | -99.81883015 | 2022-12-28 04:21:04 | Clark, Kansas, US | |
2022-12-27 | US | Connecticut | Unassigned | 90009 | 3073 | 8 | 0 | 41.85853803 | 0.0 | 2022-12-28 04:21:04 | Unassigned, Connecticut, US | |
2022-12-27 | US | Colorado | San Miguel | 8113 | 2642 | 8 | 0 | 38.00450883 | -108.4020725 | 2022-12-28 04:21:04 | San Miguel, Colorado, US | |
2022-12-27 | US | Colorado | Pitkin | 8097 | 7970 | 8 | 0 | 39.21720112 | -106.9310027 | 2022-12-28 04:21:04 | Pitkin, Colorado, US | |
2022-12-27 | US | Colorado | Dolores | 8033 | 418 | 8 | 0 | 37.75208676 | -108.5211585 | 2022-12-28 04:21:04 | Dolores, Colorado, US | |
2022-12-27 | US | California | Mono | 6051 | 3556 | 8 | 0 | 37.93899289 | -118.8872409 | 2022-12-28 04:21:04 | Mono, California, US | |
2022-12-27 | Japan | Port Quarantine | 22118 | 8 | 0 | 2022-11-22 23:21:06 | Port Quarantine, Japan | |||||
2022-12-27 | China | Shandong | 4797 | 8 | 0 | 36.3427 | 118.1498 | 2022-12-28 04:21:04 | Shandong, China | |||
2022-12-27 | China | Guangdong | 63739 | 8 | 0 | 23.3417 | 113.4244 | 2022-12-28 04:21:04 | Guangdong, China | |||
2022-12-26 | United Kingdom | Montserrat | 1403 | 8 | 0 | 16.742498 | -62.187366 | 2022-12-27 04:21:07 | Montserrat, United Kingdom | |||
2022-12-26 | US | Texas | Hemphill | 48211 | 1410 | 8 | 0 | 35.83764858 | -100.2703577 | 2022-12-27 04:21:07 | Hemphill, Texas, US | |
2022-12-26 | US | Texas | Briscoe | 48045 | 551 | 8 | 0 | 34.53026962 | -101.2084947 | 2022-12-27 04:21:07 | Briscoe, Texas, US | |
2022-12-26 | US | South Dakota | Sanborn | 46111 | 663 | 8 | 0 | 44.02351092 | -98.0909816 | 2022-12-27 04:21:07 | Sanborn, South Dakota, US | |
2022-12-26 | US | South Dakota | Mellette | 46095 | 634 | 8 | 0 | 43.58078848 | -100.7563186 | 2022-12-27 04:21:07 | Mellette, South Dakota, US | |
2022-12-26 | US | South Dakota | Hyde | 46069 | 344 | 8 | 0 | 44.54747703 | -99.48572582 | 2022-12-27 04:21:07 | Hyde, South Dakota, US | |
2022-12-26 | US | North Dakota | Hettinger | 38041 | 948 | 8 | 0 | 46.43375068 | -102.4632417 | 2022-12-27 04:21:07 | Hettinger, North Dakota, US | |
2022-12-26 | US | North Dakota | Dunn | 38025 | 1175 | 8 | 0 | 47.35423935 | -102.6160468 | 2022-12-27 04:21:07 | Dunn, North Dakota, US | |
2022-12-26 | US | Nebraska | Pawnee | 31133 | 493 | 8 | 0 | 40.13141096 | -96.23705437 | 2022-12-27 04:21:07 | Pawnee, Nebraska, US | |
2022-12-26 | US | Montana | Wibaux | 30109 | 244 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-12-27 04:21:07 | Wibaux, Montana, US | |
2022-12-26 | US | Kansas | Wallace | 20199 | 483 | 8 | 0 | 38.91686134 | -101.7638876 | 2022-12-27 04:21:07 | Wallace, Kansas, US | |
2022-12-26 | US | Kansas | Kiowa | 20097 | 748 | 8 | 0 | 37.55848695 | -99.2856537 | 2022-12-27 04:21:07 | Kiowa, Kansas, US | |
2022-12-26 | US | Kansas | Clark | 20025 | 567 | 8 | 0 | 37.23577007 | -99.81883015 | 2022-12-27 04:21:07 | Clark, Kansas, US | |
2022-12-26 | US | Connecticut | Unassigned | 90009 | 3075 | 8 | 0 | 41.85853803 | 0.0 | 2022-12-27 04:21:07 | Unassigned, Connecticut, US | |
2022-12-26 | US | Colorado | San Miguel | 8113 | 2642 | 8 | 0 | 38.00450883 | -108.4020725 | 2022-12-27 04:21:07 | San Miguel, Colorado, US | |
2022-12-26 | US | Colorado | Pitkin | 8097 | 7969 | 8 | 0 | 39.21720112 | -106.9310027 | 2022-12-27 04:21:07 | Pitkin, Colorado, US | |
2022-12-26 | US | Colorado | Dolores | 8033 | 417 | 8 | 0 | 37.75208676 | -108.5211585 | 2022-12-27 04:21:07 | Dolores, Colorado, US | |
2022-12-26 | US | California | Mono | 6051 | 3546 | 8 | 0 | 37.93899289 | -118.8872409 | 2022-12-27 04:21:07 | Mono, California, US | |
2022-12-26 | Japan | Port Quarantine | 22118 | 8 | 0 | 2022-11-22 23:21:06 | Port Quarantine, Japan | |||||
2022-12-26 | China | Shandong | 4797 | 8 | 0 | 36.3427 | 118.1498 | 2022-12-27 04:21:07 | Shandong, China | |||
2022-12-26 | China | Guangdong | 63739 | 8 | 0 | 23.3417 | 113.4244 | 2022-12-27 04:21:07 | Guangdong, China | |||
2022-12-25 | United Kingdom | Montserrat | 1403 | 8 | 0 | 16.742498 | -62.187366 | 2022-12-26 04:21:06 | Montserrat, United Kingdom | |||
2022-12-25 | US | Texas | Hemphill | 48211 | 1410 | 8 | 0 | 35.83764858 | -100.2703577 | 2022-12-26 04:21:06 | Hemphill, Texas, US | |
2022-12-25 | US | Texas | Briscoe | 48045 | 551 | 8 | 0 | 34.53026962 | -101.2084947 | 2022-12-26 04:21:06 | Briscoe, Texas, US | |
2022-12-25 | US | South Dakota | Sanborn | 46111 | 663 | 8 | 0 | 44.02351092 | -98.0909816 | 2022-12-26 04:21:06 | Sanborn, South Dakota, US | |
2022-12-25 | US | South Dakota | Mellette | 46095 | 634 | 8 | 0 | 43.58078848 | -100.7563186 | 2022-12-26 04:21:06 | Mellette, South Dakota, US | |
2022-12-25 | US | South Dakota | Hyde | 46069 | 344 | 8 | 0 | 44.54747703 | -99.48572582 | 2022-12-26 04:21:06 | Hyde, South Dakota, US | |
2022-12-25 | US | North Dakota | Hettinger | 38041 | 948 | 8 | 0 | 46.43375068 | -102.4632417 | 2022-12-26 04:21:06 | Hettinger, North Dakota, US | |
2022-12-25 | US | North Dakota | Dunn | 38025 | 1175 | 8 | 0 | 47.35423935 | -102.6160468 | 2022-12-26 04:21:06 | Dunn, North Dakota, US | |
2022-12-25 | US | Nebraska | Pawnee | 31133 | 493 | 8 | 0 | 40.13141096 | -96.23705437 | 2022-12-26 04:21:06 | Pawnee, Nebraska, US | |
2022-12-25 | US | Montana | Wibaux | 30109 | 244 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-12-26 04:21:06 | Wibaux, Montana, US | |
2022-12-25 | US | Kansas | Wallace | 20199 | 483 | 8 | 0 | 38.91686134 | -101.7638876 | 2022-12-26 04:21:06 | Wallace, Kansas, US | |
2022-12-25 | US | Kansas | Kiowa | 20097 | 748 | 8 | 0 | 37.55848695 | -99.2856537 | 2022-12-26 04:21:06 | Kiowa, Kansas, US | |
2022-12-25 | US | Kansas | Clark | 20025 | 567 | 8 | 0 | 37.23577007 | -99.81883015 | 2022-12-26 04:21:06 | Clark, Kansas, US | |
2022-12-25 | US | Connecticut | Unassigned | 90009 | 3076 | 8 | 0 | 41.85853803 | 0.0 | 2022-12-26 04:21:06 | Unassigned, Connecticut, US | |
2022-12-25 | US | Colorado | San Miguel | 8113 | 2641 | 8 | 0 | 38.00450883 | -108.4020725 | 2022-12-26 04:21:06 | San Miguel, Colorado, US | |
2022-12-25 | US | Colorado | Pitkin | 8097 | 7966 | 8 | 0 | 39.21720112 | -106.9310027 | 2022-12-26 04:21:06 | Pitkin, Colorado, US | |
2022-12-25 | US | Colorado | Dolores | 8033 | 415 | 8 | 0 | 37.75208676 | -108.5211585 | 2022-12-26 04:21:06 | Dolores, Colorado, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;