ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
822 rows where fips = 48029 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1056142 | 1056142 | 2021-02-22 | Bexar | Texas | 48029 | 193703 | 2763 |
1052896 | 1052896 | 2021-02-21 | Bexar | Texas | 48029 | 193473 | 2752 |
1049649 | 1049649 | 2021-02-20 | Bexar | Texas | 48029 | 189975 | 2731 |
1046402 | 1046402 | 2021-02-19 | Bexar | Texas | 48029 | 187758 | 2713 |
1043157 | 1043157 | 2021-02-18 | Bexar | Texas | 48029 | 187758 | 2707 |
1039912 | 1039912 | 2021-02-17 | Bexar | Texas | 48029 | 187758 | 2695 |
1036667 | 1036667 | 2021-02-16 | Bexar | Texas | 48029 | 187758 | 2690 |
1033422 | 1033422 | 2021-02-15 | Bexar | Texas | 48029 | 187758 | 2687 |
1030176 | 1030176 | 2021-02-14 | Bexar | Texas | 48029 | 187758 | 2681 |
1026929 | 1026929 | 2021-02-13 | Bexar | Texas | 48029 | 187758 | 2670 |
1023684 | 1023684 | 2021-02-12 | Bexar | Texas | 48029 | 187074 | 2646 |
1020439 | 1020439 | 2021-02-11 | Bexar | Texas | 48029 | 186358 | 2611 |
1017194 | 1017194 | 2021-02-10 | Bexar | Texas | 48029 | 185456 | 2591 |
1013949 | 1013949 | 2021-02-09 | Bexar | Texas | 48029 | 184796 | 2557 |
1010704 | 1010704 | 2021-02-08 | Bexar | Texas | 48029 | 183448 | 2534 |
1007458 | 1007458 | 2021-02-07 | Bexar | Texas | 48029 | 183213 | 2527 |
1004212 | 1004212 | 2021-02-06 | Bexar | Texas | 48029 | 181023 | 2509 |
1000966 | 1000966 | 2021-02-05 | Bexar | Texas | 48029 | 180398 | 2474 |
997720 | 997720 | 2021-02-04 | Bexar | Texas | 48029 | 178674 | 2441 |
994474 | 994474 | 2021-02-03 | Bexar | Texas | 48029 | 177814 | 2416 |
991228 | 991228 | 2021-02-02 | Bexar | Texas | 48029 | 176802 | 2380 |
987982 | 987982 | 2021-02-01 | Bexar | Texas | 48029 | 175542 | 2349 |
984735 | 984735 | 2021-01-31 | Bexar | Texas | 48029 | 173166 | 2348 |
981488 | 981488 | 2021-01-30 | Bexar | Texas | 48029 | 169700 | 2329 |
978242 | 978242 | 2021-01-29 | Bexar | Texas | 48029 | 167579 | 2303 |
974997 | 974997 | 2021-01-28 | Bexar | Texas | 48029 | 166034 | 2262 |
971752 | 971752 | 2021-01-27 | Bexar | Texas | 48029 | 164282 | 2216 |
968507 | 968507 | 2021-01-26 | Bexar | Texas | 48029 | 162941 | 2181 |
965263 | 965263 | 2021-01-25 | Bexar | Texas | 48029 | 162120 | 2161 |
962018 | 962018 | 2021-01-24 | Bexar | Texas | 48029 | 160038 | 2153 |
958773 | 958773 | 2021-01-23 | Bexar | Texas | 48029 | 159531 | 2144 |
955527 | 955527 | 2021-01-22 | Bexar | Texas | 48029 | 157847 | 2123 |
952282 | 952282 | 2021-01-21 | Bexar | Texas | 48029 | 155600 | 2090 |
949037 | 949037 | 2021-01-20 | Bexar | Texas | 48029 | 153093 | 2067 |
945791 | 945791 | 2021-01-19 | Bexar | Texas | 48029 | 152243 | 2040 |
942544 | 942544 | 2021-01-18 | Bexar | Texas | 48029 | 149848 | 2020 |
939299 | 939299 | 2021-01-17 | Bexar | Texas | 48029 | 148567 | 2019 |
936054 | 936054 | 2021-01-16 | Bexar | Texas | 48029 | 146355 | 2008 |
932809 | 932809 | 2021-01-15 | Bexar | Texas | 48029 | 143515 | 1970 |
929564 | 929564 | 2021-01-14 | Bexar | Texas | 48029 | 140626 | 1942 |
926319 | 926319 | 2021-01-13 | Bexar | Texas | 48029 | 138797 | 1912 |
923073 | 923073 | 2021-01-12 | Bexar | Texas | 48029 | 137419 | 1884 |
919828 | 919828 | 2021-01-11 | Bexar | Texas | 48029 | 135116 | 1862 |
916583 | 916583 | 2021-01-10 | Bexar | Texas | 48029 | 133531 | 1859 |
913338 | 913338 | 2021-01-09 | Bexar | Texas | 48029 | 130459 | 1844 |
910093 | 910093 | 2021-01-08 | Bexar | Texas | 48029 | 129158 | 1827 |
906848 | 906848 | 2021-01-07 | Bexar | Texas | 48029 | 128079 | 1799 |
903602 | 903602 | 2021-01-06 | Bexar | Texas | 48029 | 126909 | 1778 |
900357 | 900357 | 2021-01-05 | Bexar | Texas | 48029 | 124812 | 1758 |
897112 | 897112 | 2021-01-04 | Bexar | Texas | 48029 | 122660 | 1747 |
893866 | 893866 | 2021-01-03 | Bexar | Texas | 48029 | 121603 | 1745 |
890620 | 890620 | 2021-01-02 | Bexar | Texas | 48029 | 119367 | 1743 |
887373 | 887373 | 2021-01-01 | Bexar | Texas | 48029 | 115697 | 1739 |
884128 | 884128 | 2020-12-31 | Bexar | Texas | 48029 | 115697 | 1726 |
880883 | 880883 | 2020-12-30 | Bexar | Texas | 48029 | 115697 | 1709 |
877638 | 877638 | 2020-12-29 | Bexar | Texas | 48029 | 114374 | 1699 |
874393 | 874393 | 2020-12-28 | Bexar | Texas | 48029 | 112273 | 1689 |
871148 | 871148 | 2020-12-27 | Bexar | Texas | 48029 | 112230 | 1689 |
867903 | 867903 | 2020-12-26 | Bexar | Texas | 48029 | 106805 | 1685 |
864658 | 864658 | 2020-12-25 | Bexar | Texas | 48029 | 106805 | 1684 |
861413 | 861413 | 2020-12-24 | Bexar | Texas | 48029 | 106805 | 1666 |
858168 | 858168 | 2020-12-23 | Bexar | Texas | 48029 | 106805 | 1652 |
854923 | 854923 | 2020-12-22 | Bexar | Texas | 48029 | 105176 | 1642 |
851678 | 851678 | 2020-12-21 | Bexar | Texas | 48029 | 103459 | 1631 |
848433 | 848433 | 2020-12-20 | Bexar | Texas | 48029 | 102176 | 1630 |
845188 | 845188 | 2020-12-19 | Bexar | Texas | 48029 | 100834 | 1629 |
841942 | 841942 | 2020-12-18 | Bexar | Texas | 48029 | 100090 | 1609 |
838697 | 838697 | 2020-12-17 | Bexar | Texas | 48029 | 99154 | 1600 |
835451 | 835451 | 2020-12-16 | Bexar | Texas | 48029 | 97548 | 1591 |
832205 | 832205 | 2020-12-15 | Bexar | Texas | 48029 | 96152 | 1582 |
828958 | 828958 | 2020-12-14 | Bexar | Texas | 48029 | 94793 | 1577 |
825712 | 825712 | 2020-12-13 | Bexar | Texas | 48029 | 94194 | 1577 |
822465 | 822465 | 2020-12-12 | Bexar | Texas | 48029 | 93488 | 1574 |
819219 | 819219 | 2020-12-11 | Bexar | Texas | 48029 | 92496 | 1568 |
815973 | 815973 | 2020-12-10 | Bexar | Texas | 48029 | 91406 | 1561 |
812727 | 812727 | 2020-12-09 | Bexar | Texas | 48029 | 90232 | 1552 |
809483 | 809483 | 2020-12-08 | Bexar | Texas | 48029 | 89502 | 1544 |
806238 | 806238 | 2020-12-07 | Bexar | Texas | 48029 | 88208 | 1538 |
802993 | 802993 | 2020-12-06 | Bexar | Texas | 48029 | 86998 | 1537 |
799748 | 799748 | 2020-12-05 | Bexar | Texas | 48029 | 85907 | 1536 |
796503 | 796503 | 2020-12-04 | Bexar | Texas | 48029 | 85213 | 1525 |
793258 | 793258 | 2020-12-03 | Bexar | Texas | 48029 | 83897 | 1516 |
790013 | 790013 | 2020-12-02 | Bexar | Texas | 48029 | 83137 | 1512 |
786768 | 786768 | 2020-12-01 | Bexar | Texas | 48029 | 81638 | 1502 |
783524 | 783524 | 2020-11-30 | Bexar | Texas | 48029 | 81186 | 1498 |
780279 | 780279 | 2020-11-29 | Bexar | Texas | 48029 | 80069 | 1496 |
777033 | 777033 | 2020-11-28 | Bexar | Texas | 48029 | 78423 | 1494 |
773788 | 773788 | 2020-11-27 | Bexar | Texas | 48029 | 76762 | 1492 |
770543 | 770543 | 2020-11-26 | Bexar | Texas | 48029 | 76762 | 1489 |
767297 | 767297 | 2020-11-25 | Bexar | Texas | 48029 | 76762 | 1486 |
764052 | 764052 | 2020-11-24 | Bexar | Texas | 48029 | 75730 | 1480 |
760807 | 760807 | 2020-11-23 | Bexar | Texas | 48029 | 74603 | 1476 |
757562 | 757562 | 2020-11-22 | Bexar | Texas | 48029 | 73894 | 1476 |
754315 | 754315 | 2020-11-21 | Bexar | Texas | 48029 | 72817 | 1473 |
751069 | 751069 | 2020-11-20 | Bexar | Texas | 48029 | 72325 | 1468 |
747823 | 747823 | 2020-11-19 | Bexar | Texas | 48029 | 71389 | 1465 |
744577 | 744577 | 2020-11-18 | Bexar | Texas | 48029 | 70906 | 1458 |
741330 | 741330 | 2020-11-17 | Bexar | Texas | 48029 | 70540 | 1453 |
738084 | 738084 | 2020-11-16 | Bexar | Texas | 48029 | 70248 | 1451 |
734840 | 734840 | 2020-11-15 | Bexar | Texas | 48029 | 70054 | 1451 |
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);