ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 22071 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
947556 | 947556 | 2021-01-20 | Orleans | Louisiana | 22071 | 24844 | 702 |
944309 | 944309 | 2021-01-19 | Orleans | Louisiana | 22071 | 24703 | 702 |
941064 | 941064 | 2021-01-18 | Orleans | Louisiana | 22071 | 24571 | 702 |
937819 | 937819 | 2021-01-17 | Orleans | Louisiana | 22071 | 24476 | 701 |
934574 | 934574 | 2021-01-16 | Orleans | Louisiana | 22071 | 24170 | 696 |
931329 | 931329 | 2021-01-15 | Orleans | Louisiana | 22071 | 24170 | 696 |
928084 | 928084 | 2021-01-14 | Orleans | Louisiana | 22071 | 23965 | 696 |
924838 | 924838 | 2021-01-13 | Orleans | Louisiana | 22071 | 23725 | 695 |
921593 | 921593 | 2021-01-12 | Orleans | Louisiana | 22071 | 23531 | 691 |
918348 | 918348 | 2021-01-11 | Orleans | Louisiana | 22071 | 23252 | 689 |
915103 | 915103 | 2021-01-10 | Orleans | Louisiana | 22071 | 23117 | 689 |
911858 | 911858 | 2021-01-09 | Orleans | Louisiana | 22071 | 22737 | 687 |
908613 | 908613 | 2021-01-08 | Orleans | Louisiana | 22071 | 22737 | 687 |
905367 | 905367 | 2021-01-07 | Orleans | Louisiana | 22071 | 22484 | 685 |
902122 | 902122 | 2021-01-06 | Orleans | Louisiana | 22071 | 22171 | 685 |
898877 | 898877 | 2021-01-05 | Orleans | Louisiana | 22071 | 21802 | 682 |
895632 | 895632 | 2021-01-04 | Orleans | Louisiana | 22071 | 21521 | 679 |
892385 | 892385 | 2021-01-03 | Orleans | Louisiana | 22071 | 21364 | 679 |
889139 | 889139 | 2021-01-02 | Orleans | Louisiana | 22071 | 20780 | 679 |
885893 | 885893 | 2021-01-01 | Orleans | Louisiana | 22071 | 20780 | 679 |
882648 | 882648 | 2020-12-31 | Orleans | Louisiana | 22071 | 20780 | 679 |
879403 | 879403 | 2020-12-30 | Orleans | Louisiana | 22071 | 20524 | 679 |
876158 | 876158 | 2020-12-29 | Orleans | Louisiana | 22071 | 20237 | 677 |
872913 | 872913 | 2020-12-28 | Orleans | Louisiana | 22071 | 19935 | 675 |
869668 | 869668 | 2020-12-27 | Orleans | Louisiana | 22071 | 19847 | 673 |
866423 | 866423 | 2020-12-26 | Orleans | Louisiana | 22071 | 19520 | 673 |
863178 | 863178 | 2020-12-25 | Orleans | Louisiana | 22071 | 19520 | 673 |
859933 | 859933 | 2020-12-24 | Orleans | Louisiana | 22071 | 19520 | 673 |
856688 | 856688 | 2020-12-23 | Orleans | Louisiana | 22071 | 19348 | 673 |
853443 | 853443 | 2020-12-22 | Orleans | Louisiana | 22071 | 19217 | 672 |
850198 | 850198 | 2020-12-21 | Orleans | Louisiana | 22071 | 19030 | 670 |
846953 | 846953 | 2020-12-20 | Orleans | Louisiana | 22071 | 18944 | 664 |
843707 | 843707 | 2020-12-19 | Orleans | Louisiana | 22071 | 18682 | 664 |
840462 | 840462 | 2020-12-18 | Orleans | Louisiana | 22071 | 18682 | 664 |
837217 | 837217 | 2020-12-17 | Orleans | Louisiana | 22071 | 18498 | 662 |
833971 | 833971 | 2020-12-16 | Orleans | Louisiana | 22071 | 18307 | 660 |
830724 | 830724 | 2020-12-15 | Orleans | Louisiana | 22071 | 18179 | 656 |
827478 | 827478 | 2020-12-14 | Orleans | Louisiana | 22071 | 18036 | 656 |
824231 | 824231 | 2020-12-13 | Orleans | Louisiana | 22071 | 17949 | 655 |
820985 | 820985 | 2020-12-12 | Orleans | Louisiana | 22071 | 17667 | 653 |
817739 | 817739 | 2020-12-11 | Orleans | Louisiana | 22071 | 17667 | 653 |
814493 | 814493 | 2020-12-10 | Orleans | Louisiana | 22071 | 17520 | 653 |
811248 | 811248 | 2020-12-09 | Orleans | Louisiana | 22071 | 17374 | 652 |
808003 | 808003 | 2020-12-08 | Orleans | Louisiana | 22071 | 17194 | 651 |
804758 | 804758 | 2020-12-07 | Orleans | Louisiana | 22071 | 17082 | 650 |
801513 | 801513 | 2020-12-06 | Orleans | Louisiana | 22071 | 17013 | 649 |
798268 | 798268 | 2020-12-05 | Orleans | Louisiana | 22071 | 16733 | 649 |
795023 | 795023 | 2020-12-04 | Orleans | Louisiana | 22071 | 16733 | 649 |
791778 | 791778 | 2020-12-03 | Orleans | Louisiana | 22071 | 16580 | 649 |
788533 | 788533 | 2020-12-02 | Orleans | Louisiana | 22071 | 16421 | 649 |
785289 | 785289 | 2020-12-01 | Orleans | Louisiana | 22071 | 16077 | 648 |
782044 | 782044 | 2020-11-30 | Orleans | Louisiana | 22071 | 15838 | 647 |
778798 | 778798 | 2020-11-29 | Orleans | Louisiana | 22071 | 15834 | 647 |
775553 | 775553 | 2020-11-28 | Orleans | Louisiana | 22071 | 15716 | 646 |
772308 | 772308 | 2020-11-27 | Orleans | Louisiana | 22071 | 15716 | 646 |
769063 | 769063 | 2020-11-26 | Orleans | Louisiana | 22071 | 15388 | 646 |
765817 | 765817 | 2020-11-25 | Orleans | Louisiana | 22071 | 15388 | 646 |
762572 | 762572 | 2020-11-24 | Orleans | Louisiana | 22071 | 15323 | 646 |
759327 | 759327 | 2020-11-23 | Orleans | Louisiana | 22071 | 15174 | 645 |
756080 | 756080 | 2020-11-22 | Orleans | Louisiana | 22071 | 15121 | 644 |
752834 | 752834 | 2020-11-21 | Orleans | Louisiana | 22071 | 14978 | 644 |
749588 | 749588 | 2020-11-20 | Orleans | Louisiana | 22071 | 14978 | 644 |
746342 | 746342 | 2020-11-19 | Orleans | Louisiana | 22071 | 14874 | 644 |
743095 | 743095 | 2020-11-18 | Orleans | Louisiana | 22071 | 14786 | 644 |
739848 | 739848 | 2020-11-17 | Orleans | Louisiana | 22071 | 14711 | 644 |
736604 | 736604 | 2020-11-16 | Orleans | Louisiana | 22071 | 14593 | 644 |
733358 | 733358 | 2020-11-15 | Orleans | Louisiana | 22071 | 14553 | 644 |
730113 | 730113 | 2020-11-14 | Orleans | Louisiana | 22071 | 14401 | 644 |
726870 | 726870 | 2020-11-13 | Orleans | Louisiana | 22071 | 14401 | 644 |
723627 | 723627 | 2020-11-12 | Orleans | Louisiana | 22071 | 14124 | 605 |
720384 | 720384 | 2020-11-11 | Orleans | Louisiana | 22071 | 14034 | 602 |
717141 | 717141 | 2020-11-10 | Orleans | Louisiana | 22071 | 14034 | 602 |
713897 | 713897 | 2020-11-09 | Orleans | Louisiana | 22071 | 13844 | 602 |
710653 | 710653 | 2020-11-08 | Orleans | Louisiana | 22071 | 13821 | 601 |
707409 | 707409 | 2020-11-07 | Orleans | Louisiana | 22071 | 13719 | 600 |
704166 | 704166 | 2020-11-06 | Orleans | Louisiana | 22071 | 13719 | 600 |
700924 | 700924 | 2020-11-05 | Orleans | Louisiana | 22071 | 13673 | 599 |
697680 | 697680 | 2020-11-04 | Orleans | Louisiana | 22071 | 13638 | 598 |
694437 | 694437 | 2020-11-03 | Orleans | Louisiana | 22071 | 13623 | 597 |
691195 | 691195 | 2020-11-02 | Orleans | Louisiana | 22071 | 13589 | 595 |
687950 | 687950 | 2020-11-01 | Orleans | Louisiana | 22071 | 13569 | 595 |
684706 | 684706 | 2020-10-31 | Orleans | Louisiana | 22071 | 13536 | 595 |
681463 | 681463 | 2020-10-30 | Orleans | Louisiana | 22071 | 13536 | 595 |
678219 | 678219 | 2020-10-29 | Orleans | Louisiana | 22071 | 13514 | 594 |
674977 | 674977 | 2020-10-28 | Orleans | Louisiana | 22071 | 13499 | 593 |
671734 | 671734 | 2020-10-27 | Orleans | Louisiana | 22071 | 13471 | 592 |
668492 | 668492 | 2020-10-26 | Orleans | Louisiana | 22071 | 13434 | 592 |
665248 | 665248 | 2020-10-25 | Orleans | Louisiana | 22071 | 13427 | 592 |
662003 | 662003 | 2020-10-24 | Orleans | Louisiana | 22071 | 13368 | 592 |
658759 | 658759 | 2020-10-23 | Orleans | Louisiana | 22071 | 13368 | 592 |
655514 | 655514 | 2020-10-22 | Orleans | Louisiana | 22071 | 13324 | 592 |
652269 | 652269 | 2020-10-21 | Orleans | Louisiana | 22071 | 13289 | 592 |
649024 | 649024 | 2020-10-20 | Orleans | Louisiana | 22071 | 13271 | 589 |
645780 | 645780 | 2020-10-19 | Orleans | Louisiana | 22071 | 13218 | 589 |
642533 | 642533 | 2020-10-18 | Orleans | Louisiana | 22071 | 13207 | 589 |
639286 | 639286 | 2020-10-17 | Orleans | Louisiana | 22071 | 13150 | 589 |
636040 | 636040 | 2020-10-16 | Orleans | Louisiana | 22071 | 13150 | 589 |
632794 | 632794 | 2020-10-15 | Orleans | Louisiana | 22071 | 13106 | 589 |
629550 | 629550 | 2020-10-14 | Orleans | Louisiana | 22071 | 13057 | 588 |
626306 | 626306 | 2020-10-13 | Orleans | Louisiana | 22071 | 13022 | 588 |
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);