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 day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
country_or_region 1
- Switzerland · 939 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2017059 | 2017059 | 2022-09-20 | Switzerland | 4087087 | 13996 | 0 | 46.8182 | 8.2275 | 2022-09-21 04:23:22 | Switzerland | ||||
3570932 | 3570932 | 2022-09-19 | Switzerland | 4073348 | 13995 | 0 | 46.8182 | 8.2275 | 2022-09-20 04:22:48 | Switzerland | ||||
419671 | 419671 | 2022-09-18 | Switzerland | 4073348 | 13992 | 0 | 46.8182 | 8.2275 | 2022-09-19 04:21:49 | Switzerland | ||||
3373695 | 3373695 | 2022-09-17 | Switzerland | 4073348 | 13992 | 0 | 46.8182 | 8.2275 | 2022-09-18 04:22:50 | Switzerland | ||||
2355803 | 2355803 | 2022-09-16 | Switzerland | 4073348 | 13992 | 0 | 46.8182 | 8.2275 | 2022-09-17 04:20:19 | Switzerland | ||||
3986960 | 3986960 | 2022-09-15 | Switzerland | 4073348 | 13992 | 0 | 46.8182 | 8.2275 | 2022-09-16 04:21:19 | Switzerland | ||||
1889477 | 1889477 | 2022-09-14 | Switzerland | 4073348 | 13992 | 0 | 46.8182 | 8.2275 | 2022-09-15 04:21:02 | Switzerland | ||||
372532 | 372532 | 2022-09-13 | Switzerland | 4073348 | 13992 | 0 | 46.8182 | 8.2275 | 2022-09-14 04:20:44 | Switzerland | ||||
2395135 | 2395135 | 2022-09-12 | Switzerland | 4059532 | 13988 | 0 | 46.8182 | 8.2275 | 2022-09-13 04:20:57 | Switzerland | ||||
3766213 | 3766213 | 2022-09-11 | Switzerland | 4059532 | 13987 | 0 | 46.8182 | 8.2275 | 2022-09-12 04:20:58 | Switzerland | ||||
3824788 | 3824788 | 2022-09-10 | Switzerland | 4059532 | 13987 | 0 | 46.8182 | 8.2275 | 2022-09-11 04:20:50 | Switzerland | ||||
963245 | 963245 | 2022-09-09 | Switzerland | 4059532 | 13987 | 0 | 46.8182 | 8.2275 | 2022-09-10 04:21:10 | Switzerland | ||||
253647 | 253647 | 2022-09-08 | Switzerland | 4059532 | 13986 | 0 | 46.8182 | 8.2275 | 2022-09-09 04:21:11 | Switzerland | ||||
3745445 | 3745445 | 2022-09-07 | Switzerland | 4059532 | 13986 | 0 | 46.8182 | 8.2275 | 2022-09-08 04:21:02 | Switzerland | ||||
115085 | 115085 | 2022-09-06 | Switzerland | 4059532 | 13976 | 0 | 46.8182 | 8.2275 | 2022-09-07 04:20:59 | Switzerland | ||||
2634057 | 2634057 | 2022-09-05 | Switzerland | 4045011 | 13975 | 0 | 46.8182 | 8.2275 | 2022-09-06 04:21:02 | Switzerland | ||||
2987621 | 2987621 | 2022-09-04 | Switzerland | 4045011 | 13975 | 0 | 46.8182 | 8.2275 | 2022-09-05 04:21:01 | Switzerland | ||||
2713306 | 2713306 | 2022-09-03 | Switzerland | 4045011 | 13975 | 0 | 46.8182 | 8.2275 | 2022-09-04 04:21:22 | Switzerland | ||||
1394011 | 1394011 | 2022-09-02 | Switzerland | 4045011 | 13974 | 0 | 46.8182 | 8.2275 | 2022-09-03 04:21:04 | Switzerland | ||||
3547840 | 3547840 | 2022-09-01 | Switzerland | 4045011 | 13974 | 0 | 46.8182 | 8.2275 | 2022-09-02 04:21:07 | Switzerland | ||||
2343760 | 2343760 | 2022-08-31 | Switzerland | 4045011 | 13974 | 0 | 46.8182 | 8.2275 | 2022-09-01 04:21:03 | Switzerland | ||||
3774240 | 3774240 | 2022-08-30 | Switzerland | 4045011 | 13969 | 0 | 46.8182 | 8.2275 | 2022-08-31 04:20:57 | Switzerland | ||||
1680836 | 1680836 | 2022-08-29 | Switzerland | 4029657 | 13967 | 0 | 46.8182 | 8.2275 | 2022-08-30 04:21:03 | Switzerland | ||||
1877320 | 1877320 | 2022-08-28 | Switzerland | 4029657 | 13966 | 0 | 46.8182 | 8.2275 | 2022-08-29 04:21:06 | Switzerland | ||||
2096447 | 2096447 | 2022-08-27 | Switzerland | 4029657 | 13966 | 0 | 46.8182 | 8.2275 | 2022-08-28 04:21:02 | Switzerland | ||||
1532262 | 1532262 | 2022-08-26 | Switzerland | 4029657 | 13966 | 0 | 46.8182 | 8.2275 | 2022-08-27 04:20:57 | Switzerland | ||||
2829149 | 2829149 | 2022-08-25 | Switzerland | 4029657 | 13966 | 0 | 46.8182 | 8.2275 | 2022-08-26 04:21:02 | Switzerland | ||||
2323682 | 2323682 | 2022-08-24 | Switzerland | 4029657 | 13966 | 0 | 46.8182 | 8.2275 | 2022-08-25 04:21:13 | Switzerland | ||||
1251091 | 1251091 | 2022-08-23 | Switzerland | 4029657 | 13958 | 0 | 46.8182 | 8.2275 | 2022-08-24 04:20:46 | Switzerland | ||||
2853195 | 2853195 | 2022-08-22 | Switzerland | 4012610 | 13955 | 0 | 46.8182 | 8.2275 | 2022-08-23 04:20:56 | Switzerland | ||||
2403167 | 2403167 | 2022-08-21 | Switzerland | 4012610 | 13953 | 0 | 46.8182 | 8.2275 | 2022-08-22 04:20:38 | Switzerland | ||||
3798245 | 3798245 | 2022-08-20 | Switzerland | 4012610 | 13953 | 0 | 46.8182 | 8.2275 | 2022-08-21 04:20:44 | Switzerland | ||||
2363831 | 2363831 | 2022-08-19 | Switzerland | 4012610 | 13953 | 0 | 46.8182 | 8.2275 | 2022-08-20 04:21:01 | Switzerland | ||||
1161502 | 1161502 | 2022-08-18 | Switzerland | 4012610 | 13951 | 0 | 46.8182 | 8.2275 | 2022-08-19 04:20:54 | Switzerland | ||||
3950826 | 3950826 | 2022-08-17 | Switzerland | 4012610 | 13951 | 0 | 46.8182 | 8.2275 | 2022-08-18 04:21:11 | Switzerland | ||||
991328 | 991328 | 2022-08-16 | Switzerland | 4012610 | 13946 | 0 | 46.8182 | 8.2275 | 2022-08-17 04:20:59 | Switzerland | ||||
2494367 | 2494367 | 2022-08-15 | Switzerland | 3994397 | 13939 | 0 | 46.8182 | 8.2275 | 2022-08-16 04:20:58 | Switzerland | ||||
3647917 | 3647917 | 2022-08-14 | Switzerland | 3994397 | 13939 | 0 | 46.8182 | 8.2275 | 2022-08-15 04:20:59 | Switzerland | ||||
1968923 | 1968923 | 2022-08-13 | Switzerland | 3994397 | 13939 | 0 | 46.8182 | 8.2275 | 2022-08-14 04:20:55 | Switzerland | ||||
2888732 | 2888732 | 2022-08-12 | Switzerland | 3994397 | 13939 | 0 | 46.8182 | 8.2275 | 2022-08-13 04:20:52 | Switzerland | ||||
3908337 | 3908337 | 2022-08-11 | Switzerland | 3994397 | 13938 | 0 | 46.8182 | 8.2275 | 2022-08-12 04:20:54 | Switzerland | ||||
1346654 | 1346654 | 2022-08-10 | Switzerland | 3994397 | 13938 | 0 | 46.8182 | 8.2275 | 2022-08-11 04:20:49 | Switzerland | ||||
1086409 | 1086409 | 2022-08-09 | Switzerland | 3994397 | 13925 | 0 | 46.8182 | 8.2275 | 2022-08-10 04:20:57 | Switzerland | ||||
3543824 | 3543824 | 2022-08-08 | Switzerland | 3972622 | 13920 | 0 | 46.8182 | 8.2275 | 2022-08-09 04:20:34 | Switzerland | ||||
1070227 | 1070227 | 2022-08-07 | Switzerland | 3972622 | 13918 | 0 | 46.8182 | 8.2275 | 2022-08-08 04:21:08 | Switzerland | ||||
1940815 | 1940815 | 2022-08-06 | Switzerland | 3972622 | 13918 | 0 | 46.8182 | 8.2275 | 2022-08-07 04:20:54 | Switzerland | ||||
880614 | 880614 | 2022-08-05 | Switzerland | 3972622 | 13918 | 0 | 46.8182 | 8.2275 | 2022-08-06 04:20:56 | Switzerland | ||||
2009025 | 2009025 | 2022-08-04 | Switzerland | 3972622 | 13918 | 0 | 46.8182 | 8.2275 | 2022-08-05 04:20:52 | Switzerland | ||||
1098452 | 1098452 | 2022-08-03 | Switzerland | 3972622 | 13917 | 0 | 46.8182 | 8.2275 | 2022-08-04 04:20:58 | Switzerland | ||||
1405377 | 1405377 | 2022-08-02 | Switzerland | 3972622 | 13900 | 0 | 46.8182 | 8.2275 | 2022-08-03 04:20:59 | Switzerland | ||||
3617415 | 3617415 | 2022-08-01 | Switzerland | 3949259 | 13891 | 0 | 46.8182 | 8.2275 | 2022-08-02 04:20:53 | Switzerland | ||||
3871895 | 3871895 | 2022-07-31 | Switzerland | 3949259 | 13891 | 0 | 46.8182 | 8.2275 | 2022-08-01 04:21:03 | Switzerland | ||||
674649 | 674649 | 2022-07-30 | Switzerland | 3949259 | 13891 | 0 | 46.8182 | 8.2275 | 2022-07-31 04:21:02 | Switzerland | ||||
1783848 | 1783848 | 2022-07-29 | Switzerland | 3949259 | 13891 | 0 | 46.8182 | 8.2275 | 2022-07-30 04:20:42 | Switzerland | ||||
1066211 | 1066211 | 2022-07-28 | Switzerland | 3949259 | 13891 | 0 | 46.8182 | 8.2275 | 2022-07-29 04:20:45 | Switzerland | ||||
2335730 | 2335730 | 2022-07-27 | Switzerland | 3949259 | 13891 | 0 | 46.8182 | 8.2275 | 2022-07-28 04:20:56 | Switzerland | ||||
1487920 | 1487920 | 2022-07-26 | Switzerland | 3949259 | 13882 | 0 | 46.8182 | 8.2275 | 2022-07-27 04:21:04 | Switzerland | ||||
2594366 | 2594366 | 2022-07-25 | Switzerland | 3911515 | 13877 | 0 | 46.8182 | 8.2275 | 2022-07-26 04:20:58 | Switzerland | ||||
896481 | 896481 | 2022-07-24 | Switzerland | 3911515 | 13876 | 0 | 46.8182 | 8.2275 | 2022-07-25 04:20:51 | Switzerland | ||||
91475 | 91475 | 2022-07-23 | Switzerland | 3911515 | 13876 | 0 | 46.8182 | 8.2275 | 2022-07-24 04:20:47 | Switzerland | ||||
900497 | 900497 | 2022-07-22 | Switzerland | 3911515 | 13876 | 0 | 46.8182 | 8.2275 | 2022-07-23 04:20:53 | Switzerland | ||||
670633 | 670633 | 2022-07-21 | Switzerland | 3911515 | 13874 | 0 | 46.8182 | 8.2275 | 2022-07-22 04:21:15 | Switzerland | ||||
1608596 | 1608596 | 2022-07-20 | Switzerland | 3911515 | 13873 | 0 | 46.8182 | 8.2275 | 2022-07-21 04:21:10 | Switzerland | ||||
959229 | 959229 | 2022-07-19 | Switzerland | 3911515 | 13862 | 0 | 46.8182 | 8.2275 | 2022-07-20 04:20:59 | Switzerland | ||||
3210616 | 3210616 | 2022-07-18 | Switzerland | 3861756 | 13860 | 0 | 46.8182 | 8.2275 | 2022-07-19 04:20:58 | Switzerland | ||||
3405791 | 3405791 | 2022-07-17 | Switzerland | 3861756 | 13857 | 0 | 46.8182 | 8.2275 | 2022-07-18 04:20:59 | Switzerland | ||||
2151991 | 2151991 | 2022-07-16 | Switzerland | 3861756 | 13857 | 0 | 46.8182 | 8.2275 | 2022-07-17 04:21:15 | Switzerland | ||||
2419224 | 2419224 | 2022-07-15 | Switzerland | 3861756 | 13857 | 0 | 46.8182 | 8.2275 | 2022-07-16 04:21:05 | Switzerland | ||||
3429299 | 3429299 | 2022-07-14 | Switzerland | 3861756 | 13857 | 0 | 46.8182 | 8.2275 | 2022-07-15 04:20:53 | Switzerland | ||||
3109819 | 3109819 | 2022-07-13 | Switzerland | 3861756 | 13857 | 0 | 46.8182 | 8.2275 | 2022-07-14 04:20:57 | Switzerland | ||||
630242 | 630242 | 2022-07-12 | Switzerland | 3861756 | 13848 | 0 | 46.8182 | 8.2275 | 2022-07-13 04:20:58 | Switzerland | ||||
1211886 | 1211886 | 2022-07-11 | Switzerland | 3805774 | 13844 | 0 | 46.8182 | 8.2275 | 2022-07-12 04:20:51 | Switzerland | ||||
2789368 | 2789368 | 2022-07-10 | Switzerland | 3805774 | 13842 | 0 | 46.8182 | 8.2275 | 2022-07-11 04:20:46 | Switzerland | ||||
142321 | 142321 | 2022-07-09 | Switzerland | 3805774 | 13842 | 0 | 46.8182 | 8.2275 | 2022-07-10 04:20:54 | Switzerland | ||||
1417421 | 1417421 | 2022-07-08 | Switzerland | 3805774 | 13842 | 0 | 46.8182 | 8.2275 | 2022-07-09 04:20:59 | Switzerland | ||||
2741346 | 2741346 | 2022-07-07 | Switzerland | 3805774 | 13842 | 0 | 46.8182 | 8.2275 | 2022-07-08 04:20:56 | Switzerland | ||||
1200141 | 1200141 | 2022-07-06 | Switzerland | 3805774 | 13841 | 0 | 46.8182 | 8.2275 | 2022-07-07 04:20:55 | Switzerland | ||||
3966884 | 3966884 | 2022-07-05 | Switzerland | 3805774 | 13835 | 0 | 46.8182 | 8.2275 | 2022-07-06 04:20:58 | Switzerland | ||||
3078395 | 3078395 | 2022-07-04 | Switzerland | 3759730 | 13833 | 0 | 46.8182 | 8.2275 | 2022-07-05 04:20:45 | Switzerland | ||||
1767677 | 1767677 | 2022-07-03 | Switzerland | 3759730 | 13832 | 0 | 46.8182 | 8.2275 | 2022-07-04 04:20:54 | Switzerland | ||||
3365663 | 3365663 | 2022-07-02 | Switzerland | 3759730 | 13832 | 0 | 46.8182 | 8.2275 | 2022-07-03 04:20:59 | Switzerland | ||||
593992 | 593992 | 2022-07-01 | Switzerland | 3759730 | 13832 | 0 | 46.8182 | 8.2275 | 2022-07-02 04:21:16 | Switzerland | ||||
3940393 | 3940393 | 2022-06-30 | Switzerland | 3759730 | 13831 | 0 | 46.8182 | 8.2275 | 2022-07-01 04:21:10 | Switzerland | ||||
2490351 | 2490351 | 2022-06-29 | Switzerland | 3759730 | 13828 | 0 | 46.8182 | 8.2275 | 2022-06-30 04:21:01 | Switzerland | ||||
2239733 | 2239733 | 2022-06-28 | Switzerland | 3759730 | 13824 | 0 | 46.8182 | 8.2275 | 2022-06-29 04:20:59 | Switzerland | ||||
2147975 | 2147975 | 2022-06-27 | Switzerland | 3726615 | 13824 | 0 | 46.8182 | 8.2275 | 2022-06-28 04:20:58 | Switzerland | ||||
475776 | 475776 | 2022-06-26 | Switzerland | 3726615 | 13822 | 0 | 46.8182 | 8.2275 | 2022-06-27 04:21:00 | Switzerland | ||||
939151 | 939151 | 2022-06-25 | Switzerland | 3726615 | 13822 | 0 | 46.8182 | 8.2275 | 2022-06-26 04:21:02 | Switzerland | ||||
3346971 | 3346971 | 2022-06-24 | Switzerland | 3726615 | 13822 | 0 | 46.8182 | 8.2275 | 2022-06-25 04:20:57 | Switzerland | ||||
1648712 | 1648712 | 2022-06-23 | Switzerland | 3726615 | 13822 | 0 | 46.8182 | 8.2275 | 2022-06-24 04:20:58 | Switzerland | ||||
2187947 | 2187947 | 2022-06-22 | Switzerland | 3726615 | 13822 | 0 | 46.8182 | 8.2275 | 2022-06-23 04:20:55 | Switzerland | ||||
166378 | 166378 | 2022-06-21 | Switzerland | 3726615 | 13820 | 0 | 46.8182 | 8.2275 | 2022-06-22 04:20:54 | Switzerland | ||||
1763661 | 1763661 | 2022-06-20 | Switzerland | 3701895 | 13820 | 0 | 46.8182 | 8.2275 | 2022-06-21 04:20:56 | Switzerland | ||||
3269847 | 3269847 | 2022-06-19 | Switzerland | 3701895 | 13817 | 0 | 46.8182 | 8.2275 | 2022-06-20 04:21:01 | Switzerland | ||||
3397759 | 3397759 | 2022-06-18 | Switzerland | 3701895 | 13817 | 0 | 46.8182 | 8.2275 | 2022-06-19 04:20:51 | Switzerland | ||||
2311636 | 2311636 | 2022-06-17 | Switzerland | 3701895 | 13817 | 0 | 46.8182 | 8.2275 | 2022-06-18 04:21:10 | Switzerland | ||||
559140 | 559140 | 2022-06-16 | Switzerland | 3701895 | 13817 | 0 | 46.8182 | 8.2275 | 2022-06-17 04:20:56 | Switzerland | ||||
3982942 | 3982942 | 2022-06-15 | Switzerland | 3701895 | 13817 | 0 | 46.8182 | 8.2275 | 2022-06-16 04:20:55 | Switzerland | ||||
947183 | 947183 | 2022-06-14 | Switzerland | 3701895 | 13817 | 0 | 46.8182 | 8.2275 | 2022-06-15 04:20:54 | Switzerland | ||||
2979591 | 2979591 | 2022-06-13 | Switzerland | 3685281 | 13815 | 0 | 46.8182 | 8.2275 | 2022-06-14 04:20:52 | 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]);