ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
770 rows where fips = 48457 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
939513 | 939513 | 2021-01-17 | Tyler | Texas | 48457 | 982 | 19 |
936268 | 936268 | 2021-01-16 | Tyler | Texas | 48457 | 1440 | 18 |
933023 | 933023 | 2021-01-15 | Tyler | Texas | 48457 | 1418 | 18 |
929778 | 929778 | 2021-01-14 | Tyler | Texas | 48457 | 1410 | 17 |
926533 | 926533 | 2021-01-13 | Tyler | Texas | 48457 | 1404 | 15 |
923287 | 923287 | 2021-01-12 | Tyler | Texas | 48457 | 1383 | 14 |
920042 | 920042 | 2021-01-11 | Tyler | Texas | 48457 | 1369 | 14 |
916797 | 916797 | 2021-01-10 | Tyler | Texas | 48457 | 1369 | 14 |
913552 | 913552 | 2021-01-09 | Tyler | Texas | 48457 | 1369 | 14 |
910307 | 910307 | 2021-01-08 | Tyler | Texas | 48457 | 1369 | 14 |
907062 | 907062 | 2021-01-07 | Tyler | Texas | 48457 | 889 | 14 |
903816 | 903816 | 2021-01-06 | Tyler | Texas | 48457 | 876 | 14 |
900571 | 900571 | 2021-01-05 | Tyler | Texas | 48457 | 876 | 12 |
897326 | 897326 | 2021-01-04 | Tyler | Texas | 48457 | 786 | 12 |
894080 | 894080 | 2021-01-03 | Tyler | Texas | 48457 | 786 | 12 |
890834 | 890834 | 2021-01-02 | Tyler | Texas | 48457 | 786 | 12 |
887587 | 887587 | 2021-01-01 | Tyler | Texas | 48457 | 786 | 11 |
884342 | 884342 | 2020-12-31 | Tyler | Texas | 48457 | 786 | 11 |
881097 | 881097 | 2020-12-30 | Tyler | Texas | 48457 | 786 | 11 |
877852 | 877852 | 2020-12-29 | Tyler | Texas | 48457 | 779 | 11 |
874607 | 874607 | 2020-12-28 | Tyler | Texas | 48457 | 733 | 11 |
871362 | 871362 | 2020-12-27 | Tyler | Texas | 48457 | 733 | 10 |
868117 | 868117 | 2020-12-26 | Tyler | Texas | 48457 | 733 | 10 |
864872 | 864872 | 2020-12-25 | Tyler | Texas | 48457 | 733 | 10 |
861627 | 861627 | 2020-12-24 | Tyler | Texas | 48457 | 733 | 10 |
858382 | 858382 | 2020-12-23 | Tyler | Texas | 48457 | 733 | 10 |
855137 | 855137 | 2020-12-22 | Tyler | Texas | 48457 | 729 | 9 |
851892 | 851892 | 2020-12-21 | Tyler | Texas | 48457 | 705 | 9 |
848647 | 848647 | 2020-12-20 | Tyler | Texas | 48457 | 690 | 9 |
845402 | 845402 | 2020-12-19 | Tyler | Texas | 48457 | 705 | 9 |
842156 | 842156 | 2020-12-18 | Tyler | Texas | 48457 | 690 | 9 |
838911 | 838911 | 2020-12-17 | Tyler | Texas | 48457 | 674 | 9 |
835665 | 835665 | 2020-12-16 | Tyler | Texas | 48457 | 670 | 8 |
832419 | 832419 | 2020-12-15 | Tyler | Texas | 48457 | 656 | 7 |
829172 | 829172 | 2020-12-14 | Tyler | Texas | 48457 | 656 | 7 |
825926 | 825926 | 2020-12-13 | Tyler | Texas | 48457 | 656 | 7 |
822679 | 822679 | 2020-12-12 | Tyler | Texas | 48457 | 656 | 7 |
819433 | 819433 | 2020-12-11 | Tyler | Texas | 48457 | 627 | 7 |
816187 | 816187 | 2020-12-10 | Tyler | Texas | 48457 | 344 | 7 |
812941 | 812941 | 2020-12-09 | Tyler | Texas | 48457 | 344 | 6 |
809697 | 809697 | 2020-12-08 | Tyler | Texas | 48457 | 334 | 6 |
806452 | 806452 | 2020-12-07 | Tyler | Texas | 48457 | 325 | 6 |
803207 | 803207 | 2020-12-06 | Tyler | Texas | 48457 | 325 | 6 |
799962 | 799962 | 2020-12-05 | Tyler | Texas | 48457 | 325 | 5 |
796717 | 796717 | 2020-12-04 | Tyler | Texas | 48457 | 325 | 5 |
793472 | 793472 | 2020-12-03 | Tyler | Texas | 48457 | 318 | 5 |
790227 | 790227 | 2020-12-02 | Tyler | Texas | 48457 | 318 | 5 |
786982 | 786982 | 2020-12-01 | Tyler | Texas | 48457 | 316 | 5 |
783738 | 783738 | 2020-11-30 | Tyler | Texas | 48457 | 305 | 5 |
780493 | 780493 | 2020-11-29 | Tyler | Texas | 48457 | 305 | 5 |
777247 | 777247 | 2020-11-28 | Tyler | Texas | 48457 | 305 | 5 |
774002 | 774002 | 2020-11-27 | Tyler | Texas | 48457 | 305 | 5 |
770757 | 770757 | 2020-11-26 | Tyler | Texas | 48457 | 305 | 5 |
767511 | 767511 | 2020-11-25 | Tyler | Texas | 48457 | 305 | 4 |
764266 | 764266 | 2020-11-24 | Tyler | Texas | 48457 | 304 | 4 |
761021 | 761021 | 2020-11-23 | Tyler | Texas | 48457 | 295 | 4 |
757776 | 757776 | 2020-11-22 | Tyler | Texas | 48457 | 295 | 4 |
754529 | 754529 | 2020-11-21 | Tyler | Texas | 48457 | 295 | 4 |
751283 | 751283 | 2020-11-20 | Tyler | Texas | 48457 | 295 | 4 |
748037 | 748037 | 2020-11-19 | Tyler | Texas | 48457 | 291 | 4 |
744791 | 744791 | 2020-11-18 | Tyler | Texas | 48457 | 291 | 4 |
741544 | 741544 | 2020-11-17 | Tyler | Texas | 48457 | 282 | 4 |
738297 | 738297 | 2020-11-16 | Tyler | Texas | 48457 | 282 | 4 |
735053 | 735053 | 2020-11-15 | Tyler | Texas | 48457 | 282 | 4 |
731807 | 731807 | 2020-11-14 | Tyler | Texas | 48457 | 280 | 4 |
728562 | 728562 | 2020-11-13 | Tyler | Texas | 48457 | 280 | 4 |
725319 | 725319 | 2020-11-12 | Tyler | Texas | 48457 | 279 | 4 |
722076 | 722076 | 2020-11-11 | Tyler | Texas | 48457 | 279 | 4 |
718833 | 718833 | 2020-11-10 | Tyler | Texas | 48457 | 280 | 4 |
715590 | 715590 | 2020-11-09 | Tyler | Texas | 48457 | 278 | 4 |
712346 | 712346 | 2020-11-08 | Tyler | Texas | 48457 | 278 | 4 |
709102 | 709102 | 2020-11-07 | Tyler | Texas | 48457 | 278 | 4 |
705858 | 705858 | 2020-11-06 | Tyler | Texas | 48457 | 278 | 4 |
702615 | 702615 | 2020-11-05 | Tyler | Texas | 48457 | 276 | 4 |
699372 | 699372 | 2020-11-04 | Tyler | Texas | 48457 | 276 | 4 |
696128 | 696128 | 2020-11-03 | Tyler | Texas | 48457 | 276 | 4 |
692886 | 692886 | 2020-11-02 | Tyler | Texas | 48457 | 273 | 4 |
689642 | 689642 | 2020-11-01 | Tyler | Texas | 48457 | 273 | 4 |
686397 | 686397 | 2020-10-31 | Tyler | Texas | 48457 | 273 | 4 |
683154 | 683154 | 2020-10-30 | Tyler | Texas | 48457 | 271 | 4 |
679911 | 679911 | 2020-10-29 | Tyler | Texas | 48457 | 269 | 4 |
676668 | 676668 | 2020-10-28 | Tyler | Texas | 48457 | 269 | 4 |
673425 | 673425 | 2020-10-27 | Tyler | Texas | 48457 | 261 | 4 |
670183 | 670183 | 2020-10-26 | Tyler | Texas | 48457 | 261 | 4 |
666940 | 666940 | 2020-10-25 | Tyler | Texas | 48457 | 260 | 4 |
663695 | 663695 | 2020-10-24 | Tyler | Texas | 48457 | 260 | 4 |
660451 | 660451 | 2020-10-23 | Tyler | Texas | 48457 | 259 | 4 |
657207 | 657207 | 2020-10-22 | Tyler | Texas | 48457 | 259 | 4 |
653962 | 653962 | 2020-10-21 | Tyler | Texas | 48457 | 259 | 4 |
650717 | 650717 | 2020-10-20 | Tyler | Texas | 48457 | 259 | 4 |
647473 | 647473 | 2020-10-19 | Tyler | Texas | 48457 | 252 | 4 |
644227 | 644227 | 2020-10-18 | Tyler | Texas | 48457 | 252 | 4 |
640979 | 640979 | 2020-10-17 | Tyler | Texas | 48457 | 252 | 4 |
637732 | 637732 | 2020-10-16 | Tyler | Texas | 48457 | 252 | 4 |
634487 | 634487 | 2020-10-15 | Tyler | Texas | 48457 | 250 | 4 |
631242 | 631242 | 2020-10-14 | Tyler | Texas | 48457 | 248 | 4 |
627998 | 627998 | 2020-10-13 | Tyler | Texas | 48457 | 242 | 4 |
624755 | 624755 | 2020-10-12 | Tyler | Texas | 48457 | 242 | 4 |
621512 | 621512 | 2020-10-11 | Tyler | Texas | 48457 | 242 | 4 |
618269 | 618269 | 2020-10-10 | Tyler | Texas | 48457 | 242 | 4 |
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);