ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
310 rows where cases = 2036 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 32
- Texas 28
- Arkansas 23
- Georgia 23
- Missouri 16
- Indiana 14
- Nebraska 13
- Kentucky 12
- Virginia 12
- Illinois 11
- Tennessee 11
- Michigan 8
- North Carolina 7
- Oklahoma 7
- South Dakota 7
- Idaho 6
- Mississippi 6
- Wisconsin 6
- Alabama 5
- California 5
- Ohio 5
- Oregon 5
- Florida 4
- Louisiana 4
- New Mexico 4
- Pennsylvania 4
- Colorado 3
- Kansas 3
- Minnesota 3
- Puerto Rico 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2445079 | 2445079 | 2022-04-26 | Palo Alto | Iowa | 19147 | 2036 | 38 |
2441823 | 2441823 | 2022-04-25 | Palo Alto | Iowa | 19147 | 2036 | 38 |
2438567 | 2438567 | 2022-04-24 | Palo Alto | Iowa | 19147 | 2036 | 38 |
2435311 | 2435311 | 2022-04-23 | Palo Alto | Iowa | 19147 | 2036 | 38 |
2432055 | 2432055 | 2022-04-22 | Palo Alto | Iowa | 19147 | 2036 | 38 |
2428799 | 2428799 | 2022-04-21 | Palo Alto | Iowa | 19147 | 2036 | 38 |
2425543 | 2425543 | 2022-04-20 | Palo Alto | Iowa | 19147 | 2036 | 38 |
2422287 | 2422287 | 2022-04-19 | Palo Alto | Iowa | 19147 | 2036 | 38 |
2419031 | 2419031 | 2022-04-18 | Palo Alto | Iowa | 19147 | 2036 | 38 |
2415775 | 2415775 | 2022-04-17 | Palo Alto | Iowa | 19147 | 2036 | 38 |
2412519 | 2412519 | 2022-04-16 | Palo Alto | Iowa | 19147 | 2036 | 38 |
2409263 | 2409263 | 2022-04-15 | Palo Alto | Iowa | 19147 | 2036 | 38 |
2406007 | 2406007 | 2022-04-14 | Palo Alto | Iowa | 19147 | 2036 | 38 |
2406982 | 2406982 | 2022-04-14 | Sierra | New Mexico | 35051 | 2036 | 70 |
2402751 | 2402751 | 2022-04-13 | Palo Alto | Iowa | 19147 | 2036 | 38 |
2403726 | 2403726 | 2022-04-13 | Sierra | New Mexico | 35051 | 2036 | 70 |
2399497 | 2399497 | 2022-04-12 | Palo Alto | Iowa | 19147 | 2036 | 38 |
2400471 | 2400471 | 2022-04-12 | Sierra | New Mexico | 35051 | 2036 | 70 |
2396241 | 2396241 | 2022-04-11 | Palo Alto | Iowa | 19147 | 2036 | 38 |
2397216 | 2397216 | 2022-04-11 | Sierra | New Mexico | 35051 | 2036 | 70 |
2392986 | 2392986 | 2022-04-10 | Palo Alto | Iowa | 19147 | 2036 | 38 |
2389730 | 2389730 | 2022-04-09 | Palo Alto | Iowa | 19147 | 2036 | 38 |
2386474 | 2386474 | 2022-04-08 | Palo Alto | Iowa | 19147 | 2036 | 38 |
2383220 | 2383220 | 2022-04-07 | Palo Alto | Iowa | 19147 | 2036 | 38 |
2379965 | 2379965 | 2022-04-06 | Palo Alto | Iowa | 19147 | 2036 | 38 |
2331137 | 2331137 | 2022-03-22 | Howard | Iowa | 19089 | 2036 | 34 |
2327885 | 2327885 | 2022-03-21 | Howard | Iowa | 19089 | 2036 | 34 |
2324632 | 2324632 | 2022-03-20 | Howard | Iowa | 19089 | 2036 | 34 |
2321378 | 2321378 | 2022-03-19 | Howard | Iowa | 19089 | 2036 | 34 |
2318124 | 2318124 | 2022-03-18 | Howard | Iowa | 19089 | 2036 | 34 |
2314871 | 2314871 | 2022-03-17 | Howard | Iowa | 19089 | 2036 | 34 |
2311618 | 2311618 | 2022-03-16 | Howard | Iowa | 19089 | 2036 | 34 |
2308049 | 2308049 | 2022-03-15 | Terrell | Georgia | 13273 | 2036 | 61 |
2304798 | 2304798 | 2022-03-14 | Terrell | Georgia | 13273 | 2036 | 60 |
2301546 | 2301546 | 2022-03-13 | Terrell | Georgia | 13273 | 2036 | 60 |
2298294 | 2298294 | 2022-03-12 | Terrell | Georgia | 13273 | 2036 | 60 |
2295042 | 2295042 | 2022-03-11 | Terrell | Georgia | 13273 | 2036 | 60 |
2265528 | 2265528 | 2022-03-02 | Lincoln | Colorado | 8073 | 2036 | 9 |
2251656 | 2251656 | 2022-02-25 | Clay | Texas | 48077 | 2036 | 31 |
2226408 | 2226408 | 2022-02-18 | Searcy | Arkansas | 5129 | 2036 | 41 |
2217271 | 2217271 | 2022-02-15 | Warren | Indiana | 18171 | 2036 | 24 |
2219632 | 2219632 | 2022-02-15 | Webster | West Virginia | 54101 | 2036 | 28 |
2210389 | 2210389 | 2022-02-13 | Candler | Georgia | 13043 | 2036 | 91 |
2207136 | 2207136 | 2022-02-12 | Candler | Georgia | 13043 | 2036 | 91 |
2203883 | 2203883 | 2022-02-11 | Candler | Georgia | 13043 | 2036 | 91 |
2195309 | 2195309 | 2022-02-08 | St. Clair | Missouri | 29185 | 2036 | 31 |
2180463 | 2180463 | 2022-02-03 | Northumberland | Virginia | 51133 | 2036 | 41 |
2170706 | 2170706 | 2022-01-31 | Northampton | Virginia | 51131 | 2036 | 52 |
2157519 | 2157519 | 2022-01-27 | Terry | Texas | 48445 | 2036 | 79 |
2142258 | 2142258 | 2022-01-23 | Valley | Idaho | 16085 | 2036 | 13 |
2139003 | 2139003 | 2022-01-22 | Valley | Idaho | 16085 | 2036 | 13 |
2105198 | 2105198 | 2022-01-11 | Houston | Tennessee | 47083 | 2036 | 53 |
2101947 | 2101947 | 2022-01-10 | Houston | Tennessee | 47083 | 2036 | 53 |
2097124 | 2097124 | 2022-01-09 | Wilson | Kansas | 20205 | 2036 | 35 |
2098696 | 2098696 | 2022-01-09 | Houston | Tennessee | 47083 | 2036 | 53 |
2093872 | 2093872 | 2022-01-08 | Wilson | Kansas | 20205 | 2036 | 35 |
2095444 | 2095444 | 2022-01-08 | Houston | Tennessee | 47083 | 2036 | 53 |
2090620 | 2090620 | 2022-01-07 | Wilson | Kansas | 20205 | 2036 | 35 |
2092192 | 2092192 | 2022-01-07 | Houston | Tennessee | 47083 | 2036 | 53 |
2088940 | 2088940 | 2022-01-06 | Houston | Tennessee | 47083 | 2036 | 53 |
2085689 | 2085689 | 2022-01-05 | Houston | Tennessee | 47083 | 2036 | 53 |
2082103 | 2082103 | 2022-01-04 | Curry | Oregon | 41015 | 2036 | 40 |
2082437 | 2082437 | 2022-01-04 | Houston | Tennessee | 47083 | 2036 | 53 |
2074123 | 2074123 | 2022-01-02 | Newton | Indiana | 18111 | 2036 | 58 |
2070872 | 2070872 | 2022-01-01 | Newton | Indiana | 18111 | 2036 | 58 |
2067621 | 2067621 | 2021-12-31 | Newton | Indiana | 18111 | 2036 | 58 |
2064370 | 2064370 | 2021-12-30 | Newton | Indiana | 18111 | 2036 | 58 |
2056115 | 2056115 | 2021-12-27 | Morrow | Oregon | 41049 | 2036 | 25 |
2035880 | 2035880 | 2021-12-21 | Cedar | Missouri | 29039 | 2036 | 42 |
1992222 | 1992222 | 2021-12-08 | Chicot | Arkansas | 5017 | 2036 | 47 |
1994578 | 1994578 | 2021-12-08 | Charles Mix | South Dakota | 46023 | 2036 | 28 |
1995065 | 1995065 | 2021-12-08 | Dickenson | Virginia | 51051 | 2036 | 30 |
1988968 | 1988968 | 2021-12-07 | Bradley | Arkansas | 5011 | 2036 | 41 |
1988971 | 1988971 | 2021-12-07 | Chicot | Arkansas | 5017 | 2036 | 47 |
1991047 | 1991047 | 2021-12-07 | Love | Oklahoma | 40085 | 2036 | 30 |
1985721 | 1985721 | 2021-12-06 | Chicot | Arkansas | 5017 | 2036 | 47 |
1987796 | 1987796 | 2021-12-06 | Love | Oklahoma | 40085 | 2036 | 30 |
1982471 | 1982471 | 2021-12-05 | Chicot | Arkansas | 5017 | 2036 | 47 |
1984546 | 1984546 | 2021-12-05 | Love | Oklahoma | 40085 | 2036 | 30 |
1981296 | 1981296 | 2021-12-04 | Love | Oklahoma | 40085 | 2036 | 30 |
1978046 | 1978046 | 2021-12-03 | Love | Oklahoma | 40085 | 2036 | 30 |
1974796 | 1974796 | 2021-12-02 | Love | Oklahoma | 40085 | 2036 | 29 |
1971547 | 1971547 | 2021-12-01 | Love | Oklahoma | 40085 | 2036 | 29 |
1962072 | 1962072 | 2021-11-28 | Butte | South Dakota | 46019 | 2036 | 34 |
1958821 | 1958821 | 2021-11-27 | Butte | South Dakota | 46019 | 2036 | 34 |
1955570 | 1955570 | 2021-11-26 | Butte | South Dakota | 46019 | 2036 | 34 |
1952319 | 1952319 | 2021-11-25 | Butte | South Dakota | 46019 | 2036 | 34 |
1949068 | 1949068 | 2021-11-24 | Butte | South Dakota | 46019 | 2036 | 34 |
1931874 | 1931874 | 2021-11-19 | Dent | Missouri | 29065 | 2036 | 62 |
1933001 | 1933001 | 2021-11-19 | Camp | Texas | 48063 | 2036 | 67 |
1929750 | 1929750 | 2021-11-18 | Camp | Texas | 48063 | 2036 | 67 |
1926500 | 1926500 | 2021-11-17 | Camp | Texas | 48063 | 2036 | 67 |
1923250 | 1923250 | 2021-11-16 | Camp | Texas | 48063 | 2036 | 67 |
1920001 | 1920001 | 2021-11-15 | Camp | Texas | 48063 | 2036 | 67 |
1916751 | 1916751 | 2021-11-14 | Camp | Texas | 48063 | 2036 | 67 |
1913501 | 1913501 | 2021-11-13 | Camp | Texas | 48063 | 2036 | 67 |
1908192 | 1908192 | 2021-11-12 | Shoshone | Idaho | 16079 | 2036 | 61 |
1904943 | 1904943 | 2021-11-11 | Shoshone | Idaho | 16079 | 2036 | 61 |
1901693 | 1901693 | 2021-11-10 | Shoshone | Idaho | 16079 | 2036 | 61 |
1898443 | 1898443 | 2021-11-09 | Shoshone | Idaho | 16079 | 2036 | 61 |
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);