ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
258 rows where cases = 2062 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 32
- Kentucky 21
- Arkansas 20
- Georgia 17
- Michigan 15
- Puerto Rico 12
- Virginia 12
- Missouri 11
- Montana 10
- West Virginia 10
- Indiana 8
- Kansas 8
- Idaho 7
- Mississippi 7
- Louisiana 6
- New York 6
- Tennessee 6
- Oklahoma 4
- Colorado 3
- Florida 3
- Illinois 3
- Iowa 3
- Massachusetts 3
- Minnesota 3
- New Mexico 3
- North Carolina 3
- Wisconsin 3
- Alabama 2
- Arizona 2
- Ohio 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2473399 | 2473399 | 2022-05-04 | Pocahontas | West Virginia | 54075 | 2062 | 30 |
2470142 | 2470142 | 2022-05-03 | Pocahontas | West Virginia | 54075 | 2062 | 30 |
2377154 | 2377154 | 2022-04-05 | Presque Isle | Michigan | 26141 | 2062 | 57 |
2373902 | 2373902 | 2022-04-04 | Presque Isle | Michigan | 26141 | 2062 | 57 |
2370649 | 2370649 | 2022-04-03 | Presque Isle | Michigan | 26141 | 2062 | 57 |
2367396 | 2367396 | 2022-04-02 | Presque Isle | Michigan | 26141 | 2062 | 57 |
2364143 | 2364143 | 2022-04-01 | Presque Isle | Michigan | 26141 | 2062 | 57 |
2360889 | 2360889 | 2022-03-31 | Presque Isle | Michigan | 26141 | 2062 | 57 |
2362715 | 2362715 | 2022-03-31 | Pleasants | West Virginia | 54073 | 2062 | 35 |
2357635 | 2357635 | 2022-03-30 | Presque Isle | Michigan | 26141 | 2062 | 57 |
2359461 | 2359461 | 2022-03-30 | Pleasants | West Virginia | 54073 | 2062 | 35 |
2354686 | 2354686 | 2022-03-29 | Blaine | Montana | 30005 | 2062 | 31 |
2356207 | 2356207 | 2022-03-29 | Pleasants | West Virginia | 54073 | 2062 | 34 |
2351433 | 2351433 | 2022-03-28 | Blaine | Montana | 30005 | 2062 | 31 |
2352954 | 2352954 | 2022-03-28 | Pleasants | West Virginia | 54073 | 2062 | 34 |
2348181 | 2348181 | 2022-03-27 | Blaine | Montana | 30005 | 2062 | 31 |
2344928 | 2344928 | 2022-03-26 | Blaine | Montana | 30005 | 2062 | 31 |
2341675 | 2341675 | 2022-03-25 | Blaine | Montana | 30005 | 2062 | 31 |
2334915 | 2334915 | 2022-03-23 | Lake | Minnesota | 27075 | 2062 | 28 |
2331661 | 2331661 | 2022-03-22 | Lake | Minnesota | 27075 | 2062 | 28 |
2265668 | 2265668 | 2022-03-02 | Clinch | Georgia | 13065 | 2062 | 38 |
2258918 | 2258918 | 2022-02-28 | Searcy | Arkansas | 5129 | 2062 | 41 |
2259534 | 2259534 | 2022-02-28 | Warren | Indiana | 18171 | 2062 | 25 |
2220765 | 2220765 | 2022-02-16 | Elliott | Kentucky | 21063 | 2062 | 16 |
2194680 | 2194680 | 2022-02-08 | Pawnee | Kansas | 20145 | 2062 | 23 |
2191426 | 2191426 | 2022-02-07 | Pawnee | Kansas | 20145 | 2062 | 23 |
2182243 | 2182243 | 2022-02-04 | Iron | Missouri | 29093 | 2062 | 35 |
2179501 | 2179501 | 2022-02-03 | Traill | North Dakota | 38097 | 2062 | 22 |
2168729 | 2168729 | 2022-01-31 | Gallatin | Kentucky | 21077 | 2062 | 45 |
2164535 | 2164535 | 2022-01-30 | Greenlee | Arizona | 4011 | 2062 | 30 |
2164898 | 2164898 | 2022-01-30 | Heard | Georgia | 13149 | 2062 | 44 |
2161643 | 2161643 | 2022-01-29 | Heard | Georgia | 13149 | 2062 | 44 |
2158387 | 2158387 | 2022-01-28 | Heard | Georgia | 13149 | 2062 | 44 |
2151719 | 2151719 | 2022-01-26 | San Miguel | Colorado | 8113 | 2062 | 7 |
2131003 | 2131003 | 2022-01-19 | Florida | Puerto Rico | 72054 | 2062 | |
2126667 | 2126667 | 2022-01-18 | Iron | Michigan | 26071 | 2062 | 74 |
2123415 | 2123415 | 2022-01-17 | Iron | Michigan | 26071 | 2062 | 74 |
2123772 | 2123772 | 2022-01-17 | Jefferson | Montana | 30043 | 2062 | 22 |
2120163 | 2120163 | 2022-01-16 | Iron | Michigan | 26071 | 2062 | 74 |
2120520 | 2120520 | 2022-01-16 | Jefferson | Montana | 30043 | 2062 | 22 |
2116911 | 2116911 | 2022-01-15 | Iron | Michigan | 26071 | 2062 | 74 |
2117268 | 2117268 | 2022-01-15 | Jefferson | Montana | 30043 | 2062 | 22 |
2113660 | 2113660 | 2022-01-14 | Iron | Michigan | 26071 | 2062 | 74 |
2114017 | 2114017 | 2022-01-14 | Jefferson | Montana | 30043 | 2062 | 22 |
2111597 | 2111597 | 2022-01-13 | Bon Homme | South Dakota | 46009 | 2062 | 33 |
2107241 | 2107241 | 2022-01-12 | Koochiching | Minnesota | 27071 | 2062 | 32 |
2101375 | 2101375 | 2022-01-10 | Washington | North Carolina | 37187 | 2062 | 39 |
2097944 | 2097944 | 2022-01-09 | Colfax | New Mexico | 35007 | 2062 | 56 |
2094692 | 2094692 | 2022-01-08 | Colfax | New Mexico | 35007 | 2062 | 56 |
2091440 | 2091440 | 2022-01-07 | Colfax | New Mexico | 35007 | 2062 | 56 |
2087927 | 2087927 | 2022-01-06 | Linn | Missouri | 29115 | 2062 | 58 |
2084673 | 2084673 | 2022-01-05 | Lewis | Missouri | 29111 | 2062 | 31 |
2080769 | 2080769 | 2022-01-04 | Brown | Kansas | 20013 | 2062 | 42 |
2077517 | 2077517 | 2022-01-03 | Brown | Kansas | 20013 | 2062 | 42 |
2077725 | 2077725 | 2022-01-03 | Todd | Kentucky | 21219 | 2062 | 38 |
2073542 | 2073542 | 2022-01-02 | Stone | Arkansas | 5137 | 2062 | 49 |
2057227 | 2057227 | 2021-12-28 | Bradley | Arkansas | 5011 | 2062 | 42 |
2033457 | 2033457 | 2021-12-20 | Cabo Rojo | Puerto Rico | 72023 | 2062 | |
2008628 | 2008628 | 2021-12-13 | Gunnison | Colorado | 8051 | 2062 | 12 |
2006338 | 2006338 | 2021-12-12 | Dukes | Massachusetts | 25007 | 2062 | 0 |
2003087 | 2003087 | 2021-12-11 | Dukes | Massachusetts | 25007 | 2062 | 0 |
1999837 | 1999837 | 2021-12-10 | Dukes | Massachusetts | 25007 | 2062 | 0 |
1983430 | 1983430 | 2021-12-05 | Martin | Kentucky | 21159 | 2062 | 37 |
1980180 | 1980180 | 2021-12-04 | Martin | Kentucky | 21159 | 2062 | 37 |
1976930 | 1976930 | 2021-12-03 | Martin | Kentucky | 21159 | 2062 | 37 |
1967596 | 1967596 | 2021-11-30 | Webster | Mississippi | 28155 | 2062 | 48 |
1932694 | 1932694 | 2021-11-19 | Cayey | Puerto Rico | 72035 | 2062 | |
1925420 | 1925420 | 2021-11-17 | Pemiscot | Missouri | 29155 | 2062 | 44 |
1918358 | 1918358 | 2021-11-15 | Breathitt | Kentucky | 21025 | 2062 | 38 |
1918921 | 1918921 | 2021-11-15 | Pemiscot | Missouri | 29155 | 2062 | 44 |
1883254 | 1883254 | 2021-11-04 | Roosevelt | Montana | 30085 | 2062 | 59 |
1874869 | 1874869 | 2021-11-01 | Patrick | Virginia | 51141 | 2062 | 55 |
1855685 | 1855685 | 2021-10-27 | Kusilvak Census Area | Alaska | 2158 | 2062 | 8 |
1857023 | 1857023 | 2021-10-27 | Amite | Mississippi | 28005 | 2062 | 56 |
1855334 | 1855334 | 2021-10-26 | Grayson | Virginia | 51077 | 2062 | 46 |
1852085 | 1852085 | 2021-10-25 | Grayson | Virginia | 51077 | 2062 | 46 |
1836690 | 1836690 | 2021-10-21 | Idaho | Idaho | 16049 | 2062 | 32 |
1836728 | 1836728 | 2021-10-21 | De Witt | Illinois | 17039 | 2062 | 37 |
1829208 | 1829208 | 2021-10-18 | Terry | Texas | 48445 | 2062 | 64 |
1829291 | 1829291 | 2021-10-18 | Alleghany | Virginia | 51005 | 2062 | 68 |
1825959 | 1825959 | 2021-10-17 | Terry | Texas | 48445 | 2062 | 64 |
1822710 | 1822710 | 2021-10-16 | Terry | Texas | 48445 | 2062 | 64 |
1819461 | 1819461 | 2021-10-15 | Terry | Texas | 48445 | 2062 | 64 |
1816212 | 1816212 | 2021-10-14 | Terry | Texas | 48445 | 2062 | 64 |
1794019 | 1794019 | 2021-10-08 | Lee | Arkansas | 5077 | 2062 | 48 |
1781903 | 1781903 | 2021-10-04 | Clinton | Kentucky | 21053 | 2062 | 33 |
1778653 | 1778653 | 2021-10-03 | Clinton | Kentucky | 21053 | 2062 | 33 |
1775403 | 1775403 | 2021-10-02 | Clinton | Kentucky | 21053 | 2062 | 33 |
1777294 | 1777294 | 2021-10-02 | Orleans | Vermont | 50019 | 2062 | 13 |
1745381 | 1745381 | 2021-09-23 | Alamosa | Colorado | 8003 | 2062 | 42 |
1745832 | 1745832 | 2021-09-23 | Washington | Illinois | 17189 | 2062 | 33 |
1740073 | 1740073 | 2021-09-21 | Greene | Mississippi | 28041 | 2062 | 45 |
1730447 | 1730447 | 2021-09-18 | Macon | Missouri | 29121 | 2062 | 19 |
1727172 | 1727172 | 2021-09-17 | Gasconade | Missouri | 29073 | 2062 | 48 |
1718526 | 1718526 | 2021-09-14 | Bandera | Texas | 48019 | 2062 | 42 |
1674064 | 1674064 | 2021-09-01 | Bleckley | Georgia | 13023 | 2062 | 53 |
1634565 | 1634565 | 2021-08-19 | Nicholas | West Virginia | 54067 | 2062 | 26 |
1627954 | 1627954 | 2021-08-17 | Nottoway | Virginia | 51135 | 2062 | 55 |
1624306 | 1624306 | 2021-08-16 | Union | Tennessee | 47173 | 2062 | 34 |
1615318 | 1615318 | 2021-08-14 | Clay | Arkansas | 5021 | 2062 | 52 |
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);