ny_times_us_counties

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

6,768 rows where state = "Louisiana" sorted by date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: date (date)

fips

state

  • Louisiana · 6,768 ✖
Link rowid date ▲ county state fips cases deaths
292862 292862 2020-07-03 Acadia Louisiana 22001 968 39
292863 292863 2020-07-03 Allen Louisiana 22003 321 11
292864 292864 2020-07-03 Ascension Louisiana 22005 1278 58
292865 292865 2020-07-03 Assumption Louisiana 22007 373 15
292866 292866 2020-07-03 Avoyelles Louisiana 22009 378 14
292867 292867 2020-07-03 Beauregard Louisiana 22011 231 9
292868 292868 2020-07-03 Bienville Louisiana 22013 233 27
292869 292869 2020-07-03 Bossier Louisiana 22015 971 33
292870 292870 2020-07-03 Caddo Louisiana 22017 3598 243
292871 292871 2020-07-03 Calcasieu Louisiana 22019 2000 59
292872 292872 2020-07-03 Caldwell Louisiana 22021 106 1
292873 292873 2020-07-03 Cameron Louisiana 22023 56 0
292874 292874 2020-07-03 Catahoula Louisiana 22025 194 3
292875 292875 2020-07-03 Claiborne Louisiana 22027 125 10
292876 292876 2020-07-03 Concordia Louisiana 22029 117 6
292877 292877 2020-07-03 De Soto Louisiana 22031 361 19
292878 292878 2020-07-03 East Baton Rouge Louisiana 22033 5684 274
292879 292879 2020-07-03 East Carroll Louisiana 22035 444 1
292880 292880 2020-07-03 East Feliciana Louisiana 22037 308 33
292881 292881 2020-07-03 Evangeline Louisiana 22039 216 1
292882 292882 2020-07-03 Franklin Louisiana 22041 483 14
292883 292883 2020-07-03 Grant Louisiana 22043 93 1
292884 292884 2020-07-03 Iberia Louisiana 22045 844 44
292885 292885 2020-07-03 Iberville Louisiana 22047 740 43
292886 292886 2020-07-03 Jackson Louisiana 22049 219 16
292887 292887 2020-07-03 Jefferson Louisiana 22051 9874 486
292888 292888 2020-07-03 Jefferson Davis Louisiana 22053 419 9
292889 292889 2020-07-03 LaSalle Louisiana 22059 101 0
292890 292890 2020-07-03 Lafayette Louisiana 22055 2645 47
292891 292891 2020-07-03 Lafourche Louisiana 22057 1248 89
292892 292892 2020-07-03 Lincoln Louisiana 22061 344 19
292893 292893 2020-07-03 Livingston Louisiana 22063 1102 38
292894 292894 2020-07-03 Madison Louisiana 22065 383 2
292895 292895 2020-07-03 Morehouse Louisiana 22067 248 10
292896 292896 2020-07-03 Natchitoches Louisiana 22069 319 14
292897 292897 2020-07-03 Orleans Louisiana 22071 8031 534
292898 292898 2020-07-03 Ouachita Louisiana 22073 2591 80
292899 292899 2020-07-03 Plaquemines Louisiana 22075 273 17
292900 292900 2020-07-03 Pointe Coupee Louisiana 22077 274 28
292901 292901 2020-07-03 Rapides Louisiana 22079 1653 66
292902 292902 2020-07-03 Red River Louisiana 22081 62 8
292903 292903 2020-07-03 Richland Louisiana 22083 204 4
292904 292904 2020-07-03 Sabine Louisiana 22085 94 1
292905 292905 2020-07-03 St. Bernard Louisiana 22087 641 23
292906 292906 2020-07-03 St. Charles Louisiana 22089 789 49
292907 292907 2020-07-03 St. Helena Louisiana 22091 103 1
292908 292908 2020-07-03 St. James Louisiana 22093 390 29
292909 292909 2020-07-03 St. John the Baptist Louisiana 22095 1000 87
292910 292910 2020-07-03 St. Landry Louisiana 22097 716 57
292911 292911 2020-07-03 St. Martin Louisiana 22099 779 28
292912 292912 2020-07-03 St. Mary Louisiana 22101 550 38
292913 292913 2020-07-03 St. Tammany Louisiana 22103 2509 178
292914 292914 2020-07-03 Tangipahoa Louisiana 22105 1462 43
292915 292915 2020-07-03 Tensas Louisiana 22107 26 0
292916 292916 2020-07-03 Terrebonne Louisiana 22109 1147 61
292917 292917 2020-07-03 Union Louisiana 22111 441 24
292918 292918 2020-07-03 Unknown Louisiana   115 108
292919 292919 2020-07-03 Vermilion Louisiana 22113 297 6
292920 292920 2020-07-03 Vernon Louisiana 22115 164 8
292921 292921 2020-07-03 Washington Louisiana 22117 705 46
292922 292922 2020-07-03 Webster Louisiana 22119 431 12
292923 292923 2020-07-03 West Baton Rouge Louisiana 22121 290 30
292924 292924 2020-07-03 West Carroll Louisiana 22123 141 5
292925 292925 2020-07-03 West Feliciana Louisiana 22125 247 14
292926 292926 2020-07-03 Winn Louisiana 22127 248 5
289783 289783 2020-07-02 Acadia Louisiana 22001 945 37
289784 289784 2020-07-02 Allen Louisiana 22003 316 11
289785 289785 2020-07-02 Ascension Louisiana 22005 1246 58
289786 289786 2020-07-02 Assumption Louisiana 22007 364 15
289787 289787 2020-07-02 Avoyelles Louisiana 22009 375 14
289788 289788 2020-07-02 Beauregard Louisiana 22011 228 9
289789 289789 2020-07-02 Bienville Louisiana 22013 230 27
289790 289790 2020-07-02 Bossier Louisiana 22015 947 32
289791 289791 2020-07-02 Caddo Louisiana 22017 3520 235
289792 289792 2020-07-02 Calcasieu Louisiana 22019 1852 59
289793 289793 2020-07-02 Caldwell Louisiana 22021 105 1
289794 289794 2020-07-02 Cameron Louisiana 22023 54 0
289795 289795 2020-07-02 Catahoula Louisiana 22025 192 3
289796 289796 2020-07-02 Claiborne Louisiana 22027 122 10
289797 289797 2020-07-02 Concordia Louisiana 22029 113 6
289798 289798 2020-07-02 De Soto Louisiana 22031 357 19
289799 289799 2020-07-02 East Baton Rouge Louisiana 22033 5531 273
289800 289800 2020-07-02 East Carroll Louisiana 22035 445 1
289801 289801 2020-07-02 East Feliciana Louisiana 22037 302 33
289802 289802 2020-07-02 Evangeline Louisiana 22039 202 1
289803 289803 2020-07-02 Franklin Louisiana 22041 475 14
289804 289804 2020-07-02 Grant Louisiana 22043 90 1
289805 289805 2020-07-02 Iberia Louisiana 22045 792 44
289806 289806 2020-07-02 Iberville Louisiana 22047 732 43
289807 289807 2020-07-02 Jackson Louisiana 22049 216 16
289808 289808 2020-07-02 Jefferson Louisiana 22051 9712 486
289809 289809 2020-07-02 Jefferson Davis Louisiana 22053 399 9
289810 289810 2020-07-02 LaSalle Louisiana 22059 99 0
289811 289811 2020-07-02 Lafayette Louisiana 22055 2472 46
289812 289812 2020-07-02 Lafourche Louisiana 22057 1201 89
289813 289813 2020-07-02 Lincoln Louisiana 22061 338 19
289814 289814 2020-07-02 Livingston Louisiana 22063 1025 38
289815 289815 2020-07-02 Madison Louisiana 22065 371 2
289816 289816 2020-07-02 Morehouse Louisiana 22067 242 9
289817 289817 2020-07-02 Natchitoches Louisiana 22069 297 14

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [ny_times_us_counties] (
   [date] TEXT,
   [county] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);
Powered by Datasette · Query took 1041.849ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette