daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
95 rows where confirmed = 6860 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 7
- US 87
- Colombia 3
- Azerbaijan 1
- Canada 1
- Eritrea 1
- Netherlands 1
- Vanuatu 1
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-11-08 | US | Puerto Rico | Villalba | 72149 | 6860 | 0 | 0 | 18.127951 | -66.473115 | 2022-11-09 04:21:22 | Villalba, Puerto Rico, US | |
2022-11-01 | US | Louisiana | Grant | 22043 | 6860 | 97 | 0 | 31.59882456 | -92.56124347 | 2022-11-02 04:22:09 | Grant, Louisiana, US | |
2022-10-31 | US | Louisiana | Grant | 22043 | 6860 | 97 | 0 | 31.59882456 | -92.56124347 | 2022-11-01 04:22:36 | Grant, Louisiana, US | |
2022-10-30 | US | Louisiana | Grant | 22043 | 6860 | 97 | 0 | 31.59882456 | -92.56124347 | 2022-10-31 04:21:36 | Grant, Louisiana, US | |
2022-10-29 | US | Louisiana | Grant | 22043 | 6860 | 97 | 0 | 31.59882456 | -92.56124347 | 2022-10-30 04:22:14 | Grant, Louisiana, US | |
2022-10-28 | US | Louisiana | Grant | 22043 | 6860 | 97 | 0 | 31.59882456 | -92.56124347 | 2022-10-29 04:21:13 | Grant, Louisiana, US | |
2022-10-27 | US | Louisiana | Grant | 22043 | 6860 | 97 | 0 | 31.59882456 | -92.56124347 | 2022-10-28 04:22:31 | Grant, Louisiana, US | |
2022-10-26 | US | Louisiana | Grant | 22043 | 6860 | 97 | 0 | 31.59882456 | -92.56124347 | 2022-10-27 04:22:01 | Grant, Louisiana, US | |
2022-10-23 | US | Colorado | Delta | 8029 | 6860 | 149 | 0 | 38.86246243 | -107.8631342 | 2022-10-24 04:22:29 | Delta, Colorado, US | |
2022-10-22 | US | Colorado | Delta | 8029 | 6860 | 149 | 0 | 38.86246243 | -107.8631342 | 2022-10-23 04:22:46 | Delta, Colorado, US | |
2022-10-21 | US | Colorado | Delta | 8029 | 6860 | 149 | 0 | 38.86246243 | -107.8631342 | 2022-10-22 04:22:53 | Delta, Colorado, US | |
2022-10-03 | US | West Virginia | Hampshire | 54027 | 6860 | 74 | 0 | 39.32103553 | -78.60826476 | 2022-10-04 04:22:55 | Hampshire, West Virginia, US | |
2022-09-20 | US | New York | Lewis | 36049 | 6860 | 52 | 0 | 43.7844157 | -75.44903992 | 2022-09-21 04:23:22 | Lewis, New York, US | |
2022-08-25 | US | Puerto Rico | Aguas Buenas | 72007 | 6860 | 0 | 0 | 18.251619 | -66.126806 | 2022-08-26 04:21:02 | Aguas Buenas, Puerto Rico, US | |
2022-08-10 | US | Tennessee | Haywood | 47075 | 6860 | 105 | 0 | 35.58332824 | -89.28536625 | 2022-08-11 04:20:49 | Haywood, Tennessee, US | |
2022-07-17 | US | Louisiana | Pointe Coupee | 22077 | 6860 | 93 | 0 | 30.71409502 | -91.60209535 | 2022-07-18 04:20:59 | Pointe Coupee, Louisiana, US | |
2022-07-16 | US | Louisiana | Pointe Coupee | 22077 | 6860 | 93 | 0 | 30.71409502 | -91.60209535 | 2022-07-17 04:21:15 | Pointe Coupee, Louisiana, US | |
2022-07-15 | US | Louisiana | Pointe Coupee | 22077 | 6860 | 93 | 0 | 30.71409502 | -91.60209535 | 2022-07-16 04:21:05 | Pointe Coupee, Louisiana, US | |
2022-07-12 | US | Maine | Knox | 23013 | 6860 | 40 | 0 | 44.11486325 | -69.10529169 | 2022-07-13 04:20:58 | Knox, Maine, US | |
2022-07-03 | US | California | Del Norte | 6015 | 6860 | 53 | 0 | 41.74228275 | -123.8974063 | 2022-07-04 04:20:54 | Del Norte, California, US | |
2022-07-02 | US | California | Del Norte | 6015 | 6860 | 53 | 0 | 41.74228275 | -123.8974063 | 2022-07-03 04:20:59 | Del Norte, California, US | |
2022-06-28 | US | Louisiana | Plaquemines | 22075 | 6860 | 46 | 0 | 29.42245447 | -89.60322085 | 2022-06-29 04:20:59 | Plaquemines, Louisiana, US | |
2022-06-02 | US | Tennessee | Grainger | 47057 | 6860 | 110 | 0 | 36.27469206 | -83.51254721 | 2022-06-03 04:20:58 | Grainger, Tennessee, US | |
2022-06-01 | US | Arkansas | Johnson | 5071 | 6860 | 88 | 0 | 35.56759135 | -93.46036368 | 2022-06-02 05:20:39 | Johnson, Arkansas, US | |
2022-05-24 | US | Nebraska | Dakota | 31043 | 6860 | 71 | 0 | 42.39040144 | -96.56656425 | 2022-05-25 04:20:56 | Dakota, Nebraska, US | |
2022-05-23 | US | Nebraska | Dakota | 31043 | 6860 | 71 | 0 | 42.39040144 | -96.56656425 | 2022-05-24 04:20:57 | Dakota, Nebraska, US | |
2022-05-17 | US | Indiana | Clay | 18021 | 6860 | 88 | 0 | 39.39561833 | -87.11723506 | 2022-05-18 04:20:50 | Clay, Indiana, US | |
2022-05-17 | US | Arkansas | Yell | 5149 | 6860 | 106 | 0 | 35.00292371 | -93.41171338 | 2022-05-18 04:20:50 | Yell, Arkansas, US | |
2022-05-16 | US | Indiana | Clay | 18021 | 6860 | 88 | 0 | 39.39561833 | -87.11723506 | 2022-05-17 04:20:59 | Clay, Indiana, US | |
2022-05-16 | US | Arkansas | Yell | 5149 | 6860 | 106 | 0 | 35.00292371 | -93.41171338 | 2022-05-17 04:20:59 | Yell, Arkansas, US | |
2022-05-09 | US | Virginia | Russell | 51167 | 6860 | 114 | 0 | 36.9302832 | -82.10095486 | 2022-05-10 04:20:50 | Russell, Virginia, US | |
2022-05-04 | US | Louisiana | Morehouse | 22067 | 6860 | 134 | 0 | 32.81686191 | -91.80421614 | 2022-05-05 04:20:55 | Morehouse, Louisiana, US | |
2022-04-25 | Vanuatu | 6860 | 13 | 0 | -15.3767 | 166.9592 | 2022-04-26 04:20:51 | Vanuatu | ||||
2022-04-07 | US | Georgia | Dawson | 13085 | 6860 | 100 | 0 | 34.44244079 | -84.16964071 | 2022-04-08 04:20:48 | Dawson, Georgia, US | |
2022-03-27 | US | Puerto Rico | Rio Grande | 72119 | 6860 | 0 | 0 | 18.346329 | -65.813742 | 2022-03-28 04:20:33 | Rio Grande, Puerto Rico, US | |
2022-03-23 | US | West Virginia | Jackson | 54035 | 6860 | 133 | 0 | 38.84263974 | -81.68148753 | 2022-03-24 04:20:43 | Jackson, West Virginia, US | |
2022-02-24 | US | Oregon | Lincoln | 41041 | 6860 | 70 | 0 | 44.64252874 | -123.86991200000001 | 2022-02-25 04:21:11 | Lincoln, Oregon, US | |
2022-02-23 | US | Nevada | Nye | 32023 | 6860 | 226 | 0 | 38.04264256 | -116.47227020000001 | 2022-02-24 04:21:14 | Nye, Nevada, US | |
2022-02-23 | US | Louisiana | Union | 22111 | 6860 | 126 | 0 | 32.83121059 | -92.3749373 | 2022-02-24 04:21:14 | Union, Louisiana, US | |
2022-02-21 | US | Colorado | Pitkin | 8097 | 6860 | 7 | 0 | 39.21720112 | -106.9310027 | 2022-02-22 04:21:01 | Pitkin, Colorado, US | |
2022-02-17 | US | Minnesota | Pine | 27115 | 6860 | 61 | 0 | 46.12105238 | -92.74070188 | 2022-02-18 04:21:04 | Pine, Minnesota, US | |
2022-02-15 | US | Missouri | Dunklin | 29069 | 6860 | 95 | 0 | 36.27167174 | -90.09122243 | 2022-02-16 04:21:10 | Dunklin, Missouri, US | |
2022-02-15 | US | Mississippi | Simpson | 28127 | 6860 | 139 | 0 | 31.91282117 | -89.91716179 | 2022-02-16 04:21:10 | Simpson, Mississippi, US | |
2022-01-28 | US | Tennessee | Hardeman | 47069 | 6860 | 106 | 0 | 35.20772017 | -88.99161161 | 2022-01-29 04:21:10 | Hardeman, Tennessee, US | |
2022-01-15 | US | Pennsylvania | Tioga | 42117 | 6860 | 176 | 0 | 41.77255149 | -77.25433032 | 2022-01-16 04:21:12 | Tioga, Pennsylvania, US | |
2022-01-09 | US | Missouri | Webster | 29225 | 6860 | 121 | 0 | 37.2813734 | -92.876329 | 2022-01-10 04:22:07 | Webster, Missouri, US | |
2022-01-09 | US | Kentucky | Muhlenberg | 21177 | 6860 | 101 | 0 | 37.21425819 | -87.14632053 | 2022-01-10 04:22:07 | Muhlenberg, Kentucky, US | |
2022-01-08 | US | Kentucky | Muhlenberg | 21177 | 6860 | 101 | 0 | 37.21425819 | -87.14632053 | 2022-01-09 04:21:46 | Muhlenberg, Kentucky, US | |
2022-01-07 | US | Kentucky | Muhlenberg | 21177 | 6860 | 101 | 0 | 37.21425819 | -87.14632053 | 2022-01-08 04:21:53 | Muhlenberg, Kentucky, US | |
2022-01-07 | US | Arkansas | Baxter | 5005 | 6860 | 206 | 0 | 36.28784385 | -92.33782872 | 2022-01-08 04:21:53 | Baxter, Arkansas, US | |
2021-12-24 | US | Texas | Waller | 48473 | 6860 | 87 | 0 | 30.01058447 | -95.99011759 | 2021-12-25 04:21:37 | Waller, Texas, US | |
2021-12-23 | US | Puerto Rico | Guaynabo | 72061 | 6860 | 0 | 0 | 18.345114000000002 | -66.11452299999999 | 2021-12-24 04:21:34 | Guaynabo, Puerto Rico, US | |
2021-12-16 | US | Illinois | Livingston | 17105 | 6860 | 111 | 0 | 40.89188292 | -88.55784752 | 2021-12-17 04:22:14 | Livingston, Illinois, US | |
2021-12-06 | US | North Carolina | Alexander | 37003 | 6860 | 118 | 0 | 35.922379600000006 | -81.17751948 | 2021-12-07 04:22:34 | Alexander, North Carolina, US | |
2021-11-20 | US | Colorado | La Plata | 8067 | 6860 | 62 | 0 | 37.28632032 | -107.8429014 | 2021-11-21 04:22:13 | La Plata, Colorado, US | |
2021-11-14 | Colombia | Amazonas | 6860 | 256 | 0 | -1.4429 | -71.5724 | 2021-11-15 04:21:36 | Amazonas, Colombia | |||
2021-11-13 | Colombia | Amazonas | 6860 | 256 | 0 | -1.4429 | -71.5724 | 2021-11-14 04:21:31 | Amazonas, Colombia | |||
2021-11-03 | US | West Virginia | Jefferson | 54037 | 6860 | 88 | 0 | 39.30776166 | -77.86014147 | 2021-11-04 04:22:20 | Jefferson, West Virginia, US | |
2021-11-02 | US | Texas | Medina | 48325 | 6860 | 165 | 0 | 29.355730100000002 | -99.11030298 | 2021-11-03 06:22:09 | Medina, Texas, US | |
2021-11-02 | Eritrea | 6860 | 45 | 0 | 15.1794 | 39.7823 | 2021-11-03 06:22:09 | Eritrea | ||||
2021-10-31 | US | Texas | Medina | 48325 | 6860 | 165 | 0 | 29.355730100000002 | -99.11030298 | 2021-11-01 04:22:01 | Medina, Texas, US | |
2021-10-31 | US | Tennessee | Marshall | 47117 | 6860 | 87 | 0 | 35.45798777 | -86.76420988 | 2021-11-01 04:22:01 | Marshall, Tennessee, US | |
2021-10-30 | US | Texas | Medina | 48325 | 6860 | 165 | 0 | 29.355730100000002 | -99.11030298 | 2021-10-31 04:22:08 | Medina, Texas, US | |
2021-10-29 | US | Texas | Medina | 48325 | 6860 | 165 | 0 | 29.355730100000002 | -99.11030298 | 2021-10-30 04:22:03 | Medina, Texas, US | |
2021-10-17 | US | Wisconsin | Dunn | 55033 | 6860 | 45 | 0 | 44.94562799 | -91.8962481 | 2021-10-18 04:21:10 | Dunn, Wisconsin, US | |
2021-10-16 | US | Wisconsin | Dunn | 55033 | 6860 | 45 | 0 | 44.94562799 | -91.8962481 | 2021-10-17 04:21:29 | Dunn, Wisconsin, US | |
2021-09-25 | Colombia | San Andres y Providencia | 6860 | 134 | 0 | 12.5567 | -81.7185 | 2021-09-26 04:21:29 | San Andres y Providencia, Colombia | |||
2021-09-20 | US | Mississippi | Washington | 28151 | 6860 | 148 | 0 | 33.28392041 | -90.94196237 | 2021-09-21 04:21:26 | Washington, Mississippi, US | |
2021-09-19 | US | California | Mendocino | 6045 | 6860 | 67 | 0 | 39.4381191 | -123.39113130000001 | 2021-09-20 04:21:22 | Mendocino, California, US | |
2021-08-18 | US | California | Nevada | 6057 | 6860 | 76 | 0 | 39.30394768 | -120.76272809999999 | 2021-08-19 04:21:15 | Nevada, California, US | |
2021-08-12 | US | Colorado | Eagle | 8037 | 6860 | 28 | 0 | 39.62754308 | -106.6933637 | 2021-08-13 04:21:24 | Eagle, Colorado, US | |
2021-08-06 | US | Missouri | Newton | 29145 | 6860 | 94 | 0 | 36.90519407 | -94.3394104 | 2021-08-07 04:21:30 | Newton, Missouri, US | |
2021-06-29 | US | Ohio | Geauga | 39055 | 6860 | 153 | 0 | 41.49952319 | -81.17935342 | 2021-06-30 04:21:41 | Geauga, Ohio, US | |
2021-06-28 | US | Ohio | Geauga | 39055 | 6860 | 153 | 0 | 41.49952319 | -81.17935342 | 2021-06-29 04:21:28 | Geauga, Ohio, US | |
2021-06-15 | US | New Mexico | Valencia | 35061 | 6860 | 117 | 0 | 34.71669834 | -106.8103733 | 2021-06-16 04:22:32 | Valencia, New Mexico, US | |
2021-06-13 | US | Washington | Chelan | 53007 | 6860 | 67 | 0 | 47.87046092 | -120.6173956 | 2021-06-14 04:22:46 | Chelan, Washington, US | |
2021-06-12 | US | Washington | Chelan | 53007 | 6860 | 67 | 0 | 47.87046092 | -120.6173956 | 2021-06-13 04:22:44 | Chelan, Washington, US | |
2021-05-04 | US | Maryland | Allegany | 24001 | 6860 | 207 | 0 | 39.62357628 | -78.69280486 | 2021-05-05 04:20:43 | Allegany, Maryland, US | |
2021-04-26 | US | Tennessee | Coffee | 47031 | 6860 | 120 | 0 | 35.49090731 | -86.07311784 | 2021-04-27 04:20:52 | Coffee, Tennessee, US | |
2021-04-25 | US | Tennessee | Coffee | 47031 | 6860 | 120 | 0 | 35.49090731 | -86.07311784 | 2021-04-26 04:21:04 | Coffee, Tennessee, US | |
2021-04-20 | US | Louisiana | Iberia | 22045 | 6860 | 152 | 0 | 29.86803617 | -91.75871777 | 2021-04-21 04:21:14 | Iberia, Louisiana, US | |
2021-04-18 | US | Illinois | Whiteside | 17195 | 6860 | 163 | 0 | 41.75509713 | -89.91556058 | 2021-04-19 04:20:57 | Whiteside, Illinois, US | |
2021-04-12 | US | Pennsylvania | Crawford | 42039 | 6860 | 145 | 0 | 41.68447709 | -80.10760592 | 2021-04-13 04:20:37 | Crawford, Pennsylvania, US | |
2021-04-09 | US | Pennsylvania | Lawrence | 42073 | 6860 | 198 | 0 | 40.99206278 | -80.33393706 | 2021-04-10 04:20:59 | Lawrence, Pennsylvania, US | |
2021-03-01 | US | Tennessee | Tipton | 47167 | 6860 | 103 | 0 | 6847 | 35.501942 | -89.73694895 | 2021-03-02 05:23:30 | Tipton, Tennessee, US |
2021-02-26 | US | Virginia | Suffolk | 51800 | 6860 | 150 | 0 | 6710 | 36.70155394 | -76.63603554 | 2021-02-27 05:22:28 | Suffolk, Virginia, US |
2021-02-09 | US | New York | Chautauqua | 36013 | 6860 | 116 | 0 | 6744 | 42.22769210000001 | -79.36691763 | 2021-02-10 05:22:41 | Chautauqua, New York, US |
2021-02-08 | US | Missouri | Buchanan | 29021 | 6860 | 126 | 0 | 6734 | 39.65816401 | -94.80138942 | 2021-02-09 05:23:30 | Buchanan, Missouri, US |
2021-02-06 | US | Indiana | Floyd | 18043 | 6860 | 148 | 0 | 6712 | 38.32117957 | -85.90385377 | 2021-02-07 05:23:00 | Floyd, Indiana, US |
2020-12-22 | US | Arkansas | Saline | 5125 | 6860 | 87 | 0 | 6773 | 34.64916145 | -92.67583224 | 2020-12-23 05:22:03 | Saline, Arkansas, US |
2020-12-08 | Netherlands | Zeeland | 6860 | 105 | 0 | 6759 | 51.47936 | 3.861559 | 2020-12-09 05:28:01 | Zeeland, Netherlands | ||
2020-08-20 | US | Kansas | Johnson | 20091 | 6860 | 110 | 0 | 6750 | 38.88548175 | -94.82250877 | 2020-08-21 04:27:41 | Johnson, Kansas, US |
2020-06-05 | Azerbaijan | 6860 | 82 | 3871 | 2907 | 40.1431 | 47.5769 | 2020-06-06 02:33:00 | Azerbaijan | |||
2020-05-24 | Canada | Alberta | 6860 | 135 | 5924 | 801 | 53.9333 | -116.5765 | 2020-05-25 02:32:44 | Alberta, Canada | ||
2020-05-14 | US | Louisiana | Jefferson | 22051 | 6860 | 423 | 0 | 6437 | 29.74075478 | -90.11115756 | 2020-05-15 02:33:02 | Jefferson, Louisiana, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;