ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
106 rows where cases = 4897 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 30
- Texas 9
- Georgia 8
- Iowa 8
- Oklahoma 8
- Kansas 7
- Virginia 7
- Illinois 5
- South Carolina 5
- Minnesota 4
- Wisconsin 4
- Alabama 3
- Colorado 3
- Indiana 3
- Kentucky 3
- Michigan 3
- New York 3
- North Carolina 3
- Puerto Rico 3
- Washington 3
- Idaho 2
- Maryland 2
- West Virginia 2
- Arkansas 1
- Mississippi 1
- Missouri 1
- New Mexico 1
- Ohio 1
- Oregon 1
- Pennsylvania 1
- Tennessee 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499880 | 2499880 | 2022-05-13 | Teller | Colorado | 8119 | 4897 | 57 |
2495439 | 2495439 | 2022-05-11 | Lares | Puerto Rico | 72081 | 4897 | |
2486236 | 2486236 | 2022-05-08 | Buchanan | Virginia | 51027 | 4897 | 121 |
2482978 | 2482978 | 2022-05-07 | Buchanan | Virginia | 51027 | 4897 | 121 |
2479720 | 2479720 | 2022-05-06 | Buchanan | Virginia | 51027 | 4897 | 121 |
2395798 | 2395798 | 2022-04-11 | Cook | Georgia | 13075 | 4897 | 74 |
2288787 | 2288787 | 2022-03-09 | Rush | Indiana | 18139 | 4897 | 58 |
2281660 | 2281660 | 2022-03-07 | Lincoln | Arkansas | 5079 | 4897 | 65 |
2282284 | 2282284 | 2022-03-07 | Rush | Indiana | 18139 | 4897 | 58 |
2264786 | 2264786 | 2022-03-01 | Milam | Texas | 48331 | 4897 | 99 |
2231830 | 2231830 | 2022-02-19 | Cabo Rojo | Puerto Rico | 72023 | 4897 | |
2217496 | 2217496 | 2022-02-15 | Breckinridge | Kentucky | 21027 | 4897 | 65 |
2219133 | 2219133 | 2022-02-15 | Burleson | Texas | 48051 | 4897 | 64 |
2194185 | 2194185 | 2022-02-08 | Jones | Georgia | 13169 | 4897 | 104 |
2181283 | 2181283 | 2022-02-04 | Jerome | Idaho | 16053 | 4897 | 60 |
2178669 | 2178669 | 2022-02-03 | Somerset | Maryland | 24039 | 4897 | 67 |
2176118 | 2176118 | 2022-02-02 | Caswell | North Carolina | 37033 | 4897 | 39 |
2155362 | 2155362 | 2022-01-27 | Union | Illinois | 17181 | 4897 | 63 |
2150004 | 2150004 | 2022-01-25 | San Miguel | New Mexico | 35047 | 4897 | 44 |
2150384 | 2150384 | 2022-01-25 | Seminole | Oklahoma | 40133 | 4897 | 107 |
2146775 | 2146775 | 2022-01-24 | Essex | New York | 36031 | 4897 | 52 |
2147132 | 2147132 | 2022-01-24 | Seminole | Oklahoma | 40133 | 4897 | 107 |
2143878 | 2143878 | 2022-01-23 | Seminole | Oklahoma | 40133 | 4897 | 107 |
2140623 | 2140623 | 2022-01-22 | Seminole | Oklahoma | 40133 | 4897 | 107 |
2137367 | 2137367 | 2022-01-21 | Seminole | Oklahoma | 40133 | 4897 | 107 |
2134113 | 2134113 | 2022-01-20 | Seminole | Oklahoma | 40133 | 4897 | 107 |
2130861 | 2130861 | 2022-01-19 | Seminole | Oklahoma | 40133 | 4897 | 107 |
2125965 | 2125965 | 2022-01-18 | Elmore | Idaho | 16039 | 4897 | 54 |
2125292 | 2125292 | 2022-01-17 | Wyoming | West Virginia | 54109 | 4897 | 80 |
2099073 | 2099073 | 2022-01-09 | Carroll | Virginia | 51035 | 4897 | 113 |
2095822 | 2095822 | 2022-01-08 | Carroll | Virginia | 51035 | 4897 | 113 |
2092570 | 2092570 | 2022-01-07 | Carroll | Virginia | 51035 | 4897 | 113 |
2061857 | 2061857 | 2021-12-29 | Yazoo | Mississippi | 28163 | 4897 | 94 |
2057528 | 2057528 | 2021-12-28 | Chattooga | Georgia | 13055 | 4897 | 109 |
2040727 | 2040727 | 2021-12-22 | Hancock | West Virginia | 54029 | 4897 | 123 |
2019476 | 2019476 | 2021-12-16 | Le Sueur | Minnesota | 27079 | 4897 | 38 |
1952298 | 1952298 | 2021-11-25 | Marlboro | South Carolina | 45069 | 4897 | 83 |
1949047 | 1949047 | 2021-11-24 | Marlboro | South Carolina | 45069 | 4897 | 83 |
1945796 | 1945796 | 2021-11-23 | Marlboro | South Carolina | 45069 | 4897 | 83 |
1941479 | 1941479 | 2021-11-22 | Pine | Minnesota | 27115 | 4897 | 41 |
1942545 | 1942545 | 2021-11-22 | Marlboro | South Carolina | 45069 | 4897 | 83 |
1937328 | 1937328 | 2021-11-21 | Lumpkin | Georgia | 13187 | 4897 | 109 |
1934078 | 1934078 | 2021-11-20 | Lumpkin | Georgia | 13187 | 4897 | 109 |
1930826 | 1930826 | 2021-11-19 | Lumpkin | Georgia | 13187 | 4897 | 109 |
1918388 | 1918388 | 2021-11-15 | Grayson | Kentucky | 21085 | 4897 | 95 |
1881901 | 1881901 | 2021-11-04 | Summit | Colorado | 8117 | 4897 | 11 |
1839323 | 1839323 | 2021-10-21 | Trempealeau | Wisconsin | 55121 | 4897 | 52 |
1830417 | 1830417 | 2021-10-19 | Buena Vista | Iowa | 19021 | 4897 | 45 |
1826384 | 1826384 | 2021-10-18 | Dallas | Alabama | 1047 | 4897 | 199 |
1827168 | 1827168 | 2021-10-18 | Buena Vista | Iowa | 19021 | 4897 | 45 |
1823919 | 1823919 | 2021-10-17 | Buena Vista | Iowa | 19021 | 4897 | 45 |
1820670 | 1820670 | 2021-10-16 | Buena Vista | Iowa | 19021 | 4897 | 45 |
1817421 | 1817421 | 2021-10-15 | Buena Vista | Iowa | 19021 | 4897 | 45 |
1814173 | 1814173 | 2021-10-14 | Buena Vista | Iowa | 19021 | 4897 | 45 |
1810924 | 1810924 | 2021-10-13 | Buena Vista | Iowa | 19021 | 4897 | 45 |
1786249 | 1786249 | 2021-10-05 | Perry | Ohio | 39127 | 4897 | 56 |
1773442 | 1773442 | 2021-10-01 | Pike | Pennsylvania | 42103 | 4897 | 57 |
1739249 | 1739249 | 2021-09-21 | Christian | Illinois | 17021 | 4897 | 98 |
1720702 | 1720702 | 2021-09-15 | Marion | Missouri | 29127 | 4897 | 58 |
1716806 | 1716806 | 2021-09-14 | Cowley | Kansas | 20035 | 4897 | 117 |
1713560 | 1713560 | 2021-09-13 | Cowley | Kansas | 20035 | 4897 | 117 |
1699042 | 1699042 | 2021-09-08 | Bee | Texas | 48025 | 4897 | 89 |
1696225 | 1696225 | 2021-09-07 | Douglas | Washington | 53017 | 4897 | 26 |
1692977 | 1692977 | 2021-09-06 | Douglas | Washington | 53017 | 4897 | 26 |
1689728 | 1689728 | 2021-09-05 | Douglas | Washington | 53017 | 4897 | 26 |
1685280 | 1685280 | 2021-09-04 | Livingston | New York | 36051 | 4897 | 61 |
1624271 | 1624271 | 2021-08-16 | Lincoln | Tennessee | 47103 | 4897 | 69 |
1610075 | 1610075 | 2021-08-12 | Mower | Minnesota | 27099 | 4897 | 34 |
1608189 | 1608189 | 2021-08-11 | Howard | Texas | 48227 | 4897 | 104 |
1584058 | 1584058 | 2021-08-04 | Goodhue | Minnesota | 27049 | 4897 | 74 |
1510414 | 1510414 | 2021-07-12 | Toa Baja | Puerto Rico | 72137 | 4897 | |
1470361 | 1470361 | 2021-06-30 | Newaygo | Michigan | 26123 | 4897 | 68 |
1471007 | 1471007 | 2021-06-30 | Hoke | North Carolina | 37093 | 4897 | 56 |
1467116 | 1467116 | 2021-06-29 | Newaygo | Michigan | 26123 | 4897 | 68 |
1463871 | 1463871 | 2021-06-28 | Newaygo | Michigan | 26123 | 4897 | 68 |
1427520 | 1427520 | 2021-06-17 | Livingston | Illinois | 17105 | 4897 | 103 |
1341953 | 1341953 | 2021-05-21 | Harrison | Texas | 48203 | 4897 | 109 |
1338705 | 1338705 | 2021-05-20 | Harrison | Texas | 48203 | 4897 | 109 |
1257473 | 1257473 | 2021-04-25 | Chambers | Texas | 48071 | 4897 | 48 |
1252206 | 1252206 | 2021-04-24 | Jackson | Illinois | 17077 | 4897 | 74 |
1254226 | 1254226 | 2021-04-24 | Chambers | Texas | 48071 | 4897 | 48 |
1250979 | 1250979 | 2021-04-23 | Chambers | Texas | 48071 | 4897 | 48 |
1245568 | 1245568 | 2021-04-22 | Murray | Georgia | 13213 | 4897 | 82 |
1248268 | 1248268 | 2021-04-22 | Oconto | Wisconsin | 55083 | 4897 | 58 |
1191710 | 1191710 | 2021-04-05 | Cattaraugus | New York | 36009 | 4897 | 79 |
1050522 | 1050522 | 2021-02-21 | Eagle | Colorado | 8037 | 4897 | 20 |
1007246 | 1007246 | 2021-02-07 | Cherokee | South Carolina | 45021 | 4897 | 124 |
1007754 | 1007754 | 2021-02-07 | Augusta | Virginia | 51015 | 4897 | 50 |
999089 | 999089 | 2021-02-05 | Noble | Indiana | 18113 | 4897 | 73 |
933334 | 933334 | 2021-01-15 | Columbia | Wisconsin | 55021 | 4897 | 42 |
881946 | 881946 | 2020-12-31 | Gordon | Georgia | 13129 | 4897 | 66 |
868548 | 868548 | 2020-12-27 | Jackson | Alabama | 1071 | 4897 | 34 |
869414 | 869414 | 2020-12-27 | Butler | Kansas | 20015 | 4897 | 18 |
866169 | 866169 | 2020-12-26 | Butler | Kansas | 20015 | 4897 | 18 |
862924 | 862924 | 2020-12-25 | Butler | Kansas | 20015 | 4897 | 18 |
859679 | 859679 | 2020-12-24 | Butler | Kansas | 20015 | 4897 | 18 |
861935 | 861935 | 2020-12-24 | Calumet | Wisconsin | 55015 | 4897 | 35 |
856434 | 856434 | 2020-12-23 | Butler | Kansas | 20015 | 4897 | 18 |
828562 | 828562 | 2020-12-14 | Jackson | Oregon | 41029 | 4897 | 50 |
809045 | 809045 | 2020-12-08 | Muskogee | Oklahoma | 40101 | 4897 | 37 |
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);