daily_reports (view)

⚠️ This table has been renamed. Use johns_hopkins_csse_daily_reports instead.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

445 rows where confirmed = 1320 sorted by day descending

✎ View and edit SQL

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-27 US Virginia Rappahannock 51157 1320 13 0   38.68295619 -78.15826963 2022-12-28 04:21:04 Rappahannock, Virginia, US
2022-12-26 US Virginia Rappahannock 51157 1320 13 0   38.68295619 -78.15826963 2022-12-27 04:21:07 Rappahannock, Virginia, US
2022-12-19 US Alaska Aleutians East 2013 1320 4 0   55.32222414 -161.9722021 2022-12-20 04:21:04 Aleutians East, Alaska, US
2022-12-18 US Alaska Aleutians East 2013 1320 4 0   55.32222414 -161.9722021 2022-12-19 04:21:03 Aleutians East, Alaska, US
2022-12-17 US Alaska Aleutians East 2013 1320 4 0   55.32222414 -161.9722021 2022-12-18 04:21:03 Aleutians East, Alaska, US
2022-12-16 US Alaska Aleutians East 2013 1320 4 0   55.32222414 -161.9722021 2022-12-17 04:21:04 Aleutians East, Alaska, US
2022-12-15 US Alaska Aleutians East 2013 1320 4 0   55.32222414 -161.9722021 2022-12-16 04:21:01 Aleutians East, Alaska, US
2022-12-14 US Alaska Aleutians East 2013 1320 4 0   55.32222414 -161.9722021 2022-12-15 04:20:58 Aleutians East, Alaska, US
2022-12-13 US New Mexico Guadalupe 35019 1320 18 0   34.86319296 -104.790669 2022-12-14 04:21:04 Guadalupe, New Mexico, US
2022-12-13 US Georgia Talbot 13263 1320 34 0   32.69642758 -84.53351366 2022-12-14 04:21:04 Talbot, Georgia, US
2022-12-13 US Alaska Aleutians East 2013 1320 4 0   55.32222414 -161.9722021 2022-12-14 04:21:04 Aleutians East, Alaska, US
2022-12-12 US Georgia Talbot 13263 1320 34 0   32.69642758 -84.53351366 2022-12-13 04:21:01 Talbot, Georgia, US
2022-12-11 US Georgia Talbot 13263 1320 34 0   32.69642758 -84.53351366 2022-12-12 04:21:01 Talbot, Georgia, US
2022-12-10 US Georgia Talbot 13263 1320 34 0   32.69642758 -84.53351366 2022-12-11 04:20:50 Talbot, Georgia, US
2022-12-09 US Georgia Talbot 13263 1320 34 0   32.69642758 -84.53351366 2022-12-10 04:21:02 Talbot, Georgia, US
2022-12-08 US Georgia Talbot 13263 1320 34 0   32.69642758 -84.53351366 2022-12-09 04:21:05 Talbot, Georgia, US
2022-12-06 US Pennsylvania Sullivan 42113 1320 38 0   41.44634738 -76.51246591 2022-12-07 04:20:58 Sullivan, Pennsylvania, US
2022-12-06 US Nevada Lander 32015 1320 21 0   39.9332233 -117.0397075 2022-12-07 04:20:58 Lander, Nevada, US
2022-12-05 US Pennsylvania Sullivan 42113 1320 38 0   41.44634738 -76.51246591 2022-12-06 04:21:03 Sullivan, Pennsylvania, US
2022-12-05 US Nevada Lander 32015 1320 21 0   39.9332233 -117.0397075 2022-12-06 04:21:03 Lander, Nevada, US
2022-12-04 US Pennsylvania Sullivan 42113 1320 38 0   41.44634738 -76.51246591 2022-12-05 04:20:58 Sullivan, Pennsylvania, US
2022-12-04 US Nevada Lander 32015 1320 21 0   39.9332233 -117.0397075 2022-12-05 04:20:58 Lander, Nevada, US
2022-12-03 US Pennsylvania Sullivan 42113 1320 38 0   41.44634738 -76.51246591 2022-12-04 04:20:56 Sullivan, Pennsylvania, US
2022-12-03 US Nevada Lander 32015 1320 21 0   39.9332233 -117.0397075 2022-12-04 04:20:56 Lander, Nevada, US
2022-12-02 US Pennsylvania Sullivan 42113 1320 38 0   41.44634738 -76.51246591 2022-12-03 04:21:02 Sullivan, Pennsylvania, US
2022-12-02 US Nevada Lander 32015 1320 21 0   39.9332233 -117.0397075 2022-12-03 04:21:02 Lander, Nevada, US
2022-12-01 US Virginia Surry 51181 1320 22 0   37.11781893 -76.88450012 2022-12-02 04:21:07 Surry, Virginia, US
2022-12-01 US Pennsylvania Sullivan 42113 1320 38 0   41.44634738 -76.51246591 2022-12-02 04:21:07 Sullivan, Pennsylvania, US
2022-12-01 US Nevada Lander 32015 1320 21 0   39.9332233 -117.0397075 2022-12-02 04:21:07 Lander, Nevada, US
2022-11-30 US Virginia Surry 51181 1320 22 0   37.11781893 -76.88450012 2022-12-01 04:21:03 Surry, Virginia, US
2022-11-30 US Pennsylvania Sullivan 42113 1320 38 0   41.44634738 -76.51246591 2022-12-01 04:21:03 Sullivan, Pennsylvania, US
2022-11-30 US Nevada Lander 32015 1320 21 0   39.9332233 -117.0397075 2022-12-01 04:21:03 Lander, Nevada, US
2022-10-25 US Kansas Stafford 20185 1320 31 0   38.03100851 -98.71762001 2022-10-26 04:22:19 Stafford, Kansas, US
2022-10-24 US Kansas Stafford 20185 1320 31 0   38.03100851 -98.71762001 2022-10-25 04:21:53 Stafford, Kansas, US
2022-10-23 US Kansas Stafford 20185 1320 31 0   38.03100851 -98.71762001 2022-10-24 04:22:29 Stafford, Kansas, US
2022-10-22 US Kansas Stafford 20185 1320 31 0   38.03100851 -98.71762001 2022-10-23 04:22:46 Stafford, Kansas, US
2022-10-21 US Kansas Stafford 20185 1320 31 0   38.03100851 -98.71762001 2022-10-22 04:22:53 Stafford, Kansas, US
2022-10-20 US Kansas Stafford 20185 1320 31 0   38.03100851 -98.71762001 2022-10-21 04:22:23 Stafford, Kansas, US
2022-10-19 US Kansas Stafford 20185 1320 31 0   38.03100851 -98.71762001 2022-10-20 04:22:59 Stafford, Kansas, US
2022-09-18 US Louisiana Cameron 22023 1320 10 0   29.87592238 -93.19310676 2022-09-19 04:21:49 Cameron, Louisiana, US
2022-09-18 US Illinois Putnam 17155 1320 10 0   41.2013541 -89.2869272 2022-09-19 04:21:49 Putnam, Illinois, US
2022-09-17 US Louisiana Cameron 22023 1320 10 0   29.87592238 -93.19310676 2022-09-18 04:22:50 Cameron, Louisiana, US
2022-09-17 US Illinois Putnam 17155 1320 10 0   41.2013541 -89.2869272 2022-09-18 04:22:50 Putnam, Illinois, US
2022-09-16 US Louisiana Cameron 22023 1320 10 0   29.87592238 -93.19310676 2022-09-17 04:20:19 Cameron, Louisiana, US
2022-09-16 US Illinois Putnam 17155 1320 10 0   41.2013541 -89.2869272 2022-09-17 04:20:19 Putnam, Illinois, US
2022-09-15 US Louisiana Cameron 22023 1320 10 0   29.87592238 -93.19310676 2022-09-16 04:21:19 Cameron, Louisiana, US
2022-09-14 US Louisiana Cameron 22023 1320 10 0   29.87592238 -93.19310676 2022-09-15 04:21:02 Cameron, Louisiana, US
2022-09-13 US Louisiana Cameron 22023 1320 10 0   29.87592238 -93.19310676 2022-09-14 04:20:44 Cameron, Louisiana, US
2022-08-10 US Texas Martin 48317 1320 26 0   32.30600051 -101.9513518 2022-08-11 04:20:49 Martin, Texas, US
2022-08-03 US Texas San Saba 48411 1320 35 0   31.1577796 -98.81758731 2022-08-04 04:20:58 San Saba, Texas, US
2022-07-19 US South Dakota Day 46037 1320 35 0   45.367281 -97.60737498 2022-07-20 04:20:59 Day, South Dakota, US
2022-07-18 US South Dakota Day 46037 1320 35 0   45.367281 -97.60737498 2022-07-19 04:20:58 Day, South Dakota, US
2022-07-17 US South Dakota Day 46037 1320 35 0   45.367281 -97.60737498 2022-07-18 04:20:59 Day, South Dakota, US
2022-07-16 US South Dakota Day 46037 1320 35 0   45.367281 -97.60737498 2022-07-17 04:21:15 Day, South Dakota, US
2022-07-15 US South Dakota Day 46037 1320 35 0   45.367281 -97.60737498 2022-07-16 04:21:05 Day, South Dakota, US
2022-07-14 US South Dakota Day 46037 1320 35 0   45.367281 -97.60737498 2022-07-15 04:20:53 Day, South Dakota, US
2022-07-13 US South Dakota Day 46037 1320 35 0   45.367281 -97.60737498 2022-07-14 04:20:57 Day, South Dakota, US
2022-07-06 US Texas Crane 48103 1320 24 0   31.43052248 -102.5143314 2022-07-07 04:20:55 Crane, Texas, US
2022-07-06 US Oregon Wallowa 41063 1320 16 0   45.57894064 -117.183538 2022-07-07 04:20:55 Wallowa, Oregon, US
2022-06-21 US Illinois Scott 17171 1320 12 0   39.6429169 -90.47814431 2022-06-22 04:20:54 Scott, Illinois, US
2022-06-13 US Illinois Alexander 17003 1320 15 0   37.18049267 -89.32910838 2022-06-14 04:20:52 Alexander, Illinois, US
2022-06-12 US Illinois Alexander 17003 1320 15 0   37.18049267 -89.32910838 2022-06-13 04:21:14 Alexander, Illinois, US
2022-06-11 US Illinois Alexander 17003 1320 15 0   37.18049267 -89.32910838 2022-06-12 04:20:53 Alexander, Illinois, US
2022-06-10 US Illinois Alexander 17003 1320 15 0   37.18049267 -89.32910838 2022-06-11 04:21:01 Alexander, Illinois, US
2022-06-09 US Illinois Alexander 17003 1320 15 0   37.18049267 -89.32910838 2022-06-10 04:20:55 Alexander, Illinois, US
2022-06-05 US Texas McCulloch 48307 1320 47 0   31.1925468 -99.34682807 2022-06-06 04:20:57 McCulloch, Texas, US
2022-06-04 US Texas McCulloch 48307 1320 47 0   31.1925468 -99.34682807 2022-06-05 04:20:55 McCulloch, Texas, US
2022-05-23 US Virginia Norton 51720 1320 22 0   36.93357076 -82.62750411 2022-05-24 04:20:57 Norton, Virginia, US
2022-05-21 US Virginia Norton 51720 1320 22 0   36.93357076 -82.62750411 2022-05-22 04:20:52 Norton, Virginia, US
2022-05-20 US Virginia Norton 51720 1320 22 0   36.93357076 -82.62750411 2022-05-21 04:20:58 Norton, Virginia, US
2022-05-17 US Texas Yoakum 48501 1320 42 0   33.17320212 -102.8276433 2022-05-18 04:20:50 Yoakum, Texas, US
2022-05-15 US North Dakota McHenry 38049 1320 31 0   48.23104458 -100.6324822 2022-05-16 04:20:47 McHenry, North Dakota, US
2022-05-14 US North Dakota McHenry 38049 1320 31 0   48.23104458 -100.6324822 2022-05-15 04:20:53 McHenry, North Dakota, US
2022-05-13 US North Dakota McHenry 38049 1320 31 0   48.23104458 -100.6324822 2022-05-14 04:20:48 McHenry, North Dakota, US
2022-04-26 US South Dakota Kingsbury 46077 1320 21 0   44.36956169 -97.4913945 2022-04-27 04:20:52 Kingsbury, South Dakota, US
2022-04-25 US South Dakota Kingsbury 46077 1320 21 0   44.36956169 -97.4913945 2022-04-26 04:20:51 Kingsbury, South Dakota, US
2022-04-24 US South Dakota Kingsbury 46077 1320 21 0   44.36956169 -97.4913945 2022-04-25 04:20:56 Kingsbury, South Dakota, US
2022-04-23 US South Dakota Kingsbury 46077 1320 21 0   44.36956169 -97.4913945 2022-04-24 04:20:56 Kingsbury, South Dakota, US
2022-04-22 US South Dakota Kingsbury 46077 1320 21 0   44.36956169 -97.4913945 2022-04-23 04:20:50 Kingsbury, South Dakota, US
2022-04-21 US South Dakota Kingsbury 46077 1320 21 0   44.36956169 -97.4913945 2022-04-22 04:20:45 Kingsbury, South Dakota, US
2022-04-20 US South Dakota Kingsbury 46077 1320 21 0   44.36956169 -97.4913945 2022-04-21 04:20:46 Kingsbury, South Dakota, US
2022-03-11 Tonga       1320 0 0   -21.179000000000002 -175.1982 2022-03-12 04:20:50 Tonga
2022-03-10 Tonga       1320 0 0   -21.179000000000002 -175.1982 2022-03-11 04:20:50 Tonga
2022-02-01 US South Dakota Tripp 46123 1320 22 0   43.34459388 -99.8854891 2022-02-02 04:21:09 Tripp, South Dakota, US
2022-01-31 US Missouri Dade 29057 1320 38 0   37.431814 -93.8503345 2022-02-01 04:21:11 Dade, Missouri, US
2022-01-26 US South Dakota Spink 46115 1320 32 0   44.93837606 -98.34626602 2022-01-27 04:21:19 Spink, South Dakota, US
2022-01-23 US North Dakota Dickey 38021 1320 38 0   46.11017712 -98.50490079999999 2022-01-24 04:21:12 Dickey, North Dakota, US
2022-01-11 US Minnesota Wilkin 27167 1320 19 0   46.35721532 -96.4684375 2022-01-12 04:21:44 Wilkin, Minnesota, US
2022-01-11 US Iowa Pocahontas 19151 1320 25 0   42.73420133 -94.67862564 2022-01-12 04:21:44 Pocahontas, Iowa, US
2022-01-10 US Iowa Pocahontas 19151 1320 25 0   42.73420133 -94.67862564 2022-01-11 04:22:01 Pocahontas, Iowa, US
2022-01-10 US Colorado Clear Creek 8019 1320 10 0   39.68864463 -105.6463118 2022-01-11 04:22:01 Clear Creek, Colorado, US
2022-01-09 US Iowa Pocahontas 19151 1320 25 0   42.73420133 -94.67862564 2022-01-10 04:22:07 Pocahontas, Iowa, US
2022-01-08 US Iowa Pocahontas 19151 1320 25 0   42.73420133 -94.67862564 2022-01-09 04:21:46 Pocahontas, Iowa, US
2022-01-07 US Iowa Pocahontas 19151 1320 25 0   42.73420133 -94.67862564 2022-01-08 04:21:53 Pocahontas, Iowa, US
2022-01-06 US Iowa Pocahontas 19151 1320 25 0   42.73420133 -94.67862564 2022-01-07 04:22:09 Pocahontas, Iowa, US
2022-01-05 US Iowa Pocahontas 19151 1320 25 0   42.73420133 -94.67862564 2022-01-06 04:22:09 Pocahontas, Iowa, US
2021-12-31 US Texas Coleman 48083 1320 59 0   31.76736834 -99.45240766 2022-01-01 04:22:14 Coleman, Texas, US
2021-12-30 US Virginia Williamsburg 51830 1320 13 0   37.28131268 -76.70905141 2021-12-31 04:21:50 Williamsburg, Virginia, US
2021-12-26 US Minnesota Lac qui Parle 27073 1320 26 0   44.9973857 -96.17488219 2021-12-27 04:21:58 Lac qui Parle, Minnesota, US
2021-12-25 US Minnesota Lac qui Parle 27073 1320 26 0   44.9973857 -96.17488219 2021-12-26 04:21:50 Lac qui Parle, Minnesota, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;