ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "East Baton Rouge" and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
947537 | 947537 | 2021-01-20 | East Baton Rouge | Louisiana | 22033 | 30494 | 648 |
944290 | 944290 | 2021-01-19 | East Baton Rouge | Louisiana | 22033 | 30414 | 641 |
941045 | 941045 | 2021-01-18 | East Baton Rouge | Louisiana | 22033 | 30265 | 639 |
937800 | 937800 | 2021-01-17 | East Baton Rouge | Louisiana | 22033 | 30192 | 635 |
934555 | 934555 | 2021-01-16 | East Baton Rouge | Louisiana | 22033 | 29843 | 626 |
931310 | 931310 | 2021-01-15 | East Baton Rouge | Louisiana | 22033 | 29843 | 626 |
928065 | 928065 | 2021-01-14 | East Baton Rouge | Louisiana | 22033 | 29529 | 626 |
924819 | 924819 | 2021-01-13 | East Baton Rouge | Louisiana | 22033 | 28562 | 620 |
921574 | 921574 | 2021-01-12 | East Baton Rouge | Louisiana | 22033 | 28306 | 618 |
918329 | 918329 | 2021-01-11 | East Baton Rouge | Louisiana | 22033 | 27887 | 613 |
915084 | 915084 | 2021-01-10 | East Baton Rouge | Louisiana | 22033 | 27792 | 607 |
911839 | 911839 | 2021-01-09 | East Baton Rouge | Louisiana | 22033 | 27454 | 605 |
908594 | 908594 | 2021-01-08 | East Baton Rouge | Louisiana | 22033 | 27454 | 605 |
905348 | 905348 | 2021-01-07 | East Baton Rouge | Louisiana | 22033 | 27259 | 600 |
902103 | 902103 | 2021-01-06 | East Baton Rouge | Louisiana | 22033 | 26925 | 597 |
898858 | 898858 | 2021-01-05 | East Baton Rouge | Louisiana | 22033 | 26433 | 593 |
895613 | 895613 | 2021-01-04 | East Baton Rouge | Louisiana | 22033 | 26255 | 591 |
892366 | 892366 | 2021-01-03 | East Baton Rouge | Louisiana | 22033 | 26158 | 585 |
889120 | 889120 | 2021-01-02 | East Baton Rouge | Louisiana | 22033 | 25726 | 583 |
885874 | 885874 | 2021-01-01 | East Baton Rouge | Louisiana | 22033 | 25726 | 583 |
882629 | 882629 | 2020-12-31 | East Baton Rouge | Louisiana | 22033 | 25726 | 583 |
879384 | 879384 | 2020-12-30 | East Baton Rouge | Louisiana | 22033 | 25511 | 579 |
876139 | 876139 | 2020-12-29 | East Baton Rouge | Louisiana | 22033 | 25121 | 575 |
872894 | 872894 | 2020-12-28 | East Baton Rouge | Louisiana | 22033 | 24734 | 569 |
869649 | 869649 | 2020-12-27 | East Baton Rouge | Louisiana | 22033 | 24657 | 564 |
866404 | 866404 | 2020-12-26 | East Baton Rouge | Louisiana | 22033 | 24434 | 564 |
863159 | 863159 | 2020-12-25 | East Baton Rouge | Louisiana | 22033 | 24434 | 564 |
859914 | 859914 | 2020-12-24 | East Baton Rouge | Louisiana | 22033 | 24434 | 564 |
856669 | 856669 | 2020-12-23 | East Baton Rouge | Louisiana | 22033 | 24239 | 563 |
853424 | 853424 | 2020-12-22 | East Baton Rouge | Louisiana | 22033 | 24026 | 561 |
850179 | 850179 | 2020-12-21 | East Baton Rouge | Louisiana | 22033 | 23775 | 559 |
846934 | 846934 | 2020-12-20 | East Baton Rouge | Louisiana | 22033 | 23698 | 556 |
843688 | 843688 | 2020-12-19 | East Baton Rouge | Louisiana | 22033 | 23427 | 552 |
840443 | 840443 | 2020-12-18 | East Baton Rouge | Louisiana | 22033 | 23427 | 552 |
837198 | 837198 | 2020-12-17 | East Baton Rouge | Louisiana | 22033 | 23189 | 552 |
833952 | 833952 | 2020-12-16 | East Baton Rouge | Louisiana | 22033 | 22865 | 550 |
830705 | 830705 | 2020-12-15 | East Baton Rouge | Louisiana | 22033 | 22604 | 548 |
827459 | 827459 | 2020-12-14 | East Baton Rouge | Louisiana | 22033 | 22545 | 544 |
824212 | 824212 | 2020-12-13 | East Baton Rouge | Louisiana | 22033 | 22468 | 542 |
820966 | 820966 | 2020-12-12 | East Baton Rouge | Louisiana | 22033 | 22061 | 537 |
817720 | 817720 | 2020-12-11 | East Baton Rouge | Louisiana | 22033 | 22061 | 537 |
814474 | 814474 | 2020-12-10 | East Baton Rouge | Louisiana | 22033 | 21866 | 537 |
811229 | 811229 | 2020-12-09 | East Baton Rouge | Louisiana | 22033 | 21750 | 536 |
807984 | 807984 | 2020-12-08 | East Baton Rouge | Louisiana | 22033 | 21419 | 532 |
804739 | 804739 | 2020-12-07 | East Baton Rouge | Louisiana | 22033 | 21300 | 527 |
801494 | 801494 | 2020-12-06 | East Baton Rouge | Louisiana | 22033 | 21200 | 523 |
798249 | 798249 | 2020-12-05 | East Baton Rouge | Louisiana | 22033 | 20941 | 522 |
795004 | 795004 | 2020-12-04 | East Baton Rouge | Louisiana | 22033 | 20941 | 522 |
791759 | 791759 | 2020-12-03 | East Baton Rouge | Louisiana | 22033 | 20746 | 520 |
788514 | 788514 | 2020-12-02 | East Baton Rouge | Louisiana | 22033 | 20565 | 518 |
785270 | 785270 | 2020-12-01 | East Baton Rouge | Louisiana | 22033 | 20385 | 518 |
782025 | 782025 | 2020-11-30 | East Baton Rouge | Louisiana | 22033 | 19868 | 516 |
778779 | 778779 | 2020-11-29 | East Baton Rouge | Louisiana | 22033 | 19853 | 513 |
775534 | 775534 | 2020-11-28 | East Baton Rouge | Louisiana | 22033 | 19710 | 511 |
772289 | 772289 | 2020-11-27 | East Baton Rouge | Louisiana | 22033 | 19710 | 511 |
769044 | 769044 | 2020-11-26 | East Baton Rouge | Louisiana | 22033 | 19395 | 506 |
765798 | 765798 | 2020-11-25 | East Baton Rouge | Louisiana | 22033 | 19395 | 506 |
762553 | 762553 | 2020-11-24 | East Baton Rouge | Louisiana | 22033 | 19331 | 500 |
759308 | 759308 | 2020-11-23 | East Baton Rouge | Louisiana | 22033 | 19135 | 496 |
756061 | 756061 | 2020-11-22 | East Baton Rouge | Louisiana | 22033 | 19031 | 492 |
752815 | 752815 | 2020-11-21 | East Baton Rouge | Louisiana | 22033 | 18764 | 492 |
749569 | 749569 | 2020-11-20 | East Baton Rouge | Louisiana | 22033 | 18764 | 492 |
746323 | 746323 | 2020-11-19 | East Baton Rouge | Louisiana | 22033 | 18416 | 491 |
743076 | 743076 | 2020-11-18 | East Baton Rouge | Louisiana | 22033 | 18329 | 490 |
739829 | 739829 | 2020-11-17 | East Baton Rouge | Louisiana | 22033 | 18125 | 488 |
736585 | 736585 | 2020-11-16 | East Baton Rouge | Louisiana | 22033 | 17952 | 486 |
733339 | 733339 | 2020-11-15 | East Baton Rouge | Louisiana | 22033 | 17913 | 486 |
730094 | 730094 | 2020-11-14 | East Baton Rouge | Louisiana | 22033 | 17780 | 486 |
726851 | 726851 | 2020-11-13 | East Baton Rouge | Louisiana | 22033 | 17780 | 486 |
723608 | 723608 | 2020-11-12 | East Baton Rouge | Louisiana | 22033 | 16870 | 463 |
720365 | 720365 | 2020-11-11 | East Baton Rouge | Louisiana | 22033 | 16793 | 462 |
717122 | 717122 | 2020-11-10 | East Baton Rouge | Louisiana | 22033 | 16793 | 462 |
713878 | 713878 | 2020-11-09 | East Baton Rouge | Louisiana | 22033 | 16728 | 462 |
710634 | 710634 | 2020-11-08 | East Baton Rouge | Louisiana | 22033 | 16696 | 461 |
707390 | 707390 | 2020-11-07 | East Baton Rouge | Louisiana | 22033 | 16626 | 461 |
704147 | 704147 | 2020-11-06 | East Baton Rouge | Louisiana | 22033 | 16626 | 461 |
700905 | 700905 | 2020-11-05 | East Baton Rouge | Louisiana | 22033 | 16540 | 459 |
697661 | 697661 | 2020-11-04 | East Baton Rouge | Louisiana | 22033 | 16489 | 459 |
694418 | 694418 | 2020-11-03 | East Baton Rouge | Louisiana | 22033 | 16467 | 459 |
691176 | 691176 | 2020-11-02 | East Baton Rouge | Louisiana | 22033 | 16314 | 459 |
687931 | 687931 | 2020-11-01 | East Baton Rouge | Louisiana | 22033 | 16289 | 459 |
684687 | 684687 | 2020-10-31 | East Baton Rouge | Louisiana | 22033 | 16202 | 459 |
681444 | 681444 | 2020-10-30 | East Baton Rouge | Louisiana | 22033 | 16202 | 459 |
678200 | 678200 | 2020-10-29 | East Baton Rouge | Louisiana | 22033 | 16172 | 459 |
674958 | 674958 | 2020-10-28 | East Baton Rouge | Louisiana | 22033 | 16142 | 459 |
671715 | 671715 | 2020-10-27 | East Baton Rouge | Louisiana | 22033 | 16092 | 458 |
668473 | 668473 | 2020-10-26 | East Baton Rouge | Louisiana | 22033 | 16039 | 458 |
665229 | 665229 | 2020-10-25 | East Baton Rouge | Louisiana | 22033 | 16021 | 457 |
661984 | 661984 | 2020-10-24 | East Baton Rouge | Louisiana | 22033 | 15950 | 457 |
658740 | 658740 | 2020-10-23 | East Baton Rouge | Louisiana | 22033 | 15950 | 457 |
655495 | 655495 | 2020-10-22 | East Baton Rouge | Louisiana | 22033 | 15869 | 456 |
652250 | 652250 | 2020-10-21 | East Baton Rouge | Louisiana | 22033 | 15846 | 456 |
649005 | 649005 | 2020-10-20 | East Baton Rouge | Louisiana | 22033 | 15738 | 456 |
645761 | 645761 | 2020-10-19 | East Baton Rouge | Louisiana | 22033 | 15717 | 456 |
642514 | 642514 | 2020-10-18 | East Baton Rouge | Louisiana | 22033 | 15712 | 453 |
639267 | 639267 | 2020-10-17 | East Baton Rouge | Louisiana | 22033 | 15636 | 452 |
636021 | 636021 | 2020-10-16 | East Baton Rouge | Louisiana | 22033 | 15636 | 452 |
632775 | 632775 | 2020-10-15 | East Baton Rouge | Louisiana | 22033 | 15540 | 452 |
629531 | 629531 | 2020-10-14 | East Baton Rouge | Louisiana | 22033 | 15504 | 451 |
626287 | 626287 | 2020-10-13 | East Baton Rouge | Louisiana | 22033 | 15512 | 451 |
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);