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 2020-10-16 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
636005 636005 2020-10-16 Acadia Louisiana 22001 3053 99
636006 636006 2020-10-16 Allen Louisiana 22003 1790 53
636007 636007 2020-10-16 Ascension Louisiana 22005 3921 98
636008 636008 2020-10-16 Assumption Louisiana 22007 780 24
636009 636009 2020-10-16 Avoyelles Louisiana 22009 1656 62
636010 636010 2020-10-16 Beauregard Louisiana 22011 1041 39
636011 636011 2020-10-16 Bienville Louisiana 22013 553 33
636012 636012 2020-10-16 Bossier Louisiana 22015 3821 112
636013 636013 2020-10-16 Caddo Louisiana 22017 9532 382
636014 636014 2020-10-16 Calcasieu Louisiana 22019 8138 221
636015 636015 2020-10-16 Caldwell Louisiana 22021 334 3
636016 636016 2020-10-16 Cameron Louisiana 22023 234 2
636017 636017 2020-10-16 Catahoula Louisiana 22025 452 13
636018 636018 2020-10-16 Claiborne Louisiana 22027 582 24
636019 636019 2020-10-16 Concordia Louisiana 22029 558 16
636020 636020 2020-10-16 De Soto Louisiana 22031 979 35
636021 636021 2020-10-16 East Baton Rouge Louisiana 22033 15636 452
636022 636022 2020-10-16 East Carroll Louisiana 22035 563 6
636023 636023 2020-10-16 East Feliciana Louisiana 22037 1784 75
636024 636024 2020-10-16 Evangeline Louisiana 22039 1380 37
636025 636025 2020-10-16 Franklin Louisiana 22041 1263 44
636026 636026 2020-10-16 Grant Louisiana 22043 512 30
636027 636027 2020-10-16 Iberia Louisiana 22045 3029 93
636028 636028 2020-10-16 Iberville Louisiana 22047 1434 58
636029 636029 2020-10-16 Jackson Louisiana 22049 787 22
636030 636030 2020-10-16 Jefferson Louisiana 22051 18252 580
636031 636031 2020-10-16 Jefferson Davis Louisiana 22053 1300 42
636032 636032 2020-10-16 LaSalle Louisiana 22059 468 10
636033 636033 2020-10-16 Lafayette Louisiana 22055 9241 136
636034 636034 2020-10-16 Lafourche Louisiana 22057 3810 124
636035 636035 2020-10-16 Lincoln Louisiana 22061 1592 48
636036 636036 2020-10-16 Livingston Louisiana 22063 4047 79
636037 636037 2020-10-16 Madison Louisiana 22065 889 8
636038 636038 2020-10-16 Morehouse Louisiana 22067 861 24
636039 636039 2020-10-16 Natchitoches Louisiana 22069 1353 26
636040 636040 2020-10-16 Orleans Louisiana 22071 13150 589
636041 636041 2020-10-16 Ouachita Louisiana 22073 6714 158
636042 636042 2020-10-16 Plaquemines Louisiana 22075 824 19
636043 636043 2020-10-16 Pointe Coupee Louisiana 22077 1096 40
636044 636044 2020-10-16 Rapides Louisiana 22079 4514 153
636045 636045 2020-10-16 Red River Louisiana 22081 384 24
636046 636046 2020-10-16 Richland Louisiana 22083 841 15
636047 636047 2020-10-16 Sabine Louisiana 22085 942 14
636048 636048 2020-10-16 St. Bernard Louisiana 22087 1508 32
636049 636049 2020-10-16 St. Charles Louisiana 22089 1896 63
636050 636050 2020-10-16 St. Helena Louisiana 22091 424 4
636051 636051 2020-10-16 St. James Louisiana 22093 828 40
636052 636052 2020-10-16 St. John the Baptist Louisiana 22095 1616 105
636053 636053 2020-10-16 St. Landry Louisiana 22097 3510 132
636054 636054 2020-10-16 St. Martin Louisiana 22099 2152 61
636055 636055 2020-10-16 St. Mary Louisiana 22101 1990 83
636056 636056 2020-10-16 St. Tammany Louisiana 22103 7479 269
636057 636057 2020-10-16 Tangipahoa Louisiana 22105 4859 122
636058 636058 2020-10-16 Tensas Louisiana 22107 186 2
636059 636059 2020-10-16 Terrebonne Louisiana 22109 3779 122
636060 636060 2020-10-16 Union Louisiana 22111 1058 49
636061 636061 2020-10-16 Unknown Louisiana   3330 200
636062 636062 2020-10-16 Vermilion Louisiana 22113 2080 68
636063 636063 2020-10-16 Vernon Louisiana 22115 1108 55
636064 636064 2020-10-16 Washington Louisiana 22117 1708 68
636065 636065 2020-10-16 Webster Louisiana 22119 1412 34
636066 636066 2020-10-16 West Baton Rouge Louisiana 22121 942 42
636067 636067 2020-10-16 West Carroll Louisiana 22123 361 10
636068 636068 2020-10-16 West Feliciana Louisiana 22125 744 25
636069 636069 2020-10-16 Winn Louisiana 22127 666 19

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