ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
64 rows where cases = 574 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2173644 | 2173644 | 2022-02-01 | Fisher | Texas | 48151 | 574 | 20 |
2128162 | 2128162 | 2022-01-18 | Lipscomb | Texas | 48295 | 574 | 13 |
1903733 | 1903733 | 2021-11-10 | Baylor | Texas | 48023 | 574 | 24 |
1900483 | 1900483 | 2021-11-09 | Baylor | Texas | 48023 | 574 | 24 |
1835548 | 1835548 | 2021-10-20 | Donley | Texas | 48129 | 574 | 18 |
1799935 | 1799935 | 2021-10-09 | Reagan | Texas | 48383 | 574 | 10 |
1731627 | 1731627 | 2021-09-18 | Hudspeth | Texas | 48229 | 574 | 13 |
1660265 | 1660265 | 2021-08-27 | Sutton | Texas | 48435 | 574 | 8 |
1533609 | 1533609 | 2021-07-19 | Wheeler | Texas | 48483 | 574 | 11 |
1530362 | 1530362 | 2021-07-18 | Wheeler | Texas | 48483 | 574 | 11 |
1527115 | 1527115 | 2021-07-17 | Wheeler | Texas | 48483 | 574 | 11 |
1523868 | 1523868 | 2021-07-16 | Wheeler | Texas | 48483 | 574 | 11 |
1520620 | 1520620 | 2021-07-15 | Wheeler | Texas | 48483 | 574 | 11 |
1517372 | 1517372 | 2021-07-14 | Wheeler | Texas | 48483 | 574 | 11 |
1497894 | 1497894 | 2021-07-08 | Wheeler | Texas | 48483 | 574 | 11 |
1494647 | 1494647 | 2021-07-07 | Wheeler | Texas | 48483 | 574 | 12 |
1491400 | 1491400 | 2021-07-06 | Wheeler | Texas | 48483 | 574 | 12 |
1322530 | 1322530 | 2021-05-15 | McCulloch | Texas | 48307 | 574 | 19 |
1319284 | 1319284 | 2021-05-14 | McCulloch | Texas | 48307 | 574 | 19 |
1312683 | 1312683 | 2021-05-12 | Crockett | Texas | 48105 | 574 | 15 |
1309436 | 1309436 | 2021-05-11 | Crockett | Texas | 48105 | 574 | 15 |
1306190 | 1306190 | 2021-05-10 | Crockett | Texas | 48105 | 574 | 15 |
1302944 | 1302944 | 2021-05-09 | Crockett | Texas | 48105 | 574 | 15 |
1290065 | 1290065 | 2021-05-05 | McCulloch | Texas | 48307 | 574 | 19 |
1280326 | 1280326 | 2021-05-02 | McCulloch | Texas | 48307 | 574 | 19 |
1263984 | 1263984 | 2021-04-27 | Crockett | Texas | 48105 | 574 | 15 |
1260737 | 1260737 | 2021-04-26 | Crockett | Texas | 48105 | 574 | 15 |
1257490 | 1257490 | 2021-04-25 | Crockett | Texas | 48105 | 574 | 15 |
1254243 | 1254243 | 2021-04-24 | Crockett | Texas | 48105 | 574 | 15 |
1250996 | 1250996 | 2021-04-23 | Crockett | Texas | 48105 | 574 | 15 |
1231513 | 1231513 | 2021-04-17 | Crockett | Texas | 48105 | 574 | 15 |
1228265 | 1228265 | 2021-04-16 | Crockett | Texas | 48105 | 574 | 15 |
1225017 | 1225017 | 2021-04-15 | Crockett | Texas | 48105 | 574 | 15 |
1189287 | 1189287 | 2021-04-04 | Crockett | Texas | 48105 | 574 | 15 |
1186040 | 1186040 | 2021-04-03 | Crockett | Texas | 48105 | 574 | 15 |
1182793 | 1182793 | 2021-04-02 | Crockett | Texas | 48105 | 574 | 15 |
1176299 | 1176299 | 2021-03-31 | Crockett | Texas | 48105 | 574 | 15 |
1140578 | 1140578 | 2021-03-20 | Crockett | Texas | 48105 | 574 | 15 |
1130838 | 1130838 | 2021-03-17 | Crockett | Texas | 48105 | 574 | 15 |
1108236 | 1108236 | 2021-03-10 | Newton | Texas | 48351 | 574 | 32 |
1104990 | 1104990 | 2021-03-09 | Newton | Texas | 48351 | 574 | 32 |
997872 | 997872 | 2021-02-04 | Mills | Texas | 48333 | 574 | 19 |
984876 | 984876 | 2021-01-31 | Martin | Texas | 48317 | 574 | 18 |
975178 | 975178 | 2021-01-28 | Refugio | Texas | 48391 | 574 | 17 |
965404 | 965404 | 2021-01-25 | Martin | Texas | 48317 | 574 | 18 |
962159 | 962159 | 2021-01-24 | Martin | Texas | 48317 | 574 | 18 |
907081 | 907081 | 2021-01-07 | Winkler | Texas | 48495 | 574 | 15 |
777131 | 777131 | 2020-11-28 | Houston | Texas | 48225 | 574 | 15 |
757592 | 757592 | 2020-11-22 | Colorado | Texas | 48089 | 574 | 4 |
748059 | 748059 | 2020-11-19 | Yoakum | Texas | 48501 | 574 | 10 |
692799 | 692799 | 2020-11-02 | Lamb | Texas | 48279 | 574 | 24 |
689555 | 689555 | 2020-11-01 | Lamb | Texas | 48279 | 574 | 24 |
686310 | 686310 | 2020-10-31 | Lamb | Texas | 48279 | 574 | 24 |
683110 | 683110 | 2020-10-30 | Parmer | Texas | 48369 | 574 | 19 |
634386 | 634386 | 2020-10-15 | Jones | Texas | 48253 | 574 | 1 |
534005 | 534005 | 2020-09-14 | Scurry | Texas | 48415 | 574 | 2 |
530770 | 530770 | 2020-09-13 | Scurry | Texas | 48415 | 574 | 2 |
527533 | 527533 | 2020-09-12 | Scurry | Texas | 48415 | 574 | 2 |
436868 | 436868 | 2020-08-15 | Burnet | Texas | 48053 | 574 | 11 |
433687 | 433687 | 2020-08-14 | Erath | Texas | 48143 | 574 | 7 |
375768 | 375768 | 2020-07-27 | Harrison | Texas | 48203 | 574 | 23 |
233335 | 233335 | 2020-06-12 | Bell | Texas | 48027 | 574 | 6 |
230318 | 230318 | 2020-06-11 | Hays | Texas | 48209 | 574 | 5 |
211870 | 211870 | 2020-06-05 | Webb | Texas | 48479 | 574 | 19 |
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);