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 |
---|---|---|---|---|---|---|---|
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 |
729761 | 729761 | 2020-11-14 | Buchanan | Iowa | 19019 | 881 | 6 |
726518 | 726518 | 2020-11-13 | Buchanan | Iowa | 19019 | 853 | 6 |
723275 | 723275 | 2020-11-12 | Buchanan | Iowa | 19019 | 827 | 6 |
720032 | 720032 | 2020-11-11 | Buchanan | Iowa | 19019 | 788 | 6 |
716789 | 716789 | 2020-11-10 | Buchanan | Iowa | 19019 | 755 | 6 |
713545 | 713545 | 2020-11-09 | Buchanan | Iowa | 19019 | 727 | 5 |
710301 | 710301 | 2020-11-08 | Buchanan | Iowa | 19019 | 706 | 5 |
707057 | 707057 | 2020-11-07 | Buchanan | Iowa | 19019 | 676 | 5 |
703814 | 703814 | 2020-11-06 | Buchanan | Iowa | 19019 | 643 | 5 |
700572 | 700572 | 2020-11-05 | Buchanan | Iowa | 19019 | 623 | 5 |
697328 | 697328 | 2020-11-04 | Buchanan | Iowa | 19019 | 594 | 5 |
694086 | 694086 | 2020-11-03 | Buchanan | Iowa | 19019 | 578 | 5 |
690843 | 690843 | 2020-11-02 | Buchanan | Iowa | 19019 | 564 | 5 |
687598 | 687598 | 2020-11-01 | Buchanan | Iowa | 19019 | 555 | 5 |
684354 | 684354 | 2020-10-31 | Buchanan | Iowa | 19019 | 539 | 5 |
681111 | 681111 | 2020-10-30 | Buchanan | Iowa | 19019 | 516 | 5 |
677868 | 677868 | 2020-10-29 | Buchanan | Iowa | 19019 | 489 | 5 |
674625 | 674625 | 2020-10-28 | Buchanan | Iowa | 19019 | 475 | 5 |
671383 | 671383 | 2020-10-27 | Buchanan | Iowa | 19019 | 463 | 5 |
668140 | 668140 | 2020-10-26 | Buchanan | Iowa | 19019 | 454 | 4 |
664896 | 664896 | 2020-10-25 | Buchanan | Iowa | 19019 | 451 | 4 |
661651 | 661651 | 2020-10-24 | Buchanan | Iowa | 19019 | 446 | 4 |
658407 | 658407 | 2020-10-23 | Buchanan | Iowa | 19019 | 434 | 4 |
655162 | 655162 | 2020-10-22 | Buchanan | Iowa | 19019 | 425 | 4 |
651917 | 651917 | 2020-10-21 | Buchanan | Iowa | 19019 | 406 | 4 |
648673 | 648673 | 2020-10-20 | Buchanan | Iowa | 19019 | 403 | 3 |
645428 | 645428 | 2020-10-19 | Buchanan | Iowa | 19019 | 393 | 3 |
642181 | 642181 | 2020-10-18 | Buchanan | Iowa | 19019 | 389 | 3 |
638934 | 638934 | 2020-10-17 | Buchanan | Iowa | 19019 | 388 | 3 |
635688 | 635688 | 2020-10-16 | Buchanan | Iowa | 19019 | 385 | 3 |
632442 | 632442 | 2020-10-15 | Buchanan | Iowa | 19019 | 379 | 3 |
629198 | 629198 | 2020-10-14 | Buchanan | Iowa | 19019 | 366 | 3 |
625955 | 625955 | 2020-10-13 | Buchanan | Iowa | 19019 | 357 | 3 |
622713 | 622713 | 2020-10-12 | Buchanan | Iowa | 19019 | 352 | 2 |
619469 | 619469 | 2020-10-11 | Buchanan | Iowa | 19019 | 351 | 1 |
616227 | 616227 | 2020-10-10 | Buchanan | Iowa | 19019 | 350 | 1 |
612986 | 612986 | 2020-10-09 | Buchanan | Iowa | 19019 | 340 | 1 |
609744 | 609744 | 2020-10-08 | Buchanan | Iowa | 19019 | 334 | 1 |
606501 | 606501 | 2020-10-07 | Buchanan | Iowa | 19019 | 327 | 1 |
603259 | 603259 | 2020-10-06 | Buchanan | Iowa | 19019 | 323 | 1 |
600016 | 600016 | 2020-10-05 | Buchanan | Iowa | 19019 | 317 | 1 |
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);