ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
152 rows where cases = 4243 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Tennessee 15
- Texas 13
- Illinois 10
- Iowa 10
- Kentucky 10
- Kansas 8
- Minnesota 7
- West Virginia 7
- Wisconsin 6
- Idaho 5
- Ohio 5
- Arkansas 4
- Georgia 4
- Mississippi 4
- North Carolina 4
- Pennsylvania 4
- California 3
- Indiana 3
- Louisiana 3
- Maine 3
- Missouri 3
- New Hampshire 3
- Oregon 3
- Virginia 3
- Alabama 2
- New Mexico 2
- New York 2
- South Carolina 2
- Maryland 1
- Michigan 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2486030 | 2486030 | 2022-05-08 | Houston | Texas | 48225 | 4243 | 111 |
2482772 | 2482772 | 2022-05-07 | Houston | Texas | 48225 | 4243 | 111 |
2479514 | 2479514 | 2022-05-06 | Houston | Texas | 48225 | 4243 | 111 |
2471665 | 2471665 | 2022-05-04 | Wadena | Minnesota | 27159 | 4243 | 55 |
2440868 | 2440868 | 2022-04-24 | Crawford | Wisconsin | 55023 | 4243 | 28 |
2437612 | 2437612 | 2022-04-23 | Crawford | Wisconsin | 55023 | 4243 | 28 |
2434356 | 2434356 | 2022-04-22 | Crawford | Wisconsin | 55023 | 4243 | 28 |
2394890 | 2394890 | 2022-04-10 | Lee | Texas | 48287 | 4243 | 60 |
2395253 | 2395253 | 2022-04-10 | Morgan | West Virginia | 54065 | 4243 | 69 |
2391997 | 2391997 | 2022-04-09 | Morgan | West Virginia | 54065 | 4243 | 69 |
2388741 | 2388741 | 2022-04-08 | Morgan | West Virginia | 54065 | 4243 | 69 |
2385486 | 2385486 | 2022-04-07 | Morgan | West Virginia | 54065 | 4243 | 68 |
2373197 | 2373197 | 2022-04-04 | Carroll | Illinois | 17015 | 4243 | 49 |
2369944 | 2369944 | 2022-04-03 | Carroll | Illinois | 17015 | 4243 | 49 |
2366691 | 2366691 | 2022-04-02 | Carroll | Illinois | 17015 | 4243 | 49 |
2363438 | 2363438 | 2022-04-01 | Carroll | Illinois | 17015 | 4243 | 49 |
2360184 | 2360184 | 2022-03-31 | Carroll | Illinois | 17015 | 4243 | 49 |
2356930 | 2356930 | 2022-03-30 | Carroll | Illinois | 17015 | 4243 | 49 |
2263993 | 2263993 | 2022-03-01 | Warren | North Carolina | 37185 | 4243 | 39 |
2219014 | 2219014 | 2022-02-15 | Benton | Tennessee | 47005 | 4243 | 84 |
2215763 | 2215763 | 2022-02-14 | Benton | Tennessee | 47005 | 4243 | 84 |
2212512 | 2212512 | 2022-02-13 | Benton | Tennessee | 47005 | 4243 | 84 |
2209259 | 2209259 | 2022-02-12 | Benton | Tennessee | 47005 | 4243 | 84 |
2206006 | 2206006 | 2022-02-11 | Benton | Tennessee | 47005 | 4243 | 84 |
2202753 | 2202753 | 2022-02-10 | Benton | Tennessee | 47005 | 4243 | 84 |
2199499 | 2199499 | 2022-02-09 | Benton | Tennessee | 47005 | 4243 | 84 |
2154212 | 2154212 | 2022-01-26 | Montague | Texas | 48337 | 4243 | 106 |
2138273 | 2138273 | 2022-01-21 | Lincoln | West Virginia | 54043 | 4243 | 58 |
2133739 | 2133739 | 2022-01-20 | Taos | New Mexico | 35055 | 4243 | 76 |
2134922 | 2134922 | 2022-01-20 | Powhatan | Virginia | 51145 | 4243 | 34 |
2126246 | 2126246 | 2022-01-18 | Mahaska | Iowa | 19123 | 4243 | 74 |
2122994 | 2122994 | 2022-01-17 | Mahaska | Iowa | 19123 | 4243 | 74 |
2119742 | 2119742 | 2022-01-16 | Mahaska | Iowa | 19123 | 4243 | 74 |
2116490 | 2116490 | 2022-01-15 | Mahaska | Iowa | 19123 | 4243 | 74 |
2113239 | 2113239 | 2022-01-14 | Mahaska | Iowa | 19123 | 4243 | 74 |
2109987 | 2109987 | 2022-01-13 | Mahaska | Iowa | 19123 | 4243 | 74 |
2110139 | 2110139 | 2022-01-13 | Bourbon | Kentucky | 21017 | 4243 | 45 |
2106736 | 2106736 | 2022-01-12 | Mahaska | Iowa | 19123 | 4243 | 74 |
2106929 | 2106929 | 2022-01-12 | Hart | Kentucky | 21099 | 4243 | 85 |
2092254 | 2092254 | 2022-01-07 | Austin | Texas | 48015 | 4243 | 58 |
2006210 | 2006210 | 2021-12-12 | Rowan | Kentucky | 21205 | 4243 | 44 |
2002959 | 2002959 | 2021-12-11 | Rowan | Kentucky | 21205 | 4243 | 44 |
1999709 | 1999709 | 2021-12-10 | Rowan | Kentucky | 21205 | 4243 | 44 |
2000215 | 2000215 | 2021-12-10 | Washington | Missouri | 29221 | 4243 | 98 |
1987206 | 1987206 | 2021-12-06 | Stone | Missouri | 29209 | 4243 | 99 |
1988355 | 1988355 | 2021-12-06 | Karnes | Texas | 48255 | 4243 | 58 |
1984597 | 1984597 | 2021-12-05 | Jefferson | Oregon | 41031 | 4243 | 66 |
1985105 | 1985105 | 2021-12-05 | Karnes | Texas | 48255 | 4243 | 58 |
1981347 | 1981347 | 2021-12-04 | Jefferson | Oregon | 41031 | 4243 | 66 |
1981855 | 1981855 | 2021-12-04 | Karnes | Texas | 48255 | 4243 | 58 |
1978097 | 1978097 | 2021-12-03 | Jefferson | Oregon | 41031 | 4243 | 66 |
1974031 | 1974031 | 2021-12-02 | Coahoma | Mississippi | 28027 | 4243 | 109 |
1966698 | 1966698 | 2021-11-30 | Payette | Idaho | 16075 | 4243 | 71 |
1967869 | 1967869 | 2021-11-30 | Churchill | Nevada | 32001 | 4243 | 81 |
1962209 | 1962209 | 2021-11-28 | Smith | Tennessee | 47159 | 4243 | 53 |
1958958 | 1958958 | 2021-11-27 | Smith | Tennessee | 47159 | 4243 | 53 |
1955707 | 1955707 | 2021-11-26 | Smith | Tennessee | 47159 | 4243 | 53 |
1952456 | 1952456 | 2021-11-25 | Smith | Tennessee | 47159 | 4243 | 53 |
1949205 | 1949205 | 2021-11-24 | Smith | Tennessee | 47159 | 4243 | 53 |
1944246 | 1944246 | 2021-11-23 | Barton | Kansas | 20009 | 4243 | 63 |
1940996 | 1940996 | 2021-11-22 | Barton | Kansas | 20009 | 4243 | 63 |
1938635 | 1938635 | 2021-11-21 | Sullivan | New Hampshire | 33019 | 4243 | 38 |
1935385 | 1935385 | 2021-11-20 | Sullivan | New Hampshire | 33019 | 4243 | 38 |
1932135 | 1932135 | 2021-11-19 | Sullivan | New Hampshire | 33019 | 4243 | 38 |
1907786 | 1907786 | 2021-11-12 | Calaveras | California | 6009 | 4243 | 83 |
1908172 | 1908172 | 2021-11-12 | Elmore | Idaho | 16039 | 4243 | 47 |
1904537 | 1904537 | 2021-11-11 | Calaveras | California | 6009 | 4243 | 83 |
1904923 | 1904923 | 2021-11-11 | Elmore | Idaho | 16039 | 4243 | 47 |
1901673 | 1901673 | 2021-11-10 | Elmore | Idaho | 16039 | 4243 | 47 |
1873254 | 1873254 | 2021-11-01 | Todd | Minnesota | 27153 | 4243 | 37 |
1850306 | 1850306 | 2021-10-25 | Somerset | Maine | 23025 | 4243 | 45 |
1847056 | 1847056 | 2021-10-24 | Somerset | Maine | 23025 | 4243 | 45 |
1843806 | 1843806 | 2021-10-23 | Somerset | Maine | 23025 | 4243 | 45 |
1827431 | 1827431 | 2021-10-18 | Lincoln | Kentucky | 21137 | 4243 | 80 |
1828179 | 1828179 | 2021-10-18 | Cibola | New Mexico | 35006 | 4243 | 139 |
1815688 | 1815688 | 2021-10-14 | Tioga | Pennsylvania | 42117 | 4243 | 124 |
1810156 | 1810156 | 2021-10-13 | Lawrence | Alabama | 1079 | 4243 | 114 |
1793610 | 1793610 | 2021-10-07 | Isle of Wight | Virginia | 51093 | 4243 | 82 |
1787959 | 1787959 | 2021-10-06 | Latah | Idaho | 16057 | 4243 | 25 |
1747102 | 1747102 | 2021-09-23 | Montgomery | North Carolina | 37123 | 4243 | 105 |
1739054 | 1739054 | 2021-09-21 | Chattooga | Georgia | 13055 | 4243 | 85 |
1713828 | 1713828 | 2021-09-13 | West Baton Rouge | Louisiana | 22121 | 4243 | 71 |
1712519 | 1712519 | 2021-09-12 | Logan | West Virginia | 54045 | 4243 | 109 |
1694093 | 1694093 | 2021-09-07 | Harvey | Kansas | 20079 | 4243 | 74 |
1690844 | 1690844 | 2021-09-06 | Harvey | Kansas | 20079 | 4243 | 74 |
1687594 | 1687594 | 2021-09-05 | Harvey | Kansas | 20079 | 4243 | 74 |
1684344 | 1684344 | 2021-09-04 | Harvey | Kansas | 20079 | 4243 | 74 |
1681093 | 1681093 | 2021-09-03 | Harvey | Kansas | 20079 | 4243 | 74 |
1646385 | 1646385 | 2021-08-23 | Jackson | North Carolina | 37099 | 4243 | 58 |
1646995 | 1646995 | 2021-08-23 | Hardin | Tennessee | 47071 | 4243 | 70 |
1633757 | 1633757 | 2021-08-19 | Venango | Pennsylvania | 42121 | 4243 | 105 |
1628728 | 1628728 | 2021-08-18 | Wayne | Georgia | 13305 | 4243 | 93 |
1627254 | 1627254 | 2021-08-17 | Pike | Pennsylvania | 42103 | 4243 | 54 |
1619224 | 1619224 | 2021-08-15 | Steuben | Indiana | 18151 | 4243 | 64 |
1615976 | 1615976 | 2021-08-14 | Steuben | Indiana | 18151 | 4243 | 64 |
1612727 | 1612727 | 2021-08-13 | Steuben | Indiana | 18151 | 4243 | 64 |
1578670 | 1578670 | 2021-08-02 | Williamsburg | South Carolina | 45089 | 4243 | 105 |
1573613 | 1573613 | 2021-08-01 | Lee | Illinois | 17103 | 4243 | 93 |
1570365 | 1570365 | 2021-07-31 | Lee | Illinois | 17103 | 4243 | 93 |
1567117 | 1567117 | 2021-07-30 | Lee | Illinois | 17103 | 4243 | 93 |
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);