ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Wichita" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1056370 | 1056370 | 2021-02-22 | Wichita | Texas | 48485 | 14469 | 334 |
1053124 | 1053124 | 2021-02-21 | Wichita | Texas | 48485 | 14358 | 333 |
1049877 | 1049877 | 2021-02-20 | Wichita | Texas | 48485 | 14358 | 332 |
1046630 | 1046630 | 2021-02-19 | Wichita | Texas | 48485 | 14358 | 330 |
1043385 | 1043385 | 2021-02-18 | Wichita | Texas | 48485 | 14358 | 330 |
1040140 | 1040140 | 2021-02-17 | Wichita | Texas | 48485 | 14358 | 330 |
1036895 | 1036895 | 2021-02-16 | Wichita | Texas | 48485 | 14358 | 328 |
1033650 | 1033650 | 2021-02-15 | Wichita | Texas | 48485 | 14358 | 328 |
1030404 | 1030404 | 2021-02-14 | Wichita | Texas | 48485 | 14358 | 328 |
1027157 | 1027157 | 2021-02-13 | Wichita | Texas | 48485 | 14358 | 327 |
1023912 | 1023912 | 2021-02-12 | Wichita | Texas | 48485 | 14358 | 326 |
1020667 | 1020667 | 2021-02-11 | Wichita | Texas | 48485 | 14338 | 322 |
1017422 | 1017422 | 2021-02-10 | Wichita | Texas | 48485 | 14301 | 320 |
1014177 | 1014177 | 2021-02-09 | Wichita | Texas | 48485 | 14269 | 317 |
1010932 | 1010932 | 2021-02-08 | Wichita | Texas | 48485 | 14226 | 315 |
1007686 | 1007686 | 2021-02-07 | Wichita | Texas | 48485 | 14175 | 315 |
1004440 | 1004440 | 2021-02-06 | Wichita | Texas | 48485 | 14175 | 315 |
1001194 | 1001194 | 2021-02-05 | Wichita | Texas | 48485 | 14175 | 315 |
997948 | 997948 | 2021-02-04 | Wichita | Texas | 48485 | 14133 | 315 |
994702 | 994702 | 2021-02-03 | Wichita | Texas | 48485 | 14077 | 301 |
991456 | 991456 | 2021-02-02 | Wichita | Texas | 48485 | 14037 | 297 |
988210 | 988210 | 2021-02-01 | Wichita | Texas | 48485 | 13973 | 295 |
984963 | 984963 | 2021-01-31 | Wichita | Texas | 48485 | 13883 | 295 |
981716 | 981716 | 2021-01-30 | Wichita | Texas | 48485 | 13883 | 295 |
978470 | 978470 | 2021-01-29 | Wichita | Texas | 48485 | 13883 | 292 |
975225 | 975225 | 2021-01-28 | Wichita | Texas | 48485 | 13844 | 291 |
971980 | 971980 | 2021-01-27 | Wichita | Texas | 48485 | 13804 | 289 |
968735 | 968735 | 2021-01-26 | Wichita | Texas | 48485 | 13731 | 288 |
965491 | 965491 | 2021-01-25 | Wichita | Texas | 48485 | 13687 | 283 |
962246 | 962246 | 2021-01-24 | Wichita | Texas | 48485 | 13585 | 283 |
959001 | 959001 | 2021-01-23 | Wichita | Texas | 48485 | 13585 | 283 |
955755 | 955755 | 2021-01-22 | Wichita | Texas | 48485 | 13585 | 275 |
952510 | 952510 | 2021-01-21 | Wichita | Texas | 48485 | 13541 | 267 |
949265 | 949265 | 2021-01-20 | Wichita | Texas | 48485 | 13480 | 264 |
946019 | 946019 | 2021-01-19 | Wichita | Texas | 48485 | 13325 | 260 |
942772 | 942772 | 2021-01-18 | Wichita | Texas | 48485 | 13325 | 258 |
939527 | 939527 | 2021-01-17 | Wichita | Texas | 48485 | 13179 | 258 |
936282 | 936282 | 2021-01-16 | Wichita | Texas | 48485 | 13179 | 257 |
933037 | 933037 | 2021-01-15 | Wichita | Texas | 48485 | 13179 | 255 |
929792 | 929792 | 2021-01-14 | Wichita | Texas | 48485 | 13068 | 250 |
926547 | 926547 | 2021-01-13 | Wichita | Texas | 48485 | 12774 | 248 |
923301 | 923301 | 2021-01-12 | Wichita | Texas | 48485 | 12774 | 245 |
920056 | 920056 | 2021-01-11 | Wichita | Texas | 48485 | 12595 | 242 |
916811 | 916811 | 2021-01-10 | Wichita | Texas | 48485 | 12345 | 241 |
913566 | 913566 | 2021-01-09 | Wichita | Texas | 48485 | 12345 | 241 |
910321 | 910321 | 2021-01-08 | Wichita | Texas | 48485 | 12345 | 237 |
907076 | 907076 | 2021-01-07 | Wichita | Texas | 48485 | 12169 | 231 |
903830 | 903830 | 2021-01-06 | Wichita | Texas | 48485 | 11938 | 228 |
900585 | 900585 | 2021-01-05 | Wichita | Texas | 48485 | 11691 | 225 |
897340 | 897340 | 2021-01-04 | Wichita | Texas | 48485 | 11544 | 219 |
894094 | 894094 | 2021-01-03 | Wichita | Texas | 48485 | 11047 | 219 |
890848 | 890848 | 2021-01-02 | Wichita | Texas | 48485 | 11047 | 219 |
887601 | 887601 | 2021-01-01 | Wichita | Texas | 48485 | 11047 | 218 |
884356 | 884356 | 2020-12-31 | Wichita | Texas | 48485 | 11047 | 216 |
881111 | 881111 | 2020-12-30 | Wichita | Texas | 48485 | 10770 | 210 |
877866 | 877866 | 2020-12-29 | Wichita | Texas | 48485 | 10592 | 202 |
874621 | 874621 | 2020-12-28 | Wichita | Texas | 48485 | 10292 | 197 |
871376 | 871376 | 2020-12-27 | Wichita | Texas | 48485 | 9852 | 195 |
868131 | 868131 | 2020-12-26 | Wichita | Texas | 48485 | 9852 | 194 |
864886 | 864886 | 2020-12-25 | Wichita | Texas | 48485 | 9852 | 194 |
861641 | 861641 | 2020-12-24 | Wichita | Texas | 48485 | 9852 | 192 |
858396 | 858396 | 2020-12-23 | Wichita | Texas | 48485 | 9852 | 191 |
855151 | 855151 | 2020-12-22 | Wichita | Texas | 48485 | 9733 | 189 |
851906 | 851906 | 2020-12-21 | Wichita | Texas | 48485 | 9551 | 187 |
848661 | 848661 | 2020-12-20 | Wichita | Texas | 48485 | 9322 | 183 |
845416 | 845416 | 2020-12-19 | Wichita | Texas | 48485 | 9322 | 182 |
842170 | 842170 | 2020-12-18 | Wichita | Texas | 48485 | 9322 | 180 |
838925 | 838925 | 2020-12-17 | Wichita | Texas | 48485 | 9186 | 178 |
835679 | 835679 | 2020-12-16 | Wichita | Texas | 48485 | 9085 | 177 |
832433 | 832433 | 2020-12-15 | Wichita | Texas | 48485 | 8937 | 175 |
829186 | 829186 | 2020-12-14 | Wichita | Texas | 48485 | 8795 | 172 |
825940 | 825940 | 2020-12-13 | Wichita | Texas | 48485 | 8574 | 170 |
822693 | 822693 | 2020-12-12 | Wichita | Texas | 48485 | 8574 | 169 |
819447 | 819447 | 2020-12-11 | Wichita | Texas | 48485 | 8574 | 167 |
816201 | 816201 | 2020-12-10 | Wichita | Texas | 48485 | 8451 | 161 |
812955 | 812955 | 2020-12-09 | Wichita | Texas | 48485 | 8310 | 155 |
809711 | 809711 | 2020-12-08 | Wichita | Texas | 48485 | 8143 | 152 |
806466 | 806466 | 2020-12-07 | Wichita | Texas | 48485 | 8007 | 146 |
803221 | 803221 | 2020-12-06 | Wichita | Texas | 48485 | 7766 | 145 |
799976 | 799976 | 2020-12-05 | Wichita | Texas | 48485 | 7766 | 143 |
796731 | 796731 | 2020-12-04 | Wichita | Texas | 48485 | 7766 | 141 |
793486 | 793486 | 2020-12-03 | Wichita | Texas | 48485 | 7612 | 136 |
790241 | 790241 | 2020-12-02 | Wichita | Texas | 48485 | 7469 | 135 |
786996 | 786996 | 2020-12-01 | Wichita | Texas | 48485 | 7299 | 125 |
783752 | 783752 | 2020-11-30 | Wichita | Texas | 48485 | 7120 | 123 |
780507 | 780507 | 2020-11-29 | Wichita | Texas | 48485 | 6818 | 122 |
777261 | 777261 | 2020-11-28 | Wichita | Texas | 48485 | 6818 | 120 |
774016 | 774016 | 2020-11-27 | Wichita | Texas | 48485 | 6818 | 117 |
770771 | 770771 | 2020-11-26 | Wichita | Texas | 48485 | 6818 | 116 |
767525 | 767525 | 2020-11-25 | Wichita | Texas | 48485 | 6818 | 116 |
764280 | 764280 | 2020-11-24 | Wichita | Texas | 48485 | 6668 | 110 |
761035 | 761035 | 2020-11-23 | Wichita | Texas | 48485 | 6461 | 104 |
757790 | 757790 | 2020-11-22 | Wichita | Texas | 48485 | 6141 | 102 |
754543 | 754543 | 2020-11-21 | Wichita | Texas | 48485 | 6141 | 101 |
751297 | 751297 | 2020-11-20 | Wichita | Texas | 48485 | 6141 | 98 |
748051 | 748051 | 2020-11-19 | Wichita | Texas | 48485 | 6023 | 97 |
744805 | 744805 | 2020-11-18 | Wichita | Texas | 48485 | 5853 | 93 |
741558 | 741558 | 2020-11-17 | Wichita | Texas | 48485 | 5707 | 90 |
738311 | 738311 | 2020-11-16 | Wichita | Texas | 48485 | 5558 | 88 |
735067 | 735067 | 2020-11-15 | Wichita | Texas | 48485 | 5350 | 88 |
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);