ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
160 rows where cases = 3185 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- West Virginia 12
- Georgia 11
- Mississippi 10
- Arkansas 9
- Virginia 8
- Iowa 7
- Minnesota 7
- Ohio 7
- Puerto Rico 7
- Tennessee 7
- Texas 7
- Michigan 6
- Nebraska 6
- Illinois 5
- Kentucky 5
- Louisiana 5
- North Carolina 5
- Washington 5
- Indiana 4
- Montana 4
- Pennsylvania 4
- Alabama 3
- South Carolina 3
- Colorado 2
- Missouri 2
- New York 2
- California 1
- Kansas 1
- Maryland 1
- Massachusetts 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2396855 | 2396855 | 2022-04-11 | Tallahatchie | Mississippi | 28135 | 3185 | 60 |
2393600 | 2393600 | 2022-04-10 | Tallahatchie | Mississippi | 28135 | 3185 | 60 |
2390344 | 2390344 | 2022-04-09 | Tallahatchie | Mississippi | 28135 | 3185 | 60 |
2387088 | 2387088 | 2022-04-08 | Tallahatchie | Mississippi | 28135 | 3185 | 60 |
2383833 | 2383833 | 2022-04-07 | Tallahatchie | Mississippi | 28135 | 3185 | 60 |
2380578 | 2380578 | 2022-04-06 | Tallahatchie | Mississippi | 28135 | 3185 | 60 |
2377323 | 2377323 | 2022-04-05 | Tallahatchie | Mississippi | 28135 | 3185 | 60 |
2374071 | 2374071 | 2022-04-04 | Tallahatchie | Mississippi | 28135 | 3185 | 60 |
2339749 | 2339749 | 2022-03-24 | Brunswick | Virginia | 51025 | 3185 | 45 |
2285570 | 2285570 | 2022-03-08 | Butler | Iowa | 19023 | 3185 | 52 |
2286011 | 2286011 | 2022-03-08 | Arenac | Michigan | 26011 | 3185 | 63 |
2282318 | 2282318 | 2022-03-07 | Butler | Iowa | 19023 | 3185 | 52 |
2282759 | 2282759 | 2022-03-07 | Arenac | Michigan | 26011 | 3185 | 63 |
2282854 | 2282854 | 2022-03-07 | Cottonwood | Minnesota | 27033 | 3185 | 41 |
2279065 | 2279065 | 2022-03-06 | Butler | Iowa | 19023 | 3185 | 52 |
2275812 | 2275812 | 2022-03-05 | Butler | Iowa | 19023 | 3185 | 52 |
2272559 | 2272559 | 2022-03-04 | Butler | Iowa | 19023 | 3185 | 52 |
2269307 | 2269307 | 2022-03-03 | Butler | Iowa | 19023 | 3185 | 52 |
2266054 | 2266054 | 2022-03-02 | Butler | Iowa | 19023 | 3185 | 52 |
2264118 | 2264118 | 2022-03-01 | Noble | Ohio | 39121 | 3185 | 54 |
2239509 | 2239509 | 2022-02-22 | Gunnison | Colorado | 8051 | 3185 | 14 |
2237644 | 2237644 | 2022-02-21 | Roosevelt | Montana | 30085 | 3185 | 70 |
2234393 | 2234393 | 2022-02-20 | Roosevelt | Montana | 30085 | 3185 | 70 |
2231142 | 2231142 | 2022-02-19 | Roosevelt | Montana | 30085 | 3185 | 70 |
2227891 | 2227891 | 2022-02-18 | Roosevelt | Montana | 30085 | 3185 | 70 |
2223134 | 2223134 | 2022-02-17 | Little River | Arkansas | 5081 | 3185 | 86 |
2225080 | 2225080 | 2022-02-17 | Harrison | Ohio | 39067 | 3185 | 68 |
2157093 | 2157093 | 2022-01-27 | Bamberg | South Carolina | 45009 | 3185 | 66 |
2150562 | 2150562 | 2022-01-25 | San German | Puerto Rico | 72125 | 3185 | |
2147310 | 2147310 | 2022-01-24 | San German | Puerto Rico | 72125 | 3185 | |
2143422 | 2143422 | 2022-01-23 | York | Nebraska | 31185 | 3185 | 19 |
2140167 | 2140167 | 2022-01-22 | York | Nebraska | 31185 | 3185 | 19 |
2136911 | 2136911 | 2022-01-21 | York | Nebraska | 31185 | 3185 | 19 |
2131589 | 2131589 | 2022-01-19 | Buckingham | Virginia | 51029 | 3185 | 41 |
2086616 | 2086616 | 2022-01-06 | Alamosa | Colorado | 8003 | 3185 | 56 |
2082237 | 2082237 | 2022-01-04 | Juana Diaz | Puerto Rico | 72075 | 3185 | |
2076425 | 2076425 | 2022-01-02 | Asotin | Washington | 53003 | 3185 | 52 |
2073174 | 2073174 | 2022-01-01 | Asotin | Washington | 53003 | 3185 | 52 |
2069923 | 2069923 | 2021-12-31 | Asotin | Washington | 53003 | 3185 | 52 |
2065989 | 2065989 | 2021-12-30 | Manati | Puerto Rico | 72091 | 3185 | |
2066672 | 2066672 | 2021-12-30 | Asotin | Washington | 53003 | 3185 | 52 |
2053712 | 2053712 | 2021-12-26 | Barbour | West Virginia | 54001 | 3185 | 55 |
2050462 | 2050462 | 2021-12-25 | Barbour | West Virginia | 54001 | 3185 | 55 |
2047212 | 2047212 | 2021-12-24 | Barbour | West Virginia | 54001 | 3185 | 55 |
2043962 | 2043962 | 2021-12-23 | Barbour | West Virginia | 54001 | 3185 | 55 |
2040055 | 2040055 | 2021-12-22 | Hampton | South Carolina | 45049 | 3185 | 75 |
2036207 | 2036207 | 2021-12-21 | Taos | New Mexico | 35055 | 3185 | 72 |
2034143 | 2034143 | 2021-12-20 | Radford city | Virginia | 51750 | 3185 | 38 |
2029156 | 2029156 | 2021-12-19 | Manistee | Michigan | 26101 | 3185 | 56 |
2025905 | 2025905 | 2021-12-18 | Manistee | Michigan | 26101 | 3185 | 56 |
2022654 | 2022654 | 2021-12-17 | Manistee | Michigan | 26101 | 3185 | 56 |
1997217 | 1997217 | 2021-12-09 | Essex | New York | 36031 | 3185 | 42 |
1972635 | 1972635 | 2021-12-02 | Hale | Alabama | 1065 | 3185 | 89 |
1962722 | 1962722 | 2021-11-28 | Lincoln | West Virginia | 54043 | 3185 | 50 |
1959471 | 1959471 | 2021-11-27 | Lincoln | West Virginia | 54043 | 3185 | 50 |
1956220 | 1956220 | 2021-11-26 | Lincoln | West Virginia | 54043 | 3185 | 50 |
1952969 | 1952969 | 2021-11-25 | Lincoln | West Virginia | 54043 | 3185 | 50 |
1949718 | 1949718 | 2021-11-24 | Lincoln | West Virginia | 54043 | 3185 | 50 |
1935893 | 1935893 | 2021-11-20 | Juniata | Pennsylvania | 42067 | 3185 | 122 |
1900460 | 1900460 | 2021-11-09 | Trousdale | Tennessee | 47169 | 3185 | 26 |
1871433 | 1871433 | 2021-10-31 | Scurry | Texas | 48415 | 3185 | 82 |
1868184 | 1868184 | 2021-10-30 | Scurry | Texas | 48415 | 3185 | 82 |
1864935 | 1864935 | 2021-10-29 | Scurry | Texas | 48415 | 3185 | 82 |
1859583 | 1859583 | 2021-10-28 | Fulton | Indiana | 18049 | 3185 | 68 |
1861686 | 1861686 | 2021-10-28 | Scurry | Texas | 48415 | 3185 | 82 |
1858203 | 1858203 | 2021-10-27 | Polk | Tennessee | 47139 | 3185 | 31 |
1839168 | 1839168 | 2021-10-21 | Adams | Washington | 53001 | 3185 | 31 |
1832361 | 1832361 | 2021-10-19 | Jones | Texas | 48253 | 3185 | 70 |
1827497 | 1827497 | 2021-10-18 | Concordia | Louisiana | 22029 | 3185 | 77 |
1827733 | 1827733 | 2021-10-18 | Martin | Minnesota | 27091 | 3185 | 34 |
1824248 | 1824248 | 2021-10-17 | Concordia | Louisiana | 22029 | 3185 | 77 |
1820999 | 1820999 | 2021-10-16 | Concordia | Louisiana | 22029 | 3185 | 77 |
1817750 | 1817750 | 2021-10-15 | Concordia | Louisiana | 22029 | 3185 | 77 |
1811656 | 1811656 | 2021-10-13 | Henry | Missouri | 29083 | 3185 | 49 |
1807409 | 1807409 | 2021-10-12 | Washington | Georgia | 13303 | 3185 | 112 |
1762482 | 1762482 | 2021-09-28 | Rowan | Kentucky | 21205 | 3185 | 26 |
1760039 | 1760039 | 2021-09-27 | Ashe | North Carolina | 37009 | 3185 | 46 |
1754025 | 1754025 | 2021-09-25 | Rio Grande | Puerto Rico | 72119 | 3185 | |
1727737 | 1727737 | 2021-09-17 | Holmes | Ohio | 39075 | 3185 | 108 |
1717378 | 1717378 | 2021-09-14 | Tishomingo | Mississippi | 28141 | 3185 | 87 |
1705670 | 1705670 | 2021-09-10 | Lampasas | Texas | 48281 | 3185 | 49 |
1668208 | 1668208 | 2021-08-30 | Grant | Kentucky | 21081 | 3185 | 27 |
1669819 | 1669819 | 2021-08-30 | Calhoun | Texas | 48057 | 3185 | 26 |
1648362 | 1648362 | 2021-08-24 | Saline | Illinois | 17165 | 3185 | 75 |
1648892 | 1648892 | 2021-08-24 | Dorchester | Maryland | 24019 | 3185 | 66 |
1644323 | 1644323 | 2021-08-22 | Randolph | West Virginia | 54083 | 3185 | 18 |
1641073 | 1641073 | 2021-08-21 | Randolph | West Virginia | 54083 | 3185 | 18 |
1637823 | 1637823 | 2021-08-20 | Randolph | West Virginia | 54083 | 3185 | 18 |
1624623 | 1624623 | 2021-08-16 | Amherst | Virginia | 51009 | 3185 | 40 |
1584150 | 1584150 | 2021-08-04 | Itawamba | Mississippi | 28057 | 3185 | 81 |
1563363 | 1563363 | 2021-07-29 | Johnson | Arkansas | 5071 | 3185 | 39 |
1520214 | 1520214 | 2021-07-15 | Union | South Carolina | 45087 | 3185 | 84 |
1516176 | 1516176 | 2021-07-14 | Adams | Nebraska | 31001 | 3185 | 54 |
1516466 | 1516466 | 2021-07-14 | Macon | North Carolina | 37113 | 3185 | 41 |
1512930 | 1512930 | 2021-07-13 | Adams | Nebraska | 31001 | 3185 | 54 |
1495546 | 1495546 | 2021-07-08 | Stephens | Georgia | 13257 | 3185 | 81 |
1496036 | 1496036 | 2021-07-08 | Bell | Kentucky | 21013 | 3185 | 58 |
1492300 | 1492300 | 2021-07-07 | Stephens | Georgia | 13257 | 3185 | 81 |
1489053 | 1489053 | 2021-07-06 | Stephens | Georgia | 13257 | 3185 | 81 |
1489543 | 1489543 | 2021-07-06 | Bell | Kentucky | 21013 | 3185 | 58 |
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);