ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
245 rows where cases = 2586 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 22
- Iowa 21
- Indiana 16
- Missouri 16
- Kentucky 14
- Virginia 14
- Alabama 12
- Georgia 11
- Colorado 10
- Tennessee 8
- Puerto Rico 7
- Wisconsin 7
- Massachusetts 6
- Arkansas 5
- Idaho 5
- North Carolina 5
- Ohio 5
- West Virginia 5
- Wyoming 5
- Michigan 4
- Minnesota 4
- Mississippi 4
- Florida 3
- Louisiana 3
- Maryland 3
- New York 3
- Oklahoma 3
- Illinois 2
- Kansas 2
- Montana 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501764 | 2501764 | 2022-05-13 | Hughes | Oklahoma | 40063 | 2586 | 62 |
2502811 | 2502811 | 2022-05-13 | Big Horn | Wyoming | 56003 | 2586 | 61 |
2498506 | 2498506 | 2022-05-12 | Hughes | Oklahoma | 40063 | 2586 | 62 |
2499334 | 2499334 | 2022-05-12 | Nelson | Virginia | 51125 | 2586 | 36 |
2499553 | 2499553 | 2022-05-12 | Big Horn | Wyoming | 56003 | 2586 | 61 |
2496295 | 2496295 | 2022-05-11 | Big Horn | Wyoming | 56003 | 2586 | 61 |
2493037 | 2493037 | 2022-05-10 | Big Horn | Wyoming | 56003 | 2586 | 61 |
2463803 | 2463803 | 2022-05-02 | Sumter | Alabama | 1119 | 2586 | 51 |
2460547 | 2460547 | 2022-05-01 | Sumter | Alabama | 1119 | 2586 | 51 |
2457291 | 2457291 | 2022-04-30 | Sumter | Alabama | 1119 | 2586 | 51 |
2454035 | 2454035 | 2022-04-29 | Sumter | Alabama | 1119 | 2586 | 51 |
2415615 | 2415615 | 2022-04-17 | Brown | Indiana | 18013 | 2586 | 62 |
2412359 | 2412359 | 2022-04-16 | Brown | Indiana | 18013 | 2586 | 62 |
2409103 | 2409103 | 2022-04-15 | Brown | Indiana | 18013 | 2586 | 62 |
2405847 | 2405847 | 2022-04-14 | Brown | Indiana | 18013 | 2586 | 62 |
2402592 | 2402592 | 2022-04-13 | Brown | Indiana | 18013 | 2586 | 62 |
2399337 | 2399337 | 2022-04-12 | Brown | Indiana | 18013 | 2586 | 62 |
2396082 | 2396082 | 2022-04-11 | Brown | Indiana | 18013 | 2586 | 62 |
2392826 | 2392826 | 2022-04-10 | Brown | Indiana | 18013 | 2586 | 62 |
2389570 | 2389570 | 2022-04-09 | Brown | Indiana | 18013 | 2586 | 62 |
2386315 | 2386315 | 2022-04-08 | Brown | Indiana | 18013 | 2586 | 62 |
2353779 | 2353779 | 2022-03-29 | Brown | Indiana | 18013 | 2586 | 62 |
2350527 | 2350527 | 2022-03-28 | Brown | Indiana | 18013 | 2586 | 62 |
2333253 | 2333253 | 2022-03-22 | Clarke | Virginia | 51043 | 2586 | 40 |
2330000 | 2330000 | 2022-03-21 | Clarke | Virginia | 51043 | 2586 | 40 |
2307206 | 2307206 | 2022-03-14 | Amelia | Virginia | 51007 | 2586 | 59 |
2293240 | 2293240 | 2022-03-10 | Pamlico | North Carolina | 37137 | 2586 | 27 |
2246822 | 2246822 | 2022-02-24 | McLean | Kentucky | 21149 | 2586 | 45 |
2243571 | 2243571 | 2022-02-23 | McLean | Kentucky | 21149 | 2586 | 45 |
2240320 | 2240320 | 2022-02-22 | McLean | Kentucky | 21149 | 2586 | 45 |
2237069 | 2237069 | 2022-02-21 | McLean | Kentucky | 21149 | 2586 | 45 |
2198784 | 2198784 | 2022-02-09 | Colfax | New Mexico | 35007 | 2586 | 62 |
2169192 | 2169192 | 2022-01-31 | Barton | Missouri | 29011 | 2586 | 44 |
2165937 | 2165937 | 2022-01-30 | Barton | Missouri | 29011 | 2586 | 44 |
2156081 | 2156081 | 2022-01-27 | Watonwan | Minnesota | 27165 | 2586 | 22 |
2154073 | 2154073 | 2022-01-26 | Callahan | Texas | 48059 | 2586 | 63 |
2150689 | 2150689 | 2022-01-25 | Todd | South Dakota | 46121 | 2586 | 43 |
2145991 | 2145991 | 2022-01-24 | Martin | Kentucky | 21159 | 2586 | 44 |
2147059 | 2147059 | 2022-01-24 | Vinton | Ohio | 39163 | 2586 | 46 |
2142072 | 2142072 | 2022-01-23 | Charlton | Georgia | 13049 | 2586 | 58 |
2138419 | 2138419 | 2022-01-22 | Conecuh | Alabama | 1035 | 2586 | 63 |
2138817 | 2138817 | 2022-01-22 | Charlton | Georgia | 13049 | 2586 | 58 |
2135561 | 2135561 | 2022-01-21 | Charlton | Georgia | 13049 | 2586 | 58 |
2109899 | 2109899 | 2022-01-13 | Pulaski | Indiana | 18131 | 2586 | 74 |
2106136 | 2106136 | 2022-01-12 | Crowley | Colorado | 8025 | 2586 | 27 |
2106906 | 2106906 | 2022-01-12 | Clinton | Kentucky | 21053 | 2586 | 41 |
2104259 | 2104259 | 2022-01-11 | Glacier | Montana | 30035 | 2586 | 63 |
2099657 | 2099657 | 2022-01-10 | Las Animas | Colorado | 8071 | 2586 | 33 |
2083072 | 2083072 | 2022-01-04 | Price | Wisconsin | 55099 | 2586 | 22 |
2076217 | 2076217 | 2022-01-02 | Tyler | Texas | 48457 | 2586 | 73 |
2072966 | 2072966 | 2022-01-01 | Tyler | Texas | 48457 | 2586 | 73 |
2069715 | 2069715 | 2021-12-31 | Tyler | Texas | 48457 | 2586 | 73 |
2066464 | 2066464 | 2021-12-30 | Tyler | Texas | 48457 | 2586 | 73 |
2057148 | 2057148 | 2021-12-28 | Lamar | Alabama | 1075 | 2586 | 58 |
2060086 | 2060086 | 2021-12-28 | Giles | Virginia | 51071 | 2586 | 38 |
2044126 | 2044126 | 2021-12-24 | Cleburne | Alabama | 1029 | 2586 | 60 |
2033992 | 2033992 | 2021-12-20 | Zavala | Texas | 48507 | 2586 | 56 |
2031050 | 2031050 | 2021-12-19 | Lafayette | Wisconsin | 55065 | 2586 | 16 |
2027799 | 2027799 | 2021-12-18 | Lafayette | Wisconsin | 55065 | 2586 | 16 |
2024548 | 2024548 | 2021-12-17 | Lafayette | Wisconsin | 55065 | 2586 | 16 |
2021242 | 2021242 | 2021-12-16 | Morgan | West Virginia | 54065 | 2586 | 51 |
2008498 | 2008498 | 2021-12-13 | Howard | Arkansas | 5061 | 2586 | 39 |
2009473 | 2009473 | 2021-12-13 | Washington | Kentucky | 21229 | 2586 | 50 |
2005247 | 2005247 | 2021-12-12 | Howard | Arkansas | 5061 | 2586 | 39 |
2001996 | 2001996 | 2021-12-11 | Howard | Arkansas | 5061 | 2586 | 39 |
1997118 | 1997118 | 2021-12-09 | York | Nebraska | 31185 | 2586 | 19 |
1974971 | 1974971 | 2021-12-02 | Isabela | Puerto Rico | 72071 | 2586 | |
1963736 | 1963736 | 2021-11-29 | Unknown | Iowa | 2586 | 0 | |
1960485 | 1960485 | 2021-11-28 | Unknown | Iowa | 2586 | 0 | |
1949790 | 1949790 | 2021-11-24 | Marquette | Wisconsin | 55077 | 2586 | 37 |
1923827 | 1923827 | 2021-11-16 | Goshen | Wyoming | 56015 | 2586 | 46 |
1899404 | 1899404 | 2021-11-09 | Livingston | Missouri | 29117 | 2586 | 63 |
1896154 | 1896154 | 2021-11-08 | Livingston | Missouri | 29117 | 2586 | 63 |
1897266 | 1897266 | 2021-11-08 | Colorado | Texas | 48089 | 2586 | 53 |
1891592 | 1891592 | 2021-11-07 | Alamosa | Colorado | 8003 | 2586 | 44 |
1892904 | 1892904 | 2021-11-07 | Livingston | Missouri | 29117 | 2586 | 63 |
1894016 | 1894016 | 2021-11-07 | Colorado | Texas | 48089 | 2586 | 53 |
1888342 | 1888342 | 2021-11-06 | Alamosa | Colorado | 8003 | 2586 | 44 |
1885092 | 1885092 | 2021-11-05 | Alamosa | Colorado | 8003 | 2586 | 44 |
1859817 | 1859817 | 2021-10-28 | Neosho | Kansas | 20133 | 2586 | 51 |
1856160 | 1856160 | 2021-10-27 | Kauai | Hawaii | 15007 | 2586 | 9 |
1856568 | 1856568 | 2021-10-27 | Neosho | Kansas | 20133 | 2586 | 51 |
1853180 | 1853180 | 2021-10-26 | Delaware | Iowa | 19055 | 2586 | 46 |
1853923 | 1853923 | 2021-10-26 | Moniteau | Missouri | 29135 | 2586 | 38 |
1849931 | 1849931 | 2021-10-25 | Delaware | Iowa | 19055 | 2586 | 46 |
1846681 | 1846681 | 2021-10-24 | Delaware | Iowa | 19055 | 2586 | 46 |
1843431 | 1843431 | 2021-10-23 | Delaware | Iowa | 19055 | 2586 | 46 |
1840181 | 1840181 | 2021-10-22 | Delaware | Iowa | 19055 | 2586 | 46 |
1836932 | 1836932 | 2021-10-21 | Delaware | Iowa | 19055 | 2586 | 46 |
1833683 | 1833683 | 2021-10-20 | Delaware | Iowa | 19055 | 2586 | 46 |
1812814 | 1812814 | 2021-10-13 | Falls | Texas | 48145 | 2586 | 43 |
1807750 | 1807750 | 2021-10-12 | Tama | Iowa | 19171 | 2586 | 75 |
1804499 | 1804499 | 2021-10-11 | Tama | Iowa | 19171 | 2586 | 75 |
1800673 | 1800673 | 2021-10-10 | Teller | Colorado | 8119 | 2586 | 25 |
1801250 | 1801250 | 2021-10-10 | Tama | Iowa | 19171 | 2586 | 75 |
1797424 | 1797424 | 2021-10-09 | Teller | Colorado | 8119 | 2586 | 25 |
1798001 | 1798001 | 2021-10-09 | Tama | Iowa | 19171 | 2586 | 75 |
1794175 | 1794175 | 2021-10-08 | Teller | Colorado | 8119 | 2586 | 25 |
1794752 | 1794752 | 2021-10-08 | Tama | Iowa | 19171 | 2586 | 75 |
1791504 | 1791504 | 2021-10-07 | Tama | Iowa | 19171 | 2586 | 75 |
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);