ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
55 rows where date = "2020-03-24" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
10631 | 10631 | 2020-03-24 | Bastrop | Texas | 48021 | 1 | 0 |
10632 | 10632 | 2020-03-24 | Bell | Texas | 48027 | 8 | 0 |
10633 | 10633 | 2020-03-24 | Bexar | Texas | 48029 | 68 | 1 |
10634 | 10634 | 2020-03-24 | Bowie | Texas | 48037 | 1 | 0 |
10635 | 10635 | 2020-03-24 | Brazoria | Texas | 48039 | 18 | 0 |
10636 | 10636 | 2020-03-24 | Brazos | Texas | 48041 | 12 | 0 |
10637 | 10637 | 2020-03-24 | Brown | Texas | 48049 | 2 | 0 |
10638 | 10638 | 2020-03-24 | Cameron | Texas | 48061 | 6 | 0 |
10639 | 10639 | 2020-03-24 | Cass | Texas | 48067 | 1 | 0 |
10640 | 10640 | 2020-03-24 | Castro | Texas | 48069 | 2 | 0 |
10641 | 10641 | 2020-03-24 | Chambers | Texas | 48071 | 2 | 0 |
10642 | 10642 | 2020-03-24 | Collin | Texas | 48085 | 53 | 1 |
10643 | 10643 | 2020-03-24 | Comal | Texas | 48091 | 3 | 0 |
10644 | 10644 | 2020-03-24 | Crane | Texas | 48103 | 1 | 0 |
10645 | 10645 | 2020-03-24 | Dallas | Texas | 48113 | 169 | 5 |
10646 | 10646 | 2020-03-24 | DeWitt | Texas | 48123 | 1 | 0 |
10647 | 10647 | 2020-03-24 | Deaf Smith | Texas | 48117 | 2 | 0 |
10648 | 10648 | 2020-03-24 | Denton | Texas | 48121 | 38 | 0 |
10649 | 10649 | 2020-03-24 | El Paso | Texas | 48141 | 12 | 0 |
10650 | 10650 | 2020-03-24 | Ellis | Texas | 48139 | 5 | 0 |
10651 | 10651 | 2020-03-24 | Falls | Texas | 48145 | 1 | 0 |
10652 | 10652 | 2020-03-24 | Fannin | Texas | 48147 | 1 | 0 |
10653 | 10653 | 2020-03-24 | Fort Bend | Texas | 48157 | 42 | 0 |
10654 | 10654 | 2020-03-24 | Galveston | Texas | 48167 | 18 | 0 |
10655 | 10655 | 2020-03-24 | Grayson | Texas | 48181 | 1 | 0 |
10656 | 10656 | 2020-03-24 | Gregg | Texas | 48183 | 1 | 0 |
10657 | 10657 | 2020-03-24 | Harris | Texas | 48201 | 134 | 1 |
10658 | 10658 | 2020-03-24 | Hays | Texas | 48209 | 6 | 0 |
10659 | 10659 | 2020-03-24 | Hidalgo | Texas | 48215 | 2 | 0 |
10660 | 10660 | 2020-03-24 | Hockley | Texas | 48219 | 3 | 0 |
10661 | 10661 | 2020-03-24 | Jefferson | Texas | 48245 | 7 | 0 |
10662 | 10662 | 2020-03-24 | Johnson | Texas | 48251 | 2 | 0 |
10663 | 10663 | 2020-03-24 | Lavaca | Texas | 48285 | 1 | 0 |
10664 | 10664 | 2020-03-24 | Lubbock | Texas | 48303 | 9 | 0 |
10665 | 10665 | 2020-03-24 | Matagorda | Texas | 48321 | 4 | 1 |
10666 | 10666 | 2020-03-24 | McLennan | Texas | 48309 | 20 | 0 |
10667 | 10667 | 2020-03-24 | Medina | Texas | 48325 | 1 | 0 |
10668 | 10668 | 2020-03-24 | Midland | Texas | 48329 | 1 | 0 |
10669 | 10669 | 2020-03-24 | Montgomery | Texas | 48339 | 15 | 0 |
10670 | 10670 | 2020-03-24 | Morris | Texas | 48343 | 1 | 0 |
10671 | 10671 | 2020-03-24 | Nueces | Texas | 48355 | 1 | 0 |
10672 | 10672 | 2020-03-24 | Oldham | Texas | 48359 | 1 | 0 |
10673 | 10673 | 2020-03-24 | Parker | Texas | 48367 | 1 | 0 |
10674 | 10674 | 2020-03-24 | Potter | Texas | 48375 | 2 | 0 |
10675 | 10675 | 2020-03-24 | Rusk | Texas | 48401 | 1 | 0 |
10676 | 10676 | 2020-03-24 | Smith | Texas | 48423 | 10 | 0 |
10677 | 10677 | 2020-03-24 | Tarrant | Texas | 48439 | 57 | 1 |
10678 | 10678 | 2020-03-24 | Travis | Texas | 48453 | 79 | 0 |
10679 | 10679 | 2020-03-24 | Unknown | Texas | 0 | 1 | |
10680 | 10680 | 2020-03-24 | Upshur | Texas | 48459 | 1 | 0 |
10681 | 10681 | 2020-03-24 | Van Zandt | Texas | 48467 | 1 | 0 |
10682 | 10682 | 2020-03-24 | Victoria | Texas | 48469 | 3 | 0 |
10683 | 10683 | 2020-03-24 | Webb | Texas | 48479 | 5 | 0 |
10684 | 10684 | 2020-03-24 | Wichita | Texas | 48485 | 6 | 0 |
10685 | 10685 | 2020-03-24 | Williamson | Texas | 48491 | 14 | 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);