ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
173 rows where cases = 3176 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Mississippi 24
- Georgia 20
- Kentucky 14
- Arkansas 12
- Oklahoma 9
- Ohio 7
- Louisiana 6
- Virginia 6
- Kansas 5
- Michigan 5
- Minnesota 5
- Tennessee 5
- Texas 5
- Colorado 4
- Missouri 4
- West Virginia 4
- Wisconsin 4
- Alabama 3
- Illinois 3
- Indiana 3
- Nevada 3
- South Carolina 3
- South Dakota 3
- California 2
- Pennsylvania 2
- Washington 2
- Florida 1
- Idaho 1
- Maine 1
- Maryland 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2473405 | 2473405 | 2022-05-04 | Roane | West Virginia | 54087 | 3176 | 36 |
2438705 | 2438705 | 2022-04-24 | Bath | Kentucky | 21011 | 3176 | 44 |
2435449 | 2435449 | 2022-04-23 | Bath | Kentucky | 21011 | 3176 | 44 |
2432193 | 2432193 | 2022-04-22 | Bath | Kentucky | 21011 | 3176 | 44 |
2428937 | 2428937 | 2022-04-21 | Bath | Kentucky | 21011 | 3176 | 44 |
2425681 | 2425681 | 2022-04-20 | Bath | Kentucky | 21011 | 3176 | 44 |
2422425 | 2422425 | 2022-04-19 | Bath | Kentucky | 21011 | 3176 | 44 |
2419169 | 2419169 | 2022-04-18 | Bath | Kentucky | 21011 | 3176 | 44 |
2302504 | 2302504 | 2022-03-13 | Tallahatchie | Mississippi | 28135 | 3176 | 60 |
2299252 | 2299252 | 2022-03-12 | Tallahatchie | Mississippi | 28135 | 3176 | 60 |
2296000 | 2296000 | 2022-03-11 | Tallahatchie | Mississippi | 28135 | 3176 | 60 |
2292748 | 2292748 | 2022-03-10 | Tallahatchie | Mississippi | 28135 | 3176 | 60 |
2289496 | 2289496 | 2022-03-09 | Tallahatchie | Mississippi | 28135 | 3176 | 60 |
2286245 | 2286245 | 2022-03-08 | Tallahatchie | Mississippi | 28135 | 3176 | 60 |
2282993 | 2282993 | 2022-03-07 | Tallahatchie | Mississippi | 28135 | 3176 | 60 |
2279740 | 2279740 | 2022-03-06 | Tallahatchie | Mississippi | 28135 | 3176 | 60 |
2276487 | 2276487 | 2022-03-05 | Tallahatchie | Mississippi | 28135 | 3176 | 60 |
2273234 | 2273234 | 2022-03-04 | Tallahatchie | Mississippi | 28135 | 3176 | 60 |
2269982 | 2269982 | 2022-03-03 | Tallahatchie | Mississippi | 28135 | 3176 | 60 |
2266682 | 2266682 | 2022-03-02 | Greene | Mississippi | 28041 | 3176 | 56 |
2266729 | 2266729 | 2022-03-02 | Tallahatchie | Mississippi | 28135 | 3176 | 60 |
2247971 | 2247971 | 2022-02-24 | Baker | Oregon | 41001 | 3176 | 46 |
2242275 | 2242275 | 2022-02-22 | Rockbridge | Virginia | 51163 | 3176 | 74 |
2235482 | 2235482 | 2022-02-20 | Jackson | Texas | 48239 | 3176 | 56 |
2216632 | 2216632 | 2022-02-15 | Little River | Arkansas | 5081 | 3176 | 86 |
2216287 | 2216287 | 2022-02-14 | Westmoreland | Virginia | 51193 | 3176 | 43 |
2200718 | 2200718 | 2022-02-10 | Oglethorpe | Georgia | 13221 | 3176 | 48 |
2156124 | 2156124 | 2022-01-27 | Lawrence | Mississippi | 28077 | 3176 | 45 |
2148745 | 2148745 | 2022-01-25 | Gem | Idaho | 16045 | 3176 | 73 |
2131157 | 2131157 | 2022-01-19 | Oglala Lakota | South Dakota | 46102 | 3176 | 55 |
2118904 | 2118904 | 2022-01-16 | Crenshaw | Alabama | 1041 | 3176 | 80 |
2110520 | 2110520 | 2022-01-13 | Redwood | Minnesota | 27127 | 3176 | 50 |
2097552 | 2097552 | 2022-01-09 | Clarke | Mississippi | 28023 | 3176 | 96 |
2094300 | 2094300 | 2022-01-08 | Clarke | Mississippi | 28023 | 3176 | 96 |
2091048 | 2091048 | 2022-01-07 | Clarke | Mississippi | 28023 | 3176 | 96 |
2083364 | 2083364 | 2022-01-05 | Alamosa | Colorado | 8003 | 3176 | 56 |
2066990 | 2066990 | 2021-12-31 | Cross | Arkansas | 5037 | 3176 | 71 |
2056467 | 2056467 | 2021-12-27 | Sequatchie | Tennessee | 47153 | 3176 | 58 |
1974026 | 1974026 | 2021-12-02 | Chickasaw | Mississippi | 28017 | 3176 | 67 |
1960030 | 1960030 | 2021-11-28 | Crisp | Georgia | 13081 | 3176 | 114 |
1956779 | 1956779 | 2021-11-27 | Crisp | Georgia | 13081 | 3176 | 114 |
1953528 | 1953528 | 2021-11-26 | Crisp | Georgia | 13081 | 3176 | 114 |
1950277 | 1950277 | 2021-11-25 | Crisp | Georgia | 13081 | 3176 | 114 |
1947026 | 1947026 | 2021-11-24 | Crisp | Georgia | 13081 | 3176 | 114 |
1928588 | 1928588 | 2021-11-18 | Winston | Mississippi | 28159 | 3176 | 92 |
1894721 | 1894721 | 2021-11-08 | Conway | Arkansas | 5029 | 3176 | 45 |
1891471 | 1891471 | 2021-11-07 | Conway | Arkansas | 5029 | 3176 | 45 |
1891640 | 1891640 | 2021-11-07 | Pitkin | Colorado | 8097 | 3176 | 5 |
1893418 | 1893418 | 2021-11-07 | Carroll | Ohio | 39019 | 3176 | 69 |
1888221 | 1888221 | 2021-11-06 | Conway | Arkansas | 5029 | 3176 | 44 |
1888390 | 1888390 | 2021-11-06 | Pitkin | Colorado | 8097 | 3176 | 5 |
1885140 | 1885140 | 2021-11-05 | Pitkin | Colorado | 8097 | 3176 | 5 |
1884212 | 1884212 | 2021-11-04 | Union | Tennessee | 47173 | 3176 | 48 |
1873428 | 1873428 | 2021-11-01 | Perry | Missouri | 29157 | 3176 | 33 |
1846965 | 1846965 | 2021-10-24 | Simpson | Kentucky | 21213 | 3176 | 53 |
1843715 | 1843715 | 2021-10-23 | Simpson | Kentucky | 21213 | 3176 | 53 |
1840465 | 1840465 | 2021-10-22 | Simpson | Kentucky | 21213 | 3176 | 53 |
1807310 | 1807310 | 2021-10-12 | Elbert | Georgia | 13105 | 3176 | 83 |
1808004 | 1808004 | 2021-10-12 | Concordia | Louisiana | 22029 | 3176 | 76 |
1804158 | 1804158 | 2021-10-11 | Washington | Georgia | 13303 | 3176 | 112 |
1800909 | 1800909 | 2021-10-10 | Washington | Georgia | 13303 | 3176 | 112 |
1797660 | 1797660 | 2021-10-09 | Washington | Georgia | 13303 | 3176 | 112 |
1794411 | 1794411 | 2021-10-08 | Washington | Georgia | 13303 | 3176 | 112 |
1787867 | 1787867 | 2021-10-06 | Morgan | Georgia | 13211 | 3176 | 39 |
1780806 | 1780806 | 2021-10-03 | Jackson | Wisconsin | 55053 | 3176 | 31 |
1777508 | 1777508 | 2021-10-02 | Nicholas | West Virginia | 54067 | 3176 | 34 |
1777556 | 1777556 | 2021-10-02 | Jackson | Wisconsin | 55053 | 3176 | 31 |
1774306 | 1774306 | 2021-10-01 | Jackson | Wisconsin | 55053 | 3176 | 31 |
1765748 | 1765748 | 2021-09-29 | Woodford | Kentucky | 21239 | 3176 | 26 |
1763476 | 1763476 | 2021-09-28 | Hocking | Ohio | 39073 | 3176 | 70 |
1756188 | 1756188 | 2021-09-26 | Oceana | Michigan | 26127 | 3176 | 63 |
1752940 | 1752940 | 2021-09-25 | Oceana | Michigan | 26127 | 3176 | 63 |
1749692 | 1749692 | 2021-09-24 | Oceana | Michigan | 26127 | 3176 | 63 |
1735862 | 1735862 | 2021-09-20 | Jones | Georgia | 13169 | 3176 | 74 |
1727734 | 1727734 | 2021-09-17 | Henry | Ohio | 39069 | 3176 | 68 |
1698998 | 1698998 | 2021-09-08 | Morgan | Tennessee | 47129 | 3176 | 41 |
1677835 | 1677835 | 2021-09-02 | Franklin | Kansas | 20059 | 3176 | 50 |
1674588 | 1674588 | 2021-09-01 | Franklin | Kansas | 20059 | 3176 | 50 |
1668647 | 1668647 | 2021-08-30 | Stone | Mississippi | 28131 | 3176 | 46 |
1654625 | 1654625 | 2021-08-26 | Franklin | Georgia | 13119 | 3176 | 60 |
1655268 | 1655268 | 2021-08-26 | Ohio | Kentucky | 21183 | 3176 | 58 |
1652514 | 1652514 | 2021-08-25 | Randolph | Missouri | 29175 | 3176 | 34 |
1653047 | 1653047 | 2021-08-25 | Morrow | Ohio | 39117 | 3176 | 47 |
1653698 | 1653698 | 2021-08-25 | Limestone | Texas | 48293 | 3176 | 85 |
1645114 | 1645114 | 2021-08-23 | Saline | Illinois | 17165 | 3176 | 74 |
1639152 | 1639152 | 2021-08-21 | Queen Anne's | Maryland | 24035 | 3176 | 56 |
1626272 | 1626272 | 2021-08-17 | Brown | Minnesota | 27015 | 3176 | 40 |
1624014 | 1624014 | 2021-08-16 | Tioga | Pennsylvania | 42117 | 3176 | 113 |
1566268 | 1566268 | 2021-07-29 | Warren | Virginia | 51187 | 3176 | 61 |
1540526 | 1540526 | 2021-07-22 | Lawrence | Alabama | 1079 | 3176 | 101 |
1539972 | 1539972 | 2021-07-21 | Hockley | Texas | 48219 | 3176 | 105 |
1526149 | 1526149 | 2021-07-17 | Washington | New York | 36115 | 3176 | 55 |
1503022 | 1503022 | 2021-07-10 | Barry | Missouri | 29009 | 3176 | 47 |
1448774 | 1448774 | 2021-06-23 | Edgefield | South Carolina | 45037 | 3176 | 43 |
1404047 | 1404047 | 2021-06-09 | Wayne | West Virginia | 54099 | 3176 | 41 |
1395589 | 1395589 | 2021-06-07 | Vernon | Louisiana | 22115 | 3176 | 104 |
1381837 | 1381837 | 2021-06-03 | Butts | Georgia | 13035 | 3176 | 88 |
1357741 | 1357741 | 2021-05-26 | Clarion | Pennsylvania | 42031 | 3176 | 92 |
1353692 | 1353692 | 2021-05-25 | Scott | Mississippi | 28123 | 3176 | 74 |
1336147 | 1336147 | 2021-05-20 | Poinsett | Arkansas | 5111 | 3176 | 77 |
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);