ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Lincoln" and fips = 37109 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1055464 | 1055464 | 2021-02-22 | Lincoln | North Carolina | 37109 | 8661 | 66 |
1052218 | 1052218 | 2021-02-21 | Lincoln | North Carolina | 37109 | 8632 | 66 |
1048971 | 1048971 | 2021-02-20 | Lincoln | North Carolina | 37109 | 8607 | 66 |
1045724 | 1045724 | 2021-02-19 | Lincoln | North Carolina | 37109 | 8582 | 66 |
1042479 | 1042479 | 2021-02-18 | Lincoln | North Carolina | 37109 | 8547 | 63 |
1039234 | 1039234 | 2021-02-17 | Lincoln | North Carolina | 37109 | 8505 | 63 |
1035989 | 1035989 | 2021-02-16 | Lincoln | North Carolina | 37109 | 8488 | 61 |
1032744 | 1032744 | 2021-02-15 | Lincoln | North Carolina | 37109 | 8465 | 61 |
1029498 | 1029498 | 2021-02-14 | Lincoln | North Carolina | 37109 | 8441 | 61 |
1026251 | 1026251 | 2021-02-13 | Lincoln | North Carolina | 37109 | 8413 | 61 |
1023006 | 1023006 | 2021-02-12 | Lincoln | North Carolina | 37109 | 8372 | 61 |
1019761 | 1019761 | 2021-02-11 | Lincoln | North Carolina | 37109 | 8348 | 57 |
1016516 | 1016516 | 2021-02-10 | Lincoln | North Carolina | 37109 | 8294 | 57 |
1013271 | 1013271 | 2021-02-09 | Lincoln | North Carolina | 37109 | 8267 | 57 |
1010026 | 1010026 | 2021-02-08 | Lincoln | North Carolina | 37109 | 8231 | 57 |
1006780 | 1006780 | 2021-02-07 | Lincoln | North Carolina | 37109 | 8188 | 57 |
1003534 | 1003534 | 2021-02-06 | Lincoln | North Carolina | 37109 | 8151 | 57 |
1000288 | 1000288 | 2021-02-05 | Lincoln | North Carolina | 37109 | 8108 | 57 |
997042 | 997042 | 2021-02-04 | Lincoln | North Carolina | 37109 | 8060 | 54 |
993796 | 993796 | 2021-02-03 | Lincoln | North Carolina | 37109 | 8006 | 54 |
990550 | 990550 | 2021-02-02 | Lincoln | North Carolina | 37109 | 7968 | 50 |
987304 | 987304 | 2021-02-01 | Lincoln | North Carolina | 37109 | 7939 | 50 |
984057 | 984057 | 2021-01-31 | Lincoln | North Carolina | 37109 | 7885 | 50 |
980810 | 980810 | 2021-01-30 | Lincoln | North Carolina | 37109 | 7740 | 49 |
977564 | 977564 | 2021-01-29 | Lincoln | North Carolina | 37109 | 7740 | 49 |
974319 | 974319 | 2021-01-28 | Lincoln | North Carolina | 37109 | 7647 | 49 |
971074 | 971074 | 2021-01-27 | Lincoln | North Carolina | 37109 | 7601 | 49 |
967829 | 967829 | 2021-01-26 | Lincoln | North Carolina | 37109 | 7550 | 43 |
964585 | 964585 | 2021-01-25 | Lincoln | North Carolina | 37109 | 7498 | 43 |
961340 | 961340 | 2021-01-24 | Lincoln | North Carolina | 37109 | 7451 | 43 |
958095 | 958095 | 2021-01-23 | Lincoln | North Carolina | 37109 | 7390 | 43 |
954849 | 954849 | 2021-01-22 | Lincoln | North Carolina | 37109 | 7324 | 43 |
951604 | 951604 | 2021-01-21 | Lincoln | North Carolina | 37109 | 7229 | 43 |
948359 | 948359 | 2021-01-20 | Lincoln | North Carolina | 37109 | 7172 | 43 |
945112 | 945112 | 2021-01-19 | Lincoln | North Carolina | 37109 | 7081 | 42 |
941866 | 941866 | 2021-01-18 | Lincoln | North Carolina | 37109 | 6980 | 42 |
938621 | 938621 | 2021-01-17 | Lincoln | North Carolina | 37109 | 6980 | 42 |
935376 | 935376 | 2021-01-16 | Lincoln | North Carolina | 37109 | 6873 | 42 |
932131 | 932131 | 2021-01-15 | Lincoln | North Carolina | 37109 | 6788 | 42 |
928886 | 928886 | 2021-01-14 | Lincoln | North Carolina | 37109 | 6694 | 42 |
925641 | 925641 | 2021-01-13 | Lincoln | North Carolina | 37109 | 6587 | 40 |
922395 | 922395 | 2021-01-12 | Lincoln | North Carolina | 37109 | 6510 | 40 |
919150 | 919150 | 2021-01-11 | Lincoln | North Carolina | 37109 | 6439 | 40 |
915905 | 915905 | 2021-01-10 | Lincoln | North Carolina | 37109 | 6341 | 40 |
912660 | 912660 | 2021-01-09 | Lincoln | North Carolina | 37109 | 6228 | 39 |
909415 | 909415 | 2021-01-08 | Lincoln | North Carolina | 37109 | 6106 | 39 |
906170 | 906170 | 2021-01-07 | Lincoln | North Carolina | 37109 | 5961 | 39 |
902924 | 902924 | 2021-01-06 | Lincoln | North Carolina | 37109 | 5883 | 26 |
899679 | 899679 | 2021-01-05 | Lincoln | North Carolina | 37109 | 5804 | 26 |
896434 | 896434 | 2021-01-04 | Lincoln | North Carolina | 37109 | 5733 | 26 |
893188 | 893188 | 2021-01-03 | Lincoln | North Carolina | 37109 | 5649 | 26 |
889942 | 889942 | 2021-01-02 | Lincoln | North Carolina | 37109 | 5585 | 20 |
886695 | 886695 | 2021-01-01 | Lincoln | North Carolina | 37109 | 5378 | 20 |
883450 | 883450 | 2020-12-31 | Lincoln | North Carolina | 37109 | 5378 | 20 |
880205 | 880205 | 2020-12-30 | Lincoln | North Carolina | 37109 | 5338 | 20 |
876960 | 876960 | 2020-12-29 | Lincoln | North Carolina | 37109 | 5235 | 20 |
873715 | 873715 | 2020-12-28 | Lincoln | North Carolina | 37109 | 5197 | 20 |
870470 | 870470 | 2020-12-27 | Lincoln | North Carolina | 37109 | 5144 | 20 |
867225 | 867225 | 2020-12-26 | Lincoln | North Carolina | 37109 | 5122 | 20 |
863980 | 863980 | 2020-12-25 | Lincoln | North Carolina | 37109 | 4881 | 20 |
860735 | 860735 | 2020-12-24 | Lincoln | North Carolina | 37109 | 4881 | 20 |
857490 | 857490 | 2020-12-23 | Lincoln | North Carolina | 37109 | 4881 | 20 |
854245 | 854245 | 2020-12-22 | Lincoln | North Carolina | 37109 | 4832 | 20 |
851000 | 851000 | 2020-12-21 | Lincoln | North Carolina | 37109 | 4754 | 20 |
847755 | 847755 | 2020-12-20 | Lincoln | North Carolina | 37109 | 4697 | 20 |
844510 | 844510 | 2020-12-19 | Lincoln | North Carolina | 37109 | 4632 | 20 |
841264 | 841264 | 2020-12-18 | Lincoln | North Carolina | 37109 | 4571 | 20 |
838019 | 838019 | 2020-12-17 | Lincoln | North Carolina | 37109 | 4487 | 20 |
834773 | 834773 | 2020-12-16 | Lincoln | North Carolina | 37109 | 4443 | 20 |
831527 | 831527 | 2020-12-15 | Lincoln | North Carolina | 37109 | 4370 | 20 |
828280 | 828280 | 2020-12-14 | Lincoln | North Carolina | 37109 | 4296 | 20 |
825034 | 825034 | 2020-12-13 | Lincoln | North Carolina | 37109 | 4246 | 20 |
821787 | 821787 | 2020-12-12 | Lincoln | North Carolina | 37109 | 4190 | 20 |
818541 | 818541 | 2020-12-11 | Lincoln | North Carolina | 37109 | 4138 | 20 |
815295 | 815295 | 2020-12-10 | Lincoln | North Carolina | 37109 | 4045 | 20 |
812050 | 812050 | 2020-12-09 | Lincoln | North Carolina | 37109 | 4002 | 20 |
808805 | 808805 | 2020-12-08 | Lincoln | North Carolina | 37109 | 3939 | 20 |
805560 | 805560 | 2020-12-07 | Lincoln | North Carolina | 37109 | 3867 | 20 |
802315 | 802315 | 2020-12-06 | Lincoln | North Carolina | 37109 | 3818 | 20 |
799070 | 799070 | 2020-12-05 | Lincoln | North Carolina | 37109 | 3752 | 20 |
795825 | 795825 | 2020-12-04 | Lincoln | North Carolina | 37109 | 3702 | 20 |
792580 | 792580 | 2020-12-03 | Lincoln | North Carolina | 37109 | 3636 | 20 |
789335 | 789335 | 2020-12-02 | Lincoln | North Carolina | 37109 | 3572 | 20 |
786090 | 786090 | 2020-12-01 | Lincoln | North Carolina | 37109 | 3509 | 20 |
782846 | 782846 | 2020-11-30 | Lincoln | North Carolina | 37109 | 3472 | 20 |
779600 | 779600 | 2020-11-29 | Lincoln | North Carolina | 37109 | 3430 | 20 |
776355 | 776355 | 2020-11-28 | Lincoln | North Carolina | 37109 | 3395 | 20 |
773110 | 773110 | 2020-11-27 | Lincoln | North Carolina | 37109 | 3369 | 20 |
769865 | 769865 | 2020-11-26 | Lincoln | North Carolina | 37109 | 3306 | 20 |
766619 | 766619 | 2020-11-25 | Lincoln | North Carolina | 37109 | 3306 | 20 |
763374 | 763374 | 2020-11-24 | Lincoln | North Carolina | 37109 | 3241 | 20 |
760129 | 760129 | 2020-11-23 | Lincoln | North Carolina | 37109 | 3202 | 20 |
756883 | 756883 | 2020-11-22 | Lincoln | North Carolina | 37109 | 3175 | 20 |
753636 | 753636 | 2020-11-21 | Lincoln | North Carolina | 37109 | 3118 | 20 |
750390 | 750390 | 2020-11-20 | Lincoln | North Carolina | 37109 | 3081 | 20 |
747144 | 747144 | 2020-11-19 | Lincoln | North Carolina | 37109 | 3049 | 20 |
743898 | 743898 | 2020-11-18 | Lincoln | North Carolina | 37109 | 3007 | 20 |
740651 | 740651 | 2020-11-17 | Lincoln | North Carolina | 37109 | 2962 | 16 |
737406 | 737406 | 2020-11-16 | Lincoln | North Carolina | 37109 | 2935 | 16 |
734162 | 734162 | 2020-11-15 | Lincoln | North Carolina | 37109 | 2916 | 16 |
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);