ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
128 rows where cases = 3957 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 16
- Kansas 10
- Mississippi 8
- Georgia 7
- Oklahoma 7
- Virginia 7
- Alabama 6
- Michigan 6
- Missouri 6
- Ohio 5
- South Carolina 5
- Wisconsin 5
- Minnesota 4
- Arkansas 3
- Illinois 3
- Kentucky 3
- Louisiana 3
- North Carolina 3
- Pennsylvania 3
- Indiana 2
- New York 2
- North Dakota 2
- Alaska 1
- Arizona 1
- Florida 1
- Idaho 1
- Iowa 1
- Montana 1
- Nebraska 1
- Puerto Rico 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499241 | 2499241 | 2022-05-12 | Lamoille | Vermont | 50015 | 3957 | 17 |
2486501 | 2486501 | 2022-05-08 | Richland | Wisconsin | 55103 | 3957 | 48 |
2483243 | 2483243 | 2022-05-07 | Richland | Wisconsin | 55103 | 3957 | 48 |
2479985 | 2479985 | 2022-05-06 | Richland | Wisconsin | 55103 | 3957 | 48 |
2476395 | 2476395 | 2022-05-05 | Young | Texas | 48503 | 3957 | 94 |
2468392 | 2468392 | 2022-05-03 | Redwood | Minnesota | 27127 | 3957 | 53 |
2468634 | 2468634 | 2022-05-03 | Glacier | Montana | 30035 | 3957 | 74 |
2428826 | 2428826 | 2022-04-21 | Allen | Kansas | 20001 | 3957 | 53 |
2425570 | 2425570 | 2022-04-20 | Allen | Kansas | 20001 | 3957 | 53 |
2422314 | 2422314 | 2022-04-19 | Allen | Kansas | 20001 | 3957 | 53 |
2419058 | 2419058 | 2022-04-18 | Allen | Kansas | 20001 | 3957 | 53 |
2415802 | 2415802 | 2022-04-17 | Allen | Kansas | 20001 | 3957 | 53 |
2412546 | 2412546 | 2022-04-16 | Allen | Kansas | 20001 | 3957 | 53 |
2409290 | 2409290 | 2022-04-15 | Allen | Kansas | 20001 | 3957 | 53 |
2385758 | 2385758 | 2022-04-08 | Madison | Arkansas | 5087 | 3957 | 61 |
2382503 | 2382503 | 2022-04-07 | Madison | Arkansas | 5087 | 3957 | 61 |
2340027 | 2340027 | 2022-03-24 | Washburn | Wisconsin | 55129 | 3957 | 46 |
2336774 | 2336774 | 2022-03-23 | Washburn | Wisconsin | 55129 | 3957 | 46 |
2330766 | 2330766 | 2022-03-22 | Jeff Davis | Georgia | 13161 | 3957 | 70 |
2235366 | 2235366 | 2022-02-20 | Aransas | Texas | 48007 | 3957 | 76 |
2224553 | 2224553 | 2022-02-17 | Morgan | Missouri | 29141 | 3957 | 100 |
2221302 | 2221302 | 2022-02-16 | Morgan | Missouri | 29141 | 3957 | 100 |
2219125 | 2219125 | 2022-02-15 | Bosque | Texas | 48035 | 3957 | 65 |
2215757 | 2215757 | 2022-02-14 | Union | South Dakota | 46127 | 3957 | 49 |
2187216 | 2187216 | 2022-02-06 | Clay | Alabama | 1027 | 3957 | 72 |
2183963 | 2183963 | 2022-02-05 | Clay | Alabama | 1027 | 3957 | 72 |
2168758 | 2168758 | 2022-01-31 | Lewis | Kentucky | 21135 | 3957 | 72 |
2165682 | 2165682 | 2022-01-30 | Antrim | Michigan | 26009 | 3957 | 53 |
2162427 | 2162427 | 2022-01-29 | Antrim | Michigan | 26009 | 3957 | 53 |
2159172 | 2159172 | 2022-01-28 | Antrim | Michigan | 26009 | 3957 | 53 |
2147324 | 2147324 | 2022-01-24 | Yabucoa | Puerto Rico | 72151 | 3957 | |
2076409 | 2076409 | 2022-01-02 | Staunton city | Virginia | 51790 | 3957 | 87 |
2073158 | 2073158 | 2022-01-01 | Staunton city | Virginia | 51790 | 3957 | 87 |
2069907 | 2069907 | 2021-12-31 | Staunton city | Virginia | 51790 | 3957 | 87 |
2058458 | 2058458 | 2021-12-28 | Dodge | Minnesota | 27039 | 3957 | 13 |
2038235 | 2038235 | 2021-12-22 | Douglas | Illinois | 17041 | 3957 | 44 |
1967569 | 1967569 | 2021-11-30 | Newton | Mississippi | 28101 | 3957 | 82 |
1964317 | 1964317 | 2021-11-29 | Newton | Mississippi | 28101 | 3957 | 81 |
1940668 | 1940668 | 2021-11-22 | Cassia | Idaho | 16031 | 3957 | 42 |
1931845 | 1931845 | 2021-11-19 | Audrain | Missouri | 29007 | 3957 | 79 |
1923037 | 1923037 | 2021-11-16 | Jasper | South Carolina | 45053 | 3957 | 81 |
1919788 | 1919788 | 2021-11-15 | Jasper | South Carolina | 45053 | 3957 | 81 |
1906789 | 1906789 | 2021-11-11 | Jasper | South Carolina | 45053 | 3957 | 81 |
1903193 | 1903193 | 2021-11-10 | Henry | Ohio | 39069 | 3957 | 73 |
1903540 | 1903540 | 2021-11-10 | Jasper | South Carolina | 45053 | 3957 | 81 |
1883207 | 1883207 | 2021-11-04 | Washington | Missouri | 29221 | 3957 | 67 |
1814700 | 1814700 | 2021-10-14 | Brown | Minnesota | 27015 | 3957 | 45 |
1806363 | 1806363 | 2021-10-11 | Jasper | Texas | 48241 | 3957 | 144 |
1803113 | 1803113 | 2021-10-10 | Jasper | Texas | 48241 | 3957 | 144 |
1799864 | 1799864 | 2021-10-09 | Jasper | Texas | 48241 | 3957 | 144 |
1796615 | 1796615 | 2021-10-08 | Jasper | Texas | 48241 | 3957 | 142 |
1793366 | 1793366 | 2021-10-07 | Jasper | Texas | 48241 | 3957 | 142 |
1769173 | 1769173 | 2021-09-30 | Mecosta | Michigan | 26107 | 3957 | 41 |
1765924 | 1765924 | 2021-09-29 | Mecosta | Michigan | 26107 | 3957 | 41 |
1756310 | 1756310 | 2021-09-26 | Coahoma | Mississippi | 28027 | 3957 | 100 |
1753062 | 1753062 | 2021-09-25 | Coahoma | Mississippi | 28027 | 3957 | 100 |
1749814 | 1749814 | 2021-09-24 | Coahoma | Mississippi | 28027 | 3957 | 100 |
1690359 | 1690359 | 2021-09-06 | Gilmer | Georgia | 13123 | 3957 | 98 |
1687109 | 1687109 | 2021-09-05 | Gilmer | Georgia | 13123 | 3957 | 98 |
1683859 | 1683859 | 2021-09-04 | Gilmer | Georgia | 13123 | 3957 | 98 |
1680608 | 1680608 | 2021-09-03 | Gilmer | Georgia | 13123 | 3957 | 98 |
1675158 | 1675158 | 2021-09-01 | Yazoo | Mississippi | 28163 | 3957 | 83 |
1654050 | 1654050 | 2021-08-25 | Marshall | West Virginia | 54051 | 3957 | 83 |
1628974 | 1628974 | 2021-08-18 | Wabash | Indiana | 18169 | 3957 | 84 |
1611510 | 1611510 | 2021-08-12 | Polk | Texas | 48373 | 3957 | 126 |
1608262 | 1608262 | 2021-08-11 | Polk | Texas | 48373 | 3957 | 125 |
1605013 | 1605013 | 2021-08-10 | Polk | Texas | 48373 | 3957 | 125 |
1599971 | 1599971 | 2021-08-09 | Calloway | Kentucky | 21035 | 3957 | 51 |
1601764 | 1601764 | 2021-08-09 | Polk | Texas | 48373 | 3957 | 125 |
1583753 | 1583753 | 2021-08-04 | Greenup | Kentucky | 21089 | 3957 | 63 |
1551788 | 1551788 | 2021-07-25 | Marion | Missouri | 29127 | 3957 | 53 |
1552084 | 1552084 | 2021-07-25 | Cortland | New York | 36023 | 3957 | 64 |
1519190 | 1519190 | 2021-07-15 | Hancock | Mississippi | 28045 | 3957 | 88 |
1508754 | 1508754 | 2021-07-12 | Jasper | Indiana | 18073 | 3957 | 57 |
1493364 | 1493364 | 2021-07-07 | Polk | Missouri | 29167 | 3957 | 42 |
1481814 | 1481814 | 2021-07-03 | Petersburg city | Virginia | 51730 | 3957 | 87 |
1473448 | 1473448 | 2021-07-01 | Iberville | Louisiana | 22047 | 3957 | 101 |
1459095 | 1459095 | 2021-06-26 | Petersburg city | Virginia | 51730 | 3957 | 87 |
1382083 | 1382083 | 2021-06-03 | Logan | Illinois | 17107 | 3957 | 75 |
1342502 | 1342502 | 2021-05-22 | Escambia | Alabama | 1053 | 3957 | 77 |
1328563 | 1328563 | 2021-05-17 | Venango | Pennsylvania | 42121 | 3957 | 93 |
1303925 | 1303925 | 2021-05-10 | Camden | Georgia | 13039 | 3957 | 36 |
1303092 | 1303092 | 2021-05-09 | Rusk | Texas | 48401 | 3957 | 107 |
1299845 | 1299845 | 2021-05-08 | Rusk | Texas | 48401 | 3957 | 107 |
1275279 | 1275279 | 2021-05-01 | Seward | Kansas | 20175 | 3957 | 41 |
1272032 | 1272032 | 2021-04-30 | Seward | Kansas | 20175 | 3957 | 41 |
1268785 | 1268785 | 2021-04-29 | Seward | Kansas | 20175 | 3957 | 41 |
1263465 | 1263465 | 2021-04-27 | Caddo | Oklahoma | 40015 | 3957 | 87 |
1260218 | 1260218 | 2021-04-26 | Caddo | Oklahoma | 40015 | 3957 | 87 |
1256971 | 1256971 | 2021-04-25 | Caddo | Oklahoma | 40015 | 3957 | 87 |
1253724 | 1253724 | 2021-04-24 | Caddo | Oklahoma | 40015 | 3957 | 87 |
1250477 | 1250477 | 2021-04-23 | Caddo | Oklahoma | 40015 | 3957 | 87 |
1247230 | 1247230 | 2021-04-22 | Caddo | Oklahoma | 40015 | 3957 | 87 |
1243983 | 1243983 | 2021-04-21 | Caddo | Oklahoma | 40015 | 3957 | 87 |
1241134 | 1241134 | 2021-04-20 | Giles | Tennessee | 47055 | 3957 | 99 |
1241548 | 1241548 | 2021-04-20 | Franklin | Virginia | 51067 | 3957 | 74 |
1204233 | 1204233 | 2021-04-09 | Nobles | Minnesota | 27105 | 3957 | 47 |
1200770 | 1200770 | 2021-04-08 | St. Bernard | Louisiana | 22087 | 3957 | 48 |
1178335 | 1178335 | 2021-04-01 | Neshoba | Mississippi | 28099 | 3957 | 175 |
1146459 | 1146459 | 2021-03-22 | Ashland | Ohio | 39005 | 3957 | 85 |
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);