ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
122 rows where cases = 4615 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 30
- Georgia 13
- Ohio 11
- Wyoming 11
- Texas 10
- Minnesota 7
- Missouri 7
- Kentucky 6
- Louisiana 6
- Mississippi 6
- Wisconsin 5
- Illinois 4
- Virginia 4
- Arkansas 3
- California 3
- Indiana 3
- New Hampshire 3
- Iowa 2
- North Carolina 2
- South Carolina 2
- Tennessee 2
- Washington 2
- West Virginia 2
- Alabama 1
- Colorado 1
- Michigan 1
- New York 1
- Oklahoma 1
- Oregon 1
- Pennsylvania 1
- Utah 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2474869 | 2474869 | 2022-05-05 | Houston | Minnesota | 27055 | 4615 | 18 |
2425282 | 2425282 | 2022-04-20 | Cass | Illinois | 17017 | 4615 | 44 |
2404001 | 2404001 | 2022-04-13 | Meigs | Ohio | 39105 | 4615 | 87 |
2400746 | 2400746 | 2022-04-12 | Meigs | Ohio | 39105 | 4615 | 87 |
2397491 | 2397491 | 2022-04-11 | Meigs | Ohio | 39105 | 4615 | 87 |
2394236 | 2394236 | 2022-04-10 | Meigs | Ohio | 39105 | 4615 | 87 |
2390980 | 2390980 | 2022-04-09 | Meigs | Ohio | 39105 | 4615 | 87 |
2387724 | 2387724 | 2022-04-08 | Meigs | Ohio | 39105 | 4615 | 87 |
2384469 | 2384469 | 2022-04-07 | Meigs | Ohio | 39105 | 4615 | 87 |
2385365 | 2385365 | 2022-04-07 | New Kent | Virginia | 51127 | 4615 | 32 |
2385584 | 2385584 | 2022-04-07 | Carbon | Wyoming | 56007 | 4615 | 52 |
2381919 | 2381919 | 2022-04-06 | Reeves | Texas | 48389 | 4615 | 74 |
2382329 | 2382329 | 2022-04-06 | Carbon | Wyoming | 56007 | 4615 | 52 |
2378664 | 2378664 | 2022-04-05 | Reeves | Texas | 48389 | 4615 | 74 |
2379074 | 2379074 | 2022-04-05 | Carbon | Wyoming | 56007 | 4615 | 52 |
2375820 | 2375820 | 2022-04-04 | Carbon | Wyoming | 56007 | 4615 | 52 |
2372568 | 2372568 | 2022-04-03 | Carbon | Wyoming | 56007 | 4615 | 52 |
2369315 | 2369315 | 2022-04-02 | Carbon | Wyoming | 56007 | 4615 | 52 |
2366062 | 2366062 | 2022-04-01 | Carbon | Wyoming | 56007 | 4615 | 52 |
2330201 | 2330201 | 2022-03-21 | Adams | Wisconsin | 55001 | 4615 | 57 |
2306959 | 2306959 | 2022-03-14 | Deaf Smith | Texas | 48117 | 4615 | 111 |
2303708 | 2303708 | 2022-03-13 | Deaf Smith | Texas | 48117 | 4615 | 111 |
2300456 | 2300456 | 2022-03-12 | Deaf Smith | Texas | 48117 | 4615 | 111 |
2236753 | 2236753 | 2022-02-21 | Perry | Indiana | 18123 | 4615 | 67 |
2220282 | 2220282 | 2022-02-16 | Worth | Georgia | 13321 | 4615 | 105 |
2216786 | 2216786 | 2022-02-15 | Teller | Colorado | 8119 | 4615 | 55 |
2215181 | 2215181 | 2022-02-14 | Hertford | North Carolina | 37091 | 4615 | 80 |
2193489 | 2193489 | 2022-02-07 | Radford city | Virginia | 51750 | 4615 | 42 |
2188285 | 2188285 | 2022-02-06 | McCreary | Kentucky | 21147 | 4615 | 69 |
2185032 | 2185032 | 2022-02-05 | McCreary | Kentucky | 21147 | 4615 | 69 |
2181780 | 2181780 | 2022-02-04 | McCreary | Kentucky | 21147 | 4615 | 69 |
2174366 | 2174366 | 2022-02-02 | Randolph | Arkansas | 5121 | 4615 | 73 |
2174974 | 2174974 | 2022-02-02 | Starke | Indiana | 18149 | 4615 | 92 |
2157888 | 2157888 | 2022-01-27 | Taylor | Wisconsin | 55119 | 4615 | 63 |
2151817 | 2151817 | 2022-01-26 | Berrien | Georgia | 13019 | 4615 | 72 |
2123261 | 2123261 | 2022-01-17 | Assumption | Louisiana | 22007 | 4615 | 57 |
2120009 | 2120009 | 2022-01-16 | Assumption | Louisiana | 22007 | 4615 | 57 |
2116757 | 2116757 | 2022-01-15 | Assumption | Louisiana | 22007 | 4615 | 57 |
2113506 | 2113506 | 2022-01-14 | Assumption | Louisiana | 22007 | 4615 | 57 |
2109921 | 2109921 | 2022-01-13 | Washington | Indiana | 18175 | 4615 | 67 |
2107950 | 2107950 | 2022-01-12 | Carroll | Ohio | 39019 | 4615 | 98 |
2100877 | 2100877 | 2022-01-10 | Audrain | Missouri | 29007 | 4615 | 89 |
2057030 | 2057030 | 2021-12-27 | Door | Wisconsin | 55029 | 4615 | 49 |
2052203 | 2052203 | 2021-12-26 | Saline | Missouri | 29195 | 4615 | 85 |
2048953 | 2048953 | 2021-12-25 | Saline | Missouri | 29195 | 4615 | 85 |
2045703 | 2045703 | 2021-12-24 | Saline | Missouri | 29195 | 4615 | 85 |
2042453 | 2042453 | 2021-12-23 | Saline | Missouri | 29195 | 4615 | 85 |
2044031 | 2044031 | 2021-12-23 | Door | Wisconsin | 55029 | 4615 | 49 |
2035527 | 2035527 | 2021-12-21 | Sabine | Louisiana | 22085 | 4615 | 96 |
2016338 | 2016338 | 2021-12-15 | Simpson | Mississippi | 28127 | 4615 | 117 |
1996784 | 1996784 | 2021-12-09 | Copiah | Mississippi | 28029 | 4615 | 95 |
1837957 | 1837957 | 2021-10-21 | Allegany | New York | 36003 | 4615 | 97 |
1804095 | 1804095 | 2021-10-11 | Lee | Georgia | 13177 | 4615 | 78 |
1804152 | 1804152 | 2021-10-11 | Unknown | Georgia | 4615 | 8 | |
1800846 | 1800846 | 2021-10-10 | Lee | Georgia | 13177 | 4615 | 78 |
1800903 | 1800903 | 2021-10-10 | Unknown | Georgia | 4615 | 8 | |
1801842 | 1801842 | 2021-10-10 | Prentiss | Mississippi | 28117 | 4615 | 81 |
1797597 | 1797597 | 2021-10-09 | Lee | Georgia | 13177 | 4615 | 78 |
1797654 | 1797654 | 2021-10-09 | Unknown | Georgia | 4615 | 8 | |
1798593 | 1798593 | 2021-10-09 | Prentiss | Mississippi | 28117 | 4615 | 81 |
1794348 | 1794348 | 2021-10-08 | Lee | Georgia | 13177 | 4615 | 78 |
1794405 | 1794405 | 2021-10-08 | Unknown | Georgia | 4615 | 8 | |
1795344 | 1795344 | 2021-10-08 | Prentiss | Mississippi | 28117 | 4615 | 81 |
1796981 | 1796981 | 2021-10-08 | Greenbrier | West Virginia | 54025 | 4615 | 83 |
1791157 | 1791157 | 2021-10-07 | Unknown | Georgia | 4615 | 7 | |
1767767 | 1767767 | 2021-09-29 | Randolph | West Virginia | 54083 | 4615 | 31 |
1758783 | 1758783 | 2021-09-27 | Lee | Illinois | 17103 | 4615 | 99 |
1759606 | 1759606 | 2021-09-27 | Scott | Mississippi | 28123 | 4615 | 96 |
1751688 | 1751688 | 2021-09-25 | Pike | Alabama | 1109 | 4615 | 97 |
1745618 | 1745618 | 2021-09-23 | Lumpkin | Georgia | 13187 | 4615 | 90 |
1741719 | 1741719 | 2021-09-21 | Mason | Washington | 53045 | 4615 | 52 |
1717268 | 1717268 | 2021-09-14 | Morrison | Minnesota | 27097 | 4615 | 62 |
1710411 | 1710411 | 2021-09-12 | Boyle | Kentucky | 21021 | 4615 | 80 |
1707164 | 1707164 | 2021-09-11 | Boyle | Kentucky | 21021 | 4615 | 80 |
1703916 | 1703916 | 2021-09-10 | Boyle | Kentucky | 21021 | 4615 | 80 |
1679626 | 1679626 | 2021-09-02 | Grimes | Texas | 48185 | 4615 | 77 |
1665701 | 1665701 | 2021-08-29 | Belknap | New Hampshire | 33001 | 4615 | 105 |
1662453 | 1662453 | 2021-08-28 | Belknap | New Hampshire | 33001 | 4615 | 105 |
1659205 | 1659205 | 2021-08-27 | Belknap | New Hampshire | 33001 | 4615 | 105 |
1652284 | 1652284 | 2021-08-25 | Isanti | Minnesota | 27059 | 4615 | 68 |
1628035 | 1628035 | 2021-08-17 | Whitman | Washington | 53075 | 4615 | 54 |
1509524 | 1509524 | 2021-07-12 | Camden | Missouri | 29029 | 4615 | 94 |
1506278 | 1506278 | 2021-07-11 | Camden | Missouri | 29029 | 4615 | 94 |
1493139 | 1493139 | 2021-07-07 | Itasca | Minnesota | 27061 | 4615 | 66 |
1491291 | 1491291 | 2021-07-06 | Kerr | Texas | 48265 | 4615 | 92 |
1463979 | 1463979 | 2021-06-28 | Winona | Minnesota | 27169 | 4615 | 52 |
1460734 | 1460734 | 2021-06-27 | Winona | Minnesota | 27169 | 4615 | 52 |
1462546 | 1462546 | 2021-06-27 | Albany | Wyoming | 56001 | 4615 | 17 |
1457489 | 1457489 | 2021-06-26 | Winona | Minnesota | 27169 | 4615 | 52 |
1459301 | 1459301 | 2021-06-26 | Albany | Wyoming | 56001 | 4615 | 17 |
1456056 | 1456056 | 2021-06-25 | Albany | Wyoming | 56001 | 4615 | 17 |
1432867 | 1432867 | 2021-06-18 | Kerr | Texas | 48265 | 4615 | 90 |
1419924 | 1419924 | 2021-06-14 | Nacogdoches | Texas | 48347 | 4615 | 172 |
1335722 | 1335722 | 2021-05-19 | James City | Virginia | 51095 | 4615 | 72 |
1297462 | 1297462 | 2021-05-08 | Effingham | Georgia | 13103 | 4615 | 68 |
1251057 | 1251057 | 2021-04-23 | Howard | Texas | 48227 | 4615 | 101 |
1236197 | 1236197 | 2021-04-19 | Muscatine | Iowa | 19139 | 4615 | 96 |
1211779 | 1211779 | 2021-04-11 | Chesterfield | South Carolina | 45025 | 4615 | 101 |
1146667 | 1146667 | 2021-03-22 | Bradford | Pennsylvania | 42015 | 4615 | 82 |
1127029 | 1127029 | 2021-03-16 | Mercer | Ohio | 39107 | 4615 | 83 |
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);