daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
914 rows where confirmed = 316 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 | Texas | Motley | 48345 | 316 | 13 | 0 | 34.07408766 | -100.779722 | 2022-12-30 04:21:04 | Motley, Texas, US | |
2022-12-29 | US | Colorado | San Juan | 8111 | 316 | 0 | 0 | 37.76248981 | -107.6763289 | 2022-12-30 04:21:04 | San Juan, Colorado, US | |
2022-12-28 | US | Texas | Motley | 48345 | 316 | 13 | 0 | 34.07408766 | -100.779722 | 2022-12-29 04:21:01 | Motley, Texas, US | |
2022-12-28 | US | Colorado | San Juan | 8111 | 316 | 0 | 0 | 37.76248981 | -107.6763289 | 2022-12-29 04:21:01 | San Juan, Colorado, US | |
2022-12-27 | US | Texas | Sterling | 48431 | 316 | 9 | 0 | 31.82781912 | -101.0500746 | 2022-12-28 04:21:04 | Sterling, Texas, US | |
2022-12-27 | US | Colorado | San Juan | 8111 | 316 | 0 | 0 | 37.76248981 | -107.6763289 | 2022-12-28 04:21:04 | San Juan, Colorado, US | |
2022-12-26 | US | Texas | Sterling | 48431 | 316 | 9 | 0 | 31.82781912 | -101.0500746 | 2022-12-27 04:21:07 | Sterling, Texas, US | |
2022-12-26 | US | Colorado | San Juan | 8111 | 316 | 0 | 0 | 37.76248981 | -107.6763289 | 2022-12-27 04:21:07 | San Juan, Colorado, US | |
2022-12-25 | US | Texas | Sterling | 48431 | 316 | 9 | 0 | 31.82781912 | -101.0500746 | 2022-12-26 04:21:06 | Sterling, Texas, US | |
2022-12-25 | US | Colorado | San Juan | 8111 | 316 | 0 | 0 | 37.76248981 | -107.6763289 | 2022-12-26 04:21:06 | San Juan, Colorado, US | |
2022-12-24 | US | Texas | Sterling | 48431 | 316 | 9 | 0 | 31.82781912 | -101.0500746 | 2022-12-25 04:21:04 | Sterling, Texas, US | |
2022-12-24 | US | Colorado | San Juan | 8111 | 316 | 0 | 0 | 37.76248981 | -107.6763289 | 2022-12-25 04:21:04 | San Juan, Colorado, US | |
2022-12-23 | US | Texas | Sterling | 48431 | 316 | 9 | 0 | 31.82781912 | -101.0500746 | 2022-12-24 04:21:02 | Sterling, Texas, US | |
2022-12-23 | US | Colorado | San Juan | 8111 | 316 | 0 | 0 | 37.76248981 | -107.6763289 | 2022-12-24 04:21:02 | San Juan, Colorado, US | |
2022-12-22 | US | Texas | Sterling | 48431 | 316 | 9 | 0 | 31.82781912 | -101.0500746 | 2022-12-23 04:21:04 | Sterling, Texas, US | |
2022-12-22 | US | Colorado | San Juan | 8111 | 316 | 0 | 0 | 37.76248981 | -107.6763289 | 2022-12-23 04:21:04 | San Juan, Colorado, US | |
2022-12-21 | US | Texas | Sterling | 48431 | 316 | 9 | 0 | 31.82781912 | -101.0500746 | 2022-12-22 04:20:56 | Sterling, Texas, US | |
2022-12-21 | US | Colorado | San Juan | 8111 | 316 | 0 | 0 | 37.76248981 | -107.6763289 | 2022-12-22 04:20:56 | San Juan, Colorado, US | |
2022-08-21 | US | North Dakota | Sheridan | 38083 | 316 | 7 | 0 | 47.57700669 | -100.3426391 | 2022-08-22 04:20:38 | Sheridan, North Dakota, US | |
2022-08-20 | US | North Dakota | Sheridan | 38083 | 316 | 7 | 0 | 47.57700669 | -100.3426391 | 2022-08-21 04:20:44 | Sheridan, North Dakota, US | |
2022-08-19 | US | North Dakota | Sheridan | 38083 | 316 | 7 | 0 | 47.57700669 | -100.3426391 | 2022-08-20 04:21:01 | Sheridan, North Dakota, US | |
2022-07-14 | China | Hainan | 316 | 6 | 0 | 19.1959 | 109.7453 | 2022-07-15 04:20:53 | Hainan, China | |||
2022-04-21 | US | Texas | Cottle | 48101 | 316 | 9 | 0 | 34.07783319 | -100.27850620000001 | 2022-04-22 04:20:45 | Cottle, Texas, US | |
2022-03-17 | US | Oregon | Sherman | 41055 | 316 | 4 | 0 | 45.41501554 | -120.6827834 | 2022-03-18 04:20:55 | Sherman, Oregon, US | |
2022-03-16 | US | Oregon | Sherman | 41055 | 316 | 4 | 0 | 45.41501554 | -120.6827834 | 2022-03-17 04:20:56 | Sherman, Oregon, US | |
2022-03-15 | US | Oregon | Sherman | 41055 | 316 | 4 | 0 | 45.41501554 | -120.6827834 | 2022-03-16 04:20:50 | Sherman, Oregon, US | |
2022-03-14 | US | Oregon | Sherman | 41055 | 316 | 4 | 0 | 45.41501554 | -120.6827834 | 2022-03-15 04:20:47 | Sherman, Oregon, US | |
2022-03-13 | US | Oregon | Sherman | 41055 | 316 | 4 | 0 | 45.41501554 | -120.6827834 | 2022-03-14 04:20:46 | Sherman, Oregon, US | |
2022-03-12 | US | Oregon | Sherman | 41055 | 316 | 4 | 0 | 45.41501554 | -120.6827834 | 2022-03-13 04:20:49 | Sherman, Oregon, US | |
2022-03-11 | US | Oregon | Sherman | 41055 | 316 | 4 | 0 | 45.41501554 | -120.6827834 | 2022-03-12 04:20:50 | Sherman, Oregon, US | |
2022-03-10 | US | Oregon | Sherman | 41055 | 316 | 4 | 0 | 45.41501554 | -120.6827834 | 2022-03-11 04:20:50 | Sherman, Oregon, US | |
2022-03-09 | US | Oregon | Sherman | 41055 | 316 | 4 | 0 | 45.41501554 | -120.6827834 | 2022-03-10 04:20:48 | Sherman, Oregon, US | |
2022-02-01 | US | North Dakota | Oliver | 38065 | 316 | 4 | 0 | 47.11530482 | -101.3406158 | 2022-02-02 04:21:09 | Oliver, North Dakota, US | |
2022-01-30 | US | Montana | Wheatland | 30107 | 316 | 13 | 0 | 46.46652491 | -109.84646359999999 | 2022-01-31 04:21:09 | Wheatland, Montana, US | |
2022-01-29 | US | Texas | Stonewall | 48433 | 316 | 7 | 0 | 33.17906744 | -100.25384009999999 | 2022-01-30 04:21:26 | Stonewall, Texas, US | |
2022-01-29 | US | Montana | Wheatland | 30107 | 316 | 13 | 0 | 46.46652491 | -109.84646359999999 | 2022-01-30 04:21:26 | Wheatland, Montana, US | |
2022-01-28 | US | Montana | Wheatland | 30107 | 316 | 13 | 0 | 46.46652491 | -109.84646359999999 | 2022-01-29 04:21:10 | Wheatland, Montana, US | |
2022-01-25 | US | Nebraska | Garden | 31069 | 316 | 1 | 0 | 41.61703149 | -102.3313973 | 2022-01-26 04:21:07 | Garden, Nebraska, US | |
2022-01-23 | US | Washington | Garfield | 53023 | 316 | 7 | 0 | 46.43197502 | -117.54540320000001 | 2022-01-24 04:21:12 | Garfield, Washington, US | |
2022-01-22 | US | Washington | Garfield | 53023 | 316 | 7 | 0 | 46.43197502 | -117.54540320000001 | 2022-01-23 04:21:13 | Garfield, Washington, US | |
2022-01-21 | US | Washington | Garfield | 53023 | 316 | 7 | 0 | 46.43197502 | -117.54540320000001 | 2022-01-22 04:21:13 | Garfield, Washington, US | |
2022-01-18 | US | Montana | Liberty | 30051 | 316 | 2 | 0 | 48.56084317 | -111.02430700000001 | 2022-01-19 04:21:23 | Liberty, Montana, US | |
2022-01-13 | US | North Dakota | Steele | 38091 | 316 | 2 | 0 | 47.45611548 | -97.72728747 | 2022-01-14 04:21:54 | Steele, North Dakota, US | |
2022-01-13 | US | Nebraska | Gosper | 31073 | 316 | 5 | 0 | 40.51481965 | -99.83020279 | 2022-01-14 04:21:54 | Gosper, Nebraska, US | |
2022-01-12 | US | New Mexico | Catron | 35003 | 316 | 11 | 0 | 33.91514144 | -108.4046587 | 2022-01-13 08:00:09 | Catron, New Mexico, US | |
2022-01-12 | France | Saint Pierre and Miquelon | 316 | 0 | 0 | 46.8852 | -56.3159 | 2022-01-13 08:00:09 | Saint Pierre and Miquelon, France | |||
2022-01-09 | US | Alaska | Yakutat | 2282 | 316 | 4 | 0 | 59.890980799999994 | -140.36014509999998 | 2022-01-10 04:22:07 | Yakutat, Alaska, US | |
2022-01-08 | US | Alaska | Yakutat | 2282 | 316 | 4 | 0 | 59.890980799999994 | -140.36014509999998 | 2022-01-09 04:21:46 | Yakutat, Alaska, US | |
2022-01-07 | US | Alaska | Yakutat | 2282 | 316 | 4 | 0 | 59.890980799999994 | -140.36014509999998 | 2022-01-08 04:21:53 | Yakutat, Alaska, US | |
2022-01-06 | US | Washington | Wahkiakum | 53069 | 316 | 5 | 0 | 46.29180039999999 | -123.4250831 | 2022-01-07 04:22:09 | Wahkiakum, Washington, US | |
2022-01-05 | US | Washington | Wahkiakum | 53069 | 316 | 5 | 0 | 46.29180039999999 | -123.4250831 | 2022-01-06 04:22:09 | Wahkiakum, Washington, US | |
2022-01-04 | US | Washington | Wahkiakum | 53069 | 316 | 5 | 0 | 46.29180039999999 | -123.4250831 | 2022-01-05 04:21:59 | Wahkiakum, Washington, US | |
2022-01-03 | US | Washington | Wahkiakum | 53069 | 316 | 5 | 0 | 46.29180039999999 | -123.4250831 | 2022-01-04 04:22:17 | Wahkiakum, Washington, US | |
2022-01-03 | US | Montana | McCone | 30055 | 316 | 8 | 0 | 47.64469406 | -105.79449939999999 | 2022-01-04 04:22:17 | McCone, Montana, US | |
2021-12-29 | US | Nebraska | Greeley | 31077 | 316 | 1 | 0 | 41.56742671 | -98.52150266 | 2021-12-30 04:21:25 | Greeley, Nebraska, US | |
2021-12-28 | US | Nebraska | Greeley | 31077 | 316 | 1 | 0 | 41.56742671 | -98.52150266 | 2021-12-29 03:21:43 | Greeley, Nebraska, US | |
2021-12-27 | US | Nebraska | Greeley | 31077 | 316 | 1 | 0 | 41.56742671 | -98.52150266 | 2021-12-28 04:21:47 | Greeley, Nebraska, US | |
2021-12-26 | US | Nebraska | Greeley | 31077 | 316 | 1 | 0 | 41.56742671 | -98.52150266 | 2021-12-27 04:21:58 | Greeley, Nebraska, US | |
2021-12-26 | US | Georgia | Clay | 13061 | 316 | 4 | 0 | 31.62221166 | -84.97713865 | 2021-12-27 04:21:58 | Clay, Georgia, US | |
2021-12-25 | US | Nebraska | Greeley | 31077 | 316 | 1 | 0 | 41.56742671 | -98.52150266 | 2021-12-26 04:21:50 | Greeley, Nebraska, US | |
2021-12-25 | US | Georgia | Clay | 13061 | 316 | 4 | 0 | 31.62221166 | -84.97713865 | 2021-12-26 04:21:50 | Clay, Georgia, US | |
2021-12-24 | US | Nebraska | Greeley | 31077 | 316 | 1 | 0 | 41.56742671 | -98.52150266 | 2021-12-25 04:21:37 | Greeley, Nebraska, US | |
2021-12-24 | US | Georgia | Clay | 13061 | 316 | 4 | 0 | 31.62221166 | -84.97713865 | 2021-12-25 04:21:37 | Clay, Georgia, US | |
2021-12-23 | US | Nebraska | Greeley | 31077 | 316 | 1 | 0 | 41.56742671 | -98.52150266 | 2021-12-24 04:21:34 | Greeley, Nebraska, US | |
2021-12-23 | US | Georgia | Clay | 13061 | 316 | 4 | 0 | 31.62221166 | -84.97713865 | 2021-12-24 04:21:34 | Clay, Georgia, US | |
2021-12-22 | US | Texas | Schleicher | 48413 | 316 | 9 | 0 | 30.89740592 | -100.5384842 | 2021-12-23 04:21:21 | Schleicher, Texas, US | |
2021-12-22 | US | Nebraska | Greeley | 31077 | 316 | 1 | 0 | 41.56742671 | -98.52150266 | 2021-12-23 04:21:21 | Greeley, Nebraska, US | |
2021-12-22 | US | Montana | McCone | 30055 | 316 | 8 | 0 | 47.64469406 | -105.79449939999999 | 2021-12-23 04:21:21 | McCone, Montana, US | |
2021-12-22 | US | Georgia | Clay | 13061 | 316 | 4 | 0 | 31.62221166 | -84.97713865 | 2021-12-23 04:21:21 | Clay, Georgia, US | |
2021-12-21 | US | Texas | Schleicher | 48413 | 316 | 9 | 0 | 30.89740592 | -100.5384842 | 2021-12-22 04:21:54 | Schleicher, Texas, US | |
2021-12-21 | US | Montana | McCone | 30055 | 316 | 8 | 0 | 47.64469406 | -105.79449939999999 | 2021-12-22 04:21:54 | McCone, Montana, US | |
2021-12-21 | US | Georgia | Clay | 13061 | 316 | 4 | 0 | 31.62221166 | -84.97713865 | 2021-12-22 04:21:54 | Clay, Georgia, US | |
2021-12-20 | US | Texas | Schleicher | 48413 | 316 | 9 | 0 | 30.89740592 | -100.5384842 | 2021-12-21 03:21:27 | Schleicher, Texas, US | |
2021-12-20 | US | Texas | Dickens | 48125 | 316 | 15 | 0 | 33.61616822 | -100.7788855 | 2021-12-21 03:21:27 | Dickens, Texas, US | |
2021-12-20 | US | Montana | McCone | 30055 | 316 | 8 | 0 | 47.64469406 | -105.79449939999999 | 2021-12-21 03:21:27 | McCone, Montana, US | |
2021-12-20 | US | Georgia | Clay | 13061 | 316 | 4 | 0 | 31.62221166 | -84.97713865 | 2021-12-21 03:21:27 | Clay, Georgia, US | |
2021-12-19 | US | Texas | Dickens | 48125 | 316 | 15 | 0 | 33.61616822 | -100.7788855 | 2021-12-20 04:21:43 | Dickens, Texas, US | |
2021-12-19 | US | Montana | McCone | 30055 | 316 | 8 | 0 | 47.64469406 | -105.79449939999999 | 2021-12-20 04:21:43 | McCone, Montana, US | |
2021-12-19 | US | Georgia | Clay | 13061 | 316 | 4 | 0 | 31.62221166 | -84.97713865 | 2021-12-20 04:21:43 | Clay, Georgia, US | |
2021-12-18 | US | Texas | Dickens | 48125 | 316 | 15 | 0 | 33.61616822 | -100.7788855 | 2021-12-19 04:21:11 | Dickens, Texas, US | |
2021-12-18 | US | Montana | McCone | 30055 | 316 | 8 | 0 | 47.64469406 | -105.79449939999999 | 2021-12-19 04:21:11 | McCone, Montana, US | |
2021-12-18 | US | Georgia | Clay | 13061 | 316 | 4 | 0 | 31.62221166 | -84.97713865 | 2021-12-19 04:21:11 | Clay, Georgia, US | |
2021-12-17 | US | Montana | McCone | 30055 | 316 | 8 | 0 | 47.64469406 | -105.79449939999999 | 2021-12-18 02:22:20 | McCone, Montana, US | |
2021-12-17 | US | Georgia | Clay | 13061 | 316 | 4 | 0 | 31.62221166 | -84.97713865 | 2021-12-18 02:22:20 | Clay, Georgia, US | |
2021-12-16 | US | Montana | McCone | 30055 | 316 | 8 | 0 | 47.64469406 | -105.79449939999999 | 2021-12-17 04:22:14 | McCone, Montana, US | |
2021-12-15 | US | Montana | McCone | 30055 | 316 | 8 | 0 | 47.64469406 | -105.79449939999999 | 2021-12-16 04:22:11 | McCone, Montana, US | |
2021-12-09 | US | South Dakota | Jerauld | 46073 | 316 | 18 | 0 | 44.06637798 | -98.62965972 | 2021-12-10 04:22:28 | Jerauld, South Dakota, US | |
2021-12-02 | US | Kansas | Wichita | 20203 | 316 | 8 | 0 | 38.48178252 | -101.3471509 | 2021-12-03 04:23:05 | Wichita, Kansas, US | |
2021-12-01 | US | Kansas | Wichita | 20203 | 316 | 8 | 0 | 38.48178252 | -101.3471509 | 2021-12-02 04:22:37 | Wichita, Kansas, US | |
2021-11-30 | US | Kansas | Stanton | 20187 | 316 | 7 | 0 | 37.56304714 | -101.78435340000001 | 2021-12-01 04:22:29 | Stanton, Kansas, US | |
2021-11-29 | US | Kansas | Stanton | 20187 | 316 | 7 | 0 | 37.56304714 | -101.78435340000001 | 2021-11-30 04:22:53 | Stanton, Kansas, US | |
2021-11-28 | US | North Dakota | Divide | 38023 | 316 | 3 | 0 | 48.814938700000006 | -103.48736109999999 | 2021-11-29 04:22:30 | Divide, North Dakota, US | |
2021-11-03 | US | North Dakota | Burke | 38013 | 316 | 3 | 0 | 48.79094471 | -102.51821170000001 | 2021-11-04 04:22:20 | Burke, North Dakota, US | |
2021-10-31 | US | California | Unassigned | 90006 | 316 | 0 | 0 | 41.74228275 | 0.0 | 2021-11-01 04:22:01 | Unassigned, California, US | |
2021-10-30 | US | California | Unassigned | 90006 | 316 | 0 | 0 | 41.74228275 | 0.0 | 2021-10-31 04:22:08 | Unassigned, California, US | |
2021-10-29 | US | California | Unassigned | 90006 | 316 | 0 | 0 | 41.74228275 | 0.0 | 2021-10-30 04:22:03 | Unassigned, California, US | |
2021-10-26 | US | Nebraska | Franklin | 31061 | 316 | 4 | 0 | 40.17636348 | -98.95299073 | 2021-10-27 04:22:32 | Franklin, Nebraska, US | |
2021-10-25 | US | Nebraska | Franklin | 31061 | 316 | 4 | 0 | 40.17636348 | -98.95299073 | 2021-10-26 04:22:09 | Franklin, Nebraska, US | |
2021-10-24 | US | Nebraska | Franklin | 31061 | 316 | 4 | 0 | 40.17636348 | -98.95299073 | 2021-10-25 04:22:31 | Franklin, Nebraska, US | |
2021-10-23 | US | Nebraska | Franklin | 31061 | 316 | 4 | 0 | 40.17636348 | -98.95299073 | 2021-10-24 04:21:22 | Franklin, Nebraska, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;