ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
190 rows where deaths = 660 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Tennessee 15
- Florida 14
- Colorado 12
- Texas 11
- Michigan 10
- California 9
- Indiana 9
- Pennsylvania 9
- Delaware 8
- Illinois 8
- Arkansas 7
- Connecticut 7
- Oklahoma 7
- Nevada 6
- Washington 6
- Missouri 5
- Virginia 5
- Georgia 4
- Maryland 4
- New Jersey 4
- Oregon 4
- District of Columbia 3
- Nebraska 3
- North Carolina 3
- Utah 3
- Wisconsin 3
- Arizona 2
- Minnesota 2
- New York 2
- Louisiana 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2496631 | 2496631 | 2022-05-12 | New London | Connecticut | 9011 | 57958 | 660 |
2493373 | 2493373 | 2022-05-11 | New London | Connecticut | 9011 | 57803 | 660 |
2490115 | 2490115 | 2022-05-10 | New London | Connecticut | 9011 | 57604 | 660 |
2490159 | 2490159 | 2022-05-10 | Leon | Florida | 12073 | 85724 | 660 |
2486858 | 2486858 | 2022-05-09 | New London | Connecticut | 9011 | 57454 | 660 |
2486902 | 2486902 | 2022-05-09 | Leon | Florida | 12073 | 85724 | 660 |
2483600 | 2483600 | 2022-05-08 | New London | Connecticut | 9011 | 57081 | 660 |
2483644 | 2483644 | 2022-05-08 | Leon | Florida | 12073 | 85724 | 660 |
2480342 | 2480342 | 2022-05-07 | New London | Connecticut | 9011 | 57081 | 660 |
2480386 | 2480386 | 2022-05-07 | Leon | Florida | 12073 | 85724 | 660 |
2477084 | 2477084 | 2022-05-06 | New London | Connecticut | 9011 | 57081 | 660 |
2477128 | 2477128 | 2022-05-06 | Leon | Florida | 12073 | 85724 | 660 |
2473870 | 2473870 | 2022-05-05 | Leon | Florida | 12073 | 85273 | 660 |
2470613 | 2470613 | 2022-05-04 | Leon | Florida | 12073 | 85273 | 660 |
2422149 | 2422149 | 2022-04-19 | Hamilton | Indiana | 18057 | 81980 | 660 |
2418893 | 2418893 | 2022-04-18 | Hamilton | Indiana | 18057 | 81980 | 660 |
2415637 | 2415637 | 2022-04-17 | Hamilton | Indiana | 18057 | 81880 | 660 |
2412381 | 2412381 | 2022-04-16 | Hamilton | Indiana | 18057 | 81880 | 660 |
2409125 | 2409125 | 2022-04-15 | Hamilton | Indiana | 18057 | 81880 | 660 |
2405869 | 2405869 | 2022-04-14 | Hamilton | Indiana | 18057 | 81880 | 660 |
2402614 | 2402614 | 2022-04-13 | Hamilton | Indiana | 18057 | 81880 | 660 |
2324256 | 2324256 | 2022-03-20 | Henry | Georgia | 13151 | 57568 | 660 |
2321002 | 2321002 | 2022-03-19 | Henry | Georgia | 13151 | 57568 | 660 |
2317748 | 2317748 | 2022-03-18 | Henry | Georgia | 13151 | 57568 | 660 |
2313071 | 2313071 | 2022-03-16 | Fayette | Pennsylvania | 42051 | 30878 | 660 |
2313648 | 2313648 | 2022-03-16 | Wichita | Texas | 48485 | 33968 | 660 |
2308806 | 2308806 | 2022-03-15 | Kalamazoo | Michigan | 26077 | 58638 | 660 |
2310395 | 2310395 | 2022-03-15 | Wichita | Texas | 48485 | 33968 | 660 |
2305555 | 2305555 | 2022-03-14 | Kalamazoo | Michigan | 26077 | 58638 | 660 |
2307142 | 2307142 | 2022-03-14 | Wichita | Texas | 48485 | 33968 | 660 |
2302303 | 2302303 | 2022-03-13 | Kalamazoo | Michigan | 26077 | 58587 | 660 |
2303891 | 2303891 | 2022-03-13 | Wichita | Texas | 48485 | 33968 | 660 |
2299051 | 2299051 | 2022-03-12 | Kalamazoo | Michigan | 26077 | 58587 | 660 |
2300639 | 2300639 | 2022-03-12 | Wichita | Texas | 48485 | 33968 | 660 |
2295799 | 2295799 | 2022-03-11 | Kalamazoo | Michigan | 26077 | 58587 | 660 |
2280512 | 2280512 | 2022-03-06 | Marion | Oregon | 41047 | 68389 | 660 |
2281465 | 2281465 | 2022-03-06 | Racine | Wisconsin | 55101 | 55909 | 660 |
2277259 | 2277259 | 2022-03-05 | Marion | Oregon | 41047 | 68389 | 660 |
2278212 | 2278212 | 2022-03-05 | Racine | Wisconsin | 55101 | 55909 | 660 |
2274006 | 2274006 | 2022-03-04 | Marion | Oregon | 41047 | 68389 | 660 |
2274959 | 2274959 | 2022-03-04 | Racine | Wisconsin | 55101 | 55909 | 660 |
2270753 | 2270753 | 2022-03-03 | Marion | Oregon | 41047 | 68349 | 660 |
2244783 | 2244783 | 2022-02-23 | Franklin | Pennsylvania | 42055 | 39933 | 660 |
2241851 | 2241851 | 2022-02-22 | Sumner | Tennessee | 47165 | 52168 | 660 |
2238600 | 2238600 | 2022-02-21 | Sumner | Tennessee | 47165 | 52168 | 660 |
2239107 | 2239107 | 2022-02-21 | Kanawha | West Virginia | 54039 | 46210 | 660 |
2235349 | 2235349 | 2022-02-20 | Sumner | Tennessee | 47165 | 52168 | 660 |
2232098 | 2232098 | 2022-02-19 | Sumner | Tennessee | 47165 | 52168 | 660 |
2228847 | 2228847 | 2022-02-18 | Sumner | Tennessee | 47165 | 52168 | 660 |
2225596 | 2225596 | 2022-02-17 | Sumner | Tennessee | 47165 | 52168 | 660 |
2220039 | 2220039 | 2022-02-16 | Weld | Colorado | 8123 | 79722 | 660 |
2222345 | 2222345 | 2022-02-16 | Sumner | Tennessee | 47165 | 52168 | 660 |
2216788 | 2216788 | 2022-02-15 | Weld | Colorado | 8123 | 79562 | 660 |
2213537 | 2213537 | 2022-02-14 | Weld | Colorado | 8123 | 79477 | 660 |
2210285 | 2210285 | 2022-02-13 | Weld | Colorado | 8123 | 79224 | 660 |
2207032 | 2207032 | 2022-02-12 | Weld | Colorado | 8123 | 79224 | 660 |
2203779 | 2203779 | 2022-02-11 | Weld | Colorado | 8123 | 79224 | 660 |
2200526 | 2200526 | 2022-02-10 | Weld | Colorado | 8123 | 79019 | 660 |
2199718 | 2199718 | 2022-02-09 | Johnson | Texas | 48251 | 40913 | 660 |
2156492 | 2156492 | 2022-01-27 | Doña Ana | New Mexico | 35013 | 56294 | 660 |
2148378 | 2148378 | 2022-01-25 | Monterey | California | 6053 | 73307 | 660 |
2150435 | 2150435 | 2022-01-25 | Beaver | Pennsylvania | 42007 | 36506 | 660 |
2150442 | 2150442 | 2022-01-25 | Cambria | Pennsylvania | 42021 | 31505 | 660 |
2145126 | 2145126 | 2022-01-24 | Monterey | California | 6053 | 72854 | 660 |
2143598 | 2143598 | 2022-01-23 | Forsyth | North Carolina | 37067 | 78890 | 660 |
2140343 | 2140343 | 2022-01-22 | Forsyth | North Carolina | 37067 | 78890 | 660 |
2137087 | 2137087 | 2022-01-21 | Forsyth | North Carolina | 37067 | 78890 | 660 |
2127554 | 2127554 | 2022-01-18 | Cleveland | Oklahoma | 40027 | 56962 | 660 |
2124302 | 2124302 | 2022-01-17 | Cleveland | Oklahoma | 40027 | 56962 | 660 |
2121050 | 2121050 | 2022-01-16 | Cleveland | Oklahoma | 40027 | 56962 | 660 |
2117798 | 2117798 | 2022-01-15 | Cleveland | Oklahoma | 40027 | 56962 | 660 |
2114547 | 2114547 | 2022-01-14 | Cleveland | Oklahoma | 40027 | 56962 | 660 |
2111295 | 2111295 | 2022-01-13 | Cleveland | Oklahoma | 40027 | 56962 | 660 |
2108043 | 2108043 | 2022-01-12 | Cleveland | Oklahoma | 40027 | 56962 | 660 |
2104067 | 2104067 | 2022-01-11 | Hinds | Mississippi | 28049 | 42974 | 660 |
2097726 | 2097726 | 2022-01-09 | St. Louis city | Missouri | 29510 | 45572 | 660 |
2099224 | 2099224 | 2022-01-09 | Yakima | Washington | 53077 | 50642 | 660 |
2094474 | 2094474 | 2022-01-08 | St. Louis city | Missouri | 29510 | 45308 | 660 |
2095973 | 2095973 | 2022-01-08 | Yakima | Washington | 53077 | 50642 | 660 |
2092721 | 2092721 | 2022-01-07 | Yakima | Washington | 53077 | 50642 | 660 |
2089469 | 2089469 | 2022-01-06 | Yakima | Washington | 53077 | 50120 | 660 |
2057407 | 2057407 | 2021-12-28 | Pueblo | Colorado | 8101 | 31211 | 660 |
2058440 | 2058440 | 2021-12-28 | Anoka | Minnesota | 27003 | 70860 | 660 |
2055191 | 2055191 | 2021-12-27 | Anoka | Minnesota | 27003 | 70230 | 660 |
2035066 | 2035066 | 2021-12-21 | Winnebago | Illinois | 17201 | 51901 | 660 |
2008677 | 2008677 | 2021-12-13 | Sussex | Delaware | 10005 | 39329 | 660 |
2005426 | 2005426 | 2021-12-12 | Sussex | Delaware | 10005 | 39229 | 660 |
2002175 | 2002175 | 2021-12-11 | Sussex | Delaware | 10005 | 39052 | 660 |
1998925 | 1998925 | 2021-12-10 | Sussex | Delaware | 10005 | 38922 | 660 |
1995674 | 1995674 | 2021-12-09 | Sussex | Delaware | 10005 | 38747 | 660 |
1992423 | 1992423 | 2021-12-08 | Sussex | Delaware | 10005 | 38557 | 660 |
1989172 | 1989172 | 2021-12-07 | Sussex | Delaware | 10005 | 38414 | 660 |
1990731 | 1990731 | 2021-12-07 | Oneida | New York | 36065 | 34426 | 660 |
1937055 | 1937055 | 2021-11-21 | Merced | California | 6047 | 44990 | 660 |
1937533 | 1937533 | 2021-11-21 | St. Clair | Illinois | 17163 | 41721 | 660 |
1933805 | 1933805 | 2021-11-20 | Merced | California | 6047 | 44990 | 660 |
1934283 | 1934283 | 2021-11-20 | St. Clair | Illinois | 17163 | 41721 | 660 |
1930448 | 1930448 | 2021-11-19 | Navajo | Arizona | 4017 | 23653 | 660 |
1930553 | 1930553 | 2021-11-19 | Merced | California | 6047 | 44990 | 660 |
1931032 | 1931032 | 2021-11-19 | St. Clair | Illinois | 17163 | 41721 | 660 |
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);