ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Washington" and state = "Iowa" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
3972 | 3972 | 2020-03-18 | Washington | Iowa | 19183 | 1 | 0 |
4653 | 4653 | 2020-03-19 | Washington | Iowa | 19183 | 1 | 0 |
5464 | 5464 | 2020-03-20 | Washington | Iowa | 19183 | 1 | 0 |
6409 | 6409 | 2020-03-21 | Washington | Iowa | 19183 | 2 | 0 |
7475 | 7475 | 2020-03-22 | Washington | Iowa | 19183 | 3 | 0 |
8635 | 8635 | 2020-03-23 | Washington | Iowa | 19183 | 3 | 0 |
9915 | 9915 | 2020-03-24 | Washington | Iowa | 19183 | 4 | 0 |
11312 | 11312 | 2020-03-25 | Washington | Iowa | 19183 | 6 | 0 |
12879 | 12879 | 2020-03-26 | Washington | Iowa | 19183 | 8 | 0 |
14573 | 14573 | 2020-03-27 | Washington | Iowa | 19183 | 11 | 0 |
16380 | 16380 | 2020-03-28 | Washington | Iowa | 19183 | 11 | 0 |
18285 | 18285 | 2020-03-29 | Washington | Iowa | 19183 | 13 | 0 |
20297 | 20297 | 2020-03-30 | Washington | Iowa | 19183 | 18 | 1 |
22393 | 22393 | 2020-03-31 | Washington | Iowa | 19183 | 24 | 1 |
24568 | 24568 | 2020-04-01 | Washington | Iowa | 19183 | 34 | 2 |
26810 | 26810 | 2020-04-02 | Washington | Iowa | 19183 | 36 | 2 |
29124 | 29124 | 2020-04-03 | Washington | Iowa | 19183 | 43 | 2 |
31496 | 31496 | 2020-04-04 | Washington | Iowa | 19183 | 47 | 2 |
36365 | 36365 | 2020-04-06 | Washington | Iowa | 19183 | 52 | 2 |
38866 | 38866 | 2020-04-07 | Washington | Iowa | 19183 | 57 | 2 |
41412 | 41412 | 2020-04-08 | Washington | Iowa | 19183 | 62 | 2 |
43988 | 43988 | 2020-04-09 | Washington | Iowa | 19183 | 65 | 2 |
33909 | 33909 | 2020-04-05 | Washington | Iowa | 19183 | 49 | 3 |
46595 | 46595 | 2020-04-10 | Washington | Iowa | 19183 | 70 | 3 |
49229 | 49229 | 2020-04-11 | Washington | Iowa | 19183 | 79 | 3 |
51893 | 51893 | 2020-04-12 | Washington | Iowa | 19183 | 81 | 4 |
54575 | 54575 | 2020-04-13 | Washington | Iowa | 19183 | 89 | 4 |
57268 | 57268 | 2020-04-14 | Washington | Iowa | 19183 | 95 | 4 |
59976 | 59976 | 2020-04-15 | Washington | Iowa | 19183 | 101 | 4 |
62697 | 62697 | 2020-04-16 | Washington | Iowa | 19183 | 106 | 4 |
65432 | 65432 | 2020-04-17 | Washington | Iowa | 19183 | 109 | 5 |
68181 | 68181 | 2020-04-18 | Washington | Iowa | 19183 | 113 | 5 |
70942 | 70942 | 2020-04-19 | Washington | Iowa | 19183 | 120 | 5 |
73713 | 73713 | 2020-04-20 | Washington | Iowa | 19183 | 123 | 5 |
76493 | 76493 | 2020-04-21 | Washington | Iowa | 19183 | 126 | 5 |
79277 | 79277 | 2020-04-22 | Washington | Iowa | 19183 | 126 | 5 |
82069 | 82069 | 2020-04-23 | Washington | Iowa | 19183 | 126 | 5 |
84870 | 84870 | 2020-04-24 | Washington | Iowa | 19183 | 133 | 5 |
87679 | 87679 | 2020-04-25 | Washington | Iowa | 19183 | 134 | 5 |
90495 | 90495 | 2020-04-26 | Washington | Iowa | 19183 | 134 | 5 |
93316 | 93316 | 2020-04-27 | Washington | Iowa | 19183 | 136 | 6 |
96148 | 96148 | 2020-04-28 | Washington | Iowa | 19183 | 138 | 6 |
98993 | 98993 | 2020-04-29 | Washington | Iowa | 19183 | 139 | 7 |
101844 | 101844 | 2020-04-30 | Washington | Iowa | 19183 | 141 | 7 |
104703 | 104703 | 2020-05-01 | Washington | Iowa | 19183 | 144 | 7 |
107568 | 107568 | 2020-05-02 | Washington | Iowa | 19183 | 145 | 7 |
110439 | 110439 | 2020-05-03 | Washington | Iowa | 19183 | 148 | 7 |
113314 | 113314 | 2020-05-04 | Washington | Iowa | 19183 | 149 | 7 |
116196 | 116196 | 2020-05-05 | Washington | Iowa | 19183 | 149 | 7 |
119157 | 119157 | 2020-05-06 | Washington | Iowa | 19183 | 152 | 7 |
122127 | 122127 | 2020-05-07 | Washington | Iowa | 19183 | 154 | 7 |
125109 | 125109 | 2020-05-08 | Washington | Iowa | 19183 | 155 | 7 |
128096 | 128096 | 2020-05-09 | Washington | Iowa | 19183 | 156 | 7 |
131086 | 131086 | 2020-05-10 | Washington | Iowa | 19183 | 159 | 7 |
134077 | 134077 | 2020-05-11 | Washington | Iowa | 19183 | 162 | 7 |
137067 | 137067 | 2020-05-12 | Washington | Iowa | 19183 | 163 | 7 |
140060 | 140060 | 2020-05-13 | Washington | Iowa | 19183 | 163 | 8 |
143056 | 143056 | 2020-05-14 | Washington | Iowa | 19183 | 163 | 8 |
146056 | 146056 | 2020-05-15 | Washington | Iowa | 19183 | 163 | 8 |
149060 | 149060 | 2020-05-16 | Washington | Iowa | 19183 | 170 | 8 |
152071 | 152071 | 2020-05-17 | Washington | Iowa | 19183 | 172 | 8 |
155083 | 155083 | 2020-05-18 | Washington | Iowa | 19183 | 172 | 8 |
158100 | 158100 | 2020-05-19 | Washington | Iowa | 19183 | 173 | 8 |
161125 | 161125 | 2020-05-20 | Washington | Iowa | 19183 | 173 | 8 |
164154 | 164154 | 2020-05-21 | Washington | Iowa | 19183 | 174 | 8 |
167186 | 167186 | 2020-05-22 | Washington | Iowa | 19183 | 178 | 8 |
170224 | 170224 | 2020-05-23 | Washington | Iowa | 19183 | 178 | 8 |
173265 | 173265 | 2020-05-24 | Washington | Iowa | 19183 | 179 | 8 |
176309 | 176309 | 2020-05-25 | Washington | Iowa | 19183 | 184 | 8 |
179353 | 179353 | 2020-05-26 | Washington | Iowa | 19183 | 185 | 8 |
182398 | 182398 | 2020-05-27 | Washington | Iowa | 19183 | 185 | 8 |
185452 | 185452 | 2020-05-28 | Washington | Iowa | 19183 | 185 | 8 |
188510 | 188510 | 2020-05-29 | Washington | Iowa | 19183 | 187 | 8 |
191574 | 191574 | 2020-05-30 | Washington | Iowa | 19183 | 189 | 8 |
194642 | 194642 | 2020-05-31 | Washington | Iowa | 19183 | 189 | 8 |
197712 | 197712 | 2020-06-01 | Washington | Iowa | 19183 | 190 | 8 |
200784 | 200784 | 2020-06-02 | Washington | Iowa | 19183 | 190 | 8 |
203860 | 203860 | 2020-06-03 | Washington | Iowa | 19183 | 192 | 8 |
206941 | 206941 | 2020-06-04 | Washington | Iowa | 19183 | 195 | 8 |
210022 | 210022 | 2020-06-05 | Washington | Iowa | 19183 | 197 | 8 |
213107 | 213107 | 2020-06-06 | Washington | Iowa | 19183 | 199 | 8 |
216194 | 216194 | 2020-06-07 | Washington | Iowa | 19183 | 200 | 9 |
219286 | 219286 | 2020-06-08 | Washington | Iowa | 19183 | 200 | 9 |
222381 | 222381 | 2020-06-09 | Washington | Iowa | 19183 | 202 | 9 |
225476 | 225476 | 2020-06-10 | Washington | Iowa | 19183 | 205 | 9 |
228578 | 228578 | 2020-06-11 | Washington | Iowa | 19183 | 205 | 9 |
231681 | 231681 | 2020-06-12 | Washington | Iowa | 19183 | 208 | 9 |
234787 | 234787 | 2020-06-13 | Washington | Iowa | 19183 | 208 | 9 |
237894 | 237894 | 2020-06-14 | Washington | Iowa | 19183 | 208 | 9 |
241002 | 241002 | 2020-06-15 | Washington | Iowa | 19183 | 208 | 9 |
244113 | 244113 | 2020-06-16 | Washington | Iowa | 19183 | 208 | 9 |
247226 | 247226 | 2020-06-17 | Washington | Iowa | 19183 | 209 | 9 |
250338 | 250338 | 2020-06-18 | Washington | Iowa | 19183 | 210 | 9 |
253453 | 253453 | 2020-06-19 | Washington | Iowa | 19183 | 210 | 9 |
256573 | 256573 | 2020-06-20 | Washington | Iowa | 19183 | 210 | 9 |
259699 | 259699 | 2020-06-21 | Washington | Iowa | 19183 | 212 | 9 |
262826 | 262826 | 2020-06-22 | Washington | Iowa | 19183 | 214 | 9 |
265954 | 265954 | 2020-06-23 | Washington | Iowa | 19183 | 214 | 9 |
269084 | 269084 | 2020-06-24 | Washington | Iowa | 19183 | 218 | 9 |
272221 | 272221 | 2020-06-25 | Washington | Iowa | 19183 | 217 | 9 |
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);