ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where fips = 29049 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387453 | 387453 | 2020-07-31 | Clinton | Missouri | 29049 | 61 | 0 |
384235 | 384235 | 2020-07-30 | Clinton | Missouri | 29049 | 59 | 0 |
381019 | 381019 | 2020-07-29 | Clinton | Missouri | 29049 | 57 | 0 |
377802 | 377802 | 2020-07-28 | Clinton | Missouri | 29049 | 57 | 0 |
374587 | 374587 | 2020-07-27 | Clinton | Missouri | 29049 | 53 | 0 |
371375 | 371375 | 2020-07-26 | Clinton | Missouri | 29049 | 53 | 0 |
368164 | 368164 | 2020-07-25 | Clinton | Missouri | 29049 | 53 | 0 |
364956 | 364956 | 2020-07-24 | Clinton | Missouri | 29049 | 50 | 0 |
361749 | 361749 | 2020-07-23 | Clinton | Missouri | 29049 | 46 | 0 |
358544 | 358544 | 2020-07-22 | Clinton | Missouri | 29049 | 43 | 0 |
355341 | 355341 | 2020-07-21 | Clinton | Missouri | 29049 | 42 | 0 |
352139 | 352139 | 2020-07-20 | Clinton | Missouri | 29049 | 38 | 0 |
348939 | 348939 | 2020-07-19 | Clinton | Missouri | 29049 | 36 | 0 |
345738 | 345738 | 2020-07-18 | Clinton | Missouri | 29049 | 38 | 0 |
342538 | 342538 | 2020-07-17 | Clinton | Missouri | 29049 | 38 | 0 |
339342 | 339342 | 2020-07-16 | Clinton | Missouri | 29049 | 36 | 0 |
336146 | 336146 | 2020-07-15 | Clinton | Missouri | 29049 | 36 | 0 |
332953 | 332953 | 2020-07-14 | Clinton | Missouri | 29049 | 35 | 0 |
329766 | 329766 | 2020-07-13 | Clinton | Missouri | 29049 | 33 | 0 |
326580 | 326580 | 2020-07-12 | Clinton | Missouri | 29049 | 33 | 0 |
323397 | 323397 | 2020-07-11 | Clinton | Missouri | 29049 | 33 | 0 |
320218 | 320218 | 2020-07-10 | Clinton | Missouri | 29049 | 33 | 0 |
317043 | 317043 | 2020-07-09 | Clinton | Missouri | 29049 | 31 | 0 |
313869 | 313869 | 2020-07-08 | Clinton | Missouri | 29049 | 31 | 0 |
310699 | 310699 | 2020-07-07 | Clinton | Missouri | 29049 | 29 | 0 |
307531 | 307531 | 2020-07-06 | Clinton | Missouri | 29049 | 28 | 0 |
304364 | 304364 | 2020-07-05 | Clinton | Missouri | 29049 | 29 | 0 |
301200 | 301200 | 2020-07-04 | Clinton | Missouri | 29049 | 29 | 0 |
298037 | 298037 | 2020-07-03 | Clinton | Missouri | 29049 | 28 | 0 |
294879 | 294879 | 2020-07-02 | Clinton | Missouri | 29049 | 26 | 0 |
291725 | 291725 | 2020-07-01 | Clinton | Missouri | 29049 | 25 | 0 |
288574 | 288574 | 2020-06-30 | Clinton | Missouri | 29049 | 25 | 0 |
285424 | 285424 | 2020-06-29 | Clinton | Missouri | 29049 | 23 | 0 |
282279 | 282279 | 2020-06-28 | Clinton | Missouri | 29049 | 23 | 0 |
279131 | 279131 | 2020-06-27 | Clinton | Missouri | 29049 | 23 | 0 |
275983 | 275983 | 2020-06-26 | Clinton | Missouri | 29049 | 23 | 0 |
272840 | 272840 | 2020-06-25 | Clinton | Missouri | 29049 | 23 | 0 |
269702 | 269702 | 2020-06-24 | Clinton | Missouri | 29049 | 23 | 0 |
266569 | 266569 | 2020-06-23 | Clinton | Missouri | 29049 | 23 | 0 |
263443 | 263443 | 2020-06-22 | Clinton | Missouri | 29049 | 23 | 0 |
260315 | 260315 | 2020-06-21 | Clinton | Missouri | 29049 | 23 | 0 |
257189 | 257189 | 2020-06-20 | Clinton | Missouri | 29049 | 23 | 0 |
254069 | 254069 | 2020-06-19 | Clinton | Missouri | 29049 | 22 | 0 |
250954 | 250954 | 2020-06-18 | Clinton | Missouri | 29049 | 23 | 0 |
247841 | 247841 | 2020-06-17 | Clinton | Missouri | 29049 | 21 | 0 |
244728 | 244728 | 2020-06-16 | Clinton | Missouri | 29049 | 21 | 0 |
241617 | 241617 | 2020-06-15 | Clinton | Missouri | 29049 | 21 | 0 |
238508 | 238508 | 2020-06-14 | Clinton | Missouri | 29049 | 20 | 0 |
235401 | 235401 | 2020-06-13 | Clinton | Missouri | 29049 | 20 | 0 |
232295 | 232295 | 2020-06-12 | Clinton | Missouri | 29049 | 19 | 0 |
229191 | 229191 | 2020-06-11 | Clinton | Missouri | 29049 | 19 | 0 |
226088 | 226088 | 2020-06-10 | Clinton | Missouri | 29049 | 19 | 0 |
222990 | 222990 | 2020-06-09 | Clinton | Missouri | 29049 | 19 | 0 |
219895 | 219895 | 2020-06-08 | Clinton | Missouri | 29049 | 19 | 0 |
216803 | 216803 | 2020-06-07 | Clinton | Missouri | 29049 | 19 | 0 |
213715 | 213715 | 2020-06-06 | Clinton | Missouri | 29049 | 19 | 0 |
210631 | 210631 | 2020-06-05 | Clinton | Missouri | 29049 | 19 | 0 |
207550 | 207550 | 2020-06-04 | Clinton | Missouri | 29049 | 20 | 0 |
204469 | 204469 | 2020-06-03 | Clinton | Missouri | 29049 | 18 | 0 |
201392 | 201392 | 2020-06-02 | Clinton | Missouri | 29049 | 18 | 0 |
198319 | 198319 | 2020-06-01 | Clinton | Missouri | 29049 | 18 | 0 |
195248 | 195248 | 2020-05-31 | Clinton | Missouri | 29049 | 18 | 0 |
192180 | 192180 | 2020-05-30 | Clinton | Missouri | 29049 | 18 | 0 |
189116 | 189116 | 2020-05-29 | Clinton | Missouri | 29049 | 18 | 0 |
186058 | 186058 | 2020-05-28 | Clinton | Missouri | 29049 | 18 | 0 |
183002 | 183002 | 2020-05-27 | Clinton | Missouri | 29049 | 18 | 0 |
179956 | 179956 | 2020-05-26 | Clinton | Missouri | 29049 | 18 | 0 |
176912 | 176912 | 2020-05-25 | Clinton | Missouri | 29049 | 18 | 0 |
173869 | 173869 | 2020-05-24 | Clinton | Missouri | 29049 | 18 | 0 |
170827 | 170827 | 2020-05-23 | Clinton | Missouri | 29049 | 17 | 0 |
167789 | 167789 | 2020-05-22 | Clinton | Missouri | 29049 | 16 | 0 |
164753 | 164753 | 2020-05-21 | Clinton | Missouri | 29049 | 16 | 0 |
161724 | 161724 | 2020-05-20 | Clinton | Missouri | 29049 | 18 | 0 |
158698 | 158698 | 2020-05-19 | Clinton | Missouri | 29049 | 17 | 0 |
155680 | 155680 | 2020-05-18 | Clinton | Missouri | 29049 | 17 | 0 |
152666 | 152666 | 2020-05-17 | Clinton | Missouri | 29049 | 17 | 0 |
149655 | 149655 | 2020-05-16 | Clinton | Missouri | 29049 | 14 | 0 |
146650 | 146650 | 2020-05-15 | Clinton | Missouri | 29049 | 14 | 0 |
143650 | 143650 | 2020-05-14 | Clinton | Missouri | 29049 | 14 | 0 |
140655 | 140655 | 2020-05-13 | Clinton | Missouri | 29049 | 14 | 0 |
137661 | 137661 | 2020-05-12 | Clinton | Missouri | 29049 | 14 | 0 |
134671 | 134671 | 2020-05-11 | Clinton | Missouri | 29049 | 14 | 0 |
131680 | 131680 | 2020-05-10 | Clinton | Missouri | 29049 | 14 | 0 |
128690 | 128690 | 2020-05-09 | Clinton | Missouri | 29049 | 14 | 0 |
125703 | 125703 | 2020-05-08 | Clinton | Missouri | 29049 | 14 | 0 |
122721 | 122721 | 2020-05-07 | Clinton | Missouri | 29049 | 13 | 0 |
119747 | 119747 | 2020-05-06 | Clinton | Missouri | 29049 | 13 | 0 |
116787 | 116787 | 2020-05-05 | Clinton | Missouri | 29049 | 11 | 0 |
113905 | 113905 | 2020-05-04 | Clinton | Missouri | 29049 | 11 | 0 |
111026 | 111026 | 2020-05-03 | Clinton | Missouri | 29049 | 11 | 0 |
108155 | 108155 | 2020-05-02 | Clinton | Missouri | 29049 | 11 | 0 |
105290 | 105290 | 2020-05-01 | Clinton | Missouri | 29049 | 11 | 0 |
102429 | 102429 | 2020-04-30 | Clinton | Missouri | 29049 | 11 | 0 |
99577 | 99577 | 2020-04-29 | Clinton | Missouri | 29049 | 11 | 0 |
96731 | 96731 | 2020-04-28 | Clinton | Missouri | 29049 | 11 | 0 |
93895 | 93895 | 2020-04-27 | Clinton | Missouri | 29049 | 11 | 0 |
91074 | 91074 | 2020-04-26 | Clinton | Missouri | 29049 | 11 | 0 |
88258 | 88258 | 2020-04-25 | Clinton | Missouri | 29049 | 11 | 0 |
85448 | 85448 | 2020-04-24 | Clinton | Missouri | 29049 | 11 | 0 |
82644 | 82644 | 2020-04-23 | Clinton | Missouri | 29049 | 11 | 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);