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

733 rows where cases = 339 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
2473157 2473157 2022-05-04 Rich Utah 49033 339 0
2469901 2469901 2022-05-03 Rich Utah 49033 339 0
2466645 2466645 2022-05-02 Rich Utah 49033 339 0
2463390 2463390 2022-05-01 Rich Utah 49033 339 0
2460134 2460134 2022-04-30 Rich Utah 49033 339 0
2456878 2456878 2022-04-29 Rich Utah 49033 339 0
2453622 2453622 2022-04-28 Rich Utah 49033 339 0
2450366 2450366 2022-04-27 Rich Utah 49033 339 0
2447109 2447109 2022-04-26 Rich Utah 49033 339 0
2443854 2443854 2022-04-25 Rich Utah 49033 339 0
2440598 2440598 2022-04-24 Rich Utah 49033 339 0
2437342 2437342 2022-04-23 Rich Utah 49033 339 0
2434086 2434086 2022-04-22 Rich Utah 49033 339 0
2430830 2430830 2022-04-21 Rich Utah 49033 339 0
2427574 2427574 2022-04-20 Rich Utah 49033 339 0
2424318 2424318 2022-04-19 Rich Utah 49033 339 0
2241017 2241017 2022-02-22 Storey Nevada 32029 339 9
2237766 2237766 2022-02-21 Storey Nevada 32029 339 9
2234515 2234515 2022-02-20 Storey Nevada 32029 339 9
2231264 2231264 2022-02-19 Storey Nevada 32029 339 9
2228013 2228013 2022-02-18 Storey Nevada 32029 339 9
2206316 2206316 2022-02-11 Stonewall Texas 48433 339 7
2190719 2190719 2022-02-07 Dolores Colorado 8033 339 7
2153124 2153124 2022-01-26 Gosper Nebraska 31073 339 7
2143282 2143282 2022-01-23 Daniels Montana 30019 339 9
2140027 2140027 2022-01-22 Daniels Montana 30019 339 9
2136771 2136771 2022-01-21 Daniels Montana 30019 339 9
2130458 2130458 2022-01-19 Catron New Mexico 35003 339 11
2123842 2123842 2022-01-17 Garfield Nebraska 31071 339 2
2097837 2097837 2022-01-09 Harlan Nebraska 31083 339 2
2094585 2094585 2022-01-08 Harlan Nebraska 31083 339 2
2091333 2091333 2022-01-07 Harlan Nebraska 31083 339 2
2088082 2088082 2022-01-06 Harlan Nebraska 31083 339 2
2085617 2085617 2022-01-05 Jerauld South Dakota 46073 339 19
2075380 2075380 2022-01-02 Divide North Dakota 38023 339 3
2072129 2072129 2022-01-01 Divide North Dakota 38023 339 3
2061585 2061585 2021-12-29 Unknown Maryland   339 127
2038956 2038956 2021-12-22 Cook Minnesota 27031 339 1
2035359 2035359 2021-12-21 Wallace Kansas 20199 339 5
2037057 2037057 2021-12-21 Edwards Texas 48137 339 8
2032109 2032109 2021-12-20 Wallace Kansas 20199 339 5
2033807 2033807 2021-12-20 Edwards Texas 48137 339 8
2030557 2030557 2021-12-19 Edwards Texas 48137 339 8
2008033 2008033 2021-12-12 St. John Virgin Islands 78020 339 4
2004782 2004782 2021-12-11 St. John Virgin Islands 78020 339 4
2001531 2001531 2021-12-10 St. John Virgin Islands 78020 339 4
1998281 1998281 2021-12-09 St. John Virgin Islands 78020 339 4
1983265 1983265 2021-12-05 Comanche Kansas 20033 339 13
1980015 1980015 2021-12-04 Comanche Kansas 20033 339 13
1976765 1976765 2021-12-03 Comanche Kansas 20033 339 13
1965362 1965362 2021-11-29 Mellette South Dakota 46095 339 4
1962090 1962090 2021-11-28 Haakon South Dakota 46055 339 11
1958839 1958839 2021-11-27 Haakon South Dakota 46055 339 11
1955588 1955588 2021-11-26 Haakon South Dakota 46055 339 11
1952337 1952337 2021-11-25 Haakon South Dakota 46055 339 11
1949086 1949086 2021-11-24 Haakon South Dakota 46055 339 11
1945835 1945835 2021-11-23 Haakon South Dakota 46055 339 11
1942584 1942584 2021-11-22 Haakon South Dakota 46055 339 11
1939334 1939334 2021-11-21 Haakon South Dakota 46055 339 11
1936084 1936084 2021-11-20 Haakon South Dakota 46055 339 11
1932834 1932834 2021-11-19 Haakon South Dakota 46055 339 11
1929583 1929583 2021-11-18 Haakon South Dakota 46055 339 11
1920897 1920897 2021-11-16 Sedgwick Colorado 8115 339 5
1917647 1917647 2021-11-15 Sedgwick Colorado 8115 339 5
1919368 1919368 2021-11-15 Grant North Dakota 38037 339 7
1915003 1915003 2021-11-14 Clark Kansas 20025 339 7
1916118 1916118 2021-11-14 Grant North Dakota 38037 339 7
1911753 1911753 2021-11-13 Clark Kansas 20025 339 7
1912868 1912868 2021-11-13 Grant North Dakota 38037 339 7
1908504 1908504 2021-11-12 Clark Kansas 20025 339 7
1909618 1909618 2021-11-12 Grant North Dakota 38037 339 7
1906853 1906853 2021-11-11 McPherson South Dakota 46089 339 7
1903120 1903120 2021-11-10 Grant North Dakota 38037 339 7
1903604 1903604 2021-11-10 McPherson South Dakota 46089 339 7
1882699 1882699 2021-11-04 Robertson Kentucky 21201 339 16
1884385 1884385 2021-11-04 Menard Texas 48327 339 11
1881136 1881136 2021-11-03 Menard Texas 48327 339 11
1877887 1877887 2021-11-02 Menard Texas 48327 339 11
1874638 1874638 2021-11-01 Menard Texas 48327 339 11
1871389 1871389 2021-10-31 Menard Texas 48327 339 11
1868140 1868140 2021-10-30 Menard Texas 48327 339 11
1864891 1864891 2021-10-29 Menard Texas 48327 339 11
1861642 1861642 2021-10-28 Menard Texas 48327 339 11
1858393 1858393 2021-10-27 Menard Texas 48327 339 11
1855144 1855144 2021-10-26 Menard Texas 48327 339 11
1851895 1851895 2021-10-25 Menard Texas 48327 339 11
1848645 1848645 2021-10-24 Menard Texas 48327 339 11
1845395 1845395 2021-10-23 Menard Texas 48327 339 11
1841379 1841379 2021-10-22 Golden Valley North Dakota 38033 339 4
1842145 1842145 2021-10-22 Menard Texas 48327 339 11
1834611 1834611 2021-10-20 Sherman Nebraska 31163 339 4
1830526 1830526 2021-10-19 Decatur Kansas 20039 339 13
1830530 1830530 2021-10-19 Edwards Kansas 20047 339 13
1827277 1827277 2021-10-18 Decatur Kansas 20039 339 13
1827281 1827281 2021-10-18 Edwards Kansas 20047 339 13
1824061 1824061 2021-10-17 Lincoln Kansas 20105 339 5
1820812 1820812 2021-10-16 Lincoln Kansas 20105 339 5
1817563 1817563 2021-10-15 Lincoln Kansas 20105 339 5
1814999 1814999 2021-10-14 Granite Montana 30039 339 2
1807127 1807127 2021-10-12 Custer Colorado 8027 339 6

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