ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
124 rows where cases = 4401 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 15
- Florida 8
- Mississippi 7
- Ohio 7
- Indiana 6
- Texas 6
- Virginia 6
- Kansas 5
- Louisiana 5
- New York 5
- North Carolina 5
- Kentucky 4
- Missouri 4
- Montana 4
- New Hampshire 4
- Washington 4
- Alabama 3
- Michigan 3
- Minnesota 3
- West Virginia 3
- Colorado 2
- Puerto Rico 2
- Tennessee 2
- Wisconsin 2
- Arizona 1
- Arkansas 1
- Delaware 1
- Illinois 1
- Iowa 1
- Nebraska 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2490342 | 2490342 | 2022-05-10 | Washington | Georgia | 13303 | 4401 | 137 |
2487085 | 2487085 | 2022-05-09 | Washington | Georgia | 13303 | 4401 | 137 |
2483827 | 2483827 | 2022-05-08 | Washington | Georgia | 13303 | 4401 | 137 |
2480569 | 2480569 | 2022-05-07 | Washington | Georgia | 13303 | 4401 | 137 |
2477311 | 2477311 | 2022-05-06 | Washington | Georgia | 13303 | 4401 | 137 |
2474053 | 2474053 | 2022-05-05 | Washington | Georgia | 13303 | 4401 | 137 |
2470796 | 2470796 | 2022-05-04 | Washington | Georgia | 13303 | 4401 | 137 |
2471505 | 2471505 | 2022-05-04 | Antrim | Michigan | 26009 | 4401 | 65 |
2468249 | 2468249 | 2022-05-03 | Antrim | Michigan | 26009 | 4401 | 65 |
2466123 | 2466123 | 2022-05-02 | Lares | Puerto Rico | 72081 | 4401 | |
2266432 | 2266432 | 2022-03-02 | Winn | Louisiana | 22127 | 4401 | 61 |
2259813 | 2259813 | 2022-02-28 | Lewis | Kentucky | 21135 | 4401 | 79 |
2237622 | 2237622 | 2022-02-21 | Hill | Montana | 30041 | 4401 | 71 |
2234371 | 2234371 | 2022-02-20 | Hill | Montana | 30041 | 4401 | 71 |
2231120 | 2231120 | 2022-02-19 | Hill | Montana | 30041 | 4401 | 71 |
2227869 | 2227869 | 2022-02-18 | Hill | Montana | 30041 | 4401 | 71 |
2223325 | 2223325 | 2022-02-17 | Gilchrist | Florida | 12041 | 4401 | 71 |
2220074 | 2220074 | 2022-02-16 | Gilchrist | Florida | 12041 | 4401 | 71 |
2216823 | 2216823 | 2022-02-15 | Gilchrist | Florida | 12041 | 4401 | 71 |
2213572 | 2213572 | 2022-02-14 | Gilchrist | Florida | 12041 | 4401 | 71 |
2210320 | 2210320 | 2022-02-13 | Gilchrist | Florida | 12041 | 4401 | 71 |
2210485 | 2210485 | 2022-02-13 | Putnam | Georgia | 13237 | 4401 | 97 |
2207067 | 2207067 | 2022-02-12 | Gilchrist | Florida | 12041 | 4401 | 71 |
2207232 | 2207232 | 2022-02-12 | Putnam | Georgia | 13237 | 4401 | 97 |
2203814 | 2203814 | 2022-02-11 | Gilchrist | Florida | 12041 | 4401 | 71 |
2203979 | 2203979 | 2022-02-11 | Putnam | Georgia | 13237 | 4401 | 97 |
2169211 | 2169211 | 2022-01-31 | Clinton | Missouri | 29049 | 4401 | 107 |
2151287 | 2151287 | 2022-01-25 | Lewis | West Virginia | 54041 | 4401 | 72 |
2132322 | 2132322 | 2022-01-20 | Cook | Georgia | 13075 | 4401 | 65 |
2128696 | 2128696 | 2022-01-19 | Randolph | Alabama | 1111 | 4401 | 69 |
2095580 | 2095580 | 2022-01-08 | Frio | Texas | 48163 | 4401 | 79 |
2084705 | 2084705 | 2022-01-05 | Randolph | Missouri | 29175 | 4401 | 86 |
2084812 | 2084812 | 2022-01-05 | Dawson | Nebraska | 31047 | 4401 | 37 |
2061858 | 2061858 | 2021-12-29 | Adair | Missouri | 29001 | 4401 | 53 |
2032544 | 2032544 | 2021-12-20 | Covington | Mississippi | 28031 | 4401 | 95 |
2023460 | 2023460 | 2021-12-17 | Hocking | Ohio | 39073 | 4401 | 94 |
1985485 | 1985485 | 2021-12-05 | Nicholas | West Virginia | 54067 | 4401 | 67 |
1963595 | 1963595 | 2021-11-29 | Jennings | Indiana | 18079 | 4401 | 69 |
1956467 | 1956467 | 2021-11-27 | Carroll | Arkansas | 5015 | 4401 | 75 |
1940820 | 1940820 | 2021-11-22 | Fayette | Indiana | 18041 | 4401 | 97 |
1905061 | 1905061 | 2021-11-11 | Clay | Indiana | 18021 | 4401 | 61 |
1906434 | 1906434 | 2021-11-11 | Gallia | Ohio | 39053 | 4401 | 73 |
1883682 | 1883682 | 2021-11-04 | Fayette | Ohio | 39047 | 4401 | 65 |
1847739 | 1847739 | 2021-10-24 | Orleans | New York | 36073 | 4401 | 89 |
1841223 | 1841223 | 2021-10-22 | Greene | New York | 36039 | 4401 | 86 |
1839097 | 1839097 | 2021-10-21 | Isle of Wight | Virginia | 51093 | 4401 | 85 |
1824200 | 1824200 | 2021-10-17 | Montgomery | Kentucky | 21173 | 4401 | 51 |
1820951 | 1820951 | 2021-10-16 | Montgomery | Kentucky | 21173 | 4401 | 51 |
1817702 | 1817702 | 2021-10-15 | Montgomery | Kentucky | 21173 | 4401 | 51 |
1789227 | 1789227 | 2021-10-06 | Chenango | New York | 36017 | 4401 | 86 |
1766933 | 1766933 | 2021-09-29 | McKean | Pennsylvania | 42083 | 4401 | 76 |
1748299 | 1748299 | 2021-09-23 | Clark | Wisconsin | 55019 | 4401 | 71 |
1733595 | 1733595 | 2021-09-19 | Leflore | Mississippi | 28083 | 4401 | 140 |
1730345 | 1730345 | 2021-09-18 | Leflore | Mississippi | 28083 | 4401 | 140 |
1727095 | 1727095 | 2021-09-17 | Leflore | Mississippi | 28083 | 4401 | 140 |
1724537 | 1724537 | 2021-09-16 | Williams | Ohio | 39171 | 4401 | 81 |
1720124 | 1720124 | 2021-09-15 | Seward | Kansas | 20175 | 4401 | 43 |
1716876 | 1716876 | 2021-09-14 | Seward | Kansas | 20175 | 4401 | 43 |
1691692 | 1691692 | 2021-09-06 | Cheshire | New Hampshire | 33005 | 4401 | 40 |
1688442 | 1688442 | 2021-09-05 | Cheshire | New Hampshire | 33005 | 4401 | 40 |
1685192 | 1685192 | 2021-09-04 | Cheshire | New Hampshire | 33005 | 4401 | 40 |
1681941 | 1681941 | 2021-09-03 | Cheshire | New Hampshire | 33005 | 4401 | 40 |
1621447 | 1621447 | 2021-08-15 | Manassas city | Virginia | 51683 | 4401 | 48 |
1618199 | 1618199 | 2021-08-14 | Manassas city | Virginia | 51683 | 4401 | 48 |
1614951 | 1614951 | 2021-08-13 | Manassas city | Virginia | 51683 | 4401 | 48 |
1611702 | 1611702 | 2021-08-12 | Manassas city | Virginia | 51683 | 4401 | 48 |
1600956 | 1600956 | 2021-08-09 | Yadkin | North Carolina | 37197 | 4401 | 56 |
1583387 | 1583387 | 2021-08-04 | Randolph | Illinois | 17157 | 4401 | 93 |
1580922 | 1580922 | 2021-08-03 | Neshoba | Mississippi | 28099 | 4401 | 181 |
1551179 | 1551179 | 2021-07-25 | Lyon | Kansas | 20111 | 4401 | 88 |
1553090 | 1553090 | 2021-07-25 | Washington | Texas | 48477 | 4401 | 96 |
1547932 | 1547932 | 2021-07-24 | Lyon | Kansas | 20111 | 4401 | 88 |
1549843 | 1549843 | 2021-07-24 | Washington | Texas | 48477 | 4401 | 96 |
1544685 | 1544685 | 2021-07-23 | Lyon | Kansas | 20111 | 4401 | 88 |
1519334 | 1519334 | 2021-07-15 | Platte | Missouri | 29165 | 4401 | 50 |
1514527 | 1514527 | 2021-07-14 | Covington | Alabama | 1039 | 4401 | 125 |
1468559 | 1468559 | 2021-06-29 | Jim Wells | Texas | 48249 | 4401 | 108 |
1447099 | 1447099 | 2021-06-23 | Montgomery | Indiana | 18107 | 4401 | 92 |
1448919 | 1448919 | 2021-06-23 | Lincoln | Tennessee | 47103 | 4401 | 67 |
1441207 | 1441207 | 2021-06-21 | Isanti | Minnesota | 27059 | 4401 | 64 |
1372873 | 1372873 | 2021-05-31 | Washington | Louisiana | 22117 | 4401 | 133 |
1369628 | 1369628 | 2021-05-30 | Washington | Louisiana | 22117 | 4401 | 133 |
1366382 | 1366382 | 2021-05-29 | Washington | Louisiana | 22117 | 4401 | 133 |
1363136 | 1363136 | 2021-05-28 | Washington | Louisiana | 22117 | 4401 | 133 |
1339957 | 1339957 | 2021-05-21 | Gibson | Indiana | 18051 | 4401 | 95 |
1337886 | 1337886 | 2021-05-20 | Alexander | North Carolina | 37003 | 4401 | 84 |
1331392 | 1331392 | 2021-05-18 | Alexander | North Carolina | 37003 | 4401 | 84 |
1331434 | 1331434 | 2021-05-18 | Haywood | North Carolina | 37087 | 4401 | 96 |
1331595 | 1331595 | 2021-05-18 | Madison | Ohio | 39097 | 4401 | 63 |
1222593 | 1222593 | 2021-04-15 | Broomfield | Colorado | 8014 | 4401 | 75 |
1198308 | 1198308 | 2021-04-07 | Hoke | North Carolina | 37093 | 4401 | 55 |
1192846 | 1192846 | 2021-04-05 | Henry | Virginia | 51089 | 4401 | 121 |
1167569 | 1167569 | 2021-03-29 | Effingham | Georgia | 13103 | 4401 | 65 |
1161027 | 1161027 | 2021-03-27 | Baldwin | Georgia | 13009 | 4401 | 123 |
1154080 | 1154080 | 2021-03-24 | Marinette | Wisconsin | 55075 | 4401 | 68 |
1136125 | 1136125 | 2021-03-19 | Panola | Mississippi | 28107 | 4401 | 100 |
1134060 | 1134060 | 2021-03-18 | Burnet | Texas | 48053 | 4401 | 61 |
1118080 | 1118080 | 2021-03-13 | Wasatch | Utah | 49051 | 4401 | 20 |
1082534 | 1082534 | 2021-03-02 | Cowlitz | Washington | 53015 | 4401 | 64 |
1065376 | 1065376 | 2021-02-25 | Shelby | Ohio | 39149 | 4401 | 68 |
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);