ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Lafourche" and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
947550 | 947550 | 2021-01-20 | Lafourche | Louisiana | 22057 | 7570 | 172 |
944303 | 944303 | 2021-01-19 | Lafourche | Louisiana | 22057 | 7480 | 170 |
941058 | 941058 | 2021-01-18 | Lafourche | Louisiana | 22057 | 7416 | 170 |
937813 | 937813 | 2021-01-17 | Lafourche | Louisiana | 22057 | 7378 | 169 |
934568 | 934568 | 2021-01-16 | Lafourche | Louisiana | 22057 | 7309 | 167 |
931323 | 931323 | 2021-01-15 | Lafourche | Louisiana | 22057 | 7309 | 167 |
928078 | 928078 | 2021-01-14 | Lafourche | Louisiana | 22057 | 7236 | 167 |
924832 | 924832 | 2021-01-13 | Lafourche | Louisiana | 22057 | 7162 | 166 |
921587 | 921587 | 2021-01-12 | Lafourche | Louisiana | 22057 | 7087 | 166 |
918342 | 918342 | 2021-01-11 | Lafourche | Louisiana | 22057 | 6952 | 166 |
915097 | 915097 | 2021-01-10 | Lafourche | Louisiana | 22057 | 6871 | 164 |
911852 | 911852 | 2021-01-09 | Lafourche | Louisiana | 22057 | 6792 | 164 |
908607 | 908607 | 2021-01-08 | Lafourche | Louisiana | 22057 | 6792 | 164 |
905361 | 905361 | 2021-01-07 | Lafourche | Louisiana | 22057 | 6658 | 163 |
902116 | 902116 | 2021-01-06 | Lafourche | Louisiana | 22057 | 6617 | 163 |
898871 | 898871 | 2021-01-05 | Lafourche | Louisiana | 22057 | 6485 | 163 |
895626 | 895626 | 2021-01-04 | Lafourche | Louisiana | 22057 | 6388 | 164 |
892379 | 892379 | 2021-01-03 | Lafourche | Louisiana | 22057 | 6369 | 163 |
889133 | 889133 | 2021-01-02 | Lafourche | Louisiana | 22057 | 6250 | 162 |
885887 | 885887 | 2021-01-01 | Lafourche | Louisiana | 22057 | 6250 | 162 |
882642 | 882642 | 2020-12-31 | Lafourche | Louisiana | 22057 | 6250 | 162 |
879397 | 879397 | 2020-12-30 | Lafourche | Louisiana | 22057 | 6207 | 161 |
876152 | 876152 | 2020-12-29 | Lafourche | Louisiana | 22057 | 6075 | 161 |
872907 | 872907 | 2020-12-28 | Lafourche | Louisiana | 22057 | 5975 | 161 |
869662 | 869662 | 2020-12-27 | Lafourche | Louisiana | 22057 | 5928 | 161 |
866417 | 866417 | 2020-12-26 | Lafourche | Louisiana | 22057 | 5895 | 161 |
863172 | 863172 | 2020-12-25 | Lafourche | Louisiana | 22057 | 5895 | 161 |
859927 | 859927 | 2020-12-24 | Lafourche | Louisiana | 22057 | 5895 | 161 |
856682 | 856682 | 2020-12-23 | Lafourche | Louisiana | 22057 | 5881 | 159 |
853437 | 853437 | 2020-12-22 | Lafourche | Louisiana | 22057 | 5840 | 159 |
850192 | 850192 | 2020-12-21 | Lafourche | Louisiana | 22057 | 5742 | 158 |
846947 | 846947 | 2020-12-20 | Lafourche | Louisiana | 22057 | 5731 | 158 |
843701 | 843701 | 2020-12-19 | Lafourche | Louisiana | 22057 | 5638 | 158 |
840456 | 840456 | 2020-12-18 | Lafourche | Louisiana | 22057 | 5638 | 158 |
837211 | 837211 | 2020-12-17 | Lafourche | Louisiana | 22057 | 5587 | 158 |
833965 | 833965 | 2020-12-16 | Lafourche | Louisiana | 22057 | 5539 | 156 |
830718 | 830718 | 2020-12-15 | Lafourche | Louisiana | 22057 | 5510 | 153 |
827472 | 827472 | 2020-12-14 | Lafourche | Louisiana | 22057 | 5439 | 152 |
824225 | 824225 | 2020-12-13 | Lafourche | Louisiana | 22057 | 5388 | 152 |
820979 | 820979 | 2020-12-12 | Lafourche | Louisiana | 22057 | 5323 | 150 |
817733 | 817733 | 2020-12-11 | Lafourche | Louisiana | 22057 | 5323 | 150 |
814487 | 814487 | 2020-12-10 | Lafourche | Louisiana | 22057 | 5277 | 148 |
811242 | 811242 | 2020-12-09 | Lafourche | Louisiana | 22057 | 5244 | 144 |
807997 | 807997 | 2020-12-08 | Lafourche | Louisiana | 22057 | 5153 | 144 |
804752 | 804752 | 2020-12-07 | Lafourche | Louisiana | 22057 | 5104 | 143 |
801507 | 801507 | 2020-12-06 | Lafourche | Louisiana | 22057 | 5086 | 142 |
798262 | 798262 | 2020-12-05 | Lafourche | Louisiana | 22057 | 5001 | 142 |
795017 | 795017 | 2020-12-04 | Lafourche | Louisiana | 22057 | 5001 | 142 |
791772 | 791772 | 2020-12-03 | Lafourche | Louisiana | 22057 | 4934 | 141 |
788527 | 788527 | 2020-12-02 | Lafourche | Louisiana | 22057 | 4882 | 141 |
785283 | 785283 | 2020-12-01 | Lafourche | Louisiana | 22057 | 4852 | 140 |
782038 | 782038 | 2020-11-30 | Lafourche | Louisiana | 22057 | 4754 | 140 |
778792 | 778792 | 2020-11-29 | Lafourche | Louisiana | 22057 | 4730 | 139 |
775547 | 775547 | 2020-11-28 | Lafourche | Louisiana | 22057 | 4672 | 139 |
772302 | 772302 | 2020-11-27 | Lafourche | Louisiana | 22057 | 4672 | 139 |
769057 | 769057 | 2020-11-26 | Lafourche | Louisiana | 22057 | 4594 | 138 |
765811 | 765811 | 2020-11-25 | Lafourche | Louisiana | 22057 | 4594 | 138 |
762566 | 762566 | 2020-11-24 | Lafourche | Louisiana | 22057 | 4573 | 136 |
759321 | 759321 | 2020-11-23 | Lafourche | Louisiana | 22057 | 4521 | 136 |
756074 | 756074 | 2020-11-22 | Lafourche | Louisiana | 22057 | 4507 | 136 |
752828 | 752828 | 2020-11-21 | Lafourche | Louisiana | 22057 | 4455 | 134 |
749582 | 749582 | 2020-11-20 | Lafourche | Louisiana | 22057 | 4455 | 134 |
746336 | 746336 | 2020-11-19 | Lafourche | Louisiana | 22057 | 4399 | 134 |
743089 | 743089 | 2020-11-18 | Lafourche | Louisiana | 22057 | 4372 | 134 |
739842 | 739842 | 2020-11-17 | Lafourche | Louisiana | 22057 | 4342 | 135 |
736598 | 736598 | 2020-11-16 | Lafourche | Louisiana | 22057 | 4294 | 135 |
733352 | 733352 | 2020-11-15 | Lafourche | Louisiana | 22057 | 4276 | 135 |
730107 | 730107 | 2020-11-14 | Lafourche | Louisiana | 22057 | 4237 | 135 |
726864 | 726864 | 2020-11-13 | Lafourche | Louisiana | 22057 | 4237 | 135 |
723621 | 723621 | 2020-11-12 | Lafourche | Louisiana | 22057 | 4015 | 131 |
720378 | 720378 | 2020-11-11 | Lafourche | Louisiana | 22057 | 3998 | 131 |
717135 | 717135 | 2020-11-10 | Lafourche | Louisiana | 22057 | 3998 | 131 |
713891 | 713891 | 2020-11-09 | Lafourche | Louisiana | 22057 | 3975 | 131 |
710647 | 710647 | 2020-11-08 | Lafourche | Louisiana | 22057 | 3970 | 131 |
707403 | 707403 | 2020-11-07 | Lafourche | Louisiana | 22057 | 3954 | 131 |
704160 | 704160 | 2020-11-06 | Lafourche | Louisiana | 22057 | 3954 | 131 |
700918 | 700918 | 2020-11-05 | Lafourche | Louisiana | 22057 | 3953 | 131 |
697674 | 697674 | 2020-11-04 | Lafourche | Louisiana | 22057 | 3939 | 131 |
694431 | 694431 | 2020-11-03 | Lafourche | Louisiana | 22057 | 3936 | 131 |
691189 | 691189 | 2020-11-02 | Lafourche | Louisiana | 22057 | 3930 | 131 |
687944 | 687944 | 2020-11-01 | Lafourche | Louisiana | 22057 | 3925 | 131 |
684700 | 684700 | 2020-10-31 | Lafourche | Louisiana | 22057 | 3907 | 131 |
681457 | 681457 | 2020-10-30 | Lafourche | Louisiana | 22057 | 3907 | 131 |
678213 | 678213 | 2020-10-29 | Lafourche | Louisiana | 22057 | 3909 | 130 |
674971 | 674971 | 2020-10-28 | Lafourche | Louisiana | 22057 | 3905 | 128 |
671728 | 671728 | 2020-10-27 | Lafourche | Louisiana | 22057 | 3899 | 128 |
668486 | 668486 | 2020-10-26 | Lafourche | Louisiana | 22057 | 3886 | 128 |
665242 | 665242 | 2020-10-25 | Lafourche | Louisiana | 22057 | 3880 | 128 |
661997 | 661997 | 2020-10-24 | Lafourche | Louisiana | 22057 | 3871 | 128 |
658753 | 658753 | 2020-10-23 | Lafourche | Louisiana | 22057 | 3871 | 128 |
655508 | 655508 | 2020-10-22 | Lafourche | Louisiana | 22057 | 3862 | 126 |
652263 | 652263 | 2020-10-21 | Lafourche | Louisiana | 22057 | 3854 | 126 |
649018 | 649018 | 2020-10-20 | Lafourche | Louisiana | 22057 | 3846 | 126 |
645774 | 645774 | 2020-10-19 | Lafourche | Louisiana | 22057 | 3842 | 126 |
642527 | 642527 | 2020-10-18 | Lafourche | Louisiana | 22057 | 3831 | 125 |
639280 | 639280 | 2020-10-17 | Lafourche | Louisiana | 22057 | 3810 | 124 |
636034 | 636034 | 2020-10-16 | Lafourche | Louisiana | 22057 | 3810 | 124 |
632788 | 632788 | 2020-10-15 | Lafourche | Louisiana | 22057 | 3807 | 123 |
629544 | 629544 | 2020-10-14 | Lafourche | Louisiana | 22057 | 3793 | 123 |
626300 | 626300 | 2020-10-13 | Lafourche | Louisiana | 22057 | 3788 | 123 |
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);