ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Guadalupe", fips = 48187 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 |
---|---|---|---|---|---|---|---|
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 |
2352537 | 2352537 | 2022-03-28 | Guadalupe | Texas | 48187 | 37928 | 397 |
2349285 | 2349285 | 2022-03-27 | Guadalupe | Texas | 48187 | 37928 | 397 |
2346032 | 2346032 | 2022-03-26 | Guadalupe | Texas | 48187 | 37927 | 397 |
2342779 | 2342779 | 2022-03-25 | Guadalupe | Texas | 48187 | 37879 | 397 |
2339526 | 2339526 | 2022-03-24 | Guadalupe | Texas | 48187 | 37871 | 397 |
2336272 | 2336272 | 2022-03-23 | Guadalupe | Texas | 48187 | 37854 | 397 |
2333018 | 2333018 | 2022-03-22 | Guadalupe | Texas | 48187 | 37849 | 397 |
2329765 | 2329765 | 2022-03-21 | Guadalupe | Texas | 48187 | 37813 | 396 |
2326513 | 2326513 | 2022-03-20 | Guadalupe | Texas | 48187 | 37811 | 396 |
2323260 | 2323260 | 2022-03-19 | Guadalupe | Texas | 48187 | 37804 | 396 |
2320006 | 2320006 | 2022-03-18 | Guadalupe | Texas | 48187 | 37799 | 396 |
2316752 | 2316752 | 2022-03-17 | Guadalupe | Texas | 48187 | 37754 | 396 |
2313499 | 2313499 | 2022-03-16 | Guadalupe | Texas | 48187 | 37695 | 396 |
2310246 | 2310246 | 2022-03-15 | Guadalupe | Texas | 48187 | 37659 | 396 |
2306993 | 2306993 | 2022-03-14 | Guadalupe | Texas | 48187 | 37618 | 396 |
2303742 | 2303742 | 2022-03-13 | Guadalupe | Texas | 48187 | 37614 | 396 |
2300490 | 2300490 | 2022-03-12 | Guadalupe | Texas | 48187 | 37612 | 395 |
2297238 | 2297238 | 2022-03-11 | Guadalupe | Texas | 48187 | 37592 | 394 |
2293986 | 2293986 | 2022-03-10 | Guadalupe | Texas | 48187 | 37185 | 393 |
2290734 | 2290734 | 2022-03-09 | Guadalupe | Texas | 48187 | 37088 | 392 |
2287482 | 2287482 | 2022-03-08 | Guadalupe | Texas | 48187 | 37042 | 390 |
2284230 | 2284230 | 2022-03-07 | Guadalupe | Texas | 48187 | 36854 | 390 |
2280978 | 2280978 | 2022-03-06 | Guadalupe | Texas | 48187 | 36847 | 389 |
2277725 | 2277725 | 2022-03-05 | Guadalupe | Texas | 48187 | 36846 | 389 |
2274472 | 2274472 | 2022-03-04 | Guadalupe | Texas | 48187 | 36820 | 388 |
2271219 | 2271219 | 2022-03-03 | Guadalupe | Texas | 48187 | 36790 | 387 |
2267967 | 2267967 | 2022-03-02 | Guadalupe | Texas | 48187 | 36764 | 387 |
2264714 | 2264714 | 2022-03-01 | Guadalupe | Texas | 48187 | 36748 | 386 |
2261464 | 2261464 | 2022-02-28 | Guadalupe | Texas | 48187 | 36695 | 385 |
2258213 | 2258213 | 2022-02-27 | Guadalupe | Texas | 48187 | 36643 | 385 |
2254962 | 2254962 | 2022-02-26 | Guadalupe | Texas | 48187 | 36643 | 384 |
2251711 | 2251711 | 2022-02-25 | Guadalupe | Texas | 48187 | 36586 | 383 |
2248460 | 2248460 | 2022-02-24 | Guadalupe | Texas | 48187 | 36552 | 383 |
2245209 | 2245209 | 2022-02-23 | Guadalupe | Texas | 48187 | 36487 | 380 |
2241958 | 2241958 | 2022-02-22 | Guadalupe | Texas | 48187 | 36446 | 379 |
2238707 | 2238707 | 2022-02-21 | Guadalupe | Texas | 48187 | 36430 | 378 |
2235456 | 2235456 | 2022-02-20 | Guadalupe | Texas | 48187 | 36417 | 378 |
2232205 | 2232205 | 2022-02-19 | Guadalupe | Texas | 48187 | 36412 | 377 |
2228954 | 2228954 | 2022-02-18 | Guadalupe | Texas | 48187 | 36368 | 375 |
2225703 | 2225703 | 2022-02-17 | Guadalupe | Texas | 48187 | 36250 | 375 |
2222452 | 2222452 | 2022-02-16 | Guadalupe | Texas | 48187 | 36163 | 375 |
2219201 | 2219201 | 2022-02-15 | Guadalupe | Texas | 48187 | 36101 | 373 |
2215950 | 2215950 | 2022-02-14 | Guadalupe | Texas | 48187 | 36047 | 372 |
2212699 | 2212699 | 2022-02-13 | Guadalupe | Texas | 48187 | 36023 | 370 |
2209446 | 2209446 | 2022-02-12 | Guadalupe | Texas | 48187 | 35967 | 370 |
2206193 | 2206193 | 2022-02-11 | Guadalupe | Texas | 48187 | 35869 | 368 |
2202940 | 2202940 | 2022-02-10 | Guadalupe | Texas | 48187 | 35758 | 368 |
2199686 | 2199686 | 2022-02-09 | Guadalupe | Texas | 48187 | 35606 | 368 |
2196432 | 2196432 | 2022-02-08 | Guadalupe | Texas | 48187 | 35486 | 367 |
2193178 | 2193178 | 2022-02-07 | Guadalupe | Texas | 48187 | 35406 | 365 |
2189924 | 2189924 | 2022-02-06 | Guadalupe | Texas | 48187 | 35335 | 365 |
2186671 | 2186671 | 2022-02-05 | Guadalupe | Texas | 48187 | 35244 | 364 |
2183419 | 2183419 | 2022-02-04 | Guadalupe | Texas | 48187 | 34892 | 362 |
2180167 | 2180167 | 2022-02-03 | Guadalupe | Texas | 48187 | 34713 | 362 |
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);