ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
797 rows where fips = 19103 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054352 | 1054352 | 2021-02-22 | Johnson | Iowa | 19103 | 12906 | 72 |
1051105 | 1051105 | 2021-02-21 | Johnson | Iowa | 19103 | 12906 | 72 |
1047858 | 1047858 | 2021-02-20 | Johnson | Iowa | 19103 | 12906 | 72 |
1044613 | 1044613 | 2021-02-19 | Johnson | Iowa | 19103 | 12906 | 72 |
1041368 | 1041368 | 2021-02-18 | Johnson | Iowa | 19103 | 12902 | 72 |
1038123 | 1038123 | 2021-02-17 | Johnson | Iowa | 19103 | 12882 | 72 |
1034878 | 1034878 | 2021-02-16 | Johnson | Iowa | 19103 | 12863 | 68 |
1031632 | 1031632 | 2021-02-15 | Johnson | Iowa | 19103 | 12840 | 68 |
1028385 | 1028385 | 2021-02-14 | Johnson | Iowa | 19103 | 12830 | 68 |
1025140 | 1025140 | 2021-02-13 | Johnson | Iowa | 19103 | 12811 | 68 |
1021895 | 1021895 | 2021-02-12 | Johnson | Iowa | 19103 | 12797 | 68 |
1018650 | 1018650 | 2021-02-11 | Johnson | Iowa | 19103 | 12758 | 67 |
1015405 | 1015405 | 2021-02-10 | Johnson | Iowa | 19103 | 12752 | 66 |
1012160 | 1012160 | 2021-02-09 | Johnson | Iowa | 19103 | 12716 | 65 |
1008914 | 1008914 | 2021-02-08 | Johnson | Iowa | 19103 | 12693 | 65 |
1005668 | 1005668 | 2021-02-07 | Johnson | Iowa | 19103 | 12669 | 65 |
1002422 | 1002422 | 2021-02-06 | Johnson | Iowa | 19103 | 12653 | 65 |
999176 | 999176 | 2021-02-05 | Johnson | Iowa | 19103 | 12629 | 65 |
995930 | 995930 | 2021-02-04 | Johnson | Iowa | 19103 | 12614 | 65 |
992684 | 992684 | 2021-02-03 | Johnson | Iowa | 19103 | 12582 | 63 |
989438 | 989438 | 2021-02-02 | Johnson | Iowa | 19103 | 12539 | 62 |
986191 | 986191 | 2021-02-01 | Johnson | Iowa | 19103 | 12494 | 62 |
982944 | 982944 | 2021-01-31 | Johnson | Iowa | 19103 | 12470 | 62 |
979698 | 979698 | 2021-01-30 | Johnson | Iowa | 19103 | 12457 | 57 |
976452 | 976452 | 2021-01-29 | Johnson | Iowa | 19103 | 12414 | 56 |
973207 | 973207 | 2021-01-28 | Johnson | Iowa | 19103 | 12404 | 55 |
969962 | 969962 | 2021-01-27 | Johnson | Iowa | 19103 | 12385 | 54 |
966718 | 966718 | 2021-01-26 | Johnson | Iowa | 19103 | 12344 | 53 |
963473 | 963473 | 2021-01-25 | Johnson | Iowa | 19103 | 12317 | 52 |
960228 | 960228 | 2021-01-24 | Johnson | Iowa | 19103 | 12300 | 52 |
956982 | 956982 | 2021-01-23 | Johnson | Iowa | 19103 | 12285 | 52 |
953737 | 953737 | 2021-01-22 | Johnson | Iowa | 19103 | 12246 | 52 |
950492 | 950492 | 2021-01-21 | Johnson | Iowa | 19103 | 12200 | 51 |
947246 | 947246 | 2021-01-20 | Johnson | Iowa | 19103 | 12160 | 51 |
943999 | 943999 | 2021-01-19 | Johnson | Iowa | 19103 | 12118 | 49 |
940754 | 940754 | 2021-01-18 | Johnson | Iowa | 19103 | 12076 | 49 |
937509 | 937509 | 2021-01-17 | Johnson | Iowa | 19103 | 12047 | 49 |
934264 | 934264 | 2021-01-16 | Johnson | Iowa | 19103 | 12022 | 49 |
931019 | 931019 | 2021-01-15 | Johnson | Iowa | 19103 | 11987 | 49 |
927774 | 927774 | 2021-01-14 | Johnson | Iowa | 19103 | 11917 | 49 |
924528 | 924528 | 2021-01-13 | Johnson | Iowa | 19103 | 11856 | 49 |
921283 | 921283 | 2021-01-12 | Johnson | Iowa | 19103 | 11786 | 49 |
918038 | 918038 | 2021-01-11 | Johnson | Iowa | 19103 | 11743 | 49 |
914793 | 914793 | 2021-01-10 | Johnson | Iowa | 19103 | 11684 | 49 |
911548 | 911548 | 2021-01-09 | Johnson | Iowa | 19103 | 11661 | 49 |
908303 | 908303 | 2021-01-08 | Johnson | Iowa | 19103 | 11590 | 49 |
905057 | 905057 | 2021-01-07 | Johnson | Iowa | 19103 | 11531 | 47 |
901812 | 901812 | 2021-01-06 | Johnson | Iowa | 19103 | 11472 | 47 |
898567 | 898567 | 2021-01-05 | Johnson | Iowa | 19103 | 11397 | 47 |
895322 | 895322 | 2021-01-04 | Johnson | Iowa | 19103 | 11339 | 47 |
892075 | 892075 | 2021-01-03 | Johnson | Iowa | 19103 | 11277 | 47 |
888829 | 888829 | 2021-01-02 | Johnson | Iowa | 19103 | 11234 | 47 |
885583 | 885583 | 2021-01-01 | Johnson | Iowa | 19103 | 11186 | 47 |
882338 | 882338 | 2020-12-31 | Johnson | Iowa | 19103 | 11147 | 47 |
879093 | 879093 | 2020-12-30 | Johnson | Iowa | 19103 | 11071 | 47 |
875848 | 875848 | 2020-12-29 | Johnson | Iowa | 19103 | 11007 | 47 |
872603 | 872603 | 2020-12-28 | Johnson | Iowa | 19103 | 10930 | 47 |
869358 | 869358 | 2020-12-27 | Johnson | Iowa | 19103 | 10854 | 47 |
866113 | 866113 | 2020-12-26 | Johnson | Iowa | 19103 | 10817 | 47 |
862868 | 862868 | 2020-12-25 | Johnson | Iowa | 19103 | 10790 | 47 |
859623 | 859623 | 2020-12-24 | Johnson | Iowa | 19103 | 10779 | 47 |
856378 | 856378 | 2020-12-23 | Johnson | Iowa | 19103 | 10744 | 47 |
853133 | 853133 | 2020-12-22 | Johnson | Iowa | 19103 | 10698 | 47 |
849888 | 849888 | 2020-12-21 | Johnson | Iowa | 19103 | 10649 | 45 |
846643 | 846643 | 2020-12-20 | Johnson | Iowa | 19103 | 10607 | 45 |
843397 | 843397 | 2020-12-19 | Johnson | Iowa | 19103 | 10594 | 45 |
840152 | 840152 | 2020-12-18 | Johnson | Iowa | 19103 | 10529 | 45 |
836907 | 836907 | 2020-12-17 | Johnson | Iowa | 19103 | 10476 | 45 |
833661 | 833661 | 2020-12-16 | Johnson | Iowa | 19103 | 10440 | 43 |
830414 | 830414 | 2020-12-15 | Johnson | Iowa | 19103 | 10391 | 43 |
827168 | 827168 | 2020-12-14 | Johnson | Iowa | 19103 | 10355 | 43 |
823921 | 823921 | 2020-12-13 | Johnson | Iowa | 19103 | 10336 | 42 |
820675 | 820675 | 2020-12-12 | Johnson | Iowa | 19103 | 10310 | 42 |
817429 | 817429 | 2020-12-11 | Johnson | Iowa | 19103 | 10267 | 42 |
814183 | 814183 | 2020-12-10 | Johnson | Iowa | 19103 | 10210 | 42 |
810938 | 810938 | 2020-12-09 | Johnson | Iowa | 19103 | 10128 | 39 |
807693 | 807693 | 2020-12-08 | Johnson | Iowa | 19103 | 10071 | 39 |
804448 | 804448 | 2020-12-07 | Johnson | Iowa | 19103 | 10062 | 41 |
801203 | 801203 | 2020-12-06 | Johnson | Iowa | 19103 | 10009 | 41 |
797958 | 797958 | 2020-12-05 | Johnson | Iowa | 19103 | 9976 | 41 |
794713 | 794713 | 2020-12-04 | Johnson | Iowa | 19103 | 9937 | 40 |
791468 | 791468 | 2020-12-03 | Johnson | Iowa | 19103 | 9855 | 39 |
788223 | 788223 | 2020-12-02 | Johnson | Iowa | 19103 | 9793 | 37 |
784979 | 784979 | 2020-12-01 | Johnson | Iowa | 19103 | 9713 | 37 |
781734 | 781734 | 2020-11-30 | Johnson | Iowa | 19103 | 9643 | 37 |
778488 | 778488 | 2020-11-29 | Johnson | Iowa | 19103 | 9552 | 36 |
775243 | 775243 | 2020-11-28 | Johnson | Iowa | 19103 | 9487 | 36 |
771998 | 771998 | 2020-11-27 | Johnson | Iowa | 19103 | 9401 | 36 |
768753 | 768753 | 2020-11-26 | Johnson | Iowa | 19103 | 9355 | 36 |
765507 | 765507 | 2020-11-25 | Johnson | Iowa | 19103 | 9324 | 36 |
762262 | 762262 | 2020-11-24 | Johnson | Iowa | 19103 | 9207 | 35 |
759017 | 759017 | 2020-11-23 | Johnson | Iowa | 19103 | 9117 | 35 |
755770 | 755770 | 2020-11-22 | Johnson | Iowa | 19103 | 9008 | 35 |
752524 | 752524 | 2020-11-21 | Johnson | Iowa | 19103 | 8954 | 35 |
749278 | 749278 | 2020-11-20 | Johnson | Iowa | 19103 | 8820 | 35 |
746032 | 746032 | 2020-11-19 | Johnson | Iowa | 19103 | 8700 | 35 |
742785 | 742785 | 2020-11-18 | Johnson | Iowa | 19103 | 8555 | 35 |
739538 | 739538 | 2020-11-17 | Johnson | Iowa | 19103 | 8433 | 35 |
736294 | 736294 | 2020-11-16 | Johnson | Iowa | 19103 | 8316 | 35 |
733048 | 733048 | 2020-11-15 | Johnson | Iowa | 19103 | 8198 | 35 |
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);