ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
265 rows where cases = 2437 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 32
- Iowa 18
- Texas 18
- Virginia 17
- Oklahoma 16
- Alabama 12
- Illinois 11
- Mississippi 11
- Puerto Rico 11
- Michigan 10
- Missouri 10
- South Carolina 9
- Indiana 8
- Kentucky 8
- Ohio 8
- North Carolina 7
- Wisconsin 6
- Louisiana 5
- Tennessee 5
- Montana 4
- Nebraska 4
- Pennsylvania 4
- Arkansas 3
- Idaho 3
- Maryland 3
- New York 3
- California 2
- Colorado 2
- Florida 2
- Kansas 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2489552 | 2489552 | 2022-05-09 | Madison | Virginia | 51113 | 2437 | 41 |
2306647 | 2306647 | 2022-03-14 | Lajas | Puerto Rico | 72079 | 2437 | |
2303396 | 2303396 | 2022-03-13 | Lajas | Puerto Rico | 72079 | 2437 | |
2258347 | 2258347 | 2022-02-27 | Trinity | Texas | 48455 | 2437 | 72 |
2255096 | 2255096 | 2022-02-26 | Trinity | Texas | 48455 | 2437 | 72 |
2244868 | 2244868 | 2022-02-23 | Luquillo | Puerto Rico | 72089 | 2437 | |
2241617 | 2241617 | 2022-02-22 | Luquillo | Puerto Rico | 72089 | 2437 | |
2237645 | 2237645 | 2022-02-21 | Rosebud | Montana | 30087 | 2437 | 58 |
2238366 | 2238366 | 2022-02-21 | Luquillo | Puerto Rico | 72089 | 2437 | |
2234394 | 2234394 | 2022-02-20 | Rosebud | Montana | 30087 | 2437 | 58 |
2231143 | 2231143 | 2022-02-19 | Rosebud | Montana | 30087 | 2437 | 58 |
2227892 | 2227892 | 2022-02-18 | Rosebud | Montana | 30087 | 2437 | 58 |
2222705 | 2222705 | 2022-02-16 | Franklin city | Virginia | 51620 | 2437 | 45 |
2213938 | 2213938 | 2022-02-14 | Benton | Indiana | 18007 | 2437 | 21 |
2212777 | 2212777 | 2022-02-13 | Morris | Texas | 48343 | 2437 | 65 |
2212953 | 2212953 | 2022-02-13 | Franklin city | Virginia | 51620 | 2437 | 44 |
2209700 | 2209700 | 2022-02-12 | Franklin city | Virginia | 51620 | 2437 | 44 |
2205826 | 2205826 | 2022-02-11 | Ciales | Puerto Rico | 72039 | 2437 | |
2206447 | 2206447 | 2022-02-11 | Franklin city | Virginia | 51620 | 2437 | 44 |
2188735 | 2188735 | 2022-02-06 | Douglas | Missouri | 29067 | 2437 | 69 |
2145121 | 2145121 | 2022-01-24 | Mariposa | California | 6043 | 2437 | 19 |
2133584 | 2133584 | 2022-01-20 | Colfax | Nebraska | 31037 | 2437 | 24 |
2122384 | 2122384 | 2022-01-17 | Archuleta | Colorado | 8007 | 2437 | 9 |
2112091 | 2112091 | 2022-01-13 | Dickenson | Virginia | 51051 | 2437 | 39 |
2096556 | 2096556 | 2022-01-09 | Dade | Georgia | 13083 | 2437 | 22 |
2093304 | 2093304 | 2022-01-08 | Dade | Georgia | 13083 | 2437 | 22 |
2090052 | 2090052 | 2022-01-07 | Dade | Georgia | 13083 | 2437 | 22 |
2086801 | 2086801 | 2022-01-06 | Dade | Georgia | 13083 | 2437 | 22 |
2083549 | 2083549 | 2022-01-05 | Dade | Georgia | 13083 | 2437 | 22 |
2083784 | 2083784 | 2022-01-05 | Menard | Illinois | 17129 | 2437 | 19 |
2080447 | 2080447 | 2022-01-04 | Gooding | Idaho | 16047 | 2437 | 44 |
2079425 | 2079425 | 2022-01-03 | Pecos | Texas | 48371 | 2437 | 58 |
2074058 | 2074058 | 2022-01-02 | Wabash | Illinois | 17185 | 2437 | 22 |
2070807 | 2070807 | 2022-01-01 | Wabash | Illinois | 17185 | 2437 | 22 |
2072003 | 2072003 | 2022-01-01 | Schuyler | New York | 36097 | 2437 | 23 |
2067556 | 2067556 | 2021-12-31 | Wabash | Illinois | 17185 | 2437 | 22 |
2064305 | 2064305 | 2021-12-30 | Wabash | Illinois | 17185 | 2437 | 22 |
2056754 | 2056754 | 2021-12-27 | Millard | Utah | 49027 | 2437 | 31 |
2035210 | 2035210 | 2021-12-21 | Jefferson | Iowa | 19101 | 2437 | 44 |
2031960 | 2031960 | 2021-12-20 | Jefferson | Iowa | 19101 | 2437 | 44 |
2034133 | 2034133 | 2021-12-20 | Patrick | Virginia | 51141 | 2437 | 63 |
2028709 | 2028709 | 2021-12-19 | Jefferson | Iowa | 19101 | 2437 | 44 |
2028974 | 2028974 | 2021-12-19 | Trigg | Kentucky | 21221 | 2437 | 29 |
2025458 | 2025458 | 2021-12-18 | Jefferson | Iowa | 19101 | 2437 | 44 |
2025723 | 2025723 | 2021-12-18 | Trigg | Kentucky | 21221 | 2437 | 29 |
2022207 | 2022207 | 2021-12-17 | Jefferson | Iowa | 19101 | 2437 | 44 |
2022472 | 2022472 | 2021-12-17 | Trigg | Kentucky | 21221 | 2437 | 29 |
2018956 | 2018956 | 2021-12-16 | Jefferson | Iowa | 19101 | 2437 | 44 |
2015706 | 2015706 | 2021-12-15 | Jefferson | Iowa | 19101 | 2437 | 44 |
2013814 | 2013814 | 2021-12-14 | Okfuskee | Oklahoma | 40107 | 2437 | 49 |
2010563 | 2010563 | 2021-12-13 | Okfuskee | Oklahoma | 40107 | 2437 | 49 |
2010737 | 2010737 | 2021-12-13 | Manati | Puerto Rico | 72091 | 2437 | |
2007312 | 2007312 | 2021-12-12 | Okfuskee | Oklahoma | 40107 | 2437 | 49 |
2007486 | 2007486 | 2021-12-12 | Manati | Puerto Rico | 72091 | 2437 | |
2004061 | 2004061 | 2021-12-11 | Okfuskee | Oklahoma | 40107 | 2437 | 49 |
2000810 | 2000810 | 2021-12-10 | Okfuskee | Oklahoma | 40107 | 2437 | 49 |
2000923 | 2000923 | 2021-12-10 | Potter | Pennsylvania | 42105 | 2437 | 69 |
1997560 | 1997560 | 2021-12-09 | Okfuskee | Oklahoma | 40107 | 2437 | 49 |
1994309 | 1994309 | 2021-12-08 | Okfuskee | Oklahoma | 40107 | 2437 | 49 |
1978721 | 1978721 | 2021-12-03 | Wilbarger | Texas | 48487 | 2437 | 68 |
1973223 | 1973223 | 2021-12-02 | De Witt | Illinois | 17039 | 2437 | 37 |
1971333 | 1971333 | 2021-12-01 | Polk | North Carolina | 37149 | 2437 | 49 |
1964893 | 1964893 | 2021-11-29 | Ramsey | North Dakota | 38071 | 2437 | 38 |
1965896 | 1965896 | 2021-11-29 | Southampton | Virginia | 51175 | 2437 | 68 |
1960004 | 1960004 | 2021-11-28 | Brooks | Georgia | 13027 | 2437 | 73 |
1961096 | 1961096 | 2021-11-28 | Yalobusha | Mississippi | 28161 | 2437 | 47 |
1956753 | 1956753 | 2021-11-27 | Brooks | Georgia | 13027 | 2437 | 73 |
1957845 | 1957845 | 2021-11-27 | Yalobusha | Mississippi | 28161 | 2437 | 47 |
1953502 | 1953502 | 2021-11-26 | Brooks | Georgia | 13027 | 2437 | 73 |
1954594 | 1954594 | 2021-11-26 | Yalobusha | Mississippi | 28161 | 2437 | 47 |
1950251 | 1950251 | 2021-11-25 | Brooks | Georgia | 13027 | 2437 | 73 |
1951343 | 1951343 | 2021-11-25 | Yalobusha | Mississippi | 28161 | 2437 | 47 |
1947000 | 1947000 | 2021-11-24 | Brooks | Georgia | 13027 | 2437 | 73 |
1948092 | 1948092 | 2021-11-24 | Yalobusha | Mississippi | 28161 | 2437 | 47 |
1949640 | 1949640 | 2021-11-24 | Southampton | Virginia | 51175 | 2437 | 68 |
1943749 | 1943749 | 2021-11-23 | Brooks | Georgia | 13027 | 2437 | 73 |
1941158 | 1941158 | 2021-11-22 | Larue | Kentucky | 21123 | 2437 | 53 |
1937249 | 1937249 | 2021-11-21 | Brooks | Georgia | 13027 | 2437 | 72 |
1933999 | 1933999 | 2021-11-20 | Brooks | Georgia | 13027 | 2437 | 72 |
1930386 | 1930386 | 2021-11-19 | Macon | Alabama | 1087 | 2437 | 64 |
1930747 | 1930747 | 2021-11-19 | Brooks | Georgia | 13027 | 2437 | 72 |
1932742 | 1932742 | 2021-11-19 | San Lorenzo | Puerto Rico | 72129 | 2437 | |
1927136 | 1927136 | 2021-11-18 | Macon | Alabama | 1087 | 2437 | 64 |
1929476 | 1929476 | 2021-11-18 | Moca | Puerto Rico | 72099 | 2437 | |
1925445 | 1925445 | 2021-11-17 | Ste. Genevieve | Missouri | 29186 | 2437 | 29 |
1925841 | 1925841 | 2021-11-17 | Warren | North Carolina | 37185 | 2437 | 33 |
1922196 | 1922196 | 2021-11-16 | Ste. Genevieve | Missouri | 29186 | 2437 | 29 |
1907506 | 1907506 | 2021-11-11 | Burnett | Wisconsin | 55013 | 2437 | 33 |
1898907 | 1898907 | 2021-11-09 | Knott | Kentucky | 21119 | 2437 | 36 |
1897239 | 1897239 | 2021-11-08 | Bosque | Texas | 48035 | 2437 | 56 |
1891389 | 1891389 | 2021-11-07 | Macon | Alabama | 1087 | 2437 | 63 |
1893989 | 1893989 | 2021-11-07 | Bosque | Texas | 48035 | 2437 | 56 |
1890739 | 1890739 | 2021-11-06 | Bosque | Texas | 48035 | 2437 | 56 |
1870347 | 1870347 | 2021-10-31 | Saline | Nebraska | 31151 | 2437 | 6 |
1868466 | 1868466 | 2021-10-30 | Hardy | West Virginia | 54031 | 2437 | 31 |
1853252 | 1853252 | 2021-10-26 | Wright | Iowa | 19197 | 2437 | 45 |
1850003 | 1850003 | 2021-10-25 | Wright | Iowa | 19197 | 2437 | 45 |
1846753 | 1846753 | 2021-10-24 | Wright | Iowa | 19197 | 2437 | 45 |
1843503 | 1843503 | 2021-10-23 | Wright | Iowa | 19197 | 2437 | 45 |
1840253 | 1840253 | 2021-10-22 | Wright | Iowa | 19197 | 2437 | 45 |
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);