ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
124 rows where cases = 4547 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Tennessee 15
- Georgia 8
- Nebraska 8
- Wyoming 8
- Colorado 6
- Texas 6
- California 5
- Illinois 5
- Ohio 5
- Washington 5
- Michigan 4
- Virginia 4
- Alaska 3
- Arkansas 3
- Indiana 3
- Mississippi 3
- New York 3
- Pennsylvania 3
- South Dakota 3
- Kansas 2
- North Carolina 2
- Puerto Rico 2
- Wisconsin 2
- Alabama 1
- Connecticut 1
- Idaho 1
- Iowa 1
- Kentucky 1
- Louisiana 1
- Maine 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2486790 | 2486790 | 2022-05-09 | Alamosa | Colorado | 8003 | 4547 | 62 |
2483532 | 2483532 | 2022-05-08 | Alamosa | Colorado | 8003 | 4547 | 62 |
2480274 | 2480274 | 2022-05-07 | Alamosa | Colorado | 8003 | 4547 | 62 |
2477016 | 2477016 | 2022-05-06 | Alamosa | Colorado | 8003 | 4547 | 62 |
2416667 | 2416667 | 2022-04-17 | Washington | Nebraska | 31177 | 4547 | 43 |
2413411 | 2413411 | 2022-04-16 | Washington | Nebraska | 31177 | 4547 | 43 |
2410155 | 2410155 | 2022-04-15 | Washington | Nebraska | 31177 | 4547 | 43 |
2406899 | 2406899 | 2022-04-14 | Washington | Nebraska | 31177 | 4547 | 43 |
2403643 | 2403643 | 2022-04-13 | Washington | Nebraska | 31177 | 4547 | 43 |
2400388 | 2400388 | 2022-04-12 | Washington | Nebraska | 31177 | 4547 | 36 |
2372788 | 2372788 | 2022-04-04 | Inyo | California | 6027 | 4547 | 56 |
2369535 | 2369535 | 2022-04-03 | Inyo | California | 6027 | 4547 | 56 |
2366282 | 2366282 | 2022-04-02 | Inyo | California | 6027 | 4547 | 56 |
2363029 | 2363029 | 2022-04-01 | Inyo | California | 6027 | 4547 | 56 |
2361489 | 2361489 | 2022-03-31 | Avery | North Carolina | 37011 | 4547 | 42 |
2358082 | 2358082 | 2022-03-30 | Washington | Nebraska | 31177 | 4547 | 36 |
2312538 | 2312538 | 2022-03-16 | Washington | Nebraska | 31177 | 4547 | 36 |
2285204 | 2285204 | 2022-03-08 | Elbert | Georgia | 13105 | 4547 | 105 |
2263254 | 2263254 | 2022-03-01 | Cheboygan | Michigan | 26031 | 4547 | 100 |
2264110 | 2264110 | 2022-03-01 | Meigs | Ohio | 39105 | 4547 | 79 |
2260003 | 2260003 | 2022-02-28 | Cheboygan | Michigan | 26031 | 4547 | 100 |
2241581 | 2241581 | 2022-02-22 | Barranquitas | Puerto Rico | 72019 | 4547 | |
2239218 | 2239218 | 2022-02-21 | Carbon | Wyoming | 56007 | 4547 | 50 |
2235967 | 2235967 | 2022-02-20 | Carbon | Wyoming | 56007 | 4547 | 50 |
2232716 | 2232716 | 2022-02-19 | Carbon | Wyoming | 56007 | 4547 | 50 |
2229465 | 2229465 | 2022-02-18 | Carbon | Wyoming | 56007 | 4547 | 50 |
2220342 | 2220342 | 2022-02-16 | Cass | Illinois | 17017 | 4547 | 44 |
2190236 | 2190236 | 2022-02-06 | Radford city | Virginia | 51750 | 4547 | 41 |
2186983 | 2186983 | 2022-02-05 | Radford city | Virginia | 51750 | 4547 | 41 |
2183730 | 2183730 | 2022-02-04 | Radford city | Virginia | 51750 | 4547 | 41 |
2178946 | 2178946 | 2022-02-03 | Andrew | Missouri | 29003 | 4547 | 46 |
2150957 | 2150957 | 2022-01-25 | Milam | Texas | 48331 | 4547 | 93 |
2129294 | 2129294 | 2022-01-19 | Lawrence | Illinois | 17101 | 4547 | 48 |
2128579 | 2128579 | 2022-01-18 | Langlade | Wisconsin | 55067 | 4547 | 68 |
2099879 | 2099879 | 2022-01-10 | Pierce | Georgia | 13229 | 4547 | 108 |
2100536 | 2100536 | 2022-01-10 | Pointe Coupee | Louisiana | 22077 | 4547 | 85 |
2087561 | 2087561 | 2022-01-06 | Hancock | Maine | 23009 | 4547 | 65 |
2044230 | 2044230 | 2021-12-24 | Carroll | Arkansas | 5015 | 4547 | 80 |
2012191 | 2012191 | 2021-12-14 | Jefferson | Idaho | 16051 | 4547 | 52 |
1998277 | 1998277 | 2021-12-09 | Washington | Vermont | 50023 | 4547 | 29 |
1991928 | 1991928 | 2021-12-07 | Island | Washington | 53029 | 4547 | 51 |
1971184 | 1971184 | 2021-12-01 | Luna | New Mexico | 35029 | 4547 | 97 |
1971416 | 1971416 | 2021-12-01 | Adams | Ohio | 39001 | 4547 | 109 |
1895681 | 1895681 | 2021-11-08 | Mercer | Kentucky | 21167 | 4547 | 75 |
1871109 | 1871109 | 2021-10-31 | Meade | South Dakota | 46093 | 4547 | 46 |
1867860 | 1867860 | 2021-10-30 | Meade | South Dakota | 46093 | 4547 | 46 |
1864611 | 1864611 | 2021-10-29 | Meade | South Dakota | 46093 | 4547 | 46 |
1797149 | 1797149 | 2021-10-09 | Geneva | Alabama | 1061 | 4547 | 124 |
1799401 | 1799401 | 2021-10-09 | Clinton | Pennsylvania | 42035 | 4547 | 71 |
1789710 | 1789710 | 2021-10-06 | Arecibo | Puerto Rico | 72013 | 4547 | |
1790612 | 1790612 | 2021-10-06 | Park | Wyoming | 56029 | 4547 | 54 |
1785779 | 1785779 | 2021-10-05 | Ravalli | Montana | 30081 | 4547 | 64 |
1780704 | 1780704 | 2021-10-03 | Kittitas | Washington | 53037 | 4547 | 48 |
1777454 | 1777454 | 2021-10-02 | Kittitas | Washington | 53037 | 4547 | 48 |
1774204 | 1774204 | 2021-10-01 | Kittitas | Washington | 53037 | 4547 | 48 |
1768308 | 1768308 | 2021-09-30 | Dawson | Georgia | 13085 | 4547 | 59 |
1770110 | 1770110 | 2021-09-30 | Coos | Oregon | 41011 | 4547 | 76 |
1746071 | 1746071 | 2021-09-23 | Harvey | Kansas | 20079 | 4547 | 77 |
1742174 | 1742174 | 2021-09-22 | Montrose | Colorado | 8085 | 4547 | 76 |
1742822 | 1742822 | 2021-09-22 | Harvey | Kansas | 20079 | 4547 | 77 |
1743363 | 1743363 | 2021-09-22 | Scott | Mississippi | 28123 | 4547 | 96 |
1739172 | 1739172 | 2021-09-21 | Unknown | Georgia | 4547 | 14 | |
1720575 | 1720575 | 2021-09-15 | George | Mississippi | 28039 | 4547 | 66 |
1711714 | 1711714 | 2021-09-12 | Pike | Pennsylvania | 42103 | 4547 | 56 |
1672188 | 1672188 | 2021-08-31 | Lyon | Nevada | 32019 | 4547 | 76 |
1646212 | 1646212 | 2021-08-23 | Belknap | New Hampshire | 33001 | 4547 | 103 |
1608549 | 1608549 | 2021-08-11 | Whitman | Washington | 53075 | 4547 | 53 |
1604312 | 1604312 | 2021-08-10 | Madison | Ohio | 39097 | 4547 | 65 |
1565650 | 1565650 | 2021-07-29 | Dillon | South Carolina | 45033 | 4547 | 85 |
1566176 | 1566176 | 2021-07-29 | Danville city | Virginia | 51590 | 4547 | 144 |
1550985 | 1550985 | 2021-07-25 | Montgomery | Indiana | 18107 | 4547 | 94 |
1547738 | 1547738 | 2021-07-24 | Montgomery | Indiana | 18107 | 4547 | 94 |
1544491 | 1544491 | 2021-07-23 | Montgomery | Indiana | 18107 | 4547 | 94 |
1539108 | 1539108 | 2021-07-21 | Livingston | New York | 36051 | 4547 | 60 |
1535861 | 1535861 | 2021-07-20 | Livingston | New York | 36051 | 4547 | 60 |
1492199 | 1492199 | 2021-07-07 | Chattahoochee | Georgia | 13053 | 4547 | 17 |
1494324 | 1494324 | 2021-07-07 | Cocke | Tennessee | 47029 | 4547 | 100 |
1488952 | 1488952 | 2021-07-06 | Chattahoochee | Georgia | 13053 | 4547 | 17 |
1491077 | 1491077 | 2021-07-06 | Cocke | Tennessee | 47029 | 4547 | 100 |
1459401 | 1459401 | 2021-06-27 | Kenai Peninsula Borough | Alaska | 2122 | 4547 | 19 |
1461863 | 1461863 | 2021-06-27 | Cocke | Tennessee | 47029 | 4547 | 100 |
1456156 | 1456156 | 2021-06-26 | Kenai Peninsula Borough | Alaska | 2122 | 4547 | 19 |
1458618 | 1458618 | 2021-06-26 | Cocke | Tennessee | 47029 | 4547 | 100 |
1452911 | 1452911 | 2021-06-25 | Kenai Peninsula Borough | Alaska | 2122 | 4547 | 19 |
1455373 | 1455373 | 2021-06-25 | Cocke | Tennessee | 47029 | 4547 | 100 |
1448882 | 1448882 | 2021-06-23 | Cocke | Tennessee | 47029 | 4547 | 100 |
1445637 | 1445637 | 2021-06-22 | Cocke | Tennessee | 47029 | 4547 | 100 |
1439147 | 1439147 | 2021-06-20 | Cocke | Tennessee | 47029 | 4547 | 100 |
1435900 | 1435900 | 2021-06-19 | Cocke | Tennessee | 47029 | 4547 | 100 |
1432653 | 1432653 | 2021-06-18 | Cocke | Tennessee | 47029 | 4547 | 100 |
1429407 | 1429407 | 2021-06-17 | Cocke | Tennessee | 47029 | 4547 | 100 |
1426162 | 1426162 | 2021-06-16 | Cocke | Tennessee | 47029 | 4547 | 100 |
1417757 | 1417757 | 2021-06-14 | Franklin | Illinois | 17055 | 4547 | 90 |
1381425 | 1381425 | 2021-06-02 | Sweetwater | Wyoming | 56037 | 4547 | 39 |
1356931 | 1356931 | 2021-05-26 | Pearl River | Mississippi | 28109 | 4547 | 146 |
1325790 | 1325790 | 2021-05-16 | Nacogdoches | Texas | 48347 | 4547 | 170 |
1312600 | 1312600 | 2021-05-12 | Obion | Tennessee | 47131 | 4547 | 96 |
1293066 | 1293066 | 2021-05-06 | Cheatham | Tennessee | 47021 | 4547 | 55 |
1248572 | 1248572 | 2021-04-23 | Broomfield | Colorado | 8014 | 4547 | 75 |
1176360 | 1176360 | 2021-03-31 | Howard | Texas | 48227 | 4547 | 100 |
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);