ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
162 rows where cases = 3511 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Indiana 15
- Georgia 12
- Wisconsin 11
- Texas 10
- Illinois 8
- South Carolina 8
- Mississippi 7
- Oklahoma 7
- Michigan 6
- North Carolina 6
- Alabama 5
- Arkansas 5
- Kentucky 5
- Missouri 5
- New York 5
- Virginia 5
- California 4
- Massachusetts 4
- Minnesota 4
- Washington 4
- Florida 3
- Idaho 3
- Ohio 3
- Louisiana 2
- Puerto Rico 2
- Utah 2
- West Virginia 2
- Colorado 1
- Iowa 1
- Nebraska 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2468233 | 2468233 | 2022-05-03 | Dukes | Massachusetts | 25007 | 3511 | 0 |
2424502 | 2424502 | 2022-04-19 | Klickitat | Washington | 53039 | 3511 | 45 |
2421246 | 2421246 | 2022-04-18 | Klickitat | Washington | 53039 | 3511 | 45 |
2418070 | 2418070 | 2022-04-17 | Buffalo | Wisconsin | 55011 | 3511 | 12 |
2414814 | 2414814 | 2022-04-16 | Buffalo | Wisconsin | 55011 | 3511 | 12 |
2411558 | 2411558 | 2022-04-15 | Buffalo | Wisconsin | 55011 | 3511 | 12 |
2325074 | 2325074 | 2022-03-20 | Kalkaska | Michigan | 26079 | 3511 | 60 |
2321820 | 2321820 | 2022-03-19 | Kalkaska | Michigan | 26079 | 3511 | 60 |
2318566 | 2318566 | 2022-03-18 | Kalkaska | Michigan | 26079 | 3511 | 60 |
2315313 | 2315313 | 2022-03-17 | Kalkaska | Michigan | 26079 | 3511 | 59 |
2312060 | 2312060 | 2022-03-16 | Kalkaska | Michigan | 26079 | 3511 | 59 |
2288797 | 2288797 | 2022-03-09 | Tipton | Indiana | 18159 | 3511 | 87 |
2285546 | 2285546 | 2022-03-08 | Tipton | Indiana | 18159 | 3511 | 86 |
2282294 | 2282294 | 2022-03-07 | Tipton | Indiana | 18159 | 3511 | 86 |
2265639 | 2265639 | 2022-03-02 | Bacon | Georgia | 13005 | 3511 | 72 |
2259758 | 2259758 | 2022-02-28 | Breathitt | Kentucky | 21025 | 3511 | 50 |
2240305 | 2240305 | 2022-02-22 | Leslie | Kentucky | 21131 | 3511 | 39 |
2238919 | 2238919 | 2022-02-21 | Alleghany | Virginia | 51005 | 3511 | 92 |
2214622 | 2214622 | 2022-02-14 | Renville | Minnesota | 27129 | 3511 | 54 |
2172291 | 2172291 | 2022-02-01 | Faribault | Minnesota | 27043 | 3511 | 45 |
2150680 | 2150680 | 2022-01-25 | Oglala Lakota | South Dakota | 46102 | 3511 | 55 |
2127558 | 2127558 | 2022-01-18 | Craig | Oklahoma | 40035 | 3511 | 39 |
2124306 | 2124306 | 2022-01-17 | Craig | Oklahoma | 40035 | 3511 | 39 |
2121054 | 2121054 | 2022-01-16 | Craig | Oklahoma | 40035 | 3511 | 39 |
2117802 | 2117802 | 2022-01-15 | Craig | Oklahoma | 40035 | 3511 | 39 |
2114551 | 2114551 | 2022-01-14 | Craig | Oklahoma | 40035 | 3511 | 39 |
2111299 | 2111299 | 2022-01-13 | Craig | Oklahoma | 40035 | 3511 | 39 |
2108047 | 2108047 | 2022-01-12 | Craig | Oklahoma | 40035 | 3511 | 39 |
2101735 | 2101735 | 2022-01-10 | Fajardo | Puerto Rico | 72053 | 3511 | |
2089798 | 2089798 | 2022-01-07 | Sharp | Arkansas | 5135 | 3511 | 80 |
2086378 | 2086378 | 2022-01-06 | Cherokee | Alabama | 1019 | 3511 | 66 |
2077238 | 2077238 | 2022-01-03 | Edgar | Illinois | 17045 | 3511 | 74 |
2078997 | 2078997 | 2022-01-03 | Moca | Puerto Rico | 72099 | 3511 | |
2062282 | 2062282 | 2021-12-29 | Caswell | North Carolina | 37033 | 3511 | 39 |
2051304 | 2051304 | 2021-12-26 | Union | Illinois | 17181 | 3511 | 56 |
2048054 | 2048054 | 2021-12-25 | Union | Illinois | 17181 | 3511 | 56 |
2044804 | 2044804 | 2021-12-24 | Union | Illinois | 17181 | 3511 | 56 |
2041555 | 2041555 | 2021-12-23 | Union | Illinois | 17181 | 3511 | 56 |
1998533 | 1998533 | 2021-12-09 | Green Lake | Wisconsin | 55047 | 3511 | 43 |
1992251 | 1992251 | 2021-12-08 | Lawrence | Arkansas | 5075 | 3511 | 62 |
1967851 | 1967851 | 2021-11-30 | Saunders | Nebraska | 31155 | 3511 | 23 |
1962789 | 1962789 | 2021-11-28 | Langlade | Wisconsin | 55067 | 3511 | 59 |
1959538 | 1959538 | 2021-11-27 | Langlade | Wisconsin | 55067 | 3511 | 59 |
1956287 | 1956287 | 2021-11-26 | Langlade | Wisconsin | 55067 | 3511 | 59 |
1953036 | 1953036 | 2021-11-25 | Langlade | Wisconsin | 55067 | 3511 | 59 |
1935133 | 1935133 | 2021-11-20 | Henry | Missouri | 29083 | 3511 | 62 |
1914568 | 1914568 | 2021-11-14 | Jones | Georgia | 13169 | 3511 | 95 |
1917101 | 1917101 | 2021-11-14 | Mecklenburg | Virginia | 51117 | 3511 | 86 |
1911318 | 1911318 | 2021-11-13 | Jones | Georgia | 13169 | 3511 | 95 |
1913851 | 1913851 | 2021-11-13 | Mecklenburg | Virginia | 51117 | 3511 | 86 |
1908069 | 1908069 | 2021-11-12 | Jones | Georgia | 13169 | 3511 | 95 |
1910601 | 1910601 | 2021-11-12 | Mecklenburg | Virginia | 51117 | 3511 | 86 |
1899158 | 1899158 | 2021-11-09 | Otsego | Michigan | 26137 | 3511 | 61 |
1892580 | 1892580 | 2021-11-07 | Franklin | Massachusetts | 25011 | 3511 | 123 |
1889330 | 1889330 | 2021-11-06 | Franklin | Massachusetts | 25011 | 3511 | 123 |
1886080 | 1886080 | 2021-11-05 | Franklin | Massachusetts | 25011 | 3511 | 123 |
1829493 | 1829493 | 2021-10-18 | Nicholas | West Virginia | 54067 | 3511 | 40 |
1825210 | 1825210 | 2021-10-17 | Hocking | Ohio | 39073 | 3511 | 78 |
1814158 | 1814158 | 2021-10-14 | Washington | Indiana | 18175 | 3511 | 49 |
1812858 | 1812858 | 2021-10-13 | Hutchinson | Texas | 48233 | 3511 | 85 |
1781135 | 1781135 | 2021-10-04 | Delta | Colorado | 8029 | 3511 | 79 |
1764525 | 1764525 | 2021-09-28 | Upshur | West Virginia | 54097 | 3511 | 49 |
1758252 | 1758252 | 2021-09-27 | Cleburne | Arkansas | 5023 | 3511 | 88 |
1755073 | 1755073 | 2021-09-26 | Calaveras | California | 6009 | 3511 | 70 |
1751825 | 1751825 | 2021-09-25 | Calaveras | California | 6009 | 3511 | 70 |
1748576 | 1748576 | 2021-09-24 | Calaveras | California | 6009 | 3511 | 70 |
1751084 | 1751084 | 2021-09-24 | Fayette | Texas | 48149 | 3511 | 86 |
1751156 | 1751156 | 2021-09-24 | Limestone | Texas | 48293 | 3511 | 101 |
1747835 | 1747835 | 2021-09-23 | Fayette | Texas | 48149 | 3511 | 86 |
1747907 | 1747907 | 2021-09-23 | Limestone | Texas | 48293 | 3511 | 101 |
1744585 | 1744585 | 2021-09-22 | Fayette | Texas | 48149 | 3511 | 86 |
1739064 | 1739064 | 2021-09-21 | Cook | Georgia | 13075 | 3511 | 53 |
1734232 | 1734232 | 2021-09-19 | Hardin | Ohio | 39065 | 3511 | 69 |
1723826 | 1723826 | 2021-09-16 | Grenada | Mississippi | 28043 | 3511 | 100 |
1656908 | 1656908 | 2021-08-26 | Hockley | Texas | 48219 | 3511 | 115 |
1629619 | 1629619 | 2021-08-18 | George | Mississippi | 28039 | 3511 | 57 |
1604067 | 1604067 | 2021-08-10 | Greene | New York | 36039 | 3511 | 80 |
1586004 | 1586004 | 2021-08-05 | Marion | Alabama | 1093 | 3511 | 107 |
1573127 | 1573127 | 2021-08-01 | Poinsett | Arkansas | 5111 | 3511 | 82 |
1574513 | 1574513 | 2021-08-01 | Lafayette | Missouri | 29107 | 3511 | 58 |
1554824 | 1554824 | 2021-07-26 | Freeborn | Minnesota | 27047 | 3511 | 34 |
1541956 | 1541956 | 2021-07-22 | Pike | Mississippi | 28113 | 3511 | 111 |
1492794 | 1492794 | 2021-07-07 | Boyle | Kentucky | 21021 | 3511 | 78 |
1494231 | 1494231 | 2021-07-07 | Marlboro | South Carolina | 45069 | 3511 | 59 |
1489547 | 1489547 | 2021-07-06 | Boyle | Kentucky | 21021 | 3511 | 78 |
1490984 | 1490984 | 2021-07-06 | Marlboro | South Carolina | 45069 | 3511 | 59 |
1487737 | 1487737 | 2021-07-05 | Marlboro | South Carolina | 45069 | 3511 | 59 |
1484490 | 1484490 | 2021-07-04 | Marlboro | South Carolina | 45069 | 3511 | 58 |
1481244 | 1481244 | 2021-07-03 | Marlboro | South Carolina | 45069 | 3511 | 58 |
1477997 | 1477997 | 2021-07-02 | Marlboro | South Carolina | 45069 | 3511 | 58 |
1474279 | 1474279 | 2021-07-01 | Person | North Carolina | 37145 | 3511 | 71 |
1471033 | 1471033 | 2021-06-30 | Person | North Carolina | 37145 | 3511 | 71 |
1467788 | 1467788 | 2021-06-29 | Person | North Carolina | 37145 | 3511 | 71 |
1461175 | 1461175 | 2021-06-27 | Chenango | New York | 36017 | 3511 | 76 |
1457930 | 1457930 | 2021-06-26 | Chenango | New York | 36017 | 3511 | 76 |
1419763 | 1419763 | 2021-06-14 | Bee | Texas | 48025 | 3511 | 74 |
1416518 | 1416518 | 2021-06-13 | Bee | Texas | 48025 | 3511 | 74 |
1404851 | 1404851 | 2021-06-10 | Adams | Indiana | 18001 | 3511 | 56 |
1401606 | 1401606 | 2021-06-09 | Adams | Indiana | 18001 | 3511 | 56 |
1398361 | 1398361 | 2021-06-08 | Adams | Indiana | 18001 | 3511 | 56 |
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);