ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
427 rows where cases = 1029 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 37
- Mississippi 28
- Georgia 24
- Missouri 22
- North Dakota 20
- Virginia 20
- Idaho 18
- South Dakota 16
- Kansas 14
- Puerto Rico 14
- Colorado 13
- Kentucky 13
- Nebraska 13
- Alabama 11
- Iowa 11
- Louisiana 11
- North Carolina 11
- Arkansas 10
- Ohio 10
- Minnesota 9
- Illinois 8
- Indiana 8
- Michigan 8
- Montana 8
- Oklahoma 6
- Florida 5
- Utah 5
- Vermont 5
- West Virginia 5
- Wisconsin 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2362257 | 2362257 | 2022-03-31 | Crockett | Texas | 48105 | 1029 | 19 |
2359003 | 2359003 | 2022-03-30 | Crockett | Texas | 48105 | 1029 | 19 |
2303068 | 2303068 | 2022-03-13 | Sargent | North Dakota | 38081 | 1029 | 9 |
2299816 | 2299816 | 2022-03-12 | Sargent | North Dakota | 38081 | 1029 | 9 |
2293312 | 2293312 | 2022-03-10 | Sargent | North Dakota | 38081 | 1029 | 9 |
2290032 | 2290032 | 2022-03-09 | Dunn | North Dakota | 38025 | 1029 | 8 |
2290060 | 2290060 | 2022-03-09 | Sargent | North Dakota | 38081 | 1029 | 9 |
2267265 | 2267265 | 2022-03-02 | Dunn | North Dakota | 38025 | 1029 | 8 |
2267293 | 2267293 | 2022-03-02 | Sargent | North Dakota | 38081 | 1029 | 9 |
2262560 | 2262560 | 2022-03-01 | Boise | Idaho | 16015 | 1029 | 13 |
2264013 | 2264013 | 2022-03-01 | Dunn | North Dakota | 38025 | 1029 | 8 |
2264041 | 2264041 | 2022-03-01 | Sargent | North Dakota | 38081 | 1029 | 9 |
2259309 | 2259309 | 2022-02-28 | Boise | Idaho | 16015 | 1029 | 13 |
2260762 | 2260762 | 2022-02-28 | Dunn | North Dakota | 38025 | 1029 | 8 |
2256058 | 2256058 | 2022-02-27 | Boise | Idaho | 16015 | 1029 | 13 |
2252807 | 2252807 | 2022-02-26 | Boise | Idaho | 16015 | 1029 | 13 |
2249556 | 2249556 | 2022-02-25 | Boise | Idaho | 16015 | 1029 | 13 |
2246305 | 2246305 | 2022-02-24 | Boise | Idaho | 16015 | 1029 | 13 |
2241960 | 2241960 | 2022-02-22 | Hall | Texas | 48191 | 1029 | 21 |
2238470 | 2238470 | 2022-02-21 | Deuel | South Dakota | 46039 | 1029 | 12 |
2238709 | 2238709 | 2022-02-21 | Hall | Texas | 48191 | 1029 | 21 |
2235219 | 2235219 | 2022-02-20 | Deuel | South Dakota | 46039 | 1029 | 12 |
2235458 | 2235458 | 2022-02-20 | Hall | Texas | 48191 | 1029 | 21 |
2231968 | 2231968 | 2022-02-19 | Deuel | South Dakota | 46039 | 1029 | 12 |
2232207 | 2232207 | 2022-02-19 | Hall | Texas | 48191 | 1029 | 21 |
2228717 | 2228717 | 2022-02-18 | Deuel | South Dakota | 46039 | 1029 | 12 |
2225812 | 2225812 | 2022-02-17 | San Augustine | Texas | 48405 | 1029 | 40 |
2211650 | 2211650 | 2022-02-13 | Antelope | Nebraska | 31003 | 1029 | 12 |
2212627 | 2212627 | 2022-02-13 | Brewster | Texas | 48043 | 1029 | 25 |
2208397 | 2208397 | 2022-02-12 | Antelope | Nebraska | 31003 | 1029 | 12 |
2209049 | 2209049 | 2022-02-12 | Sullivan | Pennsylvania | 42113 | 1029 | 33 |
2209374 | 2209374 | 2022-02-12 | Brewster | Texas | 48043 | 1029 | 25 |
2205144 | 2205144 | 2022-02-11 | Antelope | Nebraska | 31003 | 1029 | 12 |
2198792 | 2198792 | 2022-02-09 | Hidalgo | New Mexico | 35023 | 1029 | 13 |
2194251 | 2194251 | 2022-02-08 | Warren | Georgia | 13301 | 1029 | 28 |
2180621 | 2180621 | 2022-02-03 | Florence | Wisconsin | 55037 | 1029 | 15 |
2153006 | 2153006 | 2022-01-26 | Reynolds | Missouri | 29179 | 1029 | 18 |
2151081 | 2151081 | 2022-01-25 | Essex | Vermont | 50009 | 1029 | 3 |
2133637 | 2133637 | 2022-01-20 | Polk | Nebraska | 31143 | 1029 | 18 |
2096197 | 2096197 | 2022-01-09 | Dillingham Census Area | Alaska | 2070 | 1029 | 10 |
2097743 | 2097743 | 2022-01-09 | Broadwater | Montana | 30007 | 1029 | 17 |
2098952 | 2098952 | 2022-01-09 | Sabine | Texas | 48403 | 1029 | 79 |
2092945 | 2092945 | 2022-01-08 | Dillingham Census Area | Alaska | 2070 | 1029 | 10 |
2094491 | 2094491 | 2022-01-08 | Broadwater | Montana | 30007 | 1029 | 17 |
2089693 | 2089693 | 2022-01-07 | Dillingham Census Area | Alaska | 2070 | 1029 | 10 |
2091239 | 2091239 | 2022-01-07 | Broadwater | Montana | 30007 | 1029 | 17 |
2087313 | 2087313 | 2022-01-06 | Kearny | Kansas | 20093 | 1029 | 17 |
2084061 | 2084061 | 2022-01-05 | Kearny | Kansas | 20093 | 1029 | 17 |
2080453 | 2080453 | 2022-01-04 | Lemhi | Idaho | 16059 | 1029 | 23 |
2066502 | 2066502 | 2021-12-30 | Kane | Utah | 49025 | 1029 | 12 |
2063252 | 2063252 | 2021-12-29 | Kane | Utah | 49025 | 1029 | 12 |
2036833 | 2036833 | 2021-12-21 | Brule | South Dakota | 46015 | 1029 | 15 |
2011847 | 2011847 | 2021-12-14 | Trinity | California | 6105 | 1029 | 17 |
2008596 | 2008596 | 2021-12-13 | Trinity | California | 6105 | 1029 | 17 |
1997385 | 1997385 | 2021-12-09 | McHenry | North Dakota | 38049 | 1029 | 28 |
1989362 | 1989362 | 2021-12-07 | Randolph | Georgia | 13243 | 1029 | 43 |
1970949 | 1970949 | 2021-12-01 | Shelby | Missouri | 29205 | 1029 | 13 |
1951228 | 1951228 | 2021-11-25 | Norman | Minnesota | 27107 | 1029 | 9 |
1947977 | 1947977 | 2021-11-24 | Norman | Minnesota | 27107 | 1029 | 9 |
1941778 | 1941778 | 2021-11-22 | Cedar | Nebraska | 31027 | 1029 | 11 |
1936003 | 1936003 | 2021-11-20 | Villalba | Puerto Rico | 72149 | 1029 | |
1932753 | 1932753 | 2021-11-19 | Villalba | Puerto Rico | 72149 | 1029 | |
1929502 | 1929502 | 2021-11-18 | Villalba | Puerto Rico | 72149 | 1029 | |
1925564 | 1925564 | 2021-11-17 | Keith | Nebraska | 31101 | 1029 | 11 |
1915405 | 1915405 | 2021-11-14 | Oscoda | Michigan | 26135 | 1029 | 40 |
1912155 | 1912155 | 2021-11-13 | Oscoda | Michigan | 26135 | 1029 | 40 |
1908905 | 1908905 | 2021-11-12 | Oscoda | Michigan | 26135 | 1029 | 40 |
1872106 | 1872106 | 2021-11-01 | Conejos | Colorado | 8021 | 1029 | 35 |
1858095 | 1858095 | 2021-10-27 | Hamlin | South Dakota | 46057 | 1029 | 40 |
1852635 | 1852635 | 2021-10-26 | Lake | Colorado | 8065 | 1029 | 1 |
1846453 | 1846453 | 2021-10-24 | Power | Idaho | 16077 | 1029 | 14 |
1847385 | 1847385 | 2021-10-24 | Daviess | Missouri | 29061 | 1029 | 14 |
1843203 | 1843203 | 2021-10-23 | Power | Idaho | 16077 | 1029 | 14 |
1839953 | 1839953 | 2021-10-22 | Power | Idaho | 16077 | 1029 | 14 |
1834377 | 1834377 | 2021-10-20 | Chariton | Missouri | 29041 | 1029 | 8 |
1834616 | 1834616 | 2021-10-20 | Thurston | Nebraska | 31173 | 1029 | 13 |
1835195 | 1835195 | 2021-10-20 | Aibonito | Puerto Rico | 72009 | 1029 | |
1831341 | 1831341 | 2021-10-19 | Merrick | Nebraska | 31121 | 1029 | 15 |
1828203 | 1828203 | 2021-10-18 | Sierra | New Mexico | 35051 | 1029 | 55 |
1816715 | 1816715 | 2021-10-15 | Greenlee | Arizona | 4011 | 1029 | 16 |
1812612 | 1812612 | 2021-10-13 | Hutchinson | South Dakota | 46067 | 1029 | 28 |
1809363 | 1809363 | 2021-10-12 | Hutchinson | South Dakota | 46067 | 1029 | 28 |
1805111 | 1805111 | 2021-10-11 | Wilkinson | Mississippi | 28157 | 1029 | 38 |
1806113 | 1806113 | 2021-10-11 | Hutchinson | South Dakota | 46067 | 1029 | 28 |
1802863 | 1802863 | 2021-10-10 | Hutchinson | South Dakota | 46067 | 1029 | 28 |
1799614 | 1799614 | 2021-10-09 | Hutchinson | South Dakota | 46067 | 1029 | 28 |
1796365 | 1796365 | 2021-10-08 | Hutchinson | South Dakota | 46067 | 1029 | 28 |
1793770 | 1793770 | 2021-10-07 | Webster | West Virginia | 54101 | 1029 | 14 |
1773772 | 1773772 | 2021-10-01 | Brewster | Texas | 48043 | 1029 | 19 |
1770522 | 1770522 | 2021-09-30 | Brewster | Texas | 48043 | 1029 | 19 |
1767273 | 1767273 | 2021-09-29 | Brewster | Texas | 48043 | 1029 | 19 |
1761263 | 1761263 | 2021-09-27 | Pendleton | West Virginia | 54071 | 1029 | 12 |
1748053 | 1748053 | 2021-09-23 | Orange | Vermont | 50017 | 1029 | 4 |
1740676 | 1740676 | 2021-09-21 | Pembina | North Dakota | 38067 | 1029 | 11 |
1723760 | 1723760 | 2021-09-16 | Marshall | Minnesota | 27089 | 1029 | 18 |
1725168 | 1725168 | 2021-09-16 | Marion | Texas | 48315 | 1029 | 40 |
1714259 | 1714259 | 2021-09-13 | Beaverhead | Montana | 30001 | 1029 | 13 |
1705820 | 1705820 | 2021-09-10 | Lamoille | Vermont | 50015 | 1029 | 3 |
1702598 | 1702598 | 2021-09-09 | Buena Vista city | Virginia | 51530 | 1029 | 22 |
1694695 | 1694695 | 2021-09-07 | Harrison | Missouri | 29081 | 1029 | 15 |
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);