ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Hunt" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502322 | 2502322 | 2022-05-13 | Hunt | Texas | 48231 | 15811 | 363 |
2499064 | 2499064 | 2022-05-12 | Hunt | Texas | 48231 | 15805 | 363 |
2495806 | 2495806 | 2022-05-11 | Hunt | Texas | 48231 | 15803 | 363 |
2492548 | 2492548 | 2022-05-10 | Hunt | Texas | 48231 | 15802 | 363 |
2489290 | 2489290 | 2022-05-09 | Hunt | Texas | 48231 | 15797 | 363 |
2486033 | 2486033 | 2022-05-08 | Hunt | Texas | 48231 | 15793 | 363 |
2482775 | 2482775 | 2022-05-07 | Hunt | Texas | 48231 | 15790 | 363 |
2479517 | 2479517 | 2022-05-06 | Hunt | Texas | 48231 | 15787 | 363 |
2476259 | 2476259 | 2022-05-05 | Hunt | Texas | 48231 | 15785 | 363 |
2473002 | 2473002 | 2022-05-04 | Hunt | Texas | 48231 | 15783 | 363 |
2469746 | 2469746 | 2022-05-03 | Hunt | Texas | 48231 | 15781 | 363 |
2466490 | 2466490 | 2022-05-02 | Hunt | Texas | 48231 | 15780 | 363 |
2463235 | 2463235 | 2022-05-01 | Hunt | Texas | 48231 | 15779 | 363 |
2459979 | 2459979 | 2022-04-30 | Hunt | Texas | 48231 | 15778 | 363 |
2456723 | 2456723 | 2022-04-29 | Hunt | Texas | 48231 | 15769 | 363 |
2453467 | 2453467 | 2022-04-28 | Hunt | Texas | 48231 | 15768 | 362 |
2450211 | 2450211 | 2022-04-27 | Hunt | Texas | 48231 | 15767 | 362 |
2446954 | 2446954 | 2022-04-26 | Hunt | Texas | 48231 | 15767 | 362 |
2443699 | 2443699 | 2022-04-25 | Hunt | Texas | 48231 | 15767 | 362 |
2440443 | 2440443 | 2022-04-24 | Hunt | Texas | 48231 | 15764 | 362 |
2437187 | 2437187 | 2022-04-23 | Hunt | Texas | 48231 | 15763 | 362 |
2433931 | 2433931 | 2022-04-22 | Hunt | Texas | 48231 | 15761 | 362 |
2430675 | 2430675 | 2022-04-21 | Hunt | Texas | 48231 | 15761 | 362 |
2427419 | 2427419 | 2022-04-20 | Hunt | Texas | 48231 | 15761 | 362 |
2424163 | 2424163 | 2022-04-19 | Hunt | Texas | 48231 | 15760 | 362 |
2420907 | 2420907 | 2022-04-18 | Hunt | Texas | 48231 | 15760 | 362 |
2417651 | 2417651 | 2022-04-17 | Hunt | Texas | 48231 | 15756 | 362 |
2414395 | 2414395 | 2022-04-16 | Hunt | Texas | 48231 | 15756 | 362 |
2411139 | 2411139 | 2022-04-15 | Hunt | Texas | 48231 | 15756 | 362 |
2407883 | 2407883 | 2022-04-14 | Hunt | Texas | 48231 | 15756 | 362 |
2404627 | 2404627 | 2022-04-13 | Hunt | Texas | 48231 | 15755 | 362 |
2401372 | 2401372 | 2022-04-12 | Hunt | Texas | 48231 | 15754 | 362 |
2398117 | 2398117 | 2022-04-11 | Hunt | Texas | 48231 | 15752 | 362 |
2394862 | 2394862 | 2022-04-10 | Hunt | Texas | 48231 | 15752 | 362 |
2391606 | 2391606 | 2022-04-09 | Hunt | Texas | 48231 | 15752 | 362 |
2388350 | 2388350 | 2022-04-08 | Hunt | Texas | 48231 | 15748 | 361 |
2385095 | 2385095 | 2022-04-07 | Hunt | Texas | 48231 | 15747 | 361 |
2381840 | 2381840 | 2022-04-06 | Hunt | Texas | 48231 | 15745 | 361 |
2378585 | 2378585 | 2022-04-05 | Hunt | Texas | 48231 | 15744 | 361 |
2375331 | 2375331 | 2022-04-04 | Hunt | Texas | 48231 | 15741 | 361 |
2372079 | 2372079 | 2022-04-03 | Hunt | Texas | 48231 | 15740 | 361 |
2368826 | 2368826 | 2022-04-02 | Hunt | Texas | 48231 | 15740 | 361 |
2365573 | 2365573 | 2022-04-01 | Hunt | Texas | 48231 | 15739 | 361 |
2362320 | 2362320 | 2022-03-31 | Hunt | Texas | 48231 | 15738 | 361 |
2359066 | 2359066 | 2022-03-30 | Hunt | Texas | 48231 | 15736 | 361 |
2355812 | 2355812 | 2022-03-29 | Hunt | Texas | 48231 | 15734 | 360 |
2352559 | 2352559 | 2022-03-28 | Hunt | Texas | 48231 | 15731 | 360 |
2349307 | 2349307 | 2022-03-27 | Hunt | Texas | 48231 | 15731 | 360 |
2346054 | 2346054 | 2022-03-26 | Hunt | Texas | 48231 | 15731 | 360 |
2342801 | 2342801 | 2022-03-25 | Hunt | Texas | 48231 | 15730 | 359 |
2339548 | 2339548 | 2022-03-24 | Hunt | Texas | 48231 | 15729 | 359 |
2336294 | 2336294 | 2022-03-23 | Hunt | Texas | 48231 | 15727 | 359 |
2333040 | 2333040 | 2022-03-22 | Hunt | Texas | 48231 | 15723 | 359 |
2329787 | 2329787 | 2022-03-21 | Hunt | Texas | 48231 | 15723 | 359 |
2326535 | 2326535 | 2022-03-20 | Hunt | Texas | 48231 | 15722 | 359 |
2323282 | 2323282 | 2022-03-19 | Hunt | Texas | 48231 | 15713 | 359 |
2320028 | 2320028 | 2022-03-18 | Hunt | Texas | 48231 | 15712 | 359 |
2316774 | 2316774 | 2022-03-17 | Hunt | Texas | 48231 | 15712 | 358 |
2313521 | 2313521 | 2022-03-16 | Hunt | Texas | 48231 | 15712 | 358 |
2310268 | 2310268 | 2022-03-15 | Hunt | Texas | 48231 | 15711 | 358 |
2307015 | 2307015 | 2022-03-14 | Hunt | Texas | 48231 | 15709 | 358 |
2303764 | 2303764 | 2022-03-13 | Hunt | Texas | 48231 | 15708 | 358 |
2300512 | 2300512 | 2022-03-12 | Hunt | Texas | 48231 | 15707 | 357 |
2297260 | 2297260 | 2022-03-11 | Hunt | Texas | 48231 | 15706 | 357 |
2294008 | 2294008 | 2022-03-10 | Hunt | Texas | 48231 | 15687 | 357 |
2290756 | 2290756 | 2022-03-09 | Hunt | Texas | 48231 | 15683 | 357 |
2287504 | 2287504 | 2022-03-08 | Hunt | Texas | 48231 | 15678 | 356 |
2284252 | 2284252 | 2022-03-07 | Hunt | Texas | 48231 | 15676 | 356 |
2281000 | 2281000 | 2022-03-06 | Hunt | Texas | 48231 | 15672 | 356 |
2277747 | 2277747 | 2022-03-05 | Hunt | Texas | 48231 | 15671 | 356 |
2274494 | 2274494 | 2022-03-04 | Hunt | Texas | 48231 | 15670 | 354 |
2271241 | 2271241 | 2022-03-03 | Hunt | Texas | 48231 | 15667 | 354 |
2267989 | 2267989 | 2022-03-02 | Hunt | Texas | 48231 | 15666 | 353 |
2264736 | 2264736 | 2022-03-01 | Hunt | Texas | 48231 | 15664 | 352 |
2261486 | 2261486 | 2022-02-28 | Hunt | Texas | 48231 | 15661 | 352 |
2258235 | 2258235 | 2022-02-27 | Hunt | Texas | 48231 | 15656 | 351 |
2254984 | 2254984 | 2022-02-26 | Hunt | Texas | 48231 | 15656 | 350 |
2251733 | 2251733 | 2022-02-25 | Hunt | Texas | 48231 | 15653 | 350 |
2248482 | 2248482 | 2022-02-24 | Hunt | Texas | 48231 | 15647 | 350 |
2245231 | 2245231 | 2022-02-23 | Hunt | Texas | 48231 | 15641 | 349 |
2241980 | 2241980 | 2022-02-22 | Hunt | Texas | 48231 | 15632 | 349 |
2238729 | 2238729 | 2022-02-21 | Hunt | Texas | 48231 | 15623 | 349 |
2235478 | 2235478 | 2022-02-20 | Hunt | Texas | 48231 | 15616 | 349 |
2232227 | 2232227 | 2022-02-19 | Hunt | Texas | 48231 | 15613 | 349 |
2228976 | 2228976 | 2022-02-18 | Hunt | Texas | 48231 | 15592 | 348 |
2225725 | 2225725 | 2022-02-17 | Hunt | Texas | 48231 | 15588 | 346 |
2222474 | 2222474 | 2022-02-16 | Hunt | Texas | 48231 | 15583 | 345 |
2219223 | 2219223 | 2022-02-15 | Hunt | Texas | 48231 | 15569 | 343 |
2215972 | 2215972 | 2022-02-14 | Hunt | Texas | 48231 | 15548 | 343 |
2212721 | 2212721 | 2022-02-13 | Hunt | Texas | 48231 | 15532 | 343 |
2209468 | 2209468 | 2022-02-12 | Hunt | Texas | 48231 | 15518 | 342 |
2206215 | 2206215 | 2022-02-11 | Hunt | Texas | 48231 | 15497 | 342 |
2202962 | 2202962 | 2022-02-10 | Hunt | Texas | 48231 | 15469 | 341 |
2199708 | 2199708 | 2022-02-09 | Hunt | Texas | 48231 | 15443 | 336 |
2196454 | 2196454 | 2022-02-08 | Hunt | Texas | 48231 | 15414 | 335 |
2193200 | 2193200 | 2022-02-07 | Hunt | Texas | 48231 | 15403 | 334 |
2189946 | 2189946 | 2022-02-06 | Hunt | Texas | 48231 | 15382 | 334 |
2186693 | 2186693 | 2022-02-05 | Hunt | Texas | 48231 | 15322 | 334 |
2183441 | 2183441 | 2022-02-04 | Hunt | Texas | 48231 | 15268 | 332 |
2180189 | 2180189 | 2022-02-03 | Hunt | Texas | 48231 | 15223 | 332 |
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);