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-06-03 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
204076 204076 2020-06-03 Acadia Louisiana 22001 446 26
204077 204077 2020-06-03 Allen Louisiana 22003 185 10
204078 204078 2020-06-03 Ascension Louisiana 22005 852 57
204079 204079 2020-06-03 Assumption Louisiana 22007 252 14
204080 204080 2020-06-03 Avoyelles Louisiana 22009 141 9
204081 204081 2020-06-03 Beauregard Louisiana 22011 81 4
204082 204082 2020-06-03 Bienville Louisiana 22013 149 23
204083 204083 2020-06-03 Bossier Louisiana 22015 425 25
204084 204084 2020-06-03 Caddo Louisiana 22017 2633 198
204085 204085 2020-06-03 Calcasieu Louisiana 22019 613 49
204086 204086 2020-06-03 Caldwell Louisiana 22021 61 0
204087 204087 2020-06-03 Cameron Louisiana 22023 6 0
204088 204088 2020-06-03 Catahoula Louisiana 22025 117 3
204089 204089 2020-06-03 Claiborne Louisiana 22027 66 10
204090 204090 2020-06-03 Concordia Louisiana 22029 94 5
204091 204091 2020-06-03 De Soto Louisiana 22031 250 17
204092 204092 2020-06-03 East Baton Rouge Louisiana 22033 3773 242
204093 204093 2020-06-03 East Carroll Louisiana 22035 165 0
204094 204094 2020-06-03 East Feliciana Louisiana 22037 198 30
204095 204095 2020-06-03 Evangeline Louisiana 22039 81 1
204096 204096 2020-06-03 Franklin Louisiana 22041 377 12
204097 204097 2020-06-03 Grant Louisiana 22043 30 1
204098 204098 2020-06-03 Iberia Louisiana 22045 418 38
204099 204099 2020-06-03 Iberville Louisiana 22047 579 42
204100 204100 2020-06-03 Jackson Louisiana 22049 110 15
204101 204101 2020-06-03 Jefferson Louisiana 22051 7738 454
204102 204102 2020-06-03 Jefferson Davis Louisiana 22053 78 7
204103 204103 2020-06-03 LaSalle Louisiana 22059 53 0
204104 204104 2020-06-03 Lafayette Louisiana 22055 821 27
204105 204105 2020-06-03 Lafourche Louisiana 22057 878 72
204106 204106 2020-06-03 Lincoln Louisiana 22061 161 16
204107 204107 2020-06-03 Livingston Louisiana 22063 446 31
204108 204108 2020-06-03 Madison Louisiana 22065 106 2
204109 204109 2020-06-03 Morehouse Louisiana 22067 131 5
204110 204110 2020-06-03 Natchitoches Louisiana 22069 173 13
204111 204111 2020-06-03 Orleans Louisiana 22071 7174 509
204112 204112 2020-06-03 Ouachita Louisiana 22073 1312 48
204113 204113 2020-06-03 Plaquemines Louisiana 22075 215 17
204114 204114 2020-06-03 Pointe Coupee Louisiana 22077 205 25
204115 204115 2020-06-03 Rapides Louisiana 22079 829 33
204116 204116 2020-06-03 Red River Louisiana 22081 50 7
204117 204117 2020-06-03 Richland Louisiana 22083 143 3
204118 204118 2020-06-03 Sabine Louisiana 22085 49 0
204119 204119 2020-06-03 St. Bernard Louisiana 22087 545 22
204120 204120 2020-06-03 St. Charles Louisiana 22089 647 45
204121 204121 2020-06-03 St. Helena Louisiana 22091 51 1
204122 204122 2020-06-03 St. James Louisiana 22093 303 27
204123 204123 2020-06-03 St. John the Baptist Louisiana 22095 868 82
204124 204124 2020-06-03 St. Landry Louisiana 22097 269 54
204125 204125 2020-06-03 St. Martin Louisiana 22099 306 23
204126 204126 2020-06-03 St. Mary Louisiana 22101 328 32
204127 204127 2020-06-03 St. Tammany Louisiana 22103 1790 162
204128 204128 2020-06-03 Tangipahoa Louisiana 22105 891 39
204129 204129 2020-06-03 Tensas Louisiana 22107 16 0
204130 204130 2020-06-03 Terrebonne Louisiana 22109 709 55
204131 204131 2020-06-03 Union Louisiana 22111 331 19
204132 204132 2020-06-03 Unknown Louisiana   196 111
204133 204133 2020-06-03 Vermilion Louisiana 22113 58 3
204134 204134 2020-06-03 Vernon Louisiana 22115 28 3
204135 204135 2020-06-03 Washington Louisiana 22117 444 39
204136 204136 2020-06-03 Webster Louisiana 22119 163 7
204137 204137 2020-06-03 West Baton Rouge Louisiana 22121 176 31
204138 204138 2020-06-03 West Carroll Louisiana 22123 68 0
204139 204139 2020-06-03 West Feliciana Louisiana 22125 215 13
204140 204140 2020-06-03 Winn Louisiana 22127 178 2

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