ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
196 rows where cases = 2803 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 18
- Florida 16
- Kentucky 12
- Georgia 11
- Missouri 11
- Oklahoma 10
- Virginia 9
- Arkansas 7
- Illinois 7
- Indiana 7
- Louisiana 7
- North Carolina 7
- Ohio 7
- California 6
- Pennsylvania 5
- Wisconsin 5
- Iowa 4
- Kansas 4
- Minnesota 4
- Mississippi 4
- Tennessee 4
- Alabama 3
- Alaska 3
- Nevada 3
- New York 3
- South Carolina 3
- West Virginia 3
- Idaho 2
- Maryland 2
- Colorado 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2490461 | 2490461 | 2022-05-10 | Marshall | Illinois | 17123 | 2803 | 33 |
2375282 | 2375282 | 2022-04-04 | Eastland | Texas | 48133 | 2803 | 113 |
2372030 | 2372030 | 2022-04-03 | Eastland | Texas | 48133 | 2803 | 113 |
2368777 | 2368777 | 2022-04-02 | Eastland | Texas | 48133 | 2803 | 113 |
2365524 | 2365524 | 2022-04-01 | Eastland | Texas | 48133 | 2803 | 113 |
2289517 | 2289517 | 2022-03-09 | Barton | Missouri | 29011 | 2803 | 50 |
2286265 | 2286265 | 2022-03-08 | Barton | Missouri | 29011 | 2803 | 50 |
2281122 | 2281122 | 2022-03-06 | Ward | Texas | 48475 | 2803 | 43 |
2277869 | 2277869 | 2022-03-05 | Ward | Texas | 48475 | 2803 | 43 |
2201667 | 2201667 | 2022-02-10 | Jefferson Davis | Mississippi | 28065 | 2803 | 47 |
2193726 | 2193726 | 2022-02-08 | Conecuh | Alabama | 1035 | 2803 | 63 |
2176203 | 2176203 | 2022-02-02 | Barnes | North Dakota | 38003 | 2803 | 44 |
2169312 | 2169312 | 2022-01-31 | Custer | Montana | 30017 | 2803 | 44 |
2130763 | 2130763 | 2022-01-19 | Morgan | Ohio | 39115 | 2803 | 48 |
2123181 | 2123181 | 2022-01-17 | Green | Kentucky | 21087 | 2803 | 40 |
2119929 | 2119929 | 2022-01-16 | Green | Kentucky | 21087 | 2803 | 40 |
2116677 | 2116677 | 2022-01-15 | Green | Kentucky | 21087 | 2803 | 40 |
2113426 | 2113426 | 2022-01-14 | Green | Kentucky | 21087 | 2803 | 40 |
2114720 | 2114720 | 2022-01-14 | Anasco | Puerto Rico | 72011 | 2803 | |
2111900 | 2111900 | 2022-01-13 | Leon | Texas | 48289 | 2803 | 75 |
2083196 | 2083196 | 2022-01-05 | Kodiak Island Borough | Alaska | 2150 | 2803 | 10 |
2079944 | 2079944 | 2022-01-04 | Kodiak Island Borough | Alaska | 2150 | 2803 | 10 |
2076692 | 2076692 | 2022-01-03 | Kodiak Island Borough | Alaska | 2150 | 2803 | 10 |
2078012 | 2078012 | 2022-01-03 | Sibley | Minnesota | 27143 | 2803 | 20 |
2060831 | 2060831 | 2021-12-29 | Jefferson | Georgia | 13163 | 2803 | 93 |
2053357 | 2053357 | 2021-12-26 | Jackson | Texas | 48239 | 2803 | 52 |
2053623 | 2053623 | 2021-12-26 | New Kent | Virginia | 51127 | 2803 | 28 |
2050107 | 2050107 | 2021-12-25 | Jackson | Texas | 48239 | 2803 | 52 |
2050373 | 2050373 | 2021-12-25 | New Kent | Virginia | 51127 | 2803 | 28 |
2046857 | 2046857 | 2021-12-24 | Jackson | Texas | 48239 | 2803 | 52 |
2047123 | 2047123 | 2021-12-24 | New Kent | Virginia | 51127 | 2803 | 28 |
2043607 | 2043607 | 2021-12-23 | Jackson | Texas | 48239 | 2803 | 52 |
2038233 | 2038233 | 2021-12-22 | De Witt | Illinois | 17039 | 2803 | 39 |
2013222 | 2013222 | 2021-12-14 | Wright | Missouri | 29229 | 2803 | 66 |
2005734 | 2005734 | 2021-12-12 | Ford | Illinois | 17053 | 2803 | 67 |
2002483 | 2002483 | 2021-12-11 | Ford | Illinois | 17053 | 2803 | 67 |
2004562 | 2004562 | 2021-12-11 | Freestone | Texas | 48161 | 2803 | 73 |
1999233 | 1999233 | 2021-12-10 | Ford | Illinois | 17053 | 2803 | 67 |
1983919 | 1983919 | 2021-12-05 | Moniteau | Missouri | 29135 | 2803 | 46 |
1962972 | 1962972 | 2021-11-29 | Clay | Arkansas | 5021 | 2803 | 74 |
1960665 | 1960665 | 2021-11-28 | Lawrence | Kentucky | 21127 | 2803 | 44 |
1956483 | 1956483 | 2021-11-27 | Franklin | Arkansas | 5047 | 2803 | 55 |
1957414 | 1957414 | 2021-11-27 | Lawrence | Kentucky | 21127 | 2803 | 44 |
1954163 | 1954163 | 2021-11-26 | Lawrence | Kentucky | 21127 | 2803 | 44 |
1950912 | 1950912 | 2021-11-25 | Lawrence | Kentucky | 21127 | 2803 | 44 |
1947661 | 1947661 | 2021-11-24 | Lawrence | Kentucky | 21127 | 2803 | 44 |
1924239 | 1924239 | 2021-11-17 | Banks | Georgia | 13011 | 2803 | 65 |
1916005 | 1916005 | 2021-11-14 | Avery | North Carolina | 37011 | 2803 | 39 |
1912755 | 1912755 | 2021-11-13 | Avery | North Carolina | 37011 | 2803 | 39 |
1909505 | 1909505 | 2021-11-12 | Avery | North Carolina | 37011 | 2803 | 39 |
1872430 | 1872430 | 2021-11-01 | Gem | Idaho | 16045 | 2803 | 60 |
1844731 | 1844731 | 2021-10-23 | Paulding | Ohio | 39125 | 2803 | 47 |
1831908 | 1831908 | 2021-10-19 | Juniata | Pennsylvania | 42067 | 2803 | 114 |
1814475 | 1814475 | 2021-10-14 | Spencer | Kentucky | 21215 | 2803 | 33 |
1811473 | 1811473 | 2021-10-13 | Hubbard | Minnesota | 27057 | 2803 | 44 |
1813242 | 1813242 | 2021-10-13 | McDowell | West Virginia | 54047 | 2803 | 43 |
1808390 | 1808390 | 2021-10-12 | Clinton | Missouri | 29049 | 2803 | 76 |
1793835 | 1793835 | 2021-10-07 | Taylor | Wisconsin | 55119 | 2803 | 43 |
1758158 | 1758158 | 2021-09-27 | Fayette | Alabama | 1057 | 2803 | 73 |
1742665 | 1742665 | 2021-09-22 | Starke | Indiana | 18149 | 2803 | 66 |
1727246 | 1727246 | 2021-09-17 | Vernon | Missouri | 29217 | 2803 | 60 |
1722859 | 1722859 | 2021-09-16 | Jeff Davis | Georgia | 13161 | 2803 | 47 |
1696380 | 1696380 | 2021-09-07 | Waushara | Wisconsin | 55137 | 2803 | 42 |
1690100 | 1690100 | 2021-09-06 | Colusa | California | 6011 | 2803 | 18 |
1678131 | 1678131 | 2021-09-02 | Somerset | Maryland | 24039 | 2803 | 44 |
1649125 | 1649125 | 2021-08-24 | Jasper | Mississippi | 28061 | 2803 | 51 |
1631585 | 1631585 | 2021-08-19 | Logan | Arkansas | 5083 | 2803 | 27 |
1612059 | 1612059 | 2021-08-13 | Arkansas | Arkansas | 5001 | 2803 | 47 |
1596452 | 1596452 | 2021-08-08 | LaGrange | Indiana | 18087 | 2803 | 75 |
1598652 | 1598652 | 2021-08-08 | Carroll | Virginia | 51035 | 2803 | 80 |
1593203 | 1593203 | 2021-08-07 | LaGrange | Indiana | 18087 | 2803 | 75 |
1595403 | 1595403 | 2021-08-07 | Carroll | Virginia | 51035 | 2803 | 80 |
1589954 | 1589954 | 2021-08-06 | LaGrange | Indiana | 18087 | 2803 | 75 |
1592154 | 1592154 | 2021-08-06 | Carroll | Virginia | 51035 | 2803 | 80 |
1558245 | 1558245 | 2021-07-27 | Crawford | Missouri | 29055 | 2803 | 41 |
1540870 | 1540870 | 2021-07-22 | Taylor | Florida | 12123 | 2803 | 48 |
1540876 | 1540876 | 2021-07-22 | Washington | Florida | 12133 | 2803 | 52 |
1537623 | 1537623 | 2021-07-21 | Taylor | Florida | 12123 | 2803 | 48 |
1537629 | 1537629 | 2021-07-21 | Washington | Florida | 12133 | 2803 | 52 |
1534375 | 1534375 | 2021-07-20 | Taylor | Florida | 12123 | 2803 | 48 |
1534381 | 1534381 | 2021-07-20 | Washington | Florida | 12133 | 2803 | 52 |
1531128 | 1531128 | 2021-07-19 | Taylor | Florida | 12123 | 2803 | 48 |
1531134 | 1531134 | 2021-07-19 | Washington | Florida | 12133 | 2803 | 52 |
1527881 | 1527881 | 2021-07-18 | Taylor | Florida | 12123 | 2803 | 48 |
1527887 | 1527887 | 2021-07-18 | Washington | Florida | 12133 | 2803 | 52 |
1524634 | 1524634 | 2021-07-17 | Taylor | Florida | 12123 | 2803 | 48 |
1524640 | 1524640 | 2021-07-17 | Washington | Florida | 12133 | 2803 | 52 |
1521386 | 1521386 | 2021-07-16 | Taylor | Florida | 12123 | 2803 | 48 |
1521392 | 1521392 | 2021-07-16 | Washington | Florida | 12133 | 2803 | 52 |
1518699 | 1518699 | 2021-07-15 | Labette | Kansas | 20099 | 2803 | 50 |
1515452 | 1515452 | 2021-07-14 | Labette | Kansas | 20099 | 2803 | 50 |
1512206 | 1512206 | 2021-07-13 | Labette | Kansas | 20099 | 2803 | 50 |
1508959 | 1508959 | 2021-07-12 | Labette | Kansas | 20099 | 2803 | 50 |
1505246 | 1505246 | 2021-07-11 | Lee | Georgia | 13177 | 2803 | 59 |
1502000 | 1502000 | 2021-07-10 | Lee | Georgia | 13177 | 2803 | 59 |
1498754 | 1498754 | 2021-07-09 | Lee | Georgia | 13177 | 2803 | 59 |
1483651 | 1483651 | 2021-07-04 | Washington | Missouri | 29221 | 2803 | 52 |
1475384 | 1475384 | 2021-07-01 | Okanogan | Washington | 53047 | 2803 | 43 |
1406015 | 1406015 | 2021-06-10 | Lewis | New York | 36049 | 2803 | 36 |
1348494 | 1348494 | 2021-05-23 | Limestone | Texas | 48293 | 2803 | 79 |
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);