ny_times_us_counties

Table actions
⚠️ 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

65 rows where "date" is on date 2020-11-17 and state = "Louisiana" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

state 1

  • Louisiana · 65 ✖
Link rowid date ▲ county state fips cases deaths
739813 739813 2020-11-17 Acadia Louisiana 22001 3587 112
739814 739814 2020-11-17 Allen Louisiana 22003 1981 67
739815 739815 2020-11-17 Ascension Louisiana 22005 5068 103
739816 739816 2020-11-17 Assumption Louisiana 22007 936 25
739817 739817 2020-11-17 Avoyelles Louisiana 22009 1942 67
739818 739818 2020-11-17 Beauregard Louisiana 22011 1223 47
739819 739819 2020-11-17 Bienville Louisiana 22013 693 37
739820 739820 2020-11-17 Bossier Louisiana 22015 5295 141
739821 739821 2020-11-17 Caddo Louisiana 22017 11705 427
739822 739822 2020-11-17 Calcasieu Louisiana 22019 9664 239
739823 739823 2020-11-17 Caldwell Louisiana 22021 517 5
739824 739824 2020-11-17 Cameron Louisiana 22023 268 3
739825 739825 2020-11-17 Catahoula Louisiana 22025 533 17
739826 739826 2020-11-17 Claiborne Louisiana 22027 696 29
739827 739827 2020-11-17 Concordia Louisiana 22029 804 24
739828 739828 2020-11-17 De Soto Louisiana 22031 1142 37
739829 739829 2020-11-17 East Baton Rouge Louisiana 22033 18125 488
739830 739830 2020-11-17 East Carroll Louisiana 22035 648 6
739831 739831 2020-11-17 East Feliciana Louisiana 22037 2015 83
739832 739832 2020-11-17 Evangeline Louisiana 22039 1668 41
739833 739833 2020-11-17 Franklin Louisiana 22041 1530 55
739834 739834 2020-11-17 Grant Louisiana 22043 637 32
739835 739835 2020-11-17 Iberia Louisiana 22045 3392 103
739836 739836 2020-11-17 Iberville Louisiana 22047 1684 62
739837 739837 2020-11-17 Jackson Louisiana 22049 1038 25
739838 739838 2020-11-17 Jefferson Louisiana 22051 20357 621
739839 739839 2020-11-17 Jefferson Davis Louisiana 22053 1521 47
739840 739840 2020-11-17 LaSalle Louisiana 22059 778 16
739841 739841 2020-11-17 Lafayette Louisiana 22055 10680 143
739842 739842 2020-11-17 Lafourche Louisiana 22057 4342 135
739843 739843 2020-11-17 Lincoln Louisiana 22061 2169 54
739844 739844 2020-11-17 Livingston Louisiana 22063 5168 87
739845 739845 2020-11-17 Madison Louisiana 22065 970 12
739846 739846 2020-11-17 Morehouse Louisiana 22067 1083 30
739847 739847 2020-11-17 Natchitoches Louisiana 22069 1793 40
739848 739848 2020-11-17 Orleans Louisiana 22071 14711 644
739849 739849 2020-11-17 Ouachita Louisiana 22073 8473 194
739850 739850 2020-11-17 Plaquemines Louisiana 22075 1022 19
739851 739851 2020-11-17 Pointe Coupee Louisiana 22077 1258 48
739852 739852 2020-11-17 Rapides Louisiana 22079 5699 179
739853 739853 2020-11-17 Red River Louisiana 22081 545 26
739854 739854 2020-11-17 Richland Louisiana 22083 1190 24
739855 739855 2020-11-17 Sabine Louisiana 22085 1249 18
739856 739856 2020-11-17 St. Bernard Louisiana 22087 1688 34
739857 739857 2020-11-17 St. Charles Louisiana 22089 2294 70
739858 739858 2020-11-17 St. Helena Louisiana 22091 496 4
739859 739859 2020-11-17 St. James Louisiana 22093 920 40
739860 739860 2020-11-17 St. John the Baptist Louisiana 22095 1816 114
739861 739861 2020-11-17 St. Landry Louisiana 22097 4355 143
739862 739862 2020-11-17 St. Martin Louisiana 22099 2496 70
739863 739863 2020-11-17 St. Mary Louisiana 22101 2239 94
739864 739864 2020-11-17 St. Tammany Louisiana 22103 9020 284
739865 739865 2020-11-17 Tangipahoa Louisiana 22105 5881 137
739866 739866 2020-11-17 Tensas Louisiana 22107 202 3
739867 739867 2020-11-17 Terrebonne Louisiana 22109 4205 132
739868 739868 2020-11-17 Union Louisiana 22111 1298 56
739869 739869 2020-11-17 Unknown Louisiana   316 0
739870 739870 2020-11-17 Vermilion Louisiana 22113 2347 71
739871 739871 2020-11-17 Vernon Louisiana 22115 1256 61
739872 739872 2020-11-17 Washington Louisiana 22117 2061 74
739873 739873 2020-11-17 Webster Louisiana 22119 1715 48
739874 739874 2020-11-17 West Baton Rouge Louisiana 22121 1170 43
739875 739875 2020-11-17 West Carroll Louisiana 22123 473 18
739876 739876 2020-11-17 West Feliciana Louisiana 22125 783 25
739877 739877 2020-11-17 Winn Louisiana 22127 855 23

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
);
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);