ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Tangipahoa", 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 |
---|---|---|---|---|---|---|---|
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 |
765834 | 765834 | 2020-11-25 | Tangipahoa | Louisiana | 22105 | 6435 | 142 |
762589 | 762589 | 2020-11-24 | Tangipahoa | Louisiana | 22105 | 6413 | 141 |
759344 | 759344 | 2020-11-23 | Tangipahoa | Louisiana | 22105 | 6274 | 139 |
756097 | 756097 | 2020-11-22 | Tangipahoa | Louisiana | 22105 | 6251 | 139 |
752851 | 752851 | 2020-11-21 | Tangipahoa | Louisiana | 22105 | 6190 | 139 |
749605 | 749605 | 2020-11-20 | Tangipahoa | Louisiana | 22105 | 6190 | 139 |
746359 | 746359 | 2020-11-19 | Tangipahoa | Louisiana | 22105 | 6079 | 139 |
743112 | 743112 | 2020-11-18 | Tangipahoa | Louisiana | 22105 | 6009 | 139 |
739865 | 739865 | 2020-11-17 | Tangipahoa | Louisiana | 22105 | 5881 | 137 |
736621 | 736621 | 2020-11-16 | Tangipahoa | Louisiana | 22105 | 5775 | 137 |
733375 | 733375 | 2020-11-15 | Tangipahoa | Louisiana | 22105 | 5760 | 137 |
730130 | 730130 | 2020-11-14 | Tangipahoa | Louisiana | 22105 | 5696 | 135 |
726887 | 726887 | 2020-11-13 | Tangipahoa | Louisiana | 22105 | 5696 | 135 |
723644 | 723644 | 2020-11-12 | Tangipahoa | Louisiana | 22105 | 5197 | 130 |
720401 | 720401 | 2020-11-11 | Tangipahoa | Louisiana | 22105 | 5151 | 129 |
717158 | 717158 | 2020-11-10 | Tangipahoa | Louisiana | 22105 | 5151 | 129 |
713914 | 713914 | 2020-11-09 | Tangipahoa | Louisiana | 22105 | 5141 | 129 |
710670 | 710670 | 2020-11-08 | Tangipahoa | Louisiana | 22105 | 5137 | 129 |
707426 | 707426 | 2020-11-07 | Tangipahoa | Louisiana | 22105 | 5116 | 127 |
704183 | 704183 | 2020-11-06 | Tangipahoa | Louisiana | 22105 | 5116 | 127 |
700941 | 700941 | 2020-11-05 | Tangipahoa | Louisiana | 22105 | 5108 | 127 |
697697 | 697697 | 2020-11-04 | Tangipahoa | Louisiana | 22105 | 5096 | 127 |
694454 | 694454 | 2020-11-03 | Tangipahoa | Louisiana | 22105 | 5091 | 127 |
691212 | 691212 | 2020-11-02 | Tangipahoa | Louisiana | 22105 | 5080 | 127 |
687967 | 687967 | 2020-11-01 | Tangipahoa | Louisiana | 22105 | 5079 | 126 |
684723 | 684723 | 2020-10-31 | Tangipahoa | Louisiana | 22105 | 5047 | 126 |
681480 | 681480 | 2020-10-30 | Tangipahoa | Louisiana | 22105 | 5047 | 126 |
678236 | 678236 | 2020-10-29 | Tangipahoa | Louisiana | 22105 | 5037 | 126 |
674994 | 674994 | 2020-10-28 | Tangipahoa | Louisiana | 22105 | 5026 | 126 |
671751 | 671751 | 2020-10-27 | Tangipahoa | Louisiana | 22105 | 5004 | 126 |
668509 | 668509 | 2020-10-26 | Tangipahoa | Louisiana | 22105 | 4983 | 126 |
665265 | 665265 | 2020-10-25 | Tangipahoa | Louisiana | 22105 | 4979 | 123 |
662020 | 662020 | 2020-10-24 | Tangipahoa | Louisiana | 22105 | 4959 | 123 |
658776 | 658776 | 2020-10-23 | Tangipahoa | Louisiana | 22105 | 4959 | 123 |
655531 | 655531 | 2020-10-22 | Tangipahoa | Louisiana | 22105 | 4936 | 122 |
652286 | 652286 | 2020-10-21 | Tangipahoa | Louisiana | 22105 | 4930 | 122 |
649041 | 649041 | 2020-10-20 | Tangipahoa | Louisiana | 22105 | 4906 | 122 |
645797 | 645797 | 2020-10-19 | Tangipahoa | Louisiana | 22105 | 4895 | 122 |
642550 | 642550 | 2020-10-18 | Tangipahoa | Louisiana | 22105 | 4889 | 122 |
639303 | 639303 | 2020-10-17 | Tangipahoa | Louisiana | 22105 | 4859 | 122 |
636057 | 636057 | 2020-10-16 | Tangipahoa | Louisiana | 22105 | 4859 | 122 |
632811 | 632811 | 2020-10-15 | Tangipahoa | Louisiana | 22105 | 4813 | 122 |
629567 | 629567 | 2020-10-14 | Tangipahoa | Louisiana | 22105 | 4822 | 122 |
626323 | 626323 | 2020-10-13 | Tangipahoa | Louisiana | 22105 | 4816 | 122 |
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);