ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
133 rows where cases = 4081 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kentucky 12
- Georgia 11
- Minnesota 10
- Iowa 9
- Mississippi 9
- Virginia 8
- Illinois 7
- Kansas 7
- Alabama 6
- Ohio 6
- Missouri 5
- New York 5
- Arkansas 4
- Indiana 4
- North Carolina 4
- Maryland 3
- South Carolina 3
- Texas 3
- Louisiana 2
- Pennsylvania 2
- Tennessee 2
- Utah 2
- Arizona 1
- California 1
- Maine 1
- Massachusetts 1
- Michigan 1
- Oklahoma 1
- Puerto Rico 1
- Washington 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2486196 | 2486196 | 2022-05-08 | Unknown | Utah | 4081 | 92 | |
2473237 | 2473237 | 2022-05-04 | Giles | Virginia | 51071 | 4081 | 50 |
2461159 | 2461159 | 2022-05-01 | Moultrie | Illinois | 17139 | 4081 | 52 |
2457903 | 2457903 | 2022-04-30 | Moultrie | Illinois | 17139 | 4081 | 52 |
2454647 | 2454647 | 2022-04-29 | Moultrie | Illinois | 17139 | 4081 | 52 |
2451391 | 2451391 | 2022-04-28 | Moultrie | Illinois | 17139 | 4081 | 52 |
2418173 | 2418173 | 2022-04-18 | Clay | Alabama | 1027 | 4081 | 81 |
2414917 | 2414917 | 2022-04-17 | Clay | Alabama | 1027 | 4081 | 81 |
2416403 | 2416403 | 2022-04-17 | Yalobusha | Mississippi | 28161 | 4081 | 57 |
2411661 | 2411661 | 2022-04-16 | Clay | Alabama | 1027 | 4081 | 81 |
2413147 | 2413147 | 2022-04-16 | Yalobusha | Mississippi | 28161 | 4081 | 57 |
2408405 | 2408405 | 2022-04-15 | Clay | Alabama | 1027 | 4081 | 81 |
2409891 | 2409891 | 2022-04-15 | Yalobusha | Mississippi | 28161 | 4081 | 57 |
2406635 | 2406635 | 2022-04-14 | Yalobusha | Mississippi | 28161 | 4081 | 57 |
2403379 | 2403379 | 2022-04-13 | Yalobusha | Mississippi | 28161 | 4081 | 57 |
2400124 | 2400124 | 2022-04-12 | Yalobusha | Mississippi | 28161 | 4081 | 57 |
2376669 | 2376669 | 2022-04-05 | Fayette | Iowa | 19065 | 4081 | 72 |
2373417 | 2373417 | 2022-04-04 | Fayette | Iowa | 19065 | 4081 | 72 |
2370164 | 2370164 | 2022-04-03 | Fayette | Iowa | 19065 | 4081 | 72 |
2366911 | 2366911 | 2022-04-02 | Fayette | Iowa | 19065 | 4081 | 72 |
2363658 | 2363658 | 2022-04-01 | Fayette | Iowa | 19065 | 4081 | 72 |
2360404 | 2360404 | 2022-03-31 | Fayette | Iowa | 19065 | 4081 | 72 |
2357150 | 2357150 | 2022-03-30 | Fayette | Iowa | 19065 | 4081 | 72 |
2339436 | 2339436 | 2022-03-24 | Aransas | Texas | 48007 | 4081 | 81 |
2333563 | 2333563 | 2022-03-23 | Clay | Alabama | 1027 | 4081 | 81 |
2336182 | 2336182 | 2022-03-23 | Aransas | Texas | 48007 | 4081 | 81 |
2324809 | 2324809 | 2022-03-20 | Caldwell | Kentucky | 21033 | 4081 | 59 |
2321555 | 2321555 | 2022-03-19 | Caldwell | Kentucky | 21033 | 4081 | 59 |
2318301 | 2318301 | 2022-03-18 | Caldwell | Kentucky | 21033 | 4081 | 59 |
2315048 | 2315048 | 2022-03-17 | Caldwell | Kentucky | 21033 | 4081 | 59 |
2311795 | 2311795 | 2022-03-16 | Caldwell | Kentucky | 21033 | 4081 | 59 |
2308542 | 2308542 | 2022-03-15 | Caldwell | Kentucky | 21033 | 4081 | 59 |
2305291 | 2305291 | 2022-03-14 | Caldwell | Kentucky | 21033 | 4081 | 59 |
2240646 | 2240646 | 2022-02-22 | Wadena | Minnesota | 27159 | 4081 | 51 |
2237492 | 2237492 | 2022-02-21 | Benton | Missouri | 29015 | 4081 | 88 |
2234241 | 2234241 | 2022-02-20 | Benton | Missouri | 29015 | 4081 | 88 |
2230990 | 2230990 | 2022-02-19 | Benton | Missouri | 29015 | 4081 | 88 |
2227739 | 2227739 | 2022-02-18 | Benton | Missouri | 29015 | 4081 | 88 |
2201368 | 2201368 | 2022-02-10 | LaSalle | Louisiana | 22059 | 4081 | 49 |
2115734 | 2115734 | 2022-01-15 | La Paz | Arizona | 4012 | 4081 | 112 |
2062954 | 2062954 | 2021-12-29 | Morgan | Tennessee | 47129 | 4081 | 57 |
2043013 | 2043013 | 2021-12-23 | Wyandot | Ohio | 39175 | 4081 | 80 |
2028654 | 2028654 | 2021-12-19 | Washington | Indiana | 18175 | 4081 | 58 |
2025403 | 2025403 | 2021-12-18 | Washington | Indiana | 18175 | 4081 | 58 |
2022152 | 2022152 | 2021-12-17 | Washington | Indiana | 18175 | 4081 | 58 |
2017898 | 2017898 | 2021-12-15 | Salem city | Virginia | 51775 | 4081 | 79 |
2005555 | 2005555 | 2021-12-12 | Franklin | Georgia | 13119 | 4081 | 85 |
2002304 | 2002304 | 2021-12-11 | Franklin | Georgia | 13119 | 4081 | 85 |
1999054 | 1999054 | 2021-12-10 | Franklin | Georgia | 13119 | 4081 | 85 |
1998332 | 1998332 | 2021-12-09 | Gloucester | Virginia | 51073 | 4081 | 80 |
1941163 | 1941163 | 2021-11-22 | Letcher | Kentucky | 21133 | 4081 | 73 |
1931565 | 1931565 | 2021-11-19 | Queen Anne's | Maryland | 24035 | 4081 | 74 |
1918521 | 1918521 | 2021-11-15 | Union | Louisiana | 22111 | 4081 | 106 |
1895963 | 1895963 | 2021-11-08 | Le Sueur | Minnesota | 27079 | 4081 | 33 |
1871528 | 1871528 | 2021-10-31 | Accomack | Virginia | 51001 | 4081 | 77 |
1868279 | 1868279 | 2021-10-30 | Accomack | Virginia | 51001 | 4081 | 77 |
1865030 | 1865030 | 2021-10-29 | Accomack | Virginia | 51001 | 4081 | 77 |
1818702 | 1818702 | 2021-10-15 | Gallia | Ohio | 39053 | 4081 | 65 |
1811980 | 1811980 | 2021-10-13 | Franklin | New York | 36033 | 4081 | 20 |
1804136 | 1804136 | 2021-10-11 | Sumter | Georgia | 13261 | 4081 | 123 |
1800887 | 1800887 | 2021-10-10 | Sumter | Georgia | 13261 | 4081 | 123 |
1797638 | 1797638 | 2021-10-09 | Sumter | Georgia | 13261 | 4081 | 123 |
1794389 | 1794389 | 2021-10-08 | Sumter | Georgia | 13261 | 4081 | 123 |
1768969 | 1768969 | 2021-09-30 | Ohio | Kentucky | 21183 | 4081 | 74 |
1727957 | 1727957 | 2021-09-17 | Snyder | Pennsylvania | 42109 | 4081 | 92 |
1694636 | 1694636 | 2021-09-07 | Simpson | Mississippi | 28127 | 4081 | 106 |
1656751 | 1656751 | 2021-08-26 | Lauderdale | Tennessee | 47097 | 4081 | 50 |
1617325 | 1617325 | 2021-08-14 | Preble | Ohio | 39135 | 4081 | 107 |
1609228 | 1609228 | 2021-08-12 | Toombs | Georgia | 13279 | 4081 | 122 |
1599936 | 1599936 | 2021-08-09 | Seward | Kansas | 20175 | 4081 | 42 |
1596688 | 1596688 | 2021-08-08 | Seward | Kansas | 20175 | 4081 | 42 |
1593439 | 1593439 | 2021-08-07 | Seward | Kansas | 20175 | 4081 | 42 |
1590190 | 1590190 | 2021-08-06 | Seward | Kansas | 20175 | 4081 | 42 |
1586941 | 1586941 | 2021-08-05 | Seward | Kansas | 20175 | 4081 | 42 |
1583691 | 1583691 | 2021-08-04 | Seward | Kansas | 20175 | 4081 | 42 |
1580441 | 1580441 | 2021-08-03 | Seward | Kansas | 20175 | 4081 | 42 |
1526327 | 1526327 | 2021-07-17 | Crawford | Ohio | 39033 | 4081 | 111 |
1508156 | 1508156 | 2021-07-12 | Independence | Arkansas | 5063 | 4081 | 126 |
1467142 | 1467142 | 2021-06-29 | Beltrami | Minnesota | 27007 | 4081 | 62 |
1463897 | 1463897 | 2021-06-28 | Beltrami | Minnesota | 27007 | 4081 | 62 |
1446752 | 1446752 | 2021-06-23 | Camden | Georgia | 13039 | 4081 | 38 |
1412016 | 1412016 | 2021-06-12 | Nobles | Minnesota | 27105 | 4081 | 50 |
1404327 | 1404327 | 2021-06-10 | Union | Arkansas | 5139 | 4081 | 115 |
1382703 | 1382703 | 2021-06-03 | Huron | Michigan | 26063 | 4081 | 80 |
1384397 | 1384397 | 2021-06-03 | Franklin | Virginia | 51067 | 4081 | 79 |
1380570 | 1380570 | 2021-06-02 | Ponce | Puerto Rico | 72113 | 4081 | |
1368169 | 1368169 | 2021-05-29 | Franklin | Virginia | 51067 | 4081 | 78 |
1354219 | 1354219 | 2021-05-25 | Yadkin | North Carolina | 37197 | 4081 | 51 |
1331946 | 1331946 | 2021-05-18 | Williamsburg | South Carolina | 45089 | 4081 | 99 |
1327618 | 1327618 | 2021-05-17 | Nobles | Minnesota | 27105 | 4081 | 48 |
1328699 | 1328699 | 2021-05-17 | Williamsburg | South Carolina | 45089 | 4081 | 99 |
1324372 | 1324372 | 2021-05-16 | Nobles | Minnesota | 27105 | 4081 | 48 |
1269264 | 1269264 | 2021-04-29 | Monroe | Mississippi | 28095 | 4081 | 132 |
1253647 | 1253647 | 2021-04-24 | Defiance | Ohio | 39039 | 4081 | 96 |
1235573 | 1235573 | 2021-04-19 | Tuolumne | California | 6109 | 4081 | 64 |
1233948 | 1233948 | 2021-04-18 | Fulton | New York | 36035 | 4081 | 86 |
1201669 | 1201669 | 2021-04-08 | Ashland | Ohio | 39005 | 4081 | 86 |
1180832 | 1180832 | 2021-04-02 | Clinton | Indiana | 18023 | 4081 | 58 |
1165752 | 1165752 | 2021-03-28 | Madison | New York | 36053 | 4081 | 85 |
1153638 | 1153638 | 2021-03-24 | Jim Wells | Texas | 48249 | 4081 | 93 |
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);