ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
115 rows where cases = 173 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2375366 | 2375366 | 2022-04-04 | Loving | Texas | 48301 | 173 | 1 |
2352640 | 2352640 | 2022-03-28 | Roberts | Texas | 48393 | 173 | 2 |
2349388 | 2349388 | 2022-03-27 | Roberts | Texas | 48393 | 173 | 2 |
2346135 | 2346135 | 2022-03-26 | Roberts | Texas | 48393 | 173 | 2 |
2342882 | 2342882 | 2022-03-25 | Roberts | Texas | 48393 | 173 | 2 |
2339629 | 2339629 | 2022-03-24 | Roberts | Texas | 48393 | 173 | 2 |
2336375 | 2336375 | 2022-03-23 | Roberts | Texas | 48393 | 173 | 2 |
2333121 | 2333121 | 2022-03-22 | Roberts | Texas | 48393 | 173 | 2 |
2329868 | 2329868 | 2022-03-21 | Roberts | Texas | 48393 | 173 | 2 |
2326616 | 2326616 | 2022-03-20 | Roberts | Texas | 48393 | 173 | 2 |
2323363 | 2323363 | 2022-03-19 | Roberts | Texas | 48393 | 173 | 2 |
2320109 | 2320109 | 2022-03-18 | Roberts | Texas | 48393 | 173 | 2 |
2316855 | 2316855 | 2022-03-17 | Roberts | Texas | 48393 | 173 | 2 |
2313602 | 2313602 | 2022-03-16 | Roberts | Texas | 48393 | 173 | 2 |
2310349 | 2310349 | 2022-03-15 | Roberts | Texas | 48393 | 173 | 2 |
2307096 | 2307096 | 2022-03-14 | Roberts | Texas | 48393 | 173 | 2 |
2303845 | 2303845 | 2022-03-13 | Roberts | Texas | 48393 | 173 | 2 |
2300593 | 2300593 | 2022-03-12 | Roberts | Texas | 48393 | 173 | 2 |
2297341 | 2297341 | 2022-03-11 | Roberts | Texas | 48393 | 173 | 2 |
2134652 | 2134652 | 2022-01-20 | Kent | Texas | 48263 | 173 | 3 |
2108727 | 2108727 | 2022-01-12 | Throckmorton | Texas | 48447 | 173 | 7 |
2095585 | 2095585 | 2022-01-08 | Glasscock | Texas | 48173 | 173 | 3 |
2037161 | 2037161 | 2021-12-21 | Motley | Texas | 48345 | 173 | 9 |
2033911 | 2033911 | 2021-12-20 | Motley | Texas | 48345 | 173 | 9 |
2030661 | 2030661 | 2021-12-19 | Motley | Texas | 48345 | 173 | 9 |
2027410 | 2027410 | 2021-12-18 | Motley | Texas | 48345 | 173 | 9 |
2024159 | 2024159 | 2021-12-17 | Motley | Texas | 48345 | 173 | 9 |
2020908 | 2020908 | 2021-12-16 | Motley | Texas | 48345 | 173 | 9 |
2017657 | 2017657 | 2021-12-15 | Motley | Texas | 48345 | 173 | 9 |
2014407 | 2014407 | 2021-12-14 | Motley | Texas | 48345 | 173 | 9 |
2011156 | 2011156 | 2021-12-13 | Motley | Texas | 48345 | 173 | 9 |
2007905 | 2007905 | 2021-12-12 | Motley | Texas | 48345 | 173 | 9 |
2004654 | 2004654 | 2021-12-11 | Motley | Texas | 48345 | 173 | 9 |
2001403 | 2001403 | 2021-12-10 | Motley | Texas | 48345 | 173 | 9 |
1728340 | 1728340 | 2021-09-17 | Foard | Texas | 48155 | 173 | 10 |
1725091 | 1725091 | 2021-09-16 | Foard | Texas | 48155 | 173 | 10 |
1725131 | 1725131 | 2021-09-16 | Irion | Texas | 48235 | 173 | 2 |
1721842 | 1721842 | 2021-09-15 | Foard | Texas | 48155 | 173 | 10 |
1721882 | 1721882 | 2021-09-15 | Irion | Texas | 48235 | 173 | 2 |
1062740 | 1062740 | 2021-02-24 | Jeff Davis | Texas | 48243 | 173 | 2 |
1059495 | 1059495 | 2021-02-23 | Jeff Davis | Texas | 48243 | 173 | 2 |
919951 | 919951 | 2021-01-11 | Knox | Texas | 48275 | 173 | 12 |
916629 | 916629 | 2021-01-10 | Delta | Texas | 48119 | 173 | 4 |
916706 | 916706 | 2021-01-10 | Knox | Texas | 48275 | 173 | 12 |
913461 | 913461 | 2021-01-09 | Knox | Texas | 48275 | 173 | 12 |
903723 | 903723 | 2021-01-06 | Kinney | Texas | 48271 | 173 | 3 |
835505 | 835505 | 2020-12-16 | Edwards | Texas | 48137 | 173 | 2 |
816106 | 816106 | 2020-12-10 | Lipscomb | Texas | 48295 | 173 | 5 |
812860 | 812860 | 2020-12-09 | Lipscomb | Texas | 48295 | 173 | 4 |
806299 | 806299 | 2020-12-07 | Fisher | Texas | 48151 | 173 | 5 |
803054 | 803054 | 2020-12-06 | Fisher | Texas | 48151 | 173 | 4 |
799809 | 799809 | 2020-12-05 | Fisher | Texas | 48151 | 173 | 4 |
760834 | 760834 | 2020-11-23 | Coleman | Texas | 48083 | 173 | 5 |
757589 | 757589 | 2020-11-22 | Coleman | Texas | 48083 | 173 | 5 |
754342 | 754342 | 2020-11-21 | Coleman | Texas | 48083 | 173 | 5 |
748026 | 748026 | 2020-11-19 | Sutton | Texas | 48435 | 173 | 3 |
734902 | 734902 | 2020-11-15 | Floyd | Texas | 48153 | 173 | 10 |
735066 | 735066 | 2020-11-15 | Wheeler | Texas | 48483 | 173 | 2 |
731656 | 731656 | 2020-11-14 | Floyd | Texas | 48153 | 173 | 10 |
731820 | 731820 | 2020-11-14 | Wheeler | Texas | 48483 | 173 | 1 |
715576 | 715576 | 2020-11-09 | Stephens | Texas | 48429 | 173 | 5 |
712332 | 712332 | 2020-11-08 | Stephens | Texas | 48429 | 173 | 5 |
709088 | 709088 | 2020-11-07 | Stephens | Texas | 48429 | 173 | 5 |
705844 | 705844 | 2020-11-06 | Stephens | Texas | 48429 | 173 | 5 |
692812 | 692812 | 2020-11-02 | Marion | Texas | 48315 | 173 | 14 |
689568 | 689568 | 2020-11-01 | Marion | Texas | 48315 | 173 | 14 |
683029 | 683029 | 2020-10-30 | Hartley | Texas | 48205 | 173 | 2 |
624720 | 624720 | 2020-10-12 | Red River | Texas | 48387 | 173 | 14 |
569584 | 569584 | 2020-09-25 | Montague | Texas | 48337 | 173 | 4 |
566343 | 566343 | 2020-09-24 | Montague | Texas | 48337 | 173 | 4 |
524261 | 524261 | 2020-09-11 | Morris | Texas | 48343 | 173 | 3 |
521104 | 521104 | 2020-09-10 | Yoakum | Texas | 48501 | 173 | 4 |
517868 | 517868 | 2020-09-09 | Yoakum | Texas | 48501 | 173 | 4 |
514633 | 514633 | 2020-09-08 | Yoakum | Texas | 48501 | 173 | 4 |
511400 | 511400 | 2020-09-07 | Yoakum | Texas | 48501 | 173 | 4 |
508167 | 508167 | 2020-09-06 | Yoakum | Texas | 48501 | 173 | 4 |
504935 | 504935 | 2020-09-05 | Yoakum | Texas | 48501 | 173 | 4 |
501525 | 501525 | 2020-09-04 | Falls | Texas | 48145 | 173 | 3 |
491944 | 491944 | 2020-09-01 | Reeves | Texas | 48389 | 173 | 5 |
475809 | 475809 | 2020-08-27 | Trinity | Texas | 48455 | 173 | 5 |
472494 | 472494 | 2020-08-26 | Leon | Texas | 48289 | 173 | 4 |
472576 | 472576 | 2020-08-26 | Trinity | Texas | 48455 | 173 | 5 |
446741 | 446741 | 2020-08-18 | Terry | Texas | 48445 | 173 | 2 |
443514 | 443514 | 2020-08-17 | Terry | Texas | 48445 | 173 | 2 |
440288 | 440288 | 2020-08-16 | Terry | Texas | 48445 | 173 | 2 |
437062 | 437062 | 2020-08-15 | Terry | Texas | 48445 | 173 | 2 |
420832 | 420832 | 2020-08-10 | Howard | Texas | 48227 | 173 | 6 |
420861 | 420861 | 2020-08-10 | Lee | Texas | 48287 | 173 | 10 |
417502 | 417502 | 2020-08-09 | Aransas | Texas | 48007 | 173 | 15 |
417640 | 417640 | 2020-08-09 | Lee | Texas | 48287 | 173 | 10 |
414342 | 414342 | 2020-08-08 | Duval | Texas | 48131 | 173 | 6 |
382155 | 382155 | 2020-07-29 | Dallam | Texas | 48111 | 173 | 5 |
378938 | 378938 | 2020-07-28 | Dallam | Texas | 48111 | 173 | 5 |
375722 | 375722 | 2020-07-27 | Dallam | Texas | 48111 | 173 | 5 |
372509 | 372509 | 2020-07-26 | Dallam | Texas | 48111 | 173 | 2 |
369297 | 369297 | 2020-07-25 | Dallam | Texas | 48111 | 173 | 2 |
366088 | 366088 | 2020-07-24 | Dallam | Texas | 48111 | 173 | 2 |
337228 | 337228 | 2020-07-15 | Bee | Texas | 48025 | 173 | 0 |
321517 | 321517 | 2020-07-10 | Wilson | Texas | 48493 | 173 | 5 |
277109 | 277109 | 2020-06-26 | Frio | Texas | 48163 | 173 | 0 |
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);