ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Lincoln" and fips = 22061 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921588 | 921588 | 2021-01-12 | Lincoln | Louisiana | 22061 | 3612 | 78 |
918343 | 918343 | 2021-01-11 | Lincoln | Louisiana | 22061 | 3587 | 78 |
915098 | 915098 | 2021-01-10 | Lincoln | Louisiana | 22061 | 3585 | 78 |
911853 | 911853 | 2021-01-09 | Lincoln | Louisiana | 22061 | 3520 | 78 |
908608 | 908608 | 2021-01-08 | Lincoln | Louisiana | 22061 | 3520 | 78 |
905362 | 905362 | 2021-01-07 | Lincoln | Louisiana | 22061 | 3503 | 78 |
902117 | 902117 | 2021-01-06 | Lincoln | Louisiana | 22061 | 3479 | 77 |
898872 | 898872 | 2021-01-05 | Lincoln | Louisiana | 22061 | 3423 | 77 |
895627 | 895627 | 2021-01-04 | Lincoln | Louisiana | 22061 | 3364 | 74 |
892380 | 892380 | 2021-01-03 | Lincoln | Louisiana | 22061 | 3361 | 74 |
889134 | 889134 | 2021-01-02 | Lincoln | Louisiana | 22061 | 3339 | 73 |
885888 | 885888 | 2021-01-01 | Lincoln | Louisiana | 22061 | 3339 | 73 |
882643 | 882643 | 2020-12-31 | Lincoln | Louisiana | 22061 | 3339 | 73 |
879398 | 879398 | 2020-12-30 | Lincoln | Louisiana | 22061 | 3298 | 72 |
876153 | 876153 | 2020-12-29 | Lincoln | Louisiana | 22061 | 3259 | 69 |
872908 | 872908 | 2020-12-28 | Lincoln | Louisiana | 22061 | 3236 | 69 |
869663 | 869663 | 2020-12-27 | Lincoln | Louisiana | 22061 | 3233 | 69 |
866418 | 866418 | 2020-12-26 | Lincoln | Louisiana | 22061 | 3204 | 69 |
863173 | 863173 | 2020-12-25 | Lincoln | Louisiana | 22061 | 3204 | 69 |
859928 | 859928 | 2020-12-24 | Lincoln | Louisiana | 22061 | 3204 | 69 |
856683 | 856683 | 2020-12-23 | Lincoln | Louisiana | 22061 | 3159 | 69 |
853438 | 853438 | 2020-12-22 | Lincoln | Louisiana | 22061 | 3133 | 71 |
850193 | 850193 | 2020-12-21 | Lincoln | Louisiana | 22061 | 3120 | 70 |
846948 | 846948 | 2020-12-20 | Lincoln | Louisiana | 22061 | 3112 | 68 |
843702 | 843702 | 2020-12-19 | Lincoln | Louisiana | 22061 | 3070 | 66 |
840457 | 840457 | 2020-12-18 | Lincoln | Louisiana | 22061 | 3070 | 66 |
837212 | 837212 | 2020-12-17 | Lincoln | Louisiana | 22061 | 3037 | 66 |
833966 | 833966 | 2020-12-16 | Lincoln | Louisiana | 22061 | 2978 | 64 |
830719 | 830719 | 2020-12-15 | Lincoln | Louisiana | 22061 | 2965 | 63 |
827473 | 827473 | 2020-12-14 | Lincoln | Louisiana | 22061 | 2949 | 63 |
824226 | 824226 | 2020-12-13 | Lincoln | Louisiana | 22061 | 2945 | 63 |
820980 | 820980 | 2020-12-12 | Lincoln | Louisiana | 22061 | 2886 | 63 |
817734 | 817734 | 2020-12-11 | Lincoln | Louisiana | 22061 | 2886 | 63 |
814488 | 814488 | 2020-12-10 | Lincoln | Louisiana | 22061 | 2860 | 61 |
811243 | 811243 | 2020-12-09 | Lincoln | Louisiana | 22061 | 2830 | 61 |
807998 | 807998 | 2020-12-08 | Lincoln | Louisiana | 22061 | 2801 | 61 |
804753 | 804753 | 2020-12-07 | Lincoln | Louisiana | 22061 | 2771 | 61 |
801508 | 801508 | 2020-12-06 | Lincoln | Louisiana | 22061 | 2765 | 61 |
798263 | 798263 | 2020-12-05 | Lincoln | Louisiana | 22061 | 2697 | 61 |
795018 | 795018 | 2020-12-04 | Lincoln | Louisiana | 22061 | 2697 | 61 |
791773 | 791773 | 2020-12-03 | Lincoln | Louisiana | 22061 | 2638 | 61 |
788528 | 788528 | 2020-12-02 | Lincoln | Louisiana | 22061 | 2607 | 61 |
785284 | 785284 | 2020-12-01 | Lincoln | Louisiana | 22061 | 2577 | 60 |
782039 | 782039 | 2020-11-30 | Lincoln | Louisiana | 22061 | 2526 | 59 |
778793 | 778793 | 2020-11-29 | Lincoln | Louisiana | 22061 | 2527 | 59 |
775548 | 775548 | 2020-11-28 | Lincoln | Louisiana | 22061 | 2501 | 59 |
772303 | 772303 | 2020-11-27 | Lincoln | Louisiana | 22061 | 2501 | 59 |
769058 | 769058 | 2020-11-26 | Lincoln | Louisiana | 22061 | 2465 | 58 |
765812 | 765812 | 2020-11-25 | Lincoln | Louisiana | 22061 | 2465 | 58 |
762567 | 762567 | 2020-11-24 | Lincoln | Louisiana | 22061 | 2443 | 58 |
759322 | 759322 | 2020-11-23 | Lincoln | Louisiana | 22061 | 2368 | 55 |
756075 | 756075 | 2020-11-22 | Lincoln | Louisiana | 22061 | 2359 | 55 |
752829 | 752829 | 2020-11-21 | Lincoln | Louisiana | 22061 | 2318 | 55 |
749583 | 749583 | 2020-11-20 | Lincoln | Louisiana | 22061 | 2318 | 55 |
746337 | 746337 | 2020-11-19 | Lincoln | Louisiana | 22061 | 2258 | 54 |
743090 | 743090 | 2020-11-18 | Lincoln | Louisiana | 22061 | 2224 | 54 |
739843 | 739843 | 2020-11-17 | Lincoln | Louisiana | 22061 | 2169 | 54 |
736599 | 736599 | 2020-11-16 | Lincoln | Louisiana | 22061 | 2141 | 54 |
733353 | 733353 | 2020-11-15 | Lincoln | Louisiana | 22061 | 2136 | 54 |
730108 | 730108 | 2020-11-14 | Lincoln | Louisiana | 22061 | 2060 | 54 |
726865 | 726865 | 2020-11-13 | Lincoln | Louisiana | 22061 | 2060 | 54 |
723622 | 723622 | 2020-11-12 | Lincoln | Louisiana | 22061 | 1817 | 53 |
720379 | 720379 | 2020-11-11 | Lincoln | Louisiana | 22061 | 1785 | 53 |
717136 | 717136 | 2020-11-10 | Lincoln | Louisiana | 22061 | 1785 | 53 |
713892 | 713892 | 2020-11-09 | Lincoln | Louisiana | 22061 | 1757 | 52 |
710648 | 710648 | 2020-11-08 | Lincoln | Louisiana | 22061 | 1757 | 52 |
707404 | 707404 | 2020-11-07 | Lincoln | Louisiana | 22061 | 1745 | 52 |
704161 | 704161 | 2020-11-06 | Lincoln | Louisiana | 22061 | 1745 | 52 |
700919 | 700919 | 2020-11-05 | Lincoln | Louisiana | 22061 | 1745 | 52 |
697675 | 697675 | 2020-11-04 | Lincoln | Louisiana | 22061 | 1741 | 52 |
694432 | 694432 | 2020-11-03 | Lincoln | Louisiana | 22061 | 1731 | 52 |
691190 | 691190 | 2020-11-02 | Lincoln | Louisiana | 22061 | 1701 | 51 |
687945 | 687945 | 2020-11-01 | Lincoln | Louisiana | 22061 | 1702 | 50 |
684701 | 684701 | 2020-10-31 | Lincoln | Louisiana | 22061 | 1688 | 50 |
681458 | 681458 | 2020-10-30 | Lincoln | Louisiana | 22061 | 1688 | 50 |
678214 | 678214 | 2020-10-29 | Lincoln | Louisiana | 22061 | 1679 | 50 |
674972 | 674972 | 2020-10-28 | Lincoln | Louisiana | 22061 | 1676 | 49 |
671729 | 671729 | 2020-10-27 | Lincoln | Louisiana | 22061 | 1672 | 49 |
668487 | 668487 | 2020-10-26 | Lincoln | Louisiana | 22061 | 1658 | 48 |
665243 | 665243 | 2020-10-25 | Lincoln | Louisiana | 22061 | 1649 | 48 |
661998 | 661998 | 2020-10-24 | Lincoln | Louisiana | 22061 | 1633 | 48 |
658754 | 658754 | 2020-10-23 | Lincoln | Louisiana | 22061 | 1633 | 48 |
655509 | 655509 | 2020-10-22 | Lincoln | Louisiana | 22061 | 1630 | 48 |
652264 | 652264 | 2020-10-21 | Lincoln | Louisiana | 22061 | 1622 | 48 |
649019 | 649019 | 2020-10-20 | Lincoln | Louisiana | 22061 | 1607 | 48 |
645775 | 645775 | 2020-10-19 | Lincoln | Louisiana | 22061 | 1602 | 48 |
642528 | 642528 | 2020-10-18 | Lincoln | Louisiana | 22061 | 1604 | 48 |
639281 | 639281 | 2020-10-17 | Lincoln | Louisiana | 22061 | 1592 | 48 |
636035 | 636035 | 2020-10-16 | Lincoln | Louisiana | 22061 | 1592 | 48 |
632789 | 632789 | 2020-10-15 | Lincoln | Louisiana | 22061 | 1582 | 48 |
629545 | 629545 | 2020-10-14 | Lincoln | Louisiana | 22061 | 1574 | 48 |
626301 | 626301 | 2020-10-13 | Lincoln | Louisiana | 22061 | 1554 | 48 |
623059 | 623059 | 2020-10-12 | Lincoln | Louisiana | 22061 | 1542 | 48 |
619815 | 619815 | 2020-10-11 | Lincoln | Louisiana | 22061 | 1537 | 48 |
616573 | 616573 | 2020-10-10 | Lincoln | Louisiana | 22061 | 1469 | 48 |
613332 | 613332 | 2020-10-09 | Lincoln | Louisiana | 22061 | 1469 | 48 |
610090 | 610090 | 2020-10-08 | Lincoln | Louisiana | 22061 | 1471 | 48 |
606848 | 606848 | 2020-10-07 | Lincoln | Louisiana | 22061 | 1462 | 48 |
603606 | 603606 | 2020-10-06 | Lincoln | Louisiana | 22061 | 1448 | 48 |
600363 | 600363 | 2020-10-05 | Lincoln | Louisiana | 22061 | 1439 | 48 |
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);