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 descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535578 | 535578 | 2020-09-15 | Plaquemines | Louisiana | 22075 | 657 | 19 |
532343 | 532343 | 2020-09-14 | Plaquemines | Louisiana | 22075 | 663 | 19 |
529106 | 529106 | 2020-09-13 | Plaquemines | Louisiana | 22075 | 662 | 19 |
525870 | 525870 | 2020-09-12 | Plaquemines | Louisiana | 22075 | 657 | 19 |
522634 | 522634 | 2020-09-11 | Plaquemines | Louisiana | 22075 | 657 | 19 |
519397 | 519397 | 2020-09-10 | Plaquemines | Louisiana | 22075 | 659 | 19 |
516162 | 516162 | 2020-09-09 | Plaquemines | Louisiana | 22075 | 645 | 19 |
512929 | 512929 | 2020-09-08 | Plaquemines | Louisiana | 22075 | 635 | 19 |
509697 | 509697 | 2020-09-07 | Plaquemines | Louisiana | 22075 | 656 | 19 |
506464 | 506464 | 2020-09-06 | Plaquemines | Louisiana | 22075 | 658 | 19 |
503230 | 503230 | 2020-09-05 | Plaquemines | Louisiana | 22075 | 643 | 19 |
499997 | 499997 | 2020-09-04 | Plaquemines | Louisiana | 22075 | 643 | 19 |
496763 | 496763 | 2020-09-03 | Plaquemines | Louisiana | 22075 | 619 | 19 |
493530 | 493530 | 2020-09-02 | Plaquemines | Louisiana | 22075 | 590 | 19 |
490296 | 490296 | 2020-09-01 | Plaquemines | Louisiana | 22075 | 538 | 19 |
487063 | 487063 | 2020-08-31 | Plaquemines | Louisiana | 22075 | 525 | 19 |
483828 | 483828 | 2020-08-30 | Plaquemines | Louisiana | 22075 | 521 | 19 |
480594 | 480594 | 2020-08-29 | Plaquemines | Louisiana | 22075 | 491 | 19 |
477361 | 477361 | 2020-08-28 | Plaquemines | Louisiana | 22075 | 491 | 19 |
474128 | 474128 | 2020-08-27 | Plaquemines | Louisiana | 22075 | 490 | 19 |
470896 | 470896 | 2020-08-26 | Plaquemines | Louisiana | 22075 | 487 | 19 |
467667 | 467667 | 2020-08-25 | Plaquemines | Louisiana | 22075 | 487 | 19 |
464438 | 464438 | 2020-08-24 | Plaquemines | Louisiana | 22075 | 489 | 19 |
461207 | 461207 | 2020-08-23 | Plaquemines | Louisiana | 22075 | 489 | 19 |
457980 | 457980 | 2020-08-22 | Plaquemines | Louisiana | 22075 | 481 | 19 |
454752 | 454752 | 2020-08-21 | Plaquemines | Louisiana | 22075 | 481 | 19 |
451524 | 451524 | 2020-08-20 | Plaquemines | Louisiana | 22075 | 482 | 19 |
448296 | 448296 | 2020-08-19 | Plaquemines | Louisiana | 22075 | 481 | 19 |
445069 | 445069 | 2020-08-18 | Plaquemines | Louisiana | 22075 | 479 | 19 |
441843 | 441843 | 2020-08-17 | Plaquemines | Louisiana | 22075 | 478 | 19 |
438616 | 438616 | 2020-08-16 | Plaquemines | Louisiana | 22075 | 472 | 19 |
435391 | 435391 | 2020-08-15 | Plaquemines | Louisiana | 22075 | 469 | 19 |
432166 | 432166 | 2020-08-14 | Plaquemines | Louisiana | 22075 | 469 | 19 |
428938 | 428938 | 2020-08-13 | Plaquemines | Louisiana | 22075 | 465 | 19 |
425714 | 425714 | 2020-08-12 | Plaquemines | Louisiana | 22075 | 462 | 19 |
422493 | 422493 | 2020-08-11 | Plaquemines | Louisiana | 22075 | 461 | 19 |
419271 | 419271 | 2020-08-10 | Plaquemines | Louisiana | 22075 | 460 | 19 |
416050 | 416050 | 2020-08-09 | Plaquemines | Louisiana | 22075 | 458 | 19 |
412830 | 412830 | 2020-08-08 | Plaquemines | Louisiana | 22075 | 451 | 19 |
409610 | 409610 | 2020-08-07 | Plaquemines | Louisiana | 22075 | 451 | 19 |
406390 | 406390 | 2020-08-06 | Plaquemines | Louisiana | 22075 | 432 | 19 |
403172 | 403172 | 2020-08-05 | Plaquemines | Louisiana | 22075 | 430 | 19 |
399955 | 399955 | 2020-08-04 | Plaquemines | Louisiana | 22075 | 428 | 19 |
396740 | 396740 | 2020-08-03 | Plaquemines | Louisiana | 22075 | 425 | 19 |
393524 | 393524 | 2020-08-02 | Plaquemines | Louisiana | 22075 | 425 | 19 |
390307 | 390307 | 2020-08-01 | Plaquemines | Louisiana | 22075 | 420 | 19 |
387090 | 387090 | 2020-07-31 | Plaquemines | Louisiana | 22075 | 420 | 19 |
383872 | 383872 | 2020-07-30 | Plaquemines | Louisiana | 22075 | 419 | 18 |
380655 | 380655 | 2020-07-29 | Plaquemines | Louisiana | 22075 | 417 | 18 |
377438 | 377438 | 2020-07-28 | Plaquemines | Louisiana | 22075 | 382 | 18 |
374223 | 374223 | 2020-07-27 | Plaquemines | Louisiana | 22075 | 381 | 18 |
371011 | 371011 | 2020-07-26 | Plaquemines | Louisiana | 22075 | 378 | 18 |
367801 | 367801 | 2020-07-25 | Plaquemines | Louisiana | 22075 | 367 | 18 |
364594 | 364594 | 2020-07-24 | Plaquemines | Louisiana | 22075 | 367 | 18 |
361387 | 361387 | 2020-07-23 | Plaquemines | Louisiana | 22075 | 362 | 18 |
358182 | 358182 | 2020-07-22 | Plaquemines | Louisiana | 22075 | 357 | 18 |
354979 | 354979 | 2020-07-21 | Plaquemines | Louisiana | 22075 | 344 | 18 |
351777 | 351777 | 2020-07-20 | Plaquemines | Louisiana | 22075 | 344 | 18 |
348577 | 348577 | 2020-07-19 | Plaquemines | Louisiana | 22075 | 341 | 18 |
345376 | 345376 | 2020-07-18 | Plaquemines | Louisiana | 22075 | 338 | 18 |
342176 | 342176 | 2020-07-17 | Plaquemines | Louisiana | 22075 | 338 | 18 |
338980 | 338980 | 2020-07-16 | Plaquemines | Louisiana | 22075 | 332 | 18 |
335784 | 335784 | 2020-07-15 | Plaquemines | Louisiana | 22075 | 327 | 18 |
332591 | 332591 | 2020-07-14 | Plaquemines | Louisiana | 22075 | 322 | 18 |
329404 | 329404 | 2020-07-13 | Plaquemines | Louisiana | 22075 | 315 | 18 |
326218 | 326218 | 2020-07-12 | Plaquemines | Louisiana | 22075 | 310 | 18 |
323035 | 323035 | 2020-07-11 | Plaquemines | Louisiana | 22075 | 306 | 18 |
319856 | 319856 | 2020-07-10 | Plaquemines | Louisiana | 22075 | 298 | 17 |
316681 | 316681 | 2020-07-09 | Plaquemines | Louisiana | 22075 | 294 | 17 |
313507 | 313507 | 2020-07-08 | Plaquemines | Louisiana | 22075 | 291 | 17 |
310337 | 310337 | 2020-07-07 | Plaquemines | Louisiana | 22075 | 288 | 17 |
307169 | 307169 | 2020-07-06 | Plaquemines | Louisiana | 22075 | 280 | 17 |
304002 | 304002 | 2020-07-05 | Plaquemines | Louisiana | 22075 | 278 | 17 |
300838 | 300838 | 2020-07-04 | Plaquemines | Louisiana | 22075 | 273 | 17 |
297676 | 297676 | 2020-07-03 | Plaquemines | Louisiana | 22075 | 273 | 17 |
294518 | 294518 | 2020-07-02 | Plaquemines | Louisiana | 22075 | 272 | 17 |
291364 | 291364 | 2020-07-01 | Plaquemines | Louisiana | 22075 | 270 | 17 |
288213 | 288213 | 2020-06-30 | Plaquemines | Louisiana | 22075 | 261 | 17 |
285064 | 285064 | 2020-06-29 | Plaquemines | Louisiana | 22075 | 260 | 17 |
281918 | 281918 | 2020-06-28 | Plaquemines | Louisiana | 22075 | 257 | 17 |
278770 | 278770 | 2020-06-27 | Plaquemines | Louisiana | 22075 | 252 | 17 |
275622 | 275622 | 2020-06-26 | Plaquemines | Louisiana | 22075 | 252 | 17 |
272479 | 272479 | 2020-06-25 | Plaquemines | Louisiana | 22075 | 248 | 17 |
269343 | 269343 | 2020-06-24 | Plaquemines | Louisiana | 22075 | 245 | 17 |
266210 | 266210 | 2020-06-23 | Plaquemines | Louisiana | 22075 | 244 | 17 |
263083 | 263083 | 2020-06-22 | Plaquemines | Louisiana | 22075 | 239 | 17 |
259954 | 259954 | 2020-06-21 | Plaquemines | Louisiana | 22075 | 239 | 17 |
256828 | 256828 | 2020-06-20 | Plaquemines | Louisiana | 22075 | 237 | 17 |
253708 | 253708 | 2020-06-19 | Plaquemines | Louisiana | 22075 | 234 | 17 |
250593 | 250593 | 2020-06-18 | Plaquemines | Louisiana | 22075 | 228 | 17 |
247481 | 247481 | 2020-06-17 | Plaquemines | Louisiana | 22075 | 228 | 17 |
244368 | 244368 | 2020-06-16 | Plaquemines | Louisiana | 22075 | 228 | 17 |
241257 | 241257 | 2020-06-15 | Plaquemines | Louisiana | 22075 | 228 | 17 |
238148 | 238148 | 2020-06-14 | Plaquemines | Louisiana | 22075 | 228 | 17 |
235041 | 235041 | 2020-06-13 | Plaquemines | Louisiana | 22075 | 228 | 17 |
231936 | 231936 | 2020-06-12 | Plaquemines | Louisiana | 22075 | 223 | 17 |
228832 | 228832 | 2020-06-11 | Plaquemines | Louisiana | 22075 | 222 | 17 |
225730 | 225730 | 2020-06-10 | Plaquemines | Louisiana | 22075 | 220 | 17 |
222634 | 222634 | 2020-06-09 | Plaquemines | Louisiana | 22075 | 219 | 17 |
219539 | 219539 | 2020-06-08 | Plaquemines | Louisiana | 22075 | 218 | 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);