ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
751 rows where fips = 48247 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 |
---|---|---|---|---|---|---|---|
2502330 | 2502330 | 2022-05-13 | Jim Hogg | Texas | 48247 | 2648 | 22 |
2499072 | 2499072 | 2022-05-12 | Jim Hogg | Texas | 48247 | 2648 | 22 |
2495814 | 2495814 | 2022-05-11 | Jim Hogg | Texas | 48247 | 2647 | 22 |
2492556 | 2492556 | 2022-05-10 | Jim Hogg | Texas | 48247 | 2644 | 22 |
2489298 | 2489298 | 2022-05-09 | Jim Hogg | Texas | 48247 | 2644 | 22 |
2486041 | 2486041 | 2022-05-08 | Jim Hogg | Texas | 48247 | 2641 | 22 |
2482783 | 2482783 | 2022-05-07 | Jim Hogg | Texas | 48247 | 2639 | 22 |
2479525 | 2479525 | 2022-05-06 | Jim Hogg | Texas | 48247 | 2639 | 22 |
2476267 | 2476267 | 2022-05-05 | Jim Hogg | Texas | 48247 | 2638 | 22 |
2473010 | 2473010 | 2022-05-04 | Jim Hogg | Texas | 48247 | 2636 | 22 |
2469754 | 2469754 | 2022-05-03 | Jim Hogg | Texas | 48247 | 2634 | 22 |
2466498 | 2466498 | 2022-05-02 | Jim Hogg | Texas | 48247 | 2633 | 22 |
2463243 | 2463243 | 2022-05-01 | Jim Hogg | Texas | 48247 | 2633 | 22 |
2459987 | 2459987 | 2022-04-30 | Jim Hogg | Texas | 48247 | 2633 | 22 |
2456731 | 2456731 | 2022-04-29 | Jim Hogg | Texas | 48247 | 2633 | 22 |
2453475 | 2453475 | 2022-04-28 | Jim Hogg | Texas | 48247 | 2622 | 22 |
2450219 | 2450219 | 2022-04-27 | Jim Hogg | Texas | 48247 | 2621 | 22 |
2446962 | 2446962 | 2022-04-26 | Jim Hogg | Texas | 48247 | 2621 | 22 |
2443707 | 2443707 | 2022-04-25 | Jim Hogg | Texas | 48247 | 2620 | 22 |
2440451 | 2440451 | 2022-04-24 | Jim Hogg | Texas | 48247 | 2620 | 22 |
2437195 | 2437195 | 2022-04-23 | Jim Hogg | Texas | 48247 | 2620 | 22 |
2433939 | 2433939 | 2022-04-22 | Jim Hogg | Texas | 48247 | 2620 | 22 |
2430683 | 2430683 | 2022-04-21 | Jim Hogg | Texas | 48247 | 2618 | 22 |
2427427 | 2427427 | 2022-04-20 | Jim Hogg | Texas | 48247 | 2617 | 22 |
2424171 | 2424171 | 2022-04-19 | Jim Hogg | Texas | 48247 | 2616 | 22 |
2420915 | 2420915 | 2022-04-18 | Jim Hogg | Texas | 48247 | 2616 | 22 |
2417659 | 2417659 | 2022-04-17 | Jim Hogg | Texas | 48247 | 2616 | 22 |
2414403 | 2414403 | 2022-04-16 | Jim Hogg | Texas | 48247 | 2616 | 22 |
2411147 | 2411147 | 2022-04-15 | Jim Hogg | Texas | 48247 | 2616 | 22 |
2407891 | 2407891 | 2022-04-14 | Jim Hogg | Texas | 48247 | 2616 | 22 |
2404635 | 2404635 | 2022-04-13 | Jim Hogg | Texas | 48247 | 2616 | 22 |
2401380 | 2401380 | 2022-04-12 | Jim Hogg | Texas | 48247 | 2616 | 22 |
2398125 | 2398125 | 2022-04-11 | Jim Hogg | Texas | 48247 | 2615 | 22 |
2394870 | 2394870 | 2022-04-10 | Jim Hogg | Texas | 48247 | 2615 | 22 |
2391614 | 2391614 | 2022-04-09 | Jim Hogg | Texas | 48247 | 2615 | 22 |
2388358 | 2388358 | 2022-04-08 | Jim Hogg | Texas | 48247 | 2614 | 22 |
2385103 | 2385103 | 2022-04-07 | Jim Hogg | Texas | 48247 | 2614 | 22 |
2381848 | 2381848 | 2022-04-06 | Jim Hogg | Texas | 48247 | 2614 | 22 |
2378593 | 2378593 | 2022-04-05 | Jim Hogg | Texas | 48247 | 2614 | 22 |
2375339 | 2375339 | 2022-04-04 | Jim Hogg | Texas | 48247 | 2614 | 22 |
2372087 | 2372087 | 2022-04-03 | Jim Hogg | Texas | 48247 | 2613 | 22 |
2368834 | 2368834 | 2022-04-02 | Jim Hogg | Texas | 48247 | 2611 | 22 |
2365581 | 2365581 | 2022-04-01 | Jim Hogg | Texas | 48247 | 2609 | 22 |
2362328 | 2362328 | 2022-03-31 | Jim Hogg | Texas | 48247 | 2609 | 22 |
2359074 | 2359074 | 2022-03-30 | Jim Hogg | Texas | 48247 | 2607 | 22 |
2355820 | 2355820 | 2022-03-29 | Jim Hogg | Texas | 48247 | 2607 | 22 |
2352567 | 2352567 | 2022-03-28 | Jim Hogg | Texas | 48247 | 2607 | 22 |
2349315 | 2349315 | 2022-03-27 | Jim Hogg | Texas | 48247 | 2607 | 22 |
2346062 | 2346062 | 2022-03-26 | Jim Hogg | Texas | 48247 | 2607 | 22 |
2342809 | 2342809 | 2022-03-25 | Jim Hogg | Texas | 48247 | 2605 | 22 |
2339556 | 2339556 | 2022-03-24 | Jim Hogg | Texas | 48247 | 2604 | 22 |
2336302 | 2336302 | 2022-03-23 | Jim Hogg | Texas | 48247 | 2604 | 22 |
2333048 | 2333048 | 2022-03-22 | Jim Hogg | Texas | 48247 | 2604 | 22 |
2329795 | 2329795 | 2022-03-21 | Jim Hogg | Texas | 48247 | 2604 | 22 |
2326543 | 2326543 | 2022-03-20 | Jim Hogg | Texas | 48247 | 2603 | 22 |
2323290 | 2323290 | 2022-03-19 | Jim Hogg | Texas | 48247 | 2603 | 22 |
2320036 | 2320036 | 2022-03-18 | Jim Hogg | Texas | 48247 | 2603 | 22 |
2316782 | 2316782 | 2022-03-17 | Jim Hogg | Texas | 48247 | 2603 | 22 |
2313529 | 2313529 | 2022-03-16 | Jim Hogg | Texas | 48247 | 2602 | 22 |
2310276 | 2310276 | 2022-03-15 | Jim Hogg | Texas | 48247 | 2602 | 22 |
2307023 | 2307023 | 2022-03-14 | Jim Hogg | Texas | 48247 | 2602 | 22 |
2303772 | 2303772 | 2022-03-13 | Jim Hogg | Texas | 48247 | 2602 | 22 |
2300520 | 2300520 | 2022-03-12 | Jim Hogg | Texas | 48247 | 2602 | 22 |
2297268 | 2297268 | 2022-03-11 | Jim Hogg | Texas | 48247 | 2600 | 22 |
2294016 | 2294016 | 2022-03-10 | Jim Hogg | Texas | 48247 | 2600 | 22 |
2290764 | 2290764 | 2022-03-09 | Jim Hogg | Texas | 48247 | 2599 | 22 |
2287512 | 2287512 | 2022-03-08 | Jim Hogg | Texas | 48247 | 2598 | 22 |
2284260 | 2284260 | 2022-03-07 | Jim Hogg | Texas | 48247 | 2596 | 22 |
2281008 | 2281008 | 2022-03-06 | Jim Hogg | Texas | 48247 | 2591 | 22 |
2277755 | 2277755 | 2022-03-05 | Jim Hogg | Texas | 48247 | 2591 | 22 |
2274502 | 2274502 | 2022-03-04 | Jim Hogg | Texas | 48247 | 2591 | 22 |
2271249 | 2271249 | 2022-03-03 | Jim Hogg | Texas | 48247 | 2591 | 21 |
2267997 | 2267997 | 2022-03-02 | Jim Hogg | Texas | 48247 | 2580 | 21 |
2264744 | 2264744 | 2022-03-01 | Jim Hogg | Texas | 48247 | 2569 | 21 |
2261494 | 2261494 | 2022-02-28 | Jim Hogg | Texas | 48247 | 2531 | 21 |
2258243 | 2258243 | 2022-02-27 | Jim Hogg | Texas | 48247 | 2531 | 21 |
2254992 | 2254992 | 2022-02-26 | Jim Hogg | Texas | 48247 | 2531 | 21 |
2251741 | 2251741 | 2022-02-25 | Jim Hogg | Texas | 48247 | 2531 | 21 |
2248490 | 2248490 | 2022-02-24 | Jim Hogg | Texas | 48247 | 2528 | 21 |
2245239 | 2245239 | 2022-02-23 | Jim Hogg | Texas | 48247 | 2510 | 21 |
2241988 | 2241988 | 2022-02-22 | Jim Hogg | Texas | 48247 | 2510 | 21 |
2238737 | 2238737 | 2022-02-21 | Jim Hogg | Texas | 48247 | 2489 | 21 |
2235486 | 2235486 | 2022-02-20 | Jim Hogg | Texas | 48247 | 2450 | 21 |
2232235 | 2232235 | 2022-02-19 | Jim Hogg | Texas | 48247 | 2449 | 21 |
2228984 | 2228984 | 2022-02-18 | Jim Hogg | Texas | 48247 | 2447 | 21 |
2225733 | 2225733 | 2022-02-17 | Jim Hogg | Texas | 48247 | 2446 | 20 |
2222482 | 2222482 | 2022-02-16 | Jim Hogg | Texas | 48247 | 2428 | 20 |
2219231 | 2219231 | 2022-02-15 | Jim Hogg | Texas | 48247 | 2391 | 20 |
2215980 | 2215980 | 2022-02-14 | Jim Hogg | Texas | 48247 | 2387 | 20 |
2212729 | 2212729 | 2022-02-13 | Jim Hogg | Texas | 48247 | 2386 | 20 |
2209476 | 2209476 | 2022-02-12 | Jim Hogg | Texas | 48247 | 2371 | 20 |
2206223 | 2206223 | 2022-02-11 | Jim Hogg | Texas | 48247 | 2371 | 20 |
2202970 | 2202970 | 2022-02-10 | Jim Hogg | Texas | 48247 | 2317 | 20 |
2199716 | 2199716 | 2022-02-09 | Jim Hogg | Texas | 48247 | 2316 | 20 |
2196462 | 2196462 | 2022-02-08 | Jim Hogg | Texas | 48247 | 2298 | 20 |
2193208 | 2193208 | 2022-02-07 | Jim Hogg | Texas | 48247 | 2297 | 20 |
2189954 | 2189954 | 2022-02-06 | Jim Hogg | Texas | 48247 | 2284 | 20 |
2186701 | 2186701 | 2022-02-05 | Jim Hogg | Texas | 48247 | 2263 | 20 |
2183449 | 2183449 | 2022-02-04 | Jim Hogg | Texas | 48247 | 2239 | 20 |
2180197 | 2180197 | 2022-02-03 | Jim Hogg | Texas | 48247 | 2215 | 20 |
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);