ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
822 rows where fips = 48029 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176837 | 2176837 | 2022-02-02 | Bexar | Texas | 48029 | 516859 | 5571 |
2173583 | 2173583 | 2022-02-01 | Bexar | Texas | 48029 | 513824 | 5546 |
2170331 | 2170331 | 2022-01-31 | Bexar | Texas | 48029 | 507920 | 5542 |
2167077 | 2167077 | 2022-01-30 | Bexar | Texas | 48029 | 504911 | 5540 |
2163822 | 2163822 | 2022-01-29 | Bexar | Texas | 48029 | 502221 | 5532 |
2160567 | 2160567 | 2022-01-28 | Bexar | Texas | 48029 | 496811 | 5511 |
2157311 | 2157311 | 2022-01-27 | Bexar | Texas | 48029 | 491302 | 5501 |
2154058 | 2154058 | 2022-01-26 | Bexar | Texas | 48029 | 486741 | 5487 |
2150806 | 2150806 | 2022-01-25 | Bexar | Texas | 48029 | 481819 | 5472 |
2147554 | 2147554 | 2022-01-24 | Bexar | Texas | 48029 | 475972 | 5461 |
2144300 | 2144300 | 2022-01-23 | Bexar | Texas | 48029 | 468927 | 5460 |
2141045 | 2141045 | 2022-01-22 | Bexar | Texas | 48029 | 464736 | 5457 |
2137789 | 2137789 | 2022-01-21 | Bexar | Texas | 48029 | 459181 | 5450 |
2134535 | 2134535 | 2022-01-20 | Bexar | Texas | 48029 | 453025 | 5436 |
2131283 | 2131283 | 2022-01-19 | Bexar | Texas | 48029 | 446704 | 5426 |
2128029 | 2128029 | 2022-01-18 | Bexar | Texas | 48029 | 439392 | 5418 |
2124777 | 2124777 | 2022-01-17 | Bexar | Texas | 48029 | 433429 | 5409 |
2121525 | 2121525 | 2022-01-16 | Bexar | Texas | 48029 | 423977 | 5409 |
2118273 | 2118273 | 2022-01-15 | Bexar | Texas | 48029 | 419517 | 5408 |
2115022 | 2115022 | 2022-01-14 | Bexar | Texas | 48029 | 411317 | 5402 |
2111770 | 2111770 | 2022-01-13 | Bexar | Texas | 48029 | 402353 | 5396 |
2108518 | 2108518 | 2022-01-12 | Bexar | Texas | 48029 | 395893 | 5392 |
2105267 | 2105267 | 2022-01-11 | Bexar | Texas | 48029 | 387060 | 5389 |
2102016 | 2102016 | 2022-01-10 | Bexar | Texas | 48029 | 382083 | 5381 |
2098765 | 2098765 | 2022-01-09 | Bexar | Texas | 48029 | 377656 | 5381 |
2095513 | 2095513 | 2022-01-08 | Bexar | Texas | 48029 | 373793 | 5381 |
2092261 | 2092261 | 2022-01-07 | Bexar | Texas | 48029 | 368897 | 5370 |
2089009 | 2089009 | 2022-01-06 | Bexar | Texas | 48029 | 364052 | 5363 |
2085758 | 2085758 | 2022-01-05 | Bexar | Texas | 48029 | 361438 | 5356 |
2082506 | 2082506 | 2022-01-04 | Bexar | Texas | 48029 | 358229 | 5348 |
2079254 | 2079254 | 2022-01-03 | Bexar | Texas | 48029 | 353345 | 5348 |
2076003 | 2076003 | 2022-01-02 | Bexar | Texas | 48029 | 339899 | 5341 |
2072752 | 2072752 | 2022-01-01 | Bexar | Texas | 48029 | 339899 | 5341 |
2069501 | 2069501 | 2021-12-31 | Bexar | Texas | 48029 | 339899 | 5341 |
2066250 | 2066250 | 2021-12-30 | Bexar | Texas | 48029 | 339899 | 5341 |
2063000 | 2063000 | 2021-12-29 | Bexar | Texas | 48029 | 339155 | 5339 |
2059750 | 2059750 | 2021-12-28 | Bexar | Texas | 48029 | 338678 | 5337 |
2056501 | 2056501 | 2021-12-27 | Bexar | Texas | 48029 | 337657 | 5334 |
2053252 | 2053252 | 2021-12-26 | Bexar | Texas | 48029 | 334634 | 5324 |
2050002 | 2050002 | 2021-12-25 | Bexar | Texas | 48029 | 334634 | 5324 |
2046752 | 2046752 | 2021-12-24 | Bexar | Texas | 48029 | 334634 | 5324 |
2043502 | 2043502 | 2021-12-23 | Bexar | Texas | 48029 | 334634 | 5324 |
2040253 | 2040253 | 2021-12-22 | Bexar | Texas | 48029 | 334216 | 5318 |
2037003 | 2037003 | 2021-12-21 | Bexar | Texas | 48029 | 333807 | 5316 |
2033753 | 2033753 | 2021-12-20 | Bexar | Texas | 48029 | 333260 | 5314 |
2030503 | 2030503 | 2021-12-19 | Bexar | Texas | 48029 | 332811 | 5314 |
2027252 | 2027252 | 2021-12-18 | Bexar | Texas | 48029 | 332445 | 5312 |
2024001 | 2024001 | 2021-12-17 | Bexar | Texas | 48029 | 332130 | 5308 |
2020750 | 2020750 | 2021-12-16 | Bexar | Texas | 48029 | 331846 | 5306 |
2017499 | 2017499 | 2021-12-15 | Bexar | Texas | 48029 | 331565 | 5303 |
2014249 | 2014249 | 2021-12-14 | Bexar | Texas | 48029 | 331322 | 5302 |
2010998 | 2010998 | 2021-12-13 | Bexar | Texas | 48029 | 331071 | 5299 |
2007747 | 2007747 | 2021-12-12 | Bexar | Texas | 48029 | 330791 | 5299 |
2004496 | 2004496 | 2021-12-11 | Bexar | Texas | 48029 | 330630 | 5299 |
2001245 | 2001245 | 2021-12-10 | Bexar | Texas | 48029 | 330299 | 5299 |
1997995 | 1997995 | 2021-12-09 | Bexar | Texas | 48029 | 329990 | 5293 |
1994744 | 1994744 | 2021-12-08 | Bexar | Texas | 48029 | 329723 | 5288 |
1991493 | 1991493 | 2021-12-07 | Bexar | Texas | 48029 | 329490 | 5286 |
1988242 | 1988242 | 2021-12-06 | Bexar | Texas | 48029 | 329136 | 5282 |
1984992 | 1984992 | 2021-12-05 | Bexar | Texas | 48029 | 328286 | 5282 |
1981742 | 1981742 | 2021-12-04 | Bexar | Texas | 48029 | 328286 | 5282 |
1978492 | 1978492 | 2021-12-03 | Bexar | Texas | 48029 | 328286 | 5279 |
1975242 | 1975242 | 2021-12-02 | Bexar | Texas | 48029 | 328044 | 5277 |
1971993 | 1971993 | 2021-12-01 | Bexar | Texas | 48029 | 327794 | 5274 |
1968743 | 1968743 | 2021-11-30 | Bexar | Texas | 48029 | 327604 | 5273 |
1965492 | 1965492 | 2021-11-29 | Bexar | Texas | 48029 | 327406 | 5269 |
1962240 | 1962240 | 2021-11-28 | Bexar | Texas | 48029 | 326570 | 5263 |
1958989 | 1958989 | 2021-11-27 | Bexar | Texas | 48029 | 326570 | 5263 |
1955738 | 1955738 | 2021-11-26 | Bexar | Texas | 48029 | 326570 | 5263 |
1952487 | 1952487 | 2021-11-25 | Bexar | Texas | 48029 | 326570 | 5263 |
1949236 | 1949236 | 2021-11-24 | Bexar | Texas | 48029 | 326570 | 5263 |
1945985 | 1945985 | 2021-11-23 | Bexar | Texas | 48029 | 326435 | 5257 |
1942734 | 1942734 | 2021-11-22 | Bexar | Texas | 48029 | 326147 | 5254 |
1939484 | 1939484 | 2021-11-21 | Bexar | Texas | 48029 | 325502 | 5254 |
1936234 | 1936234 | 2021-11-20 | Bexar | Texas | 48029 | 325502 | 5253 |
1932984 | 1932984 | 2021-11-19 | Bexar | Texas | 48029 | 325502 | 5248 |
1929733 | 1929733 | 2021-11-18 | Bexar | Texas | 48029 | 325489 | 5244 |
1926483 | 1926483 | 2021-11-17 | Bexar | Texas | 48029 | 325332 | 5233 |
1923233 | 1923233 | 2021-11-16 | Bexar | Texas | 48029 | 325106 | 5228 |
1919984 | 1919984 | 2021-11-15 | Bexar | Texas | 48029 | 324838 | 5222 |
1916734 | 1916734 | 2021-11-14 | Bexar | Texas | 48029 | 324022 | 5222 |
1913484 | 1913484 | 2021-11-13 | Bexar | Texas | 48029 | 324022 | 5221 |
1910234 | 1910234 | 2021-11-12 | Bexar | Texas | 48029 | 324022 | 5218 |
1906985 | 1906985 | 2021-11-11 | Bexar | Texas | 48029 | 323649 | 5196 |
1903736 | 1903736 | 2021-11-10 | Bexar | Texas | 48029 | 323649 | 5175 |
1900486 | 1900486 | 2021-11-09 | Bexar | Texas | 48029 | 323434 | 5175 |
1897236 | 1897236 | 2021-11-08 | Bexar | Texas | 48029 | 322466 | 5165 |
1893986 | 1893986 | 2021-11-07 | Bexar | Texas | 48029 | 322466 | 5164 |
1890736 | 1890736 | 2021-11-06 | Bexar | Texas | 48029 | 322466 | 5162 |
1887486 | 1887486 | 2021-11-05 | Bexar | Texas | 48029 | 322466 | 5151 |
1884236 | 1884236 | 2021-11-04 | Bexar | Texas | 48029 | 322327 | 5146 |
1880987 | 1880987 | 2021-11-03 | Bexar | Texas | 48029 | 322157 | 5139 |
1877738 | 1877738 | 2021-11-02 | Bexar | Texas | 48029 | 321884 | 5133 |
1874489 | 1874489 | 2021-11-01 | Bexar | Texas | 48029 | 321884 | 5131 |
1871240 | 1871240 | 2021-10-31 | Bexar | Texas | 48029 | 321198 | 5131 |
1867991 | 1867991 | 2021-10-30 | Bexar | Texas | 48029 | 321198 | 5129 |
1864742 | 1864742 | 2021-10-29 | Bexar | Texas | 48029 | 321198 | 5125 |
1861493 | 1861493 | 2021-10-28 | Bexar | Texas | 48029 | 321025 | 5107 |
1858244 | 1858244 | 2021-10-27 | Bexar | Texas | 48029 | 320626 | 5095 |
1854995 | 1854995 | 2021-10-26 | Bexar | Texas | 48029 | 320471 | 5082 |
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);