ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Yavapai" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
4427 | 4427 | 2020-03-19 | Yavapai | Arizona | 4025 | 1 | 0 |
5198 | 5198 | 2020-03-20 | Yavapai | Arizona | 4025 | 1 | 0 |
6117 | 6117 | 2020-03-21 | Yavapai | Arizona | 4025 | 1 | 0 |
7151 | 7151 | 2020-03-22 | Yavapai | Arizona | 4025 | 3 | 0 |
8294 | 8294 | 2020-03-23 | Yavapai | Arizona | 4025 | 3 | 0 |
9523 | 9523 | 2020-03-24 | Yavapai | Arizona | 4025 | 3 | 0 |
10893 | 10893 | 2020-03-25 | Yavapai | Arizona | 4025 | 4 | 0 |
12434 | 12434 | 2020-03-26 | Yavapai | Arizona | 4025 | 5 | 0 |
14097 | 14097 | 2020-03-27 | Yavapai | Arizona | 4025 | 9 | 0 |
15877 | 15877 | 2020-03-28 | Yavapai | Arizona | 4025 | 13 | 0 |
17761 | 17761 | 2020-03-29 | Yavapai | Arizona | 4025 | 12 | 0 |
19735 | 19735 | 2020-03-30 | Yavapai | Arizona | 4025 | 19 | 0 |
21807 | 21807 | 2020-03-31 | Yavapai | Arizona | 4025 | 24 | 0 |
23963 | 23963 | 2020-04-01 | Yavapai | Arizona | 4025 | 24 | 0 |
26187 | 26187 | 2020-04-02 | Yavapai | Arizona | 4025 | 34 | 0 |
28484 | 28484 | 2020-04-03 | Yavapai | Arizona | 4025 | 35 | 0 |
30841 | 30841 | 2020-04-04 | Yavapai | Arizona | 4025 | 43 | 0 |
33245 | 33245 | 2020-04-05 | Yavapai | Arizona | 4025 | 45 | 0 |
35685 | 35685 | 2020-04-06 | Yavapai | Arizona | 4025 | 50 | 1 |
38174 | 38174 | 2020-04-07 | Yavapai | Arizona | 4025 | 57 | 1 |
40717 | 40717 | 2020-04-08 | Yavapai | Arizona | 4025 | 58 | 1 |
43289 | 43289 | 2020-04-09 | Yavapai | Arizona | 4025 | 62 | 1 |
45888 | 45888 | 2020-04-10 | Yavapai | Arizona | 4025 | 62 | 1 |
48518 | 48518 | 2020-04-11 | Yavapai | Arizona | 4025 | 63 | 1 |
51180 | 51180 | 2020-04-12 | Yavapai | Arizona | 4025 | 63 | 1 |
53858 | 53858 | 2020-04-13 | Yavapai | Arizona | 4025 | 65 | 1 |
56550 | 56550 | 2020-04-14 | Yavapai | Arizona | 4025 | 70 | 1 |
59258 | 59258 | 2020-04-15 | Yavapai | Arizona | 4025 | 66 | 1 |
61977 | 61977 | 2020-04-16 | Yavapai | Arizona | 4025 | 68 | 1 |
64710 | 64710 | 2020-04-17 | Yavapai | Arizona | 4025 | 69 | 1 |
67458 | 67458 | 2020-04-18 | Yavapai | Arizona | 4025 | 72 | 1 |
70220 | 70220 | 2020-04-19 | Yavapai | Arizona | 4025 | 72 | 1 |
72989 | 72989 | 2020-04-20 | Yavapai | Arizona | 4025 | 71 | 1 |
75765 | 75765 | 2020-04-21 | Yavapai | Arizona | 4025 | 72 | 1 |
78549 | 78549 | 2020-04-22 | Yavapai | Arizona | 4025 | 73 | 1 |
81342 | 81342 | 2020-04-23 | Yavapai | Arizona | 4025 | 75 | 1 |
84142 | 84142 | 2020-04-24 | Yavapai | Arizona | 4025 | 75 | 1 |
86950 | 86950 | 2020-04-25 | Yavapai | Arizona | 4025 | 76 | 1 |
89767 | 89767 | 2020-04-26 | Yavapai | Arizona | 4025 | 76 | 1 |
92585 | 92585 | 2020-04-27 | Yavapai | Arizona | 4025 | 77 | 1 |
95415 | 95415 | 2020-04-28 | Yavapai | Arizona | 4025 | 77 | 1 |
98260 | 98260 | 2020-04-29 | Yavapai | Arizona | 4025 | 79 | 2 |
101110 | 101110 | 2020-04-30 | Yavapai | Arizona | 4025 | 79 | 2 |
103965 | 103965 | 2020-05-01 | Yavapai | Arizona | 4025 | 82 | 2 |
106830 | 106830 | 2020-05-02 | Yavapai | Arizona | 4025 | 87 | 2 |
109699 | 109699 | 2020-05-03 | Yavapai | Arizona | 4025 | 89 | 2 |
112574 | 112574 | 2020-05-04 | Yavapai | Arizona | 4025 | 93 | 2 |
115457 | 115457 | 2020-05-05 | Yavapai | Arizona | 4025 | 126 | 2 |
118416 | 118416 | 2020-05-06 | Yavapai | Arizona | 4025 | 140 | 3 |
121383 | 121383 | 2020-05-07 | Yavapai | Arizona | 4025 | 152 | 3 |
124363 | 124363 | 2020-05-08 | Yavapai | Arizona | 4025 | 170 | 4 |
127348 | 127348 | 2020-05-09 | Yavapai | Arizona | 4025 | 175 | 4 |
130338 | 130338 | 2020-05-10 | Yavapai | Arizona | 4025 | 177 | 4 |
133328 | 133328 | 2020-05-11 | Yavapai | Arizona | 4025 | 180 | 4 |
136318 | 136318 | 2020-05-12 | Yavapai | Arizona | 4025 | 206 | 4 |
139309 | 139309 | 2020-05-13 | Yavapai | Arizona | 4025 | 227 | 4 |
142305 | 142305 | 2020-05-14 | Yavapai | Arizona | 4025 | 243 | 4 |
145304 | 145304 | 2020-05-15 | Yavapai | Arizona | 4025 | 254 | 5 |
148307 | 148307 | 2020-05-16 | Yavapai | Arizona | 4025 | 260 | 5 |
151316 | 151316 | 2020-05-17 | Yavapai | Arizona | 4025 | 262 | 5 |
154328 | 154328 | 2020-05-18 | Yavapai | Arizona | 4025 | 267 | 5 |
157344 | 157344 | 2020-05-19 | Yavapai | Arizona | 4025 | 269 | 5 |
160370 | 160370 | 2020-05-20 | Yavapai | Arizona | 4025 | 273 | 6 |
163398 | 163398 | 2020-05-21 | Yavapai | Arizona | 4025 | 273 | 6 |
166430 | 166430 | 2020-05-22 | Yavapai | Arizona | 4025 | 284 | 6 |
169466 | 169466 | 2020-05-23 | Yavapai | Arizona | 4025 | 284 | 6 |
172507 | 172507 | 2020-05-24 | Yavapai | Arizona | 4025 | 285 | 6 |
175551 | 175551 | 2020-05-25 | Yavapai | Arizona | 4025 | 288 | 6 |
178595 | 178595 | 2020-05-26 | Yavapai | Arizona | 4025 | 291 | 6 |
181639 | 181639 | 2020-05-27 | Yavapai | Arizona | 4025 | 292 | 6 |
184693 | 184693 | 2020-05-28 | Yavapai | Arizona | 4025 | 294 | 6 |
187749 | 187749 | 2020-05-29 | Yavapai | Arizona | 4025 | 295 | 6 |
190814 | 190814 | 2020-05-30 | Yavapai | Arizona | 4025 | 296 | 7 |
193881 | 193881 | 2020-05-31 | Yavapai | Arizona | 4025 | 297 | 6 |
196951 | 196951 | 2020-06-01 | Yavapai | Arizona | 4025 | 297 | 6 |
200024 | 200024 | 2020-06-02 | Yavapai | Arizona | 4025 | 300 | 6 |
203100 | 203100 | 2020-06-03 | Yavapai | Arizona | 4025 | 304 | 6 |
206180 | 206180 | 2020-06-04 | Yavapai | Arizona | 4025 | 307 | 6 |
209261 | 209261 | 2020-06-05 | Yavapai | Arizona | 4025 | 314 | 6 |
212346 | 212346 | 2020-06-06 | Yavapai | Arizona | 4025 | 326 | 6 |
215433 | 215433 | 2020-06-07 | Yavapai | Arizona | 4025 | 327 | 6 |
218524 | 218524 | 2020-06-08 | Yavapai | Arizona | 4025 | 330 | 6 |
221619 | 221619 | 2020-06-09 | Yavapai | Arizona | 4025 | 340 | 6 |
224714 | 224714 | 2020-06-10 | Yavapai | Arizona | 4025 | 348 | 6 |
227816 | 227816 | 2020-06-11 | Yavapai | Arizona | 4025 | 359 | 7 |
230919 | 230919 | 2020-06-12 | Yavapai | Arizona | 4025 | 367 | 7 |
234025 | 234025 | 2020-06-13 | Yavapai | Arizona | 4025 | 374 | 7 |
237132 | 237132 | 2020-06-14 | Yavapai | Arizona | 4025 | 374 | 7 |
240240 | 240240 | 2020-06-15 | Yavapai | Arizona | 4025 | 374 | 7 |
243351 | 243351 | 2020-06-16 | Yavapai | Arizona | 4025 | 384 | 7 |
246464 | 246464 | 2020-06-17 | Yavapai | Arizona | 4025 | 387 | 7 |
249576 | 249576 | 2020-06-18 | Yavapai | Arizona | 4025 | 402 | 7 |
252691 | 252691 | 2020-06-19 | Yavapai | Arizona | 4025 | 417 | 7 |
255810 | 255810 | 2020-06-20 | Yavapai | Arizona | 4025 | 436 | 7 |
258937 | 258937 | 2020-06-21 | Yavapai | Arizona | 4025 | 456 | 7 |
262064 | 262064 | 2020-06-22 | Yavapai | Arizona | 4025 | 490 | 7 |
265192 | 265192 | 2020-06-23 | Yavapai | Arizona | 4025 | 510 | 7 |
268322 | 268322 | 2020-06-24 | Yavapai | Arizona | 4025 | 521 | 7 |
271457 | 271457 | 2020-06-25 | Yavapai | Arizona | 4025 | 564 | 7 |
274597 | 274597 | 2020-06-26 | Yavapai | Arizona | 4025 | 597 | 7 |
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);