ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
249 rows where cases = 2428 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Ohio 29
- Texas 24
- Iowa 16
- Kansas 13
- Puerto Rico 12
- Missouri 11
- Kentucky 10
- South Dakota 10
- Virginia 10
- Georgia 9
- Indiana 9
- Arkansas 8
- Michigan 8
- Illinois 7
- Washington 7
- Louisiana 6
- Nebraska 5
- Tennessee 5
- California 4
- Pennsylvania 4
- Idaho 3
- Maine 3
- Maryland 3
- Mississippi 3
- Oregon 3
- South Carolina 3
- Wisconsin 3
- Florida 2
- Minnesota 2
- New Mexico 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2496923 | 2496923 | 2022-05-12 | Brown | Illinois | 17009 | 2428 | 21 |
2493665 | 2493665 | 2022-05-11 | Brown | Illinois | 17009 | 2428 | 21 |
2446731 | 2446731 | 2022-04-26 | Roberts | South Dakota | 46109 | 2428 | 53 |
2443476 | 2443476 | 2022-04-25 | Roberts | South Dakota | 46109 | 2428 | 53 |
2440220 | 2440220 | 2022-04-24 | Roberts | South Dakota | 46109 | 2428 | 53 |
2436964 | 2436964 | 2022-04-23 | Roberts | South Dakota | 46109 | 2428 | 53 |
2433708 | 2433708 | 2022-04-22 | Roberts | South Dakota | 46109 | 2428 | 53 |
2430452 | 2430452 | 2022-04-21 | Roberts | South Dakota | 46109 | 2428 | 53 |
2427196 | 2427196 | 2022-04-20 | Roberts | South Dakota | 46109 | 2428 | 53 |
2262913 | 2262913 | 2022-03-01 | Doniphan | Kansas | 20043 | 2428 | 32 |
2259662 | 2259662 | 2022-02-28 | Doniphan | Kansas | 20043 | 2428 | 32 |
2222482 | 2222482 | 2022-02-16 | Jim Hogg | Texas | 48247 | 2428 | 20 |
2218965 | 2218965 | 2022-02-15 | Dewey | South Dakota | 46041 | 2428 | 38 |
2213830 | 2213830 | 2022-02-14 | Valley | Idaho | 16085 | 2428 | 16 |
2201285 | 2201285 | 2022-02-10 | Lee | Kentucky | 21129 | 2428 | 45 |
2199319 | 2199319 | 2022-02-09 | Ciales | Puerto Rico | 72039 | 2428 | |
2196065 | 2196065 | 2022-02-08 | Ciales | Puerto Rico | 72039 | 2428 | |
2192811 | 2192811 | 2022-02-07 | Ciales | Puerto Rico | 72039 | 2428 | |
2173976 | 2173976 | 2022-02-01 | Richmond | Virginia | 51159 | 2428 | 17 |
2168221 | 2168221 | 2022-01-31 | Turner | Georgia | 13287 | 2428 | 50 |
2149044 | 2149044 | 2022-01-25 | Shelby | Iowa | 19165 | 2428 | 46 |
2145792 | 2145792 | 2022-01-24 | Shelby | Iowa | 19165 | 2428 | 46 |
2142537 | 2142537 | 2022-01-23 | Shelby | Iowa | 19165 | 2428 | 46 |
2143248 | 2143248 | 2022-01-23 | Ripley | Missouri | 29181 | 2428 | 53 |
2139282 | 2139282 | 2022-01-22 | Shelby | Iowa | 19165 | 2428 | 46 |
2136026 | 2136026 | 2022-01-21 | Shelby | Iowa | 19165 | 2428 | 46 |
2132774 | 2132774 | 2022-01-20 | Shelby | Iowa | 19165 | 2428 | 46 |
2129521 | 2129521 | 2022-01-19 | Shelby | Iowa | 19165 | 2428 | 46 |
2126244 | 2126244 | 2022-01-18 | Lyon | Iowa | 19119 | 2428 | 44 |
2122992 | 2122992 | 2022-01-17 | Lyon | Iowa | 19119 | 2428 | 44 |
2119740 | 2119740 | 2022-01-16 | Lyon | Iowa | 19119 | 2428 | 44 |
2116488 | 2116488 | 2022-01-15 | Lyon | Iowa | 19119 | 2428 | 44 |
2113237 | 2113237 | 2022-01-14 | Lyon | Iowa | 19119 | 2428 | 44 |
2109260 | 2109260 | 2022-01-13 | Desha | Arkansas | 5041 | 2428 | 35 |
2109985 | 2109985 | 2022-01-13 | Lyon | Iowa | 19119 | 2428 | 44 |
2106734 | 2106734 | 2022-01-12 | Lyon | Iowa | 19119 | 2428 | 44 |
2107371 | 2107371 | 2022-01-12 | Webster | Mississippi | 28155 | 2428 | 51 |
2107455 | 2107455 | 2022-01-12 | Pemiscot | Missouri | 29155 | 2428 | 60 |
2087392 | 2087392 | 2022-01-06 | Carroll | Kentucky | 21041 | 2428 | 38 |
2081194 | 2081194 | 2022-01-04 | Aitkin | Minnesota | 27001 | 2428 | 54 |
2063264 | 2063264 | 2021-12-29 | Unknown | Utah | 2428 | 56 | |
2054929 | 2054929 | 2021-12-27 | Leslie | Kentucky | 21131 | 2428 | 37 |
2037795 | 2037795 | 2021-12-22 | Van Buren | Arkansas | 5141 | 2428 | 44 |
2038936 | 2038936 | 2021-12-22 | Unknown | Michigan | 2428 | 22 | |
2040506 | 2040506 | 2021-12-22 | Millard | Utah | 49027 | 2428 | 31 |
2031023 | 2031023 | 2021-12-19 | Buffalo | Wisconsin | 55011 | 2428 | 9 |
2027772 | 2027772 | 2021-12-18 | Buffalo | Wisconsin | 55011 | 2428 | 9 |
2024521 | 2024521 | 2021-12-17 | Buffalo | Wisconsin | 55011 | 2428 | 9 |
2019075 | 2019075 | 2021-12-16 | Osage | Kansas | 20139 | 2428 | 39 |
2015825 | 2015825 | 2021-12-15 | Osage | Kansas | 20139 | 2428 | 39 |
2013995 | 2013995 | 2021-12-14 | Naranjito | Puerto Rico | 72105 | 2428 | |
2007225 | 2007225 | 2021-12-12 | Monroe | Ohio | 39111 | 2428 | 62 |
1997734 | 1997734 | 2021-12-09 | Manati | Puerto Rico | 72091 | 2428 | |
1986795 | 1986795 | 2021-12-06 | Knox | Maine | 23013 | 2428 | 17 |
1983545 | 1983545 | 2021-12-05 | Knox | Maine | 23013 | 2428 | 17 |
1980295 | 1980295 | 2021-12-04 | Knox | Maine | 23013 | 2428 | 17 |
1980636 | 1980636 | 2021-12-04 | Gasconade | Missouri | 29073 | 2428 | 80 |
1982205 | 1982205 | 2021-12-04 | Braxton | West Virginia | 54007 | 2428 | 25 |
1965487 | 1965487 | 2021-11-29 | Bandera | Texas | 48019 | 2428 | 61 |
1962235 | 1962235 | 2021-11-28 | Bandera | Texas | 48019 | 2428 | 61 |
1958984 | 1958984 | 2021-11-27 | Bandera | Texas | 48019 | 2428 | 61 |
1955733 | 1955733 | 2021-11-26 | Bandera | Texas | 48019 | 2428 | 61 |
1952482 | 1952482 | 2021-11-25 | Bandera | Texas | 48019 | 2428 | 61 |
1949231 | 1949231 | 2021-11-24 | Bandera | Texas | 48019 | 2428 | 61 |
1945980 | 1945980 | 2021-11-23 | Bandera | Texas | 48019 | 2428 | 61 |
1942729 | 1942729 | 2021-11-22 | Bandera | Texas | 48019 | 2428 | 61 |
1917748 | 1917748 | 2021-11-15 | Brooks | Georgia | 13027 | 2428 | 71 |
1905947 | 1905947 | 2021-11-11 | Ste. Genevieve | Missouri | 29186 | 2428 | 29 |
1901354 | 1901354 | 2021-11-10 | Crowley | Colorado | 8025 | 2428 | 24 |
1902698 | 1902698 | 2021-11-10 | Ste. Genevieve | Missouri | 29186 | 2428 | 29 |
1897530 | 1897530 | 2021-11-08 | Appomattox | Virginia | 51011 | 2428 | 36 |
1887229 | 1887229 | 2021-11-05 | Moca | Puerto Rico | 72099 | 2428 | |
1882496 | 1882496 | 2021-11-04 | Atchison | Kansas | 20005 | 2428 | 25 |
1883979 | 1883979 | 2021-11-04 | Moca | Puerto Rico | 72099 | 2428 | |
1879247 | 1879247 | 2021-11-03 | Atchison | Kansas | 20005 | 2428 | 25 |
1860600 | 1860600 | 2021-10-28 | Saline | Nebraska | 31151 | 2428 | 6 |
1857351 | 1857351 | 2021-10-27 | Saline | Nebraska | 31151 | 2428 | 6 |
1848190 | 1848190 | 2021-10-24 | Aguada | Puerto Rico | 72003 | 2428 | |
1830904 | 1830904 | 2021-10-19 | Manistee | Michigan | 26101 | 2428 | 35 |
1826989 | 1826989 | 2021-10-18 | Ford | Illinois | 17053 | 2428 | 67 |
1827655 | 1827655 | 2021-10-18 | Manistee | Michigan | 26101 | 2428 | 35 |
1810137 | 1810137 | 2021-10-13 | Crenshaw | Alabama | 1041 | 2428 | 75 |
1803146 | 1803146 | 2021-10-10 | Madison | Texas | 48313 | 2428 | 43 |
1799897 | 1799897 | 2021-10-09 | Madison | Texas | 48313 | 2428 | 43 |
1781384 | 1781384 | 2021-10-04 | Rabun | Georgia | 13241 | 2428 | 58 |
1768663 | 1768663 | 2021-09-30 | Vermillion | Indiana | 18165 | 2428 | 51 |
1741005 | 1741005 | 2021-09-21 | Isabela | Puerto Rico | 72071 | 2428 | |
1741162 | 1741162 | 2021-09-21 | Union | South Dakota | 46127 | 2428 | 43 |
1735992 | 1735992 | 2021-09-20 | Bond | Illinois | 17005 | 2428 | 29 |
1737756 | 1737756 | 2021-09-20 | Isabela | Puerto Rico | 72071 | 2428 | |
1724003 | 1724003 | 2021-09-16 | Wright | Missouri | 29229 | 2428 | 44 |
1705302 | 1705302 | 2021-09-10 | San Sebastian | Puerto Rico | 72131 | 2428 | |
1652449 | 1652449 | 2021-08-25 | Clinton | Missouri | 29049 | 2428 | 70 |
1642493 | 1642493 | 2021-08-22 | Otsego | Michigan | 26137 | 2428 | 41 |
1639243 | 1639243 | 2021-08-21 | Otsego | Michigan | 26137 | 2428 | 41 |
1635993 | 1635993 | 2021-08-20 | Otsego | Michigan | 26137 | 2428 | 41 |
1631570 | 1631570 | 2021-08-19 | Grant | Arkansas | 5053 | 2428 | 40 |
1628012 | 1628012 | 2021-08-17 | Island | Washington | 53029 | 2428 | 32 |
1622742 | 1622742 | 2021-08-16 | Hart | Kentucky | 21099 | 2428 | 54 |
1607028 | 1607028 | 2021-08-11 | Perry | Missouri | 29157 | 2428 | 30 |
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);