ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Lubbock" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923210 | 923210 | 2021-01-12 | Lubbock | Texas | 48303 | 44757 | 618 |
919965 | 919965 | 2021-01-11 | Lubbock | Texas | 48303 | 44547 | 615 |
916720 | 916720 | 2021-01-10 | Lubbock | Texas | 48303 | 44411 | 611 |
913475 | 913475 | 2021-01-09 | Lubbock | Texas | 48303 | 44238 | 606 |
910230 | 910230 | 2021-01-08 | Lubbock | Texas | 48303 | 44095 | 602 |
906985 | 906985 | 2021-01-07 | Lubbock | Texas | 48303 | 43729 | 597 |
903739 | 903739 | 2021-01-06 | Lubbock | Texas | 48303 | 43553 | 592 |
900494 | 900494 | 2021-01-05 | Lubbock | Texas | 48303 | 43266 | 584 |
897249 | 897249 | 2021-01-04 | Lubbock | Texas | 48303 | 42951 | 576 |
894003 | 894003 | 2021-01-03 | Lubbock | Texas | 48303 | 42689 | 573 |
890757 | 890757 | 2021-01-02 | Lubbock | Texas | 48303 | 42624 | 573 |
887510 | 887510 | 2021-01-01 | Lubbock | Texas | 48303 | 42134 | 571 |
884265 | 884265 | 2020-12-31 | Lubbock | Texas | 48303 | 42134 | 561 |
881020 | 881020 | 2020-12-30 | Lubbock | Texas | 48303 | 41878 | 552 |
877775 | 877775 | 2020-12-29 | Lubbock | Texas | 48303 | 41603 | 543 |
874530 | 874530 | 2020-12-28 | Lubbock | Texas | 48303 | 41205 | 538 |
871285 | 871285 | 2020-12-27 | Lubbock | Texas | 48303 | 41034 | 531 |
868040 | 868040 | 2020-12-26 | Lubbock | Texas | 48303 | 40929 | 524 |
864795 | 864795 | 2020-12-25 | Lubbock | Texas | 48303 | 40453 | 523 |
861550 | 861550 | 2020-12-24 | Lubbock | Texas | 48303 | 40453 | 523 |
858305 | 858305 | 2020-12-23 | Lubbock | Texas | 48303 | 40249 | 523 |
855060 | 855060 | 2020-12-22 | Lubbock | Texas | 48303 | 39850 | 520 |
851815 | 851815 | 2020-12-21 | Lubbock | Texas | 48303 | 39498 | 514 |
848570 | 848570 | 2020-12-20 | Lubbock | Texas | 48303 | 39208 | 508 |
845325 | 845325 | 2020-12-19 | Lubbock | Texas | 48303 | 38890 | 505 |
842079 | 842079 | 2020-12-18 | Lubbock | Texas | 48303 | 38541 | 501 |
838834 | 838834 | 2020-12-17 | Lubbock | Texas | 48303 | 38273 | 495 |
835588 | 835588 | 2020-12-16 | Lubbock | Texas | 48303 | 37786 | 485 |
832342 | 832342 | 2020-12-15 | Lubbock | Texas | 48303 | 37528 | 474 |
829095 | 829095 | 2020-12-14 | Lubbock | Texas | 48303 | 36933 | 465 |
825849 | 825849 | 2020-12-13 | Lubbock | Texas | 48303 | 36611 | 459 |
822602 | 822602 | 2020-12-12 | Lubbock | Texas | 48303 | 36261 | 457 |
819356 | 819356 | 2020-12-11 | Lubbock | Texas | 48303 | 35977 | 446 |
816110 | 816110 | 2020-12-10 | Lubbock | Texas | 48303 | 35684 | 436 |
812864 | 812864 | 2020-12-09 | Lubbock | Texas | 48303 | 35078 | 427 |
809620 | 809620 | 2020-12-08 | Lubbock | Texas | 48303 | 35078 | 410 |
806375 | 806375 | 2020-12-07 | Lubbock | Texas | 48303 | 34886 | 402 |
803130 | 803130 | 2020-12-06 | Lubbock | Texas | 48303 | 34722 | 402 |
799885 | 799885 | 2020-12-05 | Lubbock | Texas | 48303 | 34074 | 400 |
796640 | 796640 | 2020-12-04 | Lubbock | Texas | 48303 | 34074 | 394 |
793395 | 793395 | 2020-12-03 | Lubbock | Texas | 48303 | 33864 | 381 |
790150 | 790150 | 2020-12-02 | Lubbock | Texas | 48303 | 33271 | 371 |
786905 | 786905 | 2020-12-01 | Lubbock | Texas | 48303 | 33045 | 364 |
783661 | 783661 | 2020-11-30 | Lubbock | Texas | 48303 | 32426 | 359 |
780416 | 780416 | 2020-11-29 | Lubbock | Texas | 48303 | 32236 | 355 |
777170 | 777170 | 2020-11-28 | Lubbock | Texas | 48303 | 31858 | 351 |
773925 | 773925 | 2020-11-27 | Lubbock | Texas | 48303 | 31499 | 345 |
770680 | 770680 | 2020-11-26 | Lubbock | Texas | 48303 | 30911 | 340 |
767434 | 767434 | 2020-11-25 | Lubbock | Texas | 48303 | 30592 | 334 |
764189 | 764189 | 2020-11-24 | Lubbock | Texas | 48303 | 30054 | 325 |
760944 | 760944 | 2020-11-23 | Lubbock | Texas | 48303 | 29378 | 307 |
757699 | 757699 | 2020-11-22 | Lubbock | Texas | 48303 | 28873 | 303 |
754452 | 754452 | 2020-11-21 | Lubbock | Texas | 48303 | 28375 | 300 |
751206 | 751206 | 2020-11-20 | Lubbock | Texas | 48303 | 28134 | 296 |
747960 | 747960 | 2020-11-19 | Lubbock | Texas | 48303 | 27660 | 292 |
744714 | 744714 | 2020-11-18 | Lubbock | Texas | 48303 | 27105 | 286 |
741467 | 741467 | 2020-11-17 | Lubbock | Texas | 48303 | 26693 | 282 |
738220 | 738220 | 2020-11-16 | Lubbock | Texas | 48303 | 26145 | 277 |
734976 | 734976 | 2020-11-15 | Lubbock | Texas | 48303 | 25810 | 273 |
731730 | 731730 | 2020-11-14 | Lubbock | Texas | 48303 | 25038 | 272 |
728485 | 728485 | 2020-11-13 | Lubbock | Texas | 48303 | 24846 | 269 |
725242 | 725242 | 2020-11-12 | Lubbock | Texas | 48303 | 24337 | 264 |
721999 | 721999 | 2020-11-11 | Lubbock | Texas | 48303 | 23913 | 257 |
718756 | 718756 | 2020-11-10 | Lubbock | Texas | 48303 | 23473 | 253 |
715513 | 715513 | 2020-11-09 | Lubbock | Texas | 48303 | 23148 | 248 |
712269 | 712269 | 2020-11-08 | Lubbock | Texas | 48303 | 22634 | 243 |
709025 | 709025 | 2020-11-07 | Lubbock | Texas | 48303 | 22323 | 243 |
705781 | 705781 | 2020-11-06 | Lubbock | Texas | 48303 | 22184 | 237 |
702538 | 702538 | 2020-11-05 | Lubbock | Texas | 48303 | 21746 | 234 |
699295 | 699295 | 2020-11-04 | Lubbock | Texas | 48303 | 21319 | 230 |
696051 | 696051 | 2020-11-03 | Lubbock | Texas | 48303 | 20788 | 222 |
692809 | 692809 | 2020-11-02 | Lubbock | Texas | 48303 | 20328 | 214 |
689565 | 689565 | 2020-11-01 | Lubbock | Texas | 48303 | 19751 | 208 |
686320 | 686320 | 2020-10-31 | Lubbock | Texas | 48303 | 19418 | 208 |
683077 | 683077 | 2020-10-30 | Lubbock | Texas | 48303 | 19167 | 206 |
679834 | 679834 | 2020-10-29 | Lubbock | Texas | 48303 | 18985 | 202 |
676591 | 676591 | 2020-10-28 | Lubbock | Texas | 48303 | 18712 | 195 |
673348 | 673348 | 2020-10-27 | Lubbock | Texas | 48303 | 18015 | 188 |
670106 | 670106 | 2020-10-26 | Lubbock | Texas | 48303 | 17703 | 184 |
666863 | 666863 | 2020-10-25 | Lubbock | Texas | 48303 | 17478 | 175 |
663618 | 663618 | 2020-10-24 | Lubbock | Texas | 48303 | 16911 | 174 |
660374 | 660374 | 2020-10-23 | Lubbock | Texas | 48303 | 16911 | 174 |
657130 | 657130 | 2020-10-22 | Lubbock | Texas | 48303 | 16602 | 173 |
653885 | 653885 | 2020-10-21 | Lubbock | Texas | 48303 | 16417 | 168 |
650640 | 650640 | 2020-10-20 | Lubbock | Texas | 48303 | 16130 | 165 |
647396 | 647396 | 2020-10-19 | Lubbock | Texas | 48303 | 15908 | 157 |
644150 | 644150 | 2020-10-18 | Lubbock | Texas | 48303 | 15626 | 157 |
640902 | 640902 | 2020-10-17 | Lubbock | Texas | 48303 | 15401 | 156 |
637655 | 637655 | 2020-10-16 | Lubbock | Texas | 48303 | 15174 | 156 |
634410 | 634410 | 2020-10-15 | Lubbock | Texas | 48303 | 14921 | 152 |
631165 | 631165 | 2020-10-14 | Lubbock | Texas | 48303 | 14675 | 152 |
627921 | 627921 | 2020-10-13 | Lubbock | Texas | 48303 | 14377 | 149 |
624678 | 624678 | 2020-10-12 | Lubbock | Texas | 48303 | 14006 | 139 |
621435 | 621435 | 2020-10-11 | Lubbock | Texas | 48303 | 14006 | 139 |
618192 | 618192 | 2020-10-10 | Lubbock | Texas | 48303 | 13756 | 138 |
614950 | 614950 | 2020-10-09 | Lubbock | Texas | 48303 | 13515 | 137 |
611709 | 611709 | 2020-10-08 | Lubbock | Texas | 48303 | 13283 | 137 |
608467 | 608467 | 2020-10-07 | Lubbock | Texas | 48303 | 13070 | 135 |
605224 | 605224 | 2020-10-06 | Lubbock | Texas | 48303 | 12939 | 134 |
601982 | 601982 | 2020-10-05 | Lubbock | Texas | 48303 | 12766 | 132 |
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);