ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
393 rows where cases = 1014 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 30
- Georgia 26
- Mississippi 21
- Missouri 20
- Puerto Rico 20
- Colorado 19
- Kentucky 17
- North Carolina 17
- Virginia 17
- Minnesota 16
- Nebraska 15
- Iowa 14
- Montana 11
- North Dakota 11
- West Virginia 11
- Indiana 10
- Tennessee 9
- Illinois 8
- Kansas 8
- Arkansas 7
- Michigan 7
- South Dakota 7
- California 6
- Oregon 6
- Florida 5
- Idaho 5
- New York 5
- Ohio 5
- Alabama 4
- Alaska 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2452783 | 2452783 | 2022-04-28 | Wells | North Dakota | 38103 | 1014 | 12 |
2449527 | 2449527 | 2022-04-27 | Wells | North Dakota | 38103 | 1014 | 12 |
2446270 | 2446270 | 2022-04-26 | Wells | North Dakota | 38103 | 1014 | 12 |
2443015 | 2443015 | 2022-04-25 | Wells | North Dakota | 38103 | 1014 | 12 |
2439759 | 2439759 | 2022-04-24 | Wells | North Dakota | 38103 | 1014 | 12 |
2436503 | 2436503 | 2022-04-23 | Wells | North Dakota | 38103 | 1014 | 12 |
2433247 | 2433247 | 2022-04-22 | Wells | North Dakota | 38103 | 1014 | 12 |
2217843 | 2217843 | 2022-02-15 | Kittson | Minnesota | 27069 | 1014 | 26 |
2218499 | 2218499 | 2022-02-15 | Dunn | North Dakota | 38025 | 1014 | 8 |
2193137 | 2193137 | 2022-02-07 | Crockett | Texas | 48105 | 1014 | 17 |
2193416 | 2193416 | 2022-02-07 | Craig | Virginia | 51045 | 1014 | 12 |
2188849 | 2188849 | 2022-02-06 | Mineral | Montana | 30061 | 1014 | 15 |
2185596 | 2185596 | 2022-02-05 | Mineral | Montana | 30061 | 1014 | 15 |
2182344 | 2182344 | 2022-02-04 | Mineral | Montana | 30061 | 1014 | 15 |
2161479 | 2161479 | 2022-01-29 | Saguache | Colorado | 8109 | 1014 | 10 |
2154970 | 2154970 | 2022-01-27 | Saguache | Colorado | 8109 | 1014 | 10 |
2153907 | 2153907 | 2022-01-26 | Gregory | South Dakota | 46053 | 1014 | 33 |
2149754 | 2149754 | 2022-01-25 | Reynolds | Missouri | 29179 | 1014 | 18 |
2132532 | 2132532 | 2022-01-20 | Henderson | Illinois | 17071 | 1014 | 24 |
2097865 | 2097865 | 2022-01-09 | Pierce | Nebraska | 31139 | 1014 | 21 |
2094613 | 2094613 | 2022-01-08 | Pierce | Nebraska | 31139 | 1014 | 21 |
2091361 | 2091361 | 2022-01-07 | Pierce | Nebraska | 31139 | 1014 | 21 |
2085945 | 2085945 | 2022-01-05 | Sabine | Texas | 48403 | 1014 | 78 |
2074338 | 2074338 | 2022-01-02 | Republic | Kansas | 20157 | 1014 | 14 |
2074696 | 2074696 | 2022-01-02 | Big Stone | Minnesota | 27011 | 1014 | 7 |
2074981 | 2074981 | 2022-01-02 | Broadwater | Montana | 30007 | 1014 | 17 |
2076369 | 2076369 | 2022-01-02 | Mathews | Virginia | 51115 | 1014 | 24 |
2076515 | 2076515 | 2022-01-02 | Wirt | West Virginia | 54105 | 1014 | 18 |
2071087 | 2071087 | 2022-01-01 | Republic | Kansas | 20157 | 1014 | 14 |
2071445 | 2071445 | 2022-01-01 | Big Stone | Minnesota | 27011 | 1014 | 7 |
2071730 | 2071730 | 2022-01-01 | Broadwater | Montana | 30007 | 1014 | 17 |
2073118 | 2073118 | 2022-01-01 | Mathews | Virginia | 51115 | 1014 | 24 |
2073264 | 2073264 | 2022-01-01 | Wirt | West Virginia | 54105 | 1014 | 18 |
2067836 | 2067836 | 2021-12-31 | Republic | Kansas | 20157 | 1014 | 14 |
2068194 | 2068194 | 2021-12-31 | Big Stone | Minnesota | 27011 | 1014 | 7 |
2068479 | 2068479 | 2021-12-31 | Broadwater | Montana | 30007 | 1014 | 17 |
2069867 | 2069867 | 2021-12-31 | Mathews | Virginia | 51115 | 1014 | 24 |
2070013 | 2070013 | 2021-12-31 | Wirt | West Virginia | 54105 | 1014 | 18 |
2064585 | 2064585 | 2021-12-30 | Republic | Kansas | 20157 | 1014 | 14 |
2064943 | 2064943 | 2021-12-30 | Big Stone | Minnesota | 27011 | 1014 | 7 |
2065228 | 2065228 | 2021-12-30 | Broadwater | Montana | 30007 | 1014 | 17 |
2066762 | 2066762 | 2021-12-30 | Wirt | West Virginia | 54105 | 1014 | 18 |
2061335 | 2061335 | 2021-12-29 | Republic | Kansas | 20157 | 1014 | 14 |
2037255 | 2037255 | 2021-12-21 | Kane | Utah | 49025 | 1014 | 12 |
2034005 | 2034005 | 2021-12-20 | Kane | Utah | 49025 | 1014 | 12 |
1974632 | 1974632 | 2021-12-02 | McHenry | North Dakota | 38049 | 1014 | 27 |
1937355 | 1937355 | 2021-11-21 | Randolph | Georgia | 13243 | 1014 | 43 |
1934105 | 1934105 | 2021-11-20 | Randolph | Georgia | 13243 | 1014 | 43 |
1930853 | 1930853 | 2021-11-19 | Randolph | Georgia | 13243 | 1014 | 43 |
1921964 | 1921964 | 2021-11-16 | Mahnomen | Minnesota | 27087 | 1014 | 13 |
1909155 | 1909155 | 2021-11-12 | Maries | Missouri | 29125 | 1014 | 19 |
1897275 | 1897275 | 2021-11-08 | Crosby | Texas | 48107 | 1014 | 37 |
1891623 | 1891623 | 2021-11-07 | Kit Carson | Colorado | 8063 | 1014 | 20 |
1894025 | 1894025 | 2021-11-07 | Crosby | Texas | 48107 | 1014 | 37 |
1888373 | 1888373 | 2021-11-06 | Kit Carson | Colorado | 8063 | 1014 | 20 |
1890775 | 1890775 | 2021-11-06 | Crosby | Texas | 48107 | 1014 | 37 |
1885123 | 1885123 | 2021-11-05 | Kit Carson | Colorado | 8063 | 1014 | 20 |
1884082 | 1884082 | 2021-11-04 | Fall River | South Dakota | 46047 | 1014 | 23 |
1874090 | 1874090 | 2021-11-01 | Grant | Oregon | 41023 | 1014 | 13 |
1835349 | 1835349 | 2021-10-20 | Hamlin | South Dakota | 46057 | 1014 | 40 |
1818142 | 1818142 | 2021-10-15 | Daviess | Missouri | 29061 | 1014 | 14 |
1803718 | 1803718 | 2021-10-11 | Greenlee | Arizona | 4011 | 1014 | 16 |
1796278 | 1796278 | 2021-10-08 | Villalba | Puerto Rico | 72149 | 1014 | |
1793029 | 1793029 | 2021-10-07 | Villalba | Puerto Rico | 72149 | 1014 | |
1789780 | 1789780 | 2021-10-06 | Villalba | Puerto Rico | 72149 | 1014 | |
1786460 | 1786460 | 2021-10-05 | Aibonito | Puerto Rico | 72009 | 1014 | |
1786532 | 1786532 | 2021-10-05 | Villalba | Puerto Rico | 72149 | 1014 | |
1783211 | 1783211 | 2021-10-04 | Aibonito | Puerto Rico | 72009 | 1014 | |
1783283 | 1783283 | 2021-10-04 | Villalba | Puerto Rico | 72149 | 1014 | |
1780034 | 1780034 | 2021-10-03 | Villalba | Puerto Rico | 72149 | 1014 | |
1776784 | 1776784 | 2021-10-02 | Villalba | Puerto Rico | 72149 | 1014 | |
1773534 | 1773534 | 2021-10-01 | Villalba | Puerto Rico | 72149 | 1014 | |
1770284 | 1770284 | 2021-09-30 | Villalba | Puerto Rico | 72149 | 1014 | |
1767035 | 1767035 | 2021-09-29 | Villalba | Puerto Rico | 72149 | 1014 | |
1767122 | 1767122 | 2021-09-29 | Hutchinson | South Dakota | 46067 | 1014 | 28 |
1764372 | 1764372 | 2021-09-28 | Lancaster | Virginia | 51103 | 1014 | 20 |
1760049 | 1760049 | 2021-09-27 | Camden | North Carolina | 37029 | 1014 | 8 |
1755667 | 1755667 | 2021-09-26 | Union | Indiana | 18161 | 1014 | 12 |
1752419 | 1752419 | 2021-09-25 | Union | Indiana | 18161 | 1014 | 12 |
1749170 | 1749170 | 2021-09-24 | Union | Indiana | 18161 | 1014 | 12 |
1740131 | 1740131 | 2021-09-21 | Wilkinson | Mississippi | 28157 | 1014 | 36 |
1735994 | 1735994 | 2021-09-20 | Brown | Illinois | 17009 | 1014 | 14 |
1735055 | 1735055 | 2021-09-19 | Orange | Vermont | 50017 | 1014 | 4 |
1723864 | 1723864 | 2021-09-16 | Quitman | Mississippi | 28119 | 1014 | 25 |
1698183 | 1698183 | 2021-09-08 | Pershing | Nevada | 32027 | 1014 | 21 |
1694935 | 1694935 | 2021-09-07 | Pershing | Nevada | 32027 | 1014 | 21 |
1689300 | 1689300 | 2021-09-05 | Blanco | Texas | 48031 | 1014 | 23 |
1686050 | 1686050 | 2021-09-04 | Blanco | Texas | 48031 | 1014 | 23 |
1676610 | 1676610 | 2021-09-01 | Charlotte | Virginia | 51037 | 1014 | 22 |
1667385 | 1667385 | 2021-08-30 | Plumas | California | 6063 | 1014 | 6 |
1667459 | 1667459 | 2021-08-30 | Park | Colorado | 8093 | 1014 | 6 |
1654636 | 1654636 | 2021-08-26 | Hancock | Georgia | 13141 | 1014 | 71 |
1656131 | 1656131 | 2021-08-26 | Jones | North Carolina | 37103 | 1014 | 29 |
1639441 | 1639441 | 2021-08-21 | Caldwell | Missouri | 29025 | 1014 | 18 |
1632032 | 1632032 | 2021-08-19 | Valley | Idaho | 16085 | 1014 | 6 |
1628819 | 1628819 | 2021-08-18 | Hamilton | Illinois | 17065 | 1014 | 19 |
1629256 | 1629256 | 2021-08-18 | Livingston | Kentucky | 21139 | 1014 | 26 |
1630580 | 1630580 | 2021-08-18 | San German | Puerto Rico | 72125 | 1014 | |
1625985 | 1625985 | 2021-08-17 | Hancock | Kentucky | 21091 | 1014 | 16 |
1627333 | 1627333 | 2021-08-17 | San German | Puerto Rico | 72125 | 1014 |
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);