ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
138 rows where cases = 4127 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Illinois 10
- Iowa 9
- Mississippi 9
- Texas 9
- Georgia 8
- Kentucky 7
- North Carolina 7
- Pennsylvania 7
- Ohio 6
- Tennessee 6
- Missouri 5
- Virginia 5
- Alabama 4
- New York 4
- Arizona 3
- Indiana 3
- Montana 3
- Nevada 3
- South Carolina 3
- Arkansas 2
- California 2
- Florida 2
- Idaho 2
- Kansas 2
- Minnesota 2
- New Mexico 2
- Puerto Rico 2
- Alaska 1
- Colorado 1
- Louisiana 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501057 | 2501057 | 2022-05-13 | Smith | Mississippi | 28129 | 4127 | 68 |
2497799 | 2497799 | 2022-05-12 | Smith | Mississippi | 28129 | 4127 | 68 |
2494541 | 2494541 | 2022-05-11 | Smith | Mississippi | 28129 | 4127 | 68 |
2491283 | 2491283 | 2022-05-10 | Smith | Mississippi | 28129 | 4127 | 68 |
2488026 | 2488026 | 2022-05-09 | Smith | Mississippi | 28129 | 4127 | 68 |
2446842 | 2446842 | 2022-04-26 | Aransas | Texas | 48007 | 4127 | 84 |
2426972 | 2426972 | 2022-04-20 | Fulton | Pennsylvania | 42057 | 4127 | 65 |
2423716 | 2423716 | 2022-04-19 | Fulton | Pennsylvania | 42057 | 4127 | 65 |
2405539 | 2405539 | 2022-04-14 | Brantley | Georgia | 13025 | 4127 | 108 |
2399453 | 2399453 | 2022-04-12 | Dickinson | Iowa | 19059 | 4127 | 72 |
2396197 | 2396197 | 2022-04-11 | Dickinson | Iowa | 19059 | 4127 | 72 |
2392942 | 2392942 | 2022-04-10 | Dickinson | Iowa | 19059 | 4127 | 72 |
2394470 | 2394470 | 2022-04-10 | Catano | Puerto Rico | 72033 | 4127 | |
2389686 | 2389686 | 2022-04-09 | Dickinson | Iowa | 19059 | 4127 | 72 |
2386430 | 2386430 | 2022-04-08 | Dickinson | Iowa | 19059 | 4127 | 72 |
2383176 | 2383176 | 2022-04-07 | Dickinson | Iowa | 19059 | 4127 | 72 |
2379921 | 2379921 | 2022-04-06 | Dickinson | Iowa | 19059 | 4127 | 72 |
2266770 | 2266770 | 2022-03-02 | Cooper | Missouri | 29053 | 4127 | 74 |
2257017 | 2257017 | 2022-02-27 | Cooper | Missouri | 29053 | 4127 | 74 |
2253766 | 2253766 | 2022-02-26 | Cooper | Missouri | 29053 | 4127 | 74 |
2250515 | 2250515 | 2022-02-25 | Cooper | Missouri | 29053 | 4127 | 74 |
2198879 | 2198879 | 2022-02-09 | Bertie | North Carolina | 37015 | 4127 | 63 |
2171577 | 2171577 | 2022-02-01 | Hancock | Illinois | 17067 | 4127 | 53 |
2165054 | 2165054 | 2022-01-30 | De Witt | Illinois | 17039 | 4127 | 40 |
2167272 | 2167272 | 2022-01-30 | Shelby | Texas | 48419 | 4127 | 117 |
2161799 | 2161799 | 2022-01-29 | De Witt | Illinois | 17039 | 4127 | 40 |
2158544 | 2158544 | 2022-01-28 | De Witt | Illinois | 17039 | 4127 | 40 |
2157903 | 2157903 | 2022-01-27 | Carbon | Wyoming | 56007 | 4127 | 50 |
2126497 | 2126497 | 2022-01-18 | Spencer | Kentucky | 21215 | 4127 | 44 |
2121676 | 2121676 | 2022-01-16 | Milam | Texas | 48331 | 4127 | 93 |
2112954 | 2112954 | 2022-01-14 | Cassia | Idaho | 16031 | 4127 | 48 |
2106002 | 2106002 | 2022-01-12 | Columbia | Arkansas | 5027 | 4127 | 77 |
2103062 | 2103062 | 2022-01-11 | Dodge | Georgia | 13091 | 4127 | 137 |
2034170 | 2034170 | 2021-12-20 | Winchester city | Virginia | 51840 | 4127 | 57 |
2018396 | 2018396 | 2021-12-16 | Montezuma | Colorado | 8083 | 4127 | 51 |
2014981 | 2014981 | 2021-12-15 | Cleburne | Arkansas | 5023 | 4127 | 97 |
1969429 | 1969429 | 2021-12-01 | Juneau City and Borough | Alaska | 2110 | 4127 | 12 |
1928548 | 1928548 | 2021-11-18 | Leake | Mississippi | 28079 | 4127 | 90 |
1926464 | 1926464 | 2021-11-17 | Wayne | Tennessee | 47181 | 4127 | 39 |
1907273 | 1907273 | 2021-11-11 | Accomack | Virginia | 51001 | 4127 | 80 |
1899437 | 1899437 | 2021-11-09 | Saline | Missouri | 29195 | 4127 | 48 |
1827790 | 1827790 | 2021-10-18 | Coahoma | Mississippi | 28027 | 4127 | 104 |
1813950 | 1813950 | 2021-10-14 | Jerome | Idaho | 16053 | 4127 | 44 |
1809476 | 1809476 | 2021-10-12 | Smith | Tennessee | 47159 | 4127 | 50 |
1789276 | 1789276 | 2021-10-06 | Wyoming | New York | 36121 | 4127 | 55 |
1779402 | 1779402 | 2021-10-03 | Nye | Nevada | 32023 | 4127 | 135 |
1776152 | 1776152 | 2021-10-02 | Nye | Nevada | 32023 | 4127 | 135 |
1772902 | 1772902 | 2021-10-01 | Nye | Nevada | 32023 | 4127 | 135 |
1769953 | 1769953 | 2021-09-30 | Coshocton | Ohio | 39031 | 4127 | 70 |
1761417 | 1761417 | 2021-09-28 | Lawrence | Alabama | 1079 | 4127 | 108 |
1734457 | 1734457 | 2021-09-19 | Snyder | Pennsylvania | 42109 | 4127 | 92 |
1697756 | 1697756 | 2021-09-08 | Freeborn | Minnesota | 27047 | 4127 | 37 |
1671349 | 1671349 | 2021-08-31 | Harvey | Kansas | 20079 | 4127 | 74 |
1668102 | 1668102 | 2021-08-30 | Harvey | Kansas | 20079 | 4127 | 74 |
1664931 | 1664931 | 2021-08-29 | Boyle | Kentucky | 21021 | 4127 | 80 |
1666496 | 1666496 | 2021-08-29 | Lauderdale | Tennessee | 47097 | 4127 | 50 |
1661683 | 1661683 | 2021-08-28 | Boyle | Kentucky | 21021 | 4127 | 80 |
1663248 | 1663248 | 2021-08-28 | Lauderdale | Tennessee | 47097 | 4127 | 50 |
1658435 | 1658435 | 2021-08-27 | Boyle | Kentucky | 21021 | 4127 | 80 |
1660000 | 1660000 | 2021-08-27 | Lauderdale | Tennessee | 47097 | 4127 | 50 |
1650110 | 1650110 | 2021-08-24 | Clarendon | South Carolina | 45027 | 4127 | 116 |
1641718 | 1641718 | 2021-08-22 | Upson | Georgia | 13293 | 4127 | 135 |
1638468 | 1638468 | 2021-08-21 | Upson | Georgia | 13293 | 4127 | 135 |
1635218 | 1635218 | 2021-08-20 | Upson | Georgia | 13293 | 4127 | 135 |
1631935 | 1631935 | 2021-08-19 | Pickens | Georgia | 13227 | 4127 | 81 |
1633561 | 1633561 | 2021-08-19 | Preble | Ohio | 39135 | 4127 | 107 |
1559046 | 1559046 | 2021-07-27 | Venango | Pennsylvania | 42121 | 4127 | 102 |
1518872 | 1518872 | 2021-07-15 | Whitley | Kentucky | 21235 | 4127 | 62 |
1514229 | 1514229 | 2021-07-13 | Franklin | Virginia | 51067 | 4127 | 82 |
1461709 | 1461709 | 2021-06-27 | Ponce | Puerto Rico | 72113 | 4127 | |
1447506 | 1447506 | 2021-06-23 | St. Bernard | Louisiana | 22087 | 4127 | 54 |
1428868 | 1428868 | 2021-06-17 | Yadkin | North Carolina | 37197 | 4127 | 54 |
1417191 | 1417191 | 2021-06-14 | Tallapoosa | Alabama | 1123 | 4127 | 154 |
1416209 | 1416209 | 2021-06-13 | Wayne | Pennsylvania | 42127 | 4127 | 82 |
1412963 | 1412963 | 2021-06-12 | Wayne | Pennsylvania | 42127 | 4127 | 82 |
1392824 | 1392824 | 2021-06-06 | Silver Bow | Montana | 30093 | 4127 | 86 |
1389579 | 1389579 | 2021-06-05 | Silver Bow | Montana | 30093 | 4127 | 86 |
1386334 | 1386334 | 2021-06-04 | Silver Bow | Montana | 30093 | 4127 | 86 |
1351832 | 1351832 | 2021-05-24 | Washington | Texas | 48477 | 4127 | 93 |
1337442 | 1337442 | 2021-05-20 | Monroe | Mississippi | 28095 | 4127 | 134 |
1326449 | 1326449 | 2021-05-17 | Mendocino | California | 6045 | 4127 | 49 |
1316117 | 1316117 | 2021-05-13 | Wharton | Texas | 48481 | 4127 | 116 |
1307440 | 1307440 | 2021-05-11 | Randolph | Illinois | 17157 | 4127 | 90 |
1297700 | 1297700 | 2021-05-08 | Randolph | Illinois | 17157 | 4127 | 90 |
1284882 | 1284882 | 2021-05-04 | Jasper | Iowa | 19099 | 4127 | 70 |
1255856 | 1255856 | 2021-04-25 | Graves | Kentucky | 21083 | 4127 | 92 |
1247159 | 1247159 | 2021-04-22 | Fulton | Ohio | 39051 | 4127 | 67 |
1225036 | 1225036 | 2021-04-15 | Erath | Texas | 48143 | 4127 | 68 |
1216486 | 1216486 | 2021-04-13 | Jefferson | Illinois | 17081 | 4127 | 119 |
1192977 | 1192977 | 2021-04-05 | Jefferson | West Virginia | 54037 | 4127 | 47 |
1175352 | 1175352 | 2021-03-31 | Madison | Nebraska | 31119 | 4127 | 42 |
1150632 | 1150632 | 2021-03-23 | James City | Virginia | 51095 | 4127 | 69 |
1132144 | 1132144 | 2021-03-18 | Harrison | Indiana | 18061 | 4127 | 70 |
1125645 | 1125645 | 2021-03-16 | Gibson | Indiana | 18051 | 4127 | 89 |
1126377 | 1126377 | 2021-03-16 | Marshall | Mississippi | 28093 | 4127 | 98 |
1099635 | 1099635 | 2021-03-08 | Stephenson | Illinois | 17177 | 4127 | 95 |
1101901 | 1101901 | 2021-03-08 | Culpeper | Virginia | 51047 | 4127 | 55 |
1079092 | 1079092 | 2021-03-01 | Wilson | Texas | 48493 | 4127 | 55 |
1074901 | 1074901 | 2021-02-28 | Chatham | North Carolina | 37037 | 4127 | 76 |
1075847 | 1075847 | 2021-02-28 | Wilson | Texas | 48493 | 4127 | 55 |
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);