ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Taney" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387537 | 387537 | 2020-07-31 | Taney | Missouri | 29213 | 391 | 3 |
384319 | 384319 | 2020-07-30 | Taney | Missouri | 29213 | 374 | 3 |
381103 | 381103 | 2020-07-29 | Taney | Missouri | 29213 | 304 | 3 |
377886 | 377886 | 2020-07-28 | Taney | Missouri | 29213 | 284 | 3 |
374671 | 374671 | 2020-07-27 | Taney | Missouri | 29213 | 267 | 3 |
371459 | 371459 | 2020-07-26 | Taney | Missouri | 29213 | 249 | 3 |
368248 | 368248 | 2020-07-25 | Taney | Missouri | 29213 | 237 | 3 |
365040 | 365040 | 2020-07-24 | Taney | Missouri | 29213 | 226 | 3 |
361833 | 361833 | 2020-07-23 | Taney | Missouri | 29213 | 212 | 3 |
358628 | 358628 | 2020-07-22 | Taney | Missouri | 29213 | 205 | 3 |
355425 | 355425 | 2020-07-21 | Taney | Missouri | 29213 | 184 | 3 |
352223 | 352223 | 2020-07-20 | Taney | Missouri | 29213 | 178 | 3 |
349023 | 349023 | 2020-07-19 | Taney | Missouri | 29213 | 174 | 3 |
345822 | 345822 | 2020-07-18 | Taney | Missouri | 29213 | 166 | 3 |
342622 | 342622 | 2020-07-17 | Taney | Missouri | 29213 | 155 | 3 |
339426 | 339426 | 2020-07-16 | Taney | Missouri | 29213 | 147 | 3 |
336230 | 336230 | 2020-07-15 | Taney | Missouri | 29213 | 142 | 3 |
333037 | 333037 | 2020-07-14 | Taney | Missouri | 29213 | 135 | 3 |
329850 | 329850 | 2020-07-13 | Taney | Missouri | 29213 | 126 | 3 |
326664 | 326664 | 2020-07-12 | Taney | Missouri | 29213 | 123 | 3 |
323481 | 323481 | 2020-07-11 | Taney | Missouri | 29213 | 123 | 3 |
320302 | 320302 | 2020-07-10 | Taney | Missouri | 29213 | 122 | 2 |
317127 | 317127 | 2020-07-09 | Taney | Missouri | 29213 | 119 | 2 |
313953 | 313953 | 2020-07-08 | Taney | Missouri | 29213 | 112 | 2 |
310782 | 310782 | 2020-07-07 | Taney | Missouri | 29213 | 105 | 2 |
307614 | 307614 | 2020-07-06 | Taney | Missouri | 29213 | 96 | 2 |
304447 | 304447 | 2020-07-05 | Taney | Missouri | 29213 | 84 | 2 |
301283 | 301283 | 2020-07-04 | Taney | Missouri | 29213 | 83 | 2 |
298120 | 298120 | 2020-07-03 | Taney | Missouri | 29213 | 74 | 2 |
294962 | 294962 | 2020-07-02 | Taney | Missouri | 29213 | 67 | 2 |
291808 | 291808 | 2020-07-01 | Taney | Missouri | 29213 | 63 | 2 |
288657 | 288657 | 2020-06-30 | Taney | Missouri | 29213 | 60 | 2 |
285507 | 285507 | 2020-06-29 | Taney | Missouri | 29213 | 60 | 2 |
282362 | 282362 | 2020-06-28 | Taney | Missouri | 29213 | 56 | 2 |
279214 | 279214 | 2020-06-27 | Taney | Missouri | 29213 | 48 | 2 |
276066 | 276066 | 2020-06-26 | Taney | Missouri | 29213 | 40 | 2 |
272923 | 272923 | 2020-06-25 | Taney | Missouri | 29213 | 39 | 2 |
269784 | 269784 | 2020-06-24 | Taney | Missouri | 29213 | 35 | 2 |
266651 | 266651 | 2020-06-23 | Taney | Missouri | 29213 | 34 | 2 |
263525 | 263525 | 2020-06-22 | Taney | Missouri | 29213 | 32 | 2 |
260397 | 260397 | 2020-06-21 | Taney | Missouri | 29213 | 30 | 2 |
257271 | 257271 | 2020-06-20 | Taney | Missouri | 29213 | 30 | 2 |
254150 | 254150 | 2020-06-19 | Taney | Missouri | 29213 | 30 | 2 |
251035 | 251035 | 2020-06-18 | Taney | Missouri | 29213 | 29 | 2 |
247922 | 247922 | 2020-06-17 | Taney | Missouri | 29213 | 27 | 2 |
244809 | 244809 | 2020-06-16 | Taney | Missouri | 29213 | 26 | 2 |
241698 | 241698 | 2020-06-15 | Taney | Missouri | 29213 | 24 | 2 |
238588 | 238588 | 2020-06-14 | Taney | Missouri | 29213 | 15 | 2 |
235481 | 235481 | 2020-06-13 | Taney | Missouri | 29213 | 15 | 2 |
232375 | 232375 | 2020-06-12 | Taney | Missouri | 29213 | 15 | 2 |
229271 | 229271 | 2020-06-11 | Taney | Missouri | 29213 | 15 | 2 |
226168 | 226168 | 2020-06-10 | Taney | Missouri | 29213 | 13 | 2 |
223069 | 223069 | 2020-06-09 | Taney | Missouri | 29213 | 13 | 2 |
219974 | 219974 | 2020-06-08 | Taney | Missouri | 29213 | 13 | 2 |
216882 | 216882 | 2020-06-07 | Taney | Missouri | 29213 | 13 | 2 |
213793 | 213793 | 2020-06-06 | Taney | Missouri | 29213 | 13 | 2 |
210709 | 210709 | 2020-06-05 | Taney | Missouri | 29213 | 13 | 2 |
207628 | 207628 | 2020-06-04 | Taney | Missouri | 29213 | 13 | 2 |
204547 | 204547 | 2020-06-03 | Taney | Missouri | 29213 | 13 | 2 |
201470 | 201470 | 2020-06-02 | Taney | Missouri | 29213 | 13 | 2 |
198397 | 198397 | 2020-06-01 | Taney | Missouri | 29213 | 13 | 2 |
195326 | 195326 | 2020-05-31 | Taney | Missouri | 29213 | 13 | 2 |
192256 | 192256 | 2020-05-30 | Taney | Missouri | 29213 | 13 | 2 |
189192 | 189192 | 2020-05-29 | Taney | Missouri | 29213 | 13 | 2 |
186134 | 186134 | 2020-05-28 | Taney | Missouri | 29213 | 13 | 2 |
183078 | 183078 | 2020-05-27 | Taney | Missouri | 29213 | 13 | 2 |
180030 | 180030 | 2020-05-26 | Taney | Missouri | 29213 | 13 | 2 |
176986 | 176986 | 2020-05-25 | Taney | Missouri | 29213 | 13 | 2 |
173943 | 173943 | 2020-05-24 | Taney | Missouri | 29213 | 13 | 2 |
170901 | 170901 | 2020-05-23 | Taney | Missouri | 29213 | 12 | 2 |
167862 | 167862 | 2020-05-22 | Taney | Missouri | 29213 | 12 | 2 |
164826 | 164826 | 2020-05-21 | Taney | Missouri | 29213 | 12 | 2 |
161797 | 161797 | 2020-05-20 | Taney | Missouri | 29213 | 12 | 2 |
158771 | 158771 | 2020-05-19 | Taney | Missouri | 29213 | 12 | 2 |
155753 | 155753 | 2020-05-18 | Taney | Missouri | 29213 | 12 | 2 |
152739 | 152739 | 2020-05-17 | Taney | Missouri | 29213 | 12 | 2 |
149728 | 149728 | 2020-05-16 | Taney | Missouri | 29213 | 12 | 2 |
146722 | 146722 | 2020-05-15 | Taney | Missouri | 29213 | 12 | 2 |
143721 | 143721 | 2020-05-14 | Taney | Missouri | 29213 | 12 | 2 |
140726 | 140726 | 2020-05-13 | Taney | Missouri | 29213 | 12 | 2 |
137732 | 137732 | 2020-05-12 | Taney | Missouri | 29213 | 12 | 2 |
134742 | 134742 | 2020-05-11 | Taney | Missouri | 29213 | 12 | 2 |
131751 | 131751 | 2020-05-10 | Taney | Missouri | 29213 | 12 | 2 |
128761 | 128761 | 2020-05-09 | Taney | Missouri | 29213 | 12 | 2 |
125773 | 125773 | 2020-05-08 | Taney | Missouri | 29213 | 12 | 2 |
122791 | 122791 | 2020-05-07 | Taney | Missouri | 29213 | 12 | 2 |
119817 | 119817 | 2020-05-06 | Taney | Missouri | 29213 | 12 | 2 |
116857 | 116857 | 2020-05-05 | Taney | Missouri | 29213 | 12 | 2 |
113975 | 113975 | 2020-05-04 | Taney | Missouri | 29213 | 12 | 2 |
111096 | 111096 | 2020-05-03 | Taney | Missouri | 29213 | 12 | 2 |
108223 | 108223 | 2020-05-02 | Taney | Missouri | 29213 | 12 | 2 |
105358 | 105358 | 2020-05-01 | Taney | Missouri | 29213 | 11 | 2 |
102497 | 102497 | 2020-04-30 | Taney | Missouri | 29213 | 11 | 1 |
99645 | 99645 | 2020-04-29 | Taney | Missouri | 29213 | 11 | 1 |
96799 | 96799 | 2020-04-28 | Taney | Missouri | 29213 | 11 | 1 |
93963 | 93963 | 2020-04-27 | Taney | Missouri | 29213 | 10 | 1 |
91142 | 91142 | 2020-04-26 | Taney | Missouri | 29213 | 10 | 1 |
88326 | 88326 | 2020-04-25 | Taney | Missouri | 29213 | 10 | 1 |
85516 | 85516 | 2020-04-24 | Taney | Missouri | 29213 | 10 | 1 |
82712 | 82712 | 2020-04-23 | Taney | Missouri | 29213 | 10 | 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);