ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
199 rows where cases = 2314 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 18
- Mississippi 16
- North Carolina 12
- Minnesota 10
- Virginia 10
- Illinois 9
- Indiana 8
- Puerto Rico 8
- Kentucky 7
- Arkansas 6
- Idaho 6
- Louisiana 6
- Missouri 6
- Texas 6
- California 5
- Tennessee 5
- Wisconsin 5
- Alabama 4
- Colorado 4
- Nebraska 4
- Oregon 4
- West Virginia 4
- Florida 3
- Kansas 3
- Maryland 3
- Michigan 3
- Montana 3
- Ohio 3
- Alaska 2
- Arizona 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2490103 | 2490103 | 2022-05-10 | San Miguel | Colorado | 8113 | 2314 | 8 |
2486846 | 2486846 | 2022-05-09 | San Miguel | Colorado | 8113 | 2314 | 8 |
2485047 | 2485047 | 2022-05-08 | Unknown | Nebraska | 2314 | 462 | |
2481789 | 2481789 | 2022-05-07 | Unknown | Nebraska | 2314 | 462 | |
2478531 | 2478531 | 2022-05-06 | Unknown | Nebraska | 2314 | 462 | |
2474087 | 2474087 | 2022-05-05 | Clearwater | Idaho | 16035 | 2314 | 33 |
2475273 | 2475273 | 2022-05-05 | Unknown | Nebraska | 2314 | 462 | |
2470830 | 2470830 | 2022-05-04 | Clearwater | Idaho | 16035 | 2314 | 33 |
2461915 | 2461915 | 2022-05-01 | Choctaw | Mississippi | 28019 | 2314 | 33 |
2458659 | 2458659 | 2022-04-30 | Choctaw | Mississippi | 28019 | 2314 | 33 |
2455403 | 2455403 | 2022-04-29 | Choctaw | Mississippi | 28019 | 2314 | 33 |
2452147 | 2452147 | 2022-04-28 | Choctaw | Mississippi | 28019 | 2314 | 33 |
2448891 | 2448891 | 2022-04-27 | Choctaw | Mississippi | 28019 | 2314 | 33 |
2445635 | 2445635 | 2022-04-26 | Choctaw | Mississippi | 28019 | 2314 | 33 |
2289407 | 2289407 | 2022-03-09 | Rock | Minnesota | 27133 | 2314 | 33 |
2286156 | 2286156 | 2022-03-08 | Rock | Minnesota | 27133 | 2314 | 33 |
2282904 | 2282904 | 2022-03-07 | Rock | Minnesota | 27133 | 2314 | 33 |
2281366 | 2281366 | 2022-03-06 | Clay | West Virginia | 54015 | 2314 | 36 |
2278113 | 2278113 | 2022-03-05 | Clay | West Virginia | 54015 | 2314 | 36 |
2274860 | 2274860 | 2022-03-04 | Clay | West Virginia | 54015 | 2314 | 36 |
2268943 | 2268943 | 2022-03-03 | Evans | Georgia | 13109 | 2314 | 63 |
2264497 | 2264497 | 2022-03-01 | Lake | South Dakota | 46079 | 2314 | 27 |
2217773 | 2217773 | 2022-02-15 | Mackinac | Michigan | 26097 | 2314 | 27 |
2214522 | 2214522 | 2022-02-14 | Mackinac | Michigan | 26097 | 2314 | 27 |
2211606 | 2211606 | 2022-02-13 | Fergus | Montana | 30027 | 2314 | 52 |
2208353 | 2208353 | 2022-02-12 | Fergus | Montana | 30027 | 2314 | 52 |
2204669 | 2204669 | 2022-02-11 | Piscataquis | Maine | 23021 | 2314 | 26 |
2205100 | 2205100 | 2022-02-11 | Fergus | Montana | 30027 | 2314 | 52 |
2194199 | 2194199 | 2022-02-08 | McIntosh | Georgia | 13191 | 2314 | 35 |
2183060 | 2183060 | 2022-02-04 | Florida | Puerto Rico | 72054 | 2314 | |
2148143 | 2148143 | 2022-01-24 | Big Horn | Wyoming | 56003 | 2314 | 60 |
2118902 | 2118902 | 2022-01-16 | Coosa | Alabama | 1037 | 2314 | 48 |
2111367 | 2111367 | 2022-01-13 | Curry | Oregon | 41015 | 2314 | 40 |
2111384 | 2111384 | 2022-01-13 | Morrow | Oregon | 41049 | 2314 | 26 |
2078606 | 2078606 | 2022-01-03 | Swain | North Carolina | 37173 | 2314 | 29 |
2051111 | 2051111 | 2021-12-26 | Oglethorpe | Georgia | 13221 | 2314 | 43 |
2047861 | 2047861 | 2021-12-25 | Oglethorpe | Georgia | 13221 | 2314 | 43 |
2044611 | 2044611 | 2021-12-24 | Oglethorpe | Georgia | 13221 | 2314 | 43 |
2046462 | 2046462 | 2021-12-24 | Cayey | Puerto Rico | 72035 | 2314 | |
2043212 | 2043212 | 2021-12-23 | Cayey | Puerto Rico | 72035 | 2314 | |
2038137 | 2038137 | 2021-12-22 | Telfair | Georgia | 13271 | 2314 | 75 |
2032452 | 2032452 | 2021-12-20 | Chippewa | Minnesota | 27023 | 2314 | 43 |
2011690 | 2011690 | 2021-12-14 | Nome Census Area | Alaska | 2180 | 2314 | 2 |
2008439 | 2008439 | 2021-12-13 | Nome Census Area | Alaska | 2180 | 2314 | 2 |
2006068 | 2006068 | 2021-12-12 | Nemaha | Kansas | 20131 | 2314 | 56 |
2002817 | 2002817 | 2021-12-11 | Nemaha | Kansas | 20131 | 2314 | 56 |
1999567 | 1999567 | 2021-12-10 | Nemaha | Kansas | 20131 | 2314 | 56 |
1997197 | 1997197 | 2021-12-09 | Socorro | New Mexico | 35053 | 2314 | 66 |
1983484 | 1983484 | 2021-12-05 | Caldwell | Louisiana | 22021 | 2314 | 39 |
1984728 | 1984728 | 2021-12-05 | Las Piedras | Puerto Rico | 72085 | 2314 | |
1980234 | 1980234 | 2021-12-04 | Caldwell | Louisiana | 22021 | 2314 | 39 |
1981478 | 1981478 | 2021-12-04 | Las Piedras | Puerto Rico | 72085 | 2314 | |
1976984 | 1976984 | 2021-12-03 | Caldwell | Louisiana | 22021 | 2314 | 39 |
1961083 | 1961083 | 2021-11-28 | Tallahatchie | Mississippi | 28135 | 2314 | 53 |
1957832 | 1957832 | 2021-11-27 | Tallahatchie | Mississippi | 28135 | 2314 | 53 |
1954581 | 1954581 | 2021-11-26 | Tallahatchie | Mississippi | 28135 | 2314 | 53 |
1951330 | 1951330 | 2021-11-25 | Tallahatchie | Mississippi | 28135 | 2314 | 53 |
1948079 | 1948079 | 2021-11-24 | Tallahatchie | Mississippi | 28135 | 2314 | 53 |
1944828 | 1944828 | 2021-11-23 | Tallahatchie | Mississippi | 28135 | 2314 | 53 |
1902124 | 1902124 | 2021-11-10 | Clinton | Kentucky | 21053 | 2314 | 35 |
1897407 | 1897407 | 2021-11-08 | Pecos | Texas | 48371 | 2314 | 50 |
1875866 | 1875866 | 2021-11-02 | Pike | Indiana | 18125 | 2314 | 45 |
1874994 | 1874994 | 2021-11-01 | Taylor | West Virginia | 54091 | 2314 | 38 |
1853748 | 1853748 | 2021-10-26 | Renville | Minnesota | 27129 | 2314 | 49 |
1849752 | 1849752 | 2021-10-25 | Johnson | Illinois | 17087 | 2314 | 38 |
1827032 | 1827032 | 2021-10-18 | Moultrie | Illinois | 17139 | 2314 | 41 |
1827769 | 1827769 | 2021-10-18 | Wadena | Minnesota | 27159 | 2314 | 29 |
1811508 | 1811508 | 2021-10-13 | Redwood | Minnesota | 27127 | 2314 | 43 |
1812115 | 1812115 | 2021-10-13 | Warren | North Carolina | 37185 | 2314 | 28 |
1781133 | 1781133 | 2021-10-04 | Crowley | Colorado | 8025 | 2314 | 20 |
1692683 | 1692683 | 2021-09-06 | Llano | Texas | 48299 | 2314 | 60 |
1675994 | 1675994 | 2021-09-01 | Aguada | Puerto Rico | 72003 | 2314 | |
1673357 | 1673357 | 2021-08-31 | Buckingham | Virginia | 51029 | 2314 | 33 |
1665870 | 1665870 | 2021-08-29 | Hertford | North Carolina | 37091 | 2314 | 65 |
1662622 | 1662622 | 2021-08-28 | Hertford | North Carolina | 37091 | 2314 | 65 |
1658990 | 1658990 | 2021-08-27 | Moniteau | Missouri | 29135 | 2314 | 34 |
1659374 | 1659374 | 2021-08-27 | Hertford | North Carolina | 37091 | 2314 | 65 |
1649249 | 1649249 | 2021-08-24 | Morgan | Missouri | 29141 | 2314 | 51 |
1647265 | 1647265 | 2021-08-23 | Shelby | Texas | 48419 | 2314 | 75 |
1626365 | 1626365 | 2021-08-17 | Clay | Mississippi | 28025 | 2314 | 56 |
1618934 | 1618934 | 2021-08-15 | Meriwether | Georgia | 13199 | 2314 | 93 |
1621405 | 1621405 | 2021-08-15 | Dinwiddie | Virginia | 51053 | 2314 | 46 |
1615686 | 1615686 | 2021-08-14 | Meriwether | Georgia | 13199 | 2314 | 93 |
1618157 | 1618157 | 2021-08-14 | Dinwiddie | Virginia | 51053 | 2314 | 46 |
1612437 | 1612437 | 2021-08-13 | Meriwether | Georgia | 13199 | 2314 | 93 |
1614909 | 1614909 | 2021-08-13 | Dinwiddie | Virginia | 51053 | 2314 | 46 |
1605563 | 1605563 | 2021-08-11 | Ashley | Arkansas | 5003 | 2314 | 37 |
1605851 | 1605851 | 2021-08-11 | Berrien | Georgia | 13019 | 2314 | 50 |
1604747 | 1604747 | 2021-08-10 | Crockett | Tennessee | 47033 | 2314 | 52 |
1583142 | 1583142 | 2021-08-04 | Dodge | Georgia | 13091 | 2314 | 110 |
1561089 | 1561089 | 2021-07-28 | Woodford | Kentucky | 21239 | 2314 | 22 |
1555051 | 1555051 | 2021-07-26 | Perry | Missouri | 29157 | 2314 | 30 |
1551804 | 1551804 | 2021-07-25 | Perry | Missouri | 29157 | 2314 | 30 |
1528223 | 1528223 | 2021-07-18 | Fountain | Indiana | 18045 | 2314 | 50 |
1524976 | 1524976 | 2021-07-17 | Fountain | Indiana | 18045 | 2314 | 50 |
1521728 | 1521728 | 2021-07-16 | Fountain | Indiana | 18045 | 2314 | 50 |
1514962 | 1514962 | 2021-07-14 | Grady | Georgia | 13131 | 2314 | 66 |
1505302 | 1505302 | 2021-07-11 | Union | Georgia | 13291 | 2314 | 81 |
1502056 | 1502056 | 2021-07-10 | Union | Georgia | 13291 | 2314 | 81 |
1498810 | 1498810 | 2021-07-09 | Union | Georgia | 13291 | 2314 | 81 |
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);