ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Union" and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636060 | 636060 | 2020-10-16 | Union | Louisiana | 22111 | 1058 | 49 |
632814 | 632814 | 2020-10-15 | Union | Louisiana | 22111 | 1053 | 49 |
629570 | 629570 | 2020-10-14 | Union | Louisiana | 22111 | 1042 | 49 |
626326 | 626326 | 2020-10-13 | Union | Louisiana | 22111 | 1041 | 49 |
623084 | 623084 | 2020-10-12 | Union | Louisiana | 22111 | 1033 | 46 |
619840 | 619840 | 2020-10-11 | Union | Louisiana | 22111 | 1035 | 46 |
616598 | 616598 | 2020-10-10 | Union | Louisiana | 22111 | 1020 | 46 |
613357 | 613357 | 2020-10-09 | Union | Louisiana | 22111 | 1020 | 46 |
610115 | 610115 | 2020-10-08 | Union | Louisiana | 22111 | 1019 | 46 |
606873 | 606873 | 2020-10-07 | Union | Louisiana | 22111 | 1015 | 46 |
603631 | 603631 | 2020-10-06 | Union | Louisiana | 22111 | 1011 | 46 |
600388 | 600388 | 2020-10-05 | Union | Louisiana | 22111 | 1008 | 46 |
597146 | 597146 | 2020-10-04 | Union | Louisiana | 22111 | 1007 | 46 |
593904 | 593904 | 2020-10-03 | Union | Louisiana | 22111 | 997 | 46 |
590663 | 590663 | 2020-10-02 | Union | Louisiana | 22111 | 997 | 46 |
587422 | 587422 | 2020-10-01 | Union | Louisiana | 22111 | 975 | 44 |
584182 | 584182 | 2020-09-30 | Union | Louisiana | 22111 | 969 | 44 |
580942 | 580942 | 2020-09-29 | Union | Louisiana | 22111 | 967 | 43 |
577701 | 577701 | 2020-09-28 | Union | Louisiana | 22111 | 969 | 43 |
574459 | 574459 | 2020-09-27 | Union | Louisiana | 22111 | 969 | 43 |
571216 | 571216 | 2020-09-26 | Union | Louisiana | 22111 | 963 | 42 |
567974 | 567974 | 2020-09-25 | Union | Louisiana | 22111 | 963 | 42 |
564734 | 564734 | 2020-09-24 | Union | Louisiana | 22111 | 954 | 42 |
561494 | 561494 | 2020-09-23 | Union | Louisiana | 22111 | 959 | 42 |
558258 | 558258 | 2020-09-22 | Union | Louisiana | 22111 | 953 | 42 |
555021 | 555021 | 2020-09-21 | Union | Louisiana | 22111 | 945 | 42 |
551782 | 551782 | 2020-09-20 | Union | Louisiana | 22111 | 942 | 42 |
548543 | 548543 | 2020-09-19 | Union | Louisiana | 22111 | 940 | 42 |
545305 | 545305 | 2020-09-18 | Union | Louisiana | 22111 | 940 | 42 |
542069 | 542069 | 2020-09-17 | Union | Louisiana | 22111 | 926 | 41 |
538833 | 538833 | 2020-09-16 | Union | Louisiana | 22111 | 923 | 41 |
535596 | 535596 | 2020-09-15 | Union | Louisiana | 22111 | 919 | 41 |
532361 | 532361 | 2020-09-14 | Union | Louisiana | 22111 | 913 | 41 |
529124 | 529124 | 2020-09-13 | Union | Louisiana | 22111 | 909 | 41 |
525888 | 525888 | 2020-09-12 | Union | Louisiana | 22111 | 898 | 41 |
522652 | 522652 | 2020-09-11 | Union | Louisiana | 22111 | 898 | 41 |
519415 | 519415 | 2020-09-10 | Union | Louisiana | 22111 | 896 | 40 |
516180 | 516180 | 2020-09-09 | Union | Louisiana | 22111 | 891 | 39 |
512947 | 512947 | 2020-09-08 | Union | Louisiana | 22111 | 863 | 39 |
509715 | 509715 | 2020-09-07 | Union | Louisiana | 22111 | 858 | 39 |
506482 | 506482 | 2020-09-06 | Union | Louisiana | 22111 | 855 | 39 |
503248 | 503248 | 2020-09-05 | Union | Louisiana | 22111 | 855 | 39 |
500015 | 500015 | 2020-09-04 | Union | Louisiana | 22111 | 855 | 39 |
496781 | 496781 | 2020-09-03 | Union | Louisiana | 22111 | 852 | 39 |
493548 | 493548 | 2020-09-02 | Union | Louisiana | 22111 | 845 | 39 |
490314 | 490314 | 2020-09-01 | Union | Louisiana | 22111 | 829 | 39 |
487081 | 487081 | 2020-08-31 | Union | Louisiana | 22111 | 825 | 39 |
483846 | 483846 | 2020-08-30 | Union | Louisiana | 22111 | 823 | 39 |
480612 | 480612 | 2020-08-29 | Union | Louisiana | 22111 | 818 | 39 |
477379 | 477379 | 2020-08-28 | Union | Louisiana | 22111 | 818 | 39 |
474146 | 474146 | 2020-08-27 | Union | Louisiana | 22111 | 807 | 39 |
470914 | 470914 | 2020-08-26 | Union | Louisiana | 22111 | 806 | 39 |
467685 | 467685 | 2020-08-25 | Union | Louisiana | 22111 | 796 | 39 |
464456 | 464456 | 2020-08-24 | Union | Louisiana | 22111 | 788 | 39 |
461225 | 461225 | 2020-08-23 | Union | Louisiana | 22111 | 783 | 39 |
457998 | 457998 | 2020-08-22 | Union | Louisiana | 22111 | 772 | 36 |
454770 | 454770 | 2020-08-21 | Union | Louisiana | 22111 | 772 | 36 |
451542 | 451542 | 2020-08-20 | Union | Louisiana | 22111 | 768 | 35 |
448314 | 448314 | 2020-08-19 | Union | Louisiana | 22111 | 762 | 35 |
445087 | 445087 | 2020-08-18 | Union | Louisiana | 22111 | 756 | 35 |
441861 | 441861 | 2020-08-17 | Union | Louisiana | 22111 | 754 | 35 |
438634 | 438634 | 2020-08-16 | Union | Louisiana | 22111 | 752 | 35 |
435409 | 435409 | 2020-08-15 | Union | Louisiana | 22111 | 737 | 35 |
432184 | 432184 | 2020-08-14 | Union | Louisiana | 22111 | 737 | 35 |
428956 | 428956 | 2020-08-13 | Union | Louisiana | 22111 | 732 | 35 |
425732 | 425732 | 2020-08-12 | Union | Louisiana | 22111 | 720 | 35 |
422511 | 422511 | 2020-08-11 | Union | Louisiana | 22111 | 711 | 35 |
419289 | 419289 | 2020-08-10 | Union | Louisiana | 22111 | 708 | 33 |
416068 | 416068 | 2020-08-09 | Union | Louisiana | 22111 | 706 | 33 |
412848 | 412848 | 2020-08-08 | Union | Louisiana | 22111 | 675 | 33 |
409628 | 409628 | 2020-08-07 | Union | Louisiana | 22111 | 675 | 33 |
406408 | 406408 | 2020-08-06 | Union | Louisiana | 22111 | 669 | 33 |
403190 | 403190 | 2020-08-05 | Union | Louisiana | 22111 | 652 | 33 |
399973 | 399973 | 2020-08-04 | Union | Louisiana | 22111 | 646 | 33 |
396758 | 396758 | 2020-08-03 | Union | Louisiana | 22111 | 623 | 33 |
393542 | 393542 | 2020-08-02 | Union | Louisiana | 22111 | 619 | 33 |
390325 | 390325 | 2020-08-01 | Union | Louisiana | 22111 | 596 | 32 |
387108 | 387108 | 2020-07-31 | Union | Louisiana | 22111 | 596 | 32 |
383890 | 383890 | 2020-07-30 | Union | Louisiana | 22111 | 573 | 32 |
380673 | 380673 | 2020-07-29 | Union | Louisiana | 22111 | 561 | 31 |
377456 | 377456 | 2020-07-28 | Union | Louisiana | 22111 | 551 | 31 |
374241 | 374241 | 2020-07-27 | Union | Louisiana | 22111 | 547 | 31 |
371029 | 371029 | 2020-07-26 | Union | Louisiana | 22111 | 543 | 31 |
367819 | 367819 | 2020-07-25 | Union | Louisiana | 22111 | 533 | 31 |
364612 | 364612 | 2020-07-24 | Union | Louisiana | 22111 | 533 | 31 |
361405 | 361405 | 2020-07-23 | Union | Louisiana | 22111 | 525 | 31 |
358200 | 358200 | 2020-07-22 | Union | Louisiana | 22111 | 519 | 30 |
354997 | 354997 | 2020-07-21 | Union | Louisiana | 22111 | 511 | 30 |
351795 | 351795 | 2020-07-20 | Union | Louisiana | 22111 | 506 | 30 |
348595 | 348595 | 2020-07-19 | Union | Louisiana | 22111 | 499 | 30 |
345394 | 345394 | 2020-07-18 | Union | Louisiana | 22111 | 495 | 30 |
342194 | 342194 | 2020-07-17 | Union | Louisiana | 22111 | 495 | 30 |
338998 | 338998 | 2020-07-16 | Union | Louisiana | 22111 | 491 | 30 |
335802 | 335802 | 2020-07-15 | Union | Louisiana | 22111 | 488 | 29 |
332609 | 332609 | 2020-07-14 | Union | Louisiana | 22111 | 483 | 28 |
329422 | 329422 | 2020-07-13 | Union | Louisiana | 22111 | 478 | 28 |
326236 | 326236 | 2020-07-12 | Union | Louisiana | 22111 | 476 | 28 |
323053 | 323053 | 2020-07-11 | Union | Louisiana | 22111 | 474 | 28 |
319874 | 319874 | 2020-07-10 | Union | Louisiana | 22111 | 471 | 27 |
316699 | 316699 | 2020-07-09 | Union | Louisiana | 22111 | 463 | 27 |
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);