ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
296 rows where cases = 2007 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Michigan 23
- Georgia 18
- Mississippi 18
- Tennessee 18
- Arkansas 17
- Iowa 13
- Kentucky 13
- Texas 13
- Virginia 13
- Nebraska 11
- Illinois 10
- Missouri 9
- Oklahoma 9
- Minnesota 8
- Puerto Rico 8
- Indiana 7
- West Virginia 7
- Alaska 6
- Louisiana 6
- Ohio 6
- Oregon 6
- Kansas 5
- New Mexico 5
- Wisconsin 5
- Alabama 4
- Colorado 4
- Maine 4
- California 3
- Montana 3
- Pennsylvania 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2399173 | 2399173 | 2022-04-12 | Wilcox | Georgia | 13315 | 2007 | 69 |
2401019 | 2401019 | 2022-04-12 | Patillas | Puerto Rico | 72109 | 2007 | |
2401194 | 2401194 | 2022-04-12 | Hancock | Tennessee | 47067 | 2007 | 35 |
2395918 | 2395918 | 2022-04-11 | Wilcox | Georgia | 13315 | 2007 | 69 |
2397939 | 2397939 | 2022-04-11 | Hancock | Tennessee | 47067 | 2007 | 35 |
2394684 | 2394684 | 2022-04-10 | Hancock | Tennessee | 47067 | 2007 | 35 |
2391428 | 2391428 | 2022-04-09 | Hancock | Tennessee | 47067 | 2007 | 35 |
2388172 | 2388172 | 2022-04-08 | Hancock | Tennessee | 47067 | 2007 | 35 |
2384917 | 2384917 | 2022-04-07 | Hancock | Tennessee | 47067 | 2007 | 35 |
2381662 | 2381662 | 2022-04-06 | Hancock | Tennessee | 47067 | 2007 | 35 |
2375929 | 2375929 | 2022-04-05 | Southeast Fairbanks Census Area | Alaska | 2240 | 2007 | 20 |
2372677 | 2372677 | 2022-04-04 | Southeast Fairbanks Census Area | Alaska | 2240 | 2007 | 20 |
2369424 | 2369424 | 2022-04-03 | Southeast Fairbanks Census Area | Alaska | 2240 | 2007 | 20 |
2366171 | 2366171 | 2022-04-02 | Southeast Fairbanks Census Area | Alaska | 2240 | 2007 | 20 |
2362918 | 2362918 | 2022-04-01 | Southeast Fairbanks Census Area | Alaska | 2240 | 2007 | 20 |
2358549 | 2358549 | 2022-03-30 | Unknown | Oklahoma | 2007 | 1 | |
2355295 | 2355295 | 2022-03-29 | Unknown | Oklahoma | 2007 | 1 | |
2352955 | 2352955 | 2022-03-28 | Pocahontas | West Virginia | 54075 | 2007 | 28 |
2302463 | 2302463 | 2022-03-13 | Humphreys | Mississippi | 28053 | 2007 | 44 |
2299211 | 2299211 | 2022-03-12 | Humphreys | Mississippi | 28053 | 2007 | 44 |
2295959 | 2295959 | 2022-03-11 | Humphreys | Mississippi | 28053 | 2007 | 44 |
2292707 | 2292707 | 2022-03-10 | Humphreys | Mississippi | 28053 | 2007 | 44 |
2289455 | 2289455 | 2022-03-09 | Humphreys | Mississippi | 28053 | 2007 | 44 |
2286204 | 2286204 | 2022-03-08 | Humphreys | Mississippi | 28053 | 2007 | 44 |
2282952 | 2282952 | 2022-03-07 | Humphreys | Mississippi | 28053 | 2007 | 44 |
2279699 | 2279699 | 2022-03-06 | Humphreys | Mississippi | 28053 | 2007 | 44 |
2276446 | 2276446 | 2022-03-05 | Humphreys | Mississippi | 28053 | 2007 | 44 |
2273193 | 2273193 | 2022-03-04 | Humphreys | Mississippi | 28053 | 2007 | 44 |
2269941 | 2269941 | 2022-03-03 | Humphreys | Mississippi | 28053 | 2007 | 44 |
2266688 | 2266688 | 2022-03-02 | Humphreys | Mississippi | 28053 | 2007 | 44 |
2262918 | 2262918 | 2022-03-01 | Ellsworth | Kansas | 20053 | 2007 | 31 |
2263373 | 2263373 | 2022-03-01 | Murray | Minnesota | 27101 | 2007 | 15 |
2263437 | 2263437 | 2022-03-01 | Humphreys | Mississippi | 28053 | 2007 | 44 |
2259667 | 2259667 | 2022-02-28 | Ellsworth | Kansas | 20053 | 2007 | 31 |
2256416 | 2256416 | 2022-02-27 | Ellsworth | Kansas | 20053 | 2007 | 31 |
2253165 | 2253165 | 2022-02-26 | Ellsworth | Kansas | 20053 | 2007 | 31 |
2249914 | 2249914 | 2022-02-25 | Ellsworth | Kansas | 20053 | 2007 | 31 |
2248220 | 2248220 | 2022-02-24 | Custer | South Dakota | 46033 | 2007 | 22 |
2221447 | 2221447 | 2022-02-16 | Holt | Nebraska | 31089 | 2007 | 18 |
2219484 | 2219484 | 2022-02-15 | Madison | Virginia | 51113 | 2007 | 34 |
2210260 | 2210260 | 2022-02-13 | Lincoln | Colorado | 8073 | 2007 | 9 |
2207007 | 2207007 | 2022-02-12 | Lincoln | Colorado | 8073 | 2007 | 9 |
2203754 | 2203754 | 2022-02-11 | Lincoln | Colorado | 8073 | 2007 | 9 |
2203372 | 2203372 | 2022-02-10 | Webster | West Virginia | 54101 | 2007 | 28 |
2193123 | 2193123 | 2022-02-07 | Clay | Texas | 48077 | 2007 | 27 |
2178761 | 2178761 | 2022-02-03 | Presque Isle | Michigan | 26141 | 2007 | 55 |
2179045 | 2179045 | 2022-02-03 | St. Clair | Missouri | 29185 | 2007 | 30 |
2175509 | 2175509 | 2022-02-02 | Presque Isle | Michigan | 26141 | 2007 | 55 |
2165793 | 2165793 | 2022-01-30 | Jackson | Minnesota | 27063 | 2007 | 16 |
2162538 | 2162538 | 2022-01-29 | Jackson | Minnesota | 27063 | 2007 | 16 |
2159283 | 2159283 | 2022-01-28 | Jackson | Minnesota | 27063 | 2007 | 16 |
2155832 | 2155832 | 2022-01-27 | Red River | Louisiana | 22081 | 2007 | 49 |
2152172 | 2152172 | 2022-01-26 | Martin | Indiana | 18101 | 2007 | 23 |
2152985 | 2152985 | 2022-01-26 | Monroe | Missouri | 29137 | 2007 | 38 |
2147308 | 2147308 | 2022-01-24 | Sabana Grande | Puerto Rico | 72121 | 2007 | |
2144770 | 2144770 | 2022-01-23 | Clay | West Virginia | 54015 | 2007 | 30 |
2126679 | 2126679 | 2022-01-18 | Luce | Michigan | 26095 | 2007 | 6 |
2123427 | 2123427 | 2022-01-17 | Luce | Michigan | 26095 | 2007 | 6 |
2120175 | 2120175 | 2022-01-16 | Luce | Michigan | 26095 | 2007 | 6 |
2116923 | 2116923 | 2022-01-15 | Luce | Michigan | 26095 | 2007 | 6 |
2113672 | 2113672 | 2022-01-14 | Luce | Michigan | 26095 | 2007 | 6 |
2109658 | 2109658 | 2022-01-13 | Towns | Georgia | 13281 | 2007 | 90 |
2102792 | 2102792 | 2022-01-11 | Pike | Arkansas | 5109 | 2007 | 39 |
2100084 | 2100084 | 2022-01-10 | Benton | Indiana | 18007 | 2007 | 21 |
2076630 | 2076630 | 2022-01-03 | Conecuh | Alabama | 1035 | 2007 | 62 |
2077811 | 2077811 | 2022-01-03 | Piscataquis | Maine | 23021 | 2007 | 20 |
2074560 | 2074560 | 2022-01-02 | Piscataquis | Maine | 23021 | 2007 | 20 |
2071309 | 2071309 | 2022-01-01 | Piscataquis | Maine | 23021 | 2007 | 20 |
2068058 | 2068058 | 2021-12-31 | Piscataquis | Maine | 23021 | 2007 | 20 |
2053997 | 2053997 | 2021-12-27 | Fulton | Arkansas | 5049 | 2007 | 77 |
2054973 | 2054973 | 2021-12-27 | Todd | Kentucky | 21219 | 2007 | 38 |
2032769 | 2032769 | 2021-12-20 | Richland | Montana | 30083 | 2007 | 27 |
2033462 | 2033462 | 2021-12-20 | Catano | Puerto Rico | 72033 | 2007 | |
1990084 | 1990084 | 2021-12-07 | Dukes | Massachusetts | 25007 | 2007 | 0 |
1988563 | 1988563 | 2021-12-06 | Dickenson | Virginia | 51051 | 2007 | 30 |
1980993 | 1980993 | 2021-12-04 | Schuyler | New York | 36097 | 2007 | 20 |
1941937 | 1941937 | 2021-11-22 | Socorro | New Mexico | 35053 | 2007 | 64 |
1928171 | 1928171 | 2021-11-18 | Martin | Kentucky | 21159 | 2007 | 36 |
1916214 | 1916214 | 2021-11-14 | Morgan | Ohio | 39115 | 2007 | 37 |
1892530 | 1892530 | 2021-11-07 | West Carroll | Louisiana | 22123 | 2007 | 50 |
1893082 | 1893082 | 2021-11-07 | Otoe | Nebraska | 31131 | 2007 | 13 |
1893589 | 1893589 | 2021-11-07 | Hood River | Oregon | 41027 | 2007 | 37 |
1889280 | 1889280 | 2021-11-06 | West Carroll | Louisiana | 22123 | 2007 | 50 |
1889832 | 1889832 | 2021-11-06 | Otoe | Nebraska | 31131 | 2007 | 13 |
1890339 | 1890339 | 2021-11-06 | Hood River | Oregon | 41027 | 2007 | 37 |
1886030 | 1886030 | 2021-11-05 | West Carroll | Louisiana | 22123 | 2007 | 50 |
1886582 | 1886582 | 2021-11-05 | Otoe | Nebraska | 31131 | 2007 | 13 |
1887089 | 1887089 | 2021-11-05 | Hood River | Oregon | 41027 | 2007 | 37 |
1883333 | 1883333 | 2021-11-04 | Otoe | Nebraska | 31131 | 2007 | 13 |
1880084 | 1880084 | 2021-11-03 | Otoe | Nebraska | 31131 | 2007 | 13 |
1875696 | 1875696 | 2021-11-02 | Shoshone | Idaho | 16079 | 2007 | 60 |
1871760 | 1871760 | 2021-10-31 | Buffalo | Wisconsin | 55011 | 2007 | 8 |
1868511 | 1868511 | 2021-10-30 | Buffalo | Wisconsin | 55011 | 2007 | 8 |
1865262 | 1865262 | 2021-10-29 | Buffalo | Wisconsin | 55011 | 2007 | 8 |
1853491 | 1853491 | 2021-10-26 | Claiborne | Louisiana | 22027 | 2007 | 63 |
1838764 | 1838764 | 2021-10-21 | Camp | Texas | 48063 | 2007 | 65 |
1835515 | 1835515 | 2021-10-20 | Camp | Texas | 48063 | 2007 | 65 |
1832266 | 1832266 | 2021-10-19 | Camp | Texas | 48063 | 2007 | 64 |
1828937 | 1828937 | 2021-10-18 | Lake | Tennessee | 47095 | 2007 | 31 |
1787268 | 1787268 | 2021-10-05 | Taylor | West Virginia | 54091 | 2007 | 34 |
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);