ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 48285 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923201 | 923201 | 2021-01-12 | Lavaca | Texas | 48285 | 1794 | 58 |
919956 | 919956 | 2021-01-11 | Lavaca | Texas | 48285 | 1790 | 58 |
916711 | 916711 | 2021-01-10 | Lavaca | Texas | 48285 | 1790 | 57 |
913466 | 913466 | 2021-01-09 | Lavaca | Texas | 48285 | 1790 | 56 |
910221 | 910221 | 2021-01-08 | Lavaca | Texas | 48285 | 1775 | 55 |
906976 | 906976 | 2021-01-07 | Lavaca | Texas | 48285 | 1761 | 55 |
903730 | 903730 | 2021-01-06 | Lavaca | Texas | 48285 | 1727 | 55 |
900485 | 900485 | 2021-01-05 | Lavaca | Texas | 48285 | 1722 | 55 |
897240 | 897240 | 2021-01-04 | Lavaca | Texas | 48285 | 1691 | 53 |
893994 | 893994 | 2021-01-03 | Lavaca | Texas | 48285 | 1691 | 53 |
890748 | 890748 | 2021-01-02 | Lavaca | Texas | 48285 | 1691 | 53 |
887501 | 887501 | 2021-01-01 | Lavaca | Texas | 48285 | 1691 | 53 |
884256 | 884256 | 2020-12-31 | Lavaca | Texas | 48285 | 1690 | 53 |
881011 | 881011 | 2020-12-30 | Lavaca | Texas | 48285 | 1684 | 53 |
877766 | 877766 | 2020-12-29 | Lavaca | Texas | 48285 | 1665 | 53 |
874521 | 874521 | 2020-12-28 | Lavaca | Texas | 48285 | 1660 | 53 |
871276 | 871276 | 2020-12-27 | Lavaca | Texas | 48285 | 1660 | 53 |
868031 | 868031 | 2020-12-26 | Lavaca | Texas | 48285 | 1660 | 53 |
864786 | 864786 | 2020-12-25 | Lavaca | Texas | 48285 | 1660 | 53 |
861541 | 861541 | 2020-12-24 | Lavaca | Texas | 48285 | 1652 | 53 |
858296 | 858296 | 2020-12-23 | Lavaca | Texas | 48285 | 1652 | 51 |
855051 | 855051 | 2020-12-22 | Lavaca | Texas | 48285 | 1631 | 51 |
851806 | 851806 | 2020-12-21 | Lavaca | Texas | 48285 | 1631 | 49 |
848561 | 848561 | 2020-12-20 | Lavaca | Texas | 48285 | 1631 | 49 |
845316 | 845316 | 2020-12-19 | Lavaca | Texas | 48285 | 1631 | 48 |
842070 | 842070 | 2020-12-18 | Lavaca | Texas | 48285 | 1628 | 48 |
838825 | 838825 | 2020-12-17 | Lavaca | Texas | 48285 | 1614 | 47 |
835579 | 835579 | 2020-12-16 | Lavaca | Texas | 48285 | 1610 | 47 |
832333 | 832333 | 2020-12-15 | Lavaca | Texas | 48285 | 1586 | 47 |
829086 | 829086 | 2020-12-14 | Lavaca | Texas | 48285 | 1582 | 47 |
825840 | 825840 | 2020-12-13 | Lavaca | Texas | 48285 | 1582 | 47 |
822593 | 822593 | 2020-12-12 | Lavaca | Texas | 48285 | 1582 | 46 |
819347 | 819347 | 2020-12-11 | Lavaca | Texas | 48285 | 1575 | 46 |
816101 | 816101 | 2020-12-10 | Lavaca | Texas | 48285 | 1450 | 44 |
812855 | 812855 | 2020-12-09 | Lavaca | Texas | 48285 | 1452 | 44 |
809611 | 809611 | 2020-12-08 | Lavaca | Texas | 48285 | 1447 | 44 |
806366 | 806366 | 2020-12-07 | Lavaca | Texas | 48285 | 1443 | 44 |
803121 | 803121 | 2020-12-06 | Lavaca | Texas | 48285 | 1443 | 44 |
799876 | 799876 | 2020-12-05 | Lavaca | Texas | 48285 | 1443 | 44 |
796631 | 796631 | 2020-12-04 | Lavaca | Texas | 48285 | 1439 | 44 |
793386 | 793386 | 2020-12-03 | Lavaca | Texas | 48285 | 1431 | 44 |
790141 | 790141 | 2020-12-02 | Lavaca | Texas | 48285 | 1426 | 43 |
786896 | 786896 | 2020-12-01 | Lavaca | Texas | 48285 | 1391 | 42 |
783652 | 783652 | 2020-11-30 | Lavaca | Texas | 48285 | 1382 | 42 |
780407 | 780407 | 2020-11-29 | Lavaca | Texas | 48285 | 1373 | 42 |
777161 | 777161 | 2020-11-28 | Lavaca | Texas | 48285 | 1373 | 42 |
773916 | 773916 | 2020-11-27 | Lavaca | Texas | 48285 | 1373 | 42 |
770671 | 770671 | 2020-11-26 | Lavaca | Texas | 48285 | 1373 | 42 |
767425 | 767425 | 2020-11-25 | Lavaca | Texas | 48285 | 1372 | 42 |
764180 | 764180 | 2020-11-24 | Lavaca | Texas | 48285 | 1346 | 40 |
760935 | 760935 | 2020-11-23 | Lavaca | Texas | 48285 | 1333 | 40 |
757690 | 757690 | 2020-11-22 | Lavaca | Texas | 48285 | 1333 | 40 |
754443 | 754443 | 2020-11-21 | Lavaca | Texas | 48285 | 1333 | 40 |
751197 | 751197 | 2020-11-20 | Lavaca | Texas | 48285 | 1332 | 39 |
747951 | 747951 | 2020-11-19 | Lavaca | Texas | 48285 | 1325 | 39 |
744705 | 744705 | 2020-11-18 | Lavaca | Texas | 48285 | 1322 | 39 |
741458 | 741458 | 2020-11-17 | Lavaca | Texas | 48285 | 1297 | 39 |
738212 | 738212 | 2020-11-16 | Lavaca | Texas | 48285 | 1282 | 39 |
734968 | 734968 | 2020-11-15 | Lavaca | Texas | 48285 | 1282 | 39 |
731722 | 731722 | 2020-11-14 | Lavaca | Texas | 48285 | 1282 | 39 |
728477 | 728477 | 2020-11-13 | Lavaca | Texas | 48285 | 1259 | 39 |
725234 | 725234 | 2020-11-12 | Lavaca | Texas | 48285 | 1237 | 39 |
721991 | 721991 | 2020-11-11 | Lavaca | Texas | 48285 | 1237 | 39 |
718748 | 718748 | 2020-11-10 | Lavaca | Texas | 48285 | 1236 | 39 |
715505 | 715505 | 2020-11-09 | Lavaca | Texas | 48285 | 1217 | 39 |
712261 | 712261 | 2020-11-08 | Lavaca | Texas | 48285 | 1208 | 39 |
709017 | 709017 | 2020-11-07 | Lavaca | Texas | 48285 | 1208 | 39 |
705773 | 705773 | 2020-11-06 | Lavaca | Texas | 48285 | 1203 | 39 |
702530 | 702530 | 2020-11-05 | Lavaca | Texas | 48285 | 1194 | 39 |
699287 | 699287 | 2020-11-04 | Lavaca | Texas | 48285 | 1190 | 39 |
696043 | 696043 | 2020-11-03 | Lavaca | Texas | 48285 | 1182 | 39 |
692801 | 692801 | 2020-11-02 | Lavaca | Texas | 48285 | 1177 | 39 |
689557 | 689557 | 2020-11-01 | Lavaca | Texas | 48285 | 1177 | 39 |
686312 | 686312 | 2020-10-31 | Lavaca | Texas | 48285 | 1177 | 39 |
683069 | 683069 | 2020-10-30 | Lavaca | Texas | 48285 | 1180 | 39 |
679826 | 679826 | 2020-10-29 | Lavaca | Texas | 48285 | 1164 | 39 |
676583 | 676583 | 2020-10-28 | Lavaca | Texas | 48285 | 1159 | 39 |
673340 | 673340 | 2020-10-27 | Lavaca | Texas | 48285 | 1141 | 39 |
670098 | 670098 | 2020-10-26 | Lavaca | Texas | 48285 | 1131 | 39 |
666855 | 666855 | 2020-10-25 | Lavaca | Texas | 48285 | 1126 | 39 |
663610 | 663610 | 2020-10-24 | Lavaca | Texas | 48285 | 1126 | 39 |
660366 | 660366 | 2020-10-23 | Lavaca | Texas | 48285 | 1117 | 39 |
657122 | 657122 | 2020-10-22 | Lavaca | Texas | 48285 | 1110 | 38 |
653877 | 653877 | 2020-10-21 | Lavaca | Texas | 48285 | 1110 | 38 |
650632 | 650632 | 2020-10-20 | Lavaca | Texas | 48285 | 1103 | 37 |
647388 | 647388 | 2020-10-19 | Lavaca | Texas | 48285 | 1099 | 37 |
644142 | 644142 | 2020-10-18 | Lavaca | Texas | 48285 | 1087 | 37 |
640894 | 640894 | 2020-10-17 | Lavaca | Texas | 48285 | 1087 | 37 |
637647 | 637647 | 2020-10-16 | Lavaca | Texas | 48285 | 1084 | 37 |
634402 | 634402 | 2020-10-15 | Lavaca | Texas | 48285 | 1081 | 36 |
631157 | 631157 | 2020-10-14 | Lavaca | Texas | 48285 | 1077 | 36 |
627913 | 627913 | 2020-10-13 | Lavaca | Texas | 48285 | 1084 | 36 |
624670 | 624670 | 2020-10-12 | Lavaca | Texas | 48285 | 1077 | 36 |
621427 | 621427 | 2020-10-11 | Lavaca | Texas | 48285 | 1041 | 36 |
618184 | 618184 | 2020-10-10 | Lavaca | Texas | 48285 | 1041 | 36 |
614942 | 614942 | 2020-10-09 | Lavaca | Texas | 48285 | 1037 | 36 |
611701 | 611701 | 2020-10-08 | Lavaca | Texas | 48285 | 1035 | 36 |
608459 | 608459 | 2020-10-07 | Lavaca | Texas | 48285 | 1033 | 35 |
605216 | 605216 | 2020-10-06 | Lavaca | Texas | 48285 | 1042 | 35 |
601974 | 601974 | 2020-10-05 | Lavaca | Texas | 48285 | 1040 | 35 |
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);