ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
768 rows where county = "Franklin" and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921266 | 921266 | 2021-01-12 | Franklin | Iowa | 19069 | 989 | 18 |
918021 | 918021 | 2021-01-11 | Franklin | Iowa | 19069 | 981 | 17 |
914776 | 914776 | 2021-01-10 | Franklin | Iowa | 19069 | 980 | 17 |
911531 | 911531 | 2021-01-09 | Franklin | Iowa | 19069 | 973 | 17 |
908286 | 908286 | 2021-01-08 | Franklin | Iowa | 19069 | 972 | 17 |
905040 | 905040 | 2021-01-07 | Franklin | Iowa | 19069 | 962 | 17 |
901795 | 901795 | 2021-01-06 | Franklin | Iowa | 19069 | 947 | 17 |
898550 | 898550 | 2021-01-05 | Franklin | Iowa | 19069 | 929 | 17 |
895305 | 895305 | 2021-01-04 | Franklin | Iowa | 19069 | 925 | 17 |
892058 | 892058 | 2021-01-03 | Franklin | Iowa | 19069 | 922 | 17 |
888812 | 888812 | 2021-01-02 | Franklin | Iowa | 19069 | 920 | 17 |
885566 | 885566 | 2021-01-01 | Franklin | Iowa | 19069 | 909 | 17 |
882321 | 882321 | 2020-12-31 | Franklin | Iowa | 19069 | 905 | 17 |
879076 | 879076 | 2020-12-30 | Franklin | Iowa | 19069 | 895 | 17 |
875831 | 875831 | 2020-12-29 | Franklin | Iowa | 19069 | 876 | 17 |
872586 | 872586 | 2020-12-28 | Franklin | Iowa | 19069 | 874 | 17 |
869341 | 869341 | 2020-12-27 | Franklin | Iowa | 19069 | 870 | 17 |
866096 | 866096 | 2020-12-26 | Franklin | Iowa | 19069 | 870 | 17 |
862851 | 862851 | 2020-12-25 | Franklin | Iowa | 19069 | 866 | 17 |
859606 | 859606 | 2020-12-24 | Franklin | Iowa | 19069 | 864 | 17 |
856361 | 856361 | 2020-12-23 | Franklin | Iowa | 19069 | 859 | 17 |
853116 | 853116 | 2020-12-22 | Franklin | Iowa | 19069 | 851 | 18 |
849871 | 849871 | 2020-12-21 | Franklin | Iowa | 19069 | 851 | 17 |
846626 | 846626 | 2020-12-20 | Franklin | Iowa | 19069 | 849 | 17 |
843380 | 843380 | 2020-12-19 | Franklin | Iowa | 19069 | 846 | 17 |
840135 | 840135 | 2020-12-18 | Franklin | Iowa | 19069 | 840 | 17 |
836890 | 836890 | 2020-12-17 | Franklin | Iowa | 19069 | 827 | 17 |
833644 | 833644 | 2020-12-16 | Franklin | Iowa | 19069 | 826 | 17 |
830397 | 830397 | 2020-12-15 | Franklin | Iowa | 19069 | 817 | 17 |
827151 | 827151 | 2020-12-14 | Franklin | Iowa | 19069 | 816 | 17 |
823904 | 823904 | 2020-12-13 | Franklin | Iowa | 19069 | 807 | 17 |
820658 | 820658 | 2020-12-12 | Franklin | Iowa | 19069 | 806 | 17 |
817412 | 817412 | 2020-12-11 | Franklin | Iowa | 19069 | 805 | 17 |
814166 | 814166 | 2020-12-10 | Franklin | Iowa | 19069 | 793 | 17 |
810921 | 810921 | 2020-12-09 | Franklin | Iowa | 19069 | 791 | 17 |
807676 | 807676 | 2020-12-08 | Franklin | Iowa | 19069 | 779 | 16 |
804431 | 804431 | 2020-12-07 | Franklin | Iowa | 19069 | 779 | 21 |
801186 | 801186 | 2020-12-06 | Franklin | Iowa | 19069 | 775 | 21 |
797941 | 797941 | 2020-12-05 | Franklin | Iowa | 19069 | 775 | 21 |
794696 | 794696 | 2020-12-04 | Franklin | Iowa | 19069 | 768 | 21 |
791451 | 791451 | 2020-12-03 | Franklin | Iowa | 19069 | 764 | 21 |
788206 | 788206 | 2020-12-02 | Franklin | Iowa | 19069 | 760 | 21 |
784962 | 784962 | 2020-12-01 | Franklin | Iowa | 19069 | 745 | 21 |
781717 | 781717 | 2020-11-30 | Franklin | Iowa | 19069 | 743 | 21 |
778471 | 778471 | 2020-11-29 | Franklin | Iowa | 19069 | 739 | 21 |
775226 | 775226 | 2020-11-28 | Franklin | Iowa | 19069 | 735 | 21 |
771981 | 771981 | 2020-11-27 | Franklin | Iowa | 19069 | 734 | 21 |
768736 | 768736 | 2020-11-26 | Franklin | Iowa | 19069 | 729 | 21 |
765490 | 765490 | 2020-11-25 | Franklin | Iowa | 19069 | 712 | 21 |
762245 | 762245 | 2020-11-24 | Franklin | Iowa | 19069 | 688 | 20 |
759000 | 759000 | 2020-11-23 | Franklin | Iowa | 19069 | 684 | 19 |
755753 | 755753 | 2020-11-22 | Franklin | Iowa | 19069 | 676 | 19 |
752507 | 752507 | 2020-11-21 | Franklin | Iowa | 19069 | 668 | 19 |
749261 | 749261 | 2020-11-20 | Franklin | Iowa | 19069 | 662 | 19 |
746015 | 746015 | 2020-11-19 | Franklin | Iowa | 19069 | 647 | 19 |
742768 | 742768 | 2020-11-18 | Franklin | Iowa | 19069 | 634 | 19 |
739521 | 739521 | 2020-11-17 | Franklin | Iowa | 19069 | 596 | 19 |
736277 | 736277 | 2020-11-16 | Franklin | Iowa | 19069 | 589 | 19 |
733031 | 733031 | 2020-11-15 | Franklin | Iowa | 19069 | 583 | 19 |
729786 | 729786 | 2020-11-14 | Franklin | Iowa | 19069 | 579 | 19 |
726543 | 726543 | 2020-11-13 | Franklin | Iowa | 19069 | 554 | 19 |
723300 | 723300 | 2020-11-12 | Franklin | Iowa | 19069 | 531 | 19 |
720057 | 720057 | 2020-11-11 | Franklin | Iowa | 19069 | 516 | 19 |
716814 | 716814 | 2020-11-10 | Franklin | Iowa | 19069 | 498 | 19 |
713570 | 713570 | 2020-11-09 | Franklin | Iowa | 19069 | 491 | 19 |
710326 | 710326 | 2020-11-08 | Franklin | Iowa | 19069 | 470 | 19 |
707082 | 707082 | 2020-11-07 | Franklin | Iowa | 19069 | 465 | 19 |
703839 | 703839 | 2020-11-06 | Franklin | Iowa | 19069 | 451 | 19 |
700597 | 700597 | 2020-11-05 | Franklin | Iowa | 19069 | 441 | 18 |
697353 | 697353 | 2020-11-04 | Franklin | Iowa | 19069 | 429 | 18 |
694111 | 694111 | 2020-11-03 | Franklin | Iowa | 19069 | 419 | 18 |
690868 | 690868 | 2020-11-02 | Franklin | Iowa | 19069 | 417 | 18 |
687623 | 687623 | 2020-11-01 | Franklin | Iowa | 19069 | 412 | 18 |
684379 | 684379 | 2020-10-31 | Franklin | Iowa | 19069 | 406 | 18 |
681136 | 681136 | 2020-10-30 | Franklin | Iowa | 19069 | 402 | 18 |
677893 | 677893 | 2020-10-29 | Franklin | Iowa | 19069 | 395 | 18 |
674650 | 674650 | 2020-10-28 | Franklin | Iowa | 19069 | 393 | 18 |
671408 | 671408 | 2020-10-27 | Franklin | Iowa | 19069 | 382 | 18 |
668165 | 668165 | 2020-10-26 | Franklin | Iowa | 19069 | 381 | 18 |
664921 | 664921 | 2020-10-25 | Franklin | Iowa | 19069 | 380 | 18 |
661676 | 661676 | 2020-10-24 | Franklin | Iowa | 19069 | 380 | 18 |
658432 | 658432 | 2020-10-23 | Franklin | Iowa | 19069 | 378 | 18 |
655187 | 655187 | 2020-10-22 | Franklin | Iowa | 19069 | 378 | 18 |
651942 | 651942 | 2020-10-21 | Franklin | Iowa | 19069 | 375 | 18 |
648698 | 648698 | 2020-10-20 | Franklin | Iowa | 19069 | 375 | 18 |
645453 | 645453 | 2020-10-19 | Franklin | Iowa | 19069 | 373 | 18 |
642206 | 642206 | 2020-10-18 | Franklin | Iowa | 19069 | 369 | 18 |
638959 | 638959 | 2020-10-17 | Franklin | Iowa | 19069 | 368 | 18 |
635713 | 635713 | 2020-10-16 | Franklin | Iowa | 19069 | 366 | 18 |
632467 | 632467 | 2020-10-15 | Franklin | Iowa | 19069 | 365 | 18 |
629223 | 629223 | 2020-10-14 | Franklin | Iowa | 19069 | 364 | 18 |
625980 | 625980 | 2020-10-13 | Franklin | Iowa | 19069 | 363 | 18 |
622738 | 622738 | 2020-10-12 | Franklin | Iowa | 19069 | 363 | 18 |
619494 | 619494 | 2020-10-11 | Franklin | Iowa | 19069 | 362 | 18 |
616252 | 616252 | 2020-10-10 | Franklin | Iowa | 19069 | 362 | 18 |
613011 | 613011 | 2020-10-09 | Franklin | Iowa | 19069 | 361 | 18 |
609769 | 609769 | 2020-10-08 | Franklin | Iowa | 19069 | 360 | 18 |
606526 | 606526 | 2020-10-07 | Franklin | Iowa | 19069 | 355 | 18 |
603284 | 603284 | 2020-10-06 | Franklin | Iowa | 19069 | 353 | 18 |
600041 | 600041 | 2020-10-05 | Franklin | Iowa | 19069 | 353 | 18 |
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);