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 2022-05-02 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
2464868 2464868 2022-05-02 Acadia Louisiana 22001 15889 294
2464869 2464869 2022-05-02 Allen Louisiana 22003 7874 139
2464870 2464870 2022-05-02 Ascension Louisiana 22005 34884 293
2464871 2464871 2022-05-02 Assumption Louisiana 22007 5561 70
2464872 2464872 2022-05-02 Avoyelles Louisiana 22009 11581 207
2464873 2464873 2022-05-02 Beauregard Louisiana 22011 9256 143
2464874 2464874 2022-05-02 Bienville Louisiana 22013 3986 110
2464875 2464875 2022-05-02 Bossier Louisiana 22015 37561 492
2464876 2464876 2022-05-02 Caddo Louisiana 22017 67373 1152
2464877 2464877 2022-05-02 Calcasieu Louisiana 22019 54745 706
2464878 2464878 2022-05-02 Caldwell Louisiana 22021 3614 55
2464879 2464879 2022-05-02 Cameron Louisiana 22023 1198 8
2464880 2464880 2022-05-02 Catahoula Louisiana 22025 2695 55
2464881 2464881 2022-05-02 Claiborne Louisiana 22027 3280 76
2464882 2464882 2022-05-02 Concordia Louisiana 22029 5095 89
2464883 2464883 2022-05-02 De Soto Louisiana 22031 7343 135
2464884 2464884 2022-05-02 East Baton Rouge Louisiana 22033 111118 1347
2464885 2464885 2022-05-02 East Carroll Louisiana 22035 2538 38
2464886 2464886 2022-05-02 East Feliciana Louisiana 22037 7315 170
2464887 2464887 2022-05-02 Evangeline Louisiana 22039 8388 159
2464888 2464888 2022-05-02 Franklin Louisiana 22041 7345 178
2464889 2464889 2022-05-02 Grant Louisiana 22043 5857 94
2464890 2464890 2022-05-02 Iberia Louisiana 22045 19077 263
2464891 2464891 2022-05-02 Iberville Louisiana 22047 9000 153
2464892 2464892 2022-05-02 Jackson Louisiana 22049 4407 75
2464893 2464893 2022-05-02 Jefferson Louisiana 22051 114413 1339
2464894 2464894 2022-05-02 Jefferson Davis Louisiana 22053 6936 157
2464895 2464895 2022-05-02 LaSalle Louisiana 22059 4264 60
2464896 2464896 2022-05-02 Lafayette Louisiana 22055 62642 499
2464897 2464897 2022-05-02 Lafourche Louisiana 22057 27796 370
2464898 2464898 2022-05-02 Lincoln Louisiana 22061 12237 145
2464899 2464899 2022-05-02 Livingston Louisiana 22063 37152 466
2464900 2464900 2022-05-02 Madison Louisiana 22065 3258 59
2464901 2464901 2022-05-02 Morehouse Louisiana 22067 6857 134
2464902 2464902 2022-05-02 Natchitoches Louisiana 22069 10128 166
2464903 2464903 2022-05-02 Orleans Louisiana 22071 88845 1109
2464904 2464904 2022-05-02 Ouachita Louisiana 22073 50658 751
2464905 2464905 2022-05-02 Plaquemines Louisiana 22075 6447 45
2464906 2464906 2022-05-02 Pointe Coupee Louisiana 22077 6280 93
2464907 2464907 2022-05-02 Rapides Louisiana 22079 32745 577
2464908 2464908 2022-05-02 Red River Louisiana 22081 2109 53
2464909 2464909 2022-05-02 Richland Louisiana 22083 6723 97
2464910 2464910 2022-05-02 Sabine Louisiana 22085 6340 112
2464911 2464911 2022-05-02 St. Bernard Louisiana 22087 11322 111
2464912 2464912 2022-05-02 St. Charles Louisiana 22089 13848 145
2464913 2464913 2022-05-02 St. Helena Louisiana 22091 1913 23
2464914 2464914 2022-05-02 St. James Louisiana 22093 5785 77
2464915 2464915 2022-05-02 St. John the Baptist Louisiana 22095 10558 184
2464916 2464916 2022-05-02 St. Landry Louisiana 22097 22227 416
2464917 2464917 2022-05-02 St. Martin Louisiana 22099 12960 188
2464918 2464918 2022-05-02 St. Mary Louisiana 22101 12500 262
2464919 2464919 2022-05-02 St. Tammany Louisiana 22103 72546 851
2464920 2464920 2022-05-02 Tangipahoa Louisiana 22105 34758 598
2464921 2464921 2022-05-02 Tensas Louisiana 22107 988 11
2464922 2464922 2022-05-02 Terrebonne Louisiana 22109 30906 417
2464923 2464923 2022-05-02 Union Louisiana 22111 6921 134
2464924 2464924 2022-05-02 Unknown Louisiana   983 0
2464925 2464925 2022-05-02 Vermilion Louisiana 22113 15303 223
2464926 2464926 2022-05-02 Vernon Louisiana 22115 9933 190
2464927 2464927 2022-05-02 Washington Louisiana 22117 12971 248
2464928 2464928 2022-05-02 Webster Louisiana 22119 11109 186
2464929 2464929 2022-05-02 West Baton Rouge Louisiana 22121 7312 90
2464930 2464930 2022-05-02 West Carroll Louisiana 22123 3628 66
2464931 2464931 2022-05-02 West Feliciana Louisiana 22125 2833 46
2464932 2464932 2022-05-02 Winn Louisiana 22127 4443 63

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