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 = "Berlin" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2632733 | 2632733 | 2020-06-29 | Germany | Berlin | 8176 | 213 | 7272 | 733 | 52.52 | 13.405 | 2020-06-30 04:33:48 | Berlin, Germany | ||
2306296 | 2306296 | 2020-06-28 | Germany | Berlin | 8168 | 213 | 7217 | 745 | 52.52 | 13.405 | 2020-06-29 04:33:44 | Berlin, Germany | ||
2039631 | 2039631 | 2020-06-27 | Germany | Berlin | 8145 | 213 | 7196 | 758 | 52.52 | 13.405 | 2020-06-28 04:34:04 | Berlin, Germany | ||
1135912 | 1135912 | 2020-06-26 | Germany | Berlin | 8096 | 212 | 7125 | 806 | 52.52 | 13.405 | 2020-06-27 04:33:35 | Berlin, Germany | ||
2624899 | 2624899 | 2020-06-25 | Germany | Berlin | 8021 | 212 | 7081 | 802 | 52.52 | 13.405 | 2020-06-26 04:33:43 | Berlin, Germany | ||
2700539 | 2700539 | 2020-06-24 | Germany | Berlin | 7975 | 211 | 7032 | 776 | 52.52 | 13.405 | 2020-06-25 05:26:54 | Berlin, Germany | ||
1522224 | 1522224 | 2020-06-23 | Germany | Berlin | 7916 | 211 | 6961 | 802 | 52.52 | 13.405 | 2020-06-24 04:33:28 | Berlin, Germany | ||
1510418 | 1510418 | 2020-06-22 | Germany | Berlin | 7833 | 211 | 6920 | 784 | 52.52 | 13.405 | 2020-06-23 04:33:22 | Berlin, Germany | ||
3249157 | 3249157 | 2020-06-21 | Germany | Berlin | 7804 | 211 | 6886 | 735 | 52.52 | 13.405 | 2020-06-22 04:33:20 | Berlin, Germany | ||
2437750 | 2437750 | 2020-06-20 | Germany | Berlin | 7733 | 211 | 6874 | 718 | 52.52 | 13.405 | 2020-06-21 04:33:19 | Berlin, Germany | ||
1691328 | 1691328 | 2020-06-19 | Germany | Berlin | 7603 | 211 | 6850 | 671 | 52.52 | 13.405 | 2020-06-20 04:33:19 | Berlin, Germany | ||
3682477 | 3682477 | 2020-06-18 | Germany | Berlin | 7475 | 210 | 6806 | 585 | 52.52 | 13.405 | 2020-06-19 04:33:17 | Berlin, Germany | ||
1195680 | 1195680 | 2020-06-17 | Germany | Berlin | 7402 | 209 | 6778 | 486 | 52.52 | 13.405 | 2020-06-18 04:33:18 | Berlin, Germany | ||
2386443 | 2386443 | 2020-06-16 | Germany | Berlin | 7369 | 208 | 6725 | 467 | 52.52 | 13.405 | 2020-06-17 04:33:21 | Berlin, Germany | ||
287006 | 287006 | 2020-06-15 | Germany | Berlin | 7322 | 208 | 6685 | 475 | 52.52 | 13.405 | 2020-06-16 04:33:09 | Berlin, Germany | ||
1836957 | 1836957 | 2020-06-14 | Germany | Berlin | 7282 | 208 | 6656 | 457 | 52.52 | 13.405 | 2020-06-15 03:33:14 | Berlin, Germany | ||
3061009 | 3061009 | 2020-06-13 | Germany | Berlin | 7252 | 208 | 6627 | 446 | 52.52 | 13.405 | 2020-06-14 03:33:15 | Berlin, Germany | ||
737329 | 737329 | 2020-06-12 | Germany | Berlin | 7165 | 208 | 6582 | 461 | 52.52 | 13.405 | 2020-06-13 03:33:14 | Berlin, Germany | ||
1273299 | 1273299 | 2020-06-11 | Germany | Berlin | 7138 | 208 | 6582 | 374 | 52.52 | 13.405 | 2020-06-12 05:09:52 | Berlin, Germany | ||
2863743 | 2863743 | 2020-06-10 | Germany | Berlin | 7082 | 206 | 6559 | 368 | 52.52 | 13.405 | 2020-06-11 03:33:41 | Berlin, Germany | ||
1210597 | 1210597 | 2020-06-09 | Germany | Berlin | 7042 | 205 | 6531 | 344 | 52.52 | 13.405 | 2020-06-10 04:07:00 | Berlin, Germany | ||
217024 | 217024 | 2020-06-08 | Germany | Berlin | 7016 | 205 | 6495 | 341 | 52.52 | 13.405 | 2020-06-09 03:33:03 | Berlin, Germany | ||
2799821 | 2799821 | 2020-06-07 | Germany | Berlin | 6997 | 205 | 6470 | 340 | 52.52 | 13.405 | 2020-06-08 03:33:22 | Berlin, Germany | ||
573877 | 573877 | 2020-06-06 | Germany | Berlin | 6964 | 201 | 6455 | 336 | 52.52 | 13.405 | 2020-06-07 03:53:30 | Berlin, Germany | ||
1269574 | 1269574 | 2020-06-05 | Germany | Berlin | 6946 | 200 | 6443 | 319 | 52.52 | 13.405 | 2020-06-06 02:33:00 | Berlin, Germany | ||
1281055 | 1281055 | 2020-06-04 | Germany | Berlin | 6901 | 200 | 6412 | 333 | 52.52 | 13.405 | 2020-06-05 02:33:06 | Berlin, Germany | ||
3866610 | 3866610 | 2020-06-03 | Germany | Berlin | 6874 | 198 | 6388 | 312 | 52.52 | 13.405 | 2020-06-04 02:33:14 | Berlin, Germany | ||
2555653 | 2555653 | 2020-06-02 | Germany | Berlin | 6839 | 198 | 6358 | 317 | 52.52 | 13.405 | 2020-06-03 02:33:13 | Berlin, Germany | ||
805189 | 805189 | 2020-06-01 | Germany | Berlin | 6816 | 198 | 6319 | 321 | 52.52 | 13.405 | 2020-06-02 02:33:08 | Berlin, Germany | ||
1793826 | 1793826 | 2020-05-31 | Germany | Berlin | 6800 | 198 | 6279 | 338 | 52.52 | 13.405 | 2020-06-01 02:32:46 | Berlin, Germany | ||
3638719 | 3638719 | 2020-05-30 | Germany | Berlin | 6767 | 197 | 6259 | 342 | 52.52 | 13.405 | 2020-05-31 02:32:45 | Berlin, Germany | ||
1790260 | 1790260 | 2020-05-29 | Germany | Berlin | 6738 | 196 | 6240 | 329 | 52.52 | 13.405 | 2020-05-30 02:32:48 | Berlin, Germany | ||
2712140 | 2712140 | 2020-05-28 | Germany | Berlin | 6703 | 195 | 6208 | 333 | 52.52 | 13.405 | 2020-05-29 02:32:50 | Berlin, Germany | ||
2548148 | 2548148 | 2020-05-27 | Germany | Berlin | 6673 | 193 | 6175 | 334 | 52.52 | 13.405 | 2020-05-28 02:32:31 | Berlin, Germany | ||
1041111 | 1041111 | 2020-05-26 | Germany | Berlin | 6652 | 191 | 6123 | 356 | 52.52 | 13.405 | 2020-05-27 02:32:31 | Berlin, Germany | ||
1104841 | 1104841 | 2020-05-25 | Germany | Berlin | 6642 | 191 | 6086 | 374 | 52.52 | 13.405 | 2020-05-26 02:32:35 | Berlin, Germany | ||
875521 | 875521 | 2020-05-24 | Germany | Berlin | 6637 | 191 | 6060 | 390 | 52.52 | 13.405 | 2020-05-25 02:32:44 | Berlin, Germany | ||
997712 | 997712 | 2020-05-23 | Germany | Berlin | 6614 | 190 | 6049 | 396 | 52.52 | 13.405 | 2020-05-24 02:32:43 | Berlin, Germany | ||
1864735 | 1864735 | 2020-05-22 | Germany | Berlin | 6585 | 190 | 6018 | 403 | 52.52 | 13.405 | 2020-05-23 02:32:42 | Berlin, Germany | ||
268241 | 268241 | 2020-05-21 | Germany | Berlin | 6555 | 186 | 5987 | 405 | 52.52 | 13.405 | 2020-05-22 02:36:51 | Berlin, Germany | ||
1431824 | 1431824 | 2020-05-20 | Germany | Berlin | 6507 | 186 | 5959 | 407 | 52.52 | 13.405 | 2020-05-21 02:32:48 | Berlin, Germany | ||
2390105 | 2390105 | 2020-05-19 | Germany | Berlin | 6478 | 182 | 5918 | 399 | 52.52 | 13.405 | 2020-05-20 02:32:19 | Berlin, Germany | ||
3260844 | 3260844 | 2020-05-18 | Germany | Berlin | 6458 | 180 | 5880 | 412 | 52.52 | 13.405 | 2020-05-19 02:32:18 | Berlin, Germany | ||
3416238 | 3416238 | 2020-05-17 | Germany | Berlin | 6447 | 182 | 5850 | 422 | 52.52 | 13.405 | 2020-05-18 02:32:21 | Berlin, Germany | ||
1829472 | 1829472 | 2020-05-16 | Germany | Berlin | 6428 | 181 | 5825 | 437 | 52.52 | 13.405 | 2020-05-17 02:32:32 | Berlin, Germany | ||
3276188 | 3276188 | 2020-05-15 | Germany | Berlin | 6397 | 177 | 5787 | 456 | 52.52 | 13.405 | 2020-05-16 02:32:19 | Berlin, Germany | ||
1404362 | 1404362 | 2020-05-14 | Germany | Berlin | 6342 | 173 | 5737 | 479 | 52.52 | 13.405 | 2020-05-15 02:33:02 | Berlin, 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]);