ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
18,529 rows where county = "Lincoln" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 24
- Maine 790
- Washington 790
- Arkansas 789
- Nebraska 787
- North Carolina 787
- Georgia 785
- Mississippi 784
- Louisiana 782
- Tennessee 781
- Oregon 780
- South Dakota 780
- Montana 779
- Oklahoma 779
- Colorado 778
- Minnesota 778
- Missouri 778
- Idaho 777
- Kentucky 772
- Wyoming 771
- New Mexico 770
- West Virginia 760
- Wisconsin 743
- Nevada 736
- Kansas 673
fips 24
county 1
- Lincoln · 18,529 ✖
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2483 | 2483 | 2020-03-15 | Lincoln | Maine | 23015 | 1 | 0 |
2720 | 2720 | 2020-03-15 | Lincoln | Washington | 53043 | 1 | 0 |
2758 | 2758 | 2020-03-16 | Lincoln | Arkansas | 5079 | 1 | 0 |
2929 | 2929 | 2020-03-16 | Lincoln | Maine | 23015 | 2 | 0 |
3194 | 3194 | 2020-03-16 | Lincoln | Washington | 53043 | 1 | 0 |
3238 | 3238 | 2020-03-17 | Lincoln | Arkansas | 5079 | 1 | 0 |
3428 | 3428 | 2020-03-17 | Lincoln | Maine | 23015 | 3 | 0 |
3735 | 3735 | 2020-03-17 | Lincoln | Washington | 53043 | 1 | 0 |
3790 | 3790 | 2020-03-18 | Lincoln | Arkansas | 5079 | 1 | 0 |
4009 | 4009 | 2020-03-18 | Lincoln | Maine | 23015 | 4 | 0 |
4100 | 4100 | 2020-03-18 | Lincoln | Nebraska | 31111 | 1 | 0 |
4181 | 4181 | 2020-03-18 | Lincoln | North Carolina | 37109 | 1 | 0 |
4370 | 4370 | 2020-03-18 | Lincoln | Washington | 53043 | 1 | 0 |
4443 | 4443 | 2020-03-19 | Lincoln | Arkansas | 5079 | 1 | 0 |
4711 | 4711 | 2020-03-19 | Lincoln | Maine | 23015 | 4 | 0 |
4823 | 4823 | 2020-03-19 | Lincoln | Nebraska | 31111 | 3 | 0 |
4912 | 4912 | 2020-03-19 | Lincoln | North Carolina | 37109 | 1 | 0 |
5127 | 5127 | 2020-03-19 | Lincoln | Washington | 53043 | 1 | 0 |
5215 | 5215 | 2020-03-20 | Lincoln | Arkansas | 5079 | 1 | 0 |
5366 | 5366 | 2020-03-20 | Lincoln | Georgia | 13181 | 1 | 0 |
5529 | 5529 | 2020-03-20 | Lincoln | Maine | 23015 | 4 | 0 |
5664 | 5664 | 2020-03-20 | Lincoln | Nebraska | 31111 | 3 | 0 |
5766 | 5766 | 2020-03-20 | Lincoln | North Carolina | 37109 | 1 | 0 |
6029 | 6029 | 2020-03-20 | Lincoln | Washington | 53043 | 1 | 0 |
6134 | 6134 | 2020-03-21 | Lincoln | Arkansas | 5079 | 1 | 0 |
6299 | 6299 | 2020-03-21 | Lincoln | Georgia | 13181 | 1 | 0 |
6484 | 6484 | 2020-03-21 | Lincoln | Maine | 23015 | 4 | 0 |
6600 | 6600 | 2020-03-21 | Lincoln | Mississippi | 28085 | 1 | 0 |
6656 | 6656 | 2020-03-21 | Lincoln | Nebraska | 31111 | 3 | 0 |
6763 | 6763 | 2020-03-21 | Lincoln | North Carolina | 37109 | 1 | 0 |
7060 | 7060 | 2020-03-21 | Lincoln | Washington | 53043 | 1 | 0 |
7168 | 7168 | 2020-03-22 | Lincoln | Arkansas | 5079 | 1 | 0 |
7345 | 7345 | 2020-03-22 | Lincoln | Georgia | 13181 | 1 | 0 |
7559 | 7559 | 2020-03-22 | Lincoln | Maine | 23015 | 4 | 0 |
7683 | 7683 | 2020-03-22 | Lincoln | Mississippi | 28085 | 4 | 0 |
7746 | 7746 | 2020-03-22 | Lincoln | Nebraska | 31111 | 3 | 0 |
7865 | 7865 | 2020-03-22 | Lincoln | North Carolina | 37109 | 1 | 0 |
8197 | 8197 | 2020-03-22 | Lincoln | Washington | 53043 | 1 | 0 |
8311 | 8311 | 2020-03-23 | Lincoln | Arkansas | 5079 | 1 | 0 |
8495 | 8495 | 2020-03-23 | Lincoln | Georgia | 13181 | 1 | 0 |
8703 | 8703 | 2020-03-23 | Lincoln | Louisiana | 22061 | 2 | 0 |
8729 | 8729 | 2020-03-23 | Lincoln | Maine | 23015 | 5 | 0 |
8864 | 8864 | 2020-03-23 | Lincoln | Mississippi | 28085 | 4 | 0 |
8939 | 8939 | 2020-03-23 | Lincoln | Nebraska | 31111 | 3 | 0 |
9066 | 9066 | 2020-03-23 | Lincoln | North Carolina | 37109 | 1 | 0 |
9422 | 9422 | 2020-03-23 | Lincoln | Washington | 53043 | 1 | 0 |
9546 | 9546 | 2020-03-24 | Lincoln | Arkansas | 5079 | 3 | 0 |
9750 | 9750 | 2020-03-24 | Lincoln | Georgia | 13181 | 1 | 0 |
9991 | 9991 | 2020-03-24 | Lincoln | Louisiana | 22061 | 2 | 0 |
10018 | 10018 | 2020-03-24 | Lincoln | Maine | 23015 | 5 | 0 |
10160 | 10160 | 2020-03-24 | Lincoln | Mississippi | 28085 | 4 | 0 |
10242 | 10242 | 2020-03-24 | Lincoln | Nebraska | 31111 | 3 | 0 |
10374 | 10374 | 2020-03-24 | Lincoln | North Carolina | 37109 | 1 | 0 |
10607 | 10607 | 2020-03-24 | Lincoln | Tennessee | 47103 | 1 | 0 |
10771 | 10771 | 2020-03-24 | Lincoln | Washington | 53043 | 1 | 0 |
10917 | 10917 | 2020-03-25 | Lincoln | Arkansas | 5079 | 4 | 0 |
11129 | 11129 | 2020-03-25 | Lincoln | Georgia | 13181 | 1 | 0 |
11397 | 11397 | 2020-03-25 | Lincoln | Louisiana | 22061 | 2 | 0 |
11427 | 11427 | 2020-03-25 | Lincoln | Maine | 23015 | 5 | 0 |
11580 | 11580 | 2020-03-25 | Lincoln | Mississippi | 28085 | 4 | 0 |
11673 | 11673 | 2020-03-25 | Lincoln | Nebraska | 31111 | 3 | 0 |
11817 | 11817 | 2020-03-25 | Lincoln | North Carolina | 37109 | 1 | 0 |
11945 | 11945 | 2020-03-25 | Lincoln | Oregon | 41041 | 1 | 0 |
12052 | 12052 | 2020-03-25 | Lincoln | South Dakota | 46083 | 1 | 0 |
12086 | 12086 | 2020-03-25 | Lincoln | Tennessee | 47103 | 1 | 0 |
12294 | 12294 | 2020-03-25 | Lincoln | Washington | 53043 | 1 | 0 |
12460 | 12460 | 2020-03-26 | Lincoln | Arkansas | 5079 | 5 | 0 |
12680 | 12680 | 2020-03-26 | Lincoln | Georgia | 13181 | 3 | 0 |
12974 | 12974 | 2020-03-26 | Lincoln | Louisiana | 22061 | 3 | 0 |
13008 | 13008 | 2020-03-26 | Lincoln | Maine | 23015 | 5 | 0 |
13173 | 13173 | 2020-03-26 | Lincoln | Mississippi | 28085 | 6 | 0 |
13257 | 13257 | 2020-03-26 | Lincoln | Montana | 30053 | 1 | 0 |
13276 | 13276 | 2020-03-26 | Lincoln | Nebraska | 31111 | 3 | 0 |
13421 | 13421 | 2020-03-26 | Lincoln | North Carolina | 37109 | 1 | 0 |
13531 | 13531 | 2020-03-26 | Lincoln | Oklahoma | 40081 | 1 | 0 |
13561 | 13561 | 2020-03-26 | Lincoln | Oregon | 41041 | 1 | 0 |
13674 | 13674 | 2020-03-26 | Lincoln | South Dakota | 46083 | 2 | 0 |
13710 | 13710 | 2020-03-26 | Lincoln | Tennessee | 47103 | 1 | 0 |
13944 | 13944 | 2020-03-26 | Lincoln | Washington | 53043 | 1 | 0 |
14124 | 14124 | 2020-03-27 | Lincoln | Arkansas | 5079 | 6 | 0 |
14214 | 14214 | 2020-03-27 | Lincoln | Colorado | 8073 | 1 | 0 |
14354 | 14354 | 2020-03-27 | Lincoln | Georgia | 13181 | 3 | 0 |
14681 | 14681 | 2020-03-27 | Lincoln | Louisiana | 22061 | 7 | 0 |
14716 | 14716 | 2020-03-27 | Lincoln | Maine | 23015 | 5 | 0 |
14837 | 14837 | 2020-03-27 | Lincoln | Minnesota | 27081 | 1 | 0 |
14891 | 14891 | 2020-03-27 | Lincoln | Mississippi | 28085 | 6 | 0 |
14957 | 14957 | 2020-03-27 | Lincoln | Missouri | 29113 | 2 | 0 |
14988 | 14988 | 2020-03-27 | Lincoln | Montana | 30053 | 3 | 1 |
15008 | 15008 | 2020-03-27 | Lincoln | Nebraska | 31111 | 3 | 0 |
15156 | 15156 | 2020-03-27 | Lincoln | North Carolina | 37109 | 1 | 0 |
15274 | 15274 | 2020-03-27 | Lincoln | Oklahoma | 40081 | 3 | 0 |
15306 | 15306 | 2020-03-27 | Lincoln | Oregon | 41041 | 1 | 0 |
15424 | 15424 | 2020-03-27 | Lincoln | South Dakota | 46083 | 2 | 0 |
15462 | 15462 | 2020-03-27 | Lincoln | Tennessee | 47103 | 1 | 0 |
15712 | 15712 | 2020-03-27 | Lincoln | Washington | 53043 | 1 | 0 |
15905 | 15905 | 2020-03-28 | Lincoln | Arkansas | 5079 | 6 | 0 |
15997 | 15997 | 2020-03-28 | Lincoln | Colorado | 8073 | 1 | 0 |
16141 | 16141 | 2020-03-28 | Lincoln | Georgia | 13181 | 3 | 0 |
16209 | 16209 | 2020-03-28 | Lincoln | Idaho | 16063 | 1 | 0 |
16501 | 16501 | 2020-03-28 | Lincoln | Louisiana | 22061 | 6 | 0 |
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);