ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
93 rows where deaths = 3 and state = "Arizona" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
county 13
state 1
- Arizona · 93 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
878348 | 878348 | 2020-12-30 | Greenlee | Arizona | 4011 | 392 | 3 |
875103 | 875103 | 2020-12-29 | Greenlee | Arizona | 4011 | 387 | 3 |
871858 | 871858 | 2020-12-28 | Greenlee | Arizona | 4011 | 382 | 3 |
868613 | 868613 | 2020-12-27 | Greenlee | Arizona | 4011 | 379 | 3 |
865368 | 865368 | 2020-12-26 | Greenlee | Arizona | 4011 | 376 | 3 |
862123 | 862123 | 2020-12-25 | Greenlee | Arizona | 4011 | 372 | 3 |
858878 | 858878 | 2020-12-24 | Greenlee | Arizona | 4011 | 365 | 3 |
855633 | 855633 | 2020-12-23 | Greenlee | Arizona | 4011 | 364 | 3 |
852388 | 852388 | 2020-12-22 | Greenlee | Arizona | 4011 | 359 | 3 |
849143 | 849143 | 2020-12-21 | Greenlee | Arizona | 4011 | 354 | 3 |
845898 | 845898 | 2020-12-20 | Greenlee | Arizona | 4011 | 354 | 3 |
842652 | 842652 | 2020-12-19 | Greenlee | Arizona | 4011 | 354 | 3 |
839407 | 839407 | 2020-12-18 | Greenlee | Arizona | 4011 | 347 | 3 |
836162 | 836162 | 2020-12-17 | Greenlee | Arizona | 4011 | 342 | 3 |
832916 | 832916 | 2020-12-16 | Greenlee | Arizona | 4011 | 341 | 3 |
829669 | 829669 | 2020-12-15 | Greenlee | Arizona | 4011 | 338 | 3 |
826423 | 826423 | 2020-12-14 | Greenlee | Arizona | 4011 | 331 | 3 |
823176 | 823176 | 2020-12-13 | Greenlee | Arizona | 4011 | 326 | 3 |
819930 | 819930 | 2020-12-12 | Greenlee | Arizona | 4011 | 320 | 3 |
816684 | 816684 | 2020-12-11 | Greenlee | Arizona | 4011 | 312 | 3 |
813438 | 813438 | 2020-12-10 | Greenlee | Arizona | 4011 | 309 | 3 |
810194 | 810194 | 2020-12-09 | Greenlee | Arizona | 4011 | 304 | 3 |
806949 | 806949 | 2020-12-08 | Greenlee | Arizona | 4011 | 297 | 3 |
803704 | 803704 | 2020-12-07 | Greenlee | Arizona | 4011 | 294 | 3 |
800459 | 800459 | 2020-12-06 | Greenlee | Arizona | 4011 | 293 | 3 |
797214 | 797214 | 2020-12-05 | Greenlee | Arizona | 4011 | 286 | 3 |
793969 | 793969 | 2020-12-04 | Greenlee | Arizona | 4011 | 277 | 3 |
790724 | 790724 | 2020-12-03 | Greenlee | Arizona | 4011 | 265 | 3 |
787479 | 787479 | 2020-12-02 | Greenlee | Arizona | 4011 | 248 | 3 |
784235 | 784235 | 2020-12-01 | Greenlee | Arizona | 4011 | 239 | 3 |
780990 | 780990 | 2020-11-30 | Greenlee | Arizona | 4011 | 228 | 3 |
777744 | 777744 | 2020-11-29 | Greenlee | Arizona | 4011 | 224 | 3 |
325171 | 325171 | 2020-07-12 | Graham | Arizona | 4009 | 204 | 3 |
321990 | 321990 | 2020-07-11 | Graham | Arizona | 4009 | 201 | 3 |
318811 | 318811 | 2020-07-10 | Graham | Arizona | 4009 | 184 | 3 |
315638 | 315638 | 2020-07-09 | Graham | Arizona | 4009 | 180 | 3 |
312463 | 312463 | 2020-07-08 | Graham | Arizona | 4009 | 179 | 3 |
309293 | 309293 | 2020-07-07 | Graham | Arizona | 4009 | 172 | 3 |
306125 | 306125 | 2020-07-06 | Graham | Arizona | 4009 | 152 | 3 |
302961 | 302961 | 2020-07-05 | Graham | Arizona | 4009 | 140 | 3 |
299797 | 299797 | 2020-07-04 | Graham | Arizona | 4009 | 127 | 3 |
296635 | 296635 | 2020-07-03 | Graham | Arizona | 4009 | 125 | 3 |
293479 | 293479 | 2020-07-02 | Graham | Arizona | 4009 | 117 | 3 |
255800 | 255800 | 2020-06-20 | Gila | Arizona | 4007 | 143 | 3 |
252681 | 252681 | 2020-06-19 | Gila | Arizona | 4007 | 125 | 3 |
249566 | 249566 | 2020-06-18 | Gila | Arizona | 4007 | 115 | 3 |
246454 | 246454 | 2020-06-17 | Gila | Arizona | 4007 | 99 | 3 |
243341 | 243341 | 2020-06-16 | Gila | Arizona | 4007 | 91 | 3 |
243344 | 243344 | 2020-06-16 | La Paz | Arizona | 4012 | 238 | 3 |
240230 | 240230 | 2020-06-15 | Gila | Arizona | 4007 | 87 | 3 |
237122 | 237122 | 2020-06-14 | Gila | Arizona | 4007 | 70 | 3 |
234015 | 234015 | 2020-06-13 | Gila | Arizona | 4007 | 59 | 3 |
230909 | 230909 | 2020-06-12 | Gila | Arizona | 4007 | 54 | 3 |
227806 | 227806 | 2020-06-11 | Gila | Arizona | 4007 | 49 | 3 |
224704 | 224704 | 2020-06-10 | Gila | Arizona | 4007 | 48 | 3 |
221609 | 221609 | 2020-06-09 | Gila | Arizona | 4007 | 47 | 3 |
218514 | 218514 | 2020-06-08 | Gila | Arizona | 4007 | 46 | 3 |
215423 | 215423 | 2020-06-07 | Gila | Arizona | 4007 | 45 | 3 |
212336 | 212336 | 2020-06-06 | Gila | Arizona | 4007 | 43 | 3 |
209251 | 209251 | 2020-06-05 | Gila | Arizona | 4007 | 42 | 3 |
206179 | 206179 | 2020-06-04 | Santa Cruz | Arizona | 4023 | 527 | 3 |
196939 | 196939 | 2020-06-01 | Cochise | Arizona | 4003 | 76 | 3 |
193869 | 193869 | 2020-05-31 | Cochise | Arizona | 4003 | 74 | 3 |
190802 | 190802 | 2020-05-30 | Cochise | Arizona | 4003 | 72 | 3 |
139310 | 139310 | 2020-05-13 | Yuma | Arizona | 4027 | 243 | 3 |
136319 | 136319 | 2020-05-12 | Yuma | Arizona | 4027 | 207 | 3 |
133329 | 133329 | 2020-05-11 | Yuma | Arizona | 4027 | 196 | 3 |
130339 | 130339 | 2020-05-10 | Yuma | Arizona | 4027 | 191 | 3 |
127349 | 127349 | 2020-05-09 | Yuma | Arizona | 4027 | 176 | 3 |
121383 | 121383 | 2020-05-07 | Yavapai | Arizona | 4025 | 152 | 3 |
118416 | 118416 | 2020-05-06 | Yavapai | Arizona | 4025 | 140 | 3 |
86945 | 86945 | 2020-04-25 | Mohave | Arizona | 4015 | 81 | 3 |
84137 | 84137 | 2020-04-24 | Mohave | Arizona | 4015 | 73 | 3 |
81336 | 81336 | 2020-04-23 | Mohave | Arizona | 4015 | 69 | 3 |
78543 | 78543 | 2020-04-22 | Mohave | Arizona | 4015 | 62 | 3 |
75760 | 75760 | 2020-04-21 | Mohave | Arizona | 4015 | 59 | 3 |
72984 | 72984 | 2020-04-20 | Mohave | Arizona | 4015 | 56 | 3 |
53844 | 53844 | 2020-04-13 | Apache | Arizona | 4001 | 89 | 3 |
51166 | 51166 | 2020-04-12 | Apache | Arizona | 4001 | 72 | 3 |
48504 | 48504 | 2020-04-11 | Apache | Arizona | 4001 | 66 | 3 |
48515 | 48515 | 2020-04-11 | Pinal | Arizona | 4021 | 146 | 3 |
45874 | 45874 | 2020-04-10 | Apache | Arizona | 4001 | 55 | 3 |
45885 | 45885 | 2020-04-10 | Pinal | Arizona | 4021 | 138 | 3 |
43276 | 43276 | 2020-04-09 | Apache | Arizona | 4001 | 52 | 3 |
43287 | 43287 | 2020-04-09 | Pinal | Arizona | 4021 | 137 | 3 |
40703 | 40703 | 2020-04-08 | Apache | Arizona | 4001 | 34 | 3 |
26186 | 26186 | 2020-04-02 | Unknown | Arizona | 0 | 3 | |
23951 | 23951 | 2020-04-01 | Coconino | Arizona | 4005 | 85 | 3 |
21795 | 21795 | 2020-03-31 | Coconino | Arizona | 4005 | 81 | 3 |
19723 | 19723 | 2020-03-30 | Coconino | Arizona | 4005 | 73 | 3 |
15876 | 15876 | 2020-03-28 | Unknown | Arizona | 0 | 3 | |
10892 | 10892 | 2020-03-25 | Unknown | Arizona | 0 | 3 | |
9522 | 9522 | 2020-03-24 | Unknown | Arizona | 0 | 3 |
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);