ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
197 rows where cases = 2276 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kentucky 20
- Georgia 16
- Missouri 13
- Puerto Rico 13
- North Carolina 11
- Minnesota 10
- Texas 9
- Louisiana 8
- Illinois 7
- Indiana 7
- Michigan 7
- Virginia 7
- Arkansas 6
- California 6
- Tennessee 6
- Ohio 5
- West Virginia 5
- Mississippi 4
- New Mexico 4
- Alabama 3
- Florida 3
- Idaho 3
- New York 3
- Washington 3
- Wisconsin 3
- Kansas 2
- Nebraska 2
- Oregon 2
- South Carolina 2
- Hawaii 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2498031 | 2498031 | 2022-05-12 | Hamilton | Nebraska | 31081 | 2276 | 24 |
2494773 | 2494773 | 2022-05-11 | Hamilton | Nebraska | 31081 | 2276 | 24 |
2446155 | 2446155 | 2022-04-26 | Graham | North Carolina | 37075 | 2276 | 30 |
2442900 | 2442900 | 2022-04-25 | Graham | North Carolina | 37075 | 2276 | 30 |
2439644 | 2439644 | 2022-04-24 | Graham | North Carolina | 37075 | 2276 | 30 |
2436388 | 2436388 | 2022-04-23 | Graham | North Carolina | 37075 | 2276 | 30 |
2433132 | 2433132 | 2022-04-22 | Graham | North Carolina | 37075 | 2276 | 30 |
2429876 | 2429876 | 2022-04-21 | Graham | North Carolina | 37075 | 2276 | 30 |
2426620 | 2426620 | 2022-04-20 | Graham | North Carolina | 37075 | 2276 | 30 |
2401025 | 2401025 | 2022-04-12 | Sabana Grande | Puerto Rico | 72121 | 2276 | |
2397770 | 2397770 | 2022-04-11 | Sabana Grande | Puerto Rico | 72121 | 2276 | |
2297942 | 2297942 | 2022-03-12 | Scott | Arkansas | 5127 | 2276 | 38 |
2284321 | 2284321 | 2022-03-07 | Parmer | Texas | 48369 | 2276 | 52 |
2279548 | 2279548 | 2022-03-06 | Luce | Michigan | 26095 | 2276 | 10 |
2276295 | 2276295 | 2022-03-05 | Luce | Michigan | 26095 | 2276 | 10 |
2273042 | 2273042 | 2022-03-04 | Luce | Michigan | 26095 | 2276 | 10 |
2245597 | 2245597 | 2022-02-23 | Clay | West Virginia | 54015 | 2276 | 36 |
2239243 | 2239243 | 2022-02-22 | Bullock | Alabama | 1011 | 2276 | 49 |
2163555 | 2163555 | 2022-01-29 | Lajas | Puerto Rico | 72079 | 2276 | |
2156085 | 2156085 | 2022-01-27 | Yellow Medicine | Minnesota | 27173 | 2276 | 26 |
2150566 | 2150566 | 2022-01-25 | Santa Isabel | Puerto Rico | 72133 | 2276 | |
2131820 | 2131820 | 2022-01-19 | Forest | Wisconsin | 55041 | 2276 | 47 |
2122733 | 2122733 | 2022-01-17 | Shoshone | Idaho | 16079 | 2276 | 70 |
2123547 | 2123547 | 2022-01-17 | Watonwan | Minnesota | 27165 | 2276 | 22 |
2119481 | 2119481 | 2022-01-16 | Shoshone | Idaho | 16079 | 2276 | 70 |
2120295 | 2120295 | 2022-01-16 | Watonwan | Minnesota | 27165 | 2276 | 22 |
2116229 | 2116229 | 2022-01-15 | Shoshone | Idaho | 16079 | 2276 | 70 |
2117043 | 2117043 | 2022-01-15 | Watonwan | Minnesota | 27165 | 2276 | 22 |
2113792 | 2113792 | 2022-01-14 | Watonwan | Minnesota | 27165 | 2276 | 22 |
2105032 | 2105032 | 2022-01-11 | Utuado | Puerto Rico | 72141 | 2276 | |
2100462 | 2100462 | 2022-01-10 | Metcalfe | Kentucky | 21169 | 2276 | 53 |
2089331 | 2089331 | 2022-01-06 | Dickenson | Virginia | 51051 | 2276 | 38 |
2084196 | 2084196 | 2022-01-05 | Martin | Kentucky | 21159 | 2276 | 39 |
2062352 | 2062352 | 2021-12-29 | Swain | North Carolina | 37173 | 2276 | 29 |
2016825 | 2016825 | 2021-12-15 | Mitchell | North Carolina | 37121 | 2276 | 24 |
2016982 | 2016982 | 2021-12-15 | Noble | Ohio | 39121 | 2276 | 49 |
2005605 | 2005605 | 2021-12-12 | Oglethorpe | Georgia | 13221 | 2276 | 43 |
2002354 | 2002354 | 2021-12-11 | Oglethorpe | Georgia | 13221 | 2276 | 43 |
1999104 | 1999104 | 2021-12-10 | Oglethorpe | Georgia | 13221 | 2276 | 43 |
1987445 | 1987445 | 2021-12-06 | Socorro | New Mexico | 35053 | 2276 | 65 |
1966764 | 1966764 | 2021-11-30 | Mason | Illinois | 17125 | 2276 | 54 |
1960667 | 1960667 | 2021-11-28 | Leslie | Kentucky | 21131 | 2276 | 30 |
1957416 | 1957416 | 2021-11-27 | Leslie | Kentucky | 21131 | 2276 | 30 |
1954165 | 1954165 | 2021-11-26 | Leslie | Kentucky | 21131 | 2276 | 30 |
1950914 | 1950914 | 2021-11-25 | Leslie | Kentucky | 21131 | 2276 | 30 |
1947663 | 1947663 | 2021-11-24 | Leslie | Kentucky | 21131 | 2276 | 30 |
1927713 | 1927713 | 2021-11-18 | De Witt | Illinois | 17039 | 2276 | 37 |
1928652 | 1928652 | 2021-11-18 | Macon | Missouri | 29121 | 2276 | 34 |
1929569 | 1929569 | 2021-11-18 | Clay | South Dakota | 46027 | 2276 | 17 |
1905879 | 1905879 | 2021-11-11 | Gasconade | Missouri | 29073 | 2276 | 51 |
1902630 | 1902630 | 2021-11-10 | Gasconade | Missouri | 29073 | 2276 | 51 |
1898880 | 1898880 | 2021-11-09 | Estill | Kentucky | 21065 | 2276 | 12 |
1883124 | 1883124 | 2021-11-04 | Dallas | Missouri | 29059 | 2276 | 42 |
1879875 | 1879875 | 2021-11-03 | Dallas | Missouri | 29059 | 2276 | 42 |
1874790 | 1874790 | 2021-11-01 | Bristol city | Virginia | 51520 | 2276 | 47 |
1865247 | 1865247 | 2021-10-29 | Taylor | West Virginia | 54091 | 2276 | 38 |
1839273 | 1839273 | 2021-10-21 | Crawford | Wisconsin | 55023 | 2276 | 22 |
1834891 | 1834891 | 2021-10-20 | McKenzie | North Dakota | 38053 | 2276 | 20 |
1830024 | 1830024 | 2021-10-19 | Charlton | Georgia | 13049 | 2276 | 54 |
1831472 | 1831472 | 2021-10-19 | Essex | New York | 36031 | 2276 | 31 |
1831985 | 1831985 | 2021-10-19 | Las Piedras | Puerto Rico | 72085 | 2276 | |
1828251 | 1828251 | 2021-10-18 | Schoharie | New York | 36095 | 2276 | 21 |
1828736 | 1828736 | 2021-10-18 | Las Piedras | Puerto Rico | 72085 | 2276 | |
1825487 | 1825487 | 2021-10-17 | Las Piedras | Puerto Rico | 72085 | 2276 | |
1822238 | 1822238 | 2021-10-16 | Las Piedras | Puerto Rico | 72085 | 2276 | |
1818989 | 1818989 | 2021-10-15 | Las Piedras | Puerto Rico | 72085 | 2276 | |
1814037 | 1814037 | 2021-10-14 | Moultrie | Illinois | 17139 | 2276 | 41 |
1814720 | 1814720 | 2021-10-14 | Houston | Minnesota | 27055 | 2276 | 17 |
1813127 | 1813127 | 2021-10-13 | New Kent | Virginia | 51127 | 2276 | 22 |
1800233 | 1800233 | 2021-10-09 | Hardy | West Virginia | 54031 | 2276 | 28 |
1795430 | 1795430 | 2021-10-08 | Madison | Missouri | 29123 | 2276 | 24 |
1793518 | 1793518 | 2021-10-07 | San Juan | Utah | 49037 | 2276 | 40 |
1768278 | 1768278 | 2021-09-30 | Bleckley | Georgia | 13023 | 2276 | 65 |
1735529 | 1735529 | 2021-09-20 | Howard | Arkansas | 5061 | 2276 | 29 |
1737227 | 1737227 | 2021-09-20 | San Miguel | New Mexico | 35047 | 2276 | 19 |
1732279 | 1732279 | 2021-09-19 | Howard | Arkansas | 5061 | 2276 | 29 |
1733252 | 1733252 | 2021-09-19 | Union | Kentucky | 21225 | 2276 | 22 |
1730002 | 1730002 | 2021-09-18 | Union | Kentucky | 21225 | 2276 | 22 |
1726752 | 1726752 | 2021-09-17 | Union | Kentucky | 21225 | 2276 | 22 |
1720181 | 1720181 | 2021-09-15 | Garrard | Kentucky | 21079 | 2276 | 39 |
1718270 | 1718270 | 2021-09-14 | Manati | Puerto Rico | 72091 | 2276 | |
1700047 | 1700047 | 2021-09-09 | Bacon | Georgia | 13005 | 2276 | 47 |
1696269 | 1696269 | 2021-09-07 | Hampshire | West Virginia | 54027 | 2276 | 37 |
1681738 | 1681738 | 2021-09-03 | Pike | Missouri | 29163 | 2276 | 31 |
1677872 | 1677872 | 2021-09-02 | Neosho | Kansas | 20133 | 2276 | 43 |
1678738 | 1678738 | 2021-09-02 | Lincoln | New Mexico | 35027 | 2276 | 22 |
1674625 | 1674625 | 2021-09-01 | Neosho | Kansas | 20133 | 2276 | 43 |
1649630 | 1649630 | 2021-08-24 | Hertford | North Carolina | 37091 | 2276 | 65 |
1639545 | 1639545 | 2021-08-21 | Wright | Missouri | 29229 | 2276 | 41 |
1633001 | 1633001 | 2021-08-19 | Morgan | Missouri | 29141 | 2276 | 49 |
1607549 | 1607549 | 2021-08-11 | Hocking | Ohio | 39073 | 2276 | 63 |
1600020 | 1600020 | 2021-08-09 | Letcher | Kentucky | 21133 | 2276 | 47 |
1597262 | 1597262 | 2021-08-08 | Livingston | Missouri | 29117 | 2276 | 51 |
1583471 | 1583471 | 2021-08-04 | Owen | Indiana | 18119 | 2276 | 61 |
1558955 | 1558955 | 2021-07-27 | Coos | Oregon | 41011 | 2276 | 39 |
1540677 | 1540677 | 2021-07-22 | Calaveras | California | 6009 | 2276 | 58 |
1541606 | 1541606 | 2021-07-22 | Woodford | Kentucky | 21239 | 2276 | 22 |
1533509 | 1533509 | 2021-07-19 | Lampasas | Texas | 48281 | 2276 | 33 |
1533859 | 1533859 | 2021-07-19 | Jackson | West Virginia | 54035 | 2276 | 61 |
1526881 | 1526881 | 2021-07-17 | Austin | Texas | 48015 | 2276 | 37 |
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);