ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
121 rows where cases = 4105 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Oklahoma 18
- Virginia 8
- Indiana 7
- Iowa 7
- Alabama 6
- Illinois 6
- Pennsylvania 6
- Tennessee 6
- Georgia 5
- Colorado 4
- Mississippi 4
- North Carolina 4
- Arkansas 3
- California 3
- Kentucky 3
- Minnesota 3
- Missouri 3
- Ohio 3
- Puerto Rico 3
- South Dakota 3
- Utah 3
- Louisiana 2
- South Carolina 2
- Wyoming 2
- Florida 1
- Maryland 1
- Michigan 1
- New Hampshire 1
- New York 1
- Texas 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500219 | 2500219 | 2022-05-13 | Jo Daviess | Illinois | 17085 | 4105 | 39 |
2436782 | 2436782 | 2022-04-23 | Aguas Buenas | Puerto Rico | 72007 | 4105 | |
2424051 | 2424051 | 2022-04-19 | Aransas | Texas | 48007 | 4105 | 84 |
2387958 | 2387958 | 2022-04-08 | Catano | Puerto Rico | 72033 | 4105 | |
2335763 | 2335763 | 2022-03-23 | Pawnee | Oklahoma | 40117 | 4105 | 84 |
2332509 | 2332509 | 2022-03-22 | Pawnee | Oklahoma | 40117 | 4105 | 84 |
2329256 | 2329256 | 2022-03-21 | Pawnee | Oklahoma | 40117 | 4105 | 84 |
2326004 | 2326004 | 2022-03-20 | Pawnee | Oklahoma | 40117 | 4105 | 84 |
2322751 | 2322751 | 2022-03-19 | Pawnee | Oklahoma | 40117 | 4105 | 84 |
2319497 | 2319497 | 2022-03-18 | Pawnee | Oklahoma | 40117 | 4105 | 84 |
2316243 | 2316243 | 2022-03-17 | Pawnee | Oklahoma | 40117 | 4105 | 84 |
2307691 | 2307691 | 2022-03-15 | Polk | Arkansas | 5113 | 4105 | 142 |
2308362 | 2308362 | 2022-03-15 | Hardin | Iowa | 19083 | 4105 | 59 |
2304440 | 2304440 | 2022-03-14 | Polk | Arkansas | 5113 | 4105 | 142 |
2305111 | 2305111 | 2022-03-14 | Hardin | Iowa | 19083 | 4105 | 59 |
2301859 | 2301859 | 2022-03-13 | Hardin | Iowa | 19083 | 4105 | 59 |
2298607 | 2298607 | 2022-03-12 | Hardin | Iowa | 19083 | 4105 | 59 |
2295355 | 2295355 | 2022-03-11 | Hardin | Iowa | 19083 | 4105 | 59 |
2292103 | 2292103 | 2022-03-10 | Hardin | Iowa | 19083 | 4105 | 59 |
2288851 | 2288851 | 2022-03-09 | Hardin | Iowa | 19083 | 4105 | 59 |
2257718 | 2257718 | 2022-02-27 | Unknown | Oklahoma | 4105 | 0 | |
2254467 | 2254467 | 2022-02-26 | Unknown | Oklahoma | 4105 | 0 | |
2251216 | 2251216 | 2022-02-25 | Unknown | Oklahoma | 4105 | 0 | |
2217836 | 2217836 | 2022-02-15 | Houston | Minnesota | 27055 | 4105 | 18 |
2214754 | 2214754 | 2022-02-14 | Cooper | Missouri | 29053 | 4105 | 73 |
2179858 | 2179858 | 2022-02-03 | Yabucoa | Puerto Rico | 72151 | 4105 | |
2166932 | 2166932 | 2022-01-30 | Hughes | South Dakota | 46065 | 4105 | 57 |
2163677 | 2163677 | 2022-01-29 | Hughes | South Dakota | 46065 | 4105 | 57 |
2160422 | 2160422 | 2022-01-28 | Hughes | South Dakota | 46065 | 4105 | 57 |
2154431 | 2154431 | 2022-01-26 | New Kent | Virginia | 51127 | 4105 | 28 |
2122441 | 2122441 | 2022-01-17 | Teller | Colorado | 8119 | 4105 | 55 |
2106341 | 2106341 | 2022-01-12 | Hart | Georgia | 13147 | 4105 | 76 |
2100105 | 2100105 | 2022-01-10 | Fulton | Indiana | 18049 | 4105 | 91 |
2080917 | 2080917 | 2022-01-04 | Hart | Kentucky | 21099 | 4105 | 83 |
2001977 | 2001977 | 2021-12-11 | Cleburne | Arkansas | 5023 | 4105 | 95 |
1941704 | 1941704 | 2021-11-22 | Washington | Missouri | 29221 | 4105 | 94 |
1938065 | 1938065 | 2021-11-21 | Queen Anne's | Maryland | 24035 | 4105 | 74 |
1891847 | 1891847 | 2021-11-07 | Peach | Georgia | 13225 | 4105 | 104 |
1888597 | 1888597 | 2021-11-06 | Peach | Georgia | 13225 | 4105 | 104 |
1885347 | 1885347 | 2021-11-05 | Peach | Georgia | 13225 | 4105 | 104 |
1884524 | 1884524 | 2021-11-04 | Accomack | Virginia | 51001 | 4105 | 79 |
1877319 | 1877319 | 2021-11-02 | Texas | Oklahoma | 40139 | 4105 | 39 |
1874070 | 1874070 | 2021-11-01 | Texas | Oklahoma | 40139 | 4105 | 39 |
1870821 | 1870821 | 2021-10-31 | Texas | Oklahoma | 40139 | 4105 | 39 |
1867572 | 1867572 | 2021-10-30 | Texas | Oklahoma | 40139 | 4105 | 39 |
1864323 | 1864323 | 2021-10-29 | Texas | Oklahoma | 40139 | 4105 | 39 |
1861074 | 1861074 | 2021-10-28 | Texas | Oklahoma | 40139 | 4105 | 39 |
1857825 | 1857825 | 2021-10-27 | Texas | Oklahoma | 40139 | 4105 | 39 |
1839221 | 1839221 | 2021-10-21 | Hancock | West Virginia | 54029 | 4105 | 112 |
1808297 | 1808297 | 2021-10-12 | Coahoma | Mississippi | 28027 | 4105 | 104 |
1801089 | 1801089 | 2021-10-10 | Decatur | Indiana | 18031 | 4105 | 105 |
1802976 | 1802976 | 2021-10-10 | Smith | Tennessee | 47159 | 4105 | 48 |
1797840 | 1797840 | 2021-10-09 | Decatur | Indiana | 18031 | 4105 | 105 |
1799727 | 1799727 | 2021-10-09 | Smith | Tennessee | 47159 | 4105 | 48 |
1794591 | 1794591 | 2021-10-08 | Decatur | Indiana | 18031 | 4105 | 105 |
1796478 | 1796478 | 2021-10-08 | Smith | Tennessee | 47159 | 4105 | 48 |
1788012 | 1788012 | 2021-10-06 | Iroquois | Illinois | 17075 | 4105 | 78 |
1746223 | 1746223 | 2021-09-23 | Montgomery | Kentucky | 21173 | 4105 | 38 |
1714141 | 1714141 | 2021-09-13 | Yazoo | Mississippi | 28163 | 4105 | 86 |
1699648 | 1699648 | 2021-09-08 | Sheridan | Wyoming | 56033 | 4105 | 35 |
1646861 | 1646861 | 2021-08-23 | Clarendon | South Carolina | 45027 | 4105 | 116 |
1621975 | 1621975 | 2021-08-16 | Logan | Colorado | 8075 | 4105 | 69 |
1602490 | 1602490 | 2021-08-10 | Montrose | Colorado | 8085 | 4105 | 72 |
1598603 | 1598603 | 2021-08-08 | Sanpete | Utah | 49039 | 4105 | 25 |
1595354 | 1595354 | 2021-08-07 | Sanpete | Utah | 49039 | 4105 | 25 |
1592105 | 1592105 | 2021-08-06 | Sanpete | Utah | 49039 | 4105 | 25 |
1557351 | 1557351 | 2021-07-27 | Fulton | Illinois | 17057 | 4105 | 67 |
1559037 | 1559037 | 2021-07-27 | Pike | Pennsylvania | 42103 | 4105 | 54 |
1516088 | 1516088 | 2021-07-14 | Polk | Missouri | 29167 | 4105 | 42 |
1494106 | 1494106 | 2021-07-07 | Venango | Pennsylvania | 42121 | 4105 | 102 |
1490859 | 1490859 | 2021-07-06 | Venango | Pennsylvania | 42121 | 4105 | 102 |
1487612 | 1487612 | 2021-07-05 | Venango | Pennsylvania | 42121 | 4105 | 102 |
1484365 | 1484365 | 2021-07-04 | Venango | Pennsylvania | 42121 | 4105 | 102 |
1465535 | 1465535 | 2021-06-28 | Franklin | Virginia | 51067 | 4105 | 81 |
1462290 | 1462290 | 2021-06-27 | Franklin | Virginia | 51067 | 4105 | 80 |
1459045 | 1459045 | 2021-06-26 | Franklin | Virginia | 51067 | 4105 | 80 |
1455800 | 1455800 | 2021-06-25 | Franklin | Virginia | 51067 | 4105 | 80 |
1405311 | 1405311 | 2021-06-10 | St. Bernard | Louisiana | 22087 | 4105 | 54 |
1380509 | 1380509 | 2021-06-02 | Wayne | Pennsylvania | 42127 | 4105 | 80 |
1328228 | 1328228 | 2021-05-17 | Stokes | North Carolina | 37169 | 4105 | 80 |
1304976 | 1304976 | 2021-05-10 | Monroe | Mississippi | 28095 | 4105 | 133 |
1291710 | 1291710 | 2021-05-06 | Webster | Louisiana | 22119 | 4105 | 112 |
1284057 | 1284057 | 2021-05-04 | Covington | Alabama | 1039 | 4105 | 117 |
1284689 | 1284689 | 2021-05-04 | Lee | Illinois | 17103 | 4105 | 91 |
1280810 | 1280810 | 2021-05-03 | Covington | Alabama | 1039 | 4105 | 117 |
1277563 | 1277563 | 2021-05-02 | Covington | Alabama | 1039 | 4105 | 117 |
1277784 | 1277784 | 2021-05-02 | Tuolumne | California | 6109 | 4105 | 65 |
1278918 | 1278918 | 2021-05-02 | Morrison | Minnesota | 27097 | 4105 | 60 |
1274316 | 1274316 | 2021-05-01 | Covington | Alabama | 1039 | 4105 | 117 |
1274537 | 1274537 | 2021-05-01 | Tuolumne | California | 6109 | 4105 | 65 |
1271069 | 1271069 | 2021-04-30 | Covington | Alabama | 1039 | 4105 | 116 |
1271290 | 1271290 | 2021-04-30 | Tuolumne | California | 6109 | 4105 | 65 |
1244360 | 1244360 | 2021-04-21 | Campbell | Tennessee | 47013 | 4105 | 62 |
1237418 | 1237418 | 2021-04-19 | Fulton | Ohio | 39051 | 4105 | 67 |
1226631 | 1226631 | 2021-04-16 | Graves | Kentucky | 21083 | 4105 | 90 |
1225566 | 1225566 | 2021-04-15 | Albany | Wyoming | 56001 | 4105 | 11 |
1175494 | 1175494 | 2021-03-31 | Madison | New York | 36053 | 4105 | 85 |
1155489 | 1155489 | 2021-03-25 | Goodhue | Minnesota | 27049 | 4105 | 69 |
1125650 | 1125650 | 2021-03-16 | Harrison | Indiana | 18061 | 4105 | 69 |
1109351 | 1109351 | 2021-03-11 | Monroe | Illinois | 17133 | 4105 | 89 |
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);