ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
153 rows where cases = 3956 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Louisiana 15
- South Carolina 11
- Alaska 9
- Florida 9
- Oklahoma 8
- Indiana 7
- Kentucky 7
- Mississippi 7
- Tennessee 7
- Virginia 7
- Illinois 6
- Georgia 5
- Minnesota 5
- Ohio 5
- Wisconsin 5
- New York 4
- Arkansas 3
- New Hampshire 3
- Pennsylvania 3
- Washington 3
- West Virginia 3
- Alabama 2
- Colorado 2
- Idaho 2
- Missouri 2
- Nebraska 2
- Puerto Rico 2
- Utah 2
- California 1
- Delaware 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2449928 | 2449928 | 2022-04-27 | Saluda | South Carolina | 45081 | 3956 | 76 |
2446671 | 2446671 | 2022-04-26 | Saluda | South Carolina | 45081 | 3956 | 76 |
2443416 | 2443416 | 2022-04-25 | Saluda | South Carolina | 45081 | 3956 | 76 |
2440160 | 2440160 | 2022-04-24 | Saluda | South Carolina | 45081 | 3956 | 76 |
2436904 | 2436904 | 2022-04-23 | Saluda | South Carolina | 45081 | 3956 | 76 |
2433648 | 2433648 | 2022-04-22 | Saluda | South Carolina | 45081 | 3956 | 76 |
2430392 | 2430392 | 2022-04-21 | Saluda | South Carolina | 45081 | 3956 | 76 |
2427136 | 2427136 | 2022-04-20 | Saluda | South Carolina | 45081 | 3956 | 76 |
2421494 | 2421494 | 2022-04-19 | Ketchikan Gateway Borough | Alaska | 2130 | 3956 | 17 |
2423880 | 2423880 | 2022-04-19 | Saluda | South Carolina | 45081 | 3956 | 76 |
2418238 | 2418238 | 2022-04-18 | Ketchikan Gateway Borough | Alaska | 2130 | 3956 | 17 |
2414982 | 2414982 | 2022-04-17 | Ketchikan Gateway Borough | Alaska | 2130 | 3956 | 17 |
2411726 | 2411726 | 2022-04-16 | Ketchikan Gateway Borough | Alaska | 2130 | 3956 | 17 |
2408470 | 2408470 | 2022-04-15 | Ketchikan Gateway Borough | Alaska | 2130 | 3956 | 17 |
2405214 | 2405214 | 2022-04-14 | Ketchikan Gateway Borough | Alaska | 2130 | 3956 | 17 |
2401959 | 2401959 | 2022-04-13 | Ketchikan Gateway Borough | Alaska | 2130 | 3956 | 17 |
2379248 | 2379248 | 2022-04-06 | Madison | Arkansas | 5087 | 3956 | 61 |
2336715 | 2336715 | 2022-03-23 | Burnett | Wisconsin | 55013 | 3956 | 43 |
2327514 | 2327514 | 2022-03-21 | Jeff Davis | Georgia | 13161 | 3956 | 70 |
2294165 | 2294165 | 2022-03-10 | San Juan | Utah | 49037 | 3956 | 47 |
2290913 | 2290913 | 2022-03-09 | San Juan | Utah | 49037 | 3956 | 47 |
2284749 | 2284749 | 2022-03-07 | Lincoln | Wyoming | 56023 | 3956 | 29 |
2268265 | 2268265 | 2022-03-02 | Nottoway | Virginia | 51135 | 3956 | 83 |
2263123 | 2263123 | 2022-03-01 | Bienville | Louisiana | 22013 | 3956 | 108 |
2259872 | 2259872 | 2022-02-28 | Bienville | Louisiana | 22013 | 3956 | 108 |
2256621 | 2256621 | 2022-02-27 | Bienville | Louisiana | 22013 | 3956 | 108 |
2253370 | 2253370 | 2022-02-26 | Bienville | Louisiana | 22013 | 3956 | 108 |
2250119 | 2250119 | 2022-02-25 | Bienville | Louisiana | 22013 | 3956 | 108 |
2243133 | 2243133 | 2022-02-23 | Jo Daviess | Illinois | 17085 | 3956 | 38 |
2243185 | 2243185 | 2022-02-23 | Warren | Illinois | 17187 | 3956 | 82 |
2193792 | 2193792 | 2022-02-08 | North Slope Borough | Alaska | 2185 | 3956 | 10 |
2190539 | 2190539 | 2022-02-07 | North Slope Borough | Alaska | 2185 | 3956 | 10 |
2179859 | 2179859 | 2022-02-03 | Yauco | Puerto Rico | 72153 | 3956 | |
2180599 | 2180599 | 2022-02-03 | Wetzel | West Virginia | 54103 | 3956 | 71 |
2175344 | 2175344 | 2022-02-02 | LaSalle | Louisiana | 22059 | 3956 | 49 |
2176194 | 2176194 | 2022-02-02 | Warren | North Carolina | 37185 | 3956 | 38 |
2154186 | 2154186 | 2022-01-26 | Lavaca | Texas | 48285 | 3956 | 102 |
2146263 | 2146263 | 2022-01-24 | Fillmore | Minnesota | 27045 | 3956 | 20 |
2123272 | 2123272 | 2022-01-17 | Concordia | Louisiana | 22029 | 3956 | 80 |
2123582 | 2123582 | 2022-01-17 | Jasper | Mississippi | 28061 | 3956 | 66 |
2120020 | 2120020 | 2022-01-16 | Concordia | Louisiana | 22029 | 3956 | 80 |
2120330 | 2120330 | 2022-01-16 | Jasper | Mississippi | 28061 | 3956 | 66 |
2116768 | 2116768 | 2022-01-15 | Concordia | Louisiana | 22029 | 3956 | 80 |
2117078 | 2117078 | 2022-01-15 | Jasper | Mississippi | 28061 | 3956 | 66 |
2113517 | 2113517 | 2022-01-14 | Concordia | Louisiana | 22029 | 3956 | 80 |
2113827 | 2113827 | 2022-01-14 | Jasper | Mississippi | 28061 | 3956 | 66 |
2028983 | 2028983 | 2021-12-19 | Woodford | Kentucky | 21239 | 3956 | 34 |
2025732 | 2025732 | 2021-12-18 | Woodford | Kentucky | 21239 | 3956 | 34 |
2022481 | 2022481 | 2021-12-17 | Woodford | Kentucky | 21239 | 3956 | 34 |
2013760 | 2013760 | 2021-12-14 | Wyandot | Ohio | 39175 | 3956 | 78 |
2008802 | 2008802 | 2021-12-13 | Fannin | Georgia | 13111 | 3956 | 115 |
2009361 | 2009361 | 2021-12-13 | Anderson | Kentucky | 21005 | 3956 | 56 |
1988196 | 1988196 | 2021-12-06 | Morgan | Tennessee | 47129 | 3956 | 51 |
1962973 | 1962973 | 2021-11-29 | Cleburne | Arkansas | 5023 | 3956 | 95 |
1937418 | 1937418 | 2021-11-21 | Cassia | Idaho | 16031 | 3956 | 42 |
1934168 | 1934168 | 2021-11-20 | Cassia | Idaho | 16031 | 3956 | 42 |
1870272 | 1870272 | 2021-10-31 | Adams | Nebraska | 31001 | 3956 | 54 |
1816292 | 1816292 | 2021-10-14 | Accomack | Virginia | 51001 | 3956 | 73 |
1758924 | 1758924 | 2021-09-27 | Wells | Indiana | 18179 | 3956 | 87 |
1757939 | 1757939 | 2021-09-26 | Wythe | Virginia | 51197 | 3956 | 87 |
1757945 | 1757945 | 2021-09-26 | Clallam | Washington | 53009 | 3956 | 43 |
1753537 | 1753537 | 2021-09-25 | Wyoming | New York | 36121 | 3956 | 54 |
1754691 | 1754691 | 2021-09-25 | Wythe | Virginia | 51197 | 3956 | 87 |
1754697 | 1754697 | 2021-09-25 | Clallam | Washington | 53009 | 3956 | 43 |
1751443 | 1751443 | 2021-09-24 | Wythe | Virginia | 51197 | 3956 | 87 |
1751449 | 1751449 | 2021-09-24 | Clallam | Washington | 53009 | 3956 | 43 |
1743222 | 1743222 | 2021-09-22 | Carlton | Minnesota | 27017 | 3956 | 59 |
1732913 | 1732913 | 2021-09-19 | Scott | Indiana | 18143 | 3956 | 65 |
1729663 | 1729663 | 2021-09-18 | Scott | Indiana | 18143 | 3956 | 65 |
1726413 | 1726413 | 2021-09-17 | Scott | Indiana | 18143 | 3956 | 65 |
1705223 | 1705223 | 2021-09-10 | Snyder | Pennsylvania | 42109 | 3956 | 88 |
1689808 | 1689808 | 2021-09-05 | Wayne | West Virginia | 54099 | 3956 | 48 |
1685264 | 1685264 | 2021-09-04 | Chenango | New York | 36017 | 3956 | 84 |
1678393 | 1678393 | 2021-09-02 | Tate | Mississippi | 28137 | 3956 | 93 |
1674145 | 1674145 | 2021-09-01 | Lumpkin | Georgia | 13187 | 3956 | 86 |
1647540 | 1647540 | 2021-08-23 | Fayette | West Virginia | 54019 | 3956 | 86 |
1628135 | 1628135 | 2021-08-17 | Oneida | Wisconsin | 55085 | 3956 | 81 |
1619584 | 1619584 | 2021-08-15 | East Feliciana | Louisiana | 22037 | 3956 | 124 |
1620981 | 1620981 | 2021-08-15 | Carroll | Tennessee | 47017 | 3956 | 84 |
1616336 | 1616336 | 2021-08-14 | East Feliciana | Louisiana | 22037 | 3956 | 124 |
1617733 | 1617733 | 2021-08-14 | Carroll | Tennessee | 47017 | 3956 | 84 |
1613087 | 1613087 | 2021-08-13 | East Feliciana | Louisiana | 22037 | 3956 | 124 |
1614485 | 1614485 | 2021-08-13 | Carroll | Tennessee | 47017 | 3956 | 84 |
1586345 | 1586345 | 2021-08-05 | Wakulla | Florida | 12129 | 3956 | 56 |
1583095 | 1583095 | 2021-08-04 | Wakulla | Florida | 12129 | 3956 | 56 |
1579845 | 1579845 | 2021-08-03 | Wakulla | Florida | 12129 | 3956 | 56 |
1581533 | 1581533 | 2021-08-03 | Clinton | Ohio | 39027 | 3956 | 67 |
1576597 | 1576597 | 2021-08-02 | Wakulla | Florida | 12129 | 3956 | 56 |
1573349 | 1573349 | 2021-08-01 | Wakulla | Florida | 12129 | 3956 | 56 |
1574744 | 1574744 | 2021-08-01 | Cheshire | New Hampshire | 33005 | 3956 | 35 |
1570101 | 1570101 | 2021-07-31 | Wakulla | Florida | 12129 | 3956 | 56 |
1571496 | 1571496 | 2021-07-31 | Cheshire | New Hampshire | 33005 | 3956 | 35 |
1566853 | 1566853 | 2021-07-30 | Wakulla | Florida | 12129 | 3956 | 56 |
1568248 | 1568248 | 2021-07-30 | Cheshire | New Hampshire | 33005 | 3956 | 35 |
1565784 | 1565784 | 2021-07-29 | Henderson | Tennessee | 47077 | 3956 | 79 |
1562098 | 1562098 | 2021-07-28 | Preble | Ohio | 39135 | 3956 | 107 |
1536197 | 1536197 | 2021-07-20 | Okmulgee | Oklahoma | 40111 | 3956 | 85 |
1532949 | 1532949 | 2021-07-19 | Okmulgee | Oklahoma | 40111 | 3956 | 85 |
1529702 | 1529702 | 2021-07-18 | Okmulgee | Oklahoma | 40111 | 3956 | 85 |
1526455 | 1526455 | 2021-07-17 | Okmulgee | Oklahoma | 40111 | 3956 | 85 |
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);