daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
197 rows where confirmed = 3207 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-11-09 | US | Oklahoma | Haskell | 40061 | 3207 | 43 | 0 | 35.222576 | -95.11513306 | 2022-11-10 04:21:16 | Haskell, Oklahoma, US | |
2022-11-08 | US | Oklahoma | Haskell | 40061 | 3207 | 43 | 0 | 35.222576 | -95.11513306 | 2022-11-09 04:21:22 | Haskell, Oklahoma, US | |
2022-11-07 | US | Oklahoma | Haskell | 40061 | 3207 | 43 | 0 | 35.222576 | -95.11513306 | 2022-11-08 04:21:21 | Haskell, Oklahoma, US | |
2022-11-06 | US | Oklahoma | Haskell | 40061 | 3207 | 43 | 0 | 35.222576 | -95.11513306 | 2022-11-07 04:21:26 | Haskell, Oklahoma, US | |
2022-11-05 | US | Oklahoma | Haskell | 40061 | 3207 | 43 | 0 | 35.222576 | -95.11513306 | 2022-11-06 04:21:24 | Haskell, Oklahoma, US | |
2022-11-04 | US | Oklahoma | Haskell | 40061 | 3207 | 43 | 0 | 35.222576 | -95.11513306 | 2022-11-05 04:21:52 | Haskell, Oklahoma, US | |
2022-11-03 | US | Oklahoma | Haskell | 40061 | 3207 | 43 | 0 | 35.222576 | -95.11513306 | 2022-11-04 04:22:11 | Haskell, Oklahoma, US | |
2022-09-01 | US | Texas | Pecos | 48371 | 3207 | 71 | 0 | 30.78097267 | -102.7241261 | 2022-09-02 04:21:07 | Pecos, Texas, US | |
2022-08-24 | US | Texas | Camp | 48063 | 3207 | 76 | 0 | 32.97195142 | -94.97790104 | 2022-08-25 04:21:13 | Camp, Texas, US | |
2022-08-23 | US | Oregon | Morrow | 41049 | 3207 | 37 | 0 | 45.41846568 | -119.584546 | 2022-08-24 04:20:46 | Morrow, Oregon, US | |
2022-08-18 | US | Texas | Callahan | 48059 | 3207 | 73 | 0 | 32.29760619 | -99.37326312 | 2022-08-19 04:20:54 | Callahan, Texas, US | |
2022-08-09 | US | North Dakota | Barnes | 38003 | 3207 | 47 | 0 | 46.93579637 | -98.06605978 | 2022-08-10 04:20:57 | Barnes, North Dakota, US | |
2022-07-26 | US | Idaho | Idaho | 16049 | 3207 | 52 | 0 | 45.84721541 | -115.4634436 | 2022-07-27 04:21:04 | Idaho, Idaho, US | |
2022-07-25 | US | Idaho | Idaho | 16049 | 3207 | 52 | 0 | 45.84721541 | -115.4634436 | 2022-07-26 04:20:58 | Idaho, Idaho, US | |
2022-07-25 | China | Henan | 3207 | 22 | 0 | 33.882 | 113.614 | 2022-07-26 04:20:58 | Henan, China | |||
2022-07-24 | China | Henan | 3207 | 22 | 0 | 33.882 | 113.614 | 2022-07-25 04:20:51 | Henan, China | |||
2022-06-20 | US | Colorado | Moffat | 8081 | 3207 | 52 | 0 | 40.61810999 | -108.2070876 | 2022-06-21 04:20:56 | Moffat, Colorado, US | |
2022-06-01 | US | Maine | Piscataquis | 23021 | 3207 | 31 | 0 | 45.83839062 | -69.2860223 | 2022-06-02 05:20:39 | Piscataquis, Maine, US | |
2022-05-11 | US | New Jersey | Unassigned | 90034 | 3207 | 0 | 0 | 41.13891592 | 0.0 | 2022-05-12 04:20:54 | Unassigned, New Jersey, US | |
2022-05-04 | US | Ohio | Noble | 39121 | 3207 | 59 | 0 | 39.76818851 | -81.45937183 | 2022-05-05 04:20:55 | Noble, Ohio, US | |
2022-05-03 | US | Ohio | Noble | 39121 | 3207 | 59 | 0 | 39.76818851 | -81.45937183 | 2022-05-04 04:20:59 | Noble, Ohio, US | |
2022-05-02 | US | Ohio | Noble | 39121 | 3207 | 59 | 0 | 39.76818851 | -81.45937183 | 2022-05-03 04:21:00 | Noble, Ohio, US | |
2022-05-01 | US | Ohio | Noble | 39121 | 3207 | 59 | 0 | 39.76818851 | -81.45937183 | 2022-05-02 04:21:10 | Noble, Ohio, US | |
2022-04-30 | US | Ohio | Noble | 39121 | 3207 | 59 | 0 | 39.76818851 | -81.45937183 | 2022-05-01 04:20:57 | Noble, Ohio, US | |
2022-04-29 | US | Ohio | Noble | 39121 | 3207 | 59 | 0 | 39.76818851 | -81.45937183 | 2022-04-30 04:21:05 | Noble, Ohio, US | |
2022-04-28 | US | Ohio | Noble | 39121 | 3207 | 59 | 0 | 39.76818851 | -81.45937183 | 2022-04-29 04:20:59 | Noble, Ohio, US | |
2022-04-20 | US | Ohio | Noble | 39121 | 3207 | 59 | 0 | 39.76818851 | -81.45937183 | 2022-04-21 04:20:46 | Noble, Ohio, US | |
2022-04-19 | US | Ohio | Noble | 39121 | 3207 | 59 | 0 | 39.76818851 | -81.45937183 | 2022-04-20 04:20:45 | Noble, Ohio, US | |
2022-04-18 | US | Ohio | Noble | 39121 | 3207 | 59 | 0 | 39.76818851 | -81.45937183 | 2022-04-19 04:21:00 | Noble, Ohio, US | |
2022-04-17 | US | Ohio | Noble | 39121 | 3207 | 59 | 0 | 39.76818851 | -81.45937183 | 2022-04-18 04:21:12 | Noble, Ohio, US | |
2022-04-16 | US | Ohio | Noble | 39121 | 3207 | 59 | 0 | 39.76818851 | -81.45937183 | 2022-04-17 04:20:59 | Noble, Ohio, US | |
2022-04-15 | US | Ohio | Noble | 39121 | 3207 | 58 | 0 | 39.76818851 | -81.45937183 | 2022-04-16 04:20:48 | Noble, Ohio, US | |
2022-04-14 | US | Ohio | Noble | 39121 | 3207 | 58 | 0 | 39.76818851 | -81.45937183 | 2022-04-15 04:20:57 | Noble, Ohio, US | |
2022-03-22 | US | Minnesota | Cottonwood | 27033 | 3207 | 41 | 0 | 44.00715262 | -95.18138802 | 2022-03-23 04:20:48 | Cottonwood, Minnesota, US | |
2022-03-21 | US | Minnesota | Cottonwood | 27033 | 3207 | 41 | 0 | 44.00715262 | -95.18138802 | 2022-03-22 04:20:54 | Cottonwood, Minnesota, US | |
2022-03-06 | US | Virginia | Rockbridge | 51163 | 3207 | 75 | 0 | 37.81204314 | -79.44605905 | 2022-03-07 04:20:47 | Rockbridge, Virginia, US | |
2022-03-05 | US | Virginia | Rockbridge | 51163 | 3207 | 75 | 0 | 37.81204314 | -79.44605905 | 2022-03-06 04:20:49 | Rockbridge, Virginia, US | |
2022-03-04 | US | Virginia | Rockbridge | 51163 | 3207 | 75 | 0 | 37.81204314 | -79.44605905 | 2022-03-05 04:21:10 | Rockbridge, Virginia, US | |
2022-03-01 | US | Tennessee | Jackson | 47087 | 3207 | 58 | 0 | 36.36380466 | -85.67239905 | 2022-03-02 04:21:07 | Jackson, Tennessee, US | |
2022-03-01 | US | North Dakota | Mountrail | 38061 | 3207 | 35 | 0 | 48.20197971 | -102.3555315 | 2022-03-02 04:21:07 | Mountrail, North Dakota, US | |
2022-03-01 | US | Kentucky | Martin | 21159 | 3207 | 45 | 0 | 37.79990579 | -82.51247478 | 2022-03-02 04:21:07 | Martin, Kentucky, US | |
2022-02-23 | US | Texas | Jackson | 48239 | 3207 | 58 | 0 | 28.95472367 | -96.57749563 | 2022-02-24 04:21:14 | Jackson, Texas, US | |
2022-02-23 | US | Arkansas | Little River | 5081 | 3207 | 87 | 0 | 33.70375665 | -94.23468591 | 2022-02-24 04:21:14 | Little River, Arkansas, US | |
2022-02-22 | US | Texas | Jackson | 48239 | 3207 | 57 | 0 | 28.95472367 | -96.57749563 | 2022-02-23 04:21:09 | Jackson, Texas, US | |
2022-02-17 | US | Michigan | Gogebic | 26053 | 3207 | 66 | 0 | 46.40862701 | -89.69377193 | 2022-02-18 04:21:04 | Gogebic, Michigan, US | |
2022-02-16 | US | Michigan | Gogebic | 26053 | 3207 | 66 | 0 | 46.40862701 | -89.69377193 | 2022-02-17 04:20:56 | Gogebic, Michigan, US | |
2022-02-11 | US | Puerto Rico | Anasco | 72011 | 3207 | 0 | 0 | 18.287985 | -67.120611 | 2022-02-12 04:21:06 | Anasco, Puerto Rico, US | |
2022-02-09 | US | New York | Yates | 36123 | 3207 | 37 | 0 | 42.63505484 | -77.10369919 | 2022-02-10 04:21:14 | Yates, New York, US | |
2022-02-06 | US | Missouri | Gasconade | 29073 | 3207 | 93 | 0 | 38.43947277 | -91.50847147 | 2022-02-07 04:21:05 | Gasconade, Missouri, US | |
2022-01-30 | US | Michigan | Kalkaska | 26079 | 3207 | 48 | 0 | 44.68512729 | -85.09085699 | 2022-01-31 04:21:09 | Kalkaska, Michigan, US | |
2022-01-30 | US | Kentucky | Estill | 21065 | 3207 | 40 | 0 | 37.69241417 | -83.95956369 | 2022-01-31 04:21:09 | Estill, Kentucky, US | |
2022-01-29 | US | Michigan | Kalkaska | 26079 | 3207 | 48 | 0 | 44.68512729 | -85.09085699 | 2022-01-30 04:21:26 | Kalkaska, Michigan, US | |
2022-01-29 | US | Kentucky | Estill | 21065 | 3207 | 40 | 0 | 37.69241417 | -83.95956369 | 2022-01-30 04:21:26 | Estill, Kentucky, US | |
2022-01-28 | US | Michigan | Kalkaska | 26079 | 3207 | 48 | 0 | 44.68512729 | -85.09085699 | 2022-01-29 04:21:10 | Kalkaska, Michigan, US | |
2022-01-28 | US | Kentucky | Estill | 21065 | 3207 | 40 | 0 | 37.69241417 | -83.95956369 | 2022-01-29 04:21:10 | Estill, Kentucky, US | |
2022-01-19 | US | Kentucky | Casey | 21045 | 3207 | 63 | 0 | 37.32533118 | -84.92726209 | 2022-01-20 04:21:07 | Casey, Kentucky, US | |
2022-01-17 | US | Alabama | Clay | 1027 | 3207 | 70 | 0 | 33.26984193 | -85.85836077 | 2022-01-18 04:21:04 | Clay, Alabama, US | |
2022-01-04 | US | Illinois | White | 17193 | 3207 | 35 | 0 | 38.08706198 | -88.17657461 | 2022-01-05 04:21:59 | White, Illinois, US | |
2021-12-29 | US | Tennessee | Sequatchie | 47153 | 3207 | 59 | 0 | 35.36979721 | -85.41022136 | 2021-12-30 04:21:25 | Sequatchie, Tennessee, US | |
2021-12-27 | US | Missouri | Cooper | 29053 | 3207 | 54 | 0 | 38.844478 | -92.80896081 | 2021-12-28 04:21:47 | Cooper, Missouri, US | |
2021-12-26 | US | Mississippi | Clay | 28025 | 3207 | 78 | 0 | 33.65358105 | -88.77784255 | 2021-12-27 04:21:58 | Clay, Mississippi, US | |
2021-12-25 | US | Puerto Rico | Humacao | 72069 | 3207 | 0 | 0 | 18.145211 | -65.810174 | 2021-12-26 04:21:50 | Humacao, Puerto Rico, US | |
2021-12-25 | US | Mississippi | Clay | 28025 | 3207 | 78 | 0 | 33.65358105 | -88.77784255 | 2021-12-26 04:21:50 | Clay, Mississippi, US | |
2021-12-24 | US | Mississippi | Clay | 28025 | 3207 | 78 | 0 | 33.65358105 | -88.77784255 | 2021-12-25 04:21:37 | Clay, Mississippi, US | |
2021-12-23 | US | Mississippi | Clay | 28025 | 3207 | 78 | 0 | 33.65358105 | -88.77784255 | 2021-12-24 04:21:34 | Clay, Mississippi, US | |
2021-12-22 | US | Ohio | Meigs | 39105 | 3207 | 69 | 0 | 39.09224872 | -82.0305041 | 2021-12-23 04:21:21 | Meigs, Ohio, US | |
2021-12-22 | US | Mississippi | Clay | 28025 | 3207 | 78 | 0 | 33.65358105 | -88.77784255 | 2021-12-23 04:21:21 | Clay, Mississippi, US | |
2021-12-14 | US | Mississippi | Winston | 28159 | 3207 | 92 | 0 | 33.08747908 | -89.03391385 | 2021-12-15 03:22:16 | Winston, Mississippi, US | |
2021-12-07 | US | Texas | Lavaca | 48285 | 3207 | 100 | 0 | 29.38508402 | -96.93186692 | 2021-12-08 04:22:46 | Lavaca, Texas, US | |
2021-12-07 | US | Oregon | Wasco | 41065 | 3207 | 47 | 0 | 45.16292781 | -121.16709540000001 | 2021-12-08 04:22:46 | Wasco, Oregon, US | |
2021-12-02 | US | Texas | Montague | 48337 | 3207 | 97 | 0 | 33.67521893 | -97.72500958 | 2021-12-03 04:23:05 | Montague, Texas, US | |
2021-11-30 | US | Alabama | Henry | 1067 | 3207 | 66 | 0 | 31.51148016 | -85.24267944 | 2021-12-01 04:22:29 | Henry, Alabama, US | |
2021-11-29 | US | Missouri | Ray | 29177 | 3207 | 52 | 0 | 39.353746799999996 | -93.98905745 | 2021-11-30 04:22:53 | Ray, Missouri, US | |
2021-11-11 | US | Arkansas | Ashley | 5003 | 3207 | 50 | 0 | 33.19153461 | -91.76984709999999 | 2021-11-12 04:22:01 | Ashley, Arkansas, US | |
2021-11-02 | US | Arkansas | Phillips | 5107 | 3207 | 77 | 0 | 34.43268455 | -90.84800154 | 2021-11-03 06:22:09 | Phillips, Arkansas, US | |
2021-11-01 | US | Arkansas | Phillips | 5107 | 3207 | 77 | 0 | 34.43268455 | -90.84800154 | 2021-11-02 04:22:03 | Phillips, Arkansas, US | |
2021-10-31 | US | Georgia | Ben Hill | 13017 | 3207 | 101 | 0 | 31.76095874 | -83.22145359 | 2021-11-01 04:22:01 | Ben Hill, Georgia, US | |
2021-10-30 | US | Kentucky | Simpson | 21213 | 3207 | 56 | 0 | 36.74058474 | -86.58047435 | 2021-10-31 04:22:08 | Simpson, Kentucky, US | |
2021-10-30 | US | Georgia | Ben Hill | 13017 | 3207 | 101 | 0 | 31.76095874 | -83.22145359 | 2021-10-31 04:22:08 | Ben Hill, Georgia, US | |
2021-10-29 | US | Georgia | Ben Hill | 13017 | 3207 | 101 | 0 | 31.76095874 | -83.22145359 | 2021-10-30 04:22:03 | Ben Hill, Georgia, US | |
2021-10-21 | US | Georgia | Washington | 13303 | 3207 | 117 | 0 | 32.96711864 | -82.79357039 | 2021-10-22 04:21:14 | Washington, Georgia, US | |
2021-10-21 | US | Colorado | Montezuma | 8083 | 3207 | 41 | 0 | 37.33859579 | -108.59588570000001 | 2021-10-22 04:21:14 | Montezuma, Colorado, US | |
2021-10-19 | China | Guangdong | 3207 | 8 | 0 | 23.3417 | 113.4244 | 2021-10-20 04:21:00 | Guangdong, China | |||
2021-10-15 | US | Texas | Deaf Smith | 48117 | 3207 | 74 | 0 | 34.96522957 | -102.6054267 | 2021-10-16 04:21:15 | Deaf Smith, Texas, US | |
2021-10-09 | US | Arkansas | Lawrence | 5075 | 3207 | 55 | 0 | 36.04188196 | -91.10867198 | 2021-10-10 04:21:38 | Lawrence, Arkansas, US | |
2021-10-07 | US | Arkansas | Randolph | 5121 | 3207 | 52 | 0 | 36.3415714 | -91.02455531 | 2021-10-08 04:21:25 | Randolph, Arkansas, US | |
2021-10-06 | US | Colorado | Routt | 8107 | 3207 | 22 | 0 | 40.48596505 | -106.9905548 | 2021-10-07 04:21:36 | Routt, Colorado, US | |
2021-10-05 | US | Alabama | Randolph | 1111 | 3207 | 58 | 0 | 33.29526734 | -85.45708831 | 2021-10-06 04:21:33 | Randolph, Alabama, US | |
2021-10-02 | US | Kentucky | Woodford | 21239 | 3207 | 26 | 0 | 38.04178222 | -84.7417556 | 2021-10-03 04:21:24 | Woodford, Kentucky, US | |
2021-10-01 | US | New York | Delaware | 36025 | 3207 | 41 | 0 | 42.19837623 | -74.96709306 | 2021-10-02 04:21:25 | Delaware, New York, US | |
2021-09-25 | US | Ohio | Van Wert | 39161 | 3207 | 76 | 0 | 40.8554138 | -84.59111700000003 | 2021-09-26 04:21:29 | Van Wert, Ohio, US | |
2021-09-22 | US | New York | Lewis | 36049 | 3207 | 36 | 0 | 43.784415700000004 | -75.44903992 | 2021-09-23 04:21:43 | Lewis, New York, US | |
2021-09-09 | US | Georgia | Union | 13291 | 3207 | 92 | 0 | 34.82995757 | -83.98967069 | 2021-09-10 04:21:20 | Union, Georgia, US | |
2021-09-08 | US | Arkansas | Logan | 5083 | 3207 | 33 | 0 | 35.21413234 | -93.71951016 | 2021-09-09 04:21:27 | Logan, Arkansas, US | |
2021-09-07 | US | Alabama | Barbour | 1005 | 3207 | 65 | 0 | 31.868263 | -85.3871286 | 2021-09-08 04:21:31 | Barbour, Alabama, US | |
2021-09-05 | US | Virginia | Caroline | 51033 | 3207 | 43 | 0 | 38.02679129 | -77.34901405 | 2021-09-06 04:21:22 | Caroline, Virginia, US | |
2021-09-04 | US | Virginia | Caroline | 51033 | 3207 | 43 | 0 | 38.02679129 | -77.34901405 | 2021-09-05 04:21:33 | Caroline, Virginia, US | |
2021-09-03 | US | Virginia | Caroline | 51033 | 3207 | 43 | 0 | 38.02679129 | -77.34901405 | 2021-09-04 04:21:28 | Caroline, Virginia, US | |
2021-08-28 | US | Missouri | Randolph | 29175 | 3207 | 34 | 0 | 39.44007257 | -92.49713740000001 | 2021-08-29 04:21:14 | Randolph, Missouri, US | |
2021-08-27 | US | Texas | Burleson | 48051 | 3207 | 50 | 0 | 30.49273808 | -96.62158484 | 2021-08-28 04:21:28 | Burleson, Texas, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;