ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
717 rows where county = "Monroe" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636451 | 636451 | 2020-10-16 | Monroe | Missouri | 29137 | 113 | 1 |
633205 | 633205 | 2020-10-15 | Monroe | Missouri | 29137 | 112 | 1 |
629960 | 629960 | 2020-10-14 | Monroe | Missouri | 29137 | 109 | 1 |
626716 | 626716 | 2020-10-13 | Monroe | Missouri | 29137 | 100 | 1 |
623474 | 623474 | 2020-10-12 | Monroe | Missouri | 29137 | 100 | 1 |
620231 | 620231 | 2020-10-11 | Monroe | Missouri | 29137 | 100 | 1 |
616989 | 616989 | 2020-10-10 | Monroe | Missouri | 29137 | 100 | 1 |
613748 | 613748 | 2020-10-09 | Monroe | Missouri | 29137 | 97 | 1 |
610506 | 610506 | 2020-10-08 | Monroe | Missouri | 29137 | 95 | 1 |
607264 | 607264 | 2020-10-07 | Monroe | Missouri | 29137 | 94 | 1 |
604021 | 604021 | 2020-10-06 | Monroe | Missouri | 29137 | 92 | 1 |
600779 | 600779 | 2020-10-05 | Monroe | Missouri | 29137 | 92 | 1 |
597536 | 597536 | 2020-10-04 | Monroe | Missouri | 29137 | 91 | 1 |
594295 | 594295 | 2020-10-03 | Monroe | Missouri | 29137 | 91 | 1 |
591054 | 591054 | 2020-10-02 | Monroe | Missouri | 29137 | 88 | 1 |
587813 | 587813 | 2020-10-01 | Monroe | Missouri | 29137 | 87 | 1 |
584573 | 584573 | 2020-09-30 | Monroe | Missouri | 29137 | 86 | 1 |
581332 | 581332 | 2020-09-29 | Monroe | Missouri | 29137 | 90 | 1 |
578091 | 578091 | 2020-09-28 | Monroe | Missouri | 29137 | 90 | 1 |
574850 | 574850 | 2020-09-27 | Monroe | Missouri | 29137 | 90 | 1 |
571607 | 571607 | 2020-09-26 | Monroe | Missouri | 29137 | 88 | 1 |
568365 | 568365 | 2020-09-25 | Monroe | Missouri | 29137 | 89 | 1 |
565125 | 565125 | 2020-09-24 | Monroe | Missouri | 29137 | 87 | 0 |
561885 | 561885 | 2020-09-23 | Monroe | Missouri | 29137 | 86 | 0 |
558648 | 558648 | 2020-09-22 | Monroe | Missouri | 29137 | 86 | 0 |
555411 | 555411 | 2020-09-21 | Monroe | Missouri | 29137 | 86 | 0 |
552173 | 552173 | 2020-09-20 | Monroe | Missouri | 29137 | 86 | 0 |
548934 | 548934 | 2020-09-19 | Monroe | Missouri | 29137 | 86 | 0 |
545696 | 545696 | 2020-09-18 | Monroe | Missouri | 29137 | 85 | 0 |
542459 | 542459 | 2020-09-17 | Monroe | Missouri | 29137 | 84 | 0 |
539223 | 539223 | 2020-09-16 | Monroe | Missouri | 29137 | 82 | 0 |
535986 | 535986 | 2020-09-15 | Monroe | Missouri | 29137 | 82 | 0 |
532751 | 532751 | 2020-09-14 | Monroe | Missouri | 29137 | 82 | 0 |
529515 | 529515 | 2020-09-13 | Monroe | Missouri | 29137 | 82 | 0 |
526279 | 526279 | 2020-09-12 | Monroe | Missouri | 29137 | 82 | 0 |
523043 | 523043 | 2020-09-11 | Monroe | Missouri | 29137 | 78 | 0 |
519806 | 519806 | 2020-09-10 | Monroe | Missouri | 29137 | 78 | 0 |
516571 | 516571 | 2020-09-09 | Monroe | Missouri | 29137 | 78 | 0 |
513337 | 513337 | 2020-09-08 | Monroe | Missouri | 29137 | 76 | 0 |
510105 | 510105 | 2020-09-07 | Monroe | Missouri | 29137 | 76 | 0 |
506872 | 506872 | 2020-09-06 | Monroe | Missouri | 29137 | 76 | 0 |
503639 | 503639 | 2020-09-05 | Monroe | Missouri | 29137 | 75 | 0 |
500405 | 500405 | 2020-09-04 | Monroe | Missouri | 29137 | 74 | 0 |
497171 | 497171 | 2020-09-03 | Monroe | Missouri | 29137 | 72 | 0 |
493938 | 493938 | 2020-09-02 | Monroe | Missouri | 29137 | 72 | 0 |
490704 | 490704 | 2020-09-01 | Monroe | Missouri | 29137 | 70 | 0 |
487471 | 487471 | 2020-08-31 | Monroe | Missouri | 29137 | 69 | 0 |
484237 | 484237 | 2020-08-30 | Monroe | Missouri | 29137 | 68 | 0 |
481002 | 481002 | 2020-08-29 | Monroe | Missouri | 29137 | 68 | 0 |
477770 | 477770 | 2020-08-28 | Monroe | Missouri | 29137 | 66 | 0 |
474537 | 474537 | 2020-08-27 | Monroe | Missouri | 29137 | 65 | 0 |
471305 | 471305 | 2020-08-26 | Monroe | Missouri | 29137 | 62 | 0 |
468075 | 468075 | 2020-08-25 | Monroe | Missouri | 29137 | 56 | 0 |
464846 | 464846 | 2020-08-24 | Monroe | Missouri | 29137 | 55 | 0 |
461615 | 461615 | 2020-08-23 | Monroe | Missouri | 29137 | 53 | 0 |
458388 | 458388 | 2020-08-22 | Monroe | Missouri | 29137 | 51 | 0 |
455160 | 455160 | 2020-08-21 | Monroe | Missouri | 29137 | 45 | 0 |
451932 | 451932 | 2020-08-20 | Monroe | Missouri | 29137 | 40 | 0 |
448704 | 448704 | 2020-08-19 | Monroe | Missouri | 29137 | 38 | 0 |
445478 | 445478 | 2020-08-18 | Monroe | Missouri | 29137 | 37 | 0 |
442252 | 442252 | 2020-08-17 | Monroe | Missouri | 29137 | 37 | 0 |
439025 | 439025 | 2020-08-16 | Monroe | Missouri | 29137 | 37 | 0 |
435800 | 435800 | 2020-08-15 | Monroe | Missouri | 29137 | 36 | 0 |
432574 | 432574 | 2020-08-14 | Monroe | Missouri | 29137 | 34 | 0 |
429347 | 429347 | 2020-08-13 | Monroe | Missouri | 29137 | 33 | 0 |
426123 | 426123 | 2020-08-12 | Monroe | Missouri | 29137 | 33 | 0 |
422901 | 422901 | 2020-08-11 | Monroe | Missouri | 29137 | 31 | 0 |
419679 | 419679 | 2020-08-10 | Monroe | Missouri | 29137 | 31 | 0 |
416458 | 416458 | 2020-08-09 | Monroe | Missouri | 29137 | 29 | 0 |
413238 | 413238 | 2020-08-08 | Monroe | Missouri | 29137 | 27 | 0 |
410018 | 410018 | 2020-08-07 | Monroe | Missouri | 29137 | 27 | 0 |
406798 | 406798 | 2020-08-06 | Monroe | Missouri | 29137 | 26 | 0 |
403580 | 403580 | 2020-08-05 | Monroe | Missouri | 29137 | 24 | 0 |
400363 | 400363 | 2020-08-04 | Monroe | Missouri | 29137 | 22 | 0 |
397149 | 397149 | 2020-08-03 | Monroe | Missouri | 29137 | 21 | 0 |
393933 | 393933 | 2020-08-02 | Monroe | Missouri | 29137 | 17 | 0 |
390716 | 390716 | 2020-08-01 | Monroe | Missouri | 29137 | 17 | 0 |
387499 | 387499 | 2020-07-31 | Monroe | Missouri | 29137 | 14 | 0 |
384281 | 384281 | 2020-07-30 | Monroe | Missouri | 29137 | 13 | 0 |
381065 | 381065 | 2020-07-29 | Monroe | Missouri | 29137 | 12 | 0 |
377848 | 377848 | 2020-07-28 | Monroe | Missouri | 29137 | 11 | 0 |
374633 | 374633 | 2020-07-27 | Monroe | Missouri | 29137 | 9 | 0 |
371421 | 371421 | 2020-07-26 | Monroe | Missouri | 29137 | 9 | 0 |
368210 | 368210 | 2020-07-25 | Monroe | Missouri | 29137 | 9 | 0 |
365002 | 365002 | 2020-07-24 | Monroe | Missouri | 29137 | 9 | 0 |
361795 | 361795 | 2020-07-23 | Monroe | Missouri | 29137 | 9 | 0 |
358590 | 358590 | 2020-07-22 | Monroe | Missouri | 29137 | 8 | 0 |
355387 | 355387 | 2020-07-21 | Monroe | Missouri | 29137 | 8 | 0 |
352185 | 352185 | 2020-07-20 | Monroe | Missouri | 29137 | 7 | 0 |
348985 | 348985 | 2020-07-19 | Monroe | Missouri | 29137 | 7 | 0 |
345784 | 345784 | 2020-07-18 | Monroe | Missouri | 29137 | 6 | 0 |
342584 | 342584 | 2020-07-17 | Monroe | Missouri | 29137 | 6 | 0 |
339388 | 339388 | 2020-07-16 | Monroe | Missouri | 29137 | 6 | 0 |
336192 | 336192 | 2020-07-15 | Monroe | Missouri | 29137 | 7 | 0 |
332999 | 332999 | 2020-07-14 | Monroe | Missouri | 29137 | 6 | 0 |
329812 | 329812 | 2020-07-13 | Monroe | Missouri | 29137 | 5 | 0 |
326626 | 326626 | 2020-07-12 | Monroe | Missouri | 29137 | 5 | 0 |
323443 | 323443 | 2020-07-11 | Monroe | Missouri | 29137 | 5 | 0 |
320264 | 320264 | 2020-07-10 | Monroe | Missouri | 29137 | 5 | 0 |
317089 | 317089 | 2020-07-09 | Monroe | Missouri | 29137 | 5 | 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);