ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
909 rows where county = "Lincoln" and deaths = 2 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 24
- Maine 162
- Nebraska 154
- Oklahoma 100
- Minnesota 90
- West Virginia 78
- South Dakota 66
- Montana 43
- New Mexico 34
- Washington 33
- Kansas 22
- North Carolina 22
- Kentucky 19
- Georgia 13
- Nevada 13
- Tennessee 13
- Wyoming 13
- Oregon 10
- Missouri 8
- Louisiana 6
- Colorado 4
- Idaho 2
- Wisconsin 2
- Arkansas 1
- Mississippi 1
fips 24
county 1
- Lincoln · 909 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1343669 | 1343669 | 2021-05-22 | Lincoln | Maine | 23015 | 1030 | 2 |
1340421 | 1340421 | 2021-05-21 | Lincoln | Maine | 23015 | 1027 | 2 |
1337174 | 1337174 | 2021-05-20 | Lincoln | Maine | 23015 | 1019 | 2 |
1333927 | 1333927 | 2021-05-19 | Lincoln | Maine | 23015 | 1014 | 2 |
1330680 | 1330680 | 2021-05-18 | Lincoln | Maine | 23015 | 1007 | 2 |
1327433 | 1327433 | 2021-05-17 | Lincoln | Maine | 23015 | 1004 | 2 |
1324187 | 1324187 | 2021-05-16 | Lincoln | Maine | 23015 | 996 | 2 |
1320941 | 1320941 | 2021-05-15 | Lincoln | Maine | 23015 | 997 | 2 |
1317694 | 1317694 | 2021-05-14 | Lincoln | Maine | 23015 | 994 | 2 |
1314447 | 1314447 | 2021-05-13 | Lincoln | Maine | 23015 | 986 | 2 |
1311200 | 1311200 | 2021-05-12 | Lincoln | Maine | 23015 | 980 | 2 |
1307954 | 1307954 | 2021-05-11 | Lincoln | Maine | 23015 | 973 | 2 |
1304708 | 1304708 | 2021-05-10 | Lincoln | Maine | 23015 | 965 | 2 |
1301461 | 1301461 | 2021-05-09 | Lincoln | Maine | 23015 | 962 | 2 |
1298214 | 1298214 | 2021-05-08 | Lincoln | Maine | 23015 | 949 | 2 |
1294968 | 1294968 | 2021-05-07 | Lincoln | Maine | 23015 | 941 | 2 |
1291722 | 1291722 | 2021-05-06 | Lincoln | Maine | 23015 | 923 | 2 |
1288476 | 1288476 | 2021-05-05 | Lincoln | Maine | 23015 | 914 | 2 |
1285230 | 1285230 | 2021-05-04 | Lincoln | Maine | 23015 | 903 | 2 |
1281983 | 1281983 | 2021-05-03 | Lincoln | Maine | 23015 | 889 | 2 |
1278736 | 1278736 | 2021-05-02 | Lincoln | Maine | 23015 | 877 | 2 |
1275489 | 1275489 | 2021-05-01 | Lincoln | Maine | 23015 | 876 | 2 |
1272242 | 1272242 | 2021-04-30 | Lincoln | Maine | 23015 | 863 | 2 |
1268995 | 1268995 | 2021-04-29 | Lincoln | Maine | 23015 | 857 | 2 |
1265748 | 1265748 | 2021-04-28 | Lincoln | Maine | 23015 | 851 | 2 |
1262501 | 1262501 | 2021-04-27 | Lincoln | Maine | 23015 | 826 | 2 |
1259254 | 1259254 | 2021-04-26 | Lincoln | Maine | 23015 | 821 | 2 |
1256007 | 1256007 | 2021-04-25 | Lincoln | Maine | 23015 | 808 | 2 |
1252760 | 1252760 | 2021-04-24 | Lincoln | Maine | 23015 | 806 | 2 |
1249513 | 1249513 | 2021-04-23 | Lincoln | Maine | 23015 | 805 | 2 |
1246266 | 1246266 | 2021-04-22 | Lincoln | Maine | 23015 | 798 | 2 |
1243019 | 1243019 | 2021-04-21 | Lincoln | Maine | 23015 | 792 | 2 |
1239772 | 1239772 | 2021-04-20 | Lincoln | Maine | 23015 | 784 | 2 |
1239946 | 1239946 | 2021-04-20 | Lincoln | Minnesota | 27081 | 561 | 2 |
1236525 | 1236525 | 2021-04-19 | Lincoln | Maine | 23015 | 782 | 2 |
1236699 | 1236699 | 2021-04-19 | Lincoln | Minnesota | 27081 | 560 | 2 |
1233278 | 1233278 | 2021-04-18 | Lincoln | Maine | 23015 | 774 | 2 |
1233452 | 1233452 | 2021-04-18 | Lincoln | Minnesota | 27081 | 559 | 2 |
1230030 | 1230030 | 2021-04-17 | Lincoln | Maine | 23015 | 768 | 2 |
1230204 | 1230204 | 2021-04-17 | Lincoln | Minnesota | 27081 | 559 | 2 |
1226782 | 1226782 | 2021-04-16 | Lincoln | Maine | 23015 | 749 | 2 |
1226956 | 1226956 | 2021-04-16 | Lincoln | Minnesota | 27081 | 557 | 2 |
1223535 | 1223535 | 2021-04-15 | Lincoln | Maine | 23015 | 741 | 2 |
1223708 | 1223708 | 2021-04-15 | Lincoln | Minnesota | 27081 | 557 | 2 |
1220287 | 1220287 | 2021-04-14 | Lincoln | Maine | 23015 | 733 | 2 |
1220461 | 1220461 | 2021-04-14 | Lincoln | Minnesota | 27081 | 556 | 2 |
1217039 | 1217039 | 2021-04-13 | Lincoln | Maine | 23015 | 725 | 2 |
1217213 | 1217213 | 2021-04-13 | Lincoln | Minnesota | 27081 | 555 | 2 |
1213792 | 1213792 | 2021-04-12 | Lincoln | Maine | 23015 | 712 | 2 |
1213966 | 1213966 | 2021-04-12 | Lincoln | Minnesota | 27081 | 554 | 2 |
1210544 | 1210544 | 2021-04-11 | Lincoln | Maine | 23015 | 708 | 2 |
1210718 | 1210718 | 2021-04-11 | Lincoln | Minnesota | 27081 | 553 | 2 |
1207295 | 1207295 | 2021-04-10 | Lincoln | Maine | 23015 | 706 | 2 |
1207469 | 1207469 | 2021-04-10 | Lincoln | Minnesota | 27081 | 553 | 2 |
1204047 | 1204047 | 2021-04-09 | Lincoln | Maine | 23015 | 699 | 2 |
1204221 | 1204221 | 2021-04-09 | Lincoln | Minnesota | 27081 | 550 | 2 |
1200799 | 1200799 | 2021-04-08 | Lincoln | Maine | 23015 | 695 | 2 |
1200973 | 1200973 | 2021-04-08 | Lincoln | Minnesota | 27081 | 550 | 2 |
1197550 | 1197550 | 2021-04-07 | Lincoln | Maine | 23015 | 692 | 2 |
1197724 | 1197724 | 2021-04-07 | Lincoln | Minnesota | 27081 | 547 | 2 |
1194302 | 1194302 | 2021-04-06 | Lincoln | Maine | 23015 | 682 | 2 |
1194475 | 1194475 | 2021-04-06 | Lincoln | Minnesota | 27081 | 547 | 2 |
1191052 | 1191052 | 2021-04-05 | Lincoln | Maine | 23015 | 681 | 2 |
1191226 | 1191226 | 2021-04-05 | Lincoln | Minnesota | 27081 | 547 | 2 |
1191632 | 1191632 | 2021-04-05 | Lincoln | Nevada | 32017 | 354 | 2 |
1187805 | 1187805 | 2021-04-04 | Lincoln | Maine | 23015 | 680 | 2 |
1187978 | 1187978 | 2021-04-04 | Lincoln | Minnesota | 27081 | 546 | 2 |
1188384 | 1188384 | 2021-04-04 | Lincoln | Nevada | 32017 | 354 | 2 |
1184558 | 1184558 | 2021-04-03 | Lincoln | Maine | 23015 | 675 | 2 |
1184731 | 1184731 | 2021-04-03 | Lincoln | Minnesota | 27081 | 546 | 2 |
1185137 | 1185137 | 2021-04-03 | Lincoln | Nevada | 32017 | 354 | 2 |
1181311 | 1181311 | 2021-04-02 | Lincoln | Maine | 23015 | 668 | 2 |
1181485 | 1181485 | 2021-04-02 | Lincoln | Minnesota | 27081 | 544 | 2 |
1181890 | 1181890 | 2021-04-02 | Lincoln | Nevada | 32017 | 354 | 2 |
1178064 | 1178064 | 2021-04-01 | Lincoln | Maine | 23015 | 661 | 2 |
1178238 | 1178238 | 2021-04-01 | Lincoln | Minnesota | 27081 | 541 | 2 |
1178643 | 1178643 | 2021-04-01 | Lincoln | Nevada | 32017 | 354 | 2 |
1174817 | 1174817 | 2021-03-31 | Lincoln | Maine | 23015 | 657 | 2 |
1174991 | 1174991 | 2021-03-31 | Lincoln | Minnesota | 27081 | 535 | 2 |
1175396 | 1175396 | 2021-03-31 | Lincoln | Nevada | 32017 | 354 | 2 |
1171570 | 1171570 | 2021-03-30 | Lincoln | Maine | 23015 | 653 | 2 |
1171744 | 1171744 | 2021-03-30 | Lincoln | Minnesota | 27081 | 535 | 2 |
1172149 | 1172149 | 2021-03-30 | Lincoln | Nevada | 32017 | 354 | 2 |
1168322 | 1168322 | 2021-03-29 | Lincoln | Maine | 23015 | 651 | 2 |
1168496 | 1168496 | 2021-03-29 | Lincoln | Minnesota | 27081 | 534 | 2 |
1168901 | 1168901 | 2021-03-29 | Lincoln | Nevada | 32017 | 354 | 2 |
1165074 | 1165074 | 2021-03-28 | Lincoln | Maine | 23015 | 647 | 2 |
1165248 | 1165248 | 2021-03-28 | Lincoln | Minnesota | 27081 | 534 | 2 |
1165653 | 1165653 | 2021-03-28 | Lincoln | Nevada | 32017 | 354 | 2 |
1161826 | 1161826 | 2021-03-27 | Lincoln | Maine | 23015 | 647 | 2 |
1162000 | 1162000 | 2021-03-27 | Lincoln | Minnesota | 27081 | 532 | 2 |
1162405 | 1162405 | 2021-03-27 | Lincoln | Nevada | 32017 | 354 | 2 |
1158578 | 1158578 | 2021-03-26 | Lincoln | Maine | 23015 | 642 | 2 |
1158752 | 1158752 | 2021-03-26 | Lincoln | Minnesota | 27081 | 530 | 2 |
1159157 | 1159157 | 2021-03-26 | Lincoln | Nevada | 32017 | 354 | 2 |
1155331 | 1155331 | 2021-03-25 | Lincoln | Maine | 23015 | 639 | 2 |
1155505 | 1155505 | 2021-03-25 | Lincoln | Minnesota | 27081 | 525 | 2 |
1155910 | 1155910 | 2021-03-25 | Lincoln | Nevada | 32017 | 354 | 2 |
1152084 | 1152084 | 2021-03-24 | Lincoln | Maine | 23015 | 632 | 2 |
1152258 | 1152258 | 2021-03-24 | Lincoln | Minnesota | 27081 | 523 | 2 |
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);