ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
148 rows where cases = 3893 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Minnesota 16
- Kentucky 12
- Iowa 10
- Texas 10
- North Carolina 9
- Georgia 7
- Kansas 7
- Illinois 6
- Alabama 5
- Michigan 5
- Missouri 5
- Ohio 5
- Arkansas 4
- West Virginia 4
- Alaska 3
- Tennessee 3
- Virginia 3
- Wyoming 3
- Florida 2
- Idaho 2
- Indiana 2
- Louisiana 2
- Maryland 2
- Mississippi 2
- Nebraska 2
- New Hampshire 2
- New York 2
- Puerto Rico 2
- South Carolina 2
- South Dakota 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2427052 | 2427052 | 2022-04-20 | Lares | Puerto Rico | 72081 | 3893 | |
2421559 | 2421559 | 2022-04-19 | Izard | Arkansas | 5065 | 3893 | 69 |
2383010 | 2383010 | 2022-04-07 | Mason | Illinois | 17125 | 3893 | 61 |
2379755 | 2379755 | 2022-04-06 | Mason | Illinois | 17125 | 3893 | 61 |
2339910 | 2339910 | 2022-03-24 | Braxton | West Virginia | 54007 | 3893 | 42 |
2331262 | 2331262 | 2022-03-22 | Osage | Kansas | 20139 | 3893 | 45 |
2333176 | 2333176 | 2022-03-22 | Young | Texas | 48503 | 3893 | 90 |
2328010 | 2328010 | 2022-03-21 | Osage | Kansas | 20139 | 3893 | 45 |
2324909 | 2324909 | 2022-03-20 | Webster | Kentucky | 21233 | 3893 | 48 |
2321655 | 2321655 | 2022-03-19 | Webster | Kentucky | 21233 | 3893 | 48 |
2318401 | 2318401 | 2022-03-18 | Webster | Kentucky | 21233 | 3893 | 48 |
2315148 | 2315148 | 2022-03-17 | Webster | Kentucky | 21233 | 3893 | 48 |
2311895 | 2311895 | 2022-03-16 | Webster | Kentucky | 21233 | 3893 | 48 |
2308642 | 2308642 | 2022-03-15 | Webster | Kentucky | 21233 | 3893 | 48 |
2305391 | 2305391 | 2022-03-14 | Webster | Kentucky | 21233 | 3893 | 48 |
2286526 | 2286526 | 2022-03-08 | York | Nebraska | 31185 | 3893 | 19 |
2283274 | 2283274 | 2022-03-07 | York | Nebraska | 31185 | 3893 | 19 |
2246210 | 2246210 | 2022-02-24 | Jeff Davis | Georgia | 13161 | 3893 | 66 |
2237048 | 2237048 | 2022-02-21 | Knott | Kentucky | 21119 | 3893 | 55 |
2194535 | 2194535 | 2022-02-08 | Delaware | Iowa | 19055 | 3893 | 65 |
2191281 | 2191281 | 2022-02-07 | Delaware | Iowa | 19055 | 3893 | 65 |
2188028 | 2188028 | 2022-02-06 | Delaware | Iowa | 19055 | 3893 | 65 |
2190085 | 2190085 | 2022-02-06 | Zavala | Texas | 48507 | 3893 | 59 |
2184775 | 2184775 | 2022-02-05 | Delaware | Iowa | 19055 | 3893 | 65 |
2181523 | 2181523 | 2022-02-04 | Delaware | Iowa | 19055 | 3893 | 65 |
2178057 | 2178057 | 2022-02-03 | Carroll | Illinois | 17015 | 3893 | 46 |
2178272 | 2178272 | 2022-02-03 | Delaware | Iowa | 19055 | 3893 | 65 |
2174804 | 2174804 | 2022-02-02 | Carroll | Illinois | 17015 | 3893 | 46 |
2175019 | 2175019 | 2022-02-02 | Delaware | Iowa | 19055 | 3893 | 65 |
2170843 | 2170843 | 2022-01-31 | Wetzel | West Virginia | 54103 | 3893 | 71 |
2156581 | 2156581 | 2022-01-27 | Avery | North Carolina | 37011 | 3893 | 39 |
2099524 | 2099524 | 2022-01-10 | Lawrence | Arkansas | 5075 | 3893 | 64 |
2092417 | 2092417 | 2022-01-07 | Moore | Texas | 48341 | 3893 | 95 |
2084706 | 2084706 | 2022-01-05 | Ray | Missouri | 29177 | 3893 | 69 |
2080018 | 2080018 | 2022-01-04 | Logan | Arkansas | 5083 | 3893 | 56 |
2074587 | 2074587 | 2022-01-02 | Talbot | Maryland | 24041 | 3893 | 64 |
2037352 | 2037352 | 2021-12-21 | Hopewell city | Virginia | 51670 | 3893 | 95 |
2009242 | 2009242 | 2021-12-13 | Unknown | Iowa | 3893 | 0 | |
2005567 | 2005567 | 2021-12-12 | Haralson | Georgia | 13143 | 3893 | 130 |
2005991 | 2005991 | 2021-12-12 | Unknown | Iowa | 3893 | 0 | |
2002316 | 2002316 | 2021-12-11 | Haralson | Georgia | 13143 | 3893 | 130 |
2002740 | 2002740 | 2021-12-11 | Unknown | Iowa | 3893 | 0 | |
1999066 | 1999066 | 2021-12-10 | Haralson | Georgia | 13143 | 3893 | 130 |
1937848 | 1937848 | 2021-11-21 | Allen | Kentucky | 21003 | 3893 | 72 |
1934598 | 1934598 | 2021-11-20 | Allen | Kentucky | 21003 | 3893 | 72 |
1936697 | 1936697 | 2021-11-20 | Boone | West Virginia | 54005 | 3893 | 60 |
1931347 | 1931347 | 2021-11-19 | Allen | Kentucky | 21003 | 3893 | 72 |
1923011 | 1923011 | 2021-11-16 | Abbeville | South Carolina | 45001 | 3893 | 50 |
1919762 | 1919762 | 2021-11-15 | Abbeville | South Carolina | 45001 | 3893 | 50 |
1899153 | 1899153 | 2021-11-09 | Oceana | Michigan | 26127 | 3893 | 71 |
1895903 | 1895903 | 2021-11-08 | Oceana | Michigan | 26127 | 3893 | 71 |
1873843 | 1873843 | 2021-11-01 | Transylvania | North Carolina | 37175 | 3893 | 48 |
1863324 | 1863324 | 2021-10-29 | Queen Anne's | Maryland | 24035 | 3893 | 72 |
1841683 | 1841683 | 2021-10-22 | Warren | Pennsylvania | 42123 | 3893 | 122 |
1836299 | 1836299 | 2021-10-21 | Calaveras | California | 6009 | 3893 | 81 |
1823695 | 1823695 | 2021-10-17 | Jefferson | Idaho | 16051 | 3893 | 42 |
1824516 | 1824516 | 2021-10-17 | Todd | Minnesota | 27153 | 3893 | 36 |
1820446 | 1820446 | 2021-10-16 | Jefferson | Idaho | 16051 | 3893 | 42 |
1821267 | 1821267 | 2021-10-16 | Todd | Minnesota | 27153 | 3893 | 36 |
1818018 | 1818018 | 2021-10-15 | Todd | Minnesota | 27153 | 3893 | 36 |
1805221 | 1805221 | 2021-10-11 | Stone | Missouri | 29209 | 3893 | 83 |
1801743 | 1801743 | 2021-10-10 | Mille Lacs | Minnesota | 27095 | 3893 | 64 |
1801972 | 1801972 | 2021-10-10 | Stone | Missouri | 29209 | 3893 | 83 |
1798494 | 1798494 | 2021-10-09 | Mille Lacs | Minnesota | 27095 | 3893 | 64 |
1795245 | 1795245 | 2021-10-08 | Mille Lacs | Minnesota | 27095 | 3893 | 64 |
1775940 | 1775940 | 2021-10-02 | Miller | Missouri | 29131 | 3893 | 74 |
1650976 | 1650976 | 2021-08-25 | Marion | Alabama | 1093 | 3893 | 108 |
1647727 | 1647727 | 2021-08-24 | Marion | Alabama | 1093 | 3893 | 108 |
1644478 | 1644478 | 2021-08-23 | Marion | Alabama | 1093 | 3893 | 108 |
1561804 | 1561804 | 2021-07-28 | Rio Arriba | New Mexico | 35039 | 3893 | 81 |
1554803 | 1554803 | 2021-07-26 | Becker | Minnesota | 27005 | 3893 | 57 |
1509564 | 1509564 | 2021-07-12 | Laclede | Missouri | 29105 | 3893 | 76 |
1500403 | 1500403 | 2021-07-09 | Preble | Ohio | 39135 | 3893 | 106 |
1493168 | 1493168 | 2021-07-07 | Polk | Minnesota | 27119 | 3893 | 72 |
1489921 | 1489921 | 2021-07-06 | Polk | Minnesota | 27119 | 3893 | 72 |
1486674 | 1486674 | 2021-07-05 | Polk | Minnesota | 27119 | 3893 | 72 |
1483428 | 1483428 | 2021-07-04 | Polk | Minnesota | 27119 | 3893 | 72 |
1480182 | 1480182 | 2021-07-03 | Polk | Minnesota | 27119 | 3893 | 72 |
1476935 | 1476935 | 2021-07-02 | Polk | Minnesota | 27119 | 3893 | 72 |
1473689 | 1473689 | 2021-07-01 | Polk | Minnesota | 27119 | 3893 | 72 |
1470494 | 1470494 | 2021-06-30 | Hancock | Mississippi | 28045 | 3893 | 87 |
1451573 | 1451573 | 2021-06-24 | Scotland | North Carolina | 37165 | 3893 | 88 |
1448123 | 1448123 | 2021-06-23 | Cheshire | New Hampshire | 33005 | 3893 | 35 |
1448327 | 1448327 | 2021-06-23 | Scotland | North Carolina | 37165 | 3893 | 88 |
1444878 | 1444878 | 2021-06-22 | Cheshire | New Hampshire | 33005 | 3893 | 35 |
1391280 | 1391280 | 2021-06-06 | Boone | Arkansas | 5009 | 3893 | 80 |
1380039 | 1380039 | 2021-06-02 | Cortland | New York | 36023 | 3893 | 60 |
1375693 | 1375693 | 2021-06-01 | Miami | Indiana | 18103 | 3893 | 69 |
1336051 | 1336051 | 2021-05-20 | Bethel Census Area | Alaska | 2050 | 3893 | 22 |
1332804 | 1332804 | 2021-05-19 | Bethel Census Area | Alaska | 2050 | 3893 | 22 |
1324393 | 1324393 | 2021-05-16 | Steele | Minnesota | 27147 | 3893 | 15 |
1223613 | 1223613 | 2021-04-15 | Hillsdale | Michigan | 26059 | 3893 | 82 |
1216497 | 1216497 | 2021-04-13 | Lee | Illinois | 17103 | 3893 | 88 |
1212660 | 1212660 | 2021-04-12 | Tallapoosa | Alabama | 1123 | 3893 | 146 |
1209411 | 1209411 | 2021-04-11 | Tallapoosa | Alabama | 1123 | 3893 | 146 |
1195574 | 1195574 | 2021-04-06 | Brookings | South Dakota | 46011 | 3893 | 37 |
1189743 | 1189743 | 2021-04-04 | Ohio | West Virginia | 54069 | 3893 | 81 |
1170874 | 1170874 | 2021-03-30 | Oconee | Georgia | 13219 | 3893 | 68 |
1143235 | 1143235 | 2021-03-21 | Fulton | Ohio | 39051 | 3893 | 64 |
1128158 | 1128158 | 2021-03-16 | Sweetwater | Wyoming | 56037 | 3893 | 36 |
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);