ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 48471 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923294 | 923294 | 2021-01-12 | Walker | Texas | 48471 | 6635 | 90 |
920049 | 920049 | 2021-01-11 | Walker | Texas | 48471 | 6543 | 90 |
916804 | 916804 | 2021-01-10 | Walker | Texas | 48471 | 6489 | 90 |
913559 | 913559 | 2021-01-09 | Walker | Texas | 48471 | 6461 | 90 |
910314 | 910314 | 2021-01-08 | Walker | Texas | 48471 | 6422 | 90 |
907069 | 907069 | 2021-01-07 | Walker | Texas | 48471 | 6395 | 90 |
903823 | 903823 | 2021-01-06 | Walker | Texas | 48471 | 6366 | 89 |
900578 | 900578 | 2021-01-05 | Walker | Texas | 48471 | 6319 | 89 |
897333 | 897333 | 2021-01-04 | Walker | Texas | 48471 | 6250 | 87 |
894087 | 894087 | 2021-01-03 | Walker | Texas | 48471 | 6185 | 86 |
890841 | 890841 | 2021-01-02 | Walker | Texas | 48471 | 6148 | 86 |
887594 | 887594 | 2021-01-01 | Walker | Texas | 48471 | 6111 | 86 |
884349 | 884349 | 2020-12-31 | Walker | Texas | 48471 | 6088 | 86 |
881104 | 881104 | 2020-12-30 | Walker | Texas | 48471 | 6097 | 86 |
877859 | 877859 | 2020-12-29 | Walker | Texas | 48471 | 5909 | 84 |
874614 | 874614 | 2020-12-28 | Walker | Texas | 48471 | 5901 | 83 |
871369 | 871369 | 2020-12-27 | Walker | Texas | 48471 | 5882 | 82 |
868124 | 868124 | 2020-12-26 | Walker | Texas | 48471 | 5846 | 82 |
864879 | 864879 | 2020-12-25 | Walker | Texas | 48471 | 5789 | 82 |
861634 | 861634 | 2020-12-24 | Walker | Texas | 48471 | 5763 | 81 |
858389 | 858389 | 2020-12-23 | Walker | Texas | 48471 | 5737 | 79 |
855144 | 855144 | 2020-12-22 | Walker | Texas | 48471 | 5643 | 78 |
851899 | 851899 | 2020-12-21 | Walker | Texas | 48471 | 5560 | 78 |
848654 | 848654 | 2020-12-20 | Walker | Texas | 48471 | 5548 | 78 |
845409 | 845409 | 2020-12-19 | Walker | Texas | 48471 | 5529 | 78 |
842163 | 842163 | 2020-12-18 | Walker | Texas | 48471 | 5470 | 78 |
838918 | 838918 | 2020-12-17 | Walker | Texas | 48471 | 5417 | 78 |
835672 | 835672 | 2020-12-16 | Walker | Texas | 48471 | 5407 | 76 |
832426 | 832426 | 2020-12-15 | Walker | Texas | 48471 | 5152 | 76 |
829179 | 829179 | 2020-12-14 | Walker | Texas | 48471 | 5127 | 75 |
825933 | 825933 | 2020-12-13 | Walker | Texas | 48471 | 5084 | 74 |
822686 | 822686 | 2020-12-12 | Walker | Texas | 48471 | 5054 | 74 |
819440 | 819440 | 2020-12-11 | Walker | Texas | 48471 | 5040 | 74 |
816194 | 816194 | 2020-12-10 | Walker | Texas | 48471 | 4594 | 74 |
812948 | 812948 | 2020-12-09 | Walker | Texas | 48471 | 4589 | 73 |
809704 | 809704 | 2020-12-08 | Walker | Texas | 48471 | 4578 | 72 |
806459 | 806459 | 2020-12-07 | Walker | Texas | 48471 | 4585 | 72 |
803214 | 803214 | 2020-12-06 | Walker | Texas | 48471 | 4580 | 72 |
799969 | 799969 | 2020-12-05 | Walker | Texas | 48471 | 4565 | 72 |
796724 | 796724 | 2020-12-04 | Walker | Texas | 48471 | 4513 | 71 |
793479 | 793479 | 2020-12-03 | Walker | Texas | 48471 | 4489 | 71 |
790234 | 790234 | 2020-12-02 | Walker | Texas | 48471 | 4497 | 71 |
786989 | 786989 | 2020-12-01 | Walker | Texas | 48471 | 4493 | 70 |
783745 | 783745 | 2020-11-30 | Walker | Texas | 48471 | 4457 | 69 |
780500 | 780500 | 2020-11-29 | Walker | Texas | 48471 | 4394 | 69 |
777254 | 777254 | 2020-11-28 | Walker | Texas | 48471 | 4332 | 69 |
774009 | 774009 | 2020-11-27 | Walker | Texas | 48471 | 4324 | 69 |
770764 | 770764 | 2020-11-26 | Walker | Texas | 48471 | 4286 | 69 |
767518 | 767518 | 2020-11-25 | Walker | Texas | 48471 | 4276 | 69 |
764273 | 764273 | 2020-11-24 | Walker | Texas | 48471 | 4155 | 68 |
761028 | 761028 | 2020-11-23 | Walker | Texas | 48471 | 4142 | 68 |
757783 | 757783 | 2020-11-22 | Walker | Texas | 48471 | 4098 | 68 |
754536 | 754536 | 2020-11-21 | Walker | Texas | 48471 | 4094 | 68 |
751290 | 751290 | 2020-11-20 | Walker | Texas | 48471 | 4076 | 68 |
748044 | 748044 | 2020-11-19 | Walker | Texas | 48471 | 4053 | 68 |
744798 | 744798 | 2020-11-18 | Walker | Texas | 48471 | 4046 | 68 |
741551 | 741551 | 2020-11-17 | Walker | Texas | 48471 | 4028 | 67 |
738304 | 738304 | 2020-11-16 | Walker | Texas | 48471 | 4021 | 66 |
735060 | 735060 | 2020-11-15 | Walker | Texas | 48471 | 4021 | 66 |
731814 | 731814 | 2020-11-14 | Walker | Texas | 48471 | 4009 | 66 |
728569 | 728569 | 2020-11-13 | Walker | Texas | 48471 | 4009 | 65 |
725326 | 725326 | 2020-11-12 | Walker | Texas | 48471 | 4002 | 65 |
722083 | 722083 | 2020-11-11 | Walker | Texas | 48471 | 4001 | 65 |
718840 | 718840 | 2020-11-10 | Walker | Texas | 48471 | 3960 | 65 |
715597 | 715597 | 2020-11-09 | Walker | Texas | 48471 | 3951 | 65 |
712353 | 712353 | 2020-11-08 | Walker | Texas | 48471 | 3951 | 65 |
709109 | 709109 | 2020-11-07 | Walker | Texas | 48471 | 3942 | 65 |
705865 | 705865 | 2020-11-06 | Walker | Texas | 48471 | 3938 | 64 |
702622 | 702622 | 2020-11-05 | Walker | Texas | 48471 | 3939 | 64 |
699379 | 699379 | 2020-11-04 | Walker | Texas | 48471 | 3953 | 64 |
696135 | 696135 | 2020-11-03 | Walker | Texas | 48471 | 3946 | 62 |
692893 | 692893 | 2020-11-02 | Walker | Texas | 48471 | 3963 | 62 |
689649 | 689649 | 2020-11-01 | Walker | Texas | 48471 | 3959 | 62 |
686404 | 686404 | 2020-10-31 | Walker | Texas | 48471 | 3936 | 62 |
683161 | 683161 | 2020-10-30 | Walker | Texas | 48471 | 3927 | 62 |
679918 | 679918 | 2020-10-29 | Walker | Texas | 48471 | 3930 | 62 |
676675 | 676675 | 2020-10-28 | Walker | Texas | 48471 | 3940 | 62 |
673432 | 673432 | 2020-10-27 | Walker | Texas | 48471 | 3935 | 62 |
670190 | 670190 | 2020-10-26 | Walker | Texas | 48471 | 3946 | 62 |
666947 | 666947 | 2020-10-25 | Walker | Texas | 48471 | 3946 | 62 |
663702 | 663702 | 2020-10-24 | Walker | Texas | 48471 | 3932 | 62 |
660458 | 660458 | 2020-10-23 | Walker | Texas | 48471 | 3906 | 62 |
657214 | 657214 | 2020-10-22 | Walker | Texas | 48471 | 3854 | 62 |
653969 | 653969 | 2020-10-21 | Walker | Texas | 48471 | 3854 | 62 |
650724 | 650724 | 2020-10-20 | Walker | Texas | 48471 | 3855 | 62 |
647480 | 647480 | 2020-10-19 | Walker | Texas | 48471 | 3855 | 61 |
644234 | 644234 | 2020-10-18 | Walker | Texas | 48471 | 3855 | 61 |
640986 | 640986 | 2020-10-17 | Walker | Texas | 48471 | 3855 | 61 |
637739 | 637739 | 2020-10-16 | Walker | Texas | 48471 | 3842 | 61 |
634494 | 634494 | 2020-10-15 | Walker | Texas | 48471 | 3847 | 60 |
631249 | 631249 | 2020-10-14 | Walker | Texas | 48471 | 3836 | 58 |
628005 | 628005 | 2020-10-13 | Walker | Texas | 48471 | 3838 | 58 |
624762 | 624762 | 2020-10-12 | Walker | Texas | 48471 | 3831 | 58 |
621519 | 621519 | 2020-10-11 | Walker | Texas | 48471 | 3827 | 58 |
618276 | 618276 | 2020-10-10 | Walker | Texas | 48471 | 3830 | 58 |
615034 | 615034 | 2020-10-09 | Walker | Texas | 48471 | 3813 | 58 |
611793 | 611793 | 2020-10-08 | Walker | Texas | 48471 | 3808 | 58 |
608551 | 608551 | 2020-10-07 | Walker | Texas | 48471 | 3788 | 57 |
605308 | 605308 | 2020-10-06 | Walker | Texas | 48471 | 3819 | 57 |
602066 | 602066 | 2020-10-05 | Walker | Texas | 48471 | 3769 | 57 |
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);