johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
938 rows where country_or_region = "Sweden" and province_or_state = "Skane" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2974619 | 2974619 | 2020-06-30 | Sweden | Skane | 3051 | 245 | 0 | 2806 | 55.9903 | 13.5958 | 2020-07-01 04:33:52 | Skane, Sweden | ||
2633096 | 2633096 | 2020-06-29 | Sweden | Skane | 3020 | 244 | 0 | 2776 | 55.9903 | 13.5958 | 2020-06-30 04:33:48 | Skane, Sweden | ||
2306659 | 2306659 | 2020-06-28 | Sweden | Skane | 2952 | 236 | 0 | 2716 | 55.9903 | 13.5958 | 2020-06-29 04:33:44 | Skane, Sweden | ||
2039994 | 2039994 | 2020-06-27 | Sweden | Skane | 2952 | 236 | 0 | 2716 | 55.9903 | 13.5958 | 2020-06-28 04:34:04 | Skane, Sweden | ||
1136275 | 1136275 | 2020-06-26 | Sweden | Skane | 2952 | 236 | 0 | 2716 | 55.9903 | 13.5958 | 2020-06-27 04:33:35 | Skane, Sweden | ||
2625262 | 2625262 | 2020-06-25 | Sweden | Skane | 2897 | 236 | 0 | 2661 | 55.9903 | 13.5958 | 2020-06-26 04:33:43 | Skane, Sweden | ||
2700902 | 2700902 | 2020-06-24 | Sweden | Skane | 2809 | 235 | 0 | 2574 | 55.9903 | 13.5958 | 2020-06-25 05:26:54 | Skane, Sweden | ||
1522587 | 1522587 | 2020-06-23 | Sweden | Skane | 2742 | 225 | 0 | 2517 | 55.9903 | 13.5958 | 2020-06-24 04:33:28 | Skane, Sweden | ||
1510781 | 1510781 | 2020-06-22 | Sweden | Skane | 2707 | 224 | 0 | 2483 | 55.9903 | 13.5958 | 2020-06-23 04:33:22 | Skane, Sweden | ||
3249520 | 3249520 | 2020-06-21 | Sweden | Skane | 2532 | 224 | 0 | 2308 | 55.9903 | 13.5958 | 2020-06-22 04:33:20 | Skane, Sweden | ||
2438113 | 2438113 | 2020-06-20 | Sweden | Skane | 2532 | 224 | 0 | 2308 | 55.9903 | 13.5958 | 2020-06-21 04:33:19 | Skane, Sweden | ||
1691691 | 1691691 | 2020-06-19 | Sweden | Skane | 2532 | 224 | 0 | 2308 | 55.9903 | 13.5958 | 2020-06-20 04:33:19 | Skane, Sweden | ||
3682840 | 3682840 | 2020-06-18 | Sweden | Skane | 2532 | 224 | 0 | 2308 | 55.9903 | 13.5958 | 2020-06-19 04:33:17 | Skane, Sweden | ||
1196043 | 1196043 | 2020-06-17 | Sweden | Skane | 2437 | 224 | 0 | 2213 | 55.9903 | 13.5958 | 2020-06-18 04:33:18 | Skane, Sweden | ||
2386806 | 2386806 | 2020-06-16 | Sweden | Skane | 2336 | 223 | 0 | 2113 | 55.9903 | 13.5958 | 2020-06-17 04:33:21 | Skane, Sweden | ||
287369 | 287369 | 2020-06-15 | Sweden | Skane | 2300 | 218 | 0 | 2082 | 55.9903 | 13.5958 | 2020-06-16 04:33:09 | Skane, Sweden | ||
1837320 | 1837320 | 2020-06-14 | Sweden | Skane | 2270 | 218 | 0 | 2052 | 55.9903 | 13.5958 | 2020-06-15 03:33:14 | Skane, Sweden | ||
3061372 | 3061372 | 2020-06-13 | Sweden | Skane | 2254 | 218 | 0 | 2036 | 55.9903 | 13.5958 | 2020-06-14 03:33:15 | Skane, Sweden | ||
737692 | 737692 | 2020-06-12 | Sweden | Skane | 2198 | 205 | 0 | 1993 | 55.9903 | 13.5958 | 2020-06-13 03:33:14 | Skane, Sweden | ||
1273662 | 1273662 | 2020-06-11 | Sweden | Skane | 2144 | 205 | 0 | 1939 | 55.9903 | 13.5958 | 2020-06-12 05:09:52 | Skane, Sweden | ||
2864103 | 2864103 | 2020-06-10 | Sweden | Skane | 2088 | 205 | 0 | 1883 | 55.9903 | 13.5958 | 2020-06-11 03:33:41 | Skane, Sweden | ||
1210927 | 1210927 | 2020-06-09 | Sweden | Skane | 2028 | 202 | 0 | 1826 | 55.9903 | 13.5958 | 2020-06-10 04:07:00 | Skane, Sweden | ||
217354 | 217354 | 2020-06-08 | Sweden | Skane | 1995 | 200 | 0 | 1795 | 55.9903 | 13.5958 | 2020-06-09 03:33:03 | Skane, Sweden | ||
2800150 | 2800150 | 2020-06-07 | Sweden | Skane | 1985 | 200 | 0 | 1785 | 55.9903 | 13.5958 | 2020-06-08 03:33:22 | Skane, Sweden | ||
574206 | 574206 | 2020-06-06 | Sweden | Skane | 1957 | 200 | 0 | 1757 | 55.9903 | 13.5958 | 2020-06-07 03:53:30 | Skane, Sweden | ||
1269903 | 1269903 | 2020-06-05 | Sweden | Skane | 1928 | 192 | 0 | 1736 | 55.9903 | 13.5958 | 2020-06-06 02:33:00 | Skane, Sweden |
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]);