ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
166 rows where cases = 3209 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kentucky 14
- Oklahoma 11
- Louisiana 10
- North Carolina 10
- Georgia 9
- Pennsylvania 9
- Arkansas 8
- Texas 8
- Wisconsin 8
- Iowa 7
- Michigan 6
- Nebraska 5
- West Virginia 5
- Illinois 4
- Minnesota 4
- Mississippi 4
- Missouri 4
- North Dakota 4
- Oregon 4
- South Carolina 4
- Utah 4
- Virginia 4
- Alabama 3
- Florida 3
- Ohio 3
- Puerto Rico 3
- Idaho 2
- New Mexico 2
- Tennessee 2
- California 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2433508 | 2433508 | 2022-04-22 | Potter | Pennsylvania | 42105 | 3209 | 92 |
2430252 | 2430252 | 2022-04-21 | Potter | Pennsylvania | 42105 | 3209 | 92 |
2394351 | 2394351 | 2022-04-10 | Baker | Oregon | 41001 | 3209 | 48 |
2391095 | 2391095 | 2022-04-09 | Baker | Oregon | 41001 | 3209 | 48 |
2391242 | 2391242 | 2022-04-09 | Loiza | Puerto Rico | 72087 | 3209 | |
2387839 | 2387839 | 2022-04-08 | Baker | Oregon | 41001 | 3209 | 48 |
2384584 | 2384584 | 2022-04-07 | Baker | Oregon | 41001 | 3209 | 48 |
2353876 | 2353876 | 2022-03-29 | Butler | Iowa | 19023 | 3209 | 53 |
2350624 | 2350624 | 2022-03-28 | Butler | Iowa | 19023 | 3209 | 53 |
2347371 | 2347371 | 2022-03-27 | Butler | Iowa | 19023 | 3209 | 53 |
2344118 | 2344118 | 2022-03-26 | Butler | Iowa | 19023 | 3209 | 53 |
2340865 | 2340865 | 2022-03-25 | Butler | Iowa | 19023 | 3209 | 53 |
2337612 | 2337612 | 2022-03-24 | Butler | Iowa | 19023 | 3209 | 53 |
2334358 | 2334358 | 2022-03-23 | Butler | Iowa | 19023 | 3209 | 53 |
2335126 | 2335126 | 2022-03-23 | Osage | Missouri | 29151 | 3209 | 44 |
2331872 | 2331872 | 2022-03-22 | Osage | Missouri | 29151 | 3209 | 44 |
2324222 | 2324222 | 2022-03-20 | Dade | Georgia | 13083 | 3209 | 28 |
2320968 | 2320968 | 2022-03-19 | Dade | Georgia | 13083 | 3209 | 28 |
2317714 | 2317714 | 2022-03-18 | Dade | Georgia | 13083 | 3209 | 28 |
2270535 | 2270535 | 2022-03-03 | Mountrail | North Dakota | 38061 | 3209 | 36 |
2268406 | 2268406 | 2022-03-02 | Bayfield | Wisconsin | 55007 | 3209 | 38 |
2237723 | 2237723 | 2022-02-21 | Otoe | Nebraska | 31131 | 3209 | 17 |
2235942 | 2235942 | 2022-02-20 | Price | Wisconsin | 55099 | 3209 | 28 |
2232691 | 2232691 | 2022-02-19 | Price | Wisconsin | 55099 | 3209 | 28 |
2228620 | 2228620 | 2022-02-18 | Naguabo | Puerto Rico | 72103 | 3209 | |
2229440 | 2229440 | 2022-02-18 | Price | Wisconsin | 55099 | 3209 | 28 |
2221764 | 2221764 | 2022-02-16 | McKenzie | North Dakota | 38053 | 3209 | 25 |
2211132 | 2211132 | 2022-02-13 | Madison | Louisiana | 22065 | 3209 | 58 |
2207879 | 2207879 | 2022-02-12 | Madison | Louisiana | 22065 | 3209 | 58 |
2203627 | 2203627 | 2022-02-11 | Marion | Arkansas | 5089 | 3209 | 78 |
2204626 | 2204626 | 2022-02-11 | Madison | Louisiana | 22065 | 3209 | 58 |
2191991 | 2191991 | 2022-02-07 | Gasconade | Missouri | 29073 | 3209 | 93 |
2193337 | 2193337 | 2022-02-07 | Zapata | Texas | 48505 | 3209 | 47 |
2170852 | 2170852 | 2022-01-31 | Buffalo | Wisconsin | 55011 | 3209 | 11 |
2166859 | 2166859 | 2022-01-30 | Bamberg | South Carolina | 45009 | 3209 | 66 |
2163604 | 2163604 | 2022-01-29 | Bamberg | South Carolina | 45009 | 3209 | 66 |
2160349 | 2160349 | 2022-01-28 | Bamberg | South Carolina | 45009 | 3209 | 66 |
2143362 | 2143362 | 2022-01-23 | Gage | Nebraska | 31067 | 3209 | 36 |
2140107 | 2140107 | 2022-01-22 | Gage | Nebraska | 31067 | 3209 | 36 |
2136851 | 2136851 | 2022-01-21 | Gage | Nebraska | 31067 | 3209 | 36 |
2134841 | 2134841 | 2022-01-20 | Buckingham | Virginia | 51029 | 3209 | 41 |
2110185 | 2110185 | 2022-01-13 | Jackson | Kentucky | 21109 | 3209 | 59 |
2096292 | 2096292 | 2022-01-09 | Polk | Arkansas | 5113 | 3209 | 129 |
2093040 | 2093040 | 2022-01-08 | Polk | Arkansas | 5113 | 3209 | 129 |
1923697 | 1923697 | 2021-11-16 | Brooke | West Virginia | 54009 | 3209 | 74 |
1917456 | 1917456 | 2021-11-15 | Ashley | Arkansas | 5003 | 3209 | 50 |
1914206 | 1914206 | 2021-11-14 | Ashley | Arkansas | 5003 | 3209 | 50 |
1910956 | 1910956 | 2021-11-13 | Ashley | Arkansas | 5003 | 3209 | 50 |
1907707 | 1907707 | 2021-11-12 | Ashley | Arkansas | 5003 | 3209 | 50 |
1885010 | 1885010 | 2021-11-05 | Phillips | Arkansas | 5107 | 3209 | 77 |
1880270 | 1880270 | 2021-11-03 | Caswell | North Carolina | 37033 | 3209 | 37 |
1876506 | 1876506 | 2021-11-02 | Wabasha | Minnesota | 27157 | 3209 | 8 |
1787256 | 1787256 | 2021-10-05 | Nicholas | West Virginia | 54067 | 3209 | 35 |
1782321 | 1782321 | 2021-10-04 | Jasper | Mississippi | 28061 | 3209 | 62 |
1778708 | 1778708 | 2021-10-03 | Meade | Kentucky | 21163 | 3209 | 34 |
1774381 | 1774381 | 2021-10-02 | Butler | Alabama | 1013 | 3209 | 91 |
1775458 | 1775458 | 2021-10-02 | Meade | Kentucky | 21163 | 3209 | 34 |
1772208 | 1772208 | 2021-10-01 | Meade | Kentucky | 21163 | 3209 | 34 |
1761028 | 1761028 | 2021-09-27 | Sevier | Utah | 49041 | 3209 | 16 |
1757780 | 1757780 | 2021-09-26 | Sevier | Utah | 49041 | 3209 | 16 |
1754532 | 1754532 | 2021-09-25 | Sevier | Utah | 49041 | 3209 | 16 |
1751284 | 1751284 | 2021-09-24 | Sevier | Utah | 49041 | 3209 | 16 |
1747462 | 1747462 | 2021-09-23 | Warren | Pennsylvania | 42123 | 3209 | 114 |
1737484 | 1737484 | 2021-09-20 | Henry | Ohio | 39069 | 3209 | 68 |
1728933 | 1728933 | 2021-09-18 | Marengo | Alabama | 1091 | 3209 | 81 |
1725557 | 1725557 | 2021-09-16 | Door | Wisconsin | 55029 | 3209 | 38 |
1720626 | 1720626 | 2021-09-15 | Tishomingo | Mississippi | 28141 | 3209 | 87 |
1711331 | 1711331 | 2021-09-12 | Dare | North Carolina | 37055 | 3209 | 11 |
1708084 | 1708084 | 2021-09-11 | Dare | North Carolina | 37055 | 3209 | 11 |
1704837 | 1704837 | 2021-09-10 | Dare | North Carolina | 37055 | 3209 | 11 |
1674235 | 1674235 | 2021-09-01 | Cassia | Idaho | 16031 | 3209 | 28 |
1676018 | 1676018 | 2021-09-01 | Dorado | Puerto Rico | 72051 | 3209 | |
1649805 | 1649805 | 2021-08-24 | Perry | Ohio | 39127 | 3209 | 50 |
1650003 | 1650003 | 2021-08-24 | Tioga | Pennsylvania | 42117 | 3209 | 113 |
1641683 | 1641683 | 2021-08-22 | Peach | Georgia | 13225 | 3209 | 73 |
1638433 | 1638433 | 2021-08-21 | Peach | Georgia | 13225 | 3209 | 73 |
1635183 | 1635183 | 2021-08-20 | Peach | Georgia | 13225 | 3209 | 73 |
1609748 | 1609748 | 2021-08-12 | Harlan | Kentucky | 21095 | 3209 | 93 |
1606924 | 1606924 | 2021-08-11 | Prentiss | Mississippi | 28117 | 3209 | 64 |
1604430 | 1604430 | 2021-08-10 | Woodward | Oklahoma | 40153 | 3209 | 37 |
1601181 | 1601181 | 2021-08-09 | Woodward | Oklahoma | 40153 | 3209 | 37 |
1597933 | 1597933 | 2021-08-08 | Woodward | Oklahoma | 40153 | 3209 | 37 |
1594684 | 1594684 | 2021-08-07 | Woodward | Oklahoma | 40153 | 3209 | 37 |
1591435 | 1591435 | 2021-08-06 | Woodward | Oklahoma | 40153 | 3209 | 37 |
1586440 | 1586440 | 2021-08-05 | Lumpkin | Georgia | 13187 | 3209 | 83 |
1588186 | 1588186 | 2021-08-05 | Woodward | Oklahoma | 40153 | 3209 | 37 |
1584931 | 1584931 | 2021-08-04 | Unknown | Oklahoma | 3209 | 0 | |
1584936 | 1584936 | 2021-08-04 | Woodward | Oklahoma | 40153 | 3209 | 37 |
1579260 | 1579260 | 2021-08-02 | Warren | Virginia | 51187 | 3209 | 61 |
1556622 | 1556622 | 2021-07-26 | Wayne | West Virginia | 54099 | 3209 | 44 |
1541493 | 1541493 | 2021-07-22 | Bell | Kentucky | 21013 | 3209 | 58 |
1542587 | 1542587 | 2021-07-22 | Jackson | Ohio | 39079 | 3209 | 54 |
1531833 | 1531833 | 2021-07-19 | Muhlenberg | Kentucky | 21177 | 3209 | 68 |
1528606 | 1528606 | 2021-07-18 | Taylor | Kentucky | 21217 | 3209 | 53 |
1525359 | 1525359 | 2021-07-17 | Taylor | Kentucky | 21217 | 3209 | 53 |
1522111 | 1522111 | 2021-07-16 | Taylor | Kentucky | 21217 | 3209 | 53 |
1518392 | 1518392 | 2021-07-15 | Iroquois | Illinois | 17075 | 3209 | 70 |
1518863 | 1518863 | 2021-07-15 | Taylor | Kentucky | 21217 | 3209 | 53 |
1520034 | 1520034 | 2021-07-15 | Clarion | Pennsylvania | 42031 | 3209 | 96 |
1437901 | 1437901 | 2021-06-20 | Mecosta | Michigan | 26107 | 3209 | 36 |
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);