daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
245 rows where confirmed = 2857 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-20 | US | Iowa | Franklin | 19069 | 2857 | 48 | 0 | 42.73270384 | -93.26256925 | 2022-12-21 04:21:03 | Franklin, Iowa, US | |
2022-12-19 | US | Missouri | Howard | 29089 | 2857 | 34 | 0 | 39.1435761 | -92.69756691 | 2022-12-20 04:21:04 | Howard, Missouri, US | |
2022-12-19 | US | Iowa | Franklin | 19069 | 2857 | 48 | 0 | 42.73270384 | -93.26256925 | 2022-12-20 04:21:04 | Franklin, Iowa, US | |
2022-12-18 | US | Missouri | Howard | 29089 | 2857 | 34 | 0 | 39.1435761 | -92.69756691 | 2022-12-19 04:21:03 | Howard, Missouri, US | |
2022-12-18 | US | Iowa | Franklin | 19069 | 2857 | 48 | 0 | 42.73270384 | -93.26256925 | 2022-12-19 04:21:03 | Franklin, Iowa, US | |
2022-12-17 | US | Missouri | Howard | 29089 | 2857 | 34 | 0 | 39.1435761 | -92.69756691 | 2022-12-18 04:21:03 | Howard, Missouri, US | |
2022-12-17 | US | Iowa | Franklin | 19069 | 2857 | 48 | 0 | 42.73270384 | -93.26256925 | 2022-12-18 04:21:03 | Franklin, Iowa, US | |
2022-12-16 | US | Missouri | Howard | 29089 | 2857 | 34 | 0 | 39.1435761 | -92.69756691 | 2022-12-17 04:21:04 | Howard, Missouri, US | |
2022-12-16 | US | Iowa | Franklin | 19069 | 2857 | 48 | 0 | 42.73270384 | -93.26256925 | 2022-12-17 04:21:04 | Franklin, Iowa, US | |
2022-12-15 | US | Missouri | Howard | 29089 | 2857 | 34 | 0 | 39.1435761 | -92.69756691 | 2022-12-16 04:21:01 | Howard, Missouri, US | |
2022-12-15 | US | Iowa | Franklin | 19069 | 2857 | 48 | 0 | 42.73270384 | -93.26256925 | 2022-12-16 04:21:01 | Franklin, Iowa, US | |
2022-12-14 | US | Missouri | Howard | 29089 | 2857 | 34 | 0 | 39.1435761 | -92.69756691 | 2022-12-15 04:20:58 | Howard, Missouri, US | |
2022-12-14 | US | Iowa | Franklin | 19069 | 2857 | 48 | 0 | 42.73270384 | -93.26256925 | 2022-12-15 04:20:58 | Franklin, Iowa, US | |
2022-12-13 | US | Missouri | Howard | 29089 | 2857 | 34 | 0 | 39.1435761 | -92.69756691 | 2022-12-14 04:21:04 | Howard, Missouri, US | |
2022-10-15 | US | Puerto Rico | Ceiba | 72037 | 2857 | 0 | 0 | 18.251818 | -65.666416 | 2022-10-16 04:22:39 | Ceiba, Puerto Rico, US | |
2022-10-14 | US | Puerto Rico | Ceiba | 72037 | 2857 | 0 | 0 | 18.251818 | -65.666416 | 2022-10-15 04:22:00 | Ceiba, Puerto Rico, US | |
2022-10-10 | US | West Virginia | Ritchie | 54085 | 2857 | 32 | 0 | 39.18094587 | -81.06356878 | 2022-10-11 04:23:05 | Ritchie, West Virginia, US | |
2022-10-09 | US | West Virginia | Ritchie | 54085 | 2857 | 32 | 0 | 39.18094587 | -81.06356878 | 2022-10-10 04:22:32 | Ritchie, West Virginia, US | |
2022-10-08 | US | West Virginia | Ritchie | 54085 | 2857 | 32 | 0 | 39.18094587 | -81.06356878 | 2022-10-09 04:21:16 | Ritchie, West Virginia, US | |
2022-10-07 | US | West Virginia | Ritchie | 54085 | 2857 | 32 | 0 | 39.18094587 | -81.06356878 | 2022-10-08 04:22:56 | Ritchie, West Virginia, US | |
2022-10-05 | US | Arkansas | Perry | 5105 | 2857 | 39 | 0 | 34.9459153 | -92.94372564 | 2022-10-06 04:21:22 | Perry, Arkansas, US | |
2022-10-02 | US | Idaho | Teton | 16081 | 2857 | 9 | 0 | 43.75303583 | -111.2056773 | 2022-10-03 04:23:11 | Teton, Idaho, US | |
2022-10-01 | US | Idaho | Teton | 16081 | 2857 | 9 | 0 | 43.75303583 | -111.2056773 | 2022-10-02 04:21:23 | Teton, Idaho, US | |
2022-09-30 | US | Idaho | Teton | 16081 | 2857 | 9 | 0 | 43.75303583 | -111.2056773 | 2022-10-01 04:23:01 | Teton, Idaho, US | |
2022-09-06 | US | Indiana | Brown | 18013 | 2857 | 63 | 0 | 39.19605589 | -86.22868909 | 2022-09-07 04:20:59 | Brown, Indiana, US | |
2022-09-05 | US | Indiana | Brown | 18013 | 2857 | 63 | 0 | 39.19605589 | -86.22868909 | 2022-09-06 04:21:02 | Brown, Indiana, US | |
2022-09-04 | US | Indiana | Brown | 18013 | 2857 | 63 | 0 | 39.19605589 | -86.22868909 | 2022-09-05 04:21:01 | Brown, Indiana, US | |
2022-09-03 | US | Indiana | Brown | 18013 | 2857 | 63 | 0 | 39.19605589 | -86.22868909 | 2022-09-04 04:21:22 | Brown, Indiana, US | |
2022-09-02 | US | Indiana | Brown | 18013 | 2857 | 63 | 0 | 39.19605589 | -86.22868909 | 2022-09-03 04:21:04 | Brown, Indiana, US | |
2022-08-26 | US | New Jersey | Unassigned | 90034 | 2857 | 0 | 0 | 41.13891592 | 0.0 | 2022-08-27 04:20:57 | Unassigned, New Jersey, US | |
2022-08-25 | US | Tennessee | Houston | 47083 | 2857 | 62 | 0 | 36.28872054 | -87.71878828 | 2022-08-26 04:21:02 | Houston, Tennessee, US | |
2022-08-15 | US | Wyoming | Big Horn | 56003 | 2857 | 64 | 0 | 44.52405055 | -107.9960365 | 2022-08-16 04:20:58 | Big Horn, Wyoming, US | |
2022-08-14 | US | Wyoming | Big Horn | 56003 | 2857 | 64 | 0 | 44.52405055 | -107.9960365 | 2022-08-15 04:20:59 | Big Horn, Wyoming, US | |
2022-08-13 | US | Wyoming | Big Horn | 56003 | 2857 | 64 | 0 | 44.52405055 | -107.9960365 | 2022-08-14 04:20:55 | Big Horn, Wyoming, US | |
2022-08-12 | US | Wyoming | Big Horn | 56003 | 2857 | 64 | 0 | 44.52405055 | -107.9960365 | 2022-08-13 04:20:52 | Big Horn, Wyoming, US | |
2022-08-11 | US | Wyoming | Big Horn | 56003 | 2857 | 64 | 0 | 44.52405055 | -107.9960365 | 2022-08-12 04:20:54 | Big Horn, Wyoming, US | |
2022-08-10 | US | Wyoming | Big Horn | 56003 | 2857 | 64 | 0 | 44.52405055 | -107.9960365 | 2022-08-11 04:20:49 | Big Horn, Wyoming, US | |
2022-08-10 | US | Virginia | Charlotte | 51037 | 2857 | 45 | 0 | 37.01909701 | -78.66314092 | 2022-08-11 04:20:49 | Charlotte, Virginia, US | |
2022-08-09 | US | Wyoming | Big Horn | 56003 | 2857 | 64 | 0 | 44.52405055 | -107.9960365 | 2022-08-10 04:20:57 | Big Horn, Wyoming, US | |
2022-08-09 | US | Iowa | Lyon | 19119 | 2857 | 52 | 0 | 43.38107862 | -96.20926845 | 2022-08-10 04:20:57 | Lyon, Iowa, US | |
2022-08-08 | US | Iowa | Lyon | 19119 | 2857 | 52 | 0 | 43.38107862 | -96.20926845 | 2022-08-09 04:20:34 | Lyon, Iowa, US | |
2022-08-07 | US | Iowa | Lyon | 19119 | 2857 | 52 | 0 | 43.38107862 | -96.20926845 | 2022-08-08 04:21:08 | Lyon, Iowa, US | |
2022-08-06 | US | Iowa | Lyon | 19119 | 2857 | 52 | 0 | 43.38107862 | -96.20926845 | 2022-08-07 04:20:54 | Lyon, Iowa, US | |
2022-08-05 | US | Iowa | Lyon | 19119 | 2857 | 52 | 0 | 43.38107862 | -96.20926845 | 2022-08-06 04:20:56 | Lyon, Iowa, US | |
2022-08-04 | US | Iowa | Lyon | 19119 | 2857 | 52 | 0 | 43.38107862 | -96.20926845 | 2022-08-05 04:20:52 | Lyon, Iowa, US | |
2022-08-03 | US | Iowa | Lyon | 19119 | 2857 | 52 | 0 | 43.38107862 | -96.20926845 | 2022-08-04 04:20:58 | Lyon, Iowa, US | |
2022-08-03 | China | Shandong | 2857 | 7 | 0 | 36.3427 | 118.1498 | 2022-08-04 04:20:58 | Shandong, China | |||
2022-07-12 | France | Saint Pierre and Miquelon | 2857 | 1 | 0 | 46.8852 | -56.3159 | 2022-07-13 04:20:58 | Saint Pierre and Miquelon, France | |||
2022-07-11 | France | Saint Pierre and Miquelon | 2857 | 1 | 0 | 46.8852 | -56.3159 | 2022-07-12 04:20:51 | Saint Pierre and Miquelon, France | |||
2022-07-10 | France | Saint Pierre and Miquelon | 2857 | 1 | 0 | 46.8852 | -56.3159 | 2022-07-11 04:20:46 | Saint Pierre and Miquelon, France | |||
2022-07-09 | France | Saint Pierre and Miquelon | 2857 | 1 | 0 | 46.8852 | -56.3159 | 2022-07-10 04:20:54 | Saint Pierre and Miquelon, France | |||
2022-07-08 | France | Saint Pierre and Miquelon | 2857 | 1 | 0 | 46.8852 | -56.3159 | 2022-07-09 04:20:59 | Saint Pierre and Miquelon, France | |||
2022-05-15 | US | Virginia | Lexington | 51678 | 2857 | 40 | 0 | 37.78258621 | -79.44262866 | 2022-05-16 04:20:47 | Lexington, Virginia, US | |
2022-05-14 | US | Virginia | Lexington | 51678 | 2857 | 40 | 0 | 37.78258621 | -79.44262866 | 2022-05-15 04:20:53 | Lexington, Virginia, US | |
2022-05-13 | US | Virginia | Lexington | 51678 | 2857 | 40 | 0 | 37.78258621 | -79.44262866 | 2022-05-14 04:20:48 | Lexington, Virginia, US | |
2022-05-12 | US | Missouri | Barton | 29011 | 2857 | 52 | 0 | 37.50207671 | -94.34757022 | 2022-05-13 04:20:51 | Barton, Missouri, US | |
2022-05-11 | US | Missouri | Barton | 29011 | 2857 | 52 | 0 | 37.50207671 | -94.34757022 | 2022-05-12 04:20:54 | Barton, Missouri, US | |
2022-05-10 | US | Missouri | Barton | 29011 | 2857 | 52 | 0 | 37.50207671 | -94.34757022 | 2022-05-11 04:20:48 | Barton, Missouri, US | |
2022-05-09 | US | Missouri | Barton | 29011 | 2857 | 52 | 0 | 37.50207671 | -94.34757022 | 2022-05-10 04:20:50 | Barton, Missouri, US | |
2022-05-08 | US | Missouri | Barton | 29011 | 2857 | 52 | 0 | 37.50207671 | -94.34757022 | 2022-05-09 04:20:54 | Barton, Missouri, US | |
2022-05-07 | US | Missouri | Barton | 29011 | 2857 | 52 | 0 | 37.50207671 | -94.34757022 | 2022-05-08 04:20:49 | Barton, Missouri, US | |
2022-05-06 | US | Missouri | Barton | 29011 | 2857 | 52 | 0 | 37.50207671 | -94.34757022 | 2022-05-07 04:21:09 | Barton, Missouri, US | |
2022-04-17 | US | Texas | Callahan | 48059 | 2857 | 72 | 0 | 32.29760619 | -99.37326312 | 2022-04-18 04:21:12 | Callahan, Texas, US | |
2022-04-16 | US | Texas | Callahan | 48059 | 2857 | 72 | 0 | 32.29760619 | -99.37326312 | 2022-04-17 04:20:59 | Callahan, Texas, US | |
2022-04-15 | US | Texas | Callahan | 48059 | 2857 | 72 | 0 | 32.29760619 | -99.37326312 | 2022-04-16 04:20:48 | Callahan, Texas, US | |
2022-04-14 | US | Texas | Callahan | 48059 | 2857 | 72 | 0 | 32.29760619 | -99.37326312 | 2022-04-15 04:20:57 | Callahan, Texas, US | |
2022-03-27 | US | Kentucky | Metcalfe | 21169 | 2857 | 61 | 0 | 36.99459295 | -85.63123699 | 2022-03-28 04:20:33 | Metcalfe, Kentucky, US | |
2022-03-26 | US | Kentucky | Metcalfe | 21169 | 2857 | 61 | 0 | 36.99459295 | -85.63123699 | 2022-03-27 04:20:47 | Metcalfe, Kentucky, US | |
2022-03-25 | US | Kentucky | Metcalfe | 21169 | 2857 | 61 | 0 | 36.99459295 | -85.63123699 | 2022-03-26 04:20:23 | Metcalfe, Kentucky, US | |
2022-03-24 | US | Kentucky | Metcalfe | 21169 | 2857 | 61 | 0 | 36.99459295 | -85.63123699 | 2022-03-25 04:20:46 | Metcalfe, Kentucky, US | |
2022-03-23 | US | Kentucky | Metcalfe | 21169 | 2857 | 61 | 0 | 36.99459295 | -85.63123699 | 2022-03-24 04:20:43 | Metcalfe, Kentucky, US | |
2022-03-22 | US | Kentucky | Metcalfe | 21169 | 2857 | 61 | 0 | 36.99459295 | -85.63123699 | 2022-03-23 04:20:48 | Metcalfe, Kentucky, US | |
2022-03-21 | US | Kentucky | Metcalfe | 21169 | 2857 | 61 | 0 | 36.99459295 | -85.63123699 | 2022-03-22 04:20:54 | Metcalfe, Kentucky, US | |
2022-02-10 | US | Alabama | Coosa | 1037 | 2857 | 53 | 0 | 32.93690146 | -86.24847739 | 2022-02-11 04:21:09 | Coosa, Alabama, US | |
2022-02-06 | US | North Dakota | Barnes | 38003 | 2857 | 45 | 0 | 46.93579637 | -98.06605978 | 2022-02-07 04:21:05 | Barnes, North Dakota, US | |
2022-02-01 | US | Colorado | Archuleta | 8007 | 2857 | 13 | 0 | 37.19474156 | -107.04768670000001 | 2022-02-02 04:21:09 | Archuleta, Colorado, US | |
2022-01-21 | US | Puerto Rico | Anasco | 72011 | 2857 | 0 | 0 | 18.287985 | -67.120611 | 2022-01-22 04:21:13 | Anasco, Puerto Rico, US | |
2022-01-17 | US | Georgia | Brooks | 13027 | 2857 | 76 | 0 | 30.83922642 | -83.58303423 | 2022-01-18 04:21:04 | Brooks, Georgia, US | |
2022-01-13 | US | Missouri | Madison | 29123 | 2857 | 45 | 0 | 37.47865134 | -90.34671429999999 | 2022-01-14 04:21:54 | Madison, Missouri, US | |
2022-01-13 | US | Kentucky | Monroe | 21171 | 2857 | 69 | 0 | 36.71225341 | -85.71596443 | 2022-01-14 04:21:54 | Monroe, Kentucky, US | |
2022-01-11 | US | Illinois | Massac | 17127 | 2857 | 61 | 0 | 37.22078441 | -88.71036614 | 2022-01-12 04:21:44 | Massac, Illinois, US | |
2021-12-29 | US | Utah | San Juan | 49037 | 2857 | 45 | 0 | 37.62762978 | -109.80337140000002 | 2021-12-30 04:21:25 | San Juan, Utah, US | |
2021-12-28 | US | Iowa | Page | 19145 | 2857 | 38 | 0 | 40.7393172 | -95.1497813 | 2021-12-29 03:21:43 | Page, Iowa, US | |
2021-12-27 | US | Virginia | Buckingham | 51029 | 2857 | 41 | 0 | 37.57242268 | -78.52518834 | 2021-12-28 04:21:47 | Buckingham, Virginia, US | |
2021-12-27 | US | Iowa | Page | 19145 | 2857 | 38 | 0 | 40.7393172 | -95.1497813 | 2021-12-28 04:21:47 | Page, Iowa, US | |
2021-12-26 | US | West Virginia | Taylor | 54091 | 2857 | 50 | 0 | 39.33602617 | -80.0421439 | 2021-12-27 04:21:58 | Taylor, West Virginia, US | |
2021-12-26 | US | Iowa | Page | 19145 | 2857 | 38 | 0 | 40.7393172 | -95.1497813 | 2021-12-27 04:21:58 | Page, Iowa, US | |
2021-12-25 | US | West Virginia | Taylor | 54091 | 2857 | 50 | 0 | 39.33602617 | -80.0421439 | 2021-12-26 04:21:50 | Taylor, West Virginia, US | |
2021-12-25 | US | Iowa | Page | 19145 | 2857 | 38 | 0 | 40.7393172 | -95.1497813 | 2021-12-26 04:21:50 | Page, Iowa, US | |
2021-12-25 | US | Arkansas | Madison | 5087 | 2857 | 44 | 0 | 36.01038185 | -93.72524943 | 2021-12-26 04:21:50 | Madison, Arkansas, US | |
2021-12-24 | US | West Virginia | Taylor | 54091 | 2857 | 50 | 0 | 39.33602617 | -80.0421439 | 2021-12-25 04:21:37 | Taylor, West Virginia, US | |
2021-12-24 | US | Iowa | Page | 19145 | 2857 | 38 | 0 | 40.7393172 | -95.1497813 | 2021-12-25 04:21:37 | Page, Iowa, US | |
2021-12-23 | US | West Virginia | Taylor | 54091 | 2857 | 50 | 0 | 39.33602617 | -80.0421439 | 2021-12-24 04:21:34 | Taylor, West Virginia, US | |
2021-12-23 | US | Iowa | Page | 19145 | 2857 | 38 | 0 | 40.7393172 | -95.1497813 | 2021-12-24 04:21:34 | Page, Iowa, US | |
2021-12-22 | US | Iowa | Page | 19145 | 2857 | 38 | 0 | 40.7393172 | -95.1497813 | 2021-12-23 04:21:21 | Page, Iowa, US | |
2021-12-21 | US | Puerto Rico | Humacao | 72069 | 2857 | 0 | 0 | 18.145211 | -65.810174 | 2021-12-22 04:21:54 | Humacao, Puerto Rico, US | |
2021-12-14 | US | Missouri | Moniteau | 29135 | 2857 | 46 | 0 | 38.63571781 | -92.57976951 | 2021-12-15 03:22:16 | Moniteau, Missouri, US | |
2021-12-13 | US | Missouri | Moniteau | 29135 | 2857 | 46 | 0 | 38.63571781 | -92.57976951 | 2021-12-14 04:22:38 | Moniteau, Missouri, US | |
2021-12-11 | US | Kentucky | Mason | 21161 | 2857 | 78 | 0 | 38.59471935 | -83.82151043 | 2021-12-12 04:22:12 | Mason, Kentucky, US | |
2021-12-01 | US | Maine | Waldo | 23027 | 2857 | 36 | 0 | 44.4858305 | -69.12061935 | 2021-12-02 04:22:37 | Waldo, Maine, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;