ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
364 rows where cases = 1163 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 33
- Minnesota 26
- Kentucky 20
- Virginia 20
- Georgia 19
- Puerto Rico 18
- Mississippi 16
- Missouri 16
- Montana 13
- Louisiana 12
- Illinois 11
- Arkansas 10
- Kansas 9
- Michigan 9
- West Virginia 9
- Alabama 8
- Colorado 8
- Florida 8
- Nebraska 8
- North Carolina 8
- Indiana 7
- Ohio 6
- Oklahoma 6
- Pennsylvania 6
- South Carolina 6
- Idaho 5
- Utah 5
- Wisconsin 5
- California 4
- Iowa 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2493696 | 2493696 | 2022-05-11 | Henderson | Illinois | 17071 | 1163 | 28 |
2456357 | 2456357 | 2022-04-29 | Las Marias | Puerto Rico | 72083 | 1163 | |
2447162 | 2447162 | 2022-04-26 | Charles City | Virginia | 51036 | 1163 | 27 |
2423070 | 2423070 | 2022-04-19 | Pondera | Montana | 30073 | 1163 | 6 |
2419813 | 2419813 | 2022-04-18 | Pondera | Montana | 30073 | 1163 | 6 |
2416558 | 2416558 | 2022-04-17 | Pondera | Montana | 30073 | 1163 | 6 |
2413302 | 2413302 | 2022-04-16 | Pondera | Montana | 30073 | 1163 | 6 |
2410046 | 2410046 | 2022-04-15 | Pondera | Montana | 30073 | 1163 | 6 |
2406790 | 2406790 | 2022-04-14 | Pondera | Montana | 30073 | 1163 | 6 |
2403534 | 2403534 | 2022-04-13 | Pondera | Montana | 30073 | 1163 | 6 |
2400279 | 2400279 | 2022-04-12 | Pondera | Montana | 30073 | 1163 | 6 |
2378807 | 2378807 | 2022-04-05 | Emporia city | Virginia | 51595 | 1163 | 54 |
2360095 | 2360095 | 2022-03-31 | Talbot | Georgia | 13263 | 1163 | 32 |
2330596 | 2330596 | 2022-03-22 | Saguache | Colorado | 8109 | 1163 | 12 |
2267979 | 2267979 | 2022-03-02 | Hemphill | Texas | 48211 | 1163 | 6 |
2268029 | 2268029 | 2022-03-02 | Martin | Texas | 48317 | 1163 | 26 |
2264776 | 2264776 | 2022-03-01 | Martin | Texas | 48317 | 1163 | 26 |
2245203 | 2245203 | 2022-02-23 | Goliad | Texas | 48175 | 1163 | 31 |
2224703 | 2224703 | 2022-02-17 | Kearney | Nebraska | 31099 | 1163 | 8 |
2172310 | 2172310 | 2022-02-01 | Lincoln | Minnesota | 27081 | 1163 | 5 |
2157498 | 2157498 | 2022-01-27 | Sabine | Texas | 48403 | 1163 | 78 |
2153081 | 2153081 | 2022-01-26 | Teton | Montana | 30099 | 1163 | 18 |
2154128 | 2154128 | 2022-01-26 | Garza | Texas | 48169 | 1163 | 25 |
2099972 | 2099972 | 2022-01-10 | Power | Idaho | 16077 | 1163 | 17 |
2081600 | 2081600 | 2022-01-04 | Nemaha | Nebraska | 31127 | 1163 | 16 |
2078302 | 2078302 | 2022-01-03 | Clay | Nebraska | 31035 | 1163 | 17 |
2058672 | 2058672 | 2021-12-28 | Maries | Missouri | 29125 | 1163 | 22 |
2050742 | 2050742 | 2021-12-26 | Dallas | Arkansas | 5039 | 1163 | 20 |
2047492 | 2047492 | 2021-12-25 | Dallas | Arkansas | 5039 | 1163 | 20 |
2035350 | 2035350 | 2021-12-21 | Sherman | Kansas | 20181 | 1163 | 16 |
2031542 | 2031542 | 2021-12-20 | Crawford | Georgia | 13079 | 1163 | 46 |
2031791 | 2031791 | 2021-12-20 | Pulaski | Illinois | 17153 | 1163 | 15 |
2032100 | 2032100 | 2021-12-20 | Sherman | Kansas | 20181 | 1163 | 16 |
2032708 | 2032708 | 2021-12-20 | Shannon | Missouri | 29203 | 1163 | 29 |
2030354 | 2030354 | 2021-12-19 | Hamlin | South Dakota | 46057 | 1163 | 40 |
2027103 | 2027103 | 2021-12-18 | Hamlin | South Dakota | 46057 | 1163 | 40 |
2023852 | 2023852 | 2021-12-17 | Hamlin | South Dakota | 46057 | 1163 | 40 |
2024467 | 2024467 | 2021-12-17 | Calhoun | West Virginia | 54013 | 1163 | 9 |
2019427 | 2019427 | 2021-12-16 | Schoolcraft | Michigan | 26153 | 1163 | 7 |
2021216 | 2021216 | 2021-12-16 | Calhoun | West Virginia | 54013 | 1163 | 9 |
2015319 | 2015319 | 2021-12-15 | Hancock | Georgia | 13141 | 1163 | 82 |
2016177 | 2016177 | 2021-12-15 | Schoolcraft | Michigan | 26153 | 1163 | 7 |
1992262 | 1992262 | 2021-12-08 | Montgomery | Arkansas | 5097 | 1163 | 47 |
1974998 | 1974998 | 2021-12-02 | San German | Puerto Rico | 72125 | 1163 | |
1975325 | 1975325 | 2021-12-02 | Hansford | Texas | 48195 | 1163 | 26 |
1971749 | 1971749 | 2021-12-01 | San German | Puerto Rico | 72125 | 1163 | |
1941818 | 1941818 | 2021-11-22 | Knox | Nebraska | 31107 | 1163 | 13 |
1939724 | 1939724 | 2021-11-21 | Beaver | Utah | 49001 | 1163 | 13 |
1936474 | 1936474 | 2021-11-20 | Beaver | Utah | 49001 | 1163 | 13 |
1933224 | 1933224 | 2021-11-19 | Beaver | Utah | 49001 | 1163 | 13 |
1925255 | 1925255 | 2021-11-17 | Wilkin | Minnesota | 27167 | 1163 | 15 |
1922132 | 1922132 | 2021-11-16 | Harrison | Missouri | 29081 | 1163 | 17 |
1898859 | 1898859 | 2021-11-09 | Bracken | Kentucky | 21023 | 1163 | 11 |
1893266 | 1893266 | 2021-11-07 | Camden | North Carolina | 37029 | 1163 | 8 |
1890016 | 1890016 | 2021-11-06 | Camden | North Carolina | 37029 | 1163 | 8 |
1886766 | 1886766 | 2021-11-05 | Camden | North Carolina | 37029 | 1163 | 8 |
1881698 | 1881698 | 2021-11-04 | Greenlee | Arizona | 4011 | 1163 | 16 |
1883517 | 1883517 | 2021-11-04 | Camden | North Carolina | 37029 | 1163 | 8 |
1884263 | 1884263 | 2021-11-04 | Coleman | Texas | 48083 | 1163 | 54 |
1845943 | 1845943 | 2021-10-24 | Sitka City and Borough | Alaska | 2220 | 1163 | 4 |
1842693 | 1842693 | 2021-10-23 | Sitka City and Borough | Alaska | 2220 | 1163 | 4 |
1839444 | 1839444 | 2021-10-22 | Sitka City and Borough | Alaska | 2220 | 1163 | 4 |
1835638 | 1835638 | 2021-10-20 | Marion | Texas | 48315 | 1163 | 49 |
1829912 | 1829912 | 2021-10-19 | San Miguel | Colorado | 8113 | 1163 | 4 |
1831325 | 1831325 | 2021-10-19 | Holt | Nebraska | 31089 | 1163 | 16 |
1822735 | 1822735 | 2021-10-16 | Winkler | Texas | 48495 | 1163 | 27 |
1814486 | 1814486 | 2021-10-14 | Wolfe | Kentucky | 21237 | 1163 | 10 |
1807348 | 1807348 | 2021-10-12 | Lincoln | Georgia | 13181 | 1163 | 32 |
1809784 | 1809784 | 2021-10-12 | Lamoille | Vermont | 50015 | 1163 | 6 |
1801973 | 1801973 | 2021-10-10 | Sullivan | Missouri | 29211 | 1163 | 14 |
1798724 | 1798724 | 2021-10-09 | Sullivan | Missouri | 29211 | 1163 | 14 |
1792312 | 1792312 | 2021-10-07 | Custer | Nebraska | 31041 | 1163 | 20 |
1790335 | 1790335 | 2021-10-06 | Essex | Virginia | 51057 | 1163 | 15 |
1785387 | 1785387 | 2021-10-05 | Crawford | Michigan | 26039 | 1163 | 16 |
1782138 | 1782138 | 2021-10-04 | Crawford | Michigan | 26039 | 1163 | 16 |
1783555 | 1783555 | 2021-10-04 | Dallam | Texas | 48111 | 1163 | 28 |
1780306 | 1780306 | 2021-10-03 | Dallam | Texas | 48111 | 1163 | 28 |
1777056 | 1777056 | 2021-10-02 | Dallam | Texas | 48111 | 1163 | 28 |
1769495 | 1769495 | 2021-09-30 | Carbon | Montana | 30009 | 1163 | 19 |
1748245 | 1748245 | 2021-09-23 | Gilmer | West Virginia | 54021 | 1163 | 7 |
1743320 | 1743320 | 2021-09-22 | Franklin | Mississippi | 28037 | 1163 | 28 |
1740071 | 1740071 | 2021-09-21 | Franklin | Mississippi | 28037 | 1163 | 28 |
1741400 | 1741400 | 2021-09-21 | La Salle | Texas | 48283 | 1163 | 31 |
1741659 | 1741659 | 2021-09-21 | Poquoson city | Virginia | 51735 | 1163 | 18 |
1716987 | 1716987 | 2021-09-14 | Owen | Kentucky | 21187 | 1163 | 15 |
1712864 | 1712864 | 2021-09-13 | Plumas | California | 6063 | 1163 | 6 |
1700184 | 1700184 | 2021-09-09 | Treutlen | Georgia | 13283 | 1163 | 37 |
1696437 | 1696437 | 2021-09-08 | Greene | Alabama | 1063 | 1163 | 40 |
1693331 | 1693331 | 2021-09-07 | Searcy | Arkansas | 5129 | 1163 | 20 |
1690941 | 1690941 | 2021-09-06 | Elliott | Kentucky | 21063 | 1163 | 2 |
1687691 | 1687691 | 2021-09-05 | Elliott | Kentucky | 21063 | 1163 | 2 |
1684441 | 1684441 | 2021-09-04 | Elliott | Kentucky | 21063 | 1163 | 2 |
1685787 | 1685787 | 2021-09-04 | Luquillo | Puerto Rico | 72089 | 1163 | |
1681190 | 1681190 | 2021-09-03 | Elliott | Kentucky | 21063 | 1163 | 2 |
1664895 | 1664895 | 2021-08-29 | Rice | Kansas | 20159 | 1163 | 13 |
1666807 | 1666807 | 2021-08-29 | Grand | Utah | 49019 | 1163 | 4 |
1661647 | 1661647 | 2021-08-28 | Rice | Kansas | 20159 | 1163 | 13 |
1663559 | 1663559 | 2021-08-28 | Grand | Utah | 49019 | 1163 | 4 |
1658399 | 1658399 | 2021-08-27 | Rice | Kansas | 20159 | 1163 | 13 |
1650989 | 1650989 | 2021-08-25 | Sumter | Alabama | 1119 | 1163 | 34 |
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);