ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
78 rows where cases = 6272 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 26
- Tennessee 16
- Georgia 10
- Texas 8
- Missouri 7
- Louisiana 6
- Illinois 4
- Ohio 3
- Kansas 2
- Kentucky 2
- Minnesota 2
- Mississippi 2
- Washington 2
- Alabama 1
- Arizona 1
- District of Columbia 1
- Florida 1
- Montana 1
- Nevada 1
- New Hampshire 1
- New Mexico 1
- New York 1
- North Carolina 1
- South Carolina 1
- Utah 1
- Vermont 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2497911 | 2497911 | 2022-05-12 | Saline | Missouri | 29195 | 6272 | 107 |
2494653 | 2494653 | 2022-05-11 | Saline | Missouri | 29195 | 6272 | 107 |
2491395 | 2491395 | 2022-05-10 | Saline | Missouri | 29195 | 6272 | 107 |
2488137 | 2488137 | 2022-05-09 | Saline | Missouri | 29195 | 6272 | 107 |
2484880 | 2484880 | 2022-05-08 | Saline | Missouri | 29195 | 6272 | 107 |
2481622 | 2481622 | 2022-05-07 | Saline | Missouri | 29195 | 6272 | 107 |
2478364 | 2478364 | 2022-05-06 | Saline | Missouri | 29195 | 6272 | 107 |
2461131 | 2461131 | 2022-05-01 | Jersey | Illinois | 17083 | 6272 | 91 |
2457875 | 2457875 | 2022-04-30 | Jersey | Illinois | 17083 | 6272 | 91 |
2454619 | 2454619 | 2022-04-29 | Jersey | Illinois | 17083 | 6272 | 91 |
2332848 | 2332848 | 2022-03-22 | DeKalb | Tennessee | 47041 | 6272 | 99 |
2329595 | 2329595 | 2022-03-21 | DeKalb | Tennessee | 47041 | 6272 | 99 |
2326343 | 2326343 | 2022-03-20 | DeKalb | Tennessee | 47041 | 6272 | 99 |
2323090 | 2323090 | 2022-03-19 | DeKalb | Tennessee | 47041 | 6272 | 99 |
2319836 | 2319836 | 2022-03-18 | DeKalb | Tennessee | 47041 | 6272 | 99 |
2316582 | 2316582 | 2022-03-17 | DeKalb | Tennessee | 47041 | 6272 | 99 |
2313329 | 2313329 | 2022-03-16 | DeKalb | Tennessee | 47041 | 6272 | 99 |
2188363 | 2188363 | 2022-02-06 | Plaquemines | Louisiana | 22075 | 6272 | 42 |
2185110 | 2185110 | 2022-02-05 | Plaquemines | Louisiana | 22075 | 6272 | 42 |
2181858 | 2181858 | 2022-02-04 | Plaquemines | Louisiana | 22075 | 6272 | 42 |
2176881 | 2176881 | 2022-02-02 | DeWitt | Texas | 48123 | 6272 | 87 |
2163902 | 2163902 | 2022-01-29 | Hale | Texas | 48189 | 6272 | 220 |
2126411 | 2126411 | 2022-01-18 | Carter | Kentucky | 21043 | 6272 | 87 |
2127850 | 2127850 | 2022-01-18 | Union | South Carolina | 45087 | 6272 | 120 |
2100833 | 2100833 | 2022-01-10 | Leflore | Mississippi | 28083 | 6272 | 144 |
2060858 | 2060858 | 2021-12-29 | Oconee | Georgia | 13219 | 6272 | 82 |
2032500 | 2032500 | 2021-12-20 | Polk | Minnesota | 27119 | 6272 | 90 |
2008027 | 2008027 | 2021-12-12 | Rutland | Vermont | 50021 | 6272 | 37 |
1981233 | 1981233 | 2021-12-04 | Putnam | Ohio | 39137 | 6272 | 122 |
1945421 | 1945421 | 2021-11-23 | Clinton | Ohio | 39027 | 6272 | 106 |
1900752 | 1900752 | 2021-11-09 | Wasatch | Utah | 49051 | 6272 | 28 |
1883383 | 1883383 | 2021-11-04 | Grafton | New Hampshire | 33009 | 6272 | 33 |
1869006 | 1869006 | 2021-10-31 | Bryan | Georgia | 13029 | 6272 | 67 |
1865757 | 1865757 | 2021-10-30 | Bryan | Georgia | 13029 | 6272 | 67 |
1862508 | 1862508 | 2021-10-29 | Bryan | Georgia | 13029 | 6272 | 67 |
1847037 | 1847037 | 2021-10-24 | Vernon | Louisiana | 22115 | 6272 | 160 |
1843787 | 1843787 | 2021-10-23 | Vernon | Louisiana | 22115 | 6272 | 160 |
1840537 | 1840537 | 2021-10-22 | Vernon | Louisiana | 22115 | 6272 | 160 |
1823517 | 1823517 | 2021-10-17 | Bryan | Georgia | 13029 | 6272 | 63 |
1820268 | 1820268 | 2021-10-16 | Bryan | Georgia | 13029 | 6272 | 63 |
1817019 | 1817019 | 2021-10-15 | Bryan | Georgia | 13029 | 6272 | 63 |
1792396 | 1792396 | 2021-10-07 | Lyon | Nevada | 32019 | 6272 | 101 |
1786881 | 1786881 | 2021-10-05 | Kerr | Texas | 48265 | 6272 | 119 |
1783632 | 1783632 | 2021-10-04 | Kerr | Texas | 48265 | 6272 | 119 |
1780383 | 1780383 | 2021-10-03 | Kerr | Texas | 48265 | 6272 | 119 |
1777133 | 1777133 | 2021-10-02 | Kerr | Texas | 48265 | 6272 | 119 |
1773883 | 1773883 | 2021-10-01 | Kerr | Texas | 48265 | 6272 | 117 |
1757475 | 1757475 | 2021-09-26 | Obion | Tennessee | 47131 | 6272 | 105 |
1754227 | 1754227 | 2021-09-25 | Obion | Tennessee | 47131 | 6272 | 105 |
1750979 | 1750979 | 2021-09-24 | Obion | Tennessee | 47131 | 6272 | 105 |
1715183 | 1715183 | 2021-09-13 | Cheatham | Tennessee | 47021 | 6272 | 59 |
1584776 | 1584776 | 2021-08-04 | Belmont | Ohio | 39013 | 6272 | 179 |
1541157 | 1541157 | 2021-07-22 | Ogle | Illinois | 17141 | 6272 | 92 |
1491274 | 1491274 | 2021-07-06 | Hunt | Texas | 48231 | 6272 | 179 |
1384494 | 1384494 | 2021-06-03 | Cowlitz | Washington | 53015 | 6272 | 93 |
1348296 | 1348296 | 2021-05-23 | Jefferson | Tennessee | 47089 | 6272 | 125 |
1345048 | 1345048 | 2021-05-22 | Jefferson | Tennessee | 47089 | 6272 | 125 |
1341800 | 1341800 | 2021-05-21 | Jefferson | Tennessee | 47089 | 6272 | 125 |
1330467 | 1330467 | 2021-05-18 | Saline | Kansas | 20169 | 6272 | 139 |
1327220 | 1327220 | 2021-05-17 | Saline | Kansas | 20169 | 6272 | 140 |
1311942 | 1311942 | 2021-05-12 | Duplin | North Carolina | 37061 | 6272 | 133 |
1294291 | 1294291 | 2021-05-07 | Spalding | Georgia | 13255 | 6272 | 189 |
1289882 | 1289882 | 2021-05-05 | Roane | Tennessee | 47145 | 6272 | 105 |
1262408 | 1262408 | 2021-04-27 | Pulaski | Kentucky | 21199 | 6272 | 101 |
1232461 | 1232461 | 2021-04-18 | Putnam | Florida | 12107 | 6272 | 138 |
1230730 | 1230730 | 2021-04-17 | Steuben | New York | 36101 | 6272 | 141 |
1217304 | 1217304 | 2021-04-13 | Lowndes | Mississippi | 28087 | 6272 | 144 |
1102007 | 1102007 | 2021-03-08 | Chelan | Washington | 53007 | 6272 | 63 |
1037788 | 1037788 | 2021-02-17 | Rockdale | Georgia | 13247 | 6272 | 135 |
926883 | 926883 | 2021-01-13 | Portage | Wisconsin | 55097 | 6272 | 57 |
917589 | 917589 | 2021-01-11 | Barrow | Georgia | 13013 | 6272 | 75 |
873402 | 873402 | 2020-12-28 | Missoula | Montana | 30063 | 6272 | 51 |
837876 | 837876 | 2020-12-17 | Chaves | New Mexico | 35005 | 6272 | 75 |
816679 | 816679 | 2020-12-11 | Apache | Arizona | 4001 | 6272 | 209 |
795263 | 795263 | 2020-12-04 | Sherburne | Minnesota | 27141 | 6272 | 47 |
783504 | 783504 | 2020-11-30 | Washington | Tennessee | 47179 | 6272 | 108 |
774446 | 774446 | 2020-11-28 | Marshall | Alabama | 1095 | 6272 | 55 |
130543 | 130543 | 2020-05-10 | District of Columbia | District of Columbia | 11001 | 6272 | 323 |
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);