ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
741 rows where county = "Monroe" and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193971 | 1193971 | 2021-04-06 | Monroe | Iowa | 19135 | 924 | 28 |
1190721 | 1190721 | 2021-04-05 | Monroe | Iowa | 19135 | 920 | 28 |
1187474 | 1187474 | 2021-04-04 | Monroe | Iowa | 19135 | 920 | 28 |
1184227 | 1184227 | 2021-04-03 | Monroe | Iowa | 19135 | 920 | 28 |
1180980 | 1180980 | 2021-04-02 | Monroe | Iowa | 19135 | 918 | 28 |
1177733 | 1177733 | 2021-04-01 | Monroe | Iowa | 19135 | 917 | 28 |
1174486 | 1174486 | 2021-03-31 | Monroe | Iowa | 19135 | 917 | 28 |
1171239 | 1171239 | 2021-03-30 | Monroe | Iowa | 19135 | 916 | 28 |
1167991 | 1167991 | 2021-03-29 | Monroe | Iowa | 19135 | 913 | 28 |
1164743 | 1164743 | 2021-03-28 | Monroe | Iowa | 19135 | 913 | 28 |
1161495 | 1161495 | 2021-03-27 | Monroe | Iowa | 19135 | 913 | 28 |
1158247 | 1158247 | 2021-03-26 | Monroe | Iowa | 19135 | 913 | 28 |
1155000 | 1155000 | 2021-03-25 | Monroe | Iowa | 19135 | 913 | 28 |
1151753 | 1151753 | 2021-03-24 | Monroe | Iowa | 19135 | 913 | 28 |
1148506 | 1148506 | 2021-03-23 | Monroe | Iowa | 19135 | 912 | 28 |
1145259 | 1145259 | 2021-03-22 | Monroe | Iowa | 19135 | 912 | 28 |
1142012 | 1142012 | 2021-03-21 | Monroe | Iowa | 19135 | 912 | 28 |
1138766 | 1138766 | 2021-03-20 | Monroe | Iowa | 19135 | 912 | 28 |
1135520 | 1135520 | 2021-03-19 | Monroe | Iowa | 19135 | 912 | 28 |
1132273 | 1132273 | 2021-03-18 | Monroe | Iowa | 19135 | 912 | 28 |
1129025 | 1129025 | 2021-03-17 | Monroe | Iowa | 19135 | 909 | 28 |
1125779 | 1125779 | 2021-03-16 | Monroe | Iowa | 19135 | 906 | 28 |
1122533 | 1122533 | 2021-03-15 | Monroe | Iowa | 19135 | 906 | 28 |
1119286 | 1119286 | 2021-03-14 | Monroe | Iowa | 19135 | 906 | 28 |
1116039 | 1116039 | 2021-03-13 | Monroe | Iowa | 19135 | 905 | 28 |
1112793 | 1112793 | 2021-03-12 | Monroe | Iowa | 19135 | 905 | 28 |
1109547 | 1109547 | 2021-03-11 | Monroe | Iowa | 19135 | 905 | 28 |
1106301 | 1106301 | 2021-03-10 | Monroe | Iowa | 19135 | 905 | 28 |
1103055 | 1103055 | 2021-03-09 | Monroe | Iowa | 19135 | 900 | 28 |
1099809 | 1099809 | 2021-03-08 | Monroe | Iowa | 19135 | 900 | 28 |
1096561 | 1096561 | 2021-03-07 | Monroe | Iowa | 19135 | 896 | 28 |
1093315 | 1093315 | 2021-03-06 | Monroe | Iowa | 19135 | 896 | 28 |
1090069 | 1090069 | 2021-03-05 | Monroe | Iowa | 19135 | 896 | 28 |
1086824 | 1086824 | 2021-03-04 | Monroe | Iowa | 19135 | 895 | 28 |
1083578 | 1083578 | 2021-03-03 | Monroe | Iowa | 19135 | 893 | 28 |
1080332 | 1080332 | 2021-03-02 | Monroe | Iowa | 19135 | 890 | 28 |
1077087 | 1077087 | 2021-03-01 | Monroe | Iowa | 19135 | 890 | 28 |
1073841 | 1073841 | 2021-02-28 | Monroe | Iowa | 19135 | 889 | 28 |
1070595 | 1070595 | 2021-02-27 | Monroe | Iowa | 19135 | 889 | 28 |
1067350 | 1067350 | 2021-02-26 | Monroe | Iowa | 19135 | 889 | 28 |
1064105 | 1064105 | 2021-02-25 | Monroe | Iowa | 19135 | 885 | 28 |
1060860 | 1060860 | 2021-02-24 | Monroe | Iowa | 19135 | 873 | 28 |
1057614 | 1057614 | 2021-02-23 | Monroe | Iowa | 19135 | 873 | 28 |
1054368 | 1054368 | 2021-02-22 | Monroe | Iowa | 19135 | 873 | 27 |
1051121 | 1051121 | 2021-02-21 | Monroe | Iowa | 19135 | 873 | 27 |
1047874 | 1047874 | 2021-02-20 | Monroe | Iowa | 19135 | 873 | 27 |
1044629 | 1044629 | 2021-02-19 | Monroe | Iowa | 19135 | 873 | 27 |
1041384 | 1041384 | 2021-02-18 | Monroe | Iowa | 19135 | 873 | 27 |
1038139 | 1038139 | 2021-02-17 | Monroe | Iowa | 19135 | 873 | 27 |
1034894 | 1034894 | 2021-02-16 | Monroe | Iowa | 19135 | 872 | 27 |
1031648 | 1031648 | 2021-02-15 | Monroe | Iowa | 19135 | 870 | 27 |
1028401 | 1028401 | 2021-02-14 | Monroe | Iowa | 19135 | 870 | 27 |
1025156 | 1025156 | 2021-02-13 | Monroe | Iowa | 19135 | 869 | 27 |
1021911 | 1021911 | 2021-02-12 | Monroe | Iowa | 19135 | 867 | 27 |
1018666 | 1018666 | 2021-02-11 | Monroe | Iowa | 19135 | 865 | 27 |
1015421 | 1015421 | 2021-02-10 | Monroe | Iowa | 19135 | 865 | 27 |
1012176 | 1012176 | 2021-02-09 | Monroe | Iowa | 19135 | 862 | 26 |
1008930 | 1008930 | 2021-02-08 | Monroe | Iowa | 19135 | 860 | 26 |
1005684 | 1005684 | 2021-02-07 | Monroe | Iowa | 19135 | 857 | 26 |
1002438 | 1002438 | 2021-02-06 | Monroe | Iowa | 19135 | 855 | 26 |
999192 | 999192 | 2021-02-05 | Monroe | Iowa | 19135 | 854 | 26 |
995946 | 995946 | 2021-02-04 | Monroe | Iowa | 19135 | 847 | 26 |
992700 | 992700 | 2021-02-03 | Monroe | Iowa | 19135 | 844 | 26 |
989454 | 989454 | 2021-02-02 | Monroe | Iowa | 19135 | 842 | 26 |
986207 | 986207 | 2021-02-01 | Monroe | Iowa | 19135 | 838 | 26 |
982960 | 982960 | 2021-01-31 | Monroe | Iowa | 19135 | 836 | 26 |
979714 | 979714 | 2021-01-30 | Monroe | Iowa | 19135 | 835 | 20 |
976468 | 976468 | 2021-01-29 | Monroe | Iowa | 19135 | 833 | 20 |
973223 | 973223 | 2021-01-28 | Monroe | Iowa | 19135 | 833 | 20 |
969978 | 969978 | 2021-01-27 | Monroe | Iowa | 19135 | 830 | 20 |
966734 | 966734 | 2021-01-26 | Monroe | Iowa | 19135 | 828 | 20 |
963489 | 963489 | 2021-01-25 | Monroe | Iowa | 19135 | 826 | 20 |
960244 | 960244 | 2021-01-24 | Monroe | Iowa | 19135 | 822 | 20 |
956998 | 956998 | 2021-01-23 | Monroe | Iowa | 19135 | 822 | 20 |
953753 | 953753 | 2021-01-22 | Monroe | Iowa | 19135 | 819 | 19 |
950508 | 950508 | 2021-01-21 | Monroe | Iowa | 19135 | 814 | 19 |
947262 | 947262 | 2021-01-20 | Monroe | Iowa | 19135 | 813 | 19 |
944015 | 944015 | 2021-01-19 | Monroe | Iowa | 19135 | 812 | 18 |
940770 | 940770 | 2021-01-18 | Monroe | Iowa | 19135 | 809 | 18 |
937525 | 937525 | 2021-01-17 | Monroe | Iowa | 19135 | 808 | 18 |
934280 | 934280 | 2021-01-16 | Monroe | Iowa | 19135 | 805 | 18 |
931035 | 931035 | 2021-01-15 | Monroe | Iowa | 19135 | 804 | 18 |
927790 | 927790 | 2021-01-14 | Monroe | Iowa | 19135 | 799 | 18 |
924544 | 924544 | 2021-01-13 | Monroe | Iowa | 19135 | 791 | 18 |
921299 | 921299 | 2021-01-12 | Monroe | Iowa | 19135 | 781 | 18 |
918054 | 918054 | 2021-01-11 | Monroe | Iowa | 19135 | 772 | 18 |
914809 | 914809 | 2021-01-10 | Monroe | Iowa | 19135 | 769 | 18 |
911564 | 911564 | 2021-01-09 | Monroe | Iowa | 19135 | 769 | 18 |
908319 | 908319 | 2021-01-08 | Monroe | Iowa | 19135 | 752 | 18 |
905073 | 905073 | 2021-01-07 | Monroe | Iowa | 19135 | 744 | 17 |
901828 | 901828 | 2021-01-06 | Monroe | Iowa | 19135 | 727 | 17 |
898583 | 898583 | 2021-01-05 | Monroe | Iowa | 19135 | 716 | 17 |
895338 | 895338 | 2021-01-04 | Monroe | Iowa | 19135 | 707 | 17 |
892091 | 892091 | 2021-01-03 | Monroe | Iowa | 19135 | 696 | 17 |
888845 | 888845 | 2021-01-02 | Monroe | Iowa | 19135 | 683 | 17 |
885599 | 885599 | 2021-01-01 | Monroe | Iowa | 19135 | 682 | 17 |
882354 | 882354 | 2020-12-31 | Monroe | Iowa | 19135 | 670 | 17 |
879109 | 879109 | 2020-12-30 | Monroe | Iowa | 19135 | 648 | 16 |
875864 | 875864 | 2020-12-29 | Monroe | Iowa | 19135 | 628 | 16 |
872619 | 872619 | 2020-12-28 | Monroe | Iowa | 19135 | 621 | 16 |
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);