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 2021-03-07 and state = "Louisiana" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Louisiana · 65 ✖
Link rowid date ▲ county state fips cases deaths
1096820 1096820 2021-03-07 Acadia Louisiana 22001 6140 186
1096821 1096821 2021-03-07 Allen Louisiana 22003 3014 87
1096822 1096822 2021-03-07 Ascension Louisiana 22005 11074 152
1096823 1096823 2021-03-07 Assumption Louisiana 22007 2099 34
1096824 1096824 2021-03-07 Avoyelles Louisiana 22009 3948 118
1096825 1096825 2021-03-07 Beauregard Louisiana 22011 2864 65
1096826 1096826 2021-03-07 Bienville Louisiana 22013 1615 75
1096827 1096827 2021-03-07 Bossier Louisiana 22015 13071 269
1096828 1096828 2021-03-07 Caddo Louisiana 22017 24837 687
1096829 1096829 2021-03-07 Calcasieu Louisiana 22019 19822 364
1096830 1096830 2021-03-07 Caldwell Louisiana 22021 1083 25
1096831 1096831 2021-03-07 Cameron Louisiana 22023 554 6
1096832 1096832 2021-03-07 Catahoula Louisiana 22025 1060 35
1096833 1096833 2021-03-07 Claiborne Louisiana 22027 1403 50
1096834 1096834 2021-03-07 Concordia Louisiana 22029 1789 57
1096835 1096835 2021-03-07 De Soto Louisiana 22031 2654 74
1096836 1096836 2021-03-07 East Baton Rouge Louisiana 22033 36052 743
1096837 1096837 2021-03-07 East Carroll Louisiana 22035 1112 23
1096838 1096838 2021-03-07 East Feliciana Louisiana 22037 3029 106
1096839 1096839 2021-03-07 Evangeline Louisiana 22039 3335 79
1096840 1096840 2021-03-07 Franklin Louisiana 22041 2454 104
1096841 1096841 2021-03-07 Grant Louisiana 22043 2022 52
1096842 1096842 2021-03-07 Iberia Louisiana 22045 6515 148
1096843 1096843 2021-03-07 Iberville Louisiana 22047 3491 91
1096844 1096844 2021-03-07 Jackson Louisiana 22049 1798 47
1096845 1096845 2021-03-07 Jefferson Louisiana 22051 44226 858
1096846 1096846 2021-03-07 Jefferson Davis Louisiana 22053 2895 86
1096847 1096847 2021-03-07 LaSalle Louisiana 22059 1429 34
1096848 1096848 2021-03-07 Lafayette Louisiana 22055 21729 262
1096849 1096849 2021-03-07 Lafourche Louisiana 22057 9215 198
1096850 1096850 2021-03-07 Lincoln Louisiana 22061 4243 89
1096851 1096851 2021-03-07 Livingston Louisiana 22063 12478 184
1096852 1096852 2021-03-07 Madison Louisiana 22065 1552 34
1096853 1096853 2021-03-07 Morehouse Louisiana 22067 2721 68
1096854 1096854 2021-03-07 Natchitoches Louisiana 22069 3876 81
1096855 1096855 2021-03-07 Orleans Louisiana 22071 28710 768
1096856 1096856 2021-03-07 Ouachita Louisiana 22073 17730 426
1096857 1096857 2021-03-07 Plaquemines Louisiana 22075 2383 25
1096858 1096858 2021-03-07 Pointe Coupee Louisiana 22077 2373 70
1096859 1096859 2021-03-07 Rapides Louisiana 22079 11328 296
1096860 1096860 2021-03-07 Red River Louisiana 22081 855 36
1096861 1096861 2021-03-07 Richland Louisiana 22083 2361 49
1096862 1096862 2021-03-07 Sabine Louisiana 22085 2795 55
1096863 1096863 2021-03-07 St. Bernard Louisiana 22087 3794 46
1096864 1096864 2021-03-07 St. Charles Louisiana 22089 5158 90
1096865 1096865 2021-03-07 St. Helena Louisiana 22091 881 8
1096866 1096866 2021-03-07 St. James Louisiana 22093 1859 49
1096867 1096867 2021-03-07 St. John the Baptist Louisiana 22095 3554 133
1096868 1096868 2021-03-07 St. Landry Louisiana 22097 8350 246
1096869 1096869 2021-03-07 St. Martin Louisiana 22099 4873 112
1096870 1096870 2021-03-07 St. Mary Louisiana 22101 4193 122
1096871 1096871 2021-03-07 St. Tammany Louisiana 22103 24400 497
1096872 1096872 2021-03-07 Tangipahoa Louisiana 22105 12086 274
1096873 1096873 2021-03-07 Tensas Louisiana 22107 355 6
1096874 1096874 2021-03-07 Terrebonne Louisiana 22109 9637 206
1096875 1096875 2021-03-07 Union Louisiana 22111 2307 76
1096876 1096876 2021-03-07 Unknown Louisiana   419 0
1096877 1096877 2021-03-07 Vermilion Louisiana 22113 4914 107
1096878 1096878 2021-03-07 Vernon Louisiana 22115 2899 96
1096879 1096879 2021-03-07 Washington Louisiana 22117 4130 122
1096880 1096880 2021-03-07 Webster Louisiana 22119 3946 99
1096881 1096881 2021-03-07 West Baton Rouge Louisiana 22121 2534 54
1096882 1096882 2021-03-07 West Carroll Louisiana 22123 1165 39
1096883 1096883 2021-03-07 West Feliciana Louisiana 22125 1121 31
1096884 1096884 2021-03-07 Winn Louisiana 22127 1476 39

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