ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
454 rows where cases = 1271 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 41
- Texas 41
- Virginia 28
- Oklahoma 21
- Arkansas 20
- Wisconsin 20
- Colorado 17
- Georgia 17
- Missouri 17
- Illinois 16
- Alabama 15
- Kentucky 15
- Montana 15
- Nebraska 14
- Indiana 13
- Mississippi 13
- Puerto Rico 12
- South Dakota 10
- West Virginia 10
- Michigan 8
- Minnesota 8
- North Carolina 8
- Tennessee 8
- Washington 8
- Kansas 6
- Alaska 5
- Pennsylvania 5
- Wyoming 5
- California 4
- Florida 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500466 | 2500466 | 2022-05-13 | Wayne | Iowa | 19185 | 1271 | 33 |
2497208 | 2497208 | 2022-05-12 | Wayne | Iowa | 19185 | 1271 | 33 |
2493950 | 2493950 | 2022-05-11 | Wayne | Iowa | 19185 | 1271 | 33 |
2487230 | 2487230 | 2022-05-09 | Scott | Illinois | 17171 | 1271 | 12 |
2475893 | 2475893 | 2022-05-05 | Las Marias | Puerto Rico | 72083 | 1271 | |
2443914 | 2443914 | 2022-04-25 | Covington city | Virginia | 51580 | 1271 | 26 |
2427388 | 2427388 | 2022-04-20 | Garza | Texas | 48169 | 1271 | 28 |
2424132 | 2424132 | 2022-04-19 | Garza | Texas | 48169 | 1271 | 28 |
2406757 | 2406757 | 2022-04-14 | Broadwater | Montana | 30007 | 1271 | 18 |
2403501 | 2403501 | 2022-04-13 | Broadwater | Montana | 30007 | 1271 | 18 |
2400246 | 2400246 | 2022-04-12 | Broadwater | Montana | 30007 | 1271 | 18 |
2396991 | 2396991 | 2022-04-11 | Broadwater | Montana | 30007 | 1271 | 18 |
2393736 | 2393736 | 2022-04-10 | Broadwater | Montana | 30007 | 1271 | 18 |
2390480 | 2390480 | 2022-04-09 | Broadwater | Montana | 30007 | 1271 | 18 |
2387224 | 2387224 | 2022-04-08 | Broadwater | Montana | 30007 | 1271 | 18 |
2383969 | 2383969 | 2022-04-07 | Broadwater | Montana | 30007 | 1271 | 18 |
2380714 | 2380714 | 2022-04-06 | Broadwater | Montana | 30007 | 1271 | 18 |
2372015 | 2372015 | 2022-04-03 | Crane | Texas | 48103 | 1271 | 24 |
2368762 | 2368762 | 2022-04-02 | Crane | Texas | 48103 | 1271 | 24 |
2365509 | 2365509 | 2022-04-01 | Crane | Texas | 48103 | 1271 | 24 |
2362256 | 2362256 | 2022-03-31 | Crane | Texas | 48103 | 1271 | 24 |
2359002 | 2359002 | 2022-03-30 | Crane | Texas | 48103 | 1271 | 24 |
2355552 | 2355552 | 2022-03-29 | Day | South Dakota | 46037 | 1271 | 35 |
2355748 | 2355748 | 2022-03-29 | Crane | Texas | 48103 | 1271 | 24 |
2352042 | 2352042 | 2022-03-28 | Unknown | Oklahoma | 1271 | 1 | |
2352299 | 2352299 | 2022-03-28 | Day | South Dakota | 46037 | 1271 | 35 |
2352495 | 2352495 | 2022-03-28 | Crane | Texas | 48103 | 1271 | 24 |
2348790 | 2348790 | 2022-03-27 | Unknown | Oklahoma | 1271 | 1 | |
2349047 | 2349047 | 2022-03-27 | Day | South Dakota | 46037 | 1271 | 35 |
2349243 | 2349243 | 2022-03-27 | Crane | Texas | 48103 | 1271 | 24 |
2345537 | 2345537 | 2022-03-26 | Unknown | Oklahoma | 1271 | 1 | |
2345794 | 2345794 | 2022-03-26 | Day | South Dakota | 46037 | 1271 | 35 |
2345990 | 2345990 | 2022-03-26 | Crane | Texas | 48103 | 1271 | 24 |
2342541 | 2342541 | 2022-03-25 | Day | South Dakota | 46037 | 1271 | 35 |
2342737 | 2342737 | 2022-03-25 | Crane | Texas | 48103 | 1271 | 24 |
2339288 | 2339288 | 2022-03-24 | Day | South Dakota | 46037 | 1271 | 35 |
2339484 | 2339484 | 2022-03-24 | Crane | Texas | 48103 | 1271 | 24 |
2336034 | 2336034 | 2022-03-23 | Day | South Dakota | 46037 | 1271 | 35 |
2282113 | 2282113 | 2022-03-07 | Alexander | Illinois | 17003 | 1271 | 15 |
2262142 | 2262142 | 2022-03-01 | Lafayette | Arkansas | 5073 | 1271 | 28 |
2264174 | 2264174 | 2022-03-01 | Greer | Oklahoma | 40055 | 1271 | 30 |
2258891 | 2258891 | 2022-02-28 | Lafayette | Arkansas | 5073 | 1271 | 28 |
2260484 | 2260484 | 2022-02-28 | Pierce | Nebraska | 31139 | 1271 | 21 |
2260924 | 2260924 | 2022-02-28 | Greer | Oklahoma | 40055 | 1271 | 30 |
2255640 | 2255640 | 2022-02-27 | Lafayette | Arkansas | 5073 | 1271 | 28 |
2257673 | 2257673 | 2022-02-27 | Greer | Oklahoma | 40055 | 1271 | 30 |
2252389 | 2252389 | 2022-02-26 | Lafayette | Arkansas | 5073 | 1271 | 28 |
2254422 | 2254422 | 2022-02-26 | Greer | Oklahoma | 40055 | 1271 | 30 |
2251171 | 2251171 | 2022-02-25 | Greer | Oklahoma | 40055 | 1271 | 30 |
2246722 | 2246722 | 2022-02-24 | Scott | Kansas | 20171 | 1271 | 34 |
2247920 | 2247920 | 2022-02-24 | Greer | Oklahoma | 40055 | 1271 | 30 |
2243471 | 2243471 | 2022-02-23 | Scott | Kansas | 20171 | 1271 | 34 |
2244669 | 2244669 | 2022-02-23 | Greer | Oklahoma | 40055 | 1271 | 30 |
2173444 | 2173444 | 2022-02-01 | Kingsbury | South Dakota | 46077 | 1271 | 20 |
2133265 | 2133265 | 2022-01-20 | Mahnomen | Minnesota | 27087 | 1271 | 17 |
2126983 | 2126983 | 2022-01-18 | Shannon | Missouri | 29203 | 1271 | 30 |
2110690 | 2110690 | 2022-01-13 | Maries | Missouri | 29125 | 1271 | 25 |
2111809 | 2111809 | 2022-01-13 | Crosby | Texas | 48107 | 1271 | 42 |
2102883 | 2102883 | 2022-01-11 | Conejos | Colorado | 8021 | 1271 | 46 |
2095540 | 2095540 | 2022-01-08 | Coleman | Texas | 48083 | 1271 | 59 |
2063889 | 2063889 | 2021-12-30 | Lake | Colorado | 8065 | 1271 | 2 |
2060840 | 2060840 | 2021-12-29 | Lincoln | Georgia | 13181 | 1271 | 33 |
2061880 | 2061880 | 2021-12-29 | Clark | Missouri | 29045 | 1271 | 28 |
2058855 | 2058855 | 2021-12-28 | Richardson | Nebraska | 31147 | 1271 | 24 |
2038780 | 2038780 | 2021-12-22 | St. Helena | Louisiana | 22091 | 1271 | 19 |
2035530 | 2035530 | 2021-12-21 | St. Helena | Louisiana | 22091 | 1271 | 19 |
2029274 | 2029274 | 2021-12-19 | Wilkin | Minnesota | 27167 | 1271 | 16 |
2030919 | 2030919 | 2021-12-19 | Williamsburg city | Virginia | 51830 | 1271 | 13 |
2026023 | 2026023 | 2021-12-18 | Wilkin | Minnesota | 27167 | 1271 | 16 |
2027668 | 2027668 | 2021-12-18 | Williamsburg city | Virginia | 51830 | 1271 | 13 |
2022772 | 2022772 | 2021-12-17 | Wilkin | Minnesota | 27167 | 1271 | 16 |
2024417 | 2024417 | 2021-12-17 | Williamsburg city | Virginia | 51830 | 1271 | 13 |
2012503 | 2012503 | 2021-12-14 | Worth | Iowa | 19195 | 1271 | 10 |
2009252 | 2009252 | 2021-12-13 | Worth | Iowa | 19195 | 1271 | 10 |
2009721 | 2009721 | 2021-12-13 | Lac qui Parle | Minnesota | 27073 | 1271 | 26 |
2010278 | 2010278 | 2021-12-13 | Camden | North Carolina | 37029 | 1271 | 9 |
2011060 | 2011060 | 2021-12-13 | Floyd | Texas | 48153 | 1271 | 40 |
2006001 | 2006001 | 2021-12-12 | Worth | Iowa | 19195 | 1271 | 10 |
2002750 | 2002750 | 2021-12-11 | Worth | Iowa | 19195 | 1271 | 10 |
1999500 | 1999500 | 2021-12-10 | Worth | Iowa | 19195 | 1271 | 10 |
1996249 | 1996249 | 2021-12-09 | Worth | Iowa | 19195 | 1271 | 10 |
1992998 | 1992998 | 2021-12-08 | Worth | Iowa | 19195 | 1271 | 10 |
1993613 | 1993613 | 2021-12-08 | Caldwell | Missouri | 29025 | 1271 | 26 |
1993643 | 1993643 | 2021-12-08 | Hickory | Missouri | 29085 | 1271 | 43 |
1989674 | 1989674 | 2021-12-07 | Davis | Iowa | 19051 | 1271 | 25 |
1990286 | 1990286 | 2021-12-07 | Franklin | Mississippi | 28037 | 1271 | 30 |
1986424 | 1986424 | 2021-12-06 | Davis | Iowa | 19051 | 1271 | 25 |
1983174 | 1983174 | 2021-12-05 | Davis | Iowa | 19051 | 1271 | 25 |
1983655 | 1983655 | 2021-12-05 | Montmorency | Michigan | 26119 | 1271 | 37 |
1979924 | 1979924 | 2021-12-04 | Davis | Iowa | 19051 | 1271 | 25 |
1980405 | 1980405 | 2021-12-04 | Montmorency | Michigan | 26119 | 1271 | 37 |
1976674 | 1976674 | 2021-12-03 | Davis | Iowa | 19051 | 1271 | 25 |
1977155 | 1977155 | 2021-12-03 | Montmorency | Michigan | 26119 | 1271 | 37 |
1973425 | 1973425 | 2021-12-02 | Davis | Iowa | 19051 | 1271 | 25 |
1969655 | 1969655 | 2021-12-01 | San Miguel | Colorado | 8113 | 1271 | 5 |
1970175 | 1970175 | 2021-12-01 | Davis | Iowa | 19051 | 1271 | 25 |
1944950 | 1944950 | 2021-11-23 | Sullivan | Missouri | 29211 | 1271 | 17 |
1923743 | 1923743 | 2021-11-16 | Webster | West Virginia | 54101 | 1271 | 23 |
1917330 | 1917330 | 2021-11-14 | Johnson | Wyoming | 56019 | 1271 | 16 |
1914080 | 1914080 | 2021-11-13 | Johnson | Wyoming | 56019 | 1271 | 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);