ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Marshall" and fips = 47117 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637466 | 637466 | 2020-10-16 | Marshall | Tennessee | 47117 | 992 | 8 |
634220 | 634220 | 2020-10-15 | Marshall | Tennessee | 47117 | 987 | 8 |
630975 | 630975 | 2020-10-14 | Marshall | Tennessee | 47117 | 968 | 6 |
627731 | 627731 | 2020-10-13 | Marshall | Tennessee | 47117 | 956 | 5 |
624489 | 624489 | 2020-10-12 | Marshall | Tennessee | 47117 | 946 | 5 |
621246 | 621246 | 2020-10-11 | Marshall | Tennessee | 47117 | 920 | 5 |
618003 | 618003 | 2020-10-10 | Marshall | Tennessee | 47117 | 900 | 5 |
614761 | 614761 | 2020-10-09 | Marshall | Tennessee | 47117 | 878 | 5 |
611520 | 611520 | 2020-10-08 | Marshall | Tennessee | 47117 | 873 | 5 |
608278 | 608278 | 2020-10-07 | Marshall | Tennessee | 47117 | 862 | 5 |
605035 | 605035 | 2020-10-06 | Marshall | Tennessee | 47117 | 846 | 5 |
601793 | 601793 | 2020-10-05 | Marshall | Tennessee | 47117 | 839 | 5 |
598550 | 598550 | 2020-10-04 | Marshall | Tennessee | 47117 | 824 | 5 |
595307 | 595307 | 2020-10-03 | Marshall | Tennessee | 47117 | 815 | 5 |
592066 | 592066 | 2020-10-02 | Marshall | Tennessee | 47117 | 807 | 5 |
588825 | 588825 | 2020-10-01 | Marshall | Tennessee | 47117 | 794 | 5 |
585585 | 585585 | 2020-09-30 | Marshall | Tennessee | 47117 | 791 | 5 |
582345 | 582345 | 2020-09-29 | Marshall | Tennessee | 47117 | 781 | 5 |
579105 | 579105 | 2020-09-28 | Marshall | Tennessee | 47117 | 780 | 5 |
575864 | 575864 | 2020-09-27 | Marshall | Tennessee | 47117 | 778 | 5 |
572620 | 572620 | 2020-09-26 | Marshall | Tennessee | 47117 | 756 | 5 |
569378 | 569378 | 2020-09-25 | Marshall | Tennessee | 47117 | 749 | 5 |
566137 | 566137 | 2020-09-24 | Marshall | Tennessee | 47117 | 741 | 5 |
562896 | 562896 | 2020-09-23 | Marshall | Tennessee | 47117 | 733 | 5 |
559659 | 559659 | 2020-09-22 | Marshall | Tennessee | 47117 | 720 | 5 |
556422 | 556422 | 2020-09-21 | Marshall | Tennessee | 47117 | 717 | 5 |
553185 | 553185 | 2020-09-20 | Marshall | Tennessee | 47117 | 713 | 5 |
549946 | 549946 | 2020-09-19 | Marshall | Tennessee | 47117 | 698 | 5 |
546707 | 546707 | 2020-09-18 | Marshall | Tennessee | 47117 | 697 | 4 |
543470 | 543470 | 2020-09-17 | Marshall | Tennessee | 47117 | 679 | 4 |
540234 | 540234 | 2020-09-16 | Marshall | Tennessee | 47117 | 674 | 4 |
536997 | 536997 | 2020-09-15 | Marshall | Tennessee | 47117 | 658 | 4 |
533761 | 533761 | 2020-09-14 | Marshall | Tennessee | 47117 | 657 | 4 |
530526 | 530526 | 2020-09-13 | Marshall | Tennessee | 47117 | 639 | 4 |
527289 | 527289 | 2020-09-12 | Marshall | Tennessee | 47117 | 624 | 4 |
524053 | 524053 | 2020-09-11 | Marshall | Tennessee | 47117 | 623 | 4 |
520817 | 520817 | 2020-09-10 | Marshall | Tennessee | 47117 | 609 | 4 |
517581 | 517581 | 2020-09-09 | Marshall | Tennessee | 47117 | 601 | 4 |
514346 | 514346 | 2020-09-08 | Marshall | Tennessee | 47117 | 599 | 4 |
511113 | 511113 | 2020-09-07 | Marshall | Tennessee | 47117 | 599 | 4 |
507880 | 507880 | 2020-09-06 | Marshall | Tennessee | 47117 | 595 | 4 |
504648 | 504648 | 2020-09-05 | Marshall | Tennessee | 47117 | 585 | 4 |
501414 | 501414 | 2020-09-04 | Marshall | Tennessee | 47117 | 576 | 4 |
498180 | 498180 | 2020-09-03 | Marshall | Tennessee | 47117 | 577 | 4 |
494947 | 494947 | 2020-09-02 | Marshall | Tennessee | 47117 | 568 | 4 |
491713 | 491713 | 2020-09-01 | Marshall | Tennessee | 47117 | 549 | 4 |
488480 | 488480 | 2020-08-31 | Marshall | Tennessee | 47117 | 533 | 4 |
485247 | 485247 | 2020-08-30 | Marshall | Tennessee | 47117 | 532 | 4 |
482012 | 482012 | 2020-08-29 | Marshall | Tennessee | 47117 | 529 | 4 |
478778 | 478778 | 2020-08-28 | Marshall | Tennessee | 47117 | 519 | 4 |
475545 | 475545 | 2020-08-27 | Marshall | Tennessee | 47117 | 507 | 4 |
472312 | 472312 | 2020-08-26 | Marshall | Tennessee | 47117 | 488 | 4 |
469080 | 469080 | 2020-08-25 | Marshall | Tennessee | 47117 | 474 | 4 |
465851 | 465851 | 2020-08-24 | Marshall | Tennessee | 47117 | 472 | 4 |
462622 | 462622 | 2020-08-23 | Marshall | Tennessee | 47117 | 467 | 4 |
459394 | 459394 | 2020-08-22 | Marshall | Tennessee | 47117 | 443 | 4 |
456166 | 456166 | 2020-08-21 | Marshall | Tennessee | 47117 | 416 | 4 |
452938 | 452938 | 2020-08-20 | Marshall | Tennessee | 47117 | 405 | 4 |
449710 | 449710 | 2020-08-19 | Marshall | Tennessee | 47117 | 400 | 4 |
446482 | 446482 | 2020-08-18 | Marshall | Tennessee | 47117 | 373 | 4 |
443256 | 443256 | 2020-08-17 | Marshall | Tennessee | 47117 | 372 | 4 |
440029 | 440029 | 2020-08-16 | Marshall | Tennessee | 47117 | 369 | 4 |
436804 | 436804 | 2020-08-15 | Marshall | Tennessee | 47117 | 340 | 4 |
433577 | 433577 | 2020-08-14 | Marshall | Tennessee | 47117 | 336 | 4 |
430352 | 430352 | 2020-08-13 | Marshall | Tennessee | 47117 | 325 | 4 |
427125 | 427125 | 2020-08-12 | Marshall | Tennessee | 47117 | 310 | 4 |
423902 | 423902 | 2020-08-11 | Marshall | Tennessee | 47117 | 305 | 4 |
420680 | 420680 | 2020-08-10 | Marshall | Tennessee | 47117 | 304 | 4 |
417459 | 417459 | 2020-08-09 | Marshall | Tennessee | 47117 | 301 | 3 |
414238 | 414238 | 2020-08-08 | Marshall | Tennessee | 47117 | 290 | 3 |
411018 | 411018 | 2020-08-07 | Marshall | Tennessee | 47117 | 283 | 3 |
407799 | 407799 | 2020-08-06 | Marshall | Tennessee | 47117 | 275 | 3 |
404579 | 404579 | 2020-08-05 | Marshall | Tennessee | 47117 | 271 | 3 |
401361 | 401361 | 2020-08-04 | Marshall | Tennessee | 47117 | 266 | 2 |
398146 | 398146 | 2020-08-03 | Marshall | Tennessee | 47117 | 265 | 2 |
394929 | 394929 | 2020-08-02 | Marshall | Tennessee | 47117 | 263 | 2 |
391713 | 391713 | 2020-08-01 | Marshall | Tennessee | 47117 | 261 | 2 |
388496 | 388496 | 2020-07-31 | Marshall | Tennessee | 47117 | 258 | 2 |
385279 | 385279 | 2020-07-30 | Marshall | Tennessee | 47117 | 242 | 2 |
382061 | 382061 | 2020-07-29 | Marshall | Tennessee | 47117 | 234 | 2 |
378844 | 378844 | 2020-07-28 | Marshall | Tennessee | 47117 | 221 | 2 |
375628 | 375628 | 2020-07-27 | Marshall | Tennessee | 47117 | 218 | 2 |
372415 | 372415 | 2020-07-26 | Marshall | Tennessee | 47117 | 209 | 2 |
369203 | 369203 | 2020-07-25 | Marshall | Tennessee | 47117 | 193 | 2 |
365994 | 365994 | 2020-07-24 | Marshall | Tennessee | 47117 | 188 | 2 |
362788 | 362788 | 2020-07-23 | Marshall | Tennessee | 47117 | 178 | 2 |
359581 | 359581 | 2020-07-22 | Marshall | Tennessee | 47117 | 173 | 2 |
356377 | 356377 | 2020-07-21 | Marshall | Tennessee | 47117 | 173 | 2 |
353174 | 353174 | 2020-07-20 | Marshall | Tennessee | 47117 | 166 | 2 |
349971 | 349971 | 2020-07-19 | Marshall | Tennessee | 47117 | 161 | 2 |
346771 | 346771 | 2020-07-18 | Marshall | Tennessee | 47117 | 155 | 2 |
343571 | 343571 | 2020-07-17 | Marshall | Tennessee | 47117 | 154 | 2 |
340373 | 340373 | 2020-07-16 | Marshall | Tennessee | 47117 | 150 | 2 |
337176 | 337176 | 2020-07-15 | Marshall | Tennessee | 47117 | 141 | 2 |
333982 | 333982 | 2020-07-14 | Marshall | Tennessee | 47117 | 132 | 2 |
330790 | 330790 | 2020-07-13 | Marshall | Tennessee | 47117 | 123 | 2 |
327604 | 327604 | 2020-07-12 | Marshall | Tennessee | 47117 | 118 | 2 |
324419 | 324419 | 2020-07-11 | Marshall | Tennessee | 47117 | 115 | 2 |
321238 | 321238 | 2020-07-10 | Marshall | Tennessee | 47117 | 108 | 2 |
318060 | 318060 | 2020-07-09 | Marshall | Tennessee | 47117 | 104 | 2 |
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);