ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
135 rows where date = "2020-04-01" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
25709 | 25709 | 2020-04-01 | Anderson | Texas | 48001 | 1 | 0 |
25710 | 25710 | 2020-04-01 | Angelina | Texas | 48005 | 5 | 0 |
25711 | 25711 | 2020-04-01 | Atascosa | Texas | 48013 | 2 | 0 |
25712 | 25712 | 2020-04-01 | Austin | Texas | 48015 | 2 | 0 |
25713 | 25713 | 2020-04-01 | Bastrop | Texas | 48021 | 8 | 0 |
25714 | 25714 | 2020-04-01 | Bell | Texas | 48027 | 44 | 1 |
25715 | 25715 | 2020-04-01 | Bexar | Texas | 48029 | 229 | 9 |
25716 | 25716 | 2020-04-01 | Blanco | Texas | 48031 | 1 | 0 |
25717 | 25717 | 2020-04-01 | Bowie | Texas | 48037 | 9 | 0 |
25718 | 25718 | 2020-04-01 | Brazoria | Texas | 48039 | 95 | 1 |
25719 | 25719 | 2020-04-01 | Brazos | Texas | 48041 | 63 | 3 |
25720 | 25720 | 2020-04-01 | Brown | Texas | 48049 | 3 | 0 |
25721 | 25721 | 2020-04-01 | Burleson | Texas | 48051 | 1 | 0 |
25722 | 25722 | 2020-04-01 | Burnet | Texas | 48053 | 3 | 0 |
25723 | 25723 | 2020-04-01 | Caldwell | Texas | 48055 | 1 | 0 |
25724 | 25724 | 2020-04-01 | Calhoun | Texas | 48057 | 7 | 0 |
25725 | 25725 | 2020-04-01 | Cameron | Texas | 48061 | 26 | 0 |
25726 | 25726 | 2020-04-01 | Camp | Texas | 48063 | 1 | 0 |
25727 | 25727 | 2020-04-01 | Cass | Texas | 48067 | 3 | 0 |
25728 | 25728 | 2020-04-01 | Castro | Texas | 48069 | 8 | 0 |
25729 | 25729 | 2020-04-01 | Chambers | Texas | 48071 | 9 | 0 |
25730 | 25730 | 2020-04-01 | Cherokee | Texas | 48073 | 4 | 0 |
25731 | 25731 | 2020-04-01 | Clay | Texas | 48077 | 1 | 0 |
25732 | 25732 | 2020-04-01 | Collin | Texas | 48085 | 184 | 1 |
25733 | 25733 | 2020-04-01 | Colorado | Texas | 48089 | 2 | 0 |
25734 | 25734 | 2020-04-01 | Comal | Texas | 48091 | 12 | 2 |
25735 | 25735 | 2020-04-01 | Comanche | Texas | 48093 | 1 | 0 |
25736 | 25736 | 2020-04-01 | Coryell | Texas | 48099 | 1 | 0 |
25737 | 25737 | 2020-04-01 | Crane | Texas | 48103 | 2 | 0 |
25738 | 25738 | 2020-04-01 | Dallas | Texas | 48113 | 731 | 15 |
25739 | 25739 | 2020-04-01 | Dawson | Texas | 48115 | 3 | 0 |
25740 | 25740 | 2020-04-01 | DeWitt | Texas | 48123 | 4 | 0 |
25741 | 25741 | 2020-04-01 | Deaf Smith | Texas | 48117 | 2 | 0 |
25742 | 25742 | 2020-04-01 | Denton | Texas | 48121 | 231 | 4 |
25743 | 25743 | 2020-04-01 | Eastland | Texas | 48133 | 3 | 0 |
25744 | 25744 | 2020-04-01 | Ector | Texas | 48135 | 11 | 0 |
25745 | 25745 | 2020-04-01 | El Paso | Texas | 48141 | 50 | 0 |
25746 | 25746 | 2020-04-01 | Ellis | Texas | 48139 | 20 | 1 |
25747 | 25747 | 2020-04-01 | Erath | Texas | 48143 | 2 | 0 |
25748 | 25748 | 2020-04-01 | Falls | Texas | 48145 | 1 | 0 |
25749 | 25749 | 2020-04-01 | Fannin | Texas | 48147 | 1 | 0 |
25750 | 25750 | 2020-04-01 | Fayette | Texas | 48149 | 4 | 0 |
25751 | 25751 | 2020-04-01 | Fort Bend | Texas | 48157 | 163 | 2 |
25752 | 25752 | 2020-04-01 | Franklin | Texas | 48159 | 1 | 0 |
25753 | 25753 | 2020-04-01 | Gaines | Texas | 48165 | 1 | 0 |
25754 | 25754 | 2020-04-01 | Galveston | Texas | 48167 | 118 | 0 |
25755 | 25755 | 2020-04-01 | Gonzales | Texas | 48177 | 1 | 0 |
25756 | 25756 | 2020-04-01 | Gray | Texas | 48179 | 1 | 0 |
25757 | 25757 | 2020-04-01 | Grayson | Texas | 48181 | 8 | 0 |
25758 | 25758 | 2020-04-01 | Gregg | Texas | 48183 | 6 | 0 |
25759 | 25759 | 2020-04-01 | Grimes | Texas | 48185 | 3 | 0 |
25760 | 25760 | 2020-04-01 | Guadalupe | Texas | 48187 | 17 | 0 |
25761 | 25761 | 2020-04-01 | Hale | Texas | 48189 | 1 | 0 |
25762 | 25762 | 2020-04-01 | Hardin | Texas | 48199 | 13 | 1 |
25763 | 25763 | 2020-04-01 | Harris | Texas | 48201 | 847 | 6 |
25764 | 25764 | 2020-04-01 | Harrison | Texas | 48203 | 3 | 0 |
25765 | 25765 | 2020-04-01 | Hays | Texas | 48209 | 38 | 0 |
25766 | 25766 | 2020-04-01 | Henderson | Texas | 48213 | 1 | 0 |
25767 | 25767 | 2020-04-01 | Hidalgo | Texas | 48215 | 46 | 0 |
25768 | 25768 | 2020-04-01 | Hill | Texas | 48217 | 2 | 0 |
25769 | 25769 | 2020-04-01 | Hockley | Texas | 48219 | 7 | 0 |
25770 | 25770 | 2020-04-01 | Hood | Texas | 48221 | 6 | 0 |
25771 | 25771 | 2020-04-01 | Hopkins | Texas | 48223 | 3 | 0 |
25772 | 25772 | 2020-04-01 | Hunt | Texas | 48231 | 4 | 0 |
25773 | 25773 | 2020-04-01 | Jackson | Texas | 48239 | 1 | 0 |
25774 | 25774 | 2020-04-01 | Jefferson | Texas | 48245 | 27 | 0 |
25775 | 25775 | 2020-04-01 | Johnson | Texas | 48251 | 12 | 0 |
25776 | 25776 | 2020-04-01 | Karnes | Texas | 48255 | 2 | 0 |
25777 | 25777 | 2020-04-01 | Kaufman | Texas | 48257 | 4 | 0 |
25778 | 25778 | 2020-04-01 | Kendall | Texas | 48259 | 7 | 0 |
25779 | 25779 | 2020-04-01 | Kerr | Texas | 48265 | 1 | 0 |
25780 | 25780 | 2020-04-01 | Kleberg | Texas | 48273 | 1 | 0 |
25781 | 25781 | 2020-04-01 | Lamar | Texas | 48277 | 3 | 0 |
25782 | 25782 | 2020-04-01 | Lamb | Texas | 48279 | 1 | 0 |
25783 | 25783 | 2020-04-01 | Lavaca | Texas | 48285 | 1 | 0 |
25784 | 25784 | 2020-04-01 | Leon | Texas | 48289 | 2 | 0 |
25785 | 25785 | 2020-04-01 | Liberty | Texas | 48291 | 3 | 0 |
25786 | 25786 | 2020-04-01 | Limestone | Texas | 48293 | 2 | 0 |
25787 | 25787 | 2020-04-01 | Live Oak | Texas | 48297 | 1 | 0 |
25788 | 25788 | 2020-04-01 | Llano | Texas | 48299 | 3 | 0 |
25789 | 25789 | 2020-04-01 | Lubbock | Texas | 48303 | 100 | 2 |
25790 | 25790 | 2020-04-01 | Lynn | Texas | 48305 | 2 | 0 |
25791 | 25791 | 2020-04-01 | Martin | Texas | 48317 | 1 | 0 |
25792 | 25792 | 2020-04-01 | Matagorda | Texas | 48321 | 29 | 2 |
25793 | 25793 | 2020-04-01 | Maverick | Texas | 48323 | 1 | 0 |
25794 | 25794 | 2020-04-01 | McLennan | Texas | 48309 | 48 | 1 |
25795 | 25795 | 2020-04-01 | Medina | Texas | 48325 | 3 | 0 |
25796 | 25796 | 2020-04-01 | Midland | Texas | 48329 | 16 | 1 |
25797 | 25797 | 2020-04-01 | Milam | Texas | 48331 | 2 | 0 |
25798 | 25798 | 2020-04-01 | Montague | Texas | 48337 | 1 | 0 |
25799 | 25799 | 2020-04-01 | Montgomery | Texas | 48339 | 110 | 2 |
25800 | 25800 | 2020-04-01 | Moore | Texas | 48341 | 1 | 0 |
25801 | 25801 | 2020-04-01 | Morris | Texas | 48343 | 1 | 0 |
25802 | 25802 | 2020-04-01 | Nacogdoches | Texas | 48347 | 4 | 0 |
25803 | 25803 | 2020-04-01 | Navarro | Texas | 48349 | 4 | 0 |
25804 | 25804 | 2020-04-01 | Newton | Texas | 48351 | 1 | 0 |
25805 | 25805 | 2020-04-01 | Nueces | Texas | 48355 | 34 | 0 |
25806 | 25806 | 2020-04-01 | Oldham | Texas | 48359 | 2 | 1 |
25807 | 25807 | 2020-04-01 | Orange | Texas | 48361 | 7 | 0 |
25808 | 25808 | 2020-04-01 | Parker | Texas | 48367 | 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);