johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,039 rows where country_or_region = "Switzerland" sorted by admin2
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, recovered, active, day (date), last_update (date)
country_or_region 1
- Switzerland · 1,039 ✖
province_or_state 0
Link | rowid | day | country_or_region | province_or_state | admin2 ▼ | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
662 | 662 | 2021-12-02 | Switzerland | 1034675 | 11566 | 0 | 46.8182 | 8.2275 | 2021-12-03 04:23:05 | Switzerland | ||||
4678 | 4678 | 2021-10-28 | Switzerland | 870837 | 11219 | 0 | 46.8182 | 8.2275 | 2021-10-29 04:22:03 | Switzerland | ||||
8656 | 8656 | 2020-10-25 | Switzerland | 103653 | 2121 | 55800 | 45732 | 46.8182 | 8.2275 | 2020-10-26 04:25:02 | Switzerland | |||
12667 | 12667 | 2021-01-26 | Switzerland | 515483 | 9355 | 317600 | 188528 | 46.8182 | 8.2275 | 2021-01-27 05:23:41 | Switzerland | |||
16686 | 16686 | 2021-09-18 | Switzerland | 823078 | 10999 | 0 | 46.8182 | 8.2275 | 2021-09-19 04:21:34 | Switzerland | ||||
20698 | 20698 | 2021-05-28 | Switzerland | 693023 | 10705 | 317600 | 364718 | 46.8182 | 8.2275 | 2021-05-29 04:20:41 | Switzerland | |||
24733 | 24733 | 2022-03-20 | Switzerland | 3268953 | 13423 | 0 | 46.8182 | 8.2275 | 2022-03-21 04:20:50 | Switzerland | ||||
28748 | 28748 | 2021-11-11 | Switzerland | 905112 | 11309 | 0 | 46.8182 | 8.2275 | 2021-11-12 04:22:01 | Switzerland | ||||
32747 | 32747 | 2021-08-25 | Switzerland | 765190 | 10857 | 0 | 46.8182 | 8.2275 | 2021-08-26 04:21:28 | Switzerland | ||||
36757 | 36757 | 2021-04-12 | Switzerland | 623126 | 10406 | 317600 | 295120 | 46.8182 | 8.2275 | 2021-04-13 04:20:37 | Switzerland | |||
40165 | 40165 | 2020-03-05 | Switzerland | 114 | 0 | 3 | 46.8182 | 8.2275 | 2020-03-05T17:43:03 | |||||
43320 | 43320 | 2020-04-13 | Switzerland | 25688 | 1173 | 13700 | 10815 | 46.8182 | 8.2275 | 2020-04-13 23:07:34 | Switzerland | |||
44040 | 44040 | 2021-11-02 | Switzerland | 879051 | 11259 | 0 | 46.8182 | 8.2275 | 2021-11-03 06:22:09 | Switzerland | ||||
50419 | 50419 | 2020-04-17 | Switzerland | 27078 | 1330 | 16400 | 9348 | 46.8182 | 8.2275 | 2020-04-17 23:30:32 | Switzerland | |||
51119 | 51119 | 2021-05-29 | Switzerland | 693023 | 10710 | 317600 | 364713 | 46.8182 | 8.2275 | 2021-05-30 04:20:55 | Switzerland | |||
55132 | 55132 | 2021-03-07 | Switzerland | 562290 | 10074 | 317600 | 234616 | 46.8182 | 8.2275 | 2021-03-08 05:24:48 | Switzerland | |||
62376 | 62376 | 2020-07-23 | Switzerland | 34000 | 1821 | 30500 | 1679 | 46.8182 | 8.2275 | 2020-07-24 05:30:40 | Switzerland | |||
62495 | 62495 | 2020-03-07 | Switzerland | 268 | 1 | 3 | 46.8182 | 8.2275 | 2020-03-07T17:43:05 | |||||
63397 | 63397 | 2022-11-12 | Switzerland | 4276848 | 14097 | 0 | 46.8182 | 8.2275 | 2022-11-13 04:21:14 | Switzerland | ||||
67392 | 67392 | 2021-09-01 | Switzerland | 782869 | 10907 | 0 | 46.8182 | 8.2275 | 2021-09-02 04:21:15 | Switzerland | ||||
71423 | 71423 | 2022-02-07 | Switzerland | 2433265 | 12808 | 0 | 46.8182 | 8.2275 | 2022-02-08 04:21:15 | Switzerland | ||||
75415 | 75415 | 2020-12-03 | Switzerland | 340115 | 5341 | 257600 | 77174 | 46.8182 | 8.2275 | 2020-12-04 05:27:27 | Switzerland | |||
79412 | 79412 | 2020-10-14 | Switzerland | 68704 | 1950 | 49800 | 16954 | 46.8182 | 8.2275 | 2020-10-15 04:24:28 | Switzerland | |||
83422 | 83422 | 2021-05-25 | Switzerland | 690123 | 10692 | 317600 | 361831 | 46.8182 | 8.2275 | 2021-05-26 04:20:35 | Switzerland | |||
87457 | 87457 | 2021-11-09 | Switzerland | 897078 | 11295 | 0 | 46.8182 | 8.2275 | 2021-11-10 04:21:38 | Switzerland | ||||
91475 | 91475 | 2022-07-23 | Switzerland | 3911515 | 13876 | 0 | 46.8182 | 8.2275 | 2022-07-24 04:20:47 | Switzerland | ||||
98740 | 98740 | 2020-08-04 | Switzerland | 35746 | 1829 | 31600 | 2317 | 46.8182 | 8.2275 | 2020-08-05 04:34:43 | Switzerland | |||
98837 | 98837 | 2020-03-04 | Switzerland | 90 | 0 | 3 | 46.8182 | 8.2275 | 2020-03-04T19:33:03 | |||||
99658 | 99658 | 2022-01-14 | Switzerland | 1666441 | 12464 | 0 | 46.8182 | 8.2275 | 2022-01-15 04:21:07 | Switzerland | ||||
103657 | 103657 | 2021-08-15 | Switzerland | 735375 | 10813 | 0 | 46.8182 | 8.2275 | 2021-08-16 04:21:31 | Switzerland | ||||
107781 | 107781 | 2021-06-19 | Switzerland | 701627 | 10762 | 317600 | 373265 | 46.8182 | 8.2275 | 2021-06-20 04:21:48 | Switzerland | |||
114360 | 114360 | 2020-05-08 | Switzerland | 30207 | 1738 | 26100 | 2369 | 46.8182 | 8.2275 | 2020-05-09 02:32:35 | Switzerland | |||
115085 | 115085 | 2022-09-06 | Switzerland | 4059532 | 13976 | 0 | 46.8182 | 8.2275 | 2022-09-07 04:20:59 | Switzerland | ||||
122331 | 122331 | 2020-07-19 | Switzerland | 33591 | 1815 | 30300 | 1476 | 46.8182 | 8.2275 | 2020-07-20 05:34:40 | Switzerland | |||
123030 | 123030 | 2020-11-18 | Switzerland | 280648 | 3967 | 169100 | 107581 | 46.8182 | 8.2275 | 2020-11-19 05:25:23 | Switzerland | |||
127065 | 127065 | 2022-01-09 | Switzerland | 1483212 | 12349 | 0 | 46.8182 | 8.2275 | 2022-01-10 04:22:07 | Switzerland | ||||
131085 | 131085 | 2022-10-04 | Switzerland | 4129096 | 14010 | 0 | 46.8182 | 8.2275 | 2022-10-05 04:23:06 | Switzerland | ||||
137583 | 137583 | 2020-04-29 | Switzerland | 29407 | 1649 | 22600 | 5158 | 46.8182 | 8.2275 | 2020-04-30 02:32:27 | Switzerland | |||
138303 | 138303 | 2021-12-04 | Switzerland | 1044633 | 11589 | 0 | 46.8182 | 8.2275 | 2021-12-05 04:22:25 | Switzerland | ||||
142321 | 142321 | 2022-07-09 | Switzerland | 3805774 | 13842 | 0 | 46.8182 | 8.2275 | 2022-07-10 04:20:54 | Switzerland | ||||
146295 | 146295 | 2020-08-15 | Switzerland | 37924 | 1838 | 33200 | 2886 | 46.8182 | 8.2275 | 2020-08-16 04:27:42 | Switzerland | |||
150316 | 150316 | 2021-11-29 | Switzerland | 1006239 | 11500 | 0 | 46.8182 | 8.2275 | 2021-11-30 04:22:53 | Switzerland | ||||
154309 | 154309 | 2021-01-08 | Switzerland | 477983 | 8395 | 317600 | 151988 | 46.8182 | 8.2275 | 2021-01-09 05:22:18 | Switzerland | |||
158345 | 158345 | 2022-03-29 | Switzerland | 3468289 | 13534 | 0 | 46.8182 | 8.2275 | 2022-03-30 04:20:45 | Switzerland | ||||
162360 | 162360 | 2021-11-19 | Switzerland | 941218 | 11377 | 0 | 46.8182 | 8.2275 | 2021-11-20 04:22:17 | Switzerland | ||||
166378 | 166378 | 2022-06-21 | Switzerland | 3726615 | 13820 | 0 | 46.8182 | 8.2275 | 2022-06-22 04:20:54 | Switzerland | ||||
170371 | 170371 | 2021-04-16 | Switzerland | 632399 | 10431 | 317600 | 304368 | 46.8182 | 8.2275 | 2021-04-17 04:20:40 | Switzerland | |||
177649 | 177649 | 2020-07-27 | Switzerland | 34477 | 1824 | 30900 | 1753 | 46.8182 | 8.2275 | 2020-07-28 04:58:43 | Switzerland | |||
178357 | 178357 | 2021-09-02 | Switzerland | 785696 | 10911 | 0 | 46.8182 | 8.2275 | 2021-09-03 04:21:20 | Switzerland | ||||
182367 | 182367 | 2021-02-21 | Switzerland | 547775 | 9946 | 317600 | 220229 | 46.8182 | 8.2275 | 2021-02-22 05:24:21 | Switzerland | |||
186403 | 186403 | 2022-02-13 | Switzerland | 2537734 | 12936 | 0 | 46.8182 | 8.2275 | 2022-02-14 04:20:51 | Switzerland | ||||
190395 | 190395 | 2021-01-11 | Switzerland | 484506 | 8587 | 317600 | 158319 | 46.8182 | 8.2275 | 2021-01-12 05:22:15 | Switzerland | |||
194390 | 194390 | 2020-08-31 | Switzerland | 42177 | 1848 | 36100 | 4229 | 46.8182 | 8.2275 | 2020-09-01 04:28:31 | Switzerland | |||
198594 | 198594 | 2022-10-19 | Switzerland | 4164685 | 14041 | 0 | 46.8182 | 8.2275 | 2022-10-20 04:22:59 | Switzerland | ||||
202582 | 202582 | 2020-12-25 | Switzerland | 428197 | 7352 | 311500 | 109345 | 46.8182 | 8.2275 | 2020-12-26 05:22:28 | Switzerland | |||
206577 | 206577 | 2020-08-19 | Switzerland | 38760 | 1840 | 33500 | 3420 | 46.8182 | 8.2275 | 2020-08-20 04:27:43 | Switzerland | |||
210565 | 210565 | 2020-10-29 | Switzerland | 145044 | 2280 | 65100 | 77664 | 46.8182 | 8.2275 | 2020-10-30 04:24:49 | Switzerland | |||
217589 | 217589 | 2020-06-08 | Switzerland | 30972 | 1799 | 28700 | 473 | 46.8182 | 8.2275 | 2020-06-09 03:33:03 | Switzerland | |||
218315 | 218315 | 2022-12-26 | Switzerland | 4386815 | 14166 | 0 | 46.8182 | 8.2275 | 2022-12-27 04:21:07 | Switzerland | ||||
222328 | 222328 | 2022-05-09 | Switzerland | 3636226 | 13729 | 0 | 46.8182 | 8.2275 | 2022-05-10 04:20:50 | Switzerland | ||||
228837 | 228837 | 2020-04-30 | Switzerland | 29586 | 1665 | 23400 | 4521 | 46.8182 | 8.2275 | 2020-05-01 02:32:28 | Switzerland | |||
229560 | 229560 | 2022-05-31 | Switzerland | 3674986 | 13800 | 0 | 46.8182 | 8.2275 | 2022-06-01 04:20:55 | Switzerland | ||||
233575 | 233575 | 2022-02-11 | Switzerland | 2537734 | 12932 | 0 | 46.8182 | 8.2275 | 2022-02-12 04:21:06 | Switzerland | ||||
237567 | 237567 | 2021-01-18 | Switzerland | 499931 | 8972 | 317600 | 173359 | 46.8182 | 8.2275 | 2021-01-19 05:22:15 | Switzerland | |||
241582 | 241582 | 2021-04-02 | Switzerland | 605342 | 10313 | 317600 | 277429 | 46.8182 | 8.2275 | 2021-04-03 04:20:44 | Switzerland | |||
245600 | 245600 | 2021-08-17 | Switzerland | 744106 | 10819 | 0 | 46.8182 | 8.2275 | 2021-08-18 04:21:35 | Switzerland | ||||
249614 | 249614 | 2021-09-04 | Switzerland | 785696 | 10920 | 0 | 46.8182 | 8.2275 | 2021-09-05 04:21:33 | Switzerland | ||||
253647 | 253647 | 2022-09-08 | Switzerland | 4059532 | 13986 | 0 | 46.8182 | 8.2275 | 2022-09-09 04:21:11 | Switzerland | ||||
257665 | 257665 | 2022-12-10 | Switzerland | 4356582 | 14147 | 0 | 46.8182 | 8.2275 | 2022-12-11 04:20:50 | Switzerland | ||||
261056 | 261056 | 2020-03-03 | Switzerland | 56 | 0 | 2 | 46.8182 | 8.2275 | 2020-03-03T16:43:02 | |||||
261865 | 261865 | 2022-03-15 | Switzerland | 3170937 | 13294 | 0 | 46.8182 | 8.2275 | 2022-03-16 04:20:50 | Switzerland | ||||
268593 | 268593 | 2020-05-21 | Switzerland | 30694 | 1786 | 27900 | 1008 | 46.8182 | 8.2275 | 2020-05-22 02:36:51 | Switzerland | |||
271797 | 271797 | 2020-04-28 | Switzerland | 29264 | 1637 | 22600 | 5027 | 46.8182 | 8.2275 | 2020-04-29 02:32:29 | Switzerland | |||
272480 | 272480 | 2020-11-10 | Switzerland | 235202 | 3196 | 122600 | 109406 | 46.8182 | 8.2275 | 2020-11-11 05:25:30 | Switzerland | |||
276515 | 276515 | 2021-11-03 | Switzerland | 881660 | 11261 | 0 | 46.8182 | 8.2275 | 2021-11-04 04:22:20 | Switzerland | ||||
280510 | 280510 | 2021-02-24 | Switzerland | 552698 | 9980 | 317600 | 225118 | 46.8182 | 8.2275 | 2021-02-25 05:24:57 | Switzerland | |||
287611 | 287611 | 2020-06-15 | Switzerland | 31131 | 1802 | 28900 | 429 | 46.8182 | 8.2275 | 2020-06-16 04:33:09 | Switzerland | |||
288328 | 288328 | 2021-10-31 | Switzerland | 872558 | 11234 | 0 | 46.8182 | 8.2275 | 2021-11-01 04:22:01 | Switzerland | ||||
292348 | 292348 | 2022-11-15 | Switzerland | 4297635 | 14101 | 0 | 46.8182 | 8.2275 | 2022-11-16 04:21:09 | Switzerland | ||||
296343 | 296343 | 2021-07-15 | Switzerland | 707357 | 10777 | 317600 | 378980 | 46.8182 | 8.2275 | 2021-07-16 04:21:22 | Switzerland | |||
303483 | 303483 | 2020-07-01 | Switzerland | 31851 | 1810 | 29200 | 841 | 46.8182 | 8.2275 | 2020-07-02 04:33:46 | Switzerland | |||
304201 | 304201 | 2022-04-16 | Switzerland | 3568616 | 13647 | 0 | 46.8182 | 8.2275 | 2022-04-17 04:20:59 | Switzerland | ||||
308220 | 308220 | 2022-12-13 | Switzerland | 4373011 | 14153 | 0 | 46.8182 | 8.2275 | 2022-12-14 04:21:04 | Switzerland | ||||
312236 | 312236 | 2022-11-13 | Switzerland | 4276848 | 14097 | 0 | 46.8182 | 8.2275 | 2022-11-14 04:21:09 | Switzerland | ||||
316249 | 316249 | 2022-02-12 | Switzerland | 2537734 | 12933 | 0 | 46.8182 | 8.2275 | 2022-02-13 04:21:00 | Switzerland | ||||
320268 | 320268 | 2022-10-30 | Switzerland | 4232022 | 14062 | 0 | 46.8182 | 8.2275 | 2022-10-31 04:21:36 | Switzerland | ||||
327426 | 327426 | 2020-07-20 | Switzerland | 33634 | 1818 | 30300 | 1516 | 46.8182 | 8.2275 | 2020-07-21 04:38:46 | Switzerland | |||
328242 | 328242 | 2022-12-27 | Switzerland | 4386815 | 14166 | 0 | 46.8182 | 8.2275 | 2022-12-28 04:21:04 | Switzerland | ||||
332237 | 332237 | 2021-08-04 | Switzerland | 721776 | 10796 | 317600 | 393380 | 46.8182 | 8.2275 | 2021-08-05 04:21:51 | Switzerland | |||
336269 | 336269 | 2022-03-18 | Switzerland | 3268953 | 13328 | 0 | 46.8182 | 8.2275 | 2022-03-19 04:20:47 | Switzerland | ||||
339631 | 339631 | 2020-03-21 | Switzerland | 6575 | 98 | 15 | 46.8182 | 8.2275 | 2020-03-21T20:43:02 | |||||
340602 | 340602 | 2021-02-03 | Switzerland | 528524 | 9605 | 317600 | 201319 | 46.8182 | 8.2275 | 2021-02-04 05:22:26 | Switzerland | |||
344598 | 344598 | 2020-09-14 | Switzerland | 47436 | 1870 | 39600 | 5966 | 46.8182 | 8.2275 | 2020-09-15 03:22:50 | Switzerland | |||
348632 | 348632 | 2022-12-14 | Switzerland | 4373011 | 14156 | 0 | 46.8182 | 8.2275 | 2022-12-15 04:20:58 | Switzerland | ||||
352623 | 352623 | 2021-03-11 | Switzerland | 569312 | 10113 | 317600 | 241599 | 46.8182 | 8.2275 | 2021-03-12 05:26:50 | Switzerland | |||
356659 | 356659 | 2022-03-11 | Switzerland | 3072758 | 13265 | 0 | 46.8182 | 8.2275 | 2022-03-12 04:20:50 | Switzerland | ||||
360675 | 360675 | 2022-05-07 | Switzerland | 3636226 | 13726 | 0 | 46.8182 | 8.2275 | 2022-05-08 04:20:49 | Switzerland | ||||
367831 | 367831 | 2020-07-16 | Switzerland | 33290 | 1815 | 29900 | 1575 | 46.8182 | 8.2275 | 2020-07-17 04:34:50 | Switzerland | |||
371805 | 371805 | 2020-08-08 | Switzerland | 36451 | 1833 | 31900 | 2718 | 46.8182 | 8.2275 | 2020-08-09 04:34:54 | Switzerland | |||
372532 | 372532 | 2022-09-13 | Switzerland | 4073348 | 13992 | 0 | 46.8182 | 8.2275 | 2022-09-14 04:20:44 | Switzerland |
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]);