johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
17,011 rows where province_or_state = "Arizona" sorted by country_or_region descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: longitude, combined_key, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
775 | 775 | 2021-12-02 | US | Arizona | Apache | 4001 | 15369 | 512 | 0 | 35.39465006 | -109.4892383 | 2021-12-03 04:23:05 | Apache, Arizona, US | |
776 | 776 | 2021-12-02 | US | Arizona | Cochise | 4003 | 18169 | 392 | 0 | 31.87934684 | -109.7516088 | 2021-12-03 04:23:05 | Cochise, Arizona, US | |
777 | 777 | 2021-12-02 | US | Arizona | Coconino | 4005 | 25463 | 386 | 0 | 35.83883429 | -111.77071780000001 | 2021-12-03 04:23:05 | Coconino, Arizona, US | |
778 | 778 | 2021-12-02 | US | Arizona | Gila | 4007 | 11199 | 279 | 0 | 33.80190085 | -110.8132779 | 2021-12-03 04:23:05 | Gila, Arizona, US | |
779 | 779 | 2021-12-02 | US | Arizona | Graham | 4009 | 8582 | 135 | 0 | 32.93166885 | -109.8882178 | 2021-12-03 04:23:05 | Graham, Arizona, US | |
780 | 780 | 2021-12-02 | US | Arizona | Greenlee | 4011 | 1378 | 22 | 0 | 33.21498827 | -109.2405279 | 2021-12-03 04:23:05 | Greenlee, Arizona, US | |
781 | 781 | 2021-12-02 | US | Arizona | La Paz | 4012 | 3414 | 102 | 0 | 33.72854224 | -113.98100290000001 | 2021-12-03 04:23:05 | La Paz, Arizona, US | |
782 | 782 | 2021-12-02 | US | Arizona | Maricopa | 4013 | 804278 | 12814 | 0 | 33.34835867 | -112.49181540000001 | 2021-12-03 04:23:05 | Maricopa, Arizona, US | |
783 | 783 | 2021-12-02 | US | Arizona | Mohave | 4015 | 36291 | 1047 | 0 | 35.70471703 | -113.7577902 | 2021-12-03 04:23:05 | Mohave, Arizona, US | |
784 | 784 | 2021-12-02 | US | Arizona | Navajo | 4017 | 24732 | 679 | 0 | 35.3997715 | -110.3218983 | 2021-12-03 04:23:05 | Navajo, Arizona, US | |
785 | 785 | 2021-12-02 | US | Arizona | Out of AZ | 80004 | 0 | 0 | 0 | 35.83883429 | 0.0 | 2021-12-03 04:23:05 | Out of AZ, Arizona, US | |
786 | 786 | 2021-12-02 | US | Arizona | Pima | 4019 | 160397 | 2901 | 0 | 32.0971334 | -111.7890033 | 2021-12-03 04:23:05 | Pima, Arizona, US | |
787 | 787 | 2021-12-02 | US | Arizona | Pinal | 4021 | 81996 | 1176 | 0 | 32.90525627 | -111.3449483 | 2021-12-03 04:23:05 | Pinal, Arizona, US | |
788 | 788 | 2021-12-02 | US | Arizona | Santa Cruz | 4023 | 9909 | 196 | 0 | 31.52508998 | -110.8479088 | 2021-12-03 04:23:05 | Santa Cruz, Arizona, US | |
789 | 789 | 2021-12-02 | US | Arizona | Unassigned | 90004 | 0 | 0 | 0 | 35.83883429 | 0.0 | 2021-12-03 04:23:05 | Unassigned, Arizona, US | |
790 | 790 | 2021-12-02 | US | Arizona | Yavapai | 4025 | 32974 | 812 | 0 | 34.59933926 | -112.5538588 | 2021-12-03 04:23:05 | Yavapai, Arizona, US | |
791 | 791 | 2021-12-02 | US | Arizona | Yuma | 4027 | 42804 | 930 | 0 | 32.76895712 | -113.90666740000002 | 2021-12-03 04:23:05 | Yuma, Arizona, US | |
4790 | 4790 | 2021-10-28 | US | Arizona | Apache | 4001 | 14192 | 486 | 0 | 35.39465006 | -109.4892383 | 2021-10-29 04:22:03 | Apache, Arizona, US | |
4791 | 4791 | 2021-10-28 | US | Arizona | Cochise | 4003 | 15728 | 344 | 0 | 31.87934684 | -109.7516088 | 2021-10-29 04:22:03 | Cochise, Arizona, US | |
4792 | 4792 | 2021-10-28 | US | Arizona | Coconino | 4005 | 23091 | 360 | 0 | 35.83883429 | -111.77071780000001 | 2021-10-29 04:22:03 | Coconino, Arizona, US | |
4793 | 4793 | 2021-10-28 | US | Arizona | Gila | 4007 | 9708 | 260 | 0 | 33.80190085 | -110.8132779 | 2021-10-29 04:22:03 | Gila, Arizona, US | |
4794 | 4794 | 2021-10-28 | US | Arizona | Graham | 4009 | 7619 | 118 | 0 | 32.93166885 | -109.8882178 | 2021-10-29 04:22:03 | Graham, Arizona, US | |
4795 | 4795 | 2021-10-28 | US | Arizona | Greenlee | 4011 | 1108 | 16 | 0 | 33.21498827 | -109.2405279 | 2021-10-29 04:22:03 | Greenlee, Arizona, US | |
4796 | 4796 | 2021-10-28 | US | Arizona | La Paz | 4012 | 3178 | 98 | 0 | 33.72854224 | -113.98100290000001 | 2021-10-29 04:22:03 | La Paz, Arizona, US | |
4797 | 4797 | 2021-10-28 | US | Arizona | Maricopa | 4013 | 734868 | 12147 | 0 | 33.34835867 | -112.49181540000001 | 2021-10-29 04:22:03 | Maricopa, Arizona, US | |
4798 | 4798 | 2021-10-28 | US | Arizona | Mohave | 4015 | 33327 | 984 | 0 | 35.70471703 | -113.7577902 | 2021-10-29 04:22:03 | Mohave, Arizona, US | |
4799 | 4799 | 2021-10-28 | US | Arizona | Navajo | 4017 | 21394 | 626 | 0 | 35.3997715 | -110.3218983 | 2021-10-29 04:22:03 | Navajo, Arizona, US | |
4800 | 4800 | 2021-10-28 | US | Arizona | Out of AZ | 80004 | 0 | 0 | 0 | 35.83883429 | 0.0 | 2021-10-29 04:22:03 | Out of AZ, Arizona, US | |
4801 | 4801 | 2021-10-28 | US | Arizona | Pima | 4019 | 143208 | 2733 | 0 | 32.0971334 | -111.7890033 | 2021-10-29 04:22:03 | Pima, Arizona, US | |
4802 | 4802 | 2021-10-28 | US | Arizona | Pinal | 4021 | 73331 | 1075 | 0 | 32.90525627 | -111.3449483 | 2021-10-29 04:22:03 | Pinal, Arizona, US | |
4803 | 4803 | 2021-10-28 | US | Arizona | Santa Cruz | 4023 | 9033 | 189 | 0 | 31.52508998 | -110.8479088 | 2021-10-29 04:22:03 | Santa Cruz, Arizona, US | |
4804 | 4804 | 2021-10-28 | US | Arizona | Unassigned | 90004 | 0 | 0 | 0 | 35.83883429 | 0.0 | 2021-10-29 04:22:03 | Unassigned, Arizona, US | |
4805 | 4805 | 2021-10-28 | US | Arizona | Yavapai | 4025 | 28243 | 689 | 0 | 34.59933926 | -112.5538588 | 2021-10-29 04:22:03 | Yavapai, Arizona, US | |
4806 | 4806 | 2021-10-28 | US | Arizona | Yuma | 4027 | 41498 | 908 | 0 | 32.76895712 | -113.90666740000002 | 2021-10-29 04:22:03 | Yuma, Arizona, US | |
8765 | 8765 | 2020-10-25 | US | Arizona | Apache | 4001 | 3874 | 169 | 0 | 3705 | 35.39465006 | -109.4892383 | 2020-10-26 04:25:02 | Apache, Arizona, US |
8766 | 8766 | 2020-10-25 | US | Arizona | Cochise | 4003 | 2122 | 73 | 0 | 2049 | 31.87934684 | -109.7516088 | 2020-10-26 04:25:02 | Cochise, Arizona, US |
8767 | 8767 | 2020-10-25 | US | Arizona | Coconino | 4005 | 5068 | 147 | 0 | 4921 | 35.83883429 | -111.7707178 | 2020-10-26 04:25:02 | Coconino, Arizona, US |
8768 | 8768 | 2020-10-25 | US | Arizona | Gila | 4007 | 1861 | 70 | 0 | 1791 | 33.80190085 | -110.8132779 | 2020-10-26 04:25:02 | Gila, Arizona, US |
8769 | 8769 | 2020-10-25 | US | Arizona | Graham | 4009 | 1120 | 28 | 0 | 1092 | 32.93166885 | -109.8882178 | 2020-10-26 04:25:02 | Graham, Arizona, US |
8770 | 8770 | 2020-10-25 | US | Arizona | Greenlee | 4011 | 102 | 1 | 0 | 101 | 33.21498827 | -109.2405279 | 2020-10-26 04:25:02 | Greenlee, Arizona, US |
8771 | 8771 | 2020-10-25 | US | Arizona | La Paz | 4012 | 613 | 17 | 0 | 596 | 33.72854224 | -113.9810029 | 2020-10-26 04:25:02 | La Paz, Arizona, US |
8772 | 8772 | 2020-10-25 | US | Arizona | Maricopa | 4013 | 154182 | 3540 | 0 | 150642 | 33.34835867 | -112.4918154 | 2020-10-26 04:25:02 | Maricopa, Arizona, US |
8773 | 8773 | 2020-10-25 | US | Arizona | Mohave | 4015 | 4272 | 230 | 0 | 4042 | 35.70471703 | -113.7577902 | 2020-10-26 04:25:02 | Mohave, Arizona, US |
8774 | 8774 | 2020-10-25 | US | Arizona | Navajo | 4017 | 6310 | 238 | 0 | 6072 | 35.3997715 | -110.3218983 | 2020-10-26 04:25:02 | Navajo, Arizona, US |
8775 | 8775 | 2020-10-25 | US | Arizona | Pima | 4019 | 27484 | 636 | 0 | 26848 | 32.0971334 | -111.7890033 | 2020-10-26 04:25:02 | Pima, Arizona, US |
8776 | 8776 | 2020-10-25 | US | Arizona | Pinal | 4021 | 11700 | 217 | 0 | 11483 | 32.90525627 | -111.3449483 | 2020-10-26 04:25:02 | Pinal, Arizona, US |
8777 | 8777 | 2020-10-25 | US | Arizona | Santa Cruz | 4023 | 2978 | 65 | 0 | 2913 | 31.52508998 | -110.8479088 | 2020-10-26 04:25:02 | Santa Cruz, Arizona, US |
8778 | 8778 | 2020-10-25 | US | Arizona | Unassigned | 90004 | 0 | 1 | 0 | 0 | 35.83883429 | 0.0 | 2020-10-26 04:25:02 | Unassigned, Arizona, US |
8779 | 8779 | 2020-10-25 | US | Arizona | Yavapai | 4025 | 2893 | 88 | 0 | 2805 | 34.59933926 | -112.5538588 | 2020-10-26 04:25:02 | Yavapai, Arizona, US |
8780 | 8780 | 2020-10-25 | US | Arizona | Yuma | 4027 | 13584 | 354 | 0 | 13230 | 32.76895712 | -113.90666740000002 | 2020-10-26 04:25:02 | Yuma, Arizona, US |
12776 | 12776 | 2021-01-26 | US | Arizona | Apache | 4001 | 9283 | 298 | 0 | 8985 | 35.39465006 | -109.4892383 | 2021-01-27 05:23:41 | Apache, Arizona, US |
12777 | 12777 | 2021-01-26 | US | Arizona | Cochise | 4003 | 10248 | 209 | 0 | 10039 | 31.87934684 | -109.7516088 | 2021-01-27 05:23:41 | Cochise, Arizona, US |
12778 | 12778 | 2021-01-26 | US | Arizona | Coconino | 4005 | 14894 | 264 | 0 | 14630 | 35.83883429 | -111.7707178 | 2021-01-27 05:23:41 | Coconino, Arizona, US |
12779 | 12779 | 2021-01-26 | US | Arizona | Gila | 4007 | 5824 | 180 | 0 | 5644 | 33.80190085 | -110.8132779 | 2021-01-27 05:23:41 | Gila, Arizona, US |
12780 | 12780 | 2021-01-26 | US | Arizona | Graham | 4009 | 4832 | 65 | 0 | 4767 | 32.93166885 | -109.8882178 | 2021-01-27 05:23:41 | Graham, Arizona, US |
12781 | 12781 | 2021-01-26 | US | Arizona | Greenlee | 4011 | 513 | 6 | 0 | 507 | 33.21498827 | -109.2405279 | 2021-01-27 05:23:41 | Greenlee, Arizona, US |
12782 | 12782 | 2021-01-26 | US | Arizona | La Paz | 4012 | 2177 | 54 | 0 | 2123 | 33.72854224 | -113.9810029 | 2021-01-27 05:23:41 | La Paz, Arizona, US |
12783 | 12783 | 2021-01-26 | US | Arizona | Maricopa | 4013 | 455830 | 7053 | 0 | 448777 | 33.34835867 | -112.4918154 | 2021-01-27 05:23:41 | Maricopa, Arizona, US |
12784 | 12784 | 2021-01-26 | US | Arizona | Mohave | 4015 | 18528 | 496 | 0 | 18032 | 35.70471703 | -113.7577902 | 2021-01-27 05:23:41 | Mohave, Arizona, US |
12785 | 12785 | 2021-01-26 | US | Arizona | Navajo | 4017 | 14120 | 418 | 0 | 13702 | 35.3997715 | -110.3218983 | 2021-01-27 05:23:41 | Navajo, Arizona, US |
12786 | 12786 | 2021-01-26 | US | Arizona | Out of AZ | 80004 | 0 | 0 | 0 | 0 | 35.83883429 | 0.0 | 2021-01-27 05:23:41 | Out of AZ, Arizona, US |
12787 | 12787 | 2021-01-26 | US | Arizona | Pima | 4019 | 98034 | 1649 | 0 | 96385 | 32.0971334 | -111.7890033 | 2021-01-27 05:23:41 | Pima, Arizona, US |
12788 | 12788 | 2021-01-26 | US | Arizona | Pinal | 4021 | 40533 | 571 | 0 | 39962 | 32.90525627 | -111.3449483 | 2021-01-27 05:23:41 | Pinal, Arizona, US |
12789 | 12789 | 2021-01-26 | US | Arizona | Santa Cruz | 4023 | 7355 | 142 | 0 | 7213 | 31.52508998 | -110.8479088 | 2021-01-27 05:23:41 | Santa Cruz, Arizona, US |
12790 | 12790 | 2021-01-26 | US | Arizona | Unassigned | 90004 | 0 | 0 | 0 | 0 | 35.83883429 | 0.0 | 2021-01-27 05:23:41 | Unassigned, Arizona, US |
12791 | 12791 | 2021-01-26 | US | Arizona | Yavapai | 4025 | 15929 | 362 | 0 | 15567 | 34.59933926 | -112.5538588 | 2021-01-27 05:23:41 | Yavapai, Arizona, US |
12792 | 12792 | 2021-01-26 | US | Arizona | Yuma | 4027 | 34543 | 681 | 0 | 33862 | 32.76895712 | -113.90666740000002 | 2021-01-27 05:23:41 | Yuma, Arizona, US |
16797 | 16797 | 2021-09-18 | US | Arizona | Apache | 4001 | 12890 | 462 | 0 | 35.39465006 | -109.4892383 | 2021-09-19 04:21:34 | Apache, Arizona, US | |
16798 | 16798 | 2021-09-18 | US | Arizona | Cochise | 4003 | 13830 | 313 | 0 | 31.87934684 | -109.7516088 | 2021-09-19 04:21:34 | Cochise, Arizona, US | |
16799 | 16799 | 2021-09-18 | US | Arizona | Coconino | 4005 | 20744 | 345 | 0 | 35.83883429 | -111.77071780000001 | 2021-09-19 04:21:34 | Coconino, Arizona, US | |
16800 | 16800 | 2021-09-18 | US | Arizona | Gila | 4007 | 8780 | 251 | 0 | 33.80190085 | -110.8132779 | 2021-09-19 04:21:34 | Gila, Arizona, US | |
16801 | 16801 | 2021-09-18 | US | Arizona | Graham | 4009 | 6795 | 97 | 0 | 32.93166885 | -109.8882178 | 2021-09-19 04:21:34 | Graham, Arizona, US | |
16802 | 16802 | 2021-09-18 | US | Arizona | Greenlee | 4011 | 860 | 15 | 0 | 33.21498827 | -109.2405279 | 2021-09-19 04:21:34 | Greenlee, Arizona, US | |
16803 | 16803 | 2021-09-18 | US | Arizona | La Paz | 4012 | 2900 | 86 | 0 | 33.72854224 | -113.98100290000001 | 2021-09-19 04:21:34 | La Paz, Arizona, US | |
16804 | 16804 | 2021-09-18 | US | Arizona | Maricopa | 4013 | 675252 | 11198 | 0 | 33.34835867 | -112.49181540000001 | 2021-09-19 04:21:34 | Maricopa, Arizona, US | |
16805 | 16805 | 2021-09-18 | US | Arizona | Mohave | 4015 | 30223 | 899 | 0 | 35.70471703 | -113.7577902 | 2021-09-19 04:21:34 | Mohave, Arizona, US | |
16806 | 16806 | 2021-09-18 | US | Arizona | Navajo | 4017 | 19222 | 588 | 0 | 35.3997715 | -110.3218983 | 2021-09-19 04:21:34 | Navajo, Arizona, US | |
16807 | 16807 | 2021-09-18 | US | Arizona | Out of AZ | 80004 | 0 | 0 | 0 | 35.83883429 | 0.0 | 2021-09-19 04:21:34 | Out of AZ, Arizona, US | |
16808 | 16808 | 2021-09-18 | US | Arizona | Pima | 4019 | 132229 | 2570 | 0 | 32.0971334 | -111.7890033 | 2021-09-19 04:21:34 | Pima, Arizona, US | |
16809 | 16809 | 2021-09-18 | US | Arizona | Pinal | 4021 | 66510 | 979 | 0 | 32.90525627 | -111.3449483 | 2021-09-19 04:21:34 | Pinal, Arizona, US | |
16810 | 16810 | 2021-09-18 | US | Arizona | Santa Cruz | 4023 | 8679 | 188 | 0 | 31.52508998 | -110.8479088 | 2021-09-19 04:21:34 | Santa Cruz, Arizona, US | |
16811 | 16811 | 2021-09-18 | US | Arizona | Unassigned | 90004 | 0 | 0 | 0 | 35.83883429 | 0.0 | 2021-09-19 04:21:34 | Unassigned, Arizona, US | |
16812 | 16812 | 2021-09-18 | US | Arizona | Yavapai | 4025 | 25183 | 615 | 0 | 34.59933926 | -112.5538588 | 2021-09-19 04:21:34 | Yavapai, Arizona, US | |
16813 | 16813 | 2021-09-18 | US | Arizona | Yuma | 4027 | 40249 | 881 | 0 | 32.76895712 | -113.90666740000002 | 2021-09-19 04:21:34 | Yuma, Arizona, US | |
20809 | 20809 | 2021-05-28 | US | Arizona | Apache | 4001 | 11403 | 432 | 0 | 35.39465006 | -109.4892383 | 2021-05-29 04:20:41 | Apache, Arizona, US | |
20810 | 20810 | 2021-05-28 | US | Arizona | Cochise | 4003 | 12069 | 288 | 0 | 31.87934684 | -109.7516088 | 2021-05-29 04:20:41 | Cochise, Arizona, US | |
20811 | 20811 | 2021-05-28 | US | Arizona | Coconino | 4005 | 17857 | 330 | 0 | 35.83883429 | -111.7707178 | 2021-05-29 04:20:41 | Coconino, Arizona, US | |
20812 | 20812 | 2021-05-28 | US | Arizona | Gila | 4007 | 6933 | 230 | 0 | 33.80190085 | -110.8132779 | 2021-05-29 04:20:41 | Gila, Arizona, US | |
20813 | 20813 | 2021-05-28 | US | Arizona | Graham | 4009 | 5616 | 82 | 0 | 32.93166885 | -109.8882178 | 2021-05-29 04:20:41 | Graham, Arizona, US | |
20814 | 20814 | 2021-05-28 | US | Arizona | Greenlee | 4011 | 574 | 10 | 0 | 33.21498827 | -109.2405279 | 2021-05-29 04:20:41 | Greenlee, Arizona, US | |
20815 | 20815 | 2021-05-28 | US | Arizona | La Paz | 4012 | 2478 | 80 | 0 | 33.72854224 | -113.9810029 | 2021-05-29 04:20:41 | La Paz, Arizona, US | |
20816 | 20816 | 2021-05-28 | US | Arizona | Maricopa | 4013 | 549729 | 10052 | 0 | 33.34835867 | -112.4918154 | 2021-05-29 04:20:41 | Maricopa, Arizona, US | |
20817 | 20817 | 2021-05-28 | US | Arizona | Mohave | 4015 | 23052 | 735 | 0 | 35.70471703 | -113.7577902 | 2021-05-29 04:20:41 | Mohave, Arizona, US | |
20818 | 20818 | 2021-05-28 | US | Arizona | Navajo | 4017 | 16434 | 540 | 0 | 35.3997715 | -110.3218983 | 2021-05-29 04:20:41 | Navajo, Arizona, US | |
20819 | 20819 | 2021-05-28 | US | Arizona | Out of AZ | 80004 | 0 | 0 | 0 | 35.83883429 | 0.0 | 2021-05-29 04:20:41 | Out of AZ, Arizona, US | |
20820 | 20820 | 2021-05-28 | US | Arizona | Pima | 4019 | 116485 | 2412 | 0 | 32.0971334 | -111.7890033 | 2021-05-29 04:20:41 | Pima, Arizona, US | |
20821 | 20821 | 2021-05-28 | US | Arizona | Pinal | 4021 | 52752 | 888 | 0 | 32.90525627 | -111.3449483 | 2021-05-29 04:20:41 | Pinal, Arizona, US | |
20822 | 20822 | 2021-05-28 | US | Arizona | Santa Cruz | 4023 | 8035 | 180 | 0 | 31.52508998 | -110.8479088 | 2021-05-29 04:20:41 | Santa Cruz, Arizona, US | |
20823 | 20823 | 2021-05-28 | US | Arizona | Unassigned | 90004 | 1 | 1 | 0 | 35.83883429 | 0.0 | 2021-05-29 04:20:41 | Unassigned, Arizona, US | |
20824 | 20824 | 2021-05-28 | US | Arizona | Yavapai | 4025 | 19265 | 510 | 0 | 34.59933926 | -112.5538588 | 2021-05-29 04:20:41 | Yavapai, Arizona, US |
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]);