johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
67 rows where confirmed = 8020 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
836063 | 836063 | 2022-12-02 | US | North Dakota | Stutsman | 38093 | 8020 | 97 | 0 | 46.97962541 | -98.95637318 | 2022-12-03 04:21:02 | Stutsman, North Dakota, US | |
713409 | 713409 | 2022-11-01 | US | Tennessee | Hickman | 47081 | 8020 | 119 | 0 | 35.80609681 | -87.47643507 | 2022-11-02 04:22:09 | Hickman, Tennessee, US | |
3775755 | 3775755 | 2022-08-30 | US | Mississippi | Simpson | 28127 | 8020 | 154 | 0 | 31.91282117 | -89.91716179 | 2022-08-31 04:20:57 | Simpson, Mississippi, US | |
1682351 | 1682351 | 2022-08-29 | US | Mississippi | Simpson | 28127 | 8020 | 154 | 0 | 31.91282117 | -89.91716179 | 2022-08-30 04:21:03 | Simpson, Mississippi, US | |
1878835 | 1878835 | 2022-08-28 | US | Mississippi | Simpson | 28127 | 8020 | 154 | 0 | 31.91282117 | -89.91716179 | 2022-08-29 04:21:06 | Simpson, Mississippi, US | |
2097962 | 2097962 | 2022-08-27 | US | Mississippi | Simpson | 28127 | 8020 | 154 | 0 | 31.91282117 | -89.91716179 | 2022-08-28 04:21:02 | Simpson, Mississippi, US | |
1533777 | 1533777 | 2022-08-26 | US | Mississippi | Simpson | 28127 | 8020 | 154 | 0 | 31.91282117 | -89.91716179 | 2022-08-27 04:20:57 | Simpson, Mississippi, US | |
2830664 | 2830664 | 2022-08-25 | US | Mississippi | Simpson | 28127 | 8020 | 154 | 0 | 31.91282117 | -89.91716179 | 2022-08-26 04:21:02 | Simpson, Mississippi, US | |
2326116 | 2326116 | 2022-08-24 | US | Puerto Rico | Naranjito | 72105 | 8020 | 0 | 0 | 18.288019 | -66.252703 | 2022-08-25 04:21:13 | Naranjito, Puerto Rico, US | |
2325197 | 2325197 | 2022-08-24 | US | Mississippi | Simpson | 28127 | 8020 | 154 | 0 | 31.91282117 | -89.91716179 | 2022-08-25 04:21:13 | Simpson, Mississippi, US | |
1252606 | 1252606 | 2022-08-23 | US | Mississippi | Simpson | 28127 | 8020 | 154 | 0 | 31.91282117 | -89.91716179 | 2022-08-24 04:20:46 | Simpson, Mississippi, US | |
3405842 | 3405842 | 2022-07-17 | US | Alabama | Lawrence | 1079 | 8020 | 160 | 0 | 34.52041498 | -87.31069453 | 2022-07-18 04:20:59 | Lawrence, Alabama, US | |
2152042 | 2152042 | 2022-07-16 | US | Alabama | Lawrence | 1079 | 8020 | 160 | 0 | 34.52041498 | -87.31069453 | 2022-07-17 04:21:15 | Lawrence, Alabama, US | |
2419275 | 2419275 | 2022-07-15 | US | Alabama | Lawrence | 1079 | 8020 | 160 | 0 | 34.52041498 | -87.31069453 | 2022-07-16 04:21:05 | Lawrence, Alabama, US | |
2492992 | 2492992 | 2022-06-29 | US | Tennessee | McNairy | 47109 | 8020 | 126 | 0 | 35.17468549 | -88.5647812 | 2022-06-30 04:21:01 | McNairy, Tennessee, US | |
2251943 | 2251943 | 2022-04-19 | US | Arkansas | Poinsett | 5111 | 8020 | 126 | 0 | 35.57433534 | -90.66268713 | 2022-04-20 04:20:45 | Poinsett, Arkansas, US | |
1846493 | 1846493 | 2022-04-18 | US | Arkansas | Poinsett | 5111 | 8020 | 126 | 0 | 35.57433534 | -90.66268713 | 2022-04-19 04:21:00 | Poinsett, Arkansas, US | |
3208970 | 3208970 | 2022-04-11 | US | Pennsylvania | Tioga | 42117 | 8020 | 192 | 0 | 41.77255149 | -77.25433032 | 2022-04-12 04:20:49 | Tioga, Pennsylvania, US | |
1578856 | 1578856 | 2022-04-10 | US | Pennsylvania | Tioga | 42117 | 8020 | 192 | 0 | 41.77255149 | -77.25433032 | 2022-04-11 04:21:02 | Tioga, Pennsylvania, US | |
3911870 | 3911870 | 2022-02-20 | Comoros | 8020 | 160 | 0 | -11.6455 | 43.3333 | 2022-02-21 04:21:05 | Comoros | ||||
3076076 | 3076076 | 2022-02-09 | US | Montana | Silver Bow | 30093 | 8020 | 118 | 0 | 45.90018933 | -112.6620092 | 2022-02-10 04:21:14 | Silver Bow, Montana, US | |
980454 | 980454 | 2022-02-01 | US | Louisiana | Evangeline | 22039 | 8020 | 148 | 0 | 30.72985248 | -92.39915924 | 2022-02-02 04:21:09 | Evangeline, Louisiana, US | |
1320196 | 1320196 | 2022-01-26 | US | Missouri | Webster | 29225 | 8020 | 128 | 0 | 37.2813734 | -92.876329 | 2022-01-27 04:21:19 | Webster, Missouri, US | |
1472479 | 1472479 | 2022-01-17 | US | Alabama | Covington | 1039 | 8020 | 203 | 0 | 31.247785399999998 | -86.45050893 | 2022-01-18 04:21:04 | Covington, Alabama, US | |
3615558 | 3615558 | 2022-01-12 | US | Ohio | Mercer | 39107 | 8020 | 118 | 0 | 40.54043046 | -84.62912742 | 2022-01-13 08:00:09 | Mercer, Ohio, US | |
731998 | 731998 | 2021-12-27 | US | Kentucky | Shelby | 21211 | 8020 | 128 | 0 | 38.21476019 | -85.194223 | 2021-12-28 04:21:47 | Shelby, Kentucky, US | |
731928 | 731928 | 2021-12-27 | US | Kentucky | Floyd | 21071 | 8020 | 146 | 0 | 37.56213922 | -82.74750924 | 2021-12-28 04:21:47 | Floyd, Kentucky, US | |
1147635 | 1147635 | 2021-12-01 | US | Pennsylvania | Venango | 42121 | 8020 | 170 | 0 | 41.40323442 | -79.75845449 | 2021-12-02 04:22:37 | Venango, Pennsylvania, US | |
758170 | 758170 | 2021-11-26 | Colombia | San Andres y Providencia | 8020 | 146 | 0 | 12.5567 | -81.7185 | 2021-11-27 04:22:45 | San Andres y Providencia, Colombia | |||
906884 | 906884 | 2021-11-24 | US | Pennsylvania | Union | 42119 | 8020 | 109 | 0 | 40.96188846 | -77.05996014 | 2021-11-25 04:22:33 | Union, Pennsylvania, US | |
684965 | 684965 | 2021-10-24 | US | Oregon | Klamath | 41035 | 8020 | 119 | 0 | 42.68762984 | -121.64964609999998 | 2021-10-25 04:22:31 | Klamath, Oregon, US | |
772973 | 772973 | 2021-10-23 | US | Oregon | Klamath | 41035 | 8020 | 119 | 0 | 42.68762984 | -121.64964609999998 | 2021-10-24 04:21:22 | Klamath, Oregon, US | |
656620 | 656620 | 2021-10-22 | US | Oregon | Klamath | 41035 | 8020 | 119 | 0 | 42.68762984 | -121.64964609999998 | 2021-10-23 04:21:32 | Klamath, Oregon, US | |
2125493 | 2125493 | 2021-10-21 | US | Minnesota | Otter Tail | 27111 | 8020 | 105 | 0 | 46.40846929 | -95.70835255 | 2021-10-22 04:21:14 | Otter Tail, Minnesota, US | |
3010270 | 3010270 | 2021-10-11 | US | Tennessee | Dyer | 47045 | 8020 | 141 | 0 | 36.05931946 | -89.41542855 | 2021-10-12 04:21:09 | Dyer, Tennessee, US | |
987594 | 987594 | 2021-10-04 | US | Colorado | Eagle | 8037 | 8020 | 31 | 0 | 39.62754308 | -106.6933637 | 2021-10-05 04:21:27 | Eagle, Colorado, US | |
1276931 | 1276931 | 2021-10-03 | US | Oregon | Yamhill | 41071 | 8020 | 104 | 0 | 45.23330449 | -123.3086963 | 2021-10-04 04:21:31 | Yamhill, Oregon, US | |
3930684 | 3930684 | 2021-10-02 | US | Oregon | Yamhill | 41071 | 8020 | 104 | 0 | 45.23330449 | -123.3086963 | 2021-10-03 04:21:24 | Yamhill, Oregon, US | |
2134664 | 2134664 | 2021-10-01 | US | Oregon | Yamhill | 41071 | 8020 | 104 | 0 | 45.23330449 | -123.3086963 | 2021-10-02 04:21:25 | Yamhill, Oregon, US | |
1724512 | 1724512 | 2021-09-25 | Japan | Oita | 8020 | 81 | 0 | 33.200697 | 131.43323999999998 | 2021-09-26 04:21:29 | Oita, Japan | |||
2282459 | 2282459 | 2021-09-08 | US | Virginia | Augusta | 51015 | 8020 | 90 | 0 | 38.16404586 | -79.12461614 | 2021-09-09 04:21:27 | Augusta, Virginia, US | |
2069361 | 2069361 | 2021-08-31 | US | Kentucky | Pike | 21195 | 8020 | 126 | 0 | 37.47088263 | -82.39487445 | 2021-09-01 04:21:38 | Pike, Kentucky, US | |
3894556 | 3894556 | 2021-08-29 | US | Oregon | Linn | 41043 | 8020 | 82 | 0 | 44.48899494 | -122.53731540000001 | 2021-08-30 04:21:23 | Linn, Oregon, US | |
2795659 | 2795659 | 2021-08-28 | US | Oregon | Linn | 41043 | 8020 | 82 | 0 | 44.48899494 | -122.53731540000001 | 2021-08-29 04:21:14 | Linn, Oregon, US | |
2925818 | 2925818 | 2021-08-27 | US | Oregon | Linn | 41043 | 8020 | 82 | 0 | 44.48899494 | -122.53731540000001 | 2021-08-28 04:21:28 | Linn, Oregon, US | |
2521002 | 2521002 | 2021-08-18 | US | South Carolina | Laurens | 45059 | 8020 | 173 | 0 | 34.48244419 | -82.00490796 | 2021-08-19 04:21:15 | Laurens, South Carolina, US | |
3477459 | 3477459 | 2021-07-22 | US | Indiana | Warrick | 18173 | 8020 | 157 | 0 | 38.08922676 | -87.2716085 | 2021-07-23 04:21:29 | Warrick, Indiana, US | |
1312622 | 1312622 | 2021-05-26 | US | Ohio | Erie | 39043 | 8020 | 164 | 0 | 41.36796058 | -82.62904521 | 2021-05-27 04:20:59 | Erie, Ohio, US | |
86243 | 86243 | 2021-05-25 | US | Texas | Liberty | 48291 | 8020 | 187 | 0 | 30.15152688 | -94.81205615 | 2021-05-26 04:20:35 | Liberty, Texas, US | |
726949 | 726949 | 2021-05-22 | US | Arizona | Santa Cruz | 4023 | 8020 | 180 | 0 | 31.52508998 | -110.8479088 | 2021-05-23 04:20:51 | Santa Cruz, Arizona, US | |
3114386 | 3114386 | 2021-05-06 | US | Guam | 66 | 8020 | 139 | 0 | 13.4443 | 144.7937 | 2021-05-07 04:20:40 | Guam, US | ||
1293438 | 1293438 | 2021-03-29 | US | Washington | Grant | 53025 | 8020 | 69 | 0 | 47.20753737 | -119.4500749 | 2021-03-30 04:26:23 | Grant, Washington, US | |
3670102 | 3670102 | 2021-03-06 | US | Ohio | Marion | 39101 | 8020 | 136 | 0 | 7884 | 40.58610662 | -83.15736305 | 2021-03-07 05:21:54 | Marion, Ohio, US |
2183411 | 2183411 | 2021-02-26 | China | Unknown | 8020 | 0 | 5 | 0 | 2021-02-27 05:22:28 | Unknown, China | ||||
3881830 | 3881830 | 2021-01-14 | US | New York | Schenectady | 36093 | 8020 | 114 | 0 | 7906 | 42.81668777 | -74.05278291 | 2021-01-15 05:22:24 | Schenectady, New York, US |
3771709 | 3771709 | 2020-12-22 | US | Mississippi | Rankin | 28121 | 8020 | 149 | 0 | 7871 | 32.26469147 | -89.94537876 | 2020-12-23 05:22:03 | Rankin, Mississippi, US |
740775 | 740775 | 2020-12-02 | US | Ohio | Lorain | 39093 | 8020 | 174 | 0 | 7846 | 41.29553751 | -82.15083537 | 2020-12-03 05:28:22 | Lorain, Ohio, US |
1973600 | 1973600 | 2020-11-25 | US | Illinois | McLean | 17113 | 8020 | 52 | 0 | 7968 | 40.48996987 | -88.84621113 | 2020-11-26 05:27:44 | McLean, Illinois, US |
3341222 | 3341222 | 2020-11-17 | US | Oregon | Washington | 41067 | 8020 | 92 | 0 | 7928 | 45.55972701 | -123.0955257 | 2020-11-18 05:40:31 | Washington, Oregon, US |
3990570 | 3990570 | 2020-10-20 | India | Nagaland | 8020 | 28 | 6334 | 1658 | 26.06702 | 94.470302 | 2020-10-21 04:24:14 | Nagaland, India | ||
2857030 | 2857030 | 2020-10-16 | Russia | Astrakhan Oblast | 8020 | 139 | 6725 | 1156 | 47.1878186 | 47.608851 | 2020-10-17 04:24:12 | Astrakhan Oblast, Russia | ||
2689933 | 2689933 | 2020-10-08 | Russia | Tyva Republic | 8020 | 85 | 6920 | 1015 | 51.4017149 | 93.8582593 | 2020-10-09 04:23:59 | Tyva Republic, Russia | ||
3319835 | 3319835 | 2020-09-22 | Ukraine | Kiev Oblast | 8020 | 161 | 4999 | 2860 | 50.053 | 30.7667 | 2020-09-23 04:23:00 | Kiev Oblast, Ukraine | ||
1705220 | 1705220 | 2020-07-21 | US | Ohio | Hamilton | 39061 | 8020 | 205 | 0 | 7815 | 39.19673558 | -84.54502924 | 2020-07-22 04:34:42 | Hamilton, Ohio, US |
1691931 | 1691931 | 2020-06-19 | Sudan | 8020 | 506 | 3086 | 4428 | 12.8628 | 30.2176 | 2020-06-20 04:33:19 | Sudan | |||
3683080 | 3683080 | 2020-06-18 | Sudan | 8020 | 487 | 2966 | 4567 | 12.8628 | 30.2176 | 2020-06-19 04:33:17 | Sudan | |||
2387940 | 2387940 | 2020-05-19 | US | Virginia | Fairfax | 51059 | 8020 | 292 | 0 | 7728 | 38.83677558 | -77.27565836 | 2020-05-20 02:32:19 | Fairfax, Virginia, 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]);