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

27 rows where county = "Greene", deaths = 5 and state = "Virginia" sorted by date descending

✎ View and edit SQL

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

state 1

  • Virginia · 27 ✖

fips 1

deaths 1 ✖

county 1

  • Greene · 27 ✖
Link rowid date ▲ county state fips cases deaths
1056482 1056482 2021-02-22 Greene Virginia 51079 978 5
1053236 1053236 2021-02-21 Greene Virginia 51079 979 5
1049989 1049989 2021-02-20 Greene Virginia 51079 974 5
1046742 1046742 2021-02-19 Greene Virginia 51079 966 5
1043497 1043497 2021-02-18 Greene Virginia 51079 958 5
1040252 1040252 2021-02-17 Greene Virginia 51079 949 5
1037007 1037007 2021-02-16 Greene Virginia 51079 943 5
1033762 1033762 2021-02-15 Greene Virginia 51079 940 5
1030516 1030516 2021-02-14 Greene Virginia 51079 939 5
1027269 1027269 2021-02-13 Greene Virginia 51079 935 5
1024024 1024024 2021-02-12 Greene Virginia 51079 932 5
1020779 1020779 2021-02-11 Greene Virginia 51079 928 5
1017534 1017534 2021-02-10 Greene Virginia 51079 923 5
1014289 1014289 2021-02-09 Greene Virginia 51079 912 5
1011044 1011044 2021-02-08 Greene Virginia 51079 906 5
1007798 1007798 2021-02-07 Greene Virginia 51079 901 5
1004552 1004552 2021-02-06 Greene Virginia 51079 896 5
1001306 1001306 2021-02-05 Greene Virginia 51079 883 5
998060 998060 2021-02-04 Greene Virginia 51079 865 5
994814 994814 2021-02-03 Greene Virginia 51079 863 5
991568 991568 2021-02-02 Greene Virginia 51079 857 5
988322 988322 2021-02-01 Greene Virginia 51079 855 5
985075 985075 2021-01-31 Greene Virginia 51079 848 5
981828 981828 2021-01-30 Greene Virginia 51079 840 5
978582 978582 2021-01-29 Greene Virginia 51079 835 5
975337 975337 2021-01-28 Greene Virginia 51079 830 5
972092 972092 2021-01-27 Greene Virginia 51079 817 5

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