ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
116 rows where cases = 4778 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Indiana 10
- Nebraska 10
- Georgia 8
- Tennessee 7
- Virginia 7
- Mississippi 6
- Ohio 6
- Alabama 5
- Illinois 5
- Puerto Rico 4
- Texas 4
- Colorado 3
- Kansas 3
- Maryland 3
- Oregon 3
- Wisconsin 3
- Arkansas 2
- California 2
- Florida 2
- Kentucky 2
- Michigan 2
- Montana 2
- Pennsylvania 2
- South Carolina 2
- Washington 2
- West Virginia 2
- Idaho 1
- Iowa 1
- Maine 1
- Minnesota 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2466048 | 2466048 | 2022-05-02 | Juniata | Pennsylvania | 42067 | 4778 | 176 |
2430288 | 2430288 | 2022-04-21 | Coamo | Puerto Rico | 72043 | 4778 | |
2423764 | 2423764 | 2022-04-19 | Barranquitas | Puerto Rico | 72019 | 4778 | |
2356626 | 2356626 | 2022-03-30 | Teller | Colorado | 8119 | 4778 | 57 |
2284466 | 2284466 | 2022-03-07 | Colonial Heights city | Virginia | 51570 | 4778 | 93 |
2266862 | 2266862 | 2022-03-02 | Big Horn | Montana | 30003 | 4778 | 92 |
2210720 | 2210720 | 2022-02-13 | Jay | Indiana | 18075 | 4778 | 76 |
2207467 | 2207467 | 2022-02-12 | Jay | Indiana | 18075 | 4778 | 76 |
2204214 | 2204214 | 2022-02-11 | Jay | Indiana | 18075 | 4778 | 76 |
2196329 | 2196329 | 2022-02-08 | Union | Tennessee | 47173 | 4778 | 68 |
2193075 | 2193075 | 2022-02-07 | Union | Tennessee | 47173 | 4778 | 68 |
2189821 | 2189821 | 2022-02-06 | Union | Tennessee | 47173 | 4778 | 68 |
2186568 | 2186568 | 2022-02-05 | Union | Tennessee | 47173 | 4778 | 68 |
2183316 | 2183316 | 2022-02-04 | Union | Tennessee | 47173 | 4778 | 68 |
2183820 | 2183820 | 2022-02-04 | Lewis | West Virginia | 54041 | 4778 | 75 |
2177875 | 2177875 | 2022-02-03 | Cook | Georgia | 13075 | 4778 | 66 |
2180064 | 2180064 | 2022-02-03 | Union | Tennessee | 47173 | 4778 | 68 |
2176813 | 2176813 | 2022-02-02 | Union | Tennessee | 47173 | 4778 | 68 |
2168452 | 2168452 | 2022-01-31 | Orange | Indiana | 18117 | 4778 | 90 |
2165397 | 2165397 | 2022-01-30 | Neosho | Kansas | 20133 | 4778 | 58 |
2162142 | 2162142 | 2022-01-29 | Neosho | Kansas | 20133 | 4778 | 58 |
2163954 | 2163954 | 2022-01-29 | Limestone | Texas | 48293 | 4778 | 116 |
2158887 | 2158887 | 2022-01-28 | Neosho | Kansas | 20133 | 4778 | 58 |
2154247 | 2154247 | 2022-01-26 | San Jacinto | Texas | 48407 | 4778 | 88 |
2129866 | 2129866 | 2022-01-19 | Talbot | Maryland | 24041 | 4778 | 71 |
2113572 | 2113572 | 2022-01-14 | Hancock | Maine | 23009 | 4778 | 68 |
2096617 | 2096617 | 2022-01-09 | Monroe | Georgia | 13207 | 4778 | 154 |
2093365 | 2093365 | 2022-01-08 | Monroe | Georgia | 13207 | 4778 | 154 |
2090113 | 2090113 | 2022-01-07 | Monroe | Georgia | 13207 | 4778 | 154 |
2086862 | 2086862 | 2022-01-06 | Monroe | Georgia | 13207 | 4778 | 154 |
2083610 | 2083610 | 2022-01-05 | Monroe | Georgia | 13207 | 4778 | 154 |
2060620 | 2060620 | 2021-12-29 | Delta | Colorado | 8029 | 4778 | 122 |
2055533 | 2055533 | 2021-12-27 | Adams | Nebraska | 31001 | 4778 | 56 |
2052283 | 2052283 | 2021-12-26 | Adams | Nebraska | 31001 | 4778 | 56 |
2049033 | 2049033 | 2021-12-25 | Adams | Nebraska | 31001 | 4778 | 56 |
2045783 | 2045783 | 2021-12-24 | Adams | Nebraska | 31001 | 4778 | 56 |
2042533 | 2042533 | 2021-12-23 | Adams | Nebraska | 31001 | 4778 | 56 |
2032751 | 2032751 | 2021-12-20 | Lake | Montana | 30047 | 4778 | 84 |
2011754 | 2011754 | 2021-12-14 | Johnson | Arkansas | 5071 | 4778 | 61 |
2011269 | 2011269 | 2021-12-13 | Bennington | Vermont | 50003 | 4778 | 39 |
2006563 | 2006563 | 2021-12-12 | Leflore | Mississippi | 28083 | 4778 | 144 |
2003312 | 2003312 | 2021-12-11 | Leflore | Mississippi | 28083 | 4778 | 144 |
2000062 | 2000062 | 2021-12-10 | Leflore | Mississippi | 28083 | 4778 | 144 |
1964328 | 1964328 | 2021-11-29 | Scott | Mississippi | 28123 | 4778 | 99 |
1964947 | 1964947 | 2021-11-29 | Hardin | Ohio | 39065 | 4778 | 99 |
1946662 | 1946662 | 2021-11-24 | Winston | Alabama | 1133 | 4778 | 110 |
1923102 | 1923102 | 2021-11-16 | Meade | South Dakota | 46093 | 4778 | 50 |
1896081 | 1896081 | 2021-11-08 | Tippah | Mississippi | 28139 | 4778 | 81 |
1893038 | 1893038 | 2021-11-07 | Dakota | Nebraska | 31043 | 4778 | 82 |
1889788 | 1889788 | 2021-11-06 | Dakota | Nebraska | 31043 | 4778 | 82 |
1886538 | 1886538 | 2021-11-05 | Dakota | Nebraska | 31043 | 4778 | 82 |
1883289 | 1883289 | 2021-11-04 | Dakota | Nebraska | 31043 | 4778 | 82 |
1880040 | 1880040 | 2021-11-03 | Dakota | Nebraska | 31043 | 4778 | 82 |
1871862 | 1871862 | 2021-11-01 | Clarke | Alabama | 1025 | 4778 | 84 |
1868613 | 1868613 | 2021-10-31 | Clarke | Alabama | 1025 | 4778 | 84 |
1848898 | 1848898 | 2021-10-24 | Smyth | Virginia | 51173 | 4778 | 115 |
1845648 | 1845648 | 2021-10-23 | Smyth | Virginia | 51173 | 4778 | 115 |
1842398 | 1842398 | 2021-10-22 | Smyth | Virginia | 51173 | 4778 | 115 |
1821986 | 1821986 | 2021-10-16 | Ottawa | Ohio | 39123 | 4778 | 86 |
1823060 | 1823060 | 2021-10-16 | Oneida | Wisconsin | 55085 | 4778 | 88 |
1819811 | 1819811 | 2021-10-15 | Oneida | Wisconsin | 55085 | 4778 | 88 |
1816562 | 1816562 | 2021-10-14 | Oneida | Wisconsin | 55085 | 4778 | 88 |
1761211 | 1761211 | 2021-09-27 | Mason | Washington | 53045 | 4778 | 54 |
1739378 | 1739378 | 2021-09-21 | Jasper | Indiana | 18073 | 4778 | 64 |
1732927 | 1732927 | 2021-09-19 | Wabash | Indiana | 18169 | 4778 | 92 |
1729677 | 1729677 | 2021-09-18 | Wabash | Indiana | 18169 | 4778 | 92 |
1731018 | 1731018 | 2021-09-18 | Putnam | Ohio | 39137 | 4778 | 106 |
1726427 | 1726427 | 2021-09-17 | Wabash | Indiana | 18169 | 4778 | 92 |
1723001 | 1723001 | 2021-09-16 | Christian | Illinois | 17021 | 4778 | 98 |
1704112 | 1704112 | 2021-09-10 | Calvert | Maryland | 24009 | 4778 | 91 |
1677579 | 1677579 | 2021-09-02 | Morgan | Illinois | 17137 | 4778 | 117 |
1598980 | 1598980 | 2021-08-09 | Escambia | Alabama | 1053 | 4778 | 83 |
1495654 | 1495654 | 2021-07-08 | Effingham | Illinois | 17049 | 4778 | 85 |
1474437 | 1474437 | 2021-07-01 | Shelby | Ohio | 39149 | 4778 | 95 |
1471191 | 1471191 | 2021-06-30 | Shelby | Ohio | 39149 | 4778 | 95 |
1471455 | 1471455 | 2021-06-30 | Toa Alta | Puerto Rico | 72135 | 4778 | |
1467946 | 1467946 | 2021-06-29 | Shelby | Ohio | 39149 | 4778 | 95 |
1468210 | 1468210 | 2021-06-29 | Toa Alta | Puerto Rico | 72135 | 4778 | |
1468777 | 1468777 | 2021-06-29 | Fauquier | Virginia | 51061 | 4778 | 69 |
1448585 | 1448585 | 2021-06-23 | Klamath | Oregon | 41035 | 4778 | 78 |
1449137 | 1449137 | 2021-06-23 | Nacogdoches | Texas | 48347 | 4778 | 173 |
1445340 | 1445340 | 2021-06-22 | Klamath | Oregon | 41035 | 4778 | 78 |
1438868 | 1438868 | 2021-06-20 | Yamhill | Oregon | 41071 | 4778 | 79 |
1408049 | 1408049 | 2021-06-11 | Macoupin | Illinois | 17117 | 4778 | 117 |
1331033 | 1331033 | 2021-05-18 | Johnson | Missouri | 29101 | 4778 | 54 |
1316848 | 1316848 | 2021-05-14 | Hendry | Florida | 12051 | 4778 | 83 |
1301319 | 1301319 | 2021-05-09 | Henderson | Kentucky | 21101 | 4778 | 75 |
1251045 | 1251045 | 2021-04-23 | Harrison | Texas | 48203 | 4778 | 106 |
1236752 | 1236752 | 2021-04-19 | Bolivar | Mississippi | 28011 | 4778 | 130 |
1231288 | 1231288 | 2021-04-17 | Newberry | South Carolina | 45071 | 4778 | 100 |
1170195 | 1170195 | 2021-03-29 | Cowlitz | Washington | 53015 | 4778 | 75 |
1098719 | 1098719 | 2021-03-07 | Pittsylvania | Virginia | 51143 | 4778 | 70 |
1051641 | 1051641 | 2021-02-21 | Otter Tail | Minnesota | 27111 | 4778 | 70 |
1049890 | 1049890 | 2021-02-20 | Box Elder | Utah | 49003 | 4778 | 42 |
1034295 | 1034295 | 2021-02-16 | Eagle | Colorado | 8037 | 4778 | 20 |
1028833 | 1028833 | 2021-02-14 | Marquette | Michigan | 26103 | 4778 | 56 |
1025587 | 1025587 | 2021-02-13 | Marquette | Michigan | 26103 | 4778 | 56 |
989802 | 989802 | 2021-02-02 | Cecil | Maryland | 24015 | 4778 | 111 |
987639 | 987639 | 2021-02-01 | Indiana | Pennsylvania | 42063 | 4778 | 150 |
969875 | 969875 | 2021-01-27 | Noble | Indiana | 18113 | 4778 | 62 |
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);