ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
452 rows where cases = 1189 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 42
- Nebraska 33
- Iowa 31
- Georgia 21
- Kansas 20
- Kentucky 19
- Missouri 19
- Puerto Rico 19
- Virginia 16
- Indiana 15
- Arkansas 12
- Idaho 12
- Minnesota 11
- Mississippi 11
- Montana 11
- Oklahoma 10
- Tennessee 10
- Wyoming 10
- Illinois 9
- South Dakota 9
- Louisiana 8
- Colorado 7
- Utah 7
- Washington 7
- Nevada 6
- North Carolina 6
- Ohio 6
- South Carolina 6
- Florida 5
- New Jersey 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499273 | 2499273 | 2022-05-12 | Charles City | Virginia | 51036 | 1189 | 27 |
2496015 | 2496015 | 2022-05-11 | Charles City | Virginia | 51036 | 1189 | 27 |
2442672 | 2442672 | 2022-04-25 | Howard | Nebraska | 31093 | 1189 | 15 |
2439416 | 2439416 | 2022-04-24 | Howard | Nebraska | 31093 | 1189 | 15 |
2436160 | 2436160 | 2022-04-23 | Howard | Nebraska | 31093 | 1189 | 15 |
2432904 | 2432904 | 2022-04-22 | Howard | Nebraska | 31093 | 1189 | 15 |
2419879 | 2419879 | 2022-04-18 | Howard | Nebraska | 31093 | 1189 | 15 |
2416624 | 2416624 | 2022-04-17 | Howard | Nebraska | 31093 | 1189 | 15 |
2413368 | 2413368 | 2022-04-16 | Howard | Nebraska | 31093 | 1189 | 15 |
2410112 | 2410112 | 2022-04-15 | Howard | Nebraska | 31093 | 1189 | 15 |
2406856 | 2406856 | 2022-04-14 | Howard | Nebraska | 31093 | 1189 | 15 |
2403600 | 2403600 | 2022-04-13 | Howard | Nebraska | 31093 | 1189 | 15 |
2358039 | 2358039 | 2022-03-30 | Howard | Nebraska | 31093 | 1189 | 15 |
2354786 | 2354786 | 2022-03-29 | Howard | Nebraska | 31093 | 1189 | 15 |
2351533 | 2351533 | 2022-03-28 | Howard | Nebraska | 31093 | 1189 | 15 |
2349654 | 2349654 | 2022-03-27 | San Juan | Washington | 53055 | 1189 | 2 |
2346401 | 2346401 | 2022-03-26 | San Juan | Washington | 53055 | 1189 | 2 |
2343148 | 2343148 | 2022-03-25 | San Juan | Washington | 53055 | 1189 | 2 |
2339895 | 2339895 | 2022-03-24 | San Juan | Washington | 53055 | 1189 | 2 |
2336642 | 2336642 | 2022-03-23 | San Juan | Washington | 53055 | 1189 | 2 |
2320000 | 2320000 | 2022-03-18 | Goliad | Texas | 48175 | 1189 | 32 |
2309298 | 2309298 | 2022-03-15 | Lander | Nevada | 32015 | 1189 | 20 |
2306046 | 2306046 | 2022-03-14 | Lander | Nevada | 32015 | 1189 | 20 |
2302795 | 2302795 | 2022-03-13 | Lander | Nevada | 32015 | 1189 | 20 |
2299543 | 2299543 | 2022-03-12 | Lander | Nevada | 32015 | 1189 | 20 |
2296291 | 2296291 | 2022-03-11 | Lander | Nevada | 32015 | 1189 | 20 |
2293039 | 2293039 | 2022-03-10 | Lander | Nevada | 32015 | 1189 | 20 |
2279225 | 2279225 | 2022-03-06 | Ottawa | Kansas | 20143 | 1189 | 16 |
2275972 | 2275972 | 2022-03-05 | Ottawa | Kansas | 20143 | 1189 | 16 |
2272719 | 2272719 | 2022-03-04 | Ottawa | Kansas | 20143 | 1189 | 16 |
2233869 | 2233869 | 2022-02-20 | Cameron | Louisiana | 22023 | 1189 | 8 |
2230618 | 2230618 | 2022-02-19 | Cameron | Louisiana | 22023 | 1189 | 8 |
2227367 | 2227367 | 2022-02-18 | Cameron | Louisiana | 22023 | 1189 | 8 |
2224116 | 2224116 | 2022-02-17 | Cameron | Louisiana | 22023 | 1189 | 8 |
2177024 | 2177024 | 2022-02-02 | Sabine | Texas | 48403 | 1189 | 78 |
2165021 | 2165021 | 2022-01-30 | Lemhi | Idaho | 16059 | 1189 | 25 |
2161766 | 2161766 | 2022-01-29 | Lemhi | Idaho | 16059 | 1189 | 25 |
2155273 | 2155273 | 2022-01-27 | Alexander | Illinois | 17003 | 1189 | 13 |
2153899 | 2153899 | 2022-01-26 | Day | South Dakota | 46037 | 1189 | 32 |
2143039 | 2143039 | 2022-01-23 | Norman | Minnesota | 27107 | 1189 | 12 |
2139784 | 2139784 | 2022-01-22 | Norman | Minnesota | 27107 | 1189 | 12 |
2136528 | 2136528 | 2022-01-21 | Norman | Minnesota | 27107 | 1189 | 12 |
2124865 | 2124865 | 2022-01-17 | Hartley | Texas | 48205 | 1189 | 3 |
2121613 | 2121613 | 2022-01-16 | Hartley | Texas | 48205 | 1189 | 3 |
2098645 | 2098645 | 2022-01-09 | Spink | South Dakota | 46115 | 1189 | 31 |
2095393 | 2095393 | 2022-01-08 | Spink | South Dakota | 46115 | 1189 | 31 |
2092141 | 2092141 | 2022-01-07 | Spink | South Dakota | 46115 | 1189 | 31 |
2084633 | 2084633 | 2022-01-05 | Carter | Missouri | 29035 | 1189 | 19 |
2081427 | 2081427 | 2022-01-04 | Maries | Missouri | 29125 | 1189 | 22 |
2078624 | 2078624 | 2022-01-03 | Bottineau | North Dakota | 38009 | 1189 | 24 |
2063769 | 2063769 | 2021-12-30 | Montgomery | Arkansas | 5097 | 1189 | 51 |
2063795 | 2063795 | 2021-12-30 | Woodruff | Arkansas | 5147 | 1189 | 24 |
2060616 | 2060616 | 2021-12-29 | Conejos | Colorado | 8021 | 1189 | 46 |
2058706 | 2058706 | 2021-12-28 | Shannon | Missouri | 29203 | 1189 | 29 |
2054322 | 2054322 | 2021-12-27 | Hancock | Georgia | 13141 | 1189 | 82 |
2050771 | 2050771 | 2021-12-26 | Montgomery | Arkansas | 5097 | 1189 | 51 |
2040104 | 2040104 | 2021-12-22 | Hamlin | South Dakota | 46057 | 1189 | 40 |
2040719 | 2040719 | 2021-12-22 | Calhoun | West Virginia | 54013 | 1189 | 9 |
1985019 | 1985019 | 2021-12-05 | Coleman | Texas | 48083 | 1189 | 55 |
1981769 | 1981769 | 2021-12-04 | Coleman | Texas | 48083 | 1189 | 55 |
1965632 | 1965632 | 2021-11-29 | Marion | Texas | 48315 | 1189 | 53 |
1965692 | 1965692 | 2021-11-29 | Stephens | Texas | 48429 | 1189 | 37 |
1962850 | 1962850 | 2021-11-28 | Weston | Wyoming | 56045 | 1189 | 13 |
1959599 | 1959599 | 2021-11-27 | Weston | Wyoming | 56045 | 1189 | 13 |
1956348 | 1956348 | 2021-11-26 | Weston | Wyoming | 56045 | 1189 | 13 |
1953097 | 1953097 | 2021-11-25 | Weston | Wyoming | 56045 | 1189 | 13 |
1949846 | 1949846 | 2021-11-24 | Weston | Wyoming | 56045 | 1189 | 13 |
1946595 | 1946595 | 2021-11-23 | Weston | Wyoming | 56045 | 1189 | 13 |
1926843 | 1926843 | 2021-11-17 | Lunenburg | Virginia | 51111 | 1189 | 22 |
1918357 | 1918357 | 2021-11-15 | Bracken | Kentucky | 21023 | 1189 | 11 |
1907482 | 1907482 | 2021-11-11 | Pocahontas | West Virginia | 54075 | 1189 | 18 |
1898668 | 1898668 | 2021-11-09 | Davis | Iowa | 19051 | 1189 | 25 |
1899508 | 1899508 | 2021-11-09 | Stillwater | Montana | 30095 | 1189 | 27 |
1895418 | 1895418 | 2021-11-08 | Davis | Iowa | 19051 | 1189 | 25 |
1896258 | 1896258 | 2021-11-08 | Stillwater | Montana | 30095 | 1189 | 27 |
1891433 | 1891433 | 2021-11-07 | Sitka City and Borough | Alaska | 2220 | 1189 | 4 |
1892168 | 1892168 | 2021-11-07 | Davis | Iowa | 19051 | 1189 | 25 |
1893008 | 1893008 | 2021-11-07 | Stillwater | Montana | 30095 | 1189 | 27 |
1888183 | 1888183 | 2021-11-06 | Sitka City and Borough | Alaska | 2220 | 1189 | 4 |
1888918 | 1888918 | 2021-11-06 | Davis | Iowa | 19051 | 1189 | 25 |
1889758 | 1889758 | 2021-11-06 | Stillwater | Montana | 30095 | 1189 | 27 |
1884933 | 1884933 | 2021-11-05 | Sitka City and Borough | Alaska | 2220 | 1189 | 4 |
1885668 | 1885668 | 2021-11-05 | Davis | Iowa | 19051 | 1189 | 25 |
1886508 | 1886508 | 2021-11-05 | Stillwater | Montana | 30095 | 1189 | 27 |
1882419 | 1882419 | 2021-11-04 | Davis | Iowa | 19051 | 1189 | 25 |
1879170 | 1879170 | 2021-11-03 | Davis | Iowa | 19051 | 1189 | 25 |
1878299 | 1878299 | 2021-11-02 | Pepin | Wisconsin | 55091 | 1189 | 10 |
1869081 | 1869081 | 2021-10-31 | Lincoln | Georgia | 13181 | 1189 | 33 |
1865832 | 1865832 | 2021-10-30 | Lincoln | Georgia | 13181 | 1189 | 33 |
1862583 | 1862583 | 2021-10-29 | Lincoln | Georgia | 13181 | 1189 | 33 |
1859946 | 1859946 | 2021-10-28 | Nicholas | Kentucky | 21181 | 1189 | 17 |
1859974 | 1859974 | 2021-10-28 | Wolfe | Kentucky | 21237 | 1189 | 11 |
1861194 | 1861194 | 2021-10-28 | Barceloneta | Puerto Rico | 72017 | 1189 | |
1856077 | 1856077 | 2021-10-27 | Jenkins | Georgia | 13165 | 1189 | 56 |
1857945 | 1857945 | 2021-10-27 | Barceloneta | Puerto Rico | 72017 | 1189 | |
1858480 | 1858480 | 2021-10-27 | Yoakum | Texas | 48501 | 1189 | 31 |
1852828 | 1852828 | 2021-10-26 | Jenkins | Georgia | 13165 | 1189 | 56 |
1854696 | 1854696 | 2021-10-26 | Barceloneta | Puerto Rico | 72017 | 1189 | |
1855231 | 1855231 | 2021-10-26 | Yoakum | Texas | 48501 | 1189 | 31 |
1849579 | 1849579 | 2021-10-25 | Jenkins | Georgia | 13165 | 1189 | 56 |
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);