ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Lincoln" and fips = 53043 sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2720 | 2720 | 2020-03-15 | Lincoln | Washington | 53043 | 1 | 0 |
3194 | 3194 | 2020-03-16 | Lincoln | Washington | 53043 | 1 | 0 |
3735 | 3735 | 2020-03-17 | Lincoln | Washington | 53043 | 1 | 0 |
4370 | 4370 | 2020-03-18 | Lincoln | Washington | 53043 | 1 | 0 |
5127 | 5127 | 2020-03-19 | Lincoln | Washington | 53043 | 1 | 0 |
6029 | 6029 | 2020-03-20 | Lincoln | Washington | 53043 | 1 | 0 |
7060 | 7060 | 2020-03-21 | Lincoln | Washington | 53043 | 1 | 0 |
8197 | 8197 | 2020-03-22 | Lincoln | Washington | 53043 | 1 | 0 |
9422 | 9422 | 2020-03-23 | Lincoln | Washington | 53043 | 1 | 0 |
10771 | 10771 | 2020-03-24 | Lincoln | Washington | 53043 | 1 | 0 |
12294 | 12294 | 2020-03-25 | Lincoln | Washington | 53043 | 1 | 0 |
13944 | 13944 | 2020-03-26 | Lincoln | Washington | 53043 | 1 | 0 |
15712 | 15712 | 2020-03-27 | Lincoln | Washington | 53043 | 1 | 0 |
17592 | 17592 | 2020-03-28 | Lincoln | Washington | 53043 | 1 | 0 |
19557 | 19557 | 2020-03-29 | Lincoln | Washington | 53043 | 1 | 0 |
21624 | 21624 | 2020-03-30 | Lincoln | Washington | 53043 | 1 | 0 |
23773 | 23773 | 2020-03-31 | Lincoln | Washington | 53043 | 1 | 0 |
25991 | 25991 | 2020-04-01 | Lincoln | Washington | 53043 | 1 | 0 |
28281 | 28281 | 2020-04-02 | Lincoln | Washington | 53043 | 1 | 0 |
30634 | 30634 | 2020-04-03 | Lincoln | Washington | 53043 | 1 | 0 |
33034 | 33034 | 2020-04-04 | Lincoln | Washington | 53043 | 1 | 0 |
35472 | 35472 | 2020-04-05 | Lincoln | Washington | 53043 | 1 | 0 |
37956 | 37956 | 2020-04-06 | Lincoln | Washington | 53043 | 1 | 0 |
40491 | 40491 | 2020-04-07 | Lincoln | Washington | 53043 | 1 | 0 |
43060 | 43060 | 2020-04-08 | Lincoln | Washington | 53043 | 1 | 0 |
45656 | 45656 | 2020-04-09 | Lincoln | Washington | 53043 | 1 | 0 |
48283 | 48283 | 2020-04-10 | Lincoln | Washington | 53043 | 1 | 0 |
50941 | 50941 | 2020-04-11 | Lincoln | Washington | 53043 | 2 | 0 |
53616 | 53616 | 2020-04-12 | Lincoln | Washington | 53043 | 2 | 0 |
56306 | 56306 | 2020-04-13 | Lincoln | Washington | 53043 | 2 | 0 |
59012 | 59012 | 2020-04-14 | Lincoln | Washington | 53043 | 2 | 0 |
61731 | 61731 | 2020-04-15 | Lincoln | Washington | 53043 | 2 | 0 |
64464 | 64464 | 2020-04-16 | Lincoln | Washington | 53043 | 2 | 0 |
67212 | 67212 | 2020-04-17 | Lincoln | Washington | 53043 | 2 | 0 |
69974 | 69974 | 2020-04-18 | Lincoln | Washington | 53043 | 2 | 0 |
72744 | 72744 | 2020-04-19 | Lincoln | Washington | 53043 | 2 | 0 |
75520 | 75520 | 2020-04-20 | Lincoln | Washington | 53043 | 2 | 0 |
78303 | 78303 | 2020-04-21 | Lincoln | Washington | 53043 | 2 | 0 |
81096 | 81096 | 2020-04-22 | Lincoln | Washington | 53043 | 2 | 0 |
83897 | 83897 | 2020-04-23 | Lincoln | Washington | 53043 | 2 | 0 |
86704 | 86704 | 2020-04-24 | Lincoln | Washington | 53043 | 2 | 0 |
89519 | 89519 | 2020-04-25 | Lincoln | Washington | 53043 | 2 | 0 |
92336 | 92336 | 2020-04-26 | Lincoln | Washington | 53043 | 2 | 0 |
95165 | 95165 | 2020-04-27 | Lincoln | Washington | 53043 | 2 | 0 |
98010 | 98010 | 2020-04-28 | Lincoln | Washington | 53043 | 2 | 0 |
100860 | 100860 | 2020-04-29 | Lincoln | Washington | 53043 | 2 | 0 |
103715 | 103715 | 2020-04-30 | Lincoln | Washington | 53043 | 2 | 0 |
106579 | 106579 | 2020-05-01 | Lincoln | Washington | 53043 | 2 | 0 |
109448 | 109448 | 2020-05-02 | Lincoln | Washington | 53043 | 2 | 0 |
112322 | 112322 | 2020-05-03 | Lincoln | Washington | 53043 | 2 | 0 |
115205 | 115205 | 2020-05-04 | Lincoln | Washington | 53043 | 2 | 0 |
118164 | 118164 | 2020-05-05 | Lincoln | Washington | 53043 | 2 | 0 |
121128 | 121128 | 2020-05-06 | Lincoln | Washington | 53043 | 2 | 0 |
124108 | 124108 | 2020-05-07 | Lincoln | Washington | 53043 | 2 | 0 |
127093 | 127093 | 2020-05-08 | Lincoln | Washington | 53043 | 2 | 0 |
130083 | 130083 | 2020-05-09 | Lincoln | Washington | 53043 | 2 | 0 |
133073 | 133073 | 2020-05-10 | Lincoln | Washington | 53043 | 2 | 0 |
136063 | 136063 | 2020-05-11 | Lincoln | Washington | 53043 | 2 | 0 |
139054 | 139054 | 2020-05-12 | Lincoln | Washington | 53043 | 2 | 0 |
142050 | 142050 | 2020-05-13 | Lincoln | Washington | 53043 | 2 | 0 |
145047 | 145047 | 2020-05-14 | Lincoln | Washington | 53043 | 2 | 0 |
148050 | 148050 | 2020-05-15 | Lincoln | Washington | 53043 | 2 | 0 |
151059 | 151059 | 2020-05-16 | Lincoln | Washington | 53043 | 2 | 0 |
154070 | 154070 | 2020-05-17 | Lincoln | Washington | 53043 | 2 | 0 |
157087 | 157087 | 2020-05-18 | Lincoln | Washington | 53043 | 2 | 0 |
160111 | 160111 | 2020-05-19 | Lincoln | Washington | 53043 | 2 | 0 |
163139 | 163139 | 2020-05-20 | Lincoln | Washington | 53043 | 2 | 0 |
166168 | 166168 | 2020-05-21 | Lincoln | Washington | 53043 | 2 | 0 |
169204 | 169204 | 2020-05-22 | Lincoln | Washington | 53043 | 2 | 0 |
172245 | 172245 | 2020-05-23 | Lincoln | Washington | 53043 | 2 | 0 |
175288 | 175288 | 2020-05-24 | Lincoln | Washington | 53043 | 2 | 0 |
178333 | 178333 | 2020-05-25 | Lincoln | Washington | 53043 | 2 | 0 |
181377 | 181377 | 2020-05-26 | Lincoln | Washington | 53043 | 2 | 0 |
184428 | 184428 | 2020-05-27 | Lincoln | Washington | 53043 | 2 | 0 |
187485 | 187485 | 2020-05-28 | Lincoln | Washington | 53043 | 2 | 0 |
190549 | 190549 | 2020-05-29 | Lincoln | Washington | 53043 | 2 | 0 |
193615 | 193615 | 2020-05-30 | Lincoln | Washington | 53043 | 2 | 0 |
196685 | 196685 | 2020-05-31 | Lincoln | Washington | 53043 | 2 | 0 |
199758 | 199758 | 2020-06-01 | Lincoln | Washington | 53043 | 2 | 0 |
202834 | 202834 | 2020-06-02 | Lincoln | Washington | 53043 | 2 | 0 |
205913 | 205913 | 2020-06-03 | Lincoln | Washington | 53043 | 2 | 0 |
208995 | 208995 | 2020-06-04 | Lincoln | Washington | 53043 | 2 | 0 |
212080 | 212080 | 2020-06-05 | Lincoln | Washington | 53043 | 2 | 0 |
215167 | 215167 | 2020-06-06 | Lincoln | Washington | 53043 | 2 | 0 |
218257 | 218257 | 2020-06-07 | Lincoln | Washington | 53043 | 2 | 0 |
221349 | 221349 | 2020-06-08 | Lincoln | Washington | 53043 | 2 | 0 |
224445 | 224445 | 2020-06-09 | Lincoln | Washington | 53043 | 2 | 0 |
227545 | 227545 | 2020-06-10 | Lincoln | Washington | 53043 | 2 | 0 |
230649 | 230649 | 2020-06-11 | Lincoln | Washington | 53043 | 2 | 0 |
233754 | 233754 | 2020-06-12 | Lincoln | Washington | 53043 | 2 | 0 |
236861 | 236861 | 2020-06-13 | Lincoln | Washington | 53043 | 2 | 0 |
239969 | 239969 | 2020-06-14 | Lincoln | Washington | 53043 | 2 | 0 |
243080 | 243080 | 2020-06-15 | Lincoln | Washington | 53043 | 2 | 0 |
246193 | 246193 | 2020-06-16 | Lincoln | Washington | 53043 | 2 | 0 |
249305 | 249305 | 2020-06-17 | Lincoln | Washington | 53043 | 2 | 0 |
252420 | 252420 | 2020-06-18 | Lincoln | Washington | 53043 | 2 | 0 |
255539 | 255539 | 2020-06-19 | Lincoln | Washington | 53043 | 2 | 0 |
258666 | 258666 | 2020-06-20 | Lincoln | Washington | 53043 | 2 | 0 |
261793 | 261793 | 2020-06-21 | Lincoln | Washington | 53043 | 2 | 0 |
264922 | 264922 | 2020-06-22 | Lincoln | Washington | 53043 | 2 | 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);