ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
175 rows where cases = 2371 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 21
- Michigan 14
- Kentucky 13
- Illinois 10
- Texas 9
- Missouri 8
- Virginia 8
- Oklahoma 7
- Kansas 6
- Louisiana 6
- Mississippi 6
- North Carolina 6
- Pennsylvania 6
- Arkansas 5
- Puerto Rico 5
- Washington 5
- Alabama 4
- Minnesota 3
- Montana 3
- Ohio 3
- South Carolina 3
- South Dakota 3
- Tennessee 3
- West Virginia 3
- Iowa 2
- New York 2
- North Dakota 2
- California 1
- Florida 1
- Idaho 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2473284 | 2473284 | 2022-05-04 | Poquoson city | Virginia | 51735 | 2371 | 30 |
2421168 | 2421168 | 2022-04-18 | Madison | Virginia | 51113 | 2371 | 40 |
2327480 | 2327480 | 2022-03-21 | Dooly | Georgia | 13093 | 2371 | 68 |
2328655 | 2328655 | 2022-03-21 | Wayne | Missouri | 29223 | 2371 | 51 |
2324227 | 2324227 | 2022-03-20 | Dooly | Georgia | 13093 | 2371 | 68 |
2325403 | 2325403 | 2022-03-20 | Wayne | Missouri | 29223 | 2371 | 51 |
2320973 | 2320973 | 2022-03-19 | Dooly | Georgia | 13093 | 2371 | 68 |
2322149 | 2322149 | 2022-03-19 | Wayne | Missouri | 29223 | 2371 | 51 |
2317719 | 2317719 | 2022-03-18 | Dooly | Georgia | 13093 | 2371 | 68 |
2318895 | 2318895 | 2022-03-18 | Wayne | Missouri | 29223 | 2371 | 51 |
2286054 | 2286054 | 2022-03-08 | Mackinac | Michigan | 26097 | 2371 | 29 |
2282802 | 2282802 | 2022-03-07 | Mackinac | Michigan | 26097 | 2371 | 29 |
2269492 | 2269492 | 2022-03-03 | Thomas | Kansas | 20193 | 2371 | 27 |
2266239 | 2266239 | 2022-03-02 | Thomas | Kansas | 20193 | 2371 | 27 |
2247277 | 2247277 | 2022-02-24 | Grundy | Missouri | 29079 | 2371 | 64 |
2239726 | 2239726 | 2022-02-22 | McIntosh | Georgia | 13191 | 2371 | 35 |
2219000 | 2219000 | 2022-02-15 | Roberts | South Dakota | 46109 | 2371 | 47 |
2209476 | 2209476 | 2022-02-12 | Jim Hogg | Texas | 48247 | 2371 | 20 |
2206223 | 2206223 | 2022-02-11 | Jim Hogg | Texas | 48247 | 2371 | 20 |
2180534 | 2180534 | 2022-02-03 | Pend Oreille | Washington | 53051 | 2371 | 29 |
2177283 | 2177283 | 2022-02-02 | Pend Oreille | Washington | 53051 | 2371 | 29 |
2156093 | 2156093 | 2022-01-27 | Carroll | Mississippi | 28015 | 2371 | 43 |
2153901 | 2153901 | 2022-01-26 | Dewey | South Dakota | 46041 | 2371 | 36 |
2089425 | 2089425 | 2022-01-06 | Westmoreland | Virginia | 51193 | 2371 | 39 |
2074817 | 2074817 | 2022-01-02 | Lawrence | Mississippi | 28077 | 2371 | 43 |
2071566 | 2071566 | 2022-01-01 | Lawrence | Mississippi | 28077 | 2371 | 43 |
2068315 | 2068315 | 2021-12-31 | Lawrence | Mississippi | 28077 | 2371 | 43 |
2065064 | 2065064 | 2021-12-30 | Lawrence | Mississippi | 28077 | 2371 | 43 |
2008539 | 2008539 | 2021-12-13 | Van Buren | Arkansas | 5141 | 2371 | 44 |
2009932 | 2009932 | 2021-12-13 | Osage | Missouri | 29151 | 2371 | 35 |
2006681 | 2006681 | 2021-12-12 | Osage | Missouri | 29151 | 2371 | 35 |
1996251 | 1996251 | 2021-12-09 | Allen | Kansas | 20001 | 2371 | 26 |
1993000 | 1993000 | 2021-12-08 | Allen | Kansas | 20001 | 2371 | 26 |
1981420 | 1981420 | 2021-12-04 | Potter | Pennsylvania | 42105 | 2371 | 65 |
1961223 | 1961223 | 2021-11-28 | Custer | Montana | 30017 | 2371 | 39 |
1957972 | 1957972 | 2021-11-27 | Custer | Montana | 30017 | 2371 | 39 |
1954721 | 1954721 | 2021-11-26 | Custer | Montana | 30017 | 2371 | 39 |
1938885 | 1938885 | 2021-11-21 | Ramsey | North Dakota | 38071 | 2371 | 38 |
1935635 | 1935635 | 2021-11-20 | Ramsey | North Dakota | 38071 | 2371 | 38 |
1881634 | 1881634 | 2021-11-04 | Lamar | Alabama | 1075 | 2371 | 51 |
1846466 | 1846466 | 2021-10-24 | Carroll | Illinois | 17015 | 2371 | 39 |
1846920 | 1846920 | 2021-10-24 | Larue | Kentucky | 21123 | 2371 | 45 |
1843216 | 1843216 | 2021-10-23 | Carroll | Illinois | 17015 | 2371 | 39 |
1843670 | 1843670 | 2021-10-23 | Larue | Kentucky | 21123 | 2371 | 45 |
1839966 | 1839966 | 2021-10-22 | Carroll | Illinois | 17015 | 2371 | 39 |
1840420 | 1840420 | 2021-10-22 | Larue | Kentucky | 21123 | 2371 | 45 |
1791524 | 1791524 | 2021-10-07 | Bourbon | Kansas | 20011 | 2371 | 41 |
1793170 | 1793170 | 2021-10-07 | Decatur | Tennessee | 47039 | 2371 | 43 |
1788275 | 1788275 | 2021-10-06 | Bourbon | Kansas | 20011 | 2371 | 41 |
1780011 | 1780011 | 2021-10-03 | Naranjito | Puerto Rico | 72105 | 2371 | |
1780268 | 1780268 | 2021-10-03 | Bosque | Texas | 48035 | 2371 | 52 |
1776773 | 1776773 | 2021-10-02 | San Lorenzo | Puerto Rico | 72129 | 2371 | |
1777018 | 1777018 | 2021-10-02 | Bosque | Texas | 48035 | 2371 | 52 |
1770867 | 1770867 | 2021-09-30 | King George | Virginia | 51099 | 2371 | 22 |
1761782 | 1761782 | 2021-09-28 | Brooks | Georgia | 13027 | 2371 | 62 |
1739030 | 1739030 | 2021-09-21 | Bacon | Georgia | 13005 | 2371 | 51 |
1740799 | 1740799 | 2021-09-21 | Choctaw | Oklahoma | 40023 | 2371 | 33 |
1737550 | 1737550 | 2021-09-20 | Choctaw | Oklahoma | 40023 | 2371 | 33 |
1737718 | 1737718 | 2021-09-20 | Wyoming | Pennsylvania | 42131 | 2371 | 55 |
1734300 | 1734300 | 2021-09-19 | Choctaw | Oklahoma | 40023 | 2371 | 33 |
1731050 | 1731050 | 2021-09-18 | Choctaw | Oklahoma | 40023 | 2371 | 33 |
1727800 | 1727800 | 2021-09-17 | Choctaw | Oklahoma | 40023 | 2371 | 33 |
1724551 | 1724551 | 2021-09-16 | Choctaw | Oklahoma | 40023 | 2371 | 33 |
1724722 | 1724722 | 2021-09-16 | Aguada | Puerto Rico | 72003 | 2371 | |
1721302 | 1721302 | 2021-09-15 | Choctaw | Oklahoma | 40023 | 2371 | 33 |
1715223 | 1715223 | 2021-09-13 | Lewis | Tennessee | 47101 | 2371 | 30 |
1702179 | 1702179 | 2021-09-09 | Union | South Dakota | 46127 | 2371 | 43 |
1678476 | 1678476 | 2021-09-02 | Moniteau | Missouri | 29135 | 2371 | 36 |
1676366 | 1676366 | 2021-09-01 | Freestone | Texas | 48161 | 2371 | 56 |
1671089 | 1671089 | 2021-08-31 | Pike | Illinois | 17149 | 2371 | 57 |
1660230 | 1660230 | 2021-08-27 | Panola | Texas | 48365 | 2371 | 85 |
1657362 | 1657362 | 2021-08-26 | Langlade | Wisconsin | 55067 | 2371 | 51 |
1621804 | 1621804 | 2021-08-16 | Ashley | Arkansas | 5003 | 2371 | 38 |
1621461 | 1621461 | 2021-08-15 | Orange | Virginia | 51137 | 2371 | 40 |
1618213 | 1618213 | 2021-08-14 | Orange | Virginia | 51137 | 2371 | 40 |
1614965 | 1614965 | 2021-08-13 | Orange | Virginia | 51137 | 2371 | 40 |
1608370 | 1608370 | 2021-08-11 | Rutland | Vermont | 50021 | 2371 | 20 |
1602819 | 1602819 | 2021-08-10 | Crawford | Illinois | 17033 | 2371 | 42 |
1583149 | 1583149 | 2021-08-04 | Elbert | Georgia | 13105 | 2371 | 74 |
1583828 | 1583828 | 2021-08-04 | Woodford | Kentucky | 21239 | 2371 | 22 |
1579649 | 1579649 | 2021-08-03 | Colusa | California | 6011 | 2371 | 16 |
1581863 | 1581863 | 2021-08-03 | Vega Alta | Puerto Rico | 72143 | 2371 | |
1554785 | 1554785 | 2021-07-26 | Otsego | Michigan | 26137 | 2371 | 41 |
1551538 | 1551538 | 2021-07-25 | Otsego | Michigan | 26137 | 2371 | 41 |
1548291 | 1548291 | 2021-07-24 | Otsego | Michigan | 26137 | 2371 | 41 |
1545044 | 1545044 | 2021-07-23 | Otsego | Michigan | 26137 | 2371 | 41 |
1489058 | 1489058 | 2021-07-06 | Tattnall | Georgia | 13267 | 2371 | 69 |
1463590 | 1463590 | 2021-06-28 | Carter | Kentucky | 21043 | 2371 | 35 |
1445338 | 1445338 | 2021-06-22 | Jefferson | Oregon | 41031 | 2371 | 39 |
1446186 | 1446186 | 2021-06-22 | Stevens | Washington | 53065 | 2371 | 28 |
1414958 | 1414958 | 2021-06-13 | Marion | Kentucky | 21155 | 2371 | 38 |
1411713 | 1411713 | 2021-06-12 | Marion | Kentucky | 21155 | 2371 | 38 |
1404271 | 1404271 | 2021-06-10 | Columbia | Arkansas | 5027 | 2371 | 56 |
1401026 | 1401026 | 2021-06-09 | Columbia | Arkansas | 5027 | 2371 | 56 |
1397781 | 1397781 | 2021-06-08 | Columbia | Arkansas | 5027 | 2371 | 56 |
1379449 | 1379449 | 2021-06-02 | Emmet | Michigan | 26047 | 2371 | 42 |
1376204 | 1376204 | 2021-06-01 | Emmet | Michigan | 26047 | 2371 | 42 |
1364299 | 1364299 | 2021-05-28 | Canovanas | Puerto Rico | 72029 | 2371 | |
1316305 | 1316305 | 2021-05-13 | Waynesboro city | Virginia | 51820 | 2371 | 38 |
1305506 | 1305506 | 2021-05-10 | Transylvania | North Carolina | 37175 | 2371 | 32 |
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);