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 |
---|---|---|---|---|---|---|---|
631734 | 631734 | 2020-10-15 | Apache | Arizona | 4001 | 3742 | 167 |
631735 | 631735 | 2020-10-15 | Cochise | Arizona | 4003 | 2005 | 73 |
631736 | 631736 | 2020-10-15 | Coconino | Arizona | 4005 | 4629 | 145 |
631737 | 631737 | 2020-10-15 | Gila | Arizona | 4007 | 1633 | 62 |
631738 | 631738 | 2020-10-15 | Graham | Arizona | 4009 | 977 | 26 |
631739 | 631739 | 2020-10-15 | Greenlee | Arizona | 4011 | 70 | 2 |
631740 | 631740 | 2020-10-15 | La Paz | Arizona | 4012 | 577 | 16 |
631741 | 631741 | 2020-10-15 | Maricopa | Arizona | 4013 | 148152 | 3489 |
631742 | 631742 | 2020-10-15 | Mohave | Arizona | 4015 | 4138 | 228 |
631743 | 631743 | 2020-10-15 | Navajo | Arizona | 4017 | 6120 | 236 |
631744 | 631744 | 2020-10-15 | Pima | Arizona | 4019 | 26727 | 633 |
631745 | 631745 | 2020-10-15 | Pinal | Arizona | 4021 | 11203 | 213 |
631746 | 631746 | 2020-10-15 | Santa Cruz | Arizona | 4023 | 2935 | 64 |
631747 | 631747 | 2020-10-15 | Yavapai | Arizona | 4025 | 2748 | 86 |
631748 | 631748 | 2020-10-15 | Yuma | Arizona | 4027 | 13092 | 349 |
628490 | 628490 | 2020-10-14 | Apache | Arizona | 4001 | 3734 | 166 |
628491 | 628491 | 2020-10-14 | Cochise | Arizona | 4003 | 2000 | 73 |
628492 | 628492 | 2020-10-14 | Coconino | Arizona | 4005 | 4563 | 145 |
628493 | 628493 | 2020-10-14 | Gila | Arizona | 4007 | 1597 | 61 |
628494 | 628494 | 2020-10-14 | Graham | Arizona | 4009 | 963 | 26 |
628495 | 628495 | 2020-10-14 | Greenlee | Arizona | 4011 | 66 | 2 |
628496 | 628496 | 2020-10-14 | La Paz | Arizona | 4012 | 575 | 16 |
628497 | 628497 | 2020-10-14 | Maricopa | Arizona | 4013 | 147551 | 3475 |
628498 | 628498 | 2020-10-14 | Mohave | Arizona | 4015 | 4121 | 228 |
628499 | 628499 | 2020-10-14 | Navajo | Arizona | 4017 | 5959 | 236 |
628500 | 628500 | 2020-10-14 | Pima | Arizona | 4019 | 26632 | 633 |
628501 | 628501 | 2020-10-14 | Pinal | Arizona | 4021 | 11152 | 213 |
628502 | 628502 | 2020-10-14 | Santa Cruz | Arizona | 4023 | 2921 | 64 |
628503 | 628503 | 2020-10-14 | Yavapai | Arizona | 4025 | 2738 | 86 |
628504 | 628504 | 2020-10-14 | Yuma | Arizona | 4027 | 13088 | 348 |
625247 | 625247 | 2020-10-13 | Apache | Arizona | 4001 | 3708 | 166 |
625248 | 625248 | 2020-10-13 | Cochise | Arizona | 4003 | 1984 | 73 |
625249 | 625249 | 2020-10-13 | Coconino | Arizona | 4005 | 4529 | 145 |
625250 | 625250 | 2020-10-13 | Gila | Arizona | 4007 | 1537 | 61 |
625251 | 625251 | 2020-10-13 | Graham | Arizona | 4009 | 951 | 26 |
625252 | 625252 | 2020-10-13 | Greenlee | Arizona | 4011 | 64 | 2 |
625253 | 625253 | 2020-10-13 | La Paz | Arizona | 4012 | 572 | 16 |
625254 | 625254 | 2020-10-13 | Maricopa | Arizona | 4013 | 147010 | 3471 |
625255 | 625255 | 2020-10-13 | Mohave | Arizona | 4015 | 4096 | 228 |
625256 | 625256 | 2020-10-13 | Navajo | Arizona | 4017 | 5923 | 236 |
625257 | 625257 | 2020-10-13 | Pima | Arizona | 4019 | 26516 | 633 |
625258 | 625258 | 2020-10-13 | Pinal | Arizona | 4021 | 11123 | 212 |
625259 | 625259 | 2020-10-13 | Santa Cruz | Arizona | 4023 | 2922 | 64 |
625260 | 625260 | 2020-10-13 | Yavapai | Arizona | 4025 | 2725 | 86 |
625261 | 625261 | 2020-10-13 | Yuma | Arizona | 4027 | 13089 | 348 |
622004 | 622004 | 2020-10-12 | Apache | Arizona | 4001 | 3706 | 166 |
622005 | 622005 | 2020-10-12 | Cochise | Arizona | 4003 | 1984 | 73 |
622006 | 622006 | 2020-10-12 | Coconino | Arizona | 4005 | 4498 | 145 |
622007 | 622007 | 2020-10-12 | Gila | Arizona | 4007 | 1525 | 61 |
622008 | 622008 | 2020-10-12 | Graham | Arizona | 4009 | 942 | 26 |
622009 | 622009 | 2020-10-12 | Greenlee | Arizona | 4011 | 62 | 2 |
622010 | 622010 | 2020-10-12 | La Paz | Arizona | 4012 | 571 | 16 |
622011 | 622011 | 2020-10-12 | Maricopa | Arizona | 4013 | 146574 | 3464 |
622012 | 622012 | 2020-10-12 | Mohave | Arizona | 4015 | 4089 | 228 |
622013 | 622013 | 2020-10-12 | Navajo | Arizona | 4017 | 5910 | 236 |
622014 | 622014 | 2020-10-12 | Pima | Arizona | 4019 | 26465 | 633 |
622015 | 622015 | 2020-10-12 | Pinal | Arizona | 4021 | 11076 | 212 |
622016 | 622016 | 2020-10-12 | Santa Cruz | Arizona | 4023 | 2915 | 64 |
622017 | 622017 | 2020-10-12 | Yavapai | Arizona | 4025 | 2709 | 85 |
622018 | 622018 | 2020-10-12 | Yuma | Arizona | 4027 | 13046 | 348 |
618761 | 618761 | 2020-10-11 | Apache | Arizona | 4001 | 3706 | 166 |
618762 | 618762 | 2020-10-11 | Cochise | Arizona | 4003 | 1965 | 73 |
618763 | 618763 | 2020-10-11 | Coconino | Arizona | 4005 | 4482 | 145 |
618764 | 618764 | 2020-10-11 | Gila | Arizona | 4007 | 1525 | 61 |
618765 | 618765 | 2020-10-11 | Graham | Arizona | 4009 | 940 | 26 |
618766 | 618766 | 2020-10-11 | Greenlee | Arizona | 4011 | 62 | 2 |
618767 | 618767 | 2020-10-11 | La Paz | Arizona | 4012 | 568 | 16 |
618768 | 618768 | 2020-10-11 | Maricopa | Arizona | 4013 | 146278 | 3464 |
618769 | 618769 | 2020-10-11 | Mohave | Arizona | 4015 | 4089 | 228 |
618770 | 618770 | 2020-10-11 | Navajo | Arizona | 4017 | 5898 | 236 |
618771 | 618771 | 2020-10-11 | Pima | Arizona | 4019 | 26402 | 633 |
618772 | 618772 | 2020-10-11 | Pinal | Arizona | 4021 | 11024 | 212 |
618773 | 618773 | 2020-10-11 | Santa Cruz | Arizona | 4023 | 2909 | 64 |
618774 | 618774 | 2020-10-11 | Yavapai | Arizona | 4025 | 2706 | 85 |
618775 | 618775 | 2020-10-11 | Yuma | Arizona | 4027 | 13021 | 348 |
615519 | 615519 | 2020-10-10 | Apache | Arizona | 4001 | 3713 | 166 |
615520 | 615520 | 2020-10-10 | Cochise | Arizona | 4003 | 1961 | 73 |
615521 | 615521 | 2020-10-10 | Coconino | Arizona | 4005 | 4445 | 145 |
615522 | 615522 | 2020-10-10 | Gila | Arizona | 4007 | 1523 | 61 |
615523 | 615523 | 2020-10-10 | Graham | Arizona | 4009 | 938 | 26 |
615524 | 615524 | 2020-10-10 | Greenlee | Arizona | 4011 | 62 | 2 |
615525 | 615525 | 2020-10-10 | La Paz | Arizona | 4012 | 568 | 16 |
615526 | 615526 | 2020-10-10 | Maricopa | Arizona | 4013 | 145847 | 3466 |
615527 | 615527 | 2020-10-10 | Mohave | Arizona | 4015 | 4090 | 228 |
615528 | 615528 | 2020-10-10 | Navajo | Arizona | 4017 | 5887 | 236 |
615529 | 615529 | 2020-10-10 | Pima | Arizona | 4019 | 26363 | 631 |
615530 | 615530 | 2020-10-10 | Pinal | Arizona | 4021 | 11005 | 212 |
615531 | 615531 | 2020-10-10 | Santa Cruz | Arizona | 4023 | 2904 | 64 |
615532 | 615532 | 2020-10-10 | Yavapai | Arizona | 4025 | 2693 | 85 |
615533 | 615533 | 2020-10-10 | Yuma | Arizona | 4027 | 12986 | 348 |
612278 | 612278 | 2020-10-09 | Apache | Arizona | 4001 | 3654 | 166 |
612279 | 612279 | 2020-10-09 | Cochise | Arizona | 4003 | 1961 | 73 |
612280 | 612280 | 2020-10-09 | Coconino | Arizona | 4005 | 4401 | 145 |
612281 | 612281 | 2020-10-09 | Gila | Arizona | 4007 | 1500 | 60 |
612282 | 612282 | 2020-10-09 | Graham | Arizona | 4009 | 927 | 26 |
612283 | 612283 | 2020-10-09 | Greenlee | Arizona | 4011 | 62 | 2 |
612284 | 612284 | 2020-10-09 | La Paz | Arizona | 4012 | 563 | 15 |
612285 | 612285 | 2020-10-09 | Maricopa | Arizona | 4013 | 145298 | 3458 |
612286 | 612286 | 2020-10-09 | Mohave | Arizona | 4015 | 4078 | 228 |
612287 | 612287 | 2020-10-09 | Navajo | Arizona | 4017 | 5874 | 236 |
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);