ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
766 rows where county = "Jones" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923185 | 923185 | 2021-01-12 | Jones | Texas | 48253 | 2470 | 35 |
919940 | 919940 | 2021-01-11 | Jones | Texas | 48253 | 2444 | 35 |
916695 | 916695 | 2021-01-10 | Jones | Texas | 48253 | 2444 | 35 |
913450 | 913450 | 2021-01-09 | Jones | Texas | 48253 | 2444 | 35 |
910205 | 910205 | 2021-01-08 | Jones | Texas | 48253 | 2421 | 33 |
906960 | 906960 | 2021-01-07 | Jones | Texas | 48253 | 2388 | 33 |
903714 | 903714 | 2021-01-06 | Jones | Texas | 48253 | 2389 | 33 |
900469 | 900469 | 2021-01-05 | Jones | Texas | 48253 | 2379 | 33 |
897224 | 897224 | 2021-01-04 | Jones | Texas | 48253 | 2343 | 32 |
893978 | 893978 | 2021-01-03 | Jones | Texas | 48253 | 2343 | 31 |
890732 | 890732 | 2021-01-02 | Jones | Texas | 48253 | 2343 | 30 |
887485 | 887485 | 2021-01-01 | Jones | Texas | 48253 | 2343 | 30 |
884240 | 884240 | 2020-12-31 | Jones | Texas | 48253 | 2351 | 30 |
880995 | 880995 | 2020-12-30 | Jones | Texas | 48253 | 2341 | 30 |
877750 | 877750 | 2020-12-29 | Jones | Texas | 48253 | 2279 | 28 |
874505 | 874505 | 2020-12-28 | Jones | Texas | 48253 | 2259 | 26 |
871260 | 871260 | 2020-12-27 | Jones | Texas | 48253 | 2259 | 26 |
868015 | 868015 | 2020-12-26 | Jones | Texas | 48253 | 2228 | 26 |
864770 | 864770 | 2020-12-25 | Jones | Texas | 48253 | 2228 | 26 |
861525 | 861525 | 2020-12-24 | Jones | Texas | 48253 | 2228 | 26 |
858280 | 858280 | 2020-12-23 | Jones | Texas | 48253 | 2215 | 26 |
855035 | 855035 | 2020-12-22 | Jones | Texas | 48253 | 2193 | 23 |
851790 | 851790 | 2020-12-21 | Jones | Texas | 48253 | 2124 | 22 |
848545 | 848545 | 2020-12-20 | Jones | Texas | 48253 | 2124 | 22 |
845300 | 845300 | 2020-12-19 | Jones | Texas | 48253 | 2124 | 22 |
842054 | 842054 | 2020-12-18 | Jones | Texas | 48253 | 2115 | 22 |
838809 | 838809 | 2020-12-17 | Jones | Texas | 48253 | 2098 | 19 |
835563 | 835563 | 2020-12-16 | Jones | Texas | 48253 | 2050 | 18 |
832317 | 832317 | 2020-12-15 | Jones | Texas | 48253 | 2040 | 18 |
829070 | 829070 | 2020-12-14 | Jones | Texas | 48253 | 1999 | 18 |
825824 | 825824 | 2020-12-13 | Jones | Texas | 48253 | 1999 | 18 |
822577 | 822577 | 2020-12-12 | Jones | Texas | 48253 | 1999 | 18 |
819331 | 819331 | 2020-12-11 | Jones | Texas | 48253 | 1996 | 17 |
816085 | 816085 | 2020-12-10 | Jones | Texas | 48253 | 1686 | 16 |
812839 | 812839 | 2020-12-09 | Jones | Texas | 48253 | 1682 | 16 |
809595 | 809595 | 2020-12-08 | Jones | Texas | 48253 | 1677 | 15 |
806350 | 806350 | 2020-12-07 | Jones | Texas | 48253 | 1656 | 13 |
803105 | 803105 | 2020-12-06 | Jones | Texas | 48253 | 1656 | 12 |
799860 | 799860 | 2020-12-05 | Jones | Texas | 48253 | 1656 | 12 |
796615 | 796615 | 2020-12-04 | Jones | Texas | 48253 | 1649 | 11 |
793370 | 793370 | 2020-12-03 | Jones | Texas | 48253 | 1640 | 11 |
790125 | 790125 | 2020-12-02 | Jones | Texas | 48253 | 1629 | 11 |
786880 | 786880 | 2020-12-01 | Jones | Texas | 48253 | 1610 | 10 |
783636 | 783636 | 2020-11-30 | Jones | Texas | 48253 | 1610 | 9 |
780391 | 780391 | 2020-11-29 | Jones | Texas | 48253 | 1610 | 9 |
777145 | 777145 | 2020-11-28 | Jones | Texas | 48253 | 1604 | 9 |
773900 | 773900 | 2020-11-27 | Jones | Texas | 48253 | 1604 | 9 |
770655 | 770655 | 2020-11-26 | Jones | Texas | 48253 | 1604 | 9 |
767409 | 767409 | 2020-11-25 | Jones | Texas | 48253 | 1605 | 9 |
764164 | 764164 | 2020-11-24 | Jones | Texas | 48253 | 1604 | 8 |
760919 | 760919 | 2020-11-23 | Jones | Texas | 48253 | 1596 | 8 |
757674 | 757674 | 2020-11-22 | Jones | Texas | 48253 | 1596 | 8 |
754427 | 754427 | 2020-11-21 | Jones | Texas | 48253 | 1596 | 8 |
751181 | 751181 | 2020-11-20 | Jones | Texas | 48253 | 1593 | 7 |
747935 | 747935 | 2020-11-19 | Jones | Texas | 48253 | 1588 | 7 |
744689 | 744689 | 2020-11-18 | Jones | Texas | 48253 | 1576 | 6 |
741442 | 741442 | 2020-11-17 | Jones | Texas | 48253 | 1578 | 4 |
738196 | 738196 | 2020-11-16 | Jones | Texas | 48253 | 1577 | 4 |
734952 | 734952 | 2020-11-15 | Jones | Texas | 48253 | 1577 | 4 |
731706 | 731706 | 2020-11-14 | Jones | Texas | 48253 | 1577 | 4 |
728461 | 728461 | 2020-11-13 | Jones | Texas | 48253 | 1575 | 4 |
725218 | 725218 | 2020-11-12 | Jones | Texas | 48253 | 1499 | 4 |
721975 | 721975 | 2020-11-11 | Jones | Texas | 48253 | 1499 | 4 |
718732 | 718732 | 2020-11-10 | Jones | Texas | 48253 | 855 | 4 |
715489 | 715489 | 2020-11-09 | Jones | Texas | 48253 | 855 | 4 |
712245 | 712245 | 2020-11-08 | Jones | Texas | 48253 | 855 | 4 |
709001 | 709001 | 2020-11-07 | Jones | Texas | 48253 | 855 | 4 |
705757 | 705757 | 2020-11-06 | Jones | Texas | 48253 | 613 | 3 |
702514 | 702514 | 2020-11-05 | Jones | Texas | 48253 | 612 | 3 |
699271 | 699271 | 2020-11-04 | Jones | Texas | 48253 | 616 | 3 |
696027 | 696027 | 2020-11-03 | Jones | Texas | 48253 | 613 | 3 |
692785 | 692785 | 2020-11-02 | Jones | Texas | 48253 | 610 | 3 |
689541 | 689541 | 2020-11-01 | Jones | Texas | 48253 | 610 | 3 |
686296 | 686296 | 2020-10-31 | Jones | Texas | 48253 | 610 | 3 |
683053 | 683053 | 2020-10-30 | Jones | Texas | 48253 | 603 | 3 |
679810 | 679810 | 2020-10-29 | Jones | Texas | 48253 | 600 | 2 |
676567 | 676567 | 2020-10-28 | Jones | Texas | 48253 | 595 | 2 |
673324 | 673324 | 2020-10-27 | Jones | Texas | 48253 | 590 | 2 |
670082 | 670082 | 2020-10-26 | Jones | Texas | 48253 | 585 | 2 |
666839 | 666839 | 2020-10-25 | Jones | Texas | 48253 | 585 | 2 |
663594 | 663594 | 2020-10-24 | Jones | Texas | 48253 | 585 | 1 |
660350 | 660350 | 2020-10-23 | Jones | Texas | 48253 | 593 | 2 |
657106 | 657106 | 2020-10-22 | Jones | Texas | 48253 | 591 | 2 |
653861 | 653861 | 2020-10-21 | Jones | Texas | 48253 | 591 | 2 |
650616 | 650616 | 2020-10-20 | Jones | Texas | 48253 | 586 | 2 |
647372 | 647372 | 2020-10-19 | Jones | Texas | 48253 | 586 | 2 |
644126 | 644126 | 2020-10-18 | Jones | Texas | 48253 | 586 | 2 |
640878 | 640878 | 2020-10-17 | Jones | Texas | 48253 | 586 | 2 |
637631 | 637631 | 2020-10-16 | Jones | Texas | 48253 | 577 | 1 |
634386 | 634386 | 2020-10-15 | Jones | Texas | 48253 | 574 | 1 |
631141 | 631141 | 2020-10-14 | Jones | Texas | 48253 | 572 | 1 |
627897 | 627897 | 2020-10-13 | Jones | Texas | 48253 | 573 | 1 |
624655 | 624655 | 2020-10-12 | Jones | Texas | 48253 | 568 | 0 |
621412 | 621412 | 2020-10-11 | Jones | Texas | 48253 | 568 | 0 |
618169 | 618169 | 2020-10-10 | Jones | Texas | 48253 | 568 | 0 |
614927 | 614927 | 2020-10-09 | Jones | Texas | 48253 | 569 | 0 |
611686 | 611686 | 2020-10-08 | Jones | Texas | 48253 | 567 | 0 |
608444 | 608444 | 2020-10-07 | Jones | Texas | 48253 | 565 | 0 |
605201 | 605201 | 2020-10-06 | Jones | Texas | 48253 | 577 | 0 |
601959 | 601959 | 2020-10-05 | Jones | Texas | 48253 | 568 | 0 |
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);