ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
296 rows where cases = 1697 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Missouri 35
- Iowa 21
- Virginia 17
- Florida 14
- Nebraska 13
- Texas 13
- Georgia 12
- Illinois 12
- Arkansas 10
- Kentucky 10
- Indiana 9
- Tennessee 9
- Minnesota 8
- Puerto Rico 8
- Michigan 7
- Nevada 7
- North Carolina 7
- Idaho 6
- Kansas 6
- Montana 6
- Wisconsin 6
- Mississippi 5
- Colorado 4
- Louisiana 4
- Maryland 4
- New Mexico 4
- New York 4
- Oklahoma 4
- South Carolina 4
- Alabama 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501932 | 2501932 | 2022-05-13 | Ceiba | Puerto Rico | 72037 | 1697 | |
2497830 | 2497830 | 2022-05-12 | Caldwell | Missouri | 29025 | 1697 | 39 |
2494572 | 2494572 | 2022-05-11 | Caldwell | Missouri | 29025 | 1697 | 39 |
2491314 | 2491314 | 2022-05-10 | Caldwell | Missouri | 29025 | 1697 | 39 |
2488056 | 2488056 | 2022-05-09 | Caldwell | Missouri | 29025 | 1697 | 39 |
2484799 | 2484799 | 2022-05-08 | Caldwell | Missouri | 29025 | 1697 | 39 |
2481541 | 2481541 | 2022-05-07 | Caldwell | Missouri | 29025 | 1697 | 39 |
2478283 | 2478283 | 2022-05-06 | Caldwell | Missouri | 29025 | 1697 | 39 |
2472502 | 2472502 | 2022-05-04 | Grant | Oregon | 41023 | 1697 | 21 |
2465990 | 2465990 | 2022-05-02 | Grant | Oregon | 41023 | 1697 | 21 |
2445992 | 2445992 | 2022-04-26 | White Pine | Nevada | 32033 | 1697 | 19 |
2442737 | 2442737 | 2022-04-25 | White Pine | Nevada | 32033 | 1697 | 19 |
2439481 | 2439481 | 2022-04-24 | White Pine | Nevada | 32033 | 1697 | 19 |
2436225 | 2436225 | 2022-04-23 | White Pine | Nevada | 32033 | 1697 | 19 |
2432969 | 2432969 | 2022-04-22 | White Pine | Nevada | 32033 | 1697 | 19 |
2429713 | 2429713 | 2022-04-21 | White Pine | Nevada | 32033 | 1697 | 19 |
2426457 | 2426457 | 2022-04-20 | White Pine | Nevada | 32033 | 1697 | 19 |
2354587 | 2354587 | 2022-03-29 | Chariton | Missouri | 29041 | 1697 | 36 |
2351334 | 2351334 | 2022-03-28 | Chariton | Missouri | 29041 | 1697 | 36 |
2348082 | 2348082 | 2022-03-27 | Chariton | Missouri | 29041 | 1697 | 36 |
2344829 | 2344829 | 2022-03-26 | Chariton | Missouri | 29041 | 1697 | 36 |
2341576 | 2341576 | 2022-03-25 | Chariton | Missouri | 29041 | 1697 | 36 |
2338323 | 2338323 | 2022-03-24 | Chariton | Missouri | 29041 | 1697 | 36 |
2335069 | 2335069 | 2022-03-23 | Chariton | Missouri | 29041 | 1697 | 36 |
2331815 | 2331815 | 2022-03-22 | Chariton | Missouri | 29041 | 1697 | 36 |
2325368 | 2325368 | 2022-03-20 | Ozark | Missouri | 29153 | 1697 | 55 |
2322114 | 2322114 | 2022-03-19 | Ozark | Missouri | 29153 | 1697 | 55 |
2318860 | 2318860 | 2022-03-18 | Ozark | Missouri | 29153 | 1697 | 55 |
2315607 | 2315607 | 2022-03-17 | Ozark | Missouri | 29153 | 1697 | 55 |
2312354 | 2312354 | 2022-03-16 | Ozark | Missouri | 29153 | 1697 | 55 |
2302598 | 2302598 | 2022-03-13 | Ozark | Missouri | 29153 | 1697 | 55 |
2299346 | 2299346 | 2022-03-12 | Ozark | Missouri | 29153 | 1697 | 55 |
2296094 | 2296094 | 2022-03-11 | Ozark | Missouri | 29153 | 1697 | 55 |
2292842 | 2292842 | 2022-03-10 | Ozark | Missouri | 29153 | 1697 | 55 |
2289590 | 2289590 | 2022-03-09 | Ozark | Missouri | 29153 | 1697 | 55 |
2285018 | 2285018 | 2022-03-08 | Conejos | Colorado | 8021 | 1697 | 52 |
2281766 | 2281766 | 2022-03-07 | Conejos | Colorado | 8021 | 1697 | 52 |
2263365 | 2263365 | 2022-03-01 | Mahnomen | Minnesota | 27087 | 1697 | 17 |
2261801 | 2261801 | 2022-02-28 | Williamsburg city | Virginia | 51830 | 1697 | 20 |
2240071 | 2240071 | 2022-02-22 | Greene | Iowa | 19073 | 1697 | 19 |
2236820 | 2236820 | 2022-02-21 | Greene | Iowa | 19073 | 1697 | 19 |
2233569 | 2233569 | 2022-02-20 | Greene | Iowa | 19073 | 1697 | 19 |
2230318 | 2230318 | 2022-02-19 | Greene | Iowa | 19073 | 1697 | 19 |
2227067 | 2227067 | 2022-02-18 | Greene | Iowa | 19073 | 1697 | 19 |
2223661 | 2223661 | 2022-02-17 | Pulaski | Illinois | 17153 | 1697 | 16 |
2223816 | 2223816 | 2022-02-17 | Greene | Iowa | 19073 | 1697 | 19 |
2220565 | 2220565 | 2022-02-16 | Greene | Iowa | 19073 | 1697 | 19 |
2216171 | 2216171 | 2022-02-14 | Bland | Virginia | 51021 | 1697 | 20 |
2169331 | 2169331 | 2022-01-31 | Madison | Montana | 30057 | 1697 | 20 |
2146347 | 2146347 | 2022-01-24 | Franklin | Mississippi | 28037 | 1697 | 34 |
2118744 | 2118744 | 2022-01-15 | Gilmer | West Virginia | 54021 | 1697 | 17 |
2111771 | 2111771 | 2022-01-13 | Blanco | Texas | 48031 | 1697 | 28 |
2104286 | 2104286 | 2022-01-11 | Sanders | Montana | 30089 | 1697 | 40 |
2099891 | 2099891 | 2022-01-10 | Seminole | Georgia | 13253 | 1697 | 26 |
2096643 | 2096643 | 2022-01-09 | Stewart | Georgia | 13259 | 1697 | 30 |
2093391 | 2093391 | 2022-01-08 | Stewart | Georgia | 13259 | 1697 | 30 |
2090139 | 2090139 | 2022-01-07 | Stewart | Georgia | 13259 | 1697 | 30 |
2086888 | 2086888 | 2022-01-06 | Stewart | Georgia | 13259 | 1697 | 30 |
2083636 | 2083636 | 2022-01-05 | Stewart | Georgia | 13259 | 1697 | 30 |
2067024 | 2067024 | 2021-12-31 | Perry | Arkansas | 5105 | 1697 | 26 |
2066499 | 2066499 | 2021-12-30 | Grand | Utah | 49019 | 1697 | 6 |
2066620 | 2066620 | 2021-12-30 | Nelson | Virginia | 51125 | 1697 | 24 |
2060042 | 2060042 | 2021-12-28 | Amelia | Virginia | 51007 | 1697 | 43 |
2056858 | 2056858 | 2021-12-27 | Lexington city | Virginia | 51678 | 1697 | 37 |
2029601 | 2029601 | 2021-12-19 | Phelps | Nebraska | 31137 | 1697 | 11 |
2026350 | 2026350 | 2021-12-18 | Phelps | Nebraska | 31137 | 1697 | 11 |
2023099 | 2023099 | 2021-12-17 | Phelps | Nebraska | 31137 | 1697 | 11 |
2012690 | 2012690 | 2021-12-14 | McLean | Kentucky | 21149 | 1697 | 40 |
1998152 | 1998152 | 2021-12-09 | Morris | Texas | 48343 | 1697 | 57 |
1989851 | 1989851 | 2021-12-07 | Wilson | Kansas | 20205 | 1697 | 34 |
1986601 | 1986601 | 2021-12-06 | Wilson | Kansas | 20205 | 1697 | 34 |
1988104 | 1988104 | 2021-12-06 | Lake | South Dakota | 46079 | 1697 | 20 |
1960168 | 1960168 | 2021-11-28 | Boundary | Idaho | 16021 | 1697 | 45 |
1960891 | 1960891 | 2021-11-28 | Luce | Michigan | 26095 | 1697 | 6 |
1956917 | 1956917 | 2021-11-27 | Boundary | Idaho | 16021 | 1697 | 45 |
1957640 | 1957640 | 2021-11-27 | Luce | Michigan | 26095 | 1697 | 6 |
1954389 | 1954389 | 2021-11-26 | Luce | Michigan | 26095 | 1697 | 6 |
1951138 | 1951138 | 2021-11-25 | Luce | Michigan | 26095 | 1697 | 6 |
1947887 | 1947887 | 2021-11-24 | Luce | Michigan | 26095 | 1697 | 6 |
1945272 | 1945272 | 2021-11-23 | Clay | North Carolina | 37043 | 1697 | 38 |
1924421 | 1924421 | 2021-11-17 | Franklin | Idaho | 16041 | 1697 | 23 |
1922502 | 1922502 | 2021-11-16 | Alleghany | North Carolina | 37005 | 1697 | 6 |
1919002 | 1919002 | 2021-11-15 | Rosebud | Montana | 30087 | 1697 | 58 |
1919867 | 1919867 | 2021-11-15 | Todd | South Dakota | 46121 | 1697 | 37 |
1915752 | 1915752 | 2021-11-14 | Rosebud | Montana | 30087 | 1697 | 58 |
1912502 | 1912502 | 2021-11-13 | Rosebud | Montana | 30087 | 1697 | 58 |
1909252 | 1909252 | 2021-11-12 | Rosebud | Montana | 30087 | 1697 | 58 |
1902987 | 1902987 | 2021-11-10 | Schuyler | New York | 36097 | 1697 | 19 |
1875933 | 1875933 | 2021-11-02 | Grundy | Iowa | 19075 | 1697 | 37 |
1872684 | 1872684 | 2021-11-01 | Grundy | Iowa | 19075 | 1697 | 37 |
1869435 | 1869435 | 2021-10-31 | Grundy | Iowa | 19075 | 1697 | 37 |
1866186 | 1866186 | 2021-10-30 | Grundy | Iowa | 19075 | 1697 | 37 |
1862937 | 1862937 | 2021-10-29 | Grundy | Iowa | 19075 | 1697 | 37 |
1859688 | 1859688 | 2021-10-28 | Grundy | Iowa | 19075 | 1697 | 37 |
1860277 | 1860277 | 2021-10-28 | Carroll | Mississippi | 28015 | 1697 | 40 |
1855817 | 1855817 | 2021-10-27 | Mono | California | 6051 | 1697 | 3 |
1856439 | 1856439 | 2021-10-27 | Grundy | Iowa | 19075 | 1697 | 37 |
1852434 | 1852434 | 2021-10-26 | Ketchikan Gateway Borough | Alaska | 2130 | 1697 | 9 |
1849242 | 1849242 | 2021-10-25 | Fulton | Arkansas | 5049 | 1697 | 62 |
1845992 | 1845992 | 2021-10-24 | Fulton | Arkansas | 5049 | 1697 | 62 |
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);