ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
99 rows where cases = 153 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2170478 | 2170478 | 2022-01-31 | McMullen | Texas | 48311 | 153 | 8 |
2147736 | 2147736 | 2022-01-24 | Roberts | Texas | 48393 | 153 | 1 |
2144482 | 2144482 | 2022-01-23 | Roberts | Texas | 48393 | 153 | 1 |
2141227 | 2141227 | 2022-01-22 | Roberts | Texas | 48393 | 153 | 1 |
2137971 | 2137971 | 2022-01-21 | Roberts | Texas | 48393 | 153 | 1 |
2134717 | 2134717 | 2022-01-20 | Roberts | Texas | 48393 | 153 | 1 |
2131465 | 2131465 | 2022-01-19 | Roberts | Texas | 48393 | 153 | 1 |
1842068 | 1842068 | 2021-10-22 | Glasscock | Texas | 48173 | 153 | 3 |
1838819 | 1838819 | 2021-10-21 | Glasscock | Texas | 48173 | 153 | 3 |
1835570 | 1835570 | 2021-10-20 | Glasscock | Texas | 48173 | 153 | 3 |
1832321 | 1832321 | 2021-10-19 | Glasscock | Texas | 48173 | 153 | 3 |
1829158 | 1829158 | 2021-10-18 | Motley | Texas | 48345 | 153 | 9 |
1825909 | 1825909 | 2021-10-17 | Motley | Texas | 48345 | 153 | 9 |
1822660 | 1822660 | 2021-10-16 | Motley | Texas | 48345 | 153 | 9 |
1819411 | 1819411 | 2021-10-15 | Motley | Texas | 48345 | 153 | 9 |
1150272 | 1150272 | 2021-03-23 | Armstrong | Texas | 48011 | 153 | 6 |
1101785 | 1101785 | 2021-03-08 | Stonewall | Texas | 48433 | 153 | 6 |
1098539 | 1098539 | 2021-03-07 | Stonewall | Texas | 48433 | 153 | 6 |
1095291 | 1095291 | 2021-03-06 | Stonewall | Texas | 48433 | 153 | 6 |
1092045 | 1092045 | 2021-03-05 | Stonewall | Texas | 48433 | 153 | 6 |
1088799 | 1088799 | 2021-03-04 | Stonewall | Texas | 48433 | 153 | 6 |
1085554 | 1085554 | 2021-03-03 | Stonewall | Texas | 48433 | 153 | 6 |
1082308 | 1082308 | 2021-03-02 | Stonewall | Texas | 48433 | 153 | 6 |
1079062 | 1079062 | 2021-03-01 | Stonewall | Texas | 48433 | 153 | 6 |
1075817 | 1075817 | 2021-02-28 | Stonewall | Texas | 48433 | 153 | 6 |
1072571 | 1072571 | 2021-02-27 | Stonewall | Texas | 48433 | 153 | 6 |
1069325 | 1069325 | 2021-02-26 | Stonewall | Texas | 48433 | 153 | 6 |
832202 | 832202 | 2020-12-15 | Baylor | Texas | 48023 | 153 | 5 |
819397 | 819397 | 2020-12-11 | Real | Texas | 48385 | 153 | 10 |
816054 | 816054 | 2020-12-10 | Hall | Texas | 48191 | 153 | 3 |
812808 | 812808 | 2020-12-09 | Hall | Texas | 48191 | 153 | 3 |
790165 | 790165 | 2020-12-02 | Mills | Texas | 48333 | 153 | 4 |
773813 | 773813 | 2020-11-27 | Cochran | Texas | 48079 | 153 | 5 |
770568 | 770568 | 2020-11-26 | Cochran | Texas | 48079 | 153 | 5 |
741356 | 741356 | 2020-11-17 | Coke | Texas | 48081 | 153 | 8 |
715392 | 715392 | 2020-11-09 | Callahan | Texas | 48059 | 153 | 6 |
712148 | 712148 | 2020-11-08 | Callahan | Texas | 48059 | 153 | 6 |
708904 | 708904 | 2020-11-07 | Callahan | Texas | 48059 | 153 | 6 |
705660 | 705660 | 2020-11-06 | Callahan | Texas | 48059 | 153 | 6 |
696147 | 696147 | 2020-11-03 | Winkler | Texas | 48495 | 153 | 5 |
692905 | 692905 | 2020-11-02 | Winkler | Texas | 48495 | 153 | 5 |
689661 | 689661 | 2020-11-01 | Winkler | Texas | 48495 | 153 | 5 |
686416 | 686416 | 2020-10-31 | Winkler | Texas | 48495 | 153 | 5 |
683045 | 683045 | 2020-10-30 | Jack | Texas | 48237 | 153 | 3 |
679802 | 679802 | 2020-10-29 | Jack | Texas | 48237 | 153 | 3 |
676559 | 676559 | 2020-10-28 | Jack | Texas | 48237 | 153 | 3 |
670144 | 670144 | 2020-10-26 | Rains | Texas | 48379 | 153 | 5 |
656995 | 656995 | 2020-10-22 | Blanco | Texas | 48031 | 153 | 6 |
653750 | 653750 | 2020-10-21 | Blanco | Texas | 48031 | 153 | 6 |
650505 | 650505 | 2020-10-20 | Blanco | Texas | 48031 | 153 | 6 |
647261 | 647261 | 2020-10-19 | Blanco | Texas | 48031 | 153 | 6 |
644015 | 644015 | 2020-10-18 | Blanco | Texas | 48031 | 153 | 6 |
640767 | 640767 | 2020-10-17 | Blanco | Texas | 48031 | 153 | 6 |
637520 | 637520 | 2020-10-16 | Blanco | Texas | 48031 | 153 | 6 |
637716 | 637716 | 2020-10-16 | Somervell | Texas | 48425 | 153 | 5 |
634275 | 634275 | 2020-10-15 | Blanco | Texas | 48031 | 153 | 6 |
627920 | 627920 | 2020-10-13 | Llano | Texas | 48299 | 153 | 2 |
601985 | 601985 | 2020-10-05 | Marion | Texas | 48315 | 153 | 14 |
559707 | 559707 | 2020-09-22 | Bandera | Texas | 48019 | 153 | 7 |
556471 | 556471 | 2020-09-21 | Bandera | Texas | 48019 | 153 | 7 |
514501 | 514501 | 2020-09-08 | Hutchinson | Texas | 48233 | 153 | 3 |
511268 | 511268 | 2020-09-07 | Hutchinson | Texas | 48233 | 153 | 3 |
508035 | 508035 | 2020-09-06 | Hutchinson | Texas | 48233 | 153 | 3 |
504803 | 504803 | 2020-09-05 | Hutchinson | Texas | 48233 | 153 | 3 |
491926 | 491926 | 2020-09-01 | Nolan | Texas | 48353 | 153 | 4 |
482191 | 482191 | 2020-08-29 | Lampasas | Texas | 48281 | 153 | 6 |
404842 | 404842 | 2020-08-05 | Trinity | Texas | 48455 | 153 | 3 |
398217 | 398217 | 2020-08-03 | Cass | Texas | 48067 | 153 | 7 |
398326 | 398326 | 2020-08-03 | Lee | Texas | 48287 | 153 | 8 |
395001 | 395001 | 2020-08-02 | Cass | Texas | 48067 | 153 | 7 |
395020 | 395020 | 2020-08-02 | Crockett | Texas | 48105 | 153 | 3 |
395110 | 395110 | 2020-08-02 | Lee | Texas | 48287 | 153 | 8 |
391756 | 391756 | 2020-08-01 | Aransas | Texas | 48007 | 153 | 12 |
391785 | 391785 | 2020-08-01 | Cass | Texas | 48067 | 153 | 7 |
391804 | 391804 | 2020-08-01 | Crockett | Texas | 48105 | 153 | 3 |
388539 | 388539 | 2020-07-31 | Aransas | Texas | 48007 | 153 | 12 |
388587 | 388587 | 2020-07-31 | Crockett | Texas | 48105 | 153 | 2 |
385518 | 385518 | 2020-07-30 | San Augustine | Texas | 48405 | 153 | 12 |
385567 | 385567 | 2020-07-30 | Zapata | Texas | 48505 | 153 | 1 |
382300 | 382300 | 2020-07-29 | San Augustine | Texas | 48405 | 153 | 12 |
379083 | 379083 | 2020-07-28 | San Augustine | Texas | 48405 | 153 | 12 |
356463 | 356463 | 2020-07-21 | Cooke | Texas | 48097 | 153 | 0 |
353339 | 353339 | 2020-07-20 | Karnes | Texas | 48255 | 153 | 0 |
350137 | 350137 | 2020-07-19 | Karnes | Texas | 48255 | 153 | 0 |
340484 | 340484 | 2020-07-16 | Fannin | Texas | 48147 | 153 | 8 |
340594 | 340594 | 2020-07-16 | Pecos | Texas | 48371 | 153 | 1 |
334041 | 334041 | 2020-07-14 | Brewster | Texas | 48043 | 153 | 1 |
324486 | 324486 | 2020-07-11 | Calhoun | Texas | 48057 | 153 | 3 |
267719 | 267719 | 2020-06-23 | Houston | Texas | 48225 | 153 | 0 |
233473 | 233473 | 2020-06-12 | McLennan | Texas | 48309 | 153 | 4 |
230326 | 230326 | 2020-06-11 | Houston | Texas | 48225 | 153 | 0 |
227222 | 227222 | 2020-06-10 | Houston | Texas | 48225 | 153 | 0 |
224098 | 224098 | 2020-06-09 | Gonzales | Texas | 48177 | 153 | 3 |
177926 | 177926 | 2020-05-25 | Bowie | Texas | 48037 | 153 | 11 |
174882 | 174882 | 2020-05-24 | Bowie | Texas | 48037 | 153 | 11 |
123898 | 123898 | 2020-05-07 | Washington | Texas | 48477 | 153 | 18 |
83514 | 83514 | 2020-04-23 | Bell | Texas | 48027 | 153 | 3 |
42758 | 42758 | 2020-04-08 | El Paso | Texas | 48141 | 153 | 0 |
40193 | 40193 | 2020-04-07 | El Paso | Texas | 48141 | 153 | 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);