ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
75 rows where cases = 7013 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 27
- North Carolina 9
- Tennessee 9
- Mississippi 6
- Ohio 6
- Texas 6
- New York 5
- Indiana 4
- Georgia 3
- Kentucky 3
- Alabama 2
- Kansas 2
- Louisiana 2
- Minnesota 2
- Pennsylvania 2
- Washington 2
- Arkansas 1
- Florida 1
- Illinois 1
- Missouri 1
- Montana 1
- Nebraska 1
- New Jersey 1
- North Dakota 1
- Oregon 1
- South Carolina 1
- Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2497038 | 2497038 | 2022-05-12 | Decatur | Indiana | 18031 | 7013 | 147 |
2493780 | 2493780 | 2022-05-11 | Decatur | Indiana | 18031 | 7013 | 147 |
2461969 | 2461969 | 2022-05-01 | Simpson | Mississippi | 28127 | 7013 | 148 |
2458713 | 2458713 | 2022-04-30 | Simpson | Mississippi | 28127 | 7013 | 148 |
2455457 | 2455457 | 2022-04-29 | Simpson | Mississippi | 28127 | 7013 | 148 |
2452201 | 2452201 | 2022-04-28 | Simpson | Mississippi | 28127 | 7013 | 148 |
2448945 | 2448945 | 2022-04-27 | Simpson | Mississippi | 28127 | 7013 | 148 |
2445689 | 2445689 | 2022-04-26 | Simpson | Mississippi | 28127 | 7013 | 148 |
2384604 | 2384604 | 2022-04-07 | Lincoln | Oregon | 41041 | 7013 | 82 |
2316840 | 2316840 | 2022-03-17 | Palo Pinto | Texas | 48363 | 7013 | 152 |
2312433 | 2312433 | 2022-03-16 | Ravalli | Montana | 30081 | 7013 | 141 |
2290066 | 2290066 | 2022-03-09 | Stutsman | North Dakota | 38093 | 7013 | 97 |
2266615 | 2266615 | 2022-03-02 | Lyon | Minnesota | 27083 | 7013 | 72 |
2211940 | 2211940 | 2022-02-13 | Macon | North Carolina | 37113 | 7013 | 98 |
2208687 | 2208687 | 2022-02-12 | Macon | North Carolina | 37113 | 7013 | 98 |
2205434 | 2205434 | 2022-02-11 | Macon | North Carolina | 37113 | 7013 | 98 |
2009137 | 2009137 | 2021-12-13 | Steuben | Indiana | 18151 | 7013 | 92 |
1897197 | 1897197 | 2021-11-08 | Rhea | Tennessee | 47143 | 7013 | 93 |
1893947 | 1893947 | 2021-11-07 | Rhea | Tennessee | 47143 | 7013 | 93 |
1890697 | 1890697 | 2021-11-06 | Rhea | Tennessee | 47143 | 7013 | 93 |
1887447 | 1887447 | 2021-11-05 | Rhea | Tennessee | 47143 | 7013 | 93 |
1872509 | 1872509 | 2021-11-01 | Marion | Illinois | 17121 | 7013 | 152 |
1837973 | 1837973 | 2021-10-21 | Genesee | New York | 36037 | 7013 | 132 |
1826308 | 1826308 | 2021-10-17 | Oconto | Wisconsin | 55083 | 7013 | 76 |
1805753 | 1805753 | 2021-10-11 | Seneca | Ohio | 39147 | 7013 | 140 |
1789052 | 1789052 | 2021-10-06 | Buffalo | Nebraska | 31019 | 7013 | 62 |
1755361 | 1755361 | 2021-09-26 | Liberty | Georgia | 13179 | 7013 | 87 |
1752113 | 1752113 | 2021-09-25 | Liberty | Georgia | 13179 | 7013 | 87 |
1748864 | 1748864 | 2021-09-24 | Liberty | Georgia | 13179 | 7013 | 87 |
1747037 | 1747037 | 2021-09-23 | Wayne | New York | 36117 | 7013 | 78 |
1680297 | 1680297 | 2021-09-03 | Hot Spring | Arkansas | 5059 | 7013 | 100 |
1645791 | 1645791 | 2021-08-23 | Kandiyohi | Minnesota | 27067 | 7013 | 86 |
1623262 | 1623262 | 2021-08-16 | Newton | Missouri | 29145 | 7013 | 96 |
1575050 | 1575050 | 2021-08-01 | Geauga | Ohio | 39055 | 7013 | 153 |
1568358 | 1568358 | 2021-07-30 | Steuben | New York | 36101 | 7013 | 147 |
1566253 | 1566253 | 2021-07-29 | Rockingham | Virginia | 51165 | 7013 | 113 |
1528576 | 1528576 | 2021-07-18 | McCracken | Kentucky | 21145 | 7013 | 134 |
1525329 | 1525329 | 2021-07-17 | McCracken | Kentucky | 21145 | 7013 | 134 |
1522081 | 1522081 | 2021-07-16 | McCracken | Kentucky | 21145 | 7013 | 134 |
1495034 | 1495034 | 2021-07-08 | Blount | Alabama | 1009 | 7013 | 139 |
1491787 | 1491787 | 2021-07-07 | Blount | Alabama | 1009 | 7013 | 139 |
1450296 | 1450296 | 2021-06-24 | Boone | Indiana | 18011 | 7013 | 106 |
1394225 | 1394225 | 2021-06-06 | Chelan | Washington | 53007 | 7013 | 68 |
1390980 | 1390980 | 2021-06-05 | Chelan | Washington | 53007 | 7013 | 68 |
1373630 | 1373630 | 2021-05-31 | Franklin | North Carolina | 37069 | 7013 | 51 |
1370385 | 1370385 | 2021-05-30 | Franklin | North Carolina | 37069 | 7013 | 51 |
1367139 | 1367139 | 2021-05-29 | Franklin | North Carolina | 37069 | 7013 | 51 |
1363893 | 1363893 | 2021-05-28 | Franklin | North Carolina | 37069 | 7013 | 51 |
1357526 | 1357526 | 2021-05-26 | Ashtabula | Ohio | 39007 | 7013 | 176 |
1256693 | 1256693 | 2021-04-25 | Ontario | New York | 36069 | 7013 | 92 |
1240461 | 1240461 | 2021-04-20 | Oswego | New York | 36075 | 7013 | 90 |
1185683 | 1185683 | 2021-04-03 | Somerset | Pennsylvania | 42111 | 7013 | 190 |
1163076 | 1163076 | 2021-03-27 | Kershaw | South Carolina | 45055 | 7013 | 133 |
1121034 | 1121034 | 2021-03-14 | Tipton | Tennessee | 47167 | 7013 | 104 |
1117787 | 1117787 | 2021-03-13 | Tipton | Tennessee | 47167 | 7013 | 104 |
1114540 | 1114540 | 2021-03-12 | Tipton | Tennessee | 47167 | 7013 | 104 |
1110765 | 1110765 | 2021-03-11 | Erie | Ohio | 39043 | 7013 | 150 |
1101817 | 1101817 | 2021-03-08 | Wise | Texas | 48497 | 7013 | 113 |
1098571 | 1098571 | 2021-03-07 | Wise | Texas | 48497 | 7013 | 113 |
1095323 | 1095323 | 2021-03-06 | Wise | Texas | 48497 | 7013 | 113 |
1078991 | 1078991 | 2021-03-01 | Liberty | Texas | 48291 | 7013 | 159 |
1018706 | 1018706 | 2021-02-11 | Butler | Kansas | 20015 | 7013 | 52 |
1015461 | 1015461 | 2021-02-10 | Butler | Kansas | 20015 | 7013 | 52 |
1014115 | 1014115 | 2021-02-09 | Orange | Texas | 48361 | 7013 | 98 |
1007377 | 1007377 | 2021-02-07 | Greene | Tennessee | 47059 | 7013 | 134 |
961908 | 961908 | 2021-01-24 | Anderson | Tennessee | 47001 | 7013 | 114 |
954892 | 954892 | 2021-01-22 | Wilson | North Carolina | 37195 | 7013 | 123 |
741003 | 741003 | 2020-11-17 | Northampton | Pennsylvania | 42095 | 7013 | 323 |
696849 | 696849 | 2020-11-04 | Bay | Florida | 12005 | 7013 | 138 |
558870 | 558870 | 2020-09-22 | Burlington | New Jersey | 34005 | 7013 | 493 |
494309 | 494309 | 2020-09-02 | Guilford | North Carolina | 37081 | 7013 | 170 |
435363 | 435363 | 2020-08-15 | Calcasieu | Louisiana | 22019 | 7013 | 154 |
432138 | 432138 | 2020-08-14 | Calcasieu | Louisiana | 22019 | 7013 | 154 |
295394 | 295394 | 2020-07-02 | Cuyahoga | Ohio | 39035 | 7013 | 366 |
292239 | 292239 | 2020-07-01 | Cuyahoga | Ohio | 39035 | 7013 | 366 |
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);