ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
361 rows where cases = 1369 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 33
- Oklahoma 25
- Puerto Rico 23
- Missouri 19
- Tennessee 15
- Kentucky 13
- South Dakota 13
- Virginia 13
- Illinois 12
- Kansas 12
- Mississippi 12
- Alaska 11
- Georgia 10
- Minnesota 10
- North Carolina 10
- Wisconsin 10
- Iowa 9
- North Dakota 8
- West Virginia 8
- Arkansas 7
- Rhode Island 7
- Alabama 6
- Idaho 6
- Louisiana 6
- California 5
- Indiana 5
- Montana 5
- South Carolina 5
- Colorado 4
- Florida 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2384705 | 2384705 | 2022-04-07 | Ceiba | Puerto Rico | 72037 | 1369 | |
2381450 | 2381450 | 2022-04-06 | Ceiba | Puerto Rico | 72037 | 1369 | |
2292598 | 2292598 | 2022-03-10 | Big Stone | Minnesota | 27011 | 1369 | 8 |
2284847 | 2284847 | 2022-03-08 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 1369 | 8 |
2281595 | 2281595 | 2022-03-07 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 1369 | 8 |
2237487 | 2237487 | 2022-02-21 | Atchison | Missouri | 29005 | 1369 | 19 |
2238501 | 2238501 | 2022-02-21 | Moody | South Dakota | 46101 | 1369 | 27 |
2238622 | 2238622 | 2022-02-21 | Bailey | Texas | 48017 | 1369 | 37 |
2234236 | 2234236 | 2022-02-20 | Atchison | Missouri | 29005 | 1369 | 19 |
2235250 | 2235250 | 2022-02-20 | Moody | South Dakota | 46101 | 1369 | 27 |
2235371 | 2235371 | 2022-02-20 | Bailey | Texas | 48017 | 1369 | 37 |
2230985 | 2230985 | 2022-02-19 | Atchison | Missouri | 29005 | 1369 | 19 |
2231999 | 2231999 | 2022-02-19 | Moody | South Dakota | 46101 | 1369 | 27 |
2227734 | 2227734 | 2022-02-18 | Atchison | Missouri | 29005 | 1369 | 19 |
2228748 | 2228748 | 2022-02-18 | Moody | South Dakota | 46101 | 1369 | 27 |
2225497 | 2225497 | 2022-02-17 | Moody | South Dakota | 46101 | 1369 | 27 |
2193611 | 2193611 | 2022-02-07 | Wirt | West Virginia | 54105 | 1369 | 19 |
2173165 | 2173165 | 2022-02-01 | Tillman | Oklahoma | 40141 | 1369 | 30 |
2169913 | 2169913 | 2022-01-31 | Tillman | Oklahoma | 40141 | 1369 | 30 |
2166658 | 2166658 | 2022-01-30 | Tillman | Oklahoma | 40141 | 1369 | 30 |
2163403 | 2163403 | 2022-01-29 | Tillman | Oklahoma | 40141 | 1369 | 30 |
2160148 | 2160148 | 2022-01-28 | Tillman | Oklahoma | 40141 | 1369 | 30 |
2156893 | 2156893 | 2022-01-27 | Tillman | Oklahoma | 40141 | 1369 | 30 |
2151903 | 2151903 | 2022-01-26 | Marion | Georgia | 13197 | 1369 | 43 |
2153640 | 2153640 | 2022-01-26 | Tillman | Oklahoma | 40141 | 1369 | 30 |
2154210 | 2154210 | 2022-01-26 | Mills | Texas | 48333 | 1369 | 29 |
2146509 | 2146509 | 2022-01-24 | Shelby | Missouri | 29205 | 1369 | 13 |
2148164 | 2148164 | 2022-01-24 | Weston | Wyoming | 56045 | 1369 | 16 |
2142645 | 2142645 | 2022-01-23 | Sherman | Kansas | 20181 | 1369 | 18 |
2139390 | 2139390 | 2022-01-22 | Sherman | Kansas | 20181 | 1369 | 18 |
2136134 | 2136134 | 2022-01-21 | Sherman | Kansas | 20181 | 1369 | 18 |
2122814 | 2122814 | 2022-01-17 | Pulaski | Illinois | 17153 | 1369 | 15 |
2119562 | 2119562 | 2022-01-16 | Pulaski | Illinois | 17153 | 1369 | 15 |
2116310 | 2116310 | 2022-01-15 | Pulaski | Illinois | 17153 | 1369 | 15 |
2113059 | 2113059 | 2022-01-14 | Pulaski | Illinois | 17153 | 1369 | 15 |
2097730 | 2097730 | 2022-01-09 | Sullivan | Missouri | 29211 | 1369 | 20 |
2094478 | 2094478 | 2022-01-08 | Sullivan | Missouri | 29211 | 1369 | 20 |
2078154 | 2078154 | 2022-01-03 | Hickory | Missouri | 29085 | 1369 | 45 |
2040335 | 2040335 | 2021-12-22 | Hamilton | Texas | 48193 | 1369 | 29 |
1995340 | 1995340 | 2021-12-08 | Johnson | Wyoming | 56019 | 1369 | 16 |
1970778 | 1970778 | 2021-12-01 | Choctaw | Mississippi | 28019 | 1369 | 27 |
1966204 | 1966204 | 2021-11-30 | Greenlee | Arizona | 4011 | 1369 | 22 |
1965803 | 1965803 | 2021-11-29 | Charlotte | Virginia | 51037 | 1369 | 28 |
1959689 | 1959689 | 2021-11-28 | Southeast Fairbanks Census Area | Alaska | 2240 | 1369 | 12 |
1961242 | 1961242 | 2021-11-28 | Madison | Montana | 30057 | 1369 | 19 |
1956438 | 1956438 | 2021-11-27 | Southeast Fairbanks Census Area | Alaska | 2240 | 1369 | 12 |
1957991 | 1957991 | 2021-11-27 | Madison | Montana | 30057 | 1369 | 19 |
1953187 | 1953187 | 2021-11-26 | Southeast Fairbanks Census Area | Alaska | 2240 | 1369 | 12 |
1954740 | 1954740 | 2021-11-26 | Madison | Montana | 30057 | 1369 | 19 |
1952871 | 1952871 | 2021-11-25 | Poquoson city | Virginia | 51735 | 1369 | 22 |
1924876 | 1924876 | 2021-11-17 | Elliott | Kentucky | 21063 | 1369 | 9 |
1916619 | 1916619 | 2021-11-14 | Turner | South Dakota | 46125 | 1369 | 61 |
1913369 | 1913369 | 2021-11-13 | Turner | South Dakota | 46125 | 1369 | 61 |
1909168 | 1909168 | 2021-11-12 | Oregon | Missouri | 29149 | 1369 | 11 |
1909985 | 1909985 | 2021-11-12 | Quebradillas | Puerto Rico | 72115 | 1369 | |
1910119 | 1910119 | 2021-11-12 | Turner | South Dakota | 46125 | 1369 | 61 |
1906736 | 1906736 | 2021-11-11 | Quebradillas | Puerto Rico | 72115 | 1369 | |
1901412 | 1901412 | 2021-11-10 | Unknown | Connecticut | 1369 | 5 | |
1898162 | 1898162 | 2021-11-09 | Unknown | Connecticut | 1369 | 5 | |
1896553 | 1896553 | 2021-11-08 | Jones | North Carolina | 37103 | 1369 | 34 |
1875881 | 1875881 | 2021-11-02 | Switzerland | Indiana | 18155 | 1369 | 11 |
1873236 | 1873236 | 2021-11-01 | Pipestone | Minnesota | 27117 | 1369 | 27 |
1869594 | 1869594 | 2021-10-31 | Thomas | Kansas | 20193 | 1369 | 22 |
1866345 | 1866345 | 2021-10-30 | Thomas | Kansas | 20193 | 1369 | 22 |
1863096 | 1863096 | 2021-10-29 | Thomas | Kansas | 20193 | 1369 | 22 |
1855765 | 1855765 | 2021-10-27 | Nevada | Arkansas | 5099 | 1369 | 38 |
1858009 | 1858009 | 2021-10-27 | Utuado | Puerto Rico | 72141 | 1369 | |
1853274 | 1853274 | 2021-10-26 | Doniphan | Kansas | 20043 | 1369 | 28 |
1854760 | 1854760 | 2021-10-26 | Utuado | Puerto Rico | 72141 | 1369 | |
1850025 | 1850025 | 2021-10-25 | Doniphan | Kansas | 20043 | 1369 | 28 |
1851511 | 1851511 | 2021-10-25 | Utuado | Puerto Rico | 72141 | 1369 | |
1848261 | 1848261 | 2021-10-24 | Utuado | Puerto Rico | 72141 | 1369 | |
1810872 | 1810872 | 2021-10-13 | Martin | Indiana | 18101 | 1369 | 20 |
1807623 | 1807623 | 2021-10-12 | Martin | Indiana | 18101 | 1369 | 20 |
1797719 | 1797719 | 2021-10-09 | Valley | Idaho | 16085 | 1369 | 10 |
1787425 | 1787425 | 2021-10-06 | Perry | Alabama | 1105 | 1369 | 39 |
1784176 | 1784176 | 2021-10-05 | Perry | Alabama | 1105 | 1369 | 38 |
1778285 | 1778285 | 2021-10-03 | Marshall | Illinois | 17123 | 1369 | 23 |
1778707 | 1778707 | 2021-10-03 | McLean | Kentucky | 21149 | 1369 | 35 |
1775035 | 1775035 | 2021-10-02 | Marshall | Illinois | 17123 | 1369 | 23 |
1775457 | 1775457 | 2021-10-02 | McLean | Kentucky | 21149 | 1369 | 35 |
1771785 | 1771785 | 2021-10-01 | Marshall | Illinois | 17123 | 1369 | 23 |
1772207 | 1772207 | 2021-10-01 | McLean | Kentucky | 21149 | 1369 | 35 |
1762540 | 1762540 | 2021-09-28 | Red River | Louisiana | 22081 | 1369 | 44 |
1754960 | 1754960 | 2021-09-26 | Ketchikan Gateway Borough | Alaska | 2130 | 1369 | 5 |
1751712 | 1751712 | 2021-09-25 | Ketchikan Gateway Borough | Alaska | 2130 | 1369 | 5 |
1748463 | 1748463 | 2021-09-24 | Ketchikan Gateway Borough | Alaska | 2130 | 1369 | 5 |
1750419 | 1750419 | 2021-09-24 | Mercer | North Dakota | 38057 | 1369 | 11 |
1746085 | 1746085 | 2021-09-23 | Linn | Kansas | 20107 | 1369 | 14 |
1742836 | 1742836 | 2021-09-22 | Linn | Kansas | 20107 | 1369 | 14 |
1741474 | 1741474 | 2021-09-21 | Somervell | Texas | 48425 | 1369 | 20 |
1723839 | 1723839 | 2021-09-16 | Kemper | Mississippi | 28069 | 1369 | 39 |
1724911 | 1724911 | 2021-09-16 | Todd | South Dakota | 46121 | 1369 | 33 |
1720147 | 1720147 | 2021-09-15 | Bath | Kentucky | 21011 | 1369 | 24 |
1714038 | 1714038 | 2021-09-13 | Rock | Minnesota | 27133 | 1369 | 19 |
1711009 | 1711009 | 2021-09-12 | Wayne | Missouri | 29223 | 1369 | 17 |
1701628 | 1701628 | 2021-09-09 | Pamlico | North Carolina | 37137 | 1369 | 14 |
1702007 | 1702007 | 2021-09-09 | Coamo | Puerto Rico | 72043 | 1369 | |
1674260 | 1674260 | 2021-09-01 | Teton | Idaho | 16081 | 1369 | 4 |
1667559 | 1667559 | 2021-08-30 | Atkinson | Georgia | 13003 | 1369 | 23 |
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);