ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
49 rows where cases = 12327 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 21
- Ohio 7
- Washington 7
- Illinois 6
- Wisconsin 5
- Texas 4
- Indiana 3
- North Carolina 2
- Oklahoma 2
- Alabama 1
- Arizona 1
- Colorado 1
- Kentucky 1
- Minnesota 1
- Missouri 1
- Nevada 1
- Pennsylvania 1
- Puerto Rico 1
- South Carolina 1
- Vermont 1
- West Virginia 1
- Wyoming 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501768 | 2501768 | 2022-05-13 | Kay | Oklahoma | 40071 | 12327 | 216 |
2498510 | 2498510 | 2022-05-12 | Kay | Oklahoma | 40071 | 12327 | 216 |
2350570 | 2350570 | 2022-03-28 | Marshall | Indiana | 18099 | 12327 | 195 |
2348905 | 2348905 | 2022-03-27 | Arecibo | Puerto Rico | 72013 | 12327 | |
2335700 | 2335700 | 2022-03-23 | Washington | Ohio | 39167 | 12327 | 203 |
2332446 | 2332446 | 2022-03-22 | Washington | Ohio | 39167 | 12327 | 203 |
2333219 | 2333219 | 2022-03-22 | Rutland | Vermont | 50021 | 12327 | 71 |
2329193 | 2329193 | 2022-03-21 | Washington | Ohio | 39167 | 12327 | 203 |
2325941 | 2325941 | 2022-03-20 | Washington | Ohio | 39167 | 12327 | 203 |
2322688 | 2322688 | 2022-03-19 | Washington | Ohio | 39167 | 12327 | 203 |
2319434 | 2319434 | 2022-03-18 | Washington | Ohio | 39167 | 12327 | 203 |
2316180 | 2316180 | 2022-03-17 | Washington | Ohio | 39167 | 12327 | 203 |
2267015 | 2267015 | 2022-03-02 | Elko | Nevada | 32007 | 12327 | 135 |
2247153 | 2247153 | 2022-02-24 | Winona | Minnesota | 27169 | 12327 | 71 |
2178555 | 2178555 | 2022-02-03 | Shelby | Kentucky | 21211 | 12327 | 138 |
2157844 | 2157844 | 2022-01-27 | Dunn | Wisconsin | 55033 | 12327 | 63 |
2141531 | 2141531 | 2022-01-22 | Marion | West Virginia | 54049 | 12327 | 145 |
2053816 | 2053816 | 2021-12-26 | Portage | Wisconsin | 55097 | 12327 | 125 |
2050566 | 2050566 | 2021-12-25 | Portage | Wisconsin | 55097 | 12327 | 125 |
2047316 | 2047316 | 2021-12-24 | Portage | Wisconsin | 55097 | 12327 | 125 |
2033560 | 2033560 | 2021-12-20 | Laurens | South Carolina | 45059 | 12327 | 243 |
1969167 | 1969167 | 2021-11-30 | Chelan | Washington | 53007 | 12327 | 120 |
1965917 | 1965917 | 2021-11-29 | Chelan | Washington | 53007 | 12327 | 120 |
1962665 | 1962665 | 2021-11-28 | Chelan | Washington | 53007 | 12327 | 117 |
1959414 | 1959414 | 2021-11-27 | Chelan | Washington | 53007 | 12327 | 117 |
1956163 | 1956163 | 2021-11-26 | Chelan | Washington | 53007 | 12327 | 117 |
1952912 | 1952912 | 2021-11-25 | Chelan | Washington | 53007 | 12327 | 117 |
1949661 | 1949661 | 2021-11-24 | Chelan | Washington | 53007 | 12327 | 117 |
1806832 | 1806832 | 2021-10-11 | St. Croix | Wisconsin | 55109 | 12327 | 83 |
1718675 | 1718675 | 2021-09-14 | Maverick | Texas | 48323 | 12327 | 378 |
1710001 | 1710001 | 2021-09-12 | Adams | Illinois | 17001 | 12327 | 172 |
1706754 | 1706754 | 2021-09-11 | Adams | Illinois | 17001 | 12327 | 172 |
1703506 | 1703506 | 2021-09-10 | Adams | Illinois | 17001 | 12327 | 172 |
1689947 | 1689947 | 2021-09-06 | Lauderdale | Alabama | 1077 | 12327 | 259 |
1626483 | 1626483 | 2021-08-17 | Jasper | Missouri | 29097 | 12327 | 154 |
1624927 | 1624927 | 2021-08-16 | Laramie | Wyoming | 56021 | 12327 | 137 |
1553572 | 1553572 | 2021-07-26 | Cochise | Arizona | 4003 | 12327 | 295 |
1492539 | 1492539 | 2021-07-07 | Monroe | Indiana | 18105 | 12327 | 181 |
1287932 | 1287932 | 2021-05-05 | LaSalle | Illinois | 17099 | 12327 | 294 |
1265342 | 1265342 | 2021-04-28 | Vigo | Indiana | 18167 | 12327 | 249 |
973042 | 973042 | 2021-01-28 | Rock Island | Illinois | 17161 | 12327 | 311 |
964898 | 964898 | 2021-01-25 | Butler | Pennsylvania | 42019 | 12327 | 311 |
965377 | 965377 | 2021-01-25 | Kaufman | Texas | 48257 | 12327 | 171 |
962132 | 962132 | 2021-01-24 | Kaufman | Texas | 48257 | 12327 | 171 |
958887 | 958887 | 2021-01-23 | Kaufman | Texas | 48257 | 12327 | 170 |
951627 | 951627 | 2021-01-21 | Robeson | North Carolina | 37155 | 12327 | 165 |
902943 | 902943 | 2021-01-06 | Pitt | North Carolina | 37147 | 12327 | 69 |
820439 | 820439 | 2020-12-12 | Champaign | Illinois | 17019 | 12327 | 75 |
803854 | 803854 | 2020-12-07 | Boulder | Colorado | 8013 | 12327 | 140 |
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);