ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
380 rows where cases = 1170 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Virginia 39
- Texas 25
- Georgia 22
- Iowa 22
- Kansas 19
- Kentucky 19
- Illinois 18
- Minnesota 18
- Oklahoma 17
- Michigan 13
- Louisiana 11
- Missouri 10
- West Virginia 10
- Arkansas 9
- Mississippi 9
- Puerto Rico 9
- Nebraska 8
- North Carolina 8
- North Dakota 8
- South Dakota 8
- Indiana 7
- Wisconsin 7
- Alabama 5
- Florida 5
- Ohio 5
- Tennessee 5
- Idaho 4
- South Carolina 4
- Washington 4
- Connecticut 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2468653 | 2468653 | 2022-05-03 | Pondera | Montana | 30073 | 1170 | 8 |
2463443 | 2463443 | 2022-05-01 | Charles City | Virginia | 51036 | 1170 | 27 |
2460187 | 2460187 | 2022-04-30 | Charles City | Virginia | 51036 | 1170 | 27 |
2456931 | 2456931 | 2022-04-29 | Charles City | Virginia | 51036 | 1170 | 27 |
2385221 | 2385221 | 2022-04-07 | Wheeler | Texas | 48483 | 1170 | 23 |
2381966 | 2381966 | 2022-04-06 | Wheeler | Texas | 48483 | 1170 | 23 |
2378711 | 2378711 | 2022-04-05 | Wheeler | Texas | 48483 | 1170 | 23 |
2375457 | 2375457 | 2022-04-04 | Wheeler | Texas | 48483 | 1170 | 23 |
2372205 | 2372205 | 2022-04-03 | Wheeler | Texas | 48483 | 1170 | 23 |
2368952 | 2368952 | 2022-04-02 | Wheeler | Texas | 48483 | 1170 | 23 |
2261458 | 2261458 | 2022-02-28 | Goliad | Texas | 48175 | 1170 | 32 |
2258207 | 2258207 | 2022-02-27 | Goliad | Texas | 48175 | 1170 | 32 |
2254956 | 2254956 | 2022-02-26 | Goliad | Texas | 48175 | 1170 | 32 |
2201937 | 2201937 | 2022-02-10 | Jefferson | Nebraska | 31095 | 1170 | 6 |
2196673 | 2196673 | 2022-02-08 | Cumberland | Virginia | 51049 | 1170 | 21 |
2188337 | 2188337 | 2022-02-06 | Cameron | Louisiana | 22023 | 1170 | 8 |
2185084 | 2185084 | 2022-02-05 | Cameron | Louisiana | 22023 | 1170 | 8 |
2181832 | 2181832 | 2022-02-04 | Cameron | Louisiana | 22023 | 1170 | 8 |
2165390 | 2165390 | 2022-01-30 | Meade | Kansas | 20119 | 1170 | 15 |
2162135 | 2162135 | 2022-01-29 | Meade | Kansas | 20119 | 1170 | 15 |
2158880 | 2158880 | 2022-01-28 | Meade | Kansas | 20119 | 1170 | 15 |
2160754 | 2160754 | 2022-01-28 | Sabine | Texas | 48403 | 1170 | 78 |
2156623 | 2156623 | 2022-01-27 | Hyde | North Carolina | 37095 | 1170 | 13 |
2152004 | 2152004 | 2022-01-26 | Lemhi | Idaho | 16059 | 1170 | 25 |
2149108 | 2149108 | 2022-01-25 | Kearny | Kansas | 20093 | 1170 | 18 |
2150647 | 2150647 | 2022-01-25 | Day | South Dakota | 46037 | 1170 | 32 |
2145856 | 2145856 | 2022-01-24 | Kearny | Kansas | 20093 | 1170 | 18 |
2145997 | 2145997 | 2022-01-24 | Menifee | Kentucky | 21165 | 1170 | 28 |
2147699 | 2147699 | 2022-01-24 | McCulloch | Texas | 48307 | 1170 | 42 |
2124661 | 2124661 | 2022-01-17 | Tripp | South Dakota | 46123 | 1170 | 21 |
2121409 | 2121409 | 2022-01-16 | Tripp | South Dakota | 46123 | 1170 | 21 |
2121892 | 2121892 | 2022-01-16 | Mathews | Virginia | 51115 | 1170 | 24 |
2118157 | 2118157 | 2022-01-15 | Tripp | South Dakota | 46123 | 1170 | 21 |
2118640 | 2118640 | 2022-01-15 | Mathews | Virginia | 51115 | 1170 | 24 |
2114906 | 2114906 | 2022-01-14 | Tripp | South Dakota | 46123 | 1170 | 21 |
2115388 | 2115388 | 2022-01-14 | Mathews | Virginia | 51115 | 1170 | 24 |
2087966 | 2087966 | 2022-01-06 | Shelby | Missouri | 29205 | 1170 | 13 |
2089337 | 2089337 | 2022-01-06 | Falls Church city | Virginia | 51610 | 1170 | 14 |
2089564 | 2089564 | 2022-01-06 | Menominee | Wisconsin | 55078 | 1170 | 12 |
2084488 | 2084488 | 2022-01-05 | Mahnomen | Minnesota | 27087 | 1170 | 16 |
2081236 | 2081236 | 2022-01-04 | Mahnomen | Minnesota | 27087 | 1170 | 16 |
2081554 | 2081554 | 2022-01-04 | Clay | Nebraska | 31035 | 1170 | 17 |
2060049 | 2060049 | 2021-12-28 | Bland | Virginia | 51021 | 1170 | 18 |
2044297 | 2044297 | 2021-12-24 | Woodruff | Arkansas | 5147 | 1170 | 24 |
2041048 | 2041048 | 2021-12-23 | Woodruff | Arkansas | 5147 | 1170 | 24 |
2043828 | 2043828 | 2021-12-23 | Fairfax city | Virginia | 51600 | 1170 | 36 |
2029180 | 2029180 | 2021-12-19 | Schoolcraft | Michigan | 26153 | 1170 | 7 |
2025929 | 2025929 | 2021-12-18 | Schoolcraft | Michigan | 26153 | 1170 | 7 |
2022678 | 2022678 | 2021-12-17 | Schoolcraft | Michigan | 26153 | 1170 | 7 |
2012214 | 2012214 | 2021-12-14 | Brown | Illinois | 17009 | 1170 | 18 |
2012543 | 2012543 | 2021-12-14 | Harper | Kansas | 20077 | 1170 | 25 |
2009292 | 2009292 | 2021-12-13 | Harper | Kansas | 20077 | 1170 | 25 |
2010368 | 2010368 | 2021-12-13 | Bottineau | North Dakota | 38009 | 1170 | 23 |
2007117 | 2007117 | 2021-12-12 | Bottineau | North Dakota | 38009 | 1170 | 23 |
1994827 | 1994827 | 2021-12-08 | Hansford | Texas | 48195 | 1170 | 26 |
1961331 | 1961331 | 2021-11-28 | Merrick | Nebraska | 31121 | 1170 | 15 |
1958080 | 1958080 | 2021-11-27 | Merrick | Nebraska | 31121 | 1170 | 15 |
1954829 | 1954829 | 2021-11-26 | Merrick | Nebraska | 31121 | 1170 | 15 |
1951578 | 1951578 | 2021-11-25 | Merrick | Nebraska | 31121 | 1170 | 15 |
1948327 | 1948327 | 2021-11-24 | Merrick | Nebraska | 31121 | 1170 | 15 |
1933011 | 1933011 | 2021-11-19 | Coleman | Texas | 48083 | 1170 | 54 |
1929760 | 1929760 | 2021-11-18 | Coleman | Texas | 48083 | 1170 | 54 |
1921466 | 1921466 | 2021-11-16 | Pocahontas | Iowa | 19151 | 1170 | 24 |
1918216 | 1918216 | 2021-11-15 | Pocahontas | Iowa | 19151 | 1170 | 24 |
1914966 | 1914966 | 2021-11-14 | Pocahontas | Iowa | 19151 | 1170 | 24 |
1911716 | 1911716 | 2021-11-13 | Pocahontas | Iowa | 19151 | 1170 | 24 |
1908467 | 1908467 | 2021-11-12 | Pocahontas | Iowa | 19151 | 1170 | 24 |
1905218 | 1905218 | 2021-11-11 | Pocahontas | Iowa | 19151 | 1170 | 24 |
1901968 | 1901968 | 2021-11-10 | Pocahontas | Iowa | 19151 | 1170 | 24 |
1875921 | 1875921 | 2021-11-02 | Davis | Iowa | 19051 | 1170 | 25 |
1872672 | 1872672 | 2021-11-01 | Davis | Iowa | 19051 | 1170 | 25 |
1869423 | 1869423 | 2021-10-31 | Davis | Iowa | 19051 | 1170 | 25 |
1866174 | 1866174 | 2021-10-30 | Davis | Iowa | 19051 | 1170 | 25 |
1862925 | 1862925 | 2021-10-29 | Davis | Iowa | 19051 | 1170 | 25 |
1859676 | 1859676 | 2021-10-28 | Davis | Iowa | 19051 | 1170 | 25 |
1855766 | 1855766 | 2021-10-27 | Newton | Arkansas | 5101 | 1170 | 37 |
1856427 | 1856427 | 2021-10-27 | Davis | Iowa | 19051 | 1170 | 25 |
1858805 | 1858805 | 2021-10-27 | Pepin | Wisconsin | 55091 | 1170 | 10 |
1852443 | 1852443 | 2021-10-26 | Sitka City and Borough | Alaska | 2220 | 1170 | 4 |
1852517 | 1852517 | 2021-10-26 | Newton | Arkansas | 5101 | 1170 | 37 |
1801278 | 1801278 | 2021-10-10 | Clay | Kansas | 20027 | 1170 | 31 |
1798029 | 1798029 | 2021-10-09 | Clay | Kansas | 20027 | 1170 | 31 |
1794780 | 1794780 | 2021-10-08 | Clay | Kansas | 20027 | 1170 | 31 |
1781805 | 1781805 | 2021-10-04 | Grant | Kansas | 20067 | 1170 | 25 |
1779059 | 1779059 | 2021-10-03 | Franklin | Mississippi | 28037 | 1170 | 28 |
1780575 | 1780575 | 2021-10-03 | Charlotte | Virginia | 51037 | 1170 | 24 |
1775809 | 1775809 | 2021-10-02 | Franklin | Mississippi | 28037 | 1170 | 28 |
1777325 | 1777325 | 2021-10-02 | Charlotte | Virginia | 51037 | 1170 | 24 |
1772559 | 1772559 | 2021-10-01 | Franklin | Mississippi | 28037 | 1170 | 28 |
1773466 | 1773466 | 2021-10-01 | Barceloneta | Puerto Rico | 72017 | 1170 | |
1774075 | 1774075 | 2021-10-01 | Charlotte | Virginia | 51037 | 1170 | 24 |
1768034 | 1768034 | 2021-09-30 | Monroe | Arkansas | 5095 | 1170 | 21 |
1769310 | 1769310 | 2021-09-30 | Franklin | Mississippi | 28037 | 1170 | 28 |
1770216 | 1770216 | 2021-09-30 | Barceloneta | Puerto Rico | 72017 | 1170 | |
1764785 | 1764785 | 2021-09-29 | Monroe | Arkansas | 5095 | 1170 | 21 |
1767244 | 1767244 | 2021-09-29 | Van Buren | Tennessee | 47175 | 1170 | 25 |
1750439 | 1750439 | 2021-09-24 | Traill | North Dakota | 38097 | 1170 | 18 |
1745625 | 1745625 | 2021-09-23 | Miller | Georgia | 13201 | 1170 | 17 |
1725357 | 1725357 | 2021-09-16 | Floyd | Virginia | 51063 | 1170 | 24 |
1699686 | 1699686 | 2021-09-09 | Greene | Alabama | 1063 | 1170 | 40 |
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);