ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
11,934 rows where state = "Arizona" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1715993 | 1715993 | 2021-09-14 | Greenlee | Arizona | 4011 | 833 | 14 |
1715994 | 1715994 | 2021-09-14 | La Paz | Arizona | 4012 | 2816 | 86 |
1715995 | 1715995 | 2021-09-14 | Maricopa | Arizona | 4013 | 668223 | 11075 |
1715996 | 1715996 | 2021-09-14 | Mohave | Arizona | 4015 | 29757 | 878 |
1715997 | 1715997 | 2021-09-14 | Navajo | Arizona | 4017 | 19053 | 585 |
1715998 | 1715998 | 2021-09-14 | Pima | Arizona | 4019 | 131183 | 2560 |
1715999 | 1715999 | 2021-09-14 | Pinal | Arizona | 4021 | 65790 | 971 |
1716000 | 1716000 | 2021-09-14 | Santa Cruz | Arizona | 4023 | 8643 | 188 |
1716001 | 1716001 | 2021-09-14 | Yavapai | Arizona | 4025 | 24832 | 607 |
1716002 | 1716002 | 2021-09-14 | Yuma | Arizona | 4027 | 40065 | 877 |
1712742 | 1712742 | 2021-09-13 | Apache | Arizona | 4001 | 12793 | 457 |
1712743 | 1712743 | 2021-09-13 | Cochise | Arizona | 4003 | 13591 | 308 |
1712744 | 1712744 | 2021-09-13 | Coconino | Arizona | 4005 | 20514 | 342 |
1712745 | 1712745 | 2021-09-13 | Gila | Arizona | 4007 | 8626 | 250 |
1712746 | 1712746 | 2021-09-13 | Graham | Arizona | 4009 | 6647 | 97 |
1712747 | 1712747 | 2021-09-13 | Greenlee | Arizona | 4011 | 826 | 14 |
1712748 | 1712748 | 2021-09-13 | La Paz | Arizona | 4012 | 2809 | 85 |
1712749 | 1712749 | 2021-09-13 | Maricopa | Arizona | 4013 | 666798 | 11016 |
1712750 | 1712750 | 2021-09-13 | Mohave | Arizona | 4015 | 29655 | 874 |
1712751 | 1712751 | 2021-09-13 | Navajo | Arizona | 4017 | 19020 | 580 |
1712752 | 1712752 | 2021-09-13 | Pima | Arizona | 4019 | 130914 | 2541 |
1712753 | 1712753 | 2021-09-13 | Pinal | Arizona | 4021 | 65274 | 961 |
1712754 | 1712754 | 2021-09-13 | Santa Cruz | Arizona | 4023 | 8626 | 188 |
1712755 | 1712755 | 2021-09-13 | Yavapai | Arizona | 4025 | 24746 | 603 |
1712756 | 1712756 | 2021-09-13 | Yuma | Arizona | 4027 | 40039 | 871 |
1709495 | 1709495 | 2021-09-12 | Apache | Arizona | 4001 | 12780 | 457 |
1709496 | 1709496 | 2021-09-12 | Cochise | Arizona | 4003 | 13563 | 308 |
1709497 | 1709497 | 2021-09-12 | Coconino | Arizona | 4005 | 20463 | 342 |
1709498 | 1709498 | 2021-09-12 | Gila | Arizona | 4007 | 8616 | 250 |
1709499 | 1709499 | 2021-09-12 | Graham | Arizona | 4009 | 6639 | 97 |
1709500 | 1709500 | 2021-09-12 | Greenlee | Arizona | 4011 | 821 | 14 |
1709501 | 1709501 | 2021-09-12 | La Paz | Arizona | 4012 | 2804 | 85 |
1709502 | 1709502 | 2021-09-12 | Maricopa | Arizona | 4013 | 665118 | 11016 |
1709503 | 1709503 | 2021-09-12 | Mohave | Arizona | 4015 | 29552 | 874 |
1709504 | 1709504 | 2021-09-12 | Navajo | Arizona | 4017 | 18992 | 580 |
1709505 | 1709505 | 2021-09-12 | Pima | Arizona | 4019 | 130673 | 2541 |
1709506 | 1709506 | 2021-09-12 | Pinal | Arizona | 4021 | 65273 | 961 |
1709507 | 1709507 | 2021-09-12 | Santa Cruz | Arizona | 4023 | 8621 | 188 |
1709508 | 1709508 | 2021-09-12 | Yavapai | Arizona | 4025 | 24687 | 603 |
1709509 | 1709509 | 2021-09-12 | Yuma | Arizona | 4027 | 39998 | 871 |
1706248 | 1706248 | 2021-09-11 | Apache | Arizona | 4001 | 12760 | 457 |
1706249 | 1706249 | 2021-09-11 | Cochise | Arizona | 4003 | 13504 | 307 |
1706250 | 1706250 | 2021-09-11 | Coconino | Arizona | 4005 | 20398 | 342 |
1706251 | 1706251 | 2021-09-11 | Gila | Arizona | 4007 | 8587 | 250 |
1706252 | 1706252 | 2021-09-11 | Graham | Arizona | 4009 | 6610 | 97 |
1706253 | 1706253 | 2021-09-11 | Greenlee | Arizona | 4011 | 808 | 14 |
1706254 | 1706254 | 2021-09-11 | La Paz | Arizona | 4012 | 2797 | 85 |
1706255 | 1706255 | 2021-09-11 | Maricopa | Arizona | 4013 | 663073 | 11013 |
1706256 | 1706256 | 2021-09-11 | Mohave | Arizona | 4015 | 29546 | 875 |
1706257 | 1706257 | 2021-09-11 | Navajo | Arizona | 4017 | 18964 | 580 |
1706258 | 1706258 | 2021-09-11 | Pima | Arizona | 4019 | 130405 | 2540 |
1706259 | 1706259 | 2021-09-11 | Pinal | Arizona | 4021 | 65227 | 961 |
1706260 | 1706260 | 2021-09-11 | Santa Cruz | Arizona | 4023 | 8614 | 188 |
1706261 | 1706261 | 2021-09-11 | Yavapai | Arizona | 4025 | 24609 | 603 |
1706262 | 1706262 | 2021-09-11 | Yuma | Arizona | 4027 | 39933 | 871 |
1703000 | 1703000 | 2021-09-10 | Apache | Arizona | 4001 | 12743 | 456 |
1703001 | 1703001 | 2021-09-10 | Cochise | Arizona | 4003 | 13457 | 307 |
1703002 | 1703002 | 2021-09-10 | Coconino | Arizona | 4005 | 20316 | 342 |
1703003 | 1703003 | 2021-09-10 | Gila | Arizona | 4007 | 8539 | 250 |
1703004 | 1703004 | 2021-09-10 | Graham | Arizona | 4009 | 6551 | 96 |
1703005 | 1703005 | 2021-09-10 | Greenlee | Arizona | 4011 | 797 | 14 |
1703006 | 1703006 | 2021-09-10 | La Paz | Arizona | 4012 | 2789 | 85 |
1703007 | 1703007 | 2021-09-10 | Maricopa | Arizona | 4013 | 660932 | 10995 |
1703008 | 1703008 | 2021-09-10 | Mohave | Arizona | 4015 | 29402 | 870 |
1703009 | 1703009 | 2021-09-10 | Navajo | Arizona | 4017 | 18925 | 580 |
1703010 | 1703010 | 2021-09-10 | Pima | Arizona | 4019 | 130126 | 2536 |
1703011 | 1703011 | 2021-09-10 | Pinal | Arizona | 4021 | 64980 | 957 |
1703012 | 1703012 | 2021-09-10 | Santa Cruz | Arizona | 4023 | 8595 | 187 |
1703013 | 1703013 | 2021-09-10 | Yavapai | Arizona | 4025 | 24467 | 602 |
1703014 | 1703014 | 2021-09-10 | Yuma | Arizona | 4027 | 39861 | 870 |
1699750 | 1699750 | 2021-09-09 | Apache | Arizona | 4001 | 12720 | 456 |
1699751 | 1699751 | 2021-09-09 | Cochise | Arizona | 4003 | 13415 | 307 |
1699752 | 1699752 | 2021-09-09 | Coconino | Arizona | 4005 | 20259 | 342 |
1699753 | 1699753 | 2021-09-09 | Gila | Arizona | 4007 | 8494 | 250 |
1699754 | 1699754 | 2021-09-09 | Graham | Arizona | 4009 | 6533 | 96 |
1699755 | 1699755 | 2021-09-09 | Greenlee | Arizona | 4011 | 789 | 14 |
1699756 | 1699756 | 2021-09-09 | La Paz | Arizona | 4012 | 2772 | 85 |
1699757 | 1699757 | 2021-09-09 | Maricopa | Arizona | 4013 | 659003 | 10992 |
1699758 | 1699758 | 2021-09-09 | Mohave | Arizona | 4015 | 29297 | 868 |
1699759 | 1699759 | 2021-09-09 | Navajo | Arizona | 4017 | 18901 | 580 |
1699760 | 1699760 | 2021-09-09 | Pima | Arizona | 4019 | 129788 | 2535 |
1699761 | 1699761 | 2021-09-09 | Pinal | Arizona | 4021 | 64759 | 957 |
1699762 | 1699762 | 2021-09-09 | Santa Cruz | Arizona | 4023 | 8579 | 187 |
1699763 | 1699763 | 2021-09-09 | Yavapai | Arizona | 4025 | 24392 | 602 |
1699764 | 1699764 | 2021-09-09 | Yuma | Arizona | 4027 | 39791 | 870 |
1696501 | 1696501 | 2021-09-08 | Apache | Arizona | 4001 | 12688 | 456 |
1696502 | 1696502 | 2021-09-08 | Cochise | Arizona | 4003 | 13369 | 307 |
1696503 | 1696503 | 2021-09-08 | Coconino | Arizona | 4005 | 20221 | 343 |
1696504 | 1696504 | 2021-09-08 | Gila | Arizona | 4007 | 8478 | 250 |
1696505 | 1696505 | 2021-09-08 | Graham | Arizona | 4009 | 6511 | 96 |
1696506 | 1696506 | 2021-09-08 | Greenlee | Arizona | 4011 | 776 | 14 |
1696507 | 1696507 | 2021-09-08 | La Paz | Arizona | 4012 | 2754 | 85 |
1696508 | 1696508 | 2021-09-08 | Maricopa | Arizona | 4013 | 657412 | 10943 |
1696509 | 1696509 | 2021-09-08 | Mohave | Arizona | 4015 | 29199 | 862 |
1696510 | 1696510 | 2021-09-08 | Navajo | Arizona | 4017 | 18857 | 579 |
1696511 | 1696511 | 2021-09-08 | Pima | Arizona | 4019 | 129472 | 2533 |
1696512 | 1696512 | 2021-09-08 | Pinal | Arizona | 4021 | 64611 | 957 |
1696513 | 1696513 | 2021-09-08 | Santa Cruz | Arizona | 4023 | 8572 | 187 |
1696514 | 1696514 | 2021-09-08 | Yavapai | Arizona | 4025 | 24322 | 597 |
1696515 | 1696515 | 2021-09-08 | Yuma | Arizona | 4027 | 39770 | 870 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);