ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
166 rows where cases = 3988 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kansas 22
- Tennessee 16
- Texas 16
- Illinois 11
- Oklahoma 11
- Louisiana 9
- Minnesota 8
- Ohio 6
- Pennsylvania 5
- Utah 5
- Virginia 5
- Alabama 4
- Arkansas 4
- Indiana 4
- Alaska 3
- Florida 3
- Georgia 3
- Kentucky 3
- Mississippi 3
- Missouri 3
- California 2
- Michigan 2
- New York 2
- South Carolina 2
- West Virginia 2
- Wisconsin 2
- Idaho 1
- Massachusetts 1
- Montana 1
- Nebraska 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499532 | 2499532 | 2022-05-12 | Richland | Wisconsin | 55103 | 3988 | 48 |
2492752 | 2492752 | 2022-05-10 | Buckingham | Virginia | 51029 | 3988 | 57 |
2489494 | 2489494 | 2022-05-09 | Buckingham | Virginia | 51029 | 3988 | 57 |
2469565 | 2469565 | 2022-05-03 | Grundy | Tennessee | 47061 | 3988 | 73 |
2466309 | 2466309 | 2022-05-02 | Grundy | Tennessee | 47061 | 3988 | 73 |
2463054 | 2463054 | 2022-05-01 | Grundy | Tennessee | 47061 | 3988 | 73 |
2459798 | 2459798 | 2022-04-30 | Grundy | Tennessee | 47061 | 3988 | 73 |
2456542 | 2456542 | 2022-04-29 | Grundy | Tennessee | 47061 | 3988 | 73 |
2453286 | 2453286 | 2022-04-28 | Grundy | Tennessee | 47061 | 3988 | 73 |
2450030 | 2450030 | 2022-04-27 | Grundy | Tennessee | 47061 | 3988 | 73 |
2447193 | 2447193 | 2022-04-26 | Greene | Virginia | 51079 | 3988 | 61 |
2424583 | 2424583 | 2022-04-19 | Burnett | Wisconsin | 55013 | 3988 | 43 |
2347259 | 2347259 | 2022-03-27 | Warren | Illinois | 17187 | 3988 | 85 |
2344006 | 2344006 | 2022-03-26 | Warren | Illinois | 17187 | 3988 | 85 |
2340753 | 2340753 | 2022-03-25 | Warren | Illinois | 17187 | 3988 | 85 |
2280997 | 2280997 | 2022-03-06 | Houston | Texas | 48225 | 3988 | 107 |
2277744 | 2277744 | 2022-03-05 | Houston | Texas | 48225 | 3988 | 107 |
2259805 | 2259805 | 2022-02-28 | Knott | Kentucky | 21119 | 3988 | 55 |
2225027 | 2225027 | 2022-02-17 | Richland | North Dakota | 38077 | 3988 | 21 |
2209021 | 2209021 | 2022-02-12 | Fulton | Pennsylvania | 42057 | 3988 | 62 |
2200340 | 2200340 | 2022-02-10 | Clay | Arkansas | 5021 | 3988 | 81 |
2202570 | 2202570 | 2022-02-10 | Catano | Puerto Rico | 72033 | 3988 | |
2150699 | 2150699 | 2022-01-25 | Bledsoe | Tennessee | 47007 | 3988 | 41 |
2147447 | 2147447 | 2022-01-24 | Bledsoe | Tennessee | 47007 | 3988 | 41 |
2143775 | 2143775 | 2022-01-23 | Meigs | Ohio | 39105 | 3988 | 74 |
2144193 | 2144193 | 2022-01-23 | Bledsoe | Tennessee | 47007 | 3988 | 41 |
2144468 | 2144468 | 2022-01-23 | Panola | Texas | 48365 | 3988 | 115 |
2140938 | 2140938 | 2022-01-22 | Bledsoe | Tennessee | 47007 | 3988 | 41 |
2137682 | 2137682 | 2022-01-21 | Bledsoe | Tennessee | 47007 | 3988 | 41 |
2134428 | 2134428 | 2022-01-20 | Bledsoe | Tennessee | 47007 | 3988 | 41 |
2131176 | 2131176 | 2022-01-19 | Bledsoe | Tennessee | 47007 | 3988 | 41 |
2118347 | 2118347 | 2022-01-15 | Gonzales | Texas | 48177 | 3988 | 91 |
2106026 | 2106026 | 2022-01-12 | Lawrence | Arkansas | 5075 | 3988 | 64 |
2098424 | 2098424 | 2022-01-09 | Juniata | Pennsylvania | 42067 | 3988 | 152 |
2086532 | 2086532 | 2022-01-06 | Ouachita | Arkansas | 5103 | 3988 | 91 |
1988502 | 1988502 | 2021-12-06 | Sevier | Utah | 49041 | 3988 | 19 |
1985252 | 1985252 | 2021-12-05 | Sevier | Utah | 49041 | 3988 | 19 |
1982002 | 1982002 | 2021-12-04 | Sevier | Utah | 49041 | 3988 | 19 |
1978752 | 1978752 | 2021-12-03 | Sevier | Utah | 49041 | 3988 | 19 |
1975704 | 1975704 | 2021-12-02 | Boone | West Virginia | 54005 | 3988 | 62 |
1971797 | 1971797 | 2021-12-01 | Jasper | South Carolina | 45053 | 3988 | 82 |
1967263 | 1967263 | 2021-11-30 | Pointe Coupee | Louisiana | 22077 | 3988 | 85 |
1964011 | 1964011 | 2021-11-29 | Pointe Coupee | Louisiana | 22077 | 3988 | 84 |
1960263 | 1960263 | 2021-11-28 | McDonough | Illinois | 17109 | 3988 | 78 |
1957012 | 1957012 | 2021-11-27 | McDonough | Illinois | 17109 | 3988 | 78 |
1953761 | 1953761 | 2021-11-26 | McDonough | Illinois | 17109 | 3988 | 78 |
1950510 | 1950510 | 2021-11-25 | McDonough | Illinois | 17109 | 3988 | 78 |
1947259 | 1947259 | 2021-11-24 | McDonough | Illinois | 17109 | 3988 | 78 |
1904422 | 1904422 | 2021-11-11 | Juneau City and Borough | Alaska | 2110 | 3988 | 11 |
1901172 | 1901172 | 2021-11-10 | Juneau City and Borough | Alaska | 2110 | 3988 | 11 |
1898914 | 1898914 | 2021-11-09 | Letcher | Kentucky | 21133 | 3988 | 70 |
1874966 | 1874966 | 2021-11-01 | Jackson | West Virginia | 54035 | 3988 | 87 |
1837512 | 1837512 | 2021-10-21 | Todd | Minnesota | 27153 | 3988 | 36 |
1838853 | 1838853 | 2021-10-21 | Jasper | Texas | 48241 | 3988 | 148 |
1835604 | 1835604 | 2021-10-20 | Jasper | Texas | 48241 | 3988 | 148 |
1832355 | 1832355 | 2021-10-19 | Jasper | Texas | 48241 | 3988 | 147 |
1829106 | 1829106 | 2021-10-18 | Jasper | Texas | 48241 | 3988 | 147 |
1824447 | 1824447 | 2021-10-17 | Brown | Minnesota | 27015 | 3988 | 46 |
1825857 | 1825857 | 2021-10-17 | Jasper | Texas | 48241 | 3988 | 147 |
1821198 | 1821198 | 2021-10-16 | Brown | Minnesota | 27015 | 3988 | 46 |
1822608 | 1822608 | 2021-10-16 | Jasper | Texas | 48241 | 3988 | 147 |
1817949 | 1817949 | 2021-10-15 | Brown | Minnesota | 27015 | 3988 | 46 |
1819359 | 1819359 | 2021-10-15 | Jasper | Texas | 48241 | 3988 | 147 |
1765348 | 1765348 | 2021-09-29 | Decatur | Indiana | 18031 | 3988 | 103 |
1760631 | 1760631 | 2021-09-27 | Lawrence | South Dakota | 46081 | 3988 | 53 |
1747693 | 1747693 | 2021-09-23 | Grainger | Tennessee | 47057 | 3988 | 57 |
1739223 | 1739223 | 2021-09-21 | Latah | Idaho | 16057 | 3988 | 23 |
1715932 | 1715932 | 2021-09-14 | Lawrence | Alabama | 1079 | 3988 | 101 |
1697887 | 1697887 | 2021-09-08 | Sunflower | Mississippi | 28133 | 3988 | 102 |
1693275 | 1693275 | 2021-09-07 | Carroll | Arkansas | 5015 | 3988 | 61 |
1682465 | 1682465 | 2021-09-03 | McKean | Pennsylvania | 42083 | 3988 | 75 |
1608305 | 1608305 | 2021-08-11 | Upshur | Texas | 48459 | 3988 | 78 |
1591064 | 1591064 | 2021-08-06 | Cortland | New York | 36023 | 3988 | 64 |
1582896 | 1582896 | 2021-08-04 | Amador | California | 6005 | 3988 | 48 |
1585768 | 1585768 | 2021-08-04 | York | Virginia | 51199 | 3988 | 59 |
1581587 | 1581587 | 2021-08-03 | Preble | Ohio | 39135 | 3988 | 107 |
1558927 | 1558927 | 2021-07-27 | Okmulgee | Oklahoma | 40111 | 3988 | 85 |
1555680 | 1555680 | 2021-07-26 | Okmulgee | Oklahoma | 40111 | 3988 | 85 |
1556330 | 1556330 | 2021-07-26 | Uvalde | Texas | 48463 | 3988 | 73 |
1552433 | 1552433 | 2021-07-25 | Okmulgee | Oklahoma | 40111 | 3988 | 85 |
1549186 | 1549186 | 2021-07-24 | Okmulgee | Oklahoma | 40111 | 3988 | 85 |
1545939 | 1545939 | 2021-07-23 | Okmulgee | Oklahoma | 40111 | 3988 | 85 |
1542692 | 1542692 | 2021-07-22 | Okmulgee | Oklahoma | 40111 | 3988 | 85 |
1539444 | 1539444 | 2021-07-21 | Okmulgee | Oklahoma | 40111 | 3988 | 85 |
1535978 | 1535978 | 2021-07-20 | Scotland | North Carolina | 37165 | 3988 | 88 |
1492927 | 1492927 | 2021-07-07 | Iberville | Louisiana | 22047 | 3988 | 100 |
1489935 | 1489935 | 2021-07-06 | Steele | Minnesota | 27147 | 3988 | 19 |
1486272 | 1486272 | 2021-07-05 | Seward | Kansas | 20175 | 3988 | 42 |
1483026 | 1483026 | 2021-07-04 | Seward | Kansas | 20175 | 3988 | 42 |
1479779 | 1479779 | 2021-07-03 | Seward | Kansas | 20175 | 3988 | 42 |
1476533 | 1476533 | 2021-07-02 | Seward | Kansas | 20175 | 3988 | 42 |
1473287 | 1473287 | 2021-07-01 | Seward | Kansas | 20175 | 3988 | 42 |
1470041 | 1470041 | 2021-06-30 | Seward | Kansas | 20175 | 3988 | 41 |
1466796 | 1466796 | 2021-06-29 | Seward | Kansas | 20175 | 3988 | 41 |
1463551 | 1463551 | 2021-06-28 | Seward | Kansas | 20175 | 3988 | 41 |
1460306 | 1460306 | 2021-06-27 | Seward | Kansas | 20175 | 3988 | 41 |
1457061 | 1457061 | 2021-06-26 | Seward | Kansas | 20175 | 3988 | 41 |
1453816 | 1453816 | 2021-06-25 | Seward | Kansas | 20175 | 3988 | 41 |
1450570 | 1450570 | 2021-06-24 | Seward | Kansas | 20175 | 3988 | 41 |
1446996 | 1446996 | 2021-06-23 | Logan | Illinois | 17107 | 3988 | 77 |
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);