ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
46 rows where cases = 972 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2284251 | 2284251 | 2022-03-07 | Hudspeth | Texas | 48229 | 972 | 16 |
2280999 | 2280999 | 2022-03-06 | Hudspeth | Texas | 48229 | 972 | 16 |
2277746 | 2277746 | 2022-03-05 | Hudspeth | Texas | 48229 | 972 | 16 |
2274493 | 2274493 | 2022-03-04 | Hudspeth | Texas | 48229 | 972 | 16 |
2271240 | 2271240 | 2022-03-03 | Hudspeth | Texas | 48229 | 972 | 16 |
2267988 | 2267988 | 2022-03-02 | Hudspeth | Texas | 48229 | 972 | 16 |
2264735 | 2264735 | 2022-03-01 | Hudspeth | Texas | 48229 | 972 | 16 |
2261485 | 2261485 | 2022-02-28 | Hudspeth | Texas | 48229 | 972 | 16 |
2258234 | 2258234 | 2022-02-27 | Hudspeth | Texas | 48229 | 972 | 16 |
2254983 | 2254983 | 2022-02-26 | Hudspeth | Texas | 48229 | 972 | 16 |
2085896 | 2085896 | 2022-01-05 | Lynn | Texas | 48305 | 972 | 29 |
2037148 | 2037148 | 2021-12-21 | McCulloch | Texas | 48307 | 972 | 40 |
2024089 | 2024089 | 2021-12-17 | Hartley | Texas | 48205 | 972 | 2 |
2004683 | 2004683 | 2021-12-11 | Sabine | Texas | 48403 | 972 | 77 |
1920088 | 1920088 | 2021-11-15 | Jack | Texas | 48237 | 972 | 21 |
1916838 | 1916838 | 2021-11-14 | Jack | Texas | 48237 | 972 | 21 |
1913588 | 1913588 | 2021-11-13 | Jack | Texas | 48237 | 972 | 21 |
1910338 | 1910338 | 2021-11-12 | Jack | Texas | 48237 | 972 | 21 |
1907089 | 1907089 | 2021-11-11 | Jack | Texas | 48237 | 972 | 21 |
1653648 | 1653648 | 2021-08-25 | Hamilton | Texas | 48193 | 972 | 29 |
1624392 | 1624392 | 2021-08-16 | Floyd | Texas | 48153 | 972 | 30 |
1621145 | 1621145 | 2021-08-15 | Floyd | Texas | 48153 | 972 | 30 |
1617897 | 1617897 | 2021-08-14 | Floyd | Texas | 48153 | 972 | 30 |
1592059 | 1592059 | 2021-08-06 | Trinity | Texas | 48455 | 972 | 32 |
1517302 | 1517302 | 2021-07-14 | Morris | Texas | 48343 | 972 | 34 |
1514055 | 1514055 | 2021-07-13 | Morris | Texas | 48343 | 972 | 34 |
945843 | 945843 | 2021-01-19 | Eastland | Texas | 48133 | 972 | 23 |
942596 | 942596 | 2021-01-18 | Eastland | Texas | 48133 | 972 | 23 |
939351 | 939351 | 2021-01-17 | Eastland | Texas | 48133 | 972 | 23 |
936106 | 936106 | 2021-01-16 | Eastland | Texas | 48133 | 972 | 19 |
773914 | 773914 | 2020-11-27 | Lamb | Texas | 48279 | 972 | 44 |
770669 | 770669 | 2020-11-26 | Lamb | Texas | 48279 | 972 | 43 |
725219 | 725219 | 2020-11-12 | Karnes | Texas | 48255 | 972 | 18 |
721957 | 721957 | 2020-11-11 | Hill | Texas | 48217 | 972 | 16 |
721976 | 721976 | 2020-11-11 | Karnes | Texas | 48255 | 972 | 18 |
718733 | 718733 | 2020-11-10 | Karnes | Texas | 48255 | 972 | 18 |
705688 | 705688 | 2020-11-06 | Dawson | Texas | 48115 | 972 | 22 |
644245 | 644245 | 2020-10-18 | Wilson | Texas | 48493 | 972 | 28 |
640997 | 640997 | 2020-10-17 | Wilson | Texas | 48493 | 972 | 28 |
637750 | 637750 | 2020-10-16 | Wilson | Texas | 48493 | 972 | 28 |
585822 | 585822 | 2020-09-30 | Rusk | Texas | 48401 | 972 | 11 |
559778 | 559778 | 2020-09-22 | Frio | Texas | 48163 | 972 | 8 |
427366 | 427366 | 2020-08-12 | San Patricio | Texas | 48409 | 972 | 31 |
424142 | 424142 | 2020-08-11 | San Patricio | Texas | 48409 | 972 | 30 |
385408 | 385408 | 2020-07-30 | Grayson | Texas | 48181 | 972 | 11 |
214816 | 214816 | 2020-06-06 | Galveston | Texas | 48167 | 972 | 38 |
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);