daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
765 rows where deaths = 414 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
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 | US | Georgia | Troup | 13285 | 18280 | 414 | 0 | 33.03349196 | -85.02812115 | 2022-12-30 04:21:04 | Troup, Georgia, US | |
2022-12-29 | US | Florida | Flagler | 12035 | 28002 | 414 | 0 | 29.45933576 | -81.31508595 | 2022-12-30 04:21:04 | Flagler, Florida, US | |
2022-12-29 | US | Alabama | Lauderdale | 1077 | 29121 | 414 | 0 | 34.90171875 | -87.65624729 | 2022-12-30 04:21:04 | Lauderdale, Alabama, US | |
2022-12-28 | US | Georgia | Troup | 13285 | 18280 | 414 | 0 | 33.03349196 | -85.02812115 | 2022-12-29 04:21:01 | Troup, Georgia, US | |
2022-12-28 | US | Florida | Flagler | 12035 | 28002 | 414 | 0 | 29.45933576 | -81.31508595 | 2022-12-29 04:21:01 | Flagler, Florida, US | |
2022-12-28 | US | Alabama | Lauderdale | 1077 | 29121 | 414 | 0 | 34.90171875 | -87.65624729 | 2022-12-29 04:21:01 | Lauderdale, Alabama, US | |
2022-12-27 | US | Florida | Flagler | 12035 | 28002 | 414 | 0 | 29.45933576 | -81.31508595 | 2022-12-28 04:21:04 | Flagler, Florida, US | |
2022-12-27 | US | Alabama | Lauderdale | 1077 | 29121 | 414 | 0 | 34.90171875 | -87.65624729 | 2022-12-28 04:21:04 | Lauderdale, Alabama, US | |
2022-12-26 | US | Florida | Flagler | 12035 | 28002 | 414 | 0 | 29.45933576 | -81.31508595 | 2022-12-27 04:21:07 | Flagler, Florida, US | |
2022-12-26 | US | Alabama | Lauderdale | 1077 | 29121 | 414 | 0 | 34.90171875 | -87.65624729 | 2022-12-27 04:21:07 | Lauderdale, Alabama, US | |
2022-12-25 | US | Florida | Flagler | 12035 | 28002 | 414 | 0 | 29.45933576 | -81.31508595 | 2022-12-26 04:21:06 | Flagler, Florida, US | |
2022-12-25 | US | Alabama | Lauderdale | 1077 | 29121 | 414 | 0 | 34.90171875 | -87.65624729 | 2022-12-26 04:21:06 | Lauderdale, Alabama, US | |
2022-12-24 | US | Florida | Flagler | 12035 | 28002 | 414 | 0 | 29.45933576 | -81.31508595 | 2022-12-25 04:21:04 | Flagler, Florida, US | |
2022-12-24 | US | Alabama | Lauderdale | 1077 | 29121 | 414 | 0 | 34.90171875 | -87.65624729 | 2022-12-25 04:21:04 | Lauderdale, Alabama, US | |
2022-12-23 | US | Florida | Flagler | 12035 | 28002 | 414 | 0 | 29.45933576 | -81.31508595 | 2022-12-24 04:21:02 | Flagler, Florida, US | |
2022-12-23 | US | Alabama | Lauderdale | 1077 | 29121 | 414 | 0 | 34.90171875 | -87.65624729 | 2022-12-24 04:21:02 | Lauderdale, Alabama, US | |
2022-12-22 | US | Florida | Flagler | 12035 | 28002 | 414 | 0 | 29.45933576 | -81.31508595 | 2022-12-23 04:21:04 | Flagler, Florida, US | |
2022-12-22 | US | Alabama | Lauderdale | 1077 | 29121 | 414 | 0 | 34.90171875 | -87.65624729 | 2022-12-23 04:21:04 | Lauderdale, Alabama, US | |
2022-12-21 | US | Florida | Flagler | 12035 | 28002 | 414 | 0 | 29.45933576 | -81.31508595 | 2022-12-22 04:20:56 | Flagler, Florida, US | |
2022-12-21 | US | Alabama | Lauderdale | 1077 | 29121 | 414 | 0 | 34.90171875 | -87.65624729 | 2022-12-22 04:20:56 | Lauderdale, Alabama, US | |
2022-12-20 | US | Florida | Flagler | 12035 | 28002 | 414 | 0 | 29.45933576 | -81.31508595 | 2022-12-21 04:21:03 | Flagler, Florida, US | |
2022-12-20 | US | Alabama | Lauderdale | 1077 | 29006 | 414 | 0 | 34.90171875 | -87.65624729 | 2022-12-21 04:21:03 | Lauderdale, Alabama, US | |
2022-12-19 | US | Florida | Flagler | 12035 | 28002 | 414 | 0 | 29.45933576 | -81.31508595 | 2022-12-20 04:21:04 | Flagler, Florida, US | |
2022-12-19 | US | Alabama | Lauderdale | 1077 | 29006 | 414 | 0 | 34.90171875 | -87.65624729 | 2022-12-20 04:21:04 | Lauderdale, Alabama, US | |
2022-12-18 | US | Florida | Flagler | 12035 | 28002 | 414 | 0 | 29.45933576 | -81.31508595 | 2022-12-19 04:21:03 | Flagler, Florida, US | |
2022-12-18 | US | Alabama | Lauderdale | 1077 | 29006 | 414 | 0 | 34.90171875 | -87.65624729 | 2022-12-19 04:21:03 | Lauderdale, Alabama, US | |
2022-12-17 | US | Florida | Flagler | 12035 | 28002 | 414 | 0 | 29.45933576 | -81.31508595 | 2022-12-18 04:21:03 | Flagler, Florida, US | |
2022-12-17 | US | Alabama | Lauderdale | 1077 | 29006 | 414 | 0 | 34.90171875 | -87.65624729 | 2022-12-18 04:21:03 | Lauderdale, Alabama, US | |
2022-12-16 | US | Florida | Flagler | 12035 | 28002 | 414 | 0 | 29.45933576 | -81.31508595 | 2022-12-17 04:21:04 | Flagler, Florida, US | |
2022-12-16 | US | Alabama | Lauderdale | 1077 | 29006 | 414 | 0 | 34.90171875 | -87.65624729 | 2022-12-17 04:21:04 | Lauderdale, Alabama, US | |
2022-12-15 | US | Florida | Flagler | 12035 | 27865 | 414 | 0 | 29.45933576 | -81.31508595 | 2022-12-16 04:21:01 | Flagler, Florida, US | |
2022-12-15 | US | Alabama | Lauderdale | 1077 | 29006 | 414 | 0 | 34.90171875 | -87.65624729 | 2022-12-16 04:21:01 | Lauderdale, Alabama, US | |
2022-12-14 | US | Florida | Flagler | 12035 | 27865 | 414 | 0 | 29.45933576 | -81.31508595 | 2022-12-15 04:20:58 | Flagler, Florida, US | |
2022-12-14 | US | Alabama | Lauderdale | 1077 | 29006 | 414 | 0 | 34.90171875 | -87.65624729 | 2022-12-15 04:20:58 | Lauderdale, Alabama, US | |
2022-12-13 | US | Florida | Flagler | 12035 | 27865 | 414 | 0 | 29.45933576 | -81.31508595 | 2022-12-14 04:21:04 | Flagler, Florida, US | |
2022-12-13 | US | Alabama | Lauderdale | 1077 | 28906 | 414 | 0 | 34.90171875 | -87.65624729 | 2022-12-14 04:21:04 | Lauderdale, Alabama, US | |
2022-12-12 | US | Florida | Flagler | 12035 | 27865 | 414 | 0 | 29.45933576 | -81.31508595 | 2022-12-13 04:21:01 | Flagler, Florida, US | |
2022-12-12 | US | Alabama | Lauderdale | 1077 | 28906 | 414 | 0 | 34.90171875 | -87.65624729 | 2022-12-13 04:21:01 | Lauderdale, Alabama, US | |
2022-12-11 | US | Florida | Flagler | 12035 | 27865 | 414 | 0 | 29.45933576 | -81.31508595 | 2022-12-12 04:21:01 | Flagler, Florida, US | |
2022-12-11 | US | Alabama | Lauderdale | 1077 | 28906 | 414 | 0 | 34.90171875 | -87.65624729 | 2022-12-12 04:21:01 | Lauderdale, Alabama, US | |
2022-12-11 | Japan | Miyazaki | 224765 | 414 | 0 | 32.193204 | 131.299374 | 2022-12-12 04:21:01 | Miyazaki, Japan | |||
2022-12-10 | US | Florida | Flagler | 12035 | 27865 | 414 | 0 | 29.45933576 | -81.31508595 | 2022-12-11 04:20:50 | Flagler, Florida, US | |
2022-12-10 | US | Alabama | Lauderdale | 1077 | 28906 | 414 | 0 | 34.90171875 | -87.65624729 | 2022-12-11 04:20:50 | Lauderdale, Alabama, US | |
2022-12-09 | US | Florida | Flagler | 12035 | 27865 | 414 | 0 | 29.45933576 | -81.31508595 | 2022-12-10 04:21:02 | Flagler, Florida, US | |
2022-12-09 | US | Alabama | Lauderdale | 1077 | 28906 | 414 | 0 | 34.90171875 | -87.65624729 | 2022-12-10 04:21:02 | Lauderdale, Alabama, US | |
2022-12-08 | US | Florida | Flagler | 12035 | 27865 | 414 | 0 | 29.45933576 | -81.31508595 | 2022-12-09 04:21:05 | Flagler, Florida, US | |
2022-12-08 | US | Alabama | Lauderdale | 1077 | 28906 | 414 | 0 | 34.90171875 | -87.65624729 | 2022-12-09 04:21:05 | Lauderdale, Alabama, US | |
2022-12-07 | US | Florida | Flagler | 12035 | 27865 | 414 | 0 | 29.45933576 | -81.31508595 | 2022-12-08 04:21:07 | Flagler, Florida, US | |
2022-12-07 | US | Alabama | Lauderdale | 1077 | 28906 | 414 | 0 | 34.90171875 | -87.65624729 | 2022-12-08 04:21:07 | Lauderdale, Alabama, US | |
2022-12-07 | Japan | Oita | 205959 | 414 | 0 | 33.200697 | 131.43324 | 2022-12-08 04:21:07 | Oita, Japan | |||
2022-12-06 | US | Florida | Flagler | 12035 | 27865 | 414 | 0 | 29.45933576 | -81.31508595 | 2022-12-07 04:20:58 | Flagler, Florida, US | |
2022-12-05 | US | Florida | Flagler | 12035 | 27865 | 414 | 0 | 29.45933576 | -81.31508595 | 2022-12-06 04:21:03 | Flagler, Florida, US | |
2022-12-04 | US | Florida | Flagler | 12035 | 27865 | 414 | 0 | 29.45933576 | -81.31508595 | 2022-12-05 04:20:58 | Flagler, Florida, US | |
2022-12-03 | US | Florida | Flagler | 12035 | 27865 | 414 | 0 | 29.45933576 | -81.31508595 | 2022-12-04 04:20:56 | Flagler, Florida, US | |
2022-12-02 | US | Florida | Flagler | 12035 | 27865 | 414 | 0 | 29.45933576 | -81.31508595 | 2022-12-03 04:21:02 | Flagler, Florida, US | |
2022-12-01 | US | Florida | Flagler | 12035 | 27754 | 414 | 0 | 29.45933576 | -81.31508595 | 2022-12-02 04:21:07 | Flagler, Florida, US | |
2022-11-30 | US | Florida | Flagler | 12035 | 27754 | 414 | 0 | 29.45933576 | -81.31508595 | 2022-12-01 04:21:03 | Flagler, Florida, US | |
2022-11-29 | US | Florida | Flagler | 12035 | 27754 | 414 | 0 | 29.45933576 | -81.31508595 | 2022-11-30 04:21:07 | Flagler, Florida, US | |
2022-11-28 | US | Florida | Flagler | 12035 | 27754 | 414 | 0 | 29.45933576 | -81.31508595 | 2022-11-29 04:21:05 | Flagler, Florida, US | |
2022-11-21 | US | Colorado | Boulder | 8013 | 87460 | 414 | 0 | 40.09313619 | -105.3546767 | 2022-11-22 04:20:47 | Boulder, Colorado, US | |
2022-11-20 | US | Colorado | Boulder | 8013 | 87288 | 414 | 0 | 40.09313619 | -105.3546767 | 2022-11-21 04:21:05 | Boulder, Colorado, US | |
2022-11-19 | US | Colorado | Boulder | 8013 | 87288 | 414 | 0 | 40.09313619 | -105.3546767 | 2022-11-20 04:21:08 | Boulder, Colorado, US | |
2022-11-18 | US | Colorado | Boulder | 8013 | 87288 | 414 | 0 | 40.09313619 | -105.3546767 | 2022-11-19 04:21:14 | Boulder, Colorado, US | |
2022-11-17 | US | Colorado | Boulder | 8013 | 87230 | 414 | 0 | 40.09313619 | -105.3546767 | 2022-11-18 04:21:15 | Boulder, Colorado, US | |
2022-11-15 | US | Georgia | Columbia | 13073 | 41473 | 414 | 0 | 33.54534185 | -82.263524 | 2022-11-16 04:21:09 | Columbia, Georgia, US | |
2022-11-14 | US | Georgia | Columbia | 13073 | 41473 | 414 | 0 | 33.54534185 | -82.263524 | 2022-11-15 04:21:16 | Columbia, Georgia, US | |
2022-11-13 | US | Georgia | Columbia | 13073 | 41473 | 414 | 0 | 33.54534185 | -82.263524 | 2022-11-14 04:21:09 | Columbia, Georgia, US | |
2022-11-12 | US | Georgia | Columbia | 13073 | 41473 | 414 | 0 | 33.54534185 | -82.263524 | 2022-11-13 04:21:14 | Columbia, Georgia, US | |
2022-11-11 | US | Georgia | Columbia | 13073 | 41473 | 414 | 0 | 33.54534185 | -82.263524 | 2022-11-12 04:20:41 | Columbia, Georgia, US | |
2022-11-10 | US | Georgia | Columbia | 13073 | 41473 | 414 | 0 | 33.54534185 | -82.263524 | 2022-11-11 04:21:22 | Columbia, Georgia, US | |
2022-11-09 | US | Georgia | Columbia | 13073 | 41473 | 414 | 0 | 33.54534185 | -82.263524 | 2022-11-10 04:21:16 | Columbia, Georgia, US | |
2022-11-08 | US | Maryland | Howard | 24027 | 59339 | 414 | 0 | 39.25305293 | -76.93126208 | 2022-11-09 04:21:22 | Howard, Maryland, US | |
2022-11-07 | US | Maryland | Howard | 24027 | 59339 | 414 | 0 | 39.25305293 | -76.93126208 | 2022-11-08 04:21:21 | Howard, Maryland, US | |
2022-11-02 | US | Oklahoma | Comanche | 40031 | 37149 | 414 | 0 | 34.65973764 | -98.47195055 | 2022-11-03 04:22:05 | Comanche, Oklahoma, US | |
2022-11-01 | US | Oklahoma | Comanche | 40031 | 37149 | 414 | 0 | 34.65973764 | -98.47195055 | 2022-11-02 04:22:09 | Comanche, Oklahoma, US | |
2022-10-31 | US | Oklahoma | Comanche | 40031 | 37149 | 414 | 0 | 34.65973764 | -98.47195055 | 2022-11-01 04:22:36 | Comanche, Oklahoma, US | |
2022-10-30 | US | Oklahoma | Comanche | 40031 | 37149 | 414 | 0 | 34.65973764 | -98.47195055 | 2022-10-31 04:21:36 | Comanche, Oklahoma, US | |
2022-10-29 | US | Oklahoma | Comanche | 40031 | 37149 | 414 | 0 | 34.65973764 | -98.47195055 | 2022-10-30 04:22:14 | Comanche, Oklahoma, US | |
2022-10-29 | Japan | Miyagi | 280738 | 414 | 0 | 38.446859 | 140.927086 | 2022-10-30 04:22:14 | Miyagi, Japan | |||
2022-10-28 | US | Oklahoma | Comanche | 40031 | 37149 | 414 | 0 | 34.65973764 | -98.47195055 | 2022-10-29 04:21:13 | Comanche, Oklahoma, US | |
2022-10-27 | US | Oklahoma | Comanche | 40031 | 37149 | 414 | 0 | 34.65973764 | -98.47195055 | 2022-10-28 04:22:31 | Comanche, Oklahoma, US | |
2022-10-24 | US | South Carolina | Sumter | 45085 | 33005 | 414 | 0 | 33.91826534 | -80.37942316 | 2022-10-25 04:21:53 | Sumter, South Carolina, US | |
2022-10-23 | US | West Virginia | Cabell | 54011 | 32539 | 414 | 0 | 38.42424062 | -82.23855912 | 2022-10-24 04:22:29 | Cabell, West Virginia, US | |
2022-10-23 | US | Texas | Guadalupe | 48187 | 43762 | 414 | 0 | 29.58165339 | -97.94786822 | 2022-10-24 04:22:29 | Guadalupe, Texas, US | |
2022-10-23 | US | South Carolina | Sumter | 45085 | 33005 | 414 | 0 | 33.91826534 | -80.37942316 | 2022-10-24 04:22:29 | Sumter, South Carolina, US | |
2022-10-22 | US | West Virginia | Cabell | 54011 | 32539 | 414 | 0 | 38.42424062 | -82.23855912 | 2022-10-23 04:22:46 | Cabell, West Virginia, US | |
2022-10-22 | US | Texas | Guadalupe | 48187 | 43762 | 414 | 0 | 29.58165339 | -97.94786822 | 2022-10-23 04:22:46 | Guadalupe, Texas, US | |
2022-10-22 | US | South Carolina | Sumter | 45085 | 33005 | 414 | 0 | 33.91826534 | -80.37942316 | 2022-10-23 04:22:46 | Sumter, South Carolina, US | |
2022-10-21 | US | West Virginia | Cabell | 54011 | 32539 | 414 | 0 | 38.42424062 | -82.23855912 | 2022-10-22 04:22:53 | Cabell, West Virginia, US | |
2022-10-21 | US | Texas | Guadalupe | 48187 | 43762 | 414 | 0 | 29.58165339 | -97.94786822 | 2022-10-22 04:22:53 | Guadalupe, Texas, US | |
2022-10-21 | US | South Carolina | Sumter | 45085 | 33005 | 414 | 0 | 33.91826534 | -80.37942316 | 2022-10-22 04:22:53 | Sumter, South Carolina, US | |
2022-10-20 | US | West Virginia | Cabell | 54011 | 32530 | 414 | 0 | 38.42424062 | -82.23855912 | 2022-10-21 04:22:23 | Cabell, West Virginia, US | |
2022-10-20 | US | Texas | Guadalupe | 48187 | 43744 | 414 | 0 | 29.58165339 | -97.94786822 | 2022-10-21 04:22:23 | Guadalupe, Texas, US | |
2022-10-20 | US | South Carolina | Sumter | 45085 | 33005 | 414 | 0 | 33.91826534 | -80.37942316 | 2022-10-21 04:22:23 | Sumter, South Carolina, US | |
2022-10-19 | US | West Virginia | Cabell | 54011 | 32526 | 414 | 0 | 38.42424062 | -82.23855912 | 2022-10-20 04:22:59 | Cabell, West Virginia, US | |
2022-10-19 | US | Texas | Guadalupe | 48187 | 43744 | 414 | 0 | 29.58165339 | -97.94786822 | 2022-10-20 04:22:59 | Guadalupe, Texas, US | |
2022-10-19 | US | South Carolina | Sumter | 45085 | 33005 | 414 | 0 | 33.91826534 | -80.37942316 | 2022-10-20 04:22:59 | Sumter, South Carolina, US | |
2022-10-18 | US | West Virginia | Cabell | 54011 | 32510 | 414 | 0 | 38.42424062 | -82.23855912 | 2022-10-19 04:22:26 | Cabell, West Virginia, US | |
2022-10-18 | US | Texas | Guadalupe | 48187 | 43729 | 414 | 0 | 29.58165339 | -97.94786822 | 2022-10-19 04:22:26 | Guadalupe, Texas, US | |
2022-10-18 | US | South Carolina | Sumter | 45085 | 33005 | 414 | 0 | 33.91826534 | -80.37942316 | 2022-10-19 04:22:26 | Sumter, South Carolina, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;