ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Hamblen" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1056063 | 1056063 | 2021-02-22 | Hamblen | Tennessee | 47063 | 7919 | 160 |
1052817 | 1052817 | 2021-02-21 | Hamblen | Tennessee | 47063 | 7918 | 161 |
1049570 | 1049570 | 2021-02-20 | Hamblen | Tennessee | 47063 | 7911 | 160 |
1046323 | 1046323 | 2021-02-19 | Hamblen | Tennessee | 47063 | 7890 | 161 |
1043078 | 1043078 | 2021-02-18 | Hamblen | Tennessee | 47063 | 7859 | 161 |
1039833 | 1039833 | 2021-02-17 | Hamblen | Tennessee | 47063 | 7838 | 157 |
1036588 | 1036588 | 2021-02-16 | Hamblen | Tennessee | 47063 | 7819 | 156 |
1033343 | 1033343 | 2021-02-15 | Hamblen | Tennessee | 47063 | 7788 | 156 |
1030097 | 1030097 | 2021-02-14 | Hamblen | Tennessee | 47063 | 7751 | 156 |
1026850 | 1026850 | 2021-02-13 | Hamblen | Tennessee | 47063 | 7710 | 156 |
1023605 | 1023605 | 2021-02-12 | Hamblen | Tennessee | 47063 | 7676 | 156 |
1020360 | 1020360 | 2021-02-11 | Hamblen | Tennessee | 47063 | 7658 | 153 |
1017115 | 1017115 | 2021-02-10 | Hamblen | Tennessee | 47063 | 7614 | 153 |
1013870 | 1013870 | 2021-02-09 | Hamblen | Tennessee | 47063 | 7623 | 151 |
1010625 | 1010625 | 2021-02-08 | Hamblen | Tennessee | 47063 | 7633 | 151 |
1007379 | 1007379 | 2021-02-07 | Hamblen | Tennessee | 47063 | 7626 | 151 |
1004133 | 1004133 | 2021-02-06 | Hamblen | Tennessee | 47063 | 7597 | 151 |
1000887 | 1000887 | 2021-02-05 | Hamblen | Tennessee | 47063 | 7540 | 149 |
997641 | 997641 | 2021-02-04 | Hamblen | Tennessee | 47063 | 7511 | 148 |
994395 | 994395 | 2021-02-03 | Hamblen | Tennessee | 47063 | 7483 | 144 |
991149 | 991149 | 2021-02-02 | Hamblen | Tennessee | 47063 | 7458 | 143 |
987903 | 987903 | 2021-02-01 | Hamblen | Tennessee | 47063 | 7440 | 144 |
984656 | 984656 | 2021-01-31 | Hamblen | Tennessee | 47063 | 7425 | 144 |
981409 | 981409 | 2021-01-30 | Hamblen | Tennessee | 47063 | 7400 | 144 |
978163 | 978163 | 2021-01-29 | Hamblen | Tennessee | 47063 | 7384 | 142 |
974918 | 974918 | 2021-01-28 | Hamblen | Tennessee | 47063 | 7341 | 141 |
971673 | 971673 | 2021-01-27 | Hamblen | Tennessee | 47063 | 7323 | 137 |
968428 | 968428 | 2021-01-26 | Hamblen | Tennessee | 47063 | 7286 | 128 |
965184 | 965184 | 2021-01-25 | Hamblen | Tennessee | 47063 | 7261 | 119 |
961939 | 961939 | 2021-01-24 | Hamblen | Tennessee | 47063 | 7244 | 118 |
958694 | 958694 | 2021-01-23 | Hamblen | Tennessee | 47063 | 7213 | 117 |
955448 | 955448 | 2021-01-22 | Hamblen | Tennessee | 47063 | 7172 | 117 |
952203 | 952203 | 2021-01-21 | Hamblen | Tennessee | 47063 | 7114 | 115 |
948958 | 948958 | 2021-01-20 | Hamblen | Tennessee | 47063 | 7088 | 112 |
945712 | 945712 | 2021-01-19 | Hamblen | Tennessee | 47063 | 7018 | 109 |
942465 | 942465 | 2021-01-18 | Hamblen | Tennessee | 47063 | 6990 | 109 |
939220 | 939220 | 2021-01-17 | Hamblen | Tennessee | 47063 | 6954 | 109 |
935975 | 935975 | 2021-01-16 | Hamblen | Tennessee | 47063 | 6910 | 109 |
932730 | 932730 | 2021-01-15 | Hamblen | Tennessee | 47063 | 6855 | 106 |
929485 | 929485 | 2021-01-14 | Hamblen | Tennessee | 47063 | 6779 | 106 |
926240 | 926240 | 2021-01-13 | Hamblen | Tennessee | 47063 | 6716 | 103 |
922994 | 922994 | 2021-01-12 | Hamblen | Tennessee | 47063 | 6660 | 102 |
919749 | 919749 | 2021-01-11 | Hamblen | Tennessee | 47063 | 6611 | 96 |
916504 | 916504 | 2021-01-10 | Hamblen | Tennessee | 47063 | 6576 | 96 |
913259 | 913259 | 2021-01-09 | Hamblen | Tennessee | 47063 | 6494 | 96 |
910014 | 910014 | 2021-01-08 | Hamblen | Tennessee | 47063 | 6441 | 95 |
906769 | 906769 | 2021-01-07 | Hamblen | Tennessee | 47063 | 6391 | 91 |
903523 | 903523 | 2021-01-06 | Hamblen | Tennessee | 47063 | 6289 | 91 |
900278 | 900278 | 2021-01-05 | Hamblen | Tennessee | 47063 | 6200 | 91 |
897033 | 897033 | 2021-01-04 | Hamblen | Tennessee | 47063 | 6142 | 90 |
893787 | 893787 | 2021-01-03 | Hamblen | Tennessee | 47063 | 6114 | 89 |
890541 | 890541 | 2021-01-02 | Hamblen | Tennessee | 47063 | 6044 | 89 |
887294 | 887294 | 2021-01-01 | Hamblen | Tennessee | 47063 | 5862 | 86 |
884049 | 884049 | 2020-12-31 | Hamblen | Tennessee | 47063 | 5862 | 86 |
880804 | 880804 | 2020-12-30 | Hamblen | Tennessee | 47063 | 5799 | 83 |
877559 | 877559 | 2020-12-29 | Hamblen | Tennessee | 47063 | 5718 | 80 |
874314 | 874314 | 2020-12-28 | Hamblen | Tennessee | 47063 | 5662 | 79 |
871069 | 871069 | 2020-12-27 | Hamblen | Tennessee | 47063 | 5617 | 78 |
867824 | 867824 | 2020-12-26 | Hamblen | Tennessee | 47063 | 5586 | 78 |
864579 | 864579 | 2020-12-25 | Hamblen | Tennessee | 47063 | 5536 | 77 |
861334 | 861334 | 2020-12-24 | Hamblen | Tennessee | 47063 | 5397 | 77 |
858089 | 858089 | 2020-12-23 | Hamblen | Tennessee | 47063 | 5360 | 75 |
854844 | 854844 | 2020-12-22 | Hamblen | Tennessee | 47063 | 5264 | 74 |
851599 | 851599 | 2020-12-21 | Hamblen | Tennessee | 47063 | 5268 | 72 |
848354 | 848354 | 2020-12-20 | Hamblen | Tennessee | 47063 | 5155 | 71 |
845109 | 845109 | 2020-12-19 | Hamblen | Tennessee | 47063 | 5063 | 71 |
841863 | 841863 | 2020-12-18 | Hamblen | Tennessee | 47063 | 4977 | 70 |
838618 | 838618 | 2020-12-17 | Hamblen | Tennessee | 47063 | 4873 | 70 |
835372 | 835372 | 2020-12-16 | Hamblen | Tennessee | 47063 | 4736 | 68 |
832126 | 832126 | 2020-12-15 | Hamblen | Tennessee | 47063 | 4652 | 68 |
828879 | 828879 | 2020-12-14 | Hamblen | Tennessee | 47063 | 4566 | 68 |
825633 | 825633 | 2020-12-13 | Hamblen | Tennessee | 47063 | 4457 | 67 |
822386 | 822386 | 2020-12-12 | Hamblen | Tennessee | 47063 | 4292 | 66 |
819140 | 819140 | 2020-12-11 | Hamblen | Tennessee | 47063 | 4244 | 65 |
815894 | 815894 | 2020-12-10 | Hamblen | Tennessee | 47063 | 4168 | 64 |
812648 | 812648 | 2020-12-09 | Hamblen | Tennessee | 47063 | 4118 | 64 |
809404 | 809404 | 2020-12-08 | Hamblen | Tennessee | 47063 | 3985 | 64 |
806159 | 806159 | 2020-12-07 | Hamblen | Tennessee | 47063 | 3961 | 63 |
802914 | 802914 | 2020-12-06 | Hamblen | Tennessee | 47063 | 3810 | 63 |
799669 | 799669 | 2020-12-05 | Hamblen | Tennessee | 47063 | 3788 | 63 |
796424 | 796424 | 2020-12-04 | Hamblen | Tennessee | 47063 | 3752 | 63 |
793179 | 793179 | 2020-12-03 | Hamblen | Tennessee | 47063 | 3724 | 62 |
789934 | 789934 | 2020-12-02 | Hamblen | Tennessee | 47063 | 3697 | 62 |
786689 | 786689 | 2020-12-01 | Hamblen | Tennessee | 47063 | 3679 | 61 |
783445 | 783445 | 2020-11-30 | Hamblen | Tennessee | 47063 | 3607 | 61 |
780200 | 780200 | 2020-11-29 | Hamblen | Tennessee | 47063 | 3501 | 61 |
776954 | 776954 | 2020-11-28 | Hamblen | Tennessee | 47063 | 3455 | 60 |
773709 | 773709 | 2020-11-27 | Hamblen | Tennessee | 47063 | 3408 | 60 |
770464 | 770464 | 2020-11-26 | Hamblen | Tennessee | 47063 | 3383 | 60 |
767218 | 767218 | 2020-11-25 | Hamblen | Tennessee | 47063 | 3360 | 59 |
763973 | 763973 | 2020-11-24 | Hamblen | Tennessee | 47063 | 3322 | 58 |
760728 | 760728 | 2020-11-23 | Hamblen | Tennessee | 47063 | 3315 | 57 |
757483 | 757483 | 2020-11-22 | Hamblen | Tennessee | 47063 | 3282 | 57 |
754236 | 754236 | 2020-11-21 | Hamblen | Tennessee | 47063 | 3214 | 57 |
750990 | 750990 | 2020-11-20 | Hamblen | Tennessee | 47063 | 3163 | 57 |
747744 | 747744 | 2020-11-19 | Hamblen | Tennessee | 47063 | 3131 | 57 |
744498 | 744498 | 2020-11-18 | Hamblen | Tennessee | 47063 | 3109 | 56 |
741251 | 741251 | 2020-11-17 | Hamblen | Tennessee | 47063 | 3084 | 56 |
738005 | 738005 | 2020-11-16 | Hamblen | Tennessee | 47063 | 3085 | 56 |
734761 | 734761 | 2020-11-15 | Hamblen | Tennessee | 47063 | 3034 | 56 |
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);