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

47 rows where county = "Jefferson" and deaths = 108 sorted by date descending

✎ View and edit SQL

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

fips 7

county 1

  • Jefferson · 47 ✖
Link rowid date ▲ county state fips cases deaths
2369806 2369806 2022-04-03 Jefferson Georgia 13163 3655 108
2366553 2366553 2022-04-02 Jefferson Georgia 13163 3655 108
2363300 2363300 2022-04-01 Jefferson Georgia 13163 3655 108
2360046 2360046 2022-03-31 Jefferson Georgia 13163 3655 108
2356792 2356792 2022-03-30 Jefferson Georgia 13163 3655 108
2353539 2353539 2022-03-29 Jefferson Georgia 13163 3655 108
2350287 2350287 2022-03-28 Jefferson Georgia 13163 3654 108
2347034 2347034 2022-03-27 Jefferson Georgia 13163 3654 108
2343781 2343781 2022-03-26 Jefferson Georgia 13163 3654 108
2340528 2340528 2022-03-25 Jefferson Georgia 13163 3654 108
2337275 2337275 2022-03-24 Jefferson Georgia 13163 3653 108
2334021 2334021 2022-03-23 Jefferson Georgia 13163 3653 108
2330767 2330767 2022-03-22 Jefferson Georgia 13163 3653 108
2327515 2327515 2022-03-21 Jefferson Georgia 13163 3653 108
1996097 1996097 2021-12-09 Jefferson Indiana 18077 6088 108
1992846 1992846 2021-12-08 Jefferson Indiana 18077 6044 108
1993973 1993973 2021-12-08 Jefferson New York 36045 12022 108
1989595 1989595 2021-12-07 Jefferson Indiana 18077 5982 108
1990722 1990722 2021-12-07 Jefferson New York 36045 11931 108
1986345 1986345 2021-12-06 Jefferson Indiana 18077 5949 108
1987471 1987471 2021-12-06 Jefferson New York 36045 11856 108
1983095 1983095 2021-12-05 Jefferson Indiana 18077 5859 108
1984221 1984221 2021-12-05 Jefferson New York 36045 11798 108
1979845 1979845 2021-12-04 Jefferson Indiana 18077 5859 108
1980971 1980971 2021-12-04 Jefferson New York 36045 11736 108
1976595 1976595 2021-12-03 Jefferson Indiana 18077 5859 108
1977721 1977721 2021-12-03 Jefferson New York 36045 11657 108
1974471 1974471 2021-12-02 Jefferson New York 36045 11567 108
1078324 1078324 2021-03-01 Jefferson Ohio 39081 4790 108
1075079 1075079 2021-02-28 Jefferson Ohio 39081 4781 108
1071833 1071833 2021-02-27 Jefferson Ohio 39081 4770 108
989232 989232 2021-02-02 Jefferson Illinois 17081 3736 108
985985 985985 2021-02-01 Jefferson Illinois 17081 3718 108
982738 982738 2021-01-31 Jefferson Illinois 17081 3715 108
979492 979492 2021-01-30 Jefferson Illinois 17081 3702 108
976247 976247 2021-01-29 Jefferson Illinois 17081 3660 108
973002 973002 2021-01-28 Jefferson Illinois 17081 3646 108
969757 969757 2021-01-27 Jefferson Illinois 17081 3624 108
805148 805148 2020-12-07 Jefferson Missouri 29099 13404 108
801903 801903 2020-12-06 Jefferson Missouri 29099 12862 108
798658 798658 2020-12-05 Jefferson Missouri 29099 12862 108
795413 795413 2020-12-04 Jefferson Missouri 29099 12862 108
792168 792168 2020-12-03 Jefferson Missouri 29099 12727 108
788923 788923 2020-12-02 Jefferson Missouri 29099 12486 108
785678 785678 2020-12-01 Jefferson Missouri 29099 12336 108
119298 119298 2020-05-06 Jefferson Kentucky 21111 1535 108
116337 116337 2020-05-05 Jefferson Kentucky 21111 1497 108

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