ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
449 rows where cases = 887 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Virginia 40
- Georgia 32
- Texas 30
- Kentucky 25
- Arkansas 24
- Kansas 18
- South Dakota 18
- Iowa 17
- Indiana 16
- Minnesota 16
- Mississippi 15
- Nebraska 15
- Alabama 14
- Wisconsin 13
- South Carolina 11
- Colorado 10
- Ohio 9
- Missouri 8
- Puerto Rico 8
- Wyoming 8
- Illinois 7
- North Carolina 7
- Vermont 7
- Florida 6
- Idaho 6
- Louisiana 5
- Maine 5
- Michigan 5
- North Dakota 5
- Tennessee 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2427343 | 2427343 | 2022-04-20 | Cochran | Texas | 48079 | 887 | 23 |
2424087 | 2424087 | 2022-04-19 | Cochran | Texas | 48079 | 887 | 23 |
2418453 | 2418453 | 2022-04-18 | Phillips | Colorado | 8095 | 887 | 18 |
2326731 | 2326731 | 2022-03-20 | Bath | Virginia | 51017 | 887 | 20 |
2323478 | 2323478 | 2022-03-19 | Bath | Virginia | 51017 | 887 | 20 |
2320224 | 2320224 | 2022-03-18 | Bath | Virginia | 51017 | 887 | 20 |
2316970 | 2316970 | 2022-03-17 | Bath | Virginia | 51017 | 887 | 20 |
2313717 | 2313717 | 2022-03-16 | Bath | Virginia | 51017 | 887 | 20 |
2310464 | 2310464 | 2022-03-15 | Bath | Virginia | 51017 | 887 | 19 |
2307211 | 2307211 | 2022-03-14 | Bath | Virginia | 51017 | 887 | 19 |
2216598 | 2216598 | 2022-02-15 | Calhoun | Arkansas | 5013 | 887 | 9 |
2177228 | 2177228 | 2022-02-02 | Rappahannock | Virginia | 51157 | 887 | 8 |
2171263 | 2171263 | 2022-02-01 | Unknown | Delaware | 887 | 0 | |
2170176 | 2170176 | 2022-01-31 | Edmunds | South Dakota | 46045 | 887 | 16 |
2137194 | 2137194 | 2022-01-21 | Sargent | North Dakota | 38081 | 887 | 9 |
2124815 | 2124815 | 2022-01-17 | Crockett | Texas | 48105 | 887 | 17 |
2107896 | 2107896 | 2022-01-12 | Dunn | North Dakota | 38025 | 887 | 8 |
2103503 | 2103503 | 2022-01-11 | Ringgold | Iowa | 19159 | 887 | 31 |
2100252 | 2100252 | 2022-01-10 | Ringgold | Iowa | 19159 | 887 | 31 |
2097001 | 2097001 | 2022-01-09 | Ringgold | Iowa | 19159 | 887 | 31 |
2098803 | 2098803 | 2022-01-09 | Crockett | Texas | 48105 | 887 | 17 |
2093749 | 2093749 | 2022-01-08 | Ringgold | Iowa | 19159 | 887 | 31 |
2090497 | 2090497 | 2022-01-07 | Ringgold | Iowa | 19159 | 887 | 31 |
2087246 | 2087246 | 2022-01-06 | Ringgold | Iowa | 19159 | 887 | 31 |
2088858 | 2088858 | 2022-01-06 | Gregory | South Dakota | 46053 | 887 | 33 |
2083994 | 2083994 | 2022-01-05 | Ringgold | Iowa | 19159 | 887 | 31 |
2080905 | 2080905 | 2022-01-04 | Fulton | Kentucky | 21075 | 887 | 23 |
2081516 | 2081516 | 2022-01-04 | Phillips | Montana | 30071 | 887 | 27 |
2076326 | 2076326 | 2022-01-02 | Emporia city | Virginia | 51595 | 887 | 46 |
2073075 | 2073075 | 2022-01-01 | Emporia city | Virginia | 51595 | 887 | 46 |
2069824 | 2069824 | 2021-12-31 | Emporia city | Virginia | 51595 | 887 | 46 |
2065973 | 2065973 | 2021-12-30 | Guayanilla | Puerto Rico | 72059 | 887 | |
2057258 | 2057258 | 2021-12-28 | Lafayette | Arkansas | 5073 | 887 | 28 |
2035331 | 2035331 | 2021-12-21 | Ottawa | Kansas | 20143 | 887 | 15 |
2032081 | 2032081 | 2021-12-20 | Ottawa | Kansas | 20143 | 887 | 15 |
2017259 | 2017259 | 2021-12-15 | Santa Isabel | Puerto Rico | 72133 | 887 | |
2017640 | 2017640 | 2021-12-15 | Martin | Texas | 48317 | 887 | 24 |
2012216 | 2012216 | 2021-12-14 | Calhoun | Illinois | 17013 | 887 | 5 |
2010839 | 2010839 | 2021-12-13 | Day | South Dakota | 46037 | 887 | 30 |
1975115 | 1975115 | 2021-12-02 | Moody | South Dakota | 46101 | 887 | 23 |
1923117 | 1923117 | 2021-11-16 | Tripp | South Dakota | 46123 | 887 | 20 |
1923828 | 1923828 | 2021-11-16 | Hot Springs | Wyoming | 56017 | 887 | 10 |
1919008 | 1919008 | 2021-11-15 | Teton | Montana | 30099 | 887 | 15 |
1915919 | 1915919 | 2021-11-14 | Guadalupe | New Mexico | 35019 | 887 | 15 |
1912669 | 1912669 | 2021-11-13 | Guadalupe | New Mexico | 35019 | 887 | 15 |
1909419 | 1909419 | 2021-11-12 | Guadalupe | New Mexico | 35019 | 887 | 15 |
1867400 | 1867400 | 2021-10-30 | Sioux | North Dakota | 38085 | 887 | 16 |
1858865 | 1858865 | 2021-10-28 | Choctaw | Alabama | 1023 | 887 | 27 |
1859829 | 1859829 | 2021-10-28 | Republic | Kansas | 20157 | 887 | 15 |
1856580 | 1856580 | 2021-10-27 | Republic | Kansas | 20157 | 887 | 15 |
1855361 | 1855361 | 2021-10-26 | Mathews | Virginia | 51115 | 887 | 21 |
1852112 | 1852112 | 2021-10-25 | Mathews | Virginia | 51115 | 887 | 21 |
1849036 | 1849036 | 2021-10-24 | Iron | Wisconsin | 55051 | 887 | 42 |
1845786 | 1845786 | 2021-10-23 | Iron | Wisconsin | 55051 | 887 | 42 |
1842536 | 1842536 | 2021-10-22 | Iron | Wisconsin | 55051 | 887 | 42 |
1834229 | 1834229 | 2021-10-20 | Mahnomen | Minnesota | 27087 | 887 | 12 |
1807736 | 1807736 | 2021-10-12 | Osceola | Iowa | 19143 | 887 | 17 |
1807863 | 1807863 | 2021-10-12 | Wabaunsee | Kansas | 20197 | 887 | 18 |
1804485 | 1804485 | 2021-10-11 | Osceola | Iowa | 19143 | 887 | 17 |
1804612 | 1804612 | 2021-10-11 | Wabaunsee | Kansas | 20197 | 887 | 18 |
1806124 | 1806124 | 2021-10-11 | McCook | South Dakota | 46087 | 887 | 25 |
1801236 | 1801236 | 2021-10-10 | Osceola | Iowa | 19143 | 887 | 17 |
1802874 | 1802874 | 2021-10-10 | McCook | South Dakota | 46087 | 887 | 25 |
1797987 | 1797987 | 2021-10-09 | Osceola | Iowa | 19143 | 887 | 17 |
1799625 | 1799625 | 2021-10-09 | McCook | South Dakota | 46087 | 887 | 25 |
1794738 | 1794738 | 2021-10-08 | Osceola | Iowa | 19143 | 887 | 17 |
1796376 | 1796376 | 2021-10-08 | McCook | South Dakota | 46087 | 887 | 25 |
1791490 | 1791490 | 2021-10-07 | Osceola | Iowa | 19143 | 887 | 17 |
1788241 | 1788241 | 2021-10-06 | Osceola | Iowa | 19143 | 887 | 17 |
1789116 | 1789116 | 2021-10-06 | Richardson | Nebraska | 31147 | 887 | 24 |
1768132 | 1768132 | 2021-09-30 | Conejos | Colorado | 8021 | 887 | 30 |
1770767 | 1770767 | 2021-09-30 | Kane | Utah | 49025 | 887 | 9 |
1764883 | 1764883 | 2021-09-29 | Conejos | Colorado | 8021 | 887 | 30 |
1766311 | 1766311 | 2021-09-29 | Cedar | Nebraska | 31027 | 887 | 11 |
1767411 | 1767411 | 2021-09-29 | McCulloch | Texas | 48307 | 887 | 28 |
1764571 | 1764571 | 2021-09-28 | Menominee | Wisconsin | 55078 | 887 | 11 |
1741987 | 1741987 | 2021-09-22 | Greenlee | Arizona | 4011 | 887 | 15 |
1744712 | 1744712 | 2021-09-22 | Sabine | Texas | 48403 | 887 | 62 |
1731701 | 1731701 | 2021-09-18 | Presidio | Texas | 48377 | 887 | 26 |
1728451 | 1728451 | 2021-09-17 | Presidio | Texas | 48377 | 887 | 26 |
1723481 | 1723481 | 2021-09-16 | Nicholas | Kentucky | 21181 | 887 | 10 |
1725202 | 1725202 | 2021-09-16 | Presidio | Texas | 48377 | 887 | 26 |
1721953 | 1721953 | 2021-09-15 | Presidio | Texas | 48377 | 887 | 25 |
1718705 | 1718705 | 2021-09-14 | Presidio | Texas | 48377 | 887 | 25 |
1715751 | 1715751 | 2021-09-13 | Doddridge | West Virginia | 54017 | 887 | 6 |
1710332 | 1710332 | 2021-09-12 | Greenwood | Kansas | 20073 | 887 | 11 |
1707085 | 1707085 | 2021-09-11 | Greenwood | Kansas | 20073 | 887 | 11 |
1703837 | 1703837 | 2021-09-10 | Greenwood | Kansas | 20073 | 887 | 11 |
1690693 | 1690693 | 2021-09-06 | Union | Indiana | 18161 | 887 | 11 |
1687443 | 1687443 | 2021-09-05 | Union | Indiana | 18161 | 887 | 11 |
1684193 | 1684193 | 2021-09-04 | Union | Indiana | 18161 | 887 | 11 |
1684969 | 1684969 | 2021-09-04 | Maries | Missouri | 29125 | 887 | 15 |
1680942 | 1680942 | 2021-09-03 | Union | Indiana | 18161 | 887 | 11 |
1682197 | 1682197 | 2021-09-03 | Pembina | North Dakota | 38067 | 887 | 11 |
1680050 | 1680050 | 2021-09-02 | Ritchie | West Virginia | 54085 | 887 | 11 |
1644099 | 1644099 | 2021-08-22 | Orange | Vermont | 50017 | 887 | 3 |
1629678 | 1629678 | 2021-08-18 | Wilkinson | Mississippi | 28157 | 887 | 33 |
1628181 | 1628181 | 2021-08-17 | Sublette | Wyoming | 56035 | 887 | 10 |
1621851 | 1621851 | 2021-08-16 | Montgomery | Arkansas | 5097 | 887 | 33 |
1610238 | 1610238 | 2021-08-12 | Hickory | Missouri | 29085 | 887 | 16 |
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);