ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
141 rows where cases = 3804 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 14
- Nebraska 11
- Arkansas 10
- Illinois 10
- Oklahoma 10
- Georgia 8
- Louisiana 7
- North Carolina 7
- Wisconsin 7
- Kansas 5
- Virginia 5
- New York 4
- Alabama 3
- Kentucky 3
- Ohio 3
- Tennessee 3
- California 2
- Florida 2
- Idaho 2
- Indiana 2
- Michigan 2
- Minnesota 2
- Missouri 2
- Montana 2
- Pennsylvania 2
- Puerto Rico 2
- South Carolina 2
- Colorado 1
- Massachusetts 1
- Mississippi 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2465492 | 2465492 | 2022-05-02 | Saline | Nebraska | 31151 | 3804 | 12 |
2466419 | 2466419 | 2022-05-02 | Colorado | Texas | 48089 | 3804 | 64 |
2462237 | 2462237 | 2022-05-01 | Saline | Nebraska | 31151 | 3804 | 12 |
2463164 | 2463164 | 2022-05-01 | Colorado | Texas | 48089 | 3804 | 64 |
2458981 | 2458981 | 2022-04-30 | Saline | Nebraska | 31151 | 3804 | 12 |
2459908 | 2459908 | 2022-04-30 | Colorado | Texas | 48089 | 3804 | 63 |
2455725 | 2455725 | 2022-04-29 | Saline | Nebraska | 31151 | 3804 | 12 |
2456652 | 2456652 | 2022-04-29 | Colorado | Texas | 48089 | 3804 | 63 |
2452469 | 2452469 | 2022-04-28 | Saline | Nebraska | 31151 | 3804 | 12 |
2453396 | 2453396 | 2022-04-28 | Colorado | Texas | 48089 | 3804 | 63 |
2449213 | 2449213 | 2022-04-27 | Saline | Nebraska | 31151 | 3804 | 12 |
2445956 | 2445956 | 2022-04-26 | Saline | Nebraska | 31151 | 3804 | 12 |
2442701 | 2442701 | 2022-04-25 | Saline | Nebraska | 31151 | 3804 | 12 |
2439445 | 2439445 | 2022-04-24 | Saline | Nebraska | 31151 | 3804 | 12 |
2436189 | 2436189 | 2022-04-23 | Saline | Nebraska | 31151 | 3804 | 12 |
2432933 | 2432933 | 2022-04-22 | Saline | Nebraska | 31151 | 3804 | 12 |
2362772 | 2362772 | 2022-03-31 | Marquette | Wisconsin | 55077 | 3804 | 60 |
2349950 | 2349950 | 2022-03-28 | Franklin | Arkansas | 5047 | 3804 | 72 |
2346697 | 2346697 | 2022-03-27 | Franklin | Arkansas | 5047 | 3804 | 72 |
2343444 | 2343444 | 2022-03-26 | Franklin | Arkansas | 5047 | 3804 | 72 |
2340191 | 2340191 | 2022-03-25 | Franklin | Arkansas | 5047 | 3804 | 72 |
2336938 | 2336938 | 2022-03-24 | Franklin | Arkansas | 5047 | 3804 | 72 |
2305840 | 2305840 | 2022-03-14 | Moniteau | Missouri | 29135 | 3804 | 55 |
2266878 | 2266878 | 2022-03-02 | Glacier | Montana | 30035 | 3804 | 68 |
2260376 | 2260376 | 2022-02-28 | Glacier | Montana | 30035 | 3804 | 68 |
2217872 | 2217872 | 2022-02-15 | Redwood | Minnesota | 27127 | 3804 | 52 |
2203615 | 2203615 | 2022-02-11 | Izard | Arkansas | 5065 | 3804 | 63 |
2194372 | 2194372 | 2022-02-08 | Mason | Illinois | 17125 | 3804 | 60 |
2196451 | 2196451 | 2022-02-08 | Houston | Texas | 48225 | 3804 | 98 |
2188101 | 2188101 | 2022-02-06 | Allen | Kansas | 20001 | 3804 | 43 |
2184848 | 2184848 | 2022-02-05 | Allen | Kansas | 20001 | 3804 | 43 |
2181596 | 2181596 | 2022-02-04 | Allen | Kansas | 20001 | 3804 | 43 |
2130758 | 2130758 | 2022-01-19 | Meigs | Ohio | 39105 | 3804 | 73 |
2112510 | 2112510 | 2022-01-14 | Cross | Arkansas | 5037 | 3804 | 73 |
2111572 | 2111572 | 2022-01-13 | Hampton | South Carolina | 45049 | 3804 | 75 |
2103942 | 2103942 | 2022-01-11 | Roscommon | Michigan | 26143 | 3804 | 106 |
2100691 | 2100691 | 2022-01-10 | Roscommon | Michigan | 26143 | 3804 | 106 |
2098469 | 2098469 | 2022-01-09 | Cabo Rojo | Puerto Rico | 72023 | 3804 | |
2085163 | 2085163 | 2022-01-05 | Rolette | North Dakota | 38079 | 3804 | 36 |
2082303 | 2082303 | 2022-01-04 | Fairfield | South Carolina | 45039 | 3804 | 95 |
2049254 | 2049254 | 2021-12-25 | Seneca | New York | 36099 | 3804 | 76 |
2046004 | 2046004 | 2021-12-24 | Seneca | New York | 36099 | 3804 | 76 |
2034515 | 2034515 | 2021-12-21 | Logan | Arkansas | 5083 | 3804 | 53 |
2036613 | 2036613 | 2021-12-21 | Lincoln | Oregon | 41041 | 3804 | 58 |
2015588 | 2015588 | 2021-12-15 | Fulton | Indiana | 18049 | 3804 | 78 |
2011575 | 2011575 | 2021-12-13 | Vernon | Wisconsin | 55123 | 3804 | 71 |
1995761 | 1995761 | 2021-12-09 | Burke | Georgia | 13033 | 3804 | 86 |
1972144 | 1972144 | 2021-12-01 | Milam | Texas | 48331 | 3804 | 90 |
1968894 | 1968894 | 2021-11-30 | Milam | Texas | 48331 | 3804 | 90 |
1960287 | 1960287 | 2021-11-28 | Shelby | Illinois | 17173 | 3804 | 54 |
1957036 | 1957036 | 2021-11-27 | Shelby | Illinois | 17173 | 3804 | 54 |
1953785 | 1953785 | 2021-11-26 | Shelby | Illinois | 17173 | 3804 | 54 |
1950534 | 1950534 | 2021-11-25 | Shelby | Illinois | 17173 | 3804 | 54 |
1947283 | 1947283 | 2021-11-24 | Shelby | Illinois | 17173 | 3804 | 54 |
1940289 | 1940289 | 2021-11-22 | Del Norte | California | 6015 | 3804 | 42 |
1941328 | 1941328 | 2021-11-22 | Franklin | Massachusetts | 25011 | 3804 | 123 |
1927382 | 1927382 | 2021-11-18 | Morgan | Colorado | 8087 | 3804 | 104 |
1917279 | 1917279 | 2021-11-14 | Kewaunee | Wisconsin | 55061 | 3804 | 46 |
1914029 | 1914029 | 2021-11-13 | Kewaunee | Wisconsin | 55061 | 3804 | 46 |
1910779 | 1910779 | 2021-11-12 | Kewaunee | Wisconsin | 55061 | 3804 | 46 |
1902177 | 1902177 | 2021-11-10 | McCreary | Kentucky | 21147 | 3804 | 59 |
1889966 | 1889966 | 2021-11-06 | Lewis | New York | 36049 | 3804 | 39 |
1858198 | 1858198 | 2021-10-27 | Morgan | Tennessee | 47129 | 3804 | 49 |
1852878 | 1852878 | 2021-10-26 | Tattnall | Georgia | 13267 | 3804 | 106 |
1849629 | 1849629 | 2021-10-25 | Tattnall | Georgia | 13267 | 3804 | 106 |
1830753 | 1830753 | 2021-10-19 | Grant | Louisiana | 22043 | 3804 | 77 |
1827728 | 1827728 | 2021-10-18 | Le Sueur | Minnesota | 27079 | 3804 | 31 |
1819761 | 1819761 | 2021-10-15 | Upshur | West Virginia | 54097 | 3804 | 58 |
1786876 | 1786876 | 2021-10-05 | Karnes | Texas | 48255 | 3804 | 52 |
1783627 | 1783627 | 2021-10-04 | Karnes | Texas | 48255 | 3804 | 52 |
1708055 | 1708055 | 2021-09-11 | Wyoming | New York | 36121 | 3804 | 54 |
1630591 | 1630591 | 2021-08-18 | Vega Baja | Puerto Rico | 72145 | 3804 | |
1612114 | 1612114 | 2021-08-13 | Poinsett | Arkansas | 5111 | 3804 | 87 |
1610676 | 1610676 | 2021-08-12 | Person | North Carolina | 37145 | 3804 | 76 |
1595728 | 1595728 | 2021-08-08 | Dallas | Alabama | 1047 | 3804 | 164 |
1592479 | 1592479 | 2021-08-07 | Dallas | Alabama | 1047 | 3804 | 164 |
1580379 | 1580379 | 2021-08-03 | Ellis | Kansas | 20051 | 3804 | 73 |
1582485 | 1582485 | 2021-08-03 | Prince George | Virginia | 51149 | 3804 | 33 |
1577130 | 1577130 | 2021-08-02 | Ellis | Kansas | 20051 | 3804 | 73 |
1508682 | 1508682 | 2021-07-12 | Montgomery | Illinois | 17135 | 3804 | 80 |
1505173 | 1505173 | 2021-07-11 | Bryan | Georgia | 13029 | 3804 | 41 |
1501927 | 1501927 | 2021-07-10 | Bryan | Georgia | 13029 | 3804 | 41 |
1498681 | 1498681 | 2021-07-09 | Bryan | Georgia | 13029 | 3804 | 41 |
1495218 | 1495218 | 2021-07-08 | Amador | California | 6005 | 3804 | 47 |
1491779 | 1491779 | 2021-07-06 | Teton | Wyoming | 56039 | 3804 | 11 |
1475360 | 1475360 | 2021-07-01 | York | Virginia | 51199 | 3804 | 59 |
1412941 | 1412941 | 2021-06-12 | McKean | Pennsylvania | 42083 | 3804 | 72 |
1395578 | 1395578 | 2021-06-07 | St. John the Baptist | Louisiana | 22095 | 3804 | 141 |
1377142 | 1377142 | 2021-06-01 | Okmulgee | Oklahoma | 40111 | 3804 | 81 |
1373896 | 1373896 | 2021-05-31 | Okmulgee | Oklahoma | 40111 | 3804 | 81 |
1370651 | 1370651 | 2021-05-30 | Okmulgee | Oklahoma | 40111 | 3804 | 81 |
1367405 | 1367405 | 2021-05-29 | Okmulgee | Oklahoma | 40111 | 3804 | 81 |
1364159 | 1364159 | 2021-05-28 | Okmulgee | Oklahoma | 40111 | 3804 | 81 |
1360913 | 1360913 | 2021-05-27 | Okmulgee | Oklahoma | 40111 | 3804 | 81 |
1357667 | 1357667 | 2021-05-26 | Okmulgee | Oklahoma | 40111 | 3804 | 81 |
1332682 | 1332682 | 2021-05-18 | Oneida | Wisconsin | 55085 | 3804 | 77 |
1328226 | 1328226 | 2021-05-17 | Scotland | North Carolina | 37165 | 3804 | 85 |
1274411 | 1274411 | 2021-05-01 | Boone | Arkansas | 5009 | 3804 | 80 |
1199974 | 1199974 | 2021-04-08 | Okeechobee | Florida | 12093 | 3804 | 86 |
1188614 | 1188614 | 2021-04-04 | Yadkin | North Carolina | 37197 | 3804 | 47 |
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);