ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
417 rows where cases = 1340 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 33
- Kentucky 32
- South Dakota 29
- Georgia 23
- Missouri 22
- Iowa 19
- Puerto Rico 18
- Illinois 14
- North Carolina 14
- Oklahoma 14
- Virginia 12
- Alabama 11
- Arkansas 11
- Kansas 11
- Michigan 11
- Tennessee 11
- Minnesota 10
- South Carolina 10
- North Dakota 9
- Indiana 8
- Mississippi 7
- Montana 7
- Alaska 6
- Idaho 6
- New York 6
- West Virginia 6
- Connecticut 5
- Nebraska 5
- Utah 5
- Wisconsin 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501312 | 2501312 | 2022-05-13 | Nemaha | Nebraska | 31127 | 1340 | 20 |
2501533 | 2501533 | 2022-05-13 | Hyde | North Carolina | 37095 | 1340 | 13 |
2502082 | 2502082 | 2022-05-13 | Kingsbury | South Dakota | 46077 | 1340 | 22 |
2498275 | 2498275 | 2022-05-12 | Hyde | North Carolina | 37095 | 1340 | 13 |
2498824 | 2498824 | 2022-05-12 | Kingsbury | South Dakota | 46077 | 1340 | 22 |
2495017 | 2495017 | 2022-05-11 | Hyde | North Carolina | 37095 | 1340 | 13 |
2495566 | 2495566 | 2022-05-11 | Kingsbury | South Dakota | 46077 | 1340 | 22 |
2453685 | 2453685 | 2022-04-28 | Cumberland | Virginia | 51049 | 1340 | 27 |
2429981 | 2429981 | 2022-04-21 | Sioux | North Dakota | 38085 | 1340 | 19 |
2426725 | 2426725 | 2022-04-20 | Sioux | North Dakota | 38085 | 1340 | 19 |
2423469 | 2423469 | 2022-04-19 | Sioux | North Dakota | 38085 | 1340 | 19 |
2423929 | 2423929 | 2022-04-19 | McCook | South Dakota | 46087 | 1340 | 31 |
2420212 | 2420212 | 2022-04-18 | Sioux | North Dakota | 38085 | 1340 | 19 |
2420673 | 2420673 | 2022-04-18 | McCook | South Dakota | 46087 | 1340 | 31 |
2416957 | 2416957 | 2022-04-17 | Sioux | North Dakota | 38085 | 1340 | 19 |
2417417 | 2417417 | 2022-04-17 | McCook | South Dakota | 46087 | 1340 | 31 |
2413701 | 2413701 | 2022-04-16 | Sioux | North Dakota | 38085 | 1340 | 19 |
2414161 | 2414161 | 2022-04-16 | McCook | South Dakota | 46087 | 1340 | 31 |
2410445 | 2410445 | 2022-04-15 | Sioux | North Dakota | 38085 | 1340 | 19 |
2410905 | 2410905 | 2022-04-15 | McCook | South Dakota | 46087 | 1340 | 31 |
2407649 | 2407649 | 2022-04-14 | McCook | South Dakota | 46087 | 1340 | 31 |
2404393 | 2404393 | 2022-04-13 | McCook | South Dakota | 46087 | 1340 | 31 |
2401138 | 2401138 | 2022-04-12 | McCook | South Dakota | 46087 | 1340 | 31 |
2397883 | 2397883 | 2022-04-11 | McCook | South Dakota | 46087 | 1340 | 31 |
2394628 | 2394628 | 2022-04-10 | McCook | South Dakota | 46087 | 1340 | 31 |
2391372 | 2391372 | 2022-04-09 | McCook | South Dakota | 46087 | 1340 | 31 |
2388116 | 2388116 | 2022-04-08 | McCook | South Dakota | 46087 | 1340 | 31 |
2384861 | 2384861 | 2022-04-07 | McCook | South Dakota | 46087 | 1340 | 31 |
2381606 | 2381606 | 2022-04-06 | McCook | South Dakota | 46087 | 1340 | 31 |
2378351 | 2378351 | 2022-04-05 | McCook | South Dakota | 46087 | 1340 | 31 |
2375097 | 2375097 | 2022-04-04 | McCook | South Dakota | 46087 | 1340 | 31 |
2371845 | 2371845 | 2022-04-03 | McCook | South Dakota | 46087 | 1340 | 31 |
2368592 | 2368592 | 2022-04-02 | McCook | South Dakota | 46087 | 1340 | 31 |
2365339 | 2365339 | 2022-04-01 | McCook | South Dakota | 46087 | 1340 | 31 |
2362086 | 2362086 | 2022-03-31 | McCook | South Dakota | 46087 | 1340 | 31 |
2358832 | 2358832 | 2022-03-30 | McCook | South Dakota | 46087 | 1340 | 31 |
2287270 | 2287270 | 2022-03-08 | McCook | South Dakota | 46087 | 1340 | 31 |
2270881 | 2270881 | 2022-03-03 | Maunabo | Puerto Rico | 72095 | 1340 | |
2265227 | 2265227 | 2022-03-01 | Crook | Wyoming | 56011 | 1340 | 26 |
2255579 | 2255579 | 2022-02-27 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 1340 | 6 |
2252328 | 2252328 | 2022-02-26 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 1340 | 6 |
2249077 | 2249077 | 2022-02-25 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 1340 | 6 |
2240213 | 2240213 | 2022-02-22 | Republic | Kansas | 20157 | 1340 | 14 |
2236962 | 2236962 | 2022-02-21 | Republic | Kansas | 20157 | 1340 | 14 |
2216890 | 2216890 | 2022-02-15 | Calhoun | Georgia | 13037 | 1340 | 22 |
2213639 | 2213639 | 2022-02-14 | Calhoun | Georgia | 13037 | 1340 | 22 |
2206252 | 2206252 | 2022-02-11 | Lynn | Texas | 48305 | 1340 | 34 |
2202999 | 2202999 | 2022-02-10 | Lynn | Texas | 48305 | 1340 | 34 |
2188300 | 2188300 | 2022-02-06 | Owsley | Kentucky | 21189 | 1340 | 23 |
2185047 | 2185047 | 2022-02-05 | Owsley | Kentucky | 21189 | 1340 | 23 |
2181795 | 2181795 | 2022-02-04 | Owsley | Kentucky | 21189 | 1340 | 23 |
2157141 | 2157141 | 2022-01-27 | Brule | South Dakota | 46015 | 1340 | 18 |
2126949 | 2126949 | 2022-01-18 | Maries | Missouri | 29125 | 1340 | 26 |
2127578 | 2127578 | 2022-01-18 | Kiowa | Oklahoma | 40075 | 1340 | 46 |
2124326 | 2124326 | 2022-01-17 | Kiowa | Oklahoma | 40075 | 1340 | 46 |
2121074 | 2121074 | 2022-01-16 | Kiowa | Oklahoma | 40075 | 1340 | 46 |
2117822 | 2117822 | 2022-01-15 | Kiowa | Oklahoma | 40075 | 1340 | 46 |
2114571 | 2114571 | 2022-01-14 | Kiowa | Oklahoma | 40075 | 1340 | 46 |
2111319 | 2111319 | 2022-01-13 | Kiowa | Oklahoma | 40075 | 1340 | 46 |
2108067 | 2108067 | 2022-01-12 | Kiowa | Oklahoma | 40075 | 1340 | 46 |
2086133 | 2086133 | 2022-01-05 | Northampton | Virginia | 51131 | 1340 | 49 |
2077299 | 2077299 | 2022-01-03 | Schuyler | Illinois | 17169 | 1340 | 26 |
2057944 | 2057944 | 2021-12-28 | Greene | Iowa | 19073 | 1340 | 18 |
2058203 | 2058203 | 2021-12-28 | Nicholas | Kentucky | 21181 | 1340 | 29 |
2058687 | 2058687 | 2021-12-28 | Ozark | Missouri | 29153 | 1340 | 46 |
2054695 | 2054695 | 2021-12-27 | Greene | Iowa | 19073 | 1340 | 18 |
2051445 | 2051445 | 2021-12-26 | Greene | Iowa | 19073 | 1340 | 18 |
2048195 | 2048195 | 2021-12-25 | Greene | Iowa | 19073 | 1340 | 18 |
2044945 | 2044945 | 2021-12-24 | Greene | Iowa | 19073 | 1340 | 18 |
2041696 | 2041696 | 2021-12-23 | Greene | Iowa | 19073 | 1340 | 18 |
2038446 | 2038446 | 2021-12-22 | Greene | Iowa | 19073 | 1340 | 18 |
2036981 | 2036981 | 2021-12-21 | Van Buren | Tennessee | 47175 | 1340 | 33 |
2037004 | 2037004 | 2021-12-21 | Blanco | Texas | 48031 | 1340 | 28 |
2033731 | 2033731 | 2021-12-20 | Van Buren | Tennessee | 47175 | 1340 | 33 |
2020740 | 2020740 | 2021-12-16 | Archer | Texas | 48009 | 1340 | 24 |
1983950 | 1983950 | 2021-12-05 | St. Clair | Missouri | 29185 | 1340 | 27 |
1963880 | 1963880 | 2021-11-29 | Crittenden | Kentucky | 21055 | 1340 | 37 |
1938270 | 1938270 | 2021-11-21 | Claiborne | Mississippi | 28021 | 1340 | 38 |
1938511 | 1938511 | 2021-11-21 | Valley | Montana | 30105 | 1340 | 29 |
1935020 | 1935020 | 2021-11-20 | Claiborne | Mississippi | 28021 | 1340 | 38 |
1935261 | 1935261 | 2021-11-20 | Valley | Montana | 30105 | 1340 | 29 |
1931770 | 1931770 | 2021-11-19 | Claiborne | Mississippi | 28021 | 1340 | 38 |
1932011 | 1932011 | 2021-11-19 | Valley | Montana | 30105 | 1340 | 29 |
1932383 | 1932383 | 2021-11-19 | Pembina | North Dakota | 38067 | 1340 | 13 |
1928760 | 1928760 | 2021-11-18 | Valley | Montana | 30105 | 1340 | 29 |
1917828 | 1917828 | 2021-11-15 | Macon | Georgia | 13193 | 1340 | 44 |
1919287 | 1919287 | 2021-11-15 | Graham | North Carolina | 37075 | 1340 | 28 |
1914578 | 1914578 | 2021-11-14 | Macon | Georgia | 13193 | 1340 | 44 |
1911328 | 1911328 | 2021-11-13 | Macon | Georgia | 13193 | 1340 | 44 |
1908079 | 1908079 | 2021-11-12 | Macon | Georgia | 13193 | 1340 | 44 |
1889664 | 1889664 | 2021-11-06 | Monroe | Missouri | 29137 | 1340 | 13 |
1883171 | 1883171 | 2021-11-04 | Oregon | Missouri | 29149 | 1340 | 11 |
1871909 | 1871909 | 2021-11-01 | Sumter | Alabama | 1119 | 1340 | 38 |
1868660 | 1868660 | 2021-10-31 | Sumter | Alabama | 1119 | 1340 | 38 |
1865411 | 1865411 | 2021-10-30 | Sumter | Alabama | 1119 | 1340 | 38 |
1867091 | 1867091 | 2021-10-30 | Phelps | Nebraska | 31137 | 1340 | 10 |
1862162 | 1862162 | 2021-10-29 | Sumter | Alabama | 1119 | 1340 | 38 |
1863842 | 1863842 | 2021-10-29 | Phelps | Nebraska | 31137 | 1340 | 10 |
1856991 | 1856991 | 2021-10-27 | Pipestone | Minnesota | 27117 | 1340 | 27 |
1853619 | 1853619 | 2021-10-26 | Crawford | Michigan | 26039 | 1340 | 16 |
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);