ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
273 rows where cases = 1788 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Illinois 25
- Virginia 17
- Alabama 16
- Kentucky 16
- Mississippi 16
- Georgia 15
- Texas 15
- Tennessee 14
- Minnesota 11
- Missouri 11
- Iowa 9
- Arkansas 8
- Indiana 8
- Oklahoma 8
- Kansas 7
- Louisiana 7
- North Carolina 7
- Colorado 6
- South Carolina 5
- Michigan 4
- Ohio 4
- Pennsylvania 4
- Puerto Rico 4
- Florida 3
- Nebraska 3
- New York 3
- North Dakota 3
- Washington 3
- Wisconsin 3
- Idaho 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2447270 | 2447270 | 2022-04-26 | Williamsburg city | Virginia | 51830 | 1788 | 22 |
2444014 | 2444014 | 2022-04-25 | Williamsburg city | Virginia | 51830 | 1788 | 22 |
2428862 | 2428862 | 2022-04-21 | Greenwood | Kansas | 20073 | 1788 | 23 |
2425606 | 2425606 | 2022-04-20 | Greenwood | Kansas | 20073 | 1788 | 23 |
2422350 | 2422350 | 2022-04-19 | Greenwood | Kansas | 20073 | 1788 | 23 |
2419094 | 2419094 | 2022-04-18 | Greenwood | Kansas | 20073 | 1788 | 23 |
2415838 | 2415838 | 2022-04-17 | Greenwood | Kansas | 20073 | 1788 | 23 |
2412582 | 2412582 | 2022-04-16 | Greenwood | Kansas | 20073 | 1788 | 23 |
2409326 | 2409326 | 2022-04-15 | Greenwood | Kansas | 20073 | 1788 | 23 |
2296886 | 2296886 | 2022-03-11 | Hormigueros | Puerto Rico | 72067 | 1788 | |
2247422 | 2247422 | 2022-02-24 | Butler | Nebraska | 31023 | 1788 | 14 |
2244171 | 2244171 | 2022-02-23 | Butler | Nebraska | 31023 | 1788 | 14 |
2237481 | 2237481 | 2022-02-21 | Wilkinson | Mississippi | 28157 | 1788 | 44 |
2234230 | 2234230 | 2022-02-20 | Wilkinson | Mississippi | 28157 | 1788 | 44 |
2230979 | 2230979 | 2022-02-19 | Wilkinson | Mississippi | 28157 | 1788 | 44 |
2227728 | 2227728 | 2022-02-18 | Wilkinson | Mississippi | 28157 | 1788 | 44 |
2217767 | 2217767 | 2022-02-15 | Lake | Michigan | 26085 | 1788 | 34 |
2214516 | 2214516 | 2022-02-14 | Lake | Michigan | 26085 | 1788 | 34 |
2211070 | 2211070 | 2022-02-13 | Nicholas | Kentucky | 21181 | 1788 | 29 |
2207817 | 2207817 | 2022-02-12 | Nicholas | Kentucky | 21181 | 1788 | 29 |
2204564 | 2204564 | 2022-02-11 | Nicholas | Kentucky | 21181 | 1788 | 29 |
2148334 | 2148334 | 2022-01-25 | Prairie | Arkansas | 5117 | 1788 | 32 |
2142151 | 2142151 | 2022-01-23 | Montgomery | Georgia | 13209 | 1788 | 46 |
2138896 | 2138896 | 2022-01-22 | Montgomery | Georgia | 13209 | 1788 | 46 |
2135321 | 2135321 | 2022-01-21 | Searcy | Arkansas | 5129 | 1788 | 35 |
2135640 | 2135640 | 2022-01-21 | Montgomery | Georgia | 13209 | 1788 | 46 |
2018151 | 2018151 | 2021-12-16 | Lowndes | Alabama | 1085 | 1788 | 68 |
2014076 | 2014076 | 2021-12-14 | Bon Homme | South Dakota | 46009 | 1788 | 31 |
2006509 | 2006509 | 2021-12-12 | Swift | Minnesota | 27151 | 1788 | 24 |
2003258 | 2003258 | 2021-12-11 | Swift | Minnesota | 27151 | 1788 | 24 |
2000008 | 2000008 | 2021-12-10 | Swift | Minnesota | 27151 | 1788 | 24 |
2001268 | 2001268 | 2021-12-10 | Childress | Texas | 48075 | 1788 | 22 |
1986996 | 1986996 | 2021-12-06 | Rock | Minnesota | 27133 | 1788 | 29 |
1978770 | 1978770 | 2021-12-03 | Orange | Vermont | 50017 | 1788 | 7 |
1973084 | 1973084 | 2021-12-02 | Long | Georgia | 13183 | 1788 | 28 |
1974973 | 1974973 | 2021-12-02 | Juana Diaz | Puerto Rico | 72075 | 1788 | |
1967728 | 1967728 | 2021-11-30 | Dawson | Montana | 30021 | 1788 | 49 |
1944479 | 1944479 | 2021-11-23 | Catahoula | Louisiana | 22025 | 1788 | 48 |
1923978 | 1923978 | 2021-11-17 | Fulton | Arkansas | 5049 | 1788 | 66 |
1909628 | 1909628 | 2021-11-12 | Mercer | North Dakota | 38057 | 1788 | 17 |
1901346 | 1901346 | 2021-11-10 | Bent | Colorado | 8011 | 1788 | 29 |
1848798 | 1848798 | 2021-10-24 | Brunswick | Virginia | 51025 | 1788 | 32 |
1845548 | 1845548 | 2021-10-23 | Brunswick | Virginia | 51025 | 1788 | 32 |
1842298 | 1842298 | 2021-10-22 | Brunswick | Virginia | 51025 | 1788 | 32 |
1834866 | 1834866 | 2021-10-20 | Barnes | North Dakota | 38003 | 1788 | 33 |
1823130 | 1823130 | 2021-10-17 | Coosa | Alabama | 1037 | 1788 | 38 |
1811581 | 1811581 | 2021-10-13 | Montgomery | Mississippi | 28097 | 1788 | 56 |
1807139 | 1807139 | 2021-10-12 | Gunnison | Colorado | 8051 | 1788 | 10 |
1808332 | 1808332 | 2021-10-12 | Montgomery | Mississippi | 28097 | 1788 | 56 |
1765713 | 1765713 | 2021-09-29 | Metcalfe | Kentucky | 21169 | 1788 | 37 |
1765859 | 1765859 | 2021-09-29 | Dukes | Massachusetts | 25007 | 1788 | 0 |
1766749 | 1766749 | 2021-09-29 | Noble | Ohio | 39121 | 1788 | 42 |
1759686 | 1759686 | 2021-09-27 | Linn | Missouri | 29115 | 1788 | 24 |
1756438 | 1756438 | 2021-09-26 | Linn | Missouri | 29115 | 1788 | 24 |
1746479 | 1746479 | 2021-09-23 | Cottonwood | Minnesota | 27033 | 1788 | 24 |
1743284 | 1743284 | 2021-09-22 | Sibley | Minnesota | 27143 | 1788 | 10 |
1735069 | 1735069 | 2021-09-19 | Alleghany | Virginia | 51005 | 1788 | 59 |
1731819 | 1731819 | 2021-09-18 | Alleghany | Virginia | 51005 | 1788 | 59 |
1728569 | 1728569 | 2021-09-17 | Alleghany | Virginia | 51005 | 1788 | 59 |
1720213 | 1720213 | 2021-09-15 | Lyon | Kentucky | 21143 | 1788 | 23 |
1719111 | 1719111 | 2021-09-14 | Washburn | Wisconsin | 55129 | 1788 | 25 |
1688151 | 1688151 | 2021-09-05 | Webster | Mississippi | 28155 | 1788 | 36 |
1684901 | 1684901 | 2021-09-04 | Webster | Mississippi | 28155 | 1788 | 36 |
1681650 | 1681650 | 2021-09-03 | Webster | Mississippi | 28155 | 1788 | 36 |
1677676 | 1677676 | 2021-09-02 | Pike | Indiana | 18125 | 1788 | 35 |
1678009 | 1678009 | 2021-09-02 | Powell | Kentucky | 21197 | 1788 | 15 |
1672394 | 1672394 | 2021-08-31 | Polk | North Carolina | 37149 | 1788 | 33 |
1653503 | 1653503 | 2021-08-25 | Lake | Tennessee | 47095 | 1788 | 31 |
1650256 | 1650256 | 2021-08-24 | Lake | Tennessee | 47095 | 1788 | 31 |
1632456 | 1632456 | 2021-08-19 | Casey | Kentucky | 21045 | 1788 | 43 |
1621023 | 1621023 | 2021-08-15 | Lewis | Tennessee | 47101 | 1788 | 27 |
1615240 | 1615240 | 2021-08-14 | Macon | Alabama | 1087 | 1788 | 54 |
1617775 | 1617775 | 2021-08-14 | Lewis | Tennessee | 47101 | 1788 | 27 |
1611991 | 1611991 | 2021-08-13 | Macon | Alabama | 1087 | 1788 | 54 |
1614527 | 1614527 | 2021-08-13 | Lewis | Tennessee | 47101 | 1788 | 27 |
1597059 | 1597059 | 2021-08-08 | Houston | Minnesota | 27055 | 1788 | 16 |
1593810 | 1593810 | 2021-08-07 | Houston | Minnesota | 27055 | 1788 | 16 |
1590561 | 1590561 | 2021-08-06 | Houston | Minnesota | 27055 | 1788 | 16 |
1585066 | 1585066 | 2021-08-04 | Fajardo | Puerto Rico | 72053 | 1788 | |
1579606 | 1579606 | 2021-08-03 | Lee | Arkansas | 5077 | 1788 | 38 |
1554173 | 1554173 | 2021-07-26 | White | Illinois | 17193 | 1788 | 36 |
1540663 | 1540663 | 2021-07-22 | Sharp | Arkansas | 5135 | 1788 | 48 |
1537919 | 1537919 | 2021-07-21 | Richland | Illinois | 17159 | 1788 | 49 |
1515115 | 1515115 | 2021-07-14 | Carroll | Illinois | 17015 | 1788 | 38 |
1511869 | 1511869 | 2021-07-13 | Carroll | Illinois | 17015 | 1788 | 38 |
1512047 | 1512047 | 2021-07-13 | Vermillion | Indiana | 18165 | 1788 | 44 |
1512764 | 1512764 | 2021-07-13 | Benton | Missouri | 29015 | 1788 | 36 |
1508622 | 1508622 | 2021-07-12 | Carroll | Illinois | 17015 | 1788 | 38 |
1505376 | 1505376 | 2021-07-11 | Carroll | Illinois | 17015 | 1788 | 38 |
1502130 | 1502130 | 2021-07-10 | Carroll | Illinois | 17015 | 1788 | 38 |
1498884 | 1498884 | 2021-07-09 | Carroll | Illinois | 17015 | 1788 | 38 |
1495637 | 1495637 | 2021-07-08 | Carroll | Illinois | 17015 | 1788 | 38 |
1492391 | 1492391 | 2021-07-07 | Carroll | Illinois | 17015 | 1788 | 38 |
1489144 | 1489144 | 2021-07-06 | Carroll | Illinois | 17015 | 1788 | 38 |
1485897 | 1485897 | 2021-07-05 | Carroll | Illinois | 17015 | 1788 | 38 |
1482651 | 1482651 | 2021-07-04 | Carroll | Illinois | 17015 | 1788 | 38 |
1479404 | 1479404 | 2021-07-03 | Carroll | Illinois | 17015 | 1788 | 38 |
1476158 | 1476158 | 2021-07-02 | Carroll | Illinois | 17015 | 1788 | 38 |
1472912 | 1472912 | 2021-07-01 | Carroll | Illinois | 17015 | 1788 | 38 |
1433867 | 1433867 | 2021-06-19 | Rabun | Georgia | 13241 | 1788 | 49 |
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);