ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
30 rows where cases = 1014 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2193137 | 2193137 | 2022-02-07 | Crockett | Texas | 48105 | 1014 | 17 |
2085945 | 2085945 | 2022-01-05 | Sabine | Texas | 48403 | 1014 | 78 |
1897275 | 1897275 | 2021-11-08 | Crosby | Texas | 48107 | 1014 | 37 |
1894025 | 1894025 | 2021-11-07 | Crosby | Texas | 48107 | 1014 | 37 |
1890775 | 1890775 | 2021-11-06 | Crosby | Texas | 48107 | 1014 | 37 |
1689300 | 1689300 | 2021-09-05 | Blanco | Texas | 48031 | 1014 | 23 |
1686050 | 1686050 | 2021-09-04 | Blanco | Texas | 48031 | 1014 | 23 |
1553023 | 1553023 | 2021-07-25 | Morris | Texas | 48343 | 1014 | 36 |
1533506 | 1533506 | 2021-07-19 | La Salle | Texas | 48283 | 1014 | 30 |
1530259 | 1530259 | 2021-07-18 | La Salle | Texas | 48283 | 1014 | 30 |
1527012 | 1527012 | 2021-07-17 | La Salle | Texas | 48283 | 1014 | 30 |
1147058 | 1147058 | 2021-03-22 | Clay | Texas | 48077 | 1014 | 16 |
1143811 | 1143811 | 2021-03-21 | Clay | Texas | 48077 | 1014 | 16 |
1140564 | 1140564 | 2021-03-20 | Clay | Texas | 48077 | 1014 | 16 |
1137318 | 1137318 | 2021-03-19 | Clay | Texas | 48077 | 1014 | 16 |
1134072 | 1134072 | 2021-03-18 | Clay | Texas | 48077 | 1014 | 16 |
1082295 | 1082295 | 2021-03-02 | San Jacinto | Texas | 48407 | 1014 | 28 |
1014113 | 1014113 | 2021-02-09 | Ochiltree | Texas | 48357 | 1014 | 21 |
987977 | 987977 | 2021-02-01 | Bandera | Texas | 48019 | 1014 | 22 |
984730 | 984730 | 2021-01-31 | Bandera | Texas | 48019 | 1014 | 22 |
981483 | 981483 | 2021-01-30 | Bandera | Texas | 48019 | 1014 | 22 |
832375 | 832375 | 2020-12-15 | Parmer | Texas | 48369 | 1014 | 28 |
809707 | 809707 | 2020-12-08 | Washington | Texas | 48477 | 1014 | 54 |
748040 | 748040 | 2020-11-19 | Uvalde | Texas | 48463 | 1014 | 38 |
721906 | 721906 | 2020-11-11 | Dawson | Texas | 48115 | 1014 | 24 |
670037 | 670037 | 2020-10-26 | Frio | Texas | 48163 | 1014 | 9 |
592240 | 592240 | 2020-10-02 | Kleberg | Texas | 48273 | 1014 | 44 |
546901 | 546901 | 2020-09-18 | Matagorda | Texas | 48321 | 1014 | 42 |
324551 | 324551 | 2020-07-11 | Guadalupe | Texas | 48187 | 1014 | 3 |
273883 | 273883 | 2020-06-25 | Anderson | Texas | 48001 | 1014 | 2 |
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);