ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "Orleans" and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1090363 | 1090363 | 2021-03-05 | Orleans | Louisiana | 22071 | 28655 | 766 |
1087118 | 1087118 | 2021-03-04 | Orleans | Louisiana | 22071 | 28624 | 766 |
1083872 | 1083872 | 2021-03-03 | Orleans | Louisiana | 22071 | 28581 | 764 |
1080626 | 1080626 | 2021-03-02 | Orleans | Louisiana | 22071 | 28565 | 762 |
1077381 | 1077381 | 2021-03-01 | Orleans | Louisiana | 22071 | 28501 | 763 |
1074135 | 1074135 | 2021-02-28 | Orleans | Louisiana | 22071 | 28462 | 762 |
1070889 | 1070889 | 2021-02-27 | Orleans | Louisiana | 22071 | 28386 | 760 |
1067644 | 1067644 | 2021-02-26 | Orleans | Louisiana | 22071 | 28386 | 760 |
1064399 | 1064399 | 2021-02-25 | Orleans | Louisiana | 22071 | 28341 | 760 |
1061154 | 1061154 | 2021-02-24 | Orleans | Louisiana | 22071 | 28259 | 757 |
1057908 | 1057908 | 2021-02-23 | Orleans | Louisiana | 22071 | 28164 | 757 |
1054662 | 1054662 | 2021-02-22 | Orleans | Louisiana | 22071 | 28075 | 757 |
1051415 | 1051415 | 2021-02-21 | Orleans | Louisiana | 22071 | 28044 | 757 |
1048168 | 1048168 | 2021-02-20 | Orleans | Louisiana | 22071 | 27942 | 755 |
1044923 | 1044923 | 2021-02-19 | Orleans | Louisiana | 22071 | 27942 | 755 |
1041678 | 1041678 | 2021-02-18 | Orleans | Louisiana | 22071 | 27875 | 750 |
1038433 | 1038433 | 2021-02-17 | Orleans | Louisiana | 22071 | 27803 | 750 |
1035188 | 1035188 | 2021-02-16 | Orleans | Louisiana | 22071 | 27744 | 748 |
1031942 | 1031942 | 2021-02-15 | Orleans | Louisiana | 22071 | 27744 | 748 |
1028695 | 1028695 | 2021-02-14 | Orleans | Louisiana | 22071 | 27706 | 746 |
1025450 | 1025450 | 2021-02-13 | Orleans | Louisiana | 22071 | 27625 | 745 |
1022205 | 1022205 | 2021-02-12 | Orleans | Louisiana | 22071 | 27625 | 745 |
1018960 | 1018960 | 2021-02-11 | Orleans | Louisiana | 22071 | 27544 | 745 |
1015715 | 1015715 | 2021-02-10 | Orleans | Louisiana | 22071 | 27408 | 745 |
1012470 | 1012470 | 2021-02-09 | Orleans | Louisiana | 22071 | 27375 | 744 |
1009224 | 1009224 | 2021-02-08 | Orleans | Louisiana | 22071 | 27245 | 743 |
1005978 | 1005978 | 2021-02-07 | Orleans | Louisiana | 22071 | 27158 | 743 |
1002732 | 1002732 | 2021-02-06 | Orleans | Louisiana | 22071 | 27060 | 739 |
999486 | 999486 | 2021-02-05 | Orleans | Louisiana | 22071 | 27060 | 739 |
996240 | 996240 | 2021-02-04 | Orleans | Louisiana | 22071 | 27001 | 735 |
992994 | 992994 | 2021-02-03 | Orleans | Louisiana | 22071 | 26883 | 732 |
989748 | 989748 | 2021-02-02 | Orleans | Louisiana | 22071 | 26760 | 726 |
986501 | 986501 | 2021-02-01 | Orleans | Louisiana | 22071 | 26540 | 725 |
983254 | 983254 | 2021-01-31 | Orleans | Louisiana | 22071 | 26458 | 722 |
980008 | 980008 | 2021-01-30 | Orleans | Louisiana | 22071 | 26177 | 720 |
976762 | 976762 | 2021-01-29 | Orleans | Louisiana | 22071 | 26177 | 720 |
973517 | 973517 | 2021-01-28 | Orleans | Louisiana | 22071 | 26039 | 720 |
970272 | 970272 | 2021-01-27 | Orleans | Louisiana | 22071 | 25893 | 718 |
967028 | 967028 | 2021-01-26 | Orleans | Louisiana | 22071 | 25754 | 716 |
963783 | 963783 | 2021-01-25 | Orleans | Louisiana | 22071 | 25559 | 717 |
960538 | 960538 | 2021-01-24 | Orleans | Louisiana | 22071 | 25358 | 717 |
957292 | 957292 | 2021-01-23 | Orleans | Louisiana | 22071 | 25178 | 709 |
954047 | 954047 | 2021-01-22 | Orleans | Louisiana | 22071 | 25178 | 709 |
950802 | 950802 | 2021-01-21 | Orleans | Louisiana | 22071 | 25047 | 708 |
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 |
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);