ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Lincoln" and fips = 29113 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1055061 | 1055061 | 2021-02-22 | Lincoln | Missouri | 29113 | 4272 | 32 |
1051814 | 1051814 | 2021-02-21 | Lincoln | Missouri | 29113 | 4267 | 32 |
1048567 | 1048567 | 2021-02-20 | Lincoln | Missouri | 29113 | 4264 | 32 |
1045321 | 1045321 | 2021-02-19 | Lincoln | Missouri | 29113 | 4260 | 32 |
1042076 | 1042076 | 2021-02-18 | Lincoln | Missouri | 29113 | 4248 | 31 |
1038831 | 1038831 | 2021-02-17 | Lincoln | Missouri | 29113 | 4238 | 30 |
1035586 | 1035586 | 2021-02-16 | Lincoln | Missouri | 29113 | 4234 | 30 |
1032341 | 1032341 | 2021-02-15 | Lincoln | Missouri | 29113 | 4220 | 30 |
1029094 | 1029094 | 2021-02-14 | Lincoln | Missouri | 29113 | 4215 | 30 |
1025848 | 1025848 | 2021-02-13 | Lincoln | Missouri | 29113 | 4202 | 30 |
1022603 | 1022603 | 2021-02-12 | Lincoln | Missouri | 29113 | 4188 | 30 |
1019358 | 1019358 | 2021-02-11 | Lincoln | Missouri | 29113 | 4179 | 30 |
1016113 | 1016113 | 2021-02-10 | Lincoln | Missouri | 29113 | 4165 | 27 |
1012868 | 1012868 | 2021-02-09 | Lincoln | Missouri | 29113 | 4160 | 27 |
1009623 | 1009623 | 2021-02-08 | Lincoln | Missouri | 29113 | 4157 | 27 |
1006376 | 1006376 | 2021-02-07 | Lincoln | Missouri | 29113 | 4151 | 27 |
1003130 | 1003130 | 2021-02-06 | Lincoln | Missouri | 29113 | 4147 | 27 |
999885 | 999885 | 2021-02-05 | Lincoln | Missouri | 29113 | 4137 | 27 |
996639 | 996639 | 2021-02-04 | Lincoln | Missouri | 29113 | 4128 | 27 |
993393 | 993393 | 2021-02-03 | Lincoln | Missouri | 29113 | 4115 | 27 |
990147 | 990147 | 2021-02-02 | Lincoln | Missouri | 29113 | 4098 | 27 |
986900 | 986900 | 2021-02-01 | Lincoln | Missouri | 29113 | 4094 | 24 |
983653 | 983653 | 2021-01-31 | Lincoln | Missouri | 29113 | 4088 | 24 |
980407 | 980407 | 2021-01-30 | Lincoln | Missouri | 29113 | 4078 | 24 |
977161 | 977161 | 2021-01-29 | Lincoln | Missouri | 29113 | 4060 | 24 |
973916 | 973916 | 2021-01-28 | Lincoln | Missouri | 29113 | 4052 | 24 |
970671 | 970671 | 2021-01-27 | Lincoln | Missouri | 29113 | 4030 | 24 |
967426 | 967426 | 2021-01-26 | Lincoln | Missouri | 29113 | 4008 | 24 |
964182 | 964182 | 2021-01-25 | Lincoln | Missouri | 29113 | 3990 | 24 |
960937 | 960937 | 2021-01-24 | Lincoln | Missouri | 29113 | 3984 | 24 |
957691 | 957691 | 2021-01-23 | Lincoln | Missouri | 29113 | 3976 | 24 |
954446 | 954446 | 2021-01-22 | Lincoln | Missouri | 29113 | 3964 | 24 |
951201 | 951201 | 2021-01-21 | Lincoln | Missouri | 29113 | 3952 | 24 |
947955 | 947955 | 2021-01-20 | Lincoln | Missouri | 29113 | 3925 | 24 |
944708 | 944708 | 2021-01-19 | Lincoln | Missouri | 29113 | 3919 | 24 |
941463 | 941463 | 2021-01-18 | Lincoln | Missouri | 29113 | 3907 | 24 |
938218 | 938218 | 2021-01-17 | Lincoln | Missouri | 29113 | 3891 | 24 |
934973 | 934973 | 2021-01-16 | Lincoln | Missouri | 29113 | 3882 | 24 |
931728 | 931728 | 2021-01-15 | Lincoln | Missouri | 29113 | 3872 | 24 |
928483 | 928483 | 2021-01-14 | Lincoln | Missouri | 29113 | 3853 | 24 |
925237 | 925237 | 2021-01-13 | Lincoln | Missouri | 29113 | 3835 | 24 |
921992 | 921992 | 2021-01-12 | Lincoln | Missouri | 29113 | 3817 | 23 |
918747 | 918747 | 2021-01-11 | Lincoln | Missouri | 29113 | 3803 | 20 |
915502 | 915502 | 2021-01-10 | Lincoln | Missouri | 29113 | 3791 | 20 |
912257 | 912257 | 2021-01-09 | Lincoln | Missouri | 29113 | 3758 | 20 |
909012 | 909012 | 2021-01-08 | Lincoln | Missouri | 29113 | 3742 | 20 |
905766 | 905766 | 2021-01-07 | Lincoln | Missouri | 29113 | 3704 | 20 |
902521 | 902521 | 2021-01-06 | Lincoln | Missouri | 29113 | 3666 | 20 |
899276 | 899276 | 2021-01-05 | Lincoln | Missouri | 29113 | 3639 | 20 |
896031 | 896031 | 2021-01-04 | Lincoln | Missouri | 29113 | 3612 | 20 |
892784 | 892784 | 2021-01-03 | Lincoln | Missouri | 29113 | 3612 | 20 |
889538 | 889538 | 2021-01-02 | Lincoln | Missouri | 29113 | 3582 | 20 |
886292 | 886292 | 2021-01-01 | Lincoln | Missouri | 29113 | 3561 | 20 |
883047 | 883047 | 2020-12-31 | Lincoln | Missouri | 29113 | 3536 | 20 |
879802 | 879802 | 2020-12-30 | Lincoln | Missouri | 29113 | 3501 | 20 |
876557 | 876557 | 2020-12-29 | Lincoln | Missouri | 29113 | 3478 | 20 |
873312 | 873312 | 2020-12-28 | Lincoln | Missouri | 29113 | 3460 | 20 |
870067 | 870067 | 2020-12-27 | Lincoln | Missouri | 29113 | 3447 | 20 |
866822 | 866822 | 2020-12-26 | Lincoln | Missouri | 29113 | 3438 | 20 |
863577 | 863577 | 2020-12-25 | Lincoln | Missouri | 29113 | 3413 | 20 |
860332 | 860332 | 2020-12-24 | Lincoln | Missouri | 29113 | 3388 | 20 |
857087 | 857087 | 2020-12-23 | Lincoln | Missouri | 29113 | 3357 | 18 |
853842 | 853842 | 2020-12-22 | Lincoln | Missouri | 29113 | 3321 | 18 |
850597 | 850597 | 2020-12-21 | Lincoln | Missouri | 29113 | 3298 | 17 |
847352 | 847352 | 2020-12-20 | Lincoln | Missouri | 29113 | 3246 | 17 |
844106 | 844106 | 2020-12-19 | Lincoln | Missouri | 29113 | 3225 | 17 |
840861 | 840861 | 2020-12-18 | Lincoln | Missouri | 29113 | 3202 | 17 |
837616 | 837616 | 2020-12-17 | Lincoln | Missouri | 29113 | 3147 | 17 |
834370 | 834370 | 2020-12-16 | Lincoln | Missouri | 29113 | 3102 | 17 |
831123 | 831123 | 2020-12-15 | Lincoln | Missouri | 29113 | 3080 | 16 |
827877 | 827877 | 2020-12-14 | Lincoln | Missouri | 29113 | 3033 | 13 |
824630 | 824630 | 2020-12-13 | Lincoln | Missouri | 29113 | 3005 | 13 |
821384 | 821384 | 2020-12-12 | Lincoln | Missouri | 29113 | 2961 | 13 |
818138 | 818138 | 2020-12-11 | Lincoln | Missouri | 29113 | 2860 | 13 |
814892 | 814892 | 2020-12-10 | Lincoln | Missouri | 29113 | 2860 | 13 |
811647 | 811647 | 2020-12-09 | Lincoln | Missouri | 29113 | 2809 | 13 |
808402 | 808402 | 2020-12-08 | Lincoln | Missouri | 29113 | 2784 | 13 |
805157 | 805157 | 2020-12-07 | Lincoln | Missouri | 29113 | 2763 | 13 |
801912 | 801912 | 2020-12-06 | Lincoln | Missouri | 29113 | 2723 | 13 |
798667 | 798667 | 2020-12-05 | Lincoln | Missouri | 29113 | 2695 | 13 |
795422 | 795422 | 2020-12-04 | Lincoln | Missouri | 29113 | 2634 | 13 |
792177 | 792177 | 2020-12-03 | Lincoln | Missouri | 29113 | 2587 | 13 |
788932 | 788932 | 2020-12-02 | Lincoln | Missouri | 29113 | 2540 | 13 |
785687 | 785687 | 2020-12-01 | Lincoln | Missouri | 29113 | 2509 | 13 |
782443 | 782443 | 2020-11-30 | Lincoln | Missouri | 29113 | 2476 | 9 |
779197 | 779197 | 2020-11-29 | Lincoln | Missouri | 29113 | 2438 | 9 |
775952 | 775952 | 2020-11-28 | Lincoln | Missouri | 29113 | 2407 | 9 |
772707 | 772707 | 2020-11-27 | Lincoln | Missouri | 29113 | 2394 | 9 |
769462 | 769462 | 2020-11-26 | Lincoln | Missouri | 29113 | 2363 | 9 |
766216 | 766216 | 2020-11-25 | Lincoln | Missouri | 29113 | 2304 | 9 |
762971 | 762971 | 2020-11-24 | Lincoln | Missouri | 29113 | 2254 | 9 |
759726 | 759726 | 2020-11-23 | Lincoln | Missouri | 29113 | 2217 | 8 |
756479 | 756479 | 2020-11-22 | Lincoln | Missouri | 29113 | 2160 | 8 |
753233 | 753233 | 2020-11-21 | Lincoln | Missouri | 29113 | 2114 | 8 |
749987 | 749987 | 2020-11-20 | Lincoln | Missouri | 29113 | 2072 | 8 |
746741 | 746741 | 2020-11-19 | Lincoln | Missouri | 29113 | 2013 | 8 |
743494 | 743494 | 2020-11-18 | Lincoln | Missouri | 29113 | 1972 | 8 |
740247 | 740247 | 2020-11-17 | Lincoln | Missouri | 29113 | 1928 | 8 |
737003 | 737003 | 2020-11-16 | Lincoln | Missouri | 29113 | 1858 | 7 |
733757 | 733757 | 2020-11-15 | Lincoln | Missouri | 29113 | 1817 | 7 |
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);