ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where county = "Coffee" and fips = 1031 sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
26116 | 26116 | 2020-04-02 | Coffee | Alabama | 1031 | 3 | 0 |
28412 | 28412 | 2020-04-03 | Coffee | Alabama | 1031 | 6 | 0 |
30769 | 30769 | 2020-04-04 | Coffee | Alabama | 1031 | 7 | 0 |
33173 | 33173 | 2020-04-05 | Coffee | Alabama | 1031 | 7 | 0 |
35612 | 35612 | 2020-04-06 | Coffee | Alabama | 1031 | 8 | 0 |
38100 | 38100 | 2020-04-07 | Coffee | Alabama | 1031 | 8 | 0 |
40642 | 40642 | 2020-04-08 | Coffee | Alabama | 1031 | 12 | 0 |
43215 | 43215 | 2020-04-09 | Coffee | Alabama | 1031 | 14 | 0 |
45813 | 45813 | 2020-04-10 | Coffee | Alabama | 1031 | 14 | 0 |
48442 | 48442 | 2020-04-11 | Coffee | Alabama | 1031 | 20 | 0 |
51103 | 51103 | 2020-04-12 | Coffee | Alabama | 1031 | 32 | 0 |
53781 | 53781 | 2020-04-13 | Coffee | Alabama | 1031 | 36 | 0 |
56473 | 56473 | 2020-04-14 | Coffee | Alabama | 1031 | 36 | 0 |
59181 | 59181 | 2020-04-15 | Coffee | Alabama | 1031 | 43 | 0 |
61899 | 61899 | 2020-04-16 | Coffee | Alabama | 1031 | 50 | 0 |
64632 | 64632 | 2020-04-17 | Coffee | Alabama | 1031 | 50 | 0 |
67380 | 67380 | 2020-04-18 | Coffee | Alabama | 1031 | 56 | 0 |
70142 | 70142 | 2020-04-19 | Coffee | Alabama | 1031 | 59 | 0 |
72911 | 72911 | 2020-04-20 | Coffee | Alabama | 1031 | 64 | 0 |
75687 | 75687 | 2020-04-21 | Coffee | Alabama | 1031 | 68 | 1 |
78470 | 78470 | 2020-04-22 | Coffee | Alabama | 1031 | 73 | 1 |
81263 | 81263 | 2020-04-23 | Coffee | Alabama | 1031 | 80 | 1 |
84064 | 84064 | 2020-04-24 | Coffee | Alabama | 1031 | 87 | 0 |
86872 | 86872 | 2020-04-25 | Coffee | Alabama | 1031 | 88 | 0 |
89688 | 89688 | 2020-04-26 | Coffee | Alabama | 1031 | 95 | 0 |
92506 | 92506 | 2020-04-27 | Coffee | Alabama | 1031 | 98 | 0 |
95336 | 95336 | 2020-04-28 | Coffee | Alabama | 1031 | 105 | 0 |
98181 | 98181 | 2020-04-29 | Coffee | Alabama | 1031 | 107 | 0 |
101031 | 101031 | 2020-04-30 | Coffee | Alabama | 1031 | 111 | 0 |
103886 | 103886 | 2020-05-01 | Coffee | Alabama | 1031 | 117 | 0 |
106751 | 106751 | 2020-05-02 | Coffee | Alabama | 1031 | 118 | 0 |
109620 | 109620 | 2020-05-03 | Coffee | Alabama | 1031 | 130 | 0 |
112495 | 112495 | 2020-05-04 | Coffee | Alabama | 1031 | 134 | 0 |
115378 | 115378 | 2020-05-05 | Coffee | Alabama | 1031 | 134 | 0 |
118337 | 118337 | 2020-05-06 | Coffee | Alabama | 1031 | 138 | 0 |
121303 | 121303 | 2020-05-07 | Coffee | Alabama | 1031 | 141 | 0 |
124283 | 124283 | 2020-05-08 | Coffee | Alabama | 1031 | 143 | 0 |
127268 | 127268 | 2020-05-09 | Coffee | Alabama | 1031 | 146 | 0 |
130258 | 130258 | 2020-05-10 | Coffee | Alabama | 1031 | 146 | 0 |
133248 | 133248 | 2020-05-11 | Coffee | Alabama | 1031 | 150 | 0 |
136238 | 136238 | 2020-05-12 | Coffee | Alabama | 1031 | 155 | 1 |
139229 | 139229 | 2020-05-13 | Coffee | Alabama | 1031 | 158 | 1 |
142225 | 142225 | 2020-05-14 | Coffee | Alabama | 1031 | 159 | 1 |
145224 | 145224 | 2020-05-15 | Coffee | Alabama | 1031 | 162 | 1 |
148227 | 148227 | 2020-05-16 | Coffee | Alabama | 1031 | 164 | 1 |
151236 | 151236 | 2020-05-17 | Coffee | Alabama | 1031 | 166 | 1 |
154248 | 154248 | 2020-05-18 | Coffee | Alabama | 1031 | 171 | 1 |
157264 | 157264 | 2020-05-19 | Coffee | Alabama | 1031 | 175 | 1 |
160288 | 160288 | 2020-05-20 | Coffee | Alabama | 1031 | 184 | 1 |
163316 | 163316 | 2020-05-21 | Coffee | Alabama | 1031 | 184 | 1 |
166348 | 166348 | 2020-05-22 | Coffee | Alabama | 1031 | 189 | 1 |
169384 | 169384 | 2020-05-23 | Coffee | Alabama | 1031 | 196 | 1 |
172425 | 172425 | 2020-05-24 | Coffee | Alabama | 1031 | 200 | 1 |
175468 | 175468 | 2020-05-25 | Coffee | Alabama | 1031 | 206 | 1 |
178513 | 178513 | 2020-05-26 | Coffee | Alabama | 1031 | 216 | 1 |
181557 | 181557 | 2020-05-27 | Coffee | Alabama | 1031 | 219 | 1 |
184609 | 184609 | 2020-05-28 | Coffee | Alabama | 1031 | 224 | 1 |
187666 | 187666 | 2020-05-29 | Coffee | Alabama | 1031 | 226 | 1 |
190730 | 190730 | 2020-05-30 | Coffee | Alabama | 1031 | 229 | 1 |
193796 | 193796 | 2020-05-31 | Coffee | Alabama | 1031 | 236 | 1 |
196866 | 196866 | 2020-06-01 | Coffee | Alabama | 1031 | 241 | 1 |
199939 | 199939 | 2020-06-02 | Coffee | Alabama | 1031 | 241 | 1 |
203015 | 203015 | 2020-06-03 | Coffee | Alabama | 1031 | 242 | 1 |
206094 | 206094 | 2020-06-04 | Coffee | Alabama | 1031 | 242 | 1 |
209176 | 209176 | 2020-06-05 | Coffee | Alabama | 1031 | 243 | 1 |
212261 | 212261 | 2020-06-06 | Coffee | Alabama | 1031 | 247 | 1 |
215348 | 215348 | 2020-06-07 | Coffee | Alabama | 1031 | 249 | 1 |
218438 | 218438 | 2020-06-08 | Coffee | Alabama | 1031 | 251 | 1 |
221530 | 221530 | 2020-06-09 | Coffee | Alabama | 1031 | 253 | 1 |
224626 | 224626 | 2020-06-10 | Coffee | Alabama | 1031 | 254 | 1 |
227727 | 227727 | 2020-06-11 | Coffee | Alabama | 1031 | 264 | 1 |
230831 | 230831 | 2020-06-12 | Coffee | Alabama | 1031 | 269 | 1 |
233936 | 233936 | 2020-06-13 | Coffee | Alabama | 1031 | 278 | 1 |
237043 | 237043 | 2020-06-14 | Coffee | Alabama | 1031 | 286 | 1 |
240151 | 240151 | 2020-06-15 | Coffee | Alabama | 1031 | 294 | 1 |
243262 | 243262 | 2020-06-16 | Coffee | Alabama | 1031 | 300 | 1 |
246375 | 246375 | 2020-06-17 | Coffee | Alabama | 1031 | 301 | 1 |
249487 | 249487 | 2020-06-18 | Coffee | Alabama | 1031 | 304 | 1 |
252602 | 252602 | 2020-06-19 | Coffee | Alabama | 1031 | 314 | 1 |
255721 | 255721 | 2020-06-20 | Coffee | Alabama | 1031 | 315 | 1 |
258848 | 258848 | 2020-06-21 | Coffee | Alabama | 1031 | 317 | 1 |
261975 | 261975 | 2020-06-22 | Coffee | Alabama | 1031 | 317 | 1 |
265104 | 265104 | 2020-06-23 | Coffee | Alabama | 1031 | 319 | 1 |
268233 | 268233 | 2020-06-24 | Coffee | Alabama | 1031 | 330 | 1 |
271367 | 271367 | 2020-06-25 | Coffee | Alabama | 1031 | 330 | 1 |
274507 | 274507 | 2020-06-26 | Coffee | Alabama | 1031 | 338 | 1 |
277655 | 277655 | 2020-06-27 | Coffee | Alabama | 1031 | 343 | 1 |
280803 | 280803 | 2020-06-28 | Coffee | Alabama | 1031 | 344 | 1 |
283949 | 283949 | 2020-06-29 | Coffee | Alabama | 1031 | 351 | 1 |
287095 | 287095 | 2020-06-30 | Coffee | Alabama | 1031 | 357 | 2 |
290245 | 290245 | 2020-07-01 | Coffee | Alabama | 1031 | 358 | 2 |
293398 | 293398 | 2020-07-02 | Coffee | Alabama | 1031 | 364 | 2 |
296553 | 296553 | 2020-07-03 | Coffee | Alabama | 1031 | 375 | 2 |
299715 | 299715 | 2020-07-04 | Coffee | Alabama | 1031 | 378 | 2 |
302879 | 302879 | 2020-07-05 | Coffee | Alabama | 1031 | 382 | 2 |
306043 | 306043 | 2020-07-06 | Coffee | Alabama | 1031 | 386 | 2 |
309212 | 309212 | 2020-07-07 | Coffee | Alabama | 1031 | 391 | 3 |
312381 | 312381 | 2020-07-08 | Coffee | Alabama | 1031 | 397 | 3 |
315556 | 315556 | 2020-07-09 | Coffee | Alabama | 1031 | 412 | 4 |
318729 | 318729 | 2020-07-10 | Coffee | Alabama | 1031 | 421 | 4 |
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);