ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
143 rows where cases = 4066 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Oklahoma 21
- Illinois 14
- Tennessee 11
- Indiana 9
- Virginia 8
- Idaho 6
- Missouri 6
- Ohio 5
- Arkansas 4
- California 4
- Georgia 4
- Mississippi 4
- Nebraska 4
- New York 4
- Texas 4
- Alabama 3
- Kentucky 3
- Nevada 3
- New Hampshire 3
- Pennsylvania 3
- Wisconsin 3
- North Carolina 2
- Puerto Rico 2
- Washington 2
- Arizona 1
- Colorado 1
- Florida 1
- Iowa 1
- Louisiana 1
- Maine 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2490468 | 2490468 | 2022-05-10 | Mercer | Illinois | 17131 | 4066 | 47 |
2470899 | 2470899 | 2022-05-04 | Jo Daviess | Illinois | 17085 | 4066 | 39 |
2467695 | 2467695 | 2022-05-03 | Warren | Illinois | 17187 | 4066 | 87 |
2450446 | 2450446 | 2022-04-27 | Giles | Virginia | 51071 | 4066 | 50 |
2399297 | 2399297 | 2022-04-12 | Moultrie | Illinois | 17139 | 4066 | 52 |
2401274 | 2401274 | 2022-04-12 | Bosque | Texas | 48035 | 4066 | 70 |
2396042 | 2396042 | 2022-04-11 | Moultrie | Illinois | 17139 | 4066 | 52 |
2358674 | 2358674 | 2022-03-30 | Catano | Puerto Rico | 72033 | 4066 | |
2302780 | 2302780 | 2022-03-13 | Unknown | Nebraska | 4066 | 422 | |
2299528 | 2299528 | 2022-03-12 | Unknown | Nebraska | 4066 | 422 | |
2296276 | 2296276 | 2022-03-11 | Unknown | Nebraska | 4066 | 422 | |
2278378 | 2278378 | 2022-03-06 | Clay | Arkansas | 5021 | 4066 | 90 |
2271872 | 2271872 | 2022-03-04 | Clay | Arkansas | 5021 | 4066 | 90 |
2262008 | 2262008 | 2022-03-01 | Clay | Alabama | 1027 | 4066 | 76 |
2244784 | 2244784 | 2022-02-23 | Fulton | Pennsylvania | 42057 | 4066 | 64 |
2224909 | 2224909 | 2022-02-17 | Chowan | North Carolina | 37041 | 4066 | 50 |
2198489 | 2198489 | 2022-02-09 | Cooper | Missouri | 29053 | 4066 | 73 |
2194320 | 2194320 | 2022-02-08 | Carroll | Illinois | 17015 | 4066 | 47 |
2192038 | 2192038 | 2022-02-07 | Pike | Missouri | 29163 | 4066 | 55 |
2154226 | 2154226 | 2022-01-26 | Panola | Texas | 48365 | 4066 | 116 |
2124479 | 2124479 | 2022-01-17 | Barranquitas | Puerto Rico | 72019 | 4066 | |
2077187 | 2077187 | 2022-01-03 | Cassia | Idaho | 16031 | 4066 | 45 |
2073936 | 2073936 | 2022-01-02 | Cassia | Idaho | 16031 | 4066 | 45 |
2070685 | 2070685 | 2022-01-01 | Cassia | Idaho | 16031 | 4066 | 45 |
2067434 | 2067434 | 2021-12-31 | Cassia | Idaho | 16031 | 4066 | 45 |
2064183 | 2064183 | 2021-12-30 | Cassia | Idaho | 16031 | 4066 | 45 |
2021167 | 2021167 | 2021-12-16 | Winchester city | Virginia | 51840 | 4066 | 57 |
2013827 | 2013827 | 2021-12-14 | Seminole | Oklahoma | 40133 | 4066 | 107 |
2010576 | 2010576 | 2021-12-13 | Seminole | Oklahoma | 40133 | 4066 | 107 |
2006693 | 2006693 | 2021-12-12 | Randolph | Missouri | 29175 | 4066 | 80 |
2007325 | 2007325 | 2021-12-12 | Seminole | Oklahoma | 40133 | 4066 | 107 |
2004074 | 2004074 | 2021-12-11 | Seminole | Oklahoma | 40133 | 4066 | 107 |
2000823 | 2000823 | 2021-12-10 | Seminole | Oklahoma | 40133 | 4066 | 107 |
1997573 | 1997573 | 2021-12-09 | Seminole | Oklahoma | 40133 | 4066 | 107 |
1994322 | 1994322 | 2021-12-08 | Seminole | Oklahoma | 40133 | 4066 | 107 |
1963955 | 1963955 | 2021-11-29 | Rowan | Kentucky | 21205 | 4066 | 37 |
1950023 | 1950023 | 2021-11-25 | Sevier | Arkansas | 5133 | 4066 | 60 |
1945215 | 1945215 | 2021-11-23 | Lewis | New York | 36049 | 4066 | 39 |
1946384 | 1946384 | 2021-11-23 | Russell | Virginia | 51167 | 4066 | 68 |
1897217 | 1897217 | 2021-11-08 | Wayne | Tennessee | 47181 | 4066 | 39 |
1897544 | 1897544 | 2021-11-08 | Carroll | Virginia | 51035 | 4066 | 96 |
1893967 | 1893967 | 2021-11-07 | Wayne | Tennessee | 47181 | 4066 | 39 |
1890717 | 1890717 | 2021-11-06 | Wayne | Tennessee | 47181 | 4066 | 39 |
1887467 | 1887467 | 2021-11-05 | Wayne | Tennessee | 47181 | 4066 | 39 |
1884671 | 1884671 | 2021-11-04 | Island | Washington | 53029 | 4066 | 46 |
1859355 | 1859355 | 2021-10-28 | Peach | Georgia | 13225 | 4066 | 98 |
1808731 | 1808731 | 2021-10-12 | Franklin | New York | 36033 | 4066 | 19 |
1797703 | 1797703 | 2021-10-09 | Jerome | Idaho | 16053 | 4066 | 42 |
1787892 | 1787892 | 2021-10-06 | Sumter | Georgia | 13261 | 4066 | 120 |
1778264 | 1778264 | 2021-10-03 | Iroquois | Illinois | 17075 | 4066 | 78 |
1780174 | 1780174 | 2021-10-03 | DeKalb | Tennessee | 47041 | 4066 | 64 |
1775014 | 1775014 | 2021-10-02 | Iroquois | Illinois | 17075 | 4066 | 78 |
1776924 | 1776924 | 2021-10-02 | DeKalb | Tennessee | 47041 | 4066 | 64 |
1771764 | 1771764 | 2021-10-01 | Iroquois | Illinois | 17075 | 4066 | 78 |
1773674 | 1773674 | 2021-10-01 | DeKalb | Tennessee | 47041 | 4066 | 64 |
1763498 | 1763498 | 2021-09-28 | Morrow | Ohio | 39117 | 4066 | 51 |
1736476 | 1736476 | 2021-09-20 | Montgomery | Kentucky | 21173 | 4066 | 37 |
1732856 | 1732856 | 2021-09-19 | Daviess | Indiana | 18027 | 4066 | 108 |
1733670 | 1733670 | 2021-09-19 | Dunklin | Missouri | 29069 | 4066 | 57 |
1729606 | 1729606 | 2021-09-18 | Daviess | Indiana | 18027 | 4066 | 108 |
1726356 | 1726356 | 2021-09-17 | Daviess | Indiana | 18027 | 4066 | 108 |
1722892 | 1722892 | 2021-09-16 | Pierce | Georgia | 13229 | 4066 | 82 |
1711166 | 1711166 | 2021-09-12 | Douglas | Nevada | 32005 | 4066 | 44 |
1707919 | 1707919 | 2021-09-11 | Douglas | Nevada | 32005 | 4066 | 44 |
1704672 | 1704672 | 2021-09-10 | Douglas | Nevada | 32005 | 4066 | 44 |
1667214 | 1667214 | 2021-08-30 | Marion | Alabama | 1093 | 4066 | 110 |
1617053 | 1617053 | 2021-08-14 | Cortland | New York | 36023 | 4066 | 64 |
1603238 | 1603238 | 2021-08-10 | Floyd | Kentucky | 21071 | 4066 | 75 |
1560724 | 1560724 | 2021-07-28 | Miami | Indiana | 18103 | 4066 | 74 |
1536060 | 1536060 | 2021-07-20 | Brown | Ohio | 39015 | 4066 | 62 |
1518383 | 1518383 | 2021-07-15 | Fulton | Illinois | 17057 | 4066 | 67 |
1520310 | 1520310 | 2021-07-15 | Giles | Tennessee | 47055 | 4066 | 100 |
1497106 | 1497106 | 2021-07-08 | Crawford | Ohio | 39033 | 4066 | 111 |
1488819 | 1488819 | 2021-07-06 | Logan | Colorado | 8075 | 4066 | 69 |
1447805 | 1447805 | 2021-06-23 | Neshoba | Mississippi | 28099 | 4066 | 180 |
1443892 | 1443892 | 2021-06-22 | Whitley | Indiana | 18183 | 4066 | 43 |
1440647 | 1440647 | 2021-06-21 | Whitley | Indiana | 18183 | 4066 | 43 |
1432935 | 1432935 | 2021-06-18 | Rusk | Texas | 48401 | 4066 | 109 |
1425405 | 1425405 | 2021-06-16 | Grafton | New Hampshire | 33009 | 4066 | 26 |
1422157 | 1422157 | 2021-06-15 | Grafton | New Hampshire | 33009 | 4066 | 26 |
1418912 | 1418912 | 2021-06-14 | Grafton | New Hampshire | 33009 | 4066 | 26 |
1397837 | 1397837 | 2021-06-08 | Union | Arkansas | 5139 | 4066 | 115 |
1350244 | 1350244 | 2021-05-24 | Huron | Michigan | 26063 | 4066 | 75 |
1348693 | 1348693 | 2021-05-23 | Franklin | Virginia | 51067 | 4066 | 77 |
1342197 | 1342197 | 2021-05-21 | Franklin | Virginia | 51067 | 4066 | 77 |
1315713 | 1315713 | 2021-05-13 | Williamsburg | South Carolina | 45089 | 4066 | 99 |
1299802 | 1299802 | 2021-05-08 | Matagorda | Texas | 48321 | 4066 | 109 |
1286205 | 1286205 | 2021-05-04 | Custer | Oklahoma | 40039 | 4066 | 99 |
1282959 | 1282959 | 2021-05-03 | Custer | Oklahoma | 40039 | 4066 | 99 |
1279712 | 1279712 | 2021-05-02 | Custer | Oklahoma | 40039 | 4066 | 99 |
1276465 | 1276465 | 2021-05-01 | Custer | Oklahoma | 40039 | 4066 | 99 |
1273218 | 1273218 | 2021-04-30 | Custer | Oklahoma | 40039 | 4066 | 99 |
1269971 | 1269971 | 2021-04-29 | Custer | Oklahoma | 40039 | 4066 | 99 |
1266724 | 1266724 | 2021-04-28 | Custer | Oklahoma | 40039 | 4066 | 99 |
1263477 | 1263477 | 2021-04-27 | Custer | Oklahoma | 40039 | 4066 | 97 |
1260230 | 1260230 | 2021-04-26 | Custer | Oklahoma | 40039 | 4066 | 97 |
1256983 | 1256983 | 2021-04-25 | Custer | Oklahoma | 40039 | 4066 | 97 |
1253736 | 1253736 | 2021-04-24 | Custer | Oklahoma | 40039 | 4066 | 97 |
1249831 | 1249831 | 2021-04-23 | Camden | Missouri | 29029 | 4066 | 87 |
1250489 | 1250489 | 2021-04-23 | Custer | Oklahoma | 40039 | 4066 | 97 |
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);