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 |
---|---|---|---|---|---|---|---|
531283 | 531283 | 2020-09-14 | Apache | Arizona | 4001 | 3386 | 158 |
531284 | 531284 | 2020-09-14 | Cochise | Arizona | 4003 | 1860 | 67 |
531285 | 531285 | 2020-09-14 | Coconino | Arizona | 4005 | 3553 | 132 |
531286 | 531286 | 2020-09-14 | Gila | Arizona | 4007 | 1168 | 51 |
531287 | 531287 | 2020-09-14 | Graham | Arizona | 4009 | 774 | 24 |
531288 | 531288 | 2020-09-14 | Greenlee | Arizona | 4011 | 58 | 2 |
531289 | 531289 | 2020-09-14 | La Paz | Arizona | 4012 | 526 | 15 |
531290 | 531290 | 2020-09-14 | Maricopa | Arizona | 4013 | 137589 | 3154 |
531291 | 531291 | 2020-09-14 | Mohave | Arizona | 4015 | 3792 | 217 |
531292 | 531292 | 2020-09-14 | Navajo | Arizona | 4017 | 5694 | 227 |
531293 | 531293 | 2020-09-14 | Pima | Arizona | 4019 | 22511 | 602 |
531294 | 531294 | 2020-09-14 | Pinal | Arizona | 4021 | 10187 | 195 |
531295 | 531295 | 2020-09-14 | Santa Cruz | Arizona | 4023 | 2786 | 61 |
531296 | 531296 | 2020-09-14 | Yavapai | Arizona | 4025 | 2427 | 80 |
531297 | 531297 | 2020-09-14 | Yuma | Arizona | 4027 | 12415 | 337 |
528046 | 528046 | 2020-09-13 | Apache | Arizona | 4001 | 3386 | 158 |
528047 | 528047 | 2020-09-13 | Cochise | Arizona | 4003 | 1860 | 67 |
528048 | 528048 | 2020-09-13 | Coconino | Arizona | 4005 | 3550 | 132 |
528049 | 528049 | 2020-09-13 | Gila | Arizona | 4007 | 1168 | 51 |
528050 | 528050 | 2020-09-13 | Graham | Arizona | 4009 | 774 | 24 |
528051 | 528051 | 2020-09-13 | Greenlee | Arizona | 4011 | 58 | 2 |
528052 | 528052 | 2020-09-13 | La Paz | Arizona | 4012 | 526 | 15 |
528053 | 528053 | 2020-09-13 | Maricopa | Arizona | 4013 | 137507 | 3154 |
528054 | 528054 | 2020-09-13 | Mohave | Arizona | 4015 | 3790 | 217 |
528055 | 528055 | 2020-09-13 | Navajo | Arizona | 4017 | 5686 | 227 |
528056 | 528056 | 2020-09-13 | Pima | Arizona | 4019 | 22418 | 602 |
528057 | 528057 | 2020-09-13 | Pinal | Arizona | 4021 | 10183 | 195 |
528058 | 528058 | 2020-09-13 | Santa Cruz | Arizona | 4023 | 2785 | 61 |
528059 | 528059 | 2020-09-13 | Yavapai | Arizona | 4025 | 2423 | 80 |
528060 | 528060 | 2020-09-13 | Yuma | Arizona | 4027 | 12400 | 337 |
524810 | 524810 | 2020-09-12 | Apache | Arizona | 4001 | 3384 | 154 |
524811 | 524811 | 2020-09-12 | Cochise | Arizona | 4003 | 1860 | 67 |
524812 | 524812 | 2020-09-12 | Coconino | Arizona | 4005 | 3491 | 132 |
524813 | 524813 | 2020-09-12 | Gila | Arizona | 4007 | 1167 | 51 |
524814 | 524814 | 2020-09-12 | Graham | Arizona | 4009 | 773 | 24 |
524815 | 524815 | 2020-09-12 | Greenlee | Arizona | 4011 | 59 | 2 |
524816 | 524816 | 2020-09-12 | La Paz | Arizona | 4012 | 525 | 15 |
524817 | 524817 | 2020-09-12 | Maricopa | Arizona | 4013 | 137292 | 3158 |
524818 | 524818 | 2020-09-12 | Mohave | Arizona | 4015 | 3787 | 216 |
524819 | 524819 | 2020-09-12 | Navajo | Arizona | 4017 | 5683 | 226 |
524820 | 524820 | 2020-09-12 | Pima | Arizona | 4019 | 22357 | 602 |
524821 | 524821 | 2020-09-12 | Pinal | Arizona | 4021 | 10170 | 194 |
524822 | 524822 | 2020-09-12 | Santa Cruz | Arizona | 4023 | 2784 | 61 |
524823 | 524823 | 2020-09-12 | Yavapai | Arizona | 4025 | 2418 | 79 |
524824 | 524824 | 2020-09-12 | Yuma | Arizona | 4027 | 12378 | 335 |
521574 | 521574 | 2020-09-11 | Apache | Arizona | 4001 | 3386 | 154 |
521575 | 521575 | 2020-09-11 | Cochise | Arizona | 4003 | 1856 | 66 |
521576 | 521576 | 2020-09-11 | Coconino | Arizona | 4005 | 3454 | 131 |
521577 | 521577 | 2020-09-11 | Gila | Arizona | 4007 | 1162 | 51 |
521578 | 521578 | 2020-09-11 | Graham | Arizona | 4009 | 772 | 24 |
521579 | 521579 | 2020-09-11 | Greenlee | Arizona | 4011 | 58 | 2 |
521580 | 521580 | 2020-09-11 | La Paz | Arizona | 4012 | 524 | 15 |
521581 | 521581 | 2020-09-11 | Maricopa | Arizona | 4013 | 136887 | 3140 |
521582 | 521582 | 2020-09-11 | Mohave | Arizona | 4015 | 3781 | 216 |
521583 | 521583 | 2020-09-11 | Navajo | Arizona | 4017 | 5677 | 226 |
521584 | 521584 | 2020-09-11 | Pima | Arizona | 4019 | 22247 | 600 |
521585 | 521585 | 2020-09-11 | Pinal | Arizona | 4021 | 10156 | 193 |
521586 | 521586 | 2020-09-11 | Santa Cruz | Arizona | 4023 | 2783 | 61 |
521587 | 521587 | 2020-09-11 | Yavapai | Arizona | 4025 | 2408 | 79 |
521588 | 521588 | 2020-09-11 | Yuma | Arizona | 4027 | 12374 | 332 |
518337 | 518337 | 2020-09-10 | Apache | Arizona | 4001 | 3392 | 154 |
518338 | 518338 | 2020-09-10 | Cochise | Arizona | 4003 | 1855 | 66 |
518339 | 518339 | 2020-09-10 | Coconino | Arizona | 4005 | 3436 | 130 |
518340 | 518340 | 2020-09-10 | Gila | Arizona | 4007 | 1154 | 51 |
518341 | 518341 | 2020-09-10 | Graham | Arizona | 4009 | 767 | 24 |
518342 | 518342 | 2020-09-10 | Greenlee | Arizona | 4011 | 58 | 2 |
518343 | 518343 | 2020-09-10 | La Paz | Arizona | 4012 | 525 | 15 |
518344 | 518344 | 2020-09-10 | Maricopa | Arizona | 4013 | 136571 | 3133 |
518345 | 518345 | 2020-09-10 | Mohave | Arizona | 4015 | 3776 | 216 |
518346 | 518346 | 2020-09-10 | Navajo | Arizona | 4017 | 5665 | 225 |
518347 | 518347 | 2020-09-10 | Pima | Arizona | 4019 | 22140 | 600 |
518348 | 518348 | 2020-09-10 | Pinal | Arizona | 4021 | 10142 | 191 |
518349 | 518349 | 2020-09-10 | Santa Cruz | Arizona | 4023 | 2780 | 59 |
518350 | 518350 | 2020-09-10 | Yavapai | Arizona | 4025 | 2390 | 79 |
518351 | 518351 | 2020-09-10 | Yuma | Arizona | 4027 | 12351 | 330 |
515102 | 515102 | 2020-09-09 | Apache | Arizona | 4001 | 3375 | 154 |
515103 | 515103 | 2020-09-09 | Cochise | Arizona | 4003 | 1854 | 66 |
515104 | 515104 | 2020-09-09 | Coconino | Arizona | 4005 | 3409 | 130 |
515105 | 515105 | 2020-09-09 | Gila | Arizona | 4007 | 1148 | 51 |
515106 | 515106 | 2020-09-09 | Graham | Arizona | 4009 | 766 | 24 |
515107 | 515107 | 2020-09-09 | Greenlee | Arizona | 4011 | 58 | 2 |
515108 | 515108 | 2020-09-09 | La Paz | Arizona | 4012 | 518 | 15 |
515109 | 515109 | 2020-09-09 | Maricopa | Arizona | 4013 | 136324 | 3116 |
515110 | 515110 | 2020-09-09 | Mohave | Arizona | 4015 | 3769 | 215 |
515111 | 515111 | 2020-09-09 | Navajo | Arizona | 4017 | 5661 | 225 |
515112 | 515112 | 2020-09-09 | Pima | Arizona | 4019 | 22071 | 596 |
515113 | 515113 | 2020-09-09 | Pinal | Arizona | 4021 | 10086 | 191 |
515114 | 515114 | 2020-09-09 | Santa Cruz | Arizona | 4023 | 2779 | 59 |
515115 | 515115 | 2020-09-09 | Yavapai | Arizona | 4025 | 2386 | 79 |
515116 | 515116 | 2020-09-09 | Yuma | Arizona | 4027 | 12344 | 330 |
511869 | 511869 | 2020-09-08 | Apache | Arizona | 4001 | 3371 | 154 |
511870 | 511870 | 2020-09-08 | Cochise | Arizona | 4003 | 1848 | 64 |
511871 | 511871 | 2020-09-08 | Coconino | Arizona | 4005 | 3397 | 128 |
511872 | 511872 | 2020-09-08 | Gila | Arizona | 4007 | 1134 | 50 |
511873 | 511873 | 2020-09-08 | Graham | Arizona | 4009 | 765 | 23 |
511874 | 511874 | 2020-09-08 | Greenlee | Arizona | 4011 | 59 | 2 |
511875 | 511875 | 2020-09-08 | La Paz | Arizona | 4012 | 517 | 15 |
511876 | 511876 | 2020-09-08 | Maricopa | Arizona | 4013 | 136040 | 3093 |
511877 | 511877 | 2020-09-08 | Mohave | Arizona | 4015 | 3757 | 214 |
511878 | 511878 | 2020-09-08 | Navajo | Arizona | 4017 | 5657 | 223 |
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);