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

30 rows where county = "Greenbrier" and deaths = 65 sorted by date descending

✎ View and edit SQL

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

Suggested facets: cases, date (date)

state 1

fips 1

county 1

  • Greenbrier · 30 ✖
Link rowid date ▲ county state fips cases deaths
1598816 1598816 2021-08-08 Greenbrier West Virginia 54025 2941 65
1595567 1595567 2021-08-07 Greenbrier West Virginia 54025 2941 65
1592318 1592318 2021-08-06 Greenbrier West Virginia 54025 2941 65
1589069 1589069 2021-08-05 Greenbrier West Virginia 54025 2940 65
1585820 1585820 2021-08-04 Greenbrier West Virginia 54025 2938 65
1582570 1582570 2021-08-03 Greenbrier West Virginia 54025 2932 65
1579320 1579320 2021-08-02 Greenbrier West Virginia 54025 2930 65
1576072 1576072 2021-08-01 Greenbrier West Virginia 54025 2922 65
1572824 1572824 2021-07-31 Greenbrier West Virginia 54025 2922 65
1569576 1569576 2021-07-30 Greenbrier West Virginia 54025 2922 65
1566328 1566328 2021-07-29 Greenbrier West Virginia 54025 2922 65
1563080 1563080 2021-07-28 Greenbrier West Virginia 54025 2921 65
1559832 1559832 2021-07-27 Greenbrier West Virginia 54025 2921 65
1556585 1556585 2021-07-26 Greenbrier West Virginia 54025 2920 65
1553338 1553338 2021-07-25 Greenbrier West Virginia 54025 2919 65
1550091 1550091 2021-07-24 Greenbrier West Virginia 54025 2919 65
1546844 1546844 2021-07-23 Greenbrier West Virginia 54025 2919 65
1543597 1543597 2021-07-22 Greenbrier West Virginia 54025 2916 65
1540349 1540349 2021-07-21 Greenbrier West Virginia 54025 2915 65
1537102 1537102 2021-07-20 Greenbrier West Virginia 54025 2915 65
1533854 1533854 2021-07-19 Greenbrier West Virginia 54025 2915 65
1530607 1530607 2021-07-18 Greenbrier West Virginia 54025 2913 65
1527360 1527360 2021-07-17 Greenbrier West Virginia 54025 2913 65
1524113 1524113 2021-07-16 Greenbrier West Virginia 54025 2913 65
1261171 1261171 2021-04-26 Greenbrier West Virginia 54025 2697 65
1257924 1257924 2021-04-25 Greenbrier West Virginia 54025 2691 65
1254677 1254677 2021-04-24 Greenbrier West Virginia 54025 2680 65
1251430 1251430 2021-04-23 Greenbrier West Virginia 54025 2673 65
1248183 1248183 2021-04-22 Greenbrier West Virginia 54025 2659 65
1244936 1244936 2021-04-21 Greenbrier West Virginia 54025 2643 65

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