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-06-20 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
256791 256791 2020-06-20 Acadia Louisiana 22001 646 32
256792 256792 2020-06-20 Allen Louisiana 22003 224 10
256793 256793 2020-06-20 Ascension Louisiana 22005 989 58
256794 256794 2020-06-20 Assumption Louisiana 22007 327 14
256795 256795 2020-06-20 Avoyelles Louisiana 22009 204 11
256796 256796 2020-06-20 Beauregard Louisiana 22011 155 7
256797 256797 2020-06-20 Bienville Louisiana 22013 198 26
256798 256798 2020-06-20 Bossier Louisiana 22015 654 28
256799 256799 2020-06-20 Caddo Louisiana 22017 2881 223
256800 256800 2020-06-20 Calcasieu Louisiana 22019 876 53
256801 256801 2020-06-20 Caldwell Louisiana 22021 94 1
256802 256802 2020-06-20 Cameron Louisiana 22023 26 0
256803 256803 2020-06-20 Catahoula Louisiana 22025 152 3
256804 256804 2020-06-20 Claiborne Louisiana 22027 105 10
256805 256805 2020-06-20 Concordia Louisiana 22029 101 5
256806 256806 2020-06-20 De Soto Louisiana 22031 313 17
256807 256807 2020-06-20 East Baton Rouge Louisiana 22033 4332 263
256808 256808 2020-06-20 East Carroll Louisiana 22035 308 0
256809 256809 2020-06-20 East Feliciana Louisiana 22037 268 32
256810 256810 2020-06-20 Evangeline Louisiana 22039 123 1
256811 256811 2020-06-20 Franklin Louisiana 22041 414 14
256812 256812 2020-06-20 Grant Louisiana 22043 76 1
256813 256813 2020-06-20 Iberia Louisiana 22045 465 42
256814 256814 2020-06-20 Iberville Louisiana 22047 664 43
256815 256815 2020-06-20 Jackson Louisiana 22049 189 15
256816 256816 2020-06-20 Jefferson Louisiana 22051 8647 477
256817 256817 2020-06-20 Jefferson Davis Louisiana 22053 203 7
256818 256818 2020-06-20 LaSalle Louisiana 22059 86 0
256819 256819 2020-06-20 Lafayette Louisiana 22055 1364 33
256820 256820 2020-06-20 Lafourche Louisiana 22057 1005 83
256821 256821 2020-06-20 Lincoln Louisiana 22061 273 19
256822 256822 2020-06-20 Livingston Louisiana 22063 669 35
256823 256823 2020-06-20 Madison Louisiana 22065 308 2
256824 256824 2020-06-20 Morehouse Louisiana 22067 182 6
256825 256825 2020-06-20 Natchitoches Louisiana 22069 192 13
256826 256826 2020-06-20 Orleans Louisiana 22071 7491 529
256827 256827 2020-06-20 Ouachita Louisiana 22073 1927 66
256828 256828 2020-06-20 Plaquemines Louisiana 22075 237 17
256829 256829 2020-06-20 Pointe Coupee Louisiana 22077 222 27
256830 256830 2020-06-20 Rapides Louisiana 22079 1312 50
256831 256831 2020-06-20 Red River Louisiana 22081 54 8
256832 256832 2020-06-20 Richland Louisiana 22083 148 3
256833 256833 2020-06-20 Sabine Louisiana 22085 60 1
256834 256834 2020-06-20 St. Bernard Louisiana 22087 598 23
256835 256835 2020-06-20 St. Charles Louisiana 22089 688 46
256836 256836 2020-06-20 St. Helena Louisiana 22091 86 1
256837 256837 2020-06-20 St. James Louisiana 22093 333 28
256838 256838 2020-06-20 St. John the Baptist Louisiana 22095 919 85
256839 256839 2020-06-20 St. Landry Louisiana 22097 462 55
256840 256840 2020-06-20 St. Martin Louisiana 22099 509 28
256841 256841 2020-06-20 St. Mary Louisiana 22101 378 35
256842 256842 2020-06-20 St. Tammany Louisiana 22103 2003 170
256843 256843 2020-06-20 Tangipahoa Louisiana 22105 1112 42
256844 256844 2020-06-20 Tensas Louisiana 22107 24 0
256845 256845 2020-06-20 Terrebonne Louisiana 22109 839 60
256846 256846 2020-06-20 Union Louisiana 22111 375 20
256847 256847 2020-06-20 Unknown Louisiana   120 112
256848 256848 2020-06-20 Vermilion Louisiana 22113 130 5
256849 256849 2020-06-20 Vernon Louisiana 22115 74 4
256850 256850 2020-06-20 Washington Louisiana 22117 579 44
256851 256851 2020-06-20 Webster Louisiana 22119 316 9
256852 256852 2020-06-20 West Baton Rouge Louisiana 22121 232 30
256853 256853 2020-06-20 West Carroll Louisiana 22123 105 3
256854 256854 2020-06-20 West Feliciana Louisiana 22125 226 14
256855 256855 2020-06-20 Winn Louisiana 22127 225 5

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