ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
156 rows where cases = 3134 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 13
- Georgia 11
- South Dakota 11
- Mississippi 9
- North Carolina 8
- Louisiana 7
- Virginia 7
- Missouri 6
- Puerto Rico 6
- Wisconsin 6
- Alabama 5
- California 5
- Kentucky 5
- Indiana 4
- Minnesota 4
- Pennsylvania 4
- Washington 4
- West Virginia 4
- Arkansas 3
- Florida 3
- Nevada 3
- New Mexico 3
- New York 3
- South Carolina 3
- Wyoming 3
- Colorado 2
- Kansas 2
- Michigan 2
- New Hampshire 2
- Ohio 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2462881 | 2462881 | 2022-05-01 | Orocovis | Puerto Rico | 72107 | 3134 | |
2362810 | 2362810 | 2022-03-31 | Converse | Wyoming | 56009 | 3134 | 55 |
2359556 | 2359556 | 2022-03-30 | Converse | Wyoming | 56009 | 3134 | 55 |
2356302 | 2356302 | 2022-03-29 | Converse | Wyoming | 56009 | 3134 | 55 |
2332782 | 2332782 | 2022-03-22 | Dewey | South Dakota | 46041 | 3134 | 42 |
2329529 | 2329529 | 2022-03-21 | Dewey | South Dakota | 46041 | 3134 | 42 |
2326277 | 2326277 | 2022-03-20 | Dewey | South Dakota | 46041 | 3134 | 42 |
2326937 | 2326937 | 2022-03-20 | Roane | West Virginia | 54087 | 3134 | 37 |
2323024 | 2323024 | 2022-03-19 | Dewey | South Dakota | 46041 | 3134 | 42 |
2323684 | 2323684 | 2022-03-19 | Roane | West Virginia | 54087 | 3134 | 37 |
2319770 | 2319770 | 2022-03-18 | Dewey | South Dakota | 46041 | 3134 | 42 |
2320430 | 2320430 | 2022-03-18 | Roane | West Virginia | 54087 | 3134 | 37 |
2316516 | 2316516 | 2022-03-17 | Dewey | South Dakota | 46041 | 3134 | 42 |
2313263 | 2313263 | 2022-03-16 | Dewey | South Dakota | 46041 | 3134 | 42 |
2290498 | 2290498 | 2022-03-09 | Dewey | South Dakota | 46041 | 3134 | 40 |
2285343 | 2285343 | 2022-03-08 | Gooding | Idaho | 16047 | 3134 | 54 |
2287104 | 2287104 | 2022-03-08 | Barceloneta | Puerto Rico | 72017 | 3134 | |
2287246 | 2287246 | 2022-03-08 | Dewey | South Dakota | 46041 | 3134 | 40 |
2287435 | 2287435 | 2022-03-08 | Comanche | Texas | 48093 | 3134 | 77 |
2283852 | 2283852 | 2022-03-07 | Barceloneta | Puerto Rico | 72017 | 3134 | |
2284183 | 2284183 | 2022-03-07 | Comanche | Texas | 48093 | 3134 | 77 |
2262426 | 2262426 | 2022-03-01 | Dade | Georgia | 13083 | 3134 | 28 |
2203378 | 2203378 | 2022-02-10 | Ashland | Wisconsin | 55003 | 3134 | 32 |
2195833 | 2195833 | 2022-02-08 | Morgan | Ohio | 39115 | 3134 | 51 |
2188734 | 2188734 | 2022-02-06 | Dent | Missouri | 29065 | 3134 | 66 |
2189196 | 2189196 | 2022-02-06 | Swain | North Carolina | 37173 | 3134 | 33 |
2185943 | 2185943 | 2022-02-05 | Swain | North Carolina | 37173 | 3134 | 33 |
2182691 | 2182691 | 2022-02-04 | Swain | North Carolina | 37173 | 3134 | 33 |
2084545 | 2084545 | 2022-01-05 | Clarke | Mississippi | 28023 | 3134 | 96 |
2015473 | 2015473 | 2021-12-15 | Clay | Illinois | 17025 | 3134 | 60 |
1997360 | 1997360 | 2021-12-09 | Yancey | North Carolina | 37199 | 3134 | 36 |
1971718 | 1971718 | 2021-12-01 | Gurabo | Puerto Rico | 72063 | 3134 | |
1968468 | 1968468 | 2021-11-30 | Gurabo | Puerto Rico | 72063 | 3134 | |
1964373 | 1964373 | 2021-11-29 | Clinton | Missouri | 29049 | 3134 | 94 |
1965217 | 1965217 | 2021-11-29 | Gurabo | Puerto Rico | 72063 | 3134 | |
1933138 | 1933138 | 2021-11-19 | Montague | Texas | 48337 | 3134 | 96 |
1929355 | 1929355 | 2021-11-18 | Wasco | Oregon | 41065 | 3134 | 43 |
1929887 | 1929887 | 2021-11-18 | Montague | Texas | 48337 | 3134 | 95 |
1930067 | 1930067 | 2021-11-18 | Fredericksburg city | Virginia | 51630 | 3134 | 26 |
1924246 | 1924246 | 2021-11-17 | Brantley | Georgia | 13025 | 3134 | 87 |
1906840 | 1906840 | 2021-11-11 | Hughes | South Dakota | 46065 | 3134 | 48 |
1903591 | 1903591 | 2021-11-10 | Hughes | South Dakota | 46065 | 3134 | 48 |
1855899 | 1855899 | 2021-10-27 | Pitkin | Colorado | 8097 | 3134 | 5 |
1827856 | 1827856 | 2021-10-18 | Winston | Mississippi | 28159 | 3134 | 91 |
1829359 | 1829359 | 2021-10-18 | Louisa | Virginia | 51109 | 3134 | 44 |
1813419 | 1813419 | 2021-10-14 | Pickens | Alabama | 1107 | 3134 | 79 |
1815287 | 1815287 | 2021-10-14 | Caswell | North Carolina | 37033 | 3134 | 37 |
1782011 | 1782011 | 2021-10-04 | Concordia | Louisiana | 22029 | 3134 | 74 |
1780458 | 1780458 | 2021-10-03 | Scurry | Texas | 48415 | 3134 | 81 |
1742285 | 1742285 | 2021-09-22 | Ben Hill | Georgia | 13017 | 3134 | 92 |
1736160 | 1736160 | 2021-09-20 | Randolph | Indiana | 18135 | 3134 | 88 |
1723457 | 1723457 | 2021-09-16 | Letcher | Kentucky | 21133 | 3134 | 54 |
1719631 | 1719631 | 2021-09-15 | Mitchell | Georgia | 13205 | 3134 | 93 |
1712566 | 1712566 | 2021-09-12 | Door | Wisconsin | 55029 | 3134 | 38 |
1709319 | 1709319 | 2021-09-11 | Door | Wisconsin | 55029 | 3134 | 38 |
1706072 | 1706072 | 2021-09-10 | Door | Wisconsin | 55029 | 3134 | 38 |
1680309 | 1680309 | 2021-09-03 | Logan | Arkansas | 5083 | 3134 | 32 |
1650764 | 1650764 | 2021-08-24 | Okanogan | Washington | 53047 | 3134 | 43 |
1628960 | 1628960 | 2021-08-18 | Scott | Indiana | 18143 | 3134 | 60 |
1613448 | 1613448 | 2021-08-13 | Audrain | Missouri | 29007 | 3134 | 59 |
1611319 | 1611319 | 2021-08-12 | Wayne | Tennessee | 47181 | 3134 | 36 |
1596753 | 1596753 | 2021-08-08 | Harlan | Kentucky | 21095 | 3134 | 93 |
1593504 | 1593504 | 2021-08-07 | Harlan | Kentucky | 21095 | 3134 | 93 |
1590255 | 1590255 | 2021-08-06 | Harlan | Kentucky | 21095 | 3134 | 93 |
1574097 | 1574097 | 2021-08-01 | De Soto | Louisiana | 22031 | 3134 | 80 |
1570849 | 1570849 | 2021-07-31 | De Soto | Louisiana | 22031 | 3134 | 80 |
1567601 | 1567601 | 2021-07-30 | De Soto | Louisiana | 22031 | 3134 | 80 |
1564781 | 1564781 | 2021-07-29 | Miller | Missouri | 29131 | 3134 | 62 |
1535872 | 1535872 | 2021-07-20 | Orleans | New York | 36073 | 3134 | 83 |
1532624 | 1532624 | 2021-07-19 | Orleans | New York | 36073 | 3134 | 83 |
1528870 | 1528870 | 2021-07-18 | Mille Lacs | Minnesota | 27095 | 3134 | 55 |
1529377 | 1529377 | 2021-07-18 | Orleans | New York | 36073 | 3134 | 83 |
1525623 | 1525623 | 2021-07-17 | Mille Lacs | Minnesota | 27095 | 3134 | 55 |
1522376 | 1522376 | 2021-07-16 | Mille Lacs | Minnesota | 27095 | 3134 | 55 |
1513582 | 1513582 | 2021-07-13 | Tioga | Pennsylvania | 42117 | 3134 | 112 |
1510336 | 1510336 | 2021-07-12 | Tioga | Pennsylvania | 42117 | 3134 | 112 |
1507089 | 1507089 | 2021-07-11 | Tioga | Pennsylvania | 42117 | 3134 | 112 |
1503843 | 1503843 | 2021-07-10 | Tioga | Pennsylvania | 42117 | 3134 | 112 |
1497762 | 1497762 | 2021-07-08 | Hockley | Texas | 48219 | 3134 | 104 |
1494515 | 1494515 | 2021-07-07 | Hockley | Texas | 48219 | 3134 | 104 |
1491268 | 1491268 | 2021-07-06 | Hockley | Texas | 48219 | 3134 | 104 |
1455881 | 1455881 | 2021-06-25 | Warren | Virginia | 51187 | 3134 | 61 |
1443137 | 1443137 | 2021-06-22 | Lawrence | Alabama | 1079 | 3134 | 100 |
1439892 | 1439892 | 2021-06-21 | Lawrence | Alabama | 1079 | 3134 | 100 |
1433790 | 1433790 | 2021-06-19 | Dawson | Georgia | 13085 | 3134 | 50 |
1430544 | 1430544 | 2021-06-18 | Dawson | Georgia | 13085 | 3134 | 50 |
1424054 | 1424054 | 2021-06-16 | Dawson | Georgia | 13085 | 3134 | 50 |
1420806 | 1420806 | 2021-06-15 | Dawson | Georgia | 13085 | 3134 | 49 |
1414315 | 1414315 | 2021-06-13 | Dawson | Georgia | 13085 | 3134 | 48 |
1382702 | 1382702 | 2021-06-03 | Houghton | Michigan | 26061 | 3134 | 42 |
1374993 | 1374993 | 2021-06-01 | Pike | Alabama | 1109 | 3134 | 77 |
1362963 | 1362963 | 2021-05-28 | Bell | Kentucky | 21013 | 3134 | 56 |
1336367 | 1336367 | 2021-05-20 | Unknown | Florida | 3134 | 0 | |
1330004 | 1330004 | 2021-05-18 | Stephens | Georgia | 13257 | 3134 | 83 |
1300009 | 1300009 | 2021-05-08 | Isle of Wight | Virginia | 51093 | 3134 | 68 |
1290875 | 1290875 | 2021-05-06 | Hardee | Florida | 12049 | 3134 | 43 |
1279317 | 1279317 | 2021-05-02 | Lyon | Nevada | 32019 | 3134 | 65 |
1276070 | 1276070 | 2021-05-01 | Lyon | Nevada | 32019 | 3134 | 65 |
1272823 | 1272823 | 2021-04-30 | Lyon | Nevada | 32019 | 3134 | 65 |
1262784 | 1262784 | 2021-04-27 | Scott | Mississippi | 28123 | 3134 | 73 |
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);