daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
237 rows where confirmed = 2942 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-29 | US | Montana | Richland | 30083 | 2942 | 37 | 0 | 47.78668011 | -104.5610786 | 2022-12-30 04:21:04 | Richland, Montana, US | |
2022-12-28 | US | Montana | Richland | 30083 | 2942 | 37 | 0 | 47.78668011 | -104.5610786 | 2022-12-29 04:21:01 | Richland, Montana, US | |
2022-12-27 | US | Montana | Richland | 30083 | 2942 | 37 | 0 | 47.78668011 | -104.5610786 | 2022-12-28 04:21:04 | Richland, Montana, US | |
2022-12-26 | US | Montana | Richland | 30083 | 2942 | 37 | 0 | 47.78668011 | -104.5610786 | 2022-12-27 04:21:07 | Richland, Montana, US | |
2022-12-25 | US | Montana | Richland | 30083 | 2942 | 37 | 0 | 47.78668011 | -104.5610786 | 2022-12-26 04:21:06 | Richland, Montana, US | |
2022-12-24 | US | Montana | Richland | 30083 | 2942 | 37 | 0 | 47.78668011 | -104.5610786 | 2022-12-25 04:21:04 | Richland, Montana, US | |
2022-12-23 | US | Montana | Richland | 30083 | 2942 | 37 | 0 | 47.78668011 | -104.5610786 | 2022-12-24 04:21:02 | Richland, Montana, US | |
2022-11-14 | US | Mississippi | Carroll | 28015 | 2942 | 58 | 0 | 33.44834567 | -89.91994479 | 2022-11-15 04:21:16 | Carroll, Mississippi, US | |
2022-11-13 | US | Mississippi | Carroll | 28015 | 2942 | 58 | 0 | 33.44834567 | -89.91994479 | 2022-11-14 04:21:09 | Carroll, Mississippi, US | |
2022-11-12 | US | Mississippi | Carroll | 28015 | 2942 | 58 | 0 | 33.44834567 | -89.91994479 | 2022-11-13 04:21:14 | Carroll, Mississippi, US | |
2022-11-11 | US | Mississippi | Carroll | 28015 | 2942 | 58 | 0 | 33.44834567 | -89.91994479 | 2022-11-12 04:20:41 | Carroll, Mississippi, US | |
2022-11-10 | US | Mississippi | Carroll | 28015 | 2942 | 58 | 0 | 33.44834567 | -89.91994479 | 2022-11-11 04:21:22 | Carroll, Mississippi, US | |
2022-10-18 | US | Indiana | Newton | 18111 | 2942 | 73 | 0 | 40.95610449 | -87.39635768 | 2022-10-19 04:22:26 | Newton, Indiana, US | |
2022-10-17 | US | Indiana | Newton | 18111 | 2942 | 73 | 0 | 40.95610449 | -87.39635768 | 2022-10-18 04:22:42 | Newton, Indiana, US | |
2022-10-16 | US | Indiana | Newton | 18111 | 2942 | 73 | 0 | 40.95610449 | -87.39635768 | 2022-10-17 04:20:31 | Newton, Indiana, US | |
2022-10-15 | US | Indiana | Newton | 18111 | 2942 | 73 | 0 | 40.95610449 | -87.39635768 | 2022-10-16 04:22:39 | Newton, Indiana, US | |
2022-10-14 | US | Indiana | Newton | 18111 | 2942 | 73 | 0 | 40.95610449 | -87.39635768 | 2022-10-15 04:22:00 | Newton, Indiana, US | |
2022-10-13 | US | Indiana | Newton | 18111 | 2942 | 73 | 0 | 40.95610449 | -87.39635768 | 2022-10-14 04:22:28 | Newton, Indiana, US | |
2022-10-04 | US | Colorado | Prowers | 8099 | 2942 | 51 | 0 | 37.95544985 | -102.3926052 | 2022-10-05 04:23:06 | Prowers, Colorado, US | |
2022-09-18 | US | Idaho | Valley | 16085 | 2942 | 16 | 0 | 44.76728382 | -115.5676773 | 2022-09-19 04:21:49 | Valley, Idaho, US | |
2022-09-17 | US | Idaho | Valley | 16085 | 2942 | 16 | 0 | 44.76728382 | -115.5676773 | 2022-09-18 04:22:50 | Valley, Idaho, US | |
2022-09-16 | US | Idaho | Valley | 16085 | 2942 | 16 | 0 | 44.76728382 | -115.5676773 | 2022-09-17 04:20:19 | Valley, Idaho, US | |
2022-09-04 | US | Arkansas | Fulton | 5049 | 2942 | 95 | 0 | 36.38177105 | -91.81729127 | 2022-09-05 04:21:01 | Fulton, Arkansas, US | |
2022-09-03 | US | Arkansas | Fulton | 5049 | 2942 | 95 | 0 | 36.38177105 | -91.81729127 | 2022-09-04 04:21:22 | Fulton, Arkansas, US | |
2022-09-01 | US | Texas | Blanco | 48031 | 2942 | 35 | 0 | 30.26640707 | -98.3999852 | 2022-09-02 04:21:07 | Blanco, Texas, US | |
2022-08-23 | US | North Dakota | McLean | 38055 | 2942 | 49 | 0 | 47.60766714 | -101.3182418 | 2022-08-24 04:20:46 | McLean, North Dakota, US | |
2022-08-17 | US | Virginia | Nelson | 51125 | 2942 | 36 | 0 | 37.78790447 | -78.88498513 | 2022-08-18 04:21:11 | Nelson, Virginia, US | |
2022-08-07 | US | Idaho | Shoshone | 16079 | 2942 | 77 | 0 | 47.35364087 | -115.8916749 | 2022-08-08 04:21:08 | Shoshone, Idaho, US | |
2022-08-06 | US | Idaho | Shoshone | 16079 | 2942 | 77 | 0 | 47.35364087 | -115.8916749 | 2022-08-07 04:20:54 | Shoshone, Idaho, US | |
2022-08-05 | US | Idaho | Shoshone | 16079 | 2942 | 77 | 0 | 47.35364087 | -115.8916749 | 2022-08-06 04:20:56 | Shoshone, Idaho, US | |
2022-06-30 | US | Missouri | Barton | 29011 | 2942 | 52 | 0 | 37.50207671 | -94.34757022 | 2022-07-01 04:21:10 | Barton, Missouri, US | |
2022-06-29 | US | Missouri | Barton | 29011 | 2942 | 52 | 0 | 37.50207671 | -94.34757022 | 2022-06-30 04:21:01 | Barton, Missouri, US | |
2022-06-29 | US | Louisiana | West Feliciana | 22125 | 2942 | 46 | 0 | 30.87882871 | -91.4148538 | 2022-06-30 04:21:01 | West Feliciana, Louisiana, US | |
2022-06-28 | US | Missouri | Barton | 29011 | 2942 | 52 | 0 | 37.50207671 | -94.34757022 | 2022-06-29 04:20:59 | Barton, Missouri, US | |
2022-06-28 | US | Iowa | Allamakee | 19005 | 2942 | 60 | 0 | 43.28383218 | -91.37860922 | 2022-06-29 04:20:59 | Allamakee, Iowa, US | |
2022-06-27 | US | Missouri | Barton | 29011 | 2942 | 52 | 0 | 37.50207671 | -94.34757022 | 2022-06-28 04:20:58 | Barton, Missouri, US | |
2022-06-27 | US | Iowa | Allamakee | 19005 | 2942 | 60 | 0 | 43.28383218 | -91.37860922 | 2022-06-28 04:20:58 | Allamakee, Iowa, US | |
2022-06-26 | US | Missouri | Barton | 29011 | 2942 | 52 | 0 | 37.50207671 | -94.34757022 | 2022-06-27 04:21:00 | Barton, Missouri, US | |
2022-06-26 | US | Iowa | Allamakee | 19005 | 2942 | 60 | 0 | 43.28383218 | -91.37860922 | 2022-06-27 04:21:00 | Allamakee, Iowa, US | |
2022-06-26 | US | Alabama | Conecuh | 1035 | 2942 | 70 | 0 | 31.43401703 | -86.99320044 | 2022-06-27 04:21:00 | Conecuh, Alabama, US | |
2022-06-25 | US | Missouri | Barton | 29011 | 2942 | 52 | 0 | 37.50207671 | -94.34757022 | 2022-06-26 04:21:02 | Barton, Missouri, US | |
2022-06-25 | US | Iowa | Allamakee | 19005 | 2942 | 60 | 0 | 43.28383218 | -91.37860922 | 2022-06-26 04:21:02 | Allamakee, Iowa, US | |
2022-06-25 | US | Alabama | Conecuh | 1035 | 2942 | 70 | 0 | 31.43401703 | -86.99320044 | 2022-06-26 04:21:02 | Conecuh, Alabama, US | |
2022-06-24 | US | Missouri | Barton | 29011 | 2942 | 52 | 0 | 37.50207671 | -94.34757022 | 2022-06-25 04:20:57 | Barton, Missouri, US | |
2022-06-24 | US | Iowa | Allamakee | 19005 | 2942 | 60 | 0 | 43.28383218 | -91.37860922 | 2022-06-25 04:20:57 | Allamakee, Iowa, US | |
2022-06-24 | US | Alabama | Conecuh | 1035 | 2942 | 70 | 0 | 31.43401703 | -86.99320044 | 2022-06-25 04:20:57 | Conecuh, Alabama, US | |
2022-06-23 | US | Iowa | Allamakee | 19005 | 2942 | 60 | 0 | 43.28383218 | -91.37860922 | 2022-06-24 04:20:58 | Allamakee, Iowa, US | |
2022-06-22 | US | Iowa | Allamakee | 19005 | 2942 | 60 | 0 | 43.28383218 | -91.37860922 | 2022-06-23 04:20:55 | Allamakee, Iowa, US | |
2022-06-05 | US | Puerto Rico | Florida | 72054 | 2942 | 0 | 0 | 18.373715 | -66.560488 | 2022-06-06 04:20:57 | Florida, Puerto Rico, US | |
2022-06-01 | US | Texas | Callahan | 48059 | 2942 | 72 | 0 | 32.29760619 | -99.37326312 | 2022-06-02 05:20:39 | Callahan, Texas, US | |
2022-05-17 | US | South Dakota | Charles Mix | 46023 | 2942 | 35 | 0 | 43.20660134 | -98.58856175 | 2022-05-18 04:20:50 | Charles Mix, South Dakota, US | |
2022-05-16 | US | South Dakota | Charles Mix | 46023 | 2942 | 35 | 0 | 43.20660134 | -98.58856175 | 2022-05-17 04:20:59 | Charles Mix, South Dakota, US | |
2022-05-15 | US | South Dakota | Charles Mix | 46023 | 2942 | 35 | 0 | 43.20660134 | -98.58856175 | 2022-05-16 04:20:47 | Charles Mix, South Dakota, US | |
2022-05-14 | US | South Dakota | Charles Mix | 46023 | 2942 | 35 | 0 | 43.20660134 | -98.58856175 | 2022-05-15 04:20:53 | Charles Mix, South Dakota, US | |
2022-05-13 | US | South Dakota | Charles Mix | 46023 | 2942 | 35 | 0 | 43.20660134 | -98.58856175 | 2022-05-14 04:20:48 | Charles Mix, South Dakota, US | |
2022-05-12 | US | South Dakota | Charles Mix | 46023 | 2942 | 35 | 0 | 43.20660134 | -98.58856175 | 2022-05-13 04:20:51 | Charles Mix, South Dakota, US | |
2022-05-11 | US | South Dakota | Charles Mix | 46023 | 2942 | 35 | 0 | 43.20660134 | -98.58856175 | 2022-05-12 04:20:54 | Charles Mix, South Dakota, US | |
2022-04-30 | US | Colorado | Archuleta | 8007 | 2942 | 16 | 0 | 37.19474156 | -107.0476867 | 2022-05-01 04:20:57 | Archuleta, Colorado, US | |
2022-04-24 | US | Kentucky | Lee | 21129 | 2942 | 50 | 0 | 37.59645942 | -83.71513901 | 2022-04-25 04:20:56 | Lee, Kentucky, US | |
2022-04-23 | US | Kentucky | Lee | 21129 | 2942 | 50 | 0 | 37.59645942 | -83.71513901 | 2022-04-24 04:20:56 | Lee, Kentucky, US | |
2022-04-22 | US | Kentucky | Lee | 21129 | 2942 | 50 | 0 | 37.59645942 | -83.71513901 | 2022-04-23 04:20:50 | Lee, Kentucky, US | |
2022-04-21 | US | Kentucky | Lee | 21129 | 2942 | 50 | 0 | 37.59645942 | -83.71513901 | 2022-04-22 04:20:45 | Lee, Kentucky, US | |
2022-04-20 | US | Kentucky | Lee | 21129 | 2942 | 50 | 0 | 37.59645942 | -83.71513901 | 2022-04-21 04:20:46 | Lee, Kentucky, US | |
2022-04-19 | US | Kentucky | Lee | 21129 | 2942 | 50 | 0 | 37.59645942 | -83.71513901 | 2022-04-20 04:20:45 | Lee, Kentucky, US | |
2022-04-19 | China | Zhejiang | 2942 | 1 | 0 | 29.1832 | 120.0934 | 2022-04-20 04:20:45 | Zhejiang, China | |||
2022-04-18 | US | Kentucky | Lee | 21129 | 2942 | 50 | 0 | 37.59645942 | -83.71513901 | 2022-04-19 04:21:00 | Lee, Kentucky, US | |
2022-03-27 | US | Minnesota | Aitkin | 27001 | 2942 | 60 | 0 | 46.60962049 | -93.41168259999999 | 2022-03-28 04:20:33 | Aitkin, Minnesota, US | |
2022-03-26 | US | Minnesota | Aitkin | 27001 | 2942 | 60 | 0 | 46.60962049 | -93.41168259999999 | 2022-03-27 04:20:47 | Aitkin, Minnesota, US | |
2022-03-25 | US | Minnesota | Aitkin | 27001 | 2942 | 60 | 0 | 46.60962049 | -93.41168259999999 | 2022-03-26 04:20:23 | Aitkin, Minnesota, US | |
2022-03-17 | US | Alabama | Coosa | 1037 | 2942 | 58 | 0 | 32.93690146 | -86.24847739 | 2022-03-18 04:20:55 | Coosa, Alabama, US | |
2022-03-15 | US | Iowa | Winnebago | 19189 | 2942 | 45 | 0 | 43.37751174 | -93.73407298 | 2022-03-16 04:20:50 | Winnebago, Iowa, US | |
2022-03-14 | US | Iowa | Winnebago | 19189 | 2942 | 45 | 0 | 43.37751174 | -93.73407298 | 2022-03-15 04:20:47 | Winnebago, Iowa, US | |
2022-03-13 | US | Iowa | Winnebago | 19189 | 2942 | 45 | 0 | 43.37751174 | -93.73407298 | 2022-03-14 04:20:46 | Winnebago, Iowa, US | |
2022-03-12 | US | Iowa | Winnebago | 19189 | 2942 | 45 | 0 | 43.37751174 | -93.73407298 | 2022-03-13 04:20:49 | Winnebago, Iowa, US | |
2022-03-11 | US | Iowa | Winnebago | 19189 | 2942 | 45 | 0 | 43.37751174 | -93.73407298 | 2022-03-12 04:20:50 | Winnebago, Iowa, US | |
2022-03-10 | US | Iowa | Winnebago | 19189 | 2942 | 45 | 0 | 43.37751174 | -93.73407298 | 2022-03-11 04:20:50 | Winnebago, Iowa, US | |
2022-03-09 | US | Iowa | Winnebago | 19189 | 2942 | 45 | 0 | 43.37751174 | -93.73407298 | 2022-03-10 04:20:48 | Winnebago, Iowa, US | |
2022-03-06 | US | Oregon | Morrow | 41049 | 2942 | 31 | 0 | 45.41846568 | -119.584546 | 2022-03-07 04:20:47 | Morrow, Oregon, US | |
2022-03-05 | US | Oregon | Morrow | 41049 | 2942 | 31 | 0 | 45.41846568 | -119.584546 | 2022-03-06 04:20:49 | Morrow, Oregon, US | |
2022-03-04 | US | Oregon | Morrow | 41049 | 2942 | 31 | 0 | 45.41846568 | -119.584546 | 2022-03-05 04:21:10 | Morrow, Oregon, US | |
2022-03-03 | US | Oregon | Morrow | 41049 | 2942 | 31 | 0 | 45.41846568 | -119.584546 | 2022-03-04 04:21:09 | Morrow, Oregon, US | |
2022-03-02 | US | Oregon | Morrow | 41049 | 2942 | 30 | 0 | 45.41846568 | -119.584546 | 2022-03-03 04:21:01 | Morrow, Oregon, US | |
2022-02-26 | US | North Dakota | Barnes | 38003 | 2942 | 46 | 0 | 46.93579637 | -98.06605978 | 2022-02-27 04:21:04 | Barnes, North Dakota, US | |
2022-02-25 | US | North Dakota | Barnes | 38003 | 2942 | 46 | 0 | 46.93579637 | -98.06605978 | 2022-02-26 04:21:12 | Barnes, North Dakota, US | |
2022-02-24 | US | Missouri | Pemiscot | 29155 | 2942 | 72 | 0 | 36.2130572 | -89.78742322 | 2022-02-25 04:21:11 | Pemiscot, Missouri, US | |
2022-02-19 | US | Puerto Rico | Loiza | 72087 | 2942 | 0 | 0 | 18.425688 | -65.89943000000001 | 2022-02-20 04:21:00 | Loiza, Puerto Rico, US | |
2022-02-17 | US | North Carolina | Washington | 37187 | 2942 | 46 | 0 | 35.83810081 | -76.57299037 | 2022-02-18 04:21:04 | Washington, North Carolina, US | |
2022-02-08 | US | Arkansas | Desha | 5041 | 2942 | 37 | 0 | 33.83011025 | -91.25500948 | 2022-02-09 04:21:04 | Desha, Arkansas, US | |
2022-01-18 | US | North Dakota | Ramsey | 38071 | 2942 | 47 | 0 | 48.26886249 | -98.72223879 | 2022-01-19 04:21:23 | Ramsey, North Dakota, US | |
2022-01-14 | US | Colorado | Las Animas | 8071 | 2942 | 39 | 0 | 37.3153406 | -104.03764579999999 | 2022-01-15 04:21:07 | Las Animas, Colorado, US | |
2022-01-04 | US | Texas | Bosque | 48035 | 2942 | 59 | 0 | 31.89978581 | -97.63613524 | 2022-01-05 04:21:59 | Bosque, Texas, US | |
2021-12-27 | US | Missouri | Moniteau | 29135 | 2942 | 46 | 0 | 38.63571781 | -92.57976951 | 2021-12-28 04:21:47 | Moniteau, Missouri, US | |
2021-12-26 | Australia | Australian Capital Territory | 2942 | 15 | 0 | -35.4735 | 149.0124 | 2021-12-27 04:21:58 | Australian Capital Territory, Australia | |||
2021-12-23 | Russia | Chukotka Autonomous Okrug | 2942 | 32 | 0 | 66.0006475 | 169.4900869 | 2021-12-24 04:21:34 | Chukotka Autonomous Okrug, Russia | |||
2021-12-16 | US | Vermont | Caledonia | 50005 | 2942 | 21 | 0 | 44.46548598 | -72.10314651 | 2021-12-17 04:22:14 | Caledonia, Vermont, US | |
2021-12-16 | US | North Carolina | Hertford | 37091 | 2942 | 73 | 0 | 36.3607755 | -76.98104134 | 2021-12-17 04:22:14 | Hertford, North Carolina, US | |
2021-12-15 | US | North Dakota | Richland | 38077 | 2942 | 21 | 0 | 46.26440649 | -96.94852979 | 2021-12-16 04:22:11 | Richland, North Dakota, US | |
2021-12-13 | US | North Carolina | Avery | 37011 | 2942 | 39 | 0 | 36.07569796 | -81.92308483 | 2021-12-14 04:22:38 | Avery, North Carolina, US | |
2021-12-02 | US | Indiana | Carroll | 18015 | 2942 | 39 | 0 | 40.580783200000006 | -86.56198812 | 2021-12-03 04:23:05 | Carroll, Indiana, US | |
2021-12-01 | US | Tennessee | Grundy | 47061 | 2942 | 43 | 0 | 35.38433717 | -85.72142731 | 2021-12-02 04:22:37 | Grundy, Tennessee, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;