ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 22055 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
947549 | 947549 | 2021-01-20 | Lafayette | Louisiana | 22055 | 19507 | 223 |
944302 | 944302 | 2021-01-19 | Lafayette | Louisiana | 22055 | 19427 | 218 |
941057 | 941057 | 2021-01-18 | Lafayette | Louisiana | 22055 | 19315 | 217 |
937812 | 937812 | 2021-01-17 | Lafayette | Louisiana | 22055 | 19293 | 217 |
934567 | 934567 | 2021-01-16 | Lafayette | Louisiana | 22055 | 19085 | 212 |
931322 | 931322 | 2021-01-15 | Lafayette | Louisiana | 22055 | 19085 | 212 |
928077 | 928077 | 2021-01-14 | Lafayette | Louisiana | 22055 | 18968 | 212 |
924831 | 924831 | 2021-01-13 | Lafayette | Louisiana | 22055 | 18820 | 208 |
921586 | 921586 | 2021-01-12 | Lafayette | Louisiana | 22055 | 18678 | 206 |
918341 | 918341 | 2021-01-11 | Lafayette | Louisiana | 22055 | 18439 | 203 |
915096 | 915096 | 2021-01-10 | Lafayette | Louisiana | 22055 | 18403 | 202 |
911851 | 911851 | 2021-01-09 | Lafayette | Louisiana | 22055 | 18179 | 196 |
908606 | 908606 | 2021-01-08 | Lafayette | Louisiana | 22055 | 18179 | 196 |
905360 | 905360 | 2021-01-07 | Lafayette | Louisiana | 22055 | 18011 | 194 |
902115 | 902115 | 2021-01-06 | Lafayette | Louisiana | 22055 | 17698 | 192 |
898870 | 898870 | 2021-01-05 | Lafayette | Louisiana | 22055 | 17334 | 190 |
895625 | 895625 | 2021-01-04 | Lafayette | Louisiana | 22055 | 17051 | 189 |
892378 | 892378 | 2021-01-03 | Lafayette | Louisiana | 22055 | 17005 | 188 |
889132 | 889132 | 2021-01-02 | Lafayette | Louisiana | 22055 | 16753 | 188 |
885886 | 885886 | 2021-01-01 | Lafayette | Louisiana | 22055 | 16753 | 188 |
882641 | 882641 | 2020-12-31 | Lafayette | Louisiana | 22055 | 16753 | 188 |
879396 | 879396 | 2020-12-30 | Lafayette | Louisiana | 22055 | 16506 | 187 |
876151 | 876151 | 2020-12-29 | Lafayette | Louisiana | 22055 | 16154 | 188 |
872906 | 872906 | 2020-12-28 | Lafayette | Louisiana | 22055 | 16010 | 186 |
869661 | 869661 | 2020-12-27 | Lafayette | Louisiana | 22055 | 15990 | 184 |
866416 | 866416 | 2020-12-26 | Lafayette | Louisiana | 22055 | 15859 | 183 |
863171 | 863171 | 2020-12-25 | Lafayette | Louisiana | 22055 | 15859 | 183 |
859926 | 859926 | 2020-12-24 | Lafayette | Louisiana | 22055 | 15859 | 183 |
856681 | 856681 | 2020-12-23 | Lafayette | Louisiana | 22055 | 15706 | 183 |
853436 | 853436 | 2020-12-22 | Lafayette | Louisiana | 22055 | 15569 | 178 |
850191 | 850191 | 2020-12-21 | Lafayette | Louisiana | 22055 | 15272 | 175 |
846946 | 846946 | 2020-12-20 | Lafayette | Louisiana | 22055 | 15219 | 173 |
843700 | 843700 | 2020-12-19 | Lafayette | Louisiana | 22055 | 15040 | 173 |
840455 | 840455 | 2020-12-18 | Lafayette | Louisiana | 22055 | 15040 | 173 |
837210 | 837210 | 2020-12-17 | Lafayette | Louisiana | 22055 | 14838 | 173 |
833964 | 833964 | 2020-12-16 | Lafayette | Louisiana | 22055 | 14660 | 172 |
830717 | 830717 | 2020-12-15 | Lafayette | Louisiana | 22055 | 14432 | 171 |
827471 | 827471 | 2020-12-14 | Lafayette | Louisiana | 22055 | 14269 | 167 |
824224 | 824224 | 2020-12-13 | Lafayette | Louisiana | 22055 | 14200 | 167 |
820978 | 820978 | 2020-12-12 | Lafayette | Louisiana | 22055 | 13855 | 165 |
817732 | 817732 | 2020-12-11 | Lafayette | Louisiana | 22055 | 13855 | 165 |
814486 | 814486 | 2020-12-10 | Lafayette | Louisiana | 22055 | 13688 | 164 |
811241 | 811241 | 2020-12-09 | Lafayette | Louisiana | 22055 | 13555 | 164 |
807996 | 807996 | 2020-12-08 | Lafayette | Louisiana | 22055 | 13225 | 163 |
804751 | 804751 | 2020-12-07 | Lafayette | Louisiana | 22055 | 13096 | 158 |
801506 | 801506 | 2020-12-06 | Lafayette | Louisiana | 22055 | 13054 | 158 |
798261 | 798261 | 2020-12-05 | Lafayette | Louisiana | 22055 | 12877 | 157 |
795016 | 795016 | 2020-12-04 | Lafayette | Louisiana | 22055 | 12877 | 157 |
791771 | 791771 | 2020-12-03 | Lafayette | Louisiana | 22055 | 12674 | 156 |
788526 | 788526 | 2020-12-02 | Lafayette | Louisiana | 22055 | 12509 | 155 |
785282 | 785282 | 2020-12-01 | Lafayette | Louisiana | 22055 | 12430 | 152 |
782037 | 782037 | 2020-11-30 | Lafayette | Louisiana | 22055 | 12113 | 147 |
778791 | 778791 | 2020-11-29 | Lafayette | Louisiana | 22055 | 12118 | 147 |
775546 | 775546 | 2020-11-28 | Lafayette | Louisiana | 22055 | 12035 | 146 |
772301 | 772301 | 2020-11-27 | Lafayette | Louisiana | 22055 | 12035 | 146 |
769056 | 769056 | 2020-11-26 | Lafayette | Louisiana | 22055 | 11778 | 146 |
765810 | 765810 | 2020-11-25 | Lafayette | Louisiana | 22055 | 11778 | 146 |
762565 | 762565 | 2020-11-24 | Lafayette | Louisiana | 22055 | 11695 | 146 |
759320 | 759320 | 2020-11-23 | Lafayette | Louisiana | 22055 | 11464 | 145 |
756073 | 756073 | 2020-11-22 | Lafayette | Louisiana | 22055 | 11398 | 145 |
752827 | 752827 | 2020-11-21 | Lafayette | Louisiana | 22055 | 11146 | 145 |
749581 | 749581 | 2020-11-20 | Lafayette | Louisiana | 22055 | 11146 | 145 |
746335 | 746335 | 2020-11-19 | Lafayette | Louisiana | 22055 | 10963 | 144 |
743088 | 743088 | 2020-11-18 | Lafayette | Louisiana | 22055 | 10782 | 143 |
739841 | 739841 | 2020-11-17 | Lafayette | Louisiana | 22055 | 10680 | 143 |
736597 | 736597 | 2020-11-16 | Lafayette | Louisiana | 22055 | 10434 | 142 |
733351 | 733351 | 2020-11-15 | Lafayette | Louisiana | 22055 | 10404 | 142 |
730106 | 730106 | 2020-11-14 | Lafayette | Louisiana | 22055 | 10267 | 142 |
726863 | 726863 | 2020-11-13 | Lafayette | Louisiana | 22055 | 10267 | 142 |
723620 | 723620 | 2020-11-12 | Lafayette | Louisiana | 22055 | 9878 | 141 |
720377 | 720377 | 2020-11-11 | Lafayette | Louisiana | 22055 | 9808 | 141 |
717134 | 717134 | 2020-11-10 | Lafayette | Louisiana | 22055 | 9808 | 141 |
713890 | 713890 | 2020-11-09 | Lafayette | Louisiana | 22055 | 9742 | 140 |
710646 | 710646 | 2020-11-08 | Lafayette | Louisiana | 22055 | 9719 | 140 |
707402 | 707402 | 2020-11-07 | Lafayette | Louisiana | 22055 | 9671 | 140 |
704159 | 704159 | 2020-11-06 | Lafayette | Louisiana | 22055 | 9671 | 140 |
700917 | 700917 | 2020-11-05 | Lafayette | Louisiana | 22055 | 9630 | 140 |
697673 | 697673 | 2020-11-04 | Lafayette | Louisiana | 22055 | 9610 | 140 |
694430 | 694430 | 2020-11-03 | Lafayette | Louisiana | 22055 | 9600 | 140 |
691188 | 691188 | 2020-11-02 | Lafayette | Louisiana | 22055 | 9531 | 140 |
687943 | 687943 | 2020-11-01 | Lafayette | Louisiana | 22055 | 9534 | 140 |
684699 | 684699 | 2020-10-31 | Lafayette | Louisiana | 22055 | 9505 | 140 |
681456 | 681456 | 2020-10-30 | Lafayette | Louisiana | 22055 | 9505 | 140 |
678212 | 678212 | 2020-10-29 | Lafayette | Louisiana | 22055 | 9493 | 139 |
674970 | 674970 | 2020-10-28 | Lafayette | Louisiana | 22055 | 9477 | 139 |
671727 | 671727 | 2020-10-27 | Lafayette | Louisiana | 22055 | 9463 | 139 |
668485 | 668485 | 2020-10-26 | Lafayette | Louisiana | 22055 | 9433 | 139 |
665241 | 665241 | 2020-10-25 | Lafayette | Louisiana | 22055 | 9421 | 138 |
661996 | 661996 | 2020-10-24 | Lafayette | Louisiana | 22055 | 9380 | 138 |
658752 | 658752 | 2020-10-23 | Lafayette | Louisiana | 22055 | 9380 | 138 |
655507 | 655507 | 2020-10-22 | Lafayette | Louisiana | 22055 | 9378 | 137 |
652262 | 652262 | 2020-10-21 | Lafayette | Louisiana | 22055 | 9345 | 137 |
649017 | 649017 | 2020-10-20 | Lafayette | Louisiana | 22055 | 9315 | 137 |
645773 | 645773 | 2020-10-19 | Lafayette | Louisiana | 22055 | 9297 | 137 |
642526 | 642526 | 2020-10-18 | Lafayette | Louisiana | 22055 | 9289 | 137 |
639279 | 639279 | 2020-10-17 | Lafayette | Louisiana | 22055 | 9241 | 136 |
636033 | 636033 | 2020-10-16 | Lafayette | Louisiana | 22055 | 9241 | 136 |
632787 | 632787 | 2020-10-15 | Lafayette | Louisiana | 22055 | 9212 | 136 |
629543 | 629543 | 2020-10-14 | Lafayette | Louisiana | 22055 | 9209 | 136 |
626299 | 626299 | 2020-10-13 | Lafayette | Louisiana | 22055 | 9183 | 136 |
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);