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-09-09 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
1700776 1700776 2021-09-09 Acadia Louisiana 22001 9851 231
1700777 1700777 2021-09-09 Allen Louisiana 22003 4367 102
1700778 1700778 2021-09-09 Ascension Louisiana 22005 20699 218
1700779 1700779 2021-09-09 Assumption Louisiana 22007 3437 52
1700780 1700780 2021-09-09 Avoyelles Louisiana 22009 6635 157
1700781 1700781 2021-09-09 Beauregard Louisiana 22011 5462 104
1700782 1700782 2021-09-09 Bienville Louisiana 22013 2296 87
1700783 1700783 2021-09-09 Bossier Louisiana 22015 20134 360
1700784 1700784 2021-09-09 Caddo Louisiana 22017 36614 863
1700785 1700785 2021-09-09 Calcasieu Louisiana 22019 32009 529
1700786 1700786 2021-09-09 Caldwell Louisiana 22021 1733 33
1700787 1700787 2021-09-09 Cameron Louisiana 22023 823 7
1700788 1700788 2021-09-09 Catahoula Louisiana 22025 1650 45
1700789 1700789 2021-09-09 Claiborne Louisiana 22027 1904 58
1700790 1700790 2021-09-09 Concordia Louisiana 22029 2948 69
1700791 1700791 2021-09-09 De Soto Louisiana 22031 4405 100
1700792 1700792 2021-09-09 East Baton Rouge Louisiana 22033 60609 1062
1700793 1700793 2021-09-09 East Carroll Louisiana 22035 1461 29
1700794 1700794 2021-09-09 East Feliciana Louisiana 22037 4340 133
1700795 1700795 2021-09-09 Evangeline Louisiana 22039 5378 111
1700796 1700796 2021-09-09 Franklin Louisiana 22041 3958 129
1700797 1700797 2021-09-09 Grant Louisiana 22043 3557 71
1700798 1700798 2021-09-09 Iberia Louisiana 22045 11823 204
1700799 1700799 2021-09-09 Iberville Louisiana 22047 5595 119
1700800 1700800 2021-09-09 Jackson Louisiana 22049 2571 58
1700801 1700801 2021-09-09 Jefferson Louisiana 22051 66672 1060
1700802 1700802 2021-09-09 Jefferson Davis Louisiana 22053 4379 113
1700803 1700803 2021-09-09 LaSalle Louisiana 22059 2501 41
1700804 1700804 2021-09-09 Lafayette Louisiana 22055 36501 372
1700805 1700805 2021-09-09 Lafourche Louisiana 22057 16837 266
1700806 1700806 2021-09-09 Lincoln Louisiana 22061 6370 106
1700807 1700807 2021-09-09 Livingston Louisiana 22063 23228 324
1700808 1700808 2021-09-09 Madison Louisiana 22065 2046 49
1700809 1700809 2021-09-09 Morehouse Louisiana 22067 4185 97
1700810 1700810 2021-09-09 Natchitoches Louisiana 22069 5896 113
1700811 1700811 2021-09-09 Orleans Louisiana 22071 44383 921
1700812 1700812 2021-09-09 Ouachita Louisiana 22073 28522 522
1700813 1700813 2021-09-09 Plaquemines Louisiana 22075 3647 35
1700814 1700814 2021-09-09 Pointe Coupee Louisiana 22077 3648 81
1700815 1700815 2021-09-09 Rapides Louisiana 22079 19846 408
1700816 1700816 2021-09-09 Red River Louisiana 22081 1259 42
1700817 1700817 2021-09-09 Richland Louisiana 22083 3889 72
1700818 1700818 2021-09-09 Sabine Louisiana 22085 4099 69
1700819 1700819 2021-09-09 St. Bernard Louisiana 22087 6538 86
1700820 1700820 2021-09-09 St. Charles Louisiana 22089 8487 116
1700821 1700821 2021-09-09 St. Helena Louisiana 22091 1244 12
1700822 1700822 2021-09-09 St. James Louisiana 22093 3253 62
1700823 1700823 2021-09-09 St. John the Baptist Louisiana 22095 6002 155
1700824 1700824 2021-09-09 St. Landry Louisiana 22097 13065 313
1700825 1700825 2021-09-09 St. Martin Louisiana 22099 7967 146
1700826 1700826 2021-09-09 St. Mary Louisiana 22101 8055 195
1700827 1700827 2021-09-09 St. Tammany Louisiana 22103 40968 644
1700828 1700828 2021-09-09 Tangipahoa Louisiana 22105 21524 444
1700829 1700829 2021-09-09 Tensas Louisiana 22107 462 8
1700830 1700830 2021-09-09 Terrebonne Louisiana 22109 18324 276
1700831 1700831 2021-09-09 Union Louisiana 22111 3613 92
1700832 1700832 2021-09-09 Unknown Louisiana   513 0
1700833 1700833 2021-09-09 Vermilion Louisiana 22113 9510 162
1700834 1700834 2021-09-09 Vernon Louisiana 22115 5415 137
1700835 1700835 2021-09-09 Washington Louisiana 22117 7457 183
1700836 1700836 2021-09-09 Webster Louisiana 22119 5984 132
1700837 1700837 2021-09-09 West Baton Rouge Louisiana 22121 4233 71
1700838 1700838 2021-09-09 West Carroll Louisiana 22123 1744 45
1700839 1700839 2021-09-09 West Feliciana Louisiana 22125 1415 39
1700840 1700840 2021-09-09 Winn Louisiana 22127 2461 52

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