ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 22095 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
947568 | 947568 | 2021-01-20 | St. John the Baptist | Louisiana | 22095 | 3090 | 124 |
944321 | 944321 | 2021-01-19 | St. John the Baptist | Louisiana | 22095 | 3053 | 124 |
941076 | 941076 | 2021-01-18 | St. John the Baptist | Louisiana | 22095 | 3045 | 123 |
937831 | 937831 | 2021-01-17 | St. John the Baptist | Louisiana | 22095 | 3032 | 123 |
934586 | 934586 | 2021-01-16 | St. John the Baptist | Louisiana | 22095 | 3010 | 123 |
931341 | 931341 | 2021-01-15 | St. John the Baptist | Louisiana | 22095 | 3010 | 123 |
928096 | 928096 | 2021-01-14 | St. John the Baptist | Louisiana | 22095 | 2997 | 123 |
924850 | 924850 | 2021-01-13 | St. John the Baptist | Louisiana | 22095 | 2963 | 121 |
921605 | 921605 | 2021-01-12 | St. John the Baptist | Louisiana | 22095 | 2947 | 121 |
918360 | 918360 | 2021-01-11 | St. John the Baptist | Louisiana | 22095 | 2925 | 121 |
915115 | 915115 | 2021-01-10 | St. John the Baptist | Louisiana | 22095 | 2911 | 121 |
911870 | 911870 | 2021-01-09 | St. John the Baptist | Louisiana | 22095 | 2869 | 121 |
908625 | 908625 | 2021-01-08 | St. John the Baptist | Louisiana | 22095 | 2869 | 121 |
905379 | 905379 | 2021-01-07 | St. John the Baptist | Louisiana | 22095 | 2842 | 120 |
902134 | 902134 | 2021-01-06 | St. John the Baptist | Louisiana | 22095 | 2797 | 119 |
898889 | 898889 | 2021-01-05 | St. John the Baptist | Louisiana | 22095 | 2764 | 119 |
895644 | 895644 | 2021-01-04 | St. John the Baptist | Louisiana | 22095 | 2710 | 119 |
892397 | 892397 | 2021-01-03 | St. John the Baptist | Louisiana | 22095 | 2705 | 119 |
889151 | 889151 | 2021-01-02 | St. John the Baptist | Louisiana | 22095 | 2649 | 119 |
885905 | 885905 | 2021-01-01 | St. John the Baptist | Louisiana | 22095 | 2649 | 119 |
882660 | 882660 | 2020-12-31 | St. John the Baptist | Louisiana | 22095 | 2649 | 119 |
879415 | 879415 | 2020-12-30 | St. John the Baptist | Louisiana | 22095 | 2610 | 119 |
876170 | 876170 | 2020-12-29 | St. John the Baptist | Louisiana | 22095 | 2563 | 118 |
872925 | 872925 | 2020-12-28 | St. John the Baptist | Louisiana | 22095 | 2536 | 118 |
869680 | 869680 | 2020-12-27 | St. John the Baptist | Louisiana | 22095 | 2533 | 118 |
866435 | 866435 | 2020-12-26 | St. John the Baptist | Louisiana | 22095 | 2490 | 118 |
863190 | 863190 | 2020-12-25 | St. John the Baptist | Louisiana | 22095 | 2490 | 118 |
859945 | 859945 | 2020-12-24 | St. John the Baptist | Louisiana | 22095 | 2490 | 118 |
856700 | 856700 | 2020-12-23 | St. John the Baptist | Louisiana | 22095 | 2470 | 118 |
853455 | 853455 | 2020-12-22 | St. John the Baptist | Louisiana | 22095 | 2431 | 116 |
850210 | 850210 | 2020-12-21 | St. John the Baptist | Louisiana | 22095 | 2403 | 116 |
846965 | 846965 | 2020-12-20 | St. John the Baptist | Louisiana | 22095 | 2388 | 116 |
843719 | 843719 | 2020-12-19 | St. John the Baptist | Louisiana | 22095 | 2346 | 116 |
840474 | 840474 | 2020-12-18 | St. John the Baptist | Louisiana | 22095 | 2346 | 116 |
837229 | 837229 | 2020-12-17 | St. John the Baptist | Louisiana | 22095 | 2324 | 116 |
833983 | 833983 | 2020-12-16 | St. John the Baptist | Louisiana | 22095 | 2297 | 116 |
830736 | 830736 | 2020-12-15 | St. John the Baptist | Louisiana | 22095 | 2276 | 116 |
827490 | 827490 | 2020-12-14 | St. John the Baptist | Louisiana | 22095 | 2244 | 116 |
824243 | 824243 | 2020-12-13 | St. John the Baptist | Louisiana | 22095 | 2231 | 116 |
820997 | 820997 | 2020-12-12 | St. John the Baptist | Louisiana | 22095 | 2198 | 116 |
817751 | 817751 | 2020-12-11 | St. John the Baptist | Louisiana | 22095 | 2198 | 116 |
814505 | 814505 | 2020-12-10 | St. John the Baptist | Louisiana | 22095 | 2180 | 116 |
811260 | 811260 | 2020-12-09 | St. John the Baptist | Louisiana | 22095 | 2161 | 116 |
808015 | 808015 | 2020-12-08 | St. John the Baptist | Louisiana | 22095 | 2144 | 116 |
804770 | 804770 | 2020-12-07 | St. John the Baptist | Louisiana | 22095 | 2124 | 116 |
801525 | 801525 | 2020-12-06 | St. John the Baptist | Louisiana | 22095 | 2118 | 116 |
798280 | 798280 | 2020-12-05 | St. John the Baptist | Louisiana | 22095 | 2094 | 116 |
795035 | 795035 | 2020-12-04 | St. John the Baptist | Louisiana | 22095 | 2094 | 116 |
791790 | 791790 | 2020-12-03 | St. John the Baptist | Louisiana | 22095 | 2076 | 116 |
788545 | 788545 | 2020-12-02 | St. John the Baptist | Louisiana | 22095 | 2042 | 116 |
785301 | 785301 | 2020-12-01 | St. John the Baptist | Louisiana | 22095 | 2022 | 116 |
782056 | 782056 | 2020-11-30 | St. John the Baptist | Louisiana | 22095 | 1992 | 115 |
778810 | 778810 | 2020-11-29 | St. John the Baptist | Louisiana | 22095 | 1991 | 115 |
775565 | 775565 | 2020-11-28 | St. John the Baptist | Louisiana | 22095 | 1978 | 115 |
772320 | 772320 | 2020-11-27 | St. John the Baptist | Louisiana | 22095 | 1978 | 115 |
769075 | 769075 | 2020-11-26 | St. John the Baptist | Louisiana | 22095 | 1921 | 114 |
765829 | 765829 | 2020-11-25 | St. John the Baptist | Louisiana | 22095 | 1921 | 114 |
762584 | 762584 | 2020-11-24 | St. John the Baptist | Louisiana | 22095 | 1915 | 114 |
759339 | 759339 | 2020-11-23 | St. John the Baptist | Louisiana | 22095 | 1903 | 114 |
756092 | 756092 | 2020-11-22 | St. John the Baptist | Louisiana | 22095 | 1892 | 114 |
752846 | 752846 | 2020-11-21 | St. John the Baptist | Louisiana | 22095 | 1873 | 114 |
749600 | 749600 | 2020-11-20 | St. John the Baptist | Louisiana | 22095 | 1873 | 114 |
746354 | 746354 | 2020-11-19 | St. John the Baptist | Louisiana | 22095 | 1844 | 114 |
743107 | 743107 | 2020-11-18 | St. John the Baptist | Louisiana | 22095 | 1829 | 114 |
739860 | 739860 | 2020-11-17 | St. John the Baptist | Louisiana | 22095 | 1816 | 114 |
736616 | 736616 | 2020-11-16 | St. John the Baptist | Louisiana | 22095 | 1810 | 114 |
733370 | 733370 | 2020-11-15 | St. John the Baptist | Louisiana | 22095 | 1797 | 114 |
730125 | 730125 | 2020-11-14 | St. John the Baptist | Louisiana | 22095 | 1784 | 114 |
726882 | 726882 | 2020-11-13 | St. John the Baptist | Louisiana | 22095 | 1784 | 114 |
723639 | 723639 | 2020-11-12 | St. John the Baptist | Louisiana | 22095 | 1738 | 108 |
720396 | 720396 | 2020-11-11 | St. John the Baptist | Louisiana | 22095 | 1727 | 108 |
717153 | 717153 | 2020-11-10 | St. John the Baptist | Louisiana | 22095 | 1727 | 108 |
713909 | 713909 | 2020-11-09 | St. John the Baptist | Louisiana | 22095 | 1728 | 108 |
710665 | 710665 | 2020-11-08 | St. John the Baptist | Louisiana | 22095 | 1728 | 108 |
707421 | 707421 | 2020-11-07 | St. John the Baptist | Louisiana | 22095 | 1695 | 108 |
704178 | 704178 | 2020-11-06 | St. John the Baptist | Louisiana | 22095 | 1695 | 108 |
700936 | 700936 | 2020-11-05 | St. John the Baptist | Louisiana | 22095 | 1690 | 108 |
697692 | 697692 | 2020-11-04 | St. John the Baptist | Louisiana | 22095 | 1674 | 108 |
694449 | 694449 | 2020-11-03 | St. John the Baptist | Louisiana | 22095 | 1672 | 108 |
691207 | 691207 | 2020-11-02 | St. John the Baptist | Louisiana | 22095 | 1661 | 107 |
687962 | 687962 | 2020-11-01 | St. John the Baptist | Louisiana | 22095 | 1663 | 107 |
684718 | 684718 | 2020-10-31 | St. John the Baptist | Louisiana | 22095 | 1659 | 107 |
681475 | 681475 | 2020-10-30 | St. John the Baptist | Louisiana | 22095 | 1659 | 107 |
678231 | 678231 | 2020-10-29 | St. John the Baptist | Louisiana | 22095 | 1654 | 107 |
674989 | 674989 | 2020-10-28 | St. John the Baptist | Louisiana | 22095 | 1653 | 107 |
671746 | 671746 | 2020-10-27 | St. John the Baptist | Louisiana | 22095 | 1649 | 107 |
668504 | 668504 | 2020-10-26 | St. John the Baptist | Louisiana | 22095 | 1643 | 107 |
665260 | 665260 | 2020-10-25 | St. John the Baptist | Louisiana | 22095 | 1639 | 107 |
662015 | 662015 | 2020-10-24 | St. John the Baptist | Louisiana | 22095 | 1628 | 107 |
658771 | 658771 | 2020-10-23 | St. John the Baptist | Louisiana | 22095 | 1628 | 107 |
655526 | 655526 | 2020-10-22 | St. John the Baptist | Louisiana | 22095 | 1627 | 106 |
652281 | 652281 | 2020-10-21 | St. John the Baptist | Louisiana | 22095 | 1623 | 106 |
649036 | 649036 | 2020-10-20 | St. John the Baptist | Louisiana | 22095 | 1623 | 106 |
645792 | 645792 | 2020-10-19 | St. John the Baptist | Louisiana | 22095 | 1621 | 106 |
642545 | 642545 | 2020-10-18 | St. John the Baptist | Louisiana | 22095 | 1619 | 105 |
639298 | 639298 | 2020-10-17 | St. John the Baptist | Louisiana | 22095 | 1616 | 105 |
636052 | 636052 | 2020-10-16 | St. John the Baptist | Louisiana | 22095 | 1616 | 105 |
632806 | 632806 | 2020-10-15 | St. John the Baptist | Louisiana | 22095 | 1615 | 105 |
629562 | 629562 | 2020-10-14 | St. John the Baptist | Louisiana | 22095 | 1613 | 105 |
626318 | 626318 | 2020-10-13 | St. John the Baptist | Louisiana | 22095 | 1609 | 105 |
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);