daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
199 rows where confirmed = 3507 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-27 | US | Idaho | Idaho | 16049 | 3507 | 58 | 0 | 45.84721541 | -115.4634436 | 2022-12-28 04:21:04 | Idaho, Idaho, US | |
2022-12-26 | US | Idaho | Idaho | 16049 | 3507 | 58 | 0 | 45.84721541 | -115.4634436 | 2022-12-27 04:21:07 | Idaho, Idaho, US | |
2022-12-25 | US | Idaho | Idaho | 16049 | 3507 | 58 | 0 | 45.84721541 | -115.4634436 | 2022-12-26 04:21:06 | Idaho, Idaho, US | |
2022-12-24 | US | Idaho | Idaho | 16049 | 3507 | 58 | 0 | 45.84721541 | -115.4634436 | 2022-12-25 04:21:04 | Idaho, Idaho, US | |
2022-12-23 | US | Idaho | Idaho | 16049 | 3507 | 58 | 0 | 45.84721541 | -115.4634436 | 2022-12-24 04:21:02 | Idaho, Idaho, US | |
2022-12-22 | US | Idaho | Idaho | 16049 | 3507 | 58 | 0 | 45.84721541 | -115.4634436 | 2022-12-23 04:21:04 | Idaho, Idaho, US | |
2022-12-21 | US | Idaho | Idaho | 16049 | 3507 | 58 | 0 | 45.84721541 | -115.4634436 | 2022-12-22 04:20:56 | Idaho, Idaho, US | |
2022-12-19 | US | Colorado | Rio Grande | 8105 | 3507 | 46 | 0 | 37.5836865 | -106.3847838 | 2022-12-20 04:21:04 | Rio Grande, Colorado, US | |
2022-12-12 | US | North Dakota | Barnes | 38003 | 3507 | 47 | 0 | 46.93579637 | -98.06605978 | 2022-12-13 04:21:01 | Barnes, North Dakota, US | |
2022-12-06 | US | Colorado | Crowley | 8025 | 3507 | 32 | 0 | 38.32608609 | -103.7844965 | 2022-12-07 04:20:58 | Crowley, Colorado, US | |
2022-11-11 | US | Puerto Rico | Guanica | 72055 | 3507 | 0 | 0 | 17.982429 | -66.919643 | 2022-11-12 04:20:41 | Guanica, Puerto Rico, US | |
2022-10-28 | China | Henan | 3507 | 22 | 0 | 33.882 | 113.614 | 2022-10-29 04:21:13 | Henan, China | |||
2022-10-27 | China | Henan | 3507 | 22 | 0 | 33.882 | 113.614 | 2022-10-28 04:22:31 | Henan, China | |||
2022-10-17 | US | Wyoming | Converse | 56009 | 3507 | 56 | 0 | 42.97272268 | -105.5081848 | 2022-10-18 04:22:42 | Converse, Wyoming, US | |
2022-10-16 | US | Wyoming | Converse | 56009 | 3507 | 56 | 0 | 42.97272268 | -105.5081848 | 2022-10-17 04:20:31 | Converse, Wyoming, US | |
2022-10-15 | US | Wyoming | Converse | 56009 | 3507 | 56 | 0 | 42.97272268 | -105.5081848 | 2022-10-16 04:22:39 | Converse, Wyoming, US | |
2022-10-14 | US | Wyoming | Converse | 56009 | 3507 | 56 | 0 | 42.97272268 | -105.5081848 | 2022-10-15 04:22:00 | Converse, Wyoming, US | |
2022-10-13 | US | Wyoming | Converse | 56009 | 3507 | 56 | 0 | 42.97272268 | -105.5081848 | 2022-10-14 04:22:28 | Converse, Wyoming, US | |
2022-10-12 | US | Wyoming | Converse | 56009 | 3507 | 56 | 0 | 42.97272268 | -105.5081848 | 2022-10-13 04:22:39 | Converse, Wyoming, US | |
2022-10-12 | US | Alabama | Coosa | 1037 | 3507 | 62 | 0 | 32.93690146 | -86.24847739 | 2022-10-13 04:22:39 | Coosa, Alabama, US | |
2022-10-11 | US | Wyoming | Converse | 56009 | 3507 | 56 | 0 | 42.97272268 | -105.5081848 | 2022-10-12 04:22:51 | Converse, Wyoming, US | |
2022-10-11 | US | Alabama | Coosa | 1037 | 3507 | 62 | 0 | 32.93690146 | -86.24847739 | 2022-10-12 04:22:51 | Coosa, Alabama, US | |
2022-10-10 | US | Alabama | Coosa | 1037 | 3507 | 62 | 0 | 32.93690146 | -86.24847739 | 2022-10-11 04:23:05 | Coosa, Alabama, US | |
2022-10-09 | US | Alabama | Coosa | 1037 | 3507 | 62 | 0 | 32.93690146 | -86.24847739 | 2022-10-10 04:22:32 | Coosa, Alabama, US | |
2022-10-08 | US | Alabama | Coosa | 1037 | 3507 | 62 | 0 | 32.93690146 | -86.24847739 | 2022-10-09 04:21:16 | Coosa, Alabama, US | |
2022-10-07 | US | Alabama | Coosa | 1037 | 3507 | 62 | 0 | 32.93690146 | -86.24847739 | 2022-10-08 04:22:56 | Coosa, Alabama, US | |
2022-10-06 | US | Alabama | Coosa | 1037 | 3507 | 62 | 0 | 32.93690146 | -86.24847739 | 2022-10-07 04:23:08 | Coosa, Alabama, US | |
2022-08-23 | US | Kansas | Nemaha | 20131 | 3507 | 60 | 0 | 39.78345387 | -96.01392079 | 2022-08-24 04:20:46 | Nemaha, Kansas, US | |
2022-08-22 | US | Kansas | Nemaha | 20131 | 3507 | 60 | 0 | 39.78345387 | -96.01392079 | 2022-08-23 04:20:56 | Nemaha, Kansas, US | |
2022-08-21 | US | Kansas | Nemaha | 20131 | 3507 | 60 | 0 | 39.78345387 | -96.01392079 | 2022-08-22 04:20:38 | Nemaha, Kansas, US | |
2022-08-20 | US | Kansas | Nemaha | 20131 | 3507 | 60 | 0 | 39.78345387 | -96.01392079 | 2022-08-21 04:20:44 | Nemaha, Kansas, US | |
2022-08-19 | US | Kansas | Nemaha | 20131 | 3507 | 60 | 0 | 39.78345387 | -96.01392079 | 2022-08-20 04:21:01 | Nemaha, Kansas, US | |
2022-08-18 | US | Kansas | Nemaha | 20131 | 3507 | 60 | 0 | 39.78345387 | -96.01392079 | 2022-08-19 04:20:54 | Nemaha, Kansas, US | |
2022-08-17 | US | Kansas | Nemaha | 20131 | 3507 | 60 | 0 | 39.78345387 | -96.01392079 | 2022-08-18 04:21:11 | Nemaha, Kansas, US | |
2022-07-31 | US | Louisiana | Madison | 22065 | 3507 | 58 | 0 | 32.36918118 | -91.23973355 | 2022-08-01 04:21:03 | Madison, Louisiana, US | |
2022-07-30 | US | Louisiana | Madison | 22065 | 3507 | 58 | 0 | 32.36918118 | -91.23973355 | 2022-07-31 04:21:02 | Madison, Louisiana, US | |
2022-07-29 | US | Louisiana | Madison | 22065 | 3507 | 58 | 0 | 32.36918118 | -91.23973355 | 2022-07-30 04:20:42 | Madison, Louisiana, US | |
2022-07-18 | US | Mississippi | Webster | 28155 | 3507 | 70 | 0 | 33.61300486 | -89.28392912 | 2022-07-19 04:20:58 | Webster, Mississippi, US | |
2022-07-17 | US | Mississippi | Webster | 28155 | 3507 | 70 | 0 | 33.61300486 | -89.28392912 | 2022-07-18 04:20:59 | Webster, Mississippi, US | |
2022-07-16 | US | Mississippi | Webster | 28155 | 3507 | 70 | 0 | 33.61300486 | -89.28392912 | 2022-07-17 04:21:15 | Webster, Mississippi, US | |
2022-07-15 | US | Mississippi | Webster | 28155 | 3507 | 70 | 0 | 33.61300486 | -89.28392912 | 2022-07-16 04:21:05 | Webster, Mississippi, US | |
2022-07-14 | US | Mississippi | Webster | 28155 | 3507 | 70 | 0 | 33.61300486 | -89.28392912 | 2022-07-15 04:20:53 | Webster, Mississippi, US | |
2022-07-13 | US | Mississippi | Webster | 28155 | 3507 | 70 | 0 | 33.61300486 | -89.28392912 | 2022-07-14 04:20:57 | Webster, Mississippi, US | |
2022-07-12 | US | Mississippi | Webster | 28155 | 3507 | 70 | 0 | 33.61300486 | -89.28392912 | 2022-07-13 04:20:58 | Webster, Mississippi, US | |
2022-07-11 | US | Mississippi | Webster | 28155 | 3507 | 70 | 0 | 33.61300486 | -89.28392912 | 2022-07-12 04:20:51 | Webster, Mississippi, US | |
2022-06-19 | US | Puerto Rico | Arroyo | 72015 | 3507 | 0 | 0 | 17.998457 | -66.056546 | 2022-06-20 04:21:01 | Arroyo, Puerto Rico, US | |
2022-06-18 | US | Puerto Rico | Luquillo | 72089 | 3507 | 0 | 0 | 18.342114 | -65.725097 | 2022-06-19 04:20:51 | Luquillo, Puerto Rico, US | |
2022-06-06 | US | Texas | Wilbarger | 48487 | 3507 | 87 | 0 | 34.07945812 | -99.24178437 | 2022-06-07 04:21:08 | Wilbarger, Texas, US | |
2022-04-19 | US | Puerto Rico | Lares | 72081 | 3507 | 0 | 0 | 18.269035000000002 | -66.867236 | 2022-04-20 04:20:45 | Lares, Puerto Rico, US | |
2022-04-19 | US | Minnesota | Kanabec | 27065 | 3507 | 55 | 0 | 45.9459309 | -93.29275192 | 2022-04-20 04:20:45 | Kanabec, Minnesota, US | |
2022-04-17 | US | Washington | Klickitat | 53039 | 3507 | 45 | 0 | 45.87325839 | -120.7913598 | 2022-04-18 04:21:12 | Klickitat, Washington, US | |
2022-04-16 | US | Washington | Klickitat | 53039 | 3507 | 45 | 0 | 45.87325839 | -120.7913598 | 2022-04-17 04:20:59 | Klickitat, Washington, US | |
2022-04-15 | US | Washington | Klickitat | 53039 | 3507 | 45 | 0 | 45.87325839 | -120.7913598 | 2022-04-16 04:20:48 | Klickitat, Washington, US | |
2022-04-12 | US | Wisconsin | Buffalo | 55011 | 3507 | 12 | 0 | 44.37835084 | -91.75332578 | 2022-04-13 04:21:03 | Buffalo, Wisconsin, US | |
2022-03-15 | US | Puerto Rico | Quebradillas | 72115 | 3507 | 0 | 0 | 18.439692 | -66.926113 | 2022-03-16 04:20:50 | Quebradillas, Puerto Rico, US | |
2022-02-26 | US | Texas | Bandera | 48019 | 3507 | 74 | 0 | 29.74619598 | -99.24598147 | 2022-02-27 04:21:04 | Bandera, Texas, US | |
2022-02-14 | US | Oregon | Tillamook | 41057 | 3507 | 57 | 0 | 45.46248721 | -123.712066 | 2022-02-15 04:21:09 | Tillamook, Oregon, US | |
2022-02-10 | US | Virginia | Appomattox | 51011 | 3507 | 48 | 0 | 37.37569884 | -78.81340003 | 2022-02-11 04:21:09 | Appomattox, Virginia, US | |
2022-02-01 | US | New Jersey | Unassigned | 90034 | 3507 | 0 | 0 | 41.13891592 | 0.0 | 2022-02-02 04:21:09 | Unassigned, New Jersey, US | |
2022-01-25 | US | Texas | Falls | 48145 | 3507 | 55 | 0 | 31.25350609 | -96.93630086 | 2022-01-26 04:21:07 | Falls, Texas, US | |
2022-01-16 | US | West Virginia | Hardy | 54031 | 3507 | 41 | 0 | 39.00683177 | -78.85855301 | 2022-01-17 04:21:08 | Hardy, West Virginia, US | |
2022-01-13 | US | Michigan | Antrim | 26009 | 3507 | 52 | 0 | 44.99690221 | -85.15503082 | 2022-01-14 04:21:54 | Antrim, Michigan, US | |
2022-01-12 | US | Michigan | Antrim | 26009 | 3507 | 52 | 0 | 44.99690221 | -85.15503082 | 2022-01-13 08:00:09 | Antrim, Michigan, US | |
2022-01-04 | US | Virginia | Powhatan | 51145 | 3507 | 31 | 0 | 37.55016038 | -77.91267882 | 2022-01-05 04:21:59 | Powhatan, Virginia, US | |
2022-01-02 | US | Wisconsin | Sawyer | 55113 | 3507 | 49 | 0 | 45.87931905 | -91.14504927 | 2022-01-03 02:22:25 | Sawyer, Wisconsin, US | |
2022-01-02 | US | West Virginia | McDowell | 54047 | 3507 | 56 | 0 | 37.38002939 | -81.65083669 | 2022-01-03 02:22:25 | McDowell, West Virginia, US | |
2022-01-01 | US | Wisconsin | Sawyer | 55113 | 3507 | 49 | 0 | 45.87931905 | -91.14504927 | 2022-01-02 04:20:52 | Sawyer, Wisconsin, US | |
2022-01-01 | US | West Virginia | McDowell | 54047 | 3507 | 56 | 0 | 37.38002939 | -81.65083669 | 2022-01-02 04:20:52 | McDowell, West Virginia, US | |
2021-12-31 | US | Wisconsin | Sawyer | 55113 | 3507 | 49 | 0 | 45.87931905 | -91.14504927 | 2022-01-01 04:22:14 | Sawyer, Wisconsin, US | |
2021-12-31 | US | West Virginia | McDowell | 54047 | 3507 | 56 | 0 | 37.38002939 | -81.65083669 | 2022-01-01 04:22:14 | McDowell, West Virginia, US | |
2021-12-30 | US | West Virginia | McDowell | 54047 | 3507 | 56 | 0 | 37.38002939 | -81.65083669 | 2021-12-31 04:21:50 | McDowell, West Virginia, US | |
2021-12-27 | US | Kentucky | Rockcastle | 21203 | 3507 | 44 | 0 | 37.36642393 | -84.31176452 | 2021-12-28 04:21:47 | Rockcastle, Kentucky, US | |
2021-12-24 | US | Alabama | Butler | 1013 | 3507 | 102 | 0 | 31.75300095 | -86.68057478 | 2021-12-25 04:21:37 | Butler, Alabama, US | |
2021-12-22 | US | Missouri | New Madrid | 29143 | 3507 | 71 | 0 | 36.59666326 | -89.66070007 | 2021-12-23 04:21:21 | New Madrid, Missouri, US | |
2021-12-21 | US | Missouri | New Madrid | 29143 | 3507 | 71 | 0 | 36.59666326 | -89.66070007 | 2021-12-22 04:21:54 | New Madrid, Missouri, US | |
2021-12-19 | US | South Dakota | Hughes | 46065 | 3507 | 52 | 0 | 44.39091534 | -99.99661148 | 2021-12-20 04:21:43 | Hughes, South Dakota, US | |
2021-12-18 | US | South Dakota | Hughes | 46065 | 3507 | 52 | 0 | 44.39091534 | -99.99661148 | 2021-12-19 04:21:11 | Hughes, South Dakota, US | |
2021-12-17 | US | South Dakota | Hughes | 46065 | 3507 | 52 | 0 | 44.39091534 | -99.99661148 | 2021-12-18 02:22:20 | Hughes, South Dakota, US | |
2021-12-15 | US | Georgia | Lamar | 13171 | 3507 | 99 | 0 | 33.07841647 | -84.14263877 | 2021-12-16 04:22:11 | Lamar, Georgia, US | |
2021-12-14 | US | Michigan | Roscommon | 26143 | 3507 | 94 | 0 | 44.33473082 | -84.61067651 | 2021-12-15 03:22:16 | Roscommon, Michigan, US | |
2021-12-13 | US | Michigan | Roscommon | 26143 | 3507 | 94 | 0 | 44.33473082 | -84.61067651 | 2021-12-14 04:22:38 | Roscommon, Michigan, US | |
2021-12-09 | US | Virginia | Dinwiddie | 51053 | 3507 | 60 | 0 | 37.07544585 | -77.63451754 | 2021-12-10 04:22:28 | Dinwiddie, Virginia, US | |
2021-12-09 | US | Maryland | Somerset | 24039 | 3507 | 55 | 0 | 38.1163542 | -75.75118623 | 2021-12-10 04:22:28 | Somerset, Maryland, US | |
2021-12-02 | US | Georgia | Berrien | 13019 | 3507 | 71 | 0 | 31.27590016 | -83.22529920000002 | 2021-12-03 04:23:05 | Berrien, Georgia, US | |
2021-12-01 | US | Georgia | Berrien | 13019 | 3507 | 71 | 0 | 31.27590016 | -83.22529920000002 | 2021-12-02 04:22:37 | Berrien, Georgia, US | |
2021-11-30 | US | Georgia | Berrien | 13019 | 3507 | 71 | 0 | 31.27590016 | -83.22529920000002 | 2021-12-01 04:22:29 | Berrien, Georgia, US | |
2021-11-22 | US | Virginia | Staunton | 51790 | 3507 | 82 | 0 | 38.15965544 | -79.05979937 | 2021-11-23 04:22:39 | Staunton, Virginia, US | |
2021-11-19 | US | Missouri | Henry | 29083 | 3507 | 51 | 0 | 38.38482826 | -93.79293734 | 2021-11-20 04:22:17 | Henry, Missouri, US | |
2021-11-15 | US | Missouri | Adair | 29001 | 3507 | 34 | 0 | 40.19058551 | -92.60078167 | 2021-11-16 04:21:10 | Adair, Missouri, US | |
2021-11-14 | US | Illinois | Jersey | 17083 | 3507 | 53 | 0 | 39.08869046 | -90.35393073 | 2021-11-15 04:21:36 | Jersey, Illinois, US | |
2021-11-13 | US | Illinois | Jersey | 17083 | 3507 | 53 | 0 | 39.08869046 | -90.35393073 | 2021-11-14 04:21:31 | Jersey, Illinois, US | |
2021-11-12 | US | Illinois | Jersey | 17083 | 3507 | 53 | 0 | 39.08869046 | -90.35393073 | 2021-11-13 04:21:38 | Jersey, Illinois, US | |
2021-11-07 | US | Tennessee | Bledsoe | 47007 | 3507 | 18 | 0 | 35.59942968 | -85.20611967 | 2021-11-08 04:21:43 | Bledsoe, Tennessee, US | |
2021-11-07 | US | Kentucky | Woodford | 21239 | 3507 | 30 | 0 | 38.04178222 | -84.7417556 | 2021-11-08 04:21:43 | Woodford, Kentucky, US | |
2021-11-06 | US | Tennessee | Bledsoe | 47007 | 3507 | 18 | 0 | 35.59942968 | -85.20611967 | 2021-11-07 04:21:53 | Bledsoe, Tennessee, US | |
2021-11-06 | US | Arkansas | Arkansas | 5001 | 3507 | 60 | 0 | 34.29145151 | -91.37277296 | 2021-11-07 04:21:53 | Arkansas, Arkansas, US | |
2021-11-04 | US | Virginia | Salem | 51775 | 3507 | 61 | 0 | 37.2836193 | -80.06219455 | 2021-11-05 04:21:54 | Salem, Virginia, US | |
2021-11-02 | US | Georgia | Appling | 13001 | 3507 | 103 | 0 | 31.74847232 | -82.28909114 | 2021-11-03 06:22:09 | Appling, Georgia, US | |
2021-10-17 | US | New York | Delaware | 36025 | 3507 | 47 | 0 | 42.19837623 | -74.96709306 | 2021-10-18 04:21:10 | Delaware, New York, US | |
2021-10-13 | US | Indiana | Washington | 18175 | 3507 | 48 | 0 | 38.60219804 | -86.1049363 | 2021-10-14 04:21:29 | Washington, Indiana, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;