johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
52 rows where confirmed = 9770 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3555152 | 3555152 | 2022-11-27 | US | West Virginia | Mineral | 54057 | 9770 | 166 | 0 | 39.41561583 | -78.94104895 | 2022-11-28 04:21:02 | Mineral, West Virginia, US | |
2103632 | 2103632 | 2022-11-26 | US | West Virginia | Mineral | 54057 | 9770 | 166 | 0 | 39.41561583 | -78.94104895 | 2022-11-27 04:21:05 | Mineral, West Virginia, US | |
491123 | 491123 | 2022-11-25 | US | West Virginia | Mineral | 54057 | 9770 | 166 | 0 | 39.41561583 | -78.94104895 | 2022-11-26 04:21:11 | Mineral, West Virginia, US | |
3526952 | 3526952 | 2022-11-24 | US | West Virginia | Mineral | 54057 | 9770 | 166 | 0 | 39.41561583 | -78.94104895 | 2022-11-25 04:21:06 | Mineral, West Virginia, US | |
3315735 | 3315735 | 2022-11-23 | US | West Virginia | Mineral | 54057 | 9770 | 166 | 0 | 39.41561583 | -78.94104895 | 2022-11-24 04:21:09 | Mineral, West Virginia, US | |
3599892 | 3599892 | 2022-11-14 | US | South Carolina | Williamsburg | 45089 | 9770 | 150 | 0 | 33.62190129 | -79.72767442 | 2022-11-15 04:21:16 | Williamsburg, South Carolina, US | |
314750 | 314750 | 2022-11-13 | US | South Carolina | Williamsburg | 45089 | 9770 | 150 | 0 | 33.62190129 | -79.72767442 | 2022-11-14 04:21:09 | Williamsburg, South Carolina, US | |
65911 | 65911 | 2022-11-12 | US | South Carolina | Williamsburg | 45089 | 9770 | 150 | 0 | 33.62190129 | -79.72767442 | 2022-11-13 04:21:14 | Williamsburg, South Carolina, US | |
2930073 | 2930073 | 2022-11-11 | US | South Carolina | Williamsburg | 45089 | 9770 | 150 | 0 | 33.62190129 | -79.72767442 | 2022-11-12 04:20:41 | Williamsburg, South Carolina, US | |
2508909 | 2508909 | 2022-11-10 | US | South Carolina | Williamsburg | 45089 | 9770 | 150 | 0 | 33.62190129 | -79.72767442 | 2022-11-11 04:21:22 | Williamsburg, South Carolina, US | |
2433784 | 2433784 | 2022-11-09 | US | South Carolina | Williamsburg | 45089 | 9770 | 150 | 0 | 33.62190129 | -79.72767442 | 2022-11-10 04:21:16 | Williamsburg, South Carolina, US | |
482440 | 482440 | 2022-11-08 | US | South Carolina | Williamsburg | 45089 | 9770 | 150 | 0 | 33.62190129 | -79.72767442 | 2022-11-09 04:21:22 | Williamsburg, South Carolina, US | |
2162655 | 2162655 | 2022-10-16 | US | Texas | Hill | 48217 | 9770 | 199 | 0 | 31.99045053 | -97.13423143 | 2022-10-17 04:20:31 | Hill, Texas, US | |
518852 | 518852 | 2022-10-15 | US | Texas | Hill | 48217 | 9770 | 199 | 0 | 31.99045053 | -97.13423143 | 2022-10-16 04:22:39 | Hill, Texas, US | |
2035909 | 2035909 | 2022-10-14 | US | Texas | Hill | 48217 | 9770 | 199 | 0 | 31.99045053 | -97.13423143 | 2022-10-15 04:22:00 | Hill, Texas, US | |
133721 | 133721 | 2022-10-04 | US | Tennessee | Macon | 47111 | 9770 | 156 | 0 | 36.53157855 | -86.00778595 | 2022-10-05 04:23:06 | Macon, Tennessee, US | |
2346174 | 2346174 | 2022-08-31 | US | Puerto Rico | Hatillo | 72065 | 9770 | 0 | 0 | 18.410928 | -66.796326 | 2022-09-01 04:21:03 | Hatillo, Puerto Rico, US | |
3733663 | 3733663 | 2022-04-03 | US | Virginia | York | 51199 | 9770 | 105 | 0 | 37.24374789 | -76.54412815 | 2022-04-04 04:20:51 | York, Virginia, US | |
503098 | 503098 | 2022-04-02 | US | Virginia | York | 51199 | 9770 | 105 | 0 | 37.24374789 | -76.54412815 | 2022-04-03 04:20:48 | York, Virginia, US | |
3354083 | 3354083 | 2022-04-01 | US | Virginia | York | 51199 | 9770 | 105 | 0 | 37.24374789 | -76.54412815 | 2022-04-02 04:20:47 | York, Virginia, US | |
2267412 | 2267412 | 2022-03-14 | US | West Virginia | Wayne | 54099 | 9770 | 114 | 0 | 38.14901357 | -82.42287994 | 2022-03-15 04:20:47 | Wayne, West Virginia, US | |
1993215 | 1993215 | 2022-03-01 | US | California | Lassen | 6035 | 9770 | 60 | 0 | 40.67311306 | -120.59350990000002 | 2022-03-02 04:21:07 | Lassen, California, US | |
1299614 | 1299614 | 2022-02-17 | US | Maine | Oxford | 23017 | 9770 | 126 | 0 | 44.49952995 | -70.75682123 | 2022-02-18 04:21:04 | Oxford, Maine, US | |
1467050 | 1467050 | 2022-02-10 | US | Tennessee | Lincoln | 47103 | 9770 | 135 | 0 | 35.13738622 | -86.58910106 | 2022-02-11 04:21:09 | Lincoln, Tennessee, US | |
1473690 | 1473690 | 2022-01-17 | US | Maryland | Calvert | 24009 | 9770 | 112 | 0 | 38.53961642 | -76.56820632 | 2022-01-18 04:21:04 | Calvert, Maryland, US | |
555681 | 555681 | 2022-01-16 | US | Georgia | Unassigned | 90013 | 9770 | 8 | 0 | 34.91369188 | 0.0 | 2022-01-17 04:21:08 | Unassigned, Georgia, US | |
3841402 | 3841402 | 2022-01-15 | US | Georgia | Unassigned | 90013 | 9770 | 8 | 0 | 34.91369188 | 0.0 | 2022-01-16 04:21:12 | Unassigned, Georgia, US | |
100217 | 100217 | 2022-01-14 | US | Georgia | Unassigned | 90013 | 9770 | 8 | 0 | 34.91369188 | 0.0 | 2022-01-15 04:21:07 | Unassigned, Georgia, US | |
1256747 | 1256747 | 2021-12-20 | US | Missouri | Taney | 29213 | 9770 | 173 | 0 | 36.65465345 | -93.04075153 | 2021-12-21 03:21:27 | Taney, Missouri, US | |
1664021 | 1664021 | 2021-12-12 | US | Wisconsin | Waupaca | 55135 | 9770 | 204 | 0 | 44.47068056 | -88.96534501 | 2021-12-13 04:22:02 | Waupaca, Wisconsin, US | |
1668037 | 1668037 | 2021-12-11 | US | Wisconsin | Waupaca | 55135 | 9770 | 204 | 0 | 44.47068056 | -88.96534501 | 2021-12-12 04:22:12 | Waupaca, Wisconsin, US | |
3659189 | 3659189 | 2021-12-10 | US | Wisconsin | Waupaca | 55135 | 9770 | 204 | 0 | 44.47068056 | -88.96534501 | 2021-12-11 04:22:45 | Waupaca, Wisconsin, US | |
1145999 | 1145999 | 2021-12-01 | US | Indiana | Boone | 18011 | 9770 | 121 | 0 | 40.0509304 | -86.46841646 | 2021-12-02 04:22:37 | Boone, Indiana, US | |
1803203 | 1803203 | 2021-11-25 | US | Arizona | Santa Cruz | 4023 | 9770 | 196 | 0 | 31.52508998 | -110.8479088 | 2021-11-26 04:22:33 | Santa Cruz, Arizona, US | |
2924572 | 2924572 | 2021-08-27 | US | Kentucky | Campbell | 21037 | 9770 | 83 | 0 | 38.94384345 | -84.37875208 | 2021-08-28 04:21:28 | Campbell, Kentucky, US | |
1893095 | 1893095 | 2021-06-30 | India | Lakshadweep | 9770 | 48 | 9411 | 311 | 13.6999972 | 72.18333259999999 | 2021-07-01 04:21:19 | Lakshadweep, India | ||
2296403 | 2296403 | 2021-06-24 | US | Idaho | Twin Falls | 16083 | 9770 | 131 | 0 | 42.35440512 | -114.6685381 | 2021-06-25 04:21:33 | Twin Falls, Idaho, US | |
3973230 | 3973230 | 2021-06-11 | US | Pennsylvania | Mercer | 42085 | 9770 | 261 | 0 | 41.30248872 | -80.25816981 | 2021-06-12 04:22:22 | Mercer, Pennsylvania, US | |
2107807 | 2107807 | 2021-06-01 | Malaysia | Pahang | 9770 | 48 | 6823 | 2899 | 3.8126 | 103.3256 | 2021-06-02 04:24:34 | Pahang, Malaysia | ||
1808911 | 1808911 | 2021-05-27 | US | New Jersey | Hunterdon | 34019 | 9770 | 176 | 0 | 40.56335249 | -74.91284156 | 2021-05-28 04:20:36 | Hunterdon, New Jersey, US | |
1774171 | 1774171 | 2021-05-23 | US | South Carolina | Oconee | 45073 | 9770 | 133 | 0 | 34.75225169 | -83.06742317 | 2021-05-24 04:20:53 | Oconee, South Carolina, US | |
2941754 | 2941754 | 2021-05-16 | US | North Dakota | Ward | 38101 | 9770 | 194 | 0 | 48.22390169 | -101.5436763 | 2021-05-17 04:20:34 | Ward, North Dakota, US | |
647575 | 647575 | 2021-05-05 | US | Michigan | Eaton | 26045 | 9770 | 189 | 0 | 42.59599185 | -84.83740035 | 2021-05-06 04:20:38 | Eaton, Michigan, US | |
2827765 | 2827765 | 2021-05-01 | US | Tennessee | Robertson | 47147 | 9770 | 131 | 0 | 36.52454807 | -86.87346725 | 2021-05-02 04:20:48 | Robertson, Tennessee, US | |
704219 | 704219 | 2021-03-16 | US | Mississippi | Lee | 28081 | 9770 | 166 | 0 | 34.291877500000005 | -88.68149954 | 2021-03-17 05:25:07 | Lee, Mississippi, US | |
1676637 | 1676637 | 2021-02-01 | Peru | Madre de Dios | 9770 | 167 | 0 | 9603 | -11.972699 | -70.53171999999998 | 2021-02-02 05:22:49 | Madre de Dios, Peru | ||
2192165 | 2192165 | 2020-10-21 | US | California | Santa Barbara | 6083 | 9770 | 121 | 0 | 9638 | 34.65329488 | -120.0188492 | 2020-10-22 04:24:27 | Santa Barbara, California, US |
1823292 | 1823292 | 2020-10-04 | US | Arkansas | Pulaski | 5119 | 9770 | 156 | 0 | 9614 | 34.77054088 | -92.31355101 | 2020-10-05 04:23:33 | Pulaski, Arkansas, US |
2836885 | 2836885 | 2020-09-21 | Maldives | 9770 | 34 | 8390 | 1346 | 3.2028 | 73.2207 | 2020-09-22 04:23:00 | Maldives | |||
1500270 | 1500270 | 2020-07-25 | US | Texas | Fort Bend | 48157 | 9770 | 90 | 0 | 6440 | 29.52704478 | -95.77219463 | 2020-07-26 04:35:00 | Fort Bend, Texas, US |
1704822 | 1704822 | 2020-07-21 | US | Colorado | Denver | 8031 | 9770 | 401 | 0 | 8133 | 39.76018276 | -104.87256950000001 | 2020-07-22 04:34:42 | Denver, Colorado, US |
1104902 | 1104902 | 2020-05-25 | Germany | Hessen | 9770 | 460 | 8500 | 810 | 50.6521 | 9.1624 | 2020-05-26 02:32:35 | Hessen, Germany |
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]);