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

Suggested facets: date (date)

fips

state

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