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-11-25 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
1950969 1950969 2021-11-25 Acadia Louisiana 22001 10623 251
1950970 1950970 2021-11-25 Allen Louisiana 22003 4774 117
1950971 1950971 2021-11-25 Ascension Louisiana 22005 22028 247
1950972 1950972 2021-11-25 Assumption Louisiana 22007 3698 57
1950973 1950973 2021-11-25 Avoyelles Louisiana 22009 7383 181
1950974 1950974 2021-11-25 Beauregard Louisiana 22011 6166 124
1950975 1950975 2021-11-25 Bienville Louisiana 22013 2516 99
1950976 1950976 2021-11-25 Bossier Louisiana 22015 22017 409
1950977 1950977 2021-11-25 Caddo Louisiana 22017 39993 977
1950978 1950978 2021-11-25 Calcasieu Louisiana 22019 34894 624
1950979 1950979 2021-11-25 Caldwell Louisiana 22021 2299 39
1950980 1950980 2021-11-25 Cameron Louisiana 22023 864 9
1950981 1950981 2021-11-25 Catahoula Louisiana 22025 1789 48
1950982 1950982 2021-11-25 Claiborne Louisiana 22027 2030 66
1950983 1950983 2021-11-25 Concordia Louisiana 22029 3249 79
1950984 1950984 2021-11-25 De Soto Louisiana 22031 4822 113
1950985 1950985 2021-11-25 East Baton Rouge Louisiana 22033 64514 1169
1950986 1950986 2021-11-25 East Carroll Louisiana 22035 1647 31
1950987 1950987 2021-11-25 East Feliciana Louisiana 22037 4510 145
1950988 1950988 2021-11-25 Evangeline Louisiana 22039 5904 142
1950989 1950989 2021-11-25 Franklin Louisiana 22041 4768 140
1950990 1950990 2021-11-25 Grant Louisiana 22043 3891 78
1950991 1950991 2021-11-25 Iberia Louisiana 22045 12603 227
1950992 1950992 2021-11-25 Iberville Louisiana 22047 5875 128
1950993 1950993 2021-11-25 Jackson Louisiana 22049 2811 64
1950994 1950994 2021-11-25 Jefferson Louisiana 22051 70252 1180
1950995 1950995 2021-11-25 Jefferson Davis Louisiana 22053 4790 131
1950996 1950996 2021-11-25 LaSalle Louisiana 22059 2781 46
1950997 1950997 2021-11-25 Lafayette Louisiana 22055 39507 407
1950998 1950998 2021-11-25 Lafourche Louisiana 22057 18138 319
1950999 1950999 2021-11-25 Lincoln Louisiana 22061 7214 117
1951000 1951000 2021-11-25 Livingston Louisiana 22063 24751 383
1951001 1951001 2021-11-25 Madison Louisiana 22065 2267 53
1951002 1951002 2021-11-25 Morehouse Louisiana 22067 4529 116
1951003 1951003 2021-11-25 Natchitoches Louisiana 22069 6710 137
1951004 1951004 2021-11-25 Orleans Louisiana 22071 47456 1002
1951005 1951005 2021-11-25 Ouachita Louisiana 22073 32081 597
1951006 1951006 2021-11-25 Plaquemines Louisiana 22075 4030 40
1951007 1951007 2021-11-25 Pointe Coupee Louisiana 22077 3985 84
1951008 1951008 2021-11-25 Rapides Louisiana 22079 21503 474
1951009 1951009 2021-11-25 Red River Louisiana 22081 1415 49
1951010 1951010 2021-11-25 Richland Louisiana 22083 4369 80
1951011 1951011 2021-11-25 Sabine Louisiana 22085 4550 95
1951012 1951012 2021-11-25 St. Bernard Louisiana 22087 7009 98
1951013 1951013 2021-11-25 St. Charles Louisiana 22089 8941 127
1951014 1951014 2021-11-25 St. Helena Louisiana 22091 1264 19
1951015 1951015 2021-11-25 St. James Louisiana 22093 3544 70
1951016 1951016 2021-11-25 St. John the Baptist Louisiana 22095 6368 173
1951017 1951017 2021-11-25 St. Landry Louisiana 22097 14356 349
1951018 1951018 2021-11-25 St. Martin Louisiana 22099 8490 161
1951019 1951019 2021-11-25 St. Mary Louisiana 22101 8584 226
1951020 1951020 2021-11-25 St. Tammany Louisiana 22103 44165 733
1951021 1951021 2021-11-25 Tangipahoa Louisiana 22105 22994 522
1951022 1951022 2021-11-25 Tensas Louisiana 22107 537 10
1951023 1951023 2021-11-25 Terrebonne Louisiana 22109 19647 355
1951024 1951024 2021-11-25 Union Louisiana 22111 4135 107
1951025 1951025 2021-11-25 Unknown Louisiana   584 0
1951026 1951026 2021-11-25 Vermilion Louisiana 22113 10358 193
1951027 1951027 2021-11-25 Vernon Louisiana 22115 6474 163
1951028 1951028 2021-11-25 Washington Louisiana 22117 8171 218
1951029 1951029 2021-11-25 Webster Louisiana 22119 6740 150
1951030 1951030 2021-11-25 West Baton Rouge Louisiana 22121 4436 78
1951031 1951031 2021-11-25 West Carroll Louisiana 22123 2094 52
1951032 1951032 2021-11-25 West Feliciana Louisiana 22125 1512 41
1951033 1951033 2021-11-25 Winn Louisiana 22127 2652 58

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