ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Plaquemines" and state = "Louisiana" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
4696 | 4696 | 2020-03-19 | Plaquemines | Louisiana | 22075 | 1 | 0 |
5512 | 5512 | 2020-03-20 | Plaquemines | Louisiana | 22075 | 1 | 0 |
6466 | 6466 | 2020-03-21 | Plaquemines | Louisiana | 22075 | 4 | 0 |
7541 | 7541 | 2020-03-22 | Plaquemines | Louisiana | 22075 | 5 | 0 |
8708 | 8708 | 2020-03-23 | Plaquemines | Louisiana | 22075 | 8 | 0 |
9996 | 9996 | 2020-03-24 | Plaquemines | Louisiana | 22075 | 8 | 0 |
11403 | 11403 | 2020-03-25 | Plaquemines | Louisiana | 22075 | 9 | 0 |
12981 | 12981 | 2020-03-26 | Plaquemines | Louisiana | 22075 | 13 | 0 |
14688 | 14688 | 2020-03-27 | Plaquemines | Louisiana | 22075 | 16 | 2 |
16508 | 16508 | 2020-03-28 | Plaquemines | Louisiana | 22075 | 19 | 2 |
18420 | 18420 | 2020-03-29 | Plaquemines | Louisiana | 22075 | 20 | 2 |
20436 | 20436 | 2020-03-30 | Plaquemines | Louisiana | 22075 | 22 | 2 |
22544 | 22544 | 2020-03-31 | Plaquemines | Louisiana | 22075 | 37 | 2 |
24720 | 24720 | 2020-04-01 | Plaquemines | Louisiana | 22075 | 47 | 4 |
26971 | 26971 | 2020-04-02 | Plaquemines | Louisiana | 22075 | 68 | 3 |
29288 | 29288 | 2020-04-03 | Plaquemines | Louisiana | 22075 | 75 | 4 |
31666 | 31666 | 2020-04-04 | Plaquemines | Louisiana | 22075 | 86 | 4 |
34091 | 34091 | 2020-04-05 | Plaquemines | Louisiana | 22075 | 92 | 6 |
36549 | 36549 | 2020-04-06 | Plaquemines | Louisiana | 22075 | 100 | 6 |
39057 | 39057 | 2020-04-07 | Plaquemines | Louisiana | 22075 | 115 | 7 |
41609 | 41609 | 2020-04-08 | Plaquemines | Louisiana | 22075 | 123 | 7 |
44185 | 44185 | 2020-04-09 | Plaquemines | Louisiana | 22075 | 129 | 8 |
46793 | 46793 | 2020-04-10 | Plaquemines | Louisiana | 22075 | 130 | 8 |
49434 | 49434 | 2020-04-11 | Plaquemines | Louisiana | 22075 | 136 | 11 |
52104 | 52104 | 2020-04-12 | Plaquemines | Louisiana | 22075 | 137 | 10 |
54785 | 54785 | 2020-04-13 | Plaquemines | Louisiana | 22075 | 140 | 11 |
57483 | 57483 | 2020-04-14 | Plaquemines | Louisiana | 22075 | 142 | 11 |
60191 | 60191 | 2020-04-15 | Plaquemines | Louisiana | 22075 | 147 | 11 |
62912 | 62912 | 2020-04-16 | Plaquemines | Louisiana | 22075 | 149 | 11 |
65651 | 65651 | 2020-04-17 | Plaquemines | Louisiana | 22075 | 152 | 11 |
68400 | 68400 | 2020-04-18 | Plaquemines | Louisiana | 22075 | 156 | 11 |
71163 | 71163 | 2020-04-19 | Plaquemines | Louisiana | 22075 | 157 | 11 |
73935 | 73935 | 2020-04-20 | Plaquemines | Louisiana | 22075 | 164 | 13 |
76715 | 76715 | 2020-04-21 | Plaquemines | Louisiana | 22075 | 164 | 13 |
79501 | 79501 | 2020-04-22 | Plaquemines | Louisiana | 22075 | 164 | 16 |
82297 | 82297 | 2020-04-23 | Plaquemines | Louisiana | 22075 | 165 | 16 |
85101 | 85101 | 2020-04-24 | Plaquemines | Louisiana | 22075 | 166 | 16 |
87910 | 87910 | 2020-04-25 | Plaquemines | Louisiana | 22075 | 168 | 16 |
90726 | 90726 | 2020-04-26 | Plaquemines | Louisiana | 22075 | 168 | 15 |
93547 | 93547 | 2020-04-27 | Plaquemines | Louisiana | 22075 | 168 | 17 |
96382 | 96382 | 2020-04-28 | Plaquemines | Louisiana | 22075 | 168 | 17 |
99228 | 99228 | 2020-04-29 | Plaquemines | Louisiana | 22075 | 172 | 17 |
102080 | 102080 | 2020-04-30 | Plaquemines | Louisiana | 22075 | 177 | 17 |
104941 | 104941 | 2020-05-01 | Plaquemines | Louisiana | 22075 | 179 | 17 |
107805 | 107805 | 2020-05-02 | Plaquemines | Louisiana | 22075 | 180 | 17 |
110677 | 110677 | 2020-05-03 | Plaquemines | Louisiana | 22075 | 180 | 17 |
113554 | 113554 | 2020-05-04 | Plaquemines | Louisiana | 22075 | 181 | 17 |
116436 | 116436 | 2020-05-05 | Plaquemines | Louisiana | 22075 | 181 | 17 |
119397 | 119397 | 2020-05-06 | Plaquemines | Louisiana | 22075 | 183 | 17 |
122368 | 122368 | 2020-05-07 | Plaquemines | Louisiana | 22075 | 185 | 17 |
125350 | 125350 | 2020-05-08 | Plaquemines | Louisiana | 22075 | 185 | 17 |
128337 | 128337 | 2020-05-09 | Plaquemines | Louisiana | 22075 | 189 | 17 |
131327 | 131327 | 2020-05-10 | Plaquemines | Louisiana | 22075 | 190 | 17 |
134318 | 134318 | 2020-05-11 | Plaquemines | Louisiana | 22075 | 190 | 17 |
137308 | 137308 | 2020-05-12 | Plaquemines | Louisiana | 22075 | 191 | 19 |
140302 | 140302 | 2020-05-13 | Plaquemines | Louisiana | 22075 | 191 | 16 |
143297 | 143297 | 2020-05-14 | Plaquemines | Louisiana | 22075 | 192 | 16 |
146297 | 146297 | 2020-05-15 | Plaquemines | Louisiana | 22075 | 193 | 16 |
149302 | 149302 | 2020-05-16 | Plaquemines | Louisiana | 22075 | 194 | 16 |
152313 | 152313 | 2020-05-17 | Plaquemines | Louisiana | 22075 | 194 | 16 |
155327 | 155327 | 2020-05-18 | Plaquemines | Louisiana | 22075 | 194 | 16 |
158345 | 158345 | 2020-05-19 | Plaquemines | Louisiana | 22075 | 196 | 16 |
161371 | 161371 | 2020-05-20 | Plaquemines | Louisiana | 22075 | 197 | 16 |
164400 | 164400 | 2020-05-21 | Plaquemines | Louisiana | 22075 | 197 | 16 |
167436 | 167436 | 2020-05-22 | Plaquemines | Louisiana | 22075 | 198 | 16 |
170474 | 170474 | 2020-05-23 | Plaquemines | Louisiana | 22075 | 198 | 16 |
173515 | 173515 | 2020-05-24 | Plaquemines | Louisiana | 22075 | 200 | 16 |
176559 | 176559 | 2020-05-25 | Plaquemines | Louisiana | 22075 | 200 | 16 |
179603 | 179603 | 2020-05-26 | Plaquemines | Louisiana | 22075 | 200 | 17 |
182648 | 182648 | 2020-05-27 | Plaquemines | Louisiana | 22075 | 201 | 17 |
185703 | 185703 | 2020-05-28 | Plaquemines | Louisiana | 22075 | 201 | 17 |
188761 | 188761 | 2020-05-29 | Plaquemines | Louisiana | 22075 | 201 | 17 |
191825 | 191825 | 2020-05-30 | Plaquemines | Louisiana | 22075 | 211 | 17 |
194893 | 194893 | 2020-05-31 | Plaquemines | Louisiana | 22075 | 211 | 17 |
197964 | 197964 | 2020-06-01 | Plaquemines | Louisiana | 22075 | 213 | 17 |
201036 | 201036 | 2020-06-02 | Plaquemines | Louisiana | 22075 | 215 | 17 |
204113 | 204113 | 2020-06-03 | Plaquemines | Louisiana | 22075 | 215 | 17 |
207194 | 207194 | 2020-06-04 | Plaquemines | Louisiana | 22075 | 217 | 17 |
210275 | 210275 | 2020-06-05 | Plaquemines | Louisiana | 22075 | 218 | 17 |
213360 | 213360 | 2020-06-06 | Plaquemines | Louisiana | 22075 | 218 | 17 |
216447 | 216447 | 2020-06-07 | Plaquemines | Louisiana | 22075 | 218 | 17 |
219539 | 219539 | 2020-06-08 | Plaquemines | Louisiana | 22075 | 218 | 17 |
222634 | 222634 | 2020-06-09 | Plaquemines | Louisiana | 22075 | 219 | 17 |
225730 | 225730 | 2020-06-10 | Plaquemines | Louisiana | 22075 | 220 | 17 |
228832 | 228832 | 2020-06-11 | Plaquemines | Louisiana | 22075 | 222 | 17 |
231936 | 231936 | 2020-06-12 | Plaquemines | Louisiana | 22075 | 223 | 17 |
235041 | 235041 | 2020-06-13 | Plaquemines | Louisiana | 22075 | 228 | 17 |
238148 | 238148 | 2020-06-14 | Plaquemines | Louisiana | 22075 | 228 | 17 |
241257 | 241257 | 2020-06-15 | Plaquemines | Louisiana | 22075 | 228 | 17 |
244368 | 244368 | 2020-06-16 | Plaquemines | Louisiana | 22075 | 228 | 17 |
247481 | 247481 | 2020-06-17 | Plaquemines | Louisiana | 22075 | 228 | 17 |
250593 | 250593 | 2020-06-18 | Plaquemines | Louisiana | 22075 | 228 | 17 |
253708 | 253708 | 2020-06-19 | Plaquemines | Louisiana | 22075 | 234 | 17 |
256828 | 256828 | 2020-06-20 | Plaquemines | Louisiana | 22075 | 237 | 17 |
259954 | 259954 | 2020-06-21 | Plaquemines | Louisiana | 22075 | 239 | 17 |
263083 | 263083 | 2020-06-22 | Plaquemines | Louisiana | 22075 | 239 | 17 |
266210 | 266210 | 2020-06-23 | Plaquemines | Louisiana | 22075 | 244 | 17 |
269343 | 269343 | 2020-06-24 | Plaquemines | Louisiana | 22075 | 245 | 17 |
272479 | 272479 | 2020-06-25 | Plaquemines | Louisiana | 22075 | 248 | 17 |
275622 | 275622 | 2020-06-26 | Plaquemines | Louisiana | 22075 | 252 | 17 |
Advanced export
JSON shape: default, array, newline-delimited
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);