ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
255 rows where "date" is on date 2022-01-19 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2131369 | 2131369 | 2022-01-19 | Harris | Texas | 48201 | 901838 | 9932 |
2131370 | 2131370 | 2022-01-19 | Harrison | Texas | 48203 | 11267 | 196 |
2131371 | 2131371 | 2022-01-19 | Hartley | Texas | 48205 | 1195 | 3 |
2131372 | 2131372 | 2022-01-19 | Haskell | Texas | 48207 | 763 | 37 |
2131373 | 2131373 | 2022-01-19 | Hays | Texas | 48209 | 48024 | 427 |
2131374 | 2131374 | 2022-01-19 | Hemphill | Texas | 48211 | 999 | 3 |
2131375 | 2131375 | 2022-01-19 | Henderson | Texas | 48213 | 11249 | 363 |
2131376 | 2131376 | 2022-01-19 | Hidalgo | Texas | 48215 | 154865 | 3560 |
2131377 | 2131377 | 2022-01-19 | Hill | Texas | 48217 | 7625 | 178 |
2131378 | 2131378 | 2022-01-19 | Hockley | Texas | 48219 | 6844 | 143 |
2131379 | 2131379 | 2022-01-19 | Hood | Texas | 48221 | 11498 | 223 |
2131380 | 2131380 | 2022-01-19 | Hopkins | Texas | 48223 | 6379 | 156 |
2131381 | 2131381 | 2022-01-19 | Houston | Texas | 48225 | 3450 | 94 |
2131382 | 2131382 | 2022-01-19 | Howard | Texas | 48227 | 5814 | 156 |
2131383 | 2131383 | 2022-01-19 | Hudspeth | Texas | 48229 | 853 | 16 |
2131384 | 2131384 | 2022-01-19 | Hunt | Texas | 48231 | 13799 | 322 |
2131385 | 2131385 | 2022-01-19 | Hutchinson | Texas | 48233 | 5901 | 118 |
2131386 | 2131386 | 2022-01-19 | Irion | Texas | 48235 | 333 | 2 |
2131387 | 2131387 | 2022-01-19 | Jack | Texas | 48237 | 1284 | 23 |
2131388 | 2131388 | 2022-01-19 | Jackson | Texas | 48239 | 3012 | 53 |
2131389 | 2131389 | 2022-01-19 | Jasper | Texas | 48241 | 5372 | 167 |
2131390 | 2131390 | 2022-01-19 | Jeff Davis | Texas | 48243 | 212 | 7 |
2131391 | 2131391 | 2022-01-19 | Jefferson | Texas | 48245 | 37853 | 747 |
2131392 | 2131392 | 2022-01-19 | Jim Hogg | Texas | 48247 | 1609 | 20 |
2131393 | 2131393 | 2022-01-19 | Jim Wells | Texas | 48249 | 9141 | 185 |
2131394 | 2131394 | 2022-01-19 | Johnson | Texas | 48251 | 36976 | 623 |
2131395 | 2131395 | 2022-01-19 | Jones | Texas | 48253 | 4029 | 82 |
2131396 | 2131396 | 2022-01-19 | Karnes | Texas | 48255 | 4690 | 59 |
2131397 | 2131397 | 2022-01-19 | Kaufman | Texas | 48257 | 30579 | 461 |
2131398 | 2131398 | 2022-01-19 | Kendall | Texas | 48259 | 6761 | 104 |
2131399 | 2131399 | 2022-01-19 | Kenedy | Texas | 48261 | 66 | 2 |
2131400 | 2131400 | 2022-01-19 | Kent | Texas | 48263 | 172 | 3 |
2131401 | 2131401 | 2022-01-19 | Kerr | Texas | 48265 | 8312 | 145 |
2131402 | 2131402 | 2022-01-19 | Kimble | Texas | 48267 | 549 | 12 |
2131403 | 2131403 | 2022-01-19 | King | Texas | 48269 | 39 | 0 |
2131404 | 2131404 | 2022-01-19 | Kinney | Texas | 48271 | 643 | 10 |
2131405 | 2131405 | 2022-01-19 | Kleberg | Texas | 48273 | 5623 | 133 |
2131406 | 2131406 | 2022-01-19 | Knox | Texas | 48275 | 426 | 22 |
2131407 | 2131407 | 2022-01-19 | La Salle | Texas | 48283 | 1908 | 41 |
2131408 | 2131408 | 2022-01-19 | Lamar | Texas | 48277 | 11748 | 228 |
2131409 | 2131409 | 2022-01-19 | Lamb | Texas | 48279 | 4005 | 102 |
2131410 | 2131410 | 2022-01-19 | Lampasas | Texas | 48281 | 4707 | 72 |
2131411 | 2131411 | 2022-01-19 | Lavaca | Texas | 48285 | 3806 | 101 |
2131412 | 2131412 | 2022-01-19 | Lee | Texas | 48287 | 3573 | 55 |
2131413 | 2131413 | 2022-01-19 | Leon | Texas | 48289 | 3257 | 75 |
2131414 | 2131414 | 2022-01-19 | Liberty | Texas | 48291 | 15686 | 369 |
2131415 | 2131415 | 2022-01-19 | Limestone | Texas | 48293 | 4479 | 116 |
2131416 | 2131416 | 2022-01-19 | Lipscomb | Texas | 48295 | 577 | 13 |
2131417 | 2131417 | 2022-01-19 | Live Oak | Texas | 48297 | 1884 | 39 |
2131418 | 2131418 | 2022-01-19 | Llano | Texas | 48299 | 3349 | 87 |
2131419 | 2131419 | 2022-01-19 | Loving | Texas | 48301 | 77 | 0 |
2131420 | 2131420 | 2022-01-19 | Lubbock | Texas | 48303 | 86976 | 1149 |
2131421 | 2131421 | 2022-01-19 | Lynn | Texas | 48305 | 1152 | 30 |
2131422 | 2131422 | 2022-01-19 | Madison | Texas | 48313 | 3360 | 49 |
2131423 | 2131423 | 2022-01-19 | Marion | Texas | 48315 | 1430 | 55 |
2131424 | 2131424 | 2022-01-19 | Martin | Texas | 48317 | 1028 | 24 |
2131425 | 2131425 | 2022-01-19 | Mason | Texas | 48319 | 665 | 9 |
2131426 | 2131426 | 2022-01-19 | Matagorda | Texas | 48321 | 7369 | 167 |
2131427 | 2131427 | 2022-01-19 | Maverick | Texas | 48323 | 16661 | 421 |
2131428 | 2131428 | 2022-01-19 | McCulloch | Texas | 48307 | 1118 | 41 |
2131429 | 2131429 | 2022-01-19 | McLennan | Texas | 48309 | 49233 | 791 |
2131430 | 2131430 | 2022-01-19 | McMullen | Texas | 48311 | 143 | 8 |
2131431 | 2131431 | 2022-01-19 | Medina | Texas | 48325 | 8308 | 176 |
2131432 | 2131432 | 2022-01-19 | Menard | Texas | 48327 | 421 | 12 |
2131433 | 2131433 | 2022-01-19 | Midland | Texas | 48329 | 33283 | 430 |
2131434 | 2131434 | 2022-01-19 | Milam | Texas | 48331 | 4250 | 93 |
2131435 | 2131435 | 2022-01-19 | Mills | Texas | 48333 | 1272 | 29 |
2131436 | 2131436 | 2022-01-19 | Mitchell | Texas | 48335 | 1709 | 44 |
2131437 | 2131437 | 2022-01-19 | Montague | Texas | 48337 | 3953 | 105 |
2131438 | 2131438 | 2022-01-19 | Montgomery | Texas | 48339 | 120001 | 1165 |
2131439 | 2131439 | 2022-01-19 | Moore | Texas | 48341 | 4663 | 100 |
2131440 | 2131440 | 2022-01-19 | Morris | Texas | 48343 | 2209 | 58 |
2131441 | 2131441 | 2022-01-19 | Motley | Texas | 48345 | 244 | 9 |
2131442 | 2131442 | 2022-01-19 | Nacogdoches | Texas | 48347 | 10311 | 242 |
2131443 | 2131443 | 2022-01-19 | Navarro | Texas | 48349 | 10838 | 197 |
2131444 | 2131444 | 2022-01-19 | Newton | Texas | 48351 | 1122 | 55 |
2131445 | 2131445 | 2022-01-19 | Nolan | Texas | 48353 | 2665 | 86 |
2131446 | 2131446 | 2022-01-19 | Nueces | Texas | 48355 | 78887 | 1328 |
2131447 | 2131447 | 2022-01-19 | Ochiltree | Texas | 48357 | 1911 | 40 |
2131448 | 2131448 | 2022-01-19 | Oldham | Texas | 48359 | 497 | 6 |
2131449 | 2131449 | 2022-01-19 | Orange | Texas | 48361 | 13699 | 310 |
2131450 | 2131450 | 2022-01-19 | Palo Pinto | Texas | 48363 | 6025 | 133 |
2131451 | 2131451 | 2022-01-19 | Panola | Texas | 48365 | 3824 | 113 |
2131452 | 2131452 | 2022-01-19 | Parker | Texas | 48367 | 29988 | 369 |
2131453 | 2131453 | 2022-01-19 | Parmer | Texas | 48369 | 2013 | 46 |
2131454 | 2131454 | 2022-01-19 | Pecos | Texas | 48371 | 2275 | 60 |
2131455 | 2131455 | 2022-01-19 | Polk | Texas | 48373 | 6870 | 225 |
2131456 | 2131456 | 2022-01-19 | Potter | Texas | 48375 | 31233 | 624 |
2131457 | 2131457 | 2022-01-19 | Presidio | Texas | 48377 | 908 | 32 |
2131458 | 2131458 | 2022-01-19 | Rains | Texas | 48379 | 1600 | 50 |
2131459 | 2131459 | 2022-01-19 | Randall | Texas | 48381 | 32789 | 425 |
2131460 | 2131460 | 2022-01-19 | Reagan | Texas | 48383 | 728 | 11 |
2131461 | 2131461 | 2022-01-19 | Real | Texas | 48385 | 696 | 22 |
2131462 | 2131462 | 2022-01-19 | Red River | Texas | 48387 | 1924 | 59 |
2131463 | 2131463 | 2022-01-19 | Reeves | Texas | 48389 | 4050 | 64 |
2131464 | 2131464 | 2022-01-19 | Refugio | Texas | 48391 | 1521 | 31 |
2131465 | 2131465 | 2022-01-19 | Roberts | Texas | 48393 | 153 | 1 |
2131466 | 2131466 | 2022-01-19 | Robertson | Texas | 48395 | 4095 | 69 |
2131467 | 2131467 | 2022-01-19 | Rockwall | Texas | 48397 | 23131 | 235 |
2131468 | 2131468 | 2022-01-19 | Runnels | Texas | 48399 | 2012 | 57 |
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);