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

779 rows where county = "Johnson", fips = 56019 and state = "Wyoming" sorted by date descending

✎ View and edit SQL

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

Suggested facets: deaths, date (date)

state 1

  • Wyoming · 779 ✖

fips 1

  • 56019 · 779 ✖

county 1

  • Johnson · 779 ✖
Link rowid date ▲ county state fips cases deaths
2502819 2502819 2022-05-13 Johnson Wyoming 56019 1845 19
2499561 2499561 2022-05-12 Johnson Wyoming 56019 1845 19
2496303 2496303 2022-05-11 Johnson Wyoming 56019 1845 19
2493045 2493045 2022-05-10 Johnson Wyoming 56019 1845 19
2489787 2489787 2022-05-09 Johnson Wyoming 56019 1845 19
2486530 2486530 2022-05-08 Johnson Wyoming 56019 1845 19
2483272 2483272 2022-05-07 Johnson Wyoming 56019 1845 19
2480014 2480014 2022-05-06 Johnson Wyoming 56019 1845 19
2476756 2476756 2022-05-05 Johnson Wyoming 56019 1845 19
2473498 2473498 2022-05-04 Johnson Wyoming 56019 1845 19
2470241 2470241 2022-05-03 Johnson Wyoming 56019 1845 19
2466985 2466985 2022-05-02 Johnson Wyoming 56019 1845 19
2463730 2463730 2022-05-01 Johnson Wyoming 56019 1845 19
2460474 2460474 2022-04-30 Johnson Wyoming 56019 1845 19
2457218 2457218 2022-04-29 Johnson Wyoming 56019 1845 19
2453962 2453962 2022-04-28 Johnson Wyoming 56019 1845 19
2450706 2450706 2022-04-27 Johnson Wyoming 56019 1845 19
2447450 2447450 2022-04-26 Johnson Wyoming 56019 1845 19
2444194 2444194 2022-04-25 Johnson Wyoming 56019 1845 19
2440938 2440938 2022-04-24 Johnson Wyoming 56019 1845 19
2437682 2437682 2022-04-23 Johnson Wyoming 56019 1845 19
2434426 2434426 2022-04-22 Johnson Wyoming 56019 1845 19
2431170 2431170 2022-04-21 Johnson Wyoming 56019 1845 19
2427914 2427914 2022-04-20 Johnson Wyoming 56019 1845 19
2424658 2424658 2022-04-19 Johnson Wyoming 56019 1845 19
2421402 2421402 2022-04-18 Johnson Wyoming 56019 1845 19
2418146 2418146 2022-04-17 Johnson Wyoming 56019 1845 19
2414890 2414890 2022-04-16 Johnson Wyoming 56019 1845 19
2411634 2411634 2022-04-15 Johnson Wyoming 56019 1845 19
2408378 2408378 2022-04-14 Johnson Wyoming 56019 1845 19
2405122 2405122 2022-04-13 Johnson Wyoming 56019 1845 19
2401867 2401867 2022-04-12 Johnson Wyoming 56019 1845 19
2398612 2398612 2022-04-11 Johnson Wyoming 56019 1844 19
2395357 2395357 2022-04-10 Johnson Wyoming 56019 1844 19
2392101 2392101 2022-04-09 Johnson Wyoming 56019 1844 19
2388845 2388845 2022-04-08 Johnson Wyoming 56019 1844 19
2385590 2385590 2022-04-07 Johnson Wyoming 56019 1844 19
2382335 2382335 2022-04-06 Johnson Wyoming 56019 1844 19
2379080 2379080 2022-04-05 Johnson Wyoming 56019 1844 19
2375826 2375826 2022-04-04 Johnson Wyoming 56019 1844 19
2372574 2372574 2022-04-03 Johnson Wyoming 56019 1844 19
2369321 2369321 2022-04-02 Johnson Wyoming 56019 1844 19
2366068 2366068 2022-04-01 Johnson Wyoming 56019 1844 19
2362815 2362815 2022-03-31 Johnson Wyoming 56019 1844 19
2359561 2359561 2022-03-30 Johnson Wyoming 56019 1844 19
2356307 2356307 2022-03-29 Johnson Wyoming 56019 1844 19
2353054 2353054 2022-03-28 Johnson Wyoming 56019 1844 19
2349802 2349802 2022-03-27 Johnson Wyoming 56019 1844 19
2346549 2346549 2022-03-26 Johnson Wyoming 56019 1844 19
2343296 2343296 2022-03-25 Johnson Wyoming 56019 1844 19
2340043 2340043 2022-03-24 Johnson Wyoming 56019 1844 19
2336790 2336790 2022-03-23 Johnson Wyoming 56019 1844 19
2333536 2333536 2022-03-22 Johnson Wyoming 56019 1844 19
2330282 2330282 2022-03-21 Johnson Wyoming 56019 1843 19
2327030 2327030 2022-03-20 Johnson Wyoming 56019 1843 19
2323777 2323777 2022-03-19 Johnson Wyoming 56019 1843 19
2320523 2320523 2022-03-18 Johnson Wyoming 56019 1843 19
2317269 2317269 2022-03-17 Johnson Wyoming 56019 1842 19
2314016 2314016 2022-03-16 Johnson Wyoming 56019 1842 19
2310763 2310763 2022-03-15 Johnson Wyoming 56019 1842 19
2307510 2307510 2022-03-14 Johnson Wyoming 56019 1842 19
2304259 2304259 2022-03-13 Johnson Wyoming 56019 1842 19
2301007 2301007 2022-03-12 Johnson Wyoming 56019 1842 19
2297755 2297755 2022-03-11 Johnson Wyoming 56019 1842 19
2294503 2294503 2022-03-10 Johnson Wyoming 56019 1842 19
2291251 2291251 2022-03-09 Johnson Wyoming 56019 1842 19
2287999 2287999 2022-03-08 Johnson Wyoming 56019 1842 19
2284747 2284747 2022-03-07 Johnson Wyoming 56019 1842 19
2281495 2281495 2022-03-06 Johnson Wyoming 56019 1842 19
2278242 2278242 2022-03-05 Johnson Wyoming 56019 1842 19
2274989 2274989 2022-03-04 Johnson Wyoming 56019 1842 19
2271736 2271736 2022-03-03 Johnson Wyoming 56019 1840 19
2268484 2268484 2022-03-02 Johnson Wyoming 56019 1840 19
2265231 2265231 2022-03-01 Johnson Wyoming 56019 1839 19
2261981 2261981 2022-02-28 Johnson Wyoming 56019 1839 18
2258730 2258730 2022-02-27 Johnson Wyoming 56019 1839 18
2255479 2255479 2022-02-26 Johnson Wyoming 56019 1839 18
2252228 2252228 2022-02-25 Johnson Wyoming 56019 1839 18
2248977 2248977 2022-02-24 Johnson Wyoming 56019 1839 18
2245726 2245726 2022-02-23 Johnson Wyoming 56019 1838 18
2242475 2242475 2022-02-22 Johnson Wyoming 56019 1838 18
2239224 2239224 2022-02-21 Johnson Wyoming 56019 1837 18
2235973 2235973 2022-02-20 Johnson Wyoming 56019 1837 18
2232722 2232722 2022-02-19 Johnson Wyoming 56019 1837 18
2229471 2229471 2022-02-18 Johnson Wyoming 56019 1837 18
2226220 2226220 2022-02-17 Johnson Wyoming 56019 1835 18
2222969 2222969 2022-02-16 Johnson Wyoming 56019 1835 18
2219718 2219718 2022-02-15 Johnson Wyoming 56019 1834 18
2216468 2216468 2022-02-14 Johnson Wyoming 56019 1832 18
2213217 2213217 2022-02-13 Johnson Wyoming 56019 1832 18
2209964 2209964 2022-02-12 Johnson Wyoming 56019 1832 18
2206711 2206711 2022-02-11 Johnson Wyoming 56019 1832 18
2203458 2203458 2022-02-10 Johnson Wyoming 56019 1827 18
2200204 2200204 2022-02-09 Johnson Wyoming 56019 1826 18
2196950 2196950 2022-02-08 Johnson Wyoming 56019 1824 18
2193695 2193695 2022-02-07 Johnson Wyoming 56019 1818 18
2190442 2190442 2022-02-06 Johnson Wyoming 56019 1815 18
2187189 2187189 2022-02-05 Johnson Wyoming 56019 1815 18
2183936 2183936 2022-02-04 Johnson Wyoming 56019 1815 18
2180684 2180684 2022-02-03 Johnson Wyoming 56019 1815 18

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