ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
237 rows where "date" is on date 2020-06-15 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
242646 | 242646 | 2020-06-15 | Anderson | Texas | 48001 | 102 | 0 |
242647 | 242647 | 2020-06-15 | Andrews | Texas | 48003 | 28 | 0 |
242648 | 242648 | 2020-06-15 | Angelina | Texas | 48005 | 309 | 5 |
242649 | 242649 | 2020-06-15 | Aransas | Texas | 48007 | 6 | 0 |
242650 | 242650 | 2020-06-15 | Archer | Texas | 48009 | 3 | 0 |
242651 | 242651 | 2020-06-15 | Armstrong | Texas | 48011 | 2 | 0 |
242652 | 242652 | 2020-06-15 | Atascosa | Texas | 48013 | 42 | 2 |
242653 | 242653 | 2020-06-15 | Austin | Texas | 48015 | 34 | 0 |
242654 | 242654 | 2020-06-15 | Bailey | Texas | 48017 | 34 | 0 |
242655 | 242655 | 2020-06-15 | Bandera | Texas | 48019 | 7 | 0 |
242656 | 242656 | 2020-06-15 | Bastrop | Texas | 48021 | 295 | 4 |
242657 | 242657 | 2020-06-15 | Baylor | Texas | 48023 | 1 | 0 |
242658 | 242658 | 2020-06-15 | Bee | Texas | 48025 | 31 | 0 |
242659 | 242659 | 2020-06-15 | Bell | Texas | 48027 | 629 | 7 |
242660 | 242660 | 2020-06-15 | Bexar | Texas | 48029 | 4449 | 89 |
242661 | 242661 | 2020-06-15 | Blanco | Texas | 48031 | 11 | 1 |
242662 | 242662 | 2020-06-15 | Bosque | Texas | 48035 | 7 | 0 |
242663 | 242663 | 2020-06-15 | Bowie | Texas | 48037 | 372 | 13 |
242664 | 242664 | 2020-06-15 | Brazoria | Texas | 48039 | 1184 | 18 |
242665 | 242665 | 2020-06-15 | Brazos | Texas | 48041 | 821 | 25 |
242666 | 242666 | 2020-06-15 | Brewster | Texas | 48043 | 11 | 0 |
242667 | 242667 | 2020-06-15 | Briscoe | Texas | 48045 | 1 | 0 |
242668 | 242668 | 2020-06-15 | Brooks | Texas | 48047 | 2 | 0 |
242669 | 242669 | 2020-06-15 | Brown | Texas | 48049 | 60 | 10 |
242670 | 242670 | 2020-06-15 | Burleson | Texas | 48051 | 41 | 0 |
242671 | 242671 | 2020-06-15 | Burnet | Texas | 48053 | 62 | 1 |
242672 | 242672 | 2020-06-15 | Caldwell | Texas | 48055 | 147 | 0 |
242673 | 242673 | 2020-06-15 | Calhoun | Texas | 48057 | 46 | 3 |
242674 | 242674 | 2020-06-15 | Callahan | Texas | 48059 | 13 | 2 |
242675 | 242675 | 2020-06-15 | Cameron | Texas | 48061 | 1138 | 44 |
242676 | 242676 | 2020-06-15 | Camp | Texas | 48063 | 108 | 1 |
242677 | 242677 | 2020-06-15 | Carson | Texas | 48065 | 6 | 0 |
242678 | 242678 | 2020-06-15 | Cass | Texas | 48067 | 34 | 2 |
242679 | 242679 | 2020-06-15 | Castro | Texas | 48069 | 42 | 1 |
242680 | 242680 | 2020-06-15 | Chambers | Texas | 48071 | 117 | 0 |
242681 | 242681 | 2020-06-15 | Cherokee | Texas | 48073 | 54 | 2 |
242682 | 242682 | 2020-06-15 | Childress | Texas | 48075 | 6 | 0 |
242683 | 242683 | 2020-06-15 | Clay | Texas | 48077 | 5 | 0 |
242684 | 242684 | 2020-06-15 | Cochran | Texas | 48079 | 1 | 0 |
242685 | 242685 | 2020-06-15 | Coke | Texas | 48081 | 4 | 0 |
242686 | 242686 | 2020-06-15 | Coleman | Texas | 48083 | 3 | 0 |
242687 | 242687 | 2020-06-15 | Collin | Texas | 48085 | 1787 | 38 |
242688 | 242688 | 2020-06-15 | Collingsworth | Texas | 48087 | 5 | 0 |
242689 | 242689 | 2020-06-15 | Colorado | Texas | 48089 | 34 | 0 |
242690 | 242690 | 2020-06-15 | Comal | Texas | 48091 | 191 | 7 |
242691 | 242691 | 2020-06-15 | Comanche | Texas | 48093 | 12 | 1 |
242692 | 242692 | 2020-06-15 | Concho | Texas | 48095 | 1 | 0 |
242693 | 242693 | 2020-06-15 | Cooke | Texas | 48097 | 23 | 0 |
242694 | 242694 | 2020-06-15 | Coryell | Texas | 48099 | 300 | 2 |
242695 | 242695 | 2020-06-15 | Cottle | Texas | 48101 | 4 | 1 |
242696 | 242696 | 2020-06-15 | Crane | Texas | 48103 | 32 | 5 |
242697 | 242697 | 2020-06-15 | Crockett | Texas | 48105 | 5 | 0 |
242698 | 242698 | 2020-06-15 | Crosby | Texas | 48107 | 4 | 1 |
242699 | 242699 | 2020-06-15 | Dallam | Texas | 48111 | 35 | 0 |
242700 | 242700 | 2020-06-15 | Dallas | Texas | 48113 | 14537 | 285 |
242701 | 242701 | 2020-06-15 | Dawson | Texas | 48115 | 45 | 1 |
242702 | 242702 | 2020-06-15 | DeWitt | Texas | 48123 | 28 | 1 |
242703 | 242703 | 2020-06-15 | Deaf Smith | Texas | 48117 | 212 | 14 |
242704 | 242704 | 2020-06-15 | Delta | Texas | 48119 | 2 | 0 |
242705 | 242705 | 2020-06-15 | Denton | Texas | 48121 | 1772 | 36 |
242706 | 242706 | 2020-06-15 | Dickens | Texas | 48125 | 2 | 0 |
242707 | 242707 | 2020-06-15 | Dimmit | Texas | 48127 | 1 | 0 |
242708 | 242708 | 2020-06-15 | Donley | Texas | 48129 | 28 | 0 |
242709 | 242709 | 2020-06-15 | Duval | Texas | 48131 | 5 | 0 |
242710 | 242710 | 2020-06-15 | Eastland | Texas | 48133 | 7 | 0 |
242711 | 242711 | 2020-06-15 | Ector | Texas | 48135 | 323 | 6 |
242712 | 242712 | 2020-06-15 | El Paso | Texas | 48141 | 3911 | 102 |
242713 | 242713 | 2020-06-15 | Ellis | Texas | 48139 | 448 | 19 |
242714 | 242714 | 2020-06-15 | Erath | Texas | 48143 | 36 | 1 |
242715 | 242715 | 2020-06-15 | Falls | Texas | 48145 | 17 | 0 |
242716 | 242716 | 2020-06-15 | Fannin | Texas | 48147 | 54 | 2 |
242717 | 242717 | 2020-06-15 | Fayette | Texas | 48149 | 44 | 2 |
242718 | 242718 | 2020-06-15 | Fisher | Texas | 48151 | 2 | 1 |
242719 | 242719 | 2020-06-15 | Floyd | Texas | 48153 | 16 | 1 |
242720 | 242720 | 2020-06-15 | Fort Bend | Texas | 48157 | 2402 | 49 |
242721 | 242721 | 2020-06-15 | Franklin | Texas | 48159 | 27 | 0 |
242722 | 242722 | 2020-06-15 | Freestone | Texas | 48161 | 15 | 0 |
242723 | 242723 | 2020-06-15 | Frio | Texas | 48163 | 79 | 0 |
242724 | 242724 | 2020-06-15 | Gaines | Texas | 48165 | 14 | 0 |
242725 | 242725 | 2020-06-15 | Galveston | Texas | 48167 | 1312 | 40 |
242726 | 242726 | 2020-06-15 | Garza | Texas | 48169 | 6 | 0 |
242727 | 242727 | 2020-06-15 | Gillespie | Texas | 48171 | 6 | 0 |
242728 | 242728 | 2020-06-15 | Glasscock | Texas | 48173 | 2 | 0 |
242729 | 242729 | 2020-06-15 | Goliad | Texas | 48175 | 7 | 0 |
242730 | 242730 | 2020-06-15 | Gonzales | Texas | 48177 | 166 | 4 |
242731 | 242731 | 2020-06-15 | Gray | Texas | 48179 | 111 | 3 |
242732 | 242732 | 2020-06-15 | Grayson | Texas | 48181 | 438 | 4 |
242733 | 242733 | 2020-06-15 | Gregg | Texas | 48183 | 287 | 12 |
242734 | 242734 | 2020-06-15 | Grimes | Texas | 48185 | 274 | 2 |
242735 | 242735 | 2020-06-15 | Guadalupe | Texas | 48187 | 171 | 0 |
242736 | 242736 | 2020-06-15 | Hale | Texas | 48189 | 85 | 5 |
242737 | 242737 | 2020-06-15 | Hall | Texas | 48191 | 2 | 1 |
242738 | 242738 | 2020-06-15 | Hamilton | Texas | 48193 | 11 | 1 |
242739 | 242739 | 2020-06-15 | Hansford | Texas | 48195 | 21 | 2 |
242740 | 242740 | 2020-06-15 | Hardeman | Texas | 48197 | 4 | 0 |
242741 | 242741 | 2020-06-15 | Hardin | Texas | 48199 | 146 | 5 |
242742 | 242742 | 2020-06-15 | Harris | Texas | 48201 | 17282 | 284 |
242743 | 242743 | 2020-06-15 | Harrison | Texas | 48203 | 270 | 28 |
242744 | 242744 | 2020-06-15 | Hartley | Texas | 48205 | 13 | 2 |
242745 | 242745 | 2020-06-15 | Haskell | Texas | 48207 | 4 | 0 |
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);