johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
95 rows where confirmed = 6980 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3714520 | 3714520 | 2022-12-06 | US | Alabama | Barbour | 1005 | 6980 | 103 | 0 | 31.868263 | -85.3871286 | 2022-12-07 04:20:58 | Barbour, Alabama, US | |
2415225 | 2415225 | 2022-12-05 | US | Alabama | Barbour | 1005 | 6980 | 103 | 0 | 31.868263 | -85.3871286 | 2022-12-06 04:21:03 | Barbour, Alabama, US | |
718833 | 718833 | 2022-12-04 | US | Alabama | Barbour | 1005 | 6980 | 103 | 0 | 31.868263 | -85.3871286 | 2022-12-05 04:20:58 | Barbour, Alabama, US | |
2817122 | 2817122 | 2022-12-03 | US | Alabama | Barbour | 1005 | 6980 | 103 | 0 | 31.868263 | -85.3871286 | 2022-12-04 04:20:56 | Barbour, Alabama, US | |
833978 | 833978 | 2022-12-02 | US | Alabama | Barbour | 1005 | 6980 | 103 | 0 | 31.868263 | -85.3871286 | 2022-12-03 04:21:02 | Barbour, Alabama, US | |
2136508 | 2136508 | 2022-12-01 | US | Alabama | Barbour | 1005 | 6980 | 103 | 0 | 31.868263 | -85.3871286 | 2022-12-02 04:21:07 | Barbour, Alabama, US | |
1964924 | 1964924 | 2022-11-30 | US | Alabama | Barbour | 1005 | 6980 | 103 | 0 | 31.868263 | -85.3871286 | 2022-12-01 04:21:03 | Barbour, Alabama, US | |
3551443 | 3551443 | 2022-11-27 | China | Henan | 6980 | 23 | 0 | 33.882 | 113.614 | 2022-11-28 04:21:02 | Henan, China | |||
3462887 | 3462887 | 2022-11-21 | US | Puerto Rico | Barceloneta | 72017 | 6980 | 0 | 0 | 18.445533 | -66.560531 | 2022-11-22 04:20:47 | Barceloneta, Puerto Rico, US | |
1643072 | 1643072 | 2022-11-20 | US | Puerto Rico | Barceloneta | 72017 | 6980 | 0 | 0 | 18.445533 | -66.560531 | 2022-11-21 04:21:05 | Barceloneta, Puerto Rico, US | |
2489489 | 2489489 | 2022-11-16 | US | West Virginia | Hampshire | 54027 | 6980 | 74 | 0 | 39.32103553 | -78.60826476 | 2022-11-17 04:21:11 | Hampshire, West Virginia, US | |
2027002 | 2027002 | 2022-10-17 | US | New York | Lewis | 36049 | 6980 | 53 | 0 | 43.7844157 | -75.44903992 | 2022-10-18 04:22:42 | Lewis, New York, US | |
3651181 | 3651181 | 2022-08-14 | US | Wisconsin | Waushara | 55137 | 6980 | 87 | 0 | 44.11324419 | -89.24317107 | 2022-08-15 04:20:59 | Waushara, Wisconsin, US | |
1972187 | 1972187 | 2022-08-13 | US | Wisconsin | Waushara | 55137 | 6980 | 87 | 0 | 44.11324419 | -89.24317107 | 2022-08-14 04:20:55 | Waushara, Wisconsin, US | |
2891996 | 2891996 | 2022-08-12 | US | Wisconsin | Waushara | 55137 | 6980 | 87 | 0 | 44.11324419 | -89.24317107 | 2022-08-13 04:20:52 | Waushara, Wisconsin, US | |
3618641 | 3618641 | 2022-08-01 | US | Maine | Knox | 23013 | 6980 | 40 | 0 | 44.11486325 | -69.10529169 | 2022-08-02 04:20:53 | Knox, Maine, US | |
3873121 | 3873121 | 2022-07-31 | US | Maine | Knox | 23013 | 6980 | 40 | 0 | 44.11486325 | -69.10529169 | 2022-08-01 04:21:03 | Knox, Maine, US | |
675875 | 675875 | 2022-07-30 | US | Maine | Knox | 23013 | 6980 | 40 | 0 | 44.11486325 | -69.10529169 | 2022-07-31 04:21:02 | Knox, Maine, US | |
900638 | 900638 | 2022-07-22 | US | Arkansas | Cleburne | 5023 | 6980 | 130 | 0 | 35.53864922 | -92.02640019 | 2022-07-23 04:20:53 | Cleburne, Arkansas, US | |
559461 | 559461 | 2022-06-16 | US | Colorado | Routt | 8107 | 6980 | 25 | 0 | 40.48596505 | -106.9905548 | 2022-06-17 04:20:56 | Routt, Colorado, US | |
3727060 | 3727060 | 2022-06-07 | US | Georgia | Madison | 13195 | 6980 | 110 | 0 | 34.12920917 | -83.21218732 | 2022-06-08 04:20:55 | Madison, Georgia, US | |
3888462 | 3888462 | 2022-06-06 | US | Georgia | Madison | 13195 | 6980 | 110 | 0 | 34.12920917 | -83.21218732 | 2022-06-07 04:21:08 | Madison, Georgia, US | |
3508231 | 3508231 | 2022-06-05 | US | Georgia | Madison | 13195 | 6980 | 110 | 0 | 34.12920917 | -83.21218732 | 2022-06-06 04:20:57 | Madison, Georgia, US | |
3528308 | 3528308 | 2022-06-04 | US | Georgia | Madison | 13195 | 6980 | 110 | 0 | 34.12920917 | -83.21218732 | 2022-06-05 04:20:55 | Madison, Georgia, US | |
3134394 | 3134394 | 2022-06-03 | US | Georgia | Madison | 13195 | 6980 | 110 | 0 | 34.12920917 | -83.21218732 | 2022-06-04 04:20:58 | Madison, Georgia, US | |
3579469 | 3579469 | 2022-06-02 | US | Georgia | Madison | 13195 | 6980 | 110 | 0 | 34.12920917 | -83.21218732 | 2022-06-03 04:20:58 | Madison, Georgia, US | |
974327 | 974327 | 2022-06-01 | US | Virginia | Russell | 51167 | 6980 | 116 | 0 | 36.9302832 | -82.10095486 | 2022-06-02 05:20:39 | Russell, Virginia, US | |
971762 | 971762 | 2022-06-01 | US | Georgia | Madison | 13195 | 6980 | 110 | 0 | 34.12920917 | -83.21218732 | 2022-06-02 05:20:39 | Madison, Georgia, US | |
2085708 | 2085708 | 2022-05-15 | US | Minnesota | Nobles | 27105 | 6980 | 60 | 0 | 43.67434621 | -95.75329576 | 2022-05-16 04:20:47 | Nobles, Minnesota, US | |
3356418 | 3356418 | 2022-05-14 | US | Minnesota | Nobles | 27105 | 6980 | 60 | 0 | 43.67434621 | -95.75329576 | 2022-05-15 04:20:53 | Nobles, Minnesota, US | |
660063 | 660063 | 2022-05-13 | US | Minnesota | Nobles | 27105 | 6980 | 60 | 0 | 43.67434621 | -95.75329576 | 2022-05-14 04:20:48 | Nobles, Minnesota, US | |
3446592 | 3446592 | 2022-05-11 | US | Minnesota | Nobles | 27105 | 6980 | 60 | 0 | 43.67434621 | -95.75329576 | 2022-05-12 04:20:54 | Nobles, Minnesota, US | |
3855114 | 3855114 | 2022-04-27 | US | Virginia | Accomack | 51001 | 6980 | 106 | 0 | 37.76707161 | -75.63234615 | 2022-04-28 04:20:47 | Accomack, Virginia, US | |
3854258 | 3854258 | 2022-04-27 | US | Ohio | Adams | 39001 | 6980 | 150 | 0 | 38.84541072 | -83.4718964 | 2022-04-28 04:20:47 | Adams, Ohio, US | |
1328688 | 1328688 | 2022-04-26 | US | Ohio | Adams | 39001 | 6980 | 150 | 0 | 38.84541072 | -83.4718964 | 2022-04-27 04:20:52 | Adams, Ohio, US | |
3725742 | 3725742 | 2022-04-25 | US | Wisconsin | Door | 55029 | 6980 | 71 | 0 | 44.95856458 | -87.30002707 | 2022-04-26 04:20:51 | Door, Wisconsin, US | |
3724642 | 3724642 | 2022-04-25 | US | Ohio | Adams | 39001 | 6980 | 150 | 0 | 38.84541072 | -83.4718964 | 2022-04-26 04:20:51 | Adams, Ohio, US | |
2031210 | 2031210 | 2022-04-24 | US | Ohio | Adams | 39001 | 6980 | 149 | 0 | 38.84541072 | -83.4718964 | 2022-04-25 04:20:56 | Adams, Ohio, US | |
748785 | 748785 | 2022-04-23 | US | Ohio | Adams | 39001 | 6980 | 149 | 0 | 38.84541072 | -83.4718964 | 2022-04-24 04:20:56 | Adams, Ohio, US | |
3439270 | 3439270 | 2022-04-22 | US | Ohio | Adams | 39001 | 6980 | 149 | 0 | 38.84541072 | -83.4718964 | 2022-04-23 04:20:50 | Adams, Ohio, US | |
2894855 | 2894855 | 2022-04-21 | US | Ohio | Adams | 39001 | 6980 | 149 | 0 | 38.84541072 | -83.4718964 | 2022-04-22 04:20:45 | Adams, Ohio, US | |
2321086 | 2321086 | 2022-03-16 | US | Minnesota | Pine | 27115 | 6980 | 66 | 0 | 46.12105238 | -92.74070188 | 2022-03-17 04:20:56 | Pine, Minnesota, US | |
2201665 | 2201665 | 2022-03-06 | US | Montana | Ravalli | 30081 | 6980 | 141 | 0 | 46.08520862 | -114.11891640000002 | 2022-03-07 04:20:47 | Ravalli, Montana, US | |
2094122 | 2094122 | 2022-03-05 | US | Montana | Ravalli | 30081 | 6980 | 141 | 0 | 46.08520862 | -114.11891640000002 | 2022-03-06 04:20:49 | Ravalli, Montana, US | |
2667822 | 2667822 | 2022-03-04 | US | Montana | Ravalli | 30081 | 6980 | 141 | 0 | 46.08520862 | -114.11891640000002 | 2022-03-05 04:21:10 | Ravalli, Montana, US | |
3720489 | 3720489 | 2022-02-21 | US | North Carolina | Cherokee | 37039 | 6980 | 97 | 0 | 35.1349263 | -84.05970864 | 2022-02-22 04:21:01 | Cherokee, North Carolina, US | |
3859026 | 3859026 | 2022-02-18 | US | Texas | Palo Pinto | 48363 | 6980 | 144 | 0 | 32.75310985 | -98.31319001 | 2022-02-19 04:21:11 | Palo Pinto, Texas, US | |
3820968 | 3820968 | 2022-02-16 | US | Arkansas | St. Francis | 5123 | 6980 | 80 | 0 | 35.02201976 | -90.74828138 | 2022-02-17 04:20:56 | St. Francis, Arkansas, US | |
2643260 | 2643260 | 2022-02-14 | US | Louisiana | Franklin | 22041 | 6980 | 159 | 0 | 32.13675181 | -91.67589857 | 2022-02-15 04:21:09 | Franklin, Louisiana, US | |
2658825 | 2658825 | 2022-01-31 | US | Illinois | Perry | 17145 | 6980 | 90 | 0 | 38.08510853 | -89.36856219 | 2022-02-01 04:21:11 | Perry, Illinois, US | |
2835793 | 2835793 | 2022-01-22 | US | Tennessee | Lauderdale | 47097 | 6980 | 83 | 0 | 35.75893438 | -89.63015909999999 | 2022-01-23 04:21:13 | Lauderdale, Tennessee, US | |
3613989 | 3613989 | 2022-01-12 | US | Idaho | Bonner | 16017 | 6980 | 155 | 0 | 48.29996017 | -116.6017932 | 2022-01-13 08:00:09 | Bonner, Idaho, US | |
782761 | 782761 | 2021-12-13 | US | Alabama | Escambia | 1053 | 6980 | 147 | 0 | 31.1256789 | -87.15918694 | 2021-12-14 04:22:38 | Escambia, Alabama, US | |
1743948 | 1743948 | 2021-12-05 | US | Virginia | Shenandoah | 51171 | 6980 | 177 | 0 | 38.85905135 | -78.56813762 | 2021-12-06 04:22:34 | Shenandoah, Virginia, US | |
141380 | 141380 | 2021-12-04 | US | Virginia | Shenandoah | 51171 | 6980 | 177 | 0 | 38.85905135 | -78.56813762 | 2021-12-05 04:22:25 | Shenandoah, Virginia, US | |
2199033 | 2199033 | 2021-12-03 | US | Virginia | Shenandoah | 51171 | 6980 | 177 | 0 | 38.85905135 | -78.56813762 | 2021-12-04 04:22:18 | Shenandoah, Virginia, US | |
3403586 | 3403586 | 2021-11-30 | US | Nevada | Lyon | 32019 | 6980 | 123 | 0 | 39.01777974 | -119.18704790000001 | 2021-12-01 04:22:29 | Lyon, Nevada, US | |
2289832 | 2289832 | 2021-11-15 | US | North Carolina | Vance | 37181 | 6980 | 103 | 0 | 36.36880673 | -78.40670845 | 2021-11-16 04:21:10 | Vance, North Carolina, US | |
2289202 | 2289202 | 2021-11-15 | US | Minnesota | Mower | 27099 | 6980 | 46 | 0 | 43.67142874 | -92.75234549 | 2021-11-16 04:21:10 | Mower, Minnesota, US | |
2721402 | 2721402 | 2021-10-30 | US | Alabama | Russell | 1113 | 6980 | 61 | 0 | 32.28725256 | -85.18415324 | 2021-10-31 04:22:08 | Russell, Alabama, US | |
444454 | 444454 | 2021-10-20 | US | Indiana | Jackson | 18071 | 6980 | 89 | 0 | 38.90915820000001 | -86.03851889 | 2021-10-21 04:21:18 | Jackson, Indiana, US | |
426162 | 426162 | 2021-10-10 | US | South Carolina | Chesterfield | 45025 | 6980 | 139 | 0 | 34.64137396 | -80.15640140000002 | 2021-10-11 04:21:31 | Chesterfield, South Carolina, US | |
2879019 | 2879019 | 2021-10-09 | US | South Carolina | Chesterfield | 45025 | 6980 | 139 | 0 | 34.64137396 | -80.15640140000002 | 2021-10-10 04:21:38 | Chesterfield, South Carolina, US | |
2962185 | 2962185 | 2021-10-08 | US | South Carolina | Chesterfield | 45025 | 6980 | 139 | 0 | 34.64137396 | -80.15640140000002 | 2021-10-09 04:21:34 | Chesterfield, South Carolina, US | |
468385 | 468385 | 2021-10-07 | US | Illinois | Clinton | 17027 | 6980 | 101 | 0 | 38.60704876 | -89.42385254 | 2021-10-08 04:21:25 | Clinton, Illinois, US | |
3834534 | 3834534 | 2021-10-05 | US | Nebraska | Buffalo | 31019 | 6980 | 57 | 0 | 40.85486962 | -99.07500296 | 2021-10-06 04:21:33 | Buffalo, Nebraska, US | |
2619455 | 2619455 | 2021-09-17 | US | Kentucky | Hopkins | 21107 | 6980 | 177 | 0 | 37.30939025 | -87.54670406 | 2021-09-18 04:21:24 | Hopkins, Kentucky, US | |
3452499 | 3452499 | 2021-09-10 | United Kingdom | Isle of Man | 6980 | 38 | 0 | 54.2361 | -4.5481 | 2021-09-11 04:21:30 | Isle of Man, United Kingdom | |||
3895460 | 3895460 | 2021-08-29 | US | Wisconsin | Calumet | 55015 | 6980 | 56 | 0 | 44.0816316 | -88.21780273 | 2021-08-30 04:21:23 | Calumet, Wisconsin, US | |
2796563 | 2796563 | 2021-08-28 | US | Wisconsin | Calumet | 55015 | 6980 | 56 | 0 | 44.0816316 | -88.21780273 | 2021-08-29 04:21:14 | Calumet, Wisconsin, US | |
2926722 | 2926722 | 2021-08-27 | US | Wisconsin | Calumet | 55015 | 6980 | 56 | 0 | 44.0816316 | -88.21780273 | 2021-08-28 04:21:28 | Calumet, Wisconsin, US | |
628145 | 628145 | 2021-07-10 | US | New York | Steuben | 36101 | 6980 | 146 | 0 | 42.2689144 | -77.3829924 | 2021-07-11 04:21:43 | Steuben, New York, US | |
831864 | 831864 | 2021-07-09 | US | New York | Steuben | 36101 | 6980 | 146 | 0 | 42.2689144 | -77.3829924 | 2021-07-10 04:21:25 | Steuben, New York, US | |
2295373 | 2295373 | 2021-06-24 | Germany | Unknown | 6980 | 0 | 0 | 6980 | 2021-06-25 04:21:33 | Unknown, Germany | ||||
21751 | 21751 | 2021-05-28 | US | Kentucky | Christian | 21047 | 6980 | 104 | 0 | 36.89267803 | -87.49055367 | 2021-05-29 04:20:41 | Christian, Kentucky, US | |
84657 | 84657 | 2021-05-25 | US | Maryland | Allegany | 24001 | 6980 | 209 | 0 | 39.62357628 | -78.69280486 | 2021-05-26 04:20:35 | Allegany, Maryland, US | |
1773806 | 1773806 | 2021-05-23 | US | Ohio | Hancock | 39063 | 6980 | 133 | 0 | 41.00250487 | -83.66838948 | 2021-05-24 04:20:53 | Hancock, Ohio, US | |
2762419 | 2762419 | 2021-05-03 | US | Louisiana | Iberia | 22045 | 6980 | 153 | 0 | 29.86803617 | -91.75871777 | 2021-05-04 04:20:34 | Iberia, Louisiana, US | |
2783811 | 2783811 | 2021-03-24 | US | South Carolina | Kershaw | 45055 | 6980 | 131 | 0 | 34.33988254 | -80.58763164 | 2021-03-25 05:27:00 | Kershaw, South Carolina, US | |
3371140 | 3371140 | 2021-03-21 | US | Mississippi | Lauderdale | 28075 | 6980 | 232 | 0 | 32.40419769 | -88.66229662 | 2021-03-22 05:25:43 | Lauderdale, Mississippi, US | |
474865 | 474865 | 2021-02-19 | US | Washington | Thurston | 53067 | 6980 | 76 | 0 | 6904 | 46.9291895 | -122.8290656 | 2021-02-20 05:22:51 | Thurston, Washington, US |
239568 | 239568 | 2021-01-18 | US | North Carolina | Lincoln | 37109 | 6980 | 42 | 0 | 6938 | 35.48508185 | -81.21740317 | 2021-01-19 05:22:15 | Lincoln, North Carolina, US |
3505685 | 3505685 | 2021-01-17 | US | North Carolina | Lincoln | 37109 | 6980 | 42 | 0 | 6938 | 35.48508185 | -81.21740317 | 2021-01-18 05:22:34 | Lincoln, North Carolina, US |
2231069 | 2231069 | 2021-01-02 | US | Wisconsin | Manitowoc | 55071 | 6980 | 57 | 0 | 6923 | 44.11946801 | -87.80928853 | 2021-01-03 05:22:52 | Manitowoc, Wisconsin, US |
1140433 | 1140433 | 2021-01-01 | US | Wisconsin | Manitowoc | 55071 | 6980 | 57 | 0 | 6923 | 44.11946801 | -87.80928853 | 2021-01-02 05:22:33 | Manitowoc, Wisconsin, US |
3862336 | 3862336 | 2020-12-04 | US | Ohio | Trumbull | 39155 | 6980 | 186 | 0 | 6794 | 41.31735028 | -80.76109643 | 2020-12-05 05:27:36 | Trumbull, Ohio, US |
3442495 | 3442495 | 2020-11-11 | US | Michigan | Washtenaw | 26161 | 6980 | 121 | 0 | 6859 | 42.253105 | -83.83853204 | 2020-11-12 05:25:55 | Washtenaw, Michigan, US |
11638 | 11638 | 2020-10-25 | US | Virginia | Chesterfield | 51041 | 6980 | 102 | 0 | 6878 | 37.37373208 | -77.58680140000001 | 2020-10-26 04:25:02 | Chesterfield, Virginia, US |
3994220 | 3994220 | 2020-10-20 | Ukraine | Chernihiv Oblast | 6980 | 87 | 1239 | 5654 | 51.4982 | 31.2893 | 2020-10-21 04:24:14 | Chernihiv Oblast, Ukraine | ||
2300166 | 2300166 | 2020-08-22 | US | Florida | Sarasota | 12115 | 6980 | 180 | 0 | 6800 | 27.18546175 | -82.33174248 | 2020-08-23 04:27:48 | Sarasota, Florida, US |
3179483 | 3179483 | 2020-08-18 | US | Louisiana | Caddo | 22017 | 6980 | 304 | 0 | 6676 | 32.57991587 | -93.88375652 | 2020-08-19 04:27:00 | Caddo, Louisiana, US |
3535046 | 3535046 | 2020-08-12 | Ukraine | Chernivtsi Oblast | 6980 | 232 | 5312 | 1436 | 48.2917 | 25.9352 | 2020-08-13 04:29:15 | Chernivtsi Oblast, Ukraine | ||
458421 | 458421 | 2020-08-07 | Russia | Chuvashia Republic | 6980 | 62 | 4180 | 2738 | 55.4259922 | 47.0849429 | 2020-08-08 04:34:53 | Chuvashia Republic, Russia | ||
2681552 | 2681552 | 2020-07-06 | US | California | Alameda | 6001 | 6980 | 141 | 0 | 6838 | 37.64629437 | -121.8929271 | 2020-07-07 04:34:00 | Alameda, California, US |
2435467 | 2435467 | 2020-06-20 | US | New York | Erie | 36029 | 6980 | 621 | 0 | 6359 | 42.76249024 | -78.73063652 | 2020-06-21 04:33:19 | Erie, New York, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);