ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
117 rows where cases = 3774 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Virginia 13
- Texas 12
- California 6
- Tennessee 6
- Arkansas 5
- Georgia 5
- Missouri 5
- Ohio 5
- South Carolina 5
- Virgin Islands 5
- West Virginia 5
- Colorado 4
- Michigan 4
- Puerto Rico 4
- Alabama 3
- Idaho 3
- Indiana 3
- Minnesota 3
- Wisconsin 3
- Florida 2
- New Jersey 2
- Vermont 2
- Alaska 1
- Illinois 1
- Kentucky 1
- Louisiana 1
- Maryland 1
- Mississippi 1
- Nevada 1
- New York 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2472666 | 2472666 | 2022-05-04 | Utuado | Puerto Rico | 72141 | 3774 | |
2427789 | 2427789 | 2022-04-20 | Grant | West Virginia | 54023 | 3774 | 56 |
2396721 | 2396721 | 2022-04-11 | Faribault | Minnesota | 27043 | 3774 | 50 |
2336223 | 2336223 | 2022-03-23 | Colorado | Texas | 48089 | 3774 | 62 |
2313697 | 2313697 | 2022-03-16 | Lamoille | Vermont | 50015 | 3774 | 17 |
2284896 | 2284896 | 2022-03-08 | Franklin | Arkansas | 5047 | 3774 | 71 |
2270026 | 2270026 | 2022-03-03 | Dallas | Missouri | 29059 | 3774 | 70 |
2268441 | 2268441 | 2022-03-02 | Marquette | Wisconsin | 55077 | 3774 | 55 |
2215858 | 2215858 | 2022-02-14 | Andrews | Texas | 48003 | 3774 | 70 |
2212607 | 2212607 | 2022-02-13 | Andrews | Texas | 48003 | 3774 | 70 |
2209354 | 2209354 | 2022-02-12 | Andrews | Texas | 48003 | 3774 | 70 |
2197119 | 2197119 | 2022-02-09 | Madison | Arkansas | 5087 | 3774 | 53 |
2180358 | 2180358 | 2022-02-03 | Addison | Vermont | 50001 | 3774 | 13 |
2144071 | 2144071 | 2022-01-23 | Yauco | Puerto Rico | 72153 | 3774 | |
2127504 | 2127504 | 2022-01-18 | Meigs | Ohio | 39105 | 3774 | 73 |
2121679 | 2121679 | 2022-01-16 | Montague | Texas | 48337 | 3774 | 104 |
2091974 | 2091974 | 2022-01-07 | Cidra | Puerto Rico | 72041 | 3774 | |
2076403 | 2076403 | 2022-01-02 | Scott | Virginia | 51169 | 3774 | 92 |
2073152 | 2073152 | 2022-01-01 | Scott | Virginia | 51169 | 3774 | 92 |
2069901 | 2069901 | 2021-12-31 | Scott | Virginia | 51169 | 3774 | 92 |
2053539 | 2053539 | 2021-12-26 | St. Thomas | Virgin Islands | 78030 | 3774 | 46 |
2050289 | 2050289 | 2021-12-25 | St. Thomas | Virgin Islands | 78030 | 3774 | 46 |
2047039 | 2047039 | 2021-12-24 | St. Thomas | Virgin Islands | 78030 | 3774 | 46 |
2043789 | 2043789 | 2021-12-23 | St. Thomas | Virgin Islands | 78030 | 3774 | 46 |
2040540 | 2040540 | 2021-12-22 | St. Thomas | Virgin Islands | 78030 | 3774 | 46 |
2037409 | 2037409 | 2021-12-21 | Staunton city | Virginia | 51790 | 3774 | 86 |
2020743 | 2020743 | 2021-12-16 | Austin | Texas | 48015 | 3774 | 56 |
2015009 | 2015009 | 2021-12-15 | Lincoln | Arkansas | 5079 | 3774 | 58 |
2012385 | 2012385 | 2021-12-14 | Spencer | Indiana | 18147 | 3774 | 50 |
1974009 | 1974009 | 2021-12-02 | Wabasha | Minnesota | 27157 | 3774 | 10 |
1972392 | 1972392 | 2021-12-01 | Salem city | Virginia | 51775 | 3774 | 69 |
1969157 | 1969157 | 2021-11-30 | Waynesboro city | Virginia | 51820 | 3774 | 50 |
1938369 | 1938369 | 2021-11-21 | Crawford | Missouri | 29055 | 3774 | 73 |
1923718 | 1923718 | 2021-11-16 | Mason | West Virginia | 54053 | 3774 | 60 |
1916669 | 1916669 | 2021-11-14 | Johnson | Tennessee | 47091 | 3774 | 52 |
1913419 | 1913419 | 2021-11-13 | Johnson | Tennessee | 47091 | 3774 | 52 |
1910169 | 1910169 | 2021-11-12 | Johnson | Tennessee | 47091 | 3774 | 52 |
1882678 | 1882678 | 2021-11-04 | McCreary | Kentucky | 21147 | 3774 | 56 |
1876406 | 1876406 | 2021-11-02 | Oceana | Michigan | 26127 | 3774 | 70 |
1878231 | 1878231 | 2021-11-02 | Nicholas | West Virginia | 54067 | 3774 | 49 |
1878322 | 1878322 | 2021-11-02 | Waushara | Wisconsin | 55137 | 3774 | 53 |
1873157 | 1873157 | 2021-11-01 | Oceana | Michigan | 26127 | 3774 | 70 |
1849182 | 1849182 | 2021-10-25 | Juneau City and Borough | Alaska | 2110 | 3774 | 9 |
1835547 | 1835547 | 2021-10-20 | Dimmit | Texas | 48127 | 3774 | 45 |
1819730 | 1819730 | 2021-10-15 | Jackson | West Virginia | 54035 | 3774 | 79 |
1756491 | 1756491 | 2021-09-26 | Washington | Missouri | 29221 | 3774 | 59 |
1626075 | 1626075 | 2021-08-17 | De Soto | Louisiana | 22031 | 3774 | 86 |
1604299 | 1604299 | 2021-08-10 | Highland | Ohio | 39071 | 3774 | 68 |
1598043 | 1598043 | 2021-08-08 | Arecibo | Puerto Rico | 72013 | 3774 | |
1575697 | 1575697 | 2021-08-01 | Hopkins | Texas | 48223 | 3774 | 114 |
1527700 | 1527700 | 2021-07-18 | Lake | California | 6033 | 3774 | 64 |
1530545 | 1530545 | 2021-07-18 | Tazewell | Virginia | 51185 | 3774 | 75 |
1524453 | 1524453 | 2021-07-17 | Lake | California | 6033 | 3774 | 64 |
1527298 | 1527298 | 2021-07-17 | Tazewell | Virginia | 51185 | 3774 | 75 |
1521205 | 1521205 | 2021-07-16 | Lake | California | 6033 | 3774 | 64 |
1524051 | 1524051 | 2021-07-16 | Tazewell | Virginia | 51185 | 3774 | 75 |
1516067 | 1516067 | 2021-07-14 | Marion | Missouri | 29127 | 3774 | 53 |
1505359 | 1505359 | 2021-07-11 | Nez Perce | Idaho | 16069 | 3774 | 60 |
1502113 | 1502113 | 2021-07-10 | Nez Perce | Idaho | 16069 | 3774 | 60 |
1498867 | 1498867 | 2021-07-09 | Nez Perce | Idaho | 16069 | 3774 | 60 |
1488840 | 1488840 | 2021-07-06 | Summit | Colorado | 8117 | 3774 | 8 |
1485593 | 1485593 | 2021-07-05 | Summit | Colorado | 8117 | 3774 | 8 |
1482347 | 1482347 | 2021-07-04 | Summit | Colorado | 8117 | 3774 | 8 |
1466218 | 1466218 | 2021-06-29 | Bryan | Georgia | 13029 | 3774 | 41 |
1462973 | 1462973 | 2021-06-28 | Bryan | Georgia | 13029 | 3774 | 41 |
1397126 | 1397126 | 2021-06-07 | Grimes | Texas | 48185 | 3774 | 72 |
1383502 | 1383502 | 2021-06-03 | Clinton | Ohio | 39027 | 3774 | 66 |
1380256 | 1380256 | 2021-06-02 | Clinton | Ohio | 39027 | 3774 | 66 |
1365012 | 1365012 | 2021-05-28 | York | Virginia | 51199 | 3774 | 54 |
1360604 | 1360604 | 2021-05-27 | Tioga | New York | 36107 | 3774 | 62 |
1361766 | 1361766 | 2021-05-27 | York | Virginia | 51199 | 3774 | 54 |
1338652 | 1338652 | 2021-05-20 | Cooke | Texas | 48097 | 3774 | 72 |
1271703 | 1271703 | 2021-04-30 | Logan | Illinois | 17107 | 3774 | 70 |
1270998 | 1270998 | 2021-04-29 | Oneida | Wisconsin | 55085 | 3774 | 75 |
1263414 | 1263414 | 2021-04-27 | Logan | Ohio | 39091 | 3774 | 76 |
1239936 | 1239936 | 2021-04-20 | Itasca | Minnesota | 27061 | 3774 | 53 |
1223079 | 1223079 | 2021-04-15 | Huntington | Indiana | 18069 | 3774 | 82 |
1216261 | 1216261 | 2021-04-13 | Chattahoochee | Georgia | 13053 | 3774 | 14 |
1154022 | 1154022 | 2021-03-24 | Ohio | West Virginia | 54069 | 3774 | 77 |
1146399 | 1146399 | 2021-03-22 | Yadkin | North Carolina | 37197 | 3774 | 47 |
1129370 | 1129370 | 2021-03-17 | Calvert | Maryland | 24009 | 3774 | 73 |
1115459 | 1115459 | 2021-03-13 | Logan | Colorado | 8075 | 3774 | 65 |
1104618 | 1104618 | 2021-03-09 | Chester | South Carolina | 45023 | 3774 | 69 |
1082711 | 1082711 | 2021-03-02 | Sweetwater | Wyoming | 56037 | 3774 | 35 |
1073005 | 1073005 | 2021-02-28 | Escambia | Alabama | 1053 | 3774 | 72 |
1066514 | 1066514 | 2021-02-26 | Escambia | Alabama | 1053 | 3774 | 72 |
1065700 | 1065700 | 2021-02-25 | Williamsburg | South Carolina | 45089 | 3774 | 88 |
1059284 | 1059284 | 2021-02-23 | Campbell | Tennessee | 47013 | 3774 | 58 |
1059370 | 1059370 | 2021-02-23 | Weakley | Tennessee | 47183 | 3774 | 59 |
1052526 | 1052526 | 2021-02-21 | Bedford | Pennsylvania | 42009 | 3774 | 128 |
1050000 | 1050000 | 2021-02-20 | James City | Virginia | 51095 | 3774 | 45 |
1034246 | 1034246 | 2021-02-16 | Nevada | California | 6057 | 3774 | 74 |
1034749 | 1034749 | 2021-02-16 | DeKalb | Indiana | 18033 | 3774 | 81 |
1018044 | 1018044 | 2021-02-11 | Tuolumne | California | 6109 | 3774 | 52 |
1011333 | 1011333 | 2021-02-09 | Covington | Alabama | 1039 | 3774 | 92 |
1001076 | 1001076 | 2021-02-05 | Jim Wells | Texas | 48249 | 3774 | 79 |
1001330 | 1001330 | 2021-02-05 | Manassas city | Virginia | 51683 | 3774 | 33 |
984548 | 984548 | 2021-01-31 | Newberry | South Carolina | 45071 | 3774 | 79 |
960854 | 960854 | 2021-01-24 | Pontotoc | Mississippi | 28115 | 3774 | 60 |
948605 | 948605 | 2021-01-20 | Osage | Oklahoma | 40113 | 3774 | 35 |
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);