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 |
---|---|---|---|---|---|---|---|
1413979 | 1413979 | 2021-06-13 | Apache | Arizona | 4001 | 11449 | 433 |
1413980 | 1413980 | 2021-06-13 | Cochise | Arizona | 4003 | 12116 | 292 |
1413981 | 1413981 | 2021-06-13 | Coconino | Arizona | 4005 | 17909 | 330 |
1413982 | 1413982 | 2021-06-13 | Gila | Arizona | 4007 | 7014 | 229 |
1413983 | 1413983 | 2021-06-13 | Graham | Arizona | 4009 | 5598 | 84 |
1413984 | 1413984 | 2021-06-13 | Greenlee | Arizona | 4011 | 576 | 10 |
1413985 | 1413985 | 2021-06-13 | La Paz | Arizona | 4012 | 2480 | 80 |
1413986 | 1413986 | 2021-06-13 | Maricopa | Arizona | 4013 | 554636 | 10157 |
1413987 | 1413987 | 2021-06-13 | Mohave | Arizona | 4015 | 23308 | 744 |
1413988 | 1413988 | 2021-06-13 | Navajo | Arizona | 4017 | 16495 | 544 |
1413989 | 1413989 | 2021-06-13 | Pima | Arizona | 4019 | 116980 | 2416 |
1413990 | 1413990 | 2021-06-13 | Pinal | Arizona | 4021 | 53434 | 905 |
1413991 | 1413991 | 2021-06-13 | Santa Cruz | Arizona | 4023 | 8061 | 180 |
1413992 | 1413992 | 2021-06-13 | Yavapai | Arizona | 4025 | 19421 | 519 |
1413993 | 1413993 | 2021-06-13 | Yuma | Arizona | 4027 | 37275 | 845 |
1410734 | 1410734 | 2021-06-12 | Apache | Arizona | 4001 | 11441 | 433 |
1410735 | 1410735 | 2021-06-12 | Cochise | Arizona | 4003 | 12117 | 292 |
1410736 | 1410736 | 2021-06-12 | Coconino | Arizona | 4005 | 17907 | 330 |
1410737 | 1410737 | 2021-06-12 | Gila | Arizona | 4007 | 7009 | 229 |
1410738 | 1410738 | 2021-06-12 | Graham | Arizona | 4009 | 5599 | 84 |
1410739 | 1410739 | 2021-06-12 | Greenlee | Arizona | 4011 | 576 | 10 |
1410740 | 1410740 | 2021-06-12 | La Paz | Arizona | 4012 | 2480 | 80 |
1410741 | 1410741 | 2021-06-12 | Maricopa | Arizona | 4013 | 554368 | 10150 |
1410742 | 1410742 | 2021-06-12 | Mohave | Arizona | 4015 | 23300 | 744 |
1410743 | 1410743 | 2021-06-12 | Navajo | Arizona | 4017 | 16492 | 544 |
1410744 | 1410744 | 2021-06-12 | Pima | Arizona | 4019 | 116936 | 2416 |
1410745 | 1410745 | 2021-06-12 | Pinal | Arizona | 4021 | 53430 | 905 |
1410746 | 1410746 | 2021-06-12 | Santa Cruz | Arizona | 4023 | 8060 | 180 |
1410747 | 1410747 | 2021-06-12 | Yavapai | Arizona | 4025 | 19415 | 519 |
1410748 | 1410748 | 2021-06-12 | Yuma | Arizona | 4027 | 37274 | 845 |
1407489 | 1407489 | 2021-06-11 | Apache | Arizona | 4001 | 11437 | 433 |
1407490 | 1407490 | 2021-06-11 | Cochise | Arizona | 4003 | 12113 | 292 |
1407491 | 1407491 | 2021-06-11 | Coconino | Arizona | 4005 | 17883 | 330 |
1407492 | 1407492 | 2021-06-11 | Gila | Arizona | 4007 | 7007 | 229 |
1407493 | 1407493 | 2021-06-11 | Graham | Arizona | 4009 | 5606 | 83 |
1407494 | 1407494 | 2021-06-11 | Greenlee | Arizona | 4011 | 577 | 10 |
1407495 | 1407495 | 2021-06-11 | La Paz | Arizona | 4012 | 2483 | 80 |
1407496 | 1407496 | 2021-06-11 | Maricopa | Arizona | 4013 | 553957 | 10137 |
1407497 | 1407497 | 2021-06-11 | Mohave | Arizona | 4015 | 23276 | 743 |
1407498 | 1407498 | 2021-06-11 | Navajo | Arizona | 4017 | 16483 | 543 |
1407499 | 1407499 | 2021-06-11 | Pima | Arizona | 4019 | 116903 | 2414 |
1407500 | 1407500 | 2021-06-11 | Pinal | Arizona | 4021 | 53369 | 905 |
1407501 | 1407501 | 2021-06-11 | Santa Cruz | Arizona | 4023 | 8061 | 180 |
1407502 | 1407502 | 2021-06-11 | Yavapai | Arizona | 4025 | 19407 | 515 |
1407503 | 1407503 | 2021-06-11 | Yuma | Arizona | 4027 | 37272 | 846 |
1404243 | 1404243 | 2021-06-10 | Apache | Arizona | 4001 | 11432 | 433 |
1404244 | 1404244 | 2021-06-10 | Cochise | Arizona | 4003 | 12103 | 292 |
1404245 | 1404245 | 2021-06-10 | Coconino | Arizona | 4005 | 17880 | 331 |
1404246 | 1404246 | 2021-06-10 | Gila | Arizona | 4007 | 6984 | 229 |
1404247 | 1404247 | 2021-06-10 | Graham | Arizona | 4009 | 5619 | 83 |
1404248 | 1404248 | 2021-06-10 | Greenlee | Arizona | 4011 | 577 | 10 |
1404249 | 1404249 | 2021-06-10 | La Paz | Arizona | 4012 | 2481 | 80 |
1404250 | 1404250 | 2021-06-10 | Maricopa | Arizona | 4013 | 553711 | 10137 |
1404251 | 1404251 | 2021-06-10 | Mohave | Arizona | 4015 | 23245 | 743 |
1404252 | 1404252 | 2021-06-10 | Navajo | Arizona | 4017 | 16470 | 543 |
1404253 | 1404253 | 2021-06-10 | Pima | Arizona | 4019 | 116855 | 2416 |
1404254 | 1404254 | 2021-06-10 | Pinal | Arizona | 4021 | 53326 | 905 |
1404255 | 1404255 | 2021-06-10 | Santa Cruz | Arizona | 4023 | 8061 | 180 |
1404256 | 1404256 | 2021-06-10 | Yavapai | Arizona | 4025 | 19396 | 515 |
1404257 | 1404257 | 2021-06-10 | Yuma | Arizona | 4027 | 37272 | 845 |
1400998 | 1400998 | 2021-06-09 | Apache | Arizona | 4001 | 11428 | 433 |
1400999 | 1400999 | 2021-06-09 | Cochise | Arizona | 4003 | 12099 | 291 |
1401000 | 1401000 | 2021-06-09 | Coconino | Arizona | 4005 | 17877 | 331 |
1401001 | 1401001 | 2021-06-09 | Gila | Arizona | 4007 | 6957 | 230 |
1401002 | 1401002 | 2021-06-09 | Graham | Arizona | 4009 | 5632 | 83 |
1401003 | 1401003 | 2021-06-09 | Greenlee | Arizona | 4011 | 577 | 10 |
1401004 | 1401004 | 2021-06-09 | La Paz | Arizona | 4012 | 2479 | 80 |
1401005 | 1401005 | 2021-06-09 | Maricopa | Arizona | 4013 | 553476 | 10122 |
1401006 | 1401006 | 2021-06-09 | Mohave | Arizona | 4015 | 23220 | 741 |
1401007 | 1401007 | 2021-06-09 | Navajo | Arizona | 4017 | 16465 | 541 |
1401008 | 1401008 | 2021-06-09 | Pima | Arizona | 4019 | 116826 | 2412 |
1401009 | 1401009 | 2021-06-09 | Pinal | Arizona | 4021 | 53299 | 905 |
1401010 | 1401010 | 2021-06-09 | Santa Cruz | Arizona | 4023 | 8059 | 180 |
1401011 | 1401011 | 2021-06-09 | Yavapai | Arizona | 4025 | 19382 | 513 |
1401012 | 1401012 | 2021-06-09 | Yuma | Arizona | 4027 | 37266 | 843 |
1397753 | 1397753 | 2021-06-08 | Apache | Arizona | 4001 | 11420 | 433 |
1397754 | 1397754 | 2021-06-08 | Cochise | Arizona | 4003 | 12098 | 290 |
1397755 | 1397755 | 2021-06-08 | Coconino | Arizona | 4005 | 17879 | 331 |
1397756 | 1397756 | 2021-06-08 | Gila | Arizona | 4007 | 6953 | 229 |
1397757 | 1397757 | 2021-06-08 | Graham | Arizona | 4009 | 5634 | 83 |
1397758 | 1397758 | 2021-06-08 | Greenlee | Arizona | 4011 | 577 | 10 |
1397759 | 1397759 | 2021-06-08 | La Paz | Arizona | 4012 | 2479 | 80 |
1397760 | 1397760 | 2021-06-08 | Maricopa | Arizona | 4013 | 553072 | 10120 |
1397761 | 1397761 | 2021-06-08 | Mohave | Arizona | 4015 | 23195 | 741 |
1397762 | 1397762 | 2021-06-08 | Navajo | Arizona | 4017 | 16462 | 542 |
1397763 | 1397763 | 2021-06-08 | Pima | Arizona | 4019 | 116905 | 2413 |
1397764 | 1397764 | 2021-06-08 | Pinal | Arizona | 4021 | 53255 | 905 |
1397765 | 1397765 | 2021-06-08 | Santa Cruz | Arizona | 4023 | 8054 | 180 |
1397766 | 1397766 | 2021-06-08 | Yavapai | Arizona | 4025 | 19363 | 513 |
1397767 | 1397767 | 2021-06-08 | Yuma | Arizona | 4027 | 37263 | 843 |
1394506 | 1394506 | 2021-06-07 | Apache | Arizona | 4001 | 11419 | 433 |
1394507 | 1394507 | 2021-06-07 | Cochise | Arizona | 4003 | 12097 | 290 |
1394508 | 1394508 | 2021-06-07 | Coconino | Arizona | 4005 | 17876 | 331 |
1394509 | 1394509 | 2021-06-07 | Gila | Arizona | 4007 | 6952 | 229 |
1394510 | 1394510 | 2021-06-07 | Graham | Arizona | 4009 | 5633 | 83 |
1394511 | 1394511 | 2021-06-07 | Greenlee | Arizona | 4011 | 577 | 10 |
1394512 | 1394512 | 2021-06-07 | La Paz | Arizona | 4012 | 2479 | 80 |
1394513 | 1394513 | 2021-06-07 | Maricopa | Arizona | 4013 | 552781 | 10112 |
1394514 | 1394514 | 2021-06-07 | Mohave | Arizona | 4015 | 23179 | 740 |
1394515 | 1394515 | 2021-06-07 | Navajo | Arizona | 4017 | 16463 | 542 |
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);