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 |
---|---|---|---|---|---|---|---|
1053606 | 1053606 | 2021-02-22 | Greenlee | Arizona | 4011 | 552 | 8 |
1053607 | 1053607 | 2021-02-22 | La Paz | Arizona | 4012 | 2379 | 69 |
1053608 | 1053608 | 2021-02-22 | Maricopa | Arizona | 4013 | 506046 | 8833 |
1053609 | 1053609 | 2021-02-22 | Mohave | Arizona | 4015 | 20931 | 625 |
1053610 | 1053610 | 2021-02-22 | Navajo | Arizona | 4017 | 15477 | 478 |
1053611 | 1053611 | 2021-02-22 | Pima | Arizona | 4019 | 108479 | 2149 |
1053612 | 1053612 | 2021-02-22 | Pinal | Arizona | 4021 | 45535 | 742 |
1053613 | 1053613 | 2021-02-22 | Santa Cruz | Arizona | 4023 | 7611 | 166 |
1053614 | 1053614 | 2021-02-22 | Yavapai | Arizona | 4025 | 17348 | 448 |
1053615 | 1053615 | 2021-02-22 | Yuma | Arizona | 4027 | 36310 | 770 |
1050354 | 1050354 | 2021-02-21 | Apache | Arizona | 4001 | 10268 | 365 |
1050355 | 1050355 | 2021-02-21 | Cochise | Arizona | 4003 | 11020 | 262 |
1050356 | 1050356 | 2021-02-21 | Coconino | Arizona | 4005 | 16256 | 307 |
1050357 | 1050357 | 2021-02-21 | Gila | Arizona | 4007 | 6351 | 209 |
1050358 | 1050358 | 2021-02-21 | Graham | Arizona | 4009 | 5261 | 71 |
1050359 | 1050359 | 2021-02-21 | Greenlee | Arizona | 4011 | 552 | 8 |
1050360 | 1050360 | 2021-02-21 | La Paz | Arizona | 4012 | 2379 | 69 |
1050361 | 1050361 | 2021-02-21 | Maricopa | Arizona | 4013 | 504992 | 8835 |
1050362 | 1050362 | 2021-02-21 | Mohave | Arizona | 4015 | 20868 | 625 |
1050363 | 1050363 | 2021-02-21 | Navajo | Arizona | 4017 | 15453 | 478 |
1050364 | 1050364 | 2021-02-21 | Pima | Arizona | 4019 | 108341 | 2149 |
1050365 | 1050365 | 2021-02-21 | Pinal | Arizona | 4021 | 45439 | 742 |
1050366 | 1050366 | 2021-02-21 | Santa Cruz | Arizona | 4023 | 7606 | 166 |
1050367 | 1050367 | 2021-02-21 | Yavapai | Arizona | 4025 | 17175 | 448 |
1050368 | 1050368 | 2021-02-21 | Yuma | Arizona | 4027 | 36286 | 771 |
1047107 | 1047107 | 2021-02-20 | Apache | Arizona | 4001 | 10244 | 365 |
1047108 | 1047108 | 2021-02-20 | Cochise | Arizona | 4003 | 10980 | 260 |
1047109 | 1047109 | 2021-02-20 | Coconino | Arizona | 4005 | 16209 | 306 |
1047110 | 1047110 | 2021-02-20 | Gila | Arizona | 4007 | 6342 | 209 |
1047111 | 1047111 | 2021-02-20 | Graham | Arizona | 4009 | 5251 | 71 |
1047112 | 1047112 | 2021-02-20 | Greenlee | Arizona | 4011 | 551 | 8 |
1047113 | 1047113 | 2021-02-20 | La Paz | Arizona | 4012 | 2379 | 69 |
1047114 | 1047114 | 2021-02-20 | Maricopa | Arizona | 4013 | 504383 | 8816 |
1047115 | 1047115 | 2021-02-20 | Mohave | Arizona | 4015 | 20812 | 625 |
1047116 | 1047116 | 2021-02-20 | Navajo | Arizona | 4017 | 15448 | 478 |
1047117 | 1047117 | 2021-02-20 | Pima | Arizona | 4019 | 108094 | 2146 |
1047118 | 1047118 | 2021-02-20 | Pinal | Arizona | 4021 | 45434 | 742 |
1047119 | 1047119 | 2021-02-20 | Santa Cruz | Arizona | 4023 | 7609 | 167 |
1047120 | 1047120 | 2021-02-20 | Yavapai | Arizona | 4025 | 17175 | 448 |
1047121 | 1047121 | 2021-02-20 | Yuma | Arizona | 4027 | 36252 | 770 |
1043862 | 1043862 | 2021-02-19 | Apache | Arizona | 4001 | 10236 | 365 |
1043863 | 1043863 | 2021-02-19 | Cochise | Arizona | 4003 | 10919 | 260 |
1043864 | 1043864 | 2021-02-19 | Coconino | Arizona | 4005 | 16185 | 306 |
1043865 | 1043865 | 2021-02-19 | Gila | Arizona | 4007 | 6333 | 209 |
1043866 | 1043866 | 2021-02-19 | Graham | Arizona | 4009 | 5244 | 71 |
1043867 | 1043867 | 2021-02-19 | Greenlee | Arizona | 4011 | 549 | 8 |
1043868 | 1043868 | 2021-02-19 | La Paz | Arizona | 4012 | 2378 | 68 |
1043869 | 1043869 | 2021-02-19 | Maricopa | Arizona | 4013 | 503012 | 8783 |
1043870 | 1043870 | 2021-02-19 | Mohave | Arizona | 4015 | 20750 | 624 |
1043871 | 1043871 | 2021-02-19 | Navajo | Arizona | 4017 | 15376 | 478 |
1043872 | 1043872 | 2021-02-19 | Pima | Arizona | 4019 | 107793 | 2144 |
1043873 | 1043873 | 2021-02-19 | Pinal | Arizona | 4021 | 45267 | 741 |
1043874 | 1043874 | 2021-02-19 | Santa Cruz | Arizona | 4023 | 7601 | 166 |
1043875 | 1043875 | 2021-02-19 | Yavapai | Arizona | 4025 | 17175 | 447 |
1043876 | 1043876 | 2021-02-19 | Yuma | Arizona | 4027 | 36219 | 769 |
1040617 | 1040617 | 2021-02-18 | Apache | Arizona | 4001 | 10203 | 360 |
1040618 | 1040618 | 2021-02-18 | Cochise | Arizona | 4003 | 10882 | 258 |
1040619 | 1040619 | 2021-02-18 | Coconino | Arizona | 4005 | 16138 | 305 |
1040620 | 1040620 | 2021-02-18 | Gila | Arizona | 4007 | 6318 | 209 |
1040621 | 1040621 | 2021-02-18 | Graham | Arizona | 4009 | 5239 | 71 |
1040622 | 1040622 | 2021-02-18 | Greenlee | Arizona | 4011 | 548 | 8 |
1040623 | 1040623 | 2021-02-18 | La Paz | Arizona | 4012 | 2376 | 68 |
1040624 | 1040624 | 2021-02-18 | Maricopa | Arizona | 4013 | 501792 | 8694 |
1040625 | 1040625 | 2021-02-18 | Mohave | Arizona | 4015 | 20695 | 618 |
1040626 | 1040626 | 2021-02-18 | Navajo | Arizona | 4017 | 15311 | 477 |
1040627 | 1040627 | 2021-02-18 | Pima | Arizona | 4019 | 107582 | 2119 |
1040628 | 1040628 | 2021-02-18 | Pinal | Arizona | 4021 | 45117 | 731 |
1040629 | 1040629 | 2021-02-18 | Santa Cruz | Arizona | 4023 | 7592 | 166 |
1040630 | 1040630 | 2021-02-18 | Yavapai | Arizona | 4025 | 17175 | 443 |
1040631 | 1040631 | 2021-02-18 | Yuma | Arizona | 4027 | 36190 | 767 |
1037372 | 1037372 | 2021-02-17 | Apache | Arizona | 4001 | 10168 | 352 |
1037373 | 1037373 | 2021-02-17 | Cochise | Arizona | 4003 | 10859 | 253 |
1037374 | 1037374 | 2021-02-17 | Coconino | Arizona | 4005 | 16088 | 302 |
1037375 | 1037375 | 2021-02-17 | Gila | Arizona | 4007 | 6307 | 209 |
1037376 | 1037376 | 2021-02-17 | Graham | Arizona | 4009 | 5232 | 70 |
1037377 | 1037377 | 2021-02-17 | Greenlee | Arizona | 4011 | 548 | 7 |
1037378 | 1037378 | 2021-02-17 | La Paz | Arizona | 4012 | 2364 | 67 |
1037379 | 1037379 | 2021-02-17 | Maricopa | Arizona | 4013 | 500907 | 8580 |
1037380 | 1037380 | 2021-02-17 | Mohave | Arizona | 4015 | 20624 | 605 |
1037381 | 1037381 | 2021-02-17 | Navajo | Arizona | 4017 | 15301 | 475 |
1037382 | 1037382 | 2021-02-17 | Pima | Arizona | 4019 | 107401 | 2082 |
1037383 | 1037383 | 2021-02-17 | Pinal | Arizona | 4021 | 45019 | 714 |
1037384 | 1037384 | 2021-02-17 | Santa Cruz | Arizona | 4023 | 7588 | 166 |
1037385 | 1037385 | 2021-02-17 | Yavapai | Arizona | 4025 | 17175 | 440 |
1037386 | 1037386 | 2021-02-17 | Yuma | Arizona | 4027 | 36160 | 762 |
1034127 | 1034127 | 2021-02-16 | Apache | Arizona | 4001 | 10155 | 350 |
1034128 | 1034128 | 2021-02-16 | Cochise | Arizona | 4003 | 10847 | 252 |
1034129 | 1034129 | 2021-02-16 | Coconino | Arizona | 4005 | 16081 | 302 |
1034130 | 1034130 | 2021-02-16 | Gila | Arizona | 4007 | 6291 | 206 |
1034131 | 1034131 | 2021-02-16 | Graham | Arizona | 4009 | 5228 | 69 |
1034132 | 1034132 | 2021-02-16 | Greenlee | Arizona | 4011 | 546 | 7 |
1034133 | 1034133 | 2021-02-16 | La Paz | Arizona | 4012 | 2360 | 67 |
1034134 | 1034134 | 2021-02-16 | Maricopa | Arizona | 4013 | 499865 | 8505 |
1034135 | 1034135 | 2021-02-16 | Mohave | Arizona | 4015 | 20603 | 602 |
1034136 | 1034136 | 2021-02-16 | Navajo | Arizona | 4017 | 15292 | 474 |
1034137 | 1034137 | 2021-02-16 | Pima | Arizona | 4019 | 107213 | 2075 |
1034138 | 1034138 | 2021-02-16 | Pinal | Arizona | 4021 | 44800 | 709 |
1034139 | 1034139 | 2021-02-16 | Santa Cruz | Arizona | 4023 | 7580 | 165 |
1034140 | 1034140 | 2021-02-16 | Yavapai | Arizona | 4025 | 16956 | 440 |
1034141 | 1034141 | 2021-02-16 | Yuma | Arizona | 4027 | 36127 | 758 |
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);