ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
198 rows where cases = 2958 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Mississippi 21
- Iowa 16
- Tennessee 13
- North Dakota 11
- Texas 10
- Virginia 10
- Missouri 9
- Alabama 8
- Georgia 8
- Indiana 8
- North Carolina 8
- Arkansas 6
- Illinois 6
- New York 6
- Pennsylvania 6
- Washington 6
- Kentucky 5
- West Virginia 5
- Minnesota 4
- Montana 4
- Colorado 3
- Florida 3
- Maine 3
- Ohio 3
- Puerto Rico 3
- Louisiana 2
- Michigan 2
- Wisconsin 2
- Maryland 1
- Nevada 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2442418 | 2442418 | 2022-04-25 | Montgomery | Mississippi | 28097 | 2958 | 77 |
2439162 | 2439162 | 2022-04-24 | Montgomery | Mississippi | 28097 | 2958 | 77 |
2435906 | 2435906 | 2022-04-23 | Montgomery | Mississippi | 28097 | 2958 | 77 |
2432650 | 2432650 | 2022-04-22 | Montgomery | Mississippi | 28097 | 2958 | 77 |
2429394 | 2429394 | 2022-04-21 | Montgomery | Mississippi | 28097 | 2958 | 77 |
2426138 | 2426138 | 2022-04-20 | Montgomery | Mississippi | 28097 | 2958 | 77 |
2426932 | 2426932 | 2022-04-20 | Morrow | Oregon | 41049 | 2958 | 34 |
2422228 | 2422228 | 2022-04-19 | Cass | Iowa | 19029 | 2958 | 78 |
2422882 | 2422882 | 2022-04-19 | Montgomery | Mississippi | 28097 | 2958 | 77 |
2418972 | 2418972 | 2022-04-18 | Cass | Iowa | 19029 | 2958 | 78 |
2419626 | 2419626 | 2022-04-18 | Montgomery | Mississippi | 28097 | 2958 | 77 |
2415716 | 2415716 | 2022-04-17 | Cass | Iowa | 19029 | 2958 | 78 |
2412460 | 2412460 | 2022-04-16 | Cass | Iowa | 19029 | 2958 | 78 |
2409204 | 2409204 | 2022-04-15 | Cass | Iowa | 19029 | 2958 | 78 |
2405948 | 2405948 | 2022-04-14 | Cass | Iowa | 19029 | 2958 | 78 |
2402692 | 2402692 | 2022-04-13 | Cass | Iowa | 19029 | 2958 | 78 |
2392133 | 2392133 | 2022-04-10 | Coosa | Alabama | 1037 | 2958 | 58 |
2388877 | 2388877 | 2022-04-09 | Coosa | Alabama | 1037 | 2958 | 58 |
2385622 | 2385622 | 2022-04-08 | Coosa | Alabama | 1037 | 2958 | 58 |
2382367 | 2382367 | 2022-04-07 | Coosa | Alabama | 1037 | 2958 | 58 |
2379112 | 2379112 | 2022-04-06 | Coosa | Alabama | 1037 | 2958 | 58 |
2341254 | 2341254 | 2022-03-25 | Piscataquis | Maine | 23021 | 2958 | 31 |
2338813 | 2338813 | 2022-03-24 | Barnes | North Dakota | 38003 | 2958 | 47 |
2335559 | 2335559 | 2022-03-23 | Barnes | North Dakota | 38003 | 2958 | 47 |
2332305 | 2332305 | 2022-03-22 | Barnes | North Dakota | 38003 | 2958 | 47 |
2329052 | 2329052 | 2022-03-21 | Barnes | North Dakota | 38003 | 2958 | 47 |
2325800 | 2325800 | 2022-03-20 | Barnes | North Dakota | 38003 | 2958 | 47 |
2322547 | 2322547 | 2022-03-19 | Barnes | North Dakota | 38003 | 2958 | 47 |
2319293 | 2319293 | 2022-03-18 | Barnes | North Dakota | 38003 | 2958 | 47 |
2316039 | 2316039 | 2022-03-17 | Barnes | North Dakota | 38003 | 2958 | 47 |
2312786 | 2312786 | 2022-03-16 | Barnes | North Dakota | 38003 | 2958 | 47 |
2280265 | 2280265 | 2022-03-06 | Barnes | North Dakota | 38003 | 2958 | 46 |
2201297 | 2201297 | 2022-02-10 | Martin | Kentucky | 21159 | 2958 | 44 |
2195368 | 2195368 | 2022-02-08 | Roosevelt | Montana | 30085 | 2958 | 70 |
2171373 | 2171373 | 2022-02-01 | Dade | Georgia | 13083 | 2958 | 26 |
2173980 | 2173980 | 2022-02-01 | Rockbridge | Virginia | 51163 | 2958 | 73 |
2166401 | 2166401 | 2022-01-30 | Mitchell | North Carolina | 37121 | 2958 | 28 |
2163146 | 2163146 | 2022-01-29 | Mitchell | North Carolina | 37121 | 2958 | 28 |
2159891 | 2159891 | 2022-01-28 | Mitchell | North Carolina | 37121 | 2958 | 28 |
2152992 | 2152992 | 2022-01-26 | Osage | Missouri | 29151 | 2958 | 39 |
2143783 | 2143783 | 2022-01-23 | Noble | Ohio | 39121 | 2958 | 52 |
2125402 | 2125402 | 2022-01-18 | Cleburne | Alabama | 1029 | 2958 | 62 |
2122529 | 2122529 | 2022-01-17 | Bacon | Georgia | 13005 | 2958 | 65 |
2105730 | 2105730 | 2022-01-11 | Braxton | West Virginia | 54007 | 2958 | 32 |
2083252 | 2083252 | 2022-01-05 | Franklin | Arkansas | 5047 | 2958 | 59 |
2084732 | 2084732 | 2022-01-05 | Wright | Missouri | 29229 | 2958 | 68 |
2058678 | 2058678 | 2021-12-28 | Moniteau | Missouri | 29135 | 2958 | 46 |
2051240 | 2051240 | 2021-12-26 | Ford | Illinois | 17053 | 2958 | 67 |
2047990 | 2047990 | 2021-12-25 | Ford | Illinois | 17053 | 2958 | 67 |
2044740 | 2044740 | 2021-12-24 | Ford | Illinois | 17053 | 2958 | 67 |
2041491 | 2041491 | 2021-12-23 | Ford | Illinois | 17053 | 2958 | 67 |
2035245 | 2035245 | 2021-12-21 | Tama | Iowa | 19171 | 2958 | 78 |
2031995 | 2031995 | 2021-12-20 | Tama | Iowa | 19171 | 2958 | 78 |
2032192 | 2032192 | 2021-12-20 | Mason | Kentucky | 21161 | 2958 | 81 |
2028744 | 2028744 | 2021-12-19 | Tama | Iowa | 19171 | 2958 | 78 |
2025493 | 2025493 | 2021-12-18 | Tama | Iowa | 19171 | 2958 | 78 |
2022242 | 2022242 | 2021-12-17 | Tama | Iowa | 19171 | 2958 | 78 |
2018991 | 2018991 | 2021-12-16 | Tama | Iowa | 19171 | 2958 | 78 |
2015741 | 2015741 | 2021-12-15 | Tama | Iowa | 19171 | 2958 | 78 |
2016770 | 2016770 | 2021-12-15 | Avery | North Carolina | 37011 | 2958 | 39 |
1996454 | 1996454 | 2021-12-09 | Powell | Kentucky | 21197 | 2958 | 25 |
1989618 | 1989618 | 2021-12-07 | Perry | Indiana | 18123 | 2958 | 57 |
1969485 | 1969485 | 2021-12-01 | Drew | Arkansas | 5043 | 2958 | 55 |
1965687 | 1965687 | 2021-11-29 | Shelby | Texas | 48419 | 2958 | 113 |
1922486 | 1922486 | 2021-11-16 | Seneca | New York | 36099 | 2958 | 65 |
1898023 | 1898023 | 2021-11-09 | Sharp | Arkansas | 5135 | 2958 | 69 |
1884622 | 1884622 | 2021-11-04 | Prince Edward | Virginia | 51147 | 2958 | 51 |
1853783 | 1853783 | 2021-10-26 | Clarke | Mississippi | 28023 | 2958 | 94 |
1846346 | 1846346 | 2021-10-24 | Meriwether | Georgia | 13199 | 2958 | 109 |
1843096 | 1843096 | 2021-10-23 | Meriwether | Georgia | 13199 | 2958 | 109 |
1839846 | 1839846 | 2021-10-22 | Meriwether | Georgia | 13199 | 2958 | 109 |
1832215 | 1832215 | 2021-10-19 | Sequatchie | Tennessee | 47153 | 2958 | 32 |
1832375 | 1832375 | 2021-10-19 | Lamb | Texas | 48279 | 2958 | 88 |
1824728 | 1824728 | 2021-10-17 | Big Horn | Montana | 30003 | 2958 | 81 |
1821479 | 1821479 | 2021-10-16 | Big Horn | Montana | 30003 | 2958 | 81 |
1818230 | 1818230 | 2021-10-15 | Big Horn | Montana | 30003 | 2958 | 81 |
1814973 | 1814973 | 2021-10-14 | Vernon | Missouri | 29217 | 2958 | 64 |
1807566 | 1807566 | 2021-10-12 | Wayne | Illinois | 17191 | 2958 | 62 |
1763749 | 1763749 | 2021-09-28 | Juncos | Puerto Rico | 72077 | 2958 | |
1760500 | 1760500 | 2021-09-27 | Juncos | Puerto Rico | 72077 | 2958 | |
1757919 | 1757919 | 2021-09-26 | Salem city | Virginia | 51775 | 2958 | 55 |
1757941 | 1757941 | 2021-09-26 | Adams | Washington | 53001 | 2958 | 26 |
1754671 | 1754671 | 2021-09-25 | Salem city | Virginia | 51775 | 2958 | 55 |
1754693 | 1754693 | 2021-09-25 | Adams | Washington | 53001 | 2958 | 26 |
1751423 | 1751423 | 2021-09-24 | Salem city | Virginia | 51775 | 2958 | 55 |
1751445 | 1751445 | 2021-09-24 | Adams | Washington | 53001 | 2958 | 26 |
1742180 | 1742180 | 2021-09-22 | Pitkin | Colorado | 8097 | 2958 | 5 |
1734505 | 1734505 | 2021-09-19 | Humacao | Puerto Rico | 72069 | 2958 | |
1719582 | 1719582 | 2021-09-15 | Elbert | Georgia | 13105 | 2958 | 79 |
1710772 | 1710772 | 2021-09-12 | Meeker | Minnesota | 27093 | 2958 | 46 |
1707525 | 1707525 | 2021-09-11 | Meeker | Minnesota | 27093 | 2958 | 46 |
1704278 | 1704278 | 2021-09-10 | Meeker | Minnesota | 27093 | 2958 | 46 |
1702839 | 1702839 | 2021-09-09 | Kewaunee | Wisconsin | 55061 | 2958 | 39 |
1692454 | 1692454 | 2021-09-06 | Crockett | Tennessee | 47033 | 2958 | 54 |
1689205 | 1689205 | 2021-09-05 | Crockett | Tennessee | 47033 | 2958 | 54 |
1685955 | 1685955 | 2021-09-04 | Crockett | Tennessee | 47033 | 2958 | 54 |
1682704 | 1682704 | 2021-09-03 | Crockett | Tennessee | 47033 | 2958 | 54 |
1678772 | 1678772 | 2021-09-02 | Franklin | New York | 36033 | 2958 | 13 |
1669036 | 1669036 | 2021-08-30 | Lewis | New York | 36049 | 2958 | 36 |
1666512 | 1666512 | 2021-08-29 | Morgan | Tennessee | 47129 | 2958 | 41 |
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);