ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where fips = 22115 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387111 | 387111 | 2020-07-31 | Vernon | Louisiana | 22115 | 663 | 21 |
383893 | 383893 | 2020-07-30 | Vernon | Louisiana | 22115 | 654 | 21 |
380676 | 380676 | 2020-07-29 | Vernon | Louisiana | 22115 | 631 | 21 |
377459 | 377459 | 2020-07-28 | Vernon | Louisiana | 22115 | 611 | 19 |
374244 | 374244 | 2020-07-27 | Vernon | Louisiana | 22115 | 599 | 19 |
371032 | 371032 | 2020-07-26 | Vernon | Louisiana | 22115 | 587 | 19 |
367822 | 367822 | 2020-07-25 | Vernon | Louisiana | 22115 | 544 | 18 |
364615 | 364615 | 2020-07-24 | Vernon | Louisiana | 22115 | 544 | 18 |
361408 | 361408 | 2020-07-23 | Vernon | Louisiana | 22115 | 520 | 17 |
358203 | 358203 | 2020-07-22 | Vernon | Louisiana | 22115 | 478 | 16 |
355000 | 355000 | 2020-07-21 | Vernon | Louisiana | 22115 | 445 | 15 |
351798 | 351798 | 2020-07-20 | Vernon | Louisiana | 22115 | 429 | 13 |
348598 | 348598 | 2020-07-19 | Vernon | Louisiana | 22115 | 386 | 13 |
345397 | 345397 | 2020-07-18 | Vernon | Louisiana | 22115 | 346 | 12 |
342197 | 342197 | 2020-07-17 | Vernon | Louisiana | 22115 | 346 | 12 |
339001 | 339001 | 2020-07-16 | Vernon | Louisiana | 22115 | 322 | 11 |
335805 | 335805 | 2020-07-15 | Vernon | Louisiana | 22115 | 319 | 10 |
332612 | 332612 | 2020-07-14 | Vernon | Louisiana | 22115 | 301 | 10 |
329425 | 329425 | 2020-07-13 | Vernon | Louisiana | 22115 | 288 | 9 |
326239 | 326239 | 2020-07-12 | Vernon | Louisiana | 22115 | 277 | 9 |
323056 | 323056 | 2020-07-11 | Vernon | Louisiana | 22115 | 263 | 9 |
319877 | 319877 | 2020-07-10 | Vernon | Louisiana | 22115 | 247 | 9 |
316702 | 316702 | 2020-07-09 | Vernon | Louisiana | 22115 | 237 | 9 |
313528 | 313528 | 2020-07-08 | Vernon | Louisiana | 22115 | 223 | 9 |
310358 | 310358 | 2020-07-07 | Vernon | Louisiana | 22115 | 217 | 9 |
307190 | 307190 | 2020-07-06 | Vernon | Louisiana | 22115 | 187 | 8 |
304023 | 304023 | 2020-07-05 | Vernon | Louisiana | 22115 | 179 | 8 |
300859 | 300859 | 2020-07-04 | Vernon | Louisiana | 22115 | 164 | 8 |
297697 | 297697 | 2020-07-03 | Vernon | Louisiana | 22115 | 164 | 8 |
294539 | 294539 | 2020-07-02 | Vernon | Louisiana | 22115 | 159 | 8 |
291385 | 291385 | 2020-07-01 | Vernon | Louisiana | 22115 | 153 | 8 |
288234 | 288234 | 2020-06-30 | Vernon | Louisiana | 22115 | 138 | 8 |
285085 | 285085 | 2020-06-29 | Vernon | Louisiana | 22115 | 116 | 7 |
281939 | 281939 | 2020-06-28 | Vernon | Louisiana | 22115 | 111 | 7 |
278791 | 278791 | 2020-06-27 | Vernon | Louisiana | 22115 | 107 | 7 |
275643 | 275643 | 2020-06-26 | Vernon | Louisiana | 22115 | 107 | 7 |
272500 | 272500 | 2020-06-25 | Vernon | Louisiana | 22115 | 96 | 6 |
269364 | 269364 | 2020-06-24 | Vernon | Louisiana | 22115 | 91 | 6 |
266231 | 266231 | 2020-06-23 | Vernon | Louisiana | 22115 | 89 | 6 |
263104 | 263104 | 2020-06-22 | Vernon | Louisiana | 22115 | 77 | 5 |
259975 | 259975 | 2020-06-21 | Vernon | Louisiana | 22115 | 76 | 4 |
256849 | 256849 | 2020-06-20 | Vernon | Louisiana | 22115 | 74 | 4 |
253729 | 253729 | 2020-06-19 | Vernon | Louisiana | 22115 | 73 | 4 |
250614 | 250614 | 2020-06-18 | Vernon | Louisiana | 22115 | 67 | 3 |
247502 | 247502 | 2020-06-17 | Vernon | Louisiana | 22115 | 67 | 3 |
244389 | 244389 | 2020-06-16 | Vernon | Louisiana | 22115 | 58 | 3 |
241278 | 241278 | 2020-06-15 | Vernon | Louisiana | 22115 | 54 | 3 |
238169 | 238169 | 2020-06-14 | Vernon | Louisiana | 22115 | 53 | 3 |
235062 | 235062 | 2020-06-13 | Vernon | Louisiana | 22115 | 51 | 3 |
231957 | 231957 | 2020-06-12 | Vernon | Louisiana | 22115 | 43 | 3 |
228853 | 228853 | 2020-06-11 | Vernon | Louisiana | 22115 | 39 | 3 |
225751 | 225751 | 2020-06-10 | Vernon | Louisiana | 22115 | 39 | 3 |
222655 | 222655 | 2020-06-09 | Vernon | Louisiana | 22115 | 39 | 3 |
219560 | 219560 | 2020-06-08 | Vernon | Louisiana | 22115 | 34 | 3 |
216468 | 216468 | 2020-06-07 | Vernon | Louisiana | 22115 | 34 | 3 |
213381 | 213381 | 2020-06-06 | Vernon | Louisiana | 22115 | 33 | 3 |
210296 | 210296 | 2020-06-05 | Vernon | Louisiana | 22115 | 31 | 3 |
207215 | 207215 | 2020-06-04 | Vernon | Louisiana | 22115 | 29 | 3 |
204134 | 204134 | 2020-06-03 | Vernon | Louisiana | 22115 | 28 | 3 |
201057 | 201057 | 2020-06-02 | Vernon | Louisiana | 22115 | 28 | 3 |
197985 | 197985 | 2020-06-01 | Vernon | Louisiana | 22115 | 26 | 3 |
194914 | 194914 | 2020-05-31 | Vernon | Louisiana | 22115 | 26 | 3 |
191846 | 191846 | 2020-05-30 | Vernon | Louisiana | 22115 | 25 | 3 |
188782 | 188782 | 2020-05-29 | Vernon | Louisiana | 22115 | 25 | 3 |
185724 | 185724 | 2020-05-28 | Vernon | Louisiana | 22115 | 25 | 3 |
182669 | 182669 | 2020-05-27 | Vernon | Louisiana | 22115 | 24 | 3 |
179624 | 179624 | 2020-05-26 | Vernon | Louisiana | 22115 | 24 | 3 |
176580 | 176580 | 2020-05-25 | Vernon | Louisiana | 22115 | 24 | 3 |
173536 | 173536 | 2020-05-24 | Vernon | Louisiana | 22115 | 23 | 3 |
170495 | 170495 | 2020-05-23 | Vernon | Louisiana | 22115 | 23 | 3 |
167457 | 167457 | 2020-05-22 | Vernon | Louisiana | 22115 | 23 | 3 |
164421 | 164421 | 2020-05-21 | Vernon | Louisiana | 22115 | 22 | 2 |
161392 | 161392 | 2020-05-20 | Vernon | Louisiana | 22115 | 21 | 2 |
158366 | 158366 | 2020-05-19 | Vernon | Louisiana | 22115 | 21 | 2 |
155348 | 155348 | 2020-05-18 | Vernon | Louisiana | 22115 | 21 | 2 |
152334 | 152334 | 2020-05-17 | Vernon | Louisiana | 22115 | 20 | 2 |
149323 | 149323 | 2020-05-16 | Vernon | Louisiana | 22115 | 20 | 2 |
146318 | 146318 | 2020-05-15 | Vernon | Louisiana | 22115 | 19 | 2 |
143318 | 143318 | 2020-05-14 | Vernon | Louisiana | 22115 | 19 | 2 |
140323 | 140323 | 2020-05-13 | Vernon | Louisiana | 22115 | 19 | 2 |
137329 | 137329 | 2020-05-12 | Vernon | Louisiana | 22115 | 18 | 2 |
134339 | 134339 | 2020-05-11 | Vernon | Louisiana | 22115 | 18 | 2 |
131348 | 131348 | 2020-05-10 | Vernon | Louisiana | 22115 | 18 | 2 |
128358 | 128358 | 2020-05-09 | Vernon | Louisiana | 22115 | 18 | 2 |
125371 | 125371 | 2020-05-08 | Vernon | Louisiana | 22115 | 17 | 2 |
122389 | 122389 | 2020-05-07 | Vernon | Louisiana | 22115 | 17 | 2 |
119418 | 119418 | 2020-05-06 | Vernon | Louisiana | 22115 | 17 | 2 |
116457 | 116457 | 2020-05-05 | Vernon | Louisiana | 22115 | 17 | 2 |
113575 | 113575 | 2020-05-04 | Vernon | Louisiana | 22115 | 16 | 2 |
110698 | 110698 | 2020-05-03 | Vernon | Louisiana | 22115 | 16 | 2 |
107826 | 107826 | 2020-05-02 | Vernon | Louisiana | 22115 | 16 | 2 |
104962 | 104962 | 2020-05-01 | Vernon | Louisiana | 22115 | 16 | 2 |
102101 | 102101 | 2020-04-30 | Vernon | Louisiana | 22115 | 16 | 2 |
99249 | 99249 | 2020-04-29 | Vernon | Louisiana | 22115 | 16 | 2 |
96403 | 96403 | 2020-04-28 | Vernon | Louisiana | 22115 | 16 | 2 |
93568 | 93568 | 2020-04-27 | Vernon | Louisiana | 22115 | 16 | 2 |
90747 | 90747 | 2020-04-26 | Vernon | Louisiana | 22115 | 16 | 2 |
87931 | 87931 | 2020-04-25 | Vernon | Louisiana | 22115 | 16 | 2 |
85122 | 85122 | 2020-04-24 | Vernon | Louisiana | 22115 | 15 | 1 |
82318 | 82318 | 2020-04-23 | Vernon | Louisiana | 22115 | 14 | 1 |
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);