ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Buchanan" and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054310 | 1054310 | 2021-02-22 | Buchanan | Iowa | 19019 | 1732 | 28 |
1051063 | 1051063 | 2021-02-21 | Buchanan | Iowa | 19019 | 1732 | 27 |
1047816 | 1047816 | 2021-02-20 | Buchanan | Iowa | 19019 | 1732 | 27 |
1044571 | 1044571 | 2021-02-19 | Buchanan | Iowa | 19019 | 1732 | 27 |
1041326 | 1041326 | 2021-02-18 | Buchanan | Iowa | 19019 | 1730 | 27 |
1038081 | 1038081 | 2021-02-17 | Buchanan | Iowa | 19019 | 1727 | 27 |
1034836 | 1034836 | 2021-02-16 | Buchanan | Iowa | 19019 | 1725 | 26 |
1031590 | 1031590 | 2021-02-15 | Buchanan | Iowa | 19019 | 1722 | 26 |
1028343 | 1028343 | 2021-02-14 | Buchanan | Iowa | 19019 | 1720 | 26 |
1025098 | 1025098 | 2021-02-13 | Buchanan | Iowa | 19019 | 1718 | 26 |
1021853 | 1021853 | 2021-02-12 | Buchanan | Iowa | 19019 | 1711 | 26 |
1018608 | 1018608 | 2021-02-11 | Buchanan | Iowa | 19019 | 1704 | 26 |
1015363 | 1015363 | 2021-02-10 | Buchanan | Iowa | 19019 | 1702 | 26 |
1012118 | 1012118 | 2021-02-09 | Buchanan | Iowa | 19019 | 1696 | 26 |
1008872 | 1008872 | 2021-02-08 | Buchanan | Iowa | 19019 | 1690 | 26 |
1005626 | 1005626 | 2021-02-07 | Buchanan | Iowa | 19019 | 1688 | 26 |
1002380 | 1002380 | 2021-02-06 | Buchanan | Iowa | 19019 | 1685 | 26 |
999134 | 999134 | 2021-02-05 | Buchanan | Iowa | 19019 | 1684 | 26 |
995888 | 995888 | 2021-02-04 | Buchanan | Iowa | 19019 | 1683 | 25 |
992642 | 992642 | 2021-02-03 | Buchanan | Iowa | 19019 | 1674 | 25 |
989396 | 989396 | 2021-02-02 | Buchanan | Iowa | 19019 | 1669 | 24 |
986149 | 986149 | 2021-02-01 | Buchanan | Iowa | 19019 | 1661 | 24 |
982902 | 982902 | 2021-01-31 | Buchanan | Iowa | 19019 | 1653 | 24 |
979656 | 979656 | 2021-01-30 | Buchanan | Iowa | 19019 | 1652 | 24 |
976410 | 976410 | 2021-01-29 | Buchanan | Iowa | 19019 | 1644 | 24 |
973165 | 973165 | 2021-01-28 | Buchanan | Iowa | 19019 | 1642 | 24 |
969920 | 969920 | 2021-01-27 | Buchanan | Iowa | 19019 | 1640 | 24 |
966676 | 966676 | 2021-01-26 | Buchanan | Iowa | 19019 | 1629 | 24 |
963431 | 963431 | 2021-01-25 | Buchanan | Iowa | 19019 | 1623 | 24 |
960186 | 960186 | 2021-01-24 | Buchanan | Iowa | 19019 | 1622 | 24 |
956940 | 956940 | 2021-01-23 | Buchanan | Iowa | 19019 | 1620 | 24 |
953695 | 953695 | 2021-01-22 | Buchanan | Iowa | 19019 | 1616 | 24 |
950450 | 950450 | 2021-01-21 | Buchanan | Iowa | 19019 | 1610 | 23 |
947204 | 947204 | 2021-01-20 | Buchanan | Iowa | 19019 | 1604 | 23 |
943957 | 943957 | 2021-01-19 | Buchanan | Iowa | 19019 | 1599 | 23 |
940712 | 940712 | 2021-01-18 | Buchanan | Iowa | 19019 | 1591 | 23 |
937467 | 937467 | 2021-01-17 | Buchanan | Iowa | 19019 | 1583 | 23 |
934222 | 934222 | 2021-01-16 | Buchanan | Iowa | 19019 | 1580 | 23 |
930977 | 930977 | 2021-01-15 | Buchanan | Iowa | 19019 | 1578 | 20 |
927732 | 927732 | 2021-01-14 | Buchanan | Iowa | 19019 | 1569 | 20 |
924486 | 924486 | 2021-01-13 | Buchanan | Iowa | 19019 | 1554 | 20 |
921241 | 921241 | 2021-01-12 | Buchanan | Iowa | 19019 | 1548 | 20 |
917996 | 917996 | 2021-01-11 | Buchanan | Iowa | 19019 | 1543 | 19 |
914751 | 914751 | 2021-01-10 | Buchanan | Iowa | 19019 | 1538 | 19 |
911506 | 911506 | 2021-01-09 | Buchanan | Iowa | 19019 | 1526 | 19 |
908261 | 908261 | 2021-01-08 | Buchanan | Iowa | 19019 | 1522 | 19 |
905015 | 905015 | 2021-01-07 | Buchanan | Iowa | 19019 | 1509 | 17 |
901770 | 901770 | 2021-01-06 | Buchanan | Iowa | 19019 | 1496 | 17 |
898525 | 898525 | 2021-01-05 | Buchanan | Iowa | 19019 | 1487 | 17 |
895280 | 895280 | 2021-01-04 | Buchanan | Iowa | 19019 | 1472 | 17 |
892033 | 892033 | 2021-01-03 | Buchanan | Iowa | 19019 | 1462 | 17 |
888787 | 888787 | 2021-01-02 | Buchanan | Iowa | 19019 | 1458 | 17 |
885541 | 885541 | 2021-01-01 | Buchanan | Iowa | 19019 | 1445 | 16 |
882296 | 882296 | 2020-12-31 | Buchanan | Iowa | 19019 | 1441 | 16 |
879051 | 879051 | 2020-12-30 | Buchanan | Iowa | 19019 | 1439 | 16 |
875806 | 875806 | 2020-12-29 | Buchanan | Iowa | 19019 | 1434 | 16 |
872561 | 872561 | 2020-12-28 | Buchanan | Iowa | 19019 | 1414 | 16 |
869316 | 869316 | 2020-12-27 | Buchanan | Iowa | 19019 | 1406 | 16 |
866071 | 866071 | 2020-12-26 | Buchanan | Iowa | 19019 | 1404 | 16 |
862826 | 862826 | 2020-12-25 | Buchanan | Iowa | 19019 | 1403 | 16 |
859581 | 859581 | 2020-12-24 | Buchanan | Iowa | 19019 | 1401 | 16 |
856336 | 856336 | 2020-12-23 | Buchanan | Iowa | 19019 | 1393 | 16 |
853091 | 853091 | 2020-12-22 | Buchanan | Iowa | 19019 | 1385 | 16 |
849846 | 849846 | 2020-12-21 | Buchanan | Iowa | 19019 | 1382 | 16 |
846601 | 846601 | 2020-12-20 | Buchanan | Iowa | 19019 | 1374 | 16 |
843355 | 843355 | 2020-12-19 | Buchanan | Iowa | 19019 | 1370 | 15 |
840110 | 840110 | 2020-12-18 | Buchanan | Iowa | 19019 | 1360 | 15 |
836865 | 836865 | 2020-12-17 | Buchanan | Iowa | 19019 | 1349 | 15 |
833619 | 833619 | 2020-12-16 | Buchanan | Iowa | 19019 | 1340 | 15 |
830372 | 830372 | 2020-12-15 | Buchanan | Iowa | 19019 | 1333 | 15 |
827126 | 827126 | 2020-12-14 | Buchanan | Iowa | 19019 | 1328 | 15 |
823879 | 823879 | 2020-12-13 | Buchanan | Iowa | 19019 | 1324 | 15 |
820633 | 820633 | 2020-12-12 | Buchanan | Iowa | 19019 | 1318 | 15 |
817387 | 817387 | 2020-12-11 | Buchanan | Iowa | 19019 | 1315 | 15 |
814141 | 814141 | 2020-12-10 | Buchanan | Iowa | 19019 | 1305 | 15 |
810896 | 810896 | 2020-12-09 | Buchanan | Iowa | 19019 | 1293 | 15 |
807651 | 807651 | 2020-12-08 | Buchanan | Iowa | 19019 | 1271 | 13 |
804406 | 804406 | 2020-12-07 | Buchanan | Iowa | 19019 | 1272 | 10 |
801161 | 801161 | 2020-12-06 | Buchanan | Iowa | 19019 | 1263 | 10 |
797916 | 797916 | 2020-12-05 | Buchanan | Iowa | 19019 | 1258 | 10 |
794671 | 794671 | 2020-12-04 | Buchanan | Iowa | 19019 | 1251 | 10 |
791426 | 791426 | 2020-12-03 | Buchanan | Iowa | 19019 | 1233 | 10 |
788181 | 788181 | 2020-12-02 | Buchanan | Iowa | 19019 | 1220 | 10 |
784937 | 784937 | 2020-12-01 | Buchanan | Iowa | 19019 | 1209 | 10 |
781692 | 781692 | 2020-11-30 | Buchanan | Iowa | 19019 | 1185 | 10 |
778446 | 778446 | 2020-11-29 | Buchanan | Iowa | 19019 | 1170 | 10 |
775201 | 775201 | 2020-11-28 | Buchanan | Iowa | 19019 | 1164 | 10 |
771956 | 771956 | 2020-11-27 | Buchanan | Iowa | 19019 | 1154 | 10 |
768711 | 768711 | 2020-11-26 | Buchanan | Iowa | 19019 | 1150 | 10 |
765465 | 765465 | 2020-11-25 | Buchanan | Iowa | 19019 | 1141 | 10 |
762220 | 762220 | 2020-11-24 | Buchanan | Iowa | 19019 | 1124 | 9 |
758975 | 758975 | 2020-11-23 | Buchanan | Iowa | 19019 | 1099 | 9 |
755728 | 755728 | 2020-11-22 | Buchanan | Iowa | 19019 | 1078 | 9 |
752482 | 752482 | 2020-11-21 | Buchanan | Iowa | 19019 | 1064 | 9 |
749236 | 749236 | 2020-11-20 | Buchanan | Iowa | 19019 | 1047 | 9 |
745990 | 745990 | 2020-11-19 | Buchanan | Iowa | 19019 | 1026 | 8 |
742743 | 742743 | 2020-11-18 | Buchanan | Iowa | 19019 | 997 | 7 |
739496 | 739496 | 2020-11-17 | Buchanan | Iowa | 19019 | 964 | 7 |
736252 | 736252 | 2020-11-16 | Buchanan | Iowa | 19019 | 938 | 7 |
733006 | 733006 | 2020-11-15 | Buchanan | Iowa | 19019 | 897 | 6 |
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);