ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
766 rows where fips = 48153 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923135 | 923135 | 2021-01-12 | Floyd | Texas | 48153 | 616 | 25 |
919890 | 919890 | 2021-01-11 | Floyd | Texas | 48153 | 611 | 25 |
916645 | 916645 | 2021-01-10 | Floyd | Texas | 48153 | 611 | 25 |
913400 | 913400 | 2021-01-09 | Floyd | Texas | 48153 | 611 | 24 |
910155 | 910155 | 2021-01-08 | Floyd | Texas | 48153 | 607 | 24 |
906910 | 906910 | 2021-01-07 | Floyd | Texas | 48153 | 602 | 23 |
903664 | 903664 | 2021-01-06 | Floyd | Texas | 48153 | 596 | 23 |
900419 | 900419 | 2021-01-05 | Floyd | Texas | 48153 | 579 | 23 |
897174 | 897174 | 2021-01-04 | Floyd | Texas | 48153 | 563 | 23 |
893928 | 893928 | 2021-01-03 | Floyd | Texas | 48153 | 563 | 23 |
890682 | 890682 | 2021-01-02 | Floyd | Texas | 48153 | 563 | 23 |
887435 | 887435 | 2021-01-01 | Floyd | Texas | 48153 | 563 | 23 |
884190 | 884190 | 2020-12-31 | Floyd | Texas | 48153 | 527 | 21 |
880945 | 880945 | 2020-12-30 | Floyd | Texas | 48153 | 517 | 21 |
877700 | 877700 | 2020-12-29 | Floyd | Texas | 48153 | 516 | 21 |
874455 | 874455 | 2020-12-28 | Floyd | Texas | 48153 | 517 | 21 |
871210 | 871210 | 2020-12-27 | Floyd | Texas | 48153 | 517 | 21 |
867965 | 867965 | 2020-12-26 | Floyd | Texas | 48153 | 517 | 21 |
864720 | 864720 | 2020-12-25 | Floyd | Texas | 48153 | 517 | 21 |
861475 | 861475 | 2020-12-24 | Floyd | Texas | 48153 | 517 | 21 |
858230 | 858230 | 2020-12-23 | Floyd | Texas | 48153 | 515 | 21 |
854985 | 854985 | 2020-12-22 | Floyd | Texas | 48153 | 502 | 21 |
851740 | 851740 | 2020-12-21 | Floyd | Texas | 48153 | 499 | 21 |
848495 | 848495 | 2020-12-20 | Floyd | Texas | 48153 | 499 | 21 |
845250 | 845250 | 2020-12-19 | Floyd | Texas | 48153 | 499 | 21 |
842004 | 842004 | 2020-12-18 | Floyd | Texas | 48153 | 494 | 19 |
838759 | 838759 | 2020-12-17 | Floyd | Texas | 48153 | 489 | 17 |
835513 | 835513 | 2020-12-16 | Floyd | Texas | 48153 | 487 | 17 |
832267 | 832267 | 2020-12-15 | Floyd | Texas | 48153 | 480 | 16 |
829020 | 829020 | 2020-12-14 | Floyd | Texas | 48153 | 466 | 16 |
825774 | 825774 | 2020-12-13 | Floyd | Texas | 48153 | 466 | 16 |
822527 | 822527 | 2020-12-12 | Floyd | Texas | 48153 | 466 | 16 |
819281 | 819281 | 2020-12-11 | Floyd | Texas | 48153 | 461 | 16 |
816035 | 816035 | 2020-12-10 | Floyd | Texas | 48153 | 212 | 16 |
812789 | 812789 | 2020-12-09 | Floyd | Texas | 48153 | 211 | 16 |
809545 | 809545 | 2020-12-08 | Floyd | Texas | 48153 | 202 | 16 |
806300 | 806300 | 2020-12-07 | Floyd | Texas | 48153 | 200 | 16 |
803055 | 803055 | 2020-12-06 | Floyd | Texas | 48153 | 200 | 16 |
799810 | 799810 | 2020-12-05 | Floyd | Texas | 48153 | 200 | 16 |
796565 | 796565 | 2020-12-04 | Floyd | Texas | 48153 | 198 | 16 |
793320 | 793320 | 2020-12-03 | Floyd | Texas | 48153 | 196 | 16 |
790075 | 790075 | 2020-12-02 | Floyd | Texas | 48153 | 190 | 16 |
786830 | 786830 | 2020-12-01 | Floyd | Texas | 48153 | 186 | 17 |
783586 | 783586 | 2020-11-30 | Floyd | Texas | 48153 | 186 | 17 |
780341 | 780341 | 2020-11-29 | Floyd | Texas | 48153 | 186 | 17 |
777095 | 777095 | 2020-11-28 | Floyd | Texas | 48153 | 186 | 17 |
773850 | 773850 | 2020-11-27 | Floyd | Texas | 48153 | 184 | 17 |
770605 | 770605 | 2020-11-26 | Floyd | Texas | 48153 | 184 | 17 |
767359 | 767359 | 2020-11-25 | Floyd | Texas | 48153 | 184 | 16 |
764114 | 764114 | 2020-11-24 | Floyd | Texas | 48153 | 184 | 16 |
760869 | 760869 | 2020-11-23 | Floyd | Texas | 48153 | 182 | 16 |
757624 | 757624 | 2020-11-22 | Floyd | Texas | 48153 | 182 | 16 |
754377 | 754377 | 2020-11-21 | Floyd | Texas | 48153 | 182 | 15 |
751131 | 751131 | 2020-11-20 | Floyd | Texas | 48153 | 179 | 14 |
747885 | 747885 | 2020-11-19 | Floyd | Texas | 48153 | 185 | 11 |
744639 | 744639 | 2020-11-18 | Floyd | Texas | 48153 | 184 | 10 |
741392 | 741392 | 2020-11-17 | Floyd | Texas | 48153 | 184 | 10 |
738146 | 738146 | 2020-11-16 | Floyd | Texas | 48153 | 179 | 10 |
734902 | 734902 | 2020-11-15 | Floyd | Texas | 48153 | 173 | 10 |
731656 | 731656 | 2020-11-14 | Floyd | Texas | 48153 | 173 | 10 |
728411 | 728411 | 2020-11-13 | Floyd | Texas | 48153 | 167 | 10 |
725168 | 725168 | 2020-11-12 | Floyd | Texas | 48153 | 160 | 10 |
721925 | 721925 | 2020-11-11 | Floyd | Texas | 48153 | 160 | 10 |
718682 | 718682 | 2020-11-10 | Floyd | Texas | 48153 | 160 | 10 |
715439 | 715439 | 2020-11-09 | Floyd | Texas | 48153 | 160 | 10 |
712195 | 712195 | 2020-11-08 | Floyd | Texas | 48153 | 160 | 10 |
708951 | 708951 | 2020-11-07 | Floyd | Texas | 48153 | 160 | 9 |
705707 | 705707 | 2020-11-06 | Floyd | Texas | 48153 | 140 | 9 |
702464 | 702464 | 2020-11-05 | Floyd | Texas | 48153 | 140 | 9 |
699221 | 699221 | 2020-11-04 | Floyd | Texas | 48153 | 137 | 9 |
695977 | 695977 | 2020-11-03 | Floyd | Texas | 48153 | 136 | 9 |
692735 | 692735 | 2020-11-02 | Floyd | Texas | 48153 | 128 | 9 |
689491 | 689491 | 2020-11-01 | Floyd | Texas | 48153 | 128 | 9 |
686246 | 686246 | 2020-10-31 | Floyd | Texas | 48153 | 128 | 9 |
683003 | 683003 | 2020-10-30 | Floyd | Texas | 48153 | 128 | 9 |
679760 | 679760 | 2020-10-29 | Floyd | Texas | 48153 | 142 | 9 |
676517 | 676517 | 2020-10-28 | Floyd | Texas | 48153 | 142 | 9 |
673274 | 673274 | 2020-10-27 | Floyd | Texas | 48153 | 142 | 9 |
670032 | 670032 | 2020-10-26 | Floyd | Texas | 48153 | 126 | 9 |
666789 | 666789 | 2020-10-25 | Floyd | Texas | 48153 | 126 | 9 |
663544 | 663544 | 2020-10-24 | Floyd | Texas | 48153 | 126 | 9 |
660300 | 660300 | 2020-10-23 | Floyd | Texas | 48153 | 125 | 9 |
657056 | 657056 | 2020-10-22 | Floyd | Texas | 48153 | 121 | 9 |
653811 | 653811 | 2020-10-21 | Floyd | Texas | 48153 | 121 | 9 |
650566 | 650566 | 2020-10-20 | Floyd | Texas | 48153 | 120 | 9 |
647322 | 647322 | 2020-10-19 | Floyd | Texas | 48153 | 120 | 9 |
644076 | 644076 | 2020-10-18 | Floyd | Texas | 48153 | 120 | 9 |
640828 | 640828 | 2020-10-17 | Floyd | Texas | 48153 | 120 | 9 |
637581 | 637581 | 2020-10-16 | Floyd | Texas | 48153 | 119 | 9 |
634336 | 634336 | 2020-10-15 | Floyd | Texas | 48153 | 119 | 9 |
631091 | 631091 | 2020-10-14 | Floyd | Texas | 48153 | 117 | 9 |
627847 | 627847 | 2020-10-13 | Floyd | Texas | 48153 | 117 | 9 |
624605 | 624605 | 2020-10-12 | Floyd | Texas | 48153 | 116 | 9 |
621362 | 621362 | 2020-10-11 | Floyd | Texas | 48153 | 116 | 9 |
618119 | 618119 | 2020-10-10 | Floyd | Texas | 48153 | 116 | 9 |
614877 | 614877 | 2020-10-09 | Floyd | Texas | 48153 | 115 | 9 |
611636 | 611636 | 2020-10-08 | Floyd | Texas | 48153 | 114 | 9 |
608394 | 608394 | 2020-10-07 | Floyd | Texas | 48153 | 113 | 9 |
605151 | 605151 | 2020-10-06 | Floyd | Texas | 48153 | 113 | 9 |
601909 | 601909 | 2020-10-05 | Floyd | Texas | 48153 | 112 | 9 |
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);