ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Coconino" 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 |
---|---|---|---|---|---|---|---|
3777 | 3777 | 2020-03-18 | Coconino | Arizona | 4005 | 1 | 0 |
4420 | 4420 | 2020-03-19 | Coconino | Arizona | 4005 | 2 | 0 |
5191 | 5191 | 2020-03-20 | Coconino | Arizona | 4005 | 11 | 0 |
6110 | 6110 | 2020-03-21 | Coconino | Arizona | 4005 | 11 | 0 |
7144 | 7144 | 2020-03-22 | Coconino | Arizona | 4005 | 15 | 0 |
8287 | 8287 | 2020-03-23 | Coconino | Arizona | 4005 | 17 | 0 |
9515 | 9515 | 2020-03-24 | Coconino | Arizona | 4005 | 18 | 1 |
10885 | 10885 | 2020-03-25 | Coconino | Arizona | 4005 | 23 | 1 |
12424 | 12424 | 2020-03-26 | Coconino | Arizona | 4005 | 28 | 2 |
14087 | 14087 | 2020-03-27 | Coconino | Arizona | 4005 | 41 | 2 |
15866 | 15866 | 2020-03-28 | Coconino | Arizona | 4005 | 56 | 2 |
17750 | 17750 | 2020-03-29 | Coconino | Arizona | 4005 | 68 | 2 |
19723 | 19723 | 2020-03-30 | Coconino | Arizona | 4005 | 73 | 3 |
21795 | 21795 | 2020-03-31 | Coconino | Arizona | 4005 | 81 | 3 |
23951 | 23951 | 2020-04-01 | Coconino | Arizona | 4005 | 85 | 3 |
26175 | 26175 | 2020-04-02 | Coconino | Arizona | 4005 | 116 | 8 |
28472 | 28472 | 2020-04-03 | Coconino | Arizona | 4005 | 126 | 8 |
30829 | 30829 | 2020-04-04 | Coconino | Arizona | 4005 | 147 | 10 |
33233 | 33233 | 2020-04-05 | Coconino | Arizona | 4005 | 155 | 10 |
35673 | 35673 | 2020-04-06 | Coconino | Arizona | 4005 | 167 | 10 |
38162 | 38162 | 2020-04-07 | Coconino | Arizona | 4005 | 179 | 14 |
40705 | 40705 | 2020-04-08 | Coconino | Arizona | 4005 | 186 | 14 |
43278 | 43278 | 2020-04-09 | Coconino | Arizona | 4005 | 210 | 15 |
45876 | 45876 | 2020-04-10 | Coconino | Arizona | 4005 | 214 | 15 |
48506 | 48506 | 2020-04-11 | Coconino | Arizona | 4005 | 238 | 15 |
51168 | 51168 | 2020-04-12 | Coconino | Arizona | 4005 | 243 | 21 |
53846 | 53846 | 2020-04-13 | Coconino | Arizona | 4005 | 253 | 21 |
56538 | 56538 | 2020-04-14 | Coconino | Arizona | 4005 | 270 | 22 |
59247 | 59247 | 2020-04-15 | Coconino | Arizona | 4005 | 266 | 24 |
61966 | 61966 | 2020-04-16 | Coconino | Arizona | 4005 | 299 | 26 |
64699 | 64699 | 2020-04-17 | Coconino | Arizona | 4005 | 304 | 29 |
67447 | 67447 | 2020-04-18 | Coconino | Arizona | 4005 | 314 | 29 |
70209 | 70209 | 2020-04-19 | Coconino | Arizona | 4005 | 333 | 30 |
72978 | 72978 | 2020-04-20 | Coconino | Arizona | 4005 | 337 | 30 |
75754 | 75754 | 2020-04-21 | Coconino | Arizona | 4005 | 342 | 35 |
78537 | 78537 | 2020-04-22 | Coconino | Arizona | 4005 | 353 | 35 |
81330 | 81330 | 2020-04-23 | Coconino | Arizona | 4005 | 372 | 35 |
84131 | 84131 | 2020-04-24 | Coconino | Arizona | 4005 | 391 | 36 |
86939 | 86939 | 2020-04-25 | Coconino | Arizona | 4005 | 402 | 40 |
89756 | 89756 | 2020-04-26 | Coconino | Arizona | 4005 | 420 | 40 |
92574 | 92574 | 2020-04-27 | Coconino | Arizona | 4005 | 425 | 40 |
95404 | 95404 | 2020-04-28 | Coconino | Arizona | 4005 | 439 | 42 |
98249 | 98249 | 2020-04-29 | Coconino | Arizona | 4005 | 453 | 42 |
101099 | 101099 | 2020-04-30 | Coconino | Arizona | 4005 | 486 | 42 |
103954 | 103954 | 2020-05-01 | Coconino | Arizona | 4005 | 498 | 44 |
106819 | 106819 | 2020-05-02 | Coconino | Arizona | 4005 | 512 | 44 |
109688 | 109688 | 2020-05-03 | Coconino | Arizona | 4005 | 527 | 44 |
112563 | 112563 | 2020-05-04 | Coconino | Arizona | 4005 | 540 | 44 |
115446 | 115446 | 2020-05-05 | Coconino | Arizona | 4005 | 561 | 46 |
118405 | 118405 | 2020-05-06 | Coconino | Arizona | 4005 | 588 | 48 |
121372 | 121372 | 2020-05-07 | Coconino | Arizona | 4005 | 618 | 49 |
124352 | 124352 | 2020-05-08 | Coconino | Arizona | 4005 | 659 | 55 |
127337 | 127337 | 2020-05-09 | Coconino | Arizona | 4005 | 679 | 55 |
130327 | 130327 | 2020-05-10 | Coconino | Arizona | 4005 | 699 | 55 |
133317 | 133317 | 2020-05-11 | Coconino | Arizona | 4005 | 713 | 56 |
136307 | 136307 | 2020-05-12 | Coconino | Arizona | 4005 | 720 | 58 |
139298 | 139298 | 2020-05-13 | Coconino | Arizona | 4005 | 772 | 58 |
142294 | 142294 | 2020-05-14 | Coconino | Arizona | 4005 | 795 | 59 |
145293 | 145293 | 2020-05-15 | Coconino | Arizona | 4005 | 823 | 62 |
148296 | 148296 | 2020-05-16 | Coconino | Arizona | 4005 | 839 | 64 |
151305 | 151305 | 2020-05-17 | Coconino | Arizona | 4005 | 866 | 64 |
154317 | 154317 | 2020-05-18 | Coconino | Arizona | 4005 | 901 | 65 |
157333 | 157333 | 2020-05-19 | Coconino | Arizona | 4005 | 943 | 66 |
160359 | 160359 | 2020-05-20 | Coconino | Arizona | 4005 | 961 | 68 |
163387 | 163387 | 2020-05-21 | Coconino | Arizona | 4005 | 972 | 69 |
166419 | 166419 | 2020-05-22 | Coconino | Arizona | 4005 | 979 | 69 |
169455 | 169455 | 2020-05-23 | Coconino | Arizona | 4005 | 1000 | 72 |
172496 | 172496 | 2020-05-24 | Coconino | Arizona | 4005 | 1019 | 72 |
175539 | 175539 | 2020-05-25 | Coconino | Arizona | 4005 | 1028 | 72 |
178584 | 178584 | 2020-05-26 | Coconino | Arizona | 4005 | 1041 | 73 |
181628 | 181628 | 2020-05-27 | Coconino | Arizona | 4005 | 1066 | 75 |
184681 | 184681 | 2020-05-28 | Coconino | Arizona | 4005 | 1078 | 79 |
187738 | 187738 | 2020-05-29 | Coconino | Arizona | 4005 | 1104 | 81 |
190803 | 190803 | 2020-05-30 | Coconino | Arizona | 4005 | 1123 | 81 |
193870 | 193870 | 2020-05-31 | Coconino | Arizona | 4005 | 1151 | 81 |
196940 | 196940 | 2020-06-01 | Coconino | Arizona | 4005 | 1155 | 81 |
200013 | 200013 | 2020-06-02 | Coconino | Arizona | 4005 | 1173 | 81 |
203089 | 203089 | 2020-06-03 | Coconino | Arizona | 4005 | 1186 | 85 |
206169 | 206169 | 2020-06-04 | Coconino | Arizona | 4005 | 1221 | 85 |
209250 | 209250 | 2020-06-05 | Coconino | Arizona | 4005 | 1248 | 85 |
212335 | 212335 | 2020-06-06 | Coconino | Arizona | 4005 | 1267 | 85 |
215422 | 215422 | 2020-06-07 | Coconino | Arizona | 4005 | 1282 | 85 |
218513 | 218513 | 2020-06-08 | Coconino | Arizona | 4005 | 1290 | 85 |
221608 | 221608 | 2020-06-09 | Coconino | Arizona | 4005 | 1289 | 85 |
224703 | 224703 | 2020-06-10 | Coconino | Arizona | 4005 | 1310 | 85 |
227805 | 227805 | 2020-06-11 | Coconino | Arizona | 4005 | 1328 | 86 |
230908 | 230908 | 2020-06-12 | Coconino | Arizona | 4005 | 1345 | 86 |
234014 | 234014 | 2020-06-13 | Coconino | Arizona | 4005 | 1360 | 87 |
237121 | 237121 | 2020-06-14 | Coconino | Arizona | 4005 | 1368 | 87 |
240229 | 240229 | 2020-06-15 | Coconino | Arizona | 4005 | 1373 | 88 |
243340 | 243340 | 2020-06-16 | Coconino | Arizona | 4005 | 1393 | 88 |
246453 | 246453 | 2020-06-17 | Coconino | Arizona | 4005 | 1410 | 88 |
249565 | 249565 | 2020-06-18 | Coconino | Arizona | 4005 | 1439 | 88 |
252680 | 252680 | 2020-06-19 | Coconino | Arizona | 4005 | 1470 | 90 |
255799 | 255799 | 2020-06-20 | Coconino | Arizona | 4005 | 1490 | 90 |
258926 | 258926 | 2020-06-21 | Coconino | Arizona | 4005 | 1536 | 90 |
262053 | 262053 | 2020-06-22 | Coconino | Arizona | 4005 | 1541 | 90 |
265181 | 265181 | 2020-06-23 | Coconino | Arizona | 4005 | 1595 | 90 |
268311 | 268311 | 2020-06-24 | Coconino | Arizona | 4005 | 1611 | 91 |
271446 | 271446 | 2020-06-25 | Coconino | Arizona | 4005 | 1676 | 91 |
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);