⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

380 rows where country_or_region = "Sweden" and province_or_state = "Kronoberg" sorted by day descending

View and edit SQL

Suggested facets: day (date), last_update (date)

province_or_state

  • Kronoberg · 380

country_or_region

  • Sweden · 380
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
168778 2021-06-19 Sweden Kronoberg     22177 318 0 21859 56.7183 14.4115 2021-06-20 04:21:48 Kronoberg, Sweden
686303 2021-06-18 Sweden Kronoberg     22177 318 0 21859 56.7183 14.4115 2021-06-19 04:22:33 Kronoberg, Sweden
958360 2021-06-17 Sweden Kronoberg     22177 318 0 21859 56.7183 14.4115 2021-06-18 04:22:16 Kronoberg, Sweden
1281725 2021-06-16 Sweden Kronoberg     22177 318 0 21859 56.7183 14.4115 2021-06-17 04:22:36 Kronoberg, Sweden
682315 2021-06-15 Sweden Kronoberg     22177 318 0 21859 56.7183 14.4115 2021-06-16 04:22:32 Kronoberg, Sweden
372869 2021-06-14 Sweden Kronoberg     22123 318 0 21805 56.7183 14.4115 2021-06-15 04:22:22 Kronoberg, Sweden
1223685 2021-06-13 Sweden Kronoberg     22123 318 0 21805 56.7183 14.4115 2021-06-14 04:22:46 Kronoberg, Sweden
80966 2021-06-12 Sweden Kronoberg     22123 318 0 21805 56.7183 14.4115 2021-06-13 04:22:44 Kronoberg, Sweden
970269 2021-06-11 Sweden Kronoberg     22123 318 0 21805 56.7183 14.4115 2021-06-12 04:22:22 Kronoberg, Sweden
1438842 2021-06-10 Sweden Kronoberg     22080 318 0 21762 56.7183 14.4115 2021-06-11 04:23:20 Kronoberg, Sweden
1157341 2021-06-09 Sweden Kronoberg     22050 318 0 21732 56.7183 14.4115 2021-06-10 04:23:17 Kronoberg, Sweden
1231657 2021-06-08 Sweden Kronoberg     22017 317 0 21700 56.7183 14.4115 2021-06-09 04:23:31 Kronoberg, Sweden
360653 2021-06-07 Sweden Kronoberg     21938 316 0 21622 56.7183 14.4115 2021-06-08 04:22:35 Kronoberg, Sweden
1076281 2021-06-06 Sweden Kronoberg     21938 316 0 21622 56.7183 14.4115 2021-06-07 04:22:51 Kronoberg, Sweden
1613673 2021-06-05 Sweden Kronoberg     21938 316 0 21622 56.7183 14.4115 2021-06-06 04:24:03 Kronoberg, Sweden
1125959 2021-06-04 Sweden Kronoberg     21938 316 0 21622 56.7183 14.4115 2021-06-05 04:23:03 Kronoberg, Sweden
318415 2021-06-03 Sweden Kronoberg     21908 315 0 21593 56.7183 14.4115 2021-06-04 04:23:37 Kronoberg, Sweden
1133928 2021-06-02 Sweden Kronoberg     21641 313 0 21328 56.7183 14.4115 2021-06-03 04:23:32 Kronoberg, Sweden
292105 2021-06-01 Sweden Kronoberg     21641 313 0 21328 56.7183 14.4115 2021-06-02 04:24:34 Kronoberg, Sweden
1652056 2021-05-31 Sweden Kronoberg     21641 313 0 21328 56.7183 14.4115 2021-06-01 04:23:09 Kronoberg, Sweden
981284 2021-05-30 Sweden Kronoberg     21641 313 0 21328 56.7183 14.4115 2021-05-31 03:08:59 Kronoberg, Sweden
841665 2021-05-29 Sweden Kronoberg     21641 313 0 21328 56.7183 14.4115 2021-05-30 04:20:55 Kronoberg, Sweden
698237 2021-05-28 Sweden Kronoberg     21641 313 0 21328 56.7183 14.4115 2021-05-29 04:20:41 Kronoberg, Sweden
1369738 2021-05-27 Sweden Kronoberg     21641 313 0 21328 56.7183 14.4115 2021-05-28 04:20:36 Kronoberg, Sweden
1292822 2021-05-26 Sweden Kronoberg     21639 313 0 21326 56.7183 14.4115 2021-05-27 04:20:59 Kronoberg, Sweden
603193 2021-05-25 Sweden Kronoberg     21552 313 0 21239 56.7183 14.4115 2021-05-26 04:20:35 Kronoberg, Sweden
1365751 2021-05-24 Sweden Kronoberg     21427 312 0 21115 56.7183 14.4115 2021-05-25 04:21:08 Kronoberg, Sweden
420264 2021-05-23 Sweden Kronoberg     21427 312 0 21115 56.7183 14.4115 2021-05-24 04:20:53 Kronoberg, Sweden
54603 2021-05-22 Sweden Kronoberg     21427 312 0 21115 56.7183 14.4115 2021-05-23 04:20:51 Kronoberg, Sweden
368882 2021-05-21 Sweden Kronoberg     21427 312 0 21115 56.7183 14.4115 2021-05-22 04:20:45 Kronoberg, Sweden
1024681 2021-05-20 Sweden Kronoberg     21349 312 0 21037 56.7183 14.4115 2021-05-21 04:20:43 Kronoberg, Sweden
1679307 2021-05-19 Sweden Kronoberg     21261 312 0 20949 56.7183 14.4115 2021-05-20 04:21:05 Kronoberg, Sweden
65294 2021-05-18 Sweden Kronoberg     21117 312 0 20805 56.7183 14.4115 2021-05-19 04:20:42 Kronoberg, Sweden
1243366 2021-05-17 Sweden Kronoberg     20919 311 0 20608 56.7183 14.4115 2021-05-18 04:20:33 Kronoberg, Sweden
1068214 2021-05-16 Sweden Kronoberg     20919 311 0 20608 56.7183 14.4115 2021-05-17 04:20:34 Kronoberg, Sweden
505342 2021-05-15 Sweden Kronoberg     20919 311 0 20608 56.7183 14.4115 2021-05-16 04:20:49 Kronoberg, Sweden
892947 2021-05-14 Sweden Kronoberg     20919 311 0 20608 56.7183 14.4115 2021-05-15 04:20:58 Kronoberg, Sweden
532282 2021-05-13 Sweden Kronoberg     20586 311 0 20275 56.7183 14.4115 2021-05-14 04:20:41 Kronoberg, Sweden
1719569 2021-05-12 Sweden Kronoberg     20586 311 0 20275 56.7183 14.4115 2021-05-13 04:20:51 Kronoberg, Sweden
1723555 2021-05-11 Sweden Kronoberg     20297 310 0 19987 56.7183 14.4115 2021-05-12 04:21:29 Kronoberg, Sweden
1165312 2021-05-10 Sweden Kronoberg     19915 308 0 19607 56.7183 14.4115 2021-05-11 04:20:41 Kronoberg, Sweden
1169298 2021-05-09 Sweden Kronoberg     19915 308 0 19607 56.7183 14.4115 2021-05-10 04:20:38 Kronoberg, Sweden
1660085 2021-05-08 Sweden Kronoberg     19915 308 0 19607 56.7183 14.4115 2021-05-09 04:20:35 Kronoberg, Sweden
800183 2021-05-07 Sweden Kronoberg     19915 308 0 19607 56.7183 14.4115 2021-05-08 04:21:04 Kronoberg, Sweden
1219698 2021-05-06 Sweden Kronoberg     19716 307 0 19409 56.7183 14.4115 2021-05-07 04:20:40 Kronoberg, Sweden
416278 2021-05-05 Sweden Kronoberg     19500 307 0 19193 56.7183 14.4115 2021-05-06 04:20:38 Kronoberg, Sweden
674299 2021-05-04 Sweden Kronoberg     19211 307 0 18904 56.7183 14.4115 2021-05-05 04:20:43 Kronoberg, Sweden
1088323 2021-05-03 Sweden Kronoberg     18839 303 0 18536 56.7183 14.4115 2021-05-04 04:20:34 Kronoberg, Sweden
1727541 2021-05-02 Sweden Kronoberg     18839 303 0 18536 56.7183 14.4115 2021-05-03 04:20:39 Kronoberg, Sweden
1084337 2021-05-01 Sweden Kronoberg     18839 303 0 18536 56.7183 14.4115 2021-05-02 04:20:48 Kronoberg, Sweden
1388865 2021-04-30 Sweden Kronoberg     18839 303 0 18536 56.7183 14.4115 2021-05-01 04:20:47 Kronoberg, Sweden
38684 2021-04-29 Sweden Kronoberg     18655 302 0 18353 56.7183 14.4115 2021-04-30 04:21:03 Kronoberg, Sweden
12257 2021-04-28 Sweden Kronoberg     18428 302 0 18126 56.7183 14.4115 2021-04-29 04:20:55 Kronoberg, Sweden
853640 2021-04-27 Sweden Kronoberg     18168 302 0 17866 56.7183 14.4115 2021-04-28 04:20:32 Kronoberg, Sweden
1064228 2021-04-26 Sweden Kronoberg     17811 302 0 17509 56.7183 14.4115 2021-04-27 04:20:52 Kronoberg, Sweden
1476478 2021-04-25 Sweden Kronoberg     17811 302 0 17509 56.7183 14.4115 2021-04-26 04:21:04 Kronoberg, Sweden
744099 2021-04-24 Sweden Kronoberg     17811 302 0 17509 56.7183 14.4115 2021-04-25 04:20:32 Kronoberg, Sweden
1430898 2021-04-23 Sweden Kronoberg     17811 302 0 17509 56.7183 14.4115 2021-04-24 04:20:38 Kronoberg, Sweden
96727 2021-04-22 Sweden Kronoberg     17628 302 0 17326 56.7183 14.4115 2021-04-23 04:20:52 Kronoberg, Sweden
849654 2021-04-21 Sweden Kronoberg     17392 301 0 17091 56.7183 14.4115 2021-04-22 04:20:53 Kronoberg, Sweden
827272 2021-04-20 Sweden Kronoberg     17189 301 0 16888 56.7183 14.4115 2021-04-21 04:21:14 Kronoberg, Sweden
770983 2021-04-19 Sweden Kronoberg     16875 299 0 16576 56.7183 14.4115 2021-04-20 04:20:41 Kronoberg, Sweden
1416292 2021-04-18 Sweden Kronoberg     16875 299 0 16576 56.7183 14.4115 2021-04-19 04:20:57 Kronoberg, Sweden
985269 2021-04-17 Sweden Kronoberg     16875 299 0 16576 56.7183 14.4115 2021-04-18 04:20:41 Kronoberg, Sweden
238332 2021-04-16 Sweden Kronoberg     16875 299 0 16576 56.7183 14.4115 2021-04-17 04:20:40 Kronoberg, Sweden
580061 2021-04-15 Sweden Kronoberg     16720 299 0 16421 56.7183 14.4115 2021-04-16 04:20:46 Kronoberg, Sweden
1266689 2021-04-14 Sweden Kronoberg     16535 299 0 16236 56.7183 14.4115 2021-04-15 04:20:54 Kronoberg, Sweden
702222 2021-04-13 Sweden Kronoberg     16370 299 0 16071 56.7183 14.4115 2021-04-14 04:20:41 Kronoberg, Sweden
1671335 2021-04-12 Sweden Kronoberg     16056 297 0 15759 56.7183 14.4115 2021-04-13 04:20:37 Kronoberg, Sweden
785040 2021-04-11 Sweden Kronoberg     16056 297 0 15759 56.7183 14.4115 2021-04-12 04:21:00 Kronoberg, Sweden
1392851 2021-04-10 Sweden Kronoberg     16056 297 0 15759 56.7183 14.4115 2021-04-11 04:20:56 Kronoberg, Sweden
966282 2021-04-09 Sweden Kronoberg     16056 297 0 15759 56.7183 14.4115 2021-04-10 04:20:59 Kronoberg, Sweden
690286 2021-04-08 Sweden Kronoberg     15892 297 0 15595 56.7183 14.4115 2021-04-09 04:21:13 Kronoberg, Sweden
1277738 2021-04-07 Sweden Kronoberg     15714 297 0 15417 56.7183 14.4115 2021-04-08 04:21:13 Kronoberg, Sweden
88757 2021-04-06 Sweden Kronoberg     15659 297 0 15362 56.7183 14.4115 2021-04-07 04:20:53 Kronoberg, Sweden
123139 2021-04-05 Sweden Kronoberg     15435 297 0 15138 56.7183 14.4115 2021-04-06 04:20:32 Kronoberg, Sweden
73641 2021-04-04 Sweden Kronoberg     15435 297 0 15138 56.7183 14.4115 2021-04-05 04:20:35 Kronoberg, Sweden
792257 2021-04-03 Sweden Kronoberg     15435 297 0 15138 56.7183 14.4115 2021-04-04 04:20:49 Kronoberg, Sweden
1020695 2021-04-02 Sweden Kronoberg     15435 297 0 15138 56.7183 14.4115 2021-04-03 04:20:44 Kronoberg, Sweden
1350857 2021-04-01 Sweden Kronoberg     15435 297 0 15138 56.7183 14.4115 2021-04-02 04:20:36 Kronoberg, Sweden
1691243 2021-03-31 Sweden Kronoberg     15331 297 0 15034 56.7183 14.4115 2021-04-01 04:27:05 Kronoberg, Sweden
873612 2021-03-30 Sweden Kronoberg     15208 297 0 14911 56.7183 14.4115 2021-03-31 04:26:25 Kronoberg, Sweden
1400659 2021-03-29 Sweden Kronoberg     15075 297 0 14778 56.7183 14.4115 2021-03-30 04:26:23 Kronoberg, Sweden
1625062 2021-03-28 Sweden Kronoberg     15075 297 0 14778 56.7183 14.4115 2021-03-29 04:28:35 Kronoberg, Sweden
1472492 2021-03-27 Sweden Kronoberg     15075 297 0 14778 56.7183 14.4115 2021-03-28 05:28:10 Kronoberg, Sweden
721039 2021-03-26 Sweden Kronoberg     15075 297 0 14778 56.7183 14.4115 2021-03-27 05:25:04 Kronoberg, Sweden
1617658 2021-03-25 Sweden Kronoberg     15034 297 0 14737 56.7183 14.4115 2021-03-26 05:26:55 Kronoberg, Sweden
470319 2021-03-24 Sweden Kronoberg     14962 296 0 14666 56.7183 14.4115 2021-03-25 05:27:00 Kronoberg, Sweden
1585359 2021-03-23 Sweden Kronoberg     14892 296 0 14596 56.7183 14.4115 2021-03-24 05:25:40 Kronoberg, Sweden
717053 2021-03-22 Sweden Kronoberg     14762 296 0 14466 56.7183 14.4115 2021-03-23 05:26:18 Kronoberg, Sweden
1675321 2021-03-21 Sweden Kronoberg     14762 296 0 14466 56.7183 14.4115 2021-03-22 05:25:43 Kronoberg, Sweden
1747260 2021-03-20 Sweden Kronoberg     14762 296 0 14466 56.7183 14.4115 2021-03-21 05:25:44 Kronoberg, Sweden
230382 2021-03-19 Sweden Kronoberg     14762 296 0 14466 56.7183 14.4115 2021-03-20 05:25:46 Kronoberg, Sweden
478317 2021-03-18 Sweden Kronoberg     14707 296 0 14411 56.7183 14.4115 2021-03-19 05:26:09 Kronoberg, Sweden
1426912 2021-03-17 Sweden Kronoberg     14625 296 0 14329 56.7183 14.4115 2021-03-18 05:26:22 Kronoberg, Sweden
1593500 2021-03-16 Sweden Kronoberg     14557 296 0 14261 56.7183 14.4115 2021-03-17 05:25:07 Kronoberg, Sweden
1176499 2021-03-15 Sweden Kronoberg     14473 296 0 14177 56.7183 14.4115 2021-03-16 05:25:13 Kronoberg, Sweden
276184 2021-03-14 Sweden Kronoberg     14473 296 0 14177 56.7183 14.4115 2021-03-15 05:25:51 Kronoberg, Sweden
1161326 2021-03-13 Sweden Kronoberg     14473 296 0 14177 56.7183 14.4115 2021-03-14 05:25:37 Kronoberg, Sweden
22833 2021-03-12 Sweden Kronoberg     14473 296 0 14177 56.7183 14.4115 2021-03-13 05:25:15 Kronoberg, Sweden

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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] INTEGER,
   [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]);