ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
704 rows where fips = 48425 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502420 | 2502420 | 2022-05-13 | Somervell | Texas | 48425 | 2116 | 36 |
2499162 | 2499162 | 2022-05-12 | Somervell | Texas | 48425 | 2116 | 36 |
2495904 | 2495904 | 2022-05-11 | Somervell | Texas | 48425 | 2116 | 36 |
2492646 | 2492646 | 2022-05-10 | Somervell | Texas | 48425 | 2116 | 36 |
2489388 | 2489388 | 2022-05-09 | Somervell | Texas | 48425 | 2115 | 36 |
2486130 | 2486130 | 2022-05-08 | Somervell | Texas | 48425 | 2115 | 36 |
2482872 | 2482872 | 2022-05-07 | Somervell | Texas | 48425 | 2115 | 36 |
2479614 | 2479614 | 2022-05-06 | Somervell | Texas | 48425 | 2115 | 36 |
2476356 | 2476356 | 2022-05-05 | Somervell | Texas | 48425 | 2115 | 36 |
2473099 | 2473099 | 2022-05-04 | Somervell | Texas | 48425 | 2115 | 36 |
2469843 | 2469843 | 2022-05-03 | Somervell | Texas | 48425 | 2114 | 36 |
2466587 | 2466587 | 2022-05-02 | Somervell | Texas | 48425 | 2114 | 36 |
2463332 | 2463332 | 2022-05-01 | Somervell | Texas | 48425 | 2114 | 36 |
2460076 | 2460076 | 2022-04-30 | Somervell | Texas | 48425 | 2114 | 36 |
2456820 | 2456820 | 2022-04-29 | Somervell | Texas | 48425 | 2113 | 36 |
2453564 | 2453564 | 2022-04-28 | Somervell | Texas | 48425 | 2113 | 36 |
2450308 | 2450308 | 2022-04-27 | Somervell | Texas | 48425 | 2113 | 36 |
2447051 | 2447051 | 2022-04-26 | Somervell | Texas | 48425 | 2113 | 36 |
2443796 | 2443796 | 2022-04-25 | Somervell | Texas | 48425 | 2113 | 36 |
2440540 | 2440540 | 2022-04-24 | Somervell | Texas | 48425 | 2113 | 36 |
2437284 | 2437284 | 2022-04-23 | Somervell | Texas | 48425 | 2113 | 36 |
2434028 | 2434028 | 2022-04-22 | Somervell | Texas | 48425 | 2112 | 36 |
2430772 | 2430772 | 2022-04-21 | Somervell | Texas | 48425 | 2111 | 36 |
2427516 | 2427516 | 2022-04-20 | Somervell | Texas | 48425 | 2111 | 36 |
2424260 | 2424260 | 2022-04-19 | Somervell | Texas | 48425 | 2111 | 36 |
2421004 | 2421004 | 2022-04-18 | Somervell | Texas | 48425 | 2111 | 36 |
2417748 | 2417748 | 2022-04-17 | Somervell | Texas | 48425 | 2110 | 36 |
2414492 | 2414492 | 2022-04-16 | Somervell | Texas | 48425 | 2110 | 36 |
2411236 | 2411236 | 2022-04-15 | Somervell | Texas | 48425 | 2110 | 36 |
2407980 | 2407980 | 2022-04-14 | Somervell | Texas | 48425 | 2110 | 36 |
2404724 | 2404724 | 2022-04-13 | Somervell | Texas | 48425 | 2110 | 36 |
2401469 | 2401469 | 2022-04-12 | Somervell | Texas | 48425 | 2110 | 36 |
2398214 | 2398214 | 2022-04-11 | Somervell | Texas | 48425 | 2110 | 36 |
2394959 | 2394959 | 2022-04-10 | Somervell | Texas | 48425 | 2110 | 36 |
2391703 | 2391703 | 2022-04-09 | Somervell | Texas | 48425 | 2110 | 36 |
2388447 | 2388447 | 2022-04-08 | Somervell | Texas | 48425 | 2109 | 36 |
2385192 | 2385192 | 2022-04-07 | Somervell | Texas | 48425 | 2109 | 36 |
2381937 | 2381937 | 2022-04-06 | Somervell | Texas | 48425 | 2108 | 36 |
2378682 | 2378682 | 2022-04-05 | Somervell | Texas | 48425 | 2108 | 36 |
2375428 | 2375428 | 2022-04-04 | Somervell | Texas | 48425 | 2108 | 36 |
2372176 | 2372176 | 2022-04-03 | Somervell | Texas | 48425 | 2108 | 36 |
2368923 | 2368923 | 2022-04-02 | Somervell | Texas | 48425 | 2108 | 36 |
2365670 | 2365670 | 2022-04-01 | Somervell | Texas | 48425 | 2108 | 36 |
2362417 | 2362417 | 2022-03-31 | Somervell | Texas | 48425 | 2107 | 36 |
2359163 | 2359163 | 2022-03-30 | Somervell | Texas | 48425 | 2107 | 36 |
2355909 | 2355909 | 2022-03-29 | Somervell | Texas | 48425 | 2107 | 36 |
2352656 | 2352656 | 2022-03-28 | Somervell | Texas | 48425 | 2107 | 36 |
2349404 | 2349404 | 2022-03-27 | Somervell | Texas | 48425 | 2107 | 36 |
2346151 | 2346151 | 2022-03-26 | Somervell | Texas | 48425 | 2107 | 36 |
2342898 | 2342898 | 2022-03-25 | Somervell | Texas | 48425 | 2106 | 36 |
2339645 | 2339645 | 2022-03-24 | Somervell | Texas | 48425 | 2105 | 35 |
2336391 | 2336391 | 2022-03-23 | Somervell | Texas | 48425 | 2105 | 35 |
2333137 | 2333137 | 2022-03-22 | Somervell | Texas | 48425 | 2105 | 35 |
2329884 | 2329884 | 2022-03-21 | Somervell | Texas | 48425 | 2105 | 35 |
2326632 | 2326632 | 2022-03-20 | Somervell | Texas | 48425 | 2105 | 35 |
2323379 | 2323379 | 2022-03-19 | Somervell | Texas | 48425 | 2103 | 35 |
2320125 | 2320125 | 2022-03-18 | Somervell | Texas | 48425 | 2103 | 35 |
2316871 | 2316871 | 2022-03-17 | Somervell | Texas | 48425 | 2103 | 35 |
2313618 | 2313618 | 2022-03-16 | Somervell | Texas | 48425 | 2103 | 35 |
2310365 | 2310365 | 2022-03-15 | Somervell | Texas | 48425 | 2103 | 35 |
2307112 | 2307112 | 2022-03-14 | Somervell | Texas | 48425 | 2103 | 35 |
2303861 | 2303861 | 2022-03-13 | Somervell | Texas | 48425 | 2103 | 35 |
2300609 | 2300609 | 2022-03-12 | Somervell | Texas | 48425 | 2103 | 35 |
2297357 | 2297357 | 2022-03-11 | Somervell | Texas | 48425 | 2103 | 35 |
2294105 | 2294105 | 2022-03-10 | Somervell | Texas | 48425 | 2103 | 35 |
2290853 | 2290853 | 2022-03-09 | Somervell | Texas | 48425 | 2103 | 35 |
2287601 | 2287601 | 2022-03-08 | Somervell | Texas | 48425 | 2102 | 35 |
2284349 | 2284349 | 2022-03-07 | Somervell | Texas | 48425 | 2102 | 35 |
2281097 | 2281097 | 2022-03-06 | Somervell | Texas | 48425 | 2101 | 35 |
2277844 | 2277844 | 2022-03-05 | Somervell | Texas | 48425 | 2101 | 35 |
2274591 | 2274591 | 2022-03-04 | Somervell | Texas | 48425 | 2101 | 35 |
2271338 | 2271338 | 2022-03-03 | Somervell | Texas | 48425 | 2101 | 35 |
2268086 | 2268086 | 2022-03-02 | Somervell | Texas | 48425 | 2101 | 35 |
2264833 | 2264833 | 2022-03-01 | Somervell | Texas | 48425 | 2099 | 35 |
2261583 | 2261583 | 2022-02-28 | Somervell | Texas | 48425 | 2099 | 35 |
2258332 | 2258332 | 2022-02-27 | Somervell | Texas | 48425 | 2095 | 34 |
2255081 | 2255081 | 2022-02-26 | Somervell | Texas | 48425 | 2095 | 34 |
2251830 | 2251830 | 2022-02-25 | Somervell | Texas | 48425 | 2095 | 34 |
2248579 | 2248579 | 2022-02-24 | Somervell | Texas | 48425 | 2095 | 34 |
2245328 | 2245328 | 2022-02-23 | Somervell | Texas | 48425 | 2093 | 34 |
2242077 | 2242077 | 2022-02-22 | Somervell | Texas | 48425 | 2093 | 34 |
2238826 | 2238826 | 2022-02-21 | Somervell | Texas | 48425 | 2092 | 34 |
2235575 | 2235575 | 2022-02-20 | Somervell | Texas | 48425 | 2087 | 34 |
2232324 | 2232324 | 2022-02-19 | Somervell | Texas | 48425 | 2086 | 34 |
2229073 | 2229073 | 2022-02-18 | Somervell | Texas | 48425 | 2086 | 33 |
2225822 | 2225822 | 2022-02-17 | Somervell | Texas | 48425 | 2086 | 33 |
2222571 | 2222571 | 2022-02-16 | Somervell | Texas | 48425 | 2082 | 32 |
2219320 | 2219320 | 2022-02-15 | Somervell | Texas | 48425 | 2082 | 32 |
2216069 | 2216069 | 2022-02-14 | Somervell | Texas | 48425 | 2079 | 32 |
2212818 | 2212818 | 2022-02-13 | Somervell | Texas | 48425 | 2075 | 32 |
2209565 | 2209565 | 2022-02-12 | Somervell | Texas | 48425 | 2069 | 31 |
2206312 | 2206312 | 2022-02-11 | Somervell | Texas | 48425 | 2067 | 31 |
2203059 | 2203059 | 2022-02-10 | Somervell | Texas | 48425 | 2063 | 31 |
2199805 | 2199805 | 2022-02-09 | Somervell | Texas | 48425 | 2060 | 31 |
2196551 | 2196551 | 2022-02-08 | Somervell | Texas | 48425 | 2054 | 31 |
2193297 | 2193297 | 2022-02-07 | Somervell | Texas | 48425 | 2053 | 31 |
2190043 | 2190043 | 2022-02-06 | Somervell | Texas | 48425 | 2043 | 31 |
2186790 | 2186790 | 2022-02-05 | Somervell | Texas | 48425 | 2030 | 31 |
2183538 | 2183538 | 2022-02-04 | Somervell | Texas | 48425 | 2029 | 31 |
2180286 | 2180286 | 2022-02-03 | Somervell | Texas | 48425 | 2021 | 31 |
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);