daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
543 rows where confirmed = 1129 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-15 | US | Montana | Phillips | 30071 | 1129 | 29 | 0 | 48.25936577 | -107.9128511 | 2022-12-16 04:21:01 | Phillips, Montana, US | |
2022-12-14 | US | Montana | Phillips | 30071 | 1129 | 29 | 0 | 48.25936577 | -107.9128511 | 2022-12-15 04:20:58 | Phillips, Montana, US | |
2022-12-13 | US | Montana | Phillips | 30071 | 1129 | 29 | 0 | 48.25936577 | -107.9128511 | 2022-12-14 04:21:04 | Phillips, Montana, US | |
2022-12-12 | US | Montana | Phillips | 30071 | 1129 | 29 | 0 | 48.25936577 | -107.9128511 | 2022-12-11 23:21:04 | Phillips, Montana, US | |
2022-12-11 | US | Montana | Phillips | 30071 | 1129 | 29 | 0 | 48.25936577 | -107.9128511 | 2022-12-11 23:21:04 | Phillips, Montana, US | |
2022-12-10 | US | Montana | Phillips | 30071 | 1129 | 29 | 0 | 48.25936577 | -107.9128511 | 2022-12-11 04:20:50 | Phillips, Montana, US | |
2022-12-09 | US | Montana | Phillips | 30071 | 1129 | 29 | 0 | 48.25936577 | -107.9128511 | 2022-12-10 04:21:02 | Phillips, Montana, US | |
2022-12-08 | US | Montana | Phillips | 30071 | 1129 | 29 | 0 | 48.25936577 | -107.9128511 | 2022-12-09 04:21:05 | Phillips, Montana, US | |
2022-12-07 | US | Montana | Phillips | 30071 | 1129 | 29 | 0 | 48.25936577 | -107.9128511 | 2022-12-08 04:21:07 | Phillips, Montana, US | |
2022-12-06 | US | Montana | Phillips | 30071 | 1129 | 29 | 0 | 48.25936577 | -107.9128511 | 2022-12-07 04:20:58 | Phillips, Montana, US | |
2022-12-05 | US | Montana | Phillips | 30071 | 1129 | 29 | 0 | 48.25936577 | -107.9128511 | 2022-12-06 04:21:03 | Phillips, Montana, US | |
2022-12-04 | US | Montana | Phillips | 30071 | 1129 | 29 | 0 | 48.25936577 | -107.9128511 | 2022-12-05 04:20:58 | Phillips, Montana, US | |
2022-12-03 | US | Montana | Phillips | 30071 | 1129 | 29 | 0 | 48.25936577 | -107.9128511 | 2022-12-04 04:20:56 | Phillips, Montana, US | |
2022-12-02 | US | Montana | Phillips | 30071 | 1129 | 29 | 0 | 48.25936577 | -107.9128511 | 2022-12-03 04:21:02 | Phillips, Montana, US | |
2022-11-27 | US | Texas | Presidio | 48377 | 1129 | 41 | 0 | 29.99954402 | -104.2408079 | 2022-11-28 04:21:02 | Presidio, Texas, US | |
2022-11-26 | US | Texas | Presidio | 48377 | 1129 | 41 | 0 | 29.99954402 | -104.2408079 | 2022-11-27 04:21:05 | Presidio, Texas, US | |
2022-11-25 | US | Texas | Presidio | 48377 | 1129 | 41 | 0 | 29.99954402 | -104.2408079 | 2022-11-26 04:21:11 | Presidio, Texas, US | |
2022-11-24 | US | Texas | Presidio | 48377 | 1129 | 41 | 0 | 29.99954402 | -104.2408079 | 2022-11-25 04:21:06 | Presidio, Texas, US | |
2022-11-23 | US | Texas | Presidio | 48377 | 1129 | 41 | 0 | 29.99954402 | -104.2408079 | 2022-11-24 04:21:09 | Presidio, Texas, US | |
2022-11-22 | US | Texas | Presidio | 48377 | 1129 | 41 | 0 | 29.99954402 | -104.2408079 | 2022-11-23 04:21:06 | Presidio, Texas, US | |
2022-11-21 | US | Texas | Presidio | 48377 | 1129 | 41 | 0 | 29.99954402 | -104.2408079 | 2022-11-22 04:20:47 | Presidio, Texas, US | |
2022-10-18 | US | North Dakota | LaMoure | 38045 | 1129 | 20 | 0 | 46.45681054 | -98.53542355 | 2022-10-19 04:22:26 | LaMoure, North Dakota, US | |
2022-10-04 | US | North Dakota | Dunn | 38025 | 1129 | 8 | 0 | 47.35423935 | -102.6160468 | 2022-10-05 04:23:06 | Dunn, North Dakota, US | |
2022-10-03 | US | North Dakota | Dunn | 38025 | 1129 | 8 | 0 | 47.35423935 | -102.6160468 | 2022-10-04 04:22:55 | Dunn, North Dakota, US | |
2022-10-02 | US | North Dakota | Dunn | 38025 | 1129 | 8 | 0 | 47.35423935 | -102.6160468 | 2022-10-03 04:23:11 | Dunn, North Dakota, US | |
2022-10-01 | US | North Dakota | Dunn | 38025 | 1129 | 8 | 0 | 47.35423935 | -102.6160468 | 2022-10-02 04:21:23 | Dunn, North Dakota, US | |
2022-09-30 | US | North Dakota | Dunn | 38025 | 1129 | 8 | 0 | 47.35423935 | -102.6160468 | 2022-10-01 04:23:01 | Dunn, North Dakota, US | |
2022-09-29 | US | North Dakota | Dunn | 38025 | 1129 | 8 | 0 | 47.35423935 | -102.6160468 | 2022-09-30 04:23:09 | Dunn, North Dakota, US | |
2022-09-29 | US | Illinois | Pope | 17151 | 1129 | 9 | 0 | 37.41391284 | -88.56152109 | 2022-09-30 04:23:09 | Pope, Illinois, US | |
2022-09-28 | US | North Dakota | Dunn | 38025 | 1129 | 8 | 0 | 47.35423935 | -102.6160468 | 2022-09-29 04:22:34 | Dunn, North Dakota, US | |
2022-09-28 | US | Colorado | Gilpin | 8047 | 1129 | 6 | 0 | 39.85646523 | -105.5252597 | 2022-09-29 04:22:34 | Gilpin, Colorado, US | |
2022-09-27 | US | North Dakota | Dunn | 38025 | 1129 | 8 | 0 | 47.35423935 | -102.6160468 | 2022-09-28 04:23:01 | Dunn, North Dakota, US | |
2022-09-26 | US | North Dakota | Dunn | 38025 | 1129 | 8 | 0 | 47.35423935 | -102.6160468 | 2022-09-27 04:23:01 | Dunn, North Dakota, US | |
2022-09-25 | US | North Dakota | Dunn | 38025 | 1129 | 8 | 0 | 47.35423935 | -102.6160468 | 2022-09-26 04:20:52 | Dunn, North Dakota, US | |
2022-09-24 | US | North Dakota | Dunn | 38025 | 1129 | 8 | 0 | 47.35423935 | -102.6160468 | 2022-09-25 04:23:31 | Dunn, North Dakota, US | |
2022-09-23 | US | North Dakota | Dunn | 38025 | 1129 | 8 | 0 | 47.35423935 | -102.6160468 | 2022-09-24 04:21:40 | Dunn, North Dakota, US | |
2022-09-20 | US | North Carolina | Tyrrell | 37177 | 1129 | 9 | 0 | 35.87147226 | -76.17055253 | 2022-09-21 04:23:22 | Tyrrell, North Carolina, US | |
2022-09-19 | US | North Carolina | Tyrrell | 37177 | 1129 | 9 | 0 | 35.87147226 | -76.17055253 | 2022-09-20 04:22:48 | Tyrrell, North Carolina, US | |
2022-09-18 | US | North Carolina | Tyrrell | 37177 | 1129 | 9 | 0 | 35.87147226 | -76.17055253 | 2022-09-19 04:21:49 | Tyrrell, North Carolina, US | |
2022-09-17 | US | North Carolina | Tyrrell | 37177 | 1129 | 9 | 0 | 35.87147226 | -76.17055253 | 2022-09-18 04:22:50 | Tyrrell, North Carolina, US | |
2022-09-16 | US | North Carolina | Tyrrell | 37177 | 1129 | 9 | 0 | 35.87147226 | -76.17055253 | 2022-09-17 04:20:19 | Tyrrell, North Carolina, US | |
2022-09-15 | US | North Carolina | Tyrrell | 37177 | 1129 | 9 | 0 | 35.87147226 | -76.17055253 | 2022-09-16 04:21:19 | Tyrrell, North Carolina, US | |
2022-09-14 | US | North Carolina | Tyrrell | 37177 | 1129 | 9 | 0 | 35.87147226 | -76.17055253 | 2022-09-15 04:21:02 | Tyrrell, North Carolina, US | |
2022-08-24 | US | Colorado | Washington | 8121 | 1129 | 29 | 0 | 39.97015535 | -103.202587 | 2022-08-25 04:21:13 | Washington, Colorado, US | |
2022-08-23 | US | Louisiana | Unassigned | 90022 | 1129 | 0 | 0 | 32.83121059 | 0.0 | 2022-08-24 04:20:46 | Unassigned, Louisiana, US | |
2022-08-14 | US | North Dakota | Pierce | 38069 | 1129 | 32 | 0 | 48.24977025 | -99.96407787 | 2022-08-15 04:20:59 | Pierce, North Dakota, US | |
2022-08-13 | US | North Dakota | Pierce | 38069 | 1129 | 32 | 0 | 48.24977025 | -99.96407787 | 2022-08-14 04:20:55 | Pierce, North Dakota, US | |
2022-07-27 | US | Texas | San Augustine | 48405 | 1129 | 45 | 0 | 31.39457611 | -94.17000399 | 2022-07-28 04:20:56 | San Augustine, Texas, US | |
2022-07-25 | US | Virginia | Rappahannock | 51157 | 1129 | 10 | 0 | 38.68295619 | -78.15826963 | 2022-07-26 04:20:58 | Rappahannock, Virginia, US | |
2022-07-07 | US | Texas | Brewster | 48043 | 1129 | 31 | 0 | 29.81008251 | -103.2520326 | 2022-07-08 04:20:56 | Brewster, Texas, US | |
2022-06-26 | US | Texas | Concho | 48095 | 1129 | 11 | 0 | 31.32635934 | -99.86473038 | 2022-06-27 04:21:00 | Concho, Texas, US | |
2022-06-26 | US | Idaho | Boise | 16015 | 1129 | 14 | 0 | 43.98829931 | -115.7309284 | 2022-06-27 04:21:00 | Boise, Idaho, US | |
2022-06-25 | US | Idaho | Boise | 16015 | 1129 | 14 | 0 | 43.98829931 | -115.7309284 | 2022-06-26 04:21:02 | Boise, Idaho, US | |
2022-06-24 | US | Idaho | Boise | 16015 | 1129 | 14 | 0 | 43.98829931 | -115.7309284 | 2022-06-25 04:20:57 | Boise, Idaho, US | |
2022-06-07 | US | Pennsylvania | Sullivan | 42113 | 1129 | 36 | 0 | 41.44634738 | -76.51246591 | 2022-06-08 04:20:55 | Sullivan, Pennsylvania, US | |
2022-06-06 | US | Pennsylvania | Sullivan | 42113 | 1129 | 36 | 0 | 41.44634738 | -76.51246591 | 2022-06-07 04:21:08 | Sullivan, Pennsylvania, US | |
2022-06-05 | US | Pennsylvania | Sullivan | 42113 | 1129 | 36 | 0 | 41.44634738 | -76.51246591 | 2022-06-06 04:20:57 | Sullivan, Pennsylvania, US | |
2022-06-04 | US | Pennsylvania | Sullivan | 42113 | 1129 | 36 | 0 | 41.44634738 | -76.51246591 | 2022-06-05 04:20:55 | Sullivan, Pennsylvania, US | |
2022-06-03 | US | Pennsylvania | Sullivan | 42113 | 1129 | 36 | 0 | 41.44634738 | -76.51246591 | 2022-06-04 04:20:58 | Sullivan, Pennsylvania, US | |
2022-06-02 | US | Pennsylvania | Sullivan | 42113 | 1129 | 36 | 0 | 41.44634738 | -76.51246591 | 2022-06-03 04:20:58 | Sullivan, Pennsylvania, US | |
2022-06-01 | US | Pennsylvania | Sullivan | 42113 | 1129 | 36 | 0 | 41.44634738 | -76.51246591 | 2022-06-02 05:20:39 | Sullivan, Pennsylvania, US | |
2022-05-26 | US | Virginia | Surry | 51181 | 1129 | 20 | 0 | 37.11781893 | -76.88450012 | 2022-05-27 04:20:56 | Surry, Virginia, US | |
2022-04-20 | US | Vermont | Unassigned | 90050 | 1129 | 1 | 0 | 44.85627605 | 0.0 | 2022-04-21 04:20:46 | Unassigned, Vermont, US | |
2022-04-20 | China | Jiangxi | 1129 | 1 | 0 | 27.614 | 115.7221 | 2022-04-21 04:20:46 | Jiangxi, China | |||
2022-03-29 | US | Iowa | Ringgold | 19159 | 1129 | 33 | 0 | 40.73518949 | -94.24368535 | 2022-03-30 04:20:45 | Ringgold, Iowa, US | |
2022-03-28 | US | Iowa | Ringgold | 19159 | 1129 | 33 | 0 | 40.73518949 | -94.24368535 | 2022-03-29 04:20:46 | Ringgold, Iowa, US | |
2022-03-27 | US | Iowa | Ringgold | 19159 | 1129 | 33 | 0 | 40.73518949 | -94.24368535 | 2022-03-28 04:20:33 | Ringgold, Iowa, US | |
2022-03-27 | US | Idaho | Lewis | 16061 | 1129 | 29 | 0 | 46.23315327 | -116.434146 | 2022-03-28 04:20:33 | Lewis, Idaho, US | |
2022-03-26 | US | Iowa | Ringgold | 19159 | 1129 | 33 | 0 | 40.73518949 | -94.24368535 | 2022-03-27 04:20:47 | Ringgold, Iowa, US | |
2022-03-26 | US | Idaho | Lewis | 16061 | 1129 | 29 | 0 | 46.23315327 | -116.434146 | 2022-03-27 04:20:47 | Lewis, Idaho, US | |
2022-03-25 | US | Iowa | Ringgold | 19159 | 1129 | 33 | 0 | 40.73518949 | -94.24368535 | 2022-03-26 04:20:23 | Ringgold, Iowa, US | |
2022-03-25 | US | Idaho | Lewis | 16061 | 1129 | 29 | 0 | 46.23315327 | -116.434146 | 2022-03-26 04:20:23 | Lewis, Idaho, US | |
2022-03-24 | US | Iowa | Ringgold | 19159 | 1129 | 33 | 0 | 40.73518949 | -94.24368535 | 2022-03-25 04:20:46 | Ringgold, Iowa, US | |
2022-03-24 | US | Idaho | Lewis | 16061 | 1129 | 29 | 0 | 46.23315327 | -116.434146 | 2022-03-25 04:20:46 | Lewis, Idaho, US | |
2022-03-23 | US | Iowa | Ringgold | 19159 | 1129 | 33 | 0 | 40.73518949 | -94.24368535 | 2022-03-24 04:20:43 | Ringgold, Iowa, US | |
2022-03-23 | US | Idaho | Lewis | 16061 | 1129 | 29 | 0 | 46.23315327 | -116.434146 | 2022-03-24 04:20:43 | Lewis, Idaho, US | |
2022-03-22 | US | Idaho | Lewis | 16061 | 1129 | 29 | 0 | 46.23315327 | -116.434146 | 2022-03-23 04:20:48 | Lewis, Idaho, US | |
2022-03-21 | US | Idaho | Lewis | 16061 | 1129 | 29 | 0 | 46.23315327 | -116.434146 | 2022-03-22 04:20:54 | Lewis, Idaho, US | |
2022-03-20 | US | Idaho | Lewis | 16061 | 1129 | 29 | 0 | 46.23315327 | -116.434146 | 2022-03-21 04:20:50 | Lewis, Idaho, US | |
2022-03-19 | US | Idaho | Lewis | 16061 | 1129 | 29 | 0 | 46.23315327 | -116.434146 | 2022-03-20 04:20:45 | Lewis, Idaho, US | |
2022-03-18 | US | Idaho | Lewis | 16061 | 1129 | 29 | 0 | 46.23315327 | -116.434146 | 2022-03-19 04:20:47 | Lewis, Idaho, US | |
2022-03-17 | US | Texas | Donley | 48129 | 1129 | 26 | 0 | 34.96517499 | -100.8140093 | 2022-03-18 04:20:55 | Donley, Texas, US | |
2022-03-17 | US | Idaho | Lewis | 16061 | 1129 | 29 | 0 | 46.23315327 | -116.434146 | 2022-03-18 04:20:55 | Lewis, Idaho, US | |
2022-03-16 | US | Idaho | Lewis | 16061 | 1129 | 29 | 0 | 46.23315327 | -116.434146 | 2022-03-17 04:20:56 | Lewis, Idaho, US | |
2022-03-15 | US | Idaho | Lewis | 16061 | 1129 | 29 | 0 | 46.23315327 | -116.434146 | 2022-03-16 04:20:50 | Lewis, Idaho, US | |
2022-03-14 | US | Idaho | Lewis | 16061 | 1129 | 29 | 0 | 46.23315327 | -116.434146 | 2022-03-15 04:20:47 | Lewis, Idaho, US | |
2022-02-27 | US | Nebraska | Howard | 31093 | 1129 | 10 | 0 | 41.2200529 | -98.5166499 | 2022-02-28 04:21:05 | Howard, Nebraska, US | |
2022-02-27 | US | Kansas | Stafford | 20185 | 1129 | 26 | 0 | 38.03100851 | -98.71762001 | 2022-02-28 04:21:05 | Stafford, Kansas, US | |
2022-02-27 | China | Shandong | 1129 | 7 | 0 | 36.3427 | 118.1498 | 2022-02-28 04:21:05 | Shandong, China | |||
2022-02-26 | US | Nebraska | Howard | 31093 | 1129 | 10 | 0 | 41.2200529 | -98.5166499 | 2022-02-27 04:21:04 | Howard, Nebraska, US | |
2022-02-26 | US | Kansas | Stafford | 20185 | 1129 | 26 | 0 | 38.03100851 | -98.71762001 | 2022-02-27 04:21:04 | Stafford, Kansas, US | |
2022-02-25 | US | Nebraska | Howard | 31093 | 1129 | 10 | 0 | 41.2200529 | -98.5166499 | 2022-02-26 04:21:12 | Howard, Nebraska, US | |
2022-02-25 | US | Kansas | Stafford | 20185 | 1129 | 26 | 0 | 38.03100851 | -98.71762001 | 2022-02-26 04:21:12 | Stafford, Kansas, US | |
2022-02-16 | US | Wyoming | Hot Springs | 56017 | 1129 | 14 | 0 | 43.71930657 | -108.44231740000001 | 2022-02-17 04:20:56 | Hot Springs, Wyoming, US | |
2022-02-15 | US | Illinois | Henderson | 17071 | 1129 | 17 | 0 | 40.81908672 | -90.92491462 | 2022-02-16 04:21:10 | Henderson, Illinois, US | |
2022-02-13 | US | Kentucky | Fulton | 21075 | 1129 | 23 | 0 | 36.55238827 | -89.20140068 | 2022-02-14 04:20:51 | Fulton, Kentucky, US | |
2022-02-12 | US | Kentucky | Fulton | 21075 | 1129 | 23 | 0 | 36.55238827 | -89.20140068 | 2022-02-13 04:21:00 | Fulton, Kentucky, US | |
2022-02-11 | US | Texas | Martin | 48317 | 1129 | 26 | 0 | 32.30600051 | -101.9513518 | 2022-02-12 04:21:06 | Martin, Texas, US | |
2022-02-11 | US | Kentucky | Fulton | 21075 | 1129 | 23 | 0 | 36.55238827 | -89.20140068 | 2022-02-12 04:21:06 | Fulton, Kentucky, US | |
2022-02-08 | US | Nebraska | Polk | 31143 | 1129 | 9 | 0 | 41.18813488 | -97.56630712 | 2022-02-09 04:21:04 | Polk, Nebraska, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;