ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Adair" and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054301 | 1054301 | 2021-02-22 | Adair | Iowa | 19001 | 790 | 26 |
1051054 | 1051054 | 2021-02-21 | Adair | Iowa | 19001 | 790 | 26 |
1047807 | 1047807 | 2021-02-20 | Adair | Iowa | 19001 | 790 | 26 |
1044562 | 1044562 | 2021-02-19 | Adair | Iowa | 19001 | 790 | 26 |
1041317 | 1041317 | 2021-02-18 | Adair | Iowa | 19001 | 788 | 26 |
1038072 | 1038072 | 2021-02-17 | Adair | Iowa | 19001 | 787 | 26 |
1034827 | 1034827 | 2021-02-16 | Adair | Iowa | 19001 | 780 | 25 |
1031581 | 1031581 | 2021-02-15 | Adair | Iowa | 19001 | 775 | 25 |
1028334 | 1028334 | 2021-02-14 | Adair | Iowa | 19001 | 770 | 25 |
1025089 | 1025089 | 2021-02-13 | Adair | Iowa | 19001 | 762 | 25 |
1021844 | 1021844 | 2021-02-12 | Adair | Iowa | 19001 | 761 | 25 |
1018599 | 1018599 | 2021-02-11 | Adair | Iowa | 19001 | 755 | 25 |
1015354 | 1015354 | 2021-02-10 | Adair | Iowa | 19001 | 729 | 25 |
1012109 | 1012109 | 2021-02-09 | Adair | Iowa | 19001 | 723 | 25 |
1008863 | 1008863 | 2021-02-08 | Adair | Iowa | 19001 | 721 | 25 |
1005617 | 1005617 | 2021-02-07 | Adair | Iowa | 19001 | 721 | 25 |
1002371 | 1002371 | 2021-02-06 | Adair | Iowa | 19001 | 721 | 25 |
999125 | 999125 | 2021-02-05 | Adair | Iowa | 19001 | 720 | 25 |
995879 | 995879 | 2021-02-04 | Adair | Iowa | 19001 | 718 | 24 |
992633 | 992633 | 2021-02-03 | Adair | Iowa | 19001 | 717 | 24 |
989387 | 989387 | 2021-02-02 | Adair | Iowa | 19001 | 710 | 24 |
986140 | 986140 | 2021-02-01 | Adair | Iowa | 19001 | 707 | 24 |
982893 | 982893 | 2021-01-31 | Adair | Iowa | 19001 | 706 | 24 |
979647 | 979647 | 2021-01-30 | Adair | Iowa | 19001 | 705 | 24 |
976401 | 976401 | 2021-01-29 | Adair | Iowa | 19001 | 701 | 23 |
973156 | 973156 | 2021-01-28 | Adair | Iowa | 19001 | 700 | 22 |
969911 | 969911 | 2021-01-27 | Adair | Iowa | 19001 | 699 | 20 |
966667 | 966667 | 2021-01-26 | Adair | Iowa | 19001 | 698 | 20 |
963422 | 963422 | 2021-01-25 | Adair | Iowa | 19001 | 697 | 20 |
960177 | 960177 | 2021-01-24 | Adair | Iowa | 19001 | 696 | 20 |
956931 | 956931 | 2021-01-23 | Adair | Iowa | 19001 | 696 | 20 |
953686 | 953686 | 2021-01-22 | Adair | Iowa | 19001 | 695 | 20 |
950441 | 950441 | 2021-01-21 | Adair | Iowa | 19001 | 693 | 20 |
947195 | 947195 | 2021-01-20 | Adair | Iowa | 19001 | 690 | 20 |
943948 | 943948 | 2021-01-19 | Adair | Iowa | 19001 | 688 | 20 |
940703 | 940703 | 2021-01-18 | Adair | Iowa | 19001 | 687 | 20 |
937458 | 937458 | 2021-01-17 | Adair | Iowa | 19001 | 686 | 20 |
934213 | 934213 | 2021-01-16 | Adair | Iowa | 19001 | 686 | 20 |
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 |
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);