ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 22105 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1090380 | 1090380 | 2021-03-05 | Tangipahoa | Louisiana | 22105 | 12072 | 273 |
1087135 | 1087135 | 2021-03-04 | Tangipahoa | Louisiana | 22105 | 12060 | 272 |
1083889 | 1083889 | 2021-03-03 | Tangipahoa | Louisiana | 22105 | 12036 | 272 |
1080643 | 1080643 | 2021-03-02 | Tangipahoa | Louisiana | 22105 | 12031 | 270 |
1077398 | 1077398 | 2021-03-01 | Tangipahoa | Louisiana | 22105 | 12016 | 269 |
1074152 | 1074152 | 2021-02-28 | Tangipahoa | Louisiana | 22105 | 12012 | 268 |
1070906 | 1070906 | 2021-02-27 | Tangipahoa | Louisiana | 22105 | 11987 | 266 |
1067661 | 1067661 | 2021-02-26 | Tangipahoa | Louisiana | 22105 | 11987 | 266 |
1064416 | 1064416 | 2021-02-25 | Tangipahoa | Louisiana | 22105 | 11974 | 265 |
1061171 | 1061171 | 2021-02-24 | Tangipahoa | Louisiana | 22105 | 11936 | 264 |
1057925 | 1057925 | 2021-02-23 | Tangipahoa | Louisiana | 22105 | 11915 | 262 |
1054679 | 1054679 | 2021-02-22 | Tangipahoa | Louisiana | 22105 | 11863 | 262 |
1051432 | 1051432 | 2021-02-21 | Tangipahoa | Louisiana | 22105 | 11857 | 261 |
1048185 | 1048185 | 2021-02-20 | Tangipahoa | Louisiana | 22105 | 11820 | 261 |
1044940 | 1044940 | 2021-02-19 | Tangipahoa | Louisiana | 22105 | 11820 | 261 |
1041695 | 1041695 | 2021-02-18 | Tangipahoa | Louisiana | 22105 | 11811 | 257 |
1038450 | 1038450 | 2021-02-17 | Tangipahoa | Louisiana | 22105 | 11756 | 256 |
1035205 | 1035205 | 2021-02-16 | Tangipahoa | Louisiana | 22105 | 11758 | 255 |
1031959 | 1031959 | 2021-02-15 | Tangipahoa | Louisiana | 22105 | 11758 | 255 |
1028712 | 1028712 | 2021-02-14 | Tangipahoa | Louisiana | 22105 | 11748 | 254 |
1025467 | 1025467 | 2021-02-13 | Tangipahoa | Louisiana | 22105 | 11720 | 254 |
1022222 | 1022222 | 2021-02-12 | Tangipahoa | Louisiana | 22105 | 11720 | 254 |
1018977 | 1018977 | 2021-02-11 | Tangipahoa | Louisiana | 22105 | 11694 | 254 |
1015732 | 1015732 | 2021-02-10 | Tangipahoa | Louisiana | 22105 | 11588 | 253 |
1012487 | 1012487 | 2021-02-09 | Tangipahoa | Louisiana | 22105 | 11579 | 249 |
1009241 | 1009241 | 2021-02-08 | Tangipahoa | Louisiana | 22105 | 11541 | 250 |
1005995 | 1005995 | 2021-02-07 | Tangipahoa | Louisiana | 22105 | 11500 | 247 |
1002749 | 1002749 | 2021-02-06 | Tangipahoa | Louisiana | 22105 | 11461 | 244 |
999503 | 999503 | 2021-02-05 | Tangipahoa | Louisiana | 22105 | 11461 | 244 |
996257 | 996257 | 2021-02-04 | Tangipahoa | Louisiana | 22105 | 11447 | 241 |
993011 | 993011 | 2021-02-03 | Tangipahoa | Louisiana | 22105 | 11395 | 239 |
989765 | 989765 | 2021-02-02 | Tangipahoa | Louisiana | 22105 | 11279 | 236 |
986518 | 986518 | 2021-02-01 | Tangipahoa | Louisiana | 22105 | 11099 | 236 |
983271 | 983271 | 2021-01-31 | Tangipahoa | Louisiana | 22105 | 11086 | 236 |
980025 | 980025 | 2021-01-30 | Tangipahoa | Louisiana | 22105 | 11002 | 236 |
976779 | 976779 | 2021-01-29 | Tangipahoa | Louisiana | 22105 | 11002 | 236 |
973534 | 973534 | 2021-01-28 | Tangipahoa | Louisiana | 22105 | 10937 | 234 |
970289 | 970289 | 2021-01-27 | Tangipahoa | Louisiana | 22105 | 10871 | 232 |
967045 | 967045 | 2021-01-26 | Tangipahoa | Louisiana | 22105 | 10727 | 231 |
963800 | 963800 | 2021-01-25 | Tangipahoa | Louisiana | 22105 | 10710 | 229 |
960555 | 960555 | 2021-01-24 | Tangipahoa | Louisiana | 22105 | 10665 | 225 |
957309 | 957309 | 2021-01-23 | Tangipahoa | Louisiana | 22105 | 10556 | 220 |
954064 | 954064 | 2021-01-22 | Tangipahoa | Louisiana | 22105 | 10556 | 220 |
950819 | 950819 | 2021-01-21 | Tangipahoa | Louisiana | 22105 | 10524 | 218 |
947573 | 947573 | 2021-01-20 | Tangipahoa | Louisiana | 22105 | 10392 | 211 |
944326 | 944326 | 2021-01-19 | Tangipahoa | Louisiana | 22105 | 10345 | 211 |
941081 | 941081 | 2021-01-18 | Tangipahoa | Louisiana | 22105 | 10296 | 208 |
937836 | 937836 | 2021-01-17 | Tangipahoa | Louisiana | 22105 | 10279 | 208 |
934591 | 934591 | 2021-01-16 | Tangipahoa | Louisiana | 22105 | 10192 | 206 |
931346 | 931346 | 2021-01-15 | Tangipahoa | Louisiana | 22105 | 10192 | 206 |
928101 | 928101 | 2021-01-14 | Tangipahoa | Louisiana | 22105 | 10020 | 206 |
924855 | 924855 | 2021-01-13 | Tangipahoa | Louisiana | 22105 | 9866 | 206 |
921610 | 921610 | 2021-01-12 | Tangipahoa | Louisiana | 22105 | 9800 | 198 |
918365 | 918365 | 2021-01-11 | Tangipahoa | Louisiana | 22105 | 9697 | 197 |
915120 | 915120 | 2021-01-10 | Tangipahoa | Louisiana | 22105 | 9670 | 196 |
911875 | 911875 | 2021-01-09 | Tangipahoa | Louisiana | 22105 | 9574 | 196 |
908630 | 908630 | 2021-01-08 | Tangipahoa | Louisiana | 22105 | 9574 | 196 |
905384 | 905384 | 2021-01-07 | Tangipahoa | Louisiana | 22105 | 9516 | 188 |
902139 | 902139 | 2021-01-06 | Tangipahoa | Louisiana | 22105 | 9428 | 188 |
898894 | 898894 | 2021-01-05 | Tangipahoa | Louisiana | 22105 | 9219 | 187 |
895649 | 895649 | 2021-01-04 | Tangipahoa | Louisiana | 22105 | 9104 | 184 |
892402 | 892402 | 2021-01-03 | Tangipahoa | Louisiana | 22105 | 9095 | 183 |
889156 | 889156 | 2021-01-02 | Tangipahoa | Louisiana | 22105 | 9038 | 184 |
885910 | 885910 | 2021-01-01 | Tangipahoa | Louisiana | 22105 | 9038 | 184 |
882665 | 882665 | 2020-12-31 | Tangipahoa | Louisiana | 22105 | 9038 | 184 |
879420 | 879420 | 2020-12-30 | Tangipahoa | Louisiana | 22105 | 8962 | 181 |
876175 | 876175 | 2020-12-29 | Tangipahoa | Louisiana | 22105 | 8829 | 172 |
872930 | 872930 | 2020-12-28 | Tangipahoa | Louisiana | 22105 | 8662 | 170 |
869685 | 869685 | 2020-12-27 | Tangipahoa | Louisiana | 22105 | 8660 | 170 |
866440 | 866440 | 2020-12-26 | Tangipahoa | Louisiana | 22105 | 8598 | 170 |
863195 | 863195 | 2020-12-25 | Tangipahoa | Louisiana | 22105 | 8598 | 170 |
859950 | 859950 | 2020-12-24 | Tangipahoa | Louisiana | 22105 | 8598 | 170 |
856705 | 856705 | 2020-12-23 | Tangipahoa | Louisiana | 22105 | 8552 | 169 |
853460 | 853460 | 2020-12-22 | Tangipahoa | Louisiana | 22105 | 8469 | 165 |
850215 | 850215 | 2020-12-21 | Tangipahoa | Louisiana | 22105 | 8342 | 162 |
846970 | 846970 | 2020-12-20 | Tangipahoa | Louisiana | 22105 | 8320 | 156 |
843724 | 843724 | 2020-12-19 | Tangipahoa | Louisiana | 22105 | 8246 | 155 |
840479 | 840479 | 2020-12-18 | Tangipahoa | Louisiana | 22105 | 8246 | 155 |
837234 | 837234 | 2020-12-17 | Tangipahoa | Louisiana | 22105 | 8163 | 153 |
833988 | 833988 | 2020-12-16 | Tangipahoa | Louisiana | 22105 | 8066 | 153 |
830741 | 830741 | 2020-12-15 | Tangipahoa | Louisiana | 22105 | 7936 | 152 |
827495 | 827495 | 2020-12-14 | Tangipahoa | Louisiana | 22105 | 7861 | 153 |
824248 | 824248 | 2020-12-13 | Tangipahoa | Louisiana | 22105 | 7836 | 153 |
821002 | 821002 | 2020-12-12 | Tangipahoa | Louisiana | 22105 | 7717 | 153 |
817756 | 817756 | 2020-12-11 | Tangipahoa | Louisiana | 22105 | 7717 | 153 |
814510 | 814510 | 2020-12-10 | Tangipahoa | Louisiana | 22105 | 7616 | 152 |
811265 | 811265 | 2020-12-09 | Tangipahoa | Louisiana | 22105 | 7459 | 147 |
808020 | 808020 | 2020-12-08 | Tangipahoa | Louisiana | 22105 | 7248 | 147 |
804775 | 804775 | 2020-12-07 | Tangipahoa | Louisiana | 22105 | 7186 | 147 |
801530 | 801530 | 2020-12-06 | Tangipahoa | Louisiana | 22105 | 7162 | 147 |
798285 | 798285 | 2020-12-05 | Tangipahoa | Louisiana | 22105 | 7052 | 145 |
795040 | 795040 | 2020-12-04 | Tangipahoa | Louisiana | 22105 | 7052 | 145 |
791795 | 791795 | 2020-12-03 | Tangipahoa | Louisiana | 22105 | 6982 | 145 |
788550 | 788550 | 2020-12-02 | Tangipahoa | Louisiana | 22105 | 6911 | 144 |
785306 | 785306 | 2020-12-01 | Tangipahoa | Louisiana | 22105 | 6834 | 142 |
782061 | 782061 | 2020-11-30 | Tangipahoa | Louisiana | 22105 | 6638 | 142 |
778815 | 778815 | 2020-11-29 | Tangipahoa | Louisiana | 22105 | 6635 | 142 |
775570 | 775570 | 2020-11-28 | Tangipahoa | Louisiana | 22105 | 6571 | 143 |
772325 | 772325 | 2020-11-27 | Tangipahoa | Louisiana | 22105 | 6571 | 143 |
769080 | 769080 | 2020-11-26 | Tangipahoa | Louisiana | 22105 | 6435 | 142 |
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);