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 |
---|---|---|---|---|---|---|---|
1080621 | 1080621 | 2021-03-02 | Lincoln | Louisiana | 22061 | 4232 | 89 |
1077376 | 1077376 | 2021-03-01 | Lincoln | Louisiana | 22061 | 4230 | 89 |
1074130 | 1074130 | 2021-02-28 | Lincoln | Louisiana | 22061 | 4230 | 89 |
1070884 | 1070884 | 2021-02-27 | Lincoln | Louisiana | 22061 | 4218 | 89 |
1067639 | 1067639 | 2021-02-26 | Lincoln | Louisiana | 22061 | 4218 | 89 |
1064394 | 1064394 | 2021-02-25 | Lincoln | Louisiana | 22061 | 4216 | 89 |
1061149 | 1061149 | 2021-02-24 | Lincoln | Louisiana | 22061 | 4213 | 88 |
1057903 | 1057903 | 2021-02-23 | Lincoln | Louisiana | 22061 | 4210 | 88 |
1054657 | 1054657 | 2021-02-22 | Lincoln | Louisiana | 22061 | 4213 | 88 |
1051410 | 1051410 | 2021-02-21 | Lincoln | Louisiana | 22061 | 4212 | 88 |
1048163 | 1048163 | 2021-02-20 | Lincoln | Louisiana | 22061 | 4205 | 88 |
1044918 | 1044918 | 2021-02-19 | Lincoln | Louisiana | 22061 | 4205 | 88 |
1041673 | 1041673 | 2021-02-18 | Lincoln | Louisiana | 22061 | 4201 | 88 |
1038428 | 1038428 | 2021-02-17 | Lincoln | Louisiana | 22061 | 4204 | 88 |
1035183 | 1035183 | 2021-02-16 | Lincoln | Louisiana | 22061 | 4193 | 87 |
1031937 | 1031937 | 2021-02-15 | Lincoln | Louisiana | 22061 | 4193 | 87 |
1028690 | 1028690 | 2021-02-14 | Lincoln | Louisiana | 22061 | 4193 | 86 |
1025445 | 1025445 | 2021-02-13 | Lincoln | Louisiana | 22061 | 4183 | 86 |
1022200 | 1022200 | 2021-02-12 | Lincoln | Louisiana | 22061 | 4183 | 86 |
1018955 | 1018955 | 2021-02-11 | Lincoln | Louisiana | 22061 | 4172 | 86 |
1015710 | 1015710 | 2021-02-10 | Lincoln | Louisiana | 22061 | 4159 | 85 |
1012465 | 1012465 | 2021-02-09 | Lincoln | Louisiana | 22061 | 4154 | 84 |
1009219 | 1009219 | 2021-02-08 | Lincoln | Louisiana | 22061 | 4146 | 84 |
1005973 | 1005973 | 2021-02-07 | Lincoln | Louisiana | 22061 | 4131 | 84 |
1002727 | 1002727 | 2021-02-06 | Lincoln | Louisiana | 22061 | 4103 | 84 |
999481 | 999481 | 2021-02-05 | Lincoln | Louisiana | 22061 | 4103 | 84 |
996235 | 996235 | 2021-02-04 | Lincoln | Louisiana | 22061 | 4095 | 84 |
992989 | 992989 | 2021-02-03 | Lincoln | Louisiana | 22061 | 4083 | 84 |
989743 | 989743 | 2021-02-02 | Lincoln | Louisiana | 22061 | 4074 | 84 |
986496 | 986496 | 2021-02-01 | Lincoln | Louisiana | 22061 | 4053 | 84 |
983249 | 983249 | 2021-01-31 | Lincoln | Louisiana | 22061 | 4047 | 84 |
980003 | 980003 | 2021-01-30 | Lincoln | Louisiana | 22061 | 4017 | 84 |
976757 | 976757 | 2021-01-29 | Lincoln | Louisiana | 22061 | 4017 | 84 |
973512 | 973512 | 2021-01-28 | Lincoln | Louisiana | 22061 | 4009 | 84 |
970267 | 970267 | 2021-01-27 | Lincoln | Louisiana | 22061 | 3978 | 84 |
967023 | 967023 | 2021-01-26 | Lincoln | Louisiana | 22061 | 3961 | 83 |
963778 | 963778 | 2021-01-25 | Lincoln | Louisiana | 22061 | 3932 | 83 |
960533 | 960533 | 2021-01-24 | Lincoln | Louisiana | 22061 | 3924 | 83 |
957287 | 957287 | 2021-01-23 | Lincoln | Louisiana | 22061 | 3838 | 83 |
954042 | 954042 | 2021-01-22 | Lincoln | Louisiana | 22061 | 3838 | 83 |
950797 | 950797 | 2021-01-21 | Lincoln | Louisiana | 22061 | 3818 | 83 |
947551 | 947551 | 2021-01-20 | Lincoln | Louisiana | 22061 | 3788 | 81 |
944304 | 944304 | 2021-01-19 | Lincoln | Louisiana | 22061 | 3761 | 80 |
941059 | 941059 | 2021-01-18 | Lincoln | Louisiana | 22061 | 3747 | 80 |
937814 | 937814 | 2021-01-17 | Lincoln | Louisiana | 22061 | 3738 | 80 |
934569 | 934569 | 2021-01-16 | Lincoln | Louisiana | 22061 | 3700 | 79 |
931324 | 931324 | 2021-01-15 | Lincoln | Louisiana | 22061 | 3700 | 79 |
928079 | 928079 | 2021-01-14 | Lincoln | Louisiana | 22061 | 3673 | 79 |
924833 | 924833 | 2021-01-13 | Lincoln | Louisiana | 22061 | 3646 | 78 |
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 |
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);