ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
349 rows where cases = 1131 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 35
- Virginia 24
- Georgia 19
- Missouri 16
- Mississippi 15
- Idaho 14
- Kansas 12
- Illinois 11
- Arkansas 10
- Iowa 10
- Oklahoma 10
- Colorado 9
- North Carolina 9
- Tennessee 9
- Alabama 8
- Kentucky 8
- Louisiana 8
- Michigan 8
- Montana 8
- West Virginia 8
- California 7
- Minnesota 7
- North Dakota 7
- Ohio 7
- Puerto Rico 7
- Wisconsin 7
- Nebraska 6
- Maine 5
- New York 5
- Pennsylvania 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2447207 | 2447207 | 2022-04-26 | King and Queen | Virginia | 51097 | 1131 | 12 |
2392703 | 2392703 | 2022-04-10 | Lewis | Idaho | 16061 | 1131 | 29 |
2389447 | 2389447 | 2022-04-09 | Lewis | Idaho | 16061 | 1131 | 29 |
2386192 | 2386192 | 2022-04-08 | Lewis | Idaho | 16061 | 1131 | 29 |
2382937 | 2382937 | 2022-04-07 | Lewis | Idaho | 16061 | 1131 | 29 |
2379682 | 2379682 | 2022-04-06 | Lewis | Idaho | 16061 | 1131 | 29 |
2376428 | 2376428 | 2022-04-05 | Lewis | Idaho | 16061 | 1131 | 29 |
2373176 | 2373176 | 2022-04-04 | Lewis | Idaho | 16061 | 1131 | 29 |
2369923 | 2369923 | 2022-04-03 | Lewis | Idaho | 16061 | 1131 | 29 |
2366670 | 2366670 | 2022-04-02 | Lewis | Idaho | 16061 | 1131 | 29 |
2363417 | 2363417 | 2022-04-01 | Lewis | Idaho | 16061 | 1131 | 29 |
2360163 | 2360163 | 2022-03-31 | Lewis | Idaho | 16061 | 1131 | 29 |
2356909 | 2356909 | 2022-03-30 | Lewis | Idaho | 16061 | 1131 | 29 |
2353656 | 2353656 | 2022-03-29 | Lewis | Idaho | 16061 | 1131 | 29 |
2353747 | 2353747 | 2022-03-29 | Putnam | Illinois | 17155 | 1131 | 10 |
2269488 | 2269488 | 2022-03-03 | Stafford | Kansas | 20185 | 1131 | 26 |
2266235 | 2266235 | 2022-03-02 | Stafford | Kansas | 20185 | 1131 | 26 |
2236624 | 2236624 | 2022-02-21 | Henderson | Illinois | 17071 | 1131 | 26 |
2233373 | 2233373 | 2022-02-20 | Henderson | Illinois | 17071 | 1131 | 26 |
2230122 | 2230122 | 2022-02-19 | Henderson | Illinois | 17071 | 1131 | 26 |
2226871 | 2226871 | 2022-02-18 | Henderson | Illinois | 17071 | 1131 | 26 |
2224572 | 2224572 | 2022-02-17 | Reynolds | Missouri | 29179 | 1131 | 20 |
2222682 | 2222682 | 2022-02-16 | Charles City | Virginia | 51036 | 1131 | 26 |
2218132 | 2218132 | 2022-02-15 | Pondera | Montana | 30073 | 1131 | 6 |
2216098 | 2216098 | 2022-02-14 | Wheeler | Texas | 48483 | 1131 | 19 |
2212761 | 2212761 | 2022-02-13 | Martin | Texas | 48317 | 1131 | 26 |
2212847 | 2212847 | 2022-02-13 | Wheeler | Texas | 48483 | 1131 | 19 |
2209508 | 2209508 | 2022-02-12 | Martin | Texas | 48317 | 1131 | 26 |
2209594 | 2209594 | 2022-02-12 | Wheeler | Texas | 48483 | 1131 | 19 |
2196426 | 2196426 | 2022-02-08 | Goliad | Texas | 48175 | 1131 | 29 |
2156170 | 2156170 | 2022-01-27 | Atchison | Missouri | 29005 | 1131 | 19 |
2151961 | 2151961 | 2022-01-26 | Wheeler | Georgia | 13309 | 1131 | 36 |
2149883 | 2149883 | 2022-01-25 | Jefferson | Nebraska | 31095 | 1131 | 6 |
2146631 | 2146631 | 2022-01-24 | Jefferson | Nebraska | 31095 | 1131 | 5 |
2134987 | 2134987 | 2022-01-20 | Skamania | Washington | 53059 | 1131 | 10 |
2128881 | 2128881 | 2022-01-19 | Trinity | California | 6105 | 1131 | 19 |
2104074 | 2104074 | 2022-01-11 | Jefferson | Mississippi | 28063 | 1131 | 35 |
2061956 | 2061956 | 2021-12-29 | Shelby | Missouri | 29205 | 1131 | 13 |
2058845 | 2058845 | 2021-12-28 | Nemaha | Nebraska | 31127 | 1131 | 16 |
2054395 | 2054395 | 2021-12-27 | Twiggs | Georgia | 13289 | 1131 | 62 |
2040133 | 2040133 | 2021-12-22 | Spink | South Dakota | 46115 | 1131 | 30 |
2034108 | 2034108 | 2021-12-20 | Lancaster | Virginia | 51103 | 1131 | 24 |
2030215 | 2030215 | 2021-12-19 | Ciales | Puerto Rico | 72039 | 1131 | |
2017825 | 2017825 | 2021-12-15 | Fairfax city | Virginia | 51600 | 1131 | 35 |
2013329 | 2013329 | 2021-12-14 | Keith | Nebraska | 31101 | 1131 | 11 |
1997111 | 1997111 | 2021-12-09 | Thurston | Nebraska | 31173 | 1131 | 16 |
1991451 | 1991451 | 2021-12-07 | Pickett | Tennessee | 47137 | 1131 | 26 |
1966359 | 1966359 | 2021-11-30 | Conejos | Colorado | 8021 | 1131 | 42 |
1966380 | 1966380 | 2021-11-30 | Kit Carson | Colorado | 8063 | 1131 | 21 |
1968119 | 1968119 | 2021-11-30 | Dickey | North Dakota | 38021 | 1131 | 36 |
1963107 | 1963107 | 2021-11-29 | Conejos | Colorado | 8021 | 1131 | 42 |
1940555 | 1940555 | 2021-11-22 | Hancock | Georgia | 13141 | 1131 | 82 |
1927553 | 1927553 | 2021-11-18 | Hancock | Georgia | 13141 | 1131 | 82 |
1899688 | 1899688 | 2021-11-09 | Sierra | New Mexico | 35051 | 1131 | 57 |
1900846 | 1900846 | 2021-11-09 | Lunenburg | Virginia | 51111 | 1131 | 22 |
1897596 | 1897596 | 2021-11-08 | Lunenburg | Virginia | 51111 | 1131 | 22 |
1881596 | 1881596 | 2021-11-03 | Weston | Wyoming | 56045 | 1131 | 9 |
1876422 | 1876422 | 2021-11-02 | Unknown | Michigan | 1131 | 13 | |
1859013 | 1859013 | 2021-10-28 | Montgomery | Arkansas | 5097 | 1131 | 45 |
1856034 | 1856034 | 2021-10-27 | Crawford | Georgia | 13079 | 1131 | 43 |
1852785 | 1852785 | 2021-10-26 | Crawford | Georgia | 13079 | 1131 | 43 |
1849536 | 1849536 | 2021-10-25 | Crawford | Georgia | 13079 | 1131 | 43 |
1837052 | 1837052 | 2021-10-21 | Kingman | Kansas | 20095 | 1131 | 20 |
1833803 | 1833803 | 2021-10-20 | Kingman | Kansas | 20095 | 1131 | 20 |
1823242 | 1823242 | 2021-10-17 | Dallas | Arkansas | 5039 | 1131 | 19 |
1814458 | 1814458 | 2021-10-14 | Nicholas | Kentucky | 21181 | 1131 | 15 |
1808907 | 1808907 | 2021-10-12 | Pembina | North Dakota | 38067 | 1131 | 11 |
1809569 | 1809569 | 2021-10-12 | Floyd | Texas | 48153 | 1131 | 35 |
1806319 | 1806319 | 2021-10-11 | Floyd | Texas | 48153 | 1131 | 35 |
1800676 | 1800676 | 2021-10-10 | Yuma | Colorado | 8125 | 1131 | 18 |
1803069 | 1803069 | 2021-10-10 | Floyd | Texas | 48153 | 1131 | 35 |
1797427 | 1797427 | 2021-10-09 | Yuma | Colorado | 8125 | 1131 | 18 |
1799820 | 1799820 | 2021-10-09 | Floyd | Texas | 48153 | 1131 | 34 |
1794178 | 1794178 | 2021-10-08 | Yuma | Colorado | 8125 | 1131 | 18 |
1783750 | 1783750 | 2021-10-04 | Yoakum | Texas | 48501 | 1131 | 30 |
1779027 | 1779027 | 2021-10-03 | Stevens | Minnesota | 27149 | 1131 | 11 |
1780501 | 1780501 | 2021-10-03 | Yoakum | Texas | 48501 | 1131 | 30 |
1775777 | 1775777 | 2021-10-02 | Stevens | Minnesota | 27149 | 1131 | 11 |
1777251 | 1777251 | 2021-10-02 | Yoakum | Texas | 48501 | 1131 | 30 |
1772527 | 1772527 | 2021-10-01 | Stevens | Minnesota | 27149 | 1131 | 11 |
1774001 | 1774001 | 2021-10-01 | Yoakum | Texas | 48501 | 1131 | 30 |
1770751 | 1770751 | 2021-09-30 | Yoakum | Texas | 48501 | 1131 | 30 |
1767502 | 1767502 | 2021-09-29 | Yoakum | Texas | 48501 | 1131 | 30 |
1761858 | 1761858 | 2021-09-28 | Lincoln | Georgia | 13181 | 1131 | 32 |
1764253 | 1764253 | 2021-09-28 | Yoakum | Texas | 48501 | 1131 | 28 |
1756486 | 1756486 | 2021-09-26 | Sullivan | Missouri | 29211 | 1131 | 14 |
1753238 | 1753238 | 2021-09-25 | Sullivan | Missouri | 29211 | 1131 | 14 |
1745296 | 1745296 | 2021-09-23 | Newton | Arkansas | 5101 | 1131 | 32 |
1746107 | 1746107 | 2021-09-23 | Pratt | Kansas | 20151 | 1131 | 26 |
1746754 | 1746754 | 2021-09-23 | Carbon | Montana | 30009 | 1131 | 19 |
1742858 | 1742858 | 2021-09-22 | Pratt | Kansas | 20151 | 1131 | 26 |
1715653 | 1715653 | 2021-09-13 | Nelson | Virginia | 51125 | 1131 | 14 |
1704502 | 1704502 | 2021-09-10 | St. Clair | Missouri | 29185 | 1131 | 9 |
1699291 | 1699291 | 2021-09-08 | Emery | Utah | 49015 | 1131 | 12 |
1667199 | 1667199 | 2021-08-30 | Greene | Alabama | 1063 | 1131 | 39 |
1653586 | 1653586 | 2021-08-25 | Castro | Texas | 48069 | 1131 | 32 |
1650339 | 1650339 | 2021-08-24 | Castro | Texas | 48069 | 1131 | 32 |
1628608 | 1628608 | 2021-08-18 | Clinch | Georgia | 13065 | 1131 | 27 |
1622758 | 1622758 | 2021-08-16 | Leslie | Kentucky | 21131 | 1131 | 9 |
1618618 | 1618618 | 2021-08-15 | Scott | Arkansas | 5127 | 1131 | 18 |
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);