johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
946 rows where country_or_region = "Japan" and province_or_state = "Kyoto" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2533403 | 2533403 | 2022-05-12 | Japan | Kyoto | 189482 | 706 | 0 | 35.253815 | 135.443341 | 2022-05-13 04:20:51 | Kyoto, Japan | |||
3444849 | 3444849 | 2022-05-11 | Japan | Kyoto | 188546 | 706 | 0 | 35.253815 | 135.443341 | 2022-05-12 04:20:54 | Kyoto, Japan | |||
3535466 | 3535466 | 2022-05-10 | Japan | Kyoto | 187485 | 706 | 0 | 35.253815 | 135.443341 | 2022-05-11 04:20:48 | Kyoto, Japan | |||
222001 | 222001 | 2022-05-09 | Japan | Kyoto | 186650 | 706 | 0 | 35.253815 | 135.443341 | 2022-05-10 04:20:50 | Kyoto, Japan | |||
2331386 | 2331386 | 2022-05-08 | Japan | Kyoto | 186104 | 706 | 0 | 35.253815 | 135.443341 | 2022-05-09 04:20:54 | Kyoto, Japan | |||
360348 | 360348 | 2022-05-07 | Japan | Kyoto | 184937 | 706 | 0 | 35.253815 | 135.443341 | 2022-05-08 04:20:49 | Kyoto, Japan | |||
1397699 | 1397699 | 2022-05-06 | Japan | Kyoto | 184053 | 706 | 0 | 35.253815 | 135.443341 | 2022-05-07 04:21:09 | Kyoto, Japan | |||
2598054 | 2598054 | 2022-05-05 | Japan | Kyoto | 183590 | 705 | 0 | 35.253815 | 135.443341 | 2022-05-06 04:21:00 | Kyoto, Japan | |||
3265503 | 3265503 | 2022-05-04 | Japan | Kyoto | 183248 | 705 | 0 | 35.253815 | 135.443341 | 2022-05-05 04:20:55 | Kyoto, Japan | |||
1572142 | 1572142 | 2022-05-03 | Japan | Kyoto | 182628 | 705 | 0 | 35.253815 | 135.443341 | 2022-05-04 04:20:59 | Kyoto, Japan | |||
463402 | 463402 | 2022-05-02 | Japan | Kyoto | 181882 | 703 | 0 | 35.253815 | 135.443341 | 2022-05-03 04:21:00 | Kyoto, Japan | |||
3916041 | 3916041 | 2022-05-01 | Japan | Kyoto | 181503 | 703 | 0 | 35.253815 | 135.443341 | 2022-05-02 04:21:10 | Kyoto, Japan | |||
2840845 | 2840845 | 2022-04-30 | Japan | Kyoto | 180991 | 702 | 0 | 35.253815 | 135.443341 | 2022-05-01 04:20:57 | Kyoto, Japan | |||
1157158 | 1157158 | 2022-04-29 | Japan | Kyoto | 180565 | 699 | 0 | 35.253815 | 135.443341 | 2022-04-30 04:21:05 | Kyoto, Japan | |||
1696340 | 1696340 | 2022-04-28 | Japan | Kyoto | 179772 | 699 | 0 | 35.253815 | 135.443341 | 2022-04-29 04:20:59 | Kyoto, Japan | |||
3851823 | 3851823 | 2022-04-27 | Japan | Kyoto | 178784 | 699 | 0 | 35.253815 | 135.443341 | 2022-04-28 04:20:47 | Kyoto, Japan | |||
1326253 | 1326253 | 2022-04-26 | Japan | Kyoto | 177614 | 699 | 0 | 35.253815 | 135.443341 | 2022-04-27 04:20:52 | Kyoto, Japan | |||
3722207 | 3722207 | 2022-04-25 | Japan | Kyoto | 176987 | 699 | 0 | 35.253815 | 135.443341 | 2022-04-26 04:20:51 | Kyoto, Japan | |||
2028775 | 2028775 | 2022-04-24 | Japan | Kyoto | 176401 | 699 | 0 | 35.253815 | 135.443341 | 2022-04-25 04:20:56 | Kyoto, Japan | |||
746350 | 746350 | 2022-04-23 | Japan | Kyoto | 175560 | 698 | 0 | 35.253815 | 135.443341 | 2022-04-24 04:20:56 | Kyoto, Japan | |||
3436835 | 3436835 | 2022-04-22 | Japan | Kyoto | 174660 | 696 | 0 | 35.253815 | 135.443341 | 2022-04-23 04:20:50 | Kyoto, Japan | |||
2892420 | 2892420 | 2022-04-21 | Japan | Kyoto | 173769 | 692 | 0 | 35.253815 | 135.443341 | 2022-04-22 04:20:45 | Kyoto, Japan | |||
2307292 | 2307292 | 2022-04-20 | Japan | Kyoto | 172820 | 692 | 0 | 35.253815 | 135.443341 | 2022-04-21 04:20:46 | Kyoto, Japan | |||
2251431 | 2251431 | 2022-04-19 | Japan | Kyoto | 171708 | 689 | 0 | 35.253815 | 135.443341 | 2022-04-20 04:20:45 | Kyoto, Japan | |||
1845981 | 1845981 | 2022-04-18 | Japan | Kyoto | 171183 | 688 | 0 | 35.253815 | 135.443341 | 2022-04-19 04:21:00 | Kyoto, Japan | |||
3416925 | 3416925 | 2022-04-17 | Japan | Kyoto | 170745 | 688 | 0 | 35.253815 | 135.443341 | 2022-04-18 04:21:12 | Kyoto, Japan | |||
303874 | 303874 | 2022-04-16 | Japan | Kyoto | 169891 | 688 | 0 | 35.253815 | 135.443341 | 2022-04-17 04:20:59 | Kyoto, Japan | |||
2669819 | 2669819 | 2022-04-15 | Japan | Kyoto | 168974 | 688 | 0 | 35.253815 | 135.443341 | 2022-04-16 04:20:48 | Kyoto, Japan | |||
1223604 | 1223604 | 2022-04-14 | Japan | Kyoto | 168053 | 686 | 0 | 35.253815 | 135.443341 | 2022-04-15 04:20:57 | Kyoto, Japan | |||
2442762 | 2442762 | 2022-04-13 | Japan | Kyoto | 166945 | 685 | 0 | 35.253815 | 135.443341 | 2022-04-13 23:21:06 | Kyoto, Japan | |||
1948519 | 1948519 | 2022-04-12 | Japan | Kyoto | 165774 | 685 | 0 | 35.253815 | 135.443341 | 2022-04-13 04:21:03 | Kyoto, Japan | |||
3206272 | 3206272 | 2022-04-11 | Japan | Kyoto | 165042 | 681 | 0 | 35.253815 | 135.443341 | 2022-04-12 04:20:49 | Kyoto, Japan | |||
1576158 | 1576158 | 2022-04-10 | Japan | Kyoto | 164503 | 680 | 0 | 35.253815 | 135.443341 | 2022-04-11 04:21:02 | Kyoto, Japan | |||
1652400 | 1652400 | 2022-04-09 | Japan | Kyoto | 163594 | 679 | 0 | 35.253815 | 135.443341 | 2022-04-10 04:20:52 | Kyoto, Japan | |||
2115722 | 2115722 | 2022-04-08 | Japan | Kyoto | 162602 | 676 | 0 | 35.253815 | 135.443341 | 2022-04-09 04:20:42 | Kyoto, Japan | |||
3320246 | 3320246 | 2022-04-07 | Japan | Kyoto | 161645 | 676 | 0 | 35.253815 | 135.443341 | 2022-04-08 04:20:48 | Kyoto, Japan | |||
2800782 | 2800782 | 2022-04-06 | Japan | Kyoto | 160526 | 674 | 0 | 35.253815 | 135.443341 | 2022-04-07 04:20:53 | Kyoto, Japan | |||
3867551 | 3867551 | 2022-04-05 | Japan | Kyoto | 159389 | 673 | 0 | 35.253815 | 135.443341 | 2022-04-06 04:20:49 | Kyoto, Japan | |||
2748893 | 2748893 | 2022-04-04 | Japan | Kyoto | 158687 | 671 | 0 | 35.253815 | 135.443341 | 2022-04-05 04:20:48 | Kyoto, Japan | |||
3730239 | 3730239 | 2022-04-03 | Japan | Kyoto | 158112 | 671 | 0 | 35.253815 | 135.443341 | 2022-04-04 04:20:51 | Kyoto, Japan | |||
499674 | 499674 | 2022-04-02 | Japan | Kyoto | 157173 | 671 | 0 | 35.253815 | 135.443341 | 2022-04-03 04:20:48 | Kyoto, Japan | |||
3350659 | 3350659 | 2022-04-01 | Japan | Kyoto | 156210 | 669 | 0 | 35.253815 | 135.443341 | 2022-04-02 04:20:47 | Kyoto, Japan | |||
1539964 | 1539964 | 2022-03-31 | Japan | Kyoto | 155223 | 667 | 0 | 35.253815 | 135.443341 | 2022-04-01 04:20:28 | Kyoto, Japan | |||
2477977 | 2477977 | 2022-03-30 | Japan | Kyoto | 154131 | 660 | 0 | 35.253815 | 135.443341 | 2022-03-31 04:20:56 | Kyoto, Japan | |||
158018 | 158018 | 2022-03-29 | Japan | Kyoto | 152965 | 655 | 0 | 35.253815 | 135.443341 | 2022-03-30 04:20:45 | Kyoto, Japan | |||
1436589 | 1436589 | 2022-03-28 | Japan | Kyoto | 152266 | 650 | 0 | 35.253815 | 135.443341 | 2022-03-29 04:20:46 | Kyoto, Japan | |||
876270 | 876270 | 2022-03-27 | Japan | Kyoto | 151748 | 646 | 0 | 35.253815 | 135.443341 | 2022-03-28 04:20:33 | Kyoto, Japan | |||
2163553 | 2163553 | 2022-03-26 | Japan | Kyoto | 150884 | 641 | 0 | 35.253815 | 135.443341 | 2022-03-27 04:20:47 | Kyoto, Japan | |||
1720489 | 1720489 | 2022-03-25 | Japan | Kyoto | 150045 | 632 | 0 | 35.253815 | 135.443341 | 2022-03-26 04:20:23 | Kyoto, Japan | |||
1468106 | 1468106 | 2022-03-24 | Japan | Kyoto | 149045 | 624 | 0 | 35.253815 | 135.443341 | 2022-03-25 04:20:46 | Kyoto, Japan | |||
3022280 | 3022280 | 2022-03-23 | Japan | Kyoto | 148082 | 618 | 0 | 35.253815 | 135.443341 | 2022-03-24 04:20:43 | Kyoto, Japan | |||
1905202 | 1905202 | 2022-03-22 | Japan | Kyoto | 147434 | 612 | 0 | 35.253815 | 135.443341 | 2022-03-23 04:20:48 | Kyoto, Japan | |||
3238333 | 3238333 | 2022-03-21 | Japan | Kyoto | 147208 | 604 | 0 | 35.253815 | 135.443341 | 2022-03-22 04:20:54 | Kyoto, Japan | |||
24406 | 24406 | 2022-03-20 | Japan | Kyoto | 146789 | 597 | 0 | 35.253815 | 135.443341 | 2022-03-21 04:20:50 | Kyoto, Japan | |||
1656416 | 1656416 | 2022-03-19 | Japan | Kyoto | 146028 | 589 | 0 | 35.253815 | 135.443341 | 2022-03-20 04:20:45 | Kyoto, Japan | |||
335942 | 335942 | 2022-03-18 | Japan | Kyoto | 145189 | 581 | 0 | 35.253815 | 135.443341 | 2022-03-19 04:20:47 | Kyoto, Japan | |||
694395 | 694395 | 2022-03-17 | Japan | Kyoto | 144227 | 571 | 0 | 35.253815 | 135.443341 | 2022-03-18 04:20:55 | Kyoto, Japan | |||
2319338 | 2319338 | 2022-03-16 | Japan | Kyoto | 143154 | 561 | 0 | 35.253815 | 135.443341 | 2022-03-17 04:20:56 | Kyoto, Japan | |||
261538 | 261538 | 2022-03-15 | Japan | Kyoto | 141834 | 551 | 0 | 35.253815 | 135.443341 | 2022-03-16 04:20:50 | Kyoto, Japan | |||
2263897 | 2263897 | 2022-03-14 | Japan | Kyoto | 141040 | 542 | 0 | 35.253815 | 135.443341 | 2022-03-15 04:20:47 | Kyoto, Japan | |||
3627963 | 3627963 | 2022-03-13 | Japan | Kyoto | 140418 | 536 | 0 | 35.253815 | 135.443341 | 2022-03-14 04:20:46 | Kyoto, Japan | |||
950871 | 950871 | 2022-03-12 | Japan | Kyoto | 139287 | 530 | 0 | 35.253815 | 135.443341 | 2022-03-13 04:20:49 | Kyoto, Japan | |||
356332 | 356332 | 2022-03-11 | Japan | Kyoto | 138122 | 524 | 0 | 35.253815 | 135.443341 | 2022-03-12 04:20:50 | Kyoto, Japan | |||
1865484 | 1865484 | 2022-03-10 | Japan | Kyoto | 136964 | 516 | 0 | 35.253815 | 135.443341 | 2022-03-11 04:20:50 | Kyoto, Japan | |||
2140179 | 2140179 | 2022-03-09 | Japan | Kyoto | 135668 | 509 | 0 | 35.253815 | 135.443341 | 2022-03-10 04:20:48 | Kyoto, Japan | |||
919690 | 919690 | 2022-03-08 | Japan | Kyoto | 134182 | 500 | 0 | 35.253815 | 135.443341 | 2022-03-09 04:20:59 | Kyoto, Japan | |||
1547977 | 1547977 | 2022-03-07 | Japan | Kyoto | 133350 | 491 | 0 | 35.253815 | 135.443341 | 2022-03-08 04:20:54 | Kyoto, Japan | |||
2199646 | 2199646 | 2022-03-06 | Japan | Kyoto | 132589 | 483 | 0 | 35.253815 | 135.443341 | 2022-03-07 04:20:47 | Kyoto, Japan | |||
2092103 | 2092103 | 2022-03-05 | Japan | Kyoto | 131281 | 475 | 0 | 35.253815 | 135.443341 | 2022-03-06 04:20:49 | Kyoto, Japan | |||
2665803 | 2665803 | 2022-03-04 | Japan | Kyoto | 130021 | 466 | 0 | 35.253815 | 135.443341 | 2022-03-05 04:21:10 | Kyoto, Japan | |||
1644368 | 1644368 | 2022-03-03 | Japan | Kyoto | 128661 | 457 | 0 | 35.253815 | 135.443341 | 2022-03-04 04:21:09 | Kyoto, Japan | |||
2525371 | 2525371 | 2022-03-02 | Japan | Kyoto | 127068 | 448 | 0 | 35.253815 | 135.443341 | 2022-03-03 04:21:01 | Kyoto, Japan | |||
1992665 | 1992665 | 2022-03-01 | Japan | Kyoto | 125099 | 439 | 0 | 35.253815 | 135.443341 | 2022-03-02 04:21:07 | Kyoto, Japan | |||
942839 | 942839 | 2022-02-28 | Japan | Kyoto | 124095 | 431 | 0 | 35.253815 | 135.443341 | 2022-03-01 04:21:09 | Kyoto, Japan | |||
2733030 | 2733030 | 2022-02-27 | Japan | Kyoto | 123001 | 423 | 0 | 35.253815 | 135.443341 | 2022-02-28 04:21:05 | Kyoto, Japan | |||
3046183 | 3046183 | 2022-02-26 | Japan | Kyoto | 121252 | 415 | 0 | 35.253815 | 135.443341 | 2022-02-27 04:21:04 | Kyoto, Japan | |||
574838 | 574838 | 2022-02-25 | Japan | Kyoto | 119439 | 406 | 0 | 35.253815 | 135.443341 | 2022-02-26 04:21:12 | Kyoto, Japan | |||
1511414 | 1511414 | 2022-02-24 | Japan | Kyoto | 118266 | 398 | 0 | 35.253815 | 135.443341 | 2022-02-25 04:21:11 | Kyoto, Japan | |||
1057855 | 1057855 | 2022-02-23 | Japan | Kyoto | 116540 | 391 | 0 | 35.253815 | 135.443341 | 2022-02-24 04:21:14 | Kyoto, Japan | |||
2446778 | 2446778 | 2022-02-22 | Japan | Kyoto | 114105 | 382 | 0 | 35.253815 | 135.443341 | 2022-02-23 04:21:09 | Kyoto, Japan | |||
3718191 | 3718191 | 2022-02-21 | Japan | Kyoto | 112954 | 375 | 0 | 35.253815 | 135.443341 | 2022-02-22 04:21:01 | Kyoto, Japan | |||
3912025 | 3912025 | 2022-02-20 | Japan | Kyoto | 111568 | 370 | 0 | 35.253815 | 135.443341 | 2022-02-21 04:21:05 | Kyoto, Japan | |||
3875583 | 3875583 | 2022-02-19 | Japan | Kyoto | 109799 | 366 | 0 | 35.253815 | 135.443341 | 2022-02-20 04:21:00 | Kyoto, Japan | |||
3855839 | 3855839 | 2022-02-18 | Japan | Kyoto | 107627 | 358 | 0 | 35.253815 | 135.443341 | 2022-02-19 04:21:11 | Kyoto, Japan | |||
1298058 | 1298058 | 2022-02-17 | Japan | Kyoto | 105574 | 353 | 0 | 35.253815 | 135.443341 | 2022-02-18 04:21:04 | Kyoto, Japan | |||
3820444 | 3820444 | 2022-02-16 | Japan | Kyoto | 102878 | 345 | 0 | 35.253815 | 135.443341 | 2022-02-17 04:20:56 | Kyoto, Japan | |||
3671658 | 3671658 | 2022-02-15 | Japan | Kyoto | 100228 | 338 | 0 | 35.253815 | 135.443341 | 2022-02-16 04:21:10 | Kyoto, Japan | |||
2641759 | 2641759 | 2022-02-14 | Japan | Kyoto | 98887 | 331 | 0 | 35.253815 | 135.443341 | 2022-02-15 04:21:09 | Kyoto, Japan | |||
186076 | 186076 | 2022-02-13 | Japan | Kyoto | 96921 | 331 | 0 | 35.253815 | 135.443341 | 2022-02-14 04:20:51 | Kyoto, Japan | |||
315922 | 315922 | 2022-02-12 | Japan | Kyoto | 95234 | 328 | 0 | 35.253815 | 135.443341 | 2022-02-13 04:21:00 | Kyoto, Japan | |||
233248 | 233248 | 2022-02-11 | Japan | Kyoto | 93420 | 323 | 0 | 35.253815 | 135.443341 | 2022-02-12 04:21:06 | Kyoto, Japan | |||
1464090 | 1464090 | 2022-02-10 | Japan | Kyoto | 90946 | 320 | 0 | 35.253815 | 135.443341 | 2022-02-11 04:21:09 | Kyoto, Japan | |||
3074051 | 3074051 | 2022-02-09 | Japan | Kyoto | 87964 | 317 | 0 | 35.253815 | 135.443341 | 2022-02-10 04:21:14 | Kyoto, Japan | |||
1362358 | 1362358 | 2022-02-08 | Japan | Kyoto | 84968 | 314 | 0 | 35.253815 | 135.443341 | 2022-02-09 04:21:04 | Kyoto, Japan | |||
71096 | 71096 | 2022-02-07 | Japan | Kyoto | 82828 | 311 | 0 | 35.253815 | 135.443341 | 2022-02-08 04:21:15 | Kyoto, Japan | |||
2012712 | 2012712 | 2022-02-06 | Japan | Kyoto | 80569 | 311 | 0 | 35.253815 | 135.443341 | 2022-02-07 04:21:05 | Kyoto, Japan | |||
1294041 | 1294041 | 2022-02-05 | Japan | Kyoto | 77988 | 309 | 0 | 35.253815 | 135.443341 | 2022-02-06 04:21:00 | Kyoto, Japan | |||
2327369 | 2327369 | 2022-02-04 | Japan | Kyoto | 75339 | 307 | 0 | 35.253815 | 135.443341 | 2022-02-05 04:21:05 | Kyoto, Japan | |||
2473960 | 2473960 | 2022-02-03 | Japan | Kyoto | 72461 | 304 | 0 | 35.253815 | 135.443341 | 2022-02-04 04:21:10 | Kyoto, Japan | |||
459385 | 459385 | 2022-02-02 | Japan | Kyoto | 69989 | 303 | 0 | 35.253815 | 135.443341 | 2022-02-03 04:21:21 | Kyoto, 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]);