johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
9 rows where active = 9789 and country_or_region = "US" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 7
- California 2
- South Carolina 2
- Alabama 1
- Connecticut 1
- Hawaii 1
- Minnesota 1
- Montana 1
country_or_region 1
- US · 9 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1858377 | 1858377 | 2021-02-25 | US | Alabama | Houston | 1069 | 10048 | 259 | 0 | 9789 | 31.15197924 | -85.29939599 | 2021-02-26 05:22:40 | Houston, Alabama, US |
2428891 | 2428891 | 2021-01-23 | US | Montana | Flathead | 30029 | 9849 | 60 | 0 | 9789 | 48.29575866 | -114.0520569 | 2021-01-24 05:22:35 | Flathead, Montana, US |
2543145 | 2543145 | 2021-01-07 | US | Minnesota | Olmsted | 27109 | 9854 | 65 | 0 | 9789 | 44.00374114 | -92.40209944 | 2021-01-08 05:22:42 | Olmsted, Minnesota, US |
3780712 | 3780712 | 2020-12-27 | US | South Carolina | Florence | 45041 | 10038 | 249 | 0 | 9789 | 34.02361754 | -79.70189312 | 2020-12-28 05:22:06 | Florence, South Carolina, US |
2540229 | 2540229 | 2020-12-01 | US | South Carolina | York | 45091 | 9926 | 137 | 0 | 9789 | 34.97281497 | -81.18085944 | 2020-12-02 05:27:41 | York, South Carolina, US |
1729034 | 1729034 | 2020-11-08 | US | California | Merced | 6047 | 9945 | 157 | 0 | 9789 | 37.18922369 | -120.7209035 | 2020-11-09 05:25:45 | Merced, California, US |
967445 | 967445 | 2020-09-29 | US | California | Monterey | 6053 | 9861 | 70 | 0 | 9789 | 36.21862405 | -121.2413397 | 2020-09-30 04:23:33 | Monterey, California, US |
667172 | 667172 | 2020-09-16 | US | Hawaii | Honolulu | 15003 | 9879 | 90 | 0 | 9789 | 21.45803166 | -157.9712182 | 2020-09-17 04:22:00 | Honolulu, Hawaii, US |
267144 | 267144 | 2020-05-21 | US | Connecticut | New Haven | 9009 | 10663 | 874 | 0 | 9789 | 41.4080325 | -72.93620426 | 2020-05-22 02:36:51 | New Haven, Connecticut, 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]);