ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Washington" and fips = 21229 sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
16470 | 16470 | 2020-03-28 | Washington | Kentucky | 21229 | 2 | 0 |
18382 | 18382 | 2020-03-29 | Washington | Kentucky | 21229 | 2 | 0 |
20398 | 20398 | 2020-03-30 | Washington | Kentucky | 21229 | 2 | 0 |
22505 | 22505 | 2020-03-31 | Washington | Kentucky | 21229 | 2 | 0 |
24681 | 24681 | 2020-04-01 | Washington | Kentucky | 21229 | 2 | 0 |
26931 | 26931 | 2020-04-02 | Washington | Kentucky | 21229 | 2 | 0 |
29248 | 29248 | 2020-04-03 | Washington | Kentucky | 21229 | 2 | 0 |
31626 | 31626 | 2020-04-04 | Washington | Kentucky | 21229 | 3 | 0 |
34051 | 34051 | 2020-04-05 | Washington | Kentucky | 21229 | 3 | 0 |
36509 | 36509 | 2020-04-06 | Washington | Kentucky | 21229 | 3 | 0 |
39016 | 39016 | 2020-04-07 | Washington | Kentucky | 21229 | 3 | 0 |
41567 | 41567 | 2020-04-08 | Washington | Kentucky | 21229 | 3 | 0 |
44143 | 44143 | 2020-04-09 | Washington | Kentucky | 21229 | 3 | 0 |
46751 | 46751 | 2020-04-10 | Washington | Kentucky | 21229 | 3 | 0 |
49392 | 49392 | 2020-04-11 | Washington | Kentucky | 21229 | 3 | 0 |
52062 | 52062 | 2020-04-12 | Washington | Kentucky | 21229 | 3 | 0 |
54743 | 54743 | 2020-04-13 | Washington | Kentucky | 21229 | 3 | 0 |
57441 | 57441 | 2020-04-14 | Washington | Kentucky | 21229 | 3 | 0 |
60149 | 60149 | 2020-04-15 | Washington | Kentucky | 21229 | 3 | 0 |
62870 | 62870 | 2020-04-16 | Washington | Kentucky | 21229 | 3 | 0 |
65609 | 65609 | 2020-04-17 | Washington | Kentucky | 21229 | 3 | 0 |
68358 | 68358 | 2020-04-18 | Washington | Kentucky | 21229 | 3 | 0 |
71121 | 71121 | 2020-04-19 | Washington | Kentucky | 21229 | 3 | 0 |
73893 | 73893 | 2020-04-20 | Washington | Kentucky | 21229 | 3 | 0 |
76673 | 76673 | 2020-04-21 | Washington | Kentucky | 21229 | 3 | 0 |
79459 | 79459 | 2020-04-22 | Washington | Kentucky | 21229 | 3 | 0 |
82255 | 82255 | 2020-04-23 | Washington | Kentucky | 21229 | 4 | 0 |
85059 | 85059 | 2020-04-24 | Washington | Kentucky | 21229 | 4 | 0 |
87868 | 87868 | 2020-04-25 | Washington | Kentucky | 21229 | 5 | 0 |
90684 | 90684 | 2020-04-26 | Washington | Kentucky | 21229 | 5 | 0 |
93505 | 93505 | 2020-04-27 | Washington | Kentucky | 21229 | 5 | 0 |
96340 | 96340 | 2020-04-28 | Washington | Kentucky | 21229 | 5 | 0 |
99186 | 99186 | 2020-04-29 | Washington | Kentucky | 21229 | 5 | 0 |
102038 | 102038 | 2020-04-30 | Washington | Kentucky | 21229 | 5 | 0 |
104899 | 104899 | 2020-05-01 | Washington | Kentucky | 21229 | 5 | 0 |
107763 | 107763 | 2020-05-02 | Washington | Kentucky | 21229 | 5 | 0 |
110635 | 110635 | 2020-05-03 | Washington | Kentucky | 21229 | 5 | 0 |
113512 | 113512 | 2020-05-04 | Washington | Kentucky | 21229 | 5 | 0 |
116394 | 116394 | 2020-05-05 | Washington | Kentucky | 21229 | 5 | 0 |
119355 | 119355 | 2020-05-06 | Washington | Kentucky | 21229 | 5 | 0 |
122326 | 122326 | 2020-05-07 | Washington | Kentucky | 21229 | 5 | 0 |
125308 | 125308 | 2020-05-08 | Washington | Kentucky | 21229 | 5 | 0 |
128295 | 128295 | 2020-05-09 | Washington | Kentucky | 21229 | 5 | 0 |
131285 | 131285 | 2020-05-10 | Washington | Kentucky | 21229 | 5 | 0 |
134276 | 134276 | 2020-05-11 | Washington | Kentucky | 21229 | 5 | 0 |
137266 | 137266 | 2020-05-12 | Washington | Kentucky | 21229 | 5 | 0 |
140260 | 140260 | 2020-05-13 | Washington | Kentucky | 21229 | 5 | 0 |
143255 | 143255 | 2020-05-14 | Washington | Kentucky | 21229 | 5 | 0 |
146255 | 146255 | 2020-05-15 | Washington | Kentucky | 21229 | 5 | 0 |
149260 | 149260 | 2020-05-16 | Washington | Kentucky | 21229 | 6 | 0 |
152271 | 152271 | 2020-05-17 | Washington | Kentucky | 21229 | 6 | 0 |
155285 | 155285 | 2020-05-18 | Washington | Kentucky | 21229 | 6 | 0 |
158302 | 158302 | 2020-05-19 | Washington | Kentucky | 21229 | 6 | 0 |
161328 | 161328 | 2020-05-20 | Washington | Kentucky | 21229 | 6 | 0 |
164357 | 164357 | 2020-05-21 | Washington | Kentucky | 21229 | 6 | 0 |
167393 | 167393 | 2020-05-22 | Washington | Kentucky | 21229 | 6 | 0 |
170431 | 170431 | 2020-05-23 | Washington | Kentucky | 21229 | 6 | 0 |
173472 | 173472 | 2020-05-24 | Washington | Kentucky | 21229 | 6 | 0 |
176516 | 176516 | 2020-05-25 | Washington | Kentucky | 21229 | 6 | 0 |
179560 | 179560 | 2020-05-26 | Washington | Kentucky | 21229 | 6 | 0 |
182605 | 182605 | 2020-05-27 | Washington | Kentucky | 21229 | 6 | 0 |
185660 | 185660 | 2020-05-28 | Washington | Kentucky | 21229 | 6 | 0 |
188718 | 188718 | 2020-05-29 | Washington | Kentucky | 21229 | 6 | 0 |
191782 | 191782 | 2020-05-30 | Washington | Kentucky | 21229 | 6 | 0 |
194850 | 194850 | 2020-05-31 | Washington | Kentucky | 21229 | 6 | 0 |
197921 | 197921 | 2020-06-01 | Washington | Kentucky | 21229 | 6 | 0 |
200993 | 200993 | 2020-06-02 | Washington | Kentucky | 21229 | 6 | 0 |
204070 | 204070 | 2020-06-03 | Washington | Kentucky | 21229 | 7 | 0 |
207151 | 207151 | 2020-06-04 | Washington | Kentucky | 21229 | 7 | 0 |
210232 | 210232 | 2020-06-05 | Washington | Kentucky | 21229 | 8 | 0 |
213317 | 213317 | 2020-06-06 | Washington | Kentucky | 21229 | 8 | 0 |
216404 | 216404 | 2020-06-07 | Washington | Kentucky | 21229 | 8 | 0 |
219496 | 219496 | 2020-06-08 | Washington | Kentucky | 21229 | 8 | 0 |
222591 | 222591 | 2020-06-09 | Washington | Kentucky | 21229 | 8 | 0 |
225687 | 225687 | 2020-06-10 | Washington | Kentucky | 21229 | 8 | 0 |
228789 | 228789 | 2020-06-11 | Washington | Kentucky | 21229 | 8 | 0 |
231893 | 231893 | 2020-06-12 | Washington | Kentucky | 21229 | 10 | 0 |
234998 | 234998 | 2020-06-13 | Washington | Kentucky | 21229 | 14 | 0 |
238105 | 238105 | 2020-06-14 | Washington | Kentucky | 21229 | 14 | 0 |
241214 | 241214 | 2020-06-15 | Washington | Kentucky | 21229 | 14 | 0 |
244325 | 244325 | 2020-06-16 | Washington | Kentucky | 21229 | 14 | 0 |
247438 | 247438 | 2020-06-17 | Washington | Kentucky | 21229 | 15 | 0 |
250550 | 250550 | 2020-06-18 | Washington | Kentucky | 21229 | 17 | 0 |
253665 | 253665 | 2020-06-19 | Washington | Kentucky | 21229 | 17 | 0 |
256785 | 256785 | 2020-06-20 | Washington | Kentucky | 21229 | 18 | 0 |
259911 | 259911 | 2020-06-21 | Washington | Kentucky | 21229 | 18 | 0 |
263040 | 263040 | 2020-06-22 | Washington | Kentucky | 21229 | 21 | 0 |
266167 | 266167 | 2020-06-23 | Washington | Kentucky | 21229 | 21 | 0 |
269300 | 269300 | 2020-06-24 | Washington | Kentucky | 21229 | 21 | 0 |
272436 | 272436 | 2020-06-25 | Washington | Kentucky | 21229 | 21 | 0 |
275579 | 275579 | 2020-06-26 | Washington | Kentucky | 21229 | 21 | 0 |
278727 | 278727 | 2020-06-27 | Washington | Kentucky | 21229 | 22 | 0 |
281875 | 281875 | 2020-06-28 | Washington | Kentucky | 21229 | 22 | 0 |
285021 | 285021 | 2020-06-29 | Washington | Kentucky | 21229 | 23 | 0 |
288170 | 288170 | 2020-06-30 | Washington | Kentucky | 21229 | 23 | 0 |
291321 | 291321 | 2020-07-01 | Washington | Kentucky | 21229 | 24 | 0 |
294475 | 294475 | 2020-07-02 | Washington | Kentucky | 21229 | 24 | 0 |
297633 | 297633 | 2020-07-03 | Washington | Kentucky | 21229 | 25 | 0 |
300795 | 300795 | 2020-07-04 | Washington | Kentucky | 21229 | 25 | 0 |
303959 | 303959 | 2020-07-05 | Washington | Kentucky | 21229 | 25 | 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);