ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
135 rows where cases = 4077 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Florida 16
- Georgia 14
- Missouri 8
- Oklahoma 8
- Minnesota 7
- Mississippi 7
- New York 7
- Pennsylvania 7
- Indiana 6
- Alabama 5
- Kentucky 5
- Texas 5
- Michigan 4
- North Carolina 3
- Virginia 3
- Wisconsin 3
- Arkansas 2
- Illinois 2
- Kansas 2
- Louisiana 2
- Ohio 2
- South Carolina 2
- Tennessee 2
- West Virginia 2
- Arizona 1
- Idaho 1
- Iowa 1
- Maryland 1
- Nebraska 1
- New Jersey 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2479171 | 2479171 | 2022-05-06 | Salinas | Puerto Rico | 72123 | 4077 | |
2444996 | 2444996 | 2022-04-26 | Vermillion | Indiana | 18165 | 4077 | 75 |
2441740 | 2441740 | 2022-04-25 | Vermillion | Indiana | 18165 | 4077 | 75 |
2438484 | 2438484 | 2022-04-24 | Vermillion | Indiana | 18165 | 4077 | 75 |
2435228 | 2435228 | 2022-04-23 | Vermillion | Indiana | 18165 | 4077 | 75 |
2431972 | 2431972 | 2022-04-22 | Vermillion | Indiana | 18165 | 4077 | 75 |
2337133 | 2337133 | 2022-03-24 | Calhoun | Florida | 12013 | 4077 | 97 |
2333879 | 2333879 | 2022-03-23 | Calhoun | Florida | 12013 | 4077 | 95 |
2330625 | 2330625 | 2022-03-22 | Calhoun | Florida | 12013 | 4077 | 95 |
2327373 | 2327373 | 2022-03-21 | Calhoun | Florida | 12013 | 4077 | 95 |
2329675 | 2329675 | 2022-03-21 | Aransas | Texas | 48007 | 4077 | 80 |
2324120 | 2324120 | 2022-03-20 | Calhoun | Florida | 12013 | 4077 | 95 |
2326423 | 2326423 | 2022-03-20 | Aransas | Texas | 48007 | 4077 | 80 |
2320866 | 2320866 | 2022-03-19 | Calhoun | Florida | 12013 | 4077 | 95 |
2317612 | 2317612 | 2022-03-18 | Calhoun | Florida | 12013 | 4077 | 95 |
2314359 | 2314359 | 2022-03-17 | Calhoun | Florida | 12013 | 4077 | 95 |
2311106 | 2311106 | 2022-03-16 | Calhoun | Florida | 12013 | 4077 | 95 |
2307853 | 2307853 | 2022-03-15 | Calhoun | Florida | 12013 | 4077 | 94 |
2304602 | 2304602 | 2022-03-14 | Calhoun | Florida | 12013 | 4077 | 94 |
2301350 | 2301350 | 2022-03-13 | Calhoun | Florida | 12013 | 4077 | 94 |
2298098 | 2298098 | 2022-03-12 | Calhoun | Florida | 12013 | 4077 | 94 |
2294846 | 2294846 | 2022-03-11 | Calhoun | Florida | 12013 | 4077 | 94 |
2268511 | 2268511 | 2022-03-03 | Clay | Alabama | 1027 | 4077 | 78 |
2257788 | 2257788 | 2022-02-27 | Fulton | Pennsylvania | 42057 | 4077 | 64 |
2254537 | 2254537 | 2022-02-26 | Fulton | Pennsylvania | 42057 | 4077 | 64 |
2224488 | 2224488 | 2022-02-17 | Benton | Missouri | 29015 | 4077 | 88 |
2218683 | 2218683 | 2022-02-15 | Murray | Oklahoma | 40099 | 4077 | 62 |
2215432 | 2215432 | 2022-02-14 | Murray | Oklahoma | 40099 | 4077 | 62 |
2212181 | 2212181 | 2022-02-13 | Murray | Oklahoma | 40099 | 4077 | 62 |
2208928 | 2208928 | 2022-02-12 | Murray | Oklahoma | 40099 | 4077 | 62 |
2205675 | 2205675 | 2022-02-11 | Murray | Oklahoma | 40099 | 4077 | 62 |
2202422 | 2202422 | 2022-02-10 | Murray | Oklahoma | 40099 | 4077 | 62 |
2199168 | 2199168 | 2022-02-09 | Murray | Oklahoma | 40099 | 4077 | 62 |
2172088 | 2172088 | 2022-02-01 | Jackson | Louisiana | 22049 | 4077 | 66 |
2157699 | 2157699 | 2022-01-27 | Prince Edward | Virginia | 51147 | 4077 | 54 |
2149268 | 2149268 | 2022-01-25 | Rockcastle | Kentucky | 21203 | 4077 | 49 |
2132402 | 2132402 | 2022-01-20 | Putnam | Georgia | 13237 | 4077 | 92 |
2131357 | 2131357 | 2022-01-19 | Gonzales | Texas | 48177 | 4077 | 92 |
2083691 | 2083691 | 2022-01-05 | Cassia | Idaho | 16031 | 4077 | 46 |
2063577 | 2063577 | 2021-12-29 | Vernon | Wisconsin | 55123 | 4077 | 74 |
2024515 | 2024515 | 2021-12-17 | Wyoming | West Virginia | 54109 | 4077 | 75 |
2019268 | 2019268 | 2021-12-16 | Plaquemines | Louisiana | 22075 | 4077 | 40 |
2013195 | 2013195 | 2021-12-14 | Randolph | Missouri | 29175 | 4077 | 81 |
1975082 | 1975082 | 2021-12-02 | Davison | South Dakota | 46035 | 4077 | 71 |
1905247 | 1905247 | 2021-11-11 | Barton | Kansas | 20009 | 4077 | 62 |
1901997 | 1901997 | 2021-11-10 | Barton | Kansas | 20009 | 4077 | 62 |
1886411 | 1886411 | 2021-11-05 | Miller | Missouri | 29131 | 4077 | 79 |
1824567 | 1824567 | 2021-10-17 | Leake | Mississippi | 28079 | 4077 | 87 |
1821318 | 1821318 | 2021-10-16 | Leake | Mississippi | 28079 | 4077 | 87 |
1818069 | 1818069 | 2021-10-15 | Leake | Mississippi | 28079 | 4077 | 87 |
1815427 | 1815427 | 2021-10-14 | Adams | Ohio | 39001 | 4077 | 83 |
1804109 | 1804109 | 2021-10-11 | Monroe | Georgia | 13207 | 4077 | 140 |
1800860 | 1800860 | 2021-10-10 | Monroe | Georgia | 13207 | 4077 | 140 |
1797611 | 1797611 | 2021-10-09 | Monroe | Georgia | 13207 | 4077 | 140 |
1794362 | 1794362 | 2021-10-08 | Monroe | Georgia | 13207 | 4077 | 140 |
1791141 | 1791141 | 2021-10-07 | Sumter | Georgia | 13261 | 4077 | 123 |
1769212 | 1769212 | 2021-09-30 | Carlton | Minnesota | 27017 | 4077 | 60 |
1760030 | 1760030 | 2021-09-27 | Washington | New York | 36115 | 4077 | 65 |
1753482 | 1753482 | 2021-09-25 | Allegany | New York | 36003 | 4077 | 93 |
1723871 | 1723871 | 2021-09-16 | Sunflower | Mississippi | 28133 | 4077 | 104 |
1719814 | 1719814 | 2021-09-15 | Perry | Illinois | 17145 | 4077 | 79 |
1722316 | 1722316 | 2021-09-15 | Green | Wisconsin | 55045 | 4077 | 26 |
1711704 | 1711704 | 2021-09-12 | McKean | Pennsylvania | 42083 | 4077 | 76 |
1693303 | 1693303 | 2021-09-07 | Johnson | Arkansas | 5071 | 4077 | 51 |
1677387 | 1677387 | 2021-09-02 | Lee | Georgia | 13177 | 4077 | 71 |
1674269 | 1674269 | 2021-09-01 | Bureau | Illinois | 17011 | 4077 | 99 |
1665816 | 1665816 | 2021-08-29 | Tioga | New York | 36107 | 4077 | 65 |
1561956 | 1561956 | 2021-07-28 | Scotland | North Carolina | 37165 | 4077 | 89 |
1538695 | 1538695 | 2021-07-21 | Lincoln | Mississippi | 28085 | 4077 | 115 |
1536547 | 1536547 | 2021-07-20 | Giles | Tennessee | 47055 | 4077 | 100 |
1531523 | 1531523 | 2021-07-19 | Steuben | Indiana | 18151 | 4077 | 62 |
1527995 | 1527995 | 2021-07-18 | Oconee | Georgia | 13219 | 4077 | 73 |
1524748 | 1524748 | 2021-07-17 | Oconee | Georgia | 13219 | 4077 | 73 |
1526565 | 1526565 | 2021-07-17 | Pike | Pennsylvania | 42103 | 4077 | 54 |
1521500 | 1521500 | 2021-07-16 | Oconee | Georgia | 13219 | 4077 | 73 |
1505886 | 1505886 | 2021-07-11 | Whitley | Kentucky | 21235 | 4077 | 62 |
1502640 | 1502640 | 2021-07-10 | Whitley | Kentucky | 21235 | 4077 | 62 |
1499394 | 1499394 | 2021-07-09 | Whitley | Kentucky | 21235 | 4077 | 62 |
1444475 | 1444475 | 2021-06-22 | Nobles | Minnesota | 27105 | 4077 | 50 |
1440262 | 1440262 | 2021-06-21 | Camden | Georgia | 13039 | 4077 | 38 |
1437015 | 1437015 | 2021-06-20 | Camden | Georgia | 13039 | 4077 | 38 |
1431441 | 1431441 | 2021-06-18 | Beltrami | Minnesota | 27007 | 4077 | 61 |
1431490 | 1431490 | 2021-06-18 | Nobles | Minnesota | 27105 | 4077 | 50 |
1399979 | 1399979 | 2021-06-08 | Venango | Pennsylvania | 42121 | 4077 | 97 |
1396734 | 1396734 | 2021-06-07 | Venango | Pennsylvania | 42121 | 4077 | 97 |
1393487 | 1393487 | 2021-06-06 | Venango | Pennsylvania | 42121 | 4077 | 97 |
1371755 | 1371755 | 2021-05-31 | Tallapoosa | Alabama | 1123 | 4077 | 153 |
1368509 | 1368509 | 2021-05-30 | Tallapoosa | Alabama | 1123 | 4077 | 153 |
1365263 | 1365263 | 2021-05-29 | Tallapoosa | Alabama | 1123 | 4077 | 153 |
1362017 | 1362017 | 2021-05-28 | Tallapoosa | Alabama | 1123 | 4077 | 153 |
1317880 | 1317880 | 2021-05-14 | Nobles | Minnesota | 27105 | 4077 | 48 |
1275807 | 1275807 | 2021-05-01 | Camden | Missouri | 29029 | 4077 | 87 |
1272560 | 1272560 | 2021-04-30 | Camden | Missouri | 29029 | 4077 | 87 |
1269118 | 1269118 | 2021-04-29 | Sanilac | Michigan | 26151 | 4077 | 103 |
1269289 | 1269289 | 2021-04-29 | Union | Mississippi | 28145 | 4077 | 76 |
1270666 | 1270666 | 2021-04-29 | Wharton | Texas | 48481 | 4077 | 114 |
1256086 | 1256086 | 2021-04-25 | Hillsdale | Michigan | 26059 | 4077 | 82 |
1252839 | 1252839 | 2021-04-24 | Hillsdale | Michigan | 26059 | 4077 | 82 |
1243723 | 1243723 | 2021-04-21 | Tompkins | New York | 36109 | 4077 | 49 |
1184945 | 1184945 | 2021-04-03 | Platte | Missouri | 29165 | 4077 | 45 |
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);