ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Sioux" and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
606575 | 606575 | 2020-10-07 | Sioux | Iowa | 19167 | 1954 | 6 |
603333 | 603333 | 2020-10-06 | Sioux | Iowa | 19167 | 1910 | 6 |
600090 | 600090 | 2020-10-05 | Sioux | Iowa | 19167 | 1897 | 4 |
596848 | 596848 | 2020-10-04 | Sioux | Iowa | 19167 | 1880 | 4 |
593606 | 593606 | 2020-10-03 | Sioux | Iowa | 19167 | 1859 | 4 |
590365 | 590365 | 2020-10-02 | Sioux | Iowa | 19167 | 1829 | 4 |
587124 | 587124 | 2020-10-01 | Sioux | Iowa | 19167 | 1796 | 4 |
583884 | 583884 | 2020-09-30 | Sioux | Iowa | 19167 | 1753 | 3 |
580645 | 580645 | 2020-09-29 | Sioux | Iowa | 19167 | 1707 | 3 |
577404 | 577404 | 2020-09-28 | Sioux | Iowa | 19167 | 1680 | 3 |
574162 | 574162 | 2020-09-27 | Sioux | Iowa | 19167 | 1646 | 3 |
570919 | 570919 | 2020-09-26 | Sioux | Iowa | 19167 | 1618 | 3 |
567677 | 567677 | 2020-09-25 | Sioux | Iowa | 19167 | 1565 | 3 |
564437 | 564437 | 2020-09-24 | Sioux | Iowa | 19167 | 1504 | 3 |
561197 | 561197 | 2020-09-23 | Sioux | Iowa | 19167 | 1477 | 3 |
557961 | 557961 | 2020-09-22 | Sioux | Iowa | 19167 | 1421 | 3 |
554724 | 554724 | 2020-09-21 | Sioux | Iowa | 19167 | 1372 | 3 |
551485 | 551485 | 2020-09-20 | Sioux | Iowa | 19167 | 1350 | 3 |
548246 | 548246 | 2020-09-19 | Sioux | Iowa | 19167 | 1320 | 3 |
545008 | 545008 | 2020-09-18 | Sioux | Iowa | 19167 | 1275 | 3 |
541772 | 541772 | 2020-09-17 | Sioux | Iowa | 19167 | 1249 | 3 |
538535 | 538535 | 2020-09-16 | Sioux | Iowa | 19167 | 1181 | 3 |
535299 | 535299 | 2020-09-15 | Sioux | Iowa | 19167 | 1137 | 3 |
532064 | 532064 | 2020-09-14 | Sioux | Iowa | 19167 | 1115 | 3 |
528827 | 528827 | 2020-09-13 | Sioux | Iowa | 19167 | 1092 | 3 |
525591 | 525591 | 2020-09-12 | Sioux | Iowa | 19167 | 1069 | 3 |
522355 | 522355 | 2020-09-11 | Sioux | Iowa | 19167 | 1054 | 3 |
519118 | 519118 | 2020-09-10 | Sioux | Iowa | 19167 | 1037 | 3 |
515883 | 515883 | 2020-09-09 | Sioux | Iowa | 19167 | 1013 | 3 |
512650 | 512650 | 2020-09-08 | Sioux | Iowa | 19167 | 1007 | 3 |
509417 | 509417 | 2020-09-07 | Sioux | Iowa | 19167 | 999 | 3 |
506185 | 506185 | 2020-09-06 | Sioux | Iowa | 19167 | 984 | 3 |
502951 | 502951 | 2020-09-05 | Sioux | Iowa | 19167 | 970 | 3 |
499717 | 499717 | 2020-09-04 | Sioux | Iowa | 19167 | 953 | 3 |
496484 | 496484 | 2020-09-03 | Sioux | Iowa | 19167 | 937 | 3 |
493250 | 493250 | 2020-09-02 | Sioux | Iowa | 19167 | 917 | 3 |
490017 | 490017 | 2020-09-01 | Sioux | Iowa | 19167 | 908 | 3 |
486784 | 486784 | 2020-08-31 | Sioux | Iowa | 19167 | 898 | 3 |
483549 | 483549 | 2020-08-30 | Sioux | Iowa | 19167 | 893 | 3 |
480315 | 480315 | 2020-08-29 | Sioux | Iowa | 19167 | 883 | 3 |
477082 | 477082 | 2020-08-28 | Sioux | Iowa | 19167 | 871 | 3 |
473849 | 473849 | 2020-08-27 | Sioux | Iowa | 19167 | 852 | 3 |
470617 | 470617 | 2020-08-26 | Sioux | Iowa | 19167 | 837 | 3 |
467388 | 467388 | 2020-08-25 | Sioux | Iowa | 19167 | 806 | 3 |
464159 | 464159 | 2020-08-24 | Sioux | Iowa | 19167 | 794 | 3 |
460930 | 460930 | 2020-08-23 | Sioux | Iowa | 19167 | 775 | 3 |
457703 | 457703 | 2020-08-22 | Sioux | Iowa | 19167 | 762 | 3 |
454475 | 454475 | 2020-08-21 | Sioux | Iowa | 19167 | 757 | 3 |
451247 | 451247 | 2020-08-20 | Sioux | Iowa | 19167 | 735 | 3 |
448019 | 448019 | 2020-08-19 | Sioux | Iowa | 19167 | 715 | 3 |
444792 | 444792 | 2020-08-18 | Sioux | Iowa | 19167 | 703 | 3 |
441566 | 441566 | 2020-08-17 | Sioux | Iowa | 19167 | 698 | 3 |
438340 | 438340 | 2020-08-16 | Sioux | Iowa | 19167 | 693 | 3 |
435114 | 435114 | 2020-08-15 | Sioux | Iowa | 19167 | 689 | 3 |
431889 | 431889 | 2020-08-14 | Sioux | Iowa | 19167 | 671 | 3 |
428661 | 428661 | 2020-08-13 | Sioux | Iowa | 19167 | 657 | 3 |
425437 | 425437 | 2020-08-12 | Sioux | Iowa | 19167 | 650 | 3 |
422216 | 422216 | 2020-08-11 | Sioux | Iowa | 19167 | 643 | 3 |
418993 | 418993 | 2020-08-10 | Sioux | Iowa | 19167 | 637 | 3 |
415772 | 415772 | 2020-08-09 | Sioux | Iowa | 19167 | 634 | 3 |
412552 | 412552 | 2020-08-08 | Sioux | Iowa | 19167 | 625 | 3 |
409333 | 409333 | 2020-08-07 | Sioux | Iowa | 19167 | 616 | 3 |
406113 | 406113 | 2020-08-06 | Sioux | Iowa | 19167 | 614 | 3 |
402895 | 402895 | 2020-08-05 | Sioux | Iowa | 19167 | 607 | 2 |
399679 | 399679 | 2020-08-04 | Sioux | Iowa | 19167 | 602 | 2 |
396463 | 396463 | 2020-08-03 | Sioux | Iowa | 19167 | 595 | 2 |
393247 | 393247 | 2020-08-02 | Sioux | Iowa | 19167 | 593 | 2 |
390030 | 390030 | 2020-08-01 | Sioux | Iowa | 19167 | 588 | 2 |
386813 | 386813 | 2020-07-31 | Sioux | Iowa | 19167 | 588 | 2 |
383595 | 383595 | 2020-07-30 | Sioux | Iowa | 19167 | 578 | 2 |
380378 | 380378 | 2020-07-29 | Sioux | Iowa | 19167 | 574 | 2 |
377161 | 377161 | 2020-07-28 | Sioux | Iowa | 19167 | 568 | 1 |
373946 | 373946 | 2020-07-27 | Sioux | Iowa | 19167 | 563 | 1 |
370734 | 370734 | 2020-07-26 | Sioux | Iowa | 19167 | 560 | 1 |
367524 | 367524 | 2020-07-25 | Sioux | Iowa | 19167 | 557 | 1 |
364317 | 364317 | 2020-07-24 | Sioux | Iowa | 19167 | 555 | 1 |
361110 | 361110 | 2020-07-23 | Sioux | Iowa | 19167 | 551 | 1 |
357905 | 357905 | 2020-07-22 | Sioux | Iowa | 19167 | 545 | 0 |
354703 | 354703 | 2020-07-21 | Sioux | Iowa | 19167 | 538 | 0 |
351501 | 351501 | 2020-07-20 | Sioux | Iowa | 19167 | 535 | 0 |
348301 | 348301 | 2020-07-19 | Sioux | Iowa | 19167 | 535 | 0 |
345100 | 345100 | 2020-07-18 | Sioux | Iowa | 19167 | 526 | 0 |
341900 | 341900 | 2020-07-17 | Sioux | Iowa | 19167 | 526 | 0 |
338704 | 338704 | 2020-07-16 | Sioux | Iowa | 19167 | 522 | 0 |
335508 | 335508 | 2020-07-15 | Sioux | Iowa | 19167 | 519 | 0 |
332315 | 332315 | 2020-07-14 | Sioux | Iowa | 19167 | 516 | 0 |
329128 | 329128 | 2020-07-13 | Sioux | Iowa | 19167 | 505 | 0 |
325942 | 325942 | 2020-07-12 | Sioux | Iowa | 19167 | 505 | 0 |
322761 | 322761 | 2020-07-11 | Sioux | Iowa | 19167 | 502 | 0 |
319582 | 319582 | 2020-07-10 | Sioux | Iowa | 19167 | 499 | 0 |
316409 | 316409 | 2020-07-09 | Sioux | Iowa | 19167 | 494 | 0 |
313235 | 313235 | 2020-07-08 | Sioux | Iowa | 19167 | 489 | 0 |
310065 | 310065 | 2020-07-07 | Sioux | Iowa | 19167 | 481 | 0 |
306897 | 306897 | 2020-07-06 | Sioux | Iowa | 19167 | 477 | 0 |
303732 | 303732 | 2020-07-05 | Sioux | Iowa | 19167 | 472 | 0 |
300568 | 300568 | 2020-07-04 | Sioux | Iowa | 19167 | 464 | 0 |
297406 | 297406 | 2020-07-03 | Sioux | Iowa | 19167 | 461 | 0 |
294248 | 294248 | 2020-07-02 | Sioux | Iowa | 19167 | 461 | 0 |
291094 | 291094 | 2020-07-01 | Sioux | Iowa | 19167 | 458 | 0 |
287944 | 287944 | 2020-06-30 | Sioux | Iowa | 19167 | 455 | 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);