ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
42 rows where cases = 27 and state = "Wyoming" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
570034 | 570034 | 2020-09-25 | Platte | Wyoming | 56031 | 27 | 1 |
566800 | 566800 | 2020-09-24 | Weston | Wyoming | 56045 | 27 | 0 |
537642 | 537642 | 2020-09-15 | Crook | Wyoming | 56011 | 27 | 0 |
511761 | 511761 | 2020-09-07 | Johnson | Wyoming | 56019 | 27 | 1 |
508528 | 508528 | 2020-09-06 | Johnson | Wyoming | 56019 | 27 | 1 |
505296 | 505296 | 2020-09-05 | Johnson | Wyoming | 56019 | 27 | 1 |
502062 | 502062 | 2020-09-04 | Johnson | Wyoming | 56019 | 27 | 1 |
498828 | 498828 | 2020-09-03 | Johnson | Wyoming | 56019 | 27 | 1 |
495595 | 495595 | 2020-09-02 | Johnson | Wyoming | 56019 | 27 | 1 |
492361 | 492361 | 2020-09-01 | Johnson | Wyoming | 56019 | 27 | 1 |
489128 | 489128 | 2020-08-31 | Johnson | Wyoming | 56019 | 27 | 1 |
485895 | 485895 | 2020-08-30 | Johnson | Wyoming | 56019 | 27 | 1 |
482660 | 482660 | 2020-08-29 | Johnson | Wyoming | 56019 | 27 | 1 |
479426 | 479426 | 2020-08-28 | Johnson | Wyoming | 56019 | 27 | 1 |
476193 | 476193 | 2020-08-27 | Johnson | Wyoming | 56019 | 27 | 1 |
472960 | 472960 | 2020-08-26 | Johnson | Wyoming | 56019 | 27 | 1 |
469728 | 469728 | 2020-08-25 | Johnson | Wyoming | 56019 | 27 | 1 |
466499 | 466499 | 2020-08-24 | Johnson | Wyoming | 56019 | 27 | 1 |
463270 | 463270 | 2020-08-23 | Johnson | Wyoming | 56019 | 27 | 1 |
460040 | 460040 | 2020-08-22 | Hot Springs | Wyoming | 56017 | 27 | 0 |
460041 | 460041 | 2020-08-22 | Johnson | Wyoming | 56019 | 27 | 1 |
456813 | 456813 | 2020-08-21 | Hot Springs | Wyoming | 56017 | 27 | 0 |
321874 | 321874 | 2020-07-10 | Converse | Wyoming | 56009 | 27 | 0 |
318695 | 318695 | 2020-07-09 | Converse | Wyoming | 56009 | 27 | 0 |
318707 | 318707 | 2020-07-09 | Sheridan | Wyoming | 56033 | 27 | 0 |
315522 | 315522 | 2020-07-08 | Converse | Wyoming | 56009 | 27 | 0 |
315534 | 315534 | 2020-07-08 | Sheridan | Wyoming | 56033 | 27 | 0 |
312347 | 312347 | 2020-07-07 | Converse | Wyoming | 56009 | 27 | 0 |
312359 | 312359 | 2020-07-07 | Sheridan | Wyoming | 56033 | 27 | 0 |
309178 | 309178 | 2020-07-06 | Converse | Wyoming | 56009 | 27 | 0 |
309190 | 309190 | 2020-07-06 | Sheridan | Wyoming | 56033 | 27 | 0 |
306021 | 306021 | 2020-07-05 | Sheridan | Wyoming | 56033 | 27 | 0 |
302857 | 302857 | 2020-07-04 | Sheridan | Wyoming | 56033 | 27 | 0 |
299693 | 299693 | 2020-07-03 | Sheridan | Wyoming | 56033 | 27 | 0 |
296526 | 296526 | 2020-07-02 | Lincoln | Wyoming | 56023 | 27 | 0 |
296531 | 296531 | 2020-07-02 | Sheridan | Wyoming | 56033 | 27 | 0 |
293376 | 293376 | 2020-07-01 | Sheridan | Wyoming | 56033 | 27 | 0 |
290223 | 290223 | 2020-06-30 | Sheridan | Wyoming | 56033 | 27 | 0 |
243224 | 243224 | 2020-06-15 | Albany | Wyoming | 56001 | 27 | 0 |
193776 | 193776 | 2020-05-30 | Sweetwater | Wyoming | 56037 | 27 | 0 |
30740 | 30740 | 2020-04-03 | Fremont | Wyoming | 56013 | 27 | 0 |
23873 | 23873 | 2020-03-31 | Laramie | Wyoming | 56021 | 27 | 0 |
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);