ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
646 rows where cases = 613 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kansas 129
- Texas 77
- Minnesota 28
- Alabama 24
- Georgia 24
- Virginia 23
- South Dakota 22
- Iowa 20
- Kentucky 18
- Tennessee 16
- Mississippi 15
- Puerto Rico 15
- Missouri 14
- Nebraska 13
- North Carolina 13
- Colorado 12
- Illinois 12
- Louisiana 12
- Michigan 12
- Oklahoma 12
- North Dakota 11
- Indiana 10
- Montana 10
- Pennsylvania 10
- West Virginia 10
- New Mexico 8
- Alaska 6
- Idaho 6
- Utah 6
- Florida 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502649 | 2502649 | 2022-05-13 | Columbia | Washington | 53013 | 613 | 16 |
2499391 | 2499391 | 2022-05-12 | Columbia | Washington | 53013 | 613 | 16 |
2496133 | 2496133 | 2022-05-11 | Columbia | Washington | 53013 | 613 | 16 |
2292181 | 2292181 | 2022-03-10 | Decatur | Kansas | 20039 | 613 | 19 |
2288929 | 2288929 | 2022-03-09 | Decatur | Kansas | 20039 | 613 | 19 |
2285678 | 2285678 | 2022-03-08 | Decatur | Kansas | 20039 | 613 | 19 |
2282426 | 2282426 | 2022-03-07 | Decatur | Kansas | 20039 | 613 | 19 |
2246689 | 2246689 | 2022-02-24 | Lincoln | Kansas | 20105 | 613 | 9 |
2243438 | 2243438 | 2022-02-23 | Lincoln | Kansas | 20105 | 613 | 9 |
2199438 | 2199438 | 2022-02-09 | Buffalo | South Dakota | 46017 | 613 | 17 |
2196184 | 2196184 | 2022-02-08 | Buffalo | South Dakota | 46017 | 613 | 17 |
2192930 | 2192930 | 2022-02-07 | Buffalo | South Dakota | 46017 | 613 | 17 |
2189257 | 2189257 | 2022-02-06 | Towner | North Dakota | 38095 | 613 | 12 |
2189676 | 2189676 | 2022-02-06 | Buffalo | South Dakota | 46017 | 613 | 17 |
2186004 | 2186004 | 2022-02-05 | Towner | North Dakota | 38095 | 613 | 12 |
2186423 | 2186423 | 2022-02-05 | Buffalo | South Dakota | 46017 | 613 | 17 |
2183171 | 2183171 | 2022-02-04 | Buffalo | South Dakota | 46017 | 613 | 17 |
2171930 | 2171930 | 2022-02-01 | Smith | Kansas | 20183 | 613 | 7 |
2168677 | 2168677 | 2022-01-31 | Smith | Kansas | 20183 | 613 | 7 |
2157340 | 2157340 | 2022-01-27 | Collingsworth | Texas | 48087 | 613 | 13 |
2154087 | 2154087 | 2022-01-26 | Collingsworth | Texas | 48087 | 613 | 13 |
2150835 | 2150835 | 2022-01-25 | Collingsworth | Texas | 48087 | 613 | 13 |
2145472 | 2145472 | 2022-01-24 | Adams | Idaho | 16003 | 613 | 14 |
2134412 | 2134412 | 2022-01-20 | Potter | South Dakota | 46107 | 613 | 5 |
2126361 | 2126361 | 2022-01-18 | Rawlins | Kansas | 20153 | 613 | 8 |
2123109 | 2123109 | 2022-01-17 | Rawlins | Kansas | 20153 | 613 | 8 |
2123890 | 2123890 | 2022-01-17 | Stanton | Nebraska | 31167 | 613 | 11 |
2119857 | 2119857 | 2022-01-16 | Rawlins | Kansas | 20153 | 613 | 8 |
2116605 | 2116605 | 2022-01-15 | Rawlins | Kansas | 20153 | 613 | 8 |
2113354 | 2113354 | 2022-01-14 | Rawlins | Kansas | 20153 | 613 | 8 |
2098943 | 2098943 | 2022-01-09 | Real | Texas | 48385 | 613 | 21 |
2081529 | 2081529 | 2022-01-04 | Sweet Grass | Montana | 30097 | 613 | 8 |
2078277 | 2078277 | 2022-01-03 | Sweet Grass | Montana | 30097 | 613 | 8 |
2075382 | 2075382 | 2022-01-02 | Eddy | North Dakota | 38027 | 613 | 6 |
2055595 | 2055595 | 2021-12-27 | Nance | Nebraska | 31125 | 613 | 10 |
2052345 | 2052345 | 2021-12-26 | Nance | Nebraska | 31125 | 613 | 10 |
2049095 | 2049095 | 2021-12-25 | Nance | Nebraska | 31125 | 613 | 10 |
2045845 | 2045845 | 2021-12-24 | Nance | Nebraska | 31125 | 613 | 10 |
2042595 | 2042595 | 2021-12-23 | Nance | Nebraska | 31125 | 613 | 10 |
2035291 | 2035291 | 2021-12-21 | Gove | Kansas | 20063 | 613 | 23 |
2032041 | 2032041 | 2021-12-20 | Gove | Kansas | 20063 | 613 | 23 |
2020147 | 2020147 | 2021-12-16 | Nelson | North Dakota | 38063 | 613 | 16 |
2012549 | 2012549 | 2021-12-14 | Jewell | Kansas | 20089 | 613 | 11 |
2009298 | 2009298 | 2021-12-13 | Jewell | Kansas | 20089 | 613 | 11 |
2006511 | 2006511 | 2021-12-12 | Traverse | Minnesota | 27155 | 613 | 6 |
2003260 | 2003260 | 2021-12-11 | Traverse | Minnesota | 27155 | 613 | 6 |
2000010 | 2000010 | 2021-12-10 | Traverse | Minnesota | 27155 | 613 | 6 |
1992780 | 1992780 | 2021-12-08 | Pope | Illinois | 17151 | 613 | 6 |
1993508 | 1993508 | 2021-12-08 | Traverse | Minnesota | 27155 | 613 | 6 |
1929783 | 1929783 | 2021-11-18 | Donley | Texas | 48129 | 613 | 18 |
1926533 | 1926533 | 2021-11-17 | Donley | Texas | 48129 | 613 | 18 |
1917665 | 1917665 | 2021-11-15 | Unknown | Delaware | 613 | 0 | |
1906172 | 1906172 | 2021-11-11 | Hidalgo | New Mexico | 35023 | 613 | 11 |
1902923 | 1902923 | 2021-11-10 | Hidalgo | New Mexico | 35023 | 613 | 11 |
1903952 | 1903952 | 2021-11-10 | Upton | Texas | 48461 | 613 | 14 |
1900702 | 1900702 | 2021-11-09 | Upton | Texas | 48461 | 613 | 14 |
1894189 | 1894189 | 2021-11-07 | Sutton | Texas | 48435 | 613 | 11 |
1882586 | 1882586 | 2021-11-04 | Stafford | Kansas | 20185 | 613 | 16 |
1879337 | 1879337 | 2021-11-03 | Stafford | Kansas | 20185 | 613 | 16 |
1867410 | 1867410 | 2021-10-30 | Wells | North Dakota | 38103 | 613 | 9 |
1860163 | 1860163 | 2021-10-28 | Ontonagon | Michigan | 26131 | 613 | 22 |
1856914 | 1856914 | 2021-10-27 | Ontonagon | Michigan | 26131 | 613 | 22 |
1842085 | 1842085 | 2021-10-22 | Haskell | Texas | 48207 | 613 | 31 |
1792206 | 1792206 | 2021-10-07 | Putnam | Missouri | 29171 | 613 | 9 |
1788957 | 1788957 | 2021-10-06 | Putnam | Missouri | 29171 | 613 | 9 |
1790259 | 1790259 | 2021-10-06 | Garfield | Utah | 49017 | 613 | 11 |
1785769 | 1785769 | 2021-10-05 | Mineral | Montana | 30061 | 613 | 10 |
1745724 | 1745724 | 2021-09-23 | Lincoln | Idaho | 16063 | 613 | 11 |
1740309 | 1740309 | 2021-09-21 | Antelope | Nebraska | 31003 | 613 | 8 |
1723795 | 1723795 | 2021-09-16 | Unknown | Minnesota | 613 | 93 | |
1701694 | 1701694 | 2021-09-09 | Pierce | North Dakota | 38069 | 613 | 26 |
1697786 | 1697786 | 2021-09-08 | Norman | Minnesota | 27107 | 613 | 9 |
1691276 | 1691276 | 2021-09-06 | Lincoln | Minnesota | 27081 | 613 | 4 |
1688026 | 1688026 | 2021-09-05 | Lincoln | Minnesota | 27081 | 613 | 4 |
1684776 | 1684776 | 2021-09-04 | Lincoln | Minnesota | 27081 | 613 | 4 |
1681525 | 1681525 | 2021-09-03 | Lincoln | Minnesota | 27081 | 613 | 4 |
1673123 | 1673123 | 2021-08-31 | Garza | Texas | 48169 | 613 | 22 |
1669875 | 1669875 | 2021-08-30 | Garza | Texas | 48169 | 613 | 22 |
1664916 | 1664916 | 2021-08-29 | Washington | Kansas | 20201 | 613 | 14 |
1665749 | 1665749 | 2021-08-29 | Los Alamos | New Mexico | 35028 | 613 | 7 |
1666628 | 1666628 | 2021-08-29 | Garza | Texas | 48169 | 613 | 22 |
1661668 | 1661668 | 2021-08-28 | Washington | Kansas | 20201 | 613 | 14 |
1662501 | 1662501 | 2021-08-28 | Los Alamos | New Mexico | 35028 | 613 | 7 |
1663380 | 1663380 | 2021-08-28 | Garza | Texas | 48169 | 613 | 22 |
1658420 | 1658420 | 2021-08-27 | Washington | Kansas | 20201 | 613 | 14 |
1659253 | 1659253 | 2021-08-27 | Los Alamos | New Mexico | 35028 | 613 | 7 |
1651449 | 1651449 | 2021-08-25 | Talbot | Georgia | 13263 | 613 | 20 |
1650826 | 1650826 | 2021-08-24 | Tucker | West Virginia | 54093 | 613 | 10 |
1641868 | 1641868 | 2021-08-22 | Scott | Illinois | 17171 | 613 | 2 |
1638618 | 1638618 | 2021-08-21 | Scott | Illinois | 17171 | 613 | 2 |
1635368 | 1635368 | 2021-08-20 | Scott | Illinois | 17171 | 613 | 2 |
1632837 | 1632837 | 2021-08-19 | Unknown | Minnesota | 613 | 93 | |
1625379 | 1625379 | 2021-08-17 | Echols | Georgia | 13101 | 613 | 9 |
1624367 | 1624367 | 2021-08-16 | Crane | Texas | 48103 | 613 | 14 |
1621120 | 1621120 | 2021-08-15 | Crane | Texas | 48103 | 613 | 14 |
1587154 | 1587154 | 2021-08-05 | Piscataquis | Maine | 23021 | 613 | 7 |
1583904 | 1583904 | 2021-08-04 | Piscataquis | Maine | 23021 | 613 | 7 |
1580790 | 1580790 | 2021-08-03 | Big Stone | Minnesota | 27011 | 613 | 4 |
1581943 | 1581943 | 2021-08-03 | Fall River | South Dakota | 46047 | 613 | 16 |
1577541 | 1577541 | 2021-08-02 | Big Stone | Minnesota | 27011 | 613 | 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);