ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Blount" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1091737 | 1091737 | 2021-03-05 | Blount | Tennessee | 47009 | 14167 | 184 |
1088491 | 1088491 | 2021-03-04 | Blount | Tennessee | 47009 | 14141 | 183 |
1085246 | 1085246 | 2021-03-03 | Blount | Tennessee | 47009 | 14106 | 182 |
1082000 | 1082000 | 2021-03-02 | Blount | Tennessee | 47009 | 14066 | 181 |
1078754 | 1078754 | 2021-03-01 | Blount | Tennessee | 47009 | 14050 | 181 |
1075509 | 1075509 | 2021-02-28 | Blount | Tennessee | 47009 | 14036 | 181 |
1072263 | 1072263 | 2021-02-27 | Blount | Tennessee | 47009 | 14017 | 181 |
1069017 | 1069017 | 2021-02-26 | Blount | Tennessee | 47009 | 13990 | 179 |
1065772 | 1065772 | 2021-02-25 | Blount | Tennessee | 47009 | 13959 | 178 |
1062527 | 1062527 | 2021-02-24 | Blount | Tennessee | 47009 | 13929 | 178 |
1059282 | 1059282 | 2021-02-23 | Blount | Tennessee | 47009 | 13905 | 176 |
1056036 | 1056036 | 2021-02-22 | Blount | Tennessee | 47009 | 13880 | 175 |
1052790 | 1052790 | 2021-02-21 | Blount | Tennessee | 47009 | 13868 | 175 |
1049543 | 1049543 | 2021-02-20 | Blount | Tennessee | 47009 | 13849 | 175 |
1046296 | 1046296 | 2021-02-19 | Blount | Tennessee | 47009 | 13831 | 174 |
1043051 | 1043051 | 2021-02-18 | Blount | Tennessee | 47009 | 13800 | 174 |
1039806 | 1039806 | 2021-02-17 | Blount | Tennessee | 47009 | 13778 | 171 |
1036561 | 1036561 | 2021-02-16 | Blount | Tennessee | 47009 | 13738 | 169 |
1033316 | 1033316 | 2021-02-15 | Blount | Tennessee | 47009 | 13695 | 169 |
1030070 | 1030070 | 2021-02-14 | Blount | Tennessee | 47009 | 13655 | 169 |
1026823 | 1026823 | 2021-02-13 | Blount | Tennessee | 47009 | 13611 | 169 |
1023578 | 1023578 | 2021-02-12 | Blount | Tennessee | 47009 | 13552 | 168 |
1020333 | 1020333 | 2021-02-11 | Blount | Tennessee | 47009 | 13509 | 166 |
1017088 | 1017088 | 2021-02-10 | Blount | Tennessee | 47009 | 13212 | 162 |
1013843 | 1013843 | 2021-02-09 | Blount | Tennessee | 47009 | 13074 | 158 |
1010598 | 1010598 | 2021-02-08 | Blount | Tennessee | 47009 | 13016 | 158 |
1007352 | 1007352 | 2021-02-07 | Blount | Tennessee | 47009 | 12972 | 158 |
1004106 | 1004106 | 2021-02-06 | Blount | Tennessee | 47009 | 12922 | 158 |
1000860 | 1000860 | 2021-02-05 | Blount | Tennessee | 47009 | 12854 | 157 |
997614 | 997614 | 2021-02-04 | Blount | Tennessee | 47009 | 12827 | 150 |
994368 | 994368 | 2021-02-03 | Blount | Tennessee | 47009 | 12756 | 146 |
991122 | 991122 | 2021-02-02 | Blount | Tennessee | 47009 | 12701 | 146 |
987876 | 987876 | 2021-02-01 | Blount | Tennessee | 47009 | 12668 | 144 |
984629 | 984629 | 2021-01-31 | Blount | Tennessee | 47009 | 12645 | 143 |
981382 | 981382 | 2021-01-30 | Blount | Tennessee | 47009 | 12622 | 143 |
978136 | 978136 | 2021-01-29 | Blount | Tennessee | 47009 | 12596 | 141 |
974891 | 974891 | 2021-01-28 | Blount | Tennessee | 47009 | 12550 | 140 |
971646 | 971646 | 2021-01-27 | Blount | Tennessee | 47009 | 12491 | 137 |
968401 | 968401 | 2021-01-26 | Blount | Tennessee | 47009 | 12443 | 136 |
965157 | 965157 | 2021-01-25 | Blount | Tennessee | 47009 | 12382 | 136 |
961912 | 961912 | 2021-01-24 | Blount | Tennessee | 47009 | 12366 | 134 |
958667 | 958667 | 2021-01-23 | Blount | Tennessee | 47009 | 12321 | 133 |
955421 | 955421 | 2021-01-22 | Blount | Tennessee | 47009 | 12267 | 132 |
952176 | 952176 | 2021-01-21 | Blount | Tennessee | 47009 | 12197 | 131 |
948931 | 948931 | 2021-01-20 | Blount | Tennessee | 47009 | 12146 | 127 |
945685 | 945685 | 2021-01-19 | Blount | Tennessee | 47009 | 12029 | 126 |
942438 | 942438 | 2021-01-18 | Blount | Tennessee | 47009 | 11914 | 125 |
939193 | 939193 | 2021-01-17 | Blount | Tennessee | 47009 | 11887 | 124 |
935948 | 935948 | 2021-01-16 | Blount | Tennessee | 47009 | 11784 | 123 |
932703 | 932703 | 2021-01-15 | Blount | Tennessee | 47009 | 11708 | 122 |
929458 | 929458 | 2021-01-14 | Blount | Tennessee | 47009 | 11537 | 120 |
926213 | 926213 | 2021-01-13 | Blount | Tennessee | 47009 | 11300 | 117 |
922967 | 922967 | 2021-01-12 | Blount | Tennessee | 47009 | 11245 | 112 |
919722 | 919722 | 2021-01-11 | Blount | Tennessee | 47009 | 11203 | 111 |
916477 | 916477 | 2021-01-10 | Blount | Tennessee | 47009 | 11127 | 110 |
913232 | 913232 | 2021-01-09 | Blount | Tennessee | 47009 | 11013 | 108 |
909987 | 909987 | 2021-01-08 | Blount | Tennessee | 47009 | 10905 | 107 |
906742 | 906742 | 2021-01-07 | Blount | Tennessee | 47009 | 10803 | 103 |
903496 | 903496 | 2021-01-06 | Blount | Tennessee | 47009 | 10632 | 101 |
900251 | 900251 | 2021-01-05 | Blount | Tennessee | 47009 | 10494 | 100 |
897006 | 897006 | 2021-01-04 | Blount | Tennessee | 47009 | 10433 | 99 |
893760 | 893760 | 2021-01-03 | Blount | Tennessee | 47009 | 10379 | 99 |
890514 | 890514 | 2021-01-02 | Blount | Tennessee | 47009 | 10324 | 99 |
887267 | 887267 | 2021-01-01 | Blount | Tennessee | 47009 | 9976 | 98 |
884022 | 884022 | 2020-12-31 | Blount | Tennessee | 47009 | 9976 | 98 |
880777 | 880777 | 2020-12-30 | Blount | Tennessee | 47009 | 9859 | 97 |
877532 | 877532 | 2020-12-29 | Blount | Tennessee | 47009 | 9602 | 96 |
874287 | 874287 | 2020-12-28 | Blount | Tennessee | 47009 | 9449 | 94 |
871042 | 871042 | 2020-12-27 | Blount | Tennessee | 47009 | 9365 | 94 |
867797 | 867797 | 2020-12-26 | Blount | Tennessee | 47009 | 9266 | 93 |
864552 | 864552 | 2020-12-25 | Blount | Tennessee | 47009 | 9164 | 93 |
861307 | 861307 | 2020-12-24 | Blount | Tennessee | 47009 | 9059 | 93 |
858062 | 858062 | 2020-12-23 | Blount | Tennessee | 47009 | 8984 | 93 |
854817 | 854817 | 2020-12-22 | Blount | Tennessee | 47009 | 8796 | 90 |
851572 | 851572 | 2020-12-21 | Blount | Tennessee | 47009 | 8721 | 87 |
848327 | 848327 | 2020-12-20 | Blount | Tennessee | 47009 | 8538 | 86 |
845082 | 845082 | 2020-12-19 | Blount | Tennessee | 47009 | 8387 | 84 |
841836 | 841836 | 2020-12-18 | Blount | Tennessee | 47009 | 8222 | 82 |
838591 | 838591 | 2020-12-17 | Blount | Tennessee | 47009 | 7982 | 80 |
835345 | 835345 | 2020-12-16 | Blount | Tennessee | 47009 | 7823 | 72 |
832099 | 832099 | 2020-12-15 | Blount | Tennessee | 47009 | 7610 | 71 |
828852 | 828852 | 2020-12-14 | Blount | Tennessee | 47009 | 7534 | 70 |
825606 | 825606 | 2020-12-13 | Blount | Tennessee | 47009 | 7342 | 68 |
822359 | 822359 | 2020-12-12 | Blount | Tennessee | 47009 | 7111 | 68 |
819113 | 819113 | 2020-12-11 | Blount | Tennessee | 47009 | 7015 | 68 |
815867 | 815867 | 2020-12-10 | Blount | Tennessee | 47009 | 6924 | 68 |
812621 | 812621 | 2020-12-09 | Blount | Tennessee | 47009 | 6821 | 68 |
809377 | 809377 | 2020-12-08 | Blount | Tennessee | 47009 | 6669 | 66 |
806132 | 806132 | 2020-12-07 | Blount | Tennessee | 47009 | 6559 | 66 |
802887 | 802887 | 2020-12-06 | Blount | Tennessee | 47009 | 6377 | 65 |
799642 | 799642 | 2020-12-05 | Blount | Tennessee | 47009 | 6283 | 64 |
796397 | 796397 | 2020-12-04 | Blount | Tennessee | 47009 | 6176 | 65 |
793152 | 793152 | 2020-12-03 | Blount | Tennessee | 47009 | 6089 | 63 |
789907 | 789907 | 2020-12-02 | Blount | Tennessee | 47009 | 5986 | 62 |
786662 | 786662 | 2020-12-01 | Blount | Tennessee | 47009 | 5863 | 62 |
783418 | 783418 | 2020-11-30 | Blount | Tennessee | 47009 | 5752 | 61 |
780173 | 780173 | 2020-11-29 | Blount | Tennessee | 47009 | 5531 | 61 |
776927 | 776927 | 2020-11-28 | Blount | Tennessee | 47009 | 5491 | 60 |
773682 | 773682 | 2020-11-27 | Blount | Tennessee | 47009 | 5406 | 60 |
770437 | 770437 | 2020-11-26 | Blount | Tennessee | 47009 | 5319 | 60 |
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);