ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Buchanan" and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635688 | 635688 | 2020-10-16 | Buchanan | Iowa | 19019 | 385 | 3 |
632442 | 632442 | 2020-10-15 | Buchanan | Iowa | 19019 | 379 | 3 |
629198 | 629198 | 2020-10-14 | Buchanan | Iowa | 19019 | 366 | 3 |
625955 | 625955 | 2020-10-13 | Buchanan | Iowa | 19019 | 357 | 3 |
622713 | 622713 | 2020-10-12 | Buchanan | Iowa | 19019 | 352 | 2 |
619469 | 619469 | 2020-10-11 | Buchanan | Iowa | 19019 | 351 | 1 |
616227 | 616227 | 2020-10-10 | Buchanan | Iowa | 19019 | 350 | 1 |
612986 | 612986 | 2020-10-09 | Buchanan | Iowa | 19019 | 340 | 1 |
609744 | 609744 | 2020-10-08 | Buchanan | Iowa | 19019 | 334 | 1 |
606501 | 606501 | 2020-10-07 | Buchanan | Iowa | 19019 | 327 | 1 |
603259 | 603259 | 2020-10-06 | Buchanan | Iowa | 19019 | 323 | 1 |
600016 | 600016 | 2020-10-05 | Buchanan | Iowa | 19019 | 317 | 1 |
596774 | 596774 | 2020-10-04 | Buchanan | Iowa | 19019 | 314 | 1 |
593532 | 593532 | 2020-10-03 | Buchanan | Iowa | 19019 | 314 | 1 |
590291 | 590291 | 2020-10-02 | Buchanan | Iowa | 19019 | 310 | 1 |
587050 | 587050 | 2020-10-01 | Buchanan | Iowa | 19019 | 304 | 1 |
583810 | 583810 | 2020-09-30 | Buchanan | Iowa | 19019 | 299 | 1 |
580571 | 580571 | 2020-09-29 | Buchanan | Iowa | 19019 | 292 | 1 |
577330 | 577330 | 2020-09-28 | Buchanan | Iowa | 19019 | 286 | 1 |
574088 | 574088 | 2020-09-27 | Buchanan | Iowa | 19019 | 285 | 1 |
570845 | 570845 | 2020-09-26 | Buchanan | Iowa | 19019 | 279 | 1 |
567603 | 567603 | 2020-09-25 | Buchanan | Iowa | 19019 | 274 | 1 |
564363 | 564363 | 2020-09-24 | Buchanan | Iowa | 19019 | 265 | 1 |
561123 | 561123 | 2020-09-23 | Buchanan | Iowa | 19019 | 262 | 1 |
557887 | 557887 | 2020-09-22 | Buchanan | Iowa | 19019 | 255 | 1 |
554650 | 554650 | 2020-09-21 | Buchanan | Iowa | 19019 | 251 | 1 |
551411 | 551411 | 2020-09-20 | Buchanan | Iowa | 19019 | 242 | 1 |
548172 | 548172 | 2020-09-19 | Buchanan | Iowa | 19019 | 235 | 1 |
544934 | 544934 | 2020-09-18 | Buchanan | Iowa | 19019 | 229 | 1 |
541698 | 541698 | 2020-09-17 | Buchanan | Iowa | 19019 | 224 | 1 |
538461 | 538461 | 2020-09-16 | Buchanan | Iowa | 19019 | 217 | 1 |
535225 | 535225 | 2020-09-15 | Buchanan | Iowa | 19019 | 211 | 1 |
531990 | 531990 | 2020-09-14 | Buchanan | Iowa | 19019 | 208 | 1 |
528753 | 528753 | 2020-09-13 | Buchanan | Iowa | 19019 | 207 | 1 |
525517 | 525517 | 2020-09-12 | Buchanan | Iowa | 19019 | 206 | 1 |
522281 | 522281 | 2020-09-11 | Buchanan | Iowa | 19019 | 203 | 1 |
519044 | 519044 | 2020-09-10 | Buchanan | Iowa | 19019 | 202 | 1 |
515809 | 515809 | 2020-09-09 | Buchanan | Iowa | 19019 | 199 | 1 |
512576 | 512576 | 2020-09-08 | Buchanan | Iowa | 19019 | 192 | 1 |
509343 | 509343 | 2020-09-07 | Buchanan | Iowa | 19019 | 188 | 1 |
506111 | 506111 | 2020-09-06 | Buchanan | Iowa | 19019 | 188 | 1 |
502877 | 502877 | 2020-09-05 | Buchanan | Iowa | 19019 | 189 | 1 |
499643 | 499643 | 2020-09-04 | Buchanan | Iowa | 19019 | 184 | 1 |
496410 | 496410 | 2020-09-03 | Buchanan | Iowa | 19019 | 180 | 1 |
493176 | 493176 | 2020-09-02 | Buchanan | Iowa | 19019 | 176 | 1 |
489943 | 489943 | 2020-09-01 | Buchanan | Iowa | 19019 | 176 | 1 |
486710 | 486710 | 2020-08-31 | Buchanan | Iowa | 19019 | 175 | 1 |
483475 | 483475 | 2020-08-30 | Buchanan | Iowa | 19019 | 174 | 1 |
480241 | 480241 | 2020-08-29 | Buchanan | Iowa | 19019 | 173 | 1 |
477008 | 477008 | 2020-08-28 | Buchanan | Iowa | 19019 | 172 | 1 |
473775 | 473775 | 2020-08-27 | Buchanan | Iowa | 19019 | 170 | 1 |
470543 | 470543 | 2020-08-26 | Buchanan | Iowa | 19019 | 166 | 1 |
467314 | 467314 | 2020-08-25 | Buchanan | Iowa | 19019 | 165 | 1 |
464085 | 464085 | 2020-08-24 | Buchanan | Iowa | 19019 | 164 | 1 |
460856 | 460856 | 2020-08-23 | Buchanan | Iowa | 19019 | 164 | 1 |
457629 | 457629 | 2020-08-22 | Buchanan | Iowa | 19019 | 163 | 1 |
454401 | 454401 | 2020-08-21 | Buchanan | Iowa | 19019 | 164 | 1 |
451173 | 451173 | 2020-08-20 | Buchanan | Iowa | 19019 | 157 | 1 |
447945 | 447945 | 2020-08-19 | Buchanan | Iowa | 19019 | 154 | 1 |
444718 | 444718 | 2020-08-18 | Buchanan | Iowa | 19019 | 151 | 1 |
441492 | 441492 | 2020-08-17 | Buchanan | Iowa | 19019 | 149 | 1 |
438266 | 438266 | 2020-08-16 | Buchanan | Iowa | 19019 | 150 | 1 |
435040 | 435040 | 2020-08-15 | Buchanan | Iowa | 19019 | 146 | 1 |
431815 | 431815 | 2020-08-14 | Buchanan | Iowa | 19019 | 140 | 1 |
428587 | 428587 | 2020-08-13 | Buchanan | Iowa | 19019 | 137 | 1 |
425363 | 425363 | 2020-08-12 | Buchanan | Iowa | 19019 | 130 | 1 |
422142 | 422142 | 2020-08-11 | Buchanan | Iowa | 19019 | 129 | 1 |
418919 | 418919 | 2020-08-10 | Buchanan | Iowa | 19019 | 129 | 1 |
415698 | 415698 | 2020-08-09 | Buchanan | Iowa | 19019 | 127 | 1 |
412478 | 412478 | 2020-08-08 | Buchanan | Iowa | 19019 | 124 | 1 |
409259 | 409259 | 2020-08-07 | Buchanan | Iowa | 19019 | 124 | 1 |
406039 | 406039 | 2020-08-06 | Buchanan | Iowa | 19019 | 123 | 1 |
402821 | 402821 | 2020-08-05 | Buchanan | Iowa | 19019 | 118 | 1 |
399605 | 399605 | 2020-08-04 | Buchanan | Iowa | 19019 | 114 | 1 |
396389 | 396389 | 2020-08-03 | Buchanan | Iowa | 19019 | 111 | 1 |
393173 | 393173 | 2020-08-02 | Buchanan | Iowa | 19019 | 110 | 1 |
389956 | 389956 | 2020-08-01 | Buchanan | Iowa | 19019 | 108 | 1 |
386739 | 386739 | 2020-07-31 | Buchanan | Iowa | 19019 | 105 | 1 |
383521 | 383521 | 2020-07-30 | Buchanan | Iowa | 19019 | 103 | 1 |
380304 | 380304 | 2020-07-29 | Buchanan | Iowa | 19019 | 95 | 1 |
377087 | 377087 | 2020-07-28 | Buchanan | Iowa | 19019 | 94 | 1 |
373872 | 373872 | 2020-07-27 | Buchanan | Iowa | 19019 | 91 | 1 |
370660 | 370660 | 2020-07-26 | Buchanan | Iowa | 19019 | 90 | 1 |
367450 | 367450 | 2020-07-25 | Buchanan | Iowa | 19019 | 88 | 1 |
364243 | 364243 | 2020-07-24 | Buchanan | Iowa | 19019 | 87 | 1 |
361036 | 361036 | 2020-07-23 | Buchanan | Iowa | 19019 | 84 | 1 |
357831 | 357831 | 2020-07-22 | Buchanan | Iowa | 19019 | 81 | 1 |
354629 | 354629 | 2020-07-21 | Buchanan | Iowa | 19019 | 77 | 1 |
351427 | 351427 | 2020-07-20 | Buchanan | Iowa | 19019 | 76 | 1 |
348227 | 348227 | 2020-07-19 | Buchanan | Iowa | 19019 | 74 | 1 |
345026 | 345026 | 2020-07-18 | Buchanan | Iowa | 19019 | 71 | 1 |
341826 | 341826 | 2020-07-17 | Buchanan | Iowa | 19019 | 69 | 1 |
338630 | 338630 | 2020-07-16 | Buchanan | Iowa | 19019 | 68 | 1 |
335434 | 335434 | 2020-07-15 | Buchanan | Iowa | 19019 | 66 | 1 |
332241 | 332241 | 2020-07-14 | Buchanan | Iowa | 19019 | 66 | 1 |
329054 | 329054 | 2020-07-13 | Buchanan | Iowa | 19019 | 65 | 1 |
325868 | 325868 | 2020-07-12 | Buchanan | Iowa | 19019 | 65 | 1 |
322687 | 322687 | 2020-07-11 | Buchanan | Iowa | 19019 | 63 | 1 |
319508 | 319508 | 2020-07-10 | Buchanan | Iowa | 19019 | 62 | 1 |
316335 | 316335 | 2020-07-09 | Buchanan | Iowa | 19019 | 61 | 1 |
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);