ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
758 rows where fips = 48315 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923213 | 923213 | 2021-01-12 | Marion | Texas | 48315 | 338 | 19 |
919968 | 919968 | 2021-01-11 | Marion | Texas | 48315 | 321 | 19 |
916723 | 916723 | 2021-01-10 | Marion | Texas | 48315 | 316 | 19 |
913478 | 913478 | 2021-01-09 | Marion | Texas | 48315 | 309 | 19 |
910233 | 910233 | 2021-01-08 | Marion | Texas | 48315 | 305 | 18 |
906988 | 906988 | 2021-01-07 | Marion | Texas | 48315 | 303 | 18 |
903742 | 903742 | 2021-01-06 | Marion | Texas | 48315 | 297 | 17 |
900497 | 900497 | 2021-01-05 | Marion | Texas | 48315 | 282 | 17 |
897252 | 897252 | 2021-01-04 | Marion | Texas | 48315 | 277 | 17 |
894006 | 894006 | 2021-01-03 | Marion | Texas | 48315 | 270 | 17 |
890760 | 890760 | 2021-01-02 | Marion | Texas | 48315 | 265 | 17 |
887513 | 887513 | 2021-01-01 | Marion | Texas | 48315 | 261 | 17 |
884268 | 884268 | 2020-12-31 | Marion | Texas | 48315 | 261 | 17 |
881023 | 881023 | 2020-12-30 | Marion | Texas | 48315 | 254 | 17 |
877778 | 877778 | 2020-12-29 | Marion | Texas | 48315 | 252 | 17 |
874533 | 874533 | 2020-12-28 | Marion | Texas | 48315 | 251 | 17 |
871288 | 871288 | 2020-12-27 | Marion | Texas | 48315 | 251 | 17 |
868043 | 868043 | 2020-12-26 | Marion | Texas | 48315 | 251 | 17 |
864798 | 864798 | 2020-12-25 | Marion | Texas | 48315 | 250 | 17 |
861553 | 861553 | 2020-12-24 | Marion | Texas | 48315 | 250 | 17 |
858308 | 858308 | 2020-12-23 | Marion | Texas | 48315 | 247 | 17 |
855063 | 855063 | 2020-12-22 | Marion | Texas | 48315 | 247 | 17 |
851818 | 851818 | 2020-12-21 | Marion | Texas | 48315 | 246 | 17 |
848573 | 848573 | 2020-12-20 | Marion | Texas | 48315 | 246 | 17 |
845328 | 845328 | 2020-12-19 | Marion | Texas | 48315 | 246 | 17 |
842082 | 842082 | 2020-12-18 | Marion | Texas | 48315 | 238 | 17 |
838837 | 838837 | 2020-12-17 | Marion | Texas | 48315 | 237 | 17 |
835591 | 835591 | 2020-12-16 | Marion | Texas | 48315 | 236 | 17 |
832345 | 832345 | 2020-12-15 | Marion | Texas | 48315 | 233 | 17 |
829098 | 829098 | 2020-12-14 | Marion | Texas | 48315 | 229 | 17 |
825852 | 825852 | 2020-12-13 | Marion | Texas | 48315 | 229 | 17 |
822605 | 822605 | 2020-12-12 | Marion | Texas | 48315 | 228 | 17 |
819359 | 819359 | 2020-12-11 | Marion | Texas | 48315 | 227 | 17 |
816113 | 816113 | 2020-12-10 | Marion | Texas | 48315 | 191 | 17 |
812867 | 812867 | 2020-12-09 | Marion | Texas | 48315 | 191 | 17 |
809623 | 809623 | 2020-12-08 | Marion | Texas | 48315 | 189 | 17 |
806378 | 806378 | 2020-12-07 | Marion | Texas | 48315 | 187 | 17 |
803133 | 803133 | 2020-12-06 | Marion | Texas | 48315 | 187 | 17 |
799888 | 799888 | 2020-12-05 | Marion | Texas | 48315 | 187 | 17 |
796643 | 796643 | 2020-12-04 | Marion | Texas | 48315 | 186 | 17 |
793398 | 793398 | 2020-12-03 | Marion | Texas | 48315 | 186 | 17 |
790153 | 790153 | 2020-12-02 | Marion | Texas | 48315 | 186 | 17 |
786908 | 786908 | 2020-12-01 | Marion | Texas | 48315 | 184 | 16 |
783664 | 783664 | 2020-11-30 | Marion | Texas | 48315 | 184 | 16 |
780419 | 780419 | 2020-11-29 | Marion | Texas | 48315 | 184 | 16 |
777173 | 777173 | 2020-11-28 | Marion | Texas | 48315 | 184 | 16 |
773928 | 773928 | 2020-11-27 | Marion | Texas | 48315 | 184 | 16 |
770683 | 770683 | 2020-11-26 | Marion | Texas | 48315 | 184 | 16 |
767437 | 767437 | 2020-11-25 | Marion | Texas | 48315 | 184 | 16 |
764192 | 764192 | 2020-11-24 | Marion | Texas | 48315 | 182 | 16 |
760947 | 760947 | 2020-11-23 | Marion | Texas | 48315 | 182 | 15 |
757702 | 757702 | 2020-11-22 | Marion | Texas | 48315 | 182 | 15 |
754455 | 754455 | 2020-11-21 | Marion | Texas | 48315 | 182 | 15 |
751209 | 751209 | 2020-11-20 | Marion | Texas | 48315 | 182 | 15 |
747963 | 747963 | 2020-11-19 | Marion | Texas | 48315 | 182 | 15 |
744717 | 744717 | 2020-11-18 | Marion | Texas | 48315 | 182 | 15 |
741470 | 741470 | 2020-11-17 | Marion | Texas | 48315 | 181 | 15 |
738223 | 738223 | 2020-11-16 | Marion | Texas | 48315 | 181 | 15 |
734979 | 734979 | 2020-11-15 | Marion | Texas | 48315 | 181 | 15 |
731733 | 731733 | 2020-11-14 | Marion | Texas | 48315 | 181 | 15 |
728488 | 728488 | 2020-11-13 | Marion | Texas | 48315 | 181 | 15 |
725245 | 725245 | 2020-11-12 | Marion | Texas | 48315 | 180 | 14 |
722002 | 722002 | 2020-11-11 | Marion | Texas | 48315 | 180 | 14 |
718759 | 718759 | 2020-11-10 | Marion | Texas | 48315 | 180 | 14 |
715516 | 715516 | 2020-11-09 | Marion | Texas | 48315 | 177 | 14 |
712272 | 712272 | 2020-11-08 | Marion | Texas | 48315 | 177 | 14 |
709028 | 709028 | 2020-11-07 | Marion | Texas | 48315 | 175 | 14 |
705784 | 705784 | 2020-11-06 | Marion | Texas | 48315 | 175 | 14 |
702541 | 702541 | 2020-11-05 | Marion | Texas | 48315 | 174 | 14 |
699298 | 699298 | 2020-11-04 | Marion | Texas | 48315 | 174 | 14 |
696054 | 696054 | 2020-11-03 | Marion | Texas | 48315 | 174 | 14 |
692812 | 692812 | 2020-11-02 | Marion | Texas | 48315 | 173 | 14 |
689568 | 689568 | 2020-11-01 | Marion | Texas | 48315 | 173 | 14 |
686323 | 686323 | 2020-10-31 | Marion | Texas | 48315 | 172 | 14 |
683080 | 683080 | 2020-10-30 | Marion | Texas | 48315 | 172 | 14 |
679837 | 679837 | 2020-10-29 | Marion | Texas | 48315 | 172 | 14 |
676594 | 676594 | 2020-10-28 | Marion | Texas | 48315 | 172 | 14 |
673351 | 673351 | 2020-10-27 | Marion | Texas | 48315 | 170 | 14 |
670109 | 670109 | 2020-10-26 | Marion | Texas | 48315 | 170 | 14 |
666866 | 666866 | 2020-10-25 | Marion | Texas | 48315 | 170 | 14 |
663621 | 663621 | 2020-10-24 | Marion | Texas | 48315 | 170 | 14 |
660377 | 660377 | 2020-10-23 | Marion | Texas | 48315 | 170 | 14 |
657133 | 657133 | 2020-10-22 | Marion | Texas | 48315 | 168 | 14 |
653888 | 653888 | 2020-10-21 | Marion | Texas | 48315 | 168 | 14 |
650643 | 650643 | 2020-10-20 | Marion | Texas | 48315 | 164 | 14 |
647399 | 647399 | 2020-10-19 | Marion | Texas | 48315 | 163 | 14 |
644153 | 644153 | 2020-10-18 | Marion | Texas | 48315 | 163 | 14 |
640905 | 640905 | 2020-10-17 | Marion | Texas | 48315 | 163 | 14 |
637658 | 637658 | 2020-10-16 | Marion | Texas | 48315 | 162 | 14 |
634413 | 634413 | 2020-10-15 | Marion | Texas | 48315 | 162 | 14 |
631168 | 631168 | 2020-10-14 | Marion | Texas | 48315 | 162 | 14 |
627924 | 627924 | 2020-10-13 | Marion | Texas | 48315 | 160 | 14 |
624681 | 624681 | 2020-10-12 | Marion | Texas | 48315 | 158 | 14 |
621438 | 621438 | 2020-10-11 | Marion | Texas | 48315 | 158 | 14 |
618195 | 618195 | 2020-10-10 | Marion | Texas | 48315 | 158 | 14 |
614953 | 614953 | 2020-10-09 | Marion | Texas | 48315 | 158 | 14 |
611712 | 611712 | 2020-10-08 | Marion | Texas | 48315 | 156 | 14 |
608470 | 608470 | 2020-10-07 | Marion | Texas | 48315 | 156 | 14 |
605227 | 605227 | 2020-10-06 | Marion | Texas | 48315 | 156 | 14 |
601985 | 601985 | 2020-10-05 | Marion | Texas | 48315 | 153 | 14 |
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);