ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Cumberland" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
955434 | 955434 | 2021-01-22 | Cumberland | Tennessee | 47035 | 5505 | 76 |
952189 | 952189 | 2021-01-21 | Cumberland | Tennessee | 47035 | 5470 | 75 |
948944 | 948944 | 2021-01-20 | Cumberland | Tennessee | 47035 | 5441 | 73 |
945698 | 945698 | 2021-01-19 | Cumberland | Tennessee | 47035 | 5421 | 73 |
942451 | 942451 | 2021-01-18 | Cumberland | Tennessee | 47035 | 5400 | 72 |
939206 | 939206 | 2021-01-17 | Cumberland | Tennessee | 47035 | 5378 | 72 |
935961 | 935961 | 2021-01-16 | Cumberland | Tennessee | 47035 | 5352 | 72 |
932716 | 932716 | 2021-01-15 | Cumberland | Tennessee | 47035 | 5286 | 72 |
929471 | 929471 | 2021-01-14 | Cumberland | Tennessee | 47035 | 5235 | 71 |
926226 | 926226 | 2021-01-13 | Cumberland | Tennessee | 47035 | 5193 | 70 |
922980 | 922980 | 2021-01-12 | Cumberland | Tennessee | 47035 | 5164 | 68 |
919735 | 919735 | 2021-01-11 | Cumberland | Tennessee | 47035 | 5140 | 62 |
916490 | 916490 | 2021-01-10 | Cumberland | Tennessee | 47035 | 5122 | 58 |
913245 | 913245 | 2021-01-09 | Cumberland | Tennessee | 47035 | 5070 | 58 |
910000 | 910000 | 2021-01-08 | Cumberland | Tennessee | 47035 | 4973 | 54 |
906755 | 906755 | 2021-01-07 | Cumberland | Tennessee | 47035 | 4896 | 53 |
903509 | 903509 | 2021-01-06 | Cumberland | Tennessee | 47035 | 4824 | 53 |
900264 | 900264 | 2021-01-05 | Cumberland | Tennessee | 47035 | 4750 | 53 |
897019 | 897019 | 2021-01-04 | Cumberland | Tennessee | 47035 | 4713 | 53 |
893773 | 893773 | 2021-01-03 | Cumberland | Tennessee | 47035 | 4687 | 53 |
890527 | 890527 | 2021-01-02 | Cumberland | Tennessee | 47035 | 4635 | 51 |
887280 | 887280 | 2021-01-01 | Cumberland | Tennessee | 47035 | 4398 | 51 |
884035 | 884035 | 2020-12-31 | Cumberland | Tennessee | 47035 | 4398 | 51 |
880790 | 880790 | 2020-12-30 | Cumberland | Tennessee | 47035 | 4358 | 51 |
877545 | 877545 | 2020-12-29 | Cumberland | Tennessee | 47035 | 4261 | 51 |
874300 | 874300 | 2020-12-28 | Cumberland | Tennessee | 47035 | 4225 | 51 |
871055 | 871055 | 2020-12-27 | Cumberland | Tennessee | 47035 | 4207 | 49 |
867810 | 867810 | 2020-12-26 | Cumberland | Tennessee | 47035 | 4196 | 48 |
864565 | 864565 | 2020-12-25 | Cumberland | Tennessee | 47035 | 4156 | 48 |
861320 | 861320 | 2020-12-24 | Cumberland | Tennessee | 47035 | 4024 | 48 |
858075 | 858075 | 2020-12-23 | Cumberland | Tennessee | 47035 | 3982 | 48 |
854830 | 854830 | 2020-12-22 | Cumberland | Tennessee | 47035 | 3943 | 48 |
851585 | 851585 | 2020-12-21 | Cumberland | Tennessee | 47035 | 3909 | 48 |
848340 | 848340 | 2020-12-20 | Cumberland | Tennessee | 47035 | 3823 | 48 |
845095 | 845095 | 2020-12-19 | Cumberland | Tennessee | 47035 | 3723 | 48 |
841849 | 841849 | 2020-12-18 | Cumberland | Tennessee | 47035 | 3677 | 47 |
838604 | 838604 | 2020-12-17 | Cumberland | Tennessee | 47035 | 3574 | 47 |
835358 | 835358 | 2020-12-16 | Cumberland | Tennessee | 47035 | 3457 | 44 |
832112 | 832112 | 2020-12-15 | Cumberland | Tennessee | 47035 | 3392 | 44 |
828865 | 828865 | 2020-12-14 | Cumberland | Tennessee | 47035 | 3339 | 44 |
825619 | 825619 | 2020-12-13 | Cumberland | Tennessee | 47035 | 3235 | 44 |
822372 | 822372 | 2020-12-12 | Cumberland | Tennessee | 47035 | 3158 | 44 |
819126 | 819126 | 2020-12-11 | Cumberland | Tennessee | 47035 | 3076 | 43 |
815880 | 815880 | 2020-12-10 | Cumberland | Tennessee | 47035 | 3041 | 42 |
812634 | 812634 | 2020-12-09 | Cumberland | Tennessee | 47035 | 2989 | 42 |
809390 | 809390 | 2020-12-08 | Cumberland | Tennessee | 47035 | 2912 | 42 |
806145 | 806145 | 2020-12-07 | Cumberland | Tennessee | 47035 | 2897 | 41 |
802900 | 802900 | 2020-12-06 | Cumberland | Tennessee | 47035 | 2806 | 38 |
799655 | 799655 | 2020-12-05 | Cumberland | Tennessee | 47035 | 2777 | 38 |
796410 | 796410 | 2020-12-04 | Cumberland | Tennessee | 47035 | 2741 | 38 |
793165 | 793165 | 2020-12-03 | Cumberland | Tennessee | 47035 | 2729 | 37 |
789920 | 789920 | 2020-12-02 | Cumberland | Tennessee | 47035 | 2717 | 37 |
786675 | 786675 | 2020-12-01 | Cumberland | Tennessee | 47035 | 2699 | 37 |
783431 | 783431 | 2020-11-30 | Cumberland | Tennessee | 47035 | 2665 | 36 |
780186 | 780186 | 2020-11-29 | Cumberland | Tennessee | 47035 | 2611 | 36 |
776940 | 776940 | 2020-11-28 | Cumberland | Tennessee | 47035 | 2572 | 36 |
773695 | 773695 | 2020-11-27 | Cumberland | Tennessee | 47035 | 2485 | 36 |
770450 | 770450 | 2020-11-26 | Cumberland | Tennessee | 47035 | 2470 | 35 |
767204 | 767204 | 2020-11-25 | Cumberland | Tennessee | 47035 | 2453 | 35 |
763959 | 763959 | 2020-11-24 | Cumberland | Tennessee | 47035 | 2435 | 35 |
760714 | 760714 | 2020-11-23 | Cumberland | Tennessee | 47035 | 2423 | 35 |
757469 | 757469 | 2020-11-22 | Cumberland | Tennessee | 47035 | 2400 | 35 |
754222 | 754222 | 2020-11-21 | Cumberland | Tennessee | 47035 | 2365 | 34 |
750976 | 750976 | 2020-11-20 | Cumberland | Tennessee | 47035 | 2328 | 34 |
747730 | 747730 | 2020-11-19 | Cumberland | Tennessee | 47035 | 2271 | 34 |
744484 | 744484 | 2020-11-18 | Cumberland | Tennessee | 47035 | 2254 | 34 |
741237 | 741237 | 2020-11-17 | Cumberland | Tennessee | 47035 | 2224 | 33 |
737991 | 737991 | 2020-11-16 | Cumberland | Tennessee | 47035 | 2224 | 31 |
734747 | 734747 | 2020-11-15 | Cumberland | Tennessee | 47035 | 2171 | 31 |
731501 | 731501 | 2020-11-14 | Cumberland | Tennessee | 47035 | 2130 | 31 |
728257 | 728257 | 2020-11-13 | Cumberland | Tennessee | 47035 | 2079 | 31 |
725013 | 725013 | 2020-11-12 | Cumberland | Tennessee | 47035 | 2024 | 30 |
721770 | 721770 | 2020-11-11 | Cumberland | Tennessee | 47035 | 1995 | 30 |
718527 | 718527 | 2020-11-10 | Cumberland | Tennessee | 47035 | 1957 | 29 |
715284 | 715284 | 2020-11-09 | Cumberland | Tennessee | 47035 | 1946 | 29 |
712040 | 712040 | 2020-11-08 | Cumberland | Tennessee | 47035 | 1897 | 29 |
708796 | 708796 | 2020-11-07 | Cumberland | Tennessee | 47035 | 1872 | 29 |
705553 | 705553 | 2020-11-06 | Cumberland | Tennessee | 47035 | 1819 | 29 |
702310 | 702310 | 2020-11-05 | Cumberland | Tennessee | 47035 | 1786 | 29 |
699066 | 699066 | 2020-11-04 | Cumberland | Tennessee | 47035 | 1764 | 29 |
695823 | 695823 | 2020-11-03 | Cumberland | Tennessee | 47035 | 1735 | 28 |
692581 | 692581 | 2020-11-02 | Cumberland | Tennessee | 47035 | 1732 | 27 |
689337 | 689337 | 2020-11-01 | Cumberland | Tennessee | 47035 | 1708 | 27 |
686092 | 686092 | 2020-10-31 | Cumberland | Tennessee | 47035 | 1705 | 27 |
682849 | 682849 | 2020-10-30 | Cumberland | Tennessee | 47035 | 1698 | 27 |
679606 | 679606 | 2020-10-29 | Cumberland | Tennessee | 47035 | 1669 | 27 |
676363 | 676363 | 2020-10-28 | Cumberland | Tennessee | 47035 | 1651 | 27 |
673120 | 673120 | 2020-10-27 | Cumberland | Tennessee | 47035 | 1623 | 27 |
669878 | 669878 | 2020-10-26 | Cumberland | Tennessee | 47035 | 1613 | 27 |
666634 | 666634 | 2020-10-25 | Cumberland | Tennessee | 47035 | 1610 | 25 |
663389 | 663389 | 2020-10-24 | Cumberland | Tennessee | 47035 | 1595 | 25 |
660145 | 660145 | 2020-10-23 | Cumberland | Tennessee | 47035 | 1584 | 25 |
656901 | 656901 | 2020-10-22 | Cumberland | Tennessee | 47035 | 1561 | 24 |
653656 | 653656 | 2020-10-21 | Cumberland | Tennessee | 47035 | 1536 | 24 |
650411 | 650411 | 2020-10-20 | Cumberland | Tennessee | 47035 | 1501 | 24 |
647167 | 647167 | 2020-10-19 | Cumberland | Tennessee | 47035 | 1489 | 24 |
643921 | 643921 | 2020-10-18 | Cumberland | Tennessee | 47035 | 1477 | 24 |
640673 | 640673 | 2020-10-17 | Cumberland | Tennessee | 47035 | 1467 | 24 |
637427 | 637427 | 2020-10-16 | Cumberland | Tennessee | 47035 | 1449 | 24 |
634181 | 634181 | 2020-10-15 | Cumberland | Tennessee | 47035 | 1446 | 24 |
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);