ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
764 rows where county = "Rains" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
939474 | 939474 | 2021-01-17 | Rains | Texas | 48379 | 632 | 19 |
936229 | 936229 | 2021-01-16 | Rains | Texas | 48379 | 632 | 19 |
932984 | 932984 | 2021-01-15 | Rains | Texas | 48379 | 632 | 19 |
929739 | 929739 | 2021-01-14 | Rains | Texas | 48379 | 621 | 19 |
926494 | 926494 | 2021-01-13 | Rains | Texas | 48379 | 613 | 19 |
923248 | 923248 | 2021-01-12 | Rains | Texas | 48379 | 611 | 19 |
920003 | 920003 | 2021-01-11 | Rains | Texas | 48379 | 581 | 19 |
916758 | 916758 | 2021-01-10 | Rains | Texas | 48379 | 581 | 19 |
913513 | 913513 | 2021-01-09 | Rains | Texas | 48379 | 581 | 19 |
910268 | 910268 | 2021-01-08 | Rains | Texas | 48379 | 581 | 18 |
907023 | 907023 | 2021-01-07 | Rains | Texas | 48379 | 559 | 18 |
903777 | 903777 | 2021-01-06 | Rains | Texas | 48379 | 559 | 18 |
900532 | 900532 | 2021-01-05 | Rains | Texas | 48379 | 553 | 18 |
897287 | 897287 | 2021-01-04 | Rains | Texas | 48379 | 544 | 18 |
894041 | 894041 | 2021-01-03 | Rains | Texas | 48379 | 532 | 18 |
890795 | 890795 | 2021-01-02 | Rains | Texas | 48379 | 532 | 18 |
887548 | 887548 | 2021-01-01 | Rains | Texas | 48379 | 532 | 18 |
884303 | 884303 | 2020-12-31 | Rains | Texas | 48379 | 532 | 18 |
881058 | 881058 | 2020-12-30 | Rains | Texas | 48379 | 520 | 18 |
877813 | 877813 | 2020-12-29 | Rains | Texas | 48379 | 515 | 18 |
874568 | 874568 | 2020-12-28 | Rains | Texas | 48379 | 513 | 16 |
871323 | 871323 | 2020-12-27 | Rains | Texas | 48379 | 482 | 16 |
868078 | 868078 | 2020-12-26 | Rains | Texas | 48379 | 482 | 16 |
864833 | 864833 | 2020-12-25 | Rains | Texas | 48379 | 482 | 16 |
861588 | 861588 | 2020-12-24 | Rains | Texas | 48379 | 482 | 16 |
858343 | 858343 | 2020-12-23 | Rains | Texas | 48379 | 482 | 16 |
855098 | 855098 | 2020-12-22 | Rains | Texas | 48379 | 474 | 15 |
851853 | 851853 | 2020-12-21 | Rains | Texas | 48379 | 452 | 14 |
848608 | 848608 | 2020-12-20 | Rains | Texas | 48379 | 437 | 14 |
845363 | 845363 | 2020-12-19 | Rains | Texas | 48379 | 437 | 13 |
842117 | 842117 | 2020-12-18 | Rains | Texas | 48379 | 437 | 11 |
838872 | 838872 | 2020-12-17 | Rains | Texas | 48379 | 429 | 11 |
835626 | 835626 | 2020-12-16 | Rains | Texas | 48379 | 422 | 11 |
832380 | 832380 | 2020-12-15 | Rains | Texas | 48379 | 415 | 10 |
829133 | 829133 | 2020-12-14 | Rains | Texas | 48379 | 411 | 10 |
825887 | 825887 | 2020-12-13 | Rains | Texas | 48379 | 405 | 10 |
822640 | 822640 | 2020-12-12 | Rains | Texas | 48379 | 405 | 10 |
819394 | 819394 | 2020-12-11 | Rains | Texas | 48379 | 405 | 10 |
816148 | 816148 | 2020-12-10 | Rains | Texas | 48379 | 402 | 10 |
812902 | 812902 | 2020-12-09 | Rains | Texas | 48379 | 398 | 9 |
809658 | 809658 | 2020-12-08 | Rains | Texas | 48379 | 388 | 9 |
806413 | 806413 | 2020-12-07 | Rains | Texas | 48379 | 382 | 9 |
803168 | 803168 | 2020-12-06 | Rains | Texas | 48379 | 375 | 9 |
799923 | 799923 | 2020-12-05 | Rains | Texas | 48379 | 375 | 9 |
796678 | 796678 | 2020-12-04 | Rains | Texas | 48379 | 375 | 9 |
793433 | 793433 | 2020-12-03 | Rains | Texas | 48379 | 366 | 9 |
790188 | 790188 | 2020-12-02 | Rains | Texas | 48379 | 361 | 9 |
786943 | 786943 | 2020-12-01 | Rains | Texas | 48379 | 342 | 9 |
783699 | 783699 | 2020-11-30 | Rains | Texas | 48379 | 340 | 9 |
780454 | 780454 | 2020-11-29 | Rains | Texas | 48379 | 330 | 9 |
777208 | 777208 | 2020-11-28 | Rains | Texas | 48379 | 330 | 9 |
773963 | 773963 | 2020-11-27 | Rains | Texas | 48379 | 330 | 9 |
770718 | 770718 | 2020-11-26 | Rains | Texas | 48379 | 330 | 9 |
767472 | 767472 | 2020-11-25 | Rains | Texas | 48379 | 330 | 9 |
764227 | 764227 | 2020-11-24 | Rains | Texas | 48379 | 319 | 9 |
760982 | 760982 | 2020-11-23 | Rains | Texas | 48379 | 315 | 8 |
757737 | 757737 | 2020-11-22 | Rains | Texas | 48379 | 302 | 8 |
754490 | 754490 | 2020-11-21 | Rains | Texas | 48379 | 302 | 8 |
751244 | 751244 | 2020-11-20 | Rains | Texas | 48379 | 302 | 7 |
747998 | 747998 | 2020-11-19 | Rains | Texas | 48379 | 299 | 7 |
744752 | 744752 | 2020-11-18 | Rains | Texas | 48379 | 286 | 7 |
741505 | 741505 | 2020-11-17 | Rains | Texas | 48379 | 282 | 6 |
738258 | 738258 | 2020-11-16 | Rains | Texas | 48379 | 273 | 6 |
735014 | 735014 | 2020-11-15 | Rains | Texas | 48379 | 244 | 6 |
731768 | 731768 | 2020-11-14 | Rains | Texas | 48379 | 244 | 6 |
728523 | 728523 | 2020-11-13 | Rains | Texas | 48379 | 244 | 6 |
725280 | 725280 | 2020-11-12 | Rains | Texas | 48379 | 227 | 5 |
722037 | 722037 | 2020-11-11 | Rains | Texas | 48379 | 218 | 5 |
718794 | 718794 | 2020-11-10 | Rains | Texas | 48379 | 212 | 5 |
715551 | 715551 | 2020-11-09 | Rains | Texas | 48379 | 203 | 5 |
712307 | 712307 | 2020-11-08 | Rains | Texas | 48379 | 193 | 5 |
709063 | 709063 | 2020-11-07 | Rains | Texas | 48379 | 193 | 5 |
705819 | 705819 | 2020-11-06 | Rains | Texas | 48379 | 193 | 5 |
702576 | 702576 | 2020-11-05 | Rains | Texas | 48379 | 185 | 5 |
699333 | 699333 | 2020-11-04 | Rains | Texas | 48379 | 181 | 5 |
696089 | 696089 | 2020-11-03 | Rains | Texas | 48379 | 167 | 5 |
692847 | 692847 | 2020-11-02 | Rains | Texas | 48379 | 167 | 5 |
689603 | 689603 | 2020-11-01 | Rains | Texas | 48379 | 167 | 5 |
686358 | 686358 | 2020-10-31 | Rains | Texas | 48379 | 167 | 5 |
683115 | 683115 | 2020-10-30 | Rains | Texas | 48379 | 167 | 5 |
679872 | 679872 | 2020-10-29 | Rains | Texas | 48379 | 162 | 5 |
676629 | 676629 | 2020-10-28 | Rains | Texas | 48379 | 160 | 5 |
673386 | 673386 | 2020-10-27 | Rains | Texas | 48379 | 156 | 5 |
670144 | 670144 | 2020-10-26 | Rains | Texas | 48379 | 153 | 5 |
666901 | 666901 | 2020-10-25 | Rains | Texas | 48379 | 151 | 5 |
663656 | 663656 | 2020-10-24 | Rains | Texas | 48379 | 151 | 5 |
660412 | 660412 | 2020-10-23 | Rains | Texas | 48379 | 151 | 5 |
657168 | 657168 | 2020-10-22 | Rains | Texas | 48379 | 146 | 5 |
653923 | 653923 | 2020-10-21 | Rains | Texas | 48379 | 143 | 5 |
650678 | 650678 | 2020-10-20 | Rains | Texas | 48379 | 141 | 5 |
647434 | 647434 | 2020-10-19 | Rains | Texas | 48379 | 136 | 5 |
644188 | 644188 | 2020-10-18 | Rains | Texas | 48379 | 80 | 5 |
640940 | 640940 | 2020-10-17 | Rains | Texas | 48379 | 80 | 5 |
637693 | 637693 | 2020-10-16 | Rains | Texas | 48379 | 79 | 5 |
634448 | 634448 | 2020-10-15 | Rains | Texas | 48379 | 78 | 5 |
631203 | 631203 | 2020-10-14 | Rains | Texas | 48379 | 77 | 5 |
627959 | 627959 | 2020-10-13 | Rains | Texas | 48379 | 77 | 5 |
624716 | 624716 | 2020-10-12 | Rains | Texas | 48379 | 76 | 5 |
621473 | 621473 | 2020-10-11 | Rains | Texas | 48379 | 76 | 5 |
618230 | 618230 | 2020-10-10 | Rains | Texas | 48379 | 76 | 5 |
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);