ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
447 rows where cases = 1169 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 30
- Virginia 30
- Texas 26
- Iowa 22
- Missouri 22
- Louisiana 21
- Minnesota 19
- Oklahoma 19
- Arkansas 18
- Mississippi 18
- Colorado 16
- Puerto Rico 16
- Michigan 13
- Tennessee 13
- Indiana 11
- Kansas 11
- South Dakota 11
- Montana 10
- West Virginia 9
- Nebraska 8
- Florida 7
- Idaho 7
- North Carolina 7
- Rhode Island 7
- Alabama 6
- Illinois 6
- Maine 6
- Utah 6
- Washington 6
- Wisconsin 6
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2490314 | 2490314 | 2022-05-10 | Schley | Georgia | 13249 | 1169 | 11 |
2487057 | 2487057 | 2022-05-09 | Schley | Georgia | 13249 | 1169 | 11 |
2483799 | 2483799 | 2022-05-08 | Schley | Georgia | 13249 | 1169 | 11 |
2480541 | 2480541 | 2022-05-07 | Schley | Georgia | 13249 | 1169 | 11 |
2477283 | 2477283 | 2022-05-06 | Schley | Georgia | 13249 | 1169 | 11 |
2474025 | 2474025 | 2022-05-05 | Schley | Georgia | 13249 | 1169 | 11 |
2470768 | 2470768 | 2022-05-04 | Schley | Georgia | 13249 | 1169 | 11 |
2467519 | 2467519 | 2022-05-03 | Talbot | Georgia | 13263 | 1169 | 32 |
2464264 | 2464264 | 2022-05-02 | Talbot | Georgia | 13263 | 1169 | 32 |
2461008 | 2461008 | 2022-05-01 | Talbot | Georgia | 13263 | 1169 | 32 |
2457752 | 2457752 | 2022-04-30 | Talbot | Georgia | 13263 | 1169 | 32 |
2454496 | 2454496 | 2022-04-29 | Talbot | Georgia | 13263 | 1169 | 32 |
2451240 | 2451240 | 2022-04-28 | Talbot | Georgia | 13263 | 1169 | 32 |
2447984 | 2447984 | 2022-04-27 | Talbot | Georgia | 13263 | 1169 | 32 |
2424385 | 2424385 | 2022-04-19 | Emporia city | Virginia | 51595 | 1169 | 55 |
2365699 | 2365699 | 2022-04-01 | Wheeler | Texas | 48483 | 1169 | 23 |
2362446 | 2362446 | 2022-03-31 | Wheeler | Texas | 48483 | 1169 | 23 |
2359192 | 2359192 | 2022-03-30 | Wheeler | Texas | 48483 | 1169 | 23 |
2198683 | 2198683 | 2022-02-09 | Jefferson | Nebraska | 31095 | 1169 | 6 |
2195429 | 2195429 | 2022-02-08 | Jefferson | Nebraska | 31095 | 1169 | 6 |
2192175 | 2192175 | 2022-02-07 | Jefferson | Nebraska | 31095 | 1169 | 6 |
2188572 | 2188572 | 2022-02-06 | Lincoln | Minnesota | 27081 | 1169 | 5 |
2185319 | 2185319 | 2022-02-05 | Lincoln | Minnesota | 27081 | 1169 | 5 |
2182067 | 2182067 | 2022-02-04 | Lincoln | Minnesota | 27081 | 1169 | 5 |
2179112 | 2179112 | 2022-02-03 | Toole | Montana | 30101 | 1169 | 22 |
2133925 | 2133925 | 2022-01-20 | McHenry | North Dakota | 38049 | 1169 | 28 |
2126358 | 2126358 | 2022-01-18 | Phillips | Kansas | 20147 | 1169 | 28 |
2123106 | 2123106 | 2022-01-17 | Phillips | Kansas | 20147 | 1169 | 28 |
2119854 | 2119854 | 2022-01-16 | Phillips | Kansas | 20147 | 1169 | 28 |
2122066 | 2122066 | 2022-01-16 | Iron | Wisconsin | 55051 | 1169 | 44 |
2116602 | 2116602 | 2022-01-15 | Phillips | Kansas | 20147 | 1169 | 28 |
2118814 | 2118814 | 2022-01-15 | Iron | Wisconsin | 55051 | 1169 | 44 |
2113351 | 2113351 | 2022-01-14 | Phillips | Kansas | 20147 | 1169 | 28 |
2115562 | 2115562 | 2022-01-14 | Iron | Wisconsin | 55051 | 1169 | 44 |
2082386 | 2082386 | 2022-01-04 | Spink | South Dakota | 46115 | 1169 | 31 |
2037798 | 2037798 | 2021-12-22 | Woodruff | Arkansas | 5147 | 1169 | 24 |
2035296 | 2035296 | 2021-12-21 | Greenwood | Kansas | 20073 | 1169 | 17 |
2035958 | 2035958 | 2021-12-21 | Shannon | Missouri | 29203 | 1169 | 29 |
2032046 | 2032046 | 2021-12-20 | Greenwood | Kansas | 20073 | 1169 | 17 |
2033604 | 2033604 | 2021-12-20 | Hamlin | South Dakota | 46057 | 1169 | 40 |
1995513 | 1995513 | 2021-12-09 | Montgomery | Arkansas | 5097 | 1169 | 49 |
1996599 | 1996599 | 2021-12-09 | Alger | Michigan | 26003 | 1169 | 9 |
1993348 | 1993348 | 2021-12-08 | Alger | Michigan | 26003 | 1169 | 9 |
1991249 | 1991249 | 2021-12-07 | San German | Puerto Rico | 72125 | 1169 | |
1987998 | 1987998 | 2021-12-06 | San German | Puerto Rico | 72125 | 1169 | |
1984748 | 1984748 | 2021-12-05 | San German | Puerto Rico | 72125 | 1169 | |
1966788 | 1966788 | 2021-11-30 | Schuyler | Illinois | 17169 | 1169 | 24 |
1946225 | 1946225 | 2021-11-23 | Beaver | Utah | 49001 | 1169 | 13 |
1939859 | 1939859 | 2021-11-21 | Northampton | Virginia | 51131 | 1169 | 46 |
1936609 | 1936609 | 2021-11-20 | Northampton | Virginia | 51131 | 1169 | 46 |
1933359 | 1933359 | 2021-11-19 | Northampton | Virginia | 51131 | 1169 | 46 |
1926510 | 1926510 | 2021-11-17 | Coleman | Texas | 48083 | 1169 | 54 |
1923260 | 1923260 | 2021-11-16 | Coleman | Texas | 48083 | 1169 | 54 |
1920011 | 1920011 | 2021-11-15 | Coleman | Texas | 48083 | 1169 | 54 |
1916761 | 1916761 | 2021-11-14 | Coleman | Texas | 48083 | 1169 | 54 |
1913511 | 1913511 | 2021-11-13 | Coleman | Texas | 48083 | 1169 | 54 |
1898701 | 1898701 | 2021-11-09 | Lucas | Iowa | 19117 | 1169 | 24 |
1895451 | 1895451 | 2021-11-08 | Lucas | Iowa | 19117 | 1169 | 24 |
1892201 | 1892201 | 2021-11-07 | Lucas | Iowa | 19117 | 1169 | 24 |
1888951 | 1888951 | 2021-11-06 | Lucas | Iowa | 19117 | 1169 | 24 |
1885701 | 1885701 | 2021-11-05 | Lucas | Iowa | 19117 | 1169 | 24 |
1882452 | 1882452 | 2021-11-04 | Lucas | Iowa | 19117 | 1169 | 24 |
1879203 | 1879203 | 2021-11-03 | Lucas | Iowa | 19117 | 1169 | 24 |
1869163 | 1869163 | 2021-10-31 | Benewah | Idaho | 16009 | 1169 | 23 |
1865914 | 1865914 | 2021-10-30 | Benewah | Idaho | 16009 | 1169 | 23 |
1862665 | 1862665 | 2021-10-29 | Benewah | Idaho | 16009 | 1169 | 23 |
1855692 | 1855692 | 2021-10-27 | Sitka City and Borough | Alaska | 2220 | 1169 | 4 |
1849268 | 1849268 | 2021-10-25 | Newton | Arkansas | 5101 | 1169 | 37 |
1846018 | 1846018 | 2021-10-24 | Newton | Arkansas | 5101 | 1169 | 37 |
1842768 | 1842768 | 2021-10-23 | Newton | Arkansas | 5101 | 1169 | 37 |
1839518 | 1839518 | 2021-10-22 | Newton | Arkansas | 5101 | 1169 | 37 |
1836269 | 1836269 | 2021-10-21 | Newton | Arkansas | 5101 | 1169 | 37 |
1830453 | 1830453 | 2021-10-19 | Ida | Iowa | 19093 | 1169 | 41 |
1827204 | 1827204 | 2021-10-18 | Ida | Iowa | 19093 | 1169 | 41 |
1823955 | 1823955 | 2021-10-17 | Ida | Iowa | 19093 | 1169 | 41 |
1820706 | 1820706 | 2021-10-16 | Ida | Iowa | 19093 | 1169 | 41 |
1817457 | 1817457 | 2021-10-15 | Ida | Iowa | 19093 | 1169 | 41 |
1814209 | 1814209 | 2021-10-14 | Ida | Iowa | 19093 | 1169 | 41 |
1810960 | 1810960 | 2021-10-13 | Ida | Iowa | 19093 | 1169 | 41 |
1813034 | 1813034 | 2021-10-13 | Orange | Vermont | 50017 | 1169 | 5 |
1813131 | 1813131 | 2021-10-13 | Northumberland | Virginia | 51133 | 1169 | 28 |
1805308 | 1805308 | 2021-10-11 | Custer | Nebraska | 31041 | 1169 | 21 |
1806581 | 1806581 | 2021-10-11 | Essex | Virginia | 51057 | 1169 | 15 |
1802059 | 1802059 | 2021-10-10 | Custer | Nebraska | 31041 | 1169 | 21 |
1803331 | 1803331 | 2021-10-10 | Essex | Virginia | 51057 | 1169 | 15 |
1798810 | 1798810 | 2021-10-09 | Custer | Nebraska | 31041 | 1169 | 21 |
1800082 | 1800082 | 2021-10-09 | Essex | Virginia | 51057 | 1169 | 15 |
1795561 | 1795561 | 2021-10-08 | Custer | Nebraska | 31041 | 1169 | 21 |
1796833 | 1796833 | 2021-10-08 | Essex | Virginia | 51057 | 1169 | 15 |
1791594 | 1791594 | 2021-10-07 | Pratt | Kansas | 20151 | 1169 | 26 |
1788345 | 1788345 | 2021-10-06 | Pratt | Kansas | 20151 | 1169 | 26 |
1769126 | 1769126 | 2021-09-30 | Baraga | Michigan | 26013 | 1169 | 45 |
1765877 | 1765877 | 2021-09-29 | Baraga | Michigan | 26013 | 1169 | 45 |
1766061 | 1766061 | 2021-09-29 | Franklin | Mississippi | 28037 | 1169 | 28 |
1762812 | 1762812 | 2021-09-28 | Franklin | Mississippi | 28037 | 1169 | 28 |
1759563 | 1759563 | 2021-09-27 | Franklin | Mississippi | 28037 | 1169 | 28 |
1757962 | 1757962 | 2021-09-26 | Lincoln | Washington | 53043 | 1169 | 16 |
1754714 | 1754714 | 2021-09-25 | Lincoln | Washington | 53043 | 1169 | 16 |
1751466 | 1751466 | 2021-09-24 | Lincoln | Washington | 53043 | 1169 | 16 |
1746896 | 1746896 | 2021-09-23 | Wayne | Nebraska | 31179 | 1169 | 7 |
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);