ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
756 rows where fips = 35019 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501404 | 2501404 | 2022-05-13 | Guadalupe | New Mexico | 35019 | 1482 | 17 |
2498146 | 2498146 | 2022-05-12 | Guadalupe | New Mexico | 35019 | 1481 | 17 |
2494888 | 2494888 | 2022-05-11 | Guadalupe | New Mexico | 35019 | 1481 | 17 |
2491630 | 2491630 | 2022-05-10 | Guadalupe | New Mexico | 35019 | 1481 | 17 |
2488372 | 2488372 | 2022-05-09 | Guadalupe | New Mexico | 35019 | 1481 | 17 |
2485115 | 2485115 | 2022-05-08 | Guadalupe | New Mexico | 35019 | 1482 | 17 |
2481857 | 2481857 | 2022-05-07 | Guadalupe | New Mexico | 35019 | 1482 | 17 |
2478599 | 2478599 | 2022-05-06 | Guadalupe | New Mexico | 35019 | 1482 | 17 |
2475341 | 2475341 | 2022-05-05 | Guadalupe | New Mexico | 35019 | 1482 | 17 |
2472084 | 2472084 | 2022-05-04 | Guadalupe | New Mexico | 35019 | 1482 | 17 |
2468828 | 2468828 | 2022-05-03 | Guadalupe | New Mexico | 35019 | 1482 | 17 |
2465572 | 2465572 | 2022-05-02 | Guadalupe | New Mexico | 35019 | 1482 | 17 |
2462317 | 2462317 | 2022-05-01 | Guadalupe | New Mexico | 35019 | 1482 | 17 |
2459061 | 2459061 | 2022-04-30 | Guadalupe | New Mexico | 35019 | 1482 | 17 |
2455805 | 2455805 | 2022-04-29 | Guadalupe | New Mexico | 35019 | 1482 | 17 |
2452549 | 2452549 | 2022-04-28 | Guadalupe | New Mexico | 35019 | 1480 | 17 |
2449293 | 2449293 | 2022-04-27 | Guadalupe | New Mexico | 35019 | 1480 | 17 |
2446036 | 2446036 | 2022-04-26 | Guadalupe | New Mexico | 35019 | 1480 | 17 |
2442781 | 2442781 | 2022-04-25 | Guadalupe | New Mexico | 35019 | 1480 | 17 |
2439525 | 2439525 | 2022-04-24 | Guadalupe | New Mexico | 35019 | 1479 | 17 |
2436269 | 2436269 | 2022-04-23 | Guadalupe | New Mexico | 35019 | 1479 | 17 |
2433013 | 2433013 | 2022-04-22 | Guadalupe | New Mexico | 35019 | 1479 | 17 |
2429757 | 2429757 | 2022-04-21 | Guadalupe | New Mexico | 35019 | 1479 | 17 |
2426501 | 2426501 | 2022-04-20 | Guadalupe | New Mexico | 35019 | 1478 | 17 |
2423245 | 2423245 | 2022-04-19 | Guadalupe | New Mexico | 35019 | 1478 | 17 |
2419988 | 2419988 | 2022-04-18 | Guadalupe | New Mexico | 35019 | 1478 | 17 |
2416733 | 2416733 | 2022-04-17 | Guadalupe | New Mexico | 35019 | 1478 | 17 |
2413477 | 2413477 | 2022-04-16 | Guadalupe | New Mexico | 35019 | 1478 | 17 |
2410221 | 2410221 | 2022-04-15 | Guadalupe | New Mexico | 35019 | 1478 | 17 |
2406965 | 2406965 | 2022-04-14 | Guadalupe | New Mexico | 35019 | 1478 | 17 |
2403709 | 2403709 | 2022-04-13 | Guadalupe | New Mexico | 35019 | 1478 | 17 |
2400454 | 2400454 | 2022-04-12 | Guadalupe | New Mexico | 35019 | 1478 | 17 |
2397199 | 2397199 | 2022-04-11 | Guadalupe | New Mexico | 35019 | 1478 | 17 |
2393944 | 2393944 | 2022-04-10 | Guadalupe | New Mexico | 35019 | 1477 | 17 |
2390688 | 2390688 | 2022-04-09 | Guadalupe | New Mexico | 35019 | 1477 | 17 |
2387432 | 2387432 | 2022-04-08 | Guadalupe | New Mexico | 35019 | 1477 | 17 |
2384177 | 2384177 | 2022-04-07 | Guadalupe | New Mexico | 35019 | 1477 | 17 |
2380922 | 2380922 | 2022-04-06 | Guadalupe | New Mexico | 35019 | 1478 | 17 |
2377667 | 2377667 | 2022-04-05 | Guadalupe | New Mexico | 35019 | 1478 | 17 |
2374414 | 2374414 | 2022-04-04 | Guadalupe | New Mexico | 35019 | 1478 | 17 |
2371162 | 2371162 | 2022-04-03 | Guadalupe | New Mexico | 35019 | 1476 | 17 |
2367909 | 2367909 | 2022-04-02 | Guadalupe | New Mexico | 35019 | 1476 | 17 |
2364656 | 2364656 | 2022-04-01 | Guadalupe | New Mexico | 35019 | 1476 | 17 |
2361402 | 2361402 | 2022-03-31 | Guadalupe | New Mexico | 35019 | 1476 | 17 |
2358148 | 2358148 | 2022-03-30 | Guadalupe | New Mexico | 35019 | 1476 | 17 |
2354895 | 2354895 | 2022-03-29 | Guadalupe | New Mexico | 35019 | 1475 | 17 |
2351642 | 2351642 | 2022-03-28 | Guadalupe | New Mexico | 35019 | 1474 | 17 |
2348390 | 2348390 | 2022-03-27 | Guadalupe | New Mexico | 35019 | 1473 | 17 |
2345137 | 2345137 | 2022-03-26 | Guadalupe | New Mexico | 35019 | 1473 | 17 |
2341884 | 2341884 | 2022-03-25 | Guadalupe | New Mexico | 35019 | 1473 | 17 |
2338631 | 2338631 | 2022-03-24 | Guadalupe | New Mexico | 35019 | 1474 | 17 |
2335377 | 2335377 | 2022-03-23 | Guadalupe | New Mexico | 35019 | 1473 | 17 |
2332123 | 2332123 | 2022-03-22 | Guadalupe | New Mexico | 35019 | 1473 | 17 |
2328870 | 2328870 | 2022-03-21 | Guadalupe | New Mexico | 35019 | 1473 | 17 |
2325618 | 2325618 | 2022-03-20 | Guadalupe | New Mexico | 35019 | 1473 | 17 |
2322364 | 2322364 | 2022-03-19 | Guadalupe | New Mexico | 35019 | 1473 | 17 |
2319110 | 2319110 | 2022-03-18 | Guadalupe | New Mexico | 35019 | 1473 | 17 |
2315857 | 2315857 | 2022-03-17 | Guadalupe | New Mexico | 35019 | 1473 | 17 |
2312604 | 2312604 | 2022-03-16 | Guadalupe | New Mexico | 35019 | 1473 | 17 |
2309351 | 2309351 | 2022-03-15 | Guadalupe | New Mexico | 35019 | 1472 | 17 |
2306098 | 2306098 | 2022-03-14 | Guadalupe | New Mexico | 35019 | 1472 | 17 |
2302847 | 2302847 | 2022-03-13 | Guadalupe | New Mexico | 35019 | 1472 | 17 |
2299595 | 2299595 | 2022-03-12 | Guadalupe | New Mexico | 35019 | 1472 | 17 |
2296343 | 2296343 | 2022-03-11 | Guadalupe | New Mexico | 35019 | 1472 | 17 |
2293091 | 2293091 | 2022-03-10 | Guadalupe | New Mexico | 35019 | 1470 | 17 |
2289839 | 2289839 | 2022-03-09 | Guadalupe | New Mexico | 35019 | 1468 | 17 |
2286587 | 2286587 | 2022-03-08 | Guadalupe | New Mexico | 35019 | 1468 | 17 |
2283335 | 2283335 | 2022-03-07 | Guadalupe | New Mexico | 35019 | 1468 | 17 |
2280082 | 2280082 | 2022-03-06 | Guadalupe | New Mexico | 35019 | 1435 | 17 |
2276829 | 2276829 | 2022-03-05 | Guadalupe | New Mexico | 35019 | 1435 | 17 |
2273576 | 2273576 | 2022-03-04 | Guadalupe | New Mexico | 35019 | 1435 | 17 |
2270324 | 2270324 | 2022-03-03 | Guadalupe | New Mexico | 35019 | 1435 | 17 |
2267071 | 2267071 | 2022-03-02 | Guadalupe | New Mexico | 35019 | 1421 | 17 |
2263820 | 2263820 | 2022-03-01 | Guadalupe | New Mexico | 35019 | 1420 | 17 |
2260569 | 2260569 | 2022-02-28 | Guadalupe | New Mexico | 35019 | 1414 | 17 |
2257318 | 2257318 | 2022-02-27 | Guadalupe | New Mexico | 35019 | 1414 | 17 |
2254067 | 2254067 | 2022-02-26 | Guadalupe | New Mexico | 35019 | 1414 | 17 |
2250816 | 2250816 | 2022-02-25 | Guadalupe | New Mexico | 35019 | 1414 | 17 |
2247565 | 2247565 | 2022-02-24 | Guadalupe | New Mexico | 35019 | 1414 | 17 |
2244314 | 2244314 | 2022-02-23 | Guadalupe | New Mexico | 35019 | 1406 | 17 |
2241063 | 2241063 | 2022-02-22 | Guadalupe | New Mexico | 35019 | 1402 | 17 |
2237812 | 2237812 | 2022-02-21 | Guadalupe | New Mexico | 35019 | 1418 | 16 |
2234561 | 2234561 | 2022-02-20 | Guadalupe | New Mexico | 35019 | 1339 | 16 |
2231310 | 2231310 | 2022-02-19 | Guadalupe | New Mexico | 35019 | 1339 | 16 |
2228059 | 2228059 | 2022-02-18 | Guadalupe | New Mexico | 35019 | 1339 | 16 |
2224808 | 2224808 | 2022-02-17 | Guadalupe | New Mexico | 35019 | 1334 | 16 |
2221557 | 2221557 | 2022-02-16 | Guadalupe | New Mexico | 35019 | 1330 | 16 |
2218306 | 2218306 | 2022-02-15 | Guadalupe | New Mexico | 35019 | 1322 | 16 |
2215055 | 2215055 | 2022-02-14 | Guadalupe | New Mexico | 35019 | 1321 | 16 |
2211803 | 2211803 | 2022-02-13 | Guadalupe | New Mexico | 35019 | 1310 | 16 |
2208550 | 2208550 | 2022-02-12 | Guadalupe | New Mexico | 35019 | 1310 | 16 |
2205297 | 2205297 | 2022-02-11 | Guadalupe | New Mexico | 35019 | 1310 | 16 |
2202044 | 2202044 | 2022-02-10 | Guadalupe | New Mexico | 35019 | 1300 | 16 |
2198790 | 2198790 | 2022-02-09 | Guadalupe | New Mexico | 35019 | 1293 | 16 |
2195536 | 2195536 | 2022-02-08 | Guadalupe | New Mexico | 35019 | 1287 | 16 |
2192282 | 2192282 | 2022-02-07 | Guadalupe | New Mexico | 35019 | 1284 | 16 |
2189029 | 2189029 | 2022-02-06 | Guadalupe | New Mexico | 35019 | 1275 | 16 |
2185776 | 2185776 | 2022-02-05 | Guadalupe | New Mexico | 35019 | 1275 | 16 |
2182524 | 2182524 | 2022-02-04 | Guadalupe | New Mexico | 35019 | 1275 | 16 |
2179272 | 2179272 | 2022-02-03 | Guadalupe | New Mexico | 35019 | 1270 | 16 |
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);