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 |
---|---|---|---|---|---|---|---|
1194265 | 1194265 | 2021-04-06 | Orleans | Louisiana | 22071 | 29388 | 783 |
1191015 | 1191015 | 2021-04-05 | Orleans | Louisiana | 22071 | 29377 | 783 |
1187768 | 1187768 | 2021-04-04 | Orleans | Louisiana | 22071 | 29301 | 783 |
1184521 | 1184521 | 2021-04-03 | Orleans | Louisiana | 22071 | 29301 | 783 |
1181274 | 1181274 | 2021-04-02 | Orleans | Louisiana | 22071 | 29301 | 783 |
1178027 | 1178027 | 2021-04-01 | Orleans | Louisiana | 22071 | 29301 | 783 |
1174780 | 1174780 | 2021-03-31 | Orleans | Louisiana | 22071 | 29264 | 782 |
1171533 | 1171533 | 2021-03-30 | Orleans | Louisiana | 22071 | 29234 | 782 |
1168285 | 1168285 | 2021-03-29 | Orleans | Louisiana | 22071 | 29193 | 781 |
1165037 | 1165037 | 2021-03-28 | Orleans | Louisiana | 22071 | 29147 | 779 |
1161789 | 1161789 | 2021-03-27 | Orleans | Louisiana | 22071 | 29147 | 779 |
1158541 | 1158541 | 2021-03-26 | Orleans | Louisiana | 22071 | 29147 | 779 |
1155294 | 1155294 | 2021-03-25 | Orleans | Louisiana | 22071 | 29113 | 779 |
1152047 | 1152047 | 2021-03-24 | Orleans | Louisiana | 22071 | 29108 | 779 |
1148800 | 1148800 | 2021-03-23 | Orleans | Louisiana | 22071 | 29091 | 779 |
1145553 | 1145553 | 2021-03-22 | Orleans | Louisiana | 22071 | 29061 | 779 |
1142306 | 1142306 | 2021-03-21 | Orleans | Louisiana | 22071 | 29025 | 778 |
1139060 | 1139060 | 2021-03-20 | Orleans | Louisiana | 22071 | 29025 | 778 |
1135814 | 1135814 | 2021-03-19 | Orleans | Louisiana | 22071 | 29025 | 778 |
1132567 | 1132567 | 2021-03-18 | Orleans | Louisiana | 22071 | 29021 | 778 |
1129319 | 1129319 | 2021-03-17 | Orleans | Louisiana | 22071 | 28989 | 778 |
1126073 | 1126073 | 2021-03-16 | Orleans | Louisiana | 22071 | 28970 | 775 |
1122827 | 1122827 | 2021-03-15 | Orleans | Louisiana | 22071 | 28924 | 775 |
1119580 | 1119580 | 2021-03-14 | Orleans | Louisiana | 22071 | 28901 | 772 |
1116333 | 1116333 | 2021-03-13 | Orleans | Louisiana | 22071 | 28844 | 770 |
1113087 | 1113087 | 2021-03-12 | Orleans | Louisiana | 22071 | 28844 | 770 |
1109841 | 1109841 | 2021-03-11 | Orleans | Louisiana | 22071 | 28821 | 770 |
1106595 | 1106595 | 2021-03-10 | Orleans | Louisiana | 22071 | 28802 | 770 |
1103349 | 1103349 | 2021-03-09 | Orleans | Louisiana | 22071 | 28782 | 769 |
1100103 | 1100103 | 2021-03-08 | Orleans | Louisiana | 22071 | 28744 | 768 |
1096855 | 1096855 | 2021-03-07 | Orleans | Louisiana | 22071 | 28710 | 768 |
1093609 | 1093609 | 2021-03-06 | Orleans | Louisiana | 22071 | 28655 | 766 |
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 |
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);