ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 48479 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923298 | 923298 | 2021-01-12 | Webb | Texas | 48479 | 29601 | 528 |
920053 | 920053 | 2021-01-11 | Webb | Texas | 48479 | 29601 | 528 |
916808 | 916808 | 2021-01-10 | Webb | Texas | 48479 | 28721 | 526 |
913563 | 913563 | 2021-01-09 | Webb | Texas | 48479 | 28721 | 526 |
910318 | 910318 | 2021-01-08 | Webb | Texas | 48479 | 28721 | 526 |
907073 | 907073 | 2021-01-07 | Webb | Texas | 48479 | 27686 | 523 |
903827 | 903827 | 2021-01-06 | Webb | Texas | 48479 | 27686 | 523 |
900582 | 900582 | 2021-01-05 | Webb | Texas | 48479 | 27393 | 516 |
897337 | 897337 | 2021-01-04 | Webb | Texas | 48479 | 26989 | 509 |
894091 | 894091 | 2021-01-03 | Webb | Texas | 48479 | 26989 | 509 |
890845 | 890845 | 2021-01-02 | Webb | Texas | 48479 | 26989 | 509 |
887598 | 887598 | 2021-01-01 | Webb | Texas | 48479 | 26989 | 509 |
884353 | 884353 | 2020-12-31 | Webb | Texas | 48479 | 26967 | 505 |
881108 | 881108 | 2020-12-30 | Webb | Texas | 48479 | 26821 | 505 |
877863 | 877863 | 2020-12-29 | Webb | Texas | 48479 | 26143 | 496 |
874618 | 874618 | 2020-12-28 | Webb | Texas | 48479 | 26143 | 496 |
871373 | 871373 | 2020-12-27 | Webb | Texas | 48479 | 25875 | 491 |
868128 | 868128 | 2020-12-26 | Webb | Texas | 48479 | 25514 | 485 |
864883 | 864883 | 2020-12-25 | Webb | Texas | 48479 | 25514 | 485 |
861638 | 861638 | 2020-12-24 | Webb | Texas | 48479 | 25514 | 485 |
858393 | 858393 | 2020-12-23 | Webb | Texas | 48479 | 24915 | 480 |
855148 | 855148 | 2020-12-22 | Webb | Texas | 48479 | 24915 | 480 |
851903 | 851903 | 2020-12-21 | Webb | Texas | 48479 | 24420 | 473 |
848658 | 848658 | 2020-12-20 | Webb | Texas | 48479 | 24420 | 473 |
845413 | 845413 | 2020-12-19 | Webb | Texas | 48479 | 23915 | 468 |
842167 | 842167 | 2020-12-18 | Webb | Texas | 48479 | 23915 | 468 |
838922 | 838922 | 2020-12-17 | Webb | Texas | 48479 | 23723 | 466 |
835676 | 835676 | 2020-12-16 | Webb | Texas | 48479 | 23503 | 462 |
832430 | 832430 | 2020-12-15 | Webb | Texas | 48479 | 23131 | 458 |
829183 | 829183 | 2020-12-14 | Webb | Texas | 48479 | 22971 | 452 |
825937 | 825937 | 2020-12-13 | Webb | Texas | 48479 | 22859 | 443 |
822690 | 822690 | 2020-12-12 | Webb | Texas | 48479 | 22750 | 441 |
819444 | 819444 | 2020-12-11 | Webb | Texas | 48479 | 22585 | 441 |
816198 | 816198 | 2020-12-10 | Webb | Texas | 48479 | 22540 | 438 |
812952 | 812952 | 2020-12-09 | Webb | Texas | 48479 | 22417 | 431 |
809708 | 809708 | 2020-12-08 | Webb | Texas | 48479 | 21587 | 420 |
806463 | 806463 | 2020-12-07 | Webb | Texas | 48479 | 21587 | 420 |
803218 | 803218 | 2020-12-06 | Webb | Texas | 48479 | 21268 | 419 |
799973 | 799973 | 2020-12-05 | Webb | Texas | 48479 | 21268 | 418 |
796728 | 796728 | 2020-12-04 | Webb | Texas | 48479 | 20731 | 417 |
793483 | 793483 | 2020-12-03 | Webb | Texas | 48479 | 20731 | 417 |
790238 | 790238 | 2020-12-02 | Webb | Texas | 48479 | 20280 | 411 |
786993 | 786993 | 2020-12-01 | Webb | Texas | 48479 | 20280 | 411 |
783749 | 783749 | 2020-11-30 | Webb | Texas | 48479 | 19703 | 398 |
780504 | 780504 | 2020-11-29 | Webb | Texas | 48479 | 19703 | 398 |
777258 | 777258 | 2020-11-28 | Webb | Texas | 48479 | 19703 | 398 |
774013 | 774013 | 2020-11-27 | Webb | Texas | 48479 | 19610 | 397 |
770768 | 770768 | 2020-11-26 | Webb | Texas | 48479 | 19500 | 397 |
767522 | 767522 | 2020-11-25 | Webb | Texas | 48479 | 19350 | 396 |
764277 | 764277 | 2020-11-24 | Webb | Texas | 48479 | 19204 | 394 |
761032 | 761032 | 2020-11-23 | Webb | Texas | 48479 | 18886 | 389 |
757787 | 757787 | 2020-11-22 | Webb | Texas | 48479 | 18821 | 388 |
754540 | 754540 | 2020-11-21 | Webb | Texas | 48479 | 18705 | 387 |
751294 | 751294 | 2020-11-20 | Webb | Texas | 48479 | 18369 | 386 |
748048 | 748048 | 2020-11-19 | Webb | Texas | 48479 | 18109 | 385 |
744802 | 744802 | 2020-11-18 | Webb | Texas | 48479 | 18109 | 385 |
741555 | 741555 | 2020-11-17 | Webb | Texas | 48479 | 17815 | 385 |
738308 | 738308 | 2020-11-16 | Webb | Texas | 48479 | 17450 | 379 |
735064 | 735064 | 2020-11-15 | Webb | Texas | 48479 | 17275 | 375 |
731818 | 731818 | 2020-11-14 | Webb | Texas | 48479 | 17164 | 374 |
728573 | 728573 | 2020-11-13 | Webb | Texas | 48479 | 16965 | 373 |
725330 | 725330 | 2020-11-12 | Webb | Texas | 48479 | 16692 | 371 |
722087 | 722087 | 2020-11-11 | Webb | Texas | 48479 | 16665 | 368 |
718844 | 718844 | 2020-11-10 | Webb | Texas | 48479 | 16558 | 367 |
715601 | 715601 | 2020-11-09 | Webb | Texas | 48479 | 16227 | 366 |
712357 | 712357 | 2020-11-08 | Webb | Texas | 48479 | 16161 | 363 |
709113 | 709113 | 2020-11-07 | Webb | Texas | 48479 | 15809 | 361 |
705869 | 705869 | 2020-11-06 | Webb | Texas | 48479 | 15809 | 361 |
702626 | 702626 | 2020-11-05 | Webb | Texas | 48479 | 15768 | 361 |
699383 | 699383 | 2020-11-04 | Webb | Texas | 48479 | 15656 | 361 |
696139 | 696139 | 2020-11-03 | Webb | Texas | 48479 | 15539 | 358 |
692897 | 692897 | 2020-11-02 | Webb | Texas | 48479 | 15502 | 357 |
689653 | 689653 | 2020-11-01 | Webb | Texas | 48479 | 15477 | 356 |
686408 | 686408 | 2020-10-31 | Webb | Texas | 48479 | 15455 | 356 |
683165 | 683165 | 2020-10-30 | Webb | Texas | 48479 | 15413 | 356 |
679922 | 679922 | 2020-10-29 | Webb | Texas | 48479 | 15371 | 356 |
676679 | 676679 | 2020-10-28 | Webb | Texas | 48479 | 15299 | 355 |
673436 | 673436 | 2020-10-27 | Webb | Texas | 48479 | 15175 | 355 |
670194 | 670194 | 2020-10-26 | Webb | Texas | 48479 | 15145 | 353 |
666951 | 666951 | 2020-10-25 | Webb | Texas | 48479 | 15106 | 352 |
663706 | 663706 | 2020-10-24 | Webb | Texas | 48479 | 15011 | 349 |
660462 | 660462 | 2020-10-23 | Webb | Texas | 48479 | 15011 | 349 |
657218 | 657218 | 2020-10-22 | Webb | Texas | 48479 | 14949 | 348 |
653973 | 653973 | 2020-10-21 | Webb | Texas | 48479 | 14949 | 348 |
650728 | 650728 | 2020-10-20 | Webb | Texas | 48479 | 14909 | 345 |
647484 | 647484 | 2020-10-19 | Webb | Texas | 48479 | 14833 | 343 |
644238 | 644238 | 2020-10-18 | Webb | Texas | 48479 | 14669 | 337 |
640990 | 640990 | 2020-10-17 | Webb | Texas | 48479 | 14669 | 337 |
637743 | 637743 | 2020-10-16 | Webb | Texas | 48479 | 14669 | 337 |
634498 | 634498 | 2020-10-15 | Webb | Texas | 48479 | 14669 | 337 |
631253 | 631253 | 2020-10-14 | Webb | Texas | 48479 | 14488 | 336 |
628009 | 628009 | 2020-10-13 | Webb | Texas | 48479 | 14473 | 333 |
624766 | 624766 | 2020-10-12 | Webb | Texas | 48479 | 14464 | 331 |
621523 | 621523 | 2020-10-11 | Webb | Texas | 48479 | 14364 | 329 |
618280 | 618280 | 2020-10-10 | Webb | Texas | 48479 | 14364 | 329 |
615038 | 615038 | 2020-10-09 | Webb | Texas | 48479 | 14364 | 329 |
611797 | 611797 | 2020-10-08 | Webb | Texas | 48479 | 14320 | 328 |
608555 | 608555 | 2020-10-07 | Webb | Texas | 48479 | 14301 | 326 |
605312 | 605312 | 2020-10-06 | Webb | Texas | 48479 | 14287 | 321 |
602070 | 602070 | 2020-10-05 | Webb | Texas | 48479 | 14156 | 315 |
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);