ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
139 rows where cases = 3566 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Ohio 9
- Texas 9
- Illinois 8
- Missouri 7
- Kentucky 6
- Louisiana 6
- Tennessee 6
- Georgia 5
- Indiana 5
- Nebraska 5
- New Mexico 5
- South Dakota 5
- West Virginia 5
- Alabama 4
- Alaska 4
- Minnesota 4
- New York 4
- Washington 4
- Arizona 3
- Michigan 3
- North Carolina 3
- North Dakota 3
- Oregon 3
- Wyoming 3
- Arkansas 2
- California 2
- Colorado 2
- Mississippi 2
- Pennsylvania 2
- Puerto Rico 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499589 | 2499589 | 2022-05-13 | Cleburne | Alabama | 1029 | 3566 | 69 |
2473422 | 2473422 | 2022-05-04 | Buffalo | Wisconsin | 55011 | 3566 | 12 |
2419546 | 2419546 | 2022-04-18 | Pennington | Minnesota | 27113 | 3566 | 41 |
2413544 | 2413544 | 2022-04-16 | Schuyler | New York | 36097 | 3566 | 25 |
2404129 | 2404129 | 2022-04-13 | Hood River | Oregon | 41027 | 3566 | 43 |
2312338 | 2312338 | 2022-03-16 | Madison | Missouri | 29123 | 3566 | 56 |
2305833 | 2305833 | 2022-03-14 | Madison | Missouri | 29123 | 3566 | 52 |
2279961 | 2279961 | 2022-03-06 | Gage | Nebraska | 31067 | 3566 | 37 |
2276708 | 2276708 | 2022-03-05 | Gage | Nebraska | 31067 | 3566 | 37 |
2273455 | 2273455 | 2022-03-04 | Gage | Nebraska | 31067 | 3566 | 37 |
2266950 | 2266950 | 2022-03-02 | Gage | Nebraska | 31067 | 3566 | 37 |
2258728 | 2258728 | 2022-02-27 | Goshen | Wyoming | 56015 | 3566 | 54 |
2255477 | 2255477 | 2022-02-26 | Goshen | Wyoming | 56015 | 3566 | 54 |
2252226 | 2252226 | 2022-02-25 | Goshen | Wyoming | 56015 | 3566 | 54 |
2247229 | 2247229 | 2022-02-24 | Walthall | Mississippi | 28147 | 3566 | 78 |
2248619 | 2248619 | 2022-02-24 | Zapata | Texas | 48505 | 3566 | 52 |
2241497 | 2241497 | 2022-02-22 | Tillamook | Oregon | 41057 | 3566 | 57 |
2218856 | 2218856 | 2022-02-15 | Lares | Puerto Rico | 72081 | 3566 | |
2188553 | 2188553 | 2022-02-06 | Faribault | Minnesota | 27043 | 3566 | 46 |
2185300 | 2185300 | 2022-02-05 | Faribault | Minnesota | 27043 | 3566 | 46 |
2182048 | 2182048 | 2022-02-04 | Faribault | Minnesota | 27043 | 3566 | 46 |
2183811 | 2183811 | 2022-02-04 | Grant | West Virginia | 54023 | 3566 | 51 |
2145580 | 2145580 | 2022-01-24 | Mercer | Illinois | 17131 | 3566 | 39 |
2129313 | 2129313 | 2022-01-19 | Moultrie | Illinois | 17139 | 3566 | 48 |
2083170 | 2083170 | 2022-01-05 | Pickens | Alabama | 1107 | 3566 | 91 |
2079186 | 2079186 | 2022-01-03 | Humphreys | Tennessee | 47085 | 3566 | 59 |
2061968 | 2061968 | 2021-12-29 | Vernon | Missouri | 29217 | 3566 | 87 |
2034465 | 2034465 | 2021-12-21 | La Paz | Arizona | 4012 | 3566 | 105 |
2037483 | 2037483 | 2021-12-21 | Lewis | West Virginia | 54041 | 3566 | 63 |
2031215 | 2031215 | 2021-12-20 | La Paz | Arizona | 4012 | 3566 | 105 |
1971886 | 1971886 | 2021-12-01 | Bledsoe | Tennessee | 47007 | 3566 | 22 |
1960650 | 1960650 | 2021-11-28 | Harrison | Kentucky | 21097 | 3566 | 48 |
1957399 | 1957399 | 2021-11-27 | Harrison | Kentucky | 21097 | 3566 | 48 |
1954148 | 1954148 | 2021-11-26 | Harrison | Kentucky | 21097 | 3566 | 48 |
1950897 | 1950897 | 2021-11-25 | Harrison | Kentucky | 21097 | 3566 | 48 |
1947646 | 1947646 | 2021-11-24 | Harrison | Kentucky | 21097 | 3566 | 48 |
1878811 | 1878811 | 2021-11-03 | Hart | Georgia | 13147 | 3566 | 69 |
1836110 | 1836110 | 2021-10-21 | Barbour | Alabama | 1005 | 3566 | 76 |
1826437 | 1826437 | 2021-10-18 | Juneau City and Borough | Alaska | 2110 | 3566 | 7 |
1823188 | 1823188 | 2021-10-17 | Juneau City and Borough | Alaska | 2110 | 3566 | 7 |
1824419 | 1824419 | 2021-10-17 | Oceana | Michigan | 26127 | 3566 | 69 |
1819939 | 1819939 | 2021-10-16 | Juneau City and Borough | Alaska | 2110 | 3566 | 7 |
1821170 | 1821170 | 2021-10-16 | Oceana | Michigan | 26127 | 3566 | 69 |
1816690 | 1816690 | 2021-10-15 | Juneau City and Borough | Alaska | 2110 | 3566 | 7 |
1817921 | 1817921 | 2021-10-15 | Oceana | Michigan | 26127 | 3566 | 69 |
1818710 | 1818710 | 2021-10-15 | Henry | Ohio | 39069 | 3566 | 71 |
1812260 | 1812260 | 2021-10-13 | Van Wert | Ohio | 39161 | 3566 | 74 |
1790882 | 1790882 | 2021-10-07 | Delta | Colorado | 8029 | 3566 | 79 |
1787800 | 1787800 | 2021-10-06 | Cook | Georgia | 13075 | 3566 | 57 |
1785249 | 1785249 | 2021-10-05 | Assumption | Louisiana | 22007 | 3566 | 57 |
1786823 | 1786823 | 2021-10-05 | Fayette | Texas | 48149 | 3566 | 88 |
1778198 | 1778198 | 2021-10-03 | Cassia | Idaho | 16031 | 3566 | 31 |
1763971 | 1763971 | 2021-09-28 | Morgan | Tennessee | 47129 | 3566 | 44 |
1755545 | 1755545 | 2021-09-26 | McDonough | Illinois | 17109 | 3566 | 68 |
1756969 | 1756969 | 2021-09-26 | Gallia | Ohio | 39053 | 3566 | 58 |
1757360 | 1757360 | 2021-09-26 | Davison | South Dakota | 46035 | 3566 | 69 |
1752297 | 1752297 | 2021-09-25 | McDonough | Illinois | 17109 | 3566 | 68 |
1754112 | 1754112 | 2021-09-25 | Davison | South Dakota | 46035 | 3566 | 69 |
1749048 | 1749048 | 2021-09-24 | McDonough | Illinois | 17109 | 3566 | 68 |
1750864 | 1750864 | 2021-09-24 | Davison | South Dakota | 46035 | 3566 | 69 |
1740731 | 1740731 | 2021-09-21 | Hardin | Ohio | 39065 | 3566 | 69 |
1727520 | 1727520 | 2021-09-17 | Orleans | New York | 36073 | 3566 | 83 |
1691499 | 1691499 | 2021-09-06 | Saline | Missouri | 29195 | 3566 | 43 |
1680307 | 1680307 | 2021-09-03 | Lincoln | Arkansas | 5079 | 3566 | 55 |
1674289 | 1674289 | 2021-09-01 | Fayette | Illinois | 17051 | 3566 | 59 |
1657454 | 1657454 | 2021-08-27 | Geneva | Alabama | 1061 | 3566 | 90 |
1657163 | 1657163 | 2021-08-26 | Isle of Wight | Virginia | 51093 | 3566 | 71 |
1607523 | 1607523 | 2021-08-11 | Champaign | Ohio | 39021 | 3566 | 60 |
1602031 | 1602031 | 2021-08-09 | Kittitas | Washington | 53037 | 3566 | 38 |
1558869 | 1558869 | 2021-07-27 | Williams | Ohio | 39171 | 3566 | 78 |
1555525 | 1555525 | 2021-07-26 | Stutsman | North Dakota | 38093 | 3566 | 82 |
1552278 | 1552278 | 2021-07-25 | Stutsman | North Dakota | 38093 | 3566 | 82 |
1549031 | 1549031 | 2021-07-24 | Stutsman | North Dakota | 38093 | 3566 | 82 |
1537943 | 1537943 | 2021-07-21 | Adams | Indiana | 18001 | 3566 | 57 |
1530604 | 1530604 | 2021-07-18 | Fayette | West Virginia | 54019 | 3566 | 80 |
1527357 | 1527357 | 2021-07-17 | Fayette | West Virginia | 54019 | 3566 | 80 |
1524110 | 1524110 | 2021-07-16 | Fayette | West Virginia | 54019 | 3566 | 80 |
1517360 | 1517360 | 2021-07-14 | Upshur | Texas | 48459 | 3566 | 77 |
1487104 | 1487104 | 2021-07-05 | Cibola | New Mexico | 35006 | 3566 | 125 |
1483858 | 1483858 | 2021-07-04 | Cibola | New Mexico | 35006 | 3566 | 125 |
1484378 | 1484378 | 2021-07-04 | Arecibo | Puerto Rico | 72013 | 3566 | |
1480612 | 1480612 | 2021-07-03 | Cibola | New Mexico | 35006 | 3566 | 125 |
1477365 | 1477365 | 2021-07-02 | Cibola | New Mexico | 35006 | 3566 | 125 |
1474119 | 1474119 | 2021-07-01 | Cibola | New Mexico | 35006 | 3566 | 125 |
1449790 | 1449790 | 2021-06-24 | Lake | California | 6033 | 3566 | 53 |
1438158 | 1438158 | 2021-06-20 | Lawrence | Missouri | 29109 | 3566 | 87 |
1336769 | 1336769 | 2021-05-20 | Wabash | Indiana | 18169 | 3566 | 81 |
1285082 | 1285082 | 2021-05-04 | Greenup | Kentucky | 21089 | 3566 | 59 |
1269413 | 1269413 | 2021-04-29 | Webster | Missouri | 29225 | 3566 | 53 |
1252425 | 1252425 | 2021-04-24 | Marion | Iowa | 19125 | 3566 | 75 |
1248498 | 1248498 | 2021-04-23 | St. Francis | Arkansas | 5123 | 3566 | 42 |
1242231 | 1242231 | 2021-04-21 | Bryan | Georgia | 13029 | 3566 | 37 |
1221630 | 1221630 | 2021-04-14 | Carroll | Tennessee | 47017 | 3566 | 82 |
1201680 | 1201680 | 2021-04-08 | Clinton | Ohio | 39027 | 3566 | 59 |
1185688 | 1185688 | 2021-04-03 | Venango | Pennsylvania | 42121 | 3566 | 90 |
1116345 | 1116345 | 2021-03-13 | St. John the Baptist | Louisiana | 22095 | 3566 | 134 |
1113099 | 1113099 | 2021-03-12 | St. John the Baptist | Louisiana | 22095 | 3566 | 134 |
1105088 | 1105088 | 2021-03-09 | Sanpete | Utah | 49039 | 3566 | 19 |
1075055 | 1075055 | 2021-02-28 | Crawford | Ohio | 39033 | 3566 | 96 |
1070477 | 1070477 | 2021-02-27 | Knox | Indiana | 18083 | 3566 | 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);