ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Kossuth" and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635733 | 635733 | 2020-10-16 | Kossuth | Iowa | 19109 | 411 | 0 |
632487 | 632487 | 2020-10-15 | Kossuth | Iowa | 19109 | 406 | 0 |
629243 | 629243 | 2020-10-14 | Kossuth | Iowa | 19109 | 396 | 0 |
626000 | 626000 | 2020-10-13 | Kossuth | Iowa | 19109 | 384 | 0 |
622758 | 622758 | 2020-10-12 | Kossuth | Iowa | 19109 | 378 | 0 |
619514 | 619514 | 2020-10-11 | Kossuth | Iowa | 19109 | 374 | 0 |
616272 | 616272 | 2020-10-10 | Kossuth | Iowa | 19109 | 369 | 0 |
613031 | 613031 | 2020-10-09 | Kossuth | Iowa | 19109 | 366 | 0 |
609789 | 609789 | 2020-10-08 | Kossuth | Iowa | 19109 | 352 | 0 |
606546 | 606546 | 2020-10-07 | Kossuth | Iowa | 19109 | 336 | 0 |
603304 | 603304 | 2020-10-06 | Kossuth | Iowa | 19109 | 329 | 0 |
600061 | 600061 | 2020-10-05 | Kossuth | Iowa | 19109 | 326 | 0 |
596819 | 596819 | 2020-10-04 | Kossuth | Iowa | 19109 | 322 | 0 |
593577 | 593577 | 2020-10-03 | Kossuth | Iowa | 19109 | 312 | 0 |
590336 | 590336 | 2020-10-02 | Kossuth | Iowa | 19109 | 308 | 0 |
587095 | 587095 | 2020-10-01 | Kossuth | Iowa | 19109 | 300 | 0 |
583855 | 583855 | 2020-09-30 | Kossuth | Iowa | 19109 | 290 | 0 |
580616 | 580616 | 2020-09-29 | Kossuth | Iowa | 19109 | 286 | 0 |
577375 | 577375 | 2020-09-28 | Kossuth | Iowa | 19109 | 280 | 0 |
574133 | 574133 | 2020-09-27 | Kossuth | Iowa | 19109 | 274 | 0 |
570890 | 570890 | 2020-09-26 | Kossuth | Iowa | 19109 | 270 | 0 |
567648 | 567648 | 2020-09-25 | Kossuth | Iowa | 19109 | 265 | 0 |
564408 | 564408 | 2020-09-24 | Kossuth | Iowa | 19109 | 254 | 0 |
561168 | 561168 | 2020-09-23 | Kossuth | Iowa | 19109 | 250 | 0 |
557932 | 557932 | 2020-09-22 | Kossuth | Iowa | 19109 | 238 | 0 |
554695 | 554695 | 2020-09-21 | Kossuth | Iowa | 19109 | 231 | 0 |
551456 | 551456 | 2020-09-20 | Kossuth | Iowa | 19109 | 219 | 0 |
548217 | 548217 | 2020-09-19 | Kossuth | Iowa | 19109 | 217 | 0 |
544979 | 544979 | 2020-09-18 | Kossuth | Iowa | 19109 | 209 | 0 |
541743 | 541743 | 2020-09-17 | Kossuth | Iowa | 19109 | 198 | 0 |
538506 | 538506 | 2020-09-16 | Kossuth | Iowa | 19109 | 191 | 0 |
535270 | 535270 | 2020-09-15 | Kossuth | Iowa | 19109 | 174 | 0 |
532035 | 532035 | 2020-09-14 | Kossuth | Iowa | 19109 | 167 | 0 |
528798 | 528798 | 2020-09-13 | Kossuth | Iowa | 19109 | 167 | 0 |
525562 | 525562 | 2020-09-12 | Kossuth | Iowa | 19109 | 163 | 0 |
522326 | 522326 | 2020-09-11 | Kossuth | Iowa | 19109 | 158 | 0 |
519089 | 519089 | 2020-09-10 | Kossuth | Iowa | 19109 | 149 | 0 |
515854 | 515854 | 2020-09-09 | Kossuth | Iowa | 19109 | 141 | 0 |
512621 | 512621 | 2020-09-08 | Kossuth | Iowa | 19109 | 140 | 0 |
509388 | 509388 | 2020-09-07 | Kossuth | Iowa | 19109 | 136 | 0 |
506156 | 506156 | 2020-09-06 | Kossuth | Iowa | 19109 | 132 | 0 |
502922 | 502922 | 2020-09-05 | Kossuth | Iowa | 19109 | 130 | 0 |
499688 | 499688 | 2020-09-04 | Kossuth | Iowa | 19109 | 124 | 0 |
496455 | 496455 | 2020-09-03 | Kossuth | Iowa | 19109 | 123 | 0 |
493221 | 493221 | 2020-09-02 | Kossuth | Iowa | 19109 | 122 | 0 |
489988 | 489988 | 2020-09-01 | Kossuth | Iowa | 19109 | 122 | 0 |
486755 | 486755 | 2020-08-31 | Kossuth | Iowa | 19109 | 122 | 0 |
483520 | 483520 | 2020-08-30 | Kossuth | Iowa | 19109 | 121 | 0 |
480286 | 480286 | 2020-08-29 | Kossuth | Iowa | 19109 | 119 | 0 |
477053 | 477053 | 2020-08-28 | Kossuth | Iowa | 19109 | 119 | 0 |
473820 | 473820 | 2020-08-27 | Kossuth | Iowa | 19109 | 117 | 0 |
470588 | 470588 | 2020-08-26 | Kossuth | Iowa | 19109 | 115 | 0 |
467359 | 467359 | 2020-08-25 | Kossuth | Iowa | 19109 | 113 | 0 |
464130 | 464130 | 2020-08-24 | Kossuth | Iowa | 19109 | 113 | 0 |
460901 | 460901 | 2020-08-23 | Kossuth | Iowa | 19109 | 111 | 0 |
457674 | 457674 | 2020-08-22 | Kossuth | Iowa | 19109 | 110 | 0 |
454446 | 454446 | 2020-08-21 | Kossuth | Iowa | 19109 | 110 | 0 |
451218 | 451218 | 2020-08-20 | Kossuth | Iowa | 19109 | 109 | 0 |
447990 | 447990 | 2020-08-19 | Kossuth | Iowa | 19109 | 106 | 0 |
444763 | 444763 | 2020-08-18 | Kossuth | Iowa | 19109 | 107 | 0 |
441537 | 441537 | 2020-08-17 | Kossuth | Iowa | 19109 | 106 | 0 |
438311 | 438311 | 2020-08-16 | Kossuth | Iowa | 19109 | 106 | 0 |
435085 | 435085 | 2020-08-15 | Kossuth | Iowa | 19109 | 103 | 0 |
431860 | 431860 | 2020-08-14 | Kossuth | Iowa | 19109 | 102 | 0 |
428632 | 428632 | 2020-08-13 | Kossuth | Iowa | 19109 | 97 | 0 |
425408 | 425408 | 2020-08-12 | Kossuth | Iowa | 19109 | 95 | 0 |
422187 | 422187 | 2020-08-11 | Kossuth | Iowa | 19109 | 90 | 0 |
418964 | 418964 | 2020-08-10 | Kossuth | Iowa | 19109 | 90 | 0 |
415743 | 415743 | 2020-08-09 | Kossuth | Iowa | 19109 | 91 | 0 |
412523 | 412523 | 2020-08-08 | Kossuth | Iowa | 19109 | 85 | 0 |
409304 | 409304 | 2020-08-07 | Kossuth | Iowa | 19109 | 84 | 0 |
406084 | 406084 | 2020-08-06 | Kossuth | Iowa | 19109 | 83 | 0 |
402866 | 402866 | 2020-08-05 | Kossuth | Iowa | 19109 | 82 | 0 |
399650 | 399650 | 2020-08-04 | Kossuth | Iowa | 19109 | 78 | 0 |
396434 | 396434 | 2020-08-03 | Kossuth | Iowa | 19109 | 78 | 0 |
393218 | 393218 | 2020-08-02 | Kossuth | Iowa | 19109 | 77 | 0 |
390001 | 390001 | 2020-08-01 | Kossuth | Iowa | 19109 | 77 | 0 |
386784 | 386784 | 2020-07-31 | Kossuth | Iowa | 19109 | 76 | 0 |
383566 | 383566 | 2020-07-30 | Kossuth | Iowa | 19109 | 76 | 0 |
380349 | 380349 | 2020-07-29 | Kossuth | Iowa | 19109 | 74 | 0 |
377132 | 377132 | 2020-07-28 | Kossuth | Iowa | 19109 | 72 | 0 |
373917 | 373917 | 2020-07-27 | Kossuth | Iowa | 19109 | 72 | 0 |
370705 | 370705 | 2020-07-26 | Kossuth | Iowa | 19109 | 72 | 0 |
367495 | 367495 | 2020-07-25 | Kossuth | Iowa | 19109 | 72 | 0 |
364288 | 364288 | 2020-07-24 | Kossuth | Iowa | 19109 | 72 | 0 |
361081 | 361081 | 2020-07-23 | Kossuth | Iowa | 19109 | 72 | 0 |
357876 | 357876 | 2020-07-22 | Kossuth | Iowa | 19109 | 73 | 0 |
354674 | 354674 | 2020-07-21 | Kossuth | Iowa | 19109 | 71 | 0 |
351472 | 351472 | 2020-07-20 | Kossuth | Iowa | 19109 | 71 | 0 |
348272 | 348272 | 2020-07-19 | Kossuth | Iowa | 19109 | 68 | 0 |
345071 | 345071 | 2020-07-18 | Kossuth | Iowa | 19109 | 62 | 0 |
341871 | 341871 | 2020-07-17 | Kossuth | Iowa | 19109 | 62 | 0 |
338675 | 338675 | 2020-07-16 | Kossuth | Iowa | 19109 | 60 | 0 |
335479 | 335479 | 2020-07-15 | Kossuth | Iowa | 19109 | 58 | 0 |
332286 | 332286 | 2020-07-14 | Kossuth | Iowa | 19109 | 43 | 0 |
329099 | 329099 | 2020-07-13 | Kossuth | Iowa | 19109 | 43 | 0 |
325913 | 325913 | 2020-07-12 | Kossuth | Iowa | 19109 | 42 | 0 |
322732 | 322732 | 2020-07-11 | Kossuth | Iowa | 19109 | 41 | 0 |
319553 | 319553 | 2020-07-10 | Kossuth | Iowa | 19109 | 42 | 0 |
316380 | 316380 | 2020-07-09 | Kossuth | Iowa | 19109 | 39 | 0 |
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);