ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
354 rows where cases = 1305 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 33
- Texas 27
- Virginia 26
- Georgia 17
- Mississippi 16
- North Carolina 16
- Illinois 14
- Minnesota 12
- Missouri 12
- West Virginia 12
- Alabama 11
- Kentucky 11
- Oregon 11
- Arkansas 9
- Florida 8
- Louisiana 8
- Puerto Rico 8
- South Dakota 8
- Tennessee 8
- Colorado 7
- Indiana 6
- Kansas 6
- Pennsylvania 6
- Montana 5
- North Dakota 5
- California 4
- Maine 4
- Ohio 4
- South Carolina 4
- Washington 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2492824 | 2492824 | 2022-05-10 | Norton city | Virginia | 51720 | 1305 | 22 |
2489566 | 2489566 | 2022-05-09 | Norton city | Virginia | 51720 | 1305 | 22 |
2433975 | 2433975 | 2022-04-22 | McCulloch | Texas | 48307 | 1305 | 47 |
2430719 | 2430719 | 2022-04-21 | McCulloch | Texas | 48307 | 1305 | 47 |
2424438 | 2424438 | 2022-04-19 | Norton city | Virginia | 51720 | 1305 | 22 |
2421182 | 2421182 | 2022-04-18 | Norton city | Virginia | 51720 | 1305 | 22 |
2417926 | 2417926 | 2022-04-17 | Norton city | Virginia | 51720 | 1305 | 22 |
2414670 | 2414670 | 2022-04-16 | Norton city | Virginia | 51720 | 1305 | 22 |
2411414 | 2411414 | 2022-04-15 | Norton city | Virginia | 51720 | 1305 | 22 |
2408158 | 2408158 | 2022-04-14 | Norton city | Virginia | 51720 | 1305 | 22 |
2385370 | 2385370 | 2022-04-07 | Norton city | Virginia | 51720 | 1305 | 22 |
2382115 | 2382115 | 2022-04-06 | Norton city | Virginia | 51720 | 1305 | 22 |
2378860 | 2378860 | 2022-04-05 | Norton city | Virginia | 51720 | 1305 | 22 |
2375606 | 2375606 | 2022-04-04 | Norton city | Virginia | 51720 | 1305 | 22 |
2372354 | 2372354 | 2022-04-03 | Norton city | Virginia | 51720 | 1305 | 22 |
2369101 | 2369101 | 2022-04-02 | Norton city | Virginia | 51720 | 1305 | 22 |
2365848 | 2365848 | 2022-04-01 | Norton city | Virginia | 51720 | 1305 | 22 |
2309479 | 2309479 | 2022-03-15 | Hyde | North Carolina | 37095 | 1305 | 13 |
2306226 | 2306226 | 2022-03-14 | Hyde | North Carolina | 37095 | 1305 | 13 |
2280786 | 2280786 | 2022-03-06 | Walworth | South Dakota | 46129 | 1305 | 25 |
2277533 | 2277533 | 2022-03-05 | Walworth | South Dakota | 46129 | 1305 | 25 |
2274280 | 2274280 | 2022-03-04 | Walworth | South Dakota | 46129 | 1305 | 25 |
2267749 | 2267749 | 2022-03-02 | Kingsbury | South Dakota | 46077 | 1305 | 20 |
2202268 | 2202268 | 2022-02-10 | Sioux | North Dakota | 38085 | 1305 | 19 |
2198465 | 2198465 | 2022-02-09 | Atchison | Missouri | 29005 | 1305 | 19 |
2196946 | 2196946 | 2022-02-08 | Crook | Wyoming | 56011 | 1305 | 24 |
2193260 | 2193260 | 2022-02-07 | Newton | Texas | 48351 | 1305 | 56 |
2173450 | 2173450 | 2022-02-01 | McCook | South Dakota | 46087 | 1305 | 30 |
2150800 | 2150800 | 2022-01-25 | Bailey | Texas | 48017 | 1305 | 31 |
2143105 | 2143105 | 2022-01-23 | Jefferson | Mississippi | 28063 | 1305 | 35 |
2143902 | 2143902 | 2022-01-23 | Harney | Oregon | 41025 | 1305 | 35 |
2139850 | 2139850 | 2022-01-22 | Jefferson | Mississippi | 28063 | 1305 | 35 |
2140647 | 2140647 | 2022-01-22 | Harney | Oregon | 41025 | 1305 | 35 |
2136594 | 2136594 | 2022-01-21 | Jefferson | Mississippi | 28063 | 1305 | 35 |
2136662 | 2136662 | 2022-01-21 | Carter | Missouri | 29035 | 1305 | 19 |
2137391 | 2137391 | 2022-01-21 | Harney | Oregon | 41025 | 1305 | 35 |
2125547 | 2125547 | 2022-01-18 | Montgomery | Arkansas | 5097 | 1305 | 53 |
2103305 | 2103305 | 2022-01-11 | Pulaski | Illinois | 17153 | 1305 | 15 |
2103622 | 2103622 | 2022-01-11 | Wabaunsee | Kansas | 20197 | 1305 | 19 |
2100371 | 2100371 | 2022-01-10 | Wabaunsee | Kansas | 20197 | 1305 | 19 |
2057908 | 2057908 | 2021-12-28 | Adair | Iowa | 19001 | 1305 | 43 |
2054659 | 2054659 | 2021-12-27 | Adair | Iowa | 19001 | 1305 | 43 |
2051409 | 2051409 | 2021-12-26 | Adair | Iowa | 19001 | 1305 | 43 |
2048159 | 2048159 | 2021-12-25 | Adair | Iowa | 19001 | 1305 | 43 |
2044909 | 2044909 | 2021-12-24 | Adair | Iowa | 19001 | 1305 | 43 |
2041660 | 2041660 | 2021-12-23 | Adair | Iowa | 19001 | 1305 | 43 |
2038410 | 2038410 | 2021-12-22 | Adair | Iowa | 19001 | 1305 | 43 |
2029372 | 2029372 | 2021-12-19 | Caldwell | Missouri | 29025 | 1305 | 26 |
2026121 | 2026121 | 2021-12-18 | Caldwell | Missouri | 29025 | 1305 | 26 |
2022900 | 2022900 | 2021-12-17 | Hickory | Missouri | 29085 | 1305 | 44 |
2017996 | 2017996 | 2021-12-15 | Pocahontas | West Virginia | 54075 | 1305 | 21 |
2005891 | 2005891 | 2021-12-12 | Union | Indiana | 18161 | 1305 | 17 |
2002024 | 2002024 | 2021-12-11 | Prairie | Arkansas | 5117 | 1305 | 29 |
2002640 | 2002640 | 2021-12-11 | Union | Indiana | 18161 | 1305 | 17 |
1999390 | 1999390 | 2021-12-10 | Union | Indiana | 18161 | 1305 | 17 |
1993785 | 1993785 | 2021-12-08 | Butler | Nebraska | 31023 | 1305 | 12 |
1990534 | 1990534 | 2021-12-07 | Butler | Nebraska | 31023 | 1305 | 12 |
1991471 | 1991471 | 2021-12-07 | Van Buren | Tennessee | 47175 | 1305 | 32 |
1983365 | 1983365 | 2021-12-05 | Bracken | Kentucky | 21023 | 1305 | 17 |
1979133 | 1979133 | 2021-12-04 | Greene | Alabama | 1063 | 1305 | 45 |
1980115 | 1980115 | 2021-12-04 | Bracken | Kentucky | 21023 | 1305 | 17 |
1976865 | 1976865 | 2021-12-03 | Bracken | Kentucky | 21023 | 1305 | 17 |
1964693 | 1964693 | 2021-11-29 | Sierra | New Mexico | 35051 | 1305 | 59 |
1927079 | 1927079 | 2021-11-17 | Johnson | Wyoming | 56019 | 1305 | 16 |
1921156 | 1921156 | 2021-11-16 | Benewah | Idaho | 16009 | 1305 | 28 |
1907452 | 1907452 | 2021-11-11 | Clay | West Virginia | 54015 | 1305 | 20 |
1891435 | 1891435 | 2021-11-07 | Southeast Fairbanks Census Area | Alaska | 2240 | 1305 | 10 |
1888185 | 1888185 | 2021-11-06 | Southeast Fairbanks Census Area | Alaska | 2240 | 1305 | 10 |
1884935 | 1884935 | 2021-11-05 | Southeast Fairbanks Census Area | Alaska | 2240 | 1305 | 10 |
1870003 | 1870003 | 2021-10-31 | Stevens | Minnesota | 27149 | 1305 | 11 |
1866754 | 1866754 | 2021-10-30 | Stevens | Minnesota | 27149 | 1305 | 11 |
1863505 | 1863505 | 2021-10-29 | Stevens | Minnesota | 27149 | 1305 | 11 |
1861575 | 1861575 | 2021-10-28 | Hamilton | Texas | 48193 | 1305 | 29 |
1858326 | 1858326 | 2021-10-27 | Hamilton | Texas | 48193 | 1305 | 29 |
1851747 | 1851747 | 2021-10-25 | Blanco | Texas | 48031 | 1305 | 28 |
1848497 | 1848497 | 2021-10-24 | Blanco | Texas | 48031 | 1305 | 28 |
1845247 | 1845247 | 2021-10-23 | Blanco | Texas | 48031 | 1305 | 28 |
1841997 | 1841997 | 2021-10-22 | Blanco | Texas | 48031 | 1305 | 28 |
1836390 | 1836390 | 2021-10-21 | Lincoln | Colorado | 8073 | 1305 | 8 |
1810409 | 1810409 | 2021-10-13 | Park | Colorado | 8093 | 1305 | 8 |
1811543 | 1811543 | 2021-10-13 | Claiborne | Mississippi | 28021 | 1305 | 37 |
1813360 | 1813360 | 2021-10-13 | Sublette | Wyoming | 56035 | 1305 | 13 |
1805020 | 1805020 | 2021-10-11 | Swift | Minnesota | 27151 | 1305 | 19 |
1791106 | 1791106 | 2021-10-07 | Macon | Georgia | 13193 | 1305 | 40 |
1793767 | 1793767 | 2021-10-07 | Tyler | West Virginia | 54095 | 1305 | 18 |
1790190 | 1790190 | 2021-10-06 | Red River | Texas | 48387 | 1305 | 47 |
1787266 | 1787266 | 2021-10-05 | Roane | West Virginia | 54087 | 1305 | 16 |
1782300 | 1782300 | 2021-10-04 | Choctaw | Mississippi | 28019 | 1305 | 26 |
1779240 | 1779240 | 2021-10-03 | Beaverhead | Montana | 30001 | 1305 | 15 |
1775949 | 1775949 | 2021-10-02 | Oregon | Missouri | 29149 | 1305 | 10 |
1775990 | 1775990 | 2021-10-02 | Beaverhead | Montana | 30001 | 1305 | 15 |
1772740 | 1772740 | 2021-10-01 | Beaverhead | Montana | 30001 | 1305 | 15 |
1770844 | 1770844 | 2021-09-30 | Floyd | Virginia | 51063 | 1305 | 24 |
1764845 | 1764845 | 2021-09-29 | Plumas | California | 6063 | 1305 | 6 |
1733526 | 1733526 | 2021-09-19 | Pope | Minnesota | 27121 | 1305 | 8 |
1730276 | 1730276 | 2021-09-18 | Pope | Minnesota | 27121 | 1305 | 8 |
1727026 | 1727026 | 2021-09-17 | Pope | Minnesota | 27121 | 1305 | 8 |
1723354 | 1723354 | 2021-09-16 | Norton | Kansas | 20137 | 1305 | 30 |
1720105 | 1720105 | 2021-09-15 | Norton | Kansas | 20137 | 1305 | 30 |
1716140 | 1716140 | 2021-09-14 | Archuleta | Colorado | 8007 | 1305 | 3 |
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);