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

234 rows where cases = 2708 sorted by date descending

✎ View and edit SQL

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

These facets timed out: county, fips

Link rowid date ▲ county state fips cases deaths
2501398 2501398 2022-05-13 Colfax New Mexico 35007 2708 65
2406501 2406501 2022-04-14 Koochiching Minnesota 27071 2708 37
2403245 2403245 2022-04-13 Koochiching Minnesota 27071 2708 37
2376719 2376719 2022-04-05 Shelby Iowa 19165 2708 51
2373186 2373186 2022-04-04 Teton Idaho 16081 2708 9
2373467 2373467 2022-04-04 Shelby Iowa 19165 2708 51
2370214 2370214 2022-04-03 Shelby Iowa 19165 2708 51
2366961 2366961 2022-04-02 Shelby Iowa 19165 2708 51
2363708 2363708 2022-04-01 Shelby Iowa 19165 2708 51
2360454 2360454 2022-03-31 Shelby Iowa 19165 2708 51
2357200 2357200 2022-03-30 Shelby Iowa 19165 2708 51
2353947 2353947 2022-03-29 Shelby Iowa 19165 2708 51
2350695 2350695 2022-03-28 Shelby Iowa 19165 2708 51
2347442 2347442 2022-03-27 Shelby Iowa 19165 2708 51
2344189 2344189 2022-03-26 Shelby Iowa 19165 2708 51
2340936 2340936 2022-03-25 Shelby Iowa 19165 2708 51
2337683 2337683 2022-03-24 Shelby Iowa 19165 2708 51
2334429 2334429 2022-03-23 Shelby Iowa 19165 2708 51
2243956 2243956 2022-02-23 Noxubee Mississippi 28103 2708 48
2241711 2241711 2022-02-22 Butte South Dakota 46019 2708 44
2200338 2200338 2022-02-10 Chicot Arkansas 5017 2708 52
2151128 2151128 2022-01-25 Dickenson Virginia 51051 2708 40
2097188 2097188 2022-01-09 Larue Kentucky 21123 2708 57
2098760 2098760 2022-01-09 Bandera Texas 48019 2708 65
2093936 2093936 2022-01-08 Larue Kentucky 21123 2708 57
2090684 2090684 2022-01-07 Larue Kentucky 21123 2708 57
2082845 2082845 2022-01-04 Goochland Virginia 51075 2708 35
2063030 2063030 2021-12-29 Colorado Texas 48089 2708 56
2055064 2055064 2021-12-27 Washington Maine 23029 2708 38
2055366 2055366 2021-12-27 Bates Missouri 29013 2708 62
2051814 2051814 2021-12-26 Washington Maine 23029 2708 38
2048564 2048564 2021-12-25 Washington Maine 23029 2708 38
2045314 2045314 2021-12-24 Washington Maine 23029 2708 38
2031880 2031880 2021-12-20 Pike Indiana 18125 2708 46
2016257 2016257 2021-12-15 Sibley Minnesota 27143 2708 20
2005492 2005492 2021-12-12 Unknown Florida   2708 405
2002241 2002241 2021-12-11 Unknown Florida   2708 405
1993661 1993661 2021-12-08 Livingston Missouri 29117 2708 79
1987082 1987082 2021-12-06 Smith Mississippi 28129 2708 52
1921065 1921065 2021-11-16 Jefferson Georgia 13163 2708 87
1922905 1922905 2021-11-16 Montour Pennsylvania 42093 2708 74
1917815 1917815 2021-11-15 Jefferson Georgia 13163 2708 87
1920288 1920288 2021-11-15 Buckingham Virginia 51029 2708 38
1914565 1914565 2021-11-14 Jefferson Georgia 13163 2708 87
1911315 1911315 2021-11-13 Jefferson Georgia 13163 2708 87
1908066 1908066 2021-11-12 Jefferson Georgia 13163 2708 87
1905022 1905022 2021-11-11 Pike Illinois 17149 2708 61
1901772 1901772 2021-11-10 Pike Illinois 17149 2708 61
1899196 1899196 2021-11-09 Fillmore Minnesota 27045 2708 14
1885401 1885401 2021-11-05 Kauai Hawaii 15007 2708 10
1880873 1880873 2021-11-03 Union South Dakota 46127 2708 46
1871971 1871971 2021-11-01 Clay Arkansas 5021 2708 70
1868722 1868722 2021-10-31 Clay Arkansas 5021 2708 70
1865473 1865473 2021-10-30 Clay Arkansas 5021 2708 70
1862224 1862224 2021-10-29 Clay Arkansas 5021 2708 70
1858975 1858975 2021-10-28 Clay Arkansas 5021 2708 70
1860968 1860968 2021-10-28 Meigs Ohio 39105 2708 53
1855726 1855726 2021-10-27 Clay Arkansas 5021 2708 70
1852477 1852477 2021-10-26 Clay Arkansas 5021 2708 70
1836453 1836453 2021-10-21 Hamilton Florida 12047 2708 47
1833204 1833204 2021-10-20 Hamilton Florida 12047 2708 47
1829955 1829955 2021-10-19 Hamilton Florida 12047 2708 47
1826706 1826706 2021-10-18 Hamilton Florida 12047 2708 47
1823457 1823457 2021-10-17 Hamilton Florida 12047 2708 45
1820208 1820208 2021-10-16 Hamilton Florida 12047 2708 45
1821755 1821755 2021-10-16 Seneca New York 36099 2708 63
1816959 1816959 2021-10-15 Hamilton Florida 12047 2708 45
1814889 1814889 2021-10-14 Cooper Missouri 29053 2708 33
1792882 1792882 2021-10-07 Wasco Oregon 41065 2708 39
1769172 1769172 2021-09-30 Mason Michigan 26105 2708 43
1769298 1769298 2021-09-30 Calhoun Mississippi 28013 2708 42
1765923 1765923 2021-09-29 Mason Michigan 26105 2708 43
1764206 1764206 2021-09-28 San Jacinto Texas 48407 2708 64
1760812 1760812 2021-09-27 DeWitt Texas 48123 2708 72
1757564 1757564 2021-09-26 DeWitt Texas 48123 2708 72
1754316 1754316 2021-09-25 DeWitt Texas 48123 2708 72
1751068 1751068 2021-09-24 DeWitt Texas 48123 2708 71
1751122 1751122 2021-09-24 Houston Texas 48225 2708 75
1747819 1747819 2021-09-23 DeWitt Texas 48123 2708 71
1739201 1739201 2021-09-21 Blaine Idaho 16013 2708 20
1735112 1735112 2021-09-19 Fredericksburg city Virginia 51630 2708 25
1731862 1731862 2021-09-18 Fredericksburg city Virginia 51630 2708 25
1728612 1728612 2021-09-17 Fredericksburg city Virginia 51630 2708 25
1712436 1712436 2021-09-12 Salem city Virginia 51775 2708 52
1709189 1709189 2021-09-11 Salem city Virginia 51775 2708 52
1705942 1705942 2021-09-10 Salem city Virginia 51775 2708 52
1699983 1699983 2021-09-09 Calhoun Florida 12013 2708 45
1696734 1696734 2021-09-08 Calhoun Florida 12013 2708 45
1693486 1693486 2021-09-07 Calhoun Florida 12013 2708 45
1690237 1690237 2021-09-06 Calhoun Florida 12013 2708 45
1686987 1686987 2021-09-05 Calhoun Florida 12013 2708 45
1683737 1683737 2021-09-04 Calhoun Florida 12013 2708 45
1680486 1680486 2021-09-03 Calhoun Florida 12013 2708 45
1675269 1675269 2021-09-01 Vernon Missouri 29217 2708 54
1647805 1647805 2021-08-24 Conway Arkansas 5029 2708 37
1650446 1650446 2021-08-24 Lampasas Texas 48281 2708 39
1641302 1641302 2021-08-22 Clark Arkansas 5019 2708 43
1642226 1642226 2021-08-22 Grayson Kentucky 21085 2708 59
1638976 1638976 2021-08-21 Grayson Kentucky 21085 2708 59
1635726 1635726 2021-08-20 Grayson Kentucky 21085 2708 59

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