ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
251 rows where cases = 1824 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 25
- Georgia 17
- Tennessee 16
- Illinois 15
- Kentucky 13
- Iowa 12
- Minnesota 12
- Mississippi 11
- Puerto Rico 11
- Virginia 11
- Indiana 10
- Oklahoma 10
- Utah 7
- Arkansas 6
- Nebraska 6
- Alabama 5
- Missouri 5
- North Dakota 5
- Colorado 4
- Idaho 4
- Michigan 4
- West Virginia 4
- Montana 3
- North Carolina 3
- Ohio 3
- South Carolina 3
- Wisconsin 3
- California 2
- Louisiana 2
- Maryland 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2486823 | 2486823 | 2022-05-09 | Lake | Colorado | 8065 | 1824 | 2 |
2470000 | 2470000 | 2022-05-03 | Lancaster | Virginia | 51103 | 1824 | 31 |
2293027 | 2293027 | 2022-03-10 | Wayne | Nebraska | 31179 | 1824 | 11 |
2274568 | 2274568 | 2022-03-04 | Rains | Texas | 48379 | 1824 | 57 |
2269785 | 2269785 | 2022-03-03 | Lake | Michigan | 26085 | 1824 | 35 |
2271315 | 2271315 | 2022-03-03 | Rains | Texas | 48379 | 1824 | 57 |
2266532 | 2266532 | 2022-03-02 | Lake | Michigan | 26085 | 1824 | 35 |
2268063 | 2268063 | 2022-03-02 | Rains | Texas | 48379 | 1824 | 57 |
2264810 | 2264810 | 2022-03-01 | Rains | Texas | 48379 | 1824 | 57 |
2238667 | 2238667 | 2022-02-21 | Crosby | Texas | 48107 | 1824 | 45 |
2224075 | 2224075 | 2022-02-17 | Nicholas | Kentucky | 21181 | 1824 | 29 |
2196950 | 2196950 | 2022-02-08 | Johnson | Wyoming | 56019 | 1824 | 18 |
2166121 | 2166121 | 2022-01-30 | Cheyenne | Nebraska | 31033 | 1824 | 22 |
2162866 | 2162866 | 2022-01-29 | Cheyenne | Nebraska | 31033 | 1824 | 22 |
2159611 | 2159611 | 2022-01-28 | Cheyenne | Nebraska | 31033 | 1824 | 22 |
2154422 | 2154422 | 2022-01-26 | Madison | Virginia | 51113 | 1824 | 27 |
2149551 | 2149551 | 2022-01-25 | Pipestone | Minnesota | 27117 | 1824 | 31 |
2146532 | 2146532 | 2022-01-24 | Carbon | Montana | 30009 | 1824 | 27 |
2129276 | 2129276 | 2022-01-19 | Hamilton | Illinois | 17065 | 1824 | 29 |
2112272 | 2112272 | 2022-01-13 | Ritchie | West Virginia | 54085 | 1824 | 26 |
2080898 | 2080898 | 2022-01-04 | Edmonson | Kentucky | 21061 | 1824 | 34 |
2057276 | 2057276 | 2021-12-28 | Pike | Arkansas | 5109 | 1824 | 39 |
2054440 | 2054440 | 2021-12-27 | Franklin | Idaho | 16041 | 1824 | 26 |
2020456 | 2020456 | 2021-12-16 | Camuy | Puerto Rico | 72027 | 1824 | |
1996420 | 1996420 | 2021-12-09 | Lee | Kentucky | 21129 | 1824 | 39 |
1992632 | 1992632 | 2021-12-08 | Towns | Georgia | 13281 | 1824 | 84 |
1978995 | 1978995 | 2021-12-03 | Roane | West Virginia | 54087 | 1824 | 25 |
1966965 | 1966965 | 2021-11-30 | Mitchell | Iowa | 19131 | 1824 | 43 |
1963365 | 1963365 | 2021-11-29 | Screven | Georgia | 13251 | 1824 | 62 |
1963713 | 1963713 | 2021-11-29 | Mitchell | Iowa | 19131 | 1824 | 43 |
1964609 | 1964609 | 2021-11-29 | Unknown | Nebraska | 1824 | 236 | |
1960462 | 1960462 | 2021-11-28 | Mitchell | Iowa | 19131 | 1824 | 43 |
1957211 | 1957211 | 2021-11-27 | Mitchell | Iowa | 19131 | 1824 | 43 |
1953960 | 1953960 | 2021-11-26 | Mitchell | Iowa | 19131 | 1824 | 43 |
1950709 | 1950709 | 2021-11-25 | Mitchell | Iowa | 19131 | 1824 | 43 |
1947458 | 1947458 | 2021-11-24 | Mitchell | Iowa | 19131 | 1824 | 43 |
1929127 | 1929127 | 2021-11-18 | Mercer | North Dakota | 38057 | 1824 | 17 |
1902785 | 1902785 | 2021-11-10 | Colfax | Nebraska | 31037 | 1824 | 22 |
1904038 | 1904038 | 2021-11-10 | Brunswick | Virginia | 51025 | 1824 | 33 |
1897538 | 1897538 | 2021-11-08 | Brunswick | Virginia | 51025 | 1824 | 32 |
1864757 | 1864757 | 2021-10-29 | Callahan | Texas | 48059 | 1824 | 55 |
1849378 | 1849378 | 2021-10-25 | Gunnison | Colorado | 8051 | 1824 | 12 |
1847864 | 1847864 | 2021-10-24 | Barnes | North Dakota | 38003 | 1824 | 33 |
1844614 | 1844614 | 2021-10-23 | Barnes | North Dakota | 38003 | 1824 | 33 |
1834187 | 1834187 | 2021-10-20 | Aitkin | Minnesota | 27001 | 1824 | 43 |
1831167 | 1831167 | 2021-10-19 | Linn | Missouri | 29115 | 1824 | 26 |
1828931 | 1828931 | 2021-10-18 | Houston | Tennessee | 47083 | 1824 | 43 |
1804056 | 1804056 | 2021-10-11 | Early | Georgia | 13099 | 1824 | 57 |
1800807 | 1800807 | 2021-10-10 | Early | Georgia | 13099 | 1824 | 57 |
1797558 | 1797558 | 2021-10-09 | Early | Georgia | 13099 | 1824 | 57 |
1794309 | 1794309 | 2021-10-08 | Early | Georgia | 13099 | 1824 | 57 |
1787453 | 1787453 | 2021-10-06 | Kusilvak Census Area | Alaska | 2158 | 1824 | 6 |
1785210 | 1785210 | 2021-10-05 | Metcalfe | Kentucky | 21169 | 1824 | 37 |
1768988 | 1768988 | 2021-09-30 | Trigg | Kentucky | 21221 | 1824 | 20 |
1755955 | 1755955 | 2021-09-26 | Lyon | Kentucky | 21143 | 1824 | 25 |
1752707 | 1752707 | 2021-09-25 | Lyon | Kentucky | 21143 | 1824 | 25 |
1749458 | 1749458 | 2021-09-24 | Lyon | Kentucky | 21143 | 1824 | 25 |
1746792 | 1746792 | 2021-09-23 | Roosevelt | Montana | 30085 | 1824 | 57 |
1735060 | 1735060 | 2021-09-19 | Windham | Vermont | 50025 | 1824 | 22 |
1723423 | 1723423 | 2021-09-16 | Estill | Kentucky | 21065 | 1824 | 12 |
1718464 | 1718464 | 2021-09-14 | Jackson | Tennessee | 47087 | 1824 | 37 |
1700902 | 1700902 | 2021-09-09 | Antrim | Michigan | 26009 | 1824 | 33 |
1702006 | 1702006 | 2021-09-09 | Cidra | Puerto Rico | 72041 | 1824 | |
1688129 | 1688129 | 2021-09-05 | Perry | Mississippi | 28111 | 1824 | 45 |
1684879 | 1684879 | 2021-09-04 | Perry | Mississippi | 28111 | 1824 | 45 |
1681628 | 1681628 | 2021-09-03 | Perry | Mississippi | 28111 | 1824 | 45 |
1676004 | 1676004 | 2021-09-01 | Cabo Rojo | Puerto Rico | 72023 | 1824 | |
1670013 | 1670013 | 2021-08-30 | Terry | Texas | 48445 | 1824 | 58 |
1666766 | 1666766 | 2021-08-29 | Terry | Texas | 48445 | 1824 | 58 |
1663518 | 1663518 | 2021-08-28 | Terry | Texas | 48445 | 1824 | 58 |
1660270 | 1660270 | 2021-08-27 | Terry | Texas | 48445 | 1824 | 58 |
1643731 | 1643731 | 2021-08-22 | Decatur | Tennessee | 47039 | 1824 | 39 |
1640481 | 1640481 | 2021-08-21 | Decatur | Tennessee | 47039 | 1824 | 39 |
1637231 | 1637231 | 2021-08-20 | Decatur | Tennessee | 47039 | 1824 | 39 |
1630446 | 1630446 | 2021-08-18 | Wasco | Oregon | 41065 | 1824 | 36 |
1622094 | 1622094 | 2021-08-16 | Bleckley | Georgia | 13023 | 1824 | 52 |
1624270 | 1624270 | 2021-08-16 | Lewis | Tennessee | 47101 | 1824 | 28 |
1611864 | 1611864 | 2021-08-12 | Crawford | Wisconsin | 55023 | 1824 | 19 |
1602017 | 1602017 | 2021-08-09 | Clallam | Washington | 53009 | 1824 | 16 |
1587036 | 1587036 | 2021-08-05 | Mason | Kentucky | 21161 | 1824 | 40 |
1585350 | 1585350 | 2021-08-04 | Bosque | Texas | 48035 | 1824 | 38 |
1585663 | 1585663 | 2021-08-04 | Colonial Heights city | Virginia | 51570 | 1824 | 60 |
1563897 | 1563897 | 2021-07-29 | Richland | Illinois | 17159 | 1824 | 49 |
1558925 | 1558925 | 2021-07-27 | Okfuskee | Oklahoma | 40107 | 1824 | 32 |
1554956 | 1554956 | 2021-07-26 | Tallahatchie | Mississippi | 28135 | 1824 | 42 |
1555678 | 1555678 | 2021-07-26 | Okfuskee | Oklahoma | 40107 | 1824 | 32 |
1550737 | 1550737 | 2021-07-25 | Rabun | Georgia | 13241 | 1824 | 51 |
1552224 | 1552224 | 2021-07-25 | Warren | North Carolina | 37185 | 1824 | 20 |
1552431 | 1552431 | 2021-07-25 | Okfuskee | Oklahoma | 40107 | 1824 | 32 |
1552896 | 1552896 | 2021-07-25 | Colorado | Texas | 48089 | 1824 | 33 |
1547490 | 1547490 | 2021-07-24 | Rabun | Georgia | 13241 | 1824 | 51 |
1548977 | 1548977 | 2021-07-24 | Warren | North Carolina | 37185 | 1824 | 20 |
1549184 | 1549184 | 2021-07-24 | Okfuskee | Oklahoma | 40107 | 1824 | 32 |
1544243 | 1544243 | 2021-07-23 | Rabun | Georgia | 13241 | 1824 | 51 |
1545730 | 1545730 | 2021-07-23 | Warren | North Carolina | 37185 | 1824 | 20 |
1545937 | 1545937 | 2021-07-23 | Okfuskee | Oklahoma | 40107 | 1824 | 32 |
1542690 | 1542690 | 2021-07-22 | Okfuskee | Oklahoma | 40107 | 1824 | 32 |
1539442 | 1539442 | 2021-07-21 | Okfuskee | Oklahoma | 40107 | 1824 | 32 |
1514628 | 1514628 | 2021-07-14 | Clay | Arkansas | 5021 | 1824 | 52 |
1489371 | 1489371 | 2021-07-06 | Hamilton | Iowa | 19079 | 1824 | 51 |
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);