ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
251 rows where cases = 2471 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 32
- Kentucky 27
- Missouri 19
- Georgia 15
- Louisiana 12
- Texas 12
- Indiana 11
- Wisconsin 11
- Arkansas 10
- Florida 8
- Illinois 8
- Kansas 8
- Mississippi 8
- Michigan 7
- North Carolina 7
- Ohio 7
- Puerto Rico 7
- Minnesota 6
- Tennessee 6
- Virginia 5
- New York 4
- South Carolina 3
- West Virginia 3
- Alabama 2
- New Hampshire 2
- Oklahoma 2
- Arizona 1
- Colorado 1
- Idaho 1
- Montana 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2461561 | 2461561 | 2022-05-01 | Livingston | Kentucky | 21139 | 2471 | 61 |
2458305 | 2458305 | 2022-04-30 | Livingston | Kentucky | 21139 | 2471 | 61 |
2455049 | 2455049 | 2022-04-29 | Livingston | Kentucky | 21139 | 2471 | 61 |
2451793 | 2451793 | 2022-04-28 | Livingston | Kentucky | 21139 | 2471 | 61 |
2448537 | 2448537 | 2022-04-27 | Livingston | Kentucky | 21139 | 2471 | 61 |
2445281 | 2445281 | 2022-04-26 | Livingston | Kentucky | 21139 | 2471 | 61 |
2442025 | 2442025 | 2022-04-25 | Livingston | Kentucky | 21139 | 2471 | 61 |
2398326 | 2398326 | 2022-04-11 | Charlotte | Virginia | 51037 | 2471 | 45 |
2384727 | 2384727 | 2022-04-07 | Lajas | Puerto Rico | 72079 | 2471 | |
2370406 | 2370406 | 2022-04-03 | Livingston | Kentucky | 21139 | 2471 | 59 |
2367153 | 2367153 | 2022-04-02 | Livingston | Kentucky | 21139 | 2471 | 59 |
2363900 | 2363900 | 2022-04-01 | Livingston | Kentucky | 21139 | 2471 | 59 |
2360646 | 2360646 | 2022-03-31 | Livingston | Kentucky | 21139 | 2471 | 59 |
2357392 | 2357392 | 2022-03-30 | Livingston | Kentucky | 21139 | 2471 | 59 |
2354139 | 2354139 | 2022-03-29 | Livingston | Kentucky | 21139 | 2471 | 59 |
2350887 | 2350887 | 2022-03-28 | Livingston | Kentucky | 21139 | 2471 | 59 |
2308232 | 2308232 | 2022-03-15 | Benton | Indiana | 18007 | 2471 | 21 |
2257846 | 2257846 | 2022-02-27 | Ciales | Puerto Rico | 72039 | 2471 | |
2247246 | 2247246 | 2022-02-24 | Bollinger | Missouri | 29017 | 2471 | 36 |
2237402 | 2237402 | 2022-02-21 | Yellow Medicine | Minnesota | 27173 | 2471 | 28 |
2234151 | 2234151 | 2022-02-20 | Yellow Medicine | Minnesota | 27173 | 2471 | 28 |
2230900 | 2230900 | 2022-02-19 | Yellow Medicine | Minnesota | 27173 | 2471 | 28 |
2227649 | 2227649 | 2022-02-18 | Yellow Medicine | Minnesota | 27173 | 2471 | 28 |
2220871 | 2220871 | 2022-02-16 | East Carroll | Louisiana | 22035 | 2471 | 35 |
2217315 | 2217315 | 2022-02-15 | Grundy | Iowa | 19075 | 2471 | 40 |
2217620 | 2217620 | 2022-02-15 | East Carroll | Louisiana | 22035 | 2471 | 35 |
2214064 | 2214064 | 2022-02-14 | Grundy | Iowa | 19075 | 2471 | 40 |
2214369 | 2214369 | 2022-02-14 | East Carroll | Louisiana | 22035 | 2471 | 35 |
2210812 | 2210812 | 2022-02-13 | Grundy | Iowa | 19075 | 2471 | 40 |
2207559 | 2207559 | 2022-02-12 | Grundy | Iowa | 19075 | 2471 | 40 |
2204306 | 2204306 | 2022-02-11 | Grundy | Iowa | 19075 | 2471 | 40 |
2201053 | 2201053 | 2022-02-10 | Grundy | Iowa | 19075 | 2471 | 40 |
2197799 | 2197799 | 2022-02-09 | Grundy | Iowa | 19075 | 2471 | 40 |
2198452 | 2198452 | 2022-02-09 | Tunica | Mississippi | 28143 | 2471 | 43 |
2155025 | 2155025 | 2022-01-27 | Lafayette | Florida | 12067 | 2471 | 52 |
2151772 | 2151772 | 2022-01-26 | Lafayette | Florida | 12067 | 2471 | 52 |
2148520 | 2148520 | 2022-01-25 | Lafayette | Florida | 12067 | 2471 | 52 |
2145268 | 2145268 | 2022-01-24 | Lafayette | Florida | 12067 | 2471 | 52 |
2142013 | 2142013 | 2022-01-23 | Lafayette | Florida | 12067 | 2471 | 52 |
2138758 | 2138758 | 2022-01-22 | Lafayette | Florida | 12067 | 2471 | 52 |
2135502 | 2135502 | 2022-01-21 | Lafayette | Florida | 12067 | 2471 | 52 |
2127396 | 2127396 | 2022-01-18 | Barnes | North Dakota | 38003 | 2471 | 41 |
2089375 | 2089375 | 2022-01-06 | Martinsville city | Virginia | 51690 | 2471 | 100 |
2089526 | 2089526 | 2022-01-06 | Ashland | Wisconsin | 55003 | 2471 | 28 |
2060542 | 2060542 | 2021-12-29 | Van Buren | Arkansas | 5141 | 2471 | 45 |
2035207 | 2035207 | 2021-12-21 | Iowa | Iowa | 19095 | 2471 | 36 |
2031957 | 2031957 | 2021-12-20 | Iowa | Iowa | 19095 | 2471 | 36 |
2028706 | 2028706 | 2021-12-19 | Iowa | Iowa | 19095 | 2471 | 36 |
2025455 | 2025455 | 2021-12-18 | Iowa | Iowa | 19095 | 2471 | 36 |
2026991 | 2026991 | 2021-12-18 | Manati | Puerto Rico | 72091 | 2471 | |
2022204 | 2022204 | 2021-12-17 | Iowa | Iowa | 19095 | 2471 | 36 |
2018953 | 2018953 | 2021-12-16 | Iowa | Iowa | 19095 | 2471 | 36 |
2015703 | 2015703 | 2021-12-15 | Iowa | Iowa | 19095 | 2471 | 36 |
2011227 | 2011227 | 2021-12-13 | Wilbarger | Texas | 48487 | 2471 | 69 |
2007087 | 2007087 | 2021-12-12 | Polk | North Carolina | 37149 | 2471 | 49 |
2007976 | 2007976 | 2021-12-12 | Wilbarger | Texas | 48487 | 2471 | 69 |
2003836 | 2003836 | 2021-12-11 | Polk | North Carolina | 37149 | 2471 | 49 |
2000585 | 2000585 | 2021-12-10 | Polk | North Carolina | 37149 | 2471 | 49 |
1997689 | 1997689 | 2021-12-09 | Aguada | Puerto Rico | 72003 | 2471 | |
1993131 | 1993131 | 2021-12-08 | Clinton | Kentucky | 21053 | 2471 | 37 |
1993630 | 1993630 | 2021-12-08 | Dallas | Missouri | 29059 | 2471 | 57 |
1994438 | 1994438 | 2021-12-08 | Aguada | Puerto Rico | 72003 | 2471 | |
1989880 | 1989880 | 2021-12-07 | Clinton | Kentucky | 21053 | 2471 | 37 |
1992062 | 1992062 | 2021-12-07 | Rusk | Wisconsin | 55107 | 2471 | 37 |
1988811 | 1988811 | 2021-12-06 | Rusk | Wisconsin | 55107 | 2471 | 37 |
1985561 | 1985561 | 2021-12-05 | Rusk | Wisconsin | 55107 | 2471 | 37 |
1982311 | 1982311 | 2021-12-04 | Rusk | Wisconsin | 55107 | 2471 | 37 |
1979061 | 1979061 | 2021-12-03 | Rusk | Wisconsin | 55107 | 2471 | 37 |
1966361 | 1966361 | 2021-11-30 | Crowley | Colorado | 8025 | 2471 | 27 |
1942644 | 1942644 | 2021-11-22 | Decatur | Tennessee | 47039 | 2471 | 44 |
1894737 | 1894737 | 2021-11-08 | Howard | Arkansas | 5061 | 2471 | 38 |
1879996 | 1879996 | 2021-11-03 | Park | Montana | 30067 | 2471 | 29 |
1876001 | 1876001 | 2021-11-02 | Bourbon | Kansas | 20011 | 2471 | 43 |
1872735 | 1872735 | 2021-11-01 | Unknown | Iowa | 2471 | 0 | |
1872752 | 1872752 | 2021-11-01 | Bourbon | Kansas | 20011 | 2471 | 43 |
1869486 | 1869486 | 2021-10-31 | Unknown | Iowa | 2471 | 0 | |
1870956 | 1870956 | 2021-10-31 | Corozal | Puerto Rico | 72047 | 2471 | |
1866237 | 1866237 | 2021-10-30 | Unknown | Iowa | 2471 | 0 | |
1867707 | 1867707 | 2021-10-30 | Corozal | Puerto Rico | 72047 | 2471 | |
1863148 | 1863148 | 2021-10-29 | Green | Kentucky | 21087 | 2471 | 34 |
1859899 | 1859899 | 2021-10-28 | Green | Kentucky | 21087 | 2471 | 34 |
1855157 | 1855157 | 2021-10-26 | Nolan | Texas | 48353 | 2471 | 78 |
1842761 | 1842761 | 2021-10-23 | Madison | Arkansas | 5087 | 2471 | 38 |
1832873 | 1832873 | 2021-10-20 | Cleburne | Alabama | 1029 | 2471 | 60 |
1834117 | 1834117 | 2021-10-20 | Charlevoix | Michigan | 26029 | 2471 | 31 |
1807011 | 1807011 | 2021-10-12 | Izard | Arkansas | 5065 | 2471 | 54 |
1807697 | 1807697 | 2021-10-12 | Fayette | Iowa | 19065 | 2471 | 47 |
1804446 | 1804446 | 2021-10-11 | Fayette | Iowa | 19065 | 2471 | 47 |
1801197 | 1801197 | 2021-10-10 | Fayette | Iowa | 19065 | 2471 | 47 |
1797948 | 1797948 | 2021-10-09 | Fayette | Iowa | 19065 | 2471 | 47 |
1794699 | 1794699 | 2021-10-08 | Fayette | Iowa | 19065 | 2471 | 47 |
1791451 | 1791451 | 2021-10-07 | Fayette | Iowa | 19065 | 2471 | 47 |
1788202 | 1788202 | 2021-10-06 | Fayette | Iowa | 19065 | 2471 | 47 |
1755897 | 1755897 | 2021-09-26 | Breckinridge | Kentucky | 21027 | 2471 | 24 |
1752649 | 1752649 | 2021-09-25 | Breckinridge | Kentucky | 21027 | 2471 | 24 |
1749400 | 1749400 | 2021-09-24 | Breckinridge | Kentucky | 21027 | 2471 | 24 |
1749999 | 1749999 | 2021-09-24 | Wright | Missouri | 29229 | 2471 | 46 |
1740204 | 1740204 | 2021-09-21 | Moniteau | Missouri | 29135 | 2471 | 38 |
1734049 | 1734049 | 2021-09-19 | Avery | North Carolina | 37011 | 2471 | 28 |
1730458 | 1730458 | 2021-09-18 | Morgan | Missouri | 29141 | 2471 | 57 |
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);