johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
46 rows where active = 3884 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2259372 | 2259372 | 2021-05-19 | Ukraine | Volyn Oblast | 60073 | 1106 | 55083 | 3884 | 50.7472 | 25.3254 | 2021-05-20 04:21:05 | Volyn Oblast, Ukraine | ||
1290241 | 1290241 | 2021-03-29 | Russia | Perm Krai | 51013 | 1941 | 45188 | 3884 | 58.5951603 | 56.3159546 | 2021-03-30 04:26:23 | Perm Krai, Russia | ||
2210132 | 2210132 | 2021-03-04 | US | Ohio | Madison | 39097 | 3942 | 58 | 0 | 3884 | 39.89381073 | -83.40178317 | 2021-03-05 05:26:29 | Madison, Ohio, US |
1001026 | 1001026 | 2021-03-01 | US | Oklahoma | Sequoyah | 40135 | 3915 | 31 | 0 | 3884 | 35.49447108 | -94.75463785 | 2021-03-02 05:23:30 | Sequoyah, Oklahoma, US |
2370084 | 2370084 | 2021-02-28 | US | Oklahoma | Sequoyah | 40135 | 3914 | 30 | 0 | 3884 | 35.49447108 | -94.75463785 | 2021-03-01 05:23:01 | Sequoyah, Oklahoma, US |
2368080 | 2368080 | 2021-02-28 | US | California | Tuolumne | 6109 | 3941 | 53 | 0 | 3884 | 38.02644018 | -119.9525093 | 2021-03-01 05:23:01 | Tuolumne, California, US |
3068586 | 3068586 | 2021-02-27 | US | Oklahoma | Sequoyah | 40135 | 3912 | 28 | 0 | 3884 | 35.49447108 | -94.75463785 | 2021-02-28 05:22:20 | Sequoyah, Oklahoma, US |
1859071 | 1859071 | 2021-02-25 | US | Indiana | Clinton | 18023 | 3937 | 53 | 0 | 3884 | 40.30319754 | -86.47277257 | 2021-02-26 05:22:40 | Clinton, Indiana, US |
533743 | 533743 | 2021-02-22 | US | Texas | Cherokee | 48073 | 3167 | 119 | 0 | 3884 | 31.837258 | -95.16559897 | 2021-02-23 05:23:41 | Cherokee, Texas, US |
185655 | 185655 | 2021-02-21 | Ukraine | Chernihiv Oblast | 35307 | 722 | 30701 | 3884 | 51.4982 | 31.2893 | 2021-02-22 05:24:21 | Chernihiv Oblast, Ukraine | ||
185077 | 185077 | 2021-02-21 | US | Texas | Cherokee | 48073 | 3167 | 119 | 0 | 3884 | 31.837258 | -95.16559897 | 2021-02-22 05:24:21 | Cherokee, Texas, US |
183399 | 183399 | 2021-02-21 | US | Kentucky | Barren | 21009 | 3955 | 71 | 0 | 3884 | 36.96469836 | -85.93338945 | 2021-02-22 05:24:21 | Barren, Kentucky, US |
745351 | 745351 | 2021-02-20 | US | Texas | Cherokee | 48073 | 3167 | 119 | 0 | 3884 | 31.837258 | -95.16559897 | 2021-02-21 05:24:33 | Cherokee, Texas, US |
474449 | 474449 | 2021-02-19 | US | Texas | Cherokee | 48073 | 3167 | 119 | 0 | 3884 | 31.837258 | -95.16559897 | 2021-02-20 05:22:51 | Cherokee, Texas, US |
1154949 | 1154949 | 2021-02-18 | US | Mississippi | Pearl River | 28109 | 4010 | 126 | 0 | 3884 | 30.77090935 | -89.58677275 | 2021-02-19 05:24:16 | Pearl River, Mississippi, US |
3604656 | 3604656 | 2021-02-17 | Ukraine | Chernihiv Oblast | 34855 | 711 | 30260 | 3884 | 51.4982 | 31.2893 | 2021-02-18 05:22:58 | Chernihiv Oblast, Ukraine | ||
3540499 | 3540499 | 2021-02-12 | US | Illinois | Stephenson | 17177 | 3953 | 69 | 0 | 3884 | 42.35129217 | -89.662598 | 2021-02-13 05:22:12 | Stephenson, Illinois, US |
2482388 | 2482388 | 2021-01-28 | US | Alaska | Kenai Peninsula | 2122 | 3905 | 21 | 0 | 3884 | 60.24429722 | -151.53888840000005 | 2021-01-29 05:22:23 | Kenai Peninsula, Alaska, US |
2542496 | 2542496 | 2021-01-07 | US | Indiana | Jackson | 18071 | 3940 | 56 | 0 | 3884 | 38.90915820000001 | -86.03851889 | 2021-01-08 05:22:42 | Jackson, Indiana, US |
2868267 | 2868267 | 2021-01-06 | US | Wisconsin | Marinette | 55075 | 3934 | 50 | 0 | 3884 | 45.38553432 | -88.03324599999998 | 2021-01-07 05:22:03 | Marinette, Wisconsin, US |
2864829 | 2864829 | 2021-01-06 | Namibia | 26319 | 235 | 22200 | 3884 | -22.9576 | 18.4904 | 2021-01-07 05:22:03 | Namibia | |||
2225935 | 2225935 | 2020-12-26 | US | North Dakota | Williams | 38105 | 3890 | 29 | 0 | 3884 | 48.34522353 | -103.4793387 | 2020-12-27 05:22:55 | Williams, North Dakota, US |
3770067 | 3770067 | 2020-12-22 | Russia | Chechen Republic | 7441 | 88 | 3469 | 3884 | 43.39761470000001 | 45.6985005 | 2020-12-23 05:22:03 | Chechen Republic, Russia | ||
2931690 | 2931690 | 2020-12-19 | US | Arkansas | Crittenden | 5035 | 3950 | 66 | 0 | 3884 | 35.21247318 | -90.30839406 | 2020-12-20 05:27:32 | Crittenden, Arkansas, US |
1753264 | 1753264 | 2020-12-14 | US | Montana | Lewis and Clark | 30049 | 3911 | 27 | 0 | 3884 | 47.12610041 | -112.394698 | 2020-12-15 05:26:38 | Lewis and Clark, Montana, US |
3849784 | 3849784 | 2020-12-13 | US | Montana | Lewis and Clark | 30049 | 3911 | 27 | 0 | 3884 | 47.12610041 | -112.394698 | 2020-12-14 05:26:27 | Lewis and Clark, Montana, US |
1006692 | 1006692 | 2020-12-06 | US | Alabama | Talladega | 1121 | 3944 | 60 | 0 | 3884 | 33.37823223 | -86.16886178 | 2020-12-07 05:26:14 | Talladega, Alabama, US |
3566894 | 3566894 | 2020-11-29 | Syria | 7797 | 413 | 3500 | 3884 | 34.802075 | 38.99681500000001 | 2020-11-30 05:26:13 | Syria | |||
3171972 | 3171972 | 2020-11-16 | US | North Carolina | Nash | 37127 | 3972 | 88 | 0 | 3884 | 35.96575634 | -77.98422508 | 2020-11-17 05:25:54 | Nash, North Carolina, US |
2915371 | 2915371 | 2020-11-14 | Russia | Bryansk Oblast | 15071 | 99 | 11088 | 3884 | 52.8873315 | 33.41585300000001 | 2020-11-15 05:26:53 | Bryansk Oblast, Russia | ||
866273 | 866273 | 2020-11-12 | US | Louisiana | Lafourche | 22057 | 4015 | 131 | 0 | 3884 | 29.52470226 | -90.40976986 | 2020-11-13 05:25:30 | Lafourche, Louisiana, US |
1546151 | 1546151 | 2020-11-07 | US | New York | Albany | 36001 | 4024 | 140 | 0 | 3884 | 42.60060306 | -73.97723916 | 2020-11-08 05:24:56 | Albany, New York, US |
3483543 | 3483543 | 2020-10-26 | US | Texas | Walker | 48471 | 4899 | 62 | 0 | 3884 | 30.73872995 | -95.57440968 | 2020-10-27 04:24:45 | Walker, Texas, US |
11564 | 11564 | 2020-10-25 | US | Texas | Walker | 48471 | 4891 | 62 | 0 | 3884 | 30.73872995 | -95.57440968 | 2020-10-26 04:25:02 | Walker, Texas, US |
2690355 | 2690355 | 2020-10-08 | US | Florida | Columbia | 12023 | 3946 | 62 | 0 | 3884 | 30.22509788 | -82.62160164 | 2020-10-09 04:23:59 | Columbia, Florida, US |
1823297 | 1823297 | 2020-10-04 | US | Arkansas | Sebastian | 5131 | 3946 | 62 | 0 | 3884 | 35.19605503 | -94.27162713 | 2020-10-05 04:23:33 | Sebastian, Arkansas, US |
2059858 | 2059858 | 2020-09-01 | Ireland | 29025 | 1777 | 23364 | 3884 | 53.1424 | -7.6921 | 2020-09-02 04:28:25 | Ireland | |||
3933026 | 3933026 | 2020-08-30 | US | Illinois | Madison | 17119 | 3982 | 98 | 0 | 3884 | 38.83042506 | -89.90422563 | 2020-08-31 04:28:27 | Madison, Illinois, US |
3932697 | 3932697 | 2020-08-30 | US | Florida | Clay | 12019 | 3960 | 76 | 0 | 3884 | 29.98319144 | -81.85609986 | 2020-08-31 04:28:27 | Clay, Florida, US |
3932295 | 3932295 | 2020-08-30 | Senegal | 13556 | 284 | 9388 | 3884 | 14.4974 | -14.4524 | 2020-08-31 04:28:27 | Senegal | |||
1525469 | 1525469 | 2020-08-28 | US | North Carolina | Cumberland | 37051 | 3949 | 65 | 0 | 3884 | 35.04762133 | -78.82623165 | 2020-08-29 04:28:19 | Cumberland, North Carolina, US |
2216374 | 2216374 | 2020-08-23 | US | Florida | Okaloosa | 12091 | 3955 | 71 | 0 | 3884 | 30.69143028 | -86.59267105 | 2020-08-24 04:27:56 | Okaloosa, Florida, US |
3792851 | 3792851 | 2020-08-05 | Spain | Andalusia | 15992 | 1437 | 10671 | 3884 | 37.5443 | -4.7278 | 2020-08-06 04:35:02 | Andalusia, Spain | ||
94988 | 94988 | 2020-08-04 | US | Florida | Bay | 12005 | 3921 | 37 | 0 | 3884 | 30.26548745 | -85.62122584 | 2020-08-05 04:34:43 | Bay, Florida, US |
58978 | 58978 | 2020-07-23 | US | Georgia | Chatham | 13051 | 3928 | 44 | 0 | 3884 | 32.00043026 | -81.12489526 | 2020-07-24 05:30:40 | Chatham, Georgia, US |
3736719 | 3736719 | 2020-07-12 | US | California | San Mateo | 6081 | 3995 | 108 | 0 | 3884 | 37.422880799999994 | -122.32755459999998 | 2020-07-13 04:43:04 | San Mateo, California, 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]);