ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
443 rows where cases = 906 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Nebraska 60
- Virginia 28
- Kentucky 25
- Missouri 23
- North Carolina 23
- Georgia 21
- Iowa 18
- Puerto Rico 16
- Alabama 14
- Texas 14
- Louisiana 13
- Tennessee 13
- Kansas 12
- Illinois 11
- South Carolina 11
- Michigan 10
- Montana 9
- Indiana 8
- Arkansas 7
- Minnesota 7
- Mississippi 7
- Oklahoma 7
- Rhode Island 7
- Oregon 6
- Utah 6
- West Virginia 6
- New Mexico 5
- North Dakota 5
- South Dakota 5
- Washington 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502519 | 2502519 | 2022-05-13 | Bath | Virginia | 51017 | 906 | 20 |
2216119 | 2216119 | 2022-02-14 | Garfield | Utah | 49017 | 906 | 13 |
2213012 | 2213012 | 2022-02-13 | Rappahannock | Virginia | 51157 | 906 | 10 |
2209759 | 2209759 | 2022-02-12 | Rappahannock | Virginia | 51157 | 906 | 10 |
2206506 | 2206506 | 2022-02-11 | Rappahannock | Virginia | 51157 | 906 | 10 |
2197286 | 2197286 | 2022-02-09 | Unknown | Delaware | 906 | 0 | |
2191018 | 2191018 | 2022-02-07 | Bear Lake | Idaho | 16007 | 906 | 15 |
2188682 | 2188682 | 2022-02-06 | Sharkey | Mississippi | 28125 | 906 | 21 |
2185429 | 2185429 | 2022-02-05 | Sharkey | Mississippi | 28125 | 906 | 21 |
2182177 | 2182177 | 2022-02-04 | Sharkey | Mississippi | 28125 | 906 | 21 |
2165455 | 2165455 | 2022-01-30 | Carlisle | Kentucky | 21039 | 906 | 16 |
2162200 | 2162200 | 2022-01-29 | Carlisle | Kentucky | 21039 | 906 | 16 |
2158945 | 2158945 | 2022-01-28 | Carlisle | Kentucky | 21039 | 906 | 16 |
2133257 | 2133257 | 2022-01-20 | Kittson | Minnesota | 27069 | 906 | 25 |
2133722 | 2133722 | 2022-01-20 | Hidalgo | New Mexico | 35023 | 906 | 12 |
2125154 | 2125154 | 2022-01-17 | Norton city | Virginia | 51720 | 906 | 20 |
2110779 | 2110779 | 2022-01-13 | Phillips | Montana | 30071 | 906 | 27 |
2095787 | 2095787 | 2022-01-08 | Essex | Vermont | 50009 | 906 | 3 |
2086354 | 2086354 | 2022-01-05 | Hot Springs | Wyoming | 56017 | 906 | 11 |
2080469 | 2080469 | 2022-01-04 | Alexander | Illinois | 17003 | 906 | 13 |
2081608 | 2081608 | 2022-01-04 | Polk | Nebraska | 31143 | 906 | 18 |
2081819 | 2081819 | 2022-01-04 | Hyde | North Carolina | 37095 | 906 | 12 |
2083102 | 2083102 | 2022-01-04 | Hot Springs | Wyoming | 56017 | 906 | 11 |
2021180 | 2021180 | 2021-12-16 | Ferry | Washington | 53019 | 906 | 18 |
2006064 | 2006064 | 2021-12-12 | Mitchell | Kansas | 20123 | 906 | 17 |
2002813 | 2002813 | 2021-12-11 | Mitchell | Kansas | 20123 | 906 | 17 |
1999563 | 1999563 | 2021-12-10 | Mitchell | Kansas | 20123 | 906 | 17 |
1991366 | 1991366 | 2021-12-07 | Moody | South Dakota | 46101 | 906 | 23 |
1964377 | 1964377 | 2021-11-29 | Dade | Missouri | 29057 | 906 | 38 |
1961126 | 1961126 | 2021-11-28 | Dade | Missouri | 29057 | 906 | 38 |
1957875 | 1957875 | 2021-11-27 | Dade | Missouri | 29057 | 906 | 38 |
1954624 | 1954624 | 2021-11-26 | Dade | Missouri | 29057 | 906 | 38 |
1951373 | 1951373 | 2021-11-25 | Dade | Missouri | 29057 | 906 | 38 |
1948122 | 1948122 | 2021-11-24 | Dade | Missouri | 29057 | 906 | 38 |
1945869 | 1945869 | 2021-11-23 | Tripp | South Dakota | 46123 | 906 | 20 |
1921477 | 1921477 | 2021-11-16 | Taylor | Iowa | 19173 | 906 | 14 |
1922212 | 1922212 | 2021-11-16 | Broadwater | Montana | 30007 | 906 | 17 |
1918227 | 1918227 | 2021-11-15 | Taylor | Iowa | 19173 | 906 | 14 |
1914977 | 1914977 | 2021-11-14 | Taylor | Iowa | 19173 | 906 | 14 |
1911727 | 1911727 | 2021-11-13 | Taylor | Iowa | 19173 | 906 | 14 |
1908478 | 1908478 | 2021-11-12 | Taylor | Iowa | 19173 | 906 | 14 |
1905229 | 1905229 | 2021-11-11 | Taylor | Iowa | 19173 | 906 | 14 |
1901979 | 1901979 | 2021-11-10 | Taylor | Iowa | 19173 | 906 | 14 |
1881608 | 1881608 | 2021-11-04 | Choctaw | Alabama | 1023 | 906 | 27 |
1857635 | 1857635 | 2021-10-27 | McHenry | North Dakota | 38049 | 906 | 23 |
1854862 | 1854862 | 2021-10-26 | McCook | South Dakota | 46087 | 906 | 25 |
1824833 | 1824833 | 2021-10-17 | Keith | Nebraska | 31101 | 906 | 11 |
1821584 | 1821584 | 2021-10-16 | Keith | Nebraska | 31101 | 906 | 11 |
1818335 | 1818335 | 2021-10-15 | Keith | Nebraska | 31101 | 906 | 11 |
1793512 | 1793512 | 2021-10-07 | Kane | Utah | 49025 | 906 | 9 |
1786134 | 1786134 | 2021-10-05 | Bottineau | North Dakota | 38009 | 906 | 20 |
1783882 | 1783882 | 2021-10-04 | Middlesex | Virginia | 51119 | 906 | 25 |
1780627 | 1780627 | 2021-10-03 | Madison | Virginia | 51113 | 906 | 20 |
1777377 | 1777377 | 2021-10-02 | Madison | Virginia | 51113 | 906 | 20 |
1774127 | 1774127 | 2021-10-01 | Madison | Virginia | 51113 | 906 | 20 |
1769240 | 1769240 | 2021-09-30 | Lac qui Parle | Minnesota | 27073 | 906 | 24 |
1759964 | 1759964 | 2021-09-27 | Quay | New Mexico | 35037 | 906 | 14 |
1756574 | 1756574 | 2021-09-26 | Dawes | Nebraska | 31045 | 906 | 20 |
1753326 | 1753326 | 2021-09-25 | Dawes | Nebraska | 31045 | 906 | 20 |
1750078 | 1750078 | 2021-09-24 | Dawes | Nebraska | 31045 | 906 | 20 |
1746866 | 1746866 | 2021-09-23 | Merrick | Nebraska | 31121 | 906 | 15 |
1739123 | 1739123 | 2021-09-21 | Marion | Georgia | 13197 | 906 | 28 |
1741786 | 1741786 | 2021-09-21 | Webster | West Virginia | 54101 | 906 | 13 |
1724780 | 1724780 | 2021-09-16 | Rincon | Puerto Rico | 72117 | 906 | |
1721531 | 1721531 | 2021-09-15 | Rincon | Puerto Rico | 72117 | 906 | |
1701296 | 1701296 | 2021-09-09 | Madison | Montana | 30057 | 906 | 8 |
1693667 | 1693667 | 2021-09-07 | Randolph | Georgia | 13243 | 906 | 36 |
1695196 | 1695196 | 2021-09-07 | Pembina | North Dakota | 38067 | 906 | 11 |
1695936 | 1695936 | 2021-09-07 | Marion | Texas | 48315 | 906 | 35 |
1696036 | 1696036 | 2021-09-07 | Beaver | Utah | 49001 | 906 | 10 |
1683300 | 1683300 | 2021-09-03 | Ritchie | West Virginia | 54085 | 906 | 11 |
1679781 | 1679781 | 2021-09-02 | Winkler | Texas | 48495 | 906 | 23 |
1679964 | 1679964 | 2021-09-02 | Williamsburg city | Virginia | 51830 | 906 | 14 |
1676294 | 1676294 | 2021-09-01 | Bailey | Texas | 48017 | 906 | 21 |
1673495 | 1673495 | 2021-08-31 | Lincoln | Washington | 53043 | 906 | 12 |
1667851 | 1667851 | 2021-08-30 | Schuyler | Illinois | 17169 | 906 | 19 |
1663588 | 1663588 | 2021-08-28 | Orange | Vermont | 50017 | 906 | 3 |
1655215 | 1655215 | 2021-08-26 | Gallatin | Kentucky | 21077 | 906 | 34 |
1653263 | 1653263 | 2021-08-25 | Aibonito | Puerto Rico | 72009 | 906 | |
1639449 | 1639449 | 2021-08-21 | Chariton | Missouri | 29041 | 906 | 8 |
1632412 | 1632412 | 2021-08-19 | Russell | Kansas | 20167 | 906 | 29 |
1629165 | 1629165 | 2021-08-18 | Russell | Kansas | 20167 | 906 | 29 |
1614307 | 1614307 | 2021-08-13 | Florida | Puerto Rico | 72054 | 906 | |
1610274 | 1610274 | 2021-08-12 | Ozark | Missouri | 29153 | 906 | 24 |
1608401 | 1608401 | 2021-08-11 | Charlotte | Virginia | 51037 | 906 | 21 |
1604610 | 1604610 | 2021-08-10 | Villalba | Puerto Rico | 72149 | 906 | |
1604819 | 1604819 | 2021-08-10 | Van Buren | Tennessee | 47175 | 906 | 23 |
1601361 | 1601361 | 2021-08-09 | Villalba | Puerto Rico | 72149 | 906 | |
1598113 | 1598113 | 2021-08-08 | Villalba | Puerto Rico | 72149 | 906 | |
1579177 | 1579177 | 2021-08-02 | Floyd | Virginia | 51063 | 906 | 22 |
1563850 | 1563850 | 2021-07-29 | Hamilton | Illinois | 17065 | 906 | 19 |
1564883 | 1564883 | 2021-07-29 | Valley | Montana | 30105 | 906 | 18 |
1561635 | 1561635 | 2021-07-28 | Valley | Montana | 30105 | 906 | 18 |
1563169 | 1563169 | 2021-07-28 | Pepin | Wisconsin | 55091 | 906 | 7 |
1557252 | 1557252 | 2021-07-27 | Treutlen | Georgia | 13283 | 906 | 34 |
1546585 | 1546585 | 2021-07-23 | Trinity | Texas | 48455 | 906 | 31 |
1541085 | 1541085 | 2021-07-22 | Valley | Idaho | 16085 | 906 | 6 |
1543187 | 1543187 | 2021-07-22 | Floyd | Texas | 48153 | 906 | 30 |
1537806 | 1537806 | 2021-07-21 | Boundary | Idaho | 16021 | 906 | 11 |
1539939 | 1539939 | 2021-07-21 | Floyd | Texas | 48153 | 906 | 30 |
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);