daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
279 rows where confirmed = 2438 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 | South Dakota | Custer | 46033 | 2438 | 28 | 0 | 43.67741105 | -103.4534521 | 2022-12-30 04:21:04 | Custer, South Dakota, US | |
2022-12-29 | US | Montana | Beaverhead | 30001 | 2438 | 32 | 0 | 45.13434354 | -112.8984694 | 2022-12-30 04:21:04 | Beaverhead, Montana, US | |
2022-12-28 | US | South Dakota | Custer | 46033 | 2438 | 28 | 0 | 43.67741105 | -103.4534521 | 2022-12-29 04:21:01 | Custer, South Dakota, US | |
2022-12-28 | US | Montana | Beaverhead | 30001 | 2438 | 32 | 0 | 45.13434354 | -112.8984694 | 2022-12-29 04:21:01 | Beaverhead, Montana, US | |
2022-12-27 | US | Montana | Beaverhead | 30001 | 2438 | 32 | 0 | 45.13434354 | -112.8984694 | 2022-12-28 04:21:04 | Beaverhead, Montana, US | |
2022-12-26 | US | Montana | Beaverhead | 30001 | 2438 | 32 | 0 | 45.13434354 | -112.8984694 | 2022-12-27 04:21:07 | Beaverhead, Montana, US | |
2022-12-25 | US | Montana | Beaverhead | 30001 | 2438 | 32 | 0 | 45.13434354 | -112.8984694 | 2022-12-26 04:21:06 | Beaverhead, Montana, US | |
2022-12-24 | US | Montana | Beaverhead | 30001 | 2438 | 32 | 0 | 45.13434354 | -112.8984694 | 2022-12-25 04:21:04 | Beaverhead, Montana, US | |
2022-12-23 | US | Montana | Beaverhead | 30001 | 2438 | 32 | 0 | 45.13434354 | -112.8984694 | 2022-12-24 04:21:02 | Beaverhead, Montana, US | |
2022-12-17 | China | Guangxi | 2438 | 2 | 0 | 23.8298 | 108.7881 | 2022-12-18 04:21:03 | Guangxi, China | |||
2022-12-14 | US | Minnesota | Marshall | 27089 | 2438 | 24 | 0 | 48.35825983 | -96.37017407 | 2022-12-15 04:20:58 | Marshall, Minnesota, US | |
2022-12-13 | US | Minnesota | Marshall | 27089 | 2438 | 24 | 0 | 48.35825983 | -96.37017407 | 2022-12-14 04:21:04 | Marshall, Minnesota, US | |
2022-12-12 | US | Minnesota | Marshall | 27089 | 2438 | 24 | 0 | 48.35825983 | -96.37017407 | 2022-12-13 04:21:01 | Marshall, Minnesota, US | |
2022-12-11 | US | Minnesota | Marshall | 27089 | 2438 | 24 | 0 | 48.35825983 | -96.37017407 | 2022-12-12 04:21:01 | Marshall, Minnesota, US | |
2022-12-10 | US | Minnesota | Marshall | 27089 | 2438 | 24 | 0 | 48.35825983 | -96.37017407 | 2022-12-11 04:20:50 | Marshall, Minnesota, US | |
2022-12-09 | US | Minnesota | Marshall | 27089 | 2438 | 24 | 0 | 48.35825983 | -96.37017407 | 2022-12-10 04:21:02 | Marshall, Minnesota, US | |
2022-12-08 | US | Minnesota | Marshall | 27089 | 2438 | 24 | 0 | 48.35825983 | -96.37017407 | 2022-12-09 04:21:05 | Marshall, Minnesota, US | |
2022-11-28 | US | New Mexico | Quay | 35037 | 2438 | 69 | 0 | 35.10403332 | -103.5481727 | 2022-11-29 04:21:05 | Quay, New Mexico, US | |
2022-11-22 | US | Louisiana | Red River | 22081 | 2438 | 58 | 0 | 32.09530039 | -93.34213308 | 2022-11-23 04:21:06 | Red River, Louisiana, US | |
2022-11-21 | US | Louisiana | Red River | 22081 | 2438 | 58 | 0 | 32.09530039 | -93.34213308 | 2022-11-22 04:20:47 | Red River, Louisiana, US | |
2022-11-20 | US | Louisiana | Red River | 22081 | 2438 | 58 | 0 | 32.09530039 | -93.34213308 | 2022-11-21 04:21:05 | Red River, Louisiana, US | |
2022-11-19 | US | Louisiana | Red River | 22081 | 2438 | 58 | 0 | 32.09530039 | -93.34213308 | 2022-11-20 04:21:08 | Red River, Louisiana, US | |
2022-11-18 | US | Louisiana | Red River | 22081 | 2438 | 58 | 0 | 32.09530039 | -93.34213308 | 2022-11-19 04:21:14 | Red River, Louisiana, US | |
2022-11-17 | US | Virginia | Fairfax City | 51600 | 2438 | 48 | 0 | 38.85157547 | -77.2977964 | 2022-11-18 04:21:15 | Fairfax City, Virginia, US | |
2022-11-17 | US | Louisiana | Red River | 22081 | 2438 | 58 | 0 | 32.09530039 | -93.34213308 | 2022-11-18 04:21:15 | Red River, Louisiana, US | |
2022-11-16 | US | Louisiana | Red River | 22081 | 2438 | 58 | 0 | 32.09530039 | -93.34213308 | 2022-11-17 04:21:11 | Red River, Louisiana, US | |
2022-10-20 | China | Tianjin | 2438 | 3 | 0 | 39.3054 | 117.323 | 2022-10-21 04:22:23 | Tianjin, China | |||
2022-09-27 | US | West Virginia | Gilmer | 54021 | 2438 | 22 | 0 | 38.9251277 | -80.85952723 | 2022-09-28 04:23:01 | Gilmer, West Virginia, US | |
2022-09-26 | US | West Virginia | Gilmer | 54021 | 2438 | 22 | 0 | 38.9251277 | -80.85952723 | 2022-09-27 04:23:01 | Gilmer, West Virginia, US | |
2022-09-06 | US | Illinois | Hamilton | 17065 | 2438 | 32 | 0 | 38.08163641 | -88.53883373 | 2022-09-07 04:20:59 | Hamilton, Illinois, US | |
2022-08-11 | US | Tennessee | Clay | 47027 | 2438 | 52 | 0 | 36.55151008 | -85.53930419 | 2022-08-12 04:20:54 | Clay, Tennessee, US | |
2022-08-10 | US | Minnesota | Swift | 27151 | 2438 | 33 | 0 | 45.2829032 | -95.68264092 | 2022-08-11 04:20:49 | Swift, Minnesota, US | |
2022-08-09 | US | Minnesota | Swift | 27151 | 2438 | 33 | 0 | 45.2829032 | -95.68264092 | 2022-08-10 04:20:57 | Swift, Minnesota, US | |
2022-08-09 | US | Iowa | Clarke | 19039 | 2438 | 39 | 0 | 41.02868181 | -93.78499767 | 2022-08-10 04:20:57 | Clarke, Iowa, US | |
2022-08-08 | US | Minnesota | Swift | 27151 | 2438 | 33 | 0 | 45.2829032 | -95.68264092 | 2022-08-09 04:20:34 | Swift, Minnesota, US | |
2022-08-08 | US | Iowa | Clarke | 19039 | 2438 | 39 | 0 | 41.02868181 | -93.78499767 | 2022-08-09 04:20:34 | Clarke, Iowa, US | |
2022-08-08 | US | Arkansas | Cleveland | 5025 | 2438 | 37 | 0 | 33.89723187 | -92.18537045 | 2022-08-09 04:20:34 | Cleveland, Arkansas, US | |
2022-08-07 | US | Mississippi | Benton | 28009 | 2438 | 49 | 0 | 34.81681228 | -89.18945516 | 2022-08-08 04:21:08 | Benton, Mississippi, US | |
2022-08-07 | US | Minnesota | Swift | 27151 | 2438 | 33 | 0 | 45.2829032 | -95.68264092 | 2022-08-08 04:21:08 | Swift, Minnesota, US | |
2022-08-07 | US | Iowa | Clarke | 19039 | 2438 | 39 | 0 | 41.02868181 | -93.78499767 | 2022-08-08 04:21:08 | Clarke, Iowa, US | |
2022-08-06 | US | Mississippi | Benton | 28009 | 2438 | 49 | 0 | 34.81681228 | -89.18945516 | 2022-08-07 04:20:54 | Benton, Mississippi, US | |
2022-08-06 | US | Minnesota | Swift | 27151 | 2438 | 33 | 0 | 45.2829032 | -95.68264092 | 2022-08-07 04:20:54 | Swift, Minnesota, US | |
2022-08-06 | US | Iowa | Clarke | 19039 | 2438 | 39 | 0 | 41.02868181 | -93.78499767 | 2022-08-07 04:20:54 | Clarke, Iowa, US | |
2022-08-05 | US | Mississippi | Benton | 28009 | 2438 | 49 | 0 | 34.81681228 | -89.18945516 | 2022-08-06 04:20:56 | Benton, Mississippi, US | |
2022-08-05 | US | Minnesota | Swift | 27151 | 2438 | 33 | 0 | 45.2829032 | -95.68264092 | 2022-08-06 04:20:56 | Swift, Minnesota, US | |
2022-08-05 | US | Iowa | Clarke | 19039 | 2438 | 39 | 0 | 41.02868181 | -93.78499767 | 2022-08-06 04:20:56 | Clarke, Iowa, US | |
2022-08-04 | US | Mississippi | Benton | 28009 | 2438 | 49 | 0 | 34.81681228 | -89.18945516 | 2022-08-05 04:20:52 | Benton, Mississippi, US | |
2022-08-04 | US | Minnesota | Swift | 27151 | 2438 | 33 | 0 | 45.2829032 | -95.68264092 | 2022-08-05 04:20:52 | Swift, Minnesota, US | |
2022-08-04 | US | Iowa | Clarke | 19039 | 2438 | 39 | 0 | 41.02868181 | -93.78499767 | 2022-08-05 04:20:52 | Clarke, Iowa, US | |
2022-08-03 | US | Iowa | Clarke | 19039 | 2438 | 39 | 0 | 41.02868181 | -93.78499767 | 2022-08-04 04:20:58 | Clarke, Iowa, US | |
2022-07-28 | US | Virginia | Essex | 51057 | 2438 | 35 | 0 | 37.93357639 | -76.94230311 | 2022-07-29 04:20:45 | Essex, Virginia, US | |
2022-07-19 | US | Virginia | Franklin City | 51620 | 2438 | 52 | 0 | 36.6831435 | -76.93859681 | 2022-07-20 04:20:59 | Franklin City, Virginia, US | |
2022-07-18 | US | Virginia | Franklin City | 51620 | 2438 | 52 | 0 | 36.6831435 | -76.93859681 | 2022-07-19 04:20:58 | Franklin City, Virginia, US | |
2022-07-18 | China | Sichuan | 2438 | 3 | 0 | 30.6171 | 102.7103 | 2022-07-19 04:20:58 | Sichuan, China | |||
2022-07-11 | US | Texas | Parmer | 48369 | 2438 | 52 | 0 | 34.52993409 | -102.7844668 | 2022-07-12 04:20:51 | Parmer, Texas, US | |
2022-07-10 | US | Texas | Parmer | 48369 | 2438 | 52 | 0 | 34.52993409 | -102.7844668 | 2022-07-11 04:20:46 | Parmer, Texas, US | |
2022-07-09 | US | Texas | Parmer | 48369 | 2438 | 52 | 0 | 34.52993409 | -102.7844668 | 2022-07-10 04:20:54 | Parmer, Texas, US | |
2022-07-09 | US | Tennessee | Perry | 47135 | 2438 | 56 | 0 | 35.63708728 | -87.86139634 | 2022-07-10 04:20:54 | Perry, Tennessee, US | |
2022-06-23 | US | Idaho | Benewah | 16009 | 2438 | 41 | 0 | 47.21754179 | -116.6586851 | 2022-06-24 04:20:58 | Benewah, Idaho, US | |
2022-06-22 | US | Idaho | Benewah | 16009 | 2438 | 41 | 0 | 47.21754179 | -116.6586851 | 2022-06-23 04:20:55 | Benewah, Idaho, US | |
2022-06-12 | US | Texas | Ochiltree | 48357 | 2438 | 48 | 0 | 36.27829105 | -100.8158184 | 2022-06-13 04:21:14 | Ochiltree, Texas, US | |
2022-06-11 | US | Texas | Ochiltree | 48357 | 2438 | 48 | 0 | 36.27829105 | -100.8158184 | 2022-06-12 04:20:53 | Ochiltree, Texas, US | |
2022-05-17 | US | New Mexico | Colfax | 35007 | 2438 | 64 | 0 | 36.60569702 | -104.6472674 | 2022-05-18 04:20:50 | Colfax, New Mexico, US | |
2022-05-16 | US | New Mexico | Colfax | 35007 | 2438 | 64 | 0 | 36.60569702 | -104.6472674 | 2022-05-17 04:20:59 | Colfax, New Mexico, US | |
2022-05-10 | US | Virginia | Madison | 51113 | 2438 | 41 | 0 | 38.41531222 | -78.28220331 | 2022-05-11 04:20:48 | Madison, Virginia, US | |
2022-04-10 | US | West Virginia | Ritchie | 54085 | 2438 | 31 | 0 | 39.18094587 | -81.06356878 | 2022-04-11 04:21:02 | Ritchie, West Virginia, US | |
2022-04-09 | US | West Virginia | Ritchie | 54085 | 2438 | 31 | 0 | 39.18094587 | -81.06356878 | 2022-04-10 04:20:52 | Ritchie, West Virginia, US | |
2022-04-08 | US | West Virginia | Ritchie | 54085 | 2438 | 31 | 0 | 39.18094587 | -81.06356878 | 2022-04-09 04:20:42 | Ritchie, West Virginia, US | |
2022-04-07 | US | West Virginia | Ritchie | 54085 | 2438 | 31 | 0 | 39.18094587 | -81.06356878 | 2022-04-08 04:20:48 | Ritchie, West Virginia, US | |
2022-03-30 | US | Oklahoma | Major | 40093 | 2438 | 41 | 0 | 36.31149996 | -98.53467076 | 2022-03-31 04:20:56 | Major, Oklahoma, US | |
2022-03-29 | US | Oklahoma | Major | 40093 | 2438 | 41 | 0 | 36.31149996 | -98.53467076 | 2022-03-30 04:20:45 | Major, Oklahoma, US | |
2022-03-28 | US | Oklahoma | Major | 40093 | 2438 | 41 | 0 | 36.31149996 | -98.53467076 | 2022-03-29 04:20:46 | Major, Oklahoma, US | |
2022-03-27 | US | Oklahoma | Major | 40093 | 2438 | 41 | 0 | 36.31149996 | -98.53467076 | 2022-03-28 04:20:33 | Major, Oklahoma, US | |
2022-03-26 | US | Oklahoma | Major | 40093 | 2438 | 41 | 0 | 36.31149996 | -98.53467076 | 2022-03-27 04:20:47 | Major, Oklahoma, US | |
2022-03-25 | US | Oklahoma | Major | 40093 | 2438 | 41 | 0 | 36.31149996 | -98.53467076 | 2022-03-26 04:20:23 | Major, Oklahoma, US | |
2022-03-24 | US | Oklahoma | Major | 40093 | 2438 | 41 | 0 | 36.31149996 | -98.53467076 | 2022-03-25 04:20:46 | Major, Oklahoma, US | |
2022-03-20 | US | Kansas | Doniphan | 20043 | 2438 | 34 | 0 | 39.79067154 | -95.14056866 | 2022-03-21 04:20:50 | Doniphan, Kansas, US | |
2022-03-19 | US | Kansas | Doniphan | 20043 | 2438 | 34 | 0 | 39.79067154 | -95.14056866 | 2022-03-20 04:20:45 | Doniphan, Kansas, US | |
2022-03-18 | US | Kansas | Doniphan | 20043 | 2438 | 34 | 0 | 39.79067154 | -95.14056866 | 2022-03-19 04:20:47 | Doniphan, Kansas, US | |
2022-03-17 | US | Kansas | Doniphan | 20043 | 2438 | 33 | 0 | 39.79067154 | -95.14056866 | 2022-03-18 04:20:55 | Doniphan, Kansas, US | |
2022-03-16 | US | Kansas | Doniphan | 20043 | 2438 | 33 | 0 | 39.79067154 | -95.14056866 | 2022-03-17 04:20:56 | Doniphan, Kansas, US | |
2022-03-15 | US | Kansas | Doniphan | 20043 | 2438 | 33 | 0 | 39.79067154 | -95.14056866 | 2022-03-16 04:20:50 | Doniphan, Kansas, US | |
2022-03-14 | US | Kansas | Doniphan | 20043 | 2438 | 33 | 0 | 39.79067154 | -95.14056866 | 2022-03-15 04:20:47 | Doniphan, Kansas, US | |
2022-02-15 | US | Iowa | Franklin | 19069 | 2438 | 40 | 0 | 42.73270384 | -93.26256925 | 2022-02-16 04:21:10 | Franklin, Iowa, US | |
2022-02-14 | US | Texas | Morris | 48343 | 2438 | 65 | 0 | 33.11304005 | -94.73255695 | 2022-02-15 04:21:09 | Morris, Texas, US | |
2022-02-14 | US | Iowa | Franklin | 19069 | 2438 | 40 | 0 | 42.73270384 | -93.26256925 | 2022-02-15 04:21:09 | Franklin, Iowa, US | |
2022-02-14 | US | Arkansas | Perry | 5105 | 2438 | 30 | 0 | 34.945915299999996 | -92.94372564 | 2022-02-15 04:21:09 | Perry, Arkansas, US | |
2022-02-13 | US | Minnesota | Yellow Medicine | 27173 | 2438 | 28 | 0 | 44.71710183 | -95.86842453 | 2022-02-14 04:20:51 | Yellow Medicine, Minnesota, US | |
2022-02-13 | US | Iowa | Franklin | 19069 | 2438 | 40 | 0 | 42.73270384 | -93.26256925 | 2022-02-14 04:20:51 | Franklin, Iowa, US | |
2022-02-13 | US | Arkansas | Perry | 5105 | 2438 | 30 | 0 | 34.945915299999996 | -92.94372564 | 2022-02-14 04:20:51 | Perry, Arkansas, US | |
2022-02-12 | US | Minnesota | Yellow Medicine | 27173 | 2438 | 28 | 0 | 44.71710183 | -95.86842453 | 2022-02-13 04:21:00 | Yellow Medicine, Minnesota, US | |
2022-02-12 | US | Iowa | Franklin | 19069 | 2438 | 40 | 0 | 42.73270384 | -93.26256925 | 2022-02-13 04:21:00 | Franklin, Iowa, US | |
2022-02-11 | US | Minnesota | Yellow Medicine | 27173 | 2438 | 28 | 0 | 44.71710183 | -95.86842453 | 2022-02-12 04:21:06 | Yellow Medicine, Minnesota, US | |
2022-02-11 | US | Iowa | Franklin | 19069 | 2438 | 40 | 0 | 42.73270384 | -93.26256925 | 2022-02-12 04:21:06 | Franklin, Iowa, US | |
2022-02-10 | US | Iowa | Franklin | 19069 | 2438 | 40 | 0 | 42.73270384 | -93.26256925 | 2022-02-11 04:21:09 | Franklin, Iowa, US | |
2022-02-09 | US | Iowa | Franklin | 19069 | 2438 | 40 | 0 | 42.73270384 | -93.26256925 | 2022-02-10 04:21:14 | Franklin, Iowa, US | |
2022-02-07 | US | Montana | Jefferson | 30043 | 2438 | 23 | 0 | 46.14907081 | -112.094396 | 2022-02-08 04:21:15 | Jefferson, Montana, US | |
2022-02-07 | US | Missouri | Douglas | 29067 | 2438 | 69 | 0 | 36.9325593 | -92.49905109 | 2022-02-08 04:21:15 | Douglas, Missouri, US | |
2022-02-06 | US | Mississippi | Tunica | 28143 | 2438 | 43 | 0 | 34.64967704 | -90.37481167 | 2022-02-07 04:21:05 | Tunica, Mississippi, US | |
2022-02-05 | US | Mississippi | Tunica | 28143 | 2438 | 43 | 0 | 34.64967704 | -90.37481167 | 2022-02-06 04:21:00 | Tunica, Mississippi, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;