ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
766 rows where county = "Washington" and state = "Missouri" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
41993 | 41993 | 2020-04-08 | Washington | Missouri | 29221 | 1 | 0 |
44572 | 44572 | 2020-04-09 | Washington | Missouri | 29221 | 1 | 0 |
47181 | 47181 | 2020-04-10 | Washington | Missouri | 29221 | 1 | 0 |
49829 | 49829 | 2020-04-11 | Washington | Missouri | 29221 | 1 | 0 |
52502 | 52502 | 2020-04-12 | Washington | Missouri | 29221 | 1 | 0 |
55183 | 55183 | 2020-04-13 | Washington | Missouri | 29221 | 1 | 0 |
57882 | 57882 | 2020-04-14 | Washington | Missouri | 29221 | 1 | 0 |
60595 | 60595 | 2020-04-15 | Washington | Missouri | 29221 | 2 | 0 |
63318 | 63318 | 2020-04-16 | Washington | Missouri | 29221 | 3 | 0 |
66058 | 66058 | 2020-04-17 | Washington | Missouri | 29221 | 4 | 0 |
68812 | 68812 | 2020-04-18 | Washington | Missouri | 29221 | 4 | 0 |
71579 | 71579 | 2020-04-19 | Washington | Missouri | 29221 | 4 | 0 |
74352 | 74352 | 2020-04-20 | Washington | Missouri | 29221 | 5 | 0 |
77132 | 77132 | 2020-04-21 | Washington | Missouri | 29221 | 6 | 0 |
79920 | 79920 | 2020-04-22 | Washington | Missouri | 29221 | 6 | 0 |
82716 | 82716 | 2020-04-23 | Washington | Missouri | 29221 | 7 | 0 |
85520 | 85520 | 2020-04-24 | Washington | Missouri | 29221 | 8 | 0 |
88330 | 88330 | 2020-04-25 | Washington | Missouri | 29221 | 8 | 1 |
91145 | 91145 | 2020-04-26 | Washington | Missouri | 29221 | 8 | 1 |
93966 | 93966 | 2020-04-27 | Washington | Missouri | 29221 | 8 | 1 |
96802 | 96802 | 2020-04-28 | Washington | Missouri | 29221 | 8 | 1 |
99648 | 99648 | 2020-04-29 | Washington | Missouri | 29221 | 8 | 1 |
102500 | 102500 | 2020-04-30 | Washington | Missouri | 29221 | 8 | 1 |
105361 | 105361 | 2020-05-01 | Washington | Missouri | 29221 | 8 | 1 |
108227 | 108227 | 2020-05-02 | Washington | Missouri | 29221 | 8 | 1 |
111099 | 111099 | 2020-05-03 | Washington | Missouri | 29221 | 8 | 1 |
113978 | 113978 | 2020-05-04 | Washington | Missouri | 29221 | 9 | 1 |
116860 | 116860 | 2020-05-05 | Washington | Missouri | 29221 | 9 | 1 |
119820 | 119820 | 2020-05-06 | Washington | Missouri | 29221 | 9 | 1 |
122794 | 122794 | 2020-05-07 | Washington | Missouri | 29221 | 9 | 1 |
125776 | 125776 | 2020-05-08 | Washington | Missouri | 29221 | 9 | 1 |
128764 | 128764 | 2020-05-09 | Washington | Missouri | 29221 | 9 | 1 |
131754 | 131754 | 2020-05-10 | Washington | Missouri | 29221 | 9 | 1 |
134745 | 134745 | 2020-05-11 | Washington | Missouri | 29221 | 9 | 1 |
137735 | 137735 | 2020-05-12 | Washington | Missouri | 29221 | 9 | 1 |
140729 | 140729 | 2020-05-13 | Washington | Missouri | 29221 | 9 | 1 |
143724 | 143724 | 2020-05-14 | Washington | Missouri | 29221 | 9 | 1 |
146725 | 146725 | 2020-05-15 | Washington | Missouri | 29221 | 9 | 1 |
149731 | 149731 | 2020-05-16 | Washington | Missouri | 29221 | 9 | 1 |
152742 | 152742 | 2020-05-17 | Washington | Missouri | 29221 | 9 | 1 |
155756 | 155756 | 2020-05-18 | Washington | Missouri | 29221 | 9 | 1 |
158774 | 158774 | 2020-05-19 | Washington | Missouri | 29221 | 9 | 1 |
161800 | 161800 | 2020-05-20 | Washington | Missouri | 29221 | 9 | 1 |
164829 | 164829 | 2020-05-21 | Washington | Missouri | 29221 | 10 | 1 |
167865 | 167865 | 2020-05-22 | Washington | Missouri | 29221 | 10 | 1 |
170904 | 170904 | 2020-05-23 | Washington | Missouri | 29221 | 10 | 1 |
173946 | 173946 | 2020-05-24 | Washington | Missouri | 29221 | 10 | 1 |
176989 | 176989 | 2020-05-25 | Washington | Missouri | 29221 | 10 | 1 |
180033 | 180033 | 2020-05-26 | Washington | Missouri | 29221 | 10 | 1 |
183081 | 183081 | 2020-05-27 | Washington | Missouri | 29221 | 10 | 1 |
186137 | 186137 | 2020-05-28 | Washington | Missouri | 29221 | 10 | 1 |
189196 | 189196 | 2020-05-29 | Washington | Missouri | 29221 | 11 | 1 |
192260 | 192260 | 2020-05-30 | Washington | Missouri | 29221 | 11 | 1 |
195330 | 195330 | 2020-05-31 | Washington | Missouri | 29221 | 11 | 1 |
198401 | 198401 | 2020-06-01 | Washington | Missouri | 29221 | 12 | 1 |
201474 | 201474 | 2020-06-02 | Washington | Missouri | 29221 | 12 | 1 |
204551 | 204551 | 2020-06-03 | Washington | Missouri | 29221 | 12 | 1 |
207632 | 207632 | 2020-06-04 | Washington | Missouri | 29221 | 12 | 1 |
210713 | 210713 | 2020-06-05 | Washington | Missouri | 29221 | 12 | 1 |
213797 | 213797 | 2020-06-06 | Washington | Missouri | 29221 | 13 | 1 |
216886 | 216886 | 2020-06-07 | Washington | Missouri | 29221 | 13 | 1 |
219978 | 219978 | 2020-06-08 | Washington | Missouri | 29221 | 13 | 1 |
223073 | 223073 | 2020-06-09 | Washington | Missouri | 29221 | 13 | 1 |
226172 | 226172 | 2020-06-10 | Washington | Missouri | 29221 | 13 | 1 |
229275 | 229275 | 2020-06-11 | Washington | Missouri | 29221 | 13 | 1 |
232379 | 232379 | 2020-06-12 | Washington | Missouri | 29221 | 13 | 1 |
235485 | 235485 | 2020-06-13 | Washington | Missouri | 29221 | 13 | 1 |
238592 | 238592 | 2020-06-14 | Washington | Missouri | 29221 | 13 | 1 |
241702 | 241702 | 2020-06-15 | Washington | Missouri | 29221 | 13 | 1 |
244813 | 244813 | 2020-06-16 | Washington | Missouri | 29221 | 13 | 1 |
247926 | 247926 | 2020-06-17 | Washington | Missouri | 29221 | 13 | 1 |
251039 | 251039 | 2020-06-18 | Washington | Missouri | 29221 | 14 | 1 |
254154 | 254154 | 2020-06-19 | Washington | Missouri | 29221 | 14 | 1 |
257275 | 257275 | 2020-06-20 | Washington | Missouri | 29221 | 14 | 1 |
260401 | 260401 | 2020-06-21 | Washington | Missouri | 29221 | 14 | 1 |
263530 | 263530 | 2020-06-22 | Washington | Missouri | 29221 | 14 | 1 |
266656 | 266656 | 2020-06-23 | Washington | Missouri | 29221 | 15 | 1 |
269789 | 269789 | 2020-06-24 | Washington | Missouri | 29221 | 17 | 1 |
272927 | 272927 | 2020-06-25 | Washington | Missouri | 29221 | 19 | 1 |
276070 | 276070 | 2020-06-26 | Washington | Missouri | 29221 | 21 | 1 |
279218 | 279218 | 2020-06-27 | Washington | Missouri | 29221 | 21 | 1 |
282366 | 282366 | 2020-06-28 | Washington | Missouri | 29221 | 23 | 1 |
285511 | 285511 | 2020-06-29 | Washington | Missouri | 29221 | 23 | 1 |
288661 | 288661 | 2020-06-30 | Washington | Missouri | 29221 | 23 | 1 |
291812 | 291812 | 2020-07-01 | Washington | Missouri | 29221 | 23 | 1 |
294966 | 294966 | 2020-07-02 | Washington | Missouri | 29221 | 23 | 1 |
298124 | 298124 | 2020-07-03 | Washington | Missouri | 29221 | 25 | 1 |
301287 | 301287 | 2020-07-04 | Washington | Missouri | 29221 | 25 | 1 |
304451 | 304451 | 2020-07-05 | Washington | Missouri | 29221 | 25 | 1 |
307618 | 307618 | 2020-07-06 | Washington | Missouri | 29221 | 25 | 1 |
310786 | 310786 | 2020-07-07 | Washington | Missouri | 29221 | 25 | 1 |
313957 | 313957 | 2020-07-08 | Washington | Missouri | 29221 | 26 | 1 |
317131 | 317131 | 2020-07-09 | Washington | Missouri | 29221 | 26 | 1 |
320306 | 320306 | 2020-07-10 | Washington | Missouri | 29221 | 26 | 1 |
323485 | 323485 | 2020-07-11 | Washington | Missouri | 29221 | 26 | 1 |
326668 | 326668 | 2020-07-12 | Washington | Missouri | 29221 | 26 | 1 |
329854 | 329854 | 2020-07-13 | Washington | Missouri | 29221 | 27 | 1 |
333041 | 333041 | 2020-07-14 | Washington | Missouri | 29221 | 27 | 1 |
336234 | 336234 | 2020-07-15 | Washington | Missouri | 29221 | 28 | 1 |
339430 | 339430 | 2020-07-16 | Washington | Missouri | 29221 | 38 | 1 |
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);