daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
316 rows where confirmed = 1979 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-07 | US | Arkansas | Newton | 5101 | 1979 | 51 | 0 | 35.91947491 | -93.21612969 | 2022-12-08 04:21:07 | Newton, Arkansas, US | |
2022-11-30 | US | Oklahoma | Coal | 40029 | 1979 | 25 | 0 | 34.58840127 | -96.29798747 | 2022-12-01 04:21:03 | Coal, Oklahoma, US | |
2022-11-29 | US | Oklahoma | Coal | 40029 | 1979 | 25 | 0 | 34.58840127 | -96.29798747 | 2022-11-30 04:21:07 | Coal, Oklahoma, US | |
2022-11-28 | US | Oklahoma | Coal | 40029 | 1979 | 25 | 0 | 34.58840127 | -96.29798747 | 2022-11-29 04:21:05 | Coal, Oklahoma, US | |
2022-11-27 | US | Oklahoma | Coal | 40029 | 1979 | 25 | 0 | 34.58840127 | -96.29798747 | 2022-11-28 04:21:02 | Coal, Oklahoma, US | |
2022-11-26 | US | Oklahoma | Coal | 40029 | 1979 | 25 | 0 | 34.58840127 | -96.29798747 | 2022-11-27 04:21:05 | Coal, Oklahoma, US | |
2022-11-25 | US | Oklahoma | Coal | 40029 | 1979 | 25 | 0 | 34.58840127 | -96.29798747 | 2022-11-26 04:21:11 | Coal, Oklahoma, US | |
2022-11-24 | US | Oklahoma | Coal | 40029 | 1979 | 25 | 0 | 34.58840127 | -96.29798747 | 2022-11-25 04:21:06 | Coal, Oklahoma, US | |
2022-10-20 | US | Texas | Delta | 48119 | 1979 | 27 | 0 | 33.38570922 | -95.66921122 | 2022-10-21 04:22:23 | Delta, Texas, US | |
2022-10-19 | US | Texas | Delta | 48119 | 1979 | 27 | 0 | 33.38570922 | -95.66921122 | 2022-10-20 04:22:59 | Delta, Texas, US | |
2022-10-18 | US | Texas | Delta | 48119 | 1979 | 27 | 0 | 33.38570922 | -95.66921122 | 2022-10-19 04:22:26 | Delta, Texas, US | |
2022-10-17 | US | Texas | Delta | 48119 | 1979 | 27 | 0 | 33.38570922 | -95.66921122 | 2022-10-18 04:22:42 | Delta, Texas, US | |
2022-10-16 | US | Texas | Delta | 48119 | 1979 | 27 | 0 | 33.38570922 | -95.66921122 | 2022-10-17 04:20:31 | Delta, Texas, US | |
2022-10-15 | US | Texas | Delta | 48119 | 1979 | 27 | 0 | 33.38570922 | -95.66921122 | 2022-10-16 04:22:39 | Delta, Texas, US | |
2022-10-14 | US | Texas | Delta | 48119 | 1979 | 27 | 0 | 33.38570922 | -95.66921122 | 2022-10-15 04:22:00 | Delta, Texas, US | |
2022-09-28 | US | Arkansas | Dallas | 5039 | 1979 | 37 | 0 | 33.97042763 | -92.65167437 | 2022-09-29 04:22:34 | Dallas, Arkansas, US | |
2022-08-22 | US | Colorado | Rio Blanco | 8103 | 1979 | 13 | 0 | 39.97913541 | -108.2179009 | 2022-08-23 04:20:56 | Rio Blanco, Colorado, US | |
2022-08-21 | US | Colorado | Rio Blanco | 8103 | 1979 | 13 | 0 | 39.97913541 | -108.2179009 | 2022-08-22 04:20:38 | Rio Blanco, Colorado, US | |
2022-08-20 | US | Colorado | Rio Blanco | 8103 | 1979 | 13 | 0 | 39.97913541 | -108.2179009 | 2022-08-21 04:20:44 | Rio Blanco, Colorado, US | |
2022-08-19 | US | Colorado | Rio Blanco | 8103 | 1979 | 13 | 0 | 39.97913541 | -108.2179009 | 2022-08-20 04:21:01 | Rio Blanco, Colorado, US | |
2022-08-18 | US | Texas | Stephens | 48429 | 1979 | 50 | 0 | 32.73553157 | -98.83631615 | 2022-08-19 04:20:54 | Stephens, Texas, US | |
2022-08-18 | US | Colorado | Rio Blanco | 8103 | 1979 | 13 | 0 | 39.97913541 | -108.2179009 | 2022-08-19 04:20:54 | Rio Blanco, Colorado, US | |
2022-08-16 | US | Texas | Winkler | 48495 | 1979 | 34 | 0 | 31.85008651 | -103.0485163 | 2022-08-17 04:20:59 | Winkler, Texas, US | |
2022-07-25 | US | Texas | Crosby | 48107 | 1979 | 45 | 0 | 33.61431553 | -101.3000364 | 2022-07-26 04:20:58 | Crosby, Texas, US | |
2022-07-21 | US | Virginia | Williamsburg | 51830 | 1979 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-07-22 04:21:15 | Williamsburg, Virginia, US | |
2022-06-30 | US | West Virginia | Calhoun | 54013 | 1979 | 15 | 0 | 38.84315422 | -81.11934872 | 2022-07-01 04:21:10 | Calhoun, West Virginia, US | |
2022-06-21 | US | Texas | Hamilton | 48193 | 1979 | 33 | 0 | 31.70470573 | -98.11083887 | 2022-06-22 04:20:54 | Hamilton, Texas, US | |
2022-06-14 | US | South Dakota | Turner | 46125 | 1979 | 62 | 0 | 43.3109081 | -97.14865776 | 2022-06-15 04:20:54 | Turner, South Dakota, US | |
2022-06-13 | US | South Dakota | Turner | 46125 | 1979 | 62 | 0 | 43.3109081 | -97.14865776 | 2022-06-14 04:20:52 | Turner, South Dakota, US | |
2022-06-12 | US | South Dakota | Turner | 46125 | 1979 | 62 | 0 | 43.3109081 | -97.14865776 | 2022-06-13 04:21:14 | Turner, South Dakota, US | |
2022-06-11 | US | South Dakota | Turner | 46125 | 1979 | 62 | 0 | 43.3109081 | -97.14865776 | 2022-06-12 04:20:53 | Turner, South Dakota, US | |
2022-06-11 | US | Arkansas | Prairie | 5117 | 1979 | 42 | 0 | 34.83624419 | -91.55162157 | 2022-06-12 04:20:53 | Prairie, Arkansas, US | |
2022-06-11 | China | Tianjin | 1979 | 3 | 0 | 39.3054 | 117.323 | 2022-06-12 04:20:53 | Tianjin, China | |||
2022-06-10 | US | South Dakota | Turner | 46125 | 1979 | 62 | 0 | 43.3109081 | -97.14865776 | 2022-06-11 04:21:01 | Turner, South Dakota, US | |
2022-06-10 | US | Arkansas | Prairie | 5117 | 1979 | 42 | 0 | 34.83624419 | -91.55162157 | 2022-06-11 04:21:01 | Prairie, Arkansas, US | |
2022-06-09 | US | South Dakota | Turner | 46125 | 1979 | 62 | 0 | 43.3109081 | -97.14865776 | 2022-06-10 04:20:55 | Turner, South Dakota, US | |
2022-06-09 | US | Arkansas | Prairie | 5117 | 1979 | 42 | 0 | 34.83624419 | -91.55162157 | 2022-06-10 04:20:55 | Prairie, Arkansas, US | |
2022-06-08 | US | South Dakota | Turner | 46125 | 1979 | 62 | 0 | 43.3109081 | -97.14865776 | 2022-06-09 04:20:54 | Turner, South Dakota, US | |
2022-06-08 | US | Arkansas | Prairie | 5117 | 1979 | 42 | 0 | 34.83624419 | -91.55162157 | 2022-06-09 04:20:54 | Prairie, Arkansas, US | |
2022-05-08 | US | West Virginia | Pendleton | 54071 | 1979 | 22 | 0 | 38.68314479 | -79.35084086 | 2022-05-09 04:20:54 | Pendleton, West Virginia, US | |
2022-05-07 | US | West Virginia | Pendleton | 54071 | 1979 | 22 | 0 | 38.68314479 | -79.35084086 | 2022-05-08 04:20:49 | Pendleton, West Virginia, US | |
2022-05-06 | US | West Virginia | Pendleton | 54071 | 1979 | 22 | 0 | 38.68314479 | -79.35084086 | 2022-05-07 04:21:09 | Pendleton, West Virginia, US | |
2022-05-01 | US | Wisconsin | Pepin | 55091 | 1979 | 18 | 0 | 44.58307413 | -91.99949611 | 2022-05-02 04:21:10 | Pepin, Wisconsin, US | |
2022-04-30 | US | Wisconsin | Pepin | 55091 | 1979 | 18 | 0 | 44.58307413 | -91.99949611 | 2022-05-01 04:20:57 | Pepin, Wisconsin, US | |
2022-04-29 | US | Wisconsin | Pepin | 55091 | 1979 | 18 | 0 | 44.58307413 | -91.99949611 | 2022-04-30 04:21:05 | Pepin, Wisconsin, US | |
2022-04-16 | China | Sichuan | 1979 | 3 | 0 | 30.6171 | 102.7103 | 2022-04-17 04:20:59 | Sichuan, China | |||
2022-03-30 | US | Virginia | Falls Church | 51610 | 1979 | 16 | 0 | 38.88485255 | -77.17560759 | 2022-03-31 04:20:56 | Falls Church, Virginia, US | |
2022-03-10 | US | Minnesota | Pipestone | 27117 | 1979 | 34 | 0 | 44.02301619 | -96.25841142 | 2022-03-11 04:20:50 | Pipestone, Minnesota, US | |
2022-03-09 | US | Minnesota | Pipestone | 27117 | 1979 | 34 | 0 | 44.02301619 | -96.25841142 | 2022-03-10 04:20:48 | Pipestone, Minnesota, US | |
2022-03-08 | US | Minnesota | Pipestone | 27117 | 1979 | 34 | 0 | 44.02301619 | -96.25841142 | 2022-03-09 04:20:59 | Pipestone, Minnesota, US | |
2022-03-07 | US | Minnesota | Pipestone | 27117 | 1979 | 34 | 0 | 44.02301619 | -96.25841142 | 2022-03-08 04:20:54 | Pipestone, Minnesota, US | |
2022-02-28 | US | West Virginia | Pocahontas | 54075 | 1979 | 27 | 0 | 38.32758728 | -80.00993811 | 2022-03-01 04:21:09 | Pocahontas, West Virginia, US | |
2022-02-22 | US | Tennessee | Hancock | 47067 | 1979 | 31 | 0 | 36.52692871 | -83.22375847 | 2022-02-23 04:21:09 | Hancock, Tennessee, US | |
2022-02-22 | US | Puerto Rico | Rincon | 72117 | 1979 | 0 | 0 | 18.335442999999998 | -67.23174 | 2022-02-23 04:21:09 | Rincon, Puerto Rico, US | |
2022-02-21 | US | Puerto Rico | Rincon | 72117 | 1979 | 0 | 0 | 18.335442999999998 | -67.23174 | 2022-02-22 04:21:01 | Rincon, Puerto Rico, US | |
2022-02-21 | US | Montana | Carbon | 30009 | 1979 | 28 | 0 | 45.22850116 | -109.0274047 | 2022-02-22 04:21:01 | Carbon, Montana, US | |
2022-02-20 | US | Montana | Carbon | 30009 | 1979 | 28 | 0 | 45.22850116 | -109.0274047 | 2022-02-21 04:21:05 | Carbon, Montana, US | |
2022-02-20 | US | Kentucky | Crittenden | 21055 | 1979 | 42 | 0 | 37.35839237 | -88.08826090000002 | 2022-02-21 04:21:05 | Crittenden, Kentucky, US | |
2022-02-19 | US | Montana | Carbon | 30009 | 1979 | 28 | 0 | 45.22850116 | -109.0274047 | 2022-02-20 04:21:00 | Carbon, Montana, US | |
2022-02-19 | US | Kentucky | Crittenden | 21055 | 1979 | 42 | 0 | 37.35839237 | -88.08826090000002 | 2022-02-20 04:21:00 | Crittenden, Kentucky, US | |
2022-02-18 | US | Montana | Carbon | 30009 | 1979 | 28 | 0 | 45.22850116 | -109.0274047 | 2022-02-19 04:21:11 | Carbon, Montana, US | |
2022-02-18 | US | Kentucky | Crittenden | 21055 | 1979 | 42 | 0 | 37.35839237 | -88.08826090000002 | 2022-02-19 04:21:11 | Crittenden, Kentucky, US | |
2022-02-16 | US | Minnesota | Lake | 27075 | 1979 | 27 | 0 | 47.64270764 | -91.44557998 | 2022-02-17 04:20:56 | Lake, Minnesota, US | |
2022-02-08 | US | Mississippi | Humphreys | 28053 | 1979 | 40 | 0 | 33.12825718 | -90.52252707 | 2022-02-09 04:21:04 | Humphreys, Mississippi, US | |
2022-02-07 | US | Nebraska | Holt | 31089 | 1979 | 16 | 0 | 42.45522056 | -98.78402558 | 2022-02-08 04:21:15 | Holt, Nebraska, US | |
2022-02-02 | US | Puerto Rico | Adjuntas | 72001 | 1979 | 0 | 0 | 18.180117000000006 | -66.754367 | 2022-02-03 04:21:21 | Adjuntas, Puerto Rico, US | |
2022-01-20 | US | Washington | Pend Oreille | 53051 | 1979 | 28 | 0 | 48.53234021 | -117.2741804 | 2022-01-21 04:21:09 | Pend Oreille, Washington, US | |
2022-01-16 | US | Pennsylvania | Forest | 42053 | 1979 | 33 | 0 | 41.51095103 | -79.23229292 | 2022-01-17 04:21:08 | Forest, Pennsylvania, US | |
2022-01-13 | US | North Carolina | Pamlico | 37137 | 1979 | 27 | 0 | 35.15253315 | -76.66559823 | 2022-01-14 04:21:54 | Pamlico, North Carolina, US | |
2022-01-13 | US | Kentucky | Lee | 21129 | 1979 | 44 | 0 | 37.59645942 | -83.71513901 | 2022-01-14 04:21:54 | Lee, Kentucky, US | |
2022-01-10 | US | Minnesota | Stevens | 27149 | 1979 | 11 | 0 | 45.58613007 | -96.00163705 | 2022-01-11 04:22:01 | Stevens, Minnesota, US | |
2022-01-02 | US | South Dakota | Todd | 46121 | 1979 | 39 | 0 | 43.19338568 | -100.71955030000001 | 2022-01-03 02:22:25 | Todd, South Dakota, US | |
2022-01-02 | US | North Dakota | Mercer | 38057 | 1979 | 22 | 0 | 47.31213126 | -101.8318399 | 2022-01-03 02:22:25 | Mercer, North Dakota, US | |
2022-01-01 | US | South Dakota | Todd | 46121 | 1979 | 39 | 0 | 43.19338568 | -100.71955030000001 | 2022-01-02 04:20:52 | Todd, South Dakota, US | |
2022-01-01 | US | North Dakota | Mercer | 38057 | 1979 | 22 | 0 | 47.31213126 | -101.8318399 | 2022-01-02 04:20:52 | Mercer, North Dakota, US | |
2021-12-31 | US | South Dakota | Todd | 46121 | 1979 | 39 | 0 | 43.19338568 | -100.71955030000001 | 2022-01-01 04:22:14 | Todd, South Dakota, US | |
2021-12-31 | US | North Dakota | Mercer | 38057 | 1979 | 22 | 0 | 47.31213126 | -101.8318399 | 2022-01-01 04:22:14 | Mercer, North Dakota, US | |
2021-12-30 | US | South Dakota | Todd | 46121 | 1979 | 39 | 0 | 43.19338568 | -100.71955030000001 | 2021-12-31 04:21:50 | Todd, South Dakota, US | |
2021-12-27 | US | Texas | Callahan | 48059 | 1979 | 59 | 0 | 32.29760619 | -99.37326312 | 2021-12-28 04:21:47 | Callahan, Texas, US | |
2021-12-26 | US | Puerto Rico | Barranquitas | 72019 | 1979 | 0 | 0 | 18.201592 | -66.30963 | 2021-12-27 04:21:58 | Barranquitas, Puerto Rico, US | |
2021-12-26 | US | Kansas | Brown | 20013 | 1979 | 42 | 0 | 39.82652589 | -95.56421698 | 2021-12-27 04:21:58 | Brown, Kansas, US | |
2021-12-25 | US | Kansas | Brown | 20013 | 1979 | 42 | 0 | 39.82652589 | -95.56421698 | 2021-12-26 04:21:50 | Brown, Kansas, US | |
2021-12-24 | US | Kansas | Brown | 20013 | 1979 | 42 | 0 | 39.82652589 | -95.56421698 | 2021-12-25 04:21:37 | Brown, Kansas, US | |
2021-12-23 | US | Kansas | Brown | 20013 | 1979 | 42 | 0 | 39.82652589 | -95.56421698 | 2021-12-24 04:21:34 | Brown, Kansas, US | |
2021-12-22 | US | Texas | Ward | 48475 | 1979 | 35 | 0 | 31.50999644 | -103.09279090000001 | 2021-12-23 04:21:21 | Ward, Texas, US | |
2021-12-22 | US | Oregon | Curry | 41015 | 1979 | 40 | 0 | 42.45911325 | -124.15728200000001 | 2021-12-23 04:21:21 | Curry, Oregon, US | |
2021-12-22 | US | Kansas | Brown | 20013 | 1979 | 42 | 0 | 39.82652589 | -95.56421698 | 2021-12-23 04:21:21 | Brown, Kansas, US | |
2021-12-21 | US | Missouri | Bollinger | 29017 | 1979 | 35 | 0 | 37.32449052 | -90.02725304 | 2021-12-22 04:21:54 | Bollinger, Missouri, US | |
2021-12-19 | US | North Carolina | Alleghany | 37005 | 1979 | 6 | 0 | 36.49360862 | -81.12857041 | 2021-12-20 04:21:43 | Alleghany, North Carolina, US | |
2021-12-18 | US | Ohio | Vinton | 39163 | 1979 | 46 | 0 | 39.25208988 | -82.4831444 | 2021-12-19 04:21:11 | Vinton, Ohio, US | |
2021-12-18 | US | North Carolina | Alleghany | 37005 | 1979 | 6 | 0 | 36.49360862 | -81.12857041 | 2021-12-19 04:21:11 | Alleghany, North Carolina, US | |
2021-12-17 | US | North Carolina | Alleghany | 37005 | 1979 | 6 | 0 | 36.49360862 | -81.12857041 | 2021-12-18 02:22:20 | Alleghany, North Carolina, US | |
2021-12-16 | US | Arkansas | Desha | 5041 | 1979 | 35 | 0 | 33.83011025 | -91.25500948 | 2021-12-17 04:22:14 | Desha, Arkansas, US | |
2021-12-15 | US | Maryland | Kent | 24029 | 1979 | 57 | 0 | 39.24976208 | -76.04741541 | 2021-12-16 04:22:11 | Kent, Maryland, US | |
2021-12-12 | US | Nebraska | Colfax | 31037 | 1979 | 21 | 0 | 41.57486951 | -97.0868542 | 2021-12-13 04:22:02 | Colfax, Nebraska, US | |
2021-12-11 | US | Nebraska | Colfax | 31037 | 1979 | 21 | 0 | 41.57486951 | -97.0868542 | 2021-12-12 04:22:12 | Colfax, Nebraska, US | |
2021-12-10 | US | Nebraska | Colfax | 31037 | 1979 | 21 | 0 | 41.57486951 | -97.0868542 | 2021-12-11 04:22:45 | Colfax, Nebraska, US | |
2021-12-08 | US | Montana | Richland | 30083 | 1979 | 24 | 0 | 47.78668011 | -104.5610786 | 2021-12-09 04:22:49 | Richland, Montana, US | |
2021-12-03 | US | Puerto Rico | Las Piedras | 72085 | 1979 | 0 | 0 | 18.187527 | -65.86946800000001 | 2021-12-04 04:22:18 | Las Piedras, Puerto Rico, US | |
2021-11-27 | US | Puerto Rico | Corozal | 72047 | 1979 | 0 | 0 | 18.304264 | -66.327738 | 2021-11-28 04:22:43 | Corozal, Puerto Rico, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;