ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
180 rows where cases = 3007 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 26
- South Dakota 16
- Louisiana 12
- Indiana 11
- Virginia 10
- Arkansas 9
- Georgia 8
- North Carolina 7
- Kentucky 6
- Ohio 6
- Alabama 5
- California 5
- Minnesota 5
- New York 5
- Illinois 4
- Maryland 4
- Mississippi 4
- Nebraska 4
- Michigan 3
- Missouri 3
- Nevada 3
- Pennsylvania 3
- West Virginia 3
- Colorado 2
- Kansas 2
- New Mexico 2
- Oklahoma 2
- Oregon 2
- Puerto Rico 2
- Tennessee 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2379380 | 2379380 | 2022-04-06 | Moffat | Colorado | 8081 | 3007 | 51 |
2346771 | 2346771 | 2022-03-27 | Mariposa | California | 6043 | 3007 | 30 |
2343518 | 2343518 | 2022-03-26 | Mariposa | California | 6043 | 3007 | 30 |
2340265 | 2340265 | 2022-03-25 | Mariposa | California | 6043 | 3007 | 30 |
2329044 | 2329044 | 2022-03-21 | Washington | North Carolina | 37187 | 3007 | 50 |
2325792 | 2325792 | 2022-03-20 | Washington | North Carolina | 37187 | 3007 | 50 |
2322539 | 2322539 | 2022-03-19 | Washington | North Carolina | 37187 | 3007 | 50 |
2319285 | 2319285 | 2022-03-18 | Washington | North Carolina | 37187 | 3007 | 50 |
2281641 | 2281641 | 2022-03-07 | Desha | Arkansas | 5041 | 3007 | 38 |
2278388 | 2278388 | 2022-03-06 | Desha | Arkansas | 5041 | 3007 | 38 |
2275135 | 2275135 | 2022-03-05 | Desha | Arkansas | 5041 | 3007 | 38 |
2168158 | 2168158 | 2022-01-31 | Jasper | Georgia | 13159 | 3007 | 67 |
2133786 | 2133786 | 2022-01-20 | Schuyler | New York | 36097 | 3007 | 23 |
2128134 | 2128134 | 2022-01-18 | Jackson | Texas | 48239 | 3007 | 53 |
2119649 | 2119649 | 2022-01-16 | Parke | Indiana | 18121 | 3007 | 40 |
2116397 | 2116397 | 2022-01-15 | Parke | Indiana | 18121 | 3007 | 40 |
2113146 | 2113146 | 2022-01-14 | Parke | Indiana | 18121 | 3007 | 40 |
2088602 | 2088602 | 2022-01-06 | Clatsop | Oregon | 41007 | 3007 | 36 |
2083762 | 2083762 | 2022-01-05 | Jo Daviess | Illinois | 17085 | 3007 | 35 |
2077728 | 2077728 | 2022-01-03 | Union | Kentucky | 21225 | 3007 | 46 |
2035718 | 2035718 | 2021-12-21 | Houston | Minnesota | 27055 | 3007 | 17 |
2036889 | 2036889 | 2021-12-21 | Union | South Dakota | 46127 | 3007 | 46 |
2031900 | 2031900 | 2021-12-20 | Vermillion | Indiana | 18165 | 3007 | 61 |
2030698 | 2030698 | 2021-12-19 | Shelby | Texas | 48419 | 3007 | 113 |
2024190 | 2024190 | 2021-12-17 | San Jacinto | Texas | 48407 | 3007 | 82 |
2018241 | 2018241 | 2021-12-16 | Drew | Arkansas | 5043 | 3007 | 56 |
2019209 | 2019209 | 2021-12-16 | Powell | Kentucky | 21197 | 3007 | 27 |
2014378 | 2014378 | 2021-12-14 | Lee | Texas | 48287 | 3007 | 54 |
2011127 | 2011127 | 2021-12-13 | Lee | Texas | 48287 | 3007 | 54 |
2007876 | 2007876 | 2021-12-12 | Lee | Texas | 48287 | 3007 | 54 |
2004625 | 2004625 | 2021-12-11 | Lee | Texas | 48287 | 3007 | 54 |
1994912 | 1994912 | 2021-12-08 | Panola | Texas | 48365 | 3007 | 109 |
1994981 | 1994981 | 2021-12-08 | Young | Texas | 48503 | 3007 | 74 |
1991730 | 1991730 | 2021-12-07 | Young | Texas | 48503 | 3007 | 73 |
1962990 | 1962990 | 2021-11-29 | Hempstead | Arkansas | 5057 | 3007 | 41 |
1964688 | 1964688 | 2021-11-29 | Roosevelt | New Mexico | 35041 | 3007 | 71 |
1955213 | 1955213 | 2021-11-26 | Meigs | Ohio | 39105 | 3007 | 57 |
1950014 | 1950014 | 2021-11-25 | Polk | Arkansas | 5113 | 3007 | 112 |
1946763 | 1946763 | 2021-11-24 | Polk | Arkansas | 5113 | 3007 | 112 |
1928317 | 1928317 | 2021-11-18 | Talbot | Maryland | 24041 | 3007 | 56 |
1913216 | 1913216 | 2021-11-13 | Juncos | Puerto Rico | 72077 | 3007 | |
1880953 | 1880953 | 2021-11-03 | Sequatchie | Tennessee | 47153 | 3007 | 33 |
1874344 | 1874344 | 2021-11-01 | Hughes | South Dakota | 46065 | 3007 | 45 |
1862131 | 1862131 | 2021-10-29 | Fayette | Alabama | 1057 | 3007 | 81 |
1826085 | 1826085 | 2021-10-17 | Fredericksburg city | Virginia | 51630 | 3007 | 25 |
1822836 | 1822836 | 2021-10-16 | Fredericksburg city | Virginia | 51630 | 3007 | 25 |
1819587 | 1819587 | 2021-10-15 | Fredericksburg city | Virginia | 51630 | 3007 | 25 |
1805365 | 1805365 | 2021-10-11 | Saunders | Nebraska | 31155 | 3007 | 20 |
1802116 | 1802116 | 2021-10-10 | Saunders | Nebraska | 31155 | 3007 | 20 |
1798867 | 1798867 | 2021-10-09 | Saunders | Nebraska | 31155 | 3007 | 20 |
1795618 | 1795618 | 2021-10-08 | Saunders | Nebraska | 31155 | 3007 | 20 |
1788137 | 1788137 | 2021-10-06 | Owen | Indiana | 18119 | 3007 | 69 |
1789621 | 1789621 | 2021-10-06 | Lincoln | Oregon | 41041 | 3007 | 32 |
1765735 | 1765735 | 2021-09-29 | Simpson | Kentucky | 21213 | 3007 | 47 |
1751136 | 1751136 | 2021-09-24 | Jones | Texas | 48253 | 3007 | 65 |
1747887 | 1747887 | 2021-09-23 | Jones | Texas | 48253 | 3007 | 63 |
1744220 | 1744220 | 2021-09-22 | Aguadilla | Puerto Rico | 72005 | 3007 | |
1739754 | 1739754 | 2021-09-21 | Wayne | Kentucky | 21231 | 3007 | 56 |
1741388 | 1741388 | 2021-09-21 | Jones | Texas | 48253 | 3007 | 63 |
1736505 | 1736505 | 2021-09-20 | Wayne | Kentucky | 21231 | 3007 | 56 |
1719260 | 1719260 | 2021-09-15 | Clark | Arkansas | 5019 | 3007 | 50 |
1719072 | 1719072 | 2021-09-14 | Jackson | Wisconsin | 55053 | 3007 | 29 |
1705736 | 1705736 | 2021-09-10 | Scurry | Texas | 48415 | 3007 | 69 |
1689599 | 1689599 | 2021-09-05 | Botetourt | Virginia | 51023 | 3007 | 39 |
1686349 | 1686349 | 2021-09-04 | Botetourt | Virginia | 51023 | 3007 | 39 |
1683098 | 1683098 | 2021-09-03 | Botetourt | Virginia | 51023 | 3007 | 39 |
1657121 | 1657121 | 2021-08-26 | Carroll | Virginia | 51035 | 3007 | 81 |
1651571 | 1651571 | 2021-08-25 | Jersey | Illinois | 17083 | 3007 | 71 |
1652331 | 1652331 | 2021-08-25 | Todd | Minnesota | 27153 | 3007 | 33 |
1631894 | 1631894 | 2021-08-19 | Haralson | Georgia | 13143 | 3007 | 92 |
1627683 | 1627683 | 2021-08-17 | Jasper | Texas | 48241 | 3007 | 97 |
1608589 | 1608589 | 2021-08-11 | Preston | West Virginia | 54077 | 3007 | 47 |
1588078 | 1588078 | 2021-08-05 | Morrow | Ohio | 39117 | 3007 | 44 |
1584833 | 1584833 | 2021-08-04 | Perry | Ohio | 39127 | 3007 | 50 |
1579524 | 1579524 | 2021-08-03 | Winston | Alabama | 1133 | 3007 | 73 |
1580414 | 1580414 | 2021-08-03 | Miami | Kansas | 20121 | 3007 | 43 |
1580958 | 1580958 | 2021-08-03 | Audrain | Missouri | 29007 | 3007 | 58 |
1577165 | 1577165 | 2021-08-02 | Miami | Kansas | 20121 | 3007 | 43 |
1578893 | 1578893 | 2021-08-02 | Deaf Smith | Texas | 48117 | 3007 | 68 |
1575645 | 1575645 | 2021-08-01 | Deaf Smith | Texas | 48117 | 3007 | 68 |
1572397 | 1572397 | 2021-07-31 | Deaf Smith | Texas | 48117 | 3007 | 68 |
1556180 | 1556180 | 2021-07-26 | Frio | Texas | 48163 | 3007 | 53 |
1556601 | 1556601 | 2021-07-26 | Mineral | West Virginia | 54057 | 3007 | 92 |
1530428 | 1530428 | 2021-07-18 | Amherst | Virginia | 51009 | 3007 | 40 |
1527181 | 1527181 | 2021-07-17 | Amherst | Virginia | 51009 | 3007 | 40 |
1523934 | 1523934 | 2021-07-16 | Amherst | Virginia | 51009 | 3007 | 40 |
1486452 | 1486452 | 2021-07-05 | Sabine | Louisiana | 22085 | 3007 | 64 |
1486471 | 1486471 | 2021-07-05 | West Baton Rouge | Louisiana | 22121 | 3007 | 63 |
1483206 | 1483206 | 2021-07-04 | Sabine | Louisiana | 22085 | 3007 | 64 |
1483225 | 1483225 | 2021-07-04 | West Baton Rouge | Louisiana | 22121 | 3007 | 63 |
1479959 | 1479959 | 2021-07-03 | Sabine | Louisiana | 22085 | 3007 | 64 |
1479978 | 1479978 | 2021-07-03 | West Baton Rouge | Louisiana | 22121 | 3007 | 63 |
1476713 | 1476713 | 2021-07-02 | Sabine | Louisiana | 22085 | 3007 | 64 |
1476732 | 1476732 | 2021-07-02 | West Baton Rouge | Louisiana | 22121 | 3007 | 63 |
1463995 | 1463995 | 2021-06-28 | Coahoma | Mississippi | 28027 | 3007 | 84 |
1461088 | 1461088 | 2021-06-27 | Douglas | Nevada | 32005 | 3007 | 37 |
1457843 | 1457843 | 2021-06-26 | Douglas | Nevada | 32005 | 3007 | 37 |
1454598 | 1454598 | 2021-06-25 | Douglas | Nevada | 32005 | 3007 | 37 |
1450807 | 1450807 | 2021-06-24 | Queen Anne's | Maryland | 24035 | 3007 | 51 |
1447561 | 1447561 | 2021-06-23 | Queen Anne's | Maryland | 24035 | 3007 | 51 |
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);