ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Rutherford" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637484 | 637484 | 2020-10-16 | Rutherford | Tennessee | 47149 | 10654 | 105 |
634238 | 634238 | 2020-10-15 | Rutherford | Tennessee | 47149 | 10637 | 105 |
630993 | 630993 | 2020-10-14 | Rutherford | Tennessee | 47149 | 10570 | 104 |
627749 | 627749 | 2020-10-13 | Rutherford | Tennessee | 47149 | 10510 | 103 |
624507 | 624507 | 2020-10-12 | Rutherford | Tennessee | 47149 | 10448 | 103 |
621264 | 621264 | 2020-10-11 | Rutherford | Tennessee | 47149 | 10312 | 103 |
618021 | 618021 | 2020-10-10 | Rutherford | Tennessee | 47149 | 10242 | 103 |
614779 | 614779 | 2020-10-09 | Rutherford | Tennessee | 47149 | 10147 | 102 |
611538 | 611538 | 2020-10-08 | Rutherford | Tennessee | 47149 | 10048 | 101 |
608296 | 608296 | 2020-10-07 | Rutherford | Tennessee | 47149 | 9978 | 99 |
605053 | 605053 | 2020-10-06 | Rutherford | Tennessee | 47149 | 9884 | 99 |
601811 | 601811 | 2020-10-05 | Rutherford | Tennessee | 47149 | 9807 | 98 |
598568 | 598568 | 2020-10-04 | Rutherford | Tennessee | 47149 | 9709 | 98 |
595325 | 595325 | 2020-10-03 | Rutherford | Tennessee | 47149 | 9668 | 98 |
592084 | 592084 | 2020-10-02 | Rutherford | Tennessee | 47149 | 9624 | 96 |
588843 | 588843 | 2020-10-01 | Rutherford | Tennessee | 47149 | 9579 | 95 |
585603 | 585603 | 2020-09-30 | Rutherford | Tennessee | 47149 | 9523 | 92 |
582363 | 582363 | 2020-09-29 | Rutherford | Tennessee | 47149 | 9452 | 90 |
579123 | 579123 | 2020-09-28 | Rutherford | Tennessee | 47149 | 9408 | 90 |
575882 | 575882 | 2020-09-27 | Rutherford | Tennessee | 47149 | 9361 | 89 |
572638 | 572638 | 2020-09-26 | Rutherford | Tennessee | 47149 | 9293 | 89 |
569396 | 569396 | 2020-09-25 | Rutherford | Tennessee | 47149 | 9240 | 89 |
566155 | 566155 | 2020-09-24 | Rutherford | Tennessee | 47149 | 9150 | 88 |
562914 | 562914 | 2020-09-23 | Rutherford | Tennessee | 47149 | 9113 | 88 |
559677 | 559677 | 2020-09-22 | Rutherford | Tennessee | 47149 | 9058 | 88 |
556440 | 556440 | 2020-09-21 | Rutherford | Tennessee | 47149 | 9031 | 87 |
553203 | 553203 | 2020-09-20 | Rutherford | Tennessee | 47149 | 8986 | 87 |
549964 | 549964 | 2020-09-19 | Rutherford | Tennessee | 47149 | 8902 | 87 |
546725 | 546725 | 2020-09-18 | Rutherford | Tennessee | 47149 | 8869 | 87 |
543488 | 543488 | 2020-09-17 | Rutherford | Tennessee | 47149 | 8779 | 86 |
540252 | 540252 | 2020-09-16 | Rutherford | Tennessee | 47149 | 8718 | 85 |
537015 | 537015 | 2020-09-15 | Rutherford | Tennessee | 47149 | 8661 | 85 |
533779 | 533779 | 2020-09-14 | Rutherford | Tennessee | 47149 | 8629 | 84 |
530544 | 530544 | 2020-09-13 | Rutherford | Tennessee | 47149 | 8530 | 84 |
527307 | 527307 | 2020-09-12 | Rutherford | Tennessee | 47149 | 8492 | 84 |
524071 | 524071 | 2020-09-11 | Rutherford | Tennessee | 47149 | 8420 | 82 |
520835 | 520835 | 2020-09-10 | Rutherford | Tennessee | 47149 | 8387 | 82 |
517599 | 517599 | 2020-09-09 | Rutherford | Tennessee | 47149 | 8270 | 81 |
514364 | 514364 | 2020-09-08 | Rutherford | Tennessee | 47149 | 8242 | 80 |
511131 | 511131 | 2020-09-07 | Rutherford | Tennessee | 47149 | 8188 | 80 |
507898 | 507898 | 2020-09-06 | Rutherford | Tennessee | 47149 | 8159 | 80 |
504666 | 504666 | 2020-09-05 | Rutherford | Tennessee | 47149 | 8110 | 80 |
501432 | 501432 | 2020-09-04 | Rutherford | Tennessee | 47149 | 8059 | 77 |
498198 | 498198 | 2020-09-03 | Rutherford | Tennessee | 47149 | 8018 | 73 |
494965 | 494965 | 2020-09-02 | Rutherford | Tennessee | 47149 | 7930 | 70 |
491731 | 491731 | 2020-09-01 | Rutherford | Tennessee | 47149 | 7868 | 70 |
488498 | 488498 | 2020-08-31 | Rutherford | Tennessee | 47149 | 7825 | 70 |
485265 | 485265 | 2020-08-30 | Rutherford | Tennessee | 47149 | 7799 | 70 |
482030 | 482030 | 2020-08-29 | Rutherford | Tennessee | 47149 | 7770 | 68 |
478796 | 478796 | 2020-08-28 | Rutherford | Tennessee | 47149 | 7725 | 68 |
475563 | 475563 | 2020-08-27 | Rutherford | Tennessee | 47149 | 7670 | 67 |
472330 | 472330 | 2020-08-26 | Rutherford | Tennessee | 47149 | 7620 | 67 |
469098 | 469098 | 2020-08-25 | Rutherford | Tennessee | 47149 | 7523 | 67 |
465869 | 465869 | 2020-08-24 | Rutherford | Tennessee | 47149 | 7486 | 64 |
462640 | 462640 | 2020-08-23 | Rutherford | Tennessee | 47149 | 7461 | 64 |
459412 | 459412 | 2020-08-22 | Rutherford | Tennessee | 47149 | 7404 | 64 |
456184 | 456184 | 2020-08-21 | Rutherford | Tennessee | 47149 | 7363 | 65 |
452956 | 452956 | 2020-08-20 | Rutherford | Tennessee | 47149 | 7300 | 61 |
449728 | 449728 | 2020-08-19 | Rutherford | Tennessee | 47149 | 7223 | 61 |
446500 | 446500 | 2020-08-18 | Rutherford | Tennessee | 47149 | 7179 | 61 |
443274 | 443274 | 2020-08-17 | Rutherford | Tennessee | 47149 | 7137 | 59 |
440047 | 440047 | 2020-08-16 | Rutherford | Tennessee | 47149 | 7080 | 59 |
436822 | 436822 | 2020-08-15 | Rutherford | Tennessee | 47149 | 6999 | 59 |
433595 | 433595 | 2020-08-14 | Rutherford | Tennessee | 47149 | 6938 | 57 |
430370 | 430370 | 2020-08-13 | Rutherford | Tennessee | 47149 | 6834 | 55 |
427143 | 427143 | 2020-08-12 | Rutherford | Tennessee | 47149 | 6719 | 56 |
423920 | 423920 | 2020-08-11 | Rutherford | Tennessee | 47149 | 6629 | 55 |
420698 | 420698 | 2020-08-10 | Rutherford | Tennessee | 47149 | 6589 | 55 |
417477 | 417477 | 2020-08-09 | Rutherford | Tennessee | 47149 | 6553 | 54 |
414256 | 414256 | 2020-08-08 | Rutherford | Tennessee | 47149 | 6463 | 54 |
411036 | 411036 | 2020-08-07 | Rutherford | Tennessee | 47149 | 6404 | 53 |
407817 | 407817 | 2020-08-06 | Rutherford | Tennessee | 47149 | 6298 | 53 |
404597 | 404597 | 2020-08-05 | Rutherford | Tennessee | 47149 | 6254 | 53 |
401379 | 401379 | 2020-08-04 | Rutherford | Tennessee | 47149 | 6155 | 53 |
398164 | 398164 | 2020-08-03 | Rutherford | Tennessee | 47149 | 6072 | 53 |
394947 | 394947 | 2020-08-02 | Rutherford | Tennessee | 47149 | 6042 | 51 |
391731 | 391731 | 2020-08-01 | Rutherford | Tennessee | 47149 | 5999 | 51 |
388514 | 388514 | 2020-07-31 | Rutherford | Tennessee | 47149 | 5899 | 51 |
385297 | 385297 | 2020-07-30 | Rutherford | Tennessee | 47149 | 5753 | 49 |
382079 | 382079 | 2020-07-29 | Rutherford | Tennessee | 47149 | 5682 | 49 |
378862 | 378862 | 2020-07-28 | Rutherford | Tennessee | 47149 | 5579 | 48 |
375646 | 375646 | 2020-07-27 | Rutherford | Tennessee | 47149 | 5514 | 48 |
372433 | 372433 | 2020-07-26 | Rutherford | Tennessee | 47149 | 5389 | 47 |
369221 | 369221 | 2020-07-25 | Rutherford | Tennessee | 47149 | 5202 | 47 |
366012 | 366012 | 2020-07-24 | Rutherford | Tennessee | 47149 | 5127 | 45 |
362806 | 362806 | 2020-07-23 | Rutherford | Tennessee | 47149 | 5016 | 45 |
359599 | 359599 | 2020-07-22 | Rutherford | Tennessee | 47149 | 4828 | 43 |
356395 | 356395 | 2020-07-21 | Rutherford | Tennessee | 47149 | 4716 | 43 |
353192 | 353192 | 2020-07-20 | Rutherford | Tennessee | 47149 | 4618 | 41 |
349989 | 349989 | 2020-07-19 | Rutherford | Tennessee | 47149 | 4503 | 41 |
346789 | 346789 | 2020-07-18 | Rutherford | Tennessee | 47149 | 4397 | 41 |
343589 | 343589 | 2020-07-17 | Rutherford | Tennessee | 47149 | 4242 | 41 |
340391 | 340391 | 2020-07-16 | Rutherford | Tennessee | 47149 | 4114 | 40 |
337194 | 337194 | 2020-07-15 | Rutherford | Tennessee | 47149 | 3944 | 39 |
334000 | 334000 | 2020-07-14 | Rutherford | Tennessee | 47149 | 3839 | 39 |
330808 | 330808 | 2020-07-13 | Rutherford | Tennessee | 47149 | 3755 | 39 |
327622 | 327622 | 2020-07-12 | Rutherford | Tennessee | 47149 | 3602 | 39 |
324437 | 324437 | 2020-07-11 | Rutherford | Tennessee | 47149 | 3525 | 39 |
321256 | 321256 | 2020-07-10 | Rutherford | Tennessee | 47149 | 3428 | 39 |
318078 | 318078 | 2020-07-09 | Rutherford | Tennessee | 47149 | 3326 | 38 |
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);