ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,536 rows where county = "Guadalupe" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501404 | 2501404 | 2022-05-13 | Guadalupe | New Mexico | 35019 | 1482 | 17 |
2502300 | 2502300 | 2022-05-13 | Guadalupe | Texas | 48187 | 38361 | 398 |
2498146 | 2498146 | 2022-05-12 | Guadalupe | New Mexico | 35019 | 1481 | 17 |
2499042 | 2499042 | 2022-05-12 | Guadalupe | Texas | 48187 | 38338 | 398 |
2494888 | 2494888 | 2022-05-11 | Guadalupe | New Mexico | 35019 | 1481 | 17 |
2495784 | 2495784 | 2022-05-11 | Guadalupe | Texas | 48187 | 38319 | 398 |
2491630 | 2491630 | 2022-05-10 | Guadalupe | New Mexico | 35019 | 1481 | 17 |
2492526 | 2492526 | 2022-05-10 | Guadalupe | Texas | 48187 | 38304 | 398 |
2488372 | 2488372 | 2022-05-09 | Guadalupe | New Mexico | 35019 | 1481 | 17 |
2489268 | 2489268 | 2022-05-09 | Guadalupe | Texas | 48187 | 38290 | 398 |
2485115 | 2485115 | 2022-05-08 | Guadalupe | New Mexico | 35019 | 1482 | 17 |
2486011 | 2486011 | 2022-05-08 | Guadalupe | Texas | 48187 | 38285 | 398 |
2481857 | 2481857 | 2022-05-07 | Guadalupe | New Mexico | 35019 | 1482 | 17 |
2482753 | 2482753 | 2022-05-07 | Guadalupe | Texas | 48187 | 38277 | 398 |
2478599 | 2478599 | 2022-05-06 | Guadalupe | New Mexico | 35019 | 1482 | 17 |
2479495 | 2479495 | 2022-05-06 | Guadalupe | Texas | 48187 | 38263 | 398 |
2475341 | 2475341 | 2022-05-05 | Guadalupe | New Mexico | 35019 | 1482 | 17 |
2476237 | 2476237 | 2022-05-05 | Guadalupe | Texas | 48187 | 38254 | 398 |
2472084 | 2472084 | 2022-05-04 | Guadalupe | New Mexico | 35019 | 1482 | 17 |
2472980 | 2472980 | 2022-05-04 | Guadalupe | Texas | 48187 | 38252 | 398 |
2468828 | 2468828 | 2022-05-03 | Guadalupe | New Mexico | 35019 | 1482 | 17 |
2469724 | 2469724 | 2022-05-03 | Guadalupe | Texas | 48187 | 38239 | 398 |
2465572 | 2465572 | 2022-05-02 | Guadalupe | New Mexico | 35019 | 1482 | 17 |
2466468 | 2466468 | 2022-05-02 | Guadalupe | Texas | 48187 | 38232 | 398 |
2462317 | 2462317 | 2022-05-01 | Guadalupe | New Mexico | 35019 | 1482 | 17 |
2463213 | 2463213 | 2022-05-01 | Guadalupe | Texas | 48187 | 38226 | 398 |
2459061 | 2459061 | 2022-04-30 | Guadalupe | New Mexico | 35019 | 1482 | 17 |
2459957 | 2459957 | 2022-04-30 | Guadalupe | Texas | 48187 | 38223 | 398 |
2455805 | 2455805 | 2022-04-29 | Guadalupe | New Mexico | 35019 | 1482 | 17 |
2456701 | 2456701 | 2022-04-29 | Guadalupe | Texas | 48187 | 38212 | 398 |
2452549 | 2452549 | 2022-04-28 | Guadalupe | New Mexico | 35019 | 1480 | 17 |
2453445 | 2453445 | 2022-04-28 | Guadalupe | Texas | 48187 | 38189 | 398 |
2449293 | 2449293 | 2022-04-27 | Guadalupe | New Mexico | 35019 | 1480 | 17 |
2450189 | 2450189 | 2022-04-27 | Guadalupe | Texas | 48187 | 38169 | 398 |
2446036 | 2446036 | 2022-04-26 | Guadalupe | New Mexico | 35019 | 1480 | 17 |
2446932 | 2446932 | 2022-04-26 | Guadalupe | Texas | 48187 | 38165 | 398 |
2442781 | 2442781 | 2022-04-25 | Guadalupe | New Mexico | 35019 | 1480 | 17 |
2443677 | 2443677 | 2022-04-25 | Guadalupe | Texas | 48187 | 38162 | 398 |
2439525 | 2439525 | 2022-04-24 | Guadalupe | New Mexico | 35019 | 1479 | 17 |
2440421 | 2440421 | 2022-04-24 | Guadalupe | Texas | 48187 | 38159 | 398 |
2436269 | 2436269 | 2022-04-23 | Guadalupe | New Mexico | 35019 | 1479 | 17 |
2437165 | 2437165 | 2022-04-23 | Guadalupe | Texas | 48187 | 38152 | 398 |
2433013 | 2433013 | 2022-04-22 | Guadalupe | New Mexico | 35019 | 1479 | 17 |
2433909 | 2433909 | 2022-04-22 | Guadalupe | Texas | 48187 | 38147 | 398 |
2429757 | 2429757 | 2022-04-21 | Guadalupe | New Mexico | 35019 | 1479 | 17 |
2430653 | 2430653 | 2022-04-21 | Guadalupe | Texas | 48187 | 38142 | 398 |
2426501 | 2426501 | 2022-04-20 | Guadalupe | New Mexico | 35019 | 1478 | 17 |
2427397 | 2427397 | 2022-04-20 | Guadalupe | Texas | 48187 | 38139 | 398 |
2423245 | 2423245 | 2022-04-19 | Guadalupe | New Mexico | 35019 | 1478 | 17 |
2424141 | 2424141 | 2022-04-19 | Guadalupe | Texas | 48187 | 38121 | 398 |
2419988 | 2419988 | 2022-04-18 | Guadalupe | New Mexico | 35019 | 1478 | 17 |
2420885 | 2420885 | 2022-04-18 | Guadalupe | Texas | 48187 | 38116 | 398 |
2416733 | 2416733 | 2022-04-17 | Guadalupe | New Mexico | 35019 | 1478 | 17 |
2417629 | 2417629 | 2022-04-17 | Guadalupe | Texas | 48187 | 38090 | 398 |
2413477 | 2413477 | 2022-04-16 | Guadalupe | New Mexico | 35019 | 1478 | 17 |
2414373 | 2414373 | 2022-04-16 | Guadalupe | Texas | 48187 | 38090 | 398 |
2410221 | 2410221 | 2022-04-15 | Guadalupe | New Mexico | 35019 | 1478 | 17 |
2411117 | 2411117 | 2022-04-15 | Guadalupe | Texas | 48187 | 38090 | 398 |
2406965 | 2406965 | 2022-04-14 | Guadalupe | New Mexico | 35019 | 1478 | 17 |
2407861 | 2407861 | 2022-04-14 | Guadalupe | Texas | 48187 | 38090 | 398 |
2403709 | 2403709 | 2022-04-13 | Guadalupe | New Mexico | 35019 | 1478 | 17 |
2404605 | 2404605 | 2022-04-13 | Guadalupe | Texas | 48187 | 38086 | 398 |
2400454 | 2400454 | 2022-04-12 | Guadalupe | New Mexico | 35019 | 1478 | 17 |
2401350 | 2401350 | 2022-04-12 | Guadalupe | Texas | 48187 | 38079 | 398 |
2397199 | 2397199 | 2022-04-11 | Guadalupe | New Mexico | 35019 | 1478 | 17 |
2398095 | 2398095 | 2022-04-11 | Guadalupe | Texas | 48187 | 38070 | 398 |
2393944 | 2393944 | 2022-04-10 | Guadalupe | New Mexico | 35019 | 1477 | 17 |
2394840 | 2394840 | 2022-04-10 | Guadalupe | Texas | 48187 | 38070 | 398 |
2390688 | 2390688 | 2022-04-09 | Guadalupe | New Mexico | 35019 | 1477 | 17 |
2391584 | 2391584 | 2022-04-09 | Guadalupe | Texas | 48187 | 38065 | 398 |
2387432 | 2387432 | 2022-04-08 | Guadalupe | New Mexico | 35019 | 1477 | 17 |
2388328 | 2388328 | 2022-04-08 | Guadalupe | Texas | 48187 | 38045 | 398 |
2384177 | 2384177 | 2022-04-07 | Guadalupe | New Mexico | 35019 | 1477 | 17 |
2385073 | 2385073 | 2022-04-07 | Guadalupe | Texas | 48187 | 37999 | 398 |
2380922 | 2380922 | 2022-04-06 | Guadalupe | New Mexico | 35019 | 1478 | 17 |
2381818 | 2381818 | 2022-04-06 | Guadalupe | Texas | 48187 | 37995 | 398 |
2377667 | 2377667 | 2022-04-05 | Guadalupe | New Mexico | 35019 | 1478 | 17 |
2378563 | 2378563 | 2022-04-05 | Guadalupe | Texas | 48187 | 37994 | 398 |
2374414 | 2374414 | 2022-04-04 | Guadalupe | New Mexico | 35019 | 1478 | 17 |
2375309 | 2375309 | 2022-04-04 | Guadalupe | Texas | 48187 | 37988 | 398 |
2371162 | 2371162 | 2022-04-03 | Guadalupe | New Mexico | 35019 | 1476 | 17 |
2372057 | 2372057 | 2022-04-03 | Guadalupe | Texas | 48187 | 37985 | 398 |
2367909 | 2367909 | 2022-04-02 | Guadalupe | New Mexico | 35019 | 1476 | 17 |
2368804 | 2368804 | 2022-04-02 | Guadalupe | Texas | 48187 | 37971 | 398 |
2364656 | 2364656 | 2022-04-01 | Guadalupe | New Mexico | 35019 | 1476 | 17 |
2365551 | 2365551 | 2022-04-01 | Guadalupe | Texas | 48187 | 37968 | 398 |
2361402 | 2361402 | 2022-03-31 | Guadalupe | New Mexico | 35019 | 1476 | 17 |
2362298 | 2362298 | 2022-03-31 | Guadalupe | Texas | 48187 | 37964 | 398 |
2358148 | 2358148 | 2022-03-30 | Guadalupe | New Mexico | 35019 | 1476 | 17 |
2359044 | 2359044 | 2022-03-30 | Guadalupe | Texas | 48187 | 37963 | 398 |
2354895 | 2354895 | 2022-03-29 | Guadalupe | New Mexico | 35019 | 1475 | 17 |
2355790 | 2355790 | 2022-03-29 | Guadalupe | Texas | 48187 | 37946 | 398 |
2351642 | 2351642 | 2022-03-28 | Guadalupe | New Mexico | 35019 | 1474 | 17 |
2352537 | 2352537 | 2022-03-28 | Guadalupe | Texas | 48187 | 37928 | 397 |
2348390 | 2348390 | 2022-03-27 | Guadalupe | New Mexico | 35019 | 1473 | 17 |
2349285 | 2349285 | 2022-03-27 | Guadalupe | Texas | 48187 | 37928 | 397 |
2345137 | 2345137 | 2022-03-26 | Guadalupe | New Mexico | 35019 | 1473 | 17 |
2346032 | 2346032 | 2022-03-26 | Guadalupe | Texas | 48187 | 37927 | 397 |
2341884 | 2341884 | 2022-03-25 | Guadalupe | New Mexico | 35019 | 1473 | 17 |
2342779 | 2342779 | 2022-03-25 | Guadalupe | Texas | 48187 | 37879 | 397 |
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);