ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 48309 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923219 | 923219 | 2021-01-12 | McLennan | Texas | 48309 | 21296 | 323 |
919974 | 919974 | 2021-01-11 | McLennan | Texas | 48309 | 20829 | 319 |
916729 | 916729 | 2021-01-10 | McLennan | Texas | 48309 | 20594 | 319 |
913484 | 913484 | 2021-01-09 | McLennan | Texas | 48309 | 20594 | 312 |
910239 | 910239 | 2021-01-08 | McLennan | Texas | 48309 | 20471 | 305 |
906994 | 906994 | 2021-01-07 | McLennan | Texas | 48309 | 20303 | 300 |
903748 | 903748 | 2021-01-06 | McLennan | Texas | 48309 | 20006 | 295 |
900503 | 900503 | 2021-01-05 | McLennan | Texas | 48309 | 19798 | 292 |
897258 | 897258 | 2021-01-04 | McLennan | Texas | 48309 | 19561 | 288 |
894012 | 894012 | 2021-01-03 | McLennan | Texas | 48309 | 19026 | 289 |
890766 | 890766 | 2021-01-02 | McLennan | Texas | 48309 | 19026 | 286 |
887519 | 887519 | 2021-01-01 | McLennan | Texas | 48309 | 19026 | 284 |
884274 | 884274 | 2020-12-31 | McLennan | Texas | 48309 | 19026 | 283 |
881029 | 881029 | 2020-12-30 | McLennan | Texas | 48309 | 18780 | 281 |
877784 | 877784 | 2020-12-29 | McLennan | Texas | 48309 | 18559 | 277 |
874539 | 874539 | 2020-12-28 | McLennan | Texas | 48309 | 18350 | 273 |
871294 | 871294 | 2020-12-27 | McLennan | Texas | 48309 | 17809 | 263 |
868049 | 868049 | 2020-12-26 | McLennan | Texas | 48309 | 17809 | 263 |
864804 | 864804 | 2020-12-25 | McLennan | Texas | 48309 | 17809 | 263 |
861559 | 861559 | 2020-12-24 | McLennan | Texas | 48309 | 17809 | 263 |
858314 | 858314 | 2020-12-23 | McLennan | Texas | 48309 | 17809 | 263 |
855069 | 855069 | 2020-12-22 | McLennan | Texas | 48309 | 17649 | 258 |
851824 | 851824 | 2020-12-21 | McLennan | Texas | 48309 | 17467 | 255 |
848579 | 848579 | 2020-12-20 | McLennan | Texas | 48309 | 17249 | 253 |
845334 | 845334 | 2020-12-19 | McLennan | Texas | 48309 | 17249 | 253 |
842088 | 842088 | 2020-12-18 | McLennan | Texas | 48309 | 17087 | 248 |
838843 | 838843 | 2020-12-17 | McLennan | Texas | 48309 | 16947 | 243 |
835597 | 835597 | 2020-12-16 | McLennan | Texas | 48309 | 16818 | 241 |
832351 | 832351 | 2020-12-15 | McLennan | Texas | 48309 | 16570 | 239 |
829104 | 829104 | 2020-12-14 | McLennan | Texas | 48309 | 16431 | 236 |
825858 | 825858 | 2020-12-13 | McLennan | Texas | 48309 | 16274 | 233 |
822611 | 822611 | 2020-12-12 | McLennan | Texas | 48309 | 16274 | 233 |
819365 | 819365 | 2020-12-11 | McLennan | Texas | 48309 | 16127 | 233 |
816119 | 816119 | 2020-12-10 | McLennan | Texas | 48309 | 15990 | 229 |
812873 | 812873 | 2020-12-09 | McLennan | Texas | 48309 | 15880 | 227 |
809629 | 809629 | 2020-12-08 | McLennan | Texas | 48309 | 15440 | 222 |
806384 | 806384 | 2020-12-07 | McLennan | Texas | 48309 | 15331 | 220 |
803139 | 803139 | 2020-12-06 | McLennan | Texas | 48309 | 15092 | 211 |
799894 | 799894 | 2020-12-05 | McLennan | Texas | 48309 | 15092 | 211 |
796649 | 796649 | 2020-12-04 | McLennan | Texas | 48309 | 14937 | 210 |
793404 | 793404 | 2020-12-03 | McLennan | Texas | 48309 | 14813 | 205 |
790159 | 790159 | 2020-12-02 | McLennan | Texas | 48309 | 14672 | 203 |
786914 | 786914 | 2020-12-01 | McLennan | Texas | 48309 | 14531 | 198 |
783670 | 783670 | 2020-11-30 | McLennan | Texas | 48309 | 14410 | 197 |
780425 | 780425 | 2020-11-29 | McLennan | Texas | 48309 | 14029 | 187 |
777179 | 777179 | 2020-11-28 | McLennan | Texas | 48309 | 14029 | 187 |
773934 | 773934 | 2020-11-27 | McLennan | Texas | 48309 | 14029 | 187 |
770689 | 770689 | 2020-11-26 | McLennan | Texas | 48309 | 14029 | 187 |
767443 | 767443 | 2020-11-25 | McLennan | Texas | 48309 | 14029 | 185 |
764198 | 764198 | 2020-11-24 | McLennan | Texas | 48309 | 13817 | 182 |
760953 | 760953 | 2020-11-23 | McLennan | Texas | 48309 | 13630 | 181 |
757708 | 757708 | 2020-11-22 | McLennan | Texas | 48309 | 13375 | 179 |
754461 | 754461 | 2020-11-21 | McLennan | Texas | 48309 | 13375 | 179 |
751215 | 751215 | 2020-11-20 | McLennan | Texas | 48309 | 13156 | 176 |
747969 | 747969 | 2020-11-19 | McLennan | Texas | 48309 | 12947 | 174 |
744723 | 744723 | 2020-11-18 | McLennan | Texas | 48309 | 12761 | 174 |
741476 | 741476 | 2020-11-17 | McLennan | Texas | 48309 | 12572 | 170 |
738229 | 738229 | 2020-11-16 | McLennan | Texas | 48309 | 12323 | 170 |
734985 | 734985 | 2020-11-15 | McLennan | Texas | 48309 | 12106 | 168 |
731739 | 731739 | 2020-11-14 | McLennan | Texas | 48309 | 12106 | 168 |
728494 | 728494 | 2020-11-13 | McLennan | Texas | 48309 | 11956 | 168 |
725251 | 725251 | 2020-11-12 | McLennan | Texas | 48309 | 11778 | 168 |
722008 | 722008 | 2020-11-11 | McLennan | Texas | 48309 | 11625 | 165 |
718765 | 718765 | 2020-11-10 | McLennan | Texas | 48309 | 11408 | 165 |
715522 | 715522 | 2020-11-09 | McLennan | Texas | 48309 | 11289 | 164 |
712278 | 712278 | 2020-11-08 | McLennan | Texas | 48309 | 11093 | 162 |
709034 | 709034 | 2020-11-07 | McLennan | Texas | 48309 | 11093 | 162 |
705790 | 705790 | 2020-11-06 | McLennan | Texas | 48309 | 10917 | 162 |
702547 | 702547 | 2020-11-05 | McLennan | Texas | 48309 | 10784 | 160 |
699304 | 699304 | 2020-11-04 | McLennan | Texas | 48309 | 10674 | 160 |
696060 | 696060 | 2020-11-03 | McLennan | Texas | 48309 | 10528 | 158 |
692818 | 692818 | 2020-11-02 | McLennan | Texas | 48309 | 10450 | 157 |
689574 | 689574 | 2020-11-01 | McLennan | Texas | 48309 | 10316 | 155 |
686329 | 686329 | 2020-10-31 | McLennan | Texas | 48309 | 10316 | 155 |
683086 | 683086 | 2020-10-30 | McLennan | Texas | 48309 | 10263 | 155 |
679843 | 679843 | 2020-10-29 | McLennan | Texas | 48309 | 10194 | 154 |
676600 | 676600 | 2020-10-28 | McLennan | Texas | 48309 | 10077 | 154 |
673357 | 673357 | 2020-10-27 | McLennan | Texas | 48309 | 10014 | 151 |
670115 | 670115 | 2020-10-26 | McLennan | Texas | 48309 | 9961 | 151 |
666872 | 666872 | 2020-10-25 | McLennan | Texas | 48309 | 9893 | 149 |
663627 | 663627 | 2020-10-24 | McLennan | Texas | 48309 | 9846 | 147 |
660383 | 660383 | 2020-10-23 | McLennan | Texas | 48309 | 9772 | 145 |
657139 | 657139 | 2020-10-22 | McLennan | Texas | 48309 | 9695 | 144 |
653894 | 653894 | 2020-10-21 | McLennan | Texas | 48309 | 9632 | 142 |
650649 | 650649 | 2020-10-20 | McLennan | Texas | 48309 | 9573 | 140 |
647405 | 647405 | 2020-10-19 | McLennan | Texas | 48309 | 9503 | 138 |
644159 | 644159 | 2020-10-18 | McLennan | Texas | 48309 | 9431 | 138 |
640911 | 640911 | 2020-10-17 | McLennan | Texas | 48309 | 9399 | 137 |
637664 | 637664 | 2020-10-16 | McLennan | Texas | 48309 | 9290 | 134 |
634419 | 634419 | 2020-10-15 | McLennan | Texas | 48309 | 9243 | 132 |
631174 | 631174 | 2020-10-14 | McLennan | Texas | 48309 | 9187 | 131 |
627930 | 627930 | 2020-10-13 | McLennan | Texas | 48309 | 9125 | 129 |
624687 | 624687 | 2020-10-12 | McLennan | Texas | 48309 | 9029 | 127 |
621444 | 621444 | 2020-10-11 | McLennan | Texas | 48309 | 8963 | 125 |
618201 | 618201 | 2020-10-10 | McLennan | Texas | 48309 | 8934 | 125 |
614959 | 614959 | 2020-10-09 | McLennan | Texas | 48309 | 8879 | 124 |
611718 | 611718 | 2020-10-08 | McLennan | Texas | 48309 | 8800 | 123 |
608476 | 608476 | 2020-10-07 | McLennan | Texas | 48309 | 8716 | 122 |
605233 | 605233 | 2020-10-06 | McLennan | Texas | 48309 | 8642 | 119 |
601991 | 601991 | 2020-10-05 | McLennan | Texas | 48309 | 8583 | 119 |
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);