ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
254 rows where "date" is on date 2022-03-04 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2274379 | 2274379 | 2022-03-04 | Anderson | Texas | 48001 | 9491 | 230 |
2274380 | 2274380 | 2022-03-04 | Andrews | Texas | 48003 | 3788 | 71 |
2274381 | 2274381 | 2022-03-04 | Angelina | Texas | 48005 | 15241 | 471 |
2274382 | 2274382 | 2022-03-04 | Aransas | Texas | 48007 | 4052 | 78 |
2274383 | 2274383 | 2022-03-04 | Archer | Texas | 48009 | 2092 | 28 |
2274384 | 2274384 | 2022-03-04 | Armstrong | Texas | 48011 | 502 | 8 |
2274385 | 2274385 | 2022-03-04 | Atascosa | Texas | 48013 | 13293 | 229 |
2274386 | 2274386 | 2022-03-04 | Austin | Texas | 48015 | 5569 | 71 |
2274387 | 2274387 | 2022-03-04 | Bailey | Texas | 48017 | 1380 | 38 |
2274388 | 2274388 | 2022-03-04 | Bandera | Texas | 48019 | 3527 | 74 |
2274389 | 2274389 | 2022-03-04 | Bastrop | Texas | 48021 | 21598 | 227 |
2274390 | 2274390 | 2022-03-04 | Baylor | Texas | 48023 | 809 | 32 |
2274391 | 2274391 | 2022-03-04 | Bee | Texas | 48025 | 8159 | 149 |
2274392 | 2274392 | 2022-03-04 | Bell | Texas | 48027 | 66121 | 867 |
2274393 | 2274393 | 2022-03-04 | Bexar | Texas | 48029 | 545702 | 5950 |
2274394 | 2274394 | 2022-03-04 | Blanco | Texas | 48031 | 2506 | 33 |
2274395 | 2274395 | 2022-03-04 | Borden | Texas | 48033 | 94 | 2 |
2274396 | 2274396 | 2022-03-04 | Bosque | Texas | 48035 | 4017 | 70 |
2274397 | 2274397 | 2022-03-04 | Bowie | Texas | 48037 | 19628 | 411 |
2274398 | 2274398 | 2022-03-04 | Brazoria | Texas | 48039 | 92744 | 972 |
2274399 | 2274399 | 2022-03-04 | Brazos | Texas | 48041 | 59711 | 404 |
2274400 | 2274400 | 2022-03-04 | Brewster | Texas | 48043 | 1052 | 27 |
2274401 | 2274401 | 2022-03-04 | Briscoe | Texas | 48045 | 444 | 8 |
2274402 | 2274402 | 2022-03-04 | Brooks | Texas | 48047 | 1604 | 51 |
2274403 | 2274403 | 2022-03-04 | Brown | Texas | 48049 | 11377 | 244 |
2274404 | 2274404 | 2022-03-04 | Burleson | Texas | 48051 | 4984 | 65 |
2274405 | 2274405 | 2022-03-04 | Burnet | Texas | 48053 | 10712 | 162 |
2274406 | 2274406 | 2022-03-04 | Caldwell | Texas | 48055 | 14061 | 172 |
2274407 | 2274407 | 2022-03-04 | Calhoun | Texas | 48057 | 5665 | 46 |
2274408 | 2274408 | 2022-03-04 | Callahan | Texas | 48059 | 2766 | 72 |
2274409 | 2274409 | 2022-03-04 | Cameron | Texas | 48061 | 98830 | 2029 |
2274410 | 2274410 | 2022-03-04 | Camp | Texas | 48063 | 2799 | 73 |
2274411 | 2274411 | 2022-03-04 | Carson | Texas | 48065 | 1486 | 34 |
2274412 | 2274412 | 2022-03-04 | Cass | Texas | 48067 | 7030 | 189 |
2274413 | 2274413 | 2022-03-04 | Castro | Texas | 48069 | 2259 | 46 |
2274414 | 2274414 | 2022-03-04 | Chambers | Texas | 48071 | 11587 | 111 |
2274415 | 2274415 | 2022-03-04 | Cherokee | Texas | 48073 | 7920 | 247 |
2274416 | 2274416 | 2022-03-04 | Childress | Texas | 48075 | 2583 | 29 |
2274417 | 2274417 | 2022-03-04 | Clay | Texas | 48077 | 2040 | 32 |
2274418 | 2274418 | 2022-03-04 | Cochran | Texas | 48079 | 862 | 23 |
2274419 | 2274419 | 2022-03-04 | Coke | Texas | 48081 | 830 | 19 |
2274420 | 2274420 | 2022-03-04 | Coleman | Texas | 48083 | 1612 | 69 |
2274421 | 2274421 | 2022-03-04 | Collin | Texas | 48085 | 204123 | 1448 |
2274422 | 2274422 | 2022-03-04 | Collingsworth | Texas | 48087 | 687 | 16 |
2274423 | 2274423 | 2022-03-04 | Colorado | Texas | 48089 | 3714 | 61 |
2274424 | 2274424 | 2022-03-04 | Comal | Texas | 48091 | 32225 | 535 |
2274425 | 2274425 | 2022-03-04 | Comanche | Texas | 48093 | 3129 | 77 |
2274426 | 2274426 | 2022-03-04 | Concho | Texas | 48095 | 1070 | 11 |
2274427 | 2274427 | 2022-03-04 | Cooke | Texas | 48097 | 7174 | 130 |
2274428 | 2274428 | 2022-03-04 | Coryell | Texas | 48099 | 17099 | 205 |
2274429 | 2274429 | 2022-03-04 | Cottle | Texas | 48101 | 279 | 9 |
2274430 | 2274430 | 2022-03-04 | Crane | Texas | 48103 | 1266 | 24 |
2274431 | 2274431 | 2022-03-04 | Crockett | Texas | 48105 | 1020 | 19 |
2274432 | 2274432 | 2022-03-04 | Crosby | Texas | 48107 | 1827 | 45 |
2274433 | 2274433 | 2022-03-04 | Culberson | Texas | 48109 | 508 | 14 |
2274434 | 2274434 | 2022-03-04 | Dallam | Texas | 48111 | 2122 | 40 |
2274435 | 2274435 | 2022-03-04 | Dallas | Texas | 48113 | 565678 | 6523 |
2274436 | 2274436 | 2022-03-04 | Dawson | Texas | 48115 | 2758 | 93 |
2274437 | 2274437 | 2022-03-04 | DeWitt | Texas | 48123 | 6420 | 96 |
2274438 | 2274438 | 2022-03-04 | Deaf Smith | Texas | 48117 | 4476 | 109 |
2274439 | 2274439 | 2022-03-04 | Delta | Texas | 48119 | 1795 | 24 |
2274440 | 2274440 | 2022-03-04 | Denton | Texas | 48121 | 177015 | 1304 |
2274441 | 2274441 | 2022-03-04 | Dickens | Texas | 48125 | 422 | 16 |
2274442 | 2274442 | 2022-03-04 | Dimmit | Texas | 48127 | 5711 | 51 |
2274443 | 2274443 | 2022-03-04 | Donley | Texas | 48129 | 1065 | 24 |
2274444 | 2274444 | 2022-03-04 | Duval | Texas | 48131 | 3304 | 68 |
2274445 | 2274445 | 2022-03-04 | Eastland | Texas | 48133 | 2764 | 110 |
2274446 | 2274446 | 2022-03-04 | Ector | Texas | 48135 | 36940 | 683 |
2274447 | 2274447 | 2022-03-04 | Edwards | Texas | 48137 | 465 | 11 |
2274448 | 2274448 | 2022-03-04 | El Paso | Texas | 48141 | 203510 | 3653 |
2274449 | 2274449 | 2022-03-04 | Ellis | Texas | 48139 | 48369 | 571 |
2274450 | 2274450 | 2022-03-04 | Erath | Texas | 48143 | 8597 | 121 |
2274451 | 2274451 | 2022-03-04 | Falls | Texas | 48145 | 3730 | 63 |
2274452 | 2274452 | 2022-03-04 | Fannin | Texas | 48147 | 6759 | 178 |
2274453 | 2274453 | 2022-03-04 | Fayette | Texas | 48149 | 4730 | 99 |
2274454 | 2274454 | 2022-03-04 | Fisher | Texas | 48151 | 604 | 24 |
2274455 | 2274455 | 2022-03-04 | Floyd | Texas | 48153 | 1901 | 47 |
2274456 | 2274456 | 2022-03-04 | Foard | Texas | 48155 | 198 | 11 |
2274457 | 2274457 | 2022-03-04 | Fort Bend | Texas | 48157 | 177233 | 1191 |
2274458 | 2274458 | 2022-03-04 | Franklin | Texas | 48159 | 2112 | 40 |
2274459 | 2274459 | 2022-03-04 | Freestone | Texas | 48161 | 3834 | 82 |
2274460 | 2274460 | 2022-03-04 | Frio | Texas | 48163 | 5610 | 90 |
2274461 | 2274461 | 2022-03-04 | Gaines | Texas | 48165 | 1880 | 83 |
2274462 | 2274462 | 2022-03-04 | Galveston | Texas | 48167 | 94716 | 831 |
2274463 | 2274463 | 2022-03-04 | Garza | Texas | 48169 | 1230 | 27 |
2274464 | 2274464 | 2022-03-04 | Gillespie | Texas | 48171 | 5289 | 107 |
2274465 | 2274465 | 2022-03-04 | Glasscock | Texas | 48173 | 197 | 3 |
2274466 | 2274466 | 2022-03-04 | Goliad | Texas | 48175 | 1183 | 32 |
2274467 | 2274467 | 2022-03-04 | Gonzales | Texas | 48177 | 4676 | 95 |
2274468 | 2274468 | 2022-03-04 | Gray | Texas | 48179 | 6086 | 122 |
2274469 | 2274469 | 2022-03-04 | Grayson | Texas | 48181 | 27011 | 618 |
2274470 | 2274470 | 2022-03-04 | Gregg | Texas | 48183 | 23040 | 655 |
2274471 | 2274471 | 2022-03-04 | Grimes | Texas | 48185 | 8418 | 118 |
2274472 | 2274472 | 2022-03-04 | Guadalupe | Texas | 48187 | 36820 | 388 |
2274473 | 2274473 | 2022-03-04 | Hale | Texas | 48189 | 6499 | 238 |
2274474 | 2274474 | 2022-03-04 | Hall | Texas | 48191 | 1067 | 22 |
2274475 | 2274475 | 2022-03-04 | Hamilton | Texas | 48193 | 1957 | 32 |
2274476 | 2274476 | 2022-03-04 | Hansford | Texas | 48195 | 1901 | 29 |
2274477 | 2274477 | 2022-03-04 | Hardeman | Texas | 48197 | 553 | 19 |
2274478 | 2274478 | 2022-03-04 | Hardin | Texas | 48199 | 11994 | 245 |
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);