ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 48423 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1056339 | 1056339 | 2021-02-22 | Smith | Texas | 48423 | 18634 | 389 |
1053093 | 1053093 | 2021-02-21 | Smith | Texas | 48423 | 18555 | 388 |
1049846 | 1049846 | 2021-02-20 | Smith | Texas | 48423 | 18555 | 387 |
1046599 | 1046599 | 2021-02-19 | Smith | Texas | 48423 | 18555 | 387 |
1043354 | 1043354 | 2021-02-18 | Smith | Texas | 48423 | 18535 | 387 |
1040109 | 1040109 | 2021-02-17 | Smith | Texas | 48423 | 18535 | 387 |
1036864 | 1036864 | 2021-02-16 | Smith | Texas | 48423 | 18476 | 387 |
1033619 | 1033619 | 2021-02-15 | Smith | Texas | 48423 | 18366 | 387 |
1030373 | 1030373 | 2021-02-14 | Smith | Texas | 48423 | 18366 | 387 |
1027126 | 1027126 | 2021-02-13 | Smith | Texas | 48423 | 18366 | 387 |
1023881 | 1023881 | 2021-02-12 | Smith | Texas | 48423 | 18366 | 383 |
1020636 | 1020636 | 2021-02-11 | Smith | Texas | 48423 | 18230 | 381 |
1017391 | 1017391 | 2021-02-10 | Smith | Texas | 48423 | 18230 | 381 |
1014146 | 1014146 | 2021-02-09 | Smith | Texas | 48423 | 18100 | 378 |
1010901 | 1010901 | 2021-02-08 | Smith | Texas | 48423 | 18100 | 375 |
1007655 | 1007655 | 2021-02-07 | Smith | Texas | 48423 | 17952 | 375 |
1004409 | 1004409 | 2021-02-06 | Smith | Texas | 48423 | 17952 | 371 |
1001163 | 1001163 | 2021-02-05 | Smith | Texas | 48423 | 17952 | 367 |
997917 | 997917 | 2021-02-04 | Smith | Texas | 48423 | 17764 | 362 |
994671 | 994671 | 2021-02-03 | Smith | Texas | 48423 | 17764 | 355 |
991425 | 991425 | 2021-02-02 | Smith | Texas | 48423 | 17553 | 350 |
988179 | 988179 | 2021-02-01 | Smith | Texas | 48423 | 17553 | 347 |
984932 | 984932 | 2021-01-31 | Smith | Texas | 48423 | 17292 | 346 |
981685 | 981685 | 2021-01-30 | Smith | Texas | 48423 | 17292 | 346 |
978439 | 978439 | 2021-01-29 | Smith | Texas | 48423 | 17206 | 340 |
975194 | 975194 | 2021-01-28 | Smith | Texas | 48423 | 17206 | 338 |
971949 | 971949 | 2021-01-27 | Smith | Texas | 48423 | 16779 | 338 |
968704 | 968704 | 2021-01-26 | Smith | Texas | 48423 | 16779 | 329 |
965460 | 965460 | 2021-01-25 | Smith | Texas | 48423 | 16335 | 324 |
962215 | 962215 | 2021-01-24 | Smith | Texas | 48423 | 16335 | 324 |
958970 | 958970 | 2021-01-23 | Smith | Texas | 48423 | 16335 | 323 |
955724 | 955724 | 2021-01-22 | Smith | Texas | 48423 | 16335 | 318 |
952479 | 952479 | 2021-01-21 | Smith | Texas | 48423 | 16247 | 314 |
949234 | 949234 | 2021-01-20 | Smith | Texas | 48423 | 16247 | 312 |
945988 | 945988 | 2021-01-19 | Smith | Texas | 48423 | 15874 | 309 |
942741 | 942741 | 2021-01-18 | Smith | Texas | 48423 | 15407 | 307 |
939496 | 939496 | 2021-01-17 | Smith | Texas | 48423 | 15407 | 307 |
936251 | 936251 | 2021-01-16 | Smith | Texas | 48423 | 15407 | 303 |
933006 | 933006 | 2021-01-15 | Smith | Texas | 48423 | 15407 | 298 |
929761 | 929761 | 2021-01-14 | Smith | Texas | 48423 | 15248 | 295 |
926516 | 926516 | 2021-01-13 | Smith | Texas | 48423 | 14806 | 293 |
923270 | 923270 | 2021-01-12 | Smith | Texas | 48423 | 14526 | 292 |
920025 | 920025 | 2021-01-11 | Smith | Texas | 48423 | 13854 | 290 |
916780 | 916780 | 2021-01-10 | Smith | Texas | 48423 | 13854 | 289 |
913535 | 913535 | 2021-01-09 | Smith | Texas | 48423 | 13854 | 287 |
910290 | 910290 | 2021-01-08 | Smith | Texas | 48423 | 13854 | 284 |
907045 | 907045 | 2021-01-07 | Smith | Texas | 48423 | 13545 | 280 |
903799 | 903799 | 2021-01-06 | Smith | Texas | 48423 | 13544 | 273 |
900554 | 900554 | 2021-01-05 | Smith | Texas | 48423 | 13340 | 272 |
897309 | 897309 | 2021-01-04 | Smith | Texas | 48423 | 13161 | 269 |
894063 | 894063 | 2021-01-03 | Smith | Texas | 48423 | 12844 | 269 |
890817 | 890817 | 2021-01-02 | Smith | Texas | 48423 | 12844 | 269 |
887570 | 887570 | 2021-01-01 | Smith | Texas | 48423 | 12844 | 267 |
884325 | 884325 | 2020-12-31 | Smith | Texas | 48423 | 12844 | 261 |
881080 | 881080 | 2020-12-30 | Smith | Texas | 48423 | 12749 | 259 |
877835 | 877835 | 2020-12-29 | Smith | Texas | 48423 | 12614 | 256 |
874590 | 874590 | 2020-12-28 | Smith | Texas | 48423 | 12482 | 254 |
871345 | 871345 | 2020-12-27 | Smith | Texas | 48423 | 12138 | 252 |
868100 | 868100 | 2020-12-26 | Smith | Texas | 48423 | 12138 | 251 |
864855 | 864855 | 2020-12-25 | Smith | Texas | 48423 | 12138 | 251 |
861610 | 861610 | 2020-12-24 | Smith | Texas | 48423 | 12137 | 248 |
858365 | 858365 | 2020-12-23 | Smith | Texas | 48423 | 12137 | 243 |
855120 | 855120 | 2020-12-22 | Smith | Texas | 48423 | 12024 | 237 |
851875 | 851875 | 2020-12-21 | Smith | Texas | 48423 | 11900 | 235 |
848630 | 848630 | 2020-12-20 | Smith | Texas | 48423 | 11733 | 235 |
845385 | 845385 | 2020-12-19 | Smith | Texas | 48423 | 11733 | 235 |
842139 | 842139 | 2020-12-18 | Smith | Texas | 48423 | 11733 | 232 |
838894 | 838894 | 2020-12-17 | Smith | Texas | 48423 | 11659 | 226 |
835648 | 835648 | 2020-12-16 | Smith | Texas | 48423 | 11595 | 221 |
832402 | 832402 | 2020-12-15 | Smith | Texas | 48423 | 11503 | 219 |
829155 | 829155 | 2020-12-14 | Smith | Texas | 48423 | 11399 | 219 |
825909 | 825909 | 2020-12-13 | Smith | Texas | 48423 | 11225 | 219 |
822662 | 822662 | 2020-12-12 | Smith | Texas | 48423 | 11225 | 219 |
819416 | 819416 | 2020-12-11 | Smith | Texas | 48423 | 11225 | 218 |
816170 | 816170 | 2020-12-10 | Smith | Texas | 48423 | 11059 | 215 |
812924 | 812924 | 2020-12-09 | Smith | Texas | 48423 | 10939 | 213 |
809680 | 809680 | 2020-12-08 | Smith | Texas | 48423 | 10822 | 212 |
806435 | 806435 | 2020-12-07 | Smith | Texas | 48423 | 10650 | 211 |
803190 | 803190 | 2020-12-06 | Smith | Texas | 48423 | 10366 | 211 |
799945 | 799945 | 2020-12-05 | Smith | Texas | 48423 | 10366 | 211 |
796700 | 796700 | 2020-12-04 | Smith | Texas | 48423 | 10366 | 207 |
793455 | 793455 | 2020-12-03 | Smith | Texas | 48423 | 10162 | 204 |
790210 | 790210 | 2020-12-02 | Smith | Texas | 48423 | 9900 | 203 |
786965 | 786965 | 2020-12-01 | Smith | Texas | 48423 | 9790 | 203 |
783721 | 783721 | 2020-11-30 | Smith | Texas | 48423 | 9685 | 200 |
780476 | 780476 | 2020-11-29 | Smith | Texas | 48423 | 9393 | 196 |
777230 | 777230 | 2020-11-28 | Smith | Texas | 48423 | 9393 | 196 |
773985 | 773985 | 2020-11-27 | Smith | Texas | 48423 | 9393 | 196 |
770740 | 770740 | 2020-11-26 | Smith | Texas | 48423 | 9393 | 196 |
767494 | 767494 | 2020-11-25 | Smith | Texas | 48423 | 9393 | 196 |
764249 | 764249 | 2020-11-24 | Smith | Texas | 48423 | 9273 | 197 |
761004 | 761004 | 2020-11-23 | Smith | Texas | 48423 | 9139 | 192 |
757759 | 757759 | 2020-11-22 | Smith | Texas | 48423 | 9000 | 190 |
754512 | 754512 | 2020-11-21 | Smith | Texas | 48423 | 9000 | 190 |
751266 | 751266 | 2020-11-20 | Smith | Texas | 48423 | 9000 | 190 |
748020 | 748020 | 2020-11-19 | Smith | Texas | 48423 | 8862 | 189 |
744774 | 744774 | 2020-11-18 | Smith | Texas | 48423 | 8777 | 188 |
741527 | 741527 | 2020-11-17 | Smith | Texas | 48423 | 8540 | 189 |
738280 | 738280 | 2020-11-16 | Smith | Texas | 48423 | 8389 | 189 |
735036 | 735036 | 2020-11-15 | Smith | Texas | 48423 | 8038 | 187 |
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);