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

44 rows where county = "Fayette" and deaths = 51 sorted by date descending

✎ View and edit SQL

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

fips 8

county 1

  • Fayette · 44 ✖
Link rowid date ▲ county state fips cases deaths
1724474 1724474 2021-09-16 Fayette Ohio 39047 3613 51
1721225 1721225 2021-09-15 Fayette Ohio 39047 3539 51
1717977 1717977 2021-09-14 Fayette Ohio 39047 3515 51
1714729 1714729 2021-09-13 Fayette Ohio 39047 3489 51
1711483 1711483 2021-09-12 Fayette Ohio 39047 3477 51
1708236 1708236 2021-09-11 Fayette Ohio 39047 3462 51
1704989 1704989 2021-09-10 Fayette Ohio 39047 3436 51
1701739 1701739 2021-09-09 Fayette Ohio 39047 3402 51
1698490 1698490 2021-09-08 Fayette Ohio 39047 3376 51
1695242 1695242 2021-09-07 Fayette Ohio 39047 3331 51
1034060 1034060 2021-02-16 Fayette Alabama 1057 1956 51
1030814 1030814 2021-02-15 Fayette Alabama 1057 1953 51
1027567 1027567 2021-02-14 Fayette Alabama 1057 1942 51
1024322 1024322 2021-02-13 Fayette Alabama 1057 1939 51
992561 992561 2021-02-03 Fayette Indiana 18041 2713 51
989315 989315 2021-02-02 Fayette Indiana 18041 2710 51
986068 986068 2021-02-01 Fayette Indiana 18041 2695 51
982821 982821 2021-01-31 Fayette Indiana 18041 2689 51
979575 979575 2021-01-30 Fayette Indiana 18041 2679 51
958686 958686 2021-01-23 Fayette Tennessee 47047 4126 51
955440 955440 2021-01-22 Fayette Tennessee 47047 4087 51
952195 952195 2021-01-21 Fayette Tennessee 47047 4045 51
948950 948950 2021-01-20 Fayette Tennessee 47047 4021 51
945704 945704 2021-01-19 Fayette Tennessee 47047 3993 51
942457 942457 2021-01-18 Fayette Tennessee 47047 3978 51
939212 939212 2021-01-17 Fayette Tennessee 47047 3962 51
935967 935967 2021-01-16 Fayette Tennessee 47047 3917 51
932722 932722 2021-01-15 Fayette Tennessee 47047 3889 51
929477 929477 2021-01-14 Fayette Tennessee 47047 3855 51
926232 926232 2021-01-13 Fayette Tennessee 47047 3835 51
922986 922986 2021-01-12 Fayette Tennessee 47047 3806 51
919741 919741 2021-01-11 Fayette Tennessee 47047 3778 51
916496 916496 2021-01-10 Fayette Tennessee 47047 3761 51
904837 904837 2021-01-07 Fayette Illinois 17051 2777 51
904071 904071 2021-01-06 Fayette West Virginia 54019 1913 51
628840 628840 2020-10-14 Fayette Georgia 13113 2263 51
622354 622354 2020-10-12 Fayette Georgia 13113 2242 51
619111 619111 2020-10-11 Fayette Georgia 13113 2233 51
615869 615869 2020-10-10 Fayette Georgia 13113 2224 51
612628 612628 2020-10-09 Fayette Georgia 13113 2225 51
444945 444945 2020-08-18 Fayette Kentucky 21067 4602 51
441719 441719 2020-08-17 Fayette Kentucky 21067 4521 51
438492 438492 2020-08-16 Fayette Kentucky 21067 4392 51
435267 435267 2020-08-15 Fayette Kentucky 21067 4392 51

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