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
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
291725 | 291725 | 2020-07-01 | Clinton | Missouri | 29049 | 25 | 0 |
294879 | 294879 | 2020-07-02 | Clinton | Missouri | 29049 | 26 | 0 |
298037 | 298037 | 2020-07-03 | Clinton | Missouri | 29049 | 28 | 0 |
301200 | 301200 | 2020-07-04 | Clinton | Missouri | 29049 | 29 | 0 |
304364 | 304364 | 2020-07-05 | Clinton | Missouri | 29049 | 29 | 0 |
307531 | 307531 | 2020-07-06 | Clinton | Missouri | 29049 | 28 | 0 |
310699 | 310699 | 2020-07-07 | Clinton | Missouri | 29049 | 29 | 0 |
313869 | 313869 | 2020-07-08 | Clinton | Missouri | 29049 | 31 | 0 |
317043 | 317043 | 2020-07-09 | Clinton | Missouri | 29049 | 31 | 0 |
320218 | 320218 | 2020-07-10 | Clinton | Missouri | 29049 | 33 | 0 |
323397 | 323397 | 2020-07-11 | Clinton | Missouri | 29049 | 33 | 0 |
326580 | 326580 | 2020-07-12 | Clinton | Missouri | 29049 | 33 | 0 |
329766 | 329766 | 2020-07-13 | Clinton | Missouri | 29049 | 33 | 0 |
332953 | 332953 | 2020-07-14 | Clinton | Missouri | 29049 | 35 | 0 |
336146 | 336146 | 2020-07-15 | Clinton | Missouri | 29049 | 36 | 0 |
339342 | 339342 | 2020-07-16 | Clinton | Missouri | 29049 | 36 | 0 |
342538 | 342538 | 2020-07-17 | Clinton | Missouri | 29049 | 38 | 0 |
345738 | 345738 | 2020-07-18 | Clinton | Missouri | 29049 | 38 | 0 |
348939 | 348939 | 2020-07-19 | Clinton | Missouri | 29049 | 36 | 0 |
352139 | 352139 | 2020-07-20 | Clinton | Missouri | 29049 | 38 | 0 |
355341 | 355341 | 2020-07-21 | Clinton | Missouri | 29049 | 42 | 0 |
358544 | 358544 | 2020-07-22 | Clinton | Missouri | 29049 | 43 | 0 |
361749 | 361749 | 2020-07-23 | Clinton | Missouri | 29049 | 46 | 0 |
364956 | 364956 | 2020-07-24 | Clinton | Missouri | 29049 | 50 | 0 |
368164 | 368164 | 2020-07-25 | Clinton | Missouri | 29049 | 53 | 0 |
371375 | 371375 | 2020-07-26 | Clinton | Missouri | 29049 | 53 | 0 |
374587 | 374587 | 2020-07-27 | Clinton | Missouri | 29049 | 53 | 0 |
377802 | 377802 | 2020-07-28 | Clinton | Missouri | 29049 | 57 | 0 |
381019 | 381019 | 2020-07-29 | Clinton | Missouri | 29049 | 57 | 0 |
384235 | 384235 | 2020-07-30 | Clinton | Missouri | 29049 | 59 | 0 |
387453 | 387453 | 2020-07-31 | Clinton | Missouri | 29049 | 61 | 0 |
390670 | 390670 | 2020-08-01 | Clinton | Missouri | 29049 | 61 | 0 |
393887 | 393887 | 2020-08-02 | Clinton | Missouri | 29049 | 61 | 0 |
397103 | 397103 | 2020-08-03 | Clinton | Missouri | 29049 | 65 | 0 |
400317 | 400317 | 2020-08-04 | Clinton | Missouri | 29049 | 65 | 0 |
403534 | 403534 | 2020-08-05 | Clinton | Missouri | 29049 | 68 | 0 |
406752 | 406752 | 2020-08-06 | Clinton | Missouri | 29049 | 72 | 0 |
409972 | 409972 | 2020-08-07 | Clinton | Missouri | 29049 | 79 | 0 |
413192 | 413192 | 2020-08-08 | Clinton | Missouri | 29049 | 79 | 0 |
416412 | 416412 | 2020-08-09 | Clinton | Missouri | 29049 | 82 | 0 |
419633 | 419633 | 2020-08-10 | Clinton | Missouri | 29049 | 84 | 0 |
422855 | 422855 | 2020-08-11 | Clinton | Missouri | 29049 | 85 | 0 |
426077 | 426077 | 2020-08-12 | Clinton | Missouri | 29049 | 90 | 0 |
429301 | 429301 | 2020-08-13 | Clinton | Missouri | 29049 | 88 | 0 |
432528 | 432528 | 2020-08-14 | Clinton | Missouri | 29049 | 93 | 0 |
435754 | 435754 | 2020-08-15 | Clinton | Missouri | 29049 | 95 | 0 |
438979 | 438979 | 2020-08-16 | Clinton | Missouri | 29049 | 97 | 0 |
442206 | 442206 | 2020-08-17 | Clinton | Missouri | 29049 | 101 | 0 |
445432 | 445432 | 2020-08-18 | Clinton | Missouri | 29049 | 103 | 0 |
448658 | 448658 | 2020-08-19 | Clinton | Missouri | 29049 | 105 | 0 |
451886 | 451886 | 2020-08-20 | Clinton | Missouri | 29049 | 111 | 0 |
455114 | 455114 | 2020-08-21 | Clinton | Missouri | 29049 | 112 | 0 |
458342 | 458342 | 2020-08-22 | Clinton | Missouri | 29049 | 113 | 0 |
461569 | 461569 | 2020-08-23 | Clinton | Missouri | 29049 | 113 | 0 |
464800 | 464800 | 2020-08-24 | Clinton | Missouri | 29049 | 115 | 0 |
468029 | 468029 | 2020-08-25 | Clinton | Missouri | 29049 | 118 | 0 |
471259 | 471259 | 2020-08-26 | Clinton | Missouri | 29049 | 121 | 0 |
474491 | 474491 | 2020-08-27 | Clinton | Missouri | 29049 | 123 | 0 |
477724 | 477724 | 2020-08-28 | Clinton | Missouri | 29049 | 127 | 0 |
480956 | 480956 | 2020-08-29 | Clinton | Missouri | 29049 | 128 | 0 |
484191 | 484191 | 2020-08-30 | Clinton | Missouri | 29049 | 132 | 0 |
487425 | 487425 | 2020-08-31 | Clinton | Missouri | 29049 | 127 | 0 |
490658 | 490658 | 2020-09-01 | Clinton | Missouri | 29049 | 129 | 0 |
493892 | 493892 | 2020-09-02 | Clinton | Missouri | 29049 | 135 | 0 |
497125 | 497125 | 2020-09-03 | Clinton | Missouri | 29049 | 142 | 0 |
500359 | 500359 | 2020-09-04 | Clinton | Missouri | 29049 | 146 | 0 |
503593 | 503593 | 2020-09-05 | Clinton | Missouri | 29049 | 152 | 0 |
506826 | 506826 | 2020-09-06 | Clinton | Missouri | 29049 | 158 | 0 |
510059 | 510059 | 2020-09-07 | Clinton | Missouri | 29049 | 161 | 0 |
513291 | 513291 | 2020-09-08 | Clinton | Missouri | 29049 | 162 | 0 |
516525 | 516525 | 2020-09-09 | Clinton | Missouri | 29049 | 168 | 0 |
519760 | 519760 | 2020-09-10 | Clinton | Missouri | 29049 | 170 | 0 |
522997 | 522997 | 2020-09-11 | Clinton | Missouri | 29049 | 175 | 0 |
526233 | 526233 | 2020-09-12 | Clinton | Missouri | 29049 | 176 | 0 |
529469 | 529469 | 2020-09-13 | Clinton | Missouri | 29049 | 179 | 0 |
532705 | 532705 | 2020-09-14 | Clinton | Missouri | 29049 | 179 | 0 |
535940 | 535940 | 2020-09-15 | Clinton | Missouri | 29049 | 185 | 0 |
539177 | 539177 | 2020-09-16 | Clinton | Missouri | 29049 | 186 | 0 |
542413 | 542413 | 2020-09-17 | Clinton | Missouri | 29049 | 190 | 0 |
545650 | 545650 | 2020-09-18 | Clinton | Missouri | 29049 | 193 | 0 |
548888 | 548888 | 2020-09-19 | Clinton | Missouri | 29049 | 197 | 0 |
552127 | 552127 | 2020-09-20 | Clinton | Missouri | 29049 | 196 | 0 |
555365 | 555365 | 2020-09-21 | Clinton | Missouri | 29049 | 202 | 0 |
558602 | 558602 | 2020-09-22 | Clinton | Missouri | 29049 | 206 | 0 |
561839 | 561839 | 2020-09-23 | Clinton | Missouri | 29049 | 210 | 0 |
565079 | 565079 | 2020-09-24 | Clinton | Missouri | 29049 | 221 | 0 |
568319 | 568319 | 2020-09-25 | Clinton | Missouri | 29049 | 231 | 0 |
571561 | 571561 | 2020-09-26 | Clinton | Missouri | 29049 | 236 | 0 |
574804 | 574804 | 2020-09-27 | Clinton | Missouri | 29049 | 241 | 0 |
578045 | 578045 | 2020-09-28 | Clinton | Missouri | 29049 | 244 | 0 |
581286 | 581286 | 2020-09-29 | Clinton | Missouri | 29049 | 244 | 0 |
584527 | 584527 | 2020-09-30 | Clinton | Missouri | 29049 | 236 | 0 |
587767 | 587767 | 2020-10-01 | Clinton | Missouri | 29049 | 250 | 0 |
591008 | 591008 | 2020-10-02 | Clinton | Missouri | 29049 | 253 | 0 |
594249 | 594249 | 2020-10-03 | Clinton | Missouri | 29049 | 262 | 0 |
597490 | 597490 | 2020-10-04 | Clinton | Missouri | 29049 | 265 | 0 |
600733 | 600733 | 2020-10-05 | Clinton | Missouri | 29049 | 269 | 0 |
603975 | 603975 | 2020-10-06 | Clinton | Missouri | 29049 | 274 | 0 |
607218 | 607218 | 2020-10-07 | Clinton | Missouri | 29049 | 280 | 0 |
610460 | 610460 | 2020-10-08 | Clinton | Missouri | 29049 | 293 | 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);