ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where cases = 6331 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 20
- Texas 11
- Michigan 10
- Virginia 7
- Georgia 5
- Tennessee 4
- Kansas 3
- Mississippi 3
- New York 3
- North Carolina 3
- West Virginia 3
- Alabama 2
- Kentucky 2
- Ohio 2
- South Carolina 2
- Wisconsin 2
- California 1
- Idaho 1
- Louisiana 1
- Maine 1
- Puerto Rico 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2474715 | 2474715 | 2022-05-05 | Waldo | Maine | 23027 | 6331 | 57 |
2449853 | 2449853 | 2022-04-27 | Moca | Puerto Rico | 72099 | 6331 | |
2419326 | 2419326 | 2022-04-18 | Sabine | Louisiana | 22085 | 6331 | 110 |
2399935 | 2399935 | 2022-04-12 | Oceana | Michigan | 26127 | 6331 | 89 |
2396679 | 2396679 | 2022-04-11 | Oceana | Michigan | 26127 | 6331 | 89 |
2393424 | 2393424 | 2022-04-10 | Oceana | Michigan | 26127 | 6331 | 89 |
2390168 | 2390168 | 2022-04-09 | Oceana | Michigan | 26127 | 6331 | 89 |
2386912 | 2386912 | 2022-04-08 | Oceana | Michigan | 26127 | 6331 | 89 |
2383657 | 2383657 | 2022-04-07 | Oceana | Michigan | 26127 | 6331 | 89 |
2380402 | 2380402 | 2022-04-06 | Oceana | Michigan | 26127 | 6331 | 89 |
2216485 | 2216485 | 2022-02-15 | Bibb | Alabama | 1007 | 6331 | 98 |
2180381 | 2180381 | 2022-02-03 | Amherst | Virginia | 51009 | 6331 | 71 |
2174781 | 2174781 | 2022-02-02 | Latah | Idaho | 16057 | 6331 | 46 |
2167386 | 2167386 | 2022-01-30 | Caroline | Virginia | 51033 | 6331 | 61 |
2167572 | 2167572 | 2022-01-30 | Nicholas | West Virginia | 54067 | 6331 | 80 |
2164131 | 2164131 | 2022-01-29 | Caroline | Virginia | 51033 | 6331 | 61 |
2160876 | 2160876 | 2022-01-28 | Caroline | Virginia | 51033 | 6331 | 61 |
2129665 | 2129665 | 2022-01-19 | Carter | Kentucky | 21043 | 6331 | 87 |
2108733 | 2108733 | 2022-01-12 | Upshur | Texas | 48459 | 6331 | 161 |
2075489 | 2075489 | 2022-01-02 | Perry | Ohio | 39127 | 6331 | 92 |
2031012 | 2031012 | 2021-12-19 | Wayne | West Virginia | 54099 | 6331 | 92 |
2004722 | 2004722 | 2021-12-11 | Wharton | Texas | 48481 | 6331 | 190 |
1946625 | 1946625 | 2021-11-24 | Franklin | Alabama | 1059 | 6331 | 108 |
1921692 | 1921692 | 2021-11-16 | Perry | Kentucky | 21193 | 6331 | 111 |
1906216 | 1906216 | 2021-11-11 | Livingston | New York | 36051 | 6331 | 72 |
1907305 | 1907305 | 2021-11-11 | Danville city | Virginia | 51590 | 6331 | 195 |
1853777 | 1853777 | 2021-10-26 | Bolivar | Mississippi | 28011 | 6331 | 150 |
1837972 | 1837972 | 2021-10-21 | Fulton | New York | 36035 | 6331 | 104 |
1829318 | 1829318 | 2021-10-18 | Culpeper | Virginia | 51047 | 6331 | 81 |
1809729 | 1809729 | 2021-10-12 | Waller | Texas | 48473 | 6331 | 74 |
1738049 | 1738049 | 2021-09-20 | Cherokee | Texas | 48073 | 6331 | 172 |
1734799 | 1734799 | 2021-09-19 | Cherokee | Texas | 48073 | 6331 | 172 |
1731549 | 1731549 | 2021-09-18 | Cherokee | Texas | 48073 | 6331 | 172 |
1718321 | 1718321 | 2021-09-14 | Chesterfield | South Carolina | 45025 | 6331 | 121 |
1628384 | 1628384 | 2021-08-18 | Humboldt | California | 6023 | 6331 | 59 |
1559930 | 1559930 | 2021-07-27 | Sauk | Wisconsin | 55111 | 6331 | 58 |
1556683 | 1556683 | 2021-07-26 | Sauk | Wisconsin | 55111 | 6331 | 57 |
1474874 | 1474874 | 2021-07-01 | Jefferson | Tennessee | 47089 | 6331 | 126 |
1467262 | 1467262 | 2021-06-29 | Lafayette | Mississippi | 28071 | 6331 | 122 |
1460303 | 1460303 | 2021-06-27 | Saline | Kansas | 20169 | 6331 | 144 |
1457058 | 1457058 | 2021-06-26 | Saline | Kansas | 20169 | 6331 | 144 |
1453813 | 1453813 | 2021-06-25 | Saline | Kansas | 20169 | 6331 | 144 |
1424900 | 1424900 | 2021-06-16 | Isabella | Michigan | 26073 | 6331 | 99 |
1406081 | 1406081 | 2021-06-10 | Duplin | North Carolina | 37061 | 6331 | 139 |
1402835 | 1402835 | 2021-06-09 | Duplin | North Carolina | 37061 | 6331 | 139 |
1399506 | 1399506 | 2021-06-08 | Cayuga | New York | 36011 | 6331 | 92 |
1335333 | 1335333 | 2021-05-19 | Roane | Tennessee | 47145 | 6331 | 105 |
1332086 | 1332086 | 2021-05-18 | Roane | Tennessee | 47145 | 6331 | 105 |
1255227 | 1255227 | 2021-04-25 | Catoosa | Georgia | 13047 | 6331 | 68 |
1251458 | 1251458 | 2021-04-23 | Raleigh | West Virginia | 54081 | 6331 | 79 |
1233356 | 1233356 | 2021-04-18 | Gratiot | Michigan | 26057 | 6331 | 111 |
1230108 | 1230108 | 2021-04-17 | Gratiot | Michigan | 26057 | 6331 | 111 |
1224927 | 1224927 | 2021-04-15 | McMinn | Tennessee | 47107 | 6331 | 95 |
1044278 | 1044278 | 2021-02-19 | Rockdale | Georgia | 13247 | 6331 | 139 |
976060 | 976060 | 2021-01-29 | Gordon | Georgia | 13129 | 6331 | 82 |
974442 | 974442 | 2021-01-28 | Erie | Ohio | 39043 | 6331 | 131 |
946009 | 946009 | 2021-01-19 | Val Verde | Texas | 48465 | 6331 | 158 |
942762 | 942762 | 2021-01-18 | Val Verde | Texas | 48465 | 6331 | 157 |
939517 | 939517 | 2021-01-17 | Val Verde | Texas | 48465 | 6331 | 157 |
936272 | 936272 | 2021-01-16 | Val Verde | Texas | 48465 | 6331 | 157 |
926125 | 926125 | 2021-01-13 | Lancaster | South Carolina | 45057 | 6331 | 97 |
757955 | 757955 | 2020-11-22 | Richmond city | Virginia | 51760 | 6331 | 80 |
727152 | 727152 | 2020-11-13 | Harrison | Mississippi | 28047 | 6331 | 100 |
688771 | 688771 | 2020-11-01 | Pitt | North Carolina | 37147 | 6331 | 41 |
635349 | 635349 | 2020-10-16 | Henry | Georgia | 13151 | 6331 | 109 |
512283 | 512283 | 2020-09-08 | Richmond | Georgia | 13245 | 6331 | 139 |
378944 | 378944 | 2020-07-28 | Denton | Texas | 48121 | 6331 | 71 |
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);