ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
196 rows where cases = 2301 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 24
- Indiana 13
- Iowa 12
- Virginia 12
- Georgia 11
- Ohio 11
- Mississippi 10
- Kentucky 7
- Michigan 7
- Missouri 7
- Illinois 6
- Wisconsin 6
- Idaho 5
- Minnesota 5
- New York 5
- California 4
- North Carolina 4
- Puerto Rico 4
- Louisiana 3
- New Mexico 3
- Pennsylvania 3
- South Carolina 3
- Tennessee 3
- West Virginia 3
- Alabama 2
- Arkansas 2
- Colorado 2
- Maine 2
- Oregon 2
- Utah 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2470571 | 2470571 | 2022-05-04 | Unknown | Connecticut | 2301 | 1 | |
2465149 | 2465149 | 2022-05-02 | Swift | Minnesota | 27151 | 2301 | 33 |
2376415 | 2376415 | 2022-04-05 | Clearwater | Idaho | 16035 | 2301 | 33 |
2264759 | 2264759 | 2022-03-01 | La Salle | Texas | 48283 | 2301 | 45 |
2246860 | 2246860 | 2022-02-24 | Wolfe | Kentucky | 21237 | 2301 | 18 |
2243609 | 2243609 | 2022-02-23 | Wolfe | Kentucky | 21237 | 2301 | 18 |
2201511 | 2201511 | 2022-02-10 | Mackinac | Michigan | 26097 | 2301 | 28 |
2198257 | 2198257 | 2022-02-09 | Mackinac | Michigan | 26097 | 2301 | 28 |
2180417 | 2180417 | 2022-02-03 | Floyd | Virginia | 51063 | 2301 | 33 |
2167078 | 2167078 | 2022-01-30 | Blanco | Texas | 48031 | 2301 | 29 |
2155809 | 2155809 | 2022-01-27 | East Carroll | Louisiana | 22035 | 2301 | 35 |
2154271 | 2154271 | 2022-01-26 | Trinity | Texas | 48455 | 2301 | 67 |
2154306 | 2154306 | 2022-01-26 | Emery | Utah | 49015 | 2301 | 25 |
2151139 | 2151139 | 2022-01-25 | Franklin city | Virginia | 51620 | 2301 | 43 |
2122354 | 2122354 | 2022-01-17 | Plumas | California | 6063 | 2301 | 12 |
2081084 | 2081084 | 2022-01-04 | Kent | Maryland | 24029 | 2301 | 59 |
2059340 | 2059340 | 2021-12-28 | Baker | Oregon | 41001 | 2301 | 36 |
2055392 | 2055392 | 2021-12-27 | Dent | Missouri | 29065 | 2301 | 63 |
2042767 | 2042767 | 2021-12-23 | Yates | New York | 36123 | 2301 | 35 |
2037055 | 2037055 | 2021-12-21 | Eastland | Texas | 48133 | 2301 | 87 |
2033236 | 2033236 | 2021-12-20 | Noble | Ohio | 39121 | 2301 | 50 |
2029983 | 2029983 | 2021-12-19 | Morgan | Ohio | 39115 | 2301 | 40 |
2016198 | 2016198 | 2021-12-15 | Chippewa | Minnesota | 27023 | 2301 | 43 |
1996642 | 1996642 | 2021-12-09 | Leelanau | Michigan | 26089 | 2301 | 36 |
1998435 | 1998435 | 2021-12-09 | Klickitat | Washington | 53039 | 2301 | 30 |
1993391 | 1993391 | 2021-12-08 | Leelanau | Michigan | 26089 | 2301 | 36 |
1973670 | 1973670 | 2021-12-02 | Leslie | Kentucky | 21131 | 2301 | 31 |
1969623 | 1969623 | 2021-12-01 | Grand | Colorado | 8049 | 2301 | 16 |
1970697 | 1970697 | 2021-12-01 | Cottonwood | Minnesota | 27033 | 2301 | 32 |
1955216 | 1955216 | 2021-11-26 | Monroe | Ohio | 39111 | 2301 | 60 |
1952223 | 1952223 | 2021-11-25 | Las Piedras | Puerto Rico | 72085 | 2301 | |
1943927 | 1943927 | 2021-11-23 | Idaho | Idaho | 16049 | 2301 | 39 |
1928286 | 1928286 | 2021-11-18 | Knox | Maine | 23013 | 2301 | 14 |
1917303 | 1917303 | 2021-11-14 | Rusk | Wisconsin | 55107 | 2301 | 35 |
1914053 | 1914053 | 2021-11-13 | Rusk | Wisconsin | 55107 | 2301 | 35 |
1910803 | 1910803 | 2021-11-12 | Rusk | Wisconsin | 55107 | 2301 | 35 |
1898490 | 1898490 | 2021-11-09 | Jo Daviess | Illinois | 17085 | 2301 | 32 |
1899329 | 1899329 | 2021-11-09 | Tallahatchie | Mississippi | 28135 | 2301 | 52 |
1874660 | 1874660 | 2021-11-01 | Pecos | Texas | 48371 | 2301 | 50 |
1875010 | 1875010 | 2021-11-01 | Burnett | Wisconsin | 55013 | 2301 | 32 |
1871411 | 1871411 | 2021-10-31 | Pecos | Texas | 48371 | 2301 | 50 |
1868162 | 1868162 | 2021-10-30 | Pecos | Texas | 48371 | 2301 | 50 |
1856372 | 1856372 | 2021-10-27 | Pike | Indiana | 18125 | 2301 | 45 |
1855166 | 1855166 | 2021-10-26 | Pecos | Texas | 48371 | 2301 | 50 |
1841247 | 1841247 | 2021-10-22 | Schoharie | New York | 36095 | 2301 | 21 |
1786435 | 1786435 | 2021-10-05 | Montour | Pennsylvania | 42093 | 2301 | 68 |
1745425 | 1745425 | 2021-09-23 | Otero | Colorado | 8089 | 2301 | 71 |
1746974 | 1746974 | 2021-09-23 | San Miguel | New Mexico | 35047 | 2301 | 19 |
1735264 | 1735264 | 2021-09-19 | McDowell | West Virginia | 54047 | 2301 | 28 |
1716296 | 1716296 | 2021-09-14 | Brooks | Georgia | 13027 | 2301 | 56 |
1716716 | 1716716 | 2021-09-14 | Delaware | Iowa | 19055 | 2301 | 43 |
1718153 | 1718153 | 2021-09-14 | Wasco | Oregon | 41065 | 2301 | 38 |
1713470 | 1713470 | 2021-09-13 | Delaware | Iowa | 19055 | 2301 | 43 |
1715272 | 1715272 | 2021-09-13 | Aransas | Texas | 48007 | 2301 | 52 |
1710223 | 1710223 | 2021-09-12 | Delaware | Iowa | 19055 | 2301 | 43 |
1712026 | 1712026 | 2021-09-12 | Aransas | Texas | 48007 | 2301 | 52 |
1706976 | 1706976 | 2021-09-11 | Delaware | Iowa | 19055 | 2301 | 43 |
1703728 | 1703728 | 2021-09-10 | Delaware | Iowa | 19055 | 2301 | 43 |
1700478 | 1700478 | 2021-09-09 | Delaware | Iowa | 19055 | 2301 | 43 |
1697229 | 1697229 | 2021-09-08 | Delaware | Iowa | 19055 | 2301 | 43 |
1682556 | 1682556 | 2021-09-03 | San Lorenzo | Puerto Rico | 72129 | 2301 | |
1677675 | 1677675 | 2021-09-02 | Perry | Indiana | 18123 | 2301 | 46 |
1670344 | 1670344 | 2021-08-30 | Iowa | Wisconsin | 55049 | 2301 | 14 |
1629822 | 1629822 | 2021-08-18 | Lake | Montana | 30047 | 2301 | 41 |
1587065 | 1587065 | 2021-08-05 | Simpson | Kentucky | 21213 | 2301 | 44 |
1583198 | 1583198 | 2021-08-04 | Mitchell | Georgia | 13205 | 2301 | 85 |
1564384 | 1564384 | 2021-07-29 | St. James | Louisiana | 22093 | 2301 | 52 |
1557500 | 1557500 | 2021-07-27 | Starke | Indiana | 18149 | 2301 | 61 |
1551006 | 1551006 | 2021-07-25 | Starke | Indiana | 18149 | 2301 | 61 |
1547759 | 1547759 | 2021-07-24 | Starke | Indiana | 18149 | 2301 | 61 |
1544512 | 1544512 | 2021-07-23 | Starke | Indiana | 18149 | 2301 | 61 |
1527504 | 1527504 | 2021-07-18 | Butler | Alabama | 1013 | 2301 | 71 |
1529901 | 1529901 | 2021-07-18 | Vega Alta | Puerto Rico | 72143 | 2301 | |
1525826 | 1525826 | 2021-07-17 | Perry | Missouri | 29157 | 2301 | 30 |
1519330 | 1519330 | 2021-07-15 | Perry | Missouri | 29157 | 2301 | 30 |
1511755 | 1511755 | 2021-07-13 | Morgan | Georgia | 13211 | 2301 | 31 |
1485440 | 1485440 | 2021-07-05 | Logan | Arkansas | 5083 | 2301 | 25 |
1441345 | 1441345 | 2021-06-21 | Winston | Mississippi | 28159 | 2301 | 81 |
1438099 | 1438099 | 2021-06-20 | Winston | Mississippi | 28159 | 2301 | 81 |
1434852 | 1434852 | 2021-06-19 | Winston | Mississippi | 28159 | 2301 | 81 |
1431605 | 1431605 | 2021-06-18 | Winston | Mississippi | 28159 | 2301 | 81 |
1428827 | 1428827 | 2021-06-17 | Martin | North Carolina | 37117 | 2301 | 45 |
1430110 | 1430110 | 2021-06-17 | Uinta | Wyoming | 56041 | 2301 | 13 |
1422335 | 1422335 | 2021-06-15 | Martin | North Carolina | 37117 | 2301 | 45 |
1419089 | 1419089 | 2021-06-14 | Martin | North Carolina | 37117 | 2301 | 45 |
1420372 | 1420372 | 2021-06-14 | Uinta | Wyoming | 56041 | 2301 | 13 |
1408660 | 1408660 | 2021-06-11 | Gladwin | Michigan | 26051 | 2301 | 58 |
1410427 | 1410427 | 2021-06-11 | Russell | Virginia | 51167 | 2301 | 39 |
1405415 | 1405415 | 2021-06-10 | Gladwin | Michigan | 26051 | 2301 | 58 |
1407182 | 1407182 | 2021-06-10 | Russell | Virginia | 51167 | 2301 | 39 |
1402169 | 1402169 | 2021-06-09 | Gladwin | Michigan | 26051 | 2301 | 58 |
1403936 | 1403936 | 2021-06-09 | Russell | Virginia | 51167 | 2301 | 39 |
1400691 | 1400691 | 2021-06-08 | Russell | Virginia | 51167 | 2301 | 39 |
1392649 | 1392649 | 2021-06-06 | Tishomingo | Mississippi | 28141 | 2301 | 67 |
1389404 | 1389404 | 2021-06-05 | Tishomingo | Mississippi | 28141 | 2301 | 67 |
1386159 | 1386159 | 2021-06-04 | Tishomingo | Mississippi | 28141 | 2301 | 67 |
1382914 | 1382914 | 2021-06-03 | Tishomingo | Mississippi | 28141 | 2301 | 67 |
1345957 | 1345957 | 2021-05-23 | Siskiyou | California | 6093 | 2301 | 27 |
1346746 | 1346746 | 2021-05-23 | Carter | Kentucky | 21043 | 2301 | 35 |
1342709 | 1342709 | 2021-05-22 | Siskiyou | California | 6093 | 2301 | 27 |
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);