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-04-01 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
2363951 2363951 2022-04-01 Acadia Louisiana 22001 15854 290
2363952 2363952 2022-04-01 Allen Louisiana 22003 7863 137
2363953 2363953 2022-04-01 Ascension Louisiana 22005 34790 291
2363954 2363954 2022-04-01 Assumption Louisiana 22007 5554 69
2363955 2363955 2022-04-01 Avoyelles Louisiana 22009 11571 206
2363956 2363956 2022-04-01 Beauregard Louisiana 22011 9246 142
2363957 2363957 2022-04-01 Bienville Louisiana 22013 3972 111
2363958 2363958 2022-04-01 Bossier Louisiana 22015 37472 490
2363959 2363959 2022-04-01 Caddo Louisiana 22017 67181 1141
2363960 2363960 2022-04-01 Calcasieu Louisiana 22019 54610 702
2363961 2363961 2022-04-01 Caldwell Louisiana 22021 3367 55
2363962 2363962 2022-04-01 Cameron Louisiana 22023 1198 8
2363963 2363963 2022-04-01 Catahoula Louisiana 22025 2693 55
2363964 2363964 2022-04-01 Claiborne Louisiana 22027 3276 75
2363965 2363965 2022-04-01 Concordia Louisiana 22029 5085 89
2363966 2363966 2022-04-01 De Soto Louisiana 22031 7319 135
2363967 2363967 2022-04-01 East Baton Rouge Louisiana 22033 110701 1340
2363968 2363968 2022-04-01 East Carroll Louisiana 22035 2534 38
2363969 2363969 2022-04-01 East Feliciana Louisiana 22037 7300 170
2363970 2363970 2022-04-01 Evangeline Louisiana 22039 8376 156
2363971 2363971 2022-04-01 Franklin Louisiana 22041 7335 178
2363972 2363972 2022-04-01 Grant Louisiana 22043 5852 93
2363973 2363973 2022-04-01 Iberia Louisiana 22045 19046 263
2363974 2363974 2022-04-01 Iberville Louisiana 22047 8979 152
2363975 2363975 2022-04-01 Jackson Louisiana 22049 4378 75
2363976 2363976 2022-04-01 Jefferson Louisiana 22051 113475 1329
2363977 2363977 2022-04-01 Jefferson Davis Louisiana 22053 6932 156
2363978 2363978 2022-04-01 LaSalle Louisiana 22059 4220 56
2363979 2363979 2022-04-01 Lafayette Louisiana 22055 62287 497
2363980 2363980 2022-04-01 Lafourche Louisiana 22057 27711 366
2363981 2363981 2022-04-01 Lincoln Louisiana 22061 12204 144
2363982 2363982 2022-04-01 Livingston Louisiana 22063 37079 463
2363983 2363983 2022-04-01 Madison Louisiana 22065 3255 58
2363984 2363984 2022-04-01 Morehouse Louisiana 22067 6847 134
2363985 2363985 2022-04-01 Natchitoches Louisiana 22069 10104 166
2363986 2363986 2022-04-01 Orleans Louisiana 22071 87394 1108
2363987 2363987 2022-04-01 Ouachita Louisiana 22073 50499 738
2363988 2363988 2022-04-01 Plaquemines Louisiana 22075 6410 45
2363989 2363989 2022-04-01 Pointe Coupee Louisiana 22077 6267 92
2363990 2363990 2022-04-01 Rapides Louisiana 22079 32710 575
2363991 2363991 2022-04-01 Red River Louisiana 22081 2106 52
2363992 2363992 2022-04-01 Richland Louisiana 22083 6701 94
2363993 2363993 2022-04-01 Sabine Louisiana 22085 6327 109
2363994 2363994 2022-04-01 St. Bernard Louisiana 22087 11207 110
2363995 2363995 2022-04-01 St. Charles Louisiana 22089 13795 144
2363996 2363996 2022-04-01 St. Helena Louisiana 22091 1912 23
2363997 2363997 2022-04-01 St. James Louisiana 22093 5774 76
2363998 2363998 2022-04-01 St. John the Baptist Louisiana 22095 10503 184
2363999 2363999 2022-04-01 St. Landry Louisiana 22097 22161 414
2364000 2364000 2022-04-01 St. Martin Louisiana 22099 12932 186
2364001 2364001 2022-04-01 St. Mary Louisiana 22101 12465 261
2364002 2364002 2022-04-01 St. Tammany Louisiana 22103 71984 845
2364003 2364003 2022-04-01 Tangipahoa Louisiana 22105 34652 593
2364004 2364004 2022-04-01 Tensas Louisiana 22107 985 11
2364005 2364005 2022-04-01 Terrebonne Louisiana 22109 30819 412
2364006 2364006 2022-04-01 Union Louisiana 22111 6909 130
2364007 2364007 2022-04-01 Unknown Louisiana   978 0
2364008 2364008 2022-04-01 Vermilion Louisiana 22113 15240 223
2364009 2364009 2022-04-01 Vernon Louisiana 22115 9919 191
2364010 2364010 2022-04-01 Washington Louisiana 22117 12938 246
2364011 2364011 2022-04-01 Webster Louisiana 22119 11089 183
2364012 2364012 2022-04-01 West Baton Rouge Louisiana 22121 7289 90
2364013 2364013 2022-04-01 West Carroll Louisiana 22123 3622 65
2364014 2364014 2022-04-01 West Feliciana Louisiana 22125 2831 46
2364015 2364015 2022-04-01 Winn Louisiana 22127 4429 62

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