ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
24 rows where county = "Lincoln" and "date" is on date 2021-04-17 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 24
- Arkansas 1
- Colorado 1
- Georgia 1
- Idaho 1
- Kansas 1
- Kentucky 1
- Louisiana 1
- Maine 1
- Minnesota 1
- Mississippi 1
- Missouri 1
- Montana 1
- Nebraska 1
- Nevada 1
- New Mexico 1
- North Carolina 1
- Oklahoma 1
- Oregon 1
- South Dakota 1
- Tennessee 1
- Washington 1
- West Virginia 1
- Wisconsin 1
- Wyoming 1
fips 24
county 1
- Lincoln · 24 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1228986 | 1228986 | 2021-04-17 | Lincoln | Arkansas | 5079 | 3194 | 48 |
1229118 | 1229118 | 2021-04-17 | Lincoln | Colorado | 8073 | 1012 | 4 |
1229316 | 1229316 | 2021-04-17 | Lincoln | Georgia | 13181 | 794 | 26 |
1229424 | 1229424 | 2021-04-17 | Lincoln | Idaho | 16063 | 498 | 11 |
1229784 | 1229784 | 2021-04-17 | Lincoln | Kansas | 20105 | 262 | 4 |
1229906 | 1229906 | 2021-04-17 | Lincoln | Kentucky | 21137 | 2251 | 46 |
1229988 | 1229988 | 2021-04-17 | Lincoln | Louisiana | 22061 | 4409 | 92 |
1230030 | 1230030 | 2021-04-17 | Lincoln | Maine | 23015 | 768 | 2 |
1230204 | 1230204 | 2021-04-17 | Lincoln | Minnesota | 27081 | 559 | 2 |
1230294 | 1230294 | 2021-04-17 | Lincoln | Mississippi | 28085 | 3887 | 109 |
1230392 | 1230392 | 2021-04-17 | Lincoln | Missouri | 29113 | 5625 | 40 |
1230477 | 1230477 | 2021-04-17 | Lincoln | Montana | 30053 | 1599 | 16 |
1230562 | 1230562 | 2021-04-17 | Lincoln | Nebraska | 31111 | 3728 | 53 |
1230610 | 1230610 | 2021-04-17 | Lincoln | Nevada | 32017 | 361 | 3 |
1230665 | 1230665 | 2021-04-17 | Lincoln | New Mexico | 35027 | 1608 | 19 |
1230796 | 1230796 | 2021-04-17 | Lincoln | North Carolina | 37109 | 9585 | 85 |
1231027 | 1231027 | 2021-04-17 | Lincoln | Oklahoma | 40081 | 3198 | 69 |
1231085 | 1231085 | 2021-04-17 | Lincoln | Oregon | 41041 | 1298 | 20 |
1231339 | 1231339 | 2021-04-17 | Lincoln | South Dakota | 46083 | 8494 | 77 |
1231416 | 1231416 | 2021-04-17 | Lincoln | Tennessee | 47103 | 4295 | 63 |
1231917 | 1231917 | 2021-04-17 | Lincoln | Washington | 53043 | 416 | 6 |
1231956 | 1231956 | 2021-04-17 | Lincoln | West Virginia | 54043 | 1396 | 22 |
1232024 | 1232024 | 2021-04-17 | Lincoln | Wisconsin | 55069 | 3234 | 88 |
1232073 | 1232073 | 2021-04-17 | Lincoln | Wyoming | 56023 | 1386 | 12 |
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);