ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 47065 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
955449 | 955449 | 2021-01-22 | Hamilton | Tennessee | 47065 | 36834 | 337 |
952204 | 952204 | 2021-01-21 | Hamilton | Tennessee | 47065 | 36652 | 337 |
948959 | 948959 | 2021-01-20 | Hamilton | Tennessee | 47065 | 36447 | 332 |
945713 | 945713 | 2021-01-19 | Hamilton | Tennessee | 47065 | 36233 | 330 |
942466 | 942466 | 2021-01-18 | Hamilton | Tennessee | 47065 | 35891 | 327 |
939221 | 939221 | 2021-01-17 | Hamilton | Tennessee | 47065 | 35891 | 326 |
935976 | 935976 | 2021-01-16 | Hamilton | Tennessee | 47065 | 35708 | 326 |
932731 | 932731 | 2021-01-15 | Hamilton | Tennessee | 47065 | 35557 | 325 |
929486 | 929486 | 2021-01-14 | Hamilton | Tennessee | 47065 | 35328 | 323 |
926241 | 926241 | 2021-01-13 | Hamilton | Tennessee | 47065 | 35100 | 322 |
922995 | 922995 | 2021-01-12 | Hamilton | Tennessee | 47065 | 34744 | 319 |
919750 | 919750 | 2021-01-11 | Hamilton | Tennessee | 47065 | 34254 | 313 |
916505 | 916505 | 2021-01-10 | Hamilton | Tennessee | 47065 | 33829 | 305 |
913260 | 913260 | 2021-01-09 | Hamilton | Tennessee | 47065 | 33639 | 300 |
910015 | 910015 | 2021-01-08 | Hamilton | Tennessee | 47065 | 33139 | 299 |
906770 | 906770 | 2021-01-07 | Hamilton | Tennessee | 47065 | 32484 | 292 |
903524 | 903524 | 2021-01-06 | Hamilton | Tennessee | 47065 | 31878 | 286 |
900279 | 900279 | 2021-01-05 | Hamilton | Tennessee | 47065 | 31353 | 283 |
897034 | 897034 | 2021-01-04 | Hamilton | Tennessee | 47065 | 30810 | 282 |
893788 | 893788 | 2021-01-03 | Hamilton | Tennessee | 47065 | 30333 | 276 |
890542 | 890542 | 2021-01-02 | Hamilton | Tennessee | 47065 | 30035 | 275 |
887295 | 887295 | 2021-01-01 | Hamilton | Tennessee | 47065 | 29530 | 273 |
884050 | 884050 | 2020-12-31 | Hamilton | Tennessee | 47065 | 29530 | 273 |
880805 | 880805 | 2020-12-30 | Hamilton | Tennessee | 47065 | 28930 | 269 |
877560 | 877560 | 2020-12-29 | Hamilton | Tennessee | 47065 | 28283 | 264 |
874315 | 874315 | 2020-12-28 | Hamilton | Tennessee | 47065 | 27793 | 261 |
871070 | 871070 | 2020-12-27 | Hamilton | Tennessee | 47065 | 27410 | 260 |
867825 | 867825 | 2020-12-26 | Hamilton | Tennessee | 47065 | 27159 | 253 |
864580 | 864580 | 2020-12-25 | Hamilton | Tennessee | 47065 | 26718 | 252 |
861335 | 861335 | 2020-12-24 | Hamilton | Tennessee | 47065 | 26718 | 252 |
858090 | 858090 | 2020-12-23 | Hamilton | Tennessee | 47065 | 26718 | 251 |
854845 | 854845 | 2020-12-22 | Hamilton | Tennessee | 47065 | 26163 | 247 |
851600 | 851600 | 2020-12-21 | Hamilton | Tennessee | 47065 | 25644 | 241 |
848355 | 848355 | 2020-12-20 | Hamilton | Tennessee | 47065 | 25281 | 235 |
845110 | 845110 | 2020-12-19 | Hamilton | Tennessee | 47065 | 25108 | 234 |
841864 | 841864 | 2020-12-18 | Hamilton | Tennessee | 47065 | 24816 | 232 |
838619 | 838619 | 2020-12-17 | Hamilton | Tennessee | 47065 | 24511 | 229 |
835373 | 835373 | 2020-12-16 | Hamilton | Tennessee | 47065 | 24010 | 223 |
832127 | 832127 | 2020-12-15 | Hamilton | Tennessee | 47065 | 23510 | 224 |
828880 | 828880 | 2020-12-14 | Hamilton | Tennessee | 47065 | 23000 | 221 |
825634 | 825634 | 2020-12-13 | Hamilton | Tennessee | 47065 | 22633 | 212 |
822387 | 822387 | 2020-12-12 | Hamilton | Tennessee | 47065 | 22418 | 212 |
819141 | 819141 | 2020-12-11 | Hamilton | Tennessee | 47065 | 22108 | 206 |
815895 | 815895 | 2020-12-10 | Hamilton | Tennessee | 47065 | 21753 | 204 |
812649 | 812649 | 2020-12-09 | Hamilton | Tennessee | 47065 | 21440 | 200 |
809405 | 809405 | 2020-12-08 | Hamilton | Tennessee | 47065 | 21036 | 194 |
806160 | 806160 | 2020-12-07 | Hamilton | Tennessee | 47065 | 20602 | 182 |
802915 | 802915 | 2020-12-06 | Hamilton | Tennessee | 47065 | 20425 | 177 |
799670 | 799670 | 2020-12-05 | Hamilton | Tennessee | 47065 | 20225 | 177 |
796425 | 796425 | 2020-12-04 | Hamilton | Tennessee | 47065 | 19863 | 173 |
793180 | 793180 | 2020-12-03 | Hamilton | Tennessee | 47065 | 19501 | 164 |
789935 | 789935 | 2020-12-02 | Hamilton | Tennessee | 47065 | 19069 | 161 |
786690 | 786690 | 2020-12-01 | Hamilton | Tennessee | 47065 | 18602 | 158 |
783446 | 783446 | 2020-11-30 | Hamilton | Tennessee | 47065 | 18136 | 155 |
780201 | 780201 | 2020-11-29 | Hamilton | Tennessee | 47065 | 17826 | 153 |
776955 | 776955 | 2020-11-28 | Hamilton | Tennessee | 47065 | 17506 | 152 |
773710 | 773710 | 2020-11-27 | Hamilton | Tennessee | 47065 | 17191 | 152 |
770465 | 770465 | 2020-11-26 | Hamilton | Tennessee | 47065 | 17191 | 152 |
767219 | 767219 | 2020-11-25 | Hamilton | Tennessee | 47065 | 17191 | 149 |
763974 | 763974 | 2020-11-24 | Hamilton | Tennessee | 47065 | 16945 | 140 |
760729 | 760729 | 2020-11-23 | Hamilton | Tennessee | 47065 | 16681 | 136 |
757484 | 757484 | 2020-11-22 | Hamilton | Tennessee | 47065 | 16532 | 135 |
754237 | 754237 | 2020-11-21 | Hamilton | Tennessee | 47065 | 16331 | 134 |
750991 | 750991 | 2020-11-20 | Hamilton | Tennessee | 47065 | 16169 | 134 |
747745 | 747745 | 2020-11-19 | Hamilton | Tennessee | 47065 | 15938 | 134 |
744499 | 744499 | 2020-11-18 | Hamilton | Tennessee | 47065 | 15610 | 129 |
741252 | 741252 | 2020-11-17 | Hamilton | Tennessee | 47065 | 15351 | 126 |
738006 | 738006 | 2020-11-16 | Hamilton | Tennessee | 47065 | 15141 | 124 |
734762 | 734762 | 2020-11-15 | Hamilton | Tennessee | 47065 | 14948 | 123 |
731516 | 731516 | 2020-11-14 | Hamilton | Tennessee | 47065 | 14790 | 123 |
728272 | 728272 | 2020-11-13 | Hamilton | Tennessee | 47065 | 14635 | 123 |
725028 | 725028 | 2020-11-12 | Hamilton | Tennessee | 47065 | 14432 | 120 |
721785 | 721785 | 2020-11-11 | Hamilton | Tennessee | 47065 | 14217 | 119 |
718542 | 718542 | 2020-11-10 | Hamilton | Tennessee | 47065 | 14004 | 118 |
715299 | 715299 | 2020-11-09 | Hamilton | Tennessee | 47065 | 13744 | 117 |
712055 | 712055 | 2020-11-08 | Hamilton | Tennessee | 47065 | 13661 | 117 |
708811 | 708811 | 2020-11-07 | Hamilton | Tennessee | 47065 | 13510 | 117 |
705568 | 705568 | 2020-11-06 | Hamilton | Tennessee | 47065 | 13374 | 114 |
702325 | 702325 | 2020-11-05 | Hamilton | Tennessee | 47065 | 13213 | 114 |
699081 | 699081 | 2020-11-04 | Hamilton | Tennessee | 47065 | 13048 | 113 |
695838 | 695838 | 2020-11-03 | Hamilton | Tennessee | 47065 | 12926 | 113 |
692596 | 692596 | 2020-11-02 | Hamilton | Tennessee | 47065 | 12820 | 111 |
689352 | 689352 | 2020-11-01 | Hamilton | Tennessee | 47065 | 12728 | 111 |
686107 | 686107 | 2020-10-31 | Hamilton | Tennessee | 47065 | 12656 | 111 |
682864 | 682864 | 2020-10-30 | Hamilton | Tennessee | 47065 | 12563 | 111 |
679621 | 679621 | 2020-10-29 | Hamilton | Tennessee | 47065 | 12446 | 112 |
676378 | 676378 | 2020-10-28 | Hamilton | Tennessee | 47065 | 12312 | 111 |
673135 | 673135 | 2020-10-27 | Hamilton | Tennessee | 47065 | 12202 | 110 |
669893 | 669893 | 2020-10-26 | Hamilton | Tennessee | 47065 | 12069 | 109 |
666649 | 666649 | 2020-10-25 | Hamilton | Tennessee | 47065 | 11969 | 109 |
663404 | 663404 | 2020-10-24 | Hamilton | Tennessee | 47065 | 11860 | 108 |
660160 | 660160 | 2020-10-23 | Hamilton | Tennessee | 47065 | 11732 | 106 |
656916 | 656916 | 2020-10-22 | Hamilton | Tennessee | 47065 | 11628 | 106 |
653671 | 653671 | 2020-10-21 | Hamilton | Tennessee | 47065 | 11497 | 106 |
650426 | 650426 | 2020-10-20 | Hamilton | Tennessee | 47065 | 11386 | 105 |
647182 | 647182 | 2020-10-19 | Hamilton | Tennessee | 47065 | 11289 | 105 |
643936 | 643936 | 2020-10-18 | Hamilton | Tennessee | 47065 | 11204 | 105 |
640688 | 640688 | 2020-10-17 | Hamilton | Tennessee | 47065 | 11136 | 104 |
637442 | 637442 | 2020-10-16 | Hamilton | Tennessee | 47065 | 11082 | 104 |
634196 | 634196 | 2020-10-15 | Hamilton | Tennessee | 47065 | 10984 | 103 |
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);