ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
212 rows where cases = 3067 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Florida 25
- Minnesota 19
- Tennessee 17
- Indiana 15
- Georgia 12
- Texas 12
- Virginia 11
- Kentucky 9
- Illinois 8
- Iowa 7
- Alabama 6
- Ohio 6
- Pennsylvania 6
- Colorado 5
- Idaho 4
- Louisiana 4
- Maryland 4
- Mississippi 4
- Massachusetts 3
- Missouri 3
- Nebraska 3
- New York 3
- Puerto Rico 3
- Wisconsin 3
- Arkansas 2
- California 2
- Kansas 2
- Maine 2
- North Carolina 2
- West Virginia 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499989 | 2499989 | 2022-05-13 | Charlton | Georgia | 13049 | 3067 | 62 |
2496731 | 2496731 | 2022-05-12 | Charlton | Georgia | 13049 | 3067 | 62 |
2493473 | 2493473 | 2022-05-11 | Charlton | Georgia | 13049 | 3067 | 62 |
2484676 | 2484676 | 2022-05-08 | Pope | Minnesota | 27121 | 3067 | 17 |
2481418 | 2481418 | 2022-05-07 | Pope | Minnesota | 27121 | 3067 | 17 |
2478160 | 2478160 | 2022-05-06 | Pope | Minnesota | 27121 | 3067 | 17 |
2376610 | 2376610 | 2022-04-05 | Pulaski | Indiana | 18131 | 3067 | 86 |
2373002 | 2373002 | 2022-04-04 | Charlton | Georgia | 13049 | 3067 | 62 |
2373358 | 2373358 | 2022-04-04 | Pulaski | Indiana | 18131 | 3067 | 86 |
2373927 | 2373927 | 2022-04-04 | Chippewa | Minnesota | 27023 | 3067 | 48 |
2370674 | 2370674 | 2022-04-03 | Chippewa | Minnesota | 27023 | 3067 | 48 |
2367421 | 2367421 | 2022-04-02 | Chippewa | Minnesota | 27023 | 3067 | 48 |
2364168 | 2364168 | 2022-04-01 | Chippewa | Minnesota | 27023 | 3067 | 48 |
2360914 | 2360914 | 2022-03-31 | Chippewa | Minnesota | 27023 | 3067 | 48 |
2357660 | 2357660 | 2022-03-30 | Chippewa | Minnesota | 27023 | 3067 | 48 |
2354407 | 2354407 | 2022-03-29 | Chippewa | Minnesota | 27023 | 3067 | 48 |
2351155 | 2351155 | 2022-03-28 | Chippewa | Minnesota | 27023 | 3067 | 48 |
2347902 | 2347902 | 2022-03-27 | Chippewa | Minnesota | 27023 | 3067 | 48 |
2344649 | 2344649 | 2022-03-26 | Chippewa | Minnesota | 27023 | 3067 | 48 |
2341396 | 2341396 | 2022-03-25 | Chippewa | Minnesota | 27023 | 3067 | 48 |
2334889 | 2334889 | 2022-03-23 | Chippewa | Minnesota | 27023 | 3067 | 47 |
2331635 | 2331635 | 2022-03-22 | Chippewa | Minnesota | 27023 | 3067 | 47 |
2311547 | 2311547 | 2022-03-16 | Pulaski | Indiana | 18131 | 3067 | 85 |
2308294 | 2308294 | 2022-03-15 | Pulaski | Indiana | 18131 | 3067 | 85 |
2305043 | 2305043 | 2022-03-14 | Pulaski | Indiana | 18131 | 3067 | 85 |
2291605 | 2291605 | 2022-03-10 | Franklin | Florida | 12037 | 3067 | 50 |
2288353 | 2288353 | 2022-03-09 | Franklin | Florida | 12037 | 3067 | 50 |
2285102 | 2285102 | 2022-03-08 | Franklin | Florida | 12037 | 3067 | 50 |
2281850 | 2281850 | 2022-03-07 | Franklin | Florida | 12037 | 3067 | 50 |
2278597 | 2278597 | 2022-03-06 | Franklin | Florida | 12037 | 3067 | 50 |
2275344 | 2275344 | 2022-03-05 | Franklin | Florida | 12037 | 3067 | 50 |
2272091 | 2272091 | 2022-03-04 | Franklin | Florida | 12037 | 3067 | 50 |
2268839 | 2268839 | 2022-03-03 | Franklin | Florida | 12037 | 3067 | 50 |
2265586 | 2265586 | 2022-03-02 | Franklin | Florida | 12037 | 3067 | 50 |
2262335 | 2262335 | 2022-03-01 | Franklin | Florida | 12037 | 3067 | 49 |
2259084 | 2259084 | 2022-02-28 | Franklin | Florida | 12037 | 3067 | 49 |
2255833 | 2255833 | 2022-02-27 | Franklin | Florida | 12037 | 3067 | 49 |
2252582 | 2252582 | 2022-02-26 | Franklin | Florida | 12037 | 3067 | 49 |
2249331 | 2249331 | 2022-02-25 | Franklin | Florida | 12037 | 3067 | 49 |
2213488 | 2213488 | 2022-02-14 | Crowley | Colorado | 8025 | 3067 | 28 |
2197434 | 2197434 | 2022-02-09 | Jasper | Georgia | 13159 | 3067 | 68 |
2183077 | 2183077 | 2022-02-04 | Loiza | Puerto Rico | 72087 | 3067 | |
2148149 | 2148149 | 2022-01-24 | Goshen | Wyoming | 56015 | 3067 | 53 |
2142896 | 2142896 | 2022-01-23 | Nantucket | Massachusetts | 25019 | 3067 | 0 |
2144055 | 2144055 | 2022-01-23 | Salinas | Puerto Rico | 72123 | 3067 | |
2139641 | 2139641 | 2022-01-22 | Nantucket | Massachusetts | 25019 | 3067 | 0 |
2135329 | 2135329 | 2022-01-21 | Van Buren | Arkansas | 5141 | 3067 | 46 |
2136385 | 2136385 | 2022-01-21 | Nantucket | Massachusetts | 25019 | 3067 | 0 |
2122781 | 2122781 | 2022-01-17 | Johnson | Illinois | 17087 | 3067 | 43 |
2119529 | 2119529 | 2022-01-16 | Johnson | Illinois | 17087 | 3067 | 43 |
2116277 | 2116277 | 2022-01-15 | Johnson | Illinois | 17087 | 3067 | 43 |
2113026 | 2113026 | 2022-01-14 | Johnson | Illinois | 17087 | 3067 | 43 |
2105187 | 2105187 | 2022-01-11 | Grundy | Tennessee | 47061 | 3067 | 64 |
2101936 | 2101936 | 2022-01-10 | Grundy | Tennessee | 47061 | 3067 | 64 |
2098685 | 2098685 | 2022-01-09 | Grundy | Tennessee | 47061 | 3067 | 64 |
2095433 | 2095433 | 2022-01-08 | Grundy | Tennessee | 47061 | 3067 | 64 |
2090815 | 2090815 | 2022-01-07 | Lincoln | Maine | 23015 | 3067 | 15 |
2092181 | 2092181 | 2022-01-07 | Grundy | Tennessee | 47061 | 3067 | 64 |
2088929 | 2088929 | 2022-01-06 | Grundy | Tennessee | 47061 | 3067 | 64 |
2085678 | 2085678 | 2022-01-05 | Grundy | Tennessee | 47061 | 3067 | 64 |
2080262 | 2080262 | 2022-01-04 | Banks | Georgia | 13011 | 3067 | 71 |
2082426 | 2082426 | 2022-01-04 | Grundy | Tennessee | 47061 | 3067 | 64 |
2075990 | 2075990 | 2022-01-02 | Andrews | Texas | 48003 | 3067 | 65 |
2072739 | 2072739 | 2022-01-01 | Andrews | Texas | 48003 | 3067 | 65 |
2069488 | 2069488 | 2021-12-31 | Andrews | Texas | 48003 | 3067 | 65 |
2066237 | 2066237 | 2021-12-30 | Andrews | Texas | 48003 | 3067 | 65 |
2054649 | 2054649 | 2021-12-27 | Vermillion | Indiana | 18165 | 3067 | 61 |
2012374 | 2012374 | 2021-12-14 | Perry | Indiana | 18123 | 3067 | 58 |
2014635 | 2014635 | 2021-12-14 | Prince Edward | Virginia | 51147 | 3067 | 53 |
2008846 | 2008846 | 2021-12-13 | Meriwether | Georgia | 13199 | 3067 | 120 |
2011124 | 2011124 | 2021-12-13 | Lamb | Texas | 48279 | 3067 | 97 |
2003379 | 2003379 | 2021-12-11 | Cooper | Missouri | 29053 | 3067 | 55 |
1992716 | 1992716 | 2021-12-08 | Clark | Illinois | 17023 | 3067 | 52 |
1993192 | 1993192 | 2021-12-08 | Morgan | Kentucky | 21175 | 3067 | 16 |
1987010 | 1987010 | 2021-12-06 | Wadena | Minnesota | 27159 | 3067 | 40 |
1985382 | 1985382 | 2021-12-05 | Radford city | Virginia | 51750 | 3067 | 36 |
1982132 | 1982132 | 2021-12-04 | Radford city | Virginia | 51750 | 3067 | 36 |
1977714 | 1977714 | 2021-12-03 | Essex | New York | 36031 | 3067 | 38 |
1978882 | 1978882 | 2021-12-03 | Radford city | Virginia | 51750 | 3067 | 36 |
1966877 | 1966877 | 2021-11-30 | Rush | Indiana | 18139 | 3067 | 32 |
1966909 | 1966909 | 2021-11-30 | Buchanan | Iowa | 19019 | 3067 | 41 |
1963657 | 1963657 | 2021-11-29 | Buchanan | Iowa | 19019 | 3067 | 41 |
1960406 | 1960406 | 2021-11-28 | Buchanan | Iowa | 19019 | 3067 | 41 |
1957155 | 1957155 | 2021-11-27 | Buchanan | Iowa | 19019 | 3067 | 41 |
1953904 | 1953904 | 2021-11-26 | Buchanan | Iowa | 19019 | 3067 | 41 |
1954322 | 1954322 | 2021-11-26 | Talbot | Maryland | 24041 | 3067 | 57 |
1950653 | 1950653 | 2021-11-25 | Buchanan | Iowa | 19019 | 3067 | 41 |
1951071 | 1951071 | 2021-11-25 | Talbot | Maryland | 24041 | 3067 | 57 |
1947402 | 1947402 | 2021-11-24 | Buchanan | Iowa | 19019 | 3067 | 41 |
1947820 | 1947820 | 2021-11-24 | Talbot | Maryland | 24041 | 3067 | 57 |
1944360 | 1944360 | 2021-11-23 | Breckinridge | Kentucky | 21027 | 3067 | 38 |
1939175 | 1939175 | 2021-11-21 | Wyoming | Pennsylvania | 42131 | 3067 | 68 |
1925968 | 1925968 | 2021-11-17 | Paulding | Ohio | 39125 | 3067 | 47 |
1904731 | 1904731 | 2021-11-11 | Union | Florida | 12125 | 3067 | 96 |
1901481 | 1901481 | 2021-11-10 | Union | Florida | 12125 | 3067 | 96 |
1898231 | 1898231 | 2021-11-09 | Union | Florida | 12125 | 3067 | 96 |
1894981 | 1894981 | 2021-11-08 | Union | Florida | 12125 | 3067 | 96 |
1891731 | 1891731 | 2021-11-07 | Union | Florida | 12125 | 3067 | 96 |
1888481 | 1888481 | 2021-11-06 | Union | Florida | 12125 | 3067 | 96 |
1885231 | 1885231 | 2021-11-05 | Union | Florida | 12125 | 3067 | 96 |
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);