ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
462 rows where cases = 1051 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 51
- Missouri 36
- Iowa 32
- Kentucky 20
- Mississippi 19
- Virginia 19
- Puerto Rico 18
- Florida 17
- Indiana 17
- South Dakota 16
- Georgia 14
- Illinois 13
- Minnesota 13
- Oklahoma 12
- Kansas 11
- Michigan 11
- Arkansas 10
- North Carolina 10
- Wisconsin 10
- Nebraska 9
- West Virginia 9
- Alaska 8
- Idaho 8
- North Dakota 8
- Oregon 8
- Washington 7
- Colorado 6
- Montana 6
- Pennsylvania 6
- Tennessee 6
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500939 | 2500939 | 2022-05-13 | Kittson | Minnesota | 27069 | 1051 | 27 |
2502613 | 2502613 | 2022-05-13 | Rappahannock | Virginia | 51157 | 1051 | 10 |
2499355 | 2499355 | 2022-05-12 | Rappahannock | Virginia | 51157 | 1051 | 10 |
2439104 | 2439104 | 2022-04-24 | Unknown | Minnesota | 1051 | 260 | |
2435848 | 2435848 | 2022-04-23 | Unknown | Minnesota | 1051 | 260 | |
2432592 | 2432592 | 2022-04-22 | Unknown | Minnesota | 1051 | 260 | |
2410720 | 2410720 | 2022-04-15 | Sullivan | Pennsylvania | 42113 | 1051 | 36 |
2333856 | 2333856 | 2022-03-23 | Washington | Colorado | 8121 | 1051 | 27 |
2289555 | 2289555 | 2022-03-09 | Holt | Missouri | 29087 | 1051 | 27 |
2290843 | 2290843 | 2022-03-09 | San Augustine | Texas | 48405 | 1051 | 42 |
2257248 | 2257248 | 2022-02-27 | Thayer | Nebraska | 31169 | 1051 | 8 |
2253997 | 2253997 | 2022-02-26 | Thayer | Nebraska | 31169 | 1051 | 8 |
2250746 | 2250746 | 2022-02-25 | Thayer | Nebraska | 31169 | 1051 | 8 |
2248388 | 2248388 | 2022-02-24 | Brewster | Texas | 48043 | 1051 | 26 |
2244865 | 2244865 | 2022-02-23 | Las Marias | Puerto Rico | 72083 | 1051 | |
2245211 | 2245211 | 2022-02-23 | Hall | Texas | 48191 | 1051 | 21 |
2241412 | 2241412 | 2022-02-22 | Dewey | Oklahoma | 40043 | 1051 | 28 |
2241614 | 2241614 | 2022-02-22 | Las Marias | Puerto Rico | 72083 | 1051 | |
2238161 | 2238161 | 2022-02-21 | Dewey | Oklahoma | 40043 | 1051 | 28 |
2238363 | 2238363 | 2022-02-21 | Las Marias | Puerto Rico | 72083 | 1051 | |
2234910 | 2234910 | 2022-02-20 | Dewey | Oklahoma | 40043 | 1051 | 28 |
2231659 | 2231659 | 2022-02-19 | Dewey | Oklahoma | 40043 | 1051 | 28 |
2228408 | 2228408 | 2022-02-18 | Dewey | Oklahoma | 40043 | 1051 | 28 |
2229111 | 2229111 | 2022-02-18 | Yoakum | Texas | 48501 | 1051 | 39 |
2224628 | 2224628 | 2022-02-17 | Mineral | Montana | 30061 | 1051 | 17 |
2224810 | 2224810 | 2022-02-17 | Hidalgo | New Mexico | 35023 | 1051 | 13 |
2225157 | 2225157 | 2022-02-17 | Dewey | Oklahoma | 40043 | 1051 | 28 |
2225860 | 2225860 | 2022-02-17 | Yoakum | Texas | 48501 | 1051 | 39 |
2221377 | 2221377 | 2022-02-16 | Mineral | Montana | 30061 | 1051 | 17 |
2221906 | 2221906 | 2022-02-16 | Dewey | Oklahoma | 40043 | 1051 | 28 |
2222609 | 2222609 | 2022-02-16 | Yoakum | Texas | 48501 | 1051 | 39 |
2217021 | 2217021 | 2022-02-15 | Warren | Georgia | 13301 | 1051 | 28 |
2219358 | 2219358 | 2022-02-15 | Yoakum | Texas | 48501 | 1051 | 39 |
2213770 | 2213770 | 2022-02-14 | Warren | Georgia | 13301 | 1051 | 28 |
2216107 | 2216107 | 2022-02-14 | Yoakum | Texas | 48501 | 1051 | 39 |
2212856 | 2212856 | 2022-02-13 | Yoakum | Texas | 48501 | 1051 | 39 |
2209603 | 2209603 | 2022-02-12 | Yoakum | Texas | 48501 | 1051 | 39 |
2206350 | 2206350 | 2022-02-11 | Yoakum | Texas | 48501 | 1051 | 39 |
2195414 | 2195414 | 2022-02-08 | Furnas | Nebraska | 31065 | 1051 | 6 |
2196762 | 2196762 | 2022-02-08 | Surry | Virginia | 51181 | 1051 | 17 |
2143390 | 2143390 | 2022-01-23 | Morrill | Nebraska | 31123 | 1051 | 17 |
2144441 | 2144441 | 2022-01-23 | Martin | Texas | 48317 | 1051 | 24 |
2140135 | 2140135 | 2022-01-22 | Morrill | Nebraska | 31123 | 1051 | 17 |
2136879 | 2136879 | 2022-01-21 | Morrill | Nebraska | 31123 | 1051 | 17 |
2125228 | 2125228 | 2022-01-17 | Skamania | Washington | 53059 | 1051 | 10 |
2121976 | 2121976 | 2022-01-16 | Skamania | Washington | 53059 | 1051 | 10 |
2118724 | 2118724 | 2022-01-15 | Skamania | Washington | 53059 | 1051 | 10 |
2115472 | 2115472 | 2022-01-14 | Skamania | Washington | 53059 | 1051 | 10 |
2091147 | 2091147 | 2022-01-07 | Dade | Missouri | 29057 | 1051 | 38 |
2083807 | 2083807 | 2022-01-05 | Stark | Illinois | 17175 | 1051 | 30 |
2076543 | 2076543 | 2022-01-02 | Iron | Wisconsin | 55051 | 1051 | 44 |
2073292 | 2073292 | 2022-01-01 | Iron | Wisconsin | 55051 | 1051 | 44 |
2070041 | 2070041 | 2021-12-31 | Iron | Wisconsin | 55051 | 1051 | 44 |
2066790 | 2066790 | 2021-12-30 | Iron | Wisconsin | 55051 | 1051 | 44 |
2060870 | 2060870 | 2021-12-29 | Randolph | Georgia | 13243 | 1051 | 44 |
2046142 | 2046142 | 2021-12-24 | McHenry | North Dakota | 38049 | 1051 | 28 |
2030607 | 2030607 | 2021-12-19 | Jack | Texas | 48237 | 1051 | 22 |
2027356 | 2027356 | 2021-12-18 | Jack | Texas | 48237 | 1051 | 22 |
1963423 | 1963423 | 2021-11-29 | Caribou | Idaho | 16029 | 1051 | 22 |
1926334 | 1926334 | 2021-11-17 | Hamlin | South Dakota | 46057 | 1051 | 40 |
1926845 | 1926845 | 2021-11-17 | Madison | Virginia | 51113 | 1051 | 23 |
1922114 | 1922114 | 2021-11-16 | Clark | Missouri | 29045 | 1051 | 12 |
1891971 | 1891971 | 2021-11-07 | Edwards | Illinois | 17047 | 1051 | 20 |
1893683 | 1893683 | 2021-11-07 | Aibonito | Puerto Rico | 72009 | 1051 | |
1888721 | 1888721 | 2021-11-06 | Edwards | Illinois | 17047 | 1051 | 20 |
1890433 | 1890433 | 2021-11-06 | Aibonito | Puerto Rico | 72009 | 1051 | |
1885471 | 1885471 | 2021-11-05 | Edwards | Illinois | 17047 | 1051 | 20 |
1879866 | 1879866 | 2021-11-03 | Chariton | Missouri | 29041 | 1051 | 8 |
1870095 | 1870095 | 2021-10-31 | Wilkinson | Mississippi | 28157 | 1051 | 39 |
1866846 | 1866846 | 2021-10-30 | Wilkinson | Mississippi | 28157 | 1051 | 39 |
1863597 | 1863597 | 2021-10-29 | Wilkinson | Mississippi | 28157 | 1051 | 39 |
1859450 | 1859450 | 2021-10-28 | Power | Idaho | 16077 | 1051 | 14 |
1860348 | 1860348 | 2021-10-28 | Wilkinson | Mississippi | 28157 | 1051 | 39 |
1857099 | 1857099 | 2021-10-27 | Wilkinson | Mississippi | 28157 | 1051 | 39 |
1853850 | 1853850 | 2021-10-26 | Wilkinson | Mississippi | 28157 | 1051 | 39 |
1854198 | 1854198 | 2021-10-26 | Sierra | New Mexico | 35051 | 1051 | 56 |
1850601 | 1850601 | 2021-10-25 | Wilkinson | Mississippi | 28157 | 1051 | 39 |
1847351 | 1847351 | 2021-10-24 | Wilkinson | Mississippi | 28157 | 1051 | 39 |
1844101 | 1844101 | 2021-10-23 | Wilkinson | Mississippi | 28157 | 1051 | 39 |
1840851 | 1840851 | 2021-10-22 | Wilkinson | Mississippi | 28157 | 1051 | 39 |
1837602 | 1837602 | 2021-10-21 | Wilkinson | Mississippi | 28157 | 1051 | 39 |
1839046 | 1839046 | 2021-10-21 | Bland | Virginia | 51021 | 1051 | 15 |
1826111 | 1826111 | 2021-10-17 | Lunenburg | Virginia | 51111 | 1051 | 19 |
1826257 | 1826257 | 2021-10-17 | Tucker | West Virginia | 54093 | 1051 | 20 |
1822862 | 1822862 | 2021-10-16 | Lunenburg | Virginia | 51111 | 1051 | 19 |
1823008 | 1823008 | 2021-10-16 | Tucker | West Virginia | 54093 | 1051 | 20 |
1819613 | 1819613 | 2021-10-15 | Lunenburg | Virginia | 51111 | 1051 | 19 |
1807731 | 1807731 | 2021-10-12 | Monona | Iowa | 19133 | 1051 | 35 |
1804480 | 1804480 | 2021-10-11 | Monona | Iowa | 19133 | 1051 | 35 |
1801231 | 1801231 | 2021-10-10 | Monona | Iowa | 19133 | 1051 | 35 |
1797982 | 1797982 | 2021-10-09 | Monona | Iowa | 19133 | 1051 | 35 |
1794733 | 1794733 | 2021-10-08 | Monona | Iowa | 19133 | 1051 | 35 |
1791228 | 1791228 | 2021-10-07 | Brown | Illinois | 17009 | 1051 | 15 |
1791485 | 1791485 | 2021-10-07 | Monona | Iowa | 19133 | 1051 | 35 |
1787979 | 1787979 | 2021-10-06 | Brown | Illinois | 17009 | 1051 | 15 |
1788236 | 1788236 | 2021-10-06 | Monona | Iowa | 19133 | 1051 | 35 |
1788887 | 1788887 | 2021-10-06 | Carter | Missouri | 29035 | 1051 | 14 |
1790018 | 1790018 | 2021-10-06 | Brewster | Texas | 48043 | 1051 | 19 |
1787258 | 1787258 | 2021-10-05 | Pendleton | West Virginia | 54071 | 1051 | 12 |
1781967 | 1781967 | 2021-10-04 | Nicholas | Kentucky | 21181 | 1051 | 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);