ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where fips = 48343 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
936211 | 936211 | 2021-01-16 | Morris | Texas | 48343 | 644 | 14 |
932966 | 932966 | 2021-01-15 | Morris | Texas | 48343 | 639 | 13 |
929721 | 929721 | 2021-01-14 | Morris | Texas | 48343 | 632 | 12 |
926476 | 926476 | 2021-01-13 | Morris | Texas | 48343 | 627 | 11 |
923230 | 923230 | 2021-01-12 | Morris | Texas | 48343 | 623 | 11 |
919985 | 919985 | 2021-01-11 | Morris | Texas | 48343 | 601 | 11 |
916740 | 916740 | 2021-01-10 | Morris | Texas | 48343 | 582 | 11 |
913495 | 913495 | 2021-01-09 | Morris | Texas | 48343 | 579 | 11 |
910250 | 910250 | 2021-01-08 | Morris | Texas | 48343 | 569 | 11 |
907005 | 907005 | 2021-01-07 | Morris | Texas | 48343 | 551 | 11 |
903759 | 903759 | 2021-01-06 | Morris | Texas | 48343 | 545 | 11 |
900514 | 900514 | 2021-01-05 | Morris | Texas | 48343 | 535 | 11 |
897269 | 897269 | 2021-01-04 | Morris | Texas | 48343 | 529 | 11 |
894023 | 894023 | 2021-01-03 | Morris | Texas | 48343 | 527 | 11 |
890777 | 890777 | 2021-01-02 | Morris | Texas | 48343 | 510 | 11 |
887530 | 887530 | 2021-01-01 | Morris | Texas | 48343 | 498 | 11 |
884285 | 884285 | 2020-12-31 | Morris | Texas | 48343 | 493 | 10 |
881040 | 881040 | 2020-12-30 | Morris | Texas | 48343 | 485 | 10 |
877795 | 877795 | 2020-12-29 | Morris | Texas | 48343 | 481 | 8 |
874550 | 874550 | 2020-12-28 | Morris | Texas | 48343 | 475 | 8 |
871305 | 871305 | 2020-12-27 | Morris | Texas | 48343 | 475 | 8 |
868060 | 868060 | 2020-12-26 | Morris | Texas | 48343 | 459 | 8 |
864815 | 864815 | 2020-12-25 | Morris | Texas | 48343 | 455 | 8 |
861570 | 861570 | 2020-12-24 | Morris | Texas | 48343 | 455 | 8 |
858325 | 858325 | 2020-12-23 | Morris | Texas | 48343 | 448 | 8 |
855080 | 855080 | 2020-12-22 | Morris | Texas | 48343 | 444 | 8 |
851835 | 851835 | 2020-12-21 | Morris | Texas | 48343 | 442 | 8 |
848590 | 848590 | 2020-12-20 | Morris | Texas | 48343 | 442 | 8 |
845345 | 845345 | 2020-12-19 | Morris | Texas | 48343 | 438 | 8 |
842099 | 842099 | 2020-12-18 | Morris | Texas | 48343 | 433 | 8 |
838854 | 838854 | 2020-12-17 | Morris | Texas | 48343 | 431 | 8 |
835608 | 835608 | 2020-12-16 | Morris | Texas | 48343 | 427 | 8 |
832362 | 832362 | 2020-12-15 | Morris | Texas | 48343 | 422 | 8 |
829115 | 829115 | 2020-12-14 | Morris | Texas | 48343 | 420 | 8 |
825869 | 825869 | 2020-12-13 | Morris | Texas | 48343 | 420 | 8 |
822622 | 822622 | 2020-12-12 | Morris | Texas | 48343 | 419 | 8 |
819376 | 819376 | 2020-12-11 | Morris | Texas | 48343 | 416 | 8 |
816130 | 816130 | 2020-12-10 | Morris | Texas | 48343 | 299 | 8 |
812884 | 812884 | 2020-12-09 | Morris | Texas | 48343 | 298 | 8 |
809640 | 809640 | 2020-12-08 | Morris | Texas | 48343 | 295 | 8 |
806395 | 806395 | 2020-12-07 | Morris | Texas | 48343 | 291 | 8 |
803150 | 803150 | 2020-12-06 | Morris | Texas | 48343 | 291 | 8 |
799905 | 799905 | 2020-12-05 | Morris | Texas | 48343 | 291 | 8 |
796660 | 796660 | 2020-12-04 | Morris | Texas | 48343 | 290 | 8 |
793415 | 793415 | 2020-12-03 | Morris | Texas | 48343 | 290 | 8 |
790170 | 790170 | 2020-12-02 | Morris | Texas | 48343 | 286 | 8 |
786925 | 786925 | 2020-12-01 | Morris | Texas | 48343 | 278 | 8 |
783681 | 783681 | 2020-11-30 | Morris | Texas | 48343 | 277 | 8 |
780436 | 780436 | 2020-11-29 | Morris | Texas | 48343 | 276 | 8 |
777190 | 777190 | 2020-11-28 | Morris | Texas | 48343 | 276 | 8 |
773945 | 773945 | 2020-11-27 | Morris | Texas | 48343 | 275 | 8 |
770700 | 770700 | 2020-11-26 | Morris | Texas | 48343 | 272 | 8 |
767454 | 767454 | 2020-11-25 | Morris | Texas | 48343 | 271 | 8 |
764209 | 764209 | 2020-11-24 | Morris | Texas | 48343 | 270 | 8 |
760964 | 760964 | 2020-11-23 | Morris | Texas | 48343 | 265 | 8 |
757719 | 757719 | 2020-11-22 | Morris | Texas | 48343 | 265 | 8 |
754472 | 754472 | 2020-11-21 | Morris | Texas | 48343 | 265 | 8 |
751226 | 751226 | 2020-11-20 | Morris | Texas | 48343 | 261 | 8 |
747980 | 747980 | 2020-11-19 | Morris | Texas | 48343 | 260 | 8 |
744734 | 744734 | 2020-11-18 | Morris | Texas | 48343 | 257 | 8 |
741487 | 741487 | 2020-11-17 | Morris | Texas | 48343 | 253 | 6 |
738240 | 738240 | 2020-11-16 | Morris | Texas | 48343 | 252 | 6 |
734996 | 734996 | 2020-11-15 | Morris | Texas | 48343 | 251 | 6 |
731750 | 731750 | 2020-11-14 | Morris | Texas | 48343 | 251 | 6 |
728505 | 728505 | 2020-11-13 | Morris | Texas | 48343 | 251 | 6 |
725262 | 725262 | 2020-11-12 | Morris | Texas | 48343 | 248 | 5 |
722019 | 722019 | 2020-11-11 | Morris | Texas | 48343 | 248 | 5 |
718776 | 718776 | 2020-11-10 | Morris | Texas | 48343 | 247 | 5 |
715533 | 715533 | 2020-11-09 | Morris | Texas | 48343 | 246 | 5 |
712289 | 712289 | 2020-11-08 | Morris | Texas | 48343 | 246 | 5 |
709045 | 709045 | 2020-11-07 | Morris | Texas | 48343 | 244 | 5 |
705801 | 705801 | 2020-11-06 | Morris | Texas | 48343 | 244 | 5 |
702558 | 702558 | 2020-11-05 | Morris | Texas | 48343 | 240 | 5 |
699315 | 699315 | 2020-11-04 | Morris | Texas | 48343 | 240 | 5 |
696071 | 696071 | 2020-11-03 | Morris | Texas | 48343 | 240 | 5 |
692829 | 692829 | 2020-11-02 | Morris | Texas | 48343 | 237 | 5 |
689585 | 689585 | 2020-11-01 | Morris | Texas | 48343 | 236 | 5 |
686340 | 686340 | 2020-10-31 | Morris | Texas | 48343 | 234 | 5 |
683097 | 683097 | 2020-10-30 | Morris | Texas | 48343 | 232 | 5 |
679854 | 679854 | 2020-10-29 | Morris | Texas | 48343 | 229 | 5 |
676611 | 676611 | 2020-10-28 | Morris | Texas | 48343 | 228 | 5 |
673368 | 673368 | 2020-10-27 | Morris | Texas | 48343 | 224 | 5 |
670126 | 670126 | 2020-10-26 | Morris | Texas | 48343 | 217 | 5 |
666883 | 666883 | 2020-10-25 | Morris | Texas | 48343 | 217 | 5 |
663638 | 663638 | 2020-10-24 | Morris | Texas | 48343 | 217 | 5 |
660394 | 660394 | 2020-10-23 | Morris | Texas | 48343 | 213 | 5 |
657150 | 657150 | 2020-10-22 | Morris | Texas | 48343 | 209 | 5 |
653905 | 653905 | 2020-10-21 | Morris | Texas | 48343 | 209 | 5 |
650660 | 650660 | 2020-10-20 | Morris | Texas | 48343 | 208 | 5 |
647416 | 647416 | 2020-10-19 | Morris | Texas | 48343 | 201 | 5 |
644170 | 644170 | 2020-10-18 | Morris | Texas | 48343 | 201 | 5 |
640922 | 640922 | 2020-10-17 | Morris | Texas | 48343 | 201 | 5 |
637675 | 637675 | 2020-10-16 | Morris | Texas | 48343 | 200 | 5 |
634430 | 634430 | 2020-10-15 | Morris | Texas | 48343 | 199 | 4 |
631185 | 631185 | 2020-10-14 | Morris | Texas | 48343 | 198 | 4 |
627941 | 627941 | 2020-10-13 | Morris | Texas | 48343 | 198 | 4 |
624698 | 624698 | 2020-10-12 | Morris | Texas | 48343 | 196 | 4 |
621455 | 621455 | 2020-10-11 | Morris | Texas | 48343 | 194 | 4 |
618212 | 618212 | 2020-10-10 | Morris | Texas | 48343 | 194 | 4 |
614970 | 614970 | 2020-10-09 | Morris | Texas | 48343 | 194 | 4 |
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);