daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
692 rows where confirmed = 497 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-11-20 | US | New Mexico | Catron | 35003 | 497 | 22 | 0 | 33.91514144 | -108.4046587 | 2022-11-21 04:21:05 | Catron, New Mexico, US | |
2022-11-19 | US | New Mexico | Catron | 35003 | 497 | 22 | 0 | 33.91514144 | -108.4046587 | 2022-11-20 04:21:08 | Catron, New Mexico, US | |
2022-11-18 | US | New Mexico | Catron | 35003 | 497 | 22 | 0 | 33.91514144 | -108.4046587 | 2022-11-19 04:21:14 | Catron, New Mexico, US | |
2022-11-08 | US | North Dakota | Golden Valley | 38033 | 497 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-11-09 04:21:22 | Golden Valley, North Dakota, US | |
2022-11-07 | US | North Dakota | Golden Valley | 38033 | 497 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-11-08 04:21:21 | Golden Valley, North Dakota, US | |
2022-11-06 | US | North Dakota | Golden Valley | 38033 | 497 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-11-07 04:21:26 | Golden Valley, North Dakota, US | |
2022-11-05 | US | North Dakota | Golden Valley | 38033 | 497 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-11-06 04:21:24 | Golden Valley, North Dakota, US | |
2022-11-04 | US | North Dakota | Golden Valley | 38033 | 497 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-11-05 04:21:52 | Golden Valley, North Dakota, US | |
2022-11-03 | US | North Dakota | Golden Valley | 38033 | 497 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-11-04 04:22:11 | Golden Valley, North Dakota, US | |
2022-11-02 | US | North Dakota | Golden Valley | 38033 | 497 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-11-03 04:22:05 | Golden Valley, North Dakota, US | |
2022-11-01 | US | North Dakota | Golden Valley | 38033 | 497 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-11-02 04:22:09 | Golden Valley, North Dakota, US | |
2022-10-31 | US | North Dakota | Golden Valley | 38033 | 497 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-11-01 04:22:36 | Golden Valley, North Dakota, US | |
2022-10-30 | US | North Dakota | Golden Valley | 38033 | 497 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-10-31 04:21:36 | Golden Valley, North Dakota, US | |
2022-10-29 | US | North Dakota | Golden Valley | 38033 | 497 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-10-30 04:22:14 | Golden Valley, North Dakota, US | |
2022-10-28 | US | North Dakota | Golden Valley | 38033 | 497 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-10-29 04:21:13 | Golden Valley, North Dakota, US | |
2022-10-27 | US | North Dakota | Golden Valley | 38033 | 497 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-10-28 04:22:31 | Golden Valley, North Dakota, US | |
2022-10-26 | US | North Dakota | Golden Valley | 38033 | 497 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-10-27 04:22:01 | Golden Valley, North Dakota, US | |
2022-10-25 | US | North Dakota | Golden Valley | 38033 | 497 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-10-26 04:22:19 | Golden Valley, North Dakota, US | |
2022-10-24 | US | North Dakota | Golden Valley | 38033 | 497 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-10-25 04:21:53 | Golden Valley, North Dakota, US | |
2022-10-23 | US | North Dakota | Golden Valley | 38033 | 497 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-10-24 04:22:29 | Golden Valley, North Dakota, US | |
2022-10-22 | US | North Dakota | Golden Valley | 38033 | 497 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-10-23 04:22:46 | Golden Valley, North Dakota, US | |
2022-10-21 | US | North Dakota | Golden Valley | 38033 | 497 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-10-22 04:22:53 | Golden Valley, North Dakota, US | |
2022-09-20 | US | South Dakota | Haakon | 46055 | 497 | 12 | 0 | 44.29299053 | -101.539099 | 2022-09-21 04:23:22 | Haakon, South Dakota, US | |
2022-09-19 | US | South Dakota | Haakon | 46055 | 497 | 12 | 0 | 44.29299053 | -101.539099 | 2022-09-20 04:22:48 | Haakon, South Dakota, US | |
2022-09-18 | US | South Dakota | Haakon | 46055 | 497 | 12 | 0 | 44.29299053 | -101.539099 | 2022-09-19 04:21:49 | Haakon, South Dakota, US | |
2022-09-17 | US | South Dakota | Haakon | 46055 | 497 | 12 | 0 | 44.29299053 | -101.539099 | 2022-09-18 04:22:50 | Haakon, South Dakota, US | |
2022-09-16 | US | South Dakota | Haakon | 46055 | 497 | 12 | 0 | 44.29299053 | -101.539099 | 2022-09-17 04:20:19 | Haakon, South Dakota, US | |
2022-09-15 | US | South Dakota | Haakon | 46055 | 497 | 12 | 0 | 44.29299053 | -101.539099 | 2022-09-16 04:21:19 | Haakon, South Dakota, US | |
2022-09-14 | US | South Dakota | Haakon | 46055 | 497 | 12 | 0 | 44.29299053 | -101.539099 | 2022-09-15 04:21:02 | Haakon, South Dakota, US | |
2022-09-13 | US | South Dakota | Haakon | 46055 | 497 | 12 | 0 | 44.29299053 | -101.539099 | 2022-09-14 04:20:44 | Haakon, South Dakota, US | |
2022-09-12 | US | South Dakota | Haakon | 46055 | 497 | 12 | 0 | 44.29299053 | -101.539099 | 2022-09-13 04:20:57 | Haakon, South Dakota, US | |
2022-09-11 | US | South Dakota | Haakon | 46055 | 497 | 12 | 0 | 44.29299053 | -101.539099 | 2022-09-12 04:20:58 | Haakon, South Dakota, US | |
2022-09-10 | US | South Dakota | Haakon | 46055 | 497 | 12 | 0 | 44.29299053 | -101.539099 | 2022-09-11 04:20:50 | Haakon, South Dakota, US | |
2022-09-09 | US | South Dakota | Haakon | 46055 | 497 | 12 | 0 | 44.29299053 | -101.539099 | 2022-09-10 04:21:10 | Haakon, South Dakota, US | |
2022-09-08 | US | South Dakota | Haakon | 46055 | 497 | 12 | 0 | 44.29299053 | -101.539099 | 2022-09-09 04:21:11 | Haakon, South Dakota, US | |
2022-09-07 | US | South Dakota | Haakon | 46055 | 497 | 12 | 0 | 44.29299053 | -101.539099 | 2022-09-08 04:21:02 | Haakon, South Dakota, US | |
2022-08-18 | US | North Dakota | Grant | 38037 | 497 | 11 | 0 | 46.35821257 | -101.6390013 | 2022-08-19 04:20:54 | Grant, North Dakota, US | |
2022-08-18 | US | Montana | Meagher | 30059 | 497 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-08-19 04:20:54 | Meagher, Montana, US | |
2022-08-17 | US | Montana | Meagher | 30059 | 497 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-08-18 04:21:11 | Meagher, Montana, US | |
2022-08-16 | US | Montana | Meagher | 30059 | 497 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-08-17 04:20:59 | Meagher, Montana, US | |
2022-08-15 | US | Montana | Meagher | 30059 | 497 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-08-16 04:20:58 | Meagher, Montana, US | |
2022-08-14 | US | Montana | Meagher | 30059 | 497 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-08-15 04:20:59 | Meagher, Montana, US | |
2022-08-13 | US | Montana | Meagher | 30059 | 497 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-08-14 04:20:55 | Meagher, Montana, US | |
2022-08-12 | US | Montana | Meagher | 30059 | 497 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-08-13 04:20:52 | Meagher, Montana, US | |
2022-07-12 | US | North Dakota | Divide | 38023 | 497 | 4 | 0 | 48.8149387 | -103.4873611 | 2022-07-13 04:20:58 | Divide, North Dakota, US | |
2022-07-08 | US | Texas | Edwards | 48137 | 497 | 11 | 0 | 29.98202582 | -100.304252 | 2022-07-09 04:20:59 | Edwards, Texas, US | |
2022-06-08 | US | Colorado | Sedgwick | 8115 | 497 | 10 | 0 | 40.87595412 | -102.3519227 | 2022-06-09 04:20:54 | Sedgwick, Colorado, US | |
2022-04-08 | US | Texas | Sherman | 48421 | 497 | 16 | 0 | 36.27751473 | -101.8933156 | 2022-04-09 04:20:42 | Sherman, Texas, US | |
2022-04-07 | US | Texas | Sherman | 48421 | 497 | 16 | 0 | 36.27751473 | -101.8933156 | 2022-04-08 04:20:48 | Sherman, Texas, US | |
2022-04-06 | US | Texas | Sherman | 48421 | 497 | 16 | 0 | 36.27751473 | -101.8933156 | 2022-04-07 04:20:53 | Sherman, Texas, US | |
2022-04-05 | US | Texas | Sherman | 48421 | 497 | 16 | 0 | 36.27751473 | -101.8933156 | 2022-04-06 04:20:49 | Sherman, Texas, US | |
2022-04-04 | US | Texas | Sherman | 48421 | 497 | 16 | 0 | 36.27751473 | -101.8933156 | 2022-04-05 04:20:48 | Sherman, Texas, US | |
2022-04-03 | US | Texas | Sherman | 48421 | 497 | 16 | 0 | 36.27751473 | -101.8933156 | 2022-04-04 04:20:51 | Sherman, Texas, US | |
2022-04-02 | US | Texas | Sherman | 48421 | 497 | 16 | 0 | 36.27751473 | -101.8933156 | 2022-04-03 04:20:48 | Sherman, Texas, US | |
2022-04-01 | US | Texas | Sherman | 48421 | 497 | 16 | 0 | 36.27751473 | -101.8933156 | 2022-04-02 04:20:47 | Sherman, Texas, US | |
2022-03-31 | US | Texas | Sherman | 48421 | 497 | 16 | 0 | 36.27751473 | -101.8933156 | 2022-04-01 04:20:28 | Sherman, Texas, US | |
2022-03-30 | US | Texas | Sherman | 48421 | 497 | 16 | 0 | 36.27751473 | -101.8933156 | 2022-03-31 04:20:56 | Sherman, Texas, US | |
2022-03-29 | US | Texas | Sherman | 48421 | 497 | 16 | 0 | 36.27751473 | -101.8933156 | 2022-03-30 04:20:45 | Sherman, Texas, US | |
2022-03-28 | US | Texas | Sherman | 48421 | 497 | 16 | 0 | 36.27751473 | -101.8933156 | 2022-03-29 04:20:46 | Sherman, Texas, US | |
2022-03-27 | US | Texas | Sherman | 48421 | 497 | 16 | 0 | 36.27751473 | -101.8933156 | 2022-03-28 04:20:33 | Sherman, Texas, US | |
2022-03-26 | US | Texas | Sherman | 48421 | 497 | 16 | 0 | 36.27751473 | -101.8933156 | 2022-03-27 04:20:47 | Sherman, Texas, US | |
2022-03-25 | US | Texas | Sherman | 48421 | 497 | 16 | 0 | 36.27751473 | -101.8933156 | 2022-03-26 04:20:23 | Sherman, Texas, US | |
2022-03-24 | US | Texas | Sherman | 48421 | 497 | 16 | 0 | 36.27751473 | -101.8933156 | 2022-03-25 04:20:46 | Sherman, Texas, US | |
2022-03-23 | US | Texas | Sherman | 48421 | 497 | 16 | 0 | 36.27751473 | -101.8933156 | 2022-03-24 04:20:43 | Sherman, Texas, US | |
2022-03-22 | US | Texas | Sherman | 48421 | 497 | 16 | 0 | 36.27751473 | -101.8933156 | 2022-03-23 04:20:48 | Sherman, Texas, US | |
2022-03-21 | US | Texas | Sherman | 48421 | 497 | 16 | 0 | 36.27751473 | -101.8933156 | 2022-03-22 04:20:54 | Sherman, Texas, US | |
2022-03-20 | US | Texas | Sherman | 48421 | 497 | 16 | 0 | 36.27751473 | -101.8933156 | 2022-03-21 04:20:50 | Sherman, Texas, US | |
2022-03-19 | US | Texas | Sherman | 48421 | 497 | 16 | 0 | 36.27751473 | -101.8933156 | 2022-03-20 04:20:45 | Sherman, Texas, US | |
2022-03-18 | US | Texas | Sherman | 48421 | 497 | 16 | 0 | 36.27751473 | -101.8933156 | 2022-03-19 04:20:47 | Sherman, Texas, US | |
2022-03-17 | US | Kansas | Clark | 20025 | 497 | 7 | 0 | 37.23577007 | -99.81883015 | 2022-03-18 04:20:55 | Clark, Kansas, US | |
2022-03-16 | US | Kansas | Clark | 20025 | 497 | 7 | 0 | 37.23577007 | -99.81883015 | 2022-03-17 04:20:56 | Clark, Kansas, US | |
2022-02-23 | US | North Dakota | Kidder | 38043 | 497 | 13 | 0 | 46.97830064 | -99.77507857 | 2022-02-24 04:21:14 | Kidder, North Dakota, US | |
2022-02-17 | US | Nebraska | Hitchcock | 31087 | 497 | 5 | 0 | 40.17609175 | -101.04164770000001 | 2022-02-18 04:21:04 | Hitchcock, Nebraska, US | |
2022-02-04 | US | Texas | Schleicher | 48413 | 497 | 9 | 0 | 30.89740592 | -100.5384842 | 2022-02-05 04:21:05 | Schleicher, Texas, US | |
2022-01-31 | US | Texas | Culberson | 48109 | 497 | 13 | 0 | 31.44506775 | -104.5185739 | 2022-02-01 04:21:11 | Culberson, Texas, US | |
2022-01-26 | US | Georgia | Baker | 13007 | 497 | 14 | 0 | 31.32669878 | -84.44218806 | 2022-01-27 04:21:19 | Baker, Georgia, US | |
2022-01-20 | US | South Dakota | Faulk | 46049 | 497 | 16 | 0 | 45.07082625 | -99.14535601 | 2022-01-21 04:21:09 | Faulk, South Dakota, US | |
2022-01-19 | US | Texas | Oldham | 48359 | 497 | 6 | 0 | 35.40425596 | -102.6027606 | 2022-01-20 04:21:07 | Oldham, Texas, US | |
2022-01-18 | US | Puerto Rico | Vieques | 72147 | 497 | 0 | 0 | 18.123276 | -65.44097099999999 | 2022-01-19 04:21:23 | Vieques, Puerto Rico, US | |
2022-01-16 | US | Nebraska | Sherman | 31163 | 497 | 4 | 0 | 41.22045983 | -98.97588642 | 2022-01-17 04:21:08 | Sherman, Nebraska, US | |
2022-01-15 | US | Nebraska | Sherman | 31163 | 497 | 4 | 0 | 41.22045983 | -98.97588642 | 2022-01-16 04:21:12 | Sherman, Nebraska, US | |
2022-01-14 | US | Nebraska | Sherman | 31163 | 497 | 4 | 0 | 41.22045983 | -98.97588642 | 2022-01-15 04:21:07 | Sherman, Nebraska, US | |
2022-01-12 | US | North Dakota | Griggs | 38039 | 497 | 2 | 0 | 47.45785838 | -98.23850925 | 2022-01-13 08:00:09 | Griggs, North Dakota, US | |
2022-01-11 | US | Texas | Fisher | 48151 | 497 | 20 | 0 | 32.74281316 | -100.40193020000001 | 2022-01-12 04:21:44 | Fisher, Texas, US | |
2022-01-10 | US | South Dakota | Ziebach | 46137 | 497 | 11 | 0 | 44.97881876 | -101.6654622 | 2022-01-11 04:22:01 | Ziebach, South Dakota, US | |
2022-01-05 | US | New Mexico | Mora | 35033 | 497 | 14 | 0 | 36.01095101 | -104.9497716 | 2022-01-06 04:22:09 | Mora, New Mexico, US | |
2021-12-21 | US | Colorado | Custer | 8027 | 497 | 15 | 0 | 38.10883162 | -105.3683478 | 2021-12-22 04:21:54 | Custer, Colorado, US | |
2021-12-20 | US | Colorado | Custer | 8027 | 497 | 15 | 0 | 38.10883162 | -105.3683478 | 2021-12-21 03:21:27 | Custer, Colorado, US | |
2021-12-19 | US | New Mexico | Union | 35059 | 497 | 12 | 0 | 36.48126404 | -103.4709624 | 2021-12-20 04:21:43 | Union, New Mexico, US | |
2021-12-18 | US | New Mexico | Union | 35059 | 497 | 12 | 0 | 36.48126404 | -103.4709624 | 2021-12-19 04:21:11 | Union, New Mexico, US | |
2021-12-17 | US | New Mexico | Union | 35059 | 497 | 12 | 0 | 36.48126404 | -103.4709624 | 2021-12-18 02:22:20 | Union, New Mexico, US | |
2021-12-13 | China | Guangxi | 497 | 2 | 0 | 23.8298 | 108.7881 | 2021-12-14 04:22:38 | Guangxi, China | |||
2021-12-08 | US | South Dakota | Stanley | 46117 | 497 | 3 | 0 | 44.41381872 | -100.7349153 | 2021-12-09 04:22:49 | Stanley, South Dakota, US | |
2021-12-02 | US | Wyoming | Niobrara | 56027 | 497 | 8 | 0 | 43.05607708 | -104.47588959999999 | 2021-12-03 04:23:05 | Niobrara, Wyoming, US | |
2021-11-18 | US | New York | Hamilton | 36041 | 497 | 3 | 0 | 43.66146647 | -74.49721957 | 2021-11-19 04:21:40 | Hamilton, New York, US | |
2021-11-16 | US | Oklahoma | Ellis | 40045 | 497 | 6 | 0 | 36.218019399999996 | -99.75324573 | 2021-11-17 04:21:48 | Ellis, Oklahoma, US | |
2021-11-16 | US | North Dakota | McIntosh | 38051 | 497 | 8 | 0 | 46.11182017 | -99.44145858 | 2021-11-17 04:21:48 | McIntosh, North Dakota, US | |
2021-11-15 | US | South Dakota | Bennett | 46007 | 497 | 9 | 0 | 43.19486375 | -101.6665572 | 2021-11-16 04:21:10 | Bennett, South Dakota, US | |
2021-11-15 | US | Oklahoma | Ellis | 40045 | 497 | 6 | 0 | 36.218019399999996 | -99.75324573 | 2021-11-16 04:21:10 | Ellis, Oklahoma, US | |
2021-11-15 | US | Nebraska | Valley | 31175 | 497 | 2 | 0 | 41.56730777 | -98.98197724 | 2021-11-16 04:21:10 | Valley, Nebraska, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;