ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Lewis" and state = "Washington" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
2719 | 2719 | 2020-03-15 | Lewis | Washington | 53041 | 1 | 0 |
3193 | 3193 | 2020-03-16 | Lewis | Washington | 53041 | 1 | 0 |
3734 | 3734 | 2020-03-17 | Lewis | Washington | 53041 | 1 | 0 |
4369 | 4369 | 2020-03-18 | Lewis | Washington | 53041 | 1 | 0 |
5126 | 5126 | 2020-03-19 | Lewis | Washington | 53041 | 1 | 0 |
6028 | 6028 | 2020-03-20 | Lewis | Washington | 53041 | 2 | 0 |
7059 | 7059 | 2020-03-21 | Lewis | Washington | 53041 | 2 | 0 |
8196 | 8196 | 2020-03-22 | Lewis | Washington | 53041 | 2 | 0 |
9421 | 9421 | 2020-03-23 | Lewis | Washington | 53041 | 2 | 0 |
10770 | 10770 | 2020-03-24 | Lewis | Washington | 53041 | 2 | 0 |
12293 | 12293 | 2020-03-25 | Lewis | Washington | 53041 | 5 | 0 |
13943 | 13943 | 2020-03-26 | Lewis | Washington | 53041 | 5 | 0 |
15711 | 15711 | 2020-03-27 | Lewis | Washington | 53041 | 7 | 0 |
17591 | 17591 | 2020-03-28 | Lewis | Washington | 53041 | 7 | 0 |
19556 | 19556 | 2020-03-29 | Lewis | Washington | 53041 | 10 | 0 |
21623 | 21623 | 2020-03-30 | Lewis | Washington | 53041 | 10 | 0 |
23772 | 23772 | 2020-03-31 | Lewis | Washington | 53041 | 10 | 0 |
25990 | 25990 | 2020-04-01 | Lewis | Washington | 53041 | 10 | 0 |
28280 | 28280 | 2020-04-02 | Lewis | Washington | 53041 | 12 | 0 |
30633 | 30633 | 2020-04-03 | Lewis | Washington | 53041 | 12 | 0 |
33033 | 33033 | 2020-04-04 | Lewis | Washington | 53041 | 12 | 0 |
35471 | 35471 | 2020-04-05 | Lewis | Washington | 53041 | 16 | 0 |
37955 | 37955 | 2020-04-06 | Lewis | Washington | 53041 | 16 | 1 |
40490 | 40490 | 2020-04-07 | Lewis | Washington | 53041 | 16 | 1 |
43059 | 43059 | 2020-04-08 | Lewis | Washington | 53041 | 17 | 2 |
45655 | 45655 | 2020-04-09 | Lewis | Washington | 53041 | 18 | 2 |
48282 | 48282 | 2020-04-10 | Lewis | Washington | 53041 | 18 | 2 |
50940 | 50940 | 2020-04-11 | Lewis | Washington | 53041 | 18 | 2 |
53615 | 53615 | 2020-04-12 | Lewis | Washington | 53041 | 18 | 2 |
56305 | 56305 | 2020-04-13 | Lewis | Washington | 53041 | 17 | 2 |
59011 | 59011 | 2020-04-14 | Lewis | Washington | 53041 | 19 | 2 |
61730 | 61730 | 2020-04-15 | Lewis | Washington | 53041 | 19 | 2 |
64463 | 64463 | 2020-04-16 | Lewis | Washington | 53041 | 19 | 2 |
67211 | 67211 | 2020-04-17 | Lewis | Washington | 53041 | 21 | 2 |
69973 | 69973 | 2020-04-18 | Lewis | Washington | 53041 | 21 | 2 |
72743 | 72743 | 2020-04-19 | Lewis | Washington | 53041 | 21 | 2 |
75519 | 75519 | 2020-04-20 | Lewis | Washington | 53041 | 21 | 2 |
78302 | 78302 | 2020-04-21 | Lewis | Washington | 53041 | 21 | 3 |
81095 | 81095 | 2020-04-22 | Lewis | Washington | 53041 | 22 | 3 |
83896 | 83896 | 2020-04-23 | Lewis | Washington | 53041 | 25 | 3 |
86703 | 86703 | 2020-04-24 | Lewis | Washington | 53041 | 25 | 3 |
89518 | 89518 | 2020-04-25 | Lewis | Washington | 53041 | 29 | 3 |
92335 | 92335 | 2020-04-26 | Lewis | Washington | 53041 | 29 | 3 |
95164 | 95164 | 2020-04-27 | Lewis | Washington | 53041 | 29 | 3 |
98009 | 98009 | 2020-04-28 | Lewis | Washington | 53041 | 29 | 3 |
100859 | 100859 | 2020-04-29 | Lewis | Washington | 53041 | 29 | 3 |
103714 | 103714 | 2020-04-30 | Lewis | Washington | 53041 | 29 | 3 |
106578 | 106578 | 2020-05-01 | Lewis | Washington | 53041 | 29 | 3 |
109447 | 109447 | 2020-05-02 | Lewis | Washington | 53041 | 29 | 3 |
112321 | 112321 | 2020-05-03 | Lewis | Washington | 53041 | 29 | 3 |
115204 | 115204 | 2020-05-04 | Lewis | Washington | 53041 | 29 | 3 |
118163 | 118163 | 2020-05-05 | Lewis | Washington | 53041 | 29 | 3 |
121127 | 121127 | 2020-05-06 | Lewis | Washington | 53041 | 29 | 3 |
124107 | 124107 | 2020-05-07 | Lewis | Washington | 53041 | 30 | 3 |
127092 | 127092 | 2020-05-08 | Lewis | Washington | 53041 | 30 | 3 |
130082 | 130082 | 2020-05-09 | Lewis | Washington | 53041 | 30 | 3 |
133072 | 133072 | 2020-05-10 | Lewis | Washington | 53041 | 30 | 3 |
136062 | 136062 | 2020-05-11 | Lewis | Washington | 53041 | 30 | 3 |
139053 | 139053 | 2020-05-12 | Lewis | Washington | 53041 | 32 | 3 |
142049 | 142049 | 2020-05-13 | Lewis | Washington | 53041 | 32 | 3 |
145046 | 145046 | 2020-05-14 | Lewis | Washington | 53041 | 32 | 3 |
148049 | 148049 | 2020-05-15 | Lewis | Washington | 53041 | 32 | 3 |
151058 | 151058 | 2020-05-16 | Lewis | Washington | 53041 | 34 | 3 |
154069 | 154069 | 2020-05-17 | Lewis | Washington | 53041 | 34 | 3 |
157086 | 157086 | 2020-05-18 | Lewis | Washington | 53041 | 35 | 3 |
160110 | 160110 | 2020-05-19 | Lewis | Washington | 53041 | 35 | 3 |
163138 | 163138 | 2020-05-20 | Lewis | Washington | 53041 | 35 | 3 |
166167 | 166167 | 2020-05-21 | Lewis | Washington | 53041 | 35 | 3 |
169203 | 169203 | 2020-05-22 | Lewis | Washington | 53041 | 35 | 3 |
172244 | 172244 | 2020-05-23 | Lewis | Washington | 53041 | 35 | 3 |
175287 | 175287 | 2020-05-24 | Lewis | Washington | 53041 | 35 | 3 |
178332 | 178332 | 2020-05-25 | Lewis | Washington | 53041 | 35 | 3 |
181376 | 181376 | 2020-05-26 | Lewis | Washington | 53041 | 35 | 3 |
184427 | 184427 | 2020-05-27 | Lewis | Washington | 53041 | 35 | 3 |
187484 | 187484 | 2020-05-28 | Lewis | Washington | 53041 | 35 | 3 |
190548 | 190548 | 2020-05-29 | Lewis | Washington | 53041 | 35 | 3 |
193614 | 193614 | 2020-05-30 | Lewis | Washington | 53041 | 36 | 3 |
196684 | 196684 | 2020-05-31 | Lewis | Washington | 53041 | 37 | 3 |
199757 | 199757 | 2020-06-01 | Lewis | Washington | 53041 | 37 | 3 |
202833 | 202833 | 2020-06-02 | Lewis | Washington | 53041 | 37 | 3 |
205912 | 205912 | 2020-06-03 | Lewis | Washington | 53041 | 37 | 3 |
208994 | 208994 | 2020-06-04 | Lewis | Washington | 53041 | 37 | 3 |
212079 | 212079 | 2020-06-05 | Lewis | Washington | 53041 | 37 | 3 |
215166 | 215166 | 2020-06-06 | Lewis | Washington | 53041 | 37 | 3 |
218256 | 218256 | 2020-06-07 | Lewis | Washington | 53041 | 37 | 3 |
221348 | 221348 | 2020-06-08 | Lewis | Washington | 53041 | 37 | 3 |
224444 | 224444 | 2020-06-09 | Lewis | Washington | 53041 | 37 | 3 |
227544 | 227544 | 2020-06-10 | Lewis | Washington | 53041 | 37 | 3 |
230648 | 230648 | 2020-06-11 | Lewis | Washington | 53041 | 37 | 3 |
233753 | 233753 | 2020-06-12 | Lewis | Washington | 53041 | 38 | 3 |
236860 | 236860 | 2020-06-13 | Lewis | Washington | 53041 | 38 | 3 |
239968 | 239968 | 2020-06-14 | Lewis | Washington | 53041 | 38 | 3 |
243079 | 243079 | 2020-06-15 | Lewis | Washington | 53041 | 39 | 3 |
246192 | 246192 | 2020-06-16 | Lewis | Washington | 53041 | 40 | 3 |
249304 | 249304 | 2020-06-17 | Lewis | Washington | 53041 | 41 | 3 |
252419 | 252419 | 2020-06-18 | Lewis | Washington | 53041 | 43 | 3 |
255538 | 255538 | 2020-06-19 | Lewis | Washington | 53041 | 47 | 3 |
258665 | 258665 | 2020-06-20 | Lewis | Washington | 53041 | 47 | 3 |
261792 | 261792 | 2020-06-21 | Lewis | Washington | 53041 | 49 | 3 |
264921 | 264921 | 2020-06-22 | Lewis | Washington | 53041 | 49 | 3 |
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);