ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
436 rows where cases = 915 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 35
- Virginia 28
- Missouri 27
- Montana 26
- Texas 24
- Iowa 23
- Kentucky 19
- Minnesota 16
- Kansas 15
- Mississippi 15
- South Dakota 13
- Nebraska 12
- Puerto Rico 12
- Illinois 11
- Louisiana 11
- Oklahoma 11
- Arkansas 8
- Michigan 8
- North Dakota 8
- Tennessee 8
- Wisconsin 8
- Idaho 7
- South Carolina 7
- Wyoming 7
- Indiana 6
- Washington 6
- New York 5
- Oregon 5
- Utah 5
- West Virginia 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2488415 | 2488415 | 2022-05-09 | Hamilton | New York | 36041 | 915 | 5 |
2462138 | 2462138 | 2022-05-01 | Musselshell | Montana | 30065 | 915 | 31 |
2458882 | 2458882 | 2022-04-30 | Musselshell | Montana | 30065 | 915 | 31 |
2455626 | 2455626 | 2022-04-29 | Musselshell | Montana | 30065 | 915 | 31 |
2452370 | 2452370 | 2022-04-28 | Musselshell | Montana | 30065 | 915 | 31 |
2449114 | 2449114 | 2022-04-27 | Musselshell | Montana | 30065 | 915 | 31 |
2445857 | 2445857 | 2022-04-26 | Musselshell | Montana | 30065 | 915 | 31 |
2442602 | 2442602 | 2022-04-25 | Musselshell | Montana | 30065 | 915 | 31 |
2439346 | 2439346 | 2022-04-24 | Musselshell | Montana | 30065 | 915 | 26 |
2436090 | 2436090 | 2022-04-23 | Musselshell | Montana | 30065 | 915 | 26 |
2432834 | 2432834 | 2022-04-22 | Musselshell | Montana | 30065 | 915 | 26 |
2310558 | 2310558 | 2022-03-15 | Rappahannock | Virginia | 51157 | 915 | 9 |
2258382 | 2258382 | 2022-02-27 | Garfield | Utah | 49017 | 915 | 14 |
2255131 | 2255131 | 2022-02-26 | Garfield | Utah | 49017 | 915 | 14 |
2251880 | 2251880 | 2022-02-25 | Garfield | Utah | 49017 | 915 | 14 |
2193921 | 2193921 | 2022-02-08 | Modoc | California | 6049 | 915 | 6 |
2195262 | 2195262 | 2022-02-08 | Knox | Missouri | 29103 | 915 | 12 |
2187644 | 2187644 | 2022-02-06 | Echols | Georgia | 13101 | 915 | 11 |
2184391 | 2184391 | 2022-02-05 | Echols | Georgia | 13101 | 915 | 11 |
2181139 | 2181139 | 2022-02-04 | Echols | Georgia | 13101 | 915 | 11 |
2153445 | 2153445 | 2022-01-26 | LaMoure | North Dakota | 38045 | 915 | 19 |
2150339 | 2150339 | 2022-01-25 | Dewey | Oklahoma | 40043 | 915 | 24 |
2147087 | 2147087 | 2022-01-24 | Dewey | Oklahoma | 40043 | 915 | 24 |
2143833 | 2143833 | 2022-01-23 | Dewey | Oklahoma | 40043 | 915 | 24 |
2144619 | 2144619 | 2022-01-23 | Craig | Virginia | 51045 | 915 | 11 |
2140578 | 2140578 | 2022-01-22 | Dewey | Oklahoma | 40043 | 915 | 24 |
2141219 | 2141219 | 2022-01-22 | Presidio | Texas | 48377 | 915 | 32 |
2141364 | 2141364 | 2022-01-22 | Craig | Virginia | 51045 | 915 | 11 |
2137322 | 2137322 | 2022-01-21 | Dewey | Oklahoma | 40043 | 915 | 24 |
2138108 | 2138108 | 2022-01-21 | Craig | Virginia | 51045 | 915 | 11 |
2134068 | 2134068 | 2022-01-20 | Dewey | Oklahoma | 40043 | 915 | 24 |
2130816 | 2130816 | 2022-01-19 | Dewey | Oklahoma | 40043 | 915 | 24 |
2123909 | 2123909 | 2022-01-17 | Lander | Nevada | 32015 | 915 | 16 |
2120657 | 2120657 | 2022-01-16 | Lander | Nevada | 32015 | 915 | 16 |
2117405 | 2117405 | 2022-01-15 | Lander | Nevada | 32015 | 915 | 16 |
2114154 | 2114154 | 2022-01-14 | Lander | Nevada | 32015 | 915 | 16 |
2107595 | 2107595 | 2022-01-12 | Howard | Nebraska | 31093 | 915 | 15 |
2087007 | 2087007 | 2022-01-06 | Henderson | Illinois | 17071 | 915 | 24 |
2083721 | 2083721 | 2022-01-05 | Alexander | Illinois | 17003 | 915 | 13 |
2060633 | 2060633 | 2021-12-29 | Huerfano | Colorado | 8055 | 915 | 26 |
2037433 | 2037433 | 2021-12-21 | Ferry | Washington | 53019 | 915 | 18 |
2034183 | 2034183 | 2021-12-20 | Ferry | Washington | 53019 | 915 | 18 |
2028820 | 2028820 | 2021-12-19 | Mitchell | Kansas | 20123 | 915 | 17 |
2025569 | 2025569 | 2021-12-18 | Mitchell | Kansas | 20123 | 915 | 17 |
2022318 | 2022318 | 2021-12-17 | Mitchell | Kansas | 20123 | 915 | 17 |
2016359 | 2016359 | 2021-12-15 | Atchison | Missouri | 29005 | 915 | 18 |
2006066 | 2006066 | 2021-12-12 | Morris | Kansas | 20127 | 915 | 22 |
2006088 | 2006088 | 2021-12-12 | Scott | Kansas | 20171 | 915 | 32 |
2002815 | 2002815 | 2021-12-11 | Morris | Kansas | 20127 | 915 | 22 |
2002837 | 2002837 | 2021-12-11 | Scott | Kansas | 20171 | 915 | 32 |
1999565 | 1999565 | 2021-12-10 | Morris | Kansas | 20127 | 915 | 22 |
1999587 | 1999587 | 2021-12-10 | Scott | Kansas | 20171 | 915 | 32 |
1996722 | 1996722 | 2021-12-09 | Lincoln | Minnesota | 27081 | 915 | 5 |
1965859 | 1965859 | 2021-11-29 | Mathews | Virginia | 51115 | 915 | 24 |
1938462 | 1938462 | 2021-11-21 | Broadwater | Montana | 30007 | 915 | 17 |
1935212 | 1935212 | 2021-11-20 | Broadwater | Montana | 30007 | 915 | 17 |
1931962 | 1931962 | 2021-11-19 | Broadwater | Montana | 30007 | 915 | 17 |
1881579 | 1881579 | 2021-11-03 | Crook | Wyoming | 56011 | 915 | 18 |
1875338 | 1875338 | 2021-11-02 | Trinity | California | 6105 | 915 | 11 |
1869982 | 1869982 | 2021-10-31 | Norman | Minnesota | 27107 | 915 | 9 |
1870345 | 1870345 | 2021-10-31 | Richardson | Nebraska | 31147 | 915 | 24 |
1866733 | 1866733 | 2021-10-30 | Norman | Minnesota | 27107 | 915 | 9 |
1867382 | 1867382 | 2021-10-30 | McHenry | North Dakota | 38049 | 915 | 23 |
1863484 | 1863484 | 2021-10-29 | Norman | Minnesota | 27107 | 915 | 9 |
1846792 | 1846792 | 2021-10-24 | Harper | Kansas | 20077 | 915 | 19 |
1848962 | 1848962 | 2021-10-24 | Calhoun | West Virginia | 54013 | 915 | 4 |
1843542 | 1843542 | 2021-10-23 | Harper | Kansas | 20077 | 915 | 19 |
1840292 | 1840292 | 2021-10-22 | Harper | Kansas | 20077 | 915 | 19 |
1834901 | 1834901 | 2021-10-20 | Ransom | North Dakota | 38073 | 915 | 19 |
1827957 | 1827957 | 2021-10-18 | Shelby | Missouri | 29205 | 915 | 9 |
1824708 | 1824708 | 2021-10-17 | Shelby | Missouri | 29205 | 915 | 9 |
1821459 | 1821459 | 2021-10-16 | Shelby | Missouri | 29205 | 915 | 9 |
1822647 | 1822647 | 2021-10-16 | McCulloch | Texas | 48307 | 915 | 36 |
1809759 | 1809759 | 2021-10-12 | Kane | Utah | 49025 | 915 | 9 |
1803685 | 1803685 | 2021-10-11 | Aleutians West Census Area | Alaska | 2016 | 915 | 0 |
1806103 | 1806103 | 2021-10-11 | Fall River | South Dakota | 46047 | 915 | 22 |
1800436 | 1800436 | 2021-10-10 | Aleutians West Census Area | Alaska | 2016 | 915 | 0 |
1802853 | 1802853 | 2021-10-10 | Fall River | South Dakota | 46047 | 915 | 22 |
1797187 | 1797187 | 2021-10-09 | Aleutians West Census Area | Alaska | 2016 | 915 | 0 |
1799604 | 1799604 | 2021-10-09 | Fall River | South Dakota | 46047 | 915 | 22 |
1793938 | 1793938 | 2021-10-08 | Aleutians West Census Area | Alaska | 2016 | 915 | 0 |
1796355 | 1796355 | 2021-10-08 | Fall River | South Dakota | 46047 | 915 | 22 |
1789388 | 1789388 | 2021-10-06 | Dickey | North Dakota | 38021 | 915 | 33 |
1787317 | 1787317 | 2021-10-05 | Menominee | Wisconsin | 55078 | 915 | 11 |
1782239 | 1782239 | 2021-10-04 | Lac qui Parle | Minnesota | 27073 | 915 | 24 |
1779866 | 1779866 | 2021-10-03 | Grant | Oregon | 41023 | 915 | 10 |
1780456 | 1780456 | 2021-10-03 | San Saba | Texas | 48411 | 915 | 26 |
1776616 | 1776616 | 2021-10-02 | Grant | Oregon | 41023 | 915 | 10 |
1777206 | 1777206 | 2021-10-02 | San Saba | Texas | 48411 | 915 | 26 |
1773366 | 1773366 | 2021-10-01 | Grant | Oregon | 41023 | 915 | 10 |
1773956 | 1773956 | 2021-10-01 | San Saba | Texas | 48411 | 915 | 26 |
1770116 | 1770116 | 2021-09-30 | Grant | Oregon | 41023 | 915 | 10 |
1759576 | 1759576 | 2021-09-27 | Jefferson | Mississippi | 28063 | 915 | 33 |
1744961 | 1744961 | 2021-09-22 | Jefferson | Washington | 53031 | 915 | 12 |
1726835 | 1726835 | 2021-09-17 | Piscataquis | Maine | 23021 | 915 | 7 |
1716905 | 1716905 | 2021-09-14 | Bracken | Kentucky | 21023 | 915 | 8 |
1713675 | 1713675 | 2021-09-13 | Crittenden | Kentucky | 21055 | 915 | 28 |
1702173 | 1702173 | 2021-09-09 | Spink | South Dakota | 46115 | 915 | 26 |
1702533 | 1702533 | 2021-09-09 | Beaver | Utah | 49001 | 915 | 10 |
1699038 | 1699038 | 2021-09-08 | Bailey | Texas | 48017 | 915 | 21 |
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);