ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
85 rows where cases = 6035 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 29
- Texas 13
- Idaho 10
- Florida 7
- North Carolina 6
- Illinois 5
- Georgia 4
- Tennessee 4
- Minnesota 3
- Mississippi 3
- Missouri 3
- West Virginia 3
- Alabama 2
- Kentucky 2
- Michigan 2
- Ohio 2
- Oregon 2
- Pennsylvania 2
- Arizona 1
- Arkansas 1
- Indiana 1
- Louisiana 1
- Massachusetts 1
- Nevada 1
- New York 1
- South Carolina 1
- Virginia 1
- Washington 1
- Wisconsin 1
- Wyoming 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2358561 | 2358561 | 2022-03-30 | Crook | Oregon | 41013 | 6035 | 77 |
2324375 | 2324375 | 2022-03-20 | Jerome | Idaho | 16053 | 6035 | 64 |
2321121 | 2321121 | 2022-03-19 | Jerome | Idaho | 16053 | 6035 | 64 |
2317867 | 2317867 | 2022-03-18 | Jerome | Idaho | 16053 | 6035 | 64 |
2314613 | 2314613 | 2022-03-17 | Jefferson | Idaho | 16051 | 6035 | 63 |
2311360 | 2311360 | 2022-03-16 | Jefferson | Idaho | 16051 | 6035 | 63 |
2308107 | 2308107 | 2022-03-15 | Jefferson | Idaho | 16051 | 6035 | 62 |
2304856 | 2304856 | 2022-03-14 | Jefferson | Idaho | 16051 | 6035 | 62 |
2301604 | 2301604 | 2022-03-13 | Jefferson | Idaho | 16051 | 6035 | 62 |
2298352 | 2298352 | 2022-03-12 | Jefferson | Idaho | 16051 | 6035 | 62 |
2295100 | 2295100 | 2022-03-11 | Jefferson | Idaho | 16051 | 6035 | 62 |
2291727 | 2291727 | 2022-03-10 | Harris | Georgia | 13145 | 6035 | 109 |
2286725 | 2286725 | 2022-03-08 | Martin | North Carolina | 37117 | 6035 | 89 |
2220233 | 2220233 | 2022-02-16 | Peach | Georgia | 13225 | 6035 | 119 |
2221602 | 2221602 | 2022-02-16 | Lewis | New York | 36049 | 6035 | 46 |
2174712 | 2174712 | 2022-02-02 | Stephens | Georgia | 13257 | 6035 | 132 |
2152039 | 2152039 | 2022-01-26 | Douglas | Illinois | 17041 | 6035 | 54 |
2141522 | 2141522 | 2022-01-22 | Hancock | West Virginia | 54029 | 6035 | 130 |
2129316 | 2129316 | 2022-01-19 | Perry | Illinois | 17145 | 6035 | 97 |
2097582 | 2097582 | 2022-01-09 | Leflore | Mississippi | 28083 | 6035 | 144 |
2094330 | 2094330 | 2022-01-08 | Leflore | Mississippi | 28083 | 6035 | 144 |
2091078 | 2091078 | 2022-01-07 | Leflore | Mississippi | 28083 | 6035 | 144 |
2083725 | 2083725 | 2022-01-05 | Bureau | Illinois | 17011 | 6035 | 124 |
2058252 | 2058252 | 2021-12-28 | Evangeline | Louisiana | 22039 | 6035 | 144 |
2060114 | 2060114 | 2021-12-28 | Manassas city | Virginia | 51683 | 6035 | 57 |
2043182 | 2043182 | 2021-12-23 | Snyder | Pennsylvania | 42109 | 6035 | 121 |
2040425 | 2040425 | 2021-12-22 | Polk | Texas | 48373 | 6035 | 219 |
2027462 | 2027462 | 2021-12-18 | Titus | Texas | 48449 | 6035 | 104 |
1928423 | 1928423 | 2021-11-18 | Becker | Minnesota | 27005 | 6035 | 70 |
1926941 | 1926941 | 2021-11-17 | Whitman | Washington | 53075 | 6035 | 82 |
1882973 | 1882973 | 2021-11-04 | Morrison | Minnesota | 27097 | 6035 | 71 |
1836454 | 1836454 | 2021-10-21 | Hardee | Florida | 12049 | 6035 | 97 |
1833205 | 1833205 | 2021-10-20 | Hardee | Florida | 12049 | 6035 | 97 |
1829956 | 1829956 | 2021-10-19 | Hardee | Florida | 12049 | 6035 | 97 |
1826707 | 1826707 | 2021-10-18 | Hardee | Florida | 12049 | 6035 | 97 |
1823458 | 1823458 | 2021-10-17 | Hardee | Florida | 12049 | 6035 | 96 |
1820209 | 1820209 | 2021-10-16 | Hardee | Florida | 12049 | 6035 | 96 |
1816960 | 1816960 | 2021-10-15 | Hardee | Florida | 12049 | 6035 | 96 |
1813343 | 1813343 | 2021-10-13 | Albany | Wyoming | 56001 | 6035 | 31 |
1802446 | 1802446 | 2021-10-10 | Crawford | Ohio | 39033 | 6035 | 127 |
1785704 | 1785704 | 2021-10-05 | Phelps | Missouri | 29161 | 6035 | 177 |
1786745 | 1786745 | 2021-10-05 | Weakley | Tennessee | 47183 | 6035 | 81 |
1750449 | 1750449 | 2021-09-24 | Ashland | Ohio | 39005 | 6035 | 115 |
1744643 | 1744643 | 2021-09-22 | Kerr | Texas | 48265 | 6035 | 111 |
1740149 | 1740149 | 2021-09-21 | Camden | Missouri | 29029 | 6035 | 118 |
1725511 | 1725511 | 2021-09-16 | Marion | West Virginia | 54049 | 6035 | 64 |
1702966 | 1702966 | 2021-09-10 | Tallapoosa | Alabama | 1123 | 6035 | 163 |
1695944 | 1695944 | 2021-09-07 | Medina | Texas | 48325 | 6035 | 131 |
1692696 | 1692696 | 2021-09-06 | Medina | Texas | 48325 | 6035 | 131 |
1689447 | 1689447 | 2021-09-05 | Medina | Texas | 48325 | 6035 | 131 |
1686197 | 1686197 | 2021-09-04 | Medina | Texas | 48325 | 6035 | 131 |
1672366 | 1672366 | 2021-08-31 | Hoke | North Carolina | 37093 | 6035 | 59 |
1669915 | 1669915 | 2021-08-30 | Jim Wells | Texas | 48249 | 6035 | 125 |
1666668 | 1666668 | 2021-08-29 | Jim Wells | Texas | 48249 | 6035 | 125 |
1604928 | 1604928 | 2021-08-10 | Harrison | Texas | 48203 | 6035 | 115 |
1555741 | 1555741 | 2021-07-26 | Armstrong | Pennsylvania | 42005 | 6035 | 148 |
1463280 | 1463280 | 2021-06-28 | Cass | Indiana | 18017 | 6035 | 112 |
1442573 | 1442573 | 2021-06-21 | Hardin | Texas | 48199 | 6035 | 114 |
1439328 | 1439328 | 2021-06-20 | Hardin | Texas | 48199 | 6035 | 114 |
1436081 | 1436081 | 2021-06-19 | Hardin | Texas | 48199 | 6035 | 114 |
1397565 | 1397565 | 2021-06-07 | Barron | Wisconsin | 55005 | 6035 | 84 |
1380759 | 1380759 | 2021-06-02 | Lawrence | Tennessee | 47099 | 6035 | 92 |
1381296 | 1381296 | 2021-06-02 | Harrison | West Virginia | 54033 | 6035 | 77 |
1287954 | 1287954 | 2021-05-05 | Ogle | Illinois | 17141 | 6035 | 89 |
1277671 | 1277671 | 2021-05-02 | Crittenden | Arkansas | 5035 | 6035 | 96 |
1227137 | 1227137 | 2021-04-16 | Joplin | Missouri | 6035 | 106 | |
1220438 | 1220438 | 2021-04-14 | Crow Wing | Minnesota | 27035 | 6035 | 86 |
1211286 | 1211286 | 2021-04-11 | Duplin | North Carolina | 37061 | 6035 | 128 |
1208037 | 1208037 | 2021-04-10 | Duplin | North Carolina | 37061 | 6035 | 128 |
1204789 | 1204789 | 2021-04-09 | Duplin | North Carolina | 37061 | 6035 | 128 |
1152654 | 1152654 | 2021-03-24 | Carson City | Nevada | 32510 | 6035 | 119 |
1148744 | 1148744 | 2021-03-23 | Pulaski | Kentucky | 21199 | 6035 | 93 |
1141753 | 1141753 | 2021-03-21 | Boone | Illinois | 17007 | 6035 | 83 |
1118440 | 1118440 | 2021-03-14 | Colbert | Alabama | 1033 | 6035 | 125 |
1097935 | 1097935 | 2021-03-07 | Deschutes | Oregon | 41017 | 6035 | 65 |
1046309 | 1046309 | 2021-02-19 | Cumberland | Tennessee | 47035 | 6035 | 113 |
1036578 | 1036578 | 2021-02-16 | Dickson | Tennessee | 47043 | 6035 | 102 |
1033229 | 1033229 | 2021-02-15 | Laurens | South Carolina | 45059 | 6035 | 149 |
1022313 | 1022313 | 2021-02-12 | Eaton | Michigan | 26045 | 6035 | 145 |
932139 | 932139 | 2021-01-15 | Moore | North Carolina | 37125 | 6035 | 80 |
782143 | 782143 | 2020-11-30 | Calhoun | Michigan | 26025 | 6035 | 121 |
719327 | 719327 | 2020-11-11 | Coconino | Arizona | 4005 | 6035 | 153 |
496639 | 496639 | 2020-09-03 | Fayette | Kentucky | 21067 | 6035 | 58 |
412135 | 412135 | 2020-08-08 | Hall | Georgia | 13139 | 6035 | 91 |
194969 | 194969 | 2020-05-31 | Hampden | Massachusetts | 25013 | 6035 | 580 |
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);