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)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499671 | 2499671 | 2022-05-13 | Apache | Arizona | 4001 | 22540 | 614 |
2499672 | 2499672 | 2022-05-13 | Cochise | Arizona | 4003 | 31614 | 573 |
2499673 | 2499673 | 2022-05-13 | Coconino | Arizona | 4005 | 44091 | 478 |
2499674 | 2499674 | 2022-05-13 | Gila | Arizona | 4007 | 17398 | 381 |
2499675 | 2499675 | 2022-05-13 | Graham | Arizona | 4009 | 12051 | 177 |
2499676 | 2499676 | 2022-05-13 | Greenlee | Arizona | 4011 | 2226 | 33 |
2499677 | 2499677 | 2022-05-13 | La Paz | Arizona | 4012 | 5227 | 144 |
2499678 | 2499678 | 2022-05-13 | Maricopa | Arizona | 4013 | 1283590 | 17326 |
2499679 | 2499679 | 2022-05-13 | Mohave | Arizona | 4015 | 57631 | 1454 |
2499680 | 2499680 | 2022-05-13 | Navajo | Arizona | 4017 | 38394 | 909 |
2499681 | 2499681 | 2022-05-13 | Pima | Arizona | 4019 | 255688 | 3850 |
2499682 | 2499682 | 2022-05-13 | Pinal | Arizona | 4021 | 132748 | 1666 |
2499683 | 2499683 | 2022-05-13 | Santa Cruz | Arizona | 4023 | 16683 | 232 |
2499684 | 2499684 | 2022-05-13 | Yavapai | Arizona | 4025 | 48293 | 1212 |
2499685 | 2499685 | 2022-05-13 | Yuma | Arizona | 4027 | 62751 | 1181 |
2496413 | 2496413 | 2022-05-12 | Apache | Arizona | 4001 | 22540 | 614 |
2496414 | 2496414 | 2022-05-12 | Cochise | Arizona | 4003 | 31614 | 573 |
2496415 | 2496415 | 2022-05-12 | Coconino | Arizona | 4005 | 44091 | 478 |
2496416 | 2496416 | 2022-05-12 | Gila | Arizona | 4007 | 17398 | 381 |
2496417 | 2496417 | 2022-05-12 | Graham | Arizona | 4009 | 12051 | 177 |
2496418 | 2496418 | 2022-05-12 | Greenlee | Arizona | 4011 | 2226 | 33 |
2496419 | 2496419 | 2022-05-12 | La Paz | Arizona | 4012 | 5227 | 144 |
2496420 | 2496420 | 2022-05-12 | Maricopa | Arizona | 4013 | 1283590 | 17326 |
2496421 | 2496421 | 2022-05-12 | Mohave | Arizona | 4015 | 57631 | 1454 |
2496422 | 2496422 | 2022-05-12 | Navajo | Arizona | 4017 | 38394 | 909 |
2496423 | 2496423 | 2022-05-12 | Pima | Arizona | 4019 | 255688 | 3850 |
2496424 | 2496424 | 2022-05-12 | Pinal | Arizona | 4021 | 132748 | 1666 |
2496425 | 2496425 | 2022-05-12 | Santa Cruz | Arizona | 4023 | 16683 | 232 |
2496426 | 2496426 | 2022-05-12 | Yavapai | Arizona | 4025 | 48293 | 1212 |
2496427 | 2496427 | 2022-05-12 | Yuma | Arizona | 4027 | 62751 | 1181 |
2493155 | 2493155 | 2022-05-11 | Apache | Arizona | 4001 | 22540 | 614 |
2493156 | 2493156 | 2022-05-11 | Cochise | Arizona | 4003 | 31614 | 573 |
2493157 | 2493157 | 2022-05-11 | Coconino | Arizona | 4005 | 44091 | 478 |
2493158 | 2493158 | 2022-05-11 | Gila | Arizona | 4007 | 17398 | 381 |
2493159 | 2493159 | 2022-05-11 | Graham | Arizona | 4009 | 12051 | 177 |
2493160 | 2493160 | 2022-05-11 | Greenlee | Arizona | 4011 | 2226 | 33 |
2493161 | 2493161 | 2022-05-11 | La Paz | Arizona | 4012 | 5227 | 144 |
2493162 | 2493162 | 2022-05-11 | Maricopa | Arizona | 4013 | 1283590 | 17326 |
2493163 | 2493163 | 2022-05-11 | Mohave | Arizona | 4015 | 57631 | 1454 |
2493164 | 2493164 | 2022-05-11 | Navajo | Arizona | 4017 | 38394 | 909 |
2493165 | 2493165 | 2022-05-11 | Pima | Arizona | 4019 | 255688 | 3850 |
2493166 | 2493166 | 2022-05-11 | Pinal | Arizona | 4021 | 132748 | 1666 |
2493167 | 2493167 | 2022-05-11 | Santa Cruz | Arizona | 4023 | 16683 | 232 |
2493168 | 2493168 | 2022-05-11 | Yavapai | Arizona | 4025 | 48293 | 1212 |
2493169 | 2493169 | 2022-05-11 | Yuma | Arizona | 4027 | 62751 | 1181 |
2489897 | 2489897 | 2022-05-10 | Apache | Arizona | 4001 | 22508 | 612 |
2489898 | 2489898 | 2022-05-10 | Cochise | Arizona | 4003 | 31538 | 573 |
2489899 | 2489899 | 2022-05-10 | Coconino | Arizona | 4005 | 43931 | 478 |
2489900 | 2489900 | 2022-05-10 | Gila | Arizona | 4007 | 17341 | 381 |
2489901 | 2489901 | 2022-05-10 | Graham | Arizona | 4009 | 12001 | 177 |
2489902 | 2489902 | 2022-05-10 | Greenlee | Arizona | 4011 | 2218 | 33 |
2489903 | 2489903 | 2022-05-10 | La Paz | Arizona | 4012 | 5211 | 144 |
2489904 | 2489904 | 2022-05-10 | Maricopa | Arizona | 4013 | 1279872 | 17305 |
2489905 | 2489905 | 2022-05-10 | Mohave | Arizona | 4015 | 57505 | 1450 |
2489906 | 2489906 | 2022-05-10 | Navajo | Arizona | 4017 | 38331 | 908 |
2489907 | 2489907 | 2022-05-10 | Pima | Arizona | 4019 | 254912 | 3843 |
2489908 | 2489908 | 2022-05-10 | Pinal | Arizona | 4021 | 132530 | 1665 |
2489909 | 2489909 | 2022-05-10 | Santa Cruz | Arizona | 4023 | 16670 | 232 |
2489910 | 2489910 | 2022-05-10 | Yavapai | Arizona | 4025 | 48151 | 1208 |
2489911 | 2489911 | 2022-05-10 | Yuma | Arizona | 4027 | 62716 | 1180 |
2486640 | 2486640 | 2022-05-09 | Apache | Arizona | 4001 | 22508 | 612 |
2486641 | 2486641 | 2022-05-09 | Cochise | Arizona | 4003 | 31538 | 573 |
2486642 | 2486642 | 2022-05-09 | Coconino | Arizona | 4005 | 43931 | 478 |
2486643 | 2486643 | 2022-05-09 | Gila | Arizona | 4007 | 17341 | 381 |
2486644 | 2486644 | 2022-05-09 | Graham | Arizona | 4009 | 12001 | 177 |
2486645 | 2486645 | 2022-05-09 | Greenlee | Arizona | 4011 | 2218 | 33 |
2486646 | 2486646 | 2022-05-09 | La Paz | Arizona | 4012 | 5211 | 144 |
2486647 | 2486647 | 2022-05-09 | Maricopa | Arizona | 4013 | 1279872 | 17305 |
2486648 | 2486648 | 2022-05-09 | Mohave | Arizona | 4015 | 57505 | 1450 |
2486649 | 2486649 | 2022-05-09 | Navajo | Arizona | 4017 | 38331 | 908 |
2486650 | 2486650 | 2022-05-09 | Pima | Arizona | 4019 | 254912 | 3843 |
2486651 | 2486651 | 2022-05-09 | Pinal | Arizona | 4021 | 132530 | 1665 |
2486652 | 2486652 | 2022-05-09 | Santa Cruz | Arizona | 4023 | 16670 | 232 |
2486653 | 2486653 | 2022-05-09 | Yavapai | Arizona | 4025 | 48151 | 1208 |
2486654 | 2486654 | 2022-05-09 | Yuma | Arizona | 4027 | 62716 | 1180 |
2483382 | 2483382 | 2022-05-08 | Apache | Arizona | 4001 | 22508 | 612 |
2483383 | 2483383 | 2022-05-08 | Cochise | Arizona | 4003 | 31538 | 573 |
2483384 | 2483384 | 2022-05-08 | Coconino | Arizona | 4005 | 43931 | 478 |
2483385 | 2483385 | 2022-05-08 | Gila | Arizona | 4007 | 17341 | 381 |
2483386 | 2483386 | 2022-05-08 | Graham | Arizona | 4009 | 12001 | 177 |
2483387 | 2483387 | 2022-05-08 | Greenlee | Arizona | 4011 | 2218 | 33 |
2483388 | 2483388 | 2022-05-08 | La Paz | Arizona | 4012 | 5211 | 144 |
2483389 | 2483389 | 2022-05-08 | Maricopa | Arizona | 4013 | 1279872 | 17305 |
2483390 | 2483390 | 2022-05-08 | Mohave | Arizona | 4015 | 57505 | 1450 |
2483391 | 2483391 | 2022-05-08 | Navajo | Arizona | 4017 | 38331 | 908 |
2483392 | 2483392 | 2022-05-08 | Pima | Arizona | 4019 | 254912 | 3843 |
2483393 | 2483393 | 2022-05-08 | Pinal | Arizona | 4021 | 132530 | 1665 |
2483394 | 2483394 | 2022-05-08 | Santa Cruz | Arizona | 4023 | 16670 | 232 |
2483395 | 2483395 | 2022-05-08 | Yavapai | Arizona | 4025 | 48151 | 1208 |
2483396 | 2483396 | 2022-05-08 | Yuma | Arizona | 4027 | 62716 | 1180 |
2480124 | 2480124 | 2022-05-07 | Apache | Arizona | 4001 | 22508 | 612 |
2480125 | 2480125 | 2022-05-07 | Cochise | Arizona | 4003 | 31538 | 573 |
2480126 | 2480126 | 2022-05-07 | Coconino | Arizona | 4005 | 43931 | 478 |
2480127 | 2480127 | 2022-05-07 | Gila | Arizona | 4007 | 17341 | 381 |
2480128 | 2480128 | 2022-05-07 | Graham | Arizona | 4009 | 12001 | 177 |
2480129 | 2480129 | 2022-05-07 | Greenlee | Arizona | 4011 | 2218 | 33 |
2480130 | 2480130 | 2022-05-07 | La Paz | Arizona | 4012 | 5211 | 144 |
2480131 | 2480131 | 2022-05-07 | Maricopa | Arizona | 4013 | 1279872 | 17305 |
2480132 | 2480132 | 2022-05-07 | Mohave | Arizona | 4015 | 57505 | 1450 |
2480133 | 2480133 | 2022-05-07 | Navajo | Arizona | 4017 | 38331 | 908 |
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);