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

531 rows where cases = 733 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
2284272 2284272 2022-03-07 Kinney Texas 48271 733 10
2281020 2281020 2022-03-06 Kinney Texas 48271 733 10
2277767 2277767 2022-03-05 Kinney Texas 48271 733 10
2274514 2274514 2022-03-04 Kinney Texas 48271 733 10
2214596 2214596 2022-02-14 Lake of the Woods Minnesota 27077 733 5
2155724 2155724 2022-01-27 Hickman Kentucky 21105 733 22
2157514 2157514 2022-01-27 Sutton Texas 48435 733 11
2124131 2124131 2022-01-17 Tyrrell North Carolina 37177 733 7
2120879 2120879 2022-01-16 Tyrrell North Carolina 37177 733 7
2117627 2117627 2022-01-15 Tyrrell North Carolina 37177 733 7
2114376 2114376 2022-01-14 Tyrrell North Carolina 37177 733 7
2110607 2110607 2022-01-13 Sharkey Mississippi 28125 733 21
2074914 2074914 2022-01-02 Knox Missouri 29103 733 8
2071663 2071663 2022-01-01 Knox Missouri 29103 733 8
2068412 2068412 2021-12-31 Knox Missouri 29103 733 8
2065161 2065161 2021-12-30 Knox Missouri 29103 733 8
2062095 2062095 2021-12-29 Nuckolls Nebraska 31129 733 13
2058846 2058846 2021-12-28 Nuckolls Nebraska 31129 733 13
2054883 2054883 2021-12-27 Carlisle Kentucky 21039 733 13
2056249 2056249 2021-12-27 Patillas Puerto Rico 72109 733  
2041376 2041376 2021-12-23 Schley Georgia 13249 733 8
2037251 2037251 2021-12-21 Garfield Utah 49017 733 12
2007429 2007429 2021-12-12 Sullivan Pennsylvania 42113 733 24
1997413 1997413 2021-12-09 Wells North Dakota 38103 733 10
1994162 1994162 2021-12-08 Wells North Dakota 38103 733 10
1991820 1991820 2021-12-07 Falls Church city Virginia 51610 733 14
1971000 1971000 2021-12-01 Musselshell Montana 30065 733 22
1964880 1964880 2021-11-29 LaMoure North Dakota 38045 733 17
1960286 1960286 2021-11-28 Scott Illinois 17171 733 7
1961319 1961319 2021-11-28 Johnson Nebraska 31097 733 10
1961628 1961628 2021-11-28 LaMoure North Dakota 38045 733 17
1962082 1962082 2021-11-28 Deuel South Dakota 46039 733 11
1957035 1957035 2021-11-27 Scott Illinois 17171 733 7
1958068 1958068 2021-11-27 Johnson Nebraska 31097 733 10
1958377 1958377 2021-11-27 LaMoure North Dakota 38045 733 17
1958831 1958831 2021-11-27 Deuel South Dakota 46039 733 11
1953784 1953784 2021-11-26 Scott Illinois 17171 733 7
1954817 1954817 2021-11-26 Johnson Nebraska 31097 733 10
1955580 1955580 2021-11-26 Deuel South Dakota 46039 733 11
1950533 1950533 2021-11-25 Scott Illinois 17171 733 7
1951566 1951566 2021-11-25 Johnson Nebraska 31097 733 10
1952329 1952329 2021-11-25 Deuel South Dakota 46039 733 11
1947282 1947282 2021-11-24 Scott Illinois 17171 733 7
1948315 1948315 2021-11-24 Johnson Nebraska 31097 733 10
1949078 1949078 2021-11-24 Deuel South Dakota 46039 733 11
1945045 1945045 2021-11-23 Fillmore Nebraska 31059 733 13
1945064 1945064 2021-11-23 Johnson Nebraska 31097 733 10
1927533 1927533 2021-11-18 Echols Georgia 13101 733 11
1930052 1930052 2021-11-18 Cumberland Virginia 51049 733 19
1925488 1925488 2021-11-17 Mineral Montana 30061 733 13
1922239 1922239 2021-11-16 Mineral Montana 30061 733 13
1922297 1922297 2021-11-16 Furnas Nebraska 31065 733 5
1919605 1919605 2021-11-15 Wallowa Oregon 41063 733 12
1916355 1916355 2021-11-14 Wallowa Oregon 41063 733 12
1913105 1913105 2021-11-13 Wallowa Oregon 41063 733 12
1909855 1909855 2021-11-12 Wallowa Oregon 41063 733 12
1910304 1910304 2021-11-12 Garza Texas 48169 733 22
1906606 1906606 2021-11-11 Wallowa Oregon 41063 733 12
1907055 1907055 2021-11-11 Garza Texas 48169 733 22
1903357 1903357 2021-11-10 Wallowa Oregon 41063 733 12
1878442 1878442 2021-11-03 Yukon-Koyukuk Census Area Alaska 2290 733 5
1856125 1856125 2021-10-27 Talbot Georgia 13263 733 26
1830553 1830553 2021-10-19 Kearny Kansas 20093 733 12
1826434 1826434 2021-10-18 Dillingham Census Area Alaska 2070 733 5
1827304 1827304 2021-10-18 Kearny Kansas 20093 733 12
1823185 1823185 2021-10-17 Dillingham Census Area Alaska 2070 733 5
1824808 1824808 2021-10-17 Dixon Nebraska 31051 733 10
1819936 1819936 2021-10-16 Dillingham Census Area Alaska 2070 733 5
1821559 1821559 2021-10-16 Dixon Nebraska 31051 733 10
1816687 1816687 2021-10-15 Dillingham Census Area Alaska 2070 733 5
1818310 1818310 2021-10-15 Dixon Nebraska 31051 733 10
1808908 1808908 2021-10-12 Pierce North Dakota 38069 733 27
1787079 1787079 2021-10-05 Covington city Virginia 51580 733 15
1773992 1773992 2021-10-01 Wheeler Texas 48483 733 12
1770742 1770742 2021-09-30 Wheeler Texas 48483 733 12
1763890 1763890 2021-09-28 Moody South Dakota 46101 733 20
1756251 1756251 2021-09-26 Mahnomen Minnesota 27087 733 9
1753003 1753003 2021-09-25 Mahnomen Minnesota 27087 733 9
1748396 1748396 2021-09-24 Choctaw Alabama 1023 733 26
1749755 1749755 2021-09-24 Mahnomen Minnesota 27087 733 9
1745146 1745146 2021-09-23 Choctaw Alabama 1023 733 26
1746095 1746095 2021-09-23 Morris Kansas 20127 733 23
1748367 1748367 2021-09-23 Crook Wyoming 56011 733 16
1742846 1742846 2021-09-22 Morris Kansas 20127 733 23
1740318 1740318 2021-09-21 Burt Nebraska 31021 733 12
1724419 1724419 2021-09-16 McHenry North Dakota 38049 733 23
1695550 1695550 2021-09-07 Sabana Grande Puerto Rico 72121 733  
1692302 1692302 2021-09-06 Sabana Grande Puerto Rico 72121 733  
1692984 1692984 2021-09-06 Jefferson Washington 53031 733 6
1689053 1689053 2021-09-05 Sabana Grande Puerto Rico 72121 733  
1689735 1689735 2021-09-05 Jefferson Washington 53031 733 6
1685803 1685803 2021-09-04 Sabana Grande Puerto Rico 72121 733  
1686485 1686485 2021-09-04 Jefferson Washington 53031 733 6
1683234 1683234 2021-09-03 Jefferson Washington 53031 733 6
1675614 1675614 2021-09-01 Hyde North Carolina 37095 733 9
1663451 1663451 2021-08-28 Martin Texas 48317 733 20
1647611 1647611 2021-08-23 Iron Wisconsin 55051 733 42
1631919 1631919 2021-08-19 Marion Georgia 13197 733 26
1632057 1632057 2021-08-19 Edwards Illinois 17047 733 14
1631011 1631011 2021-08-18 Sabine Texas 48403 733 47

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