ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
768 rows where fips = 48505 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 |
---|---|---|---|---|---|---|---|
2502460 | 2502460 | 2022-05-13 | Zapata | Texas | 48505 | 3752 | 55 |
2499202 | 2499202 | 2022-05-12 | Zapata | Texas | 48505 | 3750 | 55 |
2495944 | 2495944 | 2022-05-11 | Zapata | Texas | 48505 | 3742 | 55 |
2492686 | 2492686 | 2022-05-10 | Zapata | Texas | 48505 | 3739 | 55 |
2489428 | 2489428 | 2022-05-09 | Zapata | Texas | 48505 | 3739 | 55 |
2486170 | 2486170 | 2022-05-08 | Zapata | Texas | 48505 | 3739 | 55 |
2482912 | 2482912 | 2022-05-07 | Zapata | Texas | 48505 | 3738 | 55 |
2479654 | 2479654 | 2022-05-06 | Zapata | Texas | 48505 | 3734 | 55 |
2476396 | 2476396 | 2022-05-05 | Zapata | Texas | 48505 | 3734 | 55 |
2473139 | 2473139 | 2022-05-04 | Zapata | Texas | 48505 | 3730 | 55 |
2469883 | 2469883 | 2022-05-03 | Zapata | Texas | 48505 | 3730 | 55 |
2466627 | 2466627 | 2022-05-02 | Zapata | Texas | 48505 | 3727 | 55 |
2463372 | 2463372 | 2022-05-01 | Zapata | Texas | 48505 | 3712 | 55 |
2460116 | 2460116 | 2022-04-30 | Zapata | Texas | 48505 | 3711 | 55 |
2456860 | 2456860 | 2022-04-29 | Zapata | Texas | 48505 | 3709 | 55 |
2453604 | 2453604 | 2022-04-28 | Zapata | Texas | 48505 | 3701 | 55 |
2450348 | 2450348 | 2022-04-27 | Zapata | Texas | 48505 | 3695 | 55 |
2447091 | 2447091 | 2022-04-26 | Zapata | Texas | 48505 | 3693 | 55 |
2443836 | 2443836 | 2022-04-25 | Zapata | Texas | 48505 | 3691 | 55 |
2440580 | 2440580 | 2022-04-24 | Zapata | Texas | 48505 | 3691 | 55 |
2437324 | 2437324 | 2022-04-23 | Zapata | Texas | 48505 | 3691 | 55 |
2434068 | 2434068 | 2022-04-22 | Zapata | Texas | 48505 | 3689 | 55 |
2430812 | 2430812 | 2022-04-21 | Zapata | Texas | 48505 | 3686 | 55 |
2427556 | 2427556 | 2022-04-20 | Zapata | Texas | 48505 | 3683 | 55 |
2424300 | 2424300 | 2022-04-19 | Zapata | Texas | 48505 | 3681 | 55 |
2421044 | 2421044 | 2022-04-18 | Zapata | Texas | 48505 | 3679 | 55 |
2417788 | 2417788 | 2022-04-17 | Zapata | Texas | 48505 | 3676 | 55 |
2414532 | 2414532 | 2022-04-16 | Zapata | Texas | 48505 | 3676 | 55 |
2411276 | 2411276 | 2022-04-15 | Zapata | Texas | 48505 | 3676 | 55 |
2408020 | 2408020 | 2022-04-14 | Zapata | Texas | 48505 | 3676 | 55 |
2404764 | 2404764 | 2022-04-13 | Zapata | Texas | 48505 | 3676 | 55 |
2401509 | 2401509 | 2022-04-12 | Zapata | Texas | 48505 | 3676 | 55 |
2398254 | 2398254 | 2022-04-11 | Zapata | Texas | 48505 | 3676 | 55 |
2394999 | 2394999 | 2022-04-10 | Zapata | Texas | 48505 | 3674 | 55 |
2391743 | 2391743 | 2022-04-09 | Zapata | Texas | 48505 | 3674 | 55 |
2388487 | 2388487 | 2022-04-08 | Zapata | Texas | 48505 | 3674 | 54 |
2385232 | 2385232 | 2022-04-07 | Zapata | Texas | 48505 | 3674 | 54 |
2381977 | 2381977 | 2022-04-06 | Zapata | Texas | 48505 | 3673 | 53 |
2378722 | 2378722 | 2022-04-05 | Zapata | Texas | 48505 | 3673 | 53 |
2375468 | 2375468 | 2022-04-04 | Zapata | Texas | 48505 | 3672 | 53 |
2372216 | 2372216 | 2022-04-03 | Zapata | Texas | 48505 | 3672 | 53 |
2368963 | 2368963 | 2022-04-02 | Zapata | Texas | 48505 | 3671 | 53 |
2365710 | 2365710 | 2022-04-01 | Zapata | Texas | 48505 | 3670 | 53 |
2362457 | 2362457 | 2022-03-31 | Zapata | Texas | 48505 | 3670 | 53 |
2359203 | 2359203 | 2022-03-30 | Zapata | Texas | 48505 | 3670 | 53 |
2355949 | 2355949 | 2022-03-29 | Zapata | Texas | 48505 | 3669 | 53 |
2352696 | 2352696 | 2022-03-28 | Zapata | Texas | 48505 | 3669 | 53 |
2349444 | 2349444 | 2022-03-27 | Zapata | Texas | 48505 | 3669 | 53 |
2346191 | 2346191 | 2022-03-26 | Zapata | Texas | 48505 | 3669 | 53 |
2342938 | 2342938 | 2022-03-25 | Zapata | Texas | 48505 | 3669 | 53 |
2339685 | 2339685 | 2022-03-24 | Zapata | Texas | 48505 | 3667 | 52 |
2336431 | 2336431 | 2022-03-23 | Zapata | Texas | 48505 | 3667 | 52 |
2333177 | 2333177 | 2022-03-22 | Zapata | Texas | 48505 | 3665 | 52 |
2329924 | 2329924 | 2022-03-21 | Zapata | Texas | 48505 | 3665 | 52 |
2326672 | 2326672 | 2022-03-20 | Zapata | Texas | 48505 | 3665 | 52 |
2323419 | 2323419 | 2022-03-19 | Zapata | Texas | 48505 | 3664 | 52 |
2320165 | 2320165 | 2022-03-18 | Zapata | Texas | 48505 | 3664 | 52 |
2316911 | 2316911 | 2022-03-17 | Zapata | Texas | 48505 | 3664 | 52 |
2313658 | 2313658 | 2022-03-16 | Zapata | Texas | 48505 | 3663 | 52 |
2310405 | 2310405 | 2022-03-15 | Zapata | Texas | 48505 | 3663 | 52 |
2307152 | 2307152 | 2022-03-14 | Zapata | Texas | 48505 | 3661 | 52 |
2303901 | 2303901 | 2022-03-13 | Zapata | Texas | 48505 | 3661 | 52 |
2300649 | 2300649 | 2022-03-12 | Zapata | Texas | 48505 | 3661 | 52 |
2297397 | 2297397 | 2022-03-11 | Zapata | Texas | 48505 | 3661 | 52 |
2294145 | 2294145 | 2022-03-10 | Zapata | Texas | 48505 | 3660 | 52 |
2290893 | 2290893 | 2022-03-09 | Zapata | Texas | 48505 | 3658 | 52 |
2287641 | 2287641 | 2022-03-08 | Zapata | Texas | 48505 | 3652 | 52 |
2284389 | 2284389 | 2022-03-07 | Zapata | Texas | 48505 | 3652 | 52 |
2281137 | 2281137 | 2022-03-06 | Zapata | Texas | 48505 | 3651 | 52 |
2277884 | 2277884 | 2022-03-05 | Zapata | Texas | 48505 | 3649 | 52 |
2274631 | 2274631 | 2022-03-04 | Zapata | Texas | 48505 | 3645 | 52 |
2271378 | 2271378 | 2022-03-03 | Zapata | Texas | 48505 | 3639 | 52 |
2268126 | 2268126 | 2022-03-02 | Zapata | Texas | 48505 | 3634 | 52 |
2264873 | 2264873 | 2022-03-01 | Zapata | Texas | 48505 | 3631 | 52 |
2261623 | 2261623 | 2022-02-28 | Zapata | Texas | 48505 | 3624 | 52 |
2258372 | 2258372 | 2022-02-27 | Zapata | Texas | 48505 | 3621 | 52 |
2255121 | 2255121 | 2022-02-26 | Zapata | Texas | 48505 | 3613 | 52 |
2251870 | 2251870 | 2022-02-25 | Zapata | Texas | 48505 | 3603 | 52 |
2248619 | 2248619 | 2022-02-24 | Zapata | Texas | 48505 | 3566 | 52 |
2245368 | 2245368 | 2022-02-23 | Zapata | Texas | 48505 | 3535 | 51 |
2242117 | 2242117 | 2022-02-22 | Zapata | Texas | 48505 | 3512 | 50 |
2238866 | 2238866 | 2022-02-21 | Zapata | Texas | 48505 | 3508 | 50 |
2235615 | 2235615 | 2022-02-20 | Zapata | Texas | 48505 | 3503 | 50 |
2232364 | 2232364 | 2022-02-19 | Zapata | Texas | 48505 | 3498 | 50 |
2229113 | 2229113 | 2022-02-18 | Zapata | Texas | 48505 | 3480 | 50 |
2225862 | 2225862 | 2022-02-17 | Zapata | Texas | 48505 | 3474 | 49 |
2222611 | 2222611 | 2022-02-16 | Zapata | Texas | 48505 | 3448 | 49 |
2219360 | 2219360 | 2022-02-15 | Zapata | Texas | 48505 | 3387 | 49 |
2216109 | 2216109 | 2022-02-14 | Zapata | Texas | 48505 | 3375 | 49 |
2212858 | 2212858 | 2022-02-13 | Zapata | Texas | 48505 | 3341 | 49 |
2209605 | 2209605 | 2022-02-12 | Zapata | Texas | 48505 | 3335 | 48 |
2206352 | 2206352 | 2022-02-11 | Zapata | Texas | 48505 | 3320 | 48 |
2203099 | 2203099 | 2022-02-10 | Zapata | Texas | 48505 | 3289 | 48 |
2199845 | 2199845 | 2022-02-09 | Zapata | Texas | 48505 | 3256 | 48 |
2196591 | 2196591 | 2022-02-08 | Zapata | Texas | 48505 | 3223 | 47 |
2193337 | 2193337 | 2022-02-07 | Zapata | Texas | 48505 | 3209 | 47 |
2190084 | 2190084 | 2022-02-06 | Zapata | Texas | 48505 | 3167 | 47 |
2186831 | 2186831 | 2022-02-05 | Zapata | Texas | 48505 | 3141 | 47 |
2183578 | 2183578 | 2022-02-04 | Zapata | Texas | 48505 | 3078 | 47 |
2180326 | 2180326 | 2022-02-03 | Zapata | Texas | 48505 | 3030 | 47 |
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);