ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
427 rows where cases = 1132 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 34
- Virginia 27
- Arkansas 22
- Georgia 21
- Louisiana 21
- Kansas 19
- Missouri 19
- Montana 17
- Kentucky 16
- Minnesota 13
- Puerto Rico 12
- Alabama 11
- Idaho 11
- Illinois 11
- Iowa 11
- Michigan 11
- Mississippi 11
- Oklahoma 11
- Tennessee 11
- Wyoming 11
- Washington 10
- Indiana 8
- North Carolina 8
- Alaska 7
- West Virginia 7
- Colorado 6
- Ohio 6
- South Dakota 5
- Wisconsin 5
- California 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502498 | 2502498 | 2022-05-13 | Grand Isle | Vermont | 50013 | 1132 | 5 |
2463488 | 2463488 | 2022-05-01 | King and Queen | Virginia | 51097 | 1132 | 12 |
2460232 | 2460232 | 2022-04-30 | King and Queen | Virginia | 51097 | 1132 | 12 |
2456976 | 2456976 | 2022-04-29 | King and Queen | Virginia | 51097 | 1132 | 12 |
2453720 | 2453720 | 2022-04-28 | King and Queen | Virginia | 51097 | 1132 | 12 |
2450464 | 2450464 | 2022-04-27 | King and Queen | Virginia | 51097 | 1132 | 12 |
2443333 | 2443333 | 2022-04-25 | Las Marias | Puerto Rico | 72083 | 1132 | |
2395959 | 2395959 | 2022-04-11 | Lewis | Idaho | 16061 | 1132 | 29 |
2258582 | 2258582 | 2022-02-27 | San Juan | Washington | 53055 | 1132 | 1 |
2255331 | 2255331 | 2022-02-26 | San Juan | Washington | 53055 | 1132 | 1 |
2252080 | 2252080 | 2022-02-25 | San Juan | Washington | 53055 | 1132 | 1 |
2246040 | 2246040 | 2022-02-24 | Saguache | Colorado | 8109 | 1132 | 12 |
2242789 | 2242789 | 2022-02-23 | Saguache | Colorado | 8109 | 1132 | 12 |
2224634 | 2224634 | 2022-02-17 | Pondera | Montana | 30073 | 1132 | 6 |
2221383 | 2221383 | 2022-02-16 | Pondera | Montana | 30073 | 1132 | 6 |
2155675 | 2155675 | 2022-01-27 | Ballard | Kentucky | 21007 | 1132 | 26 |
2147745 | 2147745 | 2022-01-24 | San Saba | Texas | 48411 | 1132 | 29 |
2133228 | 2133228 | 2022-01-20 | Big Stone | Minnesota | 27011 | 1132 | 7 |
2131877 | 2131877 | 2022-01-19 | Crook | Wyoming | 56011 | 1132 | 22 |
2121266 | 2121266 | 2022-01-16 | Maunabo | Puerto Rico | 72095 | 1132 | |
2114733 | 2114733 | 2022-01-14 | Ceiba | Puerto Rico | 72037 | 1132 | |
2102023 | 2102023 | 2022-01-10 | Brewster | Texas | 48043 | 1132 | 24 |
2084471 | 2084471 | 2022-01-05 | Grant | Minnesota | 27051 | 1132 | 12 |
2082500 | 2082500 | 2022-01-04 | Bailey | Texas | 48017 | 1132 | 31 |
2076042 | 2076042 | 2022-01-02 | Crosby | Texas | 48107 | 1132 | 41 |
2076371 | 2076371 | 2022-01-02 | Middlesex | Virginia | 51119 | 1132 | 34 |
2072791 | 2072791 | 2022-01-01 | Crosby | Texas | 48107 | 1132 | 41 |
2073120 | 2073120 | 2022-01-01 | Middlesex | Virginia | 51119 | 1132 | 34 |
2069540 | 2069540 | 2021-12-31 | Crosby | Texas | 48107 | 1132 | 41 |
2069869 | 2069869 | 2021-12-31 | Middlesex | Virginia | 51119 | 1132 | 34 |
2066289 | 2066289 | 2021-12-30 | Crosby | Texas | 48107 | 1132 | 41 |
2062094 | 2062094 | 2021-12-29 | Nemaha | Nebraska | 31127 | 1132 | 16 |
2019104 | 2019104 | 2021-12-16 | Wabaunsee | Kansas | 20197 | 1132 | 19 |
2015854 | 2015854 | 2021-12-15 | Wabaunsee | Kansas | 20197 | 1132 | 19 |
2016580 | 2016580 | 2021-12-15 | Keith | Nebraska | 31101 | 1132 | 11 |
1978501 | 1978501 | 2021-12-03 | Brooks | Texas | 48047 | 1132 | 47 |
1942590 | 1942590 | 2021-11-22 | Hutchinson | South Dakota | 46067 | 1132 | 28 |
1937030 | 1937030 | 2021-11-21 | Woodruff | Arkansas | 5147 | 1132 | 24 |
1933780 | 1933780 | 2021-11-20 | Woodruff | Arkansas | 5147 | 1132 | 24 |
1930528 | 1930528 | 2021-11-19 | Woodruff | Arkansas | 5147 | 1132 | 24 |
1927278 | 1927278 | 2021-11-18 | Woodruff | Arkansas | 5147 | 1132 | 24 |
1928416 | 1928416 | 2021-11-18 | Unknown | Michigan | 1132 | 17 | |
1922170 | 1922170 | 2021-11-16 | Ozark | Missouri | 29153 | 1132 | 30 |
1914879 | 1914879 | 2021-11-14 | Union | Indiana | 18161 | 1132 | 17 |
1911629 | 1911629 | 2021-11-13 | Union | Indiana | 18161 | 1132 | 17 |
1908380 | 1908380 | 2021-11-12 | Union | Indiana | 18161 | 1132 | 17 |
1904096 | 1904096 | 2021-11-10 | Lunenburg | Virginia | 51111 | 1132 | 22 |
1875258 | 1875258 | 2021-11-02 | Montgomery | Arkansas | 5097 | 1132 | 45 |
1876112 | 1876112 | 2021-11-02 | Bracken | Kentucky | 21023 | 1132 | 10 |
1872009 | 1872009 | 2021-11-01 | Montgomery | Arkansas | 5097 | 1132 | 45 |
1868760 | 1868760 | 2021-10-31 | Montgomery | Arkansas | 5097 | 1132 | 45 |
1865511 | 1865511 | 2021-10-30 | Montgomery | Arkansas | 5097 | 1132 | 45 |
1862262 | 1862262 | 2021-10-29 | Montgomery | Arkansas | 5097 | 1132 | 45 |
1859283 | 1859283 | 2021-10-28 | Crawford | Georgia | 13079 | 1132 | 43 |
1854276 | 1854276 | 2021-10-26 | Camden | North Carolina | 37029 | 1132 | 8 |
1850617 | 1850617 | 2021-10-25 | Caldwell | Missouri | 29025 | 1132 | 20 |
1832989 | 1832989 | 2021-10-20 | Dallas | Arkansas | 5039 | 1132 | 19 |
1829740 | 1829740 | 2021-10-19 | Dallas | Arkansas | 5039 | 1132 | 19 |
1826448 | 1826448 | 2021-10-18 | Sitka City and Borough | Alaska | 2220 | 1132 | 4 |
1826491 | 1826491 | 2021-10-18 | Dallas | Arkansas | 5039 | 1132 | 19 |
1829416 | 1829416 | 2021-10-18 | Williamsburg city | Virginia | 51830 | 1132 | 14 |
1823199 | 1823199 | 2021-10-17 | Sitka City and Borough | Alaska | 2220 | 1132 | 4 |
1824204 | 1824204 | 2021-10-17 | Nicholas | Kentucky | 21181 | 1132 | 17 |
1819950 | 1819950 | 2021-10-16 | Sitka City and Borough | Alaska | 2220 | 1132 | 4 |
1820955 | 1820955 | 2021-10-16 | Nicholas | Kentucky | 21181 | 1132 | 17 |
1816701 | 1816701 | 2021-10-15 | Sitka City and Borough | Alaska | 2220 | 1132 | 4 |
1817706 | 1817706 | 2021-10-15 | Nicholas | Kentucky | 21181 | 1132 | 17 |
1816378 | 1816378 | 2021-10-14 | Northampton | Virginia | 51131 | 1132 | 40 |
1812156 | 1812156 | 2021-10-13 | Pembina | North Dakota | 38067 | 1132 | 11 |
1810068 | 1810068 | 2021-10-12 | Pepin | Wisconsin | 55091 | 1132 | 10 |
1788486 | 1788486 | 2021-10-06 | Trimble | Kentucky | 21223 | 1132 | 11 |
1788493 | 1788493 | 2021-10-06 | Wolfe | Kentucky | 21237 | 1132 | 8 |
1790288 | 1790288 | 2021-10-06 | Lamoille | Vermont | 50015 | 1132 | 5 |
1785154 | 1785154 | 2021-10-05 | Cumberland | Kentucky | 21057 | 1132 | 19 |
1705244 | 1705244 | 2021-09-10 | Barceloneta | Puerto Rico | 72017 | 1132 | |
1700968 | 1700968 | 2021-09-09 | Presque Isle | Michigan | 26141 | 1132 | 35 |
1702789 | 1702789 | 2021-09-09 | Pleasants | West Virginia | 54073 | 1132 | 13 |
1697719 | 1697719 | 2021-09-08 | Presque Isle | Michigan | 26141 | 1132 | 35 |
1690068 | 1690068 | 2021-09-06 | Nevada | Arkansas | 5099 | 1132 | 29 |
1670961 | 1670961 | 2021-08-31 | Wilcox | Georgia | 13315 | 1132 | 49 |
1671692 | 1671692 | 2021-08-31 | Iron | Michigan | 26071 | 1132 | 53 |
1668445 | 1668445 | 2021-08-30 | Iron | Michigan | 26071 | 1132 | 53 |
1621865 | 1621865 | 2021-08-16 | Scott | Arkansas | 5127 | 1132 | 18 |
1623116 | 1623116 | 2021-08-16 | Claiborne | Mississippi | 28021 | 1132 | 32 |
1624162 | 1624162 | 2021-08-16 | Butte | South Dakota | 46019 | 1132 | 22 |
1624283 | 1624283 | 2021-08-16 | Moore | Tennessee | 47127 | 1132 | 19 |
1607358 | 1607358 | 2021-08-11 | Alleghany | North Carolina | 37005 | 1132 | 5 |
1604109 | 1604109 | 2021-08-10 | Alleghany | North Carolina | 37005 | 1132 | 5 |
1604606 | 1604606 | 2021-08-10 | Utuado | Puerto Rico | 72141 | 1132 | |
1601549 | 1601549 | 2021-08-09 | Perry | Tennessee | 47135 | 1132 | 29 |
1590400 | 1590400 | 2021-08-06 | Lincoln | Maine | 23015 | 1132 | 3 |
1586617 | 1586617 | 2021-08-05 | Marshall | Illinois | 17123 | 1132 | 21 |
1587151 | 1587151 | 2021-08-05 | Lincoln | Maine | 23015 | 1132 | 3 |
1588500 | 1588500 | 2021-08-05 | Clay | Tennessee | 47027 | 1132 | 30 |
1576645 | 1576645 | 2021-08-02 | Dooly | Georgia | 13093 | 1132 | 44 |
1560217 | 1560217 | 2021-07-28 | Archuleta | Colorado | 8007 | 1132 | 2 |
1560517 | 1560517 | 2021-07-28 | Wilkes | Georgia | 13317 | 1132 | 32 |
1561455 | 1561455 | 2021-07-28 | Tunica | Mississippi | 28143 | 1132 | 27 |
1558207 | 1558207 | 2021-07-27 | Tunica | Mississippi | 28143 | 1132 | 27 |
1542459 | 1542459 | 2021-07-22 | Pamlico | North Carolina | 37137 | 1132 | 13 |
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);