johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
960 rows where country_or_region = "Germany" and province_or_state = "Unknown" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2016631 | 2016631 | 2022-09-20 | Germany | Unknown | 0 | 0 | 0 | 2022-09-21 04:23:22 | Unknown, Germany | |||||
3570504 | 3570504 | 2022-09-19 | Germany | Unknown | 0 | 0 | 0 | 2022-09-20 04:22:48 | Unknown, Germany | |||||
419243 | 419243 | 2022-09-18 | Germany | Unknown | 0 | 0 | 0 | 2022-09-19 04:21:49 | Unknown, Germany | |||||
3373267 | 3373267 | 2022-09-17 | Germany | Unknown | 0 | 0 | 0 | 2022-09-18 04:22:50 | Unknown, Germany | |||||
2355375 | 2355375 | 2022-09-16 | Germany | Unknown | 0 | 0 | 0 | 2022-09-17 04:20:19 | Unknown, Germany | |||||
3986532 | 3986532 | 2022-09-15 | Germany | Unknown | 0 | 0 | 0 | 2022-09-16 04:21:19 | Unknown, Germany | |||||
1889049 | 1889049 | 2022-09-14 | Germany | Unknown | 0 | 0 | 0 | 2022-09-15 04:21:02 | Unknown, Germany | |||||
372104 | 372104 | 2022-09-13 | Germany | Unknown | 0 | 0 | 0 | 2022-09-14 04:20:44 | Unknown, Germany | |||||
2394709 | 2394709 | 2022-09-12 | Germany | Unknown | 0 | 0 | 0 | 2022-09-13 04:20:57 | Unknown, Germany | |||||
3765787 | 3765787 | 2022-09-11 | Germany | Unknown | 0 | 0 | 0 | 2022-09-12 04:20:58 | Unknown, Germany | |||||
3824362 | 3824362 | 2022-09-10 | Germany | Unknown | 0 | 0 | 0 | 2022-09-11 04:20:50 | Unknown, Germany | |||||
962819 | 962819 | 2022-09-09 | Germany | Unknown | 0 | 0 | 0 | 2022-09-10 04:21:10 | Unknown, Germany | |||||
253221 | 253221 | 2022-09-08 | Germany | Unknown | 0 | 0 | 0 | 2022-09-09 04:21:11 | Unknown, Germany | |||||
3745019 | 3745019 | 2022-09-07 | Germany | Unknown | 0 | 0 | 0 | 2022-09-08 04:21:02 | Unknown, Germany | |||||
114659 | 114659 | 2022-09-06 | Germany | Unknown | 0 | 0 | 0 | 2022-09-07 04:20:59 | Unknown, Germany | |||||
2633631 | 2633631 | 2022-09-05 | Germany | Unknown | 0 | 0 | 0 | 2022-09-06 04:21:02 | Unknown, Germany | |||||
2987195 | 2987195 | 2022-09-04 | Germany | Unknown | 0 | 0 | 0 | 2022-09-05 04:21:01 | Unknown, Germany | |||||
2712880 | 2712880 | 2022-09-03 | Germany | Unknown | 0 | 0 | 0 | 2022-09-04 04:21:22 | Unknown, Germany | |||||
1393585 | 1393585 | 2022-09-02 | Germany | Unknown | 0 | 0 | 0 | 2022-09-03 04:21:04 | Unknown, Germany | |||||
3547414 | 3547414 | 2022-09-01 | Germany | Unknown | 0 | 0 | 0 | 2022-09-02 04:21:07 | Unknown, Germany | |||||
2343334 | 2343334 | 2022-08-31 | Germany | Unknown | 0 | 0 | 0 | 2022-09-01 04:21:03 | Unknown, Germany | |||||
3773814 | 3773814 | 2022-08-30 | Germany | Unknown | 0 | 0 | 0 | 2022-08-31 04:20:57 | Unknown, Germany | |||||
1680410 | 1680410 | 2022-08-29 | Germany | Unknown | 0 | 0 | 0 | 2022-08-30 04:21:03 | Unknown, Germany | |||||
1876894 | 1876894 | 2022-08-28 | Germany | Unknown | 0 | 0 | 0 | 2022-08-29 04:21:06 | Unknown, Germany | |||||
2096021 | 2096021 | 2022-08-27 | Germany | Unknown | 0 | 0 | 0 | 2022-08-28 04:21:02 | Unknown, Germany | |||||
1531836 | 1531836 | 2022-08-26 | Germany | Unknown | 0 | 0 | 0 | 2022-08-27 04:20:57 | Unknown, Germany | |||||
2828723 | 2828723 | 2022-08-25 | Germany | Unknown | 0 | 0 | 0 | 2022-08-26 04:21:02 | Unknown, Germany | |||||
2323256 | 2323256 | 2022-08-24 | Germany | Unknown | 0 | 0 | 0 | 2022-08-25 04:21:13 | Unknown, Germany | |||||
1250665 | 1250665 | 2022-08-23 | Germany | Unknown | 0 | 0 | 0 | 2022-08-24 04:20:46 | Unknown, Germany | |||||
2852769 | 2852769 | 2022-08-22 | Germany | Unknown | 0 | 0 | 0 | 2022-08-23 04:20:56 | Unknown, Germany | |||||
2402741 | 2402741 | 2022-08-21 | Germany | Unknown | 0 | 0 | 0 | 2022-08-22 04:20:38 | Unknown, Germany | |||||
3797819 | 3797819 | 2022-08-20 | Germany | Unknown | 0 | 0 | 0 | 2022-08-21 04:20:44 | Unknown, Germany | |||||
2363405 | 2363405 | 2022-08-19 | Germany | Unknown | 0 | 0 | 0 | 2022-08-20 04:21:01 | Unknown, Germany | |||||
1161076 | 1161076 | 2022-08-18 | Germany | Unknown | 0 | 0 | 0 | 2022-08-19 04:20:54 | Unknown, Germany | |||||
3950400 | 3950400 | 2022-08-17 | Germany | Unknown | 0 | 0 | 0 | 2022-08-18 04:21:11 | Unknown, Germany | |||||
990902 | 990902 | 2022-08-16 | Germany | Unknown | 0 | 0 | 0 | 2022-08-17 04:20:59 | Unknown, Germany | |||||
2493941 | 2493941 | 2022-08-15 | Germany | Unknown | 0 | 0 | 0 | 2022-08-16 04:20:58 | Unknown, Germany | |||||
3647491 | 3647491 | 2022-08-14 | Germany | Unknown | 0 | 0 | 0 | 2022-08-15 04:20:59 | Unknown, Germany | |||||
1968497 | 1968497 | 2022-08-13 | Germany | Unknown | 0 | 0 | 0 | 2022-08-14 04:20:55 | Unknown, Germany | |||||
2888306 | 2888306 | 2022-08-12 | Germany | Unknown | 0 | 0 | 0 | 2022-08-13 04:20:52 | Unknown, Germany | |||||
3907911 | 3907911 | 2022-08-11 | Germany | Unknown | 0 | 0 | 0 | 2022-08-12 04:20:54 | Unknown, Germany | |||||
1346228 | 1346228 | 2022-08-10 | Germany | Unknown | 0 | 0 | 0 | 2022-08-11 04:20:49 | Unknown, Germany | |||||
1085983 | 1085983 | 2022-08-09 | Germany | Unknown | 0 | 0 | 0 | 2022-08-10 04:20:57 | Unknown, Germany | |||||
3543398 | 3543398 | 2022-08-08 | Germany | Unknown | 0 | 0 | 0 | 2022-08-09 04:20:34 | Unknown, Germany | |||||
1069801 | 1069801 | 2022-08-07 | Germany | Unknown | 0 | 0 | 0 | 2022-08-08 04:21:08 | Unknown, Germany | |||||
1940389 | 1940389 | 2022-08-06 | Germany | Unknown | 0 | 0 | 0 | 2022-08-07 04:20:54 | Unknown, Germany | |||||
880188 | 880188 | 2022-08-05 | Germany | Unknown | 0 | 0 | 0 | 2022-08-06 04:20:56 | Unknown, Germany | |||||
2008599 | 2008599 | 2022-08-04 | Germany | Unknown | 0 | 0 | 0 | 2022-08-05 04:20:52 | Unknown, Germany | |||||
1098026 | 1098026 | 2022-08-03 | Germany | Unknown | 0 | 0 | 0 | 2022-08-04 04:20:58 | Unknown, Germany | |||||
1404951 | 1404951 | 2022-08-02 | Germany | Unknown | 0 | 0 | 0 | 2022-08-03 04:20:59 | Unknown, Germany | |||||
3616989 | 3616989 | 2022-08-01 | Germany | Unknown | 0 | 0 | 0 | 2022-08-02 04:20:53 | Unknown, Germany | |||||
3871469 | 3871469 | 2022-07-31 | Germany | Unknown | 0 | 0 | 0 | 2022-08-01 04:21:03 | Unknown, Germany | |||||
674223 | 674223 | 2022-07-30 | Germany | Unknown | 0 | 0 | 0 | 2022-07-31 04:21:02 | Unknown, Germany | |||||
1783422 | 1783422 | 2022-07-29 | Germany | Unknown | 0 | 0 | 0 | 2022-07-30 04:20:42 | Unknown, Germany | |||||
1065785 | 1065785 | 2022-07-28 | Germany | Unknown | 0 | 0 | 0 | 2022-07-29 04:20:45 | Unknown, Germany | |||||
2335304 | 2335304 | 2022-07-27 | Germany | Unknown | 0 | 0 | 0 | 2022-07-28 04:20:56 | Unknown, Germany | |||||
1487494 | 1487494 | 2022-07-26 | Germany | Unknown | 0 | 0 | 0 | 2022-07-27 04:21:04 | Unknown, Germany | |||||
2593940 | 2593940 | 2022-07-25 | Germany | Unknown | 0 | 0 | 0 | 2022-07-26 04:20:58 | Unknown, Germany | |||||
896055 | 896055 | 2022-07-24 | Germany | Unknown | 0 | 0 | 0 | 2022-07-25 04:20:51 | Unknown, Germany | |||||
91049 | 91049 | 2022-07-23 | Germany | Unknown | 0 | 0 | 0 | 2022-07-24 04:20:47 | Unknown, Germany | |||||
900071 | 900071 | 2022-07-22 | Germany | Unknown | 0 | 0 | 0 | 2022-07-23 04:20:53 | Unknown, Germany | |||||
670207 | 670207 | 2022-07-21 | Germany | Unknown | 0 | 0 | 0 | 2022-07-22 04:21:15 | Unknown, Germany | |||||
1608170 | 1608170 | 2022-07-20 | Germany | Unknown | 0 | 0 | 0 | 2022-07-21 04:21:10 | Unknown, Germany | |||||
958803 | 958803 | 2022-07-19 | Germany | Unknown | 0 | 0 | 0 | 2022-07-20 04:20:59 | Unknown, Germany | |||||
3210190 | 3210190 | 2022-07-18 | Germany | Unknown | 0 | 0 | 0 | 2022-07-19 04:20:58 | Unknown, Germany | |||||
3405365 | 3405365 | 2022-07-17 | Germany | Unknown | 0 | 0 | 0 | 2022-07-18 04:20:59 | Unknown, Germany | |||||
2151565 | 2151565 | 2022-07-16 | Germany | Unknown | 0 | 0 | 0 | 2022-07-17 04:21:15 | Unknown, Germany | |||||
2418798 | 2418798 | 2022-07-15 | Germany | Unknown | 0 | 0 | 0 | 2022-07-16 04:21:05 | Unknown, Germany | |||||
3428873 | 3428873 | 2022-07-14 | Germany | Unknown | 0 | 0 | 0 | 2022-07-15 04:20:53 | Unknown, Germany | |||||
3109393 | 3109393 | 2022-07-13 | Germany | Unknown | 0 | 0 | 0 | 2022-07-14 04:20:57 | Unknown, Germany | |||||
629816 | 629816 | 2022-07-12 | Germany | Unknown | 0 | 0 | 0 | 2022-07-13 04:20:58 | Unknown, Germany | |||||
1211460 | 1211460 | 2022-07-11 | Germany | Unknown | 0 | 0 | 0 | 2022-07-12 04:20:51 | Unknown, Germany | |||||
2788942 | 2788942 | 2022-07-10 | Germany | Unknown | 0 | 0 | 0 | 2022-07-11 04:20:46 | Unknown, Germany | |||||
141895 | 141895 | 2022-07-09 | Germany | Unknown | 0 | 0 | 0 | 2022-07-10 04:20:54 | Unknown, Germany | |||||
1416995 | 1416995 | 2022-07-08 | Germany | Unknown | 0 | 0 | 0 | 2022-07-09 04:20:59 | Unknown, Germany | |||||
2740920 | 2740920 | 2022-07-07 | Germany | Unknown | 0 | 0 | 0 | 2022-07-08 04:20:56 | Unknown, Germany | |||||
1199715 | 1199715 | 2022-07-06 | Germany | Unknown | 0 | 0 | 0 | 2022-07-07 04:20:55 | Unknown, Germany | |||||
3966458 | 3966458 | 2022-07-05 | Germany | Unknown | 0 | 0 | 0 | 2022-07-06 04:20:58 | Unknown, Germany | |||||
3077969 | 3077969 | 2022-07-04 | Germany | Unknown | 0 | 0 | 0 | 2022-07-05 04:20:45 | Unknown, Germany | |||||
1767251 | 1767251 | 2022-07-03 | Germany | Unknown | 0 | 0 | 0 | 2022-07-04 04:20:54 | Unknown, Germany | |||||
3365237 | 3365237 | 2022-07-02 | Germany | Unknown | 0 | 0 | 0 | 2022-07-03 04:20:59 | Unknown, Germany | |||||
593566 | 593566 | 2022-07-01 | Germany | Unknown | 0 | 0 | 0 | 2022-07-02 04:21:16 | Unknown, Germany | |||||
3939967 | 3939967 | 2022-06-30 | Germany | Unknown | 0 | 0 | 0 | 2022-07-01 04:21:10 | Unknown, Germany | |||||
2489925 | 2489925 | 2022-06-29 | Germany | Unknown | 0 | 0 | 0 | 2022-06-30 04:21:01 | Unknown, Germany | |||||
2239307 | 2239307 | 2022-06-28 | Germany | Unknown | 0 | 0 | 0 | 2022-06-29 04:20:59 | Unknown, Germany | |||||
2147549 | 2147549 | 2022-06-27 | Germany | Unknown | 0 | 0 | 0 | 2022-06-28 04:20:58 | Unknown, Germany | |||||
475350 | 475350 | 2022-06-26 | Germany | Unknown | 0 | 0 | 0 | 2022-06-27 04:21:00 | Unknown, Germany | |||||
938725 | 938725 | 2022-06-25 | Germany | Unknown | 0 | 0 | 0 | 2022-06-26 04:21:02 | Unknown, Germany | |||||
3346545 | 3346545 | 2022-06-24 | Germany | Unknown | 0 | 0 | 0 | 2022-06-25 04:20:57 | Unknown, Germany | |||||
1648286 | 1648286 | 2022-06-23 | Germany | Unknown | 0 | 0 | 0 | 2022-06-24 04:20:58 | Unknown, Germany | |||||
2187521 | 2187521 | 2022-06-22 | Germany | Unknown | 0 | 0 | 0 | 2022-06-23 04:20:55 | Unknown, Germany | |||||
165952 | 165952 | 2022-06-21 | Germany | Unknown | 0 | 0 | 0 | 2022-06-22 04:20:54 | Unknown, Germany | |||||
1763235 | 1763235 | 2022-06-20 | Germany | Unknown | 0 | 0 | 0 | 2022-06-21 04:20:56 | Unknown, Germany | |||||
3269421 | 3269421 | 2022-06-19 | Germany | Unknown | 0 | 0 | 0 | 2022-06-20 04:21:01 | Unknown, Germany | |||||
3397333 | 3397333 | 2022-06-18 | Germany | Unknown | 0 | 0 | 0 | 2022-06-19 04:20:51 | Unknown, Germany | |||||
2311210 | 2311210 | 2022-06-17 | Germany | Unknown | 0 | 0 | 0 | 2022-06-18 04:21:10 | Unknown, Germany | |||||
558714 | 558714 | 2022-06-16 | Germany | Unknown | 0 | 0 | 0 | 2022-06-17 04:20:56 | Unknown, Germany | |||||
3982516 | 3982516 | 2022-06-15 | Germany | Unknown | 0 | 0 | 0 | 2022-06-16 04:20:55 | Unknown, Germany | |||||
946757 | 946757 | 2022-06-14 | Germany | Unknown | 0 | 0 | 0 | 2022-06-15 04:20:54 | Unknown, Germany | |||||
2979165 | 2979165 | 2022-06-13 | Germany | Unknown | 0 | 0 | 0 | 2022-06-14 04:20:52 | Unknown, Germany |
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]);