ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
539 rows where cases = 690 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 49
- Nebraska 36
- Virginia 32
- Kentucky 29
- Puerto Rico 28
- Montana 23
- Georgia 22
- Tennessee 22
- Iowa 21
- Kansas 21
- Michigan 18
- South Dakota 18
- Mississippi 16
- Illinois 15
- Arkansas 13
- Minnesota 11
- Oklahoma 11
- West Virginia 11
- Colorado 10
- Nevada 10
- Ohio 10
- Missouri 9
- North Carolina 9
- Washington 9
- Indiana 8
- South Carolina 8
- Alaska 7
- North Dakota 7
- Alabama 6
- Idaho 6
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2495900 | 2495900 | 2022-05-11 | Shackelford | Texas | 48417 | 690 | 12 |
2440461 | 2440461 | 2022-04-24 | Kimble | Texas | 48267 | 690 | 15 |
2437205 | 2437205 | 2022-04-23 | Kimble | Texas | 48267 | 690 | 15 |
2433949 | 2433949 | 2022-04-22 | Kimble | Texas | 48267 | 690 | 15 |
2430693 | 2430693 | 2022-04-21 | Kimble | Texas | 48267 | 690 | 15 |
2427437 | 2427437 | 2022-04-20 | Kimble | Texas | 48267 | 690 | 15 |
2328704 | 2328704 | 2022-03-21 | Sheridan | Montana | 30091 | 690 | 11 |
2325452 | 2325452 | 2022-03-20 | Sheridan | Montana | 30091 | 690 | 11 |
2322198 | 2322198 | 2022-03-19 | Sheridan | Montana | 30091 | 690 | 11 |
2318944 | 2318944 | 2022-03-18 | Sheridan | Montana | 30091 | 690 | 11 |
2315691 | 2315691 | 2022-03-17 | Sheridan | Montana | 30091 | 690 | 11 |
2312438 | 2312438 | 2022-03-16 | Sheridan | Montana | 30091 | 690 | 11 |
2293936 | 2293936 | 2022-03-10 | Collingsworth | Texas | 48087 | 690 | 16 |
2266810 | 2266810 | 2022-03-02 | Mercer | Missouri | 29129 | 690 | 12 |
2257255 | 2257255 | 2022-02-27 | Webster | Nebraska | 31181 | 690 | 10 |
2254004 | 2254004 | 2022-02-26 | Webster | Nebraska | 31181 | 690 | 10 |
2250753 | 2250753 | 2022-02-25 | Webster | Nebraska | 31181 | 690 | 10 |
2247502 | 2247502 | 2022-02-24 | Webster | Nebraska | 31181 | 690 | 10 |
2245007 | 2245007 | 2022-02-23 | Potter | South Dakota | 46107 | 690 | 7 |
2241756 | 2241756 | 2022-02-22 | Potter | South Dakota | 46107 | 690 | 7 |
2238505 | 2238505 | 2022-02-21 | Potter | South Dakota | 46107 | 690 | 7 |
2234498 | 2234498 | 2022-02-20 | Webster | Nebraska | 31181 | 690 | 10 |
2235254 | 2235254 | 2022-02-20 | Potter | South Dakota | 46107 | 690 | 7 |
2231247 | 2231247 | 2022-02-19 | Webster | Nebraska | 31181 | 690 | 10 |
2232003 | 2232003 | 2022-02-19 | Potter | South Dakota | 46107 | 690 | 7 |
2227996 | 2227996 | 2022-02-18 | Webster | Nebraska | 31181 | 690 | 10 |
2228752 | 2228752 | 2022-02-18 | Potter | South Dakota | 46107 | 690 | 7 |
2195465 | 2195465 | 2022-02-08 | Stanton | Nebraska | 31167 | 690 | 11 |
2196121 | 2196121 | 2022-02-08 | Vieques | Puerto Rico | 72147 | 690 | |
2192867 | 2192867 | 2022-02-07 | Vieques | Puerto Rico | 72147 | 690 | |
2189613 | 2189613 | 2022-02-06 | Vieques | Puerto Rico | 72147 | 690 | |
2172701 | 2172701 | 2022-02-01 | Valley | Nebraska | 31175 | 690 | 6 |
2169448 | 2169448 | 2022-01-31 | Valley | Nebraska | 31175 | 690 | 5 |
2157432 | 2157432 | 2022-01-27 | Kinney | Texas | 48271 | 690 | 10 |
2153454 | 2153454 | 2022-01-26 | Nelson | North Dakota | 38063 | 690 | 17 |
2133580 | 2133580 | 2022-01-20 | Chase | Nebraska | 31029 | 690 | 6 |
2125075 | 2125075 | 2022-01-17 | Bath | Virginia | 51017 | 690 | 15 |
2110905 | 2110905 | 2022-01-13 | Mineral | Nevada | 32021 | 690 | 14 |
2108721 | 2108721 | 2022-01-12 | Sutton | Texas | 48435 | 690 | 11 |
2084596 | 2084596 | 2022-01-05 | Sharkey | Mississippi | 28125 | 690 | 21 |
2081344 | 2081344 | 2022-01-04 | Sharkey | Mississippi | 28125 | 690 | 21 |
2065991 | 2065991 | 2021-12-30 | Maunabo | Puerto Rico | 72095 | 690 | |
2057788 | 2057788 | 2021-12-28 | Pope | Illinois | 17151 | 690 | 7 |
2033598 | 2033598 | 2021-12-20 | Edmunds | South Dakota | 46045 | 690 | 14 |
2008101 | 2008101 | 2021-12-12 | King and Queen | Virginia | 51097 | 690 | 9 |
2004850 | 2004850 | 2021-12-11 | King and Queen | Virginia | 51097 | 690 | 9 |
2001599 | 2001599 | 2021-12-10 | King and Queen | Virginia | 51097 | 690 | 9 |
1983373 | 1983373 | 2021-12-05 | Carlisle | Kentucky | 21039 | 690 | 12 |
1980123 | 1980123 | 2021-12-04 | Carlisle | Kentucky | 21039 | 690 | 12 |
1976873 | 1976873 | 2021-12-03 | Carlisle | Kentucky | 21039 | 690 | 12 |
1978518 | 1978518 | 2021-12-03 | Coke | Texas | 48081 | 690 | 18 |
1945403 | 1945403 | 2021-11-23 | Wells | North Dakota | 38103 | 690 | 10 |
1932365 | 1932365 | 2021-11-19 | Foster | North Dakota | 38031 | 690 | 19 |
1930266 | 1930266 | 2021-11-18 | Florence | Wisconsin | 55037 | 690 | 14 |
1919118 | 1919118 | 2021-11-15 | Lincoln | Nevada | 32017 | 690 | 5 |
1915868 | 1915868 | 2021-11-14 | Lincoln | Nevada | 32017 | 690 | 5 |
1912618 | 1912618 | 2021-11-13 | Lincoln | Nevada | 32017 | 690 | 5 |
1909368 | 1909368 | 2021-11-12 | Lincoln | Nevada | 32017 | 690 | 5 |
1899874 | 1899874 | 2021-11-09 | LaMoure | North Dakota | 38045 | 690 | 17 |
1875975 | 1875975 | 2021-11-02 | Ringgold | Iowa | 19159 | 690 | 28 |
1877461 | 1877461 | 2021-11-02 | Guayanilla | Puerto Rico | 72059 | 690 | |
1878047 | 1878047 | 2021-11-02 | Charles City | Virginia | 51036 | 690 | 20 |
1872726 | 1872726 | 2021-11-01 | Ringgold | Iowa | 19159 | 690 | 28 |
1874212 | 1874212 | 2021-11-01 | Guayanilla | Puerto Rico | 72059 | 690 | |
1874798 | 1874798 | 2021-11-01 | Charles City | Virginia | 51036 | 690 | 20 |
1868901 | 1868901 | 2021-10-31 | Saguache | Colorado | 8109 | 690 | 8 |
1869477 | 1869477 | 2021-10-31 | Ringgold | Iowa | 19159 | 690 | 28 |
1870223 | 1870223 | 2021-10-31 | Chouteau | Montana | 30015 | 690 | 8 |
1870963 | 1870963 | 2021-10-31 | Guayanilla | Puerto Rico | 72059 | 690 | |
1865652 | 1865652 | 2021-10-30 | Saguache | Colorado | 8109 | 690 | 8 |
1866228 | 1866228 | 2021-10-30 | Ringgold | Iowa | 19159 | 690 | 28 |
1866974 | 1866974 | 2021-10-30 | Chouteau | Montana | 30015 | 690 | 8 |
1867714 | 1867714 | 2021-10-30 | Guayanilla | Puerto Rico | 72059 | 690 | |
1862403 | 1862403 | 2021-10-29 | Saguache | Colorado | 8109 | 690 | 8 |
1862979 | 1862979 | 2021-10-29 | Ringgold | Iowa | 19159 | 690 | 28 |
1863725 | 1863725 | 2021-10-29 | Chouteau | Montana | 30015 | 690 | 8 |
1864465 | 1864465 | 2021-10-29 | Guayanilla | Puerto Rico | 72059 | 690 | |
1859730 | 1859730 | 2021-10-28 | Ringgold | Iowa | 19159 | 690 | 28 |
1856481 | 1856481 | 2021-10-27 | Ringgold | Iowa | 19159 | 690 | 28 |
1831787 | 1831787 | 2021-10-19 | Grant | Oklahoma | 40053 | 690 | 7 |
1826969 | 1826969 | 2021-10-18 | Calhoun | Illinois | 17013 | 690 | 5 |
1828538 | 1828538 | 2021-10-18 | Grant | Oklahoma | 40053 | 690 | 7 |
1824831 | 1824831 | 2021-10-17 | Johnson | Nebraska | 31097 | 690 | 10 |
1825289 | 1825289 | 2021-10-17 | Grant | Oklahoma | 40053 | 690 | 7 |
1821582 | 1821582 | 2021-10-16 | Johnson | Nebraska | 31097 | 690 | 10 |
1822040 | 1822040 | 2021-10-16 | Grant | Oklahoma | 40053 | 690 | 7 |
1818333 | 1818333 | 2021-10-15 | Johnson | Nebraska | 31097 | 690 | 10 |
1818791 | 1818791 | 2021-10-15 | Grant | Oklahoma | 40053 | 690 | 7 |
1815542 | 1815542 | 2021-10-14 | Grant | Oklahoma | 40053 | 690 | 7 |
1811817 | 1811817 | 2021-10-13 | Fillmore | Nebraska | 31059 | 690 | 13 |
1812294 | 1812294 | 2021-10-13 | Grant | Oklahoma | 40053 | 690 | 7 |
1812605 | 1812605 | 2021-10-13 | Gregory | South Dakota | 46053 | 690 | 30 |
1807836 | 1807836 | 2021-10-12 | Ottawa | Kansas | 20143 | 690 | 15 |
1804254 | 1804254 | 2021-10-11 | Henderson | Illinois | 17071 | 690 | 23 |
1804585 | 1804585 | 2021-10-11 | Ottawa | Kansas | 20143 | 690 | 15 |
1806576 | 1806576 | 2021-10-11 | Cumberland | Virginia | 51049 | 690 | 13 |
1801005 | 1801005 | 2021-10-10 | Henderson | Illinois | 17071 | 690 | 23 |
1801336 | 1801336 | 2021-10-10 | Ottawa | Kansas | 20143 | 690 | 15 |
1803326 | 1803326 | 2021-10-10 | Cumberland | Virginia | 51049 | 690 | 13 |
1803457 | 1803457 | 2021-10-10 | Skamania | Washington | 53059 | 690 | 6 |
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);