ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
687 rows where county = "Jeff Davis", fips = 48243 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 |
---|---|---|---|---|---|---|---|
2502328 | 2502328 | 2022-05-13 | Jeff Davis | Texas | 48243 | 224 | 9 |
2499070 | 2499070 | 2022-05-12 | Jeff Davis | Texas | 48243 | 224 | 9 |
2495812 | 2495812 | 2022-05-11 | Jeff Davis | Texas | 48243 | 224 | 9 |
2492554 | 2492554 | 2022-05-10 | Jeff Davis | Texas | 48243 | 223 | 9 |
2489296 | 2489296 | 2022-05-09 | Jeff Davis | Texas | 48243 | 223 | 9 |
2486039 | 2486039 | 2022-05-08 | Jeff Davis | Texas | 48243 | 223 | 9 |
2482781 | 2482781 | 2022-05-07 | Jeff Davis | Texas | 48243 | 223 | 9 |
2479523 | 2479523 | 2022-05-06 | Jeff Davis | Texas | 48243 | 223 | 9 |
2476265 | 2476265 | 2022-05-05 | Jeff Davis | Texas | 48243 | 223 | 9 |
2473008 | 2473008 | 2022-05-04 | Jeff Davis | Texas | 48243 | 223 | 9 |
2469752 | 2469752 | 2022-05-03 | Jeff Davis | Texas | 48243 | 223 | 9 |
2466496 | 2466496 | 2022-05-02 | Jeff Davis | Texas | 48243 | 223 | 9 |
2463241 | 2463241 | 2022-05-01 | Jeff Davis | Texas | 48243 | 223 | 9 |
2459985 | 2459985 | 2022-04-30 | Jeff Davis | Texas | 48243 | 223 | 9 |
2456729 | 2456729 | 2022-04-29 | Jeff Davis | Texas | 48243 | 223 | 9 |
2453473 | 2453473 | 2022-04-28 | Jeff Davis | Texas | 48243 | 223 | 9 |
2450217 | 2450217 | 2022-04-27 | Jeff Davis | Texas | 48243 | 223 | 9 |
2446960 | 2446960 | 2022-04-26 | Jeff Davis | Texas | 48243 | 223 | 9 |
2443705 | 2443705 | 2022-04-25 | Jeff Davis | Texas | 48243 | 223 | 9 |
2440449 | 2440449 | 2022-04-24 | Jeff Davis | Texas | 48243 | 223 | 9 |
2437193 | 2437193 | 2022-04-23 | Jeff Davis | Texas | 48243 | 223 | 9 |
2433937 | 2433937 | 2022-04-22 | Jeff Davis | Texas | 48243 | 223 | 9 |
2430681 | 2430681 | 2022-04-21 | Jeff Davis | Texas | 48243 | 223 | 9 |
2427425 | 2427425 | 2022-04-20 | Jeff Davis | Texas | 48243 | 223 | 9 |
2424169 | 2424169 | 2022-04-19 | Jeff Davis | Texas | 48243 | 223 | 9 |
2420913 | 2420913 | 2022-04-18 | Jeff Davis | Texas | 48243 | 223 | 9 |
2417657 | 2417657 | 2022-04-17 | Jeff Davis | Texas | 48243 | 223 | 9 |
2414401 | 2414401 | 2022-04-16 | Jeff Davis | Texas | 48243 | 223 | 9 |
2411145 | 2411145 | 2022-04-15 | Jeff Davis | Texas | 48243 | 223 | 9 |
2407889 | 2407889 | 2022-04-14 | Jeff Davis | Texas | 48243 | 223 | 9 |
2404633 | 2404633 | 2022-04-13 | Jeff Davis | Texas | 48243 | 223 | 9 |
2401378 | 2401378 | 2022-04-12 | Jeff Davis | Texas | 48243 | 223 | 9 |
2398123 | 2398123 | 2022-04-11 | Jeff Davis | Texas | 48243 | 223 | 9 |
2394868 | 2394868 | 2022-04-10 | Jeff Davis | Texas | 48243 | 223 | 9 |
2391612 | 2391612 | 2022-04-09 | Jeff Davis | Texas | 48243 | 223 | 9 |
2388356 | 2388356 | 2022-04-08 | Jeff Davis | Texas | 48243 | 223 | 9 |
2385101 | 2385101 | 2022-04-07 | Jeff Davis | Texas | 48243 | 223 | 9 |
2381846 | 2381846 | 2022-04-06 | Jeff Davis | Texas | 48243 | 223 | 9 |
2378591 | 2378591 | 2022-04-05 | Jeff Davis | Texas | 48243 | 223 | 9 |
2375337 | 2375337 | 2022-04-04 | Jeff Davis | Texas | 48243 | 223 | 9 |
2372085 | 2372085 | 2022-04-03 | Jeff Davis | Texas | 48243 | 223 | 9 |
2368832 | 2368832 | 2022-04-02 | Jeff Davis | Texas | 48243 | 223 | 9 |
2365579 | 2365579 | 2022-04-01 | Jeff Davis | Texas | 48243 | 223 | 9 |
2362326 | 2362326 | 2022-03-31 | Jeff Davis | Texas | 48243 | 223 | 9 |
2359072 | 2359072 | 2022-03-30 | Jeff Davis | Texas | 48243 | 223 | 9 |
2355818 | 2355818 | 2022-03-29 | Jeff Davis | Texas | 48243 | 223 | 9 |
2352565 | 2352565 | 2022-03-28 | Jeff Davis | Texas | 48243 | 223 | 9 |
2349313 | 2349313 | 2022-03-27 | Jeff Davis | Texas | 48243 | 223 | 9 |
2346060 | 2346060 | 2022-03-26 | Jeff Davis | Texas | 48243 | 223 | 9 |
2342807 | 2342807 | 2022-03-25 | Jeff Davis | Texas | 48243 | 223 | 9 |
2339554 | 2339554 | 2022-03-24 | Jeff Davis | Texas | 48243 | 223 | 9 |
2336300 | 2336300 | 2022-03-23 | Jeff Davis | Texas | 48243 | 221 | 9 |
2333046 | 2333046 | 2022-03-22 | Jeff Davis | Texas | 48243 | 221 | 9 |
2329793 | 2329793 | 2022-03-21 | Jeff Davis | Texas | 48243 | 221 | 9 |
2326541 | 2326541 | 2022-03-20 | Jeff Davis | Texas | 48243 | 221 | 9 |
2323288 | 2323288 | 2022-03-19 | Jeff Davis | Texas | 48243 | 221 | 9 |
2320034 | 2320034 | 2022-03-18 | Jeff Davis | Texas | 48243 | 221 | 9 |
2316780 | 2316780 | 2022-03-17 | Jeff Davis | Texas | 48243 | 221 | 9 |
2313527 | 2313527 | 2022-03-16 | Jeff Davis | Texas | 48243 | 221 | 9 |
2310274 | 2310274 | 2022-03-15 | Jeff Davis | Texas | 48243 | 221 | 9 |
2307021 | 2307021 | 2022-03-14 | Jeff Davis | Texas | 48243 | 221 | 9 |
2303770 | 2303770 | 2022-03-13 | Jeff Davis | Texas | 48243 | 221 | 9 |
2300518 | 2300518 | 2022-03-12 | Jeff Davis | Texas | 48243 | 221 | 9 |
2297266 | 2297266 | 2022-03-11 | Jeff Davis | Texas | 48243 | 221 | 9 |
2294014 | 2294014 | 2022-03-10 | Jeff Davis | Texas | 48243 | 221 | 9 |
2290762 | 2290762 | 2022-03-09 | Jeff Davis | Texas | 48243 | 221 | 9 |
2287510 | 2287510 | 2022-03-08 | Jeff Davis | Texas | 48243 | 221 | 9 |
2284258 | 2284258 | 2022-03-07 | Jeff Davis | Texas | 48243 | 221 | 9 |
2281006 | 2281006 | 2022-03-06 | Jeff Davis | Texas | 48243 | 221 | 9 |
2277753 | 2277753 | 2022-03-05 | Jeff Davis | Texas | 48243 | 221 | 9 |
2274500 | 2274500 | 2022-03-04 | Jeff Davis | Texas | 48243 | 221 | 9 |
2271247 | 2271247 | 2022-03-03 | Jeff Davis | Texas | 48243 | 221 | 9 |
2267995 | 2267995 | 2022-03-02 | Jeff Davis | Texas | 48243 | 221 | 9 |
2264742 | 2264742 | 2022-03-01 | Jeff Davis | Texas | 48243 | 221 | 9 |
2261492 | 2261492 | 2022-02-28 | Jeff Davis | Texas | 48243 | 221 | 9 |
2258241 | 2258241 | 2022-02-27 | Jeff Davis | Texas | 48243 | 221 | 9 |
2254990 | 2254990 | 2022-02-26 | Jeff Davis | Texas | 48243 | 221 | 9 |
2251739 | 2251739 | 2022-02-25 | Jeff Davis | Texas | 48243 | 221 | 9 |
2248488 | 2248488 | 2022-02-24 | Jeff Davis | Texas | 48243 | 221 | 9 |
2245237 | 2245237 | 2022-02-23 | Jeff Davis | Texas | 48243 | 221 | 9 |
2241986 | 2241986 | 2022-02-22 | Jeff Davis | Texas | 48243 | 221 | 9 |
2238735 | 2238735 | 2022-02-21 | Jeff Davis | Texas | 48243 | 221 | 9 |
2235484 | 2235484 | 2022-02-20 | Jeff Davis | Texas | 48243 | 221 | 9 |
2232233 | 2232233 | 2022-02-19 | Jeff Davis | Texas | 48243 | 221 | 9 |
2228982 | 2228982 | 2022-02-18 | Jeff Davis | Texas | 48243 | 220 | 9 |
2225731 | 2225731 | 2022-02-17 | Jeff Davis | Texas | 48243 | 219 | 9 |
2222480 | 2222480 | 2022-02-16 | Jeff Davis | Texas | 48243 | 219 | 9 |
2219229 | 2219229 | 2022-02-15 | Jeff Davis | Texas | 48243 | 218 | 9 |
2215978 | 2215978 | 2022-02-14 | Jeff Davis | Texas | 48243 | 218 | 9 |
2212727 | 2212727 | 2022-02-13 | Jeff Davis | Texas | 48243 | 218 | 9 |
2209474 | 2209474 | 2022-02-12 | Jeff Davis | Texas | 48243 | 218 | 9 |
2206221 | 2206221 | 2022-02-11 | Jeff Davis | Texas | 48243 | 218 | 9 |
2202968 | 2202968 | 2022-02-10 | Jeff Davis | Texas | 48243 | 218 | 9 |
2199714 | 2199714 | 2022-02-09 | Jeff Davis | Texas | 48243 | 218 | 8 |
2196460 | 2196460 | 2022-02-08 | Jeff Davis | Texas | 48243 | 217 | 8 |
2193206 | 2193206 | 2022-02-07 | Jeff Davis | Texas | 48243 | 217 | 8 |
2189952 | 2189952 | 2022-02-06 | Jeff Davis | Texas | 48243 | 217 | 8 |
2186699 | 2186699 | 2022-02-05 | Jeff Davis | Texas | 48243 | 217 | 8 |
2183447 | 2183447 | 2022-02-04 | Jeff Davis | Texas | 48243 | 217 | 8 |
2180195 | 2180195 | 2022-02-03 | Jeff Davis | Texas | 48243 | 216 | 8 |
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);