ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
765 rows where county = "Jack" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
936158 | 936158 | 2021-01-16 | Jack | Texas | 48237 | 530 | 12 |
932913 | 932913 | 2021-01-15 | Jack | Texas | 48237 | 528 | 12 |
929668 | 929668 | 2021-01-14 | Jack | Texas | 48237 | 521 | 12 |
926423 | 926423 | 2021-01-13 | Jack | Texas | 48237 | 514 | 12 |
923177 | 923177 | 2021-01-12 | Jack | Texas | 48237 | 511 | 12 |
919932 | 919932 | 2021-01-11 | Jack | Texas | 48237 | 501 | 11 |
916687 | 916687 | 2021-01-10 | Jack | Texas | 48237 | 501 | 11 |
913442 | 913442 | 2021-01-09 | Jack | Texas | 48237 | 501 | 11 |
910197 | 910197 | 2021-01-08 | Jack | Texas | 48237 | 491 | 11 |
906952 | 906952 | 2021-01-07 | Jack | Texas | 48237 | 474 | 10 |
903706 | 903706 | 2021-01-06 | Jack | Texas | 48237 | 471 | 10 |
900461 | 900461 | 2021-01-05 | Jack | Texas | 48237 | 439 | 10 |
897216 | 897216 | 2021-01-04 | Jack | Texas | 48237 | 423 | 9 |
893970 | 893970 | 2021-01-03 | Jack | Texas | 48237 | 423 | 9 |
890724 | 890724 | 2021-01-02 | Jack | Texas | 48237 | 423 | 9 |
887477 | 887477 | 2021-01-01 | Jack | Texas | 48237 | 423 | 9 |
884232 | 884232 | 2020-12-31 | Jack | Texas | 48237 | 417 | 9 |
880987 | 880987 | 2020-12-30 | Jack | Texas | 48237 | 412 | 9 |
877742 | 877742 | 2020-12-29 | Jack | Texas | 48237 | 408 | 9 |
874497 | 874497 | 2020-12-28 | Jack | Texas | 48237 | 395 | 9 |
871252 | 871252 | 2020-12-27 | Jack | Texas | 48237 | 395 | 9 |
868007 | 868007 | 2020-12-26 | Jack | Texas | 48237 | 388 | 9 |
864762 | 864762 | 2020-12-25 | Jack | Texas | 48237 | 388 | 9 |
861517 | 861517 | 2020-12-24 | Jack | Texas | 48237 | 388 | 9 |
858272 | 858272 | 2020-12-23 | Jack | Texas | 48237 | 376 | 9 |
855027 | 855027 | 2020-12-22 | Jack | Texas | 48237 | 371 | 9 |
851782 | 851782 | 2020-12-21 | Jack | Texas | 48237 | 359 | 9 |
848537 | 848537 | 2020-12-20 | Jack | Texas | 48237 | 359 | 9 |
845292 | 845292 | 2020-12-19 | Jack | Texas | 48237 | 359 | 9 |
842046 | 842046 | 2020-12-18 | Jack | Texas | 48237 | 357 | 9 |
838801 | 838801 | 2020-12-17 | Jack | Texas | 48237 | 352 | 9 |
835555 | 835555 | 2020-12-16 | Jack | Texas | 48237 | 349 | 9 |
832309 | 832309 | 2020-12-15 | Jack | Texas | 48237 | 346 | 9 |
829062 | 829062 | 2020-12-14 | Jack | Texas | 48237 | 339 | 7 |
825816 | 825816 | 2020-12-13 | Jack | Texas | 48237 | 339 | 7 |
822569 | 822569 | 2020-12-12 | Jack | Texas | 48237 | 339 | 7 |
819323 | 819323 | 2020-12-11 | Jack | Texas | 48237 | 331 | 5 |
816077 | 816077 | 2020-12-10 | Jack | Texas | 48237 | 296 | 5 |
812831 | 812831 | 2020-12-09 | Jack | Texas | 48237 | 295 | 4 |
809587 | 809587 | 2020-12-08 | Jack | Texas | 48237 | 294 | 4 |
806342 | 806342 | 2020-12-07 | Jack | Texas | 48237 | 281 | 4 |
803097 | 803097 | 2020-12-06 | Jack | Texas | 48237 | 281 | 4 |
799852 | 799852 | 2020-12-05 | Jack | Texas | 48237 | 281 | 4 |
796607 | 796607 | 2020-12-04 | Jack | Texas | 48237 | 277 | 4 |
793362 | 793362 | 2020-12-03 | Jack | Texas | 48237 | 278 | 4 |
790117 | 790117 | 2020-12-02 | Jack | Texas | 48237 | 272 | 4 |
786872 | 786872 | 2020-12-01 | Jack | Texas | 48237 | 253 | 3 |
783628 | 783628 | 2020-11-30 | Jack | Texas | 48237 | 253 | 3 |
780383 | 780383 | 2020-11-29 | Jack | Texas | 48237 | 253 | 3 |
777137 | 777137 | 2020-11-28 | Jack | Texas | 48237 | 247 | 3 |
773892 | 773892 | 2020-11-27 | Jack | Texas | 48237 | 247 | 3 |
770647 | 770647 | 2020-11-26 | Jack | Texas | 48237 | 247 | 3 |
767401 | 767401 | 2020-11-25 | Jack | Texas | 48237 | 234 | 3 |
764156 | 764156 | 2020-11-24 | Jack | Texas | 48237 | 231 | 3 |
760911 | 760911 | 2020-11-23 | Jack | Texas | 48237 | 215 | 3 |
757666 | 757666 | 2020-11-22 | Jack | Texas | 48237 | 215 | 3 |
754419 | 754419 | 2020-11-21 | Jack | Texas | 48237 | 215 | 3 |
751173 | 751173 | 2020-11-20 | Jack | Texas | 48237 | 214 | 3 |
747927 | 747927 | 2020-11-19 | Jack | Texas | 48237 | 211 | 3 |
744681 | 744681 | 2020-11-18 | Jack | Texas | 48237 | 206 | 3 |
741434 | 741434 | 2020-11-17 | Jack | Texas | 48237 | 201 | 3 |
738188 | 738188 | 2020-11-16 | Jack | Texas | 48237 | 196 | 3 |
734944 | 734944 | 2020-11-15 | Jack | Texas | 48237 | 196 | 3 |
731698 | 731698 | 2020-11-14 | Jack | Texas | 48237 | 196 | 3 |
728453 | 728453 | 2020-11-13 | Jack | Texas | 48237 | 187 | 3 |
725210 | 725210 | 2020-11-12 | Jack | Texas | 48237 | 186 | 3 |
721967 | 721967 | 2020-11-11 | Jack | Texas | 48237 | 186 | 3 |
718724 | 718724 | 2020-11-10 | Jack | Texas | 48237 | 182 | 3 |
715481 | 715481 | 2020-11-09 | Jack | Texas | 48237 | 162 | 3 |
712237 | 712237 | 2020-11-08 | Jack | Texas | 48237 | 162 | 3 |
708993 | 708993 | 2020-11-07 | Jack | Texas | 48237 | 162 | 3 |
705749 | 705749 | 2020-11-06 | Jack | Texas | 48237 | 162 | 3 |
702506 | 702506 | 2020-11-05 | Jack | Texas | 48237 | 159 | 3 |
699263 | 699263 | 2020-11-04 | Jack | Texas | 48237 | 158 | 3 |
696019 | 696019 | 2020-11-03 | Jack | Texas | 48237 | 158 | 3 |
692777 | 692777 | 2020-11-02 | Jack | Texas | 48237 | 155 | 3 |
689533 | 689533 | 2020-11-01 | Jack | Texas | 48237 | 155 | 3 |
686288 | 686288 | 2020-10-31 | Jack | Texas | 48237 | 155 | 3 |
683045 | 683045 | 2020-10-30 | Jack | Texas | 48237 | 153 | 3 |
679802 | 679802 | 2020-10-29 | Jack | Texas | 48237 | 153 | 3 |
676559 | 676559 | 2020-10-28 | Jack | Texas | 48237 | 153 | 3 |
673316 | 673316 | 2020-10-27 | Jack | Texas | 48237 | 152 | 3 |
670074 | 670074 | 2020-10-26 | Jack | Texas | 48237 | 151 | 3 |
666831 | 666831 | 2020-10-25 | Jack | Texas | 48237 | 151 | 3 |
663586 | 663586 | 2020-10-24 | Jack | Texas | 48237 | 151 | 3 |
660342 | 660342 | 2020-10-23 | Jack | Texas | 48237 | 150 | 3 |
657098 | 657098 | 2020-10-22 | Jack | Texas | 48237 | 149 | 3 |
653853 | 653853 | 2020-10-21 | Jack | Texas | 48237 | 149 | 3 |
650608 | 650608 | 2020-10-20 | Jack | Texas | 48237 | 148 | 3 |
647364 | 647364 | 2020-10-19 | Jack | Texas | 48237 | 148 | 3 |
644118 | 644118 | 2020-10-18 | Jack | Texas | 48237 | 148 | 3 |
640870 | 640870 | 2020-10-17 | Jack | Texas | 48237 | 148 | 3 |
637623 | 637623 | 2020-10-16 | Jack | Texas | 48237 | 147 | 3 |
634378 | 634378 | 2020-10-15 | Jack | Texas | 48237 | 147 | 3 |
631133 | 631133 | 2020-10-14 | Jack | Texas | 48237 | 144 | 3 |
627889 | 627889 | 2020-10-13 | Jack | Texas | 48237 | 143 | 3 |
624647 | 624647 | 2020-10-12 | Jack | Texas | 48237 | 143 | 3 |
621404 | 621404 | 2020-10-11 | Jack | Texas | 48237 | 143 | 3 |
618161 | 618161 | 2020-10-10 | Jack | Texas | 48237 | 143 | 3 |
614919 | 614919 | 2020-10-09 | Jack | Texas | 48237 | 143 | 3 |
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);