daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
213 rows where confirmed = 3419 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-10 | US | Colorado | Archuleta | 8007 | 3419 | 22 | 0 | 37.19474156 | -107.0476867 | 2022-11-11 04:21:22 | Archuleta, Colorado, US | |
2022-11-06 | US | Texas | Camp | 48063 | 3419 | 77 | 0 | 32.97195142 | -94.97790104 | 2022-11-07 04:21:26 | Camp, Texas, US | |
2022-11-05 | US | Texas | Camp | 48063 | 3419 | 77 | 0 | 32.97195142 | -94.97790104 | 2022-11-06 04:21:24 | Camp, Texas, US | |
2022-11-04 | US | Texas | Camp | 48063 | 3419 | 77 | 0 | 32.97195142 | -94.97790104 | 2022-11-05 04:21:52 | Camp, Texas, US | |
2022-10-19 | US | Oklahoma | Noble | 40103 | 3419 | 43 | 0 | 36.38953329 | -97.22928674 | 2022-10-20 04:22:59 | Noble, Oklahoma, US | |
2022-10-18 | US | Oklahoma | Noble | 40103 | 3419 | 43 | 0 | 36.38953329 | -97.22928674 | 2022-10-19 04:22:26 | Noble, Oklahoma, US | |
2022-10-18 | US | Idaho | Idaho | 16049 | 3419 | 57 | 0 | 45.84721541 | -115.4634436 | 2022-10-19 04:22:26 | Idaho, Idaho, US | |
2022-10-17 | US | Oklahoma | Noble | 40103 | 3419 | 43 | 0 | 36.38953329 | -97.22928674 | 2022-10-18 04:22:42 | Noble, Oklahoma, US | |
2022-10-17 | US | Idaho | Idaho | 16049 | 3419 | 57 | 0 | 45.84721541 | -115.4634436 | 2022-10-18 04:22:42 | Idaho, Idaho, US | |
2022-10-16 | US | Oklahoma | Noble | 40103 | 3419 | 43 | 0 | 36.38953329 | -97.22928674 | 2022-10-17 04:20:31 | Noble, Oklahoma, US | |
2022-10-16 | US | Idaho | Idaho | 16049 | 3419 | 57 | 0 | 45.84721541 | -115.4634436 | 2022-10-17 04:20:31 | Idaho, Idaho, US | |
2022-10-15 | US | Oklahoma | Noble | 40103 | 3419 | 43 | 0 | 36.38953329 | -97.22928674 | 2022-10-16 04:22:39 | Noble, Oklahoma, US | |
2022-10-15 | US | Idaho | Idaho | 16049 | 3419 | 57 | 0 | 45.84721541 | -115.4634436 | 2022-10-16 04:22:39 | Idaho, Idaho, US | |
2022-10-14 | US | Oklahoma | Noble | 40103 | 3419 | 43 | 0 | 36.38953329 | -97.22928674 | 2022-10-15 04:22:00 | Noble, Oklahoma, US | |
2022-10-14 | US | North Dakota | Barnes | 38003 | 3419 | 47 | 0 | 46.93579637 | -98.06605978 | 2022-10-15 04:22:00 | Barnes, North Dakota, US | |
2022-10-14 | US | Idaho | Idaho | 16049 | 3419 | 57 | 0 | 45.84721541 | -115.4634436 | 2022-10-15 04:22:00 | Idaho, Idaho, US | |
2022-10-13 | US | Oklahoma | Noble | 40103 | 3419 | 43 | 0 | 36.38953329 | -97.22928674 | 2022-10-14 04:22:28 | Noble, Oklahoma, US | |
2022-10-11 | US | Texas | Pecos | 48371 | 3419 | 72 | 0 | 30.78097267 | -102.7241261 | 2022-10-12 04:22:51 | Pecos, Texas, US | |
2022-10-10 | US | Texas | Pecos | 48371 | 3419 | 72 | 0 | 30.78097267 | -102.7241261 | 2022-10-11 04:23:05 | Pecos, Texas, US | |
2022-10-07 | China | Inner Mongolia | 3419 | 1 | 0 | 44.0935 | 113.9448 | 2022-10-08 04:22:56 | Inner Mongolia, China | |||
2022-09-12 | US | Arkansas | Bradley | 5011 | 3419 | 54 | 0 | 33.46755808 | -92.15980837 | 2022-09-13 04:20:57 | Bradley, Arkansas, US | |
2022-08-22 | US | Mississippi | Perry | 28111 | 3419 | 64 | 0 | 31.17161885 | -88.99281835 | 2022-08-23 04:20:56 | Perry, Mississippi, US | |
2022-08-21 | US | Mississippi | Perry | 28111 | 3419 | 64 | 0 | 31.17161885 | -88.99281835 | 2022-08-22 04:20:38 | Perry, Mississippi, US | |
2022-08-20 | US | Mississippi | Perry | 28111 | 3419 | 64 | 0 | 31.17161885 | -88.99281835 | 2022-08-21 04:20:44 | Perry, Mississippi, US | |
2022-08-19 | US | Mississippi | Perry | 28111 | 3419 | 64 | 0 | 31.17161885 | -88.99281835 | 2022-08-20 04:21:01 | Perry, Mississippi, US | |
2022-08-18 | US | Mississippi | Perry | 28111 | 3419 | 64 | 0 | 31.17161885 | -88.99281835 | 2022-08-19 04:20:54 | Perry, Mississippi, US | |
2022-08-17 | US | Mississippi | Perry | 28111 | 3419 | 64 | 0 | 31.17161885 | -88.99281835 | 2022-08-18 04:21:11 | Perry, Mississippi, US | |
2022-08-16 | US | Mississippi | Perry | 28111 | 3419 | 64 | 0 | 31.17161885 | -88.99281835 | 2022-08-17 04:20:59 | Perry, Mississippi, US | |
2022-08-15 | US | Mississippi | Perry | 28111 | 3419 | 64 | 0 | 31.17161885 | -88.99281835 | 2022-08-16 04:20:58 | Perry, Mississippi, US | |
2022-07-18 | US | Louisiana | Madison | 22065 | 3419 | 58 | 0 | 32.36918118 | -91.23973355 | 2022-07-19 04:20:58 | Madison, Louisiana, US | |
2022-07-17 | US | Tennessee | Stewart | 47161 | 3419 | 63 | 0 | 36.50235092 | -87.83920548 | 2022-07-18 04:20:59 | Stewart, Tennessee, US | |
2022-07-16 | US | Tennessee | Stewart | 47161 | 3419 | 63 | 0 | 36.50235092 | -87.83920548 | 2022-07-17 04:21:15 | Stewart, Tennessee, US | |
2022-06-16 | US | Puerto Rico | Jayuya | 72073 | 3419 | 0 | 0 | 18.211446 | -66.58878 | 2022-06-17 04:20:56 | Jayuya, Puerto Rico, US | |
2022-06-12 | US | Puerto Rico | Luquillo | 72089 | 3419 | 0 | 0 | 18.342114 | -65.725097 | 2022-06-13 04:21:14 | Luquillo, Puerto Rico, US | |
2022-06-09 | US | Virginia | Greensville | 51081 | 3419 | 40 | 0 | 36.67878901 | -77.56351439 | 2022-06-10 04:20:55 | Greensville, Virginia, US | |
2022-06-08 | US | Virginia | Alleghany | 51005 | 3419 | 97 | 0 | 37.78636074 | -80.00222498 | 2022-06-09 04:20:54 | Alleghany, Virginia, US | |
2022-05-30 | US | Arkansas | Marion | 5089 | 3419 | 89 | 0 | 36.26844485 | -92.68451899 | 2022-05-31 04:20:51 | Marion, Arkansas, US | |
2022-05-19 | US | Texas | Duval | 48131 | 3419 | 70 | 0 | 27.68184592 | -98.50864568 | 2022-05-20 04:20:57 | Duval, Texas, US | |
2022-05-10 | US | Tennessee | Meigs | 47121 | 3419 | 58 | 0 | 35.51558739 | -84.81482914 | 2022-05-11 04:20:48 | Meigs, Tennessee, US | |
2022-04-20 | US | Wisconsin | Rusk | 55107 | 3419 | 54 | 0 | 45.47498854 | -91.1333012 | 2022-04-21 04:20:46 | Rusk, Wisconsin, US | |
2022-04-06 | US | Kentucky | Unassigned | 90021 | 3419 | 45 | 0 | 38.97065142 | 0.0 | 2022-04-07 04:20:53 | Unassigned, Kentucky, US | |
2022-04-03 | US | North Carolina | Mitchell | 37121 | 3419 | 34 | 0 | 36.01059309 | -82.1582442 | 2022-04-04 04:20:51 | Mitchell, North Carolina, US | |
2022-04-02 | US | North Carolina | Mitchell | 37121 | 3419 | 34 | 0 | 36.01059309 | -82.1582442 | 2022-04-03 04:20:48 | Mitchell, North Carolina, US | |
2022-04-01 | US | North Carolina | Mitchell | 37121 | 3419 | 34 | 0 | 36.01059309 | -82.1582442 | 2022-04-02 04:20:47 | Mitchell, North Carolina, US | |
2022-03-23 | US | Illinois | Washington | 17189 | 3419 | 35 | 0 | 38.35309213 | -89.40982703 | 2022-03-24 04:20:43 | Washington, Illinois, US | |
2022-03-09 | US | Colorado | Gunnison | 8051 | 3419 | 14 | 0 | 38.66611652 | -107.0320729 | 2022-03-10 04:20:48 | Gunnison, Colorado, US | |
2022-03-08 | US | Colorado | Gunnison | 8051 | 3419 | 14 | 0 | 38.66611652 | -107.0320729 | 2022-03-09 04:20:59 | Gunnison, Colorado, US | |
2022-03-07 | US | Wisconsin | Buffalo | 55011 | 3419 | 12 | 0 | 44.37835084 | -91.75332578 | 2022-03-08 04:20:54 | Buffalo, Wisconsin, US | |
2022-02-21 | US | Arkansas | Van Buren | 5141 | 3419 | 55 | 0 | 35.58095779 | -92.51295036 | 2022-02-22 04:21:01 | Van Buren, Arkansas, US | |
2022-02-20 | US | Kentucky | Green | 21087 | 3419 | 37 | 0 | 37.26484328 | -85.5540745 | 2022-02-21 04:21:05 | Green, Kentucky, US | |
2022-02-20 | US | Arkansas | Van Buren | 5141 | 3419 | 55 | 0 | 35.58095779 | -92.51295036 | 2022-02-21 04:21:05 | Van Buren, Arkansas, US | |
2022-02-19 | US | Kentucky | Green | 21087 | 3419 | 37 | 0 | 37.26484328 | -85.5540745 | 2022-02-20 04:21:00 | Green, Kentucky, US | |
2022-02-18 | US | Kentucky | Green | 21087 | 3419 | 37 | 0 | 37.26484328 | -85.5540745 | 2022-02-19 04:21:11 | Green, Kentucky, US | |
2022-02-06 | US | Michigan | Manistee | 26101 | 3419 | 75 | 0 | 44.33352407 | -86.05626916 | 2022-02-07 04:21:05 | Manistee, Michigan, US | |
2022-02-05 | US | Michigan | Manistee | 26101 | 3419 | 75 | 0 | 44.33352407 | -86.05626916 | 2022-02-06 04:21:00 | Manistee, Michigan, US | |
2022-02-04 | US | Michigan | Manistee | 26101 | 3419 | 75 | 0 | 44.33352407 | -86.05626916 | 2022-02-05 04:21:05 | Manistee, Michigan, US | |
2022-02-01 | US | Texas | Colorado | 48089 | 3419 | 57 | 0 | 29.622097999999998 | -96.5273805 | 2022-02-02 04:21:09 | Colorado, Texas, US | |
2022-01-20 | US | Maine | Lincoln | 23015 | 3419 | 19 | 0 | 44.05996956 | -69.54227124 | 2022-01-21 04:21:09 | Lincoln, Maine, US | |
2022-01-19 | US | Puerto Rico | Catano | 72033 | 3419 | 0 | 0 | 18.437269 | -66.14330600000001 | 2022-01-20 04:21:07 | Catano, Puerto Rico, US | |
2022-01-13 | US | North Carolina | Northampton | 37131 | 3419 | 66 | 0 | 36.41736238 | -77.39769443 | 2022-01-14 04:21:54 | Northampton, North Carolina, US | |
2022-01-12 | US | Minnesota | Houston | 27055 | 3419 | 18 | 0 | 43.67129565 | -91.49143057 | 2022-01-13 08:00:09 | Houston, Minnesota, US | |
2022-01-10 | US | West Virginia | Barbour | 54001 | 3419 | 56 | 0 | 39.1307219 | -80.00350858 | 2022-01-11 04:22:01 | Barbour, West Virginia, US | |
2022-01-05 | US | Tennessee | Trousdale | 47169 | 3419 | 36 | 0 | 36.39026213 | -86.16087954 | 2022-01-06 04:22:09 | Trousdale, Tennessee, US | |
2022-01-04 | US | Minnesota | Roseau | 27135 | 3419 | 37 | 0 | 48.77501878 | -95.81079919 | 2022-01-05 04:21:59 | Roseau, Minnesota, US | |
2021-12-24 | China | Guangdong | 3419 | 8 | 0 | 23.3417 | 113.4244 | 2021-12-25 04:21:37 | Guangdong, China | |||
2021-12-23 | US | Arkansas | Conway | 5029 | 3419 | 48 | 0 | 35.26205537 | -92.70506566 | 2021-12-24 04:21:34 | Conway, Arkansas, US | |
2021-12-22 | US | Wisconsin | Iowa | 55049 | 3419 | 23 | 0 | 43.00050278 | -90.13469017 | 2021-12-23 04:21:21 | Iowa, Wisconsin, US | |
2021-12-21 | US | New York | Essex | 36031 | 3419 | 45 | 0 | 44.11630765 | -73.77297842 | 2021-12-22 04:21:54 | Essex, New York, US | |
2021-12-16 | US | North Carolina | Caswell | 37033 | 3419 | 39 | 0 | 36.39312665 | -79.33353281 | 2021-12-17 04:22:14 | Caswell, North Carolina, US | |
2021-12-15 | US | Tennessee | Humphreys | 47085 | 3419 | 50 | 0 | 36.03958805 | -87.77992872 | 2021-12-16 04:22:11 | Humphreys, Tennessee, US | |
2021-12-11 | US | Texas | Milam | 48331 | 3419 | 91 | 0 | 30.78581830000001 | -96.97718698 | 2021-12-12 04:22:12 | Milam, Texas, US | |
2021-12-07 | US | North Carolina | Greene | 37079 | 3419 | 56 | 0 | 35.48544173 | -77.67578087 | 2021-12-08 04:22:46 | Greene, North Carolina, US | |
2021-12-02 | US | Arkansas | Columbia | 5027 | 3419 | 75 | 0 | 33.21230701 | -93.22642793 | 2021-12-03 04:23:05 | Columbia, Arkansas, US | |
2021-11-23 | US | Ohio | Carroll | 39019 | 3419 | 82 | 0 | 40.578968599999996 | -81.09178213 | 2021-11-24 04:22:14 | Carroll, Ohio, US | |
2021-11-23 | US | Indiana | Starke | 18149 | 3419 | 72 | 0 | 41.27890281 | -86.64686895 | 2021-11-24 04:22:14 | Starke, Indiana, US | |
2021-11-22 | US | Indiana | Sullivan | 18153 | 3419 | 54 | 0 | 39.08952258 | -87.41414469 | 2021-11-23 04:22:39 | Sullivan, Indiana, US | |
2021-11-21 | US | Virginia | Dinwiddie | 51053 | 3419 | 58 | 0 | 37.07544585 | -77.63451754 | 2021-11-22 04:22:20 | Dinwiddie, Virginia, US | |
2021-11-20 | US | Virginia | Dinwiddie | 51053 | 3419 | 58 | 0 | 37.07544585 | -77.63451754 | 2021-11-21 04:22:13 | Dinwiddie, Virginia, US | |
2021-11-20 | US | Alabama | Butler | 1013 | 3419 | 100 | 0 | 31.75300095 | -86.68057478 | 2021-11-21 04:22:13 | Butler, Alabama, US | |
2021-11-19 | US | Virginia | Dinwiddie | 51053 | 3419 | 58 | 0 | 37.07544585 | -77.63451754 | 2021-11-20 04:22:17 | Dinwiddie, Virginia, US | |
2021-11-09 | US | Arkansas | Ouachita | 5103 | 3419 | 85 | 0 | 33.58839816 | -92.87795984 | 2021-11-10 04:21:38 | Ouachita, Arkansas, US | |
2021-11-08 | US | Arkansas | Ouachita | 5103 | 3419 | 85 | 0 | 33.58839816 | -92.87795984 | 2021-11-09 04:21:36 | Ouachita, Arkansas, US | |
2021-11-07 | US | Vermont | Bennington | 50003 | 3419 | 27 | 0 | 43.03519828 | -73.09048868 | 2021-11-08 04:21:43 | Bennington, Vermont, US | |
2021-11-07 | US | Arkansas | Ouachita | 5103 | 3419 | 85 | 0 | 33.58839816 | -92.87795984 | 2021-11-08 04:21:43 | Ouachita, Arkansas, US | |
2021-11-06 | US | Arkansas | Ouachita | 5103 | 3419 | 85 | 0 | 33.58839816 | -92.87795984 | 2021-11-07 04:21:53 | Ouachita, Arkansas, US | |
2021-10-22 | US | Indiana | Spencer | 18147 | 3419 | 43 | 0 | 38.01519732 | -87.0079644 | 2021-10-23 04:21:32 | Spencer, Indiana, US | |
2021-10-11 | US | Montana | Lake | 30047 | 3419 | 55 | 0 | 47.64514965 | -114.0898013 | 2021-10-12 04:21:09 | Lake, Montana, US | |
2021-10-10 | US | West Virginia | Wyoming | 54109 | 3419 | 54 | 0 | 37.612327 | -81.54511071 | 2021-10-11 04:21:31 | Wyoming, West Virginia, US | |
2021-10-10 | US | Montana | Lake | 30047 | 3419 | 55 | 0 | 47.64514965 | -114.0898013 | 2021-10-11 04:21:31 | Lake, Montana, US | |
2021-10-09 | US | Montana | Lake | 30047 | 3419 | 55 | 0 | 47.64514965 | -114.0898013 | 2021-10-10 04:21:38 | Lake, Montana, US | |
2021-10-08 | US | Montana | Lake | 30047 | 3419 | 55 | 0 | 47.64514965 | -114.0898013 | 2021-10-09 04:21:34 | Lake, Montana, US | |
2021-09-27 | US | Arkansas | Logan | 5083 | 3419 | 34 | 0 | 35.21413234 | -93.71951016 | 2021-09-28 04:21:28 | Logan, Arkansas, US | |
2021-09-24 | US | Kentucky | Letcher | 21133 | 3419 | 54 | 0 | 37.12306748 | -82.85346474 | 2021-09-25 04:21:31 | Letcher, Kentucky, US | |
2021-09-22 | US | Alabama | Barbour | 1005 | 3419 | 68 | 0 | 31.868263 | -85.3871286 | 2021-09-23 04:21:43 | Barbour, Alabama, US | |
2021-09-19 | US | Kansas | Labette | 20099 | 3419 | 59 | 0 | 37.19113093 | -95.29849679 | 2021-09-20 04:21:22 | Labette, Kansas, US | |
2021-09-18 | US | Tennessee | Morgan | 47129 | 3419 | 41 | 0 | 36.13248031 | -84.64880098 | 2021-09-19 04:21:34 | Morgan, Tennessee, US | |
2021-09-18 | US | New York | Franklin | 36033 | 3419 | 15 | 0 | 44.59040891 | -74.29926032 | 2021-09-19 04:21:34 | Franklin, New York, US | |
2021-09-18 | US | Kansas | Labette | 20099 | 3419 | 59 | 0 | 37.19113093 | -95.29849679 | 2021-09-19 04:21:34 | Labette, Kansas, US | |
2021-09-17 | US | Kansas | Labette | 20099 | 3419 | 59 | 0 | 37.19113093 | -95.29849679 | 2021-09-18 04:21:24 | Labette, Kansas, US | |
2021-09-15 | US | North Carolina | Anson | 37007 | 3419 | 65 | 0 | 34.97403241 | -80.09953279 | 2021-09-16 04:22:19 | Anson, North Carolina, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;