ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
69 rows where cases = 7707 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 25
- Texas 11
- Georgia 8
- Iowa 7
- Pennsylvania 5
- Virginia 5
- California 4
- North Carolina 4
- Louisiana 3
- Arkansas 2
- Illinois 2
- Mississippi 2
- New York 2
- South Carolina 2
- Florida 1
- Idaho 1
- Indiana 1
- Maine 1
- Minnesota 1
- Nebraska 1
- New Mexico 1
- Ohio 1
- Oregon 1
- South Dakota 1
- Tennessee 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2473703 | 2473703 | 2022-05-05 | Calaveras | California | 6009 | 7707 | 120 |
2470446 | 2470446 | 2022-05-04 | Calaveras | California | 6009 | 7707 | 120 |
2467190 | 2467190 | 2022-05-03 | Calaveras | California | 6009 | 7707 | 120 |
2404621 | 2404621 | 2022-04-13 | Hockley | Texas | 48219 | 7707 | 161 |
2326117 | 2326117 | 2022-03-20 | Susquehanna | Pennsylvania | 42115 | 7707 | 107 |
2322864 | 2322864 | 2022-03-19 | Susquehanna | Pennsylvania | 42115 | 7707 | 107 |
2216647 | 2216647 | 2022-02-15 | Poinsett | Arkansas | 5111 | 7707 | 111 |
2219294 | 2219294 | 2022-02-15 | Polk | Texas | 48373 | 7707 | 235 |
2196741 | 2196741 | 2022-02-08 | Prince George | Virginia | 51149 | 7707 | 59 |
2171822 | 2171822 | 2022-02-01 | Sioux | Iowa | 19167 | 7707 | 80 |
2168569 | 2168569 | 2022-01-31 | Sioux | Iowa | 19167 | 7707 | 80 |
2165314 | 2165314 | 2022-01-30 | Sioux | Iowa | 19167 | 7707 | 80 |
2162059 | 2162059 | 2022-01-29 | Sioux | Iowa | 19167 | 7707 | 80 |
2158804 | 2158804 | 2022-01-28 | Sioux | Iowa | 19167 | 7707 | 80 |
2155550 | 2155550 | 2022-01-27 | Sioux | Iowa | 19167 | 7707 | 80 |
2152297 | 2152297 | 2022-01-26 | Sioux | Iowa | 19167 | 7707 | 80 |
2153699 | 2153699 | 2022-01-26 | Clarion | Pennsylvania | 42031 | 7707 | 184 |
2146654 | 2146654 | 2022-01-24 | Platte | Nebraska | 31141 | 7707 | 69 |
2079083 | 2079083 | 2022-01-03 | Brown | South Dakota | 46013 | 7707 | 108 |
2038239 | 2038239 | 2021-12-22 | Effingham | Illinois | 17049 | 7707 | 124 |
2020192 | 2020192 | 2021-12-16 | Defiance | Ohio | 39039 | 7707 | 118 |
2012087 | 2012087 | 2021-12-14 | Liberty | Georgia | 13179 | 7707 | 132 |
1994976 | 1994976 | 2021-12-08 | Wilson | Texas | 48493 | 7707 | 142 |
1978148 | 1978148 | 2021-12-03 | Huntingdon | Pennsylvania | 42061 | 7707 | 181 |
1968556 | 1968556 | 2021-11-30 | Newberry | South Carolina | 45071 | 7707 | 148 |
1778049 | 1778049 | 2021-10-03 | Coffee | Georgia | 13069 | 7707 | 206 |
1774799 | 1774799 | 2021-10-02 | Coffee | Georgia | 13069 | 7707 | 206 |
1771549 | 1771549 | 2021-10-01 | Coffee | Georgia | 13069 | 7707 | 206 |
1763247 | 1763247 | 2021-09-28 | Jefferson | New York | 36045 | 7707 | 71 |
1760754 | 1760754 | 2021-09-27 | Anderson | Texas | 48001 | 7707 | 169 |
1757506 | 1757506 | 2021-09-26 | Anderson | Texas | 48001 | 7707 | 169 |
1754258 | 1754258 | 2021-09-25 | Anderson | Texas | 48001 | 7707 | 167 |
1720332 | 1720332 | 2021-09-15 | Kennebec | Maine | 23011 | 7707 | 87 |
1585154 | 1585154 | 2021-08-04 | Laurens | South Carolina | 45059 | 7707 | 172 |
1574946 | 1574946 | 2021-08-01 | Rutherford | North Carolina | 37161 | 7707 | 222 |
1571698 | 1571698 | 2021-07-31 | Rutherford | North Carolina | 37161 | 7707 | 222 |
1568450 | 1568450 | 2021-07-30 | Rutherford | North Carolina | 37161 | 7707 | 222 |
1554807 | 1554807 | 2021-07-26 | Blue Earth | Minnesota | 27013 | 7707 | 44 |
1528640 | 1528640 | 2021-07-18 | Iberia | Louisiana | 22045 | 7707 | 166 |
1525393 | 1525393 | 2021-07-17 | Iberia | Louisiana | 22045 | 7707 | 166 |
1522145 | 1522145 | 2021-07-16 | Iberia | Louisiana | 22045 | 7707 | 166 |
1443011 | 1443011 | 2021-06-21 | Chippewa | Wisconsin | 55017 | 7707 | 96 |
1417566 | 1417566 | 2021-06-14 | Dougherty | Georgia | 13095 | 7707 | 309 |
1414320 | 1414320 | 2021-06-13 | Dougherty | Georgia | 13095 | 7707 | 309 |
1411075 | 1411075 | 2021-06-12 | Dougherty | Georgia | 13095 | 7707 | 309 |
1370299 | 1370299 | 2021-05-30 | Chemung | New York | 36015 | 7707 | 135 |
1330918 | 1330918 | 2021-05-18 | Forrest | Mississippi | 28035 | 7707 | 152 |
1317013 | 1317013 | 2021-05-14 | Rockdale | Georgia | 13247 | 7707 | 171 |
1303267 | 1303267 | 2021-05-09 | Lynchburg city | Virginia | 51680 | 7707 | 147 |
1258450 | 1258450 | 2021-04-26 | Walton | Florida | 12131 | 7707 | 87 |
1251291 | 1251291 | 2021-04-23 | Frederick | Virginia | 51069 | 7707 | 97 |
1241624 | 1241624 | 2021-04-20 | Suffolk city | Virginia | 51800 | 7707 | 182 |
1164586 | 1164586 | 2021-03-28 | Bartholomew | Indiana | 18005 | 7707 | 156 |
1160417 | 1160417 | 2021-03-26 | Roanoke | Virginia | 51161 | 7707 | 125 |
1128346 | 1128346 | 2021-03-17 | White | Arkansas | 5145 | 7707 | 115 |
1108241 | 1108241 | 2021-03-10 | Orange | Texas | 48361 | 7707 | 119 |
1104995 | 1104995 | 2021-03-09 | Orange | Texas | 48361 | 7707 | 119 |
1101749 | 1101749 | 2021-03-08 | Orange | Texas | 48361 | 7707 | 119 |
1098503 | 1098503 | 2021-03-07 | Orange | Texas | 48361 | 7707 | 119 |
1095255 | 1095255 | 2021-03-06 | Orange | Texas | 48361 | 7707 | 119 |
1091462 | 1091462 | 2021-03-05 | Umatilla | Oregon | 41059 | 7707 | 82 |
1013617 | 1013617 | 2021-02-09 | Mercer | Pennsylvania | 42085 | 7707 | 233 |
953583 | 953583 | 2021-01-22 | Vermilion | Illinois | 17183 | 7707 | 115 |
943348 | 943348 | 2021-01-19 | El Dorado | California | 6017 | 7707 | 44 |
928754 | 928754 | 2021-01-14 | Lea | New Mexico | 35025 | 7707 | 108 |
852885 | 852885 | 2020-12-22 | Twin Falls | Idaho | 16083 | 7707 | 112 |
776390 | 776390 | 2020-11-28 | Union | North Carolina | 37179 | 7707 | 73 |
636323 | 636323 | 2020-10-16 | Hinds | Mississippi | 28049 | 7707 | 170 |
255024 | 255024 | 2020-06-19 | Davidson | Tennessee | 47037 | 7707 | 93 |
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);