ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
880 rows where cases = 243 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 107
- Oregon 53
- South Dakota 46
- Georgia 42
- Kansas 42
- Kentucky 40
- Virginia 31
- Puerto Rico 27
- Indiana 25
- Iowa 23
- North Carolina 23
- Illinois 22
- North Dakota 22
- Colorado 21
- Minnesota 21
- Mississippi 21
- Nebraska 20
- New York 20
- Idaho 19
- Arkansas 17
- Louisiana 16
- Missouri 16
- West Virginia 16
- Tennessee 15
- Montana 14
- Ohio 14
- Michigan 13
- Washington 13
- Alaska 12
- Oklahoma 11
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2423686 | 2423686 | 2022-04-19 | Wheeler | Oregon | 41069 | 243 | 3 |
2420430 | 2420430 | 2022-04-18 | Wheeler | Oregon | 41069 | 243 | 3 |
2417174 | 2417174 | 2022-04-17 | Wheeler | Oregon | 41069 | 243 | 3 |
2413918 | 2413918 | 2022-04-16 | Wheeler | Oregon | 41069 | 243 | 3 |
2410662 | 2410662 | 2022-04-15 | Wheeler | Oregon | 41069 | 243 | 3 |
2326058 | 2326058 | 2022-03-20 | Wheeler | Oregon | 41069 | 243 | 3 |
2322805 | 2322805 | 2022-03-19 | Wheeler | Oregon | 41069 | 243 | 3 |
2319551 | 2319551 | 2022-03-18 | Wheeler | Oregon | 41069 | 243 | 3 |
2316297 | 2316297 | 2022-03-17 | Wheeler | Oregon | 41069 | 243 | 3 |
2313044 | 2313044 | 2022-03-16 | Wheeler | Oregon | 41069 | 243 | 3 |
2309791 | 2309791 | 2022-03-15 | Wheeler | Oregon | 41069 | 243 | 3 |
2306538 | 2306538 | 2022-03-14 | Wheeler | Oregon | 41069 | 243 | 3 |
2303287 | 2303287 | 2022-03-13 | Wheeler | Oregon | 41069 | 243 | 3 |
2300035 | 2300035 | 2022-03-12 | Wheeler | Oregon | 41069 | 243 | 3 |
2296783 | 2296783 | 2022-03-11 | Wheeler | Oregon | 41069 | 243 | 3 |
2293531 | 2293531 | 2022-03-10 | Wheeler | Oregon | 41069 | 243 | 3 |
2290279 | 2290279 | 2022-03-09 | Wheeler | Oregon | 41069 | 243 | 3 |
2287027 | 2287027 | 2022-03-08 | Wheeler | Oregon | 41069 | 243 | 3 |
2283775 | 2283775 | 2022-03-07 | Wheeler | Oregon | 41069 | 243 | 3 |
2278351 | 2278351 | 2022-03-06 | Unknown | American Samoa | 243 | 0 | |
2280523 | 2280523 | 2022-03-06 | Wheeler | Oregon | 41069 | 243 | 3 |
2277270 | 2277270 | 2022-03-05 | Wheeler | Oregon | 41069 | 243 | 3 |
2274017 | 2274017 | 2022-03-04 | Wheeler | Oregon | 41069 | 243 | 3 |
2270764 | 2270764 | 2022-03-03 | Wheeler | Oregon | 41069 | 243 | 3 |
2267512 | 2267512 | 2022-03-02 | Wheeler | Oregon | 41069 | 243 | 3 |
2264259 | 2264259 | 2022-03-01 | Wheeler | Oregon | 41069 | 243 | 3 |
2261009 | 2261009 | 2022-02-28 | Wheeler | Oregon | 41069 | 243 | 3 |
2257758 | 2257758 | 2022-02-27 | Wheeler | Oregon | 41069 | 243 | 3 |
2254507 | 2254507 | 2022-02-26 | Wheeler | Oregon | 41069 | 243 | 3 |
2251256 | 2251256 | 2022-02-25 | Wheeler | Oregon | 41069 | 243 | 3 |
2248005 | 2248005 | 2022-02-24 | Wheeler | Oregon | 41069 | 243 | 3 |
2244754 | 2244754 | 2022-02-23 | Wheeler | Oregon | 41069 | 243 | 3 |
2241503 | 2241503 | 2022-02-22 | Wheeler | Oregon | 41069 | 243 | 3 |
2238252 | 2238252 | 2022-02-21 | Wheeler | Oregon | 41069 | 243 | 3 |
2238510 | 2238510 | 2022-02-21 | Sully | South Dakota | 46119 | 243 | 3 |
2235001 | 2235001 | 2022-02-20 | Wheeler | Oregon | 41069 | 243 | 3 |
2235259 | 2235259 | 2022-02-20 | Sully | South Dakota | 46119 | 243 | 3 |
2231750 | 2231750 | 2022-02-19 | Wheeler | Oregon | 41069 | 243 | 3 |
2232008 | 2232008 | 2022-02-19 | Sully | South Dakota | 46119 | 243 | 3 |
2228499 | 2228499 | 2022-02-18 | Wheeler | Oregon | 41069 | 243 | 3 |
2228757 | 2228757 | 2022-02-18 | Sully | South Dakota | 46119 | 243 | 3 |
2225248 | 2225248 | 2022-02-17 | Wheeler | Oregon | 41069 | 243 | 3 |
2225506 | 2225506 | 2022-02-17 | Sully | South Dakota | 46119 | 243 | 3 |
2221997 | 2221997 | 2022-02-16 | Wheeler | Oregon | 41069 | 243 | 3 |
2218746 | 2218746 | 2022-02-15 | Wheeler | Oregon | 41069 | 243 | 3 |
2212502 | 2212502 | 2022-02-13 | Sully | South Dakota | 46119 | 243 | 3 |
2209249 | 2209249 | 2022-02-12 | Sully | South Dakota | 46119 | 243 | 3 |
2205996 | 2205996 | 2022-02-11 | Sully | South Dakota | 46119 | 243 | 3 |
2202743 | 2202743 | 2022-02-10 | Sully | South Dakota | 46119 | 243 | 3 |
2199489 | 2199489 | 2022-02-09 | Sully | South Dakota | 46119 | 243 | 3 |
2179101 | 2179101 | 2022-02-03 | Prairie | Montana | 30079 | 243 | 3 |
2180289 | 2180289 | 2022-02-03 | Sterling | Texas | 48431 | 243 | 5 |
2141254 | 2141254 | 2022-01-22 | Throckmorton | Texas | 48447 | 243 | 7 |
2121683 | 2121683 | 2022-01-16 | Motley | Texas | 48345 | 243 | 9 |
2114429 | 2114429 | 2022-01-14 | Sheridan | North Dakota | 38083 | 243 | 6 |
2111177 | 2111177 | 2022-01-13 | Sheridan | North Dakota | 38083 | 243 | 6 |
2107925 | 2107925 | 2022-01-12 | Sheridan | North Dakota | 38083 | 243 | 6 |
2097057 | 2097057 | 2022-01-09 | Greeley | Kansas | 20071 | 243 | 3 |
2093805 | 2093805 | 2022-01-08 | Greeley | Kansas | 20071 | 243 | 3 |
2090553 | 2090553 | 2022-01-07 | Greeley | Kansas | 20071 | 243 | 3 |
2089112 | 2089112 | 2022-01-06 | Irion | Texas | 48235 | 243 | 2 |
2018363 | 2018363 | 2021-12-16 | Cheyenne | Colorado | 8017 | 243 | 7 |
2015113 | 2015113 | 2021-12-15 | Cheyenne | Colorado | 8017 | 243 | 7 |
2011200 | 2011200 | 2021-12-13 | Stonewall | Texas | 48433 | 243 | 6 |
1993798 | 1993798 | 2021-12-08 | Deuel | Nebraska | 31049 | 243 | 2 |
1974640 | 1974640 | 2021-12-02 | Oliver | North Dakota | 38065 | 243 | 3 |
1967874 | 1967874 | 2021-11-30 | Eureka | Nevada | 32011 | 243 | 1 |
1938549 | 1938549 | 2021-11-21 | Garden | Nebraska | 31069 | 243 | 1 |
1935299 | 1935299 | 2021-11-20 | Garden | Nebraska | 31069 | 243 | 1 |
1932049 | 1932049 | 2021-11-19 | Garden | Nebraska | 31069 | 243 | 1 |
1901358 | 1901358 | 2021-11-10 | Dolores | Colorado | 8033 | 243 | 5 |
1898784 | 1898784 | 2021-11-09 | Hodgeman | Kansas | 20083 | 243 | 10 |
1895534 | 1895534 | 2021-11-08 | Hodgeman | Kansas | 20083 | 243 | 10 |
1855263 | 1855263 | 2021-10-26 | Wayne | Utah | 49055 | 243 | 0 |
1852014 | 1852014 | 2021-10-25 | Wayne | Utah | 49055 | 243 | 0 |
1835930 | 1835930 | 2021-10-20 | Garfield | Washington | 53023 | 243 | 7 |
1827704 | 1827704 | 2021-10-18 | Cook | Minnesota | 27031 | 243 | 0 |
1809555 | 1809555 | 2021-10-12 | Dickens | Texas | 48125 | 243 | 11 |
1806305 | 1806305 | 2021-10-11 | Dickens | Texas | 48125 | 243 | 11 |
1803055 | 1803055 | 2021-10-10 | Dickens | Texas | 48125 | 243 | 11 |
1799806 | 1799806 | 2021-10-09 | Dickens | Texas | 48125 | 243 | 11 |
1796557 | 1796557 | 2021-10-08 | Dickens | Texas | 48125 | 243 | 11 |
1792261 | 1792261 | 2021-10-07 | Liberty | Montana | 30051 | 243 | 1 |
1793308 | 1793308 | 2021-10-07 | Dickens | Texas | 48125 | 243 | 11 |
1787916 | 1787916 | 2021-10-06 | Webster | Georgia | 13307 | 243 | 6 |
1789012 | 1789012 | 2021-10-06 | Liberty | Montana | 30051 | 243 | 1 |
1782543 | 1782543 | 2021-10-04 | Wheatland | Montana | 30107 | 243 | 12 |
1777710 | 1777710 | 2021-10-03 | Petersburg Borough | Alaska | 2195 | 243 | 2 |
1779293 | 1779293 | 2021-10-03 | Wheatland | Montana | 30107 | 243 | 12 |
1774460 | 1774460 | 2021-10-02 | Petersburg Borough | Alaska | 2195 | 243 | 2 |
1776043 | 1776043 | 2021-10-02 | Wheatland | Montana | 30107 | 243 | 12 |
1771210 | 1771210 | 2021-10-01 | Petersburg Borough | Alaska | 2195 | 243 | 2 |
1772793 | 1772793 | 2021-10-01 | Wheatland | Montana | 30107 | 243 | 12 |
1769544 | 1769544 | 2021-09-30 | Wheatland | Montana | 30107 | 243 | 12 |
1766295 | 1766295 | 2021-09-29 | Wheatland | Montana | 30107 | 243 | 10 |
1763395 | 1763395 | 2021-09-28 | Divide | North Dakota | 38023 | 243 | 2 |
1758638 | 1758638 | 2021-09-27 | Quitman | Georgia | 13239 | 243 | 4 |
1755390 | 1755390 | 2021-09-26 | Quitman | Georgia | 13239 | 243 | 4 |
1752142 | 1752142 | 2021-09-25 | Quitman | Georgia | 13239 | 243 | 4 |
1748893 | 1748893 | 2021-09-24 | Quitman | Georgia | 13239 | 243 | 4 |
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);