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 |
---|---|---|---|---|---|---|---|
535940 | 535940 | 2020-09-15 | Clinton | Missouri | 29049 | 185 | 0 |
532705 | 532705 | 2020-09-14 | Clinton | Missouri | 29049 | 179 | 0 |
529469 | 529469 | 2020-09-13 | Clinton | Missouri | 29049 | 179 | 0 |
526233 | 526233 | 2020-09-12 | Clinton | Missouri | 29049 | 176 | 0 |
522997 | 522997 | 2020-09-11 | Clinton | Missouri | 29049 | 175 | 0 |
519760 | 519760 | 2020-09-10 | Clinton | Missouri | 29049 | 170 | 0 |
516525 | 516525 | 2020-09-09 | Clinton | Missouri | 29049 | 168 | 0 |
513291 | 513291 | 2020-09-08 | Clinton | Missouri | 29049 | 162 | 0 |
510059 | 510059 | 2020-09-07 | Clinton | Missouri | 29049 | 161 | 0 |
506826 | 506826 | 2020-09-06 | Clinton | Missouri | 29049 | 158 | 0 |
503593 | 503593 | 2020-09-05 | Clinton | Missouri | 29049 | 152 | 0 |
500359 | 500359 | 2020-09-04 | Clinton | Missouri | 29049 | 146 | 0 |
497125 | 497125 | 2020-09-03 | Clinton | Missouri | 29049 | 142 | 0 |
493892 | 493892 | 2020-09-02 | Clinton | Missouri | 29049 | 135 | 0 |
490658 | 490658 | 2020-09-01 | Clinton | Missouri | 29049 | 129 | 0 |
487425 | 487425 | 2020-08-31 | Clinton | Missouri | 29049 | 127 | 0 |
484191 | 484191 | 2020-08-30 | Clinton | Missouri | 29049 | 132 | 0 |
480956 | 480956 | 2020-08-29 | Clinton | Missouri | 29049 | 128 | 0 |
477724 | 477724 | 2020-08-28 | Clinton | Missouri | 29049 | 127 | 0 |
474491 | 474491 | 2020-08-27 | Clinton | Missouri | 29049 | 123 | 0 |
471259 | 471259 | 2020-08-26 | Clinton | Missouri | 29049 | 121 | 0 |
468029 | 468029 | 2020-08-25 | Clinton | Missouri | 29049 | 118 | 0 |
464800 | 464800 | 2020-08-24 | Clinton | Missouri | 29049 | 115 | 0 |
461569 | 461569 | 2020-08-23 | Clinton | Missouri | 29049 | 113 | 0 |
458342 | 458342 | 2020-08-22 | Clinton | Missouri | 29049 | 113 | 0 |
455114 | 455114 | 2020-08-21 | Clinton | Missouri | 29049 | 112 | 0 |
451886 | 451886 | 2020-08-20 | Clinton | Missouri | 29049 | 111 | 0 |
448658 | 448658 | 2020-08-19 | Clinton | Missouri | 29049 | 105 | 0 |
445432 | 445432 | 2020-08-18 | Clinton | Missouri | 29049 | 103 | 0 |
442206 | 442206 | 2020-08-17 | Clinton | Missouri | 29049 | 101 | 0 |
438979 | 438979 | 2020-08-16 | Clinton | Missouri | 29049 | 97 | 0 |
435754 | 435754 | 2020-08-15 | Clinton | Missouri | 29049 | 95 | 0 |
432528 | 432528 | 2020-08-14 | Clinton | Missouri | 29049 | 93 | 0 |
429301 | 429301 | 2020-08-13 | Clinton | Missouri | 29049 | 88 | 0 |
426077 | 426077 | 2020-08-12 | Clinton | Missouri | 29049 | 90 | 0 |
422855 | 422855 | 2020-08-11 | Clinton | Missouri | 29049 | 85 | 0 |
419633 | 419633 | 2020-08-10 | Clinton | Missouri | 29049 | 84 | 0 |
416412 | 416412 | 2020-08-09 | Clinton | Missouri | 29049 | 82 | 0 |
413192 | 413192 | 2020-08-08 | Clinton | Missouri | 29049 | 79 | 0 |
409972 | 409972 | 2020-08-07 | Clinton | Missouri | 29049 | 79 | 0 |
406752 | 406752 | 2020-08-06 | Clinton | Missouri | 29049 | 72 | 0 |
403534 | 403534 | 2020-08-05 | Clinton | Missouri | 29049 | 68 | 0 |
400317 | 400317 | 2020-08-04 | Clinton | Missouri | 29049 | 65 | 0 |
397103 | 397103 | 2020-08-03 | Clinton | Missouri | 29049 | 65 | 0 |
393887 | 393887 | 2020-08-02 | Clinton | Missouri | 29049 | 61 | 0 |
390670 | 390670 | 2020-08-01 | Clinton | Missouri | 29049 | 61 | 0 |
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 |
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);