ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
190 rows where cases = 2631 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Missouri 16
- Montana 16
- Georgia 15
- Kentucky 15
- Mississippi 13
- Virginia 10
- Minnesota 9
- Louisiana 7
- North Carolina 7
- Texas 7
- Illinois 6
- Ohio 6
- Iowa 5
- Michigan 5
- Tennessee 5
- Colorado 4
- Idaho 4
- Indiana 4
- New York 3
- Oklahoma 3
- West Virginia 3
- Alabama 2
- Florida 2
- Nebraska 2
- North Dakota 2
- Pennsylvania 2
- Puerto Rico 2
- Utah 2
- Wisconsin 2
- Arizona 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2471916 | 2471916 | 2022-05-04 | Rosebud | Montana | 30087 | 2631 | 60 |
2468660 | 2468660 | 2022-05-03 | Rosebud | Montana | 30087 | 2631 | 60 |
2465404 | 2465404 | 2022-05-02 | Rosebud | Montana | 30087 | 2631 | 60 |
2462149 | 2462149 | 2022-05-01 | Rosebud | Montana | 30087 | 2631 | 60 |
2458893 | 2458893 | 2022-04-30 | Rosebud | Montana | 30087 | 2631 | 60 |
2455637 | 2455637 | 2022-04-29 | Rosebud | Montana | 30087 | 2631 | 60 |
2419564 | 2419564 | 2022-04-18 | Stevens | Minnesota | 27149 | 2631 | 13 |
2406797 | 2406797 | 2022-04-14 | Rosebud | Montana | 30087 | 2631 | 60 |
2403541 | 2403541 | 2022-04-13 | Rosebud | Montana | 30087 | 2631 | 60 |
2400286 | 2400286 | 2022-04-12 | Rosebud | Montana | 30087 | 2631 | 60 |
2397031 | 2397031 | 2022-04-11 | Rosebud | Montana | 30087 | 2631 | 60 |
2354727 | 2354727 | 2022-03-29 | Rosebud | Montana | 30087 | 2631 | 60 |
2351474 | 2351474 | 2022-03-28 | Rosebud | Montana | 30087 | 2631 | 60 |
2348222 | 2348222 | 2022-03-27 | Rosebud | Montana | 30087 | 2631 | 60 |
2344969 | 2344969 | 2022-03-26 | Rosebud | Montana | 30087 | 2631 | 60 |
2341716 | 2341716 | 2022-03-25 | Rosebud | Montana | 30087 | 2631 | 60 |
2235548 | 2235548 | 2022-02-20 | Pecos | Texas | 48371 | 2631 | 68 |
2232297 | 2232297 | 2022-02-19 | Pecos | Texas | 48371 | 2631 | 68 |
2211112 | 2211112 | 2022-02-13 | Catahoula | Louisiana | 22025 | 2631 | 55 |
2207859 | 2207859 | 2022-02-12 | Catahoula | Louisiana | 22025 | 2631 | 55 |
2204606 | 2204606 | 2022-02-11 | Catahoula | Louisiana | 22025 | 2631 | 55 |
2192215 | 2192215 | 2022-02-07 | Unknown | Nebraska | 2631 | 336 | |
2153563 | 2153563 | 2022-01-26 | Vinton | Ohio | 39163 | 2631 | 46 |
2134977 | 2134977 | 2022-01-20 | Klickitat | Washington | 53039 | 2631 | 37 |
2112166 | 2112166 | 2022-01-13 | Rockbridge | Virginia | 51163 | 2631 | 72 |
2107367 | 2107367 | 2022-01-12 | Walthall | Mississippi | 28147 | 2631 | 69 |
2094407 | 2094407 | 2022-01-08 | Gasconade | Missouri | 29073 | 2631 | 87 |
2086139 | 2086139 | 2022-01-05 | Patrick | Virginia | 51141 | 2631 | 72 |
2082860 | 2082860 | 2022-01-04 | King William | Virginia | 51101 | 2631 | 27 |
2074025 | 2074025 | 2022-01-02 | Massac | Illinois | 17127 | 2631 | 61 |
2070774 | 2070774 | 2022-01-01 | Massac | Illinois | 17127 | 2631 | 61 |
2067523 | 2067523 | 2021-12-31 | Massac | Illinois | 17127 | 2631 | 61 |
2064272 | 2064272 | 2021-12-30 | Massac | Illinois | 17127 | 2631 | 61 |
2051730 | 2051730 | 2021-12-26 | Webster | Kentucky | 21233 | 2631 | 43 |
2048480 | 2048480 | 2021-12-25 | Webster | Kentucky | 21233 | 2631 | 43 |
2045230 | 2045230 | 2021-12-24 | Webster | Kentucky | 21233 | 2631 | 43 |
2041981 | 2041981 | 2021-12-23 | Webster | Kentucky | 21233 | 2631 | 43 |
2038731 | 2038731 | 2021-12-22 | Webster | Kentucky | 21233 | 2631 | 43 |
2040311 | 2040311 | 2021-12-22 | Falls | Texas | 48145 | 2631 | 51 |
2036395 | 2036395 | 2021-12-21 | McKenzie | North Dakota | 38053 | 2631 | 23 |
2034322 | 2034322 | 2021-12-20 | Rusk | Wisconsin | 55107 | 2631 | 39 |
2029246 | 2029246 | 2021-12-19 | Pennington | Minnesota | 27113 | 2631 | 31 |
2025995 | 2025995 | 2021-12-18 | Pennington | Minnesota | 27113 | 2631 | 31 |
2022744 | 2022744 | 2021-12-17 | Pennington | Minnesota | 27113 | 2631 | 31 |
1970024 | 1970024 | 2021-12-01 | Moultrie | Illinois | 17139 | 2631 | 42 |
1966257 | 1966257 | 2021-11-30 | Madison | Arkansas | 5087 | 2631 | 40 |
1968074 | 1968074 | 2021-11-30 | Northampton | North Carolina | 37131 | 2631 | 66 |
1964823 | 1964823 | 2021-11-29 | Northampton | North Carolina | 37131 | 2631 | 66 |
1951239 | 1951239 | 2021-11-25 | Renville | Minnesota | 27129 | 2631 | 51 |
1947988 | 1947988 | 2021-11-24 | Renville | Minnesota | 27129 | 2631 | 51 |
1918958 | 1918958 | 2021-11-15 | Wright | Missouri | 29229 | 2631 | 54 |
1905639 | 1905639 | 2021-11-11 | Manistee | Michigan | 26101 | 2631 | 40 |
1905912 | 1905912 | 2021-11-11 | Moniteau | Missouri | 29135 | 2631 | 40 |
1902390 | 1902390 | 2021-11-10 | Manistee | Michigan | 26101 | 2631 | 40 |
1902663 | 1902663 | 2021-11-10 | Moniteau | Missouri | 29135 | 2631 | 40 |
1900863 | 1900863 | 2021-11-09 | Nottoway | Virginia | 51135 | 2631 | 68 |
1831090 | 1831090 | 2021-10-19 | Smith | Mississippi | 28129 | 2631 | 50 |
1780157 | 1780157 | 2021-10-03 | Benton | Tennessee | 47005 | 2631 | 47 |
1776907 | 1776907 | 2021-10-02 | Benton | Tennessee | 47005 | 2631 | 47 |
1773657 | 1773657 | 2021-10-01 | Benton | Tennessee | 47005 | 2631 | 47 |
1769636 | 1769636 | 2021-09-30 | Washington | Nebraska | 31177 | 2631 | 29 |
1766068 | 1766068 | 2021-09-29 | Holmes | Mississippi | 28051 | 2631 | 87 |
1762819 | 1762819 | 2021-09-28 | Holmes | Mississippi | 28051 | 2631 | 87 |
1763383 | 1763383 | 2021-09-28 | Yancey | North Carolina | 37199 | 2631 | 29 |
1758526 | 1758526 | 2021-09-27 | Banks | Georgia | 13011 | 2631 | 54 |
1759239 | 1759239 | 2021-09-27 | Spencer | Kentucky | 21215 | 2631 | 28 |
1740059 | 1740059 | 2021-09-21 | Calhoun | Mississippi | 28013 | 2631 | 40 |
1723911 | 1723911 | 2021-09-16 | Clinton | Missouri | 29049 | 2631 | 75 |
1718813 | 1718813 | 2021-09-14 | Washington | Vermont | 50023 | 2631 | 18 |
1700218 | 1700218 | 2021-09-09 | Blaine | Idaho | 16013 | 2631 | 20 |
1694238 | 1694238 | 2021-09-07 | McCreary | Kentucky | 21147 | 2631 | 35 |
1690989 | 1690989 | 2021-09-06 | McCreary | Kentucky | 21147 | 2631 | 35 |
1687739 | 1687739 | 2021-09-05 | McCreary | Kentucky | 21147 | 2631 | 35 |
1684489 | 1684489 | 2021-09-04 | McCreary | Kentucky | 21147 | 2631 | 35 |
1683275 | 1683275 | 2021-09-03 | Jackson | West Virginia | 54035 | 2631 | 64 |
1668737 | 1668737 | 2021-08-30 | New Madrid | Missouri | 29143 | 2631 | 49 |
1670183 | 1670183 | 2021-08-30 | Orange | Virginia | 51137 | 2631 | 42 |
1648738 | 1648738 | 2021-08-24 | Johnson | Kentucky | 21115 | 2631 | 38 |
1645049 | 1645049 | 2021-08-23 | Crawford | Illinois | 17033 | 2631 | 43 |
1631940 | 1631940 | 2021-08-19 | Putnam | Georgia | 13237 | 2631 | 64 |
1614662 | 1614662 | 2021-08-13 | Gray | Texas | 48179 | 2631 | 58 |
1572105 | 1572105 | 2021-07-31 | Rio Grande | Puerto Rico | 72119 | 2631 | |
1564309 | 1564309 | 2021-07-29 | Ohio | Kentucky | 21183 | 2631 | 55 |
1565810 | 1565810 | 2021-07-29 | Morgan | Tennessee | 47129 | 2631 | 38 |
1538459 | 1538459 | 2021-07-21 | Somerset | Maryland | 24039 | 2631 | 42 |
1523712 | 1523712 | 2021-07-16 | Gillespie | Texas | 48171 | 2631 | 52 |
1514198 | 1514198 | 2021-07-13 | Botetourt | Virginia | 51023 | 2631 | 38 |
1485696 | 1485696 | 2021-07-05 | Burke | Georgia | 13033 | 2631 | 65 |
1482450 | 1482450 | 2021-07-04 | Burke | Georgia | 13033 | 2631 | 65 |
1479203 | 1479203 | 2021-07-03 | Burke | Georgia | 13033 | 2631 | 65 |
1475957 | 1475957 | 2021-07-02 | Burke | Georgia | 13033 | 2631 | 65 |
1472711 | 1472711 | 2021-07-01 | Burke | Georgia | 13033 | 2631 | 65 |
1472898 | 1472898 | 2021-07-01 | Payette | Idaho | 16075 | 2631 | 38 |
1469465 | 1469465 | 2021-06-30 | Burke | Georgia | 13033 | 2631 | 65 |
1470980 | 1470980 | 2021-06-30 | Cherokee | North Carolina | 37039 | 2631 | 38 |
1448248 | 1448248 | 2021-06-23 | Anson | North Carolina | 37007 | 2631 | 56 |
1428239 | 1428239 | 2021-06-17 | Meeker | Minnesota | 27093 | 2631 | 42 |
1424994 | 1424994 | 2021-06-16 | Meeker | Minnesota | 27093 | 2631 | 42 |
1418213 | 1418213 | 2021-06-14 | Mercer | Kentucky | 21167 | 2631 | 54 |
1420114 | 1420114 | 2021-06-14 | Hopewell city | Virginia | 51670 | 2631 | 79 |
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);