ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
254 rows where date = "2021-07-28" 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 |
---|---|---|---|---|---|---|---|
1562594 | 1562594 | 2021-07-28 | Anderson | Texas | 48001 | 6222 | 133 |
1562595 | 1562595 | 2021-07-28 | Andrews | Texas | 48003 | 1887 | 47 |
1562596 | 1562596 | 2021-07-28 | Angelina | Texas | 48005 | 8990 | 288 |
1562597 | 1562597 | 2021-07-28 | Aransas | Texas | 48007 | 1427 | 43 |
1562598 | 1562598 | 2021-07-28 | Archer | Texas | 48009 | 821 | 12 |
1562599 | 1562599 | 2021-07-28 | Armstrong | Texas | 48011 | 219 | 7 |
1562600 | 1562600 | 2021-07-28 | Atascosa | Texas | 48013 | 6132 | 151 |
1562601 | 1562601 | 2021-07-28 | Austin | Texas | 48015 | 2320 | 37 |
1562602 | 1562602 | 2021-07-28 | Bailey | Texas | 48017 | 874 | 19 |
1562603 | 1562603 | 2021-07-28 | Bandera | Texas | 48019 | 1520 | 31 |
1562604 | 1562604 | 2021-07-28 | Bastrop | Texas | 48021 | 10279 | 106 |
1562605 | 1562605 | 2021-07-28 | Baylor | Texas | 48023 | 305 | 13 |
1562606 | 1562606 | 2021-07-28 | Bee | Texas | 48025 | 3632 | 75 |
1562607 | 1562607 | 2021-07-28 | Bell | Texas | 48027 | 26533 | 461 |
1562608 | 1562608 | 2021-07-28 | Bexar | Texas | 48029 | 236694 | 3676 |
1562609 | 1562609 | 2021-07-28 | Blanco | Texas | 48031 | 808 | 21 |
1562610 | 1562610 | 2021-07-28 | Borden | Texas | 48033 | 31 | 2 |
1562611 | 1562611 | 2021-07-28 | Bosque | Texas | 48035 | 1764 | 37 |
1562612 | 1562612 | 2021-07-28 | Bowie | Texas | 48037 | 8112 | 227 |
1562613 | 1562613 | 2021-07-28 | Brazoria | Texas | 48039 | 40547 | 542 |
1562614 | 1562614 | 2021-07-28 | Brazos | Texas | 48041 | 28652 | 265 |
1562615 | 1562615 | 2021-07-28 | Brewster | Texas | 48043 | 949 | 17 |
1562616 | 1562616 | 2021-07-28 | Briscoe | Texas | 48045 | 181 | 7 |
1562617 | 1562617 | 2021-07-28 | Brooks | Texas | 48047 | 889 | 37 |
1562618 | 1562618 | 2021-07-28 | Brown | Texas | 48049 | 4530 | 142 |
1562619 | 1562619 | 2021-07-28 | Burleson | Texas | 48051 | 2535 | 48 |
1562620 | 1562620 | 2021-07-28 | Burnet | Texas | 48053 | 5167 | 71 |
1562621 | 1562621 | 2021-07-28 | Caldwell | Texas | 48055 | 5987 | 100 |
1562622 | 1562622 | 2021-07-28 | Calhoun | Texas | 48057 | 2568 | 25 |
1562623 | 1562623 | 2021-07-28 | Callahan | Texas | 48059 | 1231 | 41 |
1562624 | 1562624 | 2021-07-28 | Cameron | Texas | 48061 | 44091 | 1705 |
1562625 | 1562625 | 2021-07-28 | Camp | Texas | 48063 | 1369 | 45 |
1562626 | 1562626 | 2021-07-28 | Carson | Texas | 48065 | 619 | 14 |
1562627 | 1562627 | 2021-07-28 | Cass | Texas | 48067 | 2376 | 85 |
1562628 | 1562628 | 2021-07-28 | Castro | Texas | 48069 | 1083 | 32 |
1562629 | 1562629 | 2021-07-28 | Chambers | Texas | 48071 | 5573 | 59 |
1562630 | 1562630 | 2021-07-28 | Cherokee | Texas | 48073 | 4458 | 148 |
1562631 | 1562631 | 2021-07-28 | Childress | Texas | 48075 | 1382 | 17 |
1562632 | 1562632 | 2021-07-28 | Clay | Texas | 48077 | 1068 | 17 |
1562633 | 1562633 | 2021-07-28 | Cochran | Texas | 48079 | 340 | 15 |
1562634 | 1562634 | 2021-07-28 | Coke | Texas | 48081 | 474 | 13 |
1562635 | 1562635 | 2021-07-28 | Coleman | Texas | 48083 | 797 | 35 |
1562636 | 1562636 | 2021-07-28 | Collin | Texas | 48085 | 95861 | 861 |
1562637 | 1562637 | 2021-07-28 | Collingsworth | Texas | 48087 | 334 | 9 |
1562638 | 1562638 | 2021-07-28 | Colorado | Texas | 48089 | 1835 | 33 |
1562639 | 1562639 | 2021-07-28 | Comal | Texas | 48091 | 12340 | 335 |
1562640 | 1562640 | 2021-07-28 | Comanche | Texas | 48093 | 1593 | 52 |
1562641 | 1562641 | 2021-07-28 | Concho | Texas | 48095 | 515 | 8 |
1562642 | 1562642 | 2021-07-28 | Cooke | Texas | 48097 | 3851 | 72 |
1562643 | 1562643 | 2021-07-28 | Coryell | Texas | 48099 | 7724 | 89 |
1562644 | 1562644 | 2021-07-28 | Cottle | Texas | 48101 | 193 | 7 |
1562645 | 1562645 | 2021-07-28 | Crane | Texas | 48103 | 576 | 12 |
1562646 | 1562646 | 2021-07-28 | Crockett | Texas | 48105 | 618 | 15 |
1562647 | 1562647 | 2021-07-28 | Crosby | Texas | 48107 | 774 | 29 |
1562648 | 1562648 | 2021-07-28 | Culberson | Texas | 48109 | 367 | 11 |
1562649 | 1562649 | 2021-07-28 | Dallam | Texas | 48111 | 994 | 26 |
1562650 | 1562650 | 2021-07-28 | Dallas | Texas | 48113 | 314372 | 4167 |
1562651 | 1562651 | 2021-07-28 | Dawson | Texas | 48115 | 1757 | 69 |
1562652 | 1562652 | 2021-07-28 | DeWitt | Texas | 48123 | 2050 | 61 |
1562653 | 1562653 | 2021-07-28 | Deaf Smith | Texas | 48117 | 2992 | 68 |
1562654 | 1562654 | 2021-07-28 | Delta | Texas | 48119 | 367 | 14 |
1562655 | 1562655 | 2021-07-28 | Denton | Texas | 48121 | 79359 | 790 |
1562656 | 1562656 | 2021-07-28 | Dickens | Texas | 48125 | 198 | 10 |
1562657 | 1562657 | 2021-07-28 | Dimmit | Texas | 48127 | 2943 | 37 |
1562658 | 1562658 | 2021-07-28 | Donley | Texas | 48129 | 431 | 15 |
1562659 | 1562659 | 2021-07-28 | Duval | Texas | 48131 | 1367 | 42 |
1562660 | 1562660 | 2021-07-28 | Eastland | Texas | 48133 | 1386 | 50 |
1562661 | 1562661 | 2021-07-28 | Ector | Texas | 48135 | 18230 | 380 |
1562662 | 1562662 | 2021-07-28 | Edwards | Texas | 48137 | 250 | 6 |
1562663 | 1562663 | 2021-07-28 | El Paso | Texas | 48141 | 137844 | 2758 |
1562664 | 1562664 | 2021-07-28 | Ellis | Texas | 48139 | 23511 | 325 |
1562665 | 1562665 | 2021-07-28 | Erath | Texas | 48143 | 4360 | 70 |
1562666 | 1562666 | 2021-07-28 | Falls | Texas | 48145 | 2115 | 33 |
1562667 | 1562667 | 2021-07-28 | Fannin | Texas | 48147 | 3531 | 109 |
1562668 | 1562668 | 2021-07-28 | Fayette | Texas | 48149 | 2875 | 69 |
1562669 | 1562669 | 2021-07-28 | Fisher | Texas | 48151 | 311 | 14 |
1562670 | 1562670 | 2021-07-28 | Floyd | Texas | 48153 | 916 | 30 |
1562671 | 1562671 | 2021-07-28 | Foard | Texas | 48155 | 124 | 10 |
1562672 | 1562672 | 2021-07-28 | Fort Bend | Texas | 48157 | 72311 | 741 |
1562673 | 1562673 | 2021-07-28 | Franklin | Texas | 48159 | 827 | 26 |
1562674 | 1562674 | 2021-07-28 | Freestone | Texas | 48161 | 2040 | 50 |
1562675 | 1562675 | 2021-07-28 | Frio | Texas | 48163 | 3047 | 53 |
1562676 | 1562676 | 2021-07-28 | Gaines | Texas | 48165 | 1477 | 46 |
1562677 | 1562677 | 2021-07-28 | Galveston | Texas | 48167 | 43528 | 459 |
1562678 | 1562678 | 2021-07-28 | Garza | Texas | 48169 | 562 | 22 |
1562679 | 1562679 | 2021-07-28 | Gillespie | Texas | 48171 | 2707 | 53 |
1562680 | 1562680 | 2021-07-28 | Glasscock | Texas | 48173 | 105 | 2 |
1562681 | 1562681 | 2021-07-28 | Goliad | Texas | 48175 | 503 | 16 |
1562682 | 1562682 | 2021-07-28 | Gonzales | Texas | 48177 | 2808 | 59 |
1562683 | 1562683 | 2021-07-28 | Gray | Texas | 48179 | 2587 | 58 |
1562684 | 1562684 | 2021-07-28 | Grayson | Texas | 48181 | 11774 | 348 |
1562685 | 1562685 | 2021-07-28 | Gregg | Texas | 48183 | 11887 | 363 |
1562686 | 1562686 | 2021-07-28 | Grimes | Texas | 48185 | 4067 | 74 |
1562687 | 1562687 | 2021-07-28 | Guadalupe | Texas | 48187 | 16563 | 224 |
1562688 | 1562688 | 2021-07-28 | Hale | Texas | 48189 | 6278 | 157 |
1562689 | 1562689 | 2021-07-28 | Hall | Texas | 48191 | 501 | 14 |
1562690 | 1562690 | 2021-07-28 | Hamilton | Texas | 48193 | 841 | 29 |
1562691 | 1562691 | 2021-07-28 | Hansford | Texas | 48195 | 954 | 24 |
1562692 | 1562692 | 2021-07-28 | Hardeman | Texas | 48197 | 388 | 12 |
1562693 | 1562693 | 2021-07-28 | Hardin | Texas | 48199 | 6478 | 118 |
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);