ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where fips = 48437 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
939503 | 939503 | 2021-01-17 | Swisher | Texas | 48437 | 678 | 14 |
936258 | 936258 | 2021-01-16 | Swisher | Texas | 48437 | 678 | 14 |
933013 | 933013 | 2021-01-15 | Swisher | Texas | 48437 | 674 | 14 |
929768 | 929768 | 2021-01-14 | Swisher | Texas | 48437 | 673 | 14 |
926523 | 926523 | 2021-01-13 | Swisher | Texas | 48437 | 668 | 14 |
923277 | 923277 | 2021-01-12 | Swisher | Texas | 48437 | 662 | 14 |
920032 | 920032 | 2021-01-11 | Swisher | Texas | 48437 | 661 | 14 |
916787 | 916787 | 2021-01-10 | Swisher | Texas | 48437 | 661 | 14 |
913542 | 913542 | 2021-01-09 | Swisher | Texas | 48437 | 661 | 14 |
910297 | 910297 | 2021-01-08 | Swisher | Texas | 48437 | 658 | 14 |
907052 | 907052 | 2021-01-07 | Swisher | Texas | 48437 | 655 | 14 |
903806 | 903806 | 2021-01-06 | Swisher | Texas | 48437 | 651 | 14 |
900561 | 900561 | 2021-01-05 | Swisher | Texas | 48437 | 638 | 13 |
897316 | 897316 | 2021-01-04 | Swisher | Texas | 48437 | 633 | 13 |
894070 | 894070 | 2021-01-03 | Swisher | Texas | 48437 | 633 | 13 |
890824 | 890824 | 2021-01-02 | Swisher | Texas | 48437 | 633 | 13 |
887577 | 887577 | 2021-01-01 | Swisher | Texas | 48437 | 633 | 13 |
884332 | 884332 | 2020-12-31 | Swisher | Texas | 48437 | 623 | 13 |
881087 | 881087 | 2020-12-30 | Swisher | Texas | 48437 | 621 | 13 |
877842 | 877842 | 2020-12-29 | Swisher | Texas | 48437 | 615 | 12 |
874597 | 874597 | 2020-12-28 | Swisher | Texas | 48437 | 616 | 12 |
871352 | 871352 | 2020-12-27 | Swisher | Texas | 48437 | 616 | 12 |
868107 | 868107 | 2020-12-26 | Swisher | Texas | 48437 | 616 | 12 |
864862 | 864862 | 2020-12-25 | Swisher | Texas | 48437 | 616 | 12 |
861617 | 861617 | 2020-12-24 | Swisher | Texas | 48437 | 615 | 12 |
858372 | 858372 | 2020-12-23 | Swisher | Texas | 48437 | 615 | 12 |
855127 | 855127 | 2020-12-22 | Swisher | Texas | 48437 | 593 | 12 |
851882 | 851882 | 2020-12-21 | Swisher | Texas | 48437 | 588 | 12 |
848637 | 848637 | 2020-12-20 | Swisher | Texas | 48437 | 588 | 12 |
845392 | 845392 | 2020-12-19 | Swisher | Texas | 48437 | 588 | 12 |
842146 | 842146 | 2020-12-18 | Swisher | Texas | 48437 | 588 | 12 |
838901 | 838901 | 2020-12-17 | Swisher | Texas | 48437 | 582 | 11 |
835655 | 835655 | 2020-12-16 | Swisher | Texas | 48437 | 575 | 11 |
832409 | 832409 | 2020-12-15 | Swisher | Texas | 48437 | 567 | 11 |
829162 | 829162 | 2020-12-14 | Swisher | Texas | 48437 | 564 | 11 |
825916 | 825916 | 2020-12-13 | Swisher | Texas | 48437 | 564 | 11 |
822669 | 822669 | 2020-12-12 | Swisher | Texas | 48437 | 564 | 11 |
819423 | 819423 | 2020-12-11 | Swisher | Texas | 48437 | 562 | 11 |
816177 | 816177 | 2020-12-10 | Swisher | Texas | 48437 | 315 | 11 |
812931 | 812931 | 2020-12-09 | Swisher | Texas | 48437 | 312 | 10 |
809687 | 809687 | 2020-12-08 | Swisher | Texas | 48437 | 310 | 10 |
806442 | 806442 | 2020-12-07 | Swisher | Texas | 48437 | 308 | 10 |
803197 | 803197 | 2020-12-06 | Swisher | Texas | 48437 | 303 | 10 |
799952 | 799952 | 2020-12-05 | Swisher | Texas | 48437 | 303 | 10 |
796707 | 796707 | 2020-12-04 | Swisher | Texas | 48437 | 298 | 10 |
793462 | 793462 | 2020-12-03 | Swisher | Texas | 48437 | 292 | 9 |
790217 | 790217 | 2020-12-02 | Swisher | Texas | 48437 | 289 | 9 |
786972 | 786972 | 2020-12-01 | Swisher | Texas | 48437 | 281 | 9 |
783728 | 783728 | 2020-11-30 | Swisher | Texas | 48437 | 276 | 9 |
780483 | 780483 | 2020-11-29 | Swisher | Texas | 48437 | 276 | 9 |
777237 | 777237 | 2020-11-28 | Swisher | Texas | 48437 | 276 | 9 |
773992 | 773992 | 2020-11-27 | Swisher | Texas | 48437 | 270 | 8 |
770747 | 770747 | 2020-11-26 | Swisher | Texas | 48437 | 270 | 8 |
767501 | 767501 | 2020-11-25 | Swisher | Texas | 48437 | 256 | 8 |
764256 | 764256 | 2020-11-24 | Swisher | Texas | 48437 | 247 | 8 |
761011 | 761011 | 2020-11-23 | Swisher | Texas | 48437 | 239 | 8 |
757766 | 757766 | 2020-11-22 | Swisher | Texas | 48437 | 239 | 8 |
754519 | 754519 | 2020-11-21 | Swisher | Texas | 48437 | 239 | 8 |
751273 | 751273 | 2020-11-20 | Swisher | Texas | 48437 | 227 | 8 |
748027 | 748027 | 2020-11-19 | Swisher | Texas | 48437 | 220 | 7 |
744781 | 744781 | 2020-11-18 | Swisher | Texas | 48437 | 215 | 6 |
741534 | 741534 | 2020-11-17 | Swisher | Texas | 48437 | 215 | 6 |
738287 | 738287 | 2020-11-16 | Swisher | Texas | 48437 | 211 | 5 |
735043 | 735043 | 2020-11-15 | Swisher | Texas | 48437 | 208 | 5 |
731797 | 731797 | 2020-11-14 | Swisher | Texas | 48437 | 208 | 5 |
728552 | 728552 | 2020-11-13 | Swisher | Texas | 48437 | 205 | 5 |
725309 | 725309 | 2020-11-12 | Swisher | Texas | 48437 | 194 | 5 |
722066 | 722066 | 2020-11-11 | Swisher | Texas | 48437 | 194 | 5 |
718823 | 718823 | 2020-11-10 | Swisher | Texas | 48437 | 194 | 5 |
715580 | 715580 | 2020-11-09 | Swisher | Texas | 48437 | 191 | 5 |
712336 | 712336 | 2020-11-08 | Swisher | Texas | 48437 | 191 | 5 |
709092 | 709092 | 2020-11-07 | Swisher | Texas | 48437 | 191 | 5 |
705848 | 705848 | 2020-11-06 | Swisher | Texas | 48437 | 167 | 5 |
702605 | 702605 | 2020-11-05 | Swisher | Texas | 48437 | 167 | 5 |
699362 | 699362 | 2020-11-04 | Swisher | Texas | 48437 | 164 | 5 |
696118 | 696118 | 2020-11-03 | Swisher | Texas | 48437 | 162 | 5 |
692876 | 692876 | 2020-11-02 | Swisher | Texas | 48437 | 161 | 5 |
689632 | 689632 | 2020-11-01 | Swisher | Texas | 48437 | 161 | 5 |
686387 | 686387 | 2020-10-31 | Swisher | Texas | 48437 | 161 | 5 |
683144 | 683144 | 2020-10-30 | Swisher | Texas | 48437 | 149 | 5 |
679901 | 679901 | 2020-10-29 | Swisher | Texas | 48437 | 152 | 5 |
676658 | 676658 | 2020-10-28 | Swisher | Texas | 48437 | 152 | 3 |
673415 | 673415 | 2020-10-27 | Swisher | Texas | 48437 | 152 | 3 |
670173 | 670173 | 2020-10-26 | Swisher | Texas | 48437 | 146 | 3 |
666930 | 666930 | 2020-10-25 | Swisher | Texas | 48437 | 146 | 3 |
663685 | 663685 | 2020-10-24 | Swisher | Texas | 48437 | 146 | 3 |
660441 | 660441 | 2020-10-23 | Swisher | Texas | 48437 | 140 | 3 |
657197 | 657197 | 2020-10-22 | Swisher | Texas | 48437 | 137 | 3 |
653952 | 653952 | 2020-10-21 | Swisher | Texas | 48437 | 137 | 3 |
650707 | 650707 | 2020-10-20 | Swisher | Texas | 48437 | 135 | 3 |
647463 | 647463 | 2020-10-19 | Swisher | Texas | 48437 | 131 | 3 |
644217 | 644217 | 2020-10-18 | Swisher | Texas | 48437 | 131 | 3 |
640969 | 640969 | 2020-10-17 | Swisher | Texas | 48437 | 130 | 3 |
637722 | 637722 | 2020-10-16 | Swisher | Texas | 48437 | 129 | 3 |
634477 | 634477 | 2020-10-15 | Swisher | Texas | 48437 | 128 | 3 |
631232 | 631232 | 2020-10-14 | Swisher | Texas | 48437 | 126 | 3 |
627988 | 627988 | 2020-10-13 | Swisher | Texas | 48437 | 124 | 3 |
624745 | 624745 | 2020-10-12 | Swisher | Texas | 48437 | 119 | 3 |
621502 | 621502 | 2020-10-11 | Swisher | Texas | 48437 | 119 | 3 |
618259 | 618259 | 2020-10-10 | Swisher | Texas | 48437 | 119 | 3 |
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);