ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Franklin" and fips = 22041 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921578 | 921578 | 2021-01-12 | Franklin | Louisiana | 22041 | 2194 | 87 |
918333 | 918333 | 2021-01-11 | Franklin | Louisiana | 22041 | 2184 | 87 |
915088 | 915088 | 2021-01-10 | Franklin | Louisiana | 22041 | 2178 | 87 |
911843 | 911843 | 2021-01-09 | Franklin | Louisiana | 22041 | 2161 | 86 |
908598 | 908598 | 2021-01-08 | Franklin | Louisiana | 22041 | 2161 | 86 |
905352 | 905352 | 2021-01-07 | Franklin | Louisiana | 22041 | 2152 | 85 |
902107 | 902107 | 2021-01-06 | Franklin | Louisiana | 22041 | 2129 | 85 |
898862 | 898862 | 2021-01-05 | Franklin | Louisiana | 22041 | 2122 | 85 |
895617 | 895617 | 2021-01-04 | Franklin | Louisiana | 22041 | 2088 | 83 |
892370 | 892370 | 2021-01-03 | Franklin | Louisiana | 22041 | 2085 | 81 |
889124 | 889124 | 2021-01-02 | Franklin | Louisiana | 22041 | 2044 | 81 |
885878 | 885878 | 2021-01-01 | Franklin | Louisiana | 22041 | 2044 | 81 |
882633 | 882633 | 2020-12-31 | Franklin | Louisiana | 22041 | 2044 | 81 |
879388 | 879388 | 2020-12-30 | Franklin | Louisiana | 22041 | 2020 | 78 |
876143 | 876143 | 2020-12-29 | Franklin | Louisiana | 22041 | 1979 | 78 |
872898 | 872898 | 2020-12-28 | Franklin | Louisiana | 22041 | 1973 | 78 |
869653 | 869653 | 2020-12-27 | Franklin | Louisiana | 22041 | 1969 | 77 |
866408 | 866408 | 2020-12-26 | Franklin | Louisiana | 22041 | 1961 | 76 |
863163 | 863163 | 2020-12-25 | Franklin | Louisiana | 22041 | 1961 | 76 |
859918 | 859918 | 2020-12-24 | Franklin | Louisiana | 22041 | 1961 | 76 |
856673 | 856673 | 2020-12-23 | Franklin | Louisiana | 22041 | 1948 | 76 |
853428 | 853428 | 2020-12-22 | Franklin | Louisiana | 22041 | 1937 | 75 |
850183 | 850183 | 2020-12-21 | Franklin | Louisiana | 22041 | 1930 | 75 |
846938 | 846938 | 2020-12-20 | Franklin | Louisiana | 22041 | 1929 | 73 |
843692 | 843692 | 2020-12-19 | Franklin | Louisiana | 22041 | 1913 | 72 |
840447 | 840447 | 2020-12-18 | Franklin | Louisiana | 22041 | 1913 | 72 |
837202 | 837202 | 2020-12-17 | Franklin | Louisiana | 22041 | 1903 | 72 |
833956 | 833956 | 2020-12-16 | Franklin | Louisiana | 22041 | 1877 | 72 |
830709 | 830709 | 2020-12-15 | Franklin | Louisiana | 22041 | 1872 | 72 |
827463 | 827463 | 2020-12-14 | Franklin | Louisiana | 22041 | 1864 | 72 |
824216 | 824216 | 2020-12-13 | Franklin | Louisiana | 22041 | 1856 | 72 |
820970 | 820970 | 2020-12-12 | Franklin | Louisiana | 22041 | 1848 | 72 |
817724 | 817724 | 2020-12-11 | Franklin | Louisiana | 22041 | 1848 | 72 |
814478 | 814478 | 2020-12-10 | Franklin | Louisiana | 22041 | 1837 | 69 |
811233 | 811233 | 2020-12-09 | Franklin | Louisiana | 22041 | 1825 | 69 |
807988 | 807988 | 2020-12-08 | Franklin | Louisiana | 22041 | 1814 | 68 |
804743 | 804743 | 2020-12-07 | Franklin | Louisiana | 22041 | 1810 | 68 |
801498 | 801498 | 2020-12-06 | Franklin | Louisiana | 22041 | 1801 | 66 |
798253 | 798253 | 2020-12-05 | Franklin | Louisiana | 22041 | 1778 | 65 |
795008 | 795008 | 2020-12-04 | Franklin | Louisiana | 22041 | 1778 | 65 |
791763 | 791763 | 2020-12-03 | Franklin | Louisiana | 22041 | 1760 | 65 |
788518 | 788518 | 2020-12-02 | Franklin | Louisiana | 22041 | 1749 | 64 |
785274 | 785274 | 2020-12-01 | Franklin | Louisiana | 22041 | 1742 | 64 |
782029 | 782029 | 2020-11-30 | Franklin | Louisiana | 22041 | 1727 | 64 |
778783 | 778783 | 2020-11-29 | Franklin | Louisiana | 22041 | 1729 | 64 |
775538 | 775538 | 2020-11-28 | Franklin | Louisiana | 22041 | 1716 | 64 |
772293 | 772293 | 2020-11-27 | Franklin | Louisiana | 22041 | 1716 | 64 |
769048 | 769048 | 2020-11-26 | Franklin | Louisiana | 22041 | 1694 | 63 |
765802 | 765802 | 2020-11-25 | Franklin | Louisiana | 22041 | 1694 | 63 |
762557 | 762557 | 2020-11-24 | Franklin | Louisiana | 22041 | 1693 | 61 |
759312 | 759312 | 2020-11-23 | Franklin | Louisiana | 22041 | 1680 | 61 |
756065 | 756065 | 2020-11-22 | Franklin | Louisiana | 22041 | 1669 | 58 |
752819 | 752819 | 2020-11-21 | Franklin | Louisiana | 22041 | 1653 | 56 |
749573 | 749573 | 2020-11-20 | Franklin | Louisiana | 22041 | 1653 | 56 |
746327 | 746327 | 2020-11-19 | Franklin | Louisiana | 22041 | 1548 | 56 |
743080 | 743080 | 2020-11-18 | Franklin | Louisiana | 22041 | 1532 | 55 |
739833 | 739833 | 2020-11-17 | Franklin | Louisiana | 22041 | 1530 | 55 |
736589 | 736589 | 2020-11-16 | Franklin | Louisiana | 22041 | 1518 | 54 |
733343 | 733343 | 2020-11-15 | Franklin | Louisiana | 22041 | 1506 | 54 |
730098 | 730098 | 2020-11-14 | Franklin | Louisiana | 22041 | 1498 | 54 |
726855 | 726855 | 2020-11-13 | Franklin | Louisiana | 22041 | 1498 | 54 |
723612 | 723612 | 2020-11-12 | Franklin | Louisiana | 22041 | 1442 | 53 |
720369 | 720369 | 2020-11-11 | Franklin | Louisiana | 22041 | 1418 | 52 |
717126 | 717126 | 2020-11-10 | Franklin | Louisiana | 22041 | 1418 | 52 |
713882 | 713882 | 2020-11-09 | Franklin | Louisiana | 22041 | 1401 | 52 |
710638 | 710638 | 2020-11-08 | Franklin | Louisiana | 22041 | 1397 | 51 |
707394 | 707394 | 2020-11-07 | Franklin | Louisiana | 22041 | 1393 | 50 |
704151 | 704151 | 2020-11-06 | Franklin | Louisiana | 22041 | 1393 | 50 |
700909 | 700909 | 2020-11-05 | Franklin | Louisiana | 22041 | 1391 | 50 |
697665 | 697665 | 2020-11-04 | Franklin | Louisiana | 22041 | 1389 | 49 |
694422 | 694422 | 2020-11-03 | Franklin | Louisiana | 22041 | 1379 | 47 |
691180 | 691180 | 2020-11-02 | Franklin | Louisiana | 22041 | 1361 | 47 |
687935 | 687935 | 2020-11-01 | Franklin | Louisiana | 22041 | 1359 | 47 |
684691 | 684691 | 2020-10-31 | Franklin | Louisiana | 22041 | 1348 | 47 |
681448 | 681448 | 2020-10-30 | Franklin | Louisiana | 22041 | 1348 | 47 |
678204 | 678204 | 2020-10-29 | Franklin | Louisiana | 22041 | 1339 | 47 |
674962 | 674962 | 2020-10-28 | Franklin | Louisiana | 22041 | 1335 | 47 |
671719 | 671719 | 2020-10-27 | Franklin | Louisiana | 22041 | 1329 | 47 |
668477 | 668477 | 2020-10-26 | Franklin | Louisiana | 22041 | 1312 | 47 |
665233 | 665233 | 2020-10-25 | Franklin | Louisiana | 22041 | 1310 | 45 |
661988 | 661988 | 2020-10-24 | Franklin | Louisiana | 22041 | 1305 | 45 |
658744 | 658744 | 2020-10-23 | Franklin | Louisiana | 22041 | 1305 | 45 |
655499 | 655499 | 2020-10-22 | Franklin | Louisiana | 22041 | 1299 | 44 |
652254 | 652254 | 2020-10-21 | Franklin | Louisiana | 22041 | 1287 | 44 |
649009 | 649009 | 2020-10-20 | Franklin | Louisiana | 22041 | 1276 | 44 |
645765 | 645765 | 2020-10-19 | Franklin | Louisiana | 22041 | 1272 | 44 |
642518 | 642518 | 2020-10-18 | Franklin | Louisiana | 22041 | 1267 | 44 |
639271 | 639271 | 2020-10-17 | Franklin | Louisiana | 22041 | 1263 | 44 |
636025 | 636025 | 2020-10-16 | Franklin | Louisiana | 22041 | 1263 | 44 |
632779 | 632779 | 2020-10-15 | Franklin | Louisiana | 22041 | 1261 | 44 |
629535 | 629535 | 2020-10-14 | Franklin | Louisiana | 22041 | 1255 | 44 |
626291 | 626291 | 2020-10-13 | Franklin | Louisiana | 22041 | 1251 | 43 |
623049 | 623049 | 2020-10-12 | Franklin | Louisiana | 22041 | 1250 | 41 |
619805 | 619805 | 2020-10-11 | Franklin | Louisiana | 22041 | 1249 | 41 |
616563 | 616563 | 2020-10-10 | Franklin | Louisiana | 22041 | 1239 | 41 |
613322 | 613322 | 2020-10-09 | Franklin | Louisiana | 22041 | 1239 | 41 |
610080 | 610080 | 2020-10-08 | Franklin | Louisiana | 22041 | 1239 | 41 |
606838 | 606838 | 2020-10-07 | Franklin | Louisiana | 22041 | 1237 | 41 |
603596 | 603596 | 2020-10-06 | Franklin | Louisiana | 22041 | 1233 | 41 |
600353 | 600353 | 2020-10-05 | Franklin | Louisiana | 22041 | 1228 | 41 |
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);