ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
123 rows where date = "2020-03-31" 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 |
---|---|---|---|---|---|---|---|
23506 | 23506 | 2020-03-31 | Angelina | Texas | 48005 | 4 | 0 |
23507 | 23507 | 2020-03-31 | Atascosa | Texas | 48013 | 2 | 0 |
23508 | 23508 | 2020-03-31 | Austin | Texas | 48015 | 2 | 0 |
23509 | 23509 | 2020-03-31 | Bastrop | Texas | 48021 | 6 | 0 |
23510 | 23510 | 2020-03-31 | Bell | Texas | 48027 | 36 | 1 |
23511 | 23511 | 2020-03-31 | Bexar | Texas | 48029 | 207 | 9 |
23512 | 23512 | 2020-03-31 | Blanco | Texas | 48031 | 1 | 0 |
23513 | 23513 | 2020-03-31 | Bowie | Texas | 48037 | 9 | 0 |
23514 | 23514 | 2020-03-31 | Brazoria | Texas | 48039 | 95 | 1 |
23515 | 23515 | 2020-03-31 | Brazos | Texas | 48041 | 46 | 2 |
23516 | 23516 | 2020-03-31 | Brown | Texas | 48049 | 3 | 0 |
23517 | 23517 | 2020-03-31 | Burleson | Texas | 48051 | 1 | 0 |
23518 | 23518 | 2020-03-31 | Burnet | Texas | 48053 | 2 | 0 |
23519 | 23519 | 2020-03-31 | Caldwell | Texas | 48055 | 1 | 0 |
23520 | 23520 | 2020-03-31 | Calhoun | Texas | 48057 | 3 | 0 |
23521 | 23521 | 2020-03-31 | Cameron | Texas | 48061 | 26 | 0 |
23522 | 23522 | 2020-03-31 | Cass | Texas | 48067 | 2 | 0 |
23523 | 23523 | 2020-03-31 | Castro | Texas | 48069 | 8 | 0 |
23524 | 23524 | 2020-03-31 | Chambers | Texas | 48071 | 8 | 0 |
23525 | 23525 | 2020-03-31 | Cherokee | Texas | 48073 | 2 | 0 |
23526 | 23526 | 2020-03-31 | Collin | Texas | 48085 | 160 | 1 |
23527 | 23527 | 2020-03-31 | Comal | Texas | 48091 | 11 | 2 |
23528 | 23528 | 2020-03-31 | Coryell | Texas | 48099 | 1 | 0 |
23529 | 23529 | 2020-03-31 | Crane | Texas | 48103 | 1 | 0 |
23530 | 23530 | 2020-03-31 | Dallas | Texas | 48113 | 631 | 13 |
23531 | 23531 | 2020-03-31 | Dawson | Texas | 48115 | 3 | 0 |
23532 | 23532 | 2020-03-31 | DeWitt | Texas | 48123 | 3 | 0 |
23533 | 23533 | 2020-03-31 | Deaf Smith | Texas | 48117 | 2 | 0 |
23534 | 23534 | 2020-03-31 | Denton | Texas | 48121 | 206 | 4 |
23535 | 23535 | 2020-03-31 | Eastland | Texas | 48133 | 3 | 0 |
23536 | 23536 | 2020-03-31 | Ector | Texas | 48135 | 7 | 0 |
23537 | 23537 | 2020-03-31 | El Paso | Texas | 48141 | 50 | 0 |
23538 | 23538 | 2020-03-31 | Ellis | Texas | 48139 | 16 | 1 |
23539 | 23539 | 2020-03-31 | Erath | Texas | 48143 | 1 | 0 |
23540 | 23540 | 2020-03-31 | Falls | Texas | 48145 | 1 | 0 |
23541 | 23541 | 2020-03-31 | Fannin | Texas | 48147 | 1 | 0 |
23542 | 23542 | 2020-03-31 | Fayette | Texas | 48149 | 2 | 0 |
23543 | 23543 | 2020-03-31 | Fort Bend | Texas | 48157 | 138 | 2 |
23544 | 23544 | 2020-03-31 | Franklin | Texas | 48159 | 1 | 0 |
23545 | 23545 | 2020-03-31 | Gaines | Texas | 48165 | 1 | 0 |
23546 | 23546 | 2020-03-31 | Galveston | Texas | 48167 | 106 | 0 |
23547 | 23547 | 2020-03-31 | Grayson | Texas | 48181 | 7 | 0 |
23548 | 23548 | 2020-03-31 | Gregg | Texas | 48183 | 5 | 0 |
23549 | 23549 | 2020-03-31 | Grimes | Texas | 48185 | 3 | 0 |
23550 | 23550 | 2020-03-31 | Guadalupe | Texas | 48187 | 15 | 0 |
23551 | 23551 | 2020-03-31 | Hale | Texas | 48189 | 1 | 0 |
23552 | 23552 | 2020-03-31 | Hardin | Texas | 48199 | 12 | 1 |
23553 | 23553 | 2020-03-31 | Harris | Texas | 48201 | 680 | 6 |
23554 | 23554 | 2020-03-31 | Harrison | Texas | 48203 | 1 | 0 |
23555 | 23555 | 2020-03-31 | Hays | Texas | 48209 | 24 | 0 |
23556 | 23556 | 2020-03-31 | Henderson | Texas | 48213 | 1 | 0 |
23557 | 23557 | 2020-03-31 | Hidalgo | Texas | 48215 | 38 | 0 |
23558 | 23558 | 2020-03-31 | Hill | Texas | 48217 | 1 | 0 |
23559 | 23559 | 2020-03-31 | Hockley | Texas | 48219 | 7 | 0 |
23560 | 23560 | 2020-03-31 | Hood | Texas | 48221 | 6 | 0 |
23561 | 23561 | 2020-03-31 | Hopkins | Texas | 48223 | 3 | 0 |
23562 | 23562 | 2020-03-31 | Hunt | Texas | 48231 | 4 | 0 |
23563 | 23563 | 2020-03-31 | Jackson | Texas | 48239 | 1 | 0 |
23564 | 23564 | 2020-03-31 | Jefferson | Texas | 48245 | 18 | 0 |
23565 | 23565 | 2020-03-31 | Johnson | Texas | 48251 | 8 | 0 |
23566 | 23566 | 2020-03-31 | Karnes | Texas | 48255 | 2 | 0 |
23567 | 23567 | 2020-03-31 | Kaufman | Texas | 48257 | 3 | 0 |
23568 | 23568 | 2020-03-31 | Kendall | Texas | 48259 | 7 | 0 |
23569 | 23569 | 2020-03-31 | Kleberg | Texas | 48273 | 1 | 0 |
23570 | 23570 | 2020-03-31 | Lamar | Texas | 48277 | 3 | 0 |
23571 | 23571 | 2020-03-31 | Lamb | Texas | 48279 | 1 | 0 |
23572 | 23572 | 2020-03-31 | Lavaca | Texas | 48285 | 1 | 0 |
23573 | 23573 | 2020-03-31 | Leon | Texas | 48289 | 1 | 0 |
23574 | 23574 | 2020-03-31 | Liberty | Texas | 48291 | 2 | 0 |
23575 | 23575 | 2020-03-31 | Limestone | Texas | 48293 | 2 | 0 |
23576 | 23576 | 2020-03-31 | Llano | Texas | 48299 | 3 | 0 |
23577 | 23577 | 2020-03-31 | Lubbock | Texas | 48303 | 77 | 1 |
23578 | 23578 | 2020-03-31 | Lynn | Texas | 48305 | 2 | 0 |
23579 | 23579 | 2020-03-31 | Martin | Texas | 48317 | 1 | 0 |
23580 | 23580 | 2020-03-31 | Matagorda | Texas | 48321 | 27 | 2 |
23581 | 23581 | 2020-03-31 | Maverick | Texas | 48323 | 1 | 0 |
23582 | 23582 | 2020-03-31 | McLennan | Texas | 48309 | 39 | 1 |
23583 | 23583 | 2020-03-31 | Medina | Texas | 48325 | 3 | 0 |
23584 | 23584 | 2020-03-31 | Midland | Texas | 48329 | 13 | 1 |
23585 | 23585 | 2020-03-31 | Milam | Texas | 48331 | 2 | 0 |
23586 | 23586 | 2020-03-31 | Montague | Texas | 48337 | 1 | 0 |
23587 | 23587 | 2020-03-31 | Montgomery | Texas | 48339 | 81 | 0 |
23588 | 23588 | 2020-03-31 | Moore | Texas | 48341 | 1 | 0 |
23589 | 23589 | 2020-03-31 | Morris | Texas | 48343 | 1 | 0 |
23590 | 23590 | 2020-03-31 | Nacogdoches | Texas | 48347 | 2 | 0 |
23591 | 23591 | 2020-03-31 | Navarro | Texas | 48349 | 3 | 0 |
23592 | 23592 | 2020-03-31 | Nueces | Texas | 48355 | 31 | 0 |
23593 | 23593 | 2020-03-31 | Oldham | Texas | 48359 | 2 | 1 |
23594 | 23594 | 2020-03-31 | Orange | Texas | 48361 | 5 | 0 |
23595 | 23595 | 2020-03-31 | Parker | Texas | 48367 | 4 | 0 |
23596 | 23596 | 2020-03-31 | Polk | Texas | 48373 | 4 | 0 |
23597 | 23597 | 2020-03-31 | Potter | Texas | 48375 | 5 | 0 |
23598 | 23598 | 2020-03-31 | Randall | Texas | 48381 | 6 | 0 |
23599 | 23599 | 2020-03-31 | Robertson | Texas | 48395 | 2 | 0 |
23600 | 23600 | 2020-03-31 | Rockwall | Texas | 48397 | 5 | 0 |
23601 | 23601 | 2020-03-31 | Rusk | Texas | 48401 | 3 | 0 |
23602 | 23602 | 2020-03-31 | San Jacinto | Texas | 48407 | 1 | 0 |
23603 | 23603 | 2020-03-31 | San Patricio | Texas | 48409 | 1 | 0 |
23604 | 23604 | 2020-03-31 | Shelby | Texas | 48419 | 2 | 0 |
23605 | 23605 | 2020-03-31 | Smith | Texas | 48423 | 32 | 1 |
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);