ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Jefferson" and fips = 48245 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
952390 | 952390 | 2021-01-21 | Jefferson | Texas | 48245 | 16348 | 275 |
949145 | 949145 | 2021-01-20 | Jefferson | Texas | 48245 | 16211 | 269 |
945899 | 945899 | 2021-01-19 | Jefferson | Texas | 48245 | 15937 | 263 |
942652 | 942652 | 2021-01-18 | Jefferson | Texas | 48245 | 15897 | 261 |
939407 | 939407 | 2021-01-17 | Jefferson | Texas | 48245 | 15897 | 261 |
936162 | 936162 | 2021-01-16 | Jefferson | Texas | 48245 | 15872 | 259 |
932917 | 932917 | 2021-01-15 | Jefferson | Texas | 48245 | 15788 | 257 |
929672 | 929672 | 2021-01-14 | Jefferson | Texas | 48245 | 15642 | 255 |
926427 | 926427 | 2021-01-13 | Jefferson | Texas | 48245 | 15548 | 253 |
923181 | 923181 | 2021-01-12 | Jefferson | Texas | 48245 | 15188 | 253 |
919936 | 919936 | 2021-01-11 | Jefferson | Texas | 48245 | 15008 | 249 |
916691 | 916691 | 2021-01-10 | Jefferson | Texas | 48245 | 15008 | 249 |
913446 | 913446 | 2021-01-09 | Jefferson | Texas | 48245 | 15008 | 244 |
910201 | 910201 | 2021-01-08 | Jefferson | Texas | 48245 | 14782 | 237 |
906956 | 906956 | 2021-01-07 | Jefferson | Texas | 48245 | 14528 | 233 |
903710 | 903710 | 2021-01-06 | Jefferson | Texas | 48245 | 14322 | 228 |
900465 | 900465 | 2021-01-05 | Jefferson | Texas | 48245 | 14004 | 225 |
897220 | 897220 | 2021-01-04 | Jefferson | Texas | 48245 | 13802 | 223 |
893974 | 893974 | 2021-01-03 | Jefferson | Texas | 48245 | 13802 | 221 |
890728 | 890728 | 2021-01-02 | Jefferson | Texas | 48245 | 13802 | 221 |
887481 | 887481 | 2021-01-01 | Jefferson | Texas | 48245 | 13730 | 221 |
884236 | 884236 | 2020-12-31 | Jefferson | Texas | 48245 | 13606 | 219 |
880991 | 880991 | 2020-12-30 | Jefferson | Texas | 48245 | 13455 | 215 |
877746 | 877746 | 2020-12-29 | Jefferson | Texas | 48245 | 13337 | 214 |
874501 | 874501 | 2020-12-28 | Jefferson | Texas | 48245 | 12984 | 213 |
871256 | 871256 | 2020-12-27 | Jefferson | Texas | 48245 | 12984 | 213 |
868011 | 868011 | 2020-12-26 | Jefferson | Texas | 48245 | 12974 | 208 |
864766 | 864766 | 2020-12-25 | Jefferson | Texas | 48245 | 12974 | 208 |
861521 | 861521 | 2020-12-24 | Jefferson | Texas | 48245 | 12944 | 208 |
858276 | 858276 | 2020-12-23 | Jefferson | Texas | 48245 | 12756 | 207 |
855031 | 855031 | 2020-12-22 | Jefferson | Texas | 48245 | 12450 | 206 |
851786 | 851786 | 2020-12-21 | Jefferson | Texas | 48245 | 12390 | 205 |
848541 | 848541 | 2020-12-20 | Jefferson | Texas | 48245 | 12390 | 205 |
845296 | 845296 | 2020-12-19 | Jefferson | Texas | 48245 | 12365 | 203 |
842050 | 842050 | 2020-12-18 | Jefferson | Texas | 48245 | 12279 | 201 |
838805 | 838805 | 2020-12-17 | Jefferson | Texas | 48245 | 12160 | 200 |
835559 | 835559 | 2020-12-16 | Jefferson | Texas | 48245 | 12056 | 199 |
832313 | 832313 | 2020-12-15 | Jefferson | Texas | 48245 | 11932 | 196 |
829066 | 829066 | 2020-12-14 | Jefferson | Texas | 48245 | 11689 | 196 |
825820 | 825820 | 2020-12-13 | Jefferson | Texas | 48245 | 11689 | 195 |
822573 | 822573 | 2020-12-12 | Jefferson | Texas | 48245 | 11689 | 195 |
819327 | 819327 | 2020-12-11 | Jefferson | Texas | 48245 | 11553 | 195 |
816081 | 816081 | 2020-12-10 | Jefferson | Texas | 48245 | 11386 | 195 |
812835 | 812835 | 2020-12-09 | Jefferson | Texas | 48245 | 11315 | 189 |
809591 | 809591 | 2020-12-08 | Jefferson | Texas | 48245 | 11171 | 188 |
806346 | 806346 | 2020-12-07 | Jefferson | Texas | 48245 | 11000 | 184 |
803101 | 803101 | 2020-12-06 | Jefferson | Texas | 48245 | 11000 | 184 |
799856 | 799856 | 2020-12-05 | Jefferson | Texas | 48245 | 10980 | 184 |
796611 | 796611 | 2020-12-04 | Jefferson | Texas | 48245 | 10866 | 183 |
793366 | 793366 | 2020-12-03 | Jefferson | Texas | 48245 | 10779 | 183 |
790121 | 790121 | 2020-12-02 | Jefferson | Texas | 48245 | 10677 | 180 |
786876 | 786876 | 2020-12-01 | Jefferson | Texas | 48245 | 10473 | 179 |
783632 | 783632 | 2020-11-30 | Jefferson | Texas | 48245 | 10212 | 178 |
780387 | 780387 | 2020-11-29 | Jefferson | Texas | 48245 | 10212 | 178 |
777141 | 777141 | 2020-11-28 | Jefferson | Texas | 48245 | 10187 | 176 |
773896 | 773896 | 2020-11-27 | Jefferson | Texas | 48245 | 10187 | 176 |
770651 | 770651 | 2020-11-26 | Jefferson | Texas | 48245 | 10187 | 176 |
767405 | 767405 | 2020-11-25 | Jefferson | Texas | 48245 | 10073 | 175 |
764160 | 764160 | 2020-11-24 | Jefferson | Texas | 48245 | 9959 | 174 |
760915 | 760915 | 2020-11-23 | Jefferson | Texas | 48245 | 9804 | 173 |
757670 | 757670 | 2020-11-22 | Jefferson | Texas | 48245 | 9804 | 174 |
754423 | 754423 | 2020-11-21 | Jefferson | Texas | 48245 | 9804 | 172 |
751177 | 751177 | 2020-11-20 | Jefferson | Texas | 48245 | 9728 | 172 |
747931 | 747931 | 2020-11-19 | Jefferson | Texas | 48245 | 9659 | 172 |
744685 | 744685 | 2020-11-18 | Jefferson | Texas | 48245 | 9556 | 172 |
741438 | 741438 | 2020-11-17 | Jefferson | Texas | 48245 | 9368 | 170 |
738192 | 738192 | 2020-11-16 | Jefferson | Texas | 48245 | 9237 | 168 |
734948 | 734948 | 2020-11-15 | Jefferson | Texas | 48245 | 9237 | 168 |
731702 | 731702 | 2020-11-14 | Jefferson | Texas | 48245 | 9237 | 167 |
728457 | 728457 | 2020-11-13 | Jefferson | Texas | 48245 | 9166 | 166 |
725214 | 725214 | 2020-11-12 | Jefferson | Texas | 48245 | 8962 | 165 |
721971 | 721971 | 2020-11-11 | Jefferson | Texas | 48245 | 8927 | 163 |
718728 | 718728 | 2020-11-10 | Jefferson | Texas | 48245 | 8902 | 160 |
715485 | 715485 | 2020-11-09 | Jefferson | Texas | 48245 | 8786 | 160 |
712241 | 712241 | 2020-11-08 | Jefferson | Texas | 48245 | 8786 | 160 |
708997 | 708997 | 2020-11-07 | Jefferson | Texas | 48245 | 8786 | 160 |
705753 | 705753 | 2020-11-06 | Jefferson | Texas | 48245 | 8718 | 159 |
702510 | 702510 | 2020-11-05 | Jefferson | Texas | 48245 | 8659 | 158 |
699267 | 699267 | 2020-11-04 | Jefferson | Texas | 48245 | 8548 | 157 |
696023 | 696023 | 2020-11-03 | Jefferson | Texas | 48245 | 8548 | 156 |
692781 | 692781 | 2020-11-02 | Jefferson | Texas | 48245 | 8471 | 155 |
689537 | 689537 | 2020-11-01 | Jefferson | Texas | 48245 | 8471 | 155 |
686292 | 686292 | 2020-10-31 | Jefferson | Texas | 48245 | 8471 | 155 |
683049 | 683049 | 2020-10-30 | Jefferson | Texas | 48245 | 8424 | 154 |
679806 | 679806 | 2020-10-29 | Jefferson | Texas | 48245 | 8387 | 152 |
676563 | 676563 | 2020-10-28 | Jefferson | Texas | 48245 | 8332 | 152 |
673320 | 673320 | 2020-10-27 | Jefferson | Texas | 48245 | 8301 | 152 |
670078 | 670078 | 2020-10-26 | Jefferson | Texas | 48245 | 8245 | 152 |
666835 | 666835 | 2020-10-25 | Jefferson | Texas | 48245 | 8245 | 152 |
663590 | 663590 | 2020-10-24 | Jefferson | Texas | 48245 | 8245 | 152 |
660346 | 660346 | 2020-10-23 | Jefferson | Texas | 48245 | 8179 | 149 |
657102 | 657102 | 2020-10-22 | Jefferson | Texas | 48245 | 8139 | 148 |
653857 | 653857 | 2020-10-21 | Jefferson | Texas | 48245 | 8139 | 148 |
650612 | 650612 | 2020-10-20 | Jefferson | Texas | 48245 | 8109 | 146 |
647368 | 647368 | 2020-10-19 | Jefferson | Texas | 48245 | 8017 | 146 |
644122 | 644122 | 2020-10-18 | Jefferson | Texas | 48245 | 8017 | 146 |
640874 | 640874 | 2020-10-17 | Jefferson | Texas | 48245 | 8017 | 146 |
637627 | 637627 | 2020-10-16 | Jefferson | Texas | 48245 | 7980 | 145 |
634382 | 634382 | 2020-10-15 | Jefferson | Texas | 48245 | 7950 | 144 |
631137 | 631137 | 2020-10-14 | Jefferson | Texas | 48245 | 7871 | 144 |
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);