ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Woodford" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535123 | 535123 | 2020-09-15 | Woodford | Illinois | 17203 | 368 | 5 |
531888 | 531888 | 2020-09-14 | Woodford | Illinois | 17203 | 361 | 5 |
528651 | 528651 | 2020-09-13 | Woodford | Illinois | 17203 | 351 | 5 |
525415 | 525415 | 2020-09-12 | Woodford | Illinois | 17203 | 348 | 5 |
522179 | 522179 | 2020-09-11 | Woodford | Illinois | 17203 | 343 | 5 |
518942 | 518942 | 2020-09-10 | Woodford | Illinois | 17203 | 340 | 5 |
515707 | 515707 | 2020-09-09 | Woodford | Illinois | 17203 | 335 | 5 |
512474 | 512474 | 2020-09-08 | Woodford | Illinois | 17203 | 331 | 4 |
509241 | 509241 | 2020-09-07 | Woodford | Illinois | 17203 | 328 | 4 |
506009 | 506009 | 2020-09-06 | Woodford | Illinois | 17203 | 327 | 4 |
502775 | 502775 | 2020-09-05 | Woodford | Illinois | 17203 | 316 | 4 |
499541 | 499541 | 2020-09-04 | Woodford | Illinois | 17203 | 305 | 4 |
496308 | 496308 | 2020-09-03 | Woodford | Illinois | 17203 | 295 | 4 |
493074 | 493074 | 2020-09-02 | Woodford | Illinois | 17203 | 289 | 4 |
489841 | 489841 | 2020-09-01 | Woodford | Illinois | 17203 | 281 | 4 |
486608 | 486608 | 2020-08-31 | Woodford | Illinois | 17203 | 280 | 4 |
483373 | 483373 | 2020-08-30 | Woodford | Illinois | 17203 | 273 | 4 |
480139 | 480139 | 2020-08-29 | Woodford | Illinois | 17203 | 269 | 4 |
476906 | 476906 | 2020-08-28 | Woodford | Illinois | 17203 | 265 | 4 |
473673 | 473673 | 2020-08-27 | Woodford | Illinois | 17203 | 257 | 4 |
470441 | 470441 | 2020-08-26 | Woodford | Illinois | 17203 | 254 | 4 |
467212 | 467212 | 2020-08-25 | Woodford | Illinois | 17203 | 250 | 4 |
463983 | 463983 | 2020-08-24 | Woodford | Illinois | 17203 | 247 | 3 |
460754 | 460754 | 2020-08-23 | Woodford | Illinois | 17203 | 237 | 3 |
457527 | 457527 | 2020-08-22 | Woodford | Illinois | 17203 | 235 | 3 |
454299 | 454299 | 2020-08-21 | Woodford | Illinois | 17203 | 229 | 3 |
451071 | 451071 | 2020-08-20 | Woodford | Illinois | 17203 | 219 | 3 |
447843 | 447843 | 2020-08-19 | Woodford | Illinois | 17203 | 209 | 3 |
444616 | 444616 | 2020-08-18 | Woodford | Illinois | 17203 | 204 | 3 |
441390 | 441390 | 2020-08-17 | Woodford | Illinois | 17203 | 191 | 3 |
438164 | 438164 | 2020-08-16 | Woodford | Illinois | 17203 | 186 | 3 |
434938 | 434938 | 2020-08-15 | Woodford | Illinois | 17203 | 184 | 3 |
431713 | 431713 | 2020-08-14 | Woodford | Illinois | 17203 | 175 | 3 |
428485 | 428485 | 2020-08-13 | Woodford | Illinois | 17203 | 175 | 3 |
425261 | 425261 | 2020-08-12 | Woodford | Illinois | 17203 | 172 | 3 |
422040 | 422040 | 2020-08-11 | Woodford | Illinois | 17203 | 165 | 3 |
418817 | 418817 | 2020-08-10 | Woodford | Illinois | 17203 | 155 | 3 |
415596 | 415596 | 2020-08-09 | Woodford | Illinois | 17203 | 151 | 3 |
412376 | 412376 | 2020-08-08 | Woodford | Illinois | 17203 | 146 | 3 |
409157 | 409157 | 2020-08-07 | Woodford | Illinois | 17203 | 138 | 3 |
405937 | 405937 | 2020-08-06 | Woodford | Illinois | 17203 | 128 | 3 |
402719 | 402719 | 2020-08-05 | Woodford | Illinois | 17203 | 123 | 3 |
399503 | 399503 | 2020-08-04 | Woodford | Illinois | 17203 | 108 | 3 |
396287 | 396287 | 2020-08-03 | Woodford | Illinois | 17203 | 100 | 3 |
393071 | 393071 | 2020-08-02 | Woodford | Illinois | 17203 | 95 | 3 |
389854 | 389854 | 2020-08-01 | Woodford | Illinois | 17203 | 91 | 3 |
386637 | 386637 | 2020-07-31 | Woodford | Illinois | 17203 | 89 | 3 |
383419 | 383419 | 2020-07-30 | Woodford | Illinois | 17203 | 86 | 3 |
380202 | 380202 | 2020-07-29 | Woodford | Illinois | 17203 | 80 | 3 |
376985 | 376985 | 2020-07-28 | Woodford | Illinois | 17203 | 77 | 3 |
373770 | 373770 | 2020-07-27 | Woodford | Illinois | 17203 | 75 | 3 |
370558 | 370558 | 2020-07-26 | Woodford | Illinois | 17203 | 71 | 3 |
367348 | 367348 | 2020-07-25 | Woodford | Illinois | 17203 | 69 | 3 |
364141 | 364141 | 2020-07-24 | Woodford | Illinois | 17203 | 68 | 3 |
360934 | 360934 | 2020-07-23 | Woodford | Illinois | 17203 | 68 | 3 |
357729 | 357729 | 2020-07-22 | Woodford | Illinois | 17203 | 68 | 3 |
354527 | 354527 | 2020-07-21 | Woodford | Illinois | 17203 | 66 | 3 |
351325 | 351325 | 2020-07-20 | Woodford | Illinois | 17203 | 66 | 3 |
348125 | 348125 | 2020-07-19 | Woodford | Illinois | 17203 | 64 | 3 |
344924 | 344924 | 2020-07-18 | Woodford | Illinois | 17203 | 63 | 3 |
341724 | 341724 | 2020-07-17 | Woodford | Illinois | 17203 | 60 | 3 |
338528 | 338528 | 2020-07-16 | Woodford | Illinois | 17203 | 58 | 3 |
335332 | 335332 | 2020-07-15 | Woodford | Illinois | 17203 | 57 | 2 |
332139 | 332139 | 2020-07-14 | Woodford | Illinois | 17203 | 54 | 2 |
328952 | 328952 | 2020-07-13 | Woodford | Illinois | 17203 | 54 | 2 |
325766 | 325766 | 2020-07-12 | Woodford | Illinois | 17203 | 48 | 2 |
322585 | 322585 | 2020-07-11 | Woodford | Illinois | 17203 | 46 | 2 |
319406 | 319406 | 2020-07-10 | Woodford | Illinois | 17203 | 46 | 2 |
316233 | 316233 | 2020-07-09 | Woodford | Illinois | 17203 | 43 | 2 |
313059 | 313059 | 2020-07-08 | Woodford | Illinois | 17203 | 39 | 2 |
309889 | 309889 | 2020-07-07 | Woodford | Illinois | 17203 | 38 | 2 |
306721 | 306721 | 2020-07-06 | Woodford | Illinois | 17203 | 36 | 2 |
303556 | 303556 | 2020-07-05 | Woodford | Illinois | 17203 | 35 | 2 |
300392 | 300392 | 2020-07-04 | Woodford | Illinois | 17203 | 35 | 2 |
297230 | 297230 | 2020-07-03 | Woodford | Illinois | 17203 | 35 | 2 |
294072 | 294072 | 2020-07-02 | Woodford | Illinois | 17203 | 35 | 2 |
290918 | 290918 | 2020-07-01 | Woodford | Illinois | 17203 | 34 | 2 |
287768 | 287768 | 2020-06-30 | Woodford | Illinois | 17203 | 34 | 2 |
284619 | 284619 | 2020-06-29 | Woodford | Illinois | 17203 | 34 | 2 |
281474 | 281474 | 2020-06-28 | Woodford | Illinois | 17203 | 34 | 2 |
278326 | 278326 | 2020-06-27 | Woodford | Illinois | 17203 | 34 | 2 |
275178 | 275178 | 2020-06-26 | Woodford | Illinois | 17203 | 34 | 2 |
272036 | 272036 | 2020-06-25 | Woodford | Illinois | 17203 | 34 | 2 |
268899 | 268899 | 2020-06-24 | Woodford | Illinois | 17203 | 33 | 2 |
265769 | 265769 | 2020-06-23 | Woodford | Illinois | 17203 | 33 | 2 |
262641 | 262641 | 2020-06-22 | Woodford | Illinois | 17203 | 33 | 2 |
259514 | 259514 | 2020-06-21 | Woodford | Illinois | 17203 | 33 | 2 |
256388 | 256388 | 2020-06-20 | Woodford | Illinois | 17203 | 33 | 2 |
253268 | 253268 | 2020-06-19 | Woodford | Illinois | 17203 | 32 | 2 |
250153 | 250153 | 2020-06-18 | Woodford | Illinois | 17203 | 31 | 2 |
247041 | 247041 | 2020-06-17 | Woodford | Illinois | 17203 | 31 | 2 |
243928 | 243928 | 2020-06-16 | Woodford | Illinois | 17203 | 29 | 2 |
240817 | 240817 | 2020-06-15 | Woodford | Illinois | 17203 | 28 | 2 |
237709 | 237709 | 2020-06-14 | Woodford | Illinois | 17203 | 25 | 2 |
234602 | 234602 | 2020-06-13 | Woodford | Illinois | 17203 | 25 | 2 |
231496 | 231496 | 2020-06-12 | Woodford | Illinois | 17203 | 24 | 2 |
228393 | 228393 | 2020-06-11 | Woodford | Illinois | 17203 | 24 | 2 |
225291 | 225291 | 2020-06-10 | Woodford | Illinois | 17203 | 23 | 2 |
222196 | 222196 | 2020-06-09 | Woodford | Illinois | 17203 | 23 | 2 |
219101 | 219101 | 2020-06-08 | Woodford | Illinois | 17203 | 23 | 2 |
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);