ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
131 rows where cases = 3413 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 10
- Tennessee 10
- Texas 10
- Arkansas 8
- North Carolina 8
- Illinois 6
- Alabama 5
- Ohio 5
- Wisconsin 5
- California 4
- Minnesota 4
- Mississippi 4
- Nebraska 4
- Virginia 4
- Colorado 3
- Kentucky 3
- Missouri 3
- Montana 3
- South Dakota 3
- Wyoming 3
- Indiana 2
- Kansas 2
- Maryland 2
- Oklahoma 2
- Pennsylvania 2
- Washington 2
- Florida 1
- Idaho 1
- Louisiana 1
- Maine 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2395764 | 2395764 | 2022-04-11 | Bacon | Georgia | 13005 | 3413 | 71 |
2397280 | 2397280 | 2022-04-11 | Yates | New York | 36123 | 3413 | 39 |
2304677 | 2304677 | 2022-03-14 | Brooks | Georgia | 13027 | 3413 | 82 |
2281419 | 2281419 | 2022-03-06 | Buffalo | Wisconsin | 55011 | 3413 | 12 |
2278166 | 2278166 | 2022-03-05 | Buffalo | Wisconsin | 55011 | 3413 | 12 |
2274913 | 2274913 | 2022-03-04 | Buffalo | Wisconsin | 55011 | 3413 | 12 |
2240636 | 2240636 | 2022-02-22 | Sibley | Minnesota | 27143 | 3413 | 23 |
2224367 | 2224367 | 2022-02-17 | Pennington | Minnesota | 27113 | 3413 | 39 |
2168473 | 2168473 | 2022-01-31 | Tipton | Indiana | 18159 | 3413 | 81 |
2129233 | 2129233 | 2022-01-19 | Minidoka | Idaho | 16067 | 3413 | 55 |
2104538 | 2104538 | 2022-01-11 | Avery | North Carolina | 37011 | 3413 | 39 |
2101148 | 2101148 | 2022-01-10 | Humboldt | Nevada | 32013 | 3413 | 44 |
2034234 | 2034234 | 2021-12-20 | Lincoln | West Virginia | 54043 | 3413 | 54 |
2018807 | 2018807 | 2021-12-16 | Wayne | Illinois | 17191 | 3413 | 67 |
2006741 | 2006741 | 2021-12-12 | Hill | Montana | 30041 | 3413 | 71 |
2003490 | 2003490 | 2021-12-11 | Hill | Montana | 30041 | 3413 | 71 |
2000240 | 2000240 | 2021-12-10 | Hill | Montana | 30041 | 3413 | 71 |
1995474 | 1995474 | 2021-12-09 | Clark | Arkansas | 5019 | 3413 | 63 |
1989294 | 1989294 | 2021-12-07 | Elbert | Georgia | 13105 | 3413 | 92 |
1990898 | 1990898 | 2021-12-07 | Rolette | North Dakota | 38079 | 3413 | 36 |
1984898 | 1984898 | 2021-12-05 | Crockett | Tennessee | 47033 | 3413 | 64 |
1981648 | 1981648 | 2021-12-04 | Crockett | Tennessee | 47033 | 3413 | 64 |
1978398 | 1978398 | 2021-12-03 | Crockett | Tennessee | 47033 | 3413 | 64 |
1972531 | 1972531 | 2021-12-01 | Green Lake | Wisconsin | 55047 | 3413 | 36 |
1966227 | 1966227 | 2021-11-30 | Columbia | Arkansas | 5027 | 3413 | 75 |
1938592 | 1938592 | 2021-11-21 | Saunders | Nebraska | 31155 | 3413 | 23 |
1933766 | 1933766 | 2021-11-20 | Randolph | Arkansas | 5121 | 3413 | 63 |
1935342 | 1935342 | 2021-11-20 | Saunders | Nebraska | 31155 | 3413 | 23 |
1932092 | 1932092 | 2021-11-19 | Saunders | Nebraska | 31155 | 3413 | 23 |
1912383 | 1912383 | 2021-11-13 | Henry | Missouri | 29083 | 3413 | 51 |
1907640 | 1907640 | 2021-11-12 | Marengo | Alabama | 1091 | 3413 | 93 |
1900729 | 1900729 | 2021-11-09 | Carbon | Utah | 49007 | 3413 | 31 |
1895214 | 1895214 | 2021-11-08 | Crawford | Illinois | 17033 | 3413 | 46 |
1877783 | 1877783 | 2021-11-02 | Deaf Smith | Texas | 48117 | 3413 | 79 |
1872493 | 1872493 | 2021-11-01 | Jersey | Illinois | 17083 | 3413 | 72 |
1874895 | 1874895 | 2021-11-01 | Staunton city | Virginia | 51790 | 3413 | 81 |
1859329 | 1859329 | 2021-10-28 | Lamar | Georgia | 13171 | 3413 | 89 |
1861860 | 1861860 | 2021-10-28 | Mecklenburg | Virginia | 51117 | 3413 | 83 |
1837112 | 1837112 | 2021-10-21 | Anderson | Kentucky | 21005 | 3413 | 41 |
1812749 | 1812749 | 2021-10-13 | Austin | Texas | 48015 | 3413 | 51 |
1790113 | 1790113 | 2021-10-06 | Hutchinson | Texas | 48233 | 3413 | 83 |
1786865 | 1786865 | 2021-10-05 | Hutchinson | Texas | 48233 | 3413 | 83 |
1783415 | 1783415 | 2021-10-04 | Chester | Tennessee | 47023 | 3413 | 68 |
1780153 | 1780153 | 2021-10-03 | Yankton | South Dakota | 46135 | 3413 | 37 |
1776903 | 1776903 | 2021-10-02 | Yankton | South Dakota | 46135 | 3413 | 37 |
1773653 | 1773653 | 2021-10-01 | Yankton | South Dakota | 46135 | 3413 | 37 |
1755142 | 1755142 | 2021-09-26 | Delta | Colorado | 8029 | 3413 | 79 |
1751894 | 1751894 | 2021-09-25 | Delta | Colorado | 8029 | 3413 | 79 |
1748645 | 1748645 | 2021-09-24 | Delta | Colorado | 8029 | 3413 | 79 |
1732332 | 1732332 | 2021-09-19 | Del Norte | California | 6015 | 3413 | 35 |
1729082 | 1729082 | 2021-09-18 | Del Norte | California | 6015 | 3413 | 35 |
1725832 | 1725832 | 2021-09-17 | Del Norte | California | 6015 | 3413 | 35 |
1723335 | 1723335 | 2021-09-16 | Labette | Kansas | 20099 | 3413 | 58 |
1720086 | 1720086 | 2021-09-15 | Labette | Kansas | 20099 | 3413 | 58 |
1700696 | 1700696 | 2021-09-09 | Grant | Kentucky | 21081 | 3413 | 29 |
1681767 | 1681767 | 2021-09-03 | Washington | Missouri | 29221 | 3413 | 56 |
1674184 | 1674184 | 2021-09-01 | Tattnall | Georgia | 13267 | 3413 | 83 |
1649781 | 1649781 | 2021-08-24 | Jackson | Ohio | 39079 | 3413 | 55 |
1647237 | 1647237 | 2021-08-23 | Palo Pinto | Texas | 48363 | 3413 | 83 |
1643988 | 1643988 | 2021-08-22 | Palo Pinto | Texas | 48363 | 3413 | 83 |
1640738 | 1640738 | 2021-08-21 | Palo Pinto | Texas | 48363 | 3413 | 83 |
1622209 | 1622209 | 2021-08-16 | Stephens | Georgia | 13257 | 3413 | 81 |
1599071 | 1599071 | 2021-08-09 | Carroll | Arkansas | 5015 | 3413 | 52 |
1586107 | 1586107 | 2021-08-05 | Lincoln | Arkansas | 5079 | 3413 | 49 |
1575545 | 1575545 | 2021-08-01 | Marion | Tennessee | 47115 | 3413 | 50 |
1572297 | 1572297 | 2021-07-31 | Marion | Tennessee | 47115 | 3413 | 50 |
1569049 | 1569049 | 2021-07-30 | Marion | Tennessee | 47115 | 3413 | 50 |
1556769 | 1556769 | 2021-07-27 | Marion | Alabama | 1093 | 3413 | 106 |
1373665 | 1373665 | 2021-05-31 | Pasquotank | North Carolina | 37139 | 3413 | 83 |
1373762 | 1373762 | 2021-05-31 | Champaign | Ohio | 39021 | 3413 | 58 |
1370420 | 1370420 | 2021-05-30 | Pasquotank | North Carolina | 37139 | 3413 | 83 |
1370517 | 1370517 | 2021-05-30 | Champaign | Ohio | 39021 | 3413 | 58 |
1367174 | 1367174 | 2021-05-29 | Pasquotank | North Carolina | 37139 | 3413 | 83 |
1363928 | 1363928 | 2021-05-28 | Pasquotank | North Carolina | 37139 | 3413 | 83 |
1300796 | 1300796 | 2021-05-09 | Toombs | Georgia | 13279 | 3413 | 113 |
1279972 | 1279972 | 2021-05-02 | Clarendon | South Carolina | 45027 | 3413 | 112 |
1235535 | 1235535 | 2021-04-19 | Lake | California | 6033 | 3413 | 43 |
1235868 | 1235868 | 2021-04-19 | Upson | Georgia | 13293 | 3413 | 125 |
1222527 | 1222527 | 2021-04-15 | Yell | Arkansas | 5149 | 3413 | 64 |
1188392 | 1188392 | 2021-04-04 | Belknap | New Hampshire | 33001 | 3413 | 96 |
1180821 | 1180821 | 2021-04-02 | Adams | Indiana | 18001 | 3413 | 53 |
1140921 | 1140921 | 2021-03-20 | Petersburg city | Virginia | 51730 | 3413 | 74 |
1131945 | 1131945 | 2021-03-18 | Unknown | Georgia | 3413 | 11 | |
1130116 | 1130116 | 2021-03-17 | Jackson | North Carolina | 37099 | 3413 | 55 |
1113260 | 1113260 | 2021-03-12 | Beltrami | Minnesota | 27007 | 3413 | 54 |
1106457 | 1106457 | 2021-03-10 | Calloway | Kentucky | 21035 | 3413 | 38 |
1106710 | 1106710 | 2021-03-10 | Hillsdale | Michigan | 26059 | 3413 | 76 |
1103648 | 1103648 | 2021-03-09 | Leflore | Mississippi | 28083 | 3413 | 123 |
1089055 | 1089055 | 2021-03-04 | Whitman | Washington | 53075 | 3413 | 45 |
1085810 | 1085810 | 2021-03-03 | Whitman | Washington | 53075 | 3413 | 45 |
1076233 | 1076233 | 2021-03-01 | Chambers | Alabama | 1017 | 3413 | 110 |
1069201 | 1069201 | 2021-02-26 | Grimes | Texas | 48185 | 3413 | 62 |
1064628 | 1064628 | 2021-02-25 | Polk | Minnesota | 27119 | 3413 | 62 |
1045223 | 1045223 | 2021-02-19 | Lincoln | Mississippi | 28085 | 3413 | 99 |
1037289 | 1037289 | 2021-02-17 | Clarke | Alabama | 1025 | 3413 | 47 |
1030074 | 1030074 | 2021-02-14 | Carroll | Tennessee | 47017 | 3413 | 80 |
1024355 | 1024355 | 2021-02-13 | Tallapoosa | Alabama | 1123 | 3413 | 134 |
1015750 | 1015750 | 2021-02-10 | Kennebec | Maine | 23011 | 3413 | 47 |
977811 | 977811 | 2021-01-29 | Ottawa | Oklahoma | 40115 | 3413 | 34 |
978593 | 978593 | 2021-01-29 | James City | Virginia | 51095 | 3413 | 38 |
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);