ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where fips = 48407 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502411 | 2502411 | 2022-05-13 | San Jacinto | Texas | 48407 | 5611 | 102 |
2499153 | 2499153 | 2022-05-12 | San Jacinto | Texas | 48407 | 5611 | 102 |
2495895 | 2495895 | 2022-05-11 | San Jacinto | Texas | 48407 | 5611 | 102 |
2492637 | 2492637 | 2022-05-10 | San Jacinto | Texas | 48407 | 5609 | 101 |
2489379 | 2489379 | 2022-05-09 | San Jacinto | Texas | 48407 | 5605 | 101 |
2486121 | 2486121 | 2022-05-08 | San Jacinto | Texas | 48407 | 5604 | 101 |
2482863 | 2482863 | 2022-05-07 | San Jacinto | Texas | 48407 | 5604 | 101 |
2479605 | 2479605 | 2022-05-06 | San Jacinto | Texas | 48407 | 5601 | 101 |
2476347 | 2476347 | 2022-05-05 | San Jacinto | Texas | 48407 | 5598 | 101 |
2473090 | 2473090 | 2022-05-04 | San Jacinto | Texas | 48407 | 5596 | 101 |
2469834 | 2469834 | 2022-05-03 | San Jacinto | Texas | 48407 | 5592 | 101 |
2466578 | 2466578 | 2022-05-02 | San Jacinto | Texas | 48407 | 5592 | 101 |
2463323 | 2463323 | 2022-05-01 | San Jacinto | Texas | 48407 | 5592 | 101 |
2460067 | 2460067 | 2022-04-30 | San Jacinto | Texas | 48407 | 5592 | 101 |
2456811 | 2456811 | 2022-04-29 | San Jacinto | Texas | 48407 | 5590 | 101 |
2453555 | 2453555 | 2022-04-28 | San Jacinto | Texas | 48407 | 5590 | 101 |
2450299 | 2450299 | 2022-04-27 | San Jacinto | Texas | 48407 | 5588 | 101 |
2447042 | 2447042 | 2022-04-26 | San Jacinto | Texas | 48407 | 5586 | 101 |
2443787 | 2443787 | 2022-04-25 | San Jacinto | Texas | 48407 | 5572 | 101 |
2440531 | 2440531 | 2022-04-24 | San Jacinto | Texas | 48407 | 5572 | 101 |
2437275 | 2437275 | 2022-04-23 | San Jacinto | Texas | 48407 | 5572 | 101 |
2434019 | 2434019 | 2022-04-22 | San Jacinto | Texas | 48407 | 5567 | 101 |
2430763 | 2430763 | 2022-04-21 | San Jacinto | Texas | 48407 | 5553 | 100 |
2427507 | 2427507 | 2022-04-20 | San Jacinto | Texas | 48407 | 5548 | 100 |
2424251 | 2424251 | 2022-04-19 | San Jacinto | Texas | 48407 | 5547 | 100 |
2420995 | 2420995 | 2022-04-18 | San Jacinto | Texas | 48407 | 5544 | 100 |
2417739 | 2417739 | 2022-04-17 | San Jacinto | Texas | 48407 | 5540 | 100 |
2414483 | 2414483 | 2022-04-16 | San Jacinto | Texas | 48407 | 5540 | 100 |
2411227 | 2411227 | 2022-04-15 | San Jacinto | Texas | 48407 | 5540 | 100 |
2407971 | 2407971 | 2022-04-14 | San Jacinto | Texas | 48407 | 5540 | 100 |
2404715 | 2404715 | 2022-04-13 | San Jacinto | Texas | 48407 | 5539 | 100 |
2401460 | 2401460 | 2022-04-12 | San Jacinto | Texas | 48407 | 5538 | 100 |
2398205 | 2398205 | 2022-04-11 | San Jacinto | Texas | 48407 | 5532 | 100 |
2394950 | 2394950 | 2022-04-10 | San Jacinto | Texas | 48407 | 5531 | 100 |
2391694 | 2391694 | 2022-04-09 | San Jacinto | Texas | 48407 | 5530 | 100 |
2388438 | 2388438 | 2022-04-08 | San Jacinto | Texas | 48407 | 5523 | 100 |
2385183 | 2385183 | 2022-04-07 | San Jacinto | Texas | 48407 | 5521 | 100 |
2381928 | 2381928 | 2022-04-06 | San Jacinto | Texas | 48407 | 5516 | 100 |
2378673 | 2378673 | 2022-04-05 | San Jacinto | Texas | 48407 | 5514 | 100 |
2375419 | 2375419 | 2022-04-04 | San Jacinto | Texas | 48407 | 5513 | 100 |
2372167 | 2372167 | 2022-04-03 | San Jacinto | Texas | 48407 | 5513 | 100 |
2368914 | 2368914 | 2022-04-02 | San Jacinto | Texas | 48407 | 5512 | 100 |
2365661 | 2365661 | 2022-04-01 | San Jacinto | Texas | 48407 | 5510 | 100 |
2362408 | 2362408 | 2022-03-31 | San Jacinto | Texas | 48407 | 5510 | 100 |
2359154 | 2359154 | 2022-03-30 | San Jacinto | Texas | 48407 | 5498 | 100 |
2355900 | 2355900 | 2022-03-29 | San Jacinto | Texas | 48407 | 5498 | 100 |
2352647 | 2352647 | 2022-03-28 | San Jacinto | Texas | 48407 | 5497 | 100 |
2349395 | 2349395 | 2022-03-27 | San Jacinto | Texas | 48407 | 5496 | 100 |
2346142 | 2346142 | 2022-03-26 | San Jacinto | Texas | 48407 | 5495 | 100 |
2342889 | 2342889 | 2022-03-25 | San Jacinto | Texas | 48407 | 5494 | 100 |
2339636 | 2339636 | 2022-03-24 | San Jacinto | Texas | 48407 | 5493 | 100 |
2336382 | 2336382 | 2022-03-23 | San Jacinto | Texas | 48407 | 5471 | 100 |
2333128 | 2333128 | 2022-03-22 | San Jacinto | Texas | 48407 | 5447 | 100 |
2329875 | 2329875 | 2022-03-21 | San Jacinto | Texas | 48407 | 5435 | 100 |
2326623 | 2326623 | 2022-03-20 | San Jacinto | Texas | 48407 | 5434 | 100 |
2323370 | 2323370 | 2022-03-19 | San Jacinto | Texas | 48407 | 5432 | 100 |
2320116 | 2320116 | 2022-03-18 | San Jacinto | Texas | 48407 | 5419 | 100 |
2316862 | 2316862 | 2022-03-17 | San Jacinto | Texas | 48407 | 5419 | 100 |
2313609 | 2313609 | 2022-03-16 | San Jacinto | Texas | 48407 | 5407 | 100 |
2310356 | 2310356 | 2022-03-15 | San Jacinto | Texas | 48407 | 5384 | 100 |
2307103 | 2307103 | 2022-03-14 | San Jacinto | Texas | 48407 | 5372 | 100 |
2303852 | 2303852 | 2022-03-13 | San Jacinto | Texas | 48407 | 5371 | 100 |
2300600 | 2300600 | 2022-03-12 | San Jacinto | Texas | 48407 | 5369 | 100 |
2297348 | 2297348 | 2022-03-11 | San Jacinto | Texas | 48407 | 5365 | 100 |
2294096 | 2294096 | 2022-03-10 | San Jacinto | Texas | 48407 | 5364 | 100 |
2290844 | 2290844 | 2022-03-09 | San Jacinto | Texas | 48407 | 5363 | 100 |
2287592 | 2287592 | 2022-03-08 | San Jacinto | Texas | 48407 | 5359 | 100 |
2284340 | 2284340 | 2022-03-07 | San Jacinto | Texas | 48407 | 5356 | 100 |
2281088 | 2281088 | 2022-03-06 | San Jacinto | Texas | 48407 | 5353 | 100 |
2277835 | 2277835 | 2022-03-05 | San Jacinto | Texas | 48407 | 5352 | 100 |
2274582 | 2274582 | 2022-03-04 | San Jacinto | Texas | 48407 | 5341 | 100 |
2271329 | 2271329 | 2022-03-03 | San Jacinto | Texas | 48407 | 5328 | 100 |
2268077 | 2268077 | 2022-03-02 | San Jacinto | Texas | 48407 | 5325 | 100 |
2264824 | 2264824 | 2022-03-01 | San Jacinto | Texas | 48407 | 5315 | 100 |
2261574 | 2261574 | 2022-02-28 | San Jacinto | Texas | 48407 | 5313 | 100 |
2258323 | 2258323 | 2022-02-27 | San Jacinto | Texas | 48407 | 5310 | 100 |
2255072 | 2255072 | 2022-02-26 | San Jacinto | Texas | 48407 | 5308 | 100 |
2251821 | 2251821 | 2022-02-25 | San Jacinto | Texas | 48407 | 5302 | 100 |
2248570 | 2248570 | 2022-02-24 | San Jacinto | Texas | 48407 | 5298 | 99 |
2245319 | 2245319 | 2022-02-23 | San Jacinto | Texas | 48407 | 5280 | 98 |
2242068 | 2242068 | 2022-02-22 | San Jacinto | Texas | 48407 | 5273 | 98 |
2238817 | 2238817 | 2022-02-21 | San Jacinto | Texas | 48407 | 5266 | 98 |
2235566 | 2235566 | 2022-02-20 | San Jacinto | Texas | 48407 | 5263 | 98 |
2232315 | 2232315 | 2022-02-19 | San Jacinto | Texas | 48407 | 5261 | 98 |
2229064 | 2229064 | 2022-02-18 | San Jacinto | Texas | 48407 | 5254 | 98 |
2225813 | 2225813 | 2022-02-17 | San Jacinto | Texas | 48407 | 5250 | 98 |
2222562 | 2222562 | 2022-02-16 | San Jacinto | Texas | 48407 | 5239 | 98 |
2219311 | 2219311 | 2022-02-15 | San Jacinto | Texas | 48407 | 5226 | 98 |
2216060 | 2216060 | 2022-02-14 | San Jacinto | Texas | 48407 | 5219 | 97 |
2212809 | 2212809 | 2022-02-13 | San Jacinto | Texas | 48407 | 5215 | 97 |
2209556 | 2209556 | 2022-02-12 | San Jacinto | Texas | 48407 | 5208 | 95 |
2206303 | 2206303 | 2022-02-11 | San Jacinto | Texas | 48407 | 5197 | 95 |
2203050 | 2203050 | 2022-02-10 | San Jacinto | Texas | 48407 | 5178 | 95 |
2199796 | 2199796 | 2022-02-09 | San Jacinto | Texas | 48407 | 5171 | 95 |
2196542 | 2196542 | 2022-02-08 | San Jacinto | Texas | 48407 | 5160 | 93 |
2193288 | 2193288 | 2022-02-07 | San Jacinto | Texas | 48407 | 5148 | 92 |
2190034 | 2190034 | 2022-02-06 | San Jacinto | Texas | 48407 | 5139 | 92 |
2186781 | 2186781 | 2022-02-05 | San Jacinto | Texas | 48407 | 5103 | 92 |
2183529 | 2183529 | 2022-02-04 | San Jacinto | Texas | 48407 | 5091 | 91 |
2180277 | 2180277 | 2022-02-03 | San Jacinto | Texas | 48407 | 5071 | 91 |
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);