ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
773 rows where county = "Madison" and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1080325 | 1080325 | 2021-03-02 | Madison | Iowa | 19121 | 1415 | 18 |
1077080 | 1077080 | 2021-03-01 | Madison | Iowa | 19121 | 1410 | 18 |
1073834 | 1073834 | 2021-02-28 | Madison | Iowa | 19121 | 1405 | 18 |
1070588 | 1070588 | 2021-02-27 | Madison | Iowa | 19121 | 1405 | 18 |
1067343 | 1067343 | 2021-02-26 | Madison | Iowa | 19121 | 1405 | 18 |
1064098 | 1064098 | 2021-02-25 | Madison | Iowa | 19121 | 1404 | 18 |
1060853 | 1060853 | 2021-02-24 | Madison | Iowa | 19121 | 1379 | 18 |
1057607 | 1057607 | 2021-02-23 | Madison | Iowa | 19121 | 1379 | 17 |
1054361 | 1054361 | 2021-02-22 | Madison | Iowa | 19121 | 1379 | 17 |
1051114 | 1051114 | 2021-02-21 | Madison | Iowa | 19121 | 1379 | 17 |
1047867 | 1047867 | 2021-02-20 | Madison | Iowa | 19121 | 1379 | 17 |
1044622 | 1044622 | 2021-02-19 | Madison | Iowa | 19121 | 1379 | 17 |
1041377 | 1041377 | 2021-02-18 | Madison | Iowa | 19121 | 1379 | 17 |
1038132 | 1038132 | 2021-02-17 | Madison | Iowa | 19121 | 1376 | 17 |
1034887 | 1034887 | 2021-02-16 | Madison | Iowa | 19121 | 1373 | 17 |
1031641 | 1031641 | 2021-02-15 | Madison | Iowa | 19121 | 1369 | 16 |
1028394 | 1028394 | 2021-02-14 | Madison | Iowa | 19121 | 1362 | 16 |
1025149 | 1025149 | 2021-02-13 | Madison | Iowa | 19121 | 1359 | 16 |
1021904 | 1021904 | 2021-02-12 | Madison | Iowa | 19121 | 1358 | 16 |
1018659 | 1018659 | 2021-02-11 | Madison | Iowa | 19121 | 1352 | 16 |
1015414 | 1015414 | 2021-02-10 | Madison | Iowa | 19121 | 1351 | 16 |
1012169 | 1012169 | 2021-02-09 | Madison | Iowa | 19121 | 1351 | 15 |
1008923 | 1008923 | 2021-02-08 | Madison | Iowa | 19121 | 1346 | 13 |
1005677 | 1005677 | 2021-02-07 | Madison | Iowa | 19121 | 1336 | 13 |
1002431 | 1002431 | 2021-02-06 | Madison | Iowa | 19121 | 1335 | 13 |
999185 | 999185 | 2021-02-05 | Madison | Iowa | 19121 | 1332 | 13 |
995939 | 995939 | 2021-02-04 | Madison | Iowa | 19121 | 1331 | 13 |
992693 | 992693 | 2021-02-03 | Madison | Iowa | 19121 | 1321 | 12 |
989447 | 989447 | 2021-02-02 | Madison | Iowa | 19121 | 1318 | 12 |
986200 | 986200 | 2021-02-01 | Madison | Iowa | 19121 | 1303 | 12 |
982953 | 982953 | 2021-01-31 | Madison | Iowa | 19121 | 1296 | 12 |
979707 | 979707 | 2021-01-30 | Madison | Iowa | 19121 | 1294 | 10 |
976461 | 976461 | 2021-01-29 | Madison | Iowa | 19121 | 1278 | 10 |
973216 | 973216 | 2021-01-28 | Madison | Iowa | 19121 | 1276 | 10 |
969971 | 969971 | 2021-01-27 | Madison | Iowa | 19121 | 1268 | 10 |
966727 | 966727 | 2021-01-26 | Madison | Iowa | 19121 | 1262 | 10 |
963482 | 963482 | 2021-01-25 | Madison | Iowa | 19121 | 1242 | 10 |
960237 | 960237 | 2021-01-24 | Madison | Iowa | 19121 | 1239 | 10 |
956991 | 956991 | 2021-01-23 | Madison | Iowa | 19121 | 1236 | 10 |
953746 | 953746 | 2021-01-22 | Madison | Iowa | 19121 | 1232 | 10 |
950501 | 950501 | 2021-01-21 | Madison | Iowa | 19121 | 1216 | 9 |
947255 | 947255 | 2021-01-20 | Madison | Iowa | 19121 | 1212 | 9 |
944008 | 944008 | 2021-01-19 | Madison | Iowa | 19121 | 1203 | 9 |
940763 | 940763 | 2021-01-18 | Madison | Iowa | 19121 | 1199 | 9 |
937518 | 937518 | 2021-01-17 | Madison | Iowa | 19121 | 1188 | 9 |
934273 | 934273 | 2021-01-16 | Madison | Iowa | 19121 | 1186 | 9 |
931028 | 931028 | 2021-01-15 | Madison | Iowa | 19121 | 1178 | 9 |
927783 | 927783 | 2021-01-14 | Madison | Iowa | 19121 | 1163 | 9 |
924537 | 924537 | 2021-01-13 | Madison | Iowa | 19121 | 1150 | 9 |
921292 | 921292 | 2021-01-12 | Madison | Iowa | 19121 | 1131 | 9 |
918047 | 918047 | 2021-01-11 | Madison | Iowa | 19121 | 1116 | 9 |
914802 | 914802 | 2021-01-10 | Madison | Iowa | 19121 | 1095 | 9 |
911557 | 911557 | 2021-01-09 | Madison | Iowa | 19121 | 1093 | 9 |
908312 | 908312 | 2021-01-08 | Madison | Iowa | 19121 | 1077 | 9 |
905066 | 905066 | 2021-01-07 | Madison | Iowa | 19121 | 1068 | 9 |
901821 | 901821 | 2021-01-06 | Madison | Iowa | 19121 | 1045 | 9 |
898576 | 898576 | 2021-01-05 | Madison | Iowa | 19121 | 1007 | 8 |
895331 | 895331 | 2021-01-04 | Madison | Iowa | 19121 | 999 | 8 |
892084 | 892084 | 2021-01-03 | Madison | Iowa | 19121 | 987 | 8 |
888838 | 888838 | 2021-01-02 | Madison | Iowa | 19121 | 981 | 8 |
885592 | 885592 | 2021-01-01 | Madison | Iowa | 19121 | 975 | 8 |
882347 | 882347 | 2020-12-31 | Madison | Iowa | 19121 | 972 | 8 |
879102 | 879102 | 2020-12-30 | Madison | Iowa | 19121 | 963 | 8 |
875857 | 875857 | 2020-12-29 | Madison | Iowa | 19121 | 952 | 8 |
872612 | 872612 | 2020-12-28 | Madison | Iowa | 19121 | 934 | 8 |
869367 | 869367 | 2020-12-27 | Madison | Iowa | 19121 | 920 | 8 |
866122 | 866122 | 2020-12-26 | Madison | Iowa | 19121 | 918 | 8 |
862877 | 862877 | 2020-12-25 | Madison | Iowa | 19121 | 915 | 8 |
859632 | 859632 | 2020-12-24 | Madison | Iowa | 19121 | 913 | 8 |
856387 | 856387 | 2020-12-23 | Madison | Iowa | 19121 | 904 | 8 |
853142 | 853142 | 2020-12-22 | Madison | Iowa | 19121 | 895 | 8 |
849897 | 849897 | 2020-12-21 | Madison | Iowa | 19121 | 891 | 8 |
846652 | 846652 | 2020-12-20 | Madison | Iowa | 19121 | 884 | 8 |
843406 | 843406 | 2020-12-19 | Madison | Iowa | 19121 | 883 | 8 |
840161 | 840161 | 2020-12-18 | Madison | Iowa | 19121 | 872 | 8 |
836916 | 836916 | 2020-12-17 | Madison | Iowa | 19121 | 854 | 8 |
833670 | 833670 | 2020-12-16 | Madison | Iowa | 19121 | 849 | 8 |
830423 | 830423 | 2020-12-15 | Madison | Iowa | 19121 | 838 | 8 |
827177 | 827177 | 2020-12-14 | Madison | Iowa | 19121 | 832 | 8 |
823930 | 823930 | 2020-12-13 | Madison | Iowa | 19121 | 829 | 8 |
820684 | 820684 | 2020-12-12 | Madison | Iowa | 19121 | 827 | 8 |
817438 | 817438 | 2020-12-11 | Madison | Iowa | 19121 | 819 | 8 |
814192 | 814192 | 2020-12-10 | Madison | Iowa | 19121 | 804 | 8 |
810947 | 810947 | 2020-12-09 | Madison | Iowa | 19121 | 791 | 6 |
807702 | 807702 | 2020-12-08 | Madison | Iowa | 19121 | 779 | 6 |
804457 | 804457 | 2020-12-07 | Madison | Iowa | 19121 | 778 | 5 |
801212 | 801212 | 2020-12-06 | Madison | Iowa | 19121 | 775 | 5 |
797967 | 797967 | 2020-12-05 | Madison | Iowa | 19121 | 767 | 5 |
794722 | 794722 | 2020-12-04 | Madison | Iowa | 19121 | 758 | 5 |
791477 | 791477 | 2020-12-03 | Madison | Iowa | 19121 | 727 | 5 |
788232 | 788232 | 2020-12-02 | Madison | Iowa | 19121 | 717 | 4 |
784988 | 784988 | 2020-12-01 | Madison | Iowa | 19121 | 708 | 4 |
781743 | 781743 | 2020-11-30 | Madison | Iowa | 19121 | 692 | 4 |
778497 | 778497 | 2020-11-29 | Madison | Iowa | 19121 | 685 | 4 |
775252 | 775252 | 2020-11-28 | Madison | Iowa | 19121 | 681 | 4 |
772007 | 772007 | 2020-11-27 | Madison | Iowa | 19121 | 676 | 4 |
768762 | 768762 | 2020-11-26 | Madison | Iowa | 19121 | 673 | 4 |
765516 | 765516 | 2020-11-25 | Madison | Iowa | 19121 | 669 | 4 |
762271 | 762271 | 2020-11-24 | Madison | Iowa | 19121 | 661 | 4 |
759026 | 759026 | 2020-11-23 | Madison | Iowa | 19121 | 647 | 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);