ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 19001 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
930968 | 930968 | 2021-01-15 | Adair | Iowa | 19001 | 682 | 20 |
927723 | 927723 | 2021-01-14 | Adair | Iowa | 19001 | 681 | 20 |
924477 | 924477 | 2021-01-13 | Adair | Iowa | 19001 | 674 | 20 |
921232 | 921232 | 2021-01-12 | Adair | Iowa | 19001 | 669 | 20 |
917987 | 917987 | 2021-01-11 | Adair | Iowa | 19001 | 662 | 20 |
914742 | 914742 | 2021-01-10 | Adair | Iowa | 19001 | 655 | 20 |
911497 | 911497 | 2021-01-09 | Adair | Iowa | 19001 | 653 | 18 |
908252 | 908252 | 2021-01-08 | Adair | Iowa | 19001 | 646 | 18 |
905006 | 905006 | 2021-01-07 | Adair | Iowa | 19001 | 645 | 17 |
901761 | 901761 | 2021-01-06 | Adair | Iowa | 19001 | 636 | 17 |
898516 | 898516 | 2021-01-05 | Adair | Iowa | 19001 | 621 | 17 |
895271 | 895271 | 2021-01-04 | Adair | Iowa | 19001 | 620 | 17 |
892024 | 892024 | 2021-01-03 | Adair | Iowa | 19001 | 616 | 17 |
888778 | 888778 | 2021-01-02 | Adair | Iowa | 19001 | 614 | 17 |
885532 | 885532 | 2021-01-01 | Adair | Iowa | 19001 | 610 | 17 |
882287 | 882287 | 2020-12-31 | Adair | Iowa | 19001 | 606 | 17 |
879042 | 879042 | 2020-12-30 | Adair | Iowa | 19001 | 603 | 17 |
875797 | 875797 | 2020-12-29 | Adair | Iowa | 19001 | 591 | 17 |
872552 | 872552 | 2020-12-28 | Adair | Iowa | 19001 | 588 | 17 |
869307 | 869307 | 2020-12-27 | Adair | Iowa | 19001 | 581 | 17 |
866062 | 866062 | 2020-12-26 | Adair | Iowa | 19001 | 581 | 17 |
862817 | 862817 | 2020-12-25 | Adair | Iowa | 19001 | 579 | 17 |
859572 | 859572 | 2020-12-24 | Adair | Iowa | 19001 | 566 | 17 |
856327 | 856327 | 2020-12-23 | Adair | Iowa | 19001 | 561 | 17 |
853082 | 853082 | 2020-12-22 | Adair | Iowa | 19001 | 552 | 17 |
849837 | 849837 | 2020-12-21 | Adair | Iowa | 19001 | 551 | 17 |
846592 | 846592 | 2020-12-20 | Adair | Iowa | 19001 | 544 | 17 |
843346 | 843346 | 2020-12-19 | Adair | Iowa | 19001 | 544 | 17 |
840101 | 840101 | 2020-12-18 | Adair | Iowa | 19001 | 538 | 16 |
836856 | 836856 | 2020-12-17 | Adair | Iowa | 19001 | 526 | 16 |
833610 | 833610 | 2020-12-16 | Adair | Iowa | 19001 | 516 | 16 |
830363 | 830363 | 2020-12-15 | Adair | Iowa | 19001 | 513 | 16 |
827117 | 827117 | 2020-12-14 | Adair | Iowa | 19001 | 511 | 16 |
823870 | 823870 | 2020-12-13 | Adair | Iowa | 19001 | 509 | 16 |
820624 | 820624 | 2020-12-12 | Adair | Iowa | 19001 | 509 | 16 |
817378 | 817378 | 2020-12-11 | Adair | Iowa | 19001 | 506 | 16 |
814132 | 814132 | 2020-12-10 | Adair | Iowa | 19001 | 500 | 15 |
810887 | 810887 | 2020-12-09 | Adair | Iowa | 19001 | 491 | 15 |
807642 | 807642 | 2020-12-08 | Adair | Iowa | 19001 | 485 | 15 |
804397 | 804397 | 2020-12-07 | Adair | Iowa | 19001 | 484 | 11 |
801152 | 801152 | 2020-12-06 | Adair | Iowa | 19001 | 484 | 11 |
797907 | 797907 | 2020-12-05 | Adair | Iowa | 19001 | 479 | 10 |
794662 | 794662 | 2020-12-04 | Adair | Iowa | 19001 | 472 | 10 |
791417 | 791417 | 2020-12-03 | Adair | Iowa | 19001 | 453 | 9 |
788172 | 788172 | 2020-12-02 | Adair | Iowa | 19001 | 448 | 9 |
784928 | 784928 | 2020-12-01 | Adair | Iowa | 19001 | 444 | 8 |
781683 | 781683 | 2020-11-30 | Adair | Iowa | 19001 | 441 | 8 |
778437 | 778437 | 2020-11-29 | Adair | Iowa | 19001 | 441 | 8 |
775192 | 775192 | 2020-11-28 | Adair | Iowa | 19001 | 440 | 8 |
771947 | 771947 | 2020-11-27 | Adair | Iowa | 19001 | 429 | 8 |
768702 | 768702 | 2020-11-26 | Adair | Iowa | 19001 | 429 | 8 |
765456 | 765456 | 2020-11-25 | Adair | Iowa | 19001 | 425 | 8 |
762211 | 762211 | 2020-11-24 | Adair | Iowa | 19001 | 421 | 8 |
758966 | 758966 | 2020-11-23 | Adair | Iowa | 19001 | 415 | 7 |
755719 | 755719 | 2020-11-22 | Adair | Iowa | 19001 | 406 | 6 |
752473 | 752473 | 2020-11-21 | Adair | Iowa | 19001 | 405 | 6 |
749227 | 749227 | 2020-11-20 | Adair | Iowa | 19001 | 396 | 6 |
745981 | 745981 | 2020-11-19 | Adair | Iowa | 19001 | 385 | 6 |
742734 | 742734 | 2020-11-18 | Adair | Iowa | 19001 | 377 | 5 |
739487 | 739487 | 2020-11-17 | Adair | Iowa | 19001 | 359 | 5 |
736243 | 736243 | 2020-11-16 | Adair | Iowa | 19001 | 354 | 5 |
732997 | 732997 | 2020-11-15 | Adair | Iowa | 19001 | 345 | 5 |
729752 | 729752 | 2020-11-14 | Adair | Iowa | 19001 | 342 | 5 |
726509 | 726509 | 2020-11-13 | Adair | Iowa | 19001 | 329 | 4 |
723266 | 723266 | 2020-11-12 | Adair | Iowa | 19001 | 316 | 4 |
720023 | 720023 | 2020-11-11 | Adair | Iowa | 19001 | 305 | 4 |
716780 | 716780 | 2020-11-10 | Adair | Iowa | 19001 | 294 | 3 |
713536 | 713536 | 2020-11-09 | Adair | Iowa | 19001 | 290 | 3 |
710292 | 710292 | 2020-11-08 | Adair | Iowa | 19001 | 284 | 3 |
707048 | 707048 | 2020-11-07 | Adair | Iowa | 19001 | 266 | 3 |
703805 | 703805 | 2020-11-06 | Adair | Iowa | 19001 | 261 | 3 |
700563 | 700563 | 2020-11-05 | Adair | Iowa | 19001 | 257 | 3 |
697319 | 697319 | 2020-11-04 | Adair | Iowa | 19001 | 251 | 2 |
694077 | 694077 | 2020-11-03 | Adair | Iowa | 19001 | 250 | 1 |
690834 | 690834 | 2020-11-02 | Adair | Iowa | 19001 | 231 | 1 |
687589 | 687589 | 2020-11-01 | Adair | Iowa | 19001 | 224 | 1 |
684345 | 684345 | 2020-10-31 | Adair | Iowa | 19001 | 220 | 1 |
681102 | 681102 | 2020-10-30 | Adair | Iowa | 19001 | 204 | 1 |
677859 | 677859 | 2020-10-29 | Adair | Iowa | 19001 | 197 | 1 |
674616 | 674616 | 2020-10-28 | Adair | Iowa | 19001 | 191 | 1 |
671374 | 671374 | 2020-10-27 | Adair | Iowa | 19001 | 178 | 1 |
668131 | 668131 | 2020-10-26 | Adair | Iowa | 19001 | 170 | 1 |
664887 | 664887 | 2020-10-25 | Adair | Iowa | 19001 | 161 | 1 |
661642 | 661642 | 2020-10-24 | Adair | Iowa | 19001 | 155 | 1 |
658398 | 658398 | 2020-10-23 | Adair | Iowa | 19001 | 153 | 1 |
655153 | 655153 | 2020-10-22 | Adair | Iowa | 19001 | 150 | 1 |
651908 | 651908 | 2020-10-21 | Adair | Iowa | 19001 | 147 | 1 |
648664 | 648664 | 2020-10-20 | Adair | Iowa | 19001 | 143 | 1 |
645419 | 645419 | 2020-10-19 | Adair | Iowa | 19001 | 134 | 1 |
642172 | 642172 | 2020-10-18 | Adair | Iowa | 19001 | 123 | 1 |
638925 | 638925 | 2020-10-17 | Adair | Iowa | 19001 | 122 | 1 |
635679 | 635679 | 2020-10-16 | Adair | Iowa | 19001 | 117 | 1 |
632433 | 632433 | 2020-10-15 | Adair | Iowa | 19001 | 116 | 1 |
629189 | 629189 | 2020-10-14 | Adair | Iowa | 19001 | 108 | 1 |
625946 | 625946 | 2020-10-13 | Adair | Iowa | 19001 | 103 | 1 |
622704 | 622704 | 2020-10-12 | Adair | Iowa | 19001 | 99 | 1 |
619460 | 619460 | 2020-10-11 | Adair | Iowa | 19001 | 99 | 1 |
616218 | 616218 | 2020-10-10 | Adair | Iowa | 19001 | 97 | 1 |
612977 | 612977 | 2020-10-09 | Adair | Iowa | 19001 | 92 | 1 |
609735 | 609735 | 2020-10-08 | Adair | Iowa | 19001 | 87 | 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);