ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
222 rows where cases = 2262 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 21
- Idaho 17
- North Carolina 14
- Colorado 11
- Alabama 10
- Georgia 9
- Illinois 9
- Iowa 9
- Mississippi 9
- Missouri 9
- Kentucky 8
- Virginia 8
- Michigan 7
- Puerto Rico 7
- Tennessee 7
- Kansas 6
- Florida 5
- Louisiana 5
- Arkansas 4
- Nebraska 4
- Pennsylvania 4
- West Virginia 4
- Indiana 3
- Maryland 3
- Minnesota 3
- New York 3
- New Jersey 2
- New Mexico 2
- Ohio 2
- South Carolina 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2467930 | 2467930 | 2022-05-03 | Grant | Kansas | 20067 | 2262 | 36 |
2464675 | 2464675 | 2022-05-02 | Grant | Kansas | 20067 | 2262 | 36 |
2447364 | 2447364 | 2022-04-26 | Webster | West Virginia | 54101 | 2262 | 33 |
2444108 | 2444108 | 2022-04-25 | Webster | West Virginia | 54101 | 2262 | 33 |
2399443 | 2399443 | 2022-04-12 | Clarke | Iowa | 19039 | 2262 | 37 |
2396187 | 2396187 | 2022-04-11 | Clarke | Iowa | 19039 | 2262 | 37 |
2392932 | 2392932 | 2022-04-10 | Clarke | Iowa | 19039 | 2262 | 37 |
2389676 | 2389676 | 2022-04-09 | Clarke | Iowa | 19039 | 2262 | 37 |
2386420 | 2386420 | 2022-04-08 | Clarke | Iowa | 19039 | 2262 | 37 |
2383166 | 2383166 | 2022-04-07 | Clarke | Iowa | 19039 | 2262 | 37 |
2379396 | 2379396 | 2022-04-06 | San Miguel | Colorado | 8113 | 2262 | 8 |
2379911 | 2379911 | 2022-04-06 | Clarke | Iowa | 19039 | 2262 | 37 |
2376142 | 2376142 | 2022-04-05 | San Miguel | Colorado | 8113 | 2262 | 8 |
2372890 | 2372890 | 2022-04-04 | San Miguel | Colorado | 8113 | 2262 | 8 |
2359327 | 2359327 | 2022-03-30 | Madison | Virginia | 51113 | 2262 | 37 |
2347039 | 2347039 | 2022-03-27 | Lanier | Georgia | 13173 | 2262 | 24 |
2347157 | 2347157 | 2022-03-27 | Owyhee | Idaho | 16073 | 2262 | 52 |
2343786 | 2343786 | 2022-03-26 | Lanier | Georgia | 13173 | 2262 | 24 |
2343904 | 2343904 | 2022-03-26 | Owyhee | Idaho | 16073 | 2262 | 52 |
2340533 | 2340533 | 2022-03-25 | Lanier | Georgia | 13173 | 2262 | 24 |
2340651 | 2340651 | 2022-03-25 | Owyhee | Idaho | 16073 | 2262 | 52 |
2337280 | 2337280 | 2022-03-24 | Lanier | Georgia | 13173 | 2262 | 24 |
2334026 | 2334026 | 2022-03-23 | Lanier | Georgia | 13173 | 2262 | 24 |
2330890 | 2330890 | 2022-03-22 | Owyhee | Idaho | 16073 | 2262 | 52 |
2327638 | 2327638 | 2022-03-21 | Owyhee | Idaho | 16073 | 2262 | 52 |
2324385 | 2324385 | 2022-03-20 | Owyhee | Idaho | 16073 | 2262 | 52 |
2321131 | 2321131 | 2022-03-19 | Owyhee | Idaho | 16073 | 2262 | 52 |
2317877 | 2317877 | 2022-03-18 | Owyhee | Idaho | 16073 | 2262 | 52 |
2314624 | 2314624 | 2022-03-17 | Owyhee | Idaho | 16073 | 2262 | 52 |
2311371 | 2311371 | 2022-03-16 | Owyhee | Idaho | 16073 | 2262 | 52 |
2308118 | 2308118 | 2022-03-15 | Owyhee | Idaho | 16073 | 2262 | 52 |
2306934 | 2306934 | 2022-03-14 | Castro | Texas | 48069 | 2262 | 46 |
2307163 | 2307163 | 2022-03-14 | Grand | Utah | 49019 | 2262 | 6 |
2303683 | 2303683 | 2022-03-13 | Castro | Texas | 48069 | 2262 | 46 |
2300431 | 2300431 | 2022-03-12 | Castro | Texas | 48069 | 2262 | 46 |
2297179 | 2297179 | 2022-03-11 | Castro | Texas | 48069 | 2262 | 46 |
2293927 | 2293927 | 2022-03-10 | Castro | Texas | 48069 | 2262 | 46 |
2286705 | 2286705 | 2022-03-08 | Graham | North Carolina | 37075 | 2262 | 30 |
2262168 | 2262168 | 2022-03-01 | Scott | Arkansas | 5127 | 2262 | 38 |
2240358 | 2240358 | 2022-02-22 | Wolfe | Kentucky | 21237 | 2262 | 18 |
2220176 | 2220176 | 2022-02-16 | Evans | Georgia | 13109 | 2262 | 62 |
2171430 | 2171430 | 2022-02-01 | McIntosh | Georgia | 13191 | 2262 | 35 |
2171854 | 2171854 | 2022-02-01 | Coffey | Kansas | 20031 | 2262 | 37 |
2168601 | 2168601 | 2022-01-31 | Coffey | Kansas | 20031 | 2262 | 37 |
2170193 | 2170193 | 2022-01-31 | Lake | South Dakota | 46079 | 2262 | 26 |
2134578 | 2134578 | 2022-01-20 | Dawson | Texas | 48115 | 2262 | 83 |
2126029 | 2126029 | 2022-01-18 | Jasper | Illinois | 17079 | 2262 | 26 |
2112979 | 2112979 | 2022-01-14 | Teton | Idaho | 16081 | 2262 | 8 |
2107395 | 2107395 | 2022-01-12 | Cedar | Missouri | 29039 | 2262 | 43 |
2060646 | 2060646 | 2021-12-29 | Moffat | Colorado | 8081 | 2262 | 48 |
2019379 | 2019379 | 2021-12-16 | Gogebic | Michigan | 26053 | 2262 | 60 |
2016129 | 2016129 | 2021-12-15 | Gogebic | Michigan | 26053 | 2262 | 60 |
2013400 | 2013400 | 2021-12-14 | Unknown | New Hampshire | 2262 | 15 | |
1989814 | 1989814 | 2021-12-07 | Nemaha | Kansas | 20131 | 2262 | 56 |
1986564 | 1986564 | 2021-12-06 | Nemaha | Kansas | 20131 | 2262 | 56 |
1937115 | 1937115 | 2021-11-21 | Grand | Colorado | 8049 | 2262 | 16 |
1933865 | 1933865 | 2021-11-20 | Grand | Colorado | 8049 | 2262 | 16 |
1930613 | 1930613 | 2021-11-19 | Grand | Colorado | 8049 | 2262 | 16 |
1910697 | 1910697 | 2021-11-12 | Braxton | West Virginia | 54007 | 2262 | 22 |
1895980 | 1895980 | 2021-11-08 | Pennington | Minnesota | 27113 | 2262 | 29 |
1880389 | 1880389 | 2021-11-03 | Ramsey | North Dakota | 38071 | 2262 | 37 |
1839300 | 1839300 | 2021-10-21 | Marquette | Wisconsin | 55077 | 2262 | 32 |
1821753 | 1821753 | 2021-10-16 | Schoharie | New York | 36095 | 2262 | 21 |
1805367 | 1805367 | 2021-10-11 | Seward | Nebraska | 31159 | 2262 | 38 |
1802118 | 1802118 | 2021-10-10 | Seward | Nebraska | 31159 | 2262 | 38 |
1798869 | 1798869 | 2021-10-09 | Seward | Nebraska | 31159 | 2262 | 38 |
1795620 | 1795620 | 2021-10-08 | Seward | Nebraska | 31159 | 2262 | 38 |
1770251 | 1770251 | 2021-09-30 | Las Piedras | Puerto Rico | 72085 | 2262 | |
1745148 | 1745148 | 2021-09-23 | Clay | Alabama | 1027 | 2262 | 64 |
1741186 | 1741186 | 2021-09-21 | Decatur | Tennessee | 47039 | 2262 | 41 |
1737937 | 1737937 | 2021-09-20 | Decatur | Tennessee | 47039 | 2262 | 41 |
1734051 | 1734051 | 2021-09-19 | Bertie | North Carolina | 37015 | 2262 | 47 |
1730801 | 1730801 | 2021-09-18 | Bertie | North Carolina | 37015 | 2262 | 47 |
1727551 | 1727551 | 2021-09-17 | Bertie | North Carolina | 37015 | 2262 | 47 |
1723503 | 1723503 | 2021-09-16 | Union | Kentucky | 21225 | 2262 | 21 |
1696035 | 1696035 | 2021-09-07 | Zavala | Texas | 48507 | 2262 | 48 |
1692787 | 1692787 | 2021-09-06 | Zavala | Texas | 48507 | 2262 | 47 |
1689538 | 1689538 | 2021-09-05 | Zavala | Texas | 48507 | 2262 | 47 |
1686288 | 1686288 | 2021-09-04 | Zavala | Texas | 48507 | 2262 | 47 |
1678914 | 1678914 | 2021-09-02 | Yancey | North Carolina | 37199 | 2262 | 28 |
1674361 | 1674361 | 2021-09-01 | White | Illinois | 17193 | 2262 | 37 |
1675166 | 1675166 | 2021-09-01 | Benton | Missouri | 29015 | 2262 | 40 |
1675490 | 1675490 | 2021-09-01 | Lincoln | New Mexico | 35027 | 2262 | 22 |
1659721 | 1659721 | 2021-08-27 | Juniata | Pennsylvania | 42067 | 2262 | 90 |
1653841 | 1653841 | 2021-08-25 | Franklin | Vermont | 50011 | 2262 | 40 |
1653870 | 1653870 | 2021-08-25 | Buckingham | Virginia | 51029 | 2262 | 33 |
1650035 | 1650035 | 2021-08-24 | Corozal | Puerto Rico | 72047 | 2262 | |
1650377 | 1650377 | 2021-08-24 | Falls | Texas | 48145 | 2262 | 34 |
1645580 | 1645580 | 2021-08-23 | LaSalle | Louisiana | 22059 | 2262 | 39 |
1642748 | 1642748 | 2021-08-22 | Moniteau | Missouri | 29135 | 2262 | 33 |
1631720 | 1631720 | 2021-08-19 | Montezuma | Colorado | 8083 | 2262 | 28 |
1633268 | 1633268 | 2021-08-19 | Roosevelt | New Mexico | 35041 | 2262 | 61 |
1633873 | 1633873 | 2021-08-19 | Hampton | South Carolina | 45049 | 2262 | 54 |
1624792 | 1624792 | 2021-08-16 | Boone | West Virginia | 54005 | 2262 | 36 |
1613171 | 1613171 | 2021-08-13 | Talbot | Maryland | 24041 | 2262 | 46 |
1597292 | 1597292 | 2021-08-08 | Ray | Missouri | 29177 | 2262 | 37 |
1583758 | 1583758 | 2021-08-04 | Hart | Kentucky | 21099 | 2262 | 55 |
1561076 | 1561076 | 2021-07-28 | Simpson | Kentucky | 21213 | 2262 | 43 |
1559261 | 1559261 | 2021-07-27 | Chester | Tennessee | 47023 | 2262 | 51 |
1543882 | 1543882 | 2021-07-23 | Lawrence | Arkansas | 5075 | 2262 | 43 |
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);