ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
769 rows where fips = 19039 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054320 | 1054320 | 2021-02-22 | Clarke | Iowa | 19039 | 922 | 20 |
1051073 | 1051073 | 2021-02-21 | Clarke | Iowa | 19039 | 922 | 20 |
1047826 | 1047826 | 2021-02-20 | Clarke | Iowa | 19039 | 922 | 20 |
1044581 | 1044581 | 2021-02-19 | Clarke | Iowa | 19039 | 922 | 20 |
1041336 | 1041336 | 2021-02-18 | Clarke | Iowa | 19039 | 922 | 20 |
1038091 | 1038091 | 2021-02-17 | Clarke | Iowa | 19039 | 917 | 20 |
1034846 | 1034846 | 2021-02-16 | Clarke | Iowa | 19039 | 913 | 20 |
1031600 | 1031600 | 2021-02-15 | Clarke | Iowa | 19039 | 911 | 20 |
1028353 | 1028353 | 2021-02-14 | Clarke | Iowa | 19039 | 905 | 20 |
1025108 | 1025108 | 2021-02-13 | Clarke | Iowa | 19039 | 905 | 20 |
1021863 | 1021863 | 2021-02-12 | Clarke | Iowa | 19039 | 905 | 19 |
1018618 | 1018618 | 2021-02-11 | Clarke | Iowa | 19039 | 900 | 19 |
1015373 | 1015373 | 2021-02-10 | Clarke | Iowa | 19039 | 898 | 19 |
1012128 | 1012128 | 2021-02-09 | Clarke | Iowa | 19039 | 893 | 18 |
1008882 | 1008882 | 2021-02-08 | Clarke | Iowa | 19039 | 888 | 18 |
1005636 | 1005636 | 2021-02-07 | Clarke | Iowa | 19039 | 883 | 18 |
1002390 | 1002390 | 2021-02-06 | Clarke | Iowa | 19039 | 880 | 18 |
999144 | 999144 | 2021-02-05 | Clarke | Iowa | 19039 | 879 | 17 |
995898 | 995898 | 2021-02-04 | Clarke | Iowa | 19039 | 876 | 15 |
992652 | 992652 | 2021-02-03 | Clarke | Iowa | 19039 | 872 | 13 |
989406 | 989406 | 2021-02-02 | Clarke | Iowa | 19039 | 868 | 13 |
986159 | 986159 | 2021-02-01 | Clarke | Iowa | 19039 | 855 | 13 |
982912 | 982912 | 2021-01-31 | Clarke | Iowa | 19039 | 850 | 13 |
979666 | 979666 | 2021-01-30 | Clarke | Iowa | 19039 | 849 | 9 |
976420 | 976420 | 2021-01-29 | Clarke | Iowa | 19039 | 835 | 9 |
973175 | 973175 | 2021-01-28 | Clarke | Iowa | 19039 | 830 | 9 |
969930 | 969930 | 2021-01-27 | Clarke | Iowa | 19039 | 823 | 9 |
966686 | 966686 | 2021-01-26 | Clarke | Iowa | 19039 | 821 | 9 |
963441 | 963441 | 2021-01-25 | Clarke | Iowa | 19039 | 819 | 9 |
960196 | 960196 | 2021-01-24 | Clarke | Iowa | 19039 | 812 | 9 |
956950 | 956950 | 2021-01-23 | Clarke | Iowa | 19039 | 810 | 8 |
953705 | 953705 | 2021-01-22 | Clarke | Iowa | 19039 | 808 | 7 |
950460 | 950460 | 2021-01-21 | Clarke | Iowa | 19039 | 801 | 7 |
947214 | 947214 | 2021-01-20 | Clarke | Iowa | 19039 | 798 | 7 |
943967 | 943967 | 2021-01-19 | Clarke | Iowa | 19039 | 795 | 7 |
940722 | 940722 | 2021-01-18 | Clarke | Iowa | 19039 | 792 | 7 |
937477 | 937477 | 2021-01-17 | Clarke | Iowa | 19039 | 784 | 7 |
934232 | 934232 | 2021-01-16 | Clarke | Iowa | 19039 | 781 | 7 |
930987 | 930987 | 2021-01-15 | Clarke | Iowa | 19039 | 775 | 7 |
927742 | 927742 | 2021-01-14 | Clarke | Iowa | 19039 | 771 | 7 |
924496 | 924496 | 2021-01-13 | Clarke | Iowa | 19039 | 767 | 7 |
921251 | 921251 | 2021-01-12 | Clarke | Iowa | 19039 | 760 | 7 |
918006 | 918006 | 2021-01-11 | Clarke | Iowa | 19039 | 746 | 7 |
914761 | 914761 | 2021-01-10 | Clarke | Iowa | 19039 | 739 | 7 |
911516 | 911516 | 2021-01-09 | Clarke | Iowa | 19039 | 737 | 7 |
908271 | 908271 | 2021-01-08 | Clarke | Iowa | 19039 | 737 | 7 |
905025 | 905025 | 2021-01-07 | Clarke | Iowa | 19039 | 734 | 7 |
901780 | 901780 | 2021-01-06 | Clarke | Iowa | 19039 | 726 | 7 |
898535 | 898535 | 2021-01-05 | Clarke | Iowa | 19039 | 719 | 6 |
895290 | 895290 | 2021-01-04 | Clarke | Iowa | 19039 | 702 | 6 |
892043 | 892043 | 2021-01-03 | Clarke | Iowa | 19039 | 698 | 6 |
888797 | 888797 | 2021-01-02 | Clarke | Iowa | 19039 | 693 | 6 |
885551 | 885551 | 2021-01-01 | Clarke | Iowa | 19039 | 690 | 6 |
882306 | 882306 | 2020-12-31 | Clarke | Iowa | 19039 | 687 | 6 |
879061 | 879061 | 2020-12-30 | Clarke | Iowa | 19039 | 681 | 6 |
875816 | 875816 | 2020-12-29 | Clarke | Iowa | 19039 | 674 | 6 |
872571 | 872571 | 2020-12-28 | Clarke | Iowa | 19039 | 663 | 6 |
869326 | 869326 | 2020-12-27 | Clarke | Iowa | 19039 | 653 | 6 |
866081 | 866081 | 2020-12-26 | Clarke | Iowa | 19039 | 650 | 6 |
862836 | 862836 | 2020-12-25 | Clarke | Iowa | 19039 | 646 | 6 |
859591 | 859591 | 2020-12-24 | Clarke | Iowa | 19039 | 645 | 6 |
856346 | 856346 | 2020-12-23 | Clarke | Iowa | 19039 | 626 | 6 |
853101 | 853101 | 2020-12-22 | Clarke | Iowa | 19039 | 608 | 6 |
849856 | 849856 | 2020-12-21 | Clarke | Iowa | 19039 | 596 | 6 |
846611 | 846611 | 2020-12-20 | Clarke | Iowa | 19039 | 593 | 6 |
843365 | 843365 | 2020-12-19 | Clarke | Iowa | 19039 | 590 | 6 |
840120 | 840120 | 2020-12-18 | Clarke | Iowa | 19039 | 578 | 6 |
836875 | 836875 | 2020-12-17 | Clarke | Iowa | 19039 | 571 | 6 |
833629 | 833629 | 2020-12-16 | Clarke | Iowa | 19039 | 565 | 6 |
830382 | 830382 | 2020-12-15 | Clarke | Iowa | 19039 | 556 | 6 |
827136 | 827136 | 2020-12-14 | Clarke | Iowa | 19039 | 551 | 6 |
823889 | 823889 | 2020-12-13 | Clarke | Iowa | 19039 | 550 | 6 |
820643 | 820643 | 2020-12-12 | Clarke | Iowa | 19039 | 546 | 6 |
817397 | 817397 | 2020-12-11 | Clarke | Iowa | 19039 | 544 | 6 |
814151 | 814151 | 2020-12-10 | Clarke | Iowa | 19039 | 540 | 6 |
810906 | 810906 | 2020-12-09 | Clarke | Iowa | 19039 | 534 | 6 |
807661 | 807661 | 2020-12-08 | Clarke | Iowa | 19039 | 528 | 6 |
804416 | 804416 | 2020-12-07 | Clarke | Iowa | 19039 | 526 | 4 |
801171 | 801171 | 2020-12-06 | Clarke | Iowa | 19039 | 521 | 4 |
797926 | 797926 | 2020-12-05 | Clarke | Iowa | 19039 | 515 | 4 |
794681 | 794681 | 2020-12-04 | Clarke | Iowa | 19039 | 514 | 4 |
791436 | 791436 | 2020-12-03 | Clarke | Iowa | 19039 | 506 | 4 |
788191 | 788191 | 2020-12-02 | Clarke | Iowa | 19039 | 500 | 4 |
784947 | 784947 | 2020-12-01 | Clarke | Iowa | 19039 | 494 | 4 |
781702 | 781702 | 2020-11-30 | Clarke | Iowa | 19039 | 490 | 4 |
778456 | 778456 | 2020-11-29 | Clarke | Iowa | 19039 | 487 | 4 |
775211 | 775211 | 2020-11-28 | Clarke | Iowa | 19039 | 482 | 4 |
771966 | 771966 | 2020-11-27 | Clarke | Iowa | 19039 | 477 | 4 |
768721 | 768721 | 2020-11-26 | Clarke | Iowa | 19039 | 477 | 4 |
765475 | 765475 | 2020-11-25 | Clarke | Iowa | 19039 | 476 | 4 |
762230 | 762230 | 2020-11-24 | Clarke | Iowa | 19039 | 464 | 4 |
758985 | 758985 | 2020-11-23 | Clarke | Iowa | 19039 | 461 | 4 |
755738 | 755738 | 2020-11-22 | Clarke | Iowa | 19039 | 456 | 4 |
752492 | 752492 | 2020-11-21 | Clarke | Iowa | 19039 | 454 | 4 |
749246 | 749246 | 2020-11-20 | Clarke | Iowa | 19039 | 452 | 4 |
746000 | 746000 | 2020-11-19 | Clarke | Iowa | 19039 | 447 | 4 |
742753 | 742753 | 2020-11-18 | Clarke | Iowa | 19039 | 446 | 4 |
739506 | 739506 | 2020-11-17 | Clarke | Iowa | 19039 | 437 | 4 |
736262 | 736262 | 2020-11-16 | Clarke | Iowa | 19039 | 435 | 4 |
733016 | 733016 | 2020-11-15 | Clarke | Iowa | 19039 | 426 | 4 |
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);