ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
144 rows where cases = 3722 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Virginia 14
- Kansas 10
- Minnesota 10
- Oklahoma 8
- Texas 8
- Alabama 7
- Arkansas 7
- Pennsylvania 7
- Indiana 6
- Wisconsin 6
- Michigan 5
- Ohio 5
- California 4
- Missouri 4
- Puerto Rico 4
- South Carolina 4
- West Virginia 4
- Nevada 3
- New Mexico 3
- New York 3
- Idaho 2
- Illinois 2
- Iowa 2
- Kentucky 2
- Maryland 2
- North Carolina 2
- Oregon 2
- Tennessee 2
- Florida 1
- Georgia 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2447206 | 2447206 | 2022-04-26 | King William | Virginia | 51101 | 3722 | 42 |
2430271 | 2430271 | 2022-04-21 | Aibonito | Puerto Rico | 72009 | 3722 | |
2401634 | 2401634 | 2022-04-12 | Manassas Park city | Virginia | 51685 | 3722 | 26 |
2398379 | 2398379 | 2022-04-11 | Manassas Park city | Virginia | 51685 | 3722 | 26 |
2327108 | 2327108 | 2022-03-21 | Washington | Alabama | 1129 | 3722 | 58 |
2323855 | 2323855 | 2022-03-20 | Washington | Alabama | 1129 | 3722 | 58 |
2325183 | 2325183 | 2022-03-20 | Renville | Minnesota | 27129 | 3722 | 56 |
2320601 | 2320601 | 2022-03-19 | Washington | Alabama | 1129 | 3722 | 58 |
2321929 | 2321929 | 2022-03-19 | Renville | Minnesota | 27129 | 3722 | 56 |
2317347 | 2317347 | 2022-03-18 | Washington | Alabama | 1129 | 3722 | 58 |
2318675 | 2318675 | 2022-03-18 | Renville | Minnesota | 27129 | 3722 | 56 |
2315422 | 2315422 | 2022-03-17 | Renville | Minnesota | 27129 | 3722 | 56 |
2311544 | 2311544 | 2022-03-16 | Pike | Indiana | 18125 | 3722 | 48 |
2308291 | 2308291 | 2022-03-15 | Pike | Indiana | 18125 | 3722 | 48 |
2266750 | 2266750 | 2022-03-02 | Bates | Missouri | 29013 | 3722 | 88 |
2212959 | 2212959 | 2022-02-13 | Goochland | Virginia | 51075 | 3722 | 41 |
2209706 | 2209706 | 2022-02-12 | Goochland | Virginia | 51075 | 3722 | 41 |
2206453 | 2206453 | 2022-02-11 | Goochland | Virginia | 51075 | 3722 | 41 |
2201237 | 2201237 | 2022-02-10 | Caldwell | Kentucky | 21033 | 3722 | 57 |
2203415 | 2203415 | 2022-02-10 | Marquette | Wisconsin | 55077 | 3722 | 48 |
2176903 | 2176903 | 2022-02-02 | Freestone | Texas | 48161 | 3722 | 80 |
2122864 | 2122864 | 2022-01-17 | Franklin | Indiana | 18047 | 3722 | 56 |
2115809 | 2115809 | 2022-01-15 | Sharp | Arkansas | 5135 | 3722 | 82 |
2108529 | 2108529 | 2022-01-12 | Burleson | Texas | 48051 | 3722 | 61 |
2057039 | 2057039 | 2021-12-27 | Green Lake | Wisconsin | 55047 | 3722 | 48 |
2053790 | 2053790 | 2021-12-26 | Green Lake | Wisconsin | 55047 | 3722 | 48 |
2050540 | 2050540 | 2021-12-25 | Green Lake | Wisconsin | 55047 | 3722 | 48 |
2047290 | 2047290 | 2021-12-24 | Green Lake | Wisconsin | 55047 | 3722 | 48 |
2024613 | 2024613 | 2021-12-18 | Barbour | Alabama | 1005 | 3722 | 81 |
2021362 | 2021362 | 2021-12-17 | Barbour | Alabama | 1005 | 3722 | 81 |
2004489 | 2004489 | 2021-12-11 | Austin | Texas | 48015 | 3722 | 56 |
1941466 | 1941466 | 2021-11-22 | Martin | Minnesota | 27091 | 3722 | 43 |
1922080 | 1922080 | 2021-11-16 | Tishomingo | Mississippi | 28141 | 3722 | 93 |
1877198 | 1877198 | 2021-11-02 | Holmes | Ohio | 39075 | 3722 | 126 |
1848894 | 1848894 | 2021-10-24 | Russell | Virginia | 51167 | 3722 | 59 |
1845644 | 1845644 | 2021-10-23 | Russell | Virginia | 51167 | 3722 | 59 |
1842394 | 1842394 | 2021-10-22 | Russell | Virginia | 51167 | 3722 | 59 |
1814369 | 1814369 | 2021-10-14 | Allen | Kentucky | 21003 | 3722 | 63 |
1816439 | 1816439 | 2021-10-14 | Island | Washington | 53029 | 3722 | 44 |
1808142 | 1808142 | 2021-10-12 | Houghton | Michigan | 26061 | 3722 | 54 |
1804891 | 1804891 | 2021-10-11 | Houghton | Michigan | 26061 | 3722 | 54 |
1806594 | 1806594 | 2021-10-11 | Gloucester | Virginia | 51073 | 3722 | 65 |
1801589 | 1801589 | 2021-10-10 | Queen Anne's | Maryland | 24035 | 3722 | 66 |
1803344 | 1803344 | 2021-10-10 | Gloucester | Virginia | 51073 | 3722 | 65 |
1797714 | 1797714 | 2021-10-09 | Payette | Idaho | 16075 | 3722 | 56 |
1800095 | 1800095 | 2021-10-09 | Gloucester | Virginia | 51073 | 3722 | 65 |
1796846 | 1796846 | 2021-10-08 | Gloucester | Virginia | 51073 | 3722 | 65 |
1740247 | 1740247 | 2021-09-21 | Washington | Missouri | 29221 | 3722 | 58 |
1737711 | 1737711 | 2021-09-20 | Tioga | Pennsylvania | 42117 | 3722 | 115 |
1725517 | 1725517 | 2021-09-16 | Mingo | West Virginia | 54059 | 3722 | 50 |
1722267 | 1722267 | 2021-09-15 | Mineral | West Virginia | 54057 | 3722 | 96 |
1710356 | 1710356 | 2021-09-12 | Miami | Kansas | 20121 | 3722 | 51 |
1707109 | 1707109 | 2021-09-11 | Miami | Kansas | 20121 | 3722 | 51 |
1703861 | 1703861 | 2021-09-10 | Miami | Kansas | 20121 | 3722 | 51 |
1698699 | 1698699 | 2021-09-08 | Greene | Pennsylvania | 42059 | 3722 | 44 |
1665737 | 1665737 | 2021-08-29 | Cibola | New Mexico | 35006 | 3722 | 130 |
1667067 | 1667067 | 2021-08-29 | Wayne | West Virginia | 54099 | 3722 | 48 |
1662489 | 1662489 | 2021-08-28 | Cibola | New Mexico | 35006 | 3722 | 130 |
1659241 | 1659241 | 2021-08-27 | Cibola | New Mexico | 35006 | 3722 | 130 |
1647798 | 1647798 | 2021-08-24 | Carroll | Arkansas | 5015 | 3722 | 56 |
1632782 | 1632782 | 2021-08-19 | Freeborn | Minnesota | 27047 | 3722 | 37 |
1613556 | 1613556 | 2021-08-13 | Warren | Missouri | 29219 | 3722 | 39 |
1611149 | 1611149 | 2021-08-12 | Marlboro | South Carolina | 45069 | 3722 | 61 |
1597479 | 1597479 | 2021-08-08 | Lyon | Nevada | 32019 | 3722 | 69 |
1594230 | 1594230 | 2021-08-07 | Lyon | Nevada | 32019 | 3722 | 69 |
1590981 | 1590981 | 2021-08-06 | Lyon | Nevada | 32019 | 3722 | 69 |
1579470 | 1579470 | 2021-08-03 | Clarke | Alabama | 1025 | 3722 | 63 |
1561882 | 1561882 | 2021-07-28 | Bladen | North Carolina | 37017 | 3722 | 55 |
1558896 | 1558896 | 2021-07-27 | Garvin | Oklahoma | 40049 | 3722 | 79 |
1559003 | 1559003 | 2021-07-27 | Clinton | Pennsylvania | 42035 | 3722 | 68 |
1555649 | 1555649 | 2021-07-26 | Garvin | Oklahoma | 40049 | 3722 | 79 |
1555756 | 1555756 | 2021-07-26 | Clinton | Pennsylvania | 42035 | 3722 | 68 |
1552402 | 1552402 | 2021-07-25 | Garvin | Oklahoma | 40049 | 3722 | 79 |
1549155 | 1549155 | 2021-07-24 | Garvin | Oklahoma | 40049 | 3722 | 79 |
1545908 | 1545908 | 2021-07-23 | Garvin | Oklahoma | 40049 | 3722 | 79 |
1542661 | 1542661 | 2021-07-22 | Garvin | Oklahoma | 40049 | 3722 | 79 |
1538465 | 1538465 | 2021-07-21 | Worcester | Maryland | 24047 | 3722 | 106 |
1539137 | 1539137 | 2021-07-21 | Warren | New York | 36113 | 3722 | 59 |
1539413 | 1539413 | 2021-07-21 | Garvin | Oklahoma | 40049 | 3722 | 79 |
1527675 | 1527675 | 2021-07-18 | St. Francis | Arkansas | 5123 | 3722 | 45 |
1524428 | 1524428 | 2021-07-17 | St. Francis | Arkansas | 5123 | 3722 | 45 |
1521180 | 1521180 | 2021-07-16 | St. Francis | Arkansas | 5123 | 3722 | 45 |
1497565 | 1497565 | 2021-07-08 | Carroll | Tennessee | 47017 | 3722 | 83 |
1494318 | 1494318 | 2021-07-07 | Carroll | Tennessee | 47017 | 3722 | 83 |
1477100 | 1477100 | 2021-07-02 | Laclede | Missouri | 29105 | 3722 | 75 |
1423811 | 1423811 | 2021-06-16 | Amador | California | 6005 | 3722 | 47 |
1417720 | 1417720 | 2021-06-14 | Nez Perce | Idaho | 16069 | 3722 | 55 |
1344781 | 1344781 | 2021-05-22 | McKean | Pennsylvania | 42083 | 3722 | 71 |
1341533 | 1341533 | 2021-05-21 | McKean | Pennsylvania | 42083 | 3722 | 71 |
1329087 | 1329087 | 2021-05-17 | Titus | Texas | 48449 | 3722 | 84 |
1325841 | 1325841 | 2021-05-16 | Titus | Texas | 48449 | 3722 | 84 |
1310752 | 1310752 | 2021-05-12 | Knox | Indiana | 18083 | 3722 | 90 |
1309014 | 1309014 | 2021-05-11 | Polk | Oregon | 41053 | 3722 | 52 |
1302342 | 1302342 | 2021-05-09 | Clinton | Ohio | 39027 | 3722 | 63 |
1296446 | 1296446 | 2021-05-07 | Cooke | Texas | 48097 | 3722 | 72 |
1288134 | 1288134 | 2021-05-05 | Lee | Iowa | 19111 | 3722 | 55 |
1259447 | 1259447 | 2021-04-26 | Polk | Minnesota | 27119 | 3722 | 67 |
1260385 | 1260385 | 2021-04-26 | Venango | Pennsylvania | 42121 | 3722 | 91 |
1255012 | 1255012 | 2021-04-25 | Humboldt | California | 6023 | 3722 | 38 |
1256200 | 1256200 | 2021-04-25 | Polk | Minnesota | 27119 | 3722 | 67 |
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);