ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

788 rows where county = "Wyoming" and state = "New York" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state 1

  • New York · 788 ✖

fips 1

county 1

  • Wyoming · 788 ✖
Link rowid date ▲ county state fips cases deaths
2501484 2501484 2022-05-13 Wyoming New York 36121 8692 84
2498226 2498226 2022-05-12 Wyoming New York 36121 8692 84
2494968 2494968 2022-05-11 Wyoming New York 36121 8677 84
2491710 2491710 2022-05-10 Wyoming New York 36121 8658 84
2488452 2488452 2022-05-09 Wyoming New York 36121 8641 84
2485195 2485195 2022-05-08 Wyoming New York 36121 8636 84
2481937 2481937 2022-05-07 Wyoming New York 36121 8625 84
2478679 2478679 2022-05-06 Wyoming New York 36121 8599 84
2475421 2475421 2022-05-05 Wyoming New York 36121 8585 84
2472164 2472164 2022-05-04 Wyoming New York 36121 8569 84
2468908 2468908 2022-05-03 Wyoming New York 36121 8551 84
2465652 2465652 2022-05-02 Wyoming New York 36121 8539 84
2462397 2462397 2022-05-01 Wyoming New York 36121 8534 84
2459141 2459141 2022-04-30 Wyoming New York 36121 8522 84
2455885 2455885 2022-04-29 Wyoming New York 36121 8503 82
2452629 2452629 2022-04-28 Wyoming New York 36121 8494 82
2449373 2449373 2022-04-27 Wyoming New York 36121 8477 82
2446116 2446116 2022-04-26 Wyoming New York 36121 8457 82
2442861 2442861 2022-04-25 Wyoming New York 36121 8447 82
2439605 2439605 2022-04-24 Wyoming New York 36121 8434 82
2436349 2436349 2022-04-23 Wyoming New York 36121 8417 82
2433093 2433093 2022-04-22 Wyoming New York 36121 8402 82
2429837 2429837 2022-04-21 Wyoming New York 36121 8391 82
2426581 2426581 2022-04-20 Wyoming New York 36121 8371 82
2423325 2423325 2022-04-19 Wyoming New York 36121 8361 82
2420068 2420068 2022-04-18 Wyoming New York 36121 8346 82
2416813 2416813 2022-04-17 Wyoming New York 36121 8343 82
2413557 2413557 2022-04-16 Wyoming New York 36121 8333 82
2410301 2410301 2022-04-15 Wyoming New York 36121 8325 82
2407045 2407045 2022-04-14 Wyoming New York 36121 8314 82
2403789 2403789 2022-04-13 Wyoming New York 36121 8308 82
2400534 2400534 2022-04-12 Wyoming New York 36121 8302 82
2397279 2397279 2022-04-11 Wyoming New York 36121 8297 82
2394024 2394024 2022-04-10 Wyoming New York 36121 8294 82
2390768 2390768 2022-04-09 Wyoming New York 36121 8291 82
2387512 2387512 2022-04-08 Wyoming New York 36121 8287 82
2384257 2384257 2022-04-07 Wyoming New York 36121 8281 82
2381002 2381002 2022-04-06 Wyoming New York 36121 8274 82
2377747 2377747 2022-04-05 Wyoming New York 36121 8269 82
2374494 2374494 2022-04-04 Wyoming New York 36121 8269 82
2371242 2371242 2022-04-03 Wyoming New York 36121 8267 82
2367989 2367989 2022-04-02 Wyoming New York 36121 8267 82
2364736 2364736 2022-04-01 Wyoming New York 36121 8267 82
2361482 2361482 2022-03-31 Wyoming New York 36121 8266 82
2358228 2358228 2022-03-30 Wyoming New York 36121 8265 82
2354974 2354974 2022-03-29 Wyoming New York 36121 8264 82
2351721 2351721 2022-03-28 Wyoming New York 36121 8264 82
2348469 2348469 2022-03-27 Wyoming New York 36121 8263 82
2345216 2345216 2022-03-26 Wyoming New York 36121 8262 82
2341963 2341963 2022-03-25 Wyoming New York 36121 8261 82
2338710 2338710 2022-03-24 Wyoming New York 36121 8260 82
2335456 2335456 2022-03-23 Wyoming New York 36121 8259 82
2332202 2332202 2022-03-22 Wyoming New York 36121 8254 82
2328949 2328949 2022-03-21 Wyoming New York 36121 8253 82
2325697 2325697 2022-03-20 Wyoming New York 36121 8253 82
2322444 2322444 2022-03-19 Wyoming New York 36121 8252 82
2319190 2319190 2022-03-18 Wyoming New York 36121 8251 82
2315936 2315936 2022-03-17 Wyoming New York 36121 8248 82
2312683 2312683 2022-03-16 Wyoming New York 36121 8244 82
2309430 2309430 2022-03-15 Wyoming New York 36121 8244 82
2306177 2306177 2022-03-14 Wyoming New York 36121 8242 82
2302926 2302926 2022-03-13 Wyoming New York 36121 8242 82
2299674 2299674 2022-03-12 Wyoming New York 36121 8240 82
2296422 2296422 2022-03-11 Wyoming New York 36121 8240 82
2293170 2293170 2022-03-10 Wyoming New York 36121 8235 82
2289918 2289918 2022-03-09 Wyoming New York 36121 8234 82
2286666 2286666 2022-03-08 Wyoming New York 36121 8233 82
2283414 2283414 2022-03-07 Wyoming New York 36121 8232 82
2280162 2280162 2022-03-06 Wyoming New York 36121 8232 82
2276909 2276909 2022-03-05 Wyoming New York 36121 8232 82
2273656 2273656 2022-03-04 Wyoming New York 36121 8227 82
2270403 2270403 2022-03-03 Wyoming New York 36121 8227 82
2267151 2267151 2022-03-02 Wyoming New York 36121 8222 82
2263899 2263899 2022-03-01 Wyoming New York 36121 8222 82
2260648 2260648 2022-02-28 Wyoming New York 36121 8219 82
2257397 2257397 2022-02-27 Wyoming New York 36121 8219 82
2254146 2254146 2022-02-26 Wyoming New York 36121 8216 82
2250895 2250895 2022-02-25 Wyoming New York 36121 8215 82
2247644 2247644 2022-02-24 Wyoming New York 36121 8212 82
2244393 2244393 2022-02-23 Wyoming New York 36121 8206 82
2241142 2241142 2022-02-22 Wyoming New York 36121 8204 81
2237891 2237891 2022-02-21 Wyoming New York 36121 8203 81
2234640 2234640 2022-02-20 Wyoming New York 36121 8202 81
2231389 2231389 2022-02-19 Wyoming New York 36121 8201 81
2228138 2228138 2022-02-18 Wyoming New York 36121 8192 81
2224887 2224887 2022-02-17 Wyoming New York 36121 8180 81
2221636 2221636 2022-02-16 Wyoming New York 36121 8176 81
2218385 2218385 2022-02-15 Wyoming New York 36121 8166 81
2215134 2215134 2022-02-14 Wyoming New York 36121 8161 81
2211883 2211883 2022-02-13 Wyoming New York 36121 8158 81
2208630 2208630 2022-02-12 Wyoming New York 36121 8145 81
2205377 2205377 2022-02-11 Wyoming New York 36121 8136 81
2202124 2202124 2022-02-10 Wyoming New York 36121 8128 81
2198870 2198870 2022-02-09 Wyoming New York 36121 8113 81
2195616 2195616 2022-02-08 Wyoming New York 36121 8098 81
2192362 2192362 2022-02-07 Wyoming New York 36121 8092 81
2189108 2189108 2022-02-06 Wyoming New York 36121 8087 81
2185855 2185855 2022-02-05 Wyoming New York 36121 8078 81
2182603 2182603 2022-02-04 Wyoming New York 36121 8060 81
2179351 2179351 2022-02-03 Wyoming New York 36121 8038 80

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);