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 = "Bayern" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2632730 | 2632730 | 2020-06-29 | Germany | Bayern | 48344 | 2592 | 45100 | 650 | 48.7904 | 11.4979 | 2020-06-30 04:33:48 | Bayern, Germany | ||
2306293 | 2306293 | 2020-06-28 | Germany | Bayern | 48294 | 2592 | 45100 | 600 | 48.7904 | 11.4979 | 2020-06-29 04:33:44 | Bayern, Germany | ||
2039628 | 2039628 | 2020-06-27 | Germany | Bayern | 48262 | 2591 | 45100 | 568 | 48.7904 | 11.4979 | 2020-06-28 04:34:04 | Bayern, Germany | ||
1135909 | 1135909 | 2020-06-26 | Germany | Bayern | 48202 | 2594 | 45100 | 508 | 48.7904 | 11.4979 | 2020-06-27 04:33:35 | Bayern, Germany | ||
2624896 | 2624896 | 2020-06-25 | Germany | Bayern | 48122 | 2583 | 45000 | 539 | 48.7904 | 11.4979 | 2020-06-26 04:33:43 | Bayern, Germany | ||
2700536 | 2700536 | 2020-06-24 | Germany | Bayern | 47995 | 2578 | 44900 | 517 | 48.7904 | 11.4979 | 2020-06-25 05:26:54 | Bayern, Germany | ||
1522221 | 1522221 | 2020-06-23 | Germany | Bayern | 47894 | 2571 | 44700 | 625 | 48.7904 | 11.4979 | 2020-06-24 04:33:28 | Bayern, Germany | ||
1510415 | 1510415 | 2020-06-22 | Germany | Bayern | 47867 | 2567 | 44700 | 600 | 48.7904 | 11.4979 | 2020-06-23 04:33:22 | Bayern, Germany | ||
3249154 | 3249154 | 2020-06-21 | Germany | Bayern | 47843 | 2565 | 44600 | 677 | 48.7904 | 11.4979 | 2020-06-22 04:33:20 | Bayern, Germany | ||
2437747 | 2437747 | 2020-06-20 | Germany | Bayern | 47827 | 2566 | 44600 | 661 | 48.7904 | 11.4979 | 2020-06-21 04:33:19 | Bayern, Germany | ||
1691325 | 1691325 | 2020-06-19 | Germany | Bayern | 47799 | 2562 | 44500 | 737 | 48.7904 | 11.4979 | 2020-06-20 04:33:19 | Bayern, Germany | ||
3682474 | 3682474 | 2020-06-18 | Germany | Bayern | 47747 | 2556 | 44500 | 691 | 48.7904 | 11.4979 | 2020-06-19 04:33:17 | Bayern, Germany | ||
1195677 | 1195677 | 2020-06-17 | Germany | Bayern | 47710 | 2546 | 44400 | 757 | 48.7904 | 11.4979 | 2020-06-18 04:33:18 | Bayern, Germany | ||
2386440 | 2386440 | 2020-06-16 | Germany | Bayern | 47690 | 2540 | 44300 | 855 | 48.7904 | 11.4979 | 2020-06-17 04:33:21 | Bayern, Germany | ||
287003 | 287003 | 2020-06-15 | Germany | Bayern | 47642 | 2541 | 44300 | 802 | 48.7904 | 11.4979 | 2020-06-16 04:33:09 | Bayern, Germany | ||
1836954 | 1836954 | 2020-06-14 | Germany | Bayern | 47626 | 2541 | 44200 | 888 | 48.7904 | 11.4979 | 2020-06-15 03:33:14 | Bayern, Germany | ||
3061006 | 3061006 | 2020-06-13 | Germany | Bayern | 47612 | 2540 | 44200 | 873 | 48.7904 | 11.4979 | 2020-06-14 03:33:15 | Bayern, Germany | ||
737326 | 737326 | 2020-06-12 | Germany | Bayern | 47574 | 2538 | 44100 | 942 | 48.7904 | 11.4979 | 2020-06-13 03:33:14 | Bayern, Germany | ||
1273296 | 1273296 | 2020-06-11 | Germany | Bayern | 47536 | 2536 | 44000 | 1000 | 48.7904 | 11.4979 | 2020-06-12 05:09:52 | Bayern, Germany | ||
2863740 | 2863740 | 2020-06-10 | Germany | Bayern | 47479 | 2531 | 43900 | 1065 | 48.7904 | 11.4979 | 2020-06-11 03:33:41 | Bayern, Germany | ||
1210594 | 1210594 | 2020-06-09 | Germany | Bayern | 47423 | 2521 | 43800 | 1131 | 48.7904 | 11.4979 | 2020-06-10 04:07:00 | Bayern, Germany | ||
217021 | 217021 | 2020-06-08 | Germany | Bayern | 47371 | 2505 | 43700 | 1197 | 48.7904 | 11.4979 | 2020-06-09 03:33:03 | Bayern, Germany | ||
2799818 | 2799818 | 2020-06-07 | Germany | Bayern | 47334 | 2501 | 43620 | 1268 | 48.7904 | 11.4979 | 2020-06-08 03:33:22 | Bayern, Germany | ||
573874 | 573874 | 2020-06-06 | Germany | Bayern | 47326 | 2489 | 43600 | 1295 | 48.7904 | 11.4979 | 2020-06-07 03:53:30 | Bayern, Germany | ||
1269571 | 1269571 | 2020-06-05 | Germany | Bayern | 47268 | 2481 | 43480 | 1415 | 48.7904 | 11.4979 | 2020-06-06 02:33:00 | Bayern, Germany | ||
1281052 | 1281052 | 2020-06-04 | Germany | Bayern | 47209 | 2479 | 43480 | 1418 | 48.7904 | 11.4979 | 2020-06-05 02:33:06 | Bayern, Germany | ||
3866607 | 3866607 | 2020-06-03 | Germany | Bayern | 47138 | 2466 | 43310 | 1556 | 48.7904 | 11.4979 | 2020-06-04 02:33:14 | Bayern, Germany | ||
2555650 | 2555650 | 2020-06-02 | Germany | Bayern | 47029 | 2456 | 43140 | 1686 | 48.7904 | 11.4979 | 2020-06-03 02:33:13 | Bayern, Germany | ||
805186 | 805186 | 2020-06-01 | Germany | Bayern | 47004 | 2451 | 42920 | 1881 | 48.7904 | 11.4979 | 2020-06-02 02:33:08 | Bayern, Germany | ||
1793824 | 1793824 | 2020-05-31 | Germany | Bayern | 46917 | 2450 | 42920 | 1792 | 48.7904 | 11.4979 | 2020-06-01 02:32:46 | Bayern, Germany | ||
3638717 | 3638717 | 2020-05-30 | Germany | Bayern | 46854 | 2450 | 42820 | 1829 | 48.7904 | 11.4979 | 2020-05-31 02:32:45 | Bayern, Germany | ||
1790258 | 1790258 | 2020-05-29 | Germany | Bayern | 46809 | 2441 | 42660 | 1953 | 48.7904 | 11.4979 | 2020-05-30 02:32:48 | Bayern, Germany | ||
2712138 | 2712138 | 2020-05-28 | Germany | Bayern | 46729 | 2438 | 42480 | 2064 | 48.7904 | 11.4979 | 2020-05-29 02:32:50 | Bayern, Germany | ||
2548146 | 2548146 | 2020-05-27 | Germany | Bayern | 46458 | 2404 | 42310 | 2133 | 48.7904 | 11.4979 | 2020-05-28 02:32:31 | Bayern, Germany | ||
1041109 | 1041109 | 2020-05-26 | Germany | Bayern | 46456 | 2401 | 42100 | 2226 | 48.7904 | 11.4979 | 2020-05-27 02:32:31 | Bayern, Germany | ||
1104839 | 1104839 | 2020-05-25 | Germany | Bayern | 46326 | 2382 | 41850 | 2390 | 48.7904 | 11.4979 | 2020-05-26 02:32:35 | Bayern, Germany | ||
875519 | 875519 | 2020-05-24 | Germany | Bayern | 46206 | 2377 | 41740 | 2374 | 48.7904 | 11.4979 | 2020-05-25 02:32:44 | Bayern, Germany | ||
997710 | 997710 | 2020-05-23 | Germany | Bayern | 46132 | 2367 | 41530 | 2525 | 48.7904 | 11.4979 | 2020-05-24 02:32:43 | Bayern, Germany | ||
1864733 | 1864733 | 2020-05-22 | Germany | Bayern | 46024 | 2358 | 41340 | 2606 | 48.7904 | 11.4979 | 2020-05-23 02:32:42 | Bayern, Germany | ||
268239 | 268239 | 2020-05-21 | Germany | Bayern | 45929 | 2348 | 41060 | 2838 | 48.7904 | 11.4979 | 2020-05-22 02:36:51 | Bayern, Germany | ||
1431822 | 1431822 | 2020-05-20 | Germany | Bayern | 45766 | 2339 | 40750 | 2981 | 48.7904 | 11.4979 | 2020-05-21 02:32:48 | Bayern, Germany | ||
2390103 | 2390103 | 2020-05-19 | Germany | Bayern | 45639 | 2314 | 40400 | 3235 | 48.7904 | 11.4979 | 2020-05-20 02:32:19 | Bayern, Germany | ||
3260842 | 3260842 | 2020-05-18 | Germany | Bayern | 45507 | 2287 | 40260 | 3297 | 48.7904 | 11.4979 | 2020-05-19 02:32:18 | Bayern, Germany | ||
3416236 | 3416236 | 2020-05-17 | Germany | Bayern | 45427 | 2283 | 40060 | 3420 | 48.7904 | 11.4979 | 2020-05-18 02:32:21 | Bayern, Germany | ||
1829470 | 1829470 | 2020-05-16 | Germany | Bayern | 45340 | 2273 | 39880 | 3497 | 48.7904 | 11.4979 | 2020-05-17 02:32:32 | Bayern, Germany | ||
3276186 | 3276186 | 2020-05-15 | Germany | Bayern | 45143 | 2260 | 39510 | 3745 | 48.7904 | 11.4979 | 2020-05-16 02:32:19 | Bayern, Germany | ||
1404360 | 1404360 | 2020-05-14 | Germany | Bayern | 44980 | 2229 | 39140 | 3962 | 48.7904 | 11.4979 | 2020-05-15 02:33:02 | Bayern, 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]);