daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
323 rows where confirmed = 1603 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-10-12 | US | Minnesota | Big Stone | 27011 | 1603 | 9 | 0 | 45.42712824 | -96.41403739 | 2022-10-13 04:22:39 | Big Stone, Minnesota, US | |
2022-10-11 | US | Minnesota | Big Stone | 27011 | 1603 | 9 | 0 | 45.42712824 | -96.41403739 | 2022-10-12 04:22:51 | Big Stone, Minnesota, US | |
2022-10-10 | US | Minnesota | Big Stone | 27011 | 1603 | 9 | 0 | 45.42712824 | -96.41403739 | 2022-10-11 04:23:05 | Big Stone, Minnesota, US | |
2022-10-09 | US | Minnesota | Big Stone | 27011 | 1603 | 9 | 0 | 45.42712824 | -96.41403739 | 2022-10-10 04:22:32 | Big Stone, Minnesota, US | |
2022-10-08 | US | Minnesota | Big Stone | 27011 | 1603 | 9 | 0 | 45.42712824 | -96.41403739 | 2022-10-09 04:21:16 | Big Stone, Minnesota, US | |
2022-10-07 | US | Minnesota | Big Stone | 27011 | 1603 | 9 | 0 | 45.42712824 | -96.41403739 | 2022-10-08 04:22:56 | Big Stone, Minnesota, US | |
2022-10-06 | US | Minnesota | Big Stone | 27011 | 1603 | 9 | 0 | 45.42712824 | -96.41403739 | 2022-10-07 04:23:08 | Big Stone, Minnesota, US | |
2022-10-04 | US | Oregon | Lake | 41037 | 1603 | 31 | 0 | 42.79246693 | -120.3850163 | 2022-10-05 04:23:06 | Lake, Oregon, US | |
2022-10-03 | US | Oregon | Lake | 41037 | 1603 | 31 | 0 | 42.79246693 | -120.3850163 | 2022-10-04 04:22:55 | Lake, Oregon, US | |
2022-10-02 | US | Oregon | Lake | 41037 | 1603 | 31 | 0 | 42.79246693 | -120.3850163 | 2022-10-03 04:23:11 | Lake, Oregon, US | |
2022-10-01 | US | Oregon | Lake | 41037 | 1603 | 31 | 0 | 42.79246693 | -120.3850163 | 2022-10-02 04:21:23 | Lake, Oregon, US | |
2022-09-30 | US | Oregon | Lake | 41037 | 1603 | 31 | 0 | 42.79246693 | -120.3850163 | 2022-10-01 04:23:01 | Lake, Oregon, US | |
2022-09-29 | US | Oregon | Lake | 41037 | 1603 | 31 | 0 | 42.79246693 | -120.3850163 | 2022-09-30 04:23:09 | Lake, Oregon, US | |
2022-09-28 | US | Oregon | Lake | 41037 | 1603 | 31 | 0 | 42.79246693 | -120.3850163 | 2022-09-29 04:22:34 | Lake, Oregon, US | |
2022-09-14 | US | Puerto Rico | Vieques | 72147 | 1603 | 0 | 0 | 18.123276 | -65.440971 | 2022-09-15 04:21:02 | Vieques, Puerto Rico, US | |
2022-09-13 | US | Puerto Rico | Vieques | 72147 | 1603 | 0 | 0 | 18.123276 | -65.440971 | 2022-09-14 04:20:44 | Vieques, Puerto Rico, US | |
2022-09-12 | US | Puerto Rico | Vieques | 72147 | 1603 | 0 | 0 | 18.123276 | -65.440971 | 2022-09-13 04:20:57 | Vieques, Puerto Rico, US | |
2022-09-11 | US | Puerto Rico | Vieques | 72147 | 1603 | 0 | 0 | 18.123276 | -65.440971 | 2022-09-12 04:20:58 | Vieques, Puerto Rico, US | |
2022-08-28 | US | Virginia | Cumberland | 51049 | 1603 | 28 | 0 | 37.51328851 | -78.24398086 | 2022-08-29 04:21:06 | Cumberland, Virginia, US | |
2022-08-27 | US | Virginia | Cumberland | 51049 | 1603 | 28 | 0 | 37.51328851 | -78.24398086 | 2022-08-28 04:21:02 | Cumberland, Virginia, US | |
2022-08-26 | US | Virginia | Cumberland | 51049 | 1603 | 28 | 0 | 37.51328851 | -78.24398086 | 2022-08-27 04:20:57 | Cumberland, Virginia, US | |
2022-08-25 | US | Indiana | Ohio | 18115 | 1603 | 19 | 0 | 38.955305 | -84.96515993 | 2022-08-26 04:21:02 | Ohio, Indiana, US | |
2022-08-24 | US | Indiana | Ohio | 18115 | 1603 | 19 | 0 | 38.955305 | -84.96515993 | 2022-08-25 04:21:13 | Ohio, Indiana, US | |
2022-08-21 | US | Texas | Newton | 48351 | 1603 | 62 | 0 | 30.78548982 | -93.74408813 | 2022-08-22 04:20:38 | Newton, Texas, US | |
2022-08-20 | US | Texas | Newton | 48351 | 1603 | 62 | 0 | 30.78548982 | -93.74408813 | 2022-08-21 04:20:44 | Newton, Texas, US | |
2022-08-19 | US | Texas | Newton | 48351 | 1603 | 62 | 0 | 30.78548982 | -93.74408813 | 2022-08-20 04:21:01 | Newton, Texas, US | |
2022-08-18 | US | Texas | Newton | 48351 | 1603 | 62 | 0 | 30.78548982 | -93.74408813 | 2022-08-19 04:20:54 | Newton, Texas, US | |
2022-08-16 | US | Texas | Jack | 48237 | 1603 | 29 | 0 | 33.23377248 | -98.17283469 | 2022-08-17 04:20:59 | Jack, Texas, US | |
2022-08-15 | US | Texas | Jack | 48237 | 1603 | 29 | 0 | 33.23377248 | -98.17283469 | 2022-08-16 04:20:58 | Jack, Texas, US | |
2022-07-27 | US | North Dakota | Ransom | 38073 | 1603 | 28 | 0 | 46.45621782 | -97.65742504 | 2022-07-28 04:20:56 | Ransom, North Dakota, US | |
2022-07-18 | US | Arkansas | Montgomery | 5097 | 1603 | 56 | 0 | 34.53704874 | -93.65824478 | 2022-07-19 04:20:58 | Montgomery, Arkansas, US | |
2022-07-10 | US | Kentucky | Owsley | 21189 | 1603 | 29 | 0 | 37.42823949 | -83.68811419 | 2022-07-11 04:20:46 | Owsley, Kentucky, US | |
2022-07-09 | US | Kentucky | Owsley | 21189 | 1603 | 29 | 0 | 37.42823949 | -83.68811419 | 2022-07-10 04:20:54 | Owsley, Kentucky, US | |
2022-07-08 | US | Kentucky | Owsley | 21189 | 1603 | 29 | 0 | 37.42823949 | -83.68811419 | 2022-07-09 04:20:59 | Owsley, Kentucky, US | |
2022-07-07 | US | Kentucky | Owsley | 21189 | 1603 | 29 | 0 | 37.42823949 | -83.68811419 | 2022-07-08 04:20:56 | Owsley, Kentucky, US | |
2022-07-06 | US | Kentucky | Owsley | 21189 | 1603 | 29 | 0 | 37.42823949 | -83.68811419 | 2022-07-07 04:20:55 | Owsley, Kentucky, US | |
2022-07-05 | US | Kentucky | Owsley | 21189 | 1603 | 29 | 0 | 37.42823949 | -83.68811419 | 2022-07-06 04:20:58 | Owsley, Kentucky, US | |
2022-06-21 | US | Washington | Skamania | 53059 | 1603 | 12 | 0 | 46.02408726 | -121.9164403 | 2022-06-22 04:20:54 | Skamania, Washington, US | |
2022-06-20 | US | Washington | Skamania | 53059 | 1603 | 12 | 0 | 46.02408726 | -121.9164403 | 2022-06-21 04:20:56 | Skamania, Washington, US | |
2022-06-19 | US | Washington | Skamania | 53059 | 1603 | 12 | 0 | 46.02408726 | -121.9164403 | 2022-06-20 04:21:01 | Skamania, Washington, US | |
2022-06-18 | US | Washington | Skamania | 53059 | 1603 | 12 | 0 | 46.02408726 | -121.9164403 | 2022-06-19 04:20:51 | Skamania, Washington, US | |
2022-06-17 | US | Washington | Skamania | 53059 | 1603 | 12 | 0 | 46.02408726 | -121.9164403 | 2022-06-18 04:21:10 | Skamania, Washington, US | |
2022-05-19 | US | Missouri | Shelby | 29205 | 1603 | 15 | 0 | 39.79742518 | -92.07634971 | 2022-05-20 04:20:57 | Shelby, Missouri, US | |
2022-05-18 | US | Missouri | Shelby | 29205 | 1603 | 15 | 0 | 39.79742518 | -92.07634971 | 2022-05-19 04:20:54 | Shelby, Missouri, US | |
2022-05-17 | US | Missouri | Shelby | 29205 | 1603 | 15 | 0 | 39.79742518 | -92.07634971 | 2022-05-18 04:20:50 | Shelby, Missouri, US | |
2022-05-16 | US | Missouri | Shelby | 29205 | 1603 | 15 | 0 | 39.79742518 | -92.07634971 | 2022-05-17 04:20:59 | Shelby, Missouri, US | |
2022-05-15 | US | Missouri | Shelby | 29205 | 1603 | 15 | 0 | 39.79742518 | -92.07634971 | 2022-05-16 04:20:47 | Shelby, Missouri, US | |
2022-05-14 | US | Missouri | Shelby | 29205 | 1603 | 15 | 0 | 39.79742518 | -92.07634971 | 2022-05-15 04:20:53 | Shelby, Missouri, US | |
2022-05-13 | US | Missouri | Shelby | 29205 | 1603 | 15 | 0 | 39.79742518 | -92.07634971 | 2022-05-14 04:20:48 | Shelby, Missouri, US | |
2022-04-17 | US | Oregon | Harney | 41025 | 1603 | 38 | 0 | 43.06422669 | -118.96663059999999 | 2022-04-18 04:21:12 | Harney, Oregon, US | |
2022-04-16 | US | Oregon | Harney | 41025 | 1603 | 38 | 0 | 43.06422669 | -118.96663059999999 | 2022-04-17 04:20:59 | Harney, Oregon, US | |
2022-04-15 | US | Oregon | Harney | 41025 | 1603 | 38 | 0 | 43.06422669 | -118.96663059999999 | 2022-04-16 04:20:48 | Harney, Oregon, US | |
2022-04-14 | US | Oregon | Harney | 41025 | 1603 | 38 | 0 | 43.06422669 | -118.96663059999999 | 2022-04-15 04:20:57 | Harney, Oregon, US | |
2022-03-23 | US | Missouri | Shannon | 29203 | 1603 | 38 | 0 | 37.15772072 | -91.40190382 | 2022-03-24 04:20:43 | Shannon, Missouri, US | |
2022-03-10 | US | Oregon | Grant | 41023 | 1603 | 18 | 0 | 44.49024544 | -119.0068631 | 2022-03-11 04:20:50 | Grant, Oregon, US | |
2022-03-10 | China | Beijing | 1603 | 9 | 0 | 40.1824 | 116.4142 | 2022-03-11 04:20:50 | Beijing, China | |||
2022-02-28 | US | Colorado | Clear Creek | 8019 | 1603 | 11 | 0 | 39.68864463 | -105.6463118 | 2022-03-01 04:21:09 | Clear Creek, Colorado, US | |
2022-02-16 | US | Georgia | Treutlen | 13283 | 1603 | 59 | 0 | 32.40422134 | -82.56904553 | 2022-02-17 04:20:56 | Treutlen, Georgia, US | |
2022-02-15 | US | Kansas | Wabaunsee | 20197 | 1603 | 22 | 0 | 38.95471985 | -96.20350509 | 2022-02-16 04:21:10 | Wabaunsee, Kansas, US | |
2022-02-15 | US | Georgia | Treutlen | 13283 | 1603 | 59 | 0 | 32.40422134 | -82.56904553 | 2022-02-16 04:21:10 | Treutlen, Georgia, US | |
2022-02-09 | US | Missouri | Caldwell | 29025 | 1603 | 31 | 0 | 39.65620858 | -93.98308093 | 2022-02-10 04:21:14 | Caldwell, Missouri, US | |
2022-02-05 | US | Puerto Rico | Arroyo | 72015 | 1603 | 0 | 0 | 17.998457000000005 | -66.056546 | 2022-02-06 04:21:00 | Arroyo, Puerto Rico, US | |
2022-02-04 | US | Missouri | Chariton | 29041 | 1603 | 33 | 0 | 39.51499357 | -92.9629191 | 2022-02-05 04:21:05 | Chariton, Missouri, US | |
2022-01-27 | US | Alabama | Choctaw | 1023 | 1603 | 31 | 0 | 32.02227341 | -88.26564429999998 | 2022-01-28 04:21:09 | Choctaw, Alabama, US | |
2022-01-26 | US | Alabama | Choctaw | 1023 | 1603 | 31 | 0 | 32.02227341 | -88.26564429999998 | 2022-01-27 04:21:19 | Choctaw, Alabama, US | |
2022-01-24 | US | Alabama | Choctaw | 1023 | 1603 | 31 | 0 | 32.02227341 | -88.26564429999998 | 2022-01-25 04:21:05 | Choctaw, Alabama, US | |
2022-01-23 | US | Kansas | Greenwood | 20073 | 1603 | 20 | 0 | 37.8774388 | -96.23250453 | 2022-01-24 04:21:12 | Greenwood, Kansas, US | |
2022-01-22 | US | Kansas | Greenwood | 20073 | 1603 | 20 | 0 | 37.8774388 | -96.23250453 | 2022-01-23 04:21:13 | Greenwood, Kansas, US | |
2022-01-21 | US | Kansas | Greenwood | 20073 | 1603 | 20 | 0 | 37.8774388 | -96.23250453 | 2022-01-22 04:21:13 | Greenwood, Kansas, US | |
2022-01-20 | US | Montana | Powell | 30077 | 1603 | 26 | 0 | 46.85538891 | -112.93591640000001 | 2022-01-21 04:21:09 | Powell, Montana, US | |
2022-01-02 | US | Nebraska | Holt | 31089 | 1603 | 16 | 0 | 42.45522056 | -98.78402558 | 2022-01-03 02:22:25 | Holt, Nebraska, US | |
2022-01-01 | US | Nebraska | Holt | 31089 | 1603 | 16 | 0 | 42.45522056 | -98.78402558 | 2022-01-02 04:20:52 | Holt, Nebraska, US | |
2021-12-31 | US | Nebraska | Holt | 31089 | 1603 | 16 | 0 | 42.45522056 | -98.78402558 | 2022-01-01 04:22:14 | Holt, Nebraska, US | |
2021-12-30 | US | Nebraska | Holt | 31089 | 1603 | 16 | 0 | 42.45522056 | -98.78402558 | 2021-12-31 04:21:50 | Holt, Nebraska, US | |
2021-12-29 | US | Montana | Carbon | 30009 | 1603 | 23 | 0 | 45.22850116 | -109.0274047 | 2021-12-30 04:21:25 | Carbon, Montana, US | |
2021-12-28 | US | Iowa | Palo Alto | 19147 | 1603 | 32 | 0 | 43.08193849 | -94.67824621 | 2021-12-29 03:21:43 | Palo Alto, Iowa, US | |
2021-12-27 | US | Iowa | Palo Alto | 19147 | 1603 | 32 | 0 | 43.08193849 | -94.67824621 | 2021-12-28 04:21:47 | Palo Alto, Iowa, US | |
2021-12-26 | US | Iowa | Palo Alto | 19147 | 1603 | 32 | 0 | 43.08193849 | -94.67824621 | 2021-12-27 04:21:58 | Palo Alto, Iowa, US | |
2021-12-25 | US | Iowa | Palo Alto | 19147 | 1603 | 32 | 0 | 43.08193849 | -94.67824621 | 2021-12-26 04:21:50 | Palo Alto, Iowa, US | |
2021-12-24 | US | Iowa | Palo Alto | 19147 | 1603 | 32 | 0 | 43.08193849 | -94.67824621 | 2021-12-25 04:21:37 | Palo Alto, Iowa, US | |
2021-12-23 | US | Iowa | Palo Alto | 19147 | 1603 | 32 | 0 | 43.08193849 | -94.67824621 | 2021-12-24 04:21:34 | Palo Alto, Iowa, US | |
2021-12-22 | US | Iowa | Palo Alto | 19147 | 1603 | 32 | 0 | 43.08193849 | -94.67824621 | 2021-12-23 04:21:21 | Palo Alto, Iowa, US | |
2021-12-16 | US | Kentucky | Hancock | 21091 | 1603 | 18 | 0 | 37.83766422 | -86.78280584 | 2021-12-17 04:22:14 | Hancock, Kentucky, US | |
2021-12-14 | US | Virginia | Sussex | 51183 | 1603 | 29 | 0 | 36.92432914 | -77.25791182 | 2021-12-15 03:22:16 | Sussex, Virginia, US | |
2021-12-13 | US | Virginia | Sussex | 51183 | 1603 | 29 | 0 | 36.92432914 | -77.25791182 | 2021-12-14 04:22:38 | Sussex, Virginia, US | |
2021-12-12 | US | Georgia | Stewart | 13259 | 1603 | 29 | 0 | 32.07996777 | -84.83208037 | 2021-12-13 04:22:02 | Stewart, Georgia, US | |
2021-12-11 | US | Georgia | Stewart | 13259 | 1603 | 29 | 0 | 32.07996777 | -84.83208037 | 2021-12-12 04:22:12 | Stewart, Georgia, US | |
2021-12-10 | US | Georgia | Stewart | 13259 | 1603 | 29 | 0 | 32.07996777 | -84.83208037 | 2021-12-11 04:22:45 | Stewart, Georgia, US | |
2021-12-09 | US | West Virginia | Ritchie | 54085 | 1603 | 22 | 0 | 39.18094587 | -81.06356878 | 2021-12-10 04:22:28 | Ritchie, West Virginia, US | |
2021-11-29 | US | Missouri | Montgomery | 29139 | 1603 | 22 | 0 | 38.94022054 | -91.47000721 | 2021-11-30 04:22:53 | Montgomery, Missouri, US | |
2021-11-21 | US | Minnesota | Stevens | 27149 | 1603 | 11 | 0 | 45.58613007 | -96.00163705 | 2021-11-22 04:22:20 | Stevens, Minnesota, US | |
2021-11-20 | US | Minnesota | Stevens | 27149 | 1603 | 11 | 0 | 45.58613007 | -96.00163705 | 2021-11-21 04:22:13 | Stevens, Minnesota, US | |
2021-11-19 | US | Minnesota | Stevens | 27149 | 1603 | 11 | 0 | 45.58613007 | -96.00163705 | 2021-11-20 04:22:17 | Stevens, Minnesota, US | |
2021-11-17 | US | Wisconsin | Forest | 55041 | 1603 | 33 | 0 | 45.66678019 | -88.77084892 | 2021-11-18 04:21:33 | Forest, Wisconsin, US | |
2021-11-15 | China | Jiangsu | 1603 | 0 | 0 | 32.9711 | 119.455 | 2021-11-16 04:21:10 | Jiangsu, China | |||
2021-11-14 | China | Jiangsu | 1603 | 0 | 0 | 32.9711 | 119.455 | 2021-11-15 04:21:36 | Jiangsu, China | |||
2021-11-13 | China | Jiangsu | 1603 | 0 | 0 | 32.9711 | 119.455 | 2021-11-14 04:21:31 | Jiangsu, China | |||
2021-11-12 | China | Jiangsu | 1603 | 0 | 0 | 32.9711 | 119.455 | 2021-11-13 04:21:38 | Jiangsu, China | |||
2021-11-11 | China | Jiangsu | 1603 | 0 | 0 | 32.9711 | 119.455 | 2021-11-12 04:22:01 | Jiangsu, China | |||
2021-11-10 | China | Jiangsu | 1603 | 0 | 0 | 32.9711 | 119.455 | 2021-11-11 04:21:45 | Jiangsu, China |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;