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 cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-07-10 24
- 2020-07-11 24
- 2020-07-12 24
- 2020-07-13 24
- 2020-07-14 24
- 2020-07-15 24
- 2020-07-16 24
- 2020-07-17 24
- 2020-07-18 24
- 2020-07-19 24
- 2020-07-20 24
- 2020-07-21 24
- 2020-07-22 24
- 2020-07-23 24
- 2020-07-24 24
- 2020-07-25 24
- 2020-07-26 24
- 2020-07-27 24
- 2020-07-28 24
- 2020-07-29 24
- 2020-07-30 24
- 2020-07-31 24
- 2020-08-01 24
- 2020-08-02 24
- 2020-08-03 24
- 2020-08-04 24
- 2020-08-05 24
- 2020-08-06 24
- 2020-08-07 24
- 2020-08-08 24
- …
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 |
3194 | 3194 | 2020-03-16 | Lincoln | Washington | 53043 | 1 | 0 |
3238 | 3238 | 2020-03-17 | Lincoln | Arkansas | 5079 | 1 | 0 |
3735 | 3735 | 2020-03-17 | Lincoln | Washington | 53043 | 1 | 0 |
3790 | 3790 | 2020-03-18 | Lincoln | Arkansas | 5079 | 1 | 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 |
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 |
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 |
6600 | 6600 | 2020-03-21 | Lincoln | Mississippi | 28085 | 1 | 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 |
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 |
9066 | 9066 | 2020-03-23 | Lincoln | North Carolina | 37109 | 1 | 0 |
9422 | 9422 | 2020-03-23 | Lincoln | Washington | 53043 | 1 | 0 |
9750 | 9750 | 2020-03-24 | Lincoln | Georgia | 13181 | 1 | 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 |
11129 | 11129 | 2020-03-25 | Lincoln | Georgia | 13181 | 1 | 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 |
13257 | 13257 | 2020-03-26 | Lincoln | Montana | 30053 | 1 | 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 |
13710 | 13710 | 2020-03-26 | Lincoln | Tennessee | 47103 | 1 | 0 |
13944 | 13944 | 2020-03-26 | Lincoln | Washington | 53043 | 1 | 0 |
14214 | 14214 | 2020-03-27 | Lincoln | Colorado | 8073 | 1 | 0 |
14837 | 14837 | 2020-03-27 | Lincoln | Minnesota | 27081 | 1 | 0 |
15156 | 15156 | 2020-03-27 | Lincoln | North Carolina | 37109 | 1 | 0 |
15306 | 15306 | 2020-03-27 | Lincoln | Oregon | 41041 | 1 | 0 |
15462 | 15462 | 2020-03-27 | Lincoln | Tennessee | 47103 | 1 | 0 |
15712 | 15712 | 2020-03-27 | Lincoln | Washington | 53043 | 1 | 0 |
15997 | 15997 | 2020-03-28 | Lincoln | Colorado | 8073 | 1 | 0 |
16209 | 16209 | 2020-03-28 | Lincoln | Idaho | 16063 | 1 | 0 |
16659 | 16659 | 2020-03-28 | Lincoln | Minnesota | 27081 | 1 | 0 |
16988 | 16988 | 2020-03-28 | Lincoln | North Carolina | 37109 | 1 | 0 |
17153 | 17153 | 2020-03-28 | Lincoln | Oregon | 41041 | 1 | 0 |
17325 | 17325 | 2020-03-28 | Lincoln | Tennessee | 47103 | 1 | 0 |
17592 | 17592 | 2020-03-28 | Lincoln | Washington | 53043 | 1 | 0 |
17887 | 17887 | 2020-03-29 | Lincoln | Colorado | 8073 | 1 | 0 |
18106 | 18106 | 2020-03-29 | Lincoln | Idaho | 16063 | 1 | 0 |
18578 | 18578 | 2020-03-29 | Lincoln | Minnesota | 27081 | 1 | 0 |
19091 | 19091 | 2020-03-29 | Lincoln | Oregon | 41041 | 1 | 0 |
19273 | 19273 | 2020-03-29 | Lincoln | Tennessee | 47103 | 1 | 0 |
19557 | 19557 | 2020-03-29 | Lincoln | Washington | 53043 | 1 | 0 |
19865 | 19865 | 2020-03-30 | Lincoln | Colorado | 8073 | 1 | 0 |
20105 | 20105 | 2020-03-30 | Lincoln | Idaho | 16063 | 1 | 0 |
20599 | 20599 | 2020-03-30 | Lincoln | Minnesota | 27081 | 1 | 0 |
21141 | 21141 | 2020-03-30 | Lincoln | Oregon | 41041 | 1 | 0 |
21329 | 21329 | 2020-03-30 | Lincoln | Tennessee | 47103 | 1 | 0 |
21624 | 21624 | 2020-03-30 | Lincoln | Washington | 53043 | 1 | 0 |
21941 | 21941 | 2020-03-31 | Lincoln | Colorado | 8073 | 1 | 0 |
22713 | 22713 | 2020-03-31 | Lincoln | Minnesota | 27081 | 1 | 0 |
23468 | 23468 | 2020-03-31 | Lincoln | Tennessee | 47103 | 1 | 0 |
23773 | 23773 | 2020-03-31 | Lincoln | Washington | 53043 | 1 | 0 |
24100 | 24100 | 2020-04-01 | Lincoln | Colorado | 8073 | 1 | 0 |
24895 | 24895 | 2020-04-01 | Lincoln | Minnesota | 27081 | 1 | 0 |
25991 | 25991 | 2020-04-01 | Lincoln | Washington | 53043 | 1 | 0 |
26330 | 26330 | 2020-04-02 | Lincoln | Colorado | 8073 | 1 | 0 |
26901 | 26901 | 2020-04-02 | Lincoln | Kentucky | 21137 | 1 | 0 |
27149 | 27149 | 2020-04-02 | Lincoln | Minnesota | 27081 | 1 | 0 |
28281 | 28281 | 2020-04-02 | Lincoln | Washington | 53043 | 1 | 0 |
28631 | 28631 | 2020-04-03 | Lincoln | Colorado | 8073 | 1 | 0 |
29217 | 29217 | 2020-04-03 | Lincoln | Kentucky | 21137 | 1 | 0 |
29468 | 29468 | 2020-04-03 | Lincoln | Minnesota | 27081 | 1 | 0 |
30634 | 30634 | 2020-04-03 | Lincoln | Washington | 53043 | 1 | 0 |
30745 | 30745 | 2020-04-03 | Lincoln | Wyoming | 56023 | 1 | 0 |
30988 | 30988 | 2020-04-04 | Lincoln | Colorado | 8073 | 1 | 0 |
31593 | 31593 | 2020-04-04 | Lincoln | Kentucky | 21137 | 1 | 0 |
31846 | 31846 | 2020-04-04 | Lincoln | Minnesota | 27081 | 1 | 0 |
32135 | 32135 | 2020-04-04 | Lincoln | New Mexico | 35027 | 1 | 0 |
33034 | 33034 | 2020-04-04 | Lincoln | Washington | 53043 | 1 | 0 |
33149 | 33149 | 2020-04-04 | Lincoln | Wyoming | 56023 | 1 | 0 |
33394 | 33394 | 2020-04-05 | Lincoln | Colorado | 8073 | 1 | 0 |
34015 | 34015 | 2020-04-05 | Lincoln | Kentucky | 21137 | 1 | 0 |
34272 | 34272 | 2020-04-05 | Lincoln | Minnesota | 27081 | 1 | 0 |
34566 | 34566 | 2020-04-05 | Lincoln | New Mexico | 35027 | 1 | 0 |
35472 | 35472 | 2020-04-05 | Lincoln | Washington | 53043 | 1 | 0 |
35839 | 35839 | 2020-04-06 | Lincoln | Colorado | 8073 | 1 | 0 |
36473 | 36473 | 2020-04-06 | Lincoln | Kentucky | 21137 | 1 | 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);