ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
357 rows where cases = 1297 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Virginia 39
- Texas 28
- Georgia 24
- Iowa 21
- Arkansas 15
- Puerto Rico 14
- Michigan 13
- Illinois 12
- Kentucky 12
- Mississippi 12
- Missouri 11
- North Dakota 11
- Idaho 9
- Indiana 9
- South Dakota 9
- North Carolina 8
- Oklahoma 8
- Tennessee 8
- Florida 7
- Kansas 7
- Minnesota 7
- Wisconsin 7
- Alabama 6
- Colorado 6
- Ohio 6
- West Virginia 6
- Washington 5
- Pennsylvania 4
- South Carolina 4
- Wyoming 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2457379 | 2457379 | 2022-04-30 | Lafayette | Arkansas | 5073 | 1297 | 31 |
2454123 | 2454123 | 2022-04-29 | Lafayette | Arkansas | 5073 | 1297 | 31 |
2450867 | 2450867 | 2022-04-28 | Lafayette | Arkansas | 5073 | 1297 | 31 |
2447611 | 2447611 | 2022-04-27 | Lafayette | Arkansas | 5073 | 1297 | 31 |
2444355 | 2444355 | 2022-04-26 | Lafayette | Arkansas | 5073 | 1297 | 31 |
2441099 | 2441099 | 2022-04-25 | Lafayette | Arkansas | 5073 | 1297 | 31 |
2437843 | 2437843 | 2022-04-24 | Lafayette | Arkansas | 5073 | 1297 | 31 |
2434587 | 2434587 | 2022-04-23 | Lafayette | Arkansas | 5073 | 1297 | 31 |
2431331 | 2431331 | 2022-04-22 | Lafayette | Arkansas | 5073 | 1297 | 31 |
2307290 | 2307290 | 2022-03-14 | Norton city | Virginia | 51720 | 1297 | 22 |
2304039 | 2304039 | 2022-03-13 | Norton city | Virginia | 51720 | 1297 | 22 |
2300787 | 2300787 | 2022-03-12 | Norton city | Virginia | 51720 | 1297 | 22 |
2296548 | 2296548 | 2022-03-11 | McHenry | North Dakota | 38049 | 1297 | 31 |
2297535 | 2297535 | 2022-03-11 | Norton city | Virginia | 51720 | 1297 | 22 |
2293296 | 2293296 | 2022-03-10 | McHenry | North Dakota | 38049 | 1297 | 31 |
2290044 | 2290044 | 2022-03-09 | McHenry | North Dakota | 38049 | 1297 | 31 |
2244991 | 2244991 | 2022-02-23 | Kingsbury | South Dakota | 46077 | 1297 | 20 |
2241740 | 2241740 | 2022-02-22 | Kingsbury | South Dakota | 46077 | 1297 | 20 |
2238489 | 2238489 | 2022-02-21 | Kingsbury | South Dakota | 46077 | 1297 | 20 |
2235238 | 2235238 | 2022-02-20 | Kingsbury | South Dakota | 46077 | 1297 | 20 |
2231987 | 2231987 | 2022-02-19 | Kingsbury | South Dakota | 46077 | 1297 | 20 |
2228736 | 2228736 | 2022-02-18 | Kingsbury | South Dakota | 46077 | 1297 | 20 |
2222260 | 2222260 | 2022-02-16 | Walworth | South Dakota | 46129 | 1297 | 23 |
2174468 | 2174468 | 2022-02-02 | Huerfano | Colorado | 8055 | 1297 | 28 |
2170198 | 2170198 | 2022-01-31 | McCook | South Dakota | 46087 | 1297 | 30 |
2141039 | 2141039 | 2022-01-22 | Bailey | Texas | 48017 | 1297 | 31 |
2081384 | 2081384 | 2022-01-04 | Chariton | Missouri | 29041 | 1297 | 32 |
2061045 | 2061045 | 2021-12-29 | Schuyler | Illinois | 17169 | 1297 | 26 |
2062769 | 2062769 | 2021-12-29 | Villalba | Puerto Rico | 72149 | 1297 | |
2058835 | 2058835 | 2021-12-28 | Knox | Nebraska | 31107 | 1297 | 13 |
2053668 | 2053668 | 2021-12-26 | Williamsburg city | Virginia | 51830 | 1297 | 13 |
2050418 | 2050418 | 2021-12-25 | Williamsburg city | Virginia | 51830 | 1297 | 13 |
2047168 | 2047168 | 2021-12-24 | Williamsburg city | Virginia | 51830 | 1297 | 13 |
2040616 | 2040616 | 2021-12-22 | Manassas Park city | Virginia | 51685 | 1297 | 15 |
2040759 | 2040759 | 2021-12-22 | Tucker | West Virginia | 54093 | 1297 | 31 |
2027747 | 2027747 | 2021-12-18 | Pendleton | West Virginia | 54071 | 1297 | 16 |
2015020 | 2015020 | 2021-12-15 | Newton | Arkansas | 5101 | 1297 | 41 |
2012463 | 2012463 | 2021-12-14 | Lucas | Iowa | 19117 | 1297 | 28 |
2009212 | 2009212 | 2021-12-13 | Lucas | Iowa | 19117 | 1297 | 28 |
2005961 | 2005961 | 2021-12-12 | Lucas | Iowa | 19117 | 1297 | 28 |
2002710 | 2002710 | 2021-12-11 | Lucas | Iowa | 19117 | 1297 | 28 |
1999460 | 1999460 | 2021-12-10 | Lucas | Iowa | 19117 | 1297 | 28 |
2000210 | 2000210 | 2021-12-10 | Sullivan | Missouri | 29211 | 1297 | 17 |
1996209 | 1996209 | 2021-12-09 | Lucas | Iowa | 19117 | 1297 | 28 |
1996657 | 1996657 | 2021-12-09 | Montmorency | Michigan | 26119 | 1297 | 39 |
1992958 | 1992958 | 2021-12-08 | Lucas | Iowa | 19117 | 1297 | 28 |
1993406 | 1993406 | 2021-12-08 | Montmorency | Michigan | 26119 | 1297 | 39 |
1991416 | 1991416 | 2021-12-07 | Hancock | Tennessee | 47067 | 1297 | 21 |
1988243 | 1988243 | 2021-12-06 | Blanco | Texas | 48031 | 1297 | 28 |
1960123 | 1960123 | 2021-11-28 | Taylor | Georgia | 13269 | 1297 | 38 |
1960580 | 1960580 | 2021-11-28 | Russell | Kansas | 20167 | 1297 | 33 |
1956872 | 1956872 | 2021-11-27 | Taylor | Georgia | 13269 | 1297 | 38 |
1957329 | 1957329 | 2021-11-27 | Russell | Kansas | 20167 | 1297 | 33 |
1953621 | 1953621 | 2021-11-26 | Taylor | Georgia | 13269 | 1297 | 38 |
1954078 | 1954078 | 2021-11-26 | Russell | Kansas | 20167 | 1297 | 33 |
1950370 | 1950370 | 2021-11-25 | Taylor | Georgia | 13269 | 1297 | 38 |
1950827 | 1950827 | 2021-11-25 | Russell | Kansas | 20167 | 1297 | 33 |
1947119 | 1947119 | 2021-11-24 | Taylor | Georgia | 13269 | 1297 | 38 |
1947576 | 1947576 | 2021-11-24 | Russell | Kansas | 20167 | 1297 | 33 |
1943868 | 1943868 | 2021-11-23 | Taylor | Georgia | 13269 | 1297 | 38 |
1940618 | 1940618 | 2021-11-22 | Taylor | Georgia | 13269 | 1297 | 38 |
1942724 | 1942724 | 2021-11-22 | Archer | Texas | 48009 | 1297 | 23 |
1937635 | 1937635 | 2021-11-21 | Warren | Indiana | 18171 | 1297 | 18 |
1939474 | 1939474 | 2021-11-21 | Archer | Texas | 48009 | 1297 | 23 |
1939809 | 1939809 | 2021-11-21 | Essex | Virginia | 51057 | 1297 | 20 |
1934385 | 1934385 | 2021-11-20 | Warren | Indiana | 18171 | 1297 | 18 |
1936224 | 1936224 | 2021-11-20 | Archer | Texas | 48009 | 1297 | 23 |
1936559 | 1936559 | 2021-11-20 | Essex | Virginia | 51057 | 1297 | 20 |
1931134 | 1931134 | 2021-11-19 | Warren | Indiana | 18171 | 1297 | 18 |
1933309 | 1933309 | 2021-11-19 | Essex | Virginia | 51057 | 1297 | 20 |
1927124 | 1927124 | 2021-11-18 | Greene | Alabama | 1063 | 1297 | 45 |
1894296 | 1894296 | 2021-11-07 | Charlotte | Virginia | 51037 | 1297 | 27 |
1890969 | 1890969 | 2021-11-06 | Winkler | Texas | 48495 | 1297 | 29 |
1891046 | 1891046 | 2021-11-06 | Charlotte | Virginia | 51037 | 1297 | 27 |
1887796 | 1887796 | 2021-11-05 | Charlotte | Virginia | 51037 | 1297 | 27 |
1884546 | 1884546 | 2021-11-04 | Charlotte | Virginia | 51037 | 1297 | 27 |
1853798 | 1853798 | 2021-10-26 | Humphreys | Mississippi | 28053 | 1297 | 38 |
1852051 | 1852051 | 2021-10-25 | Buena Vista city | Virginia | 51530 | 1297 | 25 |
1829692 | 1829692 | 2021-10-19 | Nome Census Area | Alaska | 2180 | 1297 | 1 |
1825069 | 1825069 | 2021-10-17 | Jones | North Carolina | 37103 | 1297 | 29 |
1826353 | 1826353 | 2021-10-17 | Platte | Wyoming | 56031 | 1297 | 24 |
1821820 | 1821820 | 2021-10-16 | Jones | North Carolina | 37103 | 1297 | 29 |
1823104 | 1823104 | 2021-10-16 | Platte | Wyoming | 56031 | 1297 | 24 |
1818571 | 1818571 | 2021-10-15 | Jones | North Carolina | 37103 | 1297 | 29 |
1819855 | 1819855 | 2021-10-15 | Platte | Wyoming | 56031 | 1297 | 24 |
1816374 | 1816374 | 2021-10-14 | Nelson | Virginia | 51125 | 1297 | 16 |
1807160 | 1807160 | 2021-10-12 | Park | Colorado | 8093 | 1297 | 7 |
1808811 | 1808811 | 2021-10-12 | Graham | North Carolina | 37075 | 1297 | 27 |
1809572 | 1809572 | 2021-10-12 | Franklin | Texas | 48159 | 1297 | 32 |
1781970 | 1781970 | 2021-10-04 | Owen | Kentucky | 21187 | 1297 | 21 |
1768658 | 1768658 | 2021-09-30 | Switzerland | Indiana | 18155 | 1297 | 10 |
1758348 | 1758348 | 2021-09-27 | Plumas | California | 6063 | 1297 | 6 |
1759673 | 1759673 | 2021-09-27 | Iron | Missouri | 29093 | 1297 | 10 |
1761214 | 1761214 | 2021-09-27 | Pend Oreille | Washington | 53051 | 1297 | 17 |
1758016 | 1758016 | 2021-09-26 | Pleasants | West Virginia | 54073 | 1297 | 19 |
1739719 | 1739719 | 2021-09-21 | McLean | Kentucky | 21149 | 1297 | 33 |
1737807 | 1737807 | 2021-09-20 | Allendale | South Carolina | 45005 | 1297 | 19 |
1722705 | 1722705 | 2021-09-16 | Unknown | Connecticut | 1297 | 2 | |
1723777 | 1723777 | 2021-09-16 | Pope | Minnesota | 27121 | 1297 | 8 |
1721803 | 1721803 | 2021-09-15 | Clay | Texas | 48077 | 1297 | 21 |
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);