johns_hopkins_csse_daily_reports

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

946 rows where province_or_state = "Ibaraki" sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: day (date), last_update (date)

province_or_state 1

  • Ibaraki · 946 ✖

country_or_region 1

Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2752901 2752901 2022-12-29 Japan Ibaraki     533596 955 0   36.303588 140.319591 2022-12-30 04:21:04 Ibaraki, Japan
1073907 1073907 2022-12-28 Japan Ibaraki     528794 948 0   36.303588 140.319591 2022-12-29 04:21:01 Ibaraki, Japan
327904 327904 2022-12-27 Japan Ibaraki     523719 944 0   36.303588 140.319591 2022-12-28 04:21:04 Ibaraki, Japan
217977 217977 2022-12-26 Japan Ibaraki     522396 939 0   36.303588 140.319591 2022-12-27 04:21:07 Ibaraki, Japan
3222434 3222434 2022-12-25 Japan Ibaraki     518881 936 0   36.303588 140.319591 2022-12-26 04:21:06 Ibaraki, Japan
1018348 1018348 2022-12-24 Japan Ibaraki     514719 928 0   36.303588 140.319591 2022-12-25 04:21:04 Ibaraki, Japan
690371 690371 2022-12-23 Japan Ibaraki     511148 916 0   36.303588 140.319591 2022-12-24 04:21:02 Ibaraki, Japan
2179581 2179581 2022-12-22 Japan Ibaraki     506939 909 0   36.303588 140.319591 2022-12-23 04:21:04 Ibaraki, Japan
451385 451385 2022-12-21 Japan Ibaraki     502114 904 0   36.303588 140.319591 2022-12-22 04:20:56 Ibaraki, Japan
2951384 2951384 2022-12-20 Japan Ibaraki     497311 900 0   36.303588 140.319591 2022-12-21 04:21:03 Ibaraki, Japan
3173786 3173786 2022-12-19 Japan Ibaraki     496093 893 0   36.303588 140.319591 2022-12-20 04:21:04 Ibaraki, Japan
1628303 1628303 2022-12-18 Japan Ibaraki     493013 890 0   36.303588 140.319591 2022-12-19 04:21:03 Ibaraki, Japan
503682 503682 2022-12-17 Japan Ibaraki     488936 882 0   36.303588 140.319591 2022-12-18 04:21:03 Ibaraki, Japan
3324254 3324254 2022-12-16 Japan Ibaraki     485201 872 0   36.303588 140.319591 2022-12-17 04:21:04 Ibaraki, Japan
542766 542766 2022-12-15 Japan Ibaraki     481331 864 0   36.303588 140.319591 2022-12-16 04:21:01 Ibaraki, Japan
348294 348294 2022-12-14 Japan Ibaraki     476800 858 0   36.303588 140.319591 2022-12-15 04:20:58 Ibaraki, Japan
307882 307882 2022-12-13 Japan Ibaraki     472100 855 0   36.303588 140.319591 2022-12-14 04:21:04 Ibaraki, Japan
1148943 1148943 2022-12-12 Japan Ibaraki     470978 850 0   36.303588 140.319591 2022-12-13 04:21:01 Ibaraki, Japan
868797 868797 2022-12-11 Japan Ibaraki     468280 844 0   36.303588 140.319591 2022-12-12 04:21:01 Ibaraki, Japan
257327 257327 2022-12-10 Japan Ibaraki     464846 837 0   36.303588 140.319591 2022-12-11 04:20:50 Ibaraki, Japan
3936041 3936041 2022-12-09 Japan Ibaraki     461850 829 0   36.303588 140.319591 2022-12-10 04:21:02 Ibaraki, Japan
3377373 3377373 2022-12-08 Japan Ibaraki     458717 822 0   36.303588 140.319591 2022-12-09 04:21:05 Ibaraki, Japan
1984644 1984644 2022-12-07 Japan Ibaraki     455281 817 0   36.303588 140.319591 2022-12-08 04:21:07 Ibaraki, Japan
3714167 3714167 2022-12-06 Japan Ibaraki     451681 813 0   36.303588 140.319591 2022-12-07 04:20:58 Ibaraki, Japan
2414872 2414872 2022-12-05 Japan Ibaraki     450793 807 0   36.303588 140.319591 2022-12-06 04:21:03 Ibaraki, Japan
718480 718480 2022-12-04 Japan Ibaraki     448697 805 0   36.303588 140.319591 2022-12-05 04:20:58 Ibaraki, Japan
2816769 2816769 2022-12-03 Japan Ibaraki     445936 800 0   36.303588 140.319591 2022-12-04 04:20:56 Ibaraki, Japan
833625 833625 2022-12-02 Japan Ibaraki     443437 796 0   36.303588 140.319591 2022-12-03 04:21:02 Ibaraki, Japan
2136155 2136155 2022-12-01 Japan Ibaraki     440625 791 0   36.303588 140.319591 2022-12-02 04:21:07 Ibaraki, Japan
1964571 1964571 2022-11-30 Japan Ibaraki     437545 785 0   36.303588 140.319591 2022-12-01 04:21:03 Ibaraki, Japan
2556585 2556585 2022-11-29 Japan Ibaraki     434389 779 0   36.303588 140.319591 2022-11-30 04:21:07 Ibaraki, Japan
1239659 1239659 2022-11-28 Japan Ibaraki     433405 773 0   36.303588 140.319591 2022-11-29 04:21:05 Ibaraki, Japan
3551647 3551647 2022-11-27 Japan Ibaraki     431256 769 0   36.303588 140.319591 2022-11-28 04:21:02 Ibaraki, Japan
2100127 2100127 2022-11-26 Japan Ibaraki     428306 763 0   36.303588 140.319591 2022-11-27 04:21:05 Ibaraki, Japan
487618 487618 2022-11-25 Japan Ibaraki     426313 758 0   36.303588 140.319591 2022-11-26 04:21:11 Ibaraki, Japan
3523447 3523447 2022-11-24 Japan Ibaraki     422782 755 0   36.303588 140.319591 2022-11-25 04:21:06 Ibaraki, Japan
3312230 3312230 2022-11-23 Japan Ibaraki     421588 752 0   36.303588 140.319591 2022-11-24 04:21:09 Ibaraki, Japan
1620271 1620271 2022-11-22 Japan Ibaraki     419101 751 0   36.303588 140.319591 2022-11-23 04:21:06 Ibaraki, Japan
3460159 3460159 2022-11-21 Japan Ibaraki     417423 748 0   36.303588 140.319591 2022-11-22 04:20:47 Ibaraki, Japan
1640344 1640344 2022-11-20 Japan Ibaraki     416183 748 0   36.303588 140.319591 2022-11-21 04:21:05 Ibaraki, Japan
2063901 2063901 2022-11-19 Japan Ibaraki     414036 746 0   36.303588 140.319591 2022-11-20 04:21:08 Ibaraki, Japan
1755295 1755295 2022-11-18 Japan Ibaraki     412346 744 0   36.303588 140.319591 2022-11-19 04:21:14 Ibaraki, Japan
3026288 3026288 2022-11-17 Japan Ibaraki     410296 743 0   36.303588 140.319591 2022-11-18 04:21:15 Ibaraki, Japan
2485999 2485999 2022-11-16 Japan Ibaraki     407906 740 0   36.303588 140.319591 2022-11-17 04:21:11 Ibaraki, Japan
292010 292010 2022-11-15 Japan Ibaraki     405927 738 0   36.303588 140.319591 2022-11-16 04:21:09 Ibaraki, Japan
3597040 3597040 2022-11-14 Japan Ibaraki     404389 741 0   36.303588 140.319591 2022-11-15 04:21:16 Ibaraki, Japan
311898 311898 2022-11-13 Japan Ibaraki     403182 741 0   36.303588 140.319591 2022-11-14 04:21:09 Ibaraki, Japan
63059 63059 2022-11-12 Japan Ibaraki     401282 741 0   36.303588 140.319591 2022-11-13 04:21:14 Ibaraki, Japan
2927221 2927221 2022-11-11 Japan Ibaraki     399724 740 0   36.303588 140.319591 2022-11-12 04:20:41 Ibaraki, Japan
2506057 2506057 2022-11-10 Japan Ibaraki     398032 736 0   36.303588 140.319591 2022-11-11 04:21:22 Ibaraki, Japan
2430932 2430932 2022-11-09 Japan Ibaraki     396121 735 0   36.303588 140.319591 2022-11-10 04:21:16 Ibaraki, Japan
479588 479588 2022-11-08 Japan Ibaraki     394143 735 0   36.303588 140.319591 2022-11-09 04:21:22 Ibaraki, Japan
2438738 2438738 2022-11-07 Japan Ibaraki     393222 733 0   36.303588 140.319591 2022-11-08 04:21:21 Ibaraki, Japan
1049836 1049836 2022-11-06 Japan Ibaraki     392266 732 0   36.303588 140.319591 2022-11-07 04:21:26 Ibaraki, Japan
617860 617860 2022-11-05 Japan Ibaraki     390453 732 0   36.303588 140.319591 2022-11-06 04:21:24 Ibaraki, Japan
1022364 1022364 2022-11-04 Japan Ibaraki     389990 729 0   36.303588 140.319591 2022-11-05 04:21:52 Ibaraki, Japan
431355 431355 2022-11-03 Japan Ibaraki     388723 728 0   36.303588 140.319591 2022-11-04 04:22:11 Ibaraki, Japan
849597 849597 2022-11-02 Japan Ibaraki     387344 727 0   36.303588 140.319591 2022-11-03 04:22:05 Ibaraki, Japan
710448 710448 2022-11-01 Japan Ibaraki     385930 725 0   36.303588 140.319591 2022-11-02 04:22:09 Ibaraki, Japan
3284897 3284897 2022-10-31 Japan Ibaraki     385533 725 0   36.303588 140.319591 2022-11-01 04:22:36 Ibaraki, Japan
319930 319930 2022-10-30 Japan Ibaraki     384654 725 0   36.303588 140.319591 2022-10-31 04:21:36 Ibaraki, Japan
912206 912206 2022-10-29 Japan Ibaraki     383728 724 0   36.303588 140.319591 2022-10-30 04:22:14 Ibaraki, Japan
1366475 1366475 2022-10-28 Japan Ibaraki     382913 722 0   36.303588 140.319591 2022-10-29 04:21:13 Ibaraki, Japan
3038330 3038330 2022-10-27 Japan Ibaraki     382150 722 0   36.303588 140.319591 2022-10-28 04:22:31 Ibaraki, Japan
538750 538750 2022-10-26 Japan Ibaraki     381203 719 0   36.303588 140.319591 2022-10-27 04:22:01 Ibaraki, Japan
1830151 1830151 2022-10-25 Japan Ibaraki     380237 717 0   36.303588 140.319591 2022-10-26 04:22:19 Ibaraki, Japan
794412 794412 2022-10-24 Japan Ibaraki     379981 715 0   36.303588 140.319591 2022-10-25 04:21:53 Ibaraki, Japan
3276867 3276867 2022-10-23 Japan Ibaraki     379427 715 0   36.303588 140.319591 2022-10-24 04:22:29 Ibaraki, Japan
2267905 2267905 2022-10-22 Japan Ibaraki     378750 713 0   36.303588 140.319591 2022-10-23 04:22:46 Ibaraki, Japan
1592205 1592205 2022-10-21 Japan Ibaraki     378113 712 0   36.303588 140.319591 2022-10-22 04:22:53 Ibaraki, Japan
2271921 2271921 2022-10-20 Japan Ibaraki     377466 710 0   36.303588 140.319591 2022-10-21 04:22:23 Ibaraki, Japan
198256 198256 2022-10-19 Japan Ibaraki     376611 709 0   36.303588 140.319591 2022-10-20 04:22:59 Ibaraki, Japan
2756917 2756917 2022-10-18 Japan Ibaraki     375757 708 0   36.303588 140.319591 2022-10-19 04:22:26 Ibaraki, Japan
2024751 2024751 2022-10-17 Japan Ibaraki     375404 706 0   36.303588 140.319591 2022-10-18 04:22:42 Ibaraki, Japan
2159529 2159529 2022-10-16 Japan Ibaraki     374841 706 0   36.303588 140.319591 2022-10-17 04:20:31 Ibaraki, Japan
515726 515726 2022-10-15 Japan Ibaraki     374167 706 0   36.303588 140.319591 2022-10-16 04:22:39 Ibaraki, Japan
2032783 2032783 2022-10-14 Japan Ibaraki     373473 705 0   36.303588 140.319591 2022-10-15 04:22:00 Ibaraki, Japan
3753471 3753471 2022-10-13 Japan Ibaraki     372361 703 0   36.303588 140.319591 2022-10-14 04:22:28 Ibaraki, Japan
3214296 3214296 2022-10-12 Japan Ibaraki     371163 701 0   36.303588 140.319591 2022-10-13 04:22:39 Ibaraki, Japan
3250145 3250145 2022-10-11 Japan Ibaraki     370939 701 0   36.303588 140.319591 2022-10-12 04:22:51 Ibaraki, Japan
2967404 2967404 2022-10-10 Japan Ibaraki     370651 700 0   36.303588 140.319591 2022-10-11 04:23:05 Ibaraki, Japan
3097440 3097440 2022-10-09 Japan Ibaraki     370125 697 0   36.303588 140.319591 2022-10-10 04:22:32 Ibaraki, Japan
4002665 4002665 2022-10-08 Japan Ibaraki     369578 697 0   36.303588 140.319591 2022-10-09 04:21:16 Ibaraki, Japan
396262 396262 2022-10-07 Japan Ibaraki     369052 696 0   36.303588 140.319591 2022-10-08 04:22:56 Ibaraki, Japan
2529379 2529379 2022-10-06 Japan Ibaraki     368312 694 0   36.303588 140.319591 2022-10-07 04:23:08 Ibaraki, Japan
1810773 1810773 2022-10-05 Japan Ibaraki     367456 694 0   36.303588 140.319591 2022-10-06 04:21:22 Ibaraki, Japan
130747 130747 2022-10-04 Japan Ibaraki     366549 694 0   36.303588 140.319591 2022-10-05 04:23:06 Ibaraki, Japan
2685694 2685694 2022-10-03 Japan Ibaraki     366245 691 0   36.303588 140.319591 2022-10-04 04:22:55 Ibaraki, Japan
2259761 2259761 2022-10-02 Japan Ibaraki     365553 691 0   36.303588 140.319591 2022-10-03 04:23:11 Ibaraki, Japan
2995287 2995287 2022-10-01 Japan Ibaraki     364663 690 0   36.303588 140.319591 2022-10-02 04:21:23 Ibaraki, Japan
853613 853613 2022-09-30 Japan Ibaraki     363827 686 0   36.303588 140.319591 2022-10-01 04:23:01 Ibaraki, Japan
2375539 2375539 2022-09-29 Japan Ibaraki     362790 683 0   36.303588 140.319591 2022-09-30 04:23:09 Ibaraki, Japan
1560090 1560090 2022-09-28 Japan Ibaraki     361259 680 0   36.303588 140.319591 2022-09-29 04:22:34 Ibaraki, Japan
3994633 3994633 2022-09-27 Japan Ibaraki     360021 676 0   36.303588 140.319591 2022-09-28 04:23:01 Ibaraki, Japan
2768961 2768961 2022-09-26 Japan Ibaraki     359465 672 0   36.303588 140.319591 2022-09-27 04:23:01 Ibaraki, Japan
1976614 1976614 2022-09-25 Japan Ibaraki     358207 668 0   36.303588 140.319591 2022-09-26 04:20:52 Ibaraki, Japan
2649781 2649781 2022-09-24 Japan Ibaraki     357705 668 0   36.303588 140.319591 2022-09-25 04:23:31 Ibaraki, Japan
384221 384221 2022-09-23 Japan Ibaraki     356516 667 0   36.303588 140.319591 2022-09-24 04:21:40 Ibaraki, Japan
1624287 1624287 2022-09-22 Japan Ibaraki     354839 664 0   36.303588 140.319591 2022-09-23 04:23:13 Ibaraki, Japan
1370491 1370491 2022-09-21 Japan Ibaraki     353031 661 0   36.303588 140.319591 2022-09-22 04:22:56 Ibaraki, Japan

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);