ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
254 rows where "date" is on date 2021-02-08 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1010690 | 1010690 | 2021-02-08 | Anderson | Texas | 48001 | 5988 | 93 |
1010691 | 1010691 | 2021-02-08 | Andrews | Texas | 48003 | 1672 | 44 |
1010692 | 1010692 | 2021-02-08 | Angelina | Texas | 48005 | 7526 | 232 |
1010693 | 1010693 | 2021-02-08 | Aransas | Texas | 48007 | 1081 | 31 |
1010694 | 1010694 | 2021-02-08 | Archer | Texas | 48009 | 753 | 11 |
1010695 | 1010695 | 2021-02-08 | Armstrong | Texas | 48011 | 142 | 6 |
1010696 | 1010696 | 2021-02-08 | Atascosa | Texas | 48013 | 4866 | 118 |
1010697 | 1010697 | 2021-02-08 | Austin | Texas | 48015 | 1677 | 26 |
1010698 | 1010698 | 2021-02-08 | Bailey | Texas | 48017 | 767 | 16 |
1010699 | 1010699 | 2021-02-08 | Bandera | Texas | 48019 | 1125 | 22 |
1010700 | 1010700 | 2021-02-08 | Bastrop | Texas | 48021 | 8066 | 67 |
1010701 | 1010701 | 2021-02-08 | Baylor | Texas | 48023 | 291 | 11 |
1010702 | 1010702 | 2021-02-08 | Bee | Texas | 48025 | 3352 | 59 |
1010703 | 1010703 | 2021-02-08 | Bell | Texas | 48027 | 19669 | 297 |
1010704 | 1010704 | 2021-02-08 | Bexar | Texas | 48029 | 183448 | 2534 |
1010705 | 1010705 | 2021-02-08 | Blanco | Texas | 48031 | 649 | 15 |
1010706 | 1010706 | 2021-02-08 | Borden | Texas | 48033 | 17 | 2 |
1010707 | 1010707 | 2021-02-08 | Bosque | Texas | 48035 | 1523 | 27 |
1010708 | 1010708 | 2021-02-08 | Bowie | Texas | 48037 | 6156 | 162 |
1010709 | 1010709 | 2021-02-08 | Brazoria | Texas | 48039 | 30155 | 333 |
1010710 | 1010710 | 2021-02-08 | Brazos | Texas | 48041 | 19741 | 197 |
1010711 | 1010711 | 2021-02-08 | Brewster | Texas | 48043 | 857 | 10 |
1010712 | 1010712 | 2021-02-08 | Briscoe | Texas | 48045 | 125 | 4 |
1010713 | 1010713 | 2021-02-08 | Brooks | Texas | 48047 | 737 | 31 |
1010714 | 1010714 | 2021-02-08 | Brown | Texas | 48049 | 3862 | 117 |
1010715 | 1010715 | 2021-02-08 | Burleson | Texas | 48051 | 2115 | 28 |
1010716 | 1010716 | 2021-02-08 | Burnet | Texas | 48053 | 3905 | 49 |
1010717 | 1010717 | 2021-02-08 | Caldwell | Texas | 48055 | 4964 | 68 |
1010718 | 1010718 | 2021-02-08 | Calhoun | Texas | 48057 | 1658 | 13 |
1010719 | 1010719 | 2021-02-08 | Callahan | Texas | 48059 | 1093 | 36 |
1010720 | 1010720 | 2021-02-08 | Cameron | Texas | 48061 | 36076 | 1379 |
1010721 | 1010721 | 2021-02-08 | Camp | Texas | 48063 | 1126 | 36 |
1010722 | 1010722 | 2021-02-08 | Carson | Texas | 48065 | 351 | 12 |
1010723 | 1010723 | 2021-02-08 | Cass | Texas | 48067 | 1699 | 71 |
1010724 | 1010724 | 2021-02-08 | Castro | Texas | 48069 | 857 | 26 |
1010725 | 1010725 | 2021-02-08 | Chambers | Texas | 48071 | 3884 | 34 |
1010726 | 1010726 | 2021-02-08 | Cherokee | Texas | 48073 | 3890 | 111 |
1010727 | 1010727 | 2021-02-08 | Childress | Texas | 48075 | 1314 | 15 |
1010728 | 1010728 | 2021-02-08 | Clay | Texas | 48077 | 969 | 16 |
1010729 | 1010729 | 2021-02-08 | Cochran | Texas | 48079 | 234 | 13 |
1010730 | 1010730 | 2021-02-08 | Coke | Texas | 48081 | 437 | 11 |
1010731 | 1010731 | 2021-02-08 | Coleman | Texas | 48083 | 691 | 27 |
1010732 | 1010732 | 2021-02-08 | Collin | Texas | 48085 | 77073 | 629 |
1010733 | 1010733 | 2021-02-08 | Collingsworth | Texas | 48087 | 250 | 8 |
1010734 | 1010734 | 2021-02-08 | Colorado | Texas | 48089 | 1459 | 23 |
1010735 | 1010735 | 2021-02-08 | Comal | Texas | 48091 | 8463 | 269 |
1010736 | 1010736 | 2021-02-08 | Comanche | Texas | 48093 | 1208 | 44 |
1010737 | 1010737 | 2021-02-08 | Concho | Texas | 48095 | 283 | 6 |
1010738 | 1010738 | 2021-02-08 | Cooke | Texas | 48097 | 3301 | 57 |
1010739 | 1010739 | 2021-02-08 | Coryell | Texas | 48099 | 7022 | 64 |
1010740 | 1010740 | 2021-02-08 | Cottle | Texas | 48101 | 181 | 7 |
1010741 | 1010741 | 2021-02-08 | Crane | Texas | 48103 | 500 | 11 |
1010742 | 1010742 | 2021-02-08 | Crockett | Texas | 48105 | 542 | 15 |
1010743 | 1010743 | 2021-02-08 | Crosby | Texas | 48107 | 442 | 25 |
1010744 | 1010744 | 2021-02-08 | Culberson | Texas | 48109 | 335 | 7 |
1010745 | 1010745 | 2021-02-08 | Dallam | Texas | 48111 | 555 | 22 |
1010746 | 1010746 | 2021-02-08 | Dallas | Texas | 48113 | 268262 | 3019 |
1010747 | 1010747 | 2021-02-08 | Dawson | Texas | 48115 | 1686 | 66 |
1010748 | 1010748 | 2021-02-08 | DeWitt | Texas | 48123 | 1774 | 55 |
1010749 | 1010749 | 2021-02-08 | Deaf Smith | Texas | 48117 | 2604 | 62 |
1010750 | 1010750 | 2021-02-08 | Delta | Texas | 48119 | 277 | 7 |
1010751 | 1010751 | 2021-02-08 | Denton | Texas | 48121 | 57239 | 555 |
1010752 | 1010752 | 2021-02-08 | Dickens | Texas | 48125 | 142 | 8 |
1010753 | 1010753 | 2021-02-08 | Dimmit | Texas | 48127 | 1339 | 19 |
1010754 | 1010754 | 2021-02-08 | Donley | Texas | 48129 | 333 | 12 |
1010755 | 1010755 | 2021-02-08 | Duval | Texas | 48131 | 1131 | 35 |
1010756 | 1010756 | 2021-02-08 | Eastland | Texas | 48133 | 1148 | 36 |
1010757 | 1010757 | 2021-02-08 | Ector | Texas | 48135 | 14488 | 302 |
1010758 | 1010758 | 2021-02-08 | Edwards | Texas | 48137 | 234 | 4 |
1010759 | 1010759 | 2021-02-08 | El Paso | Texas | 48141 | 117039 | 2182 |
1010760 | 1010760 | 2021-02-08 | Ellis | Texas | 48139 | 19505 | 251 |
1010761 | 1010761 | 2021-02-08 | Erath | Texas | 48143 | 3824 | 60 |
1010762 | 1010762 | 2021-02-08 | Falls | Texas | 48145 | 1965 | 26 |
1010763 | 1010763 | 2021-02-08 | Fannin | Texas | 48147 | 3015 | 88 |
1010764 | 1010764 | 2021-02-08 | Fayette | Texas | 48149 | 2153 | 50 |
1010765 | 1010765 | 2021-02-08 | Fisher | Texas | 48151 | 290 | 13 |
1010766 | 1010766 | 2021-02-08 | Floyd | Texas | 48153 | 711 | 29 |
1010767 | 1010767 | 2021-02-08 | Foard | Texas | 48155 | 112 | 7 |
1010768 | 1010768 | 2021-02-08 | Fort Bend | Texas | 48157 | 53153 | 507 |
1010769 | 1010769 | 2021-02-08 | Franklin | Texas | 48159 | 652 | 21 |
1010770 | 1010770 | 2021-02-08 | Freestone | Texas | 48161 | 1824 | 33 |
1010771 | 1010771 | 2021-02-08 | Frio | Texas | 48163 | 2508 | 36 |
1010772 | 1010772 | 2021-02-08 | Gaines | Texas | 48165 | 1394 | 38 |
1010773 | 1010773 | 2021-02-08 | Galveston | Texas | 48167 | 32106 | 301 |
1010774 | 1010774 | 2021-02-08 | Garza | Texas | 48169 | 320 | 18 |
1010775 | 1010775 | 2021-02-08 | Gillespie | Texas | 48171 | 2244 | 43 |
1010776 | 1010776 | 2021-02-08 | Glasscock | Texas | 48173 | 100 | 2 |
1010777 | 1010777 | 2021-02-08 | Goliad | Texas | 48175 | 387 | 12 |
1010778 | 1010778 | 2021-02-08 | Gonzales | Texas | 48177 | 2421 | 43 |
1010779 | 1010779 | 2021-02-08 | Gray | Texas | 48179 | 1880 | 48 |
1010780 | 1010780 | 2021-02-08 | Grayson | Texas | 48181 | 10112 | 275 |
1010781 | 1010781 | 2021-02-08 | Gregg | Texas | 48183 | 10248 | 275 |
1010782 | 1010782 | 2021-02-08 | Grimes | Texas | 48185 | 3257 | 58 |
1010783 | 1010783 | 2021-02-08 | Guadalupe | Texas | 48187 | 12116 | 163 |
1010784 | 1010784 | 2021-02-08 | Hale | Texas | 48189 | 5942 | 150 |
1010785 | 1010785 | 2021-02-08 | Hall | Texas | 48191 | 390 | 14 |
1010786 | 1010786 | 2021-02-08 | Hamilton | Texas | 48193 | 720 | 23 |
1010787 | 1010787 | 2021-02-08 | Hansford | Texas | 48195 | 746 | 18 |
1010788 | 1010788 | 2021-02-08 | Hardeman | Texas | 48197 | 347 | 12 |
1010789 | 1010789 | 2021-02-08 | Hardin | Texas | 48199 | 4449 | 83 |
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);