ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
472 rows where cases = 730 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Nebraska 55
- Texas 37
- Georgia 27
- Virginia 27
- Kansas 22
- Missouri 19
- Arkansas 18
- Illinois 16
- Alaska 15
- Puerto Rico 15
- Iowa 13
- Kentucky 13
- Michigan 13
- Minnesota 13
- South Dakota 12
- Indiana 11
- Mississippi 10
- Montana 10
- North Carolina 10
- North Dakota 10
- Alabama 7
- Ohio 7
- Oklahoma 7
- Tennessee 7
- West Virginia 7
- Idaho 6
- Louisiana 6
- Pennsylvania 6
- California 5
- Colorado 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2498079 | 2498079 | 2022-05-12 | Valley | Nebraska | 31175 | 730 | 6 |
2494821 | 2494821 | 2022-05-11 | Valley | Nebraska | 31175 | 730 | 6 |
2444293 | 2444293 | 2022-04-26 | Petersburg Borough | Alaska | 2195 | 730 | 4 |
2441037 | 2441037 | 2022-04-25 | Petersburg Borough | Alaska | 2195 | 730 | 4 |
2437781 | 2437781 | 2022-04-24 | Petersburg Borough | Alaska | 2195 | 730 | 4 |
2434525 | 2434525 | 2022-04-23 | Petersburg Borough | Alaska | 2195 | 730 | 4 |
2431269 | 2431269 | 2022-04-22 | Petersburg Borough | Alaska | 2195 | 730 | 4 |
2428013 | 2428013 | 2022-04-21 | Petersburg Borough | Alaska | 2195 | 730 | 4 |
2424757 | 2424757 | 2022-04-20 | Petersburg Borough | Alaska | 2195 | 730 | 4 |
2268009 | 2268009 | 2022-03-02 | Kinney | Texas | 48271 | 730 | 10 |
2218314 | 2218314 | 2022-02-15 | Mora | New Mexico | 35033 | 730 | 16 |
2198985 | 2198985 | 2022-02-09 | Eddy | North Dakota | 38027 | 730 | 6 |
2150984 | 2150984 | 2022-01-25 | Real | Texas | 48385 | 730 | 22 |
2138066 | 2138066 | 2022-01-21 | Grand Isle | Vermont | 50013 | 730 | 4 |
2134560 | 2134560 | 2022-01-20 | Cochran | Texas | 48079 | 730 | 21 |
2118362 | 2118362 | 2022-01-15 | Haskell | Texas | 48207 | 730 | 37 |
2080187 | 2080187 | 2022-01-04 | Unknown | Delaware | 730 | 0 | |
2081887 | 2081887 | 2022-01-04 | Foster | North Dakota | 38031 | 730 | 19 |
2078635 | 2078635 | 2022-01-03 | Foster | North Dakota | 38031 | 730 | 19 |
2075384 | 2075384 | 2022-01-02 | Foster | North Dakota | 38031 | 730 | 19 |
2072133 | 2072133 | 2022-01-01 | Foster | North Dakota | 38031 | 730 | 19 |
2060104 | 2060104 | 2021-12-28 | King and Queen | Virginia | 51097 | 730 | 9 |
2056818 | 2056818 | 2021-12-27 | Craig | Virginia | 51045 | 730 | 11 |
2053628 | 2053628 | 2021-12-26 | Norton city | Virginia | 51720 | 730 | 19 |
2050378 | 2050378 | 2021-12-25 | Norton city | Virginia | 51720 | 730 | 19 |
2047128 | 2047128 | 2021-12-24 | Norton city | Virginia | 51720 | 730 | 19 |
2039003 | 2039003 | 2021-12-22 | Red Lake | Minnesota | 27125 | 730 | 11 |
2030226 | 2030226 | 2021-12-19 | Guayanilla | Puerto Rico | 72059 | 730 | |
2011089 | 2011089 | 2021-12-13 | Hemphill | Texas | 48211 | 730 | 3 |
2007838 | 2007838 | 2021-12-12 | Hemphill | Texas | 48211 | 730 | 3 |
2004587 | 2004587 | 2021-12-11 | Hemphill | Texas | 48211 | 730 | 3 |
1996895 | 1996895 | 2021-12-09 | Holt | Missouri | 29087 | 730 | 23 |
1994582 | 1994582 | 2021-12-08 | Corson | South Dakota | 46031 | 730 | 15 |
1990911 | 1990911 | 2021-12-07 | Wells | North Dakota | 38103 | 730 | 10 |
1967465 | 1967465 | 2021-11-30 | Kittson | Minnesota | 27069 | 730 | 23 |
1952797 | 1952797 | 2021-11-25 | Charles City | Virginia | 51036 | 730 | 21 |
1941794 | 1941794 | 2021-11-22 | Fillmore | Nebraska | 31059 | 730 | 13 |
1938563 | 1938563 | 2021-11-21 | Johnson | Nebraska | 31097 | 730 | 10 |
1935313 | 1935313 | 2021-11-20 | Johnson | Nebraska | 31097 | 730 | 10 |
1932063 | 1932063 | 2021-11-19 | Johnson | Nebraska | 31097 | 730 | 10 |
1924149 | 1924149 | 2021-11-17 | Washington | Colorado | 8121 | 730 | 23 |
1921202 | 1921202 | 2021-11-16 | Calhoun | Illinois | 17013 | 730 | 5 |
1917784 | 1917784 | 2021-11-15 | Echols | Georgia | 13101 | 730 | 11 |
1918989 | 1918989 | 2021-11-15 | Mineral | Montana | 30061 | 730 | 13 |
1919047 | 1919047 | 2021-11-15 | Furnas | Nebraska | 31065 | 730 | 5 |
1903806 | 1903806 | 2021-11-10 | Garza | Texas | 48169 | 730 | 22 |
1900556 | 1900556 | 2021-11-09 | Garza | Texas | 48169 | 730 | 22 |
1893022 | 1893022 | 2021-11-07 | Boone | Nebraska | 31011 | 730 | 4 |
1889772 | 1889772 | 2021-11-06 | Boone | Nebraska | 31011 | 730 | 4 |
1886522 | 1886522 | 2021-11-05 | Boone | Nebraska | 31011 | 730 | 4 |
1883273 | 1883273 | 2021-11-04 | Boone | Nebraska | 31011 | 730 | 4 |
1880024 | 1880024 | 2021-11-03 | Boone | Nebraska | 31011 | 730 | 4 |
1881313 | 1881313 | 2021-11-03 | Fairfax city | Virginia | 51600 | 730 | 25 |
1807826 | 1807826 | 2021-10-12 | Mitchell | Kansas | 20123 | 730 | 17 |
1808519 | 1808519 | 2021-10-12 | Pondera | Montana | 30073 | 730 | 4 |
1804575 | 1804575 | 2021-10-11 | Mitchell | Kansas | 20123 | 730 | 17 |
1788725 | 1788725 | 2021-10-06 | Grant | Minnesota | 27051 | 730 | 9 |
1785866 | 1785866 | 2021-10-05 | Polk | Nebraska | 31143 | 730 | 18 |
1760786 | 1760786 | 2021-09-27 | Carson | Texas | 48065 | 730 | 18 |
1757538 | 1757538 | 2021-09-26 | Carson | Texas | 48065 | 730 | 18 |
1754290 | 1754290 | 2021-09-25 | Carson | Texas | 48065 | 730 | 18 |
1739568 | 1739568 | 2021-09-21 | Gray | Kansas | 20069 | 730 | 14 |
1739597 | 1739597 | 2021-09-21 | Morris | Kansas | 20127 | 730 | 23 |
1736319 | 1736319 | 2021-09-20 | Gray | Kansas | 20069 | 730 | 14 |
1736348 | 1736348 | 2021-09-20 | Morris | Kansas | 20127 | 730 | 23 |
1723367 | 1723367 | 2021-09-16 | Rooks | Kansas | 20163 | 730 | 11 |
1720118 | 1720118 | 2021-09-15 | Rooks | Kansas | 20163 | 730 | 11 |
1722245 | 1722245 | 2021-09-15 | Calhoun | West Virginia | 54013 | 730 | 2 |
1717940 | 1717940 | 2021-09-14 | Sioux | North Dakota | 38085 | 730 | 14 |
1715321 | 1715321 | 2021-09-13 | Crockett | Texas | 48105 | 730 | 15 |
1697167 | 1697167 | 2021-09-08 | Ohio | Indiana | 18115 | 730 | 11 |
1699082 | 1699082 | 2021-09-08 | Crockett | Texas | 48105 | 730 | 15 |
1694402 | 1694402 | 2021-09-07 | Alger | Michigan | 26003 | 730 | 7 |
1691219 | 1691219 | 2021-09-06 | Oscoda | Michigan | 26135 | 730 | 31 |
1687969 | 1687969 | 2021-09-05 | Oscoda | Michigan | 26135 | 730 | 31 |
1684719 | 1684719 | 2021-09-04 | Oscoda | Michigan | 26135 | 730 | 31 |
1681468 | 1681468 | 2021-09-03 | Oscoda | Michigan | 26135 | 730 | 31 |
1682552 | 1682552 | 2021-09-03 | Sabana Grande | Puerto Rico | 72121 | 730 | |
1677598 | 1677598 | 2021-09-02 | Stark | Illinois | 17175 | 730 | 26 |
1679302 | 1679302 | 2021-09-02 | Sabana Grande | Puerto Rico | 72121 | 730 | |
1676810 | 1676810 | 2021-09-01 | Webster | West Virginia | 54101 | 730 | 11 |
1672894 | 1672894 | 2021-08-31 | Day | South Dakota | 46037 | 730 | 30 |
1660203 | 1660203 | 2021-08-27 | Martin | Texas | 48317 | 730 | 20 |
1634612 | 1634612 | 2021-08-19 | Iron | Wisconsin | 55051 | 730 | 42 |
1631327 | 1631327 | 2021-08-18 | Roane | West Virginia | 54087 | 730 | 9 |
1631364 | 1631364 | 2021-08-18 | Iron | Wisconsin | 55051 | 730 | 42 |
1609271 | 1609271 | 2021-08-12 | Caribou | Idaho | 16029 | 730 | 12 |
1609669 | 1609669 | 2021-08-12 | Phillips | Kansas | 20147 | 730 | 25 |
1606022 | 1606022 | 2021-08-11 | Caribou | Idaho | 16029 | 730 | 12 |
1606420 | 1606420 | 2021-08-11 | Phillips | Kansas | 20147 | 730 | 25 |
1602773 | 1602773 | 2021-08-10 | Caribou | Idaho | 16029 | 730 | 12 |
1598104 | 1598104 | 2021-08-08 | Santa Isabel | Puerto Rico | 72133 | 730 | |
1582786 | 1582786 | 2021-08-04 | Ketchikan Gateway Borough | Alaska | 2130 | 730 | 1 |
1574073 | 1574073 | 2021-08-01 | Trimble | Kentucky | 21223 | 730 | 7 |
1570825 | 1570825 | 2021-07-31 | Trimble | Kentucky | 21223 | 730 | 7 |
1567577 | 1567577 | 2021-07-30 | Trimble | Kentucky | 21223 | 730 | 7 |
1559715 | 1559715 | 2021-07-27 | Lancaster | Virginia | 51103 | 730 | 18 |
1538731 | 1538731 | 2021-07-21 | Wilkinson | Mississippi | 28157 | 730 | 32 |
1519272 | 1519272 | 2021-07-15 | Clark | Missouri | 29045 | 730 | 9 |
1506431 | 1506431 | 2021-07-11 | Toole | Montana | 30101 | 730 | 11 |
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);