ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
482 rows where cases = 717 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 43
- South Dakota 37
- Nebraska 33
- Georgia 28
- Kentucky 26
- Kansas 22
- Indiana 17
- Virginia 17
- Mississippi 16
- Montana 16
- Missouri 14
- Wyoming 14
- Arkansas 12
- Minnesota 12
- Oklahoma 12
- Illinois 11
- Iowa 11
- Michigan 11
- North Carolina 11
- Puerto Rico 10
- Ohio 9
- Alabama 8
- Idaho 8
- South Carolina 8
- Tennessee 8
- Florida 7
- Colorado 6
- North Dakota 6
- Utah 5
- Wisconsin 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2257085 | 2257085 | 2022-02-27 | Schuyler | Missouri | 29197 | 717 | 25 |
2253834 | 2253834 | 2022-02-26 | Schuyler | Missouri | 29197 | 717 | 25 |
2250583 | 2250583 | 2022-02-25 | Schuyler | Missouri | 29197 | 717 | 25 |
2247332 | 2247332 | 2022-02-24 | Schuyler | Missouri | 29197 | 717 | 25 |
2247463 | 2247463 | 2022-02-24 | Kimball | Nebraska | 31105 | 717 | 9 |
2244212 | 2244212 | 2022-02-23 | Kimball | Nebraska | 31105 | 717 | 9 |
2240961 | 2240961 | 2022-02-22 | Kimball | Nebraska | 31105 | 717 | 9 |
2237710 | 2237710 | 2022-02-21 | Kimball | Nebraska | 31105 | 717 | 9 |
2222494 | 2222494 | 2022-02-16 | Kinney | Texas | 48271 | 717 | 10 |
2219243 | 2219243 | 2022-02-15 | Kinney | Texas | 48271 | 717 | 10 |
2215992 | 2215992 | 2022-02-14 | Kinney | Texas | 48271 | 717 | 10 |
2212741 | 2212741 | 2022-02-13 | Kinney | Texas | 48271 | 717 | 10 |
2165839 | 2165839 | 2022-01-30 | Traverse | Minnesota | 27155 | 717 | 8 |
2162584 | 2162584 | 2022-01-29 | Traverse | Minnesota | 27155 | 717 | 8 |
2159329 | 2159329 | 2022-01-28 | Traverse | Minnesota | 27155 | 717 | 8 |
2157453 | 2157453 | 2022-01-27 | Mason | Texas | 48319 | 717 | 9 |
2147389 | 2147389 | 2022-01-24 | Clark | South Dakota | 46025 | 717 | 6 |
2142586 | 2142586 | 2022-01-23 | Gove | Kansas | 20063 | 717 | 23 |
2139331 | 2139331 | 2022-01-22 | Gove | Kansas | 20063 | 717 | 23 |
2136075 | 2136075 | 2022-01-21 | Gove | Kansas | 20063 | 717 | 23 |
2137174 | 2137174 | 2022-01-21 | Hettinger | North Dakota | 38041 | 717 | 7 |
2128206 | 2128206 | 2022-01-18 | Reagan | Texas | 48383 | 717 | 11 |
2111859 | 2111859 | 2022-01-13 | Haskell | Texas | 48207 | 717 | 37 |
2100854 | 2100854 | 2022-01-10 | Sharkey | Mississippi | 28125 | 717 | 21 |
2102232 | 2102232 | 2022-01-10 | Upton | Texas | 48461 | 717 | 15 |
2098981 | 2098981 | 2022-01-09 | Upton | Texas | 48461 | 717 | 15 |
2095729 | 2095729 | 2022-01-08 | Upton | Texas | 48461 | 717 | 15 |
2029597 | 2029597 | 2021-12-19 | Nuckolls | Nebraska | 31129 | 717 | 13 |
2026346 | 2026346 | 2021-12-18 | Nuckolls | Nebraska | 31129 | 717 | 13 |
2023095 | 2023095 | 2021-12-17 | Nuckolls | Nebraska | 31129 | 717 | 13 |
2023724 | 2023724 | 2021-12-17 | Guayanilla | Puerto Rico | 72059 | 717 | |
2013382 | 2013382 | 2021-12-14 | Lincoln | Nevada | 32017 | 717 | 5 |
2000927 | 2000927 | 2021-12-10 | Sullivan | Pennsylvania | 42113 | 717 | 24 |
1998243 | 1998243 | 2021-12-09 | Garfield | Utah | 49017 | 717 | 12 |
1991031 | 1991031 | 2021-12-07 | Grant | Oklahoma | 40053 | 717 | 8 |
1987780 | 1987780 | 2021-12-06 | Grant | Oklahoma | 40053 | 717 | 8 |
1984530 | 1984530 | 2021-12-05 | Grant | Oklahoma | 40053 | 717 | 8 |
1981280 | 1981280 | 2021-12-04 | Grant | Oklahoma | 40053 | 717 | 8 |
1978030 | 1978030 | 2021-12-03 | Grant | Oklahoma | 40053 | 717 | 8 |
1978583 | 1978583 | 2021-12-03 | Hemphill | Texas | 48211 | 717 | 3 |
1974780 | 1974780 | 2021-12-02 | Grant | Oklahoma | 40053 | 717 | 8 |
1975333 | 1975333 | 2021-12-02 | Hemphill | Texas | 48211 | 717 | 3 |
1975569 | 1975569 | 2021-12-02 | Falls Church city | Virginia | 51610 | 717 | 14 |
1971531 | 1971531 | 2021-12-01 | Grant | Oklahoma | 40053 | 717 | 8 |
1972084 | 1972084 | 2021-12-01 | Hemphill | Texas | 48211 | 717 | 3 |
1924848 | 1924848 | 2021-11-17 | Ballard | Kentucky | 21007 | 717 | 20 |
1906045 | 1906045 | 2021-11-11 | Fillmore | Nebraska | 31059 | 717 | 13 |
1906064 | 1906064 | 2021-11-11 | Johnson | Nebraska | 31097 | 717 | 10 |
1902796 | 1902796 | 2021-11-10 | Fillmore | Nebraska | 31059 | 717 | 13 |
1894896 | 1894896 | 2021-11-08 | Saguache | Colorado | 8109 | 717 | 8 |
1892991 | 1892991 | 2021-11-07 | Mineral | Montana | 30061 | 717 | 13 |
1889741 | 1889741 | 2021-11-06 | Mineral | Montana | 30061 | 717 | 13 |
1886491 | 1886491 | 2021-11-05 | Mineral | Montana | 30061 | 717 | 13 |
1880608 | 1880608 | 2021-11-03 | Wallowa | Oregon | 41063 | 717 | 12 |
1869287 | 1869287 | 2021-10-31 | Scott | Illinois | 17171 | 717 | 6 |
1866038 | 1866038 | 2021-10-30 | Scott | Illinois | 17171 | 717 | 6 |
1862789 | 1862789 | 2021-10-29 | Scott | Illinois | 17171 | 717 | 6 |
1860571 | 1860571 | 2021-10-28 | Howard | Nebraska | 31093 | 717 | 13 |
1857322 | 1857322 | 2021-10-27 | Howard | Nebraska | 31093 | 717 | 13 |
1847649 | 1847649 | 2021-10-24 | Unknown | New Hampshire | 717 | 1 | |
1844399 | 1844399 | 2021-10-23 | Unknown | New Hampshire | 717 | 1 | |
1841149 | 1841149 | 2021-10-22 | Unknown | New Hampshire | 717 | 1 | |
1826964 | 1826964 | 2021-10-18 | Alexander | Illinois | 17003 | 717 | 12 |
1804057 | 1804057 | 2021-10-11 | Echols | Georgia | 13101 | 717 | 11 |
1805313 | 1805313 | 2021-10-11 | Dixon | Nebraska | 31051 | 717 | 10 |
1800808 | 1800808 | 2021-10-10 | Echols | Georgia | 13101 | 717 | 11 |
1802064 | 1802064 | 2021-10-10 | Dixon | Nebraska | 31051 | 717 | 10 |
1797559 | 1797559 | 2021-10-09 | Echols | Georgia | 13101 | 717 | 11 |
1798815 | 1798815 | 2021-10-09 | Dixon | Nebraska | 31051 | 717 | 10 |
1794310 | 1794310 | 2021-10-08 | Echols | Georgia | 13101 | 717 | 11 |
1795566 | 1795566 | 2021-10-08 | Dixon | Nebraska | 31051 | 717 | 10 |
1791619 | 1791619 | 2021-10-07 | Washington | Kansas | 20201 | 717 | 15 |
1788370 | 1788370 | 2021-10-06 | Washington | Kansas | 20201 | 717 | 15 |
1784564 | 1784564 | 2021-10-05 | Echols | Georgia | 13101 | 717 | 10 |
1784644 | 1784644 | 2021-10-05 | Talbot | Georgia | 13263 | 717 | 24 |
1781395 | 1781395 | 2021-10-04 | Talbot | Georgia | 13263 | 717 | 23 |
1769540 | 1769540 | 2021-09-30 | Teton | Montana | 30099 | 717 | 7 |
1766367 | 1766367 | 2021-09-29 | Pierce | Nebraska | 31139 | 717 | 21 |
1762996 | 1762996 | 2021-09-28 | Broadwater | Montana | 30007 | 717 | 10 |
1759942 | 1759942 | 2021-09-27 | Unknown | New Jersey | 717 | 0 | |
1760995 | 1760995 | 2021-09-27 | Wheeler | Texas | 48483 | 717 | 12 |
1756694 | 1756694 | 2021-09-26 | Unknown | New Jersey | 717 | 0 | |
1757747 | 1757747 | 2021-09-26 | Wheeler | Texas | 48483 | 717 | 12 |
1754499 | 1754499 | 2021-09-25 | Wheeler | Texas | 48483 | 717 | 12 |
1747382 | 1747382 | 2021-09-23 | Lake | Oregon | 41037 | 717 | 8 |
1743699 | 1743699 | 2021-09-22 | Unknown | New Jersey | 717 | 0 | |
1741294 | 1741294 | 2021-09-21 | Carson | Texas | 48065 | 717 | 18 |
1715904 | 1715904 | 2021-09-14 | Choctaw | Alabama | 1023 | 717 | 25 |
1712503 | 1712503 | 2021-09-12 | Calhoun | West Virginia | 54013 | 717 | 1 |
1686087 | 1686087 | 2021-09-04 | Crockett | Texas | 48105 | 717 | 15 |
1676146 | 1676146 | 2021-09-01 | Fall River | South Dakota | 46047 | 717 | 16 |
1647211 | 1647211 | 2021-08-23 | Martin | Texas | 48317 | 717 | 20 |
1643962 | 1643962 | 2021-08-22 | Martin | Texas | 48317 | 717 | 20 |
1634223 | 1634223 | 2021-08-19 | Mills | Texas | 48333 | 717 | 23 |
1624939 | 1624939 | 2021-08-16 | Weston | Wyoming | 56045 | 717 | 6 |
1607370 | 1607370 | 2021-08-11 | Camden | North Carolina | 37029 | 717 | 6 |
1596717 | 1596717 | 2021-08-08 | Bracken | Kentucky | 21023 | 717 | 8 |
1596734 | 1596734 | 2021-08-08 | Cumberland | Kentucky | 21057 | 717 | 14 |
1593468 | 1593468 | 2021-08-07 | Bracken | Kentucky | 21023 | 717 | 8 |
1593485 | 1593485 | 2021-08-07 | Cumberland | Kentucky | 21057 | 717 | 14 |
Advanced export
JSON shape: default, array, newline-delimited
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);