johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
35 rows where active = 3884 and country_or_region = "US" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 1
- US · 35 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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]);