ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,114 rows where county = "Smith" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 4
- Texas 306
- Mississippi 299
- Tennessee 292
- Kansas 273
county 1
- Smith · 1,170 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921423 | 921423 | 2021-01-12 | Smith | Kansas | 20183 | 243 | 1 |
921916 | 921916 | 2021-01-12 | Smith | Mississippi | 28129 | 1150 | 22 |
923042 | 923042 | 2021-01-12 | Smith | Tennessee | 47159 | 2255 | 26 |
923270 | 923270 | 2021-01-12 | Smith | Texas | 48423 | 14526 | 292 |
918178 | 918178 | 2021-01-11 | Smith | Kansas | 20183 | 243 | 1 |
918671 | 918671 | 2021-01-11 | Smith | Mississippi | 28129 | 1142 | 20 |
919797 | 919797 | 2021-01-11 | Smith | Tennessee | 47159 | 2237 | 24 |
920025 | 920025 | 2021-01-11 | Smith | Texas | 48423 | 13854 | 290 |
914933 | 914933 | 2021-01-10 | Smith | Kansas | 20183 | 240 | 1 |
915426 | 915426 | 2021-01-10 | Smith | Mississippi | 28129 | 1140 | 20 |
916552 | 916552 | 2021-01-10 | Smith | Tennessee | 47159 | 2229 | 24 |
916780 | 916780 | 2021-01-10 | Smith | Texas | 48423 | 13854 | 289 |
911688 | 911688 | 2021-01-09 | Smith | Kansas | 20183 | 240 | 1 |
912181 | 912181 | 2021-01-09 | Smith | Mississippi | 28129 | 1132 | 20 |
913307 | 913307 | 2021-01-09 | Smith | Tennessee | 47159 | 2209 | 24 |
913535 | 913535 | 2021-01-09 | Smith | Texas | 48423 | 13854 | 287 |
908443 | 908443 | 2021-01-08 | Smith | Kansas | 20183 | 237 | 1 |
908936 | 908936 | 2021-01-08 | Smith | Mississippi | 28129 | 1122 | 20 |
910062 | 910062 | 2021-01-08 | Smith | Tennessee | 47159 | 2184 | 24 |
910290 | 910290 | 2021-01-08 | Smith | Texas | 48423 | 13854 | 284 |
905197 | 905197 | 2021-01-07 | Smith | Kansas | 20183 | 237 | 1 |
905690 | 905690 | 2021-01-07 | Smith | Mississippi | 28129 | 1112 | 20 |
906817 | 906817 | 2021-01-07 | Smith | Tennessee | 47159 | 2172 | 24 |
907045 | 907045 | 2021-01-07 | Smith | Texas | 48423 | 13545 | 280 |
901952 | 901952 | 2021-01-06 | Smith | Kansas | 20183 | 229 | 1 |
902445 | 902445 | 2021-01-06 | Smith | Mississippi | 28129 | 1090 | 20 |
903571 | 903571 | 2021-01-06 | Smith | Tennessee | 47159 | 2128 | 24 |
903799 | 903799 | 2021-01-06 | Smith | Texas | 48423 | 13544 | 273 |
898707 | 898707 | 2021-01-05 | Smith | Kansas | 20183 | 224 | 1 |
899200 | 899200 | 2021-01-05 | Smith | Mississippi | 28129 | 1079 | 20 |
900326 | 900326 | 2021-01-05 | Smith | Tennessee | 47159 | 2119 | 24 |
900554 | 900554 | 2021-01-05 | Smith | Texas | 48423 | 13340 | 272 |
895462 | 895462 | 2021-01-04 | Smith | Kansas | 20183 | 224 | 1 |
895955 | 895955 | 2021-01-04 | Smith | Mississippi | 28129 | 1072 | 20 |
897081 | 897081 | 2021-01-04 | Smith | Tennessee | 47159 | 2083 | 24 |
897309 | 897309 | 2021-01-04 | Smith | Texas | 48423 | 13161 | 269 |
892215 | 892215 | 2021-01-03 | Smith | Kansas | 20183 | 224 | 1 |
892708 | 892708 | 2021-01-03 | Smith | Mississippi | 28129 | 1061 | 20 |
893835 | 893835 | 2021-01-03 | Smith | Tennessee | 47159 | 2076 | 24 |
894063 | 894063 | 2021-01-03 | Smith | Texas | 48423 | 12844 | 269 |
888969 | 888969 | 2021-01-02 | Smith | Kansas | 20183 | 224 | 1 |
889462 | 889462 | 2021-01-02 | Smith | Mississippi | 28129 | 1049 | 20 |
890589 | 890589 | 2021-01-02 | Smith | Tennessee | 47159 | 2073 | 24 |
890817 | 890817 | 2021-01-02 | Smith | Texas | 48423 | 12844 | 269 |
885723 | 885723 | 2021-01-01 | Smith | Kansas | 20183 | 224 | 1 |
886216 | 886216 | 2021-01-01 | Smith | Mississippi | 28129 | 1036 | 20 |
887342 | 887342 | 2021-01-01 | Smith | Tennessee | 47159 | 2045 | 24 |
887570 | 887570 | 2021-01-01 | Smith | Texas | 48423 | 12844 | 267 |
882478 | 882478 | 2020-12-31 | Smith | Kansas | 20183 | 209 | 1 |
882971 | 882971 | 2020-12-31 | Smith | Mississippi | 28129 | 1021 | 20 |
884097 | 884097 | 2020-12-31 | Smith | Tennessee | 47159 | 2045 | 24 |
884325 | 884325 | 2020-12-31 | Smith | Texas | 48423 | 12844 | 261 |
879233 | 879233 | 2020-12-30 | Smith | Kansas | 20183 | 209 | 1 |
879726 | 879726 | 2020-12-30 | Smith | Mississippi | 28129 | 1010 | 20 |
880852 | 880852 | 2020-12-30 | Smith | Tennessee | 47159 | 2021 | 24 |
881080 | 881080 | 2020-12-30 | Smith | Texas | 48423 | 12749 | 259 |
875988 | 875988 | 2020-12-29 | Smith | Kansas | 20183 | 209 | 1 |
876481 | 876481 | 2020-12-29 | Smith | Mississippi | 28129 | 998 | 20 |
877607 | 877607 | 2020-12-29 | Smith | Tennessee | 47159 | 2015 | 23 |
877835 | 877835 | 2020-12-29 | Smith | Texas | 48423 | 12614 | 256 |
872743 | 872743 | 2020-12-28 | Smith | Kansas | 20183 | 209 | 1 |
873236 | 873236 | 2020-12-28 | Smith | Mississippi | 28129 | 990 | 19 |
874362 | 874362 | 2020-12-28 | Smith | Tennessee | 47159 | 2012 | 23 |
874590 | 874590 | 2020-12-28 | Smith | Texas | 48423 | 12482 | 254 |
869498 | 869498 | 2020-12-27 | Smith | Kansas | 20183 | 199 | 1 |
869991 | 869991 | 2020-12-27 | Smith | Mississippi | 28129 | 977 | 19 |
871117 | 871117 | 2020-12-27 | Smith | Tennessee | 47159 | 2004 | 23 |
871345 | 871345 | 2020-12-27 | Smith | Texas | 48423 | 12138 | 252 |
866253 | 866253 | 2020-12-26 | Smith | Kansas | 20183 | 199 | 1 |
866746 | 866746 | 2020-12-26 | Smith | Mississippi | 28129 | 971 | 18 |
867872 | 867872 | 2020-12-26 | Smith | Tennessee | 47159 | 2006 | 23 |
868100 | 868100 | 2020-12-26 | Smith | Texas | 48423 | 12138 | 251 |
863008 | 863008 | 2020-12-25 | Smith | Kansas | 20183 | 199 | 1 |
863501 | 863501 | 2020-12-25 | Smith | Mississippi | 28129 | 967 | 18 |
864627 | 864627 | 2020-12-25 | Smith | Tennessee | 47159 | 2003 | 23 |
864855 | 864855 | 2020-12-25 | Smith | Texas | 48423 | 12138 | 251 |
859763 | 859763 | 2020-12-24 | Smith | Kansas | 20183 | 199 | 1 |
860256 | 860256 | 2020-12-24 | Smith | Mississippi | 28129 | 956 | 18 |
861382 | 861382 | 2020-12-24 | Smith | Tennessee | 47159 | 1963 | 23 |
861610 | 861610 | 2020-12-24 | Smith | Texas | 48423 | 12137 | 248 |
856518 | 856518 | 2020-12-23 | Smith | Kansas | 20183 | 199 | 1 |
857011 | 857011 | 2020-12-23 | Smith | Mississippi | 28129 | 951 | 18 |
858137 | 858137 | 2020-12-23 | Smith | Tennessee | 47159 | 1955 | 23 |
858365 | 858365 | 2020-12-23 | Smith | Texas | 48423 | 12137 | 243 |
853273 | 853273 | 2020-12-22 | Smith | Kansas | 20183 | 199 | 1 |
853766 | 853766 | 2020-12-22 | Smith | Mississippi | 28129 | 946 | 17 |
854892 | 854892 | 2020-12-22 | Smith | Tennessee | 47159 | 1938 | 23 |
855120 | 855120 | 2020-12-22 | Smith | Texas | 48423 | 12024 | 237 |
850028 | 850028 | 2020-12-21 | Smith | Kansas | 20183 | 196 | 1 |
850521 | 850521 | 2020-12-21 | Smith | Mississippi | 28129 | 941 | 17 |
851647 | 851647 | 2020-12-21 | Smith | Tennessee | 47159 | 1925 | 23 |
851875 | 851875 | 2020-12-21 | Smith | Texas | 48423 | 11900 | 235 |
846783 | 846783 | 2020-12-20 | Smith | Kansas | 20183 | 196 | 1 |
847276 | 847276 | 2020-12-20 | Smith | Mississippi | 28129 | 933 | 17 |
848402 | 848402 | 2020-12-20 | Smith | Tennessee | 47159 | 1896 | 23 |
848630 | 848630 | 2020-12-20 | Smith | Texas | 48423 | 11733 | 235 |
843537 | 843537 | 2020-12-19 | Smith | Kansas | 20183 | 193 | 1 |
844030 | 844030 | 2020-12-19 | Smith | Mississippi | 28129 | 916 | 17 |
845157 | 845157 | 2020-12-19 | Smith | Tennessee | 47159 | 1863 | 23 |
845385 | 845385 | 2020-12-19 | Smith | Texas | 48423 | 11733 | 235 |
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);