daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
75 rows where confirmed = 9782 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-21 | US | Ohio | Coshocton | 39031 | 9782 | 167 | 0 | 40.30096166 | -81.91729018 | 2022-12-22 04:20:56 | Coshocton, Ohio, US | |
2022-12-20 | US | Ohio | Coshocton | 39031 | 9782 | 167 | 0 | 40.30096166 | -81.91729018 | 2022-12-21 04:21:03 | Coshocton, Ohio, US | |
2022-12-19 | US | Ohio | Coshocton | 39031 | 9782 | 167 | 0 | 40.30096166 | -81.91729018 | 2022-12-20 04:21:04 | Coshocton, Ohio, US | |
2022-12-18 | US | Ohio | Coshocton | 39031 | 9782 | 167 | 0 | 40.30096166 | -81.91729018 | 2022-12-19 04:21:03 | Coshocton, Ohio, US | |
2022-12-17 | US | Ohio | Coshocton | 39031 | 9782 | 167 | 0 | 40.30096166 | -81.91729018 | 2022-12-18 04:21:03 | Coshocton, Ohio, US | |
2022-12-16 | US | Ohio | Coshocton | 39031 | 9782 | 167 | 0 | 40.30096166 | -81.91729018 | 2022-12-17 04:21:04 | Coshocton, Ohio, US | |
2022-12-15 | US | Ohio | Coshocton | 39031 | 9782 | 167 | 0 | 40.30096166 | -81.91729018 | 2022-12-16 04:21:01 | Coshocton, Ohio, US | |
2022-11-08 | US | Virginia | Pulaski | 51155 | 9782 | 152 | 0 | 37.06474963 | -80.71229738 | 2022-11-09 04:21:22 | Pulaski, Virginia, US | |
2022-08-16 | US | Tennessee | Claiborne | 47025 | 9782 | 188 | 0 | 36.48319149 | -83.65947309 | 2022-08-17 04:20:59 | Claiborne, Tennessee, US | |
2022-08-07 | US | New York | Allegany | 36003 | 9782 | 159 | 0 | 42.25748406 | -78.02750466 | 2022-08-08 04:21:08 | Allegany, New York, US | |
2022-08-05 | US | Puerto Rico | Manati | 72091 | 9782 | 0 | 0 | 18.420473 | -66.490461 | 2022-08-06 04:20:56 | Manati, Puerto Rico, US | |
2022-06-21 | Eritrea | 9782 | 103 | 0 | 15.1794 | 39.7823 | 2022-06-22 04:20:54 | Eritrea | ||||
2022-06-15 | US | Ohio | Mercer | 39107 | 9782 | 144 | 0 | 40.54043046 | -84.62912742 | 2022-06-16 04:20:55 | Mercer, Ohio, US | |
2022-06-14 | US | Ohio | Mercer | 39107 | 9782 | 144 | 0 | 40.54043046 | -84.62912742 | 2022-06-15 04:20:54 | Mercer, Ohio, US | |
2022-06-13 | US | Ohio | Mercer | 39107 | 9782 | 144 | 0 | 40.54043046 | -84.62912742 | 2022-06-14 04:20:52 | Mercer, Ohio, US | |
2022-06-12 | US | Ohio | Mercer | 39107 | 9782 | 144 | 0 | 40.54043046 | -84.62912742 | 2022-06-13 04:21:14 | Mercer, Ohio, US | |
2022-06-11 | US | Ohio | Mercer | 39107 | 9782 | 144 | 0 | 40.54043046 | -84.62912742 | 2022-06-12 04:20:53 | Mercer, Ohio, US | |
2022-06-10 | US | Ohio | Mercer | 39107 | 9782 | 144 | 0 | 40.54043046 | -84.62912742 | 2022-06-11 04:21:01 | Mercer, Ohio, US | |
2022-06-09 | US | Ohio | Mercer | 39107 | 9782 | 144 | 0 | 40.54043046 | -84.62912742 | 2022-06-10 04:20:55 | Mercer, Ohio, US | |
2022-06-08 | US | Florida | Unassigned | 90012 | 9782 | 176 | 0 | 30.86747479 | 0.0 | 2022-06-09 04:20:54 | Unassigned, Florida, US | |
2022-06-05 | US | Illinois | Monroe | 17133 | 9782 | 129 | 0 | 38.27594376 | -90.17761038 | 2022-06-06 04:20:57 | Monroe, Illinois, US | |
2022-06-04 | US | Illinois | Monroe | 17133 | 9782 | 129 | 0 | 38.27594376 | -90.17761038 | 2022-06-05 04:20:55 | Monroe, Illinois, US | |
2022-06-03 | US | Illinois | Monroe | 17133 | 9782 | 129 | 0 | 38.27594376 | -90.17761038 | 2022-06-04 04:20:58 | Monroe, Illinois, US | |
2022-06-02 | US | Indiana | Steuben | 18151 | 9782 | 122 | 0 | 41.64423868 | -85.00101094 | 2022-06-03 04:20:58 | Steuben, Indiana, US | |
2022-06-01 | US | Indiana | Steuben | 18151 | 9782 | 122 | 0 | 41.64423868 | -85.00101094 | 2022-06-02 05:20:39 | Steuben, Indiana, US | |
2022-02-28 | US | Wyoming | Teton | 56039 | 9782 | 16 | 0 | 43.93522482 | -110.5890801 | 2022-03-01 04:21:09 | Teton, Wyoming, US | |
2022-02-23 | US | Wyoming | Albany | 56001 | 9782 | 47 | 0 | 41.65498705 | -105.72354150000001 | 2022-02-24 04:21:14 | Albany, Wyoming, US | |
2022-02-09 | US | Missouri | Platte | 29165 | 9782 | 87 | 0 | 39.38154439 | -94.77068479 | 2022-02-10 04:21:14 | Platte, Missouri, US | |
2022-01-31 | US | California | Unassigned | 90006 | 9782 | 3 | 0 | 41.74228275 | 0.0 | 2022-02-01 04:21:11 | Unassigned, California, US | |
2022-01-20 | US | Pennsylvania | Bedford | 42009 | 9782 | 242 | 0 | 40.00522157 | -78.48998442 | 2022-01-21 04:21:09 | Bedford, Pennsylvania, US | |
2022-01-16 | Malaysia | W.P. Putrajaya | 9782 | 22 | 0 | 2.9264 | 101.6964 | 2022-01-17 04:21:08 | W.P. Putrajaya, Malaysia | |||
2022-01-05 | US | Nevada | Carson City | 32510 | 9782 | 183 | 0 | 39.15509045 | -119.7480219 | 2022-01-06 04:22:09 | Carson City, Nevada, US | |
2022-01-03 | US | West Virginia | Jefferson | 54037 | 9782 | 98 | 0 | 39.30776166 | -77.86014147 | 2022-01-04 04:22:17 | Jefferson, West Virginia, US | |
2022-01-01 | US | Alabama | Coffee | 1031 | 9782 | 195 | 0 | 31.39932826 | -85.98901039 | 2022-01-02 04:20:52 | Coffee, Alabama, US | |
2021-12-31 | US | Alabama | Coffee | 1031 | 9782 | 195 | 0 | 31.39932826 | -85.98901039 | 2022-01-01 04:22:14 | Coffee, Alabama, US | |
2021-12-06 | US | North Carolina | Lenoir | 37107 | 9782 | 179 | 0 | 35.24032589999999 | -77.64245615 | 2021-12-07 04:22:34 | Lenoir, North Carolina, US | |
2021-12-02 | US | Tennessee | Lawrence | 47099 | 9782 | 131 | 0 | 35.21675201 | -87.39787695 | 2021-12-03 04:23:05 | Lawrence, Tennessee, US | |
2021-11-28 | US | Georgia | Catoosa | 13047 | 9782 | 116 | 0 | 34.89872298 | -85.13757014 | 2021-11-29 04:22:30 | Catoosa, Georgia, US | |
2021-11-27 | US | Georgia | Catoosa | 13047 | 9782 | 116 | 0 | 34.89872298 | -85.13757014 | 2021-11-28 04:22:43 | Catoosa, Georgia, US | |
2021-11-26 | US | Georgia | Catoosa | 13047 | 9782 | 116 | 0 | 34.89872298 | -85.13757014 | 2021-11-27 04:22:45 | Catoosa, Georgia, US | |
2021-11-25 | US | Georgia | Catoosa | 13047 | 9782 | 116 | 0 | 34.89872298 | -85.13757014 | 2021-11-26 04:22:33 | Catoosa, Georgia, US | |
2021-11-24 | US | Georgia | Catoosa | 13047 | 9782 | 116 | 0 | 34.89872298 | -85.13757014 | 2021-11-25 04:22:33 | Catoosa, Georgia, US | |
2021-11-17 | US | California | Nevada | 6057 | 9782 | 92 | 0 | 39.30394768 | -120.76272809999999 | 2021-11-18 04:21:33 | Nevada, California, US | |
2021-11-09 | US | Oregon | Josephine | 41033 | 9782 | 211 | 0 | 42.3665549 | -123.5561938 | 2021-11-10 04:21:38 | Josephine, Oregon, US | |
2021-10-20 | US | Nebraska | Hall | 31079 | 9782 | 117 | 0 | 40.87257079 | -98.50218293 | 2021-10-21 04:21:18 | Hall, Nebraska, US | |
2021-10-11 | US | Indiana | Grant | 18053 | 9782 | 216 | 0 | 40.51587228 | -85.65468702 | 2021-10-12 04:21:09 | Grant, Indiana, US | |
2021-10-05 | US | Washington | Skagit | 53057 | 9782 | 99 | 0 | 48.48171488 | -121.766131 | 2021-10-06 04:21:33 | Skagit, Washington, US | |
2021-09-08 | US | Mississippi | Lowndes | 28087 | 9782 | 165 | 0 | 33.47386518 | -88.44191529999998 | 2021-09-09 04:21:27 | Lowndes, Mississippi, US | |
2021-08-20 | US | Tennessee | Anderson | 47001 | 9782 | 181 | 0 | 36.12684348 | -84.19965764 | 2021-08-21 04:21:38 | Anderson, Tennessee, US | |
2021-07-16 | US | Alabama | Lauderdale | 1077 | 9782 | 253 | 0 | 34.90171875 | -87.65624729 | 2021-07-17 04:22:22 | Lauderdale, Alabama, US | |
2021-07-10 | US | California | Sutter | 6101 | 9782 | 114 | 0 | 39.03417539 | -121.6945899 | 2021-07-11 04:21:43 | Sutter, California, US | |
2021-07-09 | US | California | Sutter | 6101 | 9782 | 114 | 0 | 39.03417539 | -121.6945899 | 2021-07-10 04:21:25 | Sutter, California, US | |
2021-06-17 | US | Pennsylvania | Mercer | 42085 | 9782 | 261 | 0 | 41.30248872 | -80.25816981 | 2021-06-18 04:22:16 | Mercer, Pennsylvania, US | |
2021-06-02 | US | New Jersey | Hunterdon | 34019 | 9782 | 176 | 0 | 40.56335249 | -74.91284156 | 2021-06-03 04:23:32 | Hunterdon, New Jersey, US | |
2021-05-24 | US | South Carolina | Oconee | 45073 | 9782 | 134 | 0 | 34.75225169 | -83.06742317 | 2021-05-25 04:21:08 | Oconee, South Carolina, US | |
2021-04-23 | US | California | Napa | 6055 | 9782 | 79 | 0 | 38.50735751 | -122.332839 | 2021-04-24 04:20:38 | Napa, California, US | |
2021-03-28 | US | Connecticut | Windham | 9015 | 9782 | 187 | 0 | 41.82972709 | -71.98182316 | 2021-03-29 04:28:35 | Windham, Connecticut, US | |
2021-03-27 | US | Connecticut | Windham | 9015 | 9782 | 187 | 0 | 41.82972709 | -71.98182316 | 2021-03-28 05:28:10 | Windham, Connecticut, US | |
2021-03-26 | US | Mississippi | Madison | 28089 | 9782 | 207 | 0 | 32.63389156 | -90.03513564 | 2021-03-27 05:25:04 | Madison, Mississippi, US | |
2021-03-26 | US | Connecticut | Windham | 9015 | 9782 | 187 | 0 | 41.82972709 | -71.98182316 | 2021-03-27 05:25:04 | Windham, Connecticut, US | |
2021-03-24 | US | Illinois | Macon | 17115 | 9782 | 187 | 0 | 39.86064913 | -88.96342505 | 2021-03-25 05:27:00 | Macon, Illinois, US | |
2021-03-22 | US | New Mexico | Santa Fe | 35049 | 9782 | 142 | 0 | 35.50708973 | -105.9774716 | 2021-03-23 05:26:18 | Santa Fe, New Mexico, US | |
2021-02-26 | US | North Dakota | Grand Forks | 38035 | 9782 | 75 | 0 | 9726 | 47.92093639 | -97.45450447 | 2021-02-27 05:22:28 | Grand Forks, North Dakota, US |
2021-02-17 | India | Ladakh | 9782 | 130 | 9604 | 48 | 34.1526 | 77.5771 | 2021-02-18 05:22:58 | Ladakh, India | ||
2021-02-13 | US | Iowa | Dallas | 19049 | 9782 | 85 | 0 | 9697 | 41.68560356 | -94.04127625 | 2021-02-14 05:23:43 | Dallas, Iowa, US |
2021-01-30 | Ukraine | Kirovohrad Oblast | 9782 | 323 | 6874 | 2585 | 48.5079 | 32.2623 | 2021-01-31 05:22:42 | Kirovohrad Oblast, Ukraine | ||
2021-01-28 | Mexico | Nayarit | 9782 | 1304 | 0 | 8478 | 21.7514 | -104.8455 | 2021-01-29 05:22:23 | Nayarit, Mexico | ||
2021-01-27 | US | Connecticut | Litchfield | 9005 | 9782 | 252 | 0 | 9530 | 41.7937534 | -73.2451475 | 2021-01-28 05:22:24 | Litchfield, Connecticut, US |
2021-01-13 | Colombia | Casanare | 9782 | 194 | 9016 | 572 | 5.7589 | -71.5724 | 2021-01-14 05:22:32 | Casanare, Colombia | ||
2021-01-06 | US | Wisconsin | Eau Claire | 55035 | 9782 | 90 | 0 | 9692 | 44.726614 | -91.28609183 | 2021-01-07 05:22:03 | Eau Claire, Wisconsin, US |
2020-11-12 | Canada | Manitoba | 9782 | 132 | 3620 | 6030 | 53.7609 | -98.8139 | 2020-11-13 05:25:30 | Manitoba, Canada | ||
2020-11-04 | US | Texas | Williamson | 48491 | 9782 | 157 | 0 | 9741 | 30.64655664 | -97.6004854 | 2020-11-05 06:05:03 | Williamson, Texas, US |
2020-10-29 | Russia | Chuvashia Republic | 9782 | 139 | 8306 | 1337 | 55.4259922 | 47.0849429 | 2020-10-30 04:24:49 | Chuvashia Republic, Russia | ||
2020-10-18 | US | Colorado | El Paso | 8041 | 9782 | 206 | 0 | 8272 | 38.83240149 | -104.5251411 | 2020-10-19 04:24:16 | El Paso, Colorado, US |
2020-09-15 | US | Hawaii | Honolulu | 15003 | 9782 | 87 | 0 | 9695 | 21.45803166 | -157.97121819999995 | 2020-09-16 04:22:53 | Honolulu, Hawaii, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;