ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
771 rows where county = "Washington" and fips = 23029 sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
29328 | 29328 | 2020-04-03 | Washington | Maine | 23029 | 1 | 0 |
31706 | 31706 | 2020-04-04 | Washington | Maine | 23029 | 1 | 0 |
34131 | 34131 | 2020-04-05 | Washington | Maine | 23029 | 1 | 0 |
36590 | 36590 | 2020-04-06 | Washington | Maine | 23029 | 1 | 0 |
39098 | 39098 | 2020-04-07 | Washington | Maine | 23029 | 1 | 0 |
41650 | 41650 | 2020-04-08 | Washington | Maine | 23029 | 1 | 0 |
44226 | 44226 | 2020-04-09 | Washington | Maine | 23029 | 1 | 0 |
46834 | 46834 | 2020-04-10 | Washington | Maine | 23029 | 1 | 0 |
49476 | 49476 | 2020-04-11 | Washington | Maine | 23029 | 1 | 0 |
52146 | 52146 | 2020-04-12 | Washington | Maine | 23029 | 1 | 0 |
54827 | 54827 | 2020-04-13 | Washington | Maine | 23029 | 1 | 0 |
57525 | 57525 | 2020-04-14 | Washington | Maine | 23029 | 1 | 0 |
60233 | 60233 | 2020-04-15 | Washington | Maine | 23029 | 2 | 0 |
62954 | 62954 | 2020-04-16 | Washington | Maine | 23029 | 2 | 0 |
65692 | 65692 | 2020-04-17 | Washington | Maine | 23029 | 2 | 0 |
68442 | 68442 | 2020-04-18 | Washington | Maine | 23029 | 2 | 0 |
71206 | 71206 | 2020-04-19 | Washington | Maine | 23029 | 2 | 0 |
73978 | 73978 | 2020-04-20 | Washington | Maine | 23029 | 2 | 0 |
76758 | 76758 | 2020-04-21 | Washington | Maine | 23029 | 2 | 0 |
79544 | 79544 | 2020-04-22 | Washington | Maine | 23029 | 2 | 0 |
82339 | 82339 | 2020-04-23 | Washington | Maine | 23029 | 2 | 0 |
85143 | 85143 | 2020-04-24 | Washington | Maine | 23029 | 2 | 0 |
87953 | 87953 | 2020-04-25 | Washington | Maine | 23029 | 2 | 0 |
90769 | 90769 | 2020-04-26 | Washington | Maine | 23029 | 2 | 0 |
93590 | 93590 | 2020-04-27 | Washington | Maine | 23029 | 2 | 0 |
96425 | 96425 | 2020-04-28 | Washington | Maine | 23029 | 2 | 0 |
99271 | 99271 | 2020-04-29 | Washington | Maine | 23029 | 2 | 0 |
102123 | 102123 | 2020-04-30 | Washington | Maine | 23029 | 2 | 0 |
104983 | 104983 | 2020-05-01 | Washington | Maine | 23029 | 2 | 0 |
107847 | 107847 | 2020-05-02 | Washington | Maine | 23029 | 2 | 0 |
110719 | 110719 | 2020-05-03 | Washington | Maine | 23029 | 2 | 0 |
113597 | 113597 | 2020-05-04 | Washington | Maine | 23029 | 2 | 0 |
116478 | 116478 | 2020-05-05 | Washington | Maine | 23029 | 2 | 0 |
119439 | 119439 | 2020-05-06 | Washington | Maine | 23029 | 2 | 0 |
122411 | 122411 | 2020-05-07 | Washington | Maine | 23029 | 2 | 0 |
125393 | 125393 | 2020-05-08 | Washington | Maine | 23029 | 2 | 0 |
128380 | 128380 | 2020-05-09 | Washington | Maine | 23029 | 2 | 0 |
131370 | 131370 | 2020-05-10 | Washington | Maine | 23029 | 2 | 0 |
134361 | 134361 | 2020-05-11 | Washington | Maine | 23029 | 2 | 0 |
137351 | 137351 | 2020-05-12 | Washington | Maine | 23029 | 2 | 0 |
140345 | 140345 | 2020-05-13 | Washington | Maine | 23029 | 2 | 0 |
143340 | 143340 | 2020-05-14 | Washington | Maine | 23029 | 2 | 0 |
146340 | 146340 | 2020-05-15 | Washington | Maine | 23029 | 2 | 0 |
149345 | 149345 | 2020-05-16 | Washington | Maine | 23029 | 2 | 0 |
152356 | 152356 | 2020-05-17 | Washington | Maine | 23029 | 2 | 0 |
155370 | 155370 | 2020-05-18 | Washington | Maine | 23029 | 2 | 0 |
158388 | 158388 | 2020-05-19 | Washington | Maine | 23029 | 2 | 0 |
161414 | 161414 | 2020-05-20 | Washington | Maine | 23029 | 2 | 0 |
164443 | 164443 | 2020-05-21 | Washington | Maine | 23029 | 2 | 0 |
167479 | 167479 | 2020-05-22 | Washington | Maine | 23029 | 2 | 0 |
170516 | 170516 | 2020-05-23 | Washington | Maine | 23029 | 2 | 0 |
173558 | 173558 | 2020-05-24 | Washington | Maine | 23029 | 2 | 0 |
176601 | 176601 | 2020-05-25 | Washington | Maine | 23029 | 2 | 0 |
179645 | 179645 | 2020-05-26 | Washington | Maine | 23029 | 2 | 0 |
182691 | 182691 | 2020-05-27 | Washington | Maine | 23029 | 2 | 0 |
185746 | 185746 | 2020-05-28 | Washington | Maine | 23029 | 2 | 0 |
188804 | 188804 | 2020-05-29 | Washington | Maine | 23029 | 2 | 0 |
191868 | 191868 | 2020-05-30 | Washington | Maine | 23029 | 2 | 0 |
194936 | 194936 | 2020-05-31 | Washington | Maine | 23029 | 2 | 0 |
198007 | 198007 | 2020-06-01 | Washington | Maine | 23029 | 2 | 0 |
201079 | 201079 | 2020-06-02 | Washington | Maine | 23029 | 1 | 0 |
204156 | 204156 | 2020-06-03 | Washington | Maine | 23029 | 1 | 0 |
207237 | 207237 | 2020-06-04 | Washington | Maine | 23029 | 1 | 0 |
210318 | 210318 | 2020-06-05 | Washington | Maine | 23029 | 1 | 0 |
213402 | 213402 | 2020-06-06 | Washington | Maine | 23029 | 1 | 0 |
216490 | 216490 | 2020-06-07 | Washington | Maine | 23029 | 1 | 0 |
219582 | 219582 | 2020-06-08 | Washington | Maine | 23029 | 1 | 0 |
222677 | 222677 | 2020-06-09 | Washington | Maine | 23029 | 1 | 0 |
225773 | 225773 | 2020-06-10 | Washington | Maine | 23029 | 1 | 0 |
228875 | 228875 | 2020-06-11 | Washington | Maine | 23029 | 1 | 0 |
231979 | 231979 | 2020-06-12 | Washington | Maine | 23029 | 1 | 0 |
235084 | 235084 | 2020-06-13 | Washington | Maine | 23029 | 1 | 0 |
238191 | 238191 | 2020-06-14 | Washington | Maine | 23029 | 1 | 0 |
241300 | 241300 | 2020-06-15 | Washington | Maine | 23029 | 1 | 0 |
244411 | 244411 | 2020-06-16 | Washington | Maine | 23029 | 1 | 0 |
247524 | 247524 | 2020-06-17 | Washington | Maine | 23029 | 1 | 0 |
250636 | 250636 | 2020-06-18 | Washington | Maine | 23029 | 2 | 0 |
253751 | 253751 | 2020-06-19 | Washington | Maine | 23029 | 2 | 0 |
256871 | 256871 | 2020-06-20 | Washington | Maine | 23029 | 2 | 0 |
259997 | 259997 | 2020-06-21 | Washington | Maine | 23029 | 2 | 0 |
263126 | 263126 | 2020-06-22 | Washington | Maine | 23029 | 2 | 0 |
266252 | 266252 | 2020-06-23 | Washington | Maine | 23029 | 2 | 0 |
269385 | 269385 | 2020-06-24 | Washington | Maine | 23029 | 2 | 0 |
272522 | 272522 | 2020-06-25 | Washington | Maine | 23029 | 2 | 0 |
275665 | 275665 | 2020-06-26 | Washington | Maine | 23029 | 2 | 0 |
278813 | 278813 | 2020-06-27 | Washington | Maine | 23029 | 2 | 0 |
281961 | 281961 | 2020-06-28 | Washington | Maine | 23029 | 2 | 0 |
285106 | 285106 | 2020-06-29 | Washington | Maine | 23029 | 2 | 0 |
288256 | 288256 | 2020-06-30 | Washington | Maine | 23029 | 2 | 0 |
291407 | 291407 | 2020-07-01 | Washington | Maine | 23029 | 3 | 0 |
294561 | 294561 | 2020-07-02 | Washington | Maine | 23029 | 3 | 0 |
297719 | 297719 | 2020-07-03 | Washington | Maine | 23029 | 3 | 0 |
300881 | 300881 | 2020-07-04 | Washington | Maine | 23029 | 3 | 0 |
304045 | 304045 | 2020-07-05 | Washington | Maine | 23029 | 3 | 0 |
307212 | 307212 | 2020-07-06 | Washington | Maine | 23029 | 3 | 0 |
310380 | 310380 | 2020-07-07 | Washington | Maine | 23029 | 4 | 0 |
313550 | 313550 | 2020-07-08 | Washington | Maine | 23029 | 5 | 0 |
316724 | 316724 | 2020-07-09 | Washington | Maine | 23029 | 5 | 0 |
319899 | 319899 | 2020-07-10 | Washington | Maine | 23029 | 5 | 0 |
323078 | 323078 | 2020-07-11 | Washington | Maine | 23029 | 5 | 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);