ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
189 rows where cases = 2194 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kentucky 12
- Texas 12
- Missouri 11
- Georgia 10
- Indiana 10
- Ohio 10
- Virginia 8
- West Virginia 8
- Wisconsin 8
- Michigan 7
- Minnesota 7
- North Carolina 6
- Arkansas 5
- Louisiana 5
- Mississippi 5
- New Mexico 5
- Pennsylvania 5
- South Carolina 5
- Tennessee 5
- Illinois 4
- Alaska 3
- Iowa 3
- Puerto Rico 3
- Utah 3
- Wyoming 3
- Alabama 2
- Arizona 2
- Colorado 2
- Florida 2
- Idaho 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499986 | 2499986 | 2022-05-13 | Candler | Georgia | 13043 | 2194 | 96 |
2496728 | 2496728 | 2022-05-12 | Candler | Georgia | 13043 | 2194 | 96 |
2493470 | 2493470 | 2022-05-11 | Candler | Georgia | 13043 | 2194 | 96 |
2348108 | 2348108 | 2022-03-27 | Iron | Missouri | 29093 | 2194 | 43 |
2344855 | 2344855 | 2022-03-26 | Iron | Missouri | 29093 | 2194 | 43 |
2341602 | 2341602 | 2022-03-25 | Iron | Missouri | 29093 | 2194 | 43 |
2333447 | 2333447 | 2022-03-22 | Tyler | West Virginia | 54095 | 2194 | 31 |
2225748 | 2225748 | 2022-02-17 | La Salle | Texas | 48283 | 2194 | 42 |
2196821 | 2196821 | 2022-02-08 | Clay | West Virginia | 54015 | 2194 | 32 |
2180273 | 2180273 | 2022-02-03 | Runnels | Texas | 48399 | 2194 | 61 |
2156064 | 2156064 | 2022-01-27 | Rock | Minnesota | 27133 | 2194 | 32 |
2122650 | 2122650 | 2022-01-17 | Screven | Georgia | 13251 | 2194 | 62 |
2103387 | 2103387 | 2022-01-11 | Newton | Indiana | 18111 | 2194 | 61 |
2098466 | 2098466 | 2022-01-09 | Barceloneta | Puerto Rico | 72017 | 2194 | |
2099353 | 2099353 | 2022-01-09 | Big Horn | Wyoming | 56003 | 2194 | 58 |
2096102 | 2096102 | 2022-01-08 | Big Horn | Wyoming | 56003 | 2194 | 58 |
2092850 | 2092850 | 2022-01-07 | Big Horn | Wyoming | 56003 | 2194 | 58 |
2084708 | 2084708 | 2022-01-05 | Ripley | Missouri | 29181 | 2194 | 52 |
2029162 | 2029162 | 2021-12-19 | Missaukee | Michigan | 26113 | 2194 | 45 |
2025911 | 2025911 | 2021-12-18 | Missaukee | Michigan | 26113 | 2194 | 45 |
2022660 | 2022660 | 2021-12-17 | Missaukee | Michigan | 26113 | 2194 | 45 |
2012792 | 2012792 | 2021-12-14 | West Carroll | Louisiana | 22123 | 2194 | 52 |
2008954 | 2008954 | 2021-12-13 | Shoshone | Idaho | 16079 | 2194 | 66 |
1996624 | 1996624 | 2021-12-09 | Gogebic | Michigan | 26053 | 2194 | 57 |
1993373 | 1993373 | 2021-12-08 | Gogebic | Michigan | 26053 | 2194 | 57 |
1987722 | 1987722 | 2021-12-06 | Morgan | Ohio | 39115 | 2194 | 39 |
1969502 | 1969502 | 2021-12-01 | Lee | Arkansas | 5077 | 2194 | 52 |
1972331 | 1972331 | 2021-12-01 | Goochland | Virginia | 51075 | 2194 | 31 |
1966185 | 1966185 | 2021-11-30 | Nome Census Area | Alaska | 2180 | 2194 | 2 |
1967442 | 1967442 | 2021-11-30 | Chippewa | Minnesota | 27023 | 2194 | 42 |
1949931 | 1949931 | 2021-11-25 | Northwest Arctic Borough | Alaska | 2188 | 2194 | 9 |
1946680 | 1946680 | 2021-11-24 | Northwest Arctic Borough | Alaska | 2188 | 2194 | 9 |
1939162 | 1939162 | 2021-11-21 | Potter | Pennsylvania | 42105 | 2194 | 53 |
1927790 | 1927790 | 2021-11-18 | Washington | Illinois | 17189 | 2194 | 36 |
1895257 | 1895257 | 2021-11-08 | Mason | Illinois | 17125 | 2194 | 54 |
1895291 | 1895291 | 2021-11-08 | Wabash | Illinois | 17185 | 2194 | 22 |
1896171 | 1896171 | 2021-11-08 | Osage | Missouri | 29151 | 2194 | 23 |
1892921 | 1892921 | 2021-11-07 | Osage | Missouri | 29151 | 2194 | 23 |
1869676 | 1869676 | 2021-10-31 | Magoffin | Kentucky | 21153 | 2194 | 20 |
1871711 | 1871711 | 2021-10-31 | Grant | West Virginia | 54023 | 2194 | 33 |
1866427 | 1866427 | 2021-10-30 | Magoffin | Kentucky | 21153 | 2194 | 20 |
1863178 | 1863178 | 2021-10-29 | Magoffin | Kentucky | 21153 | 2194 | 20 |
1856989 | 1856989 | 2021-10-27 | Pennington | Minnesota | 27113 | 2194 | 27 |
1850543 | 1850543 | 2021-10-25 | Greene | Mississippi | 28041 | 2194 | 49 |
1849063 | 1849063 | 2021-10-24 | Richland | Wisconsin | 55103 | 2194 | 23 |
1844900 | 1844900 | 2021-10-23 | Fulton | Pennsylvania | 42057 | 2194 | 28 |
1845813 | 1845813 | 2021-10-23 | Richland | Wisconsin | 55103 | 2194 | 23 |
1842563 | 1842563 | 2021-10-22 | Richland | Wisconsin | 55103 | 2194 | 23 |
1815227 | 1815227 | 2021-10-14 | Essex | New York | 36031 | 2194 | 31 |
1789262 | 1789262 | 2021-10-06 | Schoharie | New York | 36095 | 2194 | 21 |
1784648 | 1784648 | 2021-10-05 | Telfair | Georgia | 13271 | 2194 | 65 |
1756725 | 1756725 | 2021-09-26 | Taos | New Mexico | 35055 | 2194 | 60 |
1753477 | 1753477 | 2021-09-25 | Taos | New Mexico | 35055 | 2194 | 60 |
1750229 | 1750229 | 2021-09-24 | Taos | New Mexico | 35055 | 2194 | 60 |
1710186 | 1710186 | 2021-09-12 | Vermillion | Indiana | 18165 | 2194 | 50 |
1706939 | 1706939 | 2021-09-11 | Vermillion | Indiana | 18165 | 2194 | 50 |
1707753 | 1707753 | 2021-09-11 | Ste. Genevieve | Missouri | 29186 | 2194 | 21 |
1703691 | 1703691 | 2021-09-10 | Vermillion | Indiana | 18165 | 2194 | 50 |
1699920 | 1699920 | 2021-09-09 | Elbert | Colorado | 8039 | 2194 | 17 |
1696546 | 1696546 | 2021-09-08 | Howard | Arkansas | 5061 | 2194 | 28 |
1676815 | 1676815 | 2021-09-01 | Adams | Wisconsin | 55001 | 2194 | 21 |
1651694 | 1651694 | 2021-08-25 | Perry | Indiana | 18123 | 2194 | 43 |
1649939 | 1649939 | 2021-08-24 | Union | Oregon | 41061 | 2194 | 30 |
1640317 | 1640317 | 2021-08-21 | Naranjito | Puerto Rico | 72105 | 2194 | |
1633476 | 1633476 | 2021-08-19 | Rolette | North Dakota | 38079 | 2194 | 28 |
1633730 | 1633730 | 2021-08-19 | Juniata | Pennsylvania | 42067 | 2194 | 88 |
1634342 | 1634342 | 2021-08-19 | Bennington | Vermont | 50003 | 2194 | 15 |
1630229 | 1630229 | 2021-08-18 | Rolette | North Dakota | 38079 | 2194 | 28 |
1618030 | 1618030 | 2021-08-14 | Shelby | Texas | 48419 | 2194 | 73 |
1613028 | 1613028 | 2021-08-13 | McCreary | Kentucky | 21147 | 2194 | 34 |
1603771 | 1603771 | 2021-08-10 | Morgan | Missouri | 29141 | 2194 | 49 |
1601896 | 1601896 | 2021-08-09 | Buckingham | Virginia | 51029 | 2194 | 32 |
1589032 | 1589032 | 2021-08-05 | Island | Washington | 53029 | 2194 | 31 |
1589136 | 1589136 | 2021-08-05 | Iowa | Wisconsin | 55049 | 2194 | 14 |
1580525 | 1580525 | 2021-08-03 | Letcher | Kentucky | 21133 | 2194 | 47 |
1577846 | 1577846 | 2021-08-02 | Lake | Montana | 30047 | 2194 | 39 |
1574043 | 1574043 | 2021-08-01 | Meade | Kentucky | 21163 | 2194 | 27 |
1570795 | 1570795 | 2021-07-31 | Meade | Kentucky | 21163 | 2194 | 27 |
1567547 | 1567547 | 2021-07-30 | Meade | Kentucky | 21163 | 2194 | 27 |
1564715 | 1564715 | 2021-07-29 | Andrew | Missouri | 29003 | 2194 | 22 |
1558201 | 1558201 | 2021-07-27 | Stone | Mississippi | 28131 | 2194 | 37 |
1553607 | 1553607 | 2021-07-26 | Drew | Arkansas | 5043 | 2194 | 46 |
1554995 | 1554995 | 2021-07-26 | Clinton | Missouri | 29049 | 2194 | 65 |
1551008 | 1551008 | 2021-07-25 | Sullivan | Indiana | 18153 | 2194 | 43 |
1547761 | 1547761 | 2021-07-24 | Sullivan | Indiana | 18153 | 2194 | 43 |
1544514 | 1544514 | 2021-07-23 | Sullivan | Indiana | 18153 | 2194 | 43 |
1543515 | 1543515 | 2021-07-22 | Radford city | Virginia | 51750 | 2194 | 21 |
1538461 | 1538461 | 2021-07-21 | Talbot | Maryland | 24041 | 2194 | 45 |
1531851 | 1531851 | 2021-07-19 | Simpson | Kentucky | 21213 | 2194 | 43 |
1514135 | 1514135 | 2021-07-13 | Young | Texas | 48503 | 2194 | 45 |
1438526 | 1438526 | 2021-06-20 | Caswell | North Carolina | 37033 | 2194 | 30 |
1435279 | 1435279 | 2021-06-19 | Caswell | North Carolina | 37033 | 2194 | 30 |
1432032 | 1432032 | 2021-06-18 | Caswell | North Carolina | 37033 | 2194 | 30 |
1428786 | 1428786 | 2021-06-17 | Caswell | North Carolina | 37033 | 2194 | 30 |
1407564 | 1407564 | 2021-06-11 | Randolph | Arkansas | 5121 | 2194 | 47 |
1397447 | 1397447 | 2021-06-07 | Salem city | Virginia | 51775 | 2194 | 50 |
1383525 | 1383525 | 2021-06-03 | Hocking | Ohio | 39073 | 2194 | 62 |
1374877 | 1374877 | 2021-05-31 | Langlade | Wisconsin | 55067 | 2194 | 47 |
1354981 | 1354981 | 2021-05-25 | Lampasas | Texas | 48281 | 2194 | 33 |
1348489 | 1348489 | 2021-05-23 | Lampasas | Texas | 48281 | 2194 | 33 |
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);