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)
state 24
- Maine 777
- Minnesota 777
- Mississippi 777
- Missouri 777
- Montana 777
- Nebraska 777
- North Carolina 777
- Oklahoma 777
- Oregon 777
- South Dakota 777
- Tennessee 777
- Washington 777
- Arkansas 776
- Colorado 776
- Georgia 776
- Idaho 776
- Louisiana 776
- Kentucky 772
- Wyoming 771
- New Mexico 770
- West Virginia 760
- Wisconsin 743
- Nevada 736
- Kansas 673
fips 24
county 1
- Lincoln · 18,429 ✖
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
16536 | 16536 | 2020-03-28 | Lincoln | Maine | 23015 | 5 | 0 |
16659 | 16659 | 2020-03-28 | Lincoln | Minnesota | 27081 | 1 | 0 |
16715 | 16715 | 2020-03-28 | Lincoln | Mississippi | 28085 | 8 | 0 |
16781 | 16781 | 2020-03-28 | Lincoln | Missouri | 29113 | 2 | 0 |
16814 | 16814 | 2020-03-28 | Lincoln | Montana | 30053 | 3 | 1 |
16835 | 16835 | 2020-03-28 | Lincoln | Nebraska | 31111 | 3 | 0 |
16988 | 16988 | 2020-03-28 | Lincoln | North Carolina | 37109 | 1 | 0 |
17120 | 17120 | 2020-03-28 | Lincoln | Oklahoma | 40081 | 3 | 0 |
17153 | 17153 | 2020-03-28 | Lincoln | Oregon | 41041 | 1 | 0 |
17282 | 17282 | 2020-03-28 | Lincoln | South Dakota | 46083 | 3 | 0 |
17325 | 17325 | 2020-03-28 | Lincoln | Tennessee | 47103 | 1 | 0 |
17592 | 17592 | 2020-03-28 | Lincoln | Washington | 53043 | 1 | 0 |
17792 | 17792 | 2020-03-29 | Lincoln | Arkansas | 5079 | 6 | 0 |
17887 | 17887 | 2020-03-29 | Lincoln | Colorado | 8073 | 1 | 0 |
18038 | 18038 | 2020-03-29 | Lincoln | Georgia | 13181 | 3 | 0 |
18106 | 18106 | 2020-03-29 | Lincoln | Idaho | 16063 | 1 | 0 |
18413 | 18413 | 2020-03-29 | Lincoln | Louisiana | 22061 | 7 | 0 |
18450 | 18450 | 2020-03-29 | Lincoln | Maine | 23015 | 5 | 0 |
18578 | 18578 | 2020-03-29 | Lincoln | Minnesota | 27081 | 1 | 0 |
18637 | 18637 | 2020-03-29 | Lincoln | Mississippi | 28085 | 9 | 0 |
18703 | 18703 | 2020-03-29 | Lincoln | Missouri | 29113 | 2 | 0 |
18737 | 18737 | 2020-03-29 | Lincoln | Montana | 30053 | 4 | 1 |
18758 | 18758 | 2020-03-29 | Lincoln | Nebraska | 31111 | 3 | 0 |
18919 | 18919 | 2020-03-29 | Lincoln | North Carolina | 37109 | 3 | 0 |
19055 | 19055 | 2020-03-29 | Lincoln | Oklahoma | 40081 | 3 | 0 |
19091 | 19091 | 2020-03-29 | Lincoln | Oregon | 41041 | 1 | 0 |
19225 | 19225 | 2020-03-29 | Lincoln | South Dakota | 46083 | 4 | 0 |
19273 | 19273 | 2020-03-29 | Lincoln | Tennessee | 47103 | 1 | 0 |
19557 | 19557 | 2020-03-29 | Lincoln | Washington | 53043 | 1 | 0 |
19766 | 19766 | 2020-03-30 | Lincoln | Arkansas | 5079 | 6 | 0 |
19865 | 19865 | 2020-03-30 | Lincoln | Colorado | 8073 | 1 | 0 |
20030 | 20030 | 2020-03-30 | Lincoln | Georgia | 13181 | 4 | 0 |
20105 | 20105 | 2020-03-30 | Lincoln | Idaho | 16063 | 1 | 0 |
20429 | 20429 | 2020-03-30 | Lincoln | Louisiana | 22061 | 8 | 0 |
20466 | 20466 | 2020-03-30 | Lincoln | Maine | 23015 | 8 | 0 |
20599 | 20599 | 2020-03-30 | Lincoln | Minnesota | 27081 | 1 | 0 |
20661 | 20661 | 2020-03-30 | Lincoln | Mississippi | 28085 | 11 | 0 |
20729 | 20729 | 2020-03-30 | Lincoln | Missouri | 29113 | 5 | 0 |
20772 | 20772 | 2020-03-30 | Lincoln | Montana | 30053 | 4 | 1 |
20794 | 20794 | 2020-03-30 | Lincoln | Nebraska | 31111 | 5 | 1 |
20959 | 20959 | 2020-03-30 | Lincoln | North Carolina | 37109 | 3 | 0 |
21104 | 21104 | 2020-03-30 | Lincoln | Oklahoma | 40081 | 4 | 0 |
21141 | 21141 | 2020-03-30 | Lincoln | Oregon | 41041 | 1 | 0 |
21277 | 21277 | 2020-03-30 | Lincoln | South Dakota | 46083 | 4 | 0 |
21329 | 21329 | 2020-03-30 | Lincoln | Tennessee | 47103 | 1 | 0 |
21624 | 21624 | 2020-03-30 | Lincoln | Washington | 53043 | 1 | 0 |
21838 | 21838 | 2020-03-31 | Lincoln | Arkansas | 5079 | 6 | 0 |
21941 | 21941 | 2020-03-31 | Lincoln | Colorado | 8073 | 1 | 0 |
22111 | 22111 | 2020-03-31 | Lincoln | Georgia | 13181 | 4 | 0 |
22196 | 22196 | 2020-03-31 | Lincoln | Idaho | 16063 | 2 | 0 |
22537 | 22537 | 2020-03-31 | Lincoln | Louisiana | 22061 | 12 | 0 |
22575 | 22575 | 2020-03-31 | Lincoln | Maine | 23015 | 8 | 0 |
22713 | 22713 | 2020-03-31 | Lincoln | Minnesota | 27081 | 1 | 0 |
22778 | 22778 | 2020-03-31 | Lincoln | Mississippi | 28085 | 11 | 0 |
22848 | 22848 | 2020-03-31 | Lincoln | Missouri | 29113 | 7 | 0 |
22893 | 22893 | 2020-03-31 | Lincoln | Montana | 30053 | 5 | 1 |
22918 | 22918 | 2020-03-31 | Lincoln | Nebraska | 31111 | 5 | 1 |
23085 | 23085 | 2020-03-31 | Lincoln | North Carolina | 37109 | 4 | 0 |
23237 | 23237 | 2020-03-31 | Lincoln | Oklahoma | 40081 | 5 | 0 |
23274 | 23274 | 2020-03-31 | Lincoln | Oregon | 41041 | 2 | 0 |
23415 | 23415 | 2020-03-31 | Lincoln | South Dakota | 46083 | 5 | 0 |
23468 | 23468 | 2020-03-31 | Lincoln | Tennessee | 47103 | 1 | 0 |
23773 | 23773 | 2020-03-31 | Lincoln | Washington | 53043 | 1 | 0 |
23996 | 23996 | 2020-04-01 | Lincoln | Arkansas | 5079 | 6 | 0 |
24100 | 24100 | 2020-04-01 | Lincoln | Colorado | 8073 | 1 | 0 |
24275 | 24275 | 2020-04-01 | Lincoln | Georgia | 13181 | 4 | 0 |
24364 | 24364 | 2020-04-01 | Lincoln | Idaho | 16063 | 5 | 0 |
24713 | 24713 | 2020-04-01 | Lincoln | Louisiana | 22061 | 13 | 0 |
24752 | 24752 | 2020-04-01 | Lincoln | Maine | 23015 | 8 | 0 |
24895 | 24895 | 2020-04-01 | Lincoln | Minnesota | 27081 | 1 | 0 |
24962 | 24962 | 2020-04-01 | Lincoln | Mississippi | 28085 | 13 | 0 |
25036 | 25036 | 2020-04-01 | Lincoln | Missouri | 29113 | 10 | 0 |
25082 | 25082 | 2020-04-01 | Lincoln | Montana | 30053 | 6 | 1 |
25108 | 25108 | 2020-04-01 | Lincoln | Nebraska | 31111 | 9 | 1 |
25279 | 25279 | 2020-04-01 | Lincoln | North Carolina | 37109 | 5 | 0 |
25434 | 25434 | 2020-04-01 | Lincoln | Oklahoma | 40081 | 5 | 0 |
25472 | 25472 | 2020-04-01 | Lincoln | Oregon | 41041 | 3 | 0 |
25613 | 25613 | 2020-04-01 | Lincoln | South Dakota | 46083 | 11 | 0 |
25670 | 25670 | 2020-04-01 | Lincoln | Tennessee | 47103 | 2 | 0 |
25991 | 25991 | 2020-04-01 | Lincoln | Washington | 53043 | 1 | 0 |
26220 | 26220 | 2020-04-02 | Lincoln | Arkansas | 5079 | 6 | 0 |
26330 | 26330 | 2020-04-02 | Lincoln | Colorado | 8073 | 1 | 0 |
26506 | 26506 | 2020-04-02 | Lincoln | Georgia | 13181 | 5 | 0 |
26596 | 26596 | 2020-04-02 | Lincoln | Idaho | 16063 | 5 | 0 |
26901 | 26901 | 2020-04-02 | Lincoln | Kentucky | 21137 | 1 | 0 |
26964 | 26964 | 2020-04-02 | Lincoln | Louisiana | 22061 | 13 | 0 |
27003 | 27003 | 2020-04-02 | Lincoln | Maine | 23015 | 8 | 0 |
27149 | 27149 | 2020-04-02 | Lincoln | Minnesota | 27081 | 1 | 0 |
27216 | 27216 | 2020-04-02 | Lincoln | Mississippi | 28085 | 14 | 0 |
27292 | 27292 | 2020-04-02 | Lincoln | Missouri | 29113 | 12 | 0 |
27339 | 27339 | 2020-04-02 | Lincoln | Montana | 30053 | 6 | 1 |
27367 | 27367 | 2020-04-02 | Lincoln | Nebraska | 31111 | 13 | 1 |
27542 | 27542 | 2020-04-02 | Lincoln | North Carolina | 37109 | 8 | 0 |
27706 | 27706 | 2020-04-02 | Lincoln | Oklahoma | 40081 | 6 | 0 |
27744 | 27744 | 2020-04-02 | Lincoln | Oregon | 41041 | 4 | 0 |
27890 | 27890 | 2020-04-02 | Lincoln | South Dakota | 46083 | 17 | 0 |
27949 | 27949 | 2020-04-02 | Lincoln | Tennessee | 47103 | 2 | 0 |
28281 | 28281 | 2020-04-02 | Lincoln | Washington | 53043 | 1 | 0 |
28518 | 28518 | 2020-04-03 | Lincoln | Arkansas | 5079 | 6 | 0 |
28631 | 28631 | 2020-04-03 | Lincoln | Colorado | 8073 | 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);