ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
46 rows where county = "Guadalupe", deaths = 398 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502300 | 2502300 | 2022-05-13 | Guadalupe | Texas | 48187 | 38361 | 398 |
2499042 | 2499042 | 2022-05-12 | Guadalupe | Texas | 48187 | 38338 | 398 |
2495784 | 2495784 | 2022-05-11 | Guadalupe | Texas | 48187 | 38319 | 398 |
2492526 | 2492526 | 2022-05-10 | Guadalupe | Texas | 48187 | 38304 | 398 |
2489268 | 2489268 | 2022-05-09 | Guadalupe | Texas | 48187 | 38290 | 398 |
2486011 | 2486011 | 2022-05-08 | Guadalupe | Texas | 48187 | 38285 | 398 |
2482753 | 2482753 | 2022-05-07 | Guadalupe | Texas | 48187 | 38277 | 398 |
2479495 | 2479495 | 2022-05-06 | Guadalupe | Texas | 48187 | 38263 | 398 |
2476237 | 2476237 | 2022-05-05 | Guadalupe | Texas | 48187 | 38254 | 398 |
2472980 | 2472980 | 2022-05-04 | Guadalupe | Texas | 48187 | 38252 | 398 |
2469724 | 2469724 | 2022-05-03 | Guadalupe | Texas | 48187 | 38239 | 398 |
2466468 | 2466468 | 2022-05-02 | Guadalupe | Texas | 48187 | 38232 | 398 |
2463213 | 2463213 | 2022-05-01 | Guadalupe | Texas | 48187 | 38226 | 398 |
2459957 | 2459957 | 2022-04-30 | Guadalupe | Texas | 48187 | 38223 | 398 |
2456701 | 2456701 | 2022-04-29 | Guadalupe | Texas | 48187 | 38212 | 398 |
2453445 | 2453445 | 2022-04-28 | Guadalupe | Texas | 48187 | 38189 | 398 |
2450189 | 2450189 | 2022-04-27 | Guadalupe | Texas | 48187 | 38169 | 398 |
2446932 | 2446932 | 2022-04-26 | Guadalupe | Texas | 48187 | 38165 | 398 |
2443677 | 2443677 | 2022-04-25 | Guadalupe | Texas | 48187 | 38162 | 398 |
2440421 | 2440421 | 2022-04-24 | Guadalupe | Texas | 48187 | 38159 | 398 |
2437165 | 2437165 | 2022-04-23 | Guadalupe | Texas | 48187 | 38152 | 398 |
2433909 | 2433909 | 2022-04-22 | Guadalupe | Texas | 48187 | 38147 | 398 |
2430653 | 2430653 | 2022-04-21 | Guadalupe | Texas | 48187 | 38142 | 398 |
2427397 | 2427397 | 2022-04-20 | Guadalupe | Texas | 48187 | 38139 | 398 |
2424141 | 2424141 | 2022-04-19 | Guadalupe | Texas | 48187 | 38121 | 398 |
2420885 | 2420885 | 2022-04-18 | Guadalupe | Texas | 48187 | 38116 | 398 |
2417629 | 2417629 | 2022-04-17 | Guadalupe | Texas | 48187 | 38090 | 398 |
2414373 | 2414373 | 2022-04-16 | Guadalupe | Texas | 48187 | 38090 | 398 |
2411117 | 2411117 | 2022-04-15 | Guadalupe | Texas | 48187 | 38090 | 398 |
2407861 | 2407861 | 2022-04-14 | Guadalupe | Texas | 48187 | 38090 | 398 |
2404605 | 2404605 | 2022-04-13 | Guadalupe | Texas | 48187 | 38086 | 398 |
2401350 | 2401350 | 2022-04-12 | Guadalupe | Texas | 48187 | 38079 | 398 |
2398095 | 2398095 | 2022-04-11 | Guadalupe | Texas | 48187 | 38070 | 398 |
2394840 | 2394840 | 2022-04-10 | Guadalupe | Texas | 48187 | 38070 | 398 |
2391584 | 2391584 | 2022-04-09 | Guadalupe | Texas | 48187 | 38065 | 398 |
2388328 | 2388328 | 2022-04-08 | Guadalupe | Texas | 48187 | 38045 | 398 |
2385073 | 2385073 | 2022-04-07 | Guadalupe | Texas | 48187 | 37999 | 398 |
2381818 | 2381818 | 2022-04-06 | Guadalupe | Texas | 48187 | 37995 | 398 |
2378563 | 2378563 | 2022-04-05 | Guadalupe | Texas | 48187 | 37994 | 398 |
2375309 | 2375309 | 2022-04-04 | Guadalupe | Texas | 48187 | 37988 | 398 |
2372057 | 2372057 | 2022-04-03 | Guadalupe | Texas | 48187 | 37985 | 398 |
2368804 | 2368804 | 2022-04-02 | Guadalupe | Texas | 48187 | 37971 | 398 |
2365551 | 2365551 | 2022-04-01 | Guadalupe | Texas | 48187 | 37968 | 398 |
2362298 | 2362298 | 2022-03-31 | Guadalupe | Texas | 48187 | 37964 | 398 |
2359044 | 2359044 | 2022-03-30 | Guadalupe | Texas | 48187 | 37963 | 398 |
2355790 | 2355790 | 2022-03-29 | Guadalupe | Texas | 48187 | 37946 | 398 |
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);