johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
43 rows where deaths = 9 and province_or_state = "Shiga" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: active, day (date), last_update (date)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2537431 | 2537431 | 2020-12-01 | Japan | Shiga | 792 | 9 | 698 | 85 | 35.21582700000001 | 136.138064 | 2020-12-02 05:27:41 | Shiga, Japan | ||
1584200 | 1584200 | 2020-11-30 | Japan | Shiga | 782 | 9 | 689 | 84 | 35.21582700000001 | 136.138064 | 2020-12-01 05:26:18 | Shiga, Japan | ||
3566603 | 3566603 | 2020-11-29 | Japan | Shiga | 779 | 9 | 685 | 85 | 35.21582700000001 | 136.138064 | 2020-11-30 05:26:13 | Shiga, Japan | ||
2935268 | 2935268 | 2020-11-28 | Japan | Shiga | 776 | 9 | 680 | 87 | 35.21582700000001 | 136.138064 | 2020-11-29 05:25:55 | Shiga, Japan | ||
392271 | 392271 | 2020-11-27 | Japan | Shiga | 773 | 9 | 665 | 99 | 35.21582700000001 | 136.138064 | 2020-11-28 05:25:50 | Shiga, Japan | ||
923718 | 923718 | 2020-11-26 | Japan | Shiga | 760 | 9 | 656 | 95 | 35.21582700000001 | 136.138064 | 2020-11-27 05:26:53 | Shiga, Japan | ||
1972623 | 1972623 | 2020-11-25 | Japan | Shiga | 756 | 9 | 647 | 100 | 35.21582700000001 | 136.138064 | 2020-11-26 05:27:44 | Shiga, Japan | ||
1350354 | 1350354 | 2020-11-24 | Japan | Shiga | 747 | 9 | 639 | 99 | 35.21582700000001 | 136.138064 | 2020-11-25 05:27:20 | Shiga, Japan | ||
678348 | 678348 | 2020-11-23 | Japan | Shiga | 740 | 9 | 635 | 96 | 35.21582700000001 | 136.138064 | 2020-11-24 05:27:31 | Shiga, Japan | ||
3190024 | 3190024 | 2020-11-22 | Japan | Shiga | 735 | 9 | 629 | 97 | 35.21582700000001 | 136.138064 | 2020-11-23 05:25:26 | Shiga, Japan | ||
3836518 | 3836518 | 2020-11-21 | Japan | Shiga | 730 | 9 | 624 | 97 | 35.21582700000001 | 136.138064 | 2020-11-22 05:25:45 | Shiga, Japan | ||
2701546 | 2701546 | 2020-11-20 | Japan | Shiga | 720 | 9 | 616 | 95 | 35.21582700000001 | 136.138064 | 2020-11-21 05:25:51 | Shiga, Japan | ||
821606 | 821606 | 2020-11-19 | Japan | Shiga | 708 | 9 | 611 | 88 | 35.21582700000001 | 136.138064 | 2020-11-20 05:26:28 | Shiga, Japan | ||
122740 | 122740 | 2020-11-18 | Japan | Shiga | 696 | 9 | 593 | 94 | 35.21582700000001 | 136.138064 | 2020-11-19 05:25:23 | Shiga, Japan | ||
3338628 | 3338628 | 2020-11-17 | Japan | Shiga | 682 | 9 | 578 | 95 | 35.21582700000001 | 136.138064 | 2020-11-18 05:40:31 | Shiga, Japan | ||
3169673 | 3169673 | 2020-11-16 | Japan | Shiga | 671 | 9 | 572 | 90 | 35.21582700000001 | 136.138064 | 2020-11-17 05:25:54 | Shiga, Japan | ||
2880241 | 2880241 | 2020-11-15 | Japan | Shiga | 662 | 9 | 559 | 94 | 35.21582700000001 | 136.138064 | 2020-11-16 05:25:57 | Shiga, Japan | ||
2915219 | 2915219 | 2020-11-14 | Japan | Shiga | 654 | 9 | 558 | 87 | 35.21582700000001 | 136.138064 | 2020-11-15 05:26:53 | Shiga, Japan | ||
2785041 | 2785041 | 2020-11-13 | Japan | Shiga | 646 | 9 | 557 | 80 | 35.21582700000001 | 136.138064 | 2020-11-14 05:25:37 | Shiga, Japan | ||
864806 | 864806 | 2020-11-12 | Japan | Shiga | 646 | 9 | 548 | 89 | 35.21582700000001 | 136.138064 | 2020-11-13 05:25:30 | Shiga, Japan | ||
3440851 | 3440851 | 2020-11-11 | Japan | Shiga | 635 | 9 | 543 | 83 | 35.21582700000001 | 136.138064 | 2020-11-12 05:25:55 | Shiga, Japan | ||
272191 | 272191 | 2020-11-10 | Japan | Shiga | 624 | 9 | 541 | 74 | 35.21582700000001 | 136.138064 | 2020-11-11 05:25:30 | Shiga, Japan | ||
1988668 | 1988668 | 2020-11-09 | Japan | Shiga | 619 | 9 | 538 | 72 | 35.21582700000001 | 136.138064 | 2020-11-10 05:40:07 | Shiga, Japan | ||
1728520 | 1728520 | 2020-11-08 | Japan | Shiga | 601 | 9 | 537 | 55 | 35.21582700000001 | 136.138064 | 2020-11-09 05:25:45 | Shiga, Japan | ||
1543980 | 1543980 | 2020-11-07 | Japan | Shiga | 599 | 9 | 535 | 55 | 35.21582700000001 | 136.138064 | 2020-11-08 05:24:56 | Shiga, Japan | ||
376218 | 376218 | 2020-11-06 | Japan | Shiga | 593 | 9 | 532 | 52 | 35.21582700000001 | 136.138064 | 2020-11-07 05:24:52 | Shiga, Japan | ||
892156 | 892156 | 2020-11-05 | Japan | Shiga | 584 | 9 | 530 | 45 | 35.21582700000001 | 136.138064 | 2020-11-06 05:24:55 | Shiga, Japan | ||
2919218 | 2919218 | 2020-11-04 | Japan | Shiga | 563 | 9 | 529 | 25 | 35.21582700000001 | 136.138064 | 2020-11-05 06:05:03 | Shiga, Japan | ||
2498055 | 2498055 | 2020-11-03 | Japan | Shiga | 560 | 9 | 526 | 25 | 35.21582700000001 | 136.138064 | 2020-11-04 05:25:09 | Shiga, Japan | ||
3304230 | 3304230 | 2020-11-02 | Japan | Shiga | 557 | 9 | 525 | 23 | 35.21582700000001 | 136.138064 | 2020-11-03 06:00:16 | Shiga, Japan | ||
3409479 | 3409479 | 2020-11-01 | Japan | Shiga | 553 | 9 | 523 | 21 | 35.21582700000001 | 136.138064 | 2020-11-02 05:25:04 | Shiga, Japan | ||
2079968 | 2079968 | 2020-10-31 | Japan | Shiga | 552 | 9 | 521 | 22 | 35.21582700000001 | 136.138064 | 2020-11-01 04:36:19 | Shiga, Japan | ||
2243421 | 2243421 | 2020-10-30 | Japan | Shiga | 547 | 9 | 520 | 18 | 35.21582700000001 | 136.138064 | 2020-10-31 04:24:44 | Shiga, Japan | ||
210276 | 210276 | 2020-10-29 | Japan | Shiga | 546 | 9 | 518 | 19 | 35.21582700000001 | 136.138064 | 2020-10-30 04:24:49 | Shiga, Japan | ||
754338 | 754338 | 2020-10-28 | Japan | Shiga | 546 | 9 | 515 | 22 | 35.21582700000001 | 136.138064 | 2020-10-29 04:24:49 | Shiga, Japan | ||
1452623 | 1452623 | 2020-10-27 | Japan | Shiga | 543 | 9 | 512 | 22 | 35.21582700000001 | 136.138064 | 2020-10-28 04:24:39 | Shiga, Japan | ||
3480347 | 3480347 | 2020-10-26 | Japan | Shiga | 539 | 9 | 510 | 20 | 35.21582700000001 | 136.138064 | 2020-10-27 04:24:45 | Shiga, Japan | ||
8368 | 8368 | 2020-10-25 | Japan | Shiga | 538 | 9 | 510 | 19 | 35.21582700000001 | 136.138064 | 2020-10-26 04:25:02 | Shiga, Japan | ||
3651605 | 3651605 | 2020-10-24 | Japan | Shiga | 537 | 9 | 509 | 19 | 35.21582700000001 | 136.138064 | 2020-10-25 04:24:36 | Shiga, Japan | ||
1053860 | 1053860 | 2020-10-23 | Japan | Shiga | 535 | 9 | 507 | 19 | 35.21582700000001 | 136.138064 | 2020-10-24 04:24:46 | Shiga, Japan | ||
1177530 | 1177530 | 2020-10-22 | Japan | Shiga | 533 | 9 | 506 | 18 | 35.21582700000001 | 136.138064 | 2020-10-23 04:24:46 | Shiga, Japan | ||
2191635 | 2191635 | 2020-10-21 | Japan | Shiga | 531 | 9 | 506 | 16 | 35.21582700000001 | 136.138064 | 2020-10-22 04:24:27 | Shiga, Japan | ||
3990646 | 3990646 | 2020-10-20 | Japan | Shiga | 530 | 9 | 506 | 15 | 35.21582700000001 | 136.138064 | 2020-10-21 04:24:14 | Shiga, Japan |
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]);