ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
82 rows where cases = 6677 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 25
- Oklahoma 15
- North Carolina 8
- Iowa 7
- Michigan 6
- New Mexico 6
- Kentucky 4
- Ohio 4
- Tennessee 4
- Texas 3
- Wisconsin 3
- Alaska 2
- Colorado 2
- Mississippi 2
- Montana 2
- New York 2
- North Dakota 2
- Virginia 2
- Arkansas 1
- Georgia 1
- Idaho 1
- Illinois 1
- Louisiana 1
- Pennsylvania 1
- South Carolina 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2449292 | 2449292 | 2022-04-27 | Grant | New Mexico | 35017 | 6677 | 87 |
2446035 | 2446035 | 2022-04-26 | Grant | New Mexico | 35017 | 6677 | 87 |
2442780 | 2442780 | 2022-04-25 | Grant | New Mexico | 35017 | 6677 | 87 |
2314616 | 2314616 | 2022-03-17 | Latah | Idaho | 16057 | 6677 | 48 |
2302853 | 2302853 | 2022-03-13 | Luna | New Mexico | 35029 | 6677 | 119 |
2299601 | 2299601 | 2022-03-12 | Luna | New Mexico | 35029 | 6677 | 119 |
2296349 | 2296349 | 2022-03-11 | Luna | New Mexico | 35029 | 6677 | 119 |
2265143 | 2265143 | 2022-03-01 | Upshur | West Virginia | 54097 | 6677 | 81 |
2256614 | 2256614 | 2022-02-27 | Woodford | Kentucky | 21239 | 6677 | 44 |
2253363 | 2253363 | 2022-02-26 | Woodford | Kentucky | 21239 | 6677 | 44 |
2250112 | 2250112 | 2022-02-25 | Woodford | Kentucky | 21239 | 6677 | 44 |
2216172 | 2216172 | 2022-02-14 | Botetourt | Virginia | 51023 | 6677 | 83 |
2192112 | 2192112 | 2022-02-07 | Ravalli | Montana | 30081 | 6677 | 134 |
2189256 | 2189256 | 2022-02-06 | Stutsman | North Dakota | 38093 | 6677 | 95 |
2186003 | 2186003 | 2022-02-05 | Stutsman | North Dakota | 38093 | 6677 | 95 |
2103507 | 2103507 | 2022-01-11 | Sioux | Iowa | 19167 | 6677 | 78 |
2103737 | 2103737 | 2022-01-11 | Taylor | Kentucky | 21217 | 6677 | 105 |
2100256 | 2100256 | 2022-01-10 | Sioux | Iowa | 19167 | 6677 | 78 |
2097005 | 2097005 | 2022-01-09 | Sioux | Iowa | 19167 | 6677 | 78 |
2093753 | 2093753 | 2022-01-08 | Sioux | Iowa | 19167 | 6677 | 78 |
2090501 | 2090501 | 2022-01-07 | Sioux | Iowa | 19167 | 6677 | 78 |
2087250 | 2087250 | 2022-01-06 | Sioux | Iowa | 19167 | 6677 | 78 |
2083998 | 2083998 | 2022-01-05 | Sioux | Iowa | 19167 | 6677 | 78 |
2052469 | 2052469 | 2021-12-26 | Columbia | New York | 36021 | 6677 | 119 |
2007218 | 2007218 | 2021-12-12 | Madison | Ohio | 39097 | 6677 | 94 |
1969641 | 1969641 | 2021-12-01 | Montrose | Colorado | 8085 | 6677 | 111 |
1961535 | 1961535 | 2021-11-28 | Davie | North Carolina | 37059 | 6677 | 81 |
1958284 | 1958284 | 2021-11-27 | Davie | North Carolina | 37059 | 6677 | 81 |
1955033 | 1955033 | 2021-11-26 | Davie | North Carolina | 37059 | 6677 | 81 |
1949917 | 1949917 | 2021-11-25 | Bethel Census Area | Alaska | 2050 | 6677 | 27 |
1951782 | 1951782 | 2021-11-25 | Davie | North Carolina | 37059 | 6677 | 81 |
1946666 | 1946666 | 2021-11-24 | Bethel Census Area | Alaska | 2050 | 6677 | 27 |
1948531 | 1948531 | 2021-11-24 | Davie | North Carolina | 37059 | 6677 | 81 |
1925931 | 1925931 | 2021-11-17 | Fulton | Ohio | 39051 | 6677 | 107 |
1883062 | 1883062 | 2021-11-04 | Neshoba | Mississippi | 28099 | 6677 | 208 |
1869906 | 1869906 | 2021-10-31 | Newaygo | Michigan | 26123 | 6677 | 84 |
1866657 | 1866657 | 2021-10-30 | Newaygo | Michigan | 26123 | 6677 | 84 |
1863408 | 1863408 | 2021-10-29 | Newaygo | Michigan | 26123 | 6677 | 84 |
1850580 | 1850580 | 2021-10-25 | Pontotoc | Mississippi | 28115 | 6677 | 104 |
1809075 | 1809075 | 2021-10-12 | Osage | Oklahoma | 40113 | 6677 | 115 |
1805825 | 1805825 | 2021-10-11 | Osage | Oklahoma | 40113 | 6677 | 115 |
1802575 | 1802575 | 2021-10-10 | Osage | Oklahoma | 40113 | 6677 | 115 |
1799326 | 1799326 | 2021-10-09 | Osage | Oklahoma | 40113 | 6677 | 115 |
1796077 | 1796077 | 2021-10-08 | Osage | Oklahoma | 40113 | 6677 | 115 |
1792828 | 1792828 | 2021-10-07 | Osage | Oklahoma | 40113 | 6677 | 115 |
1789579 | 1789579 | 2021-10-06 | Osage | Oklahoma | 40113 | 6677 | 115 |
1756830 | 1756830 | 2021-09-26 | Haywood | North Carolina | 37087 | 6677 | 127 |
1753582 | 1753582 | 2021-09-25 | Haywood | North Carolina | 37087 | 6677 | 127 |
1750334 | 1750334 | 2021-09-24 | Haywood | North Carolina | 37087 | 6677 | 127 |
1745784 | 1745784 | 2021-09-23 | Knox | Illinois | 17095 | 6677 | 195 |
1740961 | 1740961 | 2021-09-21 | Union | Pennsylvania | 42119 | 6677 | 93 |
1604359 | 1604359 | 2021-08-10 | Bryan | Oklahoma | 40013 | 6677 | 80 |
1601110 | 1601110 | 2021-08-09 | Bryan | Oklahoma | 40013 | 6677 | 80 |
1597862 | 1597862 | 2021-08-08 | Bryan | Oklahoma | 40013 | 6677 | 80 |
1598866 | 1598866 | 2021-08-08 | Calumet | Wisconsin | 55015 | 6677 | 56 |
1594613 | 1594613 | 2021-08-07 | Bryan | Oklahoma | 40013 | 6677 | 80 |
1595617 | 1595617 | 2021-08-07 | Calumet | Wisconsin | 55015 | 6677 | 56 |
1591364 | 1591364 | 2021-08-06 | Bryan | Oklahoma | 40013 | 6677 | 80 |
1592368 | 1592368 | 2021-08-06 | Calumet | Wisconsin | 55015 | 6677 | 56 |
1588115 | 1588115 | 2021-08-05 | Bryan | Oklahoma | 40013 | 6677 | 80 |
1584865 | 1584865 | 2021-08-04 | Bryan | Oklahoma | 40013 | 6677 | 80 |
1471992 | 1471992 | 2021-06-30 | Bedford | Virginia | 51019 | 6677 | 109 |
1419681 | 1419681 | 2021-06-14 | Gibson | Tennessee | 47053 | 6677 | 148 |
1416436 | 1416436 | 2021-06-13 | Gibson | Tennessee | 47053 | 6677 | 148 |
1413190 | 1413190 | 2021-06-12 | Gibson | Tennessee | 47053 | 6677 | 148 |
1409945 | 1409945 | 2021-06-11 | Gibson | Tennessee | 47053 | 6677 | 148 |
1295862 | 1295862 | 2021-05-07 | Geauga | Ohio | 39055 | 6677 | 148 |
1286473 | 1286473 | 2021-05-04 | Georgetown | South Carolina | 45043 | 6677 | 139 |
1269125 | 1269125 | 2021-04-29 | Van Buren | Michigan | 26159 | 6677 | 113 |
1227227 | 1227227 | 2021-04-16 | Lewis and Clark | Montana | 30049 | 6677 | 86 |
1114097 | 1114097 | 2021-03-12 | Creek | Oklahoma | 40037 | 6677 | 121 |
1104833 | 1104833 | 2021-03-09 | Bowie | Texas | 48037 | 6677 | 187 |
952500 | 952500 | 2021-01-21 | Val Verde | Texas | 48465 | 6677 | 165 |
949255 | 949255 | 2021-01-20 | Val Verde | Texas | 48465 | 6677 | 165 |
916071 | 916071 | 2021-01-10 | Pickaway | Ohio | 39129 | 6677 | 50 |
910838 | 910838 | 2021-01-09 | Garland | Arkansas | 5051 | 6677 | 167 |
912599 | 912599 | 2021-01-09 | Ulster | New York | 36111 | 6677 | 165 |
895645 | 895645 | 2021-01-04 | St. Landry | Louisiana | 22097 | 6677 | 204 |
856851 | 856851 | 2020-12-23 | St. Clair | Michigan | 26147 | 6677 | 146 |
811381 | 811381 | 2020-12-09 | Livingston | Michigan | 26093 | 6677 | 54 |
794350 | 794350 | 2020-12-04 | Lowndes | Georgia | 13185 | 6677 | 128 |
428029 | 428029 | 2020-08-13 | Adams | Colorado | 8001 | 6677 | 178 |
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);