ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "McLennan" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1056288 | 1056288 | 2021-02-22 | McLennan | Texas | 48309 | 24747 | 424 |
1053042 | 1053042 | 2021-02-21 | McLennan | Texas | 48309 | 24268 | 424 |
1049795 | 1049795 | 2021-02-20 | McLennan | Texas | 48309 | 24268 | 423 |
1046548 | 1046548 | 2021-02-19 | McLennan | Texas | 48309 | 24268 | 421 |
1043303 | 1043303 | 2021-02-18 | McLennan | Texas | 48309 | 24268 | 421 |
1040058 | 1040058 | 2021-02-17 | McLennan | Texas | 48309 | 24268 | 420 |
1036813 | 1036813 | 2021-02-16 | McLennan | Texas | 48309 | 24268 | 419 |
1033568 | 1033568 | 2021-02-15 | McLennan | Texas | 48309 | 24268 | 419 |
1030322 | 1030322 | 2021-02-14 | McLennan | Texas | 48309 | 24245 | 419 |
1027075 | 1027075 | 2021-02-13 | McLennan | Texas | 48309 | 24245 | 419 |
1023830 | 1023830 | 2021-02-12 | McLennan | Texas | 48309 | 24214 | 414 |
1020585 | 1020585 | 2021-02-11 | McLennan | Texas | 48309 | 24168 | 410 |
1017340 | 1017340 | 2021-02-10 | McLennan | Texas | 48309 | 24112 | 406 |
1014095 | 1014095 | 2021-02-09 | McLennan | Texas | 48309 | 23953 | 405 |
1010850 | 1010850 | 2021-02-08 | McLennan | Texas | 48309 | 23826 | 402 |
1007604 | 1007604 | 2021-02-07 | McLennan | Texas | 48309 | 23624 | 402 |
1004358 | 1004358 | 2021-02-06 | McLennan | Texas | 48309 | 23575 | 395 |
1001112 | 1001112 | 2021-02-05 | McLennan | Texas | 48309 | 23575 | 390 |
997866 | 997866 | 2021-02-04 | McLennan | Texas | 48309 | 23499 | 388 |
994620 | 994620 | 2021-02-03 | McLennan | Texas | 48309 | 23444 | 385 |
991374 | 991374 | 2021-02-02 | McLennan | Texas | 48309 | 23333 | 380 |
988128 | 988128 | 2021-02-01 | McLennan | Texas | 48309 | 23284 | 379 |
984881 | 984881 | 2021-01-31 | McLennan | Texas | 48309 | 23200 | 379 |
981634 | 981634 | 2021-01-30 | McLennan | Texas | 48309 | 23200 | 378 |
978388 | 978388 | 2021-01-29 | McLennan | Texas | 48309 | 23140 | 374 |
975143 | 975143 | 2021-01-28 | McLennan | Texas | 48309 | 23074 | 370 |
971898 | 971898 | 2021-01-27 | McLennan | Texas | 48309 | 22994 | 366 |
968653 | 968653 | 2021-01-26 | McLennan | Texas | 48309 | 22846 | 365 |
965409 | 965409 | 2021-01-25 | McLennan | Texas | 48309 | 22801 | 363 |
962164 | 962164 | 2021-01-24 | McLennan | Texas | 48309 | 22657 | 363 |
958919 | 958919 | 2021-01-23 | McLennan | Texas | 48309 | 22657 | 362 |
955673 | 955673 | 2021-01-22 | McLennan | Texas | 48309 | 22587 | 360 |
952428 | 952428 | 2021-01-21 | McLennan | Texas | 48309 | 22506 | 356 |
949183 | 949183 | 2021-01-20 | McLennan | Texas | 48309 | 22373 | 348 |
945937 | 945937 | 2021-01-19 | McLennan | Texas | 48309 | 22292 | 344 |
942690 | 942690 | 2021-01-18 | McLennan | Texas | 48309 | 21894 | 341 |
939445 | 939445 | 2021-01-17 | McLennan | Texas | 48309 | 21894 | 339 |
936200 | 936200 | 2021-01-16 | McLennan | Texas | 48309 | 21894 | 339 |
932955 | 932955 | 2021-01-15 | McLennan | Texas | 48309 | 21809 | 335 |
929710 | 929710 | 2021-01-14 | McLennan | Texas | 48309 | 21598 | 329 |
926465 | 926465 | 2021-01-13 | McLennan | Texas | 48309 | 21407 | 327 |
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 |
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);