daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
367 rows where confirmed = 1550 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-19 | US | North Dakota | McHenry | 38049 | 1550 | 31 | 0 | 48.23104458 | -100.6324822 | 2022-12-20 04:21:04 | McHenry, North Dakota, US | |
2022-12-18 | US | North Dakota | McHenry | 38049 | 1550 | 31 | 0 | 48.23104458 | -100.6324822 | 2022-12-19 04:21:03 | McHenry, North Dakota, US | |
2022-12-17 | US | North Dakota | McHenry | 38049 | 1550 | 31 | 0 | 48.23104458 | -100.6324822 | 2022-12-18 04:21:03 | McHenry, North Dakota, US | |
2022-11-08 | US | Kansas | Rooks | 20163 | 1550 | 21 | 0 | 39.35022773 | -99.32484567 | 2022-11-09 04:21:22 | Rooks, Kansas, US | |
2022-11-07 | US | Kansas | Rooks | 20163 | 1550 | 21 | 0 | 39.35022773 | -99.32484567 | 2022-11-08 04:21:21 | Rooks, Kansas, US | |
2022-11-06 | US | Kansas | Rooks | 20163 | 1550 | 21 | 0 | 39.35022773 | -99.32484567 | 2022-11-07 04:21:26 | Rooks, Kansas, US | |
2022-11-05 | US | Kansas | Rooks | 20163 | 1550 | 21 | 0 | 39.35022773 | -99.32484567 | 2022-11-06 04:21:24 | Rooks, Kansas, US | |
2022-11-04 | US | Kansas | Rooks | 20163 | 1550 | 21 | 0 | 39.35022773 | -99.32484567 | 2022-11-05 04:21:52 | Rooks, Kansas, US | |
2022-11-03 | US | Kansas | Rooks | 20163 | 1550 | 21 | 0 | 39.35022773 | -99.32484567 | 2022-11-04 04:22:11 | Rooks, Kansas, US | |
2022-11-02 | US | Kansas | Rooks | 20163 | 1550 | 21 | 0 | 39.35022773 | -99.32484567 | 2022-11-03 04:22:05 | Rooks, Kansas, US | |
2022-10-25 | US | Kansas | Phillips | 20147 | 1550 | 32 | 0 | 39.78465501 | -99.34668865 | 2022-10-26 04:22:19 | Phillips, Kansas, US | |
2022-10-24 | US | Kansas | Phillips | 20147 | 1550 | 32 | 0 | 39.78465501 | -99.34668865 | 2022-10-25 04:21:53 | Phillips, Kansas, US | |
2022-10-23 | US | Kansas | Phillips | 20147 | 1550 | 32 | 0 | 39.78465501 | -99.34668865 | 2022-10-24 04:22:29 | Phillips, Kansas, US | |
2022-10-22 | US | Kansas | Phillips | 20147 | 1550 | 32 | 0 | 39.78465501 | -99.34668865 | 2022-10-23 04:22:46 | Phillips, Kansas, US | |
2022-10-21 | US | Kansas | Phillips | 20147 | 1550 | 32 | 0 | 39.78465501 | -99.34668865 | 2022-10-22 04:22:53 | Phillips, Kansas, US | |
2022-10-20 | US | Kansas | Phillips | 20147 | 1550 | 32 | 0 | 39.78465501 | -99.34668865 | 2022-10-21 04:22:23 | Phillips, Kansas, US | |
2022-10-19 | US | Kansas | Phillips | 20147 | 1550 | 32 | 0 | 39.78465501 | -99.34668865 | 2022-10-20 04:22:59 | Phillips, Kansas, US | |
2022-10-18 | US | Kansas | Phillips | 20147 | 1550 | 32 | 0 | 39.78465501 | -99.34668865 | 2022-10-19 04:22:26 | Phillips, Kansas, US | |
2022-10-17 | US | Kansas | Phillips | 20147 | 1550 | 32 | 0 | 39.78465501 | -99.34668865 | 2022-10-18 04:22:42 | Phillips, Kansas, US | |
2022-10-16 | US | Kansas | Phillips | 20147 | 1550 | 32 | 0 | 39.78465501 | -99.34668865 | 2022-10-17 04:20:31 | Phillips, Kansas, US | |
2022-10-15 | US | Kansas | Phillips | 20147 | 1550 | 32 | 0 | 39.78465501 | -99.34668865 | 2022-10-16 04:22:39 | Phillips, Kansas, US | |
2022-10-14 | US | Kansas | Phillips | 20147 | 1550 | 32 | 0 | 39.78465501 | -99.34668865 | 2022-10-15 04:22:00 | Phillips, Kansas, US | |
2022-10-13 | US | Kansas | Phillips | 20147 | 1550 | 32 | 0 | 39.78465501 | -99.34668865 | 2022-10-14 04:22:28 | Phillips, Kansas, US | |
2022-10-12 | US | Kansas | Phillips | 20147 | 1550 | 32 | 0 | 39.78465501 | -99.34668865 | 2022-10-13 04:22:39 | Phillips, Kansas, US | |
2022-10-02 | US | Texas | Mills | 48333 | 1550 | 37 | 0 | 31.49557106 | -98.59272068 | 2022-10-03 04:23:11 | Mills, Texas, US | |
2022-10-01 | US | Texas | Mills | 48333 | 1550 | 37 | 0 | 31.49557106 | -98.59272068 | 2022-10-02 04:21:23 | Mills, Texas, US | |
2022-09-30 | US | Texas | Mills | 48333 | 1550 | 37 | 0 | 31.49557106 | -98.59272068 | 2022-10-01 04:23:01 | Mills, Texas, US | |
2022-08-21 | US | Virginia | Norton | 51720 | 1550 | 22 | 0 | 36.93357076 | -82.62750411 | 2022-08-22 04:20:38 | Norton, Virginia, US | |
2022-08-20 | US | Virginia | Norton | 51720 | 1550 | 22 | 0 | 36.93357076 | -82.62750411 | 2022-08-21 04:20:44 | Norton, Virginia, US | |
2022-08-19 | US | Virginia | Norton | 51720 | 1550 | 22 | 0 | 36.93357076 | -82.62750411 | 2022-08-20 04:21:01 | Norton, Virginia, US | |
2022-08-07 | US | Virginia | Cumberland | 51049 | 1550 | 27 | 0 | 37.51328851 | -78.24398086 | 2022-08-08 04:21:08 | Cumberland, Virginia, US | |
2022-08-06 | US | Virginia | Cumberland | 51049 | 1550 | 27 | 0 | 37.51328851 | -78.24398086 | 2022-08-07 04:20:54 | Cumberland, Virginia, US | |
2022-08-05 | US | Virginia | Cumberland | 51049 | 1550 | 27 | 0 | 37.51328851 | -78.24398086 | 2022-08-06 04:20:56 | Cumberland, Virginia, US | |
2022-07-28 | US | Idaho | Caribou | 16029 | 1550 | 27 | 0 | 42.77149116 | -111.5597683 | 2022-07-29 04:20:45 | Caribou, Idaho, US | |
2022-07-27 | US | Idaho | Caribou | 16029 | 1550 | 27 | 0 | 42.77149116 | -111.5597683 | 2022-07-28 04:20:56 | Caribou, Idaho, US | |
2022-07-15 | US | North Dakota | Dickey | 38021 | 1550 | 39 | 0 | 46.11017712 | -98.5049008 | 2022-07-16 04:21:05 | Dickey, North Dakota, US | |
2022-07-07 | US | Wisconsin | Iron | 55051 | 1550 | 48 | 0 | 46.26302338 | -90.24295041 | 2022-07-08 04:20:56 | Iron, Wisconsin, US | |
2022-07-06 | US | Minnesota | Grant | 27051 | 1550 | 12 | 0 | 45.93424769 | -96.01139609 | 2022-07-07 04:20:55 | Grant, Minnesota, US | |
2022-07-05 | US | Minnesota | Grant | 27051 | 1550 | 12 | 0 | 45.93424769 | -96.01139609 | 2022-07-06 04:20:58 | Grant, Minnesota, US | |
2022-07-05 | US | Kansas | Stevens | 20189 | 1550 | 22 | 0 | 37.1923008 | -101.3118967 | 2022-07-06 04:20:58 | Stevens, Kansas, US | |
2022-07-04 | US | Minnesota | Grant | 27051 | 1550 | 12 | 0 | 45.93424769 | -96.01139609 | 2022-07-05 04:20:45 | Grant, Minnesota, US | |
2022-07-04 | US | Kansas | Stevens | 20189 | 1550 | 22 | 0 | 37.1923008 | -101.3118967 | 2022-07-05 04:20:45 | Stevens, Kansas, US | |
2022-07-03 | US | Minnesota | Grant | 27051 | 1550 | 12 | 0 | 45.93424769 | -96.01139609 | 2022-07-04 04:20:54 | Grant, Minnesota, US | |
2022-07-03 | US | Kansas | Stevens | 20189 | 1550 | 22 | 0 | 37.1923008 | -101.3118967 | 2022-07-04 04:20:54 | Stevens, Kansas, US | |
2022-07-02 | US | Minnesota | Grant | 27051 | 1550 | 12 | 0 | 45.93424769 | -96.01139609 | 2022-07-03 04:20:59 | Grant, Minnesota, US | |
2022-07-02 | US | Kansas | Stevens | 20189 | 1550 | 22 | 0 | 37.1923008 | -101.3118967 | 2022-07-03 04:20:59 | Stevens, Kansas, US | |
2022-07-01 | US | Minnesota | Grant | 27051 | 1550 | 12 | 0 | 45.93424769 | -96.01139609 | 2022-07-02 04:21:16 | Grant, Minnesota, US | |
2022-07-01 | US | Kansas | Stevens | 20189 | 1550 | 22 | 0 | 37.1923008 | -101.3118967 | 2022-07-02 04:21:16 | Stevens, Kansas, US | |
2022-06-30 | US | Minnesota | Grant | 27051 | 1550 | 12 | 0 | 45.93424769 | -96.01139609 | 2022-07-01 04:21:10 | Grant, Minnesota, US | |
2022-06-30 | US | Kansas | Stevens | 20189 | 1550 | 22 | 0 | 37.1923008 | -101.3118967 | 2022-07-01 04:21:10 | Stevens, Kansas, US | |
2022-06-29 | US | Texas | Jack | 48237 | 1550 | 28 | 0 | 33.23377248 | -98.17283469 | 2022-06-30 04:21:01 | Jack, Texas, US | |
2022-06-29 | US | Minnesota | Grant | 27051 | 1550 | 12 | 0 | 45.93424769 | -96.01139609 | 2022-06-30 04:21:01 | Grant, Minnesota, US | |
2022-06-29 | US | Kansas | Stevens | 20189 | 1550 | 22 | 0 | 37.1923008 | -101.3118967 | 2022-06-30 04:21:01 | Stevens, Kansas, US | |
2022-06-29 | US | Colorado | Huerfano | 8055 | 1550 | 37 | 0 | 37.68473101 | -104.9612585 | 2022-06-30 04:21:01 | Huerfano, Colorado, US | |
2022-06-29 | US | California | Trinity | 6105 | 1550 | 20 | 0 | 40.6491767 | -123.114713 | 2022-06-30 04:21:01 | Trinity, California, US | |
2022-06-28 | US | Texas | Jack | 48237 | 1550 | 28 | 0 | 33.23377248 | -98.17283469 | 2022-06-29 04:20:59 | Jack, Texas, US | |
2022-06-27 | US | Texas | Jack | 48237 | 1550 | 28 | 0 | 33.23377248 | -98.17283469 | 2022-06-28 04:20:58 | Jack, Texas, US | |
2022-06-26 | US | Texas | Jack | 48237 | 1550 | 28 | 0 | 33.23377248 | -98.17283469 | 2022-06-27 04:21:00 | Jack, Texas, US | |
2022-06-21 | US | Iowa | Decatur | 19053 | 1550 | 26 | 0 | 40.73742757 | -93.78645949 | 2022-06-22 04:20:54 | Decatur, Iowa, US | |
2022-06-20 | US | Iowa | Decatur | 19053 | 1550 | 26 | 0 | 40.73742757 | -93.78645949 | 2022-06-21 04:20:56 | Decatur, Iowa, US | |
2022-06-19 | US | Iowa | Decatur | 19053 | 1550 | 26 | 0 | 40.73742757 | -93.78645949 | 2022-06-20 04:21:01 | Decatur, Iowa, US | |
2022-06-18 | US | Iowa | Decatur | 19053 | 1550 | 26 | 0 | 40.73742757 | -93.78645949 | 2022-06-19 04:20:51 | Decatur, Iowa, US | |
2022-06-17 | US | Iowa | Decatur | 19053 | 1550 | 26 | 0 | 40.73742757 | -93.78645949 | 2022-06-18 04:21:10 | Decatur, Iowa, US | |
2022-06-16 | US | Iowa | Decatur | 19053 | 1550 | 26 | 0 | 40.73742757 | -93.78645949 | 2022-06-17 04:20:56 | Decatur, Iowa, US | |
2022-06-15 | US | Iowa | Decatur | 19053 | 1550 | 26 | 0 | 40.73742757 | -93.78645949 | 2022-06-16 04:20:55 | Decatur, Iowa, US | |
2022-05-24 | US | Washington | Skamania | 53059 | 1550 | 12 | 0 | 46.02408726 | -121.9164403 | 2022-05-25 04:20:56 | Skamania, Washington, US | |
2022-05-24 | US | Illinois | Calhoun | 17013 | 1550 | 5 | 0 | 39.16840183 | -90.66330078 | 2022-05-25 04:20:56 | Calhoun, Illinois, US | |
2022-05-23 | US | Washington | Skamania | 53059 | 1550 | 12 | 0 | 46.02408726 | -121.9164403 | 2022-05-24 04:20:57 | Skamania, Washington, US | |
2022-05-23 | US | Minnesota | Norman | 27107 | 1550 | 14 | 0 | 47.32628443 | -96.45620947 | 2022-05-24 04:20:57 | Norman, Minnesota, US | |
2022-03-09 | US | Kentucky | Owsley | 21189 | 1550 | 23 | 0 | 37.42823949 | -83.68811419 | 2022-03-10 04:20:48 | Owsley, Kentucky, US | |
2022-03-08 | US | Kentucky | Owsley | 21189 | 1550 | 23 | 0 | 37.42823949 | -83.68811419 | 2022-03-09 04:20:59 | Owsley, Kentucky, US | |
2022-03-07 | US | Kentucky | Owsley | 21189 | 1550 | 23 | 0 | 37.42823949 | -83.68811419 | 2022-03-08 04:20:54 | Owsley, Kentucky, US | |
2022-03-06 | US | Kentucky | Owsley | 21189 | 1550 | 23 | 0 | 37.42823949 | -83.68811419 | 2022-03-07 04:20:47 | Owsley, Kentucky, US | |
2022-03-05 | US | Kentucky | Owsley | 21189 | 1550 | 23 | 0 | 37.42823949 | -83.68811419 | 2022-03-06 04:20:49 | Owsley, Kentucky, US | |
2022-03-04 | US | Kentucky | Owsley | 21189 | 1550 | 23 | 0 | 37.42823949 | -83.68811419 | 2022-03-05 04:21:10 | Owsley, Kentucky, US | |
2022-02-15 | US | Iowa | Adair | 19001 | 1550 | 48 | 0 | 41.33075609 | -94.47105874 | 2022-02-16 04:21:10 | Adair, Iowa, US | |
2022-02-14 | US | Iowa | Adair | 19001 | 1550 | 48 | 0 | 41.33075609 | -94.47105874 | 2022-02-15 04:21:09 | Adair, Iowa, US | |
2022-02-13 | US | Missouri | Maries | 29125 | 1550 | 29 | 0 | 38.16193985 | -91.92249662 | 2022-02-14 04:20:51 | Maries, Missouri, US | |
2022-02-13 | US | Iowa | Adair | 19001 | 1550 | 48 | 0 | 41.33075609 | -94.47105874 | 2022-02-14 04:20:51 | Adair, Iowa, US | |
2022-02-12 | US | Missouri | Maries | 29125 | 1550 | 29 | 0 | 38.16193985 | -91.92249662 | 2022-02-13 04:21:00 | Maries, Missouri, US | |
2022-02-12 | US | Iowa | Adair | 19001 | 1550 | 48 | 0 | 41.33075609 | -94.47105874 | 2022-02-13 04:21:00 | Adair, Iowa, US | |
2022-02-11 | US | Missouri | Maries | 29125 | 1550 | 29 | 0 | 38.16193985 | -91.92249662 | 2022-02-12 04:21:06 | Maries, Missouri, US | |
2022-02-11 | US | Iowa | Adair | 19001 | 1550 | 48 | 0 | 41.33075609 | -94.47105874 | 2022-02-12 04:21:06 | Adair, Iowa, US | |
2022-02-10 | US | Missouri | Maries | 29125 | 1550 | 29 | 0 | 38.16193985 | -91.92249662 | 2022-02-11 04:21:09 | Maries, Missouri, US | |
2022-02-10 | US | Minnesota | Wilkin | 27167 | 1550 | 22 | 0 | 46.35721532 | -96.4684375 | 2022-02-11 04:21:09 | Wilkin, Minnesota, US | |
2022-02-10 | US | Iowa | Adair | 19001 | 1550 | 48 | 0 | 41.33075609 | -94.47105874 | 2022-02-11 04:21:09 | Adair, Iowa, US | |
2022-02-09 | US | Iowa | Adair | 19001 | 1550 | 48 | 0 | 41.33075609 | -94.47105874 | 2022-02-10 04:21:14 | Adair, Iowa, US | |
2022-02-04 | US | Texas | Coleman | 48083 | 1550 | 65 | 0 | 31.76736834 | -99.45240766 | 2022-02-05 04:21:05 | Coleman, Texas, US | |
2022-01-25 | US | Texas | Hansford | 48195 | 1550 | 27 | 0 | 36.27743284 | -101.3545796 | 2022-01-26 04:21:07 | Hansford, Texas, US | |
2022-01-25 | US | Nebraska | Merrick | 31121 | 1550 | 15 | 0 | 41.16624273 | -98.0374887 | 2022-01-26 04:21:07 | Merrick, Nebraska, US | |
2022-01-17 | US | Nebraska | Cuming | 31039 | 1550 | 15 | 0 | 41.91637624 | -96.78730772 | 2022-01-18 04:21:04 | Cuming, Nebraska, US | |
2022-01-13 | US | Puerto Rico | Florida | 72054 | 1550 | 0 | 0 | 18.373715 | -66.560488 | 2022-01-14 04:21:54 | Florida, Puerto Rico, US | |
2022-01-12 | US | Texas | Crosby | 48107 | 1550 | 42 | 0 | 33.61431553 | -101.30003640000001 | 2022-01-13 08:00:09 | Crosby, Texas, US | |
2022-01-11 | US | Arkansas | Searcy | 5129 | 1550 | 33 | 0 | 35.9109364 | -92.69936482 | 2022-01-12 04:21:44 | Searcy, Arkansas, US | |
2022-01-06 | US | Alabama | Perry | 1105 | 1550 | 41 | 0 | 32.64048341 | -87.29770589 | 2022-01-07 04:22:09 | Perry, Alabama, US | |
2022-01-05 | US | West Virginia | Tyler | 54095 | 1550 | 26 | 0 | 39.46811972 | -80.88772676 | 2022-01-06 04:22:09 | Tyler, West Virginia, US | |
2022-01-04 | US | West Virginia | Webster | 54101 | 1550 | 27 | 0 | 38.49370949 | -80.4202023 | 2022-01-05 04:21:59 | Webster, West Virginia, US | |
2021-12-21 | US | West Virginia | Pleasants | 54073 | 1550 | 31 | 0 | 39.37091679 | -81.16771771 | 2021-12-22 04:21:54 | Pleasants, West Virginia, US | |
2021-12-21 | US | West Virginia | Gilmer | 54021 | 1550 | 15 | 0 | 38.9251277 | -80.85952723 | 2021-12-22 04:21:54 | Gilmer, West Virginia, US | |
2021-12-03 | US | Puerto Rico | Barranquitas | 72019 | 1550 | 0 | 0 | 18.201592 | -66.30963 | 2021-12-04 04:22:18 | Barranquitas, Puerto Rico, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;