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 |
---|---|---|---|---|---|---|---|
917288 | 917288 | 2021-01-11 | Apache | Arizona | 4001 | 8309 | 259 |
917289 | 917289 | 2021-01-11 | Cochise | Arizona | 4003 | 8969 | 164 |
917290 | 917290 | 2021-01-11 | Coconino | Arizona | 4005 | 12996 | 233 |
917291 | 917291 | 2021-01-11 | Gila | Arizona | 4007 | 5098 | 155 |
917292 | 917292 | 2021-01-11 | Graham | Arizona | 4009 | 4071 | 56 |
917293 | 917293 | 2021-01-11 | Greenlee | Arizona | 4011 | 465 | 4 |
917294 | 917294 | 2021-01-11 | La Paz | Arizona | 4012 | 1880 | 39 |
917295 | 917295 | 2021-01-11 | Maricopa | Arizona | 4013 | 388518 | 5823 |
917296 | 917296 | 2021-01-11 | Mohave | Arizona | 4015 | 15595 | 390 |
917297 | 917297 | 2021-01-11 | Navajo | Arizona | 4017 | 12675 | 372 |
917298 | 917298 | 2021-01-11 | Pima | Arizona | 4019 | 83386 | 1263 |
917299 | 917299 | 2021-01-11 | Pinal | Arizona | 4021 | 33638 | 418 |
917300 | 917300 | 2021-01-11 | Santa Cruz | Arizona | 4023 | 6716 | 118 |
917301 | 917301 | 2021-01-11 | Yavapai | Arizona | 4025 | 13954 | 275 |
917302 | 917302 | 2021-01-11 | Yuma | Arizona | 4027 | 31501 | 578 |
914043 | 914043 | 2021-01-10 | Apache | Arizona | 4001 | 8244 | 259 |
914044 | 914044 | 2021-01-10 | Cochise | Arizona | 4003 | 8856 | 164 |
914045 | 914045 | 2021-01-10 | Coconino | Arizona | 4005 | 12836 | 233 |
914046 | 914046 | 2021-01-10 | Gila | Arizona | 4007 | 5060 | 155 |
914047 | 914047 | 2021-01-10 | Graham | Arizona | 4009 | 4045 | 56 |
914048 | 914048 | 2021-01-10 | Greenlee | Arizona | 4011 | 463 | 4 |
914049 | 914049 | 2021-01-10 | La Paz | Arizona | 4012 | 1860 | 39 |
914050 | 914050 | 2021-01-10 | Maricopa | Arizona | 4013 | 382409 | 5818 |
914051 | 914051 | 2021-01-10 | Mohave | Arizona | 4015 | 15346 | 390 |
914052 | 914052 | 2021-01-10 | Navajo | Arizona | 4017 | 12572 | 372 |
914053 | 914053 | 2021-01-10 | Pima | Arizona | 4019 | 82197 | 1263 |
914054 | 914054 | 2021-01-10 | Pinal | Arizona | 4021 | 33154 | 418 |
914055 | 914055 | 2021-01-10 | Santa Cruz | Arizona | 4023 | 6671 | 117 |
914056 | 914056 | 2021-01-10 | Yavapai | Arizona | 4025 | 13565 | 275 |
914057 | 914057 | 2021-01-10 | Yuma | Arizona | 4027 | 31268 | 578 |
910798 | 910798 | 2021-01-09 | Apache | Arizona | 4001 | 8201 | 259 |
910799 | 910799 | 2021-01-09 | Cochise | Arizona | 4003 | 8737 | 164 |
910800 | 910800 | 2021-01-09 | Coconino | Arizona | 4005 | 12610 | 233 |
910801 | 910801 | 2021-01-09 | Gila | Arizona | 4007 | 5006 | 154 |
910802 | 910802 | 2021-01-09 | Graham | Arizona | 4009 | 4012 | 55 |
910803 | 910803 | 2021-01-09 | Greenlee | Arizona | 4011 | 459 | 4 |
910804 | 910804 | 2021-01-09 | La Paz | Arizona | 4012 | 1821 | 39 |
910805 | 910805 | 2021-01-09 | Maricopa | Arizona | 4013 | 379212 | 5814 |
910806 | 910806 | 2021-01-09 | Mohave | Arizona | 4015 | 15027 | 389 |
910807 | 910807 | 2021-01-09 | Navajo | Arizona | 4017 | 12370 | 372 |
910808 | 910808 | 2021-01-09 | Pima | Arizona | 4019 | 80642 | 1219 |
910809 | 910809 | 2021-01-09 | Pinal | Arizona | 4021 | 32960 | 417 |
910810 | 910810 | 2021-01-09 | Santa Cruz | Arizona | 4023 | 6620 | 116 |
910811 | 910811 | 2021-01-09 | Yavapai | Arizona | 4025 | 13376 | 275 |
910812 | 910812 | 2021-01-09 | Yuma | Arizona | 4027 | 30847 | 573 |
907553 | 907553 | 2021-01-08 | Apache | Arizona | 4001 | 8119 | 259 |
907554 | 907554 | 2021-01-08 | Cochise | Arizona | 4003 | 8533 | 163 |
907555 | 907555 | 2021-01-08 | Coconino | Arizona | 4005 | 12368 | 231 |
907556 | 907556 | 2021-01-08 | Gila | Arizona | 4007 | 4964 | 152 |
907557 | 907557 | 2021-01-08 | Graham | Arizona | 4009 | 3966 | 55 |
907558 | 907558 | 2021-01-08 | Greenlee | Arizona | 4011 | 451 | 4 |
907559 | 907559 | 2021-01-08 | La Paz | Arizona | 4012 | 1788 | 39 |
907560 | 907560 | 2021-01-08 | Maricopa | Arizona | 4013 | 373397 | 5727 |
907561 | 907561 | 2021-01-08 | Mohave | Arizona | 4015 | 14699 | 384 |
907562 | 907562 | 2021-01-08 | Navajo | Arizona | 4017 | 12242 | 372 |
907563 | 907563 | 2021-01-08 | Pima | Arizona | 4019 | 79190 | 1216 |
907564 | 907564 | 2021-01-08 | Pinal | Arizona | 4021 | 32178 | 414 |
907565 | 907565 | 2021-01-08 | Santa Cruz | Arizona | 4023 | 6507 | 115 |
907566 | 907566 | 2021-01-08 | Yavapai | Arizona | 4025 | 13376 | 265 |
907567 | 907567 | 2021-01-08 | Yuma | Arizona | 4027 | 30368 | 574 |
904307 | 904307 | 2021-01-07 | Apache | Arizona | 4001 | 8045 | 255 |
904308 | 904308 | 2021-01-07 | Cochise | Arizona | 4003 | 8502 | 158 |
904309 | 904309 | 2021-01-07 | Coconino | Arizona | 4005 | 12095 | 226 |
904310 | 904310 | 2021-01-07 | Gila | Arizona | 4007 | 4867 | 151 |
904311 | 904311 | 2021-01-07 | Graham | Arizona | 4009 | 3601 | 55 |
904312 | 904312 | 2021-01-07 | Greenlee | Arizona | 4011 | 441 | 4 |
904313 | 904313 | 2021-01-07 | La Paz | Arizona | 4012 | 1719 | 38 |
904314 | 904314 | 2021-01-07 | Maricopa | Arizona | 4013 | 364066 | 5598 |
904315 | 904315 | 2021-01-07 | Mohave | Arizona | 4015 | 14347 | 378 |
904316 | 904316 | 2021-01-07 | Navajo | Arizona | 4017 | 12086 | 368 |
904317 | 904317 | 2021-01-07 | Pima | Arizona | 4019 | 77854 | 1189 |
904318 | 904318 | 2021-01-07 | Pinal | Arizona | 4021 | 31497 | 407 |
904319 | 904319 | 2021-01-07 | Santa Cruz | Arizona | 4023 | 6441 | 113 |
904320 | 904320 | 2021-01-07 | Yavapai | Arizona | 4025 | 13107 | 259 |
904321 | 904321 | 2021-01-07 | Yuma | Arizona | 4027 | 29715 | 565 |
901062 | 901062 | 2021-01-06 | Apache | Arizona | 4001 | 7942 | 252 |
901063 | 901063 | 2021-01-06 | Cochise | Arizona | 4003 | 8148 | 144 |
901064 | 901064 | 2021-01-06 | Coconino | Arizona | 4005 | 11981 | 225 |
901065 | 901065 | 2021-01-06 | Gila | Arizona | 4007 | 4789 | 149 |
901066 | 901066 | 2021-01-06 | Graham | Arizona | 4009 | 3548 | 54 |
901067 | 901067 | 2021-01-06 | Greenlee | Arizona | 4011 | 428 | 4 |
901068 | 901068 | 2021-01-06 | La Paz | Arizona | 4012 | 1686 | 38 |
901069 | 901069 | 2021-01-06 | Maricopa | Arizona | 4013 | 358496 | 5439 |
901070 | 901070 | 2021-01-06 | Mohave | Arizona | 4015 | 14109 | 365 |
901071 | 901071 | 2021-01-06 | Navajo | Arizona | 4017 | 12011 | 364 |
901072 | 901072 | 2021-01-06 | Pima | Arizona | 4019 | 76243 | 1142 |
901073 | 901073 | 2021-01-06 | Pinal | Arizona | 4021 | 30729 | 389 |
901074 | 901074 | 2021-01-06 | Santa Cruz | Arizona | 4023 | 6367 | 110 |
901075 | 901075 | 2021-01-06 | Yavapai | Arizona | 4025 | 12752 | 243 |
901076 | 901076 | 2021-01-06 | Yuma | Arizona | 4027 | 29394 | 549 |
897817 | 897817 | 2021-01-05 | Apache | Arizona | 4001 | 7801 | 250 |
897818 | 897818 | 2021-01-05 | Cochise | Arizona | 4003 | 8038 | 143 |
897819 | 897819 | 2021-01-05 | Coconino | Arizona | 4005 | 11892 | 224 |
897820 | 897820 | 2021-01-05 | Gila | Arizona | 4007 | 4716 | 146 |
897821 | 897821 | 2021-01-05 | Graham | Arizona | 4009 | 3496 | 53 |
897822 | 897822 | 2021-01-05 | Greenlee | Arizona | 4011 | 422 | 4 |
897823 | 897823 | 2021-01-05 | La Paz | Arizona | 4012 | 1635 | 35 |
897824 | 897824 | 2021-01-05 | Maricopa | Arizona | 4013 | 353848 | 5375 |
897825 | 897825 | 2021-01-05 | Mohave | Arizona | 4015 | 13938 | 356 |
897826 | 897826 | 2021-01-05 | Navajo | Arizona | 4017 | 11991 | 358 |
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);