ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
77 rows where cases = 383 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2144348 | 2144348 | 2022-01-23 | Dickens | Texas | 48125 | 383 | 15 |
2098914 | 2098914 | 2022-01-09 | Menard | Texas | 48327 | 383 | 12 |
1796549 | 1796549 | 2021-10-08 | Culberson | Texas | 48109 | 383 | 11 |
1786792 | 1786792 | 2021-10-05 | Collingsworth | Texas | 48087 | 383 | 9 |
1783543 | 1783543 | 2021-10-04 | Collingsworth | Texas | 48087 | 383 | 9 |
1780294 | 1780294 | 2021-10-03 | Collingsworth | Texas | 48087 | 383 | 9 |
1777044 | 1777044 | 2021-10-02 | Collingsworth | Texas | 48087 | 383 | 9 |
1764211 | 1764211 | 2021-09-28 | Shackelford | Texas | 48417 | 383 | 5 |
1598390 | 1598390 | 2021-08-08 | Delta | Texas | 48119 | 383 | 14 |
1595141 | 1595141 | 2021-08-07 | Delta | Texas | 48119 | 383 | 14 |
1546588 | 1546588 | 2021-07-23 | Upton | Texas | 48461 | 383 | 10 |
1413451 | 1413451 | 2021-06-12 | Reagan | Texas | 48383 | 383 | 8 |
1410206 | 1410206 | 2021-06-11 | Reagan | Texas | 48383 | 383 | 8 |
1397132 | 1397132 | 2021-06-07 | Hardeman | Texas | 48197 | 383 | 12 |
1393885 | 1393885 | 2021-06-06 | Hardeman | Texas | 48197 | 383 | 12 |
1390640 | 1390640 | 2021-06-05 | Hardeman | Texas | 48197 | 383 | 12 |
1387395 | 1387395 | 2021-06-04 | Hardeman | Texas | 48197 | 383 | 12 |
1384150 | 1384150 | 2021-06-03 | Hardeman | Texas | 48197 | 383 | 12 |
1380904 | 1380904 | 2021-06-02 | Hardeman | Texas | 48197 | 383 | 12 |
1377659 | 1377659 | 2021-06-01 | Hardeman | Texas | 48197 | 383 | 12 |
1374413 | 1374413 | 2021-05-31 | Hardeman | Texas | 48197 | 383 | 12 |
1371168 | 1371168 | 2021-05-30 | Hardeman | Texas | 48197 | 383 | 12 |
1367922 | 1367922 | 2021-05-29 | Hardeman | Texas | 48197 | 383 | 12 |
1364676 | 1364676 | 2021-05-28 | Hardeman | Texas | 48197 | 383 | 12 |
1361430 | 1361430 | 2021-05-27 | Hardeman | Texas | 48197 | 383 | 12 |
1358184 | 1358184 | 2021-05-26 | Hardeman | Texas | 48197 | 383 | 12 |
1358277 | 1358277 | 2021-05-26 | Reagan | Texas | 48383 | 383 | 8 |
1354938 | 1354938 | 2021-05-25 | Hardeman | Texas | 48197 | 383 | 12 |
1355031 | 1355031 | 2021-05-25 | Reagan | Texas | 48383 | 383 | 8 |
1351692 | 1351692 | 2021-05-24 | Hardeman | Texas | 48197 | 383 | 12 |
1351785 | 1351785 | 2021-05-24 | Reagan | Texas | 48383 | 383 | 8 |
1348446 | 1348446 | 2021-05-23 | Hardeman | Texas | 48197 | 383 | 12 |
1348539 | 1348539 | 2021-05-23 | Reagan | Texas | 48383 | 383 | 8 |
1345198 | 1345198 | 2021-05-22 | Hardeman | Texas | 48197 | 383 | 12 |
1341950 | 1341950 | 2021-05-21 | Hardeman | Texas | 48197 | 383 | 12 |
1338702 | 1338702 | 2021-05-20 | Hardeman | Texas | 48197 | 383 | 12 |
1335455 | 1335455 | 2021-05-19 | Hardeman | Texas | 48197 | 383 | 12 |
1332208 | 1332208 | 2021-05-18 | Hardeman | Texas | 48197 | 383 | 12 |
1319316 | 1319316 | 2021-05-14 | Reagan | Texas | 48383 | 383 | 8 |
1315924 | 1315924 | 2021-05-13 | Concho | Texas | 48095 | 383 | 8 |
1316068 | 1316068 | 2021-05-13 | Reagan | Texas | 48383 | 383 | 8 |
1312678 | 1312678 | 2021-05-12 | Concho | Texas | 48095 | 383 | 8 |
1312822 | 1312822 | 2021-05-12 | Reagan | Texas | 48383 | 383 | 8 |
1309431 | 1309431 | 2021-05-11 | Concho | Texas | 48095 | 383 | 8 |
1072511 | 1072511 | 2021-02-27 | Mason | Texas | 48319 | 383 | 5 |
991316 | 991316 | 2021-02-02 | Hartley | Texas | 48205 | 383 | 2 |
952371 | 952371 | 2021-01-21 | Haskell | Texas | 48207 | 383 | 17 |
945830 | 945830 | 2021-01-19 | Crosby | Texas | 48107 | 383 | 22 |
861616 | 861616 | 2020-12-24 | Sutton | Texas | 48435 | 383 | 6 |
845288 | 845288 | 2020-12-19 | Hudspeth | Texas | 48229 | 383 | 7 |
718857 | 718857 | 2020-11-10 | Zapata | Texas | 48505 | 383 | 9 |
702526 | 702526 | 2020-11-05 | La Salle | Texas | 48283 | 383 | 14 |
699191 | 699191 | 2020-11-04 | Comanche | Texas | 48093 | 383 | 5 |
683075 | 683075 | 2020-10-30 | Live Oak | Texas | 48297 | 383 | 10 |
679832 | 679832 | 2020-10-29 | Live Oak | Texas | 48297 | 383 | 10 |
676589 | 676589 | 2020-10-28 | Live Oak | Texas | 48297 | 383 | 10 |
673346 | 673346 | 2020-10-27 | Live Oak | Texas | 48297 | 383 | 10 |
660399 | 660399 | 2020-10-23 | Nolan | Texas | 48353 | 383 | 5 |
644031 | 644031 | 2020-10-18 | Camp | Texas | 48063 | 383 | 13 |
640783 | 640783 | 2020-10-17 | Camp | Texas | 48063 | 383 | 13 |
634349 | 634349 | 2020-10-15 | Gray | Texas | 48179 | 383 | 9 |
605184 | 605184 | 2020-10-06 | Hockley | Texas | 48219 | 383 | 9 |
588898 | 588898 | 2020-10-01 | Cass | Texas | 48067 | 383 | 16 |
588976 | 588976 | 2020-10-01 | Hopkins | Texas | 48223 | 383 | 11 |
589048 | 589048 | 2020-10-01 | Pecos | Texas | 48371 | 383 | 5 |
563163 | 563163 | 2020-09-23 | Upshur | Texas | 48459 | 383 | 10 |
498327 | 498327 | 2020-09-03 | Hill | Texas | 48217 | 383 | 11 |
478999 | 478999 | 2020-08-28 | Parmer | Texas | 48369 | 383 | 7 |
407957 | 407957 | 2020-08-06 | Jackson | Texas | 48239 | 383 | 5 |
401607 | 401607 | 2020-08-04 | Shelby | Texas | 48419 | 383 | 17 |
366238 | 366238 | 2020-07-24 | Scurry | Texas | 48415 | 383 | 1 |
314985 | 314985 | 2020-07-08 | Deaf Smith | Texas | 48117 | 383 | 17 |
311852 | 311852 | 2020-07-07 | Harrison | Texas | 48203 | 383 | 30 |
299114 | 299114 | 2020-07-03 | Caldwell | Texas | 48055 | 383 | 2 |
168802 | 168802 | 2020-05-22 | Brazos | Texas | 48041 | 383 | 18 |
32842 | 32842 | 2020-04-04 | Tarrant | Texas | 48439 | 383 | 9 |
30446 | 30446 | 2020-04-03 | Tarrant | Texas | 48439 | 383 | 7 |
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);