daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
531 rows where confirmed = 1030 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-22 | US | Georgia | Echols | 13101 | 1030 | 12 | 0 | 30.71101099 | -82.89687287 | 2022-11-23 04:21:06 | Echols, Georgia, US | |
2022-11-21 | US | Georgia | Echols | 13101 | 1030 | 12 | 0 | 30.71101099 | -82.89687287 | 2022-11-22 04:20:47 | Echols, Georgia, US | |
2022-11-20 | US | Georgia | Echols | 13101 | 1030 | 12 | 0 | 30.71101099 | -82.89687287 | 2022-11-21 04:21:05 | Echols, Georgia, US | |
2022-11-19 | US | Georgia | Echols | 13101 | 1030 | 12 | 0 | 30.71101099 | -82.89687287 | 2022-11-20 04:21:08 | Echols, Georgia, US | |
2022-11-18 | US | Georgia | Echols | 13101 | 1030 | 12 | 0 | 30.71101099 | -82.89687287 | 2022-11-19 04:21:14 | Echols, Georgia, US | |
2022-11-17 | US | Georgia | Echols | 13101 | 1030 | 12 | 0 | 30.71101099 | -82.89687287 | 2022-11-18 04:21:15 | Echols, Georgia, US | |
2022-11-16 | US | Georgia | Echols | 13101 | 1030 | 12 | 0 | 30.71101099 | -82.89687287 | 2022-11-17 04:21:11 | Echols, Georgia, US | |
2022-11-10 | US | Colorado | Phillips | 8095 | 1030 | 19 | 0 | 40.59414277 | -102.3577703 | 2022-11-11 04:21:22 | Phillips, Colorado, US | |
2022-11-09 | US | Colorado | Phillips | 8095 | 1030 | 19 | 0 | 40.59414277 | -102.3577703 | 2022-11-10 04:21:16 | Phillips, Colorado, US | |
2022-10-30 | US | Texas | Haskell | 48207 | 1030 | 39 | 0 | 33.17823584 | -99.73037358 | 2022-10-31 04:21:36 | Haskell, Texas, US | |
2022-10-29 | US | Texas | Haskell | 48207 | 1030 | 39 | 0 | 33.17823584 | -99.73037358 | 2022-10-30 04:22:14 | Haskell, Texas, US | |
2022-10-29 | US | New York | Hamilton | 36041 | 1030 | 5 | 0 | 43.66146647 | -74.49721957 | 2022-10-30 04:22:14 | Hamilton, New York, US | |
2022-10-28 | US | Texas | Haskell | 48207 | 1030 | 39 | 0 | 33.17823584 | -99.73037358 | 2022-10-29 04:21:13 | Haskell, Texas, US | |
2022-10-27 | US | Texas | Haskell | 48207 | 1030 | 39 | 0 | 33.17823584 | -99.73037358 | 2022-10-28 04:22:31 | Haskell, Texas, US | |
2022-10-26 | US | Texas | Haskell | 48207 | 1030 | 39 | 0 | 33.17823584 | -99.73037358 | 2022-10-27 04:22:01 | Haskell, Texas, US | |
2022-10-25 | US | Texas | Haskell | 48207 | 1030 | 39 | 0 | 33.17823584 | -99.73037358 | 2022-10-26 04:22:19 | Haskell, Texas, US | |
2022-10-24 | US | Texas | Haskell | 48207 | 1030 | 39 | 0 | 33.17823584 | -99.73037358 | 2022-10-25 04:21:53 | Haskell, Texas, US | |
2022-10-23 | US | Texas | Haskell | 48207 | 1030 | 39 | 0 | 33.17823584 | -99.73037358 | 2022-10-24 04:22:29 | Haskell, Texas, US | |
2022-10-22 | US | Texas | Haskell | 48207 | 1030 | 39 | 0 | 33.17823584 | -99.73037358 | 2022-10-23 04:22:46 | Haskell, Texas, US | |
2022-10-21 | US | Texas | Haskell | 48207 | 1030 | 39 | 0 | 33.17823584 | -99.73037358 | 2022-10-22 04:22:53 | Haskell, Texas, US | |
2022-10-20 | US | Texas | Haskell | 48207 | 1030 | 39 | 0 | 33.17823584 | -99.73037358 | 2022-10-21 04:22:23 | Haskell, Texas, US | |
2022-10-19 | US | Texas | Haskell | 48207 | 1030 | 39 | 0 | 33.17823584 | -99.73037358 | 2022-10-20 04:22:59 | Haskell, Texas, US | |
2022-10-18 | US | Texas | Haskell | 48207 | 1030 | 39 | 0 | 33.17823584 | -99.73037358 | 2022-10-19 04:22:26 | Haskell, Texas, US | |
2022-10-17 | US | Texas | Haskell | 48207 | 1030 | 39 | 0 | 33.17823584 | -99.73037358 | 2022-10-18 04:22:42 | Haskell, Texas, US | |
2022-10-16 | US | Texas | Shackelford | 48417 | 1030 | 12 | 0 | 32.73587756 | -99.35401337 | 2022-10-17 04:20:31 | Shackelford, Texas, US | |
2022-10-16 | US | Texas | Haskell | 48207 | 1030 | 39 | 0 | 33.17823584 | -99.73037358 | 2022-10-17 04:20:31 | Haskell, Texas, US | |
2022-10-15 | US | Texas | Shackelford | 48417 | 1030 | 12 | 0 | 32.73587756 | -99.35401337 | 2022-10-16 04:22:39 | Shackelford, Texas, US | |
2022-10-15 | US | Texas | Haskell | 48207 | 1030 | 39 | 0 | 33.17823584 | -99.73037358 | 2022-10-16 04:22:39 | Haskell, Texas, US | |
2022-10-14 | US | Texas | Shackelford | 48417 | 1030 | 12 | 0 | 32.73587756 | -99.35401337 | 2022-10-15 04:22:00 | Shackelford, Texas, US | |
2022-10-14 | US | Texas | Haskell | 48207 | 1030 | 39 | 0 | 33.17823584 | -99.73037358 | 2022-10-15 04:22:00 | Haskell, Texas, US | |
2022-10-13 | US | Texas | Haskell | 48207 | 1030 | 39 | 0 | 33.17823584 | -99.73037358 | 2022-10-14 04:22:28 | Haskell, Texas, US | |
2022-10-12 | US | Texas | Haskell | 48207 | 1030 | 39 | 0 | 33.17823584 | -99.73037358 | 2022-10-13 04:22:39 | Haskell, Texas, US | |
2022-10-11 | US | Texas | Haskell | 48207 | 1030 | 39 | 0 | 33.17823584 | -99.73037358 | 2022-10-12 04:22:51 | Haskell, Texas, US | |
2022-10-10 | US | Texas | Haskell | 48207 | 1030 | 39 | 0 | 33.17823584 | -99.73037358 | 2022-10-11 04:23:05 | Haskell, Texas, US | |
2022-09-22 | China | Chongqing | 1030 | 6 | 0 | 30.0572 | 107.874 | 2022-09-23 04:23:13 | Chongqing, China | |||
2022-09-08 | US | Idaho | Bear Lake | 16007 | 1030 | 16 | 0 | 42.28269683 | -111.3289238 | 2022-09-09 04:21:11 | Bear Lake, Idaho, US | |
2022-09-07 | US | Idaho | Bear Lake | 16007 | 1030 | 16 | 0 | 42.28269683 | -111.3289238 | 2022-09-08 04:21:02 | Bear Lake, Idaho, US | |
2022-09-04 | US | Virginia | Bath | 51017 | 1030 | 22 | 0 | 38.05852573 | -79.73912095 | 2022-09-05 04:21:01 | Bath, Virginia, US | |
2022-09-03 | US | Virginia | Bath | 51017 | 1030 | 22 | 0 | 38.05852573 | -79.73912095 | 2022-09-04 04:21:22 | Bath, Virginia, US | |
2022-09-02 | US | Virginia | Bath | 51017 | 1030 | 22 | 0 | 38.05852573 | -79.73912095 | 2022-09-03 04:21:04 | Bath, Virginia, US | |
2022-08-31 | US | Virginia | Bath | 51017 | 1030 | 22 | 0 | 38.05852573 | -79.73912095 | 2022-09-01 04:21:03 | Bath, Virginia, US | |
2022-07-25 | US | Illinois | Pope | 17151 | 1030 | 9 | 0 | 37.41391284 | -88.56152109 | 2022-07-26 04:20:58 | Pope, Illinois, US | |
2022-07-19 | US | North Dakota | Foster | 38031 | 1030 | 23 | 0 | 47.4571084 | -98.88279923 | 2022-07-20 04:20:59 | Foster, North Dakota, US | |
2022-07-12 | US | North Carolina | Tyrrell | 37177 | 1030 | 8 | 0 | 35.87147226 | -76.17055253 | 2022-07-13 04:20:58 | Tyrrell, North Carolina, US | |
2022-07-11 | US | North Carolina | Tyrrell | 37177 | 1030 | 8 | 0 | 35.87147226 | -76.17055253 | 2022-07-12 04:20:51 | Tyrrell, North Carolina, US | |
2022-07-10 | US | North Carolina | Tyrrell | 37177 | 1030 | 8 | 0 | 35.87147226 | -76.17055253 | 2022-07-11 04:20:46 | Tyrrell, North Carolina, US | |
2022-07-09 | US | North Carolina | Tyrrell | 37177 | 1030 | 8 | 0 | 35.87147226 | -76.17055253 | 2022-07-10 04:20:54 | Tyrrell, North Carolina, US | |
2022-07-08 | US | North Carolina | Tyrrell | 37177 | 1030 | 8 | 0 | 35.87147226 | -76.17055253 | 2022-07-09 04:20:59 | Tyrrell, North Carolina, US | |
2022-07-07 | US | North Carolina | Tyrrell | 37177 | 1030 | 8 | 0 | 35.87147226 | -76.17055253 | 2022-07-08 04:20:56 | Tyrrell, North Carolina, US | |
2022-07-06 | US | North Carolina | Tyrrell | 37177 | 1030 | 8 | 0 | 35.87147226 | -76.17055253 | 2022-07-07 04:20:55 | Tyrrell, North Carolina, US | |
2022-06-29 | US | North Dakota | LaMoure | 38045 | 1030 | 20 | 0 | 46.45681054 | -98.53542355 | 2022-06-30 04:21:01 | LaMoure, North Dakota, US | |
2022-06-28 | US | North Dakota | LaMoure | 38045 | 1030 | 20 | 0 | 46.45681054 | -98.53542355 | 2022-06-29 04:20:59 | LaMoure, North Dakota, US | |
2022-06-27 | US | North Dakota | LaMoure | 38045 | 1030 | 20 | 0 | 46.45681054 | -98.53542355 | 2022-06-28 04:20:58 | LaMoure, North Dakota, US | |
2022-06-12 | US | California | Modoc | 6049 | 1030 | 8 | 0 | 41.58965602 | -120.7244817 | 2022-06-13 04:21:14 | Modoc, California, US | |
2022-06-11 | US | California | Modoc | 6049 | 1030 | 8 | 0 | 41.58965602 | -120.7244817 | 2022-06-12 04:20:53 | Modoc, California, US | |
2022-06-10 | US | California | Modoc | 6049 | 1030 | 8 | 0 | 41.58965602 | -120.7244817 | 2022-06-11 04:21:01 | Modoc, California, US | |
2022-06-09 | US | California | Modoc | 6049 | 1030 | 8 | 0 | 41.58965602 | -120.7244817 | 2022-06-10 04:20:55 | Modoc, California, US | |
2022-05-22 | US | Colorado | Gilpin | 8047 | 1030 | 4 | 0 | 39.85646523 | -105.5252597 | 2022-05-26 04:20:50 | Gilpin, Colorado, US | |
2022-05-09 | US | North Dakota | Sargent | 38081 | 1030 | 9 | 0 | 46.10830372 | -97.63217159 | 2022-05-10 04:20:50 | Sargent, North Dakota, US | |
2022-04-24 | US | Virginia | Rappahannock | 51157 | 1030 | 10 | 0 | 38.68295619 | -78.15826963 | 2022-04-25 04:20:56 | Rappahannock, Virginia, US | |
2022-04-23 | US | Virginia | Rappahannock | 51157 | 1030 | 10 | 0 | 38.68295619 | -78.15826963 | 2022-04-24 04:20:56 | Rappahannock, Virginia, US | |
2022-04-22 | US | Virginia | Rappahannock | 51157 | 1030 | 10 | 0 | 38.68295619 | -78.15826963 | 2022-04-23 04:20:50 | Rappahannock, Virginia, US | |
2022-04-17 | US | Puerto Rico | Las Marias | 72083 | 1030 | 0 | 0 | 18.23679 | -66.98362 | 2022-04-18 04:21:12 | Las Marias, Puerto Rico, US | |
2022-03-25 | China | Jiangxi | 1030 | 1 | 0 | 27.614 | 115.7221 | 2022-03-26 04:20:23 | Jiangxi, China | |||
2022-03-13 | US | Virginia | Covington | 51580 | 1030 | 25 | 0 | 37.7824656 | -79.98631446 | 2022-03-14 04:20:46 | Covington, Virginia, US | |
2022-03-12 | US | Virginia | Covington | 51580 | 1030 | 25 | 0 | 37.7824656 | -79.98631446 | 2022-03-13 04:20:49 | Covington, Virginia, US | |
2022-03-11 | US | Virginia | Covington | 51580 | 1030 | 25 | 0 | 37.7824656 | -79.98631446 | 2022-03-12 04:20:50 | Covington, Virginia, US | |
2022-03-01 | US | Alaska | Aleutians East | 2013 | 1030 | 3 | 0 | 55.32222414 | -161.9722021 | 2022-03-02 04:21:07 | Aleutians East, Alaska, US | |
2022-02-28 | US | Alaska | Aleutians East | 2013 | 1030 | 3 | 0 | 55.32222414 | -161.9722021 | 2022-03-01 04:21:09 | Aleutians East, Alaska, US | |
2022-02-22 | US | South Dakota | Deuel | 46039 | 1030 | 12 | 0 | 44.75994309 | -96.66943645 | 2022-02-23 04:21:09 | Deuel, South Dakota, US | |
2022-02-22 | China | Guangxi | 1030 | 2 | 0 | 23.8298 | 108.7881 | 2022-02-23 04:21:09 | Guangxi, China | |||
2022-02-15 | US | Nebraska | Antelope | 31003 | 1030 | 7 | 0 | 42.17695516 | -98.06662829999999 | 2022-02-16 04:21:10 | Antelope, Nebraska, US | |
2022-02-15 | US | Montana | Phillips | 30071 | 1030 | 28 | 0 | 48.25936577 | -107.9128511 | 2022-02-16 04:21:10 | Phillips, Montana, US | |
2022-02-14 | US | Texas | Brewster | 48043 | 1030 | 25 | 0 | 29.81008251 | -103.25203259999999 | 2022-02-15 04:21:09 | Brewster, Texas, US | |
2022-02-14 | US | Nebraska | Antelope | 31003 | 1030 | 7 | 0 | 42.17695516 | -98.06662829999999 | 2022-02-15 04:21:09 | Antelope, Nebraska, US | |
2022-02-14 | US | Missouri | Holt | 29087 | 1030 | 25 | 0 | 40.09799248 | -95.21638879999999 | 2022-02-15 04:21:09 | Holt, Missouri, US | |
2022-02-13 | US | Pennsylvania | Sullivan | 42113 | 1030 | 33 | 0 | 41.44634738 | -76.51246591 | 2022-02-14 04:20:51 | Sullivan, Pennsylvania, US | |
2022-02-12 | France | Saint Pierre and Miquelon | 1030 | 1 | 0 | 46.8852 | -56.3159 | 2022-02-13 04:21:00 | Saint Pierre and Miquelon, France | |||
2022-02-10 | US | Washington | San Juan | 53055 | 1030 | 1 | 0 | 48.60182783 | -122.96745 | 2022-02-11 04:21:09 | San Juan, Washington, US | |
2022-02-10 | US | Nebraska | Antelope | 31003 | 1030 | 7 | 0 | 42.17695516 | -98.06662829999999 | 2022-02-11 04:21:09 | Antelope, Nebraska, US | |
2022-02-09 | US | Washington | San Juan | 53055 | 1030 | 1 | 0 | 48.60182783 | -122.96745 | 2022-02-10 04:21:14 | San Juan, Washington, US | |
2022-01-29 | China | Tianjin | 1030 | 3 | 0 | 39.3054 | 117.323 | 2022-01-30 04:21:26 | Tianjin, China | |||
2022-01-23 | US | Nebraska | Howard | 31093 | 1030 | 10 | 0 | 41.2200529 | -98.5166499 | 2022-01-24 04:21:12 | Howard, Nebraska, US | |
2022-01-22 | US | Nebraska | Howard | 31093 | 1030 | 10 | 0 | 41.2200529 | -98.5166499 | 2022-01-23 04:21:13 | Howard, Nebraska, US | |
2022-01-21 | US | Nebraska | Howard | 31093 | 1030 | 10 | 0 | 41.2200529 | -98.5166499 | 2022-01-22 04:21:13 | Howard, Nebraska, US | |
2022-01-04 | US | Missouri | Dade | 29057 | 1030 | 38 | 0 | 37.431814 | -93.8503345 | 2022-01-05 04:21:59 | Dade, Missouri, US | |
2022-01-03 | US | South Dakota | Kingsbury | 46077 | 1030 | 20 | 0 | 44.36956169 | -97.4913945 | 2022-01-04 04:22:17 | Kingsbury, South Dakota, US | |
2022-01-03 | US | Illinois | Stark | 17175 | 1030 | 30 | 0 | 41.09309773 | -89.79745866 | 2022-01-04 04:22:17 | Stark, Illinois, US | |
2022-01-02 | US | Alabama | Choctaw | 1023 | 1030 | 30 | 0 | 32.02227341 | -88.26564429999998 | 2022-01-03 02:22:25 | Choctaw, Alabama, US | |
2021-12-27 | US | Texas | Jim Hogg | 48247 | 1030 | 20 | 0 | 27.04453923 | -98.69681870000001 | 2021-12-28 04:21:47 | Jim Hogg, Texas, US | |
2021-12-26 | US | Texas | Jim Hogg | 48247 | 1030 | 20 | 0 | 27.04453923 | -98.69681870000001 | 2021-12-27 04:21:58 | Jim Hogg, Texas, US | |
2021-12-23 | US | Georgia | Randolph | 13243 | 1030 | 44 | 0 | 31.76622818 | -84.75732369 | 2021-12-24 04:21:34 | Randolph, Georgia, US | |
2021-12-12 | US | Kansas | Phillips | 20147 | 1030 | 28 | 0 | 39.78465501 | -99.34668865 | 2021-12-13 04:22:02 | Phillips, Kansas, US | |
2021-12-11 | US | Kansas | Phillips | 20147 | 1030 | 28 | 0 | 39.78465501 | -99.34668865 | 2021-12-12 04:22:12 | Phillips, Kansas, US | |
2021-12-10 | US | Kansas | Phillips | 20147 | 1030 | 28 | 0 | 39.78465501 | -99.34668865 | 2021-12-11 04:22:45 | Phillips, Kansas, US | |
2021-12-02 | US | Puerto Rico | Orocovis | 72107 | 1030 | 0 | 0 | 18.215046 | -66.433604 | 2021-12-03 04:23:05 | Orocovis, Puerto Rico, US | |
2021-12-01 | US | Puerto Rico | Orocovis | 72107 | 1030 | 0 | 0 | 18.215046 | -66.433604 | 2021-12-02 04:22:37 | Orocovis, Puerto Rico, US | |
2021-11-30 | US | Puerto Rico | Orocovis | 72107 | 1030 | 0 | 0 | 18.215046 | -66.433604 | 2021-12-01 04:22:29 | Orocovis, Puerto Rico, US | |
2021-11-29 | US | Puerto Rico | Orocovis | 72107 | 1030 | 0 | 0 | 18.215046 | -66.433604 | 2021-11-30 04:22:53 | Orocovis, Puerto Rico, US | |
2021-11-28 | US | Puerto Rico | Orocovis | 72107 | 1030 | 0 | 0 | 18.215046 | -66.433604 | 2021-11-29 04:22:30 | Orocovis, Puerto Rico, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;