ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
729 rows where fips = 48207 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
936143 | 936143 | 2021-01-16 | Haskell | Texas | 48207 | 355 | 13 |
932898 | 932898 | 2021-01-15 | Haskell | Texas | 48207 | 354 | 13 |
929653 | 929653 | 2021-01-14 | Haskell | Texas | 48207 | 353 | 13 |
926408 | 926408 | 2021-01-13 | Haskell | Texas | 48207 | 352 | 13 |
923162 | 923162 | 2021-01-12 | Haskell | Texas | 48207 | 350 | 13 |
919917 | 919917 | 2021-01-11 | Haskell | Texas | 48207 | 329 | 13 |
916672 | 916672 | 2021-01-10 | Haskell | Texas | 48207 | 329 | 13 |
913427 | 913427 | 2021-01-09 | Haskell | Texas | 48207 | 329 | 13 |
910182 | 910182 | 2021-01-08 | Haskell | Texas | 48207 | 326 | 13 |
906937 | 906937 | 2021-01-07 | Haskell | Texas | 48207 | 322 | 13 |
903691 | 903691 | 2021-01-06 | Haskell | Texas | 48207 | 319 | 13 |
900446 | 900446 | 2021-01-05 | Haskell | Texas | 48207 | 317 | 12 |
897201 | 897201 | 2021-01-04 | Haskell | Texas | 48207 | 315 | 11 |
893955 | 893955 | 2021-01-03 | Haskell | Texas | 48207 | 315 | 11 |
890709 | 890709 | 2021-01-02 | Haskell | Texas | 48207 | 315 | 11 |
887462 | 887462 | 2021-01-01 | Haskell | Texas | 48207 | 315 | 11 |
884217 | 884217 | 2020-12-31 | Haskell | Texas | 48207 | 314 | 11 |
880972 | 880972 | 2020-12-30 | Haskell | Texas | 48207 | 311 | 10 |
877727 | 877727 | 2020-12-29 | Haskell | Texas | 48207 | 304 | 10 |
874482 | 874482 | 2020-12-28 | Haskell | Texas | 48207 | 296 | 10 |
871237 | 871237 | 2020-12-27 | Haskell | Texas | 48207 | 296 | 10 |
867992 | 867992 | 2020-12-26 | Haskell | Texas | 48207 | 295 | 10 |
864747 | 864747 | 2020-12-25 | Haskell | Texas | 48207 | 295 | 10 |
861502 | 861502 | 2020-12-24 | Haskell | Texas | 48207 | 295 | 10 |
858257 | 858257 | 2020-12-23 | Haskell | Texas | 48207 | 291 | 8 |
855012 | 855012 | 2020-12-22 | Haskell | Texas | 48207 | 282 | 8 |
851767 | 851767 | 2020-12-21 | Haskell | Texas | 48207 | 279 | 8 |
848522 | 848522 | 2020-12-20 | Haskell | Texas | 48207 | 279 | 8 |
845277 | 845277 | 2020-12-19 | Haskell | Texas | 48207 | 279 | 8 |
842031 | 842031 | 2020-12-18 | Haskell | Texas | 48207 | 279 | 7 |
838786 | 838786 | 2020-12-17 | Haskell | Texas | 48207 | 275 | 6 |
835540 | 835540 | 2020-12-16 | Haskell | Texas | 48207 | 242 | 5 |
832294 | 832294 | 2020-12-15 | Haskell | Texas | 48207 | 239 | 5 |
829047 | 829047 | 2020-12-14 | Haskell | Texas | 48207 | 220 | 5 |
825801 | 825801 | 2020-12-13 | Haskell | Texas | 48207 | 220 | 5 |
822554 | 822554 | 2020-12-12 | Haskell | Texas | 48207 | 220 | 5 |
819308 | 819308 | 2020-12-11 | Haskell | Texas | 48207 | 213 | 5 |
816062 | 816062 | 2020-12-10 | Haskell | Texas | 48207 | 107 | 5 |
812816 | 812816 | 2020-12-09 | Haskell | Texas | 48207 | 107 | 5 |
809572 | 809572 | 2020-12-08 | Haskell | Texas | 48207 | 106 | 5 |
806327 | 806327 | 2020-12-07 | Haskell | Texas | 48207 | 105 | 5 |
803082 | 803082 | 2020-12-06 | Haskell | Texas | 48207 | 105 | 5 |
799837 | 799837 | 2020-12-05 | Haskell | Texas | 48207 | 105 | 5 |
796592 | 796592 | 2020-12-04 | Haskell | Texas | 48207 | 104 | 5 |
793347 | 793347 | 2020-12-03 | Haskell | Texas | 48207 | 103 | 5 |
790102 | 790102 | 2020-12-02 | Haskell | Texas | 48207 | 97 | 5 |
786857 | 786857 | 2020-12-01 | Haskell | Texas | 48207 | 96 | 5 |
783613 | 783613 | 2020-11-30 | Haskell | Texas | 48207 | 96 | 5 |
780368 | 780368 | 2020-11-29 | Haskell | Texas | 48207 | 96 | 5 |
777122 | 777122 | 2020-11-28 | Haskell | Texas | 48207 | 96 | 5 |
773877 | 773877 | 2020-11-27 | Haskell | Texas | 48207 | 96 | 5 |
770632 | 770632 | 2020-11-26 | Haskell | Texas | 48207 | 96 | 5 |
767386 | 767386 | 2020-11-25 | Haskell | Texas | 48207 | 96 | 4 |
764141 | 764141 | 2020-11-24 | Haskell | Texas | 48207 | 96 | 3 |
760896 | 760896 | 2020-11-23 | Haskell | Texas | 48207 | 95 | 3 |
757651 | 757651 | 2020-11-22 | Haskell | Texas | 48207 | 95 | 3 |
754404 | 754404 | 2020-11-21 | Haskell | Texas | 48207 | 95 | 3 |
751158 | 751158 | 2020-11-20 | Haskell | Texas | 48207 | 94 | 3 |
747912 | 747912 | 2020-11-19 | Haskell | Texas | 48207 | 93 | 3 |
744666 | 744666 | 2020-11-18 | Haskell | Texas | 48207 | 93 | 3 |
741419 | 741419 | 2020-11-17 | Haskell | Texas | 48207 | 93 | 3 |
738173 | 738173 | 2020-11-16 | Haskell | Texas | 48207 | 92 | 3 |
734929 | 734929 | 2020-11-15 | Haskell | Texas | 48207 | 92 | 3 |
731683 | 731683 | 2020-11-14 | Haskell | Texas | 48207 | 92 | 3 |
728438 | 728438 | 2020-11-13 | Haskell | Texas | 48207 | 92 | 3 |
725195 | 725195 | 2020-11-12 | Haskell | Texas | 48207 | 90 | 3 |
721952 | 721952 | 2020-11-11 | Haskell | Texas | 48207 | 90 | 3 |
718709 | 718709 | 2020-11-10 | Haskell | Texas | 48207 | 90 | 3 |
715466 | 715466 | 2020-11-09 | Haskell | Texas | 48207 | 90 | 3 |
712222 | 712222 | 2020-11-08 | Haskell | Texas | 48207 | 90 | 3 |
708978 | 708978 | 2020-11-07 | Haskell | Texas | 48207 | 90 | 3 |
705734 | 705734 | 2020-11-06 | Haskell | Texas | 48207 | 90 | 3 |
702491 | 702491 | 2020-11-05 | Haskell | Texas | 48207 | 90 | 3 |
699248 | 699248 | 2020-11-04 | Haskell | Texas | 48207 | 89 | 3 |
696004 | 696004 | 2020-11-03 | Haskell | Texas | 48207 | 89 | 3 |
692762 | 692762 | 2020-11-02 | Haskell | Texas | 48207 | 86 | 3 |
689518 | 689518 | 2020-11-01 | Haskell | Texas | 48207 | 86 | 3 |
686273 | 686273 | 2020-10-31 | Haskell | Texas | 48207 | 86 | 3 |
683030 | 683030 | 2020-10-30 | Haskell | Texas | 48207 | 86 | 3 |
679787 | 679787 | 2020-10-29 | Haskell | Texas | 48207 | 85 | 3 |
676544 | 676544 | 2020-10-28 | Haskell | Texas | 48207 | 83 | 3 |
673301 | 673301 | 2020-10-27 | Haskell | Texas | 48207 | 83 | 3 |
670059 | 670059 | 2020-10-26 | Haskell | Texas | 48207 | 80 | 3 |
666816 | 666816 | 2020-10-25 | Haskell | Texas | 48207 | 80 | 3 |
663571 | 663571 | 2020-10-24 | Haskell | Texas | 48207 | 80 | 3 |
660327 | 660327 | 2020-10-23 | Haskell | Texas | 48207 | 78 | 3 |
657083 | 657083 | 2020-10-22 | Haskell | Texas | 48207 | 78 | 3 |
653838 | 653838 | 2020-10-21 | Haskell | Texas | 48207 | 78 | 3 |
650593 | 650593 | 2020-10-20 | Haskell | Texas | 48207 | 77 | 3 |
647349 | 647349 | 2020-10-19 | Haskell | Texas | 48207 | 77 | 3 |
644103 | 644103 | 2020-10-18 | Haskell | Texas | 48207 | 77 | 3 |
640855 | 640855 | 2020-10-17 | Haskell | Texas | 48207 | 77 | 3 |
637608 | 637608 | 2020-10-16 | Haskell | Texas | 48207 | 75 | 3 |
634363 | 634363 | 2020-10-15 | Haskell | Texas | 48207 | 75 | 3 |
631118 | 631118 | 2020-10-14 | Haskell | Texas | 48207 | 74 | 3 |
627874 | 627874 | 2020-10-13 | Haskell | Texas | 48207 | 74 | 3 |
624632 | 624632 | 2020-10-12 | Haskell | Texas | 48207 | 73 | 3 |
621389 | 621389 | 2020-10-11 | Haskell | Texas | 48207 | 73 | 3 |
618146 | 618146 | 2020-10-10 | Haskell | Texas | 48207 | 73 | 3 |
614904 | 614904 | 2020-10-09 | Haskell | Texas | 48207 | 73 | 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);