johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
946 rows where 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2016729 | 2016729 | 2022-09-20 | Japan | Kyoto | 467909 | 1019 | 0 | 35.253815 | 135.443341 | 2022-09-21 04:23:22 | Kyoto, Japan | |||
3570602 | 3570602 | 2022-09-19 | Japan | Kyoto | 467479 | 1016 | 0 | 35.253815 | 135.443341 | 2022-09-20 04:22:48 | Kyoto, Japan | |||
419341 | 419341 | 2022-09-18 | Japan | Kyoto | 466577 | 1011 | 0 | 35.253815 | 135.443341 | 2022-09-19 04:21:49 | Kyoto, Japan | |||
3373365 | 3373365 | 2022-09-17 | Japan | Kyoto | 465090 | 1006 | 0 | 35.253815 | 135.443341 | 2022-09-18 04:22:50 | Kyoto, Japan | |||
2355473 | 2355473 | 2022-09-16 | Japan | Kyoto | 463448 | 1001 | 0 | 35.253815 | 135.443341 | 2022-09-17 04:20:19 | Kyoto, Japan | |||
3986630 | 3986630 | 2022-09-15 | Japan | Kyoto | 461869 | 994 | 0 | 35.253815 | 135.443341 | 2022-09-16 04:21:19 | Kyoto, Japan | |||
1889147 | 1889147 | 2022-09-14 | Japan | Kyoto | 459930 | 987 | 0 | 35.253815 | 135.443341 | 2022-09-15 04:21:02 | Kyoto, Japan | |||
372202 | 372202 | 2022-09-13 | Japan | Kyoto | 457355 | 980 | 0 | 35.253815 | 135.443341 | 2022-09-14 04:20:44 | Kyoto, Japan | |||
2394807 | 2394807 | 2022-09-12 | Japan | Kyoto | 455996 | 974 | 0 | 35.253815 | 135.443341 | 2022-09-13 04:20:57 | Kyoto, Japan | |||
3765885 | 3765885 | 2022-09-11 | Japan | Kyoto | 454719 | 969 | 0 | 35.253815 | 135.443341 | 2022-09-12 04:20:58 | Kyoto, Japan | |||
3824460 | 3824460 | 2022-09-10 | Japan | Kyoto | 452775 | 966 | 0 | 35.253815 | 135.443341 | 2022-09-11 04:20:50 | Kyoto, Japan | |||
962917 | 962917 | 2022-09-09 | Japan | Kyoto | 450747 | 961 | 0 | 35.253815 | 135.443341 | 2022-09-10 04:21:10 | Kyoto, Japan | |||
253319 | 253319 | 2022-09-08 | Japan | Kyoto | 448521 | 956 | 0 | 35.253815 | 135.443341 | 2022-09-09 04:21:11 | Kyoto, Japan | |||
3745117 | 3745117 | 2022-09-07 | Japan | Kyoto | 445901 | 951 | 0 | 35.253815 | 135.443341 | 2022-09-08 04:21:02 | Kyoto, Japan | |||
114757 | 114757 | 2022-09-06 | Japan | Kyoto | 442676 | 947 | 0 | 35.253815 | 135.443341 | 2022-09-07 04:20:59 | Kyoto, Japan | |||
2633729 | 2633729 | 2022-09-05 | Japan | Kyoto | 440953 | 943 | 0 | 35.253815 | 135.443341 | 2022-09-06 04:21:02 | Kyoto, Japan | |||
2987293 | 2987293 | 2022-09-04 | Japan | Kyoto | 439294 | 937 | 0 | 35.253815 | 135.443341 | 2022-09-05 04:21:01 | Kyoto, Japan | |||
2712978 | 2712978 | 2022-09-03 | Japan | Kyoto | 436568 | 931 | 0 | 35.253815 | 135.443341 | 2022-09-04 04:21:22 | Kyoto, Japan | |||
1393683 | 1393683 | 2022-09-02 | Japan | Kyoto | 433848 | 924 | 0 | 35.253815 | 135.443341 | 2022-09-03 04:21:04 | Kyoto, Japan | |||
3547512 | 3547512 | 2022-09-01 | Japan | Kyoto | 430958 | 916 | 0 | 35.253815 | 135.443341 | 2022-09-02 04:21:07 | Kyoto, Japan | |||
2343432 | 2343432 | 2022-08-31 | Japan | Kyoto | 427273 | 908 | 0 | 35.253815 | 135.443341 | 2022-09-01 04:21:03 | Kyoto, Japan | |||
3773912 | 3773912 | 2022-08-30 | Japan | Kyoto | 422731 | 899 | 0 | 35.253815 | 135.443341 | 2022-08-31 04:20:57 | Kyoto, Japan | |||
1680508 | 1680508 | 2022-08-29 | Japan | Kyoto | 419904 | 890 | 0 | 35.253815 | 135.443341 | 2022-08-30 04:21:03 | Kyoto, Japan | |||
1876992 | 1876992 | 2022-08-28 | Japan | Kyoto | 417418 | 884 | 0 | 35.253815 | 135.443341 | 2022-08-29 04:21:06 | Kyoto, Japan | |||
2096119 | 2096119 | 2022-08-27 | Japan | Kyoto | 413566 | 876 | 0 | 35.253815 | 135.443341 | 2022-08-28 04:21:02 | Kyoto, Japan | |||
1531934 | 1531934 | 2022-08-26 | Japan | Kyoto | 409856 | 869 | 0 | 35.253815 | 135.443341 | 2022-08-27 04:20:57 | Kyoto, Japan | |||
2828821 | 2828821 | 2022-08-25 | Japan | Kyoto | 405709 | 861 | 0 | 35.253815 | 135.443341 | 2022-08-26 04:21:02 | Kyoto, Japan | |||
2323354 | 2323354 | 2022-08-24 | Japan | Kyoto | 400720 | 854 | 0 | 35.253815 | 135.443341 | 2022-08-25 04:21:13 | Kyoto, Japan | |||
1250763 | 1250763 | 2022-08-23 | Japan | Kyoto | 394954 | 846 | 0 | 35.253815 | 135.443341 | 2022-08-24 04:20:46 | Kyoto, Japan | |||
2852867 | 2852867 | 2022-08-22 | Japan | Kyoto | 391698 | 838 | 0 | 35.253815 | 135.443341 | 2022-08-23 04:20:56 | Kyoto, Japan | |||
2402839 | 2402839 | 2022-08-21 | Japan | Kyoto | 387974 | 832 | 0 | 35.253815 | 135.443341 | 2022-08-22 04:20:38 | Kyoto, Japan | |||
3797917 | 3797917 | 2022-08-20 | Japan | Kyoto | 382984 | 828 | 0 | 35.253815 | 135.443341 | 2022-08-21 04:20:44 | Kyoto, Japan | |||
2363503 | 2363503 | 2022-08-19 | Japan | Kyoto | 377890 | 824 | 0 | 35.253815 | 135.443341 | 2022-08-20 04:21:01 | Kyoto, Japan | |||
1161174 | 1161174 | 2022-08-18 | Japan | Kyoto | 372716 | 819 | 0 | 35.253815 | 135.443341 | 2022-08-19 04:20:54 | Kyoto, Japan | |||
3950498 | 3950498 | 2022-08-17 | Japan | Kyoto | 367729 | 814 | 0 | 35.253815 | 135.443341 | 2022-08-18 04:21:11 | Kyoto, Japan | |||
991000 | 991000 | 2022-08-16 | Japan | Kyoto | 362993 | 811 | 0 | 35.253815 | 135.443341 | 2022-08-17 04:20:59 | Kyoto, Japan | |||
2494039 | 2494039 | 2022-08-15 | Japan | Kyoto | 360394 | 806 | 0 | 35.253815 | 135.443341 | 2022-08-16 04:20:58 | Kyoto, Japan | |||
3647589 | 3647589 | 2022-08-14 | Japan | Kyoto | 357005 | 802 | 0 | 35.253815 | 135.443341 | 2022-08-15 04:20:59 | Kyoto, Japan | |||
1968595 | 1968595 | 2022-08-13 | Japan | Kyoto | 352236 | 797 | 0 | 35.253815 | 135.443341 | 2022-08-14 04:20:55 | Kyoto, Japan | |||
2888404 | 2888404 | 2022-08-12 | Japan | Kyoto | 349396 | 794 | 0 | 35.253815 | 135.443341 | 2022-08-13 04:20:52 | Kyoto, Japan | |||
3908009 | 3908009 | 2022-08-11 | Japan | Kyoto | 343789 | 793 | 0 | 35.253815 | 135.443341 | 2022-08-12 04:20:54 | Kyoto, Japan | |||
1346326 | 1346326 | 2022-08-10 | Japan | Kyoto | 338821 | 789 | 0 | 35.253815 | 135.443341 | 2022-08-11 04:20:49 | Kyoto, Japan | |||
1086081 | 1086081 | 2022-08-09 | Japan | Kyoto | 332343 | 786 | 0 | 35.253815 | 135.443341 | 2022-08-10 04:20:57 | Kyoto, Japan | |||
3543496 | 3543496 | 2022-08-08 | Japan | Kyoto | 329047 | 785 | 0 | 35.253815 | 135.443341 | 2022-08-09 04:20:34 | Kyoto, Japan | |||
1069899 | 1069899 | 2022-08-07 | Japan | Kyoto | 324582 | 783 | 0 | 35.253815 | 135.443341 | 2022-08-08 04:21:08 | Kyoto, Japan | |||
1940487 | 1940487 | 2022-08-06 | Japan | Kyoto | 319928 | 782 | 0 | 35.253815 | 135.443341 | 2022-08-07 04:20:54 | Kyoto, Japan | |||
880286 | 880286 | 2022-08-05 | Japan | Kyoto | 315222 | 780 | 0 | 35.253815 | 135.443341 | 2022-08-06 04:20:56 | Kyoto, Japan | |||
2008697 | 2008697 | 2022-08-04 | Japan | Kyoto | 309170 | 777 | 0 | 35.253815 | 135.443341 | 2022-08-05 04:20:52 | Kyoto, Japan | |||
1098124 | 1098124 | 2022-08-03 | Japan | Kyoto | 303925 | 774 | 0 | 35.253815 | 135.443341 | 2022-08-04 04:20:58 | Kyoto, Japan | |||
1405049 | 1405049 | 2022-08-02 | Japan | Kyoto | 297034 | 771 | 0 | 35.253815 | 135.443341 | 2022-08-03 04:20:59 | Kyoto, Japan | |||
3617087 | 3617087 | 2022-08-01 | Japan | Kyoto | 292681 | 770 | 0 | 35.253815 | 135.443341 | 2022-08-02 04:20:53 | Kyoto, Japan | |||
3871567 | 3871567 | 2022-07-31 | Japan | Kyoto | 288654 | 768 | 0 | 35.253815 | 135.443341 | 2022-08-01 04:21:03 | Kyoto, Japan | |||
674321 | 674321 | 2022-07-30 | Japan | Kyoto | 283610 | 768 | 0 | 35.253815 | 135.443341 | 2022-07-31 04:21:02 | Kyoto, Japan | |||
1783520 | 1783520 | 2022-07-29 | Japan | Kyoto | 278417 | 768 | 0 | 35.253815 | 135.443341 | 2022-07-30 04:20:42 | Kyoto, Japan | |||
1065883 | 1065883 | 2022-07-28 | Japan | Kyoto | 273349 | 767 | 0 | 35.253815 | 135.443341 | 2022-07-29 04:20:45 | Kyoto, Japan | |||
2335402 | 2335402 | 2022-07-27 | Japan | Kyoto | 268121 | 767 | 0 | 35.253815 | 135.443341 | 2022-07-28 04:20:56 | Kyoto, Japan | |||
1487592 | 1487592 | 2022-07-26 | Japan | Kyoto | 262630 | 766 | 0 | 35.253815 | 135.443341 | 2022-07-27 04:21:04 | Kyoto, Japan | |||
2594038 | 2594038 | 2022-07-25 | Japan | Kyoto | 258669 | 765 | 0 | 35.253815 | 135.443341 | 2022-07-26 04:20:58 | Kyoto, Japan | |||
896153 | 896153 | 2022-07-24 | Japan | Kyoto | 254909 | 764 | 0 | 35.253815 | 135.443341 | 2022-07-25 04:20:51 | Kyoto, Japan | |||
91147 | 91147 | 2022-07-23 | Japan | Kyoto | 250222 | 764 | 0 | 35.253815 | 135.443341 | 2022-07-24 04:20:47 | Kyoto, Japan | |||
900169 | 900169 | 2022-07-22 | Japan | Kyoto | 246021 | 763 | 0 | 35.253815 | 135.443341 | 2022-07-23 04:20:53 | Kyoto, Japan | |||
670305 | 670305 | 2022-07-21 | Japan | Kyoto | 242077 | 762 | 0 | 35.253815 | 135.443341 | 2022-07-22 04:21:15 | Kyoto, Japan | |||
1608268 | 1608268 | 2022-07-20 | Japan | Kyoto | 238451 | 761 | 0 | 35.253815 | 135.443341 | 2022-07-21 04:21:10 | Kyoto, Japan | |||
958901 | 958901 | 2022-07-19 | Japan | Kyoto | 235964 | 760 | 0 | 35.253815 | 135.443341 | 2022-07-20 04:20:59 | Kyoto, Japan | |||
3210288 | 3210288 | 2022-07-18 | Japan | Kyoto | 235045 | 759 | 0 | 35.253815 | 135.443341 | 2022-07-19 04:20:58 | Kyoto, Japan | |||
3405463 | 3405463 | 2022-07-17 | Japan | Kyoto | 233150 | 759 | 0 | 35.253815 | 135.443341 | 2022-07-18 04:20:59 | Kyoto, Japan | |||
2151663 | 2151663 | 2022-07-16 | Japan | Kyoto | 230683 | 758 | 0 | 35.253815 | 135.443341 | 2022-07-17 04:21:15 | Kyoto, Japan | |||
2418896 | 2418896 | 2022-07-15 | Japan | Kyoto | 228469 | 758 | 0 | 35.253815 | 135.443341 | 2022-07-16 04:21:05 | Kyoto, Japan | |||
3428971 | 3428971 | 2022-07-14 | Japan | Kyoto | 226528 | 757 | 0 | 35.253815 | 135.443341 | 2022-07-15 04:20:53 | Kyoto, Japan | |||
3109491 | 3109491 | 2022-07-13 | Japan | Kyoto | 224164 | 757 | 0 | 35.253815 | 135.443341 | 2022-07-14 04:20:57 | Kyoto, Japan | |||
629914 | 629914 | 2022-07-12 | Japan | Kyoto | 222095 | 756 | 0 | 35.253815 | 135.443341 | 2022-07-13 04:20:58 | Kyoto, Japan | |||
1211558 | 1211558 | 2022-07-11 | Japan | Kyoto | 220772 | 756 | 0 | 35.253815 | 135.443341 | 2022-07-12 04:20:51 | Kyoto, Japan | |||
2789040 | 2789040 | 2022-07-10 | Japan | Kyoto | 220155 | 755 | 0 | 35.253815 | 135.443341 | 2022-07-11 04:20:46 | Kyoto, Japan | |||
141993 | 141993 | 2022-07-09 | Japan | Kyoto | 218834 | 755 | 0 | 35.253815 | 135.443341 | 2022-07-10 04:20:54 | Kyoto, Japan | |||
1417093 | 1417093 | 2022-07-08 | Japan | Kyoto | 217639 | 754 | 0 | 35.253815 | 135.443341 | 2022-07-09 04:20:59 | Kyoto, Japan | |||
2741018 | 2741018 | 2022-07-07 | Japan | Kyoto | 216676 | 752 | 0 | 35.253815 | 135.443341 | 2022-07-08 04:20:56 | Kyoto, Japan | |||
1199813 | 1199813 | 2022-07-06 | Japan | Kyoto | 215772 | 751 | 0 | 35.253815 | 135.443341 | 2022-07-07 04:20:55 | Kyoto, Japan | |||
3966556 | 3966556 | 2022-07-05 | Japan | Kyoto | 214762 | 750 | 0 | 35.253815 | 135.443341 | 2022-07-06 04:20:58 | Kyoto, Japan | |||
3078067 | 3078067 | 2022-07-04 | Japan | Kyoto | 214083 | 749 | 0 | 35.253815 | 135.443341 | 2022-07-05 04:20:45 | Kyoto, Japan | |||
1767349 | 1767349 | 2022-07-03 | Japan | Kyoto | 213801 | 748 | 0 | 35.253815 | 135.443341 | 2022-07-04 04:20:54 | Kyoto, Japan | |||
3365335 | 3365335 | 2022-07-02 | Japan | Kyoto | 213321 | 748 | 0 | 35.253815 | 135.443341 | 2022-07-03 04:20:59 | Kyoto, Japan | |||
593664 | 593664 | 2022-07-01 | Japan | Kyoto | 212876 | 747 | 0 | 35.253815 | 135.443341 | 2022-07-02 04:21:16 | Kyoto, Japan | |||
3940065 | 3940065 | 2022-06-30 | Japan | Kyoto | 212428 | 746 | 0 | 35.253815 | 135.443341 | 2022-07-01 04:21:10 | Kyoto, Japan | |||
2490023 | 2490023 | 2022-06-29 | Japan | Kyoto | 211936 | 745 | 0 | 35.253815 | 135.443341 | 2022-06-30 04:21:01 | Kyoto, Japan | |||
2239405 | 2239405 | 2022-06-28 | Japan | Kyoto | 211526 | 743 | 0 | 35.253815 | 135.443341 | 2022-06-29 04:20:59 | Kyoto, Japan | |||
2147647 | 2147647 | 2022-06-27 | Japan | Kyoto | 211231 | 742 | 0 | 35.253815 | 135.443341 | 2022-06-28 04:20:58 | Kyoto, Japan | |||
475448 | 475448 | 2022-06-26 | Japan | Kyoto | 211071 | 741 | 0 | 35.253815 | 135.443341 | 2022-06-27 04:21:00 | Kyoto, Japan | |||
938823 | 938823 | 2022-06-25 | Japan | Kyoto | 210788 | 741 | 0 | 35.253815 | 135.443341 | 2022-06-26 04:21:02 | Kyoto, Japan | |||
3346643 | 3346643 | 2022-06-24 | Japan | Kyoto | 210449 | 740 | 0 | 35.253815 | 135.443341 | 2022-06-25 04:20:57 | Kyoto, Japan | |||
1648384 | 1648384 | 2022-06-23 | Japan | Kyoto | 210147 | 738 | 0 | 35.253815 | 135.443341 | 2022-06-24 04:20:58 | Kyoto, Japan | |||
2187619 | 2187619 | 2022-06-22 | Japan | Kyoto | 209835 | 737 | 0 | 35.253815 | 135.443341 | 2022-06-23 04:20:55 | Kyoto, Japan | |||
166050 | 166050 | 2022-06-21 | Japan | Kyoto | 209489 | 736 | 0 | 35.253815 | 135.443341 | 2022-06-22 04:20:54 | Kyoto, Japan | |||
1763333 | 1763333 | 2022-06-20 | Japan | Kyoto | 209191 | 735 | 0 | 35.253815 | 135.443341 | 2022-06-21 04:20:56 | Kyoto, Japan | |||
3269519 | 3269519 | 2022-06-19 | Japan | Kyoto | 209072 | 734 | 0 | 35.253815 | 135.443341 | 2022-06-20 04:21:01 | Kyoto, Japan | |||
3397431 | 3397431 | 2022-06-18 | Japan | Kyoto | 208805 | 734 | 0 | 35.253815 | 135.443341 | 2022-06-19 04:20:51 | Kyoto, Japan | |||
2311308 | 2311308 | 2022-06-17 | Japan | Kyoto | 208461 | 732 | 0 | 35.253815 | 135.443341 | 2022-06-18 04:21:10 | Kyoto, Japan | |||
558812 | 558812 | 2022-06-16 | Japan | Kyoto | 208146 | 731 | 0 | 35.253815 | 135.443341 | 2022-06-17 04:20:56 | Kyoto, Japan | |||
3982614 | 3982614 | 2022-06-15 | Japan | Kyoto | 207809 | 730 | 0 | 35.253815 | 135.443341 | 2022-06-16 04:20:55 | Kyoto, Japan | |||
946855 | 946855 | 2022-06-14 | Japan | Kyoto | 207400 | 729 | 0 | 35.253815 | 135.443341 | 2022-06-15 04:20:54 | Kyoto, Japan | |||
2979263 | 2979263 | 2022-06-13 | Japan | Kyoto | 207104 | 727 | 0 | 35.253815 | 135.443341 | 2022-06-14 04:20:52 | 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]);