ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Franklin" and fips = 29071 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921969 | 921969 | 2021-01-12 | Franklin | Missouri | 29071 | 7339 | 122 |
918724 | 918724 | 2021-01-11 | Franklin | Missouri | 29071 | 7305 | 116 |
915479 | 915479 | 2021-01-10 | Franklin | Missouri | 29071 | 7267 | 116 |
912234 | 912234 | 2021-01-09 | Franklin | Missouri | 29071 | 7195 | 116 |
908989 | 908989 | 2021-01-08 | Franklin | Missouri | 29071 | 7104 | 116 |
905743 | 905743 | 2021-01-07 | Franklin | Missouri | 29071 | 7001 | 116 |
902498 | 902498 | 2021-01-06 | Franklin | Missouri | 29071 | 6930 | 115 |
899253 | 899253 | 2021-01-05 | Franklin | Missouri | 29071 | 6859 | 115 |
896008 | 896008 | 2021-01-04 | Franklin | Missouri | 29071 | 6819 | 113 |
892761 | 892761 | 2021-01-03 | Franklin | Missouri | 29071 | 6819 | 113 |
889515 | 889515 | 2021-01-02 | Franklin | Missouri | 29071 | 6708 | 113 |
886269 | 886269 | 2021-01-01 | Franklin | Missouri | 29071 | 6656 | 113 |
883024 | 883024 | 2020-12-31 | Franklin | Missouri | 29071 | 6556 | 113 |
879779 | 879779 | 2020-12-30 | Franklin | Missouri | 29071 | 6466 | 113 |
876534 | 876534 | 2020-12-29 | Franklin | Missouri | 29071 | 6408 | 113 |
873289 | 873289 | 2020-12-28 | Franklin | Missouri | 29071 | 6363 | 109 |
870044 | 870044 | 2020-12-27 | Franklin | Missouri | 29071 | 6343 | 109 |
866799 | 866799 | 2020-12-26 | Franklin | Missouri | 29071 | 6308 | 109 |
863554 | 863554 | 2020-12-25 | Franklin | Missouri | 29071 | 6271 | 109 |
860309 | 860309 | 2020-12-24 | Franklin | Missouri | 29071 | 6233 | 109 |
857064 | 857064 | 2020-12-23 | Franklin | Missouri | 29071 | 6174 | 109 |
853819 | 853819 | 2020-12-22 | Franklin | Missouri | 29071 | 6134 | 109 |
850574 | 850574 | 2020-12-21 | Franklin | Missouri | 29071 | 6095 | 106 |
847329 | 847329 | 2020-12-20 | Franklin | Missouri | 29071 | 5993 | 106 |
844083 | 844083 | 2020-12-19 | Franklin | Missouri | 29071 | 5970 | 106 |
840838 | 840838 | 2020-12-18 | Franklin | Missouri | 29071 | 5919 | 102 |
837593 | 837593 | 2020-12-17 | Franklin | Missouri | 29071 | 5850 | 102 |
834347 | 834347 | 2020-12-16 | Franklin | Missouri | 29071 | 5775 | 102 |
831100 | 831100 | 2020-12-15 | Franklin | Missouri | 29071 | 5730 | 101 |
827854 | 827854 | 2020-12-14 | Franklin | Missouri | 29071 | 5690 | 96 |
824607 | 824607 | 2020-12-13 | Franklin | Missouri | 29071 | 5633 | 96 |
821361 | 821361 | 2020-12-12 | Franklin | Missouri | 29071 | 5584 | 96 |
818115 | 818115 | 2020-12-11 | Franklin | Missouri | 29071 | 5458 | 95 |
814869 | 814869 | 2020-12-10 | Franklin | Missouri | 29071 | 5458 | 95 |
811624 | 811624 | 2020-12-09 | Franklin | Missouri | 29071 | 5380 | 95 |
808379 | 808379 | 2020-12-08 | Franklin | Missouri | 29071 | 5341 | 95 |
805134 | 805134 | 2020-12-07 | Franklin | Missouri | 29071 | 5288 | 91 |
801889 | 801889 | 2020-12-06 | Franklin | Missouri | 29071 | 5221 | 91 |
798644 | 798644 | 2020-12-05 | Franklin | Missouri | 29071 | 5163 | 90 |
795399 | 795399 | 2020-12-04 | Franklin | Missouri | 29071 | 5102 | 86 |
792154 | 792154 | 2020-12-03 | Franklin | Missouri | 29071 | 5040 | 86 |
788909 | 788909 | 2020-12-02 | Franklin | Missouri | 29071 | 4970 | 86 |
785664 | 785664 | 2020-12-01 | Franklin | Missouri | 29071 | 4930 | 83 |
782420 | 782420 | 2020-11-30 | Franklin | Missouri | 29071 | 4886 | 72 |
779174 | 779174 | 2020-11-29 | Franklin | Missouri | 29071 | 4800 | 72 |
775929 | 775929 | 2020-11-28 | Franklin | Missouri | 29071 | 4753 | 72 |
772684 | 772684 | 2020-11-27 | Franklin | Missouri | 29071 | 4736 | 72 |
769439 | 769439 | 2020-11-26 | Franklin | Missouri | 29071 | 4676 | 72 |
766193 | 766193 | 2020-11-25 | Franklin | Missouri | 29071 | 4574 | 71 |
762948 | 762948 | 2020-11-24 | Franklin | Missouri | 29071 | 4507 | 71 |
759703 | 759703 | 2020-11-23 | Franklin | Missouri | 29071 | 4468 | 59 |
756456 | 756456 | 2020-11-22 | Franklin | Missouri | 29071 | 4379 | 59 |
753210 | 753210 | 2020-11-21 | Franklin | Missouri | 29071 | 4330 | 59 |
749964 | 749964 | 2020-11-20 | Franklin | Missouri | 29071 | 4247 | 59 |
746718 | 746718 | 2020-11-19 | Franklin | Missouri | 29071 | 4148 | 58 |
743471 | 743471 | 2020-11-18 | Franklin | Missouri | 29071 | 4067 | 58 |
740224 | 740224 | 2020-11-17 | Franklin | Missouri | 29071 | 4034 | 58 |
736980 | 736980 | 2020-11-16 | Franklin | Missouri | 29071 | 3917 | 58 |
733734 | 733734 | 2020-11-15 | Franklin | Missouri | 29071 | 3836 | 58 |
730489 | 730489 | 2020-11-14 | Franklin | Missouri | 29071 | 3836 | 58 |
727246 | 727246 | 2020-11-13 | Franklin | Missouri | 29071 | 3665 | 57 |
724003 | 724003 | 2020-11-12 | Franklin | Missouri | 29071 | 3631 | 57 |
720760 | 720760 | 2020-11-11 | Franklin | Missouri | 29071 | 3553 | 57 |
717517 | 717517 | 2020-11-10 | Franklin | Missouri | 29071 | 3481 | 57 |
714273 | 714273 | 2020-11-09 | Franklin | Missouri | 29071 | 3385 | 50 |
711029 | 711029 | 2020-11-08 | Franklin | Missouri | 29071 | 3344 | 50 |
707785 | 707785 | 2020-11-07 | Franklin | Missouri | 29071 | 3270 | 50 |
704542 | 704542 | 2020-11-06 | Franklin | Missouri | 29071 | 3175 | 50 |
701300 | 701300 | 2020-11-05 | Franklin | Missouri | 29071 | 3137 | 50 |
698056 | 698056 | 2020-11-04 | Franklin | Missouri | 29071 | 3060 | 50 |
694813 | 694813 | 2020-11-03 | Franklin | Missouri | 29071 | 3022 | 50 |
691571 | 691571 | 2020-11-02 | Franklin | Missouri | 29071 | 2995 | 48 |
688326 | 688326 | 2020-11-01 | Franklin | Missouri | 29071 | 2941 | 48 |
685082 | 685082 | 2020-10-31 | Franklin | Missouri | 29071 | 2879 | 48 |
681839 | 681839 | 2020-10-30 | Franklin | Missouri | 29071 | 2815 | 46 |
678595 | 678595 | 2020-10-29 | Franklin | Missouri | 29071 | 2780 | 46 |
675353 | 675353 | 2020-10-28 | Franklin | Missouri | 29071 | 2723 | 44 |
672110 | 672110 | 2020-10-27 | Franklin | Missouri | 29071 | 2694 | 44 |
668868 | 668868 | 2020-10-26 | Franklin | Missouri | 29071 | 2659 | 44 |
665624 | 665624 | 2020-10-25 | Franklin | Missouri | 29071 | 2610 | 44 |
662379 | 662379 | 2020-10-24 | Franklin | Missouri | 29071 | 2542 | 44 |
659135 | 659135 | 2020-10-23 | Franklin | Missouri | 29071 | 2464 | 43 |
655890 | 655890 | 2020-10-22 | Franklin | Missouri | 29071 | 2433 | 42 |
652645 | 652645 | 2020-10-21 | Franklin | Missouri | 29071 | 2395 | 42 |
649400 | 649400 | 2020-10-20 | Franklin | Missouri | 29071 | 2349 | 40 |
646156 | 646156 | 2020-10-19 | Franklin | Missouri | 29071 | 2349 | 40 |
642910 | 642910 | 2020-10-18 | Franklin | Missouri | 29071 | 2321 | 40 |
639662 | 639662 | 2020-10-17 | Franklin | Missouri | 29071 | 2284 | 40 |
636416 | 636416 | 2020-10-16 | Franklin | Missouri | 29071 | 2240 | 34 |
633170 | 633170 | 2020-10-15 | Franklin | Missouri | 29071 | 2202 | 34 |
629925 | 629925 | 2020-10-14 | Franklin | Missouri | 29071 | 2155 | 35 |
626681 | 626681 | 2020-10-13 | Franklin | Missouri | 29071 | 2073 | 33 |
623439 | 623439 | 2020-10-12 | Franklin | Missouri | 29071 | 2073 | 33 |
620196 | 620196 | 2020-10-11 | Franklin | Missouri | 29071 | 2073 | 33 |
616954 | 616954 | 2020-10-10 | Franklin | Missouri | 29071 | 2073 | 33 |
613713 | 613713 | 2020-10-09 | Franklin | Missouri | 29071 | 2021 | 33 |
610471 | 610471 | 2020-10-08 | Franklin | Missouri | 29071 | 1999 | 32 |
607229 | 607229 | 2020-10-07 | Franklin | Missouri | 29071 | 1972 | 32 |
603986 | 603986 | 2020-10-06 | Franklin | Missouri | 29071 | 1954 | 32 |
600744 | 600744 | 2020-10-05 | Franklin | Missouri | 29071 | 1929 | 32 |
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);