ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
297 rows where cases = 27 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2076123 | 2076123 | 2022-01-02 | King | Texas | 48269 | 27 | 0 |
2072872 | 2072872 | 2022-01-01 | King | Texas | 48269 | 27 | 0 |
2069621 | 2069621 | 2021-12-31 | King | Texas | 48269 | 27 | 0 |
2066370 | 2066370 | 2021-12-30 | King | Texas | 48269 | 27 | 0 |
2063120 | 2063120 | 2021-12-29 | King | Texas | 48269 | 27 | 0 |
2059870 | 2059870 | 2021-12-28 | King | Texas | 48269 | 27 | 0 |
2056621 | 2056621 | 2021-12-27 | King | Texas | 48269 | 27 | 0 |
2053372 | 2053372 | 2021-12-26 | King | Texas | 48269 | 27 | 0 |
2050122 | 2050122 | 2021-12-25 | King | Texas | 48269 | 27 | 0 |
2046872 | 2046872 | 2021-12-24 | King | Texas | 48269 | 27 | 0 |
2043622 | 2043622 | 2021-12-23 | King | Texas | 48269 | 27 | 0 |
910209 | 910209 | 2021-01-08 | Kenedy | Texas | 48261 | 27 | 2 |
816131 | 816131 | 2020-12-10 | Motley | Texas | 48345 | 27 | 2 |
812885 | 812885 | 2020-12-09 | Motley | Texas | 48345 | 27 | 2 |
803200 | 803200 | 2020-12-06 | Terrell | Texas | 48443 | 27 | 1 |
773935 | 773935 | 2020-11-27 | McMullen | Texas | 48311 | 27 | 1 |
773970 | 773970 | 2020-11-27 | Roberts | Texas | 48393 | 27 | 1 |
770690 | 770690 | 2020-11-26 | McMullen | Texas | 48311 | 27 | 1 |
770725 | 770725 | 2020-11-26 | Roberts | Texas | 48393 | 27 | 1 |
767360 | 767360 | 2020-11-25 | Foard | Texas | 48155 | 27 | 1 |
767444 | 767444 | 2020-11-25 | McMullen | Texas | 48311 | 27 | 1 |
764199 | 764199 | 2020-11-24 | McMullen | Texas | 48311 | 27 | 1 |
760954 | 760954 | 2020-11-23 | McMullen | Texas | 48311 | 27 | 1 |
757709 | 757709 | 2020-11-22 | McMullen | Texas | 48311 | 27 | 1 |
754462 | 754462 | 2020-11-21 | McMullen | Texas | 48311 | 27 | 1 |
751216 | 751216 | 2020-11-20 | McMullen | Texas | 48311 | 27 | 1 |
741531 | 741531 | 2020-11-17 | Sterling | Texas | 48431 | 27 | 1 |
692664 | 692664 | 2020-11-02 | Armstrong | Texas | 48011 | 27 | 1 |
692837 | 692837 | 2020-11-02 | Oldham | Texas | 48359 | 27 | 2 |
689420 | 689420 | 2020-11-01 | Armstrong | Texas | 48011 | 27 | 1 |
689593 | 689593 | 2020-11-01 | Oldham | Texas | 48359 | 27 | 2 |
686175 | 686175 | 2020-10-31 | Armstrong | Texas | 48011 | 27 | 1 |
686348 | 686348 | 2020-10-31 | Oldham | Texas | 48359 | 27 | 2 |
682932 | 682932 | 2020-10-30 | Armstrong | Texas | 48011 | 27 | 1 |
683105 | 683105 | 2020-10-30 | Oldham | Texas | 48359 | 27 | 2 |
683156 | 683156 | 2020-10-30 | Upton | Texas | 48461 | 27 | 3 |
679689 | 679689 | 2020-10-29 | Armstrong | Texas | 48011 | 27 | 1 |
679817 | 679817 | 2020-10-29 | Kimble | Texas | 48267 | 27 | 2 |
679862 | 679862 | 2020-10-29 | Oldham | Texas | 48359 | 27 | 2 |
679913 | 679913 | 2020-10-29 | Upton | Texas | 48461 | 27 | 3 |
676446 | 676446 | 2020-10-28 | Armstrong | Texas | 48011 | 27 | 1 |
676619 | 676619 | 2020-10-28 | Oldham | Texas | 48359 | 27 | 2 |
676670 | 676670 | 2020-10-28 | Upton | Texas | 48461 | 27 | 3 |
673203 | 673203 | 2020-10-27 | Armstrong | Texas | 48011 | 27 | 1 |
673376 | 673376 | 2020-10-27 | Oldham | Texas | 48359 | 27 | 2 |
673427 | 673427 | 2020-10-27 | Upton | Texas | 48461 | 27 | 3 |
670134 | 670134 | 2020-10-26 | Oldham | Texas | 48359 | 27 | 2 |
670185 | 670185 | 2020-10-26 | Upton | Texas | 48461 | 27 | 3 |
666891 | 666891 | 2020-10-25 | Oldham | Texas | 48359 | 27 | 2 |
666942 | 666942 | 2020-10-25 | Upton | Texas | 48461 | 27 | 3 |
663646 | 663646 | 2020-10-24 | Oldham | Texas | 48359 | 27 | 2 |
663697 | 663697 | 2020-10-24 | Upton | Texas | 48461 | 27 | 3 |
660402 | 660402 | 2020-10-23 | Oldham | Texas | 48359 | 27 | 2 |
660453 | 660453 | 2020-10-23 | Upton | Texas | 48461 | 27 | 3 |
657158 | 657158 | 2020-10-22 | Oldham | Texas | 48359 | 27 | 2 |
657209 | 657209 | 2020-10-22 | Upton | Texas | 48461 | 27 | 3 |
653913 | 653913 | 2020-10-21 | Oldham | Texas | 48359 | 27 | 2 |
653964 | 653964 | 2020-10-21 | Upton | Texas | 48461 | 27 | 3 |
650719 | 650719 | 2020-10-20 | Upton | Texas | 48461 | 27 | 3 |
647475 | 647475 | 2020-10-19 | Upton | Texas | 48461 | 27 | 3 |
644229 | 644229 | 2020-10-18 | Upton | Texas | 48461 | 27 | 3 |
640981 | 640981 | 2020-10-17 | Upton | Texas | 48461 | 27 | 3 |
589026 | 589026 | 2020-10-01 | Menard | Texas | 48327 | 27 | 0 |
582444 | 582444 | 2020-09-29 | Delta | Texas | 48119 | 27 | 0 |
579195 | 579195 | 2020-09-28 | Cottle | Texas | 48101 | 27 | 3 |
575954 | 575954 | 2020-09-27 | Cottle | Texas | 48101 | 27 | 3 |
572710 | 572710 | 2020-09-26 | Cottle | Texas | 48101 | 27 | 3 |
559792 | 559792 | 2020-09-22 | Hall | Texas | 48191 | 27 | 1 |
488581 | 488581 | 2020-08-31 | Dickens | Texas | 48125 | 27 | 1 |
485348 | 485348 | 2020-08-30 | Dickens | Texas | 48125 | 27 | 1 |
482113 | 482113 | 2020-08-29 | Dickens | Texas | 48125 | 27 | 1 |
449913 | 449913 | 2020-08-19 | Mills | Texas | 48333 | 27 | 0 |
446685 | 446685 | 2020-08-18 | Mills | Texas | 48333 | 27 | 0 |
443497 | 443497 | 2020-08-17 | San Saba | Texas | 48411 | 27 | 0 |
440271 | 440271 | 2020-08-16 | San Saba | Texas | 48411 | 27 | 0 |
423945 | 423945 | 2020-08-11 | Archer | Texas | 48009 | 27 | 0 |
404686 | 404686 | 2020-08-05 | Edwards | Texas | 48137 | 27 | 0 |
401439 | 401439 | 2020-08-04 | Cochran | Texas | 48079 | 27 | 0 |
378920 | 378920 | 2020-07-28 | Childress | Texas | 48075 | 27 | 0 |
359725 | 359725 | 2020-07-22 | Hemphill | Texas | 48211 | 27 | 0 |
359860 | 359860 | 2020-07-22 | Wilbarger | Texas | 48487 | 27 | 0 |
356653 | 356653 | 2020-07-21 | Wheeler | Texas | 48483 | 27 | 0 |
356655 | 356655 | 2020-07-21 | Wilbarger | Texas | 48487 | 27 | 0 |
353450 | 353450 | 2020-07-20 | Wheeler | Texas | 48483 | 27 | 0 |
346975 | 346975 | 2020-07-18 | Mitchell | Texas | 48335 | 27 | 0 |
343775 | 343775 | 2020-07-17 | Mitchell | Texas | 48335 | 27 | 0 |
343783 | 343783 | 2020-07-17 | Newton | Texas | 48351 | 27 | 0 |
340576 | 340576 | 2020-07-16 | Mitchell | Texas | 48335 | 27 | 0 |
340584 | 340584 | 2020-07-16 | Newton | Texas | 48351 | 27 | 0 |
337380 | 337380 | 2020-07-15 | Mitchell | Texas | 48335 | 27 | 0 |
334186 | 334186 | 2020-07-14 | Montague | Texas | 48337 | 27 | 1 |
334206 | 334206 | 2020-07-14 | Presidio | Texas | 48377 | 27 | 0 |
330858 | 330858 | 2020-07-13 | Callahan | Texas | 48059 | 27 | 2 |
327672 | 327672 | 2020-07-12 | Callahan | Texas | 48059 | 27 | 2 |
324487 | 324487 | 2020-07-11 | Callahan | Texas | 48059 | 27 | 2 |
321364 | 321364 | 2020-07-10 | Goliad | Texas | 48175 | 27 | 0 |
318221 | 318221 | 2020-07-09 | Jim Hogg | Texas | 48247 | 27 | 0 |
318245 | 318245 | 2020-07-09 | Llano | Texas | 48299 | 27 | 0 |
314936 | 314936 | 2020-07-08 | Bandera | Texas | 48019 | 27 | 0 |
311762 | 311762 | 2020-07-07 | Bandera | Texas | 48019 | 27 | 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);