ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where county = "Sevier" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1091810 | 1091810 | 2021-03-05 | Sevier | Tennessee | 47155 | 12127 | 165 |
1088564 | 1088564 | 2021-03-04 | Sevier | Tennessee | 47155 | 12109 | 164 |
1085319 | 1085319 | 2021-03-03 | Sevier | Tennessee | 47155 | 12065 | 164 |
1082073 | 1082073 | 2021-03-02 | Sevier | Tennessee | 47155 | 12038 | 163 |
1078827 | 1078827 | 2021-03-01 | Sevier | Tennessee | 47155 | 12023 | 163 |
1075582 | 1075582 | 2021-02-28 | Sevier | Tennessee | 47155 | 12011 | 163 |
1072336 | 1072336 | 2021-02-27 | Sevier | Tennessee | 47155 | 11993 | 163 |
1069090 | 1069090 | 2021-02-26 | Sevier | Tennessee | 47155 | 11967 | 163 |
1065845 | 1065845 | 2021-02-25 | Sevier | Tennessee | 47155 | 11930 | 161 |
1062600 | 1062600 | 2021-02-24 | Sevier | Tennessee | 47155 | 11889 | 161 |
1059355 | 1059355 | 2021-02-23 | Sevier | Tennessee | 47155 | 11870 | 160 |
1056109 | 1056109 | 2021-02-22 | Sevier | Tennessee | 47155 | 11837 | 159 |
1052863 | 1052863 | 2021-02-21 | Sevier | Tennessee | 47155 | 11829 | 159 |
1049616 | 1049616 | 2021-02-20 | Sevier | Tennessee | 47155 | 11813 | 159 |
1046369 | 1046369 | 2021-02-19 | Sevier | Tennessee | 47155 | 11784 | 158 |
1043124 | 1043124 | 2021-02-18 | Sevier | Tennessee | 47155 | 11751 | 158 |
1039879 | 1039879 | 2021-02-17 | Sevier | Tennessee | 47155 | 11731 | 157 |
1036634 | 1036634 | 2021-02-16 | Sevier | Tennessee | 47155 | 11698 | 156 |
1033389 | 1033389 | 2021-02-15 | Sevier | Tennessee | 47155 | 11674 | 154 |
1030143 | 1030143 | 2021-02-14 | Sevier | Tennessee | 47155 | 11646 | 154 |
1026896 | 1026896 | 2021-02-13 | Sevier | Tennessee | 47155 | 11610 | 153 |
1023651 | 1023651 | 2021-02-12 | Sevier | Tennessee | 47155 | 11573 | 152 |
1020406 | 1020406 | 2021-02-11 | Sevier | Tennessee | 47155 | 11531 | 150 |
1017161 | 1017161 | 2021-02-10 | Sevier | Tennessee | 47155 | 11462 | 149 |
1013916 | 1013916 | 2021-02-09 | Sevier | Tennessee | 47155 | 11430 | 149 |
1010671 | 1010671 | 2021-02-08 | Sevier | Tennessee | 47155 | 11394 | 146 |
1007425 | 1007425 | 2021-02-07 | Sevier | Tennessee | 47155 | 11372 | 146 |
1004179 | 1004179 | 2021-02-06 | Sevier | Tennessee | 47155 | 11338 | 146 |
1000933 | 1000933 | 2021-02-05 | Sevier | Tennessee | 47155 | 11285 | 144 |
997687 | 997687 | 2021-02-04 | Sevier | Tennessee | 47155 | 11253 | 142 |
994441 | 994441 | 2021-02-03 | Sevier | Tennessee | 47155 | 11194 | 139 |
991195 | 991195 | 2021-02-02 | Sevier | Tennessee | 47155 | 11170 | 136 |
987949 | 987949 | 2021-02-01 | Sevier | Tennessee | 47155 | 11137 | 134 |
984702 | 984702 | 2021-01-31 | Sevier | Tennessee | 47155 | 11121 | 134 |
981455 | 981455 | 2021-01-30 | Sevier | Tennessee | 47155 | 11070 | 133 |
978209 | 978209 | 2021-01-29 | Sevier | Tennessee | 47155 | 11019 | 133 |
974964 | 974964 | 2021-01-28 | Sevier | Tennessee | 47155 | 10981 | 132 |
971719 | 971719 | 2021-01-27 | Sevier | Tennessee | 47155 | 10945 | 129 |
968474 | 968474 | 2021-01-26 | Sevier | Tennessee | 47155 | 10910 | 128 |
965230 | 965230 | 2021-01-25 | Sevier | Tennessee | 47155 | 10877 | 123 |
961985 | 961985 | 2021-01-24 | Sevier | Tennessee | 47155 | 10839 | 122 |
958740 | 958740 | 2021-01-23 | Sevier | Tennessee | 47155 | 10787 | 121 |
955494 | 955494 | 2021-01-22 | Sevier | Tennessee | 47155 | 10704 | 120 |
952249 | 952249 | 2021-01-21 | Sevier | Tennessee | 47155 | 10663 | 116 |
949004 | 949004 | 2021-01-20 | Sevier | Tennessee | 47155 | 10589 | 110 |
945758 | 945758 | 2021-01-19 | Sevier | Tennessee | 47155 | 10534 | 108 |
942511 | 942511 | 2021-01-18 | Sevier | Tennessee | 47155 | 10495 | 108 |
939266 | 939266 | 2021-01-17 | Sevier | Tennessee | 47155 | 10461 | 108 |
936021 | 936021 | 2021-01-16 | Sevier | Tennessee | 47155 | 10406 | 108 |
932776 | 932776 | 2021-01-15 | Sevier | Tennessee | 47155 | 10320 | 108 |
929531 | 929531 | 2021-01-14 | Sevier | Tennessee | 47155 | 10243 | 103 |
926286 | 926286 | 2021-01-13 | Sevier | Tennessee | 47155 | 10112 | 99 |
923040 | 923040 | 2021-01-12 | Sevier | Tennessee | 47155 | 10056 | 99 |
919795 | 919795 | 2021-01-11 | Sevier | Tennessee | 47155 | 10001 | 90 |
916550 | 916550 | 2021-01-10 | Sevier | Tennessee | 47155 | 9947 | 88 |
913305 | 913305 | 2021-01-09 | Sevier | Tennessee | 47155 | 9823 | 86 |
910060 | 910060 | 2021-01-08 | Sevier | Tennessee | 47155 | 9704 | 85 |
906815 | 906815 | 2021-01-07 | Sevier | Tennessee | 47155 | 9595 | 84 |
903569 | 903569 | 2021-01-06 | Sevier | Tennessee | 47155 | 9450 | 78 |
900324 | 900324 | 2021-01-05 | Sevier | Tennessee | 47155 | 9366 | 76 |
897079 | 897079 | 2021-01-04 | Sevier | Tennessee | 47155 | 9317 | 76 |
893833 | 893833 | 2021-01-03 | Sevier | Tennessee | 47155 | 9265 | 73 |
890587 | 890587 | 2021-01-02 | Sevier | Tennessee | 47155 | 9180 | 73 |
887340 | 887340 | 2021-01-01 | Sevier | Tennessee | 47155 | 8901 | 70 |
884095 | 884095 | 2020-12-31 | Sevier | Tennessee | 47155 | 8901 | 70 |
880850 | 880850 | 2020-12-30 | Sevier | Tennessee | 47155 | 8818 | 70 |
877605 | 877605 | 2020-12-29 | Sevier | Tennessee | 47155 | 8704 | 67 |
874360 | 874360 | 2020-12-28 | Sevier | Tennessee | 47155 | 8667 | 64 |
871115 | 871115 | 2020-12-27 | Sevier | Tennessee | 47155 | 8583 | 63 |
867870 | 867870 | 2020-12-26 | Sevier | Tennessee | 47155 | 8505 | 63 |
864625 | 864625 | 2020-12-25 | Sevier | Tennessee | 47155 | 8382 | 63 |
861380 | 861380 | 2020-12-24 | Sevier | Tennessee | 47155 | 8218 | 63 |
858135 | 858135 | 2020-12-23 | Sevier | Tennessee | 47155 | 8154 | 60 |
854890 | 854890 | 2020-12-22 | Sevier | Tennessee | 47155 | 8033 | 60 |
851645 | 851645 | 2020-12-21 | Sevier | Tennessee | 47155 | 7993 | 58 |
848400 | 848400 | 2020-12-20 | Sevier | Tennessee | 47155 | 7742 | 58 |
845155 | 845155 | 2020-12-19 | Sevier | Tennessee | 47155 | 7527 | 57 |
841909 | 841909 | 2020-12-18 | Sevier | Tennessee | 47155 | 7359 | 55 |
838664 | 838664 | 2020-12-17 | Sevier | Tennessee | 47155 | 7146 | 54 |
835418 | 835418 | 2020-12-16 | Sevier | Tennessee | 47155 | 6993 | 54 |
832172 | 832172 | 2020-12-15 | Sevier | Tennessee | 47155 | 6770 | 54 |
828925 | 828925 | 2020-12-14 | Sevier | Tennessee | 47155 | 6594 | 50 |
825679 | 825679 | 2020-12-13 | Sevier | Tennessee | 47155 | 6453 | 47 |
822432 | 822432 | 2020-12-12 | Sevier | Tennessee | 47155 | 6206 | 46 |
819186 | 819186 | 2020-12-11 | Sevier | Tennessee | 47155 | 6126 | 44 |
815940 | 815940 | 2020-12-10 | Sevier | Tennessee | 47155 | 5964 | 42 |
812694 | 812694 | 2020-12-09 | Sevier | Tennessee | 47155 | 5862 | 41 |
809450 | 809450 | 2020-12-08 | Sevier | Tennessee | 47155 | 5646 | 41 |
806205 | 806205 | 2020-12-07 | Sevier | Tennessee | 47155 | 5579 | 40 |
802960 | 802960 | 2020-12-06 | Sevier | Tennessee | 47155 | 5409 | 39 |
799715 | 799715 | 2020-12-05 | Sevier | Tennessee | 47155 | 5384 | 39 |
796470 | 796470 | 2020-12-04 | Sevier | Tennessee | 47155 | 5317 | 38 |
793225 | 793225 | 2020-12-03 | Sevier | Tennessee | 47155 | 5287 | 35 |
789980 | 789980 | 2020-12-02 | Sevier | Tennessee | 47155 | 5238 | 33 |
786735 | 786735 | 2020-12-01 | Sevier | Tennessee | 47155 | 5219 | 33 |
783491 | 783491 | 2020-11-30 | Sevier | Tennessee | 47155 | 5121 | 33 |
780246 | 780246 | 2020-11-29 | Sevier | Tennessee | 47155 | 4937 | 31 |
777000 | 777000 | 2020-11-28 | Sevier | Tennessee | 47155 | 4848 | 31 |
773755 | 773755 | 2020-11-27 | Sevier | Tennessee | 47155 | 4768 | 31 |
770510 | 770510 | 2020-11-26 | Sevier | Tennessee | 47155 | 4738 | 31 |
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);