daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
421 rows where confirmed = 1616 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-21 | US | Oklahoma | Cotton | 40033 | 1616 | 36 | 0 | 34.28845626 | -98.37053567 | 2022-12-22 04:20:56 | Cotton, Oklahoma, US | |
2022-12-20 | US | Oklahoma | Cotton | 40033 | 1616 | 36 | 0 | 34.28845626 | -98.37053567 | 2022-12-21 04:21:03 | Cotton, Oklahoma, US | |
2022-12-19 | US | Oklahoma | Cotton | 40033 | 1616 | 36 | 0 | 34.28845626 | -98.37053567 | 2022-12-20 04:21:04 | Cotton, Oklahoma, US | |
2022-12-18 | US | Oklahoma | Cotton | 40033 | 1616 | 36 | 0 | 34.28845626 | -98.37053567 | 2022-12-19 04:21:03 | Cotton, Oklahoma, US | |
2022-12-17 | US | Oklahoma | Cotton | 40033 | 1616 | 36 | 0 | 34.28845626 | -98.37053567 | 2022-12-18 04:21:03 | Cotton, Oklahoma, US | |
2022-12-16 | US | Oklahoma | Cotton | 40033 | 1616 | 36 | 0 | 34.28845626 | -98.37053567 | 2022-12-17 04:21:04 | Cotton, Oklahoma, US | |
2022-12-15 | US | Oklahoma | Cotton | 40033 | 1616 | 36 | 0 | 34.28845626 | -98.37053567 | 2022-12-16 04:21:01 | Cotton, Oklahoma, US | |
2022-12-01 | China | Anhui | 1616 | 6 | 0 | 31.8257 | 117.2264 | 2022-12-02 04:21:07 | Anhui, China | |||
2022-10-10 | US | Michigan | Luce | 26095 | 1616 | 17 | 0 | 46.47227431 | -85.54471223 | 2022-10-11 04:23:05 | Luce, Michigan, US | |
2022-10-09 | US | Michigan | Luce | 26095 | 1616 | 17 | 0 | 46.47227431 | -85.54471223 | 2022-10-10 04:22:32 | Luce, Michigan, US | |
2022-10-08 | US | Michigan | Luce | 26095 | 1616 | 17 | 0 | 46.47227431 | -85.54471223 | 2022-10-09 04:21:16 | Luce, Michigan, US | |
2022-10-07 | US | Michigan | Luce | 26095 | 1616 | 17 | 0 | 46.47227431 | -85.54471223 | 2022-10-08 04:22:56 | Luce, Michigan, US | |
2022-10-06 | US | Michigan | Luce | 26095 | 1616 | 17 | 0 | 46.47227431 | -85.54471223 | 2022-10-07 04:23:08 | Luce, Michigan, US | |
2022-10-05 | US | Michigan | Luce | 26095 | 1616 | 17 | 0 | 46.47227431 | -85.54471223 | 2022-10-06 04:21:22 | Luce, Michigan, US | |
2022-10-04 | US | Michigan | Luce | 26095 | 1616 | 17 | 0 | 46.47227431 | -85.54471223 | 2022-10-05 04:23:06 | Luce, Michigan, US | |
2022-10-04 | US | Kansas | Mitchell | 20123 | 1616 | 25 | 0 | 39.39331582 | -98.20906732 | 2022-10-05 04:23:06 | Mitchell, Kansas, US | |
2022-10-03 | US | Kansas | Mitchell | 20123 | 1616 | 25 | 0 | 39.39331582 | -98.20906732 | 2022-10-04 04:22:55 | Mitchell, Kansas, US | |
2022-10-02 | US | Kansas | Mitchell | 20123 | 1616 | 25 | 0 | 39.39331582 | -98.20906732 | 2022-10-03 04:23:11 | Mitchell, Kansas, US | |
2022-10-01 | US | Kansas | Mitchell | 20123 | 1616 | 25 | 0 | 39.39331582 | -98.20906732 | 2022-10-02 04:21:23 | Mitchell, Kansas, US | |
2022-09-30 | US | Kansas | Mitchell | 20123 | 1616 | 25 | 0 | 39.39331582 | -98.20906732 | 2022-10-01 04:23:01 | Mitchell, Kansas, US | |
2022-09-29 | US | Kansas | Mitchell | 20123 | 1616 | 25 | 0 | 39.39331582 | -98.20906732 | 2022-09-30 04:23:09 | Mitchell, Kansas, US | |
2022-09-28 | US | Kansas | Mitchell | 20123 | 1616 | 25 | 0 | 39.39331582 | -98.20906732 | 2022-09-29 04:22:34 | Mitchell, Kansas, US | |
2022-09-22 | US | Missouri | Atchison | 29005 | 1616 | 23 | 0 | 40.43238737 | -95.42970639 | 2022-09-23 04:23:13 | Atchison, Missouri, US | |
2022-09-21 | US | Missouri | Atchison | 29005 | 1616 | 23 | 0 | 40.43238737 | -95.42970639 | 2022-09-22 04:22:56 | Atchison, Missouri, US | |
2022-09-20 | US | South Dakota | Moody | 46101 | 1616 | 28 | 0 | 44.02266214 | -96.67081159 | 2022-09-21 04:23:22 | Moody, South Dakota, US | |
2022-09-20 | US | Missouri | Atchison | 29005 | 1616 | 23 | 0 | 40.43238737 | -95.42970639 | 2022-09-21 04:23:22 | Atchison, Missouri, US | |
2022-09-19 | US | South Dakota | Moody | 46101 | 1616 | 28 | 0 | 44.02266214 | -96.67081159 | 2022-09-20 04:22:48 | Moody, South Dakota, US | |
2022-09-19 | US | Missouri | Atchison | 29005 | 1616 | 23 | 0 | 40.43238737 | -95.42970639 | 2022-09-20 04:22:48 | Atchison, Missouri, US | |
2022-09-18 | US | South Dakota | Moody | 46101 | 1616 | 28 | 0 | 44.02266214 | -96.67081159 | 2022-09-19 04:21:49 | Moody, South Dakota, US | |
2022-09-18 | US | Missouri | Atchison | 29005 | 1616 | 23 | 0 | 40.43238737 | -95.42970639 | 2022-09-19 04:21:49 | Atchison, Missouri, US | |
2022-09-17 | US | South Dakota | Moody | 46101 | 1616 | 28 | 0 | 44.02266214 | -96.67081159 | 2022-09-18 04:22:50 | Moody, South Dakota, US | |
2022-09-17 | US | Missouri | Atchison | 29005 | 1616 | 23 | 0 | 40.43238737 | -95.42970639 | 2022-09-18 04:22:50 | Atchison, Missouri, US | |
2022-09-16 | US | South Dakota | Moody | 46101 | 1616 | 28 | 0 | 44.02266214 | -96.67081159 | 2022-09-17 04:20:19 | Moody, South Dakota, US | |
2022-09-16 | US | Missouri | Atchison | 29005 | 1616 | 23 | 0 | 40.43238737 | -95.42970639 | 2022-09-17 04:20:19 | Atchison, Missouri, US | |
2022-09-15 | US | Texas | McCulloch | 48307 | 1616 | 49 | 0 | 31.1925468 | -99.34682807 | 2022-09-16 04:21:19 | McCulloch, Texas, US | |
2022-09-15 | US | South Dakota | Moody | 46101 | 1616 | 28 | 0 | 44.02266214 | -96.67081159 | 2022-09-16 04:21:19 | Moody, South Dakota, US | |
2022-09-15 | US | Idaho | Lemhi | 16059 | 1616 | 28 | 0 | 44.9438088 | -113.9309747 | 2022-09-16 04:21:19 | Lemhi, Idaho, US | |
2022-09-14 | US | Texas | McCulloch | 48307 | 1616 | 49 | 0 | 31.1925468 | -99.34682807 | 2022-09-15 04:21:02 | McCulloch, Texas, US | |
2022-09-14 | US | South Dakota | Moody | 46101 | 1616 | 28 | 0 | 44.02266214 | -96.67081159 | 2022-09-15 04:21:02 | Moody, South Dakota, US | |
2022-09-14 | US | Idaho | Lemhi | 16059 | 1616 | 28 | 0 | 44.9438088 | -113.9309747 | 2022-09-15 04:21:02 | Lemhi, Idaho, US | |
2022-08-30 | US | Texas | Jack | 48237 | 1616 | 30 | 0 | 33.23377248 | -98.17283469 | 2022-08-31 04:20:57 | Jack, Texas, US | |
2022-08-30 | US | Indiana | Ohio | 18115 | 1616 | 19 | 0 | 38.955305 | -84.96515993 | 2022-08-31 04:20:57 | Ohio, Indiana, US | |
2022-08-29 | US | Indiana | Ohio | 18115 | 1616 | 19 | 0 | 38.955305 | -84.96515993 | 2022-08-30 04:21:03 | Ohio, Indiana, US | |
2022-08-25 | US | Missouri | Dade | 29057 | 1616 | 43 | 0 | 37.431814 | -93.8503345 | 2022-08-26 04:21:02 | Dade, Missouri, US | |
2022-08-24 | US | Missouri | Dade | 29057 | 1616 | 43 | 0 | 37.431814 | -93.8503345 | 2022-08-25 04:21:13 | Dade, Missouri, US | |
2022-08-23 | US | Texas | Lynn | 48305 | 1616 | 39 | 0 | 33.17657705 | -101.8162849 | 2022-08-24 04:20:46 | Lynn, Texas, US | |
2022-08-23 | US | Missouri | Dade | 29057 | 1616 | 43 | 0 | 37.431814 | -93.8503345 | 2022-08-24 04:20:46 | Dade, Missouri, US | |
2022-08-22 | US | Missouri | Dade | 29057 | 1616 | 43 | 0 | 37.431814 | -93.8503345 | 2022-08-23 04:20:56 | Dade, Missouri, US | |
2022-08-21 | US | Missouri | Dade | 29057 | 1616 | 43 | 0 | 37.431814 | -93.8503345 | 2022-08-22 04:20:38 | Dade, Missouri, US | |
2022-08-20 | US | Missouri | Dade | 29057 | 1616 | 43 | 0 | 37.431814 | -93.8503345 | 2022-08-21 04:20:44 | Dade, Missouri, US | |
2022-08-19 | US | Missouri | Dade | 29057 | 1616 | 43 | 0 | 37.431814 | -93.8503345 | 2022-08-20 04:21:01 | Dade, Missouri, US | |
2022-07-03 | US | Virginia | Mathews | 51115 | 1616 | 27 | 0 | 37.44164146 | -76.34098896 | 2022-07-04 04:20:54 | Mathews, Virginia, US | |
2022-07-02 | US | Virginia | Mathews | 51115 | 1616 | 27 | 0 | 37.44164146 | -76.34098896 | 2022-07-03 04:20:59 | Mathews, Virginia, US | |
2022-07-01 | US | Virginia | Mathews | 51115 | 1616 | 27 | 0 | 37.44164146 | -76.34098896 | 2022-07-02 04:21:16 | Mathews, Virginia, US | |
2022-06-23 | US | Washington | Skamania | 53059 | 1616 | 12 | 0 | 46.02408726 | -121.9164403 | 2022-06-24 04:20:58 | Skamania, Washington, US | |
2022-06-22 | US | Washington | Skamania | 53059 | 1616 | 12 | 0 | 46.02408726 | -121.9164403 | 2022-06-23 04:20:55 | Skamania, Washington, US | |
2022-06-16 | US | Missouri | Shelby | 29205 | 1616 | 15 | 0 | 39.79742518 | -92.07634971 | 2022-06-17 04:20:56 | Shelby, Missouri, US | |
2022-06-15 | US | Missouri | Shelby | 29205 | 1616 | 15 | 0 | 39.79742518 | -92.07634971 | 2022-06-16 04:20:55 | Shelby, Missouri, US | |
2022-06-14 | US | Missouri | Shelby | 29205 | 1616 | 15 | 0 | 39.79742518 | -92.07634971 | 2022-06-15 04:20:54 | Shelby, Missouri, US | |
2022-06-13 | US | Missouri | Shelby | 29205 | 1616 | 15 | 0 | 39.79742518 | -92.07634971 | 2022-06-14 04:20:52 | Shelby, Missouri, US | |
2022-06-12 | US | Missouri | Shelby | 29205 | 1616 | 15 | 0 | 39.79742518 | -92.07634971 | 2022-06-13 04:21:14 | Shelby, Missouri, US | |
2022-06-11 | US | Missouri | Shelby | 29205 | 1616 | 15 | 0 | 39.79742518 | -92.07634971 | 2022-06-12 04:20:53 | Shelby, Missouri, US | |
2022-06-10 | US | Missouri | Shelby | 29205 | 1616 | 15 | 0 | 39.79742518 | -92.07634971 | 2022-06-11 04:21:01 | Shelby, Missouri, US | |
2022-06-09 | US | Missouri | Shannon | 29203 | 1616 | 40 | 0 | 37.15772072 | -91.40190382 | 2022-06-10 04:20:55 | Shannon, Missouri, US | |
2022-06-08 | US | Missouri | Shannon | 29203 | 1616 | 40 | 0 | 37.15772072 | -91.40190382 | 2022-06-09 04:20:54 | Shannon, Missouri, US | |
2022-06-07 | US | Missouri | Shannon | 29203 | 1616 | 40 | 0 | 37.15772072 | -91.40190382 | 2022-06-08 04:20:55 | Shannon, Missouri, US | |
2022-06-06 | US | Missouri | Shannon | 29203 | 1616 | 40 | 0 | 37.15772072 | -91.40190382 | 2022-06-07 04:21:08 | Shannon, Missouri, US | |
2022-06-05 | US | Missouri | Shannon | 29203 | 1616 | 40 | 0 | 37.15772072 | -91.40190382 | 2022-06-06 04:20:57 | Shannon, Missouri, US | |
2022-06-04 | US | Missouri | Shannon | 29203 | 1616 | 40 | 0 | 37.15772072 | -91.40190382 | 2022-06-05 04:20:55 | Shannon, Missouri, US | |
2022-06-03 | US | Missouri | Shannon | 29203 | 1616 | 40 | 0 | 37.15772072 | -91.40190382 | 2022-06-04 04:20:58 | Shannon, Missouri, US | |
2022-06-02 | US | Texas | Bailey | 48017 | 1616 | 39 | 0 | 34.06854817 | -102.8299707 | 2022-06-03 04:20:58 | Bailey, Texas, US | |
2022-05-29 | US | North Dakota | Bottineau | 38009 | 1616 | 26 | 0 | 48.79106111 | -100.8378166 | 2022-05-30 04:20:50 | Bottineau, North Dakota, US | |
2022-05-28 | US | North Dakota | Bottineau | 38009 | 1616 | 26 | 0 | 48.79106111 | -100.8378166 | 2022-05-29 04:20:53 | Bottineau, North Dakota, US | |
2022-02-17 | US | Minnesota | Mahnomen | 27087 | 1616 | 17 | 0 | 47.32557075 | -95.80921485 | 2022-02-18 04:21:04 | Mahnomen, Minnesota, US | |
2022-02-06 | US | Puerto Rico | Arroyo | 72015 | 1616 | 0 | 0 | 17.998457000000005 | -66.056546 | 2022-02-07 04:21:05 | Arroyo, Puerto Rico, US | |
2022-02-02 | US | Nebraska | Merrick | 31121 | 1616 | 15 | 0 | 41.16624273 | -98.0374887 | 2022-02-03 04:21:21 | Merrick, Nebraska, US | |
2022-02-01 | US | Alaska | Chugach | 2063 | 1616 | 9 | 0 | 61.16666 | -149.9 | 2022-02-02 04:21:09 | Chugach, Alaska, US | |
2022-01-31 | US | Alaska | Chugach | 2063 | 1616 | 9 | 0 | 61.16666 | -149.9 | 2022-02-01 04:21:11 | Chugach, Alaska, US | |
2022-01-27 | US | Arkansas | Dallas | 5039 | 1616 | 22 | 0 | 33.97042763 | -92.65167437 | 2022-01-28 04:21:09 | Dallas, Arkansas, US | |
2022-01-22 | US | Texas | Gaines | 48165 | 1616 | 73 | 0 | 32.74055318 | -102.6353295 | 2022-01-23 04:21:13 | Gaines, Texas, US | |
2022-01-12 | US | Wyoming | Platte | 56031 | 1616 | 37 | 0 | 42.13299116 | -104.96633100000001 | 2022-01-13 08:00:09 | Platte, Wyoming, US | |
2022-01-12 | US | Virginia | Buena Vista | 51530 | 1616 | 34 | 0 | 37.73484642 | -79.35296097 | 2022-01-13 08:00:09 | Buena Vista, Virginia, US | |
2022-01-09 | US | Texas | Mitchell | 48335 | 1616 | 44 | 0 | 32.30623474 | -100.9212058 | 2022-01-10 04:22:07 | Mitchell, Texas, US | |
2022-01-09 | US | Georgia | Lanier | 13173 | 1616 | 17 | 0 | 31.03828570000001 | -83.06472457 | 2022-01-10 04:22:07 | Lanier, Georgia, US | |
2022-01-08 | US | Georgia | Lanier | 13173 | 1616 | 17 | 0 | 31.03828570000001 | -83.06472457 | 2022-01-09 04:21:46 | Lanier, Georgia, US | |
2022-01-07 | US | Georgia | Lanier | 13173 | 1616 | 17 | 0 | 31.03828570000001 | -83.06472457 | 2022-01-08 04:21:53 | Lanier, Georgia, US | |
2022-01-06 | US | Georgia | Lanier | 13173 | 1616 | 17 | 0 | 31.03828570000001 | -83.06472457 | 2022-01-07 04:22:09 | Lanier, Georgia, US | |
2022-01-05 | US | Virginia | Essex | 51057 | 1616 | 21 | 0 | 37.93357639 | -76.94230311 | 2022-01-06 04:22:09 | Essex, Virginia, US | |
2022-01-05 | US | Georgia | Lanier | 13173 | 1616 | 17 | 0 | 31.03828570000001 | -83.06472457 | 2022-01-06 04:22:09 | Lanier, Georgia, US | |
2022-01-03 | US | Montana | Carbon | 30009 | 1616 | 23 | 0 | 45.22850116 | -109.0274047 | 2022-01-04 04:22:17 | Carbon, Montana, US | |
2022-01-02 | US | Minnesota | Murray | 27101 | 1616 | 14 | 0 | 44.02216709 | -95.76328482 | 2022-01-03 02:22:25 | Murray, Minnesota, US | |
2022-01-01 | US | Minnesota | Murray | 27101 | 1616 | 14 | 0 | 44.02216709 | -95.76328482 | 2022-01-02 04:20:52 | Murray, Minnesota, US | |
2021-12-31 | US | Minnesota | Murray | 27101 | 1616 | 14 | 0 | 44.02216709 | -95.76328482 | 2022-01-01 04:22:14 | Murray, Minnesota, US | |
2021-12-30 | US | Minnesota | Murray | 27101 | 1616 | 14 | 0 | 44.02216709 | -95.76328482 | 2021-12-31 04:21:50 | Murray, Minnesota, US | |
2021-12-29 | US | Indiana | Martin | 18101 | 1616 | 20 | 0 | 38.7099921 | -86.80373186 | 2021-12-30 04:21:25 | Martin, Indiana, US | |
2021-12-22 | US | Missouri | Howard | 29089 | 1616 | 19 | 0 | 39.1435761 | -92.69756691 | 2021-12-23 04:21:21 | Howard, Missouri, US | |
2021-12-21 | US | Kentucky | Livingston | 21139 | 1616 | 49 | 0 | 37.21137452 | -88.34797529 | 2021-12-22 04:21:54 | Livingston, Kentucky, US | |
2021-12-07 | US | Oklahoma | Blaine | 40011 | 1616 | 30 | 0 | 35.87518314 | -98.43307003 | 2021-12-08 04:22:46 | Blaine, Oklahoma, US | |
2021-12-06 | US | Oklahoma | Blaine | 40011 | 1616 | 30 | 0 | 35.87518314 | -98.43307003 | 2021-12-07 04:22:34 | Blaine, Oklahoma, US | |
2021-12-05 | US | Oklahoma | Blaine | 40011 | 1616 | 30 | 0 | 35.87518314 | -98.43307003 | 2021-12-06 04:22:34 | Blaine, Oklahoma, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;